sql select

[sparky68]

I’m trying to pick a different sql line when a querystring exists or not…heres the code:

if request.querystring(&quot;ID&quot <> &quot;&quot; then
recordtoview = request.querystring(&quot;ID&quot
strsql = &quot;SELECT * from news ORDER BY news.newsDate where news.newsid =&quot; & recordtoview & &quot;;&quot; else
strsql = &quot;SELECT * from news ORDER BY news.newsDate DESC&quot;
end if

the first time you goto to page it should use the else part, since “id” doesn’t exist. If you click a different article it adds id to url and reloads page. Eventhou the url is right, it still shows the else part…

 

[snowboardr]

Try this:

If NOT request.querystring("ID") "" then
    recordtoview = request.querystring("ID")
 strsql = "SELECT * from news ORDER BY news.newsDate where news.newsid =" & recordtoview & ";" 
else
    strsql = "SELECT * from news ORDER BY news.newsDate DESC"

End if

Try &quot;NOT&quot; instead of <> also...do you have your excute statement in the code as well?

 

[snowboardr]

Try this:

If NOT request.querystring("ID") "" then
    recordtoview = request.querystring("ID")
 strsql = "SELECT * from news ORDER BY news.newsDate where news.newsid =" & recordtoview & ";" 
else
    strsql = "SELECT * from news ORDER BY news.newsDate DESC"

End if

Try &quot;NOT&quot; instead of <> also...do you have your excute statement in the code as well?

 

[snowboardr]

That is weird, I got an error when I submitted it...saying it took to long to submit the reply...then it ended up posting it twice? ... I know I only clicked once on that button.. hmm