0

i have to use like keyword in my query in ASP

while using it in analyzer i am getting the result but when i am using it on page i m not getting the result of a simple.

Qery is :

select checktime from checkinout where checktime like '*"&any_dt&"*'

any_dt is a date in mm/dd/yyyy format.

this is working fine in analyzer but not on ASP Page.

why is it happening i dont know.

Please help me out as soon as possible.

thanx a lot in advance.

3
Contributors
4
Replies
5
Views
9 Years
Discussion Span
Last Post by hmponline
0

hi,

There change your query with following query:

select checktime from checkinout where checktime like '%"&any_dt&"%'
0

hi,

There change your query with following query:

select checktime from checkinout where checktime like '%"&any_dt&"%'

I have already apllied tis too.
But it also is not working.

thanx for reply.

give some other solution if you can.

thanx again in advance

0

hi,

Try bellow code

select checktime from checkinout where checktime like '#"&any_dt&"#'

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.