Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error in search condition '""INTERNET" OR "ONLINE" OR "WEBSITE" OR "WEB SITE" OR "DIGITAL MEDIA" OR "BROADBAND" OR "ECOMMERCE" OR "DOWNLOADS" OR "YOUTUBE" OR "AOL" OR "GOOGLE" OR "MICROSOFT" OR "EBAY" OR "AMAZON" OR "STREAMING" OR "SOCIAL NETWORKING""'.
|
| |
The error occurred in D:\Users\ShowBIZData\webadmin\mknews_sbd.cfm: line 44
|
42 : Body as Description,
43 : ImageLink from News where CONTAINS (body, '#QUERYSTRING#')
44 : or CONTAINS (title, '"#QUERYSTRING#"') and date > getdate() - 30 order by pubDate desc
45 : </cfquery>
46 :
|
|
| SQL |
select 'ShowBIZ Data' as Publisher,
id,
date as pubDate,
Title as Headline,
Body as Description,
ImageLink from News where CONTAINS (body, '"INTERNET" OR "ONLINE" OR "WEBSITE" OR "WEB SITE" OR "DIGITAL MEDIA" OR "BROADBAND" OR "ECOMMERCE" OR "DOWNLOADS" OR "YOUTUBE" OR "AOL" OR "GOOGLE" OR "MICROSOFT" OR "EBAY" OR "AMAZON" OR "STREAMING" OR "SOCIAL NETWORKING"')
or CONTAINS (title, '""INTERNET" OR "ONLINE" OR "WEBSITE" OR "WEB SITE" OR "DIGITAL MEDIA" OR "BROADBAND" OR "ECOMMERCE" OR "DOWNLOADS" OR "YOUTUBE" OR "AOL" OR "GOOGLE" OR "MICROSOFT" OR "EBAY" OR "AMAZON" OR "STREAMING" OR "SOCIAL NETWORKING""') and date > getdate() - 30 order by pubDate desc
|
| DATASOURCE |
sbd |
| VENDORERRORCODE |
7603 |
| SQLSTATE |
HY000 |
|
|
Please try the following:
|
| Browser |
CFSCHEDULE |
| Remote Address |
207.151.157.251 |
| Referrer |
|
| Date/Time |
08-Dec-06 08:54 AM |
|
