CF 101

[Bill]

I feel like an ass asking this but I can't seem to get my form values to
pass to the action page

Here's what I have

presentation page

<!--- If Free Shipping field has been filled in, --->
<cfparam name="Client.ShipFree" default="">
<cfif IsDefined("FORM.ShipFree")>
<cfset Client.ShipFree = "FORM.ShipFree">
</cfif>

***************************************

<cfquery name="rsFreeShip" datasource="#request.dsn#"
username="#request.dsnUsername#" password="#request.dsnPassword#">
SELECT ship_PayFree_ID, ship_code, ship_codeName FROM tbl_ShipPayFree
WHERE ship_code = 'Client.ShipFree'
</cfquery>
<input name="ShipFree" type="text"
value="<cfoutput>#rsFreeShip.ship_code#</cfoutput>">

For some reason when I add the right number to the text field it's not
getting picked up by the IsDefined. I also need it to match the value of the
rsFreeShip query but obviously I I need to pick it up before I can match it.

Thank in advanced

Bill

[mxstu]

Try removing the quotes from "FORM.ShipFree" it is treated as a variable and
not as a string
<cfset Client.ShipFree = FORM.ShipFree>

and I think you need pound signs around this line, so that 'Client.ShipFree'
is evaluated, and not treated as a string
WHERE ship_code = '#Client.ShipFree#'

[Bill]

That seems to be what I was missing Thanks a million.

Sometimes all it takes a second set of eyes.

Now on to the next steps.

Thanks again

Bill
"mxstu" <webforumsuser@macromedia.com> wrote in message
news:d9pasf$7br$1@forums.macromedia.com...

> Try removing the quotes from "FORM.ShipFree" it is treated as a variable
> and
> not as a string
> <cfset Client.ShipFree = FORM.ShipFree>
>
> and I think you need pound signs around this line, so that
> 'Client.ShipFree'
> is evaluated, and not treated as a string
> WHERE ship_code = '#Client.ShipFree#'
>
>
>