Re: Strange issue with cfquery
try and change the following #PreserveSingleQuotes(sql)# From: Nkonye Oyewusi To: cf-talk Sent: Wed, November 10, 2010 11:33:27 AM Subject: Strange issue with cfquery Hello, I am running CF 8 on an Oracle database. I'm trying to pass in a SQL script as a string and keep getting the error: ORA-00907: missing right parenthesis. This is what I'm trying to do: The doRunScript method is as follows: #sql# Is there a workaround for this? Thanks, Nikki ~| 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:339071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
VAADIN Integration with coldfusion ?!
Has anyone used Vaadin UI Library in a Coldfusion 9 or 8 application ? Any samples or wrapper would be appreciated . check out the library on http://demo.vaadin.com/sampler/ ~| 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:332632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: date calculations driving me batty!!
@Paul come again ?! Datediff should be dropped , and a custom function that takes two cf date objects converts them to numeric values and do the math ( subtract and return result in desired form ) how does that not solve the problem ? From: Paul Hastings To: cf-talk Sent: Wed, March 3, 2010 1:00:38 PM Subject: Re: date calculations driving me batty!! On 3/3/2010 4:02 PM, I. Addoum. wrote: > When working with different time zones and different platforms how does this solve tz problems? ~| 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:331295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: date calculations driving me batty!!
When working with different time zones and different platforms And to avoid date format issues And speed up date calculations I convert all dates to MMDD Then perform regular subtraction to get the date difference So 20100330 â 20100310 = 20 days And 20110530 â 20100310 = 10220 that is (1 year , 2 months , 20 days) case 1 case 2 case 3 date 1 201003092010031020100310 date 2 201003202010032020100330 = date 2 - date 1 11 10 20 From: Les Mizzell To: cf-talk Sent: Wed, March 3, 2010 6:39:02 AM Subject: Re: date calculations driving me batty!! > OK - THIS works __ Information from ESET NOD32 Antivirus, version of virus signature database 4910 (20100302) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~| 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:331293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIF within CFmail?
that will not work ... you should have your CFIF before the cfmail tag From: "Orlini, Robert" To: cf-talk Sent: Mon, February 22, 2010 4:57:08 PM Subject: CFIF within CFmail? Hello, I'm trying to include a cfif within a cfmail. If a form element is "K-12", then I want to add a cc to the cfmail part. Here is what I have in part: cc="te...@test2.com" Subject="New Jersey"> It generates an error. Is there a better way to do this? Thanks. RO HWW ~| 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:331016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Arrays - humbug! - Part 1
@larry try [1st dim][2nd dim] instead of [a,b] regards Bob From: "Stephens, Larry V" To: cf-talk Sent: Fri, February 5, 2010 4:06:48 PM Subject: Arrays - humbug! - Part 1 For some reason I have a mental block when it comes to arrays. At the top of the page is: I pull info (if it exists) with a query: SELECT tblLaterals.latID, tblLaterals.lateralID, tblLaterals.Why, [FirstName] & Chr(32) & [LastName] AS Who, tblPlayers.Title, tblPlayers.TX, tblPlayers.FAX, tblPlayers.Email, tblLaterals.DateSent FROM tblLaterals LEFT JOIN tblPlayers ON tblLaterals.lateralID = tblPlayers.playerID WHERE tblLaterals.MasterID=#SESSION.Report.MasterID# ORDER BY [FirstName] & Chr(32) & [LastName]; I then want to store it in an array. This is a new database so I have nothing to store, yet, i.e., the inner code hasn't been tested. Here's the first problem. Looking inside the statement, the code that is commented out throws an error. i.e., won't work. I tried #a# with and without the hash marks. My intent is to have [1,1], [1,2] ... [1,9], [2,1], [2,2] etc. I'm missing something. The code as is (i.e., setting up array a then ArrayAppending it hasn't run yet but at least doesn't throw an invalid construct error. To keep this from getting too long I'm stopping here. Continuing in next message. Larry Stephens steph...@indiana.edu ~| 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:330422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HOF mailing lists
is it me or the HOF Mailing List Management page is NOT working ?!? http://www.houseoffusion.com/signin/lists.cfm i would like to add my account to other CF mailing lists but with no success so far ... anyone else has that problem ? ~| 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:328755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion 9 Hosting with CFObject access
Hello anyone know of a Good and Reliable Hosting provider for CF9 , that permits access to cfobject ? regards Bob ~| 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:327907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Free Database Enginer for ColdFusion
best choice would be Oracle XE (it's free) regards Bob From: Arsalan Tariq Keen To: cf-talk Sent: Tuesday, October 6, 2009 7:49:56 AM Subject: Free Database Enginer for ColdFusion Hi fellows, does anyone know of a lightweight free database engine that I can bundle with my applications for small and medium size businesses? Regards, Arsalan ~| 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:326948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to make ODBC Connection to Access DB with MDW Connection
you have to use JDBC-ODBC. simply select "Microsoft Access" driver NOT "ODBC Socket" when you create your data source. and the trick is to supply the following Database File = c:\test\x.mdb System Database File = c:\test\Security.mdw Use Default User name = true (checked) open show advanced settings : Default User name = a valid user Default password = a valid user password done . Regards Bob From: Jeanmarie Richardson To: cf-talk Sent: Friday, August 28, 2009 3:20:43 AM Subject: How to make ODBC Connection to Access DB with MDW Connection Hi -- I need to make an ODBC connection to an access database that utilizes an MBW file for security. How can this be done? Could I use a connection string? Or does the ODBC manager allow this. Thanks in advance! ~| 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:325824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: COM Ports
for all things communication , be it com port / blue tooth / parallel or USB I would start from for API docs http://java.sun.com/products/javacomm/ and for some sample code http://today.java.net/pub/a/today/2004/07/27/bluetooth.html regards Bob From: Arsalan Tariq Keen To: cf-talk Sent: Wednesday, August 26, 2009 8:30:32 AM Subject: COM Ports Hi... can anyone tell me how I can access my machine's COM ports using coldfusion? I need to access me peripheral device attached on that port. Regards, Arsalan ~| 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:325710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4