date:20040202

On Saturday 31 Jan 2004 15:18 pm, Ubqtous wrote:
 .notes-box {background-color : White; overflow : auto; height: 200px;
 border : 1px solid Silver;}

Is there a live example of that working anywhere ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

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

RE: from 4.5.1 to MX

2004-02-02 Thread Darren Daniel

Try http://www.macromedia.com/devnet/mx/coldfusion/migrating.html

-Original Message-
From: Steff [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2004 10:03
To: CF-Talk
Subject: from 4.5.1 to MX

Hello

 I wan't to know what I should think to avoid problems when I will
migrate my coldfusion applications from ColdFusion Server 4.5.1 to
ColdFusion Server MX.

Can you tell me more or give me urls?

Thanks
Cordially
Steff

Stphane Vauclaire
c.com production
+352 48 30 15 21 02

[EMAIL PROTECTED]
http://www.c-comnet.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: cftransaction HELP Please...

2004-02-02 Thread Pascal Peters

It is possible, but I do not recommend. 

 -Original Message-
 From: Spectrum Web [mailto:[EMAIL PROTECTED] 
 Sent: maandag 2 februari 2004 10:19
 To: CF-Talk
 Subject: Re:cftransaction HELP Please...
 
 Right?? It's possible to insert another CF scripts inside 
 cftransaction tags? Do you recommend?
 
 Thanks once again
 
 
 This is possible. However, you have an error with your 
 cftransaction 
 tags. They ALWAYS require an end tag.
 
 cfif IsOK 
  cftransaction action="">
 cfelse 
  cftransaction action = "">
 
  -Original Message-
  From: Spectrum Web [mailto:[EMAIL PROTECTED]
  Sent: zondag 1 februari 2004 11:06
  To: CF-Talk
  Subject: Re:cftransaction HELP Please...
  
  Thanks James
  
  it's possible to insert pieces of scripts inside 
 cftransaction blocks?
  
  Like this:
  
  
  cfset IsOK = True
  cftransaction action="">
 cftry 
 cfquery to read from A 
 cfcatch 
  cfset IsOK = False 
 /cfcatch
 /cftry
  
  CFMAIL ...
  
 cfif IsOK 
 cftry 
  cfquery to save in B 
  cfcatch 
 cfset IsOK = False 
  /cfcatch 
 /cftry
  
  
  CFMAIL 
  
 cfif IsOK 
  cftry 
 cfquery to delete from A 
 cfcatch 
 cfset IsOK = False 
 /cfcatch 
  /cftry 
 /cfif
 /cfif
  
  
  CFMAIL...
  
 cfif IsOK 
 cftransaction action="" 
 cfelse 
 cftransaction action = "" 
 /cfif
  /cftransaction
  

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: OT: Making Combo Box from select

2004-02-02 Thread David Fafard

maybe

http://www.mattkruse.com/_javascript_/autocomplete/

dave
- Original Message - 
From: Andy Ousterhout 
To: CF-Talk 
Sent: Sunday, February 01, 2004 7:36 PM
Subject: RE: OT: Making Combo Box from select

Thanks.I've already incorporated what you sent into my code.
 -Original Message-
 From: Alan Rafael Bleiweiss [mailto:[EMAIL PROTECTED]
 Sent: Sunday, February 01, 2004 7:30 PM
 To: CF-Talk
 Subject: RE: OT: Making Combo Box from select

 Not sure what's required.I'll keep my eyes out though cause I'd like to
see
 the full capability.

 At 05:51 PM 2/1/04, you wrote:
 Thanks, that works great.Any way to have all of the typing in the select
 box?

 Andy
 -Original Message-
 From: Alan Rafael Bleiweiss [mailto:[EMAIL PROTECTED]
 Sent: Sunday, February 01, 2004 6:26 PM
 To: CF-Talk
 Subject: Re: OT: Making Combo Box from select

 Try this one - _javascript_.I'm going to be implementing this shortly so
I
 don't yet know
 if it's fully what you're looking for - should be adaptable...

http://_javascript_.internet.com/page-details/term-search.htmlhttp://javascri
pt.internet.com/page-details/term-search.html

 At 05:11 PM 2/1/04, you wrote:
 Does anyone have code they would share to create the equivalent of a VB
 combo
 box?

 I'd like to give the user the ability to either select from a drop-down
 list
 or to start typing and have the list move as the user types to the
first
 entry
 that matches what has been typed so far.

 Thanks,
 Andy

 --
 [

 --
 [
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: from 4.5.1 to MX

2004-02-02 Thread Doug White

CFMX comes with a utility called code analyzer. You can run this against each
web site and it will list any function or syntax that will need to be changed in
order to run without error.

When we moved from CF 5.0 on several web sites, after running the Code Analyzer,
we found all of then ran just fine, but faster with CFMX.On one web site,
there was a single syntax error reported, and it required changing only one line
of code.

There are, of course, issues with installation as there is with most of
Macromedia Products, and most of these are described in white papers on the
Macromedia Web site.

Be sure to upgrade the MDAC to 2.8 before you attempt the installation, however.

==
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
==
Aspire to Inspire before you Retire or Expire!

- Original Message - 
From: Steff
To: CF-Talk
Sent: Monday, February 02, 2004 4:02 AM
Subject: from 4.5.1 to MX

Hello

I wan't to know what I should think to avoid problems when I will
migrate my coldfusion applications from ColdFusion Server 4.5.1 to
ColdFusion Server MX.

Can you tell me more or give me urls?

Thanks
Cordially
Steff

 Stphane Vauclaire
c.com production
+352 48 30 15 21 02

[EMAIL PROTECTED]
http://www.c-comnet.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Storing SQL SP's in VSS]

2004-02-02 Thread Dan O'Keefe

Michael Wolfe wrote:

 I found a nice little app called SQL Source Control. It takes Query
 Analyzer, mixes it with VSS, and adds a dash of IntelliSense.What 
 you get
 is a very nice IDE for SQL development, and you get projects that are
 integrated with VSS. Sweet!


 Almost forgot the URL... http://www.sqlsourcecontrol.com/


 --

 Michael Wolfe

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

Awesome, I'll check it out.

Dan
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CFMX 6.1, JDBC, settings??

2004-02-02 Thread Douglas.Knudsen

We are using the standard driver that ships with CFMX.We are running the J2EE install on JRun.

 
thanks for the FYI

 
Doug

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, January 30, 2004 7:12 PM
To: CF-Talk
Subject: RE: CFMX 6.1, JDBC, settings??

 My DBA says that after each SQL run by CF the following is 
 appended SET TRANSACTION ISOLATION LEVEL READ COMMITTED
 
 The DBA is asking me if we can turn this off.Is there an 
 XML config file somewheres that can be tweaked to do this?

Not that I know of, but what database and drivers are you using?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

configure cf server

2004-02-02 Thread Won Lee

Hello,

I know I asked this question last week, but I am at a lose.
Perhaps it just got lost as the subject started to shift away from my 
initial question.

For the life of me I can not create an ODBC datasource in CF 5.0 administrator.
I know I must be doing something wrong somewhere.I just don't know where.

CF server:
CF 5.0 Professional running on RH 9.0 and Apache 2.

SQL server:
SQL server 2000 Enterprise MS Win2K3.

I just can't get it to create an ODBC connection.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: from 4.5.1 to MX

2004-02-02 Thread Jim Davis

The only problem Ive seen is with COM objects (which MXs Java architecture
doesnt handle all that well).They should still work, but maybe not
completely as expected.

 
Also you should consider doing a serious performance analysis on the
converted application.Ive found that in some cases slow templates
suddenly became fastest and fast templates suddenly became the worst
performers.Overall the speed improvement was substantial  but you should
level-set your expectations of template performance in the new architecture.

 
Jim Davis

 
_

From: Steff [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 02, 2004 5:03 AM
To: CF-Talk
Subject: from 4.5.1 to MX

 
Hello

 I wan't to know what I should think to avoid problems when I will
migrate my coldfusion applications from ColdFusion Server 4.5.1 to
ColdFusion Server MX.

Can you tell me more or give me urls?

Thanks
Cordially
Steff

Stphane Vauclaire
c.com production
+352 48 30 15 21 02

[EMAIL PROTECTED]
http://www.c-comnet.com/
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: OT: Making Combo Box from select

2004-02-02 Thread Andy Ousterhout

David,

Thanks.

Andy
-Original Message-
From: David Fafard [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 7:22 AM
To: CF-Talk
Subject: Re: OT: Making Combo Box from select

maybe

http://www.mattkruse.com/_javascript_/autocomplete/

dave
 - Original Message -
 From: Andy Ousterhout
 To: CF-Talk
 Sent: Sunday, February 01, 2004 7:36 PM
 Subject: RE: OT: Making Combo Box from select

 Thanks.I've already incorporated what you sent into my code.
-Original Message-
From: Alan Rafael Bleiweiss [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 01, 2004 7:30 PM
To: CF-Talk
Subject: RE: OT: Making Combo Box from select

Not sure what's required.I'll keep my eyes out though cause I'd like
to
 see
the full capability.

At 05:51 PM 2/1/04, you wrote:
Thanks, that works great.Any way to have all of the typing in the
select
box?

Andy
-Original Message-
From: Alan Rafael Bleiweiss [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 01, 2004 6:26 PM
To: CF-Talk
Subject: Re: OT: Making Combo Box from select

Try this one - _javascript_.I'm going to be implementing this
shortly so
 I
don't yet know
if it's fully what you're looking for - should be adaptable...

http://_javascript_.internet.com/page-details/term-search.htmlhttp://javascri
 pt.internet.com/page-details/term-search.html

At 05:11 PM 2/1/04, you wrote:
Does anyone have code they would share to create the equivalent of
a VB
combo
box?

I'd like to give the user the ability to either select from a
drop-down
list
or to start typing and have the list move as the user types to the
 first
entry
that matches what has been typed so far.

Thanks,
Andy

--
[

--
[
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Any ideas??

2004-02-02 Thread Jim Davis

Well - that's a GUID value - are you calling it as a number anyplace?
Trying to do math on it or use an aggregate mathematical function?

 
Posting some code would be the best way to help.

 
Jim Davis

 
_

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 02, 2004 6:37 AM
To: CF-Talk
Subject: Any ideas??

 
I keep getting the error:

8170f80c-8436-483b-84b5-ee351daffc0f must be interprettable as a valid
number in the current locale. 

Without getting into too much detail ,all I am doing in the code is a QoQ on
a query containing a few int and varchar columns, along with a SQL GUID
column.

We are using CFMX on SQL Server 2K on Win2K

Anyone have any ideas?

Neil
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Weird: CF Debug info Firebird

2004-02-02 Thread Josh Remus

I'm just finally getting to the point where I'm using Firebird as my browser
full-time.But I just realized the weirdest thing

When I turn on debugging for a page, I see the debug info in IE, but not in
Firebird on identical pages!

If I view source on both browsers, I see the closing HTML tag, but on
Firebird that's as far as it goes, while on IE it continues onto the debug
info.

I can understand why firebird thinks it's done after the closing HTML tag,
but is there a way to still see this debug info in there? Thanks for any
help.
---
Josh Remus
Network Manager
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Oracle Stored Procedure and CF 5.0

2004-02-02 Thread David Jones

This was exactly what I was looking for.But when I did it I created a
package and pass the cursor from the procedure to the package. I did this
because this is how it was explained on the macromedia website (I should
have looked on the site before asking the question).Do I not have to do
this? Was this just for organization?

Thanks,

David
-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]
Sent: Friday, January 30, 2004 12:00 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedure and CF 5.0

On Fri, 2004-01-30 at 07:50, David Jones wrote:
 I have a client that wants me to remove all inline SQL from his
application
 even though I am using the CFQueryParam tag to invoke the use of bind
 variables.I am fairly familiar with Oracle Stored Procedures but what
I
 not familiar with is returning queries from a Stored Procedure to CF
5.0.
 Is this possible, if so can someone provide me with a simple example.

if you havent found this out already, here is an example of using a
stored procedure

cfstoredproc procedure=sp_login
datasource=#request.dsn# debug=no

cfprocparam dbVarName=ipaddress value=#cgi.REMOTE_ADDR#
CFSQLtype=CF_SQL_VARCHAR null=No
cfprocparam dbVarName=login value=#cli_username#
CFSQLType=CF_SQL_VARCHAR null=No
cfprocparam dbVarName=password value=#rmsEncrypt(cli_password)#
CFSQLType=CF_SQL_VARCHAR null=No

cfprocresult name=checkClientCreds resultSet=1
!--- if you had other result sets you could do this as well
cfprocresult name=otherstuff resultSet=2
...
---
/cfstoredproc

One of the reasons I like stored procedures so much is you can get multi
query sets back for the price of one database hit.

anyway, hope that helps.

--
Vale,
Rob

Luxuria immodica insaniam creat.
Sanam formam viatae conservate!

http://www.rohanclan.com
http://treebeard.sourceforge.net
http://ashpool.sourceforge.net
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Weird: CF Debug info Firebird

2004-02-02 Thread Robert Bailey

I get debugging info on my firebird

 
Robert Bailey
Aesir Network Technologies
Direct: (214) 432-5865
Main: (903) 238-8211
Support: (903) 238-8212
Toll Free: (877) 238-8211
Fax: (903) 238-8251





From: Josh Remus [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 02, 2004 11:02 AM
To: CF-Talk
Subject: Weird: CF Debug info  Firebird

I'm just finally getting to the point where I'm using Firebird as my browser
full-time.But I just realized the weirdest thing

When I turn on debugging for a page, I see the debug info in IE, but not in
Firebird on identical pages!

If I view source on both browsers, I see the closing HTML tag, but on
Firebird that's as far as it goes, while on IE it continues onto the debug
info.

I can understand why firebird thinks it's done after the closing HTML tag,
but is there a way to still see this debug info in there? Thanks for any
help.
---
Josh Remus
Network Manager 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Obtaining Request URL

Unfortunately, we do Government work, so we can't rely on _javascript_.

So the answer's no? ;-)

Jamie

On Thu, 29 Jan 2004 14:25:07 -0500, in cf-talk you wrote:

You could just use _javascript_. That way it wouldn't matter what version
of CF you are using.

 

Ben

 

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 29, 2004 1:59 PM
To: CF-Talk
Subject: Obtaining Request URL

 

Just curious, is there a way to get the entire requested URL in CFMX?
That is, *not* a manually pieced-together string of cgi vars?

Thanks,
Jamie

_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Weird: CF Debug info Firebird

2004-02-02 Thread Stephen Moretti

 I'm just finally getting to the point where I'm using Firebird as my browser
 full-time.But I just realized the weirdest thing
 
 When I turn on debugging for a page, I see the debug info in IE, but not in
 Firebird on identical pages!
 
 If I view source on both browsers, I see the closing HTML tag, but on
 Firebird that's as far as it goes, while on IE it continues onto the debug
 info.
 
 I can understand why firebird thinks it's done after the closing HTML tag,
 but is there a way to still see this debug info in there? Thanks for any
 help.


Sounds like the HTML in your page is busted and the debug info has 
disappeared into a form field or something like that.

Firebird sticks to the standards, rather than making assumptions about 
your html as IE does.

Try viewing the source of the page, rather than looking at the html.

Incidently, a very useful extension for Firebird is the WebDeveloper 
extension...If you get the latest nightly installer for windows and do 
a custom install, you'll find it under there.

Regards

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Weird: CF Debug info Firebird

2004-02-02 Thread Jochem van Dieten

Josh Remus said:

 When I turn on debugging for a page, I see the debug info in IE, but
 not in Firebird on identical pages!

 If I view source on both browsers, I see the closing HTML tag, but
 on Firebird that's as far as it goes, while on IE it continues onto
 the debug info.

 I can understand why firebird thinks it's done after the closing
 HTML tag, but is there a way to still see this debug info in there?

Are you using a strict XHTML doctype declaration? If so, change it to
transitional or to some bogus declaration.

Jochem
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CFMX 6.1, JDBC, settings??

2004-02-02 Thread Dave Watts

 We are using the standard driver that ships with CFMX.We 
 are running the J2EE install on JRun.

What is the default isolation level within your database? Is it READ
COMMITTED?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Oracle Stored Procedure and CF 5.0

2004-02-02 Thread Plunkett, Matt

-Original Message-
From: Rob Rohan
Sent: Friday, January 30, 2004 12:00 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedure and CF 5.0

 cfstoredproc procedure=sp_login 
 datasource=#request.dsn# debug=no
 
 cfprocparam dbVarName=ipaddress value=#cgi.REMOTE_ADDR#
 CFSQLtype=CF_SQL_VARCHAR null=No
 cfprocparam dbVarName=login value=#cli_username#
 CFSQLType=CF_SQL_VARCHAR null=No
 cfprocparam dbVarName=password value=#rmsEncrypt(cli_password)#
 CFSQLType=CF_SQL_VARCHAR null=No

 cfprocresult name=checkClientCreds resultSet=1
 !--- if you had other result sets you could do this as well
 cfprocresult name=otherstuff resultSet=2
 ...
 ---
 /cfstoredproc 

 
This procedure is not completely correct for CF 5 (I think it is correct for
MX, but I mainly use 5, so who knows...).

 
In CF5, you must put the parameter in for the ref cursor and set
maxrows=-1:

 
cfstoredproc procedure=sp_login datasource=#request.dsn# debug=no
 cfprocparam dbVarName=ipaddress value=#cgi.REMOTE_ADDR#CFSQLtype=
CF_SQL_VARCHAR null=No
 cfprocparam dbVarName=login value=#cli_username# CFSQLType=
CF_SQL_VARCHAR null=No
 cfprocparam dbVarName=password value=#rmsEncrypt(cli_password)#
CFSQLType=CF_SQL_VARCHAR null=No
 cfprocparam type=Out cfsqltype=CF_SQL_REFCURSOR maxrows=-1
variable=p_ref
 cfprocresult name=checkClientCreds
/cfstoredproc

 
I left the rest of Rob's query the same, although I don't use dbVarName and
I always set the type (In, Out, In/Out).Another gotcha: you need to keep
the parameters in the same order that they appear in your procedure, even
though you get to set the name.

 
HTH,
Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Weird: CF Debug info Firebird

On Monday 02 Feb 2004 16:08 pm, Robert Bailey wrote:
I get debugging info on my firebird

:nods 
FB 0.7/Linux

Can I recommend the excellent AdBlock plugin ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

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

Re: Flash HTML Editor?

On Friday 30 Jan 2004 19:46 pm, Rob Rohan wrote:
 Does anyone know of a free flash or java html editor? (At any level of
 development)

Perl and PHP both have methods for generating flash.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

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

RE: Oracle Stored Procedure and CF 5.0

2004-02-02 Thread David Jones

Yeah, I actually found all this information on the macromedia website right
after I posted this.This is really cool, and works very nicely. I played
with it this weekend, I really like that you can return multiple record sets
with one procedure.

Thanks,

David
-Original Message-
From: Plunkett, Matt [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 11:21 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedure and CF 5.0

-Original Message-
From: Rob Rohan
Sent: Friday, January 30, 2004 12:00 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedure and CF 5.0

cfstoredproc procedure=sp_login
datasource=#request.dsn# debug=no

cfprocparam dbVarName=ipaddress value=#cgi.REMOTE_ADDR#
CFSQLtype=CF_SQL_VARCHAR null=No
cfprocparam dbVarName=login value=#cli_username#
CFSQLType=CF_SQL_VARCHAR null=No
cfprocparam dbVarName=password value=#rmsEncrypt(cli_password)#
CFSQLType=CF_SQL_VARCHAR null=No

cfprocresult name=checkClientCreds resultSet=1
!--- if you had other result sets you could do this as well
cfprocresult name=otherstuff resultSet=2
...
---
/cfstoredproc

This procedure is not completely correct for CF 5 (I think it is correct
for
MX, but I mainly use 5, so who knows...).

In CF5, you must put the parameter in for the ref cursor and set
maxrows=-1:

cfstoredproc procedure=sp_login datasource=#request.dsn# debug=no
cfprocparam dbVarName=ipaddress value=#cgi.REMOTE_ADDR#CFSQLtype=
CF_SQL_VARCHAR null=No
cfprocparam dbVarName=login value=#cli_username# CFSQLType=
CF_SQL_VARCHAR null=No
cfprocparam dbVarName=password value=#rmsEncrypt(cli_password)#
CFSQLType=CF_SQL_VARCHAR null=No
cfprocparam type=Out cfsqltype=CF_SQL_REFCURSOR maxrows=-1
variable=p_ref
cfprocresult name=checkClientCreds
/cfstoredproc

I left the rest of Rob's query the same, although I don't use dbVarName
and
I always set the type (In, Out, In/Out).Another gotcha: you need to keep
the parameters in the same order that they appear in your procedure, even
though you get to set the name.

HTH,
Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Flash HTML Editor?

lol, not quite what he meant ;)



 On Friday 30 Jan 2004 19:46 pm, Rob Rohan wrote:
 Does anyone know of a free flash or java html editor? (At any level of
 development)

 Perl and PHP both have methods for generating flash.

 --
 Tom Chiverton
 Advanced ColdFusion Programmer

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


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Weird: CF Debug info Firebird

2004-02-02 Thread Josh Remus

Well, I don't running 0.7 on Windoze.Anyone else running this combo that
can verify this problem?I don't have any weird plugins either (gestures,
google toolbar, etc).My settings all look okay, although there doesn't
seem to be a setting that would influence this.Hmpf.
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 11:34 AM
To: CF-Talk
Subject: Re: Weird: CF Debug info  Firebird

On Monday 02 Feb 2004 16:08 pm, Robert Bailey wrote:
I get debugging info on my firebird

:nods
FB 0.7/Linux

Can I recommend the excellent AdBlock plugin ?

--
Tom Chiverton
Advanced ColdFusion Programmer

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

RE: Web Service - this gets error . can anyone see why?

2004-02-02 Thread Tom Jordahl

Mike,

Yes, enumeration is the problem here.

I have fixed this, and I am working to try and get this fix available to
customers.

I apologize for this bug.No test for a situation means it doesn't work.
Now we have an enumeration test. :-)

In the mean time, try this workaround:

cfscript

ws = CreateObject(webservice,
http://www.webservicex.net/CurrencyConvertor.asmx?wsdl
http://www.webservicex.net/CurrencyConvertor.asmx?wsdl );

enum = CreateObject(java, NET.webserviceX.www.Currency);

argFrom = enum.fromString(GBP);

argTo = enum.fromString(USD);

result = ws.ConversionRate(argFrom, argTo);

/cfscript

The above workaround has one tricky problem however; you will need to copy
the class NET.webserviceX.www.Currency to a directory on the ColdFusion
classpath.I suggest C:\CFusionMX\wwwroot\WEB-INF\classes (adjust to your
installation directory).

Here is how to do that:

1.	Run this page at least once and get the Class Not Found error.
2.	Go to the CFusionMX/stubs directory and find the WS-
directory that has the NET sub directory.
3.	Copy the NET directory to wwwroot/WEB-INF/class.
4.	Delete all the .class files in the NET/webserviceX.www directory
EXCEPT Currency.class.



Sean Cornfield originally brought the issue up tome because of a thread on
CFGURU .Here is his web log posting on how to debug these issues:
http://www.corfield.org/blog/past/2004_01.html#000252
http://www.corfield.org/blog/past/2004_01.html#000252 

Hope this helps.

--
Tom Jordahl
Macromedia Server Development

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 02, 2004 6:58 AM
To: CF-Talk
Subject: Re: Web Service - this gets error . can anyone see why?

Mike,

The issue you have is that Currency, which is the data type for 
fromCurrency and toCurrency is an enumerated data type.

There is a issue with CF/Axis and enumerated types.I believe that 
Macromedia is aware of it, but have no idea what the status is or if 
there is a decent work around.

I've been trying to sort out an issue with an enumerated data type on a 
web service I'm trying to access and as yet I haven't had been able to 
get a solution, other than to hard/hand code the soap packet and pass it 
via cfhttp to the webservice. Not a usable solution unfortunately.

The other solution that someone suggested was to import the web service 
and rewrite it to accept strings/numerics and post it out to the actual 
web service (I think I got that right).Again not really a usable 
solution.Why should you have to rewrite someone else's web service... :o{

If get a sensible solution, I would love to know!

Regards

Stephen

Mike Kear wrote:

 I want to consume a web service for converting currencies(at
 http://www.webservicex.net/CurrencyConvertor.asmx?wsdl
http://www.webservicex.net/CurrencyConvertor.asmx?wsdl)and I used the
 EXCELLENT implementation in DreamweaverMX to write the code.That drag
and
 drop is an absolute gem for this!
 
 Anyway, the resulting page give an error and I cant see why because what's
 going in seems perfectly logical for what the web service is supposed to
do.
 
 
 Here's the code that Dreamweaver wrote:
 
 cfinvoke
 
 webservice=http://www.webservicex.net/CurrencyConvertor.asmx?WSDL
 
 method=conversionRate
 
 returnvariable=conversionRateRet
 
 cfinvokeargument name=fromCurrency value=GBP/
 
 cfinvokeargument name=toCurrency value=USD/
 
 /cfinvoke
 
 Which (I thought) should take the input value GBP and work out a
conversion
 to USD, and return a variable #conversionRateRet#which will be a number
 such as 1.02, being the conversion rate.
 
 However here's what I get:
 
 [quote]
 
 Could not perform web service invocation conversionRate because
 java.lang.IllegalArgumentException: argument type mismatch
 
 [/quote]
 
 And it's highlighting the toCurrency line as the one with the error.
Huh?
 If the 'fromCurrency line is correct, how come the next line isn't?
Can
 anyone see what's wrong?Or is there something else I have to do on the
 page?
 
 Cheers
 
 Mike Kear
 
 Windsor, NSW, Australia
 
 AFP Webworks
 
 http://afpwebworks.com http://afpwebworks.com 


_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Weird: CF Debug info Firebird

2004-02-02 Thread Josh Remus

nevermind, I figured it out.A difference in the way firebird  IE handle
proxies, I had to specifically add the internal dev server to the don't
proxy list, and then came the debug info.
-Original Message-
From: Josh Remus [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 11:42 AM
To: CF-Talk
Subject: RE: Weird: CF Debug info  Firebird

Well, I don't running 0.7 on Windoze.Anyone else running this combo that
can verify this problem?I don't have any weird plugins either (gestures,
google toolbar, etc).My settings all look okay, although there doesn't
seem to be a setting that would influence this.Hmpf.
 -Original Message-
 From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
 Sent: Monday, February 02, 2004 11:34 AM
 To: CF-Talk
 Subject: Re: Weird: CF Debug info  Firebird

 On Monday 02 Feb 2004 16:08 pm, Robert Bailey wrote:
 I get debugging info on my firebird

 :nods
 FB 0.7/Linux

 Can I recommend the excellent AdBlock plugin ?

 --
 Tom Chiverton
 Advanced ColdFusion Programmer

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

RE: Web Service - this gets error . can anyone see why?

2004-02-02 Thread JT

WebserviceX.NET is under maintenance.

This site will be up soon

Sorry for this inconvenience.

Webservices Users ,Please use following IP addresstill maintenance
complete.

http://66.165.154.102/[Service Name]

-Original Message-
From: Tom Jordahl [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 9:45 AM
To: CF-Talk
Subject: RE: Web Service - this gets error . can anyone see why?

Mike,

Yes, enumeration is the problem here.

I have fixed this, and I am working to try and get this fix available to
customers.

I apologize for this bug.No test for a situation means it doesn't work.
Now we have an enumeration test. :-)

In the mean time, try this workaround:

cfscript

 ws = CreateObject(webservice,
http://www.webservicex.net/CurrencyConvertor.asmx?wsdl
http://www.webservicex.net/CurrencyConvertor.asmx?wsdl );

 enum = CreateObject(java, NET.webserviceX.www.Currency);

 argFrom = enum.fromString(GBP);

 argTo = enum.fromString(USD);

 result = ws.ConversionRate(argFrom, argTo);

/cfscript

The above workaround has one tricky problem however; you will need to copy
the class NET.webserviceX.www.Currency to a directory on the ColdFusion
classpath.I suggest C:\CFusionMX\wwwroot\WEB-INF\classes (adjust to your
installation directory).

Here is how to do that:

1. Run this page at least once and get the Class Not Found error.
2. Go to the CFusionMX/stubs directory and find the WS-
directory that has the NET sub directory.
3. Copy the NET directory to wwwroot/WEB-INF/class.
4. Delete all the .class files in the NET/webserviceX.www directory
EXCEPT Currency.class.

Sean Cornfield originally brought the issue up tome because of a thread on
CFGURU .Here is his web log posting on how to debug these issues:
http://www.corfield.org/blog/past/2004_01.html#000252
http://www.corfield.org/blog/past/2004_01.html#000252

Hope this helps.

--
Tom Jordahl
Macromedia Server Development

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 6:58 AM
To: CF-Talk
Subject: Re: Web Service - this gets error . can anyone see why?

Mike,

The issue you have is that Currency, which is the data type for
fromCurrency and toCurrency is an enumerated data type.

There is a issue with CF/Axis and enumerated types.I believe that
Macromedia is aware of it, but have no idea what the status is or if
there is a decent work around.

I've been trying to sort out an issue with an enumerated data type on a
web service I'm trying to access and as yet I haven't had been able to
get a solution, other than to hard/hand code the soap packet and pass it
via cfhttp to the webservice. Not a usable solution unfortunately.

The other solution that someone suggested was to import the web service
and rewrite it to accept strings/numerics and post it out to the actual
web service (I think I got that right).Again not really a usable
solution.Why should you have to rewrite someone else's web service...
:o{

If get a sensible solution, I would love to know!

Regards

Stephen

Mike Kear wrote:

 I want to consume a web service for converting currencies(at
 http://www.webservicex.net/CurrencyConvertor.asmx?wsdl
http://www.webservicex.net/CurrencyConvertor.asmx?wsdl)and I used
the
 EXCELLENT implementation in DreamweaverMX to write the code.That drag
and
 drop is an absolute gem for this!

 Anyway, the resulting page give an error and I cant see why because
what's
 going in seems perfectly logical for what the web service is supposed to
do.


 Here's the code that Dreamweaver wrote:

 cfinvoke

 webservice=http://www.webservicex.net/CurrencyConvertor.asmx?WSDL

 method=conversionRate

 returnvariable=conversionRateRet

 cfinvokeargument name=fromCurrency value=GBP/

 cfinvokeargument name=toCurrency value=USD/

 /cfinvoke

 Which (I thought) should take the input value GBP and work out a
conversion
 to USD, and return a variable #conversionRateRet#which will be a
number
 such as 1.02, being the conversion rate.

 However here's what I get:

 [quote]

 Could not perform web service invocation conversionRate because
 java.lang.IllegalArgumentException: argument type mismatch

 [/quote]

 And it's highlighting the toCurrency line as the one with the error.
Huh?
 If the 'fromCurrency line is correct, how come the next line isn't?
Can
 anyone see what's wrong?Or is there something else I have to do on
the
 page?

 Cheers

 Mike Kear

 Windsor, NSW, Australia

 AFP Webworks

 http://afpwebworks.com http://afpwebworks.com


 _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFC won't return variable

Hey All,

I have a CFC that takes the FORM scope as an argument collection (do do some
form data validation and spit back an errMsg var).I've verified that the
code in the CFC is getting run, but no matter what (i.e. trying different
var names etc.) it will NOT return the variable I specified in the cfinvoke
returnvariable attribute (ErrMsg).Note that I've done this extensively
throughout this application and it works like a charmbut this one just
won't fly???

This is Windows 2000 Advanced Server and CFMX 6.1

Any thoughts?

TIA

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
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Why Webservices Stink

2004-02-02 Thread Bryan F. Hogan

-Original Message-
From: JT [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 02, 2004 11:49 AM
To: CF-Talk
Subject: RE: Web Service - this gets error . can anyone see why?

WebserviceX.NET is under maintenance.

This site will be up soon

Sorry for this inconvenience.

Webservices Users ,Please use following IP addresstill maintenance
complete.

http://66.165.154.102/[Service Name]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Why Webservices Stink

2004-02-02 Thread Matt Liotta

See http://archive.devx.com/javaSR/articles/guestop/liotta-1.asp for 
coverage on this topic.

-Matt

On Feb 2, 2004, at 11:54 AM, Bryan F. Hogan wrote:

 -Original Message-
 From: JT [mailto:[EMAIL PROTECTED]
 Sent: Monday, February 02, 2004 11:49 AM
 To: CF-Talk
 Subject: RE: Web Service - this gets error . can anyone see why?

 WebserviceX.NET is under maintenance.

 This site will be up soon

 Sorry for this inconvenience.

 Webservices Users ,Please use following IP address  till maintenance
 complete.

 http://66.165.154.102/[ServiceName]

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CFC won't return variable

2004-02-02 Thread Raymond Camden

How about sharing some code?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CFC won't return variable

Well I don't think the code will help because the same code works elsewherebut here's the short version:

!--- instantiate the Transaction component ---
cfobject name=MyTx component=components.test

!--- validate form data ---
cfinvoke
component=#MyTx#
method=ChkCardInfo
argumentcollection=#FORM#
retrurnvariable=ErrMsg

the CFC (shortened version):
cfcomponent
cffunction name=ChkCardInfo returnType=string access=public
 cfset ErrMsg = aegagagadg 
 cfreturn ErrMsg
/cffunction
/cfcomponent

Now I know I've given the shortened version, but even this doesn't return anything.If I reference ARGUMNETS.txtMyFormVar (and there is no such form var) in the function above, then the function will throw an error (therefore it is getting run).No matter which way I slice it this thing will not return anything.It may be due to other codein the calling fileso I'm looking into that now.

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: Raymond Camden 
To: CF-Talk 
Sent: Monday, February 02, 2004 9:10 AM
Subject: RE: CFC won't return variable

How about sharing some code?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Why Webservices Stink

2004-02-02 Thread Bryan F. Hogan

Great Article!

-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 02, 2004 12:09 PM
To: CF-Talk
Subject: Re: Why Webservices Stink

See http://archive.devx.com/javaSR/articles/guestop/liotta-1.asp for 
coverage on this topic.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CFC getting lost?

2004-02-02 Thread Ian Skinner

Ok, I'm not really sure what is going on here, but this is very confusing.

I've got a form that calls an action CFC that in turn calls a method of a CFC instance in the session scope.This CFC is a composite of several other CFC's that encapsulate different aspects of the system.Inside these CFC's there is function that adds and another that updates data in a database with the data collected in the original form.One of the fields being modified in the database is the User ID that I am getting from the CGI.Auth_User populated from the Integrated Windows Authentication mechanism from the IIS server at the time of the Query being processed.

This works correctly most of the time, but too frequently (roughly 1 in 4 to 1 in 5 tries) I get in error from the database because the required User ID value provided from CGI.Auth_User is empty.

After working really hard to track this problem it seems that somewhere along the line the CFC's seem to get lost?Capturing the CGI structure at each CFC I am finding that when the error occurs, I get very strange values for the CGI keys.The one the really catches my eye is that CF_TEMPLATE_PATH, PATH_TRANSLATED and SCRIPT_NAME contain an unrelated template from our website ... apparently different random templates each time I capture the error?What could possible be causing this?Anybody run in to anything like this?

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CFC won't return variable

2004-02-02 Thread Raymond Camden

The code does help. You have a typo. retrunvariable should be
returnvariable.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Flash HTML Editor?

On Monday 02 Feb 2004 16:41 pm, [EMAIL PROTECTED] wrote:
  Does anyone know of a free flash or java html editor? (At any level of
  development)
  Perl and PHP both have methods for generating flash.
 lol, not quite what he meant ;)

Oops :-)

( ( ( ( free flash) or (java html) ) editor )
OR
( free (flash or java) html editor ) )

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

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

SOLVED: CFC won't return variable

FYI...it's best to spell returnvariable and not retrurnvariable

LOL

Just call me Monday Morning Loser Boy!! ;-)

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: Bryan Stevenson 
To: CF-Talk 
Sent: Monday, February 02, 2004 9:23 AM
Subject: Re: CFC won't return variable

Well I don't think the code will help because the same code works elsewherebut here's the short version:

!--- instantiate the Transaction component ---
cfobject name=MyTx component=components.test

!--- validate form data ---
cfinvoke
 component=#MyTx#
 method=ChkCardInfo
 argumentcollection=#FORM#
 retrurnvariable=ErrMsg

the CFC (shortened version):
cfcomponent
 cffunction name=ChkCardInfo returnType=string access=public
cfset ErrMsg = aegagagadg 
cfreturn ErrMsg
 /cffunction
/cfcomponent

Now I know I've given the shortened version, but even this doesn't return anything.If I reference ARGUMNETS.txtMyFormVar (and there is no such form var) in the function above, then the function will throw an error (therefore it is getting run).No matter which way I slice it this thing will not return anything.It may be due to other codein the calling fileso I'm looking into that now.

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: Raymond Camden 
 To: CF-Talk 
 Sent: Monday, February 02, 2004 9:10 AM
 Subject: RE: CFC won't return variable

 How about sharing some code?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CFC won't return variable

LOL...thanks Ray ;-)

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: Raymond Camden 
To: CF-Talk 
Sent: Monday, February 02, 2004 9:27 AM
Subject: RE: CFC won't return variable

The code does help. You have a typo. retrunvariable should be
returnvariable.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Obtaining Request URL

2004-02-02 Thread Jeremy Brodie

Jamie wrote: Unfortunately, we do Government work, so we can't rely on _javascript_.

Could you elaborate why? Every US Government contract I've worked on did not prohibit the use of _javascript_.

Also, could you elaborate what you are attempting to do? This way the group can figure out the best way of pulling the information you need for your application, as well as how you will be hosting your application (one server, many servers).

Jeremy Brodie
Edgewater Technology

web: http://www.edgewater.com
phone:(703) 815-2500
email: [EMAIL PROTECTED]

Unfortunately, we do Government work, so we can't rely on _javascript_.

So the answer's no? ;-)

Jamie

On Thu, 29 Jan 2004 14:25:07 -0500, in cf-talk you wrote:

You could just use _javascript_. That way it wouldn't matter what version
of CF you are using.

 

Ben

 

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 29, 2004 1:59 PM
To: CF-Talk
Subject: Obtaining Request URL

 

Just curious, is there a way to get the entire requested URL in CFMX?
That is, *not* a manually pieced-together string of cgi vars?

Thanks,
Jamie

_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

help with modifying Forta shopping cart CFC

2004-02-02 Thread Jim

Posted this Friday but list traffic seemed light over the weekend so
I'm reposting hoping to get some ideas...

Recently upgraded from 4.5 to MX and am trying to leverage some of the new
MX features.Currently reworking an old shopping cart and am trying to
use the shoppingcart.cfc example in Forta's book.

Got the basics working, but my cart has one twist I'm not sure how
best to implement. Users will be able to ship items to different
addresses. Forta's example ony uses a product ID and quantity. I need
to pass a 'shiptoID' as well.

So far I've tried a few things ( wrapping the array into another
structure with the shiptoID as the key) without much success, still
trying to get my CF4.5 mindset wrapped around CFCs.

Any suggestions or pointers for a direction to take?

thanks,
jim
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Das cf eclipse plug-in

2004-02-02 Thread Rob Rohan

I worked on the cf plug-in this weekend a bit, and I am letting lose
another version. I wont have time to work on it from this point for a
while as I have to actually write cf code (get paid etc) hehehe - plus,
to me, it's now in a pretty usable state.

The new version is 1.0.8 and it has the following improvements and known
bugs:

New:
+ Added color coding for CFScript, _javascript_, and style sections
+ Cleaned up the code a bit - commented more et cetera

Known bugs:

- The code completion for cf tags and attribtues does not work well in
_javascript_ and CSS blocks (I have it turned off until I can fix it -
even dreamweaver wont do attributes in css or js blocks - try it)
- The code insight does not limit the selection as you type
- More to come I am sure :) ...

You can get the plug-in and see a screen shot at:
http://cfeclipse.rohanclan.com

-- 
Vale,
Rob

Luxuria immodica insaniam creat.
Sanam formam viatae conservate!

http://www.rohanclan.com
http://treebeard.sourceforge.net
http://ashpool.sourceforge.net
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Simple UPDATE Stuff Driving Me Insane...

Hi guys,

I've got an update field where I'm. you guessed it, updating a table.

I keep getting:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Data type mismatch in criteria _expression_.

My code is below:

CFQUERY NAME=AgentDetails datasource=020
UPDATE PropertyAgent
SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
PropertyAgentFlatNumberHouseName =
'#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber =
#Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
'#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
'#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
'#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
'#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
'#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
#Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
'#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
'#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
#Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
'#Form.PropertyAgentEmailAddress#'
WHERE PropertyAgentID = #Client.PropertyAgentID#
/CFQUERY

My fields which are numbers are PropertyAgentStreetNumber,
PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

When I change PropertyAgentContactMobile to
'#PropertyAgentContactMobile#' and correspondingly change the ACCESS
field to TEXT... the update works fine... so it seems like this is the
problem field as through tests, the others are fine.

Any ideas, this is bizarre?The field attributes seem the same for
PropertyAgentContactMobile as they are for the other numeric fields.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

2004-02-02 Thread Robert Redpath

Shouldn't #Form.PropertyAgentStreetNumber# be a text datatype? What if
someone is 101A Main Street?

 
As well as #Form.PropertyAgentTelephoneNumber#.Shoudn't that be a text
datatype too? 555-555-1212 is text. As well as
#Form.PropertyAgentContactMobile#. 

 
And therefore use ' around your varsAccess seems to better when
using ' sometimes. 

 -Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 1:19 PM
To: CF-Talk
Subject: Simple UPDATE Stuff Driving Me Insane... 

Hi guys,

I've got an update field where I'm. you guessed it, updating a table.

I keep getting:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Data type mismatch in criteria _expression_.

My code is below:

CFQUERY NAME=AgentDetails datasource=020
UPDATE PropertyAgent
SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
PropertyAgentFlatNumberHouseName =
'#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber =
#Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
'#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
'#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
'#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
'#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
'#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
#Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
'#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
'#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
#Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
'#Form.PropertyAgentEmailAddress#'
WHERE PropertyAgentID = #Client.PropertyAgentID#
/CFQUERY

My fields which are numbers are PropertyAgentStreetNumber,
PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

When I change PropertyAgentContactMobile to
'#PropertyAgentContactMobile#' and correspondingly change the ACCESS
field to TEXT... the update works fine... so it seems like this is the
problem field as through tests, the others are fine.

Any ideas, this is bizarre?The field attributes seem the same for
PropertyAgentContactMobile as they are for the other numeric fields. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CFMX 6.1, JDBC, settings??

2004-02-02 Thread Douglas.Knudsen

From the DBA...answer to Is it READ COMMITTED? - Yes, it is. That's also the oracle default. 

 
I did see in the jrun-resources.xml file this
isolation-levelREAD_UNCOMMITTED/isolation-level
but its part of a commented out block.This becasue of the 6 to 6.1 changes?I suspect so.

 
The DBA is wanting to be able to see the SQL sent to the Oracle server by CF, historically.Apparently 
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
nicks the history.I'm far from a DBA...so no clue for me.

 
Doug

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 11:27 AM
To: CF-Talk
Subject: RE: CFMX 6.1, JDBC, settings??

 We are using the standard driver that ships with CFMX.We 
 are running the J2EE install on JRun.

What is the default isolation level within your database? Is it READ
COMMITTED?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Microsoft Data Access Internet Publishing Provider Protocol Discovery

2004-02-02 Thread Dave Carabetta

Using the cferror tag on our site to catch problems, I occasionally get 
error e-mails from clients who are using Microsoft Data Access Internet 
Publishing Provider Protocol Discovery as their browser (from the 
Error.Browser variable). I've been doing some research as to exactly what 
this is and why CF would throw an error (we pass some URL variables to 
certain pages, and it looks like this Discovery thing changes the URL 
ampsersands and equal signs into their URLEncodedFormat() equivalent, hence 
kicking off an error). But the really crazy part is that I've gotten in 
touch with some of our clients who kick this error and they claim that 
they're getting their data with no errors.

A quick google search turns up that it's some sort of Front Page extension, 
but what's it used for? Some of the forum links that google points to 
suggest it's a hacking attempt, but I highly doubt that's what's going on 
based on analysis of our other log files. Should I put something in my code 
that blocks this Discovery thing? Is there a way for me to set this up 
internally to do some tests?

Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Simple UPDATE Stuff Driving Me Insane...

make sure ur formatting the dates correctly going into the date/time
fields of the db. access chokes if its empty or formatted wrong
99% of the time this is where that error message comes from



 Hi guys,

 I've got an update field where I'm. you guessed it, updating a table.

 I keep getting:

 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] Data type mismatch in criteria _expression_.

 My code is below:

 CFQUERY NAME=AgentDetails datasource=020
 UPDATE PropertyAgent
 SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
 PropertyAgentFlatNumberHouseName =
 '#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber =
 #Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
 '#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
 '#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
 '#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
 '#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
 '#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
 #Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
 '#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
 '#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
 #Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
 '#Form.PropertyAgentEmailAddress#'
 WHERE PropertyAgentID = #Client.PropertyAgentID#
 /CFQUERY

 My fields which are numbers are PropertyAgentStreetNumber,
 PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

 When I change PropertyAgentContactMobile to
 '#PropertyAgentContactMobile#' and correspondingly change the ACCESS
 field to TEXT... the update works fine... so it seems like this is the
 problem field as through tests, the others are fine.

 Any ideas, this is bizarre?The field attributes seem the same for
 PropertyAgentContactMobile as they are for the other numeric fields.



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

2004-02-02 Thread Nathan Mische

I would also recommend using CFQUERYPARAM.

cfquery name=AgentDetails datasource=020
UPDATE 
	PropertyAgent
SET 
	PropertyAgentCompanyName = cfqueryparam
value=#Form.PropertyAgentCompanyName# cfsqltype=CF_SQL_VARCHAR /,
	PropertyAgentFlatNumberHouseName = cfqueryparam
value=#Form.PropertyAgentFlatNumberHouseName#
cfsqltype=CF_SQL_VARCHAR /,
	PropertyAgentStreetNumber = cfqueryparam
value=#Form.PropertyAgentStreetNumber# cfsqltype=CF_SQL_NUMERIC /, 
	.
	.
	.
WHERE 
	PropertyAgentID = cfqueryparam value=#Client.PropertyAgentID#
cfsqltype=CF_SQL_NUMERIC /
/cfquery

HTH,

--Nathan
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Obtaining Request URL

2004-02-02 Thread MILAN MUSHRAN

Try a custom tag called verveCFGetURL on www.hotscripts.com

From: Jeremy Brodie [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re:Obtaining Request URL
Date: Mon, 02 Feb 2004 12:52:07 -0400

Jamie wrote: Unfortunately, we do Government work, so we can't rely on 
_javascript_.

Could you elaborate why? Every US Government contract I've worked on did 
not prohibit the use of _javascript_.

Also, could you elaborate what you are attempting to do? This way the group 
can figure out the best way of pulling the information you need for your 
application, as well as how you will be hosting your application (one 
server, many servers).

Jeremy Brodie
Edgewater Technology

web: http://www.edgewater.com
phone:(703) 815-2500
email: [EMAIL PROTECTED]

 Unfortunately, we do Government work, so we can't rely on _javascript_.

 So the answer's no? ;-)

 Jamie

 On Thu, 29 Jan 2004 14:25:07 -0500, in cf-talk you wrote:

 You could just use _javascript_. That way it wouldn't matter what version
 of CF you are using.

 Ben

 -Original Message-
 From: Jamie Jackson [mailto:[EMAIL PROTECTED]
 Sent: Thursday, January 29, 2004 1:59 PM
 To: CF-Talk
 Subject: Obtaining Request URL

 Just curious, is there a way to get the entire requested URL in CFMX?
 That is, *not* a manually pieced-together string of cgi vars?

 Thanks,
 Jamie

 _

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Simple UPDATE Stuff Driving Me Insane...

2004-02-02 Thread Stan Winchester

Another thing I would do is analyze at the results of the query in the actual error message before you use CFQUERYPARAM and see what values are actually being passed, though I agree you should use CFQUERYPARAM, but not during debugging. You may find you are passing a text string rather than a number. You might also try val(PropertyAgentContactMobile).

I would also recommend using CFQUERYPARAM.



cfquery name=AgentDetails datasource=020
UPDATE 
	PropertyAgent
SET 
	PropertyAgentCompanyName = cfqueryparam
value=#Form.PropertyAgentCompanyName# cfsqltype=CF_SQL_VARCHAR /,
	PropertyAgentFlatNumberHouseName = cfqueryparam
value=#Form.PropertyAgentFlatNumberHouseName#
cfsqltype=CF_SQL_VARCHAR /,
	PropertyAgentStreetNumber = cfqueryparam
value=#Form.PropertyAgentStreetNumber# cfsqltype=CF_SQL_NUMERIC /, 
	.
	.
	.
WHERE 
	PropertyAgentID = cfqueryparam value=#Client.PropertyAgentID#
cfsqltype=CF_SQL_NUMERIC /
/cfquery

HTH,

--Nathan
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

CF Outlook

2004-02-02 Thread Kelly Matthews

I have a cf application where people can register for events. When they register a vcs file is created to import the event into their outlook calendar.It works fine but we found something weird happening recently.There is an event scheduled for April 16th, the time is from 12:00 - 1:00 yet when the outlook file comes over it has it down as 1:00 - 2:00.All the other 12-1 events work fine and have the right time in outlook. I realized this must be happening because of daylight savings time.My question would be is there a way to avoid this? Had anyone run into this before? Just looking for an easy fix.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: cftransaction HELP Please...

2004-02-02 Thread Spectrum WebDesign

Why? Performance loss? Security?

- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
Date: Mon, 2 Feb 2004 14:14:18 +0100
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: cftransaction HELP Please...

It is possible, but I do not recommend. 

 -Original Message-
 From: Spectrum Web [mailto:[EMAIL PROTECTED] 
 Sent: maandag 2 februari 2004 10:19
 To: CF-Talk
 Subject: Re:cftransaction HELP Please...
 
 Right?? It's possible to insert another CF scripts inside 
 cftransaction tags? Do you recommend?
 
 Thanks once again
 
 
 This is possible. However, you have an error with your 
 cftransaction 
 tags. They ALWAYS require an end tag.
 
 cfif IsOK 
  cftransaction action="">
 cfelse 
  cftransaction action = "">
 
  -Original Message-
  From: Spectrum Web [mailto:[EMAIL PROTECTED]
  Sent: zondag 1 februari 2004 11:06
  To: CF-Talk
  Subject: Re:cftransaction HELP Please...
  
  Thanks James
  
  it's possible to insert pieces of scripts inside 
 cftransaction blocks?
  
  Like this:
  
  
  cfset IsOK = True
  cftransaction action="">
 cftry 
 cfquery to read from A 
 cfcatch 
  cfset IsOK = False 
 /cfcatch
 /cftry
  
  CFMAIL ...
  
 cfif IsOK 
 cftry 
  cfquery to save in B 
  cfcatch 
 cfset IsOK = False 
  /cfcatch 
 /cftry
  
  
  CFMAIL 
  
 cfif IsOK 
  cftry 
 cfquery to delete from A 
 cfcatch 
 cfset IsOK = False 
 /cfcatch 
  /cftry 
 /cfif
 /cfif
  
  
  CFMAIL...
  
 cfif IsOK 
 cftransaction action="" 
 cfelse 
 cftransaction action = "" 
 /cfif
  /cftransaction
  

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CF Outlook

2004-02-02 Thread Ian Skinner

Could it also be time zone.Maybe how that one event was set up, Outlook thinks it is for the next time zone over and is adjusting accordingly?

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 10:28 AM
To: CF-Talk
Subject: CF  Outlook

I have a cf application where people can register for events. When they register a vcs file is created to import the event into their outlook calendar.It works fine but we found something weird happening recently.There is an event scheduled for April 16th, the time is from 12:00 - 1:00 yet when the outlook file comes over it has it down as 1:00 - 2:00.All the other 12-1 events work fine and have the right time in outlook. I realized this must be happening because of daylight savings time.My question would be is there a way to avoid this? Had anyone run into this before? Just looking for an easy fix. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

SOT: Web server's www publishing service keeps shutting down

2004-02-02 Thread Earl, George

We are running CF 5.0 Enterprise on Windows 2003 Advanced Server with IIS
5.0. The server is a quad-processor (700MHz) with 4GB RAM and 2 NICs. 

We have a strange problem with our intranet site. On a fairly regular basis
the WWW Publishing service shuts down rendering the web server invisible so
that any http requests to the server return a 'Page cannot be displayed'
error message. Usually when this happens we cannot successfully ping the
server either, but sometimes we can. This problem seems to happen most on
days when we have a heavy load of traffic, which for us means about 60,000 -
80,000 page views between 7:00am - 6:00pm with about 30 - 40 concurrent
users. About a third of these page views are queries to Oracle and to DB2 on
OS/390. When this happened last week, about four hours before the service
stopped the number of concurrent users started to increase steadily till it
peaked at about 135 concurrent users, then it dropped straight down to the
expected 30 - 40 concurrent users (with no apparent effect on the server),
then two hours later the service stopped. We could find nothing in the CF
Admin logs nor in the Windows event log that indicated there was any problem
. . . Any ideas what might be causing this problem with the WWW Publishing
service?

Thanks!

George
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

Actually Robert, yeah you are probably right about that.I will change
them to text.But it still doesn't solve the very weird problem.

-Original Message-
From: Robert Redpath [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2004 18:37
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane... 

Shouldn't #Form.PropertyAgentStreetNumber# be a text datatype? What if
someone is 101A Main Street?

As well as #Form.PropertyAgentTelephoneNumber#.Shoudn't that be a text
datatype too? 555-555-1212 is text. As well as
#Form.PropertyAgentContactMobile#. 

And therefore use ' around your varsAccess seems to better
when
using ' sometimes. 

-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 1:19 PM
To: CF-Talk
Subject: Simple UPDATE Stuff Driving Me Insane... 

Hi guys,

I've got an update field where I'm. you guessed it, updating a table.

I keep getting:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Data type mismatch in criteria _expression_.

My code is below:

CFQUERY NAME=AgentDetails datasource=020
UPDATE PropertyAgent
SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
PropertyAgentFlatNumberHouseName =
'#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber =
#Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
'#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
'#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
'#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
'#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
'#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
#Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
'#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
'#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
#Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
'#Form.PropertyAgentEmailAddress#'
WHERE PropertyAgentID = #Client.PropertyAgentID#
/CFQUERY

My fields which are numbers are PropertyAgentStreetNumber,
PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

When I change PropertyAgentContactMobile to
'#PropertyAgentContactMobile#' and correspondingly change the ACCESS
field to TEXT... the update works fine... so it seems like this is the
problem field as through tests, the others are fine.

Any ideas, this is bizarre?The field attributes seem the same for
PropertyAgentContactMobile as they are for the other numeric fields. 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: cftransaction HELP Please...

2004-02-02 Thread Tom Kitta

Mainly performance loss, you don't want to hold a 'lock' on DB for too long.
Keep anything inside cftransaction tag to the minimum, especially don't
print long data results to the screen, or worse, do IO operations.

TK
-Original Message-
From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 2:30 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...

Why? Performance loss? Security?

- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
Date: Mon, 2 Feb 2004 14:14:18 +0100
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: cftransaction HELP Please...

It is possible, but I do not recommend.

 -Original Message-
 From: Spectrum Web [mailto:[EMAIL PROTECTED]
 Sent: maandag 2 februari 2004 10:19
 To: CF-Talk
 Subject: Re:cftransaction HELP Please...

 Right?? It's possible to insert another CF scripts inside
 cftransaction tags? Do you recommend?

 Thanks once again


 This is possible. However, you have an error with your
 cftransaction
 tags. They ALWAYS require an end tag.
 
 cfif IsOK
  cftransaction action="">
 cfelse
  cftransaction action = "">
 
  -Original Message-
  From: Spectrum Web [mailto:[EMAIL PROTECTED]
  Sent: zondag 1 februari 2004 11:06
  To: CF-Talk
  Subject: Re:cftransaction HELP Please...
 
  Thanks James
 
  it's possible to insert pieces of scripts inside
 cftransaction blocks?
 
  Like this:
 
 
  cfset IsOK = True
  cftransaction action="">
 cftry
 cfquery to read from A
 cfcatch
  cfset IsOK = False
 /cfcatch
 /cftry
 
  CFMAIL ...
 
 cfif IsOK
 cftry
  cfquery to save in B
  cfcatch
 cfset IsOK = False
  /cfcatch
 /cftry
 
 
  CFMAIL 
 
 cfif IsOK
  cftry
 cfquery to delete from A
 cfcatch
 cfset IsOK = False
 /cfcatch
  /cftry
 /cfif
 /cfif
 
 
  CFMAIL...
 
 cfif IsOK
 cftransaction action="">
 cfelse
 cftransaction action = "">
 /cfif
  /cftransaction
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

In my text field that the database received its info from is:

 
cfinput name=PropertyAgentContactMobile type=text
value=#AgentDetails.PropertyAgentContactMobile# size=25
maxlength=20 required=no class=formSTYLE2

 
Where it says type=text could I have put number?I have been
HTMLing for years but don't think I've ever seen number.??

-Original Message-
From: Stan Winchester [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2004 18:26
To: CF-Talk
Subject: Re:Simple UPDATE Stuff Driving Me Insane... 

 
Another thing I would do is analyze at the results of the query in the
actual error message before you use CFQUERYPARAM and see what values are
actually being passed, though I agree you should use CFQUERYPARAM, but
not during debugging. You may find you are passing a text string rather
than a number. You might also try val(PropertyAgentContactMobile).

I would also recommend using CFQUERYPARAM.



cfquery name=AgentDetails datasource=020
UPDATE 
 PropertyAgent
SET 
 PropertyAgentCompanyName = cfqueryparam
value=#Form.PropertyAgentCompanyName# cfsqltype=CF_SQL_VARCHAR /,
 PropertyAgentFlatNumberHouseName = cfqueryparam
value=#Form.PropertyAgentFlatNumberHouseName#
cfsqltype=CF_SQL_VARCHAR /,
 PropertyAgentStreetNumber = cfqueryparam
value=#Form.PropertyAgentStreetNumber# cfsqltype=CF_SQL_NUMERIC /,

 .
 .
 .
WHERE 
 PropertyAgentID = cfqueryparam value=#Client.PropertyAgentID#
cfsqltype=CF_SQL_NUMERIC /
/cfquery

HTH,

--Nathan
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

Maybe that could be part of the problem as there is a date field but it
only gets filled on the insert when the user first joins up.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2004 19:02
To: CF-Talk
Subject: Re: Simple UPDATE Stuff Driving Me Insane...

make sure ur formatting the dates correctly going into the date/time
fields of the db. access chokes if its empty or formatted wrong
99% of the time this is where that error message comes from

 Hi guys,

 I've got an update field where I'm. you guessed it, updating a table.

 I keep getting:

 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] Data type mismatch in criteria _expression_.

 My code is below:

 CFQUERY NAME=AgentDetails datasource=020
 UPDATE PropertyAgent
 SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
 PropertyAgentFlatNumberHouseName =
 '#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber =
 #Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
 '#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
 '#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
 '#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
 '#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
 '#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
 #Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
 '#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
 '#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
 #Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
 '#Form.PropertyAgentEmailAddress#'
 WHERE PropertyAgentID = #Client.PropertyAgentID#
 /CFQUERY

 My fields which are numbers are PropertyAgentStreetNumber,
 PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

 When I change PropertyAgentContactMobile to
 '#PropertyAgentContactMobile#' and correspondingly change the ACCESS
 field to TEXT... the update works fine... so it seems like this is the
 problem field as through tests, the others are fine.

 Any ideas, this is bizarre?The field attributes seem the same for
 PropertyAgentContactMobile as they are for the other numeric fields.

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

I've heard a lot about that cfqueryparam. why is it so important, what
does it do?

 
-Original Message-
From: Nathan Mische [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2004 19:04
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane... 

 
I would also recommend using CFQUERYPARAM.

cfquery name=AgentDetails datasource=020
UPDATE 
PropertyAgent
SET 
PropertyAgentCompanyName = cfqueryparam
value=#Form.PropertyAgentCompanyName# cfsqltype=CF_SQL_VARCHAR /,
PropertyAgentFlatNumberHouseName = cfqueryparam
value=#Form.PropertyAgentFlatNumberHouseName#
cfsqltype=CF_SQL_VARCHAR /,
PropertyAgentStreetNumber = cfqueryparam
value=#Form.PropertyAgentStreetNumber# cfsqltype=CF_SQL_NUMERIC /, 
.
.
.
WHERE 
PropertyAgentID = cfqueryparam value=#Client.PropertyAgentID#
cfsqltype=CF_SQL_NUMERIC /
/cfquery

HTH,

--Nathan
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Obtaining Request URL

Hi Jeremy,

You're right in that we can use JS, but as I wrote, we can't *rely* on
it. IOW, we have to have some failsafe way to accomplish the same task
if the user has JS turned off. This has to do with 508 compliance as
well as specific client requirements. (Besides AFAIK, JS could only
tell me where the user *was,* as opposed to where the user *is,*
right?)

There are some times when I would like to have the entire requested
URL. I can piece it together, for the most part, from various cgi
vars, but I don't know how to recreate it *exactly.* Say, for
instance, that I want to know if the URL contained a basic HTTP login,
or if it did or didn't specify a port.

This is more of an academic question (since I have working, albeit
imperfect, workarounds): Is there a natural, server-side way to get
the requested URL in CFMX? (A yes or no answer would be fine ;-)

Thanks,
Jamie

On Mon, 02 Feb 2004 12:52:07 -0400, in cf-talk you wrote:

Jamie wrote: Unfortunately, we do Government work, so we can't rely on _javascript_.

Could you elaborate why? Every US Government contract I've worked on did not prohibit the use of _javascript_.

Also, could you elaborate what you are attempting to do? This way the group can figure out the best way of pulling the information you need for your application, as well as how you will be hosting your application (one server, many servers).



Jeremy Brodie
Edgewater Technology

web: http://www.edgewater.com
phone:(703) 815-2500
email: [EMAIL PROTECTED]


Unfortunately, we do Government work, so we can't rely on _javascript_.

So the answer's no? ;-)

Jamie

On Thu, 29 Jan 2004 14:25:07 -0500, in cf-talk you wrote:

You could just use _javascript_. That way it wouldn't matter what version
of CF you are using.

 

Ben

 

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 29, 2004 1:59 PM
To: CF-Talk
Subject: Obtaining Request URL

 

Just curious, is there a way to get the entire requested URL in CFMX?
That is, *not* a manually pieced-together string of cgi vars?

Thanks,
Jamie

_




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Obtaining Request URL

On Mon, 02 Feb 2004 19:06:28 +, in cf-talk you wrote:

Try a custom tag called verveCFGetURL on www.hotscripts.com

Hi Milan,

Thanks for the reply, but this is actually less robust than mine,
since it doesn't consider those less-often used URL bits (e.g. port).
It only considers the server name and the query string.

Thanks,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: SOT: Web server's www publishing service keeps shutting down

2004-02-02 Thread Mike Brunt

George, when you say IIS shuts down does it literally show as stopped in the Services running list. Also do you have to manually restart it?

Kind Regards - Mike Brunt

Original Message ---
We are running CF 5.0 Enterprise on Windows 2003 Advanced Server with IIS
5.0. The server is a quad-processor (700MHz) with 4GB RAM and 2 NICs.

We have a strange problem with our intranet site. On a fairly regular basis
the WWW Publishing service shuts down rendering the web server invisible so
that any http requests to the server return a 'Page cannot be displayed'
error message. Usually when this happens we cannot successfully ping the
server either, but sometimes we can. This problem seems to happen most on
days when we have a heavy load of traffic, which for us means about 60,000 -
80,000 page views between 7:00am - 6:00pm with about 30 - 40 concurrent
users. About a third of these page views are queries to Oracle and to DB2 on
OS/390. When this happened last week, about four hours before the service
stopped the number of concurrent users started to increase steadily till it
peaked at about 135 concurrent users, then it dropped straight down to the
expected 30 - 40 concurrent users (with no apparent effect on the server),
then two hours later the service stopped. We could find nothing in the CF
Admin logs nor in the Windows event log that indicated there was any problem
. . . Any ideas what might be causing this problem with the WWW Publishing
service?

Thanks!

George
[EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

well there is your answer, you are trying to put an empty value in that
date field and its throwing an error, i guarantee it. if i am wrong tony
will pay u $100;)

 Maybe that could be part of the problem as there is a date field but it
 only gets filled on the insert when the user first joins up.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: 02 February 2004 19:02
 To: CF-Talk
 Subject: Re: Simple UPDATE Stuff Driving Me Insane...

 make sure ur formatting the dates correctly going into the date/time
 fields of the db. access chokes if its empty or formatted wrong
 99% of the time this is where that error message comes from



 Hi guys,

 I've got an update field where I'm. you guessed it, updating a table.

 I keep getting:

 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] Data type mismatch in criteria _expression_.

 My code is below:

 CFQUERY NAME=AgentDetails datasource=020
 UPDATE PropertyAgent
 SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
 PropertyAgentFlatNumberHouseName =
 '#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber =
 #Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
 '#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
 '#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
 '#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
 '#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
 '#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
 #Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
 '#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
 '#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
 #Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
 '#Form.PropertyAgentEmailAddress#'
 WHERE PropertyAgentID = #Client.PropertyAgentID#
 /CFQUERY

 My fields which are numbers are PropertyAgentStreetNumber,
 PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

 When I change PropertyAgentContactMobile to
 '#PropertyAgentContactMobile#' and correspondingly change the ACCESS
 field to TEXT... the update works fine... so it seems like this is the
 problem field as through tests, the others are fine.

 Any ideas, this is bizarre?The field attributes seem the same for
 PropertyAgentContactMobile as they are for the other numeric fields.



_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

2004-02-02 Thread Dave Watts

 I've heard a lot about that cfqueryparam. why is it so important, 
 what does it do?

This should answer some of your questions:

http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

here u go straight from the mothership

Error '80040e07' - Data type mismatch in criteria _expression_

Issue
The SQL error 80040E07 occurs when attempting to use the Insert Record
or the Update Record server behavior to set the value of a column in
Microsoft Access with an empty string ().

Reason
MS Access is characterized by strong data typing; it imposes a rigorous
set of rules on given column values. The empty string value in the command
text (SQL) cannot be stored in MS Access' Date/Time data type specified
by the associated column.

Solution
This is a known issue and Macromedia's Engineers are aware of it.
Currently, the only known work around available is to avoid inserting
and/or updating columns of Date/Time data types in Access with empty
strings, () or with any other value that does not correspond to the
range of values specified for the data type

i dont know crap but i nailed this one :)





 Maybe that could be part of the problem as there is a date field but it
 only gets filled on the insert when the user first joins up.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: 02 February 2004 19:02
 To: CF-Talk
 Subject: Re: Simple UPDATE Stuff Driving Me Insane...

 make sure ur formatting the dates correctly going into the date/time
 fields of the db. access chokes if its empty or formatted wrong
 99% of the time this is where that error message comes from



 Hi guys,

 I've got an update field where I'm. you guessed it, updating a table.

 I keep getting:

 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] Data type mismatch in criteria _expression_.

 My code is below:

 CFQUERY NAME=AgentDetails datasource=020
 UPDATE PropertyAgent
 SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
 PropertyAgentFlatNumberHouseName =
 '#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber =
 #Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
 '#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
 '#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
 '#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
 '#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
 '#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
 #Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
 '#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
 '#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
 #Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
 '#Form.PropertyAgentEmailAddress#'
 WHERE PropertyAgentID = #Client.PropertyAgentID#
 /CFQUERY

 My fields which are numbers are PropertyAgentStreetNumber,
 PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

 When I change PropertyAgentContactMobile to
 '#PropertyAgentContactMobile#' and correspondingly change the ACCESS
 field to TEXT... the update works fine... so it seems like this is the
 problem field as through tests, the others are fine.

 Any ideas, this is bizarre?The field attributes seem the same for
 PropertyAgentContactMobile as they are for the other numeric fields.



_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Obtaining Request URL

2004-02-02 Thread Dave Watts

 This is more of an academic question (since I have working, albeit
 imperfect, workarounds): Is there a natural, server-side way to get
 the requested URL in CFMX? (A yes or no answer would be fine ;-)

To the best of my knowledge, there's no single variable available within
CFMX that contains the entire URL as requested by the user. However, as you
mentioned, every portion of the URL is available from specific CGI
variables.

It's worth pointing out that the browser never sends the entire URL within
its request to the server. For example, if you request the URL
http://www.foo.com/bar.cfm?baz=bat, the browser would ask the OS to resolve
the IP address for www.foo.com, then open a connection on port 80 to that IP
address, sending a request like this:

GET /bar.cfm?baz=bat
Host: www.foo.com
...

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

OT: IIS Headaches

2004-02-02 Thread David Keevil

Just finished a routine installation of IIS under WINXP-PRO but the results are anything but routine. Any attempt to access anything under http://127.0.0.1/ from the local machine triggers a Windows login prompt for a Username  Password. Any help in resolving this issue would be much appreciated. TIA.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

2004-02-02 Thread Nathan Mische

I agree you should use CFQUERYPARAM, but not during debugging

Interesting. I find using CFQUERYPARAM makes debugging easier as it
generates very clear error messages such as:

 
Error Executing Database Query.
Invalid data 123-456-7890 for CFSQLTYPE CF_SQL_NUMERIC.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: IIS Headaches

2004-02-02 Thread Schuster, Steven

Just turn on Anonymous Access in the properties under IIS

-Original Message-
From: David Keevil [mailto:[EMAIL PROTECTED] 
Sent: Monday, February 02, 2004 2:20 PM
To: CF-Talk
Subject: OT: IIS Headaches

Just finished a routine installation of IIS under WINXP-PRO but the results
are anything but routine. Any attempt to access anything under
http://127.0.0.1/ http://127.0.0.1/from the local machine triggers a
Windows login prompt for a Username  Password. Any help in resolving this
issue would be much appreciated. TIA.

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: IIS Headaches

2004-02-02 Thread DURETTE, STEVEN J (AIT)

David,

 
IIS tends to set integrated authentication on by default.Go into your iis
website properties and make sure that only anonymous is checked under
authentication.

 
Steve

-Original Message-
From: David Keevil [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 2:20 PM
To: CF-Talk
Subject: OT: IIS Headaches

Just finished a routine installation of IIS under WINXP-PRO but the results
are anything but routine. Any attempt to access anything under
http://127.0.0.1/ http://127.0.0.1/from the local machine triggers a
Windows login prompt for a Username  Password. Any help in resolving this
issue would be much appreciated. TIA. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

2004-02-02 Thread Ian Skinner

Nope, just don't update it.You only need to update the fields you want to change, just ignore any you want to leave alone, so remove that line from SQL statement.

-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 12:36 PM
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane...

So even though I am not putting that into my UPDATE statement it still
needs something in there?What if I don't want to put something in
there. the date field is when they signed up.I don't want to change
it. does that mean I have to read it on the previous form (as hidden
text field) and then update it?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2004 20:18
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane...

well there is your answer, you are trying to put an empty value in that
date field and its throwing an error, i guarantee it. if i am wrong tony
will pay u $100;)

 Maybe that could be part of the problem as there is a date field but
it
 only gets filled on the insert when the user first joins up.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: 02 February 2004 19:02
 To: CF-Talk
 Subject: Re: Simple UPDATE Stuff Driving Me Insane...

 make sure ur formatting the dates correctly going into the date/time
 fields of the db. access chokes if its empty or formatted wrong
 99% of the time this is where that error message comes from



 Hi guys,

 I've got an update field where I'm. you guessed it, updating a table.

 I keep getting:

 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] Data type mismatch in criteria _expression_.

 My code is below:

 CFQUERY NAME=AgentDetails datasource=020
 UPDATE PropertyAgent
 SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
 PropertyAgentFlatNumberHouseName =
 '#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber
=
 #Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
 '#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
 '#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
 '#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
 '#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
 '#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
 #Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
 '#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
 '#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
 #Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
 '#Form.PropertyAgentEmailAddress#'
 WHERE PropertyAgentID = #Client.PropertyAgentID#
 /CFQUERY

 My fields which are numbers are PropertyAgentStreetNumber,
 PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

 When I change PropertyAgentContactMobile to
 '#PropertyAgentContactMobile#' and correspondingly change the ACCESS
 field to TEXT... the update works fine... so it seems like this is
the
 problem field as through tests, the others are fine.

 Any ideas, this is bizarre?The field attributes seem the same for
 PropertyAgentContactMobile as they are for the other numeric fields.



_



_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

2004-02-02 Thread Jerry Johnson

Can you send us an example of the exact info entered for the mobile number on the form that throws an error?

It may be that the data being entered for the mobile number is having a hard time being wedged into a NUMERIC field.

Jerry Johnson

 [EMAIL PROTECTED] 02/02/04 03:35PM 
So even though I am not putting that into my UPDATE statement it still
needs something in there?What if I don't want to put something in
there. the date field is when they signed up.I don't want to change
it. does that mean I have to read it on the previous form (as hidden
text field) and then update it?

 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2004 20:18
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane...

 
well there is your answer, you are trying to put an empty value in that
date field and its throwing an error, i guarantee it. if i am wrong tony
will pay u $100;)

 Maybe that could be part of the problem as there is a date field but
it
 only gets filled on the insert when the user first joins up.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: 02 February 2004 19:02
 To: CF-Talk
 Subject: Re: Simple UPDATE Stuff Driving Me Insane...

 make sure ur formatting the dates correctly going into the date/time
 fields of the db. access chokes if its empty or formatted wrong
 99% of the time this is where that error message comes from



 Hi guys,

 I've got an update field where I'm. you guessed it, updating a table.

 I keep getting:

 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] Data type mismatch in criteria _expression_.

 My code is below:

 CFQUERY NAME=AgentDetails datasource=020
 UPDATE PropertyAgent
 SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
 PropertyAgentFlatNumberHouseName =
 '#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber
=
 #Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
 '#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
 '#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
 '#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
 '#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
 '#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
 #Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
 '#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
 '#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
 #Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
 '#Form.PropertyAgentEmailAddress#'
 WHERE PropertyAgentID = #Client.PropertyAgentID#
 /CFQUERY

 My fields which are numbers are PropertyAgentStreetNumber,
 PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

 When I change PropertyAgentContactMobile to
 '#PropertyAgentContactMobile#' and correspondingly change the ACCESS
 field to TEXT... the update works fine... so it seems like this is
the
 problem field as through tests, the others are fine.

 Any ideas, this is bizarre?The field attributes seem the same for
 PropertyAgentContactMobile as they are for the other numeric fields.



_



_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: SOT: Web server's www publishing service keeps shutting down

2004-02-02 Thread Won Lee

At 02:40 PM 2/2/2004 -0500, you wrote:
We are running CF 5.0 Enterprise on Windows 2003 Advanced Server with IIS
5.0. The server is a quad-processor (700MHz) with 4GB RAM and 2 NICs.

What do you use for a DB?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re:Obtaining Request URL

2004-02-02 Thread Jeremy Brodie

Jamie,

See answers below

Hi Jeremy,

Jamie worte: You're right in that we can use JS, but as I wrote, we can't *rely* on it. IOW, we have to have some failsafe way to accomplish the same task if the user has JS turned off. This has to do with 508 compliance as well as specific client requirements.

I understand the need to make sure applications work without the use of _javascript_.However, this client requirement has nothing to do with Section 508! For a long (informative and technical) discussion on this subject see
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=29850forumid=4count=47.

(Besides AFAIK, JS could only
tell me where the user *was,* as opposed to where the user *is,*
right?)

Jamie wrote:
There are some times when I would like to have the entire requested
URL. I can piece it together, for the most part, from various cgi
vars, but I don't know how to recreate it *exactly.*

See Dave Watts's response on how web server headers are created. Remember too that CGI varaibles are varables available from Cold Fusion from the webserver. If you're using IIS the right combination would be
#cgi.url#?#cgi.query_string# (these can differ depending on your webserver). While we're on the subject, you might want to turn on debugging on your development server as well so you can see everything being passed to the CF application.

Jamie wrote: Say, for
instance, that I want to know if the URL contained a basic HTTP login,
or if it did or didn't specify a port.

Depending on your webserver CGI.Server_port will provide the port number of the request.

Could you tell me if I'm reading you correctly? Do you mean you're passing login information through a url variable?

Jeremy Brodie
Edgewater Technology

web: http://www.edgewater.com
phone:(703) 815-2500
email: [EMAIL PROTECTED]

On Mon, 02 Feb 2004 12:52:07 -0400, in cf-talk you wrote:

Jamie wrote: Unfortunately, we do Government work, so we can't rely
on _javascript_.

Could you elaborate why? Every US Government contract I've worked on
did not prohibit the use of _javascript_.

Also, could you elaborate what you are attempting to do? This way the
group can figure out the best way of pulling the information you need
for your application, as well as how you will be hosting your
application (one server, many servers).

Jeremy Brodie
Edgewater Technology

web: http://www.edgewater.com
phone:(703) 815-2500
email: [EMAIL PROTECTED]

Unfortunately, we do Government work, so we can't rely on _javascript_.

So the answer's no? ;-)

Jamie

On Thu, 29 Jan 2004 14:25:07 -0500, in cf-talk you wrote:

You could just use _javascript_. That way it wouldn't matter what
version
of CF you are using.

Ben

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:59 PM
To: CF-Talk
Subject: Obtaining Request URL

Just curious, is there a way to get the entire requested URL in
CFMX?
That is, *not* a manually pieced-together string of cgi vars?

Thanks,
Jamie

[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]

Better way to deal with corrupted Verity (spider) collections?

Once the following happens, I usually have to start everything from
scratch (delete collection from filesystem and start from square one).
Is there an easier way to recover from this?

Thanks,
Jamie

C:\WINNT\system32SET path=c:\cfusion\verity\_nti40\bin\ 

C:\WINNT\system32vspider -cmdfile
d:\websites\nccanch\admin\VerityK2Spider\spider_purge.txt 
vspider - Verity, Inc. Version 3.7 (_nti40, Aug 11 2000)
Info2004/02/02 16:11:19 (ind006000) Message database loaded from
[c:\cfusion\verity\_nti40\bin\ind.msg].
Info2004/02/02 16:11:19 (ind012207) Last indexing job was
interrupted 9 time(s).Running in auto-restart mode.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: IIS Headaches

2004-02-02 Thread Stefan Salzbrunn

Also make sure that the Account used for anonymous access has the correct
rights to all directories you are using... This might include the coldfusion
dirs.

Stefan

Dr. Stefan Salzbrunn
Geschftsfhrer

InterLake - The Web Enabler
FriedrichshafenMnchenBerlinNew York

InterLake Informationssysteme GmbH
Postfach 2269
D-88012 Friedrichshafen
Tel 0800 555 1010 (Intl.+49 89 53886562)
Fax 0800 555 1011 (Intl.+49 89 53886573)
E-Mail [EMAIL PROTECTED]
www.interlake.netwww.moremx.comwww.shadomx.com


 -Original Message-
 From: David Keevil [mailto:[EMAIL PROTECTED] 
 Sent: Monday, February 02, 2004 14:20
 To: CF-Talk
 Subject: OT: IIS Headaches
 
 Just finished a routine installation of IIS under WINXP-PRO 
 but the results are anything but routine. Any attempt to 
 access anything under http://127.0.0.1/ from the local 
 machine triggers a Windows login prompt for a Username  
 Password. Any help in resolving this issue would be much 
 appreciated. TIA.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: SOT: Web server's www publishing service keeps shutting down

IS CF5.0 even supposed to run under Win2003? CFMX wouldn't until version
6.1.

Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609

Tel: (02) 62115927


 Won Lee 
 [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] 
cc: 
 03/02/2004 08:08Subject:Re: SOT: Web server's www publishing service keeps shutting down
 Please respond to
 cf-talk 
 |
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: CF Outlook

One of the machines is set on daylight savings time?

Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609

Tel: (02) 62115927


 Kelly Matthews
 [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] 
 gcc: 
Subject:CF  Outlook
 03/02/2004 05:27 
 Please respond to
 cf-talk|
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Obtaining Request URL

On Mon, 2 Feb 2004 15:27:16 -0500, in cf-talk you wrote:

 This is more of an academic question (since I have working, albeit
 imperfect, workarounds): Is there a natural, server-side way to get
 the requested URL in CFMX? (A yes or no answer would be fine ;-)

To the best of my knowledge, there's no single variable available within
CFMX that contains the entire URL as requested by the user. However, as you
mentioned, every portion of the URL is available from specific CGI
variables.

It's worth pointing out that the browser never sends the entire URL within
its request to the server. For example, if you request the URL
http://www.foo.com/bar.cfm?baz=bat, the browser would ask the OS to resolve
the IP address for www.foo.com, then open a connection on port 80 to that IP
address, sending a request like this:

Ahh, right. I should have known this, as I've done telnet HTTP
requests before. Therefore I think you're right, and the answer is
necessarily no, since the port, for instance, *is* always explicitly
declared, whether it be by the user or by the client. Thanks for
getting to the crux of the matter.

Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Any ideas??

Are you using ColdFusion's own CreateUUID() functions? These are not valid
MSSQL UUID's. You need something like the MSSQLCreateUUID() UDF at
http://www.cflib.org/udf.cfm?ID=512.

Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609

Tel: (02) 62115927


 [EMAIL PROTECTED]
 com CF-TalkTo: CF-Talk [EMAIL PROTECTED] 
cc: 
 02/02/2004 22:36Subject:Any ideas?? 
 Please respond to
 cf-talk 
 |
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: CF Outlook

2004-02-02 Thread Andy Ousterhout

Kelly,

If this is an application that you can share, I'd love to see how you create
the vcs file.

Andy
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, February 02, 2004 12:28 PM
To: CF-Talk
Subject: CF  Outlook

I have a cf application where people can register for events. When they
register a vcs file is created to import the event into their outlook
calendar.It works fine but we found something weird happening recently.
There is an event scheduled for April 16th, the time is from 12:00 - 1:00 yet
when the outlook file comes over it has it down as 1:00 - 2:00.All the other
12-1 events work fine and have the right time in outlook. I realized this must
be happening because of daylight savings time.My question would be is there
a way to avoid this? Had anyone run into this before? Just looking for an easy
fix.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Content Editor for the web

2004-02-02 Thread Michael Hodgdon

I am curious to find out peoples experiences with any content editors on the market.We are thinking about integrating eWebEditPro but wanted to know other options before committing.

Anyone care to share?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Simple UPDATE Stuff Driving Me Insane...

So even though I am not putting that into my UPDATE statement it still
needs something in there?What if I don't want to put something in
there. the date field is when they signed up.I don't want to change
it. does that mean I have to read it on the previous form (as hidden
text field) and then update it?

 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 02 February 2004 20:18
To: CF-Talk
Subject: RE: Simple UPDATE Stuff Driving Me Insane...

 
well there is your answer, you are trying to put an empty value in that
date field and its throwing an error, i guarantee it. if i am wrong tony
will pay u $100;)

 Maybe that could be part of the problem as there is a date field but
it
 only gets filled on the insert when the user first joins up.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: 02 February 2004 19:02
 To: CF-Talk
 Subject: Re: Simple UPDATE Stuff Driving Me Insane...

 make sure ur formatting the dates correctly going into the date/time
 fields of the db. access chokes if its empty or formatted wrong
 99% of the time this is where that error message comes from



 Hi guys,

 I've got an update field where I'm. you guessed it, updating a table.

 I keep getting:

 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
 Microsoft Access Driver] Data type mismatch in criteria _expression_.

 My code is below:

 CFQUERY NAME=AgentDetails datasource=020
 UPDATE PropertyAgent
 SET PropertyAgentCompanyName = '#Form.PropertyAgentCompanyName#',
 PropertyAgentFlatNumberHouseName =
 '#Form.PropertyAgentFlatNumberHouseName#', PropertyAgentStreetNumber
=
 #Form.PropertyAgentStreetNumber#, PropertyAgentStreetName =
 '#Form.PropertyAgentStreetName#', PropertyAgentVillageTown =
 '#Form.PropertyAgentVillageTown#', PropertyAgentCountyState =
 '#Form.PropertyAgentCountyState#', PropertyAgentPostcodeZip =
 '#Form.PropertyAgentPostcodeZip#', PropertyAgentCountry =
 '#Form.PropertyAgentCountry#', PropertyAgentTelephoneNumber =
 #Form.PropertyAgentTelephoneNumber#, PropertyAgentContactFirstName =
 '#Form.PropertyAgentContactFirstName#', PropertyAgentContactSurname =
 '#Form.PropertyAgentContactSurname#', PropertyAgentContactMobile =
 #Form.PropertyAgentContactMobile#, PropertyAgentEmailAddress =
 '#Form.PropertyAgentEmailAddress#'
 WHERE PropertyAgentID = #Client.PropertyAgentID#
 /CFQUERY

 My fields which are numbers are PropertyAgentStreetNumber,
 PropertyAgentTelephoneNumber, PropertyAgentContactMobile.

 When I change PropertyAgentContactMobile to
 '#PropertyAgentContactMobile#' and correspondingly change the ACCESS
 field to TEXT... the update works fine... so it seems like this is
the
 problem field as through tests, the others are fine.

 Any ideas, this is bizarre?The field attributes seem the same for
 PropertyAgentContactMobile as they are for the other numeric fields.



_



_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Content Editor for the web

2004-02-02 Thread Barney Boisvert

I've had less than stellar luck with eWebEditPro.I've had better luck with
soEditor.Neither runs on a Mac, though eWeb does support Netscape.I just
ran across KTML (http://www.interakt.ro/products/KTML/) this weekend, and it
seems like it might be a good option IE6+ or Mozilla 1.4+, and it'll run on
Mac or Windows.No Safari support, but oh well.

Cheers,
barneyb 

 -Original Message-
 From: Michael Hodgdon [mailto:[EMAIL PROTECTED] 
 Sent: Monday, February 02, 2004 1:57 PM
 To: CF-Talk
 Subject: Content Editor for the web
 
 I am curious to find out peoples experiences with any content 
 editors on the market.We are thinking about integrating 
 eWebEditPro but wanted to know other options before committing.
 
 
 Anyone care to share?
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

[Stats] CF-Talk: January 2004

2004-02-02 Thread Bill Doerrfeld

Searchable archives for this list are available at
http://www.listsearch.com/cf-talk.lasso

CF-Talk Stats
January, 2004

Note: Up/Down % as compared with December, 2003

Posts:3182 (Up 11%)
Authors: 392 (Up9%)
Threads: 678 (Up 19%)

Top 20 Contributors by Number of Posts

Dave Watts125
Jochem van Dieten107
Tony Weeg80
Bryan F. Hogan74
Matt Liotta71
Thomas Chiverton 66
Raymond Camden62
Bryan Stevenson59
Matt Robertson45
Schuster, Steven 45
Rob Rohan44
Taco Fleur 42
Spectrum WebDesign41
Philip Arnold 38
Mickael 36
Barney Boisvert34
Burns, John33
Christian Cantrell32
Ubqtous 32
Katz, Dov B (IT29

Top 20 Threads by Number of Posts

CFMX 'bug'?Easy to crash CFMAIL. 50
CFDJ isn't exactly kicking bootay45
Section 50845
CFPOP and bounced mail 30
Cold Fusion Web Developer/Programmer Position - Kansas City Area 29
real quick ot 29
Password Logic27
Create PDF (without CFEXECUTE)26
CF Start a process - don't wait for it to finish25
Flash Remoting with Blue Dragon 24
Partitioning Custom Tags for multiple code lines? 24
CFFunction Question 22
Images - store in DB or filesystem?22
session management help please22
Flashpaper Macromedia - Please21
Fancy a ColdFusion Challenge?20
How to model all in a many-to-many20
CMS Solutions (Friendly URL's)19
Create table ID field19
CFCACHE parts of pages without cfhttp 18

Top 20 Search Terms by Number of Requests

cf-community1
install1
--
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Content Editor for the web

2004-02-02 Thread Massimo, Tiziana e Federica

 wanted to know other options before committing.

http://www.fredck.com/FCKeditor/

http://www.cfmentor.com/code/index.cfm?action="">

If you use DW this can be worth too:

http://www.massimocorner.com/beta/cf.htm


Massimo Foti
http://www.massimocorner.com

Co-Author of Dreamweaver MX 2004 Magic:
http://www.dwmagic.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Content Editor for the web

Or FCK Editor (Free) from http://www.fredck.com/FCKeditor/

and ActivEdit from http://www.cfdev.com/

Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609

Tel: (02) 62115927


 Barney Boisvert
 [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] 
 ntral.comcc: 
Subject:RE: Content Editor for the web
 03/02/2004 09:06 
 Please respond to
 cf-talk|
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Content Editor for the web

2004-02-02 Thread Rob Rohan

Well in their defense Safari is not done. Meaning some features wont
work quite right. I found this out when trying to write a java html
editor (http://www.rohanclan.com/products/openHTMLeditor.cfm if you want
to see - the source part is the best :-D ) and found that you can't
script between applets and _javascript_ with Safari - yet.

I am dieing for them to finish it so I can re-start that project.

Anyway, point is - you might have problems getting safari compatibility
until apple says its done.

cheers

On Mon, 2004-02-02 at 14:06, Barney Boisvert wrote:
 I've had less than stellar luck with eWebEditPro.I've had better luck with
 soEditor.Neither runs on a Mac, though eWeb does support Netscape.I just
 ran across KTML (http://www.interakt.ro/products/KTML/) this weekend, and it
 seems like it might be a good option IE6+ or Mozilla 1.4+, and it'll run on
 Mac or Windows.No Safari support, but oh well.
 
 Cheers,
 barneyb 
 
  -Original Message-
  From: Michael Hodgdon [mailto:[EMAIL PROTECTED] 
  Sent: Monday, February 02, 2004 1:57 PM
  To: CF-Talk
  Subject: Content Editor for the web
  
  I am curious to find out peoples experiences with any content 
  editors on the market.We are thinking about integrating 
  eWebEditPro but wanted to know other options before committing.
  
  
  Anyone care to share?
  
  
  

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Obtaining Request URL

Hi Jeremy,

On Mon, 02 Feb 2004 16:17:30 -0400, in cf-talk you wrote:

I understand the need to make sure applications work without
the use of _javascript_. However, this client requirement has
nothing to do with Section 508!

Okay, instead of using the phrase section 508, I should have written
usable by people with visual impairments. If there is complicated,
JS-reliant, inaccessible functionality, then I need to back it up with
something that is accessible.

#cgi.url#?#cgi.query_string# (these can differ depending on your
webserver). While we're on the subject, you might want to turn on
debugging on your development server as well so you can see
everything being passed to the CF application.

Right, but this is pieced together. I wanted to know if there was a
way to get the precise URL that was typed or linked to, but Dave Watts
explained that it's impossible. My question is answered. For instance,
there is no server-side way to differentiate between a request for
http://foo.bar.com:80/index.cfm and http://foo.bar.com/index.cfm.

Thanks,
Jamie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Content Editor for the web

2004-02-02 Thread Barney Boisvert

Interesting.I didn't know that.Though KTML certainly isn't java, I
wonder what they're using.

 -Original Message-
 From: Rob Rohan [mailto:[EMAIL PROTECTED] 
 Sent: Monday, February 02, 2004 2:26 PM
 To: CF-Talk
 Subject: RE: Content Editor for the web

 Well in their defense Safari is not done. Meaning some features wont
 work quite right. I found this out when trying to write a java html
 editor (http://www.rohanclan.com/products/openHTMLeditor.cfm 
 if you want
 to see - the source part is the best :-D ) and found that you can't
 script between applets and _javascript_ with Safari - yet.

 I am dieing for them to finish it so I can re-start that project.

 Anyway, point is - you might have problems getting safari 
 compatibility
 until apple says its done.

 cheers

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Content Editor for the web

2004-02-02 Thread Rob Rohan

On Mon, 2004-02-02 at 14:37, Barney Boisvert wrote:
 Interesting.I didn't know that.Though KTML certainly isn't java, I
 wonder what they're using.

Well whatever it is it doesn't work on linux + mozilla I go there and
get a plain textarea that says KTML safe mode - if that helps ya any.

(Someone is gonna make a mint if they can come up with a full featured
flash one)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Content Editor for the web

2004-02-02 Thread Michael Hodgdon

Hi Barney, what were some of the problems you have had with eWebEditPro?Were they mainly client interface issues or were you unsattisfied with the HTML that is generated?

Michael S Hodgdon
Web Development Project Manager
617 - 669 - 7183
[EMAIL PROTECTED]
- Original Message - 
From: Barney Boisvert 
To: CF-Talk 
Sent: Monday, February 02, 2004 5:06 PM
Subject: RE: Content Editor for the web

I've had less than stellar luck with eWebEditPro.I've had better luck with
soEditor.Neither runs on a Mac, though eWeb does support Netscape.I just
ran across KTML (http://www.interakt.ro/products/KTML/) this weekend, and it
seems like it might be a good option IE6+ or Mozilla 1.4+, and it'll run on
Mac or Windows.No Safari support, but oh well.

Cheers,
barneyb 

 -Original Message-
 From: Michael Hodgdon [mailto:[EMAIL PROTECTED] 
 Sent: Monday, February 02, 2004 1:57 PM
 To: CF-Talk
 Subject: Content Editor for the web

 I am curious to find out peoples experiences with any content 
 editors on the market.We are thinking about integrating 
 eWebEditPro but wanted to know other options before committing.

 Anyone care to share?

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Content Editor for the web