form with multiple instances of the same fields names

[E F]

Hi,

I have a form where the user can add rows to it if they need to add another record. As a result of this, i have form fields with the same name. Here is a copy of the cfdump to better illustrate what I mean.

struct
BUILDINGID	1,1
COLOUR	yellow,red
MAKE	Ferrari,Chevy
MODEL	Testaroda,Suburban
PLATE	APSW211,VE3OBX
SPOTNUMBER	22,23
TENANTID	790,790
TYPE	Car,Car
YEAR	2012,1978

As you can see coldfusion creates a list of the form names for me. I am able to deal with this outside of the wheels framework by a few loops and inserts queries. That said, how would I do an insert or update in the cfwheels framework in this scenario.

Thanks for any guidance,

Erik

[Andy Bellenie]

I'd add an index to the form field name to diffentiate between them.

E.g. textFieldTag(name="buildingId[1]")

On post, Wheels will format this into a structure for you.

--
You received this message because you are subscribed to the Google Groups "ColdFusion on Wheels" group.
To view this discussion on the web visit https://groups.google.com/d/msg/cfwheels/-/taf66XXdmRAJ.
To post to this group, send email to cfwh...@googlegroups.com.
To unsubscribe from this group, send email to cfwheels+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/cfwheels?hl=en.

[Erik Fenkell]

Like this....

#textFieldTag(name="resident[make][i]", value=resident.make)#</td>

[Erik Fenkell]

I tried this and it does not wokr. Is this what you mena though?

                        <!--- ROW 1 ---->

                        #hiddenFieldTag(name="resident[tenantid[1]]", value=resident.tenantid)#

                        #hiddenFieldTag(name="resident[buildingid[1]]", value=resident.buildingid)#

                        <td>#textFieldTag(name="resident[spotNumber[1]]", value=resident.spotNumber, class="input-mini")#</td>

                        <td>#textFieldTag(name="resident[type[1]]", value=resident.type, class="input-mini")#</td>

                        <td>#textFieldTag(name="resident[plate[1]]", value=resident.plate, class="input-mini")#</td>

                        <td>#textFieldTag(name="resident[make[1]]", value=resident.make, class="input-small")#</td>

                        <td>#textFieldTag(name="resident[model[1]]", value=resident.model, class="input-small")#</td>

                        <td>#textFieldTag(name="resident[year[1]]", value=resident.year, class="input-mini")#</td>

                        <td>#textFieldTag(name="resident[colour[1]]", value=resident.colour, class="input-mini")#</td>

                         <!--- ROW 2---->

                        #hiddenFieldTag(name="resident[tenantid[2]]", value=resident.tenantid)#

                        #hiddenFieldTag(name="resident[buildingid[2]]", value=resident.buildingid)#

                        <td>#textFieldTag(name="resident[spotNumber[2]]", value=resident.spotNumber, class="input-mini")#</td>

                        <td>#textFieldTag(name="resident[type[2]]", value=resident.type, class="input-mini")#</td>

                        <td>#textFieldTag(name="resident[plate[2]]", value=resident.plate, class="input-mini")#</td>

                        <td>#textFieldTag(name="resident[make[2]]", value=resident.make, class="input-small")#</td>

                        <td>#textFieldTag(name="resident[model[2]]", value=resident.model, class="input-small")#</td>

                        <td>#textFieldTag(name="resident[year[2]]", value=resident.year, class="input-mini")#</td>

                        <td>#textFieldTag(name="resident[colour[2]]", value=resident.colour, class="input-mini")#</td>

                   

[Erik Fenkell]

Can wheels really figure this out with out looping through the fields?

[Chris Peters]

Try keys that look similar to this:

resident[tenantid][1]

Yes, it works. Try submitting your form and dumping the params struct.

[Erik Fenkell]

struct
BUILDINGID	struct 1 1 2 1
COLOUR	struct 1 White 2 Orange
MAKE	struct 1 Ford 2 Hyundai
MODEL	struct 1 f-150 2 Pony
PLATE	struct 1 qweqwe 2 ddsaf
SPOTNUMBER	struct 1 25 2 26
TENANTID	struct 1 1648 2 1648
TYPE	struct 1 Truck 2 Car
YEAR	struct 1 2012 2 1981

The cfdump is what I get when I try that.

When I try to insert it into the DB I get the following error.

Complex object types cannot be converted to simple values.

My insert code is <cfset model("vehicles").create(params.resident)>

Am I supposed to be doing something else with that structure.

Thanks for your help Andy, it is appreciated.

Erik

[tpet...@gmail.com]

you will need to do a loop and collection to similar conditions into a struct of their own:

// pick a key in the struct and see how many elements it has

// from your example you should have 2 elements in each key

// of the struct

<cfset counter = StructCount(params.resident.buildingid)>

// loop from 1 to the number of elements. in your example 2

<cfloop from="1" to="#counter#" index="i">

  // create a struct to hold the key value pairs we gather from each

  // element

  <cfset args = {}>

  // loop over each key in the params.resident struct

  <cfloop collection="#params.resident#" item="r">

    // see if the element exists in the key

    // in other words we're checking for

    // params.resident['buildingid'][1]

    <cfif StructKeyExists(params.resident[r], i)>

       // if it exists. add the key and the value to

       // our args struct that we created

      <cfset args[r] = params.resident[r][i]>

    </cfif>

    // call create of the model passing our

    // args struct in place of the params.resident

    <cfset model("vehicles").create(args)>

  </cfloop>

</cfloop>

[Erik Fenkell]

Thanks for this. I am very close. I was able to get my structureall setup.

I get the the following error:

Element model is undefined in a CFML structure referenced as part of an expression.

My data looks like this:

struct
BUILDINGID	struct 0 1 1 1 2 1
COLOUR	struct 0 Green 1 Silver 2 Black
MAKE	struct 0 Ford 1 Lexus 2 Porsche
MODEL	struct 0 Escort 1 F7 2 928 C
PLATE	struct 0 AHH123 1 MKL291 2 HTWHLS
SPOTNUMBER	struct 0 22 1 23 2 24
TENANTID	struct 0 1648 1 1648 2 1648
TYPE	struct 0 Car 1 Car 2 Car
YEAR	struct 0 2011 1 2010 2 1970

[E F]

I Got it working with the following code. I am sure there is a better way, but this made sense to me.

 <cfset counter = StructCount(params.resident.buildingid)>

        <cfloop from="1" to="#counter#" index="i">

            <!--- REMEBER TO SUBRACT ONE BECAUSE  THE ARRAY INDEX STARTS AT 0 --->

            <cfset i = #i#-1>

            <cfoutput>

                <cfset newVehicle = model("vehicles").new()>

                <cfset newVehicle.tenantid = #params.resident.tenantid[i]#>

                <cfset newVehicle.buildingid = #params.resident.buildingid[i]#>

                <cfset newVehicle.spotnumber = #params.resident.spotnumber[i]#>

                <cfset newVehicle.type = #params.resident.type[i]#>

                <cfset newVehicle.plate = #params.resident.plate[i]#>

                <cfset newVehicle.make = #params.resident.make[i]#>

                <cfset newVehicle.model = #params.resident.model[i]#>

                <cfset newVehicle.year = #params.resident.year[i]#>

                <cfset newVehicle.colour = #params.resident.colour[i]#>

                <!--- CHECK TO SEE IF THE RECORD SHOULD BE ADDED OR AN EXISTING ONE UPDATED --->

                <cfif NOT isDefined('params.resident.id')>

                    <cfset newVehicle.save()>

                <!--- IF THERE IS A NEW RECORD TO BE INSERTED AMONGST RECORDS THAT ARE TO BE UPDATED --->

                <cfelseif #params.resident.id[i]# EQ 0>

                    <cfset newVehicle.save()>

                <cfelse>

                <!--- UPDATE AND EXISTING RECORD --->   

                    <cfset result = model("vehicles").updateByKey(#params.resident.id[i]#, newVehicle)>

                    <cfdump var="#params.resident#"/> 

                </cfif>           

            </cfoutput>

        </cfloop>  

Thanks again for everyone's help, it got me to my solution!

Erik