NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: terryd on November 05, 2014, 10:55:38 PM

Title: Problem with Apostrophe in browse link field
Post by: terryd on November 05, 2014, 10:55:38 PM

If I have a parent where the field used to restrict a child browse contains an apostrophe then the child browse displays no records. It has nothing to do with unique field identifier just a specuial
For example in the 3 filters below filter 3 doesn't work because of the apostrophe, obviously because the filter value becomes
 'BS3357 ST BENEDICT'

[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BS3358 ST JOSEPHS SCHOOL - FOURIESBURG'
[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BC3051 CRAVEN JAMES ROOS'
[2816] [st] [netTalk][thread=3] filter:FOL:Reference = 'BS3357 ST BENEDICT'S SCHOOL - LADYBRAND'

Is there any way short of telling the client to pull out any apostrophe from his field that I can get around this issue

Title: Re: Problem with Apostrophe in browse link field
Post by: kevin plummer on November 05, 2014, 11:21:20 PM

Try using Quote() in your filter. Ref to clarion docs if unfamiliar.

Title: Re: Problem with Apostrophe in browse link field
Post by: terryd on November 05, 2014, 11:40:26 PM

Thanks Kevin. That works