thanks...that makes sense...no need for any responses
to that second post i just sent.
rob
--- "Thomas A. Lowery" <[EMAIL PROTECTED]> wrote:
> > ####this uses binds, and does not work####
> >
> > #my $sth = $dbh->prepare( "SELECT * FROM
> demographics
> > WHERE ? LIKE ?");
> ^^^
> >
> > #$sth->bind_param(1, $field);
> >
> > #$sth->bind_param(2, $text);
>
> This doesn't work. You're asking the db to prepare
> a statement
> without telling it the columns in the where clause.
> You'll need to
> define the column at prepare time.
>
> Tom
>
> On Sat, May 19, 2001 at 10:21:46AM -0700, Robert
> Sherman wrote:
>
> > ####this is the interpolated statement, which
> > works####
> >
> > my $sql = "SELECT * FROM widgets WHERE $field LIKE
> > $text";
>
> --
> Thomas A. Lowery
> See DBI/FAQ http://tlowery.hypermart.net
>
>
_________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at
> http://mail.yahoo.com
>
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
