MySql question (1 Viewer)

[bonekrusher]

Hi All,

I am trying to learn sequel strings and I have a question. How do i extract the value from this sql statement? Thanks!

Dim myconnection As ADODB.Connection
Dim myrecordset As New ADODB.Recordset
Set myconnection = CurrentProject.Connection

    myrecordset.ActiveConnection = myconnection
Dim answer As String
Dim mysql As String
    mysql = "SELECT Table1.Name, Table1.eMAIL FROM Table1 WHERE (([Table1]![Name]='jdoe'))"

 

[checoturco]

if you put the query in the recordset you can get the fields


myrecordset.open "SELECT Table1.Name, Table1.eMAIL FROM Table1 WHERE (([Table1]![Name]='jdoe'))"

myrecordset("name") -> gives you the name
myrecordset("eMAIL") -> gives you the email

i thonk yhis works for you

 

[bonekrusher]

Thanks! Works great. This help out a lot.

Bones