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.


Reply via email to