I don't know if any of you know how to do it but I'm trying to get the SQL
query pasted below to include the two dates, at the moment it doesn't return
data from the two dates specified. ie It returns queries starting Jan 02 and
ending 19 Feb....
:-(
SELECT DateAdded, EmailA
FROM eShot
WHERE ( DateAdded
BETWEEN '2001/Jan/01'
AND '2001/Feb/20' )
AND EmailA LIKE '%@%'
AND ConfCode LIKE '%cc0243%'
ORDER BY DateAdded
All I can say is: HELP!!!!
Any and all comments would be most gratefully appreciated.
-= Ed
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists