Re: Probelms returning values from a db and putting into a hash

Is the problem in your DB query, or in the HTML that is generating it? How do you know? Have you dumped the raw results?

Also, I don't see any condition in your WHERE clause, which seems like extra-bad news in a join.

xoxo,
Andy
--
<megaphone> Throw down the gun and tiara and come out of the float! </megaphone>

Comment on Re: Probelms returning values from a db and putting into a hash

Replies are listed 'Best First'.
Re: Re: Probelms returning values from a db and putting into a hash by DaWolf (Curate) on Apr 04, 2002 at 20:24 UTC
Oops, real sorry. The condition exists, but I've forgot to put it in the code that I've posted, here it is: `WHERE A.login=B.login AND B.state='$filial'` [download] The "$filial" comes from a form field. Er Galvão Abbott a.k.a. Lobo, DaWolf Webdeveloper	[reply] [d/l]
Re: Re: Re: Probelms returning values from a db and putting into a hash by petdance (Parson) on Apr 04, 2002 at 20:37 UTC
The WHERE was just an aside. My real question is: What debugging have you done? You can't just throw 100 lines of code out there and say "Hey, someone fix it." My original question stands: Is it in the DB results? Or is it in your generation of the HTML? Is it even a Perl thing? Have you tried your query in SQLPLUS, or whatever database client goes with the database you're using? xoxo, Andy -- <megaphone> Throw down the gun and tiara and come out of the float! </megaphone>	[reply]