|
 |
access_asp thread: Microsoft VBScript compilation error '800a03ea'
Message #1 by "Laurie Kratochvil" <vlaurie@s...> on Fri, 27 Sep 2002 22:26:51
|
|
Microsoft VBScript compilation error '800a03ea'
Syntax error
/Chestnut/shoppingcart.asp, line 48
objRec.Open "Order Details", strConnect,
<%
Dim objConn
Dim objRec
Set objConn = Server.CreateObject ("ADODB.Connection")
Set objRec = Server.CreateObject ("ADODB.Recordset")
objConn.Open strConnect
objRec.Open "Order Details", strConnect,
adOpenStatic, adLockReadOnly, adCmdTable
objRec.MoveFirst
Response.Write CreateTable (objRec)
%>
Message #2 by "Larry Woods" <larry@l...> on Fri, 27 Sep 2002 19:03:18 -0700
|
|
I am assuming that you are asking for a solution. If your
Recordset Open is on TWO lines without a continuation then that's
a "No-No!" I am also assuming that you have defined the "ad..."
constants somewhere in your code.
Hope this helps...
Larry Woods MCSD, MCT
l.woods, inc.
> -----Original Message-----
> From: Laurie Kratochvil [mailto:vlaurie@s...]
> Sent: Friday, September 27, 2002 10:27 PM
> To: Access ASP
> Subject: [access_asp] Microsoft VBScript compilation
> error '800a03ea'
>
>
> Microsoft VBScript compilation error '800a03ea'
>
> Syntax error
>
> /Chestnut/shoppingcart.asp, line 48
>
> objRec.Open "Order Details", strConnect,
>
> <%
> Dim objConn
> Dim objRec
>
> Set objConn = Server.CreateObject ("ADODB.Connection")
> Set objRec = Server.CreateObject ("ADODB.Recordset")
>
> objConn.Open strConnect
> objRec.Open "Order Details", strConnect,
> adOpenStatic, adLockReadOnly, adCmdTable
> objRec.MoveFirst
>
> Response.Write CreateTable (objRec)
> %>
>
Message #3 by Laurie <vlaurie@s...> on Fri, 27 Sep 2002 20:47:52 -0600
|
|
Thanks Larry! That was exactly what I needed.
-----Original Message-----
From: Larry Woods [mailto:larry@l...]
Sent: September 27, 2002 8:03 PM
To: Access ASP
Subject: [access_asp] RE: Microsoft VBScript compilation error
'800a03ea'
I am assuming that you are asking for a solution. If your
Recordset Open is on TWO lines without a continuation then that's
a "No-No!" I am also assuming that you have defined the "ad..."
constants somewhere in your code.
Hope this helps...
Larry Woods MCSD, MCT
l.woods, inc.
> -----Original Message-----
> From: Laurie Kratochvil [mailto:vlaurie@s...]
> Sent: Friday, September 27, 2002 10:27 PM
> To: Access ASP
> Subject: [access_asp] Microsoft VBScript compilation
> error '800a03ea'
>
>
> Microsoft VBScript compilation error '800a03ea'
>
> Syntax error
>
> /Chestnut/shoppingcart.asp, line 48
>
> objRec.Open "Order Details", strConnect,
>
> <%
> Dim objConn
> Dim objRec
>
> Set objConn = Server.CreateObject ("ADODB.Connection")
> Set objRec = Server.CreateObject ("ADODB.Recordset")
>
> objConn.Open strConnect
> objRec.Open "Order Details", strConnect,
> adOpenStatic, adLockReadOnly, adCmdTable
> objRec.MoveFirst
>
> Response.Write CreateTable (objRec)
> %>
>
|
|
|
View Cart
