why is it when i Request.QueryString a field of datatype Date/Time i always get a datatype mismatch error? even if my default value in DWMX is in the same format as the value in my table?

if the field is Text or Number my method works just fine.

thanks


Win2k|IIS5|Access2000

send me the code and ill take a look.

Doc
Rangewalk Digital Studios

sorry it took so long to get back, get busy on another project!

Ok, i am passing a url parameter to a page. on this target page i have a recordset that grabs that url parameter thru an SQL variable.

SELECT * from Jobs
WHERE JobID ='jn'

in the DWMX Advanced dialog for my recordset i created an SQL variable called, 'jn'. like so,

jn 1 Request.QueryString("id"

jn is the name, 1 is the default value, and Req... is the run-time value.

when i use this same technique for other pages it works just fine. filters my recordset just peachy based on the variable. however, it doesn't work for this because the JobID column is a Number datatype. if i change it to Text, it works just fine.

i don't get it.

thanks for any help!

ok figured it out!

i removed the quotes around my variable and it works! my column is a number and with the quotes it interprets that as a string.

duhhhhhhhhhhh.........