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:

Re[3]: Field Problem (2000) Merging databases (1997) Append File help needed (2000) OFF-TOPIC...list serve software for newsletter? (1998) OT: Poll Results (2002) WebCatb15 Mac CGI -- [purchase] (1997) forms and variables (1998) There's a bug in the math context ... (1997) transferring values (1998) Suffix Mapping (1997) Locking up with WebCatalog... (1997) list cookies and list http headers (1997) Web Catalog 2 demo (1997) Creating folders and deleting files (1997) Navigator Parsing (1997) Physical Security for WebCatalog Directories (1997) If Else Statement... (2004) Where is f2? (1997) Signal Raised Error (1997) Timer Values on [redirect] (1998)