Re: Move WebDNA DB to MySQL

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60746
interpreted = N
texte = Try this LOAD DATA INfile 'c:/blah/blah.txt' INTO TABLE xyz IGNORE 1 LINES Sal D'Anna -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Clint Davis Sent: Tuesday, January 11, 2005 2:38 PM To: WebDNA Talk Subject: Move WebDNA DB to MySQL I want to move a tab-delimited members database that WebDNA was using to a MySQL database. What would be the proper syntax to search the tab-delimited file with WebDNA and INSERT all founditems into the MySQL database? Is the methodology below acceptable? [SQLConnect dbType=MySQL&host=xxx&database=xxx&uid=xxx&pwd=xxx&conn_var=conn1] [/SQLConnect] [search db=my.db&neIDdata=find_all] [founditems] [SQLExecute conn_ref=conn1&result_var=rs1] INSERT INTO xxx VALUES ('[value1]', '[value2]', '[value3]', '[value4]') [/SQLExecute] [/founditems] [/search] Is there a better/easier way to INSERT multiple rows? --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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: Move WebDNA DB to MySQL ( "Sal D'Anna" 2005)
  2. Re: Move WebDNA DB to MySQL ( Larry Hewitt 2005)
  3. Re: Move WebDNA DB to MySQL ( Larry Hewitt 2005)
  4. Re: Move WebDNA DB to MySQL ( William DeVaul 2005)
  5. Re: Move WebDNA DB to MySQL ( "Nitai @ ComputerOil" 2005)
  6. Move WebDNA DB to MySQL ( Clint Davis 2005)
Try this LOAD DATA INfile 'c:/blah/blah.txt' INTO TABLE xyz IGNORE 1 LINES Sal D'Anna -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Clint Davis Sent: Tuesday, January 11, 2005 2:38 PM To: WebDNA Talk Subject: Move WebDNA DB to MySQL I want to move a tab-delimited members database that WebDNA was using to a MySQL database. What would be the proper syntax to search the tab-delimited file with WebDNA and INSERT all founditems into the MySQL database? Is the methodology below acceptable? [SQLConnect dbType=MySQL&host=xxx&database=xxx&uid=xxx&pwd=xxx&conn_var=conn1] [/SQLConnect] [search db=my.db&neIDdata=find_all] [founditems] [SQLExecute conn_ref=conn1&result_var=rs1] INSERT INTO xxx VALUES ('[value1]', '[value2]', '[value3]', '[value4]') [/SQLExecute] [/founditems] [/search] Is there a better/easier way to INSERT multiple rows? --------------------------------------------------------------------- Clint Davis Webmaster / Interactive Media Specialist Gray Loon Marketing Group, Inc. http://www.grayloon.com 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 --------------------------------------------------------------------- ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ "Sal D'Anna"

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:

[WriteFile] problems (1997) Phantom Sendmail (2005) Has anyone used WebCatalog with CGatePro? (2000) Multi-processor Mac info ... (1997) Variables for chat (1997) Inventory Adjustment (2000) Universal db access template ... (2002) Summary search -- speed (1997) Nested tags count question (1997) Not Authorised Adding Items (1998) Preliminary Vendor Solicitation (2004) Project 2 (1998) WebCat2 - Getting to the browser's username/password data (1997) [WebDNA] Happy Friday (2016) Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997) WebCat2 several catalogs? (1997) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) using WebCat for Associate Programs? (1998) search/showif issues (2000) New Calendar Snippet (1998)