WritePagination

Phil,
I guess some kind of error happens on this page. To see exact error message open ..._list.asp file in any text editor

and change the following line:

On Error Resume Next

to

'On Error Resume Next

After that you can run this page again and see error message which you can post here.

Technical information

Error number -2147217900

Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'and'.

URL /Purchasing/EW/depot/General_edit.asp

SQL query select PO,PO ,Date ,Requisition ,Department ,Vendor ,Amount ,Paid ,Invoice1 ,Invoice2 ,Invoice3 from [dbo].[General] where PO= and Requisition= and Department=
More info on this error

Phil,
your previous message refers to the List page while last one refers to the Edit page.
Which one do you like to resolve first?

Well the error appears on the list pages. When I goto switch display pages, like when I list 100 items per page. It lists the first page just fine but when I go next or choose the page number to display I get the WritePagination. When I click on the writePagination it comes up and displays the sql error that I posted

Phil,
I see what you saying.
What is the exact error message? To display error message use the method I explained in my first reply.

Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'Replace'
/Purchasing/EW/depot/include/General_aspfunctions.asp, line 875

Phil,
This error happens when key column value is NULL. You need to choose another column as key column or replace NULL value with any correct value.

Key column is the database column which lets you query each table row individually and modify each row without altering other rows in the same table. The values that compose a key column a unique; no two values are the same. Key column value cannot be NULL.

I keep getting this error too... I was wondering of you could elaborate on how to fix this error. I'm a first year computer science student.
Thanks for your help.
Lando

What is the answer for Lando's question. More detail in how to fix the error.

Thanks,

Dan

Do you mean column key as same as primary key?

Dan,
key column is the same as primary key column.
The answer is: avoid choosing columns with NULL or empty values as key columns in ASPRunner.