sql help -- joining 4 tables
good evening all (Or morning). I've been digging around the net all night (and a number of books at Borders- best library in town) but I can't find an easy example so here we go: I want to join 4 tables, what would a generic 4 table join look like? thanks ahead of time. your help keeps me sane :) Jason ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Communicating FROM Flash Calendar Component
This is my first effort at communicating between Flash and ColdFusion. (Sorry, Ben, I'm not that far in your book just yet, but it is a great, easy read and I applaud you and the team on it!) I'll be using the Flash Calendar Component--quite simply so that I can select a "Start Date" for an employee, and when the date is selected, I'll "submit" and the information (date) will be passed to a ColdFusion MX page that spawned the calendar window. That value will, ideally, be populated into the form field on the page without requiring an update of the CFMX page (I'll figure that out). I'm pretty virginal with the communication of Flash to-and-from CFMX, so I'm hoping I can get a little shove in the right direction. I'm not virginal to Flash, and I'm still shaking some of the water out from behind my ears upon occasion with CFMX, but I think I can manage with a little direction. Thanks in advance, and I appreciate any assistance. Kind regards, Russ Unger Managing Partner blueChrome design, LLC www.bluechromedesign.com 312.593.4260 :office 877.433.8427 :pager 312.873.4033 :fax ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Question about Oracle JDBC drivers on MX
On Tuesday, Nov 5, 2002, at 14:54 US/Pacific, Ciliotta, Mario wrote: > I was wondering if anyone could explain to me the difference between > the Oracle JDBC drivers. I was looking thru some old postings and I > noticed a post about Oracle drivers: OCI and Thin Client and the MX > Driver. Is there a major difference between the three. I am currently > in the testing some of my apps in MX and I was just wondering if I > should use the supplied driver or try to install Oracle's instead. The Oracle driver supplied with CFMX is an Oracle 8i driver. If you are using Oracle 8i, you can probably stick with this driver without a problem (although you may find the 9i Thin Client driver faster - see below). If you are using Oracle 9i, I would recommend you download and install either the 9i Thin Client driver or the 9i OCI native driver. If you are planning on doing extensive work with CLOB / BLOB types, I believe you will find the OCI drivers more reliable. > I believe that the Oracle Drivers need to be downloaded from Oracle > and installed on the server. Correct. You need to register with Oracle Tech Net (free) in order to download the drivers. They have drivers for various platforms (including Mac :) You quoted: > But look at the second run. The second run and other runs to the > database were consisted. The jdbc:oracle:thin > driver was always the fastest followed by the jdbc:oracle:oci driver. > The slowest was the MXJDBC driver. This was > consistant after the first run. Yes, I was a little surprised by this - I think it's a case of YMMV. Hope that helps? "I can smell your brains!" -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
structFindValue document bug or CFMX bug?
>From reading the CFMX documentation (CFMX CFML reference book) I'm under the impression that the structFindValue function takes either a structure or an array from which to start the search. Pg. 631 - Parameter: Top, Description: ColdFusion object (a structure or an array) from which to start search. But trying to search an array produces the following error: You have attempted to dereference a scalar variable of type class coldfusion.runtime.Array as a structure with members. So who's bad is it?? chris kief ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: ActivePDF (web grabber) and CFMX does not work.
I have used the ActivePDF Toolkit w/ CFMX without any problems at all. I don't know about the rest of the other ActivePDF products, though. At 05:53 PM 11/5/2002 -0500, you wrote: >Last I check ActivePDF used a COM object. CFMX doesn't jive well with >COM NEmore. I talked to the activePDF guys at devCon and they said we're >your best bet is to setup a separate server with CF5. They didn't really >seem like they were even planning on resolving the issues. > >You know there are a bunch of free Java classes for PDF creation. > >Adam Wayne Lehman >Web Systems Developer >Johns Hopkins Bloomberg School of Public Health >Distance Education Division > > >-Original Message- >From: Adam Reynolds [mailto:adam@;craze.co.uk] >Sent: Tuesday, November 05, 2002 5:27 PM >To: CF-Talk >Subject: ActivePDF (web grabber) and CFMX does not work. > >I'm using the examples provided by ActivePDF for the web grabber >product. > >The example does not work under CF MX which seems very weird to me. > >Has anybody else come across this? > >Here's the link to their sample code: >http://www.activepdf.com/en/Support/Example14.asp > >Any help would be appreciated. > >Adam > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Flash reload
oops. for some reason i thought you were using Flash 5, but alas, you are using Flash 6. So, you can use named anchors to bookmark, or navigate to certain sections of your flash movie. unfortunately, we don't have much info on this on the DesDev center (i am looking into that), but it is discussed in the Flash help files Using Flash > anchors, named here is the only info i could find about them on our site: http://www.macromedia.com/support/flash/ts/documents/named_anchors.htm here is an alternate technique that is a little more difficult to implement but works better: http://www.macromedia.com/desdev/mx/blueprint/articles/back_button.html this technique was used in the pet market blueprint application. hope that helps... mike chambers [EMAIL PROTECTED] > -Original Message- > From: Mike Chambers [mailto:mchamber@;macromedia.com] > Sent: Tuesday, November 05, 2002 1:10 PM > To: CF-Talk > Subject: RE: Flash reload > Importance: High > > > fyi, Flash 6 has support for named anchors, which in the case below > could address your problem. > > basically, named anchors allow you to book mark or navigate > to specific > sections of a flash movie. > > since you are using Flash 5 though, this won't help you much. > There are > solutions, but they are mostly on the advanced level. > > mike chambers > > [EMAIL PROTECTED] > > > -Original Message- > > From: Robertson-Ravo, Neil (REC) > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > Sent: Tuesday, November 05, 2002 8:51 AM > > To: CF-Talk > > Subject: RE: Flash reload > > Importance: High > > > > > > Yep, I thought this was the case and actually, in my opinion > > this is still a > > HUGE flaw in a Flash movie. I will look into this, but I can > > say that if > > its an arse to implement, I wont be doing it! > > > > N > > > > -Original Message- > > From: dennis baldwin [mailto:dennis@;zapdesigns.com] > > Sent: 05 November 2002 13:47 > > To: CF-Talk > > Subject: RE: Flash reload > > > > > > Hey Neil, > > > > By default the movie will refresh. Here's a basic tutorial > of how to > > get it around it (requires a little more work). I'm not > > saying this is > > the best example of how to accomplish something like this but > > hopefully > > it should spark some ideas. > > > http://www.flashcfm.com/tutorial_search.cfm?> keyword=smart%20navigation > > > > Take care, > > Dennis > > > > -Original Message- > > From: Robertson-Ravo, Neil (REC) > > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > > Sent: Tuesday, November 05, 2002 3:41 AM > > To: CF-Talk > > Subject: Flash reload > > > > > > How has people/MM got around the reloading of a Flash movie when the > > user decides to F5 their browser session? Does it still reload the > > movie from the beginning? > > > > Neil > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Multiple Actions with a Single Form?
"Luke, use the JavaScript" Look at an onClick event in your button input tag to kick of a JavaScript function. In that function you can change the forms action by document.foo.action = "gooey.cfm" Note the form name is goo. Doug >-Original Message- >From: Ben Koshy [mailto:benlist@;w3media.net] >Sent: Tuesday, November 05, 2002 6:29 PM >To: CF-Talk >Subject: Multiple Actions with a Single Form? > > >Has anyone encountered a simple way to have multiple submit >buttons that >post different values of the same variable or action value? > >Here's my code > > > > > >#customerorderid#> > > >style="background-image: url(/images/delete_x.gif);height: 14; width: >25; border: none; "> > > > > > >You can see I have multiple submit buttons assigning the fuseaction >value. Of course this creates really ugly labels. So my solution was >to use style sheets to replace the button altogether. However >the label >still partially shows through on top of the background I specified even >though I have a nice delete_x button made. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Multiple Actions with a Single Form?
Has anyone encountered a simple way to have multiple submit buttons that post different values of the same variable or action value? Here's my code #customerorderid#> You can see I have multiple submit buttons assigning the fuseaction value. Of course this creates really ugly labels. So my solution was to use style sheets to replace the button altogether. However the label still partially shows through on top of the background I specified even though I have a nice delete_x button made. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Indexing strategy
I've created a CF based search engine for our new web site using Verity. The big issue I've encountered is creating and maintaining the index. Without HTML pages there are 795 PDF and Word files (about 98% PDF). I think with HTML pages included the number rises to about 1940 files. I've tried using plain old CFINDEX stuff like UPDATE and REFRESH and I've also had a crack at it with CF_PATHINDEX but at the end of the day it seems a big struggle and invariably the process is not completing. I would have thought that using CF_PATHINDEX it would have worked better because I am able to exclude a lot of the directories and stuff that I don't want indexed and therefore reduce the indexing load. On our soon to be decommissioned FreeBSD/Apache based facility UDM takes 102 seconds. Can anyone suggest any strategies for approaching indexing on this scale. TIA ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Webserver software for NT 4.0
IIS 5 is for Win2000 and AFAIK will not run on NT 4.0. For 'normal' CF apps, I haven't seen any difference betwix IS 4 or IIS 5. >-Original Message- >From: Tim Laureska [mailto:hometeam@;goeaston.net] >Sent: Tuesday, November 05, 2002 6:12 PM >To: CF-Talk >Subject: RE: Webserver software for NT 4.0 > > >Nothings wrong with IIS 4.0 or IIS 5.0... as a matter of fact >I'd rather >use that instead of learning Apache in two days... My web server >experience is limited developing CF with IIS 5.0 or PWS ... is the >upgrade to 5.0 downloadable from the net... I checked Microsoft's site >and didn't see it... or do you have to get it off a W2k server disk ? > >-Original Message- >From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen@;alltel.com] >Sent: Tuesday, November 05, 2002 5:32 PM >To: CF-Talk >Subject: RE: Webserver software for NT 4.0 > >There is IIS4 for NT 4.0...what is wrong with that on an Intranet? You >could use Apache which is free(as in beer). > > >Doug > >>-Original Message- >>From: Tim Laureska [mailto:hometeam@;goeaston.net] >>Sent: Tuesday, November 05, 2002 5:25 PM >>To: CF-Talk >>Subject: SOT: Webserver software for NT 4.0 >> >> >>Hello. I have a client who wants to set up a small intranet with a NT >>4.0 server (for future CF apps). I'm looking for recommendations for >>good cheap webserver software for NT 4.0 other than the built in IIS >>3.0.. any downloadables (upgrades or otherwise) free from Microsoft or >>elsewhere would obviously be great :-) >> >>Tim Laureska >>1st-String Technolgies >>443-496-1261 >> >> >> >> >> > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Webserver software for NT 4.0
Nothings wrong with IIS 4.0 or IIS 5.0... as a matter of fact I'd rather use that instead of learning Apache in two days... My web server experience is limited developing CF with IIS 5.0 or PWS ... is the upgrade to 5.0 downloadable from the net... I checked Microsoft's site and didn't see it... or do you have to get it off a W2k server disk ? -Original Message- From: [EMAIL PROTECTED] [mailto:Douglas.Knudsen@;alltel.com] Sent: Tuesday, November 05, 2002 5:32 PM To: CF-Talk Subject: RE: Webserver software for NT 4.0 There is IIS4 for NT 4.0...what is wrong with that on an Intranet? You could use Apache which is free(as in beer). Doug >-Original Message- >From: Tim Laureska [mailto:hometeam@;goeaston.net] >Sent: Tuesday, November 05, 2002 5:25 PM >To: CF-Talk >Subject: SOT: Webserver software for NT 4.0 > > >Hello. I have a client who wants to set up a small intranet with a NT >4.0 server (for future CF apps). I'm looking for recommendations for >good cheap webserver software for NT 4.0 other than the built in IIS >3.0.. any downloadables (upgrades or otherwise) free from Microsoft or >elsewhere would obviously be great :-) > >Tim Laureska >1st-String Technolgies >443-496-1261 > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Sanitize - Prevent SQL Injection
Thanks to everybody who answered. I think the problem with searching is that sometimes you need to know the answer before you can ask the question. I've used CFQUERYPARAM... but I didn't know that may be one of the reasons 'TO' use it. I learn something every day. Thanks again. -- Jillian -Original Message- From: Bryan Stevenson [mailto:bryan@;electricedgesystems.com] Sent: Tuesday, November 05, 2002 4:48 PM To: CF-Talk Subject: Re: Sanitize - Prevent SQL Injection Well...search the CF-Talk archivesthis has been beaten to death ;-) There are all kinds of theories/etc. but take a look at CFQUERYPARAM...it takes care of a whole lot of potential problems. HTH 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: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 2:29 PM Subject: Sanitize - Prevent SQL Injection > This may seem like a novice question... but is there a need/procedure for > sanitizing data in CF to prevent SQL injection? > > I've searched everywhere and I can't find any information on this. > > -- > Jillian > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Question about Oracle JDBC drivers on MX
Hi All, I was wondering if anyone could explain to me the difference between the Oracle JDBC drivers. I was looking thru some old postings and I noticed a post about Oracle drivers: OCI and Thin Client and the MX Driver. Is there a major difference between the three. I am currently in the testing some of my apps in MX and I was just wondering if I should use the supplied driver or try to install Oracle's instead. I believe that the Oracle Drivers need to be downloaded from Oracle and installed on the server. Any help would be appreciated. This is part of the thread that I was looking at: But look at the second run. The second run and other runs to the database were consisted. The jdbc:oracle:thin driver was always the fastest followed by the jdbc:oracle:oci driver. The slowest was the MXJDBC driver. This was consistant after the first run. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: ActivePDF (web grabber) and CFMX does not work.
Last I check ActivePDF used a COM object. CFMX doesn't jive well with COM NEmore. I talked to the activePDF guys at devCon and they said we're your best bet is to setup a separate server with CF5. They didn't really seem like they were even planning on resolving the issues. You know there are a bunch of free Java classes for PDF creation. Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Adam Reynolds [mailto:adam@;craze.co.uk] Sent: Tuesday, November 05, 2002 5:27 PM To: CF-Talk Subject: ActivePDF (web grabber) and CFMX does not work. I'm using the examples provided by ActivePDF for the web grabber product. The example does not work under CF MX which seems very weird to me. Has anybody else come across this? Here's the link to their sample code: http://www.activepdf.com/en/Support/Example14.asp Any help would be appreciated. Adam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Sanitize - Prevent SQL Injection
Well...search the CF-Talk archivesthis has been beaten to death ;-) There are all kinds of theories/etc. but take a look at CFQUERYPARAM...it takes care of a whole lot of potential problems. HTH 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: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 2:29 PM Subject: Sanitize - Prevent SQL Injection > This may seem like a novice question... but is there a need/procedure for > sanitizing data in CF to prevent SQL injection? > > I've searched everywhere and I can't find any information on this. > > -- > Jillian > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Sanitize - Prevent SQL Injection
Jillian, 2 methods are available. One is a Regex that's applied to any variable going into a query (also some easy things like using "val()" around an int). The other is using . Of the 2 mailto:jillian@;koskie.com] Sent: Tuesday, November 05, 2002 4:30 PM To: CF-Talk Subject: Sanitize - Prevent SQL Injection This may seem like a novice question... but is there a need/procedure for sanitizing data in CF to prevent SQL injection? I've searched everywhere and I can't find any information on this. -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Sanitize - Prevent SQL Injection
Oh my yes... Look at the CodeCleaner custom tag in the dev exchange. And learn all about CFQUERYPARAM and use it *everywhere* (not just WHERE statements). Thats a good start. --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com - Retail --- -- Original Message -- from: "Jillian Carroll" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Tue, 5 Nov 2002 16:29:59 -0600 >This may seem like a novice question... but is there a need/procedure for >sanitizing data in CF to prevent SQL injection? > >I've searched everywhere and I can't find any information on this. > >-- >Jillian > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Webserver software for NT 4.0
IIS is free ... and since you are on an intranet it's presumable that security - or whatever other issues you may have with IIS - are less important. Is that not the case? P.S. you can upgrade to IIS 5.0 -Original Message- From: Tim Laureska [mailto:hometeam@;goeaston.net] Sent: Tuesday, November 05, 2002 4:25 PM To: CF-Talk Subject: SOT: Webserver software for NT 4.0 Hello. I have a client who wants to set up a small intranet with a NT 4.0 server (for future CF apps). I'm looking for recommendations for good cheap webserver software for NT 4.0 other than the built in IIS 3.0.. any downloadables (upgrades or otherwise) free from Microsoft or elsewhere would obviously be great :-) Tim Laureska 1st-String Technolgies 443-496-1261 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Sanitize - Prevent SQL Injection
http://www.macromedia.com/desdev/articles/ben_forta_faster.html > -Original Message- > From: Jillian Carroll [mailto:jillian@;koskie.com] > Sent: Tuesday, November 05, 2002 5:30 PM > To: CF-Talk > Subject: Sanitize - Prevent SQL Injection > > > This may seem like a novice question... but is there a > need/procedure for > sanitizing data in CF to prevent SQL injection? > > I've searched everywhere and I can't find any information on this. > > -- > Jillian > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Webserver software for NT 4.0
Apache is compatible with NT4. www.apache.org. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "Tim Laureska" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 05, 2002 5:24 PM Subject: SOT: Webserver software for NT 4.0 > Hello. I have a client who wants to set up a small intranet with a NT > 4.0 server (for future CF apps). I'm looking for recommendations for > good cheap webserver software for NT 4.0 other than the built in IIS > 3.0.. any downloadables (upgrades or otherwise) free from Microsoft or > elsewhere would obviously be great :-) > > Tim Laureska > 1st-String Technolgies > 443-496-1261 > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Webserver software for NT 4.0
There is IIS4 for NT 4.0...what is wrong with that on an Intranet? You could use Apache which is free(as in beer). Doug >-Original Message- >From: Tim Laureska [mailto:hometeam@;goeaston.net] >Sent: Tuesday, November 05, 2002 5:25 PM >To: CF-Talk >Subject: SOT: Webserver software for NT 4.0 > > >Hello. I have a client who wants to set up a small intranet with a NT >4.0 server (for future CF apps). I'm looking for recommendations for >good cheap webserver software for NT 4.0 other than the built in IIS >3.0.. any downloadables (upgrades or otherwise) free from Microsoft or >elsewhere would obviously be great :-) > >Tim Laureska >1st-String Technolgies >443-496-1261 > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Sanitize - Prevent SQL Injection
This may seem like a novice question... but is there a need/procedure for sanitizing data in CF to prevent SQL injection? I've searched everywhere and I can't find any information on this. -- Jillian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
ActivePDF (web grabber) and CFMX does not work.
I'm using the examples provided by ActivePDF for the web grabber product. The example does not work under CF MX which seems very weird to me. Has anybody else come across this? Here's the link to their sample code: http://www.activepdf.com/en/Support/Example14.asp Any help would be appreciated. Adam ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
SOT: Webserver software for NT 4.0
Hello. I have a client who wants to set up a small intranet with a NT 4.0 server (for future CF apps). I'm looking for recommendations for good cheap webserver software for NT 4.0 other than the built in IIS 3.0.. any downloadables (upgrades or otherwise) free from Microsoft or elsewhere would obviously be great :-) Tim Laureska 1st-String Technolgies 443-496-1261 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: IIS & MX (Setup)
Yeap, it's in the documentation. If you installed in the default location, you'll find that at: C:\CFusionMX\wwwroot\cfdocs\Installing_ColdFusion_MX\contents.htm Choose Chapter 2, Configuring your System. Then it's easy to find from there, configuring for IIS. It's pretty straight forward. Vernon Viehe ColdFusion Community Manager Macromedia, Inc. Macromedia Certified Professional CF Blog: http://vvmx.blogspot.com > -Original Message- > From: W Luke [mailto:will@;lukrative.com] > Sent: Tuesday, November 05, 2002 2:01 PM > To: CF-Talk > Subject: IIS & MX (Setup) > > > Hi. > > In CF4.x I was able to "manually" setup IIS (Win2k) to > recognise .cfm templates and ask CF to process them (by > directing it to the correct DLL). (I only needed to do this > when IIS was removed or changed, or had to be re-configured) > > I originally installed MX under its own web-server & port, as > IIS wasn't installed. Now that IIS has been installed, do I > need to install MX again in order to map everything over to > IIS, or can I do it manually ala CF4.x? > > Cheers > > Will > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: initial heap stack for the JVM in MX
cfmxinstall\runtime\bin\jvm.config === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: [EMAIL PROTECTED] [mailto:RBickham@;simplot.com] > Sent: Tuesday, November 05, 2002 5:04 PM > To: CF-Talk > Subject: initial heap stack for the JVM in MX > > > I messed up and set the initial heap stack too high in CFMX. > Not the java > server won't start up. Does anyone know where the heap stack > variable are > stored so that I can manually go in and set the value to a > lower amount? I > can't do this in the admin tool because CF won't start up. > Any help would > be greatly appreciated. > > Thanks, > Randy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re:_CFFAQ_Preventing_the_"Page_Expired"_message_in_a_browser
>> I'm trying to auto refresh a page when the back button is >> clicked on the browser. At present the page that I'm going >> back to is an page which requires form variables from a >> previous page to run - if I hit back I get the usual >> "Page Expired" message > > There's not really any way to change this behavior without > changing the form's method from "post" to "get" which will > cause all the form fields to be passed in the url instead. > > S. Isaac Dealey > Certified Advanced ColdFusion 5 Developer > > www.turnkey.to > 954-776-0046 .. Wasn't this from a long time ago? In retrospect I think it might be possible to maintain the form method="post" and eliminate the alert by using something like this: Off-hand I'm not sure what other issues this might introduce however... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL Statement
Joel, It works for access and MS SQL... hmmm... have you made sure your "where" clause is finding a row or rows to update? that "daily_date" might be a problem. What happens when you run the query directly from the command line for MySQL? -mk -Original Message- From: Joel Blanchette [mailto:cftalk@;pointofimpact.com] Sent: Tuesday, November 05, 2002 3:48 PM To: CF-Talk Subject: RE: SQL Statement Tried that and all that happens is that the number stays at 0. When that query is initialized, the column Raw_Hits and Unique_Hits already has a value as Integer in a MYSQL Database. Is there another way of doing this? All I need to do is add one to the columns. == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Tuesday, November 05, 2002 2:21 PM To: CF-Talk Subject: RE: SQL Statement Joel, Put the column first in a math operation: UPDATE Statistic_Results#YearMonth# SET Raw_Hits = Raw_Hits + 1, Unique_Hits = Unique_Hits + 1 WHERE Domain_ID = '#DomainNameID#' AND Daily_Date = '#TodayDate#' Assuming they are both int or numeric types - this will work. -mk -Original Message- From: Joel Blanchette [mailto:cftalk@;pointofimpact.com] Sent: Tuesday, November 05, 2002 2:09 PM To: CF-Talk Subject: SQL Statement I have this VB SQL Statement and I need to change it to cf mysql UPDATE Statistic_Results#YearMonth# SET Raw_Hits = 1 + Raw_Hits, Unique_Hits = 1 + Unique_Hits WHERE Domain_ID = '#DomainNameID#' AND Daily_Date = '#TodayDate#' The problem lies when I do the column + 1. Is there an easy way of doing this without doing a new cfquery? == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
IIS & MX (Setup)
Hi. In CF4.x I was able to "manually" setup IIS (Win2k) to recognise .cfm templates and ask CF to process them (by directing it to the correct DLL). (I only needed to do this when IIS was removed or changed, or had to be re-configured) I originally installed MX under its own web-server & port, as IIS wasn't installed. Now that IIS has been installed, do I need to install MX again in order to map everything over to IIS, or can I do it manually ala CF4.x? Cheers Will ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
initial heap stack for the JVM in MX
I messed up and set the initial heap stack too high in CFMX. Not the java server won't start up. Does anyone know where the heap stack variable are stored so that I can manually go in and set the value to a lower amount? I can't do this in the admin tool because CF won't start up. Any help would be greatly appreciated. Thanks, Randy --- Randy Bickham Web Software Developer J.R. Simplot Company [EMAIL PROTECTED]
RE: Resizing images under Linux
My research with the ImageJ library: http://www.web-rat.com/mt2/mt-search.cgi?IncludeBlogs=2&search=image+j Ben Hediard pointed imageJ out to me ages ago - http://rsb.info.nih.gov/ij/index.html ~Todd On Tue, 5 Nov 2002, Kevin Graeme wrote: > I read that article before, and it looks to me that the huge downside of JAI > is the lack of GIF support. > > "it can write BMP, JPG, TIF, PNG, but if you must write GIF files, then youÂ’ > ll have to find another implementation (note that the PNG file format is an > acceptable substitute for GIF file format)." > > I would love it if PNG were an acceptable substitute, but it's > implementation in browsers seems worse than CSS. > > -Kevin > > > -Original Message- > > From: Sean A Corfield [mailto:sean@;corfield.org] > > Sent: Tuesday, November 05, 2002 1:47 PM > > To: CF-Talk > > Subject: Re: Resizing images under Linux > > > > > > Check out JAI - the Java image library. Matt Liotta wrote an article on > > this for the DesDev Center recently... *searches* > > > > http://www.macromedia.com/desdev/mx/coldfusion/articles/jai_images.html > > > > That Java code should be callable from CF5. > > > > On Tuesday, Nov 5, 2002, at 11:30 US/Pacific, Rick Root wrote: > > > > > Nope, requires windows... and as I said I'm using Linux. > > > > > > I'm researching the GD library which would allow me to write a perl > > > script and call that via CFEXECUTE... but I'd much rather find an > > > existing solution :) > > > > > > - Rick > > > > > > Ryan Farrell wrote: > > >> We are working with something called AutoImager. Our particular > > >> solution > > >> requires that we resize images and create thumbnails in a nightly > > >> batch, but > > >> the program may be able to meet your requirements. Check it out at > > >> http://www.mystikmedia.com/autoimager.asp. > > > > "I can smell your brains!" > > -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: appending to a list>
Also, with the code you sent to the list, if both qAwards.Photo and qAwards.Photo2 exist, the list will only contain the value of qAwards.Photo2. That's because both if ListAppends append the value to Temp. You might instead do something like: #temp -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Bosky, Dave [mailto:Dave.Bosky@;htcinc.net] > Sent: Tuesday, November 05, 2002 4:11 PM > To: CF-Talk > Subject: RE: appending to a list> > > > Everytime I post a question the answer seems to come to me the > second after > hitting send. > > Thanks, > Dave > > > -Original Message- > From: Randell B Adkins [mailto:AdkinsR@;GAO.GOV] > Sent: Tuesday, November 05, 2002 3:54 PM > To: CF-Talk > Subject: Re: appending to a list> > > > Output Temp2 and see what you get > > >>> [EMAIL PROTECTED] 11/05/02 03:36PM >>> > Can someone tell me why the code below refuses to create a list? Both > items > do exist. > I can print out each individual item but when I try to add each item to > the > list they never get appended. > > > >"'"&CLIENT.root&"contentphotos\"&qAwards.Photo&"'"> > > > >"'"&CLIENT.root&"contentphotos\"&qAwards.Photo2&"'"> > > > > Dave > > > HTC Disclaimer: The information contained in this message may be > privileged and confidential and protected from disclosure. If the reader > of this message is not the intended recipient, or an employee or agent > responsible for delivering this message to the intended recipient, you > are hereby notified that any dissemination, distribution or copying of > this communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Resizing images under Linux
I read that article before, and it looks to me that the huge downside of JAI is the lack of GIF support. "it can write BMP, JPG, TIF, PNG, but if you must write GIF files, then youÂ’ ll have to find another implementation (note that the PNG file format is an acceptable substitute for GIF file format)." I would love it if PNG were an acceptable substitute, but it's implementation in browsers seems worse than CSS. -Kevin > -Original Message- > From: Sean A Corfield [mailto:sean@;corfield.org] > Sent: Tuesday, November 05, 2002 1:47 PM > To: CF-Talk > Subject: Re: Resizing images under Linux > > > Check out JAI - the Java image library. Matt Liotta wrote an article on > this for the DesDev Center recently... *searches* > > http://www.macromedia.com/desdev/mx/coldfusion/articles/jai_images.html > > That Java code should be callable from CF5. > > On Tuesday, Nov 5, 2002, at 11:30 US/Pacific, Rick Root wrote: > > > Nope, requires windows... and as I said I'm using Linux. > > > > I'm researching the GD library which would allow me to write a perl > > script and call that via CFEXECUTE... but I'd much rather find an > > existing solution :) > > > > - Rick > > > > Ryan Farrell wrote: > >> We are working with something called AutoImager. Our particular > >> solution > >> requires that we resize images and create thumbnails in a nightly > >> batch, but > >> the program may be able to meet your requirements. Check it out at > >> http://www.mystikmedia.com/autoimager.asp. > > "I can smell your brains!" > -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Match text and display to template
Just use "AND," not "AND WHERE." For example: SELECT * FROMprofiles WHERE strUsername = '#auth#' AND strSelect = 'D:\test' This will return only those records where strSelect EXACTLY matches "D:\test." If a record contains "D:\test\someValue" it will NOT be returned. If you want to find anything that contains that value, use the LIKE operator with the "%" wildcard as in: strSelect LIKE '%D:\test%' -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: FlashGuy [mailto:flashmx@;rogers.com] > Sent: Tuesday, November 05, 2002 8:09 AM > To: CF-Talk > Subject: Match text and display to template > > > Hi, > > Is there a way to do the following with a query. I'm running CF > and MySQL. I want to display from the field "strSelect" when I > get a match on "d:\test" only even though the > field could contain "d:\mywork" and "d:\documents" Presently I'm > displaying *everything* from the strSelect field. > > Here is my query: > > > SELECT * > FROMprofiles > WHERE strUsername = '#auth#' > > > > Can I do something like: > > > SELECT * > FROMprofiles > WHERE strUsername = '#auth#' > AND > WHEREstrSelect = 'D:\test' > > > The idea here is to match/list only the occurences with "d:\test" > in the field? > > > > > > --- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --- > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: SQL Statement
Tried that and all that happens is that the number stays at 0. When that query is initialized, the column Raw_Hits and Unique_Hits already has a value as Integer in a MYSQL Database. Is there another way of doing this? All I need to do is add one to the columns. == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com] Sent: Tuesday, November 05, 2002 2:21 PM To: CF-Talk Subject: RE: SQL Statement Joel, Put the column first in a math operation: UPDATE Statistic_Results#YearMonth# SET Raw_Hits = Raw_Hits + 1, Unique_Hits = Unique_Hits + 1 WHERE Domain_ID = '#DomainNameID#' AND Daily_Date = '#TodayDate#' Assuming they are both int or numeric types - this will work. -mk -Original Message- From: Joel Blanchette [mailto:cftalk@;pointofimpact.com] Sent: Tuesday, November 05, 2002 2:09 PM To: CF-Talk Subject: SQL Statement I have this VB SQL Statement and I need to change it to cf mysql UPDATE Statistic_Results#YearMonth# SET Raw_Hits = 1 + Raw_Hits, Unique_Hits = 1 + Unique_Hits WHERE Domain_ID = '#DomainNameID#' AND Daily_Date = '#TodayDate#' The problem lies when I do the column + 1. Is there an easy way of doing this without doing a new cfquery? == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
CFFAQ Preventing the "Page Expired" message in a browser
> I'm trying to auto refresh a page when the back button is clicked on the > browser. At present the page that I'm going back to is an page which > requires form variables from a previous page to run - if I hit back I get > the usual "Page Expired" message There's not really any way to change this behavior without changing the form's method from "post" to "get" which will cause all the form fields to be passed in the url instead. S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: best practices for multi developer development of a large flash mx/ cf mx app
Movie Clips are easy to cut and paste and /or include across a major or multiple fla's through shared libraries. Additionally with the load Movie - and for bandwith issues - developing pieces (sep flas)with specific specs, size, fonts etc - will help. You can load in compiled swf's or share the .fla's and do the shared libary and MC thing - and compile all into one fla - But point is - pieces are a defiante advantage. - On the cf side- exactly what someone else said - includes. - they are similair to MC's in the way that they are functions that are seperate so they do not have to be re-written and can be reused and plugged into the bigger picture. Same thing with Director development - We on a major CD - it is great we can make heavy changes to one section while not even touching the main navigation. jay miller Josh Trefethen wrote: >Just a quick request for some guidance if any of you have done this >before... > >I am working with a team on a fairly large project which the majority of >development will be in flash mx. What are the best practices for >multi-developer projects in flash? > >Do we build one fla or several flash files and then integrate? How does >that work with flash? > >Any ideas would be greatly appreciated! > >Thanks, > >Josh Trefethen >http://exciteworks.com > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Resizing images under Linux
Rick Root wrote: > Nope, requires windows... and as I said I'm using Linux. > > I'm researching the GD library which would allow me to write a perl > script and call that via CFEXECUTE... but I'd much rather find an > existing solution :) There is a CF_ImageMagick tag somewhere... Ahh there it is: http://www.alagad.com/index.cfm/name-products it works on Windows AND Linux, which makes it a nice tool for cross platform development. Jesse ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Verity Head Aches
are you using k2? if so did you update your k2.ini? did you try restarting the services? try dumping it out to see if the contents are good -Original Message- From: Timothy Heald [mailto:healdt@;dsmail.state.gov] Sent: Tuesday, November 05, 2002 2:52 PM To: CF-Talk Subject: Verity Head Aches Hi. I have these verity collections that have 250,000 and 150,000 row queries indexed in each. We just moved them from our personal Win 2K dev box, to our production NT box. Now the search I built for them keeps throwing errors like: Error executing CFSEARCH. Error # -125 [ff83] VdkSessionNew Have any of you seen this before? Any help would be much appreciated. Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: appending to a list>
Everytime I post a question the answer seems to come to me the second after hitting send. Thanks, Dave -Original Message- From: Randell B Adkins [mailto:AdkinsR@;GAO.GOV] Sent: Tuesday, November 05, 2002 3:54 PM To: CF-Talk Subject: Re: appending to a list> Output Temp2 and see what you get >>> [EMAIL PROTECTED] 11/05/02 03:36PM >>> Can someone tell me why the code below refuses to create a list? Both items do exist. I can print out each individual item but when I try to add each item to the list they never get appended. Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: HTML E-mails with CFMAIL
Thx to you both, Cheers, --- Matt Robertson, MSB Designs, Inc. http://mysecretbase.com --- -- Original Message -- from: Jochem van Dieten <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Tue, 05 Nov 2002 22:03:49 +0100 >S. Isaac Dealey wrote: > >> No it's not a requirement -- I found an article that mentioned that >> they tend to just use #createuuid()# by itself for the boundary. I >> left the prefix "=_NextPart_." in just because I've seen it used and >> figured it couldn't hurt -- the purpose of using a uuid() is to make >> the boundary string unique, because you could just as well use >> "nextpart" by itself as the boundary, however, if by random chance, >> someone types "--nextpart" into an email this might cause a problem. >> The prefix is human readable though it's not very likely to be read by >> a human for any real reason, and the uuid() "ensures" uniqueness. > >The sequence =_ (equals underscore) is such that it can't be present in >many encodings (Base64, quoted printable) and is therefore a good one to >put in a boundary. The rest doesn't matter, although numbering >subsequently based on the nested level of the boundary is easy for >debugging. > >Jochem > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: HTML E-mails with CFMAIL
S. Isaac Dealey wrote: > No it's not a requirement -- I found an article that mentioned that > they tend to just use #createuuid()# by itself for the boundary. I > left the prefix "=_NextPart_." in just because I've seen it used and > figured it couldn't hurt -- the purpose of using a uuid() is to make > the boundary string unique, because you could just as well use > "nextpart" by itself as the boundary, however, if by random chance, > someone types "--nextpart" into an email this might cause a problem. > The prefix is human readable though it's not very likely to be read by > a human for any real reason, and the uuid() "ensures" uniqueness. The sequence =_ (equals underscore) is such that it can't be present in many encodings (Base64, quoted printable) and is therefore a good one to put in a boundary. The rest doesn't matter, although numbering subsequently based on the nested level of the boundary is easy for debugging. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: appending to a list>
Output Temp2 and see what you get >>> [EMAIL PROTECTED] 11/05/02 03:36PM >>> Can someone tell me why the code below refuses to create a list? Both items do exist. I can print out each individual item but when I try to add each item to the list they never get appended. Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: appending to a list>
You are, of course, outputting temp2? You know that listappend returns the new list - it doesn't change the list passed in. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Bosky, Dave [mailto:Dave.Bosky@;htcinc.net] > Sent: Tuesday, November 05, 2002 3:36 PM > To: CF-Talk > Subject: appending to a list> > > > Can someone tell me why the code below refuses to create a > list? Both items > do exist. > I can print out each individual item but when I try to add > each item to the > list they never get appended. > > > >"'"&CLIENT.root&"contentphotos\"&qAwards.Photo&"'"> > > > >"'"&CLIENT.root&"contentphotos\"&qAwards.Photo2&"'"> > > > > Dave > > > HTC Disclaimer: The information contained in this message > may be privileged and confidential and protected from > disclosure. If the reader of this message is not the intended > recipient, or an employee or agent responsible for delivering > this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of > this communication is strictly prohibited. If you have > received this communication in error, please notify us > immediately by replying to the message and deleting it from > your computer. Thank you. > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: best practices for multi developer development of a large fla sh mx/ cf mx app
I'm not an authority on the subject but in general practice I make each application state it's own movieclip...much more convenient when combining it in the end. Also, keep as much code as you can contained in include files...that way they can be checked into a source control management system. HTH Stace -Original Message- From: Josh Trefethen [mailto:jtnewsletters@;exciteworks.com] Sent: Tuesday, November 05, 2002 3:19 PM To: CF-Talk Subject: best practices for multi developer development of a large flash mx/ cf mx app Just a quick request for some guidance if any of you have done this before... I am working with a team on a fairly large project which the majority of development will be in flash mx. What are the best practices for multi-developer projects in flash? Do we build one fla or several flash files and then integrate? How does that work with flash? Any ideas would be greatly appreciated! Thanks, Josh Trefethen http://exciteworks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
appending to a list>
Can someone tell me why the code below refuses to create a list? Both items do exist. I can print out each individual item but when I try to add each item to the list they never get appended. Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Resizing images under Linux
This is what I run on my linux box with cf5: http://www.imagemagick.org/ http://www.alagad.com/index.cfm/name-mtdownload this is the cf custom tag. Works like a charm and is very powerful... FYI: I have this preinstalled and available for anyone with a hosting account on my server. -- Josh Trefethen :[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. ::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::. -Original Message- From: Rick Root [mailto:rroot@;wakeinternet.com] Sent: Tuesday, November 05, 2002 10:30 AM To: CF-Talk Subject: Resizing images under Linux I am running CF5.0 under Linux, and I need to be able to resize images on the fly... Ie, resize the image and cache the thumbnail image so it doesn't have to do it again UNLESS the base image has changed. There is a tag out there that can do this under Windows, but there are two problems: #1 - I can't find it. #2 - I'm using Linux, and unless I'm mistaken, CFX DLL's don't work in Linux (do they?) Thanks Rick Root http://www.wakeinternet.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL Statement
Joel, Put the column first in a math operation: UPDATE Statistic_Results#YearMonth# SET Raw_Hits = Raw_Hits + 1, Unique_Hits = Unique_Hits + 1 WHERE Domain_ID = '#DomainNameID#' AND Daily_Date = '#TodayDate#' Assuming they are both int or numeric types - this will work. -mk -Original Message- From: Joel Blanchette [mailto:cftalk@;pointofimpact.com] Sent: Tuesday, November 05, 2002 2:09 PM To: CF-Talk Subject: SQL Statement I have this VB SQL Statement and I need to change it to cf mysql UPDATE Statistic_Results#YearMonth# SET Raw_Hits = 1 + Raw_Hits, Unique_Hits = 1 + Unique_Hits WHERE Domain_ID = '#DomainNameID#' AND Daily_Date = '#TodayDate#' The problem lies when I do the column + 1. Is there an easy way of doing this without doing a new cfquery? == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
best practices for multi developer development of a large flash mx/ cf mx app
Just a quick request for some guidance if any of you have done this before... I am working with a team on a fairly large project which the majority of development will be in flash mx. What are the best practices for multi-developer projects in flash? Do we build one fla or several flash files and then integrate? How does that work with flash? Any ideas would be greatly appreciated! Thanks, Josh Trefethen http://exciteworks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Resizing images under Linux
IIRC, you can do some GD stuff with PHP... >-Original Message- >From: Rick Root [mailto:rroot@;wakeinternet.com] >Sent: Tuesday, November 05, 2002 2:30 PM >To: CF-Talk >Subject: Re: Resizing images under Linux > > >Nope, requires windows... and as I said I'm using Linux. > >I'm researching the GD library which would allow me to write a perl >script and call that via CFEXECUTE... but I'd much rather find an >existing solution :) > > - Rick > >Ryan Farrell wrote: >> We are working with something called AutoImager. Our >particular solution >> requires that we resize images and create thumbnails in a >nightly batch, but >> the program may be able to meet your requirements. Check it out at >> http://www.mystikmedia.com/autoimager.asp. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
SQL Statement
I have this VB SQL Statement and I need to change it to cf mysql UPDATE Statistic_Results#YearMonth# SET Raw_Hits = 1 + Raw_Hits, Unique_Hits = 1 + Unique_Hits WHERE Domain_ID = '#DomainNameID#' AND Daily_Date = '#TodayDate#' The problem lies when I do the column + 1. Is there an easy way of doing this without doing a new cfquery? == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: HTML E-mails with CFMAIL
> Isaac, > Is there any particular reason you preface the boundary > var with > "=_NextPart_"? That's not something I'm doing. I've > looked at the > gargantuan list of RFC's at http://faqs.org (rotten search > facilities) > and it doesn't appear to be a requirement. I've seen that > used on some > message source I've examined, but that's it. Were you > mimicing > something that worked already (:D) or have a specific > reason for that? > Cheers, > --Matt Robertson-- > MSB Designs, Inc. > http://mysecretbase.com No it's not a requirement -- I found an article that mentioned that they tend to just use #createuuid()# by itself for the boundary. I left the prefix "=_NextPart_." in just because I've seen it used and figured it couldn't hurt -- the purpose of using a uuid() is to make the boundary string unique, because you could just as well use "nextpart" by itself as the boundary, however, if by random chance, someone types "--nextpart" into an email this might cause a problem. The prefix is human readable though it's not very likely to be read by a human for any real reason, and the uuid() "ensures" uniqueness. So yea, I was mimicking something that was already working. :) I think I did that originally because I was looking at the headers on an incoming email that my client recognized as a properly formatted html message. My client doesn't recognize a lot of email that's supposed to be html because it's not properly formatted, like it was intended for Outlook and AOL ( which ignore the standards in favor of forcing html on people ). Unfortunately email standards seem to get the same kind of adherance that html got in the early web days. At least that's what I've heard and I seem to get a lot of improperly formatted spam and some improperly formatted legitimate email from people I know. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: CFML Bug or Not? Anyone know
Eh? Maybe I missed it but his list append is ok... > UCase(Left(count, 1)), " ")#> Of course, he doesn't need the # signs around the end. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Sean A Corfield [mailto:sean@;corfield.org] > Sent: Tuesday, November 05, 2002 2:35 PM > To: CF-Talk > Subject: Re: CFML Bug or Not? Anyone know > > > When you construct the list, you need to quote each item as > you add it > to the list. > > On Tuesday, Nov 5, 2002, at 10:13 US/Pacific, Graham Pearson wrote: > > > I have been writing my own web based calendaring system and > have been > > able > > to duplicate a problem that I have been receiving which I > am unable to > > solve. > > > > Problem is if one of the event administrators add's an > event and it > > happens > > to put in a comma the page breaks with the following error message: > > > > #Left(right(Variables.NewEvent, Variables.EventCount - 2) , 20)# > > Parameter 2 of functio nRight which is now -1 must be a positive > > interger. > > Line 393 colume 68 > > > > Here is the cfloop code where it breaks. Line 388 is the first line > > > > > > > Delimiters="|"> > > > > > > > > > Delimiters=" "> > > > > > UCase(Left(count, 1)), " ")#> > > > #Mid(Variables.Count, 2, #Variables.CountLen - 1)#> > > > > > > > > #Left(Variabels.EventGlance, 2)# - > > #Len(Right(Variables.NewEvent, > > Variables.EventCount - 3), 20)# > > > > > > > > An example would be Http://calendar.zebras.net and viewing > the current > > month. The first event shows 6 - 30pm beofre the 01- Sat > Preparation. > > > > The entire event should be PTO meeting@Columbia, 6:30PM > instead it is > > splitting the event title at the comma. > > > > > > > > Any Ideas > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Verity Head Aches
Hi. I have these verity collections that have 250,000 and 150,000 row queries indexed in each. We just moved them from our personal Win 2K dev box, to our production NT box. Now the search I built for them keeps throwing errors like: Error executing CFSEARCH. Error # -125 [ff83] VdkSessionNew Have any of you seen this before? Any help would be much appreciated. Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Resizing images under Linux
What about this article that Matt Liota posted http://www.macromedia.com/desdev/mx/coldfusion/articles/jai_images.html Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Rick Root [mailto:rroot@;wakeinternet.com] Sent: Tuesday, November 05, 2002 2:30 PM To: CF-Talk Subject: Re: Resizing images under Linux Nope, requires windows... and as I said I'm using Linux. I'm researching the GD library which would allow me to write a perl script and call that via CFEXECUTE... but I'd much rather find an existing solution :) - Rick Ryan Farrell wrote: > We are working with something called AutoImager. Our particular > solution requires that we resize images and create thumbnails in a > nightly batch, but the program may be able to meet your requirements. > Check it out at http://www.mystikmedia.com/autoimager.asp. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Join the next phase of the CFMX for J2EE beta program
Hello. The ColdFusion team is looking for developers to participate in the beta testing of the latest version of ColdFusion MX for J2EE. This product is a J2EE application that enables developers to build and deploy CFML applications on top of their Java application server. During this phase of the beta program, we are adding support for additional application servers and platforms. Specifically, we are testing ColdFusion MX on the following configurations: * Sun ONE Application Server version 7 on Windows and Solaris * BEA WebLogic version 7 on Windows, Linux, and Solaris * IBM WebSphere version 5 on Windows, Linux, Solaris, and AIX 5L * IBM WebSphere version 4 on AIX 5L In return for access to the beta program, we ask that participants follow the installation instructions, test with the included sample applications, migrate at least one simple application to run on their server, and report back to Macromedia on success or any issues encountered. If you are interested in participating, please register for the beta program today. Register for the CFMX for IBM WebSphere beta: http://betaprograms.macromedia.com/j2eews Register for the CFMX for Sun ONE beta: http://betaprograms.macromedia.com/j2eesone Register for the CFMX for BEA WebLogic beta: http://betaprograms.macromedia.com/j2eebea Please direct any questions regarding the beta program to: [EMAIL PROTECTED] For addition information about ColdFusion MX for J2EE, see http://www.macromedia.com/software/coldfusion/j2ee/ Regards, Phil Costa Sr. Product Manager, ColdFusion Macromedia [EMAIL PROTECTED] PLEASE NOTE: All statements about future platform support represent tentative plans and are subject to change. Any information contained in this email about future releases should be considered confidential and should not be shared with others outside of Macromedia. Failure to comply with this request will result in removal from the beta program. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Resizing images under Linux
Check out JAI - the Java image library. Matt Liotta wrote an article on this for the DesDev Center recently... *searches* http://www.macromedia.com/desdev/mx/coldfusion/articles/jai_images.html That Java code should be callable from CF5. On Tuesday, Nov 5, 2002, at 11:30 US/Pacific, Rick Root wrote: > Nope, requires windows... and as I said I'm using Linux. > > I'm researching the GD library which would allow me to write a perl > script and call that via CFEXECUTE... but I'd much rather find an > existing solution :) > > - Rick > > Ryan Farrell wrote: >> We are working with something called AutoImager. Our particular >> solution >> requires that we resize images and create thumbnails in a nightly >> batch, but >> the program may be able to meet your requirements. Check it out at >> http://www.mystikmedia.com/autoimager.asp. "I can smell your brains!" -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Deleting duplicate values in list
On Tuesday, Nov 5, 2002, at 10:57 US/Pacific, Randell B Adkins wrote: > > > > > > > > Beware of how many comparisons (and list operations in general!) this does! Assume n unique items and it works like this: n compares 1 1 (against an empty list) 2 2 (1 against an empty list, 1 against a list with 1 elem) 3 4 4 7 5 11 6 16 7 22 8 29 9 37 10 46 "I can smell your brains!" -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Query Help
Works great! Thanks. Thanks, Mark -Original Message- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Tuesday, November 05, 2002 1:58 PM To: CF-Talk Subject: RE: Query Help Try ordering by date descending and limiting to five rows. SELECT eID, city, state, country, datestamp ORDER BY datestamp DESC > -Original Message- > From: Mark Leder [mailto:mel@;markleder.com] > Sent: Tuesday, November 05, 2002 1:42 PM > To: CF-Talk > Subject: Query Help > > > Hi All, > > In a query, pulled from MS Access, I want to retrieve the five most > recent postings (they are datestamped when inputted). I know how to > do this in SQL, using top, but I can't figure out in Access. > > >SELECT eID, city, state, country, datestamp >WHERE datestamp = [five most recent] > > > Thanks, > Mark > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CFML Bug or Not? Anyone know
When you construct the list, you need to quote each item as you add it to the list. On Tuesday, Nov 5, 2002, at 10:13 US/Pacific, Graham Pearson wrote: > I have been writing my own web based calendaring system and have been > able > to duplicate a problem that I have been receiving which I am unable to > solve. > > Problem is if one of the event administrators add's an event and it > happens > to put in a comma the page breaks with the following error message: > > #Left(right(Variables.NewEvent, Variables.EventCount - 2) , 20)# > Parameter 2 of functio nRight which is now -1 must be a positive > interger. > Line 393 colume 68 > > Here is the cfloop code where it breaks. Line 388 is the first line > > > Delimiters="|"> > > > > Delimiters=" "> > > UCase(Left(count, 1)), " ")#> > #Mid(Variables.Count, 2, #Variables.CountLen - 1)#> > > > > #Left(Variabels.EventGlance, 2)# - > #Len(Right(Variables.NewEvent, > Variables.EventCount - 3), 20)# > > > > An example would be Http://calendar.zebras.net and viewing the current > month. The first event shows 6 - 30pm beofre the 01- Sat Preparation. > > The entire event should be PTO meeting@Columbia, 6:30PM instead it is > splitting the event title at the comma. > > > > Any Ideas > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Resizing images under Linux
Nope, requires windows... and as I said I'm using Linux. I'm researching the GD library which would allow me to write a perl script and call that via CFEXECUTE... but I'd much rather find an existing solution :) - Rick Ryan Farrell wrote: > We are working with something called AutoImager. Our particular solution > requires that we resize images and create thumbnails in a nightly batch, but > the program may be able to meet your requirements. Check it out at > http://www.mystikmedia.com/autoimager.asp. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Dump a SQL table into an Excel spreadsheet
Awesome. Thanks so much for your help! I'm going to dig into Enterprise Manager and get started. Thanks, Dave -Original Message- From: jon hall [mailto:jonhall@;ozline.net] Sent: Tuesday, November 05, 2002 1:22 PM To: CF-Talk Subject: Re: Dump a SQL table into an Excel spreadsheet Well I got code :) You probably will want to read a quick intro to dts somewhere as well. Enterprise Manager (EM) does most of the work though. Run through the export wizard and create the excel spreadsheet you need, and check the checkbox that says "Save DTS Package" or something like that, and give it a name. Now when you go the Data Transformation Services tree in EM you will see the package you saved. If you right click and execute it will create your excel spreadsheet without any input. Now we need a stored procedure that executes this DTS package so that we can use CF to directly execute it. It is possible to use cfexecute to run dtsrun.exe, but there are complex (to me) permission issues involved. Here is an example SP to fire the dts. CREATE PROCEDURE execDTSPackage AS DECLARE @dtscmd varchar(500) SELECT @dtscmd = "exec master..xp_cmdshell 'dtsrun /SServerName /NDTSPackageName /E EXEC(@dtscmd) GO All the SP does it shell out and call dtsrun.exe, the advantage this has over cfexecute is that it will execute dtsrun.exe on the database server instead of the web server, so you can bypass any permission issues. The SP does need to be run as SA though... If you don't need to send any parameters to the DTS package it's one line of CF code to do the export. Something like: If you need to send parameters, perhaps because you need to export a lot of different spreadsheets and can't create a DTS for each, there is a way. You would need to tell the DTS package what piece of data is dynamic and where it is coming from. If you need to do this I can send some code off list. Lots of words for such a quick process, but once you get it down, it really is a piece of cake. -- jon mailto:jonhall@;ozline.net Tuesday, November 5, 2002, 12:25:04 PM, you wrote: BD> Do you happen to have some sample code I could use as a guide. I haven't BD> really done much with DTS. BD> Thanks, BD> Dave BD> -Original Message- BD> From: jon hall [mailto:jonhall@;ozline.net] BD> Sent: Tuesday, November 05, 2002 11:49 AM BD> To: CF-Talk BD> Subject: Re: Dump a SQL table into an Excel spreadsheet BD> If you are familiar with DTS, the easiest way would be to create a dts BD> package and call it from a stored proc on the page to write out the BD> excel file. BD> 15 minutes to get the dts right and 3 lines of cf code to call the sp. BD> I'd really recommend at least trying it this way, dts can be quite BD> rewarding in terms of time saved. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Deleting duplicate values in list
Thanks for the link. ~Jason -Original Message- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Tuesday, November 05, 2002 1:51 PM To: CF-Talk Subject: RE: Deleting duplicate values in list ListDeleteDuplicates(): http://www.cflib.org/udf.cfm?ID=532 ListDeleteDuplicatesNoCase(): http://www.cflib.org/udf.cfm?ID=533 > -Original Message- > From: Dowdell, Jason G [mailto:DowdelJG@;usano.ksc.nasa.gov] > Sent: Tuesday, November 05, 2002 1:35 PM > To: CF-Talk > Subject: Deleting duplicate values in list > > > Hi all, > > Does anyone know of an easy way to delete duplicate > values from a list. > > For example: > > List = "Jason, Jeremy, John, Jason, Jack" > > Corrected_List = "Jason, Jeremy, John, Jack" > > - > Jason Dowdell > IM-AES Web Developer > 321.799.6845 > [EMAIL PROTECTED] > - > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Verity Searches - bug or bad code?
So far 110 records in the search index. If I set the drop down Max Rows for number of records returned to 200, every record (all 110) are listed on * input If I set it for 100, then 100 are returned and the "more" button yields but 1other listing. If I set it for 10, I get 10 files returned on the first page, and "more" yields but one further listing. In other words, on a global * search I get as many records returned in the initial page as number requested in the dropbox, plus 1. This proves true when searching for specific terms as well. Any ideas? rhk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Resizing images under Linux
We are working with something called AutoImager. Our particular solution requires that we resize images and create thumbnails in a nightly batch, but the program may be able to meet your requirements. Check it out at http://www.mystikmedia.com/autoimager.asp. Ryan -Original Message- From: Rick Root [mailto:rroot@;wakeinternet.com] Sent: Tuesday, November 05, 2002 12:30 PM To: CF-Talk Subject: Resizing images under Linux I am running CF5.0 under Linux, and I need to be able to resize images on the fly... Ie, resize the image and cache the thumbnail image so it doesn't have to do it again UNLESS the base image has changed. There is a tag out there that can do this under Windows, but there are two problems: #1 - I can't find it. #2 - I'm using Linux, and unless I'm mistaken, CFX DLL's don't work in Linux (do they?) Thanks Rick Root http://www.wakeinternet.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Query Help
Not sure you can but you might. However instead of the WHERE clause ADD a ORDER BY Clause and have it = DateStamp Then on the OUTPUT QUERY TAG set Maxrows = 5 Sure there maybe another way but that is one. >>> [EMAIL PROTECTED] 11/05/02 01:41PM >>> Hi All, In a query, pulled from MS Access, I want to retrieve the five most recent postings (they are datestamped when inputted). I know how to do this in SQL, using top, but I can't figure out in Access. SELECT eID, city, state, country, datestamp WHERE datestamp = [five most recent] Thanks, Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Query Help
Try ordering by date descending and limiting to five rows. SELECT eID, city, state, country, datestamp ORDER BY datestamp DESC > -Original Message- > From: Mark Leder [mailto:mel@;markleder.com] > Sent: Tuesday, November 05, 2002 1:42 PM > To: CF-Talk > Subject: Query Help > > > Hi All, > > In a query, pulled from MS Access, I want to retrieve the five most > recent postings (they are datestamped when inputted). I know > how to do > this in SQL, using top, but I can't figure out in Access. > > >SELECT eID, city, state, country, datestamp >WHERE datestamp = [five most recent] > > > Thanks, > Mark > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Deleting duplicate values in list
>>> [EMAIL PROTECTED] 11/05/02 01:34PM >>> Hi all, Does anyone know of an easy way to delete duplicate values from a list. For example: List = "Jason, Jeremy, John, Jason, Jack" Corrected_List = "Jason, Jeremy, John, Jack" - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Dump a SQL table into an Excel spreadsheet
With Word, if I am not mistaken, you can just do file - open then in the file dialog type in http://whatever.com/whatever.cfm -Original Message- From: Rick Faircloth [mailto:Rick@;GoLibertyOnline.com] Sent: Tuesday, November 05, 2002 10:30 AM To: CF-Talk Subject: RE: Dump a SQL table into an Excel spreadsheet I've been trying to get Word documents to "automatically grad" data like that, too. Would the same procedure work for Word docs? Rick -Original Message- From: Les Mizzell [mailto:lesmizz@;bellsouth.net] Sent: Tuesday, November 05, 2002 12:51 PM To: CF-Talk Subject: RE: Dump a SQL table into an Excel spreadsheet :> What exactly are Excel web queries? I've heard Its an alternative but :> That's about all I know about it. 1. Open Excel (I'm using Office 2000 here) 2. On the "data" menu and select "Get External Data" 3. Click "New Web Query" 4. Enter the address of the page that generates the data: http://www.mySite.com/EXCELGen.cfm Excel grabs the data from the page and automatically pops it right into a spreadsheet. Easy as pie. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Deleting duplicate values in list
ListDeleteDuplicates(): http://www.cflib.org/udf.cfm?ID=532 ListDeleteDuplicatesNoCase(): http://www.cflib.org/udf.cfm?ID=533 > -Original Message- > From: Dowdell, Jason G [mailto:DowdelJG@;usano.ksc.nasa.gov] > Sent: Tuesday, November 05, 2002 1:35 PM > To: CF-Talk > Subject: Deleting duplicate values in list > > > Hi all, > > Does anyone know of an easy way to delete duplicate > values from a list. > > For example: > > List = "Jason, Jeremy, John, Jason, Jack" > > Corrected_List = "Jason, Jeremy, John, Jack" > > - > Jason Dowdell > IM-AES Web Developer > 321.799.6845 > [EMAIL PROTECTED] > - > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Query Help
Hi All, In a query, pulled from MS Access, I want to retrieve the five most recent postings (they are datestamped when inputted). I know how to do this in SQL, using top, but I can't figure out in Access. SELECT eID, city, state, country, datestamp WHERE datestamp = [five most recent] Thanks, Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Deleting duplicate values in list
Hi all, Does anyone know of an easy way to delete duplicate values from a list. For example: List = "Jason, Jeremy, John, Jason, Jack" Corrected_List = "Jason, Jeremy, John, Jack" - Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] - ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Resizing images under Linux
I am running CF5.0 under Linux, and I need to be able to resize images on the fly... Ie, resize the image and cache the thumbnail image so it doesn't have to do it again UNLESS the base image has changed. There is a tag out there that can do this under Windows, but there are two problems: #1 - I can't find it. #2 - I'm using Linux, and unless I'm mistaken, CFX DLL's don't work in Linux (do they?) Thanks Rick Root http://www.wakeinternet.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Flash reload
On Tuesday, Nov 5, 2002, at 10:06 US/Pacific, Mark A. Kruger - CFG wrote: > Just remember that there is a limitation on the amount of data you can > store > in a shared object. I think it's a 100k without a prompt for user > permission. Yes, and the user can change that setting - to be zero, if they want. By default, it's 100k and that actually goes a long way. I've worked with some fairly LSO-intensive applications and the max I've had in my LSO folder is about 40k. Note that this storage is PER DOMAIN (effectively per website). "I can smell your brains!" -- Mittens the Kitten : http://www.matazone.co.uk/theotherside.html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: Dump a SQL table into an Excel spreadsheet
Well I got code :) You probably will want to read a quick intro to dts somewhere as well. Enterprise Manager (EM) does most of the work though. Run through the export wizard and create the excel spreadsheet you need, and check the checkbox that says "Save DTS Package" or something like that, and give it a name. Now when you go the Data Transformation Services tree in EM you will see the package you saved. If you right click and execute it will create your excel spreadsheet without any input. Now we need a stored procedure that executes this DTS package so that we can use CF to directly execute it. It is possible to use cfexecute to run dtsrun.exe, but there are complex (to me) permission issues involved. Here is an example SP to fire the dts. CREATE PROCEDURE execDTSPackage AS DECLARE @dtscmd varchar(500) SELECT @dtscmd = "exec master..xp_cmdshell 'dtsrun /SServerName /NDTSPackageName /E EXEC(@dtscmd) GO All the SP does it shell out and call dtsrun.exe, the advantage this has over cfexecute is that it will execute dtsrun.exe on the database server instead of the web server, so you can bypass any permission issues. The SP does need to be run as SA though... If you don't need to send any parameters to the DTS package it's one line of CF code to do the export. Something like: If you need to send parameters, perhaps because you need to export a lot of different spreadsheets and can't create a DTS for each, there is a way. You would need to tell the DTS package what piece of data is dynamic and where it is coming from. If you need to do this I can send some code off list. Lots of words for such a quick process, but once you get it down, it really is a piece of cake. -- jon mailto:jonhall@;ozline.net Tuesday, November 5, 2002, 12:25:04 PM, you wrote: BD> Do you happen to have some sample code I could use as a guide. I haven't BD> really done much with DTS. BD> Thanks, BD> Dave BD> -Original Message- BD> From: jon hall [mailto:jonhall@;ozline.net] BD> Sent: Tuesday, November 05, 2002 11:49 AM BD> To: CF-Talk BD> Subject: Re: Dump a SQL table into an Excel spreadsheet BD> If you are familiar with DTS, the easiest way would be to create a dts BD> package and call it from a stored proc on the page to write out the BD> excel file. BD> 15 minutes to get the dts right and 3 lines of cf code to call the sp. BD> I'd really recommend at least trying it this way, dts can be quite BD> rewarding in terms of time saved. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Dump a SQL table into an Excel spreadsheet
I've been trying to get Word documents to "automatically grad" data like that, too. Would the same procedure work for Word docs? Rick -Original Message- From: Les Mizzell [mailto:lesmizz@;bellsouth.net] Sent: Tuesday, November 05, 2002 12:51 PM To: CF-Talk Subject: RE: Dump a SQL table into an Excel spreadsheet :> What exactly are Excel web queries? I've heard Its an alternative but :> That's about all I know about it. 1. Open Excel (I'm using Office 2000 here) 2. On the "data" menu and select "Get External Data" 3. Click "New Web Query" 4. Enter the address of the page that generates the data: http://www.mySite.com/EXCELGen.cfm Excel grabs the data from the page and automatically pops it right into a spreadsheet. Easy as pie. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: duplicate vals written to db
Depending on how you've done your code, a page refresh might be the culprit. Ade -Original Message- From: Nick Varner [mailto:VarnerN@;cookministries.org] Sent: 05 November 2002 18:00 To: CF-Talk Subject: duplicate vals written to db We are having problems with our shopping cart. Somehow the user is getting duplicate line items placed in their cart, it doesn't happen to every line item and it doesn't happen to every user. We have not been able to duplicate this problem, we have also contacted the customers and they don't seem to be doing anything out of the ordinary. In an attempt to find out what the problem is we turned on session scope variable locking in hopes of an error, but no luck. This was not a problem until 3 months ago which leads us to think it is related to an increase in traffic. Has anyone else come across this problem, does anyone have any suggestions for what to look at. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: cffile output including Quotes
Les Mizzell wrote: > Not 100% sure on this: > > Need to generate output like: > > "Les Mizzell","Check Testing Company","100 > MyStreet","MyCity","NC","2","123-45-6789","[EMAIL PROTECTED]",...and > more and more > > inside a cffile tag. Line above contains close to 50 variables > > >FILE="C:\Inetpub\Files\blah...blah. > OUTPUT=" > > "#ck_company#","#ck_company#","#ck_address#","#ck_city#","#ck_state#","#ck_z > ip#","#ck_phone#","#ck_email#",...and more and more > > > But obviously all the quotes and perhaps other special characters in the > output file are gonna screw me up... > > Suggestions please? > > Thanks > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: cffile output including Quotes
Les, Create the variable FIRST using string concatenation or cfsavecontent . If all the text is going to be text qualified, use the "listqualify() function to encase it in quotes after you have created the list. You have to becareful with the commas though they can screw up the number of items in the list. for example: (of course using a loop and listappend looks cleaner) Then... (note the CHAR element tells it to NOT qualify numbers. Sort of standard in a .CSV file format. If I were doing this I would first build the list with piping symbols or asterick (something other than commas), then listqualify, then use changedelimeters to bring it back to commas. The text qualifies will be correctly placed then. -mk -Original Message- From: Les Mizzell [mailto:lesmizz@;bellsouth.net] Sent: Tuesday, November 05, 2002 11:49 AM To: CF-Talk Subject: cffile output including Quotes Not 100% sure on this: Need to generate output like: "Les Mizzell","Check Testing Company","100 MyStreet","MyCity","NC","2","123-45-6789","[EMAIL PROTECTED]",...and more and more inside a cffile tag. Line above contains close to 50 variables http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
CFML Bug or Not? Anyone know
I have been writing my own web based calendaring system and have been able to duplicate a problem that I have been receiving which I am unable to solve. Problem is if one of the event administrators add's an event and it happens to put in a comma the page breaks with the following error message: #Left(right(Variables.NewEvent, Variables.EventCount - 2) , 20)# Parameter 2 of functio nRight which is now -1 must be a positive interger. Line 393 colume 68 Here is the cfloop code where it breaks. Line 388 is the first line #Left(Variabels.EventGlance, 2)# - #Len(Right(Variables.NewEvent, Variables.EventCount - 3), 20)# An example would be Http://calendar.zebras.net and viewing the current month. The first event shows 6 - 30pm beofre the 01- Sat Preparation. The entire event should be PTO meeting@Columbia, 6:30PM instead it is splitting the event title at the comma. Any Ideas ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: duplicate vals written to db
Not sure how your even getting your variables. Check your action page based on what the user clicks. Other than that, without some examples, hard to determine why. >>> [EMAIL PROTECTED] 11/05/02 12:59PM >>> We are having problems with our shopping cart. Somehow the user is getting duplicate line items placed in their cart, it doesn't happen to every line item and it doesn't happen to every user. We have not been able to duplicate this problem, we have also contacted the customers and they don't seem to be doing anything out of the ordinary. In an attempt to find out what the problem is we turned on session scope variable locking in hopes of an error, but no luck. This was not a problem until 3 months ago which leads us to think it is related to an increase in traffic. Has anyone else come across this problem, does anyone have any suggestions for what to look at. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: cffile output including Quotes
Out put all the information to a Variable then output that variable in the CFFILE command. >>> [EMAIL PROTECTED] 11/05/02 12:49PM >>> Not 100% sure on this: Need to generate output like: "Les Mizzell","Check Testing Company","100 MyStreet","MyCity","NC","2","123-45-6789","[EMAIL PROTECTED]",...and more and more inside a cffile tag. Line above contains close to 50 variables http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: duplicate vals written to db
I would suspect user error on this. There are still a lot of people out there that think you need to double-click a link to go to a page/add an item to your cart/view a picture/etc. Most of the time this isn't a problem, but occassionally it is. Same with form buttons. I don't have a solution to suggest at the moment; I just thought you shouldn't discount a PEBKAC error. > -Original Message- > From: Nick Varner [mailto:VarnerN@;cookministries.org] > Sent: Tuesday, November 05, 2002 1:00 PM > To: CF-Talk > Subject: duplicate vals written to db > > > We are having problems with our shopping cart. Somehow the > user is getting > duplicate line items placed in their cart, it doesn't happen > to every line > item and it doesn't happen to every user. We have not been > able to duplicate > this problem, we have also contacted the customers and they > don't seem to be > doing anything out of the ordinary. In an attempt to find out what the > problem is we turned on session scope variable locking in > hopes of an error, > but no luck. This was not a problem until 3 months ago which > leads us to > think it is related to an increase in traffic. Has anyone > else come across > this problem, does anyone have any suggestions for what to look at. > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Flash reload
fyi, Flash 6 has support for named anchors, which in the case below could address your problem. basically, named anchors allow you to book mark or navigate to specific sections of a flash movie. since you are using Flash 5 though, this won't help you much. There are solutions, but they are mostly on the advanced level. mike chambers [EMAIL PROTECTED] > -Original Message- > From: Robertson-Ravo, Neil (REC) > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > Sent: Tuesday, November 05, 2002 8:51 AM > To: CF-Talk > Subject: RE: Flash reload > Importance: High > > > Yep, I thought this was the case and actually, in my opinion > this is still a > HUGE flaw in a Flash movie. I will look into this, but I can > say that if > its an arse to implement, I wont be doing it! > > N > > -Original Message- > From: dennis baldwin [mailto:dennis@;zapdesigns.com] > Sent: 05 November 2002 13:47 > To: CF-Talk > Subject: RE: Flash reload > > > Hey Neil, > > By default the movie will refresh. Here's a basic tutorial of how to > get it around it (requires a little more work). I'm not > saying this is > the best example of how to accomplish something like this but > hopefully > it should spark some ideas. > http://www.flashcfm.com/tutorial_search.cfm?keyword=smart%20navigation > > Take care, > Dennis > > -Original Message- > From: Robertson-Ravo, Neil (REC) > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > Sent: Tuesday, November 05, 2002 3:41 AM > To: CF-Talk > Subject: Flash reload > > > How has people/MM got around the reloading of a Flash movie when the > user decides to F5 their browser session? Does it still reload the > movie from the beginning? > > Neil > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Flash reload
Just remember that there is a limitation on the amount of data you can store in a shared object. I think it's a 100k without a prompt for user permission. Mark A. Kruger, MCSE, CFG www.cfwebtools.com www.necfug.com mxc.blogspot.com ..no more brochures! -Original Message- From: Sean A Corfield [mailto:sean@;corfield.org] Sent: Tuesday, November 05, 2002 11:31 AM To: CF-Talk Subject: Re: Flash reload On Tuesday, Nov 5, 2002, at 01:41 US/Pacific, Robertson-Ravo, Neil (REC) wrote: > How has people/MM got around the reloading of a Flash movie when the > user > decides to F5 their browser session? Does it still reload the movie > from > the beginning? If you want your Flash movie to 'remember' where it was, use Local Shared Objects. This is much the same as using a cookie to allow HTML applications to 'remember' what state they were in. This is something that has really only become possible with Flash MX... Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Dump a SQL table into an Excel spreadsheet
:> What exactly are Excel web queries? I've heard Its an alternative but :> That's about all I know about it. 1. Open Excel (I'm using Office 2000 here) 2. On the "data" menu and select "Get External Data" 3. Click "New Web Query" 4. Enter the address of the page that generates the data: http://www.mySite.com/EXCELGen.cfm Excel grabs the data from the page and automatically pops it right into a spreadsheet. Easy as pie. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
duplicate vals written to db
We are having problems with our shopping cart. Somehow the user is getting duplicate line items placed in their cart, it doesn't happen to every line item and it doesn't happen to every user. We have not been able to duplicate this problem, we have also contacted the customers and they don't seem to be doing anything out of the ordinary. In an attempt to find out what the problem is we turned on session scope variable locking in hopes of an error, but no luck. This was not a problem until 3 months ago which leads us to think it is related to an increase in traffic. Has anyone else come across this problem, does anyone have any suggestions for what to look at. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
cffile output including Quotes
Not 100% sure on this: Need to generate output like: "Les Mizzell","Check Testing Company","100 MyStreet","MyCity","NC","2","123-45-6789","[EMAIL PROTECTED]",...and more and more inside a cffile tag. Line above contains close to 50 variables http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: outputting all client vars
that works randell. Thanks guys will -Original Message- From: Randell B Adkins [mailto:AdkinsR@;GAO.GOV] Sent: 05 November 2002 17:31 To: CF-Talk Subject: RE: outputting all client vars #Evaluate(i)# >>> [EMAIL PROTECTED] 11/05/02 12:22PM >>> thats the one Adrian!! How would I dislay the value of the variables too, as that just gives me the variable names? Thanks a bunch will -Original Message- From: Adrian Lynch [mailto:adrian.l@;thoughtbubble.net] Sent: 05 November 2002 17:09 To: CF-Talk Subject: RE: outputting all client vars I don't think you can view them like that. Try #i# See if that works. Ade -Original Message- From: Will Swain [mailto:will@;hothorse.com] Sent: 05 November 2002 16:57 To: CF-Talk Subject: outputting all client vars Hi all, I've written some basic debug code to output all url, form, and session variables on a page: URL VARS: #URLVar# - #URL[URLVar]# FORM VARS: #FORMVar# - #FORM[FORMVar]# CGI VARS: #CGIVar# - #CGI[CGIVar]# SESSION VARS: #SESSIONVar# - #SESSION[SESSIONVar]# nice and straight forward. BUT, I want the same thing for client variables. However, trying CLIENT VARS: #CLIENTVar# - #CLIENT[CLIENTVar]# just throws up the error: Error Diagnostic Information An error occurred while evaluating the expression: "#CLIENT#" Error near line 37, column 22. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: outputting all client vars
Another way to just see the values for debugging is the output isn't pretty, but it's there. Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP -- Original Message -- From: "Mark Johnson" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 5 Nov 2002 09:37:29 -0800 > > > #i# = #client[i]# > > > >-Original Message- >From: Will Swain [mailto:will@;hothorse.com] >Sent: Tuesday, November 05, 2002 9:23 AM >To: CF-Talk >Subject: RE: outputting all client vars > > >thats the one Adrian!! > >How would I dislay the value of the variables too, as that just gives me the >variable names? > >Thanks a bunch > >will > >-Original Message- >From: Adrian Lynch [mailto:adrian.l@;thoughtbubble.net] >Sent: 05 November 2002 17:09 >To: CF-Talk >Subject: RE: outputting all client vars > > >I don't think you can view them like that. > >Try > > > > #i# > > > > >See if that works. > >Ade > > >-Original Message- >From: Will Swain [mailto:will@;hothorse.com] >Sent: 05 November 2002 16:57 >To: CF-Talk >Subject: outputting all client vars > > >Hi all, > >I've written some basic debug code to output all url, form, and session >variables on a page: > >URL VARS: > > > #URLVar# - #URL[URLVar]# > > >FORM VARS: > > > #FORMVar# - #FORM[FORMVar]# > > >CGI VARS: > > > #CGIVar# - #CGI[CGIVar]# > > >SESSION VARS: > > > #SESSIONVar# - #SESSION[SESSIONVar]# > > >nice and straight forward. BUT, I want the same thing for client variables. >However, trying > >CLIENT VARS: > > > #CLIENTVar# - #CLIENT[CLIENTVar]# > > > >just throws up the error: > >Error Diagnostic Information > >An error occurred while evaluating the expression: > > >"#CLIENT#" > > > >Error near line 37, column 22. > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: outputting all client vars
Try this...
#i#: Evaluate("CLIENT." & #i#)
Ade
-Original Message-
From: Will Swain [mailto:will@;hothorse.com]
Sent: 05 November 2002 17:23
To: CF-Talk
Subject: RE: outputting all client vars
thats the one Adrian!!
How would I dislay the value of the variables too, as that just gives me the
variable names?
Thanks a bunch
will
-Original Message-
From: Adrian Lynch [mailto:adrian.l@;thoughtbubble.net]
Sent: 05 November 2002 17:09
To: CF-Talk
Subject: RE: outputting all client vars
I don't think you can view them like that.
Try
#i#
See if that works.
Ade
-Original Message-
From: Will Swain [mailto:will@;hothorse.com]
Sent: 05 November 2002 16:57
To: CF-Talk
Subject: outputting all client vars
Hi all,
I've written some basic debug code to output all url, form, and session
variables on a page:
URL VARS:
#URLVar# - #URL[URLVar]#
FORM VARS:
#FORMVar# - #FORM[FORMVar]#
CGI VARS:
#CGIVar# - #CGI[CGIVar]#
SESSION VARS:
#SESSIONVar# - #SESSION[SESSIONVar]#
nice and straight forward. BUT, I want the same thing for client variables.
However, trying
CLIENT VARS:
#CLIENTVar# - #CLIENT[CLIENTVar]#
just throws up the error:
Error Diagnostic Information
An error occurred while evaluating the expression:
"#CLIENT#"
Error near line 37, column 22.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Dump a SQL table into an Excel spreadsheet
What exactly are Excel web queries? I've heard Its an alternative but That's about all I know about it. Kola >> -Original Message- >> From: Thane Sherrington [mailto:tsherr@;auracom.com] >> Sent: 05 November 2002 17:14 >> To: CF-Talk >> Subject: RE: Dump a SQL table into an Excel spreadsheet >> >> At 10:59 AM 11/5/02 -0500, Bosky, Dave wrote: >> >I've tried using the web query feature in excel but never works with >> cold >> >fusion pages. >> >Has anyone had any success using the web query feature? >> >> Yes. I've used a fair bit. If you're interested, e-mail me off list and >> I'll send you some sample stuff to play with. >> >> T >> >> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: outputting all client vars
#i# = #client[i]# -Original Message- From: Will Swain [mailto:will@;hothorse.com] Sent: Tuesday, November 05, 2002 9:23 AM To: CF-Talk Subject: RE: outputting all client vars thats the one Adrian!! How would I dislay the value of the variables too, as that just gives me the variable names? Thanks a bunch will -Original Message- From: Adrian Lynch [mailto:adrian.l@;thoughtbubble.net] Sent: 05 November 2002 17:09 To: CF-Talk Subject: RE: outputting all client vars I don't think you can view them like that. Try #i# See if that works. Ade -Original Message- From: Will Swain [mailto:will@;hothorse.com] Sent: 05 November 2002 16:57 To: CF-Talk Subject: outputting all client vars Hi all, I've written some basic debug code to output all url, form, and session variables on a page: URL VARS: #URLVar# - #URL[URLVar]# FORM VARS: #FORMVar# - #FORM[FORMVar]# CGI VARS: #CGIVar# - #CGI[CGIVar]# SESSION VARS: #SESSIONVar# - #SESSION[SESSIONVar]# nice and straight forward. BUT, I want the same thing for client variables. However, trying CLIENT VARS: #CLIENTVar# - #CLIENT[CLIENTVar]# just throws up the error: Error Diagnostic Information An error occurred while evaluating the expression: "#CLIENT#" Error near line 37, column 22. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: outputting all client vars
> How would I dislay the value of the variables too, as that just gives me
the
> variable names?
#i# : #client[i]#
should do it... Must confess I haven't tried it
Otherwise ~shudder~ : evaluate("client."&i)
Regards
Stephen
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Flash reload
On Tuesday, Nov 5, 2002, at 01:41 US/Pacific, Robertson-Ravo, Neil (REC) wrote: > How has people/MM got around the reloading of a Flash movie when the > user > decides to F5 their browser session? Does it still reload the movie > from > the beginning? If you want your Flash movie to 'remember' where it was, use Local Shared Objects. This is much the same as using a cookie to allow HTML applications to 'remember' what state they were in. This is something that has really only become possible with Flash MX... Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: Flash reload
On Tuesday, Nov 5, 2002, at 07:22 US/Pacific, Kevin Graeme wrote: > I was wondering about disabling/remapping the keyboard keys with > JavaScript, > and while most say it can't be done, there was this interesting post I > found. It may not be perfect, but it could be a place to start > fiddling: Having watched a lot of (non-techie) users interacting with websites, I can say that very few of them even know how go back via the keyboard... they nearly always use the mouse to click the back button! "I have always wished that my computer would be as easy to use as my telephone. My wish has come true - I no longer know how to use my telephone." -- Bjarne Stroustrup ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: outputting all client vars
#Evaluate(i)# >>> [EMAIL PROTECTED] 11/05/02 12:22PM >>> thats the one Adrian!! How would I dislay the value of the variables too, as that just gives me the variable names? Thanks a bunch will -Original Message- From: Adrian Lynch [mailto:adrian.l@;thoughtbubble.net] Sent: 05 November 2002 17:09 To: CF-Talk Subject: RE: outputting all client vars I don't think you can view them like that. Try #i# See if that works. Ade -Original Message- From: Will Swain [mailto:will@;hothorse.com] Sent: 05 November 2002 16:57 To: CF-Talk Subject: outputting all client vars Hi all, I've written some basic debug code to output all url, form, and session variables on a page: URL VARS: #URLVar# - #URL[URLVar]# FORM VARS: #FORMVar# - #FORM[FORMVar]# CGI VARS: #CGIVar# - #CGI[CGIVar]# SESSION VARS: #SESSIONVar# - #SESSION[SESSIONVar]# nice and straight forward. BUT, I want the same thing for client variables. However, trying CLIENT VARS: #CLIENTVar# - #CLIENT[CLIENTVar]# just throws up the error: Error Diagnostic Information An error occurred while evaluating the expression: "#CLIENT#" Error near line 37, column 22. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: outputting all client vars
CF5 will -Original Message- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: 05 November 2002 17:18 To: CF-Talk Subject: RE: outputting all client vars What version of CF? > -Original Message- > From: Will Swain [mailto:will@;hothorse.com] > Sent: Tuesday, November 05, 2002 12:14 PM > To: CF-Talk > Subject: RE: outputting all client vars > > > tried that: > > An error occurred while evaluating the expression: > > > "#CLIENT#" > > > > Error near line 36, column 15 > > works for session though. > > Cheers > > will > > -Original Message- > From: Randell B Adkins [mailto:AdkinsR@;GAO.GOV] > Sent: 05 November 2002 17:07 > To: CF-Talk > Subject: Re: outputting all client vars > > > WHy not use CF_Dump var="#client#"> > Alot easier. > > > >>> [EMAIL PROTECTED] 11/05/02 11:56AM >>> > Hi all, > > I've written some basic debug code to output all url, form, and > session > variables on a page: > > URL VARS: > > > #URLVar# - #URL[URLVar]# > > > FORM VARS: > > > #FORMVar# - #FORM[FORMVar]# > > > CGI VARS: > > > #CGIVar# - #CGI[CGIVar]# > > > SESSION VARS: > > > #SESSIONVar# - #SESSION[SESSIONVar]# > > > nice and straight forward. BUT, I want the same thing for client > variables. > However, trying > > CLIENT VARS: > > > #CLIENTVar# - #CLIENT[CLIENTVar]# > > > > just throws up the error: > > Error Diagnostic Information > > An error occurred while evaluating the expression: > > > "#CLIENT#" > > > > Error near line 37, column 22. > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: Dump a SQL table into an Excel spreadsheet
Do you happen to have some sample code I could use as a guide. I haven't really done much with DTS. Thanks, Dave -Original Message- From: jon hall [mailto:jonhall@;ozline.net] Sent: Tuesday, November 05, 2002 11:49 AM To: CF-Talk Subject: Re: Dump a SQL table into an Excel spreadsheet If you are familiar with DTS, the easiest way would be to create a dts package and call it from a stored proc on the page to write out the excel file. 15 minutes to get the dts right and 3 lines of cf code to call the sp. I'd really recommend at least trying it this way, dts can be quite rewarding in terms of time saved. -- jon mailto:jonhall@;ozline.net Tuesday, November 5, 2002, 8:59:19 AM, you wrote: BD> What would be the best method for dumping a SQL table into an Excel BD> spreadsheet and allowing the user to download it? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: outputting all client vars
thats the one Adrian!! How would I dislay the value of the variables too, as that just gives me the variable names? Thanks a bunch will -Original Message- From: Adrian Lynch [mailto:adrian.l@;thoughtbubble.net] Sent: 05 November 2002 17:09 To: CF-Talk Subject: RE: outputting all client vars I don't think you can view them like that. Try #i# See if that works. Ade -Original Message- From: Will Swain [mailto:will@;hothorse.com] Sent: 05 November 2002 16:57 To: CF-Talk Subject: outputting all client vars Hi all, I've written some basic debug code to output all url, form, and session variables on a page: URL VARS: #URLVar# - #URL[URLVar]# FORM VARS: #FORMVar# - #FORM[FORMVar]# CGI VARS: #CGIVar# - #CGI[CGIVar]# SESSION VARS: #SESSIONVar# - #SESSION[SESSIONVar]# nice and straight forward. BUT, I want the same thing for client variables. However, trying CLIENT VARS: #CLIENTVar# - #CLIENT[CLIENTVar]# just throws up the error: Error Diagnostic Information An error occurred while evaluating the expression: "#CLIENT#" Error near line 37, column 22. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
