URL ID Query

[ITGL72]

CF seems to be really beating me up the last few days. Looking for assistance in what I am missing this time around.

I have a link that points to a page with a URL ID in it for a next page query, looks like this:

catpage.cfm?CATID=3

on 'catpage.cfm' I start a query that works with the CATID=3 (for this example)


<CFQUERY NAME=&quot;GETCAT&quot; DATASOURCE=&quot;GLKB&quot;>
SELECT *
FROM KnowledgeBase
WHERE 'Category' = '#URL.CATID#'




Below are the only two tables in my database and their datatypes:




TABLE: CATEGORY

FIELD NAME - DATATYPE
---------------------
CATID - Autonumber
CATEGORY - Number





TABLE: KNOWLEDGEBASE

FIELD NAME - DATATYPE
---------------------
CONTENTID - Autonumber
CATEGORY - Number
SUBJECT - Text
CONTENT - Memo
DATE - Date/Time
EDIT - Date/Time




If I run this QUERY, I get a page that displays NOTHING.
There is no ERROR. Just a page with NOTHING. View Source shows
just the HTML code for that page.

Any suggestions? How did I fuddle this code up this time?

 

[ITGL72]

Well I seemed to get it working.. I just took out the single quotes from:

WHERE 'Category' = '#URL.CATID#'

and made it:

WHERE Category = #URL.CATID#

I guess I was sticking with the thought that anything with a number in the field needs single quotes, oh well...