Advanced searching - Anyone get this to work? Help please!

[DonRidley]

http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=21.0

Anyone get this to work and/or have an example app I could take a look at?  I simply cannot get my brain wrapped around it..

Thanks,

Don

[DonRidley]

Sorry...NetTalk 5.37

[DonRidley]

Anyone?

[kevin plummer]

Hi Don,

I'm not sure which part you had trouble with as it is a pretty extensive article and a lot has changed under the hood of NTW.

I think the easiest approach is to start simple and slowly build up your page making sure it works at each stage.

1) create a browse on a form
2) add p_web.gsv('L:myFilter') to the browse filter template prompt
3) add 1 field to the form eg L:sort1
4) tick send value to server + add browse to refresh
5) In the server embed add your filter to the SSV eg p_web.SSV('L:MyFilter','Cus:Name = <39>' & L:sort1 & '<39>' !may need to wrap in ASCII single quotes <39>

HTH's

[DonRidley]

Hey Kevin,

Thank you for responding.  I have tried pretty much exactly what you described.  I think my issue is the building of the filter string.  Thanks for confirming that I'm on the right track.

Don

[DonRidley]

Hey Kevin,

Thanks to you, I got it working.  I had to modify your code slightly.  Example:

p_web.SSV('LOC:Filter','PER:PermitNo = <39>' & p_web.GSV('LOC:PermitNo') & '<39>')

Notice the GSV on the search field. 

Thanks for taking the time to help me out!

I appreciate it greatly!

Don