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 > > > > > --------------------------------------------------- > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
