Re: How to display tables on asp pages ?

I give an example :
I have a table, "table1" with the following columns : "id", "name", "address". The "id" column is the primary key.

The following statements work :
select name from table1
select name, address from table1
select name from table1 where id=10

But these ones do not work :
select id from table 1
select * from table1
select id from table1 where name="moi"

It's the same for the other tables. I can't access the primary key column. I work with Oracle 8. The driver is "Microsoft ODBC Driver for Oracle" 2.00.00.6325.
I don't get any error message. The response sheet is just empty.

Thanks for help.

Jim Kennedy wrote:

> 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:47:53 CDT