>Thank you very much for your reply.
>
>Is it possible to create readonly recordsets by submiting queries joining two tables? I have done this successfully using ADO with the same provider in Visual Basic however it doesn't seem to work in ASP.
>
>Thanks in advance
>
>George
Yes it is. For example, a query like this works on a free table directory DSN: Select * from mytbl1 join mytbl2 on mytbl1.mrn_no=mytbl2.mrn_no. If it works in VB it should work in ASP too. One thing that could be different about the two environments is the permissions. What error message are you getting?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only