hello <br><br>I tried to retrieve the values from database to a form, to modify the existing account, but am getting all the records not the one whom i request, can u pls.help am attaching code here <br><br>i had three files <br><br>1) login.htm 2) action.cfm (for checking the validity) 3) loginvalid.cfm (to retrieve specified user from database) <br><br>if u click on login button from login.htm page the if user exists it'll pass to the loginvalid.cfm if not it goes to action.cfm <br><br>am attaching the code of loginvalidity.cfm <br><br>do i need to use a hidden variable..if so tell me.how<br><br>am attaching my code of third form..ie., loginvalidity.cfm<br><br>============================================================<br><br>Attachments: <cfquery name="retrieve" datasource="bubblegum"><br> select *from userinfo,userdetails where userinfo.username=userdetails.username<br> </cfquery><br><br><input type="text" name="user" value= "#username#"<br><input type= "text" name="pass" value= "#password#"<br><br>but am getting all the records not the one<br><br>kindly rectify this..<br><br> <br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
need to retrieve and update fields in a form
- Thread starter sree
- Start date
I'm assuming that the user has filled out a username and password in the login.htm page....<br><br>In your select statement use<br><br>select * from userinfo,userdetails where userinfo.username=userdetails.username and userinfo.username='#form.user#' and userinfo.pass='#form.pass#'<br>
- Thread starter
- #3
sorry darkman may be am mistaken<br><br> i need to send those login and password values to another form which user has to modify his details, can u tell me how to pass that username and password to another form, which user had filled.<br><br><br>regards<br>sreedhar
Assuming they've filled out a form with their username and password, the above select statement should give you the record. If that info is coming from a session variable, or some other means, just change the '#form.user#' and '#form.pass#' to whatever variable hold that info...<br><br>The input boxes you showed:<br><FONT FACE=monospace><b><input type="text" name="user" value= "#username#"<br><input type= "text" name="pass" value= "#password#"</b></font><br>are missing the > at the end, which will cause problems in your output. Also, you should qualify the value portion like:<br><FONT FACE=monospace><b><br><cfoutput><br><input type="text" name="user" value= "#retrieve.username#"><br><input type= "text" name="pass" value= "#retrieve.password#"><br></cfoutput><br></b></font><br>or<br><FONT FACE=monospace><b><br><cfoutput query="retrieve"><br><input type="text" name="user" value= "#username#"><br><input type= "text" name="pass" value= "#password#"><br></cfoutput></b></font><br><br>If you'd rather these variables not show, do it like:<br><FONT FACE=monospace><b><cfoutput><br><input type="hidden" name="user" value= "#retrieve.username#"><br><input type= "hidden" name="pass" value= "#retrieve.password#"><br></cfoutput></b></font><br><br>Hope this helps....<br><br>DM
- Thread starter
- #5
thanq darkman<br><br> anyway i had completed by passing url parameter, <br><br> <cflocation = "loginvalid.cfm?username=#form.username#><br><br> it worked<br><br> is this better of hidden fields r better<br><br> thanq<br>
- Status
Similar threads
