Imran
|
| Posted: 09/06/2002, 2:31 PM |
|
Is there a way to pair two fields that you want to appear in a pick list
together? Like first and last name.
Currently, I just hack the code. Is there a way directly within CCS?
Thanks.,
Imran.
|
|
|
 |
Imran
|
| Posted: 09/06/2002, 3:29 PM |
|
To clarify, I'm talking about pairing two sql columns. Currently I'm just
using + to put first and last name together. I'd rather not hack the code if
CCS has a built in way to pair two fields together.
"Imran" <imranz@knight-images.com> wrote in message
news:alb6ra$hto$1@news.codecharge.com...
> Is there a way to pair two fields that you want to appear in a pick list
> together? Like first and last name.
>
> Currently, I just hack the code. Is there a way directly within CCS?
>
> Thanks.,
> Imran.
>
>
|
|
|
|
RonB
|
| Posted: 09/07/2002, 2:11 AM |
|
If you mean getting info from several columns in one textfield I just use
the sql concatenate function:
select emp_id, emp_ftrstname||' '||emp_lastname as name from employees
Comes in handy for listboxes.
I don't think there's something in CCS to do this automaticaly.
RonB
"Imran" <imranz@knight-images.com> schreef in bericht
news:alba8n$nsl$1@news.codecharge.com...
> To clarify, I'm talking about pairing two sql columns. Currently I'm just
> using + to put first and last name together. I'd rather not hack the code
if
> CCS has a built in way to pair two fields together.
>
>
> "Imran" <imranz@knight-images.com> wrote in message
>news:alb6ra$hto$1@news.codecharge.com...
> > Is there a way to pair two fields that you want to appear in a pick list
> > together? Like first and last name.
> >
> > Currently, I just hack the code. Is there a way directly within CCS?
> >
> > Thanks.,
> > Imran.
> >
> >
>
>
|
|
|
|
Carl
|
| Posted: 09/07/2002, 5:44 AM |
|
You can always do it at the database level by creating a view that
concatenates the columns and the use the view instead of the table.
Carl
"RonB" <r.borkent@123chello.456nl> wrote in message
news:alcfs9$pm9$1@news.codecharge.com...
> If you mean getting info from several columns in one textfield I just use
> the sql concatenate function:
>
> select emp_id, emp_ftrstname||' '||emp_lastname as name from employees
>
> Comes in handy for listboxes.
> I don't think there's something in CCS to do this automaticaly.
>
> RonB
|
|
|
|
RonB
|
| Posted: 09/07/2002, 2:26 PM |
|
That's possible, when the databse you use supports views. I use mainly MySQL
wich doesn't and Oracle once in a while wich does. But beside that.. I dont
believe in creating tables that give you information already present in the
database. A view is handy when handling complex multi table query's. The sql
for concatenating info from one table is to easy to make a view. Just my
opinion.
RonB
"Carl" <herrecm@itis.net> schreef in bericht
news:alcsbm$fnj$1@news.codecharge.com...
> You can always do it at the database level by creating a view that
> concatenates the columns and the use the view instead of the table.
>
> Carl
>
> "RonB" <r.borkent@123chello.456nl> wrote in message
>news:alcfs9$pm9$1@news.codecharge.com...
> > If you mean getting info from several columns in one textfield I just
use
> > the sql concatenate function:
> >
> > select emp_id, emp_ftrstname||' '||emp_lastname as name from employees
> >
> > Comes in handy for listboxes.
> > I don't think there's something in CCS to do this automaticaly.
> >
> > RonB
>
>
>
|
|
|
|
Carl
|
| Posted: 09/08/2002, 1:24 PM |
|
You make some valid points Ron, however, a view does not contain any data.
It is, as the name implies, a way to look at ("view") the data. So if you
create a thousand views, you make little impact on the size of your DB or
the DB itself.
I agree that for simple stuff doing it right in the SQL statement is
expedient. Views are an alternative for those that don't like or know SQL
and want to use the view builders/wizard in their DB of choice. If (BIG IF)
I remember correctly (I could be WAY OFF here), I think that the same
calculation will execute a tad faster in a view than as part of an SQL
statement in some systems.
Well, there's one (large) strike against MySQL, no views. I know on this NG
it's blasphemous to speak ill of MySQL and twice as irreverent to speak well
of MS Access. I'm *doubly* culpable. Must go to confession (bows head in
shame).
Carl
"RonB" <r.borkent@123chello.456nl> wrote in message
news:aldqul$6qk$1@news.codecharge.com...
> That's possible, when the databse you use supports views. I use mainly
MySQL
> wich doesn't and Oracle once in a while wich does. But beside that.. I
dont
> believe in creating tables that give you information already present in
the
> database. A view is handy when handling complex multi table query's. The
sql
> for concatenating info from one table is to easy to make a view. Just my
> opinion.
>
> RonB
>
> "Carl" <herrecm@itis.net> schreef in bericht
>news:alcsbm$fnj$1@news.codecharge.com...
> > You can always do it at the database level by creating a view that
> > concatenates the columns and the use the view instead of the table.
> >
> > Carl
> >
> > "RonB" <r.borkent@123chello.456nl> wrote in message
> >news:alcfs9$pm9$1@news.codecharge.com...
> > > If you mean getting info from several columns in one textfield I just
> use
> > > the sql concatenate function:
> > >
> > > select emp_id, emp_ftrstname||' '||emp_lastname as name from employees
> > >
> > > Comes in handy for listboxes.
> > > I don't think there's something in CCS to do this automaticaly.
> > >
> > > RonB
> >
> >
> >
>
>
|
|
|
|
RonB
|
| Posted: 09/09/2002, 4:13 AM |
|
Don't be ashamed, please..
Acces is a great product if your doing a database for up to ten users. My
company has 350+ user for the intranet. using acces would be suicide. It
just wasn't meant for that. MS has sql server as a product for such demands.
I just don't like paying thrue the nose for a product I can also get for
free. MySQL has it's limitations, sure. Just pick the right database for the
right job. Wouldn't dream of using mysql for our clientregistration
software(runs on oracle) but for the intranet i haven't found a good
alternative (in speed especialy) yet.
RonB
"Carl" <herrecm@itis.net> schreef in bericht
news:algbmf$moc$1@news.codecharge.com...
> You make some valid points Ron, however, a view does not contain any data.
> It is, as the name implies, a way to look at ("view") the data. So if you
> create a thousand views, you make little impact on the size of your DB or
> the DB itself.
>
> I agree that for simple stuff doing it right in the SQL statement is
> expedient. Views are an alternative for those that don't like or know SQL
> and want to use the view builders/wizard in their DB of choice. If (BIG
IF)
> I remember correctly (I could be WAY OFF here), I think that the same
> calculation will execute a tad faster in a view than as part of an SQL
> statement in some systems.
>
> Well, there's one (large) strike against MySQL, no views. I know on this
NG
> it's blasphemous to speak ill of MySQL and twice as irreverent to speak
well
> of MS Access. I'm *doubly* culpable. Must go to confession (bows head in
> shame).
>
> Carl
>
> "RonB" <r.borkent@123chello.456nl> wrote in message
>news:aldqul$6qk$1@news.codecharge.com...
> > That's possible, when the databse you use supports views. I use mainly
> MySQL
> > wich doesn't and Oracle once in a while wich does. But beside that.. I
> dont
> > believe in creating tables that give you information already present in
> the
> > database. A view is handy when handling complex multi table query's. The
> sql
> > for concatenating info from one table is to easy to make a view. Just my
> > opinion.
> >
> > RonB
> >
> > "Carl" <herrecm@itis.net> schreef in bericht
> >news:alcsbm$fnj$1@news.codecharge.com...
> > > You can always do it at the database level by creating a view that
> > > concatenates the columns and the use the view instead of the table.
> > >
> > > Carl
> > >
> > > "RonB" <r.borkent@123chello.456nl> wrote in message
> > >news:alcfs9$pm9$1@news.codecharge.com...
> > > > If you mean getting info from several columns in one textfield I
just
> > use
> > > > the sql concatenate function:
> > > >
> > > > select emp_id, emp_ftrstname||' '||emp_lastname as name from
employees
> > > >
> > > > Comes in handy for listboxes.
> > > > I don't think there's something in CCS to do this automaticaly.
> > > >
> > > > RonB
> > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Carl
|
| Posted: 09/09/2002, 3:16 PM |
|
True. MS has done something nifty with W2K. It has some kind of DB
optimizer so that just about any DB will run fine on it. For example, if
you take a 1.8 mm record DB on NT 4 and do a search on a text field with
LIKE '%content%', you better go brew a pot of coffee, drink some, go
shopping and come back. The same query on the same DB works quite well on
W2K.
"RonB" <r.borkent@123chello.456nl> wrote in message
news:alhvpg$ka4$1@news.codecharge.com...
> Don't be ashamed, please..
> Acces is a great product if your doing a database for up to ten users. My
> company has 350+ user for the intranet. using acces would be suicide. It
> just wasn't meant for that. MS has sql server as a product for such
demands.
> I just don't like paying thrue the nose for a product I can also get for
> free. MySQL has it's limitations, sure. Just pick the right database for
the
> right job. Wouldn't dream of using mysql for our clientregistration
> software(runs on oracle) but for the intranet i haven't found a good
> alternative (in speed especialy) yet.
>
> RonB
|
|
|
|
|
