Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfcomponent output="false">
- <cffunction name="add" access="remote" returntype="string">
- <cfargument name="text" type="string" required="true" default="" />
- <cfset var q = "" />
- <cfset var r = "" />
- <cfset var re = "" />
- <cfquery datasource="jQuery" name="q" result="re">
- insert
- into jcfdump
- (data)
- values (<cfqueryparam cfsqltype="cf_sql_varchar" value="#left(arguments.text,999)#" />)
- ;
- select id,data
- from jcfdump
- order by id
- </cfquery>
- <cfif re.recordcount gte 10>
- <cfquery datasource="jQuery">
- delete
- from jcfdump
- order by id
- limit 5
- </cfquery>
- </cfif>
- <cfsavecontent variable="r">
- <cfdump var="#q#" />
- </cfsavecontent>
- <cfreturn r />
- </cffunction>
- </cfcomponent>
Add Comment
Please, Sign In to add comment