March 19, 2007
In a previous post, I covered how to have fcClient pop a page based on a URL. Now, we'll cover how to customize this functionality to perform your own actions. For this particular example, we'll show how to have an existing fcQuery query get executed and the results posted. 1. In console.asp, we'll add code to get the actual objid of the query based on the query name, for the current user. This is necessary because the query names are not unique across the system. In console.asp, after this existing code: var CommandToExecute = Request("command") + '';var CommandParam1 = Request("param1") + '';var CommandParam2 = Request("param2") + ''; We'll add this: if (CommandToExecute=="executeQuery"){ //get the query objid //first, see if this user ownes this query var gen = FCSession.CreateGeneric('ce_query'); gen.AppendFilter('ce_query2user','=',FCSession.Item('user.id')); gen.AppendFilter('query_name','=',CommandParam1); gen.Query(); if (gen.Count() > 0){ CommandParam1 = gen.Id - 0; }else{ //see…
Customizing the executeCommand actions in fcClient
March 19, 2007
In a previous post, I covered how to have fcClient pop a page based on a URL. Now, we'll cover how to customize this functionality to perform your own actions. For this particular example, we'll show how to have an existing fcQuery query get executed and the results posted. 1. In console.asp, we'll add code to get the actual objid of the query based on the query name, for the current user. This is necessary because the query names are not unique across the system. In console.asp, after this existing code: var CommandToExecute = Request("command") + '';var CommandParam1 = Request("param1") + '';var CommandParam2 = Request("param2") + ''; We'll add this: if (CommandToExecute=="executeQuery"){ //get the query objid //first, see if this user ownes this query var gen = FCSession.CreateGeneric('ce_query'); gen.AppendFilter('ce_query2user','=',FCSession.Item('user.id')); gen.AppendFilter('query_name','=',CommandParam1); gen.Query(); if (gen.Count() > 0){ CommandParam1 = gen.Id - 0; }else{ //see…
February 27, 2007
Those who have called Daylight Savings Time a folly from the beginning may snicker at the Congressional decision to alter the dates, but those who have anything to do with software aren’t laughing. Changing the dates of the Daylight Savings Time active period, for the first time in decades, will throw a lot of clocks out of sync. Dovetail engineer Steven Weintraub has compiled a list of dates affected by the new law, and instructions to update Daylight Savings Time (DST) in the Clarify database “This requires a good knowledge of CLARIFY database setup and SQL. This is a problem. I am sure Clarify is providing a solution for those using Clarify support – but this does not help the many customers who have stopped paying support. “For those customers (and this blog post is for you) – they have to…
February 19, 2007
I have been spending some time trying to understand how Castle's ActiveRecord manages SessionScopes for web applications. A SessionScope abstracts access to the database and manages a cache of conversions with the database (likely an oversimplified.) In a web application scenario it is best to 'scope' the SessionScope to a web request as this is the logically boundary of a single unit of work. I am interested in how this approach is superior than simply using an IOC container like Windsor with a PerWebRequest lifestyle. Here is a bit of info about the classes involved in scoping SessionScope per web request for Castle's web applications: SessionScope For the most part in ActiveRecord a SessionScope abstracts a NHibernate Session. provides access to current session. The injected FlushAction tells it what to do during disposal. Basically flush changes to the database or do nothing. The SessionScope also can get injected with a SessionScopeType (Simple, Transactional,...) The static SessionScope.Current is…