yeah i think I had that problem for a while... round the loop do this: <cfif query.recordcount GT 0>
loop goes here </cfif> ----- Original Message ----- From: "Sridhar Pedamallu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 12:22 PM Subject: [ cf-dev ] CFLOOP in CFMX > HI > > There seems to be an issue with CFMX looping on queries. > I am using > <cfloop query="qry1" startrow="1" endrow="10"> > <cfset Temp1 = FldName> > </cfloop> > > It works fine if the qry1 returns records. But if there are no records > in qry1 it still executing code inside the loop (I think 1 time). > It giving errors since I am referencing fields of the query in side the > loop. > > Did some body came across this problem. > Does anyone have any suggestions > > Thanks > Sridhar > Clear Thinking Group > > 100 New Kings Road, London SW6 4LX. > Tel 0870 201 1601 > Fax 0207 348 6089 > > ______________________________________________________ > > Confidentiality > > The contents of this e-mail (including any attachments) are intended for the > named recipient only. It contains information which may be confidential and > which may also be legally privileged. > > Recipients > > If you are not the intended recipient (or authorised to receive for the > recipient), any disclosure, copying, distribution or any action taken or > omitted to be taken in reliance on it, is prohibited and may be unlawful. If > you received it in error please notify us immediately and then destroy it. > > Viruses > > Although we make every effort to keep our network free from viruses you > should check this e-mail and any attachments to it for viruses as we cannot > accept any liability for viruses inadvertently transmitted by us. If you > would rather receive the attachments by another medium please let us know. > > Opinions > > The information, views and comments within this communication are those of > the sender and not necessarily those of the Clear Thinking Group. > > > __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
