Select Distinct - Howto??
[prev]
[thread]
[next]
[Date index for 2005/06/10]
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C56E01.13906520
Content-Type: text/plain;
charset="iso-8859-1"
Thanks for reading.
I'm rather new to CDBI, but am slowly getting my head around it. Been
through the archives, wiki and the docs, but I can't figure out how to
select distinct records. I know how to do it SQL wise, but can't seem to
make the leap with CDBI. add_constructor or retrieve_from_sql doesn't look
exactly like what I need. I'm looking for the CDBI equivalent to 'select
distinct address from photos where projno=?'.
TIA
Mark Schoonover
IS Manager
American Geotechnical
v - 714-685-3900
f - 714-685-3909
"We are Linux. Resistance is measured in Ohms."
------_=_NextPart_001_01C56E01.13906520
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=539140421-10062005><FONT face=Arial size=2>Thanks for
reading.</FONT></SPAN></DIV>
<DIV><SPAN class=539140421-10062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=539140421-10062005> <FONT face=Arial
size=2>I'm rather new to CDBI, but am slowly getting my head around it. Been
through the archives, wiki and the docs, but I can't figure out how to select
distinct records. I know how to do it SQL wise, but can't seem to make the leap
with CDBI. add_constructor or retrieve_from_sql doesn't look exactly like what I
need. I'm looking for the CDBI equivalent to 'select distinct address from
photos where projno=?'.</FONT></SPAN></DIV>
<DIV><SPAN class=539140421-10062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=539140421-10062005><FONT face=Arial
size=2>TIA</FONT></SPAN></DIV>
<P><FONT face="Courier New" size=2>Mark Schoonover</FONT> <BR><FONT
face="Courier New" size=2>IS Manager</FONT> <BR><FONT face="Courier New"
size=2>American Geotechnical</FONT> <BR><FONT face="Courier New" size=2>v -
714-685-3900</FONT> <BR><FONT face="Courier New" size=2>f - 714-685-3909</FONT>
</P>
<P><FONT face="Courier New" size=2>"We are Linux. Resistance is measured in
Ohms."</FONT> </P>
<DIV> </DIV></BODY></HTML>
------_=_NextPart_001_01C56E01.13906520--
 |
Select Distinct - Howto??
Mark Schoonover 21:12 on 10 Jun 2005
|
