[#FC-921] Create Tables in Oracle Sql statement

FarCry Core Framework

Create Tables in Oracle Sql statement

Created: 24/Aug/07 03:35 AM Updated: 06/Oct/08 04:33 PM

Component/s:

Installer & Updaters

Affects Version/s:

4.0.6

Fix Version/s:

FarCry 5.1

Time Tracking:

Not Specified

Description

« Hide

CREATE TABLE projectName.ruleNews( bArchive number default false NOT NULL , bMatchAllKeywords number default false NULL ,
datetimelastupdated date NULL ,
displayMethod varchar2(255) default 'displayTeaserBullets' NOT NULL ,
intro varchar2(255) default '' NULL ,
label nvarchar2(255) default '' NULL ,
metadata nclob default '' NULL ,
numItems number default 5 NOT NULL ,
numPages number default 1 NOT NULL ,
objectID varchar2(50) NOT NULL ,
suffix varchar2(255) default '' NULL )

******* the "false" in the 1st line must be "0" to create this table in both places
CREATE TABLE projectName.ruleNews( bArchive number default 0 NOT NULL , bMatchAllKeywords number default 0 NULL ,

All

Comments

Work Log

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Ian Redding - 24/Aug/07 04:59 AM

We fixed the bug on our end by placing an if statement in the file below
it created all our tables & got to the login screen,
but does not login with: u= farcry p= farcry
in table DMuser there is farcry in both fields?? but no login?

*** Fix Bug ***
File: FarCry\core\packages\fourq\gateway\OracleGateway.cfc

FIX ON LINE = 193
<cfif len(trim(defaultValue))>

<cfif trim(defaultValue) is "true">
<cfset defaultValue = "default 1" />
<cfelseif trim(defaultValue) is "false">
<cfset defaultValue = "default 0" />
<cfelse>
<cfset defaultValue = "default #defaultValue#" />
</cfif>

<cfelse>
<cfset defaultValue = "" />
</cfif>