Re: Flash Remoting bug, feature.... in variable persistence

2002-12-13 Thread Sean A Corfield
On Thursday, Nov 21, 2002, at 07:20 US/Pacific, [EMAIL PROTECTED] 
wrote:
> Personally, I do not see much use for Remoting as a webservice, at 
> least beyond fundamental operations.  By building a fascade a CFC is 
> forced to return control to the application developer, in my case, 
> revealing far more information and control than I would like, and 
> further increasing development time for both ColdFusion and Flash.

I've been puzzling over this assertion and I still don't really 
understand it. By building a facade for Flash Remoting, you *hide* 
information and you *retain* control - you provide a very specific 
interface to Flash and how you manage state information is entirely 
transparent (you can use session scope, a database, whatever).

> The intent was a black box: the user requests, the CFC figures out how 
> to handle it and returns, not vice-versa.

And that's exactly how it works. A request is made, the CFC (facade) 
figures out how to handle it and returns.

You are then free to design your server-side code however you like and 
modular design will probably lead you to create several stateless 
'service' CFCs, some stateful 'object' CFCs - and your facade - which 
can lead to much more reuse.

> The problem is, in my case, that an outside developer could 
> potentially unnecessarily burdening the server with requests to 
> rebuild a query because an overly agressive application and would ruin 
> overall performance for everyone.

So I think your main concern is that you don't want to expose 
everything as a Web Service? And of course, you don't need to - the 
facade is the only Web Service and it can use authentication to ensure 
that no "outside developer" could call it. The CFC that deals with the 
query is then kept outside the wwwroot and called as needed from the 
secure Web Service.

> That doesn't even go to the fact that code that could be handled in 
> one place is now pushed out to every application built around it... so 
> much for reuse.

Pushed out how? A facade *encapsulates* rather than exposes - it 
encourages reuse.

> In short, for Flash Remoting to be more than a 'toy', there needs to 
> be a mechanism that keeps the object resident at least for the term of 
> execution.

There is - shared scopes on the server.

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/

Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: Flash remoting

2002-12-13 Thread Sean A Corfield
On Friday, Dec 13, 2002, at 17:06 US/Pacific, Paul Johnson wrote:
> We are experiencing difficulties getting flash remoting to work on
> multiple ites. Works fine for one
> http://local.thrive3test.co.nz/flashservices/gateway), but not others.
..
> Interestingly, when I place the CFC which is not responding into
> C:\CFMX\wwwroot it suddenly works.

This is the key: CFCs must be web accessible in order to be accessed 
via Flash Remoting - they must, essentially, be Web Services.

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/

Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: Persistent CFC's in the client scope

2002-12-13 Thread Sean A Corfield
On Monday, Nov 4, 2002, at 14:10 US/Pacific, Sean A Corfield wrote:
> On Monday, Nov 4, 2002, at 11:21 US/Pacific, Brook Davies wrote:
>> Sean, our current setup uses client vars for future clustering
>> considerations. I've heard that CFMX uses a new session scheme with
>> better support for clustering. How does this work and does it require
>> Enterprise?
> Right now, I don't have all the specific details of how exactly my team
> will be making this work. However, it has just become part of my job to
> become *very* familiar with our CFMX for J2EE on JRun 4 configuration!
> That means that I will know a lot about how *my*team* is making this
> happen but I may not be able to say whether *other* configurations will
> let you do the same thing.
>
> My *feeling* is that you will need CFMX for J2EE on top of JRun 4 - I
> believe it relies on the underlying J2EE clustering mechanism. I will
> report back with more information as and when I know more...

Well, it's been over a month since I said I'd report back - apologies , 
but it's been a busy month! - and I can tell you a little bit about how 
we're doing this now.

We are indeed using CFMX for J2EE on JRun 4. We are telling CFMX to use 
J2EE sessions and then we are using the underlying JRun clustering 
functionality to manage our CFMX server instances. The load balancing 
in JRun is quite configurable and your session 'sticks' to the server 
instance on which it was created. We're using session scope rather than 
client scope.

I'll probably be able to tell you more about this in a few weeks when 
we've done more load testing and more tuning.

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/

Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Form inside a loop problem - advise please!

2002-12-13 Thread S . Isaac Dealey
> I've got a cfloop/form structure set up to allow a user to
> update one or two
> specific fields in specific records.

> ID of Record = #MyQuery.Record_ID#
> Data field to update = BOB

> The loop and form sorta like (not real code):

> 
> 
>   
>   
>   
>   UPDATE dbo.app_Master
> SET BOB = '#evaluate("FORM.BOB_#UpdateID#")#',
> WHERE MSTR_ID= '#UpdateID#'
>   
> 

> I'm having trouble getting only the specific record to
> update though... it wants to update them all..

You mean only the records that have changed? ...

the update statement looks a little funny -- where mstr_id = '#updateid#'
.. if this is coming from form.recid and form.recid is a comma delimited
list of myquery.record_id, did you use an alias in myquery? Or does
myquery.record_id == dbo.app_Master.mstr_id ? I only ask because the column
names are different, so presumably if you're updating the same table in your
db, you'd have had to either used an alias in the query on the form page,
mis-paraphrased the form page code, or you'd be attempting the update with
probably the wrong unique identifiers.

If you want to update only the records which were changed on the form, then
you need to pass an additional hidden form field with each select box to
indicate the original values for comparison.

Also, I'd change your evaluate -- it's probably better to use this

UPDATE dbo.app_Master
SET BOB = '#form["BOB_#updateid#"]#'
WHERE MSTR_ID = '#UpdateID#'

It won't solve your problem, but it's less code and it's more efficient for
the server.

hth

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

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

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Form inside a loop problem - advise please!

2002-12-13 Thread brook
Sorry, my mistake, I see it now in the loop. Have you turned on debugging 
and looked at the resulting SQL? Also, maybe you do not need the single 
quotes around the UpdateID, if it is an Int...



At 10:08 PM 12/13/2002 -0500, you wrote:
>I've got a cfloop/form structure set up to allow a user to update one or two
>specific fields in specific records.
>
>ID of Record = #MyQuery.Record_ID#
>Data field to update = BOB
>
>The loop and form sorta like (not real code):
>
>
> 
>   
>   
>   
>   UPDATE dbo.app_Master
> SET BOB = '#evaluate("FORM.BOB_#UpdateID#")#',
> WHERE MSTR_ID= '#UpdateID#'
>   
>
>
>I'm having trouble getting only the specific record to update though... it
>wants to update them all..
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Form inside a loop problem - advise please!

2002-12-13 Thread brook
Where does the UpdateID come from? Maybe it should Form.RecID, no?


At 10:08 PM 12/13/2002 -0500, you wrote:
>I've got a cfloop/form structure set up to allow a user to update one or two
>specific fields in specific records.
>
>ID of Record = #MyQuery.Record_ID#
>Data field to update = BOB
>
>The loop and form sorta like (not real code):
>
>
> 
>   
>   
>   
>   UPDATE dbo.app_Master
> SET BOB = '#evaluate("FORM.BOB_#UpdateID#")#',
> WHERE MSTR_ID= '#UpdateID#'
>   
>
>
>I'm having trouble getting only the specific record to update though... it
>wants to update them all..
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Help with this Struct question, please

2002-12-13 Thread S . Isaac Dealey
> You should replace:
> StructIsEmpty(newsbank.collection.nbx[newsNum].HEADERFIELD
> S.SHL)

> With:
> NOT (StructKeyExists(newsbank.collection.nbx[newsNum].HEAD
> ERFIELDS,
> "SHL") AND NOT
> StructIsEmpty(newsbank.collection.nbx[newsNum].HEADERFIELD
> S.SHL))

I don't think this short-circuit it quite right ... ( though it's easier to
see when the variable names are shorter ) ... what I'm reading is

NOT (StructKeyExists(mystruct,"mykey")
AND NOT StructIsEmpty(mystruct.mykey))

I suspect, what you really want is the reverse, since this will check to see
if the key exists and then attempt to read the key whether it exists or not,
which will produce an error if it doesn't exist. So I suspect you're looking
for this:



It's that extra NOT and () that I suspect will get you...

Or possibly:




> I've also tried ing
> newsbank.collection.nbx[newsNum].HEADERFIELDS.SHL.VALUE,
> and CF spits
> back profanity at me for that one as well.

There's usually a way to change the syntax to make something like this work

If NewsNum is actually a number, you're not going to be able to get away
with


Oh -- you might (probably) ought to param shl before you param shl.value ...

If NewsNum is actually a number, you should copy that structure to a local
variable, as James suggested -- makes things easier and helps you avoid
syntactical traps like the param above:




hth


s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

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

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Form inside a loop problem - advise please!

2002-12-13 Thread Les Mizzell
I've got a cfloop/form structure set up to allow a user to update one or two
specific fields in specific records.

ID of Record = #MyQuery.Record_ID#
Data field to update = BOB

The loop and form sorta like (not real code):



  
  
  
  UPDATE dbo.app_Master
SET BOB = '#evaluate("FORM.BOB_#UpdateID#")#',
WHERE MSTR_ID= '#UpdateID#'
  


I'm having trouble getting only the specific record to update though... it
wants to update them all..

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: SQL to select data from a Graph /Poll Results

2002-12-13 Thread brook
Okay, I answered my own question and used this:

 
 SELECT count(#QuestionName#) as totalper,#QuestionName# as Answer
 FROMtblwebpolls
 WHERE   #QuestionName# IS NOT NULL
 AND #QuestionName# <> ''
 GROUP BY#QuestionName#
 ORDER BY  #QuestionName# ASC
 

Brook

At 05:35 PM 12/13/2002 -0800, you wrote:
>I trying to write some SQL that will efficiently return information to
>create a web poll results graph. The database has 1 field, "pollresponse",
>which will contain 1 of 3 possible answers. I have these answers, and can
>use them in the query if necessary.
>
>How can I query this table and find out 1) the total number of submission
>where the field is not empty, 2) the number of votes for any of the 3
>possible responses.
>
>Is there some way I can do this with one query? If there is, I can't find
>it... Thanks for the assist!
>
>Brook
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



test

2002-12-13 Thread Paul Johnson
 

 

  _  


Cabbage Tree Creative Ltd.
Paul Johnson | web programmer
Phone+64 3 377 7544
Email    [EMAIL PROTECTED]
Web www.cabbagetree.co.nz

manage your own web site with Thrive - contact us to learn how!

   

 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



SQL to select data from a Graph /Poll Results

2002-12-13 Thread brook
I trying to write some SQL that will efficiently return information to 
create a web poll results graph. The database has 1 field, "pollresponse", 
which will contain 1 of 3 possible answers. I have these answers, and can 
use them in the query if necessary.

How can I query this table and find out 1) the total number of submission 
where the field is not empty, 2) the number of votes for any of the 3 
possible responses.

Is there some way I can do this with one query? If there is, I can't find 
it... Thanks for the assist!

Brook


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Help with this Struct question, please

2002-12-13 Thread James Ang
You should replace:
StructIsEmpty(newsbank.collection.nbx[newsNum].HEADERFIELDS.SHL)

With:
NOT (StructKeyExists(newsbank.collection.nbx[newsNum].HEADERFIELDS,
"SHL") AND NOT
StructIsEmpty(newsbank.collection.nbx[newsNum].HEADERFIELDS.SHL))

If the above does not work, you should try this:









In pre-MX CFML, adding dots after [] is a bad idea and can cause hard to
debug problems.


James Ang
Programmer
MedSeek, Inc.
[EMAIL PROTECTED]



-Original Message-
From: Howard Owens [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 3:40 PM
To: CF-Talk
Subject: Help with this Struct question, please


I have an XML document -- a collection of newsstories that I'm trying to
parse.

I'm using CF_SOXML to read the data and convert it to structures and
arrays.

There is an optional field in the XML called SHL.

Since the key of the struct doesn't always exist, I'm trying to find a
way to intelligently deal with it.

Here's what I've tried (everything has failed, so far):







I've also tried StructKeyExists() and IsStruct()

And each time I get an error that looks something like this:


An error occurred while evaluating the expression: 
 StructIsEmpty(newsbank.collection.nbx[newsNum].HEADERFIELDS.SHL)
Error near line 54, column 7. 
The member "SHL" in dimension 0 of object "HEADERFIELDS" cannot be
found. Please, modify the member name.

I've also tried ing
newsbank.collection.nbx[newsNum].HEADERFIELDS.SHL.VALUE, and CF spits
back profanity at me for that one as well.

H.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: cffile and server 4.5 issues??

2002-12-13 Thread Troy Montour
Matt thanks I will make sure the server has sp2 installed

- Original Message -
From: "Matt Robertson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 13, 2002 7:04 PM
Subject: Re: cffile and server 4.5 issues??


> Personally I'm running 4.51sp2 and it works great 100% of the time.  My
clients do boatloads of cffile-based image uploads, both out of ActivEdit
and stuff I made for them.
>
> ---
> Matt Robertson, MSB Designs, Inc.
> http://mysecretbase.com - Retail
> http://foohbar.org - ColdFusion Tools
> ---
>
>
> -- Original Message --
> from: "Troy Montour" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> date: Fri, 13 Dec 2002 18:52:15 -0600
>
> >Hello everyone,
> >was wondering anyone know if there is an issue with cffile tag and
4.5
> >server.. getting weird glitches of no errors but it bombs out when you
> >upload gifs/jpgs but not always about 85% of the time.
> >
> >
> >Thank you
> >Troy Montour
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Flash remoting

2002-12-13 Thread Paul Johnson
We are experiencing difficulties getting flash remoting to work on
multiple ites. Works fine for one
http://local.thrive3test.co.nz/flashservices/gateway), but not others. 

 

We have noted the advice on
http://www.macromedia.com/support/flash_remoting/ts/documents/iis_gatewa
y_connection.htm

and applied the fix described.

 

I have executed

c:\cfusionmx\runtime\bin\wsconfig.exe -v -u

c:\cfusionmx\runtime\bin\wsconfig.exe -ws IIS -site 0
-filter-prefix-only -map .cfm,.cfc,.cfml -v

 

AND DONE

 

1. Stop CF MX.

2. Delete the contents of the
C:\CFusionMX\runtime\servers\default\SERVER-INF\temp

directory.

3. Restart CF MX which redeploys the Flash Remoting gateway.

 

I get a blank page (which is the correct response) at
http://local.adventure.co.nz/flashservices/gateway and
http://local.thrive3test.co.nz/flashservices/gateway and
http://local.thrive.co.nz/flashservices/gateway.

 

I am getting a response from CFC's via cold fusion pages containing
flash movies calling the cfcs in the local.thrive.co.nz site. This is
calling the http://local.thrive.co.nz/flashservices/gateway.

 

However, no response can be got from the
http://local.adventure.co.nz/flashservices/gateway OR
http://local.thrive3test.co.nz/flashservices/gateway beyond the fact we
have a blank screen. In the Flash authoring environment we are getting
results back from all three sites when pressing ctrl Enter to testing
the movie.

 

Interestingly, when I place the CFC which is not responding into
C:\CFMX\wwwroot it suddenly works.

 

We are running CFMX (not updated, recently reinstalled) and IIS.

 

Any advice??

 

Many thanks.

 

Paul Johnson




Re: cffile and server 4.5 issues??

2002-12-13 Thread Matt Robertson
Personally I'm running 4.51sp2 and it works great 100% of the time.  My clients do 
boatloads of cffile-based image uploads, both out of ActivEdit and stuff I made for 
them.

---
Matt Robertson, MSB Designs, Inc.
http://mysecretbase.com - Retail
http://foohbar.org - ColdFusion Tools
---


-- Original Message --
from: "Troy Montour" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Fri, 13 Dec 2002 18:52:15 -0600

>Hello everyone,
>was wondering anyone know if there is an issue with cffile tag and 4.5
>server.. getting weird glitches of no errors but it bombs out when you
>upload gifs/jpgs but not always about 85% of the time.
>
>
>Thank you
>Troy Montour
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



cffile and server 4.5 issues??

2002-12-13 Thread Troy Montour
Hello everyone,
was wondering anyone know if there is an issue with cffile tag and 4.5
server.. getting weird glitches of no errors but it bombs out when you
upload gifs/jpgs but not always about 85% of the time.


Thank you
Troy Montour

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: Does anyone know how to check a file type when uploading?

2002-12-13 Thread S . Isaac Dealey
#cffile.clientfileext# will give you the 3-5 character extension from the
file prior to the upload.

> Can anyone help with this?
> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> 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 dealey954-776-0046

new epoch  http://www.turnkey.to

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

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Sessions Not working?

2002-12-13 Thread Costas Piliotis
Actually...  Hostname had underscores in it.  Illegal hostname for IE.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q312461

Found a needle in a haystack...

-Original Message-
From: Peter Mayer [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 3:17 PM
To: CF-Talk
Subject: RE: Sessions Not working?


Have you played around with the cfapplication settings (setdomaincookie)?

Best regards,

Peter


Orginale Nachricht
Von: Costas Piliotis <[EMAIL PROTECTED]>
Betreff: RE: Sessions Not working?
Datum/Zeit: Friday, 13. December 2002 23:09:35 

> Anybody?
> 
> -Original Message-
> From: Costas Piliotis
> Sent: Friday, December 13, 2002 11:48 AM
> To: CF-Talk
> Subject: Sessions Not working?
> 
> 
> I have a client that has set up a site, and they are having session
issues.
>  
> When accessing a site using the IP Address, everything works fine.
>  
> When accessing the same site using a hostheader, coldFusion doesn't 
> seem

to
> start a session.
>  
> I have checked to see if the cookie gets written at the start of the 
> session, and in fact it isn't being written with that host header.  
> Has anyone seen this before, or am i just on glue?
>  
>  
>  
> Costas Piliotis
> Guru
> Voyus Canada Inc.
> T: 604.630.5655 (direct line)
> F: 604.320.6568
> E-Mail:   [EMAIL PROTECTED]
>  
> The information in this email is confidential and may be legally
privileged.
> It is intended solely for the addressee. Access to this email by 
> anyone

else
> is unauthorized. If you are not the intended recipient, any 
> disclosure, copying, distribution or any action taken or omitted to be 
> taken in
reliance
> on it, is prohibited and may be unlawful. When addressed to our 
> clients

any
> opinions or advice contained in this email are subject to the terms 
> and conditions expressed in the applicable Voyus Canada Inc. client
engagement
> contract
>  
> http://www.voyus.com/ 
> 
>  
> 
> 
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



Does anyone know how to check a file type when uploading?

2002-12-13 Thread Eric Creese
Can anyone help with this?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Updater 2 and Oracle = 30 FIXES and 20% FASTER!

2002-12-13 Thread Damon Cooper
BTW, we should have a fix from DataDirect for this issue (15004052) in the next couple 
days...as soon as we get it, I'll have it posted in a TechNote and I'll post here.

Again, we pointed this out at the very top of the Release Notes for Updater 2, and the 
specific issue is if you are using Oracle Reference Cursors where you also have 
multiple procedures inside the reference cursor package (ref cursor packages with only 
one procedure are fine, so a possible workaround, if you're doing development, is to 
break each procedure into it's own package for now.




Updater 2 and Oracle = 30 FIXES and 20% FASTER!

2002-12-13 Thread Damon Cooper
The only issue we know about is if you are (and this is VERY specific): 

- using Oracle Reference Cursors
- those Reference Cursor packages have multiple procedures

Otherwise, there are something like 30 important Oracle fixes, plus very nice 
**15-20%** performance boost you'll pick up in the Updater 2 package for Oracle apps.

--
Date: Fri, 13 Dec 2002 16:30:40 -0600
From: [EMAIL PROTECTED]
Subject: Updater 2 and Oracle ?
Message-ID: <[EMAIL PROTECTED]>

I saw a quick mention in a post about known issues with updater 2 and 
Oracle.  I can't seem to find any information on this.  Does anyone have 
details?  Or, does anyone know if updater 1 is still available?  I need to 
get the dateDiff fix, but I can't have it cause problems with Oracle.

Thanks,
Erica



Help with this Struct question, please

2002-12-13 Thread Howard Owens
I have an XML document -- a collection of newsstories that I'm trying to parse.

I'm using CF_SOXML to read the data and convert it to structures and arrays.

There is an optional field in the XML called SHL.

Since the key of the struct doesn't always exist, I'm trying to find a way to 
intelligently deal with it.

Here's what I've tried (everything has failed, so far):







I've also tried StructKeyExists() and IsStruct()

And each time I get an error that looks something like this:


An error occurred while evaluating the expression: 
 StructIsEmpty(newsbank.collection.nbx[newsNum].HEADERFIELDS.SHL)
Error near line 54, column 7. 
The member "SHL" in dimension 0 of object "HEADERFIELDS" cannot be found. Please, 
modify the member name.

I've also tried ing newsbank.collection.nbx[newsNum].HEADERFIELDS.SHL.VALUE, 
and CF spits back profanity at me for that one as well.

H.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Updater 2 and Oracle ?

2002-12-13 Thread Stacy Young
If it's a "new break" I'd fire off an email to 
Damon Cooper [ [EMAIL PROTECTED] ]
With the details!

-Stace

-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 5:48 PM
To: CF-Talk
Subject: RE: Updater 2 and Oracle ?

>The number of Oracle fixes outweigh the non-fixes for us by a long shot

Yeah, it's probably not a big issue for most people (of course, it's not a
non-fix as much as it is a new-break).  It just happens to occur in the
start page for our app, which makes it a pretty big deal for us.

Scott

Scott Brady
http://www.scottbrady.net/
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread paul smith
In my experience with storing recordsets in cached structures, subsequent 
reading records from the structure was slower than reading the same records 
from a cached query.

Is this expected behavior, or did I screw up? (first time again)

best,  paul


At 04:29 PM 12/13/02 -0500, you wrote:
> > One thing to check is whether CFSEARCH allows caching
> > (Studio doesn't think it does, which agrees with my
> > recollection). If your app is as amenable to caching
> > queries as www.SMARTERyellowPages.com is, then your
> > choice may be clear.
>
>While you can't use CACHEDWITHIN or CACHEDAFTER attributes with CFSEARCH as
>you can with CFQUERY, you can certainly cache a recordset from CFSEARCH by
>storing it in a persistent variable.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: cfcatch.nativeErrorCode and sqlstate?

2002-12-13 Thread Chris Norloff
Using only cfquery?  No, cfcatch.nativeErrorCode is part of the cfcatch scope.

But it's easy to wrap a ctry/catch around the query, and then you'll have 
cfcatch.nativeErrorCode and cfcatch.sqlstate. We get them when triggers or stored 
procedures fail (CF 4.5 SP2, Solaris, Oracle 9i)

Chris Norloff


-- Original Message --
from: jon hall <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Fri, 13 Dec 2002 16:54:37 -0500

>  Is there any way in CF5 to get this information using only cfquery?
>  In particular I am having a problem where a trigger is returning an
>  error, but not throwing an error.
>
>-- 
> jon
>  mailto:[EMAIL PROTECTED]
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Sessions Not working?

2002-12-13 Thread Peter Mayer
Have you played around with the cfapplication settings (setdomaincookie)?

Best regards,

Peter


Orginale Nachricht
Von: Costas Piliotis <[EMAIL PROTECTED]>
Betreff: RE: Sessions Not working?
Datum/Zeit: Friday, 13. December 2002 23:09:35 

> Anybody?
> 
> -Original Message-
> From: Costas Piliotis 
> Sent: Friday, December 13, 2002 11:48 AM
> To: CF-Talk
> Subject: Sessions Not working?
> 
> 
> I have a client that has set up a site, and they are having session 
issues.
>  
> When accessing a site using the IP Address, everything works fine.
>  
> When accessing the same site using a hostheader, coldFusion doesn't seem 

to
> start a session.
>  
> I have checked to see if the cookie gets written at the start of the
> session, and in fact it isn't being written with that host header.  Has
> anyone seen this before, or am i just on glue?
>  
>  
>  
> Costas Piliotis
> Guru
> Voyus Canada Inc.
> T: 604.630.5655 (direct line)
> F: 604.320.6568
> E-Mail:   [EMAIL PROTECTED]
>  
> The information in this email is confidential and may be legally 
privileged.
> It is intended solely for the addressee. Access to this email by anyone 

else
> is unauthorized. If you are not the intended recipient, any disclosure,
> copying, distribution or any action taken or omitted to be taken in 
reliance
> on it, is prohibited and may be unlawful. When addressed to our clients 

any
> opinions or advice contained in this email are subject to the terms and
> conditions expressed in the applicable Voyus Canada Inc. client 
engagement
> contract
>  
> http://www.voyus.com/  
> 
>  
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Updater 2 and Oracle ?

2002-12-13 Thread Scott Brady
>The number of Oracle fixes outweigh the non-fixes for us by a long shot

Yeah, it's probably not a big issue for most people (of course, it's not a non-fix as 
much as it is a new-break).  It just happens to occur in the start page for our app, 
which makes it a pretty big deal for us.

Scott

Scott Brady
http://www.scottbrady.net/
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Updater 2 and Oracle ?

2002-12-13 Thread Stacy Young
We've been testing U2 with Oracle and haven't experienced any problems.
(knocks on wood)

No stored procs though...

Stace

-Original Message-
From: Kevin Bridges [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 5:38 PM
To: CF-Talk
Subject: RE: Updater 2 and Oracle ?

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx
_updater.html#knownissues

The number of Oracle fixes outweigh the non-fixes for us by a long shot

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 3:31 PM
To: CF-Talk
Subject: Updater 2 and Oracle ?

I saw a quick mention in a post about known issues with updater 2 and 
Oracle.  I can't seem to find any information on this.  Does anyone have 
details?  Or, does anyone know if updater 1 is still available?  I need to 
get the dateDiff fix, but I can't have it cause problems with Oracle.

Thanks,
Erica



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Updater 2 and Oracle ?

2002-12-13 Thread Scott Brady
It's in the release notes (which I stupidly read AFTER I installed it).

I don't know a lot of the details, other than it deals with using reference cursors in 
Oracle 8i.

Scott

Scott Brady
http://www.scottbrady.net/

-- Original Message --
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Fri, 13 Dec 2002 16:30:40 -0600

>I saw a quick mention in a post about known issues with updater 2 and 
>Oracle.  I can't seem to find any information on this.  Does anyone have 
>details?  Or, does anyone know if updater 1 is still available?  I need to 
>get the dateDiff fix, but I can't have it cause problems with Oracle.
>
>Thanks,
>Erica
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Updater 2 and Oracle ?

2002-12-13 Thread Kevin Bridges
http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx
_updater.html#knownissues

The number of Oracle fixes outweigh the non-fixes for us by a long shot

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 3:31 PM
To: CF-Talk
Subject: Updater 2 and Oracle ?

I saw a quick mention in a post about known issues with updater 2 and 
Oracle.  I can't seem to find any information on this.  Does anyone have 
details?  Or, does anyone know if updater 1 is still available?  I need to 
get the dateDiff fix, but I can't have it cause problems with Oracle.

Thanks,
Erica


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: help a newbie with code pleazz

2002-12-13 Thread Dave Lyons
Thanks!

Dave Lyons
[EMAIL PROTECTED]
www.DreamLofts.com
www.DreamLofts-WebDesigns.com
 

-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 10:50 AM
To: CF-Talk
Subject: Re: help a newbie with code pleazz

On your action page, you can eliminate the need to press another form
button.
 

   

 Insert Into TABLE Values (INSERT YOUR SQL CODE
HERE)

 
 You have a free year's membership!
 
  
 
Insert Into TABLE Values (INSERT YOUR SQL CODE HERE)

 
Thank you for joining
 
  

 
 
 
 
 
 
 
 
 
 
 
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

>>> [EMAIL PROTECTED] 12/11/2002 3:17:25 PM >>>



 you have a free years membership!

 blah blah blah 







 Thank you for joining, click here to continue 

 blah blah blah 

I have no idea lol, pleaz help me or shoot
me:)

thanks!
dave

Dave Lyons
[EMAIL PROTECTED] 
www.DreamLofts.com 






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Updater 2 and Oracle ?

2002-12-13 Thread erica . lomax
I saw a quick mention in a post about known issues with updater 2 and 
Oracle.  I can't seem to find any information on this.  Does anyone have 
details?  Or, does anyone know if updater 1 is still available?  I need to 
get the dateDiff fix, but I can't have it cause problems with Oracle.

Thanks,
Erica

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Happy story with updater2?

2002-12-13 Thread Jesse Houwing
Angel Stewart wrote:

>Happy stories?
>
>Oh yes! 
>
>I installed the updater on a LOVELY sunny morning, with faint whisps of
>clouds in the sky, and a gentle easterly breeze!
>As the little progress bar chug chugged along I sipped on a cup of hot
>cappuchino whilst listening to some Louis Armstrong and munching on some
>warm blueberry muffins.
>
>Just as the updater finished, my girlfriend called and said that she had
>gotten complimentary tickets to a great movie showing tonight at the
>cinemaplex, and I heard that I was getting a substantial raise in the
>new year.
>
>A...
>*comfortable sigh*
>
>
>Anymore happy stories while installing updater 2?
>Anyone? Anyone? Bueller?
>
>-Gel
>;-)
>*chuckle*
>  
>
Cool, I wish my days were as bright as yours. Not that t had anything to 
do with our coldfusion server. That one is running like a charm. Not our 
PHP on IIS system got hacked, and I'm still searching how they did it. 
It seems that the Chatspace chat server taht was also installed on the 
damn thing did the trick. The stupid thing is, that they hacked the 
chatserver itself too, made a few channels and forgot that when you make 
a channel, it also saves WHO made it. So this afternoon in two seconds 
and two keywords in google we were staring at the picture of the 15 year 
old arsehole who made it possible for me to do nothing else next week 
than to gather more evidence and reinstall the damn server. Argh! One 
thing I know for sure... I'll be looking for a new chatserver. Anyone? 
We need an IRC server that runs on NT or 2000 and can withstand a bit 
more than this chatspace thingy.

Jesse

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Form validation & 508 compliancy

2002-12-13 Thread Dave Watts
> I realize that sometimes it's better to use client side 
> validation on forms... Sometimes server side... Sometimes 
> both.

Rather than answering your Section 508 question, I'll simply state that you
should always use server-side validation, whether you also use client-side
validation or not. This is important for security reasons, as well as for
clients that don't support JavaScript.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Form validation & 508 compliancy

2002-12-13 Thread Smith, Matthew P -CONT(DYN)
Agreed.

I'm not sure if it's presence is considered a "violation" of compliance,
though I would think that a user that it would cause problems for would have
it disabled.

Matthew P. Smith 
Web Developer, Object Oriented 
Naval Education & Training Professional 
Development & Technology Center 
(NETPDTC) 
(850)452-1001 ext. 1245 
[EMAIL PROTECTED] 


-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 4:15 PM
To: CF-Talk
Subject: RE: Form validation & 508 compliancy

>So if you are going to do server side to protect your app/data anyway, why
>even invest the extra work in JS...

Because as a User I prefer client-side validation to save me some trips to
the server, if possible.

For the 90% of users with it enabled, it can be user-friendly.

Of course, you should ALWAYS do server-side . . . . And, for most forms, the
client-side validation is pretty quick & easy to do [paricularly if you have
a set of standard validation functions you call].

Scott

Scott Brady
http://www.scottbrady.net/
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: DB Driver Inf / DB2 on AS/400 / Joe / PDF Ref Doc / etc etc

2002-12-13 Thread Damon Cooper
 We already have this file dated 12/11/2002. 

This one is very different, and should only be used for debugging (you need to restore 
the original when you're done debugging or you will have other problems).







RE: Form validation & 508 compliancy

2002-12-13 Thread Scott Brady
>So if you are going to do server side to protect your app/data anyway, why
>even invest the extra work in JS...

Because as a User I prefer client-side validation to save me some trips to the server, 
if possible.

For the 90% of users with it enabled, it can be user-friendly.

Of course, you should ALWAYS do server-side . . . . And, for most forms, the 
client-side validation is pretty quick & easy to do [paricularly if you have a set of 
standard validation functions you call].

Scott

Scott Brady
http://www.scottbrady.net/
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: DB Driver Inf / DB2 on AS/400 / Joe / PDF Ref Doc / etc etc

2002-12-13 Thread Joe Eugene
Thanks Damon..

>hope you don't mind me CC'ing CF-Talk,
NP.. i was going to put some private string details of the connection.. but i
took it out.

> IBM drivers?  (BTW, can you get connected with
> those?)
Yes.. this works very well.. and i think its faster than client access ODBC..
havent done any stress/performance testing though. Am curious if the
DataDirect Drivers will perform better...atleast "DataDirect Claims SO" and i
think they are using it somewhere in IBM Websphere.

> First, there's a bug in JRun4 (and therefore
> CFMX Server) - #48118,
"jrpatch.jar"

We already have this file dated 12/11/2002. I guess it came with CFMX Updater
2.

Do i still need to try the below instructions?
If "Yes".. will do and post the results this weekend or so..

Thanks again for you help.
Joe

On Fri, 13 Dec 2002 16:35:47 -0500 Damon Cooper <[EMAIL PROTECTED]>
wrote:

> Hey Joehope you don't mind me CC'ing
> CF-Talk, so everyone can use this info if
> necessary...
> 
> First, there's a bug in JRun4 (and therefore
> CFMX Server) - #48118,  that can obscure the
> actual JDBC exception that you're encountering,
> giving the generic one below. So let's first
> see what the actual error is you're
> encountering
> 
> 1) Shut down CFMX.
> 2) Grab this file: 
> ftp://ftp.allaire.com/outgoing/damonc/jrpatch.jar
> 
> 3) Move aside (and SAVE!) your existing
> {cf_root}/lib/jrpatch.jar (if you have one),
> and put this "jrpatch.jar" down as
> {cf_root}/lib/jrpatch.jar.
> 4) Start CFMX
> 5) Try to connect again and send the error
> you're getting
> 
> Next, I don't see any reference to "libraries"
> in the DataDirect documentation anywhere, so
> perhaps the concept is only relevant for the
> IBM drivers?  (BTW, can you get connected with
> those?)
> 
> The "Native" DB connections we have are
> essentially just direct convenience mappings
> for you...they're not treated "specially" in
> any way, except for setup, connection, and some
> easier-to-use panels for customers.
> 
> Connection pooling is achieved via our JDBCPool
> class.  The pooling behavior is defined by the
> DSN settings you've set up in the Admin...we'll
> create a new connection as necessary, and if
> you've not disallowed connection pooling, we'll
> re-use an existing connection if the connection
> info is the same, and there's one available in
> the pool.
> 
> 
> 
> -Original Message-
> From: Joe Eugene [mailto:[EMAIL PROTECTED]]
> 
> Sent: Friday, December 13, 2002 4:03 PM
> To: Damon Cooper
> Subject: RE: DB Driver Inf / DB2 on AS/400 /
> Joe / PDF Ref Doc / etc etc
> 
> 
> Hi Damon..
> 
> Connection failed with this error
> Connection verification failed for data source:
> SYSTEMB_DUDB
> []java.sql.SQLException: SQLException occurred
> in JDBCPool while attempting to connect, please
> check your username, password, URL, and other
> connectivity info. The root cause was that:
> java.sql.SQLException: SQLException occurred in
> JDBCPool while attempting to connect, please
> check your username, password, URL, and other
> connectivity info.
> 
> Is there anyway to know whether it created the
> package? Libraries are data space objects in
> DB400.. This is what my native(JTOpen)
> connection string looks like..
> jdbc:as400://200.0.0.0/DBDATA;libraries=JDB,JEB
> JDB and JEB are libraries.
> 
> Does CFMX treat "Native" DB connection
> different from default.. DB connections? How is
> connection pooling achieved? One Connection,
> mutiple statemens?
> 
> Thanks
> Joe
> 




OT: Best PHP Open Source Shopping Cart/E-Commerce Package?

2002-12-13 Thread Tony Schreiber
I know this is a bit off topic, but I'm looking for an alternative to my
own heavy CF application in a situation where I'd be better off using php.
I've found a lot of them, but none seem to deliver what they promise, or
they do so in an exceedingly ugly fashion.

Any suggestions?


Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999
http://www.simplemessageboard.comFree Forum Software for Cold Fusion

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Form validation & 508 compliancy

2002-12-13 Thread Kevin Graeme
The only issue with JavaScript is whether the feedback from it is readily
available to the user. So a rollover/dropdown menu isn't directly
accessible, but if you have the same links available elsewhere on the page
then you're fine. With client side form validation, you typically put up an
alert box that textually tells the person where the problem is, so in that
case you should be fine. If though, when you tab out of a field it causes
some dhtml text to show up elsewhere on the same page as an alert, there is
no way for a non-visual person to realize that some text showed up, so
that's not compliant.

-Kevin

> -Original Message-
> From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 13, 2002 2:31 PM
> To: CF-Talk
> Subject: OT: Form validation & 508 compliancy
>
>
> I realize that sometimes it's better to use client side validation on
> forms... Sometimes server side... Sometimes both.
>
> Are there any rules of thumb to using client side (JavaScript)
> validation on
> 508 compliant forms?
>
> Thanks :-)
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Problem with single quotes(CFMX)

2002-12-13 Thread Sean A Corfield
On Friday, Dec 13, 2002, at 11:26 US/Pacific, Joe Eugene wrote:
> select * from TableName where myField=apos;BMWapos;
>
> it was replacing "'" with string "apos;" . I tried a few 
> things(preserve,
> build string.. and some others). None of them worked. I finally 
> restarted the
> CFMX service.. and the query started working again. Strange... Any 
> idea.. how
> this might happen?

No idea. Sounds very strange. Can you reproduce it? I've never seen 
that behavior.

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/

Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Form validation & 508 compliancy

2002-12-13 Thread Smith, Matthew P -CONT(DYN)
I had to ask around, and the consensus was that they are not compliant.  I
think that the problem is that anything that changes the focus for the user
is frowned upon.  I'm not sure if it's a technical one, like the
screen-readers would have a problem with it, or if it's a more "general"
usability no-no.

I'll try to research it a bit further and let you know (our 508 guru already
left), but I my rule of thumb is to steer clear of it.

On a side note, I prefer to keep it server side any way, as I have heard
figures ranging from 5 to 20 percent of browser have JS disabled.  Also, it
keeps malicious users from entering bad data, and if they are there to do
so, they would most certainly disable all the client side validation.

So if you are going to do server side to protect your app/data anyway, why
even invest the extra work in JS...

My 2 cents.

Matthew P. Smith 
Web Developer, Object Oriented 
Naval Education & Training Professional 
Development & Technology Center 
(NETPDTC) 
(850)452-1001 ext. 1245 
[EMAIL PROTECTED] 


-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 2:31 PM
To: CF-Talk
Subject: OT: Form validation & 508 compliancy

I realize that sometimes it's better to use client side validation on
forms... Sometimes server side... Sometimes both.

Are there any rules of thumb to using client side (JavaScript) validation on
508 compliant forms?

Thanks :-)


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



cfcatch.nativeErrorCode and sqlstate?

2002-12-13 Thread jon hall
  Is there any way in CF5 to get this information using only cfquery?
  In particular I am having a problem where a trigger is returning an
  error, but not throwing an error.

-- 
 jon
  mailto:[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Login/Password screen

2002-12-13 Thread Kevin Graeme
The server sets it when the person authenticates to the server login. So you
just define the directory as restricted in the web server configuration,
then when a person requests anything in that directory or lower, the web
server intercepts it before anything else does and asks for a login.

The CF app can then read the #cgi.remote_user# variable and compare that
against a database of users for personalization if you like.

-Kevin

> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 13, 2002 11:19 AM
> To: CF-Talk
> Subject: RE: Login/Password screen
>
>
> Kevin
>
> How is CGi.remote_user set?
>
>
> Kola
>
> >> -Original Message-
> >> From: Kevin Graeme [mailto:[EMAIL PROTECTED]]
> >> Sent: 13 December 2002 16:04
> >> To: CF-Talk
> >> Subject: RE: Login/Password screen
> >>
> >> It's not a browser issue so much as on the server. The server stores
> a
> >> set
> >> of cgi.something variables that can be asked for by CF. We used to
> use
> >> cgi.auth_user, but when we switched over to Apache, that wasn't a
> valid
> >> cgi
> >> variable anymore. Now we use cgi.remote_user.
> >>
> >> -Kevin
> >>
> >> > -Original Message-
> >> > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> >> > Sent: Friday, December 13, 2002 9:36 AM
> >> > To: CF-Talk
> >> > Subject: RE: Login/Password screen
> >> >
> >> >
> >> > That's a good idea, does cgi.remoteuser work with all major
> browsers or
> >> > just i.e.?
> >> >
> >> > Thanks
> >> > Kola
> >> >
> >> > >> -Original Message-
> >> > >> From: Kevin Graeme [mailto:[EMAIL PROTECTED]]
> >> > >> Sent: 13 December 2002 14:33
> >> > >> To: CF-Talk
> >> > >> Subject: RE: Login/Password screen
> >> > >>
> >> > >> Keep in mind that a CF based authentication system is only
> checked
> >> > >> against
> >> > >> if the user hits a CFM page. That's fine for certain types of
> >> > projects,
> >> > >> but
> >> > >> not for actual file security. So if you have a directory of
> images
> >> in
> >> > the
> >> > >> "secure" area, a person could link directly to an image and
> bypass
> >> > the
> >> > >> login
> >> > >> altogether because a .gif doesn't reference the Application.cfm
> >> > first.
> >> > >>
> >> > >> We've been using the server level authentication and then using
> cf
> >> to
> >> > >> check
> >> > >> against the cgi.remote_user to see who it is. That means that
> ANY
> >> > attempt
> >> > >> to
> >> > >> get in at that protected area has to be authenticated against
> with
> >> > the
> >> > >> server.
> >> > >>
> >> > >> -Kevin
> >> > >>
> >> > >> > -Original Message-
> >> > >> > From: FlashGuy [mailto:[EMAIL PROTECTED]]
> >> > >> > Sent: Friday, December 13, 2002 6:43 AM
> >> > >> > To: CF-Talk
> >> > >> > Subject: Login/Password screen
> >> > >> >
> >> > >> >
> >> > >> > Hi,
> >> > >> >
> >> > >> > I know there are alot of custom tags out there that will do
> what
> >> > >> > I'm looking for but I want the best one. So this is why I'm
> >> > >> > asking all of you hoping you've had
> >> > >> > some experience with some of them. I'd like everything stored
> in
> >> > >> > a database. I know some don't do that. Bascially, once the
> user
> >> > >> > enters in their
> >> > >> > username/password they are redirected to a URL on the server
> >> > >> > based on the authentication.
> >> > >> >
> >> > >> > I have one called  but was wondering if there
> are
> >> > >> > any better ones?
> >> > >> >
> >> > >> > Thanks
> >> > >> >
> >> > >> >
> >> > >> > ---
> >> > >> > Colonel Nathan R. Jessop
> >> > >> > Commanding Officer
> >> > >> > Marine Ground Forces
> >> > >> > Guatanamo Bay, Cuba
> >> > >> > ---
> >> > >> >
> >> > >> >
> >> > >> >
> >> > >> >
> >> > >> >
> >> > >>
> >> >
> >> >
> >>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



oracle, blobs, and CFMX

2002-12-13 Thread Douglas.Knudsen
anyone test inserting a blob into an Oracle DB via CFMX?  Supposedly this works now 
but I'm getting an error message:

"[Oracle JDBC Driver] The hexadecimal string is invalid"

SQL is 
INSERT INTO foo
(ct, bob)
VALUES
( '55', )

where tmp is a Word doc grabbed via CFFILE.

Cheers!

--
Douglas Knudsen
Alltel Corporate
CIS Group
678-351-6063
"Spoon feeding in the long run teaches us nothing but the shape of the spoon." - E.M. 
Forster 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: DB Driver Inf / DB2 on AS/400 / Joe / PDF Ref Doc / etc etc

2002-12-13 Thread Damon Cooper
Hey Joehope you don't mind me CC'ing CF-Talk, so everyone can use this info if 
necessary...

First, there's a bug in JRun4 (and therefore CFMX Server) - #48118,  that can obscure 
the actual JDBC exception that you're encountering, giving the generic one below. So 
let's first see what the actual error is you're encountering

1) Shut down CFMX.
2) Grab this file:  ftp://ftp.allaire.com/outgoing/damonc/jrpatch.jar 
3) Move aside (and SAVE!) your existing {cf_root}/lib/jrpatch.jar (if you have one), 
and put this "jrpatch.jar" down as {cf_root}/lib/jrpatch.jar.
4) Start CFMX
5) Try to connect again and send the error you're getting

Next, I don't see any reference to "libraries" in the DataDirect documentation 
anywhere, so perhaps the concept is only relevant for the IBM drivers?  (BTW, can you 
get connected with those?)

The "Native" DB connections we have are essentially just direct convenience mappings 
for you...they're not treated "specially" in any way, except for setup, connection, 
and some easier-to-use panels for customers.

Connection pooling is achieved via our JDBCPool class.  The pooling behavior is 
defined by the DSN settings you've set up in the Admin...we'll create a new connection 
as necessary, and if you've not disallowed connection pooling, we'll re-use an 
existing connection if the connection info is the same, and there's one available in 
the pool.



-Original Message-
From: Joe Eugene [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 4:03 PM
To: Damon Cooper
Subject: RE: DB Driver Inf / DB2 on AS/400 / Joe / PDF Ref Doc / etc etc


Hi Damon..

Connection failed with this error
Connection verification failed for data source: SYSTEMB_DUDB
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to 
connect, please check your username, password, URL, and other connectivity info. The 
root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while 
attempting to connect, please check your username, password, URL, and other 
connectivity info.

Is there anyway to know whether it created the package? Libraries are data space 
objects in DB400.. This is what my native(JTOpen) connection string looks like.. 
jdbc:as400://200.0.0.0/DBDATA;libraries=JDB,JEB
JDB and JEB are libraries.

Does CFMX treat "Native" DB connection different from default.. DB connections? How is 
connection pooling achieved? One Connection, mutiple statemens?

Thanks
Joe



Re: Pass "null" to a Java object?

2002-12-13 Thread Massimo, Tiziana e Federica
> Again.. Listen to the question...
> Massimo's comment were to the effect...
> ">from CFML and I am forced to do everything with plain CFML."
>
> HE CANNOT WRITE JAVA OBJECTS BUT CAN USE THEM?

Yes, because I am on a server (shared hosting) where I can instantiate Java
objects using  but I can't use my own class files


> All he needs to do is modify that Java Class to handle "null" as strings
and
> convert them to Java null

I can't modify the Java Class, I have to use plain vanilla CFML and what the
JRE 1.3 can provide.
I am not using my own classes (am not allowed) and can't write a wrapper

Maybe I could figure out an alternative digging JRE 1.3's docs better, but I
guess the issue may arise in different scenarios

Massimo

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Server is hosed

2002-12-13 Thread Scott Brady
>The .cfm mapping that IIS uses to map calls to .cfm pages to the CF
>Runtime has probably been removed. On the problem site, if you click the
>Home Directory tab, and then click the Configuration button on that tab,
>you will see all the mappings associated w/ that particular site. If
>cfm is missing or isn't properly mapped, add/edit it so that it's
>mapped to your CF runtime (probably something like
>C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll).

Actually, I'm going back to CF5 (so my server matches the QA server for now . . . once 
the QA server FINALLY gets upgraded [as it was supposed to be weeks ago], then I'll 
re-install MX).

But, your instructions led me on the right path (well, actually, the only difference 
is the file to point to in the mapping).

Thanks very much!

Scott

Scott Brady
http://www.scottbrady.net/
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread Dave Watts
> One thing to check is whether CFSEARCH allows caching 
> (Studio doesn't think it does, which agrees with my 
> recollection). If your app is as amenable to caching 
> queries as www.SMARTERyellowPages.com is, then your 
> choice may be clear.

While you can't use CACHEDWITHIN or CACHEDAFTER attributes with CFSEARCH as
you can with CFQUERY, you can certainly cache a recordset from CFSEARCH by
storing it in a persistent variable.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Sessions Not working?

2002-12-13 Thread Costas Piliotis
Anybody?

-Original Message-
From: Costas Piliotis 
Sent: Friday, December 13, 2002 11:48 AM
To: CF-Talk
Subject: Sessions Not working?


I have a client that has set up a site, and they are having session issues.
 
When accessing a site using the IP Address, everything works fine.
 
When accessing the same site using a hostheader, coldFusion doesn't seem to
start a session.
 
I have checked to see if the cookie gets written at the start of the
session, and in fact it isn't being written with that host header.  Has
anyone seen this before, or am i just on glue?
 
 
 
Costas Piliotis
Guru
Voyus Canada Inc.
T: 604.630.5655 (direct line)
F: 604.320.6568
E-Mail:   [EMAIL PROTECTED]
 
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful. When addressed to our clients any
opinions or advice contained in this email are subject to the terms and
conditions expressed in the applicable Voyus Canada Inc. client engagement
contract
 
http://www.voyus.com/  

 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Pass "null" to a Java object?

2002-12-13 Thread Joe Eugene
Why cant you write a wrapper class to translate string "null" from CFMX to
Java(null). Your setter methods can handle this..

Joe

On Fri, 13 Dec 2002 15:48:53 -0500 Matt Liotta <[EMAIL PROTECTED]> wrote:

> I tried several different ways of pass a null
> to a Java object without
> success. One workaround is change the Java
> source code generated by CFMX
> and then recompile the CFM.
> 
> Matt Liotta
> President & CEO
> Montara Software, Inc.
> http://www.montarasoftware.com/
> 888-408-0900 x901
> 
> > -Original Message-
> > From: Massimo, Tiziana e Federica
> [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, December 13, 2002 2:36 PM
> > To: CF-Talk
> > Subject: Pass "null" to a Java object?
> > 
> > Is there a way to pass a "null" to the method
> of a Java object?
> > 
> > In order to test this I even tried creating a
> Java class that returns
> null
> > and use it... No joy :-(
> > 
> > I guess it's not possible, but I just wanted
> to try and ask
> > 
> > Thanks
> > 
> > Massimo
> > 
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread paul smith
I don't have comparisons using the same app.  For some apps I've used 
Verity, and I used SQL7 full text exclusively in www.SMARTERyellowpages.com

I have heard that Verity K2 search is very fast (and uses the same index as 
Verity vanilla search), but again, I have no comparable data.

One thing to check is whether CFSEARCH allows caching (Studio doesn't think 
it does, which agrees with my recollection).  If your app is as amenable to 
caching queries as www.SMARTERyellowPages.com is, then your choice may be 
clear.

For example, if you go to 
 and click on each of 
the 1 2 3 4 5 6 7 8 result pages, each page request after the first is from 
a query cached for 5 minutes.  Similarly for full text searches.

The only way to decide is to try it out on your app.  When I first 
developed SMARTERyellowpages.com, I stored all database data in Structures 
(in memory, and it took the app about 20 minutes to start up and load the 
structures).  When I compared with cached queries I found that, for my app, 
cached queries were faster.  But this was because my app did not take 
advantage of the unique capabilities of structures.  Other apps that can 
use structures well will be faster than cached queries.

best,  paul

At 02:49 PM 12/13/02 -0500, you wrote:
>Thanks Paul. What has your experience with query speed been between the 
>two? I've had a few people tell me that Verity might be a bit quicker.
>
>Thanks again.
>
>On 12/13/2002 1:21 PM, paul smith <[EMAIL PROTECTED]> wrote:
> >SQL7/2000 allows combination of full-text searches and standard SQL
> >in the
> >same query.
> >
> >With Verity I find I often need a query to find the list of IDs that
> >match
> >the search text, and then a second query to match the standard SQL
> >constraints.
> >
> >Not that important if your app is not heavily loaded.
> >
> >best,  paul
> >
> >At 12:02 PM 12/13/02 -0500, you wrote:
> >>Would love to hear people's feelings and relative advantages/disadvantages
> >
> >>of each.Need to make a decision and I'm vacilating between the two.
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: Pass "null" to a Java object?

2002-12-13 Thread Joe Eugene
> Been to cflib.org or read Forta's MX book?
> People are using Java
> objects in CF everywhere...

I have written some complex Java Objects and used them successfully.. passing
"nulls" and doing whatever Write some wrapper classes in your object to
translate "nulls"

Again.. Listen to the question...
Massimo's comment were to the effect...
">from CFML and I am forced to do everything with plain CFML."

HE CANNOT WRITE JAVA OBJECTS BUT CAN USE THEM?

All he needs to do is modify that Java Class to handle "null" as strings and
convert them to Java null

Joe



On Fri, 13 Dec 2002 15:59:41 -0500 jon hall <[EMAIL PROTECTED]> wrote:

> Friday, December 13, 2002, 3:46:18 PM, you
> wrote:
> JE> Didnt you say.. you were trying to pass
> "null" to a Java Object.. if you cant
> JE> run Java Class files.. How can you
> instantiate a Java Object?
> 
> >> from CFML and I am forced to do everything
> with
> >> plain CFML.
> 
> JE> You can only write Plan CF.. Now where does
> Java Objects even fit here?
> 
> JE> Joe
> 

> 
> -- 
>  jon
>  mailto:[EMAIL PROTECTED]
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Pass "null" to a Java object?

2002-12-13 Thread Massimo, Tiziana e Federica
> I tried several different ways of pass a null to a Java object without
> success. One workaround is change the Java source code generated by CFMX
> and then recompile the CFM.

Thanks for sharing, I guess it's time to submit a feature request :-)

Massimo

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Updater 2 woes

2002-12-13 Thread brook
I was logged in as the admin, and I also deleted all of the class files and 
restarted the server, the CF administrator still gives me an error in the 
application.cfm file as below. After rebooting the error did move from line 
1 to line 228.

Maybe I'll re-install the Updater or CFMX?

Brook

At 10:28 AM 12/13/2002 +0100, you wrote:
>[EMAIL PROTECTED] wrote:
>
> >I rebooted the server and tried again and got this error:
> >
> >The error occurred in
> >C:\Inetpub\wwwroot\CFIDE\administrator\Application.cfm: line 228
> >
> >
> >
>Make sure your permissions allow writing files to the CFIDE directory
>when installing the update. Sometimes it seems to just leave the
>original file if it can't overwrite the older ones. Then stop cfmx,
>clear the cfclasses directory, start cfmx and try again.
>
>Jesse
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Pass "null" to a Java object?

2002-12-13 Thread jon hall
Friday, December 13, 2002, 3:46:18 PM, you wrote:
JE> Didnt you say.. you were trying to pass "null" to a Java Object.. if you cant
JE> run Java Class files.. How can you instantiate a Java Object?

>> from CFML and I am forced to do everything with
>> plain CFML.

JE> You can only write Plan CF.. Now where does Java Objects even fit here?

JE> Joe

Been to cflib.org or read Forta's MX book? People are using Java
objects in CF everywhere...

-- 
 jon
 mailto:[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Pass "null" to a Java object?

2002-12-13 Thread Matt Liotta
I tried several different ways of pass a null to a Java object without
success. One workaround is change the Java source code generated by CFMX
and then recompile the CFM.

Matt Liotta
President & CEO
Montara Software, Inc.
http://www.montarasoftware.com/
888-408-0900 x901

> -Original Message-
> From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 13, 2002 2:36 PM
> To: CF-Talk
> Subject: Pass "null" to a Java object?
> 
> Is there a way to pass a "null" to the method of a Java object?
> 
> In order to test this I even tried creating a Java class that returns
null
> and use it... No joy :-(
> 
> I guess it's not possible, but I just wanted to try and ask
> 
> Thanks
> 
> Massimo
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Pass "null" to a Java object?

2002-12-13 Thread Joe Eugene
Didnt you say.. you were trying to pass "null" to a Java Object.. if you cant
run Java Class files.. How can you instantiate a Java Object?

> from CFML and I am forced to do everything with
> plain CFML.

You can only write Plan CF.. Now where does Java Objects even fit here?

Joe

On Fri, 13 Dec 2002 21:00:55 +0100 "Massimo, Tiziana e Federica"
<[EMAIL PROTECTED]> wrote:

> >
> http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=194
> > 49&forumid=4&refresh=0
> 
> Thanks for the pointer, unfortunately the
> current project is on a server
> that doesn't allow me add any class or jar
> file. That's actually while I am
> stumped, since I can't create a simple Java
> class to do the job and call it

> 
> Anyway, your suggestion looks interesting and I
> will definitely investigate
> it.
> 
> Thanks again
> 
> Massimo
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Server is hosed

2002-12-13 Thread James Alexander
The .cfm mapping that IIS uses to map calls to .cfm pages to the CF
Runtime has probably been removed. On the problem site, if you click the
Home Directory tab, and then click the Configuration button on that tab,
you will see all the mappings associated w/ that particular site. If
cfm is missing or isn't properly mapped, add/edit it so that it's
mapped to your CF runtime (probably something like
C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll).

You'll also want to make sure you add any other necessary mappings back
if they are missing such as .cfc,.cfml, and .jsp.

- James

-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 3:15 PM
To: CF-Talk

I made the apparently huge mistake of installing the CFMX Updater 2 this
morning.  Of course, our application then no longer worked on my
development machine, because we're using Oracle (there's apparently a
known issue involving Oracle 8 and refcursros in the Updater 2 that
didn't exist before [should a series of bug fixes really introduce new
bugs?]).

However, the instructions on removing an update are either incredibly
poorly written or don't work, because after following the instructions,
IIS no longer wanted to treat CFM pages correctly (It tries to download
the files.)

I thought if I uninstalled MX that might fix it. I even decided to go
back to CF5 (our QA servers were supposed to be put on MX weeks ago, but
they're still on 5) and I get the same problem.

Any ideas on fixing this?  Should I reinstall IIS?

Scott



Scott Brady
http://www.scottbrady.net/ 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



OT: Form validation & 508 compliancy

2002-12-13 Thread Carlisle, Eric
I realize that sometimes it's better to use client side validation on
forms... Sometimes server side... Sometimes both.

Are there any rules of thumb to using client side (JavaScript) validation on
508 compliant forms?

Thanks :-)

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: DB Driver Inf / DB2 on AS/400 / Joe / PDF Ref Doc / etc etc

2002-12-13 Thread Joe Eugene
Daemon,
Thanks for replying.

1. Are you saying to put this in the connection string for a DB2 UDB
connection? Give it the Data Library, Userid and password and it will work?

locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG;CreateDefaultPackage=TRUE;
locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG;

No it failed. 
First Pass Connection String?
Second Pass Connection String?
What do u mean, use the first connection string.. to create..then edit and
enter second connection string?

2. Can this be done simpler.. like where is the package for the DataDirect
Drivers for DB2
macromedia.jdbc.MacromediaDrivers? Can you configure an "Other" native
connection using the same DataDirect Drivers..? with url

jdbc:datadirect:db2://server1:5;DatabaseName=SAMPLE;CollectionId=DEFAULT;
PackageName=JDBCPKG

but i guess you are creating the package above.
How do u specify Libraries? Has anyone done any performance testing against
JTOpen/IBM AS400 Toolkit Drivers provided by IBM?

Thanks for following up on this again.

Joe


On Fri, 13 Dec 2002 14:50:45 -0500 Damon Cooper <[EMAIL PROTECTED]>
wrote:

> Hey guys...
> 
> Here's some info that may help 
> 
> 1) Connecting using CFMX DB2 drivers on AS/400,
> mainframes, etc, etc: give this sample a try:
> 
>   1) The connect string is required to connect.
> 
>   a) First pass connection string in CFAdmin
> dsn
>   
>  
>
locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG;CreateDefaultPackage=TRUE;
> 
>   b) Second pass connection string in CFAdmin
> dsn (sans createdefaultpackage):
>  
> 
>  
> locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG;
> 
> 2) The JDBC dirvers in CFMX Updater Release 2
> are based on the DataDirect Technologies
> 3.1.0007 driver set.  I don't believe this high
> patch level is yet publicly available from
> DataDirect.  We worked with them to ensure some
> patches we cared about that affected you got
> fixed before we were willing to include them in
> Updater 2. Updater 1 and previous shipped
> 3.0.0005 or thereabouts, plus a few extra
> patches from DataDirect.
> 
> 3) Most notable about this driver set are 
> 
>   a) The dozens of bug fixes
> 
>   b) Significant performance improvments in the
> driver suite (we found ~10% performance
> improvement in the SQL Server driver, ~20+%
> performance improvement in the Oracle driver,
> and we understand there are big gains for DB2
> customers as well), and 
> 
>   c) Solid STABILITY fixes (most notably,
> "THREAD WHACKER" timeout watcher threads were
> not being properly killed themselevs previously
> in some cases, which could very well account
> for some "thread runaway" conditions we'd heard
> about).
> 
> 3) Doc: the JDBC Reference for each DD driver
> we provide is here:  
> 
>   ftp://ftp.allaire.com/outgoing/damonc/jdbcref.zip
> 
> 4) The MySQL driver we ship was created by MM
> himself...you should be able use the latest
> MySQL JDBC driver via the "Other" option in the
> Admin, since it's essentially from the same
> guy.
> 
> Hope that helps (more than a kick in the head
> with a steel-toed boot, anyway)
> 
> Damon
> 
> 
> --
> Date: Fri, 13 Dec 2002 09:49:19 -0800
> From: "Joe Eugene"
> Subject: RE: Java in CF (CFMX) - MM Drivers
> Message-ID: 
> 
> MM-Product Team...
> When Vernon Viehe(MM Community manager)
> exited.. there were promises from MM..that MM
> would provide better support through other MM
> Folks... *Is this a JOKE?* Vernon did a
> much better job..than whoever is in that place
> now.
> 
> This Thread Question was directed to MM..since
> there is no DOCUMENTATION on details of drivers
> and such.. NEVER Got an Answer.!
> 
> CFMX Updater 2 Release Notes...
> DB2-Specific Issues
> An exception could be generated when connecting
> to DB2 AS/400 v4R5. 15002962(ID).
> 
> ***STILL DOING THE SAME THING with V4R5 and
> V5R1***
> 
> Is MM(Product-Team) going to provide the
> documentation details.. or do we have to wait
> another year.. for a reponse...?
> 
> BTW.. This Thread is dating back early last
> Month.
> 
> Joe
> 
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread Paul Hastings
> Thanks Paul. What has your experience with query speed been between the
two? I've had a few people tell me that Verity might be a bit quicker.

verity's response is flat flat flat. sql server's full text just gets
quicker (cached). sql server's full text annually wins academic/gov. awards
for text searching.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



Server is hosed

2002-12-13 Thread Scott Brady
I made the apparently huge mistake of installing the CFMX Updater 2 this morning.  Of 
course, our application then no longer worked on my development machine, because we're 
using Oracle (there's apparently a known issue involving Oracle 8 and refcursros in 
the Updater 2 that didn't exist before [should a series of bug fixes really introduce 
new bugs?]).

However, the instructions on removing an update are either incredibly poorly written 
or don't work, because after following the instructions, IIS no longer wanted to treat 
CFM pages correctly (It tries to download the files.)

I thought if I uninstalled MX that might fix it. I even decided to go back to CF5 (our 
QA servers were supposed to be put on MX weeks ago, but they're still on 5) and I get 
the same problem.

Any ideas on fixing this?  Should I reinstall IIS?

Scott



Scott Brady
http://www.scottbrady.net/ 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Pass "null" to a Java object?

2002-12-13 Thread Massimo, Tiziana e Federica
>
http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=194
> 49&forumid=4&refresh=0

Thanks for the pointer, unfortunately the current project is on a server
that doesn't allow me add any class or jar file. That's actually while I am
stumped, since I can't create a simple Java class to do the job and call it
from CFML and I am forced to do everything with plain CFML.

Anyway, your suggestion looks interesting and I will definitely investigate
it.

Thanks again

Massimo

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



CFFILE error:formfield File does not contain a file

2002-12-13 Thread Eric Creese
I took out most of the code on the action page to make sure it brought the file over, 
uploaded the file , and gave it a unique name. it did all the following for me.

Here is the code. I used your form page as well to pass the form items. Try this first 
to get it working then try adding your validation.

#form.rFile#





#ServerFile#
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Can't Reach the Updater 2

2002-12-13 Thread Smith, Matthew P -CONT(DYN)
Useless Digressions on Friday

; )

-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 12:56 PM
To: CF-Talk
Subject: RE: Can't Reach the Updater 2

Friday, hmmm?

Don't forget UDF = Universal Disk Format.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 13, 2002 1:23 PM
> To: CF-Talk
> Subject: Re: Can't Reach the Updater 2
>
>
> So let's see in CF there is:
>
> ColdFusion...often confused with Cold Fusion (the theoretical power souce)
> ColdFusion Components (CFC) and CFCs are Chlorafloracarbons (spl?)
> and now updater 2 AKA U2 the band
>
> It's Friday and that's my reason for this little observation ;-)
>
> and now back to your regulary scheduled CF-Talk
>
> 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: "Lincoln Milner" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, December 13, 2002 9:39 AM
> Subject: RE: Can't Reach the Updater 2
>
>
> > That's U2 (not the band, the CFMX file...)
> >
> > -Original Message-
> > From: Ryan Kime [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, December 13, 2002 11:51 AM
> > To: CF-Talk
> > Subject: RE: Can't Reach the Updater 2
> >
> >
> > OKgot sick of the cookie bull. Here's the address of the actual
> > download (I think)...can someone verify that this is the U2? Our http
> usage
> > is monitored here and I don't want to waste 17 MB of my quota
> if it's not
> > the right one. :P
> >
> >
> http://download.macromedia.com/pub/coldfusion/updater/cfmx_updater_win.exe
> > U1 or U2?
> >
> >
> > -Original Message-
> > From: Joe Eugene [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, December 13, 2002 10:17 AM
> > To: CF-Talk
> > Subject: Re: Can't Reach the Updater 2
> >
> >
> > Are u using Internet Explorer? if so.. go to tool/internet options.. and
> > find where your Temp internet files are stored... You can go to the
> diretory
> > and delete everything.. Doesnt do any harm. Then MM again.. we are all
> able
> > to get to the site fine!
> >
> > Joe
> >
> >
> > On Fri, 13 Dec 2002 10:54:56 -0500 Stacy Young
> <[EMAIL PROTECTED]>
> > wrote:
> >
> > > Ok I deleted any MM cookies I had and cleared
> > > cache and I still can't reach
> > > the Updater download. Brings me to a "notify
> > > me" page.
> > >
> > > -Stace
> > >
> > >
> > > AVIS IMPORTANT:
> > > ---
> > > Les informations contenues dans le present
> > > document et ses pieces jointes sont strictement
> > > confidentielles et reservees a l'usage de la
> > > (des) personne(s) a qui il est adresse. Si vous
> > > n'etes pas le destinataire, soyez avise que
> > > toute divulgation, distribution, copie, ou
> > > autre utilisation de ces informations est
> > > strictement prohibee.  Si vous avez recu ce
> > > document par erreur, veuillez s'il vous plait
> > > communiquer immediatement avec l'expediteur et
> > > detruire ce document sans en faire de copie
> > > sous quelque forme.
> > >
> > > WARNING:
> > > ---
> > > The information contained in this document and
> > > attachments is confidential and intended only
> > > for the person(s) named above.  If you are not
> > > the intended recipient you are hereby notified
> > > that any disclosure, copying, distribution, or
> > > any other use of the information is strictly
> > > prohibited.  If you have received this document
> > > by mistake, please notify the sender
> > > immediately and destroy this document and
> > > attachments without making any copy of any
> > > kind.
> > >
> > >
> > >
> >
> >
> >
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread Matt Kornguth
Thanks Paul. What has your experience with query speed been between the two? I've had 
a few people tell me that Verity might be a bit quicker.

Thanks again.

On 12/13/2002 1:21 PM, paul smith <[EMAIL PROTECTED]> wrote:
>SQL7/2000 allows combination of full-text searches and standard SQL 
>in the 
>same query.
>
>With Verity I find I often need a query to find the list of IDs that 
>match 
>the search text, and then a second query to match the standard SQL 
>constraints.
>
>Not that important if your app is not heavily loaded.
>
>best,  paul
>
>At 12:02 PM 12/13/02 -0500, you wrote:
>>Would love to hear people's feelings and relative advantages/disadvantages 
>
>>of each.Need to make a decision and I'm vacilating between the two.
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



DB Driver Inf / DB2 on AS/400 / Joe / PDF Ref Doc / etc etc

2002-12-13 Thread Damon Cooper
Hey guys...

Here's some info that may help 

1) Connecting using CFMX DB2 drivers on AS/400, mainframes, etc, etc: give this sample 
a try:

  1) The connect string is required to connect.

  a) First pass connection string in CFAdmin dsn
  
  
locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG;CreateDefaultPackage=TRUE;

  b) Second pass connection string in CFAdmin dsn (sans createdefaultpackage):
  
  locationName=IDPODB2WDDF;collectionID=default;packagename=JDBCPKG;

2) The JDBC dirvers in CFMX Updater Release 2 are based on the DataDirect Technologies 
3.1.0007 driver set.  I don't believe this high patch level is yet publicly available 
from DataDirect.  We worked with them to ensure some patches we cared about that 
affected you got fixed before we were willing to include them in Updater 2. Updater 1 
and previous shipped 3.0.0005 or thereabouts, plus a few extra patches from DataDirect.

3) Most notable about this driver set are 

a) The dozens of bug fixes

b) Significant performance improvments in the driver suite (we found ~10% 
performance improvement in the SQL Server driver, ~20+% performance improvement in the 
Oracle driver, and we understand there are big gains for DB2 customers as well), and 

c) Solid STABILITY fixes (most notably, "THREAD WHACKER" timeout watcher 
threads were not being properly killed themselevs previously in some cases, which 
could very well account for some "thread runaway" conditions we'd heard about).

3) Doc: the JDBC Reference for each DD driver we provide is here:  

ftp://ftp.allaire.com/outgoing/damonc/jdbcref.zip

4) The MySQL driver we ship was created by MM himself...you should be able use the 
latest MySQL JDBC driver via the "Other" option in the Admin, since it's essentially 
from the same guy.

Hope that helps (more than a kick in the head with a steel-toed boot, anyway)

Damon


--
Date: Fri, 13 Dec 2002 09:49:19 -0800
From: "Joe Eugene"<[EMAIL PROTECTED]>
Subject: RE: Java in CF (CFMX) - MM Drivers
Message-ID: <[EMAIL PROTECTED]>

MM-Product Team...
When Vernon Viehe(MM Community manager) exited.. there were promises from MM..that MM 
would provide better support through other MM Folks... *Is this a JOKE?* 
Vernon did a much better job..than whoever is in that place now.

This Thread Question was directed to MM..since there is no DOCUMENTATION on details of 
drivers and such.. NEVER Got an Answer.!

CFMX Updater 2 Release Notes...
DB2-Specific Issues
An exception could be generated when connecting to DB2 AS/400 v4R5. 15002962(ID).

***STILL DOING THE SAME THING with V4R5 and V5R1***

Is MM(Product-Team) going to provide the documentation details.. or do we have to wait 
another year.. for a reponse...?

BTW.. This Thread is dating back early last Month.

Joe




Sessions Not working?

2002-12-13 Thread Costas Piliotis
I have a client that has set up a site, and they are having session issues.
 
When accessing a site using the IP Address, everything works fine.
 
When accessing the same site using a hostheader, coldFusion doesn't seem to
start a session.
 
I have checked to see if the cookie gets written at the start of the
session, and in fact it isn't being written with that host header.  Has
anyone seen this before, or am i just on glue?
 
 
 
Costas Piliotis
Guru
Voyus Canada Inc.
T: 604.630.5655 (direct line)
F: 604.320.6568
E-Mail:   [EMAIL PROTECTED]
 
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful. When addressed to our clients any
opinions or advice contained in this email are subject to the terms and
conditions expressed in the applicable Voyus Canada Inc. client engagement
contract
 
http://www.voyus.com/  

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Pass "null" to a Java object?

2002-12-13 Thread Rob Rohan
http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=194
49&forumid=4&refresh=0

Rob

http://treebeard.sourceforge.net
http://ruinworld.sourceforge.net
Scientia Est Potentia

-Original Message-
From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 11:36 AM
To: CF-Talk
Subject: Pass "null" to a Java object?


Is there a way to pass a "null" to the method of a Java object?

In order to test this I even tried creating a Java class that returns null
and use it... No joy :-(

I guess it's not possible, but I just wanted to try and ask

Thanks

Massimo


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Pass "null" to a Java object?

2002-12-13 Thread Massimo, Tiziana e Federica
Is there a way to pass a "null" to the method of a Java object?

In order to test this I even tried creating a Java class that returns null
and use it... No joy :-(

I guess it's not possible, but I just wanted to try and ask

Thanks

Massimo

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Java in CF (CFMX) - MM Drivers

2002-12-13 Thread Mike Chambers
If you have a question that is directed directly to Macromedia then you
need to contact Macromedia directly. That means either contacting
support, or sending your question to me. At the least CC us on your
post. Otherwise, there is a chance we might not see your original
question, or a follow up.

We spend a lot of time helping people out on this list. Most of the
people from Macromedia who are on the list and help people out are not
here because they have to be, but because they love and are dedicated to
the product and community. However, again, if you need direct support
from Macromedia, then you need to contact us directly. We have processes
and channels setup to provide the type of 1 on 1 support /communication
that you appear to be looking for.

Again, please feel to email me directly with any questions that you have
that are addressed to the macromedia in general, or the CF Team in
particular.

btw, this should not be taken to mean that we will not continue to be
active on the list helping people out. It just means that with the high
volume of messages on the list, we miss questions / topics sometimes.

mike chambers

[EMAIL PROTECTED]


> -Original Message-
> From: Joe Eugene [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, December 13, 2002 12:49 PM
> To: CF-Talk
> Subject: RE: Java in CF (CFMX) - MM Drivers
> 
> 
> MM-Product Team...
> When Vernon Viehe(MM Community manager) exited.. there were 
> promises from
> MM..that MM would provide better support through other MM Folks...
> *Is this a JOKE?*
> Vernon did a much better job..than whoever is in that place now.
> 
> This Thread Question was directed to MM..since there is no 
> DOCUMENTATION on
> details of drivers and such.. NEVER Got an Answer.!
> 
> CFMX Updater 2 Release Notes...
> DB2-Specific Issues
> An exception could be generated when connecting to DB2 AS/400 v4R5.
> 15002962(ID).
> 
> ***STILL DOING THE SAME THING with V4R5 and V5R1***
> 
> Is MM(Product-Team) going to provide the documentation 
> details.. or do we have
> to wait another year.. for a reponse...?
> 
> BTW.. This Thread is dating back early last Month.
> 
> Joe
> 
> 
> On Mon, 09 Dec 2002 07:20:57 -0800 Joe Eugene 
> <[EMAIL PROTECTED]> wrote:
> 
> > Phil/MM Product Team
> > 
> > > All the drivers are from DataDirect/Merant
> > > except for the mySQL driver.
> > 
> > Are you sure about the above? What Java Type IV
> > driver is provided with CFMX
> > for DB2 UDB?
> > This?
> > 
> http://www.datadirect-technologies.com/products/jdbc/jdbcrelhi
> ghlights.asp
> > The above driver supports DB2 UDB for
> > AS400(iSeries) for V5R4 and V5R1 OS
> > Versions. I havent been able to configure this
> > connection with CFMX..(got a
> > Native JTOpen connection working) and i dont
> > think AS400 DB2 UDB is
> > supported
> > Can you give some documentation on exactly what
> > drivers CMFX
> > uses(Author/Versions)?
> > 
> > It would be very helpful to see some
> > documentation on implementation of
> > "CFQUERY" and how connection pooling works in
> > CFMX.
> > 
> > Thanks
> > Joe
> > 
> > 
> > 
> > On Mon, 9 Dec 2002 08:43:38 -0500  Phil Costa 
> > wrote:
> > 
> > > Better late than never ;-)
> > > 
> > > All the drivers are from DataDirect/Merant
> > > except for the mySQL driver.
> > > 
> > > I believe a third-party JDBC driver would be
> > > managed just like one of the drivers included
> > > with CFMX, but I have to verify that.
> > > 
> > > Phil
> > > 
> > > -Original Message-
> > > From: Joe Eugene
> > [mailto:[EMAIL PROTECTED]]
> > > 
> > > Sent: Saturday, December 07, 2002 11:01 PM
> > > To: CF-Talk
> > > Subject: RE: Java in CF (CFMX) - MM Drivers
> > > 
> > > 
> > > >Anybody from MM Product Team can explain
> > this?
> > > on November 24, 2002 
> > > >5:24 PM
> > > 
> > > Product Teams reply 2 weeks later on the
> > > Thread!. Talked to Sean and figured out this
> > > already. Anyways since you mentioned it, Are
> > > all CFMX Native Drivers "DataDirect"
> > > Drivers(Oracle,DB2 UDB). If you configure a
> > > Type IV Native Datasource in CMFX... Does
> > CFMX
> > > manage connection pooling? Single
> > Connection..
> > > Multiple Statements? How does this work?
> > > 
> > > Thanks
> > > Joe
> > > 
> > > 
> > > -Original Message-
> > > From: Phil Costa
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, December 06, 2002 4:49 PM
> > > To: CF-Talk
> > > Subject: RE: Java in CF (CFMX) - MM Drivers
> > > 
> > > 
> > > It's throwing that error because you're
> > trying
> > > to access the JDBC drivers in an unlicensed
> > > fashion. The DataDirect drivers are licensed
> > > for use with ColdFusion, which includes
> > support
> > > for JSP as well as CFML, not the scenario
> > > you're describing.
> > > 
> > > Phil Costa
> > > Sr. Product Manager, ColdFusion
> > > Macromedia
> > > 
> > > 
> > > 
> > > -Original Message-
> > > From: Joe Eugene
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Sunday, November 24, 2002 5:24 PM
> > > To: CF-Talk
> > 

Re: Problem with single quotes(CFMX)

2002-12-13 Thread Joe Eugene
Sean.. 
i noticed a problem with CFMX and single quotes in a query...Query failed to
execute... and the debug code showed something like 

select * from TableName where myField=apos;BMWapos;

it was replacing "'" with string "apos;" . I tried a few things(preserve,
build string.. and some others). None of them worked. I finally restarted the
CFMX service.. and the query started working again. Strange... Any idea.. how
this might happen?

Thanks
Joe



On Fri, 13 Dec 2002 10:40:11 -0800 Sean A Corfield <[EMAIL PROTECTED]> wrote:

> Use preserveSingleQuotes()
> 
> (I wonder how many identical answers we'll get
> for this frequently 
> asked chestnut? :)
> 
> On Friday, Dec 13, 2002, at 09:29 US/Pacific,
> Wurst, Keith D. wrote:
> 
> > Hi everyone. I'm having a problem with single
> quotes. I'm building the
> > "where" part of a sql statement dynamically.
> So, I have a variable 
> > called
> > where_query. When I display where_query on
> the page I see:
> >
> > where ( title like '%Cancer%') or
> (duration_start >= '1/13/2002') or
> > (amount_requested > 5000)
> >
> > But when I then put it into a sql statement
> it looks like this
> >
> > where ( title like ''%Cancer%'')  or
> (duration_start >= ''1/13/2002'') 
> > or
> > (amount_requested > 5000)
> >
> > Does anyone know where those extra single
> quotes came from? Anyone 
> > know how
> > I might be able to get rid of them? Thanks
> very much.
> > Keith
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Running CF as a specific user

2002-12-13 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote:
> 
> (R)read
> (C)hange
> (Write)
> E(X)ecute
> 
> What does Add translate to?

Write on directories and nothing on files. Dont forget to set the 
Creator/Owner to at least Change in that case.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: CFFILE error:formfield File does not contain a file

2002-12-13 Thread Jochem van Dieten
Angel Stewart wrote:
> 
> The processing Code:
> 
> 
> 
>
>   
>  destination="e:\webs\theenergyguide\resumes\" 
>   nameconflict="makeunique">

Change form.rfile to rfile?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



CFFILE upload bug??????

2002-12-13 Thread Eric Creese
FIGURED OUT THE PROBLEM. Apparently in ServerFileName parameter in MX is not working 
right at leat when I called it so I used ServerFIle and was able to complete my task. 
Not sure if this is a bug but may need to be reviewed by MM
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Session Variables (was Login/Password screen)

2002-12-13 Thread paul smith
???  How about using the URL to maintain state?
The big advantages of cookies is to simplify/eliminate subsequent logins / 
and simplify coding.
Forta's books have forever shown how to test to see if user allows cookies 
and if not pass state in URL.

best,  paul

At 09:20 AM 12/13/02 -0800, you wrote:
> > Not all Users allow cookies.
>If you turn of "session cookies".. you will be very limited to what you can do
>on the internet. You wont be able to use Session State Management.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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't Reach the Updater 2

2002-12-13 Thread Mosh Teitelbaum
Friday, hmmm?

Don't forget UDF = Universal Disk Format.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 13, 2002 1:23 PM
> To: CF-Talk
> Subject: Re: Can't Reach the Updater 2
>
>
> So let's see in CF there is:
>
> ColdFusion...often confused with Cold Fusion (the theoretical power souce)
> ColdFusion Components (CFC) and CFCs are Chlorafloracarbons (spl?)
> and now updater 2 AKA U2 the band
>
> It's Friday and that's my reason for this little observation ;-)
>
> and now back to your regulary scheduled CF-Talk
>
> 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: "Lincoln Milner" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, December 13, 2002 9:39 AM
> Subject: RE: Can't Reach the Updater 2
>
>
> > That's U2 (not the band, the CFMX file...)
> >
> > -Original Message-
> > From: Ryan Kime [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, December 13, 2002 11:51 AM
> > To: CF-Talk
> > Subject: RE: Can't Reach the Updater 2
> >
> >
> > OKgot sick of the cookie bull. Here's the address of the actual
> > download (I think)...can someone verify that this is the U2? Our http
> usage
> > is monitored here and I don't want to waste 17 MB of my quota
> if it's not
> > the right one. :P
> >
> >
> http://download.macromedia.com/pub/coldfusion/updater/cfmx_updater_win.exe
> > U1 or U2?
> >
> >
> > -Original Message-
> > From: Joe Eugene [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, December 13, 2002 10:17 AM
> > To: CF-Talk
> > Subject: Re: Can't Reach the Updater 2
> >
> >
> > Are u using Internet Explorer? if so.. go to tool/internet options.. and
> > find where your Temp internet files are stored... You can go to the
> diretory
> > and delete everything.. Doesnt do any harm. Then MM again.. we are all
> able
> > to get to the site fine!
> >
> > Joe
> >
> >
> > On Fri, 13 Dec 2002 10:54:56 -0500 Stacy Young
> <[EMAIL PROTECTED]>
> > wrote:
> >
> > > Ok I deleted any MM cookies I had and cleared
> > > cache and I still can't reach
> > > the Updater download. Brings me to a "notify
> > > me" page.
> > >
> > > -Stace
> > >
> > >
> > > AVIS IMPORTANT:
> > > ---
> > > Les informations contenues dans le present
> > > document et ses pieces jointes sont strictement
> > > confidentielles et reservees a l'usage de la
> > > (des) personne(s) a qui il est adresse. Si vous
> > > n'etes pas le destinataire, soyez avise que
> > > toute divulgation, distribution, copie, ou
> > > autre utilisation de ces informations est
> > > strictement prohibee.  Si vous avez recu ce
> > > document par erreur, veuillez s'il vous plait
> > > communiquer immediatement avec l'expediteur et
> > > detruire ce document sans en faire de copie
> > > sous quelque forme.
> > >
> > > WARNING:
> > > ---
> > > The information contained in this document and
> > > attachments is confidential and intended only
> > > for the person(s) named above.  If you are not
> > > the intended recipient you are hereby notified
> > > that any disclosure, copying, distribution, or
> > > any other use of the information is strictly
> > > prohibited.  If you have received this document
> > > by mistake, please notify the sender
> > > immediately and destroy this document and
> > > attachments without making any copy of any
> > > kind.
> > >
> > >
> > >
> >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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't Reach the Updater 2

2002-12-13 Thread Ryan Kime
>Are you by chance using ZoneLabs or some other firewall 
>program that blocks personal header information?

Yeah, I'm behind some big nasty redundant firewalls, but I've never seen any
place require personal header info for a download. Oh well, all good now. 

Thanks to those who checked the download for me!

-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 11:45 AM
To: CF-Talk
Subject: RE: Can't Reach the Updater 2


>Well, not exactly. I get to the download page that has all the flavors 
>available and I can download, from here I can download every version 
>EXCEPT the W2K version which is what I need. It just redirects me back 
>to the front page!

Are you by chance using ZoneLabs or some other firewall program that blocks 
personal header information? I was having the same problem, went to my 
ZoneLabs console, turned on the ability to send personal header info for the

Macromedia site, and was able to successfully download the updater.

My only question is why the personal header info is necessary to be able to 
download the file, but that's another topic!

Hope this helps solve your issues,
Dave.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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't Reach the Updater 2

2002-12-13 Thread Sean A Corfield
On Friday, Dec 13, 2002, at 09:45 US/Pacific, Dave Carabetta wrote:
> My only question is why the personal header info is necessary to be 
> able to
> download the file, but that's another topic!

The Updater is behind a 'membership wall' - we'd like to ensure folks 
are macromedia.com members when they download the Updater. It provides 
more meaningful download statistics for us and ultimately helps us 
shape the website - and in particular, member-only sections - to better 
serve the our user community.

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/

Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Problem with single quotes

2002-12-13 Thread Sean A Corfield
Use preserveSingleQuotes()

(I wonder how many identical answers we'll get for this frequently 
asked chestnut? :)

On Friday, Dec 13, 2002, at 09:29 US/Pacific, Wurst, Keith D. wrote:

> Hi everyone. I'm having a problem with single quotes. I'm building the
> "where" part of a sql statement dynamically. So, I have a variable 
> called
> where_query. When I display where_query on the page I see:
>
> where ( title like '%Cancer%') or (duration_start >= '1/13/2002') or
> (amount_requested > 5000)
>
> But when I then put it into a sql statement it looks like this
>
> where ( title like ''%Cancer%'')  or (duration_start >= ''1/13/2002'') 
> or
> (amount_requested > 5000)
>
> Does anyone know where those extra single quotes came from? Anyone 
> know how
> I might be able to get rid of them? Thanks very much.
> Keith

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: updater2 99% cpu

2002-12-13 Thread Simon Stanlake
it was hanging on CFQUERY's that were doing inserts.  (to oracle 8.1.7)

uninstalled it for now.

-Original Message-
From: Simon Stanlake [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 8:56 AM
To: CF-Talk
Subject: updater2 99% cpu


when I install the updater2 I get a 99% cpu and server hangs on some pages.
other pages work.  I'm gonna do more testing but was wondering if anyone had
similar experience.  gonna try reinstalling the connector.

apache 1.3.27, rh 7.3, ibm jre 1.3.1

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: IIS on WinXP Pro

2002-12-13 Thread Dave Watts
> OpenSSH Server now works under Windows? I knew they 
> were working on it, but last time I checked only the 
> client worked under Windows.

I think you can run sshd under Windows, and have been able to for some time.
I think this is described in detail in the O'Reilly book "Securing Windows
NT/2000 Servers for the Internet", which has been out for about two years.
However, last time I checked, you couldn't run it as a service without using
a service wrapper.

Note that I haven't actually done this myself, though, since I'm happy with
other alternatives.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: What does U2 actually update?

2002-12-13 Thread Stacy Young
Joch you've told me to RTFM a couple times. LOL ( j/k )

Chill all...it's almost x-mas...

-Stace

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 11:57 AM
To: CF-Talk
Subject: Re: What does U2 actually update?

Matthew Small wrote:
> If you don't want to answer a question - then don't.  No reason to be a
> jerk about it. 

RTFM, RTFRN, STFW and STFA is being a jerk. Copy-pasting the entire list 
of fixes so the archives get screwed up is being a jerk. Pointing you to 
the release notes is not.

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Problem with single quotes

2002-12-13 Thread Scott Brady
Two options I can think of:

1) PreserveSingleQuotes() function
2) CFQUERYPARAM

I highly recommend option #2.

where 
( title like ) 
or (duration_start >= ) 
or (amount_requested > ) 

Of course, this depends on the database you're using, because some of them don't 
support parameters.

Scott Brady
http://www.scottbrady.net/

 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: Problem with single quotes

2002-12-13 Thread Jerry Johnson
wrap the variable in PreserveSingleQuotes(string)

This will prevent it from "escaping" the quotes (by adding another ' next to each 
existing ')

Jerry Johnson

>>> [EMAIL PROTECTED] 12/13/02 12:29PM >>>
Hi everyone. I'm having a problem with single quotes. I'm building the
"where" part of a sql statement dynamically. So, I have a variable called
where_query. When I display where_query on the page I see:

where ( title like '%Cancer%') or (duration_start >= '1/13/2002') or
(amount_requested > 5000) 

But when I then put it into a sql statement it looks like this

where ( title like ''%Cancer%'')  or (duration_start >= ''1/13/2002'') or
(amount_requested > 5000)

Does anyone know where those extra single quotes came from? Anyone know how
I might be able to get rid of them? Thanks very much.
Keith

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: CFFILE error:formfield File does not contain a file

2002-12-13 Thread Angel Stewart
Hey :)

Yup...thought that was it at first, but I set that and it still gives
the same error. It's very weird.

Here is all the code:


The Form:

 

   
First
Name

  
   
Last
Name

  
   
Email
Contact

  
   
Resume File(Word
doc)

  
   
 
 
  
  




The processing Code:



 

 






INSERT INTO
tblResume(fname,lname,email,rfile)
VALUES
('#form.fname#','#form.lname#','#form.email#',#cffile.serverfile#)





An error occurred while saving your
resume. Please try again









And the error again:

 And this is the error I get:
 

 The form field "FILE" did not contain a file.


 The Error Occurred in E:\webs\theenergyguide\postresume.cfm: line 9

 7 : 
 8 :
 9 :
 ---

Any other ideas? :-\

-Gel


-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 1:05 PM
To: CF-Talk
Subject: RE: CFFILE error:formfield File does not contain a file


Did you remember to set your form to multipart?  I always forget that
bit



  --Ben Doom
Programmer & General Lackey
Moonbow Software

: -Original Message-
: From: Angel Stewart [mailto:[EMAIL PROTECTED]]
: Sent: Friday, December 13, 2002 11:31 AM
: To: CF-Talk
: Subject: CFFILE error:formfield File does not contain a file
:
:
: Hey all,
:
: Here's my code
:
:
:   
:   
:
:   
:
:   
: And this is the error I get:
: 
:
: The form field "FILE" did not contain a file.
:
:
: The Error Occurred in E:\webs\theenergyguide\postresume.cfm: line 9
:
: 7 :
: 8 :   
: 9 :   
: ---
: I select a valid file in the form. The fieldnames are all correct.
: I click submit...and the CFFILE always fails with that cryptic error
: message.
:
: Anyone seen this before? What am I doing wrong?
:
: -Gel
:
:
:
: 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Happy story with updater2?

2002-12-13 Thread Sean A Corfield
On Friday, Dec 13, 2002, at 08:50 US/Pacific, Dick Applebaum wrote:
> Why would you need to remove the class files -- they shouldn't be
> affected by changes to CFMX?

Because the compiled files include calls into the CF libraries and if 
they change, the compiled code may no longer be valid. It's just safer 
to delete the .class files.

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/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: [verity] How do I exclude certain directories from my index?

2002-12-13 Thread Sean McCarthy
You have a couple of options.  

If you use the vspider to spider the site then you can use:
-indexclude /someIP/someFolder/*

If you use the standard cfindex tag then its going to be more of a
challenge.  Out of the box from what I have found outside of removing the
directory from what you are going to index or naming all of the files you
dont want indexed with .cfml then only index the .cfm's.  Neither of these
are really optimal solutions.  There is a app on cfhub, I think, that will
allow you to do this, with cfindex, I have not messed with it. 

If you are creating a web search of a varitey of doc types.  I really
recommend using the spider. The cfindex of a directory still ends up with
alot of junk in the results.  My .02

sean  



-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 11:57 AM
To: CF-Talk
Subject: [verity] How do I exclude certain directories from my index?


Let's say for example I've got directory "foo".

Inside "foo" I have "directory1", "directory2", ... "directory24"...

I want to index the cfm files in "foo", but I want to exclude "directory12"
and "directory17"
and "directory19"...

How would I go about doing that?


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



Re: Verity vs. SQL Server 2000 Full-Text

2002-12-13 Thread paul smith
SQL7/2000 allows combination of full-text searches and standard SQL in the 
same query.

With Verity I find I often need a query to find the list of IDs that match 
the search text, and then a second query to match the standard SQL constraints.

Not that important if your app is not heavily loaded.

best,  paul

At 12:02 PM 12/13/02 -0500, you wrote:
>Would love to hear people's feelings and relative advantages/disadvantages 
>of each.Need to make a decision and I'm vacilating between the two.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: Can't Reach the Updater 2

2002-12-13 Thread Bryan Stevenson
So let's see in CF there is:

ColdFusion...often confused with Cold Fusion (the theoretical power souce)
ColdFusion Components (CFC) and CFCs are Chlorafloracarbons (spl?)
and now updater 2 AKA U2 the band

It's Friday and that's my reason for this little observation ;-)

and now back to your regulary scheduled CF-Talk

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: "Lincoln Milner" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 13, 2002 9:39 AM
Subject: RE: Can't Reach the Updater 2


> That's U2 (not the band, the CFMX file...)
>
> -Original Message-
> From: Ryan Kime [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 13, 2002 11:51 AM
> To: CF-Talk
> Subject: RE: Can't Reach the Updater 2
>
>
> OKgot sick of the cookie bull. Here's the address of the actual
> download (I think)...can someone verify that this is the U2? Our http
usage
> is monitored here and I don't want to waste 17 MB of my quota if it's not
> the right one. :P
>
> http://download.macromedia.com/pub/coldfusion/updater/cfmx_updater_win.exe
> U1 or U2?
>
>
> -Original Message-
> From: Joe Eugene [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 13, 2002 10:17 AM
> To: CF-Talk
> Subject: Re: Can't Reach the Updater 2
>
>
> Are u using Internet Explorer? if so.. go to tool/internet options.. and
> find where your Temp internet files are stored... You can go to the
diretory
> and delete everything.. Doesnt do any harm. Then MM again.. we are all
able
> to get to the site fine!
>
> Joe
>
>
> On Fri, 13 Dec 2002 10:54:56 -0500 Stacy Young
<[EMAIL PROTECTED]>
> wrote:
>
> > Ok I deleted any MM cookies I had and cleared
> > cache and I still can't reach
> > the Updater download. Brings me to a "notify
> > me" page.
> >
> > -Stace
> >
> >
> > AVIS IMPORTANT:
> > ---
> > Les informations contenues dans le present
> > document et ses pieces jointes sont strictement
> > confidentielles et reservees a l'usage de la
> > (des) personne(s) a qui il est adresse. Si vous
> > n'etes pas le destinataire, soyez avise que
> > toute divulgation, distribution, copie, ou
> > autre utilisation de ces informations est
> > strictement prohibee.  Si vous avez recu ce
> > document par erreur, veuillez s'il vous plait
> > communiquer immediatement avec l'expediteur et
> > detruire ce document sans en faire de copie
> > sous quelque forme.
> >
> > WARNING:
> > ---
> > The information contained in this document and
> > attachments is confidential and intended only
> > for the person(s) named above.  If you are not
> > the intended recipient you are hereby notified
> > that any disclosure, copying, distribution, or
> > any other use of the information is strictly
> > prohibited.  If you have received this document
> > by mistake, please notify the sender
> > immediately and destroy this document and
> > attachments without making any copy of any
> > kind.
> >
> >
> >
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Running CF as a specific user

2002-12-13 Thread stas
Dave,

Going through the article to which you posted a link to I was confused for
the naming convention the original author was using for kinds of rights. Am
I correct in interpreting these as:

(R)read
(C)hange
(Write)
E(X)ecute

What does Add translate to?

Thank you

- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 13, 2002 11:57 AM
Subject: RE: Running CF as a specific user


> > Does your cf user have admin rights?
>
> The user account used by CF doesn't need administrative rights, and
> shouldn't have them if at all possible. One of the primary objectives of
> using a specific user account for CF is to deny it those administrative
> rights.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: Problem with single quotes

2002-12-13 Thread Bruce Sorge
Try using the PreserveSingleQuotes function.
- Original Message -
From: "Wurst, Keith D." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 13, 2002 11:29 AM
Subject: Problem with single quotes


> Hi everyone. I'm having a problem with single quotes. I'm building the
> "where" part of a sql statement dynamically. So, I have a variable called
> where_query. When I display where_query on the page I see:
>
> where ( title like '%Cancer%') or (duration_start >= '1/13/2002') or
> (amount_requested > 5000)
>
> But when I then put it into a sql statement it looks like this
>
> where ( title like ''%Cancer%'')  or (duration_start >= ''1/13/2002'') or
> (amount_requested > 5000)
>
> Does anyone know where those extra single quotes came from? Anyone know
how
> I might be able to get rid of them? Thanks very much.
> Keith
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



SOT: MySQL 3.23.54 has been released

2002-12-13 Thread jcc
It should be noted that this new version is in relation to a number of
seemingly major security vulnerabilities recently announced for mySQL. 
You really should upgrade.  edited security advisory follows, swee link
for full advisory, or email me (don't want to flood list):

-Jeff

>
>   -= Security  Advisory =-
>
>  Advisory: Multiple MySQL vulnerabilities
>  Release Date: 2002/12/12
> Last Modified: 2002/12/12
>Author: Stefan Esser [[EMAIL PROTECTED]]
>
>   Application: MySQL <= 3.23.53a, <= 4.0.5a
>  Severity: Several vulnerabilities within (lib)MySQL could
>allow (remote) compromise of client and/or server.
>  Risk: Medium to critical
> Vendor Status: Vendor released MySQL 3.23.54
> Reference: http://security.e-matters.de/advisories/042002.html
>
> Overview:
>
>We have discovered two flaws within the MySQL server that can be used
>by any MySQL user to crash the server. Furthermore one of the flaws can
>be used to bypass the MySQL password check or to execute arbitrary code
>with the privileges of the user running mysqld.
>
>We have also discovered an arbitrary size heap overflow within the mysql
>client library and another vulnerability that allows to write '\0' to
any
>memory address. Both flaws could allow DOS attacks against or arbitrary
>code execution within anything linked against libmysqlclient.
>
>
> Details:

*snip*


original message

> MySQL 3.23.54, a new version of the world's most popular Open Source
> Database, has been released. It is now available in source and binary
> form for a number of platforms from our download pages at
> http://www.mysql.com/downloads/ and mirror sites.






RE: Problem with single quotes

2002-12-13 Thread Everett, Al
> Does anyone know where those extra single quotes came from? 

ColdFusion escapes single quotes within CFQUERY.

> Anyone know how I might be able to get rid of them?

PreserveSingleQuotes()

> Thanks very much.

You're welcome

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Can't Reach the Updater 2

2002-12-13 Thread Dave Carabetta
>Well, not exactly. I get to the download page that has all the flavors
>available and I can download, from here I can download every version EXCEPT
>the W2K version which is what I need. It just redirects me back to the 
>front
>page!

Are you by chance using ZoneLabs or some other firewall program that blocks 
personal header information? I was having the same problem, went to my 
ZoneLabs console, turned on the ability to send personal header info for the 
Macromedia site, and was able to successfully download the updater.

My only question is why the personal header info is necessary to be able to 
download the file, but that's another topic!

Hope this helps solve your issues,
Dave.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Java in CF (CFMX) - MM Drivers

2002-12-13 Thread Joe Eugene
MM-Product Team...
When Vernon Viehe(MM Community manager) exited.. there were promises from
MM..that MM would provide better support through other MM Folks...
*Is this a JOKE?*
Vernon did a much better job..than whoever is in that place now.

This Thread Question was directed to MM..since there is no DOCUMENTATION on
details of drivers and such.. NEVER Got an Answer.!

CFMX Updater 2 Release Notes...
DB2-Specific Issues
An exception could be generated when connecting to DB2 AS/400 v4R5.
15002962(ID).

***STILL DOING THE SAME THING with V4R5 and V5R1***

Is MM(Product-Team) going to provide the documentation details.. or do we have
to wait another year.. for a reponse...?

BTW.. This Thread is dating back early last Month.

Joe


On Mon, 09 Dec 2002 07:20:57 -0800 Joe Eugene <[EMAIL PROTECTED]> wrote:

> Phil/MM Product Team
> 
> > All the drivers are from DataDirect/Merant
> > except for the mySQL driver.
> 
> Are you sure about the above? What Java Type IV
> driver is provided with CFMX
> for DB2 UDB?
> This?
> http://www.datadirect-technologies.com/products/jdbc/jdbcrelhighlights.asp
> The above driver supports DB2 UDB for
> AS400(iSeries) for V5R4 and V5R1 OS
> Versions. I havent been able to configure this
> connection with CFMX..(got a
> Native JTOpen connection working) and i dont
> think AS400 DB2 UDB is
> supported
> Can you give some documentation on exactly what
> drivers CMFX
> uses(Author/Versions)?
> 
> It would be very helpful to see some
> documentation on implementation of
> "CFQUERY" and how connection pooling works in
> CFMX.
> 
> Thanks
> Joe
> 
> 
> 
> On Mon, 9 Dec 2002 08:43:38 -0500  Phil Costa 
> wrote:
> 
> > Better late than never ;-)
> > 
> > All the drivers are from DataDirect/Merant
> > except for the mySQL driver.
> > 
> > I believe a third-party JDBC driver would be
> > managed just like one of the drivers included
> > with CFMX, but I have to verify that.
> > 
> > Phil
> > 
> > -Original Message-
> > From: Joe Eugene
> [mailto:[EMAIL PROTECTED]]
> > 
> > Sent: Saturday, December 07, 2002 11:01 PM
> > To: CF-Talk
> > Subject: RE: Java in CF (CFMX) - MM Drivers
> > 
> > 
> > >Anybody from MM Product Team can explain
> this?
> > on November 24, 2002 
> > >5:24 PM
> > 
> > Product Teams reply 2 weeks later on the
> > Thread!. Talked to Sean and figured out this
> > already. Anyways since you mentioned it, Are
> > all CFMX Native Drivers "DataDirect"
> > Drivers(Oracle,DB2 UDB). If you configure a
> > Type IV Native Datasource in CMFX... Does
> CFMX
> > manage connection pooling? Single
> Connection..
> > Multiple Statements? How does this work?
> > 
> > Thanks
> > Joe
> > 
> > 
> > -Original Message-
> > From: Phil Costa
> [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, December 06, 2002 4:49 PM
> > To: CF-Talk
> > Subject: RE: Java in CF (CFMX) - MM Drivers
> > 
> > 
> > It's throwing that error because you're
> trying
> > to access the JDBC drivers in an unlicensed
> > fashion. The DataDirect drivers are licensed
> > for use with ColdFusion, which includes
> support
> > for JSP as well as CFML, not the scenario
> > you're describing.
> > 
> > Phil Costa
> > Sr. Product Manager, ColdFusion
> > Macromedia
> > 
> > 
> > 
> > -Original Message-
> > From: Joe Eugene
> [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, November 24, 2002 5:24 PM
> > To: CF-Talk
> > Subject: RE: Java in CF (CFMX) - MM Drivers
> > 
> > 
> > I got this partially resolved... Sean helped
> > out.. Thanks Sean. It was a classpath
> problem.
> > However after i load the
> > drivers(macromedia.jdbc.MacromediaDriver)
> which
> > is in the "lib" directory of your
> > installation(eg.
> > "G:\CFusionMX\lib\macromedia_drivers.jar")
> and
> > give it the connection url.. Connection con =
> >
> DriverManager.getConnection("jdbc:macromedia:sqlserver://SqlServerName:1433"
> > ,"userid","Pwd");
> > 
> > I get an Exception..
> >
> "macromedia.jdbc.MacromediaDriver$InvalidLicenseException:
> > An Enterprise license is needed to use the
> > Macromedia JDBC Drivers on the DB2, Oracle,
> > Sybase and Info rmix servers."
> > 
> > I am running CFMX Enterprise
> > version(6,0,0,48097).  I have the same
> > connection working fine in JSP Pages under
> > CFMX. Are CFMX Enterprise drivers protected
> > from usage in Java
> Applications(Console/Swing)?
> > Anybody from MM Product Team can explain
> this?
> > 
> > Joe
> > 
> > 
> > > -Original Message-
> > > From: Joe Eugene
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, November 22, 2002 4:11 PM
> > > To: CF-Talk
> > > Subject: RE: Java in CF (CFMX) - MM Drivers
> > >
> > >
> > > I can use the CFMX MM DB drivers in a JSP
> > page..No problem. however.. 
> > > i need to use it in a Java
> Application..tried
> > to load the Driver..
> > >
> >
> Class.forName("macromedia.jdbc.MacromediaDriver")
> > > Keep getting ClassNotFound Error..
> > > I put the macromedia_driver.jar in the
> class
> > path.. still not 
> > > loading.. Do i need to impor

RE: Can't Reach the Updater 2

2002-12-13 Thread Lincoln Milner
That's U2 (not the band, the CFMX file...)

-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 11:51 AM
To: CF-Talk
Subject: RE: Can't Reach the Updater 2


OKgot sick of the cookie bull. Here's the address of the actual
download (I think)...can someone verify that this is the U2? Our http usage
is monitored here and I don't want to waste 17 MB of my quota if it's not
the right one. :P

http://download.macromedia.com/pub/coldfusion/updater/cfmx_updater_win.exe
U1 or U2?


-Original Message-
From: Joe Eugene [mailto:[EMAIL PROTECTED]] 
Sent: Friday, December 13, 2002 10:17 AM
To: CF-Talk
Subject: Re: Can't Reach the Updater 2


Are u using Internet Explorer? if so.. go to tool/internet options.. and
find where your Temp internet files are stored... You can go to the diretory
and delete everything.. Doesnt do any harm. Then MM again.. we are all able
to get to the site fine!

Joe


On Fri, 13 Dec 2002 10:54:56 -0500 Stacy Young <[EMAIL PROTECTED]>
wrote:

> Ok I deleted any MM cookies I had and cleared
> cache and I still can't reach
> the Updater download. Brings me to a "notify
> me" page.
> 
> -Stace
> 
> 
> AVIS IMPORTANT:
> ---
> Les informations contenues dans le present
> document et ses pieces jointes sont strictement
> confidentielles et reservees a l'usage de la
> (des) personne(s) a qui il est adresse. Si vous
> n'etes pas le destinataire, soyez avise que
> toute divulgation, distribution, copie, ou
> autre utilisation de ces informations est
> strictement prohibee.  Si vous avez recu ce
> document par erreur, veuillez s'il vous plait
> communiquer immediatement avec l'expediteur et
> detruire ce document sans en faire de copie
> sous quelque forme.
> 
> WARNING:
> ---
> The information contained in this document and
> attachments is confidential and intended only
> for the person(s) named above.  If you are not
> the intended recipient you are hereby notified
> that any disclosure, copying, distribution, or
> any other use of the information is strictly
> prohibited.  If you have received this document
> by mistake, please notify the sender
> immediately and destroy this document and
> attachments without making any copy of any
> kind.
> 
> 
> 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: What does U2 actually update?

2002-12-13 Thread Dina Hess
I couldn't agree more.

~Dina
  - Original Message - 
  From: Joshua Miller 
  To: CF-Talk 
  Sent: Friday, December 13, 2002 10:55 AM
  Subject: RE: What does U2 actually update?


  Ok, ok, ok, voice of reason here ...

  Jochem is typically a fabulous resource for information on this list -
  he's helped many of us out several times. 

  Let him have a bad day if he wants, I can certainly understand being
  frustrated ... Just drop it.

  Joshua Miller
  Head Programmer / IT Manager
  Garrison Enterprises Inc.
  www.garrisonenterprises.net
  [EMAIL PROTECTED]
  (704) 569-9044 ext. 254
   
  
  *
  Any views expressed in this message are those of the individual sender,
  except where the sender states them to be the views of 
  Garrison Enterprises Inc.
   
  This e-mail is intended only for the individual or entity to which it is
  addressed and contains information that is private and confidential. If
  you are not the intended recipient you are hereby notified that any
  dissemination, distribution or copying is strictly prohibited. If you 
  have received this e-mail in error please delete it immediately and
  advise us by return e-mail to [EMAIL PROTECTED]
  
  *


  -Original Message-
  From: Matthew Small [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, December 13, 2002 11:29 AM
  To: CF-Talk
  Subject: RE: What does U2 actually update?


  Well, I don't read every mail on this thing, it's impossible to do
  especially given the amount of mail that this list generates.

  If you don't want to answer a question - then don't.  No reason to be a
  jerk about it. 

  Matthew Small
  IT Supervisor
  Showstopper National Dance Competitions
  3660 Old Kings Hwy 
  Murrells Inlet, SC 29576
  843-357-1847
  http://www.showstopperonline.com

  -Original Message-
  From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
  Sent: Friday, December 13, 2002 11:14 AM
  To: CF-Talk
  Subject: RE: What does U2 actually update?

  Quoting "Robertson-Ravo, Neil (RX)" :

  > someones in a grumpy mood :-)

  Apart from the obviousness, the answer had been sent less than an hour
  before:

  - Original message -
  Date: Fri, 13 Dec 2002 14:36:07 +0100
  Subject: Re: Happy story with updater2?
  
  For me, it does what the release notes say it will do.

  - Original message -
  Date: Fri, 13 Dec 2002 09:27:19 -0500
  Subject: What does U2 actually update?
  
  So what problems is U2 reported to fix?


  And yes, that does make somebody feel unappreciated. Combine that with
  being less than happy about the issues fixed in U2, the non-issues fixed
  in U2 and the issues not fixed in U2, add in a little disappointment
  about the release date and if it weren't Friday I would indeed be grumpy
  :-)

  Jochem



  
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



Re: Happy story with updater2?

2002-12-13 Thread Samuel R. Neff
At 08:50 AM 12/13/2002, you wrote:
>(snip)
>Why would you need to remove the class files -- they shouldn't be
>affected by changes to CFMX?
>
>TIA
>
>Dick
(snip)

It's certainly possible that something in the updater can change how CFMX 
translates CFML to Java which would require recreating the class files.  I 
don't know if it's the case, and if it was I would think the updater would 
remove the class files itself, but I'm just saying it's a possibility.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



  1   2   3   >