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
<http://www.theprioryinn.co.uk/> www.theprioryinn.co.uk
"Dining in a 30 Mile Food Zone"
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
