dang
Posts: 11
|
Posted: 03/16/2008, 12:25 AM |
|
Hi
I'm trying to do a simple action: Call a stored procedure on a MySql database using asp.
I cannot use Triggers's database. It would be too easy i guess.
So, here what I did (without any success)
dim cnn
set cnn = new clsDBmydbl
cnn.open
cnn.execute("UPDATE param_class SET lastupd = Now()")
cnn.execute ("EXEC update_classement")
cnn.close
set cnn = nothing
The first Execute work well...
The second do nothing. I change the EXEC with CALL, no success.
If anyone could tell me what I'm doing wrong here. I would appreciate very much
_________________
Dan |
|
|
marcwolf
Posts: 361
|
Posted: 05/19/2008, 11:33 PM |
|
Hi Dan
I am investigating the same things however that I have used them within and MSAccess module
I will try and post some code here late
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
wkempees
Posts: 1679
|
Posted: 05/20/2008, 1:02 AM |
|
Might be stupid answer or totally irrelevant......but,
is your Version of MySQL, is supporting stored procedures? (5+)
a way to get right syntax, might be to just create a dummy form and in its VQB declare type PROCEDURE, steal syntax from generated form...
I just notice some declaration difference in the help as to exec() returning recordset or not returning recordset.
HTH
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|