even though I've written this in Access with MySQL in mind, this works
fine in the db when I give it values. this SQL is generated by the
cferror.
SELECT DISTINCT users.userID, users.firstname, users.lastname FROM
tQuestionaire, tQuestionaireQuestion, tQuestionaireAnswer, users WHERE
tQuestionaire.questionaire_id = tQuestionaireQuestion.questionaire_id AND
tQuestionaireQuestion.question_id = tQuestionaireAnswer.question_id AND
tQuestionaireAnswer.userid = users.userID AND
tQuestionaireAnswer.answer_checked= 0 AND tQuestionaire.questionaire_id=1
but from CF...
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 3.
(cfquery below...)
the whole thing is with the queryparam.
AND tQuestionaireAnswer.answer_checked=<cfqueryparam value="0"
cfsqltype="cf_sql_integer">
leave out that condition and no error. Hard code the 0 and get "Too few
parameters. Expected 2" - well that's better, at least. I've tried various
sql datatypes with no improvement.
any suggestions?
thanx, barry.b
<cfquery datasource="#request.dsn#" name="qAnswer">
SELECT DISTINCT
users.userID,
users.firstname,
users.lastname
FROM
tQuestionaire,
tQuestionaireQuestion,
tQuestionaireAnswer,
users
WHERE tQuestionaire.questionaire_id =
tQuestionaireQuestion.questionaire_id
AND tQuestionaireQuestion.question_id = tQuestionaireAnswer.question_id
AND tQuestionaireAnswer.userid = users.userID
AND tQuestionaireAnswer.answer_checked=<cfqueryparam value="0"
cfsqltype="cf_sql_tinyint"><!--- 0 means "not marked" --->
AND tQuestionaire.questionaire_id=<cfqueryparam
value="#url.questionaire#" cfsqltype="cf_sql_integer">
</cfquery>
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
