RE: CF 5, Java, Solaris

2002-02-01 Thread Jeff Sarsoun 

I recall having CF4.5 crashing if a wrong path was specified for the jvm 
in
the CF administrator.  Again this was 4.5.

Jeff Sarsoun

-Original Message-
From: Kevin Cundick [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 3:56 PM
To: CF-Talk
Subject: CF 5, Java, Solaris


Hi All,

Has anyone experienced trouble using Java 1.3.1 with Solaris
8 and ColdFusion 5?

I am having trouble with it crashing the server every time I
call a Java Custom Tag.  I am currently working to Migrate
to ColdFusion 5 from CF 4.5.1.  We run Java 1.2.2 on CF 4.

Thanks!!

Kevin Cundick
Webmaster
Flying J Inc

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: Creating ZIP archives

2002-01-08 Thread Jeff Sarsoun 

I wrote a java CFX tag that does exactly this.  Email me off list if you
would like try it.

JS

-Original Message-
From: Nick Texidor [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 6:39 PM
To: CF-Talk
Subject: Creating ZIP archives


Hi,

I have a requirement to zip up some image files together and FTP them to
another server.  The FTP bit is easy, but I'm wondering if anyone knows
how (or whether there are any modules) that will create a ZIP file.

Thanks

Nick


--
Nick Texidor

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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: Creating ZIP archives

2002-01-08 Thread Jeff Sarsoun 

Assuming cfexecute isn't disabled.  That's how the tag came into being.

JS

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 3:40 PM
To: CF-Talk
Subject: Re: Creating ZIP archives


Alternately, you can use CFExecute and a command line program like PKZip.

- Original Message -
From: Jeff Sarsoun [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, January 08, 2002 2:21 PM
Subject: RE: Creating ZIP archives


 I wrote a java CFX tag that does exactly this.  Email me off list if yo
u
 would like try it.

 JS

 -Original Message-
 From: Nick Texidor [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 07, 2002 6:39 PM
 To: CF-Talk
 Subject: Creating ZIP archives


 Hi,

 I have a requirement to zip up some image files together and FTP them t
o
 another server.  The FTP bit is easy, but I'm wondering if anyone knows
 how (or whether there are any modules) that will create a ZIP file.

 Thanks

 Nick


 --
 Nick Texidor



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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: More locking confusion...

2001-05-01 Thread Jeff Sarsoun 

Was duplicate() not broken previous to sp2?

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 10:15 AM
To: CF-Talk
Subject: RE: More locking confusion...


 The hotfix download page says the problem exists in v4.51 SP2
 but then goes on to say This fix is only available to CF Server
 Enterprise customers.

 Does this mean that the problem is only with the Enterprise
 version? Or are they only providing a fix for Enterprise customers
 leaving Pro customers vulnerable?

There's a separate patch for Pro. Unfortunately, I don't know where on the
Allaire site it can be found. You might have to contact Allaire tech
support.

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Maybe a silly question.

2001-04-05 Thread Jeff Sarsoun 

I have run into this situation in the past.  I never came up with a concrete
cause but found if I limited the output formatting it worked i.e. no
tables).

I think it had to do with buffers in the browser.

Jeff

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 10:11 AM
To: CF-Talk
Subject: RE: Maybe a silly question.


I thought out that as well, however this is a dynamic query
that the results of the query changes frequently. It is
not cached.

I have consider timeouts on the server however, I can turn
right around and execute another query with less results
and they will display. This happens infrequently. Maybe once
every 10 queries or so.


-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 9:47 AM
To: CF-Talk
Subject: Re: Maybe a silly question.


Is the query cached?  I've had this problem with cachedwithin in the past.

Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com

- Original Message -
From: ""Adkins, Randy"" [EMAIL PROTECTED]
Newsgroups: dotcom.lists.cftalk
Sent: Thursday, April 05, 2001 2:18 PM
Subject: Maybe a silly question.


 Okay this might be off the wall, but it escapes me as to the reasoning of
 this.

 I have a query that runs and generates between 200-2000 records to be
 displayed
 to the user. When the record count is low say below 300 or 4000, it will
 spit out
 the desired results without a problem.

 However when the record count is higher, say once the query is completed
and
 it will display a BLANK Page. No out put or anything. If you view the
source
 of it,
 you will see the following:

 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
 HTMLHEAD
 META http-equiv=Content-Type content="text/html;
 charset=windows-1252"/HEAD
 BODY/BODY/HTML

 I have no MAXROWs or Aborts or EXIT tags that would prevent this from
 displaying
 the appropriate data.

 Any ideas?

 Thanks in advance.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

browser trail

2001-04-04 Thread Jeff Sarsoun 

Could someone shed some light on which browser leaves "Microsoft Data Access
Internet Publishing Provider Cache Manager" as it's calling card?

Jeff


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Threaded Discussion App with Tree view...??

2001-02-22 Thread Jeff Sarsoun 

Try this one.
http://www.coldfusiontags.com/message_board/index.cfm

-Original Message-
From: BORKMAN Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:36 AM
To: CF-Talk
Subject: Threaded Discussion App with Tree view...??


Hi all,

A year or so back, I ran across a CF app for building multiple threaded
discussions.  I seem to recall that you couldn't download a demo, and you
couldn't buy it with credit card over the net (around $US100, I think).
However, it looked fantastic, showed full tree views of threads, included
IE-popups of message content when you point at the message title, pretty
colors, etc.  It claimed to handle the whole thing in a single Custom Tag.

Does anyone recall this product, and where I can find it?  I have searched
the Allaire Dev Gallery, but I can't find anything like it.  there are
plenty of discussion apps, but none as elegant as this one.

Thanks very much,
Lee Bjork Borkman
http://Bjork.net - ColdFusion Tags by Bjork



IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Java CFX Tags

2001-02-17 Thread Jeff Sarsoun 

Nick,

Connecting to a ssl server is possible through JAVA ala JSSE and JDK1.2.
http://java.sun.com/products/jsse/

You should be able to modify your existing cfx tag to implement https
support.

Although I haven't had an occasion to use cfhttp with a https url I believe
that it was possible.  Borrowing advice from David Watts you could use a
recording proxy to log the conversation between the servers.  The two he
recommends are:

Stretch
http://www.kestral.com.au/devtools/

HTTPSniffer (requires Perl)
http://www.compansr.demon.co.uk/

Hope this helps.

Jeff Sarsoun




 -Original Message-
 From: Nick Texidor [mailto:[EMAIL PROTECTED]]
 Sent: Friday, February 16, 2001 4:48 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Java CFX Tags


 Hi Jeff,

 If only I knew!!  :^)

 Where do I start?  It's been a long week!

 Ok, I need to call a secure server in order to send an sms message.  Using
 CFLOCATION was a big no-no because it exposed the URL it was posting to.
It
 also meant I had to go through 3 pages to complete all the database
updates
 etc.

 So I looked at CFHTTP, this meant I could post to this page, and then
 continue in the same script, and hide the URL.  Great I thought.

 Except it wasn't.  I just could not get it to work.  I have tried it on
four
 different servers

 1) My machine, CF4.5.1 SP2, NT4 + SP6.  Continually for a connection
failure

 2) Server where site is hosted, CF4.5, Win2K.  Same problem

 3) Our Allaire VAR.  CF 4.5, NT4.  Same problem.

 4) Another web server hosting our site, CF4.02, NT4 + SP5.  WORKS!!

 So based on this information, I'm assuming there are some changes to
CFHTTP
 between 4.02 and 4.5.

 So anyway, I looked at writing a Java tag.  And after spending an age
trying
 to get the CF Server set up for it, only to discover that using Java, you
 can't connect to a secure server using the URL Connection.  It bombs if
you
 try and use HTTPS.   I dare say there is a way around it.  But time is not
 on my side.

 Fortunately, the site I'm trying to link to also has a telnet service. So
I
 managed to change the tag I was writing to use Sockets and connect to
that,
 and it worked a treat!

 If your tag will help with the CFHTTP problem, it would be great, I can
see
 I'm going to need to do this again and again with this ongoing project.

 Thanks

 Nick



  From: "Jeff Sarsoun" [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  Date: Fri, 16 Feb 2001 13:57:02 -0500
  To: CF-Talk [EMAIL PROTECTED]
  Subject: RE: Java CFX Tags
 
  Nick,
 
  I have a beta version of a java cfx tag that is helping me get around
some
  issues I had with cfx_http and cfhttp.  What is it that your having a
  problem with and what version of cf are you using?  cf 4.5.2 cures some
  cfhttp issues.
 
  Jeff
 
  -Original Message-
  From: Nick Texidor [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, February 15, 2001 9:58 PM
  To: CF-Talk
  Subject: Java CFX Tags
 
 
  Hi,
 
  Due to some problems I'm experiencing with CFHTTP, I'm having to look at
  writing a CFX tag to achieve something I'm trying to do.
 
  I'm wondering what the lists experiences are of Java Tags with regards
to
  performance, development etc.
 
  tia
 
  N
 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Java CFX Tags

2001-02-16 Thread Jeff Sarsoun 

Nick,

I have a beta version of a java cfx tag that is helping me get around some
issues I had with cfx_http and cfhttp.  What is it that your having a
problem with and what version of cf are you using?  cf 4.5.2 cures some
cfhttp issues.

Jeff

-Original Message-
From: Nick Texidor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 9:58 PM
To: CF-Talk
Subject: Java CFX Tags


Hi,

Due to some problems I'm experiencing with CFHTTP, I'm having to look at
writing a CFX tag to achieve something I'm trying to do.

I'm wondering what the lists experiences are of Java Tags with regards to
performance, development etc.

tia

N
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Re: ParseDog

2001-02-16 Thread Jeff Sarsoun 

Take it outside (CF_COMMUNITY)!

-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 1:46 PM
To: CF-Talk
Subject: OT: Re: ParseDog


First off:  I am posting this because I do not want to look like the lier.
Its OT, sorry...but it must be addressed.

 That might explain why you saw it for $20?

You lied, I saw it for 20.  At least admit it you prick.  You were selling
it for $20.00 and you didn't think anyone on the list went to the page.  You
changed it to free so you could argue that its open source and not an
advertisement.  I saw it for $20.00 and you know it ASP_@$$HOLE.

--=@ greg @=--

cf_hack/databases/aloha.mdb/cf_hack
- Original Message -
From: "John Anderson" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, February 16, 2001 1:02 PM
Subject: RE: ParseDog


 You lier.  You just made it open source.  When I went to the page before
it
 said it costs $20.00 for the source.  You just updated it, to make it
free.

 Yeah Im sure you are correct Greg the code I used is this (free too):

 You can only do this in

 CF-MAYBE-ASP-WITH-FUSEBOX-ON-A-FRIDAY-LIST syntax

 %
 if assdetect = 1 then
 price = $20
 end if
 %

 That might explain why you saw it for $20?








 -Original Message-
 From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
 Sent: Friday, February 16, 2001 9:33 AM
 To: CF-Talk
 Subject: Re: ParseDog


  Lord Heath - The ASP Page is because this is "ASP Fusebox" and
Illustrates

 This isn't the FUSEBOX LIST.  It is CF-TALK, NOT
 CF-MAYBE-ASP-WITH-FUSEBOX-ON-A-FRIDAY-LIST

  ParseDog is a Cold Fusion app and it is a free Open Source Resource for
  Anyone who would like to use:

 You lier.  You just made it open source.  When I went to the page before
it
 said it costs $20.00 for the source.  You just updated it, to make it
free.

 --=@ greg @=--
 - Original Message -
 From: "John Anderson" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Friday, February 16, 2001 12:13 PM
 Subject: RE: ParseDog


  Thanks to all you wonderful Individuals that have contributed your vast
  knowledge and comments!
 
  Lord Heath - The ASP Page is because this is "ASP Fusebox" and
Illustrates
  the whitepaper which can be viewed here:
  http://aloha-webdesign.com/dloads/asp/aspfusebox.htm
 
  ParseDog is a Cold Fusion app and it is a free Open Source Resource for
  Anyone who would like to use:
  http://www.aloha-webdesign.com/index.asp?fuseaction=detailspid=14
 
  I appreciate people keeping the resource of this list free from bull@#@#
  stuff.
 
  I was just trying to present something that the community may find
useful.
 
  Wow You would think people could be a bit more relaxed on a Friday??
 
  John Anderson
  http://www.aloha-webdesign.com
 
  -Original Message-
  From: Lord, Heath [mailto:[EMAIL PROTECTED]]
  Sent: Friday, February 16, 2001 9:05 AM
  To: CF-Talk
  Subject: RE: ParseDog
 
 
  The worst part is it is not even a ColdFusion app, its an ASP page...
 
  -Original Message-
  From: John Anderson [mailto:[EMAIL PROTECTED]]
  Sent: Friday, February 16, 2001 11:03 AM
  To: CF-Talk
  Subject: ParseDog
 
 
  I just put a demo app of ParseDog up on my site.
 
  http://www.aloha-webdesign.com/index.asp?fuseaction=detailspid=14
  ParseDog will parse an entire application for:
 
  Custom Tags
  *Allows you to change custom tag calls to cfmodule calls.
  *Ensures that the custom tags called exist.
  *Will resolve case sensitivity issues when calling custom tags.
  Includes
  *Ensures that includes, form actions, and hrefs reference the proper
 files.
  *Verifies case sensitivity for includes, form actions, hrefs.
  *Resolves pathing for the files referenced in your application.
  Good for finding errors.
 
  John Anderson
  http://www.aloha-webdesign.com
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFHTTP Link Checker?

2001-02-10 Thread Jeff Sarsoun 

You could pull all http, mailto, ftp links that are submitted into a table,
then run a scheduled task to:

1. (4.X) use cfx_http to get the response header that is returned.
2. (4.5) use cfhttp to "get" the "CFHTTP.StatusCode"

Beware- both techniques have returned errors on certain urls, which stops
the template from processing any more urls.  The cfhttp tag has a timeout
option but doesn't always seem to catch server problems.

I have a java cfx tag that is in beta form that seems to by-pass some of the
above problems.

If interested in experimenting with the tag, email me off-list and I'll send
it to you.

Jeff Sarsoun
[EMAIL PROTECTED]

-Original Message-
From: John B Venable Jr [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 11:00 PM
To: CF-Talk
Subject: CFHTTP Link Checker?


Is there any way to check for the validity of HTML links by using Cold
Fusion. If so, any resources to explain how would be of great help.

TIA.

--
John B. Venable Jr.

it took men about five thousand years, counting from the beginning of
number symbols, to think of a symbol for nothing.
--Isaac Asimov


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFHTTP Link Checker?

2001-02-09 Thread Jeff Sarsoun 

You could pull all http, mailto, ftp links that are submitted, submit them
to a table then run a scheduled task to

1. (4.X) use cfx_http to get the response header that is returned.
2. (4.5) use cfhttp to "get" the "CFHTTP.StatusCode"

Beware- both techniques have returned errors on certain urls, which stops
template from processing any more urls.  The cfhttp tag has a timeout option
but doesn't always seem to catch server problems.

I have a beta cfx tag that is written in java that seems to by-pass some of
the above problems.

If interested in experimenting with the tag, email me off-list and I'll send
it to you.

Jeff Sarsoun
[EMAIL PROTECTED]


-Original Message-
From: John B Venable Jr [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 08, 2001 11:00 PM
To: CF-Talk
Subject: CFHTTP Link Checker?


Is there any way to check for the validity of HTML links by using Cold
Fusion. If so, any resources to explain how would be of great help.

TIA.

--
John B. Venable Jr.

it took men about five thousand years, counting from the beginning of
number symbols, to think of a symbol for nothing.
--Isaac Asimov


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cf error page in application.cfm

2001-01-25 Thread Jeff Sarsoun 

One way to get possible answers to questions quickly is to search the
archives at http://www.mail-archive.com/cf-talk@houseoffusion.com/

particularly
http://www.mail-archive.com/cgi-bin/htsearch?config=cf-talk_houseoffusion_co
mrestrict=exclude=words=cferror+cf+code in your case.

This list has been around for a long time and chances are good your question
has been asked and answered previously.  Last I knew Mike had all the posts
from day one.

This list has more value than a place to send an email and hope someone can
respond quickly (view posts about list lag time), it has a wealth of
knowledge archived.

**newbies**
Spend some time in the archives and you'll find answers to questions you
didn't know to ask.

Jeff Sarsoun




-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 12:34 PM
To: CF-Talk
Subject: cf error page in apllication.cfm


Hello,

I have a process on our web server's dynamic home page accessing data.
Whenever the dynamic data connection fails, instead of display the standard
CF error page, it displays a static version of our home page.

This process works OK. I was wondering if there is a way to incorporate
additional CF code in that CF error page that also emails our webteam that a
static page is displaying because of a bad connection.

Is the default error page specified in the application.cfm file just a
static page or can it display an error and also do other processes? Is there
another area in CF that can handle this?

Thanks.

Robert O.
web admin
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Continuous Clock

2001-01-25 Thread Jeff Sarsoun 

I don't know about the JAVA applet that refreshes the whole page to show the
sys time. I do know that most applets use a technique that just re-draws the
paint method, many can be found with a search of clock applets on any search
engine.

Jeff Sarsoun

-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 12:09 PM
To: CF-Talk
Subject: RE: Continuous Clock


Java is the only way - and even that is rusty at the best of times - the
worst I've seen involved http refresh every second

James

-Original Message-
From: Cami Lawson [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2001 16:50
To: CF-Talk
Subject: Continuous Clock


I have a display clock that shows the time the user accessed the page but
now they want a clock that shows the current time continuously.  I have
figured out countdown timers but is there an easy way to display the current
time continuously?

TIA
cami
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: how to make bar, line chart in ColdFusion

2001-01-25 Thread Jeff Sarsoun 

That depends on how elegant you want it to be.  You can simply make 1X1
pixel  graphic, put it inside of a table then dynamically draw a bar by
assigning the height of the graphic to a variable.

Quick, simple and small.

Jeff Sarsoun

-Original Message-
From: George Dong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 3:44 PM
To: CF-Talk
Subject: how to make bar, line chart in coldfusion


Hi there,
If anyone can tell me how to make chart(line, bar) by cold fusion. if the
only way to call java applet?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: how to make bar, line chart in ColdFusion

2001-01-25 Thread Jeff Sarsoun 

There are many custom tags in the tag gallery web site for charts some use
java some don't.

http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=chart

-Original Message-
From: George Dong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 3:44 PM
To: CF-Talk
Subject: how to make bar, line chart in coldfusion


Hi there,
If anyone can tell me how to make chart(line, bar) by cold fusion. if the
only way to call java applet?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread Jeff Sarsoun 

Do a search on this lists archives, you should find information on accessing
a dts as a com object.
 http://www.mail-archive.com/cf-talk@houseoffusion.com/

Jeff Sarsoun

-Original Message-
From: Percy E Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 1:14 PM
To: CF-Talk
Subject: Running a MS SQL Server DTS Package from ColdFusion


Anyone has any suggestions on how to run a DTS package from a coldfusion
page?
I found article# Q252987 on technet on how to do this using ASP, but I
would rather implemented in ColdFusion.  Thank you for any suggestions.


Percy E Perez


 -Original Message-
 From: Clint Tredway [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 16, 2001 11:59 AM
 To: CF-Talk
 Subject: RE: SQL Manager


 Yep, this will be taken care of soon.

 -Original Message-
 From: Neil Clark [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 16, 2001 10:44 AM
 To: CF-Talk
 Subject: RE: SQL Manager


  yep, I would NEVER want anyone connecting to the Master DB.
 I always keep
 my SQL Servers on the inside of the firewall allowing no
 access from the
 outside world - only from the cf server.

 Neil

 ! ---
 Neil Clark
 Senior Web Applications Engineer
 ColdFusion / Spectra / XML
 mcb digital [Allaire Premier Partner]
 Tel. +44 (0)20 8941 3232
 Tel. +44 (0)20 8408 8131 [Direct]
 http://www.mcbdigital.com
 ---

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Complex Database System

2001-01-11 Thread Jeff Sarsoun 

Talk to webserve @ LMCO EIS in Orlando, they have projects that are written
in CF.

-Original Message-
From: Foggy, Doreen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 1:28 PM
To: CF-Talk
Subject: RE: Complex Database System


Thanks Brian



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:45 AM
To: CF-Talk
Subject: RE: Complex Database System


Let me see if I can help clarifyyou're asking if CF can be used as the
front end for a complex database?

The answer is...OF COURSE!  And it will do it in a much more maintainable
way than ASP will.

If the database is properly designed, it doesn't matter what front end you
put on it.
If the database is poorly designed, it won't matter what front end you put
on it.

CF and ASP don't have any significant differences as far as functionality
goes.  They have a great deal of difference as far as speed of development
and ease of maintainance goes.  CF wins both hands down.

Brian



-Original Message-
From: Foggy, Doreen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:11 AM
To: CF-Talk
Subject: Complex Database System


Hi everyone,

I wanted to know if anyone in the forum has developed a hard core
interactive database system using ColdFusion as the front end and SQL SERVER
7.0 as the backend.  Does anyone know if there are any examples on the web.
I have seen allot of ColdFusion sites but none of the ColdFusion sites are
utilizing complex data structures.  I am trying to convince upper management
to use ColdFusion has the front end verses Active Server Pages for a SQL
SERVER 7.0 database system used by all levels of management has a finance
tool.  Please advise...and if there are examples on the web please let me
know.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Questions for Certification

2001-01-10 Thread Jeff Sarsoun 

The answer is b.

When you create a cfx tag in java you have the three available to you for
development.

Jeff Sarsoun

-Original Message-
From: Rajesh Kumar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 3:19 PM
To: CF-Talk
Subject: Questions for Certification


Hi All,

Though I have cleared the exam of BrainBench and eCertifications.com but I
am confused about the answers to the following questions. Could you people
help me out!

1. When creating a CFX tag using Java, what does the
\cfusion\java\class\cfx.jar file contain?

A. Transaction Object, CF Object, Query Object
B. Request Object, Response Object, Query Object
C. Step Object, Request Object, Responce Object
D. Process Object, Status Object, Request Object
E. Status Object, Response Object, CFQuery Object

Answer: ?

2. Sample Code:
1 CFIF NOT IsAuthenticate("Admin")
2 CFTRY
3 CFAUTHENTICATE SECURITYCONTEXT="Edge" USERNAME=#user# PASSWORD=#pwd#
4 CFCATCH TYPE="Security"
5 Access denied. /CFCATCH/CFTRY/CFIF
  Which of the lines in the above code contains an error?

A. Line 3
B. Line 1
C. Line 5
D. Line 4
E. Line 2

Answer: ?

3. 1   (Less Than)
2  (Greater Than)
3 ' (Single Quote)
4 " (Double Quote)
5 % (Percent)
  The function XMLFormat(string) is used to create an XML safe string. Which
of the following characters does it filter?

A. 1,2,3
B. 3, 4
C. 1,2,3,4
D. 3,4,5
E. 1,2,5

Answer: ?

4. Which of the following is a list of valid CFCACHE parameters?

A. ClientCache, Write, Flush, and Cache
B. Cache, Optimal, Flush, and ClientCache
C. Cache, Write, Read, and Optimal
D. Write, Flush, ClientCache, and Optimal
E. Cache, Write, Flush, and Optimal

Answer: ?

5. What is the name of the page that is similar to the application.cfm but
is run after the main page is done?

A. Application2.cfm
B. ApplicationEnd.cfm
C. OnPageEnd.cfm
D. OnRequestEnd.cfm
E. PageEnd.cfm

Answer: ?

6. Sample Code:

CFSET Txt = Evaluate("CALLER.#ATTRIBUTES.VariableName#")
CFSET Txt = Replace("#Txt#", "_", "x", "ALL")
CFSET Txt = SetVariable("CALLER.#ATTRIBUTES.VariableName#",Txt)
  When the above module is called with cfmodule template="sample.cfm"
VariableName="Text_Var", what is the result?

A. Recurse the caller routine until all characters are x.
B. Blank the value of the variable Text_Var.
C. Double call the caller routine backwards.
D. Remove all _ symbols from the contents of the variable Text_Var.
E. Change the name of the variable Text_Var to TextVar

Answer: ?

7. Which of the following a valid ACTION within the CFTRANSATION tag?

A:   END
B:   ROLLOVER
C:   READ
D:   COMMIT

Answer: ?

8. When working with CFSLIDER attributes, CFSLIDER NAME="Lyk" RANGE="1,10"
SCALE="1" VALUE="5", the VALUE attribute indicates

A:   the number of values.
B:   the starting value.
C:   the highest real value.
D:   none of the above.

Answer: ?

9. While using the CFFILE tag with the UPLOAD action, which File variable is
not matched correctly with the return?

A:   File.FileExisted: indicates whether a file already exists in the
specific directory
B:   File.ServerFile: the filename a file was saved as on the server
C:   File.ServerFileName: the filname and extension of the file that was
uploaded to the server
D:   File.OldFileSize: the size of the file that was overwritten by the
uploaded file

Answer: ?

10. To reduce the file size of ColdFusion templates by reducing white space
from the Administrator select  within the Server section.

A:   Limit file size
B:   Enforce suppression
C:   Suppress white space by default
D:   Eliminate white space

Answer: ?

11. HTML and JAVASCRIPT are supported within an error template.

A:   True
B:   False

Answer: ?

12. In a SQL query, if a subquery will return more than one result, it must
be placed in the

A:   WHERE clause
B:   FROM clause
C:   SELECT clause
D:   GROUP by clause

Answer: ?

13. Which of the following is false regarding the CFOBJECT tag?

a. Skip Question
b. Using CFOBJECT, any automation server object type that is currently
registered on a machine can be invoked
c. CFOBJECT allows you to create and use COM (Component Object Model)
objects
d. Using CFOBJECT, you can use a utility like Microsoft's OLEView to browse
COM objects
e. All the above

Answer: ?

14. What is the purpose of the Delay Evaluation (DE) function in Cold
Fusion?

a. Skip Question
b. Returns its argument with double quotes wrapped around it and all double
quotes inside it escaped
c. Prevents the evaluation of a string as an expression when it is passed as
an argument to IIf or Evaluate
d. Both a and b
e. None of the above

Answer: ?

15. What is the purpose of the Network Listener Module (NLM)?

a. Skip Question
b. NLM is a Java applet used to listen for incoming messages and redirect
them to the standard Cold Fusion server
c. NLM is only used on the Unix Operating System
d. NLM is a

RE: remote server response

2001-01-08 Thread Jeff Sarsoun 

Jennifer,

I'm finishing up a CFX tag that will do what you need.  Right now what you
can do is write a script that will parse through your templates extracting
out http, ftp, or mailto: tags.  You can dump these into a table then as a
scheduled task you could cfx_http to the address to get the response code
from the server, then not show the link if it returns anything other than
200 and send you an email to let you know.

Jeff Sarsoun

-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 3:09 PM
To: CF-Talk
Subject: remote server response


I'm looking for ideas because I'm not sure how to go about this. I'm
setting up some pages that are going to have links to external sites. I
know how bad it looks to have broken links so I'd like to check the links
on a schedule and remove any links that are broken. I'll still get some
broken inks but it's better than using up my server resources checking
links every time a page loads. At any rate, I'm not sure quite how to check
the links in the way I'd like to. I'm considered trying
CFHTTP method="get" ... throwonerror="yes"
but I'm not sure that it will do what I want it to do. In some cases I want
to make sure that the server is responding (because I don't have a specific
file to point to) and in some cases I want to make sure there isn't a 404
error (because I do have a specific file to point to). This would probably
work for a 404 error but frankly, I didn't understand the section of the
CFML Language Reference that talked about whether a filename is required
for CFHTTP. To be honest, I don't even want to get the file-- I just want
to make sure it is available. I don't have access to these servers so I
can't put a dummy file on the server to get to make sure the server is
responding.

Is there a better way to do this that I'm missing? Ideas?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: The +.htr bug strikes again

2000-12-21 Thread Jeff Sarsoun 

There are two sides to this issue. 1. Releasing bug/vulnerability
information to the public will release hoards of script kiddies to cause
havoc and dismay instantaniously without recourse.  2. Releasing
bug/vulnerability information will cause industry leaders like Microsoft and
respectively Allaire to act on the information sooner than later.

I can see both sides of the fence but would lean to alerting the public to
the problem.  Security by obscurity is not a good policy to live by.

Jeff

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 1:38 PM
To: CF-Talk
Subject: Re: The +.htr bug strikes again


Don't you think it would have been better to wait until after Hasbro
patched it to alert a list of hundreds of developers?  I often run
across cf sites with the htr bug (it's hardly uncommon).  I usually
email the webmaster personally, as opposed to the "Hey guys!  Look what
I found!"

Just out of curiosity (nothing against you Kevin): what are the legal
implications for something like this?  Even if it's just a hole which a
person could find on their own, can pointing it out be a cause for
liability?

--
Billy Cravens
[EMAIL PROTECTED]



Kevin Schmidt wrote:

 Check out Hasbro Interactive.  They run entirely CF and haven't patched
the
 +.htr bug yet.  I alerted them to this fact.

 Kevin Schmidt, Web Technology Manager
 Allaire Certified Cold Fusion Developer
 pwb inc.
 integrated marketing communications
 350 S. Main St., Suite 350
 Ann Arbor, MI 48104
 734.995.5000 (tel)
 734.995.5002 (fax)
 www.pwb.com


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cftry cfcatch/cfcatch/cftry

2000-12-13 Thread Jeff Sarsoun 

Haven't tried it but theoretically you might be able to:

application.cfm would contain: cf_error_check
onrequestend.cfm would contain: /cf_error_check

error_check.cfm would contain:
!--pseudo code--
if executionmode eq start
cftry cfcatch
else
/cfcatch/cftry

onrequestend.cfm might choke on the /cf_error_check though.  Maybe some
parameter passing would be in order.

Jeff

-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 11:38 AM
To: CF-Talk
Subject: cftry cfcatch/cfcatch/cftry


I just found, disappointingly enough that you can't have a cftry at the
top of a document via a CFinclude and the rest in another include at the
bottom?  Is there a work around.  I don't want to use a handler, and I want
the same error checking code on every page.

Please advise or throw ideas (even bones will do)

Thanks,

Neil

p.s. Running CF 4.51.

- Original Message -
From: "Hales, John M" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 11:17 AM
Subject: RE: CFreport and crystal reports


 I could never get it to work. We just use CF to pass the parameters to
 Crystal, and the CR Web Server to display the reports. That works well for
 us.

 HTH
 Mike Hales

 -Original Message-
 From: Katie Bessiere [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 13, 2000 11:08 AM
 To: CF-Talk
 Subject: CFreport and crystal reports


 has anyone had any luck using CFREPORT with crystal reports 8?  i've tried
 the workaround that Allaire recommends and I still can't get the tag to
 work.  It's very frustrating..

 If anyone has any ideas, please let me know..

 katie

 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Allaire ColdFusion Sample Script DoS Vulnerability

2000-12-13 Thread Jeff Sarsoun 

This exploit should not effect most sites, considering sample code should
not be installed on a production server in the first place.  This goes back
to other exploits that exist due to sample code that was installed by
Allaire in previous versions.

Jeff Sarsoun

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 12:51 PM
To: CF-Talk
Subject: Allaire ColdFusion Sample Script DoS Vulnerability


http://www.securityfocus.com/frames/?content=/vdb/%3Fid%3D2094

Robert Everland III
Web Developer
Dixon Ticonderoga
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL 7.0 Question

2000-11-30 Thread Jeff Sarsoun 

Why the * ?

cfquery name="get_auctions" datasource="happytoad"
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
/cfquery

If your 'deleting' your all of the record anyway.

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.

cfquery name="get_auctions" datasource="happytoad"
DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
/cfquery

Here is the error:

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'*'.

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Confused about CFSCHEDULE

2000-10-30 Thread Jeff Sarsoun 

Try this.

cfset v_date = dateformat(#now()#,"MM/DD/")
cfset v_time = timeformat(#now()#,"HH:mm:ss")


cfoutput
cftry
cfschedule action="UPDATE" task="schedule_name"
operation="HTTPRequest"
url="url"
startdate= v_date starttime= v_time
interval="ONCE" resolveurl="No" publish="No"
cfcatch
bThe schedule was not created./bbr
/cfcatch
/cftry
/cfoutput



-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 4:03 PM
To: CF-Talk
Subject: RE: Confused about CFSCHEDULE


Well do I need to use action="run" when I want to add an event to the
schedule?

action="update" doesn't seem to do it, though the docs say I can use it to
add an event.  I don't see it happening??

*  -Original Message-
*  From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
*  Sent: Monday, October 30, 2000 3:16 PM
*  To: CF-Talk
*  Subject: RE: Confused about CFSCHEDULE
*
*
*  no, the CFSCHEDULE task allows you to interface with the cfadmin.
*
*  from the docs:
*
*  "CFSCHEDULE provides a programmatic interface to the
*  ColdFusion scheduling
*  engine. You can run a specified page at scheduled intervals
*  with the option
*  to write out static HTML pages. This allows you to offer
*  users access to
*  pages that publish data, such as reports, without forcing
*  users to wait
*  while a database transaction is performed in order to
*  populate the data on
*  the page."
*
*  best used for long running reports.  the user would fill out
*  some form, the
*  CFSCHEDULE tag would be used to...well, schedule the report,
*  with the data
*  passed (perhaps) in the URL called.
*
*  chris olive, cio
*  cresco technologies
*  [EMAIL PROTECTED]
*  http://www.crescotech.com
*



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

accessing a dts file using cfobject

2000-10-02 Thread Jeff Sarsoun 

Has anyone created a dts file in MS SQL7 and was able to access it using
cfobject?  I am getting the error:

Error trying to create object specified in the tag.
COM error 0x800401F3. Invalid class string
The error occurred while processing an element with a general identifier of
(CFOBJECT), occupying document position (9:1) to (9:74) in the template file
c:\myfile.cfm

code:
cfobject
Type="COM"
Action="create"
Class="DTS_NAME.DTS"
Name="dts_name"

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: (OT) making fields readonly with JavaScript

2000-08-31 Thread Jeff Sarsoun 

Yes, but make make sure you re-enable it if you want to use it on a called
template.

-Original Message-
From: John Andrichak IV [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 1:00 PM
To: [EMAIL PROTECTED]
Subject: Re: (OT) making fields readonly with JavaScript


There is a JavaScript element attribute "disabled."  Setting
"someFormField.disabled = true" will cause whatever "someFormField" is to be
grayed out.

John Andrichak IV
Web Programmer
Dannemiller Memorial Educational Foundation

 -Original Message-
 From: Jamie Keane [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, August 31, 2000 9:51 AM
 To: CFTalk
 Subject: (OT) making fields readonly with JavaScript


 Hi all, and I apologise for being off-topic, but this is driving me nuts!

 Is there a way to "disable" text field via JavaScript?  I know of the
 READONLY attribute, and the client likes how that works, but in my
research
 I was not able to come up with a way to access that attribute through JS.
 Any ideas?

 Thanks,
 Jamie

 --
 Jamie Keane
 Programmer
 SolutionMasters, Inc.
 9111 Monroe Rd., Suite 100
 Charlotte, NC  28270
 www.solutionmasters.com
 704.563.5559 x 228  Voice
 704.849.9291  Fax


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

upsizing access to SQL server

2000-08-09 Thread Jeff Sarsoun 


I am running into memo field issues when upsizing to SQL server 7.0?  I
have been trying to upsize an access2000 db to SQL server by using both the
wizard interface and "import data", but keep getting the error:

"error at destination for row #1, errors encountered so far in this task:1.
Query based insertion or updating of blob values can not be supported."

I searched the cf-talk archive web site for this error and found a couple
of entries but the fixes prescribed, such as using "import data" rather than
the upsize wizard, (which seem to be the same wizard), did not work for me.

I am selecting Microsoft Access as the source and Microsoft ODBC driver for
MS SQL server as the destination.  The default settings are using the ntext
data type by default for my Access memo fields.  If I continue I get the
above error for every table that has data in a memo field in my access db.
If I change the data type to varchar or nvarchar it works, then I can change
the datatypes back to ntext with no problems.

I have two problems with this work around.

1.  I have quite a few very large access databases that would require large
amounts of time to manually make these changes.

2.  Data loss could occur due to limits of varchar and nvarchar data types.

If anybody has experienced this, I would appreciate some input.

Thank you

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: upsizing access to SQL server

2000-08-09 Thread Jeff Sarsoun 

I was using ODBC initially.  I switched to OLE DB and that solved the issue.

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 11:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: upsizing access to SQL server


I've just run a small test here and had no problems.  I created an Access
database with 1 table in it with a memo field with data in it.

I then used then imported data into SQL using the Import wizard in SQL 7.  I
did this by selecting MS Access as the source, My SQL server as the
destination (selecting the datbase too), selected Windows NT authentication,
selected "Copy Table(s) from the source database", and it worked fine.  It
brought in the field as an nText.

Is this along the lines of what you tried?

-Original Message-----
From: Jeff Sarsoun [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2000 16:00
To: Cf-Talk@Houseoffusion. Com (E-mail)
Subject: upsizing access to SQL server



I am running into memo field issues when upsizing to SQL server 7.0?
I
have been trying to upsize an access2000 db to SQL server by using both the
wizard interface and "import data", but keep getting the error:

"error at destination for row #1, errors encountered so far in this task:1.
Query based insertion or updating of blob values can not be supported."

I searched the cf-talk archive web site for this error and found a
couple
of entries but the fixes prescribed, such as using "import data" rather than
the upsize wizard, (which seem to be the same wizard), did not work for me.

I am selecting Microsoft Access as the source and Microsoft ODBC
driver for
MS SQL server as the destination.  The default settings are using the ntext
data type by default for my Access memo fields.  If I continue I get the
above error for every table that has data in a memo field in my access db.
If I change the data type to varchar or nvarchar it works, then I can change
the datatypes back to ntext with no problems.

I have two problems with this work around.

1.  I have quite a few very large access databases that would require large
amounts of time to manually make these changes.

2.  Data loss could occur due to limits of varchar and nvarchar data types.

If anybody has experienced this, I would appreciate some input.

Thank you


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Line Breaks in Access Notes Field

2000-08-07 Thread Jeff Sarsoun 

Look into using the ParagraphFormat() function.



-Original Message-
From: John McKown [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 4:44 PM
To: CF_Talk
Subject: Line Breaks in Access Notes Field


This is a multi-part message in MIME format.

--=_NextPart_000_0002_01C0008E.B196A5D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

BEGIN QUESTION
When using CFOUTPUT, is there a way to make the data that is in Access Memo
fields wrap without losing the line breaks and without using the PRE tag.
/END QUESTION

WHY I AM ASKING
I have a customer with an access database that we "web-enabled" with CF.
He has a really long notes field that has employee comments in it, and each
comment starts on a new line with a line break.Some of the lines are
especially long, so using the HTML PRE tag is no good, because it makes
the page 2000 pixels wide

I had the data populating a text box and then he called complaining because
his customers could not print the page.
/WHY I AM ASKING

Thanks in advance
John McKown, VP of Business Services
Delaware.Net, Inc.
30 Old Rudnick Lane, Suite 200 - Dover, DE 19901
Dover: 302.736.5515, Toll Free: 888.432.7965, Fax: 302.736.5945
E-mail: [EMAIL PROTECTED], Web Site: http://www.Delaware.Net


Delaware.Net is now an official domain name registrar!
Register your domain names with us for only $20 per year!
Simply visit my company's web site at http://Register.Delaware.Net to get
started.
Or change your existing hosting to Delaware.net and save yourself money.






--=_NextPart_000_0002_01C0008E.B196A5D0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR/HEAD
BODY
DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000
DIVFONT face=3DArial size=3D2SPAN =
class=3D709373820-07082000lt;BEGIN=20
QUESTIONgt;/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000When =
using CFOUTPUT,=20
is there a way to make the data that is in Access Memonbsp;fields wrap =
without=20
losing the line breaks and without using the lt;PREgt;=20
tag./SPAN/FONT/DIV/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN =
class=3D709373820-07082000lt;/END=20
QUESTIONgt;/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D709373820-07082000/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN =
class=3D709373820-07082000lt;WHY I AM=20
ASKINGgt;/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000I have =
a customer=20
with an access database that we "web-enabled" with =
CF./SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000He has =
a really long=20
notes field that has employee comments in it, and each comment starts on =
a new=20
line with a line break.nbsp;nbsp;nbsp; Some of the lines are =
especially long,=20
so using the HTML lt;PREgt; tag is no good, because it makes the page =
2000=20
pixels wide :(nbsp;nbsp; /SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000I had =
the data=20
populating a text box and then he called complaining because his =
customers could=20
not print the page./SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000FONT =
face=3DArial=20
size=3D2SPAN class=3D709373820-07082000lt;/WHY I AM=20
ASKINGgt;/SPAN/FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000FONT =
face=3DArial=20
size=3D2SPAN =
class=3D709373820-07082000/SPAN/FONT/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D709373820-07082000FONT =
face=3DArial=20
size=3D2SPAN class=3D709373820-07082000Thanks in=20
advance/SPAN/FONT/SPAN/FONT/DIV
PFONT size=3D2John McKown, VP of Business ServicesBRDelaware.Net, =
Inc.BR30=20
Old Rudnick Lane, Suite 200 - Dover, DE 19901BRDover: 302.736.5515, =
Toll Free:=20
888.432.7965, Fax: 302.736.5945BRE-mail: A=20
href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A, Web Site: A=20
href=3D"http://www.delaware.net/"=20
target=3D_blankhttp://www.Delaware.Net/ABRBR=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DBRDelaware.Net=
=20
is now an official domain name registrar!BRRegister your domain names =
with us=20
for only $20 per year!BRSimply visit my company's web site at A=20
href=3D"http://register.delaware.net/"=20
target=3D_blankhttp://Register.Delaware.Net/A to get started.BROr =
change your=20
existing hosting to Delaware.net and save yourself=20
money.BR=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

RE: Dedicated Hosting and questions.

2000-04-05 Thread Jeff Sarsoun 

Check out the Message Board featured on Allaire's "Cool Tags".

-Original Message-
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 05, 2000 10:27 AM
To: [EMAIL PROTECTED]
Subject: Re: Dedicated Hosting and questions.


Bud,

I don't have any experience with WebBoard, but why not use one of the CF
message board applications out there?

http://www.cfboards.com/cfb/index.cfm?CFB=1

http://www.cfcode.com/cfforum2000/

Before I moved my site to a Cold Fusion server, I used DCForums for my
Message Board.  http://www.dcscripts.com  I have about 75 users, there are
about 200 posts per day, the admin functions are easy, the support is
incredible.  I've never had a problem with the board, and its very
economical - ($99).  I wish I had known I would be moving to a CF server and
used one of the above mentioned applications because I could then tie in my
log in to the site to the log in at the Forums I haven't figured out how
to do that with the Perl Scripts interacting with Cold Fusion.

What kind of chat application are you looking at?  I'm looking for one for
my site, but since my site is more of a hobby I'm not willing to shell out
the dough I've seen for chat applications.  Currently we're using
http://www.multichat.com and http://www.hearme.com both for the very
easy-to-handle price of Free. =)

Erika


- Original Message -
From: "Bud" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 05, 2000 5:15 AM
Subject: Dedicated Hosting and questions.


 Hi. I have a potential client that needs to run a good message board
 and chat system. I need some recommendations for for providers that
 offer dedicated ColdFusion hosting, and where I'd be able to install
 something along the lines of O'Reilly's WebBoard. I'm also open to
 suggestions for other Message Board/Chat systems and would like to
 hear of anyone's experiences, good or bad, with WebBoard.

 Thanks for any help/suggestions.

 Bud Schneehagen - Tropical Web Creations

 _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
 ColdFusion Solutions / eCommerce Development
 [EMAIL PROTECTED]
 http://www.twcreations.com/
 954.721.3452
 --

 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.