Forums
This topic is locked
Adding images into datas
Posted 20 Sep 2001 12:00:48
1
has voted
20 Sep 2001 12:00:48 Ahmad Fariz Hanapiah posted:
Is there anyway todo that?Replies
Replied 20 Sep 2001 12:26:44
20 Sep 2001 12:26:44 Owen Eastwick replied:
Do you mean storing images in a database?
In Access and SQL server you cannot store an image directly within a databae. What you do is store your images in a specific directory within your site structure, then store the image path within a database field:
For example:
D:\html\mysite\Images\MyImage.gif
To display the image on the page.
Add a recordset to the page including all the fields you want along with the image path field in your database table.
Click on the web page to place the cursor where you wish the image to be placed.
Click on the image Icon in the Objects palette as you would for an ordinary image.
When the Select Image Source dialogue box opens click the Data Sources radio button at the top. This will show you the recordset as it appears in the Data Bindings window. Highlight the Image Path field in your recordset and click OK. You should now see an Image Place Holder on your page with lightning bolt on it.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
In Access and SQL server you cannot store an image directly within a databae. What you do is store your images in a specific directory within your site structure, then store the image path within a database field:
For example:
D:\html\mysite\Images\MyImage.gif
To display the image on the page.
Add a recordset to the page including all the fields you want along with the image path field in your database table.
Click on the web page to place the cursor where you wish the image to be placed.
Click on the image Icon in the Objects palette as you would for an ordinary image.
When the Select Image Source dialogue box opens click the Data Sources radio button at the top. This will show you the recordset as it appears in the Data Bindings window. Highlight the Image Path field in your recordset and click OK. You should now see an Image Place Holder on your page with lightning bolt on it.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo