Yeah. After I read your other response, I realized that I need a nap.
:-) I can tell, because I start spouting nonsense.
--Ben
Deanna Schneider wrote:
Nope, you don't. In fact, it'll throw an error if you do that, I think. You
can group by another column in the inner cfoutput, though
That works fantastically, thanks Deanna! :)
Saturday
On 27 Sep 2005, at 21:42, Deanna Schneider wrote:
You just need to build your own counter to close the div.
cfoutput query=myquery group=mygroup
cfset counter = 0
blah blah
div
cfoutput
title
cfset counter = counter + 1
cfif counter
Hi
In my CF Output how can I restrict for example the contents of #output#
from the database to the first 200 characters ?
TIA
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start
Assuming you're outputting a string called stringvar, You can use
left(stringvar, 200) if you dont care if a word is cut in half, but
if you want it to get only complete words up to a max of 200
characters, there's a cool UDF you can get from the library at
CFLIB.ORG (http://www.cflib.org)
Thanks for the UDF Mike - works just as I want it to.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: 24 August 2005 09:00
To: CF-Talk
Subject: Re: Using CF to restrict characters displayed in CFOutput
Assuming you're outputting a string called stringvar, You can
Hi,
Anyone know if there's a way to get the 'currentrow' within a cfoutput
grouping? In other words, if I have 5 groups I'm cfoutputting, I want to be
able to access the row # within each group. I know I can do this by setting a
counter and incrementing within the 'inside' cfoutput tag
You got it; you have to use a manually managed counter variable.
cheers,
barneyb
On 7/28/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
Anyone know if there's a way to get the 'currentrow' within a cfoutput
grouping? In other words, if I have 5 groups I'm cfoutputting, I want
You will need to build your own. CF is not counting the number of times a
group element changes. Conceptually all cfoutput group=column ... is doing
is storing the first value of column, then each iteration through the loop it
checks to see if the value of column has changed. If it his
Subject: cfoutput grouping - current row
Hi,
Anyone know if there's a way to get the 'currentrow' within a cfoutput
grouping? In other words, if I have 5 groups I'm cfoutputting, I want to be
able to access the row # within each group. I know I can do this by setting
a counter and incrementing
Anyone know if there's a way to get the 'currentrow'
within a cfoutput grouping? In other words, if I have 5
groups I'm cfoutputting, I want to be able to access the
row # within each group. I know I can do this by setting
a counter and incrementing within the 'inside' cfoutput
tag
I think the counter method is the one that everyone uses.
On 7/28/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
Anyone know if there's a way to get the 'currentrow' within a cfoutput
grouping? In other words, if I have 5 groups I'm cfoutputting, I want to be
able to access the row
The counter variable is how I would do it.
On 7/28/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
Anyone know if there's a way to get the 'currentrow' within a cfoutput
grouping? In other words, if I have 5 groups I'm cfoutputting, I want to be
able to access the row # within each
of volunteer categories
Volunteer inking table - links member id to one or more volunteer
categories
Club linking table - links member id to one or more volunteer categories
Grouping by clubs OR Grouping by volunteer categories is not problem
using the group=club for example within the cfoutput tag
the cfoutput tag. The
challenge comes in when I the want the volunteer category to also be
displayed for each member..
I've tried this, but it outputs the volunteer and club categories twice
for each member:
table border=1
cfoutput query=get_members group=member_id
tr
What is the purpose of all the HTML tags?
Thanks
Kevin
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with
Subject: Purpose of HTML tags at beginning of cfoutput in
classic.cfm debug page
What is the purpose of all the HTML tags?
I believe it's to catch the possibility that an error may have left
unclosed tags laying around that might interfere with the display of the
debug information
All the closing tags, you mean?
That's so that the debugging output will theoretically be a top-level
content element, rather than nested inside some of your [potentially
broken] markup. For example, in certain browsers, if you make an
invalid table in a certain way, following content will be
to close off any unclosed tags that might render the debugging content
invisible.
On 7/19/05, sonicDivx [EMAIL PROTECTED] wrote:
What is the purpose of all the HTML tags?
Thanks
Kevin
~|
Logware (www.logware.us): a
Thats what I thought. Yeah trying to fix the issue with the debug output
appearing under my DIVS. tried a div with a style of clear:both at end but
that didn't help.
Frame sites make debugging so much fun.
Kevin
~|
Hi ppl i have to make some changes in a CFX tag , and i need to cfoutput
something inside the CFX , anyone knows what method i can use?.. or betten than
that a url with fully documentation about cfx.jar
greetings.
~|
Find
to and from your CFX.
Regards,
Dan.
David Manriquez wrote:
Hi ppl i have to make some changes in a CFX tag , and i need to cfoutput
something inside the CFX , anyone knows what method i can use?.. or betten
than that a url with fully documentation about cfx.jar
greetings
as Static..
:-S
Thanks in advance.
David Manriquez
[EMAIL PROTECTED]
(+56-2) 43 00 155
-Mensaje original-
De: Daniel Mackey [mailto:[EMAIL PROTECTED]
Enviado el: Lunes, 20 de Junio de 2005 9:31
Para: CF-Talk
Asunto: Re: how to cfoutput from com.allaire.cfx. methods
Hi
/6.1/htmldocs/cfxrea25.htm
HTH
Kola
-Original Message-
From: David Manriquez [mailto:[EMAIL PROTECTED]
Sent: 20 June 2005 13:28
To: CF-Talk
Subject: how to cfoutput from com.allaire.cfx. methods
Hi ppl i have to make some changes in a CFX tag , and i need to
cfoutput something
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
David Manriquez wrote:
I have a method
public String[] getColumns(HSSFSheet hssfsheet, boolean flag)
and inside this.
Query query = Response.addQuery(output,mycolumns);
And the complier says that addquery isn't static, but I didn't
why would exactly the same file work under server but not locally? I saved a
simple word doc as xml type and pasted to a cfm. The xml worked file with
cfdump and cfoutput, but when I add cfcontent to open it with msword, the word
doc showed error. Everything worked fine under server, but when i
why would exactly the same file work under server but not
locally? I saved a simple word doc as xml type and pasted to
a cfm. The xml worked file with cfdump and cfoutput, but when
I add cfcontent to open it with msword, the word doc showed
error. Everything worked fine under server
why would exactly the same file work under server but not
locally? I saved a simple word doc as xml type and pasted to
a cfm. The xml worked file with cfdump and cfoutput, but when
I add cfcontent to open it with msword, the word doc showed
error. Everything worked fine under server
Are there any other possible reason? I turned off debugging
but the same problem remains.
Yes, there are all sorts of possible reasons. Did you examine the generated
XML in a text editor, instead of in Word? How did it differ when generated
from the one server vs the other server?
Dave Watts,
both server used the same xml code, the code generated by Word when i saved the
word prototype as *.xml. I didn't make any changes to the xml code, the only
thing I added is a cfcontent tag at the bottom. When I load the saved cfm file
on production server, it pops up the download wizard and
So, download and save the file, and open it with a text editor -
what's there? It sounds like debugging is on on the dev server, to me.
On 6/14/05, Ida Chen [EMAIL PROTECTED] wrote:
both server used the same xml code, the code generated by Word when i saved
the word prototype as *.xml. I
both server used the same xml code, the code generated by
Word when i saved the word prototype as *.xml. I didn't make
any changes to the xml code, the only thing I added is a
cfcontent tag at the bottom. When I load the saved cfm file
on production server, it pops up the download wizard
both server used the same xml code, the code generated by
You will need to examine the document directly, with a regular text editor,
rather than opening it directly within Word. There are a variety of ways you
can go about this. If your browser prompts you to open or save the document,
save
The doc downloaded from local server has a few line spaces at
the beginning. Now I know that this is why it keeps showing
the error message. Why does it create these line spaces?
Presumably, because you have some server-side code that is being executed,
and once that code is executed the
that couldn't be seen in notepad with a hex editor...
Cheers,
Kevin
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 1:56 PM
To: CF-Talk
Subject: RE: can dump or cfoutput, but can not open in application-xml?
The doc downloaded from local server
Here is an interesting one. This works fine:
CFFORM action=https://www.codagenomics.net/orders; method=post
name=frmMain
However, this:
cfoutput
CFFORM
action=https://www.codagenomics.net/orders/neworder_main_confirm.cfm;
method=post name=frmMain
/cfoutput
Generates the following error
Here is an interesting one. This works fine:
CFFORM action=https://www.codagenomics.net/orders; method=post
name=frmMain
However, this:
cfoutput
CFFORM
action=https://www.codagenomics.net/orders/neworder_main_confirm.cfm;
method=post name=frmMain
/cfoutput
Generates
Hi,
Can anyone help me, I am using grouped cfoutputs to display category and
product information,which i can do no problem in one column. I have also
somewhere else in the site used 3 column output using the cfif tag.
How do I comine the two, i.e I want;
Column 1Column 2
Would something like this work?
table
tr
cfoutput query=myQuery group=columnid
td valign=top
h3#columnName#/h3
cfoutput group=categoryId
b#categoryname#/b
ul
Cfoutput group=productID
I went with;
table width=525 cellpadding=0 cellspacing=0
cfoutput query=getsrc group=CAT_ID
cfif Getsrc.CAT_ID mod 3 eq 1
tr
/cfif
td width=175 valign=top
class=SiteStylestronga href=###CAT_DESC#/a/strongBr
You may also find something at www.webtricks.com for multi-column
output.
-Original Message-
From: Mark Stephenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 17, 2005 9:08 AM
To: CF-Talk
Subject: RE: Grouped Multicolum cfoutput
I went with;
table width=525 cellpadding=0 cellspacing
:
Uwe if you want to do this you would have to use New Atlanta's Blue
Dragon. They have a new function (version 6.2) called Render. It
should perform exactly as you are expecting
cfoutput#bob#/cfoutput.
Adam H
~|
Logware
Hi list,
I have a db-field
let us say string_field.
Let us assume that this
field contains the followingexpression inside
the db-field:
Hello, my name is cfoutput#form.name#/cfoutput...
When I output that with:
cfoutput#a#/cfoutput
appears
Hello, my name is #form.name#
So it doesn't
-
-Original Message-
From: Uwe Degenhardt [mailto:[EMAIL PROTECTED]
Sent: woensdag 27 april 2005 12:47
To: CF-Talk
Subject: cfoutput inside cfoutput with a string coming from a db
Hi list,
I have a db-field
let us say string_field.
Let us assume that this
field contains the followingexpression inside
If you remove the cfoutput section from the DB field you can do something like
cfoutput#Evaluate(DE(a))#/cfoutput
The easier task would be to use a key and search and replace the
string, we run a small newsletter app that allows users to embed
variables in fields by using known keyword
string_field.
Let us assume that this
field contains the followingexpression inside
the db-field:
Hello, my name is cfoutput#form.name#/cfoutput...
When I output that with:
cfoutput#a#/cfoutput
appears
Hello, my name is #form.name#
So it doesn't work out as expected.
How can
Uwe if you want to do this you would have to use New Atlanta's Blue
Dragon. They have a new function (version 6.2) called Render. It
should perform exactly as you are expecting
cfoutput#bob#/cfoutput.
Adam H
On 4/27/05, Micha Schopman [EMAIL PROTECTED] wrote:
You should store the contents
you dont need to use outputs within the cfmail tag just #whatever#
From: Richard Crawford [EMAIL PROTECTED]
Sent: Friday, April 22, 2005 2:41 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: cfoutput error
It appears that I'm having problems
cfoutput's group attribute, so I just
manually break out and track the groups. Now that this app is in production, I
am finding a performance hit on very large record sets and I am again exploring
cfoutput's grouping as an option. Does anyone have any experience using
cfoutput to dynamically
:21 AM
To: CF-Talk
Subject: Dynamic cfoutput groups
Morning everyone.
I currently have a reporting app that allows output to be grouped
dynamically based on user preference. The user can select an unlimited
number of values to group on and the groups are nested accordingly. I
wasn't able
Thanks for the response.
For the application requirements, this should remain a web-based CF reporting
app. I would just like to use cfoutput to the do the display grouping rather
than handling it manually. Any thoughts?
Thanks,
Chris
[EMAIL PROTECTED] 04/14/05 09:23AM
It sounds like
. If you post the query you may get
some very useful tips on how to solve the performance problems at the
root...
-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 8:35 AM
To: CF-Talk
Subject: RE: Dynamic cfoutput groups
Thanks for the response
current goal). I was hoping that by using the cfoutput
grouping, I would gain a small performance boost over manual grouping. This is
unlikely, but I figured I'd give it a shot anyway.
Thanks again,
Chris
[EMAIL PROTECTED] 04/14/05 10:35AM
You can use CF with OLAP. Read http://sys-con.com
I choose based on my need.
If the page already has cfoutput blocks, then I use cfloop, unless I need to
group output and then I use cfoutput. On a new page, I typically choose
cfloop...
- Calvin
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 20
Can anyone tell me if there is a performance difference in the
following 2 bits of code? I know back in 4.5 cfloop was worse than
cfoutput but now? Any web references to tests on these things welcome!
This is Forta on the subject. It's pre 6.1/7, but I'll bet it's the same.
http://www.sys
Can anyone tell me if there is a performance difference in the
following 2 bits of code? I know back in 4.5 cfloop was worse than
cfoutput but now? Any web references to tests on these things welcome!
Thanks.
Duncan
// using cfloop for the query output //
cfquery name=getProducts
select
all elements of the logic across the site (since you can make the UDF
available everywhere).
Just some more thoughts...
- Calvin
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 5:46 PM
To: CF-Talk
Subject: Re: Few cfoutput Vs Many
I am sifting through some inherited code and it is littered with
CFoutputs everywhere...
For example:
select name=cfoutput #sel_name#/cfotuput
option value=cfoutput#sel_value#/cfoutput
cfoutput#sel_text#/cfoutput
/option
/select
I figured it was done b/c somone jsut didn't know any better
i see cfoutput as being similar to starting a car, and /cfoutput
as similar to shutting it off.
I wouldn't stop/start the car at every corner (or every
streetlight/stopsign) that I came to.
Altho...I also wouldn't leave it running overnight just so I wouldn't
have to start it in the morning
that out over a few hundred files
and millions of requests per day and your server would see the difference.
With CFMX it's not an issue, but some people, myself, still minimize the
text within CFOUTPUT by habit. CF5 also had some slight performance gains
if you converted many ( 3-4) CFSET
It is because CFMX compiles to Java bytecode, and executes that. The
result bytecode is no different if you use cfscript or cfset :)
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
But I find cfscript easier to read and more flexible in some ways, so
I'm more likely to use it for several successive sets, or for some
loops.
I never really *was* after gains in performance... cfscript just
seemed like a nice way to write code, and overall less typing.
J
On Thu, 10 Feb 2005
Same here, I use it for sets and if/elses a lot, sometimes looping and
a switch/case here and there. All because I find it easier to read
than anything else.
On Thu, 10 Feb 2005 09:50:10 -0600, Jared Rypka-Hauer - CMG, LLC
[EMAIL PROTECTED] wrote:
But I find cfscript easier to read and more
Yeah I've commented about this other places...cfscript is just mor
comfortable for me...besides if I have a block of code dealing with
structures why would i want to constantly use cfset just to call
structinsert().
Adam H
On Thu, 10 Feb 2005 10:00:07 -0600, Aaron Rouse [EMAIL PROTECTED] wrote:
] wrote:
i see cfoutput as being similar to starting a car, and /cfoutput
as similar to shutting it off.
I wouldn't stop/start the car at every corner (or every
streetlight/stopsign) that I came to.
Altho...I also wouldn't leave it running overnight just so I wouldn't
have to start
I hate it when I see this, makes it hard to read and hard to maintain.
Technically cfoutput is a tag, and having CF go in/out of a ton of tags is
slower then going in/out of only a few. Although, granted we are talking
hundreds of a ms, so we'll never notice it. In older versions cf had to
parse
, February 10, 2005 11:57 AM
To: CF-Talk
Subject: Re: Few cfoutput Vs Many cfoutput
Yeah I've commented about this other places...cfscript is just mor
comfortable for me...besides if I have a block of code dealing with
structures why would i want to constantly use cfset just to call
structinsert().
Adam
Why do you consider top and bottom cfoutputs a 'silly' thing?
- Calvin
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 11:59 AM
To: CF-Talk
Subject: Re: Few cfoutput Vs Many cfoutput
I agree top and bottum cf outputs could be as equally
well, for one...you now have to worry about doubling up on # signs
everywhere (yes, yes, i know..i'm referring to # in hex color
declarations but the presentation layer should be seperate anyway
:P)...
i would also think (assume?) that the larger the block of text between
cfoutput tags, the more
The main issue, IMO, is how many colors, or in-document anchors, are in
the code?
Do you want to have to use ##ff or #ff? If you wrap all with
CFOUTPUT, you will need to double-up on the #s.
I agree that it's a matter of taste.
-Original Message-
From: Mike Nimer [mailto
files tend to be
fairly small in the first place...
- Calvin
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 12:44 PM
To: CF-Talk
Subject: Re: Few cfoutput Vs Many cfoutput
well, for one...you now have to worry about doubling up
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
The main issue, IMO, is how many colors, or in-document
anchors, are in the code?
Do you want to have to use ##ff or #ff? If you wrap
all with CFOUTPUT, you will need to double-up on the #s.
I agree that it's a matter of taste
Charlie said:
well, for one...you now have to worry about doubling up on # signs
everywhere (yes, yes, i know..i'm referring to # in hex color
declarations but the presentation layer should be seperate anyway
:P)...
i would also think (assume?) that the larger the block of text between
cfoutput
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 12:44 PM
To: CF-Talk
Subject: Re: Few cfoutput Vs Many cfoutput
well, for one...you now have to worry about doubling up on # signs
everywhere (yes, yes, i know..i'm referring
Well, sure. In the ideal world. ;-)
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 12:02 PM
To: CF-Talk
Subject: RE: Few cfoutput Vs Many cfoutput
From: Dawson, Michael [mailto:[EMAIL PROTECTED] The main issue,
IMO, is how
Dude,
color=#FF is so last century!
- Calvin
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 1:13 PM
To: CF-Talk
Subject: RE: Few cfoutput Vs Many cfoutput
Well, sure. In the ideal world. ;-)
-Original Message-
From
-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 12:30 PM
To: CF-Talk
Subject: RE: Few cfoutput Vs Many cfoutput
Dude,
color=#FF is so last century!
- Calvin
~|
Find out how
One co-worked claimed he did it for performance he thought it would
parse quiker, in CF5...I disagree.
I desagree also, the difference is completely marginal.
The only difference it makes is that inside CFOUTPUT, CF has to look for chars
#, and ' while outside it only has to look
I wouldn't stop/start the car at every corner (or every
streetlight/stopsign) that I came to.
Bold comparison: parsing does not pollute! ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any
the more the cf engine has to parse.
Not significantly: it still has to parse everything outside CFOUTPUT,
just to find any other CF tag,
including CFOUTPUT; even HTML tags must be parsed, in order to ignore
what's inside strings.
The ONLY difference is that CF does not look at #s any more
Spread that out over a few hundred files
and millions of requests per day and your server would see the difference.
Really? One second?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to
Take this block:
..alt0{background-color: #fff;}
..alt0{background-color: #ffc;}
class=alt#currentRow MOD 2#
And this block:
bgcolor=cfif currentRow MOD 2##ffcfelse##cc/cfif
Once you use it twice, the former is less typing overall(119 vs 129
chars), and that savings only increases per
Note that even if CFOUTPUT is horribly difficult to parse (which it
isn't), it will only have effect on the first request to a given
template, because of CF's compiler. Once it's compiled, then the
number of tags present is utterly irrelevant, and only the number of
dynamic expressions matters
Feb 2005 14:58:06 -0800, Barney Boisvert [EMAIL PROTECTED] wrote:
Note that even if CFOUTPUT is horribly difficult to parse (which it
isn't), it will only have effect on the first request to a given
template, because of CF's compiler. Once it's compiled, then the
number of tags present is utterly
and millions of requests per day and your server
would see the difference.
Really? One second?
Well, I'm not going to get into a drawn out discussion on it, but I can say
that taking normal code and applying a number of optimization techniques
on it (of which the cfoutput issue was one
I use a cfquery to retrieve a small list.
I then want to display the first value returned as the default, and populate
all of the items into a list box.
The list box populates ok, but when I use cfoutout query=, I get all values
displayed.
How can I capture the first value into a variable, so
You can use array notation to specify the record you want:
#myQuery.myColumn[1]#
Cheers
Bert
On Thu, 3 Feb 2005 11:34:12 -0800, Rodger [EMAIL PROTECTED] wrote:
I use a cfquery to retrieve a small list.
I then want to display the first value returned as the default, and populate
all of the
cfoutput#queryname.fieldname#/cfoutput will do it.
On Thu, 3 Feb 2005 11:34:12 -0800, Rodger [EMAIL PROTECTED] wrote:
I use a cfquery to retrieve a small list.
I then want to display the first value returned as the default, and populate
all of the items into a list box.
The list box
sorry, didn't read the part about setting it into a var...
cfset myFirstRecord = myQuery.columnName[1] / should do it :)
On Thu, 3 Feb 2005 14:45:08 -0500, Charlie Griefer
[EMAIL PROTECTED] wrote:
cfoutput#queryname.fieldname#/cfoutput will do it.
On Thu, 3 Feb 2005 11:34:12 -0800, Rodger
I hope this is more clear...
The solution you gave for Displaying the first value from cfoutput was
great, thanks.
Now I realise that I need the variable to hold the default value from the
database on the first pass, but when the user selects a value from the list
box I want that to become
From: Rodger [mailto:[EMAIL PROTECTED]
I hope this is more clear...
The solution you gave for Displaying the first value from
Who gave the original solution?
~|
Logware (www.logware.us): a new and convenient web-based
Sorry, I guess I am trying not to be too verbose. Let me try again.
The solution you gave for Displaying the first value from cfoutput was
great, thanks.
Now I realise that I need the variable to hold the default value from the
database on the first pass, but when the user selects a value from
-0800, Rodger [EMAIL PROTECTED] wrote:
Sorry, I guess I am trying not to be too verbose. Let me try again.
The solution you gave for Displaying the first value from cfoutput was
great, thanks.
Now I realise that I need the variable to hold the default value from the
database on the first pass
: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: 05 January 2005 01:46
To: CF-Talk
Subject: Re: SQL group by instead of cfoutput group?
Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically
ensure that you don't have any duplicate rows in your result set. Oh,
and go check out CFQUERYPARAM
ON tasks.project_id = projects.project_id
JOIN people ON tasks.owner_id = people.person_id
JOIN importance ON tasks.importance_id =
importance.importance_id
/CFQUERY
But the trouble is, the CFOUTPUT I thought would work doesn't:
CFOUTPUT query=get_tasks
td#tasks.name#/td
JOIN importance ON tasks.importance_id =
importance.importance_id
/CFQUERY
But the trouble is, the CFOUTPUT I thought would work doesn't:
CFOUTPUT query=get_tasks
td#tasks.name#/td
td#projects.name#/td
td#tasks.deadline#/td
td#importance.importance#/td
tasks
JOIN projects ON tasks.project_id = projects.project_id
JOIN people ON tasks.owner_id = people.person_id
JOIN importance ON tasks.importance_id =
importance.importance_id
/CFQUERY
CFOUTPUT query=get_tasks
td#taskName#/td
td#projectname
ON tasks.project_id = projects.project_id
JOIN people ON tasks.owner_id = people.person_id
JOIN importance ON tasks.importance_id =
importance.importance_id
/CFQUERY
CFOUTPUT query=get_tasks
td#tasks_name#/td
td#projects_name#/td
td#deadline#/td
td
What is the sql you have now?
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 8:46 PM
To: CF-Talk
Subject: Re: SQL group by instead of cfoutput group?
Just add 'DISTINCT' after 'SELECT' and SQL Server will automatically
ensure that you
tiz amazing and i will leave it at that as im trying to be
good :) (i got coal in stockings this yr)
So Santa says to a kid you should be good, you don't want to get coal
in your stocking and the kid asks what's coal? and Santa says
well... it's kind of a rock that burns... and the kid says
lol!
actually it woulda been nice as i was in kentucky and the ice storm knocked out
power out for 3 days, so we huddled around the coal stove
-- Original Message --
From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
Date: Wed, 5
301 - 400 of 910 matches
Mail list logo