Error Executing Database Query.
|
|
Table 'eaglestainless.crl_products' doesn't exist
|
| |
The error occurred in /Library/Tenon/WebServer/WebSites/www.crlsensors.com/cfc/product_details.cfc: line 22
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/cfc/product_details.cfc: line 92
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/views/prod.details.cfm: line 5
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/force-balance-accelerometers.cfm: line 57
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/cfc/product_details.cfc: line 22
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/cfc/product_details.cfc: line 92
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/views/prod.details.cfm: line 5
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/force-balance-accelerometers.cfm: line 57
|
20 : left join crl_product_features pf
21 : on p.product_id = pf.product_id
22 : where p.product_name = <cfqueryparam cfsqltype="cf_sql_varchar" value="#variables.strip_product_name#">
23 : group by p.product_id, pd.product_id, p.product_id;
24 : </cfquery>
|
|
| SQLSTATE |
42S02 |
| SQL |
select *
from crl_products p
left join crl_product_decriptions pd
on p.product_id = pd.product_id
left join crl_product_specifications ps
on p.product_id = ps.product_id
left join crl_product_features pf
on p.product_id = pf.product_id
where p.product_name = (param 1)
group by p.product_id, pd.product_id, p.product_id;
|
| VENDORERRORCODE |
1146 |
| DATASOURCE |
EagleStainless |
|
|
Resources:
|
| Browser |
CCBot/2.0 |
| Remote Address |
107.22.156.205 |
| Referrer |
|
| Date/Time |
23-May-13 06:20 PM |
|