addslashes

Kenneth Brody kenbrody at spamcop.net
Thu Aug 26 08:20:29 PDT 2010


On 8/25/2010 4:39 PM, richard wrote:
> I have a need to create some sql queries using filepro.
>
> My problem is that some of my text includes apostrophes and other chars.
> that "break" the query.
>
> In php there is a command called "addslashes".
>
> Is there a simple way in filepro to turn "Robert's golf clubs" into
> "Robert\'s golf clubs"?

If all you want to do is just make sure that any apostrophe is preceded by a 
backslash, why not use an edit to add them if necessary?  (Why don't people 
start with "gee, can this be done with an edit"?)

     { ({!" "!}@) | (<\>"'") | * }

-- 
Kenneth Brody


More information about the Filepro-list mailing list