Database append/replace

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55893
interpreted = N
texte = Hi, I make a "easy to use" webdna code to append or replace data into a database. [!]Insert database name[/!] [text]dbname=../db/database.db][/text] [!]Insert location server home directory[/!] [text]server=/home/www.website.com/docs/HTML/db/[/text] [text]velden=[ListDatabases db=[dbname]][showif [name]=[server][dbname]][numFields][/showif][/ListDatabases][/text] [!]Replace[/!] [showif [go]=replace][replace db=[dbname]&eqSKUdata=[SKU][listfields db=[dbname]][fieldname]=[interpret][[fieldname]][/interpret][showif [index]![velden]]&[/showif][/listfields][/replace][/showif] [!]Append[/!] [showif [go]=append][append db=[dbname]&eqSKUdata=[SKU][listfields db=[dbname]][fieldname]=[interpret][[fieldname]][/interpret][showif [index]![velden]]&[/showif][/listfields][/append][/showif] Maybe usefull for you! Greetings, Edwin Hoevers The Netherlands ------------------------------------------------------------- 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:

    
  1. Re: Database append/replace ( Kenneth Grome 2004)
  2. Database append/replace ( "Edwin Hoevers" 2004)
Hi, I make a "easy to use" webdna code to append or replace data into a database. [!]Insert database name[/!] [text]dbname=../db/database.db][/text] [!]Insert location server home directory[/!] [text]server=/home/www.website.com/docs/HTML/db/[/text] [text]velden=[ListDatabases db=[dbname]][showif [name]=[server][dbname]][numFields][/showif][/ListDatabases][/text] [!]Replace[/!] [showif [go]=replace][replace db=[dbname]&eqSKUdata=[SKU][listfields db=[dbname]][fieldname]=[interpret][[fieldname]][/interpret][showif [index]![velden]]&[/showif][/listfields][/replace][/showif] [!]Append[/!] [showif [go]=append][append db=[dbname]&eqSKUdata=[SKU][listfields db=[dbname]][fieldname]=[interpret][[fieldname]][/interpret][showif [index]![velden]]&[/showif][/listfields][/append][/showif] Maybe usefull for you! Greetings, Edwin Hoevers The Netherlands ------------------------------------------------------------- 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/ "Edwin Hoevers"

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:

SSL do I need it?? (1998) Calculating Shipping (1997) Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997) Quickie question on the email templates (1997) WebCat2.0 [format thousands .0f] no go (1997) adding up in a db (1997) Generating Report Totals (1997) all records returned. (1997) 2.1b3 --> way slow (1997) WebCat2 - Getting to the browser's username/password data (1997) Secure Server (1997) Emailer setup (1997) unable to run webcatalog locally (1998) Max Record length (1997) RE: OK, here goes... (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WC 2.0 frames feature (1997) Cookies and webcat (1997) WC1.6 to WC2 date formatting (1997) Add to Cart & List of Products (1997)