RE: CFX not allowed
You can use a command-line zip utility with CFEXECUTE. But, I would imagine that if the host doesn't want you to use CFXs they also won't want you to use CFEXECUTE. But it's something you can look into. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 7:54 PM To: CF-Talk Subject: CFX not allowed Can anyone point me in any direction on this please. The store on our web site, fortunately a CF based product, is run by another business area of the Corporation. Recently they commissioned some further work on the store. The developer forgot about some earlier discussions I have with them about the prohibition of CFX tags. As our CF space is run on hosted service, and is therefore shared, the host wants to keep things industry standard and won't allow CFX tags. They don't want one user doing anything that will destabilise the service for other users. I completely agree with this approach. This recent work was approached by the developer completely on the basis of using CFX_ZIP. Arguably this is not my problem, however, being the good Web Services Manager I am, I will do what I can to bail them out of trouble. Is anyone aware of and can point me to any other approach to using ZIP in CF applications that does not require a CFX tag. Much appreciated ** 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/index.cfm?sidebar=listsbody=lists/cf_talk 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: Version info in spooled mail
I already deleted the email so I can't provide the proper attribution but someone remarked that both CF4.5 and CF5 send out the same version in the email header. I assume it's either an oversight on the part of Macromedia or it's the version of the code used to support the CFMAIL tag which (in this case, I guess) didn't change from version 4.5 to 5. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 9:37 PM To: CF-Talk Subject: RE: Version info in spooled mail Mosh - see, now that's what I would have thought, but I'm running CF 5. It must refer to something else, don't you think? -mk -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 3:58 PM To: CF-Talk Subject: RE: Version info in spooled mail The Cold Fusion server version? Are you running on CF4.5? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 4:20 PM To: CF-Talk Subject: Version info in spooled mail Does anyone know why the mail format for files created with cf mail has the following header: x-cf-version: 4.5.0 What does this version number refer to? -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: QUestion about Input File and CFFILE
Brian: Is there a particular reason why you have to change the filename before you use CFFILE for upload? Because you can always follow your CFFILE ACTION=Upload with a CFFILE ACTION=Rename if necessary. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Yager, Brian T Contractor/Sverdrup [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 8:33 AM To: CF-Talk Subject: RE: QUestion about Input File and CFFILE you can only use that AFTER you have used CFFILE. I need the name of the file BEFORE I use CFFILE so I can get the extension and change the file name. Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 4:56 PM To: CF-Talk Subject: Re: QUestion about Input File and CFFILE What does #CFFILE.ClientFile# return? Jeff - Original Message - From: Yager, Brian T Contractor/Sverdrup [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 1:11 PM Subject: QUestion about Input File and CFFILE I am trying to upload a file using CFFILE. I can get it to wrok just fine. But what I can't do is get the name of the file BEFORE I use CFFILE. When I try to output the name of the file input box, I get some weird name with an extension of .tmp. Can anyone help me with what I need please? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Ways of Submission
Mark: The code would look something like: onClick=document.FormName.submit(); Just change FormName to whatever you've named your form. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 8:40 AM To: CF-Talk Subject: OT: Ways of Submission Sorry for the OT post but need a quick answer... Does anyone know any javascript I can use for the onclick caller for a rollover image that will submit a form? I know you use image as a form type but that doesn't allow me to have a roll over... Kind Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 09 October 2002 13:04 To: CF-Talk Subject: RE: CF vs ASP Being new at this, I am trying to determine why I should learn CF over ASP (or vice versa). http://www.macromedia.com/software/coldfusion/productinfo/competitive/ Tom Chiverton You don't have to be a mad scientist to believe in ColdFusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: The Myth of Bugs (Was Huge Ungainly thread of Doom)
Rick Faircloth wrote: I realize that technical support is most likely a profit center for MM, but what I'm proposing is what an EMT (Emergency Medical Technician) is to a patient. Upon first having a problem, a patient needs immediate attention. EMT's don't arrive on your accident scene, notice you have serious injury and ask for credit card assurance that you can pay. Their job is to treat as best they can and stabilize the situation. If further treatment is required, they take you to the hospital (Technical Support) where more expert care can be provided, and, naturally is more costly. EMTs do not provide service free of charge. They just don't get paid directly by the person in need of assistance. EMTs get paid via your tax dollars and donations. A more complete analogy would have MM charging you an annual fee (like taxes) for this EMT-like service. This is typically called a Support Contract. It seems reasonable for MM to be willing to spend some of its profit to provide *some* free support to the location where the patients are showing up. MM is providing plenty of free support. They have a website with tons of documentation (granted it needs some work, but we've already heard that it's being upgraded), they provide the resources to maintain a CF Community focal point on their servers, etc. They just don't offer the kind of free service that you're looking for. But there's likely a reason for that; to provide emergency support services for free would likely bankrupt them. For a company that charges for technical support, it makes little sense to then provide *free* technical support through a mailing list of forum on a formal basis. Why not? Is there too much money to be made that would be sacrificed? Apparently, you'd be amazed at how much money there is to be made in provided customer support. Also, there are plenty of software companies (so far as I remember reading) that would not break even, let alone turn a profit, were it not for tech support. As it is, several of us at MM provide free support here because it helps. It isn't Macromedia's policy to provide free support. I'm suggesting that maybe it should be as far as can be expected on forums/lists. Why is this an inappropriate scenario? Because, as a company, MM needs to be profitable. As a business owner, I'm sure you can understand. Providing free support, even if only in the form of having one or more full-time employees covering the forums is expensive. When I first started programming professionally, one of my additional responsibilities was to act as the public frontman for the user community (covering mailing lists, newsgroups, website forums, etc.). It soon became apparent that I couldn't handle my programming responsibilities *AND* be the frontman. There's just too much time that has to go into providing support like that. Especially for as complex a product, with as large a user base, as Cold Fusion enjoys. Anyway, hats off to MM and all the MM guys here on the list. And with that... back to (prolly) not responding to this thread. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Adding a target to a CFLOCATION URL?
The TARGET attribute needs to be used on the client side (in an A HREF or the FORM, etc.). It won't work from the server side. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Russ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:29 PM To: CF-Talk Subject: Adding a target to a CFLOCATION URL? Hi All... Everytime I attempt to add a target=whatever to a CFLOCATION URL, I get an error, but my form is in an iFrame and I need to redirect into the _top or _parent. Is this at all possible? Thanks, Russ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: The Myth of Bugs (Was Huge Ungainly thread of Doom)
Lee Fuller wrote: I have to agree with Sean... First, Jesse is a human being, just like we are. We have thoughts, impressions, opinions, etc. Just because he happens to collect a paycheck from MM doesn't negate these things, or make him a robot. While I would expect him to curb his temper, on personal matters that are simply off topic... I *expect* him to be passionate about his ideas and fervent about his expression of them. Without that.. Why not just setup an automated push-button responder and fire all the humans? Just my .02... Auto-response 1936782047 -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Push and CFFILE Question - one more question!
Stick the following code above the CFCONTENT tag: CFHEADER NAME=content-disposition VALUE=attachment; filename=someFILE.fnm -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 10:46 PM To: CF-Talk Subject: RE: Push and CFFILE Question - one more question! Hi, Still having a little bit of trouble. Hope you don't mind giving a little advice I'm successfully writing the required file to a directory on the server. Let's call the file someFILE.fnm. (Basically a text file - the extension is required by the program that's going to open it later...) Next I'm doing this: On the page pushFILE.cfm: cfcontent type=text/plain file=c:\inetpub\hostroot\www.mySITE.com\files\someFILE.fnm deletefile=No As soon as that file is written, the user needs a standard Open or Save alert box as the file is pushed to them. Currently the file is opening as the page it's being called from (pushFILE.cfm) in the browser, with someFILE.fnm as the content on that page. How can I get it to push someFILE.fnm at them, with the file name intact and the option to save? Hmmm Thanks... Les ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: cfinclude inside a cffile tag?
Use CFSAVECONTENT as in: CFSAVECONTENT VARIABLE=sqlOutput CFINCLUDE TEMPLATE=CFOutputApp.cfm /CFSAVECONTENT CFFILE ACTION=write FILE=d:/whatever/myfile OUTPUT=#sqlOutput# -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 5:41 PM To: CF-Talk Subject: cfinclude inside a cffile tag? Trying to get the syntax correct: cffile action=write file=d:/whatever/myfile output = cfinclude template=CFOutputApp.cfm Which obviously don't work, as it errors on the output line. Haven't found anything in the docs to help me get this straight... The CFOutputAppcfm is a huge file outputting a ton of variables from SQL, and is being used twice elsewhere on the site. So, how to include the cfinclude as part of the output statement? I'm asking way too many questions the last few dayssorry ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Push and CFFILE Question - one more question!
I sent a response to that one too 8^). Check the list. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 1:06 AM To: CF-Talk Subject: RE: Push and CFFILE Question - one more question! That worked! Thanks... Now if I can solve the cfinclude inside the cffile problem I'm done! Les : Stick the following code above the CFCONTENT tag: : :CFHEADER :NAME=content-disposition :VALUE=attachment; filename=someFILE.fnmGet the mailserver that powers this list at http://www.coolfusion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Time Required for Updating DB
Like (I think) Isaac said, there's probably something wrong with the code, but it's kind of hard to tell for sure without looking at the code. I apologize if this is obvious, but since you didn't really explain the particulars of the situation, I wanted to make sure that you weren't inadvertently making this harder than need be. Does the situation allow for you to update the column via a single UPDATE query as in: UPDATE fooTable SET barColumn = barColumn + 1 If so, this will be infinitely quicker than having to perform 1 UPDATE query per record. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 8:47 PM To: CF-Talk Subject: Time Required for Updating DB Hi I am having trouble updating a fairly small size database with approx 2 records. Size in MB is approx 18 MB. Type Access 2000. I am updating one particular column, in all the rows with CF Query and Loop tags. First the program generates : Bad Allocation Error complaining of Virtual memory shortage. I have 256 MB Ram Windows 2000 Server Pentium III 999 MZ Processor. When I increased the Virtual memory size the update seems to be going on for ever!!! Its exactly 5 hours plus now its running. How much time does similar updates take?? Any ideas ?? I have not done this before. Srimanta ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Time Required for Updating DB
Thanks Mosh Yup. 8^) I am trying to update price field in Table named Product with values from field newprice in Table named New. The primary key in both the tables is dealerpart no (Text) which is unique. Note: All the records need to be updated CFQUERY name=UpdatePrice Datasource=XYZ Select New.newprice,New.dealerpartno,New.publisher, Product.publisher,Product.dealerpartno,Product.price From New,Product /CFQUERY cfloop query=UpdatePrice Update Product SET Product.price= #UpdatePrice.newprice# WHERE Product.dealerpartno = #UpdatePrice.dealerpartno# /cfloop Note: There are 2 records in both the tables. Srimanta: There are a few problems here. The first is with your SELECT query: Select New.newprice, New.dealerpartno, New.publisher, Product.publisher, Product.dealerpartno, Product.price From New, Product This query (aside from producing two dealerpartno columns) does not specify how to join the two tables. It therefore creates (if I remember the terminology correctly) a Cartesian Product of the two tables. This is, essentially, a result set of every single possible combination of the records from each table. For example, if your 2 tables had the following data: New.newPriceProduct.price = a 1 b 2 the result set would be: newPriceprice = a 1 a 2 b 1 b 2 So, since both of your tables have 20,000 records, your SELECT query is returning a result set with 20,000 x 20,000 records (400,000,000 records). Looping 400 million times is probably what's taking so long 8^). Instead, your query should look something like: SELECT New.newprice, New.dealerpartno AS newDealerPartNo, New.publisher AS newPublisher, Product.publisher AS oldPublisher, Product.dealerpartno AS oldDealerPartNo, Product.price FROM New, Product WHERE New.dealerPartNo = Product.dealerPartNo This query will produce a result set with only 20,000 records (assuming there's a 1-to-1 match of the part numbers in the 2 tables). All that said, I don't think you need the join in the SELECT query. It might be enough to change your code to the following: CFQUERY NAME=UpdatePrice DATASOURCE=XYZ SELECT newprice, dealerpartno FROM New /CFQUERY CFTRANSACTION CFLOOP QUERY=UpdatePrice UPDATE Product SET price= #newprice# WHERE dealerpartno = #dealerpartno# /CFLOOP /CFTRANSACTION -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Time Required for Updating DB
Jeez... I forgot to include the CFQUERY tags. I keep telling myself, no more technical emails when I'm exhausted, no more technical emails when I'm exhausted. You'd think I'd finally start listening to myself 8^). Anyway, just wrap the SQL query in an appropriate CFQUERY tag and you should be fine. It's still probably going to take several minutes to perform (you *ARE* running 20,001 queries). Good luck. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 3:40 AM To: CF-Talk Subject: Re: Time Required for Updating DB Mosh, Tried the codes. Still no luck. The query runs for about 8 to 10 minutes and then the screen shows hundreds of lines of the SQL and no data is updated. Srimanta - Original Message - From: Mosh Teitelbaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:03 PM Subject: RE: Time Required for Updating DB Thanks Mosh Yup. 8^) I am trying to update price field in Table named Product with values from field newprice in Table named New. The primary key in both the tables is dealerpart no (Text) which is unique. Note: All the records need to be updated CFQUERY name=UpdatePrice Datasource=XYZ Select New.newprice,New.dealerpartno,New.publisher, Product.publisher,Product.dealerpartno,Product.price From New,Product /CFQUERY cfloop query=UpdatePrice Update Product SET Product.price= #UpdatePrice.newprice# WHERE Product.dealerpartno = #UpdatePrice.dealerpartno# /cfloop Note: There are 2 records in both the tables. Srimanta: There are a few problems here. The first is with your SELECT query: Select New.newprice, New.dealerpartno, New.publisher, Product.publisher, Product.dealerpartno, Product.price From New, Product This query (aside from producing two dealerpartno columns) does not specify how to join the two tables. It therefore creates (if I remember the terminology correctly) a Cartesian Product of the two tables. This is, essentially, a result set of every single possible combination of the records from each table. For example, if your 2 tables had the following data: New.newPrice Product.price = a 1 b 2 the result set would be: newPrice price = a 1 a 2 b 1 b 2 So, since both of your tables have 20,000 records, your SELECT query is returning a result set with 20,000 x 20,000 records (400,000,000 records). Looping 400 million times is probably what's taking so long 8^). Instead, your query should look something like: SELECT New.newprice, New.dealerpartno AS newDealerPartNo, New.publisher AS newPublisher, Product.publisher AS oldPublisher, Product.dealerpartno AS oldDealerPartNo, Product.price FROM New, Product WHERE New.dealerPartNo = Product.dealerPartNo This query will produce a result set with only 20,000 records (assuming there's a 1-to-1 match of the part numbers in the 2 tables). All that said, I don't think you need the join in the SELECT query. It might be enough to change your code to the following: CFQUERY NAME=UpdatePrice DATASOURCE=XYZ SELECT newprice, dealerpartno FROM New /CFQUERY CFTRANSACTION CFLOOP QUERY=UpdatePrice UPDATE Product SET price= #newprice# WHERE dealerpartno = #dealerpartno# /CFLOOP /CFTRANSACTION -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFX_EXCEL ERROR
Do you have Excel installed on the server? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:11 AM To: CF-Talk Subject: CFX_EXCEL ERROR hi I juz downloaded this custom tag , but it keeps giving me this error when using : Error in CFX_Excel Tag Can't start Excel Does anyone knows what wrong with it ? ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Encapsulating CFFTP within an A HREF is not respected
I think you're mistaking the purpose of the CFFTP tag. CFFTP allows Cold Fusion to act as an FTP client; uploading, downloading, etc. files from a remote FTP server. It does NOT act like CFFORM, CFINPUT, etc. which spit out associated HTML equivalents. I'm assuming you want to create a link to a file on a remote FTP site. In that case, do not use CFFTP. Instead, simply write your A HREF as: A HREF=ftp://ftp.foo.com/bar/baz.txt;Click to download/A -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: David Adams [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:24 PM To: CF-Talk Subject: Encapsulating CFFTP within an A HREF is not respected For some reason, I cannot encapsulate a CFFTP tag within an A HREF. The result is an empty string, when I go to view source of the rendered HTML page. Any ideas? The following code does not work. a href=cfftp connection=myConnection action=getfile localfile=#getDirectoryFromPath(getCurrentTemplatePath())#\#url# remotefile=/#url# stoponerror=no transfermode=binary failifexists=no #name#/A ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CF Search Debugging ??
If the code hasn't changed, check the collection. You might try to reindex/repair/recreate the collection. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 3:42 AM To: CF-Talk Subject: CF Search Debugging ?? Hi My search system via verity seems to have gone down this morning for no apparrant reason, no changes have been made to the .cfm page but when trying to conduct a search the following error message is occurring Error Occurred While Processing Request Error Diagnostic Information Error occurred in tag CFSEARCH The error occurred while processing an element with a general identifier of (CFSEARCH), occupying document position (83:13) to (89:4) in the template file /usr/netscape/server4/docs/intranet/searches/searchresults2.cfm. What could cause this, line 83 in the searchresults2.cfm page is CFSEARCH name = GetResults collection = #SearchCollection# criteria = #Form.Criteria# maxRows = #Evaluate(Form.MaxRows + 1)# startRow = #Form.StartRow# !--- search to calc no of records retreived--- CFSEARCH name = GetAllResults collection = #SearchCollection# criteria = #Form.Criteria# I have no idea firstly why this error is occuring and what is wrong with the code above that was working correctly yesterday ??? Ian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: changing the file extension of cfm to html?
The exact process differs from one web server to the next. But basically, you need to change the association of the .html file extension so that it points to the CF executable. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 9:56 AM To: CF-Talk Subject: changing the file extension of cfm to html? How woudl I go about changing the file extension of coldfusion files from cfm, or having both html and cfm files get sent to the coldfusion server? -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Cumulative Patch for SQL Server (Q316333) Crtical for 2000
From: Dave Watts [mailto:[EMAIL PROTECTED]] Subject: RE: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 If Microsoft made an airplane would you fly in it? No, probably not. On the other hand, I wouldn't feel too comfortable flying the build-your-own-airplane kit from that Linus guy, either. Nor would I want to fly Sun or Oracle, but that's OK, since I wouldn't be able to afford the ticket. Sad to say, I'd probably end up flying the damn Mac - at least the furnishings are nice. I'd only fly Mac Airlines after the OS upgrade. On older models, if someone unhooks their seatbelt while the fasten seatbelt sign is, the plane quacks at you, seizes up completely, and falls from the sky. 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Application Cf Include
But, if you have other code in Application.cfm that still needs to apply to special.cfm, than this solution won't work. Instead, as someone else (sorry, I already deleted the msg) suggested, just write some code that checks for the name of the script. Your code might look like: CFSET ExcludeList=/someDir/special.cfm CFIF ListFindNoCase(ExcludeList, CGI.SCRIPT_NAME) NEQ 0 CFINCLUDE TEMPLATE=Header.cfm /CFIF !--- Do other Application.cfm stuff --- -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Jim Curran [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 8:17 PM To: CF-Talk Subject: RE: Application Cf Include You can use Cfif *insert logic here to exclude* cfexit /cfif within the header.cfm file. CFEXIT stops the execution of that template, similar to cfabort, but it just aborts the current template. This makes the logic to exclude nice and clean since it is contained within the included file. - j jim curran technical director nylon technology 212.691.1134 [EMAIL PROTECTED] -Original Message- From: Tom McNamee [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 7:59 PM To: CF-Talk Subject: Re: Application Cf Include Could you check CGI.SCRIPT_NAME to see if it's the special file, and cfinclude only if false? == At 11:52 AM 10/4/2002 +1200, you wrote: Hi, Is there a way to exlude a file (on a particular cfm template) which is included in the Application.cfm by cfinclude tag. In other words, I have an Application.cfm which includes a header.cfm file by CFINCLUDEtag. Within the same application framework I have a file Special.cfm. I do not want to load the Header.cfm file on this page. But as the application.cfm file includes the header file it is always included in all the other files. I know I can use the cfinclude tag on each and every page individually to include the header page. But as the intranet site has more than 500 templates it seems to be a lot of work just to exclude one page. Any ideas ? Thanks Srimanta - Original Message - From: Paris Lundis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, October 04, 2002 2:51 AM Subject: Re: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 Micro$oft has to stop this s*it... It's getting silly as can be... In the last week we have had to install about 4-6 OS issued patches it seems and now this... These big long winded follow 652 step type ones are at the top of the annoyance list.. It's almost like they are daring us all to flee their stranglehold... Just imagine if this were your car and every day almost you had to take it to the dealer to be serviced... What would you do with that car? Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Zac Spitzer [EMAIL PROTECTED] Date: Thu, 03 Oct 2002 16:42:25 +0200 Subject: Cumulative Patch for SQL Server (Q316333) Crtical for 2000 Microsoft Security Bulletin MS02-056 http://www.microsoft.com/technet/treeview/default.asp?url=/technet/s ecurity/bulletin/MS02-056.asp have fun, yet another crappy m$ patch from with no installer and 2 pages of instructions and it's rated critical for all internet instances z ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Random Stuff
How about CreateUUID()? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 10:42 AM To: CF-Talk Subject: Random Stuff I have a udf that creates a random string that works great. The problem is, looping over this for multiple inserts into a db causes problems because it loops to quickly. Someone mentioned that all the random functions in CF use the current time/date as a seed. The way around this is to either slow down the loop, or to append something on the end of the string, in this case the index of the loop. Does anyone have a way to generate random numbers as fast as I need them? Adrian Lynch Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: MIME type question
Just out of curiosity, what does doesn't work mean in your context? What are you trying to do? I'm assuming you're trying to place the mime-type in the ACCEPT attribute. Are you trying to accept CSV but deny MS Excel format? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 12:42 PM To: CF-Talk Subject: RE: MIME type question That doesn't work either. I'm using this list for starters: ftp://ftp.isi.edu/in-notes/iana/assignments/media-types/media-types. I was hoping there was one they missed. -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 12:50 PM To: CF-Talk Subject: RE: MIME type question text/plain ? -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:29 AM To: CF-Talk Subject: MIME type question Does anyone know what MIME type a .csv file would have? I am trying to upload a csv file using the CFFILE tag and can't seem to find the right type. The list of MIME types i've tried so far text/x-csv,text/csv,application/csv,application/msexcel,applicatio n/excel,ap plication/x-msexcel,application/vnd.ms-excel,application/x-excel Thanks for any help. Brian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: OT--- Close Main window
You used to be able to trick IE and Netscape into thinking that you had opened the current window and than use JS to close the window. This would get around the prompt. However, that particular hole has been patched. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 2:09 PM To: CF-Talk Subject: RE: OT--- Close Main window Kris, If the window has been opened using Javascript from within another page (a la window.open) then it will not generate that error. -mk -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 12:54 PM To: CF-Talk Subject: OT--- Close Main window Does anyone know if it is possible to stop IE form sayingthe webpage your are viewing is trying to close this window when I try to close the window Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: MIME type question
I'm not sure I have the answer to this one. CSV files are just text files, so I would think that text/plain would work for you. But you're saying it doesn't. According to the CF5 docs, the browser provides the mime-type, not the server. So this may be problematic if different people have their 'puters configured differently. This might require a bit more coding on your part but might solve the problem: Why not stop using the ACCEPT parameter and just write some code that checks the extension after the file has been uploaded. This way, you can have nice error messages instead of CF generated (ugly) messages and you don't have to worry about different client configurations. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 2:50 PM To: CF-Talk Subject: RE: MIME type question Mosh, Yes, I am trying to put csv in the accept field of the cffile tag. None of the accept types I have tried already seem to work...and i've tried just about every combination (text/x-csv, text/csv, application/csv, application/csv, application/msexcel, application/excel, application/x-msexcel, application/vnd.ms-excel, application/x-excel) I'm able to upload excel files perfectly using application/vnd.ms-excel as the accept value but just can't seem to get csv to work. The only thing I can think of is that the host I have my website located on doesn't have .csv in the registry as a mime type. -Brian -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 2:27 PM To: CF-Talk Subject: RE: MIME type question Just out of curiosity, what does doesn't work mean in your context? What are you trying to do? I'm assuming you're trying to place the mime-type in the ACCEPT attribute. Are you trying to accept CSV but deny MS Excel format? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 12:42 PM To: CF-Talk Subject: RE: MIME type question That doesn't work either. I'm using this list for starters: ftp://ftp.isi.edu/in-notes/iana/assignments/media-types/media-types. I was hoping there was one they missed. -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 12:50 PM To: CF-Talk Subject: RE: MIME type question text/plain ? -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:29 AM To: CF-Talk Subject: MIME type question Does anyone know what MIME type a .csv file would have? I am trying to upload a csv file using the CFFILE tag and can't seem to find the right type. The list of MIME types i've tried so far text/x-csv,text/csv,application/csv,application/msexcel,applicatio n/excel,ap plication/x-msexcel,application/vnd.ms-excel,application/x-excel Thanks for any help. Brian ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Virus Checking
http://devex.macromedia.com/developer/gallery/info.cfm?ID=DB43FE22-4A73-11D5 -83F600508B94F380method=Full Or just use CFEXECUTE to call your own virus scanner (NAV, Panda, whatever) from the command line. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 4:17 AM To: CF-Talk Subject: SOT: Virus Checking Does anyone know of or use a tag that virus checks files that are uploaded?? Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 09:01 To: CF-Talk Subject: simple way to email my users. We've been asked to add email alert functionality to a clients web site. The client is a recruitment company and wants to maintain a list of prospective candidates that can be automatically alerted when the company has new job openings. The clients wants to be able to manually add / remove names to the email list and to enable new job seekers to add themselves or modify their settings through their web site. The settings will be quite simple, a new job seeker can specify to receive alerts for 1) Software development jobs 2) Management jobs 3) all jobs When the recruitment company has a new job requirement they will type it up, assign it to a category, and then have an option to send it out to all the prospective job seekers who have requested for alerts in that category. Before the emails are sent out the company wants a list of all the recipients so that they can manually delete or add people from the list before the mailing is kicked off. I realize this is a simple project and there are numerous ways to get this done. What I'm looking are suggestions on how to get this done very quickly ( 2 week time line) I also want to know if there is an existing product we can buy which with some customization can achieve this for us. Would love to receive recommendations, suggestions or even proposals if you have a fast solution. Thanks. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Browser forgetting form values
I'm still trying to figure out what the exact nature of this problem is (i.e., what settings cause what results) as they don't seem to be consistent. But it's most likely a function of your browser settings (in IE, Internet Options | Temporary Internet Files | Settings | Check for newer versions of stored pages). Also, check that you're not sending back page expiration headers. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 5:07 AM To: CF-Talk Subject: RE: Browser forgetting form values CLIENT vars -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:02 To: CF-Talk Subject: Browser forgetting form values IE use to remember the values that you would put into a form after submission. It does not do that any more.. or is it the CF MX server? If you enter data into a form and submit it I have a CFTRY/CFCATCH that catches a database error. If you use the browser Back button the data is gone from the form Is there any way to keep the data in the form other then session variables? Thanks __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to get directory from full URL?
Pardon? Reversed the delimiter? Reverse simply changes the order of the characters. It doesn't hold them up to a mirror and get new characters. Reverse(/) = / Reverse(\) = \ Reverse(/\) = \/ Reverse(\/) = /\ -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:34 PM To: CF-Talk Subject: RE: How to get directory from full URL? Actually, the way that works with testing is: #Reverse(ListRest(Reverse(PATH_TRANSLATED),\\))# You have reversed the string, therefore, you have reversed the delimiter. Just my two cents... Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:34 AM To: CF-Talk Subject: RE: How to get directory from full URL? Reverse(ListRest(Reverse(fullurl),/)) Oooh, that's just durn purty. Kevin Graeme __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS Access Date format
CreateODBCDate(date) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:19 PM To: CF-Talk Subject: MS Access Date format I have a CFGrid where I'd like to control the format the dates are displayed in. I believe my only choice would be to format the field in the query, but I can't get the syntax! Anyone know how to format a date in access SQL? __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Text question from a beginner
No worries... I'm j/k with you. I've certainly sent out my fair share of emails while under the influence of heavy doses of caffeine 8^). The ever nice, Mosh 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:31 AM To: CF-Talk Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forcing Word to open
Actually, there's no way (that I know of) to FORCE the downloaded file to open word. That's really a function of the browser settings. For example, with IE, you can force all word files to be saved to disk instead of opening in Word. You would do this through the OS (File Options). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:55 PM To: CF-Talk Subject: RE: Forcing Word to open Yes, I wished more documents would do that, I hate acrobat/word/excel in the browser... Have the link refer to a template.cfm, which contains: CFHEADER NAME=Content-Disposition VALUE=attachment;filename=filenameofworddocument.doc CFCONTENT TYPE=application/msword DELETEFILE=no FILE=pathAndFilenameofworddocument.doc RESET=Yes __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to get directory from full URL?
Ahh... PATH_TRANSLATED. You're right (not that you need me to tell you this), PATH_TRANSLATED will use backslashes. Wasn't the original question about a URL, tho? Confused in CF-Talk -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:14 PM To: CF-Talk Subject: RE: How to get directory from full URL? And here is my example, based on the question at hand: Path_Translated = F:\Websites\4ComPart\IMT_GetsResults\getReturns.cfm Reverse(Path_Translated) = mfc.snruteRteg\stluseRsteG_TMI\traPmoC4\setisbeW\:F Reverse(ListRest(Reverse(PATH_TRANSLATED),\\)) = F:\Websites\4ComPart\IMT_GetsResults Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:56 PM To: CF-Talk Subject: RE: How to get directory from full URL? Pardon? Reversed the delimiter? Reverse simply changes the order of the characters. It doesn't hold them up to a mirror and get new characters. Reverse(/) = / Reverse(\) = \ Reverse(/\) = \/ Reverse(\/) = /\ -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:34 PM To: CF-Talk Subject: RE: How to get directory from full URL? Actually, the way that works with testing is: #Reverse(ListRest(Reverse(PATH_TRANSLATED),\\))# You have reversed the string, therefore, you have reversed the delimiter. Just my two cents... Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:34 AM To: CF-Talk Subject: RE: How to get directory from full URL? Reverse(ListRest(Reverse(fullurl),/)) Oooh, that's just durn purty. Kevin Graeme ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Virus Checking
Well, nothing useful. You could always do the virus checking manually and, once verified as virus free, move the file to where the rest of the world can find it. But without the ability to install an antivirus app, your kind of sol. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:12 PM To: CF-Talk Subject: RE: Virus Checking Mosh, The problem is I dont have my own server(s)!!! (Poor relation of the cf-talk list!!)... Any other methods that I may consider?? Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 16:34 To: CF-Talk Subject: RE: Virus Checking http://devex.macromedia.com/developer/gallery/info.cfm?ID=DB43FE22 -4A73-11D5 -83F600508B94F380method=Full Or just use CFEXECUTE to call your own virus scanner (NAV, Panda, whatever) from the command line. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 4:17 AM To: CF-Talk Subject: SOT: Virus Checking Does anyone know of or use a tag that virus checks files that are uploaded?? Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 09:01 To: CF-Talk Subject: simple way to email my users. We've been asked to add email alert functionality to a clients web site. The client is a recruitment company and wants to maintain a list of prospective candidates that can be automatically alerted when the company has new job openings. The clients wants to be able to manually add / remove names to the email list and to enable new job seekers to add themselves or modify their settings through their web site. The settings will be quite simple, a new job seeker can specify to receive alerts for 1) Software development jobs 2) Management jobs 3) all jobs When the recruitment company has a new job requirement they will type it up, assign it to a category, and then have an option to send it out to all the prospective job seekers who have requested for alerts in that category. Before
RE: Detecting Acrobat?
Here's some HTML/JS code that I wrote way, way back that should give you what you need. Combine this with using JS to update a hidden form field and you can figure out whether or not the client supports Acrobat. HTML HEAD TITLEMy Mime Types Page/TITLE SCRIPT LANGUAGE=JavaScript !-- var pdf_flag = 0; var fdf_flag = 0; for (i = 0; i navigator.mimeTypes.length; i++) { if (navigator.mimeTypes[i].type == application/pdf) { pdf_flag = 1; } if (navigator.mimeTypes[i].type == application/vnd.fdf) { fdf_flag = 1; } } // -- /SCRIPT /HEAD BODY PRE MIME TYPE SUFFIXESDESCRIPTION application/vnd.fdf fdf AcroEx32 File application/pdf pdf Acrobat /PRE SCRIPT LANGUAGE=JavaScript !-- if (pdf_flag == 1) { document.write(You have PDFP); } if (fdf_flag == 1) { document.write(You have FDF); } // -- /SCRIPT /BODY /HTML -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 4:07 PM To: CF-Talk Subject: OT: Detecting Acrobat? I'm sure someone has covered this before, but didn't have any luck searching the archives, and google has somewhat vauge results. I need to detect if Adobe Acrobat is installed on the user's browser (which will always be IE). I did find reference to a function that uses IsObject() in VBScript but haven't been able to make it work - it throws an error trying to create an activeX object. Anyone have any tips for doing this? I'd prefer javascript, but will use what I can get. Thanks. Shawn Grover ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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 Text question from a beginner
Actually, I'm a Coke and Mountain Dew coder. Hot caffeine just doesn't do it for me. But than, this is off topic, isn't it? 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:04 PM To: CF-Talk Subject: RE: SQL Text question from a beginner s'all good mang.too bad I cant jive to well with java kinda prefer mahuang and good old thc :) ..tony -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:02 PM To: CF-Talk Subject: RE: SQL Text question from a beginner No worries... I'm j/k with you. I've certainly sent out my fair share of emails while under the influence of heavy doses of caffeine 8^). The ever nice, Mosh 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:31 AM To: CF-Talk Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFM Files are Locked?
From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:12 PM To: CF-Talk Subject: RE: CFM Files are Locked? Funny thing is that using my account through FTP, I cannot delete the files. Going to the physical server, using the Exact same account, I CAN delete the file. Or maybe the lock window expired while I was walking down the hall... Shawn: WinNT (and, therefore, Win2k/XP) lock files for use by a single user when they are accessed. For some reason, IIS doesn't like to unlock the files too quickly. When logged in as the same account as IIS, you *ARE* the same user, so you can delete them. But if you are a different user, even one with Admin privileges, the system maintains the lock. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: CFQUERY and STARTROW=0 (??!)
He's wrong. And computers don't start at 0. It's up to the compiler/interpreter to decide what the first index is. In Cold Fusion, the first index is always 1. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tom Sammons [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 5:09 PM To: CF-Talk Subject: CFQUERY and STARTROW=0 (??!) Hi all, I was looking up some stuff on joins versus unions, and came across an opinion that used CFQUERY as an example. (I won't post the url since I don't know if it's kosher here.) However, under this person's tutorial topic called Limiting Results it used this code: CFQUERY DATASOURCE = Friends Name = Query1 Maxrows = 10 Startrow = 0 followed by the comment: Note that the starting row is set at 0. Remember that computers start numbering at 0, not 1. So the first record in the database is record number 0. --- Now, I understand offsets, et cetera, but I've never heard it used regarding cfquery (or any other sql query for that matter -- I couldn't even find another mention of startrow=0 anywhere in google or altavista for any major sql platform...). And obviously, I've never had a problem with using startrow=1 missing the first record of a query return set. Has anyone else ever used startrow=0 in *any* sql platform, is it practical/standardized, or is this guy just telling people to do things the way he thinks they should be? Inquiring minds (at least one) want to know... Tom ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk 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: Help attaching a dynamic pdf to an email
It's been a few years since I had to work with FDFs so forgive me if my info is a bit off, but... my understanding is that you don't need to attach the PDF, just the FDF. Note the line in the FDF that begins with /F. It indicates a URL from where the PDF can be downloaded. What should happen is that the recipient opens the FDF, Acrobat sees that /F bit and downloads the indicated PDF, filling in the fields as indicated in the FDF. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Adam Sokolic [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 10:51 AM To: CF-Talk Subject: Help attaching a dynamic pdf to an email I'm attempting to generate a pdf through fields in a database (this part I have working fine) and then take that pdf file and attach it to an email. I'm using the Max Paperno tutorial to accomplish this, so the code reads: CFHEADER NAME=Content-Disposition VALUE=inline; filename=gift.fdf CFCONTENT TYPE=application/vnd.fdf cfinclude template=gift.fdf And all my variables fill in. However when, I then go to attach the file to an email (using cfmail with a cfmailparam tag) it attaches the original pdf which shows the cf variable names instead of the actaual dynamic data. My fdf file reads as: cfoutput %FDF-1.2 %âãÏÓ 1 0 obj /FDF /Fields [ /V (#expdate#)/T (expdate) /V (#serialnum#)/T (serialnum) /V (#clubrenewal.username#)/T (username) ] /F (http://www.gostarpower.com/club/coupon/gift.pdf)/ID [ 592d65d9f72506dde1135c341d9fdab93b3abd4eb0b65949c24c7ebb37fb1f7f ] endobj trailer /Root 1 0 R %%EOF /cfoutput I know that activepdf would most likely accomplish this, but I'm not at the point of wanting to spend $$ on it. Any help or thoughts would be greatly appreciated. Thank you, Adam M. Sokolic STAR POWER Systems, Inc. Web Developer Boulder, CO Phone:303-209-0219 or 1-800-635-6750 x219 Fax: 303-449-4222 E-Mail: [EMAIL PROTECTED] Visit the STAR POWER® Online Network: http://www.GoStarPower.com (Company Info, Chats, Events, Product Resources) __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adding two fields and displaying in a third
onchange=window.document.ExpenseForm.TotalAmount#Line#.value=eval (window.document.ExpenseForm.Mileage#Line#)+eval(window.document. ExpenseForm.CostOfMeals#Line#); Add .value to the end of the 2 fields you're trying to add, as in: ...=eval(window.document.ExpenseForm.Mileage#Line#.value)+... ^^ BTW, why are you using eval()? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:04 AM To: CF-Talk Subject: Adding two fields and displaying in a third I'm writing a form that allows a person to fill in the mileage and meal expense, and then displays the total in a third field. I'm using this in the meals expense field: input type=Text name=CostOfMeals#Line# value=0 validate=float required=Yes size=5 maxlength=5 onchange=window.document.ExpenseForm.TotalAmount#Line#.value=eval (window.document.ExpenseForm.Mileage#Line#)+eval(window.document.E xpenseForm.CostOfMeals#Line#); But the third field evaluates to [object][object]. How do I get this to add up? T __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adding two fields and displaying in a third
At 11:22 AM 9/30/02 -0400, Mosh Teitelbaum wrote: onchange=window.document.ExpenseForm.TotalAmount#Line#.value=eval (window.document.ExpenseForm.Mileage#Line#)+eval(window.document. ExpenseForm.CostOfMeals#Line#); Add .value to the end of the 2 fields you're trying to add, as in: ...=eval(window.document.ExpenseForm.Mileage#Line#.value)+... ^^ Shoot. Thanks. :) Yah, no prob 8^) BTW, why are you using eval()? I thought I had to in order to get Javascript to treat as numbers instead of text. Nope, you shouldn't have to. JavaScript is supposed to add 2 values together (via the + operator) if the values can both be resolved to numerics. Otherwise, it appends the values. So long as both of your values are numeric then, it should resolve just fine. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Text question from a beginner
A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time calculation
Jeez... must I say it again? CRAP 8^) Thanks for the correction. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 6:58 AM To: CF-Talk Subject: RE: Time calculation I think you want integer division: \ -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 8:26 PM To: CF-Talk Subject: RE: Time calculation Crap. Change all of the LTEs to GTEs and all of the MODs to / (divided by). That'll teach me not to test code. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 6:32 PM To: CF-Talk Subject: RE: Time calculation DateDiff() by itself is not enough. It can tell you the difference in days OR hours OR ..., but not all combined. The following (untested) code should do what you want. My apologies if it doesn't 8^). !--- Get difference in seconds --- CFSET diffSeconds = DateDiff(s, start, end) !--- Initialize display vars --- CFSET dspDays = 0 CFSET dspHours = 0 CFSET dspMinutes = 0 CFSET dspSeconds = 0 !--- Get the number of days and subtract them from diffSeconds --- CFSET secondsInDay = 60 * 60 * 24 CFIF diffSeconds LTE secondsInDay CFSET dspDays = diffSeconds MOD secondsInDay CFSET diffSeconds = diffSeconds - (secondsInDay * dspDays) /CFIF !--- Get the number of hours and subtract them from diffSeconds --- CFSET secondsInHour = 60 * 60 CFIF diffSeconds LTE secondsInHour CFSET dspHours = diffSeconds MOD secondsInHour CFSET diffSeconds = diffSeconds - (secondsInHour * dspHours) /CFIF !--- Get the number of minutes and subtract them from diffSeconds --- CFSET secondsInMinute = 60 CFIF diffSeconds LTE secondsInMinute CFSET dspMinutes = diffSeconds MOD secondsInMinute CFSET diffSeconds = diffSeconds - (secondsInMinute * dspMinutes) /CFIF !--- Get number of seconds --- CFSET dspSeconds = diffSeconds !--- Display in day:hour:minute:second format --- CFOUTPUT #dspDays#:#dspHours#:#dspMinutes#:#dspSeconds# /CFOUTPUT -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 4:45 PM To: CF-Talk Subject: Time calculation I have two date and time fields, start and end. I want find the difference and i want to display the difference as days:hrs:mins:secs what is the best way to do that... ? Right now i use hour minute and second (built in functions) and those work find for differences less than one day but they do not display the correct amount of hours for differences longer than 1 day... any suggestions Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL problems
I don't know that this is your specific problem, or even if it's remotely true, but I've been hearing reports of large scale email problems. I've been receiving duplicates or not receiving messages from a number of lists I subscribe to (as have others on the lists) and, sometimes, don't receive messages until a couple of days after they were sent. I don't remember where I read about it, but maybe that's what's going on here. (Jeez... I feel like I'm spreading an Urban Legend or something). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 10:24 AM To: CF-Talk Subject: CFMAIL problems A client is reporting a problem where PDF bulletins being mailed out are being delivered twice to some of their customers. I'm still trying to get to the root of the problem - which I can't replicate on my local test system - but I thought I'd ask: if I can't find any obvious code problems (and I can't so far), what are the possibilities? They're running CF 4.5 SP2 on a Solaris box, their mailing list runs to only around 160 people, and the PDF attachments are are 150KB. Could this just be a CFMAIL limitation problem? I know it isn't that robust, and that upgrading to MX or getting something like iMS was going to be a possible necessity as the list expanded, but I didn't expect it to choke on this small volume. Obviously I want to guage the situation well before being confident it's not a code problem, and recommend that the client splash out more money! TIA, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCONTENT and file downloads
Above your CFCONTENT tag, you have to create a new header (named content-disposition) to supply the new name, like: CFHEADER NAME=content-disposition VALUE=attachment; filename=something.pdf CFCONTENT TYPE=application/pdf FILE=something.pdf DELETEFILE=No Make sure that the VALUE attribute of the CFHEADER tag begins with attachment instead of inline. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: ColdFusion (CFTalk) [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 10:59 AM To: CF-Talk Subject: CFCONTENT and file downloads [CF5 Server Pro, Windows 2000] I have a feeling I've forgotten something obvious, but... In a nutshell: I have a template which uses CFCONTENT to download the contents of a file on the server to the browser. The file save dialog on the browser pops up... but the name of the file shown is the name of the template (somename.cfm) not the name of the actual file on the server (something.pdf in this case). Of course, the file then arrives on the other end with the wrong extension... etc... Anyone any ideas on how to get the right filename down to the client. If necessary, I can use a fixed name - the important thing is getting the .pdf extension (as the files are PDF's). Regards, SB Scott Bartlett BTA Limited, 100 High Street Wandsworth, London SW18 4LA, United Kingdom e: [EMAIL PROTECTED]v: +44 (0)20 8871 4240 f: +44 (0)20 8871 4584 Network Consultancy and Support for Windows 9x/NT and MacOS. Internet connectivity, solutions, and business services. http://www.bta.com. This message is intended only for the use of the person(s) (The intended recipient(s)) to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by BTA. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dot test
Using Outlook 2000, I'm seeing 1 less dot than there should be in each of the 3 samples provided. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 4:35 PM To: CF-Talk Subject: dot test ... (12) . (6) .(18) these should count right ..tony (its funny, I noticed this awhile ago, because, in my tag line, I have always had 3 dots before my name, and when my messages come through on the list, its always like this (.tony) vs (...tony) Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time calculation
DateDiff() by itself is not enough. It can tell you the difference in days OR hours OR ..., but not all combined. The following (untested) code should do what you want. My apologies if it doesn't 8^). !--- Get difference in seconds --- CFSET diffSeconds = DateDiff(s, start, end) !--- Initialize display vars --- CFSET dspDays = 0 CFSET dspHours = 0 CFSET dspMinutes = 0 CFSET dspSeconds = 0 !--- Get the number of days and subtract them from diffSeconds --- CFSET secondsInDay = 60 * 60 * 24 CFIF diffSeconds LTE secondsInDay CFSET dspDays = diffSeconds MOD secondsInDay CFSET diffSeconds = diffSeconds - (secondsInDay * dspDays) /CFIF !--- Get the number of hours and subtract them from diffSeconds --- CFSET secondsInHour = 60 * 60 CFIF diffSeconds LTE secondsInHour CFSET dspHours = diffSeconds MOD secondsInHour CFSET diffSeconds = diffSeconds - (secondsInHour * dspHours) /CFIF !--- Get the number of minutes and subtract them from diffSeconds --- CFSET secondsInMinute = 60 CFIF diffSeconds LTE secondsInMinute CFSET dspMinutes = diffSeconds MOD secondsInMinute CFSET diffSeconds = diffSeconds - (secondsInMinute * dspMinutes) /CFIF !--- Get number of seconds --- CFSET dspSeconds = diffSeconds !--- Display in day:hour:minute:second format --- CFOUTPUT #dspDays#:#dspHours#:#dspMinutes#:#dspSeconds# /CFOUTPUT -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 4:45 PM To: CF-Talk Subject: Time calculation I have two date and time fields, start and end. I want find the difference and i want to display the difference as days:hrs:mins:secs what is the best way to do that... ? Right now i use hour minute and second (built in functions) and those work find for differences less than one day but they do not display the correct amount of hours for differences longer than 1 day... any suggestions Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time calculation
Got one of these for SQL Server? j/k 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 5:36 PM To: CF-Talk Subject: Re: Time calculation John Gedeon wrote: I have two date and time fields, start and end. I want find the difference and i want to display the difference as days:hrs:mins:secs what is the best way to do that... ? Right now i use hour minute and second (built in functions) and those work find for differences less than one day but they do not display the correct amount of hours for differences longer than 1 day... any suggestions SELECT CAST( ( EXTRACT(DAY FROM (end - start)) || ':' || EXTRACT(HOUR FROM (end - start)) || ':' || EXTRACT(MINUTE FROM (end - start)) || ':' || EXTRACT(SECOND FROM (end - start)) ) AS VARCHAR) FROM table Jochem __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting By Column
Allow your code to accept the sort/filter variables as form or url variables. For example, something like: CFPARAM NAME=URL.Sort DEFAULT= CFPARAM NAME=FORM.Sort DEFAULT=#URL.Sort# CFPARAM NAME=URL.Filter DEFAULT= CFPARAM NAME=FORM.Filter DEFAULT=#URL.Filter# CFQUERY NAME=GetRecords DATASOURCE=#APPLICATION.DSN# SELECT col1, col2 FROM table CFIF Len(Trim(FORM.Filter)) WHERE col1 = '#FORM.Filter#' /CFIF CFIF Len(Trim(FORM.Sort)) ORDER BY #FORM.Sort# /CFIF /CFQUERY TABLE TR TDA HREF=currentPage.cfm?Filter=#FORM.Filter#Sort=col1Col1/A/TD TDA HREF=currentPage.cfm?Filter=#FORM.Filter#Sort=col2Col2/A/TD /TR CFOUTPUT QUERY=GetRecords ... display rows based on query ... /CFOUTPUT /TABLE -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: David Sampson [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 2:20 PM To: CF-Talk Subject: Sorting By Column Earlier this week someone posted a link to Web Tricks (http://www.webtricks.com/) for help with sorting an output table by columns. Great little application! Works fine! Thanks! But... (you had to know there was a 'but'). When I query by a variable; get a table of results; then, try to sort (using my newly installed sort-by-column links), the entire page is reloaded, the query is run again (this time without the form.variable) and the whole database is output! How can I get it to sort by column using the variables originally passed? David Sampson Analyst/Programmer II AK Department of Education Early Development 907.465.2395 ph 907.465.8676 fx [EMAIL PROTECTED] FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time calculation
Crap. Change all of the LTEs to GTEs and all of the MODs to / (divided by). That'll teach me not to test code. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 6:32 PM To: CF-Talk Subject: RE: Time calculation DateDiff() by itself is not enough. It can tell you the difference in days OR hours OR ..., but not all combined. The following (untested) code should do what you want. My apologies if it doesn't 8^). !--- Get difference in seconds --- CFSET diffSeconds = DateDiff(s, start, end) !--- Initialize display vars --- CFSET dspDays = 0 CFSET dspHours = 0 CFSET dspMinutes = 0 CFSET dspSeconds = 0 !--- Get the number of days and subtract them from diffSeconds --- CFSET secondsInDay = 60 * 60 * 24 CFIF diffSeconds LTE secondsInDay CFSET dspDays = diffSeconds MOD secondsInDay CFSET diffSeconds = diffSeconds - (secondsInDay * dspDays) /CFIF !--- Get the number of hours and subtract them from diffSeconds --- CFSET secondsInHour = 60 * 60 CFIF diffSeconds LTE secondsInHour CFSET dspHours = diffSeconds MOD secondsInHour CFSET diffSeconds = diffSeconds - (secondsInHour * dspHours) /CFIF !--- Get the number of minutes and subtract them from diffSeconds --- CFSET secondsInMinute = 60 CFIF diffSeconds LTE secondsInMinute CFSET dspMinutes = diffSeconds MOD secondsInMinute CFSET diffSeconds = diffSeconds - (secondsInMinute * dspMinutes) /CFIF !--- Get number of seconds --- CFSET dspSeconds = diffSeconds !--- Display in day:hour:minute:second format --- CFOUTPUT #dspDays#:#dspHours#:#dspMinutes#:#dspSeconds# /CFOUTPUT -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: John Gedeon [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 4:45 PM To: CF-Talk Subject: Time calculation I have two date and time fields, start and end. I want find the difference and i want to display the difference as days:hrs:mins:secs what is the best way to do that... ? Right now i use hour minute and second (built in functions) and those work find for differences less than one day but they do not display the correct amount of hours for differences longer than 1 day... any suggestions Proverbs 3:5 Trust in the Lord with all your heart and lean not on your own understanding; __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Time calculation
Mosh Teitelbaum wrote: Got one of these for SQL Server? From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] You mean it doesn't work? You should really get a better database :-) You mean MS Access? I don't think it'll work in that either 8^). ducks -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Why oh *WHY* is this *now* working?
So I'm not completely up on my CF Developer License info but I seem to recall hearing that after a certain amount of time, the dev server only accepts requests from a single IP. That IP is whichever IP first hits the server after a reboot. So, it sounds like you just need to reboot and make sure that the first hit you make against the server is of the form http://localhost/ As the error message said: The ColdFusion engine must be stopped and restarted to reset the permitted IP address. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 11:00 PM To: CF-Talk Subject: Why oh *WHY* is this *now* working? Yes, there are many other development environments out there. They all work about the same when it comes to WML. There's no problem with using CF to generate WML - I've done this personally quite a bit. It can be difficult to debug any generated WML, no matter where it came from. Usually, to determine the problem, it's helpful to see the actual generated text. One look. That's all it took. I'm digging thru the console windows, and I run across this little gem: Source HTMLHEADTITLEAccess is Restricted/TITLE/HEADBODY H3Access is Restricted to this ColdFusion Service./H3 The evaluation license for this copy of Macromedia ColdFusion has expired. The ColdFusion server is currently configured to accept requests exclusively from IP address 192.168.*.*. (Your request was made from 127.0.0.1.) The ColdFusion engine must be stopped and restarted to reset the permitted IP address. etc etc etc... Okay, so, while I'm glad it's now working (I simply typed the machine name http://jeff/wap/ and it worked just fine) I'm interested in knowing why, when I'm working in CF, and creating .cfm pages, and previewing them locally from within CF and using http://localhost, suddenly localhost doesn't work. Was it because the request came from the Openwave kit instead of from within CF? I'm willing to accept this, but it just doesn't make sense to me. I've been successfully using localhost for ages (well, at least the past couple of months) with no problem, now, suddenly, it's a problem. Oh well...any explanation is appreciated, but don't worry about it. I've got it working... __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: input tag
Change the code to something like: input type=button value=Refresh class=navlinks onClick=parent.middle.document.history.go(0); Note the removal of the TARGET attribute as this doesn't apply to INPUT tags. Also, note the removal of the javascript: from the onClick definition. It's assumed and, therefore, no necessary. And finally, note the code used in the onClick definition. -- 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:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 10:28 AM To: CF-Talk Subject: input tag I'm using 3 column frames on my site with the following names. | left | middle | right | I have this input line on a page in the right frame. When I click on the Refresh button I want the middle frame refreshed. The below only refreshes the right frame when clicked. Whats wrong with my syntax or JS? input type=button value=Refresh class=navlinks onClick=javascript:history.go(0); target=middle --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Array Help
And, in case you're still fuzzy, it's no longer a list because of the call to ListToArray(). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 2:49 PM To: CF-Talk Subject: RE: Array Help by the time you get to here #ListGetAt(x, Counter)#, x is no longer a list Ade -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 25 September 2002 19:28 To: CF-Talk Subject: Array Help Hi everyone, I am developing a sales thing for our reps and I got yanked off a project to do it and my brain is fuzzy. I have a column that gets returned that is titled Hot (a bit field in a SQL 2K DB). This column has checkboxes that can be checked so that the DB will flag them for future contact. The check box contains a dual value: 1, and the PK. So what I would like to do is when the check box is checked, set the Hot field to 1 for that particular record. My problem is that both values are numbers and not text. I am also unsure of how to accomplish this if someone selects like 20 checkboxes. I would need to update all associated records. Thanks! Tony Here is my VERY feabile attempt thus far. I just wanted to make sure the records were coming back correctly. I haven't started the update to the DB yet. So advice there would be greatly appreciated as well. cfset x = ListToArray(hot, ,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(x, Counter)#/cfoutput /CFLOOP The error I get: Error Diagnostic Information An error occurred while evaluating the expression: #ListGetAt(x, Counter, ,)# Error near line 54, column 29. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE/SCHEDULE
You would use CFCONTENT to send the file back to the browser. Either use another CFFILE after the CFCONTENT to delete the file or run a scheduled event to routinely delete any *.ins files. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 7:34 AM To: CF-Talk Subject: CFFILE/SCHEDULE Hey, A few suggestions on how to achieve the following would be GREATLY appreciated. I am creating an app that requires the user to enter their username and password (NO VALIDATION AVAILBLE)... This then sets up an .ins file so that when opens configures their internet settings. I will be using CFFILE to write the file, not sure how to offer it for download, and delete the file after they have downloaded it... Any help appreciated. Kind Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Display 3 column text
Try moving the CFSET x = 1 bit in front of the CFLOOP tag. Every iteration of the loop current resets x back to 1. -- 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:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:16 AM To: CF-Talk Subject: Display 3 column text Here is my code below. I still can't get it to display in 3 columns? cfquery name=GetEnv datasource=user-profiles dbtype=ODBC SELECT strUsername,strGroup,strSelect FROMprofiles WHERE strUsername = '#auth#' /cfquery table wisth=100% cellpadding=6 cellspacing=0 border=0 align=center tr class=wdirlinks td colspan=2 cfif COOKIE.DisplaySelect GT 0 cfloop index=ListElement list=#COOKIE.DisplaySelect# delimiters=, cfoutput table width=100% cellpadding=2 cellspacing=2 border=0 tr cfset x=1 cfif NOT x MOD 3/trcfif x NEQ #ListElement.RecordCount#tr/cfif/cfif cfset x = x + 1 td class=wdirlinksinput type=checkbox name=select value=checked#ListElement#/td /tr /table /cfoutput /cfloop cfelse nbsp;bNone Selected/b /cfif /td /tr /table --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE/SCHEDULE
Uhh... yeah, or that 8^). BTW, Isaac, did you get that link I sent about the free C lib for the Twofish algorithm? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:08 PM To: CF-Talk Subject: RE: CFFILE/SCHEDULE cfcontent has a deletefile attribute which is supposed to delete the file immediately following the transfer... though I've heard of people having problems getting cfcontent files to delete due to IIS placing file-locks on them. but that's another story... :) You would use CFCONTENT to send the file back to the browser. Either use another CFFILE after the CFCONTENT to delete the file or run a scheduled event to routinely delete any *.ins files. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 7:34 AM To: CF-Talk Subject: CFFILE/SCHEDULE Hey, A few suggestions on how to achieve the following would be GREATLY appreciated. I am creating an app that requires the user to enter their username and password (NO VALIDATION AVAILBLE)... This then sets up an .ins file so that when opens configures their internet settings. I will be using CFFILE to write the file, not sure how to offer it for download, and delete the file after they have downloaded it... Any help appreciated. Kind Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: please do my work for me
Just to clarify... YOU'RE PARSING THE URL MANUALLY?!?!?!? CF does this for you. You can access the variable as URL.pCode from anywhere in your code, as in: CFOUTPUT The value of the pCode URL variable is #URL.pCode#. /CFOUTPUT -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 5:38 PM To: CF-Talk Subject: please do my work for me I want to extract a value from a URL variable which can show up anywhere in the URL. Here are some examples, I would want the pCode value which will always be an integer of varying length: index.htm?var1=23pCode=100othervar=hello return 100 index.htm?pCode=1 --- return 1 index.htm?someVariabl=hiTheresomeothervariable=45pCode=00343223234322 - return 00343223234322 If somebody can tell me the right regular expression (or if a regular expression isn't even needed, but just some combination of CF functions) that would be GREAT! Adam. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE/SCHEDULE
You're welcome and no problem. I just wanted to make sure that you got it, cause my service provider keeps mucking up my email. Yay Comcast! -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 6:15 PM To: CF-Talk Subject: RE: CFFILE/SCHEDULE Yes I did, sorry I didn't reply -- just been real busy ( and frustrated -- long story ), but thanks a lot for the link. :) Uhh... yeah, or that 8^). BTW, Isaac, did you get that link I sent about the free C lib for the Twofish algorithm? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:08 PM To: CF-Talk Subject: RE: CFFILE/SCHEDULE cfcontent has a deletefile attribute which is supposed to delete the file immediately following the transfer... though I've heard of people having problems getting cfcontent files to delete due to IIS placing file-locks on them. but that's another story... :) You would use CFCONTENT to send the file back to the browser. Either use another CFFILE after the CFCONTENT to delete the file or run a scheduled event to routinely delete any *.ins files. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 7:34 AM To: CF-Talk Subject: CFFILE/SCHEDULE Hey, A few suggestions on how to achieve the following would be GREATLY appreciated. I am creating an app that requires the user to enter their username and password (NO VALIDATION AVAILBLE)... This then sets up an .ins file so that when opens configures their internet settings. I will be using CFFILE to write the file, not sure how to offer it for download, and delete the file after they have downloaded it... Any help appreciated. Kind Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL message resent, completed this time.
In the future, some code would make it easier to troubleshoot the specific problem. That said, I'm not sure what you're doing wrong, but the general order of your code should be something to the effect of: 1) Use CFFILE to accept the uploaded file, as in: CFFILE ACTION=Upload FILEFIELD=File DESTINATION=C:\WinNT\Temp\ NAMECONFLICT=MakeUnique 2) Use CFMAIL to send the email, attaching the newly uploaded file, as in: CFMAIL TO=#FORM.To# FROM=[EMAIL PROTECTED] SUBJECT=#FORM.Subject# CFMAILPARAM FILE=C:\WinNT\Temp\#FILE.ServerFile# Hello. Here's the file. /CFMAIL HTH. If not, send some code along. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:06 AM To: CF-Talk Subject: CFMAIL message resent, completed this time. ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi (again), As I was saying, I have a form in which a user adds a Subject, Message and selects a Attachment on their local machine, this form is then submitted to another page that runs a CFMAIL tag that sends the email. The problem is the attachment, I browse to the file attach it to the email then when the form is submitted the CFMAIL tag throws a error: Error Diagnostic Information Unable to attach file. Cannot attach 'C:\WINNT\TEMP\ACF474.tmp' to the mail message. The file does not exist. This is not the name of my attachment though (it was actually a jpg). I do have the form set to, enctype=multipart/form-data, I can't see why the attachment is passed as it's orignal address. How can I get the attachment to be passed and sent correctly by the CFMAIL tag? Thanks (sorry about the unfinshed email sent earlier) ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Forging a web page
If you're talking about the date that is commonly displayed in the header or footer when you print a web page, it's usually as simple as changing the date/time on your computer. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:48 AM To: CF-Talk Subject: OT: Forging a web page Are there any tools that allow users change data in a cfm/html page? A fax of one of my web sites' pages made it to my desk yesterday. A student is challenging grades with a forged date in the banner of the web page. I know the date is forged because two separate systems have logged a different date for the activity. I'm curious to know how easy it is to copy a page, all files included, and then modify it. There's the right click save method and notepad, but this is a little too convoluted and tedious. Are there any click and point type browser/editor hybrids that get a page then allow editing the page? Thanks, Brian __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: encryption - CF SQL Server
OK... so, just to verify what we're looking for here (again 8^): The data is submitted to CF Server in clear text, CF encrypts the data and inserts it into the DB. At some later point, an external app queries the DB, decrypts the data, and writes it to a flat file. Is that right? The solution, IMO, is to use an encryption algorithm that is available to both CF and this external app. Again, not being a practiced COM guy, I'm not going to get into COM (since I like to sound halfway intelligent when I write). But you could try finding another external app that allows encryption decryption from the command-line. CF could use CFEXECUTE to call this app to encrypt the data and the other application could call it for decryption. Or, find an algorithm that is supported via a CF_tag and has a sibling that can be called from your other app. You'd just have to make sure that both CF and the other app are using the same encryption/decryption keys. For example: Blowfish http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347367-2830-11D4 -AA9700508B94F380method=Full Rijndael or 3DES http://devex.macromedia.com/developer/gallery/info.cfm?ID=67CBD343-A003-11D5 -83F600508B94F85Amethod=Full You're on your own for finding the non-CF versions though 8^). Good luck. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 9:07 PM To: CF-Talk Subject: RE: encryption - CF SQL Server So here's the catch now if I understand correctly... You want to encrypt the data BEFORE it's passed in the form... That's funky... Thing is, you need a client solution then. CF can't do much about encrypting data BEFORE a form is submitted. Neither can ASP or PHP or JSP or whatever. The data is submitted by a client unencrypted within the form. Did I screw that description up? ... No, want to encrypt it before it goes to the sql server... but then the sql server has to decrypt it later ... You can use some javascript encryption techniques, but those are moot because the algorithm is readily available. It's important to keep a cipher away from prying eyes. So to encrypt something BEFORE it's submitted is likely not possible. Not unless you use Well, we could theoretically have built the forms in Flash and done it that way ... but that's not the direction the project is headed... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding next 2 items in query
For a few reasons. First, it necessitates that the placement of the last active record (in your code sample, row 3) is known ahead of time (which it isn't). Second, if there is 1 or less available records above the last known active record, your solution doesn't allow for returning to earlier records. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 7:42 PM To: CF-Talk Subject: RE: Finding next 2 items in query Uh, why not just use cfoutput query=foo startrow=3 maxrows=2 out of curiosity? -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 3:20 PM To: CF-Talk Subject: RE: Finding next 2 items in query You're explaining yourself just fine. No worries. Basically, you're looking at some conditional logic a few queries. Something like this: 1) Query DB for currently active items, sort by ID. 2) Discard the 1st record and store the ID of the 2nd. 3) Update DB to make currently active item inactive. 4) Query DB for all items greater than stored value that are approved, sort by ID. 5) a) If RecordCount = 2, grab 1st 2 values and ignore others. b) Else, query DB for all approved items, sort by ID. Grab 1st 1 or 2 depending on how many you got from the previous query. 6) Update DB to set these 2 values to active. Note that in the 5b, you're getting all approved items, not just those less than the last 2 approved items. This is just in case you only have to items that are currently approved. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:08 PM To: CF-Talk Subject: Re: Finding next 2 items in query -- ID* - Active - Approved -- 12 - No - Yes 23 - No - No 24 - No - Yes 29 - Yes - Yes 32 - Yes - Yes 33 - No - Yes 40 - No - No I think you'll have to fill us in on why 33, and 12 meet the criteria Because they're the next records in the table WHERE Approved = Yes AND active = No. 40 has to be ignored because Approved = No. I know how to find all records that are approved, or active, or whatever - but I don't see how I can get the next 2. A friend suggested doing something like WHERE ID #previousID# - only problem with this is if the CURRENT ID was 40 (as per the table above), it wouldn't pickup on 12 which is the logical next record. Sorry, I'm not explaining myself properly here at all - if anyone has any other ideas they'd be much appreciated Will __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding next 2 items in query
For those that are interested, this thread moved offline. I just wanted to post my follow-up for anyone that was paying attention to this thread... [excerpted from my email reply] OK, so let me explain what I meant in my response. I think part of the confusion stems from my having typed the response on a laptop keyboard, on a moving train, so I didn't do as good a job typing as I should have 8^). I'll go through each step using the sample data you had provided in an earlier email: -- ID* - Active - Approved -- 12 - No - Yes 23 - No - No 24 - No - Yes 29 - Yes - Yes 32 - Yes - Yes 33 - No - Yes 40 - No - No The basic steps, as per my last email, are: 1) Query DB for currently active items, sort by ID. 2) Discard the 1st record and store the ID of the 2nd. 3) Update DB to make currently active item inactive. 4) Query DB for all items greater than stored value that are approved, sort by ID. 5) a) If RecordCount = 2, grab 1st 2 values and ignore others. b) Else, query DB for all approved items, sort by ID. Grab 1st 1 or 2 depending on how many you got from the previous query. 6) Update DB to set these 2 values to active. Let me show you the code: !--- Step 1. Query DB for currently active items. Sort by ID --- !--- This should return only 2 records: 29 32 --- CFQUERY NAME=CurrentActive DATASOURCE=#application.DSN# SELECT PaidAdID FROM PaidAdverts WHERE NowShowing IS Yes ORDER by PaidAdID /CFQUERY !--- Step 2. Discard the 1st record and store the ID of the 2nd. --- !--- We only need the 2nd ID so we can use it to determine the --- !--- next 2 records to be activated. --- CFSET lastActiveID = CurrentActive.PaidAdID[2] !--- Step 3. Update DB to make currently active item inactive. --- !--- Deactivate old items to make room for the new ones. --- CFQUERY NAME=DeactivateAdverts DATASOURCE=#application.DSN# UPDATE PaidAdverts SET NowShowing = 'No' WHERE NowShowing IS Yes /CFQUERY !--- Step 4. Query DB for all items greater than lastActiveID that --- !--- are approved, sort by ID. This gets us all of the records with --- !--- IDs greater than lastActiveID that are eligible for activation. --- CFQUERY NAME=GetNextAdverts DATASOURCE=#application.DSN# SELECT PaidAdID FROM PaidAdverts WHERE Approved IS Yes AND PaidAdID #lastActiveID# ORDER by PaidAdID /CFQUERY !--- Step 5. Determine next 2 adverts --- CFSET nextAdvertIDList = !--- Step 5a. If RecordCount = 2, grab 1st 2 values and ignore others. --- CFIF GetNextAdverts.RecordCount GTE 2 CFSET nextAdvertIDList = ListAppend(nextAdvertIDList, GetNextAdverts.PaidAdID[1]) CFSET nextAdvertIDList = ListAppend(nextAdvertIDList, GetNextAdverts.PaidAdID[2]) !--- Step 5b. Else, query DB for all approved items, sort by ID. Grab --- !--- 1st 1 or 2 depending on how many you got from the previous query. --- CFELSE !--- Store any valid IDs greater than lastActiveID. There will only be 0 or 1. --- CFLOOP QUERY=GetNextAdverts CFSET nextAdvertIDList = ListAppend(nextAdvertIDList, GetNextAdverts.PaidAdID) /CFLOOP !--- Query DB for all valid adverts, from beginning of list --- CFQUERY NAME=GetAllApprovedAdverts DATASOURCE=#application.DSN# SELECT PaidAdID FROM PaidAdverts WHERE Approved IS Yes ORDER by PaidAdID /CFQUERY !--- Get enough adverts from query to fill the list --- CFLOOP QUERY=GetAllApprovedAdverts CFIF ListLen(nextAdvertIDList) LT 2 CFSET nextAdvertIDList = ListAppend(nextAdvertIDList, GetNextAdverts.PaidAdID) /CFIF /CFLOOP /CFIF !--- Step 6. Update DB to set these 2 values to active. --- CFQUERY NAME=ActivateAdverts DATASOURCE=#application.DSN# UPDATE PaidAdverts SET NowShowing = 'Yes' WHERE PaidAdIDs IN (#nextAdvertIDList#) /CFQUERY !--- *** --- !--- END OF CODE --- !--- *** --- Note that all of the above code should be wrapped in a CFTRANSACTION. Also, in step 5b, you may need to modify the following line: CFIF ListLen(nextAdvertIDList) LT 2 to check that the current PaidAdID is not already in the list. This would be the case if there is only 1 currently approved ad in the DB. Than, you would get the same ID in the list twice. This may or not be a problem depending on your business logic. Also, I just wrote this off the cuff without testing it. It may have some bugs and it could almost certainly be optimized. But this should at least get you going. Good luck. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com
RE: encryption - CF SQL Server
Isaac: I knew I had seen this somewhere. Niels Ferguson has just released a free C library of the Twofish encryption algorithm. You could probably create a quick and dirty command line and/or CFX implementation of the algorithm pretty quickly. Maybe this'll do it for you. http://www.macfergus.com/niels/code/TwofishClib.html -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 7:11 PM To: CF-Talk Subject: RE: encryption - CF SQL Server OK... so, just to verify what we're looking for here (again 8^): The data is submitted to CF Server in clear text, CF encrypts the data and inserts it into the DB. At some later point, an external app queries the DB, decrypts the data, and writes it to a flat file. Is that right? hehe... No, the 2nd app is SQL Server. :) Although if the encryption software has a command-line interface, I can probably use that from SQL Server. The solution, IMO, is to use an encryption algorithm that is available to both CF and this external app. Again, not being a practiced COM guy, I'm not going to get into COM (since I like to sound halfway intelligent when I write). But you could try finding another external app that allows encryption decryption from the command-line. CF could use CFEXECUTE to call this app to encrypt the data and the other application could call it for decryption. Or, find an algorithm that is supported via a CF_tag and has a sibling that can be called from your other app. You'd just have to make sure that both CF and the other app are using the same encryption/decryption keys. Yep, that's the thinking. :) For example: Blowfish http://devex.macromedia.com/developer/gallery/info.cfm?ID= CA347367-2830-11D4 -AA9700508B94F380method=Full Rijndael or 3DES http://devex.macromedia.com/developer/gallery/info.cfm?ID= 67CBD343-A003-11D5 -83F600508B94F85Amethod=Full You're on your own for finding the non-CF versions though 8^). Good luck. Thanks. :) Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding next 2 items in query
You're explaining yourself just fine. No worries. Basically, you're looking at some conditional logic a few queries. Something like this: 1) Query DB for currently active items, sort by ID. 2) Discard the 1st record and store the ID of the 2nd. 3) Update DB to make currently active item inactive. 4) Query DB for all items greater than stored value that are approved, sort by ID. 5) a) If RecordCount = 2, grab 1st 2 values and ignore others. b) Else, query DB for all approved items, sort by ID. Grab 1st 1 or 2 depending on how many you got from the previous query. 6) Update DB to set these 2 values to active. Note that in the 5b, you're getting all approved items, not just those less than the last 2 approved items. This is just in case you only have to items that are currently approved. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:08 PM To: CF-Talk Subject: Re: Finding next 2 items in query -- ID* - Active - Approved -- 12 - No - Yes 23 - No - No 24 - No - Yes 29 - Yes - Yes 32 - Yes - Yes 33 - No - Yes 40 - No - No I think you'll have to fill us in on why 33, and 12 meet the criteria Because they're the next records in the table WHERE Approved = Yes AND active = No. 40 has to be ignored because Approved = No. I know how to find all records that are approved, or active, or whatever - but I don't see how I can get the next 2. A friend suggested doing something like WHERE ID #previousID# - only problem with this is if the CURRENT ID was 40 (as per the table above), it wouldn't pickup on 12 which is the logical next record. Sorry, I'm not explaining myself properly here at all - if anyone has any other ideas they'd be much appreciated Will __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: encryption - CF SQL Server
Encrypted in the DB but not encrypted in the flat file? Do you ever need to decrypt the encrypted data? I'm not much of a COM guy but Java has internal encryption classes (dunno if that's an option for you). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:37 PM To: CF-Talk Subject: encryption - CF SQL Server The story is this: We have an app that will need to generate a flat text file from SQL Server ( without the aid of ColdFusion ) and there is a requirement that some of the data be encrypted in the db, but we don't want the data to be passed in the form unencrypted ( disclusing SSL -- we will SSL encrypt the directory, but they want another layer of security ). So I've been tasked with finding reasonably inexpensive encryption software for COM which can be used as both a CFX tag in ColdFusion and by SQL Server either internally or from the command-line on the SQL Server machine using the master..xp_cmdshell stored procedure. Both CF Server and SQL Server are Windows 2000 Servers ( was that obvious? :) Any suggestions or advice would be greatly appreciated, thanks, S. Isaac Dealey Certified Advanced ColdFusion 5 Developer New Epoch www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: parsing user input to get count
Because you're allowing users to enter ranges, you will probably have to loop over the input list and parse out the ranges, manually counting each element. For example: CFPARAM NAME=FORM.numList DEFAULT= CFSET count = 0 CFLOOP LIST=#FORM.numList# INDEX=currEle CFIF Find(-, currEle) EQ 0 !--- not a rnage, increment by 1 --- CFSET count = count + 1 CFELSE !--- range, determine range elements --- CFSET beginNum = Trim(GetToken(currEle, 1, -)) CFSET endNum = Trim(GetToken(currEle, 1, -)) CFSET count = count + (endNum - beginNum) + 1 /CFIF /CFLOOP CFOUTPUTThere were #count# numbers entered./CFOUTPUT -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 3:38 PM To: CF-Talk Subject: parsing user input to get count I have a text field that I allow users to input data as follows: 1,2,5-9 Basically it is a coma delmited list with a range. Whats the best way to get a count... in this case I'd need to return 7 Thanks in advance... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Just curious possible problem
What code are you using to perform the copy? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 10:35 AM To: CF-Talk Subject: Just curious possible problem I noticed if I have a set of text example: s3 10 X 50 120 pcs. I have this in an access database without the quotes, but when I try to copy that information to anew table it stops where the first space begins. So when I am looking at what copied into the new table is just s3.. What am I doing wrong besides using access.. I am also using cf 4.5.. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfinclude, how granular can you make it?
So I think you've already discovered that CFINCLUDE is not that granular. It seems as though you just want a way to encapsulate your CFIF expression. UDF (User Defined Functions -- introduced in CF5) may be the way to go here. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 11:15 AM To: CF-Talk Subject: cfinclude, how granular can you make it? How granular can you make your includes? I ask because I'm unable to breakup an if-else clause. If I pull out the cfif ... and put it into an include I get a Just in time compilation error. If I put the entire cfifcfelse/cfif into the include everything works fine. I'm not finding information on just in time complitation error in either google, or forta's book or the macromedia site. WHAT EXISTS : // if today is a holiday do this else do that cfif ... snip ... #year# EQ 2002 AND #month# EQ 9 AND #ThisDay# EQ 2 OR ... snip ... td class=holiday#ThisDay#/td cfelse tda href=#ThisDay#/td cfif WHAT I WOULD LIKE TO BE ABLE TO DO: cfinclude template=holiday.cfm td class=holiday#ThisDay#/td cfelse tda href=#ThisDay#/td cfif thx // gilbert midonnet __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cftry cftransaction order
You might use something like: CFTRY CFTRANSACTION ACTION=Begin CFQUERY ... /CFQUERY CFTRANSACTION ACTION=Commit / CFCATCH TYPE=Database Database Exception CFTRANSACTION ACTION=Rollback / /CFCATCH /CFTRANSACTION /CFTRY -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: jon hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 1:05 PM To: CF-Talk Subject: cftry cftransaction order I have a set of database updates that I need to nest in a cftransaction, but I also want to use a cftry/cfcatch block for error handling. If I put the cftransaction outside the try/catch block if there is an error, the catch block will execute and abort any further processing, if I put the cftrans tags inside the block, is CF smart enough to know that the transactions should be rolled back before the catch block is executed? What would be the correct way to do this? -- jon mailto:[EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Well... I think I've gone through all of my ask these first questions. The only other thing I can think of is a code review of the complete code. Dunno. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 8:50 PM To: CF-Talk Subject: Re: Log reporting error - No actual error If you try to CFOUTPUT FORM.FormFields, what does it give you? And, if it gives you a list as you would expect, try iterating over that list, evaluating each one as in: I displayed the list and the values for each item in the list. The list/values output as it should. And, it gave me an error saying Element FIELDNAMES is undefined in FORM. brThe error occurred on line 17. Line 17 is where I output Form.fieldnames (and it displayed ok). Mind boggling, isn't it? Scott --- Scott Brady http://www.scottbrady.net __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Jeez. Well, I can't see any problems in the code that you posted. If you try to CFOUTPUT FORM.FormFields, what does it give you? And, if it gives you a list as you would expect, try iterating over that list, evaluating each one as in: CFIF IsDefined(FORM.FormFields) FORM.FormFields = CFOUTPUT#FORM.FormFields#/CFOUTPUTBRBR CFLOOP LIST=#FORM.FormFields# INDEX=CurrEle CFOUTPUTFORM.#CurrEle# = #Evaluate(FORM.#CurrEle#)#/CFOUTPUT /CFLOOP CFELSE FORM.FormFields is Not Defined /CFIF -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:12 PM To: CF-Talk Subject: RE: Log reporting error - No actual error I can give you the relevant parts, without posting all of the actual code: !--- replace hack attempts --- cfif isDefined(form.firstname) cfset form.firstname = replacenocase(form.firstname, cf, _HACK, all) cfset form.firstname = replacenocase(form.firstname, script, _HACK, all) /cfif CFQUERY name=popOrder DATASOURCE=#DSN# INSERT INTO Orders ( FirstName ) VALUES ( '#form.FirstName#' ) /cfquery .. and then it displays the next page. (That page has a form on it, as well, which does the same thing with submissions). It appears to happen with every field in the form (so, if you were to cfparam FORM.firstname, then the error would report for FORM.lastname [the next field]). Scott Brady http://www.scottbrady.net/ __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Do you have any code we could look at? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 12:27 PM To: CF-Talk Subject: Log reporting error - No actual error (I thought I sent this on Saturday, but never saw any replies nor could I find it in the archives, so let me try it again) I'm helping a friend debug his site. Here's what happens: A user proceeds through the checkout process. In the first step, they fill out a form. The next page goes through just fine and they can finish the process ok. However, the log file reports an exception was generated and cferror is called, sending an e-mail to the admin. The error message is that Form.FirstName does not exist. However, on the page generating the error, you can output Form.FirstName just fine and it goes into the database just fine. I thought if I just put in cfparams (with defaults of empty strings) for the form values, that would take care of it. But then, the database actually inserts the empty strings (without the cfparams, it inserts the submitted values). Has anyone else encountered this? It's very weird. The production environment is Windows 2000 CF5. My development environment is Windows XP CFMX. The error occurs in both environments. Thanks! Scott Brady http://www.scottbrady.net/ __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Not to sound like a broken record, but could you post the code for the action page? As Dan suggested, that's most likely where the problem would be. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 1:23 PM To: CF-Talk Subject: RE: Log reporting error - No actual error Here's the basic code (with layout and such trimmed out): The form: form action=ordercredit.cfm method=POST onsubmit=return numCheck(this) table tr td width=80First Name*/td tdinput type=Text name=FirstName value= align=LEFT size=20 maxlength=25/td /tr tr td colspan=2 align=LEFT input type=Submit value= Next /tr /table /form [I just noticed the missing closing table tag in that cell. I'm closing it now, but I can't believe that's the problem] The action page is fairly simple. I can cfoutput#FORM.firstname#/cfoutput and it outputs fine and it inserts into the database fine. But, cferror is triggered and sends an e-mail saying that FORM.firstname doesn't exist. And, again, cfparam-ing it just causes an empty string to go into the database [without cfparam, the submitted form field goes into the database]. Scott Brady http://www.scottbrady.net/ -- Original Message -- From: Mosh Teitelbaum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 17 Sep 2002 13:09:38 -0400 Do you have any code we could look at? -- Mosh Teitelbaum __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recursion
Or, you could rewrite the function without recursion. Just thought I'd mention it as another alternative. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:23 PM To: CF-Talk Subject: RE: Recursion I wrote this really neat recursive function using the cffunction tag on my development system which is running CFMX on WindowsXP Pro. When I ported to the operational host (third party), I discovered that they were running a previous version of CF (I do not know which) which does not support the new tag. Does anybody know how to do recursion without the cffunction tag? If your recursive function is relatively simple, you can probably write it as a CF 5-compliant user-defined function, using CFSCRIPT. CFSCRIPT is a tag in which you can write CF commands using a JavaScript-like language, which uses the same syntax and control flow structures as JavaScript, but uses CFML operators and expressions. You can't use CFML tags within a CFSCRIPT tag, though, and CFSCRIPT doesn't support all the things you can do with CFML tags, such as querying a database. Keep in mind that the host would have to be using CF 5 or higher for this to work. Alternatively, you could write a recursive custom tag. However, this is the least desirable alternative, as custom tags don't provide any built-in ability to return values (you can write that ability into your code, though) and they tend to negatively affect performance. Nevertheless, if you need recursion and you're using a version of CF prior to 5, that's the only way you can do it within CFML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF dynamic content server load (was: Large Corporations that use ColdFusion)
You might want to consider writing out the dynamic pages as static HTML files. If the contents of the pages tend not to change on a daily basis than you may want to rethink storing the contents in a database. If the DB storage if for purposes of content management, than instead of generating the pages at each request, or even caching the queries as Dave suggested, you might just want to sump the completed webpages to static HTML files. This saves on network traffic (to/from the DB), load on the DB, load on the application server, and memory. If, however, the contents *DO* change on a regular basis, than caching the queries may not be a valid option either. In that case, you may want to rethink your approach. Out of curiosity, why are the page contents being stored in the database? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Aunger, Mitch [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 6:16 PM To: CF-Talk Subject: CF dynamic content server load (was: Large Corporations that use ColdFusion) I've got a similar question (to the original subject) that has reared (no pun related to Victoria Secret site) its ugly head again here at my office (question forms slowly and is really at the bottom). I've been asked to improve a section of our external website relating to Press Releases. A similar site that I've done creates web pages that appear to the end user as if they were basically static - tho the content is almost totally derived from data stored in a database. Now, I've proposed doing the Press Releases in a similar way - all content and much of the formatting being stored in an oracle database. However, my web 'gurus' are saying that we can't possibly put dynamic content on the external site because each page could have 50,000+ hits a day and that would overload our servers. I'm guessing that their 'fear' is based on a bad past history with ColdFusion. (Gee.. I hope none of them are on this list and are easily offended g) So, when this thread came out, I looked at the VictoriaSecret site figuring it probably gets more than 50,000 hits per day... right? It seems to be VERY reponsive! ColdFusion doesn't look so bad on their site ;) QUESTIONs: can anyone provide me with realistic comments/examples of HIGH VOLUME DYNAMIC page content or ideas on how I can assure my managment that ColdFusion dynamic content will not kill the servers? Are there recommended tools for analyzing loads and network problems (I once looked at Mercury's TOPAZ)? How do I fight this perception that CF pages must be slow server hogs? I'll be glad to chat off the list if you want (Note: Should this topic be on the 'community' list?) Thanks Mitch Lowly web developer trying to fight the evil webmasters g -Original Message- From: Weaver, Anthony [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 8:08 AM To: CF-Talk Subject: RE: Large Corporations that use ColdFusion www.VictoriasSecret.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfhttp useragent bug?
Is the user agent value hard coded as in your example or is it dynamic? Because if it's dynamic, than there may be some minor logic flaw in generating its value that causes it to be appended to the previous value instead of overwriting it. Just a thought (and a question, I guess 8^). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Benekli [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 10:43 PM To: CF-Talk Subject: cfhttp useragent bug? Using cfhttp with the useragent defined inside of a loop iterates a useragent list on the webserver logs. Any suggestions on how to stop the madness? -the code: cfhttp method=get url=http://127.0.0.1; useragent=FOO/cfhttp cfhttp method=get url=http://127.0.0.1; useragent=FOO/cfhttp cfhttp method=get url=http://127.0.0.1; useragent=FOO/cfhttp cfhttp method=get url=http://127.0.0.1; useragent=FOO/cfhttp cfloop from=0 to=3 index=i cfhttp method=get url=http://127.0.0.1; useragent=BLAH/cfhttp /cfloop -truncated results from the log file: 127.0.0.1 80 GET / - 200 0 449 138 1 HTTP/1.1 127.0.0.1 FOO - - 127.0.0.1 80 GET / - 200 0 449 138 1 HTTP/1.1 127.0.0.1 FOO - - 127.0.0.1 80 GET / - 200 0 449 138 0 HTTP/1.1 127.0.0.1 FOO - - 127.0.0.1 80 GET / - 200 0 449 138 0 HTTP/1.1 127.0.0.1 FOO - - 127.0.0.1 80 GET / - 200 0 449 139 1 HTTP/1.1 127.0.0.1 BLAH - - 127.0.0.1 80 GET / - 200 0 449 144 0 HTTP/1.1 127.0.0.1 BLAH,BLAH - - 127.0.0.1 80 GET / - 200 0 449 149 0 HTTP/1.1 127.0.0.1 BLAH,BLAH,BLAH - - 127.0.0.1 80 GET / - 200 0 449 154 1 HTTP/1.1 127.0.0.1 BLAH,BLAH,BLAH,BLAH - - Benekli22:41P12IX2002 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Recursion
Robert: If the point of the recursion was to traverse a hierarchical structure in a database, than you might want to move that part of the code to the database. How you would accomplish this depends on the database platform that you are using. Oracle supports a CONNECT BY clause in SELECT statements that makes single-parent hierarchy traversal a snap. In SQL-Server Sybase, you could write a stored procedure that performs the recursion for you. In Access, you can probably write a macro or something. The benefit to this is that you make only a single call to the DB, you end up with a single query result set containing all of your data, and you offload data processing responsibilities to the server that knows how to best process data. Good luck. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Robert Polickoski [mailto:[EMAIL PROTECTED]] Sent: Friday, September 13, 2002 1:41 PM To: CF-Talk Subject: RE: Recursion All, Thank you for your responses to my inquiry. As it turns out, the CFSCRIPT option is not viable because the point of the recursion was querying a database for records that represented subordinate records which might have subordinate records of their own. The cfmodule seems to take forever and therefore is not practical. In the end, I will have to change the design of the application. However, that is not necessarily a bad thing. However, it does make me appreciate the changes in CFMX. Again, thank you all for your responses. -- Original Message -- From: Mosh Teitelbaum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 15:45:57 -0400 Or, you could rewrite the function without recursion. Just thought I'd mention it as another alternative. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:23 PM To: CF-Talk Subject: RE: Recursion I wrote this really neat recursive function using the cffunction tag on my development system which is running CFMX on WindowsXP Pro. When I ported to the operational host (third party), I discovered that they were running a previous version of CF (I do not know which) which does not support the new tag. Does anybody know how to do recursion without the cffunction tag? If your recursive function is relatively simple, you can probably write it as a CF 5-compliant user-defined function, using CFSCRIPT. CFSCRIPT is a tag in which you can write CF commands using a JavaScript-like language, which uses the same syntax and control flow structures as JavaScript, but uses CFML operators and expressions. You can't use CFML tags within a CFSCRIPT tag, though, and CFSCRIPT doesn't support all the things you can do with CFML tags, such as querying a database. Keep in mind that the host would have to be using CF 5 or higher for this to work. Alternatively, you could write a recursive custom tag. However, this is the least desirable alternative, as custom tags don't provide any built-in ability to return values (you can write that ability into your code, though) and they tend to negatively affect performance. Nevertheless, if you need recursion and you're using a version of CF prior to 5, that's the only way you can do it within CFML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: is there a trim function to get rid of a space between names
Err... CFSET Name = Mac Donald CFSET NewName = Replace(Name, , , ALL) This will remove all of the spaces in the string. Is that what you were looking for? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rebecca Joy Sherman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 4:27 PM To: CF-Talk Subject: is there a trim function to get rid of a space between names Hi all, Is there a way to get CF to delete the space in between a name. ie... Mac Donald to just MacDonald? Thanks, Joy __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists