Re: Appending Information from one db to another

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 15922
interpreted = N
texte = At 1:40 AM -0800 1/5/98, Ray Hatch is rumored to have typed: > I'm trying to append some information from one database to another. > It was a database I had started and changed my mind on using, yet need to > info into my master db. > > The problem is I placed everything in a different order that my master db so > I can't just cut and paste. > > The other problem is my database has HTML coding in it. When I try to pull > the record into a hidden field of a form, then append it to my master db. > The HTML isn't carried over, as a matter of fact, it is show on the screen > to me even though it is inside a hidden field.I don't know why you're pulling the (old?) database info into a form, but I'd put this on a test page:[SEARCH db=old.db&neskudata=[BLANK]] [FOUNDITEMS] [APPEND db=new.db]NEWFIELD1=[OLDFIELD3]&NEWFIELD2=[OLDFIELD1]&NEWFIELD3=[OLDFIELD2][/APP END] [/FOUNDITEMS] [/SEARCH]Hit the test page with a browser, and you'll have transferred the info.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Appending Information from one db to another (Michael Winston 1998)
  2. Re: Appending Information from one db to another (John Hill 1998)
  3. Appending Information from one db to another (Ray Hatch 1998)
At 1:40 AM -0800 1/5/98, Ray Hatch is rumored to have typed: > I'm trying to append some information from one database to another. > It was a database I had started and changed my mind on using, yet need to > info into my master db. > > The problem is I placed everything in a different order that my master db so > I can't just cut and paste. > > The other problem is my database has HTML coding in it. When I try to pull > the record into a hidden field of a form, then append it to my master db. > The HTML isn't carried over, as a matter of fact, it is show on the screen > to me even though it is inside a hidden field.I don't know why you're pulling the (old?) database info into a form, but I'd put this on a test page:[SEARCH db=old.db&neskudata=[BLANK]] [founditems] [APPEND db=new.db]NEWFIELD1=[OLDFIELD3]&NEWFIELD2=[OLDFIELD1]&NEWFIELD3=[OLDFIELD2][/APP END] [/FOUNDITEMS] [/SEARCH]Hit the test page with a browser, and you'll have transferred the info.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ Michael Winston

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:

Date or time comparisons have bugs ... (1998) How old am I? (2004) SFTP (2004) [TEST] - Please Ignore (2000) FM and Webcat together? (1998) Using Currencies other than Dollars (1997) [WebDNA] shopping sites and the "old commerce tags" (2012) [ModDate] & [ModTime] ? (1997) Batch upload (2005) [WebDNA] WebDNA future (2010) Further on formula.db failure to calculate shipCost (1997) # fields limited? (1997) Next (1997) psst (1997) Never ending problem.... (2000) Credit Card Checksum (1997) [WebDNA] Error installing v6.2 on Ubuntu 10.10 ... (2010) Separate SSL Server (1997) Setting up shop (1997) Multiple fields on 1 input (1997)