Re: CF prepared statements

2009-07-17 Thread Jochem van Dieten
On Thu, Jul 16, 2009 at 12:12 AM, Michael Christensen wrote: - If you use cfqueryparams in your query, the query is executed as a prepared statement on the SQL server. To be exact, it is send to the SQL server as a prepared statement. Whether the SQL server executes it as a prepared statement

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread denstar
Ja know... If you have a current Eclipse install that you like which contains CFE, and want to try CFB in the same setting, theoretically, you could: 1) Copy your current Eclipse install folder to something like eclipse-cfb 2) Either copy your workspace folder or create a new one 3) Fire up the

cfgrid

2009-07-17 Thread RamaDevi Dobbala
Hi frnds, can we give more than one column name in cfgridcolumn tag, and also how to set query result to a variable. Rama ~| Want to reach the ColdFusion community with something they want? Let them know on the House of

CFHTTP using ClientCert

2009-07-17 Thread Amit Aggarwal
Hi, I am trying to use the Client Certificate for Mutual Authentication but receiving a HTTP 403.7 error all the time. Could you please suggest if I am doing something wrong? Here is my code sample below. cfoutput cfset variables.doctypedec = '?xml version=1.0 encoding=utf-8?' /

Coldfusion 7 and Helm 3

2009-07-17 Thread Jenny Gavin-Wear
Hi all, I'm installing Helm3 with CF7. Is there anything special I need to do to restrict the use of some Coldfusion tags (file and directory, for example) or will Helm take care of that for me? I plan to have a mixture of sites which I have developed which will run outside Helm and sites

ColdExt Installation

2009-07-17 Thread Arsalan Tariq Keen
Guys, Can anyone help me out with installing ColdExt?? Where should I put the directory structure and in what order? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the

cfgrid

2009-07-17 Thread RamaDevi Dobbala
Hi frnds, i need to pass address column to cfgrid column, but in my table i have 3 columns for that address(address,state,city), but while displaying i have to keep these three into the CFGRIDCOLUMN how to give that. ~|

Re: cfgrid

2009-07-17 Thread Azadi Saryev
concatenate the 3 columns into one in your query. eg: SELECT address1 + ', ' + address2 + ', ' + address3 AS address FROM sometable Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 17/07/2009 17:42, RamaDevi Dobbala wrote: Hi frnds, i need to pass address column to cfgrid column,

Re: cfgrid

2009-07-17 Thread Scott Stroz
You can also tap into the Ext Grid object and handle formatting the columns after the data has been loaded. Check out this link for a good start: http://blog.cutterscrossing.com/index.cfm/2007/11/30/CF8-Ajax-Grid-Renderers-and-Events On Fri, Jul 17, 2009 at 6:42 AM, RamaDevi

RE: CF9 and Bolt in eWEEK

2009-07-17 Thread Rick Faircloth
If you've never used Eclipse, Adobe wants you to be able to easily install CFB. That's a step in the right direction. The world of Eclipse is confusing at first. It's almost like build-your-own-software land compared to typical software installations. It's still frustrating trying to track

RE: CF9 and Bolt in eWEEK

2009-07-17 Thread Rick Faircloth
Sounds like a good way to go... Any other comments/warnings/gotcha's on this procedure? -Original Message- From: denstar [mailto:valliants...@gmail.com] Sent: Friday, July 17, 2009 5:19 AM To: cf-talk Subject: Re: CF9 and Bolt in eWEEK Ja know... If you have a current Eclipse

Re: Coldfusion 7 and Helm 3

2009-07-17 Thread Casey Dougall
On Fri, Jul 17, 2009 at 6:21 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: Hi all, I'm installing Helm3 with CF7. Is there anything special I need to do to restrict the use of some Coldfusion tags (file and directory, for example) or will Helm take care of that for me? You

Re: cfgrid

2009-07-17 Thread RamaDevi Dobbala
if i use like this, if any value is getting null value means all the value is becoming null, how to avoid this concatenate the 3 columns into one in your query. eg: SELECT address1 + ', ' + address2 + ', ' + address3 AS address FROM sometable Azadi Saryev Sabai-dee.com

Re: cfgrid

2009-07-17 Thread Dave Sueltenfuss
You would want to wrap each column in the query in an IsNull(coulmnName,'') Dave On Fri, Jul 17, 2009 at 8:46 AM, RamaDevi Dobbala ramadobb...@gmail.comwrote: if i use like this, if any value is getting null value means all the value is becoming null, how to avoid this concatenate the

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread Casey Dougall
On Fri, Jul 17, 2009 at 8:13 AM, Rick Faircloth r...@whitestonemedia.comwrote: Sounds like a good way to go... Any other comments/warnings/gotcha's on this procedure? Different question... Anyone know how to edit keyboard shortcuts? I can pull up keyassist but can't remember how to edit

Re: cfgrid

2009-07-17 Thread RamaDevi Dobbala
select *,Area_Mgr_RDO as Director,Area_Note as dire_Note, IsNull(address,'') +IsNull(address2,'') + IsNull(address3,'') + IsNull(city,'') + IsNull(state,'') + IsNull(zip,'') +IsNull(country,'') as office_address from sourcebook_1 i am writings like this, but still it is giving the error

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread Gerald Guido
t's still frustrating trying to track down various plug-ins, etc, sometimes. Eclipse reminds me Linux with all of its dependencies, which is why package managers are such a godsend. Which is also why I am rather partial to Yoxos on demand http://eclipsesource.com/en/yoxos/yoxos-ondemand/ It is

Re: cfgrid

2009-07-17 Thread Cutter (ColdFusion)
He would be better off using a custom column renderer, as Scott suggested. This would allow him to set other columns (such as 'State') to hidden, but they would be available should he want to sort the grid on those other columns. Steve Cutter Blades Adobe Certified Professional Advanced

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread Cutter (ColdFusion)
Unfortunately Yoxos is building with Gallileo right now, and the CFB install doesn't appear to work properly with it. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book

Re: Coldfusion 7 and Helm 3

2009-07-17 Thread Mike Kear
You can set it up in a variety of ways. We use HELM and CF8 nowdays but we were using HELM and CF7 not so long ago. We have some tags disabled by default, but they can be enabled on request. When we are requested, we set up a sandbox for the user requesting it There are only a couple of

Re: cfinvoke newb question

2009-07-17 Thread Paul Ihrig
application.cfc in folder: /rittalxpress/cart cfcomponent output=false !--- Name the application. --- !--- cfset this.name = Website --- !--- Turn on session management. --- cfset this.sessionManagement = true cfset this.clientManagement = true cffunction name=onSessionStart returnType=void

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread Gerald Guido
Unfortunately Yoxos is building with Gallileo right now Yeah, I just noticed that they removed the option to chose the version of eclipse. They also removed Aptana and a bunch of other plugins from my saved profiles. Bummer. CFB install doesn't appear to work properly with it. That is odd. I

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread Cutter (ColdFusion)
It was an issue with the Yoxos install, which has it's own custom update engine, that didn't like me installing the CFB plugin. Gave me an error every time I tried to pull up Eclipse, and immediately shut down. I've done a straight vanilla Gallileo install from the Eclipse site now, and have

cferror request and form.fieldnames

2009-07-17 Thread Mark McArthey
Hello all! I'm trying to generate a custom error page of type request and still obtain the form.fieldnames. Is it possible to get the information from the parent page once the error page has been called? Thanks! ~| Want to

RE: Calling .ASPX.VB from .CFM

2009-07-17 Thread Jason Neidert
I was told that the .vb writes the soap. Here is the SOAP: http://irm.resortdata.com/LutsenInterface/IRMpublic.asmx?op=CheckAvailabilit y So could I skip having the aspx.vb file generating the soap and just generate it myself and send it to the SOAPAction address? Thanks so much for your

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread Scott Brady
I don't know if there's a way to add shortcuts specific to the CF Builder (under ColdFusion -- Editor Profiles -- Editor -- Keys in the preferences, I don't see a way to add. Only edit.). You might be able to try it in the Eclipse-specific shortcuts (General -- Keys) [that's where I had to go to

Re: Calling .ASPX.VB from .CFM

2009-07-17 Thread Dave Watts
I was told that the .vb writes the soap. Here is the SOAP: http://irm.resortdata.com/LutsenInterface/IRMpublic.asmx?op=CheckAvailabilit y So could I skip having the aspx.vb file generating the soap and just generate it myself and send it to the SOAPAction address? If there's a URL for

uninstalling JRun4 from failed Coldfusion install.

2009-07-17 Thread Ian Skinner
I tried to uninstall a failed developer edition ColdFusion 8.0.1 64bit installation on a Windows Vista 64bit laptop. This did not work cleanly and JRun4 is still running as a service on the computer. There are no ColdFusion or JRun programs in the Windows Uninstall programs list. Can

Re: cferror request and form.fieldnames

2009-07-17 Thread Dave Watts
I'm trying to generate a custom error page of type request and still obtain the form.fieldnames.  Is it possible to get the information from the parent page once the error page has been called? No, the Form scope is unavailable in an error page when you use TYPE=REQUEST. I would recommend

Re: uninstalling JRun4 from failed Coldfusion install.

2009-07-17 Thread Dave Watts
I tried to uninstall a failed developer edition ColdFusion 8.0.1 64bit installation on a Windows Vista 64bit laptop.  This did not work cleanly and JRun4 is still running as a service on the computer.  There are no ColdFusion or JRun programs in the Windows Uninstall programs list.

Re: cfinvoke newb question

2009-07-17 Thread Ian Skinner
cfcomponent output=false !--- Name the application. --- !--- cfset this.name = Website --- cfapplication name=Website clientmanagement=yes sessionmanagement=yes sessiontimeout=#CreateTimeSpan(0,1,0,0)# Uncomment the cfset this.name = Website in the Application.cfc. You definitely need this so

cfgridcolumn

2009-07-17 Thread RamaDevi Dobbala
Hi frnds, can we give cfgridcolumn name=not in query which is not there in that query, i have to getr that from some other query, how to get that, if i want to write condition for that column value based on that i have loop some other query and then assing that value to this filed, is it

Re: uninstalling JRun4 from failed Coldfusion install.

2009-07-17 Thread Cutter (ColdFusion)
When uninstalling, I always stop the service first, uninstall, delete the directory from the c:\ drive, remove the service (command line) if it still extists, and restart the system, prior to doing additional stuff. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia

Re: Cfexchangecontact synchronization

2009-07-17 Thread Victor Moore
I'm still trying to figure out a way to do 2 way synchronization between a cf and exchange. Because it seems that the last update of a record in exchange (calendar or contact) is not available to cfexchange tags I wonder how people do this. Does anybody know if this omission has been fixed in

Re: cfinvoke newb question

2009-07-17 Thread Paul Ihrig
thanks Ian. Choop told me to cfif not StructKeyExists(session, 'myShoppingCart') cfset session.myShoppingCart = createobject('component', 'rittalxpress.cart.shoppingcart')/ /cfif in my application.cfm, bypassing the call in the application.cfc now every thing seems to work thanks choop Ian

Re: cfgridcolumn

2009-07-17 Thread Dave Sueltenfuss
If I am understanding you, you want data from 2 different tables in your CFGRID. I would recommend doing a join statement in your query to get all the columns you need in one query. On Fri, Jul 17, 2009 at 11:47 AM, RamaDevi Dobbala ramadobb...@gmail.comwrote: Hi frnds, can we give

RE: Calling .ASPX.VB from .CFM

2009-07-17 Thread Jason Neidert
Here is a link to the .WSDL file: http://lutsen.steelfusion.com/winter/rates_packages/packages/rdp/rdp/rdpweb/ IRMPublic.wsdl So I tried this: cfinvoke webservice=http://lutsen.steelfusion.com/winter/rates_packages/packages/rdp /rdp/rdpweb/IRMPublic.wsdl method=CheckAvailability

Re: uninstalling JRun4 from failed Coldfusion install.

2009-07-17 Thread Ian Skinner
You can simply stop the service, delete the registry keys, and delete the JRun4 directory. I deleted every registry key I could find with either coldfusion or macromedia, I deleted the JRun4 directory, There are no ColdFusion or Macromedia services running in the services panel. But when

Re: uninstalling JRun4 from failed Coldfusion install.

2009-07-17 Thread Dave Sueltenfuss
Just a thought, did you search for any JRUN registry keys? On Fri, Jul 17, 2009 at 1:54 PM, Ian Skinner h...@ilsweb.com wrote: You can simply stop the service, delete the registry keys, and delete the JRun4 directory. I deleted every registry key I could find with either coldfusion or

Re: Excel2Query

2009-07-17 Thread John McSwishton
I purchased a CFX from http://www.emerle.net/programming/, CFX_Excel2Query but I keep getting this error: java.lang.ClassNotFoundException: cfx_excel2query.jar, tags folder=classes/ Is this a problem with the CFX or my installation? TIA

Seding complex data to .net webservice

2009-07-17 Thread Hong Chen
I'm having a problem wrapping my data to invoke .net webservice. Here is the WSDL: - s:element name=UploadFile - s:complexType - s:sequence s:element minOccurs=0 maxOccurs=1 name=trimURL type=s:string / s:element minOccurs=0 maxOccurs=1 name=incomingArray type=s:base64Binary / s:element

Re: Excel2Query

2009-07-17 Thread John M Bliss
Not exactly an answer to your question...but: http://cflib.org/udf/parseExcel On Fri, Jul 17, 2009 at 1:18 PM, John McSwishton jmcswish...@gmail.comwrote: I purchased a CFX from http://www.emerle.net/programming/, CFX_Excel2Query but I keep getting this error:

RE: CF9 and Bolt in eWEEK

2009-07-17 Thread Rick Faircloth
Tell me I'm just having a nightmare... Does CFB not maintain folded code state when opening a document? -Original Message- From: Scott Brady [mailto:dsbr...@gmail.com] Sent: Friday, July 17, 2009 11:20 AM To: cf-talk Subject: Re: CF9 and Bolt in eWEEK I don't know if there's a way

RE: CF9 and Bolt in eWEEK

2009-07-17 Thread Rick Faircloth
Ahhh! Can only tags that are specified in Preferences be folded? Can I not set folding markers anywhere I want?? -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, July 17, 2009 3:44 PM To: cf-talk Subject: RE: CF9 and Bolt

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread John M Bliss
I came to the same conclusion: http://cfbugs.adobe.com/bugreport/flexbugui/cfbugtracker/main.html#bugId=78723 On Fri, Jul 17, 2009 at 2:44 PM, Rick Faircloth r...@whitestonemedia.comwrote: Tell me I'm just having a nightmare... Does CFB not maintain folded code state when opening a

Re: cfgridcolumn

2009-07-17 Thread Kumar Shah
If you need to manipulate the cfgrid after it has rendered, you would have to use the ExtJS library. On Fri, Jul 17, 2009 at 11:47 AM, RamaDevi Dobbalaramadobb...@gmail.com wrote: Hi frnds, can we give cfgridcolumn name=not in query which is not there in that query, i have to getr that from

RE: CF9 and Bolt in eWEEK

2009-07-17 Thread brad
Take it easy-- it's a beta. Log a bug and call it a day. The new Flex bug tracker is pretty kick butt. http://cfbugs.adobe.com/bugreport/flexbugui/cfbugtracker/main.html ~Brad Original Message Subject: RE: CF9 and Bolt in eWEEK From: Rick Faircloth

Error running CF administrator for the first time

2009-07-17 Thread Ian Skinner
I finally got the old JRun4 uninstalled so I could try installing CF8.0.1 64bit on my Windows Vista 64bit laptop. When the installer launched http://localhost/cfide/administrator/ to finish the configuration I got this error from IIS 7 Error Summary HTTP Error 500.21 - Internal Server Error

Re: Error running CF administrator for the first time

2009-07-17 Thread Casey Dougall
On Fri, Jul 17, 2009 at 4:32 PM, Ian Skinner h...@ilsweb.com wrote: I finally got the old JRun4 uninstalled so I could try installing CF8.0.1 64bit on my Windows Vista 64bit laptop. When the installer launched http://localhost/cfide/administrator/ to finish the configuration I got this

Re: Error running CF administrator for the first time

2009-07-17 Thread Ian Skinner
That happens with CF 8 as well Did you turn on IIS 6 Management Compatibility? Go back into web Management Compatibility and see if that stuff is checked. I thought I did. ~| Want to reach the ColdFusion community with

Secure FTP Issue - Authentication Error

2009-07-17 Thread Jim Carroll
I am attempting to use CF 8 to connect to a secure FTP server. Based up documents/web postings I believe that the following code should work but I am getting a user authentication error. I can connect using CoreFTP or psFTP and the same parameters from the web server. cfset objFTPProperties

Re: Error running CF administrator for the first time

2009-07-17 Thread Ian Skinner
That happens with CF 8 as well Did you turn on IIS 6 Management Compatibility? Go back into web Management Compatibility and see if that stuff is checked. Internet Information Services - [x] Web Management Tools - - [x] IIS 6 Management Compatibility - - - [x] IIS 6 Management Console

Re: Error running CF administrator for the first time

2009-07-17 Thread Dave Watts
When the installer launched http://localhost/cfide/administrator/ to finish the configuration I got this error from IIS 7 Error Summary HTTP Error 500.21 - Internal Server Error Handler AboMapperCustom-59342 has a bad module IsapiModule in its module list I would generally recommend

RE: CF9 and Bolt in eWEEK

2009-07-17 Thread Ben Forta
As he said, this is a public beta, designed so that you can provide feedback before it's too late to implement them. Take a big deep breath, and file all bugs and enhancements requests, and the sooner the better. --- Ben -Original Message- From: b...@bradwood.com

Re: Error running CF administrator for the first time

2009-07-17 Thread Ian Skinner
I would generally recommend that you not install IIS connectivity during the initial installation process. Instead, use the JRun Web Server option, then after you install you can run the Web Server Configuration Utility. When you do run that utility, make sure you right-click on it and choose

RE: CF9 and Bolt in eWEEK

2009-07-17 Thread Rick Faircloth
Hi, Ben. I've calmed down...some. I've just been living with that aggravation in CFE for so long and...well...I just couldn't contain my disappointment. :o/ Boohoo... Enhancement request filed...(who do I need to slip some green to get this feature enhanced...and how much? $300? $500?) :o)

Re: Cfexchangecontact synchronization

2009-07-17 Thread denstar
iCal4j might get you through. -- Oh, give us the man who sings at his work. Thomas Carlyle On Fri, Jul 17, 2009 at 10:42 AM, Victor Moorevictor.mo...@gmail.com wrote: I'm still trying to figure out a way to do 2 way synchronization between a cf and exchange. Because it seems that the last

Re: CF9 and Bolt in eWEEK

2009-07-17 Thread denstar
On Fri, Jul 17, 2009 at 6:13 AM, Rick Fairclothr...@whitestonemedia.com wrote: Sounds like a good way to go... Any other comments/warnings/gotcha's on this procedure? Not really. It's what I've done for a bunch of other plugins/testing cfe, etc., so *theoretically* that's about it. Java is

Re: grouped query - groups in separate columns

2009-07-17 Thread Seamus Campbell
Where I am using 'group' in my cfquery. So I think - yes to your question. I originally had this - cfoutput query=get_members_advanced group=contact_type_id h2#contact_type# /h2 cfoutput #contact_surname# br / /cfoutput /cfoutput But this gave me a single column - I want each new

Re: Aggregate query help please

2009-07-17 Thread Seamus Campbell
Hi Barney Your answer was cut - would you mind resending please ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: Aggregate query help please

2009-07-17 Thread Barney Boisvert
I have no idea what that was. My sent mail has the same blank message, but I didn't reply. WITH ROLLUP is the clause you want though, if your DB supports it. cheers, barneyb -- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com/ On Jul 17, 2009, at 4:09 PM, Seamus Campbell

Re: Aggregate query help please

2009-07-17 Thread denstar
I've got some code that uses the JExcelAPI for converting queries to Excel spreadsheets. It's got some support for formulas, so theoretically you could wow the people you need to send it to by not only having the sums there, but having them update if they change the numbers in the various