|
|
On Jul 25, 10:47 am, GArlington <garling...@xxxxxxxxxxxxx> wrote:
> On Jul 24, 9:41 pm, "NCX001" <webforumsu...@xxxxxxxxxxxxxx> wrote:
>
> > Hey guys, I'm kinda new to this whole programming thing so bare with me
> > please.
> > I have a little problem that I just can't seem to get my hear around. I
> > have a
> > working on an inventory management page. It keeps track of what software is
> > installed where and how many copies we have, and serials and such. Well,
> > this
> > page was set up long before I started here and it wasn't too friendly. So
> > I'm
> > editing it and adding some new features. Well one of them is displaying the
> > ?available installs count? with the search results.
>
> I suspect that
> <cfquery name="getAppsCounts" dataSource="#mainDS#">
> Select wa.id, count(wi.id) as installCount
> from workstationApps wa
> left join workstationAppIndex wi on wa.id = wi.id
> group by wa.id
> order by wa.id
> </cfquery>
> is what you are looking for, but it is NOT very clear from your
> description...
>
This is basic SQL, so if you do not know how to do it you should read
a bit about SQL ("Teach yourself SQL ..." by B.Forta was mentioned a
number of times in this and other groups)...
|
|