Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'AND'.
|
| |
The error occurred in C:\Inetpub\wwwroot\Webspace\merchant-gourmet.com\www\includes_merchant_gourmet\leftnav.cfm: line 85
Called from C:\Inetpub\wwwroot\Webspace\merchant-gourmet.com\www\includes_merchant_gourmet\header.cfm: line 46
Called from C:\Inetpub\wwwroot\ma\osb\merchants\101\headerinfo.cfm: line 2
Called from C:\Inetpub\wwwroot\ma\osb\header.cfm: line 47
Called from C:\Inetpub\wwwroot\ma\osb\itemdetails.cfm: line 122
Called from C:\Inetpub\wwwroot\Webspace\merchant-gourmet.com\www\includes_merchant_gourmet\leftnav.cfm: line 85
Called from C:\Inetpub\wwwroot\Webspace\merchant-gourmet.com\www\includes_merchant_gourmet\header.cfm: line 46
Called from C:\Inetpub\wwwroot\ma\osb\merchants\101\headerinfo.cfm: line 2
Called from C:\Inetpub\wwwroot\ma\osb\header.cfm: line 47
Called from C:\Inetpub\wwwroot\ma\osb\itemdetails.cfm: line 122
|
83 : SELECT MemberOf,CATEGORY
84 : FROM CATEGORIES
85 : WHERE ID=#rootCategory#
86 : AND Active=1
87 : ORDER by Category ASC, ID
|
|
| SQL |
SELECT MemberOf,CATEGORY
FROM CATEGORIES
WHERE ID=
AND Active=1
ORDER by Category ASC, ID
|
| DATASOURCE |
OSB_101 |
| VENDORERRORCODE |
156 |
| SQLSTATE |
HY000 |
|
|
Please try the following:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.18 |
| Referrer |
|
| Date/Time |
09-May-08 01:54 PM |
|