...

View Full Version : strange problem -- string not being set properly



esthera
01-02-2007, 01:02 PM
i have the following coe

sql= "select * from items where [expirydate]<CONVERT(datetime, '" & mydate & "', 101)"

response.write sql


when i right out the sql it's ignoring everything after [expirydate]
it's very strange - it's not writing it out or passing it to my query.

any ideas what could be happening?

mehere
01-02-2007, 02:45 PM
put a space before and after the less than sign

sql= "select * from items where [expirydate] < CONVERT(datetime, '" & mydate & "', 101)"



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum