从经典ASP VBScript调用MySQL存储过程 [英] Calling MySQL Stored Procedures from Classic ASP VBScript

问题描述

大家好，我正在尝试在这里解决问题.我有一个MySQL数据库，该数据库具有一个存储过程，该存储过程采用xml数据流并将记录解析为块.从PHPMyADMIN或从命令行运行时，存储的proc可以正常工作.但是，当我尝试使用适用于我所做的所有其他查询的VBScript调用从ASP页执行存储过程时，就会出现问题.这是我的代码...让我知道什么地方有问题:

Hello everyone, I'm trying to figure something out here.  I have a MySQL database that has a stored procedure that takes an xml stream of data and parses the records into blocks. The stored proc works fine when run from PHPMyADMIN or from command line. However, the problem comes in when I try to execute the stored procedure from an ASP page using a VBScript call which works for all other queries I do. Here is my code...let me know if anything is wrong:

<!-- #include file="conn.asp" -->
<%
SQLStmt = "call parseit();"
conn.execute(SQLStmt)
%>

它不会返回错误，但也不会执行任何操作.我真的为此感到难过...任何帮助将不胜感激！

It doesn't return an error but it doesn't do anything either. I'm really stumped by this one...any help would be most appreciated!

推荐答案

ASP.NET论坛: http://www.microsoft.com/communities/newsgroups/list/zh-cn/default.aspx?dg=microsoft.public.scripting .vbscript

kaymaf

ASP.NET forum : http://forums.asp.net/
 VBScript : http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.scripting.vbscript

kaymaf

这篇关于从经典ASP VBScript调用MySQL存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！