Error Executing Database Query.
|
|
SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified
|
| |
The error occurred in F:\hshome\rawcom\shipwanted.com\openrs.cfm: line 16
Called from F:\hshome\rawcom\shipwanted.com\shipsaleadsgrid.cfm: line 275
Called from F:\hshome\rawcom\shipwanted.com\shipsaleadsgrid.cfm: line 1
Called from F:\hshome\rawcom\shipwanted.com\openrs.cfm: line 16
Called from F:\hshome\rawcom\shipwanted.com\shipsaleadsgrid.cfm: line 275
Called from F:\hshome\rawcom\shipwanted.com\shipsaleadsgrid.cfm: line 1
|
14 : <CFIF Attributes.MAX_ROWS EQ "-1">
15 : <CFQUERY NAME="CALLER.query#Attributes.Name#" DATASOURCE="#Request.db_connection_DS#" DBTYPE="#Request.db_connection_DB_TYPE#" USERNAME="#Request.db_connection_USER_NAME#" PASSWORD="#Request.db_connection_USER_PASSWORD#">
16 : #PreserveSingleQuotes(Attributes.SQL)#
17 : </CFQUERY>
18 : <CFELSE>
|
|
| SQL |
select ref_id as a_ref_id, a.type as a_type, a.date_posted as a_date_posted,a.built as a_built, a.member_id as a_member_id,a.short_description as a_short_desc,a.country as a_country, a.price as a_price, a.capacity as a_capacity,a.units as a_unit from shipsale a where (datediff('m',a.date_posted,now())<11) order by a.date_posted Desc
|
| DATASOURCE |
rawcom_shipwanted |
|
|
Please try the following:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.18 |
| Referrer |
|
| Date/Time |
09-May-08 07:14 AM |
|