Why CFHTTP not post if data come from multi-part form?

2001-12-15 Thread one

Confucious say: "Why CFHTTP not post if data come from multi-part form?"


I have a CFHTTP script which executes perfectly if all the data submitted to
it comes from only one form page.

However if the data comes from a page that is the result of a multi-page
form, for some reason it doesn't execute and post properly.

Any idea what could be causing that. Same fields are present on the final
page in both cases. I even put them on there in the same order, but no luck.

It only will execute if the form is one page, and that doesn't make any
sense. Appreciate any insights into this mystery, as perplexing perhaps as
the Bermuda Triangle.
~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOXML xmlToDom

2001-12-15 Thread Fred Anderson

Well, my File is rather large, minimum 1mb.
Would You Still like me to Mail it out?
Thanks, Fred


-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, December 15, 2001 8:31 PM
To: CF-Talk
Subject: RE: SOXML xmlToDom

Also as a side note, you may want to consider using the MS XML parser
yourself instead of SoXML. In an application I did, with a 200k XML
file, it would take a minute or more to parse with soxml and a few
seconds just using the MSxml parser directly.

J.

 
 
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
 
www.red-omega.com
 
"With your shield or on it."
 
Spartan mothers would say this to their sons going to battle. It was
believed that if you turned to run you'd drop your shield.. If you died
in combat your comrades would carry your body home on your shield. So
coming home with it or on it were the only options. 


-Original Message-
From: Fred Anderson [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, December 15, 2001 10:02 PM
To: CF-Talk
Subject: SOXML xmlToDom


While using CF_SOXML xmltoDOM to parse some XML I am having the
following issue. When trying to retrieve a node it is giving back all
the nodes at that level through the site; here is an example.
 
Shelf
-Book
--Author
--Author
--Author
-Book
--Author
--Author
-Book
--Author
--Author
--Author
--Author
Shelf
-Book
--Author
--Author
--Author
-Book
--Author
--Author
-Book
--Author
--Author
--Author
--Author
 
So I looping over shelves then looping over books, then Authors
 
Well it appears to be returning all of the authors in the first Loop.
 
Does anyone have any suggestions?
Thanks, Fred
 



~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOXML xmlToDom

2001-12-15 Thread John Wilker

Can you send what the XML looks like?

J.

 
 
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
 
www.red-omega.com
 
"With your shield or on it."
 
Spartan mothers would say this to their sons going to battle. It was
believed that if you turned to run you'd drop your shield.. If you died
in combat your comrades would carry your body home on your shield. So
coming home with it or on it were the only options. 


-Original Message-
From: Fred Anderson [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, December 15, 2001 10:02 PM
To: CF-Talk
Subject: SOXML xmlToDom


While using CF_SOXML xmltoDOM to parse some XML I am having the
following issue. When trying to retrieve a node it is giving back all
the nodes at that level through the site; here is an example.
 
Shelf
-Book
--Author
--Author
--Author
-Book
--Author
--Author
-Book
--Author
--Author
--Author
--Author
Shelf
-Book
--Author
--Author
--Author
-Book
--Author
--Author
-Book
--Author
--Author
--Author
--Author
 
So I looping over shelves then looping over books, then Authors
 
Well it appears to be returning all of the authors in the first Loop.
 
Does anyone have any suggestions?
Thanks, Fred
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SOXML xmlToDom

2001-12-15 Thread John Wilker

Also as a side note, you may want to consider using the MS XML parser
yourself instead of SoXML. In an application I did, with a 200k XML
file, it would take a minute or more to parse with soxml and a few
seconds just using the MSxml parser directly.

J.

 
 
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
 
www.red-omega.com
 
"With your shield or on it."
 
Spartan mothers would say this to their sons going to battle. It was
believed that if you turned to run you'd drop your shield.. If you died
in combat your comrades would carry your body home on your shield. So
coming home with it or on it were the only options. 


-Original Message-
From: Fred Anderson [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, December 15, 2001 10:02 PM
To: CF-Talk
Subject: SOXML xmlToDom


While using CF_SOXML xmltoDOM to parse some XML I am having the
following issue. When trying to retrieve a node it is giving back all
the nodes at that level through the site; here is an example.
 
Shelf
-Book
--Author
--Author
--Author
-Book
--Author
--Author
-Book
--Author
--Author
--Author
--Author
Shelf
-Book
--Author
--Author
--Author
-Book
--Author
--Author
-Book
--Author
--Author
--Author
--Author
 
So I looping over shelves then looping over books, then Authors
 
Well it appears to be returning all of the authors in the first Loop.
 
Does anyone have any suggestions?
Thanks, Fred
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



SOXML xmlToDom

2001-12-15 Thread Fred Anderson

While using CF_SOXML xmltoDOM to parse some XML I am having the
following issue. When trying to retrieve a node it is giving back all
the nodes at that level through the site; here is an example.
 
Shelf
-Book
--Author
--Author
--Author
-Book
--Author
--Author
-Book
--Author
--Author
--Author
--Author
Shelf
-Book
--Author
--Author
--Author
-Book
--Author
--Author
-Book
--Author
--Author
--Author
--Author
 
So I looping over shelves then looping over books, then Authors
 
Well it appears to be returning all of the authors in the first Loop.
 
Does anyone have any suggestions?
Thanks, Fred
 

~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Fw: Query Field with Null Value

2001-12-15 Thread Jennifer Larkin

At 07:51 PM 12/15/01 -0500, you wrote:
>- Original Message -
>From: "Anthony Abby" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, December 14, 2001 7:19 PM
>Subject: Query Field with Null Value
>
>
> > Silly question but what's the best way of building a query that will
> > select records containing a specific WORD, AND also include records that
>are
> > NULL in the same field?
> >
> > (TC.Status <> 'Closed') OR (TC.Status = NULL) 

Try:

(TC.Status LIKE '%Closed%') OR (TC.Status IS NULL)

Now available in a San Francisco Bay Area near you!
http://www.blivit.org/mr_urc/index.cfm
http://www.blivit.org/mr_urc/resume.cfm
~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Fw: Query Field with Null Value

2001-12-15 Thread Anthony Abby

- Original Message -
From: "Anthony Abby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 14, 2001 7:19 PM
Subject: Query Field with Null Value


> Silly question but what's the best way of building a query that will
> select records containing a specific WORD, AND also include records that
are
> NULL in the same field?
>
> (TC.Status <> 'Closed') OR (TC.Status = NULL) 
>
> Thanks
> Anthony
>
>
>





_

Do You Yahoo!?

Get your free @yahoo.com address at http://mail.yahoo.com


~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



How should I handle this???

2001-12-15 Thread Douglas Brown

I am creating a message board, and have hopes of putting it up for sale 
once completed. I want the forum to be dynamic in as far as the ability 
to change the background and font etc etc on the fly. I have a page 
where the admin can make theses changes etc, but what I want to do is 
have a preview window of what it will look like once the changes are 
made. Should I try and attempt this with javascript and put in a 
 then use the innerHTML attribute? I know this will not work 
with NS but I am not sure of another way.

 Any suggestion would help!!!


Doug



~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Unique ID Help

2001-12-15 Thread Steven Dworman

make sure the datatype is a varchar (varchar2 if oracle) and that it is long
enough.

you'll need single quotes around it


- Original Message -
From: "Gregory Harris" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, December 15, 2001 1:30 PM
Subject: Unique ID Help


> Ok, say I have a given Unique ID:
>
> CFE4734A-CEA8-48BE-9D64-88FCBB7E2688
>
> That needs to be inserted into a database like so perhaps:
>
> INSERT INTO ThisTable)
>
> (GUID Field)
>
> VALUES
>
> (CFE4734A-CEA8-48BE-9D64-88FCBB7E2688)
>
>
> How do I get it into the GUID Field? I've tried with and without quotes
and
> have had no success.  Thanks for your help!
>
>
> Gregory Harris
> [EMAIL PROTECTED]
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Source Control and Your Dog

2001-12-15 Thread Steven Dworman

visual source safe or teamsite.  i've used both of them.  only heard good
things about pvcs.  so i guess any of the three would be ok.

my $0.02


- Original Message -
From: "Zac spitzer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, December 15, 2001 5:21 PM
Subject: Re: Source Control and Your Dog


> Jay Jennings wrote:
>
> >We're battling at work over whether to switch to Perforce or PVCS for our
> >source control. If anyone has any thoughts on whether one or the other is
> >better in a CF coding environment, feel free to speak up. We have local
and
> >remote developers, if that makes a difference.
> >
> good old cvs I find great
>
> http://www.wincvs.org  windows client
> http://www.cvsnt.org  windows server
>
> tortise cvs is a great exporer shell ext which ties cvs directly into
> explorer...
>
> z
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Unique ID Help

2001-12-15 Thread Jennifer Larkin

At 10:30 AM 12/15/01 -0800, you wrote:
>Ok, say I have a given Unique ID:
>
>CFE4734A-CEA8-48BE-9D64-88FCBB7E2688
>
>That needs to be inserted into a database like so perhaps:
>
>INSERT INTO ThisTable)
>
>(GUID Field)
>
>VALUES
>
>(CFE4734A-CEA8-48BE-9D64-88FCBB7E2688)
>
>
>How do I get it into the GUID Field? I've tried with and without quotes and
>have had no success.  Thanks for your help!

What is the error message? If you've tried with quotes, it might be a "this 
info will be truncated" message, in which case, the data is too long to fit 
into the specified field and you need to make the field larger.


Now available in a San Francisco Bay Area near you!
http://www.blivit.org/mr_urc/index.cfm
http://www.blivit.org/mr_urc/resume.cfm
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



anybody else having tag gallery problems?

2001-12-15 Thread Don Vawter

Anybody else getting errors when trying to submit a new tag?

Don

Error Diagnostic Information
Error processing CFFILE

Error attempting to generate temporary file name for directory
'\\uscamspcp002\e$\developer\gallery\components'.
Error: An unspecified error occurred.

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (64:2) to (64:138) in the template
file C:\PROGRAM FILES\ALLAIRE\SPECTRA\PLP\DEVX\DEVX_SUBMIT\SUBMITPAGES.CFM.


Date/Time: 12/15/01 18:40:09
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; T312461)
Remote Address: 65.100.189.91
HTTP Referer: http://devex.allaire.com/developer/gallery/Submit.cfm

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Source Control and Your Dog

2001-12-15 Thread Zac spitzer

Jay Jennings wrote:

>We're battling at work over whether to switch to Perforce or PVCS for our 
>source control. If anyone has any thoughts on whether one or the other is 
>better in a CF coding environment, feel free to speak up. We have local and 
>remote developers, if that makes a difference.
>
good old cvs I find great

http://www.wincvs.org  windows client
http://www.cvsnt.org  windows server

tortise cvs is a great exporer shell ext which ties cvs directly into 
explorer...

z
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFMAIL

2001-12-15 Thread Tangorre, Michael T.

Hey everyone,

What kind of options are available for formatting non-html email...
I need to format the emails one module of this sytem I am working on sends
out.

Thanks for any input.


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Unique ID Help

2001-12-15 Thread Douglas Brown

Well if your table row is a varchar then it should be


INSERT INTO yourtable (GUID)
VALUES ('#UUID#')




- Original Message -
From: "Gregory Harris" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, December 15, 2001 10:30 AM
Subject: Unique ID Help


> Ok, say I have a given Unique ID:
>
> CFE4734A-CEA8-48BE-9D64-88FCBB7E2688
>
> That needs to be inserted into a database like so perhaps:
>
> INSERT INTO ThisTable)
>
> (GUID Field)
>
> VALUES
>
> (CFE4734A-CEA8-48BE-9D64-88FCBB7E2688)
>
>
> How do I get it into the GUID Field? I've tried with and without quotes
and
> have had no success.  Thanks for your help!
>
>
> Gregory Harris
> [EMAIL PROTECTED]
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Unique ID Help

2001-12-15 Thread David Hannum \(Ohio University\)

In this case, you GUID field is a TEXT or CHAR or VARCHAR field, so you must
put single quotes around the value in the SQL.

INSERT INTO thisTable
(GUID)
VALUES ('CFE4734A-CEA8-48BE-9D64-88FCBB7E2688')

Dave


- Original Message -
From: "Gregory Harris" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, December 15, 2001 1:30 PM
Subject: Unique ID Help


> Ok, say I have a given Unique ID:
>
> CFE4734A-CEA8-48BE-9D64-88FCBB7E2688
>
> That needs to be inserted into a database like so perhaps:
>
> INSERT INTO ThisTable)
>
> (GUID Field)
>
> VALUES
>
> (CFE4734A-CEA8-48BE-9D64-88FCBB7E2688)
>
>
> How do I get it into the GUID Field? I've tried with and without quotes
and
> have had no success.  Thanks for your help!
>
>
> Gregory Harris
> [EMAIL PROTECTED]
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Unique ID Help

2001-12-15 Thread Gregory Harris

Ok, say I have a given Unique ID:

CFE4734A-CEA8-48BE-9D64-88FCBB7E2688

That needs to be inserted into a database like so perhaps:

INSERT INTO ThisTable)

(GUID Field)

VALUES

(CFE4734A-CEA8-48BE-9D64-88FCBB7E2688)


How do I get it into the GUID Field? I've tried with and without quotes and
have had no success.  Thanks for your help!


Gregory Harris
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Getting at a datasource on a different machine

2001-12-15 Thread Dick Applebaum

One way is to put a stub program on A.  The stub program receives a 
WDDX packet containing the SQL Statements from your program on B,

The stub program issues the SQL commands against its db and returns 
the result set through another WDDX packet.

I do this all the time to setup/manipulate client dbs where I don't 
have admin privileges to the client's site and db.

   server B: Serialize SQL Commands
   server B: cfhttp post WDDX to stub on server A

   server A Stub: Invoked by cfhttp post
   server A Stub: Deserialize WDDX SQL statements
   server A Stub: Issue SQL statements against server A db
   server A Stub: Serialize and return SQL result set to cfhttp request

   server B: deserialize SQL result set returned from cfhttp request
   server B: process result set as if normal query

HTH

Dick

At 11:16 AM -0500 12/15/01, Joe Tartaglia wrote:
>Here is my problem:
>
>The code for my main site resides on Web Server A.
>This server is running ColdFusion 4.5.
>
>Some payment forms need to be on a secure server (Server B).
>Server B is running ColdFusion 4.0
>
>Questions:
>1.  How can I access a CF datasource that is set up on
> Server A from the code on Server B?
>
>2.  What problems might I expect due to the fact that
> Server A and B are running different versions of CF.
> (My code is very generic and was originally written
> and functions under CF Ver. 4.0)
>
>Thanks in advance.
>
>Joe Tartaglia
>High Caliber Systems
>FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Getting at a datasource on a different machine

2001-12-15 Thread Alex

On Sat, 15 Dec 2001, Joe Tartaglia wrote:

> 
> Here is my problem:
> 
> The code for my main site resides on Web Server A.
> This server is running ColdFusion 4.5. 
> 
> Some payment forms need to be on a secure server (Server B).
> Server B is running ColdFusion 4.0
> 
> Questions:
> 1.  How can I access a CF datasource that is set up on
> Server A from the code on Server B?

You can't if you mean datasource to be the ODBC connection.
You can if you mean datasource to be a database. Then you just 
setup an ODBC on the serverB

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



slightly OT: anyone have Excel 97 installed?

2001-12-15 Thread Gyrus

Could someone help me out with a problem I'm having
with the web query function in Excel?

I developed a template for a client to use, tying a web
query macro to a button for them to download some data
from their CF site. But even though I saved it out as 97
format from my Excel 2000, they're having problems in
97. I think some of the macro code is incompatible.
(BTW, I'm on Win 2000 and they're on Win NT 4.)

What I'm after is some basic screen shots of all the
dialogue boxes involved in doing a web query *manually*
in Excel 97 - enough for me to talk the client through
the process blow-by-blow for them to do the query
manually.

Send any grabs you can do off-list!

thanks,

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Getting at a datasource on a different machine

2001-12-15 Thread Joe Tartaglia


Here is my problem:

The code for my main site resides on Web Server A.
This server is running ColdFusion 4.5. 

Some payment forms need to be on a secure server (Server B).
Server B is running ColdFusion 4.0

Questions:
1.  How can I access a CF datasource that is set up on
Server A from the code on Server B?

2.  What problems might I expect due to the fact that
Server A and B are running different versions of CF.
(My code is very generic and was originally written
and functions under CF Ver. 4.0)

Thanks in advance.

Joe Tartaglia
High Caliber Systems
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: XML Schema Validation

2001-12-15 Thread Dick Applebaum

Thanks Nick1

>From your reference, and a few others I found, I was able to cobble 
together a simple CF program that actually works!

   
 schemaCache = CreateObject("COM","MSXML2.XMLSchemaCache.4.0");
 schemaCache.Add("","c:\test\listschema.xml");
 doc = CreateObject("COM","MSXML2.DOMDocument.4.0");
 doc.schemas = schemaCache;
 doc.async = 0;
 doc.load("c:\tesr\publist_schema.xml");
 XMLParsingError = doc.parseError;
   

   
   ErrorCode.|#XMLParsingError.ErrorCode#|
   Reason|#XMLParsingError.Reason#|
   


I am really "shooting in the dark" though:

   VBS 5 does not support "Dim ... As" to create an object

   The Object ClassName "MSXML2.XMLSchemaCache40" in VB, needs to be 
specified as
   "MSXML2.XMLSchemaCache.4.0" in cfobject

   The Object ClassName "MSXML2.DOMDocument40" in VB, needs to be
 specified as
   "MSXML2.DOMDocument.4.0" in cfobject

So far, I have only been able to validate by loading the XNL document 
from disk.

I would like to do much more, but have been unable to find any info 
on the MSXML 4.0 objects, methods and properties.

Any help will be greatly appreciated!

Dick

At 4:45 AM -0500 12/15/01, Nick de Voil wrote:
>Dick
>
>Does this help?
>
>http://www.vbws.com/tutors/xsd/xsdvb.aspx
>
>The nitty-gritty part seems to be
>
>Dim schemaCache As MSXML2.XMLSchemaCache40
>Set schemaCache = New MSXML2.XMLSchemaCache40
>schemaCache.Add ìî,îD:\schemas\mySchema.xsdî
>Dim doc As MSXML2.DOMDocument40
>Set doc = New MSXML2.DOMDocument40
>Set doc.schemas = schemaCache
>doc.async = False
>If Not doc.Load(ìD:\docs\myDoc.xmlî) Then
> MsgBox "Error loading XML document: " & doc.parseError.reason
>End If
>
>which CFOBJECT could handle I dare say.
>
>Nick
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: XML Schema Validation

2001-12-15 Thread Nick de Voil

Dick

Does this help?

http://www.vbws.com/tutors/xsd/xsdvb.aspx

The nitty-gritty part seems to be

Dim schemaCache As MSXML2.XMLSchemaCache40
Set schemaCache = New MSXML2.XMLSchemaCache40
schemaCache.Add “”,”D:\schemas\mySchema.xsd”
Dim doc As MSXML2.DOMDocument40
Set doc = New MSXML2.DOMDocument40
Set doc.schemas = schemaCache
doc.async = False
If Not doc.Load(“D:\docs\myDoc.xml”) Then
MsgBox "Error loading XML document: " & doc.parseError.reason
End If

which CFOBJECT could handle I dare say.

Nick
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query Field with Null Value

2001-12-15 Thread Nick de Voil

Anthony

Yes, but use "IS NULL" instead of "= NULL"

(TC.Status <> 'Closed') OR (TC.Status IS NULL)

Nick
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: check for double byte (japanese characters)

2001-12-15 Thread Paul Hastings

> For the english only section, I would like to ensure that the user does
not
> enter any japanese by mistake.
>
> Is it possible to detect non english characters?

if you're using unicode, kinda easy, if not, kinda tough. you might try
forcing latin charset so that japanese chars would look "funny".


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.307 / Virus Database: 168 - Release Date: 12/11/2001
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists