simple SQL question

[jasonjb]

I need to pass info held in Long variables and a TextBox control array to a database in a SQL statement...can anyone give me some sample code on how to do it? (I already have DB connection established and stuff...just need the SQL)
Thanks!
-jason

[chrisjk]

Just use normal string interpolation...

SELECT * FROM table WHERE table.somefield = " & myVariable or textbox.text & " ORDER BY suchandsuch;"

[jasonjb]

I'll try it out.
Many thanks

[jasonjb]

hmm...I tried this:

"INSERT INTO Members VALUES(" & NewID & ", " & Text1(0).Text & ", " & Text1(1).Text & ", " & Text1(2).Text & ", " & Text1(6).Text & ", " & SSN & ", " & Text1(7).Text & ", " & Text1(5).Text & ", " & Typevar & ", " & FFID & ")"

and I got this error:
"The name 'hj' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted."
"hj" is what I typed into the first of the textboxes as a test.
Any help is appreciated. thanks.

[chrisjk]

hmm...try putting a msgbox before the sql statement to see what it is actually doing, like this

Msgbox "INSERT INTO Members VALUES(" & NewID & ", " & Text1(0).Text & ", " & Text1(1).Text & ", " & Text1(2).Text & ", " & Text1(6).Text & ", " & SSN & ", " & Text1(7).Text & ", " & Text1(5).Text & ", " & Typevar & ", " & FFID & ")"

. It may be something really obvious that usually makes itself known using msgboxes.

[jasonjb]

Worked! Thanks