Re: Simple Database close connection
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39213
interpreted = N
texte = >This is stunningly simple, which is why I was surprised when it did not>work.>>>Have a scenario where updated databases are being FTP'd hourly to my server>(from an AS 400 system but that is another story ;-)>>These DB's are read only. Meaning that NO DATA is updated via the web. I am>certain of this because there is simply no templates doing anything but>searching them.>>So like a good WebDna'r I had intended on using a closedatabase or>flushdatabases tag to close down the ones in ram each hour and thus the>newly delivered db's would open at the next needed viewing.>I assume that the DB's have the same structure, and they should have a key field or two,Could you not just simply copy the new database up with a name like new.db and then merge the two using webcat?Something like...[search db=new.db&nekeydatarq=[cart]][founditems] [showif [lookup db=old.db&lookinfield=key&value=[key]¬found=ok]=ok] [append db=old.db]key=[key]&otherfield=[otherfield][/append] [/showif][/founditems][/search]-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>This is stunningly simple, which is why I was surprised when it did not>work.>>>Have a scenario where updated databases are being FTP'd hourly to my server>(from an AS 400 system but that is another story ;-)>>These DB's are read only. Meaning that NO DATA is updated via the web. I am>certain of this because there is simply no templates doing anything but>searching them.>>So like a good WebDna'r I had intended on using a closedatabase or>flushdatabases tag to close down the ones in ram each hour and thus the>newly delivered db's would open at the next needed viewing.>I assume that the DB's have the same structure, and they should have a key field or two,Could you not just simply copy the new database up with a name like new.db and then merge the two using webcat?Something like...[search db=new.db&nekeydatarq=[cart]][founditems] [showif [lookup db=old.db&lookinfield=key&value=[key]¬found=ok]=ok] [append db=old.db]key=[key]&otherfield=[otherfield][/append] [/showif][/founditems][/search]-------------------------------------------------------------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://search.smithmicro.com/
Samuel Renkert
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:
UnitShopCost (2007)
Navigator 4.01 (1997)
Multi-processor Mac info ... (1997)
No messages for a week? (2000)
simple forum/bboard (2004)
Sendmail Enigma (2004)
[WebDNA] lists opinion (2009)
(OT) SERVER FREEZES ALL AT SAME TIME (2004)
FAX orders (1996)
Automatic POST arg sending? (1998)
customizing the color of user's pages (1997)
Textarea (1998)
[browsername] not working? (1997)
SendNews (1999)
[Q] Novice's question (1997)
WebCatalog Technical Reference (1997)
[WebDNA] Mistake in web page instructions (2009)
Dreamweaver Extensions for WC (2000)
instant cookies? (1999)
multiple search commands (1997)