Skip to main content
C
cfifvi
Participant
July 5, 2011
Answered

URL Parameter passing problem

  • July 5, 2011
  • 2 replies
  • 993 views

Below #name# displays the correct information from the gather table.

For instance, if pearl is logged in with users.userID = 5, then #name# displays mek, tiff which is correct.

But,in the a href, display_graphic2.cfm?userID=5 for both mek and tiff.  And I need it to equal the userID that is in the users table so clicking  on mek would link to: display_graphic2.cfm?userID=4 and tiff would link  to: display_graphic2.cfm?userID=3

How can I do this?

gather table data

gatherID name

3     pearl     
5     mek
5     tiff
6     sammy

users table data

userID     name

3     tiff
5     pearl
6     vi
4     meka
...

Code:
<!--- find users based on match with loggin in user --->
<cfquery name="matches" datasource="gifts">
     SELECT gather.name, gather.gatherID, users.userID
     FROM gather INNER JOIN users 
     ON gather.gatherID=users.userID
     WHERE gather.gatherID=<cfqueryparam cfsqltype="cf_sql_integer" value="#session.userID#">

</cfquery>
 <!--- display logged in users matches and pass matched user userID in URL --->
See: <cfoutput query="matches">
          <a href="display_graphic2.cfm?userID=#userID#">#name#</a>,

     </cfoutput>
    This topic has been closed for replies.
    Correct answer JMF3

    Not sure what the question is. In that data with that SQL statement,

    userID and gatherID will always be the same, since it's an INNER JOIN on

    gatherID = userID, so those IDs of 3 and 4 will never exist in the query,

    only 5. It looks like you need to be joining on name, not ID:

    That would get you userID '3' for 'tiff' and userID '4' for 'mek' (assuming

    that 'meka' is a typo in the users table).

    2 replies

    J
    JMF3Correct answer
    Participating Frequently
    July 5, 2011

    Not sure what the question is. In that data with that SQL statement,

    userID and gatherID will always be the same, since it's an INNER JOIN on

    gatherID = userID, so those IDs of 3 and 4 will never exist in the query,

    only 5. It looks like you need to be joining on name, not ID:

    That would get you userID '3' for 'tiff' and userID '4' for 'mek' (assuming

    that 'meka' is a typo in the users table).

    C
    cfifviAuthor
    Participant
    July 5, 2011

    Thank you. yes, I needed to join on name not id.

    That fixed it. I really appreciate your help.

    Sincerely.

    D
    Dan_Bracuk
    Inspiring
    July 5, 2011

    When in doubt, look at your data.

    First, after you run your query, cfdump the recordset and see if it's what you expect.

    Next, in your cfoutput block, change this

    <a href="display_graphic2.cfm?userID=#userID#">#name#</a>,

    to this

    <a href="display_graphic2.cfm?userID=#userID#">User ID is #userID# and name is #name#</a>,

    and see if it's what you expect

    C
    cfifviAuthor
    Participant
    July 5, 2011

    Thank you... this was very helpful.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices