Having trouble to use array in SELECT statement.

2001-02-26 Thread David Jacobowitz
Hello, I have constructed an array using my table field names and trying to pass that array in the select statement. @inc_re = ( Hotels, Asian_Real_Estate, Smart_Buildings, Real_Estate, Senior_Living_Homes ); $quary = "SELECT @inc_re FROM incu_real_estate LIMIT 1"; But I am getting following

Re: Need help with select statement.

2001-02-26 Thread David Jacobowitz
Thanks Rolf >From: "Rolf Hopkins" <[EMAIL PROTECTED]> >To: "David Jacobowitz" <[EMAIL PROTECTED]>, ><[EMAIL PROTECTED]> >Subject: Re: Need help with select statement. >Date: Tue, 27 Feb 2001 09:21:57 +0800 > >No it's not pos

Need help with select statement.

2001-02-26 Thread David Jacobowitz
Dear Sir, I have looked in the manual but could not find any clue so I am seeking your assistance. I have a table with 25 fields and I use most of these fields but not all in different DBI scripts. Currently I use: SELECT field_1, field_4, ...getting tired typing field names... FROM myTest; I