- see footer for list info -<
Yeh - you don't have any records returned and "sql" is not a column.
I think what you really want is.....
<cfset sql="
select *
from pdfmoveandrename as PMR
where PMR.jobid = #NAME#
AND PMR.PDFWorkFlow_startjob IS NOT NULL
AND PMR.PDFWorkFlow_endjob IS NULL">
<cfquery name="PMRrecord" datasource="Development" dbtype="query" >
#sql#
</cfquery>
<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:
*#sql#*
.End
</cfoutput>
</cfmail>
<cfelse>
</cfif>
Depending on what version of CF you are using, you could also use the
RESULT param in CFQUERY
Quoting Nick Middleweek <[EMAIL PROTECTED]>:
- 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 -<
_______________________________________________
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 -<
