Re: [WebDNA] weekday question

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110739
interpreted = N
texte = --Apple-Mail=_61D41B27-3585-4B35-9642-98E5D1C37A4A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 IIRC, webdna converts carriage returns (and line feed, I assume) into = vertical tab char.. as it stores data into a webdna db ... for the = obvious reason that carriage return chars denote end of record and so a = field cannot contain a carriage return. On 2013-09-21, at 10:24 AM, Francisco A. Hirsch = wrote: > In the database I have to use, %0B is the carriage return for text = that was on a texarea > Francisco >=20 >> El 21/09/2013 a las 09:52 -0300, sgbccebu escribi=F3: >> On 09/21/2013, at 09:52 AM -0300, sgbccebu wrote: >>=20 >> [ConvertChars] >> This is the first line >> this will be the second line >> [/ConvertChars] >>=20 >> What code would you use in a db to detect the carriage return (above = sample),=20 >> so that it will be replaced with a

>>=20 >>=20 >> ---database.db-- >> from to >> \r

>> \n

>> %02

>> SP

>> %0B

>>=20 >>=20 >> Many thanks... >>=20 >> Jess >>=20 >>=20 >> On Mon, Sep 16, 2013 at 2:33 PM, Terry Wilson = wrote: >> Is there a setting in prefs that let's you say where the week starts? >>=20 >>=20 >> On Sun, 15 Sep 2013 17:27:45 -0300 >> "Francisco A. Hirsch" wrote: >> According to the 6.2 Manual (and = http://webdna.us/page.dna?numero=3D32) >> the format %w gives Weekday 0 (Sunday) - 6 (Saturday). >> Yet I get 0 (Saturday)- 6 (Friday) >> [text show=3DT]adate=3D09/24/13[/text] is a [math >> show=3DT]dayofweek=3D[format days_to_date >> %w][math]{[adate]}[/math][/format][/math] >> Am I doing something wrong or is it the manual? >> Francisco--------------------------------------------------------- >> 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 >>=20 >> --------------------------------------------------------- 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 >=20 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_61D41B27-3585-4B35-9642-98E5D1C37A4A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 IIRC, = webdna converts carriage returns (and line feed, I assume) into vertical = tab char.. as it stores data into a webdna db ... for the obvious reason = that carriage return chars denote end of record and so a field cannot = contain a carriage return.


On 2013-09-21, at 10:24 AM, = Francisco A. Hirsch <listas.hirsch@gmail.com> = wrote:

In the database I = have to use, %0B is the carriage return for text that was on a = texarea
Francisco

El = 21/09/2013 a las 09:52 -0300, sgbccebu escribi=F3:
On 09/21/2013, at = 09:52 AM -0300, sgbccebu wrote:

[ConvertChars]
This is the first line
this = will be the second line
[/ConvertChars]

What code would you = use in a db to detect the carriage return (above sample),
so that it = will be replaced with a <p>


---database.db--
from    = to
\r    <p>
\n    = <p>
%02    <p>
SP    = <p>
%0B    <p>


Many = thanks...

Jess


On Mon, Sep 16, 2013 at 2:33 PM, Terry = Wilson <terry@terryfic.com> = wrote:
Is there a setting in prefs that let's you say where the week = starts?


On Sun, 15 Sep 2013 17:27:45 -0300
 "Francisco A. Hirsch" <listas.hirsch@gmail.com> wrote:
 According to the 6.2 Manual (and http://webdna.us/page.dna?numero=3D32)
the format %w gives Weekday 0 (Sunday) - 6 (Saturday).
 Yet I get 0 (Saturday)- 6 (Friday)
 [text show=3DT]adate=3D09/24/13[/text] is a [math
show=3DT]dayofweek=3D[format days_to_date
%w][math]{[adate]}[/math][/format][/math]
 Am I doing something wrong or is it the manual?
= Francisco---------------------------------------------------= ------
 This message is sent to you because you are subscribed 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 Reporting: support@webdna.us
---------------------------------------------------------
This message is sent to you because you are subscribed 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 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/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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_61D41B27-3585-4B35-9642-98E5D1C37A4A-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] weekday question (Tom Duke 2013)
  2. Re: [WebDNA] weekday question (John Butler 2013)
  3. Re: [WebDNA] weekday question ("Francisco A. Hirsch" 2013)
  4. Re: [WebDNA] weekday question (sgbccebu 2013)
  5. Re: [WebDNA] weekday question ("Terry Wilson" 2013)
  6. Re: [WebDNA] weekday question ("Francisco A. Hirsch" 2013)
  7. Re: [WebDNA] weekday question (Steve Raslevich 2013)
  8. [WebDNA] weekday question ("Francisco A. Hirsch" 2013)
--Apple-Mail=_61D41B27-3585-4B35-9642-98E5D1C37A4A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 IIRC, webdna converts carriage returns (and line feed, I assume) into = vertical tab char.. as it stores data into a webdna db ... for the = obvious reason that carriage return chars denote end of record and so a = field cannot contain a carriage return. On 2013-09-21, at 10:24 AM, Francisco A. Hirsch = wrote: > In the database I have to use, %0B is the carriage return for text = that was on a texarea > Francisco >=20 >> El 21/09/2013 a las 09:52 -0300, sgbccebu escribi=F3: >> On 09/21/2013, at 09:52 AM -0300, sgbccebu wrote: >>=20 >> [convertchars] >> This is the first line >> this will be the second line >> [/ConvertChars] >>=20 >> What code would you use in a db to detect the carriage return (above = sample),=20 >> so that it will be replaced with a

>>=20 >>=20 >> ---database.db-- >> from to >> \r

>> \n

>> %02

>> SP

>> %0B

>>=20 >>=20 >> Many thanks... >>=20 >> Jess >>=20 >>=20 >> On Mon, Sep 16, 2013 at 2:33 PM, Terry Wilson = wrote: >> Is there a setting in prefs that let's you say where the week starts? >>=20 >>=20 >> On Sun, 15 Sep 2013 17:27:45 -0300 >> "Francisco A. Hirsch" wrote: >> According to the 6.2 Manual (and = http://webdna.us/page.dna?numero=3D32) >> the format %w gives Weekday 0 (Sunday) - 6 (Saturday). >> Yet I get 0 (Saturday)- 6 (Friday) >> [text show=3DT]adate=3D09/24/13[/text] is a [math >> show=3DT]dayofweek=3D[format days_to_date >> %w][math]{[adate]}[/math][/format][/math] >> Am I doing something wrong or is it the manual? >> Francisco--------------------------------------------------------- >> 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 >>=20 >> --------------------------------------------------------- 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 >=20 >=20 > --------------------------------------------------------- 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 --Apple-Mail=_61D41B27-3585-4B35-9642-98E5D1C37A4A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 IIRC, = webdna converts carriage returns (and line feed, I assume) into vertical = tab char.. as it stores data into a webdna db ... for the obvious reason = that carriage return chars denote end of record and so a field cannot = contain a carriage return.


On 2013-09-21, at 10:24 AM, = Francisco A. Hirsch <listas.hirsch@gmail.com> = wrote:

In the database I = have to use, %0B is the carriage return for text that was on a = texarea
Francisco

El = 21/09/2013 a las 09:52 -0300, sgbccebu escribi=F3:
On 09/21/2013, at = 09:52 AM -0300, sgbccebu wrote:

[convertchars]
This is the first line
this = will be the second line
[/ConvertChars]

What code would you = use in a db to detect the carriage return (above sample),
so that it = will be replaced with a <p>


---database.db--
from    = to
\r    <p>
\n    = <p>
%02    <p>
SP    = <p>
%0B    <p>


Many = thanks...

Jess


On Mon, Sep 16, 2013 at 2:33 PM, Terry = Wilson <terry@terryfic.com> = wrote:
Is there a setting in prefs that let's you say where the week = starts?


On Sun, 15 Sep 2013 17:27:45 -0300
 "Francisco A. Hirsch" <listas.hirsch@gmail.com> wrote:
 According to the 6.2 Manual (and http://webdna.us/page.dna?numero=3D32)
the format %w gives Weekday 0 (Sunday) - 6 (Saturday).
 Yet I get 0 (Saturday)- 6 (Friday)
 [text show=3DT]adate=3D09/24/13[/text] is a [math
show=3DT]dayofweek=3D[format days_to_date
%w][math]{[adate]}[/math][/format][/math]
 Am I doing something wrong or is it the manual?
= Francisco---------------------------------------------------= ------
 This message is sent to you because you are subscribed 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 Reporting: support@webdna.us
---------------------------------------------------------
This message is sent to you because you are subscribed 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 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/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/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_61D41B27-3585-4B35-9642-98E5D1C37A4A-- John Butler

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:

hideif/showif causes error if wrapped around searches (2003) Weird bug, or is there something amiss? (1997) BBEdit and WebCatalog 2.0? (1997) WebDNA Running Out of RAM? (2004) SQL Error 22003 (2001) WebCat2 - Getting to the browser's username/password data (1997) HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) [format 40s]text[/format] doesn't work (1997) Stumpted Again (1997) BBEdit and WebCatalog 2.0? (1997) Sherlock plug-in? (1999) NT Email Stops Sending (2000) TRAINING videos - Prove IT. (1998) Round UP to nearest 100 (2007) OT: Quick poll (2003) Variables in a Prefernce File (2005) Date Sorting (1997) [showif [math (1999) Re[2]: Fields (2000) Rookie/New User Question (2003)