Re: Coldbox plugins vs interceptors for user management

2009-10-03 Thread Vineet Mangal

Thanks Glyn. I think interceptors make more sense. I do want this user 
management feature to be reusable across different Coldbox applications. 

I feel that there aren't any CF frameworks or apps out there(that I know of 
anyway) with a solid (role and feature based per website) user management built 
in so figured I will try to put one together.

Cheers,
Vineet


 Interceptors make requests in specific execution points in which it 
 can process, pre-process, post-process and redirect requests, perfect 
 for security! Think of interceptors as listeners to any request in 
 your application.
 
 http://ortus.svnrepository.com/coldbox/trac.
 cgi/wiki/cbInterceptorsGuide
 
 A plug-in could make use of an interceptor or it could be a whole 
 security plug-in that does many things.
 
 I think it really depends on what your tiring to achieve, does it need 
 to be reusable etc. 


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


Re: reading text from images

2009-10-03 Thread Richard White

thanks for your advice, we will take a look into that

richard



Just saw this on the wire yesterday:

http://www.labnol.org/internet/perform-ocr-with-google-docs/10059/

Don't know any more about it than that article, but maybe it's helpful. 

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


Re: CF 8 creating J2EE Archives

2009-10-03 Thread Larry Lyons

 I've been trying unsuccessfully to create war file archives of our 
 coldfusion 8 server.  I end up with an empty directory.  All we would 
 like to do is create a war file that can be deployed to multiple J2EE 
 application servers preserving the administrator settings - there is 
 no application to associate with the war because the content files 
 live elsewhere.  Any thoughts? 

What version of CF are you using? If its enterprise and you're using the war or 
ear file deployment, then its already done for you. Then all you have to do is 
to add your cf, html and other files to the war file. If your version is CF 
Standard you may be out of luck.

larry


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


Re: Write HTML content after reading a CSV file

2009-10-03 Thread Larry Lyons

Oh, hell.

Thank you John, will try this out. ;-)

Another option is to use the file attribute of cfloop as in 

cfloop 
index = i
file = absolute path and filename

Do your html stuff here

/cfloop

hth,
larry


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


cfdocument and td widths

2009-10-03 Thread Richard White

Hi,

we are trying to create a document to print on A4 and trying to control the 
sizes of the table cells.

we have tried controlling the table with in cm's but has not worked. we have 
also set the size of the flashpaper in cms and then tried to control the size 
of the table in percentages but the size still doesnt change.

here is the example we are using, can anyone spot what we are doing wrong. 
thanks

cfdocument marginbottom=0 marginleft=0 margintop=0 marginright=0 
format=flashpaper unit=cm pageheight=27.94 pagewidth=21.59

table width=100% height=100% border=1

  tr
td colspan=5 width=100%nbsp;/td
  /tr
  
  tr
td rowspan=44 width=4.63177%nbsp;/td
td colspan=3 width=90.73646%nbsp;/td
td rowspan=44 width=4.63177%nbsp;/td
  /tr

  tr
td colspan=3 width=90.73646%nbsp;/td
  /tr
  
  cfloop index=i from=1 to=40
  tr
td width=41.22278%nbsp;/td
td width=3.70541%nbsp;/td
td width=44.46503%nbsp;/td
  /tr
  /cfloop
  
  tr
td colspan=3 width=90.73646%nbsp;/td
  /tr
  
  tr
td colspan=3 width=90.73646%nbsp;/td
  /tr
  
  tr
td colspan=3 width=90.73646nbsp;/td
  /tr
/table

 /cfdocument


richard 

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


Re: Coldbox plugins vs interceptors for user management

2009-10-03 Thread s. isaac dealey

 I feel that there aren't any CF frameworks or apps out there(that I
 know of anyway) with a solid (role and feature based per website)
 user management built in so figured I will try to put one together.

You might take a look at the onTap framework's Members onTap 
plugin. 

I wrote an article about the way that security system works a while back
that's been fairly popular
http://ontap.riaforge.org/blog/index.cfm/2008/5/11/Keep-It-Simple


-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 817.385.0301

http://onTap.riaforge.org/blog



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


Strange License Error w/ Developer Edition

2009-10-03 Thread s. isaac dealey

Hey guys, 

I just got this wierd licensing error from Adobe's developer edition of
CF8. Not a big deal since I can just restart the service, but I've been
having to use an external IP address to do my testing because of an odd
bug in the Apache webserver. And today I apparently exceeded the number
of external IP addresses available on the developer edition, even though
I only used one IP address. ;) 

Here's the error:

A License exception has occurred. 
You tried to access the Developer Edition from a disallowed IP (192.168.1.100). 
The Developer Edition can only be accessed from 127.0.0.1 and two
additional IP addresses. 
The additional IP addresses are: 192.168.1.101, 192.168.1.101 

What I'm highlighting here is that the 2 additional IP addresses given at
the bottom of that error message are the same IP address. Same browser
even. Thought it was kind of odd, figured I'd post it. :) 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 817.385.0301

http://onTap.riaforge.org/blog



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


Whats wrong with this SQL?

2009-10-03 Thread Glyn Jackson

Any reason why below does now work? no errors it just does not do what it 
states.
it should look at all valueId's in the database and if its not in the list 
delete it, simple, right, so why does it not work?

DELETE FROM options 
WHERE valueId NOT IN  
cfqueryparam value=#arguments.list# cfsqltype=cf_sql_varchar / 

PS I dont have the option of using a stored procedure so it must be done at the 
layer above 

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


Re: Whats wrong with this SQL?

2009-10-03 Thread Glyn Jackson

PS the list looks like...

1,2,3,4,5,6 etc 

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


Re: Whats wrong with this SQL?

2009-10-03 Thread Leigh

 PS the list looks like...
 
 1,2,3,4,5,6 etc 

(I do not know if this went through)

It looks like you forgot the parenthesis and list attribute of cfqueryparam:

WHERE valueId NOT IN 
(
cfqueryparam value=#arguments.list#
cfsqltype=cf_sql_varchar
list=true
/
)




  


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


Re: Whats wrong with this SQL?

2009-10-03 Thread Glyn Jackson

simple when you know how. Thank you! 

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


Database-less queries

2009-10-03 Thread Pete Ruckelshaus

There are times when I have a simple problem that calls for a simple
solution.  I have data that is perhaps a half dozen columns and three dozen
rows; I was thinking how it would be cool to load that data somehow as a
query object in a memory-resident (most likely application scope) variable,
with the data stored as wddx in a text file that would get loaded when the
application loads.  New data could be added by loading the object into a
cfgrid.
Before I venture forth on this bit of experimental (for me) coding, I was
wondering if anyone else has done this, and what were the results?  This is
really more of a proof of concept, and would be used with a relatively low
traffic web site.

Thanks,

Pete


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


RE: Database-less queries

2009-10-03 Thread lists

A super simple method would be to store the plain text as ColdFusion's JSON
format. You could change it up, add (or remove) rows, and more. Then
whenever you need to, just have CF convert it a native query object:

Peep this sample code:

cfset REQUEST.q = QueryNew('firstname, lastname, email')
cfset QueryAddRow(REQUEST.q,3)
cfset QuerySetCell(REQUEST.q, 'firstname', 'neil', 1)
cfset QuerySetCell(REQUEST.q, 'lastname', 'finn', 1)
cfset QuerySetCell(REQUEST.q, 'email', 'nf...@crowdedhouse.com', 1)
cfset QuerySetCell(REQUEST.q, 'firstname', 'thom', 2)
cfset QuerySetCell(REQUEST.q, 'lastname', 'yorke', 2)
cfset QuerySetCell(REQUEST.q, 'email', 't...@radiohead.com', 2)
cfset QuerySetCell(REQUEST.q, 'firstname', 'ben', 3)
cfset QuerySetCell(REQUEST.q, 'lastname', 'folds', 3)
cfset QuerySetCell(REQUEST.q, 'email', 'b...@benfoldsfive.com', 3)

cfset REQUEST.toJSON = SerializeJSON(REQUEST.q)
cfset REQUEST.fromJSON = DeserializeJSON(REQUEST.toJSON, false)

cfdump var=#REQUEST#
cfabort

The key is the false flag in the Deserialize. It prevents ColdFusion from
converting the incoming string into strict data types (like arrays and
structs). Remove it, or change it to true, and you'll see what I mean. So
convert your query into JSON once then save that off and format it nice and
pretty so that it's human readable, and save it as a text file or something.


andy

-Original Message-
From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] 
Sent: Saturday, October 03, 2009 7:58 PM
To: cf-talk
Subject: Database-less queries


There are times when I have a simple problem that calls for a simple
solution.  I have data that is perhaps a half dozen columns and three dozen
rows; I was thinking how it would be cool to load that data somehow as a
query object in a memory-resident (most likely application scope) variable,
with the data stored as wddx in a text file that would get loaded when the
application loads.  New data could be added by loading the object into a
cfgrid.
Before I venture forth on this bit of experimental (for me) coding, I was
wondering if anyone else has done this, and what were the results?  This is
really more of a proof of concept, and would be used with a relatively low
traffic web site.

Thanks,

Pete




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


Re: Database-less queries

2009-10-03 Thread s. isaac dealey

Hey Pete, 

Although CacheBox is using structures for performance on fetch
operations, it's using a query to store the metadata for the content in
cache to improve performance of other operations like reporting
statistics and bulk-expiring or bulk-reaping the cache. (Either of which
are comparatively quite slow when using a structure.) It's working out
pretty well I think. 

http://cachebox.riaforge.org 

It sounds like your particular project will be a bit simpler than that,
and I see no particular reason why it shouldn't work. There are a few
fidly details regarding working with manually built queries, but for
what it's worth, they crop up for me more often during a query-of-query,
which you may or may not be doing. If you run into any issues with it,
feel free to ping me off-list and I'll answer any questions I can. :) 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 817.385.0301

http://onTap.riaforge.org/blog



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