Sorting my array...

[Simmantix]

Hi all,

I have a search page, the keywords form a selection routine to bring records from the DB which contain any of the keywords. Each record is then analysed to determine how many of the keywords it has in it and is given a higher rating accordingly. The records are concatenated into a string and then they are put into an array. So I have an array, that array is filled with a strings which are themselves concatenations of:

RecordID&Subject&Text&Date&Rating

The rating is a three digit rating which is assigned to the string based on the amount of matching words within the text. A example array string would be:

2&TestSubject&Hi, this a test...&31/02/2003&050

What I want to do is, having made my array from analysis of recordsets, resort the array based on the rating (highest to lowest) for output onto my web page.

Any ideas would be greatly appreciated.. Also any other ways to do the whole thing would be quite good too, emphasis on simple though.

Thanks in advance

Simm

 

[clarkin]

to put you on the right track, here's how to get your rating for that string - as a number variable. Should be easy enough to sort the array based on this.

dim strTest, intRating
strTest = "2&TestSubject&Hi, this a test...&31/02/2003&050"
intRating = CInt(Right(strTest, 3)) 'get last 3 chars of string & convert them to an int

so - if you loop through your array you can get the rating as an int for each string in your results. Let us know how you get on with trying to sort using this


Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].

 

[dilettante]

Well, there is always faq329-3362.

Then use GetString( ) or GetRows( ) to pull your data back out into a string or an array.

 

[ggriffit]

I've found the Javascript SORT function to be significantly faster for this type of thing, see

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/js56jsobjvbarray.asp

for the samples, I've found this to be significantly faster, just can't recall the URL that has the results on ;-)