for the category to the query. How can I group this so
there'll be only distinct model numbers shown?
I made it work by using cfoutput group=prodmodelcode, but I was trying to
keep the burden on SQL Server. Also, I'm going to convert the cfquery to a
stored procedure, can I handle this with T-SQL
URL parameter for the category to the query. How can I group this so
there'll be only distinct model numbers shown?
I made it work by using cfoutput group=prodmodelcode, but I was trying to
keep the burden on SQL Server. Also, I'm going to convert the cfquery to a
stored procedure, can I
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 and use it. It'll save you lots of
headaches.
I tried DISTINCT and it still returns duplicate prodmodelcodes. How can I weed
discussed 101X
on this list.. so there goes 102 times.. :-)
--
Regards,
Pascal Peters wrote:
This has always been like this (and must have been discussed a 100x on
this list). When you have nested loops over queries (it doesn't matter
if you are using cfoutput or cfloop), coldfusion looses
This has always been like this (and must have been discussed a 100x on
this list). When you have nested loops over queries (it doesn't matter
if you are using cfoutput or cfloop), coldfusion looses the reference to
the first query when looping the second. This means that you can't drop
the prefix
Hi,
I'm getting this odd.. problem.. when doing..
cfouput query=QUERYONE group=SOMECOLUMN
cfloop query=QUERYTWO
cfif QUERYONE.XID eq QUERYTWO.YID
SOMETHING
/cfif
/cfloop
/cfoutput
in the loop QUERYONE.XID will keep the first row value
Here's an interesting one...
I have a text field in a database that contains numbers because of a need to
PRESERVE leading 0's
i.e.
0001234
0123
12300
Using a regular query, pulling the numbers OUT of the database DROPS the
leading 0's in the cfoutput. Almost like cold fusion is treating
] wrote:
Here's an interesting one...
I have a text field in a database that contains numbers because of a need to
PRESERVE leading 0's
i.e.
0001234
0123
12300
Using a regular query, pulling the numbers OUT of the database DROPS the
leading 0's in the cfoutput. Almost like cold fusion
: Preserve Leading 0's question in cfoutput.
You running them through a QofQ, by chance? Or doing any
arithmetic with them? Because CF shouldn't strip the zeros
unless it's converting them to numbers, and it shouldn't do
that unless it actually needs to.
cheers,
barneyb
On Fri, 3 Dec
maybe. Did you try this:
cfset textnum = myquery.textnumber /
On Fri, 3 Dec 2004 16:58:42 -0500, Jeff Waris [EMAIL PROTECTED] wrote:
Would a cfset giving the variable a more friendly name be considered
arithmatic and trim the 0's?
i.e.
cfset textnum = myquery.textnumber
Jeff
--
You could always use #numberformat(qdfResult.numberfield, 000)#
Martin Parry
http://www.beetrootstreet.co.uk
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 21:50
To: CF-Talk
Subject: Preserve Leading 0's question in cfoutput.
Here's
I tried varchar, nvarchar and char in MS SQL. The DB all shows the 0's. The
cfoutput removes the 0's. I even tried the SET like below as well. Still
trims the 0's... I'm pulling my hair out...
Jeff
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday
The numbers are not fixed length.
-Original Message-
From: Martin Parry [mailto:[EMAIL PROTECTED]
Sent: Friday, December 03, 2004 5:09 PM
To: CF-Talk
Subject: RE: Preserve Leading 0's question in cfoutput.
You could always use #numberformat(qdfResult.numberfield, 000
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 22:23
To: CF-Talk
Subject: RE: Preserve Leading 0's question in cfoutput.
The numbers are not fixed length.
-Original Message-
From: Martin Parry [mailto:[EMAIL PROTECTED]
Sent: Friday, December
In the query - try concatenating an x with the textnumber field so the
results set would contain x0012345,x00123 then in the cfoutput use
mid(qdfResult.textnumber, 2, 9)
I think SQL would look like.. SELECT 'x' textnumber as NewTextNumber
Martin.
-Original Message-
From: Jeff
:50 PM
To: CF-Talk
Subject: Preserve Leading 0's question in cfoutput.
Here's an interesting one...
I have a text field in a database that contains numbers because of a
need to PRESERVE leading 0's i.e.
0001234
0123
12300
Using a regular query, pulling the numbers OUT of the database DROPS
can do
isquery(application.queries.testquery()) and it returns yes, but when I do
cfoutput query=application.queries.testquery() or cfoutput
query=#application.queries.testquery()# it throws an error. I can set the
method to a local variable and then I'm able to reference the query, but it
would
try
cfset myQ = application.queries.testquery() /
cfoutput query=#myQ#
Doug
On Wed, 24 Nov 2004 13:20:40 -0400, Robert Everland III
[EMAIL PROTECTED] wrote:
I have a CFC that I have put all of my stored procedures into. I then input
the CFC into the application scope for use throughout my
yes, but when I do
cfoutput query=application.queries.testquery() or cfoutput
query=#application.queries.testquery()# it throws an error. I can set the
method to a local variable and then I'm able to reference the query, but it
would be nice to use the method without having to move
like this
cfdump var=#application.queries.testquery()# and it will dump the
query. I can do isquery(application.queries.testquery()) and it returns
yes, but when I do cfoutput query=application.queries.testquery() or
cfoutput query=#application.queries.testquery()# it throws an error. I
var=#application.queries.testquery()# and it will dump the query. I can do
isquery(application.queries.testquery()) and it returns yes, but when I do
cfoutput query=application.queries.testquery() or cfoutput
query=#application.queries.testquery()# it throws an error. I can set the
method
Well, now that i think about it, you would want to copy it to the
variable scope anyway. Otherwise, each iteration of the loop you'd be
executing the query again by calling the function every time.
that is:
cfloop query=application.queries.getQuery()
cfoutput#application.querys.getQuery().name
cfoutput
query=#application.queries.testquery()# it throws an error. I can
set the method to a local variable and then I'm able to reference the
query, but it would be nice to use the method without having to move
it to a local variable. Has anyone ran into this issue?
Yes, I have run
If you were looping over the query you wouldn't need to refer to the function.
Also if you did myquery().name, you would only be getting the first record
every time, you would just refer to name. I think it's just a limitation in
ColdFusion, looks like a lot of people are having this issue.
in some cases, you'll need to use something to specify the scope:
cfloop query=query1
cfloop query=query2
cfoutput#query1.name# != #query2.name#br/cfoutput
/cfloop
/cfloop
Now try that with the unstored results of a function call.
On Wed, 24 Nov 2004 14:10:13 -0400, Robert
scalefrom=0
scaleto=#qIssues.maxscale#
gridlines=10
chartWidth=1000
chartHeight=320
foregroundcolor=44
databackgroundcolor=FF
fontsize=12
cfoutput query=qIssues group=issuetype
cfif qIssues.issuetypeid eq
=#RealPrevStart#
RealNextStart=#RealNextStart#
MyMaxRows=#mymaxrows#
MyMaxPages=10
pagecount=#pagecount#
thispage=#thispage#
showpage=no
!--- begin results table ---
table width=100%
!--- reset counter for this page ---
cfset numrecord = 0
!--- one block per result ---
cfoutput query=research
author.So Pub 1-Auth1, Pub1-Auth2, Pub2-Auth3, Pub3-Auth4 = 4 rows for 3 records. My output uses grouped nested cfoutputs for display, essentially like this:
cfoutput query=research group=publication_title maxrows=10
#publication_title#
cfoutput
#author_name#
/cfoutput
/cfoutput
But the maxrows attribute
...which gives me multiple rows for publications with more
than one author.So Pub 1-Auth1, Pub1-Auth2, Pub2-Auth3,
Pub3-Auth4 = 4 rows for 3 records. My output uses grouped
nested cfoutputs for display, essentially like this:
cfoutput query=research group=publication_title
maxrows=10
I'm sure there are many ways to approach this.One way, remove the
maxrows attribute and create your own counter.
cfset mycount = 0 /
cfoutput query=research group=publication_title
cfset mycount = ycount + 1 /
#publication_title#
cfoutput
#author_name#
/cfoutput
cfif mycount IS 10
cfexit
/cfif
cfoutput query=research group=publication_title maxrows=10
#publication_title#
cfoutput
#author_name#
/cfoutput
/cfoutput
But the maxrows attribute goes by the query record count, rather than the
count of unique publication_titles. So instead of seeing 10 records per
page, I may get 6 or 9 or 7
Hello,
I was wondering if there was a easy way to run a quick query and have it display all of the results with out know in column names?
Example --
CFQUERY NAME=q_Info DATASOURCE=dbeta1
SELECT *
FROM DOCS
/CFQUERY
cfoutput query=q_Info startrow=1 maxrows=50
#q_Info.queryoutput#br
/CFQUERY
cfoutput query=q_Info startrow=1 maxrows=50
#q_Info.queryoutput#br --- This is what I need help with :-)
/cfoutput
Thanks,
- Charles
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
you could always use cfdump var=#q_info#
or you could loop through the q_info.columnlist variable.
-Original Message-
From: Charles Heizer [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 28, 2004 2:07 PM
To: CF-Talk
Subject: cfoutput and cfquery question ...
Hello,
I
Here you go ...
cfquery name='blah' ../
cfoutput query='blah'
cfloop list='#blah.columnlist#' index='col'
#col# = #evaluate(col)#
/cfloop
/cfoutput
- Joe
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
This was just what I was looking for ...
Thanks a bunch!
- Charles
Here you go ...
cfquery name='blah' ../
cfoutput query='blah'
cfloop list='#blah.columnlist#' index='col'
#col# = #evaluate(col)#
/cfloop
/cfoutput
- Joe
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe
I am trying to dump a query to a text file..
I tried using CFFILE but I get an error saying
Object type cannot be written to file. Error attempting to write non string/binary data to file.
The error occurred while processing an element with a general identifier of (CFFILE), occupying document
Error attempting to write non string/binary data to file. The problem
is exactly what it says. You can't dump a query to a file, you need to
convert it to a string.
[EMAIL PROTECTED] wrote:
I am trying to dump a query to a text file..
I tried using CFFILE but I get an error saying
Object
Can you show a little more of your code?
Phillip B.
[EMAIL PROTECTED] wrote:
I am trying to dump a query to a text file..
I tried using CFFILE but I get an error saying
Object type cannot be written to file. Error attempting to write non
string/binary data to file.
The error occurred
I gernerally use a cfsavecontent around a cfdump and write the resulting
string to the text file using cffile.
Tyler Clendenin
GSL Solutions
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 11:09 AM
To: CF-Talk
Subject: Writing cfoutput to a text file
I
you should loop through it within the confines of a cfsavecontent tag and
then take that variable that cfsavecontent creates, and dump that to the csv
file.
dumbed down example:
cfquery name=get
cfsavecontent variable=getResults
cfloop query=get
cfoutput
#stuff1#,#stuff2#
/cfoutput
/cfloop
You can't 'dump' it, but you can output it.Here's an example:
cfquery
name=Maker
datasource=test
SELECT
myfile.FIELD1,
myfile.FIELD2
FROM myfile
WHERE
0=0
ORDER BY
myfile.FIELD1 ASC
/cfquery
cfloop query=Maker
cfset variables.DestFile=foo_ Maker.FIELD1 .txt
cffile
This shows the html code for the CFDUMP, I cant get this to work.
-Original Message-
From: Tyler Clendenin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 10:37 AM
To: CF-Talk
Subject: RE: Writing cfoutput to a text file
I gernerally use a cfsavecontent around a cfdump and write
:(
- Original Message -
From: Tony Weeg [EMAIL PROTECTED]
Date: Tue, 22 Jun 2004 11:35:13 -0400
Subject: RE: Writing cfoutput to a text file
To: CF-Talk [EMAIL PROTECTED]
you should loop through it within the confines of a cfsavecontent tag and
then take that variable that cfsavecontent creates
Yes but I need to dump the whole query formatted just how the sql query formats it.
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 10:54 AM
To: CF-Talk
Subject: Re: Writing cfoutput to a text file
You can't 'dump' it, but you can output
so, loop through it, make each field, have a #queryName.column#, value in
the cfsavecontent.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 12:41 PM
To: CF-Talk
Subject: RE: Writing cfoutput to a text file
Yes but I need to dump
I got it..
cfsavecontent variable=ecount_file
cfloop query=fetchReferrals
cfoutput#record_data#/cfoutput
/cfloop
/cfsavecontent
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 11:50 AM
To: CF-Talk
Subject: RE: Writing cfoutput to a text file
so
[EMAIL PROTECTED] wrote:
Yes but I need to dump the whole query formatted just how the sql query
formats it.
This confuses me.The SQL query doesn't format the data at all, it just
returns the data in a query object.
- Rick
[Todays Threads]
[This Message]
[Subscription]
[Fast
line write each time to the file,
not nice at all, since its filesystem access for each row :(
anyway, VERY NICE for this, later!
tw
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 1:19 PM
To: CF-Talk
Subject: RE: Writing cfoutput
We all have customers, we all should know how to read between the lines. :-)
Rick Root wrote:
This confuses me.The SQL query doesn't format the data at all, it just
returns the data in a query object.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[EMAIL PROTECTED] wrote:
I am trying to dump a query to a text file..
I tried using CFFILE but I get an error saying
You could convert the query object to a WDDX packet using CFWDDX and
then write it out...
- rick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
Sure it does... it uses the rpad oracle function to format it
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 12:37 PM
To: CF-Talk
Subject: Re: Writing cfoutput to a text file
[EMAIL PROTECTED] wrote:
Yes but I need to dump the whole query
No I don't, it works fine, Thanks though.
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 12:36 PM
To: CF-Talk
Subject: Re: Writing cfoutput to a text file
[EMAIL PROTECTED] wrote:
I am trying to dump a query to a text file..
I tried using
U the sql query DOES format the data...
Check it again. Look up the decode and rpad functions in Oracle.
customer, my ass
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 1:00 PM
To: CF-Talk
Subject: Re: Writing cfoutput to a text file
: Writing cfoutput to a text file
[EMAIL PROTECTED] wrote:
Yes but I need to dump the whole query formatted just how the sql query
formats it.
This confuses me.The SQL query doesn't format the data at all, it just
returns the data in a query object.
- Rick
[Todays Threads]
[This Message
I was commenting on the amount of traffic topics like this create.
Multiple answers had been posted and then we have someone that doesn't
read the other posts and still posts. It was not in response to you, it
was in response to the message I copied in my email.
[EMAIL PROTECTED] wrote:
PROTECTED]
Sent: Tuesday, June 22, 2004 1:37 PM
To: CF-Talk
Subject: RE: Writing cfoutput to a text file
I think he meant, in nice, columns etc...
remember, there are people who don't know everything on this list.
those who think they do, usually, don't...
tw
-Original Message-
From: Rick
And your bitching over this creates even more traffic.
Thanks a lot...
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 1:47 PM
To: CF-Talk
Subject: Re: Writing cfoutput to a text file
I was commenting on the amount of traffic topics like
Bryan F. Hogan wrote:
I was commenting on the amount of traffic topics like this create.
Multiple answers had been posted and then we have someone that doesn't
read the other posts and still posts.
I hope that was not directed at me.Please don't accuse me of not
reading threads before
And it was!
Rick Root wrote:
I hope that was not directed at me.Please don't accuse me of not
reading threads before posting.I read EVERY message in the thread that
was in my mailbox before I posted.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
query:
!--- number of columns ---
cfset n = 2
!--- Empty cells at the end ---
cfset remainingCells = (n - qTest.recordCount MOD n) MOD n
cfif qTest.recordCount
table border=1
cfoutput query=qTest
cfif qTest.currentRow MOD n IS 1
tr
/cfif
td#qTest.title#/td
cfif qTest.currentRow MOD n IS 0
/tr
/cfif
This worked well. Thanks.
_
From: Greg Luce [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 10:36 AM
To: CF-Talk
Subject: RE: CFOUTPUT Question
Bruce,
I just ran this against a local table and it renders 2 nice
columns. The y helps you see what currentrow MOD 2 is doing.
cfquery
Your close, you don't want to close the new row inside your If statement.And you will need a closing tag at the end.
tr
cfoutput query=qSubCat1 group=Style
td
img src="" border=0
/td
cfifCurrentRow Mod 2 IS 1
/tr
tr
/cfif
/cfoutput
/tr
You can also simplify your if
td
img src="" border=0
/td
td
img src="" border=0
/td
td
img src="" border=0
/td
td
img src="" border=0
/td
/tr
tr
/tr
/td
/tr
/table
_
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 20
Can you provide the complete CFML code.I think you may need to reverse your if statement to cfif NOT currentRow MOD 4.It looks like you are trying to output 4 columns?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I've got something very similar to that, with three columns, but otherwise similar logic:
cfset total_items = GetPerFeatures.Recordcount
cfset columns = 3
cfset col_tick = 0
cfset count = 0
table border=0 cellpadding=0 cellspacing=0 width=90% align=center
tr
cfoutput
cfloop query
Bruce,
I just ran this against a local table and it renders 2 nice
columns. The y helps you see what currentrow MOD 2 is doing.
cfquery name=x datasource=cftest
SELECT TOP 10 *
FROM company
/cfquery
table width=90% border=1
tr
cfoutput query=x
cfset y = CurrentRow Mod 2
td#email# - #y#/td
cfif
I have this piece of code:
tr
cfoutput query=qSubCat1 group=Style
td
img src="" border=0
/td
cfifCurrentRow Mod 2 IS 1
/tr
tr
/tr
/cfif
/cfoutput
What I was hoping to achieve was, when the second image appeared (the second
column), then a new row would appear.
This may not be how you want to handle it, but how about this way.
style
.gallery {
width:102px;
}
.gallery img {
float:left;
}
/style
div class=gallery
cfoutput query=qSubCat1 group=Style
img src="" border=0
/cfoutput
/div
--
marlon
And Bobby you are right, I am bei
the cfoutput query=myQuery...cfoutputmakes one iteration for each
row in the query
I think you want something like:
tr
td.../td
td.../td
/tr
within the output tags
HTH
Dick
On Mar 31, 2004, at 7:00 PM, Bruce Sorge wrote:
I have this piece of code:
tr
cfoutput query=qSubCat1 group
Does anyone (MM guys, in particular) know the official position on this:
cfoutput
cfoutput query=getThings group=id
cfoutput
/cfoutput
/cfoutput
/cfoutput
That's invalid in CF5 and less (the outer CFOUTPUT doesn't have a 'GROUP'
attribute, so it can't contain another CFOUTPUT tag), but it's
Someone else mentioned it before.They said it looks like CFMX is more
forgiving on this.
Jevo
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 2:13 PM
To: CF-Talk
Subject: Nesting CFOUTPUT
Does anyone (MM guys, in particular) know
]
Sent: Thursday, February 19, 2004 3:50 PM
Subject: RE: Nesting CFOUTPUT
Someone else mentioned it before.They said it looks like CFMX is more
forgiving on this.
Jevo
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 2:13 PM
To: CF
The question is not whether it's more forgiving, but whether it's a change
in the language itself, or a change in the implementation.In other words,
can we rely on CFMX's disregard for invalidly nested CFOUTPUT tags, or is it
just an implementation glitch?
barneyb
-Original Message
How do I apply the trim function in a CFOUTPUT?
I have: CFOUTPUTTrim(#getinfo.trialname#).htm/CFOUTPUT. (Maybe it should be in cfoutput--not sure on this)
It's probably wrong I figure. I need the .htm to appear right after the getinfo.trialname so it can be clicked directly to a html page. Right
cfoutput#trim(getInfo.trialName)#.htm/cfoutput
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Change it to
cfoutput#trim(getinfo.trialname)#.html/cfoutput
Notice the difference? The # signs are around trim. In your example, they
were only arround the varaible so CF just ignored the Trim part.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Move your #s outside the TRIM function
CFOUTPUT
#TRIM(getinfo.trialname)#.htm
/CFOUTPUT
Randy Adkins
SRA International
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 9:23 AM
To: CF-Talk
Subject: Trim in cfoutput
How do I
Thanks all for your QUICK suggestions. Sometimes its too easy but your thinking too ahead of the game.
Robert O.
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 10, 2004 9:32 AM
To: CF-Talk
Subject: RE: Trim in cfoutput
Change it to
cfoutput
Hi all,
I have an annoying little problem with CFOUTPUT. On a simple page which runs a stored procedure and then a query and finally indexes a collection with the results, I display a message inside of a CFOUTPUT tag to confirm that the indexing is done.
However, as my data grows, the indexing
However, as my data grows, the indexing takes a little more time, and now
about 9 times out of 10, I get the following error message: The request has
exceeded the allowable time limit Tag: cfoutput. I know I can simply remove
the CFOUTPUT tag (as indexing occurs fine), but is there a way
It's Friday the 14th not the 13th. So why is this working on my machine
and not throwing an error?
cfoutput
cfoutputdd/cfoutput
/cfoutput
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
The first cfoutput has to have a grouping= in order to nest them.
Steve
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 4:50 PM
To: CF-Talk
Subject: Cfoutput inside another cfoutput
It's Friday the 14th not the 13th. So why
he questioning why it's actually working, as it did for me - mx6.0
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 5:00 PM
To: CF-Talk
Subject: RE: Cfoutput inside another cfoutput
The first cfoutput has to have a grouping
Opps my bad.Can't seem to read any more.Brain shutting down.
-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 5:04 PM
To: CF-Talk
Subject: RE: Cfoutput inside another cfoutput
he questioning why it's actually working, as it did for me
Your right, but the below code _works_
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 5:00 PM
To: CF-Talk
Subject: RE: Cfoutput inside another cfoutput
The first cfoutput has to have a grouping= in order to nest them.
Steve
Check this one out:
cfset de=6
cfoutputcfoutput#de#cfoutput#de#cfoutput#de#/cfoutput/cfoutput/
cfoutput/cfoutput
Shows 666 :))
TK
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 4:50 PM
To: CF-Talk
Subject: Cfoutput inside another
Yep :)
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 5:11 PM
To: CF-Talk
Subject: RE: Cfoutput inside another cfoutput
Check this one out:
cfset de=6
cfoutputcfoutput#de#cfoutput#de#cfoutput#de#/cfoutput/cfoutpu
t/
cfoutput/cfoutput
Shows
In CFMX, nested CFOUTPUTs are ignored, unlike in previous versions.I've
never seen anything official stating that fact, but it's definitely true.I
suspect it's a byproduct of the fact that CF goes to Java first, so the
CFOUTPUT commands are now compiler instructions (like CFIMPORT
The only way i can think to do this would be to write the files and then
call them or include them.
Tyler Clendenin
GSL Solutions
_
From: Bailey, Neal [mailto:[EMAIL PROTECTED]
Sent: Friday, November 07, 2003 5:07 PM
To: CF-Talk
Subject: cfoutput?
Ok here is another one for ya...
I
Ok here is another one for ya...
I have a bunch of html documents stored in my database and in these
documents I need to run some ColdFusion code before it's displayed. But
since I'm outputting the html using ColdFusion it will not work. Is there
some other way of running my cf code before or
Is there anyway to put a cfoutput such as
cfoutput query=findcity#city#/cfoutput
within a cfmail tag ...
I'm getting a Invalid tag nesting configuration error:
A query driven CFOUTPUT tag is nested inside a CFMAIL tag that also has
a QUERY= attribute. This is not allowed. Nesting these tags
Hi,
You can just use
#findCity.city#
OR
#findCity.city[n]#
where n is the index of the value
Regards,
Dan.
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 17:20
To: CF-Talk
Subject: cfoutput within cfmail
Is there anyway to put
no. CFMAIL acts as a CFOUTPUT.
Try using CFLOOP QUERY instead
[EMAIL PROTECTED] 10/22/03 12:20PM
Is there anyway to put a cfoutput such as
cfoutput query=findcity#city#/cfoutput
within a cfmail tag ...
I'm getting a Invalid tag nesting configuration error:
A query driven CFOUTPUT tag
you can add query= to cfmail tag.
and it will do the same type of processing that the query= attribute
of the cfoutput tag.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-Original Message-
From: Tim Laureska [mailto
Try replacing the CFOUTPUT with a CFLOOP tag.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 12:20 PM
To: CF-Talk
Tim Laureska wrote:
Is there anyway to put a cfoutput such as
cfoutput query=findcity#city#/cfoutput
within a cfmail tag ...
cfmail acts like a cfoutput tag, so when you put a cfoutput within a
cfmail, the server thinks your nesting cfoutputs.
So, what you can do is: cfloop query=findcity
cfmail doesn't require cfoutput tags within it.anything within # in cfmail is treated as a variable and evaluated.
cfmail
to=blah
from=blah
subject=how's the blah?
City: #findcity.city#
/cfmail
the cfmail tag also accepts a QUERY attribute so you wouldn't necessarily have to scope 'city
Thanks to all that responded...this:
City: #findcity.city# works fine
I guess I'd have to loop if I wanted multiple outputs
Tim
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 12:32 PM
To: CF-Talk
Subject: Re: cfoutput within cfmail
Hello Everyone,
I'm having a strange problem, I have a few documents that are stored in a
SQL table and these docs have a little CF code in them that's used to build
some dynamic links to other docs. For some reason when I cfoutput the
content of the doc it is not processing the CF code that's
401 - 500 of 910 matches
Mail list logo