if a file exist on the web server type "Yes"... How?
Dear Experts,
I am developing a web site... An in a folder there are more than 100.000 product image files (jpeg) (So I cant use LOAD fonction... I dont want to bussy server )
I am conneting to SQL and Loading ; imagepath field....
sample data is : /products/images/x.jpg
I can see the rear of this image in qlikview : =('http://www.test.com'&left(imagepath,3)&'_r.jpg')
MY PROBLEM :
time to time I live a problem : Product and its information is on the web but it hasnt any jpeg files. So it isnt good. I want to find products without image file. then I can sent the jpeg files using ftp...
My Stock Code also xxx (same as jpeg file name)
So I want to check filesize or file name on the web but I didnt do.