> What if you need to display the count _above_ the enumerated items?
>
>
> #xx.category# (#count# items)
>
>
>
>
You have a couple of options. You could bring back the count in your SQL
query, by using COUNT and GROUPing BY the field that you're ORDERing BY now.
Or, you could u
Please disregard that last post I made. I discovered that I was naming something with
a lower case in the JS and the form had it with an upper case. DUH!!
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusiona
What database are you using
You may be able to accomplish something using "WITH ROLLUP" but I am no
expert on that.
You may also be able to have the db return two result sets, one with data,
one with counts per group. That would depend on engine.
Otherwise I don't see any way to do it without maki
What if you need to display the count _above_ the enumerated items?
#xx.category# (#count# items)
-Original Message-
From: Don Vawter <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Saturday, August 18, 2001 2:41 PM
Subject: Re: cfoutput group count
>Just i
Just initialize a counter before the group and increment it within the group
The count for the group is #ct#
...
- Original Message -
From: "Eric J Hoffman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAI
You could add a COUNT() to your query...
Once you add a "Scalar/Aggregate" function to your SQL you will need to
specify al the fields in the GROUP BY though.
SELECT
table1.field1,
table2.field1,
COUNT(table2.field1) AS CountField1
FROM
table1 INNER JOIN table2 ON table1.ID=table2.Foreign
I know this is easy, but I need sleep. How can I easily get the number of
records returned per grouping in a cfoutput query?
Eric J Hoffman
Small Dog Design, LLC
www.smalldogdesign.com
~~
Structure your ColdFusion code with Fusebox. Get the offi
We currently get about 400,00 hits per day on a cluster of CF 4 servers we
have and about 900,000 transactions per day to our 3 read MS SQL7 databases.
I have developed about 40 stored procedures that limited about 90% of the
CFQUERIES to Stored procs.
My questions is about 20 times a day we ge
Bryan, thanks for the code, this is doing almost exactly what i need, except
it is not showing me all the files in the folder...
just the sub folders
if you have a moment, how can i modify it to show me the files?
~~
Stephenie Hamilton
Macromedia Certified ColdFusion Professional
http://coldfu
Does anyone do a lot of email parsing? We have started an email campaign
and since we are using a customer database up to two years old...from each
27,000 emails I send...I am getting around 9-12k underliverables...out of
office...autoreplys...and others
Attempting to handle at least 90% of
Thank you so much, Dick and Marius. It works.
Dick Applebaum wrote:
> Try:
>
>insert into address
> (name,phone,address)
>
> select name, phone,address from prod_address
>
> HTH
>
> Dick
>
> At 11:36 PM -0600 8/17/01, Nathan Chen wrote:
> >Hi, There,
> >Can someone show me how do
I know that this is not CF related, but I do not like the JS forum because there are
way to many messages flowing around. What is the best way to allow nulls to be
accepted from a child window to a parent window. I have this script;
function saveLease() {
document.Part_1.L_Lease_Type.value = ch
Also - you have to worry about the new patches from microsoft that cut off
long URLs.. as well as firewalls that are now looking for long URLs.. it
might make sense to stay away from long urls from now on..
Al
At 07:45 PM 8/17/2001 -0400, you wrote:
> > First Template
> >
> >
> >
> > Secon
I may be paranoid (actually - I would only be paranoid if people aren't
actually trying to break into my machine... I am watching my Blackice
Defender graph now - I had 1,500 attacks in the last 90 minutes:), but when
i do things like this, I would pass 2 UUIDs through the URL... one is the
You don't need the keyword values unless you are specifically specify them
insert into address (name,phone,address)
select name, phone,address from prod_address
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd
Yvette, wouldn't a simple solution be to store the data in a session
variable then pick it up on the receiving end? You can add a switch
to the querystring if needed.
First template:
Second template:
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_
Todd Ashworth wrote:
> I telneted to the oli.tudelft.nl on port 110 and that's the response I got
> back.
You just checked whether I could pick up my email (thank you), not
whether you could deliver it to me there. I stated port 25 (SMTP) while
you checked port 110 (POP).
Jochem
17 matches
Mail list logo
