Error Executing Database Query.
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%20product_manu' at line 1
|
|
The error occurred in C:/home/goldcoastpower.com/wwwroot/product.cfm: line 115
Called from C:/home/goldcoastpower.com/wwwroot/product.cfm: line 42
Called from C:/home/goldcoastpower.com/wwwroot/product.cfm: line 1
Called from C:/home/goldcoastpower.com/wwwroot/product.cfm: line 115
Called from C:/home/goldcoastpower.com/wwwroot/product.cfm: line 42
Called from C:/home/goldcoastpower.com/wwwroot/product.cfm: line 1
|
113 : <!--- Get --->
114 : <CFQUERY Name="get" datasource="#var_datasource#" username="#var_username#" password="#var_password#">
115 : SELECT * FROM product WHERE product_type = '#url.product_type#' AND product_on_web = '1' <cfif #form.show# neq "All">AND vessel_type = '#form.show#'</cfif> ORDER BY #session.sort#
116 : </cfquery>
117 : </cfif>
|
|
SQLSTATE |
42000 |
DATASOURCE |
gcp |
VENDORERRORCODE |
1064 |
SQL |
SELECT * FROM product WHERE product_type = '4' AND product_on_web = '1' ORDER BY vessel_len,%20product_manu |
|
Resources:
|
Browser |
claudebot |
Remote Address |
34.229.62.45 |
Referrer |
|
Date/Time |
29-Mar-24 06:47 AM |
|