[thelist] SQL INSERT Trouble...

Webmaster thelist at lists.evolt.org
Mon Feb 25 02:24:14 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