Technology, Web & Business Forum

You are here: Technology, Web & Business Forum : Web Development : Programming : Why do I keep getting two few parameters. Expected 1 or 2 ColdFusion?


Welcome to the Technology, Web & Business Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.


Programming Discuss programming languages such as .NET, PHP, PERL, ASP, ColdFusion, C++


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-07-2008
Junior Member
 
Join Date: Apr 2008
Posts: 6
Default 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!
__________________
Powered by Yahoo! Answers
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -5. The time now is 09:38 AM.