|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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? |
|
#2
|
||||
|
||||
|
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? |
|
#3
|
||||
|
||||
|
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 " " 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. |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > RecordSet listing problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|