No default value / syntax error

[Vampyr_Bytes]

Hi all,

I'm trying to run the following query on an access database -

<cfquery name="Warnings" datasource="Products">
SELECT WarningInfo
FROM tblWarnings
WHERE tblWarnings.WarningCode = tblWarningLink.WarningCode
AND tblItems.ItemCode = tblWarningLink.ItemCode
AND tblItems.ItemCode = <cfqueryparam value="#url.id#"
cfsqltype="cf_sql_integer">
</cfquery>

however, when it runs I get the following error -

Error Executing Database Query.
Parameter tblItems.ItemCode has no default value.

The error occurred in C:\CFusionMX7\wwwroot\Mother Earth's Goodies\Item.cfm:
line 13

11 : WHERE tblWarnings.WarningCode = tblWarningLink.WarningCode
12 : AND tblItems.ItemCode = tblWarningLink.ItemCode
13 : AND tblItems.ItemCode = <cfqueryparam value=#url.id#
cfsqltype="cf_sql_integer">
14 : </cfquery>
15 : <cfquery name="Properties" datasource="Products">



--------------------------------------------------------------------------------

SQL SELECT WarningInfo FROM tblWarnings WHERE tblWarnings.WarningCode =
tblWarningLink.WarningCode AND tblItems.ItemCode = tblWarningLink.ItemCode AND
tblItems.ItemCode = (param 1)
DATASOURCE Products
VENDORERRORCODE 3088
SQLSTATE &nbsp;

and when I run a test in the query builder I get "syntax error(missing
operator) in query."

any and all help will be greatly appreciated

[mxstu]

If you are joining multiple tables, you need to reference all of the tables in
your FROM clause. Something like this

--- NOT TESTED
SELECT tblWarnings.WarningInfo
FROM tblWarnings, tblItems, tblWarningLink
WHERE tblWarnings.WarningCode = tblWarningLink.WarningCode AND
tblItems.ItemCode = tblWarningLink.ItemCode AND
tblItems.ItemCode = <cfqueryparam value="#url.id#" cfsqltype="cf_sql_integer">

[CF_Oracle]

If you still have error after naming all tables as mxtu advised put at the top of your CF page <cfparam name="url.ID" default=0>.