Hello,
I am connecting to a database and trying to display data based on user input from a form .
I want a user to type a PO number into a form and then the code will return the data relevent to that PO Number.
The issue I am having is I am getting a data type mismatch error when I try to math the user input to the database PO Number. The DB PONumber is an Auto Number.
I am connecting to a database and trying to display data based on user input from a form .
I want a user to type a PO number into a form and then the code will return the data relevent to that PO Number.
The issue I am having is I am getting a data type mismatch error when I try to math the user input to the database PO Number. The DB PONumber is an Auto Number.
Code:
<%@ LANGUAGE="JScript"%>
<!-- #include file="adojavas.inc" -->
<HTML>
<HEAD>
<TITLE>View PO Numbers</TITLE>
</HEAD>
<%
var PONumber = Request.Form("POChoice")
var recordSet = Server.CreateObject("ADODB.RecordSet");
recordSet.Open("select * from Data"+" WHERE PONumber ='" + PONumber + "'", "DSN=ccspo");
Response.Write(PONumber)
%>
<body>
<img src="smallCCSLOGO.jpg" />
</script>
</body>
</html>