March 10, 2004

There are two methods to send info and get a response via HTTP. The second (alternate) method works for both .NET and VB6, but it requires DLL reference (take your pick between these methods&#151which one is better really just depends on your priorities). Method 1: Dim strXml As StringstrXml =

When you compile a program the compiler first uses a preprocessor to analyze the code. The #define directive can be used to either define a constant number or function or to replace an instruction in your code. For instance: #define for_ever_do while(1) This means you can use for_ever_do instead of

The following code prints out an error report to NotePad. Private sub cmdPrintError_Click Dim curDB As Database Dim rs As Recordset Dim lSQL As String Dim retVal As Variant Open “C:Database xtValidate.txt” For Output As #1 Print #1, “Company to Validate:” & ” ” & Me.txtCompany Print #1, “” Set

Use this code to obtain the rowcount in JDBC without looping through the resultset. try { // Create a scrollable result set. stmt = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); // Set a string with the query sqlString = “SELECT …..”; rs = stmt.executeQuery(sqlString); // Point to the last row in resultset. rs.last();

Oftentimes, when I’m creating stored procedures, I forget to grant execute permissions to my user(s). Here is a stored procedure that will do this for you by simply passing in the username or a comma delimited list of users. Want to revoke permissions? Replace GRANT with REVOKE! CREATE PROCEDURE GrantExecuteForUser(@user