asked on Why isn't this query working?
I am converting a site from ColdFusion to PHP.
When I run this query:
$query = 'SELECT TOP e.date
,e.startTime
,e.endTime
,e.title
,e.details
,l.name
,e.room
FROM
WWW.dbo.Events e
LEFT OUTER JOIN WWW.dbo.Locations l
ON e.locationId = l.locationId
WHERE
WHERE e.date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY
ORDER BY date ASC';
I get this error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'e'.' in C:\inetpub\wwwroot\db2.php
Any help would be appreciated.
When I run this query:
$query = 'SELECT TOP e.date
,e.startTime
,e.endTime
,e.title
,e.details
,l.name
,e.room
FROM
WWW.dbo.Events e
LEFT OUTER JOIN WWW.dbo.Locations l
ON e.locationId = l.locationId
WHERE
WHERE e.date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY
ORDER BY date ASC';
I get this error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'e'.' in C:\inetpub\wwwroot\db2.php
Any help would be appreciated.
PHP
Last Comment
Donnie Walker
ASKER
did that and got the same error.
Try this:
$query = 'SELECT TOP e.date
,e.startTime
,e.endTime
,e.title
,e.details
,l.name
,e.room
FROM
WWW.dbo.Events AS e
LEFT OUTER JOIN WWW.dbo.Locations AS l
ON e.locationId = l.locationId
WHERE
WHERE e.date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY
ORDER BY e.date ASC';
What does that return?
$query = 'SELECT TOP e.date
,e.startTime
,e.endTime
,e.title
,e.details
,l.name
,e.room
FROM
WWW.dbo.Events AS e
LEFT OUTER JOIN WWW.dbo.Locations AS l
ON e.locationId = l.locationId
WHERE
WHERE e.date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY
ORDER BY e.date ASC';
What does that return?
ASKER
same error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'e'.' in C:\inetpub\wwwroot\db2.php
if I do this:
$query = 'SELECT TOP 5 date ,startTime ,endTime ,title ,details ,room
FROM WWW.dbo.Events
WHERE date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY date ASC';
without joining the second table I get results.
But I need the data from the second table as well.
I'm using "sqlsrv" and PDO if that makes a difference.
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'e'.' in C:\inetpub\wwwroot\db2.php
if I do this:
$query = 'SELECT TOP 5 date ,startTime ,endTime ,title ,details ,room
FROM WWW.dbo.Events
WHERE date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY date ASC';
without joining the second table I get results.
But I need the data from the second table as well.
I'm using "sqlsrv" and PDO if that makes a difference.
Duplicate WHERE and ORDER BY statements...
What about this?
$query = 'SELECT TOP e.date
,e.startTime
,e.endTime
,e.title
,e.details
,l.name
,e.room
FROM
WWW.dbo.Events AS e
LEFT OUTER JOIN WWW.dbo.Locations AS l
ON e.locationId = l.locationId
WHERE e.date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY e.date ASC';
What about this?
$query = 'SELECT TOP e.date
,e.startTime
,e.endTime
,e.title
,e.details
,l.name
,e.room
FROM
WWW.dbo.Events AS e
LEFT OUTER JOIN WWW.dbo.Locations AS l
ON e.locationId = l.locationId
WHERE e.date BETWEEN GETDATE() and DATEADD(month, 6, GETDATE())
ORDER BY e.date ASC';
ASKER
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'e'.' in C:\inetpub\wwwroot\db2.php
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
duh! That worked. Thanks again!
FROM
WWW.dbo.Events e
LEFT OUTER JOIN WWW.dbo.Locations l
Should be:
FROM
WWW.dbo.Events AS e
LEFT OUTER JOIN WWW.dbo.Locations AS l