NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: David on February 16, 2015, 05:53:27 PM

Title: Browse Filter - getting the table record ID field
Post by: David on February 16, 2015, 05:53:27 PM

I have a browse on a department table and I want to filter based on the DEP:RecordID field.  In the template filter field I have tried DEP:RecordID and p_web.GSV('DEP:RecordID') both return blank data.  I have looked at the actual table and the DEP:RecordID field has data in it.

How do I get the data in that field?

Thank you,
David

Title: Re: Browse Filter - getting the table record ID field
Post by: terryd on February 16, 2015, 08:08:36 PM

HI David
 try

'DEP:RecordID = ' & p_web.GSV('DEP:RecordID')

if DEP:recordID is numeric or

'DEP:RecordID = <39>' & p_web.GSV('DEP:RecordID') & '<39>'

If it is a string

[Edited to make it a bit easier to read - Bruce]