Code Forums - View Single Post

jeffro · 06-15-2005, 07:01 AM

No you really can't do it with a single query. You can string multiple queries together and execute them consecutively, then the commit will make the changes to the database. So you could do this:

Code:

Query
Query
Query
Query
Commit

Rather than this:

Code:

Query
Commit
Query
Commit
Query
Commit

06-15-2005, 07:01 AM	#2 (permalink)
jeffro Person of interest Join Date: Mar 2003 Location: New Jersey Posts: 102	No you really can't do it with a single query. You can string multiple queries together and execute them consecutively, then the commit will make the changes to the database. So you could do this: Code: Query Query Query Query Commit Rather than this: Code: Query Commit Query Commit Query Commit __________________ Jeffro Linux counter#:213782 GnuPG ID: 406238E7