Thanks for your responses John and Adrian. When I set the textbox as a dDateTextBox it displays <None> but the other TBs display correctly,but they are not linked to date fields plus their textboxes are derived from the dTextBox class. I checked the MySQL table structure and the field in question is definitely a DATE data type. I'm wondering if dDateTextbox is looking for a DATETIME, not a DATE?
Any ideas appreciated. On Thu, Oct 29, 2009 at 9:00 AM, <[email protected]> wrote: > Send Dabo-users mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://leafe.com/mailman/listinfo/dabo-users > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Dabo-users digest..." > > > Today's Topics: > > 1. Re: Problem with dDateTextBox (Adrian Klaver) > 2. Re: Problem with dDateTextBox (John) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 29 Oct 2009 08:19:04 -0700 > From: Adrian Klaver <[email protected]> > Subject: Re: [dabo-users] Problem with dDateTextBox > To: Dabo Users list <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > On Monday 26 October 2009 6:42:23 pm Steve Rose wrote: > > I have a form in which one of the textboxes displays a date value from a > > MySQL table. If I create the textbox like this: > > dateTB = > > > dabo.ui.dTextBox(self,RegID='dateTB',DataSource=bzs,DataField='S_Date',Widt > >h=80), the date displays correctly. However, if I try to create a textbox > > from a dDateTextBox class like this: > > dateTB = > > > dabo.ui.dDateTextBox(self,RegID='dateTB',DataSource=bzs,DataField='S_Date', > >Width=80), the textbox displays <None>. What is different about the > > dDateTextBox class that might cause this problem? > > Is it displaying <None> for all values in the table? > > > > > Platform: Win > > Python Version: 2.5.1 on win32 > > Dabo Version: Version 0.9.2; Revision ~5437 > > UI Version: 2.8.7.1 on wxMSW > > > > Steve Rose > > > > > > > > > -- > Adrian Klaver > [email protected] > > > > > ------------------------------ > > Message: 2 > Date: Thu, 29 Oct 2009 08:27:15 -0700 > From: John <[email protected]> > Subject: Re: [dabo-users] Problem with dDateTextBox > To: Dabo Users list <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > On Monday 26 October 2009 06:42:23 pm Steve Rose wrote: > > I have a form in which one of the textboxes displays a date value from a > > MySQL table. If I create the textbox like this: > > dateTB = > > > dabo.ui.dTextBox(self,RegID='dateTB',DataSource=bzs,DataField='S_Date',Widt > >h=80), the date displays correctly. However, if I try to create a textbox > > from a dDateTextBox class like this: > > dateTB = > > > dabo.ui.dDateTextBox(self,RegID='dateTB',DataSource=bzs,DataField='S_Date', > >Width=80), the textbox displays <None>. What is different about the > > dDateTextBox class that might cause this problem? > > > > Platform: Win > > Python Version: 2.5.1 on win32 > > Dabo Version: Version 0.9.2; Revision ~5437 > > UI Version: 2.8.7.1 on wxMSW > > > > Steve Rose > > Just a guess could it be because the underlying data field(S_Date) is a > varchar and not a date field. > > Johnf > > > > > > > ------------------------------ > > _______________________________________________ > Dabo-users mailing list > [email protected] > http://leafe.com/mailman/listinfo/dabo-users > Searchable Archives: http://leafe.com/archives/search/dabo-users > > > End of Dabo-users Digest, Vol 64, Issue 40 > ****************************************** > --- 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]
