RE: Database Design Challenge!

2001-05-17 Thread JustinMacCarthy

A family Tree ? Say that word again  tree . That is exactly what you
want a tree structure.
Go out and buy Joe Clecko book SQL for Smarties... He has examples of the
exact thing you are after.. with optimised querys etc...

Basically you need to de-normalise the tables a bit , Joe adds a row called
left and Right
You then use these values to get data .

For eg select * from tree where left = 1 gets you the root node.,
Buy the book, lots of great tip in there...

Justin

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 3:30 PM
To: CF-Talk
Subject: Database Design Challenge!


If anyone can solve this one, I'll give you a million
bucks. Or maybe not, but I'll certainly be impressed...

Let's say, for instance, I'm storing data about a family
tree. Every person has a record in the People table. Every
person has a Mother and a Father, linked with their unique
ID.

Now the challenge: How can I create the list of all male
ancestors, all the way back to the root level (i.e. Adam 
Eve)? I've managed to do this with a CFLOOP that keeps
running a query, going up the tree, until the FatherID is
zero, but this is expensive on the database end.

For the record, I'm not actually keeping track of people
all the way back to Adam  Eve, but this is the best way to
explain this database design issue.

Thank you very much!

Norman Elton
Jefferson Labs
~~
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: Scripting The Visual Tools Object Model

2001-05-16 Thread JustinMacCarthy

Check out http://www.wilk4.com/asp4hs/

Justin 

-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 5:45 AM
To: CF-Talk
Subject: Scripting The Visual Tools Object Model


Hi all,

I have been trolling through the Studio docs to find info on creating VTML
files - fun stuff! I came across the chapter Scripting The Visual Tools
Object Model and it seems pretty comprehensive. Amazing what you come
across in those back chapters. Is anyone actually creating customised
applications for Studio? I think it seems cool but can't think of any
practical uses.

K.
~~
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: Brown Bear's iCal

2001-05-03 Thread JustinMacCarthy

are you trying to parse iCal data??

use lex/yacc + a cCFX 
or jacc +  java cfx


look here http://www.imc.org/ 

Justin 

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 3:01 AM
To: CF-Talk
Subject: Brown Bear's iCal


Does anyone have or know of a custom tag that interacts with Brown Bear's
iCal calendar server.  If not, does anyone know where I can get a good
reference for parsing through a CFHTTP pull?

TIA!
Hatton Humphrey



~~
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: Netscape 6

2001-04-27 Thread JustinMacCarthy

I said it before and I'll say it again Mozilla is a great browser. Netscape
built NS6 on a 0.8 branch of Mozilla. When the next version of Netscape come
out you should a good browser, with a great JavaScript debugger , Mail
client etc .

Justin (wearing a black beret)

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 4:29 PM
To: CF-Talk
Subject: RE: Netscape 6


And people wunder why no one bothers to suport it :-)

 -Original Message-
 From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
 Sent: 25 April 2001 14:52
 To: CF-Talk
 Subject: RE: Netscape 6


 That is a known bug in Netscape 6. The latest updates have
 not yet fixed the
 problem.

 Benjamin S. Rogers


~~
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: Tunneling, Firwall?

2001-04-19 Thread JustinMacCarthy

How do you mean only IE ???
If you want to pretend to be IE from any client all you need to do is send a
http__user_agent value in the request, easy...


Justin

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 10:59 AM
To: CF-Talk
Subject: Tunneling, Firwall?


We're sending HTTP request to a CF server
from within a client that is not a browser (It's our own Visual
C++ application).

We're having a problem with firewalls. Personal/Enterprise
firewalls just don't seem to let us throgh (only IE is permitted).
Can someone suggest a technical way to Tunnel from within
a Firewall?

I would like to research this subject.

Thanks,

-Michael.



~~
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: Synchronize between CF-Forums NNTP

2001-04-19 Thread JustinMacCarthy

If you look at min's site www.intrafoundation.com, he has a TCP cfx you can
use for NNTP , also this list is on a NNTP, you chould email Michael.

Justin

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 1:15 PM
To: CF-Talk
Subject: Synchronize between CF-Forums  NNTP


We created a forum for our site (forums.imvamp.com).

We now want to synchronize every message that is
sent to the forum to be automaticlly sent to a NNTP
Server too (thus creating a news.imvamp.com on IIS server
and vice versa).

I saw DEVX.COM uses this method with their ASP forum
by sending a special unique header for the message.

How can this be done?



Thanks,

Michael Lugassy
Interactive Music Ltd.

~~
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: Need Help for cfhttp

2001-04-18 Thread JustinMacCarthy

Look at cfx_http in the taggallery...
Justin


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 2:50 PM
To: CF-Talk
Subject: Need Help for cfhttp





Hi,

I have a cfm page that needs access to https site to get files back to my
server, here is my problem and question.

In order for me to get the file, I will need to login to https
site first then
click one submit form to get the file. I am able to use cfhttp to
send username
and password and Logon successful. BTW on the https site is use Servelt to
verify username and password,the servelt is running on JRUN.

But, in order for me to get the file, I will need to send another
cfhttp to
access the 2nd page, but it tells me that I am not logged on when I try to
access the 2nd page.

here is my questions:
1. when I use cfhttp to access to either http or https, is that a
new instance
to the server that I am try to access to it?

2. Actually, JRUN Server is the server that I am try to use
cfhttp to get access
to it, is there a way for me to use 2 cfhttp and it will knows that is one
instance instead of 2 instances.
Is there a way to catch the jrunsessionid and the value so I can
attached that
jrunsessionid and value on my 2nd cfhttp?


Thank you for any suggestion

YC







I'm currently using CF Webstore, and also found that the site
is currently
down.  Notwithstanding, the product appears to be well written
and in its
4th iteration, fairly mature.  Documentation is just fair - I'm
 struggling
with some issues with customization (I wish we had access to a
map of the
files so we could see the interaction between files).

I too use CrystalTech in Arizona for most of my hosting.  Their
 support is
top notch - I can get a live network support person in the
server room any
hour of the day, even 3 and 4 AM EDT, and they solve problems
nearly
immediately.  They are also very responsive on email support as well.

I will caution you, the CF Webstore (to use images) requires
that the
CFX_ImgInfo tag be put on the server (CrystalTech will charge
you $10 per
month to do it).

Does someone with CF Webstore experience know how to use a
CFModule call
for this tag so that I can avoid having to place the custom tag
in CF Admin?

Thanks,
Mark Leder

-Original Message-
From: Hawkins, Tim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 4:34 PM
To: CF-Talk
Subject: CF Shopping Cart Solution?



Does anyone have experience with CF EZ CART or other CF
based Shopping Cart software? Im a Mid-Level Developer who is
looking
for a shopping cart solution. Crystaltech www.crystaltech.com is
a great ISP

which has Cold Fusion in their most basic monthly plans but
their
standard Cart is Miva Merchant, which isn't currently very stable on 2000.

Thanks in Advance.

Tim Hawkins
Web Developer
Spectrum Astro Inc.
www.spectrumastro.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: CFML not being executed

2001-04-18 Thread JustinMacCarthy

Sure the template is being called via the webserver?
You got IIS log entries?

Does cf administrator work

Justin

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 6:24 PM
To: CF-Talk
Subject: CFML not being executed


Just had a box put together with Win2k, IIS, CF 4.5.1 sp2 and for some
reason it is not executing the CFML code. When I view the source the CFML
code is still in the contained in the returned html. I've tried everything
even reinstalling both CF and the OS. I checked the ISAPI
filters, execute,
everything I can think of, but nothing works.

Any ideas

TIA,
Duane



~~
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: Transferring 1-3Kb data

2001-04-17 Thread JustinMacCarthy


 2. send the file in http (using WDDX/URL/FORMFIELD)
 and create a copy of the file locally on the server.

 the two solutions are not scalable enough, any help would be
appriciated!



Why is this not scalable ?


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

2001-04-17 Thread JustinMacCarthy

chr(7)

Justin 

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 3:11 PM
To: CF-Talk
Subject: Re: Delimiters


use a series of hard to find types.
something like: "~%~"

this will guarntee NO ONE will type it.

- Original Message -
From: "Dave Hannum" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 2:54 PM
Subject: Delimiters


 Besides commas and pipes, what are the next best choices for delimiting
 lists?

 thanks,
 Dave


 ===
 David R Hannum
 Ohio University
 Web Analyst/Programmer
 (740) 597-2524
 [EMAIL PROTECTED]




~~
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: W2K Pro, IE5.5, .doc files and duplicate file extensions

2001-04-12 Thread JustinMacCarthy

Register the doc extension in File Types in your IIS console.
extension : doc
mimetype : application/msword


JUstin
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 10:58 AM
To: CF-Talk
Subject: RE: W2K Pro, IE5.5, .doc files and duplicate file extensions


Just read this... Word 2000 is installed on my machine, yet I'm still
getting the duplicate extension. Seems a bit daft... does anyone know of a
way around it, *other* than zipping up the file (don't want to have to
explain to users how to unzip it) or saving it as a different file type?


==
Extra File Extension May Be Added to Downloaded Files [Q231755]

PSS ID Number: Q231755
Article last modified on 01-04-2001

WINDOWS:5


==
--
--
---
The information in this article applies to:

 - Microsoft Internet Explorer version 5 for Windows 95
- Microsoft Internet Explorer version 5 for Windows 98
- Microsoft Internet Explorer version 5 for Windows NT 4.0
- Microsoft Windows 98 Second Edition
--
--
---

SYMPTOMS


When you download a file using Internet Explorer, a duplicate
file extension
may
be added to the file name.

CAUSE
=

This problem can occur for file types that are not registered in Microsoft
Windows.

RESOLUTION
==

To resolve this problem, use any of the following methods:

Rename the Downloaded File
--

Rename the file to include only one extension. For example, if you
downloaded a
file named myfile.doc.doc, rename it to myfile.doc.

For information about how to rename a file, click Start, click Help, click
the
Index tab, type "renaming files" (without the quotation marks), and then
click
Display.

Hide the File Extensions for Known File Types
-

To hide the file extensions for known file types, follow these steps:

1. Double-click My Computer, and then click Folder Options on the
View menu.

2. Click the View tab.

3. Under Files and Folders, click to select the "Hide file extensions for
known
  file types" check box.

4. Click OK.

Register the File Type in Windows
-

To register the file type in Windows after you rename the file,
follow these
steps:

1. Click Start, point to Programs, and then click Windows Explorer.

2. Browse to the downloaded file that includes the extension you want to
  register.

3. Press and hold down the SHIFT key, and then right-click the file.

4. Click Open With.

5. If you are prompted to enter a description for the file type, do so. In
the
  "Choose the program you want to use" box, click the program you want to
use
  to register this file type.

6. Click to select the "Always use this program to open this file" check
box.

7. Click OK.

STATUS
==

Microsoft has confirmed this to be a problem in the Microsoft products
listed at
the beginning of this article.

Additional query words:

==
Keywords  : kbenv msiew95 msient msiew98
Version   : WINDOWS:5
Issue type: kbprb
==
==
=
Copyright Microsoft Corporation 2001.




--
Aidan Whitehall [EMAIL PROTECTED]
Netshopperuk
Telephone +44 (01744) 648650


~~
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: Email Questions

2001-04-11 Thread JustinMacCarthy

Check out iMS from coolfusion.com

~ Justin

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:04 PM
To: CF-Talk
Subject: RE: Email Questions


On the same topic, but a question(ish), I've thought about setting up a
mailing list (listserv) and using CF to send one message to the
listserv.  I
haven't put this in practice, but in theory you could set up the list to
only relay e-mails from one account and then set up CF to send the e-mails
using that address as the "from".  Then you only send one e-mail from CF
Server and let the listserv software handle all the rest.

Has anyone put this into practice?

Thanks!
Hatton

 -Original Message-
 From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 10:00 AM
 To: CF-Talk
 Subject: Re: Email Questions


 Break your query up.  Run all the email for the last names that
start with
 the letters A-C, D-F, and so on.  Run them one at a time.
 Finding a way to
 make your query results smaller and thus sending fewer emails
ought to do
 the trick.
 - Original Message -
 From: "Brian Peddle" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Wednesday, April 11, 2001 7:55 AM
 Subject: Email Questions


  I posted this last night but I didn't see it post.  I apologize if it
 comes
  through twice.
 
  I currently send out a weekly newsletter to a growing
database of 70,000
  right now.  I currently query the DB and loop the results and
 send out an
  email to each member.  It takes CF about 24 hours to process
 70,000 emails
  from it SPOOL out to the mail server.  The machines is a dual
700 / 1/2
 gig
  ram.  I don't think its the machine but more the process of 70,000!
 emails.
 
  My initial thought is to group together 40 emails at a time
and BCC then
 and
  have the sent to be whatever.  That would bring the emails
total down to
  about 1700 which CF can pump out fairly fast.  Id prefer to
 stay in CF for
  this.
 
  Does anyone have any suggestions or things that they may have done.
 
  Thanks!!
 
 
 

~~
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: compare files??

2001-04-04 Thread JustinMacCarthy

use diff, diff3  (windows port at cygwin.com ), or windiff (MS Visual studio
/ or win2000 REsource KIT  ) or CVS source control, or VSS???

Justin

-Original Message-
From: Akbar Pasha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 3:45 PM
To: CF-Talk
Subject: compare files??


hi,

i was just wondering whether CF studio has any facility to compare 2
..cfm files and list out the differences. coz i need it very much in my
work and if its not there, is there any other way i can do the compare?

TIA

akbar


~~
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: directories off of inetpub...

2001-04-03 Thread JustinMacCarthy

it?  Is it synonymous to cgi-bin in Unix?

Yes it is IIS installs a lot of crap, and the more you upgrade/ service pack
the more crap you get ...

You can remove the scripts directory , the reference to it in IIS
Also remove any documentation directories, CFDOCS etc.. FRontpage also
installs many _vti_* directories. Get rid of them too. Make sure your MDAC
to up to date too...

Make sure NT has service packs at least to sp5.


Checkout http://www.sans.org/infosecFAQ/win/IIS_vulnerabilities.htm
for a nice roundup and all the other usually sec. sites...

Justin




~~
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: IIS extension mapping to script engine

2001-03-30 Thread JustinMacCarthy

I got to ask, why ??

Justin.

-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 12:00 AM
To: CF-Talk
Subject: IIS extension mapping to script engine



I wish to map all file extensions to te Cold Fusion scripting 
engine.  Is there a way to do this using wildcards?  I have only 
been able to set this up one extension at a time.

NT4 SP6a
CF 4.5.1 SP1
IIS 4

Thank you,

Kevin




~~
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: Form Variables not being passed on selected machines

2001-03-28 Thread JustinMacCarthy

Are you sure the field names are all legal ?
You should log what you are getting as input if there is an error, at least
then you can figure out the problem.



Justin

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 11:57 AM
To: CF-Talk
Subject: Form Variables not being passed on selected machines


All of a sudden, I have a situation where form variables are not being
passed to the action template of a fairly basic form.

Out of 300 users, I guess a handful of them get an error when the action
template tries to evaluate the variables.

I've checked the security settings in Explorer and they seem ok.  Some have
IE4 some have IE5 running on NT4.  There is no pattern with the browser
version.

Any ideas?



Craig Wilson
Business Analyst
Business Applications
VOLKSWAGEN FINANCIAL SERVICES (UK) LIMITED

Work:  +44 (0)1908 485229
Fax:   +44 (0)1908 549296
Mail:  mailto:[EMAIL PROTECTED]



***
***

The opinions expressed in this E-mail are those  of  the individual  and
not  necessarily  the  company.  This E-mail and  any files transmitted
with it are confidential and solely for the use of the intended recipients

***
***


~~
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: Weird CFFile behaviour with Mac IE5 upload

2001-03-28 Thread JustinMacCarthy

Actually IE5 on Mac adds a return char to every form fields...


Justin

-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 12:52 PM
To: CF-Talk
Subject: RE: Weird CFFile behaviour with Mac IE5 upload


Problem is caused by MAC
putting space in instead of an empty field - try using trim() when checking
the field to see if it has been filled.



~~
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: Studio on Linux??

2001-03-27 Thread JustinMacCarthy

Check out jEdit.sourceforge.net, xPlatform editor with some cf support ,
install all the plugins similar to cfstudio stuff.

+ java c perl etc..

HomeSite might reach *nix , with Klix etc and MacOSX = BSD


Justin


-Original Message-
From: Norman Elton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 2:22 AM
To: CF-Talk
Subject: RE: Studio on Linux??


I've looked into Quanta. From what I understand it is fairly customizable.
Are there any customizations available for CF developers?

I certainly don't hate Windows nor Microsoft. They're certainly the driving
force behind lots of cool stuff out there. I would; however, like to learn
more Linux.

Thanks

Norman

-Original Message-
From: Javier Woodhouse [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 7:50 PM
To: CF-Talk
Subject: RE: Studio on Linux??


hating windows does not mean hating good UI...

What most people dont like about windows is Microsofts bussiness tactics...
Followed by the operating systems instability and security holes..

 -Original Message-
 From: zac [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 27, 2001 10:44 AM
 To: CF-Talk
 Subject: Re: Studio on Linux??


 Michael Rosario wrote:

  You may want to check out http://quanta.sourceforge.net/

 Which begs the question: If Linux users hate Windows so much
 why do they
 clone windows apps and use the same UI conventions as Windows?

 --

Don't blame me.
I voted for Kodos.


email: [EMAIL PROTECTED]
WWW: http://www.pixelgeek.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: cfugmay2000 :: VCalendar :: Outlook :: permission to use

2001-03-27 Thread JustinMacCarthy

BTW there is a vcard buffer overflow issues / exploit in outlook, santitize
your forms, patch outlook

Justin

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 1:53 PM
To: CF-Talk
Subject: cfugmay2000 :: VCalendar :: Outlook ::  permission to use


   hello all.
   i found some code i must have grabbed from some cfug zip for may
2000.
   it has a neat vcalendar to insert instances from a db into your
outlook calendar.

   just wanted to know if there are more examples like this.
   Also if i can modify the code for my own use in local Intranet
apps"?


~~
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: cfugmay2000 :: VCalendar :: Outlook :: permission to use

2001-03-27 Thread JustinMacCarthy

sanitize my forms?
i don't understand.

I just mean make sure you get correct field lenghts etc..


where can i get more info?
do you have a url?

Here is a link with some details about the issue
http://www.securityfocus.com/bid/1633. 

thank you
-paul


~J

~~
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: Good Books on JSP?

2001-03-26 Thread JustinMacCarthy


You can learn the basics of JSP in a couple of hours but to learn Java ...

Starting Java2 by WROX  - good starting book  for non-programmers
Java Server Programming by Wrox - good starting book for using java server
side

All the Java in a Nutshell books by OReilly for reference
java.sun.com docs and tutorials and the JavaDocs stuff..

I'd say the Wrox , and OReilly book on JSP are pretty but the more generic
java book would be better value, especially since the JSP book probably
spend half the page telling you how to install a webserver , how HTTP work ,
which you know already etc. etc

Justin :-)


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 3:08 PM
To: CF-Talk
Subject: OT: Good Books on JSP?


Good Morning All!

it is once again time to learn something new.
what is the WACK equivalent to JSP books out there?

just got a bug to learn something new!
thanks

-paul

Web Developer, NBBJ
Work:  [EMAIL PROTECTED]
   614 241-3534
fax:   614 485-5534

Home:  [EMAIL PROTECTED]
   614 449-1681

 icq: 47658358


~~
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: Using javascript to create an Undo - the return

2001-03-14 Thread JustinMacCarthy

You should look at design patterns. The command pattern as it is known is
the most used pattern for undo/ redo operations.
It is used natively in java, but chould be used in a JavaScript lib.

Check out:
http://www.amazon.co.uk/exec/obidos/ASIN/0201633612/o/qid=984585622/sr=8-1/2
02-1404477-4361464


Justin


-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 1:37 PM
To: CF-Talk
Subject: Using javascript to create an Undo - the return


Hi - posted this recently but still no resolution:

Have a cf forum we have written, with javascript "Word" like buttons that
output html for b, i and u in the input textarea - would like to
include an "undo" function with acts like ctrl+Z from the keyboard
- in that
it will remove either the last piece of text written, or the inputted
b/b (etc) tags - any suggestions?

James


~~
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: com wddx

2001-02-28 Thread JustinMacCarthy

Are you sure you are putting the wddx com in the References (in your vba)


Justin 

-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 6:53 PM
To: CF-Talk
Subject: com  wddx


Dear all

(Its been a while since I was on the list)

It occurred to me that it might be a clever thing to be able to send
data in wddx packets directly from excel 2000 (win 95) up to the server
(if you were online)... BUT

In my experimentations I have done as asked in the wddx.org SDK which
comes with CF 4.5 ref installing  registering wddx_com.dll but when I
run the VBA code (code taken verbatim from Forta) it fails on the first
line!

Set MyDeser = CreateObject("WDDX.Deserializer.1")

Run-time error '438':
Object doesn't support this property or method


wddx_com.dll seems OK in the OLE/COM OBject viewer (No idea what I'm
looking for though!)
There does seem to be some sort of problem with xmlparse.dll and
xmltok.dll in as much that I get the message xmltok.dll was loaded but
the DLLRegisterServer entry point was not found etc. when I run regsvr32
xmltok.dll  I've tried deleting  Reinstalling these files but no diff.

ANY Ideas Please!



--
Regards;

Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668


~~
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: Problem with CFFILE (sort of)

2001-02-27 Thread JustinMacCarthy

You should really use UNC instead a mapped drive .

Check out some links from

http://www.cffaq.org/cfserveruseraccount.cfm

Justin
[EMAIL PROTECTED]


-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:38 PM
To: CF-Talk
Subject: Problem with CFFILE (sort of)


OK got a strange one.  I think this will end up being an NT permissions
problem but thought one of you may have come across it.

I have a web site which sits on 2 seperate web servers.  It is
load balanced
and state is maintained via client variables stored in SQL server on a 3rd
machine.  All 3 are networked.  I have a cfm page on both web servers which
is attempting to create a file on the 3rd machine using cffile.  Both web
servers have mapped drives to a folder on the 3rd server so when this cfm
page is requested it writes a file to the same place regardless of
which web
server delivered the page (due to load balancing).

The problem I am having is that when CFServer executes the cffile
command it
says that it can't access the file.  I have checked all the permissions on
the NT server and that folder is opened up for full access to everyone.  I
have tried sucessfully to create a file in this folder from a dosbox on one
of the webservers so the path I'm using is definitely correct.  To
complicate the problem I have changed the code to write to C:\
(which exists
on both web servers) as opposed to the mapped drive to the 3rd
server.  This
works fine.  However I can't use this as I won't know which C drive it has
created the file on due to the load balancing and when request the
next page
which looks for this file it will not find it if the page gets delivered
from the other web server.

Finally I put a specific IP address in the url that requests the page that
creates the file and subsequently reads it so I could guarantee that it
would write and read to the same server (ie bypass load balancing).  But
when I did this the session auomaically expired (which I don't understand).

Has anyone ever come across anything remotely similar to this by any remote
chance!???

Andy

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy,
distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.




~~
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: Problem with CFFILE (sort of)

2001-02-27 Thread JustinMacCarthy

If you create a  domain account with access to the shared drive that will
work. (running cf under that account)

Otherwise if you create an account with the same username  password on each
box that will work too

I do this with out problem..

Justin

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:54 PM
To: CF-Talk
Subject: RE: Problem with CFFILE (sort of)


You should really use UNC instead a mapped drive .

Check out some links from

http://www.cffaq.org/cfserveruseraccount.cfm

Justin
[EMAIL PROTECTED]


-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:38 PM
To: CF-Talk
Subject: Problem with CFFILE (sort of)


OK got a strange one.  I think this will end up being an NT permissions
problem but thought one of you may have come across it.

I have a web site which sits on 2 seperate web servers.  It is
load balanced
and state is maintained via client variables stored in SQL server on a 3rd
machine.  All 3 are networked.  I have a cfm page on both web
servers which
is attempting to create a file on the 3rd machine using cffile.  Both web
servers have mapped drives to a folder on the 3rd server so when this cfm
page is requested it writes a file to the same place regardless of
which web
server delivered the page (due to load balancing).

The problem I am having is that when CFServer executes the cffile
command it
says that it can't access the file.  I have checked all the permissions on
the NT server and that folder is opened up for full access to everyone.  I
have tried sucessfully to create a file in this folder from a
dosbox on one
of the webservers so the path I'm using is definitely correct.  To
complicate the problem I have changed the code to write to C:\
(which exists
on both web servers) as opposed to the mapped drive to the 3rd
server.  This
works fine.  However I can't use this as I won't know which C drive it has
created the file on due to the load balancing and when request the
next page
which looks for this file it will not find it if the page gets delivered
from the other web server.

Finally I put a specific IP address in the url that requests the page that
creates the file and subsequently reads it so I could guarantee that it
would write and read to the same server (ie bypass load balancing).  But
when I did this the session auomaically expired (which I don't
understand).

Has anyone ever come across anything remotely similar to this by
any remote
chance!???

Andy

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy,
distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.





~~
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: Problem with CFFILE (sort of)

2001-02-27 Thread JustinMacCarthy

Have a look at the link I sent you, they will give you info you need , for
the permissions etc..

Justin

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 2:22 PM
To: CF-Talk
Subject: RE: Problem with CFFILE (sort of)


OK I can't seem to restart cold fusion as anything other than the local
system account.  I have created a new user which is part of Domain
users and
Users but when I try to start Cold Fusion I get an "Internal NT error"
number 2140 "Unable to start ColdFusion Service"



~~
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: CFFILE with UNC Paths.

2001-02-27 Thread JustinMacCarthy

Hi 

Check out the links from

http://www.cffaq.org/cfserveruseraccount.cfm

Justin
[EMAIL PROTECTED]


-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 4:12 PM
To: CF-Talk
Subject: CFFILE with UNC Paths.


Anyone know a way to write a file via a UNC path?

Thanks,

Neil



~~
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: Run CF on one server and write to another server?

2001-02-23 Thread JustinMacCarthy

Look here :

http://www.cffaq.org/cfserveruseraccount.cfm


Justin

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 5:57 PM
To: CF-Talk
Subject: Re: Run CF on one server and write to another server?



   I'd look at the CFFTP tag.  Although, I haven't actually used it, I
believe it should do the trick.

At 09:26 AM 02/23/2001 -0500, you wrote:
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C09DA4.997A2450
Content-Type: text/plain;
 charset="iso-8859-1"

I am currently using CF to create static html pages on a daily
basis.  Once
they are created, I want to write or move them to another server.  Any
suggestions as to how to get the files moved or written over to the other
server? I am having no luck here,

Thanks in advance,
Basia

--_=_NextPart_001_01C09DA4.997A2450
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
Run CF on one server and write to another server?

I am currently using CF to create static html pages = on a daily
basis.  Once they are created, I want to write or move = them to another
server.  Any suggestions as to how to get the = files moved or written
over to the other server? I am having no luck = here,

Thanks in advance,
Basia
--_=_NextPart_001_01C09DA4.997A2450--

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

Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 4.5  | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
I've got the brains, you've got the looks, let's make lots of money



~~
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: OT: Cheaper Alternative to SQL Server 2000

2001-02-22 Thread JustinMacCarthy

You could look at MySql -Free

Justin

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 8:21 PM
To: CF-Talk
Subject: Re: OT: Cheaper Alternative to SQL Server 2000



  Well, depending on your resources...

   You can get the developer version for ~$500.  Or spend $1000 to
subscribe to MSDN.  Either of these copies, however, will be strictly for
development.  Since you quoted $5,000 as the price I imagine you are not
looking into hosting yourself, but outsourcing it.

I'd highly recommend against using MS Access, although it is an option.


At 08:49 AM 02/22/2001 -0700, you wrote:

Sorry about the OT post.

I was wondering if someone could give me some feedback on a cheaper
alternative to SQL Server. I am on a limited budget to create my own
webserver and I have only experience in developing with CF and
SQL Server. I
really can't afford the $5,000 that Microsoft wants for SQL Server 2000.
Anybody have any suggestions?


Thanks for your time

Jason Larson
[EMAIL PROTECTED]
406-728-4422




~~
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: CFX_ZIP on Linux?

2001-02-20 Thread JustinMacCarthy

A java  version should be very easy, there is a java/zip example tag
supplied with CF


Justin

-Original Message-
From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 3:05 PM
To: CF-Talk
Subject: RE: CFX_ZIP on Linux?


Yippee. Thanks.

Michel

 -Original Message-
 From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, February 20, 2001 3:38 PM
 To: CF-Talk
 Subject: RE: CFX_ZIP on Linux?


 It is easier than you think Michel.

 The unix philosophy is using many small programs to
 achieve the effect of much larger ones ;)

 So.. if you wanted to create a zip file with max compression

 zip -9 foo.zip file1.txt file2.txt file3.txt

 Voila you now have foo.zip

 Just drop down to the good ole command line using a
 CFEXECUTE or some such and there you go. No Forta tags
 needed with Unix.. :)

 Jeremy Allen
 elliptIQ Inc.

 -Original Message-
 From: Michel Vuijlsteke [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, February 20, 2001 3:54 AM
 To: CF-Talk
 Subject: CFX_ZIP on Linux?
 
 
 We're migrating a CF application from NT to Linux.
 
 One of the things it does is allow the user to tag a number
 of files which
 it then packs in one zip file for him to download. This is
 done with Ben
 Forta's cfx_zip.
 
 Is there any way at all to duplicate this functionality
 easily on Linux? In
 other words: is there a Linux equivalent, or do I need to do
 stuff with
 cfexecute?
 
 Michel Vuijlsteke
 Netpoint NV
 
 


~~
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: Adding CF Template to File:New in Windows

2001-02-19 Thread JustinMacCarthy

Download TweakUI from microsoft's web site.
IT Allows you to this + a lot more besides


Justin MacCarthy

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 12:08 PM
To: CF-Talk
Subject: OT: Adding CF Template to File:New in Windows


Does anyone know how to add file types under "FILE : NEW" in Windows
Explorer (same as right click, new).  I'd like to have the ability to right
click in folder view and add a CF template.

Just to make this clear, you usually use FILE : NEW to add a new folder,
shortcut, etc.

Thanks in advance for any help,

Brad Roberts
[EMAIL PROTECTED]

BTW, I did search the web (and the m$ site) and didn't find anything.
Thanks.



~~
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: CFMail -- Good Substitute???

2001-02-17 Thread JustinMacCarthy

CHeck out iMS mail from coolfusion.com 

Justin 

-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 7:40 PM
To: CF-Talk
Subject: CFMail -- Good Substitute???


Hello.  Does anyone know of a good custom tag to use instead of CFMAIL?

Any input on this would be appreciated.

Thank you.

Melissa Fraher



~~
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: Admin .htaccess files

2001-02-17 Thread JustinMacCarthy

YEah , there are 1000's of perl scripts to just that.

http://www.google.com/search?q=perl+htaccess+cgibtnG=Google+Search


Justin

-Original Message-
From: David Hannum [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 17, 2001 2:51 PM
To: CF-Talk
Subject: Admin .htaccess files


Hello,

Is it possible to build an interface to administer .htaccess files from the
browser?  I've never tried, but can't think of a reason why it would not
work.  Any thoughts?

Dave



~~
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 launch a windows app from a web page?

2001-02-15 Thread JustinMacCarthy

On the client or server??
Signed Java or activeX or signed javascript(maybe) are the only ways to go

Pretty easy code to it 

Justin 

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 1:48 PM
To: CF-Talk
Subject: RE: how to launch a windows app from a web page?


Try writing a batch file to start your application and call the batch file
with cfexecute

-Original Message-
From: James Birchler [mailto:[EMAIL PROTECTED]]
Sent: 15 February 2001 02:30
To: CF-Talk
Subject: OT: how to launch a windows app from a web page?


Has anyone ever successfully launched a Windows application from a 
web page?
If so, how? The only way I've found so far is using an ActiveX
component--but only in theory.  I'm looking for source code I could modify
to launch a particular application.

Is it possible to simply use an object tag to launch the application?

Anyone know anything about this sort of thing?

Thanks,

James

~~
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: can anyone help?

2001-02-15 Thread JustinMacCarthy

cfif ProdCount LTE "3" AND GTE "1"

should  be 

cfif ProdCount LTE "3" AND ProdCount GTE "1"


Justin 

-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 5:40 PM
To: CF-Talk
Subject: can anyone help?


Hello all,

Im getting an error that i cant figure out here... everything 
looks fine to me but maybe someone else can see something. here is 
the error..

Error Diagnostic Information
Just in time compilation error 

Invalid parser construct found on line 98 at position 30. 
ColdFusion was looking at the following text:

GTE
Invalid expression format. The usual cause is an error in the 
expression structure. 
The last successfully parsed CFML construct was a CFIF tag 
occupying document position (98:2) to (98:6).

AND HERE IS MY CODE:

cfquery datasource="#datasource#" name="find_subcats"
  SELECT * FROM SubCats 
  WHERE TopCatID = #URL.CategoryID# 
  ORDER BY SubCat
  /cfquery
cfset ProdCount = prodpage.RecordCount

  cfoutputcenterfont class="boldtext"#prodpage.Category# 
/font/center/cfoutputbr

center
  table cellspacing="0" cellpadding="4" border="0" width="30%"


  CFPARAM NAME="URL.StartRow" DEFAULT="1"
  cfloop query="prodpage"
  cfoutput query="prodpage" startrow=#URL.StartRow# maxrows=6
  
!! this is line 98!! cfif ProdCount LTE "3" AND GTE "1"

  cfif ProdCount EQ "0"
  tr
  /cfif

  td colspan="4" align="center" valign="bottom"
  a 
href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID
#"img src="images/#ItemPic#" border="0"/abr
  font class="boldtext"a 
href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID
#"#ItemName#/a/font/td

  cfif ProdCount EQ "3"
  /tr
  /cfif

 /cfif
  
 cfif ProdCount LTE "6" AND GTE "4"

  cfif ProdCount EQ "4"
  tr
  /cfif

  td colspan="4" align="center" valign="bottom"
  a 
href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID
#"img src="images/#ItemPic#" border="0"/abr
  font class="boldtext"a 
href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID
#"#ItemName#/a/font/td

  cfif ProdCount EQ "6"
  /tr
  /cfif

 /cfif
  
  cfset ProdCount = ProdCount + 1

  /cfoutput

  /cfloop
  /table
  /center

Any help would be much appreciated.
Thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.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: Parsing Headache (Removing Multiple Images)

2001-02-14 Thread JustinMacCarthy

REreplace(page,"img.*[^]","","ALL")
or something???

Justin

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 5:44 PM
To: CF-Talk
Subject: Parsing Headache (Removing Multiple Images)


OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine.
Now I want to port my application to the Palm Pilot so I want to remove the
images from the output. Here's my line of thinking at the moment...

cfscript
 output = #Trim(CFHTTP.FileContent)#;
 imageStart =#Find("img", output, 1)#;
 imageEnd = #Find("", output, imageStart)#;
 imageLen = imageEnd - imageStart + 1;
 output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#;
/cfscript

This works great in removing the first image.

My Question:

How can I loop this some how to remove all images without knowing how many
are on the page? Fortunatly there are only 1-3 per page. I've been racking
my brain for hours over this one.. any takers?

Thanks,
Steve




~~
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: PDFs, Linotronic PS Drivers, Forms and Adobe Licensing

2001-02-14 Thread JustinMacCarthy


Check out :

ActivePDF.com
GhostViewer


Justin

-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 7:37 PM
To: CF-Talk
Subject: PDFs, Linotronic PS Drivers, Forms and Adobe Licensing


So this guy says to me. It's be cool if ...

I think I heard some comments on using Adobe Distiller on an
Internet Server
is in violation of the Adobe license for Distiller? Is this true?

Here is what I am thinking.

We create a basic site with an info centre to post how to's and
help etc. We
have downloads for people to use, basically we'll kick start a community
driven file sharing centre. The documents available for download will be
document design templates in the myriad of available formats, quark, word,
whatever.

We want to be able to create a printable format document and have
decided on
PDF. We want to dynamically generate the print document on the
server, as a
proof to the creator, and as a distributable print document to the digital
printer. And also include a basic work docket as well, type of paper,
shipping information etc.

More or less, without actually seeing it work is to output to a
common post
script format (created using a free linotronic PS driver?) to be
uploaded to
the server using a form. Distiller can be used to watch the upload
directory, and automatically create the PDF. After creation, a ticket is
sent to the creator to approve the PDF for printing. Once approved we
distribute to the printer for printing.

So

Question 1: What are the licensing issues regarding the use of
Distiller on
a public Server?

Question 2: Performance?

Question 3: Other Alternatives?

Question 4: Current examples of people doing something similar.

Question 5: Is there a way to programmatically enhance the print driver to
automatically post the PS to the Internet Server? Other Alternatives?
Implementations?

Thanks
Eric

~~
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: CFPOP unknown error

2001-02-13 Thread JustinMacCarthy

Use cfx_pop or cfx_imap

Justin

-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 9:35 PM
To: CF-Talk
Subject: CFPOP unknown error


Hi people,

I've been trying to fix my long-standing CFPOP problem by writing a page to
remove the bad messages from the mailbox. However, it seems unknown errors
cannot be caught by try and catch. Hmmm...

The only thing I can think of is relying upon client side Javascript to
autorefresh to a "delete message" page if the page isn't fully output. Can
anyone better this?

I find this horribly ugly because I can't schedule it, I'd have to run it
manually. Anybody... an alternative please???

David Cummins
--
David Cummins
Systems Developer
Ubiquity Software Ltd.
Ph: (09) 309-1921


~~
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 to find tables

2001-02-12 Thread JustinMacCarthy

You would be better off using the sp_tables Sproc.

Justin [EMAIL PROTECTED]

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 12:00 PM
To: CF-Talk
Subject: Re: SQL to find tables


Thanks . . .




- Original Message -
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, February 12, 2001 6:44 AM
Subject: RE: SQL to find tables


 Is there an SQL command I can use to look into a database and dynamically
 return all of the table names and output them to a page?

Use either Information_Schema.Columns or SysObjects

Select distinct Table_Name
from Information_Schema.Columns
order by Table_Name

Select name
from SysObjects
where xType='U'

I wouldn't recommend using SysObjects too often as knowing M$, they'll
change how it works...

Also, these return the system tables as well as the generated tables

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**

~~
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: Is there a way to run a server side executable through CF?

2001-02-07 Thread JustinMacCarthy

I think you would be better off using "AT" from the command line to run
batch job , assuming they are not cfm..
Of course it depends your access / privilgies on the box .

Justin

-Original Message-
From: Edward Smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 8:23 PM
To: CF-Talk
Subject: Re: Is there a way to run a server side executable through CF?


CFEXECUTE for newer versions of CF,
and I think there's a couple of CFX tags in the taggallery for earlier
platforms.

Paul Begovich wrote:

 We have created several scripts written for NT Server that
perform various
 server side tasks.  What we want to do is execute these scripts
using the CF
 scheduler.  Is there a way to run a server side executable through CF?

 - Paul



~~
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-NT-Server hangs: no interaction possible

2001-02-04 Thread JustinMacCarthy

One thing that really confused me recently was an exception within an error
template, resulting in infinite loop.. and the server dying (on a Linux box)

Quite confusing at first look though ...

Justin



~~
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: Batch Image Upload

2001-02-01 Thread JustinMacCarthy

Use wddx over http???


Justin

-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 4:35 PM
To: CF-Talk
Subject: Batch Image Upload



I was wondering if anyone has a custom cf tag, or some ideas to
accomplish a
batch image upload. I have a client that will be taking about 10 pictures a
day on 10 different construction projects. They want to have the capability
to upload the images in a batch process without using a FTP
utility, for the
sake of saving time. I have been brewing this over the last couple of days
and any suggestions on how to accomplish this would be of great help.

Thanks

Jason Larson
[EMAIL PROTECTED]



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



WOT: was RE: Allaire on a Mac? now IE v's Mozilla :-)

2001-01-29 Thread JustinMacCarthy



oh no, I see a Win/Mac thread looming..

Wait here is a Mozilla / IE one

to finally kill them off (just my $0.02) oh and for Crapscape to go.
Utopia indeed.

Anyone who has not tried Mozilla 0.7 should have a look. Finally getting
there. Some get features. / V fast SSL etc working

Justin in Black Beret mode.


~~
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: (OT)RE: ALLR/MACR Merger - ColdFusion to be repositioned ?????

2001-01-29 Thread JustinMacCarthy

Interesting considering the recent Lawsuit settlement

http://www.sun.com/smi/Press/sunflash/2001-01/sunflash.20010123.1.html;$sess
ionid$L2N3UHYAACQZ5AMTA1LU45Q



Justin
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 3:32 PM
To: CF-Talk
Subject: Re: (OT)RE: ALLR/MACR Merger - ColdFusion to be "repositioned"
?


Concern? I'd think not.  Besides, Microsoft has announced support for
Java in .net:
http://msdn.microsoft.com/visualj/jump/default.asp

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]



"Belfiori, Ross" wrote:

 Since you mentions the app srvr.
 Is there any concern about CF going Java backend and the whole
Java versus
 M$ .Net issues that have picked up steam?

 -Original Message-
 From: Russel Madere [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 26, 2001 12:40 PM
 To: CF-Talk
 Subject: RE: ALLR/MACR Merger - ColdFusion to be "repositioned" ?

 That was double good business double speak.

 What it sounds like to me is that the Cold Fusion server line will not be
 affected by the merger.  It will continue to progress down the path it is
 currently on independantly of the going on with the Macromedia server
 products.

 
   Russel Madere, Jr. Senior Web Developer
   ICQ: 5446158   http://www.TurboSquid.com

 Some days you eat the bear; some days the bear eats you.
 

  -Original Message-
  From: Stephen M Aylor [mailto:[EMAIL PROTECTED]]
  Sent: Friday, January 26, 2001 11:23
  To: CF-Talk
  Subject: ALLR/MACR Merger - ColdFusion to be "repositioned" ?
 
 
  Sands Brothers Investment Research Covering MACR
 
  Hears the link - hears the paragraph causing me some "kun-fusion"
 
  http://investor.cnet.com/investor/news/newsitem/0-9900-1028-459963
 2-1.html?t
 ag=yhoo

 In the past, Macromedia has made a point of NOT participating directly in
 the application server business but rather to partner with
leader's in the
 space. Management is aware of this issue and pointed out that Allaire's
 flagship product, ColdFusion, would be repositioned such that
Allaire's CFML
 technology would be maintained and that applications built with CFML will
 run on top of application servers from other vendors.

 Steve


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

2001-01-29 Thread JustinMacCarthy

It's impossible to completely get rid of this error however you can minimize
the chances of it happening.

Look at the SQL books on line for advice on how to do this

Justin


-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 3:27 PM
To: CF-Talk
Subject: SQL Error


Has anyone seen this error here before? What is the cause and the fix?

ODBC Error Code = 40001 (Serialization failure)

[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID
#17) was deadlocked with another process and has been chosen as
the deadlock
victim. Rerun your transaction.

TIA,
Duane



~~
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: (OT)RE: ALLR/MACR Merger - ColdFusion to be repositioned ?????

2001-01-29 Thread JustinMacCarthy

I'm a programmer, not
a disciple.

Quick! someone get Ben Forta, and a high powered lamp.. ASP Bad CF Good.. 

J :-) 


~~
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: Releasing COM Objects from Memory

2001-01-29 Thread JustinMacCarthy

AFAIK , cf releases COM at the end of script execution. YOu chould do

cfset myobj = nothing
but I don't think there is any difference

Justin

-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 5:14 PM
To: CF-Talk
Subject: Releasing COM Objects from Memory



Anyone know a good way to force CF to release a COM object from memory when
we are finished with 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: How do I put the little image in the address bar in IE?

2001-01-29 Thread JustinMacCarthy

create a image called favorite.ico in the web root of the site.

Justin 

-Original Message-
From: Milks, Jim [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 6:39 PM
To: CF-Talk
Subject: OT:How do I put the little image in the address bar in IE?


Hi,
I have a client who is hell-bent on having his logo appear in the 
IE address
bar and when people bookmark his site. How is this done? It is IE only,
right?

Thanks,

James



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

2001-01-26 Thread JustinMacCarthy

Well anyone interested I have the cffaq.org and cffaq.net domains
If anyone to to a design, or write a section (eg XML, Oracle ,cfx ,MS
Access) Let me know thanks


Justin


-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 10:11 AM
To: CF-Talk
Subject: RE: CF-Talk FAQ


 There was an attempt to do so on the HoF site itself but was never really
 used by anyone. http://www.houseoffusion.com/hof/faq/index.cfm

Now, are we talking about FAQ for the CF-Talk list, or CF FAQ?

Michael's done the List FAQ at this locn, but I definitely think we should
do a CF FAQ to help stop the same-old-same-old questions

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



~~
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: Alphabetic List

2001-01-26 Thread JustinMacCarthy

What would you suggest ?? :-)

Justin 

-Original Message-
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 4:36 PM
To: CF-Talk
Subject: RE: Alphabetic List


I would recommend against using this method
even if the field is indexed as this causes a
full table scan to occur which will greatly
degrade as it is used a lot and as the table
grows in size.

Jeremy Allen
elliptIQ Inc.

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 12:27 PM
To: CF-Talk
Subject: Re: Alphabetic List


You can do this in your SQL

SELECT People Info
WHERE LastName LIKE 'A%'

This would be for people with last names that start with A.

Kevin
- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, January 26, 2001 10:13 AM
Subject: Alphabetic List


 Hi,

 In Yahoo address book, they have this list for finding a particular
 person easily
 by the first letter of their last name:

 All - A B C D E F G H I J K L M N O P Q R S T U V W X Y Z - Lists

 Does anyone have any insights on how the algorithm of implementing this
 feature?

 For example, I have a user database, and I want to use this feature to
 find
 persons whose last name start with a particular letter.

 Thanks!

 Hong




~~
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: Slackware, CF, and MySQL

2001-01-25 Thread JustinMacCarthy

Dennis, there is  a cf-linux list small amounts of msg  -  good quality
mails
[EMAIL PROTECTED]

Lots of guys running that combo...

Justin

-Original Message-
From: dennis baldwin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 4:22 PM
To: CF-Talk
Subject: Slackware, CF, and MySQL


Anyone runnin' CF with MySQL on Linux?  I'm having problems
setting up MySQL
datasources through CF administrator.  Every time I try to verify I get a
failed connection.  Any pointers would be greatly appreciated.

Thanks,
Dennis Baldwin
ZAP Designs
www.zapdesigns.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: Continuous Clock

2001-01-25 Thread JustinMacCarthy

or JavaScript  as below

script
!--
function tick() {
  var hours, minutes, seconds, ap;
  var intHours, intMinutes, intSeconds;
  var today;

  today = new Date();

  intHours = today.getHours();
  intMinutes = today.getMinutes();
  intSeconds = today.getSeconds();

  if (intHours == 0) {
 hours = "12:";
 ap = "Midnight";
  } else if (intHours  12)

 hours = intHours+":";
 ap = "A.M.";
  } else if (intHours == 12) {
 hours = "12:";
 ap = "Noon";
  } else {
 intHours = intHours - 12
 hours = intHours + ":";
 ap = "P.M.";
  }

  if (intMinutes  10) {
 minutes = "0"+intMinutes+":";
  } else {
 minutes = intMinutes+":";
  }

  if (intSeconds  10) {
 seconds = "0"+intSeconds+" ";
  } else {
 seconds = intSeconds+" ";
  }

  timeString = hours+minutes+seconds+ap;

  Clock.innerHTML = timeString;

  window.setTimeout("tick();", 100);
}

window.onload = tick;
--
/script
br


div id=ReplaceMe style="font-family: verdana; font-size: 20;"What you type
in below will replace this HTML/div



Justin

-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 5: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: case sensitivity in stored procedures

2001-01-24 Thread JustinMacCarthy

Hi I'm not sure if you got this yesterday so I'm sending again

Select * from MyTbl where convert(varbinary, column1) = convert(varbinary,
'ABCD')


Justin

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 12:55 PM
To: CF-Talk
Subject: RE: case sensitivity in stored procedures



Nick, this was helpful, thanks - I didn't realize it was an installation
option, and I've never seen it installed except with the default setting. I
looked it up in BOL and it gives pretty good details.  I'm sure I've been
lazy enough with object names, etc. that I wouldn't want case-sensitivity
ON - half my queries or code might fail. Well maybe not half, but some.

I had been trying out some code with tests of exact (case-sensitive) words,
such as  "WHERE Password LIKE '[S][e][c][R][e][t]', but so far it seems
that the case-sensitivity setting relates to this too. As a result, SEcret,
seCRET, SeCrEt, etc. all come up as LIKE the above expression.

So it might be better to say that SQL Server is case-insensitive by
default, period.


Mark
[EMAIL PROTECTED]



Sebastian

Apologies, not a very helpful answer.

What I meant was SQL Server is case-sensitive, period.

But actually that's not always true, only if SQL Server is
installed with a case sensitive sort order.

http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql
/8_ar_da_

10.htm

Nick
~~
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 on a Mac?

2001-01-23 Thread JustinMacCarthy

I'd say that CF will run on the mac , consider 

CF5 - Java base 
Java runs "anywhere" sortof :-)
The new MRJ is quite fast.

Cf runs on most *nixs 
MacOSx is pretty much *nix (sort of)


Cfstudio is built on delphi
Delphi is been ported to *nix (klix)
OsX is *nix (sort of )



Justin 




-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 2:56 PM
To: CF-Talk
Subject: RE: Allaire on a Mac?


I doubt it.  Generator Server doesn't work on a Mac, and THAT's a 
Macromedia
product.  Besides, extending CF to a Mac Platform just seems WAY 
out in left
field to me (and I *like* macs).  And when I say left field... I mean on
Mars.

Maybe, possibly in the future if the OSX becomes the main mac platform and
they can really starte treating the Mac OS more like a *nix platform.  ***
Maybe *** ... and still I'd say not for a few years even then.

|-Original Message-
|From: Randy Zeitman [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, January 23, 2001 8:58 AM
|To: CF-Talk
|Subject: Allaire on a Mac?
|
|
|Anyone have any insight as to whether Allaire's apps will soon run on 
|Macintosh as a result of the merger with Macromedia?
|-- 
|**This signature sponsored by GuitarList.com - the most powerful 
|musical instrument search engine on the net!**
|
|"I've gotten so out of shape sittin' at the computer all day that I 
|get out of breath when I have to reach for the percent key!"  - 
|Zeitman 
|
|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: HELP! - CFMAIL, Security and mail server

2001-01-23 Thread JustinMacCarthy

Check out iMS mail server free for the Special Edition , integrates
perfectly with CF
www.coolfusion.com

Works great

Justin

-Original Message-
From: Milks, Jim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 3:56 PM
To: CF-Talk
Subject: HELP! - CFMAIL, Security and mail server


Hi All,
I have a client whose internal IT department is unable to provide me with a
name or IP address of a mail server to point my CF Server at. So now, I am
on my own and not a network/mail guy. I have a CF box that is
outside of the
firewall, and I am faced with installing something to generate e-mail. I
don't want something as big as exchange, and found some neat freeware for
this. However, I don't want spammers getting the address, and using my
gateway.

Can I/How do I set up CFMAIL to use a username and password when accessing
this mail server? Or do I just rely on "security by obscurity"?

Any help appreciated...

Jim


~~
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: case sensitivity in stored procedures

2001-01-23 Thread JustinMacCarthy

Yes, check out the SQL faq

 http://www.swynk.com/faq/sql/sqlserverfaq.asp

Justin 

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 5:34 PM
To: CF-Talk
Subject: RE: case sensitivity in stored procedures


 Can you do a case sensitivity comparison within a SQL Server stored
procedure?

Yes.


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**


~~
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 on a Mac?

2001-01-23 Thread JustinMacCarthy

How do you do 3 button emulation on a one button Mac Mouse ??? :-)
~Justin 

Of course... But why would you buy a mac just to
run Linux to finally make it useful? G

Jeremy Allen
elliptIQ Inc.


-Original Message-
From: David Livingston [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 11:43 AM
To: CF-Talk
Subject: RE: Allaire on a Mac?


http://www.yellowdoglinux.com/

Or just run linux on your Mac and make it real useful.
Dave

-Original Message-
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 9:30 AM
To: CF-Talk
Subject: RE: Allaire on a Mac?


It is actually not that far fetched when one
considers what OS X is.

Granted its not needed since OS X will be a fringe OS
for some time.. But the technical feasability of it
is definately easy.

In fact I bet you could get it working in OS X with
VERY little coding at all.

OS X is built on FreeBSD and a BSD kernel which have
excellent Linux emulation.

Take linux version of CF, run on OS X under emulation.

A native port to another Unix is cake, they have three
already, HP/UX, Solaris, Linux, moving to a BSD would not
be much trouble at all (in relative terms to say porting
it to MacOS)

OS X *IS* another Unix..

Jeremy Allen
elliptIQ Inc.

-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 9:56 AM
To: CF-Talk
Subject: RE: Allaire on a Mac?


I doubt it.  Generator Server doesn't work on a Mac, and THAT's a
Macromedia
product.  Besides, extending CF to a Mac Platform just seems WAY
out in left
field to me (and I *like* macs).  And when I say left field... I mean on
Mars.

Maybe, possibly in the future if the OSX becomes the main mac 
platform and
they can really starte treating the Mac OS more like a *nix 
platform.  ***
Maybe *** ... and still I'd say not for a few years even then.

|-Original Message-
|From: Randy Zeitman [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, January 23, 2001 8:58 AM
|To: CF-Talk
|Subject: Allaire on a Mac?
|
|
|Anyone have any insight as to whether Allaire's apps will soon run on
|Macintosh as a result of the merger with Macromedia?
|--
|**This signature sponsored by GuitarList.com - the most powerful
|musical instrument search engine on the net!**
|
|"I've gotten so out of shape sittin' at the computer all day that I
|get out of breath when I have to reach for the percent key!"  -
|Zeitman
|
|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



CF IDE for *nix Mac etc ...was RE: Allaire on a Mac?

2001-01-23 Thread JustinMacCarthy

Anyone wants a nice cfstudio like IDE for *nix , Mac Windows Sun ??
Check out http://jedit.sourceforge.net don't dismiss it because is java -
it's very fast. Make sure you install the plugins (tabs, cmd and project,
ftp...) is you want a real cfstudio type interface .. You can customise it
(eg add close buffer to right click)

I'm working on a DB plugin for it...

Justin

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 3:53 PM
To: CF-Talk
Subject: Re: Allaire on a Mac?


I don't know if I'd like CFserver on a Mac or not, but I'd like to see
the IDE's (Studio/HomeSite) ported over (to Linux as well, though I know
there are some code issues there)

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]


Randy Zeitman wrote:

 Anyone have any insight as to whether Allaire's apps will soon run on
 Macintosh as a result of the merger with Macromedia?
 --
 **This signature sponsored by GuitarList.com - the most powerful
 musical instrument search engine on the net!**

 "I've gotten so out of shape sittin' at the computer all day that I
 get out of breath when I have to reach for the percent key!"  -
 Zeitman

 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: chmod

2001-01-22 Thread JustinMacCarthy

chmod o=rwx filename 

JUstin 

-Original Message-
From: Yvette Ingram [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 4:06 PM
To: CF-Talk
Subject: Re: chmod


Jay:

From back in my Unix days, I think that's 777


Yvette Ingram
Brainbench Certified ColdFusion 4.5 Programmer
Email: ingramrecruiting@erols or
[EMAIL PROTECTED]
ICQ:  21200397


- Original Message -
From: Jay Patton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 18, 2001 7:28 PM
Subject: chmod


 does anyone remember or know the chmod number to make a file readable
writeable and executable by everyone? i cant remember it
 thanks,

 Jay Patton
 Web Pro USA
 406.549.3337 ext. 203
 1.888.5WEBPRO
 www.webpro-usa.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: chmod

2001-01-22 Thread JustinMacCarthy

You are going to get someone in trouble :-) 
no /dev/null jokes please

Justin 

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 11:07 AM
To: CF-Talk
Subject: Re: chmod


rm -rf /

sorry couldn't resist ;-)

jon
- Original Message -
From: "JustinMacCarthy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, January 22, 2001 5:59 AM
Subject: RE: chmod


 chmod o=rwx filename

 JUstin

 -Original Message-
 From: Yvette Ingram [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, January 21, 2001 4:06 PM
 To: CF-Talk
 Subject: Re: chmod
 
 
 Jay:
 
 From back in my Unix days, I think that's 777
 
 
 Yvette Ingram
 Brainbench Certified ColdFusion 4.5 Programmer
 Email: ingramrecruiting@erols or
 [EMAIL PROTECTED]
 ICQ:  21200397
 
 
 - Original Message -
 From: Jay Patton [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, January 18, 2001 7:28 PM
 Subject: chmod
 
 
  does anyone remember or know the chmod number to make a file readable
 writeable and executable by everyone? i cant remember it
  thanks,
 
  Jay Patton
  Web Pro USA
  406.549.3337 ext. 203
  1.888.5WEBPRO
  www.webpro-usa.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: CF Server Error

2001-01-22 Thread JustinMacCarthy

Can we see the code that gives you this ?

Justin 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 1:55 PM
To: CF-Talk
Subject: FW: CF Server Error


Anyone ideas on this one?

Mike Connolly
Web Developer
New Media
Rocom Group Limited
Tel:   01937 84 74 96
Web: http://www.rocom.co.uk





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2001 09:16
To: CF-Talk
Subject: CF Server Error


Has anyone ever come across this error with CF Server 4.5..

"CFMLInterpreterImp::executepcode"

If so, what measures were taken to alleviate it?

Regards

Mike Connolly

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

2001-01-22 Thread JustinMacCarthy

Some things 
Non treadsafe CFX tags 
File locking issues 
Reading / writing session  application variables  underload with locks.

+ 

Justin 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 2:25 PM
To: CF-Talk
Subject: RE: CF Server Error


It's more of a generic question, as we cannot uniquely identify the
erroneous code.

To re-word the question slightly, 

Does anyone know what CF tags / scenarios maybe causing this error to
appear?



-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2001 14:16
To: CF-Talk
Subject: RE: CF Server Error


Can we see the code that gives you this ?

Justin 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 1:55 PM
To: CF-Talk
Subject: FW: CF Server Error


Anyone ideas on this one?

Mike Connolly
Web Developer
New Media
Rocom Group Limited
Tel:   01937 84 74 96
Web: http://www.rocom.co.uk





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2001 09:16
To: CF-Talk
Subject: CF Server Error


Has anyone ever come across this error with CF Server 4.5..

"CFMLInterpreterImp::executepcode"

If so, what measures were taken to alleviate it?

Regards

Mike Connolly


~~
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: Perl Question

2001-01-19 Thread JustinMacCarthy



use CGI qw(:standard);
print redirect('http://www.houseoffusion.com');

Justin [EMAIL PROTECTED]

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 2:50 PM
To: CF-Talk
Subject: Fw: Perl Question



- Original Message -
From: "Kevin Schmidt" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 18, 2001 11:09 AM
Subject: OT: Perl Question


 Got a perl cgi and after I am finished processing I want to redirect the
 user to another URL similar to the Cflocation tag.  Anybody know how?

 Kevin Schmidt, Web Technology Manager
 Allaire Certified ColdFusion 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: CF games

2001-01-19 Thread JustinMacCarthy

There is a vbscript version of hangman on the MS scripting site.
Java or DHTML would be best for the crossword Depends in the browsers you
need to support

Justin

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 2:49 PM
To: CF-Talk
Subject: CF games



We have a new project that requires "Games".

I need to find a few classic English teaching games, Hangman, crossword
puzzles and the like.

Has anyone seen or written these game in CF? Or for that matter in java
script?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770



~~
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: Variable Names with -

2001-01-18 Thread JustinMacCarthy

Hack:

Select XML_F52E2B61-18A1-11d1-B105-00805F49916B as myxml
From table

Now use #myxml# in CF


Justin

-Original Message-
From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 2:58 PM
To: CF-Talk
Subject: RE: Variable Names with "-"


The problem with this is that I am working with a Microsoft
product that has
a mind of its own.  The SQL statement looks like this:
   SELECT
   *
   FROM
   TABLE
   for xml auto,elements

It returns a one column result whose name is
XML_F52E2B61-18A1-11d1-B105-00805F49916B and the xml is broken up to a
certain number of characters per line. What I want to do is to put
that back
together as a single xml string that I can get my hands on, but because of
the name that Microsoft creates, I can't loop through it with Cold Fusion.

If anyone has any suggestions on how to get at this strange
Microsoft column
with Cold Fusion, I would greatly appreciate it.  Thanks.

-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 9:37 PM
To: CF-Talk
Subject: RE: Varaible Names with "-"

You could do the following if you don't have control of the DB:-)

cfquery name="qtest: datasource="datasource"
 select `field-name` as FieldName from TableName
/cfquery

Notice the ` which is located under the tilda(~) key this will return the
fieldname as it was written in the DB. However you can't use this with CF,
so using the as command this will rename the field to anything you want it
to be.

So you could then reference it instead of qtest.field-name, but as
qtest.FieldName instead.

Hope this helps:-)



regards

Andrew Scott
Senior Cold Fusion Application Developer
ANZ Business eCommerce
* Ph 8615 6018
* [EMAIL PROTECTED]

---
 This e-mail and any attachments to it (the "Communication") is
confidential and is for the use only of the intended recipient. The
Communication may contain copyright material of Australia and New Zealand
Banking Group Limited ABN 11 005 357 522 ("ANZ"), or any of its related
entities or of third parties. If you are not the intended recipient of the
Communication, please notify the sender immediately by return
e-mail, delete
the Communication, and do not read, copy, print, retransmit, store
or act in
reliance on the Communication. Any views expressed in the Communication are
those of the individual sender only, unless expressly stated to be those of
ANZ. ANZ does not guarantee the integrity of the Communication, or that it
is free from errors, viruses or interference.


-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: 18 January 2001 10:09
To: CF-Talk
Subject: RE: Varaible Names with "-"


This probably isn't the answer you're looking for, but you should
rename the
column.  That's just plain bad database design to begin with.  And there's
no need to add on another layer of unnecessary programming when all you've
gotta do is rename the field.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 17, 2001 10:00 AM
 To: CF-Talk
 Subject: Varaible Names with "-"


 Is there any way to pull out the information about a query column
 that has a
 "-" in it?  The problem is that with SQL Server 2000, when you do a "for
  xml" select statement, the column name that is returned has "-"s in it.
 From the documentation in SQL Server 2000, I am not seeing a name
 to rename
 that.  I am trying to pull out the xml from this query, but in
order to do
 this, I need to get at the data with a column name that has a "-"
 in it.  If
 anyone has any suggestions, please let me know.  Thanks.




~~
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 Server export/import preserving diagrams

2001-01-17 Thread JustinMacCarthy

You can get a script to export diagrams from
http://www.swynk.com/sqlhome/7library.asp



Justin

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 2:11 PM
To: CF-Talk
Subject: SQL Server export/import preserving diagrams


If you import/export databases between two SQL Server 7 boxes, you seem to
always lose the diagrams. If you go in and recreate the diagram on the new
machine, all the relationship information seems to have been preserved,
however.

Are the diagrams the only thing you lose? And is there any way to retain
them whilst importing/exporting?



Thanks

--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions  Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651


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



FW: Running a MS SQL Server DTS Package from ColdFusion

2001-01-17 Thread JustinMacCarthy

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 8:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Running a MS SQL Server DTS Package from ColdFusion


options:

use cfexeccute and rundts
use xp_cmdshell
create a job  run it 

or you can run that code using cfobject
as per the MS example 

cfset DTSReposFlag_Default = 0
cfset DTSReposFlag_UseTrustedConnection = 256

CFOBJECT ACTION="Create"TYPE="COM"CLASS=DTS.Package
NAME="oPackage" 
cfset oPackage.LoadFromSQLServer  
('servername','','',256,'','','','MyPackage','')
cfset oPackage.Execute()



Justin 


-Original Message-
From: Percy E Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 6: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: Short Circuit Evaluation

2001-01-17 Thread JustinMacCarthy

CFIF (isDefined("somevar") AND somevar IS "something")
do something
cfelse
do nothing
/CFIF

JUstin

-Original Message-
From: Ruslan Sivak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 3:12 PM
To: CF-Talk
Subject: Short Circuit Evaluation


I have had to write this kind of code over and over, and was wondering if
there is a better way like in c++, where it does lazy evaluation.

This is what I want:

CFIF isDefined("somevar") AND somevar IS "something"
do something
/CFIF

Of course this fails, since if the variable is not defined, CF stil checks
the second condition.  In languages like C++, it did lazy evaluation, so if
the first condition was false, it didn't bother checking the second
condition.  This let people write things like

open(FILE,"file") || die "Can't open file";

So in CF I have to rewrite my above IF statement as 2 statements

CFIF isDefined("somevar")
   CFIF somevar IS "something"
do something
   /CFIF
/CFIF

Is there a better way?

Ruslan Sivak
Technologist

~~
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: Storing/Encrypting Credit Cards

2001-01-17 Thread JustinMacCarthy

hi
Do you know whats is the deal on the cfx_vpn ?? Also are these c++ or Java
tags??
Of course doing the 128bit etc in Java wouldn't be too difficult

Justin

Just a note on encrypting.  I know of a company getting ready to release a
strong encryption tag that will use 128bit ryndahl encryption algorithm.
look at www.cfxworks.com for more info.  Actually there site is still under
construction, but will be ready soon. It should be released very


~~
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: OT: Window 95 Log?

2001-01-17 Thread JustinMacCarthy

If you got a firewall you could check the log of that. Or if you are talking
about a webservice there is a log for personal webservice

Justin

-Original Message-
From: Ryan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 4:25 PM
To: CF-Talk
Subject: Re: OT: Window 95 Log?


At 09:25 1/17/01 -0600, you wrote:
What Log file will tell me if someone has logged into a windows
95 computer?

What other then a cmos password can protect a windows?

Nothing, unless there is some third party tool, which still would not
be very secure, Win9X (or ME I imagine) is just not a very secure OS.

R



~~
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: cfobject question

2001-01-16 Thread JustinMacCarthy

Nick you might like to use CreateObject("COM", dmoObj)  etc so you can do
all your COM stuff in cfscript block

cfscript

x = CreateObject("COM", dmoObj);
strEntityType = ;
strEntityName = ;
thisDatabase = dmoObj.Databases(strDb);

/cfscript

or whatever...

Justin

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 11:16 AM
To: CF-Talk
Subject: RE: cfobject question


Clint,
Something like this should do it

cfobject.. name="dmoObj"
cfset strDb = ...
cfset strEntityType = ...
cfset strEntityName = ...

cfscript
thisDatabase = dmoObj.Databases(strDb);
/cfscript

cfswitch expression="#strEntityType#"
cfcase value="Tables"
   cfset dmoCollection = thisDatabase.Tables
   cfset strImage = "images/table.gif"
   cfif strEntityName is not ""
   cfscript
   dmoEntities = dmoCollection(strEntityName).Columns;
   /cfscript
   /cfif
/cfcase

cfcase value="Views"
   cfset dmoCollection = thisDatabase.Views
   cfset strImage = "images/view.gif"
/cfcase

cfcase value="Stored_Procedures"
   cfset dmoCollection = thisDatabase.StoredProcedures
   cfset strImage = "images/sp.gif"
/cfcase

cfcase value="Users"
   cfset dmoCollection = thisDatabase.Users
   cfset strImage = "images/users.gif"
/cfcase

cfdefaultcase
/cfdefaultcase
/cfswitch


-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 4:46 PM
To: CF-Talk
Subject: cfobject question


I need to find out if cfboject can an equivalent to this ASP code:
With dmoServer.Databases(strDb)
   Select Case strEntityType
   Case "Tables":
   Set dmoCollection = .Tables
   strImage = "images/table.gif"
   if strEntityName  "" then
   set dmoEntities =
dmoCollection(strEntityName).Columns
   end if
   Case "Views":
   Set dmoCollection = .Views
   strImage = "images/view.gif"
   Case "Stored_Procedures":
   Set dmoCollection = .StoredProcedures
   strImage = "images/sp.gif"
   Case "Users":
   Set dmoCollection = .Users
   strImage = "images/user.gif"
   End Select
Basically what this is doing is using the SQLDMO object to get a list of
tables,views,sprocs,or users depending on what the strEntityName is. I
cannot reproduce this in CF. Can someone help me?

-Clint


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**


~~
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 do I work with XML?

2001-01-16 Thread JustinMacCarthy

Get started here 

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

Justin 

-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 4:46 PM
To: CF-Talk
Subject: How do I work with XML?


I'm going to be getting database updates as xml doc's from a third party.
Can somebody give me some direction on working with this? I need 
to know how
I can first import the data into a SQL 7.0 database, then how to work with
it using CF. Any direction would be very helpful.

Thanks,

Rick



~~
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: Copying tables thru ODBC

2001-01-16 Thread JustinMacCarthy

I believe there is a article on this very topic on cfadvisor 

Justin 


~~
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 do I work with XML?

2001-01-16 Thread JustinMacCarthy

Hey Jeremy,

You checked out JAXP?? It's real nice. 

Justin 


-Your own custom CFX using SAX in Java or C++, or a third 
party solution. 

Jeremy Allen
elliptIQ Inc.


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

options:

use cfexeccute and rundts
use xp_cmdshell
create a job  run it

or you can run that code using cfobject
as per the MS example

cfset DTSReposFlag_Default = 0
cfset DTSReposFlag_UseTrustedConnection = 256

CFOBJECT ACTION="Create"TYPE="COM"CLASS=DTS.Package
NAME="oPackage"
cfset oPackage.LoadFromSQLServer
('servername','','',256,'','','','MyPackage','')
cfset oPackage.Execute()



Justin


-Original Message-
From: Percy E Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 6: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: cfobject question

2001-01-15 Thread JustinMacCarthy

If you are using SQL Server check out the system stored procedures 

sp_tables (returns view or tables)
sp_columns
sp_stored_procedures 
sp_helplogins 

Haven't got time to get into the SQLDMO stuff 


~ Justin 



-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 4:46 PM
To: CF-Talk
Subject: cfobject question


I need to find out if cfboject can an equivalent to this ASP code: 
With dmoServer.Databases(strDb)
   Select Case strEntityType
   Case "Tables":
   Set dmoCollection = .Tables
   strImage = "images/table.gif"
   if strEntityName  "" then
   set dmoEntities =
dmoCollection(strEntityName).Columns
   end if
   Case "Views":
   Set dmoCollection = .Views
   strImage = "images/view.gif"
   Case "Stored_Procedures":
   Set dmoCollection = .StoredProcedures
   strImage = "images/sp.gif"
   Case "Users":
   Set dmoCollection = .Users
   strImage = "images/user.gif"
   End Select
Basically what this is doing is using the SQLDMO object to get a list of
tables,views,sprocs,or users depending on what the strEntityName is. I
cannot reproduce this in CF. Can someone help me?

-Clint


~~
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: Calling JavaScript when loading custom tag.

2001-01-12 Thread JustinMacCarthy

Yeah you can just do

script
Function()
/script

from where-ever in your page.

Justin

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 3:40 PM
To: CF-Talk
Subject: Calling JavaScript when loading custom tag.


I'm working on a custom tag that has a JavaScript function in it that needs
to be called when the tag is loaded.  I tried using body
onload="function();", but that doesn't work.  Is there another way to call
a function on load from a 'page' nested inside another page?  My knowledge
of JavaScript isn't all the great :(

Todd Ashworth




~~
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: CFMail Time Stamp

2001-01-10 Thread JustinMacCarthy

Is this the second error of this type I've seen on the list?
2001 bug ?
 ~ Justin 

-Original Message-
From: cftalk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 6:20 PM
To: CF-Talk
Subject: CFMail Time Stamp


I have a problem with the time stamp on messages sent through 
cfmail.  My servers clock is set at GMT -0500 but CFMail messages 
are being stamped with + 0400 wich is affecting the time sent by 
about 9 hours.

Anyone have any insight as to why this is happening or where I go 
to correct it?

Thanks,
Chris Stoner


~~
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: Distributed Processing regarding CF and a separate Web Server

2001-01-10 Thread JustinMacCarthy

I agree with all that Eric said regarding this. Just to add I heard that
proformance is dreadful using this method
There is a stub called(?) cfdist.exe to allow you do this.


~ Justin



~~
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: WDDX for Cobol

2001-01-10 Thread JustinMacCarthy

David , doing WDDX in java isn't too hard.. there are examples in wddx SDK.
Otherwise there is Perl wddx?
Using | could get ugly.. some sort of encoded is going to be needed...

Justin

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 3:10 PM
To: CF-Talk
Subject: Re: WDDX for Cobol


In production we will not have ODBC connectivity to the database, but will
only be calling a stored procedure which executes a COBOL routine.  Right
now I am getting a huge string back, delimited by the | character.  The
downside is that the client side of this is in JSP.  My parsing skills in
Java just aren't what they are in CF.

DC

- Original Message -
From: "Robert Everland" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, January 10, 2001 10:04
Subject: RE: WDDX for Cobol


 Well if you have Client access to connect to the AS/400 and it's using an
 offshoot of DB2 somewhere which AS/400 usually uses, you should
be able to
 query the database with an odbc connection. We do this now with
AS/400 and
 RPG.

 Robert Everland III
 Web Developer
 Dixon Ticonderoga


 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, January 10, 2001 9:59 AM
 To: CF-Talk
 Subject: WDDX for Cobol


 I know this sounds like a completely lame question, but has anyone
attempted
 to create a WDDX component for COBOL?  I have a legacy system integration
 project that would be greatly simplified with the ability to have WDDX or
 other XML component to deal with some data transfer.  This is on
an AS400.

 DC


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

2001-01-09 Thread JustinMacCarthy

Thats Sql Server only (access too?) . cfquery maxrows=1 might be better 

Justin 

cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC"
   Select top 1 *
   from UnitPages
   where ArticleUnit = '#form.units#'
   order by ArticleDate DESC
/cfquery

This will literally return the top row, and nothing else



~~
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: Query confusion - CF not recognising query name

2001-01-09 Thread JustinMacCarthy

Why not put debugging on for your IP only???

I can't put debugging on as it's a production server - I don't
have the data
on my test machine to use, and the amount of data is huge to download

As I said - it's confusing the hell out of me.

Philip Arnold

 Also you chould RUN SQLtrace  to see whats going on. These kind of issues
Usually are a result of silly mistakes. I know mind are. Get someone else
there to look at the code, might pick it up staight away.

Justin MacCarthy




~~
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: aliasing using cfmail

2001-01-08 Thread JustinMacCarthy

By compliant I sure Howie means "compliant with the mail RFCs" , but Howie
is the resident email expert :-)


Check out http://www.tac.nyc.ny.us/mail/rfc-index.html
Some mail server will "fix" the address though ...

Justin

cf-talk Mail 19 number of 2001 :-)

-Original Message-
From: Owen Leonard [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 4:40 PM
To: CF-Talk
Subject: Re: aliasing using cfmail


Could you elaborate on what you mean by 'compliant.'  I ask because my test
worked both with and without quotes.  Is it an issue of different mail
servers and clients?

-- Owen

-
Athens County Library Services
http://www.athenscounty.lib.oh.us

- Original Message -
From: "Howie Hamlin" [EMAIL PROTECTED]
Subject: Re: aliasing using cfmail


 To be compliant, the "friendly name" needs to be delimited by quotes and
the
 actual address needs to be delimited by  brackets as follows:

 "friendly name" [EMAIL PROTECTED]

 HTH,

 Howie Hamlin - inFusion Project Manager

 - Original Message -
 From: "Rick Lamb" [EMAIL PROTECTED]
 Subject: aliasing using cfmail


  Do any of you guys know how to alias the "from" parameter as to include
a
  display name along with the email address? EG:
 
  cfmail
  from="Rick [[EMAIL PROTECTED]]"
 
  /cfmail
 
  Thx!
 
  Rick




~~
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: Contract work??? OT

2001-01-08 Thread JustinMacCarthy

There is a cf-jobs mailing list @ houseoffusion, also I believe there is a
JobPosting section at the http://www.acfug.org/ web site.

Justin

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 5:39 PM
To: CF-Talk
Subject: Contract work??? OT




Hello all,
  I have been developing in ColdFusion, Sql Server, DB400(AS/400),
Oracle, ASP, JavaScript, Html on NT/2000 Platforms..
Do you guys know any website/company that outsources/sub-contracts
Projects/Contracts. Preferably Remote Development.
Appreciate it. Sorry for the OT question.

Thanks
Joe

-
Sent using MailStart.com ( http://MailStart.Com/welcome.html )
The FREE way to access your mailbox via any web browser, anywhere!



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

2001-01-08 Thread JustinMacCarthy

You could use "application/unknown" as your content type ???

Justin

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 6:34 PM
To: CF-Talk
Subject: CFHEADER


It seems the following won't work, well in at least IE5.5.

CFHEADER NAME="Content-Disposition"
VALUE="attachment;filename=#attributes.fname#"
CFCONTENT TYPE="application/pdf" FILE="#fnp#"

It instead opens the page up for download instead of the file.  So lets say
I have peter.pdf as my attributes.fname and download.cfm is the page the
above code is on.  And lets say that it's called from index.cfm.  Well
index.htm appears in the download file box, not peter.pdf.  It
seems to work
ok in Netscape, so I can't believe I'm the only one having this problem.
I've seen similar looking code on the Allaire site, but it's still not
working.  Can anyone help with this?



~~
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: Cold Fusion controlled CD-RW

2001-01-05 Thread JustinMacCarthy

If I were you I'd look for some Open Source CD-RW software , that has been
ported to Windows. That will give you the most options..

Try , freshmeat.org and gnu.org etc..

Justin

-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 12:53 AM
To: CF-Talk
Subject: RE: Cold Fusion controlled CD-RW


Know of any software that takes command line commands?  I don't.

Bernd VanSkiver
[EMAIL PROTECTED]
ICQ #: 916324


-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 11:49 AM
To: CF-Talk
Subject: RE: Cold Fusion controlled CD-RW


cfexecute and sw that takes command line parameters

-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: 04 January 2001 17:12
To: CF-Talk
Subject: Cold Fusion controlled CD-RW


I was just wondering if anyone knows a way to control a CD-RW drive in Cold
Fusion?  Just think it would be cool to be able to burn cds over the
intranet or internet on my server.  If anyone knows a way to do this even
without cold fusion, I am willing to take suggestions.

Bernd VanSkiver
[EMAIL PROTECTED]
ICQ #: 916324

~~
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: Calendar Question

2001-01-05 Thread JustinMacCarthy

Here you are.


cfscript

// replace now() with whatever date you are using.
year = year(now());
month = month(now());

FirstDateOfMonth = CreateDate(year,month,1);
LastDateOfMonth  = CreateDate(year,month,DaysInMonth(FirstDateOfMonth));

FirstDayOfMonth = DayOfWeek(FirstDateOfMonth);
StartPadding = FirstDayOfMonth - 1;
FirstDateToShow = DateAdd('d',-StartPadding,FirstDateOfMonth);

LastDayOfMonth = DayOfWeek(LastDateOfMonth);
EndPadding = 7 - LastDayOfMonth;
LastDateToShow = DateAdd('d',EndPadding,LastDateOfMonth);

DaysInMonthToShow = DateDiff('d',FirstDateToShow,LastDateToShow) + 1;

NumberOfRows = DaysInMonthToShow / 7; 
/cfscript


There is a slightly faster way to do this. Hope this is helpful

Justin MacCarthy
Ireland

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 10:17 PM
To: CF-Talk
Subject: Calendar Question


1) Does anyone have a fool proof formula from coming up with the number of
rows in a calendar for a month.

I've tried a couple of things but with no luck.

TIA,
Duane Boudreau
CEO/CTO, CFExperts



~~
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: Cold Fusion controlled CD-RW

2001-01-05 Thread JustinMacCarthy

Check out http://www.cfcomet.com/ for lots of CF - COM examples

Justin

-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 1:25 AM
To: CF-Talk
Subject: RE: Cold Fusion controlled CD-RW


I haven't dealt with COM objects before.  Will have to look in to learning
about doing that.  Thanx

Bernd VanSkiver
[EMAIL PROTECTED]
ICQ #: 916324


-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 12:47 PM
To: CF-Talk
Subject: Re: Cold Fusion controlled CD-RW


This would be a simple matter of controlling a COM object.  If there's
already a burner app (like Adaptec Easy CD) installed, you may be able
to tap into it's objects.. otherwise, it wouldn't be too hard to tie
into the ASPI drivers with your own solution.

--
Billy Cravens
[EMAIL PROTECTED]


Bernd VanSkiver wrote:

 I was just wondering if anyone knows a way to control a CD-RW drive in
Cold
 Fusion?  Just think it would be cool to be able to burn cds over the
 intranet or internet on my server.  If anyone knows a way to do this even
 without cold fusion, I am willing to take suggestions.

 Bernd VanSkiver
 [EMAIL PROTECTED]
 ICQ #: 916324



~~
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: Regular Expression Gurus Please Help!

2001-01-05 Thread JustinMacCarthy

Try this instead of a re 
#Replacelist("+44 (0) 7799 657093","+, ,(,)","")#

Justin 

-Original Message-
From: Edward Chanter [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 10:47 AM
To: CF-Talk
Subject: OT: Regular Expression Gurus Please Help!


I'm really bad at these so maybe one of you has some ideas, basically I'm
trying to create a reg ex to run against a list of cell phone numbers. I
need to strip out + signs as well as brackets () and spaces " " the
expression I'm using is:

cfoutput
#REReplace("+44 (0) 7799 657093","+| |(|)","","ALL")#
/cfoutput

It only takes out the spaces when I run it :-(

I bet the answer is really simple but I just can't figure it out...

Thanks in advance,

   - =Ed



~~
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: Slightly OT

2001-01-05 Thread JustinMacCarthy

A couple of comments on this:

I used to work for one of the first ISP on Europe, we used mostly Linux +
Gnu etc.
We supplied Mosaic  and then Netscape 1.2 , Netscape 3 etc . Then of course
Microsoft looked at the WEB. They gave us IDC (awful) and huge amounts of
money / support etc... They gave us IE, to distribute for free. (Netscape
wanted a license fee). As time went on we used ASP, Commerce Server,
etc...mostly for costly , Microsoft supported projects. etc .etc One
problem their products were for the most part crap, even for free. We mapped
..asp files to Perl on Linux and reported our servers as NT. Generally we
used Perl, C Scripting Linux  Sendmail etc to our work. CF made appearance
internally around CFv1.5 (It's come a long way :-) and we used from then on
for various stuff ) Having said all that ASP is pretty good now, ASP+ even
better. Win2000 is starting to mature and in general MS Web products are
getting better. As for ASP being difficult, well it's all relative. There
are some things that are "easier" to do in ASP, the same way the things
that are easier in Java or C or assembly etc... For a non-programmer the
tagged syntax of CF might be easier , more natural; but for a programmer
well why can't I do cfset x++ for example ??? Is it easier to do cfset x
= x + 1

As for maintainable code well you can write crap code in any language.

It all comes down to the problem and the resources you have.

I think in Europe there is a tradition of using open source products , maybe
because European Companies don't demand that there is "a company" to support
languages they use. They trust the community more than one company (i.e.
Microsoft). Also the Cost of the product used to be an issue on Europe (not
really any more).  This is different in the states.

As for the impact of CF Allaire in Europe, well it's exploding from I've
seen since v1.5 . The JRun purchase will definitely add to those interested
in Allaire.

Maybe you are using Linux yourself bflynn??? :-) "Flames/dev/null"?
A lot of people call that arcane. (and for the end user (my dad) they might
still be right but I love it as a programmer )

Anyway just my thoughts

Justin

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 1:14 PM
To: CF-Talk
Subject: RE: Slightly OT


Sorry, but I have to comment -

(engage soapbox mode)

Managers that choose ASP over CF are showing that they have no business
being a manager.  I've done both.  My first reaction to ASP was
"Why is this
so difficult?"  My first reaction to CF was "Wow, someone finally made it
simple."  Anyone that chooses the cheap implementation over something that
is maintainable is not someone that I want to work with/for.  Software
development is hard enough already...we don't need to make it harder by
choosing arcane scripting languages.

(ok, I'm done)

Thanks - I feel better now.  Flames/dev/null.

Brian

-Original Message-
From: Martin Sutton [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 5:28 AM
To: CF-Talk
Subject: RE: Slightly OT


The problem with this is that often, the people controlling the purse
strings are not developers, they are BIS managers brought in to control
budgets and strategy.  I am pretty sure that this is why.  They don't see a
difference as long as the functionality is the same.  Try asking a senior
manager what RAD is.

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
But ... in my humble opinion you can easily justify the purchase of a CF
server license when your development time is reduced  AND THAT IS A
FACT!

My 5 cents!

Allan Pichler
Machine Dreams Inc.

-Original Message-
From: Martin Sutton [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 2:18 AM
To: CF-Talk
Subject: RE: Slightly OT


I think that possibly Microsoft (therefore ASP) has a stronger marketing
machine here because our technology centres are not as guided.

European countries are behind the US in software development and also in
pricing.

As an indication, CF Server Pro costs £1300 ish over here.  It is $1200(?)
in the US, so yes, thats a big difference, even for a one time purchase.

-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: 05 January 2001 10:16
To: CF-Talk
Subject: RE: Slightly OT


That's actually a very interesting point to bring up 

It seems that almost all european countries uses php/asp whereas over here
the market has room for all of the scripting languages  is it the price
for a license that scares companies in europe ??

Allan Pichler
Machine Dreams Inc.

-Original Message-
From: Martin Sutton [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 2:07 AM
To: CF-Talk
Subject: RE: Slightly OT


Do UUnet have a CF hosting service?

Jason, any ISP that allows dedicated servers (if thats what you require)
will host CF.

The only problem you may come across is in the use of RDS which some 

RE: And the award goes to ......

2001-01-05 Thread JustinMacCarthy

Damn DWatt's I'll get him this year - Dave remember it's quality not
quantity :-)

Justin ([EMAIL PROTECTED])


-Original Message-
From: Hoffman, Joe (CIT) [mailto:[EMAIL PROTECTED]]
CF-talk posts for the year 2000 total 48,444

[EMAIL PROTECTED] 1,644

others in the top 20 are :

[EMAIL PROTECTED] 517
[EMAIL PROTECTED]460


~~
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: Anybody using CF 4.5.1 sp2 on RedHat 7.0 with Sybase 11.9.2

2001-01-04 Thread JustinMacCarthy

Marcus there is a Cf-linux list @ houseoffusion.com.
You would get more help there. Also I'm not sure if you looked here 
http://www.allaire.com/developer/TechnologyReference/linux.cfm

Justin 

-Original Message-
From: Marius Milosav [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 2:28 AM
To: CF-Talk
Subject: OT:Anybody using CF 4.5.1 sp2 on RedHat 7.0 with Sybase 11.9.2


and can share some info.

I am interested in any problems, unusual setup procedures etc


Thank you
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD) 
www.scorpiosoft.com/vhd/login.cfm



~~
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: a cry out for help

2001-01-04 Thread JustinMacCarthy

Hi Nick,
 you using IIS5 or Apache ? If you are you could use webDav which would do
all that stuff for, and allow them to save file directly from Word excell
etc using web Folders.

As for
Upper management has given me 6 hours

No is an important word in programming.

Justin


-Original Message-
From: Nick Call [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 3:35 PM
To: CF-Talk
Subject: a cry out for help


Hi:  I have a good one for you.

Upper management has given me 6 hours to come up with (basically) a CF
version of Source Safe.  They want to be able to publish important company
docs, like the strategic business plan for 2001 (in MS Word), and allow
certain members of management to check it out, download it, revise it, and
re-upload it without overwriting old versions.  It has to track revision
dates, author, etc.  And it has to be idiot-proof, becuase they admit that
they are Internet idiots.  Has anyone built this system before in CF?  If
so, how much?

Help.

Nick
[EMAIL PROTECTED]




~~
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: oracle/SQL7 migration... keep finding little tricks - HELP

2001-01-03 Thread JustinMacCarthy

Hi there,

for example, SQL7 will order a column with NULL values at the top, while
Oracle will order them at the bottom.

   sorted by MSSQL7:  NULL, NULL, NULL, 1, 2, 3
   sorted by Oracle:  1, 2, 3, NULL, NULL, NULL


In SQL7 server: Null values are treated as the lowest possible values.To
reverse this you use DESC ASC


case sensitivity also throws off ordering, oracle will order all
uppercase before ordering lowercase:

   sorted by MSSQL7:  jones, Smith, thomas, White
   sorted by Oracle:  Smith, White, jones, thomas


SQL 7 has the following ordering options:
Dictionary order, case-insensitive
Binary2
Dictionary order, case-sensitive
Dictionary order, case-insensitive, uppercase preference
Dictionary order, case-insensitive, accent-insensitive


Some Oracle stuff
http://www.cffaq.net/cf_and_oracle.cfm
http://www.cffaq.org/procparam.htm

Justin MacCarthy


~~
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: coldfusion xml guru wanted for a small job

2001-01-03 Thread JustinMacCarthy

As far as I know the DMOZ stuff is RDF not XML  ???

Justin

-Original Message-
From: Martin Orth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 4:42 PM
To: CF-Talk
Subject: coldfusion  xml guru wanted for a small job


Hi,

I am searching for a coldfusion  xml guru for a small job.

TODO:

1. Import a xml directory structue like the one from yahoo
to a database.

2. Import the directory entrys into a database.

3. Write a short documentation, so that it is possible to import all the
data again.

Please first take a short look at www.quendo.com. It is a link
directory like www.dmoz.org or www.yahoo.com. All the categories and the
links with descriptions are from www.dmoz.org. It is not the whole
directory. It´s only http://www.dmoz.org/World/Deutsch/ and so on.

The problem is that all the data is in two verry big xml files. I want
the data in two or maybe three database tables. The solution for me
would be a kind of import tool writen in coldfusion and of course a dll
or a cfx_customtag for deserialisation.

I think I need two main tables: 1. categories 2. links
The categories table should have the following columns: id, parent_id,
categorie_name and alias_id. The links table should have the following
columns: id, categorie_id, url, title, description.

Please write me a short eMail if you can do this job and please write
some words about the time and money you need to do this.

Thanks

Martin

--
Martin Orth - CFSOLUTIONS
Oberblissenbach 30 - 51515 Kuerten
Tel. 02207 700652 - [EMAIL PROTECTED]


~~
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: Executing SQL server DTS packages from CF...

2001-01-03 Thread JustinMacCarthy

You could run them using "dtsrun"  with xp_cmdshell
or create a job and run it using sp_start_job

Justin MacCarthy

-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 5:02 PM
To: CF-Talk
Subject: Executing SQL server DTS packages from CF...


Hi,

I have a number of DTS packages written for importing multiple text files
into SQL Server

(part of a process which sets up indexes/relationships for a temp copy of
the db, then imports a number of table in a specified order from
text files,
checking referential integrity, and if they imported without any errors,
drop the Live tables, rename the temp tables, indexes, and relationships to
the names of the live ones...)

Now, the SQL for dropping and renaming works fine, and I can put all that
into stored procedures which I can execute from cf.

The problem comes with running the DTS packages in CF - looking at the SQL
documentation, I dont see quite how it could be done - they seem to need to
run through Enterprise manager

Can anyone help me?

The alternative of using CFFILE to import and manually checking all the
referential integrity does not thrill me - it would take much longer to
create, and be far less efficient in execution...

Any Ideas would be much appreciated...

Cheers

Dan.


~~
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[2]: Generating unique values

2001-01-02 Thread JustinMacCarthy

But it doesn't create values which are not easy to guess.

Two consecutive UUID will have similar values + 1


Justin

-Original Message-
From: listmb [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 31, 2000 10:01 PM
To: CF-Talk
Subject: Re[2]: Generating unique values


Thanks Nick,

That was just what I was looking for!

Best,
WayGee


Hello Nick,

Sunday, December 31, 2000, 4:00:40 PM, you wrote:

NM You can use the CreateUUID function.

NM It generates a Universally Unique ID. It does contain both 
letters and numbers.

NM At 03:58 PM 12/31/2000 -0500, you wrote:
Hi,

Being new to cold fusion (1 week),  can anyone let me know if there is
a way to create unique random numbers or strings in cold fusion?
It should not be iterative or easily guessed.


This would help alot!

--
Best regards,
WayGee  mailto:[EMAIL PROTECTED]




NM

~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



RE: Re[4]: Generating unique values

2001-01-02 Thread JustinMacCarthy

Depends what you want to do but something like :

cfset keylength = 10 ! length of key -
cfset key ="" !--- the key "" to start 


cfloop from=1 to=keylength index=idx
!--- you might want to change this, to use a different set of charactors
if being used in a url for example---
cfset chrindex = RandRange(65, 126)
! build the key -
cfset key = key  Chr(chrindex)
/cfloop

!--- output the key ---
cfoutput
#key#
/cfoutput


Justin MacCarthy

-Original Message-
From: listmb [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 02, 2001 12:50 PM
To: CF-Talk
Subject: Re[4]: Generating unique values


Thanks this sounds like they are using a guid call to generate this.
Is there some other algorihth i could use or ways I could do this?

Thanks,
WayGee

Hello JustinMacCarthy,

Tuesday, January 02, 2001, 6:15:41 AM, you wrote:

J But it doesn't create values which are not easy to guess.

J Two consecutive UUID will have similar values + 1


J Justin

-Original Message-
From: listmb [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 31, 2000 10:01 PM
To: CF-Talk
Subject: Re[2]: Generating unique values


Thanks Nick,

That was just what I was looking for!

Best,
WayGee


Hello Nick,

Sunday, December 31, 2000, 4:00:40 PM, you wrote:

NM You can use the CreateUUID function.

NM It generates a Universally Unique ID. It does contain both
letters and numbers.

NM At 03:58 PM 12/31/2000 -0500, you wrote:
Hi,

Being new to cold fusion (1 week),  can anyone let me know if there is
a way to create unique random numbers or strings in cold fusion?
It should not be iterative or easily guessed.


This would help alot!

--
Best regards,
WayGee  mailto:[EMAIL PROTECTED]




NM

J

~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



RE: Admin E-mail (newbie level question)

2001-01-02 Thread JustinMacCarthy

CFERROR 
TYPE="Request" or "Validation" or "Monitor" or "Exception"
TEMPLATE="template_path"
MAILTO="email_address"
EXCEPTION="exception_type"

Justin 


-Original Message-
From: Scott Wolf [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 02, 2001 2:46 PM
To: CF-Talk
Subject: Admin E-mail (newbie level question)


My brain has completely locked up on me (must had
a bit too much to drink on Sunday), but I can't
remember how to change the admin e-mail for a
specific application.  The CF-Administrator says
it's possible, but I can't find it in the docs.
If someone could help me, I'd really appreciate
it.  Thanks in advance, and Happy New Year!

Scott Wolf


~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



RE: preparing for CF certification...

2001-01-02 Thread JustinMacCarthy

Just make sure who know the blink tag :-) 

~Cynical Justin 



Hi folks.  I'm thinking about going for my Allaire CF Certification in the
moderately near future.  What are some of the things I can do to help
prepare?
Thanks and hope you all had a happy and safe New Year's!
Jamie



~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



  1   2   3   4   >