Error Executing Database Query.
|
|
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot find the input table or query 'OldBookings'. Make sure it exists and that its name is spelled correctly.
|
| |
The error occurred in C:/home/chezlangleysancerre.co.uk/wwwroot/tariff.cfm: line 9
|
7 : SELECT *
8 : FROM OldBookings
9 : WHERE Category=<CFQUERYPARAM VALUE="#Category#" CFSQLType="cf_sql_varchar" MAXLENGTH="1">
10 : AND WeekCommencing > DateAdd('d', -7, Now())
11 : ORDER BY Category, WeekCommencing
|
|
| SQLSTATE |
42S02 |
| DATASOURCE |
langley32 |
| VENDORERRORCODE |
-1305 |
| SQL |
SELECT *
FROM OldBookings
WHERE Category= (param 1)
AND WeekCommencing > DateAdd('d', -7, Now())
ORDER BY Category, WeekCommencing
|
|
|
Resources:
|
| Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
| Remote Address |
18.97.9.169 |
| Referrer |
|
| Date/Time |
21-Apr-26 05:12 AM |
|