NullPointer exceptions

2010-02-11 Thread Tom McNeer

Hi,

I have a relatively complex application that uses a Flex app as a front end.
Recently, I have begun to see a spate of NullPointerExceptions being
generated when methods are called from the Flex app. The calls are
Flash/Flex Remoting calls, not directly to Blaze.

I have seen these on both CF8 and 9, although they seem more frequent on
CF9. (I'm aware that CF9 uses Blaze under the hood for its Flash Remoting.)

These errors are not consistent. They do not necessarily occur every time a
method is fired. I have seen instances where the same method is called twice
within a second, with the same parameters, and the first request generates a
NullPointerException, while the second returns correctly. Sometimes,
however, it seems as if a given method begins returning the exception in all
cases. But the next day, the same method may work fine.

The CF side uses Transfer and Coldspring. In both cases, I'm using the most
recent stable release. For Transfer, that means 1.1g, which is built to work
with CF9.

Since the exceptions are pretty opaque (they only reference templates within
the core CF files, not my application files), and the occurrence is
inconsistent, I'm having a problem even guessing what might be going on. The
best I can do is suppose that the problem is occurring within the gateway,
since I've never had a problem calling the same methods via a .cfm page
during testing. A few of the errors do suggest that the problem occurred
during the gateway's serialization of an object; but many don't.

Any thoughts would be very welcome at this point. I'll be happy to provide
any further information that someone thinks might be helpful.

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330582
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Code Review?

2010-02-11 Thread Glyn Jackson

yep the error was because of a users firewall not sending the http_referer so 
the value was - which mid function does not like. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330583
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: NullPointer exceptions

2010-02-11 Thread Brad Wood

Can you give us a sample stack trace for one of the errors?

~Brad

- Original Message - 
From: Tom McNeer tmcn...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, February 11, 2010 8:00 AM
Subject: NullPointer exceptions



 Hi,

 I have a relatively complex application that uses a Flex app as a front 
 end.
 Recently, I have begun to see a spate of NullPointerExceptions being
 generated when methods are called from the Flex app. The calls are
 Flash/Flex Remoting calls, not directly to Blaze.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330584
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


sample ldap

2010-02-11 Thread fun and learning

Hi All,

Is there a sample or example ldap for learning purposes? I am learning LDAP for 
implementing in Coldfusion

Thanks 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330585
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: sample ldap

2010-02-11 Thread Jochem van Dieten

To learn LDAP I would recommend downloading Softerra LDAP Browser and
doing a full install. The tool is useful to explore LDAP but if you do
a full install it sets up some connections to public LDAP servers.
Also, if you are in a Windows domain every Domain Controller is an
LDAP server.

Jochem


On 2/11/10, fun and learning funandlrnn...@gmail.com wrote:

 Hi All,

 Is there a sample or example ldap for learning purposes? I am learning LDAP
 for implementing in Coldfusion

 Thanks

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330586
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: sample ldap

2010-02-11 Thread Brad Wood

http://www.google.com/search?hl=ensource=hpq=coldfusion+ldap+example

The first result looks pretty comprehensive.

http://www.15seconds.com/issue/020710.htm

~Brad

- Original Message - 
From: fun and learning funandlrnn...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, February 11, 2010 8:37 AM
Subject: sample ldap



 Hi All,

 Is there a sample or example ldap for learning purposes? I am learning 
 LDAP for implementing in Coldfusion

 Thanks

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330587
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cfinsert multiple records into DB

2010-02-11 Thread Barry Mcconaghey

Hello Everybody.

I'm trying to build a form that only has one cfselect or drop-down menu option 
on my website. Right now I have two cfselect but I would like to only display 
the first cfselect (player). The second cfselect (contactID) I would like to 
hide. The player selected in the first cfselect should match the second 
cfselect contactID and go to the action page.

cfform name=AllPlayers action=AddPlayers.cfm

cfselect name=player size=1

cfoutput query=contacts
   option value=#FirstName# #LastName##FirstName# #LastName#/option
/cfoutput

/cfselect

cfselect name=contactid size=1

cfoutput query=contacts
   option value=#contactid#(#contactid#) #FirstName# #LastName#/option
/cfoutput

/cfselect

/cfform

Action page - addplayers.cfm

cfinsert datasource=mydatabase
 tablename=player
 formfields=contactID, player

Thanks,

Barry 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330588
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: NullPointer exceptions

2010-02-11 Thread Tom McNeer

On Thu, Feb 11, 2010 at 9:40 AM, Brad Wood b...@bradwood.com wrote:


 Can you give us a sample stack trace for one of the errors?


Sure. But hang on - they're long.

This one is from the CF exception log:

=
Error,jrpp-3,02/10/10,22:38:05,,
java.lang.NullPointerException
at coldfusion.util.Utils.getServletPath(Utils.java:86)
at coldfusion.util.Utils.getServletPath(Utils.java:76)
at coldfusion.util.Utils.getBaseTemplatePath(Utils.java:405)
at
coldfusion.runtime.TemplateProxyFactory.getTemplateFileHelper(TemplateProxyFactory.java:1514)
at
coldfusion.runtime.MetadataUtils.getComponentMetadata(MetadataUtils.java:112)
at
coldfusion.runtime.CfJspPage.GetComponentMetaData(CfJspPage.java:2667)
at
coldfusion.runtime.TemplateProxy.getRuntimeComponentMetadata(TemplateProxy.java:1755)
at
coldfusion.runtime.TemplateProxy.getRuntimeMetadata(TemplateProxy.java:1616)
at coldfusion.runtime.MetadataUtils.getMetaData(MetadataUtils.java:54)
at coldfusion.runtime.CfJspPage.GetMetaData(CfJspPage.java:2640)
at
cfAbstractBaseMeta2ecfc803585718$funcCLONE.runFunction(C:\webApps\frameworks\transfer\com\object\AbstractBaseMeta.cfc:33)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360)
at
cfAbstractBaseMeta2ecfc803585718$funcCLONEARRAY.runFunction(C:\webApps\frameworks\transfer\com\object\AbstractBaseMeta.cfc:68)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582)
at
cfObject2ecfc557319487$funcSETINSTANCE.runFunction(C:\webApps\frameworks\transfer\com\object\Object.cfc:865)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360)
at
cfAbstractBaseMeta2ecfc803585718$funcCLONE.runFunction(C:\webApps\frameworks\transfer\com\object\AbstractBaseMeta.cfc:37)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360)
at
cfObjectManager2ecfc882164338$funcGETOBJECTLAZYONETOMANY.runFunction(C:\webApps\frameworks\transfer\com\object\ObjectManager.cfc:153)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
at 

RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray

First the CFinsert should be avoided, it limits you.  Writing your own SQL is 
easy.

I would replace the value of the option in the player select with the ID not 
the First and Last name.  You can delete your second select since the ID 
represents the First and Last name.

cfoutput query=contacts
   option value=#contacts.contactID##contacts.FirstName# 
#contacts.LastName#/option
/cfoutput

Then before you do your insert query the FirstName and LastName with the ID 
then do your insert.  These queries are assuming your contactid in the database 
is numeric datatype and the contactID represents the first and last name.

action page:

cfquery datasource=mydatabase name=getFirstAndLast
SELECT FirstName, LastName
FROM player
WHERE contactid = #FORM.contactID#
/cfquery

cfquery datasource=mydatabase name=insertPlayer
INSERT player (contactID, player)
VALUES (#FORM.contactID#, '#getFirstAndLast.FirstName# 
#getFirstAndLast.LastName#')
/cfquery

Try to always scope your variables by adding FORM. nameOfQuery. Etc. in front 
of your variables.  This will create much more precise code for you in the 
future as you learn more.


-Original Message-
From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] 
Sent: Thursday, February 11, 2010 9:47 AM
To: cf-talk
Subject: cfinsert multiple records into DB


Hello Everybody.

I'm trying to build a form that only has one cfselect or drop-down menu option 
on my website. Right now I have two cfselect but I would like to only display 
the first cfselect (player). The second cfselect (contactID) I would like to 
hide. The player selected in the first cfselect should match the second 
cfselect contactID and go to the action page.

cfform name=AllPlayers action=AddPlayers.cfm

cfselect name=player size=1

cfoutput query=contacts
   option value=#FirstName# #LastName##FirstName# #LastName#/option
/cfoutput

/cfselect

cfselect name=contactid size=1

cfoutput query=contacts
   option value=#contactid#(#contactid#) #FirstName# #LastName#/option
/cfoutput

/cfselect

/cfform

Action page - addplayers.cfm

cfinsert datasource=mydatabase
 tablename=player
 formfields=contactID, player

Thanks,

Barry 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330590
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray

Whoops, I noticed a bug in my code.  You should use FORM.player not 
FORM.contactid in the two CFQuery's since the name of the select is player.



-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com] 
Sent: Thursday, February 11, 2010 11:11 AM
To: cf-talk
Subject: RE: cfinsert multiple records into DB


First the CFinsert should be avoided, it limits you.  Writing your own SQL is 
easy.

I would replace the value of the option in the player select with the ID not 
the First and Last name.  You can delete your second select since the ID 
represents the First and Last name.

cfoutput query=contacts
   option value=#contacts.contactID##contacts.FirstName# 
#contacts.LastName#/option
/cfoutput

Then before you do your insert query the FirstName and LastName with the ID 
then do your insert.  These queries are assuming your contactid in the database 
is numeric datatype and the contactID represents the first and last name.

action page:

cfquery datasource=mydatabase name=getFirstAndLast
SELECT FirstName, LastName
FROM player
WHERE contactid = #FORM.contactID#
/cfquery

cfquery datasource=mydatabase name=insertPlayer
INSERT player (contactID, player)
VALUES (#FORM.contactID#, '#getFirstAndLast.FirstName# 
#getFirstAndLast.LastName#')
/cfquery

Try to always scope your variables by adding FORM. nameOfQuery. Etc. in front 
of your variables.  This will create much more precise code for you in the 
future as you learn more.


-Original Message-
From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] 
Sent: Thursday, February 11, 2010 9:47 AM
To: cf-talk
Subject: cfinsert multiple records into DB


Hello Everybody.

I'm trying to build a form that only has one cfselect or drop-down menu option 
on my website. Right now I have two cfselect but I would like to only display 
the first cfselect (player). The second cfselect (contactID) I would like to 
hide. The player selected in the first cfselect should match the second 
cfselect contactID and go to the action page.

cfform name=AllPlayers action=AddPlayers.cfm

cfselect name=player size=1

cfoutput query=contacts
   option value=#FirstName# #LastName##FirstName# #LastName#/option
/cfoutput

/cfselect

cfselect name=contactid size=1

cfoutput query=contacts
   option value=#contactid#(#contactid#) #FirstName# #LastName#/option
/cfoutput

/cfselect

/cfform

Action page - addplayers.cfm

cfinsert datasource=mydatabase
 tablename=player
 formfields=contactID, player

Thanks,

Barry 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330591
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray

Hehe, another bug, your select query should be querying the contact table not 
the player table.

HTH, and I have not confused the heck of you.
Chad

-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com] 
Sent: Thursday, February 11, 2010 11:15 AM
To: cf-talk
Subject: RE: cfinsert multiple records into DB


Whoops, I noticed a bug in my code.  You should use FORM.player not 
FORM.contactid in the two CFQuery's since the name of the select is player.



-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com] 
Sent: Thursday, February 11, 2010 11:11 AM
To: cf-talk
Subject: RE: cfinsert multiple records into DB


First the CFinsert should be avoided, it limits you.  Writing your own SQL is 
easy.

I would replace the value of the option in the player select with the ID not 
the First and Last name.  You can delete your second select since the ID 
represents the First and Last name.

cfoutput query=contacts
   option value=#contacts.contactID##contacts.FirstName# 
#contacts.LastName#/option
/cfoutput

Then before you do your insert query the FirstName and LastName with the ID 
then do your insert.  These queries are assuming your contactid in the database 
is numeric datatype and the contactID represents the first and last name.

action page:

cfquery datasource=mydatabase name=getFirstAndLast
SELECT FirstName, LastName
FROM player
WHERE contactid = #FORM.contactID#
/cfquery

cfquery datasource=mydatabase name=insertPlayer
INSERT player (contactID, player)
VALUES (#FORM.contactID#, '#getFirstAndLast.FirstName# 
#getFirstAndLast.LastName#')
/cfquery

Try to always scope your variables by adding FORM. nameOfQuery. Etc. in front 
of your variables.  This will create much more precise code for you in the 
future as you learn more.


-Original Message-
From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] 
Sent: Thursday, February 11, 2010 9:47 AM
To: cf-talk
Subject: cfinsert multiple records into DB


Hello Everybody.

I'm trying to build a form that only has one cfselect or drop-down menu option 
on my website. Right now I have two cfselect but I would like to only display 
the first cfselect (player). The second cfselect (contactID) I would like to 
hide. The player selected in the first cfselect should match the second 
cfselect contactID and go to the action page.

cfform name=AllPlayers action=AddPlayers.cfm

cfselect name=player size=1

cfoutput query=contacts
   option value=#FirstName# #LastName##FirstName# #LastName#/option
/cfoutput

/cfselect

cfselect name=contactid size=1

cfoutput query=contacts
   option value=#contactid#(#contactid#) #FirstName# #LastName#/option
/cfoutput

/cfselect

/cfform

Action page - addplayers.cfm

cfinsert datasource=mydatabase
 tablename=player
 formfields=contactID, player

Thanks,

Barry 







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330592
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Upgrade from CF 8 multiserver to CF 9.

2010-02-11 Thread Fabio Serra

Ok, I decided to upgrade from CF 8 multiserver to CF 9.
I want to use CF 9 only for new applications, the old ones should continue to 
run with CF 8.
So, I tried to install CF 9 Multiserver but it detect a previous JRun 
installation and prevent me to continue.
Is there any way to upgrade only the underlying JRun mantaining all the current 
CF 8 instances? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330593
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Upgrade from CF 8 multiserver to CF 9.

2010-02-11 Thread Dave Watts

 Ok, I decided to upgrade from CF 8 multiserver to CF 9.
 I want to use CF 9 only for new applications, the old ones should continue to 
 run with CF 8.
 So, I tried to install CF 9 Multiserver but it detect a previous JRun 
 installation and prevent me to continue.
 Is there any way to upgrade only the underlying JRun mantaining all the 
 current CF 8 instances?

No, to the best of my knowledge, you'd need to uninstall CF 8
entirely, then install CF 9 multiserver, then install CF 8 EARs as
needed.

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.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330594
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


SQL Windows Authentication

2010-02-11 Thread Blizzm

Hi Everyone,

A majority of our data sources are connected via SQL authenticated accounts.  
This has been the norm established by previous developers and IT folk at my 
company.  Lately, there has been discussion about using Windows authenticated 
accounts instead, due to the 'better' Windows security etc.  My understanding 
is that the CF service can't simply connect to a data source in this manner 
because the service needs to be run as an actual domain account before a 
connection could be established?  That and modifying IIS, drivers, ODBC 
connection seem to follow suit.

This has turned into a confusing topic for some of our staff who believe that 
simply creating multiple domain accounts with access to SQL server would solve 
the CF-SQL Windows authentication issue.  These accounts have yet to work and I 
believe it's because of the reasons mentioned above.

If the CF service needs to run as a domain account and all the configurations 
are applied, then can this be the only account that can be used?  

Any thoughts and input are greatly appreciated.





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330595
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Importing large text log file into SQL Server 2005

2010-02-11 Thread Ian Skinner

Not a ColdFusion specific question, other then that I will write some
ColdFusion templates to report the data once I have it imported.  But
the HOF groups are just such a great resource.  Repeated here as the SQL
list seems a bit quite.

It has been quite some time since I have worked with SQL Server.  I
would like to import a large (~673MB) text log file into a table.  The
fields in the text file are space[ ] deliminated.  The first two fields
are a date string and a time string.  I would like to combine these two
fields into a single datetime field in the database table.  I am finding
this surprisingly difficult to do.  There does not seem to be any way to
concatenate the first two fields of the text file into one field with
the SQL Server Import and Export Wizard in the SQL Server Management Studio.

I have a bulk loader example that would theoretically import this data
as well, but it also assumes a one to one relationship between the text
fields and the table fields.
BULK INSERT dprmisc.iis.weblog1 FROM 'c:\IIS Tools\preplog\allsites.log'
WITH ( FIELDTERMINATOR = ' ', ROWTERMINATOR = '\n' )

I could probably write a SQL insert statement, but I don't know how to
access a flat text file with SQL inside the Management Studio tools.

Any help or sugestions would be appreciated, or do I just have to give
up on this dream and seperate the date and the time values in the
database table?


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330596
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SQL Windows Authentication

2010-02-11 Thread Dave Watts

 A majority of our data sources are connected via SQL authenticated accounts.  
 This has been the norm established by previous
 developers and IT folk at my company.  Lately, there has been discussion 
 about using Windows authenticated accounts instead,
 due to the 'better' Windows security etc.  My understanding is that the CF 
 service can't simply connect to a data source in this
 manner because the service needs to be run as an actual domain account before 
 a connection could be established?  That and
 modifying IIS, drivers, ODBC connection seem to follow suit.

 This has turned into a confusing topic for some of our staff who believe that 
 simply creating multiple domain accounts with access
 to SQL server would solve the CF-SQL Windows authentication issue.  These 
 accounts have yet to work and I believe it's
 because of the reasons mentioned above.

 If the CF service needs to run as a domain account and all the configurations 
 are applied, then can this be the only account that
 can be used?

CF can use Windows authentication to connect to SQL Server:

http://kb2.adobe.com/cps/000/1a3c2ad0.html

CF uses the account you use to run the CF service, so only one account
can be used per CF instance.

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 on

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330597
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Possible switch to CFEclipse

2010-02-11 Thread Tony Bentley

There is quite a difference with DreamWeaver / HomeSite versus Eclipse.

If you are strictly developing ColdFusion code, you might be better off staying 
with a simpler IDE or waiting for the stand alone CFBuilder. I use a bunch of 
other plugins in Eclipse such as egit, svn, aptana, mylyn and all of the java 
based plugins (groovy, junit, jautodoc, etc) so using a ColdFusion plugin only 
simplifies the coding process. 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330598
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Importing large text log file into SQL Server 2005

2010-02-11 Thread Dorioo

Maybe you can populate the datetime column after it's bulk inserted.
Something like below where you'd play around with Convert function
to match the format of the the string column1 + column2.

UPDATE table
SET concactenatedDateTimeColumn = CONVERT(datetime, column1 + column2)

- Gabriel

On Thu, Feb 11, 2010 at 11:41 AM, Ian Skinner h...@ilsweb.com wrote:

 Not a ColdFusion specific question, other then that I will write some
 ColdFusion templates to report the data once I have it imported.  But
 the HOF groups are just such a great resource.  Repeated here as the SQL
 list seems a bit quite.

 It has been quite some time since I have worked with SQL Server.  I
 would like to import a large (~673MB) text log file into a table.  The
 fields in the text file are space[ ] deliminated.  The first two fields
 are a date string and a time string.  I would like to combine these two
 fields into a single datetime field in the database table.  I am finding
 this surprisingly difficult to do.  There does not seem to be any way to
 concatenate the first two fields of the text file into one field with
 the SQL Server Import and Export Wizard in the SQL Server Management Studio.

 I have a bulk loader example that would theoretically import this data
 as well, but it also assumes a one to one relationship between the text
 fields and the table fields.
 BULK INSERT dprmisc.iis.weblog1 FROM 'c:\IIS Tools\preplog\allsites.log'
 WITH ( FIELDTERMINATOR = ' ', ROWTERMINATOR = '\n' )

 I could probably write a SQL insert statement, but I don't know how to
 access a flat text file with SQL inside the Management Studio tools.

 Any help or sugestions would be appreciated, or do I just have to give
 up on this dream and seperate the date and the time values in the
 database table?


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330599
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Upgrade from CF 8 multiserver to CF 9.

2010-02-11 Thread Matt Quackenbush

http://www.quackfuzed.com/index.cfm/2009/10/18/Learning-CF9-Installing-CF9-Alongside-CF8


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330600
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: NullPointer exceptions

2010-02-11 Thread Brad Wood

Hmm, looks like the error happened while getMetaData was being called from 
Transfer.

Have you posted this on the Transfer list?

Also, out of curiosity, are you using trusted cache?

~Brad

- Original Message - 
From: Tom McNeer tmcn...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, February 11, 2010 8:54 AM
Subject: Re: NullPointer exceptions



 On Thu, Feb 11, 2010 at 9:40 AM, Brad Wood b...@bradwood.com wrote:


 Can you give us a sample stack trace for one of the errors?


 Sure. But hang on - they're long.

 This one is from the CF exception log:

 =
 Error,jrpp-3,02/10/10,22:38:05,,
 java.lang.NullPointerException
at coldfusion.util.Utils.getServletPath(Utils.java:86)
at coldfusion.util.Utils.getServletPath(Utils.java:76)
at coldfusion.util.Utils.getBaseTemplatePath(Utils.java:405)
at
 coldfusion.runtime.TemplateProxyFactory.getTemplateFileHelper(TemplateProxyFactory.java:1514)
at
 coldfusion.runtime.MetadataUtils.getComponentMetadata(MetadataUtils.java:112)
at
 coldfusion.runtime.CfJspPage.GetComponentMetaData(CfJspPage.java:2667)
at
 coldfusion.runtime.TemplateProxy.getRuntimeComponentMetadata(TemplateProxy.java:1755)
at
 coldfusion.runtime.TemplateProxy.getRuntimeMetadata(TemplateProxy.java:1616)
at coldfusion.runtime.MetadataUtils.getMetaData(MetadataUtils.java:54)
at coldfusion.runtime.CfJspPage.GetMetaData(CfJspPage.java:2640)
at
 cfAbstractBaseMeta2ecfc803585718$funcCLONE.runFunction(C:\webApps\frameworks\transfer\com\object\AbstractBaseMeta.cfc:33)


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330601
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFFTP copy command?

2010-02-11 Thread James Wolfe

Is there any way to copy a file on the FTP server from 

   /directory1/fileName.mp3 
   to 
   /directory2/fileName.mp3

without downloading it to my machine?

Again, I want a COPY (not a move).

Thanks,
James 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330602
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Line debugging question

2010-02-11 Thread Susan Gallegos

That would have been great but the site seems to be down.
Thanks
Susan

-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com] 
Sent: Wednesday, February 10, 2010 5:46 PM
To: cf-talk
Subject: Re: Line debugging question


I can't believe they made this possible

Anyways, here is the fix:

http://www.oscararevalo.com/index.cfm/2007/10/21/Changin-CF8-Debugger-Port 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330603
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Line debugging question

2010-02-11 Thread Susan Gallegos

Dave,
What do you mean when you say to run CF as an application?
Susan

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, February 10, 2010 4:54 PM
To: cf-talk
Subject: Re: Line debugging question


 When I use the default port (5505 I think) for line debugging, I cannot
restart the CF service. I used netstat -a and it was not on
 the list. Now what do I do - do I have to reinstall CF?

In the worst case, you could remove the bit from jvm.config that
enables debugging. Alternatively, you could try running CF as an
application, and see where it breaks down during startup.

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.



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330604
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Line debugging question

2010-02-11 Thread Tony Bentley

http://74.125.155.132/search?q=cache:rSrE7Xr-WzkJ:www.oscararevalo.com/index.cfm/2007/10/21/Changin-CF8-Debugger-Port+http://www.oscararevalo.com/index.cfm/2007/10/21/Changin-CF8-Debugger-Portcd=1hl=enct=clnkgl=usclient=firefox-a
 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330605
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Line debugging question

2010-02-11 Thread brad

I beleive he means run it from a command line.  That way you can see any
error messages being output to the console on startup.

For the life of me, I don't have the syntax handy.

~Brad


 Original Message 
Subject: RE: Line debugging question
From: Susan Gallegos galle...@ag.arizona.edu
Date: Thu, February 11, 2010 12:06 pm
To: cf-talk cf-talk@houseoffusion.com


Dave,
What do you mean when you say to run CF as an application?
Susan



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330606
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFFTP copy command? - Found word(s) mp3 in the Text body

2010-02-11 Thread Paul Alkema

Hey James,
If your trying to copy to an outside server you could use CFFTP's
action=putfile command.

After opening a connection I use something like this...

cfftp 
action=putfile 
connection=MyConnection 
localfile=local path of file to copy 
remotefile=remote path of where to copy too 
transfermode=binary 
stoponerror=no 
timeout=3600 
failifexists=no 
retrycount=10




If you just want to copy it locally form one folder to another use cffile's
action=copy command.
http://livedocs.adobe.com/coldfusion/8/Tags_f_04.html



-Original Message-
From: James Wolfe [mailto:james-cft...@goqs.com] 
Sent: Thursday, February 11, 2010 12:29 PM
To: cf-talk
Subject: CFFTP copy command? - Found word(s) mp3 in the Text body


Is there any way to copy a file on the FTP server from 

   /directory1/fileName.mp3 
   to 
   /directory2/fileName.mp3

without downloading it to my machine?

Again, I want a COPY (not a move).

Thanks,
James 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330607
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Possible switch to CFEclipse

2010-02-11 Thread Gerald Guido

I am currently using Homesite+ for my IDE a

I made that leap a couple of years ago. This is my rig that I have been
tweeking for the last couple of years and the what and why of what I use
for CF/Web work.

One thing to remember with Eclipse. More Plugins = More ram. I also make it
a habit to jack up the RAM allotted to Eclipse from 256 megs to 512 in the
eclipse.ini file. This will speed things up considerably.

I start off with the PHP Eclipse distro because, well, I work with PHP a
lot. But even if I didn't, it has a lot of the basic tools I use for web
dev. Like support for XAMPP, Mysql etc

Then I add the Aptana plugin and add it's plugins for Ajax, SVN, AIR support
and what ever tickles my fancy at that moment. Some people are very vocal
against Aptana (I mean some people just flat out despise it) . It has a
nasty habit of firing up it's start up page every time you load it.  You can
turn this off by going to:

Window  Preferences Aapata  Start up page  and disable the start up
page

If you ask me, Aptana is fantastic for working with (X)HTML, CSS, JS, Ajax,
and in particular it's jQuery/JS support. It provides auto suggest, auto
complete and inline help CSS, html, JS including all of the major AJAX/JS
libraries as well as (inspection) for your own custom JS Libraries (and help
as long as you document them). I really like it's CSS editor a lot.

Then I add the Adobe CF 8.1 plugins and plop the CF 8.1 docs in the Plugins
folder for good measure.

Then Finally I install CFEclipse.

I also Use XMLBuddy a lot because, well, I like it.

Good luck.

G!

On Wed, Feb 10, 2010 at 9:23 PM, Terry Troxel te...@it-werks.com wrote:


 I do not want to start a flame here, just get some information to help me
 make a decision.
 I am using CF8 and not yet ready for CF9. I am currently using Homesite+
 for
 my IDE and would like to know what the requirements are for installing
 Eclipse and CFEclipse on my 32 bit dual core laptop w/3 gigs of ram.
 I do not know anyone who is currently using it which is why I am asking
 here. I do not do any Java programming at all and am planning on using it
 to
 replace Homesite if that is possible and maybe get some advise from all of
 you.
 If you recommend Eclipse, which package and other plugins do I need as
 well?

 Terry



 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330608
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Line debugging question

2010-02-11 Thread Susan Gallegos

Thanks!!

-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com] 
Sent: Thursday, February 11, 2010 11:06 AM
To: cf-talk
Subject: [SPAM] Re: Line debugging question
Importance: Low


http://74.125.155.132/search?q=cache:rSrE7Xr-WzkJ:www.oscararevalo.com/index
.cfm/2007/10/21/Changin-CF8-Debugger-Port+http://www.oscararevalo.com/index.
cfm/2007/10/21/Changin-CF8-Debugger-Portcd=1hl=enct=clnkgl=usclient=fir
efox-a 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330609
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFFTP copy command? - Found word(s) mp3 in the Text body

2010-02-11 Thread brad

 If your trying to copy to an outside server you could use CFFTP's
 action=putfile command.

Since he said without downloading it to my machine I think he means
both the source and the destination are on the FTP server.

 If you just want to copy it locally form one folder to another use cffile's
 action=copy command.

Again, cffile only works on a local file system-- not an FTP server.

@James, as far as I know you are out of luck unless you have some other
way to access the remote server (SSH, etc).  I refrained from answering
originally to see if there really was a way to do that.  As basic as a
copy from a remote location to another remote location seems- I think
the fact of the matter is that FTP was designed to move files between a
local and remote endpoints-- not to comprehensively manage remote files.

~Brad





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330610
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfinsert multiple records into DB

2010-02-11 Thread Barry Mcconaghey

Thanks Chad!

It worked.

Question...how do I add more input fields.

I would like to add this to my final code:

input type=text size=40 name=carpool_location /

Final code that works:

cfselect name=player size=1
cfoutput query=contacts
  option value=#contacts.contactID##contacts.FirstName# 
#contacts.LastName#/option
/cfoutput
/cfselect

Action page:

cfquery datasource=mydb name=getFirstAndLast
SELECT FirstName, LastName
FROM contacts
WHERE contactid = #FORM.player#
/cfquery

cfquery datasource=mydb name=insertPlayer
INSERT player (contactID, player)
VALUES (#FORM.player#,'#getFirstAndLast.FirstName# #getFirstAndLast.LastName#')
/cfquery 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330611
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray

Just keep adding them to the form then on your action page you get their value 
like this:

#FORM.carpool_location#

-Original Message-
From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] 
Sent: Thursday, February 11, 2010 2:07 PM
To: cf-talk
Subject: Re: cfinsert multiple records into DB


Thanks Chad!

It worked.

Question...how do I add more input fields.

I would like to add this to my final code:

input type=text size=40 name=carpool_location /

Final code that works:

cfselect name=player size=1
cfoutput query=contacts
  option value=#contacts.contactID##contacts.FirstName# 
#contacts.LastName#/option
/cfoutput
/cfselect

Action page:

cfquery datasource=mydb name=getFirstAndLast
SELECT FirstName, LastName
FROM contacts
WHERE contactid = #FORM.player#
/cfquery

cfquery datasource=mydb name=insertPlayer
INSERT player (contactID, player)
VALUES (#FORM.player#,'#getFirstAndLast.FirstName# #getFirstAndLast.LastName#')
/cfquery 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330612
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfinsert multiple records into DB

2010-02-11 Thread Leigh

 
 Final code that works:
 
 WHERE contactid = #FORM.player#

I would also suggest using cfqueryparam for a variety of reasons, including 
some limited sql injection protection. 
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_18.html

-Leigh



  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330613
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfinsert multiple records into DB

2010-02-11 Thread Barry Mcconaghey

I'm getting an error message.

I added this inside my CFFORM

input type=text size=40 name=carpool_location /

Action page:

cfquery datasource=mydb name=getFirstAndLast
SELECT FirstName, LastName
FROM contacts
WHERE contactid = #FORM.player#
/cfquery

cfquery datasource=mydb name=insertPlayer
INSERT player (contactID, player, carpool_location)
VALUES (#FORM.player#,'#getFirstAndLast.FirstName# #getFirstAndLast.LastName#', 
#FORM.carpool_location#)
/cfquery 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330614
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFFTP copy command? - Found word(s) mp3 in the Text body

2010-02-11 Thread denstar

The ftp command rename should do it, if it's exposed to the tag (I
don't do ftp, so don't know).

If it isn't, I guess it's java-land for you!  (Or just some other solution.)

:denny

-- 
Humility is truth.
Desiderius Erasmus

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330615
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: cfinsert multiple records into DB

2010-02-11 Thread Chad Gray

Carpool_location is probably a string data type in the database?  Strings need 
to be surrounded by single quotes.

I would do like Leigh suggested.  It is best practice to use cfqueryparam.  
You may need to adjust the cfsqltype to what you database fields are.  I 
guessed numeric and varchar.

cfquery datasource=mydb name=getFirstAndLast
SELECT FirstName, LastName
FROM contacts
WHERE contactid = cfqueryparam cfsqltype=cf_sql_numeric 
value=#FORM.player#
/cfquery

cfquery datasource=mydb name=insertPlayer
INSERT player (contactID, player, carpool_location)
VALUES (cfqueryparam cfsqltype=cf_sql_numeric value=#FORM.player#,
cfqueryparam cfsqltype=cf_sql_varchar 
value=#getFirstAndLast.FirstName# #getFirstAndLast.LastName#, 
cfqueryparam cfsqltype=cf_sql_varchar 
value=#FORM.carpool_location#)
/cfquery


-Original Message-
From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] 
Sent: Thursday, February 11, 2010 2:43 PM
To: cf-talk
Subject: Re: cfinsert multiple records into DB


I'm getting an error message.

I added this inside my CFFORM

input type=text size=40 name=carpool_location /

Action page:

cfquery datasource=mydb name=getFirstAndLast
SELECT FirstName, LastName
FROM contacts
WHERE contactid = #FORM.player#
/cfquery

cfquery datasource=mydb name=insertPlayer
INSERT player (contactID, player, carpool_location)
VALUES (#FORM.player#,'#getFirstAndLast.FirstName# #getFirstAndLast.LastName#', 
#FORM.carpool_location#)
/cfquery 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330616
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Possible switch to CFEclipse

2010-02-11 Thread Matthew Williams

The only thing I've yet found that Eclipse + plugins can do for me is 
WYSIWIG page development.  I still keep a copy of Dreamweaver around for 
that.  However, I've not really looked that hard to find a plugin in the 
last two years.  Maybe something has risen to the challenge.  Everything 
else, such as SVN, editing, etc. is perfectly fine.


Matthew Williams
Geodesic GraFX
www.geodesicgrafx.com/blog

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330617
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFFTP copy command? - Found word(s) mp3 in the Text body

2010-02-11 Thread James Wolfe

The rename command is the same as a move. 

Thanks anyway.

The ftp command rename should do it, if it's exposed to the tag (I
don't do ftp, so don't know).

If it isn't, I guess it's java-land for you!  (Or just some other solution.)

:denny

-- 
Humility is truth.
Desiderius Erasmus 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330618
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFFTP copy command? - Found word(s) mp3 in the Text body

2010-02-11 Thread James Wolfe

putfile copies a file from the local machine to the target FTP server. I want 
to copy a file that is already on the target FTP server to a different location 
on the same server.

Again, I want a COPY not a move. I want, when I am done, to have TWO copies of 
the file on the foreign server and zero traffic between my computer and the 
server except the commands.

-james

Hey James,
If your trying to copy to an outside server you could use CFFTP's
action=putfile command.

After opening a connection I use something like this...

cfftp 
   action=putfile 
   connection=MyConnection 
   localfile=local path of file to copy 
   remotefile=remote path of where to copy too 
   transfermode=binary 
   stoponerror=no 
   timeout=3600 
   failifexists=no 
   retrycount=10




If you just want to copy it locally form one folder to another use cffile's
action=copy command.
http://livedocs.adobe.com/coldfusion/8/Tags_f_04.html



Is there any way to copy a file on the FTP server from 

   /directory1/fileName.mp3 
   to 
   /directory2/fileName.mp3

without downloading it to my machine?

Again, I want a COPY (not a move).

Thanks,
James 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330619
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Administrator page will not load on dev machine

2010-02-11 Thread Aaron Roberson

Hey folks,

I have installed and uninstalled CF9 in both multi-server and as a self
contained app on my dev machine and regardless of the setup I cannot load
the admin page.

I am on Mac OSX 10.6.2 running Apache


My CF websites are served up just fine when I go to
http://localhost/mysiteso I know both Apache and CF9 are running.
However, when I go to the admin
page at http://localhost:80/cfide/administrator/index.php the page is blank.
If I refresh the browser a couple times I then get the following error:

Server ErrorThe server encountered an internal error and was unable to
complete your request.
*Application server is busy. Either there are too many concurrent requests
or the server still is starting up.*


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330620
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Possible switch to CFEclipse

2010-02-11 Thread Andy Matthews

Aptana also has a plugin which allows you to code for Adobe AIR.

http://andymatthews.net/category/AIR/


andy 

-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: Thursday, February 11, 2010 12:39 PM
To: cf-talk
Subject: Re: Possible switch to CFEclipse


I am currently using Homesite+ for my IDE a

I made that leap a couple of years ago. This is my rig that I have been
tweeking for the last couple of years and the what and why of what I use
for CF/Web work.

One thing to remember with Eclipse. More Plugins = More ram. I also make it
a habit to jack up the RAM allotted to Eclipse from 256 megs to 512 in the
eclipse.ini file. This will speed things up considerably.

I start off with the PHP Eclipse distro because, well, I work with PHP a
lot. But even if I didn't, it has a lot of the basic tools I use for web
dev. Like support for XAMPP, Mysql etc

Then I add the Aptana plugin and add it's plugins for Ajax, SVN, AIR support
and what ever tickles my fancy at that moment. Some people are very vocal
against Aptana (I mean some people just flat out despise it) . It has a
nasty habit of firing up it's start up page every time you load it.  You can
turn this off by going to:

Window  Preferences Aapata  Start up page  and disable the start up
page

If you ask me, Aptana is fantastic for working with (X)HTML, CSS, JS, Ajax,
and in particular it's jQuery/JS support. It provides auto suggest, auto
complete and inline help CSS, html, JS including all of the major AJAX/JS
libraries as well as (inspection) for your own custom JS Libraries (and help
as long as you document them). I really like it's CSS editor a lot.

Then I add the Adobe CF 8.1 plugins and plop the CF 8.1 docs in the Plugins
folder for good measure.

Then Finally I install CFEclipse.

I also Use XMLBuddy a lot because, well, I like it.

Good luck.

G!

On Wed, Feb 10, 2010 at 9:23 PM, Terry Troxel te...@it-werks.com wrote:


 I do not want to start a flame here, just get some information to help 
 me make a decision.
 I am using CF8 and not yet ready for CF9. I am currently using 
 Homesite+ for my IDE and would like to know what the requirements are 
 for installing Eclipse and CFEclipse on my 32 bit dual core laptop w/3 
 gigs of ram.
 I do not know anyone who is currently using it which is why I am 
 asking here. I do not do any Java programming at all and am planning 
 on using it to replace Homesite if that is possible and maybe get some 
 advise from all of you.
 If you recommend Eclipse, which package and other plugins do I need as 
 well?

 Terry



 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330621
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFFTP copy command? - Found word(s) mp3 in the Text body

2010-02-11 Thread denstar

Ah, eyah, me no use FTP much anymore, sorry, it must effect my reading
comp skills.  :)

Here's the low-down:

http://stackoverflow.com/questions/960501/copy-or-move-a-file-from-one-ftp-server-to-another

:Den

-- 
If you keep thinking about what you want to do or what you hope will
happen, you don't do it, and it won't happen.
Desiderius Erasmus


On Thu, Feb 11, 2010 at 12:55 PM, James Wolfe james-cft...@goqs.com wrote:

 The rename command is the same as a move.

 Thanks anyway.

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330622
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


My ColdFusion JRun service is running at 50% CPU but I have no Idea why.

2010-02-11 Thread Ian Skinner

I've got my new JConsole tool plugged in and I can see it reporting the 
CPU usage of the service using 50% plus for the last two hours.

But I don't see any threads doing anything that I can see, nor when I 
take the thread snapshots with the ColdFusion Monitor do I see any thing 
running besides the monitor it self.

This has really got me stumped.  For the last couple of weeks, since I 
installed the monitoring tools our normal profile is a CPU hovering 
around 5% usage with an occasional spike as something is run.  Then 
today, bam the spinning started up again after taking the last week 
or two off.  But I just can not see anything deadlocked, hanging or 
anything out of the ordinary.

But then I really have little idea what I am looking for.

TIA
Ian


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330623
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: My ColdFusion JRun service is running at 50% CPU but I have no Idea why.

2010-02-11 Thread brad

Can you post the full stack trace somewhere?

Also, what instances did you get stack traces for?  If I recall you have
more than one instance of CF running and I don't know of any easy way to
tie each jrun.exe back to a specific instance.

~Brad

 Original Message 
Subject: My ColdFusion JRun service is running at 50% CPU but I have no
Idea why.
From: Ian Skinner h...@ilsweb.com
Date: Thu, February 11, 2010 2:53 pm
To: cf-talk cf-talk@houseoffusion.com


I've got my new JConsole tool plugged in and I can see it reporting the 
CPU usage of the service using 50% plus for the last two hours.



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330624
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: My ColdFusion JRun service is running at 50% CPU but I have no Idea why.

2010-02-11 Thread Ian Skinner

On 2/11/2010 12:58 PM, b...@bradwood.com wrote:
 Can you post the full stack trace somewhere?


http://www.ilsweb.com/JRun4-stack-traces/

 Also, what instances did you get stack traces for?  If I recall you have
 more than one instance of CF running and I don't know of any easy way to
 tie each jrun.exe back to a specific instance.

 ~Brad


To allow the jConsole tool to connect to each instance I had to 
configure each one with a separate jvm.config so that each instance uses 
a different port number to report the JRun statistics to the console.  
Thus I can tell what instance I am looking at by the port number of the 
jConsole window and that is the one I connected to and dumped the threads.



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330625
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Paul Alkema

Hey all,
I have a list that I'm trying to loop, I was wondering if it was possible to
have multiple character delimiter.

For example..

!--- create list ---
cfset variables.exampleList = Boat,Goat,Moat,CherryPie

!--- output only the words that contain oat ---
cfloop list=#variables.exampleList# index=i delimiters=oat
#i#
/cfloop


I would like something like the above to work, but instead it outputs all
that contain a B,O,A or a T.

Any ideas? :)

Thanks,
Paul


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330626
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Phillip Vector

I don't know if it would work and I'm shooting in the dark, but if you
made oat into a variable, would that work?

On Thu, Feb 11, 2010 at 1:57 PM, Paul Alkema
paulalkemadesi...@gmail.com wrote:

 Hey all,
 I have a list that I'm trying to loop, I was wondering if it was possible to
 have multiple character delimiter.

 For example..

 !--- create list ---
 cfset variables.exampleList = Boat,Goat,Moat,CherryPie

 !--- output only the words that contain oat ---
 cfloop list=#variables.exampleList# index=i delimiters=oat
        #i#
 /cfloop


 I would like something like the above to work, but instead it outputs all
 that contain a B,O,A or a T.

 Any ideas? :)

 Thanks,
 Paul


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330627
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Administrator page will not load on dev machine

2010-02-11 Thread Aaron Roberson

During the installation there is an option of which directory to place the
administrator in and I accepted the default which was incorrect. It works
fine now!

On Thu, Feb 11, 2010 at 12:05 PM, Aaron Roberson
aaronarober...@gmail.comwrote:

 Hey folks,

 I have installed and uninstalled CF9 in both multi-server and as a self
 contained app on my dev machine and regardless of the setup I cannot load
 the admin page.

 I am on Mac OSX 10.6.2 running Apache


 My CF websites are served up just fine when I go to
 http://localhost/mysite so I know both Apache and CF9 are running.
 However, when I go to the admin page at
 http://localhost:80/cfide/administrator/index.php the page is blank. If I
 refresh the browser a couple times I then get the following error:

 Server ErrorThe server encountered an internal error and was unable to
 complete your request.
 *Application server is busy. Either there are too many concurrent requests
 or the server still is starting up.*




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330628
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Paul Alkema

Good idea, but unfortunately it didn't work. Thanks though. :)

-Original Message-
From: Phillip Vector [mailto:vec...@mostdeadlygame.com] 
Sent: Thursday, February 11, 2010 5:00 PM
To: cf-talk
Subject: Re: Cfloop List Multiple Charecter Delimiters


I don't know if it would work and I'm shooting in the dark, but if you
made oat into a variable, would that work?

On Thu, Feb 11, 2010 at 1:57 PM, Paul Alkema
paulalkemadesi...@gmail.com wrote:

 Hey all,
 I have a list that I'm trying to loop, I was wondering if it was possible
to
 have multiple character delimiter.

 For example..

 !--- create list ---
 cfset variables.exampleList = Boat,Goat,Moat,CherryPie

 !--- output only the words that contain oat ---
 cfloop list=#variables.exampleList# index=i delimiters=oat
        #i#
 /cfloop


 I would like something like the above to work, but instead it outputs all
 that contain a B,O,A or a T.

 Any ideas? :)

 Thanks,
 Paul


 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330629
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Phillip Vector

Ok.. then try this...

!--- create list ---
cfset variables.exampleList = Boat,Goat,Moat,CherryPie

cfset changedlist=ReplaceNoCase(#variables.exampleList#,oat,%)

!--- output only the words that contain oat ---
cfloop list=#ChangedList# index=i delimiters=%
cfset NewI=ReplaceNoCase(#changedlist#,%,oat)
   #NewI#
/cfloop

It's a bit of a kludge, but it should work if I understand the problem
correctly.

On Thu, Feb 11, 2010 at 2:06 PM, Paul Alkema
paulalkemadesi...@gmail.com wrote:

 Good idea, but unfortunately it didn't work. Thanks though. :)

 -Original Message-
 From: Phillip Vector [mailto:vec...@mostdeadlygame.com]
 Sent: Thursday, February 11, 2010 5:00 PM
 To: cf-talk
 Subject: Re: Cfloop List Multiple Charecter Delimiters


 I don't know if it would work and I'm shooting in the dark, but if you
 made oat into a variable, would that work?

 On Thu, Feb 11, 2010 at 1:57 PM, Paul Alkema
 paulalkemadesi...@gmail.com wrote:

 Hey all,
 I have a list that I'm trying to loop, I was wondering if it was possible
 to
 have multiple character delimiter.

 For example..

 !--- create list ---
 cfset variables.exampleList = Boat,Goat,Moat,CherryPie

 !--- output only the words that contain oat ---
 cfloop list=#variables.exampleList# index=i delimiters=oat
        #i#
 /cfloop


 I would like something like the above to work, but instead it outputs all
 that contain a B,O,A or a T.

 Any ideas? :)

 Thanks,
 Paul






 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330630
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Phillip Vector

Sorry...

cfset variables.exampleList = Boat,Goat,Moat,CherryPie

cfset changedlist=ReplaceNoCase(#variables.exampleList#,oat,%)

!--- output only the words that contain oat ---
cfloop list=#ChangedList# index=i delimiters=%
cfset NewI=ReplaceNoCase(#i#,%,oat)
  #NewI#
/cfloop

Again, this isn't tested and off the cuff.. But I think you get what
I'm trying to do here. :)

On Thu, Feb 11, 2010 at 2:12 PM, Phillip Vector
vec...@mostdeadlygame.com wrote:
 Ok.. then try this...

 !--- create list ---
 cfset variables.exampleList = Boat,Goat,Moat,CherryPie

 cfset changedlist=ReplaceNoCase(#variables.exampleList#,oat,%)

 !--- output only the words that contain oat ---
 cfloop list=#ChangedList# index=i delimiters=%
 cfset NewI=ReplaceNoCase(#changedlist#,%,oat)
       #NewI#
 /cfloop

 It's a bit of a kludge, but it should work if I understand the problem
 correctly.

 On Thu, Feb 11, 2010 at 2:06 PM, Paul Alkema
 paulalkemadesi...@gmail.com wrote:

 Good idea, but unfortunately it didn't work. Thanks though. :)

 -Original Message-
 From: Phillip Vector [mailto:vec...@mostdeadlygame.com]
 Sent: Thursday, February 11, 2010 5:00 PM
 To: cf-talk
 Subject: Re: Cfloop List Multiple Charecter Delimiters


 I don't know if it would work and I'm shooting in the dark, but if you
 made oat into a variable, would that work?

 On Thu, Feb 11, 2010 at 1:57 PM, Paul Alkema
 paulalkemadesi...@gmail.com wrote:

 Hey all,
 I have a list that I'm trying to loop, I was wondering if it was possible
 to
 have multiple character delimiter.

 For example..

 !--- create list ---
 cfset variables.exampleList = Boat,Goat,Moat,CherryPie

 !--- output only the words that contain oat ---
 cfloop list=#variables.exampleList# index=i delimiters=oat
        #i#
 /cfloop


 I would like something like the above to work, but instead it outputs all
 that contain a B,O,A or a T.

 Any ideas? :)

 Thanks,
 Paul






 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330631
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Leigh

 multiple character delimiter.

I believe CF does not support that natively. Check cflib.org. I have not tried 
them, but it looks like there are a few functions for multi-character delimiters

http://www.cflib.org/udf/splitMX
http://www.cflib.org/udf/split


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330632
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Possible switch to CFEclipse

2010-02-11 Thread Adrocknaphobia

Aptana, jQuery, ExtJS and AIR are all baked into ColdFusion Builder... with
just one install.

-Adam

On Thu, Feb 11, 2010 at 3:16 PM, Andy Matthews li...@commadelimited.comwrote:


 Aptana also has a plugin which allows you to code for Adobe AIR.

 http://andymatthews.net/category/AIR/


 andy

 -Original Message-
 From: Gerald Guido [mailto:gerald.gu...@gmail.com]
 Sent: Thursday, February 11, 2010 12:39 PM
 To: cf-talk
 Subject: Re: Possible switch to CFEclipse


 I am currently using Homesite+ for my IDE a

 I made that leap a couple of years ago. This is my rig that I have been
 tweeking for the last couple of years and the what and why of what I use
 for CF/Web work.

 One thing to remember with Eclipse. More Plugins = More ram. I also make it
 a habit to jack up the RAM allotted to Eclipse from 256 megs to 512 in the
 eclipse.ini file. This will speed things up considerably.

 I start off with the PHP Eclipse distro because, well, I work with PHP a
 lot. But even if I didn't, it has a lot of the basic tools I use for web
 dev. Like support for XAMPP, Mysql etc

 Then I add the Aptana plugin and add it's plugins for Ajax, SVN, AIR
 support
 and what ever tickles my fancy at that moment. Some people are very vocal
 against Aptana (I mean some people just flat out despise it) . It has a
 nasty habit of firing up it's start up page every time you load it.  You
 can
 turn this off by going to:

 Window  Preferences Aapata  Start up page  and disable the start up
 page

 If you ask me, Aptana is fantastic for working with (X)HTML, CSS, JS, Ajax,
 and in particular it's jQuery/JS support. It provides auto suggest, auto
 complete and inline help CSS, html, JS including all of the major AJAX/JS
 libraries as well as (inspection) for your own custom JS Libraries (and
 help
 as long as you document them). I really like it's CSS editor a lot.

 Then I add the Adobe CF 8.1 plugins and plop the CF 8.1 docs in the Plugins
 folder for good measure.

 Then Finally I install CFEclipse.

 I also Use XMLBuddy a lot because, well, I like it.

 Good luck.

 G!

 On Wed, Feb 10, 2010 at 9:23 PM, Terry Troxel te...@it-werks.com wrote:

 
  I do not want to start a flame here, just get some information to help
  me make a decision.
  I am using CF8 and not yet ready for CF9. I am currently using
  Homesite+ for my IDE and would like to know what the requirements are
  for installing Eclipse and CFEclipse on my 32 bit dual core laptop w/3
  gigs of ram.
  I do not know anyone who is currently using it which is why I am
  asking here. I do not do any Java programming at all and am planning
  on using it to replace Homesite if that is possible and maybe get some
  advise from all of you.
  If you recommend Eclipse, which package and other plugins do I need as
  well?
 
  Terry
 
 
 
 



 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330633
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: My ColdFusion JRun service is running at 50% CPU but I have no Idea why.

2010-02-11 Thread James Holmes

What's the memory usage in that instance? High CPU can sometimes be
related to constant attempts at garbage collection.

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



On 12 February 2010 05:31, Ian Skinner h...@ilsweb.com wrote:

 On 2/11/2010 12:58 PM, b...@bradwood.com wrote:
 Can you post the full stack trace somewhere?


 http://www.ilsweb.com/JRun4-stack-traces/

 Also, what instances did you get stack traces for?  If I recall you have
 more than one instance of CF running and I don't know of any easy way to
 tie each jrun.exe back to a specific instance.

 ~Brad


 To allow the jConsole tool to connect to each instance I had to
 configure each one with a separate jvm.config so that each instance uses
 a different port number to report the JRun statistics to the console.
 Thus I can tell what instance I am looking at by the port number of the
 jConsole window and that is the one I connected to and dumped the threads.



 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330634
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Charlie Griefer

Wouldn't it be pretty straightforward and more legible to just loop over the
list and do a conditional on each loop iteration?  Unless you've got a
ridiculously large list it should still perform well enough.

!--- create list ---
cfset variables.exampleList = Boat,Goat,Moat,CherryPie

!--- output only the words that contain oat ---
cfloop list=#variables.exampleList# index=i
   cfif i contains oat#i#/cfif
/cfloop

As far as your original question regarding multiple delimiters... cfloop
does accept multiple delimiters, but the implementation is that it looks for
any of those characters... not the characters as a string.

For example, cfloop list=#myList# index=i delimiters=,:

will look for the comma as a delimiter -or- the colon.

so Foo,Bar:Baz would be a 3 element list.

On Thu, Feb 11, 2010 at 2:28 PM, Leigh cfsearch...@yahoo.com wrote:


  multiple character delimiter.

 I believe CF does not support that natively. Check cflib.org. I have not
 tried them, but it looks like there are a few functions for multi-character
 delimiters

 http://www.cflib.org/udf/splitMX
 http://www.cflib.org/udf/split




 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330635
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Leigh

 Wouldn't it be pretty straightforward and more legible to

Yes, it should not be that hard to implement and probably with less code than 
one of those udf's. But the other looks elegant enough. You might see if it 
does the trick first, before re-inventing the wheel.


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330636
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Charlie Griefer

Leigh - just to clarify, I wasn't suggesting the straightforward loop
w/conditional was more straightforward/legible than the UDFs on cflib... I
meant in general compared to some of the suggestions so far in this thread.

Not taking anything away from any the suggestions themselves... they're all
good and I'm glad to see people making an effort to help and answer
questions.

My answer was just... keep it simple :)

On Thu, Feb 11, 2010 at 6:03 PM, Leigh cfsearch...@yahoo.com wrote:


  Wouldn't it be pretty straightforward and more legible to

 Yes, it should not be that hard to implement and probably with less code
 than one of those udf's. But the other looks elegant enough. You might see
 if it does the trick first, before re-inventing the wheel.




 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330637
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


how do I create a new file with cffile?

2010-02-11 Thread Matthew Smith

I am trying to save dynamic pages as static html with cffile.  I have the html 
I want to write, but when I go to write it, I get:

An error occurred when performing a file operation write on file 
D:\inetpub\site\page.htm.  
The cause of this exception was: java.io.FileNotFoundException: 
D:\inetpub\sitepage.htm (The system cannot find the path specified).

The file does not exist.  I am trying to create a new file.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330638
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Cfloop List Multiple Charecter Delimiters

2010-02-11 Thread Leigh

 My answer was just... keep it simple :)

Always good advice :)


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330639
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: how do I create a new file with cffile?

2010-02-11 Thread Barney Boisvert

Either the containing directory doesn't exist, or you (meaning the CF
server) doesn't have sufficient privileges to create a new file in
that location (because of filesystem ACLs).  Java doesn't delineate
between the two for security reasons, much like web apps return 404
for existing resources you don't have access to and have no way of
gaining access to.

cheers,
barneyb

On Thu, Feb 11, 2010 at 7:13 PM, Matthew Smith chedders...@gmail.com wrote:

 I am trying to save dynamic pages as static html with cffile.  I have the 
 html I want to write, but when I go to write it, I get:

 An error occurred when performing a file operation write on file 
 D:\inetpub\site\page.htm.
 The cause of this exception was: java.io.FileNotFoundException: 
 D:\inetpub\sitepage.htm (The system cannot find the path specified).

 The file does not exist.  I am trying to create a new file.


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330640
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Sr. Software Engineer, ASP.Net, C#

2010-02-11 Thread Kayla Fennell, www.riccione.com

New!  Sr. Software Engineer, ASP.Net, C#
Location:  Flower Mound

This entrepreneurial firm has steadily grown from zero customer 
contracts in 2004 to over 3,000+ in 2009.  The firm provides a unique 
web based solution to a segment of the insurance industry that has 
enabled agents more options and coverage to its customer base, thus 
more competitive.

This is a dynamic work environment that seeks someone who enjoys the 
challenges and the immediate impact one can make to a company's 
growth.  The firm has plans to grow by branching off into new 
entities within the vertical.

The person they are seeking will be focusing on UI and be responsible 
for this key component in their web application.  Someone with 
broader skills will have an opportunity to do more in this 
environment.

We have a very strong relationship with the VP and have been 
successful in placing 5 Software Engineers since 2007; all are still 
employed at the firm.

Qualifications:
- Senior technical skills in software development
- 4-5 yrs ASP.NET experience -  .NET 3.5,
- Focus mainly on front-end web page/application development.
- C#, object oriented design skills,
- JavaScript, jQuery, AJAX
- NUnit testing framework, Subversion Source Control

Plusses:
- Good working knowledge of MS-SQL database
- Good working knowledge of HTTP technical details

Salary:  70k - 80k + Bonus

Relocation:  No assistance

Email resume to ka...@riccione.com

-- 

Best contact method: ka...@riccione.com

Celebrating our 25th year in Technical Recruiting!
Riccione Resources, Inc.
www.riccione.com

Specializing in:
Software Development
IT/Networking
Project Management
Business Development
Hardware Engineering



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4286
Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11