This is what I put in for Oracle -> 1970-01-01 <cfproperty ftseq="61" ftfieldset="Operational" name="builttodate" type="date" hint="The date the collection was last built to. Can be manually overridden to force collection to update from the specified point, based on typename datetimelastupdated." required="yes" default="1970-01-01" fttype="datetime" ftlabel="Built To date" />
On Wed, Mar 26, 2008 at 9:54 AM, modius <[EMAIL PROTECTED]> wrote: > > On Mar 26, 11:39 am, Bill Poff <[EMAIL PROTECTED]> wrote: > > I was able to deploy farVerityLog but ran into a bug when I tried to > > deploy farVerityCollection... > > > > The SQL query that is being run: > > > > CREATE TABLE DBO.farVerityCollection( bEnableSearch [int] default 0 > > NULL , builttodate [DATETIME] default 01-JAN-70 NOT NULL , > > > ...snip...8<... > > > > The error message that SQL Server is returning: > > > > The name 'JAN' is not permitted in this context. Only constants, > > expressions, or variables allowed here. Column names are not > > permitted. > > > > What is the best way to fix this issue so that the original bug is > > corrected? > > Looks like your database doesn't like the way the default value is > being nominated for builttodate. What database type and version are > you using? > > -- geoff > http://www.daemon.com.au/ > > > > -- AJ Mercer Web Log: http://webonix.net --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
