CF list funcs ignore null entries. You can look for these yourself and replace them - ie, change || to |null|, you just have to make sure null isn't a valid value. (Or use chr(0), again though, ensure chr(0) isn't valid.)
======================================================================= Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Ernie Pena [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 10:26 AM > To: CF-Talk > Subject: a tricky question > > > I'm parsing through a list of values to be imported into a > database. I'm using the ListGetAt() function and searching > for pipes (chr(124)). Everything is working fine until it > comes to two pipes next to each other without spaces or > characters between them. When that happens, CF seems to view > both pipes as one and skips over that position in the list. > The effect is, the values after the double pipe are all one > position off. > > Thanks in advanced > > Ernie Pena > M. D. Anderson Cancer Center > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4