Try this:
<QUERY NAME="software" DATASOURCE="ccmast">
SELECT * FROM the_database
WHERE column_name = '#form.hideme#'
</QUERY>
> -----Original Message-----
> From: miles [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 27, 2000 5:30 PM
> To: [EMAIL PROTECTED]
> Subject: hiding a column name..?
>
>
> I have a real small question that you folks probably alrerady know
> the answer to.
>
> How would I "hide" the column names in a drill down link ?
>
> Lets assume the following:
>
> <a href="myfilename.cfm?columname="#columnamevalue#">link</a>
>
> in other web-enabling languages Ive seen this done where you
> can hide the column name by replacing it with a dummy that passes
> to the next page which gets processed as a form value that you
> perform a query on against the db.
>
> <a href="myfilename.cfm?hideme="#columnamevalue#">link</a>
>
> On the next page the HIDEME would become
>
> <QUERY NAME="software" DATASOURCE="ccmast">
> SELECT *
> FROM the_database
> WHERE "form.hideme" = #column_name#
> </QUERY>
>
> When I try the above with CF it tells me that "column_name"
> doesn't exist.
>
> What am I doing wrong ?
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
