![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| I am using the following script allowing users to login, but I am having trouble writing the portion that indicates an invalid username or password. Any thoughts? <% set conn=server.createobject("ADODB.connection") conn.open "DRIVER=MySQL ODBC 3.51 Driver;UID=;STMT=;OPTION=;PORT=;PASSWORD=;SERVER=; DATABASE=;DESC=;" strSqlString = "select count(*) as counter, ID from tblxxxxxx where username='"& request.form("Username") & "' and password=password('"& request.form("Password")&"') group by ID" set rs=conn.execute (strSQLString) if cint(rs("counter")) <> 1 then session("sblogin")=false session("sbuid")="" response.redirect("../system/login.asp") else session("sblogin")=true session("sbuid")=rs("id") %> | |||
|
| Featured Websites | ||||
|
![]() |
| Tags: aspmysql, invalid, login, script |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| cannot login to ebay...Help | Burnt Orange | Ebay Technical Questions | 4 | 05-31-2007 8:59 AM |
| Bypass the Login Screen ? | effdee | Windows | 1 | 05-28-2007 10:28 PM |
| Cannot login to university search | beheer@homodelft.nl | Google questions | 1 | 05-28-2007 12:46 AM |
| GTALK LOGIN BUT AS INVISIBLE MODE ?? | talktosunnysethi@gmail.com | Google questions | 1 | 05-28-2007 12:45 AM |
| Login and remember me | Mike | PHP | 2 | 05-20-2007 5:33 PM |
| Featured Websites | ||||
|