Correct SQL WebDNA Syntax
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61450
interpreted = N
texte = Hi Everyone I am just venturing into the world of MySQL/WebDNA, I have got it all working I just want to check that I am following the correct procedure. I use an SQLConnect command then SQLExecute, then use an SQLResult tag. All seems to work fine. If I need to get a different set of records from the same SQL db is it ok if I just perform another SQLExecute/SQLResult or does the connection timeout etc? Should I be repeating the SQLConnect? Also should I be issuing an SQLDisconnect anywhere or does it do it automatically? What I've done is working I just want to check I'm not leaving an ever increasing number of connections open etc. Thanks for any help. Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== ------------------------------------------------------------- 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:
| |
- Correct SQL WebDNA Syntax ( Steve Craig 2005)
|
Hi Everyone I am just venturing into the world of MySQL/WebDNA, I have got it all working I just want to check that I am following the correct procedure. I use an SQLConnect command then SQLExecute, then use an SQLResult tag. All seems to work fine. If I need to get a different set of records from the same SQL db is it ok if I just perform another SQLExecute/SQLResult or does the connection timeout etc? Should I be repeating the SQLConnect? Also should I be issuing an SQLDisconnect anywhere or does it do it automatically? What I've done is working I just want to check I'm not leaving an ever increasing number of connections open etc. Thanks for any help. Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== ------------------------------------------------------------- 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/
Steve Craig
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:
text size limitation (1997)
Multiple catalog databases and showcart (1997)
select multiple 2 more cents (1997)
WebMerchant when CC network is down (1998)
Emailer [cart] file names (1997)
Surprise x and y post args (1998)
OT: How to convert TIFs into HTML or ASCII format? (2002)
Mac GUI editors (1997)
This Code Kills My WebCatalog Dead (2003)
emailer (1997)
Multiple prices (1997)
Authentication Box (2000)
PIXO Support (1997)
Can someone remove this guy with the 186k emails!? (Thanks for the email!) (1998)
[WebDNA] Friday Fun with Variable Names (2017)
$append (1998)
SiteGuard Use Question (1997)
HTML file size limit (1998)
[protect admin] (1997)
Help name our technology! I found it (1997)