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, butI'd put this on a test page:[SEARCH db=old.db&neskudata=[BLANK]][FOUNDITEMS][APPENDdb=new.db]NEWFIELD1=[OLDFIELD3]&NEWFIELD2=[OLDFIELD1]&NEWFIELD3=[OLDFIELD2][/APPEND][/FOUNDITEMS][/SEARCH]Hit the test page with a browser, and you'll have transferred the info.MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark Horse Comics, Inc. *By web!: http://www.dhorse.com/
Associated Messages, from the most recent to the oldest:
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, butI'd put this on a test page:[SEARCH db=old.db&neskudata=[BLANK]]
[founditems][APPENDdb=new.db]NEWFIELD1=[OLDFIELD3]&NEWFIELD2=[OLDFIELD1]&NEWFIELD3=[OLDFIELD2][/APPEND][/FOUNDITEMS][/SEARCH]Hit the test page with a browser, and you'll have transferred the info.MichaelMichael Winston *By Phone!: (503)/652/8815 x341Internet Coordinator *By e-mail!: michaelw@dhorse.comDark 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)