Trouble with url variable in query

[Vampyr_Bytes]

Hi there,

I'm having trouble getting a database query that uses url variables to work.

The query is

<cfquery Name="Display" datasource="Products">
SELECT ProductType, ProductInfo, CategoryType, CategoryInfo, ItemName,
ItemInfo, Price, Weight
FROM tblProducttype, TblCategorytype, TblItems
WHERE TblProducttype.ProductCode = tblCategorytype.ProductCode
AND tblCategorytype.CategoryCode = tblItems.CategoryCode
AND tblCategorytype.ProductCode = <cfqueryparam value="#URL.cat#"
cfsqltype="cf_sql_integer">
AND tblCategorytype.CategoryCode = <cfqueryparam value="#URL.type#"
cfsqltype="cf_sql_varchar">
AND tblItems.Available = "True"
</cfquery>

The error I'm getting is

Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 3.

The error occurred in C:\CFusionMX\wwwroot\Mother Earth's Goodies\Main.cfm:
line 9

7 : AND tblCategorytype.CategoryCode = tblItems.CategoryCode
8 : AND tblCategorytype.ProductCode = <cfqueryparam value="#URL.cat#"
cfsqltype="cf_sql_integer">
9 : AND tblCategorytype.CategoryCode = <cfqueryparam value="#URL.type#"
cfsqltype="cf_sql_varchar" >
10 : AND tblItems.Available = "True"
11 : </cfquery>

Any help would be appreciated

[SafariTECH]

Sometimes teh line reference is indication of the error, and sometimes it is
indication of the last place everything made sense.

I think it actually may be the latter and the issue is in Line 10.

Access has a few quirky things with it that are different from standard SQL.

Is the "tblItems.Available" field a YES/NO field? If so, then it needs to read:
10 : AND tblItems.Available = 1

If it is any string field where it is actually looking for the word "TRUE",
you need to use single quotes, not double:
10 : AND tblItems.Available = 'True'

If the problem is actually in Line 9 thyen it is because you are specifying a
string variable but have no single quotes around the output from the
cfqueryparam. In standard SQL (ie MSSQL) you can actually get away with not
usuing proper quotes etc and the server will figure it out, but MS ACCESS won't
allow it.

Without the actual database to run the tests against, these would be my best
suggestions for now.

[Vampyr_Bytes]

Thanks :) It was line 10.