Re: - escape strings?

Right now I am using an escape_string routine to take care of the bits
before they are put into the sql query.

http://asterisk.bkw.org/other/cdr_odbc.c

It seems to solve my problem ... i have been told thats about the best way
to do it.

bkw

On Sun, 7 Dec 2003, Nick Gorham wrote:

> Brian West wrote:
>
> > I have a field in the query for cdr_odbc that stores CLID and it can have
> > ' or \ or such in it.  Those murder the query when executed.
>
> \ should be ok in a string literal, but the may be a driver issue,
> something may be doing a sprintf, shouldn't be unixODBC what driver are
> you using.
>
> The SQL standard to escape a ' in a literal is another ' ie
>
> where a = 'this isn''t a invalid string'
>
> >
> > bkw
> >
> > On Sun, 7 Dec 2003, Nick Gorham wrote:
> >
> >
> >>Brian West wrote:
> >>
> >>>I have one questions... Does unixodbc have a way to escape non-sql safe
> >>>strings?
> >>>
> >>>bkw
> >>>
> >>>
> >>
> >>Not quite sure what you mean, the driver manager just passes the buffers
> >>through to the driver, can you gine a example of such a string ?
> >>
> >>--
> >>Nick
> >>
> >>In Faecorum Semper Solum Profundum Variat
> >>
> >
> >
> >
>
>
> --
> Nick
>
> In Faecorum Semper Solum Profundum Variat
>