ListFind & Find Not Working

[BradF]

Here's the cfoutput, notice how the last two are always 0 yet they should be returning non-0 values:

#VARIABLES.lstTraining# - #qryTraining.TNG_SYS_NR# - #ListFind(VARIABLES.lstTraining, qryTraining.TNG_SYS_NR)# - #Find(qryTraining.TNG_SYS_NR,VARIABLES.lstTraining)#<br/>

Here's the output:

0443,0559,0566,0708,0785 - 0443 - 0 - 0
0443,0559,0566,0708,0785 - 0443 - 0 - 0
0443,0559,0566,0708,0785 - 0443 - 0 - 0
0443,0559,0566,0708,0785 - 0443 - 0 - 0
0443,0559,0566,0708,0785 - 0443 - 0 - 0
0443,0559,0566,0708,0785 - 0443 - 0 - 0
0443,0559,0566,0708,0785 - 0443 - 0 - 0
0443,0559,0566,0708,0785 - 0443 - 0 - 0

Please help! I'm ready to jump out the window or throw my PC out, OR BOTH!

 

[philhege]

Try converting to a quoted value list. Your values aren't numeric.

HTH,

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[BradF]

Well, I thought that would work... Apparently not... Here's the code/output:

Code:

#VARIABLES.lstTraining# - #qryTraining.TNG_SYS_NR# - #ListFind(VARIABLES.lstTraining, qryTraining.TNG_SYS_NR)# - #Find(qryTraining.TNG_SYS_NR,VARIABLES.lstTraining)#<br/>

Output:

'0443','0559','0566','0708','0785' - 0443 - 0 - 0
'0443','0559','0566','0708','0785' - 0443 - 0 - 0
'0443','0559','0566','0708','0785' - 0443 - 0 - 0
'0443','0559','0566','0708','0785' - 0443 - 0 - 0
'0443','0559','0566','0708','0785' - 0443 - 0 - 0

 

[BradF]

Fixed by doing the following:

ListFind(VARIABLES.lstTraining, RTRIM(qryTraining.TNG_SYS_NR))

Even though the output of qryTraining.TNG_SYS_NR didn't show it (because of the whitespace ignore of HTML) it was a CHAR(6) value.