If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > DB table Question

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-25-03, 16:18
bambamn007 bambamn007 is offline
Registered User
 
Join Date: Jan 2003
Posts: 32
Question 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
Reply With Quote
  #2 (permalink)  
Old 03-25-03, 16:32
farzinm farzinm is offline
Registered User
 
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>
Reply With Quote
  #3 (permalink)  
Old 03-25-03, 16:43
bambamn007 bambamn007 is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 03-25-03, 16:59
farzinm farzinm is offline
Registered User
 
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.
Reply With Quote
  #5 (permalink)  
Old 03-25-03, 16:59
Cobbyness Cobbyness is offline
Registered User
 
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.
Reply With Quote
  #6 (permalink)  
Old 03-25-03, 18:45
bambamn007 bambamn007 is offline
Registered User
 
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
Reply With Quote
  #7 (permalink)  
Old 03-25-03, 18:59
farzinm farzinm is offline
Registered User
 
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 19:04.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On