I have a field in a form with quoted values, but the values are quot;. When
I post it to another page and output it, something is changing the quot; to a
real (in the source, not the just the display).
I put the following on the page to test...
cfdump var=#form.text#
cfoutput#form.text
...@austin-williams.com]
Sent: Tuesday, April 30, 2013 2:10 PM
To: cf-talk
Subject: Strange Thing - CFOUTPUT converting quot; to
I have a field in a form with quoted values, but the values are quot;. When
I post it to another page and output it, something is changing the quot; to a
real
So, I found a work around, but does anyone know why these would give me
different values?
cfdump var=#form.text#
... the value is quot;mystringquot;
cfoutput#form.text#/cfoutput
values?
cfdump var=#form.text#
... the value is quot;mystringquot;
cfoutput#form.text#/cfoutput
... the value is mystring
Why is CFOUTPUT converting the value quot
If you view source for the cfoutput block you will find
quot;mystringquot; Looks like your html doc, not cfohtput, is rendering
the entity code as expected.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com
://www.uxbinternet.com
W: http://www.ctbusinesslist.com
-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com]
Sent: Tuesday, April 30, 2013 2:10 PM
To: cf-talk
Subject: Strange Thing - CFOUTPUT converting quot; to
I have a field in a form with quoted values, but the values
Why is CFOUTPUT converting the value quot; to on its own?
It's not. quot; is the HTML command to display a quotation. When quot; it
is outputted to the browser the browser will display the quotation mark not
the literal command. The HTMLeditFormat() command prevents the rendering
Hi folks
I need to output email addresses enclosed in as is #email#
I am using cfoutput #name# #email# /cfoutput
just gives the name how do I escape the (doubling doesn't work)
Thanks
Rob
~|
Order the Adobe Coldfusion
lt;#email#gt;
On Mon, Nov 5, 2012 at 12:17 PM, Rob Voyle robvo...@voyle.com wrote:
Hi folks
I need to output email addresses enclosed in as is #email#
I am using cfoutput #name# #email# /cfoutput
just gives the name how do I escape the (doubling doesn't work)
Thanks
Rob
Brilliant Matt
Thanks
Rob
On 5 Nov 2012 at 12:19, Matt Quackenbush wrote:
lt;#email#gt;
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
I just read you email a few minutes ago, after working on this for the
past hour.
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: Thursday, September 30, 2010 10:15 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
Did you get
Did you get this working? If not, could you post the structure of
your data table and I'll see if I can send you the SQL to generate it.
On Fri, Sep 24, 2010 at 4:23 PM, GLM g...@glmdesigns.com wrote:
I have a database with presidents, governors, etc. and need to be able to
pull out
Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced techniques so I hesitate to recommend them
, September 26, 2010 8:08 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
I was thinking years, but you could do days as well. It depends on
what you want to group on in the output.
To save you some searching, below is SQL to fill a numbers table for
SQL
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced techniques so I hesitate
, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced techniques so I hesitate to recommend them based on your
stated SQL experience. One technique involves joining
If you go with the numbers table route, I should clarify that this is
a standard technique that is commonly used, so you should be able to
find a lot of information by searching on sql server numbers table.
I use these all the time. I would think that your numbers table only
needs to contain
I didn't see it working as I only have the dateStart and dateEnd. I guess
it's time I learn how a numbers table works.
Thx
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Sunday, September 26, 2010 5:21 AM
To: cf-talk
Subject: Re: cfoutput or cfloop? which
:42 AM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
If you go with the numbers table route, I should clarify that this is
a standard technique that is commonly used, so you should be able to
find a lot of information by searching on sql server numbers table.
I
.
Thx
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
, getting nominated to higher office, etc...)
I'll give it a shot.
Thx
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do
I was thinking years, but you could do days as well. It depends on
what you want to group on in the output.
To save you some searching, below is SQL to fill a numbers table for
SQL Server, if you go that route. As I said earlier, the other methods
work fine also. I tend to prefer doing as much
it a shot.
Thx
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Saturday, September 25, 2010 10:50 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think
80,000 rows the numbers
table would be less than 400K. Not bad at all.
- Gil
-Original Message-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Sunday, September 26, 2010 8:08 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
I was thinking years
, then cfoutput the array or
structure.
-Mike Chabot
On Fri, Sep 24, 2010 at 10:28 PM, GLM g...@glmdesigns.com wrote:
Thanks Mike,
I'm not a SQL expert but I don't see how. I can do something with particular
fields such as the year the person was elected (governorDateStart) or when
the person
: Re: cfoutput or cfloop? which is the more practical solution
You can do this in SQL, although the methods I can think of involve
advanced techniques so I hesitate to recommend them based on your
stated SQL experience. One technique involves joining to a numbers
table which will transform
I have a database with presidents, governors, etc. and need to be able to
pull out information such as:
Get the number of all female governors over the years and spit out something
on the order of:
1789 : 0
1790 : 0
.
2005 : 10
.
2010 : 6
The database has dateStarted, dateEnded
Are you able to craft a query that will return the results you need
without ColdFusion having to do any extra parsing of it? That is the
first thing I would try. In your brief example it seems like that
would be solved using a GROUP BY statement in the query.
-Mike Chabot
On Fri, Sep 24, 2010
in your query only select only female governess
then use the cfoutput group attribute to group by year, this will then only
output records for the same year.
you need to next 2 cfoutput.
cfoutput query=myquery
cfoutput group=year
your output here
/cfoutput
/cfoutput
On Sat, Sep
-
From: Mike Chabot [mailto:mcha...@gmail.com]
Sent: Friday, September 24, 2010 7:35 PM
To: cf-talk
Subject: Re: cfoutput or cfloop? which is the more practical solution
Are you able to craft a query that will return the results you need
without ColdFusion having to do any extra parsing
, name, and each pet
on the same row of table, preferably with the pets all listed in the same cell.
I'm not that experienced with ColdFusion so my first attempt looked like this:
cfquery datasource=#dsn# name=person
SELECT *
FROM tblPerson
/cfquery
table
cfoutput query=person
tr
Hi Brandon,
1) Use a cfloop in place of a cfoutput tag for the inner loop.
2) in situations like these I recommend also scoping your variables, eg. the
pets in the inner loop would be #pets.pet#
3) in general your approach should be revisited, mainly because it will
create and execute a new
I think my first post failed :-(
SQL with JOIN
CFOUTPUT with group
cfquery datasource=#dsn# name=qryPetPerson
SELECT tblPerson.id, tblPerson.name,
tblPets.pet
FROM tblPerson, tblPets
WHERE tblPets.ownerID = tblPerson.id
order by tblPerson.id
/cfquery
table
cfoutput query
hi frnds,
i have a problem
like
cfoutput
.
.
.Here i have my date field,
where i have to insert .js file, where ever i am insert it is not taking the
file
i am calling js function like this javascript:showID(..)
error is this
ColdFusion was looking at the following text:
javascript
That's not much to work with, but my guess would be that you have an opening
hash sign (#) before your javascript call and that's throwing ColdFusion
off. Whenever you want to display a hash sign between cfoutput tags you
need to escape it like so:
This would throw an error:
cfoutput
a href
it won't if you code it properly.
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
BobSharp wrote:
Thanks for the tip about Grouping
Sadly, it would remove the eName column, when I just want it blank.
( ie. output shifts left one column )
/tr
tr
CFset LastEmp = *
CFoutput query=qEmpAssets
CFif VARIABLES.LastEmp IS NOT trim(qEmpAssets.eName)
CFset VARIABLES.LastEmp = trim(qEmpAssets.eName)
CFelse
PM
Subject: RE: Eliminating repeated data in CFoutput field
Order your query by eName then do something like this:
cfoutput query=yourQuery group=eName
#yourQuery.eName#
cfoutput
#yourQuery.aTitle#
#yourQuery.cCategory#
/cfoutput
/cfoutput
You'll need to tweak it to fit in your table
a link to if you do not believe me).
for a change, try this for a CFOUTPUT with GROUP attribute solution:
CFquery name=qEmpAssets datasource=bs3578
...
/CFquery
table
tr
th width=20% Name /th th width=30% Asset /th th width=30%
Category /th
/tr
CFoutput query=qEmpAssets group=eName
Thanks for the tip about Grouping
Sadly, it would remove the eName column, when I just want it blank.
( ie. output shifts left one column )
No, it needn't do that, and grouping is really the correct way to
solve this problem. You can find an example here:
Tried it several ways, yet to get it to work as I want it.
http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm
Must be the postion of the CFoutput, in relation to the TD table cells.
CFquery name=qEmpAssets datasource=bs3578
SELECT concat(e.firstname, ' ', e.lastname) AS eName
You should be able to do this but I haven't tried it.
table border=1
tr
th width=20% Name /th
th width=30% Asset /th
th width=30% Category /th
/tr
CFoutput query=qEmpAssets group=eName
tr
td #qEmpAssets.eName# /td
td CFoutput
Yep ! That's it.
http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm
Thanks
- Original Message -
From: Nick G ngiova...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Thursday, March 19, 2009 9:14 PM
Subject: Re: Eliminating repeated data in CFoutput field
You
Bob, did you try the code I posted earlier?
Using rowspan is the ideal way to do this, and it looks like what I wrote
should work fine...
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
the same as the original.
My script is ...
table
tr
th Name /th th Asset /th th Category /th
/tr
tr
CFoutput query=qEmpAssets
CFif VARIABLES.LastEmp IS eName
CFset eName = ' '
CFelse
CFset
Order your query by eName then do something like this:
cfoutput query=yourQuery group=eName
#yourQuery.eName#
cfoutput
#yourQuery.aTitle#
#yourQuery.cCategory#
/cfoutput
/cfoutput
You'll need to tweak it to fit in your table layout mind
Hi Bob,
That's not working because cfset eName = / is just setting a empty
variable named eName it's not updating the query variable eName. Since your
in a cfoutput with a query attribute CF's going to look for a query variable
that matches first. IIRC the order of lookup is query, arguments
This is not perfect (should really be using functions, for starters), but I
think it will do what you want...
cfquery name=qEmployees dbtype=Query
SELECT DISTINCT eName
FROM qEmpAssets
/cfquery
table
thead
tr
th Name /th
th
cfoutput group=n1#n1Id#,/cfoutput
i need to set a variable as a list from the results above.
i tried putting a cfset inside the cfoutput, but it didn't work.
some thing like
cfset myList = 7,4,9
~|
Adobe® ColdFusion® 8
cfset myList = ListAppend(myList, ni.id)
Adrian
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 27 February 2009 16:58
To: cf-talk
Subject: setting a var from Inside cfoutput group
cfoutput group=n1#n1Id#,/cfoutput
i need to set a variable as a list from
cfoutput group=n1
cfset myList = #n1Id#,
cfset myListx = ListAppend(myList, n1Id)
/cfoutput
returns:
myList: 6,
myListX: 6,,6
cfoutput group=n1#n1Id#,/cfoutput
returns:
1,7,2,6,
which is what i want, but as a carible i can call outside of the output
You're restarting the variable by setting it inside the output group. Try:
cfset myList =
cfoutput group=n1
cfset myListx = ListAppend(myList, n1Id)
/cfoutput
On Fri, Feb 27, 2009 at 11:10 AM, Paul Ihrig pih...@gmail.com wrote:
cfoutput group=n1
cfset myList = #n1Id#,
cfset myListx
Thanks Guys!
worked like a charm!
On Fri, Feb 27, 2009 at 12:18 PM, morgan l greyk...@gmail.com wrote:
You're restarting the variable by setting it inside the output group. Try:
cfset myList =
cfoutput group=n1
cfset myListx = ListAppend(myList, n1Id)
/cfoutput
On Fri, Feb 27, 2009
Or, if you don't need to loop the output for any other reason, just do this
once, without using CFOUTPUT at all:
cfset myList = valueList(n1.n1Id) /
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
So I'm reading this guide and it's really helpful!
http://www.iknowkungfoo.com/blog/index.cfm/2007/8/22/Object-Oriented-Coldfusion--1--Intro-to-Objectcfc
In my reading, I came upon an example similar to this:
cfset qUsers = object.getallusers()
cfoutput query=qUsers
...
/cfoutput
Would
In my reading, I came upon an example similar to this:
cfset qUsers = object.getallusers()
cfoutput query=qUsers
...
/cfoutput
Would it be possible to do this instead:
cfoutput query=object.getallusers()
...
/cfoutput
It just seems like a neat way to avoid involving an extra
In my reading, I came upon an example similar to this:
cfset qUsers = object.getallusers()
cfoutput query=qUsers
...
/cfoutput
Would it be possible to do this instead:
cfoutput query=object.getallusers()
...
/cfoutput
Yes, I'm pretty sure it would work. That said, it might
-Original Message-
From: Dominic Watson [mailto:watson.domi...@googlemail.com]
Sent: Wednesday, January 14, 2009 5:50 PM
To: cf-talk
Subject: Re: Calling functions with cfoutput
Using a function to output isn't really the done thing in CF. Use either
a custom tag, module include or plain
: Wednesday, January 14, 2009 5:50 PM
To: cf-talk
Subject: Re: Calling functions with cfoutput
Using a function to output isn't really the done thing in CF. Use either
a custom tag, module include or plain cfinclude to modularise your
output logic. If the function performs some action on a string
Custom tags, cfmodule and cfinclude all exist for good reason, they
are designed for modularising output. If you fully understand their
use, you most likely would not desire to use a function to modularise
your output though, of course, you are perfectly free to do so.
While you are free to
No, there is nothing inheritently wrong with it (though there are
articled reasons for not doing it:
http://www.adobe.com/devnet/coldfusion/extreme/bforta_cfc.html). I
don't think there are any good reasons for doing it over using
modules/includes/custom tags either.
But anyways, the OP seemed to
[mailto:dwa...@figleaf.com]
Sent: Thursday, January 15, 2009 6:18 AM
To: cf-talk
Subject: Re: Calling functions with cfoutput
Custom tags, cfmodule and cfinclude all exist for good reason, they
are designed for modularising output. If you fully understand their
use, you most likely would
I have a cfform. From this I call a function, which has cfoutput tags to
output text. However this text is not getting printed to the form. Is this
expected? Is there a way around this?
Thanks
NG
e.g.
cfform...
This is a form
cfset doPrint()
/cfform
cffunction name=doPrint...
cfoutputThis
Try other way around: cfoutput in form:
cfform...
This is a form
cfoutput#doPrint()#/cfoutput
/cfform
cffunction name=doPrint...
This is data to be printed
/cffunction
~|
Adobe® ColdFusion® 8 software 8 is the most
You're not outputting it. You're setting it.
cfform ...
this is a form.
cfoutput#doPrint()#/cfoutput
/cfform
On Wed, Jan 14, 2009 at 9:16 AM, Damayanti Gupta dgu...@archemix.comwrote:
I have a cfform. From this I call a function, which has cfoutput tags to
output text. However
Is it getting rendered out side the cfform?
On Wed, Jan 14, 2009 at 12:16 PM, Damayanti Gupta dgu...@archemix.comwrote:
I have a cfform. From this I call a function, which has cfoutput tags to
output text. However this text is not getting printed to the form. Is this
expected? Is there a way
...
cfreturn String that has been modified... or something /
/cffunction
cfform...
cfoutput#myFunction()#/cfoutput
/cfform
HTH
Dominic
2009/1/14 Gerald Guido gerald.gu...@gmail.com:
Is it getting rendered out side the cfform?
On Wed, Jan 14, 2009 at 12:16 PM, Damayanti Gupta dgu
I don't recall ever having a problem with the cfoutput group attribute. But I
can't figure out why it isn't woring right here.
My table looks like this:
ID Date ZIP code
-
1 12/01/200827403
2 12/01/200890210
3 12/01/2008
Crap, it goes back to my stupid date/time datatype for the field. All the times
are different, and CF IS group the data, but they're all different so it output
each row. I used Michael's example from my other thread to do this. Seems to
work:
SELECT estshiplogid,CAST(FLOOR(CAST(estshiplogdate
If I use cfoutput with query=foo and the queries record count is 0. The
CFoutput is not stepped into.
Has this always been true?
I have some code like this and noticed that I never returned the NOT FOUND
statement because if the recordcount is zero the cfoutput is skipped over.
cfoutput
I believe this is (and has been) true.
put the conditional outside.
cfif getshots.recordcount eq 0
cfoutput#variables.i#, not found/cfoutput
cfelse
cfoutput query=getShots
#variables.i#, #getShots.Filename#, #getShots.JID#,
#getShots.status#br /
/cfoutput
/cfif
On Tue
just tried this and it works in my CF8 installation:
cfoutput query=foo group=id
#foo.id#br
cfoutput#foo.b#br/cfoutput
/cfoutput
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get
Since when have we been able to nest cfoutputs?
I have always thought that you could not do this. Maybe it was a CF4.5/5.0
thing and in never learned it was possible in MX?
I just tried this and it works in my CF8 installation:
cfoutput query=foo group=id
#foo.id#br
cfoutput#foo.b#br/cfoutput
You've always been able to nest outputs when placed within a grouped output.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2008 8:48 AM
To: CF-Talk
Subject: cfoutput in a cfouput
Since when have we been able to nest cfoutputs?
I have always
installation:
cfoutput query=foo group=id
#foo.id#br
cfoutput#foo.b#br/cfoutput
/cfoutput
you've always been able to nest cfoutputs within one another when the
outer cfoutput made use of the group attribute. i'm pretty sure the
docs have always, even back in the day, said something to the effect
But why would you ever want to next cfoutput tags?
Rick
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2008 10:55 AM
To: CF-Talk
Subject: Re: cfoutput in a cfouput
you've always been able to nest cfoutputs within one another when
PROTECTED] wrote:
But why would you ever want to next cfoutput tags?
Rick
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2008 10:55 AM
To: CF-Talk
Subject: Re: cfoutput in a cfouput
you've always been able to nest cfoutputs within one
I guess to make things easier for those people just starting out...
My god Have I officially passed into Old Time ColdFusion Geezer
after 8 years? :)
On Wed, May 28, 2008 at 8:41 AM, Charlie Griefer
[EMAIL PROTECTED] wrote:
I can't imagine a scenario where you would.
that's why i alluded
Hate to break it to you...but you've been in the Geezer category
for a couple of years now. :oP
Rick
-Original Message-
From: Phillip Vector [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2008 11:45 AM
To: CF-Talk
Subject: Re: cfoutput in a cfouput
I guess to make things
Since when have we been able to nest cfoutputs?
I have always thought that you could not do this. Maybe it
was a CF4.5/5.0 thing and in never learned it was possible in MX?
I just tried this and it works in my CF8 installation:
cfoutput query=foo group=id
#foo.id#br
cfoutput#foo.b
My god Have I officially passed into Old Time ColdFusion Geezer
after 8 years? :)
Ha! Look here sonny. Back in my day when we wanted to query a database we
did it by rubbing two sticks together.
~|
Adobe® ColdFusion® 8
BAH!!!
Heh.. I caught myself thinking Back during ColdFusion 5, I learned
the hard way not to nest cfoutputs... These kids today have it easy.
:)
On Wed, May 28, 2008 at 9:07 AM, Rick Faircloth
[EMAIL PROTECTED] wrote:
Hate to break it to you...but you've been in the Geezer category
for a
ok. i am having a serious brain fart...
i know there is a beter way to ooutput a list the is comma seperated then
this..
cfloop query=getProd
cfset columns = columns#specs_partnum#,
/cfloop
!--- remove the last comma ---
cfset columns = left(columns,evaluate(len(columns) -1))
cfoutput
cfoutput#valueList(getProd.specs_partnum)#/cfoutput
-Joe
On Tue, May 13, 2008 at 11:26 AM, morchella
[EMAIL PROTECTED] wrote:
ok. i am having a serious brain fart...
i know there is a beter way to ooutput a list the is comma seperated then
this..
cfloop query=getProd
cfset
#specs_partnum#,
/cfloop
!--- remove the last comma ---
cfset columns = left(columns,evaluate(len(columns) -1))
cfoutput#columns#/cfoutput
but again, i am drawing a complete blank...
any help would be appreciated
thanks
(columns) -1))
cfoutput#columns#/cfoutput
but again, i am drawing a complete blank...
any help would be appreciated
thanks!
valueList(getProd,'specs_partnum')
OR
quotedValueList(getProd,'specs_partnum')
~|
Adobe® ColdFusion® 8
awsome...
thank you!
now.. =]
how would i remove doubles?
!--- List of Accessory's that are assigned to this product ---
cfquery name=getAccessory datasource=listit
SELECT DISTINCT ascList
FROM dbo.list
WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL)
/cfquery
gives me...
also why is it not listed in my wack books under functions?
also where did functions go in the 8 series of wack books..
i know its there in 4.5-7...
On Tue, May 13, 2008 at 11:46 AM, morchella [EMAIL PROTECTED]
wrote:
awsome...
thank you!
now.. =]
how would i remove doubles?
!--- List of
If you're doing a distinct in your query, or a group by, then you shouldn't
have any dupes.
-Original Message-
From: morchella [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 13, 2008 10:47 AM
To: CF-Talk
Subject: Re: easy one! : comma separated list from cfoutput
awsome...
thank you
You can do it using a QoQ and Select DISTINCT
OR
I wrote a couple of functions to do this. One day I will post them to
CFLib.
/**
* Case-sensitive function for removing duplicate entries in a list.
* @param list The list to be modified.
* @return Returns a list.
*/
function
Wait... I cant remember if I wrote those or not. I have a library of list
functions... Some I wrote, some I got offa CFlib. Don;t want to take credit
for someone else's work.
G
On Tue, May 13, 2008 at 12:04 PM, Gerald Guido [EMAIL PROTECTED]
wrote:
You can do it using a QoQ and Select
PROTECTED]
wrote:
If you're doing a distinct in your query, or a group by, then you
shouldn't
have any dupes.
-Original Message-
From: morchella [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 13, 2008 10:47 AM
To: CF-Talk
Subject: Re: easy one! : comma separated list from cfoutput
Try this:
http://www.bennadel.com/blog/432-Using-ColdFusion-Structures-To-Remove-D
uplicate-List-Values.htm
m!ke
-Original Message-
From: morchella [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 13, 2008 11:08 AM
To: CF-Talk
Subject: Re: easy one! : comma separated list from cfoutput
Order by ascList... that should get DISTINCT to work.
cfquery name=getAccessory datasource=listit
SELECT DISTINCT ascList
FROM dbo.list
WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL)
ORDER BY ascList
/cfquery
Robert B. Harrison
Director of Interactive services
Austin
ORDER BY ascList
that still gives me
ascList
132
135
135,132
On Tue, May 13, 2008 at 12:37 PM, Robert Harrison
[EMAIL PROTECTED] wrote:
Order by ascList... that should get DISTINCT to work.
cfquery name=getAccessory datasource=listit
SELECT DISTINCT ascList
FROM dbo.list
WHERE
ian, that is exactly what i am doing.
but i am storing a list inside a column to refer to user created groupings
of items.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
In that case you would probably either have to move the values to a look up
table (normalize) or uses a function to tease out the dupes.
G
On Tue, May 13, 2008 at 1:11 PM, Paul Ihrig [EMAIL PROTECTED] wrote:
ian, that is exactly what i am doing.
but i am storing a list inside a column to
If that's what you're doing then why not have a user_groupings
relational table that holds the user_id and group_id?
On Tue, May 13, 2008 at 12:11 PM, Paul Ihrig [EMAIL PROTECTED] wrote:
ian, that is exactly what i am doing.
but i am storing a list inside a column to refer to user created
Paul Ihrig wrote:
ian, that is exactly what i am doing.
but i am storing a list inside a column to refer to user created groupings
of items.
Ok, this would be fairly easy to normalize with a join table.
user_grouping
--
userID
groupID
Then you would have records something like
Paul Ihrig wrote:
ORDER BY ascList
that still gives me
ascList
132
135
135,132
It looks to me like you have a de-normalized database scheme there that
stores a list of values in a column. If that case then that is the
result you are going to get. '132', '135' and '135,132' are three
1 - 100 of 910 matches
Mail list logo
