Pete,
The query runs and returns data in Query Analyzer. In the case above, it returns 1 record.
Thanks for your suggestion though.
The error is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
When I looked this up under microsoft's help, it says that the solution is to use a...
I am using SQL Server 7.0.
I'm using inline sql to create the recordset and it doesn't have a group by clause, it is as follows:
select sp.number, p.subCategory_Number, p.reference_Code, p.price, sp.graphic, sp.position, sp.page, sp.date_last_modified from tblSpecials sp inner join...
Hi,
I am trying to use ODBC and ASP with a recordset to update a record.
The sql statement I used to create the recordset spans across two tables, that have a one to one relationship (this is created by the foreign key having a unique constraint). They are connected through an inner join in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.