[Dbix-class] not able to list any records from database

[Marc Logghe]

What does the get_column() method give you ?
Op 1 sep. 2011 23:52 schreef "Rajeev Prasad" <rp.neuli at yahoo.com> het
volgende:
> thx.
>
> but when i put search item as 'test12' I get error:
>
>
> $ get-data-from-db.pl
> Use of uninitialized value in concatenation (.) or string at ./
get-data-from-db.pl line 23.
> user is:
>
> here is the code again, i think i have defined every variable.....
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
> #!/usr/bin/perl
> use strict;
> use warnings;
> use lib '../testdb';
> use Mysqltestdb::Schema;
> my ($schema, $user, $users_rs, $userid);
> my (@newusers, @oldusers);
> $schema =3D
Mysqltestdb::Schema->connect("dbi:mysql:dbname=3Dmysqltestdb:localhost:3306=
",
'root', 'mysql5');
> $users_rs =3D $schema->resultset('Testdbuser')->search(
>     { 'userid' =3D> 'test12' },                                ## WHERE
>     {
>       select   =3D> [ qw/userid password/ ],                   ## SELECT
>       as       =3D> [ qw/uid pass/ ],
>     }
>   );
>
> while ($user =3D $users_rs->next ()){
>  print "user is:" . $user->userid . "\n";
>  };
>
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
>
>
>
> From: Brian E. Lozier <brian at massassi.com>
> To: Rajeev Prasad <rp.neuli at yahoo.com>; DBIx::Class user and developer
list <dbix-class at lists.scsys.co.uk>
> Sent: Thursday, September 1, 2011 4:46 PM
> Subject: Re: [Dbix-class] not able to list any records from database
>
> On Thu, Sep 1, 2011 at 2:40 PM, Rajeev Prasad <rp.neuli at yahoo.com> wrote:
> follwoing code is not printing anything...???? can anyone help plz?
>>
>>
>>#!/usr/bin/perl
>>use strict;
>>use warnings;
>>use lib '../testdb';
>>use Mysqltestdb::Schema;
>>my ($schema, $user, $users_rs);
>>my (@newusers, @oldusers);
>>$schema =3D
Mysqltestdb::Schema->connect("dbi:mysql:dbname=3Dmysqltestdb:localhost:3306=
",
'root', 'mysql5');
>>$users_rs =3D $schema->resultset('Testdbuser')->search(    { 'userid' =3D>
'test' },                                ## WHERE    {       select   =3D> [
qw/userid password/ ],                   ## SELECT      as       =3D> [ qw/=
uid
pass/ ],    }  );  while ($user =3D $users_rs->next ()){ print "user is:" .
$user->uid . "\n"; };
>>
>>
>>database users:
>>SQL query: SELECT * FROM `testdbusers` LIMIT 0, 30 ; Rows: 6
>>userid
>>password
>>test12 pass
>>user1 pass1
>>user2 pass2
>>test45 pass
>>te1234 pass
>>te4567 pass
>>
> You're searching for userid =3D 'test' but you have no user 'test' in your
results.{ 'userid' =3D> 'test' },
> _______________________________________________
>>List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
>>IRC: irc.perl.org#dbix-class
>>SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
>>Searchable Archive:
http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20110902/5b7=
d909c/attachment.htm