>- see footer for list info -< ok, thanks... It's strange though the docs say i can use result_name.sql: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=remoteServers_6.html
I'm currently running CF 8,0,0,176276 Cheers, Nick 2008/7/28 Philip Porter <[EMAIL PROTECTED]> > - 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 <http://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 <http://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 -<
