Alex That code seems to work ok ... I am not sure I understand exactly what your problem is ... I am getting a link if there are records from the query and a message if there isn't any records
Can you explain more about what your poblem is? Rich On 10/27/06, alex poyaoan <[EMAIL PROTECTED]> wrote: > hi everybody i have this code that checks if the recordcount of the query is > not equal to 0 it gives me the list if not on the cfelse it should give me a > message but it just doesn't the list is blank... > thanks so much just trying to for hours but couldn't just get what i want > > <CFIF risorse.recordcount IS NOT 0> > <a class="continuasmall" > href="#LINKRISORSE#?INSEGNAMENTO_ID=#UrlEncodedFormat(INSEGNAMENTO_ID)#" > target="_blank">#DESCRIZIONERISORSE#</a> > <cfelse> > <p>no risorse</p> > </CFIF> > > thanks > alex > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258221 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

