Element PARTNO is undefined in URL

jumbopillow

Hi, I am looking for some help with my code. Unable to get the action code to work.

Here is my code:

Expand|Select|Wrap|Line Numbers

 <head>

    <title>Update Form Application</title>

       <link rel="stylesheet" type="text/css" href="general.css" />

</head>
 
<body>

      <h2>Update Form Application </h2>

        <a>Edit Component Number:  </a><cfoutput>#compno#</cfoutput> <a>for Product Number: </a><cfoutput>#prodno#</cfoutput>

        <br></br>

        <a>Current Part Number:  </a><cfoutput>#partno#</cfoutput> <a>Part Description: </a><cfoutput>#partdesc#</cfoutput>

        <br></br>

Expand|Select|Wrap|Line Numbers

         <cfparam name="Form.compno" default="0" type="numeric">

        <cfparam name="partno" default="0" type="numeric">
 
<!--- Block One: Update Action Code --->
 
<cfif IsDefined("Form.update")>

                <cfquery name="updateComponent"

                datasource="#Request.DSN#"

                username="#Request.username#"

                password="#Request.password#">

                update Component

                set

                partno = '#Form.partno#',

                nopartsreq = '#Form.nopartsreq#'

                where

                compno = '#compno#'

                </cfquery>
 
        <cflocation url="updatecomponent.cfm?=#Form.partno#" addToken="no">
 
<!--- Block Two : Display Editable Fields --->
 
        <cfelseif IsDefined("Form.display")>

                <cfquery name="getPartList"

                datasource="#Request.DSN#"

                username="#Request.username#"

                password="#Request.password#">

                select *

                from part

                order by partno

                </cfquery>  
 
                <cfquery name="getComponent"

                datasource="#Request.DSN#"

                username="#Request.username#"

                password="#Request.password#">

                select nopartsreq, partno

                from component

                </cfquery>   
 
                <table>

                <cfform action="updatecomponent.cfm" method="post">

                        <tr>

                        <th style="text-align: left">Update Part: </th>

                        <td> 

                        <select name="#partno#">

                        <cfoutput query="getPartList">

                        <option value="#partno#">#partdesc#</option>

                        </cfoutput>

                        </select>

                        </td>

                        </tr>

                        <tr>

                        <th>Enter Num Parts Req: </th>

                        <td>

                        <cfinput name="nopartsreq" type="text"

                        value="#getComponent.nopartsreq#" size="3"

                        maxlength="2"

                        required="yes"

                        message="The number of parts needed is required from 1 to 10.">

                        </td>

                        <td>

                        <input type="hidden" name="prodno" value="#prodno#">

                        <input type="hidden" name="compno" value="#compno#">

                        <input name="submit" type="submit" value="Update Component" />

                        </td>

                        </tr>

                </cfform>

                </table>

                <!--- IsDefined(“Form.display”) --->
 
<!--- Block Three : Redisplay Fields --->
 
<cfelseif Form.compno NEQ "0" OR IsDefined("URL.compno")>

                <cfquery name="getComponent"

                datasource="#Request.DSN#"

                username="#Request.username#"

                password="#Request.password#">

                select nopartsreq, partno

                from component

        <cfif IsDefined("URL.compno")>

                Where compno = <cfqueryparam cfsqltype=”CF_SQL_VARCHAR” value="#URL.compno#">

        <cfelse>

                Where compno = <cfqueryparam cfsqltype=”CF_SQL_VARCHAR” value="#Form.compno#">

        </cfif>

                </cfquery>   

<cfelse>

                Please select a component from a <a href=”showproducts.cfm”>product</a> first.

</cfif>

                <h4>

                <a href="showcomponents.cfm?prodno=<cfoutput>#prodno#</cfoutput>">

                Choose another Component Number</a>&nbsp;&nbsp;|&nbsp;&nbsp;

                <a href="showproducts.cfm">Choose another Product</a>

                </h4>   

                <cfinclude template = "../footer.cfm">   

    </body>

</html>

acoder

You're submitting the form using the POST method, so the form variables will be available via the 'form' struct, not 'url'.

You're not using url.partno, so where does this error occur?

jumbopillow

Quote:

Originally Posted by acoder

You're submitting the form using the POST method, so the form variables will be available via the 'form' struct, not 'url'.

You're not using url.partno, so where does this error occur?

Thanks for replying. I'm still confused. I don't see where I am using URL in the form. 'form' struct means #Form.variable# correct?

Sorry on the url.partno, came from other error msg as I am trying to figure this submitting form problem.

acoder

Quote:

Originally Posted by jumbopillow

Thanks for replying. I'm still confused. I don't see where I am using URL in the form. 'form' struct means #Form.variable# correct?

Correct.

Let me try and get this correct. You're trying to get block 1 to work, correct?

In block 1, you have a query and then you relocate to "updatecomponent.cfm?=#form.partno#". If you want url.partno available on that page, you'll have to change that to "updatecomponent.cfm?partno=#form.partno#"

jumbopillow

Quote:

Originally Posted by acoder

Correct.

Let me try and get this correct. You're trying to get block 1 to work, correct?

In block 1, you have a query and then you relocate to "updatecomponent.cfm?=#form.partno#". If you want url.partno available on that page, you'll have to change that to "updatecomponent.cfm?partno=#form.partno#"

Hi acoder, Thanks. I figured it out.
Cheers!

acoder

I'm glad you managed to figure it out, but it might be helpful for anyone with a similar problem if you could post your solution.

Element PARTNO is undefined in URL

re: Element PARTNO is undefined in URL

re: Element PARTNO is undefined in URL

re: Element PARTNO is undefined in URL

re: Element PARTNO is undefined in URL

re: Element PARTNO is undefined in URL

Similar ColdFusion bytes

/bytes/development

/bytes/it

/bytes/about