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

I am following along with the PyCon tutorial but using my own data from a

PostgreSQL database and I have a couple of newbie questions.

First Problem:

I have a date field in the Postgres database called birth_date. As per the

tutorial, I changed it to the following code:

## Field public.employees.birth_date

label = dabo.ui.dLabel(self, NameBase="lblbirth_date",

Caption=biz.getColCaption("birth_date"))

objectRef = dabo.ui.dDateTextBox(self, NameBase="birth_date",

DataSource="public.employees", DataField="birth_date",

ToolTipText=biz.getColToolTip("birth_date"),

HelpText=biz.getColHelpText("birth_date")

)

gs.append(label, alignment=("top", "right") )

gs.append(objectRef)

gs.append( (25, 1) )

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?

Second problem:

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?

Thanks for all your help and I am sorry if these questions are hopelessly

newbie.

Dave Kelly

The Priory Inn

"Dining in a 30 Mile Food Zone"

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: Dabo-users@leafe.com