CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 SQL Query

Print topic Send  topic

Author Message
duplo1

Posts: 67
Posted: 08/30/2006, 5:27 PM

I wrote a SQL Server Query for an ASP Application (CCS 3.X). As long as there are matching records everything is fine. But as soon as I do not get any matching records I get the following error message:

ADODB.Recordset error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/intranet/Classes.asp, line 3190

What do I have to do to solve this problem ???

Please help.

Christoph
View profile  Send private message
Christoph
Posted: 08/31/2006, 6:02 AM

Thank YOU

How would I have to code it to get NULL back instead of the error message ??

If I run the SQL query within Codecharge no records will be displayed if there are not matching records. But if I go live I get the error message.

I understand now that I have to write a code. CAN YOU or somebody else help me with that ?

Christoph
peterr


Posts: 5971
Posted: 08/31/2006, 10:59 AM

You shouldn't need to do anything. How does your SQL look like?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.