getting close to giving up on ASP...getting null values from good data

wvmikep · Mar 2, 2001

I've got the following code....it returns null values for many of the columns in the query only ifI leave the IF and SELECT in the DO WHILE loop. If I take them out, things SEEM to work. However, that doesn't help.

There's nothing wrong with the db because I wrote a version in ColdFusion and it works perfectly.

<%@ Language = VBSCRIPT %>
<% Option Explicit %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
<title>Untitled</title>

</head>

<body bgcolor="#CFB89F" leftmargin="0" topmargin="0">

<%
Dim objConnTP
Set objConnTP = Server.CreateObject("ADODB.Connection&quot

objConnTP.ConnectionString = "Provider=MSDASQL;DSN=techies;UID=deleted;password=deleted;"
objConnTP.Open

Dim strSQL
strSQL = "SELECT TOP 6 ID, art_title, art_content, art_subject, art_page, art_next_page, art_macpc, art_author from thearticles WHERE art_parent = 0"

Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset&quot

'objRS.MaxRecords = 6
objRS.Open strSQL, objConnTP

Dim strSubject, strMacPC, strLabel

Do While Not objRS.EOF
If (objRS("art_macpc&quot

= 1) then
strMacPC = "In PC "
strLabel = "pc"
Elseif (objRS("art_macpc&quot

= 2) then
strMacPC = "In Mac "
strLabel = "mac"
Else
strMacPC = "In PC/Mac "
strLabel = "pcmac"
End If

Select Case objRS("art_subject&quot

Case 1
strSubject = "Hardware"
strLabel = strLabel & "hardware.png"
Case 2
strSubject = "Apps"
strLabel = strLabel & "apps.png"
Case 3
strSubject = "Games"
strLabel = strLabel & "games.png"
Case 4
strSubject = "In ASP Development"
strMacPC = ""
strLabel = strLabel & "asp.png"
Case Else
strSubject = "In ColdFusion Development"
strMacPC = ""
strLabel = strLabel & "cf.png"
End Select
%><br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tr>
<td colspan="3" width="400"><a href="subject.asp?subject=<%= objRS("art_subject&quot

%>&macpc=<%= objRS("art_macpc&quot

%>"><img src="images/label_<%= strLabel %>" width=175 height=20 alt="Latest Article" border="0"></a></td>
</tr>
<tr>
<td colspan="3" width="400" bgcolor="#60000F"><img src="images/blank.gif" width=1 height=1 alt="" border="0"></td>
</tr>
<tr>
<td width="1" bgcolor="#60000F"><img src="images/blank.gif" width=1 height=1 alt="" border="0"></td>
<td width="398"><table><tr><td><font class="basictext">
<%
Response.Write "<a href='article.asp?id=" & objRS("ID&quot

& "&page=" & objRS("art_page&quot

&"'><b>" & objRS("art_title&quot

& "</b></a><br>"
Response.Write objRS("art_content&quot

& "<br>"
%>
</font></td></tr></table></td>
<td width="1" bgcolor="#60000F"><img src="images/blank.gif" width=1 height=1 alt="" border="0"></td>
</tr>
<tr>
<td colspan="3" width="400" bgcolor="#60000F"><img src="images/blank.gif" width=1 height=1 alt="" border="0"></td>
</tr>
</table>
<%

objRS.MoveNext
Loop

objRS.Close
Set objRS = Nothing
objConnTP.Close
Set objConnTP = Nothing

%>
<br>


</body>
</html>
------------------------------------
"Unclean beast! Get thee down! Be thou consumed by the fires that made thee!" - Brother Jacobus in Dragonslayer

hblackorby · Mar 2, 2001

I'm not to familiar with SQL, but I'm not sure how the SELECT TOP 6 works with an ASP recordset. Try it without and just run through the recordset six times. Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

wvmikep · Mar 3, 2001

Tried that. Same result. ------------------------------------
"Unclean beast! Get thee down! Be thou consumed by the fires that made thee!" - Brother Jacobus in Dragonslayer

Pandyon · Mar 3, 2001

I've had a similar problem on a few projects. I found the problem to be somewhere in my hyperlink tags when I placed so many variables to be posted to the submitting page.

Check here:
Response.Write "<a href='article.asp?id=" & objRS("ID&quot

& "&page=" & objRS("art_page&quot

&"'><b>" & objRS("art_title&quot

& "</b></a><br>"
Response.Write objRS("art_content&quot

& "<br>"

Are you sure this coding is correct? I found some slight alterations necessary in coding the href="x" using Response.Write.

A suggestion I'll pass on, given to me by other programmers much more experienced than I am concerning your design: Only place an id tag in the hyperlink, then on the submitted page, requery the database seeking the information for only that record using the single passed variable. I've been told that is a faster way than passing multiple variables.

Mark

wvmikep · Mar 3, 2001

Funny thing is, the oddities occur before the links are built. ------------------------------------
"Unclean beast! Get thee down! Be thou consumed by the fires that made thee!" - Brother Jacobus in Dragonslayer

Ovatvvon · Mar 3, 2001

is there a zero (0) located in "art_parent" in the table? if there is no zero and your query is looking for that, it would have to values match where art_parent = 0, therefore would not enter anything for strMacPC, or strLabel.

Also, try trouble shooting it a little more. Is it BOTH the if-else AND the SELECT statement, or is it only the if-else, or only the select statement variables that are null?

put a response.write statement after each writing the variables to the page to see if they come up after each individual section. I don't have your db, and I don't have your page setup here, but you need to look at it more logically and debug it. piece by piece. There's nothing wrong with ASP code. If there were, do you think it would be so widely used? It's not ASP, it's your code...so don't be so willing to give up on it. What you're actually doing is giving up on yourself.

Ovatvvon

wvmikep · Mar 4, 2001

It works if I get rid of both the IF-ELSE and the SELECT. There's nothing wrong with either the SQL or the data as I wrote a version, using the same logic, in ColdFusion and it worked perfectly. ------------------------------------
"Unclean beast! Get thee down! Be thou consumed by the fires that made thee!" - Brother Jacobus in Dragonslayer

Ovatvvon · Mar 4, 2001

Did you try to debug it yet? use a response.write below each to write the values of the variables before going to another page...see if they are even set there

wvmikep · Mar 8, 2001

Yeah, that's how I found that removing the IF and the SELECT removed the symptoms. With them in, even having the response.write above the if and select gave me nulls. ------------------------------------
"Unclean beast! Get thee down! Be thou consumed by the fires that made thee!" - Brother Jacobus in Dragonslayer

Ovatvvon · Mar 8, 2001

don't put the response.write ABOVE the statement...of course it'll be null...put it below after it's selected the input for the variables.

wvmikep · Mar 9, 2001

no, no, no.....it's above the IF and SELECT, but in the DO WHILE...LOOP, which is after the SQL statement is executed. ------------------------------------
"Unclean beast! Get thee down! Be thou consumed by the fires that made thee!" - Brother Jacobus in Dragonslayer

Ovatvvon · Mar 10, 2001

Hey,
I will just have to see it to totally understand. Are you willing to email me a copy of your page and database?
Jim
jimbob550@hotmail.com

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

getting close to giving up on ASP...getting null values from good data

wvmikep

Programmer

hblackorby

Programmer

wvmikep

Programmer

Pandyon

Programmer

wvmikep

Programmer

Ovatvvon

Programmer

wvmikep

Programmer

Ovatvvon

Programmer

wvmikep

Programmer

Ovatvvon

Programmer

wvmikep

Programmer

Ovatvvon

Programmer

Similar threads

Part and Inventory Search

Sponsor