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 spreadsheet. I know how to extract the data to 
be displayed on a spreadsheet, although having problems opening a link. 

Is there a way to do this, and if so can you point me to an example?

Tom

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353980
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353984
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353986
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353988
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353990
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 email link and store each details in a excel 
spreadsheet.
 
I know how to add a list of emails from a spreadsheet and send then to clients 
although not sure how to extract it from a website?
 
Hope that this make sense and if you need more information please let me know.
 
Thanks again for you help  advise.
 
Tom

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353963
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353964
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 that although difficult (email address javascript protected) it 
is possible. 

Is there a way that I could obtain sample code of how to do this?

Tom

Tom,

You would use CFHTTP to get the HTML and then parse the data from there.

I will say that the website you sent is trying its best for you not to
do what you are doing. If you look in the HTML it clearly has the
email address javascript protected which doesn't mean you can't do
it, it just means it is going to be a little more difficult.

Why can't you just contact the college for the information? If they
aren't going to give it to you then maybe you don't need it :-)


-J.J.
 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353966
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353959
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353961
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351859
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351856
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351680
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351683
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 searching for an 
examples although so far no luck.

Tom 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351684
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351704
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 ColdFusion/ ExtJS 4 project?

Thanks

Tom 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351662
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351665
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351667
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351669
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351670
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 the code below it only finds 'boolean' keywords and when I enter a 
'string' value produces the error above.

This is a snippet of my code:

cfloop list=#arguments.query# index=keyword delimiters= ,;
WHERE u.email LIKE cfqueryparam value=%#arguments.query#% OR
  r.rolename LIKE cfqueryparam value=%#arguments.query#% OR  
  u.isactive = cfqueryparam value=#IIF(arguments.query, 1, 0)# 
/cfloop 

Thanks 

Tom 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350881
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 for the reply. 

Can you tell me how I should treat the boolean, and do I need to place the 
boolean within an cfif statement?

Appreciate your advice.

Tom 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350883
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350885
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349603
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349590
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349593
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 configuration options defined previously for easier 
reuse
encode: encode, // json encode the filter query
local: local,   // defaults to false (remote filtering)

filters: [{//id filter
type: 'numeric',
dataIndex: 'USER_PK'
}, 
{//email filter
type: 'string',
dataIndex: 'EMAIL',

}, 
{//is active filter
type: 'boolean',
dataIndex: 'ISACTIVE'
}, 
{//user role id filter
type: 'numeric',
dataIndex: 'USERROLEID'
}]
};


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,
layout: {//panel layout
align: 'stretch',
type: 'vbox'
},
title: 'span class=gridPanelTextUsers/span',

initComponent: function() {
var me = this;  

Ext.applyIf(me, {
items: [
{//grid panel data columns
xtype: 'gridpanel',
itemId: 'grid',
store: 'UserStore',
features: [filters],// filter-grid 
plugin feature
flex: 1,
columns: [
{//id column
xtype: 'numbercolumn',
width: 40,
dataIndex: 'USER_PK',
filter: {type: 'int'},
format: 0
},
{//email column
xtype: 'gridcolumn',
width: 165,
dataIndex: 'EMAIL',
filter: {type: 'string',test: 
/^{0}/},//https://github.com/nene/filter-row
text: 'Email'
},
{//is active column
xtype: 'booleancolumn',
width: 80,
dataIndex: 'ISACTIVE',
filter: {type: 'boolean'},
text: 'Is Active'
},
{//user role id column
xtype: 'numbercolumn',
width: 90,
dataIndex: 'USERROLEID',
filter: {type: 'int'},
text: 'Role',
format: 0
}
],
 
viewConfig: {

}
}
],


dockedItems: [
{//button toolbar
xtype: 'toolbar',
flex: 1,
dock: 'top',
items: [
{//add button
xtype: 'button',
id:'addbutton',
iconCls: 'addIcon',
text: 'Add',
handler: function(){
alert('Add button clicked!');
}
},
{//edit button
xtype: 'button',
id:'editbutton',
iconCls: 'editIcon',
text: 'Edit',
handler: function(){
 alert('Edit button clicked!');
}
},
{//delete button
xtype: 'button',
id:'deletebutton',
iconCls: 'deleteIcon',
text: 'Delete',
handler: function(){
 alert('Delete button clicked!');
}
},
{
xtype: 'tbseparator'
},
{//import button
xtype: 'button',
id:'importbutton',
iconCls: 'importIcon',
text: 'Import',

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 plug-in that can search row(s) in a grid? Have look 
online and can not find anything that I can get my head around, as I am new the 
extjs4 and coldfusion.

Thanks

Tom 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349584
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349586
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 applying the 
following:

// Main viewport
   var viewport = Ext.create('Ext.Viewport', {
  id: 'main_viewport',
  layout: 'border',
  items: [
  Ext.create('Ext.Component', {
   region: 'north',
   height: 25, 
   autoEl: {
tag: 'div',
html:'h1 style=margin-left:10px; margin-top:6px; 
font-weight:bold; font-family:Arial, Helvetica, sans-serifFrederick County 
MD, Public Schools Check Registers/h1'
   }
  }),
check_register_grid
]
});
check_register_grid.getStore().setExtraParam('sort','check_pay_to');
check_register_grid.getStore().setExtraParam('dir','ASC');
check_register_grid.store.loadPage(1);
});

My view is define as: Ext.define('MyApp.view.ui.UsersDetail', {extend: 
'Ext.panel.Panel',initComponent: function() {var me = this; Ext.applyIf(me, 
{items: [.

Would appreciate any help on this issue,.

Thanks 
Tom 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349587
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349517
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 snippet of 
my code? As always would appreciate any help on this matter. I am getting an 
error; grid.getColumnModel is not a function
[Break On This Error] var cm = grid.getColumnModel();

the example I have been following is: https://github.com/nene/filter-row  

Thanks 
Tom 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349504
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 on the issue.

Thanks Tom 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349508
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349509
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349514
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349501
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349499
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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:’ 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349422
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 'UserStore',
proxy: {
type: 'ajax',
url: '/orm_2/view/user/app/store/ConvertQueriesForExt.cfc',
reader: {
type: 'json',
idProperty: 'name',
root: 'users'
}
},
fields: [
{
name: 'user_pk',
allowBlank:false,
type: 'int'
},
{
name: 'email',
sortType: 'asText',
type: 'string'
},
{
name: 'isactive',
type: 'boolean'
},
{
name: 'userroleid',
sortType: 'asInt',
type: 'int'
}
]
}, cfg)]);
}
});



cfcomponent output=false

cffunction name=getUsers access=remote returnformat=json output=false 
hint=Gets list/detail of posts
 cfargument name=limit type=numeric required=no
 cfargument name=start type=numeric required=no
 cfargument name=sort required=no type=string
 
cfset var userData = 
  
cfquery name=userData datasource=orm_2
   SELECT user_pk,email,isactive,userroleid
   FROM users
   ORDER BY #arguments.sort#
 /cfquery
 
cfset clist = 'user_pk,email,isactive,userroleid'
 cfset arrayRecords = 
convertQueryToExtJSON(userData,clist,arguments.limit,arguments.start)
 cfset s = {rows=arrayRecords,dataset=#userData.recordcount#}
 cfreturn s /
/cffunction



cffunction name=ConvertQueryToExtJSON returntype=any access=public
  cfargument name=query type=query required=yes /
  cfargument name=clist type=string required=yes /
  cfargument name=limit type=numeric required=yes /
  cfargument name=start type=numeric required=yes /
  cfscript
   arrayRecords = ArrayNew(1);
   if(arguments.start==0) {
counter = 1;
   }
   else {
counter = arguments.start;
   }
   for(i=1;i=arguments.limit;i++)  {
strResults = structNew();
for(x=1;x=listLen(clist);x++) {
 strResults[ucase(listGetAt(clist,x))] = 
query[listGetAt(clist,x)][counter];
}
arrayRecords[i] = strResults;
counter = counter+1;
  }
  return arrayRecords;
 /cfscript

/cffunction
/cfcomponent

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349426
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349435
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349437
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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,
layout: {
align: 'stretch',
type: 'vbox'
},
title: 'span class=gridPanelTextUsers/span',

initComponent: function() {
var me = this;

Ext.applyIf(me, {
items: [
{
xtype: 'gridpanel',
itemId: 'grid',
store: 'UserStore',
flex: 1,
columns: [
{
xtype: 'numbercolumn',
width: 40,
dataIndex: 'user_pk',
format: 0
},
{
xtype: 'gridcolumn',
width: 165,
dataIndex: 'email',
text: 'Email'
},
{
xtype: 'booleancolumn',
width: 80,
dataIndex: 'isactive',
text: 'Is Active'
},
{
xtype: 'numbercolumn',
width: 90,
dataIndex: 'userroleid',
text: 'Role',
format: 0
}
],
viewConfig: {

}
}
],
dockedItems: [
{
xtype: 'toolbar',
flex: 1,
dock: 'top',
items: [
{
xtype: 'button',
iconCls: 'addIcon',
text: 'Add'
},
{
xtype: 'button',
iconCls: 'editIcon',
text: 'Edit'
},
{
xtype: 'button',
iconCls: 'deleteIcon',
text: 'Delete'
},
{
xtype: 'tbseparator'
},
{
xtype: 'button',
iconCls: 'importIcon',
text: 'Import'
},
{
xtype: 'tbseparator'
},
{
xtype: 'button',
iconCls: 'exportIcon',
text: 'Export'
}
]
},
{
xtype: 'toolbar',
flex: 1,
dock: 'top',
items: [
{
xtype: 'textfield',
width: 323
},
{
xtype: 'tbspacer'
}
]
}
]
});

me.callParent(arguments);
}
}); 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349442
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349453
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349456
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349457
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349458
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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... 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349390
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349415
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349369
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349371
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349372
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349373
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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

//connection String
$con = mysql_connect($hostname, $username, $password) or die('Could not 
connect: ' . mysql_error());
//select database
mysql_select_db($database, $con);
//Select The database
$bool = mysql_select_db($database, $con);
if ($bool === False){
print can't find $database;
}


$start = ($_REQUEST[start] == null)? 0 : $_REQUEST[start];
$limit = ($_REQUEST[limit] == null)? 200 : $_REQUEST[limit];

// Gather all pending requests
$query = SELECT
nimid,
level,
message,
source
FROM nas_alarms ;

$query .=  ORDER BY level ASC ;
$query .=  LIMIT .$start.,.$limit;

$result = mysql_query($query, $con); 

// Here we do the count
$query_c = SELECT
nimid,
level,
message,
source
FROM nas_alarms ;

//get total
$count_result = mysql_query($query_c, $con);
$total = mysql_num_rows($count_result);

if (mysql_num_rows($result)  0){
while($obj = mysql_fetch_object($result))
{
$arr[] = $obj;
}

// Now create the json array to be sent to our datastore

$myData = array('myInventory' = $arr, 'totalCount' = $total);
echo json_encode($myData);
return;
exit();

}

else { // If no requests found, we return nothing

$myData = array('myInventory' = '', 'totalCount' = '0');
echo json_encode($myData);
return;
exit();

}

? 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349374
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349379
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 in 
C:\ColdFusion9\wwwroot\orm\model\aop\GlobalEventHandler.cfc: line 7
5 : */ 
6 : 
7 :  component implements=CFIDE.orm.IEventHandler
8 :  {
9 : 

Thanks, Tom 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349249
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 )
{
logEvent( postload, arguments.entity );
}
public void function preInsert( any entity )
{
logEvent( preinsert, arguments.entity );
var timestamp = now();
if ( StructKeyExists( arguments.entity, setCreated ) )
{
arguments.entity.setcreated( timestamp );
}
if ( StructKeyExists( arguments.entity, setUpdated ) )
{
arguments.entity.setupdated( timestamp );
}
}
public void function postInsert( any entity )
{
logEvent( postinsert, arguments.entity );
}
public void function preUpdate( any entity, Struct oldData )
{
if ( StructKeyExists( arguments.entity, setUpdated ) )
{
arguments.entity.setupdated( Now() );
}
logEvent( preupdate, arguments.entity );
}
public void function postUpdate( any entity )
{
logEvent( postupdate, arguments.entity );
}
public void function preDelete( any entity )
{
logEvent( predelete, arguments.entity );
}
public void function postDelete( any entity )
{
logEvent( postdelete, arguments.entity );
}
private void function logEvent( required string event, required
CFC )
{
var message = Entity: #getMetaData( cfc ).fullname#, Event:
#event#;
WriteLog( type=event, file=ormevent.log, text=message );
}
} 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349251
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 mapped 
to the cfc)

Will start afresh tomorrow as it is usually the small issues that take the 
longest to solve, although once found is always remembered.

Thanks again! 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349253
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349199
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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' 
(one-to-one), 'Users' (one-to-many) and 'Users' to Userrole' (one-to-many).

My issue is how to link the foreign keys in the 'Users' to the 'Userroles'

Appreciate any help on this matter!


Mysql code:

CREATE TABLE clients (
clientid INTEGER(11) NOT NULL AUTO_INCREMENT,
clientname VARCHAR(50) NOT NULL,
isactive VARCHAR(1) NOT NULL,
departmentname VARCHAR(50) NOT NULL,
departmentaddress TEXT NOT NULL,
contactname VARCHAR(50) NOT NULL,
contactemail VARCHAR(50) NOT NULL,
contacttelephone VARCHAR(50) NOT NULL,
accounttype VARCHAR(50) NOT NULL,
startdate DATE NOT NULL,
expirydate DATE NOT NULL,
paymentmethod TEXT NOT NULL,
notes TEXT,
PRIMARY KEY (clientid),
UNIQUE (clientname)
)
ENGINE=InnoDB;


CREATE TABLE whitelabel (
whitelabelid INTEGER(11) NOT NULL,
whitelabel VARCHAR(1) NOT NULL DEFAULT 0,
logo VARCHAR(50) NOT NULL,
topbar VARCHAR(50) NOT NULL,
loginpagehtml TEXT NOT NULL,
whitelabelemail VARCHAR(50),
whitelabeltelephone VARCHAR(50),
whitelabelwebsite VARCHAR(50),
whitelabeladdress TEXT,
PRIMARY KEY (clientid),
FOREIGN KEY (clientid)
REFERENCES clients (clientid)
ON UPDATE CASCADE
ON DELETE CASCADE
)
ENGINE=InnoDB;


CREATE TABLE userrole (
userroleid INTEGER(11) NOT NULL AUTO_INCREMENT,
rolename VARCHAR(50) NOT NULL,
PRIMARY KEY (userroleid),
UNIQUE (rolename)
)
ENGINE=InnoDB;

CREATE TABLE users (
userid INTEGER(11) NOT NULL AUTO_INCREMENT,
email VARCHAR(50) NOT NULL,
password VARCHAR(255) NOT NULL,
title VARCHAR(5) NOT NULL,
firstname VARCHAR(50) NOT NULL,
lastname VARCHAR(50) NOT NULL,
position VARCHAR(50) NOT NULL,
isactive VARCHAR(1) NOT NULL,
userroleid INTEGER(11) NOT NULL,
showassistance VARCHAR(1) NOT NULL DEFAULT 1,
failedloginattempts VARCHAR(1) NOT NULL DEFAULT 0,
passwordexpires DATETIME NOT NULL,
PRIMARY KEY (userid),
UNIQUE (email),
UNIQUE (title,firstname,lastname),
FOREIGN KEY (userid)
REFERENCES clients (clientid)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (userid)
REFERENCES userrole (userroleid)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (userroleid)
REFERENCES userrole (userroleid)
ON UPDATE CASCADE
ON DELETE CASCADE
)
ENGINE=InnoDB;









~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349068
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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 entityname=Clients


cfproperty 
name=ClientID 
hint=id for clients 
type=numeric 
required=true

fieldtype=id 
generator=identity 
ormtype=integer
notnull=true


cfproperty 
name=UsersObj 
fieldtype=one-to-many 
linktable=ClientUser 
type=array 
cfc=users 
inverse=true  
cascade=all-delete-orphan 
fkcolumn=clientid 
inversejoincolumn=userid 
lazy=false 
singularname=UsersObj

cfproperty 
name=UserroleObj 
fieldtype=one-to-many 
linktable=ClientUserRole 
type=array 
cfc=userrole 
inverse=true  
cascade=all-delete-orphan 
fkcolumn=clientid 
inversejoincolumn=userroleid 
lazy=false 
singularname=UserroleObj  



cfproperty 
name=clientname

cfproperty 
name=isactive

cfproperty 
name=departmentname

cfproperty 
name=departmentaddress

cfproperty 
name=contactname

cfproperty 
name=contactemail

cfproperty 
name=contacttelephone

cfproperty 
name=accounttype

cfproperty 
name=startdate

cfproperty 
name=expirydate

cfproperty 
name=paymentmethod

cfproperty 
name=notes

---

cfcomponent hint=users CFC output=false persistent=true table=users 
entityname=Users


cfproperty 
name=userid 
hint=id for users 
type=numeric
required=true 

fieldtype=id 
generator=identity 
ormtype=integer
notnull=true



cfproperty 
name=email

cfproperty 
name=password

cfproperty 
name=title

cfproperty 
name=firstname

cfproperty 
name=lastname

cfproperty 
name=position 

cfproperty 
name=isactive

cfproperty 
name=userroleid   

cfproperty 
name=showassistance

cfproperty 
name=failedloginattempts

cfproperty 
name=passwordexpires



cfproperty 
name=ClientsID 
fieldtype=many-to-one 
linktable=ClientUser 
fkcolumn=userID 
inversejoincolumn=clientID 
cfc=clients 
singularname=Clients

/cfcomponent

---

cfcomponent hint=user role CFC output=false persistent=true 
table=userrole entityname=Userrole


!--- define the user role properties ---
cfproperty 
name=userroleid 
hint=id for user role 
type=numeric 
required=true

fieldtype=id 
generator=identity 
ormtype=integer
notnull=true

cfproperty 
name=rolename



cfproperty 
name=ClientsID 
fieldtype=many-to-one 
linktable=ClientUserRole 
fkcolumn=userroleid 
inversejoincolumn=clientID 
cfc=clients 
singularname=Clients


/cfcomponent


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

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!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349071
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

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: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347552
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm