Using MySQL and WebDNA

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58551
interpreted = N
texte = Hello, I'm going to use mySQL as a database for a website. Connect: [SQLConnect dbType=3DMySQL&host=3Dlocalhost&database=3Dcms&uid=3Droot&pwd=3D&conn_var= =3Dconn1][/SQLC onnect] Search record: [SQLExecute conn_ref=3Dconn1&result_var=3Drs2] SELECT *=20 FROM `website`=20 WHERE 1 AND `page` =3D '[page]' [/SQLExecute] View record: [SQLResult result_ref=3Drs2] [title] [/SQLResult] I want to update the record with a new title like this: [SQLExecute conn_ref=3Dconn1&result_var=3Drs3] UPDATE `website` SET `title` =3D '[url][title][/url]' [/SQLExecute] I keep trying but it's not working yet. Who's the answer to give commands to UPDATE and DELETE records? Greetings, Edwin Hoevers ------------------------------------------------------------- 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: Using MySQL and WebDNA ( "Erol Guneri" 2004)
  2. Using MySQL and WebDNA ( "Edwin Hoevers" 2004)
  3. Using MySQL and WebDNA ( "Edwin Hoevers" 2004)
Hello, I'm going to use mySQL as a database for a website. Connect: [SQLConnect dbType=3DMySQL&host=3Dlocalhost&database=3Dcms&uid=3Droot&pwd=3D&conn_var= =3Dconn1][/SQLC onnect] Search record: [SQLExecute conn_ref=3Dconn1&result_var=3Drs2] SELECT *=20 FROM `website`=20 WHERE 1 AND `page` =3D '[page]' [/SQLExecute] View record: [SQLResult result_ref=3Drs2] [title] [/SQLResult] I want to update the record with a new title like this: [SQLExecute conn_ref=3Dconn1&result_var=3Drs3] UPDATE `website` SET `title` =3D '[url][title][/url]' [/SQLExecute] I keep trying but it's not working yet. Who's the answer to give commands to UPDATE and DELETE records? Greetings, Edwin Hoevers ------------------------------------------------------------- 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:

RE: [taxRate] [TaxTotal] ? (1997) Hosting Services (1999) no word on MacAuthorize... (1997) [WebDNA] Query re: autonumber (2010) Help with WebCatalog (1998) Requiring that certain fields be completed (1997) Using [showif] (2000) serial number (1998) Format question WC Mac f3 (1997) breaking words (1997) PCS Emailer's role ? (1997) [WebDNA] CICADA (2009) [WebDNA] Error 500 with SUMM=T (2017) OT Big Brother (please ignore this sociological trivia) (2000) Online reference (1997) Refering page (1998) WCS Newbie question (1997) multiple search commands (1997) 404 error -- but wc code executes... (2001) spaces in [texta] (1998)