Ive created a basic ASP file, incorporating WML to select an employee from a 'company' database and allow them entry into the WAP site. I have configured my DSN already to the database i want to work with. My code is below:
<%Response.ContentType = "text/vnd.wap.wml" %>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
<card id="menu" title="menu">
dim dbConn, sql, empl
set dbConn = Server.CreateObject("ADODB.Connection"
sql = "SELECT * FROM tblEmpl WHERE username='ctull' AND password='232456'"
set empl = EOF then
Response.Write "You have entered an invalid login."
Response.Write "Welcome, " & empl("fname"
set empl = Nothing
set dbConn = Nothing
The result i get from the Nokia Simulator, and any other simulator for that fact is a compilation error. I dont think theres anything wrong with my database as it looks to be correct. I have only one table called 'empl' listing the employees. As you can tell from the above code i want to select the employee 'ctull' with password '232456'. This entry exists in my database!
Any solutions..??? Much appreciated. Thanks.