ServerWatch Staff

The next page is the wizard completion page where you would click Finish to complete your task to start the restoration procedure. (A window may open one last time to ask you for the location of the backup set to be used. If it does either enter it or browse to the location of the […]

Let’s take a look at how an outer join works.  Suppose I want to see a list of all customers along with some ordering information for those customers who have placed orders. The code will resemble the following.                               Select C.[Field List], O.[Field List] from Customers C left outer join Orders O on C.CustomerID=O.CustromerID   […]

Building servers for the edge will involve respoking, not reinventing, the wheel. Servers for different classes of customers carry much the same functionality, although different elements are emphasized. Two such categories are service providers and end users, said Gordon Smith, vice president of marketing for Speedera Networks. “Being a service provider, the evolution of edge […]

Now that we have done that, we need to go to the properties of the Exchange Virtual Directory inside Internet Services Manager. We are going to go to the Custom Error Messages Tab. Figure 9 illustrates where we are at. Figure 9 Once on the Custom Errors tab, we need to edit the properties of […]

T.MallardUsing ASP to Create a Website from Spreadsheets Continued So, I manually copied and pasted from the original Excel file into tables which were created with wizards and default values in Microsoft Access for the database. To the right is the “content” table definitions, note that any number fields need to be listed first, then […]

T.MallardUsing ASP to Create a Website from Spreadsheets Continued while not rsInput.EOF   if isnull(rsInput(“note1“)) then lines = lines+1 rsInput.moveprevious addin1 = rsInput(“note1“) addin2 = rsInput(“note2“) addin3 = rsInput(“note3“) rsInput.movenext rsInput(“note1“) = addin1 rsInput(“note2“) = addin2 rsInput(“note3“) = addin3 rsInput.updateresponse.write(“.”& vbCrLf)   end if   rsInput.movenext   response.write(“:” & ““& vbCrLf)wend conn1.closeset rsInput = nothingresponse.write(“done: ” & lines & […]

T.Mallard % Server.ScriptTimeOut = 2240 %>set cmd1 = server.createobject(“ADODB.Command“) cmd1.ActiveConnection = conn1 cmd1.CommandText = “update product set prod_page = ‘” &filename &“‘ where product.part_number = ‘” &rsInput(“part_number“) &“‘“set rsOutput = cmd1.execute response.write(“updated: ” &rsInput(“part_number“) &““)set cmd1.ActiveConnection = nothingset cmd1 = nothingset conn2 = server.createobject(“Scripting.FileSystemObject“)set output = conn2.OpenTextFile(htmlOut, 8, True) set rsCreate = server.createobject(“ADODB.Recordset“)set rsWords = […]

T.Mallard Using ASP to Create a Website from Spreadsheets Continued Finished with the product pages, but the catalog needs a heirarchy, so some asp pages were created to arrange several levels of indexes and also the pricing pages within the navigation schema. These are by product and group types. Then, the homepage was coded to […]

T.Mallard Using ASP to Create a Website from Spreadsheets Continued The result is the table listing on the left has the links to the product pages. Then there are the indexes, and below are the main index/homepage loops to create some drop-down select boxes on the page. From all of these, I hope it’s obvious […]

T.MallardThe variables… dim input, output, htmlOut, author, editor, pubdate, topic, source, locale, annotate, errs, err2dim conn1, conn2, conn3, rsInput, txtOut, rsTemp, pagename, metatopics, secstart, minstartdim metasOut Then the first filename is set which is used for the individual topics which appear on each page, this list is created on the first pass with the original […]

T.Mallard With the connections open… dim paging, aline, series, sNext, sPrev while not rsInput.EOF series = series + 1 The variable ‘series’ is a page counter, which begins with this while loop. Below is the code to create filenames and Next-Previous links. for paging =1 to 80if paging = 1 then   if series 100 then […]

T.MallardBegin outputting the html page to a file… set output = conn1.opentextfile(htmlOut, 8, True)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(“General Index – Volume 3, 1986 – Current Research in the Pleistocene“)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(““)output.writeline(“Current Research in the Pleistocene“)output.writeline(“Volume 3, 1986“)output.writeline(“General Index“)output.writeline(“Page “ & series & ““)output.writeline(“ “)end if