Re: CFQUERY problem

Hubert, if you are using MS-Sql server "text" is a datatype, so you might run into problems there and your code Select JokeTitle from Jokes_Table (dont use text for a table name, its a keyword) #JokeTitle" It would be appropriate to use good table name Conventions like Prefixes. like

RE: CFQUERY problem

the "text" is a keyword in access. so the error -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 25, 2000 2:06 AM To: [EMAIL PROTECTED] Subject: CFQUERY problem Hi, I'm trying to build a dynamically filled drop down select box. However, I keep getti

Re: CFQUERY problem

'TEXT' is propably a reserved word in Access change the name of your table try myText or something ... ~Justin MacCarthy > I'm trying to build a dynamically filled drop down select box. However, I > keep getting an error message which I cannot resolve, and I'd appreciate > some advice.

Re: CFQUERY problem

Thanks. I eventually did that. Hubert - Original Message - From: Annette Kunovic <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 24, 2000 7:28 PM Subject: Re: CFQUERY problem > --2E9BE6F4AE52820C8132DE58 > Content-Type: text/plain

Re: CFQUERY problem

--2E9BE6F4AE52820C8132DE58 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Text is a reserved word. You need to change the name of the table. Annette Hubert Earl wrote: > Hi, > > I'm trying to build a dynamically filled drop down select box. However, I >