Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Problem displaying data retrieved from database.

Posted on 2003-04-01
Medium Priority
Last Modified: 2011-10-03
i have the following code that loops round until eof and displays records from a database:
the code works ok, but is put in to try and highlight my problem.


tog = 1
exe = "SELECT Customers.first_name, Customers.last_name, Customers.phone, Customers.email, Reservations.arrive_date, Reservations.depart_date, Reservations.confirmed, Rooms.room_name, Customers.customer_id "
exe = exe & "FROM Reservations, Customers, Rooms "
exe = exe & "WHERE Customers.customer_id = Reservations.customer_id "
exe = exe & "AND Reservations.room_id = Rooms.room_id "
exe = exe & "ORDER BY Reservations.arrive_date"
Set RS1 = Conn.Execute(exe)
do while Not RS1.EOF
     if tog = 1 then
          bgcolor = "white"
          tog = 0
          bgcolor = "#eeeeee"
          tog = 1
     end if

     <tr bgcolor="<%= bgcolor %>">
     <td width="10">
    <INPUT Type=CheckBox Name="customer_id" Value="<% = RS1("customer_id")%>">
     <font face="Arial" size="2" color="#000000">
     <a href=mailto:<%=RS1("email")%>><%=RS1("first_name")%></a>
     <font face="Arial" size="2" color="#000000">
     <%= RS1("last_name") %>

     <font face="Arial" size="2" color="#000000">
     <%= RS1("phone") %>
     <font face="Arial" size="2" color="#000000">
     <%= RS1("arrive_date") %>
     <font face="Arial" size="2" color="#000000">
     <%= RS1("depart_date") %>
     <font face="Arial" size="2" color="#000000">
     <%= RS1("room_name") %>
     <font face="Arial" size="2" color="#000000">
     <%= RS1("confirmed") %>


Set Conn = Nothing

what i am trying to do is insert a hyperlink on the first_name attribute of each record so that on click it opens an email window to that records email address.
i have achieved this to some extent but get the following in the To box:


what do i need to do to banish the #..# for good!
regards knolio67
Question by:knolio67
LVL 18

Accepted Solution

bonjour-aut earned 1000 total points
ID: 8246580
looks, like your Customers.email is a hyperlink (? or variant wich is interpreted as hyperlink) in the database

if you convert a hyperlink to string you get #www....#
maybe that your result is due to unwanted artificial intelligence

so try to ensure, that you get a string with

>>>>>>>>>    CStr(Customers.email)

could be, that you get #mick@knowles4680.freeserve.co.uk#

with a Mid$() you can get rid of the #'s
LVL 28

Expert Comment

ID: 8677368
No comment has been added lately (68 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to bonjour-aut http:#8246580

Please leave any comments here within 7 days.



EE Cleanup Volunteer
If you feel that your question was not properly addressed, or that none of the comments received were appropriate answers, please post a request in Community support (with a link to this page) to refund your points. http://www.experts-exchange.com/Community_Support/

Expert Comment

ID: 8755808
Per Recommendation

EE Moderator

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question