Webcat & MySQL Stored Procedures question -again
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63650
interpreted = N
texte = I know I have asked this before, no response. But does anyone know if webcat 6 can call/return a record set via stored procedures? My sql commands work fine, but won't work when I try calling the same statement via a stored procedure, which leads me to believe that the current release of webcat doesn't support stored procedures. A simple yes or no will do if you know.This is the error I get:ERROR: SQL COMMAND FAILED.COMMAND TEXT: call getMail('Test101');ERROR TEXT: PROCEDURE conscious1.getMail can't return a result set in the given context ERROR: COULD NOT FIND SQLRESULT "rs1".Thanks in advance.-Adam O-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I know I have asked this before, no response. But does anyone know if webcat 6 can call/return a record set via stored procedures? My sql commands work fine, but won't work when I try calling the same statement via a stored procedure, which leads me to believe that the current release of webcat doesn't support stored procedures. A simple yes or no will do if you know.This is the error I get:ERROR: SQL COMMAND FAILED.COMMAND TEXT: call getMail('Test101');ERROR TEXT: PROCEDURE conscious1.getMail can't return a result set in the given context ERROR: COULD NOT FIND SQLRESULT "rs1".Thanks in advance.-Adam O-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Adam O'Connor"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
webcat restarting script on Linux? (1999)
F3 crashing server (1997)
security problem (1997)
Formulas.db + Users.db (1997)
Store Example to Use (1998)
Multiple prices (1997)
syntax question, not in online refernce (1997)
apparent variable variable display? (2000)
Problems getting parameters passed into email. (1997)
Running _every_ page through WebCat ? (1997)
access denied problem (1997)
RE: Formulas.db + Users.db (1997)
authorize.net hex coded variables (2002)
Searching Relational Databases (2004)
Encrypt/Decrypt (2007)
I need to get a [grep] (2003)
off topic - dna snipets (1997)
passing cart value (2003)
Merging databases (1997)
Showif Or (2000)