Microsoft Word - Sam's Teach Yourself MySQL in 21 Days - SAMS.doc
110 Dim vRecordCount 'Counter 120 Dim vbgcolor ‘Back Ground Color 130 'Creating the ADO Objects 140 Set mConn = Server.CreateObj ...
330 340 First 350 Name 360 Last 370 Name 380 State 390 400<% 410 ' Set our counter to 0 420 vRecordCount = 0 430 ' Walk thr ...
580 rstCustomers.MoveNext 590 'Increase the record count 600 vRecordCount = vRecordCount + 1 610 Loop 620 rstCustomers.Close 630 ...
be able to create this object. The Server object contains a few other rarely used methods and one property. These are not releva ...
Hopefully, with these examples, you understand the Active Server Page concept and how it can be helpful. Again, this is only a c ...
mConn.CursorLocation = 3 A little side note. There is a bug within IIS 4. The interpreter will not interpret the VBScript consta ...
that MySQL does not have (namely, stored procedures). Execute() (^) This method will cause the execution of the commands in the ...
CursorType Indicates the type of cursor used in the recordset. The types of cursors and what they can do are explained later tod ...
instead of the Microsoft constant because there is a bug within IIS that causes an error if you use the constant. If everything ...
We will not give your name or email address to anyone without your consent. Items with a ( *) are required fields. Pl ...
Please describe yourself:<font size="4" face="Arial"> <font color="#FF0000">*</font></font></P> ...
90 Dim strSQL 100 'Create the ADO objects 110 Set mCmd = Server.CreateObject("ADODB.Command") 120 Set mConn = Server.CreateObjec ...
330 'check gender 340 If Request("Contact_Gender") = "Male" Then 350 strSQL = strSQL & "M, " 360 Else 370 strSQL = strSQL &a ...
570 %> 580 590Thank You, <%Response.Write Request("Contact_FirstName%> 600 610 The first line, like most ASPs, tell ...
Displaying Data to the Web Page Now you'll create a Web page that displays all your customers. This page could be called from a ...
230 mCmd.ActiveConnection = mConn 240 mCmd.CommandType = 1 'Text 250 mCmd.CommandText = "SELECT * FROM Customers ORDER BY Last_N ...
460 ' This will alternate the row color, making it easier to read 470 If vRecordCount Mod 2 > 0 Then 480 vbgcolor = "#C0C0C0" ...
What the header and META tags are doing in lines 10–50 has been discussed earlier. Let's skip to the code that deals with the AD ...
Finally, you saw how everything comes together—how using VBScript in an ASP can manipulate a database using ADO. Q&A Q: Can ...
Installing the Perl DBI and the MySQL DBD To take advantage of the Perl DBI you need to install the necessary modules. This proc ...
«
2
3
4
5
6
7
8
9
10
11
»
Free download pdf