|
| Hello,
I am getting an error 4097 - Invalid column name. I
started getting this error after I had modified the
catalog.asp page to perform a sort on
a different column (This file is included in the site
solution package.) The following 3 steps is what I did so
that I could manipulate the order in which the products
would be displays
1) create a new catalogProducts' field via Bizdesk
2) populate the database (I used an integer data type to
sort by (1,2,3,4,5...)
3) modified the following lines of code within the
mscsGetProductList function (catalog.asp file)
sSortColumn = "ASFSortOrder"
nStartingRecord = (nPageNumber - 1) *
PRODUCTLIST_PAGE_SIZE + 1
If Not oCategory Is Nothing Then
Set mscsGetProductList = oCategory.Products(,
sSortColumn, nStartingRecord,PRODUCTLIST_PAGE_SIZE,
nOutRecordsTotal)
It works great (I am able to control which product is
displayed in any order). The problem is that every once
in awhile I would get the following error message.
Error Type: Commerce.CatalogManager
Page: /asf/category.asp
File: /asf/include/catalog.asp
Line:324
80040E14
Source:Microsoft OLE DB Provider for SQL
ServerDescription:Invalid column name 'ASFSortOrder'.
Any Suggestions
Thanks
Mark
|
|