I'm new to ASP and Im trying to make a small DB editing page... I keep getting the Data type mismatch in criteria expression. error whenever I add a where expression in my SQL statment.+
<html>
<head>
<title>Bavant Marine Services: Technician Master List</title>
<style>
td.title{background-color=skyblue}
</style>
<script language=Vbscript>
<!--
Function fnUpdateFrm()
document.frmDB.txtTechnumber.value=Response.write( techno(0))
document.frmDB.txtFirstN.value=Response.write(tech no(1))
document.frmDB.txtLastN.value=Response.write(techn o(2))
end function
-->
</script>
</head>
<body>
<%
sql="SELECT Technician.TechNumber, Technician.LastN, Technician.FirstN, Technician.Address, Technician.City, "&_
"Technician.State, Technician.Zip, Technician.HourlyRate, Technician.YTD, Technician.StartDate, Technician.Specialities, "&_
"Technician.Picture, Technician.WebPage FROM Technician WHERE Technician.TechNumber=36"
set conn = Server.CreateObject("ADODB.Connection")
conn.open "BMS"
set techno=conn.execute(sql)
%>
<form value=frmDB>
<table cellspacing=2 cellpadding=0 bordercolor=black border=0>
<tr>
<td class=title>Tech Number:<td><input type=text name=txtTechNumber value=<%= techno(0)%> size=2>
<tr>
<td class=title>Last Name:<td><input type=text name=txtLastN value=<%= techno(1)%>>
<tr>
<td class=title>First Name:<td><input type=text name=txtFirstN value=<%= techno(2)%>>
<tr>
<td class=title>Address:<td><input type=text name=txtAddress value=<%= techno(3)%>>
<tr>
<td class=title>City:<td><input type=text name=txtCity value=<%= techno(4)%>>
<tr>
<td class=title>State:<td><input type=text name=txtState value=<%= techno(5)%>>
<tr>
<td class=title>Zip:<td><input type=text name=txtZip value=<%= techno(6)%>>
<tr>
<td class=title>Hourly Rate:<td><input type=text name=txtRate value=<%= techno(7)%>>
<tr>
<td class=title>YTD Earnings:<td><input type=text name=txtYTD value=<%= techno(8)%>>
<tr>
<td class=title>Start Date:<td><input type=text name=txtStart value=<%= techno(9)%>>
<tr>
<td class=title>Specialities:<td><textarea rows=8 name=txtSpecialties><%= techno(10)%></textarea>
<tr>
<td><input type=button name=cmdSave value="Save">
</form>
</body>
</html>
dBforums
>
Data type mismatch in criteria expression.
02-14-03, 02:30
Thanks
Linear Mode
