NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: broche on October 05, 2018, 02:11:38 AM

Title: Filter not working
Post by: broche on October 05, 2018, 02:11:38 AM

CL 10
NT 10.35

Using a simple filter on a browse.

'Crs:GUIDStaff = ' &p_web.GSV('StaffID')

StaffID is set correctly on Login, checked with Debug++
The Crs:GUIDStaff is a view field
Filter fails
When I use
'Crs:GUIDStaff = <39>GGHYTDGRFSREFWRE<39>'
It Works - The letters are what is in the session field StaffID

Does it look OK?
Any Suggestions?

Brian

Title: Re: Filter not working
Post by: Vinnie on October 05, 2018, 02:18:58 AM

Hi Brian

Try
'Crs:GUIDStaff =<39>' &p_web.GSV('StaffID')&'<39>'

Should work

Title: Re: Filter not working
Post by: DonRidley on October 05, 2018, 04:38:15 AM

'Crs:GUIDStaff = ' & '''' & p_web.GSV('StaffID') & ''''

There's probably several ways to construct the filter string.

Actually, I think I have also seen something like:

'UPPER(CLIP(Crs:GUIDStaff)) = ' & '''' & UPPER(p_web.GSV('StaffID')) & ''''

Don

Title: Re: Filter not working
Post by: broche on October 06, 2018, 01:21:04 AM

Thanks Vinnie - That worked.