[mapguide-users] Theming Based on Dates

[Campbell, Keith A]

OK, it seems smalldatetime field types can be accessed, but I'm still
not able to use GETDATE() etc. I don' t suppose there are any inbuilt
functions in MG that will help? I've only seen one inbuilt function
mentioned - the 'concat' function for string manipulation.
 
Perhaps the SQL Server functions need to be altered in some way in order
to be passed on by MapGuide - e.g. the validate option in the Advanced
expression builder in Studio complains about the value for units in the
DATEDIFF function unless enclosed in single quotes. However, even when I
can get the expression to validate, it doesn't have the expected effect
in theming the layer (it appears to be ignored). Is there any guidance
on building correctly formatted expressions?
 
Keith

________________________________

From: Campbell, Keith A [mailto:keith.campbell at atkinsglobal.com] 
Sent: 25 October 2006 12:33
To: users at mapguide.osgeo.org
Subject: [mapguide-users] Theming Based on Dates



Is it possible to theme layers based on date values? If so, how is this
done? I have a layer with a join to a SQL Server table and I cannot
access datetime fields, nor SQL Server functions such as GETDATE() and
DATEDIFF(). Any ideas?

Keith 



This email and any attached files are confidential and copyright
protected. If you are not the addressee, any dissemination of this
communication is strictly prohibited. Unless otherwise expressly agreed
in writing, nothing stated in this communication shall be legally
binding. <http://www.blackspider.com/> 



This message has been scanned for viruses by MailControl
<http://bluepages.wsatkins.co.uk/?4318150> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061025/01ac7254/attachment.html