What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: [WebDNA] [table] and COMMA in a Field

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112139
interpreted = N
texte = --001a113363f4d8b7e105104cfe4c Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Palle, Hi - the safest way I have found to do this is outlined below. Commas have to be URL'd into the table or else they with be interpreted as field delimiters. - Tom [table name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_ db_image,front_db_user_creater,front_db_news_headline,front_db_news_content= ] [/table] [search db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D 1&allreqd=3DT&max=3D7][founditems] [append table=3Dfront_news][!] [/!]front_db_sku=3D[url][db_sku][/url][!] [/!]&fron_db_serial=3D[url][db_serial][/url][!] etc ... [/append] [/founditems][/search] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Digital Revolutionaries 1st Floor, Castleriver House 14-15 Parliament Street Temple Bar,Dublin 2 Ireland ---------------------------------------------- [t]: + 353 1 4403907 [e]: [w]: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On 2 March 2015 at 09:56, Palle Bo Nielsen wrote= : > Unfortunately no. > > The funny thing is that on another page I use a normal [search]=E2=80=A6 = to > retrieve the same data from the same DB with no issues at all. All COMMA= =E2=80=99s > are there as they should. > > It only happens when I use the code I posted [table]=E2=80=A6 > > All other characters like .-%&/ etc. is working just fine also using the > [table]... > > /Palle > > > On 02/03/2015, at 10.45, Stuart Tremain wrote: > > Does this help ? > > [URL][db_news_content][/URL] > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 2 Mar 2015, at 20:36, Palle Bo Nielsen > wrote: > > I tried this, as requested and the TABLE is still populated with data as > expected, which is good. > > But when I display the content, them all COMMAS is still omitted. > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7] > [table > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_user_creater,front_db_news_headline,front_db_news_content] > [founditems][db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content][/founditems] > [/table] > [/search] > > *** thinking *** > > /Palle > > > > On 02/03/2015, at 10.26, Stuart Tremain wrote: > > Try this > > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7] > > [table > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_user_creater,front_db_news_headline,front_db_news_content] > [founditems][db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content] > [/founditems] > [/table] > > [/search] > > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 2 Mar 2015, at 20:17, Palle Bo Nielsen > wrote: > > Hi Terry > > From the DOCs on WebDNA.US > > =E2=80=94 SNIP > > [*table* name=3D*yourtablename*&fields=3D*field1,field12,field3*] > *value* *value* *value* > *value* *value* *value* > *value* *value* *value* > [*/table*] > > =E2=80=94 /SNIP > > I read this, as the the TABLE values are Set with in th TABLE and the > /TABLE tags. I would expect all the values in this example to be set by > either a Search, As I did or any other algorithm (like Listchars, which i= s > exemplified in the Docs as well), within the Table and /table tags... > > /Palle > > > On 02/03/2015, at 08.52, Terry Nair wrote: > > I believe you cannot do a search within the table tags. Create the table > with no data in it, then have the search extraction part outside the tabl= e > where what is found is appended to the table. Then, you can do your 2nd > level 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:19 > To: talk@webdna.us > Subject: Re: [WebDNA] [table] and COMMA in a Field > > Hi > > Posting the actual code. Appreciate the help. > > ### SNIP START ### > > [table > > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_ > user_creater,front_db_news_headline,front_db_news_content] > > [search > > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7][fo > unditems] > [db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content] > [/founditems][/search] > > [/table] > > > [search > > table=3Dfront_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1= &max=3D5][f > ounditems] > >
[front_db_news_headline]
>
> > [text]parse_db_news_content=3D[convertchars > > db=3D/databases/MynewsConversions.db][front_db_news_content][/convertchar= s][/t > ext] > [loop start=3D1&end=3D500][text]parse_db_news_content=3D[Middle > endbefore=3D

][parse_db_news_content][/Middle][/text][/loop] > [text]parse_db_news_content[/text] > [showif [FindString source=3D[front_db_news_content]&find=3D%0B%0B]>0] - = href=3D"/nyheder/?read=3D[front_db_sku]">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=3D132 > > Lets imagine the following field [table > name=3Djustaname&fields=3Dfield1,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=3Djustaname&fields=3Dfield1,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 lis= t > . > 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.us Bug Reporting: support@webdna.u= s > > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > --001a113363f4d8b7e105104cfe4c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Palle,

Hi - the safest way I have found= to do this is outlined below.=C2=A0 Commas have to be URL'd into the t= able or else they with be interpreted as field delimiters.

- Tom



[table name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_user_creater,front_db_news_head= line,front_db_news_content][/table]
[search db=3D/data= bases/news.db&db_publishdata=3D1&= amp;dedb_serialsort=3D1&allreqd= =3DT&max=3D7][founditems]
[append table=3Dfront_news][!]
=C2=A0 =C2=A0 =C2=A0[/!]front_db_sku=3D[url][db_sku][/url][!]<= /span>
=C2=A0 =C2=A0 =C2=A0[/!]&am= p;fron_db_serial=3D[url][db_serial][/= url][!]

=C2=A0 =C2=A0 =C2=A0etc ...
<= div>
[/append]
[/fo= unditems][/search]







=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
Digital Revolutionaries
1st Floor, Castleriver = House
14-15 Parliament Street
Temple Bar,Dublin 2
Ireland
-----= -----------------------------------------
[t]: + 353 1 4403907
[e]: &= lt;mailto:tom@r= evolutionaries.ie>
[w]: <http://www.revolutionaries.ie/>
=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

On 2 March 2015 at 09:56, Palle Bo Nielsen <= span dir=3D"ltr"><powerpalle@powerpalle.dk> wrote:
Unfortunately no.

The funny thing is that on another page I use a norm= al [search]=E2=80=A6 to retrieve the same data from the same DB with no iss= ues at all. All COMMA=E2=80=99s are there as they should.

It only happens when I use the code I posted [table]=E2=80=A6
=

All other characters like .-%&/ etc. is working jus= t fine also using the [table]...

/Palle


On 02/03/2015, a= t 10.45, Stuart Tremain <webdna@idfk.com.au> wrote:

Does this help ?

[URL][db_news_content= ][/URL]



Kind regards

Stuart= Tremain
IDFK Web Developments
AUSTRALIA




On 2 Mar 2015, at 20:36, Palle Bo N= ielsen <po= werpalle@powerpalle.dk> wrote:

I tried this, as requested and the TABLE is still populat= ed with data as expected, which is good.

But when = I display the content, them all COMMAS is still omitted.

[search db=3D/databases/news.db&db_publishdata=3D1&dedb= _serialsort=3D1&allreqd=3DT&max=3D7]
[table name=3Dfront_= news&fields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_user= _creater,front_db_news_headline,front_db_news_content]
[founditem= s][db_sku][db_serial][db_image][db_user_creater][db_news_headline][db_news_= content][/founditems]
[/table]
[/search]

*** thinking ***

/Palle



On 02/03/2015, at 10.26, Stuart Tremain <webdna@idfk.com.au> wrote:

=
Try this


<= div>
[search db=3D/databases/news.db&db_publishdata=3D1&dedb_se= rialsort=3D1&allreqd=3DT&max=3D7]

[table n= ame=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,f= ront_db_user_creater,front_db_news_headline,front_db_news_content]
[founditems][db_sku][db_seri= al][db_image][db_user_creater][db_news_headline][db_news_content]
[/founditems]
[/table]
<= br>
[/search]



<= div>
Kind regards

Stuart= Tremain
IDFK Web Developments
AUSTRALIA




On 2 Mar 2015, at 20:17, Palle Bo N= ielsen <po= werpalle@powerpalle.dk> wrote:

Hi Terry

From the DOCs on WebDNA= .US

=E2=80=94 SNIP
[table name=3Dyourtablename&fields=3D=field1,field12,field3]
value value value
value value value
value = value value
[/table]
=E2=80=94= /SNIP

I read this, as the the TABLE values = are Set with in th TABLE and the /TABLE tags. I would expect all the values= in this example to be set by either a Search, As I did or any other algori= thm (like Listchars, which is exemplified in the Docs as well), within the = Table and /table tags...

/Palle


On 02/03/2015, at 08.5= 2, Terry Nair <terrynair@prism4u.com> wrote:

I believe you cannot d= o a search within the table tags. Create the table
with no data in it, t= hen have the search extraction part outside the table
where what is foun= d is appended to the table. Then, you can do your 2nd
level search on th= e 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:19
To: talk@webdna.us
Subject: Re: [WebDNA] [table] = and COMMA in a Field

Hi

Posting the actual code. Appreciate t= he help.

### SNIP START ###

[table
name=3Dfront_news&f= ields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_
user_creat= er,front_db_news_headline,front_db_news_content]

[search
db=3D/da= tabases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd= =3DT&max=3D7][fo
unditems]
[db_sku][db_serial][db_= image][db_user_creater]
[db= _news_headline][db_news_conten= t]
[/founditems][/search]

[/table]


[search
table=3D= front_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1&a= mp;max=3D5][f
ounditems]

<div class=3D"news_headline"= ;>[front_db_news_headline]</div>
<div class=3D"news_sub= line">

[text]parse_db_news_content=3D[convertchars
db=3D/= databases/MynewsConversions.db][front_db_news_content][/convertchars][/text]
[loop start=3D1&end=3D500][text]parse_db_news_content=3D[Middl= e
endbefore=3D<BR><BR>][parse_db_news_content][/Middle][/tex= t][/loop]
[text]parse_db_news_content[/text]
[showif [FindString sour= ce=3D[front_db_news_content]&find=3D%0B%0B]>0] - <a
href=3D&qu= ot;/nyheder/?read=3D[front_db_sku]">l&aelig;s mere</A>[/s= howif]

<= br></div>

[/founditems]
[/search]

### SNIP END ###
/Palle


On 01/03/2015, at 22.54, = Kenneth Grome <ken@webdnasolutions.com> 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.c= om
Web Database Systems and Linux Server Management


On 03= /01/2015 03:00 PM, Palle Bo Nielsen wrote:
Goo= d evening all,

I have never had this experience before, so now I nee= d to understand
if I am wrong or if WebDNA acts unexpected.

It&#= 39;s all about the [table] tag as referred to @
http://www.webdna.us/page.= dna?numero=3D132

Lets imagine the following field [table
nam= e=3Djustaname&fields=3Dfield1,field2,field]

I append a text (&qu= ot;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 an= d
another comma"), without the comma characters?

Why is tha= t??? Is the comma character not allowed due to the comma
seperation in = [table name=3Djustaname&fields=3Dfield1,field2,field] ??

/Palle<= br>--------------------------------------------------------- This
messa= ge is sent to you because you are subscribed to the mailing list
. To u= nsubscribe, E-mail to: archives:
http://mail.webdna.us/list/talk@webdna.us<= /a> Bug Reporting:
support@webdna.us
-----------------------------------= ----------------------
This message is sent to you because you are subsc= ribed to the mailing
list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives:
http://mail.webdna.us/list/talk@webdna.us
Bug Repor= ting: support@webdna= .us

-----------------------------------------------= ----------
This message is sent to you because you are subscribed to the= mailing list
<ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
arch= ives: 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 <talk@webdna.us>.
T= o unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/l= ist/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: suppo= rt@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: suppo= rt@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: suppo= rt@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: suppo= rt@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: suppo= rt@webdna.us

--001a113363f4d8b7e105104cfe4c-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  2. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  3. Re: [WebDNA] [table] and COMMA in a Field (Kenneth Grome 2015)
  4. Re: [WebDNA] [table] and COMMA in a Field (Tom Duke 2015)
  5. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  6. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  7. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  8. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  9. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  10. RE: [WebDNA] [table] and COMMA in a Field ("Terry Nair" 2015)
  11. Re: [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
  12. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  13. Re: [WebDNA] [table] and COMMA in a Field (Terry Wilson 2015)
  14. Re: [WebDNA] [table] and COMMA in a Field (Stuart Tremain 2015)
  15. Re: [WebDNA] [table] and COMMA in a Field (Kenneth Grome 2015)
  16. [WebDNA] [table] and COMMA in a Field (Palle Bo Nielsen 2015)
--001a113363f4d8b7e105104cfe4c Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Palle, Hi - the safest way I have found to do this is outlined below. Commas have to be URL'd into the table or else they with be interpreted as field delimiters. - Tom [table name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_ db_image,front_db_user_creater,front_db_news_headline,front_db_news_content= ] [/table] [search db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D 1&allreqd=3DT&max=3D7][founditems] [append table=3Dfront_news][!] [/!]front_db_sku=3D[url][db_sku][/url][!] [/!]&fron_db_serial=3D[url][db_serial][/url][!] etc ... [/append] [/founditems][/search] =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Digital Revolutionaries 1st Floor, Castleriver House 14-15 Parliament Street Temple Bar,Dublin 2 Ireland ---------------------------------------------- [t]: + 353 1 4403907 [e]: [w]: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On 2 March 2015 at 09:56, Palle Bo Nielsen wrote= : > Unfortunately no. > > The funny thing is that on another page I use a normal [search]=E2=80=A6 = to > retrieve the same data from the same DB with no issues at all. All COMMA= =E2=80=99s > are there as they should. > > It only happens when I use the code I posted [table]=E2=80=A6 > > All other characters like .-%&/ etc. is working just fine also using the > [table]... > > /Palle > > > On 02/03/2015, at 10.45, Stuart Tremain wrote: > > Does this help ? > > [url][db_news_content][/URL] > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 2 Mar 2015, at 20:36, Palle Bo Nielsen > wrote: > > I tried this, as requested and the TABLE is still populated with data as > expected, which is good. > > But when I display the content, them all COMMAS is still omitted. > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7] > [table > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_user_creater,front_db_news_headline,front_db_news_content] > [founditems][db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content][/founditems] > [/table] > [/search] > > *** thinking *** > > /Palle > > > > On 02/03/2015, at 10.26, Stuart Tremain wrote: > > Try this > > > [search > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7] > > [table > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_user_creater,front_db_news_headline,front_db_news_content] > [founditems][db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content] > [/founditems] > [/table] > > [/search] > > > > > Kind regards > > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au > > > > > > On 2 Mar 2015, at 20:17, Palle Bo Nielsen > wrote: > > Hi Terry > > From the DOCs on WebDNA.US > > =E2=80=94 SNIP > > [*table* name=3D*yourtablename*&fields=3D*field1,field12,field3*] > *value* *value* *value* > *value* *value* *value* > *value* *value* *value* > [*/table*] > > =E2=80=94 /SNIP > > I read this, as the the TABLE values are Set with in th TABLE and the > /TABLE tags. I would expect all the values in this example to be set by > either a Search, As I did or any other algorithm (like Listchars, which i= s > exemplified in the Docs as well), within the Table and /table tags... > > /Palle > > > On 02/03/2015, at 08.52, Terry Nair wrote: > > I believe you cannot do a search within the table tags. Create the table > with no data in it, then have the search extraction part outside the tabl= e > where what is found is appended to the table. Then, you can do your 2nd > level 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:19 > To: talk@webdna.us > Subject: Re: [WebDNA] [table] and COMMA in a Field > > Hi > > Posting the actual code. Appreciate the help. > > ### SNIP START ### > > [table > > name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,fr= ont_db_ > user_creater,front_db_news_headline,front_db_news_content] > > [search > > db=3D/databases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd=3D= T&max=3D7][fo > unditems] > [db_sku] [db_serial] [db_image] [db_user_creater] > [db_news_headline] [db_news_content] > [/founditems][/search] > > [/table] > > > [search > > table=3Dfront_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1= &max=3D5][f > ounditems] > >
[front_db_news_headline]
>
> > [text]parse_db_news_content=3D[convertchars > > db=3D/databases/MynewsConversions.db][front_db_news_content][/convertchar= s][/t > ext] > [loop start=3D1&end=3D500][text]parse_db_news_content=3D[Middle > endbefore=3D

][parse_db_news_content][/Middle][/text][/loop] > [text]parse_db_news_content[/text] > [showif [FindString source=3D[front_db_news_content]&find=3D%0B%0B]>0] - = href=3D"/nyheder/?read=3D[front_db_sku]">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=3D132 > > Lets imagine the following field [table > name=3Djustaname&fields=3Dfield1,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=3Djustaname&fields=3Dfield1,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 lis= t > . > 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.us Bug Reporting: support@webdna.u= s > > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > > > --------------------------------------------------------- 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.u= s > --001a113363f4d8b7e105104cfe4c Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Palle,

Hi - the safest way I have found= to do this is outlined below.=C2=A0 Commas have to be URL'd into the t= able or else they with be interpreted as field delimiters.

- Tom



[table name=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_user_creater,front_db_news_head= line,front_db_news_content][/table]
[search db=3D/data= bases/news.db&db_publishdata=3D1&= amp;dedb_serialsort=3D1&allreqd= =3DT&max=3D7][founditems]
[append table=3Dfront_news][!]
=C2=A0 =C2=A0 =C2=A0[/!]front_db_sku=3D[url][db_sku][/url][!]<= /span>
=C2=A0 =C2=A0 =C2=A0[/!]&am= p;fron_db_serial=3D[url][db_serial][/= url][!]

=C2=A0 =C2=A0 =C2=A0etc ...
<= div>
[/append]
[/fo= unditems][/search]







=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D
Digital Revolutionaries
1st Floor, Castleriver = House
14-15 Parliament Street
Temple Bar,Dublin 2
Ireland
-----= -----------------------------------------
[t]: + 353 1 4403907
[e]: &= lt;mailto:tom@r= evolutionaries.ie>
[w]: <http://www.revolutionaries.ie/>
=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

On 2 March 2015 at 09:56, Palle Bo Nielsen <= span dir=3D"ltr"><powerpalle@powerpalle.dk> wrote:
Unfortunately no.

The funny thing is that on another page I use a norm= al [search]=E2=80=A6 to retrieve the same data from the same DB with no iss= ues at all. All COMMA=E2=80=99s are there as they should.

It only happens when I use the code I posted [table]=E2=80=A6
=

All other characters like .-%&/ etc. is working jus= t fine also using the [table]...

/Palle


On 02/03/2015, a= t 10.45, Stuart Tremain <webdna@idfk.com.au> wrote:

Does this help ?

[url][db_news_content= ][/URL]



Kind regards

Stuart= Tremain
IDFK Web Developments
AUSTRALIA




On 2 Mar 2015, at 20:36, Palle Bo N= ielsen <po= werpalle@powerpalle.dk> wrote:

I tried this, as requested and the TABLE is still populat= ed with data as expected, which is good.

But when = I display the content, them all COMMAS is still omitted.

[search db=3D/databases/news.db&db_publishdata=3D1&dedb= _serialsort=3D1&allreqd=3DT&max=3D7]
[table name=3Dfront_= news&fields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_user= _creater,front_db_news_headline,front_db_news_content]
[founditem= s][db_sku][db_serial][db_image][db_user_creater][db_news_headline][db_news_= content][/founditems]
[/table]
[/search]

*** thinking ***

/Palle



On 02/03/2015, at 10.26, Stuart Tremain <webdna@idfk.com.au> wrote:

=
Try this


<= div>
[search db=3D/databases/news.db&db_publishdata=3D1&dedb_se= rialsort=3D1&allreqd=3DT&max=3D7]

[table n= ame=3Dfront_news&fields=3Dfront_db_sku,front_db_serial,front_db_image,f= ront_db_user_creater,front_db_news_headline,front_db_news_content]
[founditems][db_sku][db_seri= al][db_image][db_user_creater][db_news_headline][db_news_content]
[/founditems]
[/table]
<= br>
[/search]



<= div>
Kind regards

Stuart= Tremain
IDFK Web Developments
AUSTRALIA




On 2 Mar 2015, at 20:17, Palle Bo N= ielsen <po= werpalle@powerpalle.dk> wrote:

Hi Terry

From the DOCs on WebDNA= .US

=E2=80=94 SNIP
[table name=3Dyourtablename&fields=3D=field1,field12,field3]
value value value
value value value
value = value value
[/table]
=E2=80=94= /SNIP

I read this, as the the TABLE values = are Set with in th TABLE and the /TABLE tags. I would expect all the values= in this example to be set by either a Search, As I did or any other algori= thm (like Listchars, which is exemplified in the Docs as well), within the = Table and /table tags...

/Palle


On 02/03/2015, at 08.5= 2, Terry Nair <terrynair@prism4u.com> wrote:

I believe you cannot d= o a search within the table tags. Create the table
with no data in it, t= hen have the search extraction part outside the table
where what is foun= d is appended to the table. Then, you can do your 2nd
level search on th= e 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:19
To: talk@webdna.us
Subject: Re: [WebDNA] [table] = and COMMA in a Field

Hi

Posting the actual code. Appreciate t= he help.

### SNIP START ###

[table
name=3Dfront_news&f= ields=3Dfront_db_sku,front_db_serial,front_db_image,front_db_
user_creat= er,front_db_news_headline,front_db_news_content]

[search
db=3D/da= tabases/news.db&db_publishdata=3D1&dedb_serialsort=3D1&allreqd= =3DT&max=3D7][fo
unditems]
[db_sku][db_serial][db_= image][db_user_creater]
[db= _news_headline][db_news_conten= t]
[/founditems][/search]

[/table]


[search
table=3D= front_news&nefront_db_skudata=3D[blank]&defront_db_serialsort=3D1&a= mp;max=3D5][f
ounditems]

<div class=3D"news_headline"= ;>[front_db_news_headline]</div>
<div class=3D"news_sub= line">

[text]parse_db_news_content=3D[convertchars
db=3D/= databases/MynewsConversions.db][front_db_news_content][/convertchars][/text]
[loop start=3D1&end=3D500][text]parse_db_news_content=3D[Middl= e
endbefore=3D<BR><BR>][parse_db_news_content][/Middle][/tex= t][/loop]
[text]parse_db_news_content[/text]
[showif [FindString sour= ce=3D[front_db_news_content]&find=3D%0B%0B]>0] - <a
href=3D&qu= ot;/nyheder/?read=3D[front_db_sku]">l&aelig;s mere</A>[/s= howif]

<= br></div>

[/founditems]
[/search]

### SNIP END ###
/Palle


On 01/03/2015, at 22.54, = Kenneth Grome <ken@webdnasolutions.com> 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.c= om
Web Database Systems and Linux Server Management


On 03= /01/2015 03:00 PM, Palle Bo Nielsen wrote:
Goo= d evening all,

I have never had this experience before, so now I nee= d to understand
if I am wrong or if WebDNA acts unexpected.

It&#= 39;s all about the [table] tag as referred to @
http://www.webdna.us/page.= dna?numero=3D132

Lets imagine the following field [table
nam= e=3Djustaname&fields=3Dfield1,field2,field]

I append a text (&qu= ot;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 an= d
another comma"), without the comma characters?

Why is tha= t??? Is the comma character not allowed due to the comma
seperation in = [table name=3Djustaname&fields=3Dfield1,field2,field] ??

/Palle<= br>--------------------------------------------------------- This
messa= ge is sent to you because you are subscribed to the mailing list
. To u= nsubscribe, E-mail to: archives:
http://mail.webdna.us/list/talk@webdna.us<= /a> Bug Reporting:
support@webdna.us
-----------------------------------= ----------------------
This message is sent to you because you are subsc= ribed to the mailing
list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives:
http://mail.webdna.us/list/talk@webdna.us
Bug Repor= ting: support@webdna= .us

-----------------------------------------------= ----------
This message is sent to you because you are subscribed to the= mailing list
<ta= lk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
arch= ives: 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 <talk@webdna.us>.
T= o unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/l= ist/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: suppo= rt@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: suppo= rt@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: suppo= rt@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: suppo= rt@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: suppo= rt@webdna.us

--001a113363f4d8b7e105104cfe4c-- Tom Duke

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:

It finally happened ... (2003) webcat2b12 CGI -- Date comparisons (1997) Possible Macv2.1b2 Merge Bug (1997) form data submission gets truncated (1997) [WebDNA] How to tidy up data extract ? (2013) WebDNA FAQ or FAQs -- was "weird problem" (2004) Authenticate (1997) [WebDNA] Finding duplicate records (2011) Default admin bug and how tech support reacted to it. (2000) carriage returns in data (1997) [WebDNA] Google Conversions (2011) 2nd Request for help/advice on variable pricing (2000) [WebDNA] Search Question (2009) Search Sort Random (2004) [Q] Novice's question (1997) Re:Help name our technology! (1997) Bug Report, maybe (1997) Last desperate attempt (1998) webcat NT (1998) Credit Card Number checking (1997)