VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Comments about VP-ASP
 Anybody out there! S.O.S HELP!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

peebee
Starting Member

USA
30 Posts

Posted - March 13 2002 :  12:52:28  Show Profile  Reply with Quote
We fixed our database problems with read and write.
But we ran into some other difficulties. It worked great before but for some odd reason it stopped. This is the problem:

Microsoft JET Database Engine error '80040e14'

Syntax error in ORDER BY clause.

/shopping/shop$db.asp, line 424

This is what's on line 424 in shop$db.asp

if getconfig("xdebug")="Yes" then
DebugWrite mysql
end if
rstemp.Open MYSQL,dbc,adOpenKeyset,adLockReadOnly, adCmdText
if not rstemp.eof then
rstemp.movefirst
rstemp.pagesize=mypagesize
maxpages=cint(rstemp.pagecount)
maxrecs=cint(rstemp.pagesize)
rstemp.absolutepage=mypage
end if
end sub

What is it that we need to change?

Thank you for a prompt response.



  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000