<cfdump var = "#data.recordcount#"> returns zero records. The query has not been simplified. I have tried various values for url.alpha: "A,B,C,D ..."
>When you dump the recordcount (<cfdump var="#date.recordcount#"> > >Does it say '0' or does it say the variable is undefined? > >Also, is this the exact query that is in your code or is it 'simplified' for >this list? > >-- >William E. Seiter > >Have you ever read a book that changed your life? >Go to: www.winninginthemargins.com >Enter passkey: goldengrove > >Web Developer / ColdFusion Programmer >http://William.Seiter.com > >Thank You William, > >The var "url.alpha" is read properly up to the line of <cfquery ... >Even if I create <cfparam name="url.alpha" default="A"> the cfquery >does not recognize it. >I am at a loss ... > >Walter Conti > >----------------- > > >>Add this line directly before your query. >><cfdump var="#url.alpha#" label="url.alpha"> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3368 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
