m.e.r.c
|
| Posted: 08/22/2002, 1:12 PM |
|
I love CC.
I love CCS.
They have both saved me innumerable amounts of time, and we create all of
our internal applications using one or the other.
I have started playing around a lot more with CCS recently, and of all the
wonderful things I've seen, there is yet another feature I'd like to see:
the capability to perform subselects in custom SQL.
I was informed that this cannot currently be done, and was asked to create
stored procedures, etc., to achieve the same goal.
Now I don't really have a major problem with this, but a) this strikes me as
being unclean in terms of trying to keep all application related-elements
centralized, and b) I can use subselects without any issues in CC. So I'm
wondering: is the architecture for CCS so different that we really won't be
able to ever see this, or is there a possibility this could be examined and
(hopefully) implemented...?
1. Has anybody else run into this?
2. Am I alone in wanting this feature?
3. Other thoughts/comments appreciated...
Jason C.
|
|
|
 |
RonB
|
| Posted: 08/23/2002, 6:43 AM |
|
I must say I havent tried it yet but I think subselects has more to do with
wehter your database supports this than with cc/ccs. If you check your code
where sql is concerned you'll see that most queries are fed to the database
as is or split appart in select and where parts. That's why I cant imagine
why subselects wouldn't be possible.
I take it with subselects you mean:
select id, name from sometable
where id in (
select other_id from other_table
where some_field=some_value and other_id in(
select yet_another_id from yet_another_table
)
)
The above statement should work fine when you use for example an oracle
database. Wouldn't work in MYSQL though.
So the problem with sql features should have more to do with the sql
standard support of your database then with cc or ccs
RonB
"m.e.r.c" <m.e.r.c@rogers.com> schreef in bericht
news:ak3gjk$lmn$1@news.codecharge.com...
> I love CC.
> I love CCS.
> They have both saved me innumerable amounts of time, and we create all of
> our internal applications using one or the other.
>
> I have started playing around a lot more with CCS recently, and of all the
> wonderful things I've seen, there is yet another feature I'd like to see:
> the capability to perform subselects in custom SQL.
>
> I was informed that this cannot currently be done, and was asked to create
> stored procedures, etc., to achieve the same goal.
>
> Now I don't really have a major problem with this, but a) this strikes me
as
> being unclean in terms of trying to keep all application related-elements
> centralized, and b) I can use subselects without any issues in CC. So I'm
> wondering: is the architecture for CCS so different that we really won't
be
> able to ever see this, or is there a possibility this could be examined
and
> (hopefully) implemented...?
>
> 1. Has anybody else run into this?
>
> 2. Am I alone in wanting this feature?
>
> 3. Other thoughts/comments appreciated...
>
> Jason C.
>
>
|
|
|
|
Shawn Mason
|
| Posted: 08/23/2002, 11:58 AM |
|
As Ron said, I have customized many sql calls to support sub-selects, inner
joins, outer joins, joins with sub-selects, and even let's all join the
party. But, my main backend is MS Sql Server and not MySql (actually for
that very reason...I am anxiously awaiting a stable version of MySql that
supports most of that).
I am also beginning to investigate PostgreSql. Any comments on it anyone?
--
Kindest Regards,
Shawn Mason,CCD,MCP
I.S. Software Design Associates
"m.e.r.c" <m.e.r.c@rogers.com> wrote in message
news:ak3gjk$lmn$1@news.codecharge.com...
> I love CC.
> I love CCS.
> They have both saved me innumerable amounts of time, and we create all of
> our internal applications using one or the other.
>
> I have started playing around a lot more with CCS recently, and of all the
> wonderful things I've seen, there is yet another feature I'd like to see:
> the capability to perform subselects in custom SQL.
>
> I was informed that this cannot currently be done, and was asked to create
> stored procedures, etc., to achieve the same goal.
>
> Now I don't really have a major problem with this, but a) this strikes me
as
> being unclean in terms of trying to keep all application related-elements
> centralized, and b) I can use subselects without any issues in CC. So I'm
> wondering: is the architecture for CCS so different that we really won't
be
> able to ever see this, or is there a possibility this could be examined
and
> (hopefully) implemented...?
>
> 1. Has anybody else run into this?
>
> 2. Am I alone in wanting this feature?
>
> 3. Other thoughts/comments appreciated...
>
> Jason C.
>
>
|
|
|
|
RonB
|
| Posted: 08/23/2002, 1:59 PM |
|
In my company we use three main databases, Oracle (clientregistration
database), solid (human resource management) and MySQL(intranet). We believe
in using the right database for the right product and will be switching the
solid database to oracle. The intranet will continue to use mysql for the
simple reason that it cant be beat in speed. I havent yet come accros a
situation in wich I needed subselects for any query in the intranet. I do
use them heavely when extracting information from the oracle database. I've
tried oracle as a backend for the intranet but that wasn't a succes. It's
just to damned slow.
So it looks like we'll settle on Oracle and MySQL and that's fine by me. Two
SQL dialects is more then enough 
RonB
"Shawn Mason" <shawn@issda.com> schreef in bericht
news:ak60kt$rf$1@news.codecharge.com...
> As Ron said, I have customized many sql calls to support sub-selects,
inner
> joins, outer joins, joins with sub-selects, and even let's all join the
> party. But, my main backend is MS Sql Server and not MySql (actually for
> that very reason...I am anxiously awaiting a stable version of MySql that
> supports most of that).
>
> I am also beginning to investigate PostgreSql. Any comments on it anyone?
>
> --
> Kindest Regards,
>
> Shawn Mason,CCD,MCP
> I.S. Software Design Associates
>
>
> "m.e.r.c" <m.e.r.c@rogers.com> wrote in message
>news:ak3gjk$lmn$1@news.codecharge.com...
> > I love CC.
> > I love CCS.
> > They have both saved me innumerable amounts of time, and we create all
of
> > our internal applications using one or the other.
> >
> > I have started playing around a lot more with CCS recently, and of all
the
> > wonderful things I've seen, there is yet another feature I'd like to
see:
> > the capability to perform subselects in custom SQL.
> >
> > I was informed that this cannot currently be done, and was asked to
create
> > stored procedures, etc., to achieve the same goal.
> >
> > Now I don't really have a major problem with this, but a) this strikes
me
> as
> > being unclean in terms of trying to keep all application
related-elements
> > centralized, and b) I can use subselects without any issues in CC. So
I'm
> > wondering: is the architecture for CCS so different that we really won't
> be
> > able to ever see this, or is there a possibility this could be examined
> and
> > (hopefully) implemented...?
> >
> > 1. Has anybody else run into this?
> >
> > 2. Am I alone in wanting this feature?
> >
> > 3. Other thoughts/comments appreciated...
> >
> > Jason C.
> >
> >
>
>
|
|
|
|
|
