Thanks Bill, Now I get a "ORA-00907: missing right parenthesis", apparenlty from this statement:
CREATE TABLE FARCRY.container( bShared number 0 NULL ,displayMethod nvarchar2(255) default '' NULL ,label nvarchar2(255) default '(unspecified)' NULL ,mirrorID varchar2(50) default '' NULL ,objectID varchar2(50) NOT NULL ) I just don't see where there could be a "missing" right parenthesis, but I'm not a sql guru, just a tired admin... Grrr... Do you see what is wrong here? Thanks a million! On Sep 7, 3:20 pm, Bill Bagent <[EMAIL PROTECTED]> wrote: > BBeru wrote: > > > Note the "default false" extra parameters > > The "default false" isn't an extra parameter. It should be default 0 > (that's zero) instead. Here's a fix from bowden (I can't find the post > right now) that worked for me. Add the following code to the > generateDeploymentSQLArray method of > core/packages/fourq/gateway/Oraclegateway.cfc. It is around line 192. Add > it right after "<cfif len(trim(defaultValue))>: > > <!--- added by bowden 8/23/2007 to prevent code error ---> > <cfif trim(defaultValue) is "true"> > <cfset defaultValue = "1" /> <!--- Bill changed from > "default 1" ---> > <cfelseif trim(defaultValue) is "false"> > <cfset defaultValue = "0" /><!--- Bill changed from > "default 0" ---> > <cfelse> > <cfset defaultValue = "#defaultValue#" /> <!--- changed > from "default #defaultValue#" ---> > </cfif> > <!--- end of add by bowden 8/23/2007 ---> > > bowden's code originally had defaultValue="default 1" and "default 0" in it > but that was putting something like "default default 1" in the sql. > > Regards, Bill > > -- > View this message in > context:http://www.nabble.com/FarCry-4.0.3-and-Oracle--anyone-successfully-in... > Sent from the FarCry - Dev mailing list archive at Nabble.com. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
