Forum Discussion

mesg2anil's avatar
mesg2anil
Regular Contributor
14 years ago

Query MS-SQL database through TC

Hi, Using below code, I'm trying to query a table in MS-SQL server, it is giving me table fieldnames but it is not displaying the data from each field. Sub TestSQL 'Creates ADO conn...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
14 years ago
I can't be sure what the specific problem is since I don't have your database to try out the query.  My guess, though, is that your where clause needs some grouping symbols.



try the following on that line:



Set aRecSet = aCmd.Execute("select * from controlinfo where (Module like 'rental') and (submodule = 'leads')")