| getValidAds
| ADALT | ADFILENAME | ADLINK | ADID | POSITION | VIEWTIMES
1 | yadda | joes.jpg | joes.com| 4 | 0 | 0
<cfquery name="topads" dbtype="query">
SELECT
viewtimes,
adfilename,
adlink,
adalt
FROM getValidAds
WHERE position = 0
</cfquery>
throws
Error Executing Database Query.
Query Of Queries syntax error.
Encountered "position" at line 0, column 0. Incorrect conditional
_expression_, Expected one of [like|null|between|in|comparison] condition,
However if I change it to
<cfquery name="topads" dbtype="query">
SELECT
viewtimes,
adfilename,
adlink,
adalt
FROM getValidAds
WHERE [position] = 0
</cfquery>
It works. I may be rusty, but is "position" an QofQ (or sql) reserved
word? If so, anyone know where there is a list
( this just wasted 30 minutes of my time :-/ )
--
Vale,
Rob
Luxuria immodica insaniam creat.
Sanam formam viatae conservate!
http://www.rohanclan.com
http://treebeard.sourceforge.net
http://ashpool.sourceforge.net
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
