DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Multiple Record  
DwZone Forum Index -> Multiple Record
.
Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 1 to 10 of 66 (Total: 66) First |  Prev |  Next |  Last  
 Subject Author Date  
   Multiple Delete Error: Unknown Column  
View this persons public profile  Gary   10:24 28 Mar 2019  
   Error on Multi delete  
View this persons public profile  Ken   12:53 17 Dec 2016  
   Re: Error on Multi delete  
View this persons public profile  Gianluigi   13:07 17 Dec 2016  
   Multiple Record Updates Wrong Rows  
View this persons public profile  Ed Stewart   10:02 21 Dec 2015  
   Re: Multiple Record Updates Wrong Rows  
View this persons public profile  Gianluigi   10:08 21 Dec 2015  
   Re: Multiple Record Updates Wrong Rows  
View this persons public profile  Gianluigi   6:27 27 Dec 2015  
   Re: Multiple Record Updates Wrong Rows  
View this persons public profile  Ed Stewart   7:29 27 Dec 2015  
    Commas in fields screw up db updates when using Multiple Record  
View this persons public profile  Steve Skinner   11:32 22 Sep 2015  
 
I have multiple record working, however, there's a major problem in how the data gets saved to the database when commas are used in text fields.

I have an admin page for bulk editing several text fields in a product database (name, description, keywords, associated items)

If NO commas are used in the text fields, the multiple update works perfectly. However, if a comma is used in any of the fields, the text that follows the comma gets d_r_o_pped down into the same field for the next row of data.

So for instance, if I enter this into the keywords field: royal blue, red, green - what ends up getting saved to the database is only royal blue. The value red gets saved into the keywords field for the next row of data below the record I wanted it on, and green gets saved into the data two rows down.

Is there a way to get your extension to work so that commas don't split the data being entered into one field into the same field across multiple records?
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Commas in fields screw up db updates when using Multiple Record  
View this persons public profile  Gianluigi   11:40 22 Sep 2015  
   Re: Commas in fields screw up db updates when using Multiple Record  
View this persons public profile  Steve Skinner   11:49 22 Sep 2015  
Last Visit: Thursday 25 Jul, 2024 5:04 am First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: