[thelist] SQL INSERT Trouble...

Webmaster webmaster at archetype-it.com
Mon Feb 25 02:24:14 CST 2002


At 09:41 24/02/2002 -0500, you wrote:
>Doh. I'm a moron.  The database didn't have correct read / write
>permissions.  Sorry to waste your time!

There's another thing though Adam. This line:

set signedup=conn.execute(SQL)

creates a recordset. You don't need to do that for an insert statement,
since you are not returning any data. Save server resources by changing it to:

conn.execute(SQL)

Regards

--
Veronica Yuill
Moderator, I-Design http://www.adventive.com/lists/idesign/summary.html




More information about the thelist mailing list