Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2003
    Posts
    32

    Question Unanswered: DB table Question

    I have yet another question. I have a form which members fill out to be
    added to our team. In the table that displays the DB, it shows the email
    address in the correct cell. What I want to do, is have it display a little
    envelope that has the email addey contained within. Thus making the column smaller. I use FP 2002 if that helps. Can anyone give this a shot for me?
    Bam

  2. #2
    Join Date
    Feb 2003
    Location
    USA
    Posts
    18
    Do you mean use an image for the email address field? If yes then you try this
    <a href="mailto:<%=objRS("Email")%>"><img src="images/envelope.gif"></a>

  3. #3
    Join Date
    Jan 2003
    Posts
    32
    Ok. But how do I get that into the DB or the form itself, so it shows up each time someone fills out the form?
    Bam

  4. #4
    Join Date
    Feb 2003
    Location
    USA
    Posts
    18
    I didnt understand your question.
    What do u mean by
    <<In the table that displays the DB, <<

    are you talking about displaying the " a little
    envelope that has the email addey contained within. " on your webpage?

    In your DB you need to have an email field with the email address that should be enough for the line of code I posted earlier.

  5. #5
    Join Date
    Mar 2003
    Posts
    8
    Umm...you should be able to copy exactly what farzinm wrote but replace <%=objRS("Email")%>"> with the name of your email field in your DB.

  6. #6
    Join Date
    Jan 2003
    Posts
    32
    Please Excuse my ignorance. This is the line I have that is contained in the cell that has the email info. It was created with FP as I have stated earlier. I am still confused where that line will be placed.

    <!--webbot bot="DatabaseResultColumn" s-columnnames="ID,T1,T2,icq,T4,country,version,T5,Re mote_computer_name,User_name,Browser_type,Timestam p,gig_name,email,msn,real_name" s-column="email" b-tableformat="TRUE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;email&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_Field(fp_rs,"email")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11866" -->

    Bam

  7. #7
    Join Date
    Feb 2003
    Location
    USA
    Posts
    18
    I am not really aware with FP but you can try this

    <!--webbot bot="DatabaseResultColumn" s-columnnames=" ID,T1,T2,icq,T4,country,version,T5,Remote_computer
    _name,User_name,Browser_type,Timestamp,gig_name,em
    ail,msn,real_name" s-column="email" b-tableformat="TRUE" b-hashtml="TRUE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size="-1"&gt;&lt;&lt;&lt;/font&gt;email&lt;font size="-1"&gt;&gt;&gt;&lt;/font&gt;" startspan -->
    <a href="mailto:<%=FP_Field(fp_rs,"email")%>"><img src="images/envelope.gif"></a>
    <!--webbot bot="DatabaseResultColumn" endspan i-checksum="11866" -->

    Note: replace
    <%=FP_Field(fp_rs,"email")%> with
    <a href="mailto:<%=FP_Field(fp_rs,"email")%>"><img src="images/envelope.gif"></a>

    Good Luck!
    Last edited by farzinm; 03-25-03 at 20:04.

Posting Permissions

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