Dreamweaver - a little help please

Author

a little help please - recordsets

dprulhiere

2004-04-02, 5:37 pm

Using DWMX, I am trying to create a login page that transfers you to a login
welcome page. On the login page i would like to display results from multiple
tables, but only the information for that user. for example, john doe logs in
and on the welcome page it would show his login data. the fist recordset would
be rsLogin off of my Access Table "login" and it would show the following...
USERNAME = JOHN DOE
CLEARANCE = CUSTOMER
then I would like to show his last order info from the second table in my
Access DB named "orders" . If I create a second recordset called "rsOrders"
the try to drag over the dynamic data i get the following error...
[b] ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has
been deleted. Requested operation requires a current record. [/b]

I have the two tables joined with a one to many relationship and am using
LoginID as the numeric field for the relationship. in the recordset I have the
filter on to LoginID = URL param LoginID and none for the sort.

Lastly, I am able to view the dynamic data from recordset rsLogin with no
problems but when it gets to the rsOrders recordset it gives the above error,
and I do have data in the table that is causing the error.

If I can be helped please do.

Thak you

Randy Edmunds

2004-04-02, 10:32 pm

If you have a join that is filtered with a query param, then you'll have
at least 2 expressions in the WHERE clause, correct? This is a bit of
a long shot, but something similar happened to me recently -- try
changing the order of the clauses.

HTH,
Randy

> I have the two tables joined with a one to many relationship and am using
> LoginID as the numeric field for the relationship. in the recordset I have the
> filter on to LoginID = URL param LoginID and none for the sort.
>
> Lastly, I am able to view the dynamic data from recordset rsLogin with no
> problems but when it gets to the rsOrders recordset it gives the above error,
> and I do have data in the table that is causing the error.