ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreASP Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old September 10th, 2003, 09:15 PM
jsutta jsutta is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Aug 2003
Posts: 6 jsutta User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
RecordSet listing problem

<code>E-Mail: <a href="mailto:<%= cn_shr("EMail") %>" class="fontLinksDark"><%= cn_shr("EMail") %></a></code>

What the above code is supposed to do, obviously, is write a person's e-mail address out, and at the same time include that address in a hyperlink so that someone could e-mail that person. The problem is that it doesn't show up. There is no error code or anything- the output just does not show up. Any ideas?

Reply With Quote
  #2  
Old September 11th, 2003, 12:56 AM
fizzy's Avatar
fizzy fizzy is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2003
Location: Dublin, Ireland
Posts: 100 fizzy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 36 m 5 sec
Reputation Power: 6
sounds a bit odd!
have you tried looking at the html source to see the exact output?
when you say it doesn't show up do you just mean the email address or the entire line of code?
if just the e-mail address, it soundslike the variable cn_shr("email") is empty - are you sure it has a value?

Reply With Quote
  #3  
Old September 11th, 2003, 01:34 AM
OldJacques's Avatar
OldJacques OldJacques is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: in Orbit mostly
Posts: 148 OldJacques User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
One very useful tool I use to troubleshoot RecordSet and SQL problems (the most common problem for Recordset problems, after mispelled field names I would predict) is this "tutorial" which is actually a fantastic diagnostic tool in that it reads all the column names BY ITSELF thus eliminating user error as a possible cause.
If you feed it your SQL statement, preferably without the Condition (eliminating the WHERE part) you get a CAT scan of your query results and relative data.
I would guess that either there isn't data for the EMail column in the test set, or that the Query isn't returning the correct data (or not the data you are expecting, at least).

The only change I usually use for trouble shooting is substituting "-blank-" for "&nbsp;" for an empty, non-null string, so I realize that it is being fed a blank string (where I might not be expecting that...)

Last edited by OldJacques : September 11th, 2003 at 01:36 AM.

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreASP Programming > RecordSet listing problem


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway