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:

&max= (2003) [LOOKUP] (1997) IE Cache Problems... (1999) Multiple servers and Webcat (1998) passing info to thankyou.tpl (1998) Maybe off topic but how to charge (1997) RE: [isfolder] and [filename] (1997) Mozilla/4. and Browser Info.txt (1997) sendmail logs (1999) Associative lookup style? (1997) File Upload (1997) Help name our technology! I found it (1997) Trouble with formula.db (1997) Calendar Program (2004) A quickie question (1997) Sorting error (1997) shipping costs (2000) WebCat2.0 acgi vs plugin (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Sorting error (1997)