09
Jun
Jun
I get a type mismatch, simple script.
Code:
<script language="vbscript" runat="server">
CustID=Request.QueryString("CustID")
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; "& "Data Source=" & Server.MapPath("/Data/Orders.mdb")
Set OrderData=Server.CreateObject("ADODB.RecordSet")
OrderData.CursorType = 3
OrderData.CursorLocation = 3
OrderData.ActiveConnection = conn
OrderData.Open("Select OrderID From Orders where CustomerID=’"+CustID+"’")
OrdID=OrderData.Fields("OrderID")
OrderData.Close
OrderData.Open("Select ProductID From Items where OrderID=’"+OrdID+"’")
RespStr=OrderData.GetString
Response.Write(RespStr)
</script>The highlighted line causes the error…
The table Orders contains 2 columns and 1 record
OrderId (autonumber)
50
CusomerID
856564321986757 (Sess. var, global.asa, type text, temp customer ID)
The table Items contains 2 columns and 4 records (both columns text)
OrderID
50
50
50
50
ProductId
7463547
9283745
9283547
0298083
The tables are related via OrderID.
This script is serverside ajax.
30,000 Mb And Unlimited Bandwidth Only $3.75/mo.
Powered By: BigInfo.org
Relevant Links