Currency/Number related Syntax Error with Shipping Rates (Advanced Edition)
Sample Error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'ratetype=2 AND carrierid=1 AND fromnum<=0,5 AND tonum>=0,5'. /includes/functions.asp, line 1561
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'ratetype=2 AND carrierid=1 AND fromnum<=0,5 AND tonum>=0,5'. /includes/functions.asp, line 1561
Solution or Workaround
Since every server has different default regional settings, it is possible certain LCIDs (under certain conditions) can produce this 'Syntax error'. It is a complex problem resulting for the server's region settings, the current LCID, and the database driver. What works on most servers, may not work on some.
A workaround is available in the latest revision of the Advanced Edition, check your account for this download (4.015 or higher)
If you require further assistance, please contact PageDown Tech support (see link below), we may be able to provide you with a customized script.
A workaround is available in the latest revision of the Advanced Edition, check your account for this download (4.015 or higher)
If you require further assistance, please contact PageDown Tech support (see link below), we may be able to provide you with a customized script.
Related Articles
Other Resources
Related Topics
Article Applies to:
PDshop Advanced
Search for help...