<html><body bgcolor="#FFFFFF"><div>userid => { -like => 't% }<br><br>--<div>Rob Kinyon (Mobile)</div><div>This message may contain confidential information. Please delete it if you are not the intended recipient.</div></div><div><br>On Sep 1, 2011, at 18:11, Rajeev Prasad <<a href="mailto:rp.neuli@yahoo.com">rp.neuli@yahoo.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:10pt"><div style="RIGHT: auto"><span style="RIGHT: auto">thx Marc, by going to that link i was able to list all and specific user:</span></div>
<div style="RIGHT: auto"><span style="RIGHT: auto"></span> </div>
<div style="RIGHT: auto"><span style="RIGHT: auto"></span> </div>
<div style="RIGHT: auto"><span style="RIGHT: auto">I am still trying to figure how to list all users starting with letter 't'...</span></div>
<div style="RIGHT: auto"><span style="RIGHT: auto"><var id="yui-ie-cursor"></var></span> </div>
<div style="RIGHT: auto"><span style="RIGHT: auto"></span> </div>
<div style="RIGHT: auto"><span style="RIGHT: auto"></span> </div>
<div style="RIGHT: auto"><span style="RIGHT: auto">#list all users<br>print "all-users\n";<br>$users_rs = $schema->resultset('Testdbuser')->search;<br>while ($user = $users_rs->next ()){<br> print "user is: " . $user->get_column("userid") . " password is: " . $user->get_column("password") . "\n";<br> };</span></div>
<div style="RIGHT: auto"><span style="RIGHT: auto"></span> </div>
<div style="RIGHT: auto"><span style="RIGHT: auto">#list specific user, with modified column names,<br>print "\nspecific\n";<br>$users_rs = $schema->resultset('Testdbuser')->search(<br> { 'userid' => "test12" }, ## WHERE<br> { <br> select => [ qw/userid password/ ], ## SELECT<br> as => [ qw/uid pass/ ],<br> }<br> );<br>while ($user = $users_rs->next ()){<br> print "user is: " . $user->get_column("uid") . " password is: " . $user->get_column("pass") .
"\n";<br> };<br></span></div>
<div style="RIGHT: auto"><span style="RIGHT: auto"></span> </div>
<div style="RIGHT: auto"><span style="RIGHT: auto"></span> </div>
<div style="RIGHT: auto"><span style="RIGHT: auto"></span> </div>
<div><br></div>
<div style="FONT-FAMILY: verdana, helvetica, sans-serif; FONT-SIZE: 10pt">
<div style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><font size="2" face="Arial">
<div style="BORDER-BOTTOM: #ccc 1px solid; BORDER-LEFT: #ccc 1px solid; PADDING-BOTTOM: 0px; LINE-HEIGHT: 0; MARGIN: 5px 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; HEIGHT: 0px; FONT-SIZE: 0px; BORDER-TOP: #ccc 1px solid; BORDER-RIGHT: #ccc 1px solid; PADDING-TOP: 0px" class="hr" contenteditable="false" readonly="true"></div><b><span style="FONT-WEIGHT: bold">From:</span></b> Marc Logghe <<a href="mailto:logghe.marc@gmail.com">logghe.marc@gmail.com</a>><br><b><span style="FONT-WEIGHT: bold">To:</span></b> Rajeev Prasad <<a href="mailto:rp.neuli@yahoo.com">rp.neuli@yahoo.com</a>>; DBIx::Class user and developer list <<a href="mailto:dbix-class@lists.scsys.co.uk">dbix-class@lists.scsys.co.uk</a>><br><b><span style="FONT-WEIGHT: bold">Sent:</span></b> Thursday, September 1, 2011 4:50 PM<br><b><span style="FONT-WEIGHT: bold">Subject:</span></b> Re: [Dbix-class] not able to list any records from database<br></font><br>
<div id="yiv634774901"><br><br>
<div class="yiv634774901gmail_quote">On Thu, Sep 1, 2011 at 11:40 PM, Rajeev Prasad <span dir="ltr"><<a href="mailto:rp.neuli@yahoo.com" rel="nofollow" target="_blank" ymailto="mailto:rp.neuli@yahoo.com"><a href="mailto:rp.neuli@yahoo.com">rp.neuli@yahoo.com</a></a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="yiv634774901gmail_quote">
<div>
<div style="BACKGROUND-COLOR: #fff; FONT-FAMILY: verdana, helvetica, sans-serif; COLOR: #000; FONT-SIZE: 10pt">
<div>follwoing code is not printing anything...???? can anyone help plz?<var></var></div>
<div> </div>
<div> </div>
<div>#!/usr/bin/perl</div>
<div>use strict;<br>use warnings;</div>
<div>use lib '../testdb';<br>use Mysqltestdb::Schema;</div>
<div>my ($schema, $user, $users_rs);<br>my (@newusers, @oldusers);</div>
<div>$schema = Mysqltestdb::Schema->connect("dbi:mysql:dbname=mysqltestdb:localhost:3306", 'root', 'mysql5');</div>
<div>$users_rs = $schema->resultset('Testdbuser')->search(<br> { 'userid' => 'test' }, ## WHERE<br> { <br> select => [ qw/userid password/ ], ## SELECT<br> as => [ qw/uid pass/ ],<br> }<br> );<br> <br>while ($user = $users_rs->next ()){<br> print "user is:" . $user->uid . "\n";<br> };<br></div>
<div> </div>
<div> </div>
<div><br></div></div></div></blockquote>
<div><br></div>
<div> Have a look at <a href="http://search.cpan.org/~abraxxa/DBIx-Class-0.08195/lib/DBIx/Class/ResultSet.pm#as" rel="nofollow" target="_blank"><a href="http://search.cpan.org/~abraxxa/DBIx-Class-0.08195/lib/DBIx/Class/ResultSet.pm#as">http://search.cpan.org/~abraxxa/DBIx-Class-0.08195/lib/DBIx/Class/ResultSet.pm#as</a></a></div>
<div>$user->get_column('uid') or the normal accessor $user->userid should work (at least when a matching row is available)</div>
<div>cheers,</div>
<div>Marc</div></div></div>
<br><br></div></div></div></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class"><a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a></a></span><br><span>IRC: irc.perl.org#dbix-class</span><br><span>SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/"><a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a></a></span><br><span>Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk"><a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a></a></span></div></blockquote></body></html>