Re: Speaking of mysql... sqlexecute question

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 63771
interpreted = N
texte = I may be wrong but it seems like I had to create new recordsets/connections when using multiple commands. I would try something simple such as insert then select, see if this results in an error. -Adam Phil Herring wrote: >In the sqlexecute context... If I'm using inserts and updates (as opposed to >selects) can one sqlexecute context accommodate multiple mysql commands? > >Or is it one mysql command per sqlexecute context? > >Trying to figure out why my the mysql block I wrote is killing my webdna >process... :0 > >Thanks! > > > > >------------------------------------------------------------- >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/ > > ------------------------------------------------------------- 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:

    
  1. Re: Speaking of mysql... sqlexecute question ( "Adam O'Connor" 2006)
  2. Speaking of mysql... sqlexecute question ( Phil Herring 2006)
I may be wrong but it seems like I had to create new recordsets/connections when using multiple commands. I would try something simple such as insert then select, see if this results in an error. -Adam Phil Herring wrote: >In the sqlexecute context... If I'm using inserts and updates (as opposed to >selects) can one sqlexecute context accommodate multiple mysql commands? > >Or is it one mysql command per sqlexecute context? > >Trying to figure out why my the mysql block I wrote is killing my webdna >process... :0 > >Thanks! > > > > >------------------------------------------------------------- >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/ > > ------------------------------------------------------------- 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:

Sorting (2000) HideIf ip= OR ip (1998) using listfiles to build a database? more (2000) Return records from another (1997) [WebDNA] inputed text getting scrambled up in DB (2012) Frames and WebCat (1997) A few questions. . . (1997) WebCat2 - [format thousands] (1997) Sending Mail Confirmation (2002) [ShowCart] and GET vs. POST (1997) Cart# (1997) Bug? (1997) Configuring E-mail (1997) member logins database (2003) Share Bulletin Board? (1998) Can't use old cart file (was One more try) (1997) 5.0 Preview Promotion Extension (2003) Shipcost lookup? (1997) embedding commands in form (1999) Progress !! WAS: Trouble with formula.db (1997)