Remote web server - 8. Add a second field named PhotoCaption, and
8. Add a second field named PhotoCaption, and set its Data Type to varchar( 50). 9. Add a third field named PhotoURL and set its Data Type to varchar( 64). Figure 11-35 shows the final structure of the table. When defining a field that stores any kind of URL or address, use either varchar or nvarchar. Using char or nchar will pad short addresses with blank spaces, which in turn may prevent the link from working properly later when used on a page. 10. Click the Close (X) button in the upper-right corner of the Design surface. 11. Choose Yes when asked about saving your changes. 12. Change the name of the table to Photos, then click OK. Now you have a new table, named Photos, in the database. Each record in the table can contain a photo caption and the link to a photo. If you already have your pictures in a folder, you can right-click the table and choose Show Table Data. Because PhotoID is an automatically-numbered field, you want to leave it as Null when entering new records. Just type a caption name and a link to a picture in the PhotoCaption and PhotoURL fields. Then type a caption and link for each photo. For my example, where each photo is a picture of a flower, I put a (fake) Latin name for each photo into the PhotoCaption field, and a link to each photo in the PhotoURL field. (I don t know the actual Latin names for the flowers, so I just made some up, borrowing a few names from animal anatomy.) Figure 11-36 shows an example. I ve opened Solution Explorer in that figure so you can see how the PhotoURL in each record refers to a specific image in the ~/Images/FlowerPix folder. Figure 11-35: Completed Photos table design. 256 Part III: Personalization and Databases
We recommend high quality webhost to host and run your jsp application: christian web host services.