[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