Hello,
I am trying to display data from an access DB.
The user chooses a name from a list that is populated from the DB and then clicks "next"
Then I have a page that I am trying to display all the details about that record and I am getting the error: "Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ClientName = BAKALA - 1702A75130'.
/ccs/HVACServiceOrder/Servicedetails.asp, line 50 "
Here is the code for the page
I am trying to display data from an access DB.
The user chooses a name from a list that is populated from the DB and then clicks "next"
Then I have a page that I am trying to display all the details about that record and I am getting the error: "Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ClientName = BAKALA - 1702A75130'.
/ccs/HVACServiceOrder/Servicedetails.asp, line 50 "
Here is the code for the page
Code:
<%@ language ="JScript"%>
<!-- #include file="adojavas.inc" -->
<html>
<head>
<title>
Coastasl Carolina Specialty
</title>
<link href="CCSStyleHVAC.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
var cname = Request.form("vendna");
%>
<div id="">
<img src="../Images/Banner.jpg" />
</div>
<div id="MenuBanner">
<img src="../Images/MenuBanner.jpg">
<div id="Navigation">
<ul>
<li><a href="#">Home</a></li>
<li><a href="#">About Us</a></li>
<li><a href="#">Contact Us</a></li>
<li><a href="#">Links</a></li>
</ul>
</div>
</div>
<div id="MainBG">
<img src="../Images/MainBG2.jpg">
<div id="MainFrame">
</div>
<div id="Loginform" align="center">
<form onSubmit="return validForm(this)" action="ud.asp" name='getInfo' method="post" >
<%
var code;
var connect = Server.CreateObject("ADODB.Connection");
var recordSet = Server.CreateObject("ADODB.RecordSet");
connect.Open("DSN=CCSHVAC");
recordSet.Open("select * from ClientDetails" +" where ClientName = " + cname + "" , connect,adOpenKeyset,adLockOptimistic);
%>
<table border="1" id="inputData" bgcolor="#cee4e6" align="center">
<tr>
<td>Client Name
</td>
<td>
<%=cname%>
</td>
</tr>
<tr>
<td>Street
</td>
<td>
<%=Street%>
</td>
</tr>
<tr>
<td>City
</td>
<td>
<%=City%>
</td>
</tr>
<tr>
<td>Phone Number
</td>
<td>
<%=PhoneNumber%>
</td>
</tr>
</table>
<BR><BR>
<input on type="submit" value="PROCEED">
</form>
</div>
</div>
</body>
</html>