>- see footer for list info -< Ah yes, I was getting mixed up with the name and result_name structs. Strange that you need both, they could've grouped them into one struct under name...
... sorry I'm still learning CF and it's idiosyncrasies... Thanks though! 2008/7/28 Philip Porter <[EMAIL PROTECTED]> > - see footer for list info -< >> > Yes - as you are on cf 8, you can - but you must put in <cfquery .... > result="anyname_you_want"> > > then the sql would be > > #anyname_you_want.sql# > > > > Quoting Nick Middleweek <[EMAIL PROTECTED]>: > > - 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/> < >>>>> 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/> < >>>> 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 <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 -<
