RE: SQL Server virus
Thank you Michael. I made it an SOT in case I was flamed by people. It's a sad fact that many installs of SQL Server, version 7 at least, are not as carefully wrapped up as they should be. The actual artical came from Australian IT - a well respected source of many things IT related downunder: http://australianit.news.com.au/ Just to let ppl know. The default install of Microsoft SQL Server (at least version 7, all I could afford) - the default super user/administrator settings are NOT secure. Further info at: http://www.fusionauthority.com/alert/index.cfm?alertid=109#security2 Kind regards, == Peter Tilbrook Macromedia ColdFusion Applications Developer 4/73 Tharwa Road Queanbeyan, NSW, 2620 Phone: (02) 6284 2727 Mobile: 0401 973 415 Email: [EMAIL PROTECTED] -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, 23 May 2002 6:08 PM To: CF-Talk Subject: Re: SQL Server virus Not too off topic. I posted this to the [EMAIL PROTECTED] list a day or so back and it's covered in the latest issue of Fusion Authority. As many CF programmers and shops use SQL, it's an important security issue. Thanks for posting it. __ 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: HELP! Searching for a Custom Tag
The classic - and class(y/ie)? CFX_DOC2HTML would also be gratefully purchased!!! == Peter Tilbrook Macromedia ColdFusion Applications Developer 4/73 Tharwa Road Queanbeyan, NSW, 2620 Phone: (02) 6284 2727 Mobile: 0401 973 415 Email: [EMAIL PROTECTED] -Original Message- From: Mallory Woods [mailto:[EMAIL PROTECTED]] Sent: Thursday, 23 May 2002 11:33 PM To: CF-Talk Subject: HELP! Searching for a Custom Tag Greetings All, I am looking for the custom tag called CFX_ParseHTML it appears that when we upgraded our server this tag Was not copied over.. I have been searching all over for it and every place I look no longer has the tag.. Does anyone have a working link or perhaps the file itself.. Thanks in Advance.. Mallory Woods __ 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: Recomend for those just starting ColdFusion, or experienced
Hasn't Ben himself indicated that an MX version of his own classic tome/s is due? Personally I am still having a ball with CF5. And the Forrest Gump soundtrack is recommended for easy listening during database design! -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Friday, 24 May 2002 2:28 AM To: CF-Talk Subject: Re: Recomend for those just starting ColdFusion, or experienced In all ego, I suggest getting this book as we're doing a great job with it. :) Outside of Ego, I suggest getting at least 2 or 3 of the MX books coming out. The logic is that there is so much to look at and cover that one book will most probably be missing things. And remember that these books are all business expense tax deductions. I'm declaring almost my entire Amazon bill from the last year on my taxes (and its all legal). :) I recommend this one http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 because I wrote it (Michael Dinowitz is doing a lot of the tech editing). I know that Ben Forta is updated his two popular books (WACK and Advanced Development). I would expect an update to Mastering ColdFusion and Programming ColdFusion. There are others listed on Amazon. __ 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
cfobject hanging CF5 server
Morning all, Has anyone ever come across a problem with running java with cfobject? At present we run a fair few java CFX tags which are all working perfectly, however, one of our sites uses a java class to encrypt user details and post them to a credit card processing company, this is done with cfobject, up until yesterday it's worked fine, after installing the latest MS security patches, cfobject simply hangs and eventually restarts the Coldfusion application server. We are using CF5 Enterprise on Win2K Server SP2, anyone got any ideas? Regards, Craig. __ 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/CFCATCH Database errors
If I've got a query and for some odd reason the database server goes down, of course my query will fail. How can I catch the error due to the server being down and display a static/temp page instead? My code is below and it appears to be correct but it will not catch the error and redirect. Remember that rubbish SQL will also cause a CFCATCH TYPE=database to hit I'm working with the presumption you're using CF5, as I'm not 100% sure this works with CF4.x What I'd suggest is looping through the CFCATCH.TagContent array and see what's in there for different errors, that way you know if the dbServer is down, or if it's rubbish SQL Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** __ 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: Repost: CFFTP 500 Invalid PORT Command.
Does anybody know what causes Error 500 invalid port Command using CFFTP? Which web server are you CFFTPing to Some don't allow FTP access unless it's got the proper header information Also, CFFTP requires a certain amount of responses to work, so if it's a limited FTP server, then it might be causing problems Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** __ 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
cfobject hanging CF5 server
Morning all, Has anyone ever come across a problem with running java with cfobject? At present we run a fair few java CFX tags which are all working perfectly, however, one of our sites uses a java class to encrypt user details and post them to a credit card processing company, this is done with cfobject, up until yesterday it's worked fine, after installing the latest MS security patches, cfobject simply hangs and eventually restarts the Coldfusion application server. We are using CF5 Enterprise on Win2K Server SP2, anyone got any ideas? My apologies if this is the 2nd version of this message, we're also having problems with our exchange server this morning. Regards, Craig. __ 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
update a dollarformat field
Hello, I must be missing some kind of syntax. Anyone can help please? I'm getting the error below when I do this update: cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Dollarformat(Costeach)# on a field that is dollar formatted as: input type=text name=costeach value=#Dollarformat(getpo.costeach)# The error is: An error occurred while evaluating the expression: #Dollarformat(Costeach)# Parameter 1 of function DollarFormat which is now $300.00 must be a number The error occurred while processing an element with a general identifier of (#Dollarformat(Costeach)#),... Thanks, Robert Orlini __ 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
DateAdd function
I have never used these functions much. The syntax looks just like the help files. cfset TodayPlus1 = DateAdd(d, 1, Today) Can I use the DateAdd function in a CFSET? I get this error: Error Diagnostic Information An error occurred while evaluating the expression: TodayPlus1 = DateAdd(d, 1, Today) Error near line 24, column 7. Error resolving parameter D ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: 1.. You have misspelled the parameter name, or 2.. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (CFSET), occupying document position (24:1) to (24:41). Thanks, Yves __ 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: update a dollarformat field
I think you don't need DollarFormat when updating only when displaying ie cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Costeach# ... Seamus At 10:09 pm 24/05/2002 , you wrote: Hello, I must be missing some kind of syntax. Anyone can help please? I'm getting the error below when I do this update: cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Dollarformat(Costeach)# on a field that is dollar formatted as: input type=text name=costeach value=#Dollarformat(getpo.costeach)# The error is: An error occurred while evaluating the expression: #Dollarformat(Costeach)# Parameter 1 of function DollarFormat which is now $300.00 must be a number The error occurred while processing an element with a general identifier of (#Dollarformat(Costeach)#),... Thanks, Robert Orlini __ 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: DateAdd function
cfset TodayPlus1 = DateAdd(d, 1, Today) -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 7:29 AM To: CF-Talk Subject: DateAdd function I have never used these functions much. The syntax looks just like the help files. cfset TodayPlus1 = DateAdd(d, 1, Today) Can I use the DateAdd function in a CFSET? I get this error: Error Diagnostic Information An error occurred while evaluating the expression: TodayPlus1 = DateAdd(d, 1, Today) Error near line 24, column 7. Error resolving parameter D ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: 1.. You have misspelled the parameter name, or 2.. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (CFSET), occupying document position (24:1) to (24:41). Thanks, Yves __ 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: DateAdd function
Ah man, The Quotes weren't in the help file I looked at, and my brain didn't click in to trying them. Cursed Brain!! Thanks Kevin! Yves - Original Message - From: Kevin Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 9:30 AM Subject: RE: DateAdd function cfset TodayPlus1 = DateAdd(d, 1, Today) -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 7:29 AM To: CF-Talk Subject: DateAdd function I have never used these functions much. The syntax looks just like the help files. cfset TodayPlus1 = DateAdd(d, 1, Today) Can I use the DateAdd function in a CFSET? I get this error: Error Diagnostic Information An error occurred while evaluating the expression: TodayPlus1 = DateAdd(d, 1, Today) Error near line 24, column 7. Error resolving parameter D ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: 1.. You have misspelled the parameter name, or 2.. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (CFSET), occupying document position (24:1) to (24:41). Thanks, Yves __ 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: update a dollarformat field
Good point. I removed the dollarformat and now have: SET Costeach = #form.Costeach# and I get this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '$0.00' Do I need a Trim function beforhand? Robert O. -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:30 AM To: CF-Talk Subject: Re: update a dollarformat field I think you don't need DollarFormat when updating only when displaying ie cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Costeach# .. Seamus At 10:09 pm 24/05/2002 , you wrote: Hello, I must be missing some kind of syntax. Anyone can help please? I'm getting the error below when I do this update: cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Dollarformat(Costeach)# on a field that is dollar formatted as: input type=text name=costeach value=#Dollarformat(getpo.costeach)# The error is: An error occurred while evaluating the expression: #Dollarformat(Costeach)# Parameter 1 of function DollarFormat which is now $300.00 must be a number The error occurred while processing an element with a general identifier of (#Dollarformat(Costeach)#),... Thanks, Robert Orlini __ 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: DateAdd function
No problem -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 7:38 AM To: CF-Talk Subject: Re: DateAdd function Ah man, The Quotes weren't in the help file I looked at, and my brain didn't click in to trying them. Cursed Brain!! Thanks Kevin! Yves - Original Message - From: Kevin Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 9:30 AM Subject: RE: DateAdd function cfset TodayPlus1 = DateAdd(d, 1, Today) -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 7:29 AM To: CF-Talk Subject: DateAdd function I have never used these functions much. The syntax looks just like the help files. cfset TodayPlus1 = DateAdd(d, 1, Today) Can I use the DateAdd function in a CFSET? I get this error: Error Diagnostic Information An error occurred while evaluating the expression: TodayPlus1 = DateAdd(d, 1, Today) Error near line 24, column 7. Error resolving parameter D ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: 1.. You have misspelled the parameter name, or 2.. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (CFSET), occupying document position (24:1) to (24:41). Thanks, Yves __ 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: Migrating from CF4.5+WinNT to CF5(or MX)/Linux
Well folks, I'm a bit stuck with retrieving data from a mySQL-datasource which was exported from ms-access via a little nifty utility called MyAccess. The problem is that the text in the db has german special characters. Since I exported the data to mySQL I'm able to retrieve all the data but the special-chars are shown as symbols 'n' stuff. I took textpad and looked into the data-files mySQL generates for the datasource and they do contain the german chars. Any help out there? Patric PS Hi Jerry, PS thanks for your reply. I'll make sure to have a close look at the PS db-structure before converting. PS Patric JJ I've done this on 5 projects, now. JJ The three things that bit me repeatedly: JJ Boolean types in Access were not the same in mySQL. Went with int (1/0). JJ Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. JJ Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) JJ But it really wasn't very difficult. JJ Jerry Johnson [EMAIL PROTECTED] 05/21/02 08:33AM JJ Hi fellows, JJ i looking for some advice on migrating websites of one of my customers JJ from windows to linux. The customers has it's own CF4.5Pro-Server and JJ 'cause he switched his entire office to linux he's also chenging the JJ webserver to linux with apache. The nice thing is, that is will JJ purchase/update to CF5 or MX. Now my question is will the applications JJ i wrote under Windows+Access run under Linux+MySQL without bigger JJ problems??? i have a event-calendar-app which will probably make no JJ trouble. but i have a little shopping-cart-like app with session-vars JJ and a full-text-search with verity. JJ So if anyone can share experience i would be really glad for any JJ input! JJ TIA -- Patric Stumpe 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
ot-Logout alert message
I have some js that checks the time an automatically logs out if there hasn't been any activity in the last 15 minutes. This sometimes takes people by surprise. I'd like to add something that either counts down There has not been any activity. You will be logged off in 15 seconds...14...13...12... or just a generic alert that does something like because there has been no activity you are going to be logged off- if this isn't correct please click on continue session Does anyone have this and would be willing to share it? Thanks, J __ 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: update a dollarformat field
do you have the dollar sign in the form? Try putting just the amount in the form - no dollar signs and see what happens Seamus At 10:36 pm 24/05/2002 , you wrote: Good point. I removed the dollarformat and now have: SET Costeach = #form.Costeach# and I get this error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '$0.00' Do I need a Trim function beforhand? Robert O. -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:30 AM To: CF-Talk Subject: Re: update a dollarformat field I think you don't need DollarFormat when updating only when displaying ie cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Costeach# .. Seamus At 10:09 pm 24/05/2002 , you wrote: Hello, I must be missing some kind of syntax. Anyone can help please? I'm getting the error below when I do this update: cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Dollarformat(Costeach)# on a field that is dollar formatted as: input type=text name=costeach value=#Dollarformat(getpo.costeach)# The error is: An error occurred while evaluating the expression: #Dollarformat(Costeach)# Parameter 1 of function DollarFormat which is now $300.00 must be a number The error occurred while processing an element with a general identifier of (#Dollarformat(Costeach)#),... Thanks, Robert Orlini __ 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: update a dollarformat field
I must be missing some kind of syntax. Anyone can help please? I'm getting the error below when I do this update: cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Dollarformat(Costeach)# on a field that is dollar formatted as: input type=text name=costeach value=#Dollarformat(getpo.costeach)# The error is: An error occurred while evaluating the expression: #Dollarformat(Costeach)# Parameter 1 of function DollarFormat which is now $300.00 must be a number The error occurred while processing an element with a general identifier of (#Dollarformat(Costeach)#),... First of all, what type of field is Costeach in the database? If it's a number, don't take DollarFormat anywhere near it! - you also should strip all , out of the numbers as SQL treats them as a field separater Starting a string with $ means it's not a number, you should strip those out before you do anything with them Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 24 May 2002 13:10 To: CF-Talk Subject: update a dollarformat field Hello, Thanks, Robert Orlini __ 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: update a dollarformat field
OK, now I understand. Costeach is a number in the Access table. However, is there any way to make the number, let's say 1300.50 appear as $1,300.50 when displayed, but as 1300.50 (stripped the $, etc) when updating? Thanks. Robert O. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:23 AM To: CF-Talk Subject: RE: update a dollarformat field I must be missing some kind of syntax. Anyone can help please? I'm getting the error below when I do this update: cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Dollarformat(Costeach)# on a field that is dollar formatted as: input type=text name=costeach value=#Dollarformat(getpo.costeach)# The error is: An error occurred while evaluating the expression: #Dollarformat(Costeach)# Parameter 1 of function DollarFormat which is now $300.00 must be a number The error occurred while processing an element with a general identifier of (#Dollarformat(Costeach)#),... First of all, what type of field is Costeach in the database? If it's a number, don't take DollarFormat anywhere near it! - you also should strip all , out of the numbers as SQL treats them as a field separater Starting a string with $ means it's not a number, you should strip those out before you do anything with them Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 24 May 2002 13:10 To: CF-Talk Subject: update a dollarformat field Hello, Thanks, Robert Orlini __ 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: ot-Logout alert message
With JavaScript this is tricky, but you could use something like this: SCRIPT LANGUAGE=JavaScript if (confirm('You have been inactibe for x minutes. Logout?')) { // logout code here }; /SCRIPT This only gives them OK or Cancel as options. I don't think you can prompt and set your own button labels. Also, since the message box is modal, I don't think the browser could not load a new page until the prompt was answered so you couldn't automatically send them to a logout page if they didn't respond. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:36 AM To: CF-Talk Subject: ot-Logout alert message I have some js that checks the time an automatically logs out if there hasn't been any activity in the last 15 minutes. This sometimes takes people by surprise. I'd like to add something that either counts down There has not been any activity. You will be logged off in 15 seconds...14...13...12... or just a generic alert that does something like because there has been no activity you are going to be logged off- if this isn't correct please click on continue session Does anyone have this and would be willing to share it? Thanks, J __ 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
Heirmenu
Hi, Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm using frames and my dropdown navigation menu is in the top frame and when clicked does *not* overlay the bottom frame. Is there a version of heirmenu that allows overlaying on frames? If so, which one? +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ 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: ot-Logout alert message
Er...what I meant was... ..Also, since the message box is modal, I don't think the browser can load a new page until the prompt is answered so you couldn't automatically send them to a logout page if they didn't respond... Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:36 AM To: CF-Talk Subject: ot-Logout alert message I have some js that checks the time an automatically logs out if there hasn't been any activity in the last 15 minutes. This sometimes takes people by surprise. I'd like to add something that either counts down There has not been any activity. You will be logged off in 15 seconds...14...13...12... or just a generic alert that does something like because there has been no activity you are going to be logged off- if this isn't correct please click on continue session Does anyone have this and would be willing to share it? Thanks, J __ 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: Heirmenu
Hi phumes1, I would assume that the dhtml-layer of the menu can't appear anywhere else than in it's own frame... Patric p Hi, p Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm p using frames and my dropdown navigation menu is in the top frame and when p clicked does *not* overlay the bottom frame. p Is there a version of heirmenu that allows overlaying on frames? If so, p which one? p +---+ p Philip Humeniuk p [EMAIL PROTECTED] p [EMAIL PROTECTED] p ++ p __ 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
Recursive querys (from Build a tree of nodes/subnodes)
Well, I guess this is off-topic and probably a bit basic, but how do you write a recursive query? I have a need for it but I don't know how to do it. My db is access 2000. Thanks, Matt Small -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 8:39 PM To: CF-Talk Subject: RE: Build a tree of nodes/subnodes Or you can write a recursive stored proc. You have to get a little creative with Temp Tables and cursors though... But it's been done. Shawn Grover -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:52 PM To: CF-Talk Subject: RE: Build a tree of nodes/subnodes At 06:48 PM 5/23/02, you wrote: I usually do a recursive custom tag to make my trees. I haven't tried using UDFs for it because of database calls, but with CFMX, I'm sure it would be The whole thing should only have a single DB call. Using a UDF on the results of the DB call is all that's needed. Unless I'm missing something in how your doing it. nice. I haven't used the nested sets model before, but I have briefly looked at it. My problem with it seems that it's not normalized at all. In that Intelligent Enterprise article, the lft and rgt columns seem like they could easily go out of wack if you're not careful. A single table with a recursive parent ID seems much logical. Sure, there are some more database calls, but it all depends on what you're trying to do. For example, we have an application with an advanced permissions system that involves cascading permissions and some other tidbits. When the user logs in, their permissions are pulled through recursive custom tags and set to the session scope. It's a one time thing for each login so any extra load is really not noticeable. Ben Johnson Hostworks, Inc. __ 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: ot-Logout alert message
Alright, this is my LAST correction...this is getting ridiculous, but it IS Friday... With JavaScript this is tricky, but you could use something like this: SCRIPT LANGUAGE=JavaScript if (confirm('You have been inactibe for x minutes. Logout?')) { // logout code here }else { // continue code here, if any } /SCRIPT This only gives them OK or Cancel as options. I don't think you can prompt and set your own button labels. Also, since the message box is modal, I don't think the browser can load a new page until the prompt is answered so you couldn't automatically clear the prompt and send them to a logout page if they didn't respond. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:36 AM To: CF-Talk Subject: ot-Logout alert message I have some js that checks the time an automatically logs out if there hasn't been any activity in the last 15 minutes. This sometimes takes people by surprise. I'd like to add something that either counts down There has not been any activity. You will be logged off in 15 seconds...14...13...12... or just a generic alert that does something like because there has been no activity you are going to be logged off- if this isn't correct please click on continue session Does anyone have this and would be willing to share it? Thanks, J __ 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: Heirmenu
In this version, correct. At 03:34 PM 5/24/2002 +0200, you wrote: Hi phumes1, I would assume that the dhtml-layer of the menu can't appear anywhere else than in it's own frame... Patric p Hi, p Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm p using frames and my dropdown navigation menu is in the top frame and when p clicked does *not* overlay the bottom frame. p Is there a version of heirmenu that allows overlaying on frames? If so, p which one? p +---+ p Philip Humeniuk p [EMAIL PROTECTED] p [EMAIL PROTECTED] p ++ p __ 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: Heirmenu
Well, there'll be nothing (at the moment) that can be rendered partly out of it's own frame. This needs to be implementet in the browsers rendering-engine Patric p In this version, correct. p At 03:34 PM 5/24/2002 +0200, you wrote: Hi phumes1, I would assume that the dhtml-layer of the menu can't appear anywhere else than in it's own frame... Patric p Hi, p Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm p using frames and my dropdown navigation menu is in the top frame and when p clicked does *not* overlay the bottom frame. p Is there a version of heirmenu that allows overlaying on frames? If so, p which one? p +---+ p Philip Humeniuk p [EMAIL PROTECTED] p [EMAIL PROTECTED] p ++ p p __ 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: Heirmenu
I believe you will encounter the same problem in all versions of the menu. I do not think it is possible to script a layer to cross the frame since it is essentially another document. Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. __ 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: update a dollarformat field
Yes in the Query you would use: #Costeach# When displaying #Dollarformat(Costeach)# AS LONG AS Costeach in a numeric field in the database. If it is a MONEY this try using: #VAL(CostEach)# Randy Adkins [EMAIL PROTECTED] 05/24/02 09:16 AM OK, now I understand. Costeach is a number in the Access table. However, is there any way to make the number, let's say 1300.50 appear as $1,300.50 when displayed, but as 1300.50 (stripped the $, etc) when updating? Thanks. Robert O. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:23 AM To: CF-Talk Subject: RE: update a dollarformat field I must be missing some kind of syntax. Anyone can help please? I'm getting the error below when I do this update: cfquery name=update datasource=purchases UPDATE purchases SET Costeach = #Dollarformat(Costeach)# on a field that is dollar formatted as: input type=text name=costeach value=#Dollarformat(getpo.costeach)# The error is: An error occurred while evaluating the expression: #Dollarformat(Costeach)# Parameter 1 of function DollarFormat which is now $300.00 must be a number The error occurred while processing an element with a general identifier of (#Dollarformat(Costeach)#),... First of all, what type of field is Costeach in the database? If it's a number, don't take DollarFormat anywhere near it! - you also should strip all , out of the numbers as SQL treats them as a field separater Starting a string with $ means it's not a number, you should strip those out before you do anything with them Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 24 May 2002 13:10 To: CF-Talk Subject: update a dollarformat field Hello, Thanks, Robert Orlini __ 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: Heirmenu
Check out http://www.burmees.nl/menu/menus.htm. These DHTML menus appear to work across frames. They are quite ingenious. -Original Message- From: Patric Stumpe [SMTP:[EMAIL PROTECTED]] Sent: 24 May 2002 14:55 To: CF-Talk Subject: Re: Heirmenu Well, there'll be nothing (at the moment) that can be rendered partly out of it's own frame. This needs to be implementet in the browsers rendering-engine Patric p In this version, correct. p At 03:34 PM 5/24/2002 +0200, you wrote: Hi phumes1, I would assume that the dhtml-layer of the menu can't appear anywhere else than in it's own frame... Patric p Hi, p Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm p using frames and my dropdown navigation menu is in the top frame and when p clicked does *not* overlay the bottom frame. p Is there a version of heirmenu that allows overlaying on frames? If so, p which one? p +--- + p Philip Humeniuk p [EMAIL PROTECTED] p [EMAIL PROTECTED] p +--- -+ p p __ 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: ahhh query
Dooh, Beat me to it! I'll post it anyway. cfset places=querynew('name') cfset temp = QueryAddRow(places,4) cfset temp = QuerySetCell(places, 'name', 'University of Alabama The', 1) cfset temp = QuerySetCell(places, 'name', 'Florida State University', 2) cfset temp = QuerySetCell(places, 'name', 'The BlahBlah Institute', 3) cfset temp = QuerySetCell(places, 'name', 'The University of Chicago', 4) cfset re = ^(University of|The University of|The) CFOUTPUT query=places #name##left(rereplace(name,re,,all),1)#br /CFOUTPUT Results: University of Alabama The A Florida State University F The BlahBlah Institute B The University of Chicago C DRE -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 3:36 PM To: CF-Talk Subject: Re: ahhh query That was in neither English nor Geek. I'll try again. cfparam name=letter default=A cfset ignoreWordList=university,of,the,college,institute cfquery name=qSchools datasource=... select * from schools where I care /cfquery cfset newNameList=ValueList(qSchools.name,|) cfloop index=word list=#ignoreWordList# cfset newNameList=replace(newNameList,word,,ALL) /cfloop cfset newNameArray=listToArray(newNameList,|) cfset temp=queryAddColumn(qSchools,newName,newNameArray) cfquery name=AlphaSchools datasource= dbtype=query select * from qSchools where left(newName,1)='#letter#' order by name /cfquery Jerry Johnson [EMAIL PROTECTED] 05/23/02 05:27PM There are smarter/faster/bettter ways. But here is one. Create a second field, and have that be the name for selection purposes. Then sort by actual name. When you insert into the db, put the data in two fields, RealName and NewName. If you don't want to precalc this data, or can't , you can do it live, but it will cost. I think a simple mask of words you DONT care about can solve this. Build a list of words that do not matter for the sort. cfset IgnoreList=university,of,the,college,institute select em all. create a list of the name column ValueList() replace each word in the ignore list with (cfloop through ignore list, replacing with newNameList with ) list to array add a column to the query, populating with array (queryAddColumn query of query to get the list for A, order by original name field It ain't quick, but it might work. [EMAIL PROTECTED] 05/23/02 05:05PM bla... I have a template topped by the alphabet, all letters are links and they need to display the correct info from the database on the page when clicked, However the info that is being sorted will be names such as. University of Alabama (A) Florida State University (F) The BlahBlah Institute(B) The University of Chicago (C) so basically the word I need to check the first letter of could be ANYHWERE in the name ANY and ALL ideas are appreciated...(short of finding a new line of work) : ) __ 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: update a dollarformat field
OK, now I understand. Costeach is a number in the Access table. However, is there any way to make the number, let's say 1300.50 appear as $1,300.50 when displayed, but as 1300.50 (stripped the $, etc) when updating? What you have to do is before you update; form.CostEach=ReplaceList(form.CostEach,$,,all); form.CostEach=ReplaceList(form.CostEachall); That way it's removed the excess characters Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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 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
SOT: Oracle query question
Lowdown: What is the optimum arrangement of WHERE clauses when querying an Oracle database? Details: I'm trying to optimize my CF queries running against an Oracle 8i database. I know that conventional wisdom is to put highly selective columns (those with many unique values) first in the WHERE clause so that the result set is as small as possible for the following clauses. But I recall reading somewhere that Oracle actually processes WHERE clauses in reverse order--from last to first. Does anyone on the list know for sure about this? And does the order/placement of indexed columns significantly affect the query speed? Thanks, Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com __ 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
damn Netscape 4.x!
All, I have a page that displays perfectly in IE 5.5, but shows up blank in Netscape 4.79. Not only does it render blank, but it takes about 30 seconds to render blank. (no dynamic content). When I do a View Source in Netscape, the source is there. However, in the browser, I am only seeing the background color. I know that open ended table tags have caused this problem for me in the past, but there are no problems with table tags in this document. All the CSS elements linked to the page pass the TopStyle3 NN4.x validation, and the page's HTML passes the CFStudio 5 Document validation. Can anyone think of some other reasons this might be happening?? Thanks! v/r, Jeff Brown RMC, Inc. 46970 Bradley Blvd., Suite B Lexington Park, MD 20653 voice: 301.862.7501 fax: 301.862.5759 __ 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: RegExp Help
- Original Message - From: Matthew Walker [EMAIL PROTECTED] cfset content=REReplaceNoCase(content, a href=([^ ]*) ([^]*), a href=\1%20\2, all) This will only replace one space per anchor. You need to run it repeatedly to get them all. - I ended up with a similar solution in replying to the original poster - with a conditional loop wrapped around it running REFind with the same regexp. Just curious: do you know why you have to loop around, even with the ALL scope set in REReplace? What's the point of the ALL bit? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Oracle query question
Lowdown: What is the optimum arrangement of WHERE clauses when querying an Oracle database? Details: I'm trying to optimize my CF queries running against an Oracle 8i database. I know that conventional wisdom is to put highly selective columns (those with many unique values) first in the WHERE clause so that the result set is as small as possible for the following clauses. But I recall reading somewhere that Oracle actually processes WHERE clauses in reverse order--from last to first. Does anyone on the list know for sure about this? And does the order/ placement of indexed columns significantly affect the query speed? I sincerely doubt that any modern enterprise database platform (Oracle, Sybase, MS SQL Server for example) will favor one ordering of joins or filters over another. I don't know that for sure, but that's my strong suspicion. In any case, this is easy enough to determine. Just write the same query twice, and test it with Oracle's equivalent of SHOWPLAN, whatever that is (EXPLAIN PLAN, maybe?). I'll bet that the two queries will have the same query plan, and will perform equally well. 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: ahhh query
Wow, you do know that cfscript would clean up that code something fierce. cfscript places = queryNew(name); queryAddRow(places, 4); querySetCell(places, 'name', 'University of Alabama The', 1); querySetCell(places, 'name', 'Florida State University', 2); querySetCell(places, 'name', 'The BlahBlah Institute', 3); querySetCell(places, 'name', 'The University of Chicago', 4); /cfscript cfscript is your friend. Don't fear it. :-) Sharon - Original Message - From: Andre Turrettini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 10:21 AM Subject: RE: ahhh query Dooh, Beat me to it! I'll post it anyway. cfset places=querynew('name') cfset temp = QueryAddRow(places,4) cfset temp = QuerySetCell(places, 'name', 'University of Alabama The', 1) cfset temp = QuerySetCell(places, 'name', 'Florida State University', 2) cfset temp = QuerySetCell(places, 'name', 'The BlahBlah Institute', 3) cfset temp = QuerySetCell(places, 'name', 'The University of Chicago', 4) cfset re = ^(University of|The University of|The) CFOUTPUT query=places #name##left(rereplace(name,re,,all),1)#br /CFOUTPUT Results: University of Alabama The A Florida State University F The BlahBlah Institute B The University of Chicago C DRE -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 3:36 PM To: CF-Talk Subject: Re: ahhh query That was in neither English nor Geek. I'll try again. cfparam name=letter default=A cfset ignoreWordList=university,of,the,college,institute cfquery name=qSchools datasource=... select * from schools where I care /cfquery cfset newNameList=ValueList(qSchools.name,|) cfloop index=word list=#ignoreWordList# cfset newNameList=replace(newNameList,word,,ALL) /cfloop cfset newNameArray=listToArray(newNameList,|) cfset temp=queryAddColumn(qSchools,newName,newNameArray) cfquery name=AlphaSchools datasource= dbtype=query select * from qSchools where left(newName,1)='#letter#' order by name /cfquery Jerry Johnson [EMAIL PROTECTED] 05/23/02 05:27PM There are smarter/faster/bettter ways. But here is one. Create a second field, and have that be the name for selection purposes. Then sort by actual name. When you insert into the db, put the data in two fields, RealName and NewName. If you don't want to precalc this data, or can't , you can do it live, but it will cost. I think a simple mask of words you DONT care about can solve this. Build a list of words that do not matter for the sort. cfset IgnoreList=university,of,the,college,institute select em all. create a list of the name column ValueList() replace each word in the ignore list with (cfloop through ignore list, replacing with newNameList with ) list to array add a column to the query, populating with array (queryAddColumn query of query to get the list for A, order by original name field It ain't quick, but it might work. [EMAIL PROTECTED] 05/23/02 05:05PM bla... I have a template topped by the alphabet, all letters are links and they need to display the correct info from the database on the page when clicked, However the info that is being sorted will be names such as. University of Alabama (A) Florida State University (F) The BlahBlah Institute(B) The University of Chicago (C) so basically the word I need to check the first letter of could be ANYHWERE in the name ANY and ALL ideas are appreciated...(short of finding a new line of work) : ) __ 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: Oracle query question
You're right, Oracle reads from the bottom up. It's good practice to place your most limiting conditions at the end of the where clause, and work your way up from there. v/r, Jeff -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:34 AM To: CF-Talk Subject: SOT: Oracle query question Lowdown: What is the optimum arrangement of WHERE clauses when querying an Oracle database? Details: I'm trying to optimize my CF queries running against an Oracle 8i database. I know that conventional wisdom is to put highly selective columns (those with many unique values) first in the WHERE clause so that the result set is as small as possible for the following clauses. But I recall reading somewhere that Oracle actually processes WHERE clauses in reverse order--from last to first. Does anyone on the list know for sure about this? And does the order/placement of indexed columns significantly affect the query speed? Thanks, Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com __ 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: damn Netscape 4.x!
Sample code? It could be one tiny little forgotten tag .. Or something not closed correctly One of the useful things about DWMX, .. Is when I open code up in it ... If any of the tags are not nested correctly .. Or not closed properly .. It highlights it. Found quite a few errors like this that I didn't even know existed ... .. Erika | -Original Message- | From: Jeff Brown [mailto:[EMAIL PROTECTED]] | Sent: 24 May 2002 15:40 | To: CF-Talk | Subject: damn Netscape 4.x! | | | All, | | I have a page that displays perfectly in IE 5.5, but shows | up blank in Netscape 4.79. Not only does it render blank, | but it takes about 30 seconds to render blank. (no dynamic | content). When I do a View Source in Netscape, the source | is there. However, in the browser, I am only seeing the | background color. | | I know that open ended table tags have caused this | problem for me in the past, but there are no problems with | table tags in this document. All the CSS elements linked | to the page pass the TopStyle3 NN4.x validation, and the | page's HTML passes the CFStudio 5 Document validation. Can | anyone think of some other reasons this might be | happening?? Thanks! | | v/r, Jeff Brown | RMC, Inc. | 46970 Bradley Blvd., Suite B | Lexington Park, MD 20653 | voice: 301.862.7501 | fax: 301.862.5759 | | __ 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: damn Netscape 4.x!
I have a page that displays perfectly in IE 5.5, but shows up blank in Netscape 4.79. Not only does it render blank, but it takes about 30 seconds to render blank. (no dynamic content). When I do a View Source in Netscape, the source is there. However, in the browser, I am only seeing the background color. I know that open ended table tags have caused this problem for me in the past, but there are no problems with table tags in this document. All the CSS elements linked to the page pass the TopStyle3 NN4.x validation, and the page's HTML passes the CFStudio 5 Document validation. Can anyone think of some other reasons this might be happening?? Thanks! Run it through the validator in Studio, that usually points out mistakes NS also doesn't like open td or tr tags - that can screw up a page Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** __ 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: ot-Logout alert message
Thanks, but gee doesn't but I guess that defeats the purpose? Works ok as long as you want the person to respond- but it needs to logout of the applicaton if the user has walked away from their computer -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 9:39 AM To: CF-Talk Subject: RE: ot-Logout alert message Alright, this is my LAST correction...this is getting ridiculous, but it IS Friday... With JavaScript this is tricky, but you could use something like this: SCRIPT LANGUAGE=JavaScript if (confirm('You have been inactibe for x minutes. Logout?')) { // logout code here }else { // continue code here, if any } /SCRIPT This only gives them OK or Cancel as options. I don't think you can prompt and set your own button labels. Also, since the message box is modal, I don't think the browser can load a new page until the prompt is answered so you couldn't automatically clear the prompt and send them to a logout page if they didn't respond. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:36 AM To: CF-Talk Subject: ot-Logout alert message I have some js that checks the time an automatically logs out if there hasn't been any activity in the last 15 minutes. This sometimes takes people by surprise. I'd like to add something that either counts down There has not been any activity. You will be logged off in 15 seconds...14...13...12... or just a generic alert that does something like because there has been no activity you are going to be logged off- if this isn't correct please click on continue session Does anyone have this and would be willing to share it? Thanks, J __ 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: update a dollarformat field
Thanks much Phillip. One further question though. In Access I have the costeach field setup as numeric. Each time a figure is entered with cents after, it rounds it off to the next amount (350.60 becomes 360). How can I keep it as 350.50 and then at some point have this number calculated via a qty number and total? Robert O. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:35 AM To: CF-Talk Subject: RE: update a dollarformat field OK, now I understand. Costeach is a number in the Access table. However, is there any way to make the number, let's say 1300.50 appear as $1,300.50 when displayed, but as 1300.50 (stripped the $, etc) when updating? What you have to do is before you update; form.CostEach=ReplaceList(form.CostEach,$,,all); form.CostEach=ReplaceList(form.CostEachall); That way it's removed the excess characters Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** __ 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: damn Netscape 4.x!
Can you post a link? -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:40 AM To: CF-Talk Subject: damn Netscape 4.x! All, I have a page that displays perfectly in IE 5.5, but shows up blank in Netscape 4.79. Not only does it render blank, but it takes about 30 seconds to render blank. (no dynamic content). When I do a View Source in Netscape, the source is there. However, in the browser, I am only seeing the background color. I know that open ended table tags have caused this problem for me in the past, but there are no problems with table tags in this document. All the CSS elements linked to the page pass the TopStyle3 NN4.x validation, and the page's HTML passes the CFStudio 5 Document validation. Can anyone think of some other reasons this might be happening?? Thanks! __ 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
OT: XML Weather....
Do any of you fine people know of a free XML European wide weather feed? TIA J __ 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: ot-Logout alert message
Janine: If you're trying to stick with your existing JS functionality and keep it all JS, then I don't know of any other option for prompting because any JS prompt will be modal. You could try writing your countdown to the status bar but it may not be noticed by the user or they may have their status bar hidden. Or you can open a new window and write the prompt to it. Not real tidy but it may be your only other option without going to something like Java. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:42 AM To: CF-Talk Subject: RE: ot-Logout alert message Thanks, but gee doesn't but I guess that defeats the purpose? Works ok as long as you want the person to respond- but it needs to logout of the applicaton if the user has walked away from their computer -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 9:39 AM To: CF-Talk Subject: RE: ot-Logout alert message Alright, this is my LAST correction...this is getting ridiculous, but it IS Friday... With JavaScript this is tricky, but you could use something like this: SCRIPT LANGUAGE=JavaScript if (confirm('You have been inactibe for x minutes. Logout?')) { // logout code here }else { // continue code here, if any } /SCRIPT This only gives them OK or Cancel as options. I don't think you can prompt and set your own button labels. Also, since the message box is modal, I don't think the browser can load a new page until the prompt is answered so you couldn't automatically clear the prompt and send them to a logout page if they didn't respond. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 8:36 AM To: CF-Talk Subject: ot-Logout alert message I have some js that checks the time an automatically logs out if there hasn't been any activity in the last 15 minutes. This sometimes takes people by surprise. I'd like to add something that either counts down There has not been any activity. You will be logged off in 15 seconds...14...13...12... or just a generic alert that does something like because there has been no activity you are going to be logged off- if this isn't correct please click on continue session Does anyone have this and would be willing to share it? Thanks, J __ 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: damn Netscape 4.x!
not just table tags that will cause problems. also td's and tr's. I would take the netscape source and paste into a temp.htm page and start commentin out lines until you track down the issue. I feel for ya. I had a very late nite last week with the same issue. Sean -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:59 AM To: CF-Talk Subject: RE: damn Netscape 4.x! Can you post a link? -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:40 AM To: CF-Talk Subject: damn Netscape 4.x! All, I have a page that displays perfectly in IE 5.5, but shows up blank in Netscape 4.79. Not only does it render blank, but it takes about 30 seconds to render blank. (no dynamic content). When I do a View Source in Netscape, the source is there. However, in the browser, I am only seeing the background color. I know that open ended table tags have caused this problem for me in the past, but there are no problems with table tags in this document. All the CSS elements linked to the page pass the TopStyle3 NN4.x validation, and the page's HTML passes the CFStudio 5 Document validation. Can anyone think of some other reasons this might be happening?? Thanks! __ 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
Logging user footprints
Hi all, I'm currently working on an enterprise level (clusterable and such) security system and I'm working on the application logging aspect of it now. I've built several security systems in the past and have done logging before so it's no big deal. Typically I'll log the remote_address, http_referer, http_user_agent, script_name, query_string, date/time and some other application specific items. My question is whether or not you guys see anything I could add to this list. I have a custom tag that logs every action the user takes in the system so I have the action information as well. I'm just not sure if I'm missing anything. Any thoughts? ~Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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: Logging user footprints
If you have more than one URL/IP pointing at the same site, you might want to log the server_name. Or even if you want to know if they came in as IP #s or domain name. Jerry Johnson [EMAIL PROTECTED] 05/24/02 11:26AM Hi all, I'm currently working on an enterprise level (clusterable and such) security system and I'm working on the application logging aspect of it now. I've built several security systems in the past and have done logging before so it's no big deal. Typically I'll log the remote_address, http_referer, http_user_agent, script_name, query_string, date/time and some other application specific items. My question is whether or not you guys see anything I could add to this list. I have a custom tag that logs every action the user takes in the system so I have the action information as well. I'm just not sure if I'm missing anything. Any thoughts? ~Jason !--- Jason Dowdell [EMAIL PROTECTED] 321.799.6845 IM AES - Web Developer --- __ 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
OT: Search Engines
Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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: Search Engines
Try http://www.searchengineworld.com a good amount of information. Good Luck Paul Giesenhagen QuillDesign - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 11:05 AM Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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
cftransaction and single thread
I cant find in any of the books if all the queries in a CFTransaction block are single threaded. Like if i have three querys in the CFTransaction: cftransaction Query #1: Insert into DB Query #2: Select from DB to get highest number of Query #1 and increment by 1 Query #3: Insert into DB using the UID created in query #2 /cftransaction Will CFTransaction Only allow user 1 to do this, and user 2 has to wait? Im afraid Query #2 will get bad data. Will CFLOCK around a CFTransaction help? Thanks! __ 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: Search Engines
This site is pretty nice http://www.searchengineworld.com/ the thing is though, the biggest place for you to get higher ranking is from reciprical links. So you would need to do a type of link exchange program between like sites or customers. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 12:05 PM To: CF-Talk Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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: Search Engines
Also http://searchenginewatch.com/ Shawn McKee -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 11:00 AM To: CF-Talk Subject: Re: Search Engines Try http://www.searchengineworld.com a good amount of information. Good Luck Paul Giesenhagen QuillDesign - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 11:05 AM Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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: Search Engines
WordTracker.com is an essential tool. cf_plug There are also firms (like ours) that can do this for you. It's not that expensive... /cf_plug -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 9:05 AM To: CF-Talk Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [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: Search Engines
www.searchenginewatch.com He has a newsletter too. Pretty interesting each month. Dave - Original Message - From: Douglas Brown [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 12:05 PM Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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
True Combobox for HTML?
Anyone know of a custom tag or something that offers a true combo box for HTML? The tags I have seen in the exchange are typically a text box which will use JS to select the appropriate item in a select box. However, we need to allow our users to type a value into a combo box, where the value is either a new value, or an existing value. If it's an existing value, then we need it to auto fill the text entry area with the nearest matching value as the user types. In VB, I'd use the combo box in it's default style. Thanks. Shawn Grover __ 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: cftransaction and single thread
I cant find in any of the books if all the queries in a CFTransaction block are single threaded. Like if i have three querys in the CFTransaction: cftransaction Query #1: Insert into DB Query #2: Select from DB to get highest number of Query #1 and increment by 1 Query #3: Insert into DB using the UID created in query #2 /cftransaction Will CFTransaction Only allow user 1 to do this, and user 2 has to wait? CFTRANSACTION does all queries one after the other - if one fails it rolls it back What db Engine are you running, if it's a real engine like SQL Server or Oracle, you can do query 1 and 2 in the same SQL block, meaning you don't need the CFTransaction Im afraid Query #2 will get bad data. Will CFLOCK around a CFTransaction help? CFLOCK is only to do with Application, Client and Session variables - it and CFTRANSACTION have nothing to do with each other (unless you're putting a query into one of those scopes, in which case - DON'T do it via CFQUERY) Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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 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: Search Engines
check out http://www.rolist.com rotating search engine. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 12:05 PM To: CF-Talk Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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
Who do we contact to report abuse on the MM Exchange?
Does anyone know the contact email to report problems on the MM Developer's Exchange? In particular, I found a custom tag (Combo Box by Dave Miller) where if you click the View Example link, you get nailed with pop-up ads (about 6 of them), and never do get to view an example of the combo box. Or, if the sample is there, it get's lost in the clutter. And of course, the pop-ups are loosely associated with adult content (meaning it's not as explicit as some I've seen). To be fair, I cannot say if Dave Miller is the person responsible for this situation. But, the situation exists, and is not helpful when people are looking for a combo box, so should be rectified. (maybe I'm just having a bad day though... ). Thanks for the input. Shawn Grover __ 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: update a dollarformat field
robert, i guess phillip got busy :)...so i'll pinch hit for him... in access design view, click on the field name then make sure field size (general tab) is set to long integer and decimal places is set to auto. that should eliminate your problem with rounding. if you want to multiply the value of costeach by a qty and project the result as a total, you would do this in the select statement of your query: sum(costeach * qty) as total_costeach then reference total_costeach for display. just be sure to list any non-aggregate columns projected in your select statement in a group by. ~ dina - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 9:47 AM Subject: RE: update a dollarformat field Thanks much Phillip. One further question though. In Access I have the costeach field setup as numeric. Each time a figure is entered with cents after, it rounds it off to the next amount (350.60 becomes 360). How can I keep it as 350.50 and then at some point have this number calculated via a qty number and total? Robert O. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:35 AM To: CF-Talk Subject: RE: update a dollarformat field OK, now I understand. Costeach is a number in the Access table. However, is there any way to make the number, let's say 1300.50 appear as $1,300.50 when displayed, but as 1300.50 (stripped the $, etc) when updating? What you have to do is before you update; form.CostEach=ReplaceList(form.CostEach,$,,all); form.CostEach=ReplaceList(form.CostEachall); That way it's removed the excess characters Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. * * 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. * * __ 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: Who do we contact to report abuse on the MM Exchange?
There is an address you could write for such thing, but I don't have it in front of me. Send the specifics to me, I'll forward it to the correct folks. Thanks! Vernon Viehe Community Manager Macromedia, Inc. [EMAIL PROTECTED] -Original Message- From: Shawn Grover To: CF-Talk Sent: 5/24/2002 9:41 AM Subject: Who do we contact to report abuse on the MM Exchange? Does anyone know the contact email to report problems on the MM Developer's Exchange? In particular, I found a custom tag (Combo Box by Dave Miller) where if you click the View Example link, you get nailed with pop-up ads (about 6 of them), and never do get to view an example of the combo box. Or, if the sample is there, it get's lost in the clutter. And of course, the pop-ups are loosely associated with adult content (meaning it's not as explicit as some I've seen). To be fair, I cannot say if Dave Miller is the person responsible for this situation. But, the situation exists, and is not helpful when people are looking for a combo box, so should be rectified. (maybe I'm just having a bad day though... ). Thanks for the input. Shawn Grover __ 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: True Combobox for HTML?
depending on your audience... i.e. IE only as i dont think this works on Netscape.. http://www.devguru.com/Features/tutorials/ComboControl/combocontrol.html Shawn Grover wrote: Anyone know of a custom tag or something that offers a true combo box for HTML? The tags I have seen in the exchange are typically a text box which will use JS to select the appropriate item in a select box. However, we need to allow our users to type a value into a combo box, where the value is either a new value, or an existing value. If it's an existing value, then we need it to auto fill the text entry area with the nearest matching value as the user types. In VB, I'd use the combo box in it's default style. Thanks. Shawn Grover __ 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: update a dollarformat field
i guess phillip got busy :)...so i'll pinch hit for him... Oops, missed that one... Thanks for catching it for me Dina Also, my Access skills are a little rusty as I've not really used it for close on 3 years now g Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** __ 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
OT: Access SQL stored procs
Hey CF people, Happy Friday!! Well I have a question about access. I thought I saw something or read something about use the access query objects as stored procs. Has anyone done this and if so can you share? TIA Shawn Regan __ 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: Search Engines
Uh - it's a domain name for sale . . . . Daved - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 12:11 PM Subject: RE: Search Engines WordTracker.com is an essential tool. cf_plug There are also firms (like ours) that can do this for you. It's not that expensive... /cf_plug -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 9:05 AM To: CF-Talk Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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: True Combobox for HTML?
Here is one I made that works in IE5+ and Mozilla/NS/AOL/Compuserve... http://www.oztek.net/jon/combobox.htm It's not the best code, and I started working on a more OO version, but what code is there is pretty readable. jon - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 12:34 PM Subject: True Combobox for HTML? Anyone know of a custom tag or something that offers a true combo box for HTML? The tags I have seen in the exchange are typically a text box which will use JS to select the appropriate item in a select box. However, we need to allow our users to type a value into a combo box, where the value is either a new value, or an existing value. If it's an existing value, then we need it to auto fill the text entry area with the nearest matching value as the user types. In VB, I'd use the combo box in it's default style. Thanks. Shawn Grover __ 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: Access SQL stored procs
Yes, we have. It works quite well: You write your query in Access, then use CFSTOREDPROC to access it. Cut the processing time on a few of our pages from over 4 seconds to just under 400 ms. You can also access a query as a table, of course, but then PROCPARAM is right out... Ian -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:04 AM To: CF-Talk Subject: OT: Access SQL stored procs Hey CF people, Happy Friday!! Well I have a question about access. I thought I saw something or read something about use the access query objects as stored procs. Has anyone done this and if so can you share? TIA Shawn Regan __ 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: Search Engines
Are you sure - I just cut and paste this: http://www.wordtracker.com/ We use it every day, honest -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:07 AM To: CF-Talk Subject: Re: Search Engines Uh - it's a domain name for sale . . . . Daved - Original Message - From: Ian Lurie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 12:11 PM Subject: RE: Search Engines WordTracker.com is an essential tool. cf_plug There are also firms (like ours) that can do this for you. It's not that expensive... /cf_plug -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 9:05 AM To: CF-Talk Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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: True Combobox for HTML?
Thank you Jon, and Mike. I think the article Mike specified is the best solution (in our case). Unfortunately, we are mostly through our app, and need to replace some selects with combo's. On that note, it is not feasible at this time for us to rewrite the code to populate the combo boxes. So I told we'll continue as is for now, and make these changes in a future release of our web app. Thanks for the input though. Shawn Grover -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 11:06 AM To: CF-Talk Subject: Re: True Combobox for HTML? Here is one I made that works in IE5+ and Mozilla/NS/AOL/Compuserve... http://www.oztek.net/jon/combobox.htm It's not the best code, and I started working on a more OO version, but what code is there is pretty readable. jon - Original Message - From: Shawn Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 12:34 PM Subject: True Combobox for HTML? Anyone know of a custom tag or something that offers a true combo box for HTML? The tags I have seen in the exchange are typically a text box which will use JS to select the appropriate item in a select box. However, we need to allow our users to type a value into a combo box, where the value is either a new value, or an existing value. If it's an existing value, then we need it to auto fill the text entry area with the nearest matching value as the user types. In VB, I'd use the combo box in it's default style. Thanks. Shawn Grover __ 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: update a dollarformat field
:) no problem... - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 11:50 AM Subject: RE: update a dollarformat field i guess phillip got busy :)...so i'll pinch hit for him... Oops, missed that one... Thanks for catching it for me Dina Also, my Access skills are a little rusty as I've not really used it for close on 3 years now g Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. * * 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 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: return to search page
Dear Listmembers, I truly hate posting this question because I know it has been discussed, albeit some time ago. However, combing through the archives and saved emails has not proven fruitful yet. We are building a file sharing system on our intranet. CFFile uploads from a Mac go ok, but cannot be downloaded using CFContent. PC's can download the Mac files, but not the Macs. Any resolution? Tony Gruen __ 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: update a dollarformat field
Thanks Dina! Have a good weekend all and thanks for the quick and helpful replies as always. Robert O. -Original Message- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 12:36 PM To: CF-Talk Subject: Re: update a dollarformat field robert, i guess phillip got busy :)...so i'll pinch hit for him... in access design view, click on the field name then make sure field size (general tab) is set to long integer and decimal places is set to auto. that should eliminate your problem with rounding. if you want to multiply the value of costeach by a qty and project the result as a total, you would do this in the select statement of your query: sum(costeach * qty) as total_costeach then reference total_costeach for display. just be sure to list any non-aggregate columns projected in your select statement in a group by. ~ dina - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 24, 2002 9:47 AM Subject: RE: update a dollarformat field Thanks much Phillip. One further question though. In Access I have the costeach field setup as numeric. Each time a figure is entered with cents after, it rounds it off to the next amount (350.60 becomes 360). How can I keep it as 350.50 and then at some point have this number calculated via a qty number and total? Robert O. -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:35 AM To: CF-Talk Subject: RE: update a dollarformat field OK, now I understand. Costeach is a number in the Access table. However, is there any way to make the number, let's say 1300.50 appear as $1,300.50 when displayed, but as 1300.50 (stripped the $, etc) when updating? What you have to do is before you update; form.CostEach=ReplaceList(form.CostEach,$,,all); form.CostEach=ReplaceList(form.CostEachall); That way it's removed the excess characters Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. * * 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 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: Access SQL stored procs
Ok thanks Do you know of any place I can find docs on the syntax? Shawn Regan -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:12 AM To: CF-Talk Subject: RE: Access SQL stored procs Yes, we have. It works quite well: You write your query in Access, then use CFSTOREDPROC to access it. Cut the processing time on a few of our pages from over 4 seconds to just under 400 ms. You can also access a query as a table, of course, but then PROCPARAM is right out... Ian -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:04 AM To: CF-Talk Subject: OT: Access SQL stored procs Hey CF people, Happy Friday!! Well I have a question about access. I thought I saw something or read something about use the access query objects as stored procs. Has anyone done this and if so can you share? TIA Shawn Regan __ 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: Access SQL stored procs
You can set up a paramater query in Access that accepts CFPROCPRAM. something like: cfstoredproc datasource=AdvancedAccess procedure=CustomerOrders cfprocparam type=in cfsqltype=cf_sql_integer dbvarname=get_OrderListForCustomerByID value=1 cfprocresult name=GetOrderItemsByCustomer /cfstoredproc (the database and code samples are also here: http://cfhub.com/forum//index.cfm?FuseAction=ThreadTopicID=2391) __ 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: Access SQL stored procs
Ben Forta did an article on this some time ago (think it was him). Check out his site at www.forta.com the article should be there somewhere. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 11:31 AM To: CF-Talk Subject: RE: Access SQL stored procs Ok thanks Do you know of any place I can find docs on the syntax? Shawn Regan -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:12 AM To: CF-Talk Subject: RE: Access SQL stored procs Yes, we have. It works quite well: You write your query in Access, then use CFSTOREDPROC to access it. Cut the processing time on a few of our pages from over 4 seconds to just under 400 ms. You can also access a query as a table, of course, but then PROCPARAM is right out... Ian -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:04 AM To: CF-Talk Subject: OT: Access SQL stored procs Hey CF people, Happy Friday!! Well I have a question about access. I thought I saw something or read something about use the access query objects as stored procs. Has anyone done this and if so can you share? TIA Shawn Regan __ 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
CFCONTENT Woes
I forgot to change the subject line in my original post -- Dear Listmembers, I truly hate posting this question because I know it has been discussed, albeit some time ago. However, combing through the archives and saved emails has not proven fruitful yet. We are building a file sharing system on our intranet. CFFile uploads from a Mac go ok, but cannot be downloaded using CFContent. PC's can download the Mac files, but not the Macs. Any resolution? Tony Gruen __ 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
Array questions
If I define a 2 dimensional array with info in it like this: Element NameLowMark HighMarkAvgMark 1 Fred22 88 45 2 Bob 55 96 83 Is there a way to easily get the average of the average column (getting the lowest mark and highest should be easy with ArrayMin and ArrayMax), or would be better off with four single dimension arrays? T __ 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: Access SQL stored procs
ok thanks Shawn Regan -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:47 AM To: CF-Talk Subject: RE: Access SQL stored procs Ben Forta did an article on this some time ago (think it was him). Check out his site at www.forta.com the article should be there somewhere. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 11:31 AM To: CF-Talk Subject: RE: Access SQL stored procs Ok thanks Do you know of any place I can find docs on the syntax? Shawn Regan -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:12 AM To: CF-Talk Subject: RE: Access SQL stored procs Yes, we have. It works quite well: You write your query in Access, then use CFSTOREDPROC to access it. Cut the processing time on a few of our pages from over 4 seconds to just under 400 ms. You can also access a query as a table, of course, but then PROCPARAM is right out... Ian -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:04 AM To: CF-Talk Subject: OT: Access SQL stored procs Hey CF people, Happy Friday!! Well I have a question about access. I thought I saw something or read something about use the access query objects as stored procs. Has anyone done this and if so can you share? TIA Shawn Regan __ 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: Array questions
Looks like a neat problem. Lets see: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(avgMark); i = i + 1){ total = total + avgMark[i]; } average = total / arrayLen(avgMark); /CFSCRIPT That should do it right? Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:15 PM To: CF-Talk Subject: Array questions If I define a 2 dimensional array with info in it like this: Element NameLowMark HighMarkAvgMark 1 Fred22 88 45 2 Bob 55 96 83 Is there a way to easily get the average of the average column (getting the lowest mark and highest should be easy with ArrayMin and ArrayMax), or would be better off with four single dimension arrays? T __ 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: Array questions
At 02:29 PM 5/24/02 -0400, Timothy Heald wrote: That should do it right? grin Very slick. That looks like it'll solve it. Thanks. T __ 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
CFHTTP question
Hi all friends: I'm using the cfhttp tag to log into a site remotly and walk around after being logged , the problem comes out when I meet a link (that I need to call trough cfhttp too) like this: a href=javascript:cf_http_hook_fullpath('http://skillport.nywired.org/_SkillS oft_od_cgi/odisapi.dll?cmd=SummaryFrametemplate=SummaryCF.tplobjname=COMM0 20100surl=COMM020100/summary.htmactive=1sessionid=mmr-0time=1423 42', 1) Any ideas?? . I don't see how to call javascript code with this tag. Any ideas?? thanks in advance friends regards Mario __ 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: Array questions
Let me expand this a bit more: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(studentInfo[5]); i = i + 1){ total = total + studentInfo[5][i]; } average = total / arrayLen(studentInfo[5]); /CFSCRIPT StudentInfo being what I called the array. This will do it for a 2 dimensional array. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:29 PM To: CF-Talk Subject: RE: Array questions Looks like a neat problem. Lets see: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(avgMark); i = i + 1){ total = total + avgMark[i]; } average = total / arrayLen(avgMark); /CFSCRIPT That should do it right? Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:15 PM To: CF-Talk Subject: Array questions If I define a 2 dimensional array with info in it like this: Element NameLowMark HighMarkAvgMark 1 Fred22 88 45 2 Bob 55 96 83 Is there a way to easily get the average of the average column (getting the lowest mark and highest should be easy with ArrayMin and ArrayMax), or would be better off with four single dimension arrays? T __ 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: Array questions
Youre probably getting that from a query. Why not have the db calculate it for you? DRE -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 12:40 PM To: CF-Talk Subject: RE: Array questions Let me expand this a bit more: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(studentInfo[5]); i = i + 1){ total = total + studentInfo[5][i]; } average = total / arrayLen(studentInfo[5]); /CFSCRIPT StudentInfo being what I called the array. This will do it for a 2 dimensional array. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:29 PM To: CF-Talk Subject: RE: Array questions Looks like a neat problem. Lets see: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(avgMark); i = i + 1){ total = total + avgMark[i]; } average = total / arrayLen(avgMark); /CFSCRIPT That should do it right? Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:15 PM To: CF-Talk Subject: Array questions If I define a 2 dimensional array with info in it like this: Element NameLowMark HighMarkAvgMark 1 Fred22 88 45 2 Bob 55 96 83 Is there a way to easily get the average of the average column (getting the lowest mark and highest should be easy with ArrayMin and ArrayMax), or would be better off with four single dimension arrays? T __ 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: Array questions
No need to reinvent the wheel. How about average = ArrayAvg(avgMark) Don't think it will work on a 2D array but I don't see how your data fits a two dimension array. /rob -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:29 PM To: CF-Talk Subject: RE: Array questions Looks like a neat problem. Lets see: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(avgMark); i = i + 1){ total = total + avgMark[i]; } average = total / arrayLen(avgMark); /CFSCRIPT That should do it right? Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:15 PM To: CF-Talk Subject: Array questions If I define a 2 dimensional array with info in it like this: Element NameLowMark HighMarkAvgMark 1 Fred22 88 45 2 Bob 55 96 83 Is there a way to easily get the average of the average column (getting the lowest mark and highest should be easy with ArrayMin and ArrayMax), or would be better off with four single dimension arrays? T __ 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
Help Please - Having trouble with cferror
Hey all, I'm having a bit of a brain fart here. I want to have a particular site send the details of the error message when a message occurs. The plan I have is this, but it doesn't seem to be working. \root\Application.cfm (contains a cferror tag, type=exception mailto=myemailaddr template=errors/errorhandler.cfm ...) \root\errors\Application.cfm (just holds a comment); \root\errors\errorhandler.cfm (contains code to loop over the error object if it exists, putting the messages in a cfmail tag) I've been able to use cf code in an error template before (think I was tinkering with it some time ago, can't find the code). Anyone have an idea on what I might be missing? Thanks All David __ 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: Help Please - Having trouble with cferror
My understanding is that you can't use cf code at all in an error template. You have access to a few vars. You can use mailto in cferror to send an e-mail on error. You can use CF code in a cfcatch if you trap your error that way. David Schmidt [EMAIL PROTECTED] 05/23/02 02:52PM Hey all, I'm having a bit of a brain fart here. I want to have a particular site send the details of the error message when a message occurs. The plan I have is this, but it doesn't seem to be working. \root\Application.cfm (contains a cferror tag, type=exception mailto=myemailaddr template=errors/errorhandler.cfm ...) \root\errors\Application.cfm (just holds a comment); \root\errors\errorhandler.cfm (contains code to loop over the error object if it exists, putting the messages in a cfmail tag) I've been able to use cf code in an error template before (think I was tinkering with it some time ago, can't find the code). Anyone have an idea on what I might be missing? Thanks All David __ 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
Sorting a 2 dimensionl array
Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [EMAIL PROTECTED] __ 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: Sorting a 2 dimensional array
I need to use my spell checker more often! :) -Original Message- From: Kevin Schmidt Sent: Friday, May 24, 2002 1:58 PM To: CF-Talk Subject: Sorting a 2 dimensionl array Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [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: Sorting a 2 dimensionl array
check out ArraySort() in the CF Docs... v/r, Jeff -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:58 PM To: CF-Talk Subject: Sorting a 2 dimensionl array Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [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: Sorting a 2 dimensionl array
http://devex.macromedia.com/developer/gallery/SearchResults.cfm?keywords=Sort2DArray On Fri, 24 May 2002, Kevin Schmidt wrote: Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [EMAIL PROTECTED] __ 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: Sorting a 2 dimensionl array
ArraySort() only works with 1 dimensional arrays. On Fri, 24 May 2002, Jeff Brown wrote: check out ArraySort() in the CF Docs... v/r, Jeff -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:58 PM To: CF-Talk Subject: Sorting a 2 dimensionl array Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [EMAIL PROTECTED] __ 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: Sorting a 2 dimensionl array
That only does 1 dimensional arrays :) -Original Message- From: Jeff Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:01 PM To: CF-Talk Subject: RE: Sorting a 2 dimensionl array check out ArraySort() in the CF Docs... v/r, Jeff -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:58 PM To: CF-Talk Subject: Sorting a 2 dimensionl array Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [EMAIL PROTECTED] __ 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: Array questions
Didn't know there was an arrayAvg() function. Should work on a multiple dimension array like this: arrayAvg(studentInfo[5]) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Rob Baxter [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:43 PM To: CF-Talk Subject: RE: Array questions No need to reinvent the wheel. How about average = ArrayAvg(avgMark) Don't think it will work on a 2D array but I don't see how your data fits a two dimension array. /rob -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:29 PM To: CF-Talk Subject: RE: Array questions Looks like a neat problem. Lets see: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(avgMark); i = i + 1){ total = total + avgMark[i]; } average = total / arrayLen(avgMark); /CFSCRIPT That should do it right? Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:15 PM To: CF-Talk Subject: Array questions If I define a 2 dimensional array with info in it like this: Element NameLowMark HighMarkAvgMark 1 Fred22 88 45 2 Bob 55 96 83 Is there a way to easily get the average of the average column (getting the lowest mark and highest should be easy with ArrayMin and ArrayMax), or would be better off with four single dimension arrays? 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: Sorting a 2 dimensionl array
arraySort(array[1], numeric[,asc or desc]) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:58 PM To: CF-Talk Subject: Sorting a 2 dimensionl array Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [EMAIL PROTECTED] __ 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: Sorting a 2 dimensionl array
That stinks. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:59 PM To: CF-Talk Subject: RE: Sorting a 2 dimensionl array ArraySort() only works with 1 dimensional arrays. On Fri, 24 May 2002, Jeff Brown wrote: check out ArraySort() in the CF Docs... v/r, Jeff -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:58 PM To: CF-Talk Subject: Sorting a 2 dimensionl array Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [EMAIL PROTECTED] __ 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: Help Please - Having trouble with cferror
Your code is most likely throwing an exception error, after which no CFML can be processed. There are multiple error types which may be thrown (exception, request, monitor and some other I can't remember). Though you did not say it, I bet your cfmail tag is getting processed some times (like when a request error is thrown), leading you to believe the code in the error template is buggy. Use multiple error handling templates (in your application.cfm), something like this: cfparam name=ExceptionHandling default=1 cfif ExceptionHandling eq 1 cferror type=request template=errorrequest.cfm mailto=#variables.ErrorEmail# cferror type=exception template=errorexception.cfm mailto=#variables.ErrorEmail# /cfif Forta's CF5 WACK book covers this in detail- HTH. -Craig __ 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 questions
The CFStudio help says only a single dimensional array. ~Todd On Fri, 24 May 2002, Timothy Heald wrote: Didn't know there was an arrayAvg() function. Should work on a multiple dimension array like this: arrayAvg(studentInfo[5]) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Rob Baxter [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:43 PM To: CF-Talk Subject: RE: Array questions No need to reinvent the wheel. How about average = ArrayAvg(avgMark) Don't think it will work on a 2D array but I don't see how your data fits a two dimension array. /rob -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:29 PM To: CF-Talk Subject: RE: Array questions Looks like a neat problem. Lets see: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(avgMark); i = i + 1){ total = total + avgMark[i]; } average = total / arrayLen(avgMark); /CFSCRIPT That should do it right? Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:15 PM To: CF-Talk Subject: Array questions If I define a 2 dimensional array with info in it like this: Element NameLowMark HighMarkAvgMark 1 Fred22 88 45 2 Bob 55 96 83 Is there a way to easily get the average of the average column (getting the lowest mark and highest should be easy with ArrayMin and ArrayMax), or would be better off with four single dimension arrays? T __ 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: Help Please - Having trouble with cferror
This WAS true with earlier versions, but the error page is MUCH more robust now, starting with V 4.5 I think. Are you trying to make it work with a V 4.0 CF Server? On 5/24/02 11:55 AM, BEN MORRIS [EMAIL PROTECTED] wrote: My understanding is that you can't use cf code at all in an error template. You have access to a few vars. You can use mailto in cferror to send an e-mail on error. You can use CF code in a cfcatch if you trap your error that way. David Schmidt [EMAIL PROTECTED] 05/23/02 02:52PM Hey all, I'm having a bit of a brain fart here. I want to have a particular site send the details of the error message when a message occurs. The plan I have is this, but it doesn't seem to be working. \root\Application.cfm (contains a cferror tag, type=exception mailto=myemailaddr template=errors/errorhandler.cfm ...) \root\errors\Application.cfm (just holds a comment); \root\errors\errorhandler.cfm (contains code to loop over the error object if it exists, putting the messages in a cfmail tag) I've been able to use cf code in an error template before (think I was tinkering with it some time ago, can't find the code). Anyone have an idea on what I might be missing? Thanks All David __ 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: Sorting a 2 dimensionl array
Kevin, The one I pointed out at the Macromedia exchange works well. Steer clear of one called ArrayTableSort however, it has a nice little bug in it (in fact, it inserted an empty element in the array which screwed up my app like you wouldn't believe). The Sort2DArray works well and has passed our QA team (which doesn't mean much). ~Todd -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:58 PM To: CF-Talk Subject: Sorting a 2 dimensionl array Anyone have a ideas on how to sort a two dimentional array by one of the elements (numerically)? Kevin Schmidt Two Rivers Marketing Group 502 E. Locust, Des Moines, IA 50309 Phone: 515.557.2028 Mobile: 515.865.3526 Fax: 515.557.2001 [EMAIL PROTECTED] __ 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: Array questions
Man we have all these great array functions, and they only work on single dimension arrays. Wish I had known more about that during the CFMX beta. Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 3:05 PM To: CF-Talk Subject: RE: Array questions The CFStudio help says only a single dimensional array. ~Todd On Fri, 24 May 2002, Timothy Heald wrote: Didn't know there was an arrayAvg() function. Should work on a multiple dimension array like this: arrayAvg(studentInfo[5]) Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Rob Baxter [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:43 PM To: CF-Talk Subject: RE: Array questions No need to reinvent the wheel. How about average = ArrayAvg(avgMark) Don't think it will work on a 2D array but I don't see how your data fits a two dimension array. /rob -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:29 PM To: CF-Talk Subject: RE: Array questions Looks like a neat problem. Lets see: CFSCRIPT !--- initialize the total variable to hold the sum of the array's value --- total = 0; for(i = 1; i lt arrayLen(avgMark); i = i + 1){ total = total + avgMark[i]; } average = total / arrayLen(avgMark); /CFSCRIPT That should do it right? Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 2:15 PM To: CF-Talk Subject: Array questions If I define a 2 dimensional array with info in it like this: Element NameLowMark HighMarkAvgMark 1 Fred22 88 45 2 Bob 55 96 83 Is there a way to easily get the average of the average column (getting the lowest mark and highest should be easy with ArrayMin and ArrayMax), or would be better off with four single dimension arrays? T __ 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