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 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
