<br><br><div class="gmail_quote">On 17 May 2011 15:22, Bill Moseley <span dir="ltr"><<a href="mailto:moseley@hank.org">moseley@hank.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div></div></div><div class="gmail_quote"><div><div class="h5"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div bgcolor="#ffffff"><blockquote style="padding-right:0px;padding-left:5px;margin-left:5px;border-left:#000000 2px solid;margin-right:0px">
<div><br>I have two databases that are
very similar. For example, the "person" table in one db has an "email"
column and the other does not have that column, otherwise the tables are the
same.
<div>... </div></div></blockquote></div></blockquote></div></div></div></blockquote><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="gmail_quote"><div><div class="h5">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div bgcolor="#ffffff"><blockquote style="padding-right:0px;padding-left:5px;margin-left:5px;border-left:#000000 2px solid;margin-right:0px">
<div><div>My question is what can I do to make get_column and create (and other
methods that assume there is an "email" column) work without this column
defined in the result class. Is there any way to have define a column
that is never used when constructing database queries?<font face="Arial" size="2"></font></div>
<div><font face="Arial" size="2"></font><font face="Arial" size="2"></font><br></div>
<div><br></div></div></blockquote></div></blockquote></div></div></div></blockquote><div><br></div><div>Can you say</div><div><br></div><div>my $search_attr = {</div><div> '+columns' => [ { 'email' => \'' } ], # and so on for other missing fields</div>
<div>};</div><div><br></div><div>then</div><div><br></div><div>my $rs = $schema->search_rs( $query, $search_attr );</div><div><br></div><div> </div><div>Regards, Peter</div><div><a href="http://perl.dragonstaff.co.uk">http://perl.dragonstaff.co.uk</a></div>
<div><br></div></div>