|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Sql problem |
|
From: |
Jason |
|
Date: |
8/25/1999 2:07:46 PM |
|
IP: |
207.223.192.9 |
I was wondering if anyone could give me some insight into what might be happening here. I have an asp application that I am working on for a client it uses a combination of session variables and form items. I run a sql query from one page (it works and lists the data) when I post accross to the output page it gives me this:
Microsoft OLE DB Provider for ODBC Drivers error 80040e10
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/newoutput.asp, line 39
And here is the code snippet:
<%
Dim sql, rso, counter, maxcount, pagecount, endcount, startcount
sql = BuildSQL
Set rso = Server.CreateObject("ADODB.Recordset")
rso.ActiveConnection = mydbo
rso.CursorType = adOpenStatic
LINE 39=> rso.Open sql
%>
I am going bald pulling my hair out any help would be most appreciated.
Thank you,
Jason Thomson
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
