It does not seem to be a reserved keywords of T-SQL, but it is a reserved
keyword for ANSI SQL
Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: Rob Rohan [mailto:[EMAIL PROTECTED]
Sent: Saturday, 14 February 2004 7:43 AM
To: CF-Talk
Subject: Is "position" a QofQ or SQL reserved word
With the query
| 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]
