Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Storing Images

Author  Topic 

aturner
Starting Member

29 Posts

Posted - 2004-08-02 : 10:52:26
I have two tables called Employee and Location. I need the ability to store photos in the database that displays in my web application with information pulled from the Location table.

My Location table includes:

PRID
PRTitle
PRDate
PRLocation
PRRegOwner
PRLeaseOwner
PRDetails
EmpID
PREntryDate

The employee table has basic information, i.e., EmpID, EmpFName, EmpLName, EmpPwd, etc.. Can I insert the photos within the Location table using DataType (image) or should I create a second table and reference it to the PRID field? The photos have to tie in with the specific PRID field.

JasonGoff
Posting Yak Master

158 Posts

Posted - 2004-08-02 : 11:14:56
See reply at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38153 and please don't cross-post !
Go to Top of Page
   

- Advertisement -