Using MySQL and WebDNA

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58550
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:

Error Lob.db records error message not name (1997) Images (2000) Displaying photo attached to first record (1997) MacActivity and PCS (1997) ThreadMem ignored? (1998) Version f1 status (1997) Transfering [text] variables (2000) [BULK] [WebDNA] [BULK] Console / WebDNA no connection to module (2011) Sendmail question (2002) Need relative path explanation (1997) Missing contexts on NT (1997) Search results templates (1996) Custom WebCat Prefs ... (1997) 5.0 tips etc (2003) Cart Question (1998) Auto Submit (2000) [redirect] question (2005) Editing two databases in one form using [replace]? (1998) Some Questions (1997) [Fwd: Rotating Banners ... (was LinkExchange)] (1997)