Error Executing Database Query.
|
|
Table 'tomlyn.crl_products' doesn't exist
|
| |
The error occurred in /Library/Tenon/WebServer/WebSites/www.crlsensors.com/cfc/product_details.cfc: line 58
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/piezoelectric-accelerometers.cfm: line 9
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/cfc/product_details.cfc: line 58
Called from /Library/Tenon/WebServer/WebSites/www.crlsensors.com/piezoelectric-accelerometers.cfm: line 9
|
56 : left join crl_product_features pf
57 : on p.product_id = pf.product_id
58 : where p.product_name = <cfqueryparam cfsqltype="cf_sql_varchar" value="#variables.strip_product_name#">
59 : group by p.product_id, pd.product_id, p.product_id;
60 : </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 |
Tomlyn |
|
|
Resources:
|
| Browser |
CCBot/2.0 |
| Remote Address |
50.17.109.248 |
| Referrer |
|
| Date/Time |
22-May-13 10:45 AM |
|