Any ideas anyone please? Strange error running:
<cfquery dbtype="query" name="mail_clear"> select * from mail_get where mail_get.uid < #last_mail+1# </cfquery> Returning with: "0100(CET)" must be interprettable as a valid number in the current locale. The error occurred in C:\sites\ukasfp\members\maillist\import.cfm: line 168 166 : <cfquery dbtype="query" name="mail_clear"> 167 : select * from mail_get 168 : where mail_get.uid < #val(last_mail)+1# 169 : </cfquery> 170 : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230346 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54