NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: DonRidley on October 03, 2011, 02:14:53 PM

Title: Advanced searching - Anyone get this to work? Help please!
Post by: DonRidley on October 03, 2011, 02:14:53 PM

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

Title: Re: Advanced searching - Anyone get this to work? Help please!
Post by: DonRidley on October 03, 2011, 02:21:54 PM

Sorry...NetTalk 5.37

Title: Re: Advanced searching - Anyone get this to work? Help please!
Post by: DonRidley on October 04, 2011, 03:04:10 PM

Anyone?

Title: Re: Advanced searching - Anyone get this to work? Help please!
Post by: kevin plummer on October 04, 2011, 06:33:51 PM

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

Title: Re: Advanced searching - Anyone get this to work? Help please!
Post by: DonRidley on October 05, 2011, 02:18:42 AM

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

Title: Re: Advanced searching - Anyone get this to work? Help please!
Post by: DonRidley on October 05, 2011, 04:00:12 PM

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