Error Executing Database Query.
|
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
|
|
The error occurred in D:/home/djsauctions.com/wwwroot/item.cfm: line 17
|
15 : <CFQUERY NAME="ITEMINFO" DATASOURCE="DJS" MAXROWS="1">SELECT * FROM lots WHERE lot = #item#</CFQUERY>
16 :
17 : <CFQUERY NAME="GETCAT" DATASOURCE="DJS" MAXROWS="1">SELECT * FROM CATEGORY WHERE ID=#ITEMINFO.CATEGORY#</CFQUERY>
18 :
19 : <CFQUERY NAME="GETCATEGORIES" DATASOURCE="DJS">SELECT * FROM CATEGORY ORDER BY ID ASC</CFQUERY>
|
|
SQLSTATE |
42000 |
DATASOURCE |
DJS |
VENDORERRORCODE |
1064 |
SQL |
SELECT * FROM CATEGORY WHERE ID= |
|
Resources:
|
Browser |
claudebot |
Remote Address |
35.175.200.199 |
Referrer |
|
Date/Time |
29-Mar-24 06:25 AM |
|