Re: Coldfuion 9 and ORM

2011-09-21 Thread Tom Small
Hi Jonah Thanks for your reply ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: ORM Linkedtable

2011-12-12 Thread Tom Small
Hi Cameron I am not having any errors as I have a limited understanding and have followed the adobe tutorials... Although I am having trouble understanding how to create a relationship between more than one table. I have linked the core table 'Clients' to the sub-table 'Whitelabel'

Re: ORM Linkedtable

2011-12-12 Thread Tom Small
Hi Cameron, Below is a snippet of code, and appreciate your assistance in this matter... cfcomponent hint=clients CFC output=false persistent=true table=clients entityname=Clients cfcomponent hint=clients CFC output=false persistent=true table=clients

Re: ORM Linkedtable

2011-12-12 Thread Tom Small
Hi Cameron, Should have added that I am attempting to link the 'users' table (one-to-many) with the 'userrole' table. Thanks ~| Order the Adobe Coldfusion Anthology now!

Re: ORM Linkedtable

2011-12-16 Thread Tom Small
Hi Cameron, Thanks for your advice and support in this matter. I took your advise and purchased the ColdFusion ORM book, which has very good examples and is an excellent read. ~| Order the Adobe Coldfusion Anthology now!

ORM global event handler

2011-12-29 Thread Tom Small
Hi I am attempting to run a global event handler although get getting error: function keyword is missing in FUNCTION declaration. The CFML compiler was processing: A script statement beginning with component on line 7, column 2. A cfscript tag beginning on line 2, column 2. The error occurred

Re: ORM global event handler

2011-12-29 Thread Tom Small
Hi Matt Thanks for your reply. I am following a book by John Whish ColdFusion ORM and have pasted his exmaple; component implements=cfide.orm.IEventHandler { public void function preLoad( any entity ) { logEvent( preload, arguments.entity ); } public void function postLoad( any entity ) {

Re: ORM global event handler

2011-12-29 Thread Tom Small
Hi Cameron, thanks for the reply and I am not running it directly from cfc. Maybe it is something that I have done wrong in the code, although have checked and re-checked. In addition, have included in application.cfc - this.ormsettings.eventhandling; this.ormsettings.eventhandler (which is

cfquery and json

2012-01-10 Thread Tom Small
Hi I am new to coldfusion 9 and extjs 4 and like to know how to pass a cfquery to a mysql table, and then covert the data to json to populate a grid.. Would appreciate some help on this matter also if there are any tutorials for newbies. Thanks

Re: cfquery and json

2012-01-10 Thread Tom Small
Thanks for your assistance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Extjs4

2012-01-10 Thread Tom Small
Hi, I have built a grid panel via extjs4 and want to link the data store to a mysql table, which is stored locally on my machine. Is there any examples for newbie that will walk me through how to achieve this? thanks Tom

extjs4 designer

2012-01-10 Thread Tom Small
Hi, I have built a grid panel via extjs designer and want to link the data store to a mysql table, which is stored locally on my machine. Is there any examples for newbie that will walk me through how to achieve this? thanks Tom

Convert php to cfm

2012-01-10 Thread Tom Small
Hi, I need to convert php to coldfusion. Would appreciate some help, thanks ?php #First we include our credentials file # FileName=connect.php $hostname = localhost; $database = nimsoftslmdev; $username = root; $password = xxx; #And now we connect to the database //connection String

Re: Convert php to cfm

2012-01-10 Thread Tom Small
Hi Andrew, thanks for your help and advice ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Convert php to cfm

2012-01-11 Thread Tom Small
Hi Andrew, I am using ColdFusion9 and have downloaded json (serialize and deserialize) from cflibs. Although this may sound naive, can you tell me where to include both files, also how to cfoutput it via json to my datastore as I am a newbie...

Re: extjs4 designer

2012-01-11 Thread Tom Small
Hi Steve, thanks for the link ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Convert queries for ext

2012-01-12 Thread Tom Small
Hi, I am using a cfc that converts queries to ext grid. When I run the code keep getting error. Would appreciate any help on this issue: 'Unable to parse the JSON returned by the server: You're trying to decode an invalid JSON String:’

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrew this is my store and ConvertQueriesForExt.cfc: Ext.define('MyApp.store.UserStore', { extend: 'Ext.data.Store', constructor: function(cfg) { var me = this; cfg = cfg || {}; me.callParent([Ext.apply({ autoLoad: true, storeId:

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrew thanks for your reply and it is now return json format although my problem now is the data not shown in the grid. I would appreciate any help... {ROWS:[{EMAIL:s@gosh.org.uk,USER_PK:1,ISACTIVE:1,USERROLEID:1}],DATASET:1} Thanks Tom

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Matt, can you please simplify your reply as I am new to extjs and coldfusion. Thanks Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrews, here is the code for my grid. Thanks Tom --- Ext.define('MyApp.view.ui.UsersDetail', { extend: 'Ext.panel.Panel', style: margin: 0px auto 0px auto;, // center the form panel frame: true, height: 450, width: 410, autoScroll: true,

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrew, thanks for your help ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrew, Problem solved and thanks for all your help and support. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Matt, Problem solved and thanks for all your help and support. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Steve, Problem solved and thanks for all your help and support. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Filter row plugin

2012-01-14 Thread Tom Small
Hi, I have built a grid via ext designer and want to know if there is a plugin that will enable that data in the grid to be filtered... Have attempted to follow various examples although they do not represent the code as a class. I would appreciate any help. Thanks Tom

Re: Filter row plugin

2012-01-15 Thread Tom Small
Thanks Andrew I have found a solution on the forum ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Filter row plugin

2012-01-16 Thread Tom Small
Hi Andrew, thought I had a solution to the flier grid issue although can not solve the problem. I am using ext designer to generate the code (class) to filter columns in the grid and have attempted to follow various examples, although having no luck so far. Is it possible for me to send you a

Re: Filter row plugin

2012-01-16 Thread Tom Small
Hi Andrew, thanks for the advice also I think the example code I am using is for ext3 and not 4, and I believe the columnModel approach was removed, maybe that is why I am getting issues. I will send a snippet of my code the your email address, if that is OK? In the meantime will try to work

Re: Filter row plugin

2012-01-16 Thread Tom Small
Thanks for the advice ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Filter row plugin

2012-01-16 Thread Tom Small
grid.selectionModel() is produces an error ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Filter row plugin

2012-01-17 Thread Tom Small
Steve thanks for pointing me in the right direction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Grid filter textbox

2012-01-21 Thread Tom Small
Hi I am attempting to search for data in a grid via a textfield. Have downloaded a plugin which works in part(http://www.learnsomethings.com/2011/10/12/extjs4-clearable-grid-filter-textbox-that-uses-delayedtask-to-avoid-sending-data-on-every-keypress/#comment-2022), although now I need a

Re: Grid filter textbox

2012-01-21 Thread Tom Small
Hi Andrew thanks for the reply and will take a look on extjs forum ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Grid filter textbox

2012-01-21 Thread Tom Small
Hi Andrew, I have looked on ext forums and attempted to apply the examples to my grid, although there are no errors it still is not searching. Have followed a post (see below) and although it works in part, I can not make it search a row in the grid. I think that problems I am having is with

Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

2012-01-22 Thread Tom Small
I am trying to replace my grid with 'Live-Search-Grid' plugin. Would appreciate some help! Thanks Tom ~| Order the Adobe Coldfusion Anthology now!

Re: Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

2012-01-22 Thread Tom Small
Ok Andrew thanks, and have posted the same question on extjs forum. Is it possible for me to send you a snippet of my code? Thanks Tom ~| Order the Adobe Coldfusion Anthology now!

Re: Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

2012-01-22 Thread Tom Small
// configure whether filter query is encoded or not (initially) var encode = false; // configure whether filtering is performed locally or remotely (initially) var local = true; var filters = { ftype: 'filters', // encode and local

Re: Ext JS 4 Plugin: Live-Search-Grid - How to modify my Grid definition

2012-01-23 Thread Tom Small
Hi Andrew I have modified my grid to a live-search-grid ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

cannot convert the value x to a boolean

2012-04-30 Thread Tom Small
Hi, I have a loop that searches for keywords, although when I search for 'string' values get an error: cannot convert the value x to a boolean. If I remove the statement: u.isactive = cfqueryparam value=#IIF(arguments.query, 1, 0)# then only finds 'string' keywords with no errors. If I run

Re: cannot convert the value x to a boolean

2012-04-30 Thread Tom Small
I see two issues. First, you are trying arguments.query like a list, but you don't use the value. Ie, you said, loop over it and put the value in keyword, but your code never uses it. Secondly - you seem to be wanting to treat the keywords as booleans. That's not going to work. Hi Ray thanks

Re: cannot convert the value x to a boolean

2012-04-30 Thread Tom Small
You can check to see if a value can be treated as a boolean by checking isBoolean(). Hi Ray thanks ~| Order the Adobe Coldfusion Anthology now!

Software Project Development Process

2012-06-24 Thread Tom Small
Hi We are about the start our first large project, and in the past I have with have been using UML although in my opinion it has its limitations and is not flexible for ColdFusion and ExtJS 4. Could anyone advise me on a standardize-general purpose modelling tool that can be used for

Re: Software Project Development Process

2012-06-24 Thread Tom Small
Hi Russ I will give it a try ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Software Project Development Process

2012-06-24 Thread Tom Small
Hi Russ Thanks for the email although 'pencil' does not offer the flexibly that we require. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Re: Software Project Development Process

2012-06-24 Thread Tom Small
Hi Cameron Thanks for your email greatly appreciated. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Software Project Development Process

2012-06-24 Thread Tom Small
We use UML for object oriented analysis and design.. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Anyone use/used Flinthosts in the UK?

2012-06-24 Thread Tom Small
We used flinthost in the past although had problems with bandwidth and customer service. Tested various hosting companies and decided to moved to Rackspace and have been with them for over 5 years. Tom ~| Order the Adobe

Re: Software Project Development Process

2012-06-25 Thread Tom Small
Hi Mark Due to the size of the project we were looking an alternative UML diagramming tools. A lot of people have suggested reviewing Agile to management a large software project. ~| Order the Adobe Coldfusion Anthology now!

Re: Software Project Development Process

2012-06-25 Thread Tom Small
Hi Will, Thanks and will take a look although it might not be suitable for a large project. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Combo comparison operator

2012-06-25 Thread Tom Small
Hi I have a search toolbar that work OK, although now I want to add a Combobox comparison operator (AND/OR/NOT) – so when a user selects, for example AND it can filter the data (stored in MySQL db) based on the data in the grid. Can someone point my in the right direction and have been

Re: Software Project Development Process

2012-06-25 Thread Tom Small
Hi Mark I initially wanted to know if there was an alternative to UML for a large project, and although we have reviewed Argile, we will be using UML. We are using MVC framework and the UI designs can be modelled using UML (design pattern). Sorry if my initial post caused any confusion. Tom

Progressbar interacting with server

2012-07-07 Thread Tom Small
Hi I have a Progressbar that is developed with Ext JS 4 and want to know how to write ColdFusion server code that can keep track of the progress and pass it back to the progress bar.. Tom ~| Order the Adobe Coldfusion

Re: Progressbar interacting with server

2012-07-08 Thread Tom Small
Hi Guust Thanks for your reply although I am currently using ColdFusion 9 and noticed - WebSocket in point-to-point communication is developed for ColdFusion 10. If this is the case, is there an alternative that can work with the version that I am using? Tom

search email list to extract data in spreadsheet

2013-01-17 Thread Tom Small
Hi, Can someone advise me on the following.. I want to know the best way to search through a list of emails and extract the information (e.g. first, address, position, address, etc) into an excel spreadsheet. Appreciate any advice on this issue. Tom

Re: search email list to extract data in spreadsheet

2013-01-17 Thread Tom Small
Hi John, Thanks for the link. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small
Hi Attila, Thanks for your email and I should of been much clearer in my previous email. Hi John, Another questions - what if I wanted to extract information from a list of emails found on web (http://rg.kcl.ac.uk/staffprofiles/?by=A) and run some code that can extract details from each

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small
Sorry about the first part of my previous email... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small
J.J, Thanks for your replay. The main reason why I need to extract the information onto a spreadsheet is to save time (instead of doing it manually) - we work with several universities in the UK and store their information in our database - to promote our product/services. You mentioned

activeLink(string)

2013-01-20 Thread Tom Small
I am using your cfLib component ‘activeLink(string)’ which works great.. Searching for a solution to the following question, and would appreciate any advice on this matter: When the links are found, for example on a web page - I want to open each link to extract the data to an excel

Re: activeLink(string)

2013-01-20 Thread Tom Small
Have been using cfhttp although found activeLink simple to use. If there is a better way can you let me know? Tom ~| Order the Adobe Coldfusion Anthology now!

Re: activeLink(string)

2013-01-20 Thread Tom Small
I have sent him an email and got it from cfLib. You mentioned cfhttp - can you point me in the right direction? ~| Order the Adobe Coldfusion Anthology now!

Re: activeLink(string)

2013-01-20 Thread Tom Small
I have look over this but could not workout how to achieve my issue.. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: activeLink(string)

2013-01-20 Thread Tom Small
It is hyperlinks on a web page that once clicked opens data about a person, for example name, email, position, telephone - this is the link and thanks for your reply - http://rg.kcl.ac.uk/staffprofiles/?by=A ~| Order the

Re: activeLink(string)

2013-01-20 Thread Tom Small
I have been looking at screen scraping using cfhttp and found something from cfLib that works just as good. I will solve it, so no problems and thanks for your reply ~| Order the Adobe Coldfusion Anthology now!