Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql question

Author  Topic 

ripper29
Starting Member

5 Posts

Posted - 2001-07-12 : 11:43:05
hello all,

I'm kinda new at this so this question might seem easy for some. I want to randomly select from a table and i'm using the following code (this is for an ASP project).

sql="select top 5 order_id from orders and order by orderdate desc"

and i keep getting the error...

"Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1."

Any kind of help will be great.
Thanks in advance.


   

- Advertisement -