Re: where x in (a,b,c)

[prev] [thread] [next] [Date index for 2005/04/08]

From: Barry Moore
Subject: Re: where x in (a,b,c)
Date: 17:19 on 08 Apr 2005
This is a multi-part message in MIME format.
--------------000304070208040605050003
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit


my @people = People->retrieve_from_sql(name IN  (Ralph, Jane, Egbert));

Barry Dancis wrote:

> Hi --
>  
>     Is there a way to do a retrieve or search using cdbi for a subset 
> of the records using an In operator, i.e. is there something like:
>  
> my @people = People->retrieve(Name In qw (Ralph Jane Egbert);
>  
> Thanks,
>  
> Barry
>  
> 215-885-5187


        -- 
        Barry Moore
Dept. of Human Genetics
University of Utah
Salt Lake City, UT


--------------000304070208040605050003
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<br>
<font face="Arial" size="2">my @people =
People-&gt;retrieve_from_sql(name IN&nbsp; (Ralph, Jane, Egbert));</font><br>
<br>
Barry Dancis wrote:<br>
<blockquote type="cite"
 cite="mid01d901c53c4a$37a8c120$6701a8c0@BarryDell">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta content="MSHTML 6.00.2900.2604" name="GENERATOR">
  <style></style>
  <div><font face="Arial" size="2">Hi --</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">&nbsp;&nbsp;&nbsp; Is there a way to do a retrieve
or search using cdbi for a subset of the records using an In operator,
i.e. is there something like:</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">my @people =
People-&gt;retrieve(Name In qw (Ralph Jane Egbert);</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">Thanks,</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">Barry</font></div>
  <div>&nbsp;</div>
  <div><font face="Arial" size="2">215-885-5187</font></div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 
Barry Moore
Dept. of Human Genetics
University of Utah
Salt Lake City, UT
</pre>
</body>
</html>

--------------000304070208040605050003--


where x in (a,b,c)
Barry Dancis 14:49 on 08 Apr 2005

Re: where x in (a,b,c)
Cees Hek 14:58 on 08 Apr 2005

Re: where x in (a,b,c)
Barry Dancis 16:03 on 08 Apr 2005

Re: where x in (a,b,c)
Perrin Harkins 16:00 on 08 Apr 2005

Re: where x in (a,b,c)
Barry Moore 17:19 on 08 Apr 2005

Generated at 14:42 on 11 Apr 2005 by mariachi v0.52