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

[Brian E. Lozier]

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:33=
06",
> '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/20110901/1cc=
2aaef/attachment.htm