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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to create User ID & Password in VBScript? 1

Status
Not open for further replies.

00

Programmer
May 25, 2000
2
US
How do I code...comparison of the user entered ID & Password on my web page to the correct user ID & Password in my Access db?
 
You can use the SQL query..like<br>strqry = &quot;SELECT * FROM registration WHERE registration.userid = '&quot; & convertnull(Request.Form(&quot;Login&quot;)) &quot;' and registration.password='&quot; & convertnull(Request.Form (&quot;Password&quot;))& &quot;'&quot;<br><br><br>After this use strcomp to compare the strings..<br>Cheque the number of rows returned and the result of both string comparisions..[username & password]..and <br><b>Rest is Presto..:)))</b>
 
vinodgk (Programmer)<br><br>Thanks for your advice :eek:)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top