>- see footer for list info -< Hello, I've got a query...
<cfquery name="PMRrecord" datasource="Development" dbtype="query"> select * from pdfmoveandrename as PMR where PMR.jobid = #NAME# AND PMR.PDFWorkFlow_startjob IS NOT NULL AND PMR.PDFWorkFlow_endjob IS NULL </cfquery> and when I run this code: <cfif PMRrecord.RecordCount eq 0> <cfmail from="[EMAIL PROTECTED]" to="[EMAIL PROTECTED]" server="mail.tagworldwide.com" subject="PMR not found - #NAME#">Hello, <cfoutput> The record cannot be found for jobid: #NAME#. This is a problem because #NAME# is in the JobEnd folder on Server: #strFTPip#". To connect to this FTP please click the link below: ftp://#strFTPuser#:[EMAIL PROTECTED]/JobEnd/<ftp:///#strFTPuser#:[EMAIL PROTECTED]/JobEnd/> The SQL executed was: *#PMRrecord.sql#* .End </cfoutput> </cfmail> <cfelse> </cfif> I get an error: Element SQL is undefined in PMRRECORD. So it seems the PMRrecord.RecordCount works ok but not PMRrecord.sql Any ideas? Thanks, Nick _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
