In oracle for instance it's "rownum" , wondering if there's an equivalent in QofQ...
-----Original Message----- From: Stacy Young Sent: Tuesday, August 20, 2002 2:30 PM To: '[EMAIL PROTECTED]' Subject: RE: Best Way To Return Query Row Number? What that might not have been clear...I need the rownumber in which the record was found (for updating later)... Stace -----Original Message----- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:20 PM To: CF-Talk Subject: Best Way To Return Query Row Number? 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. ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists