Guys,
I am having problems joining two tables using ASP. I set up a debug page to run which has three sql commands. The first command takes fielda, fieldb from table1 and this is successful. The second command takes fielda from table 2 where field2='Y' and this is successful. The third command is in the following format:
SELECT table1.fielda, table1.fieldb, table2.fielda from table1, table2 where table1.fielda=table2.fieldc and table2.fieldb='Y'
This command always fails and I have tried simpler join command ( with no where condition ) and I have tried different syntax for the command ( using INNER JOIN and LEFT JOIN ) and nothing works. I have even tried joining different tables and nothing works. I am using the Colibri.OLEDB interface to BTrieve and I have used the RowsetViewer feature that comes with this and I have been able to successfully run the above command. BUT IT JUST WON'T DO IT FROM ASP.
All tips/advice would be appreciated. Mise Le Meas,
Mighty
I am having problems joining two tables using ASP. I set up a debug page to run which has three sql commands. The first command takes fielda, fieldb from table1 and this is successful. The second command takes fielda from table 2 where field2='Y' and this is successful. The third command is in the following format:
SELECT table1.fielda, table1.fieldb, table2.fielda from table1, table2 where table1.fielda=table2.fieldc and table2.fieldb='Y'
This command always fails and I have tried simpler join command ( with no where condition ) and I have tried different syntax for the command ( using INNER JOIN and LEFT JOIN ) and nothing works. I have even tried joining different tables and nothing works. I am using the Colibri.OLEDB interface to BTrieve and I have used the RowsetViewer feature that comes with this and I have been able to successfully run the above command. BUT IT JUST WON'T DO IT FROM ASP.
All tips/advice would be appreciated. Mise Le Meas,
Mighty