Retrive a random record from database
Posted on 2004-10-06
I'd like to retrive random record from my MS Access database. It would work like if I click on "Button2" it would show me random record from column "UserAgent" in "TextBox1".
Code I currently have is like this:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
xConn = New sqlConn
xConn.connectMe("SELECT * UserAgent FROM UserAgents ORDER BY RAND() LIMIT 1")
For iCounter = 0 To xConn.getData.Count - 1
TextBox1.Text = (xConn.dataReturned.Item(iCounter))
It doesn't work... Anybody got ideas?