SQL Reader

i am trying to make that it only reads the rows where "pri_spray" = true and "row_name" = form1.selected_row

                cmd.CommandText = "SELECT * FROM spray_db where pri_spray = true, row_name=" & form1.selected_row

thx
mSchmidtAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
if the fields pri_spray and row_name are string data type (varchar?), you need single quotes:
                cmd.CommandText = "SELECT * FROM spray_db WHERE pri_spray = 'true' AND row_name='" & form1.selected_row & "' "
0
 
mSchmidtAuthor Commented:
doh thx, just couldn't remeber how it was
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.