Too few parameters error

[ivalum21]

Here is my SQL statement:

<cfquery name="EmpIn" datasource="Mileage">
SELECT EmpID
FROM Employee_Info
WHERE First_Name = '#Form.FirstName#'
	And Last_Name = '#Form.LastName#'
</cfquery>

I get a "too few parameters error. Expecting 2" error. What is the problem here?

 

[webmigit]

IT generally means one of the fields referenced either does not exist or the name is mispelled.. this code will help you find out..

<cfquery name="ColN" datasource="Mileage">
  SELECT *
    FROM Employee_Info
   WHERE EmpID = 1
</cfquery>

<cfoutput>#ColN.ColumnList#</cfoutput>

This may return no records but it will return the column names..


ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.