Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 General help me questions
 customer other fields to update database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sharon
VP-CART Super User

357 Posts

Posted - April 29 2010 :  06:41:41  Show Profile  Visit Sharon's Homepage  Reply with Quote
Using v7

I have set the following in my shop configuration

xcustomerotherbypass sector,cotype
xcustomerothercaptions Industry Sector,Company Type,Fax
xcustomerotherfields sector,cotype,fax

Fields sector, cotype, fax are already in my customers table

I have edited shopcustomerform.asp to include the following code

Response.write tablerow & tablecolumn
Response.write "Company Type" & TablecolumnEnd
Response.write tablecolumn
%>
<select name="dropdown">
<option value="Contractor" selected="selected">Contractor</option>
<option value="Testing House">Testing House</option>
<option value="Consultant">Consultant</option>
<option value="Government">Government</option>
<option value="University/College">University/College</option>
<option value="Production">Production</option>
<option value="Reseller">Reseller</option>
</select>
<%
Response.write tablecolumnend & tableRowend


and

Response.write tablerow & tablecolumn
Response.write "Industry Sector" & TablecolumnEnd
Response.write tablecolumn
%>
<select name="dropdown">
<option value="All" selected="selected">All</option>
<option value="Soil/Rock">Soil/Rock</option>
<option value="Concrete">Concrete</option>
<option value="Cement/Mortar">Cement/Mortar</option>
<option value="Blacktop/Asphalt">Blacktop/Asphalt</option>
<option value="Sieves">Sieves</option>
<option value="Sand/Gravel">Sand/Gravel</option>
<option value="Aggregates">Aggregates</option>
<option value="Environment">Environment</option>
<option value="Calibration">Calibration</option>
<option value="None of the above">None of the above</option>
</select>
<%
Response.write tablecolumnend & tableRowend


The drop-downs display on the form but the records are not being written to the database. According to the notes on xcustomerotherbypass.

"List of customer fieldnames to be excluded from automatic display. Fields would need to be added to the customer form manually. VP-ASP will do the rest and store the data in the customers and orders tables."

What am I missing here?

carfin
VP-CART Expert

United Kingdom
948 Posts

Posted - April 29 2010 :  08:40:10  Show Profile  Reply with Quote
Hi Sharon,

you say that the customer other fields are already in the customers table. Have you also added them to the orders table? The field values are written to both customers and orders tables, and if one field cannot be found in either table, none of the data will be written.

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

Sharon
VP-CART Super User

357 Posts

Posted - April 29 2010 :  09:25:51  Show Profile  Visit Sharon's Homepage  Reply with Quote
Hi Carrol, Both fields are in both tables.

I don't get the "ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal." message when entering a new customer.

I can select from both drop-downs but when I view/edit customers the fields are blank.
Go to Top of Page

carfin
VP-CART Expert

United Kingdom
948 Posts

Posted - April 29 2010 :  09:55:52  Show Profile  Reply with Quote
Hi Sharon,

I just noticed that you haven't given the drop downs names corresponding to the fields in the database.

They should be:

<select name="sector">

and

<select name="cotype">

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

Sharon
VP-CART Super User

357 Posts

Posted - April 29 2010 :  10:06:04  Show Profile  Visit Sharon's Homepage  Reply with Quote
Thanks Carrol.

I have no coding training at all so it would have taken me about 6 months to spot that.

On our original v 5.5 site I had to pay a developer to code those in for me so I really do appreciate your help. :-)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00