RE: Musings CFAnywhere, Bandwidth, RIAs Part 1
Also how portable is it? Its always annoyed me that it doesnt have the print capabilites that powerpoint has and that you can't simply download a presenatation Kola -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 20:47 To: CF-Talk Subject: RE: Musings CFAnywhere, Bandwidth, RIAs Part 1 Why can't Hal's site have a richer UI -- think of it -- Hal's voice, explaining the animated preso? There's already a great answer for this, though - Macromedia Breeze. It's a really good product for this sort of thing, and it makes building presentations very easy. Isn't it a little pricey for most users? It's well worth the price, if you want to publish training materials online. Yes, it's pricey, but I suspect it's cheaper than building your own infrastructure to do the same thing. 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] [Donations and Support]
Re: Oracle - Incorrect Number of Arguments or Type
On Thursday 17 Jun 2004 21:21 pm, Adrocknaphobia wrote: After performing a security lockdown on the Oracle server, namely removing DBA from the role which access the package, CF cannot call store procedures which return a result set. What roles/permissions does that leave the CF user with ? -- 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] [Donations and Support]
Re: Timed links
On Thursday 17 Jun 2004 20:34 pm, Cutter (CF-Talk) wrote: I have several links that come from a db. How can I only have these Check the value of hour(now()) against 16 and 0, and 2 and 0. -- 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] [Donations and Support]
Those mysterious RE
Hi, I have been struggling all the morning with these RE. I am trying to replace a bunch of HTML by some empty space. It is for a select tag. I know the opening tag and close tag. Some thing like select name=language option value=1 selectedEn/option option value=2Fr/option option value=3Sp/option option value=4Gr/option /select In cf I do: cfset rex = ReReplace(myhtlmcode,select name=select_1.*/select, ,All) I use the .* because the option tag can change and pull 5 or 10 languages options. Any idea how to replace anything by any empty sapce? Thank you, Jean-Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Those mysterious RE
What version of CF? I don't understand what you mean by empty space? A single space, blank lines in your display, ...? The code you provided will replace a select by a single space. It will break down if you have another select following the first one you match. Pascal -Original Message- From: jean-marc bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:11 To: CF-Talk Subject: Those mysterious RE Hi, I have been struggling all the morning with these RE. I am trying to replace a bunch of HTML by some empty space. It is for a select tag. I know the opening tag and close tag. Some thing like select name=language option value=1 selectedEn/option option value=2Fr/option option value=3Sp/option option value=4Gr/option /select In cf I do: cfset rex = ReReplace(myhtlmcode,select name=select_1.*/select, ,All) I use the .* because the option tag can change and pull 5 or 10 languages options. Any idea how to replace anything by any empty sapce? Thank you, Jean-Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Those mysterious RE
By empty sapce I mean a single space. I would like to replace the entire HTML code by a single space. -Message d'origine- De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi 18 juin 2004 12:16 : CF-Talk Objet : RE: Those mysterious RE What version of CF? I don't understand what you mean by empty space? A single space, blank lines in your display, ...? The code you provided will replace a select by a single space. It will break down if you have another select following the first one you match. Pascal -Original Message- From: jean-marc bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:11 To: CF-Talk Subject: Those mysterious RE Hi, I have been struggling all the morning with these RE. I am trying to replace a bunch of HTML by some empty space. It is for a select tag. I know the opening tag and close tag. Some thing like select name=language option value=1 selectedEn/option option value=2Fr/option option value=3Sp/option option value=4Gr/option /select In cf I do: cfset rex = ReReplace(myhtlmcode,select name=select_1.*/select, ,All) I use the .* because the option tag can change and pull 5 or 10 languages options. Any idea how to replace anything by any empty sapce? Thank you, Jean-Marc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFC Response Delay Bug in ColdFusion 6.1???
On Thursday 17 Jun 2004 17:06 pm, Carlo Gabriel Evidente wrote: locally and tested my programs. Anyone of you who has also encountered this same problem after upgrading to ColdFusion 6.1??? Did you keep all your CF admin settings ? Such as caching class files, database links etc ? -- 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] [Donations and Support]
Re: Upload a file using Java in CF
On Thursday 17 Jun 2004 16:34 pm, Andrew Spear wrote: InputStreamReader/InputStreamWriter classes, but I'm pretty clueless as to where to start. http://java.sun.com/j2se/1.4.2/docs/api/ ? -- 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] [Donations and Support]
RE: Those mysterious RE
Only on cfmx: cfset myhtlmcode = ReReplace(myhtlmcode, select name=select_1.*?/select, , All) -Original Message- From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:25 To: CF-Talk Subject: RE: Those mysterious RE By empty sapce I mean a single space. I would like to replace the entire HTML code by a single space. -Message d'origine- De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi 18 juin 2004 12:16 : CF-Talk Objet : RE: Those mysterious RE What version of CF? I don't understand what you mean by empty space? A single space, blank lines in your display, ...? The code you provided will replace a select by a single space. It will break down if you have another select following the first one you match. Pascal -Original Message- From: jean-marc bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:11 To: CF-Talk Subject: Those mysterious RE Hi, I have been struggling all the morning with these RE. I am trying to replace a bunch of HTML by some empty space. It is for a select tag. I know the opening tag and close tag. Some thing like select name=language option value=1 selectedEn/option option value=2Fr/option option value=3Sp/option option value=4Gr/option /select In cf I do: cfset rex = ReReplace(myhtlmcode,select name=select_1.*/select, ,All) I use the .* because the option tag can change and pull 5 or 10 languages options. Any idea how to replace anything by any empty sapce? Thank you, Jean-Marc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFC Response Delay Bug in ColdFusion 6.1???
On Thursday 17 Jun 2004 17:24 pm, Carlo Evidente wrote: I'm currently developing a Flashcom application that interacts with the Do you think posting twice with slightly different address will help ? :-) -- 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] [Donations and Support]
Re: Upload a file using Java in CF
Andrew Spear [EMAIL PROTECTED] wrote: Sorry if this is a bit OT.I have a file upload form that posts to the code below. The code takes the uploaded file and writes it to the server. snip umm.. sorry, could I just ask, what's the advantage of doing this over using CFFILE? Or is it for servers with CFFILE disabled? -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Those mysterious RE
I have tried under CFMX 6.1 the following _expression_: cfset regex = SELECT size=2 name=X2CC229C91022073EF855A729E25A9E07.*?/select cfset myhtlmcode= ReReplace(myhtlmcode,#regex#, ,All) Unfortunately without success. Did I miss something? -Message d'origine- De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi 18 juin 2004 12:27 : CF-Talk Objet : RE: Those mysterious RE Only on cfmx: cfset myhtlmcode = ReReplace(myhtlmcode, select name=select_1.*?/select, , All) -Original Message- From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:25 To: CF-Talk Subject: RE: Those mysterious RE By empty sapce I mean a single space. I would like to replace the entire HTML code by a single space. -Message d'origine- De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi 18 juin 2004 12:16 : CF-Talk Objet : RE: Those mysterious RE What version of CF? I don't understand what you mean by empty space? A single space, blank lines in your display, ...? The code you provided will replace a select by a single space. It will break down if you have another select following the first one you match. Pascal -Original Message- From: jean-marc bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:11 To: CF-Talk Subject: Those mysterious RE Hi, I have been struggling all the morning with these RE. I am trying to replace a bunch of HTML by some empty space. It is for a select tag. I know the opening tag and close tag. Some thing like select name=language option value=1 selectedEn/option option value=2Fr/option option value=3Sp/option option value=4Gr/option /select In cf I do: cfset rex = ReReplace(myhtlmcode,select name=select_1.*/select, ,All) I use the .* because the option tag can change and pull 5 or 10 languages options. Any idea how to replace anything by any empty sapce? Thank you, Jean-Marc _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Musings CFAnywhere, Bandwidth, RIAs Part 2
On Thursday 17 Jun 2004 17:05 pm, Dick Applebaum wrote: Thoughts? You should get a blog :-) -- 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] [Donations and Support]
RE: Those mysterious RE
Pascal, Sorry my mistake, the closing was in uppercase and in the RE I put it in lowercase. Thank you very much for your help and your time. J-M -Message d'origine- De : Jean-Marc Bottin Envoy : vendredi 18 juin 2004 12:40 : CF-Talk Objet : RE: Those mysterious RE I have tried under CFMX 6.1 the following _expression_: cfset regex = SELECT size=2 name=X2CC229C91022073EF855A729E25A9E07.*?/select cfset myhtlmcode= ReReplace(myhtlmcode,#regex#, ,All) Unfortunately without success. Did I miss something? -Message d'origine- De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi 18 juin 2004 12:27 : CF-Talk Objet : RE: Those mysterious RE Only on cfmx: cfset myhtlmcode = ReReplace(myhtlmcode, select name=select_1.*?/select, , All) -Original Message- From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:25 To: CF-Talk Subject: RE: Those mysterious RE By empty sapce I mean a single space. I would like to replace the entire HTML code by a single space. -Message d'origine- De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi 18 juin 2004 12:16 : CF-Talk Objet : RE: Those mysterious RE What version of CF? I don't understand what you mean by empty space? A single space, blank lines in your display, ...? The code you provided will replace a select by a single space. It will break down if you have another select following the first one you match. Pascal -Original Message- From: jean-marc bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:11 To: CF-Talk Subject: Those mysterious RE Hi, I have been struggling all the morning with these RE. I am trying to replace a bunch of HTML by some empty space. It is for a select tag. I know the opening tag and close tag. Some thing like select name=language option value=1 selectedEn/option option value=2Fr/option option value=3Sp/option option value=4Gr/option /select In cf I do: cfset rex = ReReplace(myhtlmcode,select name=select_1.*/select, ,All) I use the .* because the option tag can change and pull 5 or 10 languages options. Any idea how to replace anything by any empty sapce? Thank you, Jean-Marc _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Those mysterious RE
Try cfset myhtlmcode= REReplaceNoCase(myhtlmcode, regex, , All) Pascal -Original Message- From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:40 To: CF-Talk Subject: RE: Those mysterious RE I have tried under CFMX 6.1 the following _expression_: cfset regex = SELECT size=2 name=X2CC229C91022073EF855A729E25A9E07.*?/select cfset myhtlmcode= ReReplace(myhtlmcode,#regex#, ,All) Unfortunately without success. Did I miss something? -Message d'origine- De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi 18 juin 2004 12:27 : CF-Talk Objet : RE: Those mysterious RE Only on cfmx: cfset myhtlmcode = ReReplace(myhtlmcode, select name=select_1.*?/select, , All) -Original Message- From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:25 To: CF-Talk Subject: RE: Those mysterious RE By empty sapce I mean a single space. I would like to replace the entire HTML code by a single space. -Message d'origine- De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi 18 juin 2004 12:16 : CF-Talk Objet : RE: Those mysterious RE What version of CF? I don't understand what you mean by empty space? A single space, blank lines in your display, ...? The code you provided will replace a select by a single space. It will break down if you have another select following the first one you match. Pascal -Original Message- From: jean-marc bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:11 To: CF-Talk Subject: Those mysterious RE Hi, I have been struggling all the morning with these RE. I am trying to replace a bunch of HTML by some empty space. It is for a select tag. I know the opening tag and close tag. Some thing like select name=language option value=1 selectedEn/option option value=2Fr/option option value=3Sp/option option value=4Gr/option /select In cf I do: cfset rex = ReReplace(myhtlmcode,select name=select_1.*/select, ,All) I use the .* because the option tag can change and pull 5 or 10 languages options. Any idea how to replace anything by any empty sapce? Thank you, Jean-Marc _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Those mysterious RE
C'est avec plaisir. Pascal -Original Message- From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juni 2004 12:44 To: CF-Talk Subject: RE: Those mysterious RE Pascal, Sorry my mistake, the closing was in uppercase and in the RE I put it in lowercase. Thank you very much for your help and your time. J-M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Upload a file using Java in CF
Kay Smoljak wrote: Andrew Spear [EMAIL PROTECTED] wrote: Sorry if this is a bit OT.I have a file upload form that posts to the code below. The code takes the uploaded file and writes it to the server. snip umm.. sorry, could I just ask, what's the advantage of doing this over using CFFILE? Or is it for servers with CFFILE disabled? ummm yeah... and if cffile is disabled I would definately expect cfobject to be disabled too. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFC Response Delay Bug in ColdFusion 6.1???
He did the same thing on the mm forums too! Except there were 5 duplicate posts!!! -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 11:37 To: CF-Talk Subject: Re: CFC Response Delay Bug in ColdFusion 6.1??? On Thursday 17 Jun 2004 17:24 pm, Carlo Evidente wrote: I'm currently developing a Flashcom application that interacts with the Do you think posting twice with slightly different address will help ? :-) -- 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] [Donations and Support]
Re: Musings CFAnywhere, Bandwidth, RIAs Part 1
I am late in returning to this thread -- My (apple's ,mac) mail server was down for several hours. Dave is probably right in that if you want to do online training, that Breeze is a good way to go. But as you point out, there are limitations. With the CFAnywhere concept, you could expand your training offerings (delivery methods) to include downloadable courses and/or CD/DVD resident courses. The delivery of CFAnywhere-based courses is not limited by the bandwidth of your internet connection, Breeze's internet connection, or network traffic/congestion.Because of this, your materials could have higher-quality A/V images than is practical on line And, the users could take the courses if the site was down or the internet was not accessible (11-hour flight to Japan). If the courses run on the desktop, they can have access to the printer (as you mention) plus be expanded to include things like interactive testing, drill and practice, student progress monitoring, etc. that may not be practical online. The course delivered on the desktop would be a different animal that the course delivered online. AFAIKT, the biggest limitation to the CFAnywhere approach is that (currently) there is a high cost and redistribution limitation for the CFML component. NewAtlanta has publicly expressed a willingness to work with anybody who wants to find creative ways of packaging/redistributing BlueDragon -- I suspect that Macromedia would do the same for ColdFusion MX if the demand warrants. NA or MM could sell you a single redistro license that would fanout to thousands (or more) CFML engines delivered this way -- thousands of installs, but only 1 customer (you) to support. The training app is only one (but a big one) class of applications that could benefit from a high-volume, low-cost, redistributable CFML engine. NA or MM would need to do nothing to change their CFML engine -- the limited-IP trial version works fine. It boils down to a pricing/licensing/redistro issue. It may sound trite, but everybody wins -- the CFML Engine maker, the app maker, the user. Dick On Jun 18, 2004, at 2:25 AM, Kola Oyedeji wrote: Also how portable is it? Its always annoyed me that it doesnt have the print capabilites that powerpoint has and that you can't simply download a presenatation Kola -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 20:47 To: CF-Talk Subject: RE: Musings CFAnywhere, Bandwidth, RIAs Part 1 Why can't Hal's site have a richer UI -- think of it -- Hal's voice, explaining the animated preso? There's already a great answer for this, though - Macromedia Breeze. It's a really good product for this sort of thing, and it makes building presentations very easy. Isn't it a little pricey for most users? It's well worth the price, if you want to publish training materials online. Yes, it's pricey, but I suspect it's cheaper than building your own infrastructure to do the same thing. 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] [Donations and Support]
Re: SOT: Musings CFAnywhere, Bandwidth, RIAs Part 2
On Jun 18, 2004, at 3:40 AM, Thomas Chiverton wrote: On Thursday 17 Jun 2004 17:05 pm, Dick Applebaum wrote: Thoughts? You should get a blog :-) Yeah, but I hope that developers on the list will see the potential of desktop CFML apps will generate interest. Macromedia and NewAtlanta techies marketing people monitor this list -- if there is enough demand, who knows... Don't think Id get that from a blog. And, if there is no interest, the thread dies a natural death -- and I thank you for the use of your time! Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (Admin) Support drive
I and many others recently made small donations to support Michael and Judith's excellent efforts with the HOF lists -- today that investment paid dividends. I was having problems creating a structure of structures of arrays -- specifically an itunes structure of songs and play lists: Playlists --PlaylistID --PlaylistName --PlaylistTracks TrackID TrackID * * * --PlaylistID --PlaylistName --PlaylistTracks TrackID TrackID I'd never created an array as a structure element try as I would, I couldn't get the syntax right. I googled, but could find no docs/tutorials/examples of what I was trying to do -- arrays of structures, sure -- but structures of arrays, nada! After several hours of frustration, I decided to swallow my pride ask for help from CF-Talk, But my mail server was down all day -- no relief there! One of the googles described a problem that really didn't seem to apply, but it was from CF-Talk -- so I clicked the link to: http://www.houseoffusion.com/cf_lists/index.cfm? method=messagesthreadid=18417forumid=4 Bingo! Problem solved! Why didn't I look there first?Dah! The point is that HOF lists have saved me much effort and many $ over the years! Michael Judith do afantastic Job -- and we need to say it out loud, every so often. My minimal contribution cannot match the dedication, effort results they provide... but, I am glad to support them however I can. Sincere thanks Dick If you haven't found something strange during the day, it hasn't been much of a day. - John A. Wheeler - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 PowerPoint
I sent this yesterday, but didn't see it appear on the list (I was having mail probs). Apologies if this is a duplicate post. You might be able to do it by CFExecuting an OSA script: Here's some info on the Mac using AppleScript (Apple's OSA scripting language). http://www.apple.com/applescript/powerpoint/ It says you can create and edit slides! Since MS put the hooks into PowerPoint, I assume they have an OSA scripting facility that can exploit them. HTH Dick On Jun 17, 2004, at 8:22 AM, George Abraham wrote: Welcome to my world, Mike! I am saddled with somewhat the same problem. I managed to do some stunts with CF5 and make it work. Right now CFMX just plain doesn't like the same code. I do have some time before I have to change the code for CFMX. Anyway, have you seen anything with the Jintegra Java-COM bridge supplied with CFMX? That's one way of manipulating PowerPoint on the server. Also, Sam Neff had a Breeze presentation about MS Office and CFMX on his website. Just search the list archive for it. George At 11:17 AM 6/17/2004, Tangorre, Michael wrote: Has anyone looked into, or successfully integrated CF with PowerPoint. A requirement came in today whereby some upper management people want a PowerPoint presentation dynamically populated from data within the application. If the application were written in ASP.NET or something MS, I'm sure it would be much easier, but it is written in CFMX 6.1 and I am not even sure if it is possible. Anyone have any insight? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx and CAPTCHA
Session variables are useless on clustered servers (no lectures on sticky sessions please they are a waste of time) I won't lecture you, but I would like to point out that you can share Session variables across cluster members using CFMX on Jrun, although you can't use CFC instances within the Session scope that way. Also, I would disagree that sticky sessions are a waste of time. If your primary goal for clustering is simply to add throughput, there's nothing wrong with using sticky sessions. 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] [Donations and Support]
cgi environment
hi, We have a cold fusion web application. Which is under the security of another applicaiton. Security application passes the user id to our application in form of something like below. cgi.http_scempnum We access this variable value in applicaiton.cfm file and query the user table for this user id every time when any cold fusion page is accessed. SO for every coldfusion request send query is fired against the database. We have 1000 users and out of them only 5 are losing that cgi user id variable passed on to us from security applicaiton. In the first attempt some users get thru it and we are able to access above mentioned value. But in is subsequent requests send after successfully login in to our site ,we are losing that value. For some users in the very first attempt we are losing the value of cgi variable. It comes as blank string. One work around we have though is to store in cookie for very first time and then in subsequent requests we can use cookie value. But what if we dont get the cgi variable valiue in first attempt itself and so cookie will also contain blank string. Users are using IE 6.0 all 1000 users. Its happening in production only and not devleopment . Can any help me on this issue.Is it related to some server settings? thanks hemant [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: FB4 catching fusebox exceptions
Thanks Barney, makes sense. However wrapping the contents of index.cfm in a cftry essentially wraps the entire request in a cftry does it not?... Potentially hindering performance? In general, using CFTRY/CFCATCH doesn't add any significant overhead unless an exception is thrown, in which case you generally don't mind the overhead. The problem with wrapping an entire page with CFTRY is that it doesn't allow you to deal with specific problems very well. Ideally, you want to wrap each problematic section of code with its own CFTRY, so that you can capture the specific exceptions that are likely to occur with that piece of code only. If you find yourself using CFTRY around very large blocks of code, you might be better off just using CFERROR. I would also like to voice agreement with Barney's disapproval of premature optimization concerns. 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] [Donations and Support]
RE: cfmx and CAPTCHA
Hey Dave, feel free to lecture, I've learned from you before:why don't CFC instances go across cluster members?I imagine it'd probably be self-evident if I knew anything about the mechanics of session sharing across JRun, but I don't. Thanks, Joe -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Fri 6/18/2004 8:34 AM To: CF-Talk Cc: Subject: RE: cfmx and CAPTCHA Session variables are useless on clustered servers (no lectures on sticky sessions please they are a waste of time) I won't lecture you, but I would like to point out that you can share Session variables across cluster members using CFMX on Jrun, although you can't use CFC instances within the Session scope that way. Also, I would disagree that sticky sessions are a waste of time. If your primary goal for clustering is simply to add throughput, there's nothing wrong with using sticky sessions. 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] [Donations and Support]
RE: cfmx and CAPTCHA
why don't CFC instances go across cluster members? I don't really know why they don't, just that they don't. I suspect that JRun has some sort of serializer to write its own session variables to strings, and that this serializer doesn't know what to do with CFC instances, but I really don't know for certain. 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] [Donations and Support]
CF and Eclipse
Sorry for asking a question that I am sure has already been asked but I cannot seem to be able to get to the House of Fusion to look it up. I am interested in using Eclipse to do some of my CF development in and I would like to know what I need to do to get it to work. Do I just download eclipse for sourceforge and that is it.I do remember reading a post about something called CFEclipse. Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Musings CFAnywhere, Bandwidth, RIAs Part 1
Dave is probably right in that if you want to do online training, that Breeze is a good way to go. But as you point out, there are limitations. Well, of course there are. There will be limitations no matter how you choose to deliver an application. Network delivery of applications addresses many limitations of locally run applications, after all. With the CFAnywhere concept, you could expand your training offerings (delivery methods) to include downloadable courses and/or CD/DVD resident courses. It strikes me that using CF to write desktop applications is like training an elephant for the ballet. Perhaps it can be done, but there are lots of other, more suitable ways to develop desktop applications. If the courses run on the desktop, they can have access to the printer (as you mention) plus be expanded to include things like interactive testing, drill and practice, student progress monitoring, etc. that may not be practical online. All of the things you mentioned can be done online as well with Breeze as well as other online solutions. AFAIKT, the biggest limitation to the CFAnywhere approach is that (currently) there is a high cost and redistribution limitation for the CFML component. I would respectfully disagree. I think the biggest limitation to this approach is that it doesn't deliver nearly the same functionality as someone can quickly whip up in, say, Visual Studio.NET. Admittedly, .NET desktop applications aren't cross-platform, but there are ways to build cross-platform desktop applications that will provide more functionality than web applications that happen to be running on your desktop. 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] [Donations and Support]
RE: CF and Eclipse
You'll find it here http://cfeclipse.tigris.org/ Matt Liotta is also working on something called He3 for Eclipse (which I'm itching to try!!) which will be available after CFFUN - someone will correct me if I'm wrong. -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 13:39 To: CF-Talk Subject: CF and Eclipse Sorry for asking a question that I am sure has already been asked but I cannot seem to be able to get to the House of Fusion to look it up. I am interested in using Eclipse to do some of my CF development in and I would like to know what I need to do to get it to work. Do I just download eclipse for sourceforge and that is it.I do remember reading a post about something called CFEclipse. Thanks Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF and Eclipse
I recently installed it and I must say version 3.0 is cracking...looks good, performs well.the little insight and CFC explorer inline are great as well. _ From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 13:39 To: CF-Talk Subject: CF and Eclipse Sorry for asking a question that I am sure has already been asked but I cannot seem to be able to get to the House of Fusion to look it up. I am interested in using Eclipse to do some of my CF development in and I would like to know what I need to do to get it to work. Do I just download eclipse for sourceforge and that is it.I do remember reading a post about something called CFEclipse. Thanks Mario _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF and Eclipse
On Friday 18 Jun 2004 13:39 pm, John Beynon wrote: Matt Liotta is also working on something called He3 for Eclipse (which I'm itching to try!!) which will be available after CFFUN - someone will correct me if I'm wrong. A beta yes. The final version will be pay-for-comercial-use, iirc, unlike CFEclipse which is free - but may end up having less features. Tis an exciting time :-) -- 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] [Donations and Support]
Re: CHARTFX ColdFusion MX
no one??? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ColdFusion on Mac OS X
Jeff You can get some more info here: http://www.macromedia.com/support/coldfusion/j2ee/cfmx-mac-onjrunandtomc at.html I followed the above instructions and hada painless install on OS X. Note that I opted to remain using the built in server as opposed to Apache so I don't know if there are any issues with it but from what I've heard, I don't think so. KOla -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 June 2004 19:16 To: CF-Talk Subject: Re: ColdFusion on Mac OS X Hi all, I just got an Apple laptop, and I'm running 10.3 on it. I've got StudioMX for it, and I really want to learn how to use Dreamweaver on OS X. If I understand everything correctly, I can run Apache on my Mac by just using Web Sharing just like I can run IIS on my PC at work. If I want to run ColdFusion, I'm going to first need to install and configure JRun, then get the single user version of CF running on top of JRun. At that point, I'll be basically all set up just like I am at work...now if I've messed any of that up, correct me now. But, as you can tell, I'm a real newbie at digging into the Unix and Apache stuff, and definitely a newbie at setting up and configuring JRun...but I'm up to the task. So what I'm wondering is, where would one go to get information specific to learning about setting up and running that stuff under OS X? More specific, the whole Apache with JRun and CF solution running on OS X...are there any good websites dealing with just this kind of thing? Another alternative I'd like to mention is using BlueDragon as opposed to JRun/CFMX.I've run both on Macs and BlueDragon is far easier to install and deal with in general.You would need to check to make sure the very few incompatibilities between BlueDragon and CFMX wouldn't cause you any problems, but I've been using BlueDragon for development on my PowerBook for quite a while and haven't had any trouble. http://www.newatlanta.com/products/bluedragon/index.cfm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Musings CFAnywhere, Bandwidth, RIAs Part 1
On Friday 18 Jun 2004 13:49 pm, Dave Watts wrote: Admittedly, .NET desktop applications aren't cross-platform, but there are ways to build fx:cough Mono -- 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] [Donations and Support]
RE: CHARTFX ColdFusion MX
Someone would have responded :-) no one??? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
I havent come across any build issues using the apache connector for JRUN, it works quite well. (to me it seems faster on my iBook but I might be wrong!) Mark Drew On I followed the above instructions and hada painless install on OS X. Note that I opted to remain using the built in server as opposed to Apache so I don't know if there are any issues with it but from what I've heard, I don't think so. KOla -- Mark Drew mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Upload a file using Java in CF
Well, here's my situation.We have a sandbox for some developers who need cffile, but we (the admins) have a requirement to log all file activity.The solution is to create a custom tag that contains the cffile functionality plus contains a logging facility so we can track what they are doing.Now, it would be perfect if I could just wrap up cffile in my own custom tag, but the sandbox security still recognizes that cffile is be run and shuts us down.So I figured I would need to use Java.If anyone has any ideas on how to get cffile to run in a custom tag within a sandbox that has cffile disabled, I would appreciate them.CF 5 used to have an unrestricted tag folder, but it doesn't look like MX does.Oh well. Thanks- Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHARTFX ColdFusion MX
:-( Someone would have responded :-) no one??? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
I havent come across any build issues using the apache connector for JRUN, it works quite well. (to me it seems faster on my iBook but I might be wrong!) Mark Drew On I followed the above instructions and hada painless install on OS X. Note that I opted to remain using the built in server as opposed to Apache so I don't know if there are any issues with it but from what I've heard, I don't think so. KOla What databases are you guys using? I'm setting up Web Sharing this weekend, after reading a bit more to make sure I understand everything, and I'm installing Jrun and CF this weekend as well...I've got Studio up and running, and was wondering now, where to turn for databases? I'm going to work with my IT guy to get the SQL server set up so I can get to that for some of our larger clients, but for myself, and the learning thing, what databases solutions are you guys using locally? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
On Friday 18 Jun 2004 15:27 pm, Jeff Small wrote: databases solutions are you guys using locally? On MacOS, I'm fairly sure you can have the normal free*/small DB's such as postgresql and mysql. -- 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] [Donations and Support]
RE: CHARTFX ColdFusion MX
This may or may not be of any help as it seems dated now (April 1998) but there is a presentation here - http://www.figleaf.com/figleafhome/cfug/cfugnews.cfm HTH Kola -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 15:25 To: CF-Talk Subject: Re: CHARTFX ColdFusion MX :-( Someone would have responded :-) no one??? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Great Resource for Non-Profits
I was referred to the following website by Macromedia. It offers software products for non-profit organizations at super low prices, which typically amount to a handling fee. I have ordered and been pleased so far. http://www.techsoup.org/stock -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
On Friday 18 Jun 2004 15:27 pm, Jeff Small wrote: databases solutions are you guys using locally? On MacOS, I'm fairly sure you can have the normal free*/small DB's such as postgresql and mysql. Okay, if a guy's familiar with access and MSSQL, which one would he gravitate towards? Which one works best with CFMX on JRun? I'm assuming everything will go thru JDBC, so whichever one works best...right? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Musings CFAnywhere, Bandwidth, RIAs Part 1
On Jun 18, 2004, at 6:27 AM, Thomas Chiverton wrote: On Friday 18 Jun 2004 13:49 pm, Dave Watts wrote: Admittedly, .NET desktop applications aren't cross-platform, but there are ways to build fx:cough Mono Responding to both you and Dave: So, let me see if I understand, this. All the wonderfulness of CF (RADD, power, db manipulation, ease of learning, ease of maintenance,etc.) is up to the task of serving many concurrent userson a complex web application, But, CF is *not* up to the task of a single user desktop application? To write a simple desktop application it is necessary to go to a more difficult language such as C#, or Java, or Perl? Then I must program a semi-custom UI for each platform? Doesn't Scales Well mean scales down as well as up? What am I missing? I think it is the law of Prometheus (or is it Occam's razor) that says: The simplest way is the best way! Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
On Friday 18 Jun 2004 15:38 pm, Jeff Small wrote: Okay, if a guy's familiar with access and MSSQL, which one would he gravitate towards? Which one works best with CFMX on JRun? I'm assuming everything will go thru JDBC, so whichever one works best...right? MySQL has better GUI tools (in the shape of MySQL-CC), in my experience. -- 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] [Donations and Support]
Re: CHARTFX ColdFusion MX
Thanks Kola, that article is a way back when CHARTFX was introduces, now their all syntax have been changed. The main thing which I am looking for is to find the way to run the query in ADODB syle in coldFusion. !---Create the ADODB Connection and query the database--- CFOBJECT ACTION="" NAME=Conn CLASS=ADODB.Connection !---Open the ODBC data source--- CFSET Conn.open(DSN=CfxSrv;UID=guest;,,0,0) !---Execute the SQL statement that will return the data--- CFSET RS=Conn.Execute(SELECT Month,Sales,Projected From CIEDemoSales,,0) the above query is connected with Access db, how can I use the same style query with SQL server. Thanks asim :-( Someone would have responded :-) no one??? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
You also can get free developer versions of Sybase_ASE (up to 25 concurrent users, AIR), Oracle9i PointBase, etc -- most any popular DB except MS-SQL-Server and MS-Access. If you use SQL-Server, have a look at Sybase -- they share ancesters both have T/SQ. HTH Dick On Jun 18, 2004, at 7:32 AM, Thomas Chiverton wrote: On Friday 18 Jun 2004 15:27 pm, Jeff Small wrote: databases solutions are you guys using locally? On MacOS, I'm fairly sure you can have the normal free*/small DB's such as postgresql and mysql. -- 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] [Donations and Support]
ASP.Net equivalent of CFLOOP in the page...?
Can anyone help me with this: In CF i'm used to being able to dynamically generate sections of an HTML form by looping over a section of HTML code like this: table tr tdHeader/td /tr cfloop from=1 to=5 index=i tr td cfoutput input type=text name=someField#i# /cfoutput /td /tr /cfloop /table Does anyone know how to do this with asp.Net? So far i've been able to discover that I can add controls to the page dynamically using Controls.Add() and asp:PlaceHolder. This doesn't allow me to add controls to a page without first knowing how many I will need and hard-coding placeholders though... Chris. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF and Eclipse
I've just put the new version on and the latest cfeclipse...i can see me switching to this as my preferred IDe very quickly...just need to figure out how to ftp from within eclipse - anyone? -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 13:52 To: CF-Talk Subject: RE: CF and Eclipse I recently installed it and I must say version 3.0 is cracking...looks good, performs well.the little insight and CFC explorer inline are great as well. _ From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 13:39 To: CF-Talk Subject: CF and Eclipse Sorry for asking a question that I am sure has already been asked but I cannot seem to be able to get to the House of Fusion to look it up. I am interested in using Eclipse to do some of my CF development in and I would like to know what I need to do to get it to work. Do I just download eclipse for sourceforge and that is it.I do remember reading a post about something called CFEclipse. Thanks Mario _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Using OS X you can get mysql and phpmyadminor/andAqua Data studio (as a client for most db servers) Just an open question do people STILL really use accessin production environments?! -- Mark Drew mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ASP.Net equivalent of CFLOOP in the page...?
Can anyone help me with this: In CF i'm used to being able to dynamically generate sections of an HTML form by looping over a section of HTML code like this: table tr tdHeader/td /tr cfloop from=1 to=5 index=i tr td cfoutput input type=text name=someField#i# /cfoutput /td /tr /cfloop /table Does anyone know how to do this with asp.Net? So far i've been able to discover that I can add controls to the page dynamically using Controls.Add() and asp:PlaceHolder. This doesn't allow me to add controls to a page without first knowing how many I will need and hard-coding placeholders though... Chris. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: advanced search
Thanks again Nando, Phillip, and Dave, and others who responded.I am currently using Verity. I asked a few co-workers at first and they suggested that Verity would not work correctly.And from the little bit that I knew of cfcollection (which was very little) I didn't believe that it would work either so I never seriously looked at the docs for it.I know, my mistake!I guess the docs should always be looked at...no matter what you hear! It does the functionality that I was looking for (i.e. NOT, AND , OR). I really appreciate ya'll's help - Frank From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, June 17, 2004 11:55 AM To: CF-Talk Subject: RE: advanced search Thanks guys for helping me with this.I looked more in Verity.Verity only looks at static pages.Since my page is generated dynamically by the database at runtime, this option will not work.I'm still kinda new to CF and so didn't know about CFQUERYPARAM...but I do now :-) You can index database content using Verity and the CFINDEX tag. You can't easily index the generated pages that use that content, but it's very easy to index the content itself. Then, when someone searches Verity, the search results can contain the primary keys of the relevant records, and you can easily display links to pages that show those records. 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] [Donations and Support]
Re: ColdFusion on Mac OS X
You also can get free developer versions of Sybase_ASE (up to 25 concurrent users, AIR), Oracle9i PointBase, etc -- most any popular DB except MS-SQL-Server and MS-Access. If you use SQL-Server, have a look at Sybase -- they share ancesters both have T/SQ. Sybase sounds interesting. I don't really want to move to Oracle because of the syntax differences (I mean, I'm just going by what I see here, and it always seems like if someone gives a SQL solution, they almost always have to add an Oracle caveat, it seems) because I'd like to work on some work stuff on the laptop. So, Sybase uses things like @@IDENTITY? What flavor of SQL does MySQL use? I think it's now a toss-up kinda, between the two, but it seems like MySQL is going to be the most common in that it seems like every host on earth supports it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Jeff Small wrote: On MacOS, I'm fairly sure you can have the normal free*/small DB's such as postgresql and mysql. Okay, if a guy's familiar with access and MSSQL, which one would he gravitate towards? Which one works best with CFMX on JRun? I'm assuming everything will go thru JDBC, so whichever one works best...right? They work equally well. MySQL could be a bit easier to set up, PostgreSQL offers more features. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF and Eclipse
Sorry for asking a question that I am sure has already been asked but I cannot seem to be able to get to the House of Fusion to look it up. I am interested in using Eclipse to do some of my CF development in and I would like to know what I need to do to get it to work. Do I just download eclipse for sourceforge and that is it.I do remember reading a post about something called CFEclipse. Mario, First you need to download the Eclipse IDE from www.eclipse.org (I believe the latest stable build is 3.0-M9). CFEclipse is a plugin to Eclipse that allows it to recognize ColdFusion syntax -- think adding HomeSite+ functionality to Eclipse, to an extent. Here is a great page to help you get a better feel for what it is and to get you started. The plugin has come a very long way in a short time. http://www.dopefly.com/pages/cfeclipse.html Hope this helps. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CHARTFX ColdFusion MX
Have you tried it with SQL server? Try this Replacing I think you need to change the connection string so it will be something like the following: Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Northwind; User Id = sa; Password= You willneed to change the datasource/username etc Kola -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 15:53 To: CF-Talk Subject: Re: CHARTFX ColdFusion MX Thanks Kola, that article is a way back when CHARTFX was introduces, now their all syntax have been changed. The main thing which I am looking for is to find the way to run the query in ADODB syle in coldFusion. !---Create the ADODB Connection and query the database--- CFOBJECT ACTION="" NAME=Conn CLASS=ADODB.Connection !---Open the ODBC data source--- CFSET Conn.open(DSN=CfxSrv;UID=guest;,,0,0) !---Execute the SQL statement that will return the data--- CFSET RS=Conn.Execute(SELECT Month,Sales,Projected From CIEDemoSales,,0) the above query is connected with Access db, how can I use the same style query with SQL server. Thanks asim :-( Someone would have responded :-) no one??? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF and Eclipse
First you need to download the Eclipse IDE from www.eclipse.org (I believe the latest stable build is 3.0-M9). CFEclipse is a plugin to Eclipse that allows it to recognize ColdFusion syntax -- think adding HomeSite+ functionality to Eclipse, to an extent. Here is a great page to help you get a better feel for what it is and to get you started. The plugin has come a very long way in a short time. http://www.dopefly.com/pages/cfeclipse.html Just a quick note that the latest stable release is 3.0 RC2, not M9. Not a big deal, but just wanted to point it out. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFLoop to insert multiple records
Hi all, I'm trying to get the following to work. 1) Query an existing access db table, loop the results (in this case, about 3000 records), and insert each record sequentially into the appropriate SQL 2000 table. 2) Problem is, should I be using a query loop, or an index loop to insert the records (the new SQL table creates the unique increment value).The way I have the code now throws an error with the for statement. == !--- 1. Retrieve records from the Access db --- cfquery name=getRecords datasource=powellEmail SELECT * FROM pm ORDER BY emailaddress /cfquery !--- 2. Insert the records into the SQL database --- !--- Loop through the getRecords query fields and update the new table. --- cfloop from=1 to=#getRecords.recordcount# index=ThisRow cfsetVARIABLES.confirmationID = #CreateUUID()#!--- Create a Unique Identifier to use as a confirming Email ID Number --- cfquery name=INSObj1 datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# INSERT INTO #REQUEST.prefix#_Email_AddressList1 (firstname, lastname, emconfID, emailaddress) VALUES (cfif Len(getRecords.firstName)cfqueryparam cfsqltype=cf_sql_varchar value=#Evaluate(getRecords.firstName ThisRow)#, /cfif cfif Len(getRecords.lastName)cfqueryparam cfsqltype=cf_sql_varchar value=#Evaluate(getRecords.lastName ThisRow)#, /cfif cfqueryparam cfsqltype=cf_sql_varchar value=#Evaluate(VARIABLES.confirmationID ThisRow)#, cfqueryparam cfsqltype=cf_sql_varchar value=#Evaluate(LCase(getRecords.emailaddress) ThisRow)# /cfquery !--- Get the last inserted record to pass through to the email sendout routine --- cfquery name=getLastRecord datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# SELECT MAX(#REQUEST.prefix#_Email_AddressList1.emailID) as emailID FROM #REQUEST.prefix#_Email_AddressList1 /cfquery !--- Associate the subscriber with the groups --- cfquery name = INSOBJcat datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# INSERT INTO #REQUEST.prefix#_Email_JoinAddressListGroups1 (subscriberGroupID, emailID) VALUES (9, #getLastRecord.emailID#) /cfquery /cfloop == Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHARTFX ColdFusion MX
the following code i tried and it throw me the error !--- Set the connection variables --- cfset serverIP = 192.168.1.11 cfset dbName = infiniti_adbuilder cfset username = _infiniti_ cfset password = infiniti123 cfset sqlString = select region, id, Buildprovince from dealers !--- Create the connection to the server --- !---cfset ConnectString=Provider=MSDASQL;DSN=infiniti;UID=_infiniti_;PWD=infiniti123;--- cfset ConnectString=Provider='SQLOLEDB';Server='#serverIP#';Initial Catalog='#dbName#' cfobject type=COM name=ConnectionObject class=ADODB.Connection action=""> cfset discard = ConnectionObject.Open(ConnectString,#username#,#password#,0) !--- Run the query --- cfset myResultSet = ConnectionObject.Execute(#sqlString#,0,8) !--- Get the column names --- cfset Columns = cfloop collection=#myResultSet.Fields# item=thisField cfset Columns = listappend(Columns, thisField.name) /cfloop !--- Populate a newly made query with Columns --- cfset MyRecords = querynew(Columns) !--- Go to the first row of the recordset --- cfset myResultSet.movefirst() !--- And populate the recordset... --- cftry cfloop from=1 to=25 index=i cfif NOT myResultSet.EOF cfset queryaddrow(MyRecords, 1) /cfif cfloop collection=#myResultSet.Fields# item=this cfset querysetcell(MyRecords, trim(this.name), this.value, i) /cfloop cfset myResultSet.movenext() /cfloop cfcatch/cfcatch /cftry !--- Output the data --- table border=1 !--- output the columns --- tr cfoutput cfloop index=thisColumn list=#MyRecords.columnList# th#thisColumn#/th /cfloop /cfoutput /tr !--- output the rows --- cfoutput query=MyRecords tr cfloop list=#MyRecords.columnlist# index=this td#evaluate(this)#/td /cfloop /tr /cfoutput /table !--- Close the ODBC connection (like you do in asp)--- cfset ConnectionObject.Close() the error I got is An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80004005 - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. in 'Microsoft OLE DB Provider for SQL Server'. The error occurred in C:\Inetpub\wwwroot\dev\test2.cfm: line 12 10 :cfset ConnectString=Provider='SQLOLEDB';Server='#serverIP#';Initial Catalog='#dbName#' 11 : cfobject type=COM name=ConnectionObject class=ADODB.Connection action=""> 12 : cfset discard = ConnectionObject.Open(ConnectString,#username#,#password#,0) 13 : !--- Run the query --- 14 : cfset myResultSet = ConnectionObject.Execute(#sqlString#,0,8) thanks asim Thanks Kola, that article is a way back when CHARTFX was introduces, now their all syntax have been changed. The main thing which I am looking for is to find the way to run the query in ADODB syle in coldFusion. !---Create the ADODB Connection and query the database--- CFOBJECT ACTION="" NAME=Conn CLASS=ADODB.Connection !---Open the ODBC data source--- CFSET Conn.open(DSN=CfxSrv;UID=guest;,,0,0) !---Execute the SQL statement that will return the data--- CFSET RS=Conn.Execute(SELECT Month,Sales,Projected From CIEDemoSales,,0) the above query is connected with Access db, how can I use the same style query with SQL server. Thanks asim :-( Someone would have responded :-) no one??? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Using OS X you can get mysql and phpmyadminor/andAqua Data studio (as a client for most db servers) Yeah, I was kinda hoping to stick with CF though. Use CF with some sort of DB. Just an open question do people STILL really use accessin production environments?! Oh sure. We do all the time. We're an advertising agency. A lot of times we'll do promotional sites with clients that may have a short lifespan, or may have barely any functionality at all besides collecting emails and addresses for contact. Why pay for SQL server when you'll have a trickle of people doing barely anything at all? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Jeff Small wrote: Sybase sounds interesting. I don't really want to move to Oracle because of the syntax differences (I mean, I'm just going by what I see here, and it always seems like if someone gives a SQL solution, they almost always have to add an Oracle caveat, it seems) FWIW, I would rate Oracle higher on standard compliance as MS SQL Server (if you start counting the SQL features they are pretty close, but MS SQL Server scores big in areas which are often less important for portability such as the information_schema, while Oracle does better in datatype and function support). But I suppose that if you are used to seeing the idiosyncracies of one database you forget that they are just that, idiosyncracies, and use that as the measure for all other databases. What flavor of SQL does MySQL use? Subset of SQL-92 Core, additions using a very 'different' syntax, many gotcha's: http://sql-info.de/mysql/gotchas.html I think it's now a toss-up kinda, between the two, but it seems like MySQL is going to be the most common in that it seems like every host on earth supports it. We don't :) Why would we want to offer MySQL when we can offer PostgreSQL? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Datasource creation errors
I'm having trouble creating Access and socket DSNs with the ColdFusion Administrator. The error message is: Connection verification failed for data source: DSN_NAME []java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined. Oddly, the sample DSNs, which use the ODBC socket driver also, work fine. Also SQL DSNs verify with no problem. I am using CFMX 6.1 and have upgraded to the 3.3 versions of the JDBC drivers. I have also uninstalled/reinstalled the CFMX ODBC Agent and Server, and installed Macromedia hotfixes hf53486_61.jar and hf53852_61.jar. I have been stuck on this for a while and am at a loss, all help appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Havent uinstalled PostgreSQL on OS X as yet.. are there good clients apart from Aqua datastudio? On Fri, 18 Jun 2004 17:34:16 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: Jeff Small wrote: Sybase sounds interesting. I don't really want to move to Oracle because of the syntax differences (I mean, I'm just going by what I see here, and it always seems like if someone gives a SQL solution, they almost always have to add an Oracle caveat, it seems) FWIW, I would rate Oracle higher on standard compliance as MS SQL Server (if you start counting the SQL features they are pretty close, but MS SQL Server scores big in areas which are often less important for portability such as the information_schema, while Oracle does better in datatype and function support). But I suppose that if you are used to seeing the idiosyncracies of one database you forget that they are just that, idiosyncracies, and use that as the measure for all other databases. What flavor of SQL does MySQL use? Subset of SQL-92 Core, additions using a very 'different' syntax, many gotcha's: http://sql-info.de/mysql/gotchas.html I think it's now a toss-up kinda, between the two, but it seems like MySQL is going to be the most common in that it seems like every host on earth supports it. We don't :) Why would we want to offer MySQL when we can offer PostgreSQL? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Datasource creation errors
OK...here's what I've always had to do: -set up the DSN via Windows ODBC -set the DSN to use Windows Authentication -test it at the end -go into CF Admin -setup the datasource as you normally would -now it will work ;-) Ahhh...I long for the good old days wehn CF Admin did it all ;-) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Kathleen Cashel To: CF-Talk Sent: Friday, June 18, 2004 8:36 AM Subject: Datasource creation errors I'm having trouble creating Access and socket DSNs with the ColdFusion Administrator. The error message is: Connection verification failed for data source: DSN_NAME []java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined. Oddly, the sample DSNs, which use the ODBC socket driver also, work fine. Also SQL DSNs verify with no problem. I am using CFMX 6.1 and have upgraded to the 3.3 versions of the JDBC drivers. I have also uninstalled/reinstalled the CFMX ODBC Agent and Server, and installed Macromedia hotfixes hf53486_61.jar and hf53852_61.jar. I have been stuck on this for a while and am at a loss, all help appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
We don't :) Why would we want to offer MySQL when we can offer PostgreSQL? So...less SQL gotchas on PostgreSQL? I'm listening...I'm listening... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
I guess if it is small amount of traffic it is ok, I do disagree on principle though! use mySQL as it is for freebut I can see your point.. and it scares me :) Oh sure. We do all the time. We're an advertising agency. A lot of times we'll do promotional sites with clients that may have a short lifespan, or may have barely any functionality at all besides collecting emails and addresses for contact. Why pay for SQL server when you'll have a trickle of people doing barely anything at all? -- Mark Drew mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Havent uinstalled PostgreSQL on OS X as yet.. are there good clients apart from Aqua datastudio? Do you have to download/install PostgreSQL...then go get a client to interface with it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHARTFX ColdFusion MX
the following code i tried and it throw me the error !--- Set the connection variables --- cfset serverIP = 192.168.1.11 cfset dbName = infiniti_adbuilder cfset username = _infiniti_ cfset password = infiniti123 cfset sqlString = select region, id, Buildprovince from dealers !--- Create the connection to the server --- !---cfset ConnectString=Provider=MSDASQL;DSN=infiniti;UID=_infiniti_;PWD=infiniti123;--- cfset ConnectString=Provider='SQLOLEDB';Server='#serverIP#';Initial Catalog='#dbName#' cfobject type=COM name=ConnectionObject class=ADODB.Connection action="" cfset discard = ConnectionObject.Open(ConnectString,#username#,#password#,0) !--- Run the query --- cfset myResultSet = ConnectionObject.Execute(#sqlString#,0,8) !--- Get the column names --- cfset Columns = cfloop collection=#myResultSet.Fields# item=thisField cfset Columns = listappend(Columns, thisField.name) /cfloop !--- Populate a newly made query with Columns --- cfset MyRecords = querynew(Columns) !--- Go to the first row of the recordset --- cfset myResultSet.movefirst() !--- And populate the recordset... --- cftry cfloop from=1 to=25 index=i cfif NOT myResultSet.EOF cfset queryaddrow(MyRecords, 1) /cfif cfloop collection=#myResultSet.Fields# item=this cfset querysetcell(MyRecords, trim(this.name), this.value, i) /cfloop cfset myResultSet.movenext() /cfloop cfcatch/cfcatch /cftry !--- Output the data --- table border=1 !--- output the columns --- tr cfoutput cfloop index=thisColumn list=#MyRecords.columnList# th#thisColumn#/th /cfloop /cfoutput /tr !--- output the rows --- cfoutput query=MyRecords tr cfloop list=#MyRecords.columnlist# index=this td#evaluate(this)#/td /cfloop /tr /cfoutput /table !--- Close the ODBC connection (like you do in asp)--- cfset ConnectionObject.Close() the error I got is An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80004005 - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. in 'Microsoft OLE DB Provider for SQL Server'. The error occurred in C:\Inetpub\wwwroot\dev\test2.cfm: line 12 10 :cfset ConnectString=Provider='SQLOLEDB';Server='#serverIP#';Initial Catalog='#dbName#' 11 : cfobject type=COM name=ConnectionObject class=ADODB.Connection action=""> 12 : cfset discard = ConnectionObject.Open(ConnectString,#username#,#password#,0) 13 : !--- Run the query --- 14 : cfset myResultSet = ConnectionObject.Execute(#sqlString#,0,8) thanks asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Normally, a lot of the clients for open source projects are developed seperately. or they come with a command line client On Fri, 18 Jun 2004 11:46:27 -0400, Jeff Small [EMAIL PROTECTED] wrote: Havent uinstalled PostgreSQL on OS X as yet.. are there good clients apart from Aqua datastudio? Do you have to download/install PostgreSQL...then go get a client to interface with it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Jeff Small wrote: We don't :) Why would we want to offer MySQL when we can offer PostgreSQL? So...less SQL gotchas on PostgreSQL? Apparently so, nobody bothered to compile a list :-) I am not sure if there are actually less gotchas, but in my experience they are different: they are about performance, not about data integrity. I feel much more comfortable with that approach: performance issues can easily be solved with more iron (to a certain extent of course). But if you don't know if the data entered last year is correct, your problem is not that easily solved. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: advanced search
Welcome to the wonderful world of Verity Remember that each time you add something to the db you should also add it to the verity colleciton, it is also an idea to have another (CF) machineperforming the updates to verity to keep it going nice and fast. -- Mark Drew mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
Mark Drew wrote: Havent uinstalled PostgreSQL on OS X as yet.. are there good clients apart from Aqua datastudio? I mostly use the command line client that comes with the distribution, and for the rest pgAdmin. But there are many more, like phpPgAdmin, pgManage and a lot of commercial tools. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFLoop to insert multiple records
I figured it out. Thanks, Mark _ From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 11:24 AM To: CF-Talk Subject: CFLoop to insert multiple records Hi all, I'm trying to get the following to work. 1) Query an existing access db table, loop the results (in this case, about 3000 records), and insert each record sequentially into the appropriate SQL 2000 table. 2) Problem is, should I be using a query loop, or an index loop to insert the records (the new SQL table creates the unique increment value).The way I have the code now throws an error with the for statement. == !--- 1. Retrieve records from the Access db --- cfquery name=getRecords datasource=powellEmail SELECT * FROM pm ORDER BY emailaddress /cfquery !--- 2. Insert the records into the SQL database --- !--- Loop through the getRecords query fields and update the new table. --- cfloop from=1 to=#getRecords.recordcount# index=ThisRow cfsetVARIABLES.confirmationID = #CreateUUID()#!--- Create a Unique Identifier to use as a confirming Email ID Number --- cfquery name=INSObj1 datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# INSERT INTO #REQUEST.prefix#_Email_AddressList1 (firstname, lastname, emconfID, emailaddress) VALUES (cfif Len(getRecords.firstName)cfqueryparam cfsqltype=cf_sql_varchar value=#Evaluate(getRecords.firstName ThisRow)#, /cfif cfif Len(getRecords.lastName)cfqueryparam cfsqltype=cf_sql_varchar value=#Evaluate(getRecords.lastName ThisRow)#, /cfif cfqueryparam cfsqltype=cf_sql_varchar value=#Evaluate(VARIABLES.confirmationID ThisRow)#, cfqueryparam cfsqltype=cf_sql_varchar value=#Evaluate(LCase(getRecords.emailaddress) ThisRow)# /cfquery !--- Get the last inserted record to pass through to the email sendout routine --- cfquery name=getLastRecord datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# SELECT MAX(#REQUEST.prefix#_Email_AddressList1.emailID) as emailID FROM #REQUEST.prefix#_Email_AddressList1 /cfquery !--- Associate the subscriber with the groups --- cfquery name = INSOBJcat datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# INSERT INTO #REQUEST.prefix#_Email_JoinAddressListGroups1 (subscriberGroupID, emailID) VALUES (9, #getLastRecord.emailID#) /cfquery /cfloop == Thanks, Mark _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
I guess if it is small amount of traffic it is ok, I do disagree on principle though! use mySQL as it is for freebut I can see your point.. and it scares me :) Remember though, a lot of times the clients have Access as well, and they like just going and downloading the access file themselves and doing whatever little funky mass mailer or promotion they're into with the list without doing anything else fancy to it...lol, but I see your point...it's just too bad that every client on earth just about (well, at least that we deal with) all have a million copies of Office distributed all thruout their respective businesses... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CHARTFX ColdFusion MX
Are you logging in with the correct username and password - also are you simply querying a sql server database to provide data to chartFX? Its not clear. Kola -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 16:52 To: CF-Talk Subject: Re: CHARTFX ColdFusion MX the following code i tried and it throw me the error !--- Set the connection variables --- cfset serverIP = 192.168.1.11 cfset dbName = infiniti_adbuilder cfset username = _infiniti_ cfset password = infiniti123 cfset sqlString = select region, id, Buildprovince from dealers !--- Create the connection to the server --- !---cfset ConnectString=Provider=MSDASQL;DSN=infiniti;UID=_infiniti_;PWD=infiniti 123;--- cfset ConnectString=Provider='SQLOLEDB';Server='#serverIP#';Initial Catalog='#dbName#' cfobject type=COM name=ConnectionObject class=ADODB.Connection action="" cfset discard = ConnectionObject.Open(ConnectString,#username#,#password#,0) !--- Run the query --- cfset myResultSet = ConnectionObject.Execute(#sqlString#,0,8) !--- Get the column names --- cfset Columns = cfloop collection=#myResultSet.Fields# item=thisField cfset Columns = listappend(Columns, thisField.name) /cfloop !--- Populate a newly made query with Columns --- cfset MyRecords = querynew(Columns) !--- Go to the first row of the recordset --- cfset myResultSet.movefirst() !--- And populate the recordset... --- cftry cfloop from=1 to=25 index=i cfif NOT myResultSet.EOF cfset queryaddrow(MyRecords, 1) /cfif cfloop collection=#myResultSet.Fields# item=this cfset querysetcell(MyRecords, trim(this.name), this.value, i) /cfloop cfset myResultSet.movenext() /cfloop cfcatch/cfcatch /cftry !--- Output the data --- table border=1 !--- output the columns --- tr cfoutput cfloop index=thisColumn list=#MyRecords.columnList# th#thisColumn#/th /cfloop /cfoutput /tr !--- output the rows --- cfoutput query=MyRecords tr cfloop list=#MyRecords.columnlist# index=this td#evaluate(this)#/td /cfloop /tr /cfoutput /table !--- Close the ODBC connection (like you do in asp)--- cfset ConnectionObject.Close() the error I got is An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80004005 - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. in 'Microsoft OLE DB Provider for SQL Server'. The error occurred in C:\Inetpub\wwwroot\dev\test2.cfm: line 12 10 :cfset ConnectString=Provider='SQLOLEDB';Server='#serverIP#';Initial Catalog='#dbName#' 11 : cfobject type=COM name=ConnectionObject class=ADODB.Connection action=""> 12 : cfset discard = ConnectionObject.Open(ConnectString,#username#,#password#,0) 13 : !--- Run the query --- 14 : cfset myResultSet = ConnectionObject.Execute(#sqlString#,0,8) thanks asim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
I mostly use the command line client that comes with the distribution, and for the rest pgAdmin. But there are many more, like phpPgAdmin, pgManage and a lot of commercial tools. Does pgAdmin do what you can also do in the command line? I mean to say, the stuff that you're doing in the command line...pgAdmin can also do? You're just more comfortable in the command line? Am I hearing you right? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
A GUI Client is useful for experimenting with/validating complex queries before coding them in CF. A fairly good, general-purpose, GUI SQL Client is ViennaSQL -- open Source, written in Java and can interface any DB that has a JDBC Driver. If you go MySQL, CocoaMYSQL is a Mac-specific GUI. BTW, on OS X, you don't need to mess with CLASSPATH -- just drop a copy of the jar containing the JDBC driver into: /Library/Java/Extensions This is on the default CLASSPATH, so every Java program will find them (you may need to burp CFMX, tho) HTH Dick On Jun 18, 2004, at 8:56 AM, Jochem van Dieten wrote: Mark Drew wrote: Havent uinstalled PostgreSQL on OS X as yet.. are there good clients apart from Aqua data studio? I mostly use the command line client that comes with the distribution, and for the rest pgAdmin. But there are many more, like phpPgAdmin, pgManage and a lot of commercial tools. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ColdFusion on Mac OS X
I agree Jeff, Sometimes it can be useful if the client wants to run a small report herself etc. KOla -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 16:49 To: CF-Talk Subject: Re: ColdFusion on Mac OS X I guess if it is small amount of traffic it is ok, I do disagree on principle though! use mySQL as it is for freebut I can see your point.. and it scares me :) Remember though, a lot of times the clients have Access as well, and they like just going and downloading the access file themselves and doing whatever little funky mass mailer or promotion they're into with the list without doing anything else fancy to it...lol, but I see your point...it's just too bad that every client on earth just about (well, at least that we deal with) all have a million copies of Office distributed all thruout their respective businesses... _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: QoQ type comparison bug
Did you try using cfqueryparam? I've seen this suggested as a possible solution elsewhere Kola -Original Message- From: Doug James [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 18:03 To: CF-Talk Subject: Re: QoQ type comparison bug Steve, Thanks for the suggestion, it got me closer. I ended up having to put everything into a date format to get it to work. cfquery name=Meeting_Dates dbType=query select Meeting_Date from Possible_Meeting_Dates where '#DateFormat(Possible_Meeting_Dates.Meeting_Date,mm/dd/)#' = '#DateFormat(now(),mm/dd/)#' and '#DateFormat(Possible_Meeting_Dates.Meeting_Date,mm/dd/)#' '#DateFormat(query1.meeting_date,mm/dd/)#' order by Meeting_Date /cfquery If there is a better way please let me know. Doug Steve Nelson wrote: It's probably because it's treating it like a string instead of a datetime since you used dateformat in the querysetcell. Is tmp_date already a date? Try removing the dateformat(). Steve Nelson _ From: Doug James [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 12:01 PM To: CF-Talk Subject: QoQ type comparison bug Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166693 --- HELP! I am getting the old: Query Of Queries runtime error. Unsupported type comparison. I have a db query then I build a QoQ using DateFormat(tmp_Date,mm/dd/) in the QuerySetCell(). I then have a QoQ: cfquery name=Meeting_Dates dbType=query select Meeting_Date from Possible_Meeting_Dates where Meeting_Date = '#DateFormat(now(),mm/dd/)#' and Meeting_Date '#query1.Meeting_Date#' order by Meeting_Date /cfquery The error is tagging the and Meeting_Date '#query1.Meeting_Date#' line. I have tried everything I can think of including cfqueryparam. The query1.meeting_date column is a SQL Server smalldatetime column. Please help! Thank you. Doug _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ASP.Net equivalent of CFLOOP in the page...?
not sure on the answer to that... Does anyone know of a comparable email list for these kind of questions? Aspnet-talk? -Original Message- From:Chris Spencer Date:6/18/04 11:02 am To:CF-Talk Subj:ASP.Net equivalent of CFLOOP in the page...? Can anyone help me with this: In CF i'm used to being able to dynamically generate sections of an HTML form by looping over a section of HTML code like this: table tr tdHeader/td /tr cfloop from=1 to=5 index=i tr td cfoutput input type=text name=someField#i# /cfoutput /td /tr /cfloop /table Does anyone know how to do this with asp.Net? So far i've been able to discover that I can add controls to the page dynamically using Controls.Add() and asp:PlaceHolder. This doesn't allow me to add controls to a page without first knowing how many I will need and hard-coding placeholders though... Chris. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cookie issues...
Hey guys, I am having Cookie issues... I don't use them very much so I may be a little lost here. I have a cookie called rsAgent that is created using ASP. I am trying to pull the values out of this cookie using ColdFusion on the same domain. When I cfdump the cookie rsAgent I get this: NeedUpdate=1Recognition=SupportEntityID=09AgentName=Neal BaileyRank=80AgentNumber=@@09 I then want to set the EntityID as a Session variable. But my problem is I can't figure out how to grab just the EntityID. I guess I need to convert it to a list using as a delimiter or something. Any ideas here?... I thought there was an easer way to do this when a cookie had multiple values. Neal Bailey Internet Marketing Manager E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion on Mac OS X
A GUI Client is useful for experimenting with/validating complex queries before coding them in CF. A fairly good, general-purpose, GUI SQL Client is ViennaSQL -- open Source, written in Java and can interface any DB that has a JDBC Driver. If you go MySQL, CocoaMYSQL is a Mac-specific GUI. BTW, on OS X, you don't need to mess with CLASSPATH -- just drop a copy of the jar containing the JDBC driver into: /Library/Java/Extensions This is on the default CLASSPATH, so every Java program will find them (you may need to burp CFMX, tho) HTH Dick Oh man...this is gonna be *so* hard...I understood like, half of that... *sigh* [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Musings CFAnywhere, Bandwidth, RIAs Part 1
So, let me see if I understand, this. All the wonderfulness of CF (RADD, power, db manipulation, ease of learning, ease of maintenance, etc.) is up to the task of serving many concurrent users on a complex web application, Yes, that's exactly right. CF was designed and created just for this single niche. It wasn't designed to be a general-purpose programming language, or to write desktop applications, and I think it's spectacularly unsuited for those tasks. But, CF is *not* up to the task of a single user desktop application? Right. I mean, you can certainly use it for that, but it's probably the least appropriate tool for the job I can think of. To write a simple desktop application it is necessary to go to a more difficult language such as C#, or Java, or Perl? If by more difficult you mean something you don't already know, yes, I suppose so. When you have a hammer, every problem looks like a nail. But if you're using a modern forms-based IDE, it's pretty easy to develop desktop applications that will be far more user-friendly and functional than a browser-based application interface. Then I must program a semi-custom UI for each platform? Not necessarily. Macromedia Director, for example, excels as a standalone multimedia application interface for CD-based applications. Doesn't Scales Well mean scales down as well as up? Not within the normal usage of the phrase, when people are talking about web applications. I think it is the law of Prometheus (or is it Occam's razor) that says: The simplest way is the best way! That's not Occam's razor, and I don't know about Prometheus, who after all wasn't known for his wisdom but his daring. And look what happened to him - he got chained to a rock and had his liver eaten daily. Yecch. I submit that using CF for desktop applications is not the simplest way. It's just the way with which we are most familiar. 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] [Donations and Support]
Re: ColdFusion on Mac OS X
Jeff Small wrote: I mostly use the command line client that comes with the distribution, and for the rest pgAdmin. But there are many more, like phpPgAdmin, pgManage and a lot of commercial tools. Does pgAdmin do what you can also do in the command line? I mean to say, the stuff that you're doing in the command line...pgAdmin can also do? You're just more comfortable in the command line? Am I hearing you right? Of course functionality overlaps a lot between any two clients. I mostly use pgAdmin for quickly changing a few values in tables and for exploring unknown databases (customers with problems). But when I want to interactively step through a multi-query script, I prefer the command line. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
request scope in cfc... really so bad?
Thoughts? If CFCs were EJBs, you would have external config info that you would look up using JNDI (or something, I'm not quite up to snuff on J2EE). Let's say I am careful and create well named variables like... request.cfcname.datasource = MyDatasource; request.cfcname.timeout = 300; etc, all in one file called cfcname.cfm that is included in application.cfm. Contract with the developer is you have to include cfcname.cfm in your application.cfm before calling the CFC. Am I such a bad guy? I guess worst case scenario is Macromedia decides not to support it one day, but I haven't heard anything about that. It's just such a pain if there's 10 variables in your app that are required by 10 different CFCs, passing them in as args to the constructor seems awkward. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle - Incorrect Number of Arguments or Type
CF is connecting as the schema owner. Everything worked fine until we took away the DBA role from the schema owner. So the schema owner is still maintaing all its permissions outside of the dba role. The thing is that schema owner still has access to the packages, otherwise Oracle with throw a proceudre not found type error. So when everything breaks we reapply dba roles, but that doesnt fix the problem. The packages then need to be recompiled. -Adam - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] Date: Fri, 18 Jun 2004 10:46:49 +0100 Subject: Re: Oracle - Incorrect Number of Arguments or Type To: CF-Talk [EMAIL PROTECTED] On Thursday 17 Jun 2004 21:21 pm, Adrocknaphobia wrote: After performing a security lockdown on the Oracle server, namely removing DBA from the role which access the package, CF cannot call store procedures which return a result set. What roles/permissions does that leave the CF user with ? -- 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] [Donations and Support]
RE: request scope in cfc... really so bad?
Why not make a configuration CFC (basically an encapsulated struct), that you can pass to all the various CFCs?Instantiate that CFC into the application scope, initialize it with the parameters, and then pass that single course-grained view of the configuration data to each individual CFC that needs it. Cheers, barneyb -Original Message- From: Simon Stanlake [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 9:29 AM To: CF-Talk Subject: request scope in cfc... really so bad? Thoughts? If CFCs were EJBs, you would have external config info that you would look up using JNDI (or something, I'm not quite up to snuff on J2EE). Let's say I am careful and create well named variables like... request.cfcname.datasource = MyDatasource; request.cfcname.timeout = 300; etc, all in one file called cfcname.cfm that is included in application.cfm. Contract with the developer is you have to include cfcname.cfm in your application.cfm before calling the CFC. Am I such a bad guy? I guess worst case scenario is Macromedia decides not to support it one day, but I haven't heard anything about that. It's just such a pain if there's 10 variables in your app that are required by 10 different CFCs, passing them in as args to the constructor seems awkward. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHARTFX ColdFusion MX
write now I am just using the ADODB style query, I am not interacting with CHARTFX for now. If I get success to run the query in that way then I will implement it with CHARTFX. Yes I double check that I put the right username password. I think its a bug http://support.microsoft.com/default.aspx?kbid=315159 not sure what to do now. thanks asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle - Incorrect Number of Arguments or Type
Also searching MM forums find some promising thread titles, but I get a site area unavailable message. Yay! -Adam On Fri, 18 Jun 2004 12:29:47 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: CF is connecting as the schema owner. Everything worked fine until we took away the DBA role from the schema owner. So the schema owner is still maintaing all its permissions outside of the dba role. The thing is that schema owner still has access to the packages, otherwise Oracle with throw a proceudre not found type error. So when everything breaks we reapply dba roles, but that doesnt fix the problem. The packages then need to be recompiled. -Adam - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] Date: Fri, 18 Jun 2004 10:46:49 +0100 Subject: Re: Oracle - Incorrect Number of Arguments or Type To: CF-Talk [EMAIL PROTECTED] On Thursday 17 Jun 2004 21:21 pm, Adrocknaphobia wrote: After performing a security lockdown on the Oracle server, namely removing DBA from the role which access the package, CF cannot call store procedures which return a result set. What roles/permissions does that leave the CF user with ? -- 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] [Donations and Support]
RE: Great Resource for Non-Profits
As a follow up to this, I order the Microsoft Action Pack and found a pricing configuration tool on the Partner site that lets you price Microsoft products and when you go through there is an option for type of business.If you're a charity or non-profit organization, you can get AMAZING prices on all Microsoft products.Dell also participates in this, so if you call and order computers, ask about charity licensing for Microsoft products.Just thought I'd share.I was just able to save my Church thousands of dollars through this program.If you need more info, feel free to contact me off list. John -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 10:38 AM To: CF-Talk Subject: Great Resource for Non-Profits I was referred to the following website by Macromedia. It offers software products for non-profit organizations at super low prices, which typically amount to a handling fee. I have ordered and been pleased so far. http://www.techsoup.org/stock -Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CHARTFX ColdFusion MX
Subject: Re: CHARTFX ColdFusion MX When I last used ChartFX, I was able to pass individual data points to it, rather than passing an ADO/ADODB recordset. If you can do that, you can use CFQUERY to fetch your data, then you can just pass those data points directly. the error I got is An exception occurred when executing a Com method. The cause of this exception was that: AutomationException: 0x80004005 - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. in 'Microsoft OLE DB Provider for SQL Server'. I suspect that you have some error in your connect string. Have you tried the same connection information from another client? Have you been able to connect through the ODBC control panel, for example? 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] [Donations and Support]
RE: CHARTFX ColdFusion MX
write now I am just using the ADODB style query, I am not interacting with CHARTFX for now. If I get success to run the query in that way then I will implement it with CHARTFX. Yes I double check that I put the right username password. I think its a bug http://support.microsoft.com/default.aspx?kbid=315159 not sure what to do now. If your SQL Server supports TCP/IP, you could use that instead of Named Pipes. 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] [Donations and Support]
RE: ColdFusion on Mac OS X
Okay, if a guy's familiar with access and MSSQL, which one would he gravitate towards? Which one works best with CFMX on JRun? I'm assuming everything will go thru JDBC, so whichever one works best...right? In general, you're better off using a database server like MS SQL Server rather than a desktop database like Access. Of course, SQL Server is quite a bit more expensive. 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] [Donations and Support]
RE: Musings CFAnywhere, Bandwidth, RIAs Part 1
Also how portable is it? Its always annoyed me that it doesnt have the print capabilites that powerpoint has and that you can't simply download a presenatation It's an online application. It uses Flash. While it could perhaps be engineered to work as a local application, I suppose, that's simply not what it's for. 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] [Donations and Support]
Re: Oracle - Incorrect Number of Arguments or Type
Here is the official error its throwing: wrong number or types of arguments On Fri, 18 Jun 2004 12:41:56 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: Also searching MM forums find some promising thread titles, but I get a site area unavailable message. Yay! -Adam On Fri, 18 Jun 2004 12:29:47 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: CF is connecting as the schema owner. Everything worked fine until we took away the DBA role from the schema owner. So the schema owner is still maintaing all its permissions outside of the dba role. The thing is that schema owner still has access to the packages, otherwise Oracle with throw a proceudre not found type error. So when everything breaks we reapply dba roles, but that doesnt fix the problem. The packages then need to be recompiled. -Adam - Original Message - From: Thomas Chiverton [EMAIL PROTECTED] Date: Fri, 18 Jun 2004 10:46:49 +0100 Subject: Re: Oracle - Incorrect Number of Arguments or Type To: CF-Talk [EMAIL PROTECTED] On Thursday 17 Jun 2004 21:21 pm, Adrocknaphobia wrote: After performing a security lockdown on the Oracle server, namely removing DBA from the role which access the package, CF cannot call store procedures which return a result set. What roles/permissions does that leave the CF user with ? -- 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] [Donations and Support]
RE: cfmx and CAPTCHA
Apparently Blue dragon can but I haven't tried it ;-) KOla -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 13:43 To: CF-Talk Subject: RE: cfmx and CAPTCHA why don't CFC instances go across cluster members? I don't really know why they don't, just that they don't. I suspect that JRun has some sort of serializer to write its own session variables to strings, and that this serializer doesn't know what to do with CFC instances, but I really don't know for certain. 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] [Donations and Support]
RE: problems using ADODB (was CHARTFX ColdFusion MX)
IS there a particular reason why you need to run the query that way? As its fairly trivial to retrieve information from a SQL server database I would actually concentrate on getting chartFX up and running - you can create a mock/fake query to test chartfx if that's what you're trying to achieve? KOla -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 17:38 To: CF-Talk Subject: Re: CHARTFX ColdFusion MX write now I am just using the ADODB style query, I am not interacting with CHARTFX for now. If I get success to run the query in that way then I will implement it with CHARTFX. Yes I double check that I put the right username password. I think its a bug http://support.microsoft.com/default.aspx?kbid=315159 not sure what to do now. thanks asim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: request scope in cfc... really so bad?
yep, though I guess my question is really, why not use request scope, rather than how to work around it. There are probably lots of ways to do it without using request scope, but request seems like the least overhead. From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 9:36 AM To: CF-Talk Subject: RE: request scope in cfc... really so bad? Why not make a configuration CFC (basically an encapsulated struct), that you can pass to all the various CFCs?Instantiate that CFC into the application scope, initialize it with the parameters, and then pass that single course-grained view of the configuration data to each individual CFC that needs it. Cheers, barneyb -Original Message- From: Simon Stanlake [mailto:[EMAIL PROTECTED] Sent: Friday, June 18, 2004 9:29 AM To: CF-Talk Subject: request scope in cfc... really so bad? Thoughts? If CFCs were EJBs, you would have external config info that you would look up using JNDI (or something, I'm not quite up to snuff on J2EE). Let's say I am careful and create well named variables like... request.cfcname.datasource = MyDatasource; request.cfcname.timeout = 300; etc, all in one file called cfcname.cfm that is included in application.cfm. Contract with the developer is you have to include cfcname.cfm in your application.cfm before calling the CFC. Am I such a bad guy? I guess worst case scenario is Macromedia decides not to support it one day, but I haven't heard anything about that. It's just such a pain if there's 10 variables in your app that are required by 10 different CFCs, passing them in as args to the constructor seems awkward. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cookie issues...
But my problem is I can't figure out how to grab just the EntityID. This is an issue for RegEx. If you're not too familiar with regEX, see the REWizard, And if you really want it to be even easier, see the tag CF_REExtract that could to the job with only one step, like: CF_REextract INPUTMODE= variable INPUT= cookie.rsAgent RE1= EntityID= RE2= [OUTPUTMODE]= list OUTPUT= session.EntityID Both at the address below. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]