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:

RequiredFields parameter (1998) How to Sort Summ data ? (1997) HUGE DATABASES (1998) SQL db type (2006) Need help (1998) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) [ModDate] & [ModTime] ? (1997) RE: Automatic thumbnail images (1998) quantity minimum problem (1997) off topic fetch vs PCS photomaster (1997) textA (1998) Where's Cart Created ? (1997) [WebDNA] Some code inside a large loops fail ... but why? (2010) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) two unique banners on one page (1997) quitting (1997) Dr.Watson Error (1999) [taxRate] [TaxTotal] ? (1997) Searchable WebCat (etc.) Docs ? (1997) log out (2001)