Server error: Unable to retrieve schema information from the query:

[msnews.microsoft.com]

I am sending some hidden fieldvalues to a dbresultpage made with DBW in FP
2003. The query in the resultpage is like this

SELECT * FROM kalreg WHERE ((Request.QueryString("manad") = 'manad') AND
(Request.QueryString("ar")= 'ar'))

The hyperlink I send is:
<a target="I2" href="manadslista.asp?ar=2004&manad=10">

and the errormessages I get is:

Server error: Unable to retrieve schema information from the query:

SELECT * FROM kalreg WHERE ((Request.QueryString("manad") = 'manad') AND
(Request.QueryString("ar")= 'ar'))

against a database using the connection string
DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=kalender4/fpdb/kalender.mdb.
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.

Is there anyone have an idea of what I am doing wrong
I appreciate any answer
Ted

 

[Ted]

Sorry
The information about sender was wrong I hope it is ok now
/Ted

 

[Jon Spivey]

Hi Ted,

I think you want a custom query (wizard step 2) along these lines.
SELECT * FROM kalreg
WHERE Manad = '::manad::' AND ar = '::ar::'

 

[Ted]

Thanks Jon !!!
This work
Ted

Hi Ted,

I think you want a custom query (wizard step 2) along these lines.
SELECT * FROM kalreg
WHERE Manad = '::manad::' AND ar = '::ar::'