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