Re: jquery grid problem

2009-08-13 Thread Dominic Watson

Yes absolutely right - dang useful that. The other thing to be weary of is
cf debugging output - so:

cfsetting showdebugoutput=false /cfcontent reset=true
type=application/json /(output code)

I think this is especially helpful when there are other devs working on the
same project.

Dominic


 Ah, see, my application.cfm outputs some html comments that sometimes
 screws up calls like this so I've become used to doing a cfcontent
 reset to blank out anything in the output buffer.

 Thanks!

 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:325430
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: jquery grid problem

2009-08-13 Thread Rick Root

On Thu, Aug 13, 2009 at 4:31 AM, Dominic
Watsonwatson.domi...@googlemail.com wrote:

 Yes absolutely right - dang useful that. The other thing to be weary of is
 cf debugging output - so:

 cfsetting showdebugoutput=false /cfcontent reset=true
 type=application/json /(output code)

 I think this is especially helpful when there are other devs working on the
 same project.

Not a problem if you're using Firebug and Coldfire =)

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:325431
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: jquery grid problem

2009-08-13 Thread Dominic Watson

And working alone indeed

2009/8/13 Rick Root rick.r...@webworksllc.com

 Not a problem if you're using Firebug and Coldfire =)



~|
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:325432
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


system security question

2009-08-13 Thread Richard White

Hi,

We would very much appreciate some expert interegation of the following 
scenario:

An ms access database system is setup within an internal network. It has no 
internet access or entry.

It stores sensitive data. However non-sensitive data is passed to it via an 
email that is collected by a computer within the network.

The computer then runs visual basic code to check the data within the email and 
store it into the database.

Do you see any potential security issues with this i.e. sql injection via the 
email, or some code that will run queries and export data out of the network 
etc...

does this seem like a viable option, or would setting up a VPN between the 
internal network and an external internet server that collects the 
non-sensitive data seem like a better option? if so what security problems do 
you see with the vpn option?

thanks your interegation is greatly appreciated 

~|
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:325433
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: system security question

2009-08-13 Thread Claude Schneegans

Do you see any potential security issues with this i.e. sql injection 
via the email

As far as SQL injection is concerned, the risk is pretty low with an
Access database, since it cannot process
multi-statement SQL command. Unless there are tricks I don't know, all
SQL injections are based
on multi-statement commands.


~|
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:325434
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Regex Help - Can this be simplified?

2009-08-13 Thread Che Vilnonis

Is there a way using CF's Regex functions to simplfy the lines of code below
into one line? Some kind of built in regex list comparison maybe?

cfset finalDescription = replace(trim(form.description), br, br /,
ALL)
cfset finalDescription = replace(finalDescription, p/p, br /br
/, ALL)
cfset finalDescription = replace(finalDescription, p, br /br /,
ALL)

Thanks, CV



~|
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:325435
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Regex Help - Can this be simplified?

2009-08-13 Thread Dave Phillips

I'm not an expert with Regex, but you could do this:

cfset finalDescription =
replace(replace(replace(trim(form.description),br,br/,all),p/p
,br /br /,all),p,br /br /,all) 

Again, this is not regex, but it is a much more simplified (and faster I
believe) way of doing the same thing with 1 line of code.

Dave Phillips
-Original Message-
From: Che Vilnonis [mailto:ch...@asitv.com] 
Sent: Thursday, August 13, 2009 1:14 PM
To: cf-talk
Subject: Regex Help - Can this be simplified?


Is there a way using CF's Regex functions to simplfy the lines of code below
into one line? Some kind of built in regex list comparison maybe?

cfset finalDescription = replace(trim(form.description), br, br /,
ALL)
cfset finalDescription = replace(finalDescription, p/p, br /br
/, ALL)
cfset finalDescription = replace(finalDescription, p, br /br /,
ALL)

Thanks, CV



~|
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:325436
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Regex Help - Can this be simplified?

2009-08-13 Thread Charlie Griefer

less lines != simplified :)

A year from now, which version are you going to want to come back to when it
needs work?  The 3 line version or the 1?

I'd prefer the 3.  Easier to read.

Not really sure a regex solution is warranted here.  You could probably get
one whipped up to find all instances of the tag combinations that you
want... but not all instances are replaced with the same string.  Only the
first one (the br) is replaced with a single br /.  The others are
replaced with two br /s.

Also curious about the need to replace p/p with br /br /.  I'm not a
CSS guru, but I believe the two are semantically different.  One (the p /)
is meant to contain text.  The other (br /) just meant to force a space.

p/p will give you more flexibility via CSS to style individual
paragraphs.  You might not have that need now, which is fine.  But by
replacing all p / elements with br /br / you're effectively giving up
that flexibility forever.

On Thu, Aug 13, 2009 at 11:19 AM, Dave Phillips 
experiencedcfdevelo...@gmail.com wrote:


 I'm not an expert with Regex, but you could do this:

 cfset finalDescription =

 replace(replace(replace(trim(form.description),br,br/,all),p/p
 ,br /br /,all),p,br /br /,all) 

 Again, this is not regex, but it is a much more simplified (and faster I
 believe) way of doing the same thing with 1 line of code.

 Dave Phillips
 -Original Message-
 From: Che Vilnonis [mailto:ch...@asitv.com]
 Sent: Thursday, August 13, 2009 1:14 PM
 To: cf-talk
 Subject: Regex Help - Can this be simplified?


 Is there a way using CF's Regex functions to simplfy the lines of code
 below
 into one line? Some kind of built in regex list comparison maybe?

 cfset finalDescription = replace(trim(form.description), br, br /,
 ALL)
 cfset finalDescription = replace(finalDescription, p/p, br /br
 /, ALL)
 cfset finalDescription = replace(finalDescription, p, br /br /,
 ALL)

 Thanks, CV



 

~|
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:325437
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Regex Help - Can this be simplified?

2009-08-13 Thread Che Vilnonis

Charlie, think of my problem like this. Say you had any 5 character combos
you wanted to remove, for whatever reason.
I'm just looking for a simpler (or so I thought) RegEx way to do this.

I could loop over a list, but I thought (perhaps naively) there might be a
Regex function that could accepta a list of chars and then replace any of
them when a match was found.

-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com] 
Sent: Thursday, August 13, 2009 2:29 PM
To: cf-talk
Subject: Re: Regex Help - Can this be simplified?


less lines != simplified :)

A year from now, which version are you going to want to come back to when it
needs work?  The 3 line version or the 1?

I'd prefer the 3.  Easier to read.

Not really sure a regex solution is warranted here.  You could probably get
one whipped up to find all instances of the tag combinations that you
want... but not all instances are replaced with the same string.  Only the
first one (the br) is replaced with a single br /.  The others are
replaced with two br /s.

Also curious about the need to replace p/p with br /br /.  I'm not a
CSS guru, but I believe the two are semantically different.  One (the p /)
is meant to contain text.  The other (br /) just meant to force a space.

p/p will give you more flexibility via CSS to style individual
paragraphs.  You might not have that need now, which is fine.  But by
replacing all p / elements with br /br / you're effectively giving up
that flexibility forever.



~|
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:325438
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


SQL Server Logins (should I be seeing so many in the log?)

2009-08-13 Thread Brook Davies

Hello,

On SQL Server 2005, the event view shows login from our two webservers (via
CF), but there are so many. In a couple of minutes there are over 500 of
these entries:

Login succeeded for user xyz. Connection: non-trusted. [CLIENT:
192.168.1.12]

I have maintain connections selected. So is this normal? Should I turn off
logging of successful logins?

Brook





~|
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:325439
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Regex Help - Can this be simplified?

2009-08-13 Thread Dave Phillips

This, of course, is completely a matter of opinion.  I prefer 1 line -
faster processing, and still easy to support.  Again, that's MY opinion, and
I'm sure we have about a hundred other opinions on this list.  There's no
doubt that there are many ways to accomplish something in ColdFusion.  But
an alternate method should not be shot down as not simplified especially
when the provider of the alternate method was just trying to help.

Dave Phillips

-Original Message-
From: Charlie Griefer [mailto:charlie.grie...@gmail.com] 
Sent: Thursday, August 13, 2009 1:29 PM
To: cf-talk
Subject: Re: Regex Help - Can this be simplified?


less lines != simplified :)

A year from now, which version are you going to want to come back to when it
needs work?  The 3 line version or the 1?

I'd prefer the 3.  Easier to read.


~|
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:325440
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Regex Help - Can this be simplified?

2009-08-13 Thread Tony Bentley

rereplace(string,(p)+(/p),br,all)


~|
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:325441
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Regex Help - Can this be simplified?

2009-08-13 Thread Charlie Griefer

Easy there, killer.  You said A.  I said B.  You didn't preface it with
in my opinion any more than I did.

I still maintain that (in my opinion), it's preferable to write more legible
code.  The single line may be just as easily readable for you, but you may
not always be the one maintaining your code.

On Thu, Aug 13, 2009 at 11:40 AM, Dave Phillips 
experiencedcfdevelo...@gmail.com wrote:


 This, of course, is completely a matter of opinion.  I prefer 1 line -
 faster processing, and still easy to support.  Again, that's MY opinion,
 and
 I'm sure we have about a hundred other opinions on this list.  There's no
 doubt that there are many ways to accomplish something in ColdFusion.  But
 an alternate method should not be shot down as not simplified especially
 when the provider of the alternate method was just trying to help.

 Dave Phillips

 -Original Message-
 From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
 Sent: Thursday, August 13, 2009 1:29 PM
 To: cf-talk
 Subject: Re: Regex Help - Can this be simplified?


 less lines != simplified :)

 A year from now, which version are you going to want to come back to when
 it
 needs work?  The 3 line version or the 1?

 I'd prefer the 3.  Easier to read.


 

~|
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:325442
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Regex Help - Can this be simplified?

2009-08-13 Thread Tony Bentley

Sorry I didn't read the post very well

rereplace(form.description,(p)+(/p)+(br),br/,all)

This does not replace a single p with br/br/ but I think it does the job. 

~|
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:325443
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Regex Help - Can this be simplified?

2009-08-13 Thread Che Vilnonis

There ya go. :) Just found out you can use the pipe | as well. 

-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com] 
Sent: Thursday, August 13, 2009 2:35 PM
To: cf-talk
Subject: Re: Regex Help - Can this be simplified?


rereplace(string,(p)+(/p),br,all)




~|
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:325444
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: SQL Server Logins (should I be seeing so many in the log?)

2009-08-13 Thread brad

I have maintain connections selected.


Did you check that setting on all data sources for both CF Servers.  Are
you storing client vars in via a datasource?

Run a trace on the SQL server to see what sort of operations are being
performed-- especially by new connections.

~Brad


~|
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:325445
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Regex Help - Can this be simplified?

2009-08-13 Thread Tony Bentley

You're better off using regex-replace(){rereplace()} over replace() for more 
than one condition. The pipe is a way to cheat the replace function but for 
future string searching or replacing functions, try regex and you can even test 
it online here:

http://www.cftopper.com/contentfiles/tools/regularExpTester.cfm



There ya go. :) Just found out you can use the pipe | as well. 

rereplace(string,(p)+(/p),br,all) 

~|
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:325446
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Regex Help - Can this be simplified?

2009-08-13 Thread Gabriel

You don't actually need a regex to put this into one easily read line:

replaceList(trim(finalDesription), 'br,p/p,p,/p', 'br /,br
/br /,br /br /,')

... Or some derivative there of.

Performance may differ slightly in favour of one way or another, but as much
as I love regexs and I use them frequently, they're rarely easy to descipher
at a glance.

Gabriel
 

-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com] 
Sent: Friday, 14 August 2009 5:59 AM
To: cf-talk
Subject: Re: Regex Help - Can this be simplified?


You're better off using regex-replace(){rereplace()} over replace() for more
than one condition. The pipe is a way to cheat the replace function but for
future string searching or replacing functions, try regex and you can even
test it online here:

http://www.cftopper.com/contentfiles/tools/regularExpTester.cfm



There ya go. :) Just found out you can use the pipe | as well. 

rereplace(string,(p)+(/p),br,all)



~|
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:325447
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFDOCUMENT SRC= and Dynamic HTML

2009-08-13 Thread Brook Davies

Is there any way to capture a rendered page that uses DHTML? I have a simple
test case where I use some JS to do a document.write('test') to the page and
then use CFDOCUMENT to grab the page via the src attribute. But none of the
dynamic content is ever rendered. Has any one had any success with this?

The only workaround I can think of, and its convoluted and I am not even
sure it would work:

1.  Create a Unique ID server side and write a database entry for the
content to fetch
2.  Call cfdocument or cfhttp to fetch the page, passing the uniqueID.
3.  On the page, include an ajax call back to send back to the server
the documents innerHTML (which should be the dynamic output) along with the
uniqueID
4.  The server (polls?) gets the new HTML from the database and uses it
with CFDOCUMENT to create the page.

This is a bit crazy right? There has got to be a better way. And oh yeah,
The output is generated through a lot of JS, so I can't easily reproduce it
on the server and avoid these steps. But, I wish there was some other way..


Brook



~|
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:325448
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: file comparison tools for outputting differences to client?

2009-08-13 Thread Maureen

If you are dealing in web content that changes and you want to compare
the current version to the previous version, look at some of the wiki
software, which has history and compare in the default install.

If  you are looking at markup comparisons like Word does, that's a
more complex chore, but COM and XML objects exist that you could
integrate into the site to handle it.
http://www.leadtools.com/SDK/Document/Document-Annotation.htm

If you are only looking for basic version control, the list is long.
http://en.wikipedia.org/wiki/Revision_control


On Tue, Aug 11, 2009 at 12:07 PM, Mike Henkehenke.m...@gmail.com wrote:

 Thanks for all the good feedback.

~|
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:325449
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFDOCUMENT SRC= and Dynamic HTML

2009-08-13 Thread brad

I think you're out of luck.  If your pages require a client that parses
and executes JavaScript in able to display all the content, cfhttp and
cfdocument won't do that.  I've never been able to find a way to easily
execute JavaScript and collect the rendered HTML on the server.

~Brad


 Original Message 
 Subject: CFDOCUMENT src= and Dynamic HTML
 From: Brook Davies cft...@logiforms.com
 Date: Thu, August 13, 2009 7:32 pm
 To: cf-talk cf-talk@houseoffusion.com
 
 
 Is there any way to capture a rendered page that uses DHTML? I have a
simple
 test case where I use some JS to do a document.write('test') to the
page and
 then use CFDOCUMENT to grab the page via the src attribute. But none of
the
 dynamic content is ever rendered. Has any one had any success with
this?
 
 The only workaround I can think of, and its convoluted and I am not
even
 sure it would work:
 
 1. Create a Unique ID server side and write a database entry for the
 content to fetch
 2. Call cfdocument or cfhttp to fetch the page, passing the uniqueID.
 3. On the page, include an ajax call back to send back to the server
 the documents innerHTML (which should be the dynamic output) along with
the
 uniqueID
 4. The server (polls?) gets the new HTML from the database and uses it
 with CFDOCUMENT to create the page.
 


~|
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:325450
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4