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.14.85 |
Referrer |
|
Date/Time |
06-Dec-24 05:05 PM |
|