QueryString

[fran7]

Hi, Trying to solve a problem with no knowledge of asp.

I have a dropdown list populated from my database with card decription. The output is names like, abstract,illust ration etc.

I am sending the results to another page like so

.. html
directory.asp?PostCardID=XX
 

..
Now the request.queryst ring I presume should be something like this.

..asp
<%=request.QueryString("PostcardID")%>
 

..
But all I get is xx as output.
When someone selects from the dropdown I am trying to populate the page with all those from the database who have the same title and so am trying to get the ids.

Is there something more to this, I am sure there is.
Thanks in advance for any help.

Basically I was told I had to get the get the PostCardID into the action querystring
Richard

[jhardman]

Richard,

Wait, let's see if I understand. There is one dropdown list that allows the user to select a category of postcard. You have this selection submitted to a second page where you want to display a dropdown list of all of the cards in that category. Please confirm that this is right.

I'm still not sure what part is giving you trouble. You got the first page to give you a dropdown list, right? Are you still not getting the second page to give you a list of the cards in that category?

Jared

[fran7]

Dear Jared, thanks for the reply. Not quite right.
I have a dropdown on one page populated with the carddescription s from the database. I want to send the submitted selection to the next page to display in the table like other links display, not in another dropdown list. At the moment if you select abstract, what displays on the next page is simply the word abstract and not the sites that are listed in my database under that carddescription .

I need carddescription in the dropdown as they are the headings like abstract etc and I was led to believe that I needed to send the id to the next page to display the relevant sites.

So basically I need to send the id relevant to the selection, but when I tried that
with asp?cardID=xx, I just got xx appearing in the next page.

I dont know if that helps you to understand. I am stabbing in the dark trying to figure this out. basically if you visited wotartist .com you would see what I need to appear.

Thanks
Richard

[jhardman]

I have a dropdown on one page populated with the carddescription s from the database. I want to send the submitted selection to the next page to display in the table like other links display, not in another dropdown list. At the moment if you select abstract, what displays on the next page is simply the word abstract and not the sites that are listed in my database under that carddescription .

OK, not a big difference, I think I get you. maybe. The first page gets categories in a drop down select and the second displays a table with links to each of the art in that category. It looks like you have a good start, though. The first page already gives you a list of categories and the second page checks to make sure it was sent data (the response.write request.queryst ring line only checks to see if data was sent). The second page also opens the database, as I looked over the code. Does it not display anything from the database, or is it displaying stuff from the db that you didn't select? I couldn't tell. It looks to me like when the second page opens the db you want it to say this:

strSQL = "SELECT * FROM tblGreetingPostCards WHERE CardDescription = '" & request.querystring("PostCardID") & "' ORDER BY Rnd([PostCardID])"
    oRs.Open strSQL, conn 'this opens everything from the db that has 
       'CardDescription = the data sent from the first page.  Then you need to put 
       'each link you get into a table
 
      response.write "<table><tr>"
      dim x
 
      x = 0
 
    Do while not oRs.EOF
        x = x + 1
        if x = 5 then
           response.write "</tr><tr>" 'start a new row every five records
           x = 0
        end if 
 
        'I just pulled the content of the table cell from you code example %>
        <td><br><font size="2"><p></p> 
        <a onmouseover="doTooltip(event,'<img
        src="<%=Server.URLPathEncode(rsCard("ThumbnailURL"))%>" alt=""  
        border="0"><div class="tp2">
        <%
        If Trim(rsCard("Author"))<>"" Then  %>
           <%=rsCard("Author")%>
        <%
        End If %>
        </div>' )"
        onmouseout="hideTip()"
        href="http://<%=rsCard("DefaultHeadline")%>"
        target="_blank"><%=rsCard("CardDescription")%></a>
        </font>
        <p align="left"><font size="1"><span style="color : #303030;">
        <%
        If  Trim(rsCard("Author"))<>"" Then %>
           <%=rsCard("Author")%>
        <%
        End If %>
        </font></span>
        <p align="left"><font face="<%=FontName%>" size="1"><a
        href="card.asp?PostCardID=<%=rsCard("PostCardID")%>">
        <I><%=rsCard("DefaultMessage")%></I><a></td>
        <% 
        oRs.MoveNext
    loop
    response.write "</tr></table>"

I need carddescription in the dropdown as they are the headings like abstract etc and I was led to believe that I needed to send the id to the next page to display the relevant sites.

So basically I need to send the id relevant to the selection, but when I tried that
with asp?cardID=xx, I just got xx appearing in the next page.

right, you need to send the thing the user selected in the first page to the second page, but all they actually selected is a card ID. You need to connect to the db again to see what the card ID means, ie "SELECT * FROM myTable WHERE cardID = " & request("dardID "). Does this make sense?

I dont know if that helps you to understand. I am stabbing in the dark trying to figure this out. basically if you visited wotartist .com you would see what I need to appear.

I checked out wotartist.com and I think I'm more confused than when I started. Is that supposed to be an example of how it is supposed to work, or is it a work in progress? I definitely don't see the problem you are describing. Is your script page in testing up at a URL where we can check it out?

Jared

[fran7]

Dear Jared, I have to thank you for your help.

www.wotartist. com/right.asp

is where I have the dropdown test popluated from the database. You will see when taken to the next test page, that you just get one carddescription shown. What I am trying to get happening is what happens when you search for a word or use the main country categories, that the page is populated with the relevant links to the category selected from the dropdown.

If you look at any country category on the site you will see that artists have a heading, eg, watercolor, abstract etc. It is those that I want to only appear when someone selects from the dropdown.
Thanks
Richard

[jhardman]

a Ha! The problem is that you have an error on line 229. Which is line 229? it's one of these:

<%   
    If Not rsCard.EOF Then
    rsCard.AbsolutePage = intPage
 
 
   For intRecord = 1 To rsCard.PageSize
    CurrentColumn=1
%>

There is some object definition missing, and this is always a tricky problem to find.

I notice the page is set up to either return search results or display results from a category. You have never tested it with search results though, right?

Jared

[fran7]

Hi Jared, Thats strange as line 229 is an empty line. This code finishes on line 228

<p align="left"><f ont size="1"><span style="color : #303030;"><%If Trim(rsCard("Au thor"))<>"" Then%> <%=rsCard("Auth or")%><%End If%></font></span>
<p align="left"><f ont face="<%=FontNa me%>" size="1"><a href="card.asp? PostCardID=<%=r sCard("PostCard ID")%>">
<I><%=rsCard("D efaultMessage") %></I><a>

Thanks

Richard

[fran7]

Hi Jared, That error comes up if the page is accessed directly. ie manner.asp in the address bar. It doesnt occur if you search or enter by category, only if there is no object.
Thanks
Richard

[jhardman]

Richard

BTW, what are you using to edit the page? some editors will number the lines for you, and they tend to be fairly accurate. I can think of a couple reasons your count may be a little off from what the server says, but there's an easy way to check. Put one more blank line before the line you think is causing the error, and one line after. If the line you thought is the problem really is the problem, the error message will now say the error is on line 230. If it is after that line, the error message will say line 231. If it is before that line, the error message will not change. My best guess is that the error is coming from this line:

    If Not rsCard.EOF Then

put one blank line before and one after and see what the error message says.

Jared

[fran7]

Hi Jared, You are right, it didnt change but did when I added another blank line before the line you think is the problem
Thanks Richard

[jhardman]

Hi Jared, You are right, it didnt change but did when I added another blank line before the line you think is the problem
Thanks Richard

so now it says the error is on line 231, which means the error is after the line I thought. I still think it has to be one of those four I said in post 16. Test it on the next line. What you are looking for is the line that makes the error line only go up one number.

Jared