Re: Query Caching..
The cached query will persist for the template it was run from, and the only way to override it (even if CF gets newer info from the database in an identical query elsewhere) is to use the cfobjectcache tag (5.0 only) like this: cfobjectcache action=clear The syntax is as follows: cfquery name=get_content datasource=#request.www_ds# maxrows=1 dbtype=ODBC cachedwithin=#CreateTimeSpan(1,0,0,0)# ... where the timespan arguments are days,hours,minutes,seconds. - Original Message - Just a quick question about query caching (using CACHEDWITHIN attrib) -- Is the cached query tied to a particular application? Sincerely, Daniel Larson [ [EMAIL PROTECTED] | www.larsoninternet.org ] ~~ 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: Query Caching..
Ahh, so basically caching a query with the same name and application within an application that uses different templates (e.g. dsp_list.cfm and dsp_list2.cfm) but the same query is pointless? Darryl -Original Message- From: Daniel Larson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 4:32 PM To: CF-Talk Subject: Re: Query Caching.. The cached query will persist for the template it was run from, and the only way to override it (even if CF gets newer info from the database in an identical query elsewhere) is to use the cfobjectcache tag (5.0 only) like this: cfobjectcache action=clear The syntax is as follows: cfquery name=get_content datasource=#request.www_ds# maxrows=1 dbtype=ODBC cachedwithin=#CreateTimeSpan(1,0,0,0)# ... where the timespan arguments are days,hours,minutes,seconds. - Original Message - Just a quick question about query caching (using CACHEDWITHIN attrib) -- Is the cached query tied to a particular application? Sincerely, Daniel Larson [ [EMAIL PROTECTED] | www.larsoninternet.org ] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT Removing some ODBC drivers
-- Date: Thu, 16 Aug 2001 10:57:43 -0400 From: Timothy Lynn [EMAIL PROTECTED] Subject: OT: Removing some ODBC drivers Message-ID: 006401c12663$ce1c3f20$[EMAIL PROTECTED] 'lo all, Strange question here. I'm not sure *how* I did, but I have quite a few redundant ODBC drivers installed on my system in different languages. For simplicity when installing Office 2k, I usually install the whole thing rather than clicking through its millions of options, and I assume this is where the drivers came from (though I've done this on other machines and have not had the same result with the ODBC drivers.. weird). Anyway, I'd like to remove the redundant drivers, and just keep what I use -- SQL, Access and Oracle, all in English. Is there a way to go about doing this? thanks, tim Tim, Try looking in the ODBC dialog under drivers, if you look under the file heading it will display the name of the dll file that you want to remove, then run regsvr32 -u dllname.dll and that will unregister the dll from windows and you can delete the file from your system folder. There is one problem with this, if you look at the file the different languages point to it, it appears to be the same for english as well as other languages for many of the entries. EX: NameVersion Company File Microsoft Access Driver (*.mdb) 4.00.4403.02M$ ODBCJT32.DLL Driver do Microsoft Access Driver (*.mdb) 4.00.4403.02M$ ODBCJT32.DLL So if it points to a different file you can probaly safely remove it, if not I would leave it alone Jim There was no such thing as the Internet five years ago. --Neil Herman, Smith Barney Is that when Al Gore invented it? --Anonymous Programmer B L A Z E i n t e r . N E T 103 Pleasant Ave #2| Jim Finucane - sandwich maker Upper Saddle River, NJ 07458| jim(at)blaze(dot)net 201-825-1313 Fax-825-4949| http://www.blaze.net ~~ 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: Screen Display specs
Does anyone have any current materials that outline any survey that has been conducted and isolates the percentage of users working at the different resolutions (ie: 640x480, 800x600, 1024x768, etc)? statmarket.com, but their *very* expensive. ~~ 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
Recall: Screen Display specs
Thomas Chiverton would like to recall the message, Screen Display specs. ~~ 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: Screen Display specs
Does anyone have any current materials that outline any survey that has been conducted and isolates the percentage of users working at the different resolutions (ie: 640x480, 800x600, 1024x768, etc)? http://www.statmarket.com/SM?c=WeekStat: Screen Resolution Global Percentage 1152 x 864 2.32 1280 X 1024 2.88 1024 X 768 32.72 800 X 600 52.47 640 X 480 5.71 ~~ 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: Flash Component Kit Issue
Does anyone know how to solve this? I am trying to use the calendar control from the flash componet kit. When the window pops up, all I get is a white square. Just an aside, but the calender still does not work in non-popup mode, afaik. A kludge and new files are in the forum on the allaire site. ~~ 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: Javascript Validation Coldfusion ?
Hi I have just tried all your suggestions shown below and it is still not working? The javascript validation kicks in for the two input fields and displays Title of the Uploaded File but the two select boxes did not activate the validation messages? Any ideas why?, I have attached the code snippet below that I am using. --- SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; if (document.form.dltitle.value == ) { missinginfo += \n - Title of the File Uploaded; } if (document.form.dlsummary.value == ) { missinginfo += \n - Descriptive Summary of Uploaded File; } if(document.form.area.value == 1){ missinginfo += \n - Please select option for Sel1; } if(document.form.dlos.value == 1){ missinginfo += \n - Please select option for Sel2; } if (missinginfo != ) { missinginfo = ~~ 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: SQL Syntax - table structure
Try sp_columns() Nick -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:46 AM To: CF-Talk Subject: OT: SQL Syntax - table structure hi, this might sound stupid but i have forgotten the command. does anyone know the command to view a table structure on a database for SQL/Sybase? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: Database query question
What do you mean by output a single row? You mean sth like FoodName MoreFoodInfo Nutrient1 Value Nutrient2 Value. - - - - Name more stuff ENERGY-SOA 191.574 PROT FAT where the number of columns is controlled by the number of rows in NIP_Nutrient for that food? If so, you can't do it in one SQL statement. Presumably you are doing this in CF though, in which case you can just join the tables: SELECT F.col1, F.col2 N.value, N.nutrient FROM NIP_FOOD F, NIP_Nutrient N WHERE F.FOOD_ID = N.FOOD_ID and then use CFML to build up the display row by looping through the 7 dataset rows returned. Nick -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:38 AM To: CF-Talk Subject: Database query question I've been given a massive (130Mb) Access database with two tables. NIP_FOOD and NIP_Nutrient. NIP_FOOD contains a unique ID field which is Alphanumeric (eg: 01A10014). NIP_Nutrient contains a field called FOOD_ID which is seven seperate rows of the same value as ID (but not linked). eg: FOOD_ID VALUE NUTRIENT 01A10014191.574 ENERGY-SOA 01A100140.4 PROT 01A100140 FAT 01A100140 TOTSATFD 01A100142.492 CHO-SOA 01A100140 TOTSUG 01A1001410 NA-SOA What would be the way to retrieve all of the fields from both tables using the value (eg: 01A10014) but have it output a single row? It will stay in Access until I can get IT to port it to SQL Server or Oracle. Thanks! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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: Query Caching..
Ahh, so basically caching a query with the same name and application within an application that uses different templates (e.g. dsp_list.cfm and dsp_list2.cfm) but the same query is pointless? NO - a Cached query persists for the same SQL and datasource, it has nothing to do with the template name So as long as you keep the SQL the same, and use the same CACHEDWITHIN it'll use the cached version The way to clear a cached query is to use a time period of 0 seconds Obviously it's only cached on the one server, so if you run a cluster, each one has it's own cache memory 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: Diary of a hack attempt
Great post Josh. Your suggestions are common sense and easy to implement. Sounds like your script kiddie had some cf knowledge though!! Cheers Will -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: 16 August 2001 20:10 To: CF-Talk Subject: Re: Diary of a hack attempt Josh, Thanks for the information. Your account, observations and suggestions are a great help. I'm thinking about co-lo'ing a server so your post came in very handy. Best, Rey Bango... - Original Message - From: Josh R [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 6:20 PM Subject: Diary of a hack attempt Wednesday morning, someone tried hacking into my website. (Not the first time, won't be the last) Didn't look like they made it. I can't be surprised. I have a controversial article about hacking plus I offer a security script. The fun part is there's nothing of value up there (my shopping site doesn't store credit card info or anything like that). But of course, they don't know that, and sometimes, they don't care. Since we just had a discussion about security, I figured I'd relate some details and observations for the sake of information. Perhaps this will help some people improve their security. (I'm assuming it's a he for ease of writing so don't get all sexist on me.) Some non-important details have been left out to protect my butt, but you'll get the full idea. (hack attempt) The first thing the guy did was try to use a well known IIS hole to look at my application.cfm. Didn't work. Then he tried the same IIS hole to look at my cart.cfm page. No luck there either. Then I received about 100 calls in about 2 minutes, each one aiming for locations of known scripts. It searched for known FrontPage extensions, locations of standard DLL files, well known CGI scripts, EXE files, standard Cold Fusion files, stock shopping cart files, the works. He even looked for scandisk logs and other known items. It tried a few locations for the same item, but not very much. Mostly it tried specific known holes. When that failed, he seemed to leave. (/hack attempt) OBSERVATIONS: This seems to have been what many people refer to as a script kiddie. Some young (in terms of computer skill) person with knowledge of a few holes and a hacking program. First, he poked around to see if he could get information on my sites layout and vital statistics. Looking at the application.cfm and cart.cfm were the best bets for finding out important info, so kudos to the hacker for having some intelligence. Once he realized he wasn't going to get anywhere that way, he launched his hack weapon of death. He has a program that runs through a list of known security holes. It systematically tries each one and alerts him to open doors. This has become a very standard way of attempting hacks. The days of some computer nerd exploiting one unknown hole is over. With so many systems and possible security holes, the usual attack is a shotgun attack, trying every known hole as quickly as possible. One thing I've noticed is that this shotgun method relies on one thing: Standard layouts. Every single hole he tried attempted to find a specific file in a specific location (or locations). These locations are known because programs install the same way every time. For example, when installing FrontPage in the default way (the way 99.9% of people install software), the same extensions are placed in the same location every time. Since the locations are known, the attack aims at those specific locations. The same is true about certain settings. Since programs install with certain settings (or default passwords) these are also scanned for. In other words these attacks aren't like a find program that looks all over your system for a particular file, they're more like a run program that expects something to be in a standard location. Since the file it wants isn't where it should be, nothing runs, and the hack is unsuccessful. However, since nothing on my system is in default locations, this attempt doesn't seem to work. A more personal touch is required to enter my site and this guy didn't want to spend the time when other sites will probably fall victim to his shotgun technique. The important thing to remember about this kind of attack is that it isn't personal. These hackers are going door-to-door knocking and checking the handle to see if it's unlocked. When they find an entrance they head on in. They don't know who you are and they don't care. This guy didn't have a personal vendetta against me or my site. If he did, he would have poked around a little closer, searched the internet for personal info about me, made phone calls, bribed employees and friends for info and found out as much as he could about me and my sites layout so he could find a way to break in. That didn't happen. He couldn't find an easy entrance so he moved on to
RE: Javascript Validation Coldfusion ?
Can you show me what your form looks like? I have a suspicion that your problem may lie there. In order for my code to work, you have to make sure that at least one of your options for your select is equal to one and that it is a value that you do not want them to be using. Also, on my demo, I went ahead and gave my form a name, such as TestForm and then called it specifically in my code such as document.TestDemo.[selectfeildname].value Hope this helps Larry Juncker Cold Fusion developer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 3:56 AM To: CF-Talk Subject: Re: Javascript Validation Coldfusion ? Hi I have just tried all your suggestions shown below and it is still not working? The javascript validation kicks in for the two input fields and displays Title of the Uploaded File but the two select boxes did not activate the validation messages? Any ideas why?, I have attached the code snippet below that I am using. --- SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; if (document.form.dltitle.value == ) { missinginfo += \n - Title of the File Uploaded; } if (document.form.dlsummary.value == ) { missinginfo += \n - Descriptive Summary of Uploaded File; } if(document.form.area.value == 1){ missinginfo += \n - Please select option for Sel1; } if(document.form.dlos.value == 1){ missinginfo += \n - Please select option for Sel2; } if (missinginfo != ) { missinginfo = ~~ 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
CF Express v. 4.5
Does anyone know where to find a feature comparison between ColdFusion Express and its big brothers? I need to know what tags I can safely use in CF Express. I seem to remember there was a matrix on Allaire's site but I can't find it now. Tristram Charnley ~~ 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
ava script
OK another Javascript teaser. I have written a function which changes the value in text box 2 when the value text box 1 changes. I call this function in the onchange event of text box 1. By definition of the onchange event this function should run if and only if the value in text box 1 is different when focus is lost to when focus was gained. When I enter the form the value in text box 1 is blank. I start to type in something and IE recognises that what I am trying to type in I've entered before (much like when you attempt to go to a URL that is in the browser history). I select the entry from the drop down list I get and hit tab to tab off the text box. When I do this the function is not called. However when I do not select it from the drop down list and type it in manually it does call the function!does anyone know why this is happening and what I can do to stop the browser trying to predict what I'm typing in ? -- 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. ~~ 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: ava script
OK I've sorted this to some extent.If I use the onblur event it solves it because it doesn't check to see if it's changed but the point is that it has changed so the onchange event should work too -- 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: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 August 2001 12:50 To: CF-Talk Subject: ava script OK another Javascript teaser. I have written a function which changes the value in text box 2 when the value text box 1 changes. I call this function in the onchange event of text box 1. By definition of the onchange event this function should run if and only if the value in text box 1 is different when focus is lost to when focus was gained. When I enter the form the value in text box 1 is blank. I start to type in something and IE recognises that what I am trying to type in I've entered before (much like when you attempt to go to a URL that is in the browser history). I select the entry from the drop down list I get and hit tab to tab off the text box. When I do this the function is not called. However when I do not select it from the drop down list and type it in manually it does call the function!does anyone know why this is happening and what I can do to stop the browser trying to predict what I'm typing in ? -- 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. ~~ 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: CF Express v. 4.5
Here you go: http://www.allaire.com/handlers/index.cfm?ID=13570Method=FullTitle=Edition %20Comparison%20MatrixCache=False I found it looking the FAQ. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq There's a lot of good information there. Daniel At 12:38 17/8/2001 +0100, you wrote: Does anyone know where to find a feature comparison between ColdFusion Express and its big brothers? I need to know what tags I can safely use in CF Express. I seem to remember there was a matrix on Allaire's site but I can't find it now. Tristram Charnley ~~ 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: ava script
In IE the form tag can have a property of autocomplete set to false and the form elements won't do that. Bryan - Original Message - From: Andy Ewings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 6:50 AM Subject: ava script | OK another Javascript teaser. | | I have written a function which changes the value in text box 2 when the | value text box 1 changes. I call this function in the onchange event of | text box 1. By definition of the onchange event this function should run if | and only if the value in text box 1 is different when focus is lost to when | focus was gained. When I enter the form the value in text box 1 is blank. | I start to type in something and IE recognises that what I am trying to type | in I've entered before (much like when you attempt to go to a URL that is in | the browser history). I select the entry from the drop down list I get and | hit tab to tab off the text box. When I do this the function is not called. | However when I do not select it from the drop down list and type it in | manually it does call the function!does anyone know why this is | happening and what I can do to stop the browser trying to predict what I'm | typing in ? | | -- | 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. | | | | ~~ 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: ava script
Hello Andy, turn off the autocomplete input autocomplete=off i believe. -- Best regards, Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOp Network=EFNet Channel=ColdFusion --- Friday, August 17, 2001, 7:50:19 AM, you wrote: AE OK another Javascript teaser. AE I have written a function which changes the value in text box 2 when the AE value text box 1 changes. I call this function in the onchange event of AE text box 1. By definition of the onchange event this function should run if AE and only if the value in text box 1 is different when focus is lost to when AE focus was gained. When I enter the form the value in text box 1 is blank. AE I start to type in something and IE recognises that what I am trying to type AE in I've entered before (much like when you attempt to go to a URL that is in AE the browser history). I select the entry from the drop down list I get and AE hit tab to tab off the text box. When I do this the function is not called. AE However when I do not select it from the drop down list and type it in AE manually it does call the function!does anyone know why this is AE happening and what I can do to stop the browser trying to predict what I'm AE typing in ? AE -- AE Andrew Ewings AE Project Manager AE Thoughtbubble Ltd AE http://www.thoughtbubble.net AE -- AE United Kingdom AE http://www.thoughtbubble.co.uk/ AE Tel: +44 (0) 20 7387 8890 AE -- AE New Zealand AE http://www.thoughtbubble.co.nz/ AE Tel: +64 (0) 9 488 9131 AE -- AE The information in this email and in any attachments is confidential and AE intended solely for the attention and use of the named addressee(s). Any AE views or opinions presented are solely those of the author and do not AE necessarily represent those of Thoughtbubble. This information may be AE subject to legal, professional or other privilege and further distribution AE of it is strictly prohibited without our authority. If you are not the AE intended recipient, you are not authorised to disclose, copy, distribute, or AE retain this message. Please notify us on +44 (0)207 387 8890. AE ~~ 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
online Oracle SQL reference
Just wondering if anyone out there knows of a good online reference page for Oracle SQL. I am thinking something like: http://www-rohan.sdsu.edu/doc/oracle/server803/A54647_01/toc.htm 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: ASP vs. Cold Fusion
Michael Dinowitz wrote: Checking that the domain exists is easy using the CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a Boolean true or false id the mail server exists or not. How does this work internally? Does it do a DNS lookup and search for a failover server if it can't contact the main server? Many mail domains I know (e.g. most academic domains in the Netherlands) have a setup where they block all incoming traffic on port 25 and provide a failover server that acts as a smarthost for mail to be delivered to the network (130.161.0.0/16 and 145.94.0.0/16 need to go through one server at my Uni). This allows them to provide central spam blocking and antivirus scanning, while the users can still connect to local servers. I would however expect that you can not verify my email server, while it is a valid and running server (try it). Also, many servers don't accept SMTP connections from computers outside a trusted domain that don't have an MX record. If your CF server does not have an MX record but your SMTP server does, you might get a false negative. 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: ASP vs. Cold Fusion
Michael, What do the * next to the version number signify? -Stephen -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:57 PM To: CF-Talk Subject: RE: ASP vs. Cold Fusion http://www.houseoffusion.com/index.cfm?body=functions It's a COMPLETE list. At 06:51 PM 8/16/01, you wrote: I guess I didn't know about that built in function :) Shawn Regan Applications Developer Pacific Technology Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 3:18 PM To: CF-Talk Subject: Re: ASP vs. Cold Fusion Checking that the domain exists is easy using the CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a Boolean true or false id the mail server exists or not. The second part of finding if the user actually exists on the mail server is harder. Many (most?) mailservers do not allow this feature as its used by spammers to gather addresses. You can use CFX_Socket to do a socket call to the mail server in the same way your doing it with Asp (basically). If I saw the Asp code you have I could show where what goes. At 06:10 PM 8/16/01, you wrote: Hi all, I am trying to write a new routine to verify email addresses. I have already written a small routine which validates the address for correct syntax. However, I want to take it a few steps further. I found a routine written for ASP (http://CoverYourASP.com/ValidateEmail.asp) which not only checks syntax but goes so far as to check that the domain exists and that the domain can also accept email. The routine also goes one step beyond this and checks the mailserver to see if the address actually belongs to any of its registered users. I am pretty sure that I can do the same thing in Cold Fusion but I am up against a wall as to how. Also, I want to try and avoid passing anything to an ASP page then back to a CF page. Any ideas out there? Any tutorials on the subject? Thanks in advance, Nelson ~~ 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
Software
I have two servers that I cluster my content. Does anyone know of any good software programs that make sure the content on both are the same. It watchs the files to see whats newer? 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: Database query question
You could try something like SELECT A.FOOD_ID, B.ENERGY-SOA, C.PROT, D.FAT, E.TOTSATFD, F.CHO-SOA, G.TOTSUG, H.NA-SOA FROM NIP_FOOD A, NIP_NUTRIENT B, NIP_NUTRIENT c, NIP_NUTRIENT D, NIP_NUTRIENT E, NIP_NUTRIENT F, NIP_NUTRIENT G, NIP_NUTRIENT H WHERE A.FOOD_ID = B.FOOD_ID AND A.FOOD_ID = C.FOOD_ID AND A.FOOD_ID = D.FOOD_ID AND A.FOOD_ID = E.FOOD_ID AND A.FOOD_ID = F.FOOD_ID AND A.FOOD_ID = G.FOOD_ID AND A.FOOD_ID = H.FOOD_ID (alter the WHERE as need to selectively get one FOOD_ID or several, or whatever other criteria you need to put in) which will flatten the rows for you. Not quite that elegant but it will get the job done... Regards, Joel Parramore -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 8:38 PM To: CF-Talk Subject: Database query question I've been given a massive (130Mb) Access database with two tables. NIP_FOOD and NIP_Nutrient. NIP_FOOD contains a unique ID field which is Alphanumeric (eg: 01A10014). NIP_Nutrient contains a field called FOOD_ID which is seven seperate rows of the same value as ID (but not linked). eg: FOOD_ID VALUE NUTRIENT 01A10014 191.574 ENERGY-SOA 01A10014 0.4 PROT 01A10014 0 FAT 01A10014 0 TOTSATFD 01A10014 2.492 CHO-SOA 01A10014 0 TOTSUG 01A10014 10 NA-SOA What would be the way to retrieve all of the fields from both tables using the value (eg: 01A10014) but have it output a single row? It will stay in Access until I can get IT to port it to SQL Server or Oracle. Thanks! Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271 2256 Fax: +61-2-6271 2278 http://www.anzfa.gov.au ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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: Removing some ODBC drivers
If you just want to not see the drivers listed on the ODBC Data Source Administrator ... Drivers tab ... you can edit odbc.ini and/or odbsinst.ini and HKEY_CURRENT_USER\Software\ODBC and HKEY_LOCAL_MACHINE\SOFTWARE\ODBC registry keys. Don't delete any files from the hard drive and make backups of the reg keys as well as the 2 ini files. Joe Hoffman mailto:[EMAIL PROTECTED] National Institutes of Health Center for Information Technology Division of Computer System Services -Original Message- From: Timothy Lynn [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 10:58 AM To: CF-Talk Subject: OT: Removing some ODBC drivers 'lo all, Strange question here. I'm not sure *how* I did, but I have quite a few redundant ODBC drivers installed on my system in different languages. For simplicity when installing Office 2k, I usually install the whole thing rather than clicking through its millions of options, and I assume this is where the drivers came from (though I've done this on other machines and have not had the same result with the ODBC drivers.. weird). Anyway, I'd like to remove the redundant drivers, and just keep what I use -- SQL, Access and Oracle, all in English. Is there a way to go about doing this? thanks, tim ~~ 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
Grouping DB Data with Coldfusion ?
Hi With Coldfusion how do you group field data together, for example. I have a database table with id, date, summary and AREA. The area field contains values such as 'software', 'presentations' etc in each record. How do you then in coldfusion pass a paramenter from a hyperlink to a coldfusion page that would only display all the records that area. I.E. If I clicked on a link called 'Software' it passes the parameter in the url ie ?area=software and it takes you to a page with only the records with software in the area field. Any ideas on how to accomplish this, and is the above method the best and most efficient approach of achieving this? ~~ 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: Grouping DB Data with Coldfusion ?
This is how I do it if this is the only area you want them to access. If I allow a user to select the area, then we pass it in a form from a dropdown, but the idea is the same. JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 10:23 AM To: CF-Talk Subject: Grouping DB Data with Coldfusion ? Hi With Coldfusion how do you group field data together, for example. I have a database table with id, date, summary and AREA. The area field contains values such as 'software', 'presentations' etc in each record. How do you then in coldfusion pass a paramenter from a hyperlink to a coldfusion page that would only display all the records that area. I.E. If I clicked on a link called 'Software' it passes the parameter in the url ie ?area=software and it takes you to a page with only the records with software in the area field. Any ideas on how to accomplish this, and is the above method the best and most efficient approach of achieving this? ~~ 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
hyperlinks in IE5 for Mac
Anyone have or had any problems with IE5 for the Macintosh? I have the link below which works in IE/NN on the PC and NN on the mac but not IE!? a href=index.mcb?threedot=work title= work onMouseOver=thisLinkStatus('who we work with, and what we have done; a visual feast.');return document.returnValue onMouseOut=thisLinkStatus('navigate with the quick links - its easy!');return document.returnValueimg src=images/work.gif width=75 height=10 border=0/a Anyone? Neil ~~ 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
Creating Stored Procedures (DB2/NT)
Question, Is it possible to create stored procedures with DB2 running on NT? James ~~ 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: Database query question
Try this. In ACCESS create a Crosstab Query for the NIP_NUTRIENT table, with FOOD_ID as the row value, NUTRIENT as the column value, and VALUE as the intersection. Then in your CFQUERY do a JOIN of the NIP_FOOD table and the query over the FOOD_ID value. Caveat, I've never tried doing a join to a crosstab-ed query, but it seems like it should work. -reed -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:38 AM To: CF-Talk Subject: Database query question I've been given a massive (130Mb) Access database with two tables. NIP_FOOD and NIP_Nutrient. NIP_FOOD contains a unique ID field which is Alphanumeric (eg: 01A10014). NIP_Nutrient contains a field called FOOD_ID which is seven seperate rows of the same value as ID (but not linked). eg: FOOD_ID VALUE NUTRIENT 01A10014191.574 ENERGY-SOA 01A100140.4 PROT 01A100140 FAT 01A100140 TOTSATFD 01A100142.492 CHO-SOA 01A100140 TOTSUG 01A1001410 NA-SOA What would be the way to retrieve all of the fields from both tables using the value (eg: 01A10014) but have it output a single row? It will stay in Access until I can get IT to port it to SQL Server or Oracle. Thanks! 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
FTP Replication
Hey, Anyone know of a application that watches the contents of a folder and subfolders and upon change ftps them somewhere? Kinda tired of making and support web applications where a web app is not always the best solution... ~~ 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: ASP vs. Cold Fusion
In the version column it means that it was a hidden function in that version. In the datatype column it means that something special is coming back from the function call. This could be multiple types of datatypes based on an attribute (like REFind returning a numeric or a structure), datatypes that are dependant on other things (like LSDateFormat returning a dateformat that's legal based on some other location), or even some strange stuff like Javacast. The notes that go to each function was supposed to be in the functions book I have shelved at the moment. I was talking to MM and others about backing so I could just write stuff for CF and the community but it all fell apart. My need to support my family stops me from writing a book for myself (though I am writing a few chapters in other books but for pay). We'll see what the future holds on all this but for now you've got the functions list. At 09:02 AM 8/17/01, you wrote: Michael, What do the * next to the version number signify? -Stephen -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:57 PM To: CF-Talk Subject: RE: ASP vs. Cold Fusion http://www.houseoffusion.com/index.cfm?body=functions It's a COMPLETE list. At 06:51 PM 8/16/01, you wrote: I guess I didn't know about that built in function :) Shawn Regan Applications Developer Pacific Technology Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 3:18 PM To: CF-Talk Subject: Re: ASP vs. Cold Fusion Checking that the domain exists is easy using the CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a Boolean true or false id the mail server exists or not. The second part of finding if the user actually exists on the mail server is harder. Many (most?) mailservers do not allow this feature as its used by spammers to gather addresses. You can use CFX_Socket to do a socket call to the mail server in the same way your doing it with Asp (basically). If I saw the Asp code you have I could show where what goes. At 06:10 PM 8/16/01, you wrote: Hi all, I am trying to write a new routine to verify email addresses. I have already written a small routine which validates the address for correct syntax. However, I want to take it a few steps further. I found a routine written for ASP (http://CoverYourASP.com/ValidateEmail.asp) which not only checks syntax but goes so far as to check that the domain exists and that the domain can also accept email. The routine also goes one step beyond this and checks the mailserver to see if the address actually belongs to any of its registered users. I am pretty sure that I can do the same thing in Cold Fusion but I am up against a wall as to how. Also, I want to try and avoid passing anything to an ASP page then back to a CF page. Any ideas out there? Any tutorials on the subject? Thanks in advance, Nelson ~~ 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: ASP vs. Cold Fusion
I really have no clue as to how this works internally. The test is if your mail server shows up in the administrator then the function will work for it. Basically, this is the function used in the admin to do that check. My thought is that it does a tcp/ip request to the port specified. If so, then maybe it can also be used to specify if a server or service is running or not. Use it to check if an FTP server is running on a machine. At 08:26 AM 8/17/01, you wrote: Michael Dinowitz wrote: Checking that the domain exists is easy using the CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a Boolean true or false id the mail server exists or not. How does this work internally? Does it do a DNS lookup and search for a failover server if it can't contact the main server? Many mail domains I know (e.g. most academic domains in the Netherlands) have a setup where they block all incoming traffic on port 25 and provide a failover server that acts as a smarthost for mail to be delivered to the network (130.161.0.0/16 and 145.94.0.0/16 need to go through one server at my Uni). This allows them to provide central spam blocking and antivirus scanning, while the users can still connect to local servers. I would however expect that you can not verify my email server, while it is a valid and running server (try it). Also, many servers don't accept SMTP connections from computers outside a trusted domain that don't have an MX record. If your CF server does not have an MX record but your SMTP server does, you might get a false negative. 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: FTP Replication
Your could use a scheduled page to do that... run it every 5-10 minutes, store the cfdirectory results in a server.var and compare it to the current results Justin Hansen - [EMAIL PROTECTED] Project Leader / Web Application Developer Interactive Business Solutions, Inc 816-221-5200 ext. 1305 -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 9:49 AM To: CF-Talk Subject: FTP Replication Hey, Anyone know of a application that watches the contents of a folder and subfolders and upon change ftps them somewhere? Kinda tired of making and support web applications where a web app is not always the best solution... ~~ 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: Database query question
I just realized that I totally misread that question --- never mind that previous reply. Grrr... it's morning... -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:38 AM To: CF-Talk Subject: Database query question I've been given a massive (130Mb) Access database with two tables. NIP_FOOD and NIP_Nutrient. NIP_FOOD contains a unique ID field which is Alphanumeric (eg: 01A10014). NIP_Nutrient contains a field called FOOD_ID which is seven seperate rows of the same value as ID (but not linked). eg: FOOD_ID VALUE NUTRIENT 01A10014 191.574 ENERGY-SOA 01A10014 0.4 PROT 01A10014 0 FAT 01A10014 0 TOTSATFD 01A10014 2.492 CHO-SOA 01A10014 0 TOTSUG 01A10014 10 NA-SOA What would be the way to retrieve all of the fields from both tables using the value (eg: 01A10014) but have it output a single row? It will stay in Access until I can get IT to port it to SQL Server or Oracle. Thanks! 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 ~~ 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: ASP vs. Cold Fusion
And the answer is no. It looks like the function calls the mail server on X port and waits for a HELO or the equivalent. At 11:00 AM 8/17/01, you wrote: I really have no clue as to how this works internally. The test is if your mail server shows up in the administrator then the function will work for it. Basically, this is the function used in the admin to do that check. My thought is that it does a tcp/ip request to the port specified. If so, then maybe it can also be used to specify if a server or service is running or not. Use it to check if an FTP server is running on a machine. At 08:26 AM 8/17/01, you wrote: Michael Dinowitz wrote: Checking that the domain exists is easy using the CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a Boolean true or false id the mail server exists or not. How does this work internally? Does it do a DNS lookup and search for a failover server if it can't contact the main server? Many mail domains I know (e.g. most academic domains in the Netherlands) have a setup where they block all incoming traffic on port 25 and provide a failover server that acts as a smarthost for mail to be delivered to the network (130.161.0.0/16 and 145.94.0.0/16 need to go through one server at my Uni). This allows them to provide central spam blocking and antivirus scanning, while the users can still connect to local servers. I would however expect that you can not verify my email server, while it is a valid and running server (try it). Also, many servers don't accept SMTP connections from computers outside a trusted domain that don't have an MX record. If your CF server does not have an MX record but your SMTP server does, you might get a false negative. 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: FTP Replication
If you don't find one, let me know, sounds cool. I could use it. let me know the features you want in it and I will talk to my team about making such a tool. Gary Kraeger Cfdev.com - Original Message - From: BT [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 10:48 AM Subject: FTP Replication Hey, Anyone know of a application that watches the contents of a folder and subfolders and upon change ftps them somewhere? Kinda tired of making and support web applications where a web app is not always the best solution... ~~ 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: Screen Display specs
If you're interested in tracking your visitor's resolutions (as well as other data, like color depth, etc), TheCounter.com does this for you. Of course, it'd be easy to implement the way they do it on your own. --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 2:54 PM To: CF-Talk Subject: Screen Display specs Working on some research right now about the changing face of the browser market, with an emphasis on the viewers screen resolution... Does anyone have any current materials that outline any survey that has been conducted and isolates the percentage of users working at the different resolutions (ie: 640x480, 800x600, 1024x768, etc)? -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] ~~ 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: Multilpe Domains on a single IP IIS with no virtual directory access
That assumes control of IIS, which you usually won't find in a shared host environment (which I'd assume is the case if you can't set up virtual directories) --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:58 PM To: CF-Talk Subject: RE: Multilpe Domains on a single IP IIS with no virtual directory access Can't you use host headers? -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Friday, 17 August 2001 3:19 To: CF-Talk Subject: Multilpe Domains on a single IP IIS with no virtual directory access We have to set up a web site portfolio of 11 sites on a single IP with no access to IIS 5.0 to create virtual directories/folders. We need to use normal fully qualified domain names that will be set up in DNS to point to the one IP Address. We are able to get mappings set up in CF Admin and are able to create sub directories under our server root (this is a hosting situation). Any ideas on the best way to go about this? Kind Regards - Mike Brunt Tel: 562.790.8631 Instant Messaging Handles: - AIM (AOL): MediaEmbee MSN: [EMAIL PROTECTED] Yahoo: MediaEmbeeYH ~~ 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: disappearing queries
I believe that CFQuery will not handle SQL that returns/processes more than one recordset. So if you do an INSERT then a SELECT in a proc/query, you won't get any results back. For stored procedures, you should be using CFSTOREDPROC/CFPROCPARAM/CFPROCRESULT instead. --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Darryl Lyons [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 7:33 PM To: CF-Talk Subject: disappearing queries Has anyone ever had any problems displaying result sets from a stored procedure using temporary tables? The query works fine in SQL Query Analyser, but CF just won't bring back results. Even stranger is that as soon as the query is run, the debug info comes up with 0 results, and then CF says the query doesn't exist.. Error below. (Note that the asdasdsadsd is referenced properly in the cfoutput tag) asdasdsadsd (Records=0, Time=15ms) Bottom of Form 0 Error Occurred While Processing Request SQL = { CALL cm_qry_listing_obj('1','47','1','1') } Error Diagnostic Information QUERY The QUERY attribute of the tag does not specify the name of an available query The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (5:1) to (5:30). Date/Time: 08/17/01 10:31:58 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address: 210.11.100.2 --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : (07) 3230 8811 'merging business + technology' ~~ 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
What is a Query Result Set look like? (tds)
What does a ColdFusion Query Result Set look like? Is it an array, a structure, or something else? I have a collection of information that I would like to put into a Query Result Set and use the CFOUTPUT tag to spit out the results. Any Idea would be greatly appreciated. Thanks for the help. Sincerely, Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 Some people change when they see the light. Others, when they feel the heat. -- corvis advertisement ~~ 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: ASP vs. Cold Fusion
You can also telnet into the machine and see if the mailserver is running. Often times you get something like this: +OK POP3 dssf.tudelft.nl v2000.70 server ready I tried using cfexecute, but it wouldn't actually 'return' anything that could be displayed. Maybe someone else could figure out a way to do this. Todd | I really have no clue as to how this works internally. The test is if your | mail server shows up in the administrator then the function will work for | it. Basically, this is the function used in the admin to do that check. | My thought is that it does a tcp/ip request to the port specified. If so, | then maybe it can also be used to specify if a server or service is running | or not. Use it to check if an FTP server is running on a machine. | | At 08:26 AM 8/17/01, you wrote: | Michael Dinowitz wrote: | Checking that the domain exists is easy using the | CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a | Boolean true or false id the mail server exists or not. | | How does this work internally? Does it do a DNS lookup and search for a | failover server if it can't contact the main server? Many mail domains I | know (e.g. most academic domains in the Netherlands) have a setup where | they block all incoming traffic on port 25 and provide a failover server | that acts as a smarthost for mail to be delivered to the network | (130.161.0.0/16 and 145.94.0.0/16 need to go through one server at my | Uni). This allows them to provide central spam blocking and antivirus | scanning, while the users can still connect to local servers. I would | however expect that you can not verify my email server, while it is a | valid and running server (try it). | Also, many servers don't accept SMTP connections from computers outside | a trusted domain that don't have an MX record. If your CF server does | not have an MX record but your SMTP server does, you might get a false | negative. | | 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: CFFTP
CFFTP is actually a COM object. Perhaps re-registering it would fix your problem. Regsvr32 c:\winnt\system32\cfftp.dll --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: McCabe, Kevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 11:24 AM To: CF-Talk Subject: CFFTP Currently Getting this using FTP. A stop and start of services fixes it for a bit. We haven't touched the code base for at least 6 months and not used the application for around 2 months Then this has just started to happen. The machine has been rebooted and the Code Red Path applied. Now code it be that? Error Occurred While Processing Request Error Diagnostic Information Error trying to create object specified in the tag. COM error 0x80040154. Class not registered Date/Time: 08/15/01 14:52:04 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) Remote Address: XXX.XXX.XXX.XXX HTTP Referrer: http://awebserver/acfmpage.cfm http://awebserver/acfmpage.cfm Template: e:\directory\ftp.cfm Cheers Kev McCabe Senior ETV Developer _/_/_/_/ _/ _/ _/_/ Digital Development _/ _/ _/_/ _/British Sky Broadcasting _/_/_/_/ _/_/ _/ Tel: +44 (0)20 7941 5329 _/ _/ _/ _/ Mob: +44 (0)77 1117 2730 _/_/_/_/ _/_/ _/Mobex: 123 5502 Web: http://www.sky.com http://www.sky.com Wap: http://mobile.sky.com http://mobile.sky.com ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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: What is a Query Result Set look like? (tds)
Internally to CF it is a Query datatype. It actually looks like a structure of equal length arrays. For example, a query with the columns name, age that has 5 rows will look like a structure with the key name and the key age and each key will have an array in it of length 5. This is why using the targeted method of getting a query item (queryname.name[3]) looks exactly like getting an array item that's contained in a structure. queryname (structure) name (structure key) row1 (array item) row2 (array item) row3 (array item) row4 (array item) row5 (array item) Age (structure key) row1 (array item) row2 (array item) row3 (array item) row4 (array item) row5 (array item) At 11:19 AM 8/17/01, you wrote: What does a ColdFusion Query Result Set look like? Is it an array, a structure, or something else? I have a collection of information that I would like to put into a Query Result Set and use the CFOUTPUT tag to spit out the results. Any Idea would be greatly appreciated. Thanks for the help. Sincerely, Troy -- Troy Simpson | North Carolina State University NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 Some people change when they see the light. Others, when they feel the heat. -- corvis advertisement ~~ 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: Apache and cflocation......
CFLocation simply returns an HTTP status code - not all browsers process it the same (in other words, the redirection isn't automatic - it's actually a status code returned to the browser, and the browser then handles redirection). To get around this, use a META refresh tag instead. --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Richard Kuryk [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 12:56 PM To: CF-Talk Subject: Apache and cflocation.. I am having a problem on my server where when I do a cflocation apache stops it from relocating and displays a 302 found error and comes up with the msg the document has moved here with a link. I can't seem to find any settings in my httpd.conf that would seem to fix this problem. Has anyone else seen this or know what I need to add to my configuration files. Thanks Rich ~~ 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: cfschedule question
A number of potential issues. Does the script rely on user agent? Permissions perhaps? How about firewall issues? (I ran into this one not too long ago - seems that localhost wasn't on the list of acceptable IP addresses) --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 7:44 PM To: CF-Talk Subject: Re: cfschedule question i use cfschedule to make http call on other pages that run some perl script the problem is that the perl script has not been run at all, but if i run those pages direct from the browser then the perl script is execute, why is that? - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 8:37 PM Subject: Re: cfschedule question CFSchedule calls pages via http so it should be able to do what you're looking for. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Mak Wing Lok [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 4:05 AM Subject: cfschedule question hi, just curious, is cfschedule able to schdule-call pages from .asp, .php or any other valid http pages? ~~ 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: Multilpe Domains on a single IP IIS with no virtual directory access
Yes, you are correct and thanks to all for your suggestions and advice. Our eventual aim is to move all the websites to full stand-alone status but in the short term they will form our design portfolio. Kind Regards - Mike Brunt Tel: 562.790.8631 Instant Messaging Handles: - AIM (AOL): MediaEmbee MSN: [EMAIL PROTECTED] Yahoo: MediaEmbeeYH -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 8:05 AM To: CF-Talk Subject: RE: Multilpe Domains on a single IP IIS with no virtual directory access That assumes control of IIS, which you usually won't find in a shared host environment (which I'd assume is the case if you can't set up virtual directories) --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:58 PM To: CF-Talk Subject: RE: Multilpe Domains on a single IP IIS with no virtual directory access Can't you use host headers? -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Friday, 17 August 2001 3:19 To: CF-Talk Subject: Multilpe Domains on a single IP IIS with no virtual directory access We have to set up a web site portfolio of 11 sites on a single IP with no access to IIS 5.0 to create virtual directories/folders. We need to use normal fully qualified domain names that will be set up in DNS to point to the one IP Address. We are able to get mappings set up in CF Admin and are able to create sub directories under our server root (this is a hosting situation). Any ideas on the best way to go about this? Kind Regards - Mike Brunt Tel: 562.790.8631 Instant Messaging Handles: - AIM (AOL): MediaEmbee MSN: [EMAIL PROTECTED] Yahoo: MediaEmbeeYH ~~ 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: Any horror stories from not locking session vars?
Just use client vars...with the datasource and you have no need for shared memory vars in a load balanced environment. - Original Message - From: Billy Cravens [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 10:20 AM Subject: RE: Any horror stories from not locking session vars? I don't know that this is necessary. Configure client storage to use ODBC; that way all of your servers can point to that datasource and retain the same sessions. --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: JB Mentzer [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 9:25 PM To: CF-Talk Subject: Re: Any horror stories from not locking session vars? Hi all [EMAIL PROTECTED] wrote: A further suggestion is to avoid SESSION, APPLICATION and SERVER variables completely. Build a site that will be ready for loadbalancing WITHOUT sticky sessions now and don't even fool with server specific shared memory scopes. So what variables am I to use? Aren't URL variables a security breach? Thanks! * john * 2c ~.net3 - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 06, 2001 10:10 Subject: Any horror stories from not locking session vars? I have been asked to do a code review of a site and I have found that the developers don't bother to lock session variables when then read or write them. Does anybody have an good horror stories about the dangers of doing this so I legitimately show the customer why this is a problem. He is a nontechnical person so any talk of needing to single-thread processes when using shared variables won't mean a thing to him. Since I always lock around the variables I can't give him any personal horror stories. Perhaps some of you have heard of some (I KNOW they won't come from YOUR sites because you always follow best practices ;-) but maybe you inherited some.) TIA Don ~~ 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: ASP vs. Cold Fusion
If memory serves me, an undocumented function. Notice it only shows up next to the 'cf' or cfusion functions? At 09:02 AM 08/17/2001 -0400, you wrote: Michael, What do the * next to the version number signify? -Stephen -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 6:57 PM To: CF-Talk Subject: RE: ASP vs. Cold Fusion http://www.houseoffusion.com/index.cfm?body=functions It's a COMPLETE list. At 06:51 PM 8/16/01, you wrote: I guess I didn't know about that built in function :) Shawn Regan Applications Developer Pacific Technology Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 3:18 PM To: CF-Talk Subject: Re: ASP vs. Cold Fusion Checking that the domain exists is easy using the CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a Boolean true or false id the mail server exists or not. The second part of finding if the user actually exists on the mail server is harder. Many (most?) mailservers do not allow this feature as its used by spammers to gather addresses. You can use CFX_Socket to do a socket call to the mail server in the same way your doing it with Asp (basically). If I saw the Asp code you have I could show where what goes. At 06:10 PM 8/16/01, you wrote: Hi all, I am trying to write a new routine to verify email addresses. I have already written a small routine which validates the address for correct syntax. However, I want to take it a few steps further. I found a routine written for ASP (http://CoverYourASP.com/ValidateEmail.asp) which not only checks syntax but goes so far as to check that the domain exists and that the domain can also accept email. The routine also goes one step beyond this and checks the mailserver to see if the address actually belongs to any of its registered users. I am pretty sure that I can do the same thing in Cold Fusion but I am up against a wall as to how. Also, I want to try and avoid passing anything to an ASP page then back to a CF page. Any ideas out there? Any tutorials on the subject? Thanks in advance, Nelson ~~ 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: FTP Replication
How about Rsync? Here's a cygnus nt port... http://members.ozemail.com.au/~msteveb/rsync/index.html -Rich - Original Message - From: BT [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 10:48 AM Subject: FTP Replication Hey, Anyone know of a application that watches the contents of a folder and subfolders and upon change ftps them somewhere? Kinda tired of making and support web applications where a web app is not always the best solution... ~~ 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
CFX_Socket was ASP vs. Cold Fusion
Um I did some research all over and couldn't find CFX_Socket... Devex doesn't have it, Google is a no go, and in a last attempt CFXSocket.com is not taken All I could turn up was cfsocket for Mac OS X for Core Foundation... What in the Hello.. -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 11:46 AM To: CF-Talk Subject: Re: ASP vs. Cold Fusion You can also telnet into the machine and see if the mailserver is running. Often times you get something like this: +OK POP3 dssf.tudelft.nl v2000.70 server ready I tried using cfexecute, but it wouldn't actually 'return' anything that could be displayed. Maybe someone else could figure out a way to do this. Todd | I really have no clue as to how this works internally. The test is if your | mail server shows up in the administrator then the function will work for | it. Basically, this is the function used in the admin to do that check. | My thought is that it does a tcp/ip request to the port specified. If so, | then maybe it can also be used to specify if a server or service is running | or not. Use it to check if an FTP server is running on a machine. | | At 08:26 AM 8/17/01, you wrote: | Michael Dinowitz wrote: | Checking that the domain exists is easy using the | CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a | Boolean true or false id the mail server exists or not. | | How does this work internally? Does it do a DNS lookup and search for a | failover server if it can't contact the main server? Many mail domains I | know (e.g. most academic domains in the Netherlands) have a setup where | they block all incoming traffic on port 25 and provide a failover server | that acts as a smarthost for mail to be delivered to the network | (130.161.0.0/16 and 145.94.0.0/16 need to go through one server at my | Uni). This allows them to provide central spam blocking and antivirus | scanning, while the users can still connect to local servers. I would | however expect that you can not verify my email server, while it is a | valid and running server (try it). | Also, many servers don't accept SMTP connections from computers outside | a trusted domain that don't have an MX record. If your CF server does | not have an MX record but your SMTP server does, you might get a false | negative. | | 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: Software
we use repliweb - it is great - has tons of functionality and controls microsoft also has a free one on the win2k web server resource kit - but it is not as functional. kirk - Original Message - From: Michael Ross [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 6:21 AM Subject: Software I have two servers that I cluster my content. Does anyone know of any good software programs that make sure the content on both are the same. It watchs the files to see whats newer? 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: FTP Replication
http://www.repliweb.com/ - Original Message - From: BT [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 7:48 AM Subject: FTP Replication Hey, Anyone know of a application that watches the contents of a folder and subfolders and upon change ftps them somewhere? Kinda tired of making and support web applications where a web app is not always the best solution... ~~ 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: CFX_Socket was ASP vs. Cold Fusion
CFX_Socket was a custom tag to allow direct socket calls. If its not in the tag gallery then I'll send you a copy when I get home. I have the entire gallery local including old stuff. :) Eventually I'm going to put out that organized CD of tags. Time, money and a backer. At 11:49 AM 8/17/01, you wrote: Um I did some research all over and couldn't find CFX_Socket... Devex doesn't have it, Google is a no go, and in a last attempt CFXSocket.com is not taken All I could turn up was cfsocket for Mac OS X for Core Foundation... What in the Hello.. -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 11:46 AM To: CF-Talk Subject: Re: ASP vs. Cold Fusion You can also telnet into the machine and see if the mailserver is running. Often times you get something like this: +OK POP3 dssf.tudelft.nl v2000.70 server ready I tried using cfexecute, but it wouldn't actually 'return' anything that could be displayed. Maybe someone else could figure out a way to do this. Todd | I really have no clue as to how this works internally. The test is if your | mail server shows up in the administrator then the function will work for | it. Basically, this is the function used in the admin to do that check. | My thought is that it does a tcp/ip request to the port specified. If so, | then maybe it can also be used to specify if a server or service is running | or not. Use it to check if an FTP server is running on a machine. | | At 08:26 AM 8/17/01, you wrote: | Michael Dinowitz wrote: | Checking that the domain exists is easy using the | CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a | Boolean true or false id the mail server exists or not. | | How does this work internally? Does it do a DNS lookup and search for a | failover server if it can't contact the main server? Many mail domains I | know (e.g. most academic domains in the Netherlands) have a setup where | they block all incoming traffic on port 25 and provide a failover server | that acts as a smarthost for mail to be delivered to the network | (130.161.0.0/16 and 145.94.0.0/16 need to go through one server at my | Uni). This allows them to provide central spam blocking and antivirus | scanning, while the users can still connect to local servers. I would | however expect that you can not verify my email server, while it is a | valid and running server (try it). | Also, many servers don't accept SMTP connections from computers outside | a trusted domain that don't have an MX record. If your CF server does | not have an MX record but your SMTP server does, you might get a false | negative. | | 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: Anyone else having problems with Hostcentric?
Hey John, We too were with Virtualscape before they were gobbled up. It seems like a lot of the problems I've encountered didn't start until after this past New Year. Since then, there have been a lot of run-ins with technical support that take much too long to resolve. You may have missed my latest problem with them posted yesterday. They advertise that they're hosting CF 4.51. However output from #server.ColdFusion.ProductVersion# shows v4.01. This has caused an app I was launching this week to not work and be delayed. (FYI, this is on virtualscape34, I don't know how your server is working). So, we're packing our bags and looking for a good home. I'm awaiting a proposal to move over to CF_Hosting and make use of their new ASP offerings which provide PaperThin's CommonSpot. Hopefully the future's looking better. -Tim - Original Message - From: JB Mentzer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 11:42 AM Subject: Anyone else having problems with Hostcentric? Hi all If you were paying $54.99 a month, would you put up with with this? At what point would you change hosts? Thanks! * John * ~~ 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: CFX_Socket was ASP vs. Cold Fusion
Um I did some research all over and couldn't find CFX_Socket... Devex doesn't have it, Google is a no go, and in a last attempt CFXSocket.com is not taken It's here: http://www.intrafoundation.com/ It's called TCPSocket, I think. Enjoy! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFX_Socket was ASP vs. Cold Fusion
please send me the CFX_Socket tag... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: [EMAIL PROTECTED] (Michael Dinowitz) Date: Fri, 17 Aug 2001 12:04:38 -0400 Subject: Re: CFX_Socket was ASP vs. Cold Fusion CFX_Socket was a custom tag to allow direct socket calls. If its not in the tag gallery then I'll send you a copy when I get home. I have the entire gallery local including old stuff. :) Eventually I'm going to put out that organized CD of tags. Time, money and a backer. At 11:49 AM 8/17/01, you wrote: Um I did some research all over and couldn't find CFX_Socket... Devex doesn't have it, Google is a no go, and in a last attempt CFXSocket.com is not taken All I could turn up was cfsocket for Mac OS X for Core Foundation... What in the Hello.. -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 11:46 AM To: CF-Talk Subject: Re: ASP vs. Cold Fusion You can also telnet into the machine and see if the mailserver is running. Often times you get something like this: +OK POP3 dssf.tudelft.nl v2000.70 server ready I tried using cfexecute, but it wouldn't actually 'return' anything that could be displayed. Maybe someone else could figure out a way to do this. Todd | I really have no clue as to how this works internally. The test is if your | mail server shows up in the administrator then the function will work for | it. Basically, this is the function used in the admin to do that check. | My thought is that it does a tcp/ip request to the port specified. If so, | then maybe it can also be used to specify if a server or service is running | or not. Use it to check if an FTP server is running on a machine. | | At 08:26 AM 8/17/01, you wrote: | Michael Dinowitz wrote: | Checking that the domain exists is easy using the | CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll return a | Boolean true or false id the mail server exists or not. | | How does this work internally? Does it do a DNS lookup and search for a | failover server if it can't contact the main server? Many mail domains I | know (e.g. most academic domains in the Netherlands) have a setup where | they block all incoming traffic on port 25 and provide a failover server | that acts as a smarthost for mail to be delivered to the network | (130.161.0.0/16 and 145.94.0.0/16 need to go through one server at my | Uni). This allows them to provide central spam blocking and antivirus | scanning, while the users can still connect to local servers. I would | however expect that you can not verify my email server, while it is a | valid and running server (try it). | Also, many servers don't accept SMTP connections from computers outside | a trusted domain that don't have an MX record. If your CF server does | not have an MX record but your SMTP server does, you might get a false | negative. | | 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: FTP Replication
Kirk: Repliweb looks great does it cost a lot. Gary Cfdev.com http://www.cfdev.com - Original Message - From: Kirk Boecker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 11:51 AM Subject: Re: FTP Replication http://www.repliweb.com/ - Original Message - From: BT [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 7:48 AM Subject: FTP Replication Hey, Anyone know of a application that watches the contents of a folder and subfolders and upon change ftps them somewhere? Kinda tired of making and support web applications where a web app is not always the best solution... ~~ 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
file upload, large files, HTTP/FTP, CF/IIS, CFFILE - magic formula?
need the ability to upload 5mb-10mb CSV/XML file to a CF template that will process it. i'm attempting to use a multi-part form post, but here's the problems i've experienced: 1. once the web server receives the form post, it has to then transfer it to CF. when the file is large, this process can take over 5-10 minutes. this problem is documented all over the web (just do a search). unfortunately, in my case, it can't take longer than a minute or so. 2. if form post via HTTP to IIS doesn't work, is there any way to upload a file through the web via FTP? i know you can ftp into a ftp server via Javascript, but i don't know if you can upload files via Javascript. 3. i've considered other solutions -- submitting to a servlet (elimates IIS), uploading FTP via signed applet -- but would like to find an interim solution using CF. any other ideas? -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: CFX_Socket was ASP vs. Cold Fusion
There is a socket CFX as well as a new COM object at www.intrafoundation.com (comes with complete source code as well). Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: BT [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 11:49 AM Subject: CFX_Socket was ASP vs. Cold Fusion Um I did some research all over and couldn't find CFX_Socket... Devex doesn't have it, Google is a no go, and in a last attempt CFXSocket.com is not taken All I could turn up was cfsocket for Mac OS X for Core Foundation... What in the Hello.. ~~ 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:ftp replication
Telestream has a product that does this. It's part of the functionality of their flip factory product. Flip factory actually does more than that, but you can configure an account to ftp anytime something changes in a folder. It's pricey though. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ftp replication
Would you be referring to the FF Publish, FF Pro, FF OnDemand? -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:44 PM To: CF-Talk Subject: re:ftp replication Telestream has a product that does this. It's part of the functionality of their flip factory product. Flip factory actually does more than that, but you can configure an account to ftp anytime something changes in a folder. It's pricey though. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ftp replication
Well, that's a good question. I think we have FF Pro, but I'm honestly not sure. It's not a feature we're using, but we've been through the feature chat about a million times, and I know it was discussed. -d Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: file upload, large files, HTTP/FTP, CF/IIS, CFFILE - magic formula?
If you're wanting to use the browser upload, you're quite limited, no matter what language you use. You could split up the process - when they upload, just save the file. Have a separate process (perhaps a scheduled task) that parses the file. As far as your time limit is concerned, you have very little control. It's all a matter of bandwidth. If the file is over X bytes, it will take at least Y seconds, if the user has Z bandwidth. Sounds like one of those classic situations where CF may not be the best approach. My recommendation: make an app (VB, etc) that user downloads. In your app, parse the large file into a recordset and then stream that recordset up to your site - you can have a nifty little status bar showing the progress, as opposed to a empty browser window while a large process is taking place. --- Billy Cravens HR Systems, EDS [EMAIL PROTECTED] -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 12:24 PM To: CF-Talk Subject: file upload, large files, HTTP/FTP, CF/IIS, CFFILE - magic formula? need the ability to upload 5mb-10mb CSV/XML file to a CF template that will process it. i'm attempting to use a multi-part form post, but here's the problems i've experienced: 1. once the web server receives the form post, it has to then transfer it to CF. when the file is large, this process can take over 5-10 minutes. this problem is documented all over the web (just do a search). unfortunately, in my case, it can't take longer than a minute or so. 2. if form post via HTTP to IIS doesn't work, is there any way to upload a file through the web via FTP? i know you can ftp into a ftp server via Javascript, but i don't know if you can upload files via Javascript. 3. i've considered other solutions -- submitting to a servlet (elimates IIS), uploading FTP via signed applet -- but would like to find an interim solution using CF. any other ideas? -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
Frameset problem using cgi.http_referrer
Hello, I am looking for a way to retrieve the location of a page embedded into a frameset. I have a log on page built to catch users who have timed out and wish to return users back to the page from which they came. I am currently using a meta tag in combination with the HTTP_REFERER, but the problem is that some of the pages from which users are coming are in a frameset's main window. Here is what I currently have: In the log on page I have input type=hidden name=referer_url value=#CGI.HTTP_REFERER# The verification page then sets the variables and calls the meta meta http-equiv=refresh content=.1; url=#newurl# I even went as far as to try JavaScript: window.history.go (-2) so I am looking for a way to target the main frame or lower frame of a frameset. Bryan Langford Web Info Specialist National Customer Operations Enterprise Services Strategic Planning Training Development and Design Team. ~~ 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
Passing SP params to CFReport
I have tried every variation I can think of to pass in three parameters into a CFReport for use when it calls a stored procedure. I can call a report that requires no input fine and it displays fine. When it requires parameters it seems to just hang, like the server is prompting for them only I obviously can't see the prompt. It just gives me the forever spinning globe in my browser. CF5 with Crystal 8. ~~ 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: Anyone else having problems with Hostcentric?
At 11:42 AM 08/17/2001 -0400, you wrote: Hi all I maintain jamesabrams.com for my client. It's currently being hosted by Hostcentric. The site's been there since way before the Hostcentric takeover in 1999. Do you mean Virtualscape in the first sentence? I first noticed my site was down last Saturday evening (8/11). Since then, it's been up and down. Repeated emails to the support department yield only 'its a hardware issue' or 'connectivity problem' type answers. They won't tell me when I can expect my site to come back up. I've read another post about issues with their billing department (not closing a closed account). Is anyone else having problems with them? My site is hosted on a server named 'Virtualscape29'. Anyone else here on that server? If you were paying $54.99 a month, would you put up with with this? At what point would you change hosts? Is the web presence a necessity for doing business? If so, then I'd say it's time to change hosts. Otherwise you can stand to be a little more flexible. But.. it's your money. I would start researching alternate options the second that the service starts becoming unbearable. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- I'm looking for a room-mate in the Hartford CT area, starting in August -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 http://www.instantcoldfusion.com -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- If you lived here, it wouldn't be my house; it'd be yours. ~~ 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: hyperlinks in IE5 for Mac
How about a URL... there is a function that needs to bee seen Dick At 3:35 PM +0100 8/17/01, Neil Clark wrote: Anyone have or had any problems with IE5 for the Macintosh? I have the link below which works in IE/NN on the PC and NN on the mac but not IE!? a href=index.mcb?threedot=work title= work onMouseOver=thisLinkStatus('who we work with, and what we have done; a visual feast.');return document.returnValue onMouseOut=thisLinkStatus('navigate with the quick links - its easy!');return document.returnValueimg src=images/work.gif width=75 height=10 border=0/a Anyone? Neil ~~ 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: Passing SP params to CFReport
What database? I had a similar issue with Sybase ASA 7.02. Upgrading to 7.03 solved it. Todd - Original Message - From: DJ Riebesell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 2:16 PM Subject: Passing SP params to CFReport | I have tried every variation I can think of to pass in three parameters into | a CFReport for use when it calls a stored procedure. | | I can call a report that requires no input fine and it displays fine. | | When it requires parameters it seems to just hang, like the server is | prompting for them only I obviously can't see the prompt. It just gives me | the forever spinning globe in my browser. | | CF5 with Crystal 8. ~~ 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: Passing SP params to CFReport
MS SQL Server 7.0 -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:55 PM To: CF-Talk Subject: Re: Passing SP params to CFReport What database? I had a similar issue with Sybase ASA 7.02. Upgrading to 7.03 solved it. Todd - Original Message - From: DJ Riebesell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 2:16 PM Subject: Passing SP params to CFReport | I have tried every variation I can think of to pass in three parameters into | a CFReport for use when it calls a stored procedure. | | I can call a report that requires no input fine and it displays fine. | | When it requires parameters it seems to just hang, like the server is | prompting for them only I obviously can't see the prompt. It just gives me | the forever spinning globe in my browser. | | CF5 with Crystal 8. ~~ 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: CFX_Socket was ASP vs. Cold Fusion
We have a CFX_JSocket tag written in java, free and open source. Check it out: http://www.cfdev.com/products/index.cfm?ref=126 + Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developers Resources http://www.cfdev.com/ -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:27 PM To: CF-Talk Subject: Re: CFX_Socket was ASP vs. Cold Fusion There is a socket CFX as well as a new COM object at www.intrafoundation.com (comes with complete source code as well). Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: BT [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 11:49 AM Subject: CFX_Socket was ASP vs. Cold Fusion Um I did some research all over and couldn't find CFX_Socket... Devex doesn't have it, Google is a no go, and in a last attempt CFXSocket.com is not taken All I could turn up was cfsocket for Mac OS X for Core Foundation... What in the Hello.. ~~ 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
Checking for a files existence?
Does checking for a files existence use up alot of system resources? Does it take a long time? Brook ~~ 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
file/directory browsing/selection
hi fellow cf'ers! hope everyone is doing good ok enough chit chat i need to build an interface for file/directory browsing/selection that will let the user select a file off the server...like the one in the CF Administrator that can be used when you select your DSN... any tips on which tag(s) to use would be most appreciated. ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional http://coldfusionwebs.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: Checking for a files existence?
well, there was a script i tried to run on a webserver of ours that would compare to web folders already there, using the DirectoryExists function, there was about 15000+ folders, and well...i couldn't even find the correct time to set as the timeout, so i've had to resort by cleaning up in blocks, which of course is a better method anyways, considering load on the server just my .02 -kev ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:49 PM To: CF-Talk Subject: Checking for a files existence? Does checking for a files existence use up alot of system resources? Does it take a long time? Brook ~~ 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
ReUseForm
I've been messing with ReUseForm for a couple of days now... hating it! Anyone have access to some good docs on ReUseForm... or perhaps some code... The ReadMe.txt file is inadequate for my small brain. :-) 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: Checking for a files existence?
use the built-in FileExists() function - it returns a simple true or false. As for processing time, I've not seen any performance hit from using it, and it processes faster than loading a plain HTML web page. On the other hand, if you are checking the existence of a few hundred thousand files, then yes, it may take a bit... Shawn Grover -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:49 PM To: CF-Talk Subject: Checking for a files existence? Does checking for a files existence use up alot of system resources? Does it take a long time? Brook ~~ 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: file/directory browsing/selection
cfdirectory and cftree would probably meet your needs. Good luck. Shawn Grover -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:52 PM To: CF-Talk Subject: file/directory browsing/selection hi fellow cf'ers! hope everyone is doing good ok enough chit chat i need to build an interface for file/directory browsing/selection that will let the user select a file off the server...like the one in the CF Administrator that can be used when you select your DSN... any tips on which tag(s) to use would be most appreciated. ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional http://coldfusionwebs.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: file/directory browsing/selection
Ahhh... I don't know. Perhaps you should as a Macromedia Certified ColdFusion Professional! grin Seriously though, why not look at the CFADMIN code? At 04:51 PM 8/17/01 -0400, you wrote: hi fellow cf'ers! hope everyone is doing good ok enough chit chat i need to build an interface for file/directory browsing/selection that will let the user select a file off the server...like the one in the CF Administrator that can be used when you select your DSN... any tips on which tag(s) to use would be most appreciated. ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional http://coldfusionwebs.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: ASP vs. Cold Fusion
Todd Ashworth wrote: You can also telnet into the machine and see if the mailserver is running. Often times you get something like this: +OK POP3 dssf.tudelft.nl v2000.70 server ready Of course the port 25 block failover and MX checks might prevent this from working as well. 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
OT: Regexp
I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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
CF_TwoSelectsRelated
Hi, Guru, I tried to implement the CF_TwoSelectsRelated tag from the Developer's Exchange and got an error of evaluting the expression: MyQuery=Evaluate(Caller.#Attributes.Query#) I have been looking at it too long and lost my brain. Can anyone help to point out what mistake that I made? Please feel free to make any comment. Your enlightment is greatly appreicated. Here is the code straight out from the tag with some modification. Thank you. cfparam name=Attributes.Query default=Server.Cats cfparam name=Attributes.Display1 default=MASTER_CAT cfparam name=Attributes.Display2 default=CAT cfparam name=Attributes.Value1 default=#Attributes.Display1# cfparam name=Attributes.Value2 default=#Attributes.Display2# cfparam name=Attributes.Name1 default=TwoSelectsRelated1 cfparam name=Attributes.Name2 default=TwoSelectsRelated2 cfparam name=Attributes.Size1 default=1 cfparam name=Attributes.Size2 default=1 cfparam name=Attributes.Width1 default= cfparam name=Attributes.Width2 default= cfparam name=Attributes.ForceWidth1 default= cfparam name=Attributes.ForceWidth2 default= cfparam name=Attributes.ForceWidthChar default=nbsp; cfparam name=Attributes.EmptyText1 default= cfparam name=Attributes.EmptyText2 default= cfparam name=Attributes.Message1 default=You must choose an option for #Attributes.Name1#. cfparam name=Attributes.Message2 default=You must choose an option for #Attributes.Name2#. cfparam name=Attributes.FormName default=TwoSelected cfparam name=Attributes.HTMLBetween default= cfparam name=Attributes.OnChange default= cfparam name=Attributes.AutoselectFirst default=Yes cfset FunctionName=ReplaceList(Attributes.FormName, [,], ,) ChangeMenu() cfif Attributes.OnChange is Jump! cfset Attributes.OnChange=document.location=this.options[selectedIndex}.value; cfelseif Attributes.OnChange is Submit! cfset Attributes.OnChange=this.form.submit(); /cfif !--- use passed query width this code as MyQuery --- cfset MyQuery=Evaluate(Caller.#Attributes.Query#) cfquery name=Server.Cats datasource=CompanyInfo dbtype=ODBC SELECT MASTER_CAT FROM Cats /cfquery cfquery name=Server.Cats datasource=CompanyInfo dbtype=ODBC SELECT CAT FROM Cats /cfquery cfoutput script language=JavaScript1.1 var maxlength=10; OneA=new Array; var trueLength=OneA.length; var lst=OneA.length; function require_#Attributes.Name1#() { with (document.#Attributes.FormName#.#Attributes.Name1#) { RetVal=true; if (options[selectedIndex]==null) RetVal=false; else RetVal=!(options[selectedIndex].value==''); if (!RetVal) alert('#Attributes.Message1#'); return RetVal } } function require_#Attributes.Name2#() { with (document.#Attributes.FormName#.#Attributes.Name2#) { RetVal=true; if (options[selectedIndex]==null) RetVal=false; else RetVal=!(options[selectedIndex].value==''); if (!RetVal) alert('#Attributes.Message2#'); return RetVal } } function require_#Attributes.Name1#And#Attributes.Name2#() { return ((require_#Attributes.Name1#()) (require_#Attributes.Name2#())); } function #FunctionName# { OneA.length=0; menuNum=document.#Attributes.FormName#.#Attributes.Name1#.selectedIndex; if (menuNum==null) return; /cfoutput cfset Counter=IIF(Attributes.EmptyText1 is not , 1, 0) cfoutput query=MyQuery group=#Attributes.Display1# if (menuNum==#Counter#) { NewOpt=new Array; NewVal=new Array; cfset Counter2=IIF(Attributes.EmptyText2 is not , 1, 0) cfif Attributes.EmptyText2 is not cfoutput NewOpt[0]=new Option(#Attributes.EmptyText2#); NewOpt[0].value=''; /cfoutput /cfif cfoutput NewOpt[#Counter2#]=new Option(#Evaluate(Attributes.Display2)#); NewOpt[#Counter2#].value='#Evaluate(Attributes.Value2)#'; cfset Counter2=Counter2 + 1 /cfoutput } cfset Counter=Counter + 1 /cfoutput cfoutput tot=NewOpt.length; lst=document.#Attributes.FormName#.#Attributes.Name2#.options.length; for (i=lst; i0; i--) { document.#Attributes.FormName#.#Attributes.Name2#.options[i]=null; } for (i=0; itot; i++) { document.#Attributes.FormName#.#Attributes.Name2#.options[i]=NewOpt[i]; } cfif Attributes.AutoSelectFirst is Yes document.#Attributes.FormName#.#Attributes.Name2#.options0].selected=true; /cfif } /script /cfoutput cfif Attributes.Size1 is Auto cfset Attributes.Size1=Counter /cfif cfif Attributes.Size2 is Auto cfset Attributes.Size2=Attributes.Size1 /cfif cfoutput select name=#Attributes.Name1# onChange=#FunctionName# size=#Attributes.Size1# cfif Attributes.Width1 is not style=width:#Attributes.Width1# /cfif /cfoutput cfif Attriubtes.EmptyText1 is not cfoutput option value= #Attributes.EmptyText1# /cfoutput
RE: Regexp
Since CF treats # as a variable marker, you have to escape it. Just use ## to mean one #. Also, instead of doing multiple REReplaces, use []s. Ie, tempstring = REREplace(tempstring,[ @##etc],,ALL); === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 5:13 PM To: CF-Talk Subject: OT: Regexp I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Regexp
Try [[:punct:]] That gets rid of punctuation... anything that's not letters or numbers basically. tempstring = REReplace(tempstring, [[:punct:]], , all) Stuart Duncan MaracasMedia Inc. At 02:12 PM 8/17/01 -0700, you wrote: I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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: Regexp
but the # errors out. Have you tried escaping it? tempstring = REREplace(tempstring, ##, , all) ~~ 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: Regexp
What about something like this: cfset invalidchars = [!@`;:'%,##\*\?\$\^\] !--- invalidate certain characters --- CFSET tempstring = REReplace(tempstring,invalidchars,,ALL) Glenn Olsen Doceus -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 5:13 PM To: CF-Talk Subject: OT: Regexp I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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
using cf_combo box
if the company that the person entered in the combo box doesnt exist in the database... how would the insert statement look to insert the new company in tblCompany? because the value=#CompanyID# works for my passthru table if the company already exists. but if it doesnt, i need to insert the name in tblCompany and then the new CompanyID in tblCompEquip. cf_combobox name=CompanyNM value= cfoutput query=qryComp group=CompanyNM option value=#CompanyID# class=BIOS#CompanyNM#/cfoutput /cf_combobox * 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
Newbie - URL redirect?
How do I redirect an incoming url request to a specific directory on the server? I have multiple domain names routing to the same root directory - I'd like to have each separate domain name be directed to the appropriate directory to keep the different sites separated. I've tried the following cf code provided by my hosting company: cfif server_name IS www.domain2.com cflocation url=directory2 cfelseif server_name IS www.domain3.com cflocation url=directory3 cfelseif... /cfif I've put this at the top of the default page in the root directory, but it doesn't work. What am I missing? TIA, jon 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: Regexp
Try: tempstring = REREplaceNoCase(tempstring, [^A-Z_], , all) HTH Dick At 2:12 PM -0700 8/17/01, Bruce, Rodney wrote: I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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: file/directory browsing/selection
doh! guess i was thinking this was going to be harder than it was... never mind. ~~ Stephenie - Original Message - From: Stephenie Hamilton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 4:51 PM Subject: file/directory browsing/selection hi fellow cf'ers! hope everyone is doing good ok enough chit chat i need to build an interface for file/directory browsing/selection that will let the user select a file off the server...like the one in the CF Administrator that can be used when you select your DSN... any tips on which tag(s) to use would be most appreciated. ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional http://coldfusionwebs.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: Checking for a files existence?
As with most other things on the web, it is all relative. If you are talking about a call that happens infrequently, checking for a file's existence is not a major hit. There is a performance hit associated with it, it just depends on frequecy. Example: Trusted Cache In this case, we are talking about turning off file checking (to determine the date/time of the .cfm on disk, and compare to the date/time of the pcode in RAM). Under this scenario, there *is* a gain to be had, as it affects virtually every call to a .cfm. Mike -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 4:49 PM To: CF-Talk Subject: Checking for a files existence? Does checking for a files existence use up alot of system resources? Does it take a long time? Brook ~~ 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: Regexp
I must be missing something: here is what I have, trying to use a UDF. The testing file name is ^@#$% $rt4o.txt When I run it through this code newfile is D:\documents\^@#$%$rt4o.txt I left the space separate for testing, the space is remove but none of the other chars are CFSCRIPT Function removestrangechars(pagestring){ temppage = REReplaceNoCase(pagestring, , , all); temppage = ReplaceNoCase(temppage, [@##$%^*()], , all); return temppage; } /CFSCRIPT CFOUTPUT CFSET newfile = getpagename(form.filename) CFSET newfile = D:\Documents\ removestrangechars(newfile) #newfile# /CFOUTPUT thanks rodney -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:23 PM To: CF-Talk Subject: RE: Regexp Since CF treats # as a variable marker, you have to escape it. Just use ## to mean one #. Also, instead of doing multiple REReplaces, use []s. Ie, tempstring = REREplace(tempstring,[ @##etc],,ALL); === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 5:13 PM To: CF-Talk Subject: OT: Regexp I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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 - URL redirect?
There ya go :o) cfif #CGI.SERVER_NAME# IS www.something.com cflocation url=index.cfm addtoken=no /cfif cfif #CGI.SERVER_NAME# IS www.something2.com cflocation url=knowledgebase.cfm addtoken=no /cfif cfif #CGI.SERVER_NAME# IS support.something.com cflocation url=support.cfm addtoken=no /cfif or you can use the cfelseif's of course... -kevin ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jon Dunn [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:36 PM To: CF-Talk Subject: Newbie - URL redirect? How do I redirect an incoming url request to a specific directory on the server? I have multiple domain names routing to the same root directory - I'd like to have each separate domain name be directed to the appropriate directory to keep the different sites separated. I've tried the following cf code provided by my hosting company: cfif server_name IS www.domain2.com cflocation url=directory2 cfelseif server_name IS www.domain3.com cflocation url=directory3 cfelseif... /cfif I've put this at the top of the default page in the root directory, but it doesn't work. What am I missing? TIA, jon 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=sts ~~ 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: Regexp
DUH No typing skill shows up again. My second Replace is misspelled below. corrected it and now exp works. Thanks for all the suggestions and help. Rodney -Original Message- From: Bruce, Rodney Sent: Friday, August 17, 2001 2:43 PM To: '[EMAIL PROTECTED]' Subject: RE: Regexp I must be missing something: here is what I have, trying to use a UDF. The testing file name is ^@#$% $rt4o.txt When I run it through this code newfile is D:\documents\^@#$%$rt4o.txt I left the space separate for testing, the space is remove but none of the other chars are CFSCRIPT Function removestrangechars(pagestring){ temppage = REReplaceNoCase(pagestring, , , all); temppage = ReplaceNoCase(temppage, [@##$%^*()], , all); return temppage; } /CFSCRIPT CFOUTPUT CFSET newfile = getpagename(form.filename) CFSET newfile = D:\Documents\ removestrangechars(newfile) #newfile# /CFOUTPUT thanks rodney -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:23 PM To: CF-Talk Subject: RE: Regexp Since CF treats # as a variable marker, you have to escape it. Just use ## to mean one #. Also, instead of doing multiple REReplaces, use []s. Ie, tempstring = REREplace(tempstring,[ @##etc],,ALL); === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 5:13 PM To: CF-Talk Subject: OT: Regexp I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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: Regexp
heh... switch your function names you need REReplace if you are pattern matching RegularExpressions. In the source below, you are trying to pattern match a regular expression with the normal replace function. -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:43 PM To: CF-Talk Subject: RE: Regexp I must be missing something: here is what I have, trying to use a UDF. The testing file name is ^@#$% $rt4o.txt When I run it through this code newfile is D:\documents\^@#$%$rt4o.txt I left the space separate for testing, the space is remove but none of the other chars are CFSCRIPT Function removestrangechars(pagestring){ temppage = REReplaceNoCase(pagestring, , , all); temppage = ReplaceNoCase(temppage, [@##$%^*()], , all); return temppage; } /CFSCRIPT CFOUTPUT CFSET newfile = getpagename(form.filename) CFSET newfile = D:\Documents\ removestrangechars(newfile) #newfile# /CFOUTPUT thanks rodney -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:23 PM To: CF-Talk Subject: RE: Regexp Since CF treats # as a variable marker, you have to escape it. Just use ## to mean one #. Also, instead of doing multiple REReplaces, use []s. Ie, tempstring = REREplace(tempstring,[ @##etc],,ALL); ==Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 5:13 PM To: CF-Talk Subject: OT: Regexp I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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: Regexp
rereplace(tempString,[^[:alnum:]],,ALL) Marlon -Original Message- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 4:13 PM To: CF-Talk Subject: OT: Regexp I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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 - URL redirect?
How about SWITCH/CASE? cfswitch=#CGI.SERVER_NAME# cfcase=www.something.com cflocation url=index.cfm addtoken=no /cfcase cfcase=www.something2.com cflocation url=knowledgebase.cfm addtoken=no /cfcase cfcase=support.something.com cflocation url=support.cfm addtoken=no /cfcase /cfswitch -Original Message- From: Kevin Mansel [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:45 PM To: CF-Talk Subject: RE: Newbie - URL redirect? There ya go :o) cfif #CGI.SERVER_NAME# IS www.something.com cflocation url=index.cfm addtoken=no /cfif cfif #CGI.SERVER_NAME# IS www.something2.com cflocation url=knowledgebase.cfm addtoken=no /cfif cfif #CGI.SERVER_NAME# IS support.something.com cflocation url=support.cfm addtoken=no /cfif or you can use the cfelseif's of course... -kevin ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jon Dunn [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:36 PM To: CF-Talk Subject: Newbie - URL redirect? How do I redirect an incoming url request to a specific directory on the server? I have multiple domain names routing to the same root directory - I'd like to have each separate domain name be directed to the appropriate directory to keep the different sites separated. I've tried the following cf code provided by my hosting company: cfif server_name IS www.domain2.com cflocation url=directory2 cfelseif server_name IS www.domain3.com cflocation url=directory3 cfelseif... /cfif I've put this at the top of the default page in the root directory, but it doesn't work. What am I missing? TIA, jon 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=sts ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Regexp
Misread the questionb... shoukd have been: tempstring = REReplaceNoCase(tempstring, [^A-Z0-9_], , all) Try: tempstring = REREplaceNoCase(tempstring, [^A-Z_], , all) HTH Dick At 2:12 PM -0700 8/17/01, Bruce, Rodney wrote: I need help with a regexp. I am trying to remove all special chars from file names. I can remove them one at a time like so: tempstring = REREplace(tempstring, , , all) tempstring = REReplace(tempstring, @, , all) etc but the # errors out. How can I do this in one pass, if possible? Thanks for any and all help ~~ 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
CFLocation and Passing Complex Data
Hi: I'm trying to pass complex data (structure in particular), using cflocation, but I'm not able to. The example is like this: cflocation url=template.cfm?stMemberData=#stMemberInfo# The error I'm getting is saying that I can only pass simple data with cflocation. I need to pass complex data. Is this possible to do? Thanks in advance. Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED], or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.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: CF_TwoSelectsRelated
On 8/17/01, Julia Phu penned: I tried to implement the CF_TwoSelectsRelated tag from the Developer's Exchange and got an error of evaluting the expression: MyQuery=Evaluate(Caller.#Attributes.Query#) One problem could be that you've set your attributes.query value to Server.Cats. Server is a variable scope. Inside that evaluate function, not telling what it's doing. :) Try changing it to MyServer.Cats and see what happens. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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: CFLocation and Passing Complex Data
Hi: Just wanted to add that the error message is also saying that you used to be able to do this in version 2.0. What version can do this now? Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED], or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.com - Original Message - From: Yvette Ingram [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, August 17, 2001 6:44 PM Subject: CFLocation and Passing Complex Data Hi: I'm trying to pass complex data (structure in particular), using cflocation, but I'm not able to. The example is like this: cflocation url=template.cfm?stMemberData=#stMemberInfo# The error I'm getting is saying that I can only pass simple data with cflocation. I need to pass complex data. Is this possible to do? Thanks in advance. Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED], or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.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