How to sort? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

How to sort?

Author

Topic

Mamatha
Posting Yak Master

102 Posts

Posted - 2005-04-01 : 01:00:02

Hi

I have an application in VB6.0,in that application i used recordset object to insert and retrieve some data,now i want to sort these records while displaying,but i don't have any idea hoe to sort these records.I want help from you people.

My code is like the following:

creating recordset object to store data
Set grst_Summary = CreateObject("ADODB.recordset")
With grst_Summary
.fields.Append "PST", 200, 255
.fields.Append "Foldername", 200, 255
.fields.Append "TotalEmails", 3
.fields.Append "FilteredItems", 3
.CursorType = 1
.LockType = 3
.Open
.groupby
End With

Inserting data:

With grst_Summary
.AddNew
!PST = strPSTname
!FolderName = strFoldername
!TotalEmails = lngTotalEmails
!FilteredItems = lngCurrentEmails
.Update
End With

Retrieved like the following:

grst_Summary.movefirst

Do While Not grst_Summary.EOF
summaryHtml = summaryHtml & "<tr>"
For i = 0 To grst_Summary.fields.Count - 1
summaryHtml = summaryHtml & "<td align='center'>" & grst_Summary(i) & "</td>"
Next
summaryHtml = summaryHtml & "</tr>"
grst_Summary.movenext
Loop

Thanks in advance

Mamatha

jhermiz

3564 Posts

Posted - 2005-04-01 : 09:47:28

why dont you sort from the backend ?

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]

jhermiz

3564 Posts

Posted - 2005-04-01 : 09:47:32

why dont you sort from the backend ?

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources