Swapping records (1 Viewer)

bloody_football

Registered User.
Local time
Today, 21:05
Joined
Sep 8, 2004
Messages
70
I have a list of records but there comes a time when I wish to swap records around; is there a way of doing this in ASP?
 

bloody_football

Registered User.
Local time
Today, 21:05
Joined
Sep 8, 2004
Messages
70
Oops sorry.

I have 4 records in a database
A - James,
B - Darren,
C - Emma &
D - Anne.
Is there a way of swapping the records (and all the info) of B & C?

I realise I can get the data in any order but I would like the option of swapping data.
 

Sergeant

Someone's gotta do it
Local time
Today, 06:05
Joined
Jan 4, 2003
Messages
638
Well, there's no relevance to a record's row position in a database. If you have them lettered or numbered with a column like you show here, you could just swap the letters or numbers with each other and then re-sort the recordset. Depending on how fancy you want to get, that could just be a matter of using input boxes and a pushbutton, or using jscript to do that for you. You'd save changes to the recordset, and post the form back to the same page.
There may be other ways of doing this. I would suggest you post the question to www.aspmessageboard.com.
 

Users who are viewing this thread

Top Bottom