[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-developers] Help with quotes in sql statements
|
From: |
Michael Dean |
|
Subject: |
Re: [Phpgroupware-developers] Help with quotes in sql statements |
|
Date: |
14 Nov 2002 19:54:58 -0600 |
You should not use the addslashes function to escape the strings.
Instead, use the db_addslashes method of the database object. Not all
SQL servers escape single quotes with backslashes.
On Thu, 2002-11-14 at 13:24, Brian Johnson wrote:
> I wondered where this message went to - I sent the email two days ago
>
> Anyway - I found the problem and fixed it using the addslashes function
> >Could someone help me with to change this sql statement from the addbook
> >module, it
> >has problems with names that include a single quote (like O'Sullivan)
> >
--
Michael Dean <address@hidden>