ASP.NET Forum

**tcb** · 10-11-2005, 04:33 AM

Hello,

How can I check if data exists in database?

tcb.

**robsmith** · 10-11-2005, 07:31 PM

If you want to know if a record exists, go here:

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=106

**tcb** · 10-12-2005, 04:35 AM

Hello Robsmith,

I tried the code from the site you've indicated, but an error occurs on the following line:

Set rs = db.Execute(sSQL)

Here is the error:

[Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

tcb.

**WebcyteDesign** · 10-17-2005, 11:32 PM

Have you changed the querystring and connection string to point to your database?

**tcb** · 10-18-2005, 08:19 AM

Yes. But now I am using some IFs outside the SQL statement. And the problem with the "Set rs = db.Execute(sSQL)" line is not occuring anymore.
Thanks anyway.

tcb.

**pjb007** · 10-21-2005, 01:48 PM

http://www.codefixer.com/ is an excellent website.

I think that this page may help with what you want to to.
http://www.codefixer.com/tutorials/n...s_returned.asp