> ok... i tried both suggestions and am still getting the
> same error:
>
> here is my new code:
>
>
> SELECT * FROM price WHERE ID = (SELECT MAX(ID) FROM price)
>
>
> ...
>
> and here is the error message:
> Element REPVOL is undefined in CURRENT QUERY
My guess is that you don't have a fie
also getting "Variable REPVOL is undefined" when i use my queries and throw ouput
around tr tags
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm
ok... i tried both suggestions and am still getting the same error:
here is my new code:
SELECT * FROM price WHERE ID = (SELECT MAX(ID) FROM price)
lto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 5:32 PM
To: CF-Talk
Subject: please help me with cfoutput
Below is an exerpt of my code that is applicable. Whats weird is that
the first cfoutput gives me an error, "repvol is undefined", and the
second cfoutput works (of course I have to
ww.macromedia.com/v1/handlers/index.cfm?ID=21816
> Below is an exerpt of my code that is applicable. Whats
> weird is that
> the first cfoutput gives me an error, "repvol is
> undefined", and the
> second cfoutput works (of course I have to rid the first
> one to see
Below is an exerpt of my code that is applicable. Whats weird is that
the first cfoutput gives me an error, "repvol is undefined", and the
second cfoutput works (of course I have to rid the first one to see so
that it will process the second). Both are working valid fields in my
d
Thx for looking, Sean. The comment you referenced was what I was keying
on.
>I'd imagine "do something" and "do something else" are alternative ways
>to set up the data for the presentation section of the page
Yup. Any action to process the current data in some way.
>and that "call security"
On Thursday, Jun 26, 2003, at 16:37 US/Pacific, Matt Robertson wrote:
> Great resource, those coding guidelines.
Thanx. I intend to publish a revised set of guidelines this summer that
take into account my team's experiences with developing about a quarter
of a million lines of CFMX code that is
Sean,
Great resource, those coding guidelines. I have a related question.
I noticed the guidelines specify removing cf processing into a physically different
template. Is it such a bad thing to keep a template and any directly associated
actions in the same file for the sake of keeping uniq
Ah. Didn't know that things changed since MX. Very cool (and much less
painful, heh). Thanks for the link also - very useful.
-Rich
-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 4:31 PM
To: CF-Talk
Subject: Re: The Verbosity of CFO
On Thursday, Jun 26, 2003, at 12:02 US/Pacific, Rich Z wrote:
> I am a big fan and advocate of CFML, but I have to confess, I've grown
> so tired of wrapping cfoutput tags around values like
> #this#. Now I know I could put Cfoutputs at the
> top
> and bottom of my page (or bl
I have become a fan of the WriteOutput() function. For your example below, you can do
. I like it because it's quicker to type than a pair cfoutput
tags, and it is easier to read and write (and perhaps more efficient to execute) when
you just need to output one little thing in the middle
ile cycle after that).
Regardless of all that mumbo-jumbo, I'd say wrap your block in a single
CFOUTPUT, because it makes the code easier to read. The performance hit is
going to be minimal compared to a DB access or something, so unless you're
to the knife's edge on opt
I am a big fan and advocate of CFML, but I have to confess, I've grown
so tired of wrapping cfoutput tags around values like
#this#. Now I know I could put Cfoutputs at the top
and bottom of my page (or block) and save myself some hassle, but I've
read in numerous places that this is ba
Try saving the queries out of the array if you
need to use cfloop /cfoutput. (Just a thought)
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 22 March 2003 3:19 AM
> To: CF-Talk
> Subject: RE: Array of Queries and CFOutput
>
I'm guessing cfoutput query="" doesn't evaluate the string correctly.
You have already found a workaround though, just don't use output
query="". Use the wishform to log a bug for this.
===
Ray
I don't know if this is a bug, undocumented feature or correct behavior?
But has anybody run into this before?
I have some code such as this in a CFC creating an array of queries.
SELECT Field1, Field2, Field3
FROM Table1
WHERE ID = #IDVar#
SELECT F
Peter Mayer wrote:
>
> I know this example isn't very good but the general question still exists
> if it is a bug that during a cfloop within a cfoutput always the first row
> is returned and not the currentrow record.
Presuming this is your actual question: some call it a bug
I have mentioned this workaround already in my original posting (see
under "my workaround"). ;-)
This "error" (?) occurs every time I use this construction.
Best regards,
Peter
Orginale Nachricht
Von: "Kevin Langevin" <[EMAIL PROTECTED]>
Be
as a
matter of course, and then I don't have to worry about it.
-Kev
-Original Message-
From: Ryan Emerle [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 11:55 AM
To: CF-Talk
Subject: RE: cfoutput + cfloop: bug or
Did you try this?
#query1.wha
customerid = #customers.id#
#selectitems.itemtitle # (ordered by: #customers.name#)
I know this example isn't very good but the general question still exists
if it is a bug that during a cfloop within a cfoutput always the first row
is returned and not the currentrow record.
Best re
teration should be separate, i rarely
use cfouput to iterate through loops.
HTH
--
Ryan Emerle
-Original Message-
From: Peter Mayer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 9:26 AM
To: CF-Talk
Subject: cfoutput + cfloop: bug or
Hello!
I have two queries - the output o
Peter,
> I have two queries - the output of the first one is handled by a cfoutput
>
> tag, the second one is handled by a cfloop (nested construction):
>
>
> bla bla #query1.name#:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.house
sults.
FWIW,
-lincoln
-Original Message-
From: Peter Mayer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 9:26 AM
To: CF-Talk
Subject: cfoutput + cfloop: bug or
Hello!
I have two queries - the output of the first one is handled by a cfoutput
tag, the second one is handled
2003 14:26
To: CF-Talk
Subject: cfoutput + cfloop: bug or
Hello!
I have two queries - the output of the first one is handled by a cfoutput
tag, the second one is handled by a cfloop (nested construction):
bla bla #query1.name#:
bla bla #query1.name#:
http://www.houseoffusion.com/cf_lists
Hello!
I have two queries - the output of the first one is handled by a cfoutput
tag, the second one is handled by a cfloop (nested construction):
bla bla #query1.name#:
bla bla #query1.name#:
http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http
lk
Subject: UDF always returning "YES" no "NO" when I call it in a cfoutput
Is there a way to get rid of the "YES" no "NO" from a UDF
I have a UDF
function someFunction(param)
{
}
when I call someFuntion like this:
#someFunction(param)#
the outp
To: CF-Talk
> > Subject: UDF always returning "YES" no "NO" when I call it in
> > a cfoutput
> >
> >
> > Is there a way to get rid of the "YES" no "NO" from a UDF
> >
> > I have a UDF
> >
> >
h Weiming [mailto:[EMAIL PROTECTED]]
: Sent: Wednesday, January 22, 2003 5:06 PM
: To: CF-Talk
: Subject: UDF always returning "YES" no "NO" when I call it in a cfoutput
:
:
: Is there a way to get rid of the "YES" no "NO" from a UDF
:
: I have a UDF
:
: funct
Try
function someFunction(param)
{
return "";
}
I guess you're using UDF to send content?
At 05:06 PM 1/22/2003, you wrote:
>Is there a way to get rid of the "YES" no "NO" from a UDF
>
>I have a UDF
>
>function someFunction(param)
>{
>}
>
>when I call someFuntion like this:
>
>
> #someFunct
ly it is." - Yoda
> -Original Message-
> From: Huynh Weiming [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 22, 2003 4:06 PM
> To: CF-Talk
> Subject: UDF always returning "YES" no "NO" when I call it in
> a cfoutput
>
>
>
Is there a way to get rid of the "YES" no "NO" from a UDF
I have a UDF
function someFunction(param)
{
}
when I call someFuntion like this:
#someFunction(param)#
the output is as follow:
someFunction result
and the word "YES" or "NO" following the result
thanks.
~
access the the firstname field of a query you named
"FirstnameLastname"
(In the CFQUERY statement; )
you would use the variable;FirstnameLastname.firstname
(queryname.fieldname).
Using the CFOUTPUT tag with the 'query' parameter also does something
special.. It tells ColdF
Tom, you're welcome. My pleasure to be of assistance.
~Dina
- Original Message -
From: Tom Forbes
To: CF-Talk
Sent: Tuesday, December 10, 2002 1:41 PM
Subject: Re: CFOUTPUT group by & recordcount HELP
Dear Dina Hess,
Thank you very much for taking the time thi
>
>
>
>
>
> #num_cat_recs#
>
>
>
>
>#DomainName#
>
>
>
> - Original Message -
> From: Tom Forbes
> To: CF-Talk
> Sent: Monday, December 09, 2002 9:28 PM
> Subject: CFOUTPUT group by & recordcount HE
DomainName#
- Original Message -
From: Tom Forbes
To: CF-Talk
Sent: Monday, December 09, 2002 9:28 PM
Subject: CFOUTPUT group by & recordcount HELP
I have checked my books and the CF achieve, but need a little help in the
right direction, please.
I have a
I have checked my books and the CF achieve, but need a little help in the
right direction, please.
I have a db table that contains, among other things, Domain Names and about
20 Different Domain Name Categories. I want to Output the results of this
db table by GROUPING the Domain Name Categorie
IIRC, yes. Just pound them in the subject string.
--Ben Doom
Programmer & General Lackey
Moonbow Software
: -Original Message-
: From: Clark, Aimee [mailto:[EMAIL PROTECTED]]
: Sent: Monday, December 09, 2002 10:59 AM
: To: CF-Talk
: Subject: Using cfoutput in Emails
:
:
Inc.
http://www.4guys.com
"We create websites that make you a hero."
-Original Message-
From: Clark, Aimee [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 9:59 AM
To: CF-Talk
Subject: Using cfoutput in Emails
I have used cfmail for quite some time, but I had a quick qu
Defnitely.. u can do anything you want~!.
BTW.. Why dont you take a minute or two and try this...! Have you tried any
code? Got any errors?
Joe
On Mon, 9 Dec 2002 09:58:58 -0600 "Clark, Aimee" <[EMAIL PROTECTED]>
wrote:
> I have used cfmail for quite some time, but I
> had a quick question. Is
I don't think you need the CFoutputs since you're within the cfmail tag.
The ## should suffice.
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 12/9
I have used cfmail for quite some time, but I had a quick question. Is it
possible to display parameters in the subject line? For instance if I wanted
the subject line to be:
Departure-IS Notification: Bugs Bunny, PHX, 12/14/02
Now, the first part after notification is just something that I type,
I suspect one one-millionth of a second ( or is that of a millisecond ) will
matter much on an output of 5 rows.
> Confuses the crap out of people, but saves .001 millisecond, that why
> you shouldn't use it.
> WG
>> -Original Message-
>> From: Cutter (CF_Talk) [mailto:[EMAIL PROTEC
> I should let Isaac explain, since he did all the hard work, but I'll try.
Thanks Jerry, :)
I don't think I could have explained it better myself. :)
> The first 2 hash marks (##) output the hash symbol (The first # escapes
> the second #, which results in a single # being output)
> The next t
ginal Message-
From: webguy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 9:53 AM
To: CF-Talk
Subject: RE: Alternating Row Colours & Number Listing in CFOutput
Andy said:
>Here is the code that I use combined with a Style Sheet:
>
Why on earth ? Here is that l
: [EMAIL PROTECTED]
Subject: RE: Alternating Row Colours & Number Listing in CFOutput
Because the first row is a header row and I did this to align the colors
correctly. I should have just have switched labels. Duh.
Thanks.
-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]]
Colours & Number Listing in CFOutput
Andy said:
>Here is the code that I use combined with a Style Sheet:
>
Why on earth ? Here is that logic in English
if (the number of the currentrow plus one) divided by 2 is divisible by two
with no remainder
you can just do
if ( the cur
Andy said:
>Here is the code that I use combined with a Style Sheet:
>
Why on earth ? Here is that logic in English
if (the number of the currentrow plus one) divided by 2 is divisible by two
with no remainder
you can just do
if ( the currentrow is divisible by two with no remainder )
, 2002 10:39 AM
To: CF-Talk
Subject: Alternating Row Colours & Number Listing in CFOutput
Hi
I am using the following script to display the latest 5 records from the
database table, and alternate the colour of each row, from white to grey.
This works, but how to I add a number listing with
is passed as an argument
to IIf or Evaluate."
- Original Message -
From: charlie griefer
To: CF-Talk
Sent: Wednesday, November 27, 2002 11:23 AM
Subject: Re: Alternating Row Colours & Number Listing in CFOutput
Cutter (CF_Talk) writes:
> Could you please e
I should let Isaac explain, since he did all the hard work, but I'll try.
The first 2 hash marks (##) output the hash symbol (The first # escapes the second #,
which results in a single # being output)
The next two hash marks surround a Cold Fusion function, iif()
The iif() function is the "imm
Confuses the crap out of people, but saves .001 millisecond, that why
you shouldn't use it.
WG
> -Original Message-
> From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]
>
> Could you please explain what the following statement does?
>
> "###iif(currentrow mod 2, DE('DFDFDF'), DE('FFF
Cutter (CF_Talk) writes:
> Could you please explain what the following statement does?
>
> "###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"
actually, i'd appreciate an explanation as well. I understand the
IIF()...but i never really understood DE()...what exactly it does or why it
ma
Could you please explain what the following statement does?
"###iif(currentrow mod 2, DE('DFDFDF'), DE('FF'))#"
Cutter
S. Isaac Dealey wrote:
>
>
>
>
> valign="middle">#currentrow#.
>
> #linktitle#
>
>
>
>
>Try this -- less code. :)
>
>s. isaac dea
#currentrow#.
#linktitle#
Try this -- less code. :)
s. isaac dealey954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
certified advanced coldfusion 5 developer
h
mber Listing in CFOutput
Hi
I am using the following script to display the latest 5 records from the
database table, and alternate the colour of each row, from white to grey.
This works, but how to I add a number listing with each record so the latest
record would have a number 1. next to it the se
you can use that #currentRow# variable that you're already using to
determine alternating rows...
Ian Vaughan writes:
> Hi
>
> I am using the following script to display the latest 5 records from the
> database table, and alternate the colour of each row, from white to grey.
>
> This wo
color a #foo.currentrow# ) #foo.recordname#
color b #foo.currentrow# ) #foo.recordname#
wg
> -Original Message-
> From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> Sent: 27 November 2002 16:39
> To: CF-Talk
> Subject: Alternating Row Colours & Number Listing i
- Original Message -
From: "Ian Vaughan" <[EMAIL PROTECTED]>
> This works, but how to I add a number listing with each record so the
latest
> record would have a number 1. next to it the seconf record would have
number
> 2 then number 3 etc.
---
Try using the curren
Hi
I am using the following script to display the latest 5 records from the
database table, and alternate the colour of each row, from white to grey.
This works, but how to I add a number listing with each record so the latest
record would have a number 1. next to it the seconf record would have
Wednesday, October 30, 2002 11:06 AM
> Subject: Attribute set validation error in tag CFOUTPUT
>> Here's a unique one:
>>
>> CF 5, Win2K Server
>>
>> This code:
>>
>> -
>>
>>
>> Change Bond Order for
>> #cl
> I think you've nested some tags, Isaac me boyo. That's not the
> error message I recall seeing exactly, but is very similar. I know that
> when I did it, it asked for a GROUP attribute, just like your error
> message.
You'd think... But it was fine just moments b
onbow Software
: -Original Message-
: From: S. Isaac Dealey [mailto:info@;turnkey.to]
: Sent: Wednesday, October 30, 2002 12:06 PM
: To: CF-Talk
: Subject: Attribute set validation error in tag CFOUTPUT
:
:
: Here's a unique one:
:
: CF 5, Win2K Server
:
: This code:
:
: -
:
:
> Anybody have any ideas why the server would just freak out suddenly like
> this? I tried commenting out the client variable on the off-chance it
might
> produce a change and it didn't seem to have any affect.
>
That error is usually indicitive of your CFOUTPUT being nest
>
Sent: Wednesday, October 30, 2002 11:06 AM
Subject: Attribute set validation error in tag CFOUTPUT
> Here's a unique one:
>
> CF 5, Win2K Server
>
> This code:
>
> -
>
>
> Change Bond Order for #client
Here's a unique one:
CF 5, Win2K Server
This code:
-
Change Bond Order for #client.ssmembername#
-
Produces this error:
-
Attribute set validation error in tag CFOUTPUT
The tag has an invalid attribute combination: the
Dowdell, Jason G wrote:
> Here's a bit of a challenge. I have a single table storing category
> information similar to any search engine. The table structure looks
> like this
> IDNameParentIDLevel
> 1 Computers 0 1
> 2 Laptop 1
Even if you can, I suspect it's not a very efficient method.
> Can you put maxrows="3" in the innermost CFOUTPUT?
>> -Original Message-
>> From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, October 15, 2002 3:15 PM
>> To: CF
me,
child.parentid, child.id, child.name
ORDER BY parent.name, child.name
Then you should be able to use your cfoutput group on id and sub-cfoutput
group on childid and come up with the 3 sub's you want...
hth
S. Isaac Dealey
Certifie
That's the piece I'm working on now.
It won't allow you to do that since you must
specify a query in order to specify maxrows.
~Jason
-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:17 PM
To: CF-Talk
Subject: RE: group
lto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:15 PM
To: CF-Talk
Subject: RE: group by in cfoutput
It does a portion of what I want. I need to restrict
the output of the group by to a max of 3 records per
parent category.
~jason
-Original Message-
From: Sam Farmer [mailto:[EMAIL
Can you put maxrows="3" in the innermost CFOUTPUT?
> -Original Message-
> From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 3:15 PM
> To: CF-Talk
> Subject: RE: group by in cfoutput
>
>
> It does a portion of what
It does a portion of what I want. I need to restrict
the output of the group by to a max of 3 records per
parent category.
~jason
-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 3:11 PM
To: CF-Talk
Subject: Re: group by in cfoutput
look
look at the group attribute of cfoutput.
Should do what you want.
HTH,
Sam
- Original Message -
From: "Dowdell, Jason G" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 2:30 PM
Subject: group by in cfoutput
Hi all,
Here's a bit of a challenge. I have a single table storing category
information similar to any search engine. The table structure looks
like this
ID NameParentIDLevel
1 Computers 0 1
2 Laptop 1 2
3 De
: embedding cfmail in a cfoutput -- thx
>This is because the tag uses the mechanism internally (
>this is why it has the query="" atrribute and I think a group=""
That helps me explain why cfmail requires grouping if nested within
cfoutput. Basically because cfmail *is*
>This is because the tag uses the mechanism internally (
>this is why it has the query="" atrribute and I think a group=""
That helps me explain why cfmail requires grouping if nested within
cfoutput. Basically because cfmail *is* a cfoutput (of sorts) and nest
ying about controlling the order of output. Lets
take a diary application as an example. We might have a table called
appointments, which will store each appointment as an individual lineitem,
with a primary key. Now there may be several appointments on a single day
(date field).
If we did a simple c
lto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 01, 2002 9:57 AM
> To: CF-Talk
> Subject: RE: embedding cfmail in a cfoutput
> Do a group on the user id. This way your grouping is done on individual
> unique values, hence cancelling out the grouping.
> Hope this makes sense,
TED]]
Sent: Tuesday, October 01, 2002 9:57 AM
To: CF-Talk
Subject: RE: embedding cfmail in a cfoutput
Do a group on the user id. This way your grouping is done on individual
unique values, hence cancelling out the grouping.
Hope this makes sense,
Dave
-Original Message-
From: Gilber
a cfoutput
I must be missing something very simple. I'm trying to embed a cfmail in a
cfoutput tag and am getting the following error msg.
// ERROR MSG
A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP=
attribute. This is not allowed. Nesting these tags implies tha
I must be missing something very simple. I'm trying to embed a cfmail in a
cfoutput tag and am getting the following error msg.
// ERROR MSG
A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP=
attribute. This is not allowed. Nesting these tags implies that you want t
of the CF form objects not geared towards validation,
>but it may be worthwhile to look at another solution. Something about
>using CFFORM inside of CFOUTPUT just gave us fits.
>
>If you're interested I'll send you the validation routines and tag that
>we wrote to get around c
,
but it may be worthwhile to look at another solution. Something about
using CFFORM inside of CFOUTPUT just gave us fits.
If you're interested I'll send you the validation routines and tag that
we wrote to get around cfform.
Joshua Miller
Web Development :: Programming
Eagle Web Develo
OK, this is so strange I almost don't want to write it.
This code doesn't work. The innermost cfoutput is not working as
expected. It is only showing the first Product. There are several
Products in each Category. If I change cfform to form, it works as
expected. I double check
it DOES work if you use array
notation as above.
-Andy
> -Original Message-
> From: William H. Bowen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 23, 2002 2:30 PM
> To: CF-Talk
> Subject: Maximum value of column in cfoutput
>
>
> Hello all,
>
> I have a
6 Cell
425.739.3690 FAX
- Original Message -
From: "Dan Haley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 12:05 PM
Subject: RE: Maximum value of column in cfoutput
> You can do it in CF after the query is back ...
&
dFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Dan Haley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 12:15 PM
Subject: RE: Maximum value of column in cfoutput
&g
e: Maximum value of column in cfoutput
>
>
>and if you're not using CF 5...
>
>
>
>Then do some list manipulation to get the MAX item in the list
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>El
We are still on 4.5 ... why won't valuelist work in CF5?
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:08 PM
To: CF-Talk
Subject: Re: Maximum value of column in cfoutput
and if you're not using CF 5...
Then do
You can do it in CF after the query is back ...
Dan
-Original Message-
From: William H. Bowen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:59 AM
To: CF-Talk
Subject: Re: Maximum value of column in cfoutput
Unfortunately I don't need the data in that order, I just
: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 11:59 AM
Subject: Re: Maximum value of column in cfoutput
> Unfortunately I don't need the data in that order, I just need the largest
> value of lvl so that I can use that as the colspan value at the top row of
>
quot; <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 11:59 AM
Subject: Re: Maximum value of column in cfoutput
> Unfortunately I don't need the data in that order, I just need the largest
> value of lvl so that I can use that as the colspan value at the top row of
> my table.
>
neighborhood Webmaster"
[EMAIL PROTECTED]
http://www.esca.com/
425.739.3629 Voice
425.466.7016 Cell
425.739.3690 FAX
- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 11:52 AM
OTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 11:29 AM
Subject: Maximum value of column in cfoutput
> Hello all,
>
> I have a column [ lvl ] being returned in a query that is a Count [
> count(child.startbranch) AS lvl ]of another column. I ne
cfoutput?
Desired result:
A table that builds itself dynamically so the end result will look like this
td colspan=*max(lvl)* - lvl (here it'll be 0)> 0 level header /td/tr
td> ,/td td colspan=*max(lvl)* - lvl (here it'll be 1)> 1 level subhead
/td/tr
etc.
so far the data I n
You should be able to do a simple group on the date:
SELECT
Format(YourDate,'') AS GroupedDate
GROUP BY
GroupedDate
http://cfhub.com/forum//index.cfm?FuseAction=Thread&TopicID=2399
> Hi,
>
> What is the best way to group by months for a query that contains full
(day,
> month, year) dat
PROTECTED]]
Sent: Monday, 15 July 2002 10:26 AM
To: CF-Talk
Subject: RE: cfoutput and grouping
What DB are you using?
Tim
-Original Message-
From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 8:49 PM
To: CF-Talk
Subject: cfoutput and grouping
Hi
If you can'rt change the query, I would do exactly what you are
thinking, q of q with CreateDate(Year(startDate), Month(startDate), 1)
> -Original Message-
> From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 15 July 2002 12:49 p.m.
> To: CF-Talk
&g
What DB are you using?
Tim
-Original Message-
From: Whiterod, David (PLNSA) [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 8:49 PM
To: CF-Talk
Subject: cfoutput and grouping
Hi,
What is the best way to group by months for a query that contains full (day,
month, year) dates
501 - 600 of 808 matches
Mail list logo