Re: Using MySQL and WebDNA

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58553
interpreted = N
texte = Do you need to add a where statement in your update? ----- Original Message ----- From: "Edwin Hoevers" To: "WebDNA Talk" Sent: Wednesday, June 23, 2004 11:56 AM Subject: Using MySQL and WebDNA > Hello, > > I'm going to use mySQL as a database for a website. > > Connect: > [SQLConnect > dbType=MySQL&host=localhost&database=cms&uid=root&pwd=&conn_var=conn1][/SQLC > onnect] > > Search record: > [SQLExecute conn_ref=conn1&result_var=rs2] > SELECT * > FROM `website` > WHERE 1 AND `page` = '[page]' > [/SQLExecute] > > View record: > [SQLResult result_ref=rs2] > [title] > [/SQLResult] > > I want to update the record with a new title like this: > [SQLExecute conn_ref=conn1&result_var=rs3] > UPDATE `website` SET `title` = '[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/ > ------------------------------------------------------------- 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)
Do you need to add a where statement in your update? ----- Original Message ----- From: "Edwin Hoevers" To: "WebDNA Talk" Sent: Wednesday, June 23, 2004 11:56 AM Subject: Using MySQL and WebDNA > Hello, > > I'm going to use mySQL as a database for a website. > > Connect: > [SQLConnect > dbType=MySQL&host=localhost&database=cms&uid=root&pwd=&conn_var=conn1][/SQLC > onnect] > > Search record: > [SQLExecute conn_ref=conn1&result_var=rs2] > SELECT * > FROM `website` > WHERE 1 AND `page` = '[page]' > [/SQLExecute] > > View record: > [SQLResult result_ref=rs2] > [title] > [/SQLResult] > > I want to update the record with a new title like this: > [SQLExecute conn_ref=conn1&result_var=rs3] > UPDATE `website` SET `title` = '[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/ > ------------------------------------------------------------- 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/ "Erol Guneri"

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:

New WebCatalog Version !!! (1997) Searchable WebCat (etc.) Docs ? (1997) Emailer tracking (1997) Running 2 two WebCatalog.acgi's (1996) CloseDatabase (1997) Pithy questions on webcommerce & siteedit (1997) standard vs intertwined multithreading (1999) RED QUESTION MARKS AGAIN (1999) I'm tired of all this! (2000) calculate age (2003) Sorting by date (1997) syntax question, not in online refernce (1997) Something about defining variables (1998) Not really WebCat - need HTML Grider (1997) Verifying and adding new users (1997) failed installs on OS X Server 10.2.6/XServe/WebStar (2003) emailer (1997) Displaying xx number of characters (1997) [WebDNA] mac osx permissions problem (2010) Good vs. Bad; also [setHeader] (2002)