storing the records retrieved from a database

[kirankumar]

Hi,<br>I want to store the records retrieved from a database for further processing in the same page.Further processing here i mean like sorting the records on different fields.The values are same, but the sorting order field needs to be changed whenever the user click on a field.If you have any idea apart from storing them as application or session variables.The method may be like storing them in javascript arrays.<br>Thanks in advance<br>

 

[JDurbin]

I would do this with a com server created by Visual FoxPro.&nbsp;&nbsp;Then again, M$ has hidden VFP pretty well within Visual Studio but that will change in the upcoming release of VS 7.&nbsp;&nbsp;VFP is getting it's due at least as a middle tier component.&nbsp;&nbsp;If you have Studio, I can help you with the code.&nbsp;&nbsp;You just return an A HREF link from within a SQL statement for the table headers so they are linkable back to your COM object to return a new sorted set.&nbsp;&nbsp;It also gives the visual clue that it is available&nbsp;&nbsp;As I say this you can prehaps do this trick already with your current ADO or ODBC SQL Select statement.<br><br>Looks like this from within VFP<br>SELECT [&lt;A HREF=&quot;MyASPPage.asp?Custno=ALLTRIM(Custno) + [&quot;&gt;&quot;] + Company + [&lt;/A&gt;] as COMPANY, careof AS CONTACT, phone, company AS Sort FROM .\Data\MyTable WHERE CustNo=lcCustNo ORDER BY Sort INTO Cursor MyCursor<br> <p>John Durbin<br><a href=mailto: > </a><br><a href= > </a><br>ICQ VFP ActiveList #73897253

 

[JDurbin]

Another way using ADO: <A HREF="

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=6238"

TARGET="_new">

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=6238</A><br>

<p>John Durbin<br><a href=mailto: > </a><br><a href= > </a><br>ICQ VFP ActiveList #73897253

 

[kirankumar]

Thanks Durbin,<br>I am working on that.<br>Kirankumar