In this script: line 12 causes a type mismatch error. Anybody know why?
1 <script language="vbscript" runat="server">
2 CustID=Request.QueryString("CustID")
3 Set conn=Server.CreateObject("ADODB.Connection")
4 conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; "& "Data
Source=" & Server.MapPath("/Data/Orders.mdb")
5 Set OrderData=Server.CreateObject("ADODB.RecordSet")
6 OrderData.CursorType = 3
7 OrderData.CursorLocation = 3
8 OrderData.ActiveConnection = conn
9 OrderData.Open("Select OrderID From Orders where CustomerID= "+CustID+" ")
10 OrdID=OrderData.Fields("OrderID")
11 OrderData.Close
12 OrderData.Open("Select ProductID From Items where OrderID= "+OrdID+" ")
13 RespStr=OrderData.GetString
14 Response.Write(RespStr)
15 </script>
This is a server script for an AJAX request.
Thx for the effort- this was the fix:
<script language="vbscript" runat="server">
CustID=Request.QueryString("CustID")
Set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0;"
conn.Open="/inetpub/wwwroot/hawksweb/Data/Orders.mdb"
Set OrderData=Server.CreateObject("ADODB.RecordSet")
OrderData.ActiveConnection = conn
OrderData.Open("Select OrderID From Orders where CustomerID= "+CustID+" ")
OrdID=OrderData.Fields("OrderID")
<strong>OrdID=cstr(OrdID)</strong>
OrderData.Close
OrderData.Open("Select ProductID From Items where OrderID= "+OrdID+" ")
RespStr=OrderData.GetString
OrderData.Close
Response.Write(RespStr)
</script>
excuse the <strong> tag was trying to make it bold.
what is the difference between Diomedes and Ajax?? ( iam reading the Trojan War ). feel free to tell me anything else important about the Iliad or the Odyssey. thanks.
Does anybody know if there are any recordings of the famous Mark Twain playing his guitar?
Mark Twain- guitarist- singer- and literary legend- was first exposed to music by his sister Pamilla. She supplemented the family income by teaching guitar and piano. He obtained his guitar used in 1861 (in 1835 it was $10 new) and kept it in close company until shortly before his death in 1910.
He sang and played for newspaper men of the Nevada Territories- miners from California s Gold Rush days and for passengers aboard Ajax- a clipper ship bound for the Hawaiian Islands. But mostly he played for the willing women of the West. In December 1866- Mark Twain brought his Martin 2 ½-17 guitar aboard the steamer America and sailed from San Francisco to New York City- where he would seek his fortune.
Totally Controversary [Ajax]
Imprinted by Sockett [Kelo]
Miesters Rope Burn [Titan]
Because I m Shakespeare [Shakespeare]
I m good friends with the owners of those horses-
and i ride ajax and shakespeare.
i doubt anybody knows who they are-
but if you do- thats awesome.
I wrote a commenting script in php- mysql- and ajax and would like to package it and sell it! What type of source code or software license would i need to sell this script on hotscripts.com or other similar website! Thank you for your help!
I am asking around $49.90 for a 1 domain license? It s a digg like commenting system I wrote for a website I m developing- you can view the commenting system at mythkillers.com... just click on a few topics!
There may be alot of free ones out there but there is no commenting system like available anywhere on the net!
No comments:
Post a Comment