OT: is someone try to hack my server?
hi, I get all these error from my apache error log file, can someone help me by explaining what caused this? seems like someone is hacking my server, thank god, i'm not using NT server. but still it makes my server's response slow. [Fri Nov 2 12:19:25 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/root.exe [Fri Nov 2 12:19:27 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/MSADC/root.exe [Fri Nov 2 12:19:29 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/c/winnt/system32/cmd.exe [Fri Nov 2 12:19:48 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/d/winnt/system32/cmd.exe [Fri Nov 2 12:20:01 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..%5c../winnt/system32/cmd.exe [Fri Nov 2 12:20:08 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/_vti_bin/..%5c../..%5c../..%5c../winnt/system32/cmd.exe [Fri Nov 2 12:20:08 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/_mem_bin/..%5c../..%5c../..%5c../winnt/system32/cmd.exe [Fri Nov 2 12:20:09 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/msadc/..%5c../..%5c../..%5c/..Á../..Á../..Á../winnt/syst em32/cmd.exe [Fri Nov 2 12:20:10 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..Á../winnt/system32/cmd.exe [Fri Nov 2 12:20:12 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..À¯../winnt/system32/cmd.exe [Fri Nov 2 12:20:13 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..Á../winnt/system32/cmd.exe [Fri Nov 2 12:20:15 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..%5c../winnt/system32/cmd.exe any way that i can prevent all these? ~~ 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: OT: is someone try to hack my server?
Mak Wing Lok wrote: hi, I get all these error from my apache error log file, can someone help me by explaining what caused this? seems like someone is hacking my server, thank god, i'm not using NT server. but still it makes my server's response slow. [Fri Nov 2 12:19:25 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/root.exe cf_snip Looks like the Nimda virus/worm. There appears to ba an upsurge with a new mutation around. Info in all the usuall places. If you can't find the usual places, do a search for nimda in the list archives. any way that i can prevent all these? Firewall configuration. Jochem ~~ 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: locking within CFSCRIPT
At 02:37 AM 11/2/2001, Birgit wrote: Pete, you are right concerning cfscript but I can't see the limitations regarding UDFs. A UDF pre se is meant to be self-contained and therefore not relying on anything outside it's own scope. Wouldn't the use of shared data inside a UDF be defeating this purpose? You could read a shared scope variable into a local variable and get that into the UDF do what ever you do and than return a new value, write that value into your shared data. Birgit James Sleeman wrote: I don't think so... take for example the following if locking could be done in CFSCRIPT/ CFIF serviceAvailable('borkyService') do stuff, we don't care about how serviceAvailable() does it's job, just that we ask for a service and it tells us if it is available internally, serviceAvailable must perform a named lock around say some code accessing a global structure that holds the services that are currently configured in the website, say, APPLICATION.Services but this calling section of code doesn't care aboutt that we don't want to know how the job is done, only that it is /CFIF If serviceAvailable() requires the use of the external variable application.services I would say that it is a Bad Thing (TM) if you can invoke it like serviceAvailable('borkyService'). The UDF should be modified so it has to be invoked by sending all external variables, serviceAvailable('borkyService',application.services) cf_snip in conclusion I think that not having locks in CFSCRIPT is causing the break of scope. I think bad UDF implementation is causing break of scope in your example for the reasons stated above, and I completely agree with Birgit. Jochem ~~ 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: Cross Selects
Create a list from your query and pass it to the custom tag: cfset lMyList = Valuelist(qMyQuery.myColumn) cf_crossselect valuesleft=#lMyList# ... Pascal -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: donderdag 1 november 2001 15:15 To: CF-Talk Subject: RE: Cross Selects Yes, I have placed the Select box/multiple code within the custom tag, which I can't get to work. The custom tag only seems to allow comma delimited hard code text. Mark -Original Message- From: Yanton [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:00 AM To: CF-Talk Subject: Re: Cross Selects don't use textarea but used select box multiple you can display all you recordset in option yanton - Original Message - From: Mark Leder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, 01 November, 2001 8:40 PM Subject: Cross Selects Anyone have any experience with custom tags known as Cross Selects? This is used in a form and provides two textarea boxes. Values in the left box can be selectively moved to the box on the right. My problem, getting the box on the left to be populated from a query (and behaving like a scrolling list), instead of hard coding values in the tag. I've tried loops, outputs, etc. with no effect (I only am able to display the first record of a multiple record query). Any ideas on how to do this dynamically? Thanks, Mark ~~ 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: sql distinct
Doesn't the distinct work for the whole select and not just the first field? -Original Message- From: Michael Vinson [mailto:[EMAIL PROTECTED]] Sent: donderdag 1 november 2001 16:45 To: CF-Talk Subject: sql distinct My distinct is no longer distinct after a simple, but major, change. SELECT DISTINCT CategoryIdTable.Category, CategoryIdTable.CategoryID, CourseTable.CategoryID, CourseTable.PartNumber FROM CategoryIdTable, CourseTable WHERE CategoryIdTable.CategoryID = CourseTable.CategoryID AND CourseTable.Lang LIKE '%#tmpLangCode#%' I changed my db to embed the language code in the part number (e.g. 1000-ABC-ES), (ES=espanol), instead of using an (existing) column (which was like EN,ES,PT,etc) SELECT DISTINCT CategoryIdTable.Category, CategoryIdTable.CategoryID, CourseTable.CategoryID, CourseTable.PartNumber FROM CategoryIdTable, CourseTable WHERE CategoryIdTable.CategoryID = CourseTable.CategoryID AND CourseTable.PartNumber LIKE '%#tmpLangCode#' So now I get MULTIPLE categories, instead of the DISTINCT list that was returned using the former sql statement. Also can anyone point me to a 'proper' SQL spec for Access 97 / ODBC driver. I'm using a generic Que book which says things like ... try INSTR() but if that doesn't work try INSTRING() or SUBSTR/SUBSTRING ... or maybe they won't work at all ;o) ... It's actually driving me a little batty this halloween. Thanks, Mike ~~ 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: sql distinct
yep your right pascalsthe distinct works on all of the fields combined that are listed in trhe select statement -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 10:28 To: CF-Talk Subject: RE: sql distinct Doesn't the distinct work for the whole select and not just the first field? -Original Message- From: Michael Vinson [mailto:[EMAIL PROTECTED]] Sent: donderdag 1 november 2001 16:45 To: CF-Talk Subject: sql distinct My distinct is no longer distinct after a simple, but major, change. SELECT DISTINCT CategoryIdTable.Category, CategoryIdTable.CategoryID, CourseTable.CategoryID, CourseTable.PartNumber FROM CategoryIdTable, CourseTable WHERE CategoryIdTable.CategoryID = CourseTable.CategoryID AND CourseTable.Lang LIKE '%#tmpLangCode#%' I changed my db to embed the language code in the part number (e.g. 1000-ABC-ES), (ES=espanol), instead of using an (existing) column (which was like EN,ES,PT,etc) SELECT DISTINCT CategoryIdTable.Category, CategoryIdTable.CategoryID, CourseTable.CategoryID, CourseTable.PartNumber FROM CategoryIdTable, CourseTable WHERE CategoryIdTable.CategoryID = CourseTable.CategoryID AND CourseTable.PartNumber LIKE '%#tmpLangCode#' So now I get MULTIPLE categories, instead of the DISTINCT list that was returned using the former sql statement. Also can anyone point me to a 'proper' SQL spec for Access 97 / ODBC driver. I'm using a generic Que book which says things like ... try INSTR() but if that doesn't work try INSTRING() or SUBSTR/SUBSTRING ... or maybe they won't work at all ;o) ... It's actually driving me a little batty this halloween. Thanks, Mike ~~ 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: Caching Queries
Eric: there's a couple of articles on allaire.com. Just search for 'query caching'. Basically, query caching is a Good Thing, as long as you use it sensibly and handle it correctly. A few points to consider: Query caching only applies to queries of the same name and with the same (exact same) SQL. Within the timeframe of the cache, any changes that are made to the data within the result set will not be returned; if you want changes to be available immediately, you need to refresh the cache. You need to consider how long you will accept data to be out of date for. If you have a heavy load site, caching a query for 3-4 seconds will improve performance without your data being out of date: Person A requests the query, it is cached. People B,C,D,E,F,G,H all request the same query within the next 3-4 seconds and reeive the cached version. Person A refreshes their screen immediately and, since the timeout will have passed, will receive a refreshed data set. -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 20:03 To: CF-Talk Subject: Caching Queries An application I am working with is really bogging down a database server. Can anybody point out an online resource to the pros/cons of caching queries? Maybe I'm making this more than it is and it's not that complicated. I'm just wondering if caching queries is an eventuality for web applications that get a lot of traffic. 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: csv loop problem
The easiest solution is to make sure that there are no CR/LF in your text. Replace them by some code when you create the csv file. When you have to treat the elements, replace the codes by CR/LF. If this is not an option, you should read each field separately in a condition loop. For the first 6 fields, you find the next comma and then find the CR/LF for the 7th. Use the Mid() function to isolate the field. In any case, this method will always fail if you have a CR/LF in the last field of a record. Pascal -Original Message- From: list peters [mailto:[EMAIL PROTECTED]] Sent: vrijdag 2 november 2001 8:56 To: CF-Talk Subject: csv loop problem hi, i am looping over a csv file. doing this cfloop index=newtext list=#textfile# delimiters=#CHR(13)##CHR(10)# This works fine for things like item1,item2 but i get problem for item1 (line breaks inserted into text), item2 Because of the line breaks in a text block i am getting more than 2 items. each row is delimited by a CR, however there are CR inside the csv as text blocks. How do i loop over it cleanly. THere are 7 items per row. thanks chad ~~ 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: csv loop problem
i am looping over a csv file. doing this cfloop index=newtext list=#textfile# delimiters=#CHR(13)##CHR(10)# This works fine for things like item1,item2 but i get problem for item1 (line breaks inserted into text), item2 Because of the line breaks in a text block i am getting more than 2 items. each row is delimited by a CR, however there are CR inside the csv as text blocks. How do i loop over it cleanly. THere are 7 items per row. Are you using CFFile to read in the CSV? If so, why not try making a Text Datasource and letting ODBC handle the field and record breaks That's how I normally read in CSVs... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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: Generator Issues
What I meant to ask was Does it happen in all browsers?. Yup, Netscape and IE - it's actually the graphic that's generated - if we open it in PhotoShop it's got a dapple effect on it I'm assuming that it doesn't do this if you use a websafe colour in the background? It's not the background color that has the problem, the image is a button with a background of one color, a shaped area and text over the top - we can't use just websafe colors as they are just too limiting - the anti-aliasing alone would throw it out of the window! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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
Fw: commas in lists
Hi, Maybe someone can help me. I have a field that a customer fills out which is a comma delimited list. Ex: wide,very deep,too easy,rugby This is fine, however, if the customer wants to put a comma in the text, it screws up list functions and list loops. Notice the , between very and deep. Ex: wide,very, deep,too easy,rugby So, I say to him, if want to put commans in there, you have to quote the text. Ex: wide,very, deep,too easy,rugby OR 'wide','very, deep','too easy','rugby' Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? Best Regards Joe Hansen ~~ 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: commas in lists
Maybe someone can help me. I have a field that a customer fills out which is a comma delimited list. Ex: wide,very deep,too easy,rugby This is fine, however, if the customer wants to put a comma in the text, it screws up list functions and list loops. Notice the , between very and deep. Ex: wide,very, deep,too easy,rugby So, I say to him, if want to put commans in there, you have to quote the text. Ex: wide,very, deep,too easy,rugby OR 'wide','very, deep','too easy','rugby' Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? CF is stupid about commas in lists, so, here's an idea... put , in front of the list , at the end and use , as the delimiter The problem with this is that you may have to read through it yourself and not use a list function - maybe treat it as an array... Or, why use a comma as the delimiter - use a pipe instead (|), that way you can put whatever you want into the entries Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** 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: commas in lists
We usualy use the pipe as a delimiter for non numerical lists Pascal -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: vrijdag 2 november 2001 13:07 To: CF-Talk Subject: Fw: commas in lists Hi, Maybe someone can help me. I have a field that a customer fills out which is a comma delimited list. Ex: wide,very deep,too easy,rugby This is fine, however, if the customer wants to put a comma in the text, it screws up list functions and list loops. Notice the , between very and deep. Ex: wide,very, deep,too easy,rugby So, I say to him, if want to put commans in there, you have to quote the text. Ex: wide,very, deep,too easy,rugby OR 'wide','very, deep','too easy','rugby' Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? Best Regards Joe Hansen ~~ 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: commas in lists
We tend to use the ^ sign for 'annoying' lists - we use it all the time as a standard to allow our web and director apps to talk. HTH Neil Team Macromedia ~~ 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: Three select
Changed that--didn't help... Is there a newer tag available somewhere?? -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:30 AM To: CF-Talk Subject: RE: Three select Forcewidth4 should be forcewidth3 Steven D Dworman - Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 - EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com -Original Message- From: Dave Babbitt [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 9:21 AM To: CF-Talk Subject: RE: Three select There is a typo in the javascript code and I can't remember where it is - somebody needs to sit down and rewrite this tag! Does anybody know of an open source depository for this tag - where developers can upload their fixes? -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 10:24 AM To: CF-Talk Subject: Three select I am using the cf_threeselectrelated tag. There are a few things that have come up and I'm wondering how others have handled it. I hope I can explain the behavior clearly, because it is somewhat odd/confusing when the back button is used. A user chooses from select box 1 and 2 and (maybe) 3 and chooses from a variety of report styles (different excel reports showing different info). They view their report then retun to the three select page using the back button and if they want to just hit a different report for the same group already chosen: 1. If they previously chose the 1st choice in the 2nd select box they get an error. The error says Incorrect syntax near ')' so it's reading the query as (Choose.Choice2=) instead of (Choose.Choice2=#Choose.Choice2#) 2. If they previously chose any other choice in the 2nd box they don't get an error, but the excel report comes up with just the information listed from the 1st box (it doesn't filter the 2nd box) 3. The options from the 2nd/3rd box disappers when they retun to the page. So if the user wants to keep the same info for the 1st box but wants to change the option in the 2nd/3rd boxes they have to click a different option in the 1st box than re-click on the original choice. Ideally I would like the user to be able to look at their excel sheet, hit the back button, then click on the next report keeping the same filters in place until others are choosen... Is this possible? Thanks in advance! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: commas in lists
cf_kmPlug degree=blatant cfx_kmSuite contains over 100 functions to extend ColdFusion, including a set of list functions that behave *exactly* as you would hope. http://www.hoptechno.com/kmtools/ Checkout the cfx_kmList module documentation. /cf_kmPlug Keith Meade [EMAIL PROTECTED] - Original Message - From: Webmaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 6:06 AM Subject: Fw: commas in lists Hi, Maybe someone can help me. I have a field that a customer fills out which is a comma delimited list. Ex: wide,very deep,too easy,rugby This is fine, however, if the customer wants to put a comma in the text, it screws up list functions and list loops. Notice the , between very and deep. Ex: wide,very, deep,too easy,rugby So, I say to him, if want to put commans in there, you have to quote the text. Ex: wide,very, deep,too easy,rugby OR 'wide','very, deep','too easy','rugby' Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? Best Regards Joe Hansen ~~ 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
A little project I'm starting - need help
Howdy All, Alright enough with the redneck humor. I'm starting a little project that I have been considering for awhile and thought that maybe the CF community could help me out. Now that SQL Server 2000 support UDF's, I am begining to port as many CF functions as I can to T-SQL. Last night I sat down and ported ListGetAt() and DaysInMonth() to T-SQL functions. They work great and fast. If anyone would like to help out, I will be putting the function collect in the Allaire (Macromedia) custom tag directory and also on my website http://www.xcreation.com/apps.cfm . Feel free to download it and contribute to it. Just please email me any bugs and fixes you make. Also if anyone knows of a project to do this that is already in the works, please tell me. I don't like reinventing the wheel. Anthony Petruzzi http://www.xcreation.com/rip747 MSCE MCP+I [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: commas in lists
Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? CF is stupid about commas in lists, so, here's an idea... put , in front of the list , at the end and use , as the delimiter It's not that important, but I'd like to argue against this. CF isn't stupid about lists. If you say that the comma is a delimiter, then it's going to treat every delimiter as a comma. You can see the same behaviour in Java using StringTokenizers. Sure, you can say, Well, if I put a comma between quotes, it should be ignored, but that's one of those things that's easy for us to say as a human, but is pretty complex for a computer. (Ie, you can build programs that run fast, but building a program with common sense is a lot more difficult. ;) In general, whenever I have a list where I can't trust the data... I just don't use a list. In the example the user gave where the list came from user input, why not consider a set of text boxes? [ ] [ ] [ ] [ ] etc. You can then store this data into an array and just forget worrying about delimiter. Also, be aware that if you pass , as a delimiter, this will NOT work. CF will treat this is as 2 delimiters, the quote () and the comma (,). It will _not_ treat it as one delmiter - , === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~~ 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: commas in lists
On 11/2/01, Raymond Camden penned: It's not that important, but I'd like to argue against this. CF isn't stupid about lists. If you say that the comma is a delimiter, then it's going to treat every delimiter as a comma. You can see the same behaviour in Java using StringTokenizers. Sure, you can say, Well, if I put a comma between quotes, it should be ignored, but that's one of those things that's easy for us to say as a human, but is pretty complex for a computer. (Ie, you can build programs that run fast, but building a program with common sense is a lot more difficult. ;) I would like to see ColdFusion recognize a qualifier. Other programs do it easily enough. cfloop index=listitem list=#mylist# qualifier = #chr(34)# I'd also like it if they would make it recognize empty list items as just that, i.e; A,B,,D So listgetat(mylist, 4) would return D and not an error that the list has only 3 items. In those 2 regards I'd agree that CF isn't too bright where lists are concerned. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: commas in lists
CF isn't stupid about lists. When ColdFusion allows you to specify that it shouldn't ignore empty list elements, I'll agree with you. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: commas in lists
I would like to see ColdFusion recognize a qualifier. Other programs do it easily enough. cfloop index=listitem list=#mylist# qualifier = #chr(34)# What's a qualifier? -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ 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: commas in lists
Try this strategy: // default delimiter is a comma cfset myDelimiter=, //if If Find(yourList,',') // replace , by an unprintable character yourList = Replace(yourList,',',CHR(7)) // Remove opening and closing Replace(yourList,'',) // Change your delimiter to CHR(7) cfset myDelimiter=CHR(7) end if Now pass in myDelimiter along with your list whenever you use CF's list manipulation functions P.S. I don't feel that this is a particular deficiency of CF. I think making it smart enough to not ignore quotes would be a bad thing. You just have to deal with it properly. Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? CF is stupid about commas in lists, so, here's an idea... put , in front of the list , at the end and use , as the delimiter = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ 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: Caching Queries
On 11/2/01, Fiona Barker penned: If you have a heavy load site, caching a query for 3-4 seconds will improve performance without your data being out of date: Person A requests the query, it is cached. People B,C,D,E,F,G,H all request the same query within the next 3-4 seconds and reeive the cached version. Person A refreshes their screen immediately and, since the timeout will have passed, will receive a refreshed data set. I always presumed that the caching timeout was reset every time the query is called. Are you saying that the person who calls the query initially (while it is not cached) is the only one that can reset the timeout? In other words, what you appear to be saying is that person A caches the query (set to 4 seconds). B calls it 1 second later (still cached), C calls 1 second later (still cached), D calls it 1 second later (still cached), E calls it 1 seconds later (still cached), A calls again it 1 second later and it is no longer cached? I thought that if it is called every second it will stay cached indefinitely (or until it becomes the last query in the maximum number of queries to cache) no matter who calls it. Can anyone else verify which is correct? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: Frames and variable scoping
Thanks for the help. I am coming into an application that is already deployed. I'm here to fix bugs and add functionality. I am in the process of converting a lot of stuff to a few session scoped structures. The scoping going on in the frameset and frames is a little funky. My first goal is to get all of the variables passed and scoped properly. And if I had thought about how the thing was working, I would have been able to answer my question. Doh! The form thing is very slick, though. Thanks again! -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 8:43 PM To: CF-Talk Subject: RE: Frames and variable scoping Keep in mind that variables are processed server side while the frameset tags are processed client side. That means that ONLY the page you call with the form action can see the form variables - in this case that page will likely have the FRAMESET tags and nothing else. Once that page is served up the browser initiates requests for the frame sources - by this time your form variables are gone. Your only option here is to generate the frame tags on the fly using CF and put the form variables in the url string for the SRC attribute. This way when the browser makes the request for the frame source your variables will be passed in again through the url scope. You could also store the variables in a persistant scope, but it's probably not the best idea. If you do decide to do this there is one very easy way to do it: cfset session.theForm = form (this works because form is actually a struct pointer which is getting copied into the session.theForm variable) then you can access the variables later like this #session.theForm.fieldName# ~~ 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: Frames and variable scoping
Hi Kelly, Went and grabbed it. Very interesting and helpful reading. Thanks. -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 5:25 PM To: CF-Talk Subject: RE: Frames and variable scoping Check out this: http://www.cfugorama.com/cfugorama/DevCon.cfm Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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
Double Post: Caching Queries
I'm reading all of these articles that say query caching is an essentual tool in web application scalability. I have a few questions about caching queries. Any feedback is much appreciated. Where is a cached query stored (I'm assuming RAM)? Is there a rule of thumb to how many queries you can cache on an application server before you start bogging it down? Can you edit a recordset of a cached query? If so, do the changes span sessions? Are there any downfalls, bugs, limitations to using cached queries? What's the catch? :) Many thanks for any responses :) ~~ 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: commas in lists
Instead of the Replace, don't forget you can use ListChangeDelims. /CFDOCS/CFML_Reference/Functions137.html#1107244 === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:32 AM To: CF-Talk Subject: RE: commas in lists Try this strategy: // default delimiter is a comma cfset myDelimiter=, //if If Find(yourList,',') // replace , by an unprintable character yourList = Replace(yourList,',',CHR(7)) // Remove opening and closing Replace(yourList,'',) // Change your delimiter to CHR(7) cfset myDelimiter=CHR(7) end if Now pass in myDelimiter along with your list whenever you use CF's list manipulation functions P.S. I don't feel that this is a particular deficiency of CF. I think making it smart enough to not ignore quotes would be a bad thing. You just have to deal with it properly. Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? CF is stupid about commas in lists, so, here's an idea... put , in front of the list , at the end and use , as the delimiter = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ 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
Double Post: Caching Queries
Sorry, didn't mean to start a 2nd thread when the first one was active. I didn't notice that there were responses to the initial thread till now. :/ ~~ 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: Caching Queries
Only the first call will cache it. Then the naxt call after the cache timeout will re-cache it. However, CF will only reuse the cached query if all of the attributes and the generated SQL are exactly the same. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: vrijdag 2 november 2001 15:33 To: CF-Talk Subject: RE: Caching Queries On 11/2/01, Fiona Barker penned: If you have a heavy load site, caching a query for 3-4 seconds will improve performance without your data being out of date: Person A requests the query, it is cached. People B,C,D,E,F,G,H all request the same query within the next 3-4 seconds and reeive the cached version. Person A refreshes their screen immediately and, since the timeout will have passed, will receive a refreshed data set. I always presumed that the caching timeout was reset every time the query is called. Are you saying that the person who calls the query initially (while it is not cached) is the only one that can reset the timeout? In other words, what you appear to be saying is that person A caches the query (set to 4 seconds). B calls it 1 second later (still cached), C calls 1 second later (still cached), D calls it 1 second later (still cached), E calls it 1 seconds later (still cached), A calls again it 1 second later and it is no longer cached? I thought that if it is called every second it will stay cached indefinitely (or until it becomes the last query in the maximum number of queries to cache) no matter who calls it. Can anyone else verify which is correct? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Caching Queries
it will remain cached until the cache expires. once the cache expires, the next person to run it will cache it again. i probably phrased it a bit ambiguously. what i meant was that in the time it takes to load the page initially and for the user to have a quick look then refresh the page, the timeout will have expired if it's set to a few seconds. Therefore for one particular user, employing query caching with a very short timespan will not affect the validity (up-to-datedness - i never was particularly good at grammar) of the data that is being displayed, so you don't have to worry about refreshing your cache after every update/insert/deletion. But it will improve the performance of your site (if it's heavily loaded), because any other users that request the same query in that short timespan will get the cached dataset returned. does that make sense? -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 14:33 To: CF-Talk Subject: RE: Caching Queries On 11/2/01, Fiona Barker penned: If you have a heavy load site, caching a query for 3-4 seconds will improve performance without your data being out of date: Person A requests the query, it is cached. People B,C,D,E,F,G,H all request the same query within the next 3-4 seconds and reeive the cached version. Person A refreshes their screen immediately and, since the timeout will have passed, will receive a refreshed data set. I always presumed that the caching timeout was reset every time the query is called. Are you saying that the person who calls the query initially (while it is not cached) is the only one that can reset the timeout? In other words, what you appear to be saying is that person A caches the query (set to 4 seconds). B calls it 1 second later (still cached), C calls 1 second later (still cached), D calls it 1 second later (still cached), E calls it 1 seconds later (still cached), A calls again it 1 second later and it is no longer cached? I thought that if it is called every second it will stay cached indefinitely (or until it becomes the last query in the maximum number of queries to cache) no matter who calls it. Can anyone else verify which is correct? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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
Parsing/Stripping out not letters or numbers
Anyone know how I may do this? We're running CF5. ~~ 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: Frames and variable scoping
Great! It was a great Session! :) Kelly www.webdiva.org -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:41 AM To: CF-Talk Subject: RE: Frames and variable scoping Hi Kelly, Went and grabbed it. Very interesting and helpful reading. Thanks. -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 5:25 PM To: CF-Talk Subject: RE: Frames and variable scoping Check out this: http://www.cfugorama.com/cfugorama/DevCon.cfm Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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: Parsing/Stripping out not letters or numbers
You mean replacing anything that isn't a num or a letter? CFSET STR = Some original string CFSET CLEAN_STR = REReplaceNoCase(STR,[^0-9a-z],,ALL) Normally you would want to keep spaces as well. If so, add a space after 'z'. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:42 AM To: CF-Talk Subject: Parsing/Stripping out not letters or numbers Anyone know how I may do this? We're running CF5. ~~ 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: commas in lists
ListChangeDelims() is wierd though in that it will allow you to replace a single delimiter with multiple delimiters eg: listchangedelims(thislist, ',', ',') I find this unexpected behaviour in that other list functions only act on single delimiters. (ie listfind(thislist, 'myvalue', ',') uses '' or ',' as delimiters, not ','). I would expect multiple delimiters to be not allowed. I'm struggling to find the differences here between listchangedelims() and replace(). -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 14:46 To: CF-Talk Subject: RE: commas in lists Instead of the Replace, don't forget you can use ListChangeDelims. /CFDOCS/CFML_Reference/Functions137.html#1107244 == = Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:32 AM To: CF-Talk Subject: RE: commas in lists Try this strategy: // default delimiter is a comma cfset myDelimiter=, //if If Find(yourList,',') // replace , by an unprintable character yourList = Replace(yourList,',',CHR(7)) // Remove opening and closing Replace(yourList,'',) // Change your delimiter to CHR(7) cfset myDelimiter=CHR(7) end if Now pass in myDelimiter along with your list whenever you use CF's list manipulation functions P.S. I don't feel that this is a particular deficiency of CF. I think making it smart enough to not ignore quotes would be a bad thing. You just have to deal with it properly. Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? CF is stupid about commas in lists, so, here's an idea... put , in front of the list , at the end and use , as the delimiter = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ 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: Parsing/Stripping out not letters or numbers
Raymond, one of those silly little questions, but is there any preference in using: ReplaceNoCase(STR,[^0-9a-zA-Z],,ALL) or REReplaceNoCase(STR,[^0-9a-z],,ALL) to replace case-insensitively? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 14:59 To: CF-Talk Subject: RE: Parsing/Stripping out not letters or numbers You mean replacing anything that isn't a num or a letter? CFSET STR = Some original string CFSET CLEAN_STR = REReplaceNoCase(STR,[^0-9a-z],,ALL) Normally you would want to keep spaces as well. If so, add a space after 'z'. == = Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:42 AM To: CF-Talk Subject: Parsing/Stripping out not letters or numbers Anyone know how I may do this? We're running CF5. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Parsing/Stripping out not letters or numbers
#REReplace(myvar,[^[:alnum:]],,ALL)# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: vrijdag 2 november 2001 15:42 To: CF-Talk Subject: Parsing/Stripping out not letters or numbers Anyone know how I may do this? We're running CF5. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Parsing/Stripping out not letters or numbers
one of those silly little questions, but is there any preference in using: ReplaceNoCase(STR,[^0-9a-zA-Z],,ALL) or REReplaceNoCase(STR,[^0-9a-z],,ALL) to replace case-insensitively? No... to be honest, I think I prefer the first, it looks better. Not sure why I used the second. Maybe it's the moon's fault. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Parsing/Stripping out not letters or numbers
I was going to reply and say that this doesn't work, because I've never been able to get [^ (special) ] to work, but then I noticed you used one bracket: [:alnum:]. In the past, I've tried [^[[:alnum:]]] and wasn't able to get it working. Your code works perfect, and is better than my 0-9a-z thing. (and, thanks for showing me this! I've always reverted to a-z, etc, when I need a ^ type clause.) === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:09 AM To: CF-Talk Subject: RE: Parsing/Stripping out not letters or numbers #REReplace(myvar,[^[:alnum:]],,ALL)# ~~ 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: commas in lists
The problem with using ListChangeDelims in this case is that it will treat the commas within quotes the same way as it treats the commas outside the quotes. That's part of the original problem. --- Raymond Camden [EMAIL PROTECTED] wrote: Instead of the Replace, don't forget you can use ListChangeDelims. /CFDOCS/CFML_Reference/Functions137.html#1107244 === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:32 AM To: CF-Talk Subject: RE: commas in lists Try this strategy: // default delimiter is a comma cfset myDelimiter=, //if If Find(yourList,',') // replace , by an unprintable character yourList = Replace(yourList,',',CHR(7)) // Remove opening and closing Replace(yourList,'',) // Change your delimiter to CHR(7) cfset myDelimiter=CHR(7) end if Now pass in myDelimiter along with your list whenever you use CF's list manipulation functions P.S. I don't feel that this is a particular deficiency of CF. I think making it smart enough to not ignore quotes would be a bad thing. You just have to deal with it properly. Well, this didn't work. CF ignors the quotes and treats all commas it finds as delimiters Any ideas how I can allow a comma in the list? CF is stupid about commas in lists, so, here's an idea... put , in front of the list , at the end and use , as the delimiter = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ 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: commas in lists
Try this out cfoutput #ListChangeDelims(aa;bb;;;cc,|,;)#br #Replace(aa;bb;;;cc,;,|,ALL)# /cfoutput Replace will replace all occurrences of ; by a | Listchangedelims will replace the three consecutive ; as one | Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: vrijdag 2 november 2001 15:58 To: CF-Talk Subject: RE: commas in lists ListChangeDelims() is wierd though in that it will allow you to replace a single delimiter with multiple delimiters eg: listchangedelims(thislist, ',', ',') I find this unexpected behaviour in that other list functions only act on single delimiters. (ie listfind(thislist, 'myvalue', ',') uses '' or ',' as delimiters, not ','). I would expect multiple delimiters to be not allowed. I'm struggling to find the differences here between listchangedelims() and replace(). ~~ 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: Parsing/Stripping out not letters or numbers
soz - typo - I meant the following 2: REReplace(STR,[^0-9a-zA-Z],,ALL) or REReplaceNoCase(STR,[^0-9a-z],,ALL) diff between REReplace and REReplaceNoCase -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 15:00 To: CF-Talk Subject: RE: Parsing/Stripping out not letters or numbers Raymond, one of those silly little questions, but is there any preference in using: ReplaceNoCase(STR,[^0-9a-zA-Z],,ALL) or REReplaceNoCase(STR,[^0-9a-z],,ALL) to replace case-insensitively? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 14:59 To: CF-Talk Subject: RE: Parsing/Stripping out not letters or numbers You mean replacing anything that isn't a num or a letter? CFSET STR = Some original string CFSET CLEAN_STR = REReplaceNoCase(STR,[^0-9a-z],,ALL) Normally you would want to keep spaces as well. If so, add a space after 'z'. == = Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:42 AM To: CF-Talk Subject: Parsing/Stripping out not letters or numbers Anyone know how I may do this? We're running CF5. ~~ 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: commas in lists
Certainly, but my point was that the person who followed up with a way to change delims may not have known about this 'native' function. As one of the maintainers of cflib, I see _numerous_ submissions where people forget about various native cfml functions. :) -RC The problem with using ListChangeDelims in this case is that it will treat the commas within quotes the same way as it treats the commas outside the quotes. That's part of the original problem. --- Raymond Camden [EMAIL PROTECTED] wrote: Instead of the Replace, don't forget you can use ListChangeDelims. /CFDOCS/CFML_Reference/Functions137.html#1107244 ~~ 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
Printing 11x17 Reports
I am tasked with converting to ColdFusion a set of reports currently produced in MS Access. These report needs to be printed on 11 x 17 paper with headers, footers and other features that a web browser doesn't do. What product can I use, and where do I begin? Please explain everything, assume I know nothing other than how to use ColdFusion. Thanks, Joy ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Parsing/Stripping out not letters or numbers
Err, the difference would be that the first doesn't support using regexps and the second does? Or has something been changed here? Regards, Joel Parramore -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:09 AM To: CF-Talk Subject: RE: Parsing/Stripping out not letters or numbers one of those silly little questions, but is there any preference in using: ReplaceNoCase(STR,[^0-9a-zA-Z],,ALL) or REReplaceNoCase(STR,[^0-9a-z],,ALL) to replace case-insensitively? No... to be honest, I think I prefer the first, it looks better. Not sure why I used the second. Maybe it's the moon's fault. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Parsing/Stripping out not letters or numbers
Ah, a typo. Okay... Disregard previous reply... Regards, Joel Parramore -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:10 AM To: CF-Talk Subject: RE: Parsing/Stripping out not letters or numbers soz - typo - I meant the following 2: REReplace(STR,[^0-9a-zA-Z],,ALL) or REReplaceNoCase(STR,[^0-9a-z],,ALL) diff between REReplace and REReplaceNoCase -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 15:00 To: CF-Talk Subject: RE: Parsing/Stripping out not letters or numbers Raymond, one of those silly little questions, but is there any preference in using: ReplaceNoCase(STR,[^0-9a-zA-Z],,ALL) or REReplaceNoCase(STR,[^0-9a-z],,ALL) to replace case-insensitively? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 14:59 To: CF-Talk Subject: RE: Parsing/Stripping out not letters or numbers You mean replacing anything that isn't a num or a letter? CFSET STR = Some original string CFSET CLEAN_STR = REReplaceNoCase(STR,[^0-9a-z],,ALL) Normally you would want to keep spaces as well. If so, add a space after 'z'. == = Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:42 AM To: CF-Talk Subject: Parsing/Stripping out not letters or numbers Anyone know how I may do this? We're running CF5. ~~ 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: commas in lists
Yea - but again, that too is unexpected behaviour in that CF doesn't recognise empty list elements as valid, and removes them. -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 15:18 To: CF-Talk Subject: RE: commas in lists Try this out cfoutput #ListChangeDelims(aa;bb;;;cc,|,;)#br #Replace(aa;bb;;;cc,;,|,ALL)# /cfoutput Replace will replace all occurrences of ; by a | Listchangedelims will replace the three consecutive ; as one | Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: vrijdag 2 november 2001 15:58 To: CF-Talk Subject: RE: commas in lists ListChangeDelims() is wierd though in that it will allow you to replace a single delimiter with multiple delimiters eg: listchangedelims(thislist, ',', ',') I find this unexpected behaviour in that other list functions only act on single delimiters. (ie listfind(thislist, 'myvalue', ',') uses '' or ',' as delimiters, not ','). I would expect multiple delimiters to be not allowed. I'm struggling to find the differences here between listchangedelims() and replace(). ~~ 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
related selects
im interested in doing 4 related selects. i see that there is an example at http://www.pengoworks.com/qForms/docs/examples/n-related_selectboxes.htm but i was wondering if cf could mix with the js code? ive tried before with not much sucess. has anyone used this form in conjunction with cold fusion code. and if so, would you mind sharing an example? thanks so much, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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
Turbolink/United Stationers...
Hello all- Got one from way out in left field. Anyone ever dealt with parsing export files from a company called United Stationers? They have a proprietary conduit for transmitting invoices from to and from vendors. My client's client uses United Stationers for office supplies, and needs me to build an app which takes order info from an AbleCommerce DB, match it up with the export file from US' Turbolink product to get accurate current pricing (the prices change without notice from time to time) and then export the records to a text file importable by Quickbooks. Fun fun. I've got the export to Quickbooks pretty much down, but US tech support is almost non-existent, and their docs are horrible. The sample export file that I managed to get tells me nothing of what I need to parse out, so I'm beating my head against a wall here. To top it off, my client is under major pressure to have this thing done yesterday, so I am too. Any help would be appreciated. Kevin Langevin Web Guy in Charge UsWebGuys 954-327-5780 [EMAIL PROTECTED] -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:39 AM To: CF-Talk Subject: related selects im interested in doing 4 related selects. i see that there is an example at http://www.pengoworks.com/qForms/docs/examples/n-related_selectboxes.htm but i was wondering if cf could mix with the js code? ive tried before with not much sucess. has anyone used this form in conjunction with cold fusion code. and if so, would you mind sharing an example? thanks so much, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: related selects
Becky, As the author of qForms I can tell you it integrates *extremely* well w/ColdFusion. As a matter of fact, many of the features of the API derived as a way of making it easier to develop complex applications w/server-side technologies--and most specifically, ColdFusion. I would recommend playing around with the API and getting used to it before doing a 4-related select box--especially if you're not very familiar w/JS. I only say this, because I find that the most common mistake people make the first time they try to use the API, is they try to add as much stuff as possible, without really understanding what they're adding. This makes it very hard to troubleshooting where the problem lies. Doing the related select boxes w/qForms is actually pretty easy--the hard part designing the data structure. I'd recommend just playing around with creating a simple 2-related select box at first and really reading the documentation on the populate() method--which is the real key to the whole thing. -Dan -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:39 AM To: CF-Talk Subject: related selects im interested in doing 4 related selects. i see that there is an example at http://www.pengoworks.com/qForms/docs/examples/n-related_selectboxes.htm but i was wondering if cf could mix with the js code? ive tried before with not much sucess. has anyone used this form in conjunction with cold fusion code. and if so, would you mind sharing an example? thanks so much, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: Caching Queries
I've heard of someone that looks at the execution time of a query, when it exceedes a certain standard the query's will be cached (at a busy time or something like that). I'ts a way to cache it when you need it - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 9:03 PM Subject: Caching Queries An application I am working with is really bogging down a database server. Can anybody point out an online resource to the pros/cons of caching queries? Maybe I'm making this more than it is and it's not that complicated. I'm just wondering if caching queries is an eventuality for web applications that get a lot of traffic. 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
Newbie question
I new to this list and new to CF. I have a question though. I have a very small search engine I am trying to create. I am using CF 5 and I am using Access as the database. I can get it to find the entries, but it only sees the first keyword and nothing after that. Here is my code see if you can help me PLEASE! I also need to be able to shoot an error if they enter a keyword that is not listed. I am completely lost about what I am doing wrong. CFQUERY NAME=search DATASOURCE=search SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords = keywords cfif keywords IS NOT AND keywords LIKE '#keywords#%' CFELSE h3You did not enter a keyword!!/h3 /cfif /CFQUERY html head titleUntitled/title /head body cfoutput query=search strong#search.RecordCount#nbsp;nbsp;Results/strongbrbrbr table cellspacing=2 cellpadding=2 border=0 tr td/td /tr tr td#title#/td /tr tr td#Description#/td /tr tr tda href=#hyperlink#Test/a/td /tr /table /cfoutput Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com ~~ 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
cgi.http_referer problem
Hi All, As I understand that cgi.http_referer created by the browser only when the user follows a link or submit a form to the current page. So sometimes it could be blank. With this in mind we put this piece of code in our action page: cfif attributes.method contains Action cfif listGetAt(cgi.HTTP_REFERER,2,/) neq cgi.HTTP_HOST cflocation url=index.cfm addtoken=no cfabort /cfif /cfif Also after an action page is called it relocated to another page so the action page shouldn't be bookmarked accidentally. But still sometimes we received an error message indicate that the cgi.http_referer is empty. This occurred even with IE5.0 For this error message we can check to see if the cgi.http_referer is empty first, but we do not want to throw the right person away by mistake. So the question is: Is there any other situation when the cgi.http_referer would not be get set? Any suggestions will be greatly appreciate! ~~ 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: Printing 11x17 Reports
Hi Joy, Can't give you too many details, because it's quite a time since I used it, but I once used Crytal Reports for doing something similar, and it was very successful. Don't get confused with the CF documentation, though, Crytal Reports is a separate product, it doesn't come bundled with CF, although it has very neat integration using the cfreport tag. -Original Message- From: Joy Bedell [mailto:[EMAIL PROTECTED]] Sent: 02 November 2001 15:17 To: CF-Talk Subject: Printing 11x17 Reports I am tasked with converting to ColdFusion a set of reports currently produced in MS Access. These report needs to be printed on 11 x 17 paper with headers, footers and other features that a web browser doesn't do. What product can I use, and where do I begin? Please explain everything, assume I know nothing other than how to use ColdFusion. Thanks, Joy ~~ 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: Newbie question
Take a look at using verity and CFCOLLECTION Doug - Original Message - From: Steven Lancaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 8:09 AM Subject: Newbie question I new to this list and new to CF. I have a question though. I have a very small search engine I am trying to create. I am using CF 5 and I am using Access as the database. I can get it to find the entries, but it only sees the first keyword and nothing after that. Here is my code see if you can help me PLEASE! I also need to be able to shoot an error if they enter a keyword that is not listed. I am completely lost about what I am doing wrong. CFQUERY NAME=search DATASOURCE=search SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords = keywords cfif keywords IS NOT AND keywords LIKE '#keywords#%' CFELSE h3You did not enter a keyword!!/h3 /cfif /CFQUERY html head titleUntitled/title /head body cfoutput query=search strong#search.RecordCount#nbsp;nbsp;Results/strongbrbrbr table cellspacing=2 cellpadding=2 border=0 tr td/td /tr tr td#title#/td /tr tr td#Description#/td /tr tr tda href=#hyperlink#Test/a/td /tr /table /cfoutput Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access OLE DB vs. ODBC
I've screamed about this OLE DB vs. ODBC for almost a year, and no one ever gives me any concrete answers or benchmarks! There was an article in CF Developer's Journal a year or so back about how to set up OLE DB... The author couldn't disclose the speed differences because they were done without adhering to any strict standards, whatever that means. It was just a bunch of bull, because the article focused more on getting OLE DB to work (what a chore it was on CF 4.x -- don't know about CF 5 server). After the author jumped through numerous hoops, I bet he found no speed gain, probably a speed deficiency, so he downplayed benchmarking. Wonderful! Now I have an OLE DB connection which took a half-hour to set up, and it's slow as molasses anyway. All I know is, OLE DB is SLOWER than ODBC when I ran a bunch of tests, with Access. I have seen no speed gain with OLE DB. Access using ODBC is a lot faster for small to medium-sized queries; when you hit queries that return super-large result sets, the two get closer together in speed. But let's face it, if you need an Enterprise database solution, you won't be using Access, because it WILL crap out sooner or later under load. Andy -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 7:58 PM To: CF-Talk Subject: Re: Access OLE DB vs. ODBC My experience was it either worked very well or not at all. I have one big site that uses still Access 2k and OLEDB and gives me absolutely no trouble. Works so well I've been lazy and left it alone for over a year like that. I wasn't always so lucky. There's one particular weird error that crops up for no apparent reason on some files. If you have the problem with your file spec you'll know immediately. Was never able to track down exactly what it was that caused the trouble. From what I saw in the CF forums at the time I wasn't the only one so afflicted, and no one else had any luck tracking down the root cause, either. Give it a shot. You can always switch back. Heck, you have nowhere to go but up ;D --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 31 Oct 2001 13:13:25 -0700 We've got a couple of customers that we host who insist on using Access 97 as their database. One of them has a fairly busy site and a single large Access database of about 1/2 GB. The CF server that hosts the site becomes occasionally unresponsive, no doubt due to the use of Access. Migrating the site to MS SQL is in the works, but we're not in the loop on that, so we can only wait for the customer to complete the job. In the meantime, we need to get the system as stable as we can. Does anyone have much experience using OLE DB instead of ODBC to connect to Access databases that might be able to say whether it's any more stable? I know that articles in the Allaire knowledgebase recommend OLE DB over ODBC. Are there any differences in SQL statements when using OLE DB - that is, any code changes required when changing from Access ODBC to OLE DB? Thanks, Jim ~~ 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: is someone try to hack my server?
you already have. these are log files showing that the folder traversal vulnerability (in one of it's MANY available exploits) has already been patched. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 4:08 AM To: CF-Talk Subject: OT: is someone try to hack my server? hi, I get all these error from my apache error log file, can someone help me by explaining what caused this? seems like someone is hacking my server, thank god, i'm not using NT server. but still it makes my server's response slow. [Fri Nov 2 12:19:25 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/root.exe [Fri Nov 2 12:19:27 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/MSADC/root.exe [Fri Nov 2 12:19:29 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/c/winnt/system32/cmd.exe [Fri Nov 2 12:19:48 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/d/winnt/system32/cmd.exe [Fri Nov 2 12:20:01 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..%5c../winnt/system32/cmd.exe [Fri Nov 2 12:20:08 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/_vti_bin/..%5c../..%5c../..%5c../winnt/system32/cmd.exe [Fri Nov 2 12:20:08 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/_mem_bin/..%5c../..%5c../..%5c../winnt/system32/cmd.exe [Fri Nov 2 12:20:09 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/msadc/..%5c../..%5c../..%5c/..Á../..Á../..Á ./winnt/ syst em32/cmd.exe [Fri Nov 2 12:20:10 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..Á../winnt/system32/cmd.exe [Fri Nov 2 12:20:12 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..À¯../winnt/system32/cmd.exe [Fri Nov 2 12:20:13 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..Áoe../winnt/system32/cmd.exe [Fri Nov 2 12:20:15 2001] [error] [client 203.255.177.169] File does not exist: /web/Data/ishome/scripts/..%5c../winnt/system32/cmd.exe any way that i can prevent all these? ~~ 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: Newbie question
Do you know of a resource that I can look at to give me more info.? Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:49 AM To: CF-Talk Subject: Re: Newbie question Take a look at using verity and CFCOLLECTION Doug - Original Message - From: Steven Lancaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 8:09 AM Subject: Newbie question I new to this list and new to CF. I have a question though. I have a very small search engine I am trying to create. I am using CF 5 and I am using Access as the database. I can get it to find the entries, but it only sees the first keyword and nothing after that. Here is my code see if you can help me PLEASE! I also need to be able to shoot an error if they enter a keyword that is not listed. I am completely lost about what I am doing wrong. CFQUERY NAME=search DATASOURCE=search SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords = keywords cfif keywords IS NOT AND keywords LIKE '#keywords#%' CFELSE h3You did not enter a keyword!!/h3 /cfif /CFQUERY html head titleUntitled/title /head body cfoutput query=search strong#search.RecordCount#nbsp;nbsp;Results/strongbrbrbr table cellspacing=2 cellpadding=2 border=0 tr td/td /tr tr td#title#/td /tr tr td#Description#/td /tr tr tda href=#hyperlink#Test/a/td /tr /table /cfoutput Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com ~~ 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: Newbie question
If someone searched multiple key words like Baseball football soccer And you are searching on 'Baseball football soccer%' The whole string 'baseball football soccer' would Have to appear the % only implies that any records with Baseball football soccer AND THEN SOME, would appear. Take Dougs suggestion and use CFCOLLECTION -Original Message- From: Steven Lancaster [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:09 AM To: CF-Talk Subject: Newbie question I new to this list and new to CF. I have a question though. I have a very small search engine I am trying to create. I am using CF 5 and I am using Access as the database. I can get it to find the entries, but it only sees the first keyword and nothing after that. Here is my code see if you can help me PLEASE! I also need to be able to shoot an error if they enter a keyword that is not listed. I am completely lost about what I am doing wrong. CFQUERY NAME=search DATASOURCE=search SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords = keywords cfif keywords IS NOT AND keywords LIKE '#keywords#%' CFELSE h3You did not enter a keyword!!/h3 /cfif /CFQUERY html head titleUntitled/title /head body cfoutput query=search strong#search.RecordCount#nbsp;nbsp;Results/strongbrbrbr table cellspacing=2 cellpadding=2 border=0 tr td/td /tr tr td#title#/td /tr tr td#Description#/td /tr tr tda href=#hyperlink#Test/a/td /tr /table /cfoutput Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF vars from JavaScript vars?
Folks: Anyone know how to convert Client JavaScript variables to CF variables? Example : I would like to grab the value from the following variable, whose location is in a JavaScript block in child pop-up window : opener.document.myForm.myVariable.value I would assume that since JS is Client-Side and CF is Server-Side, that this type of interaction isn't possible. Any ideas? Thanks, Christian N. Abad ColdFusion Web Developer ~~ 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: Newbie question
Well the CF Help files themselves have quite a bit of info on how to use that tag. Also check Allaires Knowledge base and support forums for more info. Kelly www.webdiva.org -Original Message- From: Steven Lancaster [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:50 AM To: CF-Talk Subject: RE: Newbie question Do you know of a resource that I can look at to give me more info.? Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:49 AM To: CF-Talk Subject: Re: Newbie question Take a look at using verity and CFCOLLECTION Doug - Original Message - From: Steven Lancaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 8:09 AM Subject: Newbie question I new to this list and new to CF. I have a question though. I have a very small search engine I am trying to create. I am using CF 5 and I am using Access as the database. I can get it to find the entries, but it only sees the first keyword and nothing after that. Here is my code see if you can help me PLEASE! I also need to be able to shoot an error if they enter a keyword that is not listed. I am completely lost about what I am doing wrong. CFQUERY NAME=search DATASOURCE=search SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords = keywords cfif keywords IS NOT AND keywords LIKE '#keywords#%' CFELSE h3You did not enter a keyword!!/h3 /cfif /CFQUERY html head titleUntitled/title /head body cfoutput query=search strong#search.RecordCount#nbsp;nbsp;Results/strongbrbrbr table cellspacing=2 cellpadding=2 border=0 tr td/td /tr tr td#title#/td /tr tr td#Description#/td /tr tr tda href=#hyperlink#Test/a/td /tr /table /cfoutput Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com ~~ 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 OLE DB vs. ODBC
I think the whole OLEDB is faster than ODBC argument came out of the ADO Programmer's Reference book. If you do a web search for any articles that offer hard number comparisons (I'm using Google) all you can find (or at least all I've been able to find) is reference to some metrics that were put forth in the ADO 2.0 Programmer's Reference (though a lot of people seem to be referencing this). The numbers were (to SQL Server): Connection Times via OLEDB: 18 (I'm assuming this is supposed to be ms) Vs DSN Connection: 82 I personally have tried some comparisons on my own when I was doing Performance Analysis with the old Allaire Consulting group and have found the difference to be nominal when connecting to SQL Server. Maybe others have some other useful data on this, I'm just speaking from my own experiences. J. -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:46 AM To: CF-Talk Subject: RE: Access OLE DB vs. ODBC I've screamed about this OLE DB vs. ODBC for almost a year, and no one ever gives me any concrete answers or benchmarks! There was an article in CF Developer's Journal a year or so back about how to set up OLE DB... The author couldn't disclose the speed differences because they were done without adhering to any strict standards, whatever that means. It was just a bunch of bull, because the article focused more on getting OLE DB to work (what a chore it was on CF 4.x -- don't know about CF 5 server). After the author jumped through numerous hoops, I bet he found no speed gain, probably a speed deficiency, so he downplayed benchmarking. Wonderful! Now I have an OLE DB connection which took a half-hour to set up, and it's slow as molasses anyway. All I know is, OLE DB is SLOWER than ODBC when I ran a bunch of tests, with Access. I have seen no speed gain with OLE DB. Access using ODBC is a lot faster for small to medium-sized queries; when you hit queries that return super-large result sets, the two get closer together in speed. But let's face it, if you need an Enterprise database solution, you won't be using Access, because it WILL crap out sooner or later under load. Andy -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 7:58 PM To: CF-Talk Subject: Re: Access OLE DB vs. ODBC My experience was it either worked very well or not at all. I have one big site that uses still Access 2k and OLEDB and gives me absolutely no trouble. Works so well I've been lazy and left it alone for over a year like that. I wasn't always so lucky. There's one particular weird error that crops up for no apparent reason on some files. If you have the problem with your file spec you'll know immediately. Was never able to track down exactly what it was that caused the trouble. From what I saw in the CF forums at the time I wasn't the only one so afflicted, and no one else had any luck tracking down the root cause, either. Give it a shot. You can always switch back. Heck, you have nowhere to go but up ;D --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 31 Oct 2001 13:13:25 -0700 We've got a couple of customers that we host who insist on using Access 97 as their database. One of them has a fairly busy site and a single large Access database of about 1/2 GB. The CF server that hosts the site becomes occasionally unresponsive, no doubt due to the use of Access. Migrating the site to MS SQL is in the works, but we're not in the loop on that, so we can only wait for the customer to complete the job. In the meantime, we need to get the system as stable as we can. Does anyone have much experience using OLE DB instead of ODBC to connect to Access databases that might be able to say whether it's any more stable? I know that articles in the Allaire knowledgebase recommend OLE DB over ODBC. Are there any differences in SQL statements when using OLE DB - that is, any code changes required when changing from Access ODBC to OLE DB? Thanks, Jim ~~ 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 OLE DB vs. ODBC
BTW, here's a link to one of the few sites I found that had any numbers associated with the comparison for those who are interested. http://www.4guysfromrolla.com/webtech/063099-1.shtml J. -Original Message- From: John Cummings [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 12:14 PM To: '[EMAIL PROTECTED]' Subject: RE: Access OLE DB vs. ODBC I think the whole OLEDB is faster than ODBC argument came out of the ADO Programmer's Reference book. If you do a web search for any articles that offer hard number comparisons (I'm using Google) all you can find (or at least all I've been able to find) is reference to some metrics that were put forth in the ADO 2.0 Programmer's Reference (though a lot of people seem to be referencing this). The numbers were (to SQL Server): Connection Times via OLEDB: 18 (I'm assuming this is supposed to be ms) Vs DSN Connection: 82 I personally have tried some comparisons on my own when I was doing Performance Analysis with the old Allaire Consulting group and have found the difference to be nominal when connecting to SQL Server. Maybe others have some other useful data on this, I'm just speaking from my own experiences. J. -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:46 AM To: CF-Talk Subject: RE: Access OLE DB vs. ODBC I've screamed about this OLE DB vs. ODBC for almost a year, and no one ever gives me any concrete answers or benchmarks! There was an article in CF Developer's Journal a year or so back about how to set up OLE DB... The author couldn't disclose the speed differences because they were done without adhering to any strict standards, whatever that means. It was just a bunch of bull, because the article focused more on getting OLE DB to work (what a chore it was on CF 4.x -- don't know about CF 5 server). After the author jumped through numerous hoops, I bet he found no speed gain, probably a speed deficiency, so he downplayed benchmarking. Wonderful! Now I have an OLE DB connection which took a half-hour to set up, and it's slow as molasses anyway. All I know is, OLE DB is SLOWER than ODBC when I ran a bunch of tests, with Access. I have seen no speed gain with OLE DB. Access using ODBC is a lot faster for small to medium-sized queries; when you hit queries that return super-large result sets, the two get closer together in speed. But let's face it, if you need an Enterprise database solution, you won't be using Access, because it WILL crap out sooner or later under load. Andy -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 7:58 PM To: CF-Talk Subject: Re: Access OLE DB vs. ODBC My experience was it either worked very well or not at all. I have one big site that uses still Access 2k and OLEDB and gives me absolutely no trouble. Works so well I've been lazy and left it alone for over a year like that. I wasn't always so lucky. There's one particular weird error that crops up for no apparent reason on some files. If you have the problem with your file spec you'll know immediately. Was never able to track down exactly what it was that caused the trouble. From what I saw in the CF forums at the time I wasn't the only one so afflicted, and no one else had any luck tracking down the root cause, either. Give it a shot. You can always switch back. Heck, you have nowhere to go but up ;D --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 31 Oct 2001 13:13:25 -0700 We've got a couple of customers that we host who insist on using Access 97 as their database. One of them has a fairly busy site and a single large Access database of about 1/2 GB. The CF server that hosts the site becomes occasionally unresponsive, no doubt due to the use of Access. Migrating the site to MS SQL is in the works, but we're not in the loop on that, so we can only wait for the customer to complete the job. In the meantime, we need to get the system as stable as we can. Does anyone have much experience using OLE DB instead of ODBC to connect to Access databases that might be able to say whether it's any more stable? I know that articles in the Allaire knowledgebase recommend OLE DB over ODBC. Are there any differences in SQL statements when using OLE DB - that is, any code changes required when changing from Access ODBC to OLE DB? Thanks, Jim ~~ 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:
~~OT: Need help building server
HEL! I am moving all of our websites else where and need help with the new server specs. This is what we have. At least 15 different web sites. Maybe a 150 domain names that need to point to any one of these 15 sites. 150,000 hits a month average Use ColdFusion, ASP, SQL server, Informix, Flash sub domains Stats What would you all recommend for the server OS CPU speed and number of them Ram Hard Drive Bandwidth Stat software I guess it would be best to run CF Server 5 on Win 2000. I am looking at Burlee.com and Rackspace.com for the dedicated hosting but I am still open to ideas. That's about as far as I have gotten and with the little knowledge I have. Thanks Phillip ~~ 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: CF vars from JavaScript vars?
oi Christian!! you'd have to pass it's value into a form object for a post back to the server. -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Friday, November 02, 2001, 1:45:09 PM, you wrote: CA Folks: CA Anyone know how to convert Client JavaScript variables to CF variables? CA Example : CA I would like to grab the value from the following variable, whose location CA is in a JavaScript block in child pop-up window : CA opener.document.myForm.myVariable.value CA I would assume that since JS is Client-Side and CF is Server-Side, that this CA type of interaction isn't possible. CA Any ideas? CA Thanks, CA Christian N. Abad CA ColdFusion Web Developer CA ~~ 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
Content Management light
Just wondering if anyone knows of a lightweight (possibly free) Content management application. Requirements: Allow groups within a company to add files and categories. Also, possibly have a browser based html editor to add content quickly. Does not need security. just needs to be easily portable to an internal website. * A vehicle that will allow for groups on an intranet to quickly add files, and create content for internal communication. ~~ 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: Newbie question
Try this, sloppy code but hope it helps: Jason Larson [EMAIL PROTECTED] html head titleUntitled/title /head body cfif Form.Keyword NEQ CFQUERY NAME=search DATASOURCE=search SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords LIKE '%#Form.Keywords#%' /CFQUERY cfset TotalRecords = Search.RecordCount cfelse h3You did not enter a keyword!!/h3 /cfif cfif isdefined(TotalRecords) AND TotalRecords NEQ 0 strong#TotalRecords#nbsp;nbsp;Results/strongbrbrbr table cellspacing=2 cellpadding=2 border=0 cfoutput query=search tr td/td /tr tr td#title#/td /tr tr td#Description#/td /tr tr tda href=#hyperlink#Test/a/td /tr /cfoutput /table /cfif /body /html -Original Message- From: Steven Lancaster [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:09 AM To: CF-Talk Subject: Newbie question I new to this list and new to CF. I have a question though. I have a very small search engine I am trying to create. I am using CF 5 and I am using Access as the database. I can get it to find the entries, but it only sees the first keyword and nothing after that. Here is my code see if you can help me PLEASE! I also need to be able to shoot an error if they enter a keyword that is not listed. I am completely lost about what I am doing wrong. CFQUERY NAME=search DATASOURCE=search SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords = keywords cfif keywords IS NOT AND keywords LIKE '#keywords#%' CFELSE h3You did not enter a keyword!!/h3 /cfif /CFQUERY html head titleUntitled/title /head body cfoutput query=search strong#search.RecordCount#nbsp;nbsp;Results/strongbrbrbr table cellspacing=2 cellpadding=2 border=0 tr td/td /tr tr td#title#/td /tr tr td#Description#/td /tr tr tda href=#hyperlink#Test/a/td /tr /table /cfoutput /body /html Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Single user CF5 license available
It's worth noting ... if you do supplemental development at home ... which I take by implication that we're talking about a person who has a job at an office location where CFStudio is installed it's worth noting that the CFStudio license allows you to install CFStudio at home. You can install CFStudio on any number of machines that you personally use and use exclusively, or at least nobody else uses CFStudio on those machines. For example, you can install it at work, on your laptop and on your home machine. From the license: One copy of Cold Fusion Studio software may either be used (1) by a single person who uses the software personally on one or more computers, or (2) by multiple people non-simultaneously on a single workstation, but not both. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Scott Brady [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 2:27 PM To: CF-Talk Subject: Re: Single user CF5 license available BF wrote (can I call ya BF?): Scott, that was the same for the prior version too. It is intended for use with Studio. --- Ben The same for the previous version of the single user license? If so, then fine. They should release a version 5 of CFExpress. They have a lot of users who develop at home, (but don't host at home), and don't want to be forced to purchase CF Studio in order to do so. I mean, we're not even talking about a product they sell (single-user version of the server) and it's not usable in a production environment. If someone is stupid enough to actually host from home while using it, then they risk getting caught with a simple visit to Netcraft. I love Cold Fusion and I'm quite good at it (not trying to sound arrogant, really). But, I'm also good enough to switch to a non-MM technology [I've been learning ASP and am learning JSP, which doesn't require JRun], which would allow me to develop at home without shelling out $500 for a program that has more features than I really need for home development. (I'm not trying to harass you, Ben, since you're just the Evangelist.) I'd even be happy with letting HomeSite users (at $100, that's at least much more reasonable) use the single-user license. Scott Scott Brady http://www.scottbrady.net/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access OLE DB vs. ODBC
What you're going to gain is *not* going to be speed but increased stability *under load*. There's an Allaire KB in there somewhere about using Access in a production environment, where the only real point discussed, if I recall correctly, was that your server is a lot less likely to bust a gut if you're using OLEDB drivers. Once I got rid of most of the Access db's on my server my memory requirements went way down (leaky odbc drivers) and the thing suddenly became solid as a rock. If you're stuck with Access then try the OLEDB as it will work better, if it works at all. If you have control of your own server mySQL for Windows is probably your next best bet, unless you have an extra $5,000 you need to spend, or a dire need for stored procs or triggers. - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Andrew Tyrone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 8:46 AM Subject: RE: Access OLE DB vs. ODBC I've screamed about this OLE DB vs. ODBC for almost a year, and no one ever gives me any concrete answers or benchmarks! There was an article in CF Developer's Journal a year or so back about how to set up OLE DB... The author couldn't disclose the speed differences because they were done without adhering to any strict standards, whatever that means. It was just a bunch of bull, because the article focused more on getting OLE DB to work (what a chore it was on CF 4.x -- don't know about CF 5 server). After the author jumped through numerous hoops, I bet he found no speed gain, probably a speed deficiency, so he downplayed benchmarking. Wonderful! Now I have an OLE DB connection which took a half-hour to set up, and it's slow as molasses anyway. All I know is, OLE DB is SLOWER than ODBC when I ran a bunch of tests, with Access. I have seen no speed gain with OLE DB. Access using ODBC is a lot faster for small to medium-sized queries; when you hit queries that return super-large result sets, the two get closer together in speed. But let's face it, if you need an Enterprise database solution, you won't be using Access, because it WILL crap out sooner or later under load. Andy -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 7:58 PM To: CF-Talk Subject: Re: Access OLE DB vs. ODBC My experience was it either worked very well or not at all. I have one big site that uses still Access 2k and OLEDB and gives me absolutely no trouble. Works so well I've been lazy and left it alone for over a year like that. I wasn't always so lucky. There's one particular weird error that crops up for no apparent reason on some files. If you have the problem with your file spec you'll know immediately. Was never able to track down exactly what it was that caused the trouble. From what I saw in the CF forums at the time I wasn't the only one so afflicted, and no one else had any luck tracking down the root cause, either. Give it a shot. You can always switch back. Heck, you have nowhere to go but up ;D --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Jim McAtee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 31 Oct 2001 13:13:25 -0700 We've got a couple of customers that we host who insist on using Access 97 as their database. One of them has a fairly busy site and a single large Access database of about 1/2 GB. The CF server that hosts the site becomes occasionally unresponsive, no doubt due to the use of Access. Migrating the site to MS SQL is in the works, but we're not in the loop on that, so we can only wait for the customer to complete the job. In the meantime, we need to get the system as stable as we can. Does anyone have much experience using OLE DB instead of ODBC to connect to Access databases that might be able to say whether it's any more stable? I know that articles in the Allaire knowledgebase recommend OLE DB over ODBC. Are there any differences in SQL statements when using OLE DB - that is, any code changes required when changing from Access ODBC to OLE DB? Thanks, Jim ~~ 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: cgi.http_referer problem
Short answer: Yes. I've been running and logging referer tests for about 6 months now. I get an email every time one fails, and record all initial 'incoming' visitors in a db that logs, among other things, browser type and referer value. Every once in a while I'll have a user get 'refered' in from my own site, which should be impossible given the tests I run. Only maybe 1 out of 100 fail, and the failure appears to be random... sort of. It appears to be restricted to IE 5.x and AOL browsers after AOL 4.0. However I haven't tried to quantify this other than eyeballing the reports. On occasion, maybe the browser drops the ball and somehow loses the referer value. This could also be user behavior: Lets say for some reason a page doesn't load properly for whatever reason. a user could place their cursor in the Address field at the end and hits the ENTER key. That would do it, too. (i.e. user 'arrives' at a page after hitting 'Enter' and actually refreshes it. The next link is a referred link in from my own site). - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Sima Lee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 8:20 AM Subject: cgi.http_referer problem snip So the question is: Is there any other situation when the cgi.http_referer would not be get set? ~~ 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: related selects
Just build the structure in CF and then use CFWDDX to put that structure into a JavaScript for qForms to use. Another way is to just use cfoutput tags inside the javascript, so that they put in all the code to build a JS structure once the browser gets the page source. I for some reason prefer to do the second option, but more people find that confusing since it is mixing client and server languages and they tend to not take into account the CF runs on the server and generates the code the client language would then need. Here is a example of how I do it: http://www.happyhacker.com/Code.cfm?Cat=CFSubCat=4Slcts Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion On Fri, 2 Nov 2001, Jones, Becky wrote: im interested in doing 4 related selects. i see that there is an example at http://www.pengoworks.com/qForms/docs/examples/n-related_selectboxes.htm but i was wondering if cf could mix with the js code? ive tried before with not much sucess. has anyone used this form in conjunction with cold fusion code. and if so, would you mind sharing an example? thanks so much, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ 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: Access Help
Hey there guys... I'm at a lose here and don't know where else to turn to. I have serveral Access DBs. They all have the same DB design. I need someway to 'merge' all these DBs together. I don't want to write a CF application to read all the data in etc, because I don't think it would be the most effective way to handle the problem. More so, I'm curious to know if Access has a feature to do this or not. Won ~~ 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 OLE DB vs. ODBC
BTW, here's a link to one of the few sites I found that had any numbers associated with the comparison for those who are interested. http://www.4guysfromrolla.com/webtech/063099-1.shtml interesting. all my tests w/cf *never* showed anything that clear cut. ~~ 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: File Upload Question
Does anyone know if there is a maximum file size limit that the HTTP protocol applies or that IIS applies by default when doing a file upload? I have a site where clients upload video files. Some of these video files can be up to 100MB. The site is written in PHP and CGI (perl, yuck!). I have set IIS's CGI timeout setting to well over an hour, however, I get the good ol The page cannot be displayed message whenever I try to upload a file over 25MBs. The error message appears within 30 seconds of the upload. When I upload a file of 25MBs, it takes roughly 15 minutes to upload the file, but it does upload successfully. So, why will a 25MB file upload with no problem but yet a 40MB file times out after 30 seconds? The form that passes the video to the server is PHP. Also, in the PHP script, I am using the set_time_limit(0) command, similar to CF's requesttimeout. The file that handles the upload itself is CGI. I couldn't find a command in cgi to set the timeout limit, so I set it in IIS. I know this is off topic, but I was hoping someone may have an idea about file uploads of this size. All of the file uploading I have done in the past have never gone over a few MBs. Thanks for any help, Jeff Stone Stone Grove Design [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: Content Management light
I've got one freebie right now that doesn't handle security or groups, but the pro version I'm finishing up has this functionality. Unlimited user tree, section-specific rights, tiered access, managerial approval of content etc. etc. Will integrate easily with any wysiwyg editor, but I do want to integrate one in as part of the pkg, although I may not have time to do that deal in the first release. http://foohbar.org/contentmonger/docs.cfm. Follow the link that says 'ContentMonger Pro is coming'. Just put up a link in there to a demo, although its display-only and doesn't yet have the scrn shots I want to put in. Later today for that. Chk the to-do list to see whats left to go. Contact me off-list for more info if you like. I just delayed release to take some time to integrate Hiermenus in for a new menu display option, and am building a slick forms-based form generator/processor. Maybe we can work something out if you don't want that stuff. Cheers, - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: John Anderson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 10:07 AM Subject: Content Management light Just wondering if anyone knows of a lightweight (possibly free) Content management application. Requirements: Allow groups within a company to add files and categories. Also, possibly have a browser based html editor to add content quickly. Does not need security. just needs to be easily portable to an internal website. * A vehicle that will allow for groups on an intranet to quickly add files, and create content for internal communication. ~~ 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: Newbie question
Are you using CF Studio? If so, just do a search for verity and then check out the cfcollection tag. If not you can go here to see it. This is CF 4.0 docs, but it has the tag and info you need http://www.allaire.com/documents/cf4/dochome.htm DB - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 10:47 AM Subject: RE: Newbie question Well the CF Help files themselves have quite a bit of info on how to use that tag. Also check Allaires Knowledge base and support forums for more info. Kelly www.webdiva.org -Original Message- From: Steven Lancaster [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:50 AM To: CF-Talk Subject: RE: Newbie question Do you know of a resource that I can look at to give me more info.? Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:49 AM To: CF-Talk Subject: Re: Newbie question Take a look at using verity and CFCOLLECTION Doug - Original Message - From: Steven Lancaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 8:09 AM Subject: Newbie question I new to this list and new to CF. I have a question though. I have a very small search engine I am trying to create. I am using CF 5 and I am using Access as the database. I can get it to find the entries, but it only sees the first keyword and nothing after that. Here is my code see if you can help me PLEASE! I also need to be able to shoot an error if they enter a keyword that is not listed. I am completely lost about what I am doing wrong. CFQUERY NAME=search DATASOURCE=search SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords = keywords cfif keywords IS NOT AND keywords LIKE '#keywords#%' CFELSE h3You did not enter a keyword!!/h3 /cfif /CFQUERY html head titleUntitled/title /head body cfoutput query=search strong#search.RecordCount#nbsp;nbsp;Results/strongbrbrbr table cellspacing=2 cellpadding=2 border=0 tr td/td /tr tr td#title#/td /tr tr td#Description#/td /tr tr tda href=#hyperlink#Test/a/td /tr /table /cfoutput Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com ~~ 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: Content Management light
WE have a content management system we built. Its only $1,000.00 Canadian. Warren Jansons www.ironleaf.com -Original Message- From: John Anderson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:08 AM To: CF-Talk Subject: Content Management light Just wondering if anyone knows of a lightweight (possibly free) Content management application. Requirements: Allow groups within a company to add files and categories. Also, possibly have a browser based html editor to add content quickly. Does not need security. just needs to be easily portable to an internal website. * A vehicle that will allow for groups on an intranet to quickly add files, and create content for internal communication. ~~ 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 OLE DB vs. ODBC
Mine either. -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 2:25 PM To: CF-Talk Subject: Re: Access OLE DB vs. ODBC BTW, here's a link to one of the few sites I found that had any numbers associated with the comparison for those who are interested. http://www.4guysfromrolla.com/webtech/063099-1.shtml interesting. all my tests w/cf *never* showed anything that clear cut. ~~ 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
form question
Hi all I have a shopping cart page that posts to itself for updating a shopping cart. Since it posts back to itself I cannot use hidden fields to pass values or the structure will duplicate everything. Anybody have any Ideas on the subject? CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cgi.http_referer problem
Hi Matt, Thanks for your input. Yes, this does not happen very often, we got two from one site: Browser used: Mozilla/4.0 (compatible; MSIE 5.0; AOL 5.0; Windows 98; DigExt) Browser used: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) I guess we cannot do anything to prevent this to happen? Thank you again. Sima -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 12:35 PM To: CF-Talk Subject: Re: cgi.http_referer problem Short answer: Yes. I've been running and logging referer tests for about 6 months now. I get an email every time one fails, and record all initial 'incoming' visitors in a db that logs, among other things, browser type and referer value. Every once in a while I'll have a user get 'refered' in from my own site, which should be impossible given the tests I run. Only maybe 1 out of 100 fail, and the failure appears to be random... sort of. It appears to be restricted to IE 5.x and AOL browsers after AOL 4.0. However I haven't tried to quantify this other than eyeballing the reports. On occasion, maybe the browser drops the ball and somehow loses the referer value. This could also be user behavior: Lets say for some reason a page doesn't load properly for whatever reason. a user could place their cursor in the Address field at the end and hits the ENTER key. That would do it, too. (i.e. user 'arrives' at a page after hitting 'Enter' and actually refreshes it. The next link is a referred link in from my own site). - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Sima Lee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 8:20 AM Subject: cgi.http_referer problem snip So the question is: Is there any other situation when the cgi.http_referer would not be get set? ~~ 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: cgi.http_referer problem
If there is anything we can do I certainly haven't figured it out. If this is user behavior it would explain the scattered random nature of the problem. I have about 1 records in the db at the moment. If I get the time today I'll see if I can pin the problem on specific browsers, although it won't do much good to know, I think. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Sima Lee [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 2 Nov 2001 15:17:46 -0500 Hi Matt, Thanks for your input. Yes, this does not happen very often, we got two from one site: Browser used: Mozilla/4.0 (compatible; MSIE 5.0; AOL 5.0; Windows 98; DigExt) Browser used: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) I guess we cannot do anything to prevent this to happen? Thank you again. Sima -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 12:35 PM To: CF-Talk Subject: Re: cgi.http_referer problem Short answer: Yes. I've been running and logging referer tests for about 6 months now. I get an email every time one fails, and record all initial 'incoming' visitors in a db that logs, among other things, browser type and referer value. Every once in a while I'll have a user get 'refered' in from my own site, which should be impossible given the tests I run. Only maybe 1 out of 100 fail, and the failure appears to be random... sort of. It appears to be restricted to IE 5.x and AOL browsers after AOL 4.0. However I haven't tried to quantify this other than eyeballing the reports. On occasion, maybe the browser drops the ball and somehow loses the referer value. This could also be user behavior: Lets say for some reason a page doesn't load properly for whatever reason. a user could place their cursor in the Address field at the end and hits the ENTER key. That would do it, too. (i.e. user 'arrives' at a page after hitting 'Enter' and actually refreshes it. The next link is a referred link in from my own site). - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: Sima Lee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 8:20 AM Subject: cgi.http_referer problem snip So the question is: Is there any other situation when the cgi.http_referer would not be get set? ~~ 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: form question
Can you expand just a little on what you currently have. You are just a little broad here. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 1:57 PM To: CF-Talk Subject: form question Hi all I have a shopping cart page that posts to itself for updating a shopping cart. Since it posts back to itself I cannot use hidden fields to pass values or the structure will duplicate everything. Anybody have any Ideas on the subject? CF_SIGNATURE NAME=Douglas L. Brown EMAIL=[EMAIL PROTECTED] PHONE=714.538.6611 WEB=http://www.carnivorepc.com; ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Generator Issues
It's not the background color that has the problem, the image is a button with a background of one color, a shaped area and text over the top - we can't use just websafe colors as they are just too limiting - the anti-aliasing alone would throw it out of the window! I'm not suggesting that you use a websafe colour, only that you might want to test to see if using a websafe colour eliminates the problem. If it does then its the graphics engine that produces the GIF image that is causing the problem. If not (then it still might be the graphics engine) but it might be a format issue. Can you use a JPG? ~~ 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: File Upload Question
File uploads over http (using a form post) is limited by the amount of memory on your server. The protocol uploads the file to memory first, then your scripts transfer it from memory to disk, or whatever your scripts decide to do with it. So, if you only have 25 meg available ram, that would be the maximum file size you can upload. We ran into this a while back and have yet to find another solution (besides bumping the memory on the server). If you know of something to address this, let me know. That still doesn't explain why a 40 meg file would time out after only 30 seconds though. I'd suggest examining your CF application logs, or your server logs (application event log in NT). They might offer some insight. The problem I described above logs an NT error indicating Out of resources. Hope that helps. Shawn Grover -Original Message- From: Jeff Stone [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:26 AM To: CF-Talk Subject: OT: File Upload Question Does anyone know if there is a maximum file size limit that the HTTP protocol applies or that IIS applies by default when doing a file upload? I have a site where clients upload video files. Some of these video files can be up to 100MB. The site is written in PHP and CGI (perl, yuck!). I have set IIS's CGI timeout setting to well over an hour, however, I get the good ol The page cannot be displayed message whenever I try to upload a file over 25MBs. The error message appears within 30 seconds of the upload. When I upload a file of 25MBs, it takes roughly 15 minutes to upload the file, but it does upload successfully. So, why will a 25MB file upload with no problem but yet a 40MB file times out after 30 seconds? The form that passes the video to the server is PHP. Also, in the PHP script, I am using the set_time_limit(0) command, similar to CF's requesttimeout. The file that handles the upload itself is CGI. I couldn't find a command in cgi to set the timeout limit, so I set it in IIS. I know this is off topic, but I was hoping someone may have an idea about file uploads of this size. All of the file uploading I have done in the past have never gone over a few MBs. Thanks for any help, Jeff Stone Stone Grove Design [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
MS SQL ports
Hello, I am having hard time connecting to my development SQL server through the firewall. Both the web server and the DB server are on the DMZ port of my firewall, and I am trying to connect to the SQL box via EM from the LAN side of the firewall. The firewall in questions is a SonicWall Pro. I've opened up ports 1433 and 1434 for machines from the inside the LAN to the DMZ, but I am still timing out while trying to register the SQL server. I would greatly appreciate any tips as I am tired of running between floors when I need to adjust something in the database. 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: MS SQL ports
I am having hard time connecting to my development SQL server through the firewall. Both the web server and the DB server are on the DMZ port of my firewall, and I am trying to connect to the SQL box via EM from the LAN side of the firewall. The firewall in questions is a SonicWall Pro. I've opened up ports 1433 and 1434 for machines from the inside the LAN to the DMZ, but I am still timing out while trying to register the SQL server. I would greatly appreciate any tips as I am tired of running between floors when I need to adjust something in the database. This might be a stupid question, but have you configured Enterprise Manager to use TCP/IP instead of the default Named Pipes? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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
cfcontent file naming
Ok gang... I'm using to use CFCONTENT to deliver files from a non-web accessible directory. It works fine. The problem is the file name is always the page name that contains the CFCONTENT code. How do I get the download to use the original file name. There has to be something I'm missing here. Thanks! Justin Hansen - [EMAIL PROTECTED] Project Leader / Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 ~~ 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: cfcontent file naming
Ok gang... I'm using to use CFCONTENT to deliver files from a non-web accessible directory. It works fine. The problem is the file name is always the page name that contains the CFCONTENT code. How do I get the download to use the original file name. There has to be something I'm missing here. This might answer your question: http://www.figleaf.com/demo/mimetest/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MS SQL ports
Dave, I did. I can connect successfully to a box running on the LAN via TCP/IP. Do I need to open both of these ports on UDP as well? How about any NetBios ports? - Original Message - From: Dave Watts [EMAIL PROTECTED] I am having hard time connecting to my development SQL server through the firewall. Both the web server and the DB server are on the DMZ port of my firewall, and I am trying to connect to the SQL box via EM from the LAN side of the firewall. The firewall in questions is a SonicWall Pro. I've opened up ports 1433 and 1434 for machines from the inside the LAN to the DMZ, but I am still timing out while trying to register the SQL server. I would greatly appreciate any tips as I am tired of running between floors when I need to adjust something in the database. This might be a stupid question, but have you configured Enterprise Manager to use TCP/IP instead of the default Named Pipes? ~~ 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: form question
Sorry about that. I have a form page that lets a customer custom configure a computer system and then add it to the shopping cart. Upon the adding of the first computer to the cart the form variables pass over just fine and everything is hunky dory, and if they add another system, that is fine also. The problem comes in when the user decides to update the quantity of units purchased. When they hit the update button, which their is just one on the page 2 things can happen depending if their is hidden fields on the page or not. 1 If there is hidden fields, I can update 1 system just fine and pass all the variables to the structure. If I try 2 systems then I have a comma delimeted list of variables that passes and that wont work 2. If there is not any hidden fields, I get an error that it cannot find a variable that it is looking for. This is view cart page that posts back to itself !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN CFIF ISDEFINED(FORM.ACTION) CFIF TRIM(FORM.ACTION) EQ Add To Cart CF_EXAMPLECART SYSMODELNUM=#form.sysModelNum# PRICE=#form.show_price_top# QTY=#attributes.qty# CSE=#form.cse# CPU=#form.cpu# RAM=#form.ram# HDD=#form.hdd# SEC_HDD=#form.sec_hdd# MTR=#form.mtr# CTR=#form.ctr# VID=#form.vid# SND=#form.snd# CDR=#form.cdr# DVD=#form.dvd# CRW=#form.crw# MODEM=#form.modem# STG=#form.stg# SPK=#form.spk# NIC=#form.nic# CLNG=#form.clng# OS=#form.os# WAR=#form.war# /CFIF /CFIF CFIF isDefined(URL.UPDATE) CF_EXAMPLECART SYSMODELNUM=#form.sysModelNum# PRICE=#form.show_price_top# QTY=#form.qty# CSE=#form.cse# CPU=#form.cpu# RAM=#form.ram# HDD=#form.hdd# SEC_HDD=#form.sec_hdd# MTR=#form.mtr# CTR=#form.ctr# VID=#form.vid# SND=#form.snd# CDR=#TRIM(form.cdr)# DVD=#form.dvd# CRW=#form.crw# MODEM=#form.modem# STG=#form.stg# SPK=#form.spk# NIC=#form.nic# CLNG=#form.clng# OS=#form.os# WAR=#form.war# /CFIF CFIF isDefined(URL.DELETE) CFIF TRIM(URL.DELETE) EQ Delete CF_ACT_CART_DELETE SYSMODELNUM = #form.sysModelNum# /CFIF /CFIF HTML HEAD SCRIPT LANGUAGE=JavaScript !-- if (document.images) { !---ON IMAGES//--- image1on = new Image(); image1on.src = /_images/addtocart_on.gif; image2on = new Image(); image2on.src = /_images/customize_on.gif; image3on = new Image(); image3on.src = /_images/purple_products_on.gif; image4on = new Image(); image4on.src = /_images/purple_info_on.gif; image5on = new Image(); image5on.src = /_images/purple_support_on.gif; image6on = new Image(); image6on.src = /_images/purple_home_on.gif; image7on = new Image(); image7on.src = /_images/update_cart_on.gif; image8on = new Image(); image8on.src = /_images/del_items_on.gif; image9on = new Image(); image9on.src = /_images/show_details_on.gif; image10on = new Image(); image10on.src = /_images/hide_details_on.gif; image11on = new Image(); image11on.src = /_images/keep_shopping_on.gif; image12on = new Image(); image12on.src = /_images/checkout_on.gif; !---OFF IMAGES//--- image1off = new Image(); image1off.src = /_images/addtocart_off.gif; image2off = new Image(); image2off.src = /_images/customize_off.gif; image3off = new Image(); image3off.src = /_images/purple_products_off.gif; image4off = new Image(); image4off.src = /_images/purple_info_off.gif; image5off = new Image(); image5off.src = /_images/purple_support_off.gif; image6off = new Image(); image6off.src = /_images/purple_home_off.gif; image7off = new Image(); image7off.src = /_images/update_cart_off.gif; image8off = new Image(); image8off.src = /_images/del_items_off.gif; image9off = new Image(); image9off.src = /_images/show_details_off.gif; image10off = new Image(); image10off.src = /_images/hide_details_off.gif; image11off = new Image(); image11off.src = /_images/keep_shopping_off.gif; image12off = new Image(); image12off.src = /_images/checkout_off.gif; } function changeImages() { if (document.images) { for (var i=0; ichangeImages.arguments.length; i+=2) { document[changeImages.arguments[i]].src = eval(changeImages.arguments[i+1] + .src); } } } //-- /SCRIPT LINK REL=stylesheet HREF=/_css/cart.css TITLECarnivore Shopping Cart/TITLE SCRIPT LANGUAGE=javascript function redirectAndSubmit(theForm,theURL){ theForm.action = (theURL); theForm.submit(); return true(); } /script /HEAD BODY class=body leftmargin=5 topmargin=5 CFOUTPUT TABLE WIDTH=100% CELLSPACING=0 CELLPADDING=0 BORDER=0 TR TD BACKGROUND=/_images/dark_purple_spacer.gif COLSPAN=5A HREF=/index.cfm?fuseaction=home#client.urltoken#IMG NAME=carnivorepc SRC=/_images/carnivorepc.gif BORDER=0/A/TD /TR /TABLE TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100% TR TD WIDTH=94A HREF=/index.cfm?fuseaction=products#client.urltoken# onmouseover=changeImages('image3','image3on')
RE: MS SQL ports
Dave, I did. I can connect successfully to a box running on the LAN via TCP/IP. Do I need to open both of these ports on UDP as well? How about any NetBios ports? If you're connecting via TCP/IP directly, all you need is TCP port 1433 by default. This sounds like a firewall rule configuration issue, then. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfcontent file naming
Dead link... http://www.figleaf.com/demo/mimetest/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 3:00 PM To: CF-Talk Subject: RE: cfcontent file naming Ok gang... I'm using to use CFCONTENT to deliver files from a non-web accessible directory. It works fine. The problem is the file name is always the page name that contains the CFCONTENT code. How do I get the download to use the original file name. There has to be something I'm missing here. This might answer your question: http://www.figleaf.com/demo/mimetest/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfcontent file naming
works for me - Original Message - From: Justin Hansen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 3:40 PM Subject: RE: cfcontent file naming Dead link... http://www.figleaf.com/demo/mimetest/ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 3:00 PM To: CF-Talk Subject: RE: cfcontent file naming Ok gang... I'm using to use CFCONTENT to deliver files from a non-web accessible directory. It works fine. The problem is the file name is always the page name that contains the CFCONTENT code. How do I get the download to use the original file name. There has to be something I'm missing here. This might answer your question: http://www.figleaf.com/demo/mimetest/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MS SQL ports
Actually, I think that the port that Enterprise Manager uses for outbound connections is different. (I think you're referring to MSSQL's inbound port). To figure out the port you're using, you could try connecting to a server inside the firewall, and looking at netstat to see what ports are being used (look for connection to the microsoft-ds port on the receiving end) - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, November 02, 2001 3:13 PM Subject: RE: MS SQL ports Dave, I did. I can connect successfully to a box running on the LAN via TCP/IP. Do I need to open both of these ports on UDP as well? How about any NetBios ports? If you're connecting via TCP/IP directly, all you need is TCP port 1433 by default. This sounds like a firewall rule configuration issue, then. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Caching Queries
On 11/2/01, Fiona Barker penned: it will remain cached until the cache expires. once the cache expires, the next person to run it will cache it again. OK cool. So, if I cache the query initially for 10 hours it will expire in 10 hours even if people are clicking on it constantly. That's good to know. I thought that even if it was cached, the clock would start clicking from 0 every time someone clicked it. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: Single user CF5 license available
At 1:51 PM 11/1/1, Dave Watts wrote: There is a single-user version, but it requires a Studio license, which I believe is Tom Muck's complaint. I have to agree with him - I think the single-user Developer license for JRun would be a great idea for CF, and wouldn't cost MM any money. I may be misunderstanding the core requests here, but the following I think is what is being sought: -- update ColdFusion Express or produce something similar that is free and which can be used for testing on a developer's server -- produce a parallel ability for JRun Did I get this correct? If so, then I know Ben has already forwarded the thread, and I'll drop the above summary in my weekly report too. If you could also push the feature request in then this could help as well, thanks: http://www.macromedia.com/support/email/wishform/ Cogent reasons for the change help greatly... saying I'll switch to ASP because I can test it on my own server usually carries more persuasive power than where's CF5 Express or whatever. (I'm not sure of the background behind this set of decisions, myself... I do know that varietal versions usually are created in a second wave behind the main product, and an Express version may already be in the pipeline. Or it might be that the development costs were judged to not pay off yet in this particularly constrained time. In any case, getting the feedback to the varied decision makers makes for improved overall happiness, thanks.) Summary: I'll pass word along too... if you could drop a note to the wishlist directly then that'd be great, thanks. jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ ~~ 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: Single user CF5 license available
There is a single-user version, but it requires a Studio license, which I believe is Tom Muck's complaint. I have to agree with him - I think the single-user Developer license for JRun would be a great idea for CF, and wouldn't cost MM any money. I may be misunderstanding the core requests here, but the following I think is what is being sought: -- update ColdFusion Express or produce something similar that is free and which can be used for testing on a developer's server Not exactly. CF Express is good as a starter for people just starting out, but it's hardly what you'd want to use for development. -- produce a parallel ability for JRun I'm not sure what you mean by this exactly; I think what people are looking for is for a free, single-user developers edition of CF, as there already is for JRun. Before the release of CF 5, there was a pretty widespread expectation that MM would follow the same model for CF that they had with JRun. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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: cfcontent file naming
I had the same problem, until I added the cfheader tag with the filename attribute... cfcontent type=text/plain cfheader name=Content-Disposition value=attachment;filename=yourfilename.txt Does that help? Brook Davies logiforms.com ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Single user CF5 license available
At 3:14 PM 11/2/1, Dave Watts wrote: I think what people are looking for is for a free, single-user developers edition of CF, as there already is for JRun. Before the release of CF 5, there was a pretty widespread expectation that MM would follow the same model for CF that they had with JRun. ah, got it, thanks... will forward that along in my support report. For other folks, if this makes a difference in your daily work, then adding a vote in at the wishlist can reach the product planners directly, thanks. (If a message comes in through each of the feedback avenues it carries more weight than if it's just passed along from tech support, thanks.) http://www.macromedia.com/support/email/wishform/ jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ ~~ 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: Single user CF5 license available
Hi John: For me, the bottom line is that someone who buys UltraDev to develop CF 5 pages has no local means of testing those pages because the development license is only for CF Studio users. For my money that means that MM is not committing to UltraDev as a development environment for ColdFusion. The CF Express issue is rather besides the point, because CF Express is a limited version of CF, which would be the same regardless of version number. A CF Express version 5 is not going to have UDFs or CFGraph anyways, so I don't see why MM would need another version of this. tom John Dowdell [EMAIL PROTECTED] wrote in message news:v02140b16b808d5445877@[10.112.254.244]... I may be misunderstanding the core requests here, but the following I think is what is being sought: -- update ColdFusion Express or produce something similar that is free and which can be used for testing on a developer's server -- produce a parallel ability for JRun Did I get this correct? If so, then I know Ben has already forwarded the thread, and I'll drop the above summary in my weekly report too. If you could also push the feature request in then this could help as well, thanks: http://www.macromedia.com/support/email/wishform/ ~~ 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
FLASH - Coldfusion
Hello, I am thinking about using Flash as a front-end to Coldfusion server based applications. Does anyone know if flash handle session management for enterprise transaction based solutions over SSL? ~~ 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