Re: CF 4.51sp2 Memory Usage Plateau
Try going to the beta site and reading the forum...there are specifics about at what point the warnings kick in and about registry keys that you can set that will change this. At what point is memory usage excessive: When memory usage exceeds physical memory? When memory is x% of swap? Still trying to get a handle on what the memory plateau is for CF ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Allaire aquires java based tools
http://www.varbusiness.com/Sections/News/BreakingNews.asp?ArticleID=21435 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: [slightly ot: math question, needed for cold fusion programming]
I don't know about a true timestamp but MSSQL7 has numerous date/time functions that do return milliseconds. However, you're right when you state that a UUID would be better suited to uniqueness. I haven't really been watching CF-Talk that closely lately, so I may be missing some info here, but... If you are in need of a random and unique ID, I would suggest using the CreateUUID() function, not a timestamp. It is unique across the universe and is only 35 characters long. Also, if you actually store this as a date stamp in a database (which I'm not sure you are doing), I recall reading that SQL 7 (and probably other RDBMS platforms as well) don't store date stamps with millisecond precision, so the chances of dups would be much higher. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 1:37 PM To: CF-Talk Subject: RE: [slightly ot: math question, needed for cold fusion programming] okay, that sounds good so the chances of two people getting the same timestamp is the same as the packers making it to the superbowl. pretty much impossible. i'll put that in my report (using timestamp (thanks to whomever suggested that awhile back) to create a series of random 60 digit numbers, and their can never be duplicates). Thanks! Gavin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 12:21 PM To: CF-Talk Subject: Re: [slightly ot: math question, needed for cold fusion programming] 1.4884 x 10^19 Gavin Myers [EMAIL PROTECTED] wrote: Lets say you have 1 page that scores 1,000,000 unique visitors a month here's what I came up with: 1,000,000/30/24/60/60/1000 = 0.000385 So that means that 0.0003 people a milisecond hit the sight, correct? what is the % chance of 2 people hitting on the same milisecond (and math equation for that?) -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [slightly ot: math question, needed for cold fusion programming]
I wouldn't use 'randomize(GetTickCount())' If your server happens to run too long without a reboot it will error out...the Randomize will work until it acts on a GetTickCount than an integer...once it's too large it will croak. this is actually what i'm doing cfset x5 = randomize(GetTickCount()) cfset x5 = Randrange(1, 9) cfset x5 = randomize(GetTickCount()) + #x5# cfoutput cfset x = Randrange(1, 9) cfset x2 = Randrange(1, 9) cfset y = Randrange(1, 9) cfset y2 = Randrange(1, 9) cfset ran = "#x##x2##y##y2#" /cfoutput but I'll look into UUID, that sounds pretty cool -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 1:59 PM To: CF-Talk Subject: RE: [slightly ot: math question, needed for cold fusion programming] I thought it was added in 4.0, but it might have been 4.0.1. I think it was added while Allaire was developing Spectra. I guess is could be a 4.5 thing, but I don't see it in the "new functions" page in my 4.5 docs. Most RDBMS systems also have a comparable UUID type of functionality as well, but using that will, tie you to the RDBMS platform to a certain extent. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 2:43 PM To: CF-Talk Subject: RE: [slightly ot: math question, needed for cold fusion programming] is CreateUUID() a 4.5 feature? I dont see any reference to it in 4.0 -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 1:33 PM To: CF-Talk Subject: RE: [slightly ot: math question, needed for cold fusion programming] I haven't really been watching CF-Talk that closely lately, so I may be missing some info here, but... If you are in need of a random and unique ID, I would suggest using the CreateUUID() function, not a timestamp. It is unique across the universe and is only 35 characters long. Also, if you actually store this as a date stamp in a database (which I'm not sure you are doing), I recall reading that SQL 7 (and probably other RDBMS platforms as well) don't store date stamps with millisecond precision, so the chances of dups would be much higher. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 1:37 PM To: CF-Talk Subject: RE: [slightly ot: math question, needed for cold fusion programming] okay, that sounds good so the chances of two people getting the same timestamp is the same as the packers making it to the superbowl. pretty much impossible. i'll put that in my report (using timestamp (thanks to whomever suggested that awhile back) to create a series of random 60 digit numbers, and their can never be duplicates). Thanks! Gavin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2000 12:21 PM To: CF-Talk Subject: Re: [slightly ot: math question, needed for cold fusion programming] 1.4884 x 10^19 Gavin Myers [EMAIL PROTECTED] wrote: Lets say you have 1 page that scores 1,000,000 unique visitors a month here's what I came up with: 1,000,000/30/24/60/60/1000 = 0.000385 So that means that 0.0003 people a milisecond hit the sight, correct? what is the % chance of 2 people hitting on the same milisecond (and math equation for that?) -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Duplicate emails
up to 7 duplicates of some messages...and it's getting really old! Sorry to bother everyone, but has anyone else been getting lots of duplicate emails from this list? Thanks, Bob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: # rule? [CF-Talk]
Here's a link to a Ben Forta article on #s http://www.defusion.com/articles/index.cfm?ArticleID=26 What is the rule of thumb with the # ? I see you don' t need it to refer to cfparam variables but you do use it for cfset variables and table variables can someone clarify this? Thanks, Mark :o) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFFILE
Steve, This is a common occurrence on Macs where one may upload a JPG or GIF that has no extension to the file name. I have a site that uses CFFILE to upload a picture. My client is using a graphic off a floppy on her a: drive. The file is uploaded through an input type="file". Here is the problem... Whenever I do it, it works fine. I can't seem to break it no matter what I do. When she does it, she gets the following error... Error Diagnostic Information Error processing CFFILE tag The MIME type of the uploaded file (/) was not accepted by the server. Please verify that you are uploading a file of the appropriate type. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (29:2) to (33:20) in the template file D:\INETPUB\WWWROOT\VMSITES\. blah, blah, blah I have walked through it with her on the phone I can't figure it out. The file that is passing through is just a slash (/) which to me would indicate and empty field. Does anyone have any insight? Thanks, Steve -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Specifying Number of Records output per page of results
Allaire's Exchange Gallery is full of tags that will do this: http://devex.allaire.com/developer/gallery/ I am wanting to be able to set the number of records that are outputted on each page of search results and then have the remaining records outputted on subsequent pages each page displaying 10 records at a time same way the search engines do any advice / assistance would be appreciated Kind Regards Claude Raiola (Director) -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ie 5.5 and history.back
history.back(1) works fine here on 5.5...sure you didn't mean to put in on the RESET button instead of the SUBMIT button? I haven't seen any discussion of this: form input type="submit" value="Back" onClick="history.back()" /form used to send you to the previous page. But with IE 5.5, it just reloads the same page. Any idea why? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: 4.5.1 memory leak? is this really a leak we are talking about ?
Hi Peter, Yes, CF Studio 4.5[1] is a resource hog on Win95/98. Running it, Outlook Express and an accounting database we use will bring Windows to it's knees in a short time. I've read the release notes on CF 4.51 SP1 beta1 and they are addressing a whole plethora of memory leaks and hopefully, once released will help solve these problems. One thing that I found that might help is a program call RAMPage. It helps release unneeded memory and is available at: http://www.tudogs.com/windows2.php3 Actually, I was speaking of Cold Fusion Studio's memory leaks. It will crash Windows-98 in minutes. It's completely unusable. Windows-NT/2000 has better memory protection and will fare better. At 03:52 PM 8/15/00 +0100, JustinMacCarthy wrote: Are you guys talking about the memory allocation in CF or a bona fide leak CF does grab memory as it needs and yes it doesn't release it - by design. It fingures that if it needed the memory once it will do again. And there is an over head in aquiring / releasing memory. From "Looking At ColdFusion Memory Usage" @ http://www.allaire.com/Handlers/index.cfm?ID=15014Method=Full "Neither of the statistics provided by the Task Manager or Performance Monitor will show memory being returned. That's because ColdFusion 4.5 incorporates the latest version of SmartHeap, which no longer returns unused memory to NT. Instead, memory is held, assuming ColdFusion may reuse it in the near future. While this method is faster and more efficient, SmartHeap can lead to confusion when looking at memory statistics on NT. " So is this something different..?? Justin MacCarthy - Original Message - From: "Peter Theobald" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 15, 2000 3:25 PM Subject: Re: MIME types and 4.5.1 memory leak? It still leaks. At 10:03 AM 8/15/00 -0400, Christopher S Martin wrote: Is anyone aware of a method or tag that can be used to return the mime type of an email attachment? Or is this functionality already built into cfpop, and I am just not aware of it? On an unrealted note, would anyone have the url for the 4.5.1 memory leak patch? I couldn't find it at allaires site. Thanks Chris Martin [EMAIL PROTECTED] www.fsenablers.com www.fslink.com -- - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - - - Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- - Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: This is Crazy!
Hi Paul, I've got a Verity Collection that retrieve the word Attorney just fine so it may be how you're indexing it. I'm using a SQL7 database to store client variables via WDDX The relevant script CF for a updating a Verity Search Term passed to it by a form follows: !---Update client variables--- CFIF ISDEFINED("Form.st") CFSET VARS = STRUCTNEW() CFWDDX ACTION="WDDX2CFML" INPUT="#client.vars#" OUTPUT="vars" CFSET VARS["Search_Term"] = FORM.ST CFWDDX ACTION="CFML2WDDX" INPUT="#Vars#" OUTPUT="wddx_vars" CFSET CLIENT.VARS = WDDX_VARS CFELSE CFSET VARS = STRUCTNEW() CFWDDX ACTION="WDDX2CFML" INPUT="#client.vars#" OUTPUT="vars" /CFIF The CF script updates fine for many, many Search Terms, EXCEPT when Form.st = "Attorney" OR Form.st = "Attorneys" !!! But Form.st = "Attorneys-Patent" works fine as does Form.st = "Attorney Referal Service" Is this someone's lawyer joke? HELP! best, paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Form.Fieldnames Missing
Your 3rd form has a field called UW_NOD_RESCIND_DATE that would never get passed IF form.fieldnames was passed (_date, _integer, _float, _time, _range, _eurodate are all naming convention to form inputs that will cause server side validation). That doesn't explain why the form.fieldnames never gets passed but you might try what Greg suggested and beginning by doing some renaming. I dont' think that's it because the it's missing on several different forms. Here's the debugging info. 1st form BROKER_POINTS=0 BROKERPYA=0 CALCULATE_FOR=BrokerPYA CALCVIAJS= CATEGORY= CLTV=0 COMMENTS= CONFIRMPASS= CREDIT_RISK= EMAIL= FAX= FIRST= HOW_HEAR= LAST= LOAN_AMOUNT=0 LTV=0 NEWPASS= OC= OTHER_CATEGORY= OTHER_FINANCING=No OTHER_FINANCING_AMOUNT= PHONE= PREPAYMENT_TERM= PREPAYMENT_TERM_ID=1 SAVE_SCENARIO_NUM=1 STATE=1 2nd form BANKRUPTCY=NO BANKRUPTCYDATE=mm/dd/yy BANKRUPTCYTYPE= BROKER_POINTS=0 BROKERPYA=0 CALCULATE_FOR=BrokerPYA CALCULATED=1 CALCVIAJS= CATEGORY= CLTV=0 COMMENTS= CONFIRMPASS= CREDIT_RISK= CREDITSCORE=670 DEBTRATIO=35 EMAIL= FAX= FIELDNAMES=CREDITSCORE,DEBTRATIO,THIRTYDAYS,SIXTYDAYS,NINETYDAYS,ONETWENTYDA YS,NOD,RESCINDDATE,BANKRUPTCY,BANKRUPTCYDATE,BANKRUPTCYTYPE,CALCULATED,SUBMI T FIRST= HOW_HEAR= LAST= LOAN_AMOUNT=0 LTV=0 NEWPASS= NINETYDAYS=0 NOD=NO OC= ONETWENTYDAYS=0 OTHER_CATEGORY= OTHER_FINANCING=No OTHER_FINANCING_AMOUNT= PHONE= PREPAYMENT_TERM= PREPAYMENT_TERM_ID=1 RESCINDDATE=mm/dd/yy SAVE_SCENARIO_NUM=1 SIXTYDAYS=0 STATE=1 SUBMIT=Calculate THIRTYDAYS=0 3rd form BANKRUPTCY_TYPE_ID=0 BORROWER_LASTNAME= BROKER_ID=112 BROKER_POINTS= .000 BROKER_PYA= BROKERPYA=0 CALCULATE_FOR=Broker PYA CALCVIAJS= CATEGORY= CLTV=0 CLTV_OTHER_FINANCING_AMT= COMMENTS= CONFIRMPASS= CREDIT_RISK=AAA EMAIL= FAX= FIRST= HOW_HEAR= INCOME_DOCUMENTATION= INCOME_DOCUMENTATION_ID= LAST= LOAN= LOAN_AMOUNT=0 LOAN_AMT=0 LOAN_PURPOSE_ID= LOAN_STATUS_ID=6 LTV=0 NEWPASS= OC= OCCUPANCY= OCCUPANCY_ID= OTHER_CATEGORY= OTHER_FINANCING=No OTHER_FINANCING_AMOUNT= OWNERS_ID=11 PHONE= PREPAYMENT_PENALTY=0 PREPAYMENT_TERM= PREPAYMENT_TERM_ID= PREQUAL_NUM=000407 PRODUCT= PRODUCT_ID= PROPERTY_LOCATION= PROPERTY_LOCATION_ID= PROPERTY_TYPE= PROPERTY_TYPE_ID= PROPERTY_VALUE= PURCHASE_PRICE=0 REQ_START_RATE= RISK_CODE=A RISKBANKRUPTCYDATE= RISKBANKRUPTCYTYPE= RISKBANKRUPTCYTYPEID=0 RISKCREDITSCORE=670 RISKDEBTRATIO=35 RISKNINETYDAYS=0 RISKNODRESCINDDATE= RISKONETWENTYDAYS=0 RISKSIXTYDAYS=0 RISKTHIRTYDAYS=0 SALES_PRICE= SAVE=Save SAVE_SCENARIO_NUM=1 SCENE_LTV=0 SCENE_UW_TIME={ts '2000-07-10 15:40:45'} START_RATE=0 STATE=1 STATE_ID=1 UW_BANKRUPTCY_RELEASE_DATE=NULL UW_CREDIT_SCORE=670 UW_DEBT_RATIO=35 UW_MORTGAGE_HIST_120=0 UW_MORTGAGE_HIST_30=0 UW_MORTGAGE_HIST_60=0 UW_MORTGAGE_HIST_90=0 UW_NOD_RESCIND_DATE=NULL YOUR_NAME= If you notice only the second form sends the field. --K Katrina Chapman Consultant Ameriquest Mortgage "Gregory Harris"To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .la.ca.us Subject: Re: Form.Fieldnames Missing 07/10/00 03:10 PM Please respond to cf-talk There is a default field in EVERY form passed via coldfusion called fieldnames, this contains a comma spliced list of all the fieldnames in the form. Your code could be causing a conflict with this default field. Would advise checking and renaming. Gregory Harris Los Angeles ITA Dept. [EMAIL PROTECTED] [EMAIL PROTECTED] 07/10 3:01 PM Is there a reason why the form.fieldnames field would not be passed in a form? --K Katrina Chapman Consultant Ameriquest Mortgage -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To
Re: Calculate Function on a form?
Send them to a 'Review' page that calculates every thing BEFIRE you submit the form as all CF is server side code. Stupid question... I've got a form that required a decent amount of calculations (figuring insurance premiums) to be done before it is submitted. Currently, I've written a JavaScript function that runs when I hit a "Calculate" button on the form. However, this is driving me absolutely NUTS in JavaScript, as it will calculate correctly except when one number is a multiple of ten or something..among other things... Is it possible in Cold Fusion to write a similar function that would run and do the calculations so the user could see the result before submitting the form? [button] onsubmit="calcform" or something? I know how to do it when I submit the form and get the results out the other side, but haven't exactly figured out how to get anything to run within the form Suggestions? Thanks! Les Mizzell *** Who needs Intel? Athlon Inside!!! -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: UPS Shipping Costs
Don't feel too bad...I'm up to 7 on many and climbing :( How many times are you going to send the exact same message? We're up to four at the moment. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Michael Chiu [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 01, 2000 16:22 To: CF-Talk Subject: UPS Shipping Costs My client registered as an end user, so I have access to the requirements for their different tools. I've run into a snag, and that also may be why you are getting the $0.00 returned. The tools require you to send it as url encoded type. I think it's something similar in function to the enctype you have to use when you use a browser for file uploads. Well, I had an example script, and I just use URLEncodedFormat on the fields that contained data that needed conversion, but that didn't satisfy the CGI script. It recognized that I wasn't sending an encoded format, so it stopped at that point. I've searched the documentation, and I can't see any way to use CFHTTP to pass the information properly. I don't know if this is a recent thing or not, but it bugs me. I had the UPS guy in a meeting, and he assured me that I wouldn't have any problems using Cold Fusion. At this point, I think I'm going to go the route of AbleShipper. The zones and rate tables are free on the UPS site, and it cannot be too hard to import those into a table once a year or so. Mike Chiu [EMAIL PROTECTED] http://yoyoman.insync.net "No one who believes in him will be put to shame." (Romans 10:11) -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Cold Fusion Server 4.5.1 DoS Vulnerability.
Why is it that when companies begin thinking they're God's gift to the world that they start giving answers like this? Reminds me of how Microsoft is currently... Allaire's Unofficial response to this bug: "What are the chances that 5 people would simultaneously request the same page?" -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: long tables and headings
You can always throw out a TH row every QueryName.CurrentRecord MOD 20 (or so) IS 0, assign an incrementing A Name="thisanchor" with Next|Previous|Top links Several of my applications list out a few hundred records in table format, the top row contains the headings. After scrolling down you loose the headings and are constantly scrolling up down up down to see the heading. Ive played with a this a little using a frame, it works ok but you must define everything to be the exact width height etc otherwise things dont line up, it creates lots of maintenance it seems and Id rather not use another frame for this. Is there some method for a floating heading bar anyone has discovered or some JavaScript that would pop up the heading when a link is clicked say in the first column or something like this...? How are people handling this, anything I can do with CF...? Thanks,Adrian -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: odbc error
Include the 'id' field as part of the aggregate function (sum, group by, avg, whatever) Can anyone give suggestions why I am getting the following error when selecting specific fields from an Access db, yet when I use a "select *" everything is fine? [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'id' as part of an aggregate function. thanks. Sincerely, Shane Witbeck Webmaster [EMAIL PROTECTED] www.digitalsanctum.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: MSIE Debug is a PIMA
Kill the process MDM (take it out of the Run or RunServices registry entry under HKEY_LOCAL_MACHINE/Software/Microsoft/Windows) Yes, but unfortunately that seems to also disable all those informative little pop-up errors like "object expected", which I'd like to keep. I just don't want it to load up the whole script debugger window if I click "yes". -Cameron Cameron Childress McRae Communications 770.460.7277 x.232 770.460.0963 fax -Original Message- From: Greg Creedon [mailto:[EMAIL PROTECTED]] Sent: Friday, May 05, 2000 10:04 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MSIE Debug is a PIMA tools -- internet options -- advanced -- browsing -- disable script debugging greg creedon piermont ny -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Friday, May 05, 2000 10:05 AM To: [EMAIL PROTECTED] Subject: OT: MSIE Debug is a PIMA Every now and then, when I'm adding javascript to my CF pages, I will do something wrong and get an error (Oh my!). I get the question "Do I want to debug?", and if I accidentally say yes, a Microsoft debugging environment window pops open, and when I close it, all my open explorer windows close as well. I have to open them back up, log back into what I was working on, and cuss at Bill. I'm sure I could figure it out if I looked hard enough, but where in the hell do I turn off this debugging "feature"? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Studio crashing with CFMLVALIDATOR.DLL
Hi Adrian, I haven't found a definite fix for the same problem yet...here's a thread to several link's at the Allaire support forums, some of them have a couple of dozen threads http://forums1.allaire.com/DevConf/Search_Results.cfm?#Message439148 Can someone remind me how to re-register the CFMLVALIDATOR.DLL after a corrupt installation of Studio? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.co.uk/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL! i'm losing it
Shawn, It may be parsing the field Group and confusing it with GROUP BY, a reserved phrase. I'd try changing the name of the field. I have checked and checked this but I cannot see anything wrong with this code: cfquery name="adduser" datasource="#DSN#" insert into users (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) values (#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstname)#','#trim(a ttributes.lastname)#','#trim(attributes.Title)#','#trim(attributes.email)#', '#trim(attributes.Password)#','#trim(attributes.userid)#',#trim(attributes.C lientID)#) /cfquery But I keep getting this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "insert into users (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) values (2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597',2)" Anyone see what I am missing? Shawn Regan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [RE: AOL and Caching]
I looked that page over...and notice that they don't cache ASP pages...so why special treatment for ASP pages and not for CF, iHTML, PHP, and other scripting engines? AOL does not cache objects containing a Question Mark. This is checked first, regardless of file extension / mime type. Most CFM's fall under this category ... however, your root page will probably not: ie: http://www.company.com/ Other than that, you can use those Cache-Control Headers Michael Sheldon mentioned below. You really should only need Cache-Control Headers for objects that don't contain question marks... More details on AOL's caching at: http://webmaster.info.aol.com/index.cfm?article=12 Thanks, Matt -- "Mike Sheldon" [EMAIL PROTECTED] wrote: The following has worked for me in preventing AOL from caching dynamic pages. Note that this must be included in ALL pages you do not wish to be cached. (I like to put it in Application.cfm) CFSET gmts = gettimezoneinfo() CFSET gmt = gmts.utcHourOffset CFIF gmt EQ 0 CFSET gmt = "" CFELSEIF gmt GT 0 CFSET gmt = "+" gmt /CFIF CFHEADER NAME="Pragma" VALUE="no-cache" CFHEADER NAME="Cache-Control" VALUE="no-cache, must-revalidate" CFHEADER NAME="Last-Modified" VALUE="#dateformat(now(), 'ddd, dd mmm ')# timeformat(now(), 'HH:mm:ss') GMT#gmt#" CFHEADER NAME="Expires" VALUE="Mon, 26 Jul 1997 05:00:00 GMT" Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Skip Ogden [mailto:[EMAIL PROTECTED]] Sent: Monday, May 01, 2000 18:55 To: [EMAIL PROTECTED] Subject: AOL and Caching I searched the archives (or should I say struggled through them) and found nothing. Is there something I need to know regarding CF and AOL? AOL seems to be caching templates and serving them instead of pulling up the latest and greatest. Thanks in advance. Skip Ogden -- -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: VB COM Examples
Try wrapping your CFWDDX arguments in double quotes...seemed like I got the same error without them... CFWDDX ACTION="CFML2WDDX" INPUT="#qry#" OUTPUT="qryWDDX" Ok, Making progress but left without the warm fuzzy feeling at the end of the day. Make that two days. Have a class in VB which is creating a formatted wddx packet, function as follows: Public Function GetData() As String Dim StrXml As String StrXml = "xmpwddxPacket version='1.0'header/headerdatarecordset rowCount='2' fieldNames='MESSAGE_ID,THREAD_ID'field name='MESSAGE_ID'number346/numbernumber347/number/fieldfield name='THREAD_ID'number162/numbernumber162/number/field/recordset /data/wddxPacket/xmp" GetData = StrXml End Function in the coldfusion I have a constructor and the call to the method retrurning the value as follows: cftry cfobject type="COM" name="VB_COM" class="VBCOM.XmlParsor" action="CREATE" cfset wddxText = VB_COM.GetData() cfcatch type="any" opps /cfcatch /cftry CFwddx ACTION='wddx2cfml' input=#wddxText# output='serializedrs' --- The recordset data is:...P CFOUTPUT query="serializedrs" #NAME#,#AGE#br /CFOUTPUTP Ok so here's the skinny,.the method returns the string wddxText, and it is indeed there. It is in the appropriate format, I tested with regular conversion with cfml query. However when I process the page with a com implemntation I get the following error: Error Diagnostic Information unknown element encountered Just so everyone knows, the line/string prints out just fine as variable unto itself i.e. cfoutput#wddxText/cfoutput. I also tried having the vb com object return a variant type as well instead of a string, that was not it either. Any ideas guys? Shannon -Original Message- From: WBB [mailto:[EMAIL PROTECTED]] Sent: Monday, May 01, 2000 4:05 PM To: [EMAIL PROTECTED] Subject: Re: VB COM Examples Hi Shannon, I don't know if that would work or not (I've never tried it) but you might consider sending the resultset or collection back as a formatted WDDX (a string works fine for this) packet and read the packet in with CF.. Examples, I am looking for examples of com implementation for coldfusion. I am working on a com object in VB, which has methods for returning a string for the coldfusion tags, this works fine. What I am looking for now is a way to return a resultset, or a collection for colfusion to loop through. Has anyone done this? Alaires site makes no referrence to it, although it does say it supports com implenetation. Shannon -- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL Error using 'Name' as field
Hi Pablo, GROUP BY is an aggregate SQL function and must include all fields found in the SELECT clause. SELECT Name, PackageSent FROM location WHERE NOT PackageSent IS NULL GROUP BY PackageSent, Name; I'm performing the following query to an Access database in a page: cfquery datasource="webtrack" name="pkg_recipients" SELECT Name, PackageSent FROM location WHERE NOT PackageSent IS NULL GROUP BY PackageSent; /cfquery However, I get this error when executing it: - Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'Name' as part of an aggregate function. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: AOL uses CF!
I believe it's specific to SQL...CF or probably ANY other scripting backend using ODBC as a transport would be vulnerable Now, to switch topics, what exactly is this "SQL Server exposed URL parameter hack"? This term doesn't ring any bells. Is this a CF specific issue? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: VB COM Examples
Hi Shannon, I don't know if that would work or not (I've never tried it) but you might consider sending the resultset or collection back as a formatted WDDX (a string works fine for this) packet and read the packet in with CF.. Examples, I am looking for examples of com implementation for coldfusion. I am working on a com object in VB, which has methods for returning a string for the coldfusion tags, this works fine. What I am looking for now is a way to return a resultset, or a collection for colfusion to loop through. Has anyone done this? Alaires site makes no referrence to it, although it does say it supports com implenetation. Shannon -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Thank you for choosing Smart Web Tech your online business provider. We have received you
Big hammer, please ;) Must smite. At 07:43 PM 5/1/00 -0500, you wrote: Thank you for choosing Smart Web Tech your online business provider. We have received your message our tech staff will get in touch with you as soon as possible. If you have any additional, questions please visit our website at www.SmartWebTech.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Is 4.5.1 Solid
Hi Jennifer, At 09:02 AM 4/10/00 -0700, you wrote: Hi Dick, We upgraded to 4.51 and it seemed to cure quite a few ills. So far no damage. We had previously installed the hot fixes for CFHTTP and CFMAIL and had switched some CFMAIL calls off to another machine so we didn't have many problems there. It now does allow the 20,000,000 AOL users that couldn't complete our pages do so...seems really strange to me that they would allow such crap to be issued as a release in the first place as an 'upgrade' ;) You can't really mean that. The problem is on AOL's end. CF Server now Oh yes...I really can mean it ;)...and the problem was with CFServer with O'Reilly's Website OR AOL fixed the problem as we were installing 4.51 ;) accommodates the problems on AOL's end. Do you honestly want Allaire to get accounts with every major ISP so they can check to see if the ISP's stupid procedures mess up the sites? I used to work at a hosting company and the Of course not...but I would think that they would test it on the LARGEST modem community in the world...duh! focus was on video hosting. Every time we had a broadcast, we would get inundated with tech support calls from AOL users asking us why our site was broken. You can't imagine how many times I had to explain to people exactly why they needed to get a real ISP. AOL uses cached proxy servers and it is bad bad bad. I also do tech support and know just how lame AOL users can be and have used that same explaination as you did ;), however, that doesn't cover the fact that submit buttons or graphics buttons or verity searches wouldn't work using an AOL account until we upgraded to 4.51 (they worked fine with 1.5, 2.0, 2.5, 3.0, 3.1, 4.0 and 4.1) from 4.5 The really funny calls were the AOL users who said "What do you mean you don't do tech support for AOL? You're the Internet, right?" I understand...we have several hundred customers that use our lines to connect to their AOL accounts and it's tough to explain to them why their AOL mail doesn't work ;) -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: US States Custom Tag or something else...
Bill, There's a tag in Allaire's gallery called CF_USAMap that should work just fine. I have a client that wants to use a Map of the US to act as a trigger for a database query, in other words if a client clicks on Texas, the would get all the records of companies that are in Texas. I just need to be able to change the links on each state really. I was just hoping that somebody may have one that is a bit more automated, or could point me to where I can get an image that I can then put the image map's into. TIA! Bill Killillay ICQ @ 8425781 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: No Nulls or Decimals for Numbers?
Hi Stuart, First, if you wish to use nulls in Access then you need to set the field up as Required:No If the field is set to currency and you're trying to put in integers then that should work. If you're trying to stuff the field with an amount using the DollarFormat that wont work. You can use the CF function Replace to rid yourself of the dollar sign and the commas, the stuff it into the field. Hey all, this is probably a bit of a beginner question... but where else should I ask right? I have a database (in Access) that I'm trying to put a bunch of prices into. And when I set the fields as integers, long integers,etc it says that they can't be null and I don't want to put a 0 in there. Also they can't be made into decimals either. The Dollar format just doesn't work, because it automatically puts in those dollar signs and throws everything off. Almost everything other than text wouldn't allow a null value. I need them as number values, so I can do the math with them. In the insert query though, if the number is blank, it doesn't put anything there, and I get to commas together and an error. Any help would be appreciated! Stuart. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Trouble uploading Mac Image Files.
Try using 'application/x-macbinary' in your ENCTYPE attribute of the FILE tag along with whatever else is there. Worked for me ;) I've been having trouble uploading image files to an NT Server from IE on the Mac, Netscape loads them fine. The problem then is not the difference in file storage formats between Mac and NT, but the way IE is encoding the images when it sends them. I've tried to look into its preferences and make sure the MIME format is correct and tried switching all sorts of different settings, but to no avail. Does somebody know how to tweak IE so that it sends them correctly. Thanks -Talha -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: 237 checkboxes
Optionally, you can name them all the same, assign them different values...any that are checked will have their values passed as a list. That way you only have 1 CFPARAM to worry about. I have search form that contains a large amount of yes/no check boxes -237 to be exact. It is to search the results of a survey that has 237 questions. Only when a checkbox is checked will data be sent from the form. Because of this I need to check if each variable is present. I can create 237 "CFIF IsDefined" statements to see if the variables are present. The other option is to set 237 CFPARAM variables to "NO" as default, and then create my dynamic SQL statements with CFIF tags checking for "YES". The problems with these two options is that they are slow and will take a long time to code. I was thinking: Is there a way to create a loop that will run through all the values from the form - creating a query and output for each one. Thanks, Dan -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Slightly OT...
Documentation is pretty much universal, feature set usually falls within a certain fixed set of parameters and any bugs are usually a subset of your own, just ask any grand parent ;) Contrats from Northern California ;) Everyone's in good condition, but as expected, the documentation is lousy... Documentation? :) Wouldn't do ya any good anyway. The feature set and bugs are different on each version and they seem to keep changing without notice. Congratulations and...good luck. Ken -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.