dnb
|
| Posted: 02/19/2003, 10:35 PM |
|
Hi All,
I am using 1.07 and have build a new page and use the grid builder to
display a grid. The search field is a drop down of a secondary key to
another table ie.
Table 1
ID ID2 Description
1 101 my name
2 102 yourname
Table 2
ID2 something
ID3 something else
etc
When I use the search from the drop down, I get an error
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.
Classes.asp, line 1631
What seems to be happening is that there are no records matching and so the
error is displayed. I dont understand why. I have other grids that just
return a "No Records" message which is what I would expect when there are no
matching records.
I checked the SQL on the Data Source and it is set to "SELECT *
FROM Table1
WHERE id2 = {s_id2}"
The control is called s_id2.
I'm stumped and annoyed. I have built a few grids and this hasn't happened
before.
Can any offer anything I should check ?
Thanks
David
|
|
|
 |
BJ Freeman
|
| Posted: 02/22/2003, 12:14 AM |
|
when a where clause is used with strings the single quote must wrap the
variable.
so
WHERE id2 = {s_id2}
should be
WHERE id2 = '"+{s_id2}+"'" now so you can see what I did I will blow it up.
WHERE id2 = ' "+{s_id2}+" ' " <--- don't put the spaces in like I did here.
this is just for clarity
"dnb" <dnb@anysurvey.com.au> wrote in message
news:b31svv$jt0$1@news.codecharge.com...
> Hi All,
>
> I am using 1.07 and have build a new page and use the grid builder to
> display a grid. The search field is a drop down of a secondary key to
> another table ie.
>
> Table 1
> ID ID2 Description
> 1 101 my name
> 2 102 yourname
>
> Table 2
> ID2 something
> ID3 something else
> etc
>
> When I use the search from the drop down, I get an error
> Error Type:
> ADODB.Field (0x800A0BCD)
> Either BOF or EOF is True, or the current record has been deleted.
Requested
> operation requires a current record.
> Classes.asp, line 1631
>
> What seems to be happening is that there are no records matching and so
the
> error is displayed. I dont understand why. I have other grids that just
> return a "No Records" message which is what I would expect when there are
no
> matching records.
>
> I checked the SQL on the Data Source and it is set to "SELECT *
> FROM Table1
> WHERE id2 = {s_id2}"
>
> The control is called s_id2.
>
> I'm stumped and annoyed. I have built a few grids and this hasn't happened
> before.
>
> Can any offer anything I should check ?
>
> Thanks
>
> David
>
>
|
|
|
|
DAVID
|
| Posted: 02/25/2003, 9:45 AM |
|
I'd just do WHERE id2 = '{s_id2}'
"BJ Freeman" <spam_blockbfree@free-man.com> wrote in message
news:b37bhr$49j$1@news.codecharge.com...
> when a where clause is used with strings the single quote must wrap the
> variable.
>
> so
> WHERE id2 = {s_id2}
> should be
> WHERE id2 = '"+{s_id2}+"'" now so you can see what I did I will blow it
up.
> WHERE id2 = ' "+{s_id2}+" ' " <--- don't put the spaces in like I did
here.
> this is just for clarity
>
> "dnb" <dnb@anysurvey.com.au> wrote in message
>news:b31svv$jt0$1@news.codecharge.com...
> > Hi All,
> >
> > I am using 1.07 and have build a new page and use the grid builder to
> > display a grid. The search field is a drop down of a secondary key to
> > another table ie.
> >
> > Table 1
> > ID ID2 Description
> > 1 101 my name
> > 2 102 yourname
> >
> > Table 2
> > ID2 something
> > ID3 something else
> > etc
> >
> > When I use the search from the drop down, I get an error
> > Error Type:
> > ADODB.Field (0x800A0BCD)
> > Either BOF or EOF is True, or the current record has been deleted.
> Requested
> > operation requires a current record.
> > Classes.asp, line 1631
> >
> > What seems to be happening is that there are no records matching and so
> the
> > error is displayed. I dont understand why. I have other grids that just
> > return a "No Records" message which is what I would expect when there
are
> no
> > matching records.
> >
> > I checked the SQL on the Data Source and it is set to "SELECT *
> > FROM Table1
> > WHERE id2 = {s_id2}"
> >
> > The control is called s_id2.
> >
> > I'm stumped and annoyed. I have built a few grids and this hasn't
happened
> > before.
> >
> > Can any offer anything I should check ?
> >
> > Thanks
> >
> > David
> >
> >
>
>
|
|
|
|
|
