Three Family Picture Tables

I have three tables.
Picture, Picture Group, and Picture description.

I have picture id, path and date in picture table.

I have Picture grpid, Group in picture group table.

I have Pic_descid and Description in the picture description table.

The question i have is where do i store the pictures? In the picture table i have the location and date. when i write a query for date i have to format the query, i have dummy data for path like c:\saru\img.gif1, 2, and 3.

where would i have the actual pictures.

I am thinking if i had the path in the db and would i have the thumb nails in a file on the web server?

Please help me. Thanks/Saru

Yes, the best way is to store the files on the webserver.

Thanks.

If i have a date as a field for date in my db, how would i query to get a formated date. Right now when i query i get 1996-01-10 00:00:00.000.

Thanks/Saru

How do you want the date to look?

Check out "Set DateFormat" and Convert() in Books Online.

i want the date to appear simple like 04/25/2005. Thanks

Convert(varchar, DateField, 101)

SELECT Path, Cvt([Date])
FROM Picture;

I tried like the above. I got an error.
DB am using is sql server 2000.

Thanks/Saru

What is CVT()? Never heard of it, and it's not what I suggested.


SELECT Path, Convert(varchar, [Date], 101)
FROM Picture



When posting that you got an error, please tell us what the error is.

Thank you very much.