At the bottom of your error page it should show the generated SQL from your query. Can you include that?
On Tue, 23 Nov 2004 13:58:55 -0400, alysia brown <[EMAIL PROTECTED]> wrote: > here is the error > > > Error Executing Database Query. > [Macromedia][Oracle JDBC Driver][Oracle]ORA-00933: SQL command not properly > ended > > The error occurred in > /home/httpd/web-dev/www/newsroom/news/ag_biosecurity/testing.cfm: line 11 > > 9 : testing > 10 : > 11 : <cfquery name="Programs" datasource="#dsn#" username="#dbuser#" > > 12 : select p.PROG_EMPH_ID, l.PROG_RL_DESCRIPTION, > 13 : l.PROG_RL_LINK, l.PROG_REC_ID, l.PROG_LINK_LKUP_REC_ID, > p.PROG_REC_ID > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:15:505 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
