Can't INSERT into database's table !

kanenas.net · August 3rd, 2006, 03:39 AM

Hi everyone !!!
The past two days I am trying to make a survey to work !
Unfortunately I haven't accomplised yet :-(

So this is my problem...
I am using ASP, MS-SQL for the survey.
When I take the survey for the first time evetything is working and the fields are inserted correctly in the table !
If I take the survey for the second time... there is no insert in the table !!!

This is code...

Code:

dim Rs_Qu
      set Rs_Qu = myCon.Execute("Select * From QUESTION ")
      if Rs_Qu.Eof then
         myCon.Execute ("Insert into QUESTION (" & SqlStr_1 & ") values (" & SqlStr_2 & ")")

Also, I must tell you that when I use the SQL Pane and do ...

Code:

Insert into QUESTION (" & SqlStr_1 & ") values (" & SqlStr_2 & ")

replacing of course " & SqlStr_1 & " and " & SqlStr_2 & "
i can insert the entry !!!

Please help !

Visit...
http://www.kanenas.net
News and Ideas about programming

prabodh_mishra · August 10th, 2006, 05:56 AM

I wonder why u have put up statement like "if Rs_Qu.Eof then".
It will only allow you to insert record when table is empty i.e. first time. Any subsequent request will be declined.

kanenas.net · August 10th, 2006, 07:37 AM

Yes I know ! I have figured it out !!!
I am so sorry I forgot to make a post...
:-(

Visit...
http://www.kanenas.net
News and Ideas about programming