Brian Gubb
|
| Posted: 10/27/2002, 3:57 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C27E1D.0D8EF820
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Can someone point me into the right direction as to how to prevent =
duplicated names from appearing in a list box?
Thanks
Brian
------=_NextPart_000_0008_01C27E1D.0D8EF820
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Can someone point me into the right direction as to =
how to=20
prevent duplicated names from appearing in a list box?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks</FONT></DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BODY></HTML>
------=_NextPart_000_0008_01C27E1D.0D8EF820--
|
|
|
 |
Dave Rexel
|
| Posted: 10/27/2002, 6:07 AM |
|
if the listbox is being populated from a DB pls use SELECT DISTINCT to avoid
duplicate entries
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:apgkc1$o6n$1@news.codecharge.com...
Can someone point me into the right direction as to how to prevent
duplicated names from appearing in a list box?
Thanks
Brian
|
|
|
|
Brian Gubb
|
| Posted: 11/02/2002, 8:58 PM |
|
Thanks for the reply, but I think I need a CCS for dummies book. I've tried
to work out how or where to use/put SELECT DISTINCT to no avail. Could you
please explain it for me in detail?
Thanks, Brian
"Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
news:apgrv0$7hr$1@news.codecharge.com...
> if the listbox is being populated from a DB pls use SELECT DISTINCT to
avoid
> duplicate entries
>
>
> "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
>news:apgkc1$o6n$1@news.codecharge.com...
> Can someone point me into the right direction as to how to prevent
> duplicated names from appearing in a list box?
>
> Thanks
> Brian
>
>
|
|
|
|
Dave Rexel
|
| Posted: 11/03/2002, 4:40 AM |
|
Hello Brian
Did you follow my reply to you in June? I would also suggest enrolling in a
instructor-led course (if you can find one) if you need to learn database
and application programming.
There are many good sites that detail the building of applications, pick the
one using your script-language and apply the knowledge to your CCS projects.
I would like to suggest
http://www.sqlcourse.com/
as an excellent online site to learn useful SQL
The SELECT DISTINCT is custom SQL and can be written in the Query Builder
when you choose SQL as the Data Source Type in CCS.
Regards
Dave
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:aq2ae3$bj4$1@news.codecharge.com...
> Thanks for the reply, but I think I need a CCS for dummies book. I've
tried
> to work out how or where to use/put SELECT DISTINCT to no avail. Could you
> please explain it for me in detail?
>
> Thanks, Brian
>
>
>
> "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
>news:apgrv0$7hr$1@news.codecharge.com...
> > if the listbox is being populated from a DB pls use SELECT DISTINCT to
> avoid
> > duplicate entries
> >
> >
> > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> >news:apgkc1$o6n$1@news.codecharge.com...
> > Can someone point me into the right direction as to how to prevent
> > duplicated names from appearing in a list box?
> >
> > Thanks
> > Brian
> >
> >
>
>
|
|
|
|
Brian Gubb
|
| Posted: 11/04/2002, 3:12 AM |
|
Thanks Dave, I forgotten about your reply in June when my Codecharge free
trial expired.
Thanks for helping me again, that site is very good and now I'm ready to do
something with it.
Brian
"Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
news:aq35g4$spc$1@news.codecharge.com...
> Hello Brian
>
> Did you follow my reply to you in June? I would also suggest enrolling in
a
> instructor-led course (if you can find one) if you need to learn database
> and application programming.
>
> There are many good sites that detail the building of applications, pick
the
> one using your script-language and apply the knowledge to your CCS
projects.
>
> I would like to suggest
>
> http://www.sqlcourse.com/
>
> as an excellent online site to learn useful SQL
>
> The SELECT DISTINCT is custom SQL and can be written in the Query Builder
> when you choose SQL as the Data Source Type in CCS.
>
> Regards
> Dave
>
> "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
>news:aq2ae3$bj4$1@news.codecharge.com...
> > Thanks for the reply, but I think I need a CCS for dummies book. I've
> tried
> > to work out how or where to use/put SELECT DISTINCT to no avail. Could
you
> > please explain it for me in detail?
> >
> > Thanks, Brian
> >
> >
> >
> > "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
> >news:apgrv0$7hr$1@news.codecharge.com...
> > > if the listbox is being populated from a DB pls use SELECT DISTINCT to
> > avoid
> > > duplicate entries
> > >
> > >
> > > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> > >news:apgkc1$o6n$1@news.codecharge.com...
> > > Can someone point me into the right direction as to how to prevent
> > > duplicated names from appearing in a list box?
> > >
> > > Thanks
> > > Brian
> > >
> > >
> >
> >
>
>
|
|
|
|
Dave Rexel
|
| Posted: 11/04/2002, 1:23 PM |
|
You're welcome,
Dave
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:aq5kmu$53n$1@news.codecharge.com...
> Thanks Dave, I forgotten about your reply in June when my Codecharge free
> trial expired.
>
> Thanks for helping me again, that site is very good and now I'm ready to
do
> something with it.
>
> Brian
>
> "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
>news:aq35g4$spc$1@news.codecharge.com...
> > Hello Brian
> >
> > Did you follow my reply to you in June? I would also suggest enrolling
in
> a
> > instructor-led course (if you can find one) if you need to learn
database
> > and application programming.
> >
> > There are many good sites that detail the building of applications, pick
> the
> > one using your script-language and apply the knowledge to your CCS
> projects.
> >
> > I would like to suggest
> >
> > http://www.sqlcourse.com/
> >
> > as an excellent online site to learn useful SQL
> >
> > The SELECT DISTINCT is custom SQL and can be written in the Query
Builder
> > when you choose SQL as the Data Source Type in CCS.
> >
> > Regards
> > Dave
> >
> > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> >news:aq2ae3$bj4$1@news.codecharge.com...
> > > Thanks for the reply, but I think I need a CCS for dummies book. I've
> > tried
> > > to work out how or where to use/put SELECT DISTINCT to no avail. Could
> you
> > > please explain it for me in detail?
> > >
> > > Thanks, Brian
> > >
> > >
> > >
> > > "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
> > >news:apgrv0$7hr$1@news.codecharge.com...
> > > > if the listbox is being populated from a DB pls use SELECT DISTINCT
to
> > > avoid
> > > > duplicate entries
> > > >
> > > >
> > > > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> > > >news:apgkc1$o6n$1@news.codecharge.com...
> > > > Can someone point me into the right direction as to how to prevent
> > > > duplicated names from appearing in a list box?
> > > >
> > > > Thanks
> > > > Brian
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
RonB
|
| Posted: 11/04/2002, 11:52 PM |
|
Hi,
This, http://www.sqlcourse.com , is a good place to start. It's free and you
can test the sql online against there database. You'll quickly get the
basics of sql.
RonB
"Brian Gubb" <b.gubb@clear.net.nz> schreef in bericht
news:aq2ae3$bj4$1@news.codecharge.com...
> Thanks for the reply, but I think I need a CCS for dummies book. I've
tried
> to work out how or where to use/put SELECT DISTINCT to no avail. Could you
> please explain it for me in detail?
>
> Thanks, Brian
>
>
>
> "Dave Rexel" <therex_spamenot@hotmail.com> wrote in message
>news:apgrv0$7hr$1@news.codecharge.com...
> > if the listbox is being populated from a DB pls use SELECT DISTINCT to
> avoid
> > duplicate entries
> >
> >
> > "Brian Gubb" <b.gubb@clear.net.nz> wrote in message
> >news:apgkc1$o6n$1@news.codecharge.com...
> > Can someone point me into the right direction as to how to prevent
> > duplicated names from appearing in a list box?
> >
> > Thanks
> > Brian
> >
> >
>
>
|
|
|
|
|
