after an insert... the inserted record can not be found... it's there,
I can see it but this query returns with zero records found.
The Details:
First:
INSERT INTO DocsList
(DocsList_ID,filename)
VALUES (746,'H:\UpLoadImages\CmosPic.jpg')
then sometime later we Check4Duplicate with:
SELECT *
FROM DocsList
WHERE FileName = 'H:\UpLoadImages\CmosPic.jpg'
This Retuns ZERO Records found.
but I can see the record plain as day in the database and in reports etc...
when I do it with simpler things like 'CmosPic.jpg' there are no problems
???
any clues will be very appreciated!
Gonz
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184923
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
