Re: MySql select and insert

SELECT * FROM TBL_Pictre WHERE FLD_FileName = 'Duck.jpg' and FLD_Path = '/var/www/html/slidecollection/WinterCarnival' and the insert statement: INSERT INTO TBL_Picture VALUES ('Duck.jpg','/var/www/html/slidecollection/WinterCarnival','1958','some text','move text' I had a guy at work look at it and he thinks there is some unprintable character being stored onthe db. The keys I get from the system. I do a trim on the readsql statement to elimate anything that might be there. On Wed, 25 Apr 2001, olinux o wrote: > what is your SQL select statement ? > > olinux > > --- johndmiller <john@mn.mediaone.net> wrote: > > Ok here is my problem. I have this database and the > > key is comprised of > > two fields, filename and path to file. When I read > > based on this key, I > > get 0 records found. When I insert the same record, > > it will say that the > > key already exists.(which id does). Why can't MySql > > findthe record. > > > > Also when I log into MySql and type the search in > > manually, it doesnot > > find it, then when I put a wild card at the end of > > the path and use "like" > > MySql finds the record. The File name and Path are > > derived from the > > system so it is not atyping error. Any know what is > > up with it > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > >