Hi guys I have this query:
Select count(searchid) as searches from tblsearchlog where (tblsearchlog.minsize + tblsearchlog.maxsize) /2 > 500 and (tblsearchlog.minsize + tblsearchlog.maxsize) /2 < 1000 which should work fine. The thing is that minsize and maxsize (for some strange reason) are text fields. Really these should be changed but that would be take forever. Can I cast the two fields to numbers so that this will work? I did try messing around with the eval function but if I use this in CF I get an unknown function error (is there any way of using access fuinctions in cf). I'll probably have to change the datatype on the field but I really dont want to. I'm, using CF 4.51 and access 2000. Thanks Giles -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
