Re: [dabo-users] Y2K issue with date fields and multi line text fields

Author: Dave Kelly

Posted: 2012-06-20 at 02:53:40

I just realised that you might have a text only email. You can see all the

screen shots here: http://theprioryinn.co.uk/specials/dabo.aspx.

Thanks!

Dave Kelly

The Priory Inn

01666 502 251

www.theprioryinn.co.uk

"Dining in a 30 Mile Food Zone"

-----Original Message-----

From: dabo-users-bounces@leafe.com [mailto:dabo-users-bounces@leafe.com] On

Behalf Of dave@theprioryinn.co.uk

Sent: 20 June 2012 08:18

To: Dabo Users list

Subject: Re: [dabo-users] Y2K issue with date fields and multi line text

fields

Regarding the date field,

I have attached 4 screen shots. They show before and after an update of

birth_date. The interesting thing is that if you change a date after 1970,

it defaults to the 1900s. If birth_date is changed before 1970, it defaults

to the 2000s.

As you can see from the screen shot, Dabo is only seeking a two digit date.

Thanks for all your help!

On Tue 19/06/12 9:47 PM , Ed Leafe ed@leafe.com sent:

> On Jun 19, 2012, at 11:24 AM, Dave Kelly wrote:

>

> > The Problem is, the date field only accepts two

> digit dates. When I put in> birth dates, they default to the 2000's.

> Therefore, my birthdate in the> database becomes 2064 rather than

> 1964. How do I fix this?

> I'm not sure I understand - what do you mean by "the date field only

> accepts two digit dates"? A dDateTextBox should default to 4-digit

> years.

> > I have an address field which is a varchar(255).

> I exported this from a> Microsoft Access database to Postgres and it

> has multiple lines separated by> crlf. It displays fine in PgAdmin

> III on Linux Mint but in a Dabo text> field it is all on one line with

> an unprintable character between what> should be the lines. How can I

> make this display properly?

> Hmmm... looks like something strange is going on. I just took a

> dEditBox, and set its Value to:r"\n".join(['foo', 'bar', 'baz'])

>

> I would expect this to show the three words all on separate lines, but

> instead it's showing "foo\nbar\nbaz". I'll have to dig into the code

> to see where it is escaping the newline character.

>

> -- Ed Leafe

>

>

>

> _______________________________________________

> Post Messages to: Dabo-use

> rs@leafe.comSubscription Maintenance:

http://leafe.com/mailman/listinfo/dabo-usersSearchable Archives:

http://leafe.com/archives/search/dabo-usersThis message:

http://leafe.com/archives/byMID/EAD78632-FA51-

468B-8EC8-C9ADD96A849C@leafe.com

>

>

>

--- StripMime Report -- processed MIME parts --- multipart/mixed

text/plain (text body -- kept)

image/png

image/png

image/png

image/png

---

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message:

http://leafe.com/archives/byMID/16346.1340176656@theprioryinn.co.uk

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/000301cd4eb9$cec51070$6c4f3150$@theprioryinn.co.uk

©2012 Dave Kelly