perhaps it's not the name column, but the name attribute of the cfquery tag. try changing that around...
if it still happens with select top 10 * from tablename then it's not the sql at all. -cameron On 2/28/07, Damien McKenna <[EMAIL PROTECTED]> wrote: > On 2/28/07 4:23 PM, Jochem van Dieten wrote: > > Can you show the exact error message? Is it from CF, the JDBC Driver or > > the database? > > name can't be empty > > The error occurred in C:\inetpub\site\circuits\blah\act_functions.cfm: line > 19 > Called from C:\inetpub\site\circuits\blah\act_functions.cfm: line 72 > Called from C:\inetpub\site\circuits\blah\act_ajax.cfm: line 21 > Called from C:\inetpub\site\index.cfm: line 26 > 17 : </cfif> > 18 : > 19 : <cfquery name="msg_details" datasource="#application.tlc#"> > 20 : select > 21 : title, > Please try the following: > Check the ColdFusion documentation to verify that you are using the correct > syntax. > Search the Knowledge Base to find a solution to your problem. > > Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en) > AppleWebKit/418.9.1 (KHTML, like Gecko) Safari/419.3 > Remote Address 68.213.132.14 > Referrer > Date/Time 28-Feb-07 02:27 PM > Stack Trace > at > cfact_functions2ecfm1273117340$funcNOTIFYSPONSOR.runFunction(C:\inetpub\site > \circuits\blah\act_functions.cfm:19) at > cfact_functions2ecfm1273117340$funcFINDDIST.runFunction(C:\inetpub\site\circ > uits\blah\act_functions.cfm:72) at > cfact_ajax2ecfm1486445576.runPage(C:\inetpub\site\circuits\blah\act_ajax.cfm > :21) at cfindex2ecfm1314450034.runPage(C:\inetpub\site\index.cfm:26) > > java.lang.IllegalArgumentException: name can't be empty > at java.security.BasicPermission.init(BasicPermission.java:85) > at java.security.BasicPermission.<init>(BasicPermission.java:118) > at > coldfusion.sql.DataSourcePermission.<init>(DataSourcePermission.java:12) > at coldfusion.sql.DataSrcImpl.check(DataSrcImpl.java:80) > at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:85) > at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75) > at coldfusion.sql.SqlImpl.execute(SqlImpl.java:214) > at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447) > (etc ad nausium) > > -- > Damien McKenna - Web Developer - [EMAIL PROTECTED] > The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 > #include <stdjoke.h> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
