subject:"Apostrophe In SELECT"

Re: Apostrophe In SELECT

2001-10-24 Thread Patrik Wallstrom

On Wed, 24 Oct 2001, John Abel wrote: > Hi, > > I am having bother trying to perform a select, that has an apostrophe in > the value Im looking for. Below is the Perl code Im using. > > $SQLStatement = "SELECT ID FROM Albums WHERE Name = > '".$DBHandle->quote($Name)."';"; > $STLook

Apostrophe In SELECT

2001-10-24 Thread John Abel

Hi, I am having bother trying to perform a select, that has an apostrophe in the value Im looking for. Below is the Perl code Im using. $SQLStatement = "SELECT ID FROM Albums WHERE Name = '".$DBHandle->quote($Name)."';"; $STLookUpHandle=$DBHandle->prepare($SQLStatement);