Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'kids'.
|
| |
The error occurred in C:/DATA/WWWROOT/Twits/PUBLIC/webshop/overview.cfm: line 88
Called from C:/DATA/WWWROOT/Twits/PUBLIC/webshop/routes.cfm: line 30
Called from C:/DATA/WWWROOT/Twits/PUBLIC/_owner/main.template.cfm: line 209
Called from C:/DATA/WWWROOT/Twits/PUBLIC/routes.cfm: line 50
Called from C:/DATA/WWWROOT/Twits/PUBLIC/webshop/overview.cfm: line 88
Called from C:/DATA/WWWROOT/Twits/PUBLIC/webshop/routes.cfm: line 30
Called from C:/DATA/WWWROOT/Twits/PUBLIC/_owner/main.template.cfm: line 209
Called from C:/DATA/WWWROOT/Twits/PUBLIC/routes.cfm: line 50
|
86 : ORDER BY CP.sequence asc, P.createTS desc
87 : </cfif>
88 : <cfelse>
89 : ORDER BY P.createTS desc
90 : </cfif>
|
|
| VENDORERRORCODE |
102 |
| SQLSTATE |
HY000 |
| SQL |
SELECT P.product_id as pId, P.product_name as product, P.product_artnr as artnr, P.product_permalink as permalink, P.product_price as price,
B.brand_title as brand, B.brand_logo as brandlogo, P.product_promoprice as promoprice, P.product_discount
FROM twits_products P
inner join twits_brands B on (B.brand_id = P.lnk_brand_id)
left outer join twits_cats C on (C.cat_id = CP.lnk_cat_id and C.cat_permalink = snowboard kids)
left outer join twits_cat_products CP on (CP.lnk_product_id = P.product_id)
WHERE P.status > 0
ORDER BY CP.sequence asc, P.createTS desc
|
| DATASOURCE |
twits |
|
|
Resources:
|
| Browser |
CCBot/2.0 (http://commoncrawl.org/faq/) |
| Remote Address |
23.20.86.177 |
| Referrer |
|
| Date/Time |
20-Oct-17 01:36 AM |
|
