On Fri, 12 Jul 2002 19:06:30 -0400 Roy Rudder <[EMAIL PROTECTED]> wrote:
> I am having a problem getting a statement like below to produce any
> results when I have several columns with blank fields.
>
> $sth = $dbh->prepare("SELECT * FROM $tablename WHERE username =
> '$username'");
>
> If I limit it to just the columns that have data in them it works fine
> but when I try to select all the data it just hangs up.
> I have spent the last several hours searching for an answer to this
> problem and can't find one.
It's a bit hard to make meaningful guesses without even knowing what
database you are using. The DBI and DBD::??? versions would also be
useful. A short, complete example of the code that demonstrates the
problem would be even better; in addition to the rest.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.