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 <[EMAIL PROTECTED]> 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/
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]