Chris Moore
|
Posted: 07/23/2003, 2:22 PM |
|
I have a page that contains a record form. I have hidden the form because
I don't need it, I just needed the DB connection. In the Before Show
server event I have code to Insert a new record into a database. When
this page is loaded, it is inserting 2 records instead of just the one.
Any ideas on what causes this? Here is my code:
'==========================================================
Dim SQL
SQL = "INSERT INTO orders (email_address, name, data_format, sql_string,
paid) "&_
"VALUES ('"& Session("sessionEmail") & "','" & Session("sessionUserName")
& "','" & Session("sessionDataFormat") & "',""" & Session("sessionSQL") &
""", 1)"
DBOrdersList.Execute SQL
'==========================================================
Thanks
Chris
|
|
|
|