Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › Dreamweaver › retrieving record number from a DW recordset

retrieving record number from a DW recordset

Thread began 10/03/2009 7:13 am by CraigR | Last modified 10/04/2009 3:04 am by CraigR | 2227 views | 4 replies |

10/03/2009 7:13 am | #1 CraigRBeta Tester

retrieving record number from a DW recordset

when i use dreamweaver to bind a new recordset and test the sql statement, in the displayed results, as well as the data, you get the record number displayed.

i want to be able to retrieve this record number to use elsewhere, can anyone tell me what syntax i need to retrieve it?

10/03/2009 1:22 pm | #2 Dave BuchholzBeta Tester

Craig,

do you mean the id number from the database or the position of the record in the recordset ?

10/04/2009 2:12 am | #3 CraigRBeta Tester

Hi Dave.

i mean the position (row number) of the record in the recordset.

i'm sure i did this using mysqli, but the syntax is different when the rs is created within DW.

10/04/2009 2:40 am | #4 Dave BuchholzBeta Tester

This is what I use in DW to do this Auto Numbered Records with a DW Recordset

10/04/2009 3:04 am | #5 CraigRBeta Tester

Thanks Dave.

that certainly works when displaying the recrord number in my repeat region.

i'll see if i can use this approach in solving my problem

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.