I have created a query in access and want to use it in a select statement in my asp code.
I tried to simply do:
select * from query
and it comes back with an error that it could not find the table/query
The whole reason for doing this is because I cannot seem to find the reason why I get an error on the following code
sqlstr = "SELECT * FROM nanny inner join references on nanny.id = references.id"
sqlstr = sqlstr & " WHERE nanny.id = " & request("id"
The error says something is wrong with my from statement.
I tried to simply do:
select * from query
and it comes back with an error that it could not find the table/query
The whole reason for doing this is because I cannot seem to find the reason why I get an error on the following code
sqlstr = "SELECT * FROM nanny inner join references on nanny.id = references.id"
sqlstr = sqlstr & " WHERE nanny.id = " & request("id"
The error says something is wrong with my from statement.