Joined Parameter help please 1

[butkus]

I would like to present my users with a name search parameter seeking their input as follows:
LNAME,FNAME

I would then like to parse their input and compair it to two different fields in the DB (LNAME and FNAME)

I've got an idea of how to start but don't know how to grab everything before and after the comman seperating the users input. Something like this I think;


if {db.lname}={?name}[1 to #before,] and
{db.fname}={?name}[#after, to last#] then true

I'm writing in CR8.5 dev edition, and pulling from an OLD FoxPro DB.

Any help would be great, thanks in advance.

James

 

[lbass]

Try:

trim(split({?name},",")[1]) = {db.lname} and
trim(split({?name},",")[2]) = {db.fname}

The problem might be ensuring that users enter a comma after the last name.

-LB

 

[butkus]

Works like a champ, thanks

James