validate text field to db field

jtesolin · #1 Jul 7th, 2006, 00:30

Hello. I am in the process of creating a login script that once users enter in a code, and submit it the asp script will then check what was entered againsty a database. My code isnt working amd from what i know there are no errors. Everything shows up but the lines in certain if statements

Code is attached in a text file.

daninmanchester · #2 Jul 18th, 2006, 17:48

I think you are approaching this wrong.
Ideally you should be using an SQL parameterised query with an ADODB Command although you could use dynamic SQL but it's open to attack so you need to sanitise your user input.

This is the dynamic SQL version which is a bit simpler but I suggest you look into parameters and SQL.

Code: Select all

 
strSQL = "SELECT * "
strSQL = strSQL & " FROM dealercode "
strSQL = strSQL & " WHERE DealerCode = " & replace(user_code,"'","''")
set RS = Conn.Execute(strSQL)
If rs.eof then
       ' code not found
else
       ' code found
end if

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
making text field text disapear	Phixon	JavaScript Forum	4	Feb 2nd, 2008 07:49
[SOLVED] Validate name field	Graisbeck	PHP Forum	2	Jan 13th, 2008 15:26
Need javascript to set input field value field	jdadwilson	JavaScript Forum	3	May 9th, 2007 04:47
Validate a certain field content	Syd	JavaScript Forum	6	Jan 1st, 2007 01:24
Non-text field Validation	NewDesigner	JavaScript Forum	6	Nov 24th, 2006 22:34

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
validate text field to db field