Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Peter Boughton

 I have a (large) table that has a list of 
 users with IDs of newUsers and oldUsers.

This is wrong!

Every ID on the page *must* be unique.

Use CLASS for common attributes. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328343
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Eric Cobb

Thank you Azadi!  I figured it was something simple like that.  I'll 
give it a try and let you know how it goes.


Azadi Saryev wrote:
 your html is not valid: id's are supposed to be unique per page.
 chnage that and you'll see ff work fine.
 
 Azadi Saryev
 Sabai-dee.com
 http://www.sabai-dee.com/
 
 
 On 13/11/2009 06:38, Eric Cobb wrote:
 Oh, the horror to see my beloved FireFox crash repeatedly when trying to 
 run some jQuery that works flawlessly in IE 8!  (I thought it was 
 supposed to be the other way around!)

 Seriously though, I do have a chunk of jQuery that I hope someone here 
 can help me with.  Basically, I have a (large) table that has a list of 
 users with IDs of newUsers and oldUsers.  I have a checkbox that 
 displays/hides the oldUsers.  In IE everything works instantaneously. 
   But in FireFox when you first check the box it takes several seconds 
 to hide the oldUsers.  Then, when you uncheck the box to display the 
 oldUsers again, it changes the display instantly but then the browser 
 hangs and crashes every time.

 Now, as I mentioned before this table is large, with somewhere around 
 500 rows.  Is this too much for FF/jQuery to handle?  I thought about 
 breaking it up between 2 separate newUsers and oldUsers divs and 
 just toggle the display accordingly, but I'd rather do it in one table 
 if I could.

 
 Here's my jQuery:

 $(document).ready(function() {
  //table striping
  
 $('table.stripetbodytr:even').addClass(lite);
  $('table.stripetbodytr:odd').addClass(dark);

  //Display/Hide new and old user tables rows.
  $(#userFilter).click(function(){
  // If checked
  if ($(#userFilter).is(:checked)){
  //hide all old users
 
  $('table.stripetbodytr:not(#newUsers)').hide();
  }
  else {
  //show all old users
 
  $('table.stripetbodytr:not(#newUsers)').show();
  }
  });
  });


 
 Here's my table:

 table cellpadding=1 cellspacing=1 class=stripe
  tbody
  tr id=oldUsers  
 tdOld Test User/td
  td align=centerStuff/td
  td align=centerStuff/td
  td align=centerStuff/td   
 /tr
tr 
 id=oldUsers   
 tdOld Test User/td
  td align=centerStuff/td
  td align=centerStuff/td
  td align=centerStuff/td   
 /tr
tr 
 id=newUsers   
 tdNew Test User/td
  td align=centerStuff/td
  td align=centerStuff/td
  td align=centerStuff/td   
 /tr
tr 
 id=oldUsers   
 tdNew Test User/td
  td align=centerStuff/td
  td align=centerStuff/td
  td align=centerStuff/td   
 /tr   
  /tbody
 !-- Rinse and repeat about 490 more times --   
 
 /table


 Any ideas as to why this would be killing FireFox?  Is it just the way 
 FF handles processing the display/hide of so many table rows?


   
 
 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328344
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Eric Cobb

Yeah, after tinkering with it a little more I realized what I was trying 
to do would be better with classes instead of IDs.  I really didn't want 
to have to deal with a unique ID for all 500 rows.

Anyway, here's my jQuery now:

$(#userFilter).click(function(){   
// If checked
if ($(#userFilter).is(:checked)){
//hide all old users
$(.oldUsers).css(display,none);
}
else { 
 //show all old users
$(.oldUsers).css(display,table-row);
}
});

It works correctly in both FF and IE, although in FF there's still a 
good bit of lag time from when you click the checkbox until it actually 
hides the rows.  I guess it's just the way FF is dealing with so many 
table rows.

-- 

Thanks,

Eric Cobb
http://www.cfgears.com



Peter Boughton wrote:
 I have a (large) table that has a list of 
 users with IDs of newUsers and oldUsers.
 

 This is wrong!

 Every ID on the page *must* be unique.

 Use CLASS for common attributes. 

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328345
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


(ot) SQL Question - flattening data

2009-11-13 Thread Rick Root

I'm trying to flatten out some data using only SQL we currently
have a mainframe job that produces a datafeed for me uses cobol to
do the work of looping through all the entities and putting up to 5
record types in 5 record type fields in the output file.  I'm trying
to figure out a way to do it with SQL alone so I can just use a
transact-sql job to produced my flattened reporting table.

So for example, let's say I've got a table like this:

create table entityRecordTypes
(
entityid char(10),
recordType char(2),
primary key (entityid, recordType)
);

How do I get from here ...

rick,AL
rick,FR
rick,TR
rick,HS
joe,AL
joe,FU
Bob,FM

to a view or table that has this structure 

entityid,rectype1,rectype2,rectype3,rectype4,rectype5
rick,AL,FR,TR,HS,NULL
joe,AL,FU,NULL,NULL,NULL
bob,FM,NULL,NULL,NULL,NULL

using SQL.

if an entity had more than 5 record types, only the first 5 would be
put into the output table/view.

Rick

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328346
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CKEditor

2009-11-13 Thread Rick Root

I think CFFM integrates pretty easily into CKeditor so don't let
CKeditor's lack of a free file browser stop you from using it.  Both
CFFM 1.22 (the non-ajax version) and 1.31 (the ajax version) work
pretty well in CKeditor 3.0.

Rick

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328347
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: ColdFusion.Window.create set bodystyle attribute

2009-11-13 Thread Joshua Rowe

Hmmm.. The background color is gray by default on my machine for whatever
reason.  Also, for some reason, the headerstyle attribute works, but the
bodystyle attribute does not.  I'll play around with it some more and see if
I can get it to work.


-Original Message-
From: Azadi Saryev [mailto:az...@sabai-dee.com] 
Sent: Thursday, November 12, 2009 7:16 PM
To: cf-talk
Subject: Re: ColdFusion.Window.create set bodystyle attribute


this code worked fine for me - a cfwindow with blindingly blue background
popped up:

cfajaximport tags=cfwindow!--- need this because cfwindow is created
via js only --- script type=text/javascript doWindow = function() {
var wConfig = new Object();
wConfig.bodystyle = background-color: blue; //changed it to 'blue'
wConfig.center = true; //center the window on page
ColdFusion.Window.create('mywin', 'test window', 'some-page.cfm',
wConfig); //change some-page.cfm to your url } /script body
onload=doWindow(); /body

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/


On 13/11/2009 08:15, Joshua Rowe wrote:
 How do I set the bodystyle attribute for the ColdFusion.Window.create()
function?  I tried creating a JavaScript object like so, but it didn't work:

 var windowConfig = new Object();
 windowConfig.bodystyle = background-color: white;; 
 ColdFusion.Window.create(name, title, url, windowConfig);

 I read somewhere that you cannot set the bodystyle attribute when creating
a cfwindow this way.  Any thoughts? 

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328348
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Better manage bulk update process

2009-11-13 Thread Agha Mehdi

there are other tasks that run at the same time too but none that would
interact with the same tables. One thing I did notice though that there is
only one task that runs at 8:00 PM (which is this one) and there are 4
different tasks that run at 8:00 AM (including this task). Could that be an
issue?

On Thu, Nov 12, 2009 at 6:25 PM, Maureen mamamaur...@gmail.com wrote:


 Is there any chance the morning run is conflicting with another task,
 like a backup, or another import, and just stalling?

 On Thu, Nov 12, 2009 at 4:29 PM, Agha Mehdi aghaime...@gmail.com wrote:
 
  Yup. that's what I am doing now. CFTransaction is an option but it won't
 do
  me any good if for some reason the processing just stops without any
 error.
  It is strange but that's what's happening. I haven't found any errors in
 the
  logs. Also, it gets more interesting as the task runs every 12 hours. the
  one that runs in the evening is fine and the one running in the morning
 has
  started to not run after deleting records from two tables. I am also
 going
  to start writing each row's insert/update success to a log file to see
  exactly what's going on.

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328349
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: itemSelectEvent : Coldfusion AutoSuggest?

2009-11-13 Thread Tony Bentley

Never mind. I used the better autosuggest. Too bad Coldfusion did not make all 
of the methods available as attributes in the input. 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328350
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Nicholas Stein

Maybe I am missing something.  Why not just to it this way...
cfset rNum = 0
cfoutput query=searchresults
cfset rNum = rNum + 1
trcfif rNum MOD 2 EQ 0 class=alternaterow/cfif
...display td/td
/tr
/cfoutput

Nick 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328351
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Charlie Griefer

Preference.

Some people would prefer to not introduce the extra CFML markup into the
HTML markup.

The jQuery lets you manipulate the HTML without actually modifying the
HTML.  That's nice.
The CF method will work even if the user has JS disabled.  That's nice.

Neither is right or wrong.

On Fri, Nov 13, 2009 at 9:29 AM, Nicholas Stein nicholasst...@cox.netwrote:


 Maybe I am missing something.  Why not just to it this way...
 cfset rNum = 0
 cfoutput query=searchresults
 cfset rNum = rNum + 1
 trcfif rNum MOD 2 EQ 0 class=alternaterow/cfif
 ...display td/td
 /tr
 /cfoutput

 Nick

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328352
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Better manage bulk update process

2009-11-13 Thread Agha Mehdi

I also just thought of something. I am using the following setting;

Frequency: Daily every 12 hours start time: 11:00 PM. Do I need to specify
End time too?

On Fri, Nov 13, 2009 at 8:58 AM, Agha Mehdi aghaime...@gmail.com wrote:

 there are other tasks that run at the same time too but none that would
 interact with the same tables. One thing I did notice though that there is
 only one task that runs at 8:00 PM (which is this one) and there are 4
 different tasks that run at 8:00 AM (including this task). Could that be an
 issue?


 On Thu, Nov 12, 2009 at 6:25 PM, Maureen mamamaur...@gmail.com wrote:


 Is there any chance the morning run is conflicting with another task,
 like a backup, or another import, and just stalling?

 On Thu, Nov 12, 2009 at 4:29 PM, Agha Mehdi aghaime...@gmail.com wrote:
 
  Yup. that's what I am doing now. CFTransaction is an option but it won't
 do
  me any good if for some reason the processing just stops without any
 error.
  It is strange but that's what's happening. I haven't found any errors in
 the
  logs. Also, it gets more interesting as the task runs every 12 hours.
 the
  one that runs in the evening is fine and the one running in the morning
 has
  started to not run after deleting records from two tables. I am also
 going
  to start writing each row's insert/update success to a log file to see
  exactly what's going on.

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328353
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) SQL Question - flattening data

2009-11-13 Thread Dave Phelan

Is there a particular reason to return them in this format?  I would think that 
the straight query output would be simpler to work with. However, you can 
accomplish this either by using cursors to loop over the query output and build 
what you are looking for or by building a crosstab query of the data.  I 
haven't built a crosstab query in quite a while and don't remember all the 
specifics, but the output would be similar to:


Entity  AL  FR  TR  HS  FU  FM
RickX   X   X   X
Joe X   X
Bob X


Crosstab queries can be a little hairy to build.  IMHO, go with the cursors.



-Original Message-
From: Rick Root [mailto:rick.r...@gmail.com] 
Sent: Friday, November 13, 2009 10:41 AM
To: cf-talk
Subject: (ot) SQL Question - flattening data


I'm trying to flatten out some data using only SQL we currently
have a mainframe job that produces a datafeed for me uses cobol to
do the work of looping through all the entities and putting up to 5
record types in 5 record type fields in the output file.  I'm trying
to figure out a way to do it with SQL alone so I can just use a
transact-sql job to produced my flattened reporting table.

So for example, let's say I've got a table like this:

create table entityRecordTypes
(
entityid char(10),
recordType char(2),
primary key (entityid, recordType)
);

How do I get from here ...

rick,AL
rick,FR
rick,TR
rick,HS
joe,AL
joe,FU
Bob,FM

to a view or table that has this structure 

entityid,rectype1,rectype2,rectype3,rectype4,rectype5
rick,AL,FR,TR,HS,NULL
joe,AL,FU,NULL,NULL,NULL
bob,FM,NULL,NULL,NULL,NULL

using SQL.

if an entity had more than 5 record types, only the first 5 would be
put into the output table/view.

Rick



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328354
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Josh Nathanson

You might get a tad bit more speed if you do this in your selectors:

$(table.stripetbodytr.oldUsers)

Instead of this:

$(.oldUsers)

This is because jQuery will execute the DOM search more specifically instead
of having to traverse the whole DOM for that class.

-- Josh



-Original Message-
From: Eric Cobb [mailto:cft...@ecartech.com] 
Sent: Friday, November 13, 2009 6:26 AM
To: cf-talk
Subject: Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in
IE!


Yeah, after tinkering with it a little more I realized what I was trying 
to do would be better with classes instead of IDs.  I really didn't want 
to have to deal with a unique ID for all 500 rows.

Anyway, here's my jQuery now:

$(#userFilter).click(function(){   
// If checked
if ($(#userFilter).is(:checked)){
//hide all old users
$(.oldUsers).css(display,none);
}
else { 
 //show all old users
$(.oldUsers).css(display,table-row);
}
});

It works correctly in both FF and IE, although in FF there's still a 
good bit of lag time from when you click the checkbox until it actually 
hides the rows.  I guess it's just the way FF is dealing with so many 
table rows.

-- 

Thanks,

Eric Cobb
http://www.cfgears.com



Peter Boughton wrote:
 I have a (large) table that has a list of 
 users with IDs of newUsers and oldUsers.
 

 This is wrong!

 Every ID on the page *must* be unique.

 Use CLASS for common attributes. 

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328355
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Better manage bulk update process

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)

I'd say no.  The end time is only if you want the job to run between
certain hours.

For example I have a job that runs every 5 minutes between 8am and 4pm.

Steve


-Original Message-
From: Agha Mehdi [mailto:aghaime...@gmail.com] 
Sent: Friday, November 13, 2009 12:58 PM
To: cf-talk
Subject: Re: Better manage bulk update process


I also just thought of something. I am using the following setting;

Frequency: Daily every 12 hours start time: 11:00 PM. Do I need to
specify
End time too?

On Fri, Nov 13, 2009 at 8:58 AM, Agha Mehdi aghaime...@gmail.com
wrote:

 there are other tasks that run at the same time too but none that
would
 interact with the same tables. One thing I did notice though that
there is
 only one task that runs at 8:00 PM (which is this one) and there are 4
 different tasks that run at 8:00 AM (including this task). Could that
be an
 issue?


 On Thu, Nov 12, 2009 at 6:25 PM, Maureen mamamaur...@gmail.com
wrote:


 Is there any chance the morning run is conflicting with another task,
 like a backup, or another import, and just stalling?

 On Thu, Nov 12, 2009 at 4:29 PM, Agha Mehdi aghaime...@gmail.com
wrote:
 
  Yup. that's what I am doing now. CFTransaction is an option but it
won't
 do
  me any good if for some reason the processing just stops without
any
 error.
  It is strange but that's what's happening. I haven't found any
errors in
 the
  logs. Also, it gets more interesting as the task runs every 12
hours.
 the
  one that runs in the evening is fine and the one running in the
morning
 has
  started to not run after deleting records from two tables. I am
also
 going
  to start writing each row's insert/update success to a log file to
see
  exactly what's going on.

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328356
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) SQL Question - flattening data

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)

Actually, if MSSQL 2005+ is being used, PIVOT might come in handy here.

I had a procedure that used cursors. It ran for 2 minutes.  I converted
it to use PIVOT instead and I get the same results in 2 seconds!

Steve


-Original Message-
From: Dave Phelan [mailto:dphe...@lifepoint.com] 
Sent: Friday, November 13, 2009 1:11 PM
To: cf-talk
Subject: RE: (ot) SQL Question - flattening data


Is there a particular reason to return them in this format?  I would
think that the straight query output would be simpler to work with.
However, you can accomplish this either by using cursors to loop over
the query output and build what you are looking for or by building a
crosstab query of the data.  I haven't built a crosstab query in quite a
while and don't remember all the specifics, but the output would be
similar to:


Entity  AL  FR  TR  HS  FU  FM
RickX   X   X   X
Joe X   X
Bob X


Crosstab queries can be a little hairy to build.  IMHO, go with the
cursors.



-Original Message-
From: Rick Root [mailto:rick.r...@gmail.com] 
Sent: Friday, November 13, 2009 10:41 AM
To: cf-talk
Subject: (ot) SQL Question - flattening data


I'm trying to flatten out some data using only SQL we currently
have a mainframe job that produces a datafeed for me uses cobol to
do the work of looping through all the entities and putting up to 5
record types in 5 record type fields in the output file.  I'm trying
to figure out a way to do it with SQL alone so I can just use a
transact-sql job to produced my flattened reporting table.

So for example, let's say I've got a table like this:

create table entityRecordTypes
(
entityid char(10),
recordType char(2),
primary key (entityid, recordType)
);

How do I get from here ...

rick,AL
rick,FR
rick,TR
rick,HS
joe,AL
joe,FU
Bob,FM

to a view or table that has this structure 

entityid,rectype1,rectype2,rectype3,rectype4,rectype5
rick,AL,FR,TR,HS,NULL
joe,AL,FU,NULL,NULL,NULL
bob,FM,NULL,NULL,NULL,NULL

using SQL.

if an entity had more than 5 record types, only the first 5 would be
put into the output table/view.

Rick





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328357
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cfgrid

2009-11-13 Thread Won Lee

Hello,

is cfgrid broken?  the insert can't seem to add more than one row before it
returns a uncaught exception: Multiple row insert is not supported error
message.  I would really like to avoid building out the grid in ext myself.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328358
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Eric Cobb

I'm not sure if you guys are following what I'm trying to do

I want to dynamically hide/display certain table rows when a checkbox is 
selected/deselected.

-- 

Thanks,

Eric Cobb
http://www.cfgears.com



Charlie Griefer wrote:
 Preference.

 Some people would prefer to not introduce the extra CFML markup into the
 HTML markup.

 The jQuery lets you manipulate the HTML without actually modifying the
 HTML.  That's nice.
 The CF method will work even if the user has JS disabled.  That's nice.

 Neither is right or wrong.

 On Fri, Nov 13, 2009 at 9:29 AM, Nicholas Stein nicholasst...@cox.netwrote:

   
 Maybe I am missing something.  Why not just to it this way...
 cfset rNum = 0
 cfoutput query=searchresults
 cfset rNum = rNum + 1
 trcfif rNum MOD 2 EQ 0 class=alternaterow/cfif
 ...display td/td
 /tr
 /cfoutput

 Nick


 

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328359
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Eric Cobb

Thanks Josh!  I'll give that a whirl and see how it works.

-- 

Thanks,

Eric Cobb
http://www.cfgears.com



Josh Nathanson wrote:
 You might get a tad bit more speed if you do this in your selectors:

 $(table.stripetbodytr.oldUsers)

 Instead of this:

 $(.oldUsers)

 This is because jQuery will execute the DOM search more specifically instead
 of having to traverse the whole DOM for that class.

 -- Josh



 -Original Message-
 From: Eric Cobb [mailto:cft...@ecartech.com] 
 Sent: Friday, November 13, 2009 6:26 AM
 To: cf-talk
 Subject: Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in
 IE!


 Yeah, after tinkering with it a little more I realized what I was trying 
 to do would be better with classes instead of IDs.  I really didn't want 
 to have to deal with a unique ID for all 500 rows.

 Anyway, here's my jQuery now:

 $(#userFilter).click(function(){   
   // If checked
   if ($(#userFilter).is(:checked)){
   //hide all old users
   $(.oldUsers).css(display,none);
   }
   else { 
//show all old users
   $(.oldUsers).css(display,table-row);
   }
 });

 It works correctly in both FF and IE, although in FF there's still a 
 good bit of lag time from when you click the checkbox until it actually 
 hides the rows.  I guess it's just the way FF is dealing with so many 
 table rows.

   



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328360
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Charlie Griefer

On Fri, Nov 13, 2009 at 10:47 AM, Eric Cobb cft...@ecartech.com wrote:


 I'm not sure if you guys are following what I'm trying to do

 I want to dynamically hide/display certain table rows when a checkbox is
 selected/deselected.


No, I was with ya.

I recognized that the question had to do with table striping in CF vs
jQuery, and wasn't really pertinent to the original question, but figured
I'd take a shot at answering :)

-- 
Charlie Griefer
http://charlie.griefer.com/

I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328361
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Better manage bulk update process

2009-11-13 Thread Jason Fisher

No, you shouldn't need to specify end, but make sure there's a timeout 
sufficient for the process to complete.
 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328362
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


JPG in Database - Retrieve for web page

2009-11-13 Thread Kim Hoopingarner

I have not tried this before - so I thought I might see if this is feasible.  

I have stored 2 jpgs in my database - one for the header of the site and one 
for the left side graphic.

I want to retrieve these 2 BLOBS and place them on my web page - removing the 
need to have the jpg on my file server.

Possible?  If so - hints? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328363
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JPG in Database - Retrieve for web page

2009-11-13 Thread Jacob

You can store just about any type of file in a database.. jpg, doc, gif.

Performance would be my only issue. If just two jpg, should be okay.

But, for us, storing 10s of jpgs was a performance nightmare. So we keep
the jpg on the hard drives with the path to the jgp in the database.

-Original Message-
From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com] 
Sent: Friday, November 13, 2009 12:06 PM
To: cf-talk
Subject: JPG in Database - Retrieve for web page


I have not tried this before - so I thought I might see if this is feasible.


I have stored 2 jpgs in my database - one for the header of the site and one
for the left side graphic.

I want to retrieve these 2 BLOBS and place them on my web page - removing
the need to have the jpg on my file server.

Possible?  If so - hints? 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328364
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


onRequestEnd.cfm exploit (need help)

2009-11-13 Thread Michael Patti

Three of my CF7-driven sites just got hit this morning with an exploit that I'm 
having trouble finding information on.

The attack did the following:
1) wrote 0 KB Application.cfm file to the web-root of the sites
2) wrote an onRequestEnd.cfm file (also to the web-root) that contained a 
script src pointing to a site that looks to have been turned into a bot.

The net result was that anyone who entered a keyword in a search engine that 
directed them to a page on our sites would be re-directed to 
http://c-car.co.cc/s/search.php?q=[search keywords] where [search keywords] = 
the search term used by the person to reach our site.

I'm trying to find the vector for this attack, and haven't had luck yet.  It 
doesn't look like the application.cfm and onRequestEnd.cfm files were written 
via FTP (no unusual activity today), and while these sites do have some 
public-facing file upload forms, the permissions on those are pretty well 
locked down.

Has anyone out there seen this type of attack before, or is this something new?

Thanks for any help you can provide.





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328365
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JPG in Database - Retrieve for web page

2009-11-13 Thread Kim Hoopingarner

Thanks for the heads up on performance.  Will definitely warn client.

What is the trick to streaming to a web page?  I am using the cfheader and 
cfcontent - to no avail.  It puts the header out - and then the next line is 
not seen.  here's my simple code ... just trying to get one of those BLOBS to 
work with a cfinput tag.

cfform name=x action=home.cfm 
  cfinvoke component=#session.cfc#.msr_multisigs method=getMSigImage 
returnvariable=qMsigImage
  /cfinvoke

  div
cfheader name=Content-Disposition value=inline
cfcontent type=image/jpg variable=binaryObject 

  /div
  div

cfinput type=text value=HELLO name=x

  /div
  /cfform 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328366
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JPG in Database - Retrieve for web page

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)

I don't fully remember but I believe that you have to wrap the data in
toBase64()

-Original Message-
From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com] 
Sent: Friday, November 13, 2009 3:20 PM
To: cf-talk
Subject: Re: JPG in Database - Retrieve for web page


Thanks for the heads up on performance.  Will definitely warn client.

What is the trick to streaming to a web page?  I am using the cfheader
and cfcontent - to no avail.  It puts the header out - and then the next
line is not seen.  here's my simple code ... just trying to get one of
those BLOBS to work with a cfinput tag.

cfform name=x action=home.cfm 
  cfinvoke component=#session.cfc#.msr_multisigs
method=getMSigImage returnvariable=qMsigImage
  /cfinvoke

  div
cfheader name=Content-Disposition value=inline
cfcontent type=image/jpg variable=binaryObject 

  /div
  div

cfinput type=text value=HELLO name=x

  /div
  /cfform 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328367
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JPG in Database - Retrieve for web page

2009-11-13 Thread Kim Hoopingarner

CORRECT CODE!
 
 cfform name=x action=home.cfm 
  
 cfinvoke component=cfc.msr_multisigs method=getMSigImage
returnvariable=qMsigImage
  
 /cfinvoke
 
  
 div
cfheader name=Content-Disposition value=inline
cfcontent type=image/jpg variable=qMsigImage.binaryObject 
 /div
  
 div
cfinput type=text value=HELLO name=x
 /div

/cfform 


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328368
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JPG in Database - Retrieve for web page

2009-11-13 Thread Kim Hoopingarner

That gives an error that my data must be binary on the cfcontent.  Any other 
thoughts? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328369
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JPG in Database - Retrieve for web page

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)

toBinary() ?

-Original Message-
From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com] 
Sent: Friday, November 13, 2009 3:25 PM
To: cf-talk
Subject: Re: JPG in Database - Retrieve for web page


That gives an error that my data must be binary on the cfcontent.  Any
other thoughts? 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328370
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JPG in Database - Retrieve for web page

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)

You may have to do toBinary(toBase64(yourVariable))

-Original Message-
From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com] 
Sent: Friday, November 13, 2009 3:25 PM
To: cf-talk
Subject: Re: JPG in Database - Retrieve for web page


That gives an error that my data must be binary on the cfcontent.  Any
other thoughts? 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328371
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JPG in Database - Retrieve for web page

2009-11-13 Thread Leigh

 That gives an error that my data must be binary on the
 cfcontent.  Any other thoughts? 
 cfcontent type=image/jpg variable=qMsigImage.binaryObject  

You forgot the # signs. So CF thinks the value is the literal string: 
qMsigImage.binaryObject:

cfcontent type=image/jpg variable=#qMsigImage.binaryObject#  


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328372
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JPG in Database - Retrieve for web page

2009-11-13 Thread DURETTE, STEVEN J (ATTASIAIT)

Well, Time for me to climb back down into the hole and hide my head!  :)

-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com] 
Sent: Friday, November 13, 2009 3:37 PM
To: cf-talk
Subject: Re: JPG in Database - Retrieve for web page


 That gives an error that my data must be binary on the
 cfcontent.  Any other thoughts? 
 cfcontent type=image/jpg variable=qMsigImage.binaryObject  

You forgot the # signs. So CF thinks the value is the literal string: 
qMsigImage.binaryObject:

cfcontent type=image/jpg variable=#qMsigImage.binaryObject#  


 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328373
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JPG in Database - Retrieve for web page

2009-11-13 Thread Leigh

 Well, Time for me to climb back down into the hole and hide
 my head!  :)

Brew a fresh pot of coffee would you? I am sure one of us will be joining you 
there soon enough ;-)


 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328374
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Andy Matthews

Josh...

That's not true. Everything I've read says that the less specific you are,
the faster your code will run.

In your example, it has to search through a whole bunch of stuff rather than
just going and finding items with a class of oldUsers.



andy 

-Original Message-
From: Josh Nathanson [mailto:p...@oakcitygraphics.com] 
Sent: Friday, November 13, 2009 12:20 PM
To: cf-talk
Subject: RE: 'Tis a sad, sad day...jQuery kills FireFox but works great in
IE!


You might get a tad bit more speed if you do this in your selectors:

$(table.stripetbodytr.oldUsers)

Instead of this:

$(.oldUsers)

This is because jQuery will execute the DOM search more specifically instead
of having to traverse the whole DOM for that class.

-- Josh



-Original Message-
From: Eric Cobb [mailto:cft...@ecartech.com]
Sent: Friday, November 13, 2009 6:26 AM
To: cf-talk
Subject: Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in
IE!


Yeah, after tinkering with it a little more I realized what I was trying 
to do would be better with classes instead of IDs.  I really didn't want 
to have to deal with a unique ID for all 500 rows.

Anyway, here's my jQuery now:

$(#userFilter).click(function(){   
// If checked
if ($(#userFilter).is(:checked)){
//hide all old users
$(.oldUsers).css(display,none);
}
else { 
 //show all old users
$(.oldUsers).css(display,table-row);
}
});

It works correctly in both FF and IE, although in FF there's still a 
good bit of lag time from when you click the checkbox until it actually 
hides the rows.  I guess it's just the way FF is dealing with so many 
table rows.

-- 

Thanks,

Eric Cobb
http://www.cfgears.com



Peter Boughton wrote:
 I have a (large) table that has a list of 
 users with IDs of newUsers and oldUsers.
 

 This is wrong!

 Every ID on the page *must* be unique.

 Use CLASS for common attributes. 

 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328375
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Andy Matthews

Eric. I've tried to do showing and hiding table rows with jQuery before and
it's not that great. It has to do with the way JavaScript considers TR tags
and all. Try taking a look at this example I wrote for Psychic Sales a long
time ago:

http://andymatthews.net/code/tablefilter/

-Original Message-
From: Eric Cobb [mailto:cft...@ecartech.com] 
Sent: Friday, November 13, 2009 12:48 PM
To: cf-talk
Subject: Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in
IE!


I'm not sure if you guys are following what I'm trying to do

I want to dynamically hide/display certain table rows when a checkbox is
selected/deselected.

-- 

Thanks,

Eric Cobb
http://www.cfgears.com



Charlie Griefer wrote:
 Preference.

 Some people would prefer to not introduce the extra CFML markup into 
 the HTML markup.

 The jQuery lets you manipulate the HTML without actually modifying the 
 HTML.  That's nice.
 The CF method will work even if the user has JS disabled.  That's nice.

 Neither is right or wrong.

 On Fri, Nov 13, 2009 at 9:29 AM, Nicholas Stein
nicholasst...@cox.netwrote:

   
 Maybe I am missing something.  Why not just to it this way...
 cfset rNum = 0
 cfoutput query=searchresults
 cfset rNum = rNum + 1
 trcfif rNum MOD 2 EQ 0 class=alternaterow/cfif ...display 
 td/td /tr /cfoutput

 Nick


 

 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328376
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: (ot) SQL Question - flattening data

2009-11-13 Thread Rick Root

From the documentation, pivot tables seem to require aggregate
functions... The generic description would seem to work but the
examples make it difficult to see how.

But... I figured out a solution!  Using SQL Server's row_number() over
(partition by XXX order by XXX) I can make a subquery that returns
data like this

entityid,rownum,rectyp

And then run this query (tb901 is my primary table)

select
tb901.entityid,
R1.rectypcd as rectype1,
r2.rectypcd as rectype2,
r3.rectypcd as rectype3,
r4.rectypcd as rectype4,
r5.rectypcd as rectype5
from
tb901
left join
(
select row_number() over(partition by entityid order by 
rectypcd)
as rownum, entityid, rectypcd
from tb906
) R1 on tb901.entityid=R1.entityid and R1.rownum=1
left join
(
select row_number() over(partition by entityid order by 
rectypcd)
as rownum, entityid, rectypcd
from tb906
) R2 on tb901.entityid=R2.entityid and R2.rownum=2
left join
(
select row_number() over(partition by entityid order by 
rectypcd)
as rownum, entityid, rectypcd
from tb906
) R3 on tb901.entityid=R3.entityid and R3.rownum=3
left join
(
select row_number() over(partition by entityid order by 
rectypcd)
as rownum, entityid, rectypcd
from tb906
) R4 on tb901.entityid=R4.entityid and R4.rownum=4
left join
(
select row_number() over(partition by entityid order by 
rectypcd)
as rownum, entityid, rectypcd
from tb906
) R5 on tb901.entityid=R5.entityid and R5.rownum=5

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328377
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: onRequestEnd.cfm exploit (need help)

2009-11-13 Thread Dave Watts

 Three of my CF7-driven sites just got hit this morning with an exploit that 
 I'm having trouble  finding information on.

 The attack did the following:
 1) wrote 0 KB Application.cfm file to the web-root of the sites
 2) wrote an onRequestEnd.cfm file (also to the web-root) that contained a 
 script src
 pointing to a site that looks to have been turned into a bot.

 The net result was that anyone who entered a keyword in a search engine that 
 directed
 them to a page on our sites would be re-directed to 
 http://c-car.co.cc/s/search.php?q=
 [search keywords] where [search keywords] = the search term used by the 
 person to
 reach our site.

 I'm trying to find the vector for this attack, and haven't had luck yet.  It 
 doesn't look like the
 application.cfm and onRequestEnd.cfm files were written via FTP (no unusual 
 activity
 today), and while these sites do have some public-facing file upload forms, 
 the
 permissions on those are pretty well locked down.

 Has anyone out there seen this type of attack before, or is this something 
 new?

I'm not aware of any specific new attack that does exactly this, but I
suspect that your web server's log files will have the specific URLs
used to launch the attack.

If you're running CF on Windows, and CF is running as SYSTEM (which is
the default), then CF can rewrite .cfm files. So, if it doesn't look
like an FTP problem, that's the most likely vector.

Did you apply the recent security patches for FCKEditor from Adobe?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328378
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Post a form synchronously even though it is in a cfdiv

2009-11-13 Thread David Mineer

How do I force a form to post synchronously even thought it is inside a
cfdiv and therefore defaults to posting asynchronously?

-- 
David Mineer Jr
-
The critical ingredient is getting off your
butt and doing something. It's as simple
as that. A lot of people have ideas, but
there are few who decide to do
something about them now. Not
tomorrow. Not next week. But today.
The true entrepreneur is a doer.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328379
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Post a form synchronously even though it is in a cfdiv

2009-11-13 Thread Dave Watts

 How do I force a form to post synchronously even thought it is inside a
 cfdiv and therefore defaults to posting asynchronously?

What exactly do you mean? Do you want the entire page to refresh, not
just the contents of the CFDIV? If so, just change the TARGET to
incorporate the entire page (target=_top).

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328380
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Josh Nathanson

Hmmm...ok, maybe I was thinking of the difference between ID and class or
something.  Sorry about that.

-- Josh


-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com] 
Sent: Friday, November 13, 2009 12:52 PM
To: cf-talk
Subject: RE: 'Tis a sad, sad day...jQuery kills FireFox but works great in
IE!


Josh...

That's not true. Everything I've read says that the less specific you are,
the faster your code will run.

In your example, it has to search through a whole bunch of stuff rather than
just going and finding items with a class of oldUsers.



andy 

-Original Message-
From: Josh Nathanson [mailto:p...@oakcitygraphics.com] 
Sent: Friday, November 13, 2009 12:20 PM
To: cf-talk
Subject: RE: 'Tis a sad, sad day...jQuery kills FireFox but works great in
IE!


You might get a tad bit more speed if you do this in your selectors:

$(table.stripetbodytr.oldUsers)

Instead of this:

$(.oldUsers)

This is because jQuery will execute the DOM search more specifically instead
of having to traverse the whole DOM for that class.

-- Josh



-Original Message-
From: Eric Cobb [mailto:cft...@ecartech.com]
Sent: Friday, November 13, 2009 6:26 AM
To: cf-talk
Subject: Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in
IE!


Yeah, after tinkering with it a little more I realized what I was trying 
to do would be better with classes instead of IDs.  I really didn't want 
to have to deal with a unique ID for all 500 rows.

Anyway, here's my jQuery now:

$(#userFilter).click(function(){   
// If checked
if ($(#userFilter).is(:checked)){
//hide all old users
$(.oldUsers).css(display,none);
}
else { 
 //show all old users
$(.oldUsers).css(display,table-row);
}
});

It works correctly in both FF and IE, although in FF there's still a 
good bit of lag time from when you click the checkbox until it actually 
hides the rows.  I guess it's just the way FF is dealing with so many 
table rows.

-- 

Thanks,

Eric Cobb
http://www.cfgears.com



Peter Boughton wrote:
 I have a (large) table that has a list of 
 users with IDs of newUsers and oldUsers.
 

 This is wrong!

 Every ID on the page *must* be unique.

 Use CLASS for common attributes. 

 







~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328381
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Post a form synchronously even though it is in a cfdiv

2009-11-13 Thread David Mineer

That is what I mean.  It submits inside the cfdiv, show the target page
pulls up completely inside the cfdiv.  I want it to pull up on a new page.
I changed the cfform to just use form and that fixed it for me, but I didn't
need any cfform goodness this time.  I did breifly test your _top suggestion
and that didn't make a difference when I was still using CFFORM.

On Fri, Nov 13, 2009 at 2:49 PM, Dave Watts dwa...@figleaf.com wrote:


  How do I force a form to post synchronously even thought it is inside a
  cfdiv and therefore defaults to posting asynchronously?

 What exactly do you mean? Do you want the entire page to refresh, not
 just the contents of the CFDIV? If so, just change the TARGET to
 incorporate the entire page (target=_top).

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/

 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328382
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFMAP Problems in firefox

2009-11-13 Thread David Mineer

We are passing some addresses to the cfmap tag and it is working awesome.
In IE.  But in firefox it cuts of the right side of the map.  Normally you
see the map, hybrid, and satellite buttons.  In firefox it cuts it off so
you only barely see the left side of the map button, which is the leftmost
button, so it is cutting of quite a bit.

Chrom also does the same thing.

Has anyone ran into this and do you have a solution?

-- 
David Mineer Jr
-
The critical ingredient is getting off your
butt and doing something. It's as simple
as that. A lot of people have ideas, but
there are few who decide to do
something about them now. Not
tomorrow. Not next week. But today.
The true entrepreneur is a doer.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328383
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CFMAP Problems in firefox

2009-11-13 Thread David Mineer

This has something to do with the css that we are using, cause when we
remove it it works.  Now to track down the specific part of the css and find
a solution.

On Fri, Nov 13, 2009 at 3:49 PM, David Mineer min...@gmail.com wrote:

 We are passing some addresses to the cfmap tag and it is working awesome.
 In IE.  But in firefox it cuts of the right side of the map.  Normally you
 see the map, hybrid, and satellite buttons.  In firefox it cuts it off so
 you only barely see the left side of the map button, which is the leftmost
 button, so it is cutting of quite a bit.

 Chrom also does the same thing.

 Has anyone ran into this and do you have a solution?

 --
 David Mineer Jr
 -
 The critical ingredient is getting off your
 butt and doing something. It's as simple
 as that. A lot of people have ideas, but
 there are few who decide to do
 something about them now. Not
 tomorrow. Not next week. But today.
 The true entrepreneur is a doer.




-- 
David Mineer Jr
-
The critical ingredient is getting off your
butt and doing something. It's as simple
as that. A lot of people have ideas, but
there are few who decide to do
something about them now. Not
tomorrow. Not next week. But today.
The true entrepreneur is a doer.


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328384
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Better manage bulk update process

2009-11-13 Thread Maureen

Do any of the other tasks use the tables you are deleting or updating?

On Fri, Nov 13, 2009 at 8:58 AM, Agha Mehdi aghaime...@gmail.com wrote:

 there are other tasks that run at the same time too but none that would
 interact with the same tables. One thing I did notice though that there is
 only one task that runs at 8:00 PM (which is this one) and there are 4
 different tasks that run at 8:00 AM (including this task). Could that be an
 issue?

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328385
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Compare records and update

2009-11-13 Thread Jason Congerton

Hi 

Just wondered if anyone had any ideas?

Jason






 Thank you again for your response, sorry for time its taking for me to 
 get my head around this!!
 
 Have a look at this
 
 http://tvpressings.jasoncongerton.co.uk/transteel-products/test.
 cfm?productid=2
 
 all looks good, however no NA in boxes with no measurements. however 
 this is only becauase the top two rows contains the top most amount of 
 measurements, all the way to T
 
 now look at this, i have placed the letters above the measurment to 
 show they are out of align with the top headers.
 
 http://tvpressings.jasoncongerton.co.uk/transteel-products/test.
 cfm?productid=29
 
 I need the ooutput to align with the top headers ABC.
 
 code below
 
 Jason
 
 
 !---get the measurements and parts no's---
 
 cfquery name=get_parts datasource=#application.dsn#

 SELECT p.lamNo,

   p.coreNo,

   p.pattern,

 p.productPartID, 

 p.partNo, 

 m.measOne,

 m.measTwo, 

 m.mTitle

 FROM productPart p INNER JOIN

 measurement m ON p.productPartID = m.mPartID
  
 WHERE p.partProdID = cfqueryparam value=#productID# 
 cfsqltype=cf_sql_integer 

 ORDER BY  p.order, p.lamNo, p.coreNo, p.pattern, m.mtitle
 /cfquery
 
 !---//get the letters for the top most row---
 
 cfquery name=get_alpha datasource=#application.dsn#
 SELECT tableLetter
 FROM tableSort
 WHERE tableLetter IN (SELECT mTitle
 FROM measurement WHERE mPartID IN (SELECT productPartID
 FROM productPart WHERE partProdID =  cfqueryparam value=#productID# 
 cfsqltype=cf_sql_integer))
 ORDER BY tableLetter ASC 
 /cfquery
 
 
 
 table
 tr
 td
 cfif get_parts.lamNo NEQ LAM NO:/cfifcfif get_parts.coreNo NEQ 
 CORE NO:/cfif
 cfif get_parts.pattern NEQ Pattern:/cfif/td
 tdstrongPART NO:/strong/td
 cfoutput query=get_alpha
 td style=width:70px; font-family:Verdana, Geneva, sans-serif; 
 font-size:10px; 
 text-align:center;strong#tableLetter#/strong/td
 /cfoutput
 /tr  
 cfoutput query=get_parts group=lamNo 
 td#lamNo#/td
 tdstrong#partNo#/strong/td
 cfset ctr = 0 /
 cfoutput group=mTitle
 td#mTitle#br /#decimalFormat(measOne)#cfif measTwo GT 0 X 
 #decimalFormat(measTwo)#/cfif/td
 cfset ctr = ctr+1 /
 /cfoutput
 cfif ctr lt get_alpha.recordcount
 cfloop from=#ctr# to=#get_alpha.recordcount# index=c
 tdnbsp;/td
 /cfloop
 /cfif
 
 /tr
 /cfoutput 

 
 /cfif

 

 
 /table
 
  
 
 
 

 /tr  
   
 

 
 
 

 

 cfoutput query=get_parts group=lamNo 

 

 td style=width:80px; font-family:Verdana, Geneva, sans-serif; 
 font-size:10px;strong#lamNo#/strong/td

 td style=width:80px; font-family:Verdana, Geneva, sans-serif; 
 font-size:10px;strong#partNo#/strong/td

 cfset ctr = 0 /

 cfoutput group=mTitle

 td style=width:70px; font-family:Verdana, Geneva, sans-serif; 
 font-size:10px; text-align:center;#mTitle#br 
 /#decimalFormat(measOne)#cfif measTwo GT 0 X 
 #decimalFormat(measTwo)#/cfif/td

 cfset ctr = ctr+1 /

 /cfoutput

 cfif ctr lt get_alpha.recordcount

 cfloop from=#ctr# to=#get_alpha.recordcount# index=c

 tdnbsp;/td

 /cfloop

 /cfif

 /tr

 /cfoutput 

 

 /cfif

 

 
 /table


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328386
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JPG in Database - Retrieve for web page

2009-11-13 Thread James Holmes

Why are you trying to oputput div and form tags as part of an image?

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

2009/11/14 Kim Hoopingarner k.hoopingar...@e-details.com:

 CORRECT CODE!

  cfform name=x action=home.cfm 

  cfinvoke component=cfc.msr_multisigs method=getMSigImage                
 returnvariable=qMsigImage

  /cfinvoke


  div
        cfheader name=Content-Disposition value=inline
        cfcontent type=image/jpg variable=qMsigImage.binaryObject 
  /div

  div
        cfinput type=text value=HELLO name=x

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328389
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Post a form synchronously even though it is in a cfdiv

2009-11-13 Thread Dave Watts

 That is what I mean.  It submits inside the cfdiv, show the target page
 pulls up completely inside the cfdiv.  I want it to pull up on a new page.
 I changed the cfform to just use form and that fixed it for me, but I didn't
 need any cfform goodness this time.  I did breifly test your _top suggestion
 and that didn't make a difference when I was still using CFFORM.

It turns out that CFFORM doesn't appear to support the TARGET
attribute any more, according to the documentation. It used to circa
CF 6.1. However, you can use JavaScript to set the TARGET attribute
for your form. Your code would look something like this:

cfform

/cfform

script
document.forms[0].target = _top;
/script

Note that I haven't actually tested this code. Good luck!

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more informati

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328388
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Better manage bulk update process

2009-11-13 Thread Agha Mehdi

nope, the other tasks don't do anything to those tables.

so here's what I did.

wrapped cftransaction around the process.
created two staging tables that hold the process updates.
once the process finishes, i call a stored proc, which deletes old data from
prod tables, copy data from staging to prod tables and truncates staging
tables.

This is working without crashing and the web site doesn't lose any data
while the import job is running.

thanks everyone for pitching in. that's why i love this list and rejoined
after 3 years of absence. :)

On Fri, Nov 13, 2009 at 4:18 PM, Maureen mamamaur...@gmail.com wrote:


 Do any of the other tasks use the tables you are deleting or updating?

 On Fri, Nov 13, 2009 at 8:58 AM, Agha Mehdi aghaime...@gmail.com wrote:
 
  there are other tasks that run at the same time too but none that would
  interact with the same tables. One thing I did notice though that there
 is
  only one task that runs at 8:00 PM (which is this one) and there are 4
  different tasks that run at 8:00 AM (including this task). Could that be
 an
  issue?

 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328387
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in IE!

2009-11-13 Thread Azadi Saryev

jquery 'best practice' in regard to class selectors is to prefix them
with tag name whenever possible.
i am not sure if using parent-child selectors speeds up the code
execution even more, but i imagine it could.

Azadi Saryev



On 14/11/2009 04:51, Andy Matthews wrote:
 Josh...

 That's not true. Everything I've read says that the less specific you are,
 the faster your code will run.

 In your example, it has to search through a whole bunch of stuff rather than
 just going and finding items with a class of oldUsers.



 andy 

 -Original Message-
 From: Josh Nathanson [mailto:p...@oakcitygraphics.com] 
 Sent: Friday, November 13, 2009 12:20 PM
 To: cf-talk
 Subject: RE: 'Tis a sad, sad day...jQuery kills FireFox but works great in
 IE!


 You might get a tad bit more speed if you do this in your selectors:

 $(table.stripetbodytr.oldUsers)

 Instead of this:

 $(.oldUsers)

 This is because jQuery will execute the DOM search more specifically instead
 of having to traverse the whole DOM for that class.

 -- Josh



 -Original Message-
 From: Eric Cobb [mailto:cft...@ecartech.com]
 Sent: Friday, November 13, 2009 6:26 AM
 To: cf-talk
 Subject: Re: 'Tis a sad, sad day...jQuery kills FireFox but works great in
 IE!


 Yeah, after tinkering with it a little more I realized what I was trying 
 to do would be better with classes instead of IDs.  I really didn't want 
 to have to deal with a unique ID for all 500 rows.

 Anyway, here's my jQuery now:

 $(#userFilter).click(function(){   
   // If checked
   if ($(#userFilter).is(:checked)){
   //hide all old users
   $(.oldUsers).css(display,none);
   }
   else { 
//show all old users
   $(.oldUsers).css(display,table-row);
   }
 });

 It works correctly in both FF and IE, although in FF there's still a 
 good bit of lag time from when you click the checkbox until it actually 
 hides the rows.  I guess it's just the way FF is dealing with so many 
 table rows.

   

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328390
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


How to save a web page as an image

2009-11-13 Thread Dave Hatz

I am not sure if this is possible or not, but I am trying to figure out how to 
save a web page as an image.  We are using CF8 Enterprise.  I am able to save 
the web page using CFSAVECONTENT, but, can't seem to find how to save it as an 
image. 

Is it even possible to do with CF8?

Thanks,
Dave 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328391
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: How to save a web page as an image

2009-11-13 Thread Leigh

 to figure out how to save a web page as an image

http://www.coldfusionjedi.com/index.cfm/2007/6/13/ColdFusion-8-URL-Thumbnails


  

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328392
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


The Ten Most Critical Web Application Security Risks

2009-11-13 Thread Andrew Grosset

Essential reading...

http://www.owasp.org/images/0/0f/OWASP_T10_-_2010_rc1.pdf

(released today 13th November) 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328393
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4