Re: storing xml in sql

2003-08-20 Thread Kwang Suh
1) Using wddx is, well, a really bad idea.  How can you describe a product
using wddx?

2) Storing XML in a text field is, well, a bad idea.  Besides the obvious
performance implications, you're already running into problems with having
multiple pieces of data glommed into a big field.

Seems to me that you've actually lost functionality going the way you're
going.

I would at least create objects that represent a data layer that you can use
for CRUD operations to the database.  It would also make sense to create
objects that represent things like "product" that use the data layer for
attribute filling and functionality.  Your database would be set up in a
proper normalized fashion.  If you really do have 40 fields for products,
consider going all the way up to 5th normal form in your DB design.

- Original Message - 
From: "Alan Quinlan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 3:27 PM
Subject: storing xml in sql


> Somewhat OT but this is for a CF app and I thought it could be useful for
> others too.
>
> I'm in the processing of making a very flexible OO inventory app. The
basic
> rundown is this.
>
>
>
> You have a table in the DB called "Products". This is where you inventory
> goes. Now because this database is going to be used by several different
> e-commerce apps, it has to be flexible. App 1 may have a field called
> "MODEL" for the item data to go into the table.
>
> App2 might have a field called "YEAR", and etc. Now if I make new columns
> for every app, I'm going to end up with a products table with like 40
> columns. Sure that will work, but its not very organized, and there are
> things like, one product cant have more than one model, and etc.
>
>
>
> Instead I want to store the data as XML in a text field. Pretty simple
> right?
>
> I format the data using cfwddx. This way I can easily format the data as
it
> comes in and out of the database. It works great.
>
>
>
> But now I ran into a problem. What if I want to search by model? Say I
want
> all the items in the database that are model "XYZ". Well the only option I
> have it to search the xml text field for XYZ, but then I "could" get
double
> the number of fields I want if any other xml data has "XYZ" in it.
>
>
>
> Does anyone know of a good solution to this? Is there a way to search the
> specific xml fields while its still in the database? I've looked into the
> Microsoft OpenXML, but that seems overly complex.
>
>
> Any ideas would be great.
>
>
>
> Thanks,
>
> -Alan
>
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Time zone mask characters

2003-08-20 Thread Matthew Walker
I think the best solution might be to write a udf:

Function getTimeZone() {
Return ListLast(TimeFormat(Now(),"long")," ")
}

or you could write your own extraspecialtimeformat() function that applied
the regular timeformat() fn then replaced any "z" with the tz.


> -Original Message-
> From: Bill Henderson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 21 August 2003 1:16 p.m.
> To: CF-Talk
> Subject: RE: Time zone mask characters
> 
> Thanks, I was hoping that was not going to be the only way, because I
> would
> have to do it like this:
> 
> "#TimeFormat( Now( ),"HH:mm" )# #ListLast( TimeFormat( Now( ),"long" )," "
> )# "
> 
> In order return a string of "23:05 PDT" - And that seems a bit kludgy. I
> submitted a feature request to MM, although I believe that this would
> probably not be a commonly needed feature.
> 
> Bill Henderson
> [EMAIL PROTECTED]
> 
> -Original Message-
> From: Matthew Walker [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 3:16 PM
> To: CF-Talk
> Subject: RE: Time zone mask characters
> 
> You could use listlast(TimeFormat( Now( ),"long" ), " ") as a work around
> to
> get the time zone.
> 
> > -Original Message-
> > From: Bill Henderson [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, 21 August 2003 8:23 a.m.
> > To: CF-Talk
> > Subject: Time zone mask characters
> >
> > Hello All -
> >
> > When you do TimeFormat( Now( ),"long" ) or TimeFormat( Now( ),"full" )
> it
> > returns strings with the time zone at the end like so: 2:25:18 AM PDT.
> >
> > My question is, what are the mask characters to get the time zone to
> > display
> > if you don't use "long" or "full" as the mask? I can't find anything in
> > the
> > docs about it.
> >
> > More specifically, I want to show the date as 24 hour time, like this:
> > TimeFormat( Now( ),"HH:mm ZZ" ) with ZZ being the time zone.
> >
> >
> > Bill Henderson
> > [EMAIL PROTECTED]
> >
> >
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


DateDiff() broken in 6.1 (Bug?)

2003-08-20 Thread Johan Steenkamp
Can anyone else confirm that the datediff() function is broken in MX 6.1
compared with 6.0?

Simple test (code below) - output will show two consecutive dates with a
difference of  157 days i.e:
...
156
157
157
158
...

where it should be
...
156
157
158
159
...

Problem not evident on 6.0 (Windows or Linux).








 
 #i#. #date1# - #date2# =
#datediff("d",date1,date2)#




Johan Steenkamp
www.assetnow.com



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: CF in XSL, passing variables

2003-08-20 Thread jonhall
What do you mean by "xsl page"? Neither XSLT nor XSL-FO in and of
themselves have any concept of a url variable...

-- 
mailto:[EMAIL PROTECTED]
Wednesday, August 20, 2003, 7:44:15 PM, you wrote:

BRR> Hello all,

BRR> I am trying to pass an url variable from one xsl page to another and USE it.

BRR> How could I...

BRR> a.) invoke the url-variable in xsl..

BRR> OR

BRR> b.) output Cold Fusion in the XSL page, like..
BRR> #url.item#

BRR> this has gotten me NO replies in various XSL forums,
BRR> gawd - can't you pass a bloody variable in XSL, what a pain in the a**

BRR> all thanks - flashlight



BRR> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


UDF in CFC's - was: CFC Issues....

2003-08-20 Thread Paul Spitzer
>   
>   function boring() { return now(); }
>   


wow!.. I didn't know you could do that.  Is there *any* way to make them
private?  I noticed that the component documentation says all the arguments
are required, is it possible to declare which arguments are required and
which ones aren't?  What else can you do with this... playing with it, it
really doesn't seem very flexible, but I still have hope.


Paul  (wishing I could use script syntax for everything)



> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 2:33 PM
> To: CF-Talk
> Subject: RE: CFC Issues
>
>
> My blog entry talked about creating a UDF _inside_ a method, this is NOT
> the same as creating a UDF in a CFC. For example:
>
> 
>
>   
>   function boring() { return now(); }
>   
>
>   
>   
>   
>
> 
>
> This is perfectly valid. The only issue is that EVERY UDF defined, even
> cfscript ones, are considered methods. So "boring" will show up in the
> metadata. In general, you do not want to use cfscript, instead, use
> cffunction and mark the udfs as private so they can't be called from the
> outside.
> > > 
http://www.fusionauthority.com/signup.cfm

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Time zone mask characters

2003-08-20 Thread Bill Henderson
Thanks, I was hoping that was not going to be the only way, because I would
have to do it like this: 

"#TimeFormat( Now( ),"HH:mm" )# #ListLast( TimeFormat( Now( ),"long" )," "
)# " 

In order return a string of "23:05 PDT" - And that seems a bit kludgy. I
submitted a feature request to MM, although I believe that this would
probably not be a commonly needed feature.

Bill Henderson
[EMAIL PROTECTED]

-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 3:16 PM
To: CF-Talk
Subject: RE: Time zone mask characters

You could use listlast(TimeFormat( Now( ),"long" ), " ") as a work around to
get the time zone.

> -Original Message-
> From: Bill Henderson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 21 August 2003 8:23 a.m.
> To: CF-Talk
> Subject: Time zone mask characters
> 
> Hello All -
> 
> When you do TimeFormat( Now( ),"long" ) or TimeFormat( Now( ),"full" ) it
> returns strings with the time zone at the end like so: 2:25:18 AM PDT.
> 
> My question is, what are the mask characters to get the time zone to
> display
> if you don't use "long" or "full" as the mask? I can't find anything in
> the
> docs about it.
> 
> More specifically, I want to show the date as 24 hour time, like this:
> TimeFormat( Now( ),"HH:mm ZZ" ) with ZZ being the time zone.
> 
> 
> Bill Henderson
> [EMAIL PROTECTED]
> 
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Updating MDAC

2003-08-20 Thread Jim McAtee
We're runninng MDAC 2.5 SP3 on our CF5/IIS5 (Win2k) servers.  I was just
looking into updating this to the latest 2.7 SP1 version of MDAC.  These
servers are primarily using Access and MySQL through ODBC.

The following was found on Microsoft's download page for MDAC 2.7 SP1 download
page:

---
Starting with Microsoft Data Access Components (MDAC) version 2.6, MDAC no
longer contains Jet components. In other words, MDAC versions 2.6 and later do
not include Microsoft Jet, Microsoft Jet OLE DB Provider, and the ODBC Desktop
Database Drivers.
---

So, does this mean that updates 2.6 and later have no Access component,
therefore there's no real reason to update MDAC?  I've been burned before by
updating MDAC and losing support for older databases with no way to undo the
installation, so want to be very careful.

Thanks,
Jim

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


CF in XSL, passing variables

2003-08-20 Thread Bruce Rojas-Rennke
Hello all,

I am trying to pass an url variable from one xsl page to another and USE it.

How could I...

a.) invoke the url-variable in xsl..

OR

b.) output Cold Fusion in the XSL page, like..
#url.item#

this has gotten me NO replies in various XSL forums,
gawd - can't you pass a bloody variable in XSL, what a pain in the a**

all thanks - flashlight



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Formatting a List Output Question

2003-08-20 Thread Rafael Bleiweiss
>The  tags are what is responsible for indentation among list
>items.  So, you'd need to wrap the  tag around any  tags in order
>to get the inner indentation that you're looking for.  Of course, they'll
>also cause a space before and after the list itself, which may have been
>what you were trying to avoid.
>
>If that is true, then you have to choose:  Use  and accept the space;
>Don't use  and accept the out-dentation; create nested tables and a
>bullet graphic to force the issue.
>
>There might be a fourth option, to use CSS and somehow make your magic
>work, but that one is beyond me.


Yeah with CSS, you can do this with nested DIV tags, and such, however then 
you need to
spend your precious time dealing with all the cross-browser 
incompatabilities due to the current state of
poorly implemented CSS rules because EVERY major browser out there has at 
least some bugs in how
it handles CSS...   for example the "Box model" fiasco and Internet 
Explorer... just to name ONE issue.



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: .cfc's and application.cfm file

2003-08-20 Thread S . Isaac Dealey
Ahhh ... good to know, thanks. :)

seems kinda odd that it'd become an external call when using
this scope...

> Not exactly. If you use "this.foo()", it acts as an
> 'external' call, in
> other words, if foo() is private, you will get an error.

> ==
> ==
> ===
> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> (www.mindseye.com)
> Member of Team Macromedia
> (http://www.macromedia.com/go/teammacromedia)

> Email: [EMAIL PROTECTED]
> Blog : www.camdenfamily.com/morpheus/blog
> Yahoo IM : morpheus

> "My ally is the Force, and a powerful ally it is." - Yoda

>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, August 20, 2003 2:37 PM
>> To: CF-Talk
>> Subject: RE: .cfc's and application.cfm file
>>
>>
>> Or  if you really feel like scoping
>> it. :)
>>
>>
>> -- Original Message --
>> From: Raymond Camden <[EMAIL PROTECTED]>
>> To: CF-Talk <[EMAIL PROTECTED]>
>> Sent: Aug 20, 2003 02:39 PM
>> Subject: RE: .cfc's and application.cfm file
>>
>> >Are you asking if one method in a cfc can call another?
>> >Yes.
>> If you are
>> >in method A, for example, and want to call B, you can
>> >easily do:
>> >
>> >
>> >
>> >
>> >
>> >=
>> ==
>> >=
>> >===
>> >Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
>> >(www.mindseye.com)
>> >Member of Team Macromedia
>> (http://www.macromedia.com/go/teammacromedia)
>> >
>> >Email: [EMAIL PROTECTED]
>> >Blog : www.camdenfamily.com/morpheus/blog
>> >Yahoo IM : morpheus
>> >
>> >"My ally is the Force, and a powerful ally it is." -
>> >Yoda
>> >
>> >> -Original Message-
>> >> From: Tony Weeg [mailto:[EMAIL PROTECTED]
>> >> Sent: Wednesday, August 20, 2003 12:56 PM
>> >> To: CF-Talk
>> >> Subject: RE: .cfc's and application.cfm file
>> >>
>> >>
>> >> so how about...
>> >>
>> >> can I make the functionality a cffuntion inside my
>> >> cfcomponent and
>> >> call one cffuntion from within another?
>> >>
>> >> tony weeg
>> >> uncertified advanced cold fusion developer
>> >> tony at navtrak dot net
>> >> www.navtrak.net
>> >> office 410.548.2337
>> >> fax 410.860.2337
>> >>
>> >>
>> >> -Original Message-
>> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> >> Sent: Wednesday, August 20, 2003 2:51 PM
>> >> To: CF-Talk
>> >> Subject: Re: .cfc's and application.cfm file
>> >>
>> >>
>> >> Errr... I didn't think CFC's were supposed to inherit
>> UDF's... except
>> >> from other CFC's...
>> >>
>> >> You can however attach the existing UDF to the CFC
>> >> like this afaik:
>> >>
>> >> 
>> >>
>> >> Although you may need to store the UDF in another
>> >> scope first, so
>> >> more
>> >> like:
>> >>
>> >> ...
>> >> 
>> >>
>> >> ...
>> >>
>> >> 
>> >>
>> >> hth
>> >>
>> >> Isaac
>> >>
>> >>
>> >> -- Original Message --
>> >> From: Tony Weeg <[EMAIL PROTECTED]>
>> >> To: CF-Talk <[EMAIL PROTECTED]>
>> >> Sent: Aug 20, 2003 01:26 PM
>> >> Subject: Re: .cfc's and application.cfm file
>> >>
>> >> >if I have a udf in my application.cfm file, why
>> >> >doesn't a
>> cfc in the
>> >> >same dir inherit the udf function from it?
>> >> >
>> >> >thanks!
>> >> >
>> >> >tony weeg
>> >> >uncertified advanced cold fusion developer
>> >> >tony at navtrak dot net
>> >> >www.navtrak.net
>> >> >office 410.548.2337
>> >> >fax 410.860.2337
>> >> >
>> >> >
>> >>
>> >>
>> >
>>
> ~~
> ~~~|
> Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
> Subscription:
> http://www.houseoffusion.com/lists.cfm?link=s:4
> Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubsc
> ribe.cfm?user=633.558.4

> Signup for the Fusion Authority news alert and keep up
> with the latest news in ColdFusion and related topics.
> http://www.fusionauthority.com/signup.cfm



s. isaac dealey972-490-6624

team macromedia volunteer
http://www.macromedia.com/go/team

chief architect, tapestry cms  http://products.turnkey.to

onTap is open source   http://www.turnkey.to/ontap


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: CFC Issues....

2003-08-20 Thread Bryan F. Hogan
So the following should work?


















Abviously this is not a usable example it just illistrates what I'm talking
about.

By creating a UDF inside a cfc and trying to use it in the same cfc I get
the exact same error that Tony gets with any UDF.

- Original Message - 
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 5:32 PM
Subject: RE: CFC Issues


> My blog entry talked about creating a UDF _inside_ a method, this is NOT
> the same as creating a UDF in a CFC. For example:
>
> 
>
> 
> function boring() { return now(); }
> 
>
> 
> 
> 
>
> 
>
> This is perfectly valid. The only issue is that EVERY UDF defined, even
> cfscript ones, are considered methods. So "boring" will show up in the
> metadata. In general, you do not want to use cfscript, instead, use
> cffunction and mark the udfs as private so they can't be called from the
> outside.
>
> 
> ===
> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> (www.mindseye.com)
> Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
>
> Email: [EMAIL PROTECTED]
> Blog : www.camdenfamily.com/morpheus/blog
> Yahoo IM : morpheus
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, August 20, 2003 3:10 PM
> > To: CF-Talk
> > Subject: RE: CFC Issues
> >
> >
> > I have always recieved this same problem while trying to
> > create a UDF and use a UDF in the same CFC. I thought that it
> > wasn't allowed. See this entry:
> > http://www.camdenfamily.com/morpheus/blog/index.cfm?mode=entry
> > &entry=130
> > from Ray.
> >
> >
> > -Original Message-
> > From: Sean A Corfield [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, August 20, 2003 3:50 PM
> > To: CF-Talk
> > Subject: Re: CFC Issues
> >
> >
> > Show us yer code Weeg!! :)
> >
> > On Wednesday, Aug 20, 2003, at 10:30 US/Pacific, Tony Weeg wrote:
> >
> > > what could this possibly mean?
> > >
> > > the code works perfect outside of the cfc, but now it
> > doesn't inside
> > > the cfc?
> > >
> > > Unable to complete CFML to Java translation.
> > > Error information unsupported statement: class
> > > coldfusion.compiler.ASTfunctionDefinition
> > >
> > > The error occurred in C:\Inetpub\wwwroot\cf~permissionsConsume.cfm:
> > > line
> > > 15
> > >
> > > 13 :> > 14 : name="featureBit"
> > > 15 : value="#featureBit#">
> > > 16 :
> > > 17 : 
> > >
> > >
> > >
> > >
> > --
> > > -
> > > -
> > > 
> > >
> > > Please try the following:
> > > Check the ColdFusion documentation to verify that you are using the
> > > correct syntax. Search the Knowledge Base to find a
> > solution to your
> > > problem.
> > >
> > >
> > > Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
> > 5.1; .NET CLR
> > > 1.1.4322)
> > > Remote Address   10.10.11.186
> > > Referrer
> > > Date/Time   20-Aug-03 01:29 PM
> > >
> > > Stack Trace (click to expand)
> > >
> > >
> > > tony weeg
> > > uncertified advanced cold fusion developer
> > > tony at navtrak dot net
> > > www.navtrak.net
> > > office 410.548.2337
> > > fax 410.860.2337
> >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Access issue in CF6.1

2003-08-20 Thread chris petersen
I posted this to the webforums a few weeks back, but never really got a
definitive solution. Perhaps someone here knows the solution:
 
Can anyone explain why when using remoting to connect to CF 6.0 I get
dates returned as 'Wed Aug 6 12:15:00 GMT-0700 2003', which is perfect
with me, but using CF6.1, I get dates back formatted '2003-07-31
01:00:00'? Is 6.1 converting my longs to mediums?


Below is a basic sample created entirely for the purpose of
demonstrating the change. I compare CF6.0, CF6.1 to MSAccess and MySQL.
I would upgrade the data to SQL and solve the prob, but my client
insists on using Access. Sigh.
 
-=-=-=-=-=-=- CFC





SELECT * 
FROM myTABLE
WHERE myTABLE_ID = 550





-=-=-=-=-=-=- Flash

#include "NetServices.as"
#include "NetDebug.as"

cnn0 =
NetServices.createGatewayConnection("http://67.115.131.211:8500/flashser
vices/gateway");
svc0 = cnn0.getService("eomp.com.DateService");
svc0.querySomeDate( { onResult: function(result) { trace("CFMX6.0: " +
result.items[0].OMP_Date); } } );

cnn1 =
NetServices.createGatewayConnection("http://127.0.0.1:8500/flashservices
/gateway");
svc1 = cnn1.getService("eomp.com.DateService");
svc1.querySomeDate( { onResult: function(result) { trace("CFMX6.1: " +
result.items[0].OMP_Date); } } );

-=-=-=-=-=-=- Trace Output:
 
CFMX6.0/Access: Sat Jun 14 20:15:00 GMT-0700 2003
CFMX6.1/mySQL: Thu Aug 7 13:34:00 GMT-0700 2003
CFMX6.1/Access: 2003-06-14 22:15:00


-=-=-=-=-=-=- END
 

So it appears that Access is the culprit, as SQL returns a proper 'long'
date in 6.1. Wonder why Access is returning different output all of a
sudden? Does 6.1 use a different driver for Access? If so, how do I
update it so it works proper?
 
 
Thanks in advance for any assistance.
 


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Time zone mask characters

2003-08-20 Thread Matthew Walker
You could use listlast(TimeFormat( Now( ),"long" ), " ") as a work around to
get the time zone.

> -Original Message-
> From: Bill Henderson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 21 August 2003 8:23 a.m.
> To: CF-Talk
> Subject: Time zone mask characters
> 
> Hello All -
> 
> When you do TimeFormat( Now( ),"long" ) or TimeFormat( Now( ),"full" ) it
> returns strings with the time zone at the end like so: 2:25:18 AM PDT.
> 
> My question is, what are the mask characters to get the time zone to
> display
> if you don't use "long" or "full" as the mask? I can't find anything in
> the
> docs about it.
> 
> More specifically, I want to show the date as 24 hour time, like this:
> TimeFormat( Now( ),"HH:mm ZZ" ) with ZZ being the time zone.
> 
> 
> Bill Henderson
> [EMAIL PROTECTED]
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


cf4.5.1 and CFMX

2003-08-20 Thread Ramesh Deva
Hi,

Here I have installed two versions of coldfusion (CF4.5.1 and CFMX) 

But it 4.5.1 is working fine with 

http://localhost/login.cfm   (going thru IIS here)

using path : c:\inetpub\wwwroot\

and even CFMX (6.0) version is also working fine. 

http://localhost:8500/login.cfm

using path : c:\CfusionMX\wwwroot\

so here I would like to avoid to use 8500 when I use cfmx version. Becos I
want to go thru IIS only here. So is there any command we have where we can
internally switch from cf4.5.1 to CFMX version when I want to use cfmx
version url.

(note : I want to run both versions in my machines since some times I need
to work on cf4.5 and some times I need to work on CFMX version.)


Appreciate your great ideas...



thanks
Ramesh





~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: .cfc's and application.cfm file

2003-08-20 Thread Raymond Camden
Not exactly. If you use "this.foo()", it acts as an 'external' call, in
other words, if foo() is private, you will get an error.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 20, 2003 2:37 PM
> To: CF-Talk
> Subject: RE: .cfc's and application.cfm file
> 
> 
> Or  if you really feel like scoping it. :) 
> 
> 
> -- Original Message -- 
> From: Raymond Camden <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Aug 20, 2003 02:39 PM
> Subject: RE: .cfc's and application.cfm file
> 
> >Are you asking if one method in a cfc can call another? Yes. 
> If you are 
> >in method A, for example, and want to call B, you can easily do:
> >
> >
> >
> >
> >=
> ==
> >=
> >===
> >Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> >(www.mindseye.com)
> >Member of Team Macromedia 
> (http://www.macromedia.com/go/teammacromedia)
> >
> >Email: [EMAIL PROTECTED]
> >Blog : www.camdenfamily.com/morpheus/blog
> >Yahoo IM : morpheus
> >
> >"My ally is the Force, and a powerful ally it is." - Yoda
> >
> >> -Original Message-
> >> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> >> Sent: Wednesday, August 20, 2003 12:56 PM
> >> To: CF-Talk
> >> Subject: RE: .cfc's and application.cfm file
> >>
> >>
> >> so how about...
> >>
> >> can I make the functionality a cffuntion inside my cfcomponent and 
> >> call one cffuntion from within another?
> >>
> >> tony weeg
> >> uncertified advanced cold fusion developer
> >> tony at navtrak dot net
> >> www.navtrak.net
> >> office 410.548.2337
> >> fax 410.860.2337
> >>
> >>
> >> -Original Message-
> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> >> Sent: Wednesday, August 20, 2003 2:51 PM
> >> To: CF-Talk
> >> Subject: Re: .cfc's and application.cfm file
> >>
> >>
> >> Errr... I didn't think CFC's were supposed to inherit 
> UDF's... except 
> >> from other CFC's...
> >>
> >> You can however attach the existing UDF to the CFC like this afaik:
> >>
> >> 
> >>
> >> Although you may need to store the UDF in another scope first, so 
> >> more
> >> like:
> >>
> >> ...
> >> 
> >>
> >> ...
> >>
> >> 
> >>
> >> hth
> >>
> >> Isaac
> >>
> >>
> >> -- Original Message --
> >> From: Tony Weeg <[EMAIL PROTECTED]>
> >> To: CF-Talk <[EMAIL PROTECTED]>
> >> Sent: Aug 20, 2003 01:26 PM
> >> Subject: Re: .cfc's and application.cfm file
> >>
> >> >if I have a udf in my application.cfm file, why doesn't a 
> cfc in the 
> >> >same dir inherit the udf function from it?
> >> >
> >> >thanks!
> >> >
> >> >tony weeg
> >> >uncertified advanced cold fusion developer
> >> >tony at navtrak dot net
> >> >www.navtrak.net
> >> >office 410.548.2337
> >> >fax 410.860.2337
> >> >
> >> >
> >>
> >>
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: homesite help

2003-08-20 Thread Patricia G. L. Hall
I don't think there has been an update to the Homesite+ Help CFML
Reference book.  I looked all over the place on Macromedia, searched the
archives of this list and posted my own question.  I got nothing.

-Patti

> Hello all,
>
> I downloaded the HomesiteTags.zip and HomeSiteExtensions.zip and unzipped
> into my homesite root directory... I still don't see the new red sky tags
> in
> my help menu.  I do see it on the tag completion however.  What am I
> forgetting?
>
> Thanks,
> Tim
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: CFC Issues....

2003-08-20 Thread Raymond Camden
My blog entry talked about creating a UDF _inside_ a method, this is NOT
the same as creating a UDF in a CFC. For example:




function boring() { return now(); }








This is perfectly valid. The only issue is that EVERY UDF defined, even
cfscript ones, are considered methods. So "boring" will show up in the
metadata. In general, you do not want to use cfscript, instead, use
cffunction and mark the udfs as private so they can't be called from the
outside.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 20, 2003 3:10 PM
> To: CF-Talk
> Subject: RE: CFC Issues
> 
> 
> I have always recieved this same problem while trying to 
> create a UDF and use a UDF in the same CFC. I thought that it 
> wasn't allowed. See this entry: 
> http://www.camdenfamily.com/morpheus/blog/index.cfm?mode=entry
> &entry=130
> from Ray.
> 
> 
> -Original Message-
> From: Sean A Corfield [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 3:50 PM
> To: CF-Talk
> Subject: Re: CFC Issues
> 
> 
> Show us yer code Weeg!! :)
> 
> On Wednesday, Aug 20, 2003, at 10:30 US/Pacific, Tony Weeg wrote:
> 
> > what could this possibly mean?
> >
> > the code works perfect outside of the cfc, but now it 
> doesn't inside 
> > the cfc?
> >
> > Unable to complete CFML to Java translation.
> > Error information unsupported statement: class 
> > coldfusion.compiler.ASTfunctionDefinition
> >
> > The error occurred in C:\Inetpub\wwwroot\cf~permissionsConsume.cfm:
> > line
> > 15
> >
> > 13 :> 14 : name="featureBit"
> > 15 : value="#featureBit#">
> > 16 :
> > 17 : 
> >
> >
> >
> > 
> --
> > -
> > -
> > 
> >
> > Please try the following:
> > Check the ColdFusion documentation to verify that you are using the 
> > correct syntax. Search the Knowledge Base to find a 
> solution to your 
> > problem.
> >
> >
> > Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 
> 5.1; .NET CLR
> > 1.1.4322)
> > Remote Address   10.10.11.186
> > Referrer
> > Date/Time   20-Aug-03 01:29 PM
> >
> > Stack Trace (click to expand)
> >
> >
> > tony weeg
> > uncertified advanced cold fusion developer
> > tony at navtrak dot net
> > www.navtrak.net
> > office 410.548.2337
> > fax 410.860.2337
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: .cfc's and application.cfm file

2003-08-20 Thread info
Or  if you really feel like scoping it. :) 


-- Original Message -- 
From: Raymond Camden <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 20, 2003 02:39 PM
Subject: RE: .cfc's and application.cfm file

>Are you asking if one method in a cfc can call another? Yes. If you are
>in method A, for example, and want to call B, you can easily do:
>
>
>
>
>
>===
>Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
>(www.mindseye.com)
>Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
>
>Email: [EMAIL PROTECTED]
>Blog : www.camdenfamily.com/morpheus/blog
>Yahoo IM : morpheus
>
>"My ally is the Force, and a powerful ally it is." - Yoda
>
>> -Original Message-
>> From: Tony Weeg [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, August 20, 2003 12:56 PM
>> To: CF-Talk
>> Subject: RE: .cfc's and application.cfm file
>>
>>
>> so how about...
>>
>> can I make the functionality a cffuntion inside my
>> cfcomponent and call one cffuntion from within another?
>>
>> tony weeg
>> uncertified advanced cold fusion developer
>> tony at navtrak dot net
>> www.navtrak.net
>> office 410.548.2337
>> fax 410.860.2337
>>
>>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, August 20, 2003 2:51 PM
>> To: CF-Talk
>> Subject: Re: .cfc's and application.cfm file
>>
>>
>> Errr... I didn't think CFC's were supposed to inherit
>> UDF's... except from other CFC's...
>>
>> You can however attach the existing UDF to the CFC like this afaik:
>>
>> 
>>
>> Although you may need to store the UDF in another scope first, so more
>> like:
>>
>> ...
>> 
>>
>> ...
>>
>> 
>>
>> hth
>>
>> Isaac
>>
>>
>> -- Original Message --
>> From: Tony Weeg <[EMAIL PROTECTED]>
>> To: CF-Talk <[EMAIL PROTECTED]>
>> Sent: Aug 20, 2003 01:26 PM
>> Subject: Re: .cfc's and application.cfm file
>>
>> >if I have a udf in my application.cfm file, why doesn't a cfc in the
>> >same dir inherit the udf function from it?
>> >
>> >thanks!
>> >
>> >tony weeg
>> >uncertified advanced cold fusion developer
>> >tony at navtrak dot net
>> >www.navtrak.net
>> >office 410.548.2337
>> >fax 410.860.2337
>> >
>> >
>>
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: homesite help

2003-08-20 Thread Tim Do
The contents of the zip contains only vtm & htm files... I see booktree.xml
under the help directory along with cfml_reference folder... I'm not clear
on what you mean by just unzipping to the help directory.  I see the
unzipped files under my Extensions\Docs\CFMLTags

Thanks
-Original Message-
From: John Cummings [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 12:09 PM
To: CF-Talk
Subject: RE: homesite help


To get the language reference to show up in the help "books" tree, the docs
need to be unzipped inside the "Help" directory.The folder that you
unzip them to beneath "Help" becomes the title of the "book" in your help
tree.

HTH,
JC

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 2:28 PM
To: CF-Talk
Subject: homesite help

Hello all,
 
I downloaded the HomesiteTags.zip and HomeSiteExtensions.zip and unzipped
into my homesite root directory... I still don't see the new red sky tags in
my help menu.  I do see it on the tag completion however.  What am I
forgetting?
 
Thanks,
Tim
 
 
 



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: homesite help

2003-08-20 Thread Christine Lawson
Hi Tim,
It's a bug with the file, we're aware of the issue and are working on it as we speak. 
I'll post to the list when we release the new files.

Best Regards,
Christine

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 2:28 PM
To: CF-Talk
Subject: homesite help


Hello all,
 
I downloaded the HomesiteTags.zip and HomeSiteExtensions.zip and unzipped into my 
homesite root directory... I still don't see the new red sky tags in my help menu.  I 
do see it on the tag completion however.  What am I forgetting?
 
Thanks,
Tim
 
 
 


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Formatting a List Output Question

2003-08-20 Thread Patricia G. L. Hall
The  tags are what is responsible for indentation among list
items.  So, you'd need to wrap the  tag around any  tags in order
to get the inner indentation that you're looking for.  Of course, they'll
also cause a space before and after the list itself, which may have been
what you were trying to avoid.

If that is true, then you have to choose:  Use  and accept the space;
Don't use  and accept the out-dentation; create nested tables and a
bullet graphic to force the issue.

There might be a fourth option, to use CSS and somehow make your magic
work, but that one is beyond me.

-Patti

> Morning,
>
> Got a list problem that's driving me crazy!  This is probably more a CSS
> question than Cold Fusion
>
> I'm trying to output the results of a query into a list. No problems
> there,
> but the formatting is driving me nutz.  The list wraps wrong.  What I'm
> getting (using a "*" as the bullet for example here only...
>
> * Item One
> * Item Two is long
> and wraps under the bullet
> *Item Three is long
> and wraps under the bullet
>
> What I'm trying to get:
>
> * Item One
> * Item Two is long
>   and wraps this way
> * Item Three is long
>   and wraps this way
>
> So, shouldn't the below do what I want?
>
> 
>   
> outside;>#deals.PA_CATEGORY#
>   
> 
>
> Of course, I could use a graphic and a two column tablebut that
> doesn't
> seem like the best way to go...
>
> I've tried all sorts of CSS tricks, but nothing seems to fix the problem.
> Ideas?
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: CFC Issues....

2003-08-20 Thread Bryan F. Hogan
I have always recieved this same problem while trying to create a UDF and
use a UDF in the same CFC. I thought that it wasn't allowed. See this entry:
http://www.camdenfamily.com/morpheus/blog/index.cfm?mode=entry&entry=130
from Ray.


-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:50 PM
To: CF-Talk
Subject: Re: CFC Issues


Show us yer code Weeg!! :)

On Wednesday, Aug 20, 2003, at 10:30 US/Pacific, Tony Weeg wrote:

> what could this possibly mean?
>
> the code works perfect outside of the cfc, but now it doesn't inside
> the
> cfc?
>
> Unable to complete CFML to Java translation.
> Error information unsupported statement: class
> coldfusion.compiler.ASTfunctionDefinition
>
> The error occurred in C:\Inetpub\wwwroot\cf~permissionsConsume.cfm:
> line
> 15
>
> 13 :14 : name="featureBit"
> 15 : value="#featureBit#">
> 16 :
> 17 : 
>
>
>
> ---
> -
> 
>
> Please try the following:
> Check the ColdFusion documentation to verify that you are using the
> correct syntax.
> Search the Knowledge Base to find a solution to your problem.
>
>
> Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR
> 1.1.4322)
> Remote Address   10.10.11.186
> Referrer
> Date/Time   20-Aug-03 01:29 PM
>
> Stack Trace (click to expand)
>
>
> tony weeg
> uncertified advanced cold fusion developer
> tony at navtrak dot net
> www.navtrak.net
> office 410.548.2337
> fax 410.860.2337


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


J2EE CFMX install error

2003-08-20 Thread Heald, Tim
When we get the point where we should be brought to the administrator, after
the install, we get an error:

No such role cfadmin84f49b8e2fd010bc479ba763218432c4

anyone see this before?

Timothy Heald
Information Systems Specialist
Overseas Security Advisory Council
U.S. Department of State
571.345.2235

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


storing xml in sql

2003-08-20 Thread Alan Quinlan
Somewhat OT but this is for a CF app and I thought it could be useful for
others too.

I'm in the processing of making a very flexible OO inventory app. The basic
rundown is this.

 

You have a table in the DB called "Products". This is where you inventory
goes. Now because this database is going to be used by several different
e-commerce apps, it has to be flexible. App 1 may have a field called
"MODEL" for the item data to go into the table.

App2 might have a field called "YEAR", and etc. Now if I make new columns
for every app, I'm going to end up with a products table with like 40
columns. Sure that will work, but its not very organized, and there are
things like, one product cant have more than one model, and etc.

 

Instead I want to store the data as XML in a text field. Pretty simple
right?

I format the data using cfwddx. This way I can easily format the data as it
comes in and out of the database. It works great.

 

But now I ran into a problem. What if I want to search by model? Say I want
all the items in the database that are model "XYZ". Well the only option I
have it to search the xml text field for XYZ, but then I "could" get double
the number of fields I want if any other xml data has "XYZ" in it.

 

Does anyone know of a good solution to this? Is there a way to search the
specific xml fields while its still in the database? I've looked into the
Microsoft OpenXML, but that seems overly complex.


Any ideas would be great.

 

Thanks,

-Alan 

 


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: What's wrong with Tuesday and Thursdays???

2003-08-20 Thread info
When you insert your dates into the query, convert them to odbcdate time values first 
by stripping the day of week and the time zone like this (if you need the time zone, 
put it in a separate column): 

createodbcdatetime(rereplace(thedate,"^[^,]*,[[:space:]]*(.*)[[:space:]]*[[:alpha:]]{2,2}T[[:space:]]*$","\1"))

If that doesn't work, specify individual column names and use a filter on the date 
with cfqueryparam like: 

where pubdate < 

hth

Isaac 

-- Original Message -- 
From: James Edmunds <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 20, 2003 02:24 PM
Subject: Re: What's wrong with Tuesday and Thursdays???

>I have two templates of code that concatenate and display two XML files
>in RSS 2.0 format, identical except that one of them calls an RSS XML
>file that has dates whose day of the week begin with a "T", and chokes!
>It stops with a database exception, with this error message:
>Can't convert the string Tue, 23 Sep 2003 00:00:00 CDT to java type DATE
>(In earlier tests, I have had this same stop at Thu dates)
>
>You can navigate to each of these with these URLs, and you'll note the
>CFDUMPs and Error reporting:
>
>The one that works:
>
>http://www.jamesedmunds.com/rssgetYES.cfm
>
>The one that doesn't:
>
>http://www.jamesedmunds.com/rssgetNO.cfm
>
>Below my signature, the code for each. Thanks in advance for anyone with
>insight into this issue, which seems to have to do with the way the
>dates are read in the database engine. I am getting these errors in CFMX
>(what we would now call 6.0) through shared hosting on CrystalTech, as
>well as locally testing on CFMX 6.1.
>
>Best to all,
>
>James Edmunds
>-
>CODE FOR RSSGETYES.CFM:
>
>
>http://lapresenters.org/rss/lajazdanz.xml"; method="get">
>
>
>
>
>
>
>
>
>QuerySetCell(myQuery,'Title',myDoc.rss.channel.item[idx].Title.XMLText)>
>QuerySetCell(myQuery,'Link',myDoc.rss.channel.item[idx].Link.XMLText)>
>QuerySetCell(myQuery,'Description',myDoc.rss.channel.item[idx].Description.XMLText)>
>QuerySetCell(myQuery,'pubDate',myDoc.rss.channel.item[idx].pubDate.XMLText)>
>
>
>
>
>
>
>
>http://www.lapresenters.org/rss/PrincessTheaterInc.xml";
>method="get">
>
>
>
>
>
>
>QuerySetCell(myQuery2,'Title',myDoc.rss.channel.item[idx].Title.XMLText)>
>QuerySetCell(myQuery2,'Link',myDoc.rss.channel.item[idx].Link.XMLText)>
>QuerySetCell(myQuery2,'Description',myDoc.rss.channel.item[idx].Description.XMLText)>
>
>QuerySetCell(myQuery2,'pubDate',myDoc.rss.channel.item[idx].pubdate.XMLText)>
>
>
>
>
>
>
>
>
>  SELECT * FROM MyQuery
>  UNION
>  SELECT * FROM MyQuery2
>  ORDER BY pubDate
>
>
>
>XML
>  Parsed and combined listings
>  from two different web site sources
>  
>  
>
>
>
> 
>
>
>    href="#link#">#title#
>  #description#
>  
>
>  
>  
>
>
>Didn't happen. A #cfcatch.type# exception occurred.
>#cfcatch.message# #cfcatch.Detail#
>
>
>
>
>
>
>
>END OF CODE FOR RESSGETYES.CFM==
>+
>CODE FOR RSSGETNO.CFM:
>
>
>http://pasa-online.org/rss/pasa.xml"; method="get">
>
>
>
>
>
>
>
>
>QuerySetCell(myQuery,'Title',myDoc.rss.channel.item[idx].Title.XMLText)>
>QuerySetCell(myQuery,'Link',myDoc.rss.channel.item[idx].Link.XMLText)>
>QuerySetCell(myQuery,'Description',myDoc.rss.channel.item[idx].Description.XMLText)>
>QuerySetCell(myQuery,'pubDate',myDoc.rss.channel.item[idx].pubDate.XMLText)>
>
>
>
>
>
>
>
>http://www.lapresenters.org/rss/PrincessTheaterInc.xml";
>method="get">
>
>
>
>
>
>
>QuerySetCell(myQuery2,'Title',myDoc.rss.channel.item[idx].Title.XMLText)>
>QuerySetCell(myQuery2,'Link',myDoc.rss.channel.item[idx].Link.XMLText)>
>QuerySetCell(myQuery2,'Description',myDoc.rss.channel.item[idx].Description.XMLText)>
>
>QuerySetCell(myQuery2,'pubDate',myDoc.rss.channel.item[idx].pubdate.XMLText)>
>
>
>
>
>
>
>
>
>  SELECT * FROM MyQuery
>  UNION
>  SELECT * FROM MyQuery2
>  ORDER BY pubDate
>
>
>
>XML
>  Parsed and combined listings
>  from two different web site sources
>  
>  
>
>
>
>
>
>
>    href="#link#">#title#
>  #description#
>  
>
>  
>  
>
>
>Didn't happen. A #cfcatch.type# exception occurred.
>#cfcatch.message# #cfcatch.Detail#
>
>
>
>
>
>
>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: CFC Issues....

2003-08-20 Thread Sean A Corfield
Show us yer code Weeg!! :)

On Wednesday, Aug 20, 2003, at 10:30 US/Pacific, Tony Weeg wrote:

> what could this possibly mean?
>
> the code works perfect outside of the cfc, but now it doesn't inside  
> the
> cfc?
>
> Unable to complete CFML to Java translation.
> Error information unsupported statement: class
> coldfusion.compiler.ASTfunctionDefinition
>
> The error occurred in C:\Inetpub\wwwroot\cf~permissionsConsume.cfm:  
> line
> 15
>
> 13 :14 : name="featureBit"
> 15 : value="#featureBit#">
> 16 :  
> 17 : 
>
>
>
> --- 
> -
> 
>
> Please try the following:
> Check the ColdFusion documentation to verify that you are using the
> correct syntax.
> Search the Knowledge Base to find a solution to your problem.
>
>
> Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR
> 1.1.4322)
> Remote Address   10.10.11.186
> Referrer
> Date/Time   20-Aug-03 01:29 PM
>
> Stack Trace (click to expand)
>
>
> tony weeg
> uncertified advanced cold fusion developer
> tony at navtrak dot net
> www.navtrak.net
> office 410.548.2337
> fax 410.860.2337

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Can CF Detect a Win32 Service?

2003-08-20 Thread Ryan Emerle
There are CFX tags that will allow interaction and listing of services and their 
states (CFX_Service is one).

Or, you can CFEXECUTE "net start" to get a list of started services (then "net start 
" or "net stop ")

Depends on what you are trying to do..

-Original Message-
From: David Adams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:01 PM
To: CF-Talk
Subject: Can CF Detect a Win32 Service?


Is it possible to build a service control interface with CF?  I need to detect the 
status 
of a service.

Hope someone can comment.
Dave Adams



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: XML/XPATH

2003-08-20 Thread Massimo Foti
"Ian Skinner" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Is there a way to get a single, modified XML document/structure?

You have many options, the easier should be:

1) XSLT

2) Serialize the node in the NodeList and build a new XML document from
there


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Can CF Detect a Win32 Service?

2003-08-20 Thread Mike Townend
On the CoolFusion.com site there is a cfx_servicecontrol tag that allows you
to monitor/start/stop service 

HTH

Mikey



-Original Message-
From: David Adams [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 20:01
To: CF-Talk
Subject: Can CF Detect a Win32 Service?


Is it possible to build a service control interface with CF?  I need to
detect the status 
of a service.

Hope someone can comment.
Dave Adams



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: Can CF Detect a Win32 Service?

2003-08-20 Thread jon hall
The standard way to check a Win32 service is ADSI. Since ADSI doesn't
have a standard COM interface even though it acts like it, it couldn't
be accessed from CF previous to MX.

However...since JIntegra does have support for ADSI, I'm thinking MX
just might be able to talk to active directory.
http://www.intrinsyc.com/support/j-integra/doc/other_examples/Creating_an_NT_User_via_ADSI_from_Java.htm
Probably depends on how smart the cf/jintegra interface is (I wouldn't
hold my breath...). I'd definitely investigate it though.

Who knows...might be as simple as
comp = createObject("COM","WinNT://serverName/")
service = comp.getObject("service", "serviceName")
etc...


-- 
 jon
 mailto:[EMAIL PROTECTED]

Wednesday, August 20, 2003, 3:01:21 PM, you wrote:
DA> Is it possible to build a service control interface with CF?  I need to detect the 
status 
DA> of a service.

DA> Hope someone can comment.
DA> Dave Adams


DA> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: cfdirectory help - photo album

2003-08-20 Thread Jerry Johnson
Yes. Don't do this.

=)

If you pass to the display page the forward and back values, and then click forward or 
back, how are you going to know what the next next or previous previous values are.

I would instead suggest that on the display page you again do a cfdirectory, and then 
grab the previous and next files from the list on each display of the page.

Just my 2 cents (having recently struggled through this very thing)

Jerry Johnson

>>> [EMAIL PROTECTED] 08/20/03 03:06PM >>>
i am using cfdirectory to display some thumbnails. when a thumbnail is
clicked - it then displays the larger version of the image. what i would
like to do is pass a few variables in the link that will allow 2 more links
to appear on the 'larger version' image page. those 2 links would be 'file
before' and 'file after'. so, if you were to click the 'file before' link -
you would see the image that sits in the same dir before the one you are
looking at. if you were to click 'file after' you would see the image that
appears right after the one you are looking at. pretty much your standard
photo-album app but creating everything dynamically using cfdirectory. any
suggestions? thanks. 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Time zone mask characters

2003-08-20 Thread Bill Henderson
Hello All - 

When you do TimeFormat( Now( ),"long" ) or TimeFormat( Now( ),"full" ) it
returns strings with the time zone at the end like so: 2:25:18 AM PDT. 

My question is, what are the mask characters to get the time zone to display
if you don't use "long" or "full" as the mask? I can't find anything in the
docs about it.

More specifically, I want to show the date as 24 hour time, like this:
TimeFormat( Now( ),"HH:mm ZZ" ) with ZZ being the time zone.


Bill Henderson
[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: WOT: SQL Data types

2003-08-20 Thread Jochem van Dieten
Michael Hodgdon wrote:
> I am curious how religiously people stay true to using data types for MS SQL
> Server.  I know some of these stretch to other RDBMS's, however, I would
> like to know what people in industry think.  What type of general rules of
> thumb do people follow when planning data types  for a data store? For
> instance Money, Numeric, varchar, int, bigint ...  I think you get the
> point.   

Money: never, it is not a predefined type in SQL. Use NUMERIC 
instead.

"CHARACTER, CHARACTER VARYING, CHARACTER LARGE OBJECT, BINARY 
LARGE OBJECT, BIT, BIT VARYING, NUMERIC, DECIMAL, INTEGER, 
SMALLINT, FLOAT, REAL, DOUBLE PRECISION, BOOLEAN, DATE, TIME, 
TIMESTAMP, and INTERVAL" says the SQL standard (time and 
timestamp may or may not have a timezone).

Of those, I have reservations with the large object types and 
with intervals. Although they are standardized, few databases 
support them fully and you might run into issues. I also have 
reservations with using timezones.

But for some applications, you just need them.

Jochem


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: .cfc's and application.cfm file

2003-08-20 Thread Tony Weeg
yah, and I got it to work 100% :) 
lovely

now, tell me why again, besides, oo code pieces and its cool, am I
porting a lot of stuff to cfc's 

thanks.

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 3:21 PM
To: CF-Talk
Subject: RE: .cfc's and application.cfm file


To a CFC, it doesn't matter what order the methods are, method N can
call method M no matter what order they come in.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 1:02 PM
> To: CF-Talk
> Subject: RE: .cfc's and application.cfm file
> 
> 
> so is this the way it works
> 
> 
> 
> 
> 
> 
> 
>  
> 
> 
> 
> can I call out to the first cffunction in the second one, to
> run the first one, to get some value and then use that value 
> 1 line down in the 2nd one?
> 
> am I making sense?
> 
> tony
>   
>   
> 
> 
> tony weeg
> uncertified advanced cold fusion developer
> tony at navtrak dot net
> www.navtrak.net
> office 410.548.2337
> fax 410.860.2337
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 2:51 PM
> To: CF-Talk
> Subject: Re: .cfc's and application.cfm file
> 
> 
> Errr... I didn't think CFC's were supposed to inherit
> UDF's... except from other CFC's... 
> 
> You can however attach the existing UDF to the CFC like this afaik:
> 
> 
> 
> Although you may need to store the UDF in another scope first, so more
> like:
> 
> ...
> 
> 
> ...
> 
> 
> 
> hth
> 
> Isaac
> 
> 
> -- Original Message --
> From: Tony Weeg <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Aug 20, 2003 01:26 PM
> Subject: Re: .cfc's and application.cfm file
> 
> >if I have a udf in my application.cfm file, why doesn't a cfc in the 
> >same dir inherit the udf function from it?
> >
> >thanks!
> >
> >tony weeg
> >uncertified advanced cold fusion developer
> >tony at navtrak dot net
> >www.navtrak.net
> >office 410.548.2337
> >fax 410.860.2337
> >
> >
> 
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: Can CF Detect a Win32 Service?

2003-08-20 Thread Howie Hamlin
CFX_ServiceControl does this.  You can download the freeware tag from:

http://www.coolfusion.com/downloads/freeware.cfm

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
((())) PrismAV is Coming ((()))
>>> Please vote for iMS here: 
>>> http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm 
>>> Find out how iMS Stacks up to the competition: 
>>> http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: "David Adams" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 3:01 PM
Subject: Can CF Detect a Win32 Service?


> Is it possible to build a service control interface with CF?  I need to detect the 
> status 
> of a service.
> 
> Hope someone can comment.
> Dave Adams
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: .cfc's and application.cfm file

2003-08-20 Thread Raymond Camden
Are you asking if one method in a cfc can call another? Yes. If you are
in method A, for example, and want to call B, you can easily do:





===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 20, 2003 12:56 PM
> To: CF-Talk
> Subject: RE: .cfc's and application.cfm file
> 
> 
> so how about...
> 
> can I make the functionality a cffuntion inside my 
> cfcomponent and call one cffuntion from within another?
> 
> tony weeg
> uncertified advanced cold fusion developer
> tony at navtrak dot net
> www.navtrak.net
> office 410.548.2337
> fax 410.860.2337
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 20, 2003 2:51 PM
> To: CF-Talk
> Subject: Re: .cfc's and application.cfm file
> 
> 
> Errr... I didn't think CFC's were supposed to inherit 
> UDF's... except from other CFC's... 
> 
> You can however attach the existing UDF to the CFC like this afaik:
> 
> 
> 
> Although you may need to store the UDF in another scope first, so more
> like: 
> 
> ...
> 
> 
> ... 
> 
>  
> 
> hth
> 
> Isaac 
> 
> 
> -- Original Message -- 
> From: Tony Weeg <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Aug 20, 2003 01:26 PM
> Subject: Re: .cfc's and application.cfm file
> 
> >if I have a udf in my application.cfm file, why doesn't a cfc in the
> >same dir inherit the udf function from it?
> >
> >thanks!
> >
> >tony weeg
> >uncertified advanced cold fusion developer
> >tony at navtrak dot net
> >www.navtrak.net
> >office 410.548.2337
> >fax 410.860.2337
> >
> >
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: question / scheduled tasks CF 5 specific

2003-08-20 Thread Rafael Bleiweiss
Thanks to everyone who posted a reply - I'm going with Win2K's task 
scheduler.

I will, however, now be using CF's scheduler for automating some other 
routines that I was manually handling, so I've now learned from this worm 
dealing issue!

3 Worms in a week in a half - hit by one (SoBig) cause our definition files 
from the DAY BEFORE the worm, didn't recognize it!  hahaha   Friggin 
Hackers are pretty active lately.  Must be something in the air

Now, to just get Microsoft to stop sending out 39 updates patches and 
security fixes every few days and instead spend two more years before they 
deploy their next system  OH wait - too late - Win 2003 is just out isn't 
it?  hahahaha   LIKE I'd EVER consider jumping to THAT system before it's 
been patched and updated for two more years!

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


What's wrong with Tuesday and Thursdays???

2003-08-20 Thread James Edmunds
I have two templates of code that concatenate and display two XML files 
in RSS 2.0 format, identical except that one of them calls an RSS XML 
file that has dates whose day of the week begin with a "T", and chokes! 
It stops with a database exception, with this error message:
Can't convert the string Tue, 23 Sep 2003 00:00:00 CDT to java type DATE
(In earlier tests, I have had this same stop at Thu dates)

You can navigate to each of these with these URLs, and you'll note the 
CFDUMPs and Error reporting:

The one that works:

http://www.jamesedmunds.com/rssgetYES.cfm

The one that doesn't:

http://www.jamesedmunds.com/rssgetNO.cfm

Below my signature, the code for each. Thanks in advance for anyone with 
insight into this issue, which seems to have to do with the way the 
dates are read in the database engine. I am getting these errors in CFMX 
(what we would now call 6.0) through shared hosting on CrystalTech, as 
well as locally testing on CFMX 6.1.

Best to all,

James Edmunds
-
CODE FOR RSSGETYES.CFM:


http://lapresenters.org/rss/lajazdanz.xml"; method="get">



















http://www.lapresenters.org/rss/PrincessTheaterInc.xml"; 
method="get">



















  SELECT * FROM MyQuery
  UNION
  SELECT * FROM MyQuery2
  ORDER BY pubDate



XML
  Parsed and combined listings
  from two different web site sources
  
  
  


 


    #title#
  #description#
  

  
  


Didn't happen. A #cfcatch.type# exception occurred.
#cfcatch.message# #cfcatch.Detail#







END OF CODE FOR RESSGETYES.CFM==
+
CODE FOR RSSGETNO.CFM:


http://pasa-online.org/rss/pasa.xml"; method="get">



















http://www.lapresenters.org/rss/PrincessTheaterInc.xml"; 
method="get">



















  SELECT * FROM MyQuery
  UNION
  SELECT * FROM MyQuery2
  ORDER BY pubDate



XML
  Parsed and combined listings
  from two different web site sources
  
  
  





    #title#
  #description#
  

  
  


Didn't happen. A #cfcatch.type# exception occurred.
#cfcatch.message# #cfcatch.Detail#








~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Banner Ads

2003-08-20 Thread Tony Weeg
there appears to be something like that in the cfczone.org site...maybe?

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 3:06 PM
To: CF-Talk
Subject: Banner Ads


Anyone have any experience with a good CF Banner Ad Application? Perhaps
Fusebox?


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Banner Ads

2003-08-20 Thread Greg Luce
Anyone have any experience with a good CF Banner Ad Application? Perhaps
Fusebox?

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: cfdirectory help - photo album

2003-08-20 Thread Charlie Griefer
if i'm not mistaken, cfdirectory returns a query object.

that being the case, you can manipulate the currentRow variable (+/- 1) to
get the previous and next filenames.

- Original Message - 
From: "Wurst, Keith D." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 12:06 PM
Subject: cfdirectory help - photo album


> i am using cfdirectory to display some thumbnails. when a thumbnail is
> clicked - it then displays the larger version of the image. what i would
> like to do is pass a few variables in the link that will allow 2 more
links
> to appear on the 'larger version' image page. those 2 links would be 'file
> before' and 'file after'. so, if you were to click the 'file before'
link -
> you would see the image that sits in the same dir before the one you are
> looking at. if you were to click 'file after' you would see the image that
> appears right after the one you are looking at. pretty much your standard
> photo-album app but creating everything dynamically using cfdirectory. any
> suggestions? thanks.
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: homesite help

2003-08-20 Thread John Cummings
To get the language reference to show up in the help "books" tree, the docs need to be 
unzipped inside the "Help" directory.The folder that you unzip them to beneath 
"Help" becomes the title of the "book" in your help tree.

HTH,
JC

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 2:28 PM
To: CF-Talk
Subject: homesite help

Hello all,
 
I downloaded the HomesiteTags.zip and HomeSiteExtensions.zip and unzipped
into my homesite root directory... I still don't see the new red sky tags in
my help menu.  I do see it on the tag completion however.  What am I
forgetting?
 
Thanks,
Tim
 
 
 


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: .cfc's and application.cfm file

2003-08-20 Thread Tony Weeg
so is this the way it works




  







can I call out to the first cffunction in the second one, to run the
first one, to get some value
and then use that value 1 line down in the 2nd one?

am I making sense?

tony




tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 2:51 PM
To: CF-Talk
Subject: Re: .cfc's and application.cfm file


Errr... I didn't think CFC's were supposed to inherit UDF's... except
from other CFC's... 

You can however attach the existing UDF to the CFC like this afaik:



Although you may need to store the UDF in another scope first, so more
like: 

...


... 

 

hth

Isaac 


-- Original Message -- 
From: Tony Weeg <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 20, 2003 01:26 PM
Subject: Re: .cfc's and application.cfm file

>if I have a udf in my application.cfm file, why doesn't a cfc in the 
>same dir inherit the udf function from it?
>
>thanks!
>
>tony weeg
>uncertified advanced cold fusion developer
>tony at navtrak dot net
>www.navtrak.net
>office 410.548.2337
>fax 410.860.2337
>
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Banner Ads

2003-08-20 Thread Jeff Lucido
Yep. Try FuseAds from the same folks who brought us FuseTalk.

http://www.fuseads.com/

Good luck,
-JSLucido

-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 2:06 PM
To: CF-Talk
Subject: Banner Ads


Anyone have any experience with a good CF Banner Ad Application? Perhaps
Fusebox?


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: .cfc's and application.cfm file

2003-08-20 Thread Raymond Camden
To a CFC, it doesn't matter what order the methods are, method N can
call method M no matter what order they come in.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 20, 2003 1:02 PM
> To: CF-Talk
> Subject: RE: .cfc's and application.cfm file
> 
> 
> so is this the way it works
> 
> 
> 
> 
> 
> 
> 
>  
> 
> 
> 
> can I call out to the first cffunction in the second one, to 
> run the first one, to get some value and then use that value 
> 1 line down in the 2nd one?
> 
> am I making sense?
> 
> tony
>   
>   
> 
> 
> tony weeg
> uncertified advanced cold fusion developer
> tony at navtrak dot net
> www.navtrak.net
> office 410.548.2337
> fax 410.860.2337
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 20, 2003 2:51 PM
> To: CF-Talk
> Subject: Re: .cfc's and application.cfm file
> 
> 
> Errr... I didn't think CFC's were supposed to inherit 
> UDF's... except from other CFC's... 
> 
> You can however attach the existing UDF to the CFC like this afaik:
> 
> 
> 
> Although you may need to store the UDF in another scope first, so more
> like: 
> 
> ...
> 
> 
> ... 
> 
>  
> 
> hth
> 
> Isaac 
> 
> 
> -- Original Message -- 
> From: Tony Weeg <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Aug 20, 2003 01:26 PM
> Subject: Re: .cfc's and application.cfm file
> 
> >if I have a udf in my application.cfm file, why doesn't a cfc in the
> >same dir inherit the udf function from it?
> >
> >thanks!
> >
> >tony weeg
> >uncertified advanced cold fusion developer
> >tony at navtrak dot net
> >www.navtrak.net
> >office 410.548.2337
> >fax 410.860.2337
> >
> >
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: .cfc's and application.cfm file

2003-08-20 Thread info
Errr... I didn't think CFC's were supposed to inherit UDF's... except from other 
CFC's... 

You can however attach the existing UDF to the CFC like this afaik:



Although you may need to store the UDF in another scope first, so more like: 

...


... 

 

hth

Isaac 


-- Original Message -- 
From: Tony Weeg <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 20, 2003 01:26 PM
Subject: Re: .cfc's and application.cfm file

>if I have a udf in my application.cfm file, why doesn't a cfc in the
>same dir inherit the udf function from it?
>
>thanks!
>
>tony weeg
>uncertified advanced cold fusion developer
>tony at navtrak dot net
>www.navtrak.net
>office 410.548.2337
>fax 410.860.2337
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


cfdirectory help - photo album

2003-08-20 Thread Wurst, Keith D.
i am using cfdirectory to display some thumbnails. when a thumbnail is
clicked - it then displays the larger version of the image. what i would
like to do is pass a few variables in the link that will allow 2 more links
to appear on the 'larger version' image page. those 2 links would be 'file
before' and 'file after'. so, if you were to click the 'file before' link -
you would see the image that sits in the same dir before the one you are
looking at. if you were to click 'file after' you would see the image that
appears right after the one you are looking at. pretty much your standard
photo-album app but creating everything dynamically using cfdirectory. any
suggestions? thanks. 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Can CF Detect a Win32 Service?

2003-08-20 Thread Raymond Camden
Sure - you can use cfexecute to list our running services.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: David Adams [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, August 20, 2003 1:01 PM
> To: CF-Talk
> Subject: Can CF Detect a Win32 Service?
> 
> 
> Is it possible to build a service control interface with CF?  
> I need to detect the status 
> of a service.
> 
> Hope someone can comment.
> Dave Adams
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: Congressional Data

2003-08-20 Thread Chuck Rodgers
Hi Jeremy,

Thanks for the links I will be contacting them to see what they have to
offer.

Chuck Rodgers

- Original Message - 
From: "Jeremy Brodie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 12:45 PM
Subject: Congressional Data


> Chuck,
>
> Here are a few websites you may want to look at. I'm not seeing anything
for free-- but these all seem to be in the few hundred dollar range for a
good list.
>
> 1) Electon Data Services:
http://www.electiondataservices.com/content/zipdistrict.htm
> 2) CQPress:
http://www.cqpress.com/getProduct.asp?nav=government&ProductID=416
>
> Jeremy Brodie
> Intelix
> an Edgewater Technology Solutions Company
>
> web: http://www.edgewater.com
> phone:(703) 815-2500
> nasdaq symbol: EDGE
>
>
> P.S. Great to hear from you. If you're up in NOVA in the next few weeks,
let me buy you lunch!
>
>
>
> >I seem to recall this data being asked for a year or so ago on this
> >list.might want to check the archives
> >
> >Bryan Stevenson B.Comm.
> >VP & Director of E-Commerce Development
> >Electric Edge Systems Group Inc.
> >t. 250.920.8830
> >e. [EMAIL PROTECTED]
> >
> >-
> >Macromedia Associate Partner
> >www.macromedia.com
> >-
> >Vancouver Island ColdFusion Users Group
> >Founder & Director
> >www.cfug-vancouverisland.com
> >- Original Message -
> >From: "Chuck Rodgers" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Wednesday, August 20, 2003 8:46 AM
> >Subject: OT: Congressional Data
> >
> >
> >> Hi,
> >>
> >> I am working with an association that wants to do some advocacy work
with
> >their members.  We are looking for data for zip codes and congressional
> >districts to do lookups for Representatives in Congress.  Anyone have any
> >experience finding this kind of data?
> >>
> >> Thanks
> >>
> >> Chuck Rodgers
> >>
> >>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: Cache trouble or something

2003-08-20 Thread info
I've never seen the cf-server cache pages like that (showing the cached page even 
after deletion) -- could be browser possibly or the other thing that always turns out 
to be the case for me when this happens is that I'm editing the code in the wrong 
directory or on the wrong server. 

Isaac 


-- Original Message -- 
From: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 20, 2003 09:37 AM
Subject: Re: Cache trouble or something

>I don't know what happened but the other day it did. Now when I change the
>code on a page, the old version displays when I test that URL. I can even
>rename or delete the page and it still displays when I test that url.
>
>What in the Wide Wide world of Sports is going on here?
>
>I thought it was some sort of funky caching thing so I've turned off the
>server and restarted it. Same thing.
>
>I hate when these little space time continuum shifts happen.
>
>
>Any help would be appreciated. Thanks
>
>
>Douglas Kronenberger
>OI National Training & Education Office
>440-526-3030 x7776
>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Can CF Detect a Win32 Service?

2003-08-20 Thread David Adams
Is it possible to build a service control interface with CF?  I need to detect the 
status 
of a service.

Hope someone can comment.
Dave Adams


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: .cfc's and application.cfm file

2003-08-20 Thread Tony Weeg
so how about...

can I make the functionality a cffuntion inside my cfcomponent
and call one cffuntion from within another?

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 2:51 PM
To: CF-Talk
Subject: Re: .cfc's and application.cfm file


Errr... I didn't think CFC's were supposed to inherit UDF's... except
from other CFC's... 

You can however attach the existing UDF to the CFC like this afaik:



Although you may need to store the UDF in another scope first, so more
like: 

...


... 

 

hth

Isaac 


-- Original Message -- 
From: Tony Weeg <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 20, 2003 01:26 PM
Subject: Re: .cfc's and application.cfm file

>if I have a udf in my application.cfm file, why doesn't a cfc in the 
>same dir inherit the udf function from it?
>
>thanks!
>
>tony weeg
>uncertified advanced cold fusion developer
>tony at navtrak dot net
>www.navtrak.net
>office 410.548.2337
>fax 410.860.2337
>
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: XML/XPATH

2003-08-20 Thread Ian Skinner
Is there a way to get a single, modified XML document/structure?

--
Ian Skinner
Web Programmer
BloodSource
Sacramento, CA


-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 8:48 AM
To: CF-Talk
Subject: Re: XML/XPATH


> The closet I've gotten is this.   XmlSearch(masterXML,"/root/article[type = 'Event']")>.  But, this returns
> an Array of XML structures, when what I really want is a single XML
> structure.
>
> newXML[1]=
> 
>Event
> 
> newXML[2]=
> 
>Event
> 
>
> What relatively basic concept am I not getting here?

Executing an XPath expression on a XML structure with XmlSearch always
return the CFML equivalent of a DOM "NodeList". The NodeList may be empty or
contain only one node but it's still a NodeList, so in CFML you get an array
of XML elements.


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/






~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: .cfc's and application.cfm file

2003-08-20 Thread Tony Weeg
so, barney, could I make it a cffunction in my cfc, and then call that
method from within another cffunction?

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 2:26 PM
To: CF-Talk
Subject: RE: .cfc's and application.cfm file


The UDF will be defined for external requests to the CFC (meaning
myCfc.cfc?method=myMethod calls), but it will be inaccessible because of
scoping issues.  It will never be a method, only a UDF, and won't even
be defined for internal requests to the CFC, unless the root page
happens to have executed the same Application.cfm.  If you want to add a
method to all CFCs in a directory, you need to add the method to a new
CFC, and make all the existing CFCs inherit from that new base CFC,
directly or indirectly.

There is also a component.cfc file somewhere in the CF install (I don't
know
where) that is the implied base class for all CFCs that don't explicitly
extend another CFC.  If you add a method to that file, it will be
inherited by ALL components on the entire server.

HTH,
barneyb

---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com


> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 10:27 AM
> To: CF-Talk
> Subject: .cfc's and application.cfm file
>
>
> if I have a udf in my application.cfm file, why doesn't a cfc in the 
> same dir inherit the udf function from it?
>
> thanks!
>
> tony weeg
> uncertified advanced cold fusion developer
> tony at navtrak dot net
> www.navtrak.net
> office 410.548.2337
> fax 410.860.2337
>
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: hard returns and text areas

2003-08-20 Thread Barney Boisvert
Yep, it sure is.  But that doesn't affect the code I proposed, because it
uses a character class.  As well as chr 13,10 (for windows), it'll also
catch just chr 10 (for *nix, including Mac OSX), just chr 13 (for non-OSX
Mac), and even chr 10,13 (from a developer who got his code wrong).

It will also compress multiple sequential line breaks into a single space,
which may or may not be desirable, but seemed so for the situation
described.

cheers,
barneyb

---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com


> -Original Message-
> From: Critz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 9:37 AM
> To: CF-Talk
> Subject: Re: hard returns and text areas
>
>
> oi Barney!!
>
> isn't a crlf 13,10 ?
>
> INTRO   db   13,10   ;;Intro-Message: 13,10 = New Line
>
> least it is in asm would assume it is a standard thing
>
> --
> Currently Playing: Godsmack - Releasing The Demons
>
> 
> Wednesday, August 20, 2003, 12:08:50 PM, you wrote:
>
> BB> Hard breaks should come through to the server as either
> newlines, carriage
> BB> returns, or both, depending on OS.  then it's just a matter of doing a
> BB> search and replace for them:
>
> BB> myString = REreplace(myString, "[#chr(10)##chr(13)#]+", " ", "all");
>
> BB> ---
> BB> Barney Boisvert, Senior Development Engineer
> BB> AudienceCentral
> BB> [EMAIL PROTECTED]
> BB> voice : 360.756.8080 x12
> BB> fax   : 360.647.5351
>
> BB> www.audiencecentral.com
>
>
> >> -Original Message-
> >> From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]
> >> Sent: Wednesday, August 20, 2003 7:23 AM
> >> To: CF-Talk
> >> Subject: hard returns and text areas
> >>
> >>
> >> hi. does anyone know of a way to identify that a user has
> entered a hard
> >> return into a text-area and then pull those hard returns out
> (or replace
> >> them with just a single space).  any help is greatly
> appreciated. thanks
> >> very much.
> >>
> BB>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


ó into ý - Spanish text in application

2003-08-20 Thread Bryan F. Hogan
I have a client, that has their application encoding set to "Spanish
(Mexican)" via setEncoding().

When they enter the character ó into the form it inserts into a memo column
in their access database. After doing so if you look at the data in access
the ó has changed to ý.

Is this the applications problem or Access? Anyone know how to correct the
problem?

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Congressional Data

2003-08-20 Thread Jeff Beer
http://www.visi.com/juan/congress/downloads.html

You'll love this :)


-Original Message-
From: Chuck Rodgers [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 12:34 PM
To: CF-Talk
Subject: Re: Congressional Data


Hi,

I did that and searching for congress data or congressional data did not
turn up anything.

Chuck Rodgers

- Original Message - 
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 12:14 PM
Subject: Re: Congressional Data


> I seem to recall this data being asked for a year or so ago on this 
> list.might want to check the archives
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
>
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> - Original Message -
> From: "Chuck Rodgers" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 20, 2003 8:46 AM
> Subject: OT: Congressional Data
>
>
> > Hi,
> >
> > I am working with an association that wants to do some advocacy work
with
> their members.  We are looking for data for zip codes and 
> congressional districts to do lookups for Representatives in Congress.

> Anyone have any experience finding this kind of data?
> >
> > Thanks
> >
> > Chuck Rodgers
> >
> >
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Mach II. Is it faster than Fusebox 3?

2003-08-20 Thread info
Personally I'd really like to see some comparisons also of the onTap framework along 
side comparable applications in FB3, FB4 and Mach-II ... Although some of the reasons 
behind onTap are similar (having a recognizable pattern for code reuse) I think it's 
fairly obvious that I had some different things in mind when I put onTap together 
(managing and documenting custom tags and UDF's for instance). If I get some time I 
might try drafting a copy of the Blogs onTap sample application (because it's small) 
in FB3, FB4 and Mach-II for just such an accademic comparison. ... In all honesty I 
hope I don't have the time to do that, but we'll just have to see when my current 
contract ends on the 15th. 

Isaac 

http://www.turnkey.to/ontap 


-- Original Message -- 
From: Haggerty, Mike <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 20, 2003 11:01 AM
Subject: RE: Mach II. Is it faster than Fusebox 3?

>> -Original Message-
>> From: Sean A Corfield [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, August 19, 2003 5:15 PM
>> To: CF-Talk
>> Subject: Re: Mach II. Is it faster than Fusebox 3?
>>
>> It would perhaps be instructive to find a reasonably sized
>> FB3 app and
>> then port it to FB4 and also convert it to Mach II and test
>> all three.
>> But that's asking a big commitment of time and effort from folks!
>>
>> Another factor that I think is more important is TCO based on the
>> maintenance overhead of applications written in FB3, FB4 and Mach II.
>> One of the prime drivers for Mach II is to address the
>> maintenance cost
>> overhead through the use of OO to improve reusability and increase
>> flexibility (through loose coupling, encapsulation etc).
>
>Sean, I am in complete agreement with you that the major benefit to
>using MachII will be a reduction in the cost of maintaining an
>application over time. I also see the language agnostic aspects of
>MachII being a big part of its value proposition, and a wonderful one
>for shops that are not necessarily standardized on a single technology.
>
>Or couse, performance should be an important initial factor in the
>decision to adopt a framework for a project, especially in the case of a
>high volume Web application. The cost to maintain an application is
>meaningless if a project is so slow under load that no one can stand to
>use it.
>
>While I don't see anyone making a concurrent joint migration to FB4 and
>MachII except as an academic exercise, I do think performance
>comparisons will come out as people start moving applications into
>MachII.
>
>M
>
>> Sean A Corfield -- http://www.corfield.org/blog/
>>
>> "If you're not annoying somebody, you're not really alive."
>> -- Margaret Atwood
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: question / scheduled tasks CF 5 specific

2003-08-20 Thread info
I've never experienced any problems with the cf scheduler myself. That doesn't 
necessarily mean they're not there, I just haven't run into them. If you want to 
execute a command line statement from a coldfusion page, you want to use  
... which can be rather frustrating to figure out ... however, it doesn't sound like 
you need to do any ColdFusion work with this particular task, so I'd recommend looking 
into the Windows scheduler to run the command instead. I can't point you to any 
documentation off the top of my head, but I'm sure it's out there. :) 

Isaac 

-- Original Message -- 
From: [EMAIL PROTECTED] (Rafael Bleiweiss)
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Aug 20, 2003 04:40 AM
Subject: Re: question / scheduled tasks CF 5 specific

>Having difficulty finding examples or better documentation on the CF 5
>Scheduler...
>
>I'm about to attempt to try for the first time to run a scheduled task once
>an hour on my server - Win2K, IIS, and CF 5.   I want to schedule a task
>that automatically retrieves the latest Symantic virus definition files
>hourly instead of the minimum daily that the System Center console allows
>for directly.
>
>It's literally a one line code thing - a command prompt execution of the
>Live Update system configured to only get the definition files and exclude
>product updates.
>
>As the documentation is overly thin for someone unfamiliar with this sort
>of process, I have CLUE ZERO regarding how to execute a server based
>executable with command line variables through the scheduler, as the only
>"option is CFHTTP...
>
>So.. any help or pointing to more info is extremely appreciated...
>
>AND ALSO I've heard (even today on this list) that CF 5 doesn't handle
>Scheduled events too well - THOUGHTS?  COMMENTS?
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


homesite help

2003-08-20 Thread Tim Do
Hello all,
 
I downloaded the HomesiteTags.zip and HomeSiteExtensions.zip and unzipped
into my homesite root directory... I still don't see the new red sky tags in
my help menu.  I do see it on the tag completion however.  What am I
forgetting?
 
Thanks,
Tim
 
 
 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: Congressional Data

2003-08-20 Thread Cary Gordon
There are several commercial databases available in the $3-400 range, or 
you can buy the raw data (messy) from the USPS.

http://www.zipinfo.com/
http://www.congressmerge.com/

Cary Gordon
The Cherry Hill Company
 > Hi,
 >
 > I am working with an association that wants to do some advocacy work with
their members.  We are looking for data for zip codes and congressional
districts to do lookups for Representatives in Congress.  Anyone have any
experience finding this kind of data?
 >
 > Thanks
 >
 > Chuck Rodgers

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: .cfc's and application.cfm file

2003-08-20 Thread Barney Boisvert
The UDF will be defined for external requests to the CFC (meaning
myCfc.cfc?method=myMethod calls), but it will be inaccessible because of
scoping issues.  It will never be a method, only a UDF, and won't even be
defined for internal requests to the CFC, unless the root page happens to
have executed the same Application.cfm.  If you want to add a method to all
CFCs in a directory, you need to add the method to a new CFC, and make all
the existing CFCs inherit from that new base CFC, directly or indirectly.

There is also a component.cfc file somewhere in the CF install (I don't know
where) that is the implied base class for all CFCs that don't explicitly
extend another CFC.  If you add a method to that file, it will be inherited
by ALL components on the entire server.

HTH,
barneyb

---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com


> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 10:27 AM
> To: CF-Talk
> Subject: .cfc's and application.cfm file
>
>
> if I have a udf in my application.cfm file, why doesn't a cfc in the
> same dir inherit the udf function from it?
>
> thanks!
>
> tony weeg
> uncertified advanced cold fusion developer
> tony at navtrak dot net
> www.navtrak.net
> office 410.548.2337
> fax 410.860.2337
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


MX61 admin password problem

2003-08-20 Thread Jon Moneymaker
As usual, it was operator (me) error
I just wasn't paying attentionstupid mistake, but was just too close and 
frustrated at the time...saw the problem (embarrassed) and fixed it
works like a champ now

Jon
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


.cfc's and application.cfm file

2003-08-20 Thread Tony Weeg
if I have a udf in my application.cfm file, why doesn't a cfc in the
same dir inherit the udf function from it?

thanks!

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Congressional Data

2003-08-20 Thread Jeremy Brodie
Chuck,

Here are a few websites you may want to look at. I'm not seeing anything for free-- 
but these all seem to be in the few hundred dollar range for a good list.

1) Electon Data Services: http://www.electiondataservices.com/content/zipdistrict.htm
2) CQPress: http://www.cqpress.com/getProduct.asp?nav=government&ProductID=416

Jeremy Brodie
Intelix
an Edgewater Technology Solutions Company

web: http://www.edgewater.com
phone:(703) 815-2500
nasdaq symbol: EDGE


P.S. Great to hear from you. If you're up in NOVA in the next few weeks, let me buy 
you lunch!



>I seem to recall this data being asked for a year or so ago on this
>list.might want to check the archives
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>t. 250.920.8830
>e. [EMAIL PROTECTED]
>
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>- Original Message -
>From: "Chuck Rodgers" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, August 20, 2003 8:46 AM
>Subject: OT: Congressional Data
>
>
>> Hi,
>>
>> I am working with an association that wants to do some advocacy work with
>their members.  We are looking for data for zip codes and congressional
>districts to do lookups for Representatives in Congress.  Anyone have any
>experience finding this kind of data?
>>
>> Thanks
>>
>> Chuck Rodgers
>>
>> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: Congressional Data

2003-08-20 Thread Bryan Stevenson
did ya just try "congress" ;-) ?

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Chuck Rodgers" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 9:34 AM
Subject: Re: Congressional Data


> Hi,
>
> I did that and searching for congress data or congressional data did not
> turn up anything.
>
> Chuck Rodgers
>
> - Original Message -
> From: "Bryan Stevenson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 20, 2003 12:14 PM
> Subject: Re: Congressional Data
>
>
> > I seem to recall this data being asked for a year or so ago on this
> > list.might want to check the archives
> >
> > Bryan Stevenson B.Comm.
> > VP & Director of E-Commerce Development
> > Electric Edge Systems Group Inc.
> > t. 250.920.8830
> > e. [EMAIL PROTECTED]
> >
> > -
> > Macromedia Associate Partner
> > www.macromedia.com
> > -
> > Vancouver Island ColdFusion Users Group
> > Founder & Director
> > www.cfug-vancouverisland.com
> > - Original Message -
> > From: "Chuck Rodgers" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 20, 2003 8:46 AM
> > Subject: OT: Congressional Data
> >
> >
> > > Hi,
> > >
> > > I am working with an association that wants to do some advocacy work
> with
> > their members.  We are looking for data for zip codes and congressional
> > districts to do lookups for Representatives in Congress.  Anyone have
any
> > experience finding this kind of data?
> > >
> > > Thanks
> > >
> > > Chuck Rodgers
> > >
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Congressional Data

2003-08-20 Thread Dan O'Keefe
I was one of them. Found what I was looking for. This is the mother of all
data, for government data any ways. It is called Yellow books at
leadershipdirectories.com.

Dan

-Original Message-
From: Chuck Rodgers [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 12:34 PM
To: CF-Talk
Subject: Re: Congressional Data


Hi,

I did that and searching for congress data or congressional data did not
turn up anything.

Chuck Rodgers

- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 12:14 PM
Subject: Re: Congressional Data


> I seem to recall this data being asked for a year or so ago on this
> list.might want to check the archives
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
>
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> - Original Message -
> From: "Chuck Rodgers" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 20, 2003 8:46 AM
> Subject: OT: Congressional Data
>
>
> > Hi,
> >
> > I am working with an association that wants to do some advocacy work
with
> their members.  We are looking for data for zip codes and congressional
> districts to do lookups for Representatives in Congress.  Anyone have any
> experience finding this kind of data?
> >
> > Thanks
> >
> > Chuck Rodgers
> >
> >
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Congressional Data

2003-08-20 Thread Jeremy Brodie
Chuck,

Here are a few websites you may want to look at. I'm not seeing anything for free-- 
but these all seem to be in the few hundred dollar range for a good list.

1) Electon Data Services: http://www.electiondataservices.com/content/zipdistrict.htm
2) CQPress: http://www.cqpress.com/getProduct.asp?nav=government&ProductID=416

Jeremy Brodie
Intelix
an Edgewater Technology Solutions Company

web: http://www.edgewater.com
phone:(703) 815-2500
nasdaq symbol: EDGE


P.S. Great to hear from you. If you're up in NOVA in the next few weeks, let me buy 
you lunch!



>I seem to recall this data being asked for a year or so ago on this
>list.might want to check the archives
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>t. 250.920.8830
>e. [EMAIL PROTECTED]
>
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>- Original Message -
>From: "Chuck Rodgers" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, August 20, 2003 8:46 AM
>Subject: OT: Congressional Data
>
>
>> Hi,
>>
>> I am working with an association that wants to do some advocacy work with
>their members.  We are looking for data for zip codes and congressional
>districts to do lookups for Representatives in Congress.  Anyone have any
>experience finding this kind of data?
>>
>> Thanks
>>
>> Chuck Rodgers
>>
>> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: hard returns and text areas

2003-08-20 Thread Tony Weeg
is that you critz listening to godsmack?

tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: Critz [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 12:37 PM
To: CF-Talk
Subject: Re: hard returns and text areas


oi Barney!!

isn't a crlf 13,10 ?

INTRO   db   13,10   ;;Intro-Message: 13,10 = New
Line

least it is in asm would assume it is a standard thing

-- 
Currently Playing: Godsmack - Releasing The Demons


Wednesday, August 20, 2003, 12:08:50 PM, you wrote:

BB> Hard breaks should come through to the server as either newlines, 
BB> carriage returns, or both, depending on OS.  then it's just a matter

BB> of doing a search and replace for them:

BB> myString = REreplace(myString, "[#chr(10)##chr(13)#]+", " ", "all");

BB> ---
BB> Barney Boisvert, Senior Development Engineer AudienceCentral
BB> [EMAIL PROTECTED]
BB> voice : 360.756.8080 x12
BB> fax   : 360.647.5351

BB> www.audiencecentral.com


>> -Original Message-
>> From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, August 20, 2003 7:23 AM
>> To: CF-Talk
>> Subject: hard returns and text areas
>>
>>
>> hi. does anyone know of a way to identify that a user has entered a 
>> hard return into a text-area and then pull those hard returns out (or

>> replace them with just a single space).  any help is greatly 
>> appreciated. thanks very much.
>> 
BB> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: hard returns and text areas

2003-08-20 Thread Critz
oi Tony!!

aye :)


-- 
Currently Playing: Let The Party Begin - Shaved - My Mouse


Wednesday, August 20, 2003, 1:13:28 PM, you wrote:

TW> is that you critz listening to godsmack?

TW> tony weeg
TW> uncertified advanced cold fusion developer
TW> tony at navtrak dot net
TW> www.navtrak.net
TW> office 410.548.2337
TW> fax 410.860.2337


TW> -Original Message-
TW> From: Critz [mailto:[EMAIL PROTECTED] 
TW> Sent: Wednesday, August 20, 2003 12:37 PM
TW> To: CF-Talk
TW> Subject: Re: hard returns and text areas


TW> oi Barney!!

TW> isn't a crlf 13,10 ?

TW> INTRO   db   13,10   ;;Intro-Message: 13,10 = New
TW> Line

TW> least it is in asm would assume it is a standard thing



---
[This E-mail scanned for viruses by Declude Virus]

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


HELP! POST CFMX 6.1 and MDAC Upgrade - Query problems!

2003-08-20 Thread Brook Davies
HELP!   

Last night I installed MDAC 2.8 and CFMX 6.1. CFMX failed with the web 
server connectors so I reverted back to the previous installation. Now 
today, I am having all kinds of problems.

There are numerous threads stacking up on top of one another and they seem 
to all be related to DB queries. It is very strange, some queries are 
working while others are not returning a result and resulting in a long 
running thread. I don't know what to do and I can not figure out why only 
some of the queries are causing the problem.

Can anyone help me with this?

Brook Davies


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


oracle datasource as OLEDB

2003-08-20 Thread Sheila Handler
Actually the clients have pro; from the documentation, it seemed to me that only 
Enterprise supports Oracle, and I told them they'd have to upgrade. Is that true? Or 
can they use MS ODBC drivers for Oracle on CF5 Pro? 
 

>which version of CF5 are you using?  The enterprise version comes with 
>a native Oracle driver.  Otherwise, the Oracel ODBC driver or the M$ 
>ODBC driver for Oracle work fine.  The M$ one actually tends to work 
>better.  TO use the ODBC drivers, you have to first setup the DSN on 
>the server, then set it up in CF Admin.
>
>Doug
>
>>-Original Message-
>>From: Sheila Handler [mailto:[EMAIL PROTECTED]
>>Sent: Tuesday, August 19, 2003 10:18 PM
>>To: CF-Talk
>>Subject: oracle datasource as OLEDB
>>
>>
>>This is my first encounter with Oracle. I need to define a 
>>datasource in
>>CF5. As far as using the database, it'll be nothing but the 
>>simplest SELECT
>>statements, so that shouldn't be a problem.
>>
>>Is it possible to define an Oracle database with OLEDB, or do 
>>I have to use
>>ODBC? Can anyone give me some hints about defining an Oracle 
>>datasource? My
>>experience is mostly with Sql Server.
>>
>>
>>
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Decode - URLEncoded string

2003-08-20 Thread Jim Davis
Could you actually just replace the "00"?  Is it that simple?  Are there
no three character entity codes?

Just curious.

Jim Davis

> -Original Message-
> From: Jeff Chastain [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 12:10 PM
> To: CF-Talk
> Subject: RE: Decode - URLEncoded string
> 
> That is the route I have gone with so far ... I was just looking for a
> 'correct' solution.
> 
> Thanks
> -- Jeff
> 
> 
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 10:11 AM
> To: CF-Talk
> Subject: Re: Decode - URLEncoded string
> 
> 
> h...looks like you could just replace all instances of "002" and
"004"
> with "2" and "4". and then you'll have a normal URLEncoded
string...not
> elegant...but it should fly
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
> 
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> - Original Message -
> From: "Jeff Chastain" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 19, 2003 6:23 PM
> Subject: Decode - URLEncoded string
> 
> 
> > I have got a string that was encoded by another application using a
> > 'quad-character format'.  I have not seen this format before and I
am
> > getting errors when trying to decode it.   Anybody run into this
before
> and
> > have any suggestions?  I have tried the different formatting options
for
> > URLDecode without any luck.
> >
> > 'Normal' encoding - jeff%u2Echastain%u40hp%u2Ecom
> > Quad Character encoding - jeff%u002Echastain%u0040hp%u002Ecom
> >
> > Thanks
> > -- Jeff
> >
> >
> >
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: oracle datasource as OLEDB

2003-08-20 Thread Dave Watts
> Actually the clients have pro; from the documentation, it 
> seemed to me that only Enterprise supports Oracle, and I told 
> them they'd have to upgrade. Is that true? Or can they use MS 
> ODBC drivers for Oracle on CF5 Pro?

You should be able to use any ODBC drivers, including those for Oracle, from
CF 5 Professional.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: OT: Oracle Licensing

2003-08-20 Thread Brrrian
Tell him your company is seriously considering moving to PostgreSQL and 
that until a decision is made on that matter you won't be in a position to 
make any decision.

At 10:46 AM 8/20/03 -0400, you wrote:

>I just completed a call with the Oracle rep (who is a salesman) for my
>organization and received some feedback about our licensing that has me
>more than a little confused. I am wondering if anyone can offer some
>insight or advice to help me understand the situation.
>
>Back in 1999, our organization purchased parallel licenses for 2 Oracle
>servers with 8 concurrent users. My understanding (and our CIOs) was
>that ColdFusion would count as 1 user on each machine and we would have
>7 developers on each box. Additionally, our understanding was that we
>need no licenses for a development box.
>
>The person I just spoke to explained that these licenses are not valid
>for the purpose of distributing information over the Internet (i.e. that
>using CF, PHP or anything else to draw data from the server) and that we
>will need to migrate to a per-processor model immediately in order to be
>in compliance. He also said that using a copy of Oracle for development
>purposes would require that we purchase licenses for the development
>boxes as well (which, incidentally, is at the same cost as a full blown
>production server).
>
>Before I contact the sales representative we originally spoke to on the
>matter, I wanted to see if anyone has had similar experiences or is
>familiar with the Oracle concurrent user licensing model in regards to
>the use of dynamic Web pages. I am thinking that under the terms of the
>license we originally purchased should cover the use of ColdFusion and
>that this guy is just trying to get me to buy stuff.
>
>M
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Oracle Licensing

2003-08-20 Thread John Paul Ashenfelter
Can't speak to the processor/user licensing (though it is in keeping with
how Microsoft SQL Server is licensed -- seems like a CAL per connection is
enough, but MS says no, you must have one per device connecting and each
internet user is a device, so therefore save millions of dollars and buy a
per-processor license)

But for the development side, Oracle used to have a $200 developer
subscription. Been two years since I had one, but it gave you the Oracle db
on a particular OS (eg linux or windows) and what read like a developer
license. Of course it may have all changed. It was sort of like MSDN or MM
DevNet. Maybe it was called Oracle Developer's Network (ODN?). If that is
the case, $200x7 is probably FAR less than another Oracle license :)

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message - 
From: "Haggerty, Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 10:46 AM
Subject: OT: Oracle Licensing


> I just completed a call with the Oracle rep (who is a salesman) for my
> organization and received some feedback about our licensing that has me
> more than a little confused. I am wondering if anyone can offer some
> insight or advice to help me understand the situation.
>
> Back in 1999, our organization purchased parallel licenses for 2 Oracle
> servers with 8 concurrent users. My understanding (and our CIOs) was
> that ColdFusion would count as 1 user on each machine and we would have
> 7 developers on each box. Additionally, our understanding was that we
> need no licenses for a development box.
>
> The person I just spoke to explained that these licenses are not valid
> for the purpose of distributing information over the Internet (i.e. that
> using CF, PHP or anything else to draw data from the server) and that we
> will need to migrate to a per-processor model immediately in order to be
> in compliance. He also said that using a copy of Oracle for development
> purposes would require that we purchase licenses for the development
> boxes as well (which, incidentally, is at the same cost as a full blown
> production server).
>
> Before I contact the sales representative we originally spoke to on the
> matter, I wanted to see if anyone has had similar experiences or is
> familiar with the Oracle concurrent user licensing model in regards to
> the use of dynamic Web pages. I am thinking that under the terms of the
> license we originally purchased should cover the use of ColdFusion and
> that this guy is just trying to get me to buy stuff.
>
> M
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


oracle datasource as OLEDB

2003-08-20 Thread Sheila Handler
Actually the clients have pro; from the documentation, it seemed to me that only 
Enterprise supports Oracle, and I told them they'd have to upgrade. Is that true? Or 
can they use MS ODBC drivers for Oracle on CF5 Pro? 
 

>which version of CF5 are you using?  The enterprise version comes with 
>a native Oracle driver.  Otherwise, the Oracel ODBC driver or the M$ 
>ODBC driver for Oracle work fine.  The M$ one actually tends to work 
>better.  TO use the ODBC drivers, you have to first setup the DSN on 
>the server, then set it up in CF Admin.
>
>Doug
>
>>-Original Message-
>>From: Sheila Handler [mailto:[EMAIL PROTECTED]
>>Sent: Tuesday, August 19, 2003 10:18 PM
>>To: CF-Talk
>>Subject: oracle datasource as OLEDB
>>
>>
>>This is my first encounter with Oracle. I need to define a 
>>datasource in
>>CF5. As far as using the database, it'll be nothing but the 
>>simplest SELECT
>>statements, so that shouldn't be a problem.
>>
>>Is it possible to define an Oracle database with OLEDB, or do 
>>I have to use
>>ODBC? Can anyone give me some hints about defining an Oracle 
>>datasource? My
>>experience is mostly with Sql Server.
>>
>>
>>
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: question / scheduled tasks CF 5 specific

2003-08-20 Thread Jim Davis
> 
> > AND ALSO I've heard (even today on this list) that CF 5
> > doesn't handle Scheduled events too well - THOUGHTS? COMMENTS?

Just throwing my experience in: in 4.5 (which we're still stuck on) the
scheduler has always run just fine for us.  I'm doing so pretty complex
stuff with as well (for example running a task one per day that then
changes it to once every ten minutes until a series of files is imported
then changing back to once per day).

It's always done the job.

That being said a lot of people have had trouble... but I still suspect
that they are in the minority.

Jim Davis



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Upgrading to 6.1 fails : "web server connector update failed"

2003-08-20 Thread Brook Davies
Actually, I am using IIS 5.0 on Windows 2k / SP3.

The install log has very little. These are the only two failure entries:


Copy Folder:  Destination: C:\CFusionMX\jre
   Status: WARNING
   Additional Notes: WARNING - There was a 
problem copying C:\CFusionMX\cfmx_updater\cfmx_61\jre


ANT Script Error:
Status: ERROR
Additional Notes: ERROR - 26: Java returned: 1



After reverting to the original CFMX installtion (with Updater 3) we have 
started to see many, many "null null" errors today and database threads 
that would not die. We also upgraded MDAC to 2.8 last night, so that might 
have also caused some problems.

Brook Davies

At 11:50 AM 8/20/2003 -0400, you wrote:
> > I get this error at the very end of an otherwise successful
> > upgrade to 6.1.
> >
> > I have tried multiple times and it can not complete the
> > installation. Any ideas?
> >
> > "web server connector update failed"
>
>Are you using a version of Apache supported by CFMX 6.1? Is there more
>information in the install log?
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


CFC Issues....

2003-08-20 Thread Tony Weeg
what could this possibly mean?

the code works perfect outside of the cfc, but now it doesn't inside the
cfc?

Unable to complete CFML to Java translation.  
Error information unsupported statement: class
coldfusion.compiler.ASTfunctionDefinition  
  
The error occurred in C:\Inetpub\wwwroot\cf~permissionsConsume.cfm: line
15
 
13 : 
16 :
17 : 

 



 
Please try the following: 
Check the ColdFusion documentation to verify that you are using the
correct syntax. 
Search the Knowledge Base to find a solution to your problem. 

 
Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR
1.1.4322) 
Remote Address   10.10.11.186 
Referrer
Date/Time   20-Aug-03 01:29 PM 
 
Stack Trace (click to expand)  


tony weeg
uncertified advanced cold fusion developer
tony at navtrak dot net
www.navtrak.net
office 410.548.2337
fax 410.860.2337

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: hard returns and text areas

2003-08-20 Thread Knight, Matt
Chr(10) and Chr(13) in the ASCII table are carriage return with a line feed

So do a REReplace(#Chr(10)##Chr(13)#," ",ALL)

(may not be syntactically accurate - but you get the idea...) 


Matt Knight ► w: 972 361 9943 ► m: 214 213 4016


-Original Message-
From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 9:23 AM
To: CF-Talk

hi. does anyone know of a way to identify that a user has entered a hard
return into a text-area and then pull those hard returns out (or replace
them with just a single space).  any help is greatly appreciated. thanks
very much.

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: hard returns and text areas

2003-08-20 Thread Barney Boisvert
Hard breaks should come through to the server as either newlines, carriage
returns, or both, depending on OS.  then it's just a matter of doing a
search and replace for them:

myString = REreplace(myString, "[#chr(10)##chr(13)#]+", " ", "all");

---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com


> -Original Message-
> From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 7:23 AM
> To: CF-Talk
> Subject: hard returns and text areas
>
>
> hi. does anyone know of a way to identify that a user has entered a hard
> return into a text-area and then pull those hard returns out (or replace
> them with just a single space).  any help is greatly appreciated. thanks
> very much.
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Decode - URLEncoded string

2003-08-20 Thread Jeff Chastain
That is the route I have gone with so far ... I was just looking for a
'correct' solution.

Thanks
-- Jeff


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 20, 2003 10:11 AM
To: CF-Talk
Subject: Re: Decode - URLEncoded string


h...looks like you could just replace all instances of "002" and "004"
with "2" and "4". and then you'll have a normal URLEncoded string...not
elegant...but it should fly

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Jeff Chastain" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, August 19, 2003 6:23 PM
Subject: Decode - URLEncoded string


> I have got a string that was encoded by another application using a
> 'quad-character format'.  I have not seen this format before and I am
> getting errors when trying to decode it.   Anybody run into this before
and
> have any suggestions?  I have tried the different formatting options for
> URLDecode without any luck.
>
> 'Normal' encoding - jeff%u2Echastain%u40hp%u2Ecom
> Quad Character encoding - jeff%u002Echastain%u0040hp%u002Ecom
>
> Thanks
> -- Jeff
>
>
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


6.1 404

2003-08-20 Thread Robertson-Ravo, Neil (RX)
I have just installed 6.1 on a dev server in a co-exist format.I have
added the folder I want to view within the Jrun webserver to the XML file
and indeed when the services are restart I can actually view them, but when
I click a file in the browser to view I get : 

File not found:  [path][filenameandpath]

The folder I am viewing is a seperate partition.i.e. CFMX is on c: and
the files are d:

Anyone know what the scoop is with this?!

Ta

Neil
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: hard returns and text areas

2003-08-20 Thread Critz
oi Keith!!

couldn't you do a replace on CHR(13)&CHR(10) ?

Crit


-- 
Currently Playing: Godsmack - Straight Out Of Line


Wednesday, August 20, 2003, 10:22:30 AM, you wrote:

WKD> hi. does anyone know of a way to identify that a user has entered a hard
WKD> return into a text-area and then pull those hard returns out (or replace
WKD> them with just a single space).  any help is greatly appreciated. thanks
WKD> very much.
WKD> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Formatting a List Output Question

2003-08-20 Thread Les Mizzell
Morning,

Got a list problem that's driving me crazy!  This is probably more a CSS
question than Cold Fusion

I'm trying to output the results of a query into a list. No problems there,
but the formatting is driving me nutz.  The list wraps wrong.  What I'm
getting (using a "*" as the bullet for example here only...

* Item One
* Item Two is long
and wraps under the bullet
*Item Three is long
and wraps under the bullet

What I'm trying to get:

* Item One
* Item Two is long
  and wraps this way
* Item Three is long
  and wraps this way

So, shouldn't the below do what I want?


  
   #deals.PA_CATEGORY#
  


Of course, I could use a graphic and a two column tablebut that doesn't
seem like the best way to go...

I've tried all sorts of CSS tricks, but nothing seems to fix the problem.
Ideas?

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Integrating CFM pages with JSP and Servlets

2003-08-20 Thread John McCosker
Hi,

having problems here trying to get a test servlet to work,
I'm following Ben Forta's example in MX Application Development (third
edition),
using MX 6 not 6.1,

on one box it runs fine, its using MX's standalone JRUN server,

the one that is giving the problem is running IIS.



error message = The system has attempted to use an undefined value, which
usually indicates a programming error, either in your code or some system
code. 
Null Pointers are another name for undefined values. 

Works fine with JSP's.

Does the JRUNScripts virtual directory for ISS over-ride the WEB-INF\web.xml
lookup, or something like that.

Any ideas?

Respectfully,

J.
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: hard returns and text areas

2003-08-20 Thread Critz
oi Barney!!

isn't a crlf 13,10 ?

INTRO   db   13,10   ;;Intro-Message: 13,10 = New Line

least it is in asm would assume it is a standard thing

-- 
Currently Playing: Godsmack - Releasing The Demons


Wednesday, August 20, 2003, 12:08:50 PM, you wrote:

BB> Hard breaks should come through to the server as either newlines, carriage
BB> returns, or both, depending on OS.  then it's just a matter of doing a
BB> search and replace for them:

BB> myString = REreplace(myString, "[#chr(10)##chr(13)#]+", " ", "all");

BB> ---
BB> Barney Boisvert, Senior Development Engineer
BB> AudienceCentral
BB> [EMAIL PROTECTED]
BB> voice : 360.756.8080 x12
BB> fax   : 360.647.5351

BB> www.audiencecentral.com


>> -Original Message-
>> From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, August 20, 2003 7:23 AM
>> To: CF-Talk
>> Subject: hard returns and text areas
>>
>>
>> hi. does anyone know of a way to identify that a user has entered a hard
>> return into a text-area and then pull those hard returns out (or replace
>> them with just a single space).  any help is greatly appreciated. thanks
>> very much.
>> 
BB> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: question / scheduled tasks CF 5 specific

2003-08-20 Thread Jim Davis
I think that you'd benefit from splitting your problem.

For your problem think of the scheduler just as a timer that runs CF
pages - nothing more.  So first you need to ignore the scheduler and
create a CF page that does your fetch one time.

THEN use the scheduler to run that page once an hour.

To do what you want you'd (if I understand correctly) you'd use
CFEXECUTE to run the command to LiveUpdate.  That's it, right?
LiveUpdate handles installing the file and everything, right?

Once that's done save the page on your server.  Now use the scheduler to
run that file once per hour.

Jim Davis

> -Original Message-
> From: Rafael Bleiweiss [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 5:40 AM
> To: CF-Talk
> Subject: question / scheduled tasks CF 5 specific
> 
> Having difficulty finding examples or better documentation on the CF 5
> Scheduler...
> 
> I'm about to attempt to try for the first time to run a scheduled task
> once
> an hour on my server - Win2K, IIS, and CF 5.   I want to schedule a
task
> that automatically retrieves the latest Symantic virus definition
files
> hourly instead of the minimum daily that the System Center console
allows
> for directly.
> 
> It's literally a one line code thing - a command prompt execution of
the
> Live Update system configured to only get the definition files and
exclude
> product updates.
> 
> As the documentation is overly thin for someone unfamiliar with this
sort
> of process, I have CLUE ZERO regarding how to execute a server based
> executable with command line variables through the scheduler, as the
only
> "option is CFHTTP...
> 
> So.. any help or pointing to more info is extremely appreciated...
> 
> AND ALSO I've heard (even today on this list) that CF 5 doesn't handle
> Scheduled events too well - THOUGHTS?  COMMENTS?
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Upgrading to 6.1 fails : "web server connector update failed"

2003-08-20 Thread Brook Davies
After the install finishes, it says the "web server connector update 
failed". And gives the option of rebooting and trying to install the 
connectors after the reboot or reverting to the previously installed 
version. I have tried the reboot method, which again fails after reboot and 
automatically proceeds with the revert to previous version so I can not 
just run the connectors. I wish I could. Neither option allows for me to do 
that before it reverts to the original.

I have tried stopping all the webservices and CFMX and this does not 
help.  Is there anything else I can try before a full reinstall?

Brook Davies


At 12:23 PM 8/20/2003 -0400, you wrote:
> > You probably neglected to stop your web server before running
> > the install.
> >
> > Do a full un-install of ColdFusion. Reboot. STOP your web
> > server (eg: IIS) - usually done under Administrator Tools
> > /Services.
> >
> > Re-install MX 6.1.
>
>Yikes! You shouldn't have to uninstall CF if the web server connector
>install fails - just run the web server connector stuff after the install.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: Oracle Licensing

2003-08-20 Thread Bryan Stevenson
I know nothing about Oracle licensing (except it's really expensive)but
I do know to NEVER trust a saleperson ;-)

I'd call the original salesperson and run it by him/her.  If that person
screwed up...it's Oracle's fault for having a salesperson misrepresenting
the factsthey should GIVE you the correct licences if they were wrong
IMHO

Good luck

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Haggerty, Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 7:46 AM
Subject: OT: Oracle Licensing


> I just completed a call with the Oracle rep (who is a salesman) for my
> organization and received some feedback about our licensing that has me
> more than a little confused. I am wondering if anyone can offer some
> insight or advice to help me understand the situation.
>
> Back in 1999, our organization purchased parallel licenses for 2 Oracle
> servers with 8 concurrent users. My understanding (and our CIOs) was
> that ColdFusion would count as 1 user on each machine and we would have
> 7 developers on each box. Additionally, our understanding was that we
> need no licenses for a development box.
>
> The person I just spoke to explained that these licenses are not valid
> for the purpose of distributing information over the Internet (i.e. that
> using CF, PHP or anything else to draw data from the server) and that we
> will need to migrate to a per-processor model immediately in order to be
> in compliance. He also said that using a copy of Oracle for development
> purposes would require that we purchase licenses for the development
> boxes as well (which, incidentally, is at the same cost as a full blown
> production server).
>
> Before I contact the sales representative we originally spoke to on the
> matter, I wanted to see if anyone has had similar experiences or is
> familiar with the Oracle concurrent user licensing model in regards to
> the use of dynamic Web pages. I am thinking that under the terms of the
> license we originally purchased should cover the use of ColdFusion and
> that this guy is just trying to get me to buy stuff.
>
> M
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


hard returns and text areas

2003-08-20 Thread Mike Mertsock
Not sure if you need to implement it in Javascript or CF. Here's both versions:





document.forms.formName.foo.value = document.forms.formName.foo.value.replace(/\n/, " 
");
//note that this is using a regular expression (delimited by the / slashes)

You could put the javascript snippet in a function that gets called in the textarea's 
onchange attribute, or maybe the form's onsubmit attribute...whatever you need to do.

Good luck
Mike Mertsock
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: question / scheduled tasks CF 5 specific

2003-08-20 Thread Dave Watts
> Having difficulty finding examples or better documentation 
> on the CF 5 Scheduler...
> 
> I'm about to attempt to try for the first time to run a 
> scheduled task once an hour on my server - Win2K, IIS, and 
> CF 5. I want to schedule a task that automatically retrieves 
> the latest Symantic virus definition files hourly instead of 
> the minimum daily that the System Center console allows for
> directly.
> 
> It's literally a one line code thing - a command prompt 
> execution of the Live Update system configured to only get 
> the definition files and exclude product updates.
> 
> As the documentation is overly thin for someone unfamiliar 
> with this sort of process, I have CLUE ZERO regarding how to 
> execute a server based executable with command line variables 
> through the scheduler, as the only "option is CFHTTP...
> 
> So.. any help or pointing to more info is extremely 
> appreciated...

You can only run HTTP requests with the CF scheduler. If you wanted to run a
program on your own server, and if that program doesn't have a CGI
interface, you'd have to write a CF page that used CFEXECUTE to run the
program, and schedule the execution of that page.

However, I'd recommend that you just use your OS scheduler instead. On
Windows, it's the Task Scheduler, which you can manage through the Windows
GUI or using the "at" command from a command prompt. This way, you can take
CF entirely out of the process.

> AND ALSO I've heard (even today on this list) that CF 5 
> doesn't handle Scheduled events too well - THOUGHTS? COMMENTS?

Many people have encountered problems with the CF scheduler in CF 5 and
earlier versions; a common solution is to use the OS scheduler even when you
want to execute a CF page.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: hard returns and text areas

2003-08-20 Thread Jacob
use replace to replace "chr(13)" with what ever you like.

replace("#string#","chr(13)"," ","ALL")

At 10:22 AM 8/20/2003 -0400, you wrote:
>hi. does anyone know of a way to identify that a user has entered a hard
>return into a text-area and then pull those hard returns out (or replace
>them with just a single space).  any help is greatly appreciated. thanks
>very much.
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: oracle datasource as OLEDB

2003-08-20 Thread DDB Lists
The Microsoft ODBC driver for Oracle seems to be the best companion for CF,
so you might want to try that.

- Original Message -
From: "Sheila Handler" <[EMAIL PROTECTED]>
> Is it possible to define an Oracle database with OLEDB, or do I have to
use
> ODBC? Can anyone give me some hints about defining an Oracle datasource?

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


XML/XPATH

2003-08-20 Thread Ian Skinner
> Ok, I'm trying to get my head around this XML stuff.  I've got a
> document/structure something like this.
> 
> 
>
>   News
>
>
>   Event
>
>
>   News
>
>
>   Event
>
>
>   Headline
>
> 
> 
> What would I want to do (in ColdFusion at this time) is parse this
> structure and return a subset structure such as below!  In other words, I
> want to return a structure only containing "type" nodes of a certain
> value.  I have tied every way I could think of to use xmlsearch() and an
> xpath string to get this, but can't seem to quite get it right.
> 
> 
>
>   Event
>
>
>   Event
>
> 
> 
> The closet I've gotten is this.   XmlSearch(masterXML,"/root/article[type = 'Event']")>.  But, this returns
> an Array of XML structures, when what I really want is a single XML
> structure.
> 
> newXML[1]=
>   
>  Event
>   
> newXML[2]=
>   
>  Event
>   
> 
> What relatively basic concept am I not getting here?
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> Sacramento, CA
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re:

2003-08-20 Thread Jochem van Dieten
Sean Hynes wrote:
> Anyone got any ideas on why CFMAIL is doing this?
> 
> One last thing is it 6.0 MX with update 3 OR iMS mail. (coolfusion.com) OR 
> Some setting?
> 
> THIS DOESN'T work

What is the error message? If you don't get one immediately it 
will be in your mailserver logs.

Jochem


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Congressional Data

2003-08-20 Thread Chuck Rodgers
Hi,

I did that and searching for congress data or congressional data did not
turn up anything.

Chuck Rodgers

- Original Message - 
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 12:14 PM
Subject: Re: Congressional Data


> I seem to recall this data being asked for a year or so ago on this
> list.might want to check the archives
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
>
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> - Original Message -
> From: "Chuck Rodgers" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 20, 2003 8:46 AM
> Subject: OT: Congressional Data
>
>
> > Hi,
> >
> > I am working with an association that wants to do some advocacy work
with
> their members.  We are looking for data for zip codes and congressional
> districts to do lookups for Representatives in Congress.  Anyone have any
> experience finding this kind of data?
> >
> > Thanks
> >
> > Chuck Rodgers
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re:

2003-08-20 Thread Thomas Chiverton
On Wednesday 20 Aug 2003 07:53 am, Sean Hynes wrote:
> THIS DOESN'T work if its an outside mail server address:

Do you get any error messages in the main log or mail log ? 
Does the message get spooled ?
Can you see SMTP traffic ?

-- 
Tom Chiverton (sorry 'bout sig.)
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: null null errors

2003-08-20 Thread Bryan F. Hogan
Sorry I forgot to repost. The null null was reported to me from my the
global error. I took it off to see the normal error page and it was a index
out of range problem. Index out of range is much more descriptive than null
null and I was able to correct the problem with a simple cfbreak.

I wonder why the errors returned from the site wide error template are
differant than the ones on the normal error page.

-Original Message-
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 10:08 AM
To: CF-Talk
Subject: RE: null null errors


Can you be more specific? Are you seeing this in a page or in a log
file?


~~
Stephenie Hamilton
Macromedia Certified ColdFusion Professional
CFXHosting

Do you want complete ColdFusion Administrator access?
- CFX-Advanced VPS -
http://www.cfxhosting.com/Plans/s_cfxadvancedVPS.cfm




-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 6:55 PM
To: CF-Talk
Subject: null null errors


Anyone have any ideas as to what a "null null" error is?


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


  1   2   >