Filter not working

[broche]

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

[Vinnie]

Hi Brian

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

Should work

[DonRidley]

'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

[broche]

Thanks Vinnie - That worked.