Re: clearing all sessions in an application
Do you have some sample code? On Thu, 3 Apr 2003 08:54:50 -0500, Tyler Silcox wrote: There is not an application wide session-clearer, so I always set a UUID, from CreateUUID(), in the application scope and in the user's session variables. Then if the application UUID is different from the session UUID, you reset the session variables. You can do this programmatically by just changing the UUID in the application scope and then have your session variables update automatically, which also works very nicely when the application vars expire- Tyler - Original Message - From: Kay Smoljak [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 2:22 AM Subject: clearing all sessions in an application Hi All, This is really an application design issue I'm having, I think. If anyone has any ideas I'd be greatly appreciative! I have an intranet app which uses the current Windows username to set some session variables - actually mainly a list of current projects for each user, taken from the database. Users need to be logged in to the local network to access the app, so logging in is automatic. The session setup checks for the existence of the session user struct, so an update only occurs if the session is new or timed out. As the app is used all day every day, the session timeouts are long. However, if a user adds a new project and assigns it to several users, those users will only see it when their session times out. What I'd like is a way to clear *all* sessions for that application. If that's not possible, there's several other scenarios I've thought about - setting an application variable with a timestamp when a project is added and including that in the session setup check, or using client variables stored in the database instead of sessions (but I'm not even sure if that will help). Thanks in advance... Kay. __ Kay Smoljak Web DeveloperPerthWeb Pty Ltd Level 9/105 St George's Tc - Perth - Western Australia Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au developer.perthweb.com.au ~| 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: clearing all sessions in an application
Cool...where would you place this code? In all application.cfm files? On Thu, 3 Apr 2003 15:40:35 +0100, Mike Townend wrote: CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=READONLY SCOPE=SESSION CFSCRIPT Temp = StructNew(); Temp.CFID = Session.CFID; Temp.CFTOKEN = Session.CFTOKEN; Temp.SESSIONID = Session.SESSIONID; Temp.URLTOKEN = Session.URLTOKEN; /CFSCRIPT /CFLOCK CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=SESSION CFSCRIPT StructClear(Session); // Restore the important values. Session.CFID = Temp.CFID; Session.CFTOKEN = Temp.CFTOKEN; Session.SESSIONID = Temp.SESSIONID; Session.URLTOKEN = Temp.URLTOKEN; /CFSCRIPT /CFLOCK --- 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: cfquery UPDATE
Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- 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: cfquery UPDATE
WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) 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, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- 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: cfquery UPDATE
Nevermind...I found the problem. I had a input tag with a hidden field along with a text field. On Thu, 03 Apr 2003 12:56:05 -0500, FlashGuy wrote: WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) 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, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE #FORM.UserID# /cfquery --- 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: cfquery UPDATE
Man I'm dense today. Figured it out. Used input type=password Doh. On Thu, 03 Apr 2003 13:13:20 -0500, FlashGuy wrote: I have it working now. Thanks Another question. I'm displaying the password in my template as by using input type=text name=Password value= size=33 class=inputfield I then select the username I want to edit and click on the submit button which takes me to my edit template. Here I'm inserting the fields of the user into input tags for editing. What I would like to do is have the password field return also and not display the password from the database but be able to edit the field and return * when typing rather that the characters. Am I making sense? On Thu, 3 Apr 2003 10:06:45 -0800, Bryan Stevenson wrote: Is this a clean form post (i.e. no errors and re-display of form)? If not then you may be accidentally re-setting vars somewhere along the line. Can you post all the code for your form? 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, April 03, 2003 9:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) 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, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCH AR WHERE #FORM.UserID# /cfquery --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba
Re: cfquery UPDATE
I have it working now. Thanks Another question. I'm displaying the password in my template as by using input type=text name=Password value= size=33 class=inputfield I then select the username I want to edit and click on the submit button which takes me to my edit template. Here I'm inserting the fields of the user into input tags for editing. What I would like to do is have the password field return also and not display the password from the database but be able to edit the field and return * when typing rather that the characters. Am I making sense? On Thu, 3 Apr 2003 10:06:45 -0800, Bryan Stevenson wrote: Is this a clean form post (i.e. no errors and re-display of form)? If not then you may be accidentally re-setting vars somewhere along the line. Can you post all the code for your form? 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, April 03, 2003 9:56 AM Subject: Re: cfquery UPDATE WTF Here is my code: cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCHAR WHERE UserID=cfqueryparam value=#FORM.UserID# cfsqltype=CF_SQL_LONGVARCHAR /cfquery When I update the password field it doesn't get inserted and then the username filed gets a duplicate name inserted. username field = bob,bob If I try setting the password again and hit submit I get. username field = bob,bob,bob,bob and so on. The output of the variables for the UserID are: UsrID: 9,9 FORM.UserID: 9,9 Why is the an extra figure concatenated on the end? On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: WHERE #FORM.UserID# Should be something like: WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as well) 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, April 03, 2003 9:16 AM Subject: re: cfquery UPDATE Hi, Whats wrong with the syntax below? When I change a field and click the submit to run the code below it adds the field to the existing field in the database. I want to replace it. For example the password is test. Using my template I enter in xxx click the submit. When I check the database I have test,xxx in the password field. I just want xxx. cfquery name=UpdateUser datasource=#Request.App.dsn# UPDATE login SET Username=cfqueryparam value=#FORM.Username# cfsqltype=CF_SQL_LONGVARCHAR, Password=cfqueryparam value=#FORM.Password# cfsqltype=CF_SQL_LONGVARCHAR, Firstname=cfqueryparam value=#FORM.Firstname# cfsqltype=CF_SQL_LONGVARCHAR, Lastname=cfqueryparam value=#FORM.Lastname# cfsqltype=CF_SQL_LONGVARCHAR, Level=cfqueryparam value=#FORM.Level# cfsqltype=CF_SQL_LONGVARCHAR, Access=cfqueryparam value=#FORM.Access# cfsqltype=CF_SQL_LONGVARCHAR, Status=cfqueryparam value=#FORM.Status# cfsqltype=CF_SQL_LONGVARCH AR WHERE #FORM.UserID# /cfquery --- 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
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
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: 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: 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
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
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
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
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 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
Encrypting password
HI, I'm displaying all the fields from my database which also contains the users password in plain text. Is there a way to encrypt it when I display it to the screen? As *** or just a bunch of gobbly gook? #GetUsers.Password# --- 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
Submitting form from img
Hi, I have a form that I want to submit using an image rather than a input type=submit button. How can I do this? form action=action.cfm method=post img src=file.gif /form --- 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: 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: 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 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: Getting XP Login Name?
Use cfset auth = #CGI.AUTH_USER# cfoutput #user# /cfoutput On Wed, 19 Mar 2003 13:33:30 -, Robertson-Ravo, Neil (RX) wrote: I woudl assume that if you can get to the registry you can get that info... -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 13:22 To: CF-Talk Subject: Getting XP Login Name? I have not played with CF for a couple and years, and now am getting back into it. Can someone tell me if it is possible to retrieve the XP login name on the puter that is accessing my app? Thanks! Tim Claremont Applications Specialist Independent Living For Seniors 585.922.2882 [EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. Thank you! ViaHealth ** ~| 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
Stripping from variable
Hi, I have a variable called file which is being passed to my template via JS. The output always gets duplicated. file = test2test2 -OR- file = cubacuba How can I ouput just one occurrence? Is there some sort of match function? file = cuba --- 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
Using createUUID()
Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- 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: Using createUUID()
If there is no change of duplication I like this ID#. In the code below. Would the UUID number be different for the hidden field when I eventually insert the form fields into my database? input class=uuid type=text value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumber size=38 onfocus=this.blur(); input type=hidden value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumberr On Mon, 17 Mar 2003 07:55:49 -0600, Larry Juncker wrote: Unless I am missing something very simple, why would this not work? cfloop from=1 to=1000 index=i cfoutput CT-#Right(createUUID(),7)# BR /cfoutput /cfloop I ran this code and found no dups in 1000 lines on one machine Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- 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: Using createUUID()
On Mon, 17 Mar 2003 08:19:44 -0600, Larry Juncker wrote: As long as you use this value when the form is initially loaded, then this value would insert into the database as well. I think I understand what you are asking. If you are wanting this to be a unique form ID number then I would recommend calling it something other than UUID, because once you save it as a ten digit number, it is no longer a UUID. Does that make sense? Yup. Hope this helps. Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:05 AM To: CF-Talk Subject: RE: Using createUUID() If there is no change of duplication I like this ID#. In the code below. Would the UUID number be different for the hidden field when I eventually insert the form fields into my database? input class=uuid type=text value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumber size=38 onfocus=this.blur(); input type=hidden value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumberr On Mon, 17 Mar 2003 07:55:49 -0600, Larry Juncker wrote: Unless I am missing something very simple, why would this not work? cfloop from=1 to=1000 index=i cfoutput CT-#Right(createUUID(),7)# BR /cfoutput /cfloop I ran this code and found no dups in 1000 lines on one machine Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- 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
Check if file on server is *read-only*
HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- 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: Check if file on server is *read-only*
Thanks On Mon, 17 Mar 2003 08:51:45 -0700, [EMAIL PROTECTED] wrote: On Windows systems, files that are read only will have an R in the attributes column when using cfdirectory. For *nix systems, you should be able to check the mode column. - Original Message - From: FlashGuy [EMAIL PROTECTED] Date: Monday, March 17, 2003 8:37 am Subject: Check if file on server is *read-only* HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- 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
OT: Saving webpage as a PDF document and retain links
Hi, This is off topic but has anyone had experience saving a webpage (with links etc.) to a PDF file and also retain the links that when clicked on in Acrobat opens those links? Can this be done? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- --- 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: Creating a auto-generated account number
It might require a format like TSC-number On Thu, 13 Mar 2003 18:04:52 -0500, John Quarto-vonTivadar wrote: If it doesn't need a specific format why not just use createUUID() ? -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 5:51 PM To: CF-Talk Subject: Creating a auto-generated account number Hi, I'm using CF and MySQL in a windows platform. I have a form that when opened I would like a unique account number generated for each form opened. Has anyone done this before? Whats the best way to go about it? --- 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
Creating a auto-generated account number
Hi, I'm using CF and MySQL in a windows platform. I have a form that when opened I would like a unique account number generated for each form opened. Has anyone done this before? Whats the best way to go about it? --- 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
Using layers...div tags
Hi, I would like to duplicate one part from this website but I'm not sure how to go about it. http://www.mapleleafs.com/home.ml I want to create something similar to the SCORE, LEAFS TV and LEAFS INSIDER by clicking the tabs the content changes. Anyone have any code or would know how to do this? BTW...Go Leafs Go!...Stanley Cup here we come! Thanks --- 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
input tag
Hi again, I have a form with two input tags. The Login button executes the file assigned to the form tag. How can I have the Logout button run a template file rather then the form? form action=index.cfm method=post input type=submit value=Login style=background:6C993F class=loginbutton !--- THIS EXECUTES THE ABOVE form --- input type=submit value=Logout style=background:6C993F class=loginbutton!--- I WANT THIS TO EXECUTE THE FILE logout.cfm --- /form --- 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: Creating custom tag?
Hi, I have a box that I created that appears multiple times in my template. The only thing that gets modified is the text and the width in pixels based on ths ize on my input box. Is it possible to create a custom tag where I can enter in only the text and width measurements? For examle: dialog text=Date Created width=156 input input input /dialog The above would draw a box around the input tags and insert the text appropriately. Below is the code I current;y use. !--- Start Date Created Box --- table border=0 cellpadding=12 cellspacing=0 width=156 tr td table border=0 cellpadding=0 cellspacing=0 tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxl.gif width=2 height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=12 height=17 border=0/td td class=dialogheadnbsp;Datenbsp;Creatednbsp;/td td width=156img src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=100% height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxr.gif width=2 height=17 border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxl.gif width=2 height=100% border=0/td td colspan=3 width=100% height=100% table border=0 cellpadding=8 cellspacing=0 tr td class=binputtype input type=hidden name=theTime value=#now()# cfoutput input type=text name=theTime value=nbsp;#DateFormat(todayDate, , dd, )# size=30 class=inputfield READONLY /cfoutput /td /tr /table /td tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxr.gif width=2 height=100% border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxl.gif width=2 height=2 border=0/td td colspan=3img src=cfoutput#Request.App.image_root#/cfoutputmbxb.gif width=100% height=2 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxr.gif width=2 height=2 border=0/td /tr /table /td /tr /table !--- End Date Created Box --- --- 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: Creating custom tag?
OK...so I don't have to do anything fancy. Just cut my code below into two files. Like so: CFMODULE TEMPLATE=../CustomTags/dialog_start.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 input... input... input... CFMODULE TEMPLATE=../CustomTags/dialog_end.cfm ?? On Tue, 11 Mar 2003 07:20:11 -0500, Randell B Adkins wrote: Sure. You can call the CustomTag such as CF_MyTag or using CFModule: CustomTag: CF_MyTag Text=Whatever you want to say bxheight=100 bxwidth=200 CFMODULE TEMPLATE=../CustomTags/MyTag.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 Just remember now in your custom tag that the values of TEXT, BXHEIGHT and BXWIDTH should be referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH The good thing about CFModule is the tag can reside anywhere. Using the CF_MyTag approach, the tag must be in the custom tags directory specified in CF Administator. [EMAIL PROTECTED] 03/11/03 06:56AM Hi, I have a box that I created that appears multiple times in my template. The only thing that gets modified is the text and the width in pixels based on ths ize on my input box. Is it possible to create a custom tag where I can enter in only the text and width measurements? For examle: dialog text=Date Created width=156 input input input /dialog The above would draw a box around the input tags and insert the text appropriately. Below is the code I current;y use. !--- Start Date Created Box --- table border=0 cellpadding=12 cellspacing=0 width=156 tr td table border=0 cellpadding=0 cellspacing=0 tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxl.gif width=2 height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=12 height=17 border=0/td td class=dialogheadnbsp;Datenbsp;Creatednbsp;/td td width=156img src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=100% height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxr.gif width=2 height=17 border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxl.gif width=2 height=100% border=0/td td colspan=3 width=100% height=100% table border=0 cellpadding=8 cellspacing=0 tr td class=binputtype input type=hidden name=theTime value=#now()# cfoutput input type=text name=theTime value=nbsp;#DateFormat(todayDate, , dd, )# size=30 class=inputfield READONLY /cfoutput /td /tr /table /td tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxr.gif width=2 height=100% border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxl.gif width=2 height=2 border=0/td td colspan=3img src=cfoutput#Request.App.image_root#/cfoutputmbxb.gif width=100% height=2 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxr.gif width=2 height=2 border=0/td /tr /table /td /tr /table !--- End Date Created Box --- --- 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: Creating custom tag?
Correct. It works great. Thanks On Tue, 11 Mar 2003 07:47:01 -0500, Randell B Adkins wrote: Yes just considering that the dialog_start would be the beginning part of your tabel then your inputs are within that table elements itself. Then you will need to close your tables thus I am assuming that is the reason for the dialog_end [EMAIL PROTECTED] 03/11/03 07:25AM OK...so I don't have to do anything fancy. Just cut my code below into two files. Like so: CFMODULE TEMPLATE=../CustomTags/dialog_start.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 input... input... input... CFMODULE TEMPLATE=../CustomTags/dialog_end.cfm ?? On Tue, 11 Mar 2003 07:20:11 -0500, Randell B Adkins wrote: Sure. You can call the CustomTag such as CF_MyTag or using CFModule: CustomTag: CF_MyTag Text=Whatever you want to say bxheight=100 bxwidth=200 CFMODULE TEMPLATE=../CustomTags/MyTag.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 Just remember now in your custom tag that the values of TEXT, BXHEIGHT and BXWIDTH should be referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH The good thing about CFModule is the tag can reside anywhere. Using the CF_MyTag approach, the tag must be in the custom tags directory specified in CF Administator. [EMAIL PROTECTED] 03/11/03 06:56AM Hi, I have a box that I created that appears multiple times in my template. The only thing that gets modified is the text and the width in pixels based on ths ize on my input box. Is it possible to create a custom tag where I can enter in only the text and width measurements? For examle: dialog text=Date Created width=156 input input input /dialog The above would draw a box around the input tags and insert the text appropriately. Below is the code I current;y use. !--- Start Date Created Box --- table border=0 cellpadding=12 cellspacing=0 width=156 tr td table border=0 cellpadding=0 cellspacing=0 tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxl.gif width=2 height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=12 height=17 border=0/td td class=dialogheadnbsp;Datenbsp;Creatednbsp;/td td width=156img src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=100% height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxr.gif width=2 height=17 border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxl.gif width=2 height=100% border=0/td td colspan=3 width=100% height=100% table border=0 cellpadding=8 cellspacing=0 tr td class=binputtype input type=hidden name=theTime value=#now()# cfoutput input type=text name=theTime value=nbsp;#DateFormat(todayDate, , dd, )# size=30 class=inputfield READONLY /cfoutput /td /tr /table /td tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxr.gif width=2 height=100% border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxl.gif width=2 height=2 border=0/td td colspan=3img src=cfoutput#Request.App.image_root#/cfoutputmbxb.gif width=100% height=2 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxr.gif width=2 height=2 border=0/td /tr /table /td /tr /table !--- End Date Created Box --- --- 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: Creating custom tag?
Opps...not quite. Would I put these in my application.cfm along with my APPLICATION. stuff? referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH On Tue, 11 Mar 2003 07:48:47 -0500, FlashGuy wrote: Correct. It works great. Thanks On Tue, 11 Mar 2003 07:47:01 -0500, Randell B Adkins wrote: Yes just considering that the dialog_start would be the beginning part of your tabel then your inputs are within that table elements itself. Then you will need to close your tables thus I am assuming that is the reason for the dialog_end [EMAIL PROTECTED] 03/11/03 07:25AM OK...so I don't have to do anything fancy. Just cut my code below into two files. Like so: CFMODULE TEMPLATE=../CustomTags/dialog_start.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 input... input... input... CFMODULE TEMPLATE=../CustomTags/dialog_end.cfm ?? On Tue, 11 Mar 2003 07:20:11 -0500, Randell B Adkins wrote: Sure. You can call the CustomTag such as CF_MyTag or using CFModule: CustomTag: CF_MyTag Text=Whatever you want to say bxheight=100 bxwidth=200 CFMODULE TEMPLATE=../CustomTags/MyTag.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 Just remember now in your custom tag that the values of TEXT, BXHEIGHT and BXWIDTH should be referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH The good thing about CFModule is the tag can reside anywhere. Using the CF_MyTag approach, the tag must be in the custom tags directory specified in CF Administator. [EMAIL PROTECTED] 03/11/03 06:56AM Hi, I have a box that I created that appears multiple times in my template. The only thing that gets modified is the text and the width in pixels based on ths ize on my input box. Is it possible to create a custom tag where I can enter in only the text and width measurements? For examle: dialog text=Date Created width=156 input input input /dialog The above would draw a box around the input tags and insert the text appropriately. Below is the code I current;y use. !--- Start Date Created Box --- table border=0 cellpadding=12 cellspacing=0 width=156 tr td table border=0 cellpadding=0 cellspacing=0 tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxl.gif width=2 height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=12 height=17 border=0/td td class=dialogheadnbsp;Datenbsp;Creatednbsp;/td td width=156img src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=100% height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxr.gif width=2 height=17 border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxl.gif width=2 height=100% border=0/td td colspan=3 width=100% height=100% table border=0 cellpadding=8 cellspacing=0 tr td class=binputtype input type=hidden name=theTime value=#now()# cfoutput input type=text name=theTime value=nbsp;#DateFormat(todayDate, , dd, )# size=30 class=inputfield READONLY /cfoutput /td /tr /table /td tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxr.gif width=2 height=100% border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxl.gif width=2 height=2 border=0/td td colspan=3img src=cfoutput#Request.App.image_root#/cfoutputmbxb.gif width=100% height=2 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxr.gif width=2 height=2 border=0/td /tr /table /td /tr /table !--- End Date Created Box --- --- 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
Re: Creating custom tag?
I'm not sure where to define the attributes. Below is my code split up into files (dialog_start.cfm, dialog_end.cfm) and test.cfm contains the CFMODULE stuff. What am I doing wrong? The CFMODULE attributes (bxtext, bxwidth) are not being inserted. dialog_start.cfm --- !--- Start Date Created Box --- table border=0 cellpadding=12 cellspacing=0 width=#bxwidth# tr td table border=0 cellpadding=0 cellspacing=0 tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxl.gif width=2 height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=12 height=17 border=0/td td class=dialogheadcfoutputnbsp;#bxtext#nbsp;/cfoutput/td td width=bxwidth#img src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=100% height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxr.gif width=2 height=17 border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxl.gif width=2 height=100% border=0/td td colspan=3 width=#Request.Att.bxwidth# height=100% table border=0 cellpadding=8 cellspacing=0 tr td class=binputtype dialog_end.cfm --- /td /tr /table /td tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxr.gif width=2 height=100% border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxl.gif width=2 height=2 border=0/td td colspan=3img src=cfoutput#Request.App.image_root#/cfoutputmbxb.gif width=100% height=2 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxr.gif width=2 height=2 border=0/td /tr /table /td /tr /table !--- End Date Created Box --- test.cfm --- CFMODULE TEMPLATE=dialog_start.cfm BXTEXT=Wicked BXWIDTH=140 cfoutput input type=text name=theTime value=nbsp;#DateFormat(todayDate, , dd, )# size=30 class=inputfield onfocus=this.blur(); input type=hidden name=theTime value=#DateFormat(todayDate, , dd, )# /cfoutput CFMODULE TEMPLATE=dialog_end.cfm On Tue, 11 Mar 2003 07:52:50 -0500, FlashGuy wrote: Opps...not quite. Would I put these in my application.cfm along with my APPLICATION. stuff? referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH On Tue, 11 Mar 2003 07:48:47 -0500, FlashGuy wrote: Correct. It works great. Thanks On Tue, 11 Mar 2003 07:47:01 -0500, Randell B Adkins wrote: Yes just considering that the dialog_start would be the beginning part of your tabel then your inputs are within that table elements itself. Then you will need to close your tables thus I am assuming that is the reason for the dialog_end [EMAIL PROTECTED] 03/11/03 07:25AM OK...so I don't have to do anything fancy. Just cut my code below into two files. Like so: CFMODULE TEMPLATE=../CustomTags/dialog_start.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 input... input... input... CFMODULE TEMPLATE=../CustomTags/dialog_end.cfm ?? On Tue, 11 Mar 2003 07:20:11 -0500, Randell B Adkins wrote: Sure. You can call the CustomTag such as CF_MyTag or using CFModule: CustomTag: CF_MyTag Text=Whatever you want to say bxheight=100 bxwidth=200 CFMODULE TEMPLATE=../CustomTags/MyTag.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 Just remember now in your custom tag that the values of TEXT, BXHEIGHT and BXWIDTH should be referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH The good thing about CFModule is the tag can reside anywhere. Using the CF_MyTag approach, the tag must be in the custom tags directory specified in CF Administator. [EMAIL PROTECTED] 03/11/03 06:56AM Hi, I have a box that I created that appears multiple times in my template. The only thing that gets modified is the text and the width in pixels based on ths ize on my input box. Is it possible to create a custom tag where I can enter in only the text and width measurements? For examle: dialog text=Date Created width=156 input input input /dialog The above would draw a box around the input tags and insert the text appropriately. Below is the code I current;y use. !--- Start Date Created Box --- table border=0 cellpadding=12 cellspacing=0 width=156 tr td table border=0 cellpadding=0 cellspacing=0 tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxl.gif width=2 height=17 border=0/td tdimg src=cfoutput
RE: Creating custom tag?
That worked. Thanks On Tue, 11 Mar 2003 08:39:28 -0600, Raymond Camden wrote: Your custom tags need to use Attributes.Foo instead of Foo. For example, change bxwidth to attributes.bxwidth. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia 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: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 7:15 AM To: CF-Talk Subject: Re: Creating custom tag? I'm not sure where to define the attributes. Below is my code split up into files (dialog_start.cfm, dialog_end.cfm) and test.cfm contains the CFMODULE stuff. What am I doing wrong? The CFMODULE attributes (bxtext, bxwidth) are not being inserted. dialog_start.cfm --- !--- Start Date Created Box --- table border=0 cellpadding=12 cellspacing=0 width=#bxwidth# tr td table border=0 cellpadding=0 cellspacing=0 tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxl.gif width=2 height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=12 height=17 border=0/td td class=dialogheadcfoutputnbsp;#bxtext#nbsp;/cfoutput/td td width=bxwidth#img src=cfoutput#Request.App.image_root#/cfoutputtbxm.gif width=100% height=17 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputtbxr.gif width=2 height=17 border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxl.gif width=2 height=100% border=0/td td colspan=3 width=#Request.Att.bxwidth# height=100% table border=0 cellpadding=8 cellspacing=0 tr td class=binputtype dialog_end.cfm --- /td /tr /table /td tdimg src=cfoutput#Request.App.image_root#/cfoutputmbxr.gif width=2 height=100% border=0/td /tr tr tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxl.gif width=2 height=2 border=0/td td colspan=3img src=cfoutput#Request.App.image_root#/cfoutputmbxb.gif width=100% height=2 border=0/td tdimg src=cfoutput#Request.App.image_root#/cfoutputbbxr.gif width=2 height=2 border=0/td /tr /table /td /tr /table !--- End Date Created Box --- test.cfm --- CFMODULE TEMPLATE=dialog_start.cfm BXTEXT=Wicked BXWIDTH=140 cfoutput input type=text name=theTime value=nbsp;#DateFormat(todayDate, , dd, )# size=30 class=inputfield onfocus=this.blur(); input type=hidden name=theTime value=#DateFormat(todayDate, , dd, )# /cfoutput CFMODULE TEMPLATE=dialog_end.cfm On Tue, 11 Mar 2003 07:52:50 -0500, FlashGuy wrote: Opps...not quite. Would I put these in my application.cfm along with my APPLICATION. stuff? referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH On Tue, 11 Mar 2003 07:48:47 -0500, FlashGuy wrote: Correct. It works great. Thanks On Tue, 11 Mar 2003 07:47:01 -0500, Randell B Adkins wrote: Yes just considering that the dialog_start would be the beginning part of your tabel then your inputs are within that table elements itself. Then you will need to close your tables thus I am assuming that is the reason for the dialog_end [EMAIL PROTECTED] 03/11/03 07:25AM OK...so I don't have to do anything fancy. Just cut my code below into two files. Like so: CFMODULE TEMPLATE=../CustomTags/dialog_start.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 input... input... input... CFMODULE TEMPLATE=../CustomTags/dialog_end.cfm ?? On Tue, 11 Mar 2003 07:20:11 -0500, Randell B Adkins wrote: Sure. You can call the CustomTag such as CF_MyTag or using CFModule: CustomTag: CF_MyTag Text=Whatever you want to say bxheight=100 bxwidth=200 CFMODULE TEMPLATE=../CustomTags/MyTag.cfm TEXT=Whatever you want to say BXHEIGHT=100 BEWIDTH=200 Just remember now in your custom tag that the values of TEXT, BXHEIGHT and BXWIDTH should be referenced in the ATTRIBUTE Scope: ATTRIBUTE.TEXT ATTRIBUTE.BXHEIGHT ATTRIBUTE.BXWIDTH The good thing about CFModule is the tag can reside anywhere. Using the CF_MyTag approach, the tag must
input radio buttons
HI, I have the following radio buttons: input type=radio name=Yesnbsp;Yesbr input type=radio name=Nonbsp;No Currently I can click on both the yes and no and they both get selected. I don't want that to happen. The user should only be able to select one. How can I do this? I also have another list of radio buttons with 5 items but only want to allow the user to select one and NOT multiples. --- 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
Inserting date/time stamp
Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- 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: Inserting date/time stamp
On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? I want the date and time the form was opened/created. For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the first time, simply eded this in the form: input type=hidden name=theTime value=#now()# and store form.theTime in your db. If you want the time submitted, just passed now() to your database (or whatever function your db uses to represent the current time). Thanks === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia 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: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:14 PM To: CF-Talk Subject: Inserting date/time stamp Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- 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: Inserting date/time stamp
HmmmI also want the date and time displayed on my form. I did a cfoutput#now()#/cfoutput but I don't like the results. I want something like: Monday, March 10, 2003 at 2:26pm On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the first time, simply eded this in the form: input type=hidden name=theTime value=#now()# and store form.theTime in your db. If you want the time submitted, just passed now() to your database (or whatever function your db uses to represent the current time). === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia 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: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:14 PM To: CF-Talk Subject: Inserting date/time stamp Hi, I have a form that I want to insert the date and time when the form is opened. This will also be saved to a database when saved. Whats the best way of also creating a automatic reference no which increments when a new form is opened? Any ideas... --- 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: Inserting date/time stamp
On Mon, 10 Mar 2003 14:23:36 -0500, Ben Doom wrote: You could always use an application variable. I'm not sure what that has to do with a date/time object. Just out of curiosity, if this is going to a database, can't you just create a unique self-incrementing field and use that? How? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 2:14 PM : To: CF-Talk : Subject: Inserting date/time stamp : : : Hi, : : I have a form that I want to insert the date and time when the : form is opened. This will also be saved to a database when saved. : : Whats the best way of also creating a automatic reference no : which increments when a new form is opened? : : Any ideas... : : : --- : 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: Inserting date/time stamp
Works great. How can I stop people of editing the input line where I'm dumping the date? I don't want them to be able to change it. input type=text name=theTime value=cfoutputnbsp;#DateFormat(todayDate, , dd, )#/cfoutput size=30 On Mon, 10 Mar 2003 14:35:13 -0500, Ben Doom wrote: dateformat() and timeformat() should take care of display issues nicely for you. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 2:27 PM : To: CF-Talk : Subject: RE: Inserting date/time stamp : : : HmmmI also want the date and time displayed on my form. I did : a cfoutput#now()#/cfoutput but I don't like the results. : : I want something like: : : Monday, March 10, 2003 at 2:26pm : : : : On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: : : Do you want to know the time when the form was 'opened' (viewed you : mean) or actually saved? For example, I may hit your form at 12:01 PM, : and it may take me 5 minutes to fill it out. So would you want 12:01 PM : stored, or 12:06 PM, the time when the form was actually submitted? If : you want the first time, simply eded this in the form: : : input type=hidden name=theTime value=#now()# : : and store form.theTime in your db. If you want the time submitted, just : passed now() to your database (or whatever function your db uses to : represent the current time). : : === : Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc : Member of Team Macromedia : : 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: FlashGuy [mailto:[EMAIL PROTECTED] : Sent: Monday, March 10, 2003 1:14 PM : To: CF-Talk : Subject: Inserting date/time stamp : : : Hi, : : I have a form that I want to insert the date and time when : the form is opened. This will also be saved to a database when saved. : : Whats the best way of also creating a automatic reference : no which increments when a new form is opened? : : Any ideas... : : : --- : 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: Inserting date/time stamp
Right, but the idea I was trying to achieve was to keep the look the same (with the input field) so it matches the rest of the form. From: FlashGuy [EMAIL PROTECTED] How can I stop people of editing the input line where I'm dumping the date? I don't want them to be able to change it. input type=text name=theTime value=cfoutput #DateFormat(todayDate, , dd, )#/cfoutput size=30 I'd display it as plain text (not in a form field), and do a hidden form field to send the value through the form. cfoutput #DateFormat(todayDate, , dd, )#/cfoutput input type=hidden name=theTime value=cfoutput #DateFormat(todayDate, , dd, )#/cfoutput Scott Brady http://www.scottbrady.net/ ~| 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
CF and MySQL
Hi, I've installed MySQL. I can't seem to verify the databases within the CF Adminstrator. I created the data source within the System DSN. I then go into the CF Admin and try to verify the database but it fails. I've also installed MyODBC for MySQL Why? I cant see the database with MySQL-Front no problem. --- 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
input button using a graphic
Hi, How can I have a image file for my submit button rather than what being specified in the VALUE attribute? input type=submit name=SubmitCheck value=[D] --- 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
Deleting entries from database via checkbox
HI, I'm displaying entries from my database in my template. I have input checkboxes displayed on every line. I would like to be able to check on a box or multiple boxes and when a click on my Delete button on my template those entries are deleted from my database. Here is the code that displays the entries from my database. CFOUTPUT QUERY=GetEnv TR bgcolor=#bgColor(currentRow MOD 2,silver,white)# TD valign=top width=3input type=checkbox name=submitButtonName value=Delete/TD TD valign=top width=5% class=filetrackernbsp;#GetEnv.Filename#/TD TD align=center valign=top width=5%#GetEnv.Command#/TD TD align=center valign=top width=15%#GetEnv.CreatedOn#/TD TD align=center valign=top width=15%#GetEnv.LastAcc#/TD TD align=center valign=top width=15%#GetEnv.LastMod#/TD TD align=center valign=top width=5%#GetEnv.FileSize#/TD TD valign=top width=15%#GetEnv.Directory#/TD TD align=center valign=top width=5%#GetEnv.Username#/TD TD valign=top width=20%#GetEnv.FileDescription#/TD /TR /CFOUTPUT --- 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: Force authentication screen
Hi, I have a login template and database authentication that works great. My question is. How can I force the user to always authenticate after the browser has been closed or they click on the logout button on my template? How can I also stop them from dragging a shortcut to the desktop to bypass the authentication screen? Can I do this by clearing all the session varaibles etc.? If so, how? --- 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: Force authentication screen
Thanks Michael. On Thu, 27 Feb 2003 07:18:29 -0500, Tangorre, Michael wrote: What you need to do is the following: When the user clicks the logout button, clear their session out, and send them outside of the secured area. For the closing of the browser, put this code into your application.cfm page: cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN) cfset localCFID = Cookie.CFID cfset localCFToken = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif The makes sure that the cookies that CF uses for session management never get written to disk, thus memory resident only, and thus gone when the browser closes. HTH, Mike -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 7:06 AM To: CF-Talk Subject: Re: Force authentication screen Hi, I have a login template and database authentication that works great. My question is. How can I force the user to always authenticate after the browser has been closed or they click on the logout button on my template? How can I also stop them from dragging a shortcut to the desktop to bypass the authentication screen? Can I do this by clearing all the session varaibles etc.? If so, how? --- 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: Force authentication screen
Is there a one liner that clears out all the session variables for my logout.cfm template? On Thu, 27 Feb 2003 07:18:29 -0500, Tangorre, Michael wrote: What you need to do is the following: When the user clicks the logout button, clear their session out, and send them outside of the secured area. For the closing of the browser, put this code into your application.cfm page: cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN) cfset localCFID = Cookie.CFID cfset localCFToken = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif The makes sure that the cookies that CF uses for session management never get written to disk, thus memory resident only, and thus gone when the browser closes. HTH, Mike -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 7:06 AM To: CF-Talk Subject: Re: Force authentication screen Hi, I have a login template and database authentication that works great. My question is. How can I force the user to always authenticate after the browser has been closed or they click on the logout button on my template? How can I also stop them from dragging a shortcut to the desktop to bypass the authentication screen? Can I do this by clearing all the session varaibles etc.? If so, how? --- 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
Logging out of application
HI, I have a logout button in my application. When clicked I want to sent the user back to the login screen. This works just fine. The problem I'm having is if I click on the back button in IE I'm able to go back to that page. I don't want this to happen. How can I clear all session varaibles etc.? This is what I have in my logout.cfm file: cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN) cfset localCFID = Cookie.CFID cfset localCFToken = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif CFLOCATION URL=/website/secure/index.htm The index.htm is my login (authentication) template. --- 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: Logging out of application
Nope. I can redirect to another template after clicking the logoff button. The problem is if I click on the back button of IE I can go back the the previous page. If the user logouts I want to force them to log back in. On Thu, 27 Feb 2003 12:03:13 -0600, Paul Giesenhagen wrote: I am not sure if this will work but try CFHEADER cfheader name=location value = someurl.html cfheader statusCode = 302 statusText = Document Moved. Let us know Thanks Paul Giesenhagen QuillDesign - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, February 27, 2003 11:58 AM Subject: Logging out of application HI, I have a logout button in my application. When clicked I want to sent the user back to the login screen. This works just fine. The problem I'm having is if I click on the back button in IE I'm able to go back to that page. I don't want this to happen. How can I clear all session varaibles etc.? This is what I have in my logout.cfm file: cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN) cfset localCFID = Cookie.CFID cfset localCFToken = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif CFLOCATION URL=/website/secure/index.htm The index.htm is my login (authentication) template. --- 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: Logging out of application
THis would go into the top of my logoff.cfm file? I tried it and I can still click the IE back button and go back the the previous template. On Thu, 27 Feb 2003 12:17:26 -0600, Andy Ousterhout wrote: CFHEADER NAME=Expires VALUE=Now() CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=cache-control VALUE=no-cache, no-store, must-revalidate --- 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: Logging out of application
On Thu, 27 Feb 2003 13:32:12 -0500, Dave Watts wrote: THis would go into the top of my logoff.cfm file? I tried it and I can still click the IE back button and go back the the previous template. This would need to go into each page that is currently being cached by the browser, that you don't want the user to be able to see after logging out; when you click the back button, the browser is simply retrieving the last page from its cache. However, since all they'd be seeing is what's in the cache, you typically don't really have to worry about this. So what if they see a cached page they saw a few minutes earlier? What's important, typically, is that they can't rerun the page on the server. For example, if they click on a link from the cached page that goes to another page on the server that isn't cached by the browser, they should be forced to login again. Correct. I never tried that. Thats what I want. Thanks 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
Whats wrong with this code?
Hi, Whats wrong with the below code? I get a SQL syntax error. cfquery name=qInsertData DATASOURCE=databaser INSERT INTO results ( FileName, Command, CreatedOn, LastAcc, LastMod, Size, Directory, Username, New, Copy, Delete, Move, Rename, Description ) VALUES ( cfqueryparam value=#Filename# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=DELETE cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateCreated(TheFile), 'mm/dd/')# - #TimeFormat(FileDateCreated(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateLastAccessed(TheFile), 'mm/dd/')# at #TimeFormat(FileDateLastAccessed(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateLastModified(TheFile), 'mm/dd/')# at #TimeFormat(FileDateLastModified(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#FileSize(TheFile)# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#TheFolder# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#auth# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=YES cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#FileSource# DELETED successfully from #DirPath# cfsqltype=CF_SQL_LONGVARCHAR ) /cfquery --- 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: Whats wrong with this code?
No. They are all VARCHAR(50) to VARCHAR(255) On Thu, 27 Feb 2003 14:52:50 -0500, Bryan F. Hogan wrote: Are all you column data types text ? Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:43 PM To: CF-Talk Subject: Whats wrong with this code? Hi, Whats wrong with the below code? I get a SQL syntax error. cfquery name=qInsertData DATASOURCE=databaser INSERT INTO results ( FileName, Command, CreatedOn, LastAcc, LastMod, Size, Directory, Username, New, Copy, Delete, Move, Rename, Description ) VALUES ( cfqueryparam value=#Filename# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=DELETE cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateCreated(TheFile), 'mm/dd/')# - #TimeFormat(FileDateCreated(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateLastAccessed(TheFile), 'mm/dd/')# at #TimeFormat(FileDateLastAccessed(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateLastModified(TheFile), 'mm/dd/')# at #TimeFormat(FileDateLastModified(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#FileSize(TheFile)# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#TheFolder# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#auth# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=YES cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#FileSource# DELETED successfully from #DirPath# cfsqltype=CF_SQL_LONGVARCHAR ) /cfquery --- 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: Whats wrong with this code?
Yes! That was it. I changed the field names and it workds great. Thanks On Thu, 27 Feb 2003 15:06:38 -0500, Bryan F. Hogan wrote: There are two reserved words in your query that will cause a problem. They are: Size and Delete, these column names should not be used. Without knowing the values of your variables. I can't say for sure if this is your problem. Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:55 PM To: CF-Talk Subject: RE: Whats wrong with this code? No. They are all VARCHAR(50) to VARCHAR(255) On Thu, 27 Feb 2003 14:52:50 -0500, Bryan F. Hogan wrote: Are all you column data types text ? Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:43 PM To: CF-Talk Subject: Whats wrong with this code? Hi, Whats wrong with the below code? I get a SQL syntax error. cfquery name=qInsertData DATASOURCE=databaser INSERT INTO results ( FileName, Command, CreatedOn, LastAcc, LastMod, Size, Directory, Username, New, Copy, Delete, Move, Rename, Description ) VALUES ( cfqueryparam value=#Filename# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=DELETE cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateCreated(TheFile), 'mm/dd/')# - #TimeFormat(FileDateCreated(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateLastAccessed(TheFile), 'mm/dd/')# at #TimeFormat(FileDateLastAccessed(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#DateFormat(FileDateLastModified(TheFile), 'mm/dd/')# at #TimeFormat(FileDateLastModified(TheFile), 'HH:MM:SS')# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#FileSize(TheFile)# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#TheFolder# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#auth# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=YES cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=NO cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam value=#FileSource# DELETED successfully from #DirPath# cfsqltype=CF_SQL_LONGVARCHAR ) /cfquery --- 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
Creating a login screen
Hi, I want to create a login screen that allows the user to create his own password at initial login. So if the password field is empty in the database a Create password input would appear. Once they type in the password and click the Login button then another login template would open with the username...password prompt. The next time the user logs in the database is checked for an empty password field and goes through the same cycle again if empty. Can someone help me on this? What do I need to put into my application.cfm to? How can I stop someone from dragging a shortcut to their desktop to by-pass the login screen nexttime. I want to always force a login. --- 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
Inserting into MySQL database
Hi, I have nine variables that I want inserted into my database. cfquery name=qInsertData DATASOURCE=results Insert into myresults (strFileName, strCommand, strCreatedOn, strLastAcc, strLastMod, strSize, strDirectory, strDateCommand, strUsername) VALUES ('#Filename#', cfqueryparam value=#strFilename# cfsqltype=CF_SQL_LONGVARCHAR) ('#FileCommand#', cfqueryparam value=#strCommand# cfsqltype=CF_SQL_LONGVARCHAR) ...and so on... /cfquery Is this the correct syntax? Is there an easier way? --- 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
Checking variables
Hi, I have two variables. I need to check if the contents of the first variable exists in the second and if it does to something and if not do something else. How can I do this with a cfif statement? Example: var1 = mywork var2= C:\temp,C:\windows,c:\program files,c:\tmp DO THIS Or it could be var1 = mywork var2= C:\temp,C:\windows,c:\mywork,c:\program files,c:\tmp DO SOMETHING ELSE. --- 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
Updating database
Hi, I have this code that updated my MySQL database successfully. I'm testing this out on another PC with just Access. WHen I try to update the database I get the following error? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Below is my query for my MySQL database. Is the syntax different for MS Access? cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT alias SET env_var=#ListGetAt(Line,1,'|')#, destination=#ListGetAt(Line,2,'|')# /cfquery --- 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: Updating database
That worked. Thanks I tried to incorporate the same type of code to the example below but I also get an error on this. MySQL: - cfquery name=Update datasource=prefs UPDATE tblProfiles SET strSelect=#ListGetAt(commalist,1,'|')# /cfquery Access: -- cfquery name=Update DATASOURCE=prefs dbtype=ODBC UPDATE tblProfiles (strSelect) VALUES('#ListGetAt(commalist,1,'|')#') /cfquery On Tue, 21 Jan 2003 13:53:41 +0100, Pascal Peters wrote: cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT INTO alias (env_var,destination) VALUES('#ListGetAt(Line,1,|)#','#ListGetAt(Line,2,|)#') /cfquery -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: dinsdag 21 januari 2003 13:49 To: CF-Talk Subject: Updating database Hi, I have this code that updated my MySQL database successfully. I'm testing this out on another PC with just Access. WHen I try to update the database I get the following error? Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. Below is my query for my MySQL database. Is the syntax different for MS Access? cfquery name=update_alias DATASOURCE=alias dbtype=ODBC INSERT alias SET env_var=#ListGetAt(Line,1,'|')#, destination=#ListGetAt(Line,2,'|')# /cfquery --- 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: Updating database
Why do I need an INSERT command? I just want to update my table field. This worked fine in MySQL. On Tue, 21 Jan 2003 14:24:04 +0100, Jochem van Dieten wrote: FlashGuy wrote: Access: -- cfquery name=Update DATASOURCE=prefs dbtype=ODBC UPDATE tblProfiles (strSelect) VALUES('#ListGetAt(commalist,1,'|')#') /cfquery You are mixing insert and update syntax, correct syntax should be: INSERT INTO table (field [, field]) VALUES (value [, value]) UPDATE table SETfield = value [, field = value] Jochem ~| 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: Updating database
I never received any errors when the code was run? On Tue, 21 Jan 2003 08:38:04 -0500, Todd wrote: I'll be surprised if it worked in MySQL. It's not even a valid SQL Statement. The statement you want is: UPDATE tablename SET (field) = (value) WHERE primaryKey = something RTM: http://www.mysql.com/doc/en/UPDATE.html ~Todd At 08:34 AM 1/21/2003 -0500, you wrote: Why do I need an INSERT command? I just want to update my table field. This worked fine in MySQL. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.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 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: Updating database
No. I guess I should. On Tue, 21 Jan 2003 08:50:39 -0500, Todd wrote: Then, MySQL is definitely broken. Did you report this to the MySQL dev team as a bug? At 08:48 AM 1/21/2003 -0500, you wrote: I never received any errors when the code was run? On Tue, 21 Jan 2003 08:38:04 -0500, Todd wrote: I'll be surprised if it worked in MySQL. It's not even a valid SQL Statement. The statement you want is: UPDATE tablename SET (field) = (value) WHERE primaryKey = something RTM: http://www.mysql.com/doc/en/UPDATE.html ~Todd -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.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
WTF! Data Sources
Hi, I had MySQl installed. Converted all my Access databases over no problem. All my databases were working fine. Without going into too much detail on why...I uninstalled MySQL. Removed the data sources (ODBC) from the Control Panel and CF Administrator. I rebooted the PC and tried to enter in the old Access databases again but it won't let me. Keeps telling me The data source XXX already exists as a ColdFUsion Native Data Source. Please choose a different name for your Data Source. When I go into the ColdFUsion Administrator ODBC Data Sources I don't see the XXX data source being references. I can't find it anywhere??? Do I have to go into the registry and manually delete it. --- 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: WTF! Data Sources
That worked. Thanks On Tue, 14 Jan 2003 17:57:59 -, Stephen Moretti wrote: I had MySQl installed. Converted all my Access databases over no problem. All my databases were working fine. Without going into too much detail on why...I uninstalled MySQL. Removed the data sources (ODBC) from the Control Panel and CF Administrator. I rebooted the PC and tried to enter in the old Access databases again but it won't let me. Keeps telling me The data source XXX already exists as a ColdFUsion Native Data Source. Please choose a different name for your Data Source. When I go into the ColdFUsion Administrator ODBC Data Sources I don't see the XXX data source being references. I can't find it anywhere??? Do I have to go into the registry and manually delete it. Yep CF stores a list of datasources for its own use, which isn't altered when you delete a datasource via the ODBC Control Panel. Only problem is the CFA just doesn't display the datasource entries, rather than report them as broken. Go find HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\DataSources in the registry and delete the key for the datasource you've removed via the ODBC Control Panel. Just be careful what you mess with in the registry Stephen ~| 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
Incrementing a variable
Hi, For some reason I can't get my variable to increment when my page is reloaded. I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to reload mu index.cfm it doesn't increment? --- 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
RE: Incrementing a variable
On Tue, 17 Dec 2002 12:26:53 -, webguy wrote: Are you trying to get this result? 1st view of index.cfm value=1 2nd view of index.cfm value=2 3rd view of index.cfm value=3 Yes. If so you are doing to wrong because this is what you are actually doing OK..I see...how would I go about doing the above? 1st view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 2nd view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 3rd view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 Webguy -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 12:12 To: CF-Talk Subject: Incrementing a variable Hi, For some reason I can't get my variable to increment when my page is reloaded. I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to reload mu index.cfm it doesn't increment? --- 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
RE: Incrementing a variable
Hmm...OK I just tried it out and its not quite working the way I wanted it to. On Tue, 17 Dec 2002 12:23:20 -, Mike Townend wrote: Youll need to do something like... In Application.cfm CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=APPLICATION CFPARAM NAME=Application.child DEFAULT=0 /CFLOCK And in the index file CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=APPLICATION CFSET Application.child = Application.Child + 1 /CFLOCK HTH -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 12:12 To: CF-Talk Subject: Incrementing a variable Hi, For some reason I can't get my variable to increment when my page is reloaded. I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to reload mu index.cfm it doesn't increment? --- 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
Re: Incrementing a variable
I'm trying to set a variable based on were I am in my directory structure. At initial loading of my index.cfm I would set a variable to 0 WHen I click on a link and drill-down into the directory I want that variable incremented. At the same time if I go backup up in the directorure structure I want the variable decremented. Example: D:\dir1 [0] D:\dir2 [0] Click on D:\dir1 D:\ D:\dir1\test1 [1] D:\dir1\test2 [1] Click on D:\dir1\test D:\ D:\dir1 [1] D:\dir1\test1 [2] On Tue, 17 Dec 2002 12:28:55 -, Taz wrote: That's because on every page request you reset the value to zero What are you trying to do? Taz - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 12:12 PM Subject: Incrementing a variable Hi, For some reason I can't get my variable to increment when my page is reloaded. I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to reload mu index.cfm it doesn't increment? --- 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
Re: Incrementing a variable
If I close the brower the application.child variable doesn't get cleared? On Tue, 17 Dec 2002 13:30:50 +0100, DDB Lists wrote: Your application.cfm is loaded on every refresh so the variable is set to zero every time. You should put it in a persistant scope and check for it's existance: cif not isdefined(application.child) cfset application.child = 0 /cfif and cfset application.child = application.child + 1 - Original Message - From: FlashGuy [EMAIL PROTECTED] I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to reload mu index.cfm it doesn't increment? ~| 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
RE: Incrementing a variable
No...no error. code works just fine. Its not not behaving like I want it to. On Tue, 17 Dec 2002 12:55:38 -, webguy wrote: That code looks ok to me , how is it not working ? An error ? cflock In Application.cfm CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=APPLICATION CFPARAM NAME=Application.child DEFAULT=0 /CFLOCK And in the index file CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=APPLICATION CFSET Application.child = Application.Child + 1 /CFLOCK WG Detainees in Guantánamo: As One Year Anniversary Nears, US Bars Scrutiny By Human Rights Group http://www.amnestyusa.org/news/2002/usa12132002.html On Tue, 17 Dec 2002 12:26:53 -, webguy wrote: Are you trying to get this result? 1st view of index.cfm value=1 2nd view of index.cfm value=2 3rd view of index.cfm value=3 Yes. If so you are doing to wrong because this is what you are actually doing OK..I see...how would I go about doing the above? 1st view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 2nd view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 3rd view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 Webguy -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 12:12 To: CF-Talk Subject: Incrementing a variable Hi, For some reason I can't get my variable to increment when my page is reloaded. I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to reload mu index.cfm it doesn't increment? --- 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
Checking
I need to check if part of one string matches part of another. For example, I have to variables. dir = D:\documents\test strShowMe = documents\test,documents\test2,mywork\test,misc\test Using cfif how could I check to see if any text from the dir variable, either documents or test return a match in the strShowMe variable? --- 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
RE: Incrementing a variable
OK...but every time I hit the refresh it increments. I don't want that. Also everytime I drill down into the directory structure I also want the counter to decrement if I click on a link to go back. Probably too much work, right? On Tue, 17 Dec 2002 13:11:03 -, webguy wrote: Use a session instead of a application scope In Application.cfm CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=session CFPARAM NAME=session.child DEFAULT=0 /CFLOCK And in the index file CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=session CFSET session.child = session.Child + 1 /CFLOCK WG -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 13:02 To: CF-Talk Subject: RE: Incrementing a variable No...no error. code works just fine. Its not not behaving like I want it to. On Tue, 17 Dec 2002 12:55:38 -, webguy wrote: That code looks ok to me , how is it not working ? An error ? cflock In Application.cfm CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=APPLICATION CFPARAM NAME=Application.child DEFAULT=0 /CFLOCK And in the index file CFLOCK TIMEOUT=5 THROWONTIMEOUT=No TYPE=EXCLUSIVE SCOPE=APPLICATION CFSET Application.child = Application.Child + 1 /CFLOCK WG Detainees in Guantánamo: As One Year Anniversary Nears, US Bars Scrutiny By Human Rights Group http://www.amnestyusa.org/news/2002/usa12132002.html On Tue, 17 Dec 2002 12:26:53 -, webguy wrote: Are you trying to get this result? 1st view of index.cfm value=1 2nd view of index.cfm value=2 3rd view of index.cfm value=3 Yes. If so you are doing to wrong because this is what you are actually doing OK..I see...how would I go about doing the above? 1st view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 2nd view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 3rd view of index.cfm appliation.cfm sets child = 0 index.cfm sets child = child + 1 = 1 Webguy -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 12:12 To: CF-Talk Subject: Incrementing a variable Hi, For some reason I can't get my variable to increment when my page is reloaded. I have the following in my application.cfm file cfset child = 0 In my index.cfm file I have the following. cfset child=child + 1 Everytime I refresh the page manually or by using an a href within mu file to reload mu index.cfm it doesn't increment? --- 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
REReplace
For some reason I can't to a replace on the following: dir = D:\\ cfset test = #RERplace(dir,\\,\,ALL)# --- 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
Re: REReplace
Nevermind... On Mon, 16 Dec 2002 12:29:23 -0500, FlashGuy wrote: For some reason I can't to a replace on the following: dir = D:\\ cfset test = #RERplace(dir,\\,\,ALL)# --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- --- 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
Login/Password screen
Hi, I know there are alot of custom tags out there that will do what I'm looking for but I want the best one. So this is why I'm asking all of you hoping you've had some experience with some of them. I'd like everything stored in a database. I know some don't do that. Bascially, once the user enters in their username/password they are redirected to a URL on the server based on the authentication. I have one called CF_EzPassword but was wondering if there are any better ones? Thanks --- 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
RE: Login/Password screen
That part is no problem. Its what I need to put into the application.cfm to timeout or after 2-3 attempts lock the user out. Also once they log in they might drag a shortcut to their desktop which would bypass my index.cfm in the root that has the authentication code. How can I force them to the login screen everytime regardless if they dragged a shortcut? On Fri, 13 Dec 2002 13:10:45 -, Craig Dudley wrote: That's quite simple to code yourself, why don't you give it a try and post any questions here if you get stuck? Just pass a username and password from a from into a query, if a matching record is found, the queries record count will be 1 and you can authenticate the user, that's quite simplistic but basically all you need. Have a go, you know you want to ;-) -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 13 December 2002 12:43 To: CF-Talk Subject: Login/Password screen Hi, I know there are alot of custom tags out there that will do what I'm looking for but I want the best one. So this is why I'm asking all of you hoping you've had some experience with some of them. I'd like everything stored in a database. I know some don't do that. Bascially, once the user enters in their username/password they are redirected to a URL on the server based on the authentication. I have one called CF_EzPassword but was wondering if there are any better ones? Thanks --- 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
Re: Login/Password screen
On Fri, 13 Dec 2002 13:48:25 +0100, Jochem van Dieten wrote: Quoting FlashGuy [EMAIL PROTECTED]: I know there are alot of custom tags out there that will do what I'm looking for but I want the best one. So this is why I'm asking all of you hoping you've had some experience with some of them. I'd like everything stored in a database. I know some don't do that. Bascially, once the user enters in their username/password they are redirected to a URL on the server based on the authentication. I have one called CF_EzPassword but was wondering if there are any better ones? Can you post a full list of requirements? - validate users - database for authenitcation - redirection to different URLS on server based on authentication - username/password/IP/login time/logout time/ logging to database - force all users to the login screen regardless of shortcut on desktop which points to a URL off \inetpub\wwwroot\ Jochem ~| 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
Re: Login/Password screen
On Fri, 13 Dec 2002 14:30:01 +0100, Jochem van Dieten wrote: Quoting FlashGuy [EMAIL PROTECTED]: On Fri, 13 Dec 2002 13:48:25 +0100, Jochem van Dieten wrote: Can you post a full list of requirements? - validate users - database for authenitcation - redirection to different URLS on server based on authentication - username/password/IP/login time/logout time/ logging to database - force all users to the login screen regardless of shortcut on desktop which points to a URL off \inetpub\wwwroot\ - encryption over the wire? - encryption/hashed in database? Sure. - form or HTTP based? Either one. - multiple simultaneous logins allowed? Absolutely. - password recovery module? Not necessary. Jochem ~| 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.
Re: Login/Password screen
I'll take a stab at it. Thanks On Fri, 13 Dec 2002 07:22:51 -0600, Clint Tredway wrote: What I do is create a file called session.cfm. In there I check for a specific session variable. If that variable is there, I let the user go on their way. If that variable is not there, I send them back to the login screen or what ever screen is needed. If you need help with this, just let me know. HTH Clint - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 13, 2002 7:15 AM Subject: RE: Login/Password screen That part is no problem. Its what I need to put into the application.cfm to timeout or after 2-3 attempts lock the user out. Also once they log in they might drag a shortcut to their desktop which would bypass my index.cfm in the root that has the authentication code. How can I force them to the login screen everytime regardless if they dragged a shortcut? On Fri, 13 Dec 2002 13:10:45 -, Craig Dudley wrote: That's quite simple to code yourself, why don't you give it a try and post any questions here if you get stuck? Just pass a username and password from a from into a query, if a matching record is found, the queries record count will be 1 and you can authenticate the user, that's quite simplistic but basically all you need. Have a go, you know you want to ;-) -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 13 December 2002 12:43 To: CF-Talk Subject: Login/Password screen Hi, I know there are alot of custom tags out there that will do what I'm looking for but I want the best one. So this is why I'm asking all of you hoping you've had some experience with some of them. I'd like everything stored in a database. I know some don't do that. Bascially, once the user enters in their username/password they are redirected to a URL on the server based on the authentication. I have one called CF_EzPassword but was wondering if there are any better ones? Thanks --- 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
RE: Login/Password screen
I'm currently using NT authentication for another application. I just don't want to create accounts for this application because I don't want to give access to out technical support. This login stuff is needed just for a intranet app. On Fri, 13 Dec 2002 08:32:45 -0600, Kevin Graeme wrote: Keep in mind that a CF based authentication system is only checked against if the user hits a CFM page. That's fine for certain types of projects, but not for actual file security. So if you have a directory of images in the secure area, a person could link directly to an image and bypass the login altogether because a .gif doesn't reference the Application.cfm first. We've been using the server level authentication and then using cf to check against the cgi.remote_user to see who it is. That means that ANY attempt to get in at that protected area has to be authenticated against with the server. -Kevin -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 6:43 AM To: CF-Talk Subject: Login/Password screen Hi, I know there are alot of custom tags out there that will do what I'm looking for but I want the best one. So this is why I'm asking all of you hoping you've had some experience with some of them. I'd like everything stored in a database. I know some don't do that. Bascially, once the user enters in their username/password they are redirected to a URL on the server based on the authentication. I have one called CF_EzPassword but was wondering if there are any better ones? Thanks --- 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
Updating two fields
Hi, I need to update two fields in my database. For example, I have two fields called data1 and data2. THe below code updates only data1 field. Whats the correct syntax to also update data2 field at the same time? cfquery name=Update datasource=db dbtype=ODBC UPDATE tblField SET data1='Yes' WHERE strUsername='test' /cfquery --- 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.
Querying a database
Hi, Can the below be easily done from a database? The idea would be to add/remove directories from the database which would be inserted in the code below. This is just a snippet from my cfdirectory cfloop index=LineNo from=#i# to=#i# cfif Session.stDirFileType[i] eq Dir OR cfif ListFindNoCase(cdfiles,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(eps,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(inetpub,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(mywork,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(restored files,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(restored,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(system volume information,listLast(#Session.stDirFileName[i]#, .)) OR ListFindNoCase(usr,listLast(#Session.stDirFileName[i]#, .)) cfelse cfinclude template=/intincludes/directory-list.cfm /cfif /cfif /cfloop --- 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.
Stripping variable
Hi, I have the following variable (which can change based on directory). Below is the output from some examples: dir = D:\mywork\temp dir1 = D:\mywork\temp\dir1 How can I output only temp or dir1 from the above variables? --- 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
CF and mySQL
There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute the updated code. Before: - cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('#FORM.env_var#', '#FORM.destination#') /cfquery After: --- cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', 'cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR') /cfquery --- 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
RE: CF and mySQL
I actually get the ? inserted into my two fields in the database. On Tue, 3 Dec 2002 15:23:58 -, Mike Townend wrote: Do you actually get the ? inserted into the DB or does the Query debug show a ? ? -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 3, 2002 15:17 To: CF-Talk Subject: CF and mySQL There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute the updated code. Before: - cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('#FORM.env_var#', '#FORM.destination#') /cfquery After: --- cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', 'cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR') /cfquery --- 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
RE: CF and mySQL
Yes, the FORM.destination but thats the reason for the cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR Yet the ? are being inserted. On Tue, 3 Dec 2002 15:26:18 -, Robertson-Ravo, Neil (RX) wrote: do any of the variables contain \ -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 15:17 To: CF-Talk Subject: CF and mySQL There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute the updated code. Before: - cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('#FORM.env_var#', '#FORM.destination#') /cfquery After: --- cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', 'cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR') /cfquery --- 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.
RE: CF and mySQL
I did and I still get ? inserted in the database? cfquery name=update_alias DATASOURCE=Alias UPDATE alias SET env_var = cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR, destination = cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR WHERE alias_ID = #FORM.alias_ID# /cfquery On Tue, 3 Dec 2002 09:42:22 -0600, Mark A. Kruger - CFG wrote: hehe. Get rid of the single quotes around your cfqueryparam it should NOT be: ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', it SHOULD be (cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR, You are inserting the placeholder. -Mark -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:17 AM To: CF-Talk Subject: CF and mySQL There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute the updated code. Before: - cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('#FORM.env_var#', '#FORM.destination#') /cfquery After: --- cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', 'cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR') /cfquery --- 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
RE: CF and mySQL
Yes I'm sure. I removed the env_var = cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR and put it back the way I had it before to env_var = '#FORM.env_var#'. Now this field gets inserted properly but the destination = cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR gets inserted as a ? It has to be the syntax of the SQL statement? I'm using the cfqueryparam on another database and it works great. On Tue, 3 Dec 2002 09:58:05 -0600, Mark A. Kruger - CFG wrote: H. Are you sure. Delete them all manually and try again. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:47 AM To: CF-Talk Subject: RE: CF and mySQL I did and I still get ? inserted in the database? cfquery name=update_alias DATASOURCE=Alias UPDATE alias SET env_var = cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR, destination = cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR WHERE alias_ID = #FORM.alias_ID# /cfquery On Tue, 3 Dec 2002 09:42:22 -0600, Mark A. Kruger - CFG wrote: hehe. Get rid of the single quotes around your cfqueryparam it should NOT be: ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', it SHOULD be (cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR, You are inserting the placeholder. -Mark -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:17 AM To: CF-Talk Subject: CF and mySQL There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute the updated code. Before: - cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('#FORM.env_var#', '#FORM.destination#') /cfquery After: --- cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', 'cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR') /cfquery --- 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
RE: CF and mySQL
Correct. Thats the reason for the cfqueryparam... On Tue, 3 Dec 2002 15:49:04 -, Robertson-Ravo, Neil (RX) wrote: doesn't mySQL use \ for something internally? I had a problem with it ages back can't remember what it was though! -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 15:45 To: CF-Talk Subject: RE: CF and mySQL Yes, the FORM.destination but thats the reason for the cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR Yet the ? are being inserted. On Tue, 3 Dec 2002 15:26:18 -, Robertson-Ravo, Neil (RX) wrote: do any of the variables contain \ -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 15:17 To: CF-Talk Subject: CF and mySQL There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute the updated code. Before: - cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('#FORM.env_var#', '#FORM.destination#') /cfquery After: --- cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', 'cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR') /cfquery --- 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.
RE: CF and mySQL
On Tue, 3 Dec 2002 17:00:38 +0100, Jochem van Dieten wrote: Quoting FlashGuy [EMAIL PROTECTED]: I did and I still get ? inserted in the database? cfquery name=update_alias DATASOURCE=Alias UPDATE alias SET env_var = cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR, destination = cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR WHERE alias_ID = #FORM.alias_ID# /cfquery Can you show us the query debug output? And you really should convert that last pass through variable into a cfqueryparam too. Even if the variable won't ever contain a \ like the destination field? Jochem ~| 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
RE: CF and mySQL
Got it. Thanks On Tue, 03 Dec 2002 11:07:55 -0500, FlashGuy wrote: Correct. Thats the reason for the cfqueryparam... On Tue, 3 Dec 2002 15:49:04 -, Robertson-Ravo, Neil (RX) wrote: doesn't mySQL use \ for something internally? I had a problem with it ages back can't remember what it was though! -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 15:45 To: CF-Talk Subject: RE: CF and mySQL Yes, the FORM.destination but thats the reason for the cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR Yet the ? are being inserted. On Tue, 3 Dec 2002 15:26:18 -, Robertson-Ravo, Neil (RX) wrote: do any of the variables contain \ -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 15:17 To: CF-Talk Subject: CF and mySQL There is something wrong with my syntax. I just converted my Access database over to mySQL. Whats wrong with the cfqueryparam? I get ? question marks inserted into the database when I execute the updated code. Before: - cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('#FORM.env_var#', '#FORM.destination#') /cfquery After: --- cfquery name=update_alias DATASOURCE=Alias Insert into alias (env_var, destination) VALUES ('cfqueryparam value=#FORM.env_var# cfsqltype=CF_SQL_LONGVARCHAR', 'cfqueryparam value=#FORM.destination# cfsqltype=CF_SQL_LONGVARCHAR') /cfquery --- 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.
Checking SESSION variable
Hi, I have session variable that contains the directory name session.strFileName. I also have another session variable session.ShowMe that contains multiple directory names (comma-delimited) which i'm setting from my database. Basically, i need to check if the directory session.strFileName exists in the variable session.showme. Example: session.strfilename = 'mywork' session.showme = 'c:\temp\dir1,c:\temp\dir2,c:\temp\mywork,c:\temp\mywork2' --- 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
Re: Checking SESSION variable
Actually, the session.strFileName would have no path in it. sesion.strFileName = Temp sesion.ShowMe = D:\Temp,D:\Test On Mon, 02 Dec 2002 11:11:43 -0500, Randell B Adkins wrote: CFIF LISTCONTAINSNOCASE(session.ShowMe,session.strFileName) I think this is what you are asking. sesion.strFileName = D:\Temp sesion.ShowMe = D:\Temp,D:\Test then the above CFIF statement should return TRUE [EMAIL PROTECTED] 12/02/02 11:08AM Hi, I have session variable that contains the directory name session.strFileName. I also have another session variable session.ShowMe that contains multiple directory names (comma-delimited) which i'm setting from my database. Basically, i need to check if the directory session.strFileName exists in the variable session.showme. Example: session.strfilename = 'mywork' session.showme = 'c:\temp\dir1,c:\temp\dir2,c:\temp\mywork,c:\temp\mywork2' --- 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
Re: CFEXECUTE and Perl Scripts
Have you tried modifying the Perl script to handle additional arguments being passed at the command prompt. I had a similar problem and fixed it by doing so. On Wed, 27 Nov 2002 14:28:19 -0500, David Adams wrote: I am having a hard time calling a PERL script from a CFEXECUTE tag. It seems to not accept more than one argument. For example the following code with FAIL: cfexecute name=C:\perl\bin\perl.exe arguments=c:\scripts\run_myPERLapp.pl http://www.cnn.com; timeout=10 /cfexecute The following code will WORK but I cannot pass it a second or third argument: cfexecute name=C:\perl\bin\perl.exe arguments=c:\scripts\run_myPERLapp.pl timeout=10 /cfexecute Any ideas? Dave adams CFUG Ottawa ~| 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
Re: Listing/adding/deleting checkboxes generated from database - CONTINUED THREAD
Hi, Currently I have the following fields in my database: Database name: test table: tblprofiles fields: strUser_ID (auto-generated) strUserName strGroup strSelect strSelectFlag strShow Contents of above fields for example purposes: strUser_ID (auto-generated) = '1' strUserName = 'test' strGroup = '' strSelect = 'D:\documents\dir1,D:\documents\dir2,D:\documents\dir3,D:\documents\dir4,D:\documents\dir5,D:\mywork\dir1,D:\mywork\dir2, D:\mywork\dir3,D:\mywork\dir4,D:\mywork\dir5,D:\temp\dir2,D:\temp\dir3,D:\temp\dir4,D:\temp\dir5' strSelectFlag = 'Yes' strShow = 'D:\temp\dir1,D:\temp\dir3' I read in the strSelect string and display only those fields that don't match the strShow field. The above would display the following on my template page: Select the directory(s) to SHOW: [ ] dir2 [ ] dir4 [ ] dir5 Select the directory(s) to ADD: [ ] dir1 [ ] dir3 [ UPDATE ] What I would like to do is rather than have the listing appear in the ADD are above I would like those selections to appear under the SHOW listing but have only those items that have been selected marked with a checkbox. Example: [x] dir1 [ ] dir2 [x] dir3 [ ] dir4 [ ] dir5 If additional items are selected then the database is updated accordingly and a list created with those check boxes checked based on the selection. I am willing to send my code and database to anyone willing to give me a hand.? Thanks --- 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.
Re: Listing/adding/deleting checkboxes generated from database - CONTINUED THREAD
Hi everyone, Sorry, Please ignore this posting. On Mon, 25 Nov 2002 09:55:11 -0500, FlashGuy wrote: Hi, Currently I have the following fields in my database: Database name: test table: tblprofiles fields: strUser_ID (auto-generated) strUserName strGroup strSelect strSelectFlag strShow Contents of above fields for example purposes: strUser_ID (auto-generated) = '1' strUserName = 'test' strGroup = '' strSelect = 'D:\documents\dir1,D:\documents\dir2,D:\documents\dir3,D:\documents\dir4,D:\documents\dir5,D:\mywork\dir1,D:\mywork\dir2, D:\mywork\dir3,D:\mywork\dir4,D:\mywork\dir5,D:\temp\dir2,D:\temp\dir3,D:\temp\dir4,D:\temp\dir5' strSelectFlag = 'Yes' strShow = 'D:\temp\dir1,D:\temp\dir3' I read in the strSelect string and display only those fields that don't match the strShow field. The above would display the following on my template page: Select the directory(s) to SHOW: [ ] dir2 [ ] dir4 [ ] dir5 Select the directory(s) to ADD: [ ] dir1 [ ] dir3 [ UPDATE ] What I would like to do is rather than have the listing appear in the ADD are above I would like those selections to appear under the SHOW listing but have only those items that have been selected marked with a checkbox. Example: [x] dir1 [ ] dir2 [x] dir3 [ ] dir4 [ ] dir5 If additional items are selected then the database is updated accordingly and a list created with those check boxes checked based on the selection. I am willing to send my code and database to anyone willing to give me a hand.? Thanks --- 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