a tricky question

2003-02-03 Thread Ernie Pena
 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




RE: a tricky question

2003-02-03 Thread Raymond Camden
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