Help with simple conditional?
Fairlight
fairlite at fairlite.com
Wed Aug 15 17:53:16 PDT 2012
Someone told me 'co' may not work in processing. Okay, so I tried a
different method that should work:
I've tried putting both the lookup value and the search value into ALLUP
variables and checking for INSTR eq "0".
If: instr(SinUp,SinSearch) eq "0"
Then: getnext sintest;goto loop
If I use that, and that -should- mean that the substring was not found, get
the next record and loop...it fails to work properly. If I flip it to
"ne", it always passes, if I leave it as "eq", it always fails. It should
succeed when there's a match, and it doesn't.
I've tried logging the values of SinUp, SinSearch, and INRes (INRes being
the result of an instr(SinUp,SinSearch). Here's what I get:
sinup: 35000 (SINGLE MIX) searchup: DARK inres: 0
sinup: 35000 (SKYHIGH MIX) searchup: DARK inres: 0
sinup: BEFORE THE DAWN searchup: DARK inres: 0
sinup: BITTERSWEET MEMORY searchup: DARK inres: 0
sinup: BRING THE DARK (DARKDANCE MIX) searchup: DARK inres: 0
sinup: BRING THE DARK (SINGLE MIX) searchup: DARK inres: 0
sinup: CRACKHEAD KITTY searchup: DARK inres: 0
sinup: CRACKHEAD KITTY (CATNIP MIX) searchup: DARK inres: 0
sinup: DEMONS EVERY DAY (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: DESPAIR (SINGLE MIX) searchup: DARK inres: 0
sinup: FALLING INTO YOU (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: FOUR AM (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: FUGUE STATE (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: INTERLUDE 1 searchup: DARK inres: 0
sinup: INTERLUDE 2 searchup: DARK inres: 0
sinup: LYA (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: MISCHIEF AND MAYHEM (SINGLE MIX) searchup: DARK inres: 0
sinup: NEON (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: OWN THE NIGHT (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: REGRETS (SINGLE MIX) searchup: DARK inres: 0
sinup: RELAXING MEADOW searchup: DARK inres: 0
sinup: SEASIDE CAVE searchup: DARK inres: 0
sinup: SKYHIGH INTERLUDE searchup: DARK inres: 0
sinup: SOLITARY ORBIT (SINGLE MIX) searchup: DARK inres: 0
sinup: SUNRISE (FAIRLIGHT MIX) searchup: DARK inres: 0
sinup: SUNRISE (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: TWILIGHT (FAIRLIGHT MIX) searchup: DARK inres: 0
sinup: TWILIGHT (INSTRUMENTAL MIX) searchup: DARK inres: 0
sinup: VACATIANUS TROPICALUS (SINGLE MIX) searchup: DARK inres: 0
sinup: WEEKENDER (SINGLE MIX) searchup: DARK inres: 0
Okay, please explain to me how "BRING THE DARK" (both mixes) fail to
trigger a substring match against "DARK". Hell, one has the word in it
-twice-. Both 'co' and 'instr()' are acting improperly. Both fields
involved are now ALLUP, and it's just flat-out failing.
This makes less and less sense. It makes even less sense when you realise
that I have 'instr()' working in a table called from this one. It's not
like I've never used instr() before... So I know instr() works on these
binaries in general. But what's going on with these comparisons?
mark->
--
Audio panton, cogito singularis.
More information about the Filepro-list
mailing list