Re: [SQL] Why doesn't this work

On 01/15/2013 04:50 AM, Barbara Woolums wrote: I am running a query like so SELECT id FROM image WHERE image='demo-harvey wallbanger.jpg' It returns nothing My table looks like this "demo-820.jpg";1 "demo-lemon-mousse-1.jpg";2 "demo-pumpkinchaibars.jpg";3 "demo-Lolly-Shop.jpg";4 "demo-scan000

Re: [SQL] Why doesn't this work

Tirsdag 15. januar 2013 12.50.00 skrev Barbara Woolums : > I am running a query like so > > SELECT id FROM image WHERE image='demo-harvey wallbanger.jpg' > > It returns nothing > > My table looks like this > > "demo-820.jpg";1 > "demo-lemon-mousse-1.jpg";2 > "demo-pumpkinchaibars.jpg";3 > "dem

Re: [SQL] Why doesn't this work

Hi Barbara, from what I see in your msg, you have a /cr at the end of the filename. You should check for weird stuff and trim it away (before insert triggers do wonders at this). Cheers Bèrto On 15 January 2013 11:50, Barbara Woolums wrote: > I am running a query like so > > SELECT id FROM imag

[SQL] Why doesn't this work

I am running a query like so SELECT id FROM image WHERE image='demo-harvey wallbanger.jpg' It returns nothing My table looks like this "demo-820.jpg";1 "demo-lemon-mousse-1.jpg";2 "demo-pumpkinchaibars.jpg";3 "demo-Lolly-Shop.jpg";4 "demo-scan0001.jpg";5 "demo-cherry-chocolate-mousse-pie.jpg";6