RE: [WebDNA] [table] and COMMA in a Field
This WebDNA talk-list message is from 2015
It keeps the original formatting.
numero = 112133
interpreted = N
texte = I believe you cannot do a search within the table tags. Create the tablewith no data in it, then have the search extraction part outside the tablewhere what is found is appended to the table. Then, you can do your 2ndlevel search on the table filled with data you appended earlier.Cheers TDn-----Original Message-----From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk] Sent: Monday, March 02, 2015 15:19To: talk@webdna.usSubject: Re: [WebDNA] [table] and COMMA in a FieldHiPosting the actual code. Appreciate the help.### SNIP START ###[tablename=front_news&fields=front_db_sku,front_db_serial,front_db_image,front_db_user_creater,front_db_news_headline,front_db_news_content][searchdb=/databases/news.db&db_publishdata=1&dedb_serialsort=1&allreqd=T&max=7][founditems][db_sku][db_serial][db_image][db_user_creater][db_news_headline][db_news_content][/founditems][/search][/table][searchtable=front_news&nefront_db_skudata=[blank]&defront_db_serialsort=1&max=5][founditems]
[front_db_news_headline]
[text]parse_db_news_content=[convertcharsdb=/databases/MynewsConversions.db][front_db_news_content][/convertchars][/text][loop start=1&end=500][text]parse_db_news_content=[Middleendbefore=
][parse_db_news_content][/Middle][/text][/loop][text]parse_db_news_content[/text][showif [FindString source=[front_db_news_content]&find=%0B%0B]>0] -
læs mere[/showif]
[/founditems][/search]### SNIP END ###/Palle> On 01/03/2015, at 22.54, Kenneth Grome
wrote:> > Post your code so we know how you created the table and how you > attempted to append a record to it.> > Regards,> Kenneth Grome> WebDNA Solutions> http://www.webdnasolutions.com> Web Database Systems and Linux Server Management> > > On 03/01/2015 03:00 PM, Palle Bo Nielsen wrote:>> Good evening all,>> >> I have never had this experience before, so now I need to understand >> if I am wrong or if WebDNA acts unexpected.>> >> It's all about the [table] tag as referred to @>> http://www.webdna.us/page.dna?numero=132>> >> Lets imagine the following field [table >> name=justaname&fields=field1,field2,field]>> >> I append a text ("a text with a comma, inside and another, comma") in >> to FIELD1>> >> When I output FIELD1, then I get ("a text with a comma inside and >> another comma"), without the comma characters?>> >> Why is that??? Is the comma character not allowed due to the comma >> seperation in [table name=justaname&fields=field1,field2,field] ??>> >> /Palle>> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the mailing list >> . To unsubscribe, E-mail to: archives:>> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:>> support@webdna.us> ---------------------------------------------------------> This message is sent to you because you are subscribed to the mailing > list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed to the mailing list.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
I believe you cannot do a search within the table tags. Create the tablewith no data in it, then have the search extraction part outside the tablewhere what is found is appended to the table. Then, you can do your 2ndlevel search on the table filled with data you appended earlier.Cheers TDn-----Original Message-----From: Palle Bo Nielsen [mailto:powerpalle@powerpalle.dk] Sent: Monday, March 02, 2015 15:19To: talk@webdna.usSubject: Re: [WebDNA] [table] and COMMA in a FieldHiPosting the actual code. Appreciate the help.### SNIP START ###[tablename=front_news&fields=front_db_sku,front_db_serial,front_db_image,front_db_user_creater,front_db_news_headline,front_db_news_content][searchdb=/databases/news.db&db_publishdata=1&dedb_serialsort=1&allreqd=T&max=7][founditems][db_sku][db_serial][db_image][db_user_creater][db_news_headline][db_news_content][/founditems][/search][/table][searchtable=front_news&nefront_db_skudata=[blank]&defront_db_serialsort=1&max=5][founditems][front_db_news_headline]
[text]parse_db_news_content=[convertcharsdb=/databases/MynewsConversions.db][front_db_news_content][/convertchars][/text][loop start=1&end=500]
[text]parse_db_news_content=[Middleendbefore=
][parse_db_news_content][/Middle][/text][/loop]
[text]parse_db_news_content[/text][showif [FindString source=[front_db_news_content]&find=%0B%0B]>0] -
læs mere[/showif]
[/founditems][/search]### SNIP END ###/Palle> On 01/03/2015, at 22.54, Kenneth Grome wrote:> > Post your code so we know how you created the table and how you > attempted to append a record to it.> > Regards,> Kenneth Grome> WebDNA Solutions> http://www.webdnasolutions.com> Web Database Systems and Linux Server Management> > > On 03/01/2015 03:00 PM, Palle Bo Nielsen wrote:>> Good evening all,>> >> I have never had this experience before, so now I need to understand >> if I am wrong or if WebDNA acts unexpected.>> >> It's all about the [table] tag as referred to @>> http://www.webdna.us/page.dna?numero=132>> >> Lets imagine the following field [table >> name=justaname&fields=field1,field2,field]>> >> I append a text ("a text with a comma, inside and another, comma") in >> to FIELD1>> >> When I output FIELD1, then I get ("a text with a comma inside and >> another comma"), without the comma characters?>> >> Why is that??? Is the comma character not allowed due to the comma >> seperation in [table name=justaname&fields=field1,field2,field] ??>> >> /Palle>> --------------------------------------------------------- This >> message is sent to you because you are subscribed to the mailing list >> . To unsubscribe, E-mail to: archives:>> http://mail.webdna.us/list/talk@webdna.us Bug Reporting:>> support@webdna.us> ---------------------------------------------------------> This message is sent to you because you are subscribed to the mailing > list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed to the mailing list.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
"Terry Nair"
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:
passing large amount of text in post form (2005)
[addlineitems] (1997)
Okay, I give up... (1999)
[OT] degree symbol (2003)
searching results (1999)
Multiple catalog databases and showcart (1997)
ErrorMessages.db suggestion (1997)
Canada oh Canada (2004)
Sorting Numbers (1997)
sending graphics in HTML email via [sendmail]? (2000)
Help! WebCat2 bug (1997)
[WebDNA] Bug in decrypt method=Base64 (2012)
Resume Catalog ? (1997)
[include] and v.email (1998)
Multiple Newcarts (1996)
webcatalog [date] bug...not (1999)
Sorting by type=date (1999)
[group] ? (1997)
Major Security Hole (1998)
RE: Include (1998)