Getting #'s into SQL Strings 1

[NOPOPNOSTYLE]

Hello

I'm using Dreamweaver MX and I'm trying to asses an access database using a date between query, below is the result so far, this only works if I type a date flanked by the # character in the Form. Can I modify the code below to put the #'s in. (TIMM_ONE Refers to the Request.Form bit as does TIMM_TWO)

TIMM.Source = "SELECT * FROM OPS_EXTRACT WHERE DATE Between " + Replace(TIMM__ONE, "'", "''&quot + " And " + Replace(TIMM__TWO, "'", "''&quot + " ORDER BY DATE ASC"

Regards

Lord Exell

 

[Tarwn]

...
"SELECT * FROM OPS_EXTRACT WHERE DATE Between #" + Replace(TIMM__ONE, "'", "''&quot + "# And #" + Replace(TIMM__TWO, "'", "''&quot + "# ORDER BY DATE ASC"

like that?


_{01010100 01101001 01100101 01110010 01101110 01101111 01101011 00101110 01100011 01101111 01101101}
^{29 3K 10 3D 3L 3J 3K 10 32 35 10 3E 39 33 35 10 3K 3F 10 38 31 3M 35 10 36 3I 35 35 10 3K 39 3D 35 10 1Q 19}
Do you know how hot your home computer is? I do:

http://www.tiernok.com/hscripts/systemp.asp

 

[NOPOPNOSTYLE]

Tarwn

Many thanks, your solution worked a treat, simple when your know how, I was trying to overcomplicate the situation.

Hurrah

Lord Exell