Is the order number a field in your table or a row number? I'm not entirely sure what you're trying to achieve, or what data structure you have. Dan
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 18 July 2005 10:52 To: [email protected] Subject: RE: [AspClassicAnyQuestionIsOk] Sorting using Ms-Access hi thanks i did that,but i need to display the order number like bid price | bid number -------------------------------- 20 | 2 10 | 1 --------------------------------- like this,how to do this? using order by we can arrange asending or des but hw to dispaly the ordernumber? help me thanks Jegatha Dan Powderhill <[EMAIL PROTECTED]> wrote: I'm not sure what the aim of the lngSortField part of the code is, but why not use the "order by" statement within the SQL itself? rs.open "select * from [bidorder] order by [bidprice] asc",cn,1,2 Dan ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 18 July 2005 09:22 To: Asp Subject: [AspClassicAnyQuestionIsOk] Sorting using Ms-Access Hi all, its very urgent, how to do the sorting in Ms-access db, i am using the following code,but it shows error as "current provider does not support sorting or filtering" code is DSNtest="DRIVER={Microsoft Access Driver (*.mdb)}; " DSNtest=dsntest &"DBQ=" &Server.MapPath("/access_db/paybill.mdb") Cn.Open DSNtest rs.open"select * from bidorder",cn,1,2 rs.Sort = "[bidprice]" If lngSortField > 0 Then strSortField="[" & rs.Fields(Cint(lngSortField)).Name & "]" strStortField=strSortfield rs.sort=strSortField End if whats the problem in this? anyone help in this? thanks jegatha --------------------------------- Free antispam, antivirus and 1GB to save all your messages Only in Yahoo! Mail: http://in.mail.yahoo.com [Non-text portions of this message have been removed] ________________________________ YAHOO! GROUPS LINKS * Visit your group "AspClassicAnyQuestionIsOk <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ [Non-text portions of this message have been removed] --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspClassicAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Free antispam, antivirus and 1GB to save all your messages Only in Yahoo! Mail: http://in.mail.yahoo.com [Non-text portions of this message have been removed] ________________________________ YAHOO! GROUPS LINKS * Visit your group "AspClassicAnyQuestionIsOk <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
