Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Trying to learn SQL, Python, and VB.
#8
Omni Wrote:Strangely, that looks easier to understand than VB. I looked at that 'code' and it made sense. I stare at VB's, and I just sorta cringe. Thanks for the advice, because I have to take a class of SQL eventually, and I wanted to prepare. Smile

Actually the VB version of what Fiel just wrote is pretty simple too;

Code:
set rs = CreateObject("ADODB.Recordset")
cn = "Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase; User=myUsername;Password=;"
sSQL = "SELECT spam, eggs, sausage FROM breakfast WHERE price < 5"
rs.open sSQL, cn

debug.print rs.getstring ()
Reply


Messages In This Thread
Trying to learn SQL, Python, and VB. - by Khoi - 2010-03-11, 12:35 PM
Trying to learn SQL, Python, and VB. - by Fiel - 2010-03-11, 01:57 PM
Trying to learn SQL, Python, and VB. - by Khoi - 2010-03-11, 02:02 PM
Trying to learn SQL, Python, and VB. - by Hazzy - 2010-03-11, 03:17 PM
Trying to learn SQL, Python, and VB. - by Khoi - 2010-03-11, 03:20 PM
Trying to learn SQL, Python, and VB. - by Fiel - 2010-03-11, 03:28 PM
Trying to learn SQL, Python, and VB. - by Khoi - 2010-03-11, 03:52 PM
Trying to learn SQL, Python, and VB. - by Eos - 2010-03-11, 04:30 PM
Trying to learn SQL, Python, and VB. - by Khoi - 2010-03-11, 04:32 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)