Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston suburb (Acton), Massachusetts, USA
    Posts
    109
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Images in a table that are 'specified' in a DB (2000)

    I am posting this as a second post because the subject is quite different

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Images in a table that are 'specified' in a DB (2000)

    Images as links, when entered manually, look more like this:

    [img]pic.jpg[/img]

    For just an image with no link, just use the tag in the middle.

    Are you trying to fill in part or all of this from the database? That might make it more complicated...

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston suburb (Acton), Massachusetts, USA
    Posts
    109
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Images in a table that are 'specified' in a DB (2000)

    Each DB record is info about one car - Year, Make, Model, Picture.
    The web page has a table with 4 columns - in column 4 I want to display a picture.

    I want to get this entry -
    [img]/pics/04Small.jpg[/img]
    to be loaded into the the cell from the DB which I expect will make that image display.

    What actually happens -
    The display in the cell looks exactly like the goal I list above, but the actual HMTL code does it's special magic with HTML characters and substitutes for quotes, greater than, less than. To wit, the code looks like -
    [img]/pics/04Small.jpg[/img]

    I am a real novice at this - I couldn't find any useful "help" - I tried enclosing the string in:

    double quotes - resulting in -
    '[img]/pics/01Small.jpg[/img]'

    single quotes - resulting in -
    "[img]/pics/02Small.jpg[/img]"

    double quotes outside single quotes - resulting in -
    [img]/pics/03Small.jpg[/img]

    I also tried single quotes outside double quotes, brackets (fancy & plain), question marks, pipes, exclamation points, etc.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Images in a table that are 'specified' in a DB (2000)

    Can I assume you are using FrontPage's database component? My help on databases seems to be missing, so I don't know what this option does, but maybe switching it from one setting to the other will help? To get this dialog, right-click the <<field placeholder>> and choose results column properties.
    Attached Images Attached Images

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston suburb (Acton), Massachusetts, USA
    Posts
    109
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Images in a table that are 'specified' in a DB (2000)

    "Field Placeholder" - egad - I am staggered by how awkward it was to find this option. You must be right." Unfortunately it didn't fix the problem - when ASP generates the HTML source for the page...

    <center>HTML tags (e.g., <) are still "translated" as though they were text (& L T ; <font color=red>[without the spaces]</font color=red>)</center>

    But I need to tweak more to be 100% sure and my host went down for the day. I shall let you know when I solve it, but I wanted to give you the courtesey of a reply - it's already been a couple days.

    BTW - I do have FP help installed, and I was not able to find anything pertinent. I searched for HTML + database (only hit was "forms") or + field.(only hit was DHTML to add action).

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Images in a table that are 'specified' in a DB (2000)

    I don't have a suitable database to experiment with this, unfortunately.

    You might be able to fall back on storing only the file path in Access, and adding the rest of the tag in FP:

    [img]<<DatabaseField>>[/img]

    I'm not sure you could enter this on the Normal tab; maybe on the HTML tab?

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston suburb (Acton), Massachusetts, USA
    Posts
    109
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Images in a table that are 'specified' in a DB (2000)

    <font face="Comic Sans MS"><big>Finally!</big></font face=comic>
    I found this while pursuing my problem getting the DB site to publish.
    1. <LI>delete the tag in the cell of the table where the image will appear (the cell will now be blank)
      <LI>insert any image into the cell (I used one of the JPG's referenced by the DB)
      <LI>Modify "Picture Properties" (which will show the path to the image)
      <LI>"General", "Browse", "Parameters", "Delete" to remove the existing "path"
      <LI>Insert Field Parameter" and select the label for the tag (e.g., <<carpic>>)
      <LI>Git-outta-there....
    <font face="Comic Sans MS"><big><center>Sure doesn't seem very intuitive to me!</center></big></font face=comic>
    Now "Picture Properties" will show "<%=FP_FieldLink(fp_rs,"carpic")%>"

    And when you publish will show the image(s) in the table.

    BTW - the DB cell entry needs to be "text" and would contain something like this (assuming storage in folder "images") -
    <hr><center>/images/car01.jpg</center> <hr>
    Good luck to anyone else, and THANKS to everyone who tried to help me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •