Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 data saved twice without a reason

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-06 : 09:22:31
yong writes "Hi,

First of all, I'm so glad that I can find this site
which looks so professional about sql above all other sites.

I made a plain-jane asp script which saves data to SQL-Server
but When I run the script, the same record stored twice.
It works fine if I use different sql-server which is located
in our office.
Maybe there might be an misconfiguration to save duplicate data..
I don't know what to do about it.
Please help me.

Thank you

Yong

My Script is as follows

#include file=ODBC_con.inc


SQLStr = "Insert into Bidding (MemberCode, MercheCode, FirstDay, EditDay, Price, Status) values ("SQLStr = SQLStr & MemberCode & "," & MerCode_chip & ",'" & FirstDay & "',''," & PriceValue & "," & Status & ")"

DBCon.Execute(SQLStr)"
   

- Advertisement -