Re: WebDNA tables and commas - the fix

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 60278
interpreted = N
texte = Thanks the comma hint got me thinking... The fix? First create the table [table name=timport&fields=t_idblock,t_blocktype,t_blockdata1][/table] and use Append inside of the SQLResult ... [FoundItems] [Append table=timport]t_idblock=[idblock_]&t_blocktype=[blocktype_]&t_blockdata1 =[blockdata1_][/Append] [/FoundItems] Works fine. - Jim > What is the deal with WebDNA tables and commas. > > Then loading SQL fields into a table, the commas are gone. > > It this a feature, bug or what? > > [SQLResult result_ref=rs1] > [FoundItems] > [blockdata1_]
> [/FoundItems] > [/SQLResult] > > [blockdata1_] has commas > > [SQLResult result_ref=rs1] > [table name=timport&fields=t_idblock,t_blocktype,t_blockdata1][!] > [/!][FoundItems] > [idblock_],[blocktype_],[blockdata1_] > [/FoundItems][/table] > [/SQLResult] > [SQLRelease result_ref=rs1] > > [search table=timport&neT_IDBLOCKdatarq=[blank]] > [FoundItems] > [t_blockdata1] >
> [/FoundItems] > [/search] > > [t_blockdata1] now has no commas > ------------------------------------------------------------- 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: WebDNA tables and commas - the fix ( Jim Lanford 2004)
Thanks the comma hint got me thinking... The fix? First create the table [table name=timport&fields=t_idblock,t_blocktype,t_blockdata1][/table] and use Append inside of the SQLResult ... [founditems] [Append table=timport]t_idblock=[idblock_]&t_blocktype=[blocktype_]&t_blockdata1 =[blockdata1_][/Append] [/FoundItems] Works fine. - Jim > What is the deal with WebDNA tables and commas. > > Then loading SQL fields into a table, the commas are gone. > > It this a feature, bug or what? > > [SQLResult result_ref=rs1] > [founditems] > [blockdata1_]
> [/FoundItems] > [/SQLResult] > > [blockdata1_] has commas > > [SQLResult result_ref=rs1] > [table name=timport&fields=t_idblock,t_blocktype,t_blockdata1][!] > [/!][founditems] > [idblock_],[blocktype_],[blockdata1_] > [/FoundItems][/table] > [/SQLResult] > [SQLRelease result_ref=rs1] > > [search table=timport&neT_IDBLOCKdatarq=[blank]] > [founditems] > [t_blockdata1] >
> [/FoundItems] > [/search] > > [t_blockdata1] now has no commas > ------------------------------------------------------------- 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/ Jim Lanford

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:

bug in [SendMail] (1997) upgrade problem with users.db (1998) [WebDNA] WebDNA Upgrade Question - eCommerce (2009) WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997) Return records from another (1997) Prepaid monthly subscription order fulfillment question (2004) WebCatalog for Postcards ? (1997) WebCatalog Review (2001) X etc.... (1999) username = 115 (1999) Why is deleting so slow? (2002) Apache and Applescript (2004) WebTen and WebCat (1997) Clean Code: Rules for inserting keyboard returns? (1997) First postarg not taking in $Commands (1997) WC2b12: Yes, Formulas.db is for real (1997) I'm new be kind (1997) PageMaker/Quark to db (1999) Reloading adds items - how to prevent?? (1998) Exclude by date - multiple (1997)