Welcome, Guest ( Customer Panel | Login )




 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
0 Item(s)
$0.00