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
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,
>
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
