Re: CF9 to CF11 cfscript
Hi Adam Its the end of a workshop registration form where multiple participants can be registered. For each participant a series of emails are generated to both the participant and the workshop host, and the participant information is entered into a data bases. The page is then paused for a couple of seconds and then the database is checked to see if all the information is entered before the confirmation page is presented. I had trouble with the combination of email and database actions, I think it was the speed of the email process, putting in the pause solved the problem, let the email processes conclude before going to the confirmation. some of this code is very old I didn't know about sleep() Rob On 10 Aug 2014 at 16:19, Adam Cameron wrote: You know CFML has had the sleep() function (which does what your code does) built-in since CF8, right? Your issue is probaby that thread is a keyword in CF9+. Replace your code with: sleep(4000); Wanting the page to pause whilst data is entered into the DB is an odd thing... given DB operations in CFML are blocking by default. It'd be good to see more of your code to cast some light on what you're doing here...? -- ~| 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:359105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 to CF11 cfscript
Hi folks Migrating from cf9 to cf11 cfscript thread = CreateObject(java, java.lang.Thread); thread.sleep(4000); /cfscript is now giving an error message invalid token What should the syntax be. I simply want the page to pause while data is entered into a database. Thanks Rob ~| 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:359102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 to CF11 cfscript
You know CFML has had the sleep() function (which does what your code does) built-in since CF8, right? Your issue is probaby that thread is a keyword in CF9+. Replace your code with: sleep(4000); Wanting the page to pause whilst data is entered into the DB is an odd thing... given DB operations in CFML are blocking by default. It'd be good to see more of your code to cast some light on what you're doing here...? -- Adam On 10 August 2014 15:56, Rob Voyle robvo...@voyle.com wrote: Hi folks Migrating from cf9 to cf11 cfscript thread = CreateObject(java, java.lang.Thread); thread.sleep(4000); /cfscript is now giving an error message invalid token What should the syntax be. I simply want the page to pause while data is entered into a database. Thanks Rob ~| 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:359103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfscript assistance
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/cfscript and then
https://learn.adobe.com/wiki/display/coldfusionen/Extending+ColdFusion+Pages+with+CFML+Scripting
because 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#1160935
and 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:357072
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript assistance
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
Re: cfscript assistance
On Fri, Nov 15, 2013 at 9:35 AM, Stephens, Larry V steph...@iu.edu wrote:
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?
if ( GetB.bcode[x] != xcampus )
{
// do something
}
~|
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:357075
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript assistance
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?
if ( GetB.bcode[x] != xcampus )
{
// do something
}
And in an attempt to reduce future problems, it's worth pointing out
that CFSCRIPT is basically JavaScript expression syntax with
ColdFusion operators and functions.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.
~|
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:357076
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfscript assistance
Thanks. See below
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: Friday, November 15, 2013 9:45 AM
To: cf-talk
Subject: Re: cfscript assistance
On Fri, Nov 15, 2013 at 9:35 AM, Stephens, Larry V steph...@iu.edu wrote:
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?
if ( GetB.bcode[x] != xcampus )
{
// do something
}
I wondered about != vs NEQ but it throws the same error. At
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=CFScript_02.html
the example uses NEQ inside cfscript
~|
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:357077
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfscript assistance
Ah - I missed part of Matt's response and Dave said the same thing. It was the
() that was throwing the error. Should have seen that...
Thanks.
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
if GetB.bcode[x] NEQ xcampus {
if ( GetB.bcode[x] != xcampus )
{
// do something
}
~|
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:357078
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript queries error in base.cfc
You get same error without the setName aspect:
cfscript
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test value')
);
local.qryObj.execute();
/cfscript
Error:
11:01:30.030 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find qryname19596 key in structure.
On Mon, Oct 14, 2013 at 7:49 AM, Nando d.na...@gmail.com wrote:
I don't use setName() in my script based queries and it works. If I need a
result back from the query, then I use a different variable name
(v.perviousPayPeriod) from the one I use to construct and execute the query
(v.payPerQ). Here's an example of some working code:
v.payPerQ = new Query();
v.payPerQ.setSql(
select paymentPeriodId
from PaymentPeriod
where startDateTime = :startDateTime
and endDateTime = :endDateTime
and isClosed = 1
);
v.payPerQ.addParam( name='startDateTime',
value='#v.previousStartDateTime#', cfsqltype='cf_sql_timestamp' );
v.payPerQ.addParam( name='endDateTime', value='#v.previousEndDateTime#',
cfsqltype='cf_sql_timestamp' );
v.previousPayPeriod= v.payPerQ.execute().getResult();
if (v.previousPayPeriod.RecordCount) {
... do something
} else {
... do something else
}
On Mon, Oct 14, 2013 at 12:44 PM, Raymond Camden raymondcam...@gmail.com
wrote:
Two things.
1) Don't forget that the code behind the script based CFCs is not
encrypted. You can look at base.cfc.
2) The issue seems to be this line:
cfset tagResult.setResult(StructFind(variables,tagAttributes['name']))
But - it is wrapped in a try/catch, so you shouldn't be seeing it. If you
get rid of the setname aspect, which I don't think you need, does it work
ok?
On Sun, Oct 13, 2013 at 9:59 PM, Kumar Shah shahku...@gmail.com wrote:
This is the first time I am creating components wholly in cfscript.
When running update or insert statements via the cfscript query
functions
an error gets recorded like:
22:52:17.017 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find updSaveXML key in structure.
The system still processes fine. The query runs, data gets saved,
updated. I don't know why the error above gets reoorded.
I ran a simple test with code:
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setName(test);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test
value')
);
local.qryObj.execute();
Same Error:
22:58:48.048 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find test key in structure.
Thanks
~|
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:356920
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript queries error in base.cfc
Weird. Not that it matters, but try this mod:
local.qryObj = new com.adobe.coldfusion.query();
local.qryObj.setDatasource(PNGOasis);
then continue
On Tue, Oct 15, 2013 at 10:02 AM, Kumar Shah shahku...@gmail.com wrote:
You get same error without the setName aspect:
cfscript
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test value')
);
local.qryObj.execute();
/cfscript
Error:
11:01:30.030 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find qryname19596 key in structure.
On Mon, Oct 14, 2013 at 7:49 AM, Nando d.na...@gmail.com wrote:
I don't use setName() in my script based queries and it works. If I need
a
result back from the query, then I use a different variable name
(v.perviousPayPeriod) from the one I use to construct and execute the
query
(v.payPerQ). Here's an example of some working code:
v.payPerQ = new Query();
v.payPerQ.setSql(
select paymentPeriodId
from PaymentPeriod
where startDateTime = :startDateTime
and endDateTime = :endDateTime
and isClosed = 1
);
v.payPerQ.addParam( name='startDateTime',
value='#v.previousStartDateTime#', cfsqltype='cf_sql_timestamp' );
v.payPerQ.addParam( name='endDateTime', value='#v.previousEndDateTime#',
cfsqltype='cf_sql_timestamp' );
v.previousPayPeriod= v.payPerQ.execute().getResult();
if (v.previousPayPeriod.RecordCount) {
... do something
} else {
... do something else
}
On Mon, Oct 14, 2013 at 12:44 PM, Raymond Camden
raymondcam...@gmail.com
wrote:
Two things.
1) Don't forget that the code behind the script based CFCs is not
encrypted. You can look at base.cfc.
2) The issue seems to be this line:
cfset
tagResult.setResult(StructFind(variables,tagAttributes['name']))
But - it is wrapped in a try/catch, so you shouldn't be seeing it. If
you
get rid of the setname aspect, which I don't think you need, does it
work
ok?
On Sun, Oct 13, 2013 at 9:59 PM, Kumar Shah shahku...@gmail.com
wrote:
This is the first time I am creating components wholly in cfscript.
When running update or insert statements via the cfscript query
functions
an error gets recorded like:
22:52:17.017 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find updSaveXML key in structure.
The system still processes fine. The query runs, data gets saved,
updated. I don't know why the error above gets reoorded.
I ran a simple test with code:
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setName(test);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test
value')
);
local.qryObj.execute();
Same Error:
22:58:48.048 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find test key in structure.
Thanks
~|
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:356921
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript queries error in base.cfc
I see you are on CF9. Do you have a copy of CF10? If so, try copying over
the CFCs. This may be something that was fixed.
On Tue, Oct 15, 2013 at 10:13 AM, Raymond Camden raymondcam...@gmail.comwrote:
Weird. Not that it matters, but try this mod:
local.qryObj = new com.adobe.coldfusion.query();
local.qryObj.setDatasource(PNGOasis);
then continue
On Tue, Oct 15, 2013 at 10:02 AM, Kumar Shah shahku...@gmail.com wrote:
You get same error without the setName aspect:
cfscript
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test value')
);
local.qryObj.execute();
/cfscript
Error:
11:01:30.030 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find qryname19596 key in structure.
On Mon, Oct 14, 2013 at 7:49 AM, Nando d.na...@gmail.com wrote:
I don't use setName() in my script based queries and it works. If I
need a
result back from the query, then I use a different variable name
(v.perviousPayPeriod) from the one I use to construct and execute the
query
(v.payPerQ). Here's an example of some working code:
v.payPerQ = new Query();
v.payPerQ.setSql(
select paymentPeriodId
from PaymentPeriod
where startDateTime = :startDateTime
and endDateTime = :endDateTime
and isClosed = 1
);
v.payPerQ.addParam( name='startDateTime',
value='#v.previousStartDateTime#', cfsqltype='cf_sql_timestamp' );
v.payPerQ.addParam( name='endDateTime',
value='#v.previousEndDateTime#',
cfsqltype='cf_sql_timestamp' );
v.previousPayPeriod= v.payPerQ.execute().getResult();
if (v.previousPayPeriod.RecordCount) {
... do something
} else {
... do something else
}
On Mon, Oct 14, 2013 at 12:44 PM, Raymond Camden
raymondcam...@gmail.com
wrote:
Two things.
1) Don't forget that the code behind the script based CFCs is not
encrypted. You can look at base.cfc.
2) The issue seems to be this line:
cfset
tagResult.setResult(StructFind(variables,tagAttributes['name']))
But - it is wrapped in a try/catch, so you shouldn't be seeing it. If
you
get rid of the setname aspect, which I don't think you need, does it
work
ok?
On Sun, Oct 13, 2013 at 9:59 PM, Kumar Shah shahku...@gmail.com
wrote:
This is the first time I am creating components wholly in cfscript.
When running update or insert statements via the cfscript query
functions
an error gets recorded like:
22:52:17.017 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find updSaveXML key in structure.
The system still processes fine. The query runs, data gets saved,
updated. I don't know why the error above gets reoorded.
I ran a simple test with code:
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setName(test);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test
value')
);
local.qryObj.execute();
Same Error:
22:58:48.048 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find test key in structure.
Thanks
~|
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:356923
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfscript queries error in base.cfc
This is the first time I am creating components wholly in cfscript.
When running update or insert statements via the cfscript query functions
an error gets recorded like:
22:52:17.017 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find updSaveXML key in structure.
The system still processes fine. The query runs, data gets saved,
updated. I don't know why the error above gets reoorded.
I ran a simple test with code:
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setName(test);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test value')
);
local.qryObj.execute();
Same Error:
22:58:48.048 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find test key in structure.
Thanks
~|
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:356915
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript queries error in base.cfc
Two things.
1) Don't forget that the code behind the script based CFCs is not
encrypted. You can look at base.cfc.
2) The issue seems to be this line:
cfset tagResult.setResult(StructFind(variables,tagAttributes['name']))
But - it is wrapped in a try/catch, so you shouldn't be seeing it. If you
get rid of the setname aspect, which I don't think you need, does it work
ok?
On Sun, Oct 13, 2013 at 9:59 PM, Kumar Shah shahku...@gmail.com wrote:
This is the first time I am creating components wholly in cfscript.
When running update or insert statements via the cfscript query functions
an error gets recorded like:
22:52:17.017 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find updSaveXML key in structure.
The system still processes fine. The query runs, data gets saved,
updated. I don't know why the error above gets reoorded.
I ran a simple test with code:
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setName(test);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test value')
);
local.qryObj.execute();
Same Error:
22:58:48.048 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find test key in structure.
Thanks
~|
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:356918
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript queries error in base.cfc
I don't use setName() in my script based queries and it works. If I need a
result back from the query, then I use a different variable name
(v.perviousPayPeriod) from the one I use to construct and execute the query
(v.payPerQ). Here's an example of some working code:
v.payPerQ = new Query();
v.payPerQ.setSql(
select paymentPeriodId
from PaymentPeriod
where startDateTime = :startDateTime
and endDateTime = :endDateTime
and isClosed = 1
);
v.payPerQ.addParam( name='startDateTime',
value='#v.previousStartDateTime#', cfsqltype='cf_sql_timestamp' );
v.payPerQ.addParam( name='endDateTime', value='#v.previousEndDateTime#',
cfsqltype='cf_sql_timestamp' );
v.previousPayPeriod= v.payPerQ.execute().getResult();
if (v.previousPayPeriod.RecordCount) {
... do something
} else {
... do something else
}
On Mon, Oct 14, 2013 at 12:44 PM, Raymond Camden raymondcam...@gmail.comwrote:
Two things.
1) Don't forget that the code behind the script based CFCs is not
encrypted. You can look at base.cfc.
2) The issue seems to be this line:
cfset tagResult.setResult(StructFind(variables,tagAttributes['name']))
But - it is wrapped in a try/catch, so you shouldn't be seeing it. If you
get rid of the setname aspect, which I don't think you need, does it work
ok?
On Sun, Oct 13, 2013 at 9:59 PM, Kumar Shah shahku...@gmail.com wrote:
This is the first time I am creating components wholly in cfscript.
When running update or insert statements via the cfscript query functions
an error gets recorded like:
22:52:17.017 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find updSaveXML key in structure.
The system still processes fine. The query runs, data gets saved,
updated. I don't know why the error above gets reoorded.
I ran a simple test with code:
local.qryObj = new Query(datasource=PNGOasis);
local.qryObj.setName(test);
local.qryObj.setSQL(
INSERT INTO PNGOasisExt.dbo.Test(testValue) VALUES ('test value')
);
local.qryObj.execute();
Same Error:
22:58:48.048 - Expression Exception - in
C:/ColdFusion9/CustomTags/com/adobe/coldfusion/base.cfc : line 460
Cannot find test key in structure.
Thanks
~|
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:356919
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re[6]: cfscript zip example?
Ah. My apologies to the list for my inadvertent faux pas. (And thanks to the two kind souls who sent me messages off-list...) -- Cheers! Michael David -- Original Message -- From: Nathan Strutz str...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 10:18:28 PM Subject: Re: Re[4]: cfscript zip example? Michael, Start a new thread. Start a new subject. Don't hijack ;) nathan strutz [ www.dopefly.com ] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Mon, Jun 25, 2012 at 6:09 PM, Michael David li...@michaeldavid.com wrote: Ok, I'll bite. :) How is Railo compared, say, to CF9? Is it solid enough on IIS7 for high-volume production use? Seriously, not trying to touch off some debate here. I'm just curious... -- Cheers! Michael David -- Original Message -- From: Matt Quackenbush quackfu...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 2:23:14 PM Subject: Re: Re[2]: cfscript zip example? It's called Railo. :D On Mon, Jun 25, 2012 at 12:52 PM, Michael David li...@michaeldavid.com wrote: Seriously! I sure wish that Adobe would provide a cfscript solution for every cftag, for those of us who prefer the former. -- Cheers! Michael David -- Original Message -- From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 11:05:08 AM Subject: Re: cfscript zip example? Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jun 26, 2012 at 12:48 AM, Raymond Camden raymondcam...@gmail.com wrote: There is no script support for cfzip. He is using a script based CFC. On Mon, Jun 25, 2012 at 4:08 AM, Andrew Scott andr...@andyscott.id.au wrote: Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~| 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:351712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
Any particular reason you don't use the cfzip tag from ColdFusion 8+? Sorry, that's probably not helpful, but hey sometimes people don't read the docs. If you're on Adobe software, I think nothing before CF8 is even supported anymore. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Sun, Jun 24, 2012 at 7:36 PM, Paul Hastings p...@sustainablegis.comwrote: having a hard time getting my wooly head around the zip.cfc from cfcommunity. anyone know of any code examples for the action zip bits? thanks. ~| 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:351673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
On 6/25/2012 1:07 PM, Nathan Strutz wrote: Any particular reason you don't use the cfzip tag from ColdFusion 8+? project CFCs are all in cfscript. Sorry, that's probably not helpful, but hey sometimes people don't read the docs. If you're on Adobe software, I think nothing before CF8 is even supported anymore. sorry, not following you. what? ~| 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:351677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Mon, Jun 25, 2012 at 6:13 PM, Paul Hastings p...@sustainablegis.comwrote: On 6/25/2012 1:07 PM, Nathan Strutz wrote: Any particular reason you don't use the cfzip tag from ColdFusion 8+? project CFCs are all in cfscript. Sorry, that's probably not helpful, but hey sometimes people don't read the docs. If you're on Adobe software, I think nothing before CF8 is even supported anymore. sorry, not following you. what? ~| 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:351678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
There is no script support for cfzip. He is using a script based CFC. On Mon, Jun 25, 2012 at 4:08 AM, Andrew Scott andr...@andyscott.id.au wrote: Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~| 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:351687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
Unless you're on Railo, of course. :-) http://wiki.getrailo.org/wiki/TAG:CFZIP On Mon, Jun 25, 2012 at 9:48 AM, Raymond Camden raymondcam...@gmail.comwrote: There is no script support for cfzip. He is using a script based CFC. On Mon, Jun 25, 2012 at 4:08 AM, Andrew Scott andr...@andyscott.id.au wrote: Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~| 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:351688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
Ok, so to clarify, are you using the zip.cfc from https://github.com/CFCommunity/CFScript-Community-Components ? Sorry, I don't think I know Russ, who it looks like authored it. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Mon, Jun 25, 2012 at 1:13 AM, Paul Hastings p...@sustainablegis.comwrote: On 6/25/2012 1:07 PM, Nathan Strutz wrote: Any particular reason you don't use the cfzip tag from ColdFusion 8+? project CFCs are all in cfscript. ~| 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:351689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jun 26, 2012 at 12:48 AM, Raymond Camden raymondcam...@gmail.comwrote: There is no script support for cfzip. He is using a script based CFC. On Mon, Jun 25, 2012 at 4:08 AM, Andrew Scott andr...@andyscott.id.au wrote: Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~| 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:351690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
To be fair, we've been expanded native script functionality _and_ the Script Stuff as CFCs in each release. It's getting there. On Mon, Jun 25, 2012 at 10:05 AM, Andrew Scott andr...@andyscott.id.au wrote: Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( ~| 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:351691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
Yes, we can agree getting there. But would it have not been better to sit down and think that people are going to want cfscript version of everything, and hold of releasing until it is done and not 4 versions later? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jun 26, 2012 at 1:19 AM, Raymond Camden raymondcam...@gmail.comwrote: To be fair, we've been expanded native script functionality _and_ the Script Stuff as CFCs in each release. It's getting there. On Mon, Jun 25, 2012 at 10:05 AM, Andrew Scott andr...@andyscott.id.au wrote: Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( ~| 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:351693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
But would it have not been better to sit down and think that people are going to want cfscript version of everything, and hold of releasing until it is done and not 4 versions later? Probably not - you can either get some things now, or maybe get everything later. Note the word maybe. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:351694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
This topic has devolved a bit - let's see if we can actually help Paul Paul, are you just looking for an example of creating a zip file from let's say, a specific directory? I'd be happy to send you a couple of working examples if you tell just what you need it to do. =] -- Alan Rother Manager, Phoenix Cold Fusion User Group, www.AZCFUG.org Twitter: @AlanRother ~| 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:351695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re[2]: cfscript zip example?
Seriously! I sure wish that Adobe would provide a cfscript solution for every cftag, for those of us who prefer the former. -- Cheers! Michael David -- Original Message -- From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 11:05:08 AM Subject: Re: cfscript zip example? Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jun 26, 2012 at 12:48 AM, Raymond Camden raymondcam...@gmail.com wrote: There is no script support for cfzip. He is using a script based CFC. On Mon, Jun 25, 2012 at 4:08 AM, Andrew Scott andr...@andyscott.id.au wrote: Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~| 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:351697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re[2]: cfscript zip example?
It's called Railo. :D On Mon, Jun 25, 2012 at 12:52 PM, Michael David li...@michaeldavid.comwrote: Seriously! I sure wish that Adobe would provide a cfscript solution for every cftag, for those of us who prefer the former. -- Cheers! Michael David -- Original Message -- From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 11:05:08 AM Subject: Re: cfscript zip example? Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jun 26, 2012 at 12:48 AM, Raymond Camden raymondcam...@gmail.com wrote: There is no script support for cfzip. He is using a script based CFC. On Mon, Jun 25, 2012 at 4:08 AM, Andrew Scott andr...@andyscott.id.au wrote: Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~| 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:351698 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re[2]: cfscript zip example?
Errr, yes, so sorry we couldn't do _everything_ people wanted in CF10. CF11 will have every feature requested. Ever. (Yes, I'm being sarcastic.) On Mon, Jun 25, 2012 at 1:23 PM, Matt Quackenbush quackfu...@gmail.com wrote: It's called Railo. :D On Mon, Jun 25, 2012 at 12:52 PM, Michael David li...@michaeldavid.comwrote: Seriously! I sure wish that Adobe would provide a cfscript solution for every cftag, for those of us who prefer the former. -- Cheers! Michael David -- Original Message -- From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 11:05:08 AM Subject: Re: cfscript zip example? Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( ~| 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:351699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re[2]: cfscript zip example?
CF11: Code name Magic Pony! On Mon, Jun 25, 2012 at 11:35 AM, Raymond Camden raymondcam...@gmail.com wrote: Errr, yes, so sorry we couldn't do _everything_ people wanted in CF10. CF11 will have every feature requested. Ever. (Yes, I'm being sarcastic.) On Mon, Jun 25, 2012 at 1:23 PM, Matt Quackenbush quackfu...@gmail.com wrote: It's called Railo. :D On Mon, Jun 25, 2012 at 12:52 PM, Michael David li...@michaeldavid.comwrote: Seriously! I sure wish that Adobe would provide a cfscript solution for every cftag, for those of us who prefer the former. -- Cheers! Michael David -- Original Message -- From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 11:05:08 AM Subject: Re: cfscript zip example? Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( ~| 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:351700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
On 6/26/2012 1:35 AM, Raymond Camden wrote: Errr, yes, so sorry we couldn't do _everything_ people wanted in CF10. CF11 will have every feature requested. Ever. the cfcommunity's done a good job w/some of what was missing--it's just this one case where *i'm* not getting the syntax. you guys don't have to do it all alone. ~| 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:351705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re[4]: cfscript zip example?
Ok, I'll bite. :) How is Railo compared, say, to CF9? Is it solid enough on IIS7 for high-volume production use? Seriously, not trying to touch off some debate here. I'm just curious... -- Cheers! Michael David -- Original Message -- From: Matt Quackenbush quackfu...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 2:23:14 PM Subject: Re: Re[2]: cfscript zip example? It's called Railo. :D On Mon, Jun 25, 2012 at 12:52 PM, Michael David li...@michaeldavid.com wrote: Seriously! I sure wish that Adobe would provide a cfscript solution for every cftag, for those of us who prefer the former. -- Cheers! Michael David -- Original Message -- From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 11:05:08 AM Subject: Re: cfscript zip example? Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jun 26, 2012 at 12:48 AM, Raymond Camden raymondcam...@gmail.com wrote: There is no script support for cfzip. He is using a script based CFC. On Mon, Jun 25, 2012 at 4:08 AM, Andrew Scott andr...@andyscott.id.au wrote: Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~| 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:351706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
On 6/25/2012 11:24 PM, Alan Rother wrote: This topic has devolved a bit - let's see if we can actually help Paul well since this list is also a part of the cf community, posting a few simple cfscript zip examples for all the function's actions would be a good idea. an even better one would be to add them to the cf community git whatever-it-is. and FYI i would have simply contacted the author (russplaysguitar) if github actually had functionality for that. ~| 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:351707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
On Mon, Jun 25, 2012 at 8:14 PM, Paul Hastings p...@sustainablegis.com wrote: and FYI i would have simply contacted the author (russplaysguitar) if github actually had functionality for that. RIAForge let's you contact project owners! ;) -- === Raymond Camden, Adobe Developer Evangelist Email : raymondcam...@gmail.com Blog : www.raymondcamden.com Twitter: cfjedimaster ~| 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:351708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re[4]: cfscript zip example?
Michael, Start a new thread. Start a new subject. Don't hijack ;) nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Mon, Jun 25, 2012 at 6:09 PM, Michael David li...@michaeldavid.comwrote: Ok, I'll bite. :) How is Railo compared, say, to CF9? Is it solid enough on IIS7 for high-volume production use? Seriously, not trying to touch off some debate here. I'm just curious... -- Cheers! Michael David -- Original Message -- From: Matt Quackenbush quackfu...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 2:23:14 PM Subject: Re: Re[2]: cfscript zip example? It's called Railo. :D On Mon, Jun 25, 2012 at 12:52 PM, Michael David li...@michaeldavid.com wrote: Seriously! I sure wish that Adobe would provide a cfscript solution for every cftag, for those of us who prefer the former. -- Cheers! Michael David -- Original Message -- From: Andrew Scott andr...@andyscott.id.au To: cf-talk cf-talk@houseoffusion.com Sent: 6/25/2012 11:05:08 AM Subject: Re: cfscript zip example? Hmmm, for some reason I thought there had been some functions for zip... Oh well, more tags not converted to script that adobe think we don't use :-( -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jun 26, 2012 at 12:48 AM, Raymond Camden raymondcam...@gmail.com wrote: There is no script support for cfzip. He is using a script based CFC. On Mon, Jun 25, 2012 at 4:08 AM, Andrew Scott andr...@andyscott.id.au wrote: Paul, Nathan is asking is there any reason you are not using ColdFusion 8 and its tag/script based support for zip, instead of a 3rd party library. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 ~| 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:351709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
If we have any takers, I would especially love it if someone would create a demo in the form of an MXUnit test case and issue a pull request. Anyone... ? In fact, if somebody makes a demo, I can make the test case for you and add it to the project. Paul's got a good idea though. We could really use some solid demos. Paul, why not add the missing test case and the missing demos as separate bug reports on github? They're both good ideas. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Mon, Jun 25, 2012 at 6:14 PM, Paul Hastings p...@sustainablegis.comwrote: On 6/25/2012 11:24 PM, Alan Rother wrote: This topic has devolved a bit - let's see if we can actually help Paul well since this list is also a part of the cf community, posting a few simple cfscript zip examples for all the function's actions would be a good idea. an even better one would be to add them to the cf community git whatever-it-is. and FYI i would have simply contacted the author (russplaysguitar) if github actually had functionality for that. ~| 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:351710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfscript zip example?
On 6/26/2012 9:24 AM, Nathan Strutz wrote: Paul's got a good idea though. We could really use some solid demos. Paul, why not add the missing test case and the missing demos as separate bug reports on github? They're both good ideas. i would if i 100% understood it in the first place. don't have the time right now to figure it out, hence the email. ~| 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:351711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfscript zip example?
having a hard time getting my wooly head around the zip.cfc from cfcommunity. anyone know of any code examples for the action zip bits? thanks. ~| 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:351671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Converting this java code into cfscript?
Thanks Leigh, made a lot of sense and works perfect!! See http://pastebin.com/M5CNshBp . Looks like my post got cut off again ... -Leigh ~| 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:351553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Converting this java code into cfscript?
Hi, I am having difficulty understanding how i would change the follower Java code into cfscript... specifically the 'new CellRangeAddress' section: CellRangeAddress cellRangeAddress = sheet.getMergedRegion(i); CellRangeAddress newCellRangeAddress = new CellRangeAddress(newRow.getRowNum(), (newRow.getRowNum() + (cellRangeAddress.getFirstRow() - cellRangeAddress.getLastRow())), cellRangeAddress.getFirstColumn(), cellRangeAddress.getLastColumn()); thanks for your help ~| 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:351520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Converting this java code into cfscript?
CellRangeAddress cellRangeAddress = sheet.getMergedRegion(i); Just drop the data type declarations in front of the variable names. Then instantiate classes with init() instead of new ClassName( ...). You may also want to break it up for better readability. I am heading out and cannot test this, but something along these lines: // not tested cellRangeAddress = sheet.getMergedRegion(i); firstRow = newRow.getRowNum(); lastRow = newRow.getRowNum() + (cellRangeAddress.getFirstRow() - cellRangeAddress.getLastRow()); firstCol = cellRangeAddress.getFirstColumn(); lastCol = cellRangeAddress.getLastColumn(); cellRangeAddress = createObject(java, org.apache.poi.hssf.util.CellRangeAddress); cellRangeAddress = cellRangeAddress.init( f ~| 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:351522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Converting this java code into cfscript?
See http://pastebin.com/M5CNshBp . Looks like my post got cut off again ... -Leigh ~| 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:351523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Best IDE for cfscript
I've considered IDEA. Is it overkill or, rather, heavy on features that aren't usable for someone who codes in HTML, CF, jQuery, CSS 5 and does no pure JS app coding or mobile apps coding. I code hybrid web apps. IDEA just seems to be too heavy on the JS side for my work. I'm not looking so much for language support as an IDE that works they I want. There's not one under the sun that I've found so far, even after 15 years of searching. -Original Message- From: Dave Merrill [mailto:enigm...@gmail.com] Sent: Saturday, May 12, 2012 11:42 PM To: cf-talk Subject: Re: Best IDE for cfscript I'm with Matt, IDEA is great. In many ways, big and small, it increases my productivity and code quality, and just improve the experience of coding all around. It's not without its warts, but it's improving all the time. I'd never go back. Dave Merrill On Mon, May 7, 2012 at 1:45 PM, Matt Quackenbush wrote: Since it hasn't been mentioned yet, I would also recommend giving Intellij IDEA a shot, *especially* if you work in other languages, too. It was quite a change for me, having used CFE/CFB for many years, but I doubt I could switch back, now. http://www.jetbrains.com/idea/ ~| 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:351126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best IDE for cfscript
I'm with Matt, IDEA is great. In many ways, big and small, it increases my productivity and code quality, and just improve the experience of coding all around. It's not without its warts, but it's improving all the time. I'd never go back. Dave Merrill On Mon, May 7, 2012 at 1:45 PM, Matt Quackenbush wrote: Since it hasn't been mentioned yet, I would also recommend giving Intellij IDEA a shot, *especially* if you work in other languages, too. It was quite a change for me, having used CFE/CFB for many years, but I doubt I could switch back, now. http://www.jetbrains.com/idea/ ~| 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:351125 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Best IDE for cfscript
What is the best IDE for cfcript work? CFBuilder 2? CFEclipse? Or? -RR ~| 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:351017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best IDE for cfscript
I use CFEclipse with no problems. Not a big fan of CFBuilder. Eric On Mon, May 7, 2012 at 10:46 AM, Robert Rhodes rrhode...@gmail.com wrote: What is the best IDE for cfcript work? CFBuilder 2? CFEclipse? Or? -RR ~| 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:351021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best IDE for cfscript
On Mon, May 7, 2012 at 11:46 AM, Robert Rhodes rrhode...@gmail.com wrote: What is the best IDE for cfcript work? CFBuilder 2? CFEclipse? Or? Try them both. Decide for yourself. That are both built on Eclipse, so it's easy to switch. -Cameron ... ~| 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:351022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best IDE for cfscript
Since it hasn't been mentioned yet, I would also recommend giving Intellij IDEA a shot, *especially* if you work in other languages, too. It was quite a change for me, having used CFE/CFB for many years, but I doubt I could switch back, now. http://www.jetbrains.com/idea/ On Mon, May 7, 2012 at 12:40 PM, Cameron Childress camer...@gmail.comwrote: On Mon, May 7, 2012 at 11:46 AM, Robert Rhodes rrhode...@gmail.com wrote: What is the best IDE for cfcript work? CFBuilder 2? CFEclipse? Or? Try them both. Decide for yourself. That are both built on Eclipse, so it's easy to switch. -Cameron ... ~| 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:351023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best IDE for cfscript
So there are large line number issues with most.. My backup is a old tool called PFE, Programmers FIle Editor. I've edited 14 GB text files with it. On Mon, May 7, 2012 at 1:21 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I use CFEclipse with no problems. Not a big fan of CFBuilder. Eric On Mon, May 7, 2012 at 10:46 AM, Robert Rhodes rrhode...@gmail.com wrote: What is the best IDE for cfcript work? CFBuilder 2? CFEclipse? Or? -RR ~| 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:351024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best IDE for cfscript
When I need to do some quick editing I use Notepad++ on Windows or Textwragler on Mac (both free editors). When working on projects I use CFBuilder for all the ColdFusion specific features like Server management, tailview, extensions, ... Don't forget that CFBuilder has a free express version! Guust On 07 May 2012, at 20:16, Brian Thornton br...@cfdeveloper.com wrote: So there are large line number issues with most.. My backup is a old tool called PFE, Programmers FIle Editor. I've edited 14 GB text files with it. On Mon, May 7, 2012 at 1:21 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I use CFEclipse with no problems. Not a big fan of CFBuilder. Eric On Mon, May 7, 2012 at 10:46 AM, Robert Rhodes rrhode...@gmail.com wrote: What is the best IDE for cfcript work? CFBuilder 2? CFEclipse? Or? -RR ~| 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:351026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
Right. I was talking about why _I_ generally don't like cfscript. But, honestly, if they don't really know how to do anything in javascript, then I'm not sure what they're doing writing CFML (or any web application development language). Scott On Tue, Feb 21, 2012 at 7:27 PM, Aaron Rouse aaron.ro...@gmail.com wrote: The people I was referring to I am certain do not know how to write anything or much of anything in JavaScript. So it is not a matter of CFScript confusing them into thinking it is JavaScript. -- - Scott Brady http://www.scottbrady.net/ ~| 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:350020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
You might be surprised at how many people I come across in the industry who are making a good solid living writing CF apps but barely can write CSS, HTML, JavaScript and really even much in regards to SQL. Quite often though they are using some sort of CF framework or other core tool that a more advanced group of CF people developed. On Wed, Feb 22, 2012 at 4:50 AM, Scott Brady dsbr...@gmail.com wrote: Right. I was talking about why _I_ generally don't like cfscript. But, honestly, if they don't really know how to do anything in javascript, then I'm not sure what they're doing writing CFML (or any web application development language). Scott On Tue, Feb 21, 2012 at 7:27 PM, Aaron Rouse aaron.ro...@gmail.com wrote: The people I was referring to I am certain do not know how to write anything or much of anything in JavaScript. So it is not a matter of CFScript confusing them into thinking it is JavaScript. -- - Scott Brady http://www.scottbrady.net/ ~| 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:350024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
As of CF9, the vast majority of CF can be written in script, if you desire. Almost every tag has a cfscript equivalent (I believe there were a few that didn't make the cut, but I can't recall which ones off-hand). Of course, some things are a bit more tedious doing them in script (such as outputting content and running queries). Scott On Mon, Feb 20, 2012 at 5:50 PM, Robert Rhodes rrhode...@gmail.com wrote: I do wish Adobe would fill out CF so that one could write mostly in cfscript and avoid cf tags altogether, if desired. It would also help when I end up around small-minded coders who scoff at CF merely because of the tags.On Mon, Feb 20, 2012 at 12:25 PM, Cameron Childress -- - Scott Brady http://www.scottbrady.net/ ~| 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:349987 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
Agreed and someone could always write themselves some custom functions as wrappers to CF tags for prior versions CF or perhaps even what is missing in the current. To a point at least. I have been a CFScript Nazi for well over a decade now but fully recognize a place for it and a place for when to use the tags. I very rarely use it for outputting things and can't say I really have had a need for much of the added tags-to-functions introduced in CF9. We though have many pre-CF9 servers so also does not make too much sense for me to write anything specific to CF9. On Tue, Feb 21, 2012 at 5:05 AM, Scott Brady dsbr...@gmail.com wrote: As of CF9, the vast majority of CF can be written in script, if you desire. Almost every tag has a cfscript equivalent (I believe there were a few that didn't make the cut, but I can't recall which ones off-hand). Of course, some things are a bit more tedious doing them in script (such as outputting content and running queries). Scott On Mon, Feb 20, 2012 at 5:50 PM, Robert Rhodes rrhode...@gmail.com wrote: I do wish Adobe would fill out CF so that one could write mostly in cfscript and avoid cf tags altogether, if desired. It would also help when I end up around small-minded coders who scoff at CF merely because of the tags.On Mon, Feb 20, 2012 at 12:25 PM, Cameron Childress -- - Scott Brady http://www.scottbrady.net/ ~| 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:349993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
On Mon, Feb 20, 2012 at 7:50 PM, Robert Rhodes rrhode...@gmail.com wrote: I do wish Adobe would fill out CF so that one could write mostly in cfscript and avoid cf tags altogether, if desired. It would also help when I end up around small-minded coders who scoff at CF merely because of the tags. I've never changed my coding style to make a non-CF developer happy, seems a waste of time. If you prefer it, that's one thing, but you should never measure your own self worth by comments made by someone ignorant of the language. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| 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:349994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
I have worked with CF developers who scoff at any CFScript usage but for reasons most would not assume. They did it because they flat out did not understand the syntax and I am not referring to some abundant overuse of CFScript here. It can sometimes be a balancing act of coding how you want and/or think you should v. staying employed and making some adjustments so others stay happy. On Tue, Feb 21, 2012 at 9:28 AM, Cameron Childress camer...@gmail.comwrote: On Mon, Feb 20, 2012 at 7:50 PM, Robert Rhodes rrhode...@gmail.com wrote: I do wish Adobe would fill out CF so that one could write mostly in cfscript and avoid cf tags altogether, if desired. It would also help when I end up around small-minded coders who scoff at CF merely because of the tags. I've never changed my coding style to make a non-CF developer happy, seems a waste of time. If you prefer it, that's one thing, but you should never measure your own self worth by comments made by someone ignorant of the language. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| 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:350005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
You mean I should write a book on CFScript? Fantastic? Betascript Publishing hhhm... Anyone notice the tagline states: ColdFusion Markup Language, JavaScript, BlogCFC Now THAT is interesting... Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 2/20/2012 10:48 AM, Robert Rhodes wrote: Hello to all. Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. All suggestions welcome. -RR ~| 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:350006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
Yeah, or how about the red seal on the cover that says High Quality Content by WIKIPEDIA articles!? LOL :-D On 2/21/2012 11:04 AM, Steve 'Cutter' Blades wrote: You mean I should write a book on CFScript? Fantastic? Betascript Publishing hhhm... Anyone notice the tagline states: ColdFusion Markup Language, JavaScript, BlogCFC Now THAT is interesting... Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 2/20/2012 10:48 AM, Robert Rhodes wrote: Hello to all. Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. All suggestions welcome. -RR ~| 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:350008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
This publisher releases something like 10,000+ titles a year: they scrape Wikipedia content and sell it. http://en.wikipedia.org/wiki/VDM_Publishing Billy Cravens bdcrav...@gmail.com On Feb 21, 2012, at 1:19 PM, Carl Von Stetten wrote: Yeah, or how about the red seal on the cover that says High Quality Content by WIKIPEDIA articles!? LOL :-D On 2/21/2012 11:04 AM, Steve 'Cutter' Blades wrote: You mean I should write a book on CFScript? Fantastic? Betascript Publishing hhhm... Anyone notice the tagline states: ColdFusion Markup Language, JavaScript, BlogCFC Now THAT is interesting... Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 2/20/2012 10:48 AM, Robert Rhodes wrote: Hello to all. Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. All suggestions welcome. -RR ~| 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:350013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
My main issue with cfscript is that it's easy to confuse at first glance between that and javascript (for cases when you have JS mixed in with CF code, as the legacy app I work on at work has). So, it's not really cfscript's fault as much as a personal bugaboo. Scott On Tue, Feb 21, 2012 at 11:35 AM, Aaron Rouse aaron.ro...@gmail.com wrote: I have worked with CF developers who scoff at any CFScript usage but for reasons most would not assume. They did it because they flat out did not understand the syntax and I am not referring to some abundant overuse of CFScript here. It can sometimes be a balancing act of coding how you want and/or think you should v. staying employed and making some adjustments so others stay happy. -- - Scott Brady http://www.scottbrady.net/ ~| 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:350014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
cfscript to many defeats the who point of why they chose cf in the first place, because it was a html like easy to learn tag based language. When you go down the route of doing all your code in script, using OOP style coding, then surely you would just be better off writing directly in JAVA ? On Wed, Feb 22, 2012 at 12:55 AM, Scott Brady dsbr...@gmail.com wrote: My main issue with cfscript is that it's easy to confuse at first glance between that and javascript (for cases when you have JS mixed in with CF code, as the legacy app I work on at work has). So, it's not really cfscript's fault as much as a personal bugaboo. Scott On Tue, Feb 21, 2012 at 11:35 AM, Aaron Rouse aaron.ro...@gmail.com wrote: I have worked with CF developers who scoff at any CFScript usage but for reasons most would not assume. They did it because they flat out did not understand the syntax and I am not referring to some abundant overuse of CFScript here. It can sometimes be a balancing act of coding how you want and/or think you should v. staying employed and making some adjustments so others stay happy. -- - Scott Brady http://www.scottbrady.net/ ~| 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:350015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
Well, nobody's better off writing in Java, but C# would be an alternative. On Wednesday, February 22, 2012, Russ Michaels wrote: cfscript to many defeats the who point of why they chose cf in the first place, because it was a html like easy to learn tag based language. When you go down the route of doing all your code in script, using OOP style coding, then surely you would just be better off writing directly in JAVA ? -- -- Shu Ha Ri: Agile and .NET blog http://www.bifrost.com.au/ ~| 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:350016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
The people I was referring to I am certain do not know how to write anything or much of anything in JavaScript. So it is not a matter of CFScript confusing them into thinking it is JavaScript. On Tue, Feb 21, 2012 at 6:55 PM, Scott Brady dsbr...@gmail.com wrote: My main issue with cfscript is that it's easy to confuse at first glance between that and javascript (for cases when you have JS mixed in with CF code, as the legacy app I work on at work has). So, it's not really cfscript's fault as much as a personal bugaboo. Scott On Tue, Feb 21, 2012 at 11:35 AM, Aaron Rouse aaron.ro...@gmail.com wrote: I have worked with CF developers who scoff at any CFScript usage but for reasons most would not assume. They did it because they flat out did not understand the syntax and I am not referring to some abundant overuse of CFScript here. It can sometimes be a balancing act of coding how you want and/or think you should v. staying employed and making some adjustments so others stay happy. -- - Scott Brady http://www.scottbrady.net/ ~| 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:350017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFScript Book
Hello to all. Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. All suggestions welcome. -RR ~| 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:349961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
On Mon, Feb 20, 2012 at 10:48 AM, Robert Rhodes rrhode...@gmail.com wrote: Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. Is there a reason you want to only learn CFScript? The CFML language has so many tags and many ways of doing things. Learning only CFScript may not serve you well. Attempting to use all tags or all script is probably not the best goal IMHO. Having said that, the Adobe docs are a good starting point for learning CFScript, but if you want more than that I'd look at a regular ole CF Book like CFWACK, and then look for a CFScript equivalent for what you're doing if you really need/want one. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| 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:349964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
For what its worth I have a cfscript cheatsheet here: http://www.petefreitag.com/cheatsheets/coldfusion/cfscript/ It lists much but certainly not all of what you need to know to use cfscript. Feedback, suggestions welcome. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Mon, Feb 20, 2012 at 12:25 PM, Cameron Childress camer...@gmail.comwrote: On Mon, Feb 20, 2012 at 10:48 AM, Robert Rhodes rrhode...@gmail.com wrote: Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. Is there a reason you want to only learn CFScript? The CFML language has so many tags and many ways of doing things. Learning only CFScript may not serve you well. Attempting to use all tags or all script is probably not the best goal IMHO. Having said that, the Adobe docs are a good starting point for learning CFScript, but if you want more than that I'd look at a regular ole CF Book like CFWACK, and then look for a CFScript equivalent for what you're doing if you really need/want one. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| 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:349969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
Hi Cameron. I know CF very well. I been coding in it for many years. But, I admit, I am a little tagged out. Cfscript feels more elegant, and as I learn more and more javascript, it seems a natural time to try to get completely up to speed on cfscript. I do wish Adobe would fill out CF so that one could write mostly in cfscript and avoid cf tags altogether, if desired. It would also help when I end up around small-minded coders who scoff at CF merely because of the tags. Yes, I have answers for those types, like how I can produce the same apps they can, but in 1/3 the time, or how Adobe puts a lot of development into the language, which gets us big upgrades every few years -- or how we can get a live body on the phone when we need one. But still, I really want to be a cfscripter, and I am looking for a path to make that happen. There must be at least a few chapters in some book out there somewhere, no? Pete, thank you very much for the cheat sheet. That will come in handy. -RR On Mon, Feb 20, 2012 at 12:25 PM, Cameron Childress camer...@gmail.comwrote: On Mon, Feb 20, 2012 at 10:48 AM, Robert Rhodes rrhode...@gmail.com wrote: Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. Is there a reason you want to only learn CFScript? The CFML language has so many tags and many ways of doing things. Learning only CFScript may not serve you well. Attempting to use all tags or all script is probably not the best goal IMHO. Having said that, the Adobe docs are a good starting point for learning CFScript, but if you want more than that I'd look at a regular ole CF Book like CFWACK, and then look for a CFScript equivalent for what you're doing if you really need/want one. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| 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:349983 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
you have cf_abort in your code instead of cf_abort() I am using cf_abort. ~| 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:349845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Looks like the issue is that you have the cf_dump() and cf_abort() calls outside of the curly braces. ok, that's a thought that I hadn't considered. I moved them inside the brackets and now I don't receive an error. Thank you! Unfortunately, I also don't receive the dump or the abort. I even built an array to dump to simplify the test and assure that there's dumpable data. sigh I guess I'm just not used to this. Maybe the logs will reveal what happened. daniel ~| 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:349846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Unfortunately, I also don't receive the dump or the abort. I even built an array to dump to simplify the test and assure that there's dumpable data. sigh I guess I'm just not used to this. Maybe the logs will reveal what happened. ok, it looks like the cf_dump() is working. If I put a cfabort inside it's function. I tried following the cf_dump() with a cf_abort for it's own function, but that didn't do the abort and I didn't see the dump (which should even display without the abort), but once I put the cfabort inside the cf_dump function, I saw the output. thank you everyone for your help. daniel ~| 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:349848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
yes, but to call cf_abort, you want to do cf_abort() It's like calling #now# instead of #now()# - Rex On 2/9/2012 5:46 AM, daniel kessler wrote: you have cf_abort in your code instead of cf_abort() I am using cf_abort. ~| 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:349851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Rex, I think cf_abort is a custom tag, not a UDF, so it would not be called using cf_abort(). -Carl On 2/9/2012 9:19 AM, Rex wrote: yes, but to call cf_abort, you want to do cf_abort() It's like calling #now# instead of #now()# - Rex On 2/9/2012 5:46 AM, daniel kessler wrote: you have cf_abort in your code instead of cf_abort() I am using cf_abort. ~| 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:349853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Nopers. Daniel has an cffunction name=cf_abort in his CFC. See his previous posts in the thread. On Thu, Feb 9, 2012 at 12:04 PM, Carl Von Stetten vonner.li...@vonner.netwrote: Rex, I think cf_abort is a custom tag, not a UDF, so it would not be called using cf_abort(). -Carl On 2/9/2012 9:19 AM, Rex wrote: yes, but to call cf_abort, you want to do cf_abort() It's like calling #now# instead of #now()# - Rex On 2/9/2012 5:46 AM, daniel kessler wrote: you have cf_abort in your code instead of cf_abort() I am using cf_abort. ~| 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:349854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Oops. I missed that. Nevermind! :-[ On 2/9/2012 10:10 AM, Matt Quackenbush wrote: Nopers. Daniel has ancffunction name=cf_abort in his CFC. See his previous posts in the thread. On Thu, Feb 9, 2012 at 12:04 PM, Carl Von Stetten vonner.li...@vonner.netwrote: Rex, I think cf_abort is a custom tag, not a UDF, so it would not be called using cf_abort(). -Carl On 2/9/2012 9:19 AM, Rex wrote: yes, but to call cf_abort, you want to do cf_abort() It's like calling #now# instead of #now()# - Rex On 2/9/2012 5:46 AM, daniel kessler wrote: you have cf_abort in your code instead of cf_abort() I am using cf_abort. ~| 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:349855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
I added this to my component, but I'm getting an error while calling it from within the component. cfcomponent hint=Replaces The Package PK_employer cffunction name=cf_abort output=false returntype=void cfabort / /cffunction cffunction name=cf_dump output=false returntype=void cfargument name=objToDump type=any required=false default= / cfdump var=#arguments.objToDump# / /cffunction Then further down, I call the cf_dump, like cf_dump(dbResult); How do I implement this correctly? Thank you for your assistance. ~| 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:349835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
To clarify, I receive an error when these function calls are used and no error
when they're commented out.
---
Invalid CFML construct found on line 78 at column 33.
ColdFusion was looking at the following text:
else
The CFML compiler was processing:
a script statement beginning with { on line 63, column 39.
a script statement beginning with if on line 63, column 17.
a cfscript tag beginning on line 52, column 18.
a cfscript tag beginning on line 52, column 18.
The error occurred in C:\localServer\beatch\cfc\emp.cfc: line 78
76 : //cf_dump(dbResult);
77 : cf_abort;
78 :else
79 :request.inStruct.beatch_id = ;
80 :
~|
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:349836
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
First off, this is a nearly 4 year old thread. It may or may not apply to
what you're working on now.
What CFML engine and version are you using?
What is the relevant code?
On Wed, Feb 8, 2012 at 1:24 PM, daniel kessler dani...@umd.edu wrote:
To clarify, I receive an error when these function calls are used and no
error when they're commented out.
---
Invalid CFML construct found on line 78 at column 33.
ColdFusion was looking at the following text:
else
The CFML compiler was processing:
a script statement beginning with { on line 63, column 39.
a script statement beginning with if on line 63, column 17.
a cfscript tag beginning on line 52, column 18.
a cfscript tag beginning on line 52, column 18.
The error occurred in C:\localServer\beatch\cfc\emp.cfc: line 78
76 : //cf_dump(dbResult);
77 : cf_abort;
78 :else
79 :request.inStruct.beatch_id = ;
80 :
~|
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:349837
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
First off, this is a nearly 4 year old thread. It may or may not apply to what you're working on now. What CFML engine and version are you using? What is the relevant code? I didn't think reposting was a good idea, since there was a thread with a relevant history. I'm using CF7. I posted the relevant code: part of the component, the cfabort/dump code, and my call. Is there more code that you would like? ~| 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:349838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
The error code mentions Line 63 as the start of an if () statement, and Line 52 as the start of the cfscript tag. We'll need probably the entire if () block at the least, as it would seem the issue lies in there. Hard to speculate based solely upon the error message, as CF is notorious for providing rather cryptic error messages which often send one off chasing ghosts. On Wed, Feb 8, 2012 at 1:37 PM, daniel kessler dani...@umd.edu wrote: First off, this is a nearly 4 year old thread. It may or may not apply to what you're working on now. What CFML engine and version are you using? What is the relevant code? I didn't think reposting was a good idea, since there was a thread with a relevant history. I'm using CF7. I posted the relevant code: part of the component, the cfabort/dump code, and my call. Is there more code that you would like? ~| 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:349839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
The error code mentions Line 63 as the start of an if () statement, and
Line 52 as the start of the cfscript tag. We'll need probably the entire
if () block at the least, as it would seem the issue lies in there.
Hard to speculate based solely upon the error message, as CF is notorious
for providing rather cryptic error messages which often send one off
chasing ghosts.
In this case, it is reporting loosely. If I comment out the cf_abort, there is
no error. So it has a problem with the cf_abort. That being a problem, messes
with the next line, the else. Since the else is part of the IF, it complains
about the whole IF. Really, it's complaining about the cf_abort, like it
doesn't know what it is.
However, the IF is several hundred lines long. Here's the relevant part up to
the 'else' that works fine with the cf_abort commented out:
if (len(arguments.inStruct.a_agent_first_name) gt 0 OR
len(arguments.inStruct.a_agent_middle_initial) gt 0 OR
len(arguments.inStruct.a_agent_last_name) gt 0 OR
len(arguments.inStruct.a_agent_firm_ein) gt
0 OR len(arguments.inStruct.a_agent_firm_name) gt 0 OR
len(arguments.inStruct.a_agent_phone) gt 0 OR
len(arguments.inStruct.a_agent_phone_ext) gt
0 OR len(arguments.inStruct.a_agent_address_1) gt 0 OR
len(arguments.inStruct.a_agent_address_2) gt 0 OR
len(arguments.inStruct.a_agent_city) gt 0 OR
len(arguments.inStruct.a_agent_state_id) gt 0 OR
len(arguments.inStruct.a_agent_province) gt 0 OR
len(arguments.inStruct.a_agent_country_id)
gt 0 OR len(arguments.inStruct.a_agent_postal_code) gt 0 OR
len(arguments.inStruct.a_agent_email) gt 0)
{
dbResult =
request.oEmployer.Ins_Agent_Tbl(arguments.inStruct);
if (dbResult eq 0,)
request.inStruct.l_agent_id =
listGetAt(dbResult,2);
else
request.inStruct.l_agent_id =
;
}
//cf_dump(dbResult);
cf_abort;
else
request.inStruct.l_agent_id = ;
~|
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:349840
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Looks like the issue is that you have the cf_dump() and cf_abort() calls
outside of the curly braces.
if ( // all those items )
{
// stuff here
}
cf_dump(dbResult);
cf_abort();
else
// other stuff
You need to move those two items inside of the }.
HTH
On Wed, Feb 8, 2012 at 2:05 PM, daniel kessler dani...@umd.edu wrote:
The error code mentions Line 63 as the start of an if () statement, and
Line 52 as the start of the cfscript tag. We'll need probably the entire
if () block at the least, as it would seem the issue lies in there.
Hard to speculate based solely upon the error message, as CF is notorious
for providing rather cryptic error messages which often send one off
chasing ghosts.
In this case, it is reporting loosely. If I comment out the cf_abort,
there is no error. So it has a problem with the cf_abort. That being a
problem, messes with the next line, the else. Since the else is part of
the IF, it complains about the whole IF. Really, it's complaining about
the cf_abort, like it doesn't know what it is.
However, the IF is several hundred lines long. Here's the relevant part
up to the 'else' that works fine with the cf_abort commented out:
if (len(arguments.inStruct.a_agent_first_name) gt 0 OR
len(arguments.inStruct.a_agent_middle_initial) gt 0 OR
len(arguments.inStruct.a_agent_last_name) gt 0 OR
len(arguments.inStruct.a_agent_firm_ein)
gt 0 OR len(arguments.inStruct.a_agent_firm_name) gt 0 OR
len(arguments.inStruct.a_agent_phone) gt 0 OR
len(arguments.inStruct.a_agent_phone_ext) gt 0 OR
len(arguments.inStruct.a_agent_address_1) gt 0 OR
len(arguments.inStruct.a_agent_address_2) gt 0 OR
len(arguments.inStruct.a_agent_city) gt
0 OR len(arguments.inStruct.a_agent_state_id) gt 0 OR
len(arguments.inStruct.a_agent_province) gt 0 OR
len(arguments.inStruct.a_agent_country_id) gt 0 OR
len(arguments.inStruct.a_agent_postal_code) gt 0 OR
len(arguments.inStruct.a_agent_email) gt 0)
{
dbResult =
request.oEmployer.Ins_Agent_Tbl(arguments.inStruct);
if (dbResult eq 0,)
request.inStruct.l_agent_id
= listGetAt(dbResult,2);
else
request.inStruct.l_agent_id
= ;
}
//cf_dump(dbResult);
cf_abort;
else
request.inStruct.l_agent_id = ;
~|
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:349842
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
you have cf_abort in your code instead of cf_abort()
On Thu, Feb 9, 2012 at 04:20, Matt Quackenbush quackfu...@gmail.com wrote:
Looks like the issue is that you have the cf_dump() and cf_abort() calls
outside of the curly braces.
if ( // all those items )
{
// stuff here
}
cf_dump(dbResult);
cf_abort();
else
// other stuff
You need to move those two items inside of the }.
HTH
On Wed, Feb 8, 2012 at 2:05 PM, daniel kessler dani...@umd.edu wrote:
The error code mentions Line 63 as the start of an if () statement, and
Line 52 as the start of the cfscript tag. We'll need probably the entire
if () block at the least, as it would seem the issue lies in there.
Hard to speculate based solely upon the error message, as CF is notorious
for providing rather cryptic error messages which often send one off
chasing ghosts.
In this case, it is reporting loosely. If I comment out the cf_abort,
there is no error. So it has a problem with the cf_abort. That being a
problem, messes with the next line, the else. Since the else is part of
the IF, it complains about the whole IF. Really, it's complaining about
the cf_abort, like it doesn't know what it is.
However, the IF is several hundred lines long. Here's the relevant part
up to the 'else' that works fine with the cf_abort commented out:
if (len(arguments.inStruct.a_agent_first_name) gt 0 OR
len(arguments.inStruct.a_agent_middle_initial) gt 0 OR
len(arguments.inStruct.a_agent_last_name) gt 0 OR
len(arguments.inStruct.a_agent_firm_ein)
gt 0 OR len(arguments.inStruct.a_agent_firm_name) gt 0 OR
len(arguments.inStruct.a_agent_phone) gt 0 OR
len(arguments.inStruct.a_agent_phone_ext) gt 0 OR
len(arguments.inStruct.a_agent_address_1) gt 0 OR
len(arguments.inStruct.a_agent_address_2) gt 0 OR
len(arguments.inStruct.a_agent_city) gt
0 OR len(arguments.inStruct.a_agent_state_id) gt 0 OR
len(arguments.inStruct.a_agent_province) gt 0 OR
len(arguments.inStruct.a_agent_country_id) gt 0 OR
len(arguments.inStruct.a_agent_postal_code) gt 0 OR
len(arguments.inStruct.a_agent_email) gt 0)
{
dbResult =
request.oEmployer.Ins_Agent_Tbl(arguments.inStruct);
if (dbResult eq 0,)
request.inStruct.l_agent_id
= listGetAt(dbResult,2);
else
request.inStruct.l_agent_id
= ;
}
//cf_dump(dbResult);
cf_abort;
else
request.inStruct.l_agent_id = ;
~|
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:349844
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFScript help
I'm attemping to create a function that adds spaces either in front of or
behind a string. For example, I want this test string to have 6 spaces after
it, plus the 4 characters in test for a total of 10 characters. I have an
align variable for both left and right alignment for the spaces. So far, the
only result I get is 'test ' instead of 'test '
CFSCRIPT
function spaceFiller(cell, fill, align) {
var newcell = ;
if (len(cell) EQ 0) {
cell = ;
}
newcell = cell;
for (i=1; i EQ len(fill - (len(cell))); i=i+1) {
if (align EQ R) {
newcell =newcell;
} else { newcell = newcell ;
}
}
return (newcell);
}
/CFSCRIPT
cfoutput
10 characters - align left: '#spaceFiller(test,10,L)#'
/cfoutput
The result I get is 'test ' and what I want is 'test '
Any help would be much appreciated - thanks in advance.
-J
~|
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:346926
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript help
I'm attemping to create a function that adds spaces either in front of or behind a string. Hi Josh, a couple of things. First, ColdFusion has the LJustify(), RJustify(), and CJustify() functions which will do exactly what you're trying to accomplish already built in. Second, your function (at a glance) appears that it would work, but when you say you're only getting one space are you referring to the actual output, or just what you see on the browser screen after the page has been rendered? Remember that in HTML, multiple spaces (or other whitespace in the output code) will get truncated down to a single space. You could wrap the output with pre/pre tags to force it to show all of the whitespace as it exists in the code, or append the HTML character entity for a space instead (nbsp;) to force multiple spaces to show in the output rendering. -Justin ~| 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:346927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript help
If you're displaying this in a browser, then HTML is likely the culprit,
condensing multiple spaces into just one. Use non-breaking spaces (or wrap
your output in pre tags) to get HTML to output multiple spaces.
On Mon, Aug 22, 2011 at 11:19 AM, Josh Cesana joshuaces...@yahoo.comwrote:
I'm attemping to create a function that adds spaces either in front of or
behind a string. For example, I want this test string to have 6 spaces
after it, plus the 4 characters in test for a total of 10 characters. I
have an align variable for both left and right alignment for the spaces.
So far, the only result I get is 'test ' instead of 'test '
CFSCRIPT
function spaceFiller(cell, fill, align) {
var newcell = ;
if (len(cell) EQ 0) {
cell = ;
}
newcell = cell;
for (i=1; i EQ len(fill - (len(cell))); i=i+1) {
if (align EQ R) {
newcell =newcell;
} else { newcell = newcell ;
}
}
return (newcell);
}
/CFSCRIPT
cfoutput
10 characters - align left: '#spaceFiller(test,10,L)#'
/cfoutput
The result I get is 'test ' and what I want is 'test '
Any help would be much appreciated - thanks in advance.
-J
~|
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:346928
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript help
just off the top of my head:
function spaceFiller(cell, fill, align) {
var space = RepeatString(' ', fill - Len(Cell));
return iif(align eq 'R', de(space cell), de(cell space));
}
You may need to deal with the scenario of cell having more characters
than the value of fill. Also, if you're spitting out html and want the
space to be visible, use white-space:pre in the css of the containing
element.
On 22 August 2011 17:19, Josh Cesana joshuaces...@yahoo.com wrote:
I'm attemping to create a function that adds spaces either in front of or
behind a string. For example, I want this test string to have 6 spaces
after it, plus the 4 characters in test for a total of 10 characters. I
have an align variable for both left and right alignment for the spaces. So
far, the only result I get is 'test ' instead of 'test '
CFSCRIPT
function spaceFiller(cell, fill, align) {
var newcell = ;
if (len(cell) EQ 0) {
cell = ;
}
newcell = cell;
for (i=1; i EQ len(fill - (len(cell))); i=i+1) {
if (align EQ R) {
newcell =newcell;
} else { newcell = newcell ;
}
}
return (newcell);
}
/CFSCRIPT
cfoutput
10 characters - align left: '#spaceFiller(test,10,L)#'
/cfoutput
The result I get is 'test ' and what I want is 'test '
Any help would be much appreciated - thanks in advance.
-J
~|
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:346929
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript help
Wow: LJustify(), RJustify(), and CJustify() functions. Who woulda thunk it. Brilliant. I guess. On 22 August 2011 17:37, Justin Scott leviat...@darktech.org wrote: I'm attemping to create a function that adds spaces either in front of or behind a string. Hi Josh, a couple of things. First, ColdFusion has the LJustify(), RJustify(), and CJustify() functions which will do exactly what you're trying to accomplish already built in. Second, your function (at a glance) appears that it would work, but when you say you're only getting one space are you referring to the actual output, or just what you see on the browser screen after the page has been rendered? Remember that in HTML, multiple spaces (or other whitespace in the output code) will get truncated down to a single space. You could wrap the output with pre/pre tags to force it to show all of the whitespace as it exists in the code, or append the HTML character entity for a space instead (nbsp;) to force multiple spaces to show in the output rendering. -Justin ~| 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:346930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript help
Wow: LJustify(), RJustify(), and CJustify() functions. Who woulda thunk it. Brilliant. I guess. Whenever I'm working with people relatively new to CF my number one piece of advice is to become very familiar with the function reference so you don't spend a bunch of time re-writing functions that are already built-in. I recall one new developer back in 2001 who spent nearly a day working on a function and ran into a snag. He asked me for help and after looking over his code for a moment I replaced his entire file with one line, a function CF already had which would do the same thing (getProfileString() in that case since he was trying to read and parse .ini files). Granted, the function list has grown by leaps and bounds with more recent releases so even more experienced developers may not be fully up-to-date in that area. The white-space directive in CSS isn't something I was aware of so even I am constantly learning. :) -Justin ~| 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:346932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript help
Thanks all - the built in function is exactly what I needed. I am fairly new to CF so I will definitely spend time learning the functions. Thanks again. ~| 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:346933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Dynamic SQL in CFScript
I've been working on a CF9 project, and I'm trying to take full advantage of the cfscript syntax for my components. I have many cases where I'm using dynamic SQL based on the existence of an optional argument in a function. In CF8 and below it'd look something like this: cffunction name=testFunc returntype=query cfargument name=testArg type=string required=false / cfquery name=testQuery datasource=testDSN SELECT * FROM TBL cfif structKeyExists(arguments.testArg) WHERE COL = '#arguments.testArg#' /cfif /cfquery cfreturn testQuery / /cffunction Is there an elegant way to do the same thing using cfscript? I haven't had any luck with string concatenation in the setSQL method of the query object (and it's kind of clunky to boot). I'd also hate to have to write two almost-identical blocks of code one with the where clause and one without and then apply the correct string to setSQL at runtime, although I assume that would solve my problem. I'd also like to use query binding, just to make things more complicated. Is there some sort of cleaner approach that I'm missing, or is this just one of the downsides to using cfscript? Thanks in advance! ~| 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:344002 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL in CFScript
Do you have the option of moving your query logic into a stored proc? It would be more secure. Jeff On Tue, Apr 26, 2011 at 2:32 PM, Kyle McLean kmclea...@gmail.com wrote: I've been working on a CF9 project, and I'm trying to take full advantage of the cfscript syntax for my components. I have many cases where I'm using dynamic SQL based on the existence of an optional argument in a function. In CF8 and below it'd look something like this: cffunction name=testFunc returntype=query cfargument name=testArg type=string required=false / cfquery name=testQuery datasource=testDSN SELECT * FROM TBL cfif structKeyExists(arguments.testArg) WHERE COL = '#arguments.testArg#' /cfif /cfquery cfreturn testQuery / /cffunction Is there an elegant way to do the same thing using cfscript? I haven't had any luck with string concatenation in the setSQL method of the query object (and it's kind of clunky to boot). I'd also hate to have to write two almost-identical blocks of code one with the where clause and one without and then apply the correct string to setSQL at runtime, although I assume that would solve my problem. I'd also like to use query binding, just to make things more complicated. Is there some sort of cleaner approach that I'm missing, or is this just one of the downsides to using cfscript? Thanks in advance! ~| 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:344003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL in CFScript
var q = new com.adobe.coldfusion.query();
q.setDatasource(cfartgallery);
var sql = select mediatype from media;
if(structKeyExists(arguments, something)) {
sql = where media like :search;
q.addParam(name=search,value=%#arguments.str#%,cfsqltype=cf_sql_varchar);
}
q.setSQL(sql);
var results = q.execute().getResult();
Does that make sense?
On Tue, Apr 26, 2011 at 1:32 PM, Kyle McLean kmclea...@gmail.com wrote:
I've been working on a CF9 project, and I'm trying to take full advantage of
the cfscript syntax for my components. I have many cases where I'm using
dynamic SQL based on the existence of an optional argument in a function. In
CF8 and below it'd look something like this:
cffunction name=testFunc returntype=query
cfargument name=testArg type=string required=false /
cfquery name=testQuery datasource=testDSN
SELECT
*
FROM
TBL
cfif structKeyExists(arguments.testArg)
WHERE
COL = '#arguments.testArg#'
/cfif
/cfquery
cfreturn testQuery /
/cffunction
Is there an elegant way to do the same thing using cfscript? I haven't had
any luck with string concatenation in the setSQL method of the query object
(and it's kind of clunky to boot). I'd also hate to have to write two
almost-identical blocks of code one with the where clause and one without and
then apply the correct string to setSQL at runtime, although I assume that
would solve my problem.
I'd also like to use query binding, just to make things more complicated. Is
there some sort of cleaner approach that I'm missing, or is this just one of
the downsides to using cfscript?
Thanks in advance!
~|
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:344004
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL in CFScript
It does, but it still looks like it's a little more clunky (in my opinion at
least :)) than the tag-based alternative. Bummer, since I much prefer the
succinct style of CFSCRIPT for writing pretty much everything else in a
component.
Thanks for your help everyone!
var q = new com.adobe.coldfusion.query();
q.setDatasource(cfartgallery);
var sql = select mediatype from media;
if(structKeyExists(arguments, something)) {
sql = where media like :search;
q.addParam(name=search,value=%#arguments.str#%,cfsqltype=cf_sql_varchar);
}
q.setSQL(sql);
var results = q.execute().getResult();
Does that make sense?
~|
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:344006
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic SQL in CFScript
On Tue, Apr 26, 2011 at 11:32 AM, Kyle McLean kmclea...@gmail.com wrote:
cfquery name=testQuery datasource=testDSN
SELECT
*
FROM
TBL
cfif structKeyExists(arguments.testArg)
WHERE
COL = '#arguments.testArg#'
/cfif
/cfquery
I know this doesn't help you, since you're on CF9, but I just wanted
to note that Railo also supports an alternative syntax that was
discussed by the CFML Advisory Committee - although, unfortunately, we
couldn't reach consensus on any proposed syntax (although we were all
in agreement that adding CFCs was... less than ideal):
query name=testQuery datasource=testDSN {
writeOutput( SELECT
*
FROM
TBL );
if ( structKeyExists(arguments.testArg) ) {
writeOutput( WHERE
COL = '#arguments.testArg#' );
}
}
Of course, it would be be better to use (cf)queryparam here, like this:
query name=testQuery datasource=testDSN {
writeOutput( SELECT
*
FROM
TBL );
if ( structKeyExists(arguments.testArg) ) {
writeOutput( WHERE
COL = ); queryparam value=#arguments.testArg# cfsqltype=varchar;
}
}
and I'd write that like this:
query name=testQuery datasource=testDSN {
writeOutput( SELECT * FROM TBL );
if ( structKeyExists(arguments.testArg) ) {
writeOutput( WHERE COL = );
queryparam value=#arguments.testArg# cfsqltype=varchar;
}
}
Still a bit ugly with the writeOutput() calls but a lot cleaner than
using the CFC, IMO.
--
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/
World Singles, LLC. -- http://worldsingles.com/
Railo Technologies, Inc. -- http://www.getrailo.com/
Perfection is the enemy of the good.
-- Gustave Flaubert, French realist novelist (1821-1880)
~|
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:344011
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser
That is the greatest thing ever. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 9 April 2011 04:55, Judah McAuley ju...@wiredotter.com wrote: Start here, Michael: http://www.pcworld.com/article/224722/new_commodore_64_is_finally_herefor_real.html ~| 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:343632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser
My frosted side wants it. On Fri, Apr 8, 2011 at 4:55 PM, Judah McAuley ju...@wiredotter.com wrote: Start here, Michael: http://www.pcworld.com/article/224722/new_commodore_64_is_finally_herefor_real.html On Thu, Apr 7, 2011 at 4:36 PM, Michael Grant mgr...@modus.bz wrote: And I'm willing to pay for a C-64 version of Halo 3. On Thu, Apr 7, 2011 at 7:20 PM, Jeff Gladnick jeff.gladn...@gmail.com wrote: I actually don't hate cfscript, but I do hate that we have both tags and script based syntax for CFML. And since it started off as tags, I firmly believe that's the way it should stay. I understand lots of people feel differently, but it really sucks (for me) seeing all the new great open source projects being released in cfscript. Therefore I have created a $1000 bounty (I have pledged $250) to the first developer who can deliver a working cfscript -- cftag based parser for eclipse. http://www.pledgebank.com/CFScriptSucks People can still write in cfscript if they want to, but people who feel like me won't have to deal with it anymore. Please post flames below ~| 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:343633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser
Start here, Michael: http://www.pcworld.com/article/224722/new_commodore_64_is_finally_herefor_real.html On Thu, Apr 7, 2011 at 4:36 PM, Michael Grant mgr...@modus.bz wrote: And I'm willing to pay for a C-64 version of Halo 3. On Thu, Apr 7, 2011 at 7:20 PM, Jeff Gladnick jeff.gladn...@gmail.comwrote: I actually don't hate cfscript, but I do hate that we have both tags and script based syntax for CFML. And since it started off as tags, I firmly believe that's the way it should stay. I understand lots of people feel differently, but it really sucks (for me) seeing all the new great open source projects being released in cfscript. Therefore I have created a $1000 bounty (I have pledged $250) to the first developer who can deliver a working cfscript -- cftag based parser for eclipse. http://www.pledgebank.com/CFScriptSucks People can still write in cfscript if they want to, but people who feel like me won't have to deal with it anymore. Please post flames below ~| 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:343631 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser
I actually don't hate cfscript, but I do hate that we have both tags and script based syntax for CFML. And since it started off as tags, I firmly believe that's the way it should stay. I understand lots of people feel differently, but it really sucks (for me) seeing all the new great open source projects being released in cfscript. Therefore I have created a $1000 bounty (I have pledged $250) to the first developer who can deliver a working cfscript -- cftag based parser for eclipse. http://www.pledgebank.com/CFScriptSucks People can still write in cfscript if they want to, but people who feel like me won't have to deal with it anymore. Please post flames below. ~| 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:343605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser
And I'm willing to pay for a C-64 version of Halo 3. On Thu, Apr 7, 2011 at 7:20 PM, Jeff Gladnick jeff.gladn...@gmail.comwrote: I actually don't hate cfscript, but I do hate that we have both tags and script based syntax for CFML. And since it started off as tags, I firmly believe that's the way it should stay. I understand lots of people feel differently, but it really sucks (for me) seeing all the new great open source projects being released in cfscript. Therefore I have created a $1000 bounty (I have pledged $250) to the first developer who can deliver a working cfscript -- cftag based parser for eclipse. http://www.pledgebank.com/CFScriptSucks People can still write in cfscript if they want to, but people who feel like me won't have to deal with it anymore. Please post flames below. ~| 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:343606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
