Re: Azure Storage

2015-04-01 Thread Bobby

Sorry about the double post. The list was acting up yesterday.

On 3/30/15, 9:49 AM, Bobby bo...@acoderslife.com wrote:


Anyone managed to get Azure blob storage working in CF? There are very few
examples out there and virtually none in CF.

I©öm mostly just having issues with the authorization header
formatting/encoding and wondered if anyone had any working examples.

Unfortunately, this is a CF8 project.





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


Re: Error calling a .net object

2015-03-25 Thread Bobby

Its not necessarily saying the method doesn't exist, it is saying it
doesn't exist with the arguments and/or argument TYPEs you are giving it.
Look at the types in the dump of the method you mentioned and try to
javacast() your values to match those types when passing them in.

example: opendesign(javacast('string',thisfile), javacast('int',0))

...assuming that it is actually expecting a simple string and int.

If that doesn't work, try posting the method dump or (if you have it) a
working.NET example of how it is used.



On 3/25/15, 8:28 AM, Charles Sheehan-Miles char...@sheehanmiles.net
wrote:


I have a problem I wanted to run by the list.  I’m recently back in the
coldfusion world after a several year hiatus.  I’m in the process of
trying to access the methods of a .net component, at this point as a
proof of concept. Once I can do something with it I’ll actually start
building the app.

I set up the object like this:

cfset dll = ExpandPath('./com/Interop.CADXLib.dll')
cfobject
class=CADXLib.CadX
type=.NET
name=cadx
assembly=#dll#”

That’s in my application.cfc, in the onRequestStart() method. Then in
my index.cfm I call:

cfdump var=#cadx#”

The object dumps just fine. I can see all the internal methods, including
the one I need to get things going, the OpenDesign() method, which (in
theory) opens a local file and reads the contents.

So next I set the actual filename I want to access:

cfset thisfile=1571269P01R01_ARTIOS.ARD
cfset thispath=getDirectoryfromPath(getCurrentTemplatePath())
cfset thisfile=thispath  thisfile

This works, and outputting “thistfile” gives me the correct path
location.  So now I call the actual method:

cfset result=cadx.OpenDesign(thisfile,0)

That’s where I get stuck. I get this error:

Either there are no methods with the specified method name and argument
types or the OpenDesign method is overloaded with argument types that
ColdFusion cannot decipher reliably. ColdFusion found 0 methods that
match the provided arguments. If this is a Java object and you verified
that the method exists, use the javacast function to reduce ambiguity.

I javacast the arguments and get the same error. Method not found. But
based on the dump, the method is clearly there.

Has anyone encountered this or something similar?









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


Re: Error calling a .net object

2015-03-25 Thread Bobby

I gave the benefit of the doubt but that is also my primary suspicion
(file object vs path).

On 3/25/15, 9:17 AM, Byron Mann byronos...@gmail.com wrote:


I know I've done things like pass a file path (string) instead of file
object, so make sure the type the method wants is string or otherwise.

So might look if the function is this:

OpenDesign(File, Int)

as opposed to:

OpenDesign(String, Int)

~Byron


On Wed, Mar 25, 2015 at 9:08 AM, Bobby bo...@acoderslife.com wrote:


 example: opendesign(javacast('string',thisfile), javacast('int',0))






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


Re: Error calling a .net object

2015-03-25 Thread Bobby

Javacast the 0 as short and the path as a string and see how that goes.

example: opendesign(javacast('string',thisfile), javacast('short',0))



On 3/25/15, 9:45 AM, Charles Sheehan-Miles char...@sheehanmiles.net
wrote:


That was my first thought too.  But the documentation is pretty clear
that it?s looking for the file path, and the dump shows this:

OpenDesign(java.lang.String, short)




 On Mar 25, 2015, at 9:23 AM, Bobby bo...@acoderslife.com wrote:
 
 
 I gave the benefit of the doubt but that is also my primary suspicion
 (file object vs path).
 
 On 3/25/15, 9:17 AM, Byron Mann byronos...@gmail.com wrote:
 
 
 I know I've done things like pass a file path (string) instead of file
 object, so make sure the type the method wants is string or otherwise.
 
 So might look if the function is this:
 
 OpenDesign(File, Int)
 
 as opposed to:
 
 OpenDesign(String, Int)
 
 ~Byron
 
 
 On Wed, Mar 25, 2015 at 9:08 AM, Bobby bo...@acoderslife.com wrote:
 
 
 example: opendesign(javacast('string',thisfile), javacast('int',0))
 
 
 
 
 
 
 



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


Re: Can you use a CFTHREAD inside an Ajax routine?

2015-03-12 Thread Bobby

When you say it doesn¹t generate any errors, do you mean that you¹ve
looked through the exception logs? Unless you are trapping it with
try/catch or a custom error handler, that¹s the only place you would
discover that an error happened in a cfthread that you are spawning and
forgetting.

On 3/5/15, 3:47 PM, John Pullam jpul...@mcleansystems.com wrote:


It seems to me that the CFTHREAD I attempt to start from inside an Ajax
routine (triggered by a CFWINDOW) never runs and doesn't generate any
error message. Can anyone advise if this is a legitimate thing to do?



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


Re: CF11 Licensing - 2 servers behind load balancer

2014-10-09 Thread Bobby

That¹s not what Adobe is telling us. They want a license per virtual
machine, not per host.


On 10/2/14, 3:22 PM, Russ Michaels r...@michaels.me.uk wrote:


as they are virtual, if you have enterprise license then you are covered
as
long as you are within the CPU/core requirements.

On Thu, Oct 2, 2014 at 8:15 PM, Dan LeGate d...@legeek.com wrote:


 Okay, if I have a single site, being run on two or more virtual (vmware)
 servers behind a load balancer, does each server need a license?  Or
 does one license cover the site?

 Thanks!

 



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


Re: code suddenly stops working for no apparent reason

2014-09-02 Thread Bobby

It isn¹t being explicitly passed, it is being explicitly referenced. The
template assumes it was passed in as part of the attributes
collection/scope (as per argumentcollection=#attributes#²). The error is
telling you that it is not in the attributes scope. The error is not wrong
so, like Phillip suggested, step back until you find where you think it is
being set and figure out why it isn¹t. Nothing you¹ve said or pasted will
let anywhere here give you much more info than that.


On 8/30/14, 3:44 PM, Phillip Vector vec...@mostdeadlygame.com wrote:


Apparently, it isn't. Go back further.


On Sat, Aug 30, 2014 at 12:08 PM, Matthew Smith chedders...@gmail.com
wrote:


 But it is being explicitly passed. That's where I'm lost.

  On Aug 30, 2014, at 12:44, Phillip Vector vec...@mostdeadlygame.com
 wrote:
 
 
  The reason is apparent.
 
  Element USERID is undefined in ATTRIBUTES.
 
  Trace the attribute back and figure out where it was set and see why
it
  isn't being set.
 
 
  On Sat, Aug 30, 2014 at 11:31 AM, Matthew Smith
chedders...@gmail.com
  wrote:
 
 
   cfcase value=createUser
   cfinvoke
  component=cfcs.qry-todatabase
  method=qry_peopleCreateNewUser
 argumentcollection=#attributes#
  returnvariable=qry_peopleCreateNewUser
   cfif qry_peopleCreateNewUser.returnKey eq -1
 cfset XFA.badLogin = #fusebox.thisCircuit#.go
 cfmodule fuseaction=#XFA.badLogin#
  error=badPassword
  emailaddress = #attributes.emailAddress#
  cfid=#cfid# cftoken=#session.cftoken#
  template=#fusebox.rootpath##modself#
 cfelse
 cfmodule
  fuseaction=#fusebox.thisCircuit#.startSession
  userid=#qry_peopleCreateNewUser.returnKey#
  template=#fusebox.rootpath##modself#
  cfid=#cfid# cftoken=#session.cftoken#
   /cfif
   /cfcase
   cfcase value=startSession
   cflock
  scope=SESSION
  timeout=10
  type=EXCLUSIVE
 cfset session.loggedIn = 1
 cfset variables.tmp = structdelete(session, billinginfo)
   /cflock
   cfset client.userID = attributes.userID
   cfset XFA.defaultReturnFuseaction = #fusebox.homeCircuit#.home
   cfif
 listFirst(evaluate(client.#fusebox.thiscircuit#returnFuseaction),
  .) eq SECUREOrderApp
 cfobject component=cfcs.qry-todatabase name=qry /
 cfset qry_orderInfoBufferCreate = qry.qry_orderInfoBufferEdit(
  cfuserid=#session.CFID#0#session.CFTOKEN#) /
 cfset qry_cartAssignPersonKey = qry.qry_cartAssignPersonKey(
  cfuserid=#session.CFID#0#session.CFTOKEN#, app_user_id =
  #CLIENT.USERID#) /
   /cfif
   cfinclude template=url_thisCircuit_returnFuseAction.cfm
   /cfcase
 
 
  getting this error even though explicitly passed...
 
  Element USERID is undefined in ATTRIBUTES.  The error occurred in
 
 
 
*D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/authenticati
on/fbx_Switch.cfm:
  line 91*
  *Called from*
 
 
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30
_CF50.cfm:
  line 273
  *Called from*
 
 
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30
_CF50.cfm:
  line 33
  *Called from*
 
 
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30
_CF50.cfm:
  line 1
  *Called from*
  
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm:
  line 9
  *Called from*
 
 
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.c
fc:
  line 62
 
  89 : cfset variables.tmp = structdelete(session, billinginfo)
  90 :   /cflock*91 :   cfset client.userID = attributes.userID*
  92 :   cfset XFA.defaultReturnFuseaction =
 #fusebox.homeCircuit#.home
  93 :   cfif
  listFirst(evaluate(client.#fusebox.thiscircuit#returnFuseaction),
  .) eq SECUREOrderApp
 
 

 



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


Re: ColdFusion BBCode routines

2014-08-12 Thread Bobby

Without specifics, I can just suggest trying to download the last version
of CF4em (which is still pretty old) and check out the bbmlparser there.

http://cf4em.com/downloads/

/cf4em/inc/parsebbml.cfm

Unless CF4em is what you inherited... In which case, I¹d suggest NOT doing
that that :-)


On 8/10/14, 8:31 PM, UXB denn...@uxbinternet.com wrote:


I was wondering if anyone has some battle tested BBCode routines to
convert
BBcode to html and one to covert the HTML created back to BBcode?  I have
inherited a forum that has rolled its own BBcode  Html routines and the
kiddies are finding ways to imbed scripts into the various BBCode
routines.
I would prefer not to have to re-create the wheel. I have tried Google but
can't seem to find much of anything coldfusion related on the subject.

Any assistance is appreciated.

Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W: http://www.ctbusinesslist.com






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


Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Bobby

Last time, my suggestion was to make sure the Enable High ASCII
characters and Unicode for data sources configured for non-Latin
characters² setting was enabled on your CF datasource but that was before
I realized it was an oracle datasource. If you are using a SQL Server
datasource this time, that setting should apply so make sure the setting
is enabled and try it again.


On 8/6/14, 9:17 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com
wrote:


Dear Friends,

Few days before I was trying to insert Arabic text into my ColdFusion
application with oracle database. And finally it worked for me as I
mentioned in previous mail chain below.

*Steps taken:*

*Oracle side:* I created the new database with NLS_CHARACTERSET as
AL32UTF8
and imported my old exported database having different characterset.

*CF side:*
I added the below two lines at the top of the cfm template.
meta http-equiv=Content-Type content=text/html; charset=utf-8
cfprocessingdirective pageencoding=utf-8

*Current Issue:*
But now am facing similar issue with respect to insert Arabic text into my
ColdFusion application with SQL Server 2008 database.

*Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in
some table columns. But when I try to fetch  display using CF even after
adding charset in meta tag  cfprocessingdirective as UTF-8 all Arabic
text
appeared as .

But if I use charset as Windows-1256 static text in the cfm page such as
column headers are coming as Arabic. But the fetched data from sql db
still
appear as ???

Please help.

Sathya.R




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


Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

2014-08-06 Thread Bobby

He said the arabic text was actually in the database but only ??? when
retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt
an nchar/nvarchar data type?

On 8/6/14, 12:21 PM, Paul Hastings p...@sustainablegis.com wrote:


On 8/6/2014 8:17 PM, Sathyanarayanan Ramanathan wrote:
 *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data
in
 some table columns. But when I try to fetch  display using CF even
after
 adding charset in meta tag  cfprocessingdirective as UTF-8 all Arabic
text
 appeared as .

?? means your text data is garbaged from the db. double check that it's
stored
in an N datatype (nchar, nvarchar, etc.). then double check if the data
is in
fact encoded as unicode.




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


Re: To insert Arabic text into my ColdFusion application with Oracle database.

2014-07-13 Thread Bobby

In the CF Administrator datasource settings, under the advanced section,
there is a checkbox for enabling high ascii/unicode chars. It is off by
default. Be sure that is checked.

Enable High ASCII characters and Unicode for data sources configured for
non-Latin characters²


On 7/13/14, 3:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com
wrote:


Dear All,

I am trying to insert Arabic text into my ColdFusion application with
Oracle database.
I tried below 3 scenarios but didn't work for me.

1. One of my ColdFusion application is already implemented to handle
Arabic
text using Oracle db.
I checked the NLS_characterset  is set to AR8MSWIN1256. There are few
Arabic text found in few tables.
But when I try to insert some sample rows with arabic text using toad it's
coming as ?.

2. I created a new database and tried to set NLS_characterset to
AR8MSWIN1256.
I tried to create a table  insert some sample rows with Arabic text using
toad it's still coming as ?.

3. I searched few sites  set NLS_characterset to AL32UTF8. But still the
results are same.

Your time  help will be really appreciated.

Sathya.R




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


Re: To insert Arabic text into my ColdFusion application with Oracle database.

2014-07-13 Thread Bobby

Your screenshots will not come through on the the list, you will have to
put them online somewhere and send the links instead. As for the ¡°Enable
High ascii¡± settings, my apologies, it doesn¡¯t appear to be available for
oracle datasources.


On 7/13/14, 9:47 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com
wrote:


Dear All,

I have created a test oracle database with AR8MSWIN1256 as characterset.
Also I created a test table with NVARCHAR2 (1000) as the datatype. Please
see the screenshots below.

[image: Inline image 1]
*Test table:*

[image: Inline image 2]

*Simple insert statement using Toad for Oracle:*


*[image: Inline image 3] *

I am not able to find Enable High ASCII characters and Unicode for data
sources configured for
non-Latin characters©÷ as suggested by Bobby. I am using CF9.

Regards,
Sathya



On Sun, Jul 13, 2014 at 3:52 PM, Bobby bo...@acoderslife.com wrote:


 In the CF Administrator datasource settings, under the advanced section,
 there is a checkbox for enabling high ascii/unicode chars. It is off by
 default. Be sure that is checked.

 Enable High ASCII characters and Unicode for data sources configured
for
 non-Latin characters©÷


 On 7/13/14, 3:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com
 wrote:

 
 Dear All,
 
 I am trying to insert Arabic text into my ColdFusion application with
 Oracle database.
 I tried below 3 scenarios but didn't work for me.
 
 1. One of my ColdFusion application is already implemented to handle
 Arabic
 text using Oracle db.
 I checked the NLS_characterset  is set to AR8MSWIN1256. There are few
 Arabic text found in few tables.
 But when I try to insert some sample rows with arabic text using toad
it's
 coming as ?.
 
 2. I created a new database and tried to set NLS_characterset to
 AR8MSWIN1256.
 I tried to create a table  insert some sample rows with Arabic text
using
 toad it's still coming as ?.
 
 3. I searched few sites  set NLS_characterset to AL32UTF8. But still
the
 results are same.
 
 Your time  help will be really appreciated.
 
 Sathya.R
 
 
 

 



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


Re: Dynamic queries within a loop

2014-04-18 Thread Bobby

Variables[getCourse  i  .CREDITDESIGNATIONTO²]


On 4/18/14, 9:42 AM, Torrent Girl moniqueb...@gmail.com wrote:


This actually worked for me: #evaluate(getCourse  i 
.CREDITDESIGNATIONTO)#

but of course everyone will tell me not to use evaluate.

How can I rewrite this properly?




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


Re: Dynamic queries within a loop

2014-04-18 Thread Bobby

errrŠ Variables[getCourse  I].CREDITDESIGNATIONTO

One of those bad boys.



On 4/18/14, 10:28 AM, Bobby bo...@acoderslife.com wrote:


Variables[getCourse  i  .CREDITDESIGNATIONTO©÷]


On 4/18/14, 9:42 AM, Torrent Girl moniqueb...@gmail.com wrote:


This actually worked for me: #evaluate(getCourse  i 
.CREDITDESIGNATIONTO)#

but of course everyone will tell me not to use evaluate.

How can I rewrite this properly?






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


Re: how to check if a remote file exists

2014-04-01 Thread Bobby

What is running on your w2k3 server? Is there a web server through which
the source/txt file is accessible? If so, sure, cfhttp can go out and grab
it over HTTP. Being a txt file, you wouldn't have to do anything fancy,
just point CFHTTP to the txt URL and then read the resulting file content
or even use the path and file attributes of CFHTTP to read and save the
file at the same time.

If there is no web server on the W2k3 server that holds the file, then
your options change.

If the two servers are on the same network, then you could run the CF
service as an account that has access to reach the file over UNC then just
use the UNC paths like you would normal paths in your cffile tag(s).

If they are not on the same network (and you can¹t set them up that way),
then there are many ways that you could have the w2k3 server ³send² the
file to the other machine when it generates it. I believe you said there
is a visual fox pro app on the w2k3 box. If you control that app and can
change it, it is capable of POSTing a file to a URL (url being a page you
setup on your CF server to accept a multipart/form-data post to upload the
file).

If you can¹t edit the VFP app, then you could install CURL on the W2k3 box
and still do the same thingŠ Have CURL post the file to a page you set up
on your CF server. Your CURL command would be a one liner that you could
either schedule with windows scheduler or you could set up a service on
the w2k3 box to monitor changes to the txt file and trigger the POST
automatically anytime it changes.




On 4/1/14, 5:37 AM, Russ Michaels r...@michaels.me.uk wrote:


if you have direct access tot he server with the file then you would use
CFFILE to copy it.
If the file is only accessible over the web, then you can use CFHTTP to
grab the file content and save to your local server. You will of course
not
get the raw file, only what is displayed in a browser.



On Tue, Apr 1, 2014 at 9:50 AM, safo 2000 safokas...@hotmail.com wrote:


 i am a bit confused, this is the first time I do this kind of request so
 bear with me.

 I am trying to do the following:

 i created a cf app on the source server (w2k3)

 cfquery name=Param datasource=lib_datasql 
 SELECT proxloc from MainServer
 /cfquery
 cfset
 
fname=#param.proxloc#\@conv_#dateformat(dateadd(d,-1,now()),'dd-mm-yyy
y')#.txt

 cfif FileExists(#fname#) 

 (the above will check for the file and find it)

 then i need to copy the file to the cf server and work with it,
 that's were you lost me.
 cfelse
 not found
 /cfif


  ok, so then how would I do the copy from w2k3 to cf9 server
 
  You would use CFHTTP to grab the content from the other server, and
  then save it as a file on your CF9 server.
 
  Personally I would do a separate CF app, scheduled in the CF
  administrator, that would periodically look for the file on the other
  server, and if it is there, grab it and download it.
 
  Then when your aggregation app runs, it just has to worry about
  content on your server.
 
  YMMV of course - I'm looking at it from the perspective of an
  application I worked on where the other server wasn't that reliable,
  and separating the grab files from the other server and process
  files helped troubleshooting tremendously.

 



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


Re: onApplicationStart and cfmail, when doess server start?

2014-04-01 Thread Bobby

The behavior you explained is expected. onApplicationStart() isn¹t
triggered until the first request to the application.

Check out onServerStart and Server.cfc

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WS7AC9408A-1AC6-4ab7-9C8
E-CF1DA8FCA16D.html




On 4/1/14, 11:31 AM, morchella morchella.delici...@gmail.com wrote:


so i am trying some thing out on localhost befor i move to dev
i want to know when my cf server was started or restarted.
so after my onApplicationStart
i put in a cfmail and fir up an instance of cf9 for my localhost.

i dont get the email unless i actually goto 127.x.x.x to view a page.
i thought i should get it imeditaly when the server starts?

how would or should i be doing this.
thanks a bunch.
will help to know when offshore reboots some thing with out informing us.

-m




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


Re: onApplicationStart and cfmail, when doess server start?

2014-04-01 Thread Bobby

The next thing that comes to mind is to parse the CF server.log file for
the instance you are targeting. There are log entries for stopping and
starting in there. ButŠ I¹m guessing you are wanting this to be used as an
alert not post-portem investigation.

There are plenty of infrastructure monitoring applications and 3rd party
services out there for monitoring your production servers (including the
services). My company uses PRTG for performance/service monitoring
(http://www.paessler.com/prtg) to cover all of our different servers. Im
mostly responsible for the health of our CF servers though and
FusionReactor works great for me. If you set it up correctly, it can
notify you of service availability changes.

None of the above actual means that a server was ³rebooted² though and a
CF service stopping/starting also doesn¹t mean that someone manually
triggered it.

Also, keep in mind that something running ON the server that is supposed
to send you this email is probably not going to work if its running on the
service you are trying to monitor.



On 4/1/14, 12:11 PM, morchella morchella.delici...@gmail.com wrote:


looks like onServerStart is turned off. i cant change that on our server.



On Tue, Apr 1, 2014 at 11:49 AM, morchella
morchella.delici...@gmail.comwrote:

 thanks guys! i was unfamilar with onServerStart. looking now!
 Much appreciated!



 On Tue, Apr 1, 2014 at 11:44 AM, Bobby bo...@acoderslife.com wrote:


 The behavior you explained is expected. onApplicationStart() isnšt
 triggered until the first request to the application.

 Check out onServerStart and Server.cfc


 
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WS7AC9408A-1AC6-4ab7-
9C8
 
E-CF1DA8FCA16D.htmlhttp://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/W
S7AC9408A-1AC6-4ab7-9C8E-CF1DA8FCA16D.html




 On 4/1/14, 11:31 AM, morchella morchella.delici...@gmail.com wrote:

 
 so i am trying some thing out on localhost befor i move to dev
 i want to know when my cf server was started or restarted.
 so after my onApplicationStart
 i put in a cfmail and fir up an instance of cf9 for my localhost.
 
 i dont get the email unless i actually goto 127.x.x.x to view a page.
 i thought i should get it imeditaly when the server starts?
 
 how would or should i be doing this.
 thanks a bunch.
 will help to know when offshore reboots some thing with out informing
us.
 
 -m
 
 
 

 



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


Re: The long tail of ColdFusion fail

2014-03-29 Thread Bobby

Yeah, DaveŠ Haven¹t you ³learnt² anything?


On 3/29/14, 8:38 AM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk
wrote:


Dave, I am curious.  Have you ever, even once, changed your mind because
of
what someone has told you?


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: 28 March 2014 18:07
To: cf-talk
Subject: Re: The long tail of ColdFusion fail


 if you think no-one uses Windows web servers then you are wrong, very
wrong.

Uh, yeah, I know that. That was my point.

 It would seem you also think that Windows is not locked down by
 default, that may have been true once upon a time, but is no longer
 the case and hasn't been for many years.Certainly since Windows Server
 2008, you must specifically choose which roles to install, everything
 is not installed by default, the firewall is also installed and
 enabled by default with only the basic required services allowed through
and networking is also disabled.

I guess you can interpret many years however you like, but the simple
fact
is, from the beginning and through the majority of the lifespan of Windows
servers, this was not the default. And I don't think Windows would have
been
nearly as popular for servers if it had started out that way. The fact
that
things worked by default gave Windows market share.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA
Schedule,
and provides the highest caliber vendor-authorized instruction at our
training centers, online, or onsite.





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


Re: The long tail of ColdFusion fail

2014-03-28 Thread Bobby

Re: The long tail of analogy hell.


On 3/28/14, 4:42 PM, Russ Michaels r...@michaels.me.uk wrote:


A locked door is useless if you leave the windows open.

Russ Michaels
www.michaels.me.uk
cfmldeveloper.com
cflive.net
cfsearch.com
On 28 Mar 2014 19:09, Dave Watts dwa...@figleaf.com wrote:


  I also once had a client who did this, they were Linux heads who
thought
  that hiding the sucky insecure windows/cf server behind a linux
server
  and doing a reverse proxy would make it secure.

 There is no such thing as make it secure, of course. But it is more
 secure. It solves one specific security problem - preventing
 executable code from being directly accessed from an untrusted
 network.

  But of course it didn't as everything still works the same way, the
SQL
  injections still got through, the insecure file upload forms still
 allowed
  files to be uploaded, which could then be executed as they had
cfexecute
  and cfregistry enabled.

 So what you're saying is that, despite the fact that the environment
 was (more) secure by default, developers accidentally wrote
 exploitable code?

 I have the feeling there's some lesson to be drawn from this. I wonder
 what it is?

 Dave Watts, CTO, Fig Leaf Software
 1-202-527-9569
 http://www.figleaf.com/
 http://training.figleaf.com/

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.

 



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


Re: Quick Survey

2014-03-26 Thread Bobby

*Throws keyboard in the air and gives Œprogramming¹ the finger while
walking away*


On 3/26/14, 9:20 AM, Phillip Vector vec...@mostdeadlygame.com wrote:


To show how things can be twisted...

poll does not count / quantify people who're choosing not to learn a new
language at this time.

So it doesn't count people who are giving up programing altogether. :)


On Wed, Mar 26, 2014 at 5:55 AM, Robert Harrison
rob...@austin-williams.com
 wrote:


  @Robert Did you looked into Railo? If clients don't want to use Adobe
 Coldfusion due to the recent bad news, I've been recently able to sell
 Railo to them instead.

 It's not recent bad news that caused this.  It's been a long slow
decline
 that Adobe has failed to address with any marketing or rebranding
 initiatives.  The perception of the technology, the limitations and
costs
 of available hosts, the limited number of developers, and the facts
that no
 IT departments (that I know of) teach ColdFusion as part of their
 curriculum is the issue. Adobe could has long since addressed all of
these
 issues.


 Robert Harrison
 Director of Interactive Services

 Austin  Williams
 Advertising I Branding I Digital I Direct
 125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788
 T 631.231.6600 X 119   F 631.434.7022
 http://www.austin-williams.com

 Blog:  http://www.austin-williams.com/blog
 Twitter:  http://www.twitter.com/austin_wi

 



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


Re: cflocation mystery

2014-02-02 Thread Bobby

Exception.log

On 2/2/14, 12:18 PM, Rob Voyle robvo...@voyle.com wrote:


Hi Timothy

Which log would the error be in. I can't find the error in any of the
logs.
The site is public and only displays a generic error template rather than
the 
specific error. 

Rob

On 2 Feb 2014 at 11:58, Timothy Heald wrote:

 
 What's the error message?
 On Feb 2, 2014 11:42 AM, Rob Voyle robvo...@voyle.com wrote:





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


Re: Cumulative Hotfix 3 4

2013-10-04 Thread Bobby

Right, cumalative would mean that 4 includes 3 (and previous). Russ is
right, there are plenty of security patches that are NOT in the cumulative
hotfix. I do believe the unofficial updater has many of them included
though so you might consider that if you are looking for more than what is
in the cumulative hotfix.


On 10/4/13 4:01 AM, Russ Michaels r...@michaels.me.uk wrote:


yes each CHF includes all fixes from previous ones.
You should however be sure to check carefully on their site what is NOT
included, often security fixes are not included.


On Fri, Oct 4, 2013 at 8:06 AM, Nick Gleason n.glea...@citysoft.com
wrote:


 Hi All,
 A quick question.  I need to install Cumulative Hotfix 3 and 4 on a
server.
  If I install 4, will that include 3 (as the word cumulative seems to
 imply)?  Or do I need to install CH 3 first and then install CH 4?
 Thanks!
 Nick




 



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


FusionReactor log archive stopped working

2013-07-26 Thread Bobby

We have MANY servers all running the exact same setupŠ All with fusion
reactor installed. All of the FR logging and log archive settings are
identical but one of them stopped archiving the logs for some reason.

Instead of archiving, it just grows the active log file forever.

Since it only purges archived logs, drive space is an issue.

I tried to trigger the archival manually in FR Log Archive UI. It claimed
success but showed 0mb for the archive sizes and the archive directory
remains empty.

I then set the log rotation to every 1 minute and watched the Log Archive UI
do the same thing automatically every 1 minuteŠ Archives aren't created and
live log files continue to grow.

Anyone else seen this?






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


Re: assess/

2013-07-02 Thread Bobby

Since I'm on this list... I'm going to go with the name.

On 7/2/13 11:06 AM, Mark A Kruger mkru...@cfwebtools.com wrote:


Is this a request for analysis or is he calling us a peculiar (and
misspelled) name?

-Original Message-
From: Matthew Friedman [mailto:m...@hozgroup.com]
Sent: Tuesday, July 02, 2013 8:34 AM
To: cf-talk
Subject: assess/


A
Sent from my iPhone





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


Re: CF Live

2013-05-29 Thread Bobby

It throws an error on CF as well.

createObject error no less.

Security: The requested template has been denied access to
createobject(java).



On 5/29/13 3:06 PM, Raymond Camden raymondcam...@gmail.com wrote:


FYI, using CFDUMP/Railo throws an error.


On Wed, May 29, 2013 at 1:31 PM, Russ Michaels r...@michaels.me.uk
wrote:


 Greetings,

 Just thought I would share this new CF App  I have recently released
last
 week, hopefully this will be useful to the community and might perhaps
 encourage a few more people to try out CFML, you cannot really get any
less
 effort than this.

 www.cflive.net


 --

 --

 *Russ Michaels*
 Blog: www.michaels.me.uk
 *skype*: russmichaels

 *My other sites/projects*
 www.bluethunder.co   : SME hosting solutions
 www.cfmldeveloper.com: ColdFusion/Railo developer hosting
 www.cfsearch.com : ColdFusion search engine
 www.cflive.net   : Live CFML console/testing tool

 **


 



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


Re: Coldfusion 8 erratic behavior

2013-05-25 Thread Bobby

Like Russ said, check the stack. If you can't seem to catch it, you can
set up FusionReactor to send you notifications (that include the stack
trace) when threads hit a certain time in their life span.

You said you didn't think it was DB. How did you determine that? Does it
mean you are using the FusionReactor JDBC wrapper on the datasource? If
not, then I suggest doing that so you can get a full picture of what's
going on with the DB actions in your request.


On 5/24/13 8:39 PM, Richard  Steele r...@photoeye.com wrote:


How can I determine what causes a coldfusion 8 page to be fast loading
sometimes and other times, extremely slow? The server seems to have
enough memory and the traffic is not high. The db query part of the page
is fast according to Fusion Reactor. I don't see any leads in the Fusion
Reactor Request Detail.  What else should I check? Thanks in advance.
Rick 



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


Re: NY Area Recruiters

2013-04-30 Thread Bobby

But he who we do not speak of no longer DOES CF, Phil! lol

On 4/29/13 7:08 PM, Phillip Vector vec...@mostdeadlygame.com wrote:


Either that or it's a sign that they picked up that you misspelled
Recruiters or it could be that you don't specify what you know. CFC's?
Frameworks? Other Skillsets?

It also could be that you only waited 1 hour from 3:30 EST to 4:30 EST.
You
also don't even give a name, so why would people want to even talk to
someone who is hiding behind an email? Sounds like a Michael Firth
situation.

On Mon, Apr 29, 2013 at 4:02 PM, cfprogram...@mail.com wrote:


 Yes, I've been on this list since forever. I normally don't break
 protocal, but there have been no responses. If there are no recruiters
in
 NY seeking incredible CF programmers it should be a concern to us all.
That
 could indeed be a sign of the state of CF.





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


SOT but worth it - Sabin Adams

2013-04-30 Thread Bobby

I'd imagine most people on this list frequent cfobjective.com but, for those
who do not, I hope you enjoy this as much as I did.

http://www.cfobjective.com/news/cfobjective-invests-in-future-cfml-programme
rs/







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


Re: Optimising SQL Statement

2013-04-26 Thread Bobby

You could start by replacing SELECT * with SELECT column1, column2,
column3, etc.


On 4/26/13 6:56 AM, Richard White rich...@re-base.net wrote:


Hi, I am sure there must be a way to restructure this query to bring the
time down but i cannot see it. Any pointers at all would be greatly
appreciated.

 Hi,
 
 We have a problem with one of our MySQL statements and wondering if
 you guys can help point us in the right direction.
 
 Basically the following statement is taking 5 seconds to run. We have
 diagnosed it is down to the join of two select statement. When the
 select statements are run individually they take only 0.2 seconds but
 when combined with the JOIN it takes 5 seconds.
 
 WE have been told then when MySQL performs a join it creates temporary
 tables in the background. Is this correct?
 
 Is there anything you can see that we are doing wrong or can you see a
 better way? 
 
  code start --
 
 SELECT temp_4.primaryid, temp_1.`subjectID` , temp_4.`testOccasionID` ,
 `studyNumbers` ,`testDate`
 
 FROM (
   
 SELECT * FROM (
 
 SELECT primarys.primaryid , q_1 AS `subjectID` , q_2 AS `studyNumbers`
 FROM primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid =
 questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL GROUP BY
 primaryid) AS maintable_1
 GROUP BY `subjectID` ) AS temp_1
 
 JOIN 
 
 (SELECT * FROM 
 (SELECT primarys.primaryid , q_1 AS `subjectID` , q_4 AS
 `testOccasionID` , DATE_FORMAT(q_5, '%m/%d/%Y') AS `testDate` FROM
 primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid =
 questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL AND q_4 IS
 NOT NULL GROUP BY primaryid) AS maintable_4
 GROUP BY `subjectID` ,`testOccasionID` ) AS temp_4
 
 ON temp_1.`subjectID` = temp_4.`subjectID`
 
  code end --
 
 Many thanks
 Richard 



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


Re: How to learn to build mobile apps..

2013-04-19 Thread Bobby

phonegap+

It was very easy to figure out. We used it recently to convert a
responsive hack day project into a mobile app. It worked like a champ.


On 4/19/13 6:27 AM, Raymond Camden raymondcam...@gmail.com wrote:


I'd take a look at PhoneGap (phonegap.com).


On Fri, Apr 19, 2013 at 12:59 AM, Cameron Childress
camer...@gmail.comwrote:


 I like Titanium:

 Some decent but not awesome basic instruction:

 
http://mobile.tutsplus.com/tutorials/appcelerator/appcelerator-developmen
t/

 -Cameron


 On Fri, Apr 19, 2013 at 1:45 AM, Jerry Milo Johnson jmi...@gmail.com
 wrote:

 
  Phonegap (html5/css/js skillz needed)
 
  Titanium (js skillz needed)
 
  Native development (2 different environments, one for iDevices, one
for
  Android)
 
  if at all possible, I prefer the first.
 
 
  On Fri, Apr 19, 2013 at 1:41 AM, Mike K afpwebwo...@gmail.com wrote:
 
  
   I need to learn how to build mobile apps for iPad/iPhone and
Android.
  
   I have been building responsive web sites for mobile devices and
think
 I
   have a reasonable understanding of the issues involved with that,
but I
   have a project coming up that will require a full-on app not just a
web
   site.
  
   So here's my question to those of you who build mobile apps ... how
  would I
   go about learning this?   Is there a course i can take?   On line
 course?
   Books?Where do i gather the skills?
  
   I dont have a tertiary qualification in programming - everything
I've
   learned so far I've picked up along the way, so I have quite a steep
   learning curve for building mobile apps, I think.
  
  
   Cheers
   Mike Kear
   Windsor, NSW, Australia
   Adobe Certified Advanced ColdFusion Developer
   AFP Webworks
   http://afpwebworks.com
   ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
  
  
  
 
 

 



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


Re: Anyone ever created their own email archive with CF?

2013-04-16 Thread Bobby

How about BCC to a designated box?

On 4/15/13 9:04 PM, Rick Faircloth r...@whitestonemedia.com wrote:


I've been trying to find a good way to store email
*from* AND *to* my clients. (you know, create that
really handy paper trail you need sometimes...)

I've tried all sorts of ways from The Brain to Evernote
to One Note, but nothing works easily or automatically.

Just wondering if anyone has tried this.  I found nothing
about it when searching the Internet.

Rick





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


Re: Anyone ever created their own email archive with CF?

2013-04-16 Thread Bobby

I guess you could really only control the initial TO with that solution.


On 4/16/13 1:25 PM, Bobby bo...@acoderslife.com wrote:


How about BCC to a designated box?

On 4/15/13 9:04 PM, Rick Faircloth r...@whitestonemedia.com wrote:


I've been trying to find a good way to store email
*from* AND *to* my clients. (you know, create that
really handy paper trail you need sometimes...)

I've tried all sorts of ways from The Brain to Evernote
to One Note, but nothing works easily or automatically.

Just wondering if anyone has tried this.  I found nothing
about it when searching the Internet.

Rick







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


Re: Issue with Session scope

2013-03-15 Thread Bobby

Sounds like your sessions aren't persisting across requests. There could
be a couple of reasons but the most common, from what I've seen, is that
people forget to enable session management in their application.


On 3/15/13 10:43 AM, fun and learning funandlrnn...@gmail.com wrote:


I am converting a hidden variable to session variable. I am setting a
session variable when a page loads. The page consists of a form

cfset session.host = cgi.remotehost

When the form is submitted, the session variable is saved to a file. The
form submits to the same page except there is a condition,

cfif isdefined(form.submit)
  cfinclude template=savetofile.cfm
/cfif

The problem is when I submit the form on my computer, the session
variable exists and form submission works fine. But when I asked some
other people at my office to test, they get 'Element host is undefined in
session' on form's submission.Looks like it is failing in savetofile.cfm.
Why could this be happening?




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


Re: Issue with Session scope

2013-03-15 Thread Bobby

No doubt. Also, as Roger pointed out. It is not cgi.remotehsot, it is
cgi.remote_host.

Cgi.remotehost will result in an empty string.

On 3/15/13 11:24 AM, Matt Quackenbush quackfu...@gmail.com wrote:


Your application timeout is seriously set to 10 seconds??  I suspect that
would hose sessions pretty quickly, but not sure, since I've never set an
app timeout so short.  :-)

HTH


On Fri, Mar 15, 2013 at 11:18 AM, funand learning
funandlrnn...@gmail.comwrote:


 I did enable session management using cfapplication tag. Below is the
piece
 of code

 cfapplication name=app
 applicationtimeout=#createtimespan(0, 0, 0, 10)#
   sessionmanagement=yes
   clientmanagement=no


 On Fri, Mar 15, 2013 at 12:15 PM, Bobby bo...@acoderslife.com wrote:

 
  Sounds like your sessions aren't persisting across requests. There
could
  be a couple of reasons but the most common, from what I've seen, is
that
  people forget to enable session management in their application.
 
 
  On 3/15/13 10:43 AM, fun and learning funandlrnn...@gmail.com
wrote:
 
  
  I am converting a hidden variable to session variable. I am setting a
  session variable when a page loads. The page consists of a form
  
  cfset session.host = cgi.remotehost
  
  When the form is submitted, the session variable is saved to a file.
The
  form submits to the same page except there is a condition,
  
  cfif isdefined(form.submit)
cfinclude template=savetofile.cfm
  /cfif
  
  The problem is when I submit the form on my computer, the session
  variable exists and form submission works fine. But when I asked some
  other people at my office to test, they get 'Element host is
undefined
 in
  session' on form's submission.Looks like it is failing in
 savetofile.cfm.
  Why could this be happening?
  
  
  
 
 

 



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


Re: Issue with Session scope

2013-03-15 Thread Bobby

They are different because the sessions aren't persisting. They are being
recreated on each request.

Whats the session timeout?

On 3/15/13 11:37 AM, funand learning funandlrnn...@gmail.com wrote:


also cfid cftoken are same for me before and after form submission. When I
asked my colleague to test, I see they are different before and after form
submission. I thought this issue happens when we use cflocation, but I am
not using this tag either

On Fri, Mar 15, 2013 at 11:34 AM, funand learning
funandlrnn...@gmail.comwrote:

 sorry, it is remote_host in my code. I will try to increase application
 time out and try


 On Fri, Mar 15, 2013 at 12:32 PM, Bobby bo...@acoderslife.com wrote:


 No doubt. Also, as Roger pointed out. It is not cgi.remotehsot, it is
 cgi.remote_host.

 Cgi.remotehost will result in an empty string.

 On 3/15/13 11:24 AM, Matt Quackenbush quackfu...@gmail.com wrote:

 
 Your application timeout is seriously set to 10 seconds??  I suspect
that
 would hose sessions pretty quickly, but not sure, since I've never
set an
 app timeout so short.  :-)
 
 HTH
 
 
 On Fri, Mar 15, 2013 at 11:18 AM, funand learning
 funandlrnn...@gmail.comwrote:
 
 
  I did enable session management using cfapplication tag. Below is
the
 piece
  of code
 
  cfapplication name=app
  applicationtimeout=#createtimespan(0, 0, 0, 10)#
sessionmanagement=yes
clientmanagement=no
 
 
  On Fri, Mar 15, 2013 at 12:15 PM, Bobby bo...@acoderslife.com
wrote:
 
  
   Sounds like your sessions aren't persisting across requests. There
 could
   be a couple of reasons but the most common, from what I've seen,
is
 that
   people forget to enable session management in their application.
  
  
   On 3/15/13 10:43 AM, fun and learning funandlrnn...@gmail.com
 wrote:
  
   
   I am converting a hidden variable to session variable. I am
setting
 a
   session variable when a page loads. The page consists of a form
   
   cfset session.host = cgi.remotehost
   
   When the form is submitted, the session variable is saved to a
file.
 The
   form submits to the same page except there is a condition,
   
   cfif isdefined(form.submit)
 cfinclude template=savetofile.cfm
   /cfif
   
   The problem is when I submit the form on my computer, the session
   variable exists and form submission works fine. But when I asked
 some
   other people at my office to test, they get 'Element host is
 undefined
  in
   session' on form's submission.Looks like it is failing in
  savetofile.cfm.
   Why could this be happening?
   
   
   
  
  
 
 
 
 

 



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


Re: Issue with Session scope

2013-03-15 Thread Bobby

Your session is tied to the application. With a 10 second timeout, you are
more than likely seeing the application timeout (which means all the
sessions in it are gone too).

You can prove this by changing the application name to something like
#createUUID()# or #now()# and seeing if that is also changing when you
experience your issue.

My guess is that every time you see this issue, the application name will
have changed.


On 3/15/13 12:41 PM, Bobby bo...@acoderslife.com wrote:


They are different because the sessions aren't persisting. They are being
recreated on each request.

Whats the session timeout?

On 3/15/13 11:37 AM, funand learning funandlrnn...@gmail.com wrote:


also cfid cftoken are same for me before and after form submission. When
I
asked my colleague to test, I see they are different before and after
form
submission. I thought this issue happens when we use cflocation, but I am
not using this tag either

On Fri, Mar 15, 2013 at 11:34 AM, funand learning
funandlrnn...@gmail.comwrote:

 sorry, it is remote_host in my code. I will try to increase application
 time out and try


 On Fri, Mar 15, 2013 at 12:32 PM, Bobby bo...@acoderslife.com wrote:


 No doubt. Also, as Roger pointed out. It is not cgi.remotehsot, it is
 cgi.remote_host.

 Cgi.remotehost will result in an empty string.

 On 3/15/13 11:24 AM, Matt Quackenbush quackfu...@gmail.com wrote:

 
 Your application timeout is seriously set to 10 seconds??  I suspect
that
 would hose sessions pretty quickly, but not sure, since I've never
set an
 app timeout so short.  :-)
 
 HTH
 
 
 On Fri, Mar 15, 2013 at 11:18 AM, funand learning
 funandlrnn...@gmail.comwrote:
 
 
  I did enable session management using cfapplication tag. Below is
the
 piece
  of code
 
  cfapplication name=app
  applicationtimeout=#createtimespan(0, 0, 0, 10)#
sessionmanagement=yes
clientmanagement=no
 
 
  On Fri, Mar 15, 2013 at 12:15 PM, Bobby bo...@acoderslife.com
wrote:
 
  
   Sounds like your sessions aren't persisting across requests.
There
 could
   be a couple of reasons but the most common, from what I've seen,
is
 that
   people forget to enable session management in their application.
  
  
   On 3/15/13 10:43 AM, fun and learning funandlrnn...@gmail.com
 wrote:
  
   
   I am converting a hidden variable to session variable. I am
setting
 a
   session variable when a page loads. The page consists of a form
   
   cfset session.host = cgi.remotehost
   
   When the form is submitted, the session variable is saved to a
file.
 The
   form submits to the same page except there is a condition,
   
   cfif isdefined(form.submit)
 cfinclude template=savetofile.cfm
   /cfif
   
   The problem is when I submit the form on my computer, the
session
   variable exists and form submission works fine. But when I asked
 some
   other people at my office to test, they get 'Element host is
 undefined
  in
   session' on form's submission.Looks like it is failing in
  savetofile.cfm.
   Why could this be happening?
   
   
   
  
  
 
 
 
 

 





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


Re: Why is this happening??????

2013-03-14 Thread Bobby

I guess you had no luck finding an instance of jsStringFormat().

Does the value ever hit a scope covered by global script protection before
it gets set to the app scope?

You could easily rule it out by making sure it is off or turning it off
long enough to test.



On 3/14/13 12:25 AM, Kym Kovan dev-li...@mbcomms.net.au wrote:


Rick,

how are you returning this structure? You haven't got some funny format
turning on as the return from the CFC function by accident have you?

Kym

On 14/03/2013 15:49, Rick Faircloth wrote:

 The application.temp_images_directory is being set in application.cfc:

 cfset application.temp_images_directory = 'e:\tempImages' /

 The last part of the example below, the
#newImageFileName#.#originalImageExt#
 is being set in news.cfc, after an image has been uploaded. It's done
this
 way to be able to manipulate the filename part before the extension,
such as:

 #newImageFileName#_400.#originalImageExt#

 I'm checking it right now by setting struct variables
 in a cfc such as,

 cfset saveNewsItemStruct.APPTEMP =
 
'#application.temp_images_directory#\#newImageFileName#_400.#originalImag
eExt#' /

 then, just returning the struct to the calling page:

 cfreturn saveNewsItemStruct /

 The saveNewsItemStruct.APPTEMP would end up looking like:

 e:\\temp_images\\duck_400.jpg

 And when I tried Dave's solution of using forward slashes, /,
 instead of back slashes, I'd end up with:

 e:\/temp_images\/duck_400.jpg

 I'm not sure what is inserting the backslashes. I don't believe
 I've ever run into this before.

 Rick



 -Original Message-
 From: Jerry Milo Johnson [mailto:jmi...@gmail.com]
 Sent: Wednesday, March 13, 2013 10:18 PM
 To: cf-talk
 Subject: Re: Why is this happening??


 how are you displaying it when the \ are appearing doubled? (something
like
 a js alert, or a cfoutput to an html page, or some other mechanism?)


 On Wed, Mar 13, 2013 at 10:08 PM, Rick Faircloth
 r...@whitestonemedia.comwrote:


 If I use this on a test page:

 cfoutput#application.temp_images_directory#/cfoutput

 it comes out fine: e:\inetpub\webroot\tempImages

 I just don't see why (or how) it could be happening.

 Thanks for the feedback!

 Rick

 -Original Message-
 From: Jerry Milo Johnson [mailto:jmi...@gmail.com]
 Sent: Wednesday, March 13, 2013 9:34 PM
 To: cf-talk
 Subject: Re: Why is this happening??


 what happens if you display the value INSIDE the cfc before you return
it?
 what happens if you set the same variable OUTSIDE the cfc and display
it?


 On Wed, Mar 13, 2013 at 9:23 PM, Rick Faircloth
r...@whitestonemedia.com
 wrote:


 This has been driving me crazy for two days and I GIVE UP! AHH!


 If I create this variable in application.cfc:

 cfset application.temp_images_directory =
 'e:\inetpub\webroot\tempImages'
 /


 and use it in news.cfc like this:

 cfset saveNewsItemStruct = structNew()

 cfset saveNewsItemStruct.ATID =
'#application.temp_images_directory#' /


 why in the WORLD would I get this:

 e:\\inetpub\\webroot\\tempImages


 when I return the struct and display saveNewsItemsStruct.ATID?

 Why are the path lines doubling?


 I don't think I've seen this in 15 years of CF programming!

 (I'm getting too old for all this aggravation...)

 Thanks for any help!

 Rick











 



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


Re: Why is this happening??????

2013-03-13 Thread Bobby

That is the equivalent of what you would see if you ran that variable
through jsStringFormat() somewhere.

I'd run a quick search for that. I'd start in the app.cfc with that search
to make sure you don't have a routine somewhere that cleans' your
variables for you.


On 3/13/13 8:23 PM, Rick Faircloth r...@whitestonemedia.com wrote:


This has been driving me crazy for two days and I GIVE UP! AHH!


If I create this variable in application.cfc:

cfset application.temp_images_directory =
'e:\inetpub\webroot\tempImages' /


and use it in news.cfc like this:

cfset saveNewsItemStruct = structNew()

cfset saveNewsItemStruct.ATID = '#application.temp_images_directory#' /


why in the WORLD would I get this:

e:\\inetpub\\webroot\\tempImages


when I return the struct and display saveNewsItemsStruct.ATID?

Why are the path lines doubling?


I don't think I've seen this in 15 years of CF programming!

(I'm getting too old for all this aggravation...)

Thanks for any help!

Rick





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


Re: now( ) is off by an hour

2013-03-12 Thread Bobby

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions
_m-r_07.html

Gets the current date and time of the computer running the ColdFusion
server

It doesn't get its time form the VPN, it gets its time from the host
machine running the CF service. Clock in the bottom right corner of
windows has the time that the CF server would use.

If, for some reason, you've hidden the clock, cmd.exe  echo %time%

Your windows timezone could be off or you don't have the option set to
adjust for daylight savings time.



On 3/12/13 8:05 AM, daniel kessler dani...@umd.edu wrote:


It's a localhost CFServer (developer mode).  That is on a VPN that I am
using.  The VPN has the correct time.  However the now() is incorrect.
It was correct until daylight savings time.

At this point, I assume that it's getting the time from the machine that
is hosting the VPN, which means that the VPN can have a different time.
However since I don't know where now() gets it's time, I can't get any
traction on this from our support staff.

 Check the date and time on the ColdFusion server. Also, make sure that
 your DB server and ColdFusion server are in the same time zone.



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


Re: Adding Salt and Password Hash to existing acocunts

2013-03-11 Thread Bobby

In the example it was a hardcoded string for the salt. 'mySalt'. you'd
just replace that with whatever you intend to use.

I haven't used SHA512 this way. I only did it the way I did so there was
an equivalent method in CF to generate the same hash.

You'd have to play around with generating SHA512 hashes in TSQL and make
sure you are also able to generate that same hash in CF (assuming you will
be doing your hashing in CF at all before sending to the database).

You can do as many iterations of the salt as you want I suppose. If I was
going to hash multiple times, I'd salt them all.


On 3/11/13 9:05 AM, Torrent Girl moniqueb...@gmail.com wrote:

SHA512





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


Re: Adding Salt and Password Hash to existing acocunts

2013-03-07 Thread Bobby

I suggest adding a new bit flag column to the table and only update
records that have that flag set to 0.

The password update query could set that flag to 1 so if you accidentally
run that template twice, you don't hash and salt salted hashes.

Step 1, back up the database.


On 3/7/13 11:02 AM, Torrent Girl moniqueb...@gmail.com wrote:


Here you go.

Cfquery name=GetUserPasswords
select memberid, password from users
/cfquery
cfoutput#getUserPasswords.RecordCount#/cfoutput!---Just to see how
many we have ---
Cfset salt = ''/
cfset newpassword = ''/
Cfset count = 0/
cfloop query=GetUserPasswords
cfset salt = generateSecretKey(DESEDE )/
Cfset newpassword = hash( hash(password[currentrow]) 
user.salt,SHA-256,us-ascii)/
 cfquery name=updateUser
UPdate users set password = '#user.password#', salt = '#user.salt#'
where memberid = '#memberid[currentrow]#'
 /cfquery
Cfset salt= ''/
cfset newpassword = ''/
Cfset count = count +1/
/cfloop
  and we changed cfoutput#count#/cfoutput

Again, you will want to change one account and test it to make sure that
your login routine will validate the password and login the user.  Then
you
can just run this on the whole table, no muss no fuss.  You won't have to
make the users change anything, their passwords will just be secure.  You
will also have to come up with a Forgot Password routine, since the
passwords are irretrievable.

Cheers,

Rob




Thank you!



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


Re: Adding Salt and Password Hash to existing acocunts

2013-03-07 Thread Bobby

Password expirations would definitely be the way I would have gone with
this.

If I didn't have that option id probably just hash them all with a single
update statement in SQL Server rather than involving CF at all.

update userTable set passwordColumn =
right(master.dbo.fn_varbintohexstr(hashBytes('MD5', cast(passwordColumn +
'mySalt' as nvarchar(max,32)

Then, to convert a submitted password to that in CF,
lcase(hash(passwordString  'mySalt', 'MD5', 'UTF-16LE'))



On 3/7/13 3:00 PM, Roger Austin raust...@nc.rr.com wrote:


 Torrent Girl moniqueb...@gmail.com wrote:

 Did you have a problem with timeouts or out of memory errors?
 
 I have quite a bit of records

This is why I suggested that you pre-expire everyone and have them update
their credentials on next log in.
It spreads out the load and you have to have the code anyway. You might
check for a blank password field
and then send them to change their password to the new salted hash
version. Then, blank out the password
field at the same time.
--
LinkedIn: http://www.linkedin.com/pub/roger-austin/8/a4/60
Twitter:  http://twitter.com/RogerTheGeek
Google+:  https://plus.google.com/117357905892731200369




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


Re: CFFILE Issue

2013-03-07 Thread Bobby

I'd probably start by trying one of these instead just to see if it made a
difference:

./pdf/voucher#user_id#.pdf

Or

#expandPath('./pdf/')#  'voucher#user_id#.pdf'



On 3/7/13 3:41 PM, Bruce Sorge sor...@gmail.com wrote:


I am having something strange going on today with my dev machine. I have
an app that writes a PDF:

cffile action=write file=pdf/Voucher#user_id#.pdf output=#Voucher#
nameconflict=make unique

It has been working great, but today when I ran it I was given an java.io
error that a folder did not exist. Funny thing was that it was looking at
the following path:

ColdFusion10\cfusion\runtime\work\catalina\localhost\tmp\pdf.
But as you can see in my cffile I am pointing to a local folder called
PDF that is in the same directory as the .CFM file calling it. Any ideas?

Also, this is a duplicate of another app that I have that does the exact
same thing, and it works fine. That app is in another directory, and the
only difference is that this new one allows the site admin to generate a
PDF for one customer where the other app I have sends PDF's to all users
who bought something the day prior.

Thanks,

Bruce



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


Re: Anyone see anything wrong with the syntax of the query?

2013-03-05 Thread Bobby

Use cfqueryparam to rule out the value of the arguments variable causing
syntax related issues.

When an error tells you the line number and it is in a query, it rarely is
that actual line; it just knows it is in the query somewhere.



On 3/5/13 11:47 AM, Rick Faircloth r...@whitestonemedia.com wrote:


cfquery name = qGetAllPropertiesAndOpenHouses
datasource=#arguments.real_estate_dsn#

   select  substring_index(p.mls_number, '_', 1) as p.mls_number,
   p.street_number, p.street_name, p.city, p.state,
   oh.mls_number, oh.date, oh.start_time, oh.end_time,
oh.host_name

   fromproperties p

   left join   fortstewart.open_houses oh
   on  substring_index(p.mls_number, '_', 1) = oh.mls_number

   where   p.listing_office_mls_id =
'#arguments.listing_office_mls_id#'
   order byp.street_name, p.street_number

/cfquery

I keep getting a CF error stating I have a syntax error on this line:

where p.listing_office_mls_id =
'#arguments.listing_office_mls_id#'


Anything?

Thanks!

Rick





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


Re: Adding Salt and Password Hash to existing acocunts

2013-03-05 Thread Bobby

The original poster never said they were adding salts to existing hashes.
They laid out the same scenario of converting plaintext passwords to
salted hashes.

On 3/5/13 7:06 PM, Justin Scott leviat...@darktech.org wrote:


 I guess I didn't make myself clear.  I wrote a routine that salted and
 hashed all of the plain text passwords that were in the system.

Ah, that is a good thing then.  I took it that you were adding salts
to an existing hash like the original poster.


-Justin



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


Re: Localization , French Accents...

2013-02-27 Thread Bobby

My first guess is that it is happening when the file is read in. Was it
saved as unicode? I think notepad lets you do that. If not, notepad++ does.


On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote:


I am trying to read in a number of text files that contain translations
(using French in this example) and store them in my applications app
scope.
The file I am reading in looks like this:
http://screencast.com/t/DZTv3iVrbyo

When I dump the results from reading in the file, or try to use them in
output, the accents get munged:
http://screencast.com/t/aoRcLWWHn

I have tried everything I can think of to get this to work and everything
has failed. I have tried manually setting the charset on the CFFILE tag
and
that has not helped. I tried using  UTF-8, and WINDOWS-1255.

Since I have numerous language files I have even tried implementing this
java class org.mozilla.universalchardet.UniversalDetector that detects the
encoding of a file, and then using the detected encoding when reading in
the
translation files. But no matter what I do, the encoding is not preserved.
Note, this library tells me my French files are WINDOWS-1255./

Does anyone have any suggestions on how I can handle this?

Brook





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


Re: Localization , French Accents...

2013-02-27 Thread Bobby

UTF-8 should do it.

On 2/27/13 3:00 PM, Brook Davies cft...@logiforms.com wrote:


Should I be saving it in Unicode or UTF-8?

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: February-27-13 11:01 AM
To: cf-talk
Subject: Re: Localization , French Accents...


My first guess is that it is happening when the file is read in. Was it
saved as unicode? I think notepad lets you do that. If not, notepad++
does.


On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote:


I am trying to read in a number of text files that contain translations
(using French in this example) and store them in my applications app
scope.
The file I am reading in looks like this:
http://screencast.com/t/DZTv3iVrbyo

When I dump the results from reading in the file, or try to use them in
output, the accents get munged:
http://screencast.com/t/aoRcLWWHn

I have tried everything I can think of to get this to work and
everything has failed. I have tried manually setting the charset on the
CFFILE tag and that has not helped. I tried using  UTF-8, and
WINDOWS-1255.

Since I have numerous language files I have even tried implementing
this java class org.mozilla.universalchardet.UniversalDetector that
detects the encoding of a file, and then using the detected encoding
when reading in the translation files. But no matter what I do, the
encoding is not preserved.
Note, this library tells me my French files are WINDOWS-1255./

Does anyone have any suggestions on how I can handle this?

Brook









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


Re: Localization , French Accents...

2013-02-27 Thread Bobby

Any time. Glad it's worked out.

On 2/27/13 3:56 PM, Brook Davies cft...@logiforms.com wrote:


Bobby, thanks for the notepad+ idea - it was the encoding on the source
file

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: February-27-13 12:05 PM
To: cf-talk
Subject: Re: Localization , French Accents...


UTF-8 should do it.

On 2/27/13 3:00 PM, Brook Davies cft...@logiforms.com wrote:


Should I be saving it in Unicode or UTF-8?

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: February-27-13 11:01 AM
To: cf-talk
Subject: Re: Localization , French Accents...


My first guess is that it is happening when the file is read in. Was it
saved as unicode? I think notepad lets you do that. If not, notepad++
does.


On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote:


I am trying to read in a number of text files that contain
translations (using French in this example) and store them in my
applications app scope.
The file I am reading in looks like this:
http://screencast.com/t/DZTv3iVrbyo

When I dump the results from reading in the file, or try to use them
in output, the accents get munged:
http://screencast.com/t/aoRcLWWHn

I have tried everything I can think of to get this to work and
everything has failed. I have tried manually setting the charset on
the CFFILE tag and that has not helped. I tried using  UTF-8, and
WINDOWS-1255.

Since I have numerous language files I have even tried implementing
this java class org.mozilla.universalchardet.UniversalDetector that
detects the encoding of a file, and then using the detected encoding
when reading in the translation files. But no matter what I do, the
encoding is not preserved.
Note, this library tells me my French files are WINDOWS-1255./

Does anyone have any suggestions on how I can handle this?

Brook













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


Re: SOT: Graphic Artist Software for HTML CSS

2013-02-22 Thread Bobby

In the beginning, I actually sliced designs. When I did, I used Image
Ready. It was much better suited for the slicing part than Photoshop.


On 2/22/13 12:04 PM, Gerald Guido gerald.gu...@gmail.com wrote:


In the past I have used Photoshop's Slice tool. It does a fairly decent
job
but I have always had to go in and massage it by hand. It does not by any
means leave you with finished product out of the box but it takes care of
a
lions share of the grunt work.

HTH
G!

On Fri, Feb 22, 2013 at 11:38 AM, Chad Gray cg...@careyweb.com wrote:


 I have not kept track of all the graphic artist software adobe has come
 out with to go from mockups to HTML/CSS.



 If I were to tell a graphic designer to design me some mockups for a web
 site, what is the best adobe software that will export out to _CLEAN_
 (looks like hand written J) HTML/CSS that I can inject my CF code easily
 into?



 Muse?



 Thanks!









 



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


Re: How would you optimize this SQL?

2013-02-20 Thread Bobby

You could also add schema prefixes to your tables and columns (or alias
them) as well as make the 1 a parameter.

That should help with execution plan caching.


Declare @myBit int
Set @myBit = 1
SELECT @intCourseCompletions = COUNT(m.intMemberStageID) FROM
dbo.tblMemberStages m WHERE m.bitCompleted = @myBit;



On 2/20/13 11:30 AM, Torrent Girl moniqueb...@gmail.com wrote:


 Well, that code would be equivalent to:
 
 SELECT @intCourseCompletions = COUNT(intMemberStageID) FROM
 tblMemberStages WHERE bitCompleted = 1;
 
 However I believe to get any performance increase you will need an
 index on bitCompleted.
 
 CREATE INDEX myindexname ON tblMemberStages (bitCompleted);
 
 You could also try: SELECT @intCourseCompletions =
 sum(cast(bitCompleted as int)) FROM tblMemberStages;
 
 The conversion to INT may or may not take longer. The index is
 probably your best bet but try both ways to see which works best.
 
 Steve
 
 -Original Message-
 From: Torrent Girl [mailto:moniqueb...@gmail.com]
 Sent: Wednesday, February 20, 2013 11:07 AM
 To: cf-talk
 Subject: How would you optimize this SQL?
 
 
Thank you.





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


Re: How would you optimize this SQL?

2013-02-20 Thread Bobby

Will it even cache the plan without the 1 being a parameter?

In either case, I'd still advocate the use of schema prefixes/aliases.


On 2/20/13 1:15 PM, Dave Watts dwa...@figleaf.com wrote:


 You could also add schema prefixes to your tables and columns (or alias
 them) as well as make the 1 a parameter.

 That should help with execution plan caching.

Actually, caching the execution plan with a parameter here is probably
a bad idea - at least half the time!

When you have a bit value (on/off) as a parameter, the execution plan
will either be very very good, or very very bad. You're better off not
using a parameter (which will give you two execution plans ultimately
that are more specific and both very very good) or using WITH
RECOMPILE to avoid the use of any cached execution plans at all.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



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


Re: Anyone using CFPDF/CFPDFFORM to deliver personalized PDFs?

2013-01-15 Thread Bobby

It has been a very long time but a number of years ago, I did a college
application in PDF format.

The PDF was already defined by the college and the format couldn't change.
What I did was go into the PDF and make all of the answer sections form
fields. Then, obviously, created a web form to gather all the answers.

Once the form was submitted, all of those answers were used to generate a
PDF answer file. The two files together populated the PDF with all the
answers. It was tedious work since all the answer fields needed to match
the PDF field names exactly (it was a huge application) but once that was
done, it worked like a champ.

It was all native CF code in (if I recall) CF6.



On 12/12/12 10:59 AM, Stephen Hait sh...@mindspring.com wrote:


We have an app that takes a user's info and uses it to populate an
existing, blank Acrobat PDF form template that the user can then view,
save
or print. We had been using a commercial component, ActivePDFToolkit, for
this on a CF7 platform.

Our process previously had been to populate the PDF form template from a
query, then to flatten and save the resulting PDF with a unique name. Now
we want to use CF10 to accomplish the same goal.

I'd be interested in discussing the approaches you may have taken for
doing
this type of thing with CF10. If anyone has experience with this and would
be willing to discuss how you've approached it, please let me know, either
through the list or by e-mail.

Regards,
Stephen Hait
sh...@mindspring.com




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


Re: (ot) Blocking IPs

2012-11-01 Thread Bobby

Ha! I was about to reply with the exact same link...

On 11/1/12 4:06 PM, Dave Watts dwa...@figleaf.com wrote:


 I have found it effective to block troublesome emails for some length of
 time, usually 6 months does it.

http://instantrimshot.com/

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



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


Re: HomeSite

2012-10-07 Thread Bobby

I believe it was in the CFWACK for version 4.5 or 5. Maybe you have that
book or know someone who does?

On 10/7/12 10:27 AM, Richard Colman col...@uci.edu wrote:


Hate to bring this up again, but I have used Homesite for many years and
do like it.

I need to transfer the application to a new computer, and the original
install disks are long gone.

Does anyone know of a source to obtain or purchase?

TNX,

signed ... the dinosaur ...



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


Re: CFHeader Problem

2012-06-26 Thread Bobby

Which CF Version? What is the file size of myfile.zip? And how much memory
is allocated to CF?


On 6/26/12 11:08 AM, Robert Harrison rob...@austin-williams.com wrote:


According to the documentation the default is yes.


Robert Harrison 
Director of Interactive Services

Austin  Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788
T 631.231.6600 X 119   F 631.434.7022
http://www.austin-williams.com

Blog:  http://www.austin-williams.com/blog
Twitter:  http://www.twitter.com/austin_williams


-Original Message-
From: 
Sent: Tuesday, June 26, 2012 11:04 AM
To: cf-talk
Subject: Re: CFHeader Problem


 What's wrong with the below?

Don't you need  RESET=yes inside the CFCONTENT tag?





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


Re: CFHeader Problem

2012-06-26 Thread Bobby

Sorry. I didn't realize it was solved. It would help to not change the
subject of the thread ;-)

On 6/26/12 10:26 PM, Bobby bo...@acoderslife.com wrote:


Which CF Version? What is the file size of myfile.zip? And how much memory
is allocated to CF?


On 6/26/12 11:08 AM, Robert Harrison rob...@austin-williams.com wrote:


According to the documentation the default is yes.


Robert Harrison 
Director of Interactive Services

Austin  Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788
T 631.231.6600 X 119   F 631.434.7022
http://www.austin-williams.com

Blog:  http://www.austin-williams.com/blog
Twitter:  http://www.twitter.com/austin_williams


-Original Message-
From: 
Sent: Tuesday, June 26, 2012 11:04 AM
To: cf-talk
Subject: Re: CFHeader Problem


 What's wrong with the below?

Don't you need  RESET=yes inside the CFCONTENT tag?







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


CF8 AdminApi throws errors.

2012-06-04 Thread Bobby Hartsfield

 

I've been using the admin API for years to list and create datasources so I
am pretty familiar with it (which isn't to say I'm not doing something dumb
and just missing it). We recently created two new CF8.0.1 machines (clones
of a existing machines that work fine). There are hundreds of datasources on
the cloned machines and I needed to clean them out and create new ones. I
decided to use the admin API to do both tasks. However, all requests of any
methods within the datasource.cfc are throwing odd errors on the new
servers.

 

For instance, a simple list of datasources (which i know I can get with the
service factory but this is happening with datasource delete and create
attempts as well)

 

This is the code (quite basic and known to work elsewhere)

 

cfsetadminObj =
createObject(component,cfide.adminapi.administrator) /

cfset isLoggedin = adminObj.login(cfadminpassword) /

cfif isLoggedin

cfdump
var=#createObject(component,cfide.adminapi.datasource).getDatasources()
# /

/cfif

 

The error behind that one is:

 


 


 



The error occurred in datasource.cfc: line 67


-1 : Unable to display error's location in a CFML template.

 

No actual error message; just that info.

 

The stack points to authentication issues
(coldfusion.security.SecurityManager$UnauthenticatedCredentialsException)
but the isLogged check is true and im positive the password in
cfadminpassword is correct (further indicated by isLoggedIn being true).
The Cf Admin is set to Use a single password only (default)

 

Here is the top of the stack:

 

coldfusion.security.SecurityManager$UnauthenticatedCredentialsException
 at
coldfusion.security.SecurityManager.authenticateAdmin(SecurityManager.java:1
704)
 at coldfusion.sql.Executive.getDatasources(Executive.java:92)
 at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at coldfusion.runtime.StructBean.resolveName(StructBean.java:188)
 at coldfusion.runtime.Scope.get(Scope.java:60)
 at
coldfusion.runtime.ScopeSearchResult.searchForSubkeys(ScopeSearchResult.java
:104)
 at coldfusion.runtime.LocalScope.search(LocalScope.java:441)
 at
coldfusion.runtime.NeoPageContext.searchScopes(NeoPageContext.java:662)
 at
coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1653)
 at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1612)
 at
coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1747)
 at
coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1740)
 at
cfdatasource2ecfc498810217$funcGETDATASOURCES.runFunction(E:\cf8_updates\cfu
sion\wwwroot\CFIDE\adminapi\datasource.cfc:67)

 

Has anyone ran into this one before or have any ideas on what to try next?

 

Thanks.

 

.:.:.:.:.:.:.:.:.:.:.:.

Bobby Hartsfield

http://acoderslife.com

http://cf4em.com

 




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


RE: CF8 AdminApi throws errors.

2012-06-04 Thread Bobby Hartsfield

I set the CF Admin to no authentication (just to test) and it appears to
work. There server will be public facing once it is setup so I sure can't
leave it that way. it is interesting though...

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Monday, June 04, 2012 2:00 PM
To: cf-talk
Subject: CF8 AdminApi throws errors.


 

I've been using the admin API for years to list and create datasources so I
am pretty familiar with it (which isn't to say I'm not doing something dumb
and just missing it). We recently created two new CF8.0.1 machines (clones
of a existing machines that work fine). There are hundreds of datasources on
the cloned machines and I needed to clean them out and create new ones. I
decided to use the admin API to do both tasks. However, all requests of any
methods within the datasource.cfc are throwing odd errors on the new
servers.

 

For instance, a simple list of datasources (which i know I can get with the
service factory but this is happening with datasource delete and create
attempts as well)

 

This is the code (quite basic and known to work elsewhere)

 

cfsetadminObj =
createObject(component,cfide.adminapi.administrator) /

cfset isLoggedin = adminObj.login(cfadminpassword) /

cfif isLoggedin

cfdump
var=#createObject(component,cfide.adminapi.datasource).getDatasources()
# /

/cfif

 

The error behind that one is:

 


 


 



The error occurred in datasource.cfc: line 67


-1 : Unable to display error's location in a CFML template.

 

No actual error message; just that info.

 

The stack points to authentication issues
(coldfusion.security.SecurityManager$UnauthenticatedCredentialsException)
but the isLogged check is true and im positive the password in
cfadminpassword is correct (further indicated by isLoggedIn being true).
The Cf Admin is set to Use a single password only (default)

 

Here is the top of the stack:

 

coldfusion.security.SecurityManager$UnauthenticatedCredentialsException
 at
coldfusion.security.SecurityManager.authenticateAdmin(SecurityManager.java:1
704)
 at coldfusion.sql.Executive.getDatasources(Executive.java:92)
 at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at coldfusion.runtime.StructBean.resolveName(StructBean.java:188)
 at coldfusion.runtime.Scope.get(Scope.java:60)
 at
coldfusion.runtime.ScopeSearchResult.searchForSubkeys(ScopeSearchResult.java
:104)
 at coldfusion.runtime.LocalScope.search(LocalScope.java:441)
 at
coldfusion.runtime.NeoPageContext.searchScopes(NeoPageContext.java:662)
 at
coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1653)
 at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1612)
 at
coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1747)
 at
coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:1740)
 at
cfdatasource2ecfc498810217$funcGETDATASOURCES.runFunction(E:\cf8_updates\cfu
sion\wwwroot\CFIDE\adminapi\datasource.cfc:67)

 

Has anyone ran into this one before or have any ideas on what to try next?

 

Thanks.

 

.:.:.:.:.:.:.:.:.:.:.:.

Bobby Hartsfield

http://acoderslife.com

http://cf4em.com

 






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


Re: CF real time data updates possible?

2012-06-03 Thread Bobby

If you are on CF10 (in which case, I'd be jealous), then look into the new
WebSockets.

If not, then I believe you will be stuck polling for changes on regular
intervals to get the submissions of others.

Here is an example of websockets in CF10.

http://www.bennadel.com/blog/2351-ColdFusion-10-Using-WebSockets-To-Push-A-
Message-To-A-Target-User.htm


On 6/3/12 4:57 PM, Akos Fortagh akos.fort...@yahoo.com wrote:


Wondering if anyone has a good suggestion how I might be able to achieve
the following without using flash if possible.
I have a simple interface where logged in users fill out 10 multiple
choice questions and at the end they get a score like 5 out of 10 etc.
The odd thing is that they must be able to see other users' scores real
time so it all becomes like a live competition.
Is there a way of 'pushing' the other users' scores somehow to the logged
in user's screen as soon as the 'other' users score some points?
Hopefully this all makes sense...
Or am I thinking the impossible?
Any help or suggestions would be much appreciated.
Akos





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


Re: Movie To Watch

2012-05-12 Thread Bobby

FYI, There is a cf-community list for these types of off topic threads.

On 5/12/12 1:30 PM, Brian Thornton br...@cfdeveloper.com wrote:


Bobcat Goldthwait and Darko Productions put our a GREAT movie that
challenges society, religion and stereotypes...

To me, Robin WIlliams through this movie explains why Dave Chapelle
would move to Africa.

Thought I would share..

http://movies.netflix.com/WiMovie/World_s_Greatest_Dad/70112475?trkid=4966
24



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


Re: date and time from two different inputs query a single datetime field

2012-05-10 Thread Bobby

#createOBDCDateTime(form.xdate_use  ' '  form.xtime)#


On 5/10/12 9:50 PM, Les Mizzell lesm...@bellsouth.net wrote:


cfinput type=text name=xdate_use  ex: 05/31/2012
cfinput type=text name=xtime  ex: 3:31 PM

Given the values used as examples for the fields above, exactly how
would I go about querying a datetime stamp field (SQL Server) to find
all records dates on or after the date/time above?

No problem doing it with just the date:

   responsedate = cfqueryparam value=#trim(form.xdate)#
cfsqltype=CF_SQL_DATE /


  but for the life of me, I can't figure how to put both fields together
to do date AND time...

I'm probably an idiot..



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


Re: CFINVOKE - Component Location

2012-05-03 Thread Bobby

Try component=gallerycomponents.functions




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


FusionReactor - Development server

2012-04-14 Thread Bobby

I figured if anyone knew the answer to this (outside of FR Support), it
would be someone on this listŠ

I may have dreamed this because I can't find it again but I thought I read
that if you bought a FusionReactor enterprise license, you were also allowed
to install a second copy on a development server at no extra cost.

Does anyone know whether or not that is true?

Thanks





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


Re: FusionReactor - Development server

2012-04-14 Thread Bobby

I saw that but it doesn't mention development. Their license does talk
about a development license but doesn't talk about cost in the license.

You ever have one of those dreams that seems s real? Apparently I have
:-)



On 4/14/12 10:23 AM, andy matthews li...@commadelimited.com wrote:


Looks like you might have been dreaming:

http://www.fusion-reactor.com/fr/faq.cfm#licencing1

Each physical or virtual server requires one FusionReactor license - all
of
the instances which are installed on that server are covered by the one
FusionReactor license. So, if you have (say) 6 physical boxes, then you
need
6 licenses. Note, that on a single box you may have multiple instances
(ColdFusion, JRun, Tomcat, JBoss) installed on it, but you still only
need 1
license for that (virtual or physical) server. Virtual Machines (VM's) are
also classed as separate physical servers and therefore require a license.


andy 

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com]
Sent: Saturday, April 14, 2012 8:31 AM
To: cf-talk
Subject: FusionReactor - Development server


I figured if anyone knew the answer to this (outside of FR Support), it
would be someone on this list©

I may have dreamed this because I can't find it again but I thought I read
that if you bought a FusionReactor enterprise license, you were also
allowed
to install a second copy on a development server at no extra cost.

Does anyone know whether or not that is true?

Thanks









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


Re: Can I ask why this place has been taken over by Brian Thornton aka CFDeveloper

2012-04-12 Thread Bobby

Mike, a couple of emails a day is hardly enough to hide anything. I have
no problem seeing everything that comes across the list. I think it's fine
the way it is and prefer it. People who don't like it DO have optionsŠ
They can filter the emails or they can switch to digest.

I'd reconsider asking him to change anything. Instead, I'd consider asking
recruiters to not complain simply because someone is giving away what they
sell.


On 4/12/12 9:52 AM, Christian N. Abad li...@accessiblecomputing.com
wrote:


Jordan:

I agree with you!  I personally feel that Brian Thornton is performing a
fantastic service for the CF Community in general.

Thank You, Brian!  :-)

Personally, I have seen over 15 possible job opportunities from Brian's
postings that are an excellent fit for my skillset, although I'm not
currently looking at this time (but  I do like to keep my finger on the
pulse of this list).

Just my $0.02 as well...

Cheers!

Christian N. Abad - President

Accessible Computing, Inc.
1210 McLaughlin Drive
Charlotte, NC 28212
http://www.AccessibleComputing.com

704.900.1825 (Direct Line)
li...@accessiblecomputing.com

-Original Message-
From: Jordan Michaels [mailto:jor...@viviotech.net]
Sent: Wednesday, April 11, 2012 4:30 PM
To: cf-jobs-talk
Subject: Re: Can I ask why this place has been taken over by Brian
Thornton
aka CFDeveloper


Not that my opinion really matters here, but I don't see the problem.

That is a CF-Jobs list, and the posts are listing real jobs. Is that not
the
content that the majority of subscribers of CF-Jobs are wanting? I would
hardly call posts with legitimate content spam simply because a single
person (who isn't interested in the content anyway) doesn't like it. The
content is true to the purpose of the list. No big deal.

My $0.02.

-Jordan



On 04/11/2012 12:49 PM, Michael Dinowitz wrote:

 I'm going to ask Brian to send a daily summary or something like it.
 The amount of generated posts are hiding the individual posts from
 others.


 On Wed, Apr 11, 2012 at 3:35 PM, Larry C. Lyonslarrycly...@gmail.com
wrote:

 These are legitimate jobs however. It appears that Brian has written
 an app that goes through Craigslist looking for CF related jobs. That
 would be a community service if you ask me.

 BTW jerry, lets keep this confined to cf-jobs-talk and not clutter up
cf-jobs.

 regards,

 larry

 On Wed, Apr 11, 2012 at 10:00 AM, Jerry Albright
 je...@profsearchgroup.com  wrote:

 His non stop spam is ridiculous.  Is anyone in charge here?  Is this
place simply a free-for-all? Left to the demise of someone who thinks it's
helpful to soak this place with Craigslist ads?

 Wow.  This is ridiculous.





 





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


RE: random records no duplicates

2012-03-29 Thread Bobby Hartsfield

There are more efficient ways of getting a single random record from the
database. You are grabbing them all every time when you only need 1.


SQL Server:
SElECT TOP 1 q.questionid, q.questiontext FROM questions q ORDER BY NEWID()

MySQL
SELECT q.questionid, q.questiontext FROM questions q ORDER BY RAND() LIMIT
0,1


As for not showing a user the same question twice, you could store the
questionIDs that they have seen in their session (or the questionIds that
they havent seen... your call) and then filter those from your possible
results.

1: Get a random record they havent seen
SELECT TOP 1 q.questionid, q.questiontext FROM questions q WHERE
q.questionId NOT IN cfqueryparam cfsqltype=cf_sql_integer
value=#session.listOfUsedQuestionIds# list=true /) ORDER BY NEWID()

2: Add it to the list of questions they have seen
listappend(session.listofusedquestions, thisQuestionQuery.questionId)

3: Display the question.


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Akos Fortagh [mailto:akos.fort...@yahoo.com] 
Sent: Thursday, March 29, 2012 4:22 AM
To: cf-talk
Subject: random records no duplicates


hi there, wondering if someone might be able to help with this please.
I have a simple questions table and I'm displaying one randomly generated
question from it at a time. User clicks a button and the page reloads to
give the next question.
So far I have this simple bit working fine:
cfquery name=getquestion datasource=#request.DSN#
  SELECT questions.questionid, questions.questiontext
   FROM questions
/cfquery

cfset displayRow = RandRange(1,getquestion.recordcount)

cfoutput query=getquestion maxrows=1
startrow=#displayRow##questiontext#/cfoutput

What would be the easiest approach to make sure that one question cannot be
delivered twice?
Any help would be greatly appreciated. 



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


RE: Moving CF8 Std to IIS7 Now Get Blank Screen

2012-03-28 Thread Bobby Hartsfield

I have seen blank white pages served up when CF would run out of memory. CF
Exception logs would show outOfMemory errors in those cases. 

Just something else to check.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: Wednesday, March 28, 2012 5:15 PM
To: cf-talk
Subject: RE: Moving CF8 Std to IIS7 Now Get Blank Screen


Except the subject stats Moving CF8 to IIS7...

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



-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Thursday, 29 March 2012 8:13 AM
To: cf-talk
Subject: Re: Moving CF8 Std to IIS7 Now Get Blank Screen


this is not required with CF9.01




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


RE: Local Dev Environment Troubles w/ Virtual Host- CF Builder

2012-03-20 Thread Bobby Hartsfield

Did you add a hosts file entry for 127.0.0.1   myproject.dev so it knows
how to resolve it?

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Dan Kraus [mailto:dskr...@gmail.com] 
Sent: Tuesday, March 20, 2012 8:04 PM
To: cf-talk
Subject: Local Dev Environment Troubles w/ Virtual Host- CF Builder


Hi All, long time reader, first time poster! But I'm beating my head
against the wall here...

I've been developing locally in CFBuilder on Windows 7. When I installed
CFBuilder I used the Built-In Webserver option rather than local IIS or
Apache or something else.

Things have been working fine - I could access my server at
http://localhost:8300, set up databases, and do the typical things one
would expect.

I have a few different projects in the root server each in their own
folder. However, this required browsing to
http://localhost:8300/myProjectFolder but to simulate the production sites,
this couldn't continue. I wanted to set it up so I could do
http://myproject.dev or some variation but the problem is I can't quite
figure out how, or at least how to do it correctly.

In my local server aptly named LocalDev configuration from CFBuilder, I
added a Virtual Host named myproject.dev, Host name, myproject.dev, Port
8300 (same as the server) over http and pointed at my document root which
lives in the cf server root folder. I had a multi-instance install so the
path is C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\myProject

I then right clicked on my project PropertiesColdfusion Server Settings
and selected my server with the virtual host. LocalDev-myproject.dev and
see a Sample Url of http://myproject.dev:8300/

Now it looks like all systems go but when I try to browse there to a basic
txt file right in the root http://myproject.dev:8300/readme.txt

Chrome says Oops! Google Chrome could not connect to myproject.dev:8300
Firefox equivalent is The connection has timed out The server at
myproject.dev is taking too long to respond.

What am I doing wrong!? I'm going nuts over here!

Thanks!




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


RE: Image Crop/Resize Tool

2012-02-25 Thread Bobby Hartsfield

+2000

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: Friday, February 24, 2012 4:28 PM
To: cf-talk
Subject: Re: Image Crop/Resize Tool


Like so? http://cfimagecropper.riaforge.org/

On Fri, Feb 24, 2012 at 3:19 PM, Robert Harrison
rob...@austin-williams.com wrote:

 Does anyone know of a decent utility or CF compatible code that could be
used to help users resize/crop the images they've uploaded.  I know I could
use CFIMAGE to do it, but I'd like to add something to the CMS that let
users see what they are doing before they do it.

 Any ideas on what may be available?

 Thanks
 Robert


 Robert B. Harrison
 Director of Interactive Services
 Austin  Williams
 125 Kennedy Drive, Suite 100
 Hauppauge NY 11788
 P : 631.231.6600 Ext. 119
 F : 631.434.7022
 http://www.austin-williams.com

 Great advertising can't be either/or.  It must be .

 Plug in to our blog: AW Unplugged
 http://www.austin-williams.com/unplugged

 



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


RE: Difference between cfcontent and cfheader in terms its usage?

2012-02-16 Thread Bobby Hartsfield

as the names suggest, cfheader is for creating HTTP response headers and
cfcontent is for sending mime encoded content (generally that of a file).
cfcontent can set the mime content header but it's the only header it sets.

http://cfdocs.org/cfheader

http://cfdocs.org/cfcontent


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com



-Original Message-
From: Jay Pandya [mailto:jaypandy...@gmail.com] 
Sent: Thursday, February 16, 2012 2:01 AM
To: cf-talk
Subject: Difference between cfcontent and cfheader in terms its usage?


Difference between cfcontent and cfheader in terms its usage? 



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


Java Keystore... why is it needed for valid certs?

2012-02-13 Thread Bobby Hartsfield

At work, we have a number of 3rd party vendors that we post to with CFHTTP
calls. Unless we add their certificate to the java keystore, the CFHTTP
connections fail. It wasn't a big deal at first, but the more vendors we
support, the more certificates I add... and the more often a certificate is
expiring.

 

It is to the point where I'm updating one certificate or another every month
or two.

 

My question is why do I have to add these certificates to the keystore at
all? They validate fine in a browser (in fact, that is where I always get
the x.50- certificate from... by exporting it through the browser).

 

This is only an issue for vendors that we have to CFHTTP post to; I do not
need to import certificates to support vendors with web services.

 

Is there a better method that wouldn't require updating the keystore
everytime a certificate is renewed?

 

.:.:.:.:.:.:.:.:.:.:.:.

Bobby Hartsfield

http://acoderslife.com

http://cf4em.com

 




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


RE: Java Keystore... why is it needed for valid certs?

2012-02-13 Thread Bobby Hartsfield

That is more or less what I suspected but wasn't sure. Thanks for the
clarification, Dave.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Monday, February 13, 2012 12:54 PM
To: cf-talk
Subject: Re: Java Keystore... why is it needed for valid certs?


 My question is why do I have to add these certificates to the keystore at
 all? They validate fine in a browser (in fact, that is where I always get
 the x.50- certificate from... by exporting it through the browser).

The reason they validate fine in a browser is because browsers come
with a pretty large set of root certificates. The JVM does not. My
guess is you could import all of the root certificates from your
browser into your JVM if you really wanted to, and not have to worry
about anything for quite a while.

Now, the fact that browsers come with so many trusted certificates is
actually kind of a problem - when someone misuses a CA cert, it can be
hard to ensure that the cert they fraudulently create isn't trusted by
browsers by default. There isn't really a good universal revocation
process.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



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


RE: cfspreadsheet issue when reads dates from spreadsheet

2012-02-07 Thread Bobby Hartsfield

If you are on CF9, you can try using SpreadsheetFormatColumns() to format it
like you want.

something like this (I think) after your cfsrpeeadsheet tag.

cfset spreadSheetFormatColumn(qryResult, {dataformat=mm/dd/yyy}, 1) /

Im assuming DOB is the first column. If that isnt the case, change the last
attribute to the right column number.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Hong Chen [mailto:ho...@cbmiweb.com] 
Sent: Tuesday, February 07, 2012 2:42 PM
To: cf-talk
Subject: cfspreadsheet issue when reads dates from spreadsheet


We use cfspreadsheet  to upload Excel spreadsheet into database, but
having an issue with reading dates. cfspreadsheet only reads last 2 digits
of the year, e.g. the date in the Excel file is 2/2/1999, the
cfspreadsheet reads it as 2/2/99. Below is my code:
cfset strDir=GetDirectoryFromPath(ExpandPath(*.*))  /uploadFile
cffile action=Upload
filefield=InputFile
destination=#strDir#
nameconflict=Overwrite 
mode=757 
cfset destFileName = file.ServerDirectory  \Book1.xls
cfspreadsheet action=read 
src =#destFileName#   
columnnames = name,dob 
query=qryResult
cfdump var=#qryResult#
The query dumped out like this:
query

DOB NAME
1   2/2/99  John 

Anyone can help?
Thanks!



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


RE: SEO Redirection

2012-02-07 Thread Bobby Hartsfield

I think all of those lcase() and LEFT() calls are unnecessary as well.
 
lists aren't known for their performance but in this case, I'd think this
would perform a little better. You would have to compare to see. In either
case, I think your use of lcase() is arbitrary.

cfif Session.EmploymentPartner.ID LT 1 and !listfindnocase('www,beta,dev',
listfirst(cgi.server_name), '.')


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, February 07, 2012 5:26 PM
To: cf-talk
Subject: Re: SEO Redirection


        cfheader statuscode=301 statustext=Moved permanently
        cfheader name=Location
value=http://#subDomain#.#appdatasource#.com#thePage#;
    cfexit

You could replace these three lines with a single CFLOCATION tag. I'm
not sure if that's what's causing your performance problems, but
there's really no reason to do this the way you're doing it.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, 



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


RE: cfspreadsheet issue when reads dates from spreadsheet

2012-02-07 Thread Bobby Hartsfield

Not sure why I was thinking after.


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com] 
Sent: Tuesday, February 07, 2012 5:42 PM
To: cf-talk
Subject: Re: cfspreadsheet issue when reads dates from spreadsheet


 something like this (I think) after your cfsrpeeadsheet tag.
 cfset spreadSheetFormatColumn(qryResult, {dataformat=mm/dd/yyy}, 1) /

 
Yep, essentially. But it needs to be applied before reading the sheet into a
query. 

-Leig



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


RE: [5] RE: cfspreadsheet issue when reads dates from spreadsheet

2012-02-07 Thread Bobby Hartsfield

Sounds like the same solution in both cases unless I'm missing something.


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Hong Chen [mailto:ho...@cbmiweb.com] 
Sent: Tuesday, February 07, 2012 6:47 PM
To: cf-talk
Subject: RE: [5] RE: cfspreadsheet issue when reads dates from spreadsheet


I also have a download function, in there I have formatted the column with
spreadSheetFormatColumn. If I use the downloaded file to upload, it reads 4
digits year. But if I create a new spreadsheet to upload. It only reads the
last 2 digits of year.

-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Tuesday, February 07, 2012 5:59 PM
To: cf-talk
Subject: [5] RE: cfspreadsheet issue when reads dates from spreadsheet


Not sure why I was thinking after.


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Tuesday, February 07, 2012 5:42 PM
To: cf-talk
Subject: Re: cfspreadsheet issue when reads dates from spreadsheet


 something like this (I think) after your cfsrpeeadsheet tag.
 cfset spreadSheetFormatColumn(qryResult, {dataformat=mm/dd/yyy}, 1) /

 
Yep, essentially. But it needs to be applied before reading the sheet into a
query. 

-Leig







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


RE: Best Practice question about database access between Dev and Production Servers

2012-01-28 Thread Bobby Hartsfield

Generally, it is pretty bad practice to copy production data to any other
network. You would most definitely not pass a SaaS 70 audit if they found
that you were doing it. You would also not pass the same audit if they found
that all of your developers had direct access to that data without going
through permission granting hoops.

That said, you may not have a need to worry about it if your data isnt
really that sensitive in the first place. In which case, I think domain
authentication would be the better way to govern the access. When people
leave or contracts expire, the removal of their domain accounts would cover
removing the DB access. Otherwise, you may find yourself managing the
accounts individually for everything or changing the password every time
someone leaves.

Another option, which Russ mentioned, is scrubbing the data before copying
it down to the dev network. Of course, you'd want to do that on the
production network BEFORE copying it down to the other network. I have seen
people do the scrubbing AFTER the move... which is kind of pointless.

Just some things to think about.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Brook Davies [mailto:cft...@logiforms.com] 
Sent: Saturday, January 28, 2012 4:02 PM
To: cf-talk
Subject: Best Practice question about database access between Dev and
Production Servers


Hello,

 

I'm setting up a new environment and I would like to have the ability,
through a web UI to copy objects from our production database (separate
server) to a development/debugging database (separate server). My question
is not about how to implement this but rather whether this is bad practice.
It would involve exposing the production database on the dev server (via a
datasource mapping in the cfadmin).

 

This would mean that any developer that is using our dev server (my concern
is contractors..) would be able to write a query against the production
database and potentially download sensitive data. How to people handle this
type of risk?

 

One idea I had was to not hardcode the database username/password in the
CFadmin and instead prompt for it when accessing this specific tool through
the web UI. Does that sound like a reasonable means of protecting the data
in the production database from developers working on the development
server? 

 

Anybody have better ideas?

 

Brook

 






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


(Job) ColdFusion Programmer

2012-01-27 Thread Bobby June

Where can I find some ColdFusion programmers open for a position in Kansas.

I have a client who is in need of 5 ColdFusion people for full time positions 
offering a base salary of $80-105K base + bonus + full benefits.

If you or anyone you know may be interested please contact me ASAP!

Thank you. 

Bobby June / BeyondTek IT 
Tel: 714-572-1544 x 11 / Fax: 714-982-5094 
Yahoo IM: bobbybeyondtekit
bo...@beyondtekit.com / www.BeyondTekIT.com 
  


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


RE: ORM Compositie Key Help

2012-01-09 Thread Bobby Hartsfield

Noob mistake. I had this.ormsettings.flushAtRequestEnd set to flase in
applicaiton.cfc and was not using ormFlush() after entitySave. I Must have
changed it to false to try an example in John W's book or something.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Sunday, January 08, 2012 8:42 PM
To: cf-talk
Subject: RE: ORM Compositie Key Help


So my issue may not be related to composite keys at all... If I use a
generator of any type other than native, I get the issue of no records. I
created this small example to prove it:


The component: states.cfc

component persistent=true table=tblStates
{
property name=StateId ormtype=string length=33 fieldtype=id
generator=assigned;

property name=stateCode ormtype=string length=2;
property name=stateName ormtype=string length=30;
}



CFM Template to call states component:  statesTest.cfm
==
cfscript
stateCodes = AL,HI,FL,NC,NY,NE,KS;
stateNames = Alabama,Hawaii,Florida,North Carolina,New
York,Nevada,Kansas;

for (i=1; i lte listlen(stateCodes); i=i+1)
{
obj = EntityNew(states);

obj.setStateCode(listgetat(stateCodes, i));
obj.setStateName(listgetat(stateNames, i));
obj.setStateID(obj.getStateCode()  _ 
replace(obj.getStateName(), '[^\w]', '_', 'all'));

entitySave(obj);
}
/cfscript


If I call statesTest.cfm, It will create tblStates as expected, but it will
not put anything in it. 

If I profile the database when I run statesTest.cfm, all queries are
selects... no inserts.


Now... If I change the stateID property in states.cfc to the following:
property name=StateId fieldtype=id generator=native;

...and remove the obj.setStateID() line from statesTest.cfm, it inserts the
records fine.

Any ideas while I still have hair left?

Thanks!


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Sunday, January 08, 2012 3:09 PM
To: cf-talk
Subject: RE: ORM Compositie Key Help


FYI, I did read people saying to set the generator of composite keys to
assigned (even though I'm pretty sure that is the default) so I did try
that but it did not make a difference. 


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Sunday, January 08, 2012 1:40 PM
To: cf-talk
Subject: ORM Compositie Key Help


Hi All,

I'm still playing around with ORM and am finally trying to use it in an
actual project but am running into an issue with composite keys.

Here is a basic compnent that works.


component persistent=true table=tmp_utilities_import
{
property name=stateID fieldtype=id
generator=native;

property name=stateCode   ormtype=stringlength=2;
property name=stateName   ormtype=stringlength=30;

property name=RECORDTIMESTAMP ormtype=timestamp default=;

any function init()
{
variables.recordTimeStamp = now();
}
}


I have an excel doc full of records that I read in and loop over. Using the
above component, I can use the generated setters to set the values and then
use entitySave() to write it to the database.

The problem comes when I try to make stateCode (which is just the two letter
state abbreviation) and stateNamepart of the PK.

I change the above to:


==
component persistent=true table=tmp_utilities_import
{
property name=stateID fieldtype=id generator=native;
property name=stateCode fieldtype=id ormtype=string
length=2;
property name=stateName fieldtype=id ormtype=string
length=30;

property name=RECORDTIMESTAMP ormtype=timestamp default=;

any function init()
{
variables.recordTimeStamp = now();
}
}
==

Then I use the same code to loop over the spreadsheet. There is no error but
it does not write anything to the database either. When I run profiler (this
is SQL Server 2005 by the way), I see the inserts with the first entity but
I only see a bunch of selects with the second.

I drop the table each time I run it so I know its empty to begin with. Both
components create the table as I would expect them to (correct columns,
types and constraints).

I'm sure I'm doing something wrong obviously but I can't seem to find what
that is.

Any ideas here?

Thanks.



.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

ORM Compositie Key Help

2012-01-08 Thread Bobby Hartsfield

Hi All,

I'm still playing around with ORM and am finally trying to use it in an
actual project but am running into an issue with composite keys.

Here is a basic compnent that works.


component persistent=true table=tmp_utilities_import
{
property name=stateID fieldtype=id
generator=native;

property name=stateCode   ormtype=stringlength=2;
property name=stateName   ormtype=stringlength=30;

property name=RECORDTIMESTAMP ormtype=timestamp default=;

any function init()
{
variables.recordTimeStamp = now();
}
}


I have an excel doc full of records that I read in and loop over. Using the
above component, I can use the generated setters to set the values and then
use entitySave() to write it to the database.

The problem comes when I try to make stateCode (which is just the two letter
state abbreviation) and stateNamepart of the PK.

I change the above to:


==
component persistent=true table=tmp_utilities_import
{
property name=stateID fieldtype=id generator=native;
property name=stateCode fieldtype=id ormtype=string
length=2;
property name=stateName fieldtype=id ormtype=string
length=30;

property name=RECORDTIMESTAMP ormtype=timestamp default=;

any function init()
{
variables.recordTimeStamp = now();
}
}
==

Then I use the same code to loop over the spreadsheet. There is no error but
it does not write anything to the database either. When I run profiler (this
is SQL Server 2005 by the way), I see the inserts with the first entity but
I only see a bunch of selects with the second.

I drop the table each time I run it so I know its empty to begin with. Both
components create the table as I would expect them to (correct columns,
types and constraints).

I'm sure I'm doing something wrong obviously but I can't seem to find what
that is.

Any ideas here?

Thanks.



.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com




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


RE: ORM Compositie Key Help

2012-01-08 Thread Bobby Hartsfield

FYI, I did read people saying to set the generator of composite keys to
assigned (even though I'm pretty sure that is the default) so I did try
that but it did not make a difference. 


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Sunday, January 08, 2012 1:40 PM
To: cf-talk
Subject: ORM Compositie Key Help


Hi All,

I'm still playing around with ORM and am finally trying to use it in an
actual project but am running into an issue with composite keys.

Here is a basic compnent that works.


component persistent=true table=tmp_utilities_import
{
property name=stateID fieldtype=id
generator=native;

property name=stateCode   ormtype=stringlength=2;
property name=stateName   ormtype=stringlength=30;

property name=RECORDTIMESTAMP ormtype=timestamp default=;

any function init()
{
variables.recordTimeStamp = now();
}
}


I have an excel doc full of records that I read in and loop over. Using the
above component, I can use the generated setters to set the values and then
use entitySave() to write it to the database.

The problem comes when I try to make stateCode (which is just the two letter
state abbreviation) and stateNamepart of the PK.

I change the above to:


==
component persistent=true table=tmp_utilities_import
{
property name=stateID fieldtype=id generator=native;
property name=stateCode fieldtype=id ormtype=string
length=2;
property name=stateName fieldtype=id ormtype=string
length=30;

property name=RECORDTIMESTAMP ormtype=timestamp default=;

any function init()
{
variables.recordTimeStamp = now();
}
}
==

Then I use the same code to loop over the spreadsheet. There is no error but
it does not write anything to the database either. When I run profiler (this
is SQL Server 2005 by the way), I see the inserts with the first entity but
I only see a bunch of selects with the second.

I drop the table each time I run it so I know its empty to begin with. Both
components create the table as I would expect them to (correct columns,
types and constraints).

I'm sure I'm doing something wrong obviously but I can't seem to find what
that is.

Any ideas here?

Thanks.



.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com






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


RE: ORM Compositie Key Help

2012-01-08 Thread Bobby Hartsfield

So my issue may not be related to composite keys at all... If I use a
generator of any type other than native, I get the issue of no records. I
created this small example to prove it:


The component: states.cfc

component persistent=true table=tblStates
{
property name=StateId ormtype=string length=33 fieldtype=id
generator=assigned;

property name=stateCode ormtype=string length=2;
property name=stateName ormtype=string length=30;
}



CFM Template to call states component:  statesTest.cfm
==
cfscript
stateCodes = AL,HI,FL,NC,NY,NE,KS;
stateNames = Alabama,Hawaii,Florida,North Carolina,New
York,Nevada,Kansas;

for (i=1; i lte listlen(stateCodes); i=i+1)
{
obj = EntityNew(states);

obj.setStateCode(listgetat(stateCodes, i));
obj.setStateName(listgetat(stateNames, i));
obj.setStateID(obj.getStateCode()  _ 
replace(obj.getStateName(), '[^\w]', '_', 'all'));

entitySave(obj);
}
/cfscript


If I call statesTest.cfm, It will create tblStates as expected, but it will
not put anything in it. 

If I profile the database when I run statesTest.cfm, all queries are
selects... no inserts.


Now... If I change the stateID property in states.cfc to the following:
property name=StateId fieldtype=id generator=native;

...and remove the obj.setStateID() line from statesTest.cfm, it inserts the
records fine.

Any ideas while I still have hair left?

Thanks!


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Sunday, January 08, 2012 3:09 PM
To: cf-talk
Subject: RE: ORM Compositie Key Help


FYI, I did read people saying to set the generator of composite keys to
assigned (even though I'm pretty sure that is the default) so I did try
that but it did not make a difference. 


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Sunday, January 08, 2012 1:40 PM
To: cf-talk
Subject: ORM Compositie Key Help


Hi All,

I'm still playing around with ORM and am finally trying to use it in an
actual project but am running into an issue with composite keys.

Here is a basic compnent that works.


component persistent=true table=tmp_utilities_import
{
property name=stateID fieldtype=id
generator=native;

property name=stateCode   ormtype=stringlength=2;
property name=stateName   ormtype=stringlength=30;

property name=RECORDTIMESTAMP ormtype=timestamp default=;

any function init()
{
variables.recordTimeStamp = now();
}
}


I have an excel doc full of records that I read in and loop over. Using the
above component, I can use the generated setters to set the values and then
use entitySave() to write it to the database.

The problem comes when I try to make stateCode (which is just the two letter
state abbreviation) and stateNamepart of the PK.

I change the above to:


==
component persistent=true table=tmp_utilities_import
{
property name=stateID fieldtype=id generator=native;
property name=stateCode fieldtype=id ormtype=string
length=2;
property name=stateName fieldtype=id ormtype=string
length=30;

property name=RECORDTIMESTAMP ormtype=timestamp default=;

any function init()
{
variables.recordTimeStamp = now();
}
}
==

Then I use the same code to loop over the spreadsheet. There is no error but
it does not write anything to the database either. When I run profiler (this
is SQL Server 2005 by the way), I see the inserts with the first entity but
I only see a bunch of selects with the second.

I drop the table each time I run it so I know its empty to begin with. Both
components create the table as I would expect them to (correct columns,
types and constraints).

I'm sure I'm doing something wrong obviously but I can't seem to find what
that is.

Any ideas here?

Thanks.



.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com








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


RE: StructDelete inside cfc

2012-01-06 Thread Bobby Hartsfield

I'd imagine that it isn't the structDelete line but the CFSET line for
recipient_id since the line just above it has an extra quote.

cfset var qrySurveyInfo =  /

Try making that: cfset var qrySurveyInfo =  /


.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Shannon Rhodes [mailto:shan...@rhodesedge.com] 
Sent: Friday, January 06, 2012 3:51 PM
To: cf-talk
Subject: StructDelete inside cfc


I'm trying to process dynamic form fields in a function.  The first thing I
need is to grab a value that I need for saving the data to the right user.
If for some reason the value isn't there, I want to halt processing; else I
want to remove the value from the structure so I can loop over the rest of
the form scope and insert all numeric values.  For some reason, it errors at
the StructDelete line. This is CF8 if that matters.

Error:  Invalid CFML construct found on line 144 at column 68.  
ColdFusion was looking at the following text:
recipient_id

The CFML compiler was processing:

A cfset tag beginning on line 140, column 10.
 
Beginning of function:


cffunction name=processSurvey returntype=boolean output=false
hint=Takes the form structure and processes the completed form.  Returns
boolean indicating whether insert was successful
cfargument name=FormStucture required=yes type=struct/
cfset var processSuccess = false /
cfset var RKeyExists = false /
cfset var insertText = false /
cfset var qrySurveyInfo =  /
cfset var recipient_id = arguments.FormStructure.recipient_id /

!--- saved to local var, delete from struct; error if it isn't
there ---  
cfset RKeyExists = StructDelete(arguments.FormStructure,
recipient_id, true)

cfif StructIsEmpty(arguments.FormStructure) or NOT RKeyExists
cfexit
/cfif 



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


RE: list of running cfthreads

2011-12-29 Thread Bobby Hartsfield

Jconsole as well.



.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Bryan Stevenson [mailto:br...@electricedgesystems.com] 
Sent: Thursday, December 29, 2011 8:07 PM
To: cf-talk
Subject: Re: list of running cfthreads


Things like SeeFusion and other dashboards doand doesn't CF 9 have
something like that bundled in CF Admin??

...been a while since I was thread hunting ;-)

On Thu, 2011-12-29 at 19:47 -0500, Michael Dinowitz wrote:

 Is there a way to view the threads created with cfthread. How many are
 in the queue, how long they've been waiting, etc.
 
 Thanks


-- 


Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: br...@electricedgesystems.com
web: www.electricedgesystems.com
 
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.
Please consider the environment before printing this e-mail





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


RE: fresh cf 9 install can't see administrator

2011-12-13 Thread Bobby Hartsfield

Is /cfide/ in the root of your website? If not, setup a virtual directory to
put it there.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Mr. Chedder P. Slam [mailto:chedders...@gmail.com] 
Sent: Tuesday, December 13, 2011 12:14 PM
To: cf-talk
Subject: fresh cf 9 install can't see administrator


http://192.168.1.10/CFIDE/administrator/index.cfm

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for 
debugging purposes.
Error Occurred While Processing Request


  File not found: /CFIDE/administrator/index.cfm



apache running on VM to wwwroot in host machine

cf service running as local system account, but wwwroot has everyone 
full access

http://192.168.1.10/

serves index.html properly, but index.cfm gives the same error

i'm thinking permissions, but not sure how...

any help?




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


RE: TOT - Forwarding port 80 to two machines with a home Router -- Linksys WRT54GL

2011-12-11 Thread Bobby Hartsfield

The chances of bricking the router are pretty low. You'd pretty much have to
lose power in the middle of the actual flash (doesn't mean it has never
happened). I've installed DD-WRT on just about every linksys router I've had
(including two WRT54GL routers). Currently, I'm running it on a WRT610N. 

Installing DD-WRT is the first thing I do to a new Cisco/Linksys home router
when I take it out of the box. I think you'll much prefer the control it
gives you over your equipment.

Another option is to throw together a cheap linux box and install a
firewall/router distro like ipcop, ipfire, brazilfw.. (and many others). You
could also run a normal distro and use something like firewall builder to
make it a firewall/router.

The benefit of moving up to a linux distro from DD-WRT is even more control
and the ability to install many different packages (like a proxy server)

ipfire is an iptables based firewall distro (forked from ipcop and debian
based)... it has a TON of addons all tested and ready to be installed right
from the web interface. 

Add-ons list: http://wiki.ipfire.org/en/addons/start

these distros are tiny and typically run on anything you have laying around.
Some of them are small enough to fit on a single floppy disk and run
entirely from RAM.

So that's my linux firewall spiel.

Cheers

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: Sunday, December 11, 2011 3:07 PM
To: cf-talk
Subject: Re: TOT - Forwarding port 80 to two machines with a home Router --
Linksys WRT54GL


Than you all for your response. I tried  reverse proxy ala mod proxy and
that works. Sort of. If the site uses URLs that includes the host name. One
of the apps that I use a lot, Word press, uses the host name in the URL..
and the whole reverse proxy thing goes down the shi... err  drain. That and
Trac throws a fit when I try to authenticate while going through the proxy

I am aware of the Linux firmware for the router, but I was hoping there was
another way to do this for fear of bricking it.

Thanx
G!

On Sun, Dec 11, 2011 at 11:29 AM, Eric Roberts 
ow...@threeravensconsulting.com wrote:


 Look into the DD-WRT firmware for that router...it basically turns in into
 a
 linux box as Jochem was talking about...

 -Original Message-
 From: Jochem van Dieten [mailto:joch...@gmail.com]
 Sent: Sunday, December 11, 2011 5:26 AM
 To: cf-talk
 Subject: Re: TOT - Forwarding port 80 to two machines with a home Router
--
 Linksys WRT54GL


 On Sat, Dec 10, 2011 at 4:06 AM, Gerald Guido wrote:
  I have two servers @ home that I want to use for hosting hobby sites.
  One runs Win 08 server and the other Linux (CentOS). My router (
  Linksys
  WRT54GL) does port forwarding but I want to have port 80 point to both
  machines based on the domain.

 Did you upgrade your router to run an open souce Linux or are you running
 the original Linksys firmware?

 Jochem


 --
 Jochem van Dieten
 http://jochem.vandieten.net/



 



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


RE: TOT - Forwarding port 80 to two machines with a home Router -- Linksys WRT54GL

2011-12-11 Thread Bobby Hartsfield

It really is easier than the docs make it seem... download the right files,
flash it, done.

I only use the smaller store bough routers for access points or for DMZs at
home. My modem always plugs into a linux box of one type or another.

I envy the fun you are about to have discovering firewall distros.

Enjoy.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: Sunday, December 11, 2011 5:09 PM
To: cf-talk
Subject: Re: TOT - Forwarding port 80 to two machines with a home Router --
Linksys WRT54GL


Another option is to throw together a cheap linux box and install a
firewall/router distro like ipcop, ipfire, brazilfw..

SWEET. Thanx Bobby! That was just what I was looking for. I would be *much*
more inclined to set up a Linux box than start hacking my router. I am sure
the DD-WRT/router method would work fine and I would soon be singing it's
praises. However, I was looking at the *lengthy* install docs with a bunch
of bright red WARNING messages scattered about and I was thinking:
Do I really want to get involved with this?

Thanx again,
G!


On Sun, Dec 11, 2011 at 4:01 PM, Bobby Hartsfield
bo...@acoderslife.comwrote:


 The chances of bricking the router are pretty low. You'd pretty much have
 to
 lose power in the middle of the actual flash (doesn't mean it has never
 happened). I've installed DD-WRT on just about every linksys router I've
 had
 (including two WRT54GL routers). Currently, I'm running it on a WRT610N.

 Installing DD-WRT is the first thing I do to a new Cisco/Linksys home
 router
 when I take it out of the box. I think you'll much prefer the control it
 gives you over your equipment.

 Another option is to throw together a cheap linux box and install a
 firewall/router distro like ipcop, ipfire, brazilfw.. (and many others).
 You
 could also run a normal distro and use something like firewall builder to
 make it a firewall/router.

 The benefit of moving up to a linux distro from DD-WRT is even more
control
 and the ability to install many different packages (like a proxy server)

 ipfire is an iptables based firewall distro (forked from ipcop and debian
 based)... it has a TON of addons all tested and ready to be installed
right
 from the web interface.

 Add-ons list: http://wiki.ipfire.org/en/addons/start

 these distros are tiny and typically run on anything you have laying
 around.
 Some of them are small enough to fit on a single floppy disk and run
 entirely from RAM.

 So that's my linux firewall spiel.

 Cheers

 .:.:.:.:.:.:.:.:.:.:.:.
 Bobby Hartsfield
 http://acoderslife.com
 http://cf4em.com


 -Original Message-
 From: Gerald Guido [mailto:gerald.gu...@gmail.com]
 Sent: Sunday, December 11, 2011 3:07 PM
 To: cf-talk
 Subject: Re: TOT - Forwarding port 80 to two machines with a home Router
--
 Linksys WRT54GL


 Than you all for your response. I tried  reverse proxy ala mod proxy and
 that works. Sort of. If the site uses URLs that includes the host name.
One
 of the apps that I use a lot, Word press, uses the host name in the URL..
 and the whole reverse proxy thing goes down the shi... err  drain. That
and
 Trac throws a fit when I try to authenticate while going through the proxy

 I am aware of the Linux firmware for the router, but I was hoping there
was
 another way to do this for fear of bricking it.

 Thanx
 G!

 On Sun, Dec 11, 2011 at 11:29 AM, Eric Roberts 
 ow...@threeravensconsulting.com wrote:

 
  Look into the DD-WRT firmware for that router...it basically turns in
 into
  a
  linux box as Jochem was talking about...
 
  -Original Message-
  From: Jochem van Dieten [mailto:joch...@gmail.com]
  Sent: Sunday, December 11, 2011 5:26 AM
  To: cf-talk
  Subject: Re: TOT - Forwarding port 80 to two machines with a home Router
 --
  Linksys WRT54GL
 
 
  On Sat, Dec 10, 2011 at 4:06 AM, Gerald Guido wrote:
   I have two servers @ home that I want to use for hosting hobby sites.
   One runs Win 08 server and the other Linux (CentOS). My router (
   Linksys
   WRT54GL) does port forwarding but I want to have port 80 point to both
   machines based on the domain.
 
  Did you upgrade your router to run an open souce Linux or are you
running
  the original Linksys firmware?
 
  Jochem
 
 
  --
  Jochem van Dieten
  http://jochem.vandieten.net/
 
 
 
 



 



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


RE: Is CFMAIL reliable??

2011-12-05 Thread Bobby Hartsfield

I can only say I've not ran into any issues with the spool needing to be
kick started and we send ridiculous amounts of email all day from about 20
different CF 8.01 enterprise servers... all via cfmail.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com



-Original Message-
From: Brook Davies [mailto:cft...@logiforms.com] 
Sent: Monday, December 05, 2011 9:06 PM
To: cf-talk
Subject: Is CFMAIL reliable??


Hi Guys (and girls),

 

You may notice a trend in my postings! Moving away from infusion (long over
due) and looking at Native CF functions instead. So now I am looking at
CFMAIL and in the past know it has been a bit dodgy. There is a conversation
here about restarting the spooling service:

 

http://www.mail-archive.com/cf-talk@houseoffusion.com/msg342750.html

 

And Ben Nadel talks about monitoring the undeliverable folder and how the
spooler just occasionally stops working. 

http://www.bennadel.com/blog/1893-Monitoring-The-ColdFusion-Mail-Server-With
-GMail-And-A-Scheduled-Task.htm

 

The comments attest to this being an issue for a lot of people. So I guess
the question is, has this been resolved or is it necessary  to implement all
of these hacks to keep CFMAIL running well?

 

Brook






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


ORM/Hibernate generator issue

2011-12-03 Thread Bobby Hartsfield

I've finally been playing around with ORM lately and I've hit an issue that
I'm having a hard time finding answers for on Google. Hopefully someone here
knows what the deal.

 

Below is a very basic person app with one component (outside of app.cfc)
and a small index.cfm

 

The error I'm seeing is:

this id generator generates long, integer, short

Root cause :org.hibernate.id.IdentifierGenerationException: this id
generator generates long, integer, short

 

Basically, I read a xls doc of first and last names and (attempt to) load it
into a tblPeople table.

 

The above error happens in inde.cfm when entitySave(obj) is triggered. I can
comment out  entitySave(obj); and not get any errors.

 

There are only about 3000 records in people.xls and tblPeople doesn't exist
yet.

 

It is a new, basic install of CF9 on server 2003.

 

This worked earlier but I was using the old style cfcomponent / tags in
person.cfc

 

hopefully I'm just missing something obvious to someone else.

 

Any help appreciated here.

 

Thanks

 

---INDEX.CFM

 

cfset ormReload() /

cfspreadsheet action=read src=#expandPath('.')#\people.xls
query=sheet headerrow=1 /

 

cfloop query=sheet startrow=2

cfscript

obj = EntityNew(person);

 

obj.setPersonFname(sheet[personFname][sheet.currentRow]);

obj.setPersonLname(sheet[personLname][sheet.currentRow]);

 

entitySave(obj);

/cfscript

/cfloop

 

 

 

 

---PERSON.CFC

component persistent=true table=tblpeople

{

property name=personId fieldtype=id
generator=increment;

property name=personFname;

property name=personLname;

}

 

 

 

 

 

 

---APPLICATION.CFC

component

{

this.name = personTest;

 

this.ormenabled = true;

this.datasource = peopleTest;

this.ormsettings={dbcreate=update, logsql=true};

this.ormsettings.savemapping = false;

 

this.clientmanagement=false;

this.sessionmanagement=true;

this.sessiontimeout=#createtimespan(0,0,1,0)#;

this.applicationtimeout=#createtimespan(0,0,1,0)#;

}

 

 

.:.:.:.:.:.:.:.:.:.:.:.

Bobby Hartsfield

http://acoderslife.com

http://cf4em.com

 




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


RE: ORM/Hibernate generator issue

2011-12-03 Thread Bobby Hartsfield

Thanks Matt. I swear I did try that earlier but I just tried it again to
make sure I didn't typo it or something earlier and it got past the error.

Today has been one long caching nightmare.

Thanks!

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Saturday, December 03, 2011 10:15 PM
To: cf-talk
Subject: Re: ORM/Hibernate generator issue


Try setting generator=native instead.
On Dec 3, 2011 9:10 PM, Bobby Hartsfield bo...@acoderslife.com wrote:


 I've finally been playing around with ORM lately and I've hit an issue
that
 I'm having a hard time finding answers for on Google. Hopefully someone
 here
 knows what the deal.



 Below is a very basic person app with one component (outside of app.cfc)
 and a small index.cfm



 The error I'm seeing is:

 this id generator generates long, integer, short

 Root cause :org.hibernate.id.IdentifierGenerationException: this id
 generator generates long, integer, short



 Basically, I read a xls doc of first and last names and (attempt to) load
 it
 into a tblPeople table.



 The above error happens in inde.cfm when entitySave(obj) is triggered. I
 can
 comment out  entitySave(obj); and not get any errors.



 There are only about 3000 records in people.xls and tblPeople doesn't
exist
 yet.



 It is a new, basic install of CF9 on server 2003.



 This worked earlier but I was using the old style cfcomponent / tags in
 person.cfc



 hopefully I'm just missing something obvious to someone else.



 Any help appreciated here.



 Thanks



 ---INDEX.CFM



 cfset ormReload() /

 cfspreadsheet action=read src=#expandPath('.')#\people.xls
 query=sheet headerrow=1 /



 cfloop query=sheet startrow=2

 cfscript

obj = EntityNew(person);



obj.setPersonFname(sheet[personFname][sheet.currentRow]);

obj.setPersonLname(sheet[personLname][sheet.currentRow]);



entitySave(obj);

 /cfscript

 /cfloop









 ---PERSON.CFC

 component persistent=true table=tblpeople

 {

property name=personId fieldtype=id
 generator=increment;

property name=personFname;

property name=personLname;

 }













 ---APPLICATION.CFC

 component

 {

this.name = personTest;



this.ormenabled = true;

this.datasource = peopleTest;

this.ormsettings={dbcreate=update, logsql=true};

this.ormsettings.savemapping = false;



this.clientmanagement=false;

this.sessionmanagement=true;

this.sessiontimeout=#createtimespan(0,0,1,0)#;

this.applicationtimeout=#createtimespan(0,0,1,0)#;

 }





 .:.:.:.:.:.:.:.:.:.:.:.

 Bobby Hartsfield

 http://acoderslife.com

 http://cf4em.com






 



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


RE: Printing barcodes

2011-11-11 Thread Bobby Hartsfield

Thanks for pointing out your own solution. I hope to play around with
barcodes soon.

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Keith McGee [mailto:kpmc...@frontiernet.net] 
Sent: Friday, November 11, 2011 2:15 PM
To: cf-talk
Subject: Re: Printing barcodes


Found the solution

http://kb2.adobe.com/cps/405/kb405588.html




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


RE: HouseOfFusion is down (was: CF8 cftextarea richtext is stealing form focus, and being referred to by the form

2011-11-02 Thread Bobby Hartsfield

 Yes, but luckily the mailing list is handled by a different server 
 so anyone using regular email is still able to send/reply to the list.

AKA... all the REAL users. :-p

.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Sean Corfield [mailto:seancorfi...@gmail.com] 
Sent: Wednesday, November 02, 2011 2:38 PM
To: cf-talk
Subject: HouseOfFusion is down (was: CF8 cftextarea richtext is stealing
form focus, and being referred to by the form


On Wed, Nov 2, 2011 at 11:21 AM, Monique Boea moniqueb...@gmail.com wrote:
 is houseoffusion.com down?

Yes, but luckily the mailing list is handled by a different server so
anyone using regular email is still able to send/reply to the list.
-- 
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/
World Singles, LLC. -- http://worldsingles.com/

Perfection is the enemy of the good.
-- Gustave Flaubert, French realist novelist (1821-1880)



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


RE: Hiding email address from spiders

2011-10-13 Thread Bobby Hartsfield

I've been doing that one for years (and offered it as potential solution
here a few times). Hiding it by CSS or JS is the key.

Typically, I put the normal text field and some text next to it like dont
fill in this field in a single div then use CSS and/or JS to hide it from
real people.

It has worked well for me in the past.


.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com




-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: Thursday, October 13, 2011 8:58 AM
To: cf-talk
Subject: RE: Hiding email address from spiders


I can't find a reference on www.meetup.com/coldfusionmeetup
to the archived presentation, but the basic idea is this:

Add a hidden form field that a user can't see, and therefore,
won't fill in, and use it to trap a bot/spider.

The bot doesn't realize the field is hidden and puts something
in it.  Check the field when the form is submitted for the
presence of a value in the field.  If there's a value in the
hidden field, don't process the form.

I love the idea and hope it works well.  I'm going to implement
it and see how it goes.

Anyone have any experience with this highly efficient,
user-friendly method?



-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Thursday, October 13, 2011 8:32 AM
To: cf-talk
Subject: Re: Hiding email address from spiders


 How about the honeypot method that was presented
on CFMeetup a few months ago?

Never heard of it. Any reference ?





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


RE: Hiding email address from spiders

2011-10-13 Thread Bobby Hartsfield

The onclick sounds pretty cool. I never thought to do it like that.


.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com





-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Thursday, October 13, 2011 9:08 AM
To: cf-talk
Subject: Re: Hiding email address from spiders


 The bot doesn't realize the field is hidden and puts something
in it.  Check the field when the form is submitted for the
presence of a value in the field.

OK, I see. But there is no guaranty the bot will fill the field.
I prefer the reverse : add a field in a onclick event and check for the
presence of the field.
This is 100% sure.

I've also read about the Honey Pot project.
IMO, its weakness is that it mostly rely on list of IP addresses.
This is not sure enough, mainly because
1º IP addreses may be spoofed
2º many bots are actually ordinary user browsers hosting some worms
therefore they can attack from any legitimate IP adresses.



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


RE: Shouldn't these statements work?

2011-10-13 Thread Bobby Hartsfield

Say goodbye to your thread Rick. :-/


.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com




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


RE: Shouldn't these statements work?

2011-10-13 Thread Bobby Hartsfield

Now I owe Dave $1. He bet me that he could get you to admit truthiness was
a word... crap!


.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com





-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Thursday, October 13, 2011 6:59 PM
To: cf-talk
Subject: Re: Shouldn't these statements work?


I can only imagine what a game of scrabble must be like at your house.

In the interest of moving forward and freeing up my spare time I'll concede
to you that truthiness is a word. (Even though the red squiggle under the
word right now seems to be mocking me.) 

We'll have to agree to disagree as to whether or not using it in a
presentation would make you look a fool. 

MG 



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


RE: Hiding email address from spiders

2011-10-08 Thread Bobby Hartsfield

Here is a quick mod of the original. Just pass in the entire text block and
it takes care of the rest.

What it is doing is using rematch() to return an array of all email
addresses that it finds in the given string. 

It then loops over that array of email addresses, replacing all occurrences
in the given string, with the ascii encoded equivalent (the inner loop is
what I sent last time).

cfscript
function disguiseEmails(str){

var emailArr =
rematch(([[:alnum:]_\.\-]+@([[:alnum:]_\.\-]+\.)+(museum|travel|[[:alpha:]]
{2,4})), str);
var thisEmailAddr = ;
var i = 1;
var ii = 1;

for (i=1; i = arraylen(emailArr); i++)
{
for (ii=1; ii = len(emailArr[i]); ii++)
{
thisEmailAddr = thisEmailAddr  ## 
asc(mid(emailArr[i], ii, 1));
}
str = replace(str, emailArr[i], thisEmailAddr,
'all');
}   

return str;
}
/cfscript



.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com





-Original Message-
From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] 
Sent: Saturday, October 08, 2011 5:40 AM
To: cf-talk
Subject: RE: Hiding email address from spiders


Thanks, Bobby, exactly along the lines I am thinking.

The mail address for me has no mailto:, it's just contained in a string.
I'm wondering if I'll have to check the whole string for the existance of an
email address by looping through each word, or if there is an
easier/faster way?

For example, this code would find the string.  However, I don't know if I
can use a regular expression, for example, to rereplace the string with
ascii?  (Never used regex before...)

Or could I use a regular expression to search AND replace the email address
with ascii on the whole string, which would be a lot faster?

cfset mystring = this is the email address myaddr...@home.com that I use
cfset mynewString = 
cfoutput
cfloop from=1 to=#listlen(mystring,  )# index=I
cfif  isvalid(email, listgetat(mystring, I,  ))
!--- now set this to ascii ---
#listgetat(mystring, I,  )#br
cfelse
cfset mynewString = #mynewString# #listgetat(mystring, I,  )#
/cfif
/cfloop
#mynewString#
/cfoutput


Jenny Gavin-Wear
Fast Track Online
Tel: 01262 602013
http://www.fasttrackonline.co.uk/


-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: 08 October 2011 04:09
To: cf-talk
Subject: RE: Hiding email address from spiders



Here is a page with an example of the source:

http://cf4em.com/cf4em/index.cfm?mainaction=postsforumid=2threadid=63

The last post has my email address in the last sentence. This is what the
source of that mailto link looks like:

a
href=#109#97#105#108#116#111#58#98#111#98#98#121#64
#99#102#
52#101#109#46#99#111#109#98#111#98#98#121#64#99#10
2#52#101
#109#46#99#111#109/a


.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com




--
I am using the free version of SPAMfighter.
We are a community of 7 million users fighting spam.
SPAMfighter has removed 4302 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

The Professional version does not have this message






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


RE: Hiding email address from spiders

2011-10-08 Thread Bobby Hartsfield

Yep. Definitely not 100% (nor are images .. especially if you want them
linked). I'd imagine most bots aren't going to bother with either though.

I'd have to agree that non-linked images of the email text is less likely to
be deciphered by a bot than ascii equivalents. No doubt.

In all honesty though, if someone submits some text to their own site that
they know is going to be displayed and it has email addresses in it, they
probably don't care much about the subject.

.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com



-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Saturday, October 08, 2011 8:34 AM
To: cf-talk
Subject: Re: Hiding email address from spiders


This may be academic, but be aware that this method isn't actually hiding
the address, simply ascii encoding it. It wouldn't surprise me in the least
if spider don't already evaluate ascii.

I stand by my statement that the most effective (though not elegant) is to
replace addy's with images. The likelihood of a spider also doing character
recognition is much less

Carry on.

On Sat, Oct 8, 2011 at 5:39 AM, Jenny Gavin-Wear 
jenn...@fasttrackonline.co.uk wrote:


 Thanks, Bobby, exactly along the lines I am thinking.

 The mail address for me has no mailto:, it's just contained in a string.
 I'm wondering if I'll have to check the whole string for the existance of
 an
 email address by looping through each word, or if there is an
 easier/faster way?

 For example, this code would find the string.  However, I don't know if I
 can use a regular expression, for example, to rereplace the string with
 ascii?  (Never used regex before...)

 Or could I use a regular expression to search AND replace the email
address
 with ascii on the whole string, which would be a lot faster?

 cfset mystring = this is the email address myaddr...@home.com that I
 use
 cfset mynewString = 
 cfoutput
 cfloop from=1 to=#listlen(mystring,  )# index=I
 cfif  isvalid(email, listgetat(mystring, I,  ))
 !--- now set this to ascii ---
 #listgetat(mystring, I,  )#br
 cfelse
 cfset mynewString = #mynewString# #listgetat(mystring, I,  )#
 /cfif
 /cfloop
 #mynewString#
 /cfoutput


 Jenny Gavin-Wear
 Fast Track Online
 Tel: 01262 602013
 http://www.fasttrackonline.co.uk/


 -Original Message-
 From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
 Sent: 08 October 2011 04:09
 To: cf-talk
 Subject: RE: Hiding email address from spiders
 
 
 
 Here is a page with an example of the source:
 
 http://cf4em.com/cf4em/index.cfm?mainaction=postsforumid=2threadid=63
 
 The last post has my email address in the last sentence. This is what
the
 source of that mailto link looks like:
 
 a
 href=#109#97#105#108#116#111#58#98#111#98#98#121#64
 #99#102#
 52#101#109#46#99#111#109#98#111#98#98#121#64#99#10
 2#52#101
 #109#46#99#111#109/a
 
 
 .:.:.:.:.:.:.:.:.:.:.:.:.
 Bobby Hartsfield
 http://acoderslife.com
 http://cf4em.com
 
 


 --
 I am using the free version of SPAMfighter.
 We are a community of 7 million users fighting spam.
 SPAMfighter has removed 4302 of my spam emails to date.
 Get the free SPAMfighter here: http://www.spamfighter.com/len

 The Professional version does not have this message




 



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


RE: Hiding email address from spiders

2011-10-08 Thread Bobby Hartsfield

In which case ascii encoding would make them feel better about themselves
because they don't know any better. ;-)

.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com





-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Saturday, October 08, 2011 10:40 AM
To: cf-talk
Subject: Re: Hiding email address from spiders


  if someone submits some text to their own site that
they know is going to be displayed and it has email addresses in it, they
probably don't care much about the subject.

May be they do care, but they just don't know how to hide their address.
And there are also all those who do care and do not put addresses
because they cannot hide them.



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


RE: MXUnit - Fail a success

2011-10-08 Thread Bobby Hartsfield

Yeah, A couple of us were quite sure what I had should work and were
surprised when it didn't. 

Your example looks like a winner to get the test working like it needs to
though!


.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com





-Original Message-
From: Dominic Watson [mailto:watson.domi...@googlemail.com] 
Sent: Saturday, October 08, 2011 10:54 AM
To: cf-talk
Subject: Re: MXUnit - Fail a success


While I'm not sure why the test is not failing, I've done this before with:

var failed = false;

try {
 doSomething();
} catch( someError e ) {
 failed = true;
}

Assert(failed);

Your method is more elegant I think, would be interesting to see why
it isn't working.

Dominic

On 8 October 2011 00:27, Bobby Hartsfield bo...@acoderslife.com wrote:

 Thanks Matt. I did see that list but figured people here were likely users
 of MXUnit and gave it a shot.

 I'll resort to the google group if all else fails.

 Thanks again.

 .:.:.:.:.:.:.:.:.:.:.:.:.
 Bobby Hartsfield
 http://acoderslife.com
 http://cf4em.com




 -Original Message-
 From: Matt Quackenbush [mailto:quackfu...@gmail.com]
 Sent: Friday, October 07, 2011 3:20 PM
 To: cf-talk
 Subject: Re: MXUnit - Fail a success


 I'm not certain the answer to your question, but wanted to make sure you
 know about the MXUnit list.  I suspect you might have better luck getting
an
 answer over there.

 http://groups.google.com/group/mxunit

 (I would have also expected the test to fail, based upon what you've
 posted.)


 On Fri, Oct 7, 2011 at 2:13 PM, Bobby Hartsfield
 bo...@acoderslife.comwrote:


 Sounds like an odd request right? lol

 So I have a method that I have written some unit tests for. What I want
to
 add is a test that tests missing arguments. There are two arguments in my
 method and both are required so I wanted a test for passing no arguments.

 This is what I tried:



                try

                {

                                local.result =
 instance.myService.meyMethod();

                                fail();

                }

                catch(Application e) { }





 The above test passed. I THOUGHT the fail() was going to ensure that if
 anyone came along and made the arguments not required that the test would
 fail but the catch appears to be catching that as well...

 For instance, I tried this.





                try

                {

                                local.result = 1;

                                fail();

                }

                catch(Application e) { }





 That test still passes...



 What I also thought was odd was that the exception type thrown by calling
 my
 method with no arguments was not the missingArgument type, it was
 application. I'm assuming that application type is simply catching
 whatever
 fail () is doing as well as my missing argument error and there for
 hitting
 the catch.



 Does anyone know a solution to make this work as expected?



 I am on CF 8.0.1 by the way and running mxUnit 2.0.3



 Thanks.





 .:.:.:.:.:.:.:.:.:.:.:.:.

 Bobby Hartsfield

 http://acoderslife.com

 http://cf4em.com
















 



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


  1   2   3   4   5   6   7   8   9   10   >