RE: list question

2009-05-01 Thread Jason Fisher
ay 01, 2009 10:43 AM To: "cf-talk" Subject: RE: list question Jason, This worked like a champ... Thanks sas -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: Jason Fisher [mailto:ja...@wa

Re: list question

2009-05-01 Thread Ben Nadel
Scott, If you are storing the list in session vars, I would suggest storing it as an Array since array index access is MUCH faster than list index access. The same index logic can be applied. -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York Cold

RE: list question

2009-05-01 Thread Scott Stewart
Session vars -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: Ben Nadel [mailto:b...@bennadel.com] Sent: Friday, May 01, 2009 10:16 AM To: cf-talk Subject: Re: list question Scott, How are you

RE: list question

2009-05-01 Thread Scott Stewart
Jason, This worked like a champ... Thanks sas -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Friday, May 01, 2009 10:21 AM To: cf-talk Subject: re: list

Re: list question

2009-05-01 Thread ColdFusion Developer
If I recall ListFind will return the numeric location of the list (if found). Using that numeric you can do a ListGetAt to get the next and previous. Something like that anyway... syntax may not be right but you get the idea ~~~

Re: list question

2009-05-01 Thread Randy Adkins
If I recall ListFind will return the numeric location of the list (if found). Using that numeric you can do a ListGetAt to get the next and previous. Something like that anyway... syntax may not be right but you get the idea On Fri, May 1, 2009 at 10:13 AM, Scott Stewart wrote: > > Hey all

RE: list question

2009-05-01 Thread Robert Harrison
You could pass the current item id and set nextquery WHERE ID > CURID or WHERE ID < CURID; or you could use startrow http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_1 7.html Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suit

re: list question

2009-05-01 Thread Jason Fisher
and then just use prevOrderID and nextOrderID as appropriate in your links. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;2

Re: list question

2009-05-01 Thread Ian Skinner
listFind() perchance. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-

Re: list question

2009-05-01 Thread Ben Nadel
Scott, How are you maintaining the list from page to page? Are you caching it somewhere? Or passing is via the URLs? -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www

Re: List question... (having a brain [EMAIL PROTECTED])

2008-06-07 Thread Claude Schneegans
Note 3: You must have a pretty good reason not making a loop, because a loop would be much more efficient than using ReplaceList(). A loop could be stopped as soon as an element in the list is found. ReplaceList() will also have a loop internally, but this one will run till the end. --

Re: List question... (having a brain [EMAIL PROTECTED])

2008-06-06 Thread Claude Schneegans
>>Without looping (I'd like one conditional), is there any way to determine if any element from "badtitlekeywords" is contained within "title"? Yes there is, use ReplaceList(), ie: ... then... If one element of badtitlekeywords is found in the string, it will be replaced by a space, then the s

Re: List question... (having a brain [EMAIL PROTECTED])

2008-06-06 Thread Matt Williams
On Fri, Jun 6, 2008 at 4:59 PM, Brad Wood <[EMAIL PROTECTED]> wrote: > Technically, couldn't you create some regex that would check for it in > one swipe? Something like if find matches of (string1 or string2 or > string3 or etc...) I had the same thought, but I had a feeling his list of bad keyw

RE: List question... (having a brain [EMAIL PROTECTED])

2008-06-06 Thread Brad Wood
bject: Re: List question... (having a brain [EMAIL PROTECTED]) No, you have to loop over one of them. Well, you can use a UDF (I know one exists for this at cflib), and that would 'hide' the loop from ya. ;) On Fri, Jun 6, 2008 at 3:52 PM, Che Vilnonis <[EMAIL PROTECTED]> wrote:

Re: List question... (having a brain [EMAIL PROTECTED])

2008-06-06 Thread Raymond Camden
No, you have to loop over one of them. Well, you can use a UDF (I know one exists for this at cflib), and that would 'hide' the loop from ya. ;) On Fri, Jun 6, 2008 at 3:52 PM, Che Vilnonis <[EMAIL PROTECTED]> wrote: > Take the following... > > > > Without looping (I'd like one conditional), i

Re: List Question

2008-04-23 Thread Michael Dinowitz
The old CF-Talk was split a while ago into CF-Talk for technical, CF-Community for off topic community BS, and CF-Jobs for job posts and requests. Since then other lists have spawned off including a CF-OT list for those who want to post OT content but do not want to join the general mayhem of CF-C

Re: List Question

2008-04-23 Thread Greg Morphis
there's the CF-Jobs list... bunch of peeps there On Wed, Apr 23, 2008 at 2:13 PM, Robert Harrison <[EMAIL PROTECTED]> wrote: > I used to see CF Jobs on this list but haven't seen that in awhile. > > Am I allow to send out a CF job notice on the list or is that verboten now? > > > Robert B. Harri

Re: List Question

2008-04-23 Thread Dominic Watson
http://www.houseoffusion.com/groups/cf-jobs/ ;) Dominic On 23/04/2008, Robert Harrison <[EMAIL PROTECTED]> wrote: > > I used to see CF Jobs on this list but haven't seen that in awhile. > > Am I allow to send out a CF job notice on the list or is that verboten > now? > > > Robert B. Harrison >

Re: List Question-

2007-03-09 Thread Peter Boughton
Needs to happen twice - since if you have "ab" then it'll come out as "a| || |b" the first time, so it needs doing again to ensure any middle bits get done. Which is why its better to simply use the list_string.split('|') method I've already provided above. >replace(list_string,"||","| |",

Re: List Question-

2007-03-09 Thread Mik Muller
replace(list_string,"||","| |","all") At 05:46 AM 3/9/2007, Deepak Gupta wrote: >HI >I have this pipe delimited list >suppose A||C >Now the middle one is blank. How can i store this list so that i can track the >middle one as blank and later when i update the DB i can update this null a

Re: List Question-

2007-03-09 Thread Kris Jones
You could do a replace on the list, adding a space between the double delims (CF ignores empty list elements), then in your insert/update statement, set the value to NULL (or whatever) if the list value is a single space. Cheers, Kris > I have this pipe delimited list > suppose A||C > Now the mid

RE: List Question-

2007-03-09 Thread Leitch, Oblio
-- From: Deepak Gupta [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 6:14 AM To: CF-Talk Subject: Re: List Question- cant find a proper solution and all of them were coldfusion 5..has anyone done something like this? >Check out cflib.org, this'll have functions that deal with this ty

Re: List Question-

2007-03-09 Thread Deepak Gupta
Thanks Peter > "VARHCHAR" - I have no idea how I wrote that. :'( > > > Just to note that the cfqueryparam would of course be on the value > side of an appropriate insert/update SQL statement within a cfquery, > etc. > > > > Convert to an array like this: > > > > > > Then insert a null like

Re: List Question-

2007-03-09 Thread Peter Boughton
"VARHCHAR" - I have no idea how I wrote that. :'( Just to note that the cfqueryparam would of course be on the value side of an appropriate insert/update SQL statement within a cfquery, etc. > Convert to an array like this: > > > Then insert a null like this: > cfsqltype="CF_SQL_VARHCHAR"/>

Re: List Question-

2007-03-09 Thread Deepak Gupta
cant find a proper solution and all of them were coldfusion 5..has anyone done something like this? >Check out cflib.org, this'll have functions that deal with this type of >thing. > >Adrian > >-Original Message- >From: Deepak Gupta [mailto:[EMAIL PROTECTED] >Sent: 09 March 2007 10:47 >

Re: List Question-

2007-03-09 Thread Peter Boughton
Convert to an array like this: Then insert a null like this: > HI > I have this pipe delimited list > suppose A||C > Now the middle one is blank. How can i store this list so that i can > track the middle one as blank and later when i update the DB i can > update this null as something else

RE: List Question-

2007-03-09 Thread Adrian Lynch
Check out cflib.org, this'll have functions that deal with this type of thing. Adrian -Original Message- From: Deepak Gupta [mailto:[EMAIL PROTECTED] Sent: 09 March 2007 10:47 To: CF-Talk Subject: List Question- HI I have this pipe delimited list suppose A||C Now the middle one is blank

RE: list question

2005-11-15 Thread Raster, Tim
CF ignores empty items (though I don't know why, because I agree it seems more intuitive that it shouldn't). But some people have written UDFs to get around this: http://www.cflib.org/codeView.cfm?ID=961 or http://www.cflib.org/codeView.cfm?ID=507 These can be easily modified to handle differ

Re: list question

2005-11-14 Thread Qasim Rasheed
I believe you can use something like this HTH Qasim On 11/14/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > oops...yep...my bad...thanks for the catch Barney ;-) > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 >

Re: list question

2005-11-14 Thread Bryan Stevenson
oops...yep...my bad...thanks for the catch Barney ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~

Re: list question

2005-11-14 Thread Ray Champagne
Hey, thanks again Barney. That was the simplest way to get around my problem. Barney Boisvert wrote: > Because CF ignores 'null' list items. So sequential commas are > treated as a single comma. Easiest solution is to do this: > > > > which will add a space to the end of each list element,

Re: list question

2005-11-14 Thread Charlie Griefer
#myList# ? > > -Original Message- > > From: Ray Champagne [mailto:[EMAIL PROTECTED] > > Sent: Monday, November 14, 2005 2:38 PM > > To: CF-Talk > > Subject: list question > > > > can anyone tell me why this list: > > > > 2,1,250,This transaction has been > > declined,,P,0,,,101.00,,aut

Re: list question

2005-11-14 Thread Barney Boisvert
Because CF ignores 'null' list items. So sequential commas are treated as a single comma. Easiest solution is to do this: which will add a space to the end of each list element, including the 'null' ones, thereby making CF recognize them. Just make sure to strip the trailing space after you g

Re: list question

2005-11-14 Thread Barney Boisvert
If you have this list "a,b,,,e", doing that replace will return "a,b, ,,e", which isn't what you want. You have to do it per-comma (as I proposed), or run it twice. cheers, barneyb On 11/14/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > CF ignores empty elementsdoesn't that suck ;-) > > tr

Re: list question

2005-11-14 Thread Ryan Guill
Dov is right, empty list elements are ignored. There is a udf on cflib.org that will turn a list into an array, with elements for empty list items. http://cflib.org/udf.cfm?ID=1022 You could pretty easily write something yourself as well. On 11/14/05, Katz, Dov B (IT) <[EMAIL PROTECTED]> wrote:

Re: list question

2005-11-14 Thread Ray Champagne
Well, I wonder why that is set to be like that. I'll look into using java. Thanks. Katz, Dov B (IT) wrote: > Looks like consecutive delimiters are ignored... > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functb15.htm#wp11 > 07782 > > I wish they had the same option as java.util.St

Re: list question

2005-11-14 Thread Bryan Stevenson
CF ignores empty elementsdoesn't that suck ;-) try doing a replace of ",," with ", ," and then you can check to see if the element is empty using Len(Trim()) HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax:

Re: list question

2005-11-14 Thread Jerry Johnson
Because the default delimiter for a list is a comma (,), and the example you gave has only 9 values in the list (between commas that are not empty). Remember that CF ignores empty list values when counting (so "a,,b,,,c," is really just "a,b,c") On 11/14/05, Ray Champagne <[EMAIL PROTECTED]> wro

RE: list question

2005-11-14 Thread Katz, Dov B \(IT\)
Looks like consecutive delimiters are ignored... http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functb15.htm#wp11 07782 I wish they had the same option as java.util.StringTokenizer which can choose to ignore or count empty tokens -dov -Original Message- From: Ray Champagne [

RE: list question

2002-11-07 Thread Andres
This did it! Thanks! -Original Message- From: Mosh Teitelbaum [mailto:mosh.teitelbaum@;evoch.com] Sent: Thursday, November 07, 2002 10:15 AM To: CF-Talk Subject: RE: list question Place the following just after your CFLOOP statement. It creates variables in the REQUEST scope

Re: list question

2002-11-07 Thread Stephen Moretti
> == > "cookieID=1ID=1&tblID=QQ_323s" > == CookieVarList = ''; for (i=1; i=listlen(cookie.AffilPassedInfo,"&");i=i+1) { CookieItem = ListGetAt(cookie.AffilPassedInfo,i,"&"); CookieVarName = ListFirst(c

RE: list question

2002-11-07 Thread Mosh Teitelbaum
Place the following just after your CFLOOP statement. It creates variables in the REQUEST scope. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Andr

RE: list question

2002-08-14 Thread Tony Weeg
: RE: list question Lists aren't real data structures in CF. They are just a string. So, this is a list: Or Or In the 'z' example - the string can be treated as a list if you use space " " as a delimiter. (It can also be used as a list w/ the default delimiter,

Re: list question

2002-08-14 Thread Paul Giesenhagen
OR dynamically Paul Giesenhagen QuillDesign - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 14, 2002 9:18 AM Subject: list question > duhhhbrain fart this morning > > how the heck do I make a new > list

RE: list question

2002-08-14 Thread Raymond Camden
Lists aren't real data structures in CF. They are just a string. So, this is a list: Or Or In the 'z' example - the string can be treated as a list if you use space " " as a delimiter. (It can also be used as a list w/ the default delimiter, comma, however it will be a list with only one

RE: List question

2001-06-05 Thread Andrew Scott
There are a few things that need to be considered here, first are they required fields (meaning can any be left blank). But if it was me writing the code, I would do the following!! First convert the string into a full name variable, this way you will not need to do any other processing later. Al

RE: List question

2001-06-05 Thread Mark Warrick
arrick.net > -Original Message- > From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 05, 2001 6:50 PM > To: CF-Talk > Subject: RE: List question > > > > That comes back as: > > John,Michael,James Pat,Tony,Peter Smith

RE: List question

2001-06-05 Thread Peter Tilbrook
That comes back as: John,Michael,James Pat,Tony,Peter Smith,Affleck,Cousins) Well, I believe the answer to your question would be to set a var as follows: Unless I'm missing something here. By the way... I'm just curious. Why in the heck would you do this anyway? I mean wouldn't it make m

RE: List question

2001-06-05 Thread Garza, Jeff
Peter, I would treat each as a list and loop over each "memo" field within the loop creating the full name for inserting into the DB... This will break badly if any of the fields are blank! But on another note, why do you have it this way to begin with??? HTH. Jeff Garza Lead Developer

RE: List question

2001-06-05 Thread Mark Warrick
Well, I believe the answer to your question would be to set a var as follows: Unless I'm missing something here. By the way... I'm just curious. Why in the heck would you do this anyway? I mean wouldn't it make more sense to just split up the names into three fields? mark --

RE: List Question

2001-06-05 Thread Jann VanOver
Duane -- if you really don't have control over the input (ie you don't have the option to use tabs instead of commas), you may have to write the import code yourself. Read in one line, parse the line for strings inside double quotes, change the commas in those strings to some type of place holder

RE: List Question

2001-06-05 Thread Bryan Love
I have found that the tab character (char 9) works well and is difficult for a user to enter since the tab key moves a user across form fields. Bryan Love ACP Internet Application Developer [EMAIL PROTECTED]

RE: List Question

2001-06-05 Thread Paul Smith
Some guy named Alexander Graham something or other thot it up (running & ducking...;-) At 04:45 PM 6/5/01 -0400, you wrote: > > It is a real chore for a user to enter a "bell" sound... try > > the chr(07) delimiter? > > > > (blatantly stolen from Dave Watts lol) > >Don't worry - I'm pretty sure

RE: List Question

2001-06-05 Thread Dave Watts
> It is a real chore for a user to enter a "bell" sound... try > the chr(07) delimiter? > > (blatantly stolen from Dave Watts lol) Don't worry - I'm pretty sure I wasn't the first person to think it up. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202)

Re: List Question

2001-06-05 Thread Joseph Thompson
It is a real chore for a user to enter a "bell" sound... try the chr(07) delimiter? (blatantly stolen from Dave Watts lol) - Original Message - From: "Duane Boudreau" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 0

RE: List Question

2001-06-05 Thread Duane Boudreau
o: CF-Talk Subject: RE: List Question use a different delimiter than a comma... for example a semicolon or some other character that's not going to be used. HTH Hatton > -Original Message- > From: Duane Boudreau [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 05, 2001 3:

RE: List Question

2001-06-05 Thread C. Hatton Humphrey
use a different delimiter than a comma... for example a semicolon or some other character that's not going to be used. HTH Hatton > -Original Message- > From: Duane Boudreau [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 05, 2001 3:32 PM > To: CF-Talk > Subject: List Question > > > Hi

Re: List question?

2000-06-04 Thread Seth Petry-Johnson
> Hello all, > > When Posting to this list, is it necessary to paste this? > " > - -- > --- > > Archives: http://www.eGroups.com/list/cf-talk No, that part is added automatically to every email sent to the list. All you ne