dim mysql as string
dim str1 as string
dim number1 as longmysql = "select * from tablename where col1 = '" & str1 & "' and col2 = " & number1
dim str1 as string
dim number1 as longmysql = "select * from tablename where col1 = '" & str1 & "' and col2 = " & number1
dim strName as stringstrSql= "select * from tablename where name= '" & strName & "'"
dim str1 as string
dim number1 as longmysql = "select * from tablename where col1 = '" & str1 & "' and col2 = ' " & number1 "'我同意Cooly(苦力) 的写法!