It caused me some grief yesterday when messing with Railo 3.1 nearcry trunk
2009/4/2 modius <[email protected]> > > On Apr 1, 4:22 pm, AJ Mercer <[email protected]> wrote: > > What is this qCheck code all about in *fqaudit.cfc*? > > Someone smoking crack? > > Looks a lot like some harmless detritus from refactoring. In any > event I think fqAudit is no more (well deprecated at least) from > FarCry 5.x onwards. Might be worth adding a bug and suggesting it be > removed. > > -- geoff > http://www.daemon.com.au/ > > > > <cffunction name="createTableMySQL" access="public" output="false" > > returntype="struct" hint="Create table; MySQL."> > > <cfargument name="bDropTable" default="true" type="boolean" > hint="Flag > > to drop table before creating." /> > > <cfset var stReturn = structNew() /> > > > > * <cfquery datasource="#variables.dsn#" name="qCheck"> > > SHOW TABLES LIKE 'fqAudit' > > </cfquery> > > > > <cfset result = ArrayNew(1)> > > > > <cfif IsDefined("qCheck.RecordCount") AND qCheck.RecordCount eq 1> > > <cfset result[1] = 1> > > <cfelse> > > <cfset QueryNew('qCheck')> > > <cfset QueryAddRow(qCheck)> > > <cfset result[1] = 0> > > </cfif> > > <cfset temp = QueryAddColumn(qCheck,'tblExists',result)>* > > > > <cfquery datasource="#variables.dsn#" name="qDrop"> > > DROP TABLE if exists #application.dbowner#fqAudit > > </cfquery> > > > > <!--- create the audit tables ---> > > <cfquery datasource="#variables.dsn#" name="qCreate"> > > CREATE TABLE #application.dbowner#fqAudit ( > > AuditID char (50) NOT NULL , > > objectid char (50) NULL , > > datetimeStamp datetime NOT NULL , > > username varchar (255) NOT NULL , > > location varchar (255) NULL , > > auditType char (50) NOT NULL , > > note varchar (255) NULL, > > PRIMARY KEY(AuditID) > > ) > > </cfquery> > > > > <cfreturn stReturn /> > > </cffunction> > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
