Errors in ASP Code

[Sean]

Ive cleaned the code up a wee bit to see if it makes it easier to spot were i've went wrong. Hope this helps, thanks agai
Sea
<
Option Explicit
Dim sDat
sDate = Request.Form("ReportByPubClass2"
dim dbcn, dbrs, byclassnopric
Set dbcn = server.CreateObject("ADODB.Connection"
set dbrs = server.CreateObject("ADODB.Recordset"
Set byclassnoprice = server.CreateObject("ADODB.Command"
dbcn.open Application ("connectionString"
byclassnoprice.ActiveConnection = dbc
byclassnoprice.CommandType = adCmdStoredPro
byclassnoprice.CommandText = "ByClassPUBCLASS

Dim objParam,adDat
set objParam = byclassnoprice.CreateParamete
objParam.Name = "@t_week_end_date
objParam.Type = adDat
objParam.Direction = adParamInpu
objParam.Value = t_week_end_date.Tex
byclassnoprice.Parameters.Append objPara

dbrs = byclasspubclass.Execute

dim sHTM
if rs.eof the
response.write "No records were returned
els
Response.Write "<table border=1><tr><td>
sHTML=rs.GetString(2,,"</td><td>",
"</td></tr><tr><td>", "NA"
sHTML = Left(sHTML, len(sHTML) - 8
response.Write sHTM
response.write "</table>
End i
dbrs.Close: set dbrs = nothin
dbcn.close: set dbcn = nothin
%><form name="accounting" method="post" action="testing.asp"><%sDate%><p>Please Enter a Weekending Date
<input type="text" name="t_week_end_date"></p><p><input type="submit" name="ReportByPubClass2" value="View Report"></p></form
Errors:
Microsoft VBScript runtime error '800a01f4'
Variable is undefined: 'adCmdStoredProc'
/testing.asp, line 23

ADODB.Parameter error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/testing.asp, line 30

[McKirahan]

"Sean" <S.Cairns@belfasttelegraph.co.uk> wrote in message
news:2A67FA63-7F3C-44C9-A8AE-6B554F093334@microsoft.com...

> Ive cleaned the code up a wee bit to see if it makes it easier to spot

were i've went wrong. Hope this helps, thanks again

> Sean

[snip]

Stop creating a new post each time!

So far you have the same basic question under:
ASP still having problems
ASP errors
Errors in ASP Code

Just hit "Reply Group" when responding to a reply!