Re: Duplicate record
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62708
interpreted = N
texte = Paul, (I don't know anything about Storebuilder, so ignore this if it's not relevant.) I do something along these lines on one of my sites when I let the admin add a new record. They get a choice of adding a clean blank record and then fill it all in, or duping an existing one. For the dupe, I have them be on the record they're duping, but you could just as easily have them choose from a list and send that record's unique ID (Hmmm maybe I'll let them do it that way as well). Then, do a search to find the source record, and within the founditems, do a replace, and within that, a listfields with (the fieldnames wrapped in square brackets and interpret tags) = (the values wrapped in URL tags). Use Autonumber to set the unique field ID. For the inevitable fields that will be different (or why else would you dupe this?) you can precede the listfields with those values set to blank, or an incoming variable (they will override the same fieldnames that show later in the replace). Or just present the new record for editing on the next page and let the admin make changes there. For your related records, it depends on how they're related. If the product calls the color and size dbs, then that would automatically come along for the ride when you duped the record. If you were wondering if WebDNA had a [duplicaterecord] tag, and the answer is no. Terry > >Is there a way to duplicate a product record, it has several entries in the >related .db for colour choice and size? > >I need an easy way to enter 18 diffferent colours as well as different sizes >without doing them one by one for some 300 new items > >Help or advice appreciated > >We are using a slightly modified version of the storebuilder -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightPods.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Paul, (I don't know anything about Storebuilder, so ignore this if it's not relevant.) I do something along these lines on one of my sites when I let the admin add a new record. They get a choice of adding a clean blank record and then fill it all in, or duping an existing one. For the dupe, I have them be on the record they're duping, but you could just as easily have them choose from a list and send that record's unique ID (Hmmm maybe I'll let them do it that way as well). Then, do a search to find the source record, and within the founditems, do a replace, and within that, a listfields with (the fieldnames wrapped in square brackets and interpret tags) = (the values wrapped in URL tags). Use Autonumber to set the unique field ID. For the inevitable fields that will be different (or why else would you dupe this?) you can precede the listfields with those values set to blank, or an incoming variable (they will override the same fieldnames that show later in the replace). Or just present the new record for editing on the next page and let the admin make changes there. For your related records, it depends on how they're related. If the product calls the color and size dbs, then that would automatically come along for the ride when you duped the record. If you were wondering if WebDNA had a [duplicaterecord] tag, and the answer is no. Terry > >Is there a way to duplicate a product record, it has several entries in the >related .db for colour choice and size? > >I need an easy way to enter 18 diffferent colours as well as different sizes >without doing them one by one for some 300 new items > >Help or advice appreciated > >We are using a slightly modified version of the storebuilder -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightPods.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Terry Wilson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Spaces inside [AppendFile] (1998)
More on the email templates (1997)
Bug or syntax error on my part? (1997)
Re:Emailer and encryption (1997)
[UPPERCASE] (1997)
ShipCosts database (1997)
Domain serial issue (2008)
Getting total number of items ordered (1997)
Country & Ship-to address & other fields ? (1997)
Limit picture size on upload (2005)
Extended [Concvertchars] needed (1997)
RE: incrementing a counter remotely? (1999)
Database not found in Include (2002)
PCS Frames (1997)
Harvesting invalid email addresses from bounced emails??? (2000)
WebTen and WebCat (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Using Plug-In while running 1.6.1 (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)