MySql Full Text searches

You must create a table that uses the MyISAM engine to support full text searches in MySql. Here is an example on how to create the table.

        conn = New MySqlConnection(strConn)

        conn.Open()
        Dim sbCmd As New System.Text.StringBuilder

        sbCmd.Append("Create Table If Not Exists MyBlog ")
        sbCmd.Append("(PostDate DateTime NOT NULL PRIMARY KEY, ")
        sbCmd.Append("BlogEntry Text, FullText(BlogText))")
        sbCmd.Append(" Engine = MyISAM")
        cmd = New MySqlCommand(sbCmd.ToString, conn)
        cmd.ExecuteNonQuery()
        conn.Close()

Use the MySql Match Against query to preform a full text search

Image Buttons

I have been working on making image buttons that change color when the mouse is over them. I have created transparent gifs using vb.net for the buttons. I use a transparent background because the image will display the background color of the image button. I change the backcolor with java script.

The code I used to create the transparent gif is based on code from Bob Powells

Blog up and running

Well I got my blog up and running today. I am using a MySql database for storing the data. My web host brinkster offers Sql Server, MS Access, and MySql database storage. I seam to get a lot of data access errors using MS Access on the web when I have too many users at once. I figured I will try the MySql. Seams to be a very powerfull database full of features. I still prefer to use Sql Server.

In addition to this site I also maintain a VB.Net and VB-Tips website with Cor Ligthert. I am starting to make some Visual Studio .Net 2005 tips. Hope to be able to start posting some soon.