Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Mar 2010
    Posts
    8
    Thanks
    1
    Thanked 0 Times in 0 Posts

    URL parameter issue

    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:
    <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>
    
    See: <cfoutput query="matches"><a href="display_graphic2.cfm?userID=#userID#">#name#</a>,
    
    </cfoutput>
    SOLVED.
    changed my query to JOIN on name not ID:
    SELECT gather.gatherID, gather.name, users.userID
    FROM gather INNER JOIN users ON gather.name=users.name
    WHERE gatherID=<cfqueryparam cfsqltype="cf_sql_integer" value="#session.userID#">
    Last edited by vivE; 07-05-2011 at 11:48 PM. Reason: fixed this

  • #2
    New Coder
    Join Date
    Aug 2011
    Location
    Fuquay Varina NC
    Posts
    21
    Thanks
    1
    Thanked 2 Times in 2 Posts
    loop through the output of the query until you find the matching record and then <cfoutput> the variable and exit the loop.

  • #3
    New Coder
    Join Date
    Aug 2011
    Location
    Fuquay Varina NC
    Posts
    21
    Thanks
    1
    Thanked 2 Times in 2 Posts
    ok hey looks like you've solved it with the query / joins. Cool. that's a little slicker than my method, but it goes to show there are multiple ways to get stuff done.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •