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: Escaping #

2012-01-22 Thread Rob Voyle

Hi Claude
Thanks
I still have a problem
The value comes from the form itself.
The first time the form is read the values are set to default with:

cfloop index = i from = 1 to = 50
cfparam name=namefirst#i# default=
/cfloop

In the form I use

cfloop index = i from = 1 to = 50
input type=text class=txt name=namefirst#i# size=25
   value=cfoutput#form['nameFirst'  i]#/cfoutput /br /
 /cfloop

but I get the error message
Element nameFirst1 is undefined in a Java object of type class 
coldfusion.filter.FormScope.

Rob



On 21 Jan 2012 at 17:20, =?ISO-8859-1?Q?Claude_Schn=E9 wrote:

 
 I suppose the namefirst variables come from some Query?
 
 cfloop index = i from = 1 to = 50
 input type=text class=txt name=namefirst#i# size=25
  value=cfoutput#evaluate ('nameFirst'  i)#/cfoutput /br
 /
 /cfloop
 
 However, if the variables namefirst come from a form or some other
 structure, there might be a better way.
 cfloop index = i from = 1 to = 50
 input type=text class=txt name=namefirst#i# size=25
  value=cfoutput#form['nameFirst'  i]#/cfoutput /br /
 /cfloop
 
 
 
 ~|
 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:34
 9589
 Subscription:
 http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
 Unsubscribe:
 http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
 




~|
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:349591
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 Andrew Scott

Tom this is a ColdFusion mailing list, and your questions on ExtJS are best
suited over at sencha's website and forums.

Now I personally don't mind answering your questions, but you need to
consider that there isn't that many people here who can help you, as
compared to the relevant places.

So you may not get the same responses or help that you would get over there.


-- 
Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+: http://plus.google.com/108193156965451149543


On Sun, Jan 22, 2012 at 11:20 PM, Tom Small t...@re-base.net wrote:


 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:349592
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: Escaping #

2012-01-22 Thread Captain Obvious

/* note: your cfparam needs form.namefirst not just namefirst */

cfoutput

cfloop index = i from = 1 to = 50
cfparam name= form.namefirst#i# default=
/cfloop

cfloop index=i from=1 to=50
input
 type=text
 class=txt
 name=namefirst#i#
 size=25
 value=#form['nameFirst'  i]# /
  br /
/cfloop

/cfoutput


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


Re: Escaping #

2012-01-22 Thread Claude Schnéegans

 /* note: your cfparam needs form.namefirst not just namefirst */

Furthermore, if they are text fields, you don't need to set default values.
Only for checkboxes or radios

~|
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:349595
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 Andrew Scott

Sure.


On Mon, Jan 23, 2012 at 1:34 AM, Tom Small t...@re-base.net wrote:


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


Re: (ot) SEO

2012-01-22 Thread Dave Hatz

Dave,
Thanks for the feedback. Let me try to explain how the client site is currently 
set up. Client has a search results page on his site, like this

http://www.mydomain.com/car_results.cfm?make=toyotamodel=tacoma where the Car 
Model and Type are passed in as parameters.  The page uses CSS, JS and Images 
folders to produce the results page.

Then he has gone and set up links that are set up on other sites to point to 
something like this

http://www.mydomain.com/cars/toyota/tacoma

and what the client wants is the for the .cmf page under /tacoma to parse the 
url for the car type and model then display the results on his car_results.cfm 
page from his site.  So our index.cfm parses the url and gets the make and 
model then redirects using CFLOCATION to the car_results.cfm page.  

Client is trying to gain SEO rankings on his 
http://www.mydomain.com/cars/toyota/tacoma page.  He has folders for different 
makers/models of cars, which is 100's of different folders.  We didn't want to 
have to create the same results page in all these different folders.

You mentioned this approach was not a good idea.  I would love to find a better 
approach and your thoughts on how we can improve this 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:349597
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: (ot) SEO

2012-01-22 Thread Russ Michaels

why not just use URL rewriting to point
http://www.mydomain.com/cars/toyota/tacoma  at
http://www.mydomain.com/car_results.cfm?make=toyotamodel=tacoma
seems like this would be a much simpler solution

On Sun, Jan 22, 2012 at 4:30 PM, Dave Hatz daveh...@hatzventures.orgwrote:


 Dave,
 Thanks for the feedback. Let me try to explain how the client site is
 currently set up. Client has a search results page on his site, like this

 http://www.mydomain.com/car_results.cfm?make=toyotamodel=tacoma where
 the Car Model and Type are passed in as parameters.  The page uses CSS, JS
 and Images folders to produce the results page.

 Then he has gone and set up links that are set up on other sites to point
 to something like this

 http://www.mydomain.com/cars/toyota/tacoma

 and what the client wants is the for the .cmf page under /tacoma to parse
 the url for the car type and model then display the results on his
 car_results.cfm page from his site.  So our index.cfm parses the url and
 gets the make and model then redirects using CFLOCATION to the
 car_results.cfm page.

 Client is trying to gain SEO rankings on his
 http://www.mydomain.com/cars/toyota/tacoma page.  He has folders for
 different makers/models of cars, which is 100's of different folders.  We
 didn't want to have to create the same results page in all these different
 folders.

 You mentioned this approach was not a good idea.  I would love to find a
 better approach and your thoughts on how we can improve this 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:349598
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',

MySQL date problem

2012-01-22 Thread Dean Lawrence

I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. One of 
the properties of my object is a start date. Everything inserts and updates to 
the MySQL database without a problem. This issue that I am having is when I try 
to perform any CF date functions on the stored date.

If I try to do a datecompare or datediff function on the start date, I get a 
Date value passed to date function DateCompare is unspecified or invalid 
error message. However, if I try either isValid(date,Deal.getStartDate()) or 
isDate(Deal.getStartDate()), both return true. Any thoughts? 

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


Re: MySQL date problem

2012-01-22 Thread Dean Lawrence

Nevermind. Stupid mistake. I was looping over a number of records and it turns 
out that one of the records had a null value set which was what caused the 
error. Had nothing to do with MySQL dates at all. Ugh.


 I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. 
 One of the properties of my object is a start date. Everything inserts 
 and updates to the MySQL database without a problem. This issue that I 
 am having is when I try to perform any CF date functions on the stored 
 date.
 
 If I try to do a datecompare or datediff function on the start date, I 
 get a Date value passed to date function DateCompare is unspecified 
 or invalid error message. However, if I try either isValid(date,
 Deal.getStartDate()) or isDate(Deal.getStartDate()), both return true. 
 Any thoughts? 

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


Re: MySQL date problem

2012-01-22 Thread Russ Michaels

can you perform any date functions on it at all ?
Try running it through CreateDate() or CreateODBCDate() first and see if
that helps

On Sun, Jan 22, 2012 at 8:48 PM, Dean Lawrence dean...@gmail.com wrote:


 I have an app that I have created using CF 9.01, MySQL 5.1.41 and ORM. One
 of the properties of my object is a start date. Everything inserts and
 updates to the MySQL database without a problem. This issue that I am
 having is when I try to perform any CF date functions on the stored date.

 If I try to do a datecompare or datediff function on the start date, I get
 a Date value passed to date function DateCompare is unspecified or
 invalid error message. However, if I try either
 isValid(date,Deal.getStartDate()) or isDate(Deal.getStartDate()), both
 return true. Any thoughts?

 

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