CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Perl

 Date fields error in Search Form of a grid and solution

Print topic Send  topic

Author Message
roeya


Posts: 180
Posted: 07/31/2006, 7:13 AM

Date fields error in Search Form of a grid

When creating search form for a grid with conditions on date fields such as
after some date or before some date the results are wrong

We found the error when using Perl with SQLite database. The problem is that the date fields in the search form are not converted to the date format of the database itself (As defined in Projects - Settings -Connections -Modify -Server -Date Format: “yyyy-mm-dd HH:nn:ss”)

The value goes directly to the SQL query in the Date format of the field.

To correct this we used the following custom code in the before select event:

CCFormatDate(CCParseDate($value, @DefaultDateFormat), ('yyyy','-','mm','-','dd',' ','HH',':','nn',':','ss'))

This code converts the date to the correct format

We do not know if this error is Perl version only problem or general problem



_________________
http://www.infoneto.com/
View profile  Send private message
Last Hero
Posted: 08/01/2006, 2:47 AM

Do you have right settings in datasource where parameter?
FieldType = Date

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.