strSQLQuery Help

healdem · #1 (**permalink**) 11-23-06, 04:37

Moving to ASP page...............

healdem · #2 (**permalink**) 11-23-06, 04:41

mind you I'd expect that the problem is probably
strSQLQuery = "SELECT * From Clients where Client_Type=" & CType

if CType is a string / text column then it should be encased in quote or double quotemarks

strSQLQuery = "SELECT * From Clients where Client_Type=" & chr(34) & CType & chr(34)

mwood · #3 (**permalink**) 11-30-06, 13:25

Thanks for the help. That worked..

Internet Services

Web Development

Digital Marketing

Consumer Tech