Re: How to display tables on asp pages ?

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 28 May 2001 14:29:17 GMT
Message-ID: <1htQ6.71331$p33.1480161@news1.sttls1.wa.home.com>

Not sure I understand the problem. If you issue "select name from table" then you will get back all the rows from the table. It has nothing to do with primary key columns unless you are trying to have the Jet engine handle the selection on your selection (very inefficient). Try posing an example of what does not work and the error message you are getting. Also please include the versions of things (e.g. Oracle, the driver etc.) that you are using.
Jim

"Eric Gernot" <gernote2_at_cti.ecp.fr> wrote in message news:3B124D64.5B885232_at_cti.ecp.fr...
> Hi,
>
> I try to connect to a Oracle Database using ASP code.
> It works with queries like "select name from table". But I can't get
> primary key columns, and therefore, the SQL statement "select * from
> table" does not work.
> I don't think it comes from my ASP code.
>
> Can someone help ?
>
> Thanks.
> EG
>
Received on Mon May 28 2001 - 09:29:17 CDT