[CDBI] Simple join

[prev] [thread] [next] [Date index for 2005/12/30]

--===============1692384321==
Content-Type: multipart/alternative; 
	boundary="----=_Part_71382_8983016.1135901806378"

------=_Part_71382_8983016.1135901806378
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi list,

I've just started looking at Class:DBI after only using DBI directly with
own written sql. I've read through the beginners guide and there's one thin=
g
I wonder about:

In the search_like example:

my @cd =3D Music::CD->search_like(title =3D> 'Hits%', artist =3D> 'Various%=
');

It searches for "cd.title like 'Hits%' or artist.name like 'Varios%'"? I
can't really understand how to make a  relationship that makes such a join.
I need one of them with a similar db but can't find examples except this in
the documentation.

Any pointers?

Thanks

------=_Part_71382_8983016.1135901806378
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi list,<br>
<br>
I've just started looking at Class:DBI after only using DBI directly
with own written sql. I've read through the beginners guide and there's
one thing I wonder about:<br>
<br>
In the search_like example:<br>
<pre>my @cd =3D Music::CD-&gt;search_like(title =3D&gt; 'Hits%', artist =3D=
&gt; 'Various%');<br></pre>
It searches for &quot;cd.title like 'Hits%' or <a href=3D"http://artist.nam=
e">artist.name</a> like 'Varios%'&quot;?
I can't really understand how to make a&nbsp; relationship that makes
such a join. I need one of them with a similar db but can't find
examples except this in the documentation.<br>
<br>
Any pointers?<br>
<br>
Thanks <br>
<br>

------=_Part_71382_8983016.1135901806378--


--===============1692384321==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

--===============1692384321==--