User Guide
Adding and Updating the Shopping Cart 109
Testing and Trouble Shooting the
Shopping Cart
Once you have added and configured the shopping pages, you are ready to test the
shopping cart connection to the products (source) and orders (destination)
database tables. To test the shopping area, you must publish the site to an ASP-
compatible server. To help you test and trouble shoot, here is table with the most
common run-time errors and their solutions.
Error message in
browser
Typical Cause Solution
sourceCol is undefined Manually adding columns to
the Data-Map content table
and improperly binding the
Shopping Cart
SmartElement.
After adding columns to the
Data-Map, activate the
Shopping Cart’s attributes and,
under the Content attribute,
ensure all columns are set to
‘show these columns’.
ADODB.Fields error
800aOcc1
ADO could not find the
object (in this case name-
value pair) requested by the
page. This is usually caused
by a typo or non-existent
column in the source and/or
destination database tables.
Verify each column in the Data-
Map, paying special attention
to the first two rows. Be sure
that any values not equal to
‘none’ match the name of the
corresponding database-table
column. If it does and you still
get this error, make sure the
recordset reflects the intend
query. If it does not, edit the
query and include the desired
columns.
ADO Errors Occured The insertion of a new order
in the orders record or the
Shopping Cart contents in
the OrdersDetail record is
violating a database field
constraint. In some cases,
this happens because a
required field in the database
is not being bound to the
recordset for inserting, or
because the data type or
value of the individual field
in not the proper data type
or is a value that violates
field requirement.
Check that all required fields in
the database have a
corresponding source in the
web page that is properly
bound to the recordset used
for inserting. If you do not
need to insert to a field in the
database, make sure that there
are no constraints such as
disallowing zero length for text
fields.