Error Executing Database Query.
|
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[subscriptions].[customerID])
AND ((subscriptions.CustomerType)='customer...' at line 16
|
|
The error occurred in D:/home/fabfileonline.com/wwwroot/Production/sample.cfm: line 145
Called from : line -1
Called from : line -1
Called from D:/home/fabfileonline.com/wwwroot/Production/sample.cfm: line 145
|
143 : WHERE (((registration.CustomerID)=[subscriptions].[customerID])
144 : AND ((subscriptions.CustomerType)='customer')
145 : AND ((subscriptions.ExpireDate) Between ###todayMinus60### And ###todayPlus60###)
146 : AND ((registration.Status)='Active'))
147 : ORDER BY subscriptions.ExpireDate;
|
|
SQLSTATE |
42000 |
DATASOURCE |
fabfile |
VENDORERRORCODE |
1064 |
SQL |
SELECT
registration.CustomerID,
registration.FirstName,
registration.LastName,
registration.CompanyName,
registration.Email,
registration.Status,
registration.Phone,
subscriptions.CustomerType,
subscriptions.BeginDate,
subscriptions.ExpireDate,
registration.Sales_In_Process
FROM registration
INNER JOIN subscriptions ON
registration.CustomerID = subscriptions.CustomerID
WHERE (((registration.CustomerID)=[subscriptions].[customerID])
AND ((subscriptions.CustomerType)='customer')
AND ((subscriptions.ExpireDate) Between #01/29/2024# And #05/28/2024#)
AND ((registration.Status)='Active'))
ORDER BY subscriptions.ExpireDate;
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
44.211.91.23 |
Referrer |
|
Date/Time |
29-Mar-24 07:19 AM |
|