For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Course Of The Month
1 day, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Why isn't this query working?
Posted on 2012-12-21
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
4
8 Comments
You need to use AS to alias your tables.
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
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
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?
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';
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
No numeric value after the TOP statement. Try this:
$query = 'SELECT TOP 5 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';
$query = 'SELECT TOP 5 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';
Featured Post
June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose.
It turns out that Yaho…
Things That Drive Us Nuts
Have you noticed the use of the reCaptcha feature at EE and other web sites? It wants you to read and retype something that looks like this.
Insanity! It's not EE's fault - that's just the way reCaptcha works. But it i…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses
Course of the Month1 day, 19 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.