Are you trying to do this?
list = simg1,limg1,simg2,limg2...
Or
list= simg1,simg2,limg1,limg2...
--K
-Original Message-
From: Jeffrey V. Lemire [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 2:06 PM
To: CFTALK
Subject: Creating A List
Hello Folks!
I was wondering if someo
Version 1:
> list = simg1,limg1,simg2,limg2...
Or version 2:
> list= simg1,simg2,limg1,limg2...
> -Original Message-
> From: Jeffrey V. Lemire [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 04, 2000 2:06 PM
> To: CFTALK
> Subject: Creating A List
>
>
> Hello Folks!
>
I'm trying to accomplish list= simg1,simg2,limg1,limg2
This would be ideal...got some ideas?
Jeff
-Original Message-
From: Katrina Chapman [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 5:45 PM
To: [EMAIL PROTECTED]
Subject: RE: Creating A List
Are you trying to do
Check out David's answer
-Original Message-
From: Jeffrey V. Lemire [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 4:13 PM
To: [EMAIL PROTECTED]
Subject: RE: Creating A List
I'm trying to accomplish list= simg1,simg2,limg1,limg2
This would be ideal...got some id
Lists don't require anything special to create. Just set a variable to
an empty string and use the listappend function to additems to it.
-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 3:51 PM
To: CF-Talk
Subject: Creating a list
Is ListA
Valuelist() will turn a DB field into a list. For example, a query returns 10 rows. To
turn this into a list
valuelist(queryname.columnname)
A second, optional attribute allows you to control the delimiter (default to comma)
At 04:51 PM 5/21/02, you wrote:
>Is ListAppend used to create a new lis
If you want to turn a column of a query into a list
If you want to create a blank List
:)
If you want to add to the end of a list
Jerry Johnson
>>> [EMAIL PROTECTED] 05/21/02 04:51PM >>>
Is ListAppend used to create a new list? I am querying a db for one field.
This will return multiple
Tony,
This should work...
v/r,
Jeff
-Original Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 4:51 PM
To: CF-Talk
Subject: Creating a list
Is ListAppend used to create a new list? I am querying a db for one field.
This will return multip
use valueList(query.column, list)
At 01:51 PM 5/21/2002 -0700, you wrote:
>Is ListAppend used to create a new list? I am querying a db for one field.
>This will return multiple values. I need to turn that return set into a list
>for use elsewhere. Strange I have realized I have not had to create
I remember asking myself the same question when I first got into lists.
There is no function for creating a list like there is for query or array.
AFAIK CF looks at whatever variable like a list. Just set the field's value
to a CF variable like this. It works perfectly for me.
HTH,
~Val
---
dOh :-), Thanks
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:54 PM
To: CF-Talk
Subject: RE: Creating a list
Lists don't require anything special to create. Just set a variable to
an empty string and use the listappend functi
use the old favorite #ValueList(queryName.ColumnName)# to start off your
list and you should be set...
Tyler Silcox
email | [EMAIL PROTECTED]
website | www.gslsolutions.com- Original Message -
From: "Tony Gruen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 21,
Not as such, you can create a list simply by doing this...
#y#
A 'list' is anything seperated by a delimiter such as a comma.
Neil Clark
Team Macromedia
http://www.macromedia.com/go/team
Announcing Macromedia MX!!
http://www.macromedia.com/software/trial/.
-Original Message---
use value list for this ...
valuelist(query.columnname)
- Original Message -
From: "Tony Gruen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 21, 2002 9:51 PM
Subject: Creating a list
> Is ListAppend used to create a new list? I am querying a db for one field.
Les Mizzell wrote:
> Need to build a list of record counts
>
> What's wrong with this?
>
>
>
>
>
> SELECT *
> FROM Q_D2
> WHERE ACTPRYSID = #BUILDINGS.PRYSID#
>
>
>
>
>
How does the query Buildings look? You can probably do this more
efficient
-Talk
Subject: Re: Creating a list of myQUERY.recordcount
Les Mizzell wrote:
> Need to build a list of record counts
>
> What's wrong with this?
>
>
>
>
>
> SELECT *
> FROM Q_D2
> WHERE ACTPRYSID = #BUILDINGS.PRY
Tim;
How about:
Seperate your records by a tilda and then split them out later by looking
for
a double tilda.
-Original Message-
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 12:08 PM
To: CF-Talk
Subject: creating a list from a query
I need to create
You can then get each list by breaking it down to smaller lists by using
chr(7) as your delimiter.
__
steve oliver
cresco technologies, inc.
http://www.crescotech.com
-Original Message-
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 1:08 P
Something like this should work. Lookup the columnList property in the CF
manual.
select *
from finals
where name = #form.name#
- Original Message -
From: "Tim" <[EMAIL PROTECTED]>
I need to create a comma delineated list of all field
values generated from a q
It's faster to build the list in the SQL statement...
[Oracle]
SELECT field1 || "~" || field2 || "~" || field 3
FROM.
then finish it off with a VALUELIST() function.
But this is pretty specialized so it may not be the right solution for
your
app.
+
valuelist() perhaps?
jb.
On Tue, 24 Aug 2004 09:53:04 -0400, Anne Girardeau <[EMAIL PROTECTED]> wrote:
> I've created a custom tag that recurses over a database to create a breadcrumb trail. The problem I'm encountering is I would really like to be able to pull a list from that tag that it can t
I don't think that will work in a recursion judging by what I've read about it. It seems it just takes data from a query column and creates a list out of it. But, that's assuming all of the data needed for the list is there on the first query. Since I'm dealing with a recursion, the query will ob
s that are
even less intensive, but require more development that I can't go into
right now because my dev server just came back up.
Cheers,
Joe
- Original Message -
From: Anne Girardeau <[EMAIL PROTECTED]>
Date: Tue, 24 Aug 2004 10:48:03 -0400
Subject: Re: Creating a List fr
Hey Joe,
Thanks for your input. Actually I figured something out using session variables and it works amazingly well. The performance of it also isn't too terrible since the most the script should ever recurse would be 5 or 6 times, if that.
I am, however, intrigued by your comment about havin
I'd recommend using the request scope, rather than the session scope.
A breadcrumb display is not bound to a user session in any way, it's
strictly related to the current request.
Joe's suggestion to use the custom tag framework that CF provides is
superior even to that, because it allows multipl
Thanks for the tip barneyb, I replaced session with request and it still works beautifully.
I agree that it's not much of an issue with breadcrumb generation. I'm never going to need more than one set of breadcrumbs on a requesting page so hopefully I'm pretty safe with what I have.
Thanks again
>> Currently the breadcrumbs display directly from the custom
>> tag which works relatively well. Except there are instances
>> when I would really like to have the data placed into a list.
>> Any ideas how I could accomplish this?
You need to build the list successively with each recursion and t
its all about the parentId, as long as you know that, and your main
heading, non-indents
have a parent of 0, then order them by recordId or some other ordering
schema, it works.
you cfquery for parents, then under those parents, you cfquery for
children that match
the parentID
make sense?
tony w
Check out these John
http://affy.blogspot.com/ntm/index.htm
WG
-Original Message-
From: John Sprenkle [mailto:[EMAIL PROTECTED]
Sent: 09 July 2003 14:19
To: CF-Talk
Subject: Creating a list with infinite groupings and indents
Say I have a table with the following records:
rec id d
First off... the way you have it setup now will only allow for two levels..
level 1 and level 2. To get the ability you are after (tree type strucutre),
you need to get into nested sets. Joe Celko has done some awesome work in
this area and the links below may help you out. It is a bit tricky at fi
BTW Joe Clecko had an entire book on trees coming soon
"TREES & HIERARCHIES IN SQL (Morgan-Kaufmann), 2003"
http://www.celko.com/books.htm
WG
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: 09 July 2003 14:48
To: CF-Talk
Subject: Re: Creati
navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 9:48 AM
To: CF-Talk
Subject: Re: Creating a list with infinite groupings and indents
First off... the way you have
http://www.houseoffusion.com/_library/
This is the (almost) latest version of my CF_MakeTree and is what's used to
thread the messages on the HoF mail archives. Infinite across the board and
exactly what you need.
> Say I have a table with the following records:
>
> rec id description
mp; HIERARCHIES IN SQL (Morgan-Kaufmann), 2003"
>
>http://www.celko.com/books.htm
>
>WG
>
>
>-Original Message-
>From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
>Sent: 09 July 2003 14:48
>To: CF-Talk
>Subject: Re: Creating a list with infinite groupings
I looked at this method and all the others, and decided to go with
the non-traditional method outlined here.
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=7321&lngWId=4
Much faster in just about every regard (except updating) than the
below method, and sorting is built in.
Ma
Jon Hall wrote:
>I looked at this method and all the others, and decided to go
>with the non-traditional method outlined here.
>http://www.planet-source-code.com/vb/scripts/ShowCode.asp?
>txtCodeId=7321&lngWId=4
Thats actually a fairly old idea. Always seemed to me that inserting records or
reo
Wednesday, July 9, 2003, 5:13:02 PM, you wrote:
MR> Jon Hall wrote:
>>I looked at this method and all the others, and decided to go
>>with the non-traditional method outlined here.
>>http://www.planet-source-code.com/vb/scripts/ShowCode.asp?
>>txtCodeId=7321&lngWId=4
MR> Thats actually a fairly o
>I speak not for this guy...except to say he sounds pretty
>typical of the average VB dork's I run into.
I'll bet. I wasn't lumping you in with His Majesty's royal attitude. :D
Did you look at Michael Dinowitz' cf_maketree? He mentioned it earlier on in this
thread. I use it and its pretty c
Wednesday, July 9, 2003, 5:50:33 PM, you wrote:
>>I speak not for this guy...except to say he sounds pretty
>>typical of the average VB dork's I run into.
MR> I'll bet. I wasn't lumping you in with His Majesty's royal attitude. :D
MR> Did you look at Michael Dinowitz' cf_maketree? He mentioned
> MR> Did you look at Michael Dinowitz' cf_maketree? He mentioned it earlier on
in this thread. I use it and its pretty cool. Its quite fast, and not that
much slower than cfx_fMakeTree (which is
> MR> blazing fast).
>
> I seriously doubt any method written in CF could come close to this
> metho
> A CC processing routine returns via CFHTTP.Filecontent the
> following string:
>
> ssl_result=0 ssl_result_message=APPROVED ssl_txn_id=0123456789
> ssl_approval_code=023456 ssl_cvv2_response=P ssl_avs_response=Y
> ssl_transaction_type=SALE ssl_card_number=4000
>
> I want to conver
#testlist#
Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: "Mark Leder" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, July 14, 2002 1:20 PM
Subject: Creating a list with comma delimits rather than spaces
> This one I've really been pulling my
, where I
would want the ssl_result=0 to appear by itself, but no luck.
Thanks,
Mark
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 4:31 PM
To: CF-Talk
Subject: RE: Creating a list with comma delimits rather than spaces
> A CC process
That worked, THANK YOU!
Thanks,
Mark
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 14, 2002 5:05 PM
To: CF-Talk
Subject: Re: Creating a list with comma delimits rather than spaces
#testlist#
Douglas Brown
Email: [EMAIL PROTECTED
Check they are actually spaces. Forget about /n or /r, and I think these
should be \n but not in CF...
Ade
-Original Message-
From: D F [mailto:[EMAIL PROTECTED]
Sent: 23 August 2006 13:14
To: CF-Talk
Subject: creating a list from copy and pasted text from notepad...
Hi there, I'm tryin
Yah you're right it should be "\n" etc.. I tried both, no luck.
I also tried search for the spaces, but no luck there either.
>Check they are actually spaces. Forget about /n or /r, and I think these
>should be \n but not in CF...
>
>Ade
>
>>For example I'm trying to import a cut and pasted list from notepad
that looks like this..
In your example, you have no spaces but new line chars, so you should
replace all these
by true spaces first, ie:
myList = REReplace (myList, "[[:space:]]+", " ", "all")
Then you'll have a space delimi
D F wrote:
> Yah you're right it should be "\n" etc.. I tried both, no luck.
>
> I also tried search for the spaces, but no luck there either.
>
Try outputting the ascii of your var to see what it contains
#i# - #asc(mid(myvar, i, 1)#
~~~
in Cold Fusion.
-Original Message-
From: Sarah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 1:42 PM
To: CF-Talk
Subject: RE: Creating a list with infinite groupings and indents
I think this is pretty much the same thing that others have pointed you
towards, but I think this art
> First and foremost, we can't run queries inside of tags.
Bummer.
easy enough with a wrapper function.
> Second, even if the query issue were resolved (and if you've got ideas for
> work-arounds, I'd love to hear them), you've now got variable scope
issues.
> A variable declared in a CFMX page
On Wednesday, Jul 9, 2003, at 13:13 US/Pacific, Hagan, Ryan Mr
(Contractor ACI) wrote:
> function list_categories( $parentId, $level ) {
> global $database, $connection;
> $numSpaces = 5;
> $query = "SELECT * FROM myTab
56.8080 x12
fax : 360.647.5351
www.audiencecentral.com
> -Original Message-
> From: Paul Hastings [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 09, 2003 1:33 PM
> To: CF-Talk
> Subject: Re: recursion in cold fusion ( was RE: Creating a list with
> infinite grouping
Hagan, Ryan Mr (Contractor ACI) wrote:
>
> I personally like this solution quite a bit. I know it has performance
> issues, but I've never noticed any significant impact on server response,
> even under heavy load.
I think it is an ugly workaround. SQL is a set oriented language and the
best wa
recursion in cold fusion ( was RE: Creating a list with
infinite groupings and indents )
This brings up an interesting question for me. I tend to use recursive
functions frequently, and have even had to solve a problem very similar to
the original question posed in this thread. My take on the sol
54 matches
Mail list logo