really strange mysql result

[Alexandre Jaquet]

Hi,

I can't understand why I got different result
with the same sql query.

My code :

sub getComboBox {

my $name = shift || '';
my $htmlbuffer = '';
my @members = ();
my $group = ();

(@members) = sqlSelect("clientlevel","user","userID=userID AND
clientlevel <> ''");

$htmlbuffer = "<select name=\"$name\" style=\"width: 100%\"
class=\"editionFld\" \">\n";

foreach $group(@members) {
$htmlbuffer.= "<option value=\"$group\" selected>$group</option>\n";
}
return $htmlbuffer .= "</select>\n";
}

I got only one result and when I execute the query with the console :
select clientlevel from user where userID=userID and clientlevel <> ''

I got 4 items

 

[Walter Roberson]

:I can't understand why I got different result
:with the same sql query.
@members) = sqlSelect("clientlevel","user","userID=userID AND
:clientlevel <> ''");

Do you really want to be passing in the literal string userID as the userID ?
Has the variable userID previously been set by the code ?

 

[Alexandre Jaquet]

Walter Roberson a écrit :

:I can't understand why I got different result
:with the same sql query.
@members) = sqlSelect("clientlevel","user","userID=userID AND
:clientlevel <> ''");

Do you really want to be passing in the literal string userID as the userID ?
Has the variable userID previously been set by the code ?

Nope I don't really need that, I was just been trying different form.

 

[Alexandre Jaquet]

Alexandre Jaquet a écrit :

Walter Roberson a écrit :



Nope I don't really need that, I was just been trying different form.

I'm getting headache if I debug the query who's past to the sqlSelect I
got : sql : SELECT clientlevel FROM user WHERE userID=userID AND
clientlevel <> ''

just the same :s