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

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

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

Replies are listed 'Best First'.
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]

Replies are listed 'Best First'.

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

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]