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)#
~~~
>>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
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
>
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
Hi there, I'm trying to create a list ( with the delimiter set for space )...
but it seems that when the text I'm working with ( cut and pasted from notepad
) it seems Coldfusion is not recognizing the spaces as legitimate spaces...
probably some kind of control characters or line brakes etc
>> 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
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
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
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
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
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
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'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 then be easily manipulated. Below is the custom tag code:
SELECT Keywords.KeyID, Keywords.Keyword, Keywor
-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
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
Need to build a list of record counts
What's wrong with this?
SELECT *
FROM Q_D2
WHERE ACTPRYSID = #BUILDINGS.PRYSID#
#roomCOUNTER.recordcount# displays correctly if placed
inside the loop. But setting the list errors out:
The ValueList() func
> 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
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
>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: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
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
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
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
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
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
> 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
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
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
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
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
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
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
om/9603d06.html
http://www.mvps.org/access/queries/qry0023.htm
HTH,
Mike
- Original Message -
From: "John Sprenkle" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 9:19 AM
Subject: Creating a list with infinite groupings a
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
weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: John Sprenkle [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 9:19 AM
To: CF-Talk
Subject: Creating a list with infinite groupings
Say I have a table with the following records:
rec id description parent id
1 Test Record 1 0
2 Test Record 2 1
3 Test Record 3 1
4 Test Record 4 3
5 Test Record 5 3
6 Test Record 6
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
, 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
#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
>
> 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
This one I've really been pulling my hair out on.
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=
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 lis
al Message-
From: Tony Gruen [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2002 21:51
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 multiple values. I need to turn that return set into a
list
for use elsewhere. Stra
ECTED]>
Sent: Tuesday, May 21, 2002 4:51 PM
Subject: Creating a list
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 t
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
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,
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
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
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
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
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 lis
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 a list
like this before.
_
day, that my child may
have
peace'..."
- Thomas Paine, The American Crisis
-Original Message-
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 10:08 AM
To: CF-Talk
Subject: creating a list from a query
I need to create a comma delineated list of all field
val
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
PM
To: CF-Talk
Subject: creating a list from a query
I need to create a comma delineated list of all field
values generated from a query. I know ValueList will
create a list, but from what I can tell it will only
create a list of values from one column for all
records. Is the a way to create a
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
I need to create a comma delineated list of all field
values generated from a query. I know ValueList will
create a list, but from what I can tell it will only
create a list of values from one column for all
records. Is the a way to create a list of all fields
for one record?
I need to be abl
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
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
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 L
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
Hello Folks!
I was wondering if someone could point me in the right direction. Im trying
to create a list that is derived from two columns. For example:
SELECT LargeImage,SmallImage
FROMCoolCars
WHERE CarID=#form.CarID#
I know that the section is wrong bec
62 matches
Mail list logo