|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
EOF/BOF problem |
|
From: |
Honna |
|
Date: |
2/16/1999 11:51:07 AM |
|
IP: |
138.87.13.205 |
I am trying to do different formating for different types of records. I have a "type" field in my
database table, which is the distinguishing criterion. I use "if" statement to select a certain
type of records. Alltogether I have 15 if statements. My code is as follows:
----------------------------------------------------------------
<%Query="select * from table1 inner join table2 on table1.key=table2.key "
Query = Query & "where table1key=" & key & ""
set Class=Connect.Execute(Query)
if (Class.eof=false and Class.bof=false) then
if Trim(Class("Type"))="type1" then%>
<some html statements>
<%end iff%>
...
if Trim(Class("Type"))="typelast" then%>
<some html statements>
<%end if%>
<%end if%>
--------------------------------------------------------------------
The problem I have is that only the records of "typelast" (which is stated in the last "if" statement)
showed up. When I tried my code other other types of records (whose types are stated in "if"
statements before the last "if" statement), the browser said
"ADODB.Field error 800a0bcd
Either BOF or EOF is True, or the current record has been deleted; the operation
requested by the application requires a current record."
What shall I do to fix the problem? Please help me and thank you.
p.s. I have checked that the following things are true:
1. there are records in the recordset
2. recordset.cursorlocation is found to be 2
3. all types (type1 through typelast) have corresponding records
Thanks again. |
Follow Up - Re: EOF/BOF problem - harlan 2/16/1999 3:56:55 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
