Adding Fields  
       
      Printed From: SalesCart
        Category:  Legacy Products
       Forum Name:  SalesCart Standard / PRO / SQL
       Forum Description:  All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
       URL: http://forum.salescart.com/forum/forum_posts.asp?TID=375
       Printed Date: November/04/25 at 1:07am Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com
      
 
  
      Topic: Adding Fields
       
      Posted By: moganowski
       Subject: Adding Fields
       Date Posted: July/12/05 at 9:08pm
       
      
        
          
	
Article 5020 talks about how to add a field.  However, step 3 is missing, and a complete list of the page names needing editing would also be helpful.   It appears that add the field to database, case sensitive, adding field to details1.asp, update SQL (2 places) on shipping1.asp and (2 places)confirm1.asp are not sufficient to get the value passed through to the payment2.asp page.
 
 This includes using single quotes around text variables.  Has someone done this successfully.
 I was assured by a salesperson this is easily done.
          | 
         
        
      
 
  Replies: 
       
      Posted By: Techno Geek
       
      Date Posted: July/13/05 at 8:36am
       
      
        
          
	
Hi, 
 - Add columns to database
 - Update forms with new fields
 - Update SQL queries
 - Test it out
  That is what it takes to add additional fields to the database. This isn't something we advertise as part of the shopping cart. You have an open source cart that you can modify, but modifications are not part of the product that we advertise. If you have some experience in ASP you will be able to do this.
  ------------- Techno Geek
 Customer Support Engineer
 ComCity and SalesCart Technical Support
          | 
         
        
        
       
      
      Posted By: moganowski
       
      Date Posted: July/13/05 at 9:48am
       
      
        
          
	
yes, these are the steps performed, and data is added to db, but does not appear in the payment2 or receipt forms.  What is the extra step?
 
 thanks,
 Marcia
          | 
         
        
        
       
      
      Posted By: Techno Geek
       
      Date Posted: July/13/05 at 9:50am
       
      
        
          
	
Yeah but did you make sure that you've modified the MS-Access views to display the additional fields? Also, did you add the record sets for the additional fields to payment2?
  ------------- Techno Geek
 Customer Support Engineer
 ComCity and SalesCart Technical Support
          | 
         
        
        
       
      
     |