[Company Logo Image] 

Home Up Feedback

MS Knowledge Base
MS Knowledge Base Tips and Tricks SlashPane Wiki Mirror

 

<% Set loConn = Server.CreateObject("ADODB.Connection") loConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\hosting\member\SarekOfVulca\mskb.mdb;Persist Security Info=False" loConn.Open() Set loRS = Server.CreateObject("ADODB.RecordSet") Set loRS.ActiveConnection = loConn lcOrder = Request.Form("Order") IF lcOrder = "Type" Then loRS.Open("SELECT * FROM mskb ORDER BY cType, cNumber") ELSE loRS.Open("SELECT * FROM mskb ORDER BY cNumber") END IF %>

During my stint in Microsoft Product Support Services, I wrote a number of Knowledge Base articles for VFP. You can sort them either by number (chronologically), or by type. For a static list with further comments, please see the FoxForum Wiki. Mike Stewart also has a list on the Wiki at http://fox.wikis.com/wc.dll?Wiki~MikeStewKBArticles.

"Type" Then Response.Write "checked" End If %>>By Number >By Type
<% Do While Not loRS.EOF lcNumber = loRS.Fields("cNumber")%> <% loRS.MoveNext Loop %>
<%= lcNumber %> <% = loRS.Fields("cTitle") %>

 

Home ] Up ]

Send mail to webmaster@donnael.com with questions or comments about this web site.
Last modified: 2007-01-29

Join WebHost4Life.com