RE: CFCs and cftry/cfcatch

2005-10-13 Thread Andy
Are you sure an error is being thrown?  I recommend you comment all code out
betweent the CFTRY and CFCatch  and add a CFTHROW to force a specific
error type.   

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 12, 2005 9:26 PM
To: CF-Talk
Subject: Re: CFCs and cftry/cfcatch

exactly what I'm doing Kenand I think I have it all working now (didn't
have cfreturn as part of my catchtry when the remote machine connection is
restored)DOH!

I'm having one of thse days today ;-)

Cheers

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: [EMAIL PROTECTED]
web: www.electricedgesystems.com 




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220873
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: javax.mail.SendFailedException: 550 5.7.1

2005-10-13 Thread Paul Vernon
This is probably a permissions issue or the relay settings on you mail
server not including the IP of your CF server.

Either you need to supply a username and password to the CF server in the
CFMAIL admin area to authenticate with your mail server or you need to set
up your mail server to let CF relay through it without authenticating.

Paul


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220874
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFAJAX return types docco

2005-10-13 Thread James Holmes
OK I've dug through the many examples and finally discovered the
relatively simple structure that represents a query.

Is anyone interested in me compiling the info on CFAJAX return types
in a quick reference doc and posting/blogging it?

On 10/5/05, James Holmes [EMAIL PROTECTED] wrote:
 Does anyone have a simple docco for the JS objects returned by CFAJAX
 for the corresponding CF types? I have arrays worked out (a
 no-brainer) but I haven't looked at, for example, what queries come
 back as.

 If soemone can save me reinventing the wheel, please let me know.



--
Geeque - accept the geek within and get your friends off your back -
http://www.cafepress.com/geeque/

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220875
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Loop through a structure of structures

2005-10-13 Thread Andy McShane
Nice  tidy Alex, thanks, I'll use this. :-)

-Original Message-
From: Alexander Sherwood [mailto:[EMAIL PROTECTED] 
Sent: 12 October 2005 20:05
To: CF-Talk
Subject: Re: Loop through a structure of structures

Try this:

[CFLOOP collection=RSStructure item=itm]

[cfset thisQuery  =RSStructure[itm]]

[cfoutput query =thisQuery]

   .. query output code here

[/cfoutput]

[/CFLOOP]

Hope this helps.

--
Alex





Andy Mcshane wrote:

Hi all, I think I have been looking at this for too long and cannot figure
out how to loop through and output a structure of query results.

I have a CFC that will return multiple recordsets. I figured that the only
way that I could return multiple recordsets from a CFC was to return them
within a structure. My query runs inside my CFC and returns 17 individual
recordsets. I create a structure and add each of these recordsets to it so
my structure now looks like this;

RSStructure
RS1   query - Rows 2
AGE   ID   NAME
  1  221   Wibble
  2  212   Wobble
RS2   query - Rows 3
AGE   ID   NAME
  1  223   Wibble
  2  214   Wobble
  3  305   Woo
RS3   query - Rows 3
AGE   ID   NAME
  1  346   Wibble
  2  237   Wobble
  3  338   Woo

This continues until I have 17 recordsets within my structure. I then
return this structure to my calling page. Now I must be having a really
brain dead day because for the life of me I cannot remeber how to reference
each of my recordsets within this structure so that I can output the data,
it must be simple but then again so must I be at the moment! Can anybody
help this flagging programmer?






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220876
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFC Lifecycle

2005-10-13 Thread Andy Mcshane
Just a quick question to help clear, hopefully, the last of the muddy waters 
with regards to how CFC's work. 

A CFC that is initialized and stored within the application/session scope is 
then available to use everywhere as required.

Now I just want clarification on CFC's created at page level. If I create an 
instance of a CFC on my page, carry out some processing and then do cflocate to 
another page am I correct in assuming that my CFC instance is now gone and if I 
wish to re-use it I must create another instance of it? I am just a little 
confused on the whole lifecycle bit of CFC's, can anyone provide some clarity?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220877
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT: HTML Combo Boxes

2005-10-13 Thread Robertson-Ravo, Neil (RX)
Hey Aaaron, what is it you want to achieve?




-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED] 
Sent: 12 October 2005 21:32
To: CF-Talk
Subject: Re: OT: HTML Combo Boxes

I implimented it earlier with IE 6 and ran into no JS errors. We did just
decide we need more of an auto-fill on a text input kind of like how
Google does things in gmail. So back to searching to see what I can find for
that.

On 10/12/05, Paul [EMAIL PROTECTED] wrote:

  Nevermind, I think this one will do what I need done.
  http://shaunwagner.com/projects/js/comboBox.html

 Looks like this one has a JS error on Windows IE6?



 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220878
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: SQL issue: filter query

2005-10-13 Thread Robertson-Ravo, Neil (RX)
select * from getList
where [someuniqueIDingetlist] NOT IN (
select [someuniqueIDinJudges]  from Judges
)
Where getList,id = [yourid]

I am not sure on your column structs but you sure as hell don't need 3
queries, it can all be done in 1.





-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED] 
Sent: 13 October 2005 03:22
To: CF-Talk
Subject: SQL issue: filter query

Hi,
 I have two queries.

cfquery name=getImg dbtype=query
select * from getList
where name NOT like 'tn_%'
order by name
/cfquery

cfquery name=getSQL datasource=#DSN#
select * from Judges
/cfquery

 in GetImg recordset I have some data in there, in GetSQL recordset I am
pulling another series of records.
 I need to create the third query which contains all the records but not the
one which are pulled from Judges table.
 in other words,
select * from getList, GetSql where getlist.name http://getlist.name 
getSql.image


--

Regards,




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220879
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFC Lifecycle

2005-10-13 Thread Mike Soultanian
I am no pro with CFCs as I'm just learning them myself, but I believe 
the answer is yes, it will die after the page request is over.  In the 
reading I've done, people will instantiate their CFCs into persistant 
variables such as server, session, or application scopes so that the 
instance of that CFC will be available to all page requests.

So, let's say for example, I have some CFC that I invoke methods on 
quite often.  Instead of invoking it repeatedly in various pages, I 
might as will just invoke it once and save that instance in the 
application scope so it is accessible to every page.  You still have to 
be cautious of locking, just like any other variable, though.

hth,
Mike

Andy Mcshane wrote:
 Just a quick question to help clear, hopefully, the last of the muddy waters 
 with regards to how CFC's work. 
 
 A CFC that is initialized and stored within the application/session scope is 
 then available to use everywhere as required.
 
 Now I just want clarification on CFC's created at page level. If I create an 
 instance of a CFC on my page, carry out some processing and then do cflocate 
 to another page am I correct in assuming that my CFC instance is now gone and 
 if I wish to re-use it I must create another instance of it? I am just a 
 little confused on the whole lifecycle bit of CFC's, can anyone provide some 
 clarity?
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220880
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFC Lifecycle

2005-10-13 Thread Deanna Schneider
You've got it correct. An instance of a cfc created on a page is no
different than any other variable created on a page - it's gone when you
leave the page.

Where it gets murky with CFC's is whether or not you're creating it with
createObject or using cfinvoke to just hit a method that doesn't return an
instance of the object. So, for instance this would work:

cfset myObj = createObject(component, myComponent)

cfoutput
#myObj.sayHello()#
/cfoutput

And, this would work:

cfinvoke
   component=myComponent
   method=sayHello
   returnVariable=hello
/cfinvoke
cfoutput#hello#/cfoutput

But, the first one creates an object (myObj) that can be re-used
throughout your page. So, you could also do,
cfoutput#myObj.sayGoodbye()#/cfoutput without
re-instantiating the object. The second does not keep a reference to
the object for further use.




On 10/13/05, Andy Mcshane [EMAIL PROTECTED] wrote:

 Just a quick question to help clear, hopefully, the last of the muddy
 waters with regards to how CFC's work.

 A CFC that is initialized and stored within the application/session scope
 is then available to use everywhere as required.

 Now I just want clarification on CFC's created at page level. If I create
 an instance of a CFC on my page, carry out some processing and then do
 cflocate to another page am I correct in assuming that my CFC instance is
 now gone and if I wish to re-use it I must create another instance of it? I
 am just a little confused on the whole lifecycle bit of CFC's, can anyone
 provide some clarity?





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220881
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFC Lifecycle

2005-10-13 Thread Joe Rinehart
Hey Andy,

 If I create an instance of a CFC on my page, carry out some processing
 and then do cflocate to another page am I correct in assuming that
 my CFC instance is now gone and if I wish to re-use it I must create
 another instance of it?

Exactly!  A CFC instance is just a variable like any other - put it in
the unnamed/variables scope and it only hangs out for the duration of
the page.  Put it in application/session, and it'll stick around.

-Joe

--
Get Glued!
The Model-Glue ColdFusion Framework
http://www.model-glue.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220882
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: javax.mail.SendFailedException: 550 5.7.1

2005-10-13 Thread John Lucania
I mentioned that ** If I open Outlook and send e-mail to
[EMAIL PROTECTED] and
[EMAIL PROTECTED], messages go through with no issue. ** and
** If I send messages with CFMAIL, I get the error above. **

Then, the question I have which one (Outlook Server or CFMX Server) is
generating the error?
CFMX Server passes the message to Outlook Server fine, but is Outlook
Server rejecting it and send it back to CFMX Server?  Or, CFMX Server
is rejecting it before sending to Outlook Server?


jl

On 10/13/05, Paul Vernon [EMAIL PROTECTED] wrote:
 This is probably a permissions issue or the relay settings on you mail
 server not including the IP of your CF server.

 Either you need to supply a username and password to the CF server in the
 CFMAIL admin area to authenticate with your mail server or you need to set
 up your mail server to let CF relay through it without authenticating.

 Paul


 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220883
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: javax.mail.SendFailedException: 550 5.7.1

2005-10-13 Thread Dave Watts
 Why is this generating this error?
 
 Invalid Addresses; nested exception is:
 javax.mail.SendFailedException: 550 5.7.1 Unable to relay for
 [EMAIL PROTECTED] ; nested exception is:
 javax.mail.SendFailedException: 550 5.7.1 Unable to relay for
 [EMAIL PROTECTED]
 
 If I open Outlook and send e-mail to [EMAIL PROTECTED] and
 [EMAIL PROTECTED], messages go through with no issue.
 
 If I send messages with CFMAIL, I get the error above.
 
 CF is connecting Outlook server, so I thought it should work fine.

When you connect to your Exchange server using Outlook, you are using
Microsoft's specific protocols to communicate. When you connect to Exchange
from CF using CFMAIL, you're using SMTP. Your Exchange server needs to be
configured to allow SMTP relaying from your CF server. Google Exchange SMTP
relay to find out how to do this. 

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

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


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220884
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CFC Lifecycle

2005-10-13 Thread Andy Matthews
Joe made a fine point. Just because you instantiate a CFC on a page that
gets called does NOT mean it'll die after the page request is through IF you
instantiate it into the SERVER, APPLICATION or SESSION scope.

That said, I use this method, in my Application file, to instantiate
commonly used CFCs.

cfscript
// intialize the query manager CFC
APPLICATION.queryObj = CreateObject(component, 
includes.queryManager);
/cfscript

And let's be honest here...if they weren't commonly used, we probably
wouldnt' make them into a CFC now would we?

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 7:14 AM
To: CF-Talk
Subject: Re: CFC Lifecycle


Hey Andy,

 If I create an instance of a CFC on my page, carry out some processing
 and then do cflocate to another page am I correct in assuming that
 my CFC instance is now gone and if I wish to re-use it I must create
 another instance of it?

Exactly!  A CFC instance is just a variable like any other - put it in
the unnamed/variables scope and it only hangs out for the duration of
the page.  Put it in application/session, and it'll stick around.

-Joe

--
Get Glued!
The Model-Glue ColdFusion Framework
http://www.model-glue.com



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220885
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


OT: Java IDE

2005-10-13 Thread Phill B
I would like to incorporate more Java into my CF sites. Since I'm new
to Java, can you guys recommend a good IDE to use to write the Java?

--
Phil

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220886
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Java IDE

2005-10-13 Thread Robertson-Ravo, Neil (RX)
Eclipse springs to mind. 

;-p



-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED] 
Sent: 13 October 2005 14:26
To: CF-Talk
Subject: OT: Java IDE

I would like to incorporate more Java into my CF sites. Since I'm new
to Java, can you guys recommend a good IDE to use to write the Java?

--

Phil



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220887
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Java IDE

2005-10-13 Thread Michael T. Tangorre
 From: Phill B [mailto:[EMAIL PROTECTED] 
 I would like to incorporate more Java into my CF sites. Since 
 I'm new to Java, can you guys recommend a good IDE to use to 
 write the Java?

ECLIPSE! :-)




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220888
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Java IDE

2005-10-13 Thread Phill B
That's what I thought! I started going thru the Eclipse site but I
wasn't sure if I needed a plugin to get the Java tools like you do
with ColdFusion.

So can I just use the straight up version of Eclipse or are there some
plugins I need to get for it?

On 10/13/05, Michael T. Tangorre [EMAIL PROTECTED] wrote:
  From: Phill B [mailto:[EMAIL PROTECTED]
  I would like to incorporate more Java into my CF sites. Since
  I'm new to Java, can you guys recommend a good IDE to use to
  write the Java?

 ECLIPSE! :-)

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220889
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Java IDE

2005-10-13 Thread Spike
If you download the SDK version of Eclipse it comes with all the Java tools.

The Eclipse platform and Eclipse RCP downloads do not come with Java tools.

Spike

On 10/13/05, Phill B [EMAIL PROTECTED] wrote:

 That's what I thought! I started going thru the Eclipse site but I
 wasn't sure if I needed a plugin to get the Java tools like you do
 with ColdFusion.

 So can I just use the straight up version of Eclipse or are there some
 plugins I need to get for it?

 On 10/13/05, Michael T. Tangorre [EMAIL PROTECTED] wrote:
   From: Phill B [mailto:[EMAIL PROTECTED]
   I would like to incorporate more Java into my CF sites. Since
   I'm new to Java, can you guys recommend a good IDE to use to
   write the Java?
 
  ECLIPSE! :-)

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220890
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: javax.mail.SendFailedException: 550 5.7.1

2005-10-13 Thread Mark Fuqua
I don't know if this will help you, but it sure seems timely (posted early
this morning)

http://www.danvega.org/blog/client/index.cfm/2005/10/12/Sending-mail-with-CF
Mail-A-problem--A-solution

Mark Fuqua




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220891
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Java IDE

2005-10-13 Thread Phill B
Cool! I'll just run the updater and grab the SDK. Thanks Spike

On 10/13/05, Spike [EMAIL PROTECTED] wrote:
 If you download the SDK version of Eclipse it comes with all the Java tools.

 The Eclipse platform and Eclipse RCP downloads do not come with Java tools.

 Spike


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220892
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CFC Lifecycle

2005-10-13 Thread Andy McShane
Thanks all, this clears things up and re-enforces what I thought was
correct. ;-)


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220893
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFCs and cftry/cfcatch

2005-10-13 Thread Rob Richardson
Bryan--- I'm coming in on the tail end of this conversation, but noticed in 
your code sample that you were trying to cfdump the cfcatch structure.  I ran 
into problems with cfdump/cfcatch that was ultimately confirmed by Macromedia 
to be a bug in CFMX6.1 that isn't corrected by one of their hot fixes and I'm 
having to hack around since we won't be moving to 7.0 anythime soon.  See 
thread 
(http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:42124#217681)
 for details.  I'll update that thread with the response from MM.  Good luck 
with this.--- Rob

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220894
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


verify ip addr in a specific range

2005-10-13 Thread Bosky, Dave
Does anyone have a function that will check if an ip address falls with
a starting/ending ip address range

 

Thanks,

Dave

 


**
HTC Disclaimer:  The information contained in this message may be privileged 
and confidential and protected from disclosure. If the reader of this message 
is not the intended recipient, or an employee or agent responsible for 
delivering this message to the intended recipient, you are hereby notified that 
any dissemination, distribution or copying of this communication is strictly 
prohibited.  If you have received this communication in error, please notify us 
immediately by replying to the message and deleting it from your computer.  
Thank you.
**



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220895
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


HP OpenView Service Desk API?

2005-10-13 Thread MrBuzzy
 and it's a long shot:
 Has anyone out there connected to HP OV ServiceDesk using the web-api.jar?
 If so, I'd like to know;
* Does it work on anything more recent than CF4.5? I might have other
questions :)
 Thankyou.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220896
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfcatch/cfdump weirdness

2005-10-13 Thread Rob Richardson
All--- This is a bug confirmed by Macromedia, but not resolved, as follows.  I 
have  to hack around this until (IF) they fix it.  I'll update CFBugHunt too.  
Thanks.--- Rob

 Bill Sahlas [EMAIL PROTECTED] 9/9/2005 11:05:18 AM 
I was able to reproduce the problem using the tests that you provided.  This is 
a bug in CF 6.1.  However, it has been fixed in CF 7.0, i.e. I  see all the 
output beyond the cfcatch.  I can enter this as a bug against 6.1 and I am 
curious to know if you can move to CF 7.0 to resolve this OR can you work 
around this OR how should we proceed?  We often patch CF 6.1 for customers 
under support agreement.  Do you have a
support agreement contract with Macromedia?  We will work to have this 
resolved.  Thanks for the report.  Bug entry on your behalf is #61103.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220897
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


IE and CSS

2005-10-13 Thread Jean-Baptiste Emanuel Zorg
i've got a div on a page that i want to encompass the full page.. it's
a container.
i have body,html set to height:100% but when i set the container div
to 100% it only goes to the height of the viewable area. but the page
scrolls... and the container div is too short..

any ideas or suggestions?

ta.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220898
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Java IDE

2005-10-13 Thread Douglas Knudsen
or nab the wtp, web tools platform, package...you get the Java stuffs
and web stuffs.  They have an all-in-one download at version 0.7 now. 
two tweaks and you can edit mxml files.  one plugin, cfeclipes, and
you get cf editing.  Nothing more you need, eh?  :)

DK

On 10/13/05, Phill B [EMAIL PROTECTED] wrote:
 Cool! I'll just run the updater and grab the SDK. Thanks Spike

 On 10/13/05, Spike [EMAIL PROTECTED] wrote:
  If you download the SDK version of Eclipse it comes with all the Java tools.
 
  The Eclipse platform and Eclipse RCP downloads do not come with Java tools.
 
  Spike
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220899
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFDocument, FlashPaper and Table Borders

2005-10-13 Thread Sam Farmer
I am having problems with CFDocument creating a Flashpaper and then
displaying table cell borders.

The pure html in a browser shows borders but Flashpaper completely ignores
the Styles whether in the td or in a style block.

Any ideas?

Here is the code:

cfdocument format=flashpaper
style type=text/css
TD {
border-right : 1px dotted Gray;
border-bottom : 1px dotted Gray;
font : 0.7em Verdana, Geneva, Arial, Helvetica, sans-serif;
}
/style
table
tr
td valign=topAfternoon Chair /td
td valign=top6/17/06/td
/tr
tr
td valign=topAll in/td
td valign=top6/17/06/td
/tr
/table
/cfdocument

Thanks,

Sam


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220900
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CFCs and cftry/cfcatch

2005-10-13 Thread Kerry
I thought there was a patch for this?
http://www.macromedia.com/go/1a9c83c

Or are you referring to another bug?

-Original Message-
From: Rob Richardson [mailto:[EMAIL PROTECTED]
Sent: 13 October 2005 15:17
To: CF-Talk
Subject: Re: CFCs and cftry/cfcatch


Bryan--- I'm coming in on the tail end of this conversation, but noticed in
your code sample that you were trying to cfdump the cfcatch structure.  I
ran into problems with cfdump/cfcatch that was ultimately confirmed by
Macromedia to be a bug in CFMX6.1 that isn't corrected by one of their hot
fixes and I'm having to hack around since we won't be moving to 7.0 anythime
soon.  See thread
(http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:42124
#217681) for details.  I'll update that thread with the response from MM.
Good luck with this.--- Rob



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220901
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: HTML Combo Boxes

2005-10-13 Thread Aaron Rouse
An autosuggests seems to be the common term used for it. I found one and
modified it for our needs yesterday evening. It is a form where a user keys
in product codes, they can only key in one of 900 product codes existing in
the system. So when they hit a they want to see a drop down of all the A's
so they can pick from there. This is the URL to the one I worked into our
form.
 http://www.webreference.com/programming/javascript/ncz/column2/index.html

 On 10/13/05, Robertson-Ravo, Neil (RX) 
[EMAIL PROTECTED] wrote:

 Hey Aaaron, what is it you want to achieve?




 -Original Message-
 From: Aaron Rouse [mailto:[EMAIL PROTECTED]
 Sent: 12 October 2005 21:32
 To: CF-Talk
 Subject: Re: OT: HTML Combo Boxes

 I implimented it earlier with IE 6 and ran into no JS errors. We did just
 decide we need more of an auto-fill on a text input kind of like how
 Google does things in gmail. So back to searching to see what I can find
 for
 that.




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220902
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: verify ip addr in a specific range

2005-10-13 Thread Scott Stroz
http://www.cflib.org/udf.cfm?id=1075enable=1

On 10/13/05, Bosky, Dave [EMAIL PROTECTED] wrote:

 Does anyone have a function that will check if an ip address falls with
 a starting/ending ip address range



 Thanks,

 Dave




 **
 HTC Disclaimer: The information contained in this message may be
 privileged and confidential and protected from disclosure. If the reader of
 this message is not the intended recipient, or an employee or agent
 responsible for delivering this message to the intended recipient, you are
 hereby notified that any dissemination, distribution or copying of this
 communication is strictly prohibited. If you have received this
 communication in error, please notify us immediately by replying to the
 message and deleting it from your computer. Thank you.
 **



 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220903
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


cfstudio bug

2005-10-13 Thread Wurst, Keith D.
hi everone. i'm having a problem with cfstudio. i seem to have lost my
line number gutter in the editing window. even when I click on the
little button that turns the gutter on and off - it doesn't re-appear.
anyone have any ideas? thanks.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220904
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Java IDE

2005-10-13 Thread Nathan Strutz
Obviously Eclipse would be a good choice, as it's a great choice for
your CFML programming, too. Seriously, the Java editing is awesome.

Plus it's free, and is very heavily community supported.

-nathan strutz
http://www.dopefly.com/

On 10/13/05, Phill B [EMAIL PROTECTED] wrote:
 I would like to incorporate more Java into my CF sites. Since I'm new
 to Java, can you guys recommend a good IDE to use to write the Java?

 --
 Phil

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220905
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Trapping a null form field value

2005-10-13 Thread Scott Stewart
I'm trying to trap a null form field in an update query

cfif (IsDefined(form.Dropouts)) and (form.Dropouts is not ),Dropouts =
#form.Dropouts#/cfif

This used to work, I first check to see if the field is defined, then if
there's anything there. If not then don't even include the line in the
update.

BUT...


What I'm getting is the blank field appearing in the update and it's causing
an oracle error [Oracle][ODBC][Ora]ORA-00936: missing expression 
Because the query is trying to insert nothing into the field.

Hlll

Thanks

sas

Scott A. Stewart
Cold Fusion Developer

GNSI
11820 Parklawn Dr.
Rockville, MD


over a thousand years ago, a blue faced Pict stepped on a bloated sheep
carcass, and thus.. the pipes were born

- the Scottish Rogues




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220906
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfstudio bug

2005-10-13 Thread Dawson, Michael
Toggling the gutter does not toggle the line numbers.  There is a
separate toggle for that.

If you enable the Editor toolbar, you should see the extra button for
line numbers.  There may also be a menu option, but I don't have
Studio/HS handy right now.

M!ke 

-Original Message-
From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 13, 2005 10:35 AM
To: CF-Talk
Subject: cfstudio bug

hi everone. i'm having a problem with cfstudio. i seem to have lost my
line number gutter in the editing window. even when I click on the
little button that turns the gutter on and off - it doesn't re-appear.
anyone have any ideas? thanks.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220908
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Trapping a null form field value

2005-10-13 Thread Justin D. Scott
 cfif (IsDefined(form.Dropouts)) and (form.Dropouts is not 
 ),Dropouts = #form.Dropouts#/cfif

Try wrapping the variable in a trim() function when checking for the blank
value.

-Justin Scott



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220907
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfstudio bug

2005-10-13 Thread Robert Munn
hi everone. i'm having a problem with cfstudio. i seem to have lost my
line number gutter in the editing window. even when I click on the
little button that turns the gutter on and off - it doesn't re-appear.
anyone have any ideas? thanks.

Switch to CFEclipse!

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220909
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Trapping a null form field value

2005-10-13 Thread Scott Stewart
Thanks Justin... that worked



Scott A. Stewart
Cold Fusion Developer

GNSI
11820 Parklawn Dr.
Rockville, MD


over a thousand years ago, a blue faced Pict stepped on a bloated sheep
carcass, and thus.. the pipes were born

- the Scottish Rogues


-Original Message-
From: Justin D. Scott [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 13, 2005 11:46 AM
To: CF-Talk
Subject: RE: Trapping a null form field value

 cfif (IsDefined(form.Dropouts)) and (form.Dropouts is not 
 ),Dropouts = #form.Dropouts#/cfif

Try wrapping the variable in a trim() function when checking for the blank
value.

-Justin Scott





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220910
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Trapping a null form field value

2005-10-13 Thread Mark Drew
in these cases you should always do

cfparam name=form.dropouts default= /

And when you want to you use it you just do

cfif Len(form.dropouts)
do something
/cfif

Much easier

MD

On 13/10/05, Justin D. Scott [EMAIL PROTECTED] wrote:

  cfif (IsDefined(form.Dropouts)) and (form.Dropouts is not
  ),Dropouts = #form.Dropouts#/cfif

 Try wrapping the variable in a trim() function when checking for the blank
 value.

 -Justin Scott



 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220911
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfstudio bug (line numbers in eclipse)

2005-10-13 Thread Paul
 Switch to CFEclipse!

On the very subject, I have to enable line numbers in CFEclipse for every
file individually.  Is there some way to just turn it on so the line numbers
are on by default?


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220912
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Trapping a null form field value

2005-10-13 Thread Deanna Schneider
Is this a varchar field in the db? I think cfqueryparam could be of help
here, but I'm a bit confused as to exactly what you're trying to accomplish.

On 10/13/05, Scott Stewart [EMAIL PROTECTED] wrote:

 I'm trying to trap a null form field in an update query

 cfif (IsDefined(form.Dropouts)) and (form.Dropouts is not ),Dropouts
 =
 #form.Dropouts#/cfif

 This used to work, I first check to see if the field is defined, then if
 there's anything there. If not then don't even include the line in the
 update.

 BUT...


 What I'm getting is the blank field appearing in the update and it's
 causing
 an oracle error [Oracle][ODBC][Ora]ORA-00936: missing expression 
 Because the query is trying to insert nothing into the field.

 Hlll

 Thanks

 sas

 Scott A. Stewart
 Cold Fusion Developer

 GNSI
 11820 Parklawn Dr.
 Rockville, MD


 over a thousand years ago, a blue faced Pict stepped on a bloated
 sheep
 carcass, and thus.. the pipes were born

 - the Scottish Rogues




 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220913
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Here's one more, ClusterCats error

2005-10-13 Thread Scott Stewart
ClusterCATS Manager detected failure of probe Verity
(D:\CFusion\cfam\program/cfprobe.exe
http:///search97cgi/s97_cgi.exe?querytext=testAction=SearchRe
sultTemplate=FIRSthome_nf.htscollection=C5 Query NORESTART NOLOGGING) on
server GlobalProbe. Returned value 2; expected value 0. Server is, by admin
request, not restricted.

I think this is clustercats trying to replicate a verity collection or
template.. but there's nothing readily available from either MM or a google
search.

Sever is running CF 5.0..

Thanks

sas

Scott A. Stewart
Cold Fusion Developer

GNSI
11820 Parklawn Dr.
Rockville, MD


over a thousand years ago, a blue faced Pict stepped on a bloated sheep
carcass, and thus.. the pipes were born

- the Scottish Rogues





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220914
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfstudio bug (line numbers in eclipse)

2005-10-13 Thread Rob
That is odd - WindowPreferences then CFEclipseEditor and check Show line
numbers should do it for all cfml/cfm/cfc files.

On 10/13/05, Paul [EMAIL PROTECTED] wrote:

  Switch to CFEclipse!

 On the very subject, I have to enable line numbers in CFEclipse for every
 file individually. Is there some way to just turn it on so the line
 numbers
 are on by default?


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220915
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Java IDE

2005-10-13 Thread Mark Drew
And I belive a few people in the CF community have had experience with it so
you will be able to get some help here too

MD

On 13/10/05, Nathan Strutz [EMAIL PROTECTED] wrote:

 Obviously Eclipse would be a good choice, as it's a great choice for
 your CFML programming, too. Seriously, the Java editing is awesome.

 Plus it's free, and is very heavily community supported.

 -nathan strutz
 http://www.dopefly.com/

 On 10/13/05, Phill B [EMAIL PROTECTED] wrote:
  I would like to incorporate more Java into my CF sites. Since I'm new
  to Java, can you guys recommend a good IDE to use to write the Java?
 
  --
  Phil
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220916
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Problem with duplicate check

2005-10-13 Thread Orlini, Robert
Can someone please tell me what I'm doing wrong here? I want this code to check 
for duplicates in a database and then give the javascript error pop-up. 
However, when I add a unique record it keeps giving me the duplicate pop-up 
message.

CFQUERY name=checkduplicates datasource=pc_inventory
Select pcname, ip, serialnumber, oldpcnumber, newpcnumber from inventory
Where id=id
/cfquery

CFIF IsDefined (form.oldpcnumber) and #trim(form.oldpcnumber)# NEQ  
or IsDefined (form.newpcnumber) and #trim(form.newpcnumber)# NEQ  
or IsDefined (form.serialnumber) and #trim(form.serialnumber)# NEQ 

CFLOOP Query=checkduplicates
CFIF #trim(form.oldpcnumber)# EQ #trim(checkduplicates.oldpcnumber)#
Script Language = Javascript
alert (**IDENTICAL PC Number or Serial Number in Database - PLEASE 
RETRY**);window.history.go(-1);
/script
/CFIF 
/CFLOOP
cfabort
/CFIF  

Robert O.

Thanks!


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.14/130 - Release Date: 10/12/2005
 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220917
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Java IDE

2005-10-13 Thread Dave Jones
Let me throw in a plug for IntelliJ's IDEA. I look for free tools 
as much as possible, but buying IDEA has probably been the best 
money I've ever spent. YMMV, but I found getting up to speed and 
getting productive in IDEA much easier and faster than Eclipse.

Dave Jones
NetEffect


At 06:25 AM 10/13/05, you wrote:
I would like to incorporate more Java into my CF sites. Since I'm new
to Java, can you guys recommend a good IDE to use to write the Java?

--
Phil



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220918
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Problem with duplicate check

2005-10-13 Thread Dave Watts
 Can someone please tell me what I'm doing wrong here? I want 
 this code to check for duplicates in a database and then give 
 the javascript error pop-up. However, when I add a unique 
 record it keeps giving me the duplicate pop-up message.
 
 CFQUERY name=checkduplicates datasource=pc_inventory
 Select pcname, ip, serialnumber, oldpcnumber, newpcnumber 
 from inventory
 Where id=id
 /cfquery

ID will always equal ID, so this query will match every record in the
INVENTORY table. If you want to find duplicates, you'll need to do a
self-join. Something like this might work - I obviously haven't tested it,
though, and it usually takes me a couple of tries to write a query to detect
duplicates.

SELECT i1.pcname, i1.ip, i1.serialnumber, i1.oldpcnumber, i1.newpcnumber
FROM inventory i1
INNER JOIN inventory i2 ON i1.id  i2.id
WHERE i1.pcname = i2.pcname
AND i1.ip = i2.ip
AND i1.serialnumber = i2.serialnumber
AND i1.oldpcnumber = i2.oldpcnumber
AND i1.newpcnumber = i2.oldpcnumber

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

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

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220919
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: eclipse line numbers + (was cfstudio bug)

2005-10-13 Thread Paul
Well what a dunder, I was sure I had checked that...  Thanks.

While I have your attention Rob, my only remaining squibble with CFEclipse,
probably another oversight on my part, is I can't find a way to shift the
text in the editor.  

While editing an XML file I can select a block of text, right click, and
select shift text right.  That option isn't available while editing
cfc/cfm files and I'm going crazy aligning pasted code.  Is this one
something I'm missing as well? 

-Original Message-
From: Rob [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 13, 2005 10:19 AM
To: CF-Talk
Subject: Re: cfstudio bug (line numbers in eclipse)

That is odd - WindowPreferences then CFEclipseEditor and check Show line
numbers should do it for all cfml/cfm/cfc files.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220920
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFCs and cftry/cfcatch

2005-10-13 Thread Rob Richardson
I have 6.1, with updater  hot fixes, including 1a9c83c.  MM confirmed this bug 
is in addition to list of known updater issues posted on their site.  This bug 
is not yet listed online.

I thought there was a patch for this?
http://www.macromedia.com/go/1a9c83c

Or are you referring to another bug?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220921
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFAJAX return types docco

2005-10-13 Thread Ken Ferguson
I'd be very interested James.

James Holmes wrote:

OK I've dug through the many examples and finally discovered the
relatively simple structure that represents a query.

Is anyone interested in me compiling the info on CFAJAX return types
in a quick reference doc and posting/blogging it?

On 10/5/05, James Holmes [EMAIL PROTECTED] wrote:
  

Does anyone have a simple docco for the JS objects returned by CFAJAX
for the corresponding CF types? I have arrays worked out (a
no-brainer) but I haven't looked at, for example, what queries come
back as.

If soemone can save me reinventing the wheel, please let me know.





--
Geeque - accept the geek within and get your friends off your back -
http://www.cafepress.com/geeque/



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220922
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFERROR

2005-10-13 Thread Chad McCue
I am running CF7on windows 2003.

I am trying to use CFERROR in my application.cfm file and it never calls my 
template I give it.


here is my call.
cferror template=CustomError.cfm mailto=test@test.com type=Exception 
exception=Any   



Here is the error the page has.

13:00:28.028 - Expression Exception - in 
D:\Inetpub\wwwroot\AgentSite\FunctionPages\AccountFunctions.cfc : line 841
Element CustomerID is undefined in a CFML structure referenced as 
part of an expression.




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220923
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: javax.mail.SendFailedException: 550 5.7.1

2005-10-13 Thread Daniel Kang
Have you checked firewall?

Daniel

On 10/13/05, Mark Fuqua [EMAIL PROTECTED] wrote:
 I don't know if this will help you, but it sure seems timely (posted early
 this morning)

 http://www.danvega.org/blog/client/index.cfm/2005/10/12/Sending-mail-with-CF
 Mail-A-problem--A-solution

 Mark Fuqua




 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220924
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


setting up jrun for search engine friendly URLS

2005-10-13 Thread John Wilker
My dev environment is jrun. I'm working on making a client's site search
engine friendly.

Currently their URL is
http://localhost:8102/Clients_cfusion/atfn/site/content.cfm?id=68A272B3-EB78-492E-9377131A684C0481

the new one will be
http://localhost:8102/Clients_cfusion/atfn/site/content.cfm/id/68A272B3-EB78-492E-9377131A684C0481

Using cf_fakeurl. But I don't know how to make jruns web server (please say
it's possible) not look to see if the file exists.

That possible?

THanks all.

J

--
John Wilker
Writer/Web Consultant
www.red-omega.com http://www.red-omega.com

The measure of success is not whether you have a tough problem to deal
with,
but whether it's the same problem you had last year.
~John Foster Dulles, Former US Sec. of State.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220925
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread Alexander Sherwood
Hello All,

Anyone have experience with a CFML-based Learning Management System 
and/or Web Based Training Application? We are considering purchasing vs. 
rolling our own, so any links/resources would be helpful.

Thanks much,

--
Alex Sherwood
Hunter Warfield

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220926
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CFAJAX return types docco

2005-10-13 Thread Andy Matthews
I'd be interested as well. AJAX is something I've been wanting to start
using more often, but I'm no javascript guy.

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 1:54 AM
To: CF-Talk
Subject: Re: CFAJAX return types docco


OK I've dug through the many examples and finally discovered the
relatively simple structure that represents a query.

Is anyone interested in me compiling the info on CFAJAX return types
in a quick reference doc and posting/blogging it?

On 10/5/05, James Holmes [EMAIL PROTECTED] wrote:
 Does anyone have a simple docco for the JS objects returned by CFAJAX
 for the corresponding CF types? I have arrays worked out (a
 no-brainer) but I haven't looked at, for example, what queries come
 back as.

 If soemone can save me reinventing the wheel, please let me know.



--
Geeque - accept the geek within and get your friends off your back -
http://www.cafepress.com/geeque/



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220927
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread David Livingston
It's not a Cf based one but it is open source and gaining momentum.
http://www.moodle.org

Dave


On Oct 13, 2005, at 12:42 PM, Alexander Sherwood wrote:

 Hello All,

 Anyone have experience with a CFML-based Learning Management System
 and/or Web Based Training Application? We are considering  
 purchasing vs.
 rolling our own, so any links/resources would be helpful.

 Thanks much,

 --
 Alex Sherwood
 Hunter Warfield

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220928
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread Robert Munn
My team built one for our business that we have been using internally for four 
plus years. We've deployed it once for a customer solution, but the business 
recently decided not to support it as a product (doesn't fit into our solution 
set) so it is probably going to die. It's a really cool app. I would definitely 
recommend buying instead of building for this kind of product- a lot of thought 
goes into these solutions. You can email me offlist at robert.munn at 
peregrine.com if you'd like to hear more about our experiences with it.

Hello All,

Anyone have experience with a CFML-based Learning Management System 
and/or Web Based Training Application? We are considering purchasing vs. 
rolling our own, so any links/resources would be helpful.

Thanks much,

--
Alex Sherwood
Hunter Warfield

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220929
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFFile caching in MX7??

2005-10-13 Thread Javier Arroyo
I have a strange thing that started hapenning once we migrated from CF 5 to CF7 
...there is a particular process that creates a file (a csv to be exact) using 
CCFILE Action=Append ..problem is sometimes the file can get huge (e.g. 2.5 
megs) ...I have a web page that generates this and updates itself with a 
progress counter via javascript (100 of 2 records ..200 of 2 records, 
etc..) issue is once it is done it appears that cffile then starts to write 
out the file, I have determined this by wathing the file size as the counter 
increments and it doesn't grow in size very much when the counter is done 
then the file seems to grow and grow and grow ...the next page is to show the 
user an icon to download the .csv with, but we never see the icon on large 
files as the web server seems to timeout (although requesttimeout is set to a 
large amount) ...is there anyway to make cffile not cache? 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220930
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread Dawson, Michael
I may be a bit OT, but in case you didn't know, Blackboard and WebCT
have shown intent to merge their companies.  We started using Blackboard
recently (I'm no big fan of BB) but it may be interesting to see where
this merger goes.

I, too, built a custom student portal that pulled data from our AS400
student information system.  It was basic compared to BB, but it pleased
the majority of students and instructors.

That part of our intranet will be moved to BB next fall.

M!ke 

-Original Message-
From: Robert Munn [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 13, 2005 12:59 PM
To: CF-Talk
Subject: Re: Recommend a good CF-based LMS/WBT Application?

My team built one for our business that we have been using internally
for four plus years. We've deployed it once for a customer solution, but
the business recently decided not to support it as a product (doesn't
fit into our solution set) so it is probably going to die. It's a really
cool app. I would definitely recommend buying instead of building for
this kind of product- a lot of thought goes into these solutions. You
can email me offlist at robert.munn at peregrine.com if you'd like to
hear more about our experiences with it.

Hello All,

Anyone have experience with a CFML-based Learning Management System 
and/or Web Based Training Application? We are considering purchasing
vs.
rolling our own, so any links/resources would be helpful.

Thanks much,

--
Alex Sherwood
Hunter Warfield

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220931
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Suggestions for javascript interaction.

2005-10-13 Thread Andy Matthews
I'm working on a CMS which will be the basis for all admin sections I build
for my company. I'm trying to add in the sections which are most commonly
used by clients such as pages admin, file upload and interaction, user
management and more. At this point it's all built and functional. But I'm
looking to spend some time jazzing it up as it were. Using some javascript
(or other stuff) to add those little touches which can amount to big time
savings for the users.

Can anyone offer suggestions for things you might do in your code to make
life easier for the user?

I'd also love to hear if any of you use prebuilt validation libraries for
your forms. I've used qForms from Pengoworks.com before and liked it. But
it's been long enough that I wonder if there's anything better/easier to
implement.

Anyway, I  thought that this could be a good informative thread for us
javascript challenged people.

Thanks in advance.

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220932
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Suggestions for javascript interaction.

2005-10-13 Thread Aaron Rouse
Such as qForms 2.0? It is in beta but in use by many in its current state.

On 10/13/05, Andy Matthews [EMAIL PROTECTED] wrote:



 I'd also love to hear if any of you use prebuilt validation libraries for
 your forms. I've used qForms from Pengoworks.com 
 http://Pengoworks.combefore and liked it. But
 it's been long enough that I wonder if there's anything better/easier to
 implement.



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220933
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread Alexander Sherwood
I know BB used to be CF-based, but it looks like it's JSP now, no?

--
Alex



Dawson, Michael wrote:

I may be a bit OT, but in case you didn't know, Blackboard and WebCT
have shown intent to merge their companies.  We started using Blackboard
recently (I'm no big fan of BB) but it may be interesting to see where
this merger goes.

I, too, built a custom student portal that pulled data from our AS400
student information system.  It was basic compared to BB, but it pleased
the majority of students and instructors.

That part of our intranet will be moved to BB next fall.

M!ke



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220934
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


security suggestions?

2005-10-13 Thread Ray Champagne
We have a potential customer that is a bank (a small local one).  They 
want to be able to have people fill out a loan application online, but 
are worried about security, etc.  Other than using a secure certificate 
and SQL Server, are there any other considerations I should give to 
security?  Sorry this is such a broad question, but I really don't know 
any other things I should be worrying about.

Here's a list that I've thought out, but this is all really elemntary stuff:

Use cfqueryparam always
Use POST vs GET
Use SQL Server
Use SSL
Only allow retireval of data via the web site, not send any info in emails
???



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220935
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Suggestions for javascript interaction.

2005-10-13 Thread Michael T. Tangorre
 From: Aaron Rouse [mailto:[EMAIL PROTECTED] 
 Such as qForms 2.0? It is in beta but in use by many in its 
 current state.

Did Dan post a link for 2.0 beta? I didn't run across it on the Pengoworks
site... is it over at sourceforge now?




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220936
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Suggestions for javascript interaction.

2005-10-13 Thread Aaron Rouse
He posted a link on his blog, I do not have the URL handy though.

On 10/13/05, Michael T. Tangorre [EMAIL PROTECTED] wrote:

  From: Aaron Rouse [mailto:[EMAIL PROTECTED]
  Such as qForms 2.0? It is in beta but in use by many in its
  current state.

 Did Dan post a link for 2.0 beta? I didn't run across it on the Pengoworks
 site... is it over at sourceforge now?




 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220937
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Suggestions for javascript interaction.

2005-10-13 Thread Andy Matthews
Googling for javascript validation library I came across the TMT
validation library coded by our own Massimo. I looked through all of the
examples and this looks like PRECISELY what I need. It looks SIMPLE to
implement and easy to read and understand by someone coming behind me.

Here's the link: http://www.massimocorner.com/validator/

Good job Massimo...this looks amazing.

I haven't seen qForms 2.0 as it's not listed on the PengoWorks website. I'll
look on SourceForge though.

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 1:12 PM
To: CF-Talk
Subject: Suggestions for javascript interaction.


I'm working on a CMS which will be the basis for all admin sections I build
for my company. I'm trying to add in the sections which are most commonly
used by clients such as pages admin, file upload and interaction, user
management and more. At this point it's all built and functional. But I'm
looking to spend some time jazzing it up as it were. Using some javascript
(or other stuff) to add those little touches which can amount to big time
savings for the users.

Can anyone offer suggestions for things you might do in your code to make
life easier for the user?

I'd also love to hear if any of you use prebuilt validation libraries for
your forms. I've used qForms from Pengoworks.com before and liked it. But
it's been long enough that I wonder if there's anything better/easier to
implement.

Anyway, I  thought that this could be a good informative thread for us
javascript challenged people.

Thanks in advance.

!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220938
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: security suggestions?

2005-10-13 Thread Jerry Johnson
There is the transaction/filling out of information and how it is sent.
Then there is the issue of how and what is stored.
Then there is the issue of how and what is pulled back out and what is
done with it.
Then there is the issue of what system maintenance or backups
replicate the data.
Then there is the issue of what other systems share the same space

How secure is the db box (and lan) that the data will be stored on?
Does the CF server that gets the information have write-only access to
that db, or can it also read (and potentially display?)
What admin/reporting features are you going to put into place to
retrieve the data? How secure are they? Can the reporting
pages/reports be cached onto non-secure client boxes?  Can the
information be printed to a printer? Can it be copied or sent via
email? How is it retained?

The same questions that would need to be answered if they wanted to
implement a fax-in loan application (where do they store the paper,
who can access it, is it locked up, how do ou destroy it, etc).


On 10/13/05, Ray Champagne [EMAIL PROTECTED] wrote:
 We have a potential customer that is a bank (a small local one).  They
 want to be able to have people fill out a loan application online, but
 are worried about security, etc.  Other than using a secure certificate
 and SQL Server, are there any other considerations I should give to
 security?  Sorry this is such a broad question, but I really don't know
 any other things I should be worrying about.

 Here's a list that I've thought out, but this is all really elemntary stuff:

 Use cfqueryparam always
 Use POST vs GET
 Use SQL Server
 Use SSL
 Only allow retireval of data via the web site, not send any info in emails
 ???



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220939
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: security suggestions?

2005-10-13 Thread Justin D. Scott
 We have a potential customer that is a bank (a small
 local one).  They want to be able to have people fill
 out a loan application online, but are worried about
 security, etc.

A couple of things to consider if you can...

* Put the SQL Server on its own box connected to the web server on a second
NIC and different non-routable subnet.
* Ensure CF only has access to the data it needs to have access to (no using
sa to connect to the DB).
* Ensure you have a properly configured firewall in front of your network.
* Encrypt the more sensitive data before it goes into the database.
* Put a disclaimer on the site about not being responsible for communication
errors.

We have a small local bank as a client here and they found it to be more
cost effective to just offer the forms as PDF downloads to allow people to
print their own forms and mail/fax them in instead of using the web site.


-Justin Scott



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220940
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


IP to Zip Codes

2005-10-13 Thread Ray Champagne
I know that one can get a geographic location for a given IP, but does 
anyone know if there is a way to get the Zip Code a user is in from 
their IP?

I doubt this is possible, and all my research points to NO, but I'd 
never know for sure if I didn't ask...
-- 
=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220941
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: eclipse line numbers + (was cfstudio bug)

2005-10-13 Thread Rob
Highlight the text and hit tab to shift the selected text - shift+tab to
unindent

On 10/13/05, Paul [EMAIL PROTECTED] wrote:

 Well what a dunder, I was sure I had checked that... Thanks.

 While I have your attention Rob, my only remaining squibble with
 CFEclipse,
 probably another oversight on my part, is I can't find a way to shift the
 text in the editor.

 While editing an XML file I can select a block of text, right click, and
 select shift text right. That option isn't available while editing
 cfc/cfm files and I'm going crazy aligning pasted code. Is this one
 something I'm missing as well?

 -Original Message-
 From: Rob [mailto:[EMAIL PROTECTED]
 Sent: Thursday, October 13, 2005 10:19 AM
 To: CF-Talk
 Subject: Re: cfstudio bug (line numbers in eclipse)

 That is odd - WindowPreferences then CFEclipseEditor and check Show
 line
 numbers should do it for all cfml/cfm/cfc files.


 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220942
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: security suggestions?

2005-10-13 Thread Ray Champagne
Thanks, Jerry, Justin.  I'm going to write all this down and make sure I 
address all these concerns.

Justin, you may be right.  Spending thousands of dollars to have a loan 
app online that may or may not be used seems like a silly waste of money 
to me.  Sometimes new technology isn't always betteralthough, like 
Jerry said, it is just as much of a concern when you have a paper 
version.  It just isn't perceived that way, which is weird, because I'd 
figure there are more security concerns when you involve the human error 
factor: Now where is that Loan App?  Hmmm, must have left it in the 
lunchroom/restaurant/bathroom/

Jerry Johnson wrote:
 There is the transaction/filling out of information and how it is sent.
 Then there is the issue of how and what is stored.
 Then there is the issue of how and what is pulled back out and what is
 done with it.
 Then there is the issue of what system maintenance or backups
 replicate the data.
 Then there is the issue of what other systems share the same space
 
 How secure is the db box (and lan) that the data will be stored on?
 Does the CF server that gets the information have write-only access to
 that db, or can it also read (and potentially display?)
 What admin/reporting features are you going to put into place to
 retrieve the data? How secure are they? Can the reporting
 pages/reports be cached onto non-secure client boxes?  Can the
 information be printed to a printer? Can it be copied or sent via
 email? How is it retained?
 
 The same questions that would need to be answered if they wanted to
 implement a fax-in loan application (where do they store the paper,
 who can access it, is it locked up, how do ou destroy it, etc).
 
 
 On 10/13/05, Ray Champagne [EMAIL PROTECTED] wrote:
 
We have a potential customer that is a bank (a small local one).  They
want to be able to have people fill out a loan application online, but
are worried about security, etc.  Other than using a secure certificate
and SQL Server, are there any other considerations I should give to
security?  Sorry this is such a broad question, but I really don't know
any other things I should be worrying about.

Here's a list that I've thought out, but this is all really elemntary stuff:

Use cfqueryparam always
Use POST vs GET
Use SQL Server
Use SSL
Only allow retireval of data via the web site, not send any info in emails
???




 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220943
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: javax.mail.SendFailedException: 550 5.7.1

2005-10-13 Thread John Lucania
Thanks a bunch, Daniel and others.
Firewall was the cause.  Relay was shut off.

Daniel

On 10/13/05, Daniel Kang [EMAIL PROTECTED] wrote:
 Have you checked firewall?

 Daniel

 On 10/13/05, Mark Fuqua [EMAIL PROTECTED] wrote:
  I don't know if this will help you, but it sure seems timely (posted early
  this morning)
 
  http://www.danvega.org/blog/client/index.cfm/2005/10/12/Sending-mail-with-CF
  Mail-A-problem--A-solution
 
  Mark Fuqua
 
 
 
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220944
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: IP to Zip Codes

2005-10-13 Thread Justin D. Scott
 I know that one can get a geographic location for a
 given IP, but does anyone know if there is a way to
 get the Zip Code a user is in from their IP?

No, as one ISP can service many zip codes, and in many cases many states.
The addresses are rotated out dynamically to users in most cases, so an IP
may be in one zip code on one request, and another zip code on the next
request if two people end up with the same IP from different areas on the
same provider.  Unless the IP is known and trusted, never rely on it.


-Justin Scott



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220945
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: security suggestions?

2005-10-13 Thread Justin D. Scott
 Justin, you may be right.  Spending thousands of
 dollars to have a loan app online that may or may
 not be used seems like a silly waste of money to me

All we can do as developers is tell the clients what it will take to make
their dreams come true.  It's up to them to do the cost analysis and
determine if they will have a positive ROI or not.  For a small local bank,
it may be nice to offer this as a convenience to their customers, but unless
they're anticipating a lot of use, it may or may not be worth it to pay you
to implement it.


-Justin Scott



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220946
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: IP to Zip Codes

2005-10-13 Thread Ray Champagne
OK.  That was how I thought it worked, although I forgot about the 
dynamic IP thing, but it really doesn't matter anyways.

Justin D. Scott wrote:
I know that one can get a geographic location for a
given IP, but does anyone know if there is a way to
get the Zip Code a user is in from their IP?
 
 
 No, as one ISP can service many zip codes, and in many cases many states.
 The addresses are rotated out dynamically to users in most cases, so an IP
 may be in one zip code on one request, and another zip code on the next
 request if two people end up with the same IP from different areas on the
 same provider.  Unless the IP is known and trusted, never rely on it.
 
 
 -Justin Scott
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220947
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CF5 Session Variables Timing out early?

2005-10-13 Thread paulh
I'm running CF5 and I can't figure out why my session variables timeout
approx every 30min even though I've set the maximum timeout and default
timeout to 1 day (as a test) in the cfserver on the Memory Variables page.

Originally I had specified the timeout values within the application.cfm
page which should override the server settings...but since it wasn't
working I removed the timeout specifications and I've still had the same
problem.

Any ideas?

Thanks
-Paul


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220948
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Report Builder Query Questions

2005-10-13 Thread Claremont, Timothy
I am using the updated report builder, and trying to construct a query
using the query builder.

My datasource is a FoxPro free table directory.

When I click on the tables icon for the data source in question, many of
the tables appear, but not all of them. As a matter of fact, the ones
that I NEED are not there.

The FoxPro tables are from a third party application, and I don't know
much about FoxPro. Does anyone have any clues as to why some tables
would appear and not others?

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from 
your system.

This footnote also confirms that this email message has been swept for
the presence of computer viruses.

Thank You,
Viahealth
**


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220949
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: security suggestions?

2005-10-13 Thread Jim Davis
 -Original Message-
 From: Ray Champagne [mailto:[EMAIL PROTECTED]
 Sent: Thursday, October 13, 2005 2:24 PM
 To: CF-Talk
 Subject: security suggestions?
 
 We have a potential customer that is a bank (a small local one).  They
 want to be able to have people fill out a loan application online, but
 are worried about security, etc.  Other than using a secure certificate
 and SQL Server, are there any other considerations I should give to
 security?  Sorry this is such a broad question, but I really don't know
 any other things I should be worrying about.
 
 Here's a list that I've thought out, but this is all really elemntary
 stuff:

Just some comments (you may already know this but I find a lot of people
saying these things are security related without knowing why):
 
 Use cfqueryparam always

Understand that this is only a security measure because of the type
validation provided and the inability to create SQL injection attacks.
Regardless of CFQUERYPARAM you should take care to construct your data
access in a such as way as to be removed from your interface.

Information entered in the interface should never be used to populate a data
call without first going through a validation filter.  While CFQUERYPARAM
makes for a decent validation filter I greatly prefer the addition of a
true, componentized filter as well.

 Use POST vs GET

The only real problem here is that a GET may be bookmarked or kept in
browser history.  Under SSL BOTH POSTs and GETs are passed via the secure
transit.

 Use SQL Server

This doesn't really add any security... all databases are only as secure as
their configuration.  In general you should never allow a database to exist
in a downloadable area (as when people place Access files within the web
server root).

You should also severely limit access to the data... a more professional
DBMS like SQL Server makes this easier but still, you must actually do it.

I recommend, if the system design allows, making the web database user who
writes the data not be allowed to read it.  You might allow that user access
to certain procedures which could read some of the information... but having
the user be a one way gate can increase security somewhat (if the username
and password for that user is compromised no personal data can be obtained
using it).

 Use SSL

Definitely.  SSL has some overhead (it's not cheap to encrypt/decrypt) but
for any small sites it's negligible.  

 Only allow retireval of data via the web site, not send any info in emails

That depends.  Secure email (using something PGP) may be more secure that
allowing access from the site (what's more likely to be hacked?)

You may also have two sites: one hosted and accessible only on an internal
network.  The public site could update the data but not read it, the
internal site could do both.

 ???

There some other technical ideas to consider:

1) If your application contains sensitive information you might want to host
it within a pop-up window, closing the window when you're done.  This
eliminates the possibility that somebody could come along and back button
to the personal information.

It also adds the possibility that people with pop-up blockers will not see
the form.  And it pretty much requires JavaScript to do it right.

Also note that features like this are to protect the user from themselves,
not the company.  It's not the companies' fault if the user is sloppy with
their information... but it can be hard to tell who's been sloppy when a
leak occurs.

2) You might want to encrypt the information on the database... but this is
a little overkill-ish.  However if you can't secure the database as much as
you'd like it can be a good measure.

In this case an application would be needed to get the information (like,
say, an internal web application).

3) Do you actually need to store in the information at all?  Could, for
example, the web site collection the data, convert it to a secure
(encrypted) email and send it directly the loan officer?

You might store some, non-specific aggregate information on the database but
the custom data would be sent directly to the only person that needed it and
would not be available if the web site were compromised.


More broadly there are some business issues to consider:

1) Ensure that the customer (via a Privacy Policy) knows how their
information will be used and what recourse they have.  Legally (at least in
some states) the custom must has full disclosure about the information
accepted, what's done with it and so forth.

A system must also be put into place (and publicized in your privacy policy)
how a customer may have their information removed from your system.

For most of this check in the Platform for Privacy Policy (PPP - it's a
W3C spec).  IBM offers a free tool to generate compliant privacy statements
and compact statements (used for cookies).

2) Determine who needs access to the data and put procedures in place to
protect it.  In other words if you (the web 

Changing tag case

2005-10-13 Thread Helmut Doll
Hello everyone,

I need to parse and search xml data using coldfusion where tags are  
not always using
the same case. (i.e. sometimes improvements and sometimes
Improvements.
While parsing is case-insensitive, xmlsearch is not.

Is there a search and replace that would convert all tags to
lowercase letters?

Thanks for your help.

Helmut Doll
[EMAIL PROTECTED]


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220951
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: security suggestions?

2005-10-13 Thread Robert Munn
some other thoughts:

- Use a non-standard port to talk to the database instead of 4133.
- Use strong passwords for all users on both systems and any applications, such 
as CF Admin. Use a strong password generator for this.
- Protect the CF Admin folder with OS-level security so you need a system login 
just to access the Admin.
- Require SSL everywhere.
- Make sure the app uses a site-wide error handler, missing template error 
handler, etc. You don't want any untrapped errors leaking out that could show 
useful debugging information to a hacker.
- Encrypt everything going into the database. 
- deploy a sourceless CF application (if possible- CFMX Ent. required) so even 
if some gets into the filesystem they can peruse the code for hints about how 
to get at customer data.

Maybe encrypting everything in the db is a bit over the top, but my thinking is 
that you can't be too secure in the banking world. 

 We have a potential customer that is a bank (a small
 local one).  They want to be able to have people fill
 out a loan application online, but are worried about
 security, etc.

A couple of things to consider if you can...

* Put the SQL Server on its own box connected to the web server on a second
NIC and different non-routable subnet.
* Ensure CF only has access to the data it needs to have access to (no using
sa to connect to the DB).
* Ensure you have a properly configured firewall in front of your network.
* Encrypt the more sensitive data before it goes into the database.
* Put a disclaimer on the site about not being responsible for communication
errors.

We have a small local bank as a client here and they found it to be more
cost effective to just offer the forms as PDF downloads to allow people to
print their own forms and mail/fax them in instead of using the web site.


-Justin Scott

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220952
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Loop through a structure of structures

2005-10-13 Thread Chris Stoner
On 10/12/05, Andy Mcshane [EMAIL PROTECTED] wrote:

 Thanks, I just realised that before I posted again, God alone knows what I
 thought I was trying to do with it earlier! The 17 recordsets are all
 returned via one stored procedure call within the CFC so there really is
 only DB call, couldn't do it any other way as the data that is returned is
 keyed on a position on screen so I have to get all top row, middle row, etc
 data.

  Without knowing all the details of your problem its possible that what you
are trying to accomplish can be done with the group attribute of cfquery and
one result set.
 If you group your recordsets with in your query with a column that
describes the recordset and order by that group column, you can the use the
cfouput with a group, for example
  LOCATION AGE ID NAME
TOP 22 1 Wibble
TOP 21 2 Wobble
MIDDLE 22 3 Wibble
MIDDLE 21 4 Wobble
MIDDLE 30 5 Woo
BOTTOM 34 6 Wibble
BOTTOM 23 7 Wobble
BOTTOM 33 8 Woo
 cfoutput query=myQuery group=Location
 #Location#BR
 cfoutput
 #Age# #ID# #Name#BR
 /cfoutput
/cfoutput


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220953
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Changing tag case

2005-10-13 Thread Justin D. Scott
 I need to parse and search xml data using coldfusion
 where tags are not always using the same case. (i.e.
 sometimes improvements and sometimes Improvements.
 While parsing is case-insensitive, xmlsearch is not.
 
 Is there a search and replace that would convert all
 tags to lowercase letters?

Is there a reason for the inconsistency?  Is this data used by any other
applications?  If not, I would just run a search and replace on the file
outside of CF to make them all lowercase.  Then it becomes a non-issue for
CF and will save you a lot of time.

If you do have to keep the source data the same, but need to walk through
the tags within CF, you can output the XML object as a string into a
variable, SR on that variable using CF's functions to get the tags to lower
case, and finally read it back into an XML object again.


-Justin Scott



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220954
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Using cferror

2005-10-13 Thread Chad McCue
I am running CF7on windows 2003.

I am trying to use CFERROR in my application.cfm file and it never calls my 
template I give it.


here is my call.
cferror template=CustomError.cfm mailto=test@test.com type=Exception 
exception=Any   



Here is the error the page has.

13:00:28.028 - Expression Exception - in 
D:\Inetpub\wwwroot\AgentSite\FunctionPages\AccountFunctions.cfc : line 841
Element CustomerID is undefined in a CFML structure referenced as part of 
an expression.




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220955
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: security suggestions?

2005-10-13 Thread Mike Klostermeyer
I'd figure there are more security concerns when you involve the human
error factor

Not only error, but theft as well.  I put myself through college working
retail at a nationally known retailer, and I had access to every one of our
customers credit card numbers, anytime I wanted.

It boggles my mind when people are scared to death to give their SSN or
credit card # over the internet, but won't think anything about freely give
their credit card to a broke 16 year old running the cash register.

Mike

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 1:54 PM
To: CF-Talk
Subject: Re: security suggestions?


Thanks, Jerry, Justin.  I'm going to write all this down and make sure I
address all these concerns.

Justin, you may be right.  Spending thousands of dollars to have a loan
app online that may or may not be used seems like a silly waste of money
to me.  Sometimes new technology isn't always betteralthough, like
Jerry said, it is just as much of a concern when you have a paper
version.  It just isn't perceived that way, which is weird, because I'd
figure there are more security concerns when you involve the human error
factor: Now where is that Loan App?  Hmmm, must have left it in the
lunchroom/restaurant/bathroom/

Jerry Johnson wrote:
 There is the transaction/filling out of information and how it is sent.
 Then there is the issue of how and what is stored.
 Then there is the issue of how and what is pulled back out and what is
 done with it.
 Then there is the issue of what system maintenance or backups
 replicate the data.
 Then there is the issue of what other systems share the same space

 How secure is the db box (and lan) that the data will be stored on?
 Does the CF server that gets the information have write-only access to
 that db, or can it also read (and potentially display?)
 What admin/reporting features are you going to put into place to
 retrieve the data? How secure are they? Can the reporting
 pages/reports be cached onto non-secure client boxes?  Can the
 information be printed to a printer? Can it be copied or sent via
 email? How is it retained?

 The same questions that would need to be answered if they wanted to
 implement a fax-in loan application (where do they store the paper,
 who can access it, is it locked up, how do ou destroy it, etc).


 On 10/13/05, Ray Champagne [EMAIL PROTECTED] wrote:

We have a potential customer that is a bank (a small local one).  They
want to be able to have people fill out a loan application online, but
are worried about security, etc.  Other than using a secure certificate
and SQL Server, are there any other considerations I should give to
security?  Sorry this is such a broad question, but I really don't know
any other things I should be worrying about.

Here's a list that I've thought out, but this is all really elemntary
stuff:

Use cfqueryparam always
Use POST vs GET
Use SQL Server
Use SSL
Only allow retireval of data via the web site, not send any info in emails
???










~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220956
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Changing tag case

2005-10-13 Thread Helmut Doll
The data comes from different sources and is submitted to the CF app.
I am currently doing a search and replace that changes individual  
tags when I notice a problem, but that is not scalable.
I am looking for a (maybe regular expression) solution (it has to be  
in cf), that would find all xml tags in a file and make them lower case.

Thanks for the suggestion,

Helmut Doll
[EMAIL PROTECTED]

On Oct 13, 2005, at 3:33 PM, Justin D. Scott wrote:

 I need to parse and search xml data using coldfusion
 where tags are not always using the same case. (i.e.
 sometimes improvements and sometimes Improvements.
 While parsing is case-insensitive, xmlsearch is not.

 Is there a search and replace that would convert all
 tags to lowercase letters?


 Is there a reason for the inconsistency?  Is this data used by any  
 other
 applications?  If not, I would just run a search and replace on the  
 file
 outside of CF to make them all lowercase.  Then it becomes a non- 
 issue for
 CF and will save you a lot of time.

 If you do have to keep the source data the same, but need to walk  
 through
 the tags within CF, you can output the XML object as a string into a
 variable, SR on that variable using CF's functions to get the tags  
 to lower
 case, and finally read it back into an XML object again.


 -Justin Scott



 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220957
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread Qasim Rasheed
edufolio.net

On 10/13/05, Alexander Sherwood [EMAIL PROTECTED] wrote:
 I know BB used to be CF-based, but it looks like it's JSP now, no?

 --
 Alex



 Dawson, Michael wrote:

 I may be a bit OT, but in case you didn't know, Blackboard and WebCT
 have shown intent to merge their companies.  We started using Blackboard
 recently (I'm no big fan of BB) but it may be interesting to see where
 this merger goes.
 
 I, too, built a custom student portal that pulled data from our AS400
 student information system.  It was basic compared to BB, but it pleased
 the majority of students and instructors.
 
 That part of our intranet will be moved to BB next fall.
 
 M!ke
 


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220958
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CF CR

2005-10-13 Thread John Lucania
Crystal Reports (CR) running off of Oracle database is in place to run
and get necessary queries and reports.   However, unfortunately, the
direct database connection between CF and the Oracle DB is not allowed
per the contract (duh).   The only connection I can have is though
CR.

How can you
1) connect CR
2) execute the CR as a scheduled task
3) get the query output
4) dump the query output into SQL DB?

jl

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220959
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL issue: filter query

2005-10-13 Thread Asim Manzur
I tried below and got an error

cfquery name=getImg dbtype=query
select * from getList
where name NOT like 'tn_%'
order by name
/cfquery

cfquery name=getSQL datasource=#DSN#
select j_image from Judges
/cfquery
cfquery name=getList2 dbtype=query
select * from getImg
where name NOT IN
(select j_image from getSQL)
/cfquery

 The error is
   Error Executing Database Query.
*Query Of Queries syntax error.*
Encountered name NOT IN ( select at line 0, column 0. Incorrect
conditional expression, Expected one of [like|null|between|in|comparison]
condition,   The error occurred in *C:\Inetpub\wwwroot\test3.cfm: line 31*

29 :select j_image from Judges
30 : /cfquery*31 : cfquery name=getList2 dbtype=query*
32 :select * from getImg
33 :where name NOT IN

  --
Regards,


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220960
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread Alexander Sherwood
Under Construction!

Qasim Rasheed wrote:

edufolio.net

On 10/13/05, Alexander Sherwood [EMAIL PROTECTED] wrote:
  

I know BB used to be CF-based, but it looks like it's JSP now, no?

--
Alex



Dawson, Michael wrote:



I may be a bit OT, but in case you didn't know, Blackboard and WebCT
have shown intent to merge their companies.  We started using Blackboard
recently (I'm no big fan of BB) but it may be interesting to see where
this merger goes.

I, too, built a custom student portal that pulled data from our AS400
student information system.  It was basic compared to BB, but it pleased
the majority of students and instructors.

That part of our intranet will be moved to BB next fall.

M!ke

  







~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220961
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread Alexander Sherwood
www.edufolio.com does work, though!

Thanks much...

--
Alex



Alexander Sherwood wrote:

Under Construction!

Qasim Rasheed wrote:

  

edufolio.net

On 10/13/05, Alexander Sherwood [EMAIL PROTECTED] wrote:
 



I know BB used to be CF-based, but it looks like it's JSP now, no?

--
Alex



Dawson, Michael wrote:

   

  

I may be a bit OT, but in case you didn't know, Blackboard and WebCT
have shown intent to merge their companies.  We started using Blackboard
recently (I'm no big fan of BB) but it may be interesting to see where
this merger goes.

I, too, built a custom student portal that pulled data from our AS400
student information system.  It was basic compared to BB, but it pleased
the majority of students and instructors.

That part of our intranet will be moved to BB next fall.

M!ke

 



   

  






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220962
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CF_Underground interview 2: Paper prototyping, MAX survey

2005-10-13 Thread Michael Smith
In this issue of ColdFusion conference and training news:

1. CF_Underground News - MAX and training survey
2. Class news - Management Seminar How to Build Websites Right, the First Time
3. Paper Prototyping interview with Simon Horwith

Happy coding
- Michael Smith,
   TeraTech, Inc  http://www.teratech.com/
   Creating excellent custom software since 1989

1. CF_Underground conference News
*
* Who is going to MAX and what training do you prefer? Take our MAX and training
survey at
http://www.cfconf.org/cf_underground7/survey.cfm
One lucky winner will be chosen at random to receive a $300 discount on a 
TeraTech
class or event of thier choice!

* The CF_Underground VII conference http://www.cfconf.org/cf_underground7/
   is 3 days away in Anaheim CA 10/15/05 before MAX

* Attendees will receive a CF_beer mug at the event


2. Class and certification news
***
Class schedule:

MS01  Management Seminar: How to Build Websites Right, the First Time Wed 11/2 
8am $49 (at TeraTech)
CS201H 4 day hands on CSS classTue-Fri 11/29 - 12/2/05 $1399 (at TeraTech)

More CF and Fusebox classes coming in January (dates to be announced)

More info and registration at
http://www.teratech.com/training/


3. Paper Prototyping interview with Simon Horwith
***
Michael Smith: Simon, this year at CF Underground you're talking about Paper
Prototyping.  Can you explain what paper prototyping is and why people should
come hear you talk about it?

Simon Horwith: Paper prototyping is a technique for wireframing (storyboarding)
sites, and is also useful for designing software and/or databases. Too many
developers aren't wireframing before development or even properly planning their
applications.  Paper prototyping is an easy and fun way to do that.

MS: So you're saying that anyone who attends CFUnderground will learn how to
design software and websites in your session?

SH: No, not at all.  There's no way to convey everything there is to software
architecture and design in a 50 minute presentation.  What I will do is convey
the importance of planning and demonstrate, or not demonstrate, one very
effective technique for planning an application.

MS: Not demonstrate?

SH: Well, I might demonstrate the technique, but I probably won't - that's not
as fun.

MS: Not as fun as what?

SH: Not as fun as not demonstrating what I'm talking about.

MS: I'm confused. You keep talking about having fun, or not having fun, without
explaining what you actually mean.  Is there something here that you're not
telling me?

SH: Yes. No. Kind of.

MS: Could you be more vague?

SH: Probably, but I'll stop pussyfooting around and elaborate.  Every year I
present at the CFUnderground conference.  I've made no secret of the fact that
it's most likely my favorite conference of the year.  The reason it's my
favorite is the relaxed one-on-one atmosphere that attendees get to share with
the presenters.  A contributing factor to that is the fact that presentations
are given the traditional way; without slides.  As a presenter I find this more
challenging and very fun.

That's not the fun I'm talking about, though.  This year I chose paper
prototyping because it will allow for real audience participation.  I wanted to
do something really different, so I'm not going to demo the technique - I'll
leave that to the attendees!  That's right - the audience will be guinea pigs on
this one.  The other reason I keep referring to the topic as fun is simply
because it really can be a lot of fun.  It's an excellent team building exercise
and a great way to not only plan an application but also open up channels for
communication between developers, project managers, and clients alike.

MS: So you're going to make your CFUnderground session an interactive event
unlike any we've seen before?  That does sound interesting… and fun!

SH: Oh it will be.  I promise that.  It'll be unlike any presentation I've ever
given.  I'm gonna excite the audience and wake them up… whether they like it or
not.  And trust me - they'll like it.

MS: Well, that does sound like a session that's not to be missed.  I'm looking
forward to hearing more about paper prototyping at CFUnderground… and to being
one of your guinea pigs.



*
CF_Underground VII
Sat 10/15/05
Anaheim CA
http://www.cfconf.org/CF_Underground7/
$69 before 9/30/05, $99 after
Includes lunch and drink
*




-- 
Michael Smith, TeraTech Inc - Tools for Programmers(tm)
TeraTech voted Best Consulting Service by CFDJ readers!
CF/ASP Web, VB, Math, Access programming tools and consulting
405 E Gude Dr Ste 207, Rockville MD 20850 USA
Please check out http://www.teratech.com/ - email mailto:[EMAIL PROTECTED],
or call us for more information; in the USA at 1-800-447-9120,
+1-301-424-3903 International, Fax 301-762-8185  Thanks!




RE: Recommend a good CF-based LMS/WBT Application?

2005-10-13 Thread Dawson, Michael
I'm not sure about it's past, but it is now .jsp.

M!ke 

-Original Message-
From: Alexander Sherwood [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 13, 2005 1:23 PM
To: CF-Talk
Subject: Re: Recommend a good CF-based LMS/WBT Application?

I know BB used to be CF-based, but it looks like it's JSP now, no?

--
Alex

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220964
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Merrimack and merry making!

2005-10-13 Thread Calvin Ward
Okay, does anyone else find the release of Merrimack and then 2 hotfixes and
the JDBC fix (making it four patches to be current) within a few short weeks
a bit much?
 
I wish we could get a single consistently updated rollup updater !


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220965
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF_Underground interview 2: Paper prototyping, MAX survey

2005-10-13 Thread Sean Corfield
On 10/13/05, Michael Smith [EMAIL PROTECTED] wrote:
 1. CF_Underground News - MAX and training survey

 1. CF_Underground conference News
 *
 * Who is going to MAX and what training do you prefer? Take our MAX and 
 training
 survey at
 http://www.cfconf.org/cf_underground7/survey.cfm

The survey thanks you for entering the CF_Underground *6* survey...
--
Sean A Corfield -- http://corfield.org/
Team Fusebox -- http://fusebox.org/
Got Gmail? -- I have 100, yes 100, invites to give away!

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220966
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Changing tag case

2005-10-13 Thread Rob
In situations like that, I've made XSLTs that are applied to the different
formats based on incoming URLs to make them into a common format. So when
you get another customer (or whatever) with yet another different format,
you only have write a new sheet and still only deal with your one common
format.

Or validate the XML file and tell everyone to use one XML file format - if
you have that power.

On 10/13/05, Helmut Doll [EMAIL PROTECTED] wrote:

 The data comes from different sources and is submitted to the CF app.
 I am currently doing a search and replace that changes individual
 tags when I notice a problem, but that is not scalable.
 I am looking for a (maybe regular expression) solution (it has to be
 in cf), that would find all xml tags in a file and make them lower case.

 Thanks for the suggestion,



--
~Blog~
http://www.robrohan.com
~The cfml plug-in for eclipse~
http://cfeclipse.tigris.org
~open source xslt IDE~
http://treebeard.sourceforge.net


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220967
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Changing tag case

2005-10-13 Thread Bobby Hartsfield
It seems like xls would be able to fix that for you without having to change
anything but here is a regex just the same...

Ill haven't tested this yet... but it looks right.

rereplacenocase(str, (.*?), \L\1:, all)
 
str = your xmlSTRING (not xmlparsed data)

xmlparse it AFTER you run the rereplace


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

-Original Message-
From: Helmut Doll [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 13, 2005 4:00 PM
To: CF-Talk
Subject: Re: Changing tag case

The data comes from different sources and is submitted to the CF app.
I am currently doing a search and replace that changes individual  
tags when I notice a problem, but that is not scalable.
I am looking for a (maybe regular expression) solution (it has to be  
in cf), that would find all xml tags in a file and make them lower case.

Thanks for the suggestion,

Helmut Doll
[EMAIL PROTECTED]

On Oct 13, 2005, at 3:33 PM, Justin D. Scott wrote:

 I need to parse and search xml data using coldfusion
 where tags are not always using the same case. (i.e.
 sometimes improvements and sometimes Improvements.
 While parsing is case-insensitive, xmlsearch is not.

 Is there a search and replace that would convert all
 tags to lowercase letters?


 Is there a reason for the inconsistency?  Is this data used by any  
 other
 applications?  If not, I would just run a search and replace on the  
 file
 outside of CF to make them all lowercase.  Then it becomes a non- 
 issue for
 CF and will save you a lot of time.

 If you do have to keep the source data the same, but need to walk  
 through
 the tags within CF, you can output the XML object as a string into a
 variable, SR on that variable using CF's functions to get the tags  
 to lower
 case, and finally read it back into an XML object again.


 -Justin Scott



 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220968
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFMAIL “type: text/plain; charset=UTF-8”

2005-10-13 Thread John Lucania
I am sending messages like below with CFMAIL.  The format is type: 
text/plain; charset=UTF-8.   A few messages were received with weird
formats.

It must be From:[EMAIL PROTECTED], but From: bomA.
It must be Subject: Discharge, but Subject:Dh{{ha{gma-t_2~A(_10a?

What might have caused this?

jl

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220969
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CFMAIL “type: text/plain; charset=UTF-8”

2005-10-13 Thread Bobby Hartsfield
A bot is a likely culprit

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

-Original Message-
From: John Lucania [mailto:[EMAIL PROTECTED] 
Sent: Thursday, October 13, 2005 7:30 PM
To: CF-Talk
Subject: CFMAIL  “type: text/plain; charset=UTF-8”

I am sending messages like below with CFMAIL.  The format is type: 
text/plain; charset=UTF-8.   A few messages were received with weird
formats.

It must be From:[EMAIL PROTECTED], but From: bomA.
It must be Subject: Discharge, but Subject:Dh{{ha{gma-t_2~A(_10a?

What might have caused this?

jl



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220970
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Changing tag case

2005-10-13 Thread Helmut Doll
That's the type of solution I had hoped for and it seems to work in  
my tests so far (the : seemed to cause a problem, but without it it  
worked well).

Thank you very much.

Helmut Doll.


On Oct 13, 2005, at 6:28 PM, Bobby Hartsfield wrote:

 It seems like xls would be able to fix that for you without having  
 to change
 anything but here is a regex just the same...

 Ill haven't tested this yet... but it looks right.

 rereplacenocase(str, (.*?), \L\1:, all)

 str = your xmlSTRING (not xmlparsed data)

 xmlparse it AFTER you run the rereplace


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

 -Original Message-
 From: Helmut Doll [mailto:[EMAIL PROTECTED]
 Sent: Thursday, October 13, 2005 4:00 PM
 To: CF-Talk
 Subject: Re: Changing tag case

 The data comes from different sources and is submitted to the CF app.
 I am currently doing a search and replace that changes individual
 tags when I notice a problem, but that is not scalable.
 I am looking for a (maybe regular expression) solution (it has to be
 in cf), that would find all xml tags in a file and make them lower  
 case.

 Thanks for the suggestion,

 Helmut Doll
 [EMAIL PROTECTED]

 On Oct 13, 2005, at 3:33 PM, Justin D. Scott wrote:


 I need to parse and search xml data using coldfusion
 where tags are not always using the same case. (i.e.
 sometimes improvements and sometimes Improvements.
 While parsing is case-insensitive, xmlsearch is not.

 Is there a search and replace that would convert all
 tags to lowercase letters?



 Is there a reason for the inconsistency?  Is this data used by any
 other
 applications?  If not, I would just run a search and replace on the
 file
 outside of CF to make them all lowercase.  Then it becomes a non-
 issue for
 CF and will save you a lot of time.

 If you do have to keep the source data the same, but need to walk
 through
 the tags within CF, you can output the XML object as a string into a
 variable, SR on that variable using CF's functions to get the tags
 to lower
 case, and finally read it back into an XML object again.


 -Justin Scott








 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220971
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFAJAX return types docco

2005-10-13 Thread James Holmes
OK will do. I am in the same boat - I'm learning JS on the run because
this AJAX stuff is too darn useful to ignore and CFAJAX is a really
nice tool.

On 10/14/05, Andy Matthews [EMAIL PROTECTED] wrote:
 I'd be interested as well. AJAX is something I've been wanting to start
 using more often, but I'm no javascript guy.

 !//--
 andy matthews
 web developer
 ICGLink, Inc.
 [EMAIL PROTECTED]
 615.370.1530 x737
 --//-

 -Original Message-
 From: James Holmes [mailto:[EMAIL PROTECTED]
 Sent: Thursday, October 13, 2005 1:54 AM
 To: CF-Talk
 Subject: Re: CFAJAX return types docco


 OK I've dug through the many examples and finally discovered the
 relatively simple structure that represents a query.

 Is anyone interested in me compiling the info on CFAJAX return types
 in a quick reference doc and posting/blogging it?

 On 10/5/05, James Holmes [EMAIL PROTECTED] wrote:
  Does anyone have a simple docco for the JS objects returned by CFAJAX
  for the corresponding CF types? I have arrays worked out (a
  no-brainer) but I haven't looked at, for example, what queries come
  back as.
 
  If soemone can save me reinventing the wheel, please let me know.
 


 --
 Geeque - accept the geek within and get your friends off your back -
 http://www.cafepress.com/geeque/



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220972
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


  1   2   >