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 > keep getting an error message which I cannot resolve, and I'd appreciate > some advice. The error message is: > > "ODBC Error Code = 37000 (Syntax error or access violation) > > [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. > > SQL = "SELECT JokeTitle FROM Text" > Data Source = "Jokes" > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (1:1) to (3:14). " > > The code for the form is below. Please note that the name of the table is > 'text'. > > DATASOURCE="Jokes" > NAME="Titles"> > > SELECT JokeTitle > FROM Text > > > > > > > Jokes > > > > > JOKES > > > > Please select the joke titles from the contents of the select boxes below. > You may select up to five titles at a time. > > Joke title #1: > > > > > #Titles# > > > > > > > Thanks. > > Sincerely, > --- > Hubert Earl > ICQ#: 16199853 > > I develop & maintain web sites internationally. I also build web > applications using CGI scripts written in Perl. I accept subcontracting > work. > > **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ > (please remember to view this with a sense of humour!) > > **Business web page: http://home.talkcity.com/MigrationPath/hearl/ > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --2E9BE6F4AE52820C8132DE58 Content-Type: text/html; 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 keep getting an error message which I cannot resolve, and I'd appreciate some advice. The error message is: "ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. SQL = "SELECT JokeTitle FROM Text" Data Source = "Jokes" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (3:14). " The code for the form is below. Please note that the name of the table is 'text'.Thanks. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop & maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/">http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/">http://home.talkcity.com/MigrationPath/hearl/ -- Archives: http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --2E9BE6F4AE52820C8132DE58-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.SELECT JokeTitle FROM Text Jokes JOKES
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; 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 > > keep getting an error message which I cannot resolve, and I'd appreciate > > some advice. The error message is: > > > > "ODBC Error Code = 37000 (Syntax error or access violation) > > > > [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. > > > > SQL = "SELECT JokeTitle FROM Text" > > Data Source = "Jokes" > > > > The error occurred while processing an element with a general identifier of > > (CFQUERY), occupying document position (1:1) to (3:14). " > > > > The code for the form is below. Please note that the name of the table is > > 'text'. > > > > > DATASOURCE="Jokes" > > NAME="Titles"> > > > > SELECT JokeTitle > > FROM Text > > > > > > > > > > > > > > Jokes > > > > > > > > > > JOKES > > > > > > > > Please select the joke titles from the contents of the select boxes below. > > You may select up to five titles at a time. > > > > Joke title #1: > > > > > > > > > > #Titles# > > > > > > > > > > > > > > Thanks. > > > > Sincerely, > > --- > > Hubert Earl > > ICQ#: 16199853 > > > > I develop & maintain web sites internationally. I also build web > > applications using CGI scripts written in Perl. I accept subcontracting > > work. > > > > **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ > > (please remember to view this with a sense of humour!) > > > > **Business web page: http://home.talkcity.com/MigrationPath/hearl/ > > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > --2E9BE6F4AE52820C8132DE58 > Content-Type: text/html; 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 > keep getting an error message which I cannot resolve, and I'd appreciate > some advice. The error message is: > "ODBC Error Code = 37000 (Syntax error or access violation) > [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. > SQL = "SELECT JokeTitle FROM Text" > Data Source = "Jokes" > The error occurred while processing an element with a general identifier > of > (CFQUERY), occupying document position (1:1) to (3:14). " > The code for the form is below. Please note that the name of the > table is > 'text'. > <CFQUERY > DATASOURCE="Jokes" > NAME="Titles"> > SELECT JokeTitle > FROM Text > </CFQUERY> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <html> > <head> > <title>Jokes</title> > </head> > <body> > <h1>JOKES</h1> > <FORM ACTION="jokesaction.cfm" METHOD="POST"> > Please select the joke titles from the contents of the select boxes > below. > You may select up to five titles at a time. > Joke title #1: > <SELECT NAME="JokeTitle"> > <OPTION> > <CFOUTPUT QUERY="Titles"> > <OPTION VALUE="#JokeTitle#">#Titles# > </cfoutput> > </select> > </FORM> > </body> > </html> > Thanks. > Sincerely, > --- > Hubert Earl > ICQ#: 16199853 > I develop & maintain web sites internationally. I also build > web > applications using CGI scripts written in Perl. I accept subcontracting > work. > **Personal web site: http://www.geoci
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. The error message is: > > "ODBC Error Code = 37000 (Syntax error or access violation) > > [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. > > SQL = "SELECT JokeTitle FROM Text" > Data Source = "Jokes" > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (1:1) to (3:14). " > > The code for the form is below. Please note that the name of the table is > 'text'. > > DATASOURCE="Jokes" > NAME="Titles"> > > SELECT JokeTitle > FROM Text > > > > > > > > > Jokes > > > > > JOKES > > > > Please select the joke titles from the contents of the select boxes below. > You may select up to five titles at a time. > > Joke title #1: > > > > > #Titles# > > > > > > > Thanks. > > Sincerely, > > --- > Hubert Earl > ICQ#: 16199853 > > I develop & maintain web sites internationally. I also build web > applications using CGI scripts written in Perl. I accept subcontracting > work. > > **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ > (please remember to view this with a sense of humour!) > > **Business web page: http://home.talkcity.com/MigrationPath/hearl/ > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 getting an error message which I cannot resolve, and I'd appreciate some advice. The error message is: "ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. SQL = "SELECT JokeTitle FROM Text" Data Source = "Jokes" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (3:14). " The code for the form is below. Please note that the name of the table is 'text'. SELECT JokeTitle FROM Text Jokes JOKES Please select the joke titles from the contents of the select boxes below. You may select up to five titles at a time. Joke title #1: #Titles# Thanks. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop & maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view this with a sense of humour!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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 Jokes_Titles or Jokes_Titles_Text refer your database for keywords. - - Original Message - From: "Hubert Earl" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 24, 2000 2:06 PM Subject: CFQUERY problem > Hi, > > 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. The error message is: > > "ODBC Error Code = 37000 (Syntax error or access violation) > > [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. > > SQL = "SELECT JokeTitle FROM Text" > Data Source = "Jokes" > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (1:1) to (3:14). " > > The code for the form is below. Please note that the name of the table is > 'text'. > > DATASOURCE="Jokes" > NAME="Titles"> > > SELECT JokeTitle > FROM Text > > > > > > > > > Jokes > > > > > JOKES > > > > Please select the joke titles from the contents of the select boxes below. > You may select up to five titles at a time. > > Joke title #1: > > > > > #Titles# > > > > > > > Thanks. > > Sincerely, > > --- > Hubert Earl > ICQ#: 16199853 > > I develop & maintain web sites internationally. I also build web > applications using CGI scripts written in Perl. I accept subcontracting > work. > > **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ > (please remember to view this with a sense of humour!) > > **Business web page: http://home.talkcity.com/MigrationPath/hearl/ > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.