I meant test.currentRow, sorry. ---------- Forwarded message ---------- Date: Tue, 20 Aug 2002 14:31:57 -0400 (EDT) From: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: Best Way To Return Query Row Number?
Uh, test.rowcolumn doesn't work? ~Todd On Tue, 20 Aug 2002, Stacy Young wrote: > Is there a pseudo column I can return on a QofQ that provides the rownumber? > Say for example I have: > > <cfquery name="test" type="query"> > SELECT name > FROM mytable > WHERE name = "test" > </cfquery> > > Or anyone have an alternate solution? > > Thanks! > > > AVIS IMPORTANT: > ------------------------------- > Les informations contenues dans le present document et ses pieces jointes sont >strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il >est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, >distribution, copie, ou autre utilisation de ces informations est strictement >prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait >communiquer immediatement avec l'expediteur et detruire ce document sans en faire de >copie sous quelque forme. > > WARNING: > ------------------------------- > The information contained in this document and attachments is confidential and >intended only for the person(s) named above. If you are not the intended recipient >you are hereby notified that any disclosure, copying, distribution, or any other use >of the information is strictly prohibited. If you have received this document by >mistake, please notify the sender immediately and destroy this document and >attachments without making any copy of any kind. > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

