Adding attachments to cfmail

[mfasis]

I have a form that allows a user to send an email to a list with the option of
adding an attachment. The action page uploads the file, using cffile, to a temp
diectory and then creates the email and adds the attachment using cfmail and
cfmailparam. I then used cffile to delete the file. A problem arose because the
file was deleted before the email was sent. I then used the following code to
delete all files in the temp directory before uploading the new file.
<cfdirectory
directory='#REQUEST.Site_DirectoryPath#brd_dynamic/email/attachments/'
name='q'> <cfoutput query='q'> <cfif q.type eq 'file' and dateDiff('h',
createodbcdate(q.datelastmodified), now()) GT 0> <cffile action='delete'
file='#REQUEST.Site_DirectoryPath#brd_dynamic/email/attachments/#q.name#'>
</cfif> </cfoutput> I get the following error: The value 'Thursday, March
24, 2005 2:40:33 PM EST' could not be converted to a date. Any ideas?

[blewis]

You probably want to get rid of the createodbcdate() call in there.

[mfasis]

Sorry, In my original code the creatodbcdate() was not there. I was just
trying anything to see if it worked. <cfoutput query='q'> <cfif q.type eq
'file' and dateDiff('h', q.datelastmodified, now()) GT 0> <cffile
action='delete'
file='#REQUEST.Site_DirectoryPath#brd_dynamic/email/attachments/#q.name#'>
</cfif> </cfoutput>

[Mike Greider]

Are you using CF 7? This seems to run just fine for me on CF 6.1. Although I
did hard code my path instead of using a variable. You may want to try that
just to see if they might be something wrong with the variables.

[zoeski80]

Hi

Try using ParseDateTime, it will convert to standard Date/Time format so you can do the date comparison.

#dateDiff("h", ParseDateTime(q.datelastmodified), now()) #

HTH

Zoe