Text field to cfquery

[Guest_imported]

I've got a text field. Can i get the entered value in a CFquery tag?

Like:

The user filled the text field (named: textfield) with: "hello"

In the CFQuery tag:
<cfquery datasource=&quot;FAQ&quot;>
DELETE FROM FAQ WHERE key = ?textfield?
</cfquery>

so the record with &quot;hello&quot; (key) will be deleted.

what do i have to fill in to get the variable of the text field in my cfquery tag?

 

[CFDude]

You are on the right track -- it would be :

For numbers:
<cfquery datasource=&quot;FAQ&quot;>
DELETE FROM FAQ WHERE key = #form.textfield#
</cfquery>

If &quot;key&quot; in the DB is text field, then you would need quotes around it:

<cfquery datasource=&quot;FAQ&quot;>
DELETE FROM FAQ WHERE key = '#form.textfield#'
</cfquery>

HTH,
Tim P.