try these tools, you may have more luck http://carehart.org/cf411/#excel
On Fri, Nov 15, 2013 at 2:35 PM, Stephens, Larry V <steph...@iu.edu> wrote: > > I've stayed away from cfscript but now I'm looking at it in conjunction > with writing Excel spreadsheets. > > I looked at https://learn.adobe.com/wiki/display/coldfusionen/cfscriptand then > https://learn.adobe.com/wiki/display/coldfusionen/Extending+ColdFusion+Pages+with+CFML+Scriptingbecause > I thought perhaps CF10 is different than CF8. No joy on these pages. > > Google took me to > http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=CFScript_03.html#1160935and > there I see: > > <cfscript> > // Loop through the qGetEmails RecordSet > for (x = 1; x <= qGetEmails.RecordCount; x=x+1) { > This_id = qGetEmails.Emails_id[x]; > > I don't see anything specific to an if statement here. Here's my snippet > (where GetB.bcode is from query GetB and xcampus is set above here): > > <cfscript> > for ( x=1; x<=GetB.Recordcount; x=x+1) { > if GetB.bcode[x] NEQ xcampus { > > This throws an invalid construct error: > ColdFusion was looking at the following text: > > GetB.bcode > > ? What am I missing? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
