I had to do the same. I just wanted to make sure since the extra cfset using the replace could add more overhead.
Thanks, - Charles On 3/30/05 11:19 AM, "Sam Farmer" <[EMAIL PROTECTED]> wrote: > I'll leave it to others to classify it as a bug or a feature. > > I get around it by doing this: > <cfset tmpWhere = ListAppend(tmpWhere,c,"~")> > and then when done with all my list appends: > <cset tmpWhere = replace(tmpWhere,"~"," AND ","all")> > > Cheers, > > Sam > > On Wed, 30 Mar 2005 11:07:53 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote: >> Hello, >> I have a strange question, I think. Can a delimiter be only one character? >> I'm trying to do a sql statement and I wanted to use ListAppend and specify >> the delimiter as "AND" >> >> Example ... >> >> <cfset tmpWhere = ListAppend(tmpWhere,c,"AND")> >> >> But when I view the list I only see "A" as the delimiter. >> >> Is this a bug or is this how it should be? >> >> Thanks, >> - Charles >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54