How do you concatenate 2 string variables into one with a space in the middle

2001-12-12 Thread one

Re: How do you concatenate 2 string variables into one with a space in the
middle

i.e. (area code) and (telephone number)  - such as 858  999  into 858
999  to be inserted into one field in a database. Here's how I wrote the
code thus far:

Variable 1:cfparam name=areacode default=#BusphoneArea#

Variable 2:   cfparam name=telnum default=#Busphone#

Then I try to concatenate em as follows, and find I have not only not
succeeded but have in fact arrived at a place of dismal failure.

cfparam name=cust_tel_num default=#areacode# #telnum#

Appreciate any insights.

Cheers aye,
Pardee.
~~
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: Stupid Studio Bug?

2001-12-12 Thread Kay Smoljak

Hi Jon,

I've noticed this before - what is actually happening on mine (CFStudio
5) is that the Tag Insight popup is coming up, and the first item (it's
the a tag) is selected, so that when you hit enter without looking at
the screen that item is selected and replaces the text back from where
it thinks it should go. If this is your problem, you can fix it by
increasing the delay for Tag Insight in the Settings Dialog, or
disabling it altogther if you're not using it.

HTH,
Kay.
__ 
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd 
Internet Solutions for your business! 
  
Level 9/105 St George's Tc - Perth - Western Australia 
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007 
Visit Perth online! : www.perthweb.com.au 

Tools for developers: http://developer.perthweb.com.au 
-- cfx_pwimageproc -- cfx_pwcardcrypt -- cfx_pwtextcrypt --
--   plus WindowsXP-compliant toolbar glyphs -- 
 

Jon Hall [EMAIL PROTECTED] wrote in message
news:003501c182d7$ae4e2160$a41f88d8@ns2...
 OK, no one else has ever mentioned this, but it's bugged me to no end 
 for a long time. I was wondering if it is perhaps someone knew of a 
 way to stop it from happening. The problem is that Studio seems to be 
 incompatible with for loops. When I type:
 for (i = 0; i  5; i++ ) {
 
 Right after the curly brace I hit enter and half of the line I am 
 writing disappears and the cursor goes back to the  character. I 
 can't belive that this big a bug in Studio has gone unnoticed or would

 not be fixed. I am thinking it's something with my config that someone

 else has seen?
 
 jon
 
~~
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: How do you concatenate 2 string variables into one with a space in the middle

2001-12-12 Thread Yanton

you can use
cfparam name=cust_tel_num default=#areacode# #telnum#

yanton
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, 12 December, 2001 3:16 PM
Subject: How do you concatenate 2 string variables into one with a space in
the middle


 Re: How do you concatenate 2 string variables into one with a space in the
 middle

 i.e. (area code) and (telephone number)  - such as 858  999  into 858
 999  to be inserted into one field in a database. Here's how I wrote
the
 code thus far:

 Variable 1:cfparam name=areacode default=#BusphoneArea#

 Variable 2:   cfparam name=telnum default=#Busphone#

 Then I try to concatenate em as follows, and find I have not only not
 succeeded but have in fact arrived at a place of dismal failure.

 cfparam name=cust_tel_num default=#areacode# #telnum#

 Appreciate any insights.

 Cheers aye,
 Pardee.
 
~~
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



OT: JavaScript to validate form with 2 functions

2001-12-12 Thread Aidan Whitehall

Does anyone know how to validate a form using two functions, one triggering
another?

I've got three forms that all contain the same fields, but then each one has
a couple of other fields as well. The onSubmit needs to trigger a specific
function and if that validation passes, it should then trigger the generic
form validation. The two functions work when called independently, but if
the first one validates OK, the form is submitted (ie the second function
doesn't seem to catch validation errors).

Something like this...


SCRIPT SRC=/javascript/validateRegisterForm.js.../SCRIPT
SCRIPT SRC=/javascript/validateForm.js.../SCRIPT

FORM ACTION=/cgi-bin/sendmail.asp METHOD=post onSubmit=return
validateEnrollmentForm(this);


function validateEnrollmentForm(form) {
   if (someCondition) {
  alert(You forgot the x);
  return false;
   } else {
  validateForm(form)
   }

   return true;
}

function validateForm(form) {
   if (someCondition) {
  alert(You forgot the y);
  return false;
   }

   return true;
}


Thanks if you can help.

-- 
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775

_
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
~~
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: JavaScript to validate form with 2 functions IGNORE

2001-12-12 Thread Aidan Whitehall

 Does anyone know how to validate a form using two functions, one
triggering
 another?

Please ignore previous post... got the answer!



-- 
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775

_
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
~~
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



Java - Socket()

2001-12-12 Thread Rudy Rustam

Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks
~~
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: Java - Socket()

2001-12-12 Thread Craig Dudley

I don't think there is one, the closest would be cfhttp though I think, what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks

~~
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: Java - Socket()

2001-12-12 Thread Mark Smyth

I though COM/DCOM were similar to sockets..

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:11
To: CF-Talk
Subject: RE: Java - Socket()


I don't think there is one, the closest would be cfhttp though I think, what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks


~~
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: Java - Socket()

2001-12-12 Thread Rudy Rustam

Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks


~~
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



Locking again (sorry)

2001-12-12 Thread Tage Widsell

Just a little detail:

I know that I must lock every read from a shared scope variable, but what
about checking for it's existence? Is that ok without locking? For example:

cfif IsDefined(Server.webroot)
...do this and that...
/cfif

Regards
Tage Widsell
Webmaster

~~
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: Locking again (sorry)

2001-12-12 Thread Jochem van Dieten

Tage Widsell wrote:

 Just a little detail:
 
 I know that I must lock every read from a shared scope variable, but what
 about checking for it's existence? Is that ok without locking? For example:
 
 cfif IsDefined(Server.webroot)
 ...do this and that...
 /cfif


You need to lock those too.

Jochem
~~
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: Java - Socket()

2001-12-12 Thread Craig Dudley

CFHTTP will not give you the control you need over the http headers.

You will need either a com object or a java custom tag. I'm doing something
very similar with a com object called tcpclient, the writer of which (Lewis
Sellers) is on this list.

It's fast, easy to use and gives you almost total control, you can get it
here http://www.intrafoundation.com/tcpclient.html

I'll glady let you have the code I'm using if you need help.

HTH, Craig.


-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks



~~
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: Java - Socket()

2001-12-12 Thread Mark Smyth

cfhttp is fairly limited

I've had this problem working with SOAP.  

If you need to send a body, this is achieved by using a COM object and then
sending the http message through the COM.

try tcpclient2 http://www.intrafoundation.com/tcpclient.html

You connect to a COM object using the cfobject tag, but this tag comes with
loads of examples if i remember

Mark




-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks



~~
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: Java - Socket()

2001-12-12 Thread Mark Smyth

hi craig

just out of interest, have you (or anyone else on the list) connected to a
SOAP server of tomcat?

Mark

-Original Message-
From: Mark Smyth 
Sent: 12 December 2001 11:04
To: CF-Talk
Subject: RE: Java - Socket()


cfhttp is fairly limited

I've had this problem working with SOAP.  

If you need to send a body, this is achieved by using a COM object and then
sending the http message through the COM.

try tcpclient2 http://www.intrafoundation.com/tcpclient.html

You connect to a COM object using the cfobject tag, but this tag comes with
loads of examples if i remember

Mark




-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks




~~
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: New CF Whois tag?

2001-12-12 Thread Gordon Burns

Hi Lewis,

I am attempting to use your TCP Client and although I have managed 
to use it for your examples I fear that in the real world example 
where I need to use it I am struggling.  It is at the very edge of 
my abilities and experience.


I have to talk to an SMS message gateway and I have the TCP/IP spec 
some asp examples but I am still struggling

I have attached the zip file with the specs from these guys.
I know this is very presumptuous and if you are too busy I do 
understand.  I am happy to pay for your time if you could just give 
me a couple of working examples.

I had the syem all working beautifully from another supplier (using 
an http post) only to find that all of a sudden they have problems 
with their UK Gateway which is essential as it is where I and my 
clients are based.  They did not know that until I advised them and 
they are talking about a month to fix it.

In the meantime I have a bunch of clients who I had demonstrated 
this working all now anxious to go and I am stuffed.  This new 
supplier seems a better bet but only have a TCP/IP connection or 
email connection but the email will not allow me to set the sender ID.

I have always been grateful for your contributions on the list and 
hope that you do not mind mailing you direct.  I am happy to pay 
for your time if you have any spare.  I am in a bit of a bind over this.


Kind regards



Gordon


PS if you can not help but know someone who could assist me with 
this please let me know.










At 21:47 29/11/2001 lsellers said
At 03:04 PM 11/29/2001 -0600, you wrote:
 look for a CFX tag that does everything at a lower level - those cf_whois
 tags just grab the info from NSI's website and parse the output - messy, and
 potentially a legal issue - instead, use something like cfx_nicname:
 http://www.intrafoundation.com/freeware.html#cfx_nicname

Even slightly better, if they're not scared of COM's they can use tcpclient
and talk directly to the whois server (there is an WHOIS protocol just as
there is HTTP and FTP protocols etc.) If you talked directly to it there's
a whole lot of [censored] you don't have to worry about then.

You do unfortunately still have to parse through it but the plus of doing
it in CFM instead of C or C++ (or java) is you don't have to bug me if
there's some radical change to the text format. /-)

This example looks up houseoffusion.com and printed out the returned text

h1HOUSEOFFUSION.COM/h1

cfset obj.Clear()
cfset c=obj.Open(whois.networksolutions.com,whois)
CFIF c IS 1
  cfset obj.timeout=3.000
  cfset obj.SendRN(houseoffusion.com)
  cfset page=obj.Recv()
  cfoutput#HTMLCodeFormat(page)#/cfoutput
  cfset obj.Close()
/CFIF

--min


~~
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: Java - Socket()

2001-12-12 Thread Craig Dudley

Not yet Mark, will be implementing a SOAP system soon after Christmas.

I've heard a few people talk about a custom tag called cfx_soap before
though, maybe that can help you.


-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:06
To: CF-Talk
Subject: RE: Java - Socket()


hi craig

just out of interest, have you (or anyone else on the list) connected to a
SOAP server of tomcat?

Mark

-Original Message-
From: Mark Smyth 
Sent: 12 December 2001 11:04
To: CF-Talk
Subject: RE: Java - Socket()


cfhttp is fairly limited

I've had this problem working with SOAP.  

If you need to send a body, this is achieved by using a COM object and then
sending the http message through the COM.

try tcpclient2 http://www.intrafoundation.com/tcpclient.html

You connect to a COM object using the cfobject tag, but this tag comes with
loads of examples if i remember

Mark




-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks





~~
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



NTConsoleJava Tieing Up Resources

2001-12-12 Thread Scott Brady

I'm running Windows XP Pro with IIS and CF 5.

When I log into my computer (or turn it on, whatever), during the startup
process (after logging on, so the desktop is showing and startup
items/services are starting up) NTConsoleJava.exe uses up all spare CPUs
(which makes the computer run very slowly).  The only way to speed it up is
to kill the process.

I originally thought this had something to do with my current version of my
JVM on Windows.  However, I just discovered that NTConsoleJava.exe is in the
cfusion directory, so I assume it's related to ColdFusion.

Is there anything I can do to either 1) Stop NTConsoleJava from using up all
my spare CPUs or 2) Stop NTConsoleJava from running at startup?  I looked in
the CF Admin, and the closest I could find is to not load the JVM when CF
starts up, but that was already turned off.

Thanks!

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

~~
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: NTConsoleJava Tieing Up Resources

2001-12-12 Thread Craig Dudley

Uninstall cfgraph and or performance monitoring, the problem will go away.

Try re-installing them again later if you really need them.

Craig.

-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:34
To: CF-Talk
Subject: NTConsoleJava Tieing Up Resources


I'm running Windows XP Pro with IIS and CF 5.

When I log into my computer (or turn it on, whatever), during the startup
process (after logging on, so the desktop is showing and startup
items/services are starting up) NTConsoleJava.exe uses up all spare CPUs
(which makes the computer run very slowly).  The only way to speed it up is
to kill the process.

I originally thought this had something to do with my current version of my
JVM on Windows.  However, I just discovered that NTConsoleJava.exe is in the
cfusion directory, so I assume it's related to ColdFusion.

Is there anything I can do to either 1) Stop NTConsoleJava from using up all
my spare CPUs or 2) Stop NTConsoleJava from running at startup?  I looked in
the CF Admin, and the closest I could find is to not load the JVM when CF
starts up, but that was already turned off.

Thanks!

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


~~
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: Java - Socket()

2001-12-12 Thread Mark Smyth

tried cfx_soap, even to the extent of altering the source code, with no luck

there seems to be some problem with coldfusion, com and soap servers on
tomcat.

ASP works fine, and i'm really pi with having to work with asp

Mark


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:24
To: CF-Talk
Subject: RE: Java - Socket()


Not yet Mark, will be implementing a SOAP system soon after Christmas.

I've heard a few people talk about a custom tag called cfx_soap before
though, maybe that can help you.


-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:06
To: CF-Talk
Subject: RE: Java - Socket()


hi craig

just out of interest, have you (or anyone else on the list) connected to a
SOAP server of tomcat?

Mark

-Original Message-
From: Mark Smyth 
Sent: 12 December 2001 11:04
To: CF-Talk
Subject: RE: Java - Socket()


cfhttp is fairly limited

I've had this problem working with SOAP.  

If you need to send a body, this is achieved by using a COM object and then
sending the http message through the COM.

try tcpclient2 http://www.intrafoundation.com/tcpclient.html

You connect to a COM object using the cfobject tag, but this tag comes with
loads of examples if i remember

Mark




-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks






~~
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: New CF Whois tag?

2001-12-12 Thread Gordon Burns

Sorry Folks clearly that should have been off List.

Must be the stress...

Apologies to all

Gordon 
~~
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



No pemmission to delete file after corrupt FTP

2001-12-12 Thread Nick Betts

Has anyone experienced this.
I have happily been uploading files to  server via FTP.  Along the way,
one file was corrupted, resulting in me not being able to delete/rename
etc.   How can I upload a new version of the file?

Cheers,
Nick.

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:35
To: CF-Talk
Subject: RE: NTConsoleJava Tieing Up Resources


Uninstall cfgraph and or performance monitoring, the problem will go
away.

Try re-installing them again later if you really need them.

Craig.

-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:34
To: CF-Talk
Subject: NTConsoleJava Tieing Up Resources


I'm running Windows XP Pro with IIS and CF 5.

When I log into my computer (or turn it on, whatever), during the
startup
process (after logging on, so the desktop is showing and startup
items/services are starting up) NTConsoleJava.exe uses up all spare CPUs
(which makes the computer run very slowly).  The only way to speed it up
is
to kill the process.

I originally thought this had something to do with my current version of
my
JVM on Windows.  However, I just discovered that NTConsoleJava.exe is in
the
cfusion directory, so I assume it's related to ColdFusion.

Is there anything I can do to either 1) Stop NTConsoleJava from using up
all
my spare CPUs or 2) Stop NTConsoleJava from running at startup?  I
looked in
the CF Admin, and the closest I could find is to not load the JVM when
CF
starts up, but that was already turned off.

Thanks!

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



~~
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: Locking again (sorry)

2001-12-12 Thread Bud

On 12/12/01, Tage Widsell penned:
I know that I must lock every read from a shared scope variable, but what
about checking for it's existence? Is that ok without locking? For example:

cfif IsDefined(Server.webroot)
 ...do this and that...
/cfif

isDefined is a Read. You'll only be able to leave it unlocked if 
Automatic Read Locking is enabled on the server.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
~~
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



CF server 5.0 bug?

2001-12-12 Thread Franke, Ir. G.J.

Hello there,

I recently upgraded my 4.5 server to 5.0 prof.

i use COM objects to communicate with a picture generating dll installed on
the server:

application.cfm code:

cfif not isdefined(session.comobject)

cflock timeout=5 throwontimeout=Yes type=EXCLUSIVE scope=SESSION 
cfset session.comobject = createobject(com,Mapmaker.CF_interface)
/cflock

/cfif

mapmaker.cfm code:

cflock timeout=5 throwontimeout=Yes type=EXCLUSIVE scope=SESSION
cfset xmldata = session.comobject.execute(cgistring,cmdstring)
/cflock

this all worked fine on 4.5... but since i installed 5.0 the server
*sometimes* goes to 99% cpu usage and stops responding when running
mapmaker.cfm...

when restarting the server the dll throws the following error:

TMoMapProducer:~~Object server is stopping when OLE service contacts it... 
so this suggests that cf 5 is not answering properly to the dll.

does anybody know what is going on here and what to do about it, except
reinstalling cf 4.5 again?

cheers, Jappe


~~
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: Java - Socket()

2001-12-12 Thread Rudy Rustam

Yeah...! just what I want, Thanks guys, Thanks Craig!


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 7:36 PM
To: CF-Talk
Subject: RE: Java - Socket()

CFHTTP will not give you the control you need over the http headers.

You will need either a com object or a java custom tag. I'm doing
something
very similar with a com object called tcpclient, the writer of which
(Lewis
Sellers) is on this list.

It's fast, easy to use and gives you almost total control, you can get
it
here http://www.intrafoundation.com/tcpclient.html

I'll glady let you have the code I'm using if you need help.

HTH, Craig.


-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

Thanks




~~
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: Java - Socket()

2001-12-12 Thread Joel Parramore

There isn't one.  And what else you use depends on what you want to do.

ColdFusion has a number of tags encapsulating specific Internet protocols,
i.e., CFHTTP, CFFTP, CFPOP, etc. CFHTTP can be used for regular HTTP
operations (POST, GET) but is no good for things like SOAP (not enough
control of headers, for one).

Lower-level socket operations would require the use of a custom tag, either
written in C++ or Java, or a COM/DCOM object.

Regards,
Joel Parramore



 -Original Message-
 From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 12, 2001 5:18 AM
 To: CF-Talk
 Subject: Java - Socket()


 Hi guys,

 What's the coldfusion equivalent for java Socket()?

 Thanks
 
~~
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: NTConsoleJava Tieing Up Resources

2001-12-12 Thread Scott Brady

 Uninstall cfgraph and or performance monitoring, the problem will go away.

By uninstall do you mean just disabling the service on startup?  Or, do I
need to uninstall CF5 and reinstall without CFGraph or Performance
Monitoring?

I tried disabling the CFGraph server and Cold Fusion Monitoring services,
but that didn't help.

Thanks!

Scott

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

~~
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: Quick cfdirectory ?...

2001-12-12 Thread Tyler Silcox

I set it up the same way as below with the if statement.  I was just looking
for a quick and (not-so) dirty solution, and I really don't know why they
are there in the first place.  Can you climb a directory tree with these or
what?  Thanks James and Lloyd...

Tyler

- Original Message -
From: Lloyd Bayley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 11, 2001 9:56 PM
Subject: Re: Quick cfdirectory ?...


I did it this way...

Set the query here...

cfdirectory action=LIST directory=d:\folder\subfolder
name=Qry_Show_Folder


Show the files without directories here...

select name=Cmb_FolderView size=9
 cfoutput query=Qry_Show_Folder

 cfif #type# neq Dir
 option
 #DateLastModified# - #name#br
 /option
 /cfif
 /cfoutput
/select


HTH,

Lloyd. :-)



At 15:40 12/12/01 +1300, you wrote:
At 03:01 PM 12/12/2001, you wrote:
 Is it possible to keep the Dir Types out of my query for cfdirectory?
 With a filter maybe?  This is what I got's:
 
 cfdirectory name=myQueryName action=LIST
 directory=#request.Path.FileDir#filez\
 
 and it returns:
 
 ., .., file01, file02, file03, etc.  Can I throw a filter
 attribute on the cfdirectory?  I can figure out how to make it return all
 the *.wma files, but I can't figure out how to just give me back
Type=File,
 (Type is a returned column when using cfdirectory) and not the Type=Dir.
 And I've got it doing basically what I want, which is excluding the Dir
 Types, with some cfifs, but I'd rather leave them out of the over all
 picture.  Any assistance would be greatly appreciated...


Mmm, I don't think there is a way to do it directly with the cfdirectory
tag.  If you are runing CF5, you can just do a query of the query that
cfdirectory returns to get all the type='file' or type='dir' records.  If
you are not yet on CF5 you could build another query manually (using
combinations of queryNew(), queryAddRow(), querySetCell()) from the query
that cfdirectory returns, opnly inserting those rows you want (i.e where
type eq file).




James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential
and may be legally privileged. If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited. If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.


~~
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: NTConsoleJava Tieing Up Resources

2001-12-12 Thread Craig Dudley

If you look at add/remove progams there should be a cfgraph support entry
in the list

-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 13:06
To: CF-Talk
Subject: Re: NTConsoleJava Tieing Up Resources


 Uninstall cfgraph and or performance monitoring, the problem will go away.

By uninstall do you mean just disabling the service on startup?  Or, do I
need to uninstall CF5 and reinstall without CFGraph or Performance
Monitoring?

I tried disabling the CFGraph server and Cold Fusion Monitoring services,
but that didn't help.

Thanks!

Scott

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


~~
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: Quick cfdirectory ?...

2001-12-12 Thread Craig Dudley

Yes you can climb directory trees by calling cfdirectory recursivley.


like this


custom tag, [dir.cfm]

cfparam name=request.filelist
default=#QueryNew('Filename,FileDate,Size')#
cfdirectory action=LIST directory=#attributes.basedir# name=list
cfloop query=list
cfif type is File and right(#name#,4) is #attributes.filter#
cfscript
QueryAddRow(request.filelist);

QuerySetCell(request.filelist,FileName,#attributes.basedir##name#);

QuerySetCell(request.filelist,FileDate,#DateLastModified#);
QuerySetCell(request.filelist,Size,#Size#);
/cfscript
cfelse
cfif NOT (name is . or name is ..)
cf_dir basedir = #attributes.basedir##name#\
filter=#attributes.filter#
/cfif
/cfif
/cfloop



Call the tag like so...

cf_dir basedir = d:\ filter=.wma


That should kick back a query obect (request.filelist) which contains all
wma files in the directory tree down form d:\

Try not to let it scan HUGE trees as it may take for ever.

HTH, Craig.

-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 13:09
To: CF-Talk
Subject: Re: Quick cfdirectory ?...


I set it up the same way as below with the if statement.  I was just looking
for a quick and (not-so) dirty solution, and I really don't know why they
are there in the first place.  Can you climb a directory tree with these or
what?  Thanks James and Lloyd...

Tyler

- Original Message -
From: Lloyd Bayley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 11, 2001 9:56 PM
Subject: Re: Quick cfdirectory ?...


I did it this way...

Set the query here...

cfdirectory action=LIST directory=d:\folder\subfolder
name=Qry_Show_Folder


Show the files without directories here...

select name=Cmb_FolderView size=9
 cfoutput query=Qry_Show_Folder

 cfif #type# neq Dir
 option
 #DateLastModified# - #name#br
 /option
 /cfif
 /cfoutput
/select


HTH,

Lloyd. :-)



At 15:40 12/12/01 +1300, you wrote:
At 03:01 PM 12/12/2001, you wrote:
 Is it possible to keep the Dir Types out of my query for cfdirectory?
 With a filter maybe?  This is what I got's:
 
 cfdirectory name=myQueryName action=LIST
 directory=#request.Path.FileDir#filez\
 
 and it returns:
 
 ., .., file01, file02, file03, etc.  Can I throw a filter
 attribute on the cfdirectory?  I can figure out how to make it return all
 the *.wma files, but I can't figure out how to just give me back
Type=File,
 (Type is a returned column when using cfdirectory) and not the Type=Dir.
 And I've got it doing basically what I want, which is excluding the Dir
 Types, with some cfifs, but I'd rather leave them out of the over all
 picture.  Any assistance would be greatly appreciated...


Mmm, I don't think there is a way to do it directly with the cfdirectory
tag.  If you are runing CF5, you can just do a query of the query that
cfdirectory returns to get all the type='file' or type='dir' records.  If
you are not yet on CF5 you could build another query manually (using
combinations of queryNew(), queryAddRow(), querySetCell()) from the query
that cfdirectory returns, opnly inserting those rows you want (i.e where
type eq file).




James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential
and may be legally privileged. If the reader of this message is not the
intended recipient you are notified that any use, dissemination,
distribution or reproduction of this message is prohibited. If you have
received this message in error please notify the sender immediately and
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media
Ltd.



~~
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: NTConsoleJava Tieing Up Resources

2001-12-12 Thread Scott Brady

 If you look at add/remove progams there should be a cfgraph support
entry
 in the list

Nope, there isn't.

I wonder how much of a hassle it'll be to uninstall and re-install the
server . . . .

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

~~
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: No pemmission to delete file after corrupt FTP

2001-12-12 Thread Nick Betts

Solution found:  I had to close my Secure FTP session and VNC in and
delete corrupt file.  It appears that FTP had a lock on file (due to the
fact I was uploading from our network instead of my local machine me
thinks..)


-Original Message-
From: Nick Betts 
Sent: 12 December 2001 12:27
To: CF-Talk
Subject: No pemmission to delete file after corrupt FTP


Has anyone experienced this.
I have happily been uploading files to  server via FTP.  Along the way,
one file was corrupted, resulting in me not being able to delete/rename
etc.   How can I upload a new version of the file?

Cheers,
Nick.

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:35
To: CF-Talk
Subject: RE: NTConsoleJava Tieing Up Resources


Uninstall cfgraph and or performance monitoring, the problem will go
away.

Try re-installing them again later if you really need them.

Craig.

-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:34
To: CF-Talk
Subject: NTConsoleJava Tieing Up Resources


I'm running Windows XP Pro with IIS and CF 5.

When I log into my computer (or turn it on, whatever), during the
startup
process (after logging on, so the desktop is showing and startup
items/services are starting up) NTConsoleJava.exe uses up all spare CPUs
(which makes the computer run very slowly).  The only way to speed it up
is
to kill the process.

I originally thought this had something to do with my current version of
my
JVM on Windows.  However, I just discovered that NTConsoleJava.exe is in
the
cfusion directory, so I assume it's related to ColdFusion.

Is there anything I can do to either 1) Stop NTConsoleJava from using up
all
my spare CPUs or 2) Stop NTConsoleJava from running at startup?  I
looked in
the CF Admin, and the closest I could find is to not load the JVM when
CF
starts up, but that was already turned off.

Thanks!

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




~~
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



Address Verification

2001-12-12 Thread Sam Farmer

Doing some research on address verification software and was wondering if
anyone had used some in the past?  There seem to be several that provide a
COM interface.

Has anyone used this?
How much did it cost?

Thanks,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions
http://www.intelixinc.com
12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
703-815-2500


~~
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



Verify error

2001-12-12 Thread Michael Ross

I run a job every other day to index some of my collections.  Today I
 got this error and now I can't do it throught the administrator eith
er, it keeps timing out.  I searched the forums but there wasn't 
much on it.  Can anyone point me in the right direction.

Thanks
¯---
Error occurred in tag CFINDEX 
Internal Error: Purge failed
Error Code: -23

¯-

~~
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 help needed: stripping tags from a string

2001-12-12 Thread Kay Smoljak

Hi all,

I'm trying to get a regular expression working to replace some
particularly horrible markup (yes it's Microsoft-generated) with
something manageable. I'm trying to turn this string:

P class=MsoNormal style=MARGIN: 0cm 0cm 0pt /P
P class=MsoNormal style=MARGIN: 0cm 0cm 0ptBlah Blah Blah/P

Into this:

 | | | Blah Blah Blah |

So far I have this:

cfset cleanme = REREplaceNoCase(mystring,[][[:print:]]*[], |
,ALL)

to try and turn all paragraph tags into pipe characters flanked by
spaces. But, instead of it matching any printable character from the
first  to the first , which is what I thought it should do, it's
ignoring the first  and the second  and skipping to the second . So
the first two paragraph tags, instead of being converted to two pipes,
are being converted to one. Argh!

If anyone can point out where I'm going wrong, I'd really appreciate it.

K.
~~
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: Address Verification

2001-12-12 Thread Jon Hall

USPS provides address verification via it's XML interface for free...
http://164.109.64.160/front2.asp
I haven't used their address verification api, but the rest of their api's
are great.

jon
- Original Message -
From: Sam Farmer [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 9:13 AM
Subject: Address Verification


 Doing some research on address verification software and was wondering if
 anyone had used some in the past?  There seem to be several that provide a
 COM interface.

 Has anyone used this?
 How much did it cost?

 Thanks,

 Sam

 Sam Farmer - Senior Developer
 Certified Advanced ColdFusion 5 Developer
 [EMAIL PROTECTED]
 INTELIX - Intelligent Solutions
 http://www.intelixinc.com
 12500 Fair Lakes Circle, Suite 150
 Fairfax, VA 22033
 703-815-2500


 
~~
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: RE help needed: stripping tags from a string

2001-12-12 Thread Steve Martin

An alternative approach - try using the MS Office 2000 HTML filter:
http://download.microsoft.com/download/office2000prem/msohtmf/2000/WIN98
/EN-US/msohtmf2.exe

Steve

 -Original Message-
 From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
 Sent: 12 December 2001 14:36
 To: CF-Talk
 Subject: RE help needed: stripping tags from a string
 
 
 Hi all,
 
 I'm trying to get a regular expression working to replace some
 particularly horrible markup (yes it's Microsoft-generated) with
 something manageable. I'm trying to turn this string:
 
 P class=MsoNormal style=MARGIN: 0cm 0cm 0pt /P
 P class=MsoNormal style=MARGIN: 0cm 0cm 0ptBlah Blah Blah/P
 
 Into this:
 
  | | | Blah Blah Blah |
 
 So far I have this:
 
 cfset cleanme = REREplaceNoCase(mystring,[][[:print:]]*[], |
 ,ALL)
 
 to try and turn all paragraph tags into pipe characters flanked by
 spaces. But, instead of it matching any printable character from the
 first  to the first , which is what I thought it should do, it's
 ignoring the first  and the second  and skipping to the second . So
 the first two paragraph tags, instead of being converted to two pipes,
 are being converted to one. Argh!
 
 If anyone can point out where I'm going wrong, I'd really 
 appreciate it.
 
 K.
 
~~
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: Send response to browser, but continue working on request?

2001-12-12 Thread Lon Lentz

  Sorry for my nondescript answer yesterday but I didn't have the exact 
answer in front of me.

  Use cfhttp in your kickstart template to make a post to the action 
template with a timeout=1.


 -Original Message-
 From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, December 11, 2001 4:07 PM
 To: CF-Talk
 Subject: RE: Send response to browser, but continue working on 
request?
 
 
 Thanks, that sounds good, but I was hoping to not have to use 
CFSCHEDULE.
 
 Any other ideas?
~~
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: Stupid Studio Bug?

2001-12-12 Thread Don Vawter

I have had this happen to when you have tag insight enabled. Fortunately
clicking the undo button  or typing ctrl-Z will restore the erased portion

- Original Message -
From: Jon Hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 11, 2001 11:38 PM
Subject: Stupid Studio Bug?


 OK, no one else has ever mentioned this, but it's bugged me to no end for
a
 long time. I was wondering if it is perhaps someone knew of a way to stop
it
 from happening. The problem is that Studio seems to be incompatible with
for
 loops.
 When I type:
 for (i = 0; i  5; i++ ) {

 Right after the curly brace I hit enter and half of the line I am writing
 disappears and the cursor goes back to the  character. I can't belive
that
 this big a bug in Studio has gone unnoticed or would not be fixed. I am
 thinking it's something with my config that someone else has seen?

 jon
 
~~
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: How do you concatenate 2 string variables into one with a space in the middle

2001-12-12 Thread Tony Schreiber

CFSET combined = var1 var2

or

CFSET combined = #var1# #var2#

 you can use
 cfparam name=cust_tel_num default=#areacode# #telnum#

 yanton
 - Original Message -
 From: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, 12 December, 2001 3:16 PM
 Subject: How do you concatenate 2 string variables into one with a space in
 the middle


  Re: How do you concatenate 2 string variables into one with a space in the
  middle
 
  i.e. (area code) and (telephone number)  - such as 858  999  into 858
  999  to be inserted into one field in a database. Here's how I wrote
 the
  code thus far:
 
  Variable 1:cfparam name=areacode default=#BusphoneArea#
 
  Variable 2:   cfparam name=telnum default=#Busphone#
 
  Then I try to concatenate em as follows, and find I have not only not
  succeeded but have in fact arrived at a place of dismal failure.
 
  cfparam name=cust_tel_num default=#areacode# #telnum#
 
  Appreciate any insights.
 
  Cheers aye,
  Pardee.
 
 
~~
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: Send response to browser, but continue working on request?

2001-12-12 Thread Tony Schreiber

CFHTTP with a timeout of 1? Hmm. I got it working with CFEXECUTE (Timeout
0), but ultimately CFHTTP may be easier to use (because I can pump some
cookie variables into it)...

   Sorry for my nondescript answer yesterday but I didn't have the exact
 answer in front of me.

   Use cfhttp in your kickstart template to make a post to the action
 template with a timeout=1.


  -Original Message-
  From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, December 11, 2001 4:07 PM
  To: CF-Talk
  Subject: RE: Send response to browser, but continue working on
 request?
 
 
  Thanks, that sounds good, but I was hoping to not have to use
 CFSCHEDULE.
 
  Any other ideas?
 
~~
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



Releasing Access locks with Coldfusion?

2001-12-12 Thread Kris Pilles

Anyone know how to release all locks on an access database via coldfusion?

I am having some trouble with getting one of our datasources to release its
current locking thus preventing me from uploading a new copy of the DB.


Thanks for your help

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Mark Smyth

just stopping the coldfusion service should do it


-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 15:31
To: CF-Talk
Subject: Releasing Access locks with Coldfusion?


Anyone know how to release all locks on an access database via coldfusion?

I am having some trouble with getting one of our datasources to release its
current locking thus preventing me from uploading a new copy of the DB.


Thanks for your help

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Will Swain

query a table that doesn't exist. That'll force Access to close its ldb
file.

cfquery name=kill_connections datasourceyourdatasource
SELECT *
FROM tbl_nothere
/cfquery

HTH

will

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 15:31
To: CF-Talk
Subject: Releasing Access locks with Coldfusion?


Anyone know how to release all locks on an access database via coldfusion?

I am having some trouble with getting one of our datasources to release its
current locking thus preventing me from uploading a new copy of the DB.


Thanks for your help

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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



formating in database?

2001-12-12 Thread Shawn Regan

What are some good products that people are using to give the user the
ability to do html formating on text and then submit it to a database?

Shawn Regan
Applications Developer
pacifictechnologysolutions

~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Jon Hall

cfset rs = cfusion_disable_dbconnections(myDSN,1)
The following line enables the data source named cfmysource:
cfset rs = cfusion_disable_dbconnections(myDSN,0)

You can also uncheck Maintain Database Connections in the CF admin and the
database will never lock.

jon
- Original Message -
From: Kris Pilles [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 10:31 AM
Subject: Releasing Access locks with Coldfusion?


 Anyone know how to release all locks on an access database via coldfusion?

 I am having some trouble with getting one of our datasources to release
its
 current locking thus preventing me from uploading a new copy of the DB.



~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Benjamin S. Rogers

Perhaps there is a better way in newer version of ColdFusion, but in
ColdFusion 4.0.1 we just generated an ODBC error by querying a column
that doesn't exist.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 10:31 AM
To: CF-Talk
Subject: Releasing Access locks with Coldfusion?


Anyone know how to release all locks on an access database via
coldfusion?

I am having some trouble with getting one of our datasources to release
its current locking thus preventing me from uploading a new copy of the
DB.


Thanks for your help

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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: Send response to browser, but continue working on request?

2001-12-12 Thread Lon Lentz

 
  I don't know how this will work if you are running both templates on 
the same server. We had the kickstart template on the webserver and the 
action template on a different machine.


 -Original Message-
 From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 12, 2001 10:28 AM
 To: CF-Talk
 Subject: RE: Send response to browser, but continue working on 
request?
 
 
 CFHTTP with a timeout of 1? Hmm. I got it working with CFEXECUTE 
(Timeout
 0), but ultimately CFHTTP may be easier to use (because I can pump 
some
 cookie variables into it)...
 
Sorry for my nondescript answer yesterday but I didn't have the 
exact
  answer in front of me.
 
Use cfhttp in your kickstart template to make a post to the action
  template with a timeout=1.
 
 
   -Original Message-
   From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, December 11, 2001 4:07 PM
   To: CF-Talk
   Subject: RE: Send response to browser, but continue working on
  request?
  
  
   Thanks, that sounds good, but I was hoping to not have to use
  CFSCHEDULE.
  
   Any other ideas?
  
 
~~
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



Inserting data from txt file into db via cf?

2001-12-12 Thread Kris Pilles

I need to take a text file lisitng of about 300 different courses (1 per
line comma delimited) and inser them into my database.  Anyone know how I
can accomplish this?

Thanks

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Michael Hazard

Just send it a junk SQL statement.  For example:

cfquery name=unlockmdb datasource=datasourceName
  SELECT  blah
  FROM blah
/cfquery

It will return an error, but the lock should be gone.

Kris Pilles [EMAIL PROTECTED] wrote in message
E7B536D0EE4BD51197B0009027724CE1C5999F@ADMIN-EXCHANGE">news:E7B536D0EE4BD51197B0009027724CE1C5999F@ADMIN-EXCHANGE...
 Anyone know how to release all locks on an access database via coldfusion?

 I am having some trouble with getting one of our datasources to release
its
 current locking thus preventing me from uploading a new copy of the DB.


 Thanks for your help

 Kris Pilles
 Website Manager
 Western Suffolk BOCES
 507 Deer Park Rd., Building C
 Phone: 631-549-4900 x 267
 E-mail: [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



OT: Sendmail under Windows

2001-12-12 Thread Zac Belado

Sorry for the offtopic post but I am looking for any comments from people
who have used sendmail under Windows NT or Windows 2000. Especially those
people who may have used it in conjunction with ColdFusion.


If you have any comments, pro or con, and have a second I would greatly
appreciate any feedback, offlist please, that you might have.


TIA

--

Zac Belado
Application Developer

Bayleaf Software
#300 948 Homer Street,
Vancouver, BC,
V6B 2W7
Ph: 604.683.1288 x 116
~~
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



recordset sql statement

2001-12-12 Thread Dunwiddie, Bruce

in the debug window, under recordsets, there's a column that shows the sql
that ran to generate that query. is this an exposed variable that we have
access to on a page? like in the form of something like
#queryname.statement# or is it restricted to only their debug window and
~~
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: Address Verification

2001-12-12 Thread Dunwiddie, Bruce

USPS offers it for free from their website but you have to go thru alot of
paperwork to get in to it, but I'd recommend it.

-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 8:14 AM
To: CF-Talk
Subject: Address Verification


Doing some research on address verification software and was wondering if
anyone had used some in the past?  There seem to be several that provide a
COM interface.

Has anyone used this?
How much did it cost?

Thanks,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions
http://www.intelixinc.com
12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033
703-815-2500



~~
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: formating in database?

2001-12-12 Thread Howie Hamlin

EZ-Edit:

http://www.siteobjects.com/index.cfm?fuseaction=showezedit

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
 Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product 
http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm
 Find out how iMS Stacks up to the competition: 
http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: Shawn Regan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 10:43 AM
Subject: formating in database?


 What are some good products that people are using to give the user the
 ability to do html formating on text and then submit it to a database?
 
 Shawn Regan
 Applications Developer
 pacifictechnologysolutions
 
 
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Jon Hall

Opps snipped the first line, and the dsn was named wrong :) This is CF 4.5+
only

The following line disables the data source.
cfset rs = cfusion_disable_dbconnections(myDSN,1)
The following line enables the data source.
cfset rs = cfusion_disable_dbconnections(myDSN,0)

jon
- Original Message -
From: Jon Hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 10:46 AM
Subject: Re: Releasing Access locks with Coldfusion?


 cfset rs = cfusion_disable_dbconnections(myDSN,1)
 The following line enables the data source named cfmysource:
 cfset rs = cfusion_disable_dbconnections(myDSN,0)

 You can also uncheck Maintain Database Connections in the CF admin and the
 database will never lock.

 jon
 - Original Message -
 From: Kris Pilles [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, December 12, 2001 10:31 AM
 Subject: Releasing Access locks with Coldfusion?


  Anyone know how to release all locks on an access database via
coldfusion?
 
  I am having some trouble with getting one of our datasources to release
 its
  current locking thus preventing me from uploading a new copy of the DB.
 
 

 
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Michiel Boland

 Perhaps there is a better way in newer version of ColdFusion, but in
 ColdFusion 4.0.1 we just generated an ODBC error by querying a column
 that doesn't exist.

This does not work in CF versions 4.5 and higher. What does work is
the cfusion_dbconnections_flush() function.
~~
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: recordset sql statement

2001-12-12 Thread Garza, Jeff

It's part of the debug variables.  You can enable this in the CF
Administrator to appear on pages requested from a specific IP address.

HTH,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 9:11 AM
To: CF-Talk
Subject: recordset sql statement


in the debug window, under recordsets, there's a column that shows the sql
that ran to generate that query. is this an exposed variable that we have
access to on a page? like in the form of something like
#queryname.statement# or is it restricted to only their debug window and

~~
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: RE help needed: stripping tags from a string

2001-12-12 Thread Don Vawter

cfset cleanme = rereplace(mystring,[^]*,,all)
this will strip all tags

- Original Message -
From: Kay Smoljak [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 7:35 AM
Subject: RE help needed: stripping tags from a string


 Hi all,

 I'm trying to get a regular expression working to replace some
 particularly horrible markup (yes it's Microsoft-generated) with
 something manageable. I'm trying to turn this string:

 P class=MsoNormal style=MARGIN: 0cm 0cm 0pt /P
 P class=MsoNormal style=MARGIN: 0cm 0cm 0ptBlah Blah Blah/P

 Into this:

  | | | Blah Blah Blah |

 So far I have this:

 cfset cleanme = REREplaceNoCase(mystring,[][[:print:]]*[], |
 ,ALL)

 to try and turn all paragraph tags into pipe characters flanked by
 spaces. But, instead of it matching any printable character from the
 first  to the first , which is what I thought it should do, it's
 ignoring the first  and the second  and skipping to the second . So
 the first two paragraph tags, instead of being converted to two pipes,
 are being converted to one. Argh!

 If anyone can point out where I'm going wrong, I'd really appreciate it.

 K.
 
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Chuck Rodgers

Hi,

Causing the ODBC error works to unlock an Access db in CF 4.5 and CF 5.0 in 
my experience.

Chuck Rodgers

At 05:17 PM 12/12/01 +0100, you wrote:
  Perhaps there is a better way in newer version of ColdFusion, but in
  ColdFusion 4.0.1 we just generated an ODBC error by querying a column
  that doesn't exist.

This does not work in CF versions 4.5 and higher. What does work is
the cfusion_dbconnections_flush() function.

~~
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: Stupid Studio Bug?

2001-12-12 Thread Douglas Brown

I would say that it is a setting in your auto-completion. I tried your code
and it works fine. V4.5.2


Doug



- Original Message -
From: Jon Hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 11, 2001 10:38 PM
Subject: Stupid Studio Bug?


 OK, no one else has ever mentioned this, but it's bugged me to no end for
a
 long time. I was wondering if it is perhaps someone knew of a way to stop
it
 from happening. The problem is that Studio seems to be incompatible with
for
 loops.
 When I type:
 for (i = 0; i  5; i++ ) {

 Right after the curly brace I hit enter and half of the line I am writing
 disappears and the cursor goes back to the  character. I can't belive
that
 this big a bug in Studio has gone unnoticed or would not be fixed. I am
 thinking it's something with my config that someone else has seen?

 jon
 
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Will Swain

yeah it does. I did it just yesterday on CF version 5. Throws an error but
unlocks the DB.

will

-Original Message-
From: Michiel Boland [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 16:18
To: CF-Talk
Subject: RE: Releasing Access locks with Coldfusion?


 Perhaps there is a better way in newer version of ColdFusion, but in
 ColdFusion 4.0.1 we just generated an ODBC error by querying a column
 that doesn't exist.

This does not work in CF versions 4.5 and higher. What does work is
the cfusion_dbconnections_flush() function.

~~
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



CF Java trouble.

2001-12-12 Thread Kevin Cundick

Hi All,

This is the first time I've tried to do anything with Java and CF.  I have
downloaded the CFX_JSocket.class from cfdev.com.  I have setup Java in the CF
Administrator as the documentation has instructed.  I have had some success with
some simple Java cfobject programs, but this is my first Java Custom tag.

I copied the CFX_JSocket.class into the coldfusion install/Java/classes
directory which I also added the Class Path in CF Admin.  I registered the CFX
tag in CF Admin as well.

I created a small .cfm file with this line in it:
CFX_JSocket host=www.yahoo.com port=80 data=GET / #Chr(13)##Chr(10)#
lines=12 timeout=8000
(which is the example they give when I downloaded the class.  I have tried to
connect to other servers in house with the same problem)

Each time I try to run the .cfm file I get this error:
java.lang.NumberFormatException: . Java exception occurred in call to method.

Can anyone give me any idea what I'm doing wrong?  I'm not sure it matters, but
we do run ColdFusion on Solaris.

Thanks!!

Kevin
~~
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: CF Java trouble.

2001-12-12 Thread Zac Belado

 Can anyone give me any idea what I'm doing wrong?  I'm not sure 
 it matters, but we do run ColdFusion on Solaris.

What version of Java are you running on your server? 

~~
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: CF Java trouble.

2001-12-12 Thread Zac Belado

  Can anyone give me any idea what I'm doing wrong?  I'm not sure
  it matters, but we do run ColdFusion on Solaris.

 What version of Java are you running on your server?

And I also asked

Does the error give a method name or class name in which the error occurs?


But the last line got cut off again. Is this the listserv's mail server
doing this or mine?







~~
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: CF Java trouble.

2001-12-12 Thread Kevin Cundick

We are running CF 4.5.1 SP 2.

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 9:39 AM
To: CF-Talk
Subject: RE: CF  Java trouble.


 Can anyone give me any idea what I'm doing wrong?  I'm not sure 
 it matters, but we do run ColdFusion on Solaris.

What version of Java are you running on your server? 


~~
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: CF Java trouble.

2001-12-12 Thread Kevin Cundick

No it does not.  Here is the exact error:

Error Diagnostic Information
java.lang.NumberFormatException: . Java exception occurred in call to method.

The error occurred while processing an element with a general identifier of
(CFX_JSOCKET), occupying document position (88:1) to (88:104) in the template
file /opt/apache/htdocs/Java/jsocket.cfm.

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 9:45 AM
To: CF-Talk
Subject: RE: CF  Java trouble.


  Can anyone give me any idea what I'm doing wrong?  I'm not sure
  it matters, but we do run ColdFusion on Solaris.

 What version of Java are you running on your server?

And I also asked

Does the error give a method name or class name in which the error occurs?


But the last line got cut off again. Is this the listserv's mail server
doing this or mine?








~~
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: recordset sql statement

2001-12-12 Thread Tyler Clendenin

i have also been woindering this, if anyone can answert this question it
would be greatlky appreciated.
- Original Message -
From: Dunwiddie, Bruce [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 11:11 AM
Subject: recordset sql statement


 in the debug window, under recordsets, there's a column that shows the sql
 that ran to generate that query. is this an exposed variable that we have
 access to on a page? like in the form of something like
 #queryname.statement# or is it restricted to only their debug window and
 
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Jon Hall

It didn't work for me in 4.5, but I haven't tested in 5.0, so it probably
depends on some config in the cf admin. However this IS a bug, and as with
all bugs or undocumented features, there is a chance that they will not work
in future versions, so dont build any code that relies on it.
This bug was supposed to be fixed in 4.5 though...

jon
- Original Message -
From: Will Swain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 11:25 AM
Subject: RE: Releasing Access locks with Coldfusion?


 yeah it does. I did it just yesterday on CF version 5. Throws an error but
 unlocks the DB.

 will

 -Original Message-
 From: Michiel Boland [mailto:[EMAIL PROTECTED]]
 Sent: 12 December 2001 16:18
 To: CF-Talk
 Subject: RE: Releasing Access locks with Coldfusion?


  Perhaps there is a better way in newer version of ColdFusion, but in
  ColdFusion 4.0.1 we just generated an ODBC error by querying a column
  that doesn't exist.

 This does not work in CF versions 4.5 and higher. What does work is
 the cfusion_dbconnections_flush() function.

 
~~
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: formating in database?

2001-12-12 Thread Tyler Clendenin

We use http://www.cfdev.com/activedit/ It is very helpful.
- Original Message -
From: Shawn Regan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 10:43 AM
Subject: formating in database?


 What are some good products that people are using to give the user the
 ability to do html formating on text and then submit it to a database?

 Shawn Regan
 Applications Developer
 pacifictechnologysolutions

 
~~
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: HTML okay in browser

2001-12-12 Thread Paul Sinclair

Jochem,

As you suggested in trying to diagnose the problem I am having, I sent
an email that got trapped and went to the undelivr folder. When I look
at it, the html looks fine. Opening it in a browser after renaming it to
html everything is fine. 

I've put up the chopped version of the file up as well as the version
that was trapped in the undelivr folder. The chopped version is a
sample of what is getting to the email addresses it is sent to. It is
here:
http://www.cpsmagazines.com/news.sent.version.html

The version that got trapped in the undelivr folder is here:
http://www.cpsmagazines.com/news.undelivr.html

Take a look at numbered paragraph 6/7 in the sent version to see an
example of what is happening somewhere along the way. In the undelivr
version, those paragraphs are fine. There are several other paragraphs
in chopped sample where I am getting the same kind of thing.

FYI, the mailserver is iMail v6.

Thanks if you have any ideas what I can do to fix this. I've got
scheduled deliveries of this starting this weekend so I would really
like to get it working right before then obviously!

Regards,
Paul Sinclair




 -Original Message-
 From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
 Sent: Monday, December 10, 2001 3:33 AM
 To: CF-Talk
 Subject: Re: HTML okay in browser
 
 
 Paul Sinclair wrote:
 
  Jochem,
  
 But when is it chopped off? When cf writes the email to the 
 spoolfolder or when dart.dll takes it from the spool folder 
 to the SMTP server?
  
  I have no idea. How do I tell? All I know is that somewhere in the
  process chunks of the html code are just being left out.
 
 
 Send the email in such a way that the SMTP server does not accept it. 
 Common ways to do that are to set the To: and the From: both to an 
 adress in an untrusted domain (relaying) or a non-excistent 
 domain. The 
 email will end up in the mail\undelivr\ folder and you can 
 see what it 
 looks like by just opening the file in a text editor.
 
 Jochem
 
~~
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: CF Java trouble.

2001-12-12 Thread Zac Belado

 We are running CF 4.5.1 SP 2.

Which version of the Java runtime are you running? You might want to
consider upgrading if you're not running 1.3.1



~~
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: CF Java trouble.

2001-12-12 Thread Pete Freitag

That exception is cause because you are entering (or not entering) a tag
attribute that it is expecting to be a number, and it can't convert it to a
number.  See the tag docs to see which ones must be numbers (eg PORT).

+
Pete Freitag ([EMAIL PROTECTED])
CTO, CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/


-Original Message-
From: Kevin Cundick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 11:55 AM
To: CF-Talk
Subject: RE: CF  Java trouble.


No it does not.  Here is the exact error:

Error Diagnostic Information
java.lang.NumberFormatException: . Java exception occurred in call to
method.

The error occurred while processing an element with a general identifier of
(CFX_JSOCKET), occupying document position (88:1) to (88:104) in the
template
file /opt/apache/htdocs/Java/jsocket.cfm.

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 9:45 AM
To: CF-Talk
Subject: RE: CF  Java trouble.


  Can anyone give me any idea what I'm doing wrong?  I'm not sure
  it matters, but we do run ColdFusion on Solaris.

 What version of Java are you running on your server?

And I also asked

Does the error give a method name or class name in which the error occurs?


But the last line got cut off again. Is this the listserv's mail server
doing this or mine?









~~
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: CF Java trouble.

2001-12-12 Thread Kevin Cundick

Looks like we're running 1.2.2.  Seems like I read somewhere that, at least at
this point, upgrading to 1.3.x is not recommended.  I can't remember exactly
where I read that.  Anyone else know anything about this?

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 10:15 AM
To: CF-Talk
Subject: RE: CF  Java trouble.


 We are running CF 4.5.1 SP 2.

Which version of the Java runtime are you running? You might want to
consider upgrading if you're not running 1.3.1




~~
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: CF Java trouble.

2001-12-12 Thread Zac Belado

 Looks like we're running 1.2.2.  Seems like I read somewhere
 that, at least at
 this point, upgrading to 1.3.x is not recommended.  I can't
 remember exactly
 where I read that.  Anyone else know anything about this?

I've been running 1.3.1 with no problems. But that is under win2K. I've no
idea what impact this would have under Solaris.
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Bud

On 12/12/01, Jon Hall penned:
You can also uncheck Maintain Database Connections in the CF admin and the
database will never lock.

You should never Maintain Database Connections on an Access DB anyway.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
~~
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: formating in database?

2001-12-12 Thread Gary Kraeger

Speaking of Activedit, we are seeking around 10 beta testers, to test our
new Activedit built in Java. We built this version because many of our
customers wanted to be able to use Macs for editing. So far in our test it
works with all version of IE on windows and mac and on most version of
Netscape on both windows and mac.

If you would like to beta test please email [EMAIL PROTECTED] and tell us
what browser(s), operating system(s) you would like to be a tester for. We
will only take a limited number of testers, on a first come first serve
basis.

Tyler thanks for suggesting out product.

gary
cfdev.com


- Original Message -
From: Tyler Clendenin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 12:09 PM
Subject: Re: formating in database?


 We use http://www.cfdev.com/activedit/ It is very helpful.
 - Original Message -
 From: Shawn Regan [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, December 12, 2001 10:43 AM
 Subject: formating in database?


  What are some good products that people are using to give the user the
  ability to do html formating on text and then submit it to a database?
 
  Shawn Regan
  Applications Developer
  pacifictechnologysolutions
 
 
 
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Steve Martin

Porquoi?

 -Original Message-
 From: Bud [mailto:[EMAIL PROTECTED]]
 Sent: 12 December 2001 17:27
 To: CF-Talk
 Subject: Re: Releasing Access locks with Coldfusion?
 
 
 On 12/12/01, Jon Hall penned:
 You can also uncheck Maintain Database Connections in the CF 
 admin and the
 database will never lock.
 
 You should never Maintain Database Connections on an Access DB anyway.
 -- 
 
 Bud Schneehagen - Tropical Web Creations
 
 _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
 ColdFusion Solutions / eCommerce Development
 [EMAIL PROTECTED]
 http://www.twcreations.com/
 
~~
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



Custom Delimiters with DSNless connection

2001-12-12 Thread Correa, Orlando (ITSC)

Anyone know how to set custom delimiters using a DSNless connection in CF?

I have the following which does work... except for the fact that it's
delimiting based on the commas(,), not the pipes (|).

cfset connectstring = 
Driver={Microsoft Text Driver (*.txt;
*.csv)};Format=Delimited(|);Dbq=c:\inetpub\wwwroot\textfiles;
 Extensions=asc,csv,tab,txt;Persist Security Info=False;

CFQUERY NAME=qry_text_monkey DBTYPE=dynamic
CONNECTSTRING=#connectstring#
  SELECT * from Equip99a.txt
/CFQUERY

I've also created a Schema.ini file in the same directory to no avail:

[Equip99a.txt]
ColNameHeader = False
Format=Delimited(|)
CharacterSet = ANSI

Any ideas?

Thanks,
Orlando
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Dave Watts

  You should never Maintain Database Connections on an Access 
  DB anyway.
 
 Pourquoi?

En raison des fuites de mémoire ODBC!

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
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: CF Java trouble.

2001-12-12 Thread Kevin Cundick

Thanks Pete.  I have double-checked everything as you indicated.  This is what
I'm trying to get to work:
CFX_JSocket host=#server# port=9987 data=#FullString# lines=1000
timeout=8000

Server = the IP Address of the server I'm trying to connect to.
FullString = the String I'm trying to pass.

Do you see anything that should cause that error with what I'm sending?  I've
checked the tag docs and so far as I can see everything is setup correctly.

Thanks!!

Kevin

-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 10:05 AM
To: CF-Talk
Subject: RE: CF  Java trouble.


That exception is cause because you are entering (or not entering) a tag
attribute that it is expecting to be a number, and it can't convert it to a
number.  See the tag docs to see which ones must be numbers (eg PORT).

+
Pete Freitag ([EMAIL PROTECTED])
CTO, CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/


-Original Message-
From: Kevin Cundick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 11:55 AM
To: CF-Talk
Subject: RE: CF  Java trouble.


No it does not.  Here is the exact error:

Error Diagnostic Information
java.lang.NumberFormatException: . Java exception occurred in call to
method.

The error occurred while processing an element with a general identifier of
(CFX_JSOCKET), occupying document position (88:1) to (88:104) in the
template
file /opt/apache/htdocs/Java/jsocket.cfm.

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 9:45 AM
To: CF-Talk
Subject: RE: CF  Java trouble.


  Can anyone give me any idea what I'm doing wrong?  I'm not sure
  it matters, but we do run ColdFusion on Solaris.

 What version of Java are you running on your server?

And I also asked

Does the error give a method name or class name in which the error occurs?


But the last line got cut off again. Is this the listserv's mail server
doing this or mine?










~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Steve Martin

Are they still around? 
Ignoring the mem leak issues (or the escapes of memory  ;-) ) I recall
that Allaire recommended that connections should not be maintained to
Access dbs with CF3.x but changed the database pooling methods with 4.x+
and hence recommended that connections should be maintained. Obviously
they should have considered the mem leaks before giving this advice. Ho
hum.

 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]]
 Sent: 12 December 2001 17:44
 To: CF-Talk
 Subject: RE: Releasing Access locks with Coldfusion?
 
 
   You should never Maintain Database Connections on an Access 
   DB anyway.
  
  Pourquoi?
 
 En raison des fuites de mémoire ODBC!
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444
 
~~
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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Dave Watts

 Are they still around? 
 Ignoring the mem leak issues (or the escapes of memory  ;-) 
 ) I recall that Allaire recommended that connections should not 
 be maintained to Access dbs with CF3.x but changed the database 
 pooling methods with 4.x+ and hence recommended that connections 
 should be maintained. Obviously they should have considered the 
 mem leaks before giving this advice. Ho hum.

I think the problem of Access memory leaks probably occurs with various
version of MDAC released after CF 4 came out.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
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



Apache Xindice Project

2001-12-12 Thread Kurt Ward

The XF_Xindice Toolkit is now available through the developers exchange.
The admin application will follow in a couple of days.  The project is
hosted on SourceForge if anyone is interested in contributing.

Kurt
~~
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



Displaying of HTML in page?

2001-12-12 Thread Douglas Brown

I am creating a forum for our site, and want to be able to display HTML 
code. How can I accomplish this where the browser will not try to render 
the code. Also if someone types in a link, I want that to display as a 
clickable link and not just text.


All help appreciated.




Doug




~~
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: Displaying of HTML in page?

2001-12-12 Thread Garza, Jeff

HTMLCodeFormat(yourstring)

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 11:13 AM
To: CF-Talk
Subject: Displaying of HTML in page?


I am creating a forum for our site, and want to be able to display HTML 
code. How can I accomplish this where the browser will not try to render 
the code. Also if someone types in a link, I want that to display as a 
clickable link and not just text.


All help appreciated.




Doug





~~
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: Displaying of HTML in page?

2001-12-12 Thread Will Swain

use the character entities for  and  instead of the symbols themselves. I
think its lt; and gt; if I remember correctly.

HTH

will

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 18:13
To: CF-Talk
Subject: Displaying of HTML in page?


I am creating a forum for our site, and want to be able to display HTML
code. How can I accomplish this where the browser will not try to render
the code. Also if someone types in a link, I want that to display as a
clickable link and not just text.


All help appreciated.




Doug





~~
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



javascript variables help!

2001-12-12 Thread thanh . nguyen

Hi all,
 
In one of my pages, I have a javascript array.  How do I pass it to the next
page to do some calculation using both Coldfusion and javascript?

TIA,
 
Thanh

~~
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



Passing a radiobutton value through a javascript function within frames

2001-12-12 Thread James Taavon

Hello All,

Interesting problem here that's probably easily fixed but I'm at wits end.
For starters I have a three-framed environment, a top frame, a left frame
and a main frame. In the main frame I have a simple form consisting of two
radiobuttons and a continue button. I have an onclick function attached to
the continue button. I'm trying to pass the value of the selected
radiobutton through a javascript function onto the next page which loads in
the same frame.

HERE'S THE CODE:



The javascript function:

SCRIPT LANGUAGE=JavaScript
function loadFrames(frame1,page1) {
eval(parent.+frame1+.location='+page1+');
}
/script

--

The form:

input type=radio name=radiobutton value=request Requestbr
input type=radio name=radiobutton value=fixProgram Fix

input type=button value=Submit
onClick=javascript:loadFrames('mainFrame',
'main_request1_form.cfm?requesttype=radiobutton.value')



requesttype is the variable that passes onto the next page. In fact it
does pass, but when I do a cfoutput it displays: radiobutton.value

Any help would be greatly appreciated.
~~
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: Displaying of HTML in page?

2001-12-12 Thread Bryan Love

actually I believe it's HTMLEditFormat()

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+

...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 10:03 AM
To: CF-Talk
Subject: RE: Displaying of HTML in page?


HTMLCodeFormat(yourstring)

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 11:13 AM
To: CF-Talk
Subject: Displaying of HTML in page?


I am creating a forum for our site, and want to be able to display HTML 
code. How can I accomplish this where the browser will not try to render 
the code. Also if someone types in a link, I want that to display as a 
clickable link and not just text.


All help appreciated.




Doug






~~
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: OnSelect Javascript code

2001-12-12 Thread thanh . nguyen

I used this 


CFWDDX
ACTION=CFML2JS
INPUT=#getProd_list#
TOPLEVELVARIABLE=getProd_list

function partlist(thisInfo){
document.all.PartList.options.length = 0;
var olen = 0;
for (var i=0;i  getProd_list.p_num.length; i++)
{
if (getProd_list.m_mscode[i] ==
thisInfo.options[thisInfo.selectedIndex].value){
NewOpt = new Option;
NewOpt.value = getProd_list.p_num[i];
NewOpt.text = '(' + getProd_list.p_num[i] +
') '+ getProd_list.p_name[i] ;
document.all.PartList.options[olen++] =
NewOpt;
}
}
}


the partlist function is called when a product is selected. It will loop
through the list and get all the parts for that product.

Hope this help!

Thanh

-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 11:31 AM
To: CF-Talk
Subject: OnSelect Javascript code


I am looking for a onSelect javascript code that has the same type of
ability as the popular CFTwoRelatedSelects Custom Tag. Basically I want
field 2 to change dynamically from the selection of field 1. Both fields
are being populated from the database. Anybody got something like that?


James

~~
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: Displaying of HTML in page?

2001-12-12 Thread Garza, Jeff

Actually either will produce the HTML Code, the formatting is different...

CFOUTPUT
#HTMLCodeFormat(bthis is some Text/b)#
BR
BR
#HTMLEditFormat(bthis is some Text/b)#
/CFOUTPUT

HTMLCodeFormat() will output the string wrapped with PRE tags.

HTMLEditFormat() will output the string without PRE tags.


Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 11:23 AM
To: CF-Talk
Subject: RE: Displaying of HTML in page?


actually I believe it's HTMLEditFormat()

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+

...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 10:03 AM
To: CF-Talk
Subject: RE: Displaying of HTML in page?


HTMLCodeFormat(yourstring)

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 11:13 AM
To: CF-Talk
Subject: Displaying of HTML in page?


I am creating a forum for our site, and want to be able to display HTML 
code. How can I accomplish this where the browser will not try to render 
the code. Also if someone types in a link, I want that to display as a 
clickable link and not just text.


All help appreciated.




Doug







~~
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: javascript variables help!

2001-12-12 Thread Michael Bruce

What I have done is take the JavaScript Variables and WDDXd them and then
put the wddx packet into a hidden form field and submitted the form.

You will need the wddx.js file that comes with CF. If you don't have it
email me off list and I will send it.


Mike
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 12:58 PM
Subject: javascript variables help!


 Hi all,

 In one of my pages, I have a javascript array.  How do I pass it to the
next
 page to do some calculation using both Coldfusion and javascript?

 TIA,

 Thanh

 
~~
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: javascript variables help!

2001-12-12 Thread Alex

www.irt.org

On Wed, 12 Dec 2001 [EMAIL PROTECTED] wrote:

 Hi all,
  
 In one of my pages, I have a javascript array.  How do I pass it to the next
 page to do some calculation using both Coldfusion and javascript?
 
 TIA,
  
 Thanh
 
 
~~
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



(Complete) ColdFusion Function reference?

2001-12-12 Thread Tyler Silcox

Is there a complete CF function reference in existence?  I seem to remember
seeing something online at some time in my ColdFusion developing history,
but I can't find one when I need too, and I'm very intrigued to see what
#CFusion_VerifyMail# does.  (If it's even accessible, I found in by using
GetFunctionList.)  I have a few books, but none have a complete list with
examples...

Tyler
~~
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: (Complete) ColdFusion Function reference?

2001-12-12 Thread Semrau, Steven L Mr RDAISA/SRA

Check it out at the House of Fusion (http://www.houseoffusion.com/) ... 4th
link down.

-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 2:14 PM
To: CF-Talk
Subject: (Complete) ColdFusion Function reference?


Is there a complete CF function reference in existence?  I seem to remember
seeing something online at some time in my ColdFusion developing history,
but I can't find one when I need too, and I'm very intrigued to see what
#CFusion_VerifyMail# does.  (If it's even accessible, I found in by using
GetFunctionList.)  I have a few books, but none have a complete list with
examples...

Tyler

~~
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: (Complete) ColdFusion Function reference?

2001-12-12 Thread Michael Dinowitz

Look at the front of House of Fusion (www.houseoffusion.com). I have a 
complete function list there.
The function your asking about queries a mail server to see if it is 
operating properly. The attributes are in the list.

At 02:13 PM 12/12/01, you wrote:
Is there a complete CF function reference in existence?  I seem to remember
seeing something online at some time in my ColdFusion developing history,
but I can't find one when I need too, and I'm very intrigued to see what
#CFusion_VerifyMail# does.  (If it's even accessible, I found in by using
GetFunctionList.)  I have a few books, but none have a complete list with
examples...

Tyler

~~
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



searches

2001-12-12 Thread Troy Montour

Hello everyone,
I'm getting a new project and want to plan for it so I'm not trying 
to figure it out at the last minute.

whats the best way to set-up a search engine on a site to search through 
the whole site and give you a list of pages with what your searching for 
so you can jump directly to that page.

version of CF to get it working in is 4.5

any suggestions would be great.

Thank You
Troy Montour


~~
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



Stupid a** CFGRID!

2001-12-12 Thread Angel Stewart

Error Diagnostic Information
The table 'activity_code_tbl' contained no columns in the grid 'RELORA'.


This error may have been caused by not specifying the table name in the
format which the ODBC data source expects (e.g. SQL Server table names
must be qualified with the database name and table owner, as in
'customers.dbo.orders').


I get that error everytime I try to do a CFGRIDUPDATE ona  table in an
Oracle database.

Now, simply giving the table name works with ALL other controls!

I haven't even added CFGRID Columns yet, and when I DID specify the
columns it did not make a difference.

Has ANYONE used this goddamned control ata ll? 

If I have to pay for another frigging Single INCdente support sh** for
this blasted control I will pitch this whole fr***ing computer ou thte
goddamned window!

I don't iknow who the f*** told these people about the 'Grids' in
CF..but If I find out I will f***ing STRANGLE his a**!


-Gel

~~
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



CFHTTP.FileContent - parse string - then save

2001-12-12 Thread Gilbert Midonnet

OK,

I'm getting there. 

I'm trying to pull data from a page, manipulate it and save the result as a
new file on my HD, and later to make this a CRON job. 


I'm using CFHTTP to pull a page. WORKS
I'm parsing the page. WORKS
Trying to save the resulting page. It doesn't work. 

Any help will be greatly appreciated. Abbreviated code below.


cfhttp
URL=http://www.aaa.com/bbb/ccc/ddd/eee.html;


cfset removeStuff=#CFHTTP.FileContent#

cfoutput

#RemoveChars(removeStuff,1,1323)#

/cfoutput



 
This message is for the named person's use only. It may contain
confidential, proprietary or legally 
privileged information. No confidentiality or privilege is waived or lost by
any mistransmission. If 
you receive this message in error, please immediately delete it and all
copies of it from your 
system, destroy any hard copies of it and notify the sender. You must not,
directly or indirectly, 
use, disclose, distribute, print, or copy any part of this message if you
are not the intended 
recipient. 



~~
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



OT: Exporting an Access report

2001-12-12 Thread Bruce, Rodney (Contractor)

Hello everyone

I know this is OT, but I am using CF on the web site ;o}
But the powers that be want to gather information from a web site
into an ACCESS db and then use ACCESS to create the reports(no problems so
far).
Now they want the reports to be able to be reviewed using MS Word.
After playing around some I can only find out how to export to Excel
and then all the formatting is lost as well as the report headers and
footers.
Is there a way to export ACCESS reports with out losing all the
formatting?
My guess is that they want this so that the reports can be emailed
around while reviewing and some don't have access to ACCESS.

Thanks for any help,
Rodney
~~
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: searches

2001-12-12 Thread Will Swain

use verity, it comes with cfserver. I have found it to be quite simnple to
set up, and it will index html pages, database tables, pdf's, word documents
etc.

HTH

will

-Original Message-
From: Troy Montour [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 19:36
To: CF-Talk
Subject: searches


Hello everyone,
I'm getting a new project and want to plan for it so I'm not trying
to figure it out at the last minute.

whats the best way to set-up a search engine on a site to search through
the whole site and give you a list of pages with what your searching for
so you can jump directly to that page.

version of CF to get it working in is 4.5

any suggestions would be great.

Thank You
Troy Montour



~~
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



  1   2   >