CUSTOMER table not being updated!

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   For some reason my Customer table is no longer being updated with info on details1.asp page.  It appears as if the "UPDATE DISTINCTROW [Customer]" statement in shipping1.asp module is no longer working.  The code contains a variable called "Success" which is set to "TRUE" even though no data in the Customer Table has been updated.  All the other data asscoiated with the "order' is in the "allorders" query which is used by shipping ASP modules to calculate shipping costs.  The DHL, UPS modules have errors because there is no city, zipcode, etc. data in the Customer table.  

Any suggestions as what could have caused this?

Thanks.  

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
wesonline Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: August/25/04 Location: United States Status: Offline Points: 23	Post Options Post Reply Quote wesonline Report Post Thanks(0) Quote Reply Topic: CUSTOMER table not being updated! Posted: October/04/05 at 1:03pm
	For some reason my Customer table is no longer being updated with info on details1.asp page. It appears as if the "UPDATE DISTINCTROW [Customer]" statement in shipping1.asp module is no longer working. The code contains a variable called "Success" which is set to "TRUE" even though no data in the Customer Table has been updated. All the other data asscoiated with the "order' is in the "allorders" query which is used by shipping ASP modules to calculate shipping costs. The DHL, UPS modules have errors because there is no city, zipcode, etc. data in the Customer table. Any suggestions as what could have caused this? Thanks.