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:
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
MY SOLUTION.... Send massmail (2000)
Show if time tags (1997)
New Plug-in and Type 11 errors (1997)
Frames and WebCat (1997)
Sort Issue? (2000)
Searching an Email database (1997)
"Could not establish connection with module" (2005)
[OT] Merchant Accounts (2007)
WebCatalog NT (1996)
webcat nt (1997)
Separate SSL Server (1997)
Extended [ConvertChars] (1997)
listing [text] variables? (1999)
user flush db (2002)
database search help (2003)