RE: Single Quotes in Comment Fields Problem
Les, RTFM on cfqueryparam, you need to supply the 'value' and 'cfsqltype' as attributes to cfqueryparam: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm#wp11 02474 - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Les Mizzell [mailto:[EMAIL PROTECTED] | Sent: Tuesday, February 24, 2004 02:40 | To: CF-Talk | Subject: Re: Single Quotes in Comment Fields Problem | | OK, | | This one errors out: | COMMENTS = cfqueryparam name=#form[comments_#thisId#]# | | Attribute validation error for tag CFQUERYPARAM. | The tag does not allow the attribute(s) NAME. The valid | attribute(s) are CFSQLTYPE,LIST,MAXLENGTH,NULL,SCALE,SEPARATOR,VALUE. | | | This one works: | | COMMENTS = cfqueryparam cfsqltype=cf_sql_varchar | value=#FORM['COMMENTS_#thisID#']#' null=false /, | | | Interesting. Learn something every day - despite the ever ticking age | clock. Heh... | | Thanks so much for the input! | | -- | Les Mizzell | -- | Skill without imagination is craftsmanship | and gives us many useful objects such as | wickerwork picnic baskets. Imagination | without skill gives us modern art. | -- | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question regarding CFMX 6.2
Ben Any update on connecting to IBM Univers database from Macromedia, has this been confirmed as a bug ?or have they come up with any solution why it does not work with MX but does with 4.5 ? If it is a bug it would be good if it could be resolved! -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 18:56 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Nothing is final. But you hit the nail on the head, every piece of software in existence (including the CF apps that us CF developers write) could be updated and patched and improved. Some updates are vital, some are insignificant, and the vast majority sit somewhere between those two extremes. And so judgment calls have to be made, recognizing that while updates are important, they have a tremendous cost and impact on core product delivery. And too many incremental updates are disruptive (look at Microsoft, and how often that annoying automatic update utility kicks in). It's about balance. As I already said, critical issues (for example, security holes, or anything that could crash a server) take top priority, beyond that it's a judgment call. We have releases a few hot fixes, they may be more, we'll work it out as is needed. For now, keep us informed of any and all issues, we'll try to maintain the right balance. --- Ben _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 1:45 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 No planned maintenance release anytime soon? Sigh, that is too bad, I was hoping some of the minor issues would be addressed in CFMX 6.1 soon.But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Has black stone entered Beta testing yet?I should maybe get in that program and see if I can get some of these issues addressed, if they have not been yet. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:57 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Right now we are aggressively working on Blackstone. That is not to say that there'll not be a release between now and then, but I am unaware of any planned maintenance release at this point. If one becomes critical and necessary, then I am sure that one will be released (if hot fixes are not an option). --- Ben _ From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 12:50 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Correct me if I'm wrong but aren't there still bugs and known issues with 6.1. Are you suggesting that there are no immediate plans to address these? Thanks Kola -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 16:29 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 CFMX 6.2? I don't believe that version numbers and editions have been discussed at all, actually. Generally, maintenance releases have been free upgrades (as 6.1 was) whereas full product releases have been paid upgrades (and included in subscriptions, of course). The next planned version of ColdFusion is codenamed Blackstone, and version numbers, pricing, etc., have yet to be discussed at all. But, and this is my own opinion here, I doubt that there will be another maintenance release for CFMX any time soon. CFMX needed updates, which is why we released service packs and then v6.1, But 6.1 has proven to be reliable and solid and arguably one of the best ColdFusion's ever, and so a maintenance release is unlikely. Bottom line, use 6.1 now, and stay tuned for announcements from MM. --- Ben _ From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:16 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 I am wondering, will CF 6.2 be a free upgrade from 6.1 or will MM want us to pay for it? And if $$$ is involved, how much? TK -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 10:21 AM To: CF-Talk Subject: Re: Question regarding CFMX 6.2 On Monday 23 Feb 2004 09:21 am, Jochem van Dieten wrote: Macromedia is thinking about: http://mxeurope.org/go/objectid/CAAA4C2A-50DA-4D01-876C3488A0F5D98A simpler ways to create compelling UIs, Does that sound like shiping some sort of cut-down Flex to anyone else ? In the same way they implemented cfchart by shipping a cut down version of their own stand alone graphing app ? Increasing
RE: Dreamweaver - split document
It doesnt exists in DWMX2004 AFAIK. N _ From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 22:47 To: CF-Talk Subject: Dreamweaver - split document Does anybody know how to get DW to split a document the way HomeSite does? I really miss that feature. Walt _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: cfeclipse version 1.1.1 released - if you care
Of course we care ! happy cfcoding It is now :-) Great job, once again. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: cfeclipse version 1.1.1 released - if you care
On Tuesday 24 Feb 2004 09:34 am, Thomas Chiverton wrote: Great job, once again. Except it appears to be missing some files in /icons/ - like the title bar and menu icons. I copied the /icons/ dir from 1.1.0 into the /icons/ dir of 1.1.1 and that has fixed it. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
On Monday 23 Feb 2004 23:37 pm, Richard Crawford wrote: more disturbing indications that Oracle Stored Procedures do not return result sets. I am investigating this today / yesterday. Using cfprocresult works, with Oracle 9i and CFMX6.1 under weblogic, using CFMX 'oracle' datasources. Some combination of WebLogic JNDI datasources and some beta MM drivers causes this to break, however. More later :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Dreamweaver - split document
Me too! Thecloset you can get is to hit F11 or F10 (one of those 2) for the code inspector. Kola -Original Message- From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 22:47 To: CF-Talk Subject: Dreamweaver - split document Does anybody know how to get DW to split a document the way HomeSite does? I really miss that feature. Walt _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
REFind
Hi guys, I'm trying to make sure that my field has ONLY numeric characters otherwise show an error.I'm using the REFind but it doesn't pick up characters like $ £ etc. cfelseif REFind([[:num:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif Any ideas? Cheers, Stu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
REFind
Sorry, that line should have read: cfelseif REFind([[:alpha:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REFind
REFind([^0-9],form.PropertyDataPrice) If you want to allow other caracters like . and , add them in the class: REFind([^0-9.,],form.PropertyDataPrice) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 10:50 To: CF-Talk Subject: REFind Hi guys, I'm trying to make sure that my field has ONLY numeric characters otherwise show an error.I'm using the REFind but it doesn't pick up characters like $ £ etc. cfelseif REFind([[:num:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif Any ideas? Cheers, Stu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REFind
Don't you have to escape the period? like so \. Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 February 2004 8:17 PM To: CF-Talk Subject: RE: REFind REFind([^0-9],form.PropertyDataPrice) If you want to allow other caracters like . and , add them in the class: REFind([^0-9.,],form.PropertyDataPrice) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 10:50 To: CF-Talk Subject: REFind Hi guys, I'm trying to make sure that my field has ONLY numeric characters otherwise show an error.I'm using the REFind but it doesn't pick up characters like $ £ etc. cfelseif REFind([[:num:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif Any ideas? Cheers, Stu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REFind
Thanks Pascal, that's great! :) -- Original Message -- From: Pascal Peters [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 24 Feb 2004 11:16:48 +0100 REFind([^0-9],form.PropertyDataPrice) If you want to allow other caracters like . and , add them in the class: REFind([^0-9.,],form.PropertyDataPrice) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 10:50 To: CF-Talk Subject: REFind Hi guys, I'm trying to make sure that my field has ONLY numeric characters otherwise show an error.I'm using the REFind but it doesn't pick up characters like $ £ etc. cfelseif REFind([[:num:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif Any ideas? Cheers, Stu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REFind
Only if it is not in a character class. -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 11:36 To: CF-Talk Subject: RE: REFind Don't you have to escape the period? like so \. Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 February 2004 8:17 PM To: CF-Talk Subject: RE: REFind REFind([^0-9],form.PropertyDataPrice) If you want to allow other caracters like . and , add them in the class: REFind([^0-9.,],form.PropertyDataPrice) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 10:50 To: CF-Talk Subject: REFind Hi guys, I'm trying to make sure that my field has ONLY numeric characters otherwise show an error.I'm using the REFind but it doesn't pick up characters like $ £ etc. cfelseif REFind([[:num:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif Any ideas? Cheers, Stu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF lead management app?
I developed one that I think does what you are looking for.It uses a modified fusebox framework.www.leadsgroup5.com if you contact me off line I will set up a demo account and we can discuss what if anything I can share. Dwayne Cole, MS in MIS, MBA Certified Advanced ColdFusion Developer 850-591-0212 It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing.The Fifth Discipline - Peter Senge -- Original Message -- From: Phillip B [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Mon, 23 Feb 2004 16:18:04 -0600 I need a way to send leads to it and have it auto respond according to the lead information. Schedule follow ups and notes about the lead. Capable of sending bulk emailings based on certain criteria. It would be used by multiple stores who will have multiple people using it. A way to view lead stats and reports. There are several other things that would be nice but this would be the most important. Phillip B. JT wrote: what would you you like it you do.. what features are you looking for? http://www.houseoffusion.com/banners/view.cfm?bannerid=37 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Resource Security
Hi all, I am having a strange problem on a CFMX server when I enable Resource Security via the CF Administrator. I have a CF based application which replicates a directory structure from one box to another via ftp. When I enable Resource Security on the Originating box but leave all defaults in place (in other words, I do not explicitly restrict any tags, etc), the application is able to make the corresponding directories on the target box, but fails to Put any of the files. A check of the logs reveals that the CFFTP tag is throwing an error that reads something along the lines of (java.net.SocketPermission localhost:1024 - listen,resolve). I tried explicitly allowing this port on this box and the target box on the Server/Ports tab of the Resource Security section with no luck. If I disable Resource security on the originating box, it works just fine. Note that Resource Security is also enabled on the target box and has been hardened and does not appear to be causing any issues. In all testing, it has been enabled on the target box. Any ideas? JM [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Resource Security
J M said: I am having a strange problem on a CFMX server when I enable Resource Security via the CF Administrator. I have a CF based application which replicates a directory structure from one box to another via ftp. When I enable Resource Security on the Originating box but leave all defaults in place (in other words, I do not explicitly restrict any tags, etc), the application is able to make the corresponding directories on the target box, but fails to Put any of the files. http://www.macromedia.com/support/coldfusion/ts/documents/cfftp_sandbox.htm Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question regarding CFMX 6.2
No, but I'll check. --- Ben _ From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 3:55 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Any update on connecting to IBM Univers database from Macromedia, has this been confirmed as a bug ?or have they come up with any solution why it does not work with MX but does with 4.5 ? If it is a bug it would be good if it could be resolved! -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 18:56 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Nothing is final. But you hit the nail on the head, every piece of software in existence (including the CF apps that us CF developers write) could be updated and patched and improved. Some updates are vital, some are insignificant, and the vast majority sit somewhere between those two extremes. And so judgment calls have to be made, recognizing that while updates are important, they have a tremendous cost and impact on core product delivery. And too many incremental updates are disruptive (look at Microsoft, and how often that annoying automatic update utility kicks in). It's about balance. As I already said, critical issues (for example, security holes, or anything that could crash a server) take top priority, beyond that it's a judgment call. We have releases a few hot fixes, they may be more, we'll work it out as is needed. For now, keep us informed of any and all issues, we'll try to maintain the right balance. --- Ben _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 1:45 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 No planned maintenance release anytime soon? Sigh, that is too bad, I was hoping some of the minor issues would be addressed in CFMX 6.1 soon.But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Has black stone entered Beta testing yet?I should maybe get in that program and see if I can get some of these issues addressed, if they have not been yet. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:57 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Right now we are aggressively working on Blackstone. That is not to say that there'll not be a release between now and then, but I am unaware of any planned maintenance release at this point. If one becomes critical and necessary, then I am sure that one will be released (if hot fixes are not an option). --- Ben _ From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 12:50 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Correct me if I'm wrong but aren't there still bugs and known issues with 6.1. Are you suggesting that there are no immediate plans to address these? Thanks Kola -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 16:29 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 CFMX 6.2? I don't believe that version numbers and editions have been discussed at all, actually. Generally, maintenance releases have been free upgrades (as 6.1 was) whereas full product releases have been paid upgrades (and included in subscriptions, of course). The next planned version of ColdFusion is codenamed Blackstone, and version numbers, pricing, etc., have yet to be discussed at all. But, and this is my own opinion here, I doubt that there will be another maintenance release for CFMX any time soon. CFMX needed updates, which is why we released service packs and then v6.1, But 6.1 has proven to be reliable and solid and arguably one of the best ColdFusion's ever, and so a maintenance release is unlikely. Bottom line, use 6.1 now, and stay tuned for announcements from MM. --- Ben _ From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:16 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 I am wondering, will CF 6.2 be a free upgrade from 6.1 or will MM want us to pay for it? And if $$$ is involved, how much? TK -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 10:21 AM To: CF-Talk Subject: Re: Question regarding CFMX 6.2 On Monday 23 Feb 2004 09:21 am, Jochem van Dieten wrote: Macromedia is thinking about: http://mxeurope.org/go/objectid/CAAA4C2A-50DA-4D01-876C3488A0F5D98A simpler ways to create compelling UIs, Does that sound like shiping some sort of cut-down Flex to anyone else ? In the same way they implemented cfchart by shipping a cut down version of their own stand alone graphing
Access to the configuration variables
I need to get access to the server configuration settings from a CFMX script. Is there a possibility to access these values from CFMX like for the CFC with the #server# variable? Thx. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Resource Security
Thanks for the link. The problem is still here, but the error message has changed slightly. I now simply receive the error Connection Refused:connect. Again, all cfftp commands work (with the passive=yes parameter added) except the putfile command. It is that one that is throwing the error. Bizarre. JM [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
On Tuesday 24 Feb 2004 09:46 am, Thomas Chiverton wrote:
More later :-)
There appears to be an issue with Oracle's JDBC driver and weblogic 7 (fixed
in 8 of course) that prevents the use of stored procs that return result
sets.
I was hoping to use weblogic's jdbc driver, with code likethe below, taken
from the WebLogic examples. However the registerOutParmeter fails (JDBC 3.0
method not implemented) :-(
--snip--
thingy=CreateObject('java','com.bf.common.j2ee.jdbc.JdbcConnectionFactory');
conn=thingy.getFactory().getConnection('dev_ora_resultSet');
cstmt=CreateObject('java','weblogic.jdbc.common.OracleCallableStatement');
cstmtWrong=conn.prepareCall(begin
bf_report.client_facade_pkg.get_available_reports(?, ?); end;);
wibble=CreateObject('java','com.bf.common.util.cast.CastingFactory');
cstmt=wibble.cast(cstmtWrong);
otherObj=CreateObject('java','java.sql.Types');
other=otherObj.OTHER;
cstmt.registerOutParameter(2,otherObj.OTHER);
cstmt.setString(1,'h');
cstmt.execute();
rs=cstmt.getResultSet(1);
--pins--
Solution: Use native CFMX drivers. Which is a shame :-(
I dunno if it's worth putting in on the wish list...
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CFMX Resource Security
J M said: Thanks for the link. The problem is still here, but the error message has changed slightly.I now simply receive the error Connection Refused:connect. Again, all cfftp commands work (with the passive=yes parameter added) except the putfile command.It is that one that is throwing the error. Does getting a file work too? Bizarre. Only if you are not familiar with FTP :-) FTP is a rather peculiar protocol. Data transfer operations require opening a second data connection next to the control connection. Opening this data connection is not easy in a setup with firewalls, because this connection does not happen on fixed ports and in active mode is set up in the reverse direction (the server opens a connection to the client). Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFINSERT on CFMX (newbe question)
I took an old application that seemed to work fine in CF5 but now on CFMX I get errors with all my cfinsert, Why?Is there a quick fix? Do I have to edit all of them one by one? THE SHARK [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfquery
Hi guys, I have this query: CFQUERY NAME=PropertyDetails datasource=020 SELECT PropertyDataID, PropertyAgentID, PropertyDataAgentReference, PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, PropertyDataStreetName, PropertyDataVillageTown, PropertyDataCountyState, PropertyDataPostcodeZip, PropertyDataCountry, PropertyDataNumberofBedrooms, PropertyDataNumberofBathrooms, PropertyDataHouseType, PropertyDataPrice, PropertyDataDurationType, PropertyDataDescription, PropertyDataDateAdded FROM PropertyData WHERE PropertyDataID = #URL.PropertyDataID# AND PropertyAgentID = cfqueryparam cfsqltype=cf_sql_integer value=#client.propertyagentid# /CFQUERY Say if a user got to this page with a URL.PropertyID which equaled something in the database I thought that it wouldn't matter because of the rest of the WHERE clause stating that PropertyAgentID = Client.PropertyAgentID.When i try and access the page being a different client.PropertyAgentID, the page still displays but without the fields filled in, so i guess it works but wouldn't it be better if an error appeared.I thought that because the WHERE clause is false an error would occur but it doesn't. Anyone know a simple way to make an error occur when a user somehow gets to run this query not being the correct client for that propertydataid (via a url)? Cheers, Stuart [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFINSERT on CFMX (newbe question)
helps if you paste the exact error message and/or code. in this case, since cfinsert is fairly straightforward, what's the exact error? - Original Message - From: Steven Sharko [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 8:13 AM Subject: CFINSERT on CFMX (newbe question) I took an old application that seemed to work fine in CF5 but now on CFMX I get errors with all my cfinsert, Why?Is there a quick fix? Do I have to edit all of them one by one? THE SHARK [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
Why would an error occur in a perfectly valid query? You can simply have an alternate display if the query is empty: cfifPropertyDetails.recordCount !--- show table --- cfelse !--- alternate display --- /cfif -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 16:16 To: CF-Talk Subject: cfquery Hi guys, I have this query: CFQUERY NAME=PropertyDetails datasource=020 SELECT PropertyDataID, PropertyAgentID, PropertyDataAgentReference, PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, PropertyDataStreetName, PropertyDataVillageTown, PropertyDataCountyState, PropertyDataPostcodeZip, PropertyDataCountry, PropertyDataNumberofBedrooms, PropertyDataNumberofBathrooms, PropertyDataHouseType, PropertyDataPrice, PropertyDataDurationType, PropertyDataDescription, PropertyDataDateAdded FROM PropertyData WHERE PropertyDataID = #URL.PropertyDataID# AND PropertyAgentID = cfqueryparam cfsqltype=cf_sql_integer value=#client.propertyagentid# /CFQUERY Say if a user got to this page with a URL.PropertyID which equaled something in the database I thought that it wouldn't matter because of the rest of the WHERE clause stating that PropertyAgentID = Client.PropertyAgentID.When i try and access the page being a different client.PropertyAgentID, the page still displays but without the fields filled in, so i guess it works but wouldn't it be better if an error appeared.I thought that because the WHERE clause is false an error would occur but it doesn't. Anyone know a simple way to make an error occur when a user somehow gets to run this query not being the correct client for that propertydataid (via a url)? Cheers, Stuart [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Has anyone else noticed how handy cfinsert would be if you could get the inserted identity back? Marlon -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 9:24 AM To: CF-Talk Subject: Re: CFINSERT on CFMX (newbe question) helps if you paste the exact error message and/or code. in this case, since cfinsert is fairly straightforward, what's the exact error? - Original Message - From: Steven Sharko [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 8:13 AM Subject: CFINSERT on CFMX (newbe question) I took an old application that seemed to work fine in CF5 but now on CFMX I get errors with all my cfinsert, Why?Is there a quick fix? Do I have to edit all of them one by one? THE SHARK [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
I have this query: CFQUERY NAME=PropertyDetails datasource=020 SELECT PropertyDataID, PropertyAgentID, PropertyDataAgentReference, PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, PropertyDataStreetName, PropertyDataVillageTown, PropertyDataCountyState, PropertyDataPostcodeZip, PropertyDataCountry, PropertyDataNumberofBedrooms, PropertyDataNumberofBathrooms, PropertyDataHouseType, PropertyDataPrice, PropertyDataDurationType, PropertyDataDescription, PropertyDataDateAdded FROM PropertyData WHERE PropertyDataID = #URL.PropertyDataID# AND PropertyAgentID = cfqueryparam cfsqltype=cf_sql_integer value=#client.propertyagentid# /CFQUERY On a COMPLETELY different note - the URL.PropertyDataID is the thing you REALLY want to put in a CFQUERYPARAM Otherwise I could put 1;delete%20from%20PropertyData%20// and it would kill your data [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Can you give us a code example?I can think of lots of reasons. Is one of your field names a reserved keyword?Like date? Are your field names named like Address, Address2, Address3?See http://www.macromedia.com/support/coldfusion/ts/documents/cfinsert_hotfi x.htm . Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 9:13 AM To: CF-Talk Subject: CFINSERT on CFMX (newbe question) I took an old application that seemed to work fine in CF5 but now on CFMX I get errors with all my cfinsert, Why?Is there a quick fix? Do I have to edit all of them one by one? THE SHARK _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Marlon Moyer said: Has anyone else noticed how handy cfinsert would be if you could get the inserted identity back? That might be a future possibility once we move to JDBC 3: http://www.macromedia.com/go/wish/ Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\clients.cfm: line 34 32 :CFUPDATE datasource=#application.db# tablename=clients 33 :CFELSE 34 :CFINSERT datasource=#application.db# tablename=clients 35 :/CFIF 36 : /CFIF SQLinsert into clients (COMPANY,DATE) values ( (param 1) , (param 2) ) DATASOURCEdevchat VENDORERRORCODE-3502 SQLSTATE42000 Please try the following: At 10:36 AM 2/24/2004, you wrote: Marlon Moyer said: Has anyone else noticed how handy cfinsert would be if you could get the inserted identity back? That might be a future possibility once we move to JDBC 3: http://www.macromedia.com/go/wish/http://www.macromedia.com/go/wish/ Jochem -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Single Quotes in Comment Fields Problem
Hugo Ahlenius wrote: RTFM on cfqueryparam, you need to supply the 'value' and 'cfsqltype' as attributes to cfqueryparam: I did!I did RTFM! I just didn't understand how to work it back into the evaluate statement I was using to combine the field variable names along with the record id numbers to updte multiple rows. -- Les Mizzell -- Skill without imagination is craftsmanship and gives us many useful objects such as wickerwork picnic baskets. Imagination without skill gives us modern art. -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
I believe that date is reserved keyword. Try changing that field name. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 9:46 AM To: CF-Talk Subject: RE: CFINSERT on CFMX (newbe question) Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\clients.cfm: line 34 32 :CFUPDATE datasource=#application.db# tablename=clients 33 :CFELSE 34 :CFINSERT datasource=#application.db# tablename=clients 35 :/CFIF 36 : /CFIF SQLinsert into clients (COMPANY,DATE) values ( (param 1) , (param 2) ) DATASOURCEdevchat VENDORERRORCODE-3502 SQLSTATE42000 Please try the following: At 10:36 AM 2/24/2004, you wrote: Marlon Moyer said: Has anyone else noticed how handy cfinsert would be if you could get the inserted identity back? That might be a future possibility once we move to JDBC 3: http://www.macromedia.com/go/wish/http://www.macromedia.com/go/wish/ Jochem -- [ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
From: Marlon Moyer Has anyone else noticed how handy cfinsert would be if you could get the inserted identity back? Well, if you want to do something like that, don't use CFINSERT - use a regular CFQUERY and you have complete control over what you want to do I've not used CFINSERT or CFUPDATE for years, purely for the fact that you have no real control over what's going on internally [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
Thanks Philip and Pascal, I've fixed it up so now I have a cfquery param on url.propertydataid (making sure it's only an integer which is processed) and also checked if the recordcount is gt 0 then display the form otherwise display a message saying that You don't have user rights to edit this record. When I get some spare time i'm going to go through all my code and put cfqueryparams everywhere.One thing I don't understand is though, if i put a cfqueryparam on PropertyDataVillageTown for instance, this will be any type of string inputed therefore couldn't a hacker still put his/her malicious stuff in?Or will it block '%', '', '' and that sort of stuff? CFQUERY NAME=PropertyDetails datasource=020 SELECT PropertyDataID, PropertyAgentID, PropertyDataAgentReference, PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, PropertyDataStreetName, PropertyDataVillageTown, PropertyDataCountyState, PropertyDataPostcodeZip, PropertyDataCountry, PropertyDataNumberofBedrooms, PropertyDataNumberofBathrooms, PropertyDataHouseType, PropertyDataPrice, PropertyDataDurationType, PropertyDataDescription, PropertyDataDateAdded FROM PropertyData WHERE PropertyDataID = cfqueryparam cfsqltype=cf_sql_integer value=#URL.PropertyDataID# AND PropertyAgentID = cfqueryparam cfsqltype=cf_sql_integer value=#client.propertyagentid# /CFQUERY cfif PropertyDetails.recordCount GT 0 Thanks guys. -- Original Message -- From: Pascal Peters [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 24 Feb 2004 16:24:04 +0100 Why would an error occur in a perfectly valid query? You can simply have an alternate display if the query is empty: cfifPropertyDetails.recordCount !--- show table --- cfelse !--- alternate display --- /cfif -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 16:16 To: CF-Talk Subject: cfquery Hi guys, I have this query: CFQUERY NAME=PropertyDetails datasource=020 SELECT PropertyDataID, PropertyAgentID, PropertyDataAgentReference, PropertyDataFlatNumberHouseName, PropertyDataStreetNumber, PropertyDataStreetName, PropertyDataVillageTown, PropertyDataCountyState, PropertyDataPostcodeZip, PropertyDataCountry, PropertyDataNumberofBedrooms, PropertyDataNumberofBathrooms, PropertyDataHouseType, PropertyDataPrice, PropertyDataDurationType, PropertyDataDescription, PropertyDataDateAdded FROM PropertyData WHERE PropertyDataID = #URL.PropertyDataID# AND PropertyAgentID = cfqueryparam cfsqltype=cf_sql_integer value=#client.propertyagentid# /CFQUERY Say if a user got to this page with a URL.PropertyID which equaled something in the database I thought that it wouldn't matter because of the rest of the WHERE clause stating that PropertyAgentID = Client.PropertyAgentID.When i try and access the page being a different client.PropertyAgentID, the page still displays but without the fields filled in, so i guess it works but wouldn't it be better if an error appeared.I thought that because the WHERE clause is false an error would occur but it doesn't. Anyone know a simple way to make an error occur when a user somehow gets to run this query not being the correct client for that propertydataid (via a url)? Cheers, Stuart [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
From: Mark W. Breneman I believe that date is reserved keyword. Try changing that field name. Or switch to CFQUERY and put square brackets around the field names [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
From: Stuart Kidd When I get some spare time i'm going to go through all my code and put cfqueryparams everywhere.One thing I don't understand is though, if i put a cfqueryparam on PropertyDataVillageTown for instance, this will be any type of string inputed therefore couldn't a hacker still put his/her malicious stuff in?Or will it block '%', '', '' and that sort of stuff? No - the CFQUERYPARAM passes the data as a parameter, and it forces it to be a string that the database can handle - so anything in there is always entered into the field correctly (or used as a WHERE CFQUERYPARAM is the best way to protect your database from malicious attacks, although you have to trap for wrong datatypes outside of the query [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
Thanks for that Philip, that gives me a better understanding. But I suppose trapping for wrong datatypes outside of the query opens a whole new can of worms?... -- Original Message -- From: Philip Arnold [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 24 Feb 2004 11:07:31 -0500 From: Stuart Kidd When I get some spare time i'm going to go through all my code and put cfqueryparams everywhere.One thing I don't understand is though, if i put a cfqueryparam on PropertyDataVillageTown for instance, this will be any type of string inputed therefore couldn't a hacker still put his/her malicious stuff in?Or will it block '%', '', '' and that sort of stuff? No - the CFQUERYPARAM passes the data as a parameter, and it forces it to be a string that the database can handle - so anything in there is always entered into the field correctly (or used as a WHERE CFQUERYPARAM is the best way to protect your database from malicious attacks, although you have to trap for wrong datatypes outside of the query [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Will that fieldname date come back to bite him later?Seems like I changed a database or two due to other issues related to using the field name date.Can't remember right now.. Maybe it was just to not use the reserved word.. Thoughts??? Yes using a real SQL statement is the better way to go then to use Cfinsert or Cfupdate. Ha, It must be the masochist in me but I still use Cfupdate and insert even after CFMX issues and 5+ years of CF programming. Go figure.. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 10:05 AM To: CF-Talk Subject: RE: CFINSERT on CFMX (newbe question) From: Mark W. Breneman I believe that date is reserved keyword. Try changing that field name. Or switch to CFQUERY and put square brackets around the field names _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
DATE is a reserved word. Either change the column name in the db or switch to cfquery -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 16:46 To: CF-Talk Subject: RE: CFINSERT on CFMX (newbe question) Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\clients.cfm: line 34 32 :CFUPDATE datasource=#application.db# tablename=clients 33 :CFELSE 34 :CFINSERT datasource=#application.db# tablename=clients 35 :/CFIF 36 : /CFIF SQLinsert into clients (COMPANY,DATE) values ( (param 1) , (param 2) ) DATASOURCEdevchat VENDORERRORCODE-3502 SQLSTATE42000 Please try the following: At 10:36 AM 2/24/2004, you wrote: Marlon Moyer said: Has anyone else noticed how handy cfinsert would be if you could get the inserted identity back? That might be a future possibility once we move to JDBC 3: http://www.macromedia.com/go/wish/http://www.macromedia.com /go/wish/ Jochem -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Crystal Reports
Hi all, I was wondering if anyone can explain to me how exactly Crystal Reports work with CF. I have a request from my users to replace their Access based report with web based reports and I think Crystal is the best route - maybe. Does Crystal need to be installed on the CF server? What version of Crystal is needed as I have two different versions of CF running. I on set of servers that is still using CF4.5 - waiting to be upgraded and another set running MX. Is there any other report writers out there that will work with CF? I have been working with iText to make pdf's but I am not sure if this is good for what I want to do. If anyone has any ideas or knows of any other solutions, can you let me know. Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Mark W. Breneman said: Will that fieldname date come back to bite him later? It will probably continue to cause inconvenience, but nothing major. It is just not something you would want a prospective employer to see. Ha, It must be the masochist in me but I still use Cfupdate and insert even after CFMX issues and 5+ years of CF programming. Go figure.. It should not be that hard to write your own cfinsert and cfupdate if you ever feel the need to abandon them. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about CFQUERYPARAM and GUIDs
At 11:16 AM -0600 2/23/04, Justin Hansen wrote: I use CF_SQL_VARCHAR for GUIDs. It works just fine. What if a string of characters, formatted just the same as a GUID but with one less character, was used?According to my coworker, this would validate just the same as a real GUID. -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net | Blog at http://www.lolajl.net/blog/ I'm in Bowie, MD, USA, halfway between DC and Annapolis. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Jochem van Dieten said: It should not be that hard to write your own cfinsert and cfupdate if you ever feel the need to abandon them. Yes, I have started several times to plan out just what my Cfupdate any Cfinsert would do based on how we use it, but then I realize that 98% of that is already done by the current Cfupdate and Cfinsert. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 10:26 AM To: CF-Talk Subject: RE: CFINSERT on CFMX (newbe question) Mark W. Breneman said: Will that fieldname date come back to bite him later? It will probably continue to cause inconvenience, but nothing major. It is just not something you would want a prospective employer to see. Ha, It must be the masochist in me but I still use Cfupdate and insert even after CFMX issues and 5+ years of CF programming. Go figure.. It should not be that hard to write your own cfinsert and cfupdate if you ever feel the need to abandon them. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about CFQUERYPARAM and GUIDs
Any character string will validate if you use CF_SQL_VARCHAR, regardless of
format.If you want to validate a GUID, you'll have to use something more
than just CFQUERYPARAM.Easiest is probably a simple Refind call, with the
appropriate RE.I don't know the exact format of a GUID, but it should be
something like this (change the numbers, and maybe add another segment):
isValid = refind(^[0-9a-fA-F]{5}-[0-9a-fA-F]{5}-[0-9a-fA-F]{5}$, myGuid);
Cheers,
barneyb
-Original Message-
From: Lola Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 8:32 AM
To: CF-Talk
Subject: RE: Question about CFQUERYPARAM and GUIDs
At 11:16 AM -0600 2/23/04, Justin Hansen wrote:
I use CF_SQL_VARCHAR for GUIDs. It works just fine.
What if a string of characters, formatted just the same as a GUID but
with one less character, was used?According to my coworker, this
would validate just the same as a real GUID.
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
I'm in Bowie, MD, USA, halfway between DC and Annapolis.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: SOT: cfeclipse version 1.1.1 released - if you care
On Tue, 2004-02-24 at 01:43, Thomas Chiverton wrote: On Tuesday 24 Feb 2004 09:34 am, Thomas Chiverton wrote: Great job, once again. Except it appears to be missing some files in /icons/ - like the title bar and menu icons. I copied the /icons/ dir from 1.1.0 into the /icons/ dir of 1.1.1 and that has fixed it. I changed the directory structure for 1.1.1's icons to be standard to eclipse (I read an article hehehe) - I had to remove the 1.1.0 directory from the plugin's directory to get the 1.1.1 icons to show up(I think they are cached somehow) and all was fine (you way seem cool too :) -- Vale, Rob Luxuria immodica insaniam creat. Sanam formam viatae conservate! http://www.rohanclan.com http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: REFind
Not within a character class.If you're careful about how you construct it, you never have to escape anything in a class.Unless I forgot about something, or course.:-) --Ben Doom Taco Fleur wrote: Don't you have to escape the period? like so \. Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 February 2004 8:17 PM To: CF-Talk Subject: RE: REFind REFind([^0-9],form.PropertyDataPrice) If you want to allow other caracters like . and , add them in the class: REFind([^0-9.,],form.PropertyDataPrice) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 10:50 To: CF-Talk Subject: REFind Hi guys, I'm trying to make sure that my field has ONLY numeric characters otherwise show an error.I'm using the REFind but it doesn't pick up characters like $ £ etc. cfelseif REFind([[:num:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif Any ideas? Cheers, Stu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question about CFQUERYPARAM and GUIDs
Lola Lee wrote: At 11:16 AM -0600 2/23/04, Justin Hansen wrote: I use CF_SQL_VARCHAR for GUIDs. It works just fine. What if a string of characters, formatted just the same as a GUID but with one less character, was used?According to my coworker, this would validate just the same as a real GUID. It would. But that is the risk you take when you use datatypes that are neither standardized in SQL nor in JDBC. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about CFQUERYPARAM and GUIDs
At 8:38 AM -0800 2/24/04, Barney Boisvert wrote:
Any character string will validate if you use CF_SQL_VARCHAR, regardless of
format.If you want to validate a GUID, you'll have to use something more
than just CFQUERYPARAM.Easiest is probably a simple Refind call, with the
appropriate RE.I don't know the exact format of a GUID, but it should be
something like this (change the numbers, and maybe add another segment):
isValid = refind(^[0-9a-fA-F]{5}-[0-9a-fA-F]{5}-[0-9a-fA-F]{5}$, myGuid);
Isn't this counterintuitive?
We're being told to use CFQUERYPARAM in cfqueries.But if I
understand it correctly, there is no CF_SQL types that handle GUIDs.
What we need to be able to do is something like this:
cfquery verifyUser
select * from user
where UserID = cfqueryparam type=CF_SQL_xxx value=GUID
/cfquery
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
I'm in Bowie, MD, USA, halfway between DC and Annapolis.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: SOT: cfeclipse version 1.1.1 released - if you care
Rob, what is cfeclipse? I went to http://cfeclipse.rohanclan.com/ and can't make heads or tails of it? Is it an editor? That's what it sounds like from the notes there. Is it freeware/shareware? Where can it be downloaded from? Greg -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:45 AM To: CF-Talk Subject: Re: SOT: cfeclipse version 1.1.1 released - if you care On Tue, 2004-02-24 at 01:43, Thomas Chiverton wrote: On Tuesday 24 Feb 2004 09:34 am, Thomas Chiverton wrote: Great job, once again. Except it appears to be missing some files in /icons/ - like the title bar and menu icons. I copied the /icons/ dir from 1.1.0 into the /icons/ dir of 1.1.1 and that has fixed it. I changed the directory structure for 1.1.1's icons to be standard to eclipse (I read an article hehehe) - I had to remove the 1.1.0 directory from the plugin's directory to get the 1.1.1 icons to show up(I think they are cached somehow) and all was fine (you way seem cool too :) -- Vale, Rob Luxuria immodica insaniam creat. Sanam formam viatae conservate! http://www.rohanclan.com http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about CFQUERYPARAM and GUIDs
We're being told to use CFQUERYPARAM in cfqueries. But if I understand it correctly, there is no CF_SQL types that handle GUIDs. What we need to be able to do is something like this: cfquery verifyUser select * from user where UserID = cfqueryparam type=CF_SQL_xxx value=GUID /cfquery I don't think that UUID/GUID is a defined data type within SQL; it's specific to SQL Server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about CFQUERYPARAM and GUIDs
CFQUERYPARAM protects your database.It includes very primitive data
validation for standardized SQL types.That validation is for protection
only, in most cases, it's completely insufficient for the specific data of
an app.For example, the INTEGER type will happily let you store a persons
age that is negative or in the millions, as long as it's an integer, so you
almost always have to provide additional validation.
This is even worse with non-standard data types, such as SQL Server's GUID
type, MySQL's SET and ENUM types, etc.The best you can do is to use a
CF_SQL_VARCHAR, which will protect the database as well, but won't provide
you with any validation, so you have to provide external validation.
Bottom line, CFQUERYPARAM is an extra layer of security on your database,
it's not for validation.It can be used that way, but only in a supporting
role.
Cheers,
barneyb
-Original Message-
From: Lola Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 8:54 AM
To: CF-Talk
Subject: RE: Question about CFQUERYPARAM and GUIDs
At 8:38 AM -0800 2/24/04, Barney Boisvert wrote:
Any character string will validate if you use
CF_SQL_VARCHAR, regardless of
format.If you want to validate a GUID, you'll have to use
something more
than just CFQUERYPARAM.Easiest is probably a simple Refind
call, with the
appropriate RE.I don't know the exact format of a GUID,
but it should be
something like this (change the numbers, and maybe add
another segment):
isValid =
refind(^[0-9a-fA-F]{5}-[0-9a-fA-F]{5}-[0-9a-fA-F]{5}$, myGuid);
Isn't this counterintuitive?
We're being told to use CFQUERYPARAM in cfqueries.But if I
understand it correctly, there is no CF_SQL types that handle GUIDs.
What we need to be able to do is something like this:
cfquery verifyUser
select * from user
where UserID = cfqueryparam type=CF_SQL_xxx value=GUID
/cfquery
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
I'm in Bowie, MD, USA, halfway between DC and Annapolis.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Question about CFQUERYPARAM and GUIDs
Isn't this counterintuitive?
I'd answer no.What you're asking for is akin to a cfsqltype to
enforce, say, a telephone number to 999-999-.That's not what
cfqueryparam is about.You're really talking about a formatting mask
and not validating a standard SQL datatype.
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc.http://mysecretbase.com
-Original Message-
From: Lola Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 8:54 AM
To: CF-Talk
Subject: RE: Question about CFQUERYPARAM and GUIDs
At 8:38 AM -0800 2/24/04, Barney Boisvert wrote:
Any character string will validate if you use CF_SQL_VARCHAR,
regardless of
format.If you want to validate a GUID, you'll have to use something
more
than just CFQUERYPARAM.Easiest is probably a simple Refind call, with
the
appropriate RE.I don't know the exact format of a GUID, but it should
be
something like this (change the numbers, and maybe add another
segment):
isValid = refind(^[0-9a-fA-F]{5}-[0-9a-fA-F]{5}-[0-9a-fA-F]{5}$,
myGuid);
Isn't this counterintuitive?
We're being told to use CFQUERYPARAM in cfqueries.But if I
understand it correctly, there is no CF_SQL types that handle GUIDs.
What we need to be able to do is something like this:
cfquery verifyUser
select * from user
where UserID = cfqueryparam type=CF_SQL_xxx value=GUID
/cfquery
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
I'm in Bowie, MD, USA, halfway between DC and Annapolis.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Break the block, and SURVIVE, any way?
A browser can be configured to accept cookies from a server while a spider does not seem to have an ability to accept cookie(s), hence it failed to go further (been redirected to some other place). Spiders have whatever ability you provide them - they're programs that you write yourself. If you want your spider to accept cookies, your program will have to keep track of the cookies that it receives. You can get to these cookies after an HTTP request by looking at CFHTTP.ResponseHeader or CFHTTP.Header. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question about CFQUERYPARAM and GUIDs
Lola Lee wrote:
At 8:38 AM -0800 2/24/04, Barney Boisvert wrote:
Any character string will validate if you use CF_SQL_VARCHAR, regardless of
format.If you want to validate a GUID, you'll have to use something more
than just CFQUERYPARAM.Easiest is probably a simple Refind call, with the
appropriate RE.I don't know the exact format of a GUID, but it should be
something like this (change the numbers, and maybe add another segment):
isValid = refind(^[0-9a-fA-F]{5}-[0-9a-fA-F]{5}-[0-9a-fA-F]{5}$, myGuid);
Isn't this counterintuitive?
No. SQL allows you to even create your own datatypes. Why would
some cf_sql-type automagically exists when I write my own
datatype for GUIDs or ISBN numbers?
The SQL standard has a number of predefined datatypes. For those
cf_sql-types are provided. If you wish to use other datatypes you
are on your own.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Question about CFQUERYPARAM and GUIDs
From: Lola Lee Isn't this counterintuitive? We're being told to use CFQUERYPARAM in cfqueries.But if I understand it correctly, there is no CF_SQL types that handle GUIDs. What we need to be able to do is something like this: cfquery verifyUser select * from user where UserID = cfqueryparam type=CF_SQL_xxx value=GUID /cfquery Not at all What you have to remember is that a GUID is just a string of characters - different systems produce them differently CF, SQL Server and other apps won't produce the same data layout If you expand it for GUID, people will ask for a data-type for emails, Zip, telephone numbers and credit cards (But they're valid data-types, right?) You're meant to do the validation yourself, and then pass your data to the server [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfquery
From: Stuart Kidd Thanks for that Philip, that gives me a better understanding. No problems, glad to help g But I suppose trapping for wrong datatypes outside of the query opens a whole new can of worms?... It throws an error, so you'd have to do a CFTRY, CFCATCH to check that the error thrown is of the correct type, and then either report it or just re-run the query with data you want to pass it All part of the joys of error trapping [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: cfeclipse version 1.1.1 released - if you care
On Tue, 2004-02-24 at 08:55, Greg Luce wrote: Rob, what is cfeclipse? I went to http://cfeclipse.rohanclan.com/ and can't make heads or tails of it? Is it an editor? That's what it sounds like from the notes there. Is it freeware/shareware? Where can it be downloaded from? Sorry, Eclipse is an open source IDE / framework for java from IBM (and I think Macromedia had a hand in it too). You can read about it and download it here http://www.eclipse.org. It's a java IDE by default, but you can add plug-ins for other languages - actually you can add plug-ins for pretty much anything. People have made UML modelers and IM plug-ins - all kinds of stuff. It's kind of like .net for java. If you have used a java type editor before, you'll probably have noticed it was kind of slow (like netbeans), but this one uses native under java so it crazy fast (Uses activeX stuff on windows, GTK on linux, Cocca on Mac, etc). In fact, some say that eclipse with the cfeclipse plug-in is faster / more responsive then dw - that is opinion and cfeclipse has far less features then dw. Anyway, to take the long way around, Eclipse is an IDE, cfeclipse is a plug-in to make Eclipse an CF IDE/Editor - they are both free and open source. http://www.eclipse.org http://cfeclipse.rohanclan.com Cheers whiner I used dreamweaver a couple of jobs ago and I didn't like it. It's a great product but it was not written for coders it was written for people who needed a wizard to make a query tag. I found it to be intrusive and unhelpful and an editor should help not hinder. Finally I do mostly contract work, I use Linux and dw wont work on Linux (purposefully I think). I didn't like dw for the reasons listed below: * It doesn't work on linux * I could not do Emacs key bindings * that stupid blue line number gutter thing, why blue? why cant I turn that off? * the price is out of control * function helping not helpful * it just seems to be made by designers for designers - lots of little things - if you look at a code based IDE and you look at dw, you can just tell its not a code based IDE * I write quite a bit of java and I like to compile java and have access to cf at the same times (like writing and testing beans or cfx tags) * an abundant of wizards piss me off. /whiner Greg -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:45 AM To: CF-Talk Subject: Re: SOT: cfeclipse version 1.1.1 released - if you care On Tue, 2004-02-24 at 01:43, Thomas Chiverton wrote: On Tuesday 24 Feb 2004 09:34 am, Thomas Chiverton wrote: Great job, once again. Except it appears to be missing some files in /icons/ - like the title bar and menu icons. I copied the /icons/ dir from 1.1.0 into the /icons/ dir of 1.1.1 and that has fixed it. I changed the directory structure for 1.1.1's icons to be standard to eclipse (I read an article hehehe) - I had to remove the 1.1.0 directory from the plugin's directory to get the 1.1.1 icons to show up(I think they are cached somehow) and all was fine (you way seem cool too :) -- Vale, Rob Luxuria immodica insaniam creat. Sanam formam viatae conservate! http://www.rohanclan.com http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Single Quotes in Comment Fields Problem
I just didn't understand how to work it back into the evaluate statement I was using to combine the field variable names along with the record id numbers to updte multiple rows. I recently ran into this issue and found that the Evaluate function can cause problems in query statements if you have single quotes in there. Try running the Evaluate outside the cfquery (just set a new variable with the results) and use that in your cfqueryparam. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
Scott Brady wrote: Try swapping the last two cfprocparams.Assuming you're using CFMX, CFMX no longer uses the dbvarname attribute (at least for Oracle, not sure about other databases), so the order in which you provide the parameters needs to match the order they're defined in the procedure. In the procedure, you have success last, but in the CF you're listing studentID last. Scott, That fixed one issue.Thanks! -- Richard S. Crawford Programmer/Analyst III, UC Davis Extension Distance Learning Group (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question about CFQUERYPARAM and GUIDs
Philip Arnold wrote: What you have to remember is that a GUID is just a string of characters - different systems produce them differently Actually, a GUID is a 128 bit integer that is produced according to the same algorithm everywhere. CF, SQL Server and other apps won't produce the same data layout Even the string representation of a GUID is the same everywhere. There is however a difference between the string representation of a GUID and a UUID. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: cfeclipse version 1.1.1 released - if you care
Rob, How do I check that I'm using 1.1.1 and not previous versions? Won [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
New Book
This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc.You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: cfeclipse version 1.1.1 released - if you care
Rob, I should be a little more specific.The reason that I ask is because I extracted it to e:\eclipse\plugins. It created a directory com.rohanclan.coldfusionmx_1.1.1 and I do see the jar file there. But when i go into the configuration history and I don't see an reference to 1.1.1.I do see old references to 1.0.5 though. Won [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: cfeclipse version 1.1.1 released - if you care
I sent a reply to this but it doesn't seem to have been posted - sorry if this gets duped. to be brief: File/Open no worky at present File/new/project/simple/project then add or import cfm,cfc, or cfml files will work On Tue, 2004-02-24 at 03:44, Oliver Tupman wrote: Hi Rob, Downloaded a clean copy M7 of Eclipse 3 and followed the steps for installing the plugin. I also copied the icons from 1.1.0 to 1.1.1. I open a CFM file and here's what I get: i) The plugin's toolbar ii) The plugin's menubar iii) An error in the window that the CFM file should be displayed in saying ERROR and nowt else! I'm running Version 3.0.0, build ID 200402122000 on Windows 2k. I've no idea how Eclipse works, nor a huge amount of Java experience but surely there should be some way of outputting debug info? Maybe some sort of menu option (for the moment)? In fact, are there any pointers you can give me on getting started with your source? I'd love to help out - Homesite is annoying me and I don't think my boss will fork out for Dreamweaver as it does a whole lot of stuff I don't need! So if you've pointers on how to get started, good websites, etc. I'd be very grateful! To start off with, how would you start debug my problem? How does one debug Eclipse? Perhaps I can fix my own problem! The joys of open source, no? Anyway, good work on the menu options as that's all I see at the moment :D Oliver Tupman. Rob Rohan wrote: This version has a couple bug fixes, and adds snips. Snips are the same thing as snippets with a different file format. They can *not* be assigned to key strokes yet (I know - I know). The snips are xml files that need to be placed in your [home]/workspace/.metadata/.plugins/com.rohanclan.coldfusionmx directory, and are then uses buy turning on the Snip View by selecting Windows/Show View/Other... then Snip View/Snip View from the Eclipse IDE menubar. changes: * Bug fix: crazy double clicking highlight - double clicks now act normal * Bug fix: the code insight now stays open and limits selections as you type (tags and attributes only) * Bug fix: the cursor is moved to the middle of any inserted items (i.e. comments and hash inserts) * Added snips - much like snippets, and can read dreamweaver snippets, but imported dreamweaver snippets don't work right yet. * Ctrl+Shift+R creates a cfscript block happy cfcoding -- Vale, Rob Luxuria immodica insaniam creat. Sanam formam viatae conservate! http://www.rohanclan.com http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: cfeclipse version 1.1.1 released - if you care
On Tue, 2004-02-24 at 09:32, Won Lee wrote: Rob, How do I check that I'm using 1.1.1 and not previous versions? Help/About eclipse platform/plug-in details should list all installed plug-ins and versions Won [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: New Book
Congratulations Jeff! Can't wait to see it. --- Ben _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 12:19 PM To: CF-Talk Subject: New Book This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc. You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: cfeclipse version 1.1.1 released - if you care
On Tue, 2004-02-24 at 09:34, Won Lee wrote: Rob, I should be a little more specific.The reason that I ask is because I extracted it to e:\eclipse\plugins. It created a directory com.rohanclan.coldfusionmx_1.1.1 and I do see the jar file there. But when i go into the configuration history and I don't see an reference to 1.1.1.I do see old references to 1.0.5 though. To use the new plug-ins you have to have eclipse 3.0M7 not 2.1.2 - I stopped writing for version 2 as the api changed in 3 and I dont have the man power to keep up 2 separate versions sorry :( Won [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Factoring out locking in CFC
Say I've got a CFC with several methods whose operations (e.g. cfexecutes) need identical named locks, so that none can run concurrently. Is there a way to factor out a locking method that can be used by the other methods, or is this the exclusive domain of custom tags? The only way that I can figure to do it in the context of a CFC is to abstract the whole idea of an operation into its own method, and lock the operation there. Am I thinking straight? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: cfeclipse version 1.1.1 released - if you care
Rob Thanks.I just realized that I did a re-install of 2.1.1. I guess that means I can only get up to cfeclipse 1.0.5? At 09:36 AM 2/24/2004 -0800, you wrote: On Tue, 2004-02-24 at 09:32, Won Lee wrote: Rob, How do I check that I'm using 1.1.1 and not previous versions? Help/About eclipse platform/plug-in details should list all installed plug-ins and versions Won -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about CFQUERYPARAM and GUIDs
Even the string representation of a GUID is the same everywhere. There is however a difference between the string representation of a GUID and a UUID. Sorry, I meant UUID/GUID g [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
If you've got it set to maintain connections in the administrator, have you tried disabling that setting? If not, you might try that for a few days, and see if the problem reoccurs. Jamie On Tue, 24 Feb 2004 13:40:47 +1000, in cf-talk you wrote: Please Help My companies live hosting server was recently upgraded to Coldfusion MX6.1 .. and the latest MDAC / Jet Drivers have been updated also.The problem is that all coldfusion sites on the server using access db's stop working every 2 days or so (more often if traffic is high).. the only way to get it running again is to restart the whole server. Has anyone had this problem and managed to fix it?I've run this hot-fix: http://www.macromedia.com/support/coldfusion/ts/documents/conn_pool_hotfix.htm and it made no difference.We're re-installed MDAC 2.8, re-applied the latest security patch and re-installed JET several times... the only thing that has not been re-installed is the MX 6.1 updater. The error message the sites throw is this: Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: Thanks in advance. Will [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Factoring out locking in CFC
Well... You could have a flag (or structure of flags) in the CFC scope, that you set and read depending on the locking status. It could also be that the locks should be on the calling page/cfc/etc, e.g. start lock, create object, call method1, call method2, end lock. /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Jamie Jackson [mailto:[EMAIL PROTECTED] | Sent: Tuesday, February 24, 2004 18:40 | To: CF-Talk | Subject: Factoring out locking in CFC | | Say I've got a CFC with several methods whose operations (e.g. | cfexecutes) need identical named locks, so that none can | run concurrently. Is there a way to factor out a locking | method that can be used by the other methods, or is this the | exclusive domain of custom tags? | | The only way that I can figure to do it in the context of a | CFC is to abstract the whole idea of an operation into its | own method, and lock the operation there. | | Am I thinking straight? | | Thanks, | Jamie | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: New Book
Just purchased it! 19.99 is a good buy. I'll let you know how I like it. Dave - Original Message - From: Ben Forta To: CF-Talk Sent: Tuesday, February 24, 2004 12:38 PM Subject: RE: New Book Congratulations Jeff! Can't wait to see it. --- Ben _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 12:19 PM To: CF-Talk Subject: New Book This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc. You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Factoring out locking in CFC
You can't do a body with a function like you can do with a custom tag, so I think you're stuck, if you can't abstract out the entire operation. However, that's definitely the best way to go; no sense in having the same code more than once if you can help it. If it's not possible, then set up the lock name as a variable in your CFC, and then use that variable, if you're not already.Then you're assured that you're always using the same lock name. Cheers, barneyb -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 9:40 AM To: CF-Talk Subject: Factoring out locking in CFC Say I've got a CFC with several methods whose operations (e.g. cfexecutes) need identical named locks, so that none can run concurrently. Is there a way to factor out a locking method that can be used by the other methods, or is this the exclusive domain of custom tags? The only way that I can figure to do it in the context of a CFC is to abstract the whole idea of an operation into its own method, and lock the operation there. Am I thinking straight? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: New Book
Well done Jeff, Just one question, which versions of CF does it cover? Kola -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 17:19 To: CF-Talk Subject: New Book This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc.You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SOT: cfeclipse version 1.1.1 released - if you care
On Tue, 2004-02-24 at 09:41, Won Lee wrote: Rob Thanks.I just realized that I did a re-install of 2.1.1. I guess that means I can only get up to cfeclipse 1.0.5? Yeah, unless you want to back port the newer stuff to 2 - That would help quite a few people I think. The source for the 3 version is on the site - if I had time I would sorry. -- Vale, Rob Luxuria immodica insaniam creat. Sanam formam viatae conservate! http://www.rohanclan.com http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: cfeclipse version 1.1.1 released - if you care
In fact, some say that eclipse with the cfeclipse plug-in is faster / more responsive then dw - that is opinion and cfeclipse has far less features then dw. Being faster than DW isn't that hard :-))) Apart from this, yes, Eclipse is faster than most Java IDEs out there Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: New Book
I'll def be checking it out. Your FB3 book was a good read, you've got a very casual wirting style that makes it easy to go cover to cover. Although, not to offend, I found that last chapter to be the funniest thing I've read in a techbook in awhile. hehehe. Nuthin' but net. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 05:38 PM To: 'CF-Talk' Subject: RE: New Book Congratulations Jeff! Can't wait to see it. --- Ben _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 12:19 PM To: CF-Talk Subject: New Book This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc. You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help: UTF-16 in ColdFusion 5???
I'm using the Microsoft XML Services (v4) parser with CF5 on Windows. I'm getting an error and this page http://support.microsoft.com/default.aspx?scid=kb;EN-US;q247708 explains that the reason is because I have to convert my ColdFusion 5 string to UTF-16 before I can pass the string to the Microsoft XML parser. How the heck can I convert my string to UTF-16 in ColdFusion 5??? Is there an alternative way to do this? I'm one line of code away from being done with this hassle... Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
Thomas Chiverton wrote: On Monday 23 Feb 2004 23:37 pm, Richard Crawford wrote: more disturbing indications that Oracle Stored Procedures do not return result sets. I am investigating this today / yesterday. Using cfprocresult works, with Oracle 9i and CFMX6.1 under weblogic, using CFMX 'oracle' datasources. Some combination of WebLogic JNDI datasources and some beta MM drivers causes this to break, however. Our setup:Oracle 9i, CFMX, JRun, Apache.Weblogic doesn't seem to be involved in our servers. -- Richard S. Crawford Programmer/Analyst III, UC Davis Extension Distance Learning Group (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: New Book
Thanks, Ben. - Jeff On 24 Feb 2004 at 12:38, Ben Forta wrote: Congratulations Jeff! Can't wait to see it. --- Ben _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 12:19 PM To: CF-Talk Subject: New Book This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc. You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: New Book
The illustrations are rendered in CFMX, and the book is aimed there, but I tried to make comments where previous versions were concerned.Note, though, that I didn't make notes on every function as to which versions have that function.The book should be beneficial to users of any version 4.5 and later, as well as the BlueDragon adherents out there. - Jeff On 24 Feb 2004 at 18:01, Kola Oyedeji wrote: Well done Jeff, Just one question, which versions of CF does it cover? Kola -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 24 February 2004 17:19 To: CF-Talk Subject: New Book This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc.You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: New Book
No offense taken at all!It was intended to amuse.You should've seen the fight I had with our editors to get that chapter in, though.They literally didn't know how to deal with fiction.It was almost unbelievable.I'm glad you enjoyed it. - Jeff On 24 Feb 2004 at 18:43, [EMAIL PROTECTED] wrote: I'll def be checking it out. Your FB3 book was a good read, you've got a very casual wirting style that makes it easy to go cover to cover. Although, not to offend, I found that last chapter to be the funniest thing I've read in a techbook in awhile. hehehe. Nuthin' but net. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 05:38 PM To: 'CF-Talk' Subject: RE: New Book Congratulations Jeff! Can't wait to see it. --- Ben _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 12:19 PM To: CF-Talk Subject: New Book This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc. You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Help: UTF-16 in ColdFusion 5???
I'm using the Microsoft XML Services (v4) parser with CF5 on Windows. I'm getting an error and this page http://support.microsoft.com/default.aspx?scid=kb;EN-US;q247708 explains that the reason is because I have to convert my ColdFusion 5 string to UTF-16 before I can pass the string to the Microsoft XML parser. How the heck can I convert my string to UTF-16 in ColdFusion 5??? Is there an alternative way to do this? I'm one line of code away from being done with this hassle... According to the URL you posted: Scripting developers have two options available: 1. Convert your XML documents to UTF-16-formatted Unicode, either automatically or by hand.Escape all non-Unicode character encodings inside the XML document using XML Unicode entity references. Any XML character can be encoded in plain ASCII using the form #, where is its index into the Unicode character set. 2. Escape all non-Unicode character encodings inside the XML document using XML Unicode entity references. Any XML character can be encoded in plain ASCII using the form #, where is its index into the Unicode character set. Out of curiosity, have you identified the invalid characters? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: New Book
Good luck with your book, Jeff! I ordered it and will provide some feedback. Irvin This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc.You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: New Book
Thanks, Irvin.I look forward to hearing from you. - Jeff On 24 Feb 2004 at 14:26, Irvin Gomez wrote: Good luck with your book, Jeff! I ordered it and will provide some feedback. Irvin This message is an advertisement of sorts, and something of a birth announcement as well. I hope you don't mind my taking a bit of your bandwidth with it: *** My new book--ColdFusion Lists, Arrays, Structures--is available for ordering online.You can pick it up here: http://www.protonarts.com The book is intended to answer all those questions about complex datatypes that Macromedia's documentation leaves unanswered (assuming you've read all the documentation!).If you're new to CF, it will give you a rapid and thorough introduction to lists, arrays, and structures.If you're an old hand, you might still be surprised at what you find. There are plenty of examples and illustrations, and lots of code. If you buy the book, please do me a couple of favors: 1.Write me a note and let me know what you think about the book, its quality, content, price, etc.Good or bad, I'd like to hear your thoughts.Also tell me about your experience with ordering, delivery, etc.I'm not working with a major publishing house this time, so I want to make sure the process works smoothly. 2.If you like the book, tell your friends, colleagues, CFUG cohorts, etc.You'll notice the book is not on Amazon.com.There's a reason for that: Amazon wanted %55 of the cover price as their commission!That means we would have had to jack up the cover price just to break even if we wanted to be on Amazon.But I wanted to keep the price as affordable as possible for you.Consequently, the book is only available through the Proton Arts website.I'm hoping for a balance between outstanding service and an affordable product, courtesy of Internet technology.Let me know if we've succeeded. Thanks, - Jeff Peters [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Execution time for cfapplication tag
Hello, My Application.cfm is taking 390ms to run, which is actually the cfapplication tag alone taking 350ms. Shouldn't it run faster than that? Is that because I'm using a database for clientstorage? (it's MS SQL 2k) Here's the tag: cfapplication name=myapp loginStorage=cookie clientmanagement=Yes clientstorage=myappClientStorage setdomaincookies=Yes setclientcookies=Yes TIA, Claudia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
bank of america processing
Does anyone have B of A cc processing enabled on CF 6.1?If so can you share your (sanitized) cfhttp call with me?Mine has been working since Q3 last year, but suddenly seems to have stopped.I had a January 9 transaction work great, and one yesterday blew up (nothing in between... Hi-dollar lo-volume on this site). I've spent quite a bit of time trying to debug it, and a bunch of time on the phone with the BofA folks.The problem seems to be cfhttp itself.Before I give up I was hoping someone had a working example I could use to compare mine against. Thx, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: bank of america processing
Does the interface involve sending a file to BofA?When using CFHTTP to interface with MediaLinq faxing service, it wouldn't accept the file uploads as valid.I ended up writing a function library that would build and send HTTP calls using HTTPClient (the same library that CFHTTP is built on), but using the right syntax for the uploaded files. No idea if that's relevant or not, but thought I'd throw it out there. Cheers, barneyb -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:33 AM To: CF-Talk Subject: bank of america processing Does anyone have B of A cc processing enabled on CF 6.1?If so can you share your (sanitized) cfhttp call with me?Mine has been working since Q3 last year, but suddenly seems to have stopped.I had a January 9 transaction work great, and one yesterday blew up (nothing in between... Hi-dollar lo-volume on this site). I've spent quite a bit of time trying to debug it, and a bunch of time on the phone with the BofA folks.The problem seems to be cfhttp itself.Before I give up I was hoping someone had a working example I could use to compare mine against. Thx, Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
vspider on CFMX J2EE Linux: Works or not?
Just wondering whether I wasted a couple of days of work developing an application to ease the creation of vspider searches. (ARGGH!) This link (Original MX release notes) indicates that vspider doesn't work at all on Linux: http://www.macromedia.com/support/coldfusion/releasenotes/mx/knownissues_mx_j2ee_p2.html#verity But newer release notes make no mention of a non-functional vspider: http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_known_problems.html#verity Which is it, does vspider work on CFMX/J2EE for Linux, or doesn't it? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Break the block, and SURVIVE, any way?
Yes, your follow-up makes a lot of sense to me except the GET method in the following block, is it a typo? meant to be POST? I thought cfhttpparam subtag is used with POST method only. Thanks. !--- Now send the cookies back to the server on our next request --- cfhttp url="" http:// http://www.whatever.com/index.html www.whatever.com/index.html useragent=Mozilla/4.0 method=get cfloop from=1 to=#arrayLen(cookies)# index=x cfhttpparam type=COOKIE name=#ListFirst(cookies[x],'=')# value=#ListRest(cookies[x],'=')# /cfloop /cfhttp When you do an cfhttp request, you may or may not receive cookies FROM the server.To determine if you have, simply look at the responseHeader.If you have, and you need to send those BACK to the server, that is when you want to use the cfhttpparam type=COOKIE code.The following code connects to a server, gets the cookies and then connects back using the cookies that were just sent. I have to do this quite frequently when I'm connecting to websites that use cookies to determine whether or not to display an advertisement before showing the page that you're really trying to access.I hope this helps. cfhttp url="" http:// http://www.whatever.com/index.html www.whatever.com/index.html useragent=Mozilla/4.0 /cfhttp !--- Take a look at the cookies that the server sent to ME --- cfdump var=#cfhttp.responseHeader# !--- Create an array to hold the cookies that the server sent --- cfset cookies = ArrayNew(1) cfset counter = 1 !--- Loop through the cookies from the response header --- cfloop item=currItem collection=#cfhttp.responseHeader[Set-Cookie]# cfset cookies[counter] = ListGetAt( cfhttp.responseHeader[Set-Cookie][currItem], 1, ; ) cfset counter = counter + 1 /cfloop !--- Now send the cookies back to the server on our next request --- cfhttp url="" http:// http://www.whatever.com/index.html www.whatever.com/index.html useragent=Mozilla/4.0 method=get cfloop from=1 to=#arrayLen(cookies)# index=x cfhttpparam type=COOKIE name=#ListFirst(cookies[x],'=')# value=#ListRest(cookies[x],'=')# /cfloop /cfhttp -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 9:53 AM To: CF-Talk Subject: Re: Break the block, and SURVIVE, any way? Now, I'm totally confused or have not waken up yet :) It seems either ua problem or cookie problem or both. But here's my take on this fiasco, this particular case, process flow-wise, normally a web client sends a request to a remote web server, the server checks ua and write some cookes to the requesters, if successful, send back requested info/web page, else, redirect to yahoo. Now, with my so-called spider, it sends a request to the same server telling the server I'm whom whom with the cfhttpparam type=Header value=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) subtag, meantime, it also tells the server, cookies, bla, bla with the cfhttpparam type=Cookie ... but here it bugs me, cookie ah, cookie, you're supposed to be crisp but ... :) Web server write cookie to requester/web client, aka ua, but cfhttpparam type=Cookie ... seems to say, hey, take this cookie from us (POST method) instead of accepting a cookie. Is my understanding if cfhttpparam type=Cookie incorrect? What's the deal here? Thanks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
Thomas Chiverton wrote: Solution: Use native CFMX drivers. Which is a shame :-( I dunno if it's worth putting in on the wish list... I figured out to return a ref cursor, and this appears to return a result set fine.However, now I'm getting an error reading, [Oracle JDBC Driver]Unsupported data conversion.The offending line that the CF processor shows has nothing to do with SP's, of course (in fact, it's a comment line).I'm using CFMX's native drivers to talk to Oracle -- or, at least, I believe I am. Oh, the humanity! -- Richard S. Crawford Programmer/Analyst III, UC Davis Extension Distance Learning Group (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REFind
if you're careful? What does that mean? I guess I was not careful then, as far as I could see I had to escape the period in one of my character classes.. Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, 25 February 2004 2:46 AM To: CF-Talk Subject: Re: REFind Not within a character class.If you're careful about how you construct it, you never have to escape anything in a class.Unless I forgot about something, or course.:-) --Ben Doom Taco Fleur wrote: Don't you have to escape the period? like so \. Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 February 2004 8:17 PM To: CF-Talk Subject: RE: REFind REFind([^0-9],form.PropertyDataPrice) If you want to allow other caracters like . and , add them in the class: REFind([^0-9.,],form.PropertyDataPrice) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 10:50 To: CF-Talk Subject: REFind Hi guys, I'm trying to make sure that my field has ONLY numeric characters otherwise show an error.I'm using the REFind but it doesn't pick up characters like $ £ etc. cfelseif REFind([[:num:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif Any ideas? Cheers, Stu _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Break the block, and SURVIVE, any way?
Yep, typo.Sorry about that. -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 1:51 PM To: CF-Talk Subject: Re: Break the block, and SURVIVE, any way? Yes, your follow-up makes a lot of sense to me except the GET method in the following block, is it a typo? meant to be POST? I thought cfhttpparam subtag is used with POST method only. Thanks. !--- Now send the cookies back to the server on our next request --- cfhttp url="" http:// http://www.whatever.com/index.html www.whatever.com/index.html useragent=Mozilla/4.0 method=get cfloop from=1 to=#arrayLen(cookies)# index=x cfhttpparam type=COOKIE name=#ListFirst(cookies[x],'=')# value=#ListRest(cookies[x],'=')# /cfloop /cfhttp When you do an cfhttp request, you may or may not receive cookies FROM the server.To determine if you have, simply look at the responseHeader.If you have, and you need to send those BACK to the server, that is when you want to use the cfhttpparam type=COOKIE code.The following code connects to a server, gets the cookies and then connects back using the cookies that were just sent. I have to do this quite frequently when I'm connecting to websites that use cookies to determine whether or not to display an advertisement before showing the page that you're really trying to access.I hope this helps. cfhttp url="" http:// http://www.whatever.com/index.html www.whatever.com/index.html useragent=Mozilla/4.0 /cfhttp !--- Take a look at the cookies that the server sent to ME --- cfdump var=#cfhttp.responseHeader# !--- Create an array to hold the cookies that the server sent --- cfset cookies = ArrayNew(1) cfset counter = 1 !--- Loop through the cookies from the response header --- cfloop item=currItem collection=#cfhttp.responseHeader[Set-Cookie]# cfset cookies[counter] = ListGetAt( cfhttp.responseHeader[Set-Cookie][currItem], 1, ; ) cfset counter = counter + 1 /cfloop !--- Now send the cookies back to the server on our next request --- cfhttp url="" http:// http://www.whatever.com/index.html www.whatever.com/index.html useragent=Mozilla/4.0 method=get cfloop from=1 to=#arrayLen(cookies)# index=x cfhttpparam type=COOKIE name=#ListFirst(cookies[x],'=')# value=#ListRest(cookies[x],'=')# /cfloop /cfhttp -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 9:53 AM To: CF-Talk Subject: Re: Break the block, and SURVIVE, any way? Now, I'm totally confused or have not waken up yet :) It seems either ua problem or cookie problem or both. But here's my take on this fiasco, this particular case, process flow-wise, normally a web client sends a request to a remote web server, the server checks ua and write some cookes to the requesters, if successful, send back requested info/web page, else, redirect to yahoo. Now, with my so-called spider, it sends a request to the same server telling the server I'm whom whom with the cfhttpparam type=Header value=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) subtag, meantime, it also tells the server, cookies, bla, bla with the cfhttpparam type=Cookie ... but here it bugs me, cookie ah, cookie, you're supposed to be crisp but ... :) Web server write cookie to requester/web client, aka ua, but cfhttpparam type=Cookie ... seems to say, hey, take this cookie from us (POST method) instead of accepting a cookie. Is my understanding if cfhttpparam type=Cookie incorrect? What's the deal here? Thanks. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Execution time for cfapplication tag
There's a good chance that your client variable storage is the problem. How large is the database? Is there any way you can do without it? I personally have some reservations about using client database storage. The idea is great, but the implementation is poor. On my SQL 2k server, we can watch as client variables prepare and unprepare stored procs to set and update variables. This is a mean thing to do to a database. If at all possible, change your client storage to cookies, or do a roll-your-own client storage mechanism. I've been thinking about this for a while and have come up with a number of ideas. Let me know if you want any of them. -nathan strutz -Original Message- From: Claudia Hoag [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:34 AM To: CF-Talk Subject: Execution time for cfapplication tag Hello, My Application.cfm is taking 390ms to run, which is actually the cfapplication tag alone taking 350ms. Shouldn't it run faster than that? Is that because I'm using a database for clientstorage? (it's MS SQL 2k) Here's the tag: cfapplication name=myapp loginStorage=cookie clientmanagement=Yes clientstorage=myappClientStorage setdomaincookies=Yes setclientcookies=Yes TIA, Claudia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: REFind
What I meant by being careful has to do with the placement of -, ], and [ in the class.- is easy:make it the first or last char, and it's literal.[] I can never remember, so I escape. I just checked, and in 6.1 you don't have to escape a period in a character class.I remember not having to in 5, but I could be wrong. Unlikely as that seems.:-) --Ben Doom Taco Fleur wrote: if you're careful? What does that mean? I guess I was not careful then, as far as I could see I had to escape the period in one of my character classes.. Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, 25 February 2004 2:46 AM To: CF-Talk Subject: Re: REFind Not within a character class.If you're careful about how you construct it, you never have to escape anything in a class.Unless I forgot about something, or course.:-) --Ben Doom Taco Fleur wrote: Don't you have to escape the period? like so \. Taco Fleur Bloghttp://www.tacofleur.com/index/blog/ http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 February 2004 8:17 PM To: CF-Talk Subject: RE: REFind REFind([^0-9],form.PropertyDataPrice) If you want to allow other caracters like . and , add them in the class: REFind([^0-9.,],form.PropertyDataPrice) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: dinsdag 24 februari 2004 10:50 To: CF-Talk Subject: REFind Hi guys, I'm trying to make sure that my field has ONLY numeric characters otherwise show an error.I'm using the REFind but it doesn't pick up characters like $ £ etc. cfelseif REFind([[:num:]],form.PropertyDataPrice)cfset MessageAlert = MessageAlert font color='red'Price/font must only be numbers baby.br/cfif Any ideas? Cheers, Stu _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cold Fusion and Oracle Stored Procedures
On Tue, 2004-02-24 at 11:50, Richard Crawford wrote: Thomas Chiverton wrote: Solution: Use native CFMX drivers. Which is a shame :-( I dunno if it's worth putting in on the wish list... I figured out to return a ref cursor, and this appears to return a result set fine.However, now I'm getting an error reading, [Oracle JDBC Driver]Unsupported data conversion. That just passes along the problem from the driver/database it cant tell you the line number of the stored proc if it was not given The offending line that the CF processor shows has nothing to do with SP's, of course (in fact, it's a comment line). its talking about the cfproc call, probably near the comment. Sometimes it points before sometimes after, but generally near the query/proc call. In other words, its telling you were cf made the proc call not where the proc errored. -- Vale, Rob Luxuria immodica insaniam creat. Sanam formam viatae conservate! http://www.rohanclan.com http://treebeard.sourceforge.net http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Execution time for cfapplication tag
Or use SESSION variables, which can be shared quite easily and effectively when CF is deployed on top of a J2EE server. And SESSION supports far more data types than does CLIENT too. --- Ben _ From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 2:57 PM To: CF-Talk Subject: RE: Execution time for cfapplication tag There's a good chance that your client variable storage is the problem. How large is the database? Is there any way you can do without it? I personally have some reservations about using client database storage. The idea is great, but the implementation is poor. On my SQL 2k server, we can watch as client variables prepare and unprepare stored procs to set and update variables. This is a mean thing to do to a database. If at all possible, change your client storage to cookies, or do a roll-your-own client storage mechanism. I've been thinking about this for a while and have come up with a number of ideas. Let me know if you want any of them. -nathan strutz -Original Message- From: Claudia Hoag [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 11:34 AM To: CF-Talk Subject: Execution time for cfapplication tag Hello, My Application.cfm is taking 390ms to run, which is actually the cfapplication tag alone taking 350ms. Shouldn't it run faster than that? Is that because I'm using a database for clientstorage? (it's MS SQL 2k) Here's the tag: cfapplication name=myapp loginStorage=cookie clientmanagement=Yes clientstorage=myappClientStorage setdomaincookies=Yes setclientcookies=Yes TIA, Claudia _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Help: UTF-16 in ColdFusion 5???
Dave I have no idea which are the invalid characters and thats what is driving me crazy. I was hoping someone may have had a need to do this in the past and created some UDF or CFX that would do what I'm looking for... any ideas? Jon -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 2:12 PM To: CF-Talk Subject: RE: Help: UTF-16 in ColdFusion 5??? I'm using the Microsoft XML Services (v4) parser with CF5 on Windows. I'm getting an error and this page http://support.microsoft.com/default.aspx?scid=kb;EN-US;q247708 explains that the reason is because I have to convert my ColdFusion 5 string to UTF-16 before I can pass the string to the Microsoft XML parser. How the heck can I convert my string to UTF-16 in ColdFusion 5??? Is there an alternative way to do this? I'm one line of code away from being done with this hassle... According to the URL you posted: Scripting developers have two options available: 1. Convert your XML documents to UTF-16-formatted Unicode, either automatically or by hand.Escape all non-Unicode character encodings inside the XML document using XML Unicode entity references. Any XML character can be encoded in plain ASCII using the form #, where is its index into the Unicode character set. 2. Escape all non-Unicode character encodings inside the XML document using XML Unicode entity references. Any XML character can be encoded in plain ASCII using the form #, where is its index into the Unicode character set. Out of curiosity, have you identified the invalid characters? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Break the block, and SURVIVE, any way?
Exercise in vain?It still redirect to yahoo. First try your whole block of code. Second try just the following block of code for debugging. cftry cfhttp url="" ThrowOnError=yes redirect=No useragent=#cgi.http_user_agent# method=get /cfhttp cfcatch type=any/cfcatch /cftry !--- Take a look at the cookies that the server sent to ME --- cfdump var=#cfhttp.responseHeader# cfabort Yep, typo.Sorry about that. -Original Message- From: Chunshen Li [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 1:51 PM To: CF-Talk Subject: Re: Break the block, and SURVIVE, any way? Yes, your follow-up makes a lot of sense to me except the GET method in the following block, is it a typo? meant to be POST? I thought cfhttpparam subtag is used with POST method only. Thanks. !--- Now send the cookies back to the server on our next request --- cfhttp url="" http:// http://www.whatever.com/index.html www.whatever.com/index.html useragent=Mozilla/4.0 method=get cfloop from=1 to=#arrayLen(cookies)# index=x cfhttpparam type=COOKIE name=#ListFirst(cookies[x],'=')# value=#ListRest(cookies[x],'=')# /cfloop /cfhttp When you do an cfhttp request, you may or may not receive cookies FROM the successful, _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
