Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 16: Incorrect syntax near 'Eagle'.
|
| |
The error occurred in /home/imdaMarketplace/www/listings/dsp_main.cfm: line 72
Called from /home/imdaMarketplace/www/listings/fbx_Switch.cfm: line 7
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 242
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 1
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 1
Called from /home/imdaMarketplace/www/index.cfm: line 4
Called from /home/imdaMarketplace/www/listings/dsp_main.cfm: line 72
Called from /home/imdaMarketplace/www/listings/fbx_Switch.cfm: line 7
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 242
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 1
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 1
Called from /home/imdaMarketplace/www/index.cfm: line 4
|
70 : </cfif>
71 :
72 : ORDER BY #trim(attributes.orderBy)# #trim(attributes.sortType)#
73 : </cfquery>
74 :
|
|
| SQL |
SELECT view_classified.*, view_userInfo.city
FROM view_classified
INNER JOIN view_userInfo ON view_userInfo.useriD = view_classified.userID
WHERE view_classified.active = 1
AND view_userInfo.active = 1
AND view_classified.categoryID = 3
AND view_classified.adID IN (SELECT adID
FROM tblClassifiedDetails
WHERE fieldOptionID = 3
)
AND view_classified.adID IN (SELECT adID
FROM tblClassifiedDetails
WHERE fieldID = 25
AND fieldValue = 'Screamin' Eagle V-Rod Destroyer')
ORDER BY price DESC |
| DATASOURCE |
imdaMarketplace |
| VENDORERRORCODE |
170 |
| SQLSTATE |
HY000 |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.16 |
| Referrer |
|
| Date/Time |
13-May-08 08:12 AM |
|