You don't have to, it's available as queryname.CurrentRow. Ade
-----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 26 April 2005 23:11 To: CF-Talk Subject: RE: Finding "page" in a query. <quote> In that case, do you really want to move the user to a page out of sequence? Aren't they more likely to want to see the next records in the sequence to potentially edit those? </quote> Good question! I was thinking of showing them the updated record, as reinforcement that "yes the record you changed has changed." But maybe this is not the best way to do this, HMMM. Going to have to think on this and probably ask the project lead when she return tomorrow. Mean while, If I wanted to add a column numbered 1 to Number of Records in a query of query I'm using to sort by the selected column, how might I do this? <cfquery dbtype="query" name="ReturnQuery"> SELECT TRAN_CODE, SERVICE_CODE, PRODUCT_CODE, CPT_CODE FROM variables.CPT_data ORDER BY #sortCol# #sortDir# </cfquery> -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204583 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
