Hello,
I was finishing up a class project for school and was wondering if it is possible to pass the client side variables over to the server side asp. I keep getting a server error requesting the two missing variables :BDate & EDate. I didn't want to have to make a seperate asp page to request the info. Is this still possible?
<Script Language = "VBScript">
Dim date1, date2, BDate, EDate
date1 = InputBox("Enter the Start Date","Input Box", ,1000,1000)
date2 = InputBox("Enter the End Date","Input Box", ,1000,1000)
BDate = (date1)
EDate = (date2)
</SCRIPT>
<%
Dim objCom, oRS, strID
strID = Session ("ID")
Set objCom = Server.CreateObject ("ADODB.Command")
objCom.ActiveConnection = objConn
objCom.CommandText = "{CALL dbo.qViewOrders ('"&CStr(strID)&"','"&CDate(BDate)&"','"&CDate(EDate)&"')}"
objCom.CommandType = adCmdText
Set oRS = Server.CreateObject ("ADODB.Recordset")
Set oRS = objCom.Execute
%>
Enter your message below
Sign in or Join us (it's free).