Hi Brad, thanks for the reply.
I think the problem might be with the imap cfc I'm using. The sub q is based on a imap query on the mail folder and I think it's got confused over the message uid value. Seems like a date is being returned into the uid field. Have emailed Paul Vernon who wrote the cfc. Jenny -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 19:08 To: CF-Talk Subject: RE: Weird error message Try wrapping val(last_mail)+1 in an evaluate() #evaluate(val(last_mail)+1)# -----Original Message----- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 12:49 PM To: CF-Talk Subject: Weird error message 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:230359 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
