Hi David:
You advice worked!... I now get another error and can't see anything wrong with the script
... I'm I going blind...
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'ORDER'.
/ssl/SFLIB/incAE.asp, line 2390
--------------------------------------------------------------------------------------------------
sql = "Select * FROM sfMTPrices WHERE mtprodid= '" & makeInputSafe(strProductID) & "' AND mtQUANTITY <= " & makeInputSafe(totqty) & " ORDER BY mtValue DESC"
Set rst = Server.CreateObject("ADODB.RecordSet")
rst.Open sql, cnn, adOpenStatic, adLockReadOnly, adCmdText
--------------------------------------------------------------------------------------------------
I would really appreciate your help. I'm sure many people have this problem.
O