Re: Move WebDNA DB to MySQL

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 60730
interpreted = N
texte = On Jan 11, 2005, at 5:37 PM, Clint Davis wrote: > 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? I highly recommend phpmyadmin if you are supporting mysql. ------------------------------------------------------------- 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)
On Jan 11, 2005, at 5:37 PM, Clint Davis wrote: > 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? I highly recommend phpmyadmin if you are supporting mysql. ------------------------------------------------------------- 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/ William DeVaul

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:

Reminder for beta testers (2000) Support ?? (1997) Pre-flight public flag (1997) ups quickcost [repost] (1999) Odd