field contains other field value

[DoctorGonzo]

HI guys,

Can anyone tell me how to look for a field value within another field?

I want to check if a field value is already contained within a multivalie field.

Any help much appreciated

Gonzo

 

[tsuji]

>...within a multivalie field.
For instance?

 

[BillyRayPreachersSon]

What is a multivalue field? Do you mean a select box with the multiple attribute? Or do you mean a text field which happens to have data in it that you have formatted to be able to delimit values... or something else entirely?

Dan


[tt]D'ya think I got where I am today because I dress like Peter Pan here?[/tt]

 

[DoctorGonzo]

Hi guys,

here uis the field (called CrewIDs) when I do VIEW SOURCE

<INPUT NAME="CrewIDs" TYPE=hidden VALUE="7878; 1414">

I have another fiedls called CREW.. I want to write a function that checks if CREW is inside CrewIDs - say for example if I type "7878" into CREW, it will return TRUE (because "7878" id onf of the values in CrewIDs)

hope this helps

 

[BillyRayPreachersSon]

So you really want to test for the presence of a substring within a string. The "multivalue" field you talk about is a simple text field that (as I guessed) you have chosen to store delimited text in.

You can do this with the "indexOf" method of the String object. It returns -1 if the substring is not found, the starting position (0-based) otherwise:

var somePos = stringToSearch.indexOf('stringToFind');

Hope this helps,
Dan

[tt]D'ya think I got where I am today because I dress like Peter Pan here?[/tt]

 

[DoctorGonzo]

Brilliant Dan - works perfectly!

Many thanks

Gonzo