Why do I keep getting two few parameters. Expected 1 or 2 ColdFusion?
<cfquery name="GetCmts" datasource="DB">
SELECT
EmpID,
commentID,
userName,
comment
FROM
usersTbl u INNER JOIN commentTbl c
ON u.EmpID = c.EmpID
WHERE
EmpID = #Val(EmpID)#
ORDER BY
commentID DESC,
EmpID DESC
</cfquery>
URL: ../user.cfm?EmpID=4
I can't seem to get this code to work correctly, I want to display comments left from other employee's on a employee's page(user.cfm?EmpID='What ever the EmpID EQ') to show up on my employee's profile. I just can't seem to get it to work. If anyone can help me, thanks!
|