Ask a Question related to Coldfusion Database Access, Design and Development.
-
Dr. Goomba #1
Reserved Word Problem or CFMX7 Bug?
I cant figure out what is wrong with this SQL query to result in an Error
Executing Database Query error. If i rename my table column to 'lang' it works
fine. Just when i use 'language' i have problems. I have noticed that using
'password' causes problems as well. I am using CFMX7.01, these are new
problems. On previous versions this has never been a problem. Database is
Access 2000
<cfquery name="getMovieLanguages" datasource="#request.dsn#">
SELECT language
FROM mLanguages
</cfquery>
thank you!
Dr. Goomba Guest
-
reserved word?
Hello, I got a PHP script in wich i have the following sql request: $configs = $db->getAll( 'SELECT * from !',array( CONFIG_TABLE ) ); No... -
Reserved characters in name attribute??
Hello.... It appears that the : (colon) is a reserved character in CF. I am attempting to name a hidden cfinput tag "rc:Parameters" (in a Flash... -
Reserved characters in name attribute???
Hello.... It appears that the : (colon) is a reserved character in CF. I am attempting to name a hidden cfinput tag "rc:Parameters" (in a Flash... -
Reserved characters for name attribute
Hello.... It appears that the : (colon) is a reserved character in CF. I am attempting to name a hidden cfinput tag rc:Parameters which is the... -
I4GL V7.30 and up - undocumented reserved words
Well, OK, it took the special breed of programmer we have here to find them and any fool should have known not to use these words in 4gl BUT......... -
Adam Cameron #2 Re: Reserved Word Problem or CFMX7 Bug?
[url]http://www.petefreitag.com/tools/sql_reserved_words_checker/?word=language[/url]
[url]http://office.microsoft.com/en-us/assistance/HP010322491033.aspx[/url]
[url]http://developer.mimer.se/validator/sql-reserved-words.tml[/url]
I guess you were lucky it ever worked. It shouldn't have.
--
Adam
Adam Cameron Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
