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]

Reply via email to