RE: ColdFusion and ArcIMS
The ESRI ArcIMS forums could be a place to check out: http://forums.esri.com/forums.asp?c=64 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and ArcIMS
further to arcIMS 4.01: i just finished upgrading a couple of intranet boxes w/arcIMS 4.01 got them all cooking in one shot. ditto for a new install on a development box. this is almost miraculous ;-) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: sqlplus locks qhen i am trying to delete a record
I have no idea if control returns because it becomes unresponsive for a long time then i quit and close the sqlplus. But i guess you are right. Sometimes it becomes unresponsive and some time it works fine for the same query. I will try to index the tables. Maybe upgrade my oracle for oracle 9x could solve my problem? =]. tks a lot, Carlos. -Original Message- From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 6:10 PM To: CF-Talk Subject: RE: sqlplus locks qhen i am trying to delete a record When you say it locks, do you mean it becomes unresponsive? I assume that's what you mean. My guess is you may need to create an index on the key you're deleting by (id), and you should also look at your triggers. Also, if you leave it for a while, does control eventually return? I've seem delete queries that take up to 45 minutes to run. You may want to check out metalink.oracle.com for a better source of info on Oracle problems. Kevin -Original Message- From: Carlos Henrique Aoki Kac [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 3:30 PM To: CF-Talk Subject: sqlplus locks qhen i am trying to delete a record Something really strange is happening (Oracle 8i). I have a database and when i try to delete a record which doesn´t exist the sqlplus becomes locked. And other tables the sqlplus returns the correct message 0 rows deleted. i.e: table home | id(Integer) | address(String) | | 1 | addr1 | | 2 | addr2 | | 3 | addr3 | When i try: delete from home where id = 5 the SQLPlus locks!!! What is going on? Could it be the relashionship between tables? tks, Carlos. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Submitting form. Passing variables to template
HI, Below is my code. I've removed some code just to make it easier to read. I have three templates. I'm listing the users from a database which gets a radio button inserted at the beginning of each field when displayed. When a user clicks on one of the radio buttons beside a users name I then want them to have the option of deleting or editing that field by clicking on the Edit/Delete graphic buttons. I can't get the checked radio button results passed to the submit-action.cfm page. What am I missing? Should it be a form rather than cfform? users.cfm cfform action=submit-action.cfm method=post input type=image src=cfoutput#Request.App.image_root#/cfoutputtestn.giffont color=#00Edit/font input type=image src=cfoutput#Request.App.image_root#/cfoutputtestn.giffont color=#00Delete/font CFINCLUDE template=dialog.cfm /cfform dialog.cfm CFQUERY NAME=GetUsers datasource=#Request.App.dsn# select * from login /cfquery table cfoutput query=GetUsers tr bgcolor=#bgColor(currentRow MOD 2,##DD,##EE)# tdinput type=radio name=Selected onfocus=this.blur();input type=hidden name=Selected#GetUsers.Username#/td td**/td td#GetUsers.Firstname#/td td#GetUsers.Lastname#/td /tr /cfoutput /table submit-action.cfm - h2cfoutput#FORM.Selected#/cfoutput/h2 --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FOLLOWUP - Submitting form. Passing variables to template
OK...I've been able to pass the results to my submit-action.cfm page but I'm getting ALL the fields of UserID from the database listed not just the one I checked on the radio buttons? I made one change to the code below on the input tags to pass the input value. tdinput type=radio name=Selected value=#UserID# onFocus=this.blur();input type=hidden value=#UserID# name=Selected#GetUsers.Username#/td This is the result I get on my submit-action.cfm page: #FORM.Selected# = 8,8,4,7,5,6,3,1,2 On Thu, 27 Mar 2003 07:57:53 -0500, FlashGuy wrote: HI, Below is my code. I've removed some code just to make it easier to read. I have three templates. I'm listing the users from a database which gets a radio button inserted at the beginning of each field when displayed. When a user clicks on one of the radio buttons beside a users name I then want them to have the option of deleting or editing that field by clicking on the Edit/Delete graphic buttons. I can't get the checked radio button results passed to the submit-action.cfm page. What am I missing? Should it be a form rather than cfform? users.cfm cfform action=submit-action.cfm method=post input type=image src=cfoutput#Request.App.image_root#/cfoutputtestn.giffont color=#00Edit/font input type=image src=cfoutput#Request.App.image_root#/cfoutputtestn.giffont color=#00Delete/font CFINCLUDE template=dialog.cfm /cfform dialog.cfm CFQUERY NAME=GetUsers datasource=#Request.App.dsn# select * from login /cfquery table cfoutput query=GetUsers tr bgcolor=#bgColor(currentRow MOD 2,##DD,##EE)# tdinput type=radio name=Selected onfocus=this.blur();input type=hidden name=Selected#GetUsers.Username#/td td**/td td#GetUsers.Firstname#/td td#GetUsers.Lastname#/td /tr /cfoutput /table submit-action.cfm - h2cfoutput#FORM.Selected#/cfoutput/h2 --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MedSeek
If you want a fully qualified opinion from a developer's perspective you should contact James Ang. He works there as a developer and will give you an unbiased opinion of the product. Email me offlist if you want his email addr. ~Jason -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 10:30 PM To: CF-Talk Subject: Re: MedSeek They came and did a dog and pony show for us (Baylor Health Care System, Dallas TX) of their CMS. It is over 165K. Pretty pricy considering that you can order Ektron's Empower CMS for under 20K, and that includes all the open source code. In fact, Medseek is using Ektron's WYSIWYG editor for their product. Understand though that we are just looking for a CMS that we can incorporate into our portal. HTH, Bruce - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 9:17 AM Subject: MedSeek Has anyone heard of or used MedSeek or MedSeek's sitemaker? If so, what comments do you have on it? We are trying to determine if this is a better fit for us than CommonSpot. TIA Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Securing XML files...
I've started to put some config and other data in XML files for our applications and have no idea how to secure the information, especially on a shared server. Has any of y'all come up with a good way to do this? Tyler ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Checking values of input passed to template
Hi again, I have four input tags that based on which one I click on passes the appropriate varaible. For example input type=image name=new src=cfoutput#Request.App.image_root#/cfoutputnew.gif onFocus=this.blur(); br input type=image name=delete src=cfoutput#Request.App.image_root#/cfoutputdelete.gif onFocus=this.blur(); So...if I click on the new image I want to pass that to my action page. so I can check it and do my edit stuff. cfif new... Do this /cfif cfif delete... Do this /cfif And so on... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Getting rid of evaluate
At 09:14 AM 03/26/03 -0600, Mark A. Kruger - CFG wrote: Thane, Make your fields part of a structure... Thanks for the code, I'll try that. Of course depending on what you are trying to do there are probably easier ways to accomplish it. Your data structure seems unconventional, but I'm only seeing a tiny piece of it of course. Perhaps the point is to convert a bunch of individual data members into a 2d array. An array of structures might be a better choice if you have more than one collection of these individual data members. I'm trying to create a form system where I can simply enter the field information (name, type, size, displayed name, validation) and then some generic code will build a form for me. (I'm tired of building forms and data entry scripts from scratch or near scratch every time.) There's probably a better way to do this, but I haven't figured it out. :) T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT-DTS
Anyone ever used DTS to migrate data from MS Access to MySQL? I've installed the MyODBC driver and created an ODBC connection then I'm using DTS to export the data from the specified access db to the mysql db. It creates all tables, but when inserting Memo type columns (I think) it gives this error: Query-based insertion or updating of BLOB values is not supported. Do I need to customize the query and convert the data to another datatype? I'm new to MySQL. Thanks, Greg ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FOLLOWUP - Submitting form. Passing variables to template
You are getting the result of every hidden input named Selected in a comma delimeted list. Remove all the hidden inputs and use the value statement in the radio button tags. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 27, 2003 8:05 AM : To: CF-Talk : Subject: Re: FOLLOWUP - Submitting form. Passing variables to template : : : OK...I've been able to pass the results to my submit-action.cfm : page but I'm getting ALL the fields of UserID from the database : listed not just the one I checked on the radio : buttons? : : I made one change to the code below on the input tags to pass : the input value. : : tdinput type=radio name=Selected value=#UserID# : onFocus=this.blur();input type=hidden value=#UserID# : name=Selected#GetUsers.Username#/td : : This is the result I get on my submit-action.cfm page: : : #FORM.Selected# = 8,8,4,7,5,6,3,1,2 : : On Thu, 27 Mar 2003 07:57:53 -0500, FlashGuy wrote: : : HI, : : Below is my code. I've removed some code just to make it easier : to read. I have three templates. I'm listing the users from a : database which gets a radio button inserted : at : the beginning of each field when displayed. When a user clicks : on one of the radio buttons beside a users name I then want them : to have the option of deleting or editing : that field by clicking on the Edit/Delete graphic buttons. I : can't get the checked radio button results passed to the : submit-action.cfm page. : : What am I missing? Should it be a form rather than cfform? : : : users.cfm : : : cfform action=submit-action.cfm method=post : input type=image : src=cfoutput#Request.App.image_root#/cfoutputtestn.giffont : color=#00Edit/font : input type=image : src=cfoutput#Request.App.image_root#/cfoutputtestn.giffont : color=#00Delete/font : CFINCLUDE template=dialog.cfm : /cfform : : : : dialog.cfm : : : CFQUERY NAME=GetUsers datasource=#Request.App.dsn# : select * : from login : /cfquery : : table : cfoutput query=GetUsers : tr bgcolor=#bgColor(currentRow MOD 2,##DD,##EE)# : tdinput type=radio name=Selected : onfocus=this.blur();input type=hidden : name=Selected#GetUsers.Username#/td : td**/td : td#GetUsers.Firstname#/td : td#GetUsers.Lastname#/td : /tr : /cfoutput : /table : : : submit-action.cfm : - : : h2cfoutput#FORM.Selected#/cfoutput/h2 : : : : : --- : Colonel Nathan R. Jessop : Commanding Officer : Marine Ground Forces : Guatanamo Bay, Cuba : --- : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT-DTS
This is a mySQL problem methinks and it would appear to be self-explanatory. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 14:29 To: CF-Talk Subject: OT-DTS Anyone ever used DTS to migrate data from MS Access to MySQL? I've installed the MyODBC driver and created an ODBC connection then I'm using DTS to export the data from the specified access db to the mysql db. It creates all tables, but when inserting Memo type columns (I think) it gives this error: Query-based insertion or updating of BLOB values is not supported. Do I need to customize the query and convert the data to another datatype? I'm new to MySQL. Thanks, Greg ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Macromedia Central and FlashCom 1.5
Some interesting announcements at Flashforward : - Macromedia Central, a new way to distribute/sell FlashMX applications, http://www.macromedia.com/software/central/ http://www.macromedia.com/devnet/central/ - Macromedia FlashCom MX 1.5 http://www.macromedia.com/software/flashcom/ Benoit Hediard www.benorama.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FOLLOWUP - Submitting form. Passing variables to template
Yea...I noticed that and removed the hidden fields. Works OK now. Thanks On Thu, 27 Mar 2003 09:35:13 -0500, Ben Doom wrote: You are getting the result of every hidden input named Selected in a comma delimeted list. Remove all the hidden inputs and use the value statement in the radio button tags. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 27, 2003 8:05 AM : To: CF-Talk : Subject: Re: FOLLOWUP - Submitting form. Passing variables to template : : : OK...I've been able to pass the results to my submit-action.cfm : page but I'm getting ALL the fields of UserID from the database : listed not just the one I checked on the radio : buttons? : : I made one change to the code below on the input tags to pass : the input value. : : tdinput type=radio name=Selected value=#UserID# : onFocus=this.blur();input type=hidden value=#UserID# : name=Selected#GetUsers.Username#/td : : This is the result I get on my submit-action.cfm page: : : #FORM.Selected# = 8,8,4,7,5,6,3,1,2 : : On Thu, 27 Mar 2003 07:57:53 -0500, FlashGuy wrote: : : HI, : : Below is my code. I've removed some code just to make it easier : to read. I have three templates. I'm listing the users from a : database which gets a radio button inserted : at : the beginning of each field when displayed. When a user clicks : on one of the radio buttons beside a users name I then want them : to have the option of deleting or editing : that field by clicking on the Edit/Delete graphic buttons. I : can't get the checked radio button results passed to the : submit-action.cfm page. : : What am I missing? Should it be a form rather than cfform? : : : users.cfm : : :cfform action=submit-action.cfm method=post : input type=image : src=cfoutput#Request.App.image_root#/cfoutputtestn.giffont : color=#00Edit/font : input type=image : src=cfoutput#Request.App.image_root#/cfoutputtestn.giffont : color=#00Delete/font : CFINCLUDE template=dialog.cfm : /cfform : : : : dialog.cfm : : : CFQUERY NAME=GetUsers datasource=#Request.App.dsn# : select * : from login : /cfquery : : table : cfoutput query=GetUsers : tr bgcolor=#bgColor(currentRow MOD 2,##DD,##EE)# : tdinput type=radio name=Selected : onfocus=this.blur();input type=hidden : name=Selected#GetUsers.Username#/td : td**/td : td#GetUsers.Firstname#/td : td#GetUsers.Lastname#/td : /tr : /cfoutput : /table : : : submit-action.cfm : - : : h2cfoutput#FORM.Selected#/cfoutput/h2 : : : : : --- : Colonel Nathan R. Jessop : Commanding Officer : Marine Ground Forces : Guatanamo Bay, Cuba : --- : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re:ColdFusion and ArcIMS
We use ArcIMS for displaying data from our research department. http://appalachia.outdoors.org/mapping/ So far it works great for us. We also are having discussions about some much larger projects which would utilize the system. Ironically, we found that the most tricky part of it all is the initial install. Specifically getting the java servlet engine to play nicely. But it's just a matter of the right configuration (and which engine you decide to use - we are on CF5 not CFMX). And there are some great hint docs out there that will help with that (let me know if you have problems and I can dig them up). Once you have it installed, it's pretty easy to use. I would also agree with whomever posted about learning ArcXML. Some real power can be gained through the use of that which simply can't be gotten any other way. --Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking values of input passed to template
When you use the image type in HTML is passes the .x and .y coords of where on the image you clicked. If you cfdump the form scope you will see which variables are available to you. Also, if you have multiple image types only the one you click will be passed to the action page. DM = = = Original message = = = Hi again, I have four input tags that based on which one I click on passes the appropriate varaible. For example input type=image name=new src=cfoutput#Request.App.image_root#/cfoutp utnew.gif onFocus=this.blur(); br input type=image name=delete src=cfoutput#Request.App.image_root#/cfo utputdelete.gif onFocus=this.blur(); So...if I click on the new image I want to pass that to my action page. so I can check it and do my edit stuff. cfif new... Do this /cfif cfif delete... Do this /cfif And so on... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT-DTS
Actually it's not a MySQL problem per se -- I've seen similar things before from the ODBC driver. I'd first look at the schema for the MySQL db generated by DTS to see what column type the memo field was turned into -- if your memo fields generally only hold 255 characters or less, by all means turn them into varchar columns! If not, your life gets a little more complicated. If they really are long text fields, you should be using one of the TEXT types in MySQL for that column -- TEXT, MEDIUMTEXT, or LONGTEXT depending on the size. You *could* use the transform functions in DTS to generate a script to do the insert/update of the text data, but since this is a CF list, I'm guessing you know CF, so it might be easier (assuming this is a one-off conversion) to write a quick CF script that reads in the data and then inserts the memo data into MySQL using CFMX and it's JDBC MySQL driver which is more robust IMHO. While you're at it, take a look at how the boolean data fields converted -- if you're not careful, those fields can get mapped onto int or tinyint which are unsigned by default in MySQL -- so all the true values (-1) get truncated to 0 so everything becomes false in the column. Converting can be a little tricky since the data types are defined differently in Access and MySQL. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 9:35 AM Subject: RE: OT-DTS This is a mySQL problem methinks and it would appear to be self-explanatory. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 14:29 To: CF-Talk Subject: OT-DTS Anyone ever used DTS to migrate data from MS Access to MySQL? I've installed the MyODBC driver and created an ODBC connection then I'm using DTS to export the data from the specified access db to the mysql db. It creates all tables, but when inserting Memo type columns (I think) it gives this error: Query-based insertion or updating of BLOB values is not supported. Do I need to customize the query and convert the data to another datatype? I'm new to MySQL. Thanks, Greg ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking values of input passed to template
I've never used cfdump. Whats the syntax to dump the variables from the form? cfdump var=query Outputs: query On Thu, 27 Mar 2003 9:55:38 -0500, [EMAIL PROTECTED] wrote: When you use the image type in HTML is passes the .x and .y coords of where on the image you clicked. If you cfdump the form scope you will see which variables are available to you. Also, if you have multiple image types only the one you click will be passed to the action page. DM = = = Original message = = = Hi again, I have four input tags that based on which one I click on passes the appropriate varaible. For example input type=image name=new src=cfoutput#Request.App.image_root#/cfoutp utnew.gif onFocus=this.blur(); br input type=image name=delete src=cfoutput#Request.App.image_root#/cfo utputdelete.gif onFocus=this.blur(); So...if I click on the new image I want to pass that to my action page. so I can check it and do my edit stuff. cfif new... Do this /cfif cfif delete... Do this /cfif And so on... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checking values of input passed to template
Try: cfdump var=#Form# and check the manual... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion and ArcIMS
Recently I had to learn the ins and outs of CF and ArcIMS, it's been fun. I inherited a number of ArcIMS projects from a developer who quit and had to become competent in it very quickly. In our shop, we have ArcIMS set up with ArcSDE to generate maps dynamically based on layered data. Specificially, we are displaying regional maps containing business locations, congressional districts, state lines, roads, etc. Nothing too fancy. The biggest challenge has been learning ArcSDE administration - ArcSDE itself was fairly easy to set up, but the process of adding / taking data out of various mapservices was difficult to work with primarily because it uses command line tools for most of its data-loading functions. While we found we could get by with just using shapefiles, we really needed a spatially enabled database to handle the constantly changing data in our output files (and we needed ArcView to make the shapefiles, which meant updates to the mapping services were done by a human operator). Oh yeah, and we were not going to use the java browser for our Web sites even if it meant more work, nobody was really fond of it too much around here and XP users were having to download the JDK. But we were able to build out a fully automated system. It took about six weeks. One tutorial I found helpful was from the NOAA, I think this was the link: http://hypernews.ngdc.noaa.gov/HyperNews/get/geospatial.html?inline=-1nogif s NOAA is big into ArcIMS but they like to automate it with Perl. Nonetheless, the syntax for ArcIMS is the same. M -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 1:19 PM To: CF-Talk Subject: RE: ColdFusion and ArcIMS Well, what we're doing is showing maps of a specific area and then allowing someone to enter gps points for a well or septic system or outbuilding, etc. Then we need to be able to lay those points on top of the main property map with an outline of the structure they've entered into the system. Does this sound like something that Mapserver can handle? How about plotting based on physical address? Or is there another database somewhere that I could use to lookup lat/long points for a physical address? Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 1:17 PM To: CF-Talk Subject: Re: ColdFusion and ArcIMS Basically all we need to do is generate a map based off of lat/long points. We'll eventually be laying maps overtop of the standard map, but I would imagine the ability to do layering, etc. would require the paid product. no, mapserver can handle that plenty fine. do you have an exact list of your requirements? got data, etc? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checking values of input passed to template
OK...now I get: FIELDNAMES NEW.X,NEW.Y NEW.X 11 NEW.Y 11 FORM.fieldnames: NEW.X,NEW.Y How can I check just for new? On Thu, 27 Mar 2003 16:11:19 +0100, Hugo Ahlenius wrote: Try: cfdump var=#Form# and check the manual... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Checking values of input passed to template
cfdump var=#form# Cfdump is a CF developer's best friend. Learn to use it and use it often! DM = = = Original message = = = I've never used cfdump. Whats the syntax to dump the variables from the form? cfdump var=query Outputs: query On Thu, 27 Mar 2003 9:55:38 -0500, [EMAIL PROTECTED] wrote: When you use the image type in HTML is passes the .x and .y coords of where on the image you clicked. If you cfdump the form scope you will see which variables are available to you. Also, if you have multiple image types only the one you click will be passed to the action page. DM = = = Original message = = = Hi again, I have four input tags that based on which one I click on passes the appropriate varaible. For example input type=image name=new src=cfoutput#Request.App.image_root#/cfou tp utnew.gif onFocus=this.blur(); br input type=image name=delete src=cfoutput#Request.App.image_root#/c fo utputdelete.gif onFocus=this.blur(); So...if I click on the new image I want to pass that to my action page. so I can check it and do my edit stuff. cfif new... Do this /cfif cfif delete... Do this /cfif And so on... --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re:RE: application.cfm
CF5 does not allow for a blank application.cfm. It will throw an error. I in fact just ran into that last week. :) You can use something simple like cfset fu = bar and you will be all set. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Checking values of input passed to template
OK...now I get: FIELDNAMES NEW.X,NEW.Y NEW.X 11 NEW.Y 11 FORM.fieldnames: NEW.X,NEW.Y How can I check just for new? If you're using CFDUMP to dump the Form scope, and something doesn't show up in there that you're expecting, well, it's not in there, so there's nothing else to check for. CFDUMP shows you everything in the Form scope, when you dump that scope. If new corresponds to an INPUT field with TYPE=IMAGE, you won't have a variable called new in the Form scope - you'll just have new.x and new.y. That's just the way image fields work in HTML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RE: application.cfm
Yep, you cannot have a blank application or onrequestend.cfm page You can simply put a CF comment in it as well, that should be enough. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 15:23 To: CF-Talk Subject: Re:RE: application.cfm CF5 does not allow for a blank application.cfm. It will throw an error. I in fact just ran into that last week. :) You can use something simple like cfset fu = bar and you will be all set. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RE: application.cfm
Actually CF doesn't allow a blank template. You can avoid this by having just one CR/LF in the file. You don't need a CF tag -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: donderdag 27 maart 2003 16:23 To: CF-Talk Subject: Re:RE: application.cfm CF5 does not allow for a blank application.cfm. It will throw an error. I in fact just ran into that last week. :) You can use something simple like cfset fu = bar and you will be all set. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Securing XML files...
I've started to put some config and other data in XML files for our applications and have no idea how to secure the information, especially on a shared server. Has any of y'all come up with a good way to do this? There's nothing inherently different about securing XML files, as opposed to any other sort of files. They're just text files. If you're concerned about people being able to download them from your web site, don't put them in a public web directory. If you're concerned about people with filesystem access being able to read them, use filesystem permissions to prevent that if possible. If you're concerned about people with the ability to write programs in CF that could read your files, and who can store those programs on this shared server, your server administrator will need to use the security sandbox functionality provided in CFMX, or the Advanced Security functionality in CF 4-5. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Killer App vs. Right App
Just thought, the title might be a bit misleading, which may bear negative connotation, that is, some one may construe it to imply Right App may not equal to Killer App, in actuality, some Right App may well be Killer App. Need example? Don http://www.hegelsoftware.com/regURL.htm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: RE: application.cfm
Just to remind folks - this was fixed in MX. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 9:32 AM To: CF-Talk Subject: RE: RE: application.cfm Actually CF doesn't allow a blank template. You can avoid this by having just one CR/LF in the file. You don't need a CF tag -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: donderdag 27 maart 2003 16:23 To: CF-Talk Subject: Re:RE: application.cfm CF5 does not allow for a blank application.cfm. It will throw an error. I in fact just ran into that last week. :) You can use something simple like cfset fu = bar and you will be all set. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Re:ColdFusion and ArcIMS
larger projects which would utilize the system. Ironically, we found that the most tricky part of it all is the initial install. Specifically getting the then by all means do the upgrade to arcIMS 4.01. i'm astounded by the improvements. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT-DTS
Try this: cfquery name=rs datasource=#accessdb# SELECT * FROM mytable /cfquery cfloop query=rs cfquery name=rsins datasource=#mysqldb# INSERT INTO mytable ( my,list,of,columns ) VALUES ( cfqueryparam value=#rs.my# cfsqltype=cf_sql_longvarchar cfqueryparam value=#rs.list# cfsqltype=cf_sql_varchar cfqueryparam value=#rs.of# cfsqltype=cf_sql_integer cfqueryparam value=#rs.columns# cfsqltype=cf_sql_float ) /cfquery /cfloop This is a mySQL problem methinks and it would appear to be self-explanatory. -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 14:29 To: CF-Talk Subject: OT-DTS Anyone ever used DTS to migrate data from MS Access to MySQL? I've installed the MyODBC driver and created an ODBC connection then I'm using DTS to export the data from the specified access db to the mysql db. It creates all tables, but when inserting Memo type columns (I think) it gives this error: Query-based insertion or updating of BLOB values is not supported. Do I need to customize the query and convert the data to another datatype? I'm new to MySQL. Thanks, Greg ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/uns ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query Timeout
Why does this never actually work. I am running a query on an ODBC datasource. The ODBC is connecting to an informix database. I don't want the query to take longer then 30 seconds. Not that coldfusion cares what I tell it the timeout value is. The main question is: Why does the timeout not work. The second question is Is there any way to wrap things with a timeout value as to say if what is inside of here take more then x time throw an error. Also is there a way to run a query in what would be like a seperate thread similar to doing a callback so that while the query is proccessing other things can run and then set a wait point or something? Tyler Clendenin GSL Solutions, Inc. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFSELECT (I hate CFFORM)
Actually Bud it doesn't work with no value attribute either (I tried it every way possible). Anyways, thanks for the responseI rolled a custom solution to get around CFSELECT and it's dark dark evilness ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 5:16 PM Subject: Re: CFSELECT (I hate CFFORM) On 3/26/03, Bryan Stevenson penned: I'm using IE and I know IE would consider the text Select one as the selection when the option value is left blank as I'm doing. I tried removing the Select one text and it still didn't catch the lack of selection!! It shouldn't. If it does it's broke. It should only recognize Select one if there was no value attribute at all. optionSelect one And cfselect isn't used that way. You pass a query to it. I believe the minimum is below: cfselect name=field name query=query name value=field to be passed as value display=field to display /cfselect You can also add required and message as with cfinput. That said, javascript validation has never worked on cfselect for me. I hate cfselect also. But I do use cfform quite a bit. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ http://www.cf-ezcart.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Flash detector
A friend wanted me to see if anyone here had a bullet proof flash detection script. Some thing that checks to see what version of flash they have and then show an image or the flash file. Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MedSeek
Hmm. I thought that I was a developer. Lets see, I develope applications, I have the title of developer, I am paid as a developer, so I guess I am a developer. Oh yeah, and there were four other developers AND our manager in the presentation, and we are all of the same opinion. Also, how is it that my opinion is biased? I do NOT work for MedSeek. I have been evaluating CMS applications for a while now, so I think that my opinion is qualified and unbiased. This is all I have to say. Bruce From: Dowdell, Jason G [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: MedSeek Date: Thu, 27 Mar 2003 08:36:36 -0500 If you want a fully qualified opinion from a developer's perspective you should contact James Ang. He works there as a developer and will give you an unbiased opinion of the product. Email me offlist if you want his email addr. ~Jason -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 10:30 PM To: CF-Talk Subject: Re: MedSeek They came and did a dog and pony show for us (Baylor Health Care System, Dallas TX) of their CMS. It is over 165K. Pretty pricy considering that you can order Ektron's Empower CMS for under 20K, and that includes all the open source code. In fact, Medseek is using Ektron's WYSIWYG editor for their product. Understand though that we are just looking for a CMS that we can incorporate into our portal. HTH, Bruce - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 9:17 AM Subject: MedSeek Has anyone heard of or used MedSeek or MedSeek's sitemaker? If so, what comments do you have on it? We are trying to determine if this is a better fit for us than CommonSpot. TIA Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MedSeek
If you want a fully qualified opinion from a developer's perspective you should contact James Ang. He works there as a developer and will give you an unbiased opinion of the product. Hmm...I don't know James, but i'd bet he'd be the first to freely admit that precisely due to the fact that he *does* work there, his opinion is far from unbiased :) charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFSELECT (I hate CFFORM)
The required checking for cfselect for a size of 1 has never worked. I wonder if they fixed it in CFMX. And you can place option tags within cfselect/cfselect, in addition to or without a query. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] Date: Thursday, March 27, 2003 9:27 am Subject: Re: CFSELECT (I hate CFFORM) Actually Bud it doesn't work with no value attribute either (I tried it every way possible). Anyways, thanks for the responseI rolled a custom solution to get around CFSELECT and it's dark dark evilness ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 5:16 PM Subject: Re: CFSELECT (I hate CFFORM) On 3/26/03, Bryan Stevenson penned: I'm using IE and I know IE would consider the text Select one as the selection when the option value is left blank as I'm doing. I tried removing the Select one text and it still didn't catch the lack of selection!! It shouldn't. If it does it's broke. It should only recognize Select one if there was no value attribute at all. optionSelect one And cfselect isn't used that way. You pass a query to it. I believe the minimum is below: cfselect name=field name query=query name value=field to be passed as value display=field to display /cfselect You can also add required and message as with cfinput. That said, javascript validation has never worked on cfselect for me. I hate cfselect also. But I do use cfform quite a bit. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ http://www.cf-ezcart.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Nested Query Loop Bug/Issue
I don't know if any of you have run into this before or if it's even been mentioned (couldn't find it at mm technotes either), but I've run into a situation where the values of an outer loop referred to in an inner loop are not what you expect. I was burned on this recently and remember vaguely it happening to me before. I've written some demonstration code to illustrate: http://www.simplemessageboard.com/loopbug.cfm The solution as shown in the code is to set a local variable BEFORE you begin the inner loop to hold the value of the outer loop you want to refer to within the inner loop. Anyone had this happen? Or is this expected behavior that I can't see? BTW, this is CF5, I don't know about MX. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFSELECT (I hate CFFORM)
This is CFMX and no it doesn't work.grr ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 9:00 AM Subject: Re: CFSELECT (I hate CFFORM) The required checking for cfselect for a size of 1 has never worked. I wonder if they fixed it in CFMX. And you can place option tags within cfselect/cfselect, in addition to or without a query. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] Date: Thursday, March 27, 2003 9:27 am Subject: Re: CFSELECT (I hate CFFORM) Actually Bud it doesn't work with no value attribute either (I tried it every way possible). Anyways, thanks for the responseI rolled a custom solution to get around CFSELECT and it's dark dark evilness ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 5:16 PM Subject: Re: CFSELECT (I hate CFFORM) On 3/26/03, Bryan Stevenson penned: I'm using IE and I know IE would consider the text Select one as the selection when the option value is left blank as I'm doing. I tried removing the Select one text and it still didn't catch the lack of selection!! It shouldn't. If it does it's broke. It should only recognize Select one if there was no value attribute at all. optionSelect one And cfselect isn't used that way. You pass a query to it. I believe the minimum is below: cfselect name=field name query=query name value=field to be passed as value display=field to display /cfselect You can also add required and message as with cfinput. That said, javascript validation has never worked on cfselect for me. I hate cfselect also. But I do use cfform quite a bit. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ http://www.cf-ezcart.com/ 954.721.3452 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DB Driven Collapsable Tree
I'm looking for a tree structure that can be expanded and collapsed much like Windows Explorer. It needs to be built from my DB tree structure I already have setup. It has to work on IE and NS4. Any ideas? I assume either Javascript or DHTML will do and I'm sure this has been discussed before. Any suggestions? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DB Driven Collapsable Tree
I used Tigra Menu (www.softcomplex.com) I used it with a SQL DB to populate all elements. [EMAIL PROTECTED] 03/27/03 12:08PM I'm looking for a tree structure that can be expanded and collapsed much like Windows Explorer. It needs to be built from my DB tree structure I already have setup. It has to work on IE and NS4. Any ideas? I assume either Javascript or DHTML will do and I'm sure this has been discussed before. Any suggestions? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Nested Query Loop Bug/Issue
I have seen it before, not sure why it happens but what I did to solve it was set a temp variable to hold the first element of the query and reset it when it changes. cfset tempvar = '' cfoutput query=myQuery cfif tempvar NEQ myQuery.Value1 cfset tempvar = myQuery.Value1 /cfif ... [EMAIL PROTECTED] 03/27/03 12:04PM I don't know if any of you have run into this before or if it's even been mentioned (couldn't find it at mm technotes either), but I've run into a situation where the values of an outer loop referred to in an inner loop are not what you expect. I was burned on this recently and remember vaguely it happening to me before. I've written some demonstration code to illustrate: http://www.simplemessageboard.com/loopbug.cfm The solution as shown in the code is to set a local variable BEFORE you begin the inner loop to hold the value of the outer loop you want to refer to within the inner loop. Anyone had this happen? Or is this expected behavior that I can't see? BTW, this is CF5, I don't know about MX. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DB Driven Collapsable Tree
Take a look at the menus available at DHTMLCentral.com They work great in those browsers. You'll have to make them data-driven, but it's not that hard (just some queries and loops). Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Cedric Villat [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 9:08 AM Subject: DB Driven Collapsable Tree I'm looking for a tree structure that can be expanded and collapsed much like Windows Explorer. It needs to be built from my DB tree structure I already have setup. It has to work on IE and NS4. Any ideas? I assume either Javascript or DHTML will do and I'm sure this has been discussed before. Any suggestions? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DB Driven Collapsable Tree
note that Tigra Menus do not support Netscape 4.x browsersthe one at DHTMLCentral does...and it's easily as flexible as Tigra ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 9:09 AM Subject: Re: DB Driven Collapsable Tree I used Tigra Menu (www.softcomplex.com) I used it with a SQL DB to populate all elements. [EMAIL PROTECTED] 03/27/03 12:08PM I'm looking for a tree structure that can be expanded and collapsed much like Windows Explorer. It needs to be built from my DB tree structure I already have setup. It has to work on IE and NS4. Any ideas? I assume either Javascript or DHTML will do and I'm sure this has been discussed before. Any suggestions? Cedric ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Nested Query Loop Bug/Issue
On each loop, whatever values you want to use in your inner loops need to be set to a local variable in the loop. In fact, been burned so many times now I just dont bother using the loop count and alwasy set the variables I need straight after my cfloop ie cfloop query=qSomething cfset loop1Col1 = qSomething.MultiplyBy20 cfset loop1Col2 = qSomething.MultiplyBy30 cfloop from=1 to=100 index=tIndex cfset output1 = loop1Col1 * tIndex cfset output2 = loop1Col2 * tIndex cfoutput#tIndex# - #output1# - #output2#/cfoutput /cfloop /cfloop Trying to access it as... cfset output1 = qSomething.MultiplyBy20 * tIndex Doesn't work (well, i didn't test the code but I hope you get my drift) There is a tech support somewhere about this on the MM site but I can't find much (no patience with it) any more and prefer looking elsewhere This could be described as a FEATURE of cold fusionhehehehe -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 17:04 To: CF-Talk Subject: Nested Query Loop Bug/Issue I don't know if any of you have run into this before or if it's even been mentioned (couldn't find it at mm technotes either), but I've run into a situation where the values of an outer loop referred to in an inner loop are not what you expect. I was burned on this recently and remember vaguely it happening to me before. I've written some demonstration code to illustrate: http://www.simplemessageboard.com/loopbug.cfm The solution as shown in the code is to set a local variable BEFORE you begin the inner loop to hold the value of the outer loop you want to refer to within the inner loop. Anyone had this happen? Or is this expected behavior that I can't see? BTW, this is CF5, I don't know about MX. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Nested Query Loop Bug/Issue
That's basically what the example variable in my demo code does - you have to set it outside of the inner loop. So is this a confirmed bug or anything? I have seen it before, not sure why it happens but what I did to solve it was set a temp variable to hold the first element of the query and reset it when it changes. cfset tempvar = '' cfoutput query=myQuery cfif tempvar NEQ myQuery.Value1 cfset tempvar = myQuery.Value1 /cfif ... [EMAIL PROTECTED] 03/27/03 12:04PM I don't know if any of you have run into this before or if it's even been mentioned (couldn't find it at mm technotes either), but I've run into a situation where the values of an outer loop referred to in an inner loop are not what you expect. I was burned on this recently and remember vaguely it happening to me before. I've written some demonstration code to illustrate: http://www.simplemessageboard.com/loopbug.cfm The solution as shown in the code is to set a local variable BEFORE you begin the inner loop to hold the value of the outer loop you want to refer to within the inner loop. Anyone had this happen? Or is this expected behavior that I can't see? BTW, this is CF5, I don't know about MX. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cache-control: no-cache
What exactly does the set-cookie portion allow for? My guess would be that it allows cookies to come thru okay, but that seems to be happening even with the CFHEADER code in my original message. Could you explain the set-cookie portion a little better and how it would be implimented with CFHeader? like this... CFHEADER Name=Cache-control Value=no-cache:set-cookie,set-cookie2 is that what you're talking about? thanks for the help. . . . . . .joe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DB and input
Hi, Why is this happening? I'm reading in fields from my database and dumpping them to input tags so that I can edit the lines if required and by clicking on a submit button saves the revised data fields back to my DB. If I put the cursor in a field to edit and hit the backspace to delete the characters it takes me to the previous screen. Why? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DB and input
ALT key stuck? (Oh, sorry, that's ALT-LeftArrow - in IE anyway...) If I put the cursor in a field to edit and hit the backspace to delete the characters it takes me to the previous screen. Why? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Flash detector
typically moock.org has the best advanced scripts like that... I think specifically - http://www.moock.org/asdg/ actionscript-toolbox.com has very solid code samples too but a simple google search will turn up lots. jay miller Phillip B wrote: A friend wanted me to see if anyone here had a bullet proof flash detection script. Some thing that checks to see what version of flash they have and then show an image or the flash file. Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DB and input
Some code and an explanation of what yer doing would be handy ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 9:42 AM Subject: DB and input Hi, Why is this happening? I'm reading in fields from my database and dumpping them to input tags so that I can edit the lines if required and by clicking on a submit button saves the revised data fields back to my DB. If I put the cursor in a field to edit and hit the backspace to delete the characters it takes me to the previous screen. Why? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(SOT) Oops, I've broken it.
Hi all - I'm following Macromedia's instructions to set up a secure FTP connection with PuTTY and PLink in Dreamweaver MX. Anyway, in the Site Definition dialog, I set the SSH checkbox (Advanced Tab Remote Info Access: FTP Use SSH ...), and got a pop-up reminding me I had to download the aforementioned tools. I already had them in the appropriate directory, and checked the don't remind me again box... now I can't check the SSH box anymore. Is this just a bug, or is there a config file someplace deep in DWMX's Configuration folders that I can edit to let me check the SSH box? Muchas Gracias, - Jim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Does anyone know where this error is generated?
Ocassionally our CF service restarts, and when it does, IIS generates the following message: == Error Occurred While Processing Request Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) == What I'm looking for is a way to replace this message with one of my own, or even a javascript redirect to somewhere else. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Flash detector
The closest one that I have to found to perfect is: SCRIPT language=VBScript Private i, x, MM_FlashControlVersion On Error Resume Next x = null MM_FlashControlVersion = 0 var Flashmode FlashMode = False For i = 9 To 1 Step -1 Set x = CreateObject(ShockwaveFlash.ShockwaveFlash. i) MM_FlashControlInstalled = IsObject(x) If MM_FlashControlInstalled Then MM_FlashControlVersion = CStr(i) Exit For End If Next FlashMode = (MM_FlashControlVersion 5) If FlashMode = True Then document.write flash object goes here Else document.write You need to download flash End If /SCRIPT Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:01 PM To: CF-Talk Subject: Re: OT: Flash detector typically moock.org has the best advanced scripts like that... I think specifically - http://www.moock.org/asdg/ actionscript-toolbox.com has very solid code samples too but a simple google search will turn up lots. jay miller Phillip B wrote: A friend wanted me to see if anyone here had a bullet proof flash detection script. Some thing that checks to see what version of flash they have and then show an image or the flash file. Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does anyone know where this error is generated?
Use CFTRY/CATCH wrapped around the whole page. If that error happens then display a nicer message. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Calvin Ward [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 10:05 AM Subject: Does anyone know where this error is generated? Ocassionally our CF service restarts, and when it does, IIS generates the following message: == Error Occurred While Processing Request Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) == What I'm looking for is a way to replace this message with one of my own, or even a javascript redirect to somewhere else. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB and input
It's almost certainly a browser issue. What browser, version, and OS? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 27, 2003 12:43 PM : To: CF-Talk : Subject: DB and input : : : Hi, : : Why is this happening? I'm reading in fields from my database and : dumpping them to input tags so that I can edit the lines if : required and by clicking on a submit button saves : the revised data fields back to my DB. : : If I put the cursor in a field to edit and hit the backspace to : delete the characters it takes me to the previous screen. Why? : : : --- : Colonel Nathan R. Jessop : Commanding Officer : Marine Ground Forces : Guatanamo Bay, Cuba : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Does anyone know where this error is generated?
a custom error template is good...cferror tag...but you should probably figure out why this is occuring. What version of CF are you using? Using Access DBs anywhere? Check your logs in the CFADMIN tool for long running requests. Something is holding up cfserver threads somewhere it seems. Doug -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:06 PM To: CF-Talk Subject: Does anyone know where this error is generated? Ocassionally our CF service restarts, and when it does, IIS generates the following message: == Error Occurred While Processing Request Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) == What I'm looking for is a way to replace this message with one of my own, or even a javascript redirect to somewhere else. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB and input
I found the problem. Improperly placed form tag. Dawg! On Thu, 27 Mar 2003 13:19:49 -0500, Ben Doom wrote: It's almost certainly a browser issue. What browser, version, and OS? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 27, 2003 12:43 PM : To: CF-Talk : Subject: DB and input : : : Hi, : : Why is this happening? I'm reading in fields from my database and : dumpping them to input tags so that I can edit the lines if : required and by clicking on a submit button saves : the revised data fields back to my DB. : : If I put the cursor in a field to edit and hit the backspace to : delete the characters it takes me to the previous screen. Why? : : : --- : Colonel Nathan R. Jessop : Commanding Officer : Marine Ground Forces : Guatanamo Bay, Cuba : --- : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: iframes
If you haven't disabled it...triple clicking will select all text in a text area. One click puts cursor at moust pointer. Two clicks selects entire word (white space to white space) Three clicks selects entire content of text area box. At least in IE 6 on win XP. I do this all the time in a content management form I've worked up. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 4:03 AM To: CF-Talk Subject: RE: iframes Yes...I have some JS that disables this features. On Tue, 25 Mar 2003 12:08:20 -0800, Barney Boisvert wrote: You should be able to use the mouse to select it. Or hit CTRL-A to select all. If you can't then something's screwy. Do you perhaps have a JS function that's capturing mouse events for some other purpose? --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.671.8708 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 11:53 AM To: CF-Talk Subject: RE: iframes Hmm...if I type in a large paragprah and I want to delete all of it whats the easiest way? I can't hilight it with the curser. The only way is to backspace all the text. I bit of a pain... On Tue, 25 Mar 2003 14:47:24 -0500, FlashGuy wrote: OK...thanks On Tue, 25 Mar 2003 11:37:16 -0800, Barney Boisvert wrote: An IFRAME is just like a normal frame, except that you can put it inside a normal page. It's not a text input field. TEXTAREA is the beast you're looking for. textarea name=solution cols=30 rows=6 wrap=virtual style=width:600px;height:80px;Key in information here.../textarea --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.671.8708 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 11:24 AM To: CF-Talk Subject: Re: iframes Hi, I'm trying to create a larger input area for the user to key in information. This is what I have using an iframe but I can't seem to be able to input any information with the box? Is there another way of doing this? table cellpadding=0 cellspacing=0 border=0 tr td iframe name=solution id=problem width=600 height=80 marginwidth=8 marginheight=8 align=top scrolling=yes frameborder=0 Key in information here... /iframe /td /tr /table --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MedSeek
Quit your whining and develop some applications. This is petty. ~Jason -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 12:03 PM To: CF-Talk Subject: Re: MedSeek If you want a fully qualified opinion from a developer's perspective you should contact James Ang. He works there as a developer and will give you an unbiased opinion of the product. Hmm...I don't know James, but i'd bet he'd be the first to freely admit that precisely due to the fact that he *does* work there, his opinion is far from unbiased :) charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MedSeek
My post was not to insult anyone's status as a developer. But merely to give an inside story from a developer that has worked on the application in question. ~Jason -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 11:54 AM To: CF-Talk Subject: RE: MedSeek Hmm. I thought that I was a developer. Lets see, I develope applications, I have the title of developer, I am paid as a developer, so I guess I am a developer. Oh yeah, and there were four other developers AND our manager in the presentation, and we are all of the same opinion. Also, how is it that my opinion is biased? I do NOT work for MedSeek. I have been evaluating CMS applications for a while now, so I think that my opinion is qualified and unbiased. This is all I have to say. Bruce From: Dowdell, Jason G [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: MedSeek Date: Thu, 27 Mar 2003 08:36:36 -0500 If you want a fully qualified opinion from a developer's perspective you should contact James Ang. He works there as a developer and will give you an unbiased opinion of the product. Email me offlist if you want his email addr. ~Jason -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 10:30 PM To: CF-Talk Subject: Re: MedSeek They came and did a dog and pony show for us (Baylor Health Care System, Dallas TX) of their CMS. It is over 165K. Pretty pricy considering that you can order Ektron's Empower CMS for under 20K, and that includes all the open source code. In fact, Medseek is using Ektron's WYSIWYG editor for their product. Understand though that we are just looking for a CMS that we can incorporate into our portal. HTH, Bruce - Original Message - From: Candace Cottrell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 9:17 AM Subject: MedSeek Has anyone heard of or used MedSeek or MedSeek's sitemaker? If so, what comments do you have on it? We are trying to determine if this is a better fit for us than CommonSpot. TIA Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
is email-adress wrong ?
It might have been asked before, but is there a fast AND free custom-tag (CF-routine) to check if an email adress is syntactically wrong ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: is email-adress wrong ?
Yup http://www.cflib.org/udf.cfm?ID=216 Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:29 PM To: CF-Talk Subject: is email-adress wrong ? It might have been asked before, but is there a fast AND free custom-tag (CF-routine) to check if an email adress is syntactically wrong ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is email-adress wrong ?
There is a UDF at cflib.org called IsEmail() I believe (if you're using CF 5 or newer).if not...there are tonnes of e-mial validating tagsgot o MM DevEx Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 10:29 AM Subject: is email-adress wrong ? It might have been asked before, but is there a fast AND free custom-tag (CF-routine) to check if an email adress is syntactically wrong ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Application security structure
Running CFMX Okay, this is a very basic question for alot of you, but one that gives me pause everytime it comes up. I am developing a large application-level web site that will house several smaller applications inside of it. I am using application and user-groups defined roles for each user to limit their access to whatever I want them to see. This all works great. Here is my problem: 1. The appliation.cfm loads with every page request. 2. If there is no Session.Auth structure, it makes one. 3. The session scope for the application tag in my application.cfm is set to timeout after 20 minutes. 4. If the browser has had no activity for the prescribed length of time, the user on the next page request should be prompted to log in again. 5. I cannot figuire out how to redirect the user by using code on the application.cfm to do this. Sort of like the following: cfif not isdefined(session.Auth) cfset session.Auth = structNew() cfset session.Auth.UserID = 0 cfset session.Auth.LoginAttempts = 0 cfset session.Auth.AppList = cfelse cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif /cfif This should be very easy, but I just cant get my head around it. I keep getting the million-page-loading problem. Any thoughts. :-) John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MedSeek
My apologies to Charlie for calling him whiney sp? Thanks to all for ignoring this OT thread. ~Jason -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:25 PM To: CF-Talk Subject: RE: MedSeek Quit your whining and develop some applications. This is petty. ~Jason -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 12:03 PM To: CF-Talk Subject: Re: MedSeek If you want a fully qualified opinion from a developer's perspective you should contact James Ang. He works there as a developer and will give you an unbiased opinion of the product. Hmm...I don't know James, but i'd bet he'd be the first to freely admit that precisely due to the fact that he *does* work there, his opinion is far from unbiased :) charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application security structure
You pretty much have it. Change this: cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif Into this: cfif session.Auth.UserID eq 0 and FindNoCase('int.cfm',Script_Name) script document.location=int.cfm /script /cfif Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:40 PM To: CF-Talk Subject: Application security structure Running CFMX Okay, this is a very basic question for alot of you, but one that gives me pause everytime it comes up. I am developing a large application-level web site that will house several smaller applications inside of it. I am using application and user-groups defined roles for each user to limit their access to whatever I want them to see. This all works great. Here is my problem: 1. The appliation.cfm loads with every page request. 2. If there is no Session.Auth structure, it makes one. 3. The session scope for the application tag in my application.cfm is set to timeout after 20 minutes. 4. If the browser has had no activity for the prescribed length of time, the user on the next page request should be prompted to log in again. 5. I cannot figuire out how to redirect the user by using code on the application.cfm to do this. Sort of like the following: cfif not isdefined(session.Auth) cfset session.Auth = structNew() cfset session.Auth.UserID = 0 cfset session.Auth.LoginAttempts = 0 cfset session.Auth.AppList = cfelse cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif /cfif This should be very easy, but I just cant get my head around it. I keep getting the million-page-loading problem. Any thoughts. :-) John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is email-adress wrong ?
You can use cfinput type=Text name=email validate=regular_expression pattern=([[:alnum:]_\.\-]+@([[:alnum:]_\.\-]+\.)+[[:alpha:]]+) required=yes David Murphy www.cfugcny.org = = = Original message = = = There is a UDF at cflib.org called IsEmail() I believe (if you're using CF 5 or newer).if not...there are tonnes of e-mial validating tagsgot o MM DevEx Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 10:29 AM Subject: is email-adress wrong ? It might have been asked before, but is there a fast AND free custom-tag (CF-routine) to check if an email adress is syntactically wrong ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application security structure
P.S. It should be: cfif session.Auth.UserID eq 0 and not FindNoCase('init.cfm',Script_Name) Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:40 PM To: CF-Talk Subject: Application security structure Running CFMX Okay, this is a very basic question for alot of you, but one that gives me pause everytime it comes up. I am developing a large application-level web site that will house several smaller applications inside of it. I am using application and user-groups defined roles for each user to limit their access to whatever I want them to see. This all works great. Here is my problem: 1. The appliation.cfm loads with every page request. 2. If there is no Session.Auth structure, it makes one. 3. The session scope for the application tag in my application.cfm is set to timeout after 20 minutes. 4. If the browser has had no activity for the prescribed length of time, the user on the next page request should be prompted to log in again. 5. I cannot figuire out how to redirect the user by using code on the application.cfm to do this. Sort of like the following: cfif not isdefined(session.Auth) cfset session.Auth = structNew() cfset session.Auth.UserID = 0 cfset session.Auth.LoginAttempts = 0 cfset session.Auth.AppList = cfelse cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif /cfif This should be very easy, but I just cant get my head around it. I keep getting the million-page-loading problem. Any thoughts. :-) John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application security structure
You have to make an exception for the login page, else it keeps trying to redirect from the login page to the login page. You should also put a redirect at the bottom of the code block that handles creating the session variables, because if there is no autorization stored in session, then the user isn't logged in by definition. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: John Stanley [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 27, 2003 1:40 PM : To: CF-Talk : Subject: Application security structure : : : Running CFMX : : Okay, this is a very basic question for alot of you, but one that gives me : pause everytime it comes up. : : I am developing a large application-level web site that will house several : smaller applications inside of it. I am using application and user-groups : defined roles for each user to limit their access to whatever I : want them to : see. This all works great. : : Here is my problem: : 1. The appliation.cfm loads with every page request. : 2. If there is no Session.Auth structure, it makes one. : 3. The session scope for the application tag in my : application.cfm is set to : timeout after 20 minutes. : 4. If the browser has had no activity for the prescribed length : of time, the : user on the next page request should be prompted to log in again. : 5. I cannot figuire out how to redirect the user by using code on the : application.cfm to do this. Sort of like the following: : : cfif not isdefined(session.Auth) : cfset session.Auth = structNew() : cfset session.Auth.UserID = 0 : cfset session.Auth.LoginAttempts = 0 : cfset session.Auth.AppList = : cfelse : cfif session.Auth.UserID eq 0 : script : document.location=int.cfm : /script : /cfif : /cfif : : This should be very easy, but I just cant get my head around it. I keep : getting the million-page-loading problem. : : Any thoughts. : : :-) : : John : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cflogin and IIS Integrated Windows Security
I have a real simple login framework where I use the ntsecurity CFC I got from Macromedia to get a list of NT user groups of which a user is a member. By setting the directory security in IIS to integrated windows security and turning off Anonymous access, cgi.auth_user is populated with the domain and user id of the person who logged into the computer. I can then get their user groups. This all works well and fine. But I have a question about the password. The password parameter of the cfLogInUser tag is required. With integrated windows security, the cgi.Auth_Password seems to be an empty string if you output it. Is this going to be a problem, passing a possibly empty string to the password parameter of cfLogInUser? Is cgi.Auth_User not actually empty in this scenario? The code below works in testing, but I don't want it to become a problem under load with multiple users. Would it be better if I used some kind a random and/or unique string for a psedo password (maybe a UUID), since I don't know what the user typed to log into the computer? Ben Forta's ColdFusion MX: Web Application Construction Kit book says The password that the user logs in with. This is used internally by ColdFusion to track the user's login status. I would appreciate any insights on this from the guru's, Macromedia insiders, and other experts. Thanks. cflogin cfinvoke component = NTSecurity method = getUserGroups domain = #ListFirst(cgi.AUTH_USER,'\')# userid = #ListLast(cgi.AUTH_USER,'\')# returnVariable = GetUsers cfloginuser name=#ListLast(cgi.AUTH_USER,'\')# password=#cgi.AUTH_PASSWORD# roles=#replace(GetUsers,' ','','ALL')# /cflogin -- Ian Skinner Web Programmer BloodSource Sacramento, CA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Application security structure -- ADDENDUM
I dont know if this matters, but the default page for this site is int.cfm which is a frame page that calls the page content.cfm. this page checks to see whether the user has successfully logged in, and then directs them to the correct page. -Original Message- From: John Stanley Sent: Thursday, March 27, 2003 1:40 PM To: CF-Talk Subject: Application security structure Running CFMX Okay, this is a very basic question for alot of you, but one that gives me pause everytime it comes up. I am developing a large application-level web site that will house several smaller applications inside of it. I am using application and user-groups defined roles for each user to limit their access to whatever I want them to see. This all works great. Here is my problem: 1. The appliation.cfm loads with every page request. 2. If there is no Session.Auth structure, it makes one. 3. The session scope for the application tag in my application.cfm is set to timeout after 20 minutes. 4. If the browser has had no activity for the prescribed length of time, the user on the next page request should be prompted to log in again. 5. I cannot figuire out how to redirect the user by using code on the application.cfm to do this. Sort of like the following: cfif not isdefined(session.Auth) cfset session.Auth = structNew() cfset session.Auth.UserID = 0 cfset session.Auth.LoginAttempts = 0 cfset session.Auth.AppList = cfelse cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif /cfif This should be very easy, but I just cant get my head around it. I keep getting the million-page-loading problem. Any thoughts. :-) John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application security structure
You need to check to see if the user is being redirected to that page. If they are, then they should skip the authentication. cfif not isDefined(session.Auth) and listLast(cgi.path_info, /) neq int.cfm - Original Message - From: John Stanley [EMAIL PROTECTED] Date: Thursday, March 27, 2003 11:39 am Subject: Application security structure Running CFMX Okay, this is a very basic question for alot of you, but one that gives me pause everytime it comes up. I am developing a large application-level web site that will house severalsmaller applications inside of it. I am using application and user-groups defined roles for each user to limit their access to whatever I want them to see. This all works great. Here is my problem: 1. The appliation.cfm loads with every page request. 2. If there is no Session.Auth structure, it makes one. 3. The session scope for the application tag in my application.cfm is set to timeout after 20 minutes. 4. If the browser has had no activity for the prescribed length of time, the user on the next page request should be prompted to log in again. 5. I cannot figuire out how to redirect the user by using code on the application.cfm to do this. Sort of like the following: cfif not isdefined(session.Auth) cfset session.Auth = structNew() cfset session.Auth.UserID = 0 cfset session.Auth.LoginAttempts = 0 cfset session.Auth.AppList = cfelse cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif /cfif This should be very easy, but I just cant get my head around it. I keepgetting the million-page-loading problem. Any thoughts. :-) John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Nested Query Loop Bug/Issue
This issue has been around since v4.x. :P The workaround mentioned is *the* workaround. Confirmed bug or not? Not sure. Most developers just use the workaround. :D --- James Ang Sr. Developer/Product Engineer MedSeek, Inc. [EMAIL PROTECTED] -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 9:18 AM To: CF-Talk Subject: Re: Nested Query Loop Bug/Issue That's basically what the example variable in my demo code does - you have to set it outside of the inner loop. So is this a confirmed bug or anything? I have seen it before, not sure why it happens but what I did to solve it was set a temp variable to hold the first element of the query and reset it when it changes. cfset tempvar = '' cfoutput query=myQuery cfif tempvar NEQ myQuery.Value1 cfset tempvar = myQuery.Value1 /cfif ... [EMAIL PROTECTED] 03/27/03 12:04PM I don't know if any of you have run into this before or if it's even been mentioned (couldn't find it at mm technotes either), but I've run into a situation where the values of an outer loop referred to in an inner loop are not what you expect. I was burned on this recently and remember vaguely it happening to me before. I've written some demonstration code to illustrate: http://www.simplemessageboard.com/loopbug.cfm The solution as shown in the code is to set a local variable BEFORE you begin the inner loop to hold the value of the outer loop you want to refer to within the inner loop. Anyone had this happen? Or is this expected behavior that I can't see? BTW, this is CF5, I don't know about MX. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: is email-adress wrong ?
CFFORM is the Devil ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 10:46 AM Subject: Re: is email-adress wrong ? You can use cfinput type=Text name=email validate=regular_expression pattern=([[:alnum:]_\.\-]+@([[:alnum:]_\.\-]+\.)+[[:alpha:]]+) required=yes David Murphy www.cfugcny.org = = = Original message = = = There is a UDF at cflib.org called IsEmail() I believe (if you're using CF 5 or newer).if not...there are tonnes of e-mial validating tagsgot o MM DevEx Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 10:29 AM Subject: is email-adress wrong ? It might have been asked before, but is there a fast AND free custom-tag (CF-routine) to check if an email adress is syntactically wrong ? Uwe ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does anyone know where this error is generated?
Douglas, We're working on resolving unlocked session variables, as well as other known causes (culled from various sources), and there aren't any Access DBs on our servers, all SQL2000 and Oracle. This is definitely a priority. In the meantime, we'd like to present a prettier face to the user. I don't believe that ColdFusion code will resolve that, as the error seems to also be generated during server restart or being down. In fact, I copied and pasted the below text from a browser trying to hit our dev server after we manually stopped the service. I was under the impression that it was actually generated through IIS and not CF. Anyone have further thoughts? - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:21 PM Subject: RE: Does anyone know where this error is generated? a custom error template is good...cferror tag...but you should probably figure out why this is occuring. What version of CF are you using? Using Access DBs anywhere? Check your logs in the CFADMIN tool for long running requests. Something is holding up cfserver threads somewhere it seems. Doug -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:06 PM To: CF-Talk Subject: Does anyone know where this error is generated? Ocassionally our CF service restarts, and when it does, IIS generates the following message: == Error Occurred While Processing Request Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) == What I'm looking for is a way to replace this message with one of my own, or even a javascript redirect to somewhere else. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does anyone know where this error is generated?
The message is from CF, not IIS. If you've stopped the CF service, if you try to request a .cfm page, this error will appear. If this is a priority, fix your session variable locking. - Original Message - From: Calvin Ward [EMAIL PROTECTED] Date: Thursday, March 27, 2003 12:04 pm Subject: Re: Does anyone know where this error is generated? Douglas, We're working on resolving unlocked session variables, as well as otherknown causes (culled from various sources), and there aren't any Access DBs on our servers, all SQL2000 and Oracle. This is definitely a priority. In the meantime, we'd like to present a prettier face to the user. I don't believe that ColdFusion code will resolve that, as the error seems to also be generated during server restart or being down. In fact, I copied and pasted the below text from a browser trying to hit our dev server after we manually stopped the service. I was under the impression that it was actually generated through IIS and not CF. Anyone have further thoughts? - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:21 PM Subject: RE: Does anyone know where this error is generated? a custom error template is good...cferror tag...but you should probablyfigure out why this is occuring. What version of CF are you using? Using Access DBs anywhere? Check your logs in the CFADMIN tool for long runningrequests. Something is holding up cfserver threads somewhere it seems. Doug -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:06 PM To: CF-Talk Subject: Does anyone know where this error is generated? Ocassionally our CF service restarts, and when it does, IIS generates the following message: == Error Occurred While Processing Request Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) == What I'm looking for is a way to replace this message with one of my own, or even a javascript redirect to somewhere else. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Does anyone know where this error is generated?
Ah...I see... CF has a great error trapping schtuff you can use, but it is useless for server timeout stuff in my experience. I know unlocked vars can cause wierd stuff, but I have found long running SQL to be a culprit quite often too. Have you guys looked at upping the request timeout setting? perhaps raise the limit simultaneous requests setting? Have restart after n unresponsive threads on and all...lower this. Have you tried setting the locking to single threaded sessions? Sounds like you are looking at this stuff already. Filter for 'Warning' and 'Information' severity in your application log via the CFADMIN tool. This will show you all the long running requests, if you set the logs to log them that is. It will also show when CF labels a thread unresponsive. just my thoughts Doug -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:04 PM To: CF-Talk Subject: Re: Does anyone know where this error is generated? Douglas, We're working on resolving unlocked session variables, as well as other known causes (culled from various sources), and there aren't any Access DBs on our servers, all SQL2000 and Oracle. This is definitely a priority. In the meantime, we'd like to present a prettier face to the user. I don't believe that ColdFusion code will resolve that, as the error seems to also be generated during server restart or being down. In fact, I copied and pasted the below text from a browser trying to hit our dev server after we manually stopped the service. I was under the impression that it was actually generated through IIS and not CF. Anyone have further thoughts? - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:21 PM Subject: RE: Does anyone know where this error is generated? a custom error template is good...cferror tag...but you should probably figure out why this is occuring. What version of CF are you using? Using Access DBs anywhere? Check your logs in the CFADMIN tool for long running requests. Something is holding up cfserver threads somewhere it seems. Doug -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:06 PM To: CF-Talk Subject: Does anyone know where this error is generated? Ocassionally our CF service restarts, and when it does, IIS generates the following message: == Error Occurred While Processing Request Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) == What I'm looking for is a way to replace this message with one of my own, or even a javascript redirect to somewhere else. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: JSP and outputing cgi variables
*** Your mail has been scanned, and no virus was found. ***-*** Hello, Sorry for the OT post, I'm a JSP newbie and need to know how I would do cfoutput #cgi.server_name# /cfoutput on a JSP page? Thanks, Nate ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does anyone know where this error is generated?
Not to be dense, but if CF service is stopped, then how does it provide this response? We ARE fixing the session variable locking, but this message ALSO appears when CF Service restarts. I meant that the fixing of issues was a priority, in the MEANTIME we would like to present a prettier face to the user. There are a large number of sites here, so it takes some time to resolve all that. Still wondering - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:18 PM Subject: Re: Does anyone know where this error is generated? The message is from CF, not IIS. If you've stopped the CF service, if you try to request a .cfm page, this error will appear. If this is a priority, fix your session variable locking. - Original Message - From: Calvin Ward [EMAIL PROTECTED] Date: Thursday, March 27, 2003 12:04 pm Subject: Re: Does anyone know where this error is generated? Douglas, We're working on resolving unlocked session variables, as well as otherknown causes (culled from various sources), and there aren't any Access DBs on our servers, all SQL2000 and Oracle. This is definitely a priority. In the meantime, we'd like to present a prettier face to the user. I don't believe that ColdFusion code will resolve that, as the error seems to also be generated during server restart or being down. In fact, I copied and pasted the below text from a browser trying to hit our dev server after we manually stopped the service. I was under the impression that it was actually generated through IIS and not CF. Anyone have further thoughts? - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:21 PM Subject: RE: Does anyone know where this error is generated? a custom error template is good...cferror tag...but you should probablyfigure out why this is occuring. What version of CF are you using? Using Access DBs anywhere? Check your logs in the CFADMIN tool for long runningrequests. Something is holding up cfserver threads somewhere it seems. Doug -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:06 PM To: CF-Talk Subject: Does anyone know where this error is generated? Ocassionally our CF service restarts, and when it does, IIS generates the following message: == Error Occurred While Processing Request Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) == What I'm looking for is a way to replace this message with one of my own, or even a javascript redirect to somewhere else. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cffile vs. cfinclude
Here's some questions I have about cffile... maybe someone can help me out. 1. All I've been able find out about performance, is that extensive use of cffile will create a performance problem because of the slow nature of disk I/O. What is extensive? 2. As far as disk access is concerned, what's the difference between CF reading a file using cffile, and inculding one using cfinclude? 3. Which of the following (if either) is better? cffile action=read file=test.xml variable=foo -OR- cfsavecontent variable=foo cfinclude template=test.xml /cfsavecontent -Brad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SQL Name Sounds Like Matching
I have a feeling I am going to be working on this one for a while... One of my more demanding clients is asking for a name matching solution on the cheap. What it needs to do is find where a name 'sounds like' another name, even if it is in another language (including Middle Eastern and Oriental names). In addition, I need to be able to eliminate false positives wherever possible, in order to come up with the most consise list of matches. I really don't know where to start. SQL Server and Oracle both offer soundex support, which I suppose could be used to generate some values for comparisons. But I am not sure how this would work when different languages come into play. Does anyone have / know of any books / resources / advice on how to do this? M ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Does anyone know where this error is generated?
The message is from CF, not IIS. If you've stopped the CF service, if you try to request a .cfm page, this error will appear. This isn't exactly the case. The message is from the CF ISAPI extension, and to the best of my knowledge there's no way to change it in CF 5. In CFMX with Updater 3, however, I imagine that you may be able to change it if you're using Apache instead of IIS, since I believe that the source for the Apache module is provided with Updater 3. No such luck with IIS, though, I'll bet. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application security structure
thanks for your help -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:54 PM To: CF-Talk Subject: Re: Application security structure You need to check to see if the user is being redirected to that page. If they are, then they should skip the authentication. cfif not isDefined(session.Auth) and listLast(cgi.path_info, /) neq int.cfm - Original Message - From: John Stanley [EMAIL PROTECTED] Date: Thursday, March 27, 2003 11:39 am Subject: Application security structure Running CFMX Okay, this is a very basic question for alot of you, but one that gives me pause everytime it comes up. I am developing a large application-level web site that will house severalsmaller applications inside of it. I am using application and user-groups defined roles for each user to limit their access to whatever I want them to see. This all works great. Here is my problem: 1. The appliation.cfm loads with every page request. 2. If there is no Session.Auth structure, it makes one. 3. The session scope for the application tag in my application.cfm is set to timeout after 20 minutes. 4. If the browser has had no activity for the prescribed length of time, the user on the next page request should be prompted to log in again. 5. I cannot figuire out how to redirect the user by using code on the application.cfm to do this. Sort of like the following: cfif not isdefined(session.Auth) cfset session.Auth = structNew() cfset session.Auth.UserID = 0 cfset session.Auth.LoginAttempts = 0 cfset session.Auth.AppList = cfelse cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif /cfif This should be very easy, but I just cant get my head around it. I keepgetting the million-page-loading problem. Any thoughts. :-) John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application security structure
bryan, thanks for your help -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:46 PM To: CF-Talk Subject: RE: Application security structure P.S. It should be: cfif session.Auth.UserID eq 0 and not FindNoCase('init.cfm',Script_Name) Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:40 PM To: CF-Talk Subject: Application security structure Running CFMX Okay, this is a very basic question for alot of you, but one that gives me pause everytime it comes up. I am developing a large application-level web site that will house several smaller applications inside of it. I am using application and user-groups defined roles for each user to limit their access to whatever I want them to see. This all works great. Here is my problem: 1. The appliation.cfm loads with every page request. 2. If there is no Session.Auth structure, it makes one. 3. The session scope for the application tag in my application.cfm is set to timeout after 20 minutes. 4. If the browser has had no activity for the prescribed length of time, the user on the next page request should be prompted to log in again. 5. I cannot figuire out how to redirect the user by using code on the application.cfm to do this. Sort of like the following: cfif not isdefined(session.Auth) cfset session.Auth = structNew() cfset session.Auth.UserID = 0 cfset session.Auth.LoginAttempts = 0 cfset session.Auth.AppList = cfelse cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif /cfif This should be very easy, but I just cant get my head around it. I keep getting the million-page-loading problem. Any thoughts. :-) John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application security structure
ben, thanks for your help -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:49 PM To: CF-Talk Subject: RE: Application security structure You have to make an exception for the login page, else it keeps trying to redirect from the login page to the login page. You should also put a redirect at the bottom of the code block that handles creating the session variables, because if there is no autorization stored in session, then the user isn't logged in by definition. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: John Stanley [mailto:[EMAIL PROTECTED] : Sent: Thursday, March 27, 2003 1:40 PM : To: CF-Talk : Subject: Application security structure : : : Running CFMX : : Okay, this is a very basic question for alot of you, but one that gives me : pause everytime it comes up. : : I am developing a large application-level web site that will house several : smaller applications inside of it. I am using application and user-groups : defined roles for each user to limit their access to whatever I : want them to : see. This all works great. : : Here is my problem: : 1. The appliation.cfm loads with every page request. : 2. If there is no Session.Auth structure, it makes one. : 3. The session scope for the application tag in my : application.cfm is set to : timeout after 20 minutes. : 4. If the browser has had no activity for the prescribed length : of time, the : user on the next page request should be prompted to log in again. : 5. I cannot figuire out how to redirect the user by using code on the : application.cfm to do this. Sort of like the following: : : cfif not isdefined(session.Auth) : cfset session.Auth = structNew() : cfset session.Auth.UserID = 0 : cfset session.Auth.LoginAttempts = 0 : cfset session.Auth.AppList = : cfelse : cfif session.Auth.UserID eq 0 : script : document.location=int.cfm : /script : /cfif : /cfif : : This should be very easy, but I just cant get my head around it. I keep : getting the million-page-loading problem. : : Any thoughts. : : :-) : : John : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does anyone know where this error is generated?
One way would be to develop an ISAPI filter or extension that determines if the CF service is started, if so, pass request to CF, if not, send user to pretty error page. -- jon mailto:[EMAIL PROTECTED] Thursday, March 27, 2003, 2:28:35 PM, you wrote: CW Not to be dense, but if CF service is stopped, then how does it provide this CW response? CW We ARE fixing the session variable locking, but this message ALSO appears CW when CF Service restarts. CW I meant that the fixing of issues was a priority, in the MEANTIME we would CW like to present a prettier face to the user. There are a large number of CW sites here, so it takes some time to resolve all that. CW Still wondering ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application security structure -- ADDENDUM
Yes it does matter, since this is a frame you do not want the login page loading inside the frame. You have: script document.location=int.cfm /script which will indeed load it into the frame. You want to do top.document.location instead. Example script top.document.location.href='int.cfm'; /script Bryan F. Hogan Director of Internet Development Team Macromedia Volunteer Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:51 PM To: CF-Talk Subject: Application security structure -- ADDENDUM I dont know if this matters, but the default page for this site is int.cfm which is a frame page that calls the page content.cfm. this page checks to see whether the user has successfully logged in, and then directs them to the correct page. -Original Message- From: John Stanley Sent: Thursday, March 27, 2003 1:40 PM To: CF-Talk Subject: Application security structure Running CFMX Okay, this is a very basic question for alot of you, but one that gives me pause everytime it comes up. I am developing a large application-level web site that will house several smaller applications inside of it. I am using application and user-groups defined roles for each user to limit their access to whatever I want them to see. This all works great. Here is my problem: 1. The appliation.cfm loads with every page request. 2. If there is no Session.Auth structure, it makes one. 3. The session scope for the application tag in my application.cfm is set to timeout after 20 minutes. 4. If the browser has had no activity for the prescribed length of time, the user on the next page request should be prompted to log in again. 5. I cannot figuire out how to redirect the user by using code on the application.cfm to do this. Sort of like the following: cfif not isdefined(session.Auth) cfset session.Auth = structNew() cfset session.Auth.UserID = 0 cfset session.Auth.LoginAttempts = 0 cfset session.Auth.AppList = cfelse cfif session.Auth.UserID eq 0 script document.location=int.cfm /script /cfif /cfif This should be very easy, but I just cant get my head around it. I keep getting the million-page-loading problem. Any thoughts. :-) John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RE: Does anyone know where this error is generated?
This isn't exactly the case. The message is from the CF ISAPI extension, and to the best of my knowledge there's no way to change it in CF 5. Yes. I just didn't want to explain the nuts and bolts :) It should be mentioned for clarity that it's not the ISAPI extension that's causing the error, it's the fact that the service is down. The ISAPI extension is merely displaying the error message. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cffile vs. cfinclude
For question 3, the biggest difference is whether you can have CF processing in your files. Usually for config stuff, CF is not used, so either will work in this case. CFFILE does not have the overhead associated with the CFSAVECONTENT tag (minimal, but still there), nor the CFMX compilation cycle. However, CFFILE doesn't get the benefit of cached templates like the CFINCLUDE would from the CF server. Both will benefit from filesystem-level caching/buffers. I suspect that CFFILE is faster than CFSAVECONTENT/CFINCLUDE because there is no processing overhead, but you'd have to do some tests to see if that's the case (loop over each one a few thousand times and use gettickcount() to see how long it takes). To get to the final point though, if it's a config file that's static, just read it once, and cache it somewhere (probably the parsed representation, rather than the raw data), and then the discussion is moot. cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 11:30 AM To: CF-Talk Subject: cffile vs. cfinclude Here's some questions I have about cffile... maybe someone can help me out. 1. All I've been able find out about performance, is that extensive use of cffile will create a performance problem because of the slow nature of disk I/O. What is extensive? 2. As far as disk access is concerned, what's the difference between CF reading a file using cffile, and inculding one using cfinclude? 3. Which of the following (if either) is better? cffile action=read file=test.xml variable=foo -OR- cfsavecontent variable=foo cfinclude template=test.xml /cfsavecontent -Brad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JSP and outputing cgi variables
Sorry for the OT post, I'm a JSP newbie and need to know how I would do cfoutput #cgi.server_name# /cfoutput on a JSP page? %=request.getServerName()% ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfimport tag - jsp libraries
Its my first attempt at using the cfimport tag and I can't seem to get by this error. What type should it be? I didn't seem a 'type' option in the documentation. The type for attribute path of tag Height could not be determined. 1 : CFOUTPUT 2 : cfimport taglib=/WEB-INF/lib/image_taglib.jar prefix=imgD 3 : imdD:Height path=0100680s.jpg / 4 : /CFOUTPUT Thanks, Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfimport tag - jsp libraries
Its my first attempt at using the cfimport tag and I can't seem to get by this error. What type should it be? I didn't seem a 'type' option in the documentation. The type for attribute path of tag Height could not be determined. 1 : CFOUTPUT 2 : cfimport taglib=/WEB-INF/lib/image_taglib.jar prefix=imgD 3 : imdD:Height path=0100680s.jpg / 4 : /CFOUTPUT You can get it to work by cycling the CF server. There may be a way to get it to automatically recognize jar and tld files placed in /WEB-INF/lib, but I don't know what it is, off the top of my head. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX Updater 3 Available
Just a reminder that ColdFusion MX Updater 3 is now available for free download from the MM website. In my opinion, this is very close to a full dot-release of CFMX, and includes all cumulative major fixes in all product areas, and adds over 100 fixes, mostly focused around server reliability and stability. If you've shied away from CFMX until now because of reported stability problems, this is your release. We're committed to supporting ColdFusion and you, the ColdFusion customer, and we're working hard to ensure you get the best ColdFusion products we can produce. Sincerely, The ColdFusion RD Team ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does anyone know where this error is generated?
Dave, Thanks, but that's certainly not the good news I was looking for... Ah well. I wouldn't have thought that CF would respond at all if it was... well, not responding, quite an interesting deal there. - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:42 PM Subject: RE: Does anyone know where this error is generated? The message is from CF, not IIS. If you've stopped the CF service, if you try to request a .cfm page, this error will appear. This isn't exactly the case. The message is from the CF ISAPI extension, and to the best of my knowledge there's no way to change it in CF 5. In CFMX with Updater 3, however, I imagine that you may be able to change it if you're using Apache instead of IIS, since I believe that the source for the Apache module is provided with Updater 3. No such luck with IIS, though, I'll bet. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Name Sounds Like Matching
Search google for SOUNDEX. I have a feeling I am going to be working on this one for a while... One of my more demanding clients is asking for a name matching solution on the cheap. What it needs to do is find where a name 'sounds like' another name, even if it is in another language (including Middle Eastern and Oriental names). In addition, I need to be able to eliminate false positives wherever possible, in order to come up with the most consise list of matches. I really don't know where to start. SQL Server and Oracle both offer soundex support, which I suppose could be used to generate some values for comparisons. But I am not sure how this would work when different languages come into play. Does anyone have / know of any books / resources / advice on how to do this? M ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Does anyone know where this error is generated?
Downside of that would be additional load for every request, would it not? - Original Message - From: jon hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:47 PM Subject: Re: Does anyone know where this error is generated? One way would be to develop an ISAPI filter or extension that determines if the CF service is started, if so, pass request to CF, if not, send user to pretty error page. -- jon mailto:[EMAIL PROTECTED] Thursday, March 27, 2003, 2:28:35 PM, you wrote: CW Not to be dense, but if CF service is stopped, then how does it provide this CW response? CW We ARE fixing the session variable locking, but this message ALSO appears CW when CF Service restarts. CW I meant that the fixing of issues was a priority, in the MEANTIME we would CW like to present a prettier face to the user. There are a large number of CW sites here, so it takes some time to resolve all that. CW Still wondering ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Name Sounds Like Matching
You say on the cheap. Well that means they get whatever's standard with no customisation, right? That's what soundex is. It may not be great, but it's certainly easy. Demanding clients with a tight budget really need to be dealt with firmly. They're business killers. The thing is that phonetic tokenisation algorithms are language based, i.e. soundex is designed to work for English. However, it would be by far the easiest to implement. There's a udf here: http://cflib.org/udf.cfm?ID=39 . There are a few variations on Soundex which could be investigated. There's also metaphone which is a bit more complex to implement. I would store the soundex code for each name in the database, with an index on this column, and then use the soundex code of the input data as the search key. In this way it will be just as quick as a regular search and you can do it whether or not the dbms supports Soundex. Combined with regular searching perhaps with typo support from verity, and that would have to be way more than a budget client could expect. Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ - Original Message - From: Haggerty, Mike [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, March 28, 2003 7:34 AM Subject: OT: SQL Name Sounds Like Matching I have a feeling I am going to be working on this one for a while... One of my more demanding clients is asking for a name matching solution on the cheap. What it needs to do is find where a name 'sounds like' another name, even if it is in another language (including Middle Eastern and Oriental names). In addition, I need to be able to eliminate false positives wherever possible, in order to come up with the most consise list of matches. I really don't know where to start. SQL Server and Oracle both offer soundex support, which I suppose could be used to generate some values for comparisons. But I am not sure how this would work when different languages come into play. Does anyone have / know of any books / resources / advice on how to do this? M ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Updater 3 Available
Damon, What's the Plan-B procedure should our installations decide to die on us and our customers after installing 3? Just need to know before we move forward. Thanks... Lee Fuller Chief Technical Officer PrimeDNA / AAA Web Hosting Corp. | -Original Message- | From: Damon Cooper [mailto:[EMAIL PROTECTED] | Sent: Thursday, March 27, 2003 12:08 PM | To: CF-Talk | Subject: CFMX Updater 3 Available | | | Just a reminder that ColdFusion MX Updater 3 is now | available for free download from the MM website. | | In my opinion, this is very close to a full dot-release of | CFMX, and includes all cumulative major fixes in all product | areas, and adds over 100 fixes, mostly focused around server | reliability and stability. | | If you've shied away from CFMX until now because of reported | stability problems, this is your release. We're committed to | supporting ColdFusion and you, the ColdFusion customer, and | we're working hard to ensure you get the best ColdFusion | products we can produce. | | Sincerely, | | The ColdFusion RD Team | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Name Sounds Like Matching
Matthew; Yeah, I'd like to give them the standard with no customization, period. Something tells me that's not going to happen. Youre message is very helpful. I hadn't thought about using Verity for this, but typo support would be great. My only issue with Soundex is with foreign names, and I can expect over a million of them from over 50 countries. Is there a way (meaning, has anyone already worked this out somehow) of compensating for international variations in pronounciation? Do you know of a cyrillic version of soundex? Something that does Greek, Russian, Hebrew? Thanks, M -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:20 PM To: CF-Talk Subject: Re: SQL Name Sounds Like Matching You say on the cheap. Well that means they get whatever's standard with no customisation, right? That's what soundex is. It may not be great, but it's certainly easy. Demanding clients with a tight budget really need to be dealt with firmly. They're business killers. The thing is that phonetic tokenisation algorithms are language based, i.e. soundex is designed to work for English. However, it would be by far the easiest to implement. There's a udf here: http://cflib.org/udf.cfm?ID=39 . There are a few variations on Soundex which could be investigated. There's also metaphone which is a bit more complex to implement. I would store the soundex code for each name in the database, with an index on this column, and then use the soundex code of the input data as the search key. In this way it will be just as quick as a regular search and you can do it whether or not the dbms supports Soundex. Combined with regular searching perhaps with typo support from verity, and that would have to be way more than a budget client could expect. Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4