| photos are stored as .jpg files [message #76501] |
Mon, 30 September 2002 05:43  |
Luda James
Messages: 12
Registered: August 2002
|
Junior Member |
|
|
My Web-based pl/sql appl-n retrieves an information of our users from Oracle DB. I have to show this inform along with user's photo. The user photos are stored as .jpg files on another server. Not every user has the photo. I just specify img src=http..../user_id.jpg where user_id input parameter.
And I need to know if we have certain user photo in advance because I can get empty space instead of image.
How can I find it out.
Thanks.
|
|
|
|
| Re: photos are stored as .jpg files [message #76511 is a reply to message #76501] |
Fri, 04 October 2002 16:42  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
Testing for the file's existence at runtime is going to complicate your coding and I guess could slow things down. I would tag a column onto the user table like image_exists_yn varchar2(1) and then update that. Assuming you are on Unix, just do a ls -ltr on the image directory and use that as a basis for generating an update statement to set image_exists_yn to 'Y' or 'N'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
