RE: OT - Windows NT source code

2004-02-13 Thread Schuster, Steven
How many companies with over 1,000 employees (and PC's) have you been with
that ran Linux, FreeBSD or something similar on the desktop?

The answer is: Not a whole lot.

So, if most business runs MS on the desktop they rely on it. There are
enough hacks out there now without the source code causing problems. If
somebody had the source code they could cripple industries that relied on
the platform rather quickly.

Our jobs are time consuming enough without the added pressure of 16 year old
kids writing viruses all day aren't they.

If Linux was the most used OS in the world you better bet it wouldn't take
long for exploit after exploit to hit that platform. With it being open
source that simply makes the job that much easier.





-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 13, 2004 11:51 AM
To: CF-Talk
Subject: RE: OT - Windows NT source code

Riddle me this:

If you can get Linux, FreeBSD, etc source code 24 hours a day 7 days a
week and that is not a security risk, why is a leak of ( | )icrosoft
code such a huge security leak? Could it be they have really bad code,
or perhaps they don't want you to see the back door they put in to all
there OSs... um... well makes you wonder.

On Fri, 2004-02-13 at 06:52, cfhelp wrote:
 Even though I am going to probably have to deal with an increase in Hacks
I
 think this may be a good thing, as it will force M$ to get off there a$$
and
 fix more in OS. Well then again I could see them saying Windows 2003 fixs
 all.


-- 
Vale,
Rob

Luxuria immodica insaniam creat.
Sanam formam viatae conservate!

http://www.rohanclan.com http://www.rohanclan.com 
http://treebeard.sourceforge.net http://treebeard.sourceforge.net 
http://ashpool.sourceforge.net http://ashpool.sourceforge.net 

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




RE: OT - Windows NT source code

2004-02-13 Thread Schuster, Steven
Ummm, that's like apples and oranges...Last time I checked Apache was not an
OS!

What OS is it running on? 





-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 13, 2004 12:19 PM
To: CF-Talk
Subject: Re: OT - Windows NT source code

Schuster, Steven wrote:
 
 If Linux was the most used OS in the world you better bet it 
wouldn't take
 long for exploit after exploit to hit that platform. With it being open
 source that simply makes the job that much easier.

If Apache was the most used webserver in the world, you better 
bet it wouldn't take long for exploit after exploit to hit that 
platform.

Oh wait ...

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje

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




RE: OT - Windows NT source code

2004-02-13 Thread Schuster, Steven
That sounds like a mile high view of the situation.

MS, MAC and others were around before the net was what it is today thus the
security dictated that it was closed source. 

MAC just recently got into open-source with X and eventually MS will as
well. 

I do think that it may make for a more stable environment if it were
open-source but I doubt it would make it hack proof at all. I just don't see
that as a possibility.

As for the encryption, I remember learning that years ago and finding it
hard to swallow then as well.

If I installed a security system in my house I wouldn't want to be the one
to test it. I know where the weak and strong points would exist. That would
nullify the test altogether. I would rather have somebody come in (like a
robber would do) and try to get in. They may be able to research the system
I used but may not be aware of the details of the house layout and what
other traps might exist.

A true hacker is going to work like a robber and not an insider. They have
to piece the puzzle together and seldom have all the pieces (hence the word
hacking).



-Original Message-the weakness
From: Tom Kitta [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 13, 2004 12:16 PM
To: CF-Talk
Subject: RE: OT - Windows NT source code

I disagree, open source makes OS much safer than closed source OS. Everyone
can inspect the code and point out problems with open source, not so when it
is closed. Thus, MS has a problem when its source gets suddenly released --
people will most likely find a lot of holes in it which were long time ago
fixed in open source OS. It can be compared to a person that lived in a
bubble their whole life getting exposed to the outside world for the first
time -- might catch something pretty quickly.

Also, security through obscurity is no security at all. One of the oldest
principles in encryption states that one should test the system under the
conditions where the attacker is assumed to have full knowledge of the
system.

TK
-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 12:00 PM
To: CF-Talk
Subject: RE: OT - Windows NT source code

How many companies with over 1,000 employees (and PC's) have you been with
that ran Linux, FreeBSD or something similar on the desktop?

The answer is: Not a whole lot.

So, if most business runs MS on the desktop they rely on it. There are
enough hacks out there now without the source code causing problems. If
somebody had the source code they could cripple industries that relied on
the platform rather quickly.

Our jobs are time consuming enough without the added pressure of 16 year
old
kids writing viruses all day aren't they.

If Linux was the most used OS in the world you better bet it wouldn't take
long for exploit after exploit to hit that platform. With it being open
source that simply makes the job that much easier.

-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 11:51 AM
To: CF-Talk
Subject: RE: OT - Windows NT source code

Riddle me this:

If you can get Linux, FreeBSD, etc source code 24 hours a day 7 days a
week and that is not a security risk, why is a leak of ( | )icrosoft
code such a huge security leak? Could it be they have really bad code,
or perhaps they don't want you to see the back door they put in to all
there OSs... um... well makes you wonder.

On Fri, 2004-02-13 at 06:52, cfhelp wrote:
 Even though I am going to probably have to deal with an increase in
Hacks
I
 think this may be a good thing, as it will force M$ to get off there a$$
and
 fix more in OS. Well then again I could see them saying Windows 2003
fixs
 all.


--
Vale,
Rob

Luxuria immodica insaniam creat.
Sanam formam viatae conservate!

http://www.rohanclan.com http://www.rohanclan.com
http://www.rohanclan.com
http://treebeard.sourceforge.net http://treebeard.sourceforge.net
http://treebeard.sourceforge.net
http://ashpool.sourceforge.net http://ashpool.sourceforge.net
http://ashpool.sourceforge.net

 _

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




RE: OT - Windows NT source code

2004-02-13 Thread Schuster, Steven
...and from a business point of view where does the majority of the work
happen?

Not on a server but rather on some desktop where people key in data to
systems (Excel, PeopleSoft, Oracle, etc.). So if the desktop becomes
unstable the work is unstable and so on and so forth.

I'm not knocking the value of Linux and those like it I just don't see it as
a viable option for a world raised on MS. Our users have a hard enough time
as it is with MS, asking them to change gears in mid stroke seems kind of
self-defeating.

Now, new companies and up and comers would be able to start differently, I'm
referring to the bigger companies here that would have problems.



-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 13, 2004 12:25 PM
To: CF-Talk
Subject: RE: OT - Windows NT source code

On Fri, 2004-02-13 at 09:00, Schuster, Steven wrote:
 How many companies with over 1,000 employees (and PC's) have you been with
 that ran Linux, FreeBSD or something similar on the desktop?

Not many on the U.S. desktop, no - but for back end systems open source
OSs are used quite a bit - 

In 1999, Linux scooted past Novell's Netware to become the No. 2 server
operating system behind Microsoft's Windows NT. Over the next four
years, IDC said, Linux shipments will grow at a rate of 28 percent, from
1.3 million in 1999 to 4.7 million in 2004.
-- CNET news

Linux surged from a 16% share of the server software market in 1998 to
a quarter of the market in 1999, when it shipped nearly twice as many
copies as during the previous year, according to figures from
International Data Corporation (IDC).
-- BBC news

And that's just Linux.

 The answer is: Not a whole lot.

I am not too sure about that - I think China (and a lot of other
countries) uses Linux quite a bit (even on the desktop) -- and there are
a few people in china I hear. I couldn't find any stats though

 So, if most business runs MS on the desktop they rely on it. There are
 enough hacks out there now without the source code causing problems. If
 somebody had the source code they could cripple industries that relied on
 the platform rather quickly.

Well when your right your right.

 Our jobs are time consuming enough without the added pressure of 16 year
old
 kids writing viruses all day aren't they.

I agree.

 If Linux was the most used OS in the world you better bet it wouldn't take
 long for exploit after exploit to hit that platform. With it being open
 source that simply makes the job that much easier.

Well I think Unix (the catch all) is the OS that has all the hard core
data in the world, but I haven't heard of a Unix worm or virus in a
while.

Your points are valid - I was just trying to make light and poke a bit
of fun.

All in good fun

-- 
Vale,
Rob

Luxuria immodica insaniam creat.
Sanam formam viatae conservate!

http://www.rohanclan.com http://www.rohanclan.com 
http://treebeard.sourceforge.net http://treebeard.sourceforge.net 
http://ashpool.sourceforge.net http://ashpool.sourceforge.net 

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




RE: ColdfusionMX Server?

2004-02-11 Thread Schuster, Steven
That sounds like a very very serious problem.

I would probably just turn it all off and go home for the day.

S

:-)



-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 11, 2004 10:13 AM
To: CF-Talk
Subject: Re: ColdfusionMX Server?

On Wed, 2004-02-11 at 07:01, John Ho wrote:
 I don't why all my application doesn't display
 anything?. When I open them, it doesn't show anything
 just a blank page. I can not open Coldfusion admin
 either. Do you know what wrong with this? Please help

John, that is not enough information for anyone to help you

-- 
Vale,
Rob

Luxuria immodica insaniam creat.
Sanam formam viatae conservate!

http://www.rohanclan.com http://www.rohanclan.com 
http://treebeard.sourceforge.net http://treebeard.sourceforge.net 
http://ashpool.sourceforge.net http://ashpool.sourceforge.net 

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




RE: MS Update broke security

2004-02-06 Thread Schuster, Steven
They didn't break it, it is supposed to not work that way. So actually they
fixed it.



-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 8:08 AM
To: CF-Talk
Subject: MS Update broke security

Here is the issue I have. A month ago I had a question about authentication
for basic authentication and how to do it with ColdFusion. I eventually
found out that you can do this http://user:[EMAIL PROTECTED]
http://user:[EMAIL PROTECTED]and the user won't be prompted for a
username or password. Well the last update of Internet Explorer broke this
functionality. So I ask everyone out there, how do I do this without making
the url that way. I have tried headers, cfheader and nothing I do seems to
make the browser know that it needs to cache that password for future use.
Is there anything in java I can do, anything at all. HELP!!

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




RE: MS Update broke security

2004-02-06 Thread Schuster, Steven
Roflmao

Ok that was funny...

Do the users have set IP addresses, you could use the CGI variables to maybe
do it that way. It would suck and be tied to a PC...nah that wouldn't
work



-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 10:08 AM
To: CF-Talk
Subject: Re: MS Update broke security

On Friday 06 Feb 2004 13:59 pm, Robert Everland III wrote:
 that's just it I can't use anythign that requires user intervention. 

Then you can't do security.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

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

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




RE: MS Update broke security

2004-02-06 Thread Schuster, Steven
For instance:

Putting the username and password in the URL. :-)

Steve



-Original Message-
From: Josh Remus [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 10:22 AM
To: CF-Talk
Subject: RE: MS Update broke security

Honestly, none of this has sounded secure at all, actually.
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 10:08 AM
To: CF-Talk
Subject: Re: MS Update broke security

On Friday 06 Feb 2004 13:59 pm, Robert Everland III wrote:
 that's just it I can't use anythign that requires user intervention.

Then you can't do security.

--
Tom Chiverton
Advanced ColdFusion Programmer

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

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




RE: IIS Headaches

2004-02-02 Thread Schuster, Steven
Just turn on Anonymous Access in the properties under IIS



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

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

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




RE: Selecting a specific row from the cfquery?

2004-01-21 Thread Schuster, Steven
I think you can access a query like an array so that might be the right
direction.

#Getitem[27].blah#

or it may be

#getitem.blh[27]#

for instance would get the 27th result set row

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 21, 2004 3:21 PM
To: CF-Talk
Subject: Selecting a specific row from the cfquery?

I'm trying to randomly bring back a specific row from a query recordset.
How do I do that? I can't figure it out. :-\
The query is GetItem and I'm using 
CFSET itemtodisplay = #RandRange(1,#getitem.recordcount#)#
So I need to display the #itemtodisplay# row of the query. 
Been looking through CFWACK but I haven't been able to figure how to
pull a specific row from a recordset but I just don't see that.
I know that queryname.currentrow displays the current row being output. 
But how do I specifically pull a row?

-Gel

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.559 / Virus Database: 351 - Release Date: 1/7/2004

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




ENCRYPT EXE Question

2004-01-18 Thread Schuster, Steven
Ok,

I know the version of encrypt has been broken for years (ie, programs
available online to decrypt the encrypted files)...but has anyone bothered
to see if the version in the latest MX 6.1 is any better. Is it possible to
pass a cipher key to ensure unique encryption that could then not be hacked
as easily as the old version. Or is it possible that they never even
bothered to upgrade it at all and no matter what I do it will always be able
to be decrypted?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: RE: cf administrator + odbc

2004-01-15 Thread Schuster, Steven
You can't install Enterprise or Standard I think all you can install is the
developer edition.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 15, 2004 1:01 PM
To: CF-Talk
Subject: Re: RE: cf administrator + odbc

 
SQL Server 2000 installs fine on XP.

- Original Message -
From: Burns, John [EMAIL PROTECTED]
Date: Thursday, January 15, 2004 10:37 am
Subject: RE: cf administrator + odbc

 How'd you get SQL server 2000 running on a Win XP machine?I thought
 when you tried installing the sql 2k server on win xp it told you that
 it couldn't install on that OS? 
 
 John Burns
 
 PS- Sorry I don't have any help for your initial question. 
 
 -Original Message-
 From: Won Lee [EMAIL PROTECTED] 
 Sent: Thursday, January 15, 2004 12:30 PM
 To: CF-Talk
 Subject: cf administrator + odbc
 
 Hello all,
 
 Looking through macromedia.com but not having too much luck on this.
 I'm trying to create an ODBC connection from my cf 5.0 running on 
 redhat9.0 to my sql server 2000 running on a win 2k3 machine.
 I'm confused because my cf server can create an ODBC connection to
 another sql server 2000 server on a win xp machine.
 
 I not only created a user but also tried the sa account in the
 cfsettings.
 Am I missing something?
 
 
 

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




RE: what is shtml

2004-01-14 Thread Schuster, Steven
shtml is the default extension for a page with server-side includes


Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 9:58 AM
To: CF-Talk
Subject: RE: what is shtml

 
definition:

SHTML
Web pages that contain SSIs often end with an shtml extension, though this
is not a requirement. The filename extension enables the Web server to
differentiate those pages that need to be processed before they are sent to
the browser.

I think its from the old days, where SSI's where used.


-Original Message-
From: Kevin Marino [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 9:58 AM
To: CF-Talk
Subject: OT: what is shtml

Ok, this may sound stupid, but what is shtml? How is it generated? And are
there some resources?

Crazy question, never used and just want to educate myself on them.

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




RE: Windows Authentication

2004-01-14 Thread Schuster, Steven
Yes and No, what Web Server are you using?



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 9:02 AM
To: CF-Talk
Subject: Windows Authentication

 
Ok I have an ISAPI application that can't be secure with usernames and
password, so the only way is if the user logs in with a windows username and
password. I am taking away all the NT users in favor of a database that has
all their names and passwords. Is there any way that I can make a CF page
that will log into windows with a specified username and password so that
they aren't prompted for a password.

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




RE: Windows Authentication

2004-01-14 Thread Schuster, Steven
Turn on Windows Integrated Security in IIS under the properties of the a.)
folder or b.) site you wish to integrate with the domain.


Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 9:16 AM
To: CF-Talk
Subject: Re:Windows Authentication

 
IIS 6.1

Yes and No, what Web Server are you using?
 
 

 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101


Office Phone 606.920.7447
Cell Phone 606.831.4590
 
 
_

From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 9:02 AM
To: CF-Talk
Subject: Windows Authentication
 
Ok I have an ISAPI application that can't be secure with usernames and
password, so the only way is if the user logs in with a windows username
and
password. I am taking away all the NT users in favor of a database that has
all their names and passwords. Is there any way that I can make a CF page
that will log into windows with a specified username and password so that
they aren't prompted for a password.

Bob
_


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




RE: ecommerce store and real store inventory

2004-01-14 Thread Schuster, Steven
Looks like you are out of luck. Unless you can talk to the DB then you can't
do it. 

 
How many orders do they receive a month/day etc. Is it even worth pursuing
for them. I mean if they get 1 order a day then I doubt it, but if they get
several hundred then that's a different story. Anyone using Retail Pro is
probably a small mom and pop or small business anyway so I doubt they would
have the money to invest in much.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: walker [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 10:24 AM
To: CF-Talk
Subject: Re: ecommerce store and real store inventory

 
I have a client who uses 'Retail Pro' for their point of sale system in the 
store(s) - every night a script runs to export the inventory data of the 
physical store to the website- and the ecommerce website runs off of the 
exported inventory data.

So obviously the online store isn't real time with the inventory in the 
physical store, but it works for them.

The problem is that orders from the website then need to be keyed back into 
the retail pro system to keep the inventory consistent.

I heard that 'Retail Pro' was coming out with a point of sale system that 
was ODBC compliant- so you could read and write to it... but I don't know 
if its out or not. The system my client uses is not ODBC.

- w

At 04:51 PM 1/13/2004, you wrote:
ok group. Here is one I can't seem to find information on.

I have been asked if a real world store that has a Cold Fusion based
webstore could tie their inventory to the website. If an item sells out in
the store, it would not be available on the website until restocked. They
have a CF Based website now and are willing to change their in-house
inventory system. Anyone else run into this idea?

Tony

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




Submit Question....

2004-01-14 Thread Schuster, Steven
Ok, this is dumb but...

 
Single-form...

 
Two submit buttonsboth go to the same page. How can I tell which submit
button was pressed in JS. Is there some button is true state I can look for
on submit types?



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 1:57 PM
To: CF-Talk
Subject: RE: CFScript StructInsert or cfset. Which is faster?

 
 I have a collection of parameters that I keep in a struct.
 Mostly out of a perceived feeling that this is tidier.I use 
 cfscript for this sort of thing for speed.It occurs to me I 
 should ask Those Who Know... would it be faster to just use 
 plain variables?Or a 2d array?An example is below.
 
 cfscript
 Parameters=StructNew();
 StructInsert(Parameters,AllowMultiEdit,);
 StructInsert(Parameters,AllowMultiAdd,);
 StructInsert(Parameters,TotalCols,(ListLen(variables.Fields)+2);
 StructInsert(Parameters,FooterColSpan,ParameterGroup.TotalCols+1);
 /cfscript

It makes no significant difference, and you should favor readability over
speed in this case anyway.

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




RE: Submit Question....

2004-01-14 Thread Schuster, Steven
Ok, I have it... Here is what I did...

 
If you use the BUTTON tag the value of the submit button contains whatever
is in between the button/button tags. So if you have 2 buttons and press
one the one you pressed will not be null and the other submit button will
be.

 
Easy enough...

 
Thanks,



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Philip Arnold [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 2:09 PM
To: CF-Talk
Subject: RE: Submit Question

 
 Ok, this is dumb but...

 Single-form...

 Two submit buttonsboth go to the same page. How can I
 tell which submit button was pressed in JS. Is there some
 button is true state I can look for on submit types?

2 options

1) Name the buttons - only the one pressed will be passed

BUT - if somebody hits return, then neither is pressed

2) Have a hidden field that when you click on the button, it runs a
function to set the value of the hidden field
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: General Comment about CF-Talk List.

2004-01-14 Thread Schuster, Steven
I think version 3.0 of the board will be out soon. It uses compressed energy
waves to actually split the space time continuum so it can answer your
questions even before you type them

 
There are still a few bugs though...those damn creepy crawlies from the
alternate universe keep killing the developers every time they press the
send buttonbut we are working on that!



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 2:11 PM
To: CF-Talk
Subject: WOT: General Comment about CF-Talk List.

 
I just wanted to drop a quick note and praise how good this list is.It is
so good that I get answers to my problems before I even finish writing the
first e-mail to ask the about the problem.I didn't even need to send the
message.You just can't beat a response turn around like that.

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

PS.Ok!It was the process of describing the problem and isolating the
code specific to the problem to include it that highlighted the solution
before I even sent the e-mail.But still, that's a pretty good turn around.
;)
Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Submit Question....

2004-01-14 Thread Schuster, Steven
Spoke too soon, nope had to do the hidden crap...oh well at least it
works...thanks



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 2:14 PM
To: CF-Talk
Subject: RE: Submit Question

 
Ok, I have it... Here is what I did...

If you use the BUTTON tag the value of the submit button contains whatever
is in between the button/button tags. So if you have 2 buttons and press
one the one you pressed will not be null and the other submit button will
be.

Easy enough...

Thanks,

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Philip Arnold [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 14, 2004 2:09 PM
To: CF-Talk
Subject: RE: Submit Question

 Ok, this is dumb but...

 Single-form...

 Two submit buttonsboth go to the same page. How can I
 tell which submit button was pressed in JS. Is there some
 button is true state I can look for on submit types?

2 options

1) Name the buttons - only the one pressed will be passed

BUT - if somebody hits return, then neither is pressed

2) Have a hidden field that when you click on the button, it runs a
function to set the value of the hidden field
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Sub Query of a QofQ

2004-01-13 Thread Schuster, Steven
Though this seems like a stupid question why not just use a left outer join?
 Of course I didn't see any code as I must have deleted the original so this
may all be moot.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 13, 2004 2:29 PM
To: CF-Talk
Subject: Sub Query of a QofQ

 
Hi 

Is it possible to have a simple query have a sub query using QofQ.It
sounds like it could work but how do you determine the datasource?

What I am getting at is 

cfquery datasource=mydsn

Select thedate from datetable where thedate in (select * from the
QofQResult)

/cfquery

How would you get the above to work?

Thanks

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




RE: Something for ASP like livedocs

2004-01-13 Thread Schuster, Steven
MSDN Online.

 
Msdn.microsoft.com

 
Also, you can get MSDN Library as well. CD's or DVD versions full of bunches
of crap



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 13, 2004 2:17 PM
To: CF-Talk
Subject: Something for ASP like livedocs

 
The docs that come with ColdFusion have always been pretty good. I need
something that has the same kind of functionality for ASP. Anyone have any
good references that is similar to that or has the same kind of content. 

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




RE: ampersands in a XML object

2004-01-13 Thread Schuster, Steven
Use the special character amp;

 
That works in my XML docs



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: David Adams [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 13, 2004 2:20 PM
To: CF-Talk
Subject: ampersands in a XML object 

 
I need to have an ampersand in a XML object such as:

linkURLhttp://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforu
mid=4/linkURL

Unfortunately, XML and CF complain about this.Any advice?
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: real quick ot

2004-01-13 Thread Schuster, Steven
I used VSS a long time ago, back when 3.1 or 4.0 supported it. They lied, it
sucked



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 13, 2004 3:57 PM
To: CF-Talk
Subject: real quick ot

 
does anyone here use version control for web apps?

my CTO is dying for me to version control our company intranet
and I cant explain to him enough that in the 10 freakin years ive
been building web apps, that ive never heard of a VERSION.

since web sites are a single point of distribution, and as soon as someone 
loads a page they have the new version, WHATS THE POINT?

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
I can assure you that storing images in BLOB does not bloat a database. They
are designed for this very thing. Though I will admit that Oracle is far
better than SQL Server at doing it. I have never really dealt with mySQL and
it's been years since I used Informix so I can't tell you much on those
products.

 
We do this for our fax apps. We store all types of data in Oracle BLOBS and
it is actually faster than file writes. We use a JSP page to do the pulls
and puts. In fact we even integrated it into our PeopleSoft product so that
our remote locations can now just fax in new hire documents, the faxes go
directly to the database and are available for viewing through the Job panel
in PS.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 10:42 AM
To: CF-Talk
Subject: Re: Images - store in DB or filesystem?

 
I've always heard path in text fields.From what I understand, storing as
BLOBs will bloat the db, and it's rather slow.

- Original Message - 
From: Spectrum WebDesign 
To: CF-Talk 
Sent: Friday, January 09, 2004 8:15 AM
Subject: Images - store in DB or filesystem?

What's the in/out for image storage? Bynary in BLOB database fields or
file system or path in text fields?

- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
Date: Fri, 9 Jan 2004 15:40:16 +0100
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: insert multiple drop down list selects into access

Looks like you want a one-to many relationship. Create a second table for
that (with a FK to the existing table). Then loop over the list and insert
in the second table within the loop (using the PK from the record in the
first table as FK in the second table)

-Oorspronkelijk bericht- 
Van: Tim Laureska [mailto:[EMAIL PROTECTED] 
Verzonden: vr 9/01/2004 15:15 
Aan: CF-Talk 
CC: 
Onderwerp: insert multiple drop down list selects into access

Is it possible to insert into one access database number field, a comma
delimited list of numbers, received from a form template thusly (is not
working now ... only can one number to show in the database when
multiples are selected on the form drop down):

FORM CODE:
select name=cat_no multiple
cfoutput query=client_catoption
value=#cat_no##work_cat#/cfoutput
/select

TEMPLATE WHERE DATABASE INSERT IS HAPPENING:

cfquery datasource=todo dbtype=odbc
INSERT into clients (category)
VALUES (#cat_no#)
/cfquery

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




RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
Hmm, that's odd I thought that was what InterMedia from Oracle was all
about? Of course they just scratched the surface in 8i but in 9i it's all
about that. I can search binary data, both clob and blob. They can be stored
within the database structure itself or in separate files associated with
the db structure. They have little or nothing to do at all with relational
modeling. 

 
We currently have functionality that allows us to store PDF in Oracle and
search the BLOB for content. Now, of course, that won't work with images and
more proprietary formats that are not conducive to text searching but it
works perfect for us. We even ran comparisons against retrieval and write
vs. write/read. So long as you stream output using JSPwe find that the DB
is faster than the filesystem most always.

 
Granted our Oracle environment runs on Digital UNIX so I haven't tried this
on NT running UNIX. Also If you are on SQL server I am sure the differences
may be somewhat less desirable as well.

 
But that's just IMHO regardless.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 11:15 AM
To: CF-Talk
Subject: RE: Images - store in DB or filesystem?

 
 I can assure you that storing images in BLOB does not bloat a 
 database. They are designed for this very thing.

I would agree with you about the choice of the word bloat, but relational
databases are hardly designed for storing binary data - it's purely an
afterthought at most. Relational databases are very good at storing and
retrieving character strings, and SQL is appropriate for searching character
strings. Neither is especially adept for working with binary data. In most
cases, I've found little or no benefit in storing binary data in a database
instead of just storing it on the filesystem, and in some cases, I've found
that filesystem storage performs a lot better and is easier to implement.

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




RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
Well I'm not sure about taking up less size at all. Now given you will have
to create an initial database but minus that it's just data. Regardless if
you go this route the space differences would be minimal.

 
If you want I can post the JSP code we use for retrieval?



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 11:04 AM
To: CF-Talk
Subject: Re: Images - store in DB or filesystem?

 
Hi Steven:

I'll have to defer to your experience here, as my answer was based only on a
response I got from an instructor when asking him this same question...so
I've always done it the text datatype/file path method.

Maybe 'bloat' was too strong of a word?Maybe he just meant that storing
the images as files would take up -less- space than storing them as BLOBs?

Charlie

- Original Message - 
From: Schuster, Steven 
To: CF-Talk 
Sent: Friday, January 09, 2004 8:47 AM
Subject: RE: Images - store in DB or filesystem?

I can assure you that storing images in BLOB does not bloat a database.
They
are designed for this very thing. Though I will admit that Oracle is far
better than SQL Server at doing it. I have never really dealt with mySQL
and
it's been years since I used Informix so I can't tell you much on those
products.

We do this for our fax apps. We store all types of data in Oracle BLOBS
and
it is actually faster than file writes. We use a JSP page to do the pulls
and puts. In fact we even integrated it into our PeopleSoft product so
that
our remote locations can now just fax in new hire documents, the faxes go
directly to the database and are available for viewing through the Job
panel
in PS.

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 _

From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 10:42 AM
To: CF-Talk
Subject: Re: Images - store in DB or filesystem?

I've always heard path in text fields.From what I understand, storing as
BLOBs will bloat the db, and it's rather slow.

 - Original Message - 
 From: Spectrum WebDesign 
 To: CF-Talk 
 Sent: Friday, January 09, 2004 8:15 AM
 Subject: Images - store in DB or filesystem?

 What's the in/out for image storage? Bynary in BLOB database fields or
file system or path in text fields?

 - Original Message -
 From: Pascal Peters [EMAIL PROTECTED]
 Date: Fri, 9 Jan 2004 15:40:16 +0100
 To: CF-Talk [EMAIL PROTECTED]
 Subject: RE: insert multiple drop down list selects into access

 Looks like you want a one-to many relationship. Create a second table
for
that (with a FK to the existing table). Then loop over the list and insert
in the second table within the loop (using the PK from the record in the
first table as FK in the second table)

 -Oorspronkelijk bericht- 
 Van: Tim Laureska [mailto:[EMAIL PROTECTED] 
 Verzonden: vr 9/01/2004 15:15 
 Aan: CF-Talk 
 CC: 
 Onderwerp: insert multiple drop down list selects into access

 Is it possible to insert into one access database number field, a comma
 delimited list of numbers, received from a form template thusly (is not
 working now ... only can one number to show in the database when
 multiples are selected on the form drop down):

 FORM CODE:
 select name=cat_no multiple
 cfoutput query=client_catoption
 value=#cat_no##work_cat#/cfoutput
 /select

 TEMPLATE WHERE DATABASE INSERT IS HAPPENING:

 cfquery datasource=todo dbtype=odbc
 INSERT into clients (category)
 VALUES (#cat_no#)
 /cfquery

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




RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_____

From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 12:40 PM
To: CF-Talk
Subject: RE: Images - store in DB or filesystem?

 
Well I'm not sure about taking up less size at all. Now given you will have
to create an initial database but minus that it's just data. Regardless if
you go this route the space differences would be minimal.

If you want I can post the JSP code we use for retrieval?

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 11:04 AM
To: CF-Talk
Subject: Re: Images - store in DB or filesystem?

Hi Steven:

I'll have to defer to your experience here, as my answer was based only on a
response I got from an instructor when asking him this same question...so
I've always done it the text datatype/file path method.

Maybe 'bloat' was too strong of a word?Maybe he just meant that storing
the images as files would take up -less- space than storing them as BLOBs?

Charlie

- Original Message ----- 
From: Schuster, Steven 
To: CF-Talk 
Sent: Friday, January 09, 2004 8:47 AM
Subject: RE: Images - store in DB or filesystem?

I can assure you that storing images in BLOB does not bloat a database.
They
are designed for this very thing. Though I will admit that Oracle is far
better than SQL Server at doing it. I have never really dealt with mySQL
and
it's been years since I used Informix so I can't tell you much on those
products.

We do this for our fax apps. We store all types of data in Oracle BLOBS
and
it is actually faster than file writes. We use a JSP page to do the pulls
and puts. In fact we even integrated it into our PeopleSoft product so
that
our remote locations can now just fax in new hire documents, the faxes go
directly to the database and are available for viewing through the Job
panel
in PS.

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 _

From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 10:42 AM
To: CF-Talk
Subject: Re: Images - store in DB or filesystem?

I've always heard path in text fields.From what I understand, storing as
BLOBs will bloat the db, and it's rather slow.

 - Original Message - 
 From: Spectrum WebDesign 
 To: CF-Talk 
 Sent: Friday, January 09, 2004 8:15 AM
 Subject: Images - store in DB or filesystem?

 What's the in/out for image storage? Bynary in BLOB database fields or
file system or path in text fields?

 - Original Message -
 From: Pascal Peters [EMAIL PROTECTED]
 Date: Fri, 9 Jan 2004 15:40:16 +0100
 To: CF-Talk [EMAIL PROTECTED]
 Subject: RE: insert multiple drop down list selects into access

 Looks like you want a one-to many relationship. Create a second table
for
that (with a FK to the existing table). Then loop over the list and insert
in the second table within the loop (using the PK from the record in the
first table as FK in the second table)

 -Oorspronkelijk bericht- 
 Van: Tim Laureska [mailto:[EMAIL PROTECTED] 
 Verzonden: vr 9/01/2004 15:15 
 Aan: CF-Talk 
 CC: 
 Onderwerp: insert multiple drop down list selects into access

 Is it possible to insert into one access database number field, a comma
 delimited list of numbers, received from a form template thusly (is not
 working now ... only can one number to show in the database when
 multiples are selected on the form drop down):

 FORM CODE:
 select name=cat_no multiple
 cfoutput query=client_catoption
 value=#cat_no##work_cat#/cfoutput
 /select

 TEMPLATE WHERE DATABASE INSERT IS HAPPENING:

 cfquery datasource=todo dbtype=odbc
 INSERT into clients (category)
 VALUES (#cat_no#)
 /cfquery

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




RE: Need help with MS Word Automation

2004-01-09 Thread Schuster, Steven
You are opening a can of worms...I don't recommend this..

But try www.cfcomet.com http://www.cfcomet.com/ 

 
And use OWA or whatever it is called. It is for Office and makes '00 and '03
automation much easier.


Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Shawn Grover [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 1:06 PM
To: CF-Talk
Subject: Need help with MS Word Automation

 
I am having problems finding information on using Word Automation.What I
am trying to do is use CFMX (6.0) to open a MS Word template (.dot file),
find the bookmarks in the file, insert data from our database at the
bookmark locations, and then save the document as a new file on the server.
Once the file has been saved, I need to push it to the client browser (via a
UNC path).

I think I have the information I need to work with the bookmarks, and know
how to push the resulting file to the client.But I'm having problems
reliably opening the word.application object.

I'm sure this has been done before but am finding very little references in
how to do it.Am I just misreading what I have found?Is there some trick
that I don't know about? 

Thanks for any tips.

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




RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
I did, let me dig around and see if I can find them.

 
I already posted the JSP code, here is the CF equivalent that writes the
file to disk and lets you view them. This doesn't take any more space either
as the cfcontent tag simply deletes the file after it has streamed to the
browser.

cfparam name=SID default=None
cfparam name=ID default=0
cfparam name=Table default=None
cfparam name=Extn default=ext
cfparam name=UidField default=ID
cfparam name=MediaField default=Media
cfparam name=DirectorySet default=c:\inetpub\wwwroot\Faxed\viewacts\

 
cfif #ID# IS 0
p
General Error Occured
/p
cfabort
cfelse
cftry
CFQUERY name=qryGetCV datasource=#SID#
SELECT *
FROM #Table#
WHERE #uidfield# = #ID# 
/CFQUERY

cfcatch type=Database
A general database error has occured
trying to run the specified query!
p
SELECT *
FROM #Table#
WHERE #uidfield# = #ID# 
/p
cfabort
/cfcatch
/cftry

!--- Create the Temp Files ---
cfdirectory directory=#DirectorySet# name=qryFindIt
cfset temp = ValueList(qryFindIt.Name)

 
cfoutput query=qryGetCV
cfset FileVal = #Evaluate(qryGetCV. 
#uidfield#)#  .  #Evaluate(qryGetCV.  #Extn#)#
cfset myCount = ListValueCount(temp, FileVal)
cfif #myCount# IS 1
!--- Skip For Now ---
cfelse
cffile action="">
file=#DirectorySet##FileVal# output=#toBinary(Evaluate(qryGetCV. 
#mediafield#))# addnewline=No
/cfif
/cfoutput

 
cfset Ext =#Evaluate(qryGetCV.  #Extn#)#

!--- Display File in Browser ---
!--- Also deleted the file after it has been written to
conserve space ---
cfif Ext IS PDF
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=application/pdf
deletefile
cfelseif Ext IS TIFF or Ext IS TIF
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=image/tiff deletefile 
cfelseif Ext IS GIF
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=image/gif deletefile 
cfelseif Ext IS BMP
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=image/bmp deletefile 
cfelseif ucase(Ext) IS MAX
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=application/max deletefile

cfelseif Ext IS CSV
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=application/vnd.ms-excel
deletefile 
cfelseif Ext IS XLS
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=application/vnd.ms-excel
deletefile 
cfelseif Ext IS DOC
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=application/msword
deletefile 
cfelseif Ext IS MP3
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=audio/x-mpeg3 deletefile 
cfelseif Ext IS TXT
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile 
cfelseif Ext IS HTM
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile 
cfelse
cfcontent
file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile 
/cfif

/cfif

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Kevin Graeme [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 09, 2004 1:51 PM
To: CF-Talk
Subject: Re: Images - store in DB or filesystem?

 
Do you have a rough estimate of the performance difference of using this
streamed output via JSP compared to just doing a standard CF query?

-Kevin

- Original Message - 
From: Schuster, Steven [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 09, 2004 11:45 AM
Subject: RE: Images - store in DB or filesystem?

 For Inserts we just use the cf_blob type in MX 6.1 and do a direct insert
 into the blob.

 To retrieve we have this JSP page. This allows a direct stream read to the
 browser and does not write the file to the system and then attempt to read
 it. But we have code that does that as well if you need to look at it
also.

 This is a JSP page so you must be running MX for this to work (or a JSP
 alternative)
[snip
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFDJ isn't exactly kicking bootay

2004-01-08 Thread Schuster, Steven
Also consider the Cold Fusion programming is not as widespread as say .NET
or some others. Whereas you can get literally hundreds of books on .NET,
JAVA etc CF has a few dozen. The audience has been pretty stable since back
in the late 90's and stayed that way.

 
** A side note ** 
Personally the reason I think MACR even originally bought Allaire was
because the Generator project they had sucked so bad and they needed a good
application engine that had great web functionality and would integrate into
Flash more readily. Well, Bingo! To boot they also get all of the loyal CF
developers who, for better or worse, will stick with the system because they
love it.

 
I remember back in the Team Allaire days when A. Guthrie (sp) sent out all
the stuff on the changes. Man how I long for the good ol' Allaire days

 
** End side note **

 
Well anyway, because of this you are not going to see a lot of people out
there getting these mags. Not to mention that lists like this plus others
provide free help as well. Generally I find that I need help with a very
specific item and more often than not the mags don't cover what I am
wanting. They do look nice on my rack at work though next to my other JAVA
and .NET mags.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Samuel Neff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 08, 2004 8:57 AM
To: CF-Talk
Subject: RE: CFDJ isn't exactly kicking bootay

 
Dave,

Keep in mind that with the lower subscription rate mentioned earlier, and
especially with the low potential subscription rate (there are a lot less CF
users than there are people that can read Time magazine), sys-con is going
to get a lot less from advertising than magazines with a higher subscription
rate.They have a lot less to work with and I think they do a great job
with what they have.

Also remember that the authors are not paid for their articles, they are
voluntary contributions.With that being the case, there aren't too many
people that would do it on a regular basis.I've contributed a few
articles, but it's certainly not something I'd like to do more than a few
times a year since it does take a lot of time and that's time I can spend
doing other things (like earning money).

I'll agree that there is a lot more information available for free now than
there used to be, but you have to be careful about editorial quality and
even accuracy.The vast majority of blogs post small snippets and not full
articles like in a magazine, and many blogs post incorrect information.
With CFDJ, there is an assurance of some level of quality (not perfection,
but a certain level) due to the editorial review and CFDJ's review board.

My $0.02

Best regards,

Sam

--
Blog:http://www.rewindlife.com http://www.rewindlife.com 
Chart: http://www.blinex.com/products/charting
http://www.blinex.com/products/charting 
--

-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 1:26 AM
To: CF-Talk
Subject: Re: CFDJ isn't exactly kicking bootay

Simon,

With all due respect to both you and your valuable contributions, I have to
say that I entirely disagree. I used to have a subscription to CFDJ. But for
$49 USD/year, it's absolute bottom of the barrel. Your monthly column
contribution is useful (along with your papers on www.how2cf.com/), and
Brendan O'Hara's Design Patterns series was invaluable (at least, to me).
But the magazine overall really is a joke for what you get. You get articles
that just barely touch on what I really care about (I want useful topics
with meaty code samples as opposed to hello world theoretical statements
and the aggravating poorly written code snippets), and the price of the
subscription is almost twice what Time magazine costs me (and, oh by the
way, Time is a *weekly* publication with a helluva lot more relevant
information. The last issue of CFDJ was 52 pages. Of the 52, I think *maybe*
half actually had article content. The rest was advertisements and promos
that I could care less about. As for relevancy, by the time the monthly
issue comes out, most hot topics are outdated, such as hotfix
announcements, etc.

Honestly, between the numerous blogs at fullasagoog.com, and CF-Talk,
CFCDev, and some other mailing lists, CFDJ is a complete rip-off. I like to
buy virtually everything associated with CF (books, magazines, training,
etc.). But I have to say that, of all the resources out there for
ColdFusion, CFDJ is absolutely the last resource I would refer to if I ever
needed advice or direction on a particular issue. And don't get me started
on their website...

Please don't take this as a personal attack, as I have great respect for
everything you contribute to the CF community. But if there are people out
there wondering if it's worth taking the risk of 

RE: CFContent Excel design woes

2004-01-08 Thread Schuster, Steven
Because office 97 isn't designed to read them at all. You do mean CSS sheets
correct? I thought you had to use Office 2000 or later for that stuff
(unless there exists some widget plugin I never used, but I haven't used
office 97 in like 4 years)



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 08, 2004 9:09 AM
To: CF-Talk
Subject: RE: CFContent Excel design woes

 
I still have not been able to figure out the source of the difference.
Anyone have any ideas why Office 97 wouldn't read a stylesheet file right?

Thanks!
Hatton

_

From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 06, 2004 4:28 PM
To: CF-Talk
Subject: SOT: CFContent Excel design woes

Okay, this is only slightly off topic but I don't know where else to look
for answers.

I built a spreadsheet export that uses CFContent to create an Excel
spreadsheet.I'm using CSS in that file to border some of the cells to
create a cleaner output look to the sheet.We've been testing it on Excel
2000 and everything works perfectly.Today the client looks at it and asks
for lines.Turns out they're running Excel 97, and a screenshot confirmed
their comment, there are no lines (cell borders) in the file.

Anyone hear anything like this before?Any suggestions to correct the
issue?

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Loop Question - Hiding Second Occurrence of a Variable?

2004-01-08 Thread Schuster, Steven
Could you send the query you are using. The Group tag should do what you are
describing with cfoutput.


Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Lola Lee [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 08, 2004 9:12 AM
To: CF-Talk
Subject: RE: Loop Question - Hiding Second Occurrence of a Variable?

 
At 7:48 PM -0500 1/7/04, Dave Watts wrote:
The easiest way to show a hierarchical relationship in your data is to use
the GROUP attribute of CFOUTPUT:

Cfoutput query doesn't return all the records in the yarn table, 
which is why I'm using cfloop.

While thinking about this on the metro, I thought of another approach 
that might work.How about this:

Create a structure containing all the records from the query.Loop 
through the structure, comparing the cell holding mfr_desc to the 
previous cell.If it matches, then replace the value with nbsp;. 
Once the replacing has been done, output the modified structure into 
the table.

-- 

Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net http://www.lolajl.net| Blog at
http://www.lolajl.net/blog/ http://www.lolajl.net/blog/ 
Check out this blog:http://www.denbeste.nu http://www.denbeste.nu 
I'm in Bowie, MD, USA, halfway between DC and Annapolis.
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFDJ isn't exactly kicking bootay

2004-01-08 Thread Schuster, Steven
http://www.msnbc.msn.com/id/3899043/ http://www.msnbc.msn.com/id/3899043/ 

 
Isn't this just too precious



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Samuel Neff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 08, 2004 8:57 AM
To: CF-Talk
Subject: RE: CFDJ isn't exactly kicking bootay

 
Dave,

Keep in mind that with the lower subscription rate mentioned earlier, and
especially with the low potential subscription rate (there are a lot less CF
users than there are people that can read Time magazine), sys-con is going
to get a lot less from advertising than magazines with a higher subscription
rate.They have a lot less to work with and I think they do a great job
with what they have.

Also remember that the authors are not paid for their articles, they are
voluntary contributions.With that being the case, there aren't too many
people that would do it on a regular basis.I've contributed a few
articles, but it's certainly not something I'd like to do more than a few
times a year since it does take a lot of time and that's time I can spend
doing other things (like earning money).

I'll agree that there is a lot more information available for free now than
there used to be, but you have to be careful about editorial quality and
even accuracy.The vast majority of blogs post small snippets and not full
articles like in a magazine, and many blogs post incorrect information.
With CFDJ, there is an assurance of some level of quality (not perfection,
but a certain level) due to the editorial review and CFDJ's review board.

My $0.02

Best regards,

Sam

--
Blog:http://www.rewindlife.com http://www.rewindlife.com 
Chart: http://www.blinex.com/products/charting
http://www.blinex.com/products/charting 
--

-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 1:26 AM
To: CF-Talk
Subject: Re: CFDJ isn't exactly kicking bootay

Simon,

With all due respect to both you and your valuable contributions, I have to
say that I entirely disagree. I used to have a subscription to CFDJ. But for
$49 USD/year, it's absolute bottom of the barrel. Your monthly column
contribution is useful (along with your papers on www.how2cf.com/), and
Brendan O'Hara's Design Patterns series was invaluable (at least, to me).
But the magazine overall really is a joke for what you get. You get articles
that just barely touch on what I really care about (I want useful topics
with meaty code samples as opposed to hello world theoretical statements
and the aggravating poorly written code snippets), and the price of the
subscription is almost twice what Time magazine costs me (and, oh by the
way, Time is a *weekly* publication with a helluva lot more relevant
information. The last issue of CFDJ was 52 pages. Of the 52, I think *maybe*
half actually had article content. The rest was advertisements and promos
that I could care less about. As for relevancy, by the time the monthly
issue comes out, most hot topics are outdated, such as hotfix
announcements, etc.

Honestly, between the numerous blogs at fullasagoog.com, and CF-Talk,
CFCDev, and some other mailing lists, CFDJ is a complete rip-off. I like to
buy virtually everything associated with CF (books, magazines, training,
etc.). But I have to say that, of all the resources out there for
ColdFusion, CFDJ is absolutely the last resource I would refer to if I ever
needed advice or direction on a particular issue. And don't get me started
on their website...

Please don't take this as a personal attack, as I have great respect for
everything you contribute to the CF community. But if there are people out
there wondering if it's worth taking the risk of subscribing to CFDJ,
especially when there aren't corporate pocketbooks to pick up the bill, I
think my opinion is pretty clear.

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




RE: CFContent Excel design woes

2004-01-08 Thread Schuster, Steven
This would be uber nasty but you may be able to use COM to modify the excel
file after it was created ...oh nevermind that would just be too horrid.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 08, 2004 10:26 AM
To: CF-Talk
Subject: RE: CFContent Excel design woes

 
 On Thursday 08 Jan 2004 14:08 pm, C. Hatton Humphrey wrote:
  I still have not been able to figure out the source of the 
 difference.
  Anyone have any ideas why Office 97 wouldn't read a 
 stylesheet file right?
 
 If there weren't any bugs, you'd never upgrade to 'Office XP 
 2004 bling edition' :-)

Can't quite tell this to a paying client.

Hatton

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Learning .NET (c-sharp) books

2004-01-08 Thread Schuster, Steven
Be sure you read books on the Framework and ADO though. I would recommend
reading those first as it makes the C# read a lot easier. Generally speaking
if you know C++ you should have no problems with C#. The Framework books
help you with all of the libraries. 

 
The ADO books with the new ADO stuff, it's pretty darn slick.

 
If you are not versed in traditional OOP languages then a book on OOP
wouldn't be a bad idea either.


Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Ben Densmore [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 08, 2004 10:29 AM
To: CF-Talk
Subject: RE: Learning .NET (c-sharp) books

 
Oliver,

I got this book which is pretty good. It's called C#: A Programmers
Introduction by Harvey Deitel. He explains things really well and starts
from the beginning. The ISBN is: 0130461326

Ben

-Original Message-
From: Oliver Cookson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 08, 2004 9:35 AM
To: CF-Talk
Subject: OT: Learning .NET (c-sharp) books

Hi,
I need to learn .NET (c-sharp) this year to comply with works learning
ethos so I was wondering if anyone can recommend any books for learning
.NET from the ground up. I know the methodology of OOP but may need some
reminders.
I like Forta's style of writing books if that helps. :)
Thanks

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




RE: CFContent Excel design woes

2004-01-08 Thread Schuster, Steven
Could you duplicate the effect with HTML 3 commands? Also, does it have to
be EXCEL? There are Excel Readers for Office 200, '03 etc that ma work but I
doubt they would be able to play around with the data. Also, a table-widget
could make it look real nice on the web and give online sorting abilities
and nice print features as well. I used some for a cash forcasting app I
wrote a few months back.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Samuel Neff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 08, 2004 10:30 AM
To: CF-Talk
Subject: RE: CFContent Excel design woes

 
If the paying client requires Office 97 support than redo the output and
don't use CSS.Have to program to lowest common denominator and if in this
case that doesn't include CSS than don't use CSS.

Client should know if this decision is going to cost more money and make an
informed decision, but it's still client's decision to make (at least in my
opinion).

Sam

--
Blog:http://www.rewindlife.com http://www.rewindlife.com 
Chart: http://www.blinex.com/products/charting
http://www.blinex.com/products/charting 
--

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 10:26 AM
To: CF-Talk
Subject: RE: CFContent Excel design woes

 On Thursday 08 Jan 2004 14:08 pm, C. Hatton Humphrey wrote:
  I still have not been able to figure out the source of the
 difference.
  Anyone have any ideas why Office 97 wouldn't read a
 stylesheet file right?

 If there weren't any bugs, you'd never upgrade to 'Office XP
 2004 bling edition' :-)

Can't quite tell this to a paying client.

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




RE: CF MX 6.1 and com objects

2004-01-07 Thread Schuster, Steven
Sure, no problem.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Andrew Scott [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 06, 2004 6:45 PM
To: CF-Talk
Subject: RE: CF MX 6.1 and com objects

 
Thanks Steven, I was looking at that yesterday. But couldn't figure out how
to achieve that, I'll have a play around with it this week and see what I
can do.

If you don't mind me contacting you again if I run into trouble.

Regards
Andrew Scott
Technical Consultant

NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: 03 9686 0485-Fax: 03 9699 7976

_

From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 7 January 2004 12:53 AM
To: CF-Talk
Subject: RE: CF MX 6.1 and com objects

You probably do indeed have it working but not natively. .NET is the
replacement for COM. COM has a different internal architecture from .NET and
thus they are not compatibility natively. That is why you have to use the
RCW which translates specific calls from managed clients into COM specific
invocation requests on unmanaged COM components. Basically this makes the
.NET components think they are talking to another .NET component.

This is how it is implemented:
Create a RCW out of the COM component
Ref. the metadata assembly Dl lint he project and use its
methods and properties

You can do the RCW step using the Type Library Importer utility or the
VS.Net IDE. 

Ex.) This generates metadata assembly with the name IopExampleRCW.dll out of
the COM IopExamlple.dll
Command line: tlbimp IopExample.dll /output:IopExampleRCW.dll /verbose 

In VS.NET IDE you would go to Project -Add Reference-COM tab...

All of this is based on the fact that you have already registered the
original COM component as well. Unless you register the original COM
component none of this will work at all. This will work in all .Net
invocations from C#, VB.NET and ASP.NET (et al.)

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 7:49 PM
To: CF-Talk
Subject: RE: CF MX 6.1 and com objects

.Net does support com, I have it working here now. Secondly I am creating
code that can be used by Windows Applications as well as ASP applications
and coldfusion applications that will share common business logic.
Blacknight does not support what I am trying to achive, so I am correct when
I say I am not looking for a wrapper solution.

Further discovery shows that I need to setup a DLLRegistrerServer or
something.

Regards
Andrew Scott
Technical Consultant

NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: 03 9686 0485-Fax: 03 9699 7976
_ 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea

2004-01-07 Thread Schuster, Steven
Just curious, OOP doesn't really apply to CF so why the OOP stuff?

 
I have read all the crud where people say CFC's are like OOP but it just
isn't true. Now OOP concepts may have been a better choice of words because
that would imply the ability to understand the reasons why but not
necessarily the implementation of such concepts.

 
I suppose people could say that CFC's make you think about reuse but to be
honest when I programmed in C (well before C++ caught on) I was using code
reuse and nobody called it OOP. I had libraries built for all kinds of off
the wall crud.

 
But what do I knownot meant to diss the post just a thought I had as I
glanced over it.



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Justin Hansen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 07, 2004 10:18 AM
To: CF-Talk
Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area

 
Cold Fusion Web Developer/Programmer Position - Kansas City Area

Uhlig Communications, Inc., is an advanced-technology publishing company
specializing in variable-data printing.

We are offering an outstanding career opportunity for a Web
Developer/Programmer with exceptional Programming and Application
Development experience. As a Developer, you will take part in the
design, programming, testing and implementation of highly innovative,
new publishing concepts. 

Qualified individuals will have 3+ years experience developing
ColdFusionMX applications. Necessary skills include: CFCs, SQL 2k, XML 
OOP. Additional knowledge of FlashMX, FireworksMX, design skills a plus.

Excellent organizational, communication, and interpersonal skills. Must
be team player, able to work independently (manage own work effectively,
show initiative, able to focus and prioritize) but seek assistance
readily when needed. A strong record of delivering projects on schedule
is key.

We offer competitive compensation and benefits including 401(k) with
matching and a culture that fosters business and professional growth. We
work in a modern, high-technology office environment, and offer generous
opportunities for continuing work-related education and career
advancement. EOE

Qualified individuals please email resume to [EMAIL PROTECTED]
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea

2004-01-07 Thread Schuster, Steven
Ahh, if that is the case they will need to add JAVA and JSP to the list as
well then.

 
But it wasn't mentioned. If I was looking for a .NET developer I would
expect them to know the framework, C#, VB, etc. But if all I wanted was a C#
coder I would only expect them to know the framework and C#.

 
I guess it's all just semantics



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Jim Campbell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 07, 2004 10:50 AM
To: CF-Talk
Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City A
rea

 
Since they're using MX, then they may likely be looking at writing 
supporting framework(s) in J2EE, which would certainly benefit from a 
developer with Object-Oriented development experience.

- Jim

Schuster, Steven wrote:

 Just curious, OOP doesn't really apply to CF so why the OOP stuff?


 I have read all the crud where people say CFC's are like OOP but it just
 isn't true. Now OOP concepts may have been a better choice of words 
 because
 that would imply the ability to understand the reasons why but not
 necessarily the implementation of such concepts.


 I suppose people could say that CFC's make you think about reuse but to be
 honest when I programmed in C (well before C++ caught on) I was using code
 reuse and nobody called it OOP. I had libraries built for all kinds of off
 the wall crud.


 But what do I knownot meant to diss the post just a thought I had as I
 glanced over it.



 Stephen E. Schuster
 PeopleSoft Administrator
 2000 Ashland Drive
 Ashland, KY 41101

 Office Phone 606.920.7447
 Cell Phone 606.831.4590

_

 From: Justin Hansen [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, January 07, 2004 10:18 AM
 To: CF-Talk
 Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area


 Cold Fusion Web Developer/Programmer Position - Kansas City Area

 Uhlig Communications, Inc., is an advanced-technology publishing company
 specializing in variable-data printing.

 We are offering an outstanding career opportunity for a Web
 Developer/Programmer with exceptional Programming and Application
 Development experience. As a Developer, you will take part in the
 design, programming, testing and implementation of highly innovative,
 new publishing concepts.

 Qualified individuals will have 3+ years experience developing
 ColdFusionMX applications. Necessary skills include: CFCs, SQL 2k, XML 
 OOP. Additional knowledge of FlashMX, FireworksMX, design skills a plus.

 Excellent organizational, communication, and interpersonal skills. Must
 be team player, able to work independently (manage own work effectively,
 show initiative, able to focus and prioritize) but seek assistance
 readily when needed. A strong record of delivering projects on schedule
 is key.

 We offer competitive compensation and benefits including 401(k) with
 matching and a culture that fosters business and professional growth. We
 work in a modern, high-technology office environment, and offer generous
 opportunities for continuing work-related education and career
 advancement. EOE

 Qualified individuals please email resume to [EMAIL PROTECTED]
_

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




RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea

2004-01-07 Thread Schuster, Steven
Rolling on the floor laughing my ass off



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Robert Redpath [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 07, 2004 1:28 PM
To: CF-Talk
Subject: RE: Cold Fusion Web Developer/Programmer Position - Kansas City A
rea

 
what the heck is ROTFLMAO?

-Original Message-
From: Doug White [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 12:45 PM
To: CF-Talk
Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City
Area

ROTFLMAO!

- Original Message - 
From: Tim H [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 8:25 AM
Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City
Area

: And as we all can tell, you're probably just a barrel of monkeys to work
with
: too. Too bad for Uhlig Corp.
: 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea

2004-01-07 Thread Schuster, Steven
That's called nailing it home.

 
:-)



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Tim Hanbey [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 07, 2004 3:06 PM
To: CF-Talk
Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City A
rea

 
The extended features of OOP like inheritance and polymorphism is what 
makes OOP--OOP. If we were to say ok well since we putting this code 
into a file and makingthe code in the file is a function that can be 
called is really not Object Oriented Programming.

It sounds like you are trying to describe Reusing Code by modularizing 
it, which yes, is an aspect of OOP but isn't the full thing. You can''t 
write object oriented code without an object oriented language. the 
makes sense doesnt it? you can try and you can call your module, 
function or code an object, but it really isn't an object because it 
doesn't behave like one.

If I were an OOP programmer using Java and C++ and someone told me that 
other people could callthemselves OOP programmers simply because they 
can create objects with HTML. I'd be kinda mad.

OOP is a fundamental concept of programming, but you can't program using 
OOP if you aren't using an OOP language.

nuff said

-Tim

Cantrell, Adam wrote:

 I have read all the crud where people say CFC's are like OOP but it
 just isn't true.

 The middle letter in OOP stands for Oriented. When I think of that word I
 think of becoming familiar with and somewhat following the general 
 idea of
 whatever subject is at hand. When I apply that to Object Oriented
 Programming, I simply think of orienting my code around self contained
 entities that hide their details and inner workings behind methods -
 car.drive(). The part that I think is most important is deciding what
 becomes an object and then how the objects work together, not the 
 syntax and
 extended features that make it easier to work with objects like 
 inheritance
 and all the rest. There should be a term to describe this very simple,
 high-level concept, and it seems like using the term Oriented is right on.
 Maybe we just need a new acronym to more accurately describe the specific
 syntax of OOP when it was a concept that was exclusive to lower level
 language circles, because it sounds kind of silly to say you're not
 orienting yourself correctly when people are just trying to benefit from
 organizing their code around objects but might be veering a little from
 tradition. I hereby submit this new acronym, I hope it's not already 
 taken:
 SJOCSOCPSAYBNVFTSMFOWHYSADALYAHTMLC, which you probably already guessed
 stands for Strict Java or C Style Object Conforming Programming Syntax and
 You Better Not Veer From This Sh*t Mother Fu*er or We'll Hunt Your Stupid
 As$ Down and Label You a Hyper Text Markup Language Coder. Not only would
 replacing the term Oriented with Conforming clear up a lot of 
 confusion for
 people, but that acronym would just look so sweet on a resume.

 :)

 Adam.


 -Original Message-
 From: Schuster, Steven [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, January 07, 2004 9:44 AM
 To: CF-Talk
 Subject: RE: Cold Fusion Web Developer/Programmer Position - Kansas City A
 rea

 Just curious, OOP doesn't really apply to CF so why the OOP stuff?

 I have read all the crud where people say CFC's are like OOP but it just
 isn't true. Now OOP concepts may have been a better choice of words 
 because
 that would imply the ability to understand the reasons why but not
 necessarily the implementation of such concepts.

 I suppose people could say that CFC's make you think about reuse but to be
 honest when I programmed in C (well before C++ caught on) I was using code
 reuse and nobody called it OOP. I had libraries built for all kinds of off
 the wall crud.

 But what do I knownot meant to diss the post just a thought I had as I
 glanced over it.

 Stephen E. Schuster
 PeopleSoft Administrator
 2000 Ashland Drive
 Ashland, KY 41101

 Office Phone 606.920.7447
 Cell Phone 606.831.4590

_

 From: Justin Hansen [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, January 07, 2004 10:18 AM
 To: CF-Talk
 Subject: Cold Fusion Web Developer/Programmer Position - Kansas City Area

 Cold Fusion Web Developer/Programmer Position - Kansas City Area

 Uhlig Communications, Inc., is an advanced-technology publishing company
 specializing in variable-data printing.

 We are offering an outstanding career opportunity for a Web
 Developer/Programmer with exceptional Programming and Application
 Development experience. As a Developer, you will take part in the design,
 programming, testing and implementation of highly innovative, new 
 publishing
 concepts.

 Qualified individuals will have 3+ years experience developing 
 ColdFusionMX
 applications. Necessary skills include: CFCs, SQL 2k, XML  OOP. 
 Additional
 knowledge of FlashMX, FireworksMX, design skills a plus

RE: Cold Fusion Web Developer/Programmer Position - Kansas City A rea

2004-01-07 Thread Schuster, Steven
Then I want to be the 

 
Services broker of data between disparate systems using intuitive
interfaces



Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

_

From: Ubqtous [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, January 07, 2004 3:51 PM
To: CF-Talk
Subject: Re: Cold Fusion Web Developer/Programmer Position - Kansas City A
rea

 
Matt,

On 1/7/2004 at 15:40, you wrote:

ML Shouldn't that be glorified administrative assistant? ;)

Sorry to butt in, but I had to mention that on a recent flight the
stewardess referred to herself as an in-flight service coordinator.
Classic.

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




RE: CF MX 6.1 and com objects

2004-01-06 Thread Schuster, Steven
You probably do indeed have it working but not natively. .NET is the
replacement for COM. COM has a different internal architecture from .NET and
thus they are not compatibility natively. That is why you have to use the
RCW which translates specific calls from managed clients into COM specific
invocation requests on unmanaged COM components. Basically this makes the
.NET components think they are talking to another .NET component.

 
This is how it is implemented:
Create a RCW out of the COM component
Ref. the metadata assembly Dl lint he project and use its
methods and properties

 
You can do the RCW step using the Type Library Importer utility or the
VS.Net IDE. 

 
Ex.) This generates metadata assembly with the name IopExampleRCW.dll out of
the COM IopExamlple.dll
Command line: tlbimp IopExample.dll /output:IopExampleRCW.dll /verbose 

 
In VS.NET IDE you would go to Project -Add Reference-COM tab...

 
All of this is based on the fact that you have already registered the
original COM component as well. Unless you register the original COM
component none of this will work at all. This will work in all .Net
invocations from C#, VB.NET and ASP.NET (et al.)

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 7:49 PM
To: CF-Talk
Subject: RE: CF MX 6.1 and com objects

 
.Net does support com, I have it working here now. Secondly I am creating
code that can be used by Windows Applications as well as ASP applications
and coldfusion applications that will share common business logic.
Blacknight does not support what I am trying to achive, so I am correct when
I say I am not looking for a wrapper solution.

Further discovery shows that I need to setup a DLLRegistrerServer or
something.

Regards
Andrew Scott
Technical Consultant

NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: 03 9686 0485-Fax: 03 9699 7976
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF MX 6.1 and com objects

2004-01-06 Thread Schuster, Steven
compatibility natively - That was a good one

 
Compatible natively - Damn MS spell checker

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 06, 2004 8:53 AM
To: CF-Talk
Subject: RE: CF MX 6.1 and com objects

 
You probably do indeed have it working but not natively. .NET is the
replacement for COM. COM has a different internal architecture from .NET and
thus they are not compatibility natively. That is why you have to use the
RCW which translates specific calls from managed clients into COM specific
invocation requests on unmanaged COM components. Basically this makes the
.NET components think they are talking to another .NET component.

This is how it is implemented:
Create a RCW out of the COM component
Ref. the metadata assembly Dl lint he project and use its
methods and properties

You can do the RCW step using the Type Library Importer utility or the
VS.Net IDE. 

Ex.) This generates metadata assembly with the name IopExampleRCW.dll out of
the COM IopExamlple.dll
Command line: tlbimp IopExample.dll /output:IopExampleRCW.dll /verbose 

In VS.NET IDE you would go to Project -Add Reference-COM tab...

All of this is based on the fact that you have already registered the
original COM component as well. Unless you register the original COM
component none of this will work at all. This will work in all .Net
invocations from C#, VB.NET and ASP.NET (et al.)

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 7:49 PM
To: CF-Talk
Subject: RE: CF MX 6.1 and com objects

.Net does support com, I have it working here now. Secondly I am creating
code that can be used by Windows Applications as well as ASP applications
and coldfusion applications that will share common business logic.
Blacknight does not support what I am trying to achive, so I am correct when
I say I am not looking for a wrapper solution.

Further discovery shows that I need to setup a DLLRegistrerServer or
something.

Regards
Andrew Scott
Technical Consultant

NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne, Victoria, 3205

Phone: 03 9686 0485-Fax: 03 9699 7976
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT-SQL Data file issue

2004-01-05 Thread Schuster, Steven
I can't remember the name of it but there is a SP you can run to fix this.

 
Check your SQL Books online, it is there.

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:06 AM
To: CF-Talk
Subject: OT-SQL Data file issue

 
Ok I made a big mistake. I had a database set to FULL thinking it was set to
SIMPLE and forgot to set up a job to truncate the transaction log. Needless
to say, the transaction log grew huge (14g) and sucked up all my memory. So
I took the database offline and deleted the file and replaced it with a new
empty one. Well that made my database suspect. How can I fix this?
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT-SQL Data file issue

2004-01-05 Thread Schuster, Steven
Ok, first try this::

 
sp_resetstatus

 
If that does not work you might try the following::

 
1. Turn off the SQL Server,
2. Copy the data file to a secure location on the drive
3. Turn on the SQL Server
4. Create a new database, call it foo or something
5. Turn off the database
6. Look in the /Data/ directory (or wherever you place your DB's). You
should see the FOO Data and Log files. Overwrite your backup data file you
moved earlier in Step 2 and replace it exactly with the Data name of Foo. 
7. Turn on the database, and try to access FOO. That should work

 
That should work, at least it has for me in the past

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

 
Unfortunately the last back up I had was from 11/28. This all happened
yesterday. And yes the .ldf file was deleted.

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

you deleted the ldb file?

uhhh, hmm, do you have a backup?

tw 

-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:06 AM
To: CF-Talk
Subject: OT-SQL Data file issue

Ok I made a big mistake. I had a database set to FULL thinking it was set to
SIMPLE and forgot to set up a job to truncate the transaction log. Needless
to say, the transaction log grew huge (14g) and sucked up all my memory. So
I took the database offline and deleted the file and replaced it with a new
empty one. Well that made my database suspect. How can I fix this? 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT-SQL Data file issue

2004-01-05 Thread Schuster, Steven
Just to verify...

 
You had two files in your originals DATA directory, lets assume the path is
E:\Program Files\Microsoft SQL Server\MSSQL\Data

 
Ok, your two original files were 

 
Sample_DATA.MDF
Sample_LOG.LDF

 
You then deleted the LDF file on accident.

 
Ok, so then you created a new Database, let's call it Foo.

 
You then stop the sql server. You now have 2 new files:

 
Foo_DATA.MDF
Foo_LOG.LDF

 
You then deleted Foo_DATA.MDF and took Sample_DATA.MDF and renamed it to
Foo_DATA.MDF.

 
Then when you restarted the Db it gave you an error?

 
That is really freaky, let me double check my instructions but that is
exactly how I do it here. I may have missed a step though.





-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:30 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

 
I did that and got an error message telling me that the database names were
different. think it was error 5173

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:19 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

Ok, first try this::

sp_resetstatus

If that does not work you might try the following::

1. Turn off the SQL Server,
2. Copy the data file to a secure location on the drive
3. Turn on the SQL Server
4. Create a new database, call it foo or something
5. Turn off the database
6. Look in the /Data/ directory (or wherever you place your DB's). You
should see the FOO Data and Log files. Overwrite your backup data file you
moved earlier in Step 2 and replace it exactly with the Data name of Foo. 
7. Turn on the database, and try to access FOO. That should work

That should work, at least it has for me in the past

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

Unfortunately the last back up I had was from 11/28. This all happened
yesterday. And yes the .ldf file was deleted.

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

you deleted the ldb file?

uhhh, hmm, do you have a backup?

tw 

-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:06 AM
To: CF-Talk
Subject: OT-SQL Data file issue

Ok I made a big mistake. I had a database set to FULL thinking it was set to
SIMPLE and forgot to set up a job to truncate the transaction log. Needless
to say, the transaction log grew huge (14g) and sucked up all my memory. So
I took the database offline and deleted the file and replaced it with a new
empty one. Well that made my database suspect. How can I fix this? 
_
_ 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT-SQL Data file issue

2004-01-05 Thread Schuster, Steven
Don't use the same name and try again.

 
The suspect status may be tied to simply the db entry itself. Also, did you
try sp_statusreset as well?





-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:47 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

 
Pretty close.

I took SQL down.
Copied the mdf file called abc_data.mdf to another directory.
Brought SQL up.
Dropped the database ABC.
Created a new databse called ABC.
I took SQL down.
Copied the old abc_data.mdf from another directory and pasted it over the
new abc_data.mdf.
Brought SQL up.
Open Enterprise manager.
ABC database was suspect.

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:42 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

Just to verify...

You had two files in your originals DATA directory, lets assume the path is
E:\Program Files\Microsoft SQL Server\MSSQL\Data

Ok, your two original files were 

Sample_DATA.MDF
Sample_LOG.LDF

You then deleted the LDF file on accident.

Ok, so then you created a new Database, let's call it Foo.

You then stop the sql server. You now have 2 new files:

Foo_DATA.MDF
Foo_LOG.LDF

You then deleted Foo_DATA.MDF and took Sample_DATA.MDF and renamed it to
Foo_DATA.MDF.

Then when you restarted the Db it gave you an error?

That is really freaky, let me double check my instructions but that is
exactly how I do it here. I may have missed a step though.

-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:30 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

I did that and got an error message telling me that the database names were
different. think it was error 5173

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:19 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

Ok, first try this::

sp_resetstatus

If that does not work you might try the following::

1. Turn off the SQL Server,
2. Copy the data file to a secure location on the drive
3. Turn on the SQL Server
4. Create a new database, call it foo or something
5. Turn off the database
6. Look in the /Data/ directory (or wherever you place your DB's). You
should see the FOO Data and Log files. Overwrite your backup data file you
moved earlier in Step 2 and replace it exactly with the Data name of Foo. 
7. Turn on the database, and try to access FOO. That should work

That should work, at least it has for me in the past

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

Unfortunately the last back up I had was from 11/28. This all happened
yesterday. And yes the .ldf file was deleted.

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue

you deleted the ldb file?

uhhh, hmm, do you have a backup?

tw 

-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 10:06 AM
To: CF-Talk
Subject: OT-SQL Data file issue

Ok I made a big mistake. I had a database set to FULL thinking it was set to
SIMPLE and forgot to set up a job to truncate the transaction log. Needless
to say, the transaction log grew huge (14g) and sucked up all my memory. So
I took the database offline and deleted the file and replaced it with a new
empty one. Well that made my database suspect. How can I fix this? 
_
_ 
_
_ 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Schuster, Steven
You may want to create a Sp if in SQL or a Package in Oracle to do this.
That way if no rows are returned by the default date you can do the previous
month in code rather than making CF do it with loops and all that jaz. Just
saves the processing baby!!!

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 1:21 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries

 
SELECT *
FROM table
WHERE DateCol = (SELECT MAX(DateCol) FROM Table)

HTH

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

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:10 AM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries

What I want to do is something like below.

select *
from table
where month(postdatetime)=max(month(postdatetime)) and
year(postdatetime)=max(year(postdatetime))

I want the current months entries. But if there is no entries I want it
to display the previous months entries. I only want it to display 1
months worth of entries.

-Original Message-
From: MILAN MUSHRAN [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 1:06 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries

If you are trying to get the highest date value in the database -
use this query:

SELECT max(DateColumnName)
FROM TableName

But, If you are trying to get the highest date value in the database for

every year -
use this query:

SELECT max(DateColumnName)
FROM TableName
GROUP BY DatePart('',DateColumnName) 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Schuster, Steven
MAX of a date field to ignore time, why would you want it to do this?

 
That would be tricky, I guess you could trunc the date field or something,
or use the format command.

 
But wouldn't you want the time piece in the comparison since 10/12/2004 at 3
PM is before 10/12/2004 at 5 PM? Excuse the stupid question just trying to
understand...

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 1:27 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries

 
Thanks Ian, but how do I get it to ignore the time portion?

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 1:21 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries

SELECT *
FROM table
WHERE DateCol = (SELECT MAX(DateCol) FROM Table)
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SQL: Selecting Max Date Entries

2004-01-05 Thread Schuster, Steven
Now that makes more senseI thought you were trying to do same Date - 1
month thing based on an earlier post. My bad.

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 1:36 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries

 
It makes sense because I want all entries in the month no matter the
time. If there where no entries for a month I don't want the site to
display no entries, I want it to display the entries for last month
that has entries. That way there will always be entries shown.

The below works.
SELECT*
FROMtbl_entries
WHERE(MONTH(postDateTime) =
(SELECTmonth(MAX(postdatetime))
 FROM tbl_entries)) AND
(YEAR(postDateTime) =
(SELECTyear(MAX(postdatetime))
 FROM tbl_entries))

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 05, 2004 1:34 PM
To: CF-Talk
Subject: RE: SQL: Selecting Max Date Entries

MAX of a date field to ignore time, why would you want it to do this?

That would be tricky, I guess you could trunc the date field or
something,
or use the format command.

But wouldn't you want the time piece in the comparison since 10/12/2004
at 3
PM is before 10/12/2004 at 5 PM? Excuse the stupid question just trying
to
understand...
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT- making a windows based app

2004-01-02 Thread Schuster, Steven
.NET can do this as well. Just write it in VB or C# and deliver it either
way. You have to put some thought into the design but that's exactly what
.Net is for.

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 02, 2004 12:22 PM
To: CF-Talk
Subject: Re: OT- making a windows based app

 
It can be done via Flash. I did a bunch of research into building an app
with different data requirements, but the same kind of functionality as you
have described (work offline from local db etc.).The bonus that you can
sell to your client is that the app could periodically (or based on a user
action or detection of an internet connection) check for updates with a
central online db so that all apps can get updated data with ease and then
work off that data when offline.

You may of course want to look at MM Central as it should allow you to do
this kind of stuff as well.

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: mayo 
To: CF-Talk 
Sent: Friday, January 02, 2004 8:53 AM
Subject: OT- making a windows based app

A client would like for me to build a windows based app for him. 
I have suggested that he keep it web-based but he insists that it 
be available on unconnected desktops. He's even thinking about 
selling it to customers.

The application is a catalogue of items. Selecting an item
will display information regarding that item. It does get fairly
involved but that is the essence of project.

-- This should be a stand alone app, ie: neither IIS nor apache 
should have to be installed on the computer; and for security reasons 
the db should not be in an easily accessable file where employees 
could just download it.

-- The app will need to tie into a database. Access would do, about
20-30 tables, under 500,000 records. Users will not update the
database.

-- It would be loaded into a variety of stand-alone desktops. 

-- It would have to be secure. Employees, and customers, should not be 
able to readily download the data. 

Does anybody have any idea. I'm wondering if VB is the way to go. 

It may be beyond me but I would like to give it a shot.

thanks for any input,

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




RE: Create table ID field

2004-01-02 Thread Schuster, Steven
If I am not mistaken UUID is a big string of mess. Now granted a PK as a
char or int may not inherently be much to fuss over when the chat gets large
it does become a very big issue. I can't see how a large char could ever
compete against a small int. At the bit level you can not say that

 
102031

 
is the same as parsing

 
122434TREgh-e-rfwer43 

 
so and an so on.

 
Regardless, comparing int to varchar is measured at the ms level so I
wouldn't worry about it too much...

 
Steve



 http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 02, 2004 3:19 PM
To: CF-Talk
Subject: Re: Create table ID field

 
This brings up an interesting question I've had for a while: I've seen a few
(but only a few!) developers use CreateUUID() for creating a record's PKID,
and therefore have the PKIDs be strings rather than integers. (their
argument was that they didn't have to worry about another record being
inserted in between when the CreateUUID() was called and when the first
record was actually inserted into the DB)I questioned them about the
impact this has on their joins and a few said they never saw a real decrease
in performance (I don't have any proof, but I inherently distrust that
statement!) and a few others say that they used that only for creating a
unique ID, but that they had a separate ID field in each table that was
numeric which they used for joins.This part seemed like overkill to me -
surely there's some stored procedure that accomplishes all of this?

Can someone who actually thinks about this stuff regularly (uh, that means
you, Dave Watts!) explain whether there's any merit to either group of
people above? I thought the whole point of autonumber fields was exactly
to make this issue moot.
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX on Win2K3 Web Edition?

2003-12-30 Thread Schuster, Steven
I forgot to ask, is this MX 6 or 6.1. 6 does have issues with IIS in 2003
because of the J2EE hooks. 

 
Steve

http://intranet 

Stephen E. Schuster
PeopleSoft Administrator
2000 Ashland Drive
Ashland, KY 41101

Office Phone 606.920.7447
Cell Phone 606.831.4590

 
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 30, 2003 2:42 PM
To: CF-Talk
Subject: RE: CFMX on Win2K3 Web Edition?

 
 Are there any known issues for installing CFMX on Windows 
 2003 Web Edition? Because we're having problems...first the 
 CF service started fine, but would not execute CF pages, 
 now the service won't even start. Any help would be greatly, 
 superly, duperly, stupendously, immeasurably appreciated-

In general, no, there aren't any problems specific to CFMX on W2K3 of which
I'm aware. I've worked with several deployments now on that platform with no
problems.

However, you can often determine the cause of a CFMX problem by trying to
start CFMX from the command line as an application. If you're running the
regular, standalone version of CFMX as opposed to a J2EE server version,
look somewhere within your CFusionMX directory for a batch file called
something like startup.bat or cfstart.bat.

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




Scheduled Task question?

2003-12-23 Thread Schuster, Steven
In MX 6.1 does a scheduled task have to exist in the CF Administrator for it
to work. I was able to add them to the registry in 5 so they would not
appear in the CF Administrator and get hosed up by developers poking around.

 
Any ideas? I was thinking it was just an XML entry in 6.1 but was not sure
where it was stored?

 
Steve

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 22, 2003 9:24 AM
To: CF-Talk
Subject: RE: Date Errors in MX ?

 
Jochem

I have just changed the query to what is below and received the
following error

Error Occurred While Processing Request 

Error Executing Database Query. 

[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character 

The error occurred in
F:\Websites\Intranet\itintranet\publishing\articleaction.cfm: line 54

52 : cfqueryparam cfsqltype=cf_sql_varchar value=#security#,
53 : cfif
isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif,
54 :cfqueryparam cfsqltype=cf_sql_blob value=#content#;
55 : /cfquery
56 : 

cftransaction

cfquery name=LOOKUP datasource=intranetv8
SELECT Max(id) NewID
FROM itarticle
/cfquery

cfif lookup.newid is 
cfset id = 1
cfelse
cfset id = lookup.newid + 1
/cfif

!--- Insert contact into the contacts tabel in the tes8 Database ---

cfset articledate = form.event_month  /  form.event_day  / 
form.event_year 
cfset articledate = #CreateODBCDate(articledate)#
cfset formatted_date = dateformat(articledate, MM/DD/) 

cfset content = REReplacenocase(content, /*font[^]*, , ALL) 
cfset content = REReplacenocase(content, /*span[^]*, , ALL) 

cfif form.uploadfile neq  

cffile action="" filefield=Form.UploadFile
destination=F:\Websites\Intranet\itintranet\itnews\images\
nameconflict=OVERWRITE
/cfif
!--- Make sure that file is of correct type ---

!--- Insert the story record ---

cfquery datasource=#Application.DSN# name=insert_query
INSERT INTO itarticle (id, articledate, articletitle, articlesummary,
articleauthor, security, imgsrc, articlebody) 
VALUES (
 cfqueryparam cfsqltype=cf_sql_date value=#articledate#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#articletitle#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#articlesummary#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#Session.Fname#
#Session.Lname#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#security#,
 cfif
isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif,
 cfqueryparam cfsqltype=cf_sql_blob value=#content#
/cfquery

/cftransaction

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: 22 December 2003 12:08
To: CF-Talk
Subject: RE: Date Errors in MX ?

Ian Vaughan said:

 cftransaction

It would be better to use a sequence for primary key generation.
If
you also use cfqueryparam your 3 query transaction reduces to 1
query.

cfset storydate =
CreateDate(form.event_year,form.event_month,form.event_day

cfset content =
REReplacenocase(content,/*(font|span)[^]*,,ALL)

cfquery datasource=#Application.DSN# name=insert_query
INSERT INTO itarticle (
 articledate,
 articletitle,
 etc.
 itarticle
 )
VALUES (
 cfqueryparam cfsqltype=cf_sql_date value=#storydate#,
 cfqueryparam cfsqltype=cf_sql_varchar
value=#articletitle#,
 etc.
 cfqueryparam cfsqltype=cf_sql_clob value=#content#
/cfquery

Jochem 

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




RE: Scheduled Task question?

2003-12-23 Thread Schuster, Steven
I tried the following:

 
Created the cron job in the cfide. Then I went to the CFusionMX/lib
directory and looked at the neo-cron.xml file.

 
Sure enough my entry was there.

 
So I copied the entry in the neo-cron.xml, went back to the cfide and
deleted the manual entry I made in the Scheduled Tasks setting. Sure enough
it cleared out the neo-cron file. 

 
So I then pasted the earlier copied (old version with the entry) contents
into neo-cron.xml. Just like it was when I created the entry through the
cfide.

 
Ok, all seemed well, the entry was gone in the CFIDE like I wantedbut
when I went to refresh the CFIDE screen where the scheduled tasks appear it
must do a manual sweep of the xml directories because it kept cleaning out
the file contents in neo-cron.xml...any thoughts

 
Steve

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 23, 2003 9:21 AM
To: CF-Talk
Subject: Scheduled Task question?

 
In MX 6.1 does a scheduled task have to exist in the CF Administrator for it
to work. I was able to add them to the registry in 5 so they would not
appear in the CF Administrator and get hosed up by developers poking around.

Any ideas? I was thinking it was just an XML entry in 6.1 but was not sure
where it was stored?

Steve

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 22, 2003 9:24 AM
To: CF-Talk
Subject: RE: Date Errors in MX ?

Jochem

I have just changed the query to what is below and received the
following error

Error Occurred While Processing Request 

Error Executing Database Query. 

[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character 

The error occurred in
F:\Websites\Intranet\itintranet\publishing\articleaction.cfm: line 54

52 : cfqueryparam cfsqltype=cf_sql_varchar value=#security#,
53 : cfif
isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif,
54 :cfqueryparam cfsqltype=cf_sql_blob value=#content#;
55 : /cfquery
56 : 

cftransaction

cfquery name=LOOKUP datasource=intranetv8
SELECT Max(id) NewID
FROM itarticle
/cfquery

cfif lookup.newid is 
cfset id = 1
cfelse
cfset id = lookup.newid + 1
/cfif

!--- Insert contact into the contacts tabel in the tes8 Database ---

cfset articledate = form.event_month  /  form.event_day  / 
form.event_year 
cfset articledate = #CreateODBCDate(articledate)#
cfset formatted_date = dateformat(articledate, MM/DD/) 

cfset content = REReplacenocase(content, /*font[^]*, , ALL) 
cfset content = REReplacenocase(content, /*span[^]*, , ALL) 

cfif form.uploadfile neq  

cffile action="" filefield=Form.UploadFile
destination=F:\Websites\Intranet\itintranet\itnews\images\
nameconflict=OVERWRITE
/cfif
!--- Make sure that file is of correct type ---

!--- Insert the story record ---

cfquery datasource=#Application.DSN# name=insert_query
INSERT INTO itarticle (id, articledate, articletitle, articlesummary,
articleauthor, security, imgsrc, articlebody) 
VALUES (
 cfqueryparam cfsqltype=cf_sql_date value=#articledate#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#articletitle#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#articlesummary#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#Session.Fname#
#Session.Lname#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#security#,
 cfif
isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif,
 cfqueryparam cfsqltype=cf_sql_blob value=#content#
/cfquery

/cftransaction

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: 22 December 2003 12:08
To: CF-Talk
Subject: RE: Date Errors in MX ?

Ian Vaughan said:

 cftransaction

It would be better to use a sequence for primary key generation.
If
you also use cfqueryparam your 3 query transaction reduces to 1
query.

cfset storydate =
CreateDate(form.event_year,form.event_month,form.event_day

cfset content =
REReplacenocase(content,/*(font|span)[^]*,,ALL)

cfquery datasource=#Application.DSN# name=insert_query
INSERT INTO itarticle (
 articledate,
 articletitle,
 etc.
 itarticle
 )
VALUES (
 cfqueryparam cfsqltype=cf_sql_date value=#storydate#,
 cfqueryparam cfsqltype=cf_sql_varchar
value=#articletitle#,
 etc.
 cfqueryparam cfsqltype=cf_sql_clob value=#content#
/cfquery

Jochem 

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




RE: Date Errors in MX ?

2003-12-22 Thread Schuster, Steven
The date format is wrong...Oracle is specific on how dates are inserted,
don't use create ODBC Date just pass in something like 10-OCT-2003 or
something similar depending on how dates are set up on the oracle side.

 
Also, put a sequence on that table man, don't use those MAX commands, here
is an example of a sequence::

 
First, put a trigger on the table like this code below::

 
declare 
pkvaluenumber; 
BEGIN 
select SEQUENCE NAME_seq.nextval into pkvalue from dual; 
:new.FIELD NAME FOR TABLE THAT NEEDS SEQUENCE := pkvalue; 
END;

 
CREATE SEQUENCE SEQUENCE NAME_seq
INCREMENT BY 1
START WITH STAR_NUMBER
MINVALUE 1
MAXVALUE 999
NOCYCLE
NOORDER
CACHE 20

 
Just replace everything inside the 's with your sequence name and the
field/table to create the sequence on.

 
Steve
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 22, 2003 9:24 AM
To: CF-Talk
Subject: RE: Date Errors in MX ?

 
Jochem

I have just changed the query to what is below and received the
following error

Error Occurred While Processing Request 

Error Executing Database Query. 

[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character 

The error occurred in
F:\Websites\Intranet\itintranet\publishing\articleaction.cfm: line 54

52 : cfqueryparam cfsqltype=cf_sql_varchar value=#security#,
53 : cfif
isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif,
54 :cfqueryparam cfsqltype=cf_sql_blob value=#content#;
55 : /cfquery
56 : 

cftransaction

cfquery name=LOOKUP datasource=intranetv8
SELECT Max(id) NewID
FROM itarticle
/cfquery

cfif lookup.newid is 
cfset id = 1
cfelse
cfset id = lookup.newid + 1
/cfif

!--- Insert contact into the contacts tabel in the tes8 Database ---

cfset articledate = form.event_month  /  form.event_day  / 
form.event_year 
cfset articledate = #CreateODBCDate(articledate)#
cfset formatted_date = dateformat(articledate, MM/DD/) 

cfset content = REReplacenocase(content, /*font[^]*, , ALL) 
cfset content = REReplacenocase(content, /*span[^]*, , ALL) 

cfif form.uploadfile neq  

cffile action="" filefield=Form.UploadFile
destination=F:\Websites\Intranet\itintranet\itnews\images\
nameconflict=OVERWRITE
/cfif
!--- Make sure that file is of correct type ---

!--- Insert the story record ---

cfquery datasource=#Application.DSN# name=insert_query
INSERT INTO itarticle (id, articledate, articletitle, articlesummary,
articleauthor, security, imgsrc, articlebody) 
VALUES (
 cfqueryparam cfsqltype=cf_sql_date value=#articledate#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#articletitle#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#articlesummary#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#Session.Fname#
#Session.Lname#,
 cfqueryparam cfsqltype=cf_sql_varchar value=#security#,
 cfif
isdefined(file.serverFile)'#file.serverFile#'cfelseNULL/cfif,
 cfqueryparam cfsqltype=cf_sql_blob value=#content#
/cfquery

/cftransaction

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: 22 December 2003 12:08
To: CF-Talk
Subject: RE: Date Errors in MX ?

Ian Vaughan said:

 cftransaction

It would be better to use a sequence for primary key generation.
If
you also use cfqueryparam your 3 query transaction reduces to 1
query.

cfset storydate =
CreateDate(form.event_year,form.event_month,form.event_day

cfset content =
REReplacenocase(content,/*(font|span)[^]*,,ALL)

cfquery datasource=#Application.DSN# name=insert_query
INSERT INTO itarticle (
 articledate,
 articletitle,
 etc.
 itarticle
 )
VALUES (
 cfqueryparam cfsqltype=cf_sql_date value=#storydate#,
 cfqueryparam cfsqltype=cf_sql_varchar
value=#articletitle#,
 etc.
 cfqueryparam cfsqltype=cf_sql_clob value=#content#
/cfquery

Jochem 

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




RE: Joining the dark side - using DWMX

2003-12-19 Thread Schuster, Steven
It will never beat Cold Fusion Studio 5...never I say!

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 19, 2003 9:45 AM
To: CF-Talk
Subject: Joining the dark side - using DWMX

 
Well, I decided to try out DWMX for some coding yesterday...

And it was good.I actually liked it.

The color coding was nicer than Homesite+.The browser check was nice.The
css integration was great.I even enjoyed the split code/design view.

I may never turn back :)
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Joining the dark side - using DWMX

2003-12-19 Thread Schuster, Steven
Fundamental difference between programmers and web developers...

 
I have noticed that programmer like Studio much better than Dreamweaver
whereas web site designers like dreamweaver.

 
They may both program in CF but the difference to me is that one is written
with a coder in mind and the other was written with a designer in mind.

 
I cam from a programming background, I mean hardcore as in C++ with VI or
Emacs...so to me CF 5 is much better...


-Original Message-
From: Daniel Farmer [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 19, 2003 12:38 PM
To: CF-Talk
Subject: Re: Joining the dark side - using DWMX

 
ALLAIRE RULES
- Original Message - 
From: Dave Watts 
To: CF-Talk 
Sent: Friday, December 19, 2003 12:43 PM
Subject: RE: Joining the dark side - using DWMX

 CFS5 Kicks DWMX ass anytime. It is faster and more stable. I 
 don't care what hardware you are on - the bottom line is that 
 CFS5 is faster than DWMX on any hardware.

We're talking about a text editor, not a compiler. How fast does it have
to
be? On my laptop (which is hardly a blazing machine) Dreamweaver MX 2004
runs well enough that it doesn't slow me down any.

In exchange, it gives me a usable design view, templates, an incredibly
powerful search and replace interface, and all sorts of other stuff I find
very helpful.

There are plenty of things I don't like about Dreamweaver, but they're
outweighed by the good things in my opinion. For that matter, there were
plenty of things I didn't like about CF Studio - it's not like that was
God's gift to text editing, either.

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




RE: Hiring: CF Developer

2003-12-18 Thread Schuster, Steven
Do they pay more than 85K a year?

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 18, 2003 11:59 AM
To: CF-Talk
Subject: Hiring: CF Developer

 
[Sorry if this is against the rules, I saw no precedent.]

My company is looking to fill a position, here's what they're posting
on the job sites. They also ask that resumes be sent to:
Email: hr atSign calib dotCharacter com

Cold Fusion Developer 

Caliber Associates, Inc. is a dynamic, employee-owned consulting firm
specializing in the social and behavioral sciences.Caliber's 300
staff continue to share the firm's founding philosophy of building
success through dedication to intellectual excellence, scientific
rigor and professional integrity.We are growing and seek a Cold
Fusion Developer.

The Cold Fusion Developer will be responsible for full life-cycle
web-based application development, management, and maintenance of
database driven web applications, for high profile Federal government
and commercial clients, online learning communities and dynamic web
sites.

Bachelor's Degree in Computer Science and 3-5 years of work experience
performing web application development required.Strong web
development skills and demonstrated proficiency in ColdFusion 5/MX,
Java, _javascript_, MS SQL Server 7/2000 and/or Oracle 8i technologies
required.Fusebox, Flash, and XML experience preferred.Excellent
written and verbal communication skills and ability to work on
multiple projects essential.Caliber offers a supportive work
environment, competitive salary and excellent benefits.If
interested, please forward a cover letter with salary requirements and
resume to: 

Caliber Associates, Inc.
Attn: HR- ColdFusion Developer
10530 Rosehaven Street, Suite 400
Fairfax, VA 22030
Email: itjobs atSign calib dotCharacter com
Fax: 703-218-6930
Website: www.calib.com
Caliber Associates, the measure of excellence.
EOE
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: IIS remove and reinstall

2003-12-18 Thread Schuster, Steven
Make sure your entrance pages for .cfm are listed in IIS. They probably are
not

-Original Message-
From: mayo [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 18, 2003 1:13 PM
To: CF-Talk
Subject: RE: IIS remove and reinstall

 
I removed and reinstalled IIS. My asp pages work fine. CF doesn't work, I
can't get to the CFIDE/administrator pages but

Cold Fusion has started.

The CFMX logs are below

\CFusionMX\logs

Information,main,12/18/03,08:52:49,,Starting license...
Information,main,12/18/03,08:52:49,,Starting License server ...
Information,main,12/18/03,08:52:49,,Starting scheduler...
Information,main,12/18/03,08:52:50,,Starting debugging...
Information,main,12/18/03,08:52:50,,Starting sql...
Information,main,12/18/03,08:52:50,,Starting mail...
Information,main,12/18/03,08:52:50,,Starting verity...
Information,main,12/18/03,08:52:51,,CORBA Configuration not
enabled
Information,main,12/18/03,08:52:51,,Starting cron...
Information,main,12/18/03,08:52:51,,Starting registry...
Information,main,12/18/03,08:52:52,,Starting client...
Information,main,12/18/03,08:52:52,,Starting xmlrpc...
Information,main,12/18/03,08:52:52,,Starting graphing...
Information,main,12/18/03,08:52:52,,Starting archive...
Information,main,12/18/03,08:52:52,,ColdFusion started

I tried to remove CFMX but am running into difficulty Files are being
shared by other apps that aren't on!?!

note to Dave,

I found the connectors but haven't removed them.

--glm

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 9:56 AM
To: CF-Talk
Subject: RE: IIS remove and reinstall

 The result is: 'cfusionmx\runtime\jre\bin\java-jar' is not
 recognized as an internal or external command, operable program
 or batch file.

That should be java -jar, not java-jar.

But frankly, I wouldn't worry about what version of the wsconfig.jar file
you have. You didn't say whether you're using CFMX 6.0 or 6.1, but if
you're
using CFMX 6.1, you should be using the version of wsconfig.jar that came
with the product, I think - there haven't been any updates to that.

I would just uninstall the connector, see if IIS works then, and go from
there. There are some handy batch files to do this for you, if you're
running CFMX Enterprise or Standard - look in your
\cfusionmx\bin\connectors
directory for remove_all_connectors.bat, I think.

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




Help Desk Software...

2003-12-17 Thread Schuster, Steven
I know it's been done 100 times but I am going to do one open-source for the
CF folks with Oracle, SQL and maybe Access back-ends. What I am looking for
are suggestions as to what it should have in it. I have a basic framework
developed with a UI but it is all up in the air right now.

 
Here is why I am doing this...

 
1.)I want something that fits a large number of people
2.)I want something that is intuitive and easy to use
3.)Ant something that is free and that I can give to the community

 
So , what do you all think?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MS-SQL 2000 NULL Problem

2003-12-17 Thread Schuster, Steven
Is the field storing NULL or blanks space, there is a difference.

 
Steve

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 17, 2003 12:59 PM
To: CF-Talk
Subject: MS-SQL 2000 NULL Problem

 
How come a simple query like this still returns NULL for emails even though
my WHERE clause says to exclude them?What am I doing wrong?I've tried
both IS NOT NULL and .

SELECT L.email, L.firstname, L.lastname, L.directEmailTo
FROM #REQUEST.prefix#_Members_List L
WHERE L.email IS NOT NULL
ORDER BY L.email

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




RE: text editor for content manag. systems

2003-12-17 Thread Schuster, Steven
FCKEditor I think or is it FKEditor

 
It's free and awesome...

 
Steve

-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 17, 2003 1:03 PM
To: CF-Talk
Subject: text editor for content manag. systems

 
I'm looking for a good text editor for content management systems. Something

I can basically plug into an app. Are there any good free or cheap ones 
around?

__
Daniel Farmer
Producer / Coldfusion Developer
http://www.bernardclark.com/danfarmer.ca
http://www.bernardclark.com/danfarmer.ca 
P: 613.284.1684
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Weird Images issues...

2003-12-17 Thread Schuster, Steven
./ is just another way of saying /

 
My UNIX shows through every now and then, but that's not it. The problem is
I can see the images in thumbnail view and when viewing them on the server.
When I look at them through either the web site or directly in the
globalimages directory on a web browser I get nadda. No broken links just no
image.

 
Really really really weird.

-Original Message-
From: Roth, John [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 17, 2003 12:17 PM
To: CF-Talk
Subject: RE: Weird Images issues...

 
Steven,
1-When I go to the index.htm file
http://www.lcgis.com/STAGE/index.htm http://www.lcgis.com/STAGE/index.htm 
I _do not_ see the images.Methinks you need to clear your cache...

2-The source for that file lists all the image references as img
src="" width= height= alt= border=.I
don't think I've ever seen a path with ./ in the beginning.Could that be
the problem?

J.B. Roth
Web Developer

 -Original Message-
 From: CF-Talk [SMTP:[EMAIL PROTECTED]
 Subject: Weird Images issues...
 From: Schuster, Steven [EMAIL PROTECTED]
 Date: Tue, 16 Dec 2003 14:45:09 -0500
 Thread:
 http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=2
threadid=2
 9343forumid=4#147239
 
 Yeah, it is really freaky weird. Oh well, on to other things...I'll let
 you
 all know what it was when I fix it.

 Steve


 -Original Message-
 From: Turetsky, Seth [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, December 16, 2003 2:41 PM
 To: CF-Talk
 Subject: RE: Weird Images issues...

 What's weird is that you can view the source after clicking on an image,
 so
 it's an html page that is loading, not the image.something is up with
 your
 webserver, at least i think
 
 -Original Message-----
 From: Schuster, Steven [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, December 16, 2003 1:51 PM
 To: CF-Talk
 Subject: RE: Weird Images issues...
 
 Ok, would that explain why I can see them in the file browser or when
 viewing the page offline??? That's why this is kicking my butt, it just
 doesn't make any sense...
 
 -Original Message-
 From: Jeff Garza [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, December 16, 2003 1:43 PM
 To: CF-Talk
 Subject: Re: Weird Images issues...
 
 
 It appears that your files are damaged.I can't open them with Fireworks
 either.
 
 Cheers,
 
 Jeff
- Original Message ----- 
From: Schuster, Steven 
To: CF-Talk 
Sent: Tuesday, December 16, 2003 11:39 AM
Subject: Weird Images issues...
 
Ok, here is some weirdness for you...
 
http://www.lcgis.com/STAGE/GlobalImages
http://www.lcgis.com/STAGE/GlobalImages 
 http://www.lcgis.com/STAGE/GlobalImages 
 http://www.lcgis.com/STAGE/GlobalImages 
http://www.lcgis.com/STAGE/GlobalImages 
 
See the list of images, click one, does it show up...mine don't. No
 matter
what I do they do not appear in the browser. However if I view folder in
Thumbnail mode I can see them all. To boot if I go to the STAGE
 directory
and open up Index.htm as a File-Open in IE they show up as well. This
 seems
to be something with IIS and the folder.
 
I have set all permissions to full and made sure they were not read only
 or
something. I also checked in IIS and turned on browse to that folder so
 I
could see that they were indeed there
 
This is a Win 2K3 box running the latest and greatest IIS.
 
Any help, any ideas. I have never ever had this happen before
 
Thanks,
Steve
_
_
 

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




RE: Weird Images issues...

2003-12-17 Thread Schuster, Steven
Let me rephrase ./ and / in the context of this site are the root
directories of the web server which is why I said what I said. Regardless ./
works just fine so that is not the problem.

 
S

-Original Message-
From: Plunkett, Matt [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 17, 2003 1:27 PM
To: CF-Talk
Subject: RE: Weird Images issues...

 
./means the current directory. (I've never seen this in a web document
before either)
/ means the root directory of the webserver.

-Original Message-
From: Schuster, Steven
Sent: Wednesday, December 17, 2003 1:24 PM
To: CF-Talk
Subject: RE: Weird Images issues...

./ is just another way of saying /
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MS-SQL 2000 NULL Problem

2003-12-17 Thread Schuster, Steven
When you design a table you have a property called Allow Nulls, make sure
that it is checked. Then the default will be NULL and not   or something
else. Then as inserts occur you can be assured that NULL fields are actually
NULL and not equivelant nulls like   or Null typed into a varchar field.

 
I know it sounds odd, and it is, but that's the way NULLS are...

-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 17, 2003 1:39 PM
To: CF-Talk
Subject: Re: MS-SQL 2000 NULL Problem

 
Mark

 All the empty fields in the email db contain null

How exactly do you know the email field is null? It seems to me that if
WHERE L.email IS NOT NULL returns the rows, then that's the surest proof
that the field is not null.

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




Weird Images issues...

2003-12-16 Thread Schuster, Steven
Ok, here is some weirdness for you...

 
http://www.lcgis.com/STAGE/GlobalImages
http://www.lcgis.com/STAGE/GlobalImages 

 
See the list of images, click one, does it show up...mine don't. No matter
what I do they do not appear in the browser. However if I view folder in
Thumbnail mode I can see them all. To boot if I go to the STAGE directory
and open up Index.htm as a File-Open in IE they show up as well. This seems
to be something with IIS and the folder.

 
I have set all permissions to full and made sure they were not read only or
something. I also checked in IIS and turned on browse to that folder so I
could see that they were indeed there

 
This is a Win 2K3 box running the latest and greatest IIS.

 
Any help, any ideas. I have never ever had this happen before

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




RE: Weird Images issues...

2003-12-16 Thread Schuster, Steven
Ok, would that explain why I can see them in the file browser or when
viewing the page offline??? That's why this is kicking my butt, it just
doesn't make any sense...

-Original Message-
From: Jeff Garza [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 16, 2003 1:43 PM
To: CF-Talk
Subject: Re: Weird Images issues...

 
It appears that your files are damaged.I can't open them with Fireworks
either.

Cheers,

Jeff
- Original Message - 
From: Schuster, Steven 
To: CF-Talk 
Sent: Tuesday, December 16, 2003 11:39 AM
Subject: Weird Images issues...

Ok, here is some weirdness for you...

http://www.lcgis.com/STAGE/GlobalImages
http://www.lcgis.com/STAGE/GlobalImages 
http://www.lcgis.com/STAGE/GlobalImages 

See the list of images, click one, does it show up...mine don't. No matter
what I do they do not appear in the browser. However if I view folder in
Thumbnail mode I can see them all. To boot if I go to the STAGE directory
and open up Index.htm as a File-Open in IE they show up as well. This
seems
to be something with IIS and the folder.

I have set all permissions to full and made sure they were not read only
or
something. I also checked in IIS and turned on browse to that folder so I
could see that they were indeed there

This is a Win 2K3 box running the latest and greatest IIS.

Any help, any ideas. I have never ever had this happen before

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




RE: Weird Images issues...

2003-12-16 Thread Schuster, Steven
Yeah, it is really freaky weird. Oh well, on to other things...I'll let you
all know what it was when I fix it.

 
Steve

-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 16, 2003 2:41 PM
To: CF-Talk
Subject: RE: Weird Images issues...

 
What's weird is that you can view the source after clicking on an image, so
it's an html page that is loading, not the image.something is up with your
webserver, at least i think

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 1:51 PM
To: CF-Talk
Subject: RE: Weird Images issues...

Ok, would that explain why I can see them in the file browser or when
viewing the page offline??? That's why this is kicking my butt, it just
doesn't make any sense...

-Original Message-
From: Jeff Garza [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 16, 2003 1:43 PM
To: CF-Talk
Subject: Re: Weird Images issues...

It appears that your files are damaged.I can't open them with Fireworks
either.

Cheers,

Jeff
- Original Message - 
From: Schuster, Steven 
To: CF-Talk 
Sent: Tuesday, December 16, 2003 11:39 AM
Subject: Weird Images issues...

Ok, here is some weirdness for you...

http://www.lcgis.com/STAGE/GlobalImages
http://www.lcgis.com/STAGE/GlobalImages 
http://www.lcgis.com/STAGE/GlobalImages 
http://www.lcgis.com/STAGE/GlobalImages 

See the list of images, click one, does it show up...mine don't. No matter
what I do they do not appear in the browser. However if I view folder in
Thumbnail mode I can see them all. To boot if I go to the STAGE directory
and open up Index.htm as a File-Open in IE they show up as well. This
seems
to be something with IIS and the folder.

I have set all permissions to full and made sure they were not read only
or
something. I also checked in IIS and turned on browse to that folder so I
could see that they were indeed there

This is a Win 2K3 box running the latest and greatest IIS.

Any help, any ideas. I have never ever had this happen before

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




RE: Strange problem with Oracle/WordXP

2003-12-12 Thread Schuster, Steven
What are you pasting it into (Ektron, etc.)...Is this store in a BLOB, CLOB,
or a big fat VARCHAR.

 
Steve

-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 12, 2003 10:34 AM
To: CF-Talk
Subject: Strange problem with Oracle/WordXP

 
Hi,

I have two servers one runningCF 4.0 the other CF 5.0.

They are running identical applications and connectiing to the same database
server with the same NLS setting.

The problem is when I paste bulletted text copied from specifically Word XP
on the CF 5.0 application it changes the bullets to upside down question
marks. The problem does not occur on the CF 4.0 server.

Can this be an ODBC driver problem or a setting withing CF5?

Thanks!

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




RE: Refresh left frame

2003-12-09 Thread Schuster, Steven
top.frames['FRAMENAME'].location=PAGE'

 
or

 
top.frames['FRAMENAME'].reload() or refresh();

 
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 10:25 AM
To: CF-Talk
Subject: Refresh left frame

 
Hi

I have Login link on left frame which opens login screen on right frame.
On successfull login I want to refresh the left frame. But as I am at
right frame it just refreshes right one. Reason I want to do is that
some links in left are enabled only when appropriate user is logged in.
Without refreshing it doesn't show the links to authorised users.

Thanks

Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Query of a text file

2003-12-09 Thread Schuster, Steven
Well
First of all use this #cfhttp.filecontent# to see what is in the file.

 
If you need to loop through those contents you will have to do something
like this:

 
cfloop list=# cfhttp .fileContents# index=line
delimiters=#chr(10)##chr(13)#

 
This assumes this is a list separated and users vbcrlf for line ends. You
can play around with it if need be.

 
Inside the cfloop just output #line# to see the contents of the current row.

 
You could also assign values or store in a DB at that point as well..

Steve

-Original Message-
From: Jim T [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 10:55 AM
To: CF-Talk
Subject: Query of a text file

 
I am Stuck .. can someone help?

I am getting this error:

Attribute validation error for tag cfoutput.
The value of the attribute query, which is currently thefile, is
invalid.

this is the text filetop of the text file:
Code,page,title,unit,price
884,248,LIGHTED ROSE BASKET,1 EA,9.95
1402,194,3 PC BRASS BUTTERFLY WALL SET,1 SET,6.30
1506,91,BRASS/SHIPS CARGO LANTERN,1 EA,53.30
1875,175,10 PC PORC COBALT BLUE TEA SET,1 SET,3.65
1932,54,CHILDREN'S PLAQUE,1 EA,2.65
2018,303,100 BR/BELL WIND CHM,1 EA,2.95

This is the code:

!--- Get the file ---
cfhttp url="">
method=GET
Name=thefile
/cfhttp
!--- Output the file ---
cfoutput query=thefile
codeb#code#/b
/cfoutput
Are you paying more than $9.99 for internet? Then you are paying too much!
http://bizovation.speedydialup.net http://bizovation.speedydialup.net 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Query of a text file

2003-12-09 Thread Schuster, Steven
Ok, then that is a bit different. The following is based off the these
assumptions (hopefully I won't make an ass out of u and mption..oh I kill
me)...

 
Each line ends with a VBCRLF
Each row is comma delimited. 

 
** You may need to check the above two in your file and replace the correct
escape codes in the following example:

 
SAMPLE METHOD 1 ::
!--- This will loop through the entire file line by line ---
cfloop list=#cfhttp.fileContents# index=line
delimiters=#chr(10)##chr(13)#

 
!--- Once you are in the first row you need to then loop through the
columns ---
cfloop index = index_name List = #line# delimiters = ,

 
!--- Ok , at this point you now have row 1 in an indexed loop that you can
cycle through ---
!--- based on your sample data this will loop 5 times for each row, one for
each column ---
!--- you simply need to output the first and last instance of this loop and
you will get Code and Price ---

 
/cfloop
/cfloop

SAMPLE METHOD 2::

 
Another way would be the following::

 
cfset sLogpath = c:\ errorlog.txt
!--- init line counter ---
cfset countLines = 0
!--- init error counter ---
cfset countErrors = 0

 
cfloop list=#fileContents# index=line delimiters=#chr(10)##chr(13)#
 !--- trim spaces off beginning and end of line ---
 cfset line = trim(line)
 !--- if line is not blank ---
 cfif len(line)
cfif listLen(line,,) eq 9
cfset Code = ListGetAt(line,1 ,,)
cfset Price = ListGetAt(line,5 ,,)
!--- increment line counter ---

!--- Output #Code# and #Price# here ---
cfoutput
#Code# - #Price# br
/cfoutput

 
cfset countLines = countLines + 1
cfelse
!--- Write Error Log ---
cffile action="" file=#sLogpath#
output=[Line Skipped - #listLen(line,',')# Columns] #line#
addnewline=yes
cfset countErrors = countErrors + 1

/cfif 
/cfif
/cfloop

 
!--- display results ---
cfoutput
font face=Arial size=2
 bFile Parsing Results/b
 hr
 Lines processes correctly : font color=green#countLines#/fontp
 Lines skipped due to errors : font color=red#countErrors#/fontp
 Errors logged to : #sLogpath#p
/font
/cfoutput

 
-Original Message-
From: Jim T [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:11 AM
To: CF-Talk
Subject: RE: Query of a text file

 
But I only want to output code and price
-Original Message-----
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 9:09 AM
To: CF-Talk
Subject: RE: Query of a text file

Well
First of all use this #cfhttp.filecontent# to see what is in the file.

If you need to loop through those contents you will have to do something
like this:

cfloop list=# cfhttp .fileContents# index=line
delimiters=#chr(10)##chr(13)#

This assumes this is a list separated and users vbcrlf for line ends. You
can play around with it if need be.

Inside the cfloop just output #line# to see the contents of the current
row.

You could also assign values or store in a DB at that point as well..

Steve

-Original Message-
From: Jim T [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:55 AM
To: CF-Talk
Subject: Query of a text file

I am Stuck .. can someone help?

I am getting this error:

Attribute validation error for tag cfoutput.
The value of the attribute query, which is currently thefile, is
invalid.

this is the text filetop of the text file:
Code,page,title,unit,price
884,248,LIGHTED ROSE BASKET,1 EA,9.95
1402,194,3 PC BRASS BUTTERFLY WALL SET,1 SET,6.30
1506,91,BRASS/SHIPS CARGO LANTERN,1 EA,53.30
1875,175,10 PC PORC COBALT BLUE TEA SET,1 SET,3.65
1932,54,CHILDREN'S PLAQUE,1 EA,2.65
2018,303,100 BR/BELL WIND CHM,1 EA,2.95

This is the code:

!--- Get the file ---
cfhttp url="">
 method=GET
 Name=thefile
/cfhttp
!--- Output the file ---
cfoutput query=thefile
codeb#code#/b
/cfoutput
Are you paying more than $9.99 for internet? Then you are paying too much!
http://bizovation.speedydialup.net http://bizovation.speedydialup.net
http://bizovation.speedydialup.net
 _
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS help

2003-12-09 Thread Schuster, Steven
Make sure the tag code does not use http:// anywhere is one way. 

 
Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:10 PM
To: CF-Talk
Subject: OT: JS help

 
Hello all,

I'm trying to use a calendar custom tag (cf_formFieldCalendar) inside a
secure directory.Inside the tag it has a window.open command that spawns
a window.When it does, the browser prompts that you're leaving a secure
area.The tag is inside the secure directory.Can anybody tell me how to
get it so the browser doesn't prompt the user that they're leaving a secure
area?

Thanks in advance,
Tim

Here is a piece of the js:

function openCalWin_#attributes.target#() { 
stats='toolbar=no,location=no,directories=no,status=no,menubar=no,'
stats += 'scrollbars=no,resizable=no,width=300,height=250'
CalWin = window.open (,Calendar,stats)
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Prism Antivirus in HOF footer...

2003-12-09 Thread Schuster, Steven
I wonder how it would handle CFCONTENT streams??

-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:21 PM
To: CF-Talk
Subject: Re: Prism Antivirus in HOF footer...

 
Wow, someone actually reads these adds at the bottom of group emails! :)

I don't know what does this program do (this tag) but to keep your
environment safe I think it is OK to run antiviral software on your server
and make sure to take extra care of files being uploaded by users. Also, to
keep your network free consider running integrated e-mail antiviral scanner
(saves on user problems and bandwidth usage).

TK
- Original Message - 
From: Angel Stewart 
To: CF-Talk 
Sent: Tuesday, December 09, 2003 1:55 PM
Subject: Prism Antivirus in HOF footer...

This is the first time I've heard about this product, from the Ad at the
end of one of these messages.

PrismAV for ColdFusion is a custom tag that allows you to scan for, and
repair, virus-infected files from your ColdFusion environment. It is the
first and only anti-virus solution designed specifically for ColdFusion
applications.

I'm a little confused. They say it is an Antivirus package for
Coldfusion Applications. 

Does this mean we can integrate Antivirus scanning into our coldfusion
applications using this tool?
For example to scan file attachments for a file management system or a
CF based webmail system?

Or is it some way to keep your CF Development environment free of
viruses somehow integrating with CF Sandbox security in ways a standard
AV program might not?

-Gel

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.544 / Virus Database: 338 - Release Date: 11/25/2003
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS help

2003-12-09 Thread Schuster, Steven
So there are no internal links using http:// within the custom tag itself
and when you call it externally you are using https:// correct?

 
Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:16 PM
To: CF-Talk
Subject: RE: JS help

 
There is no http anywhere... the calendar is all rendered inside the custom
tag.

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:20 AM
To: CF-Talk
Subject: RE: JS help

Make sure the tag code does not use http:// anywhere is one way. 

Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:10 PM
To: CF-Talk
Subject: OT: JS help

Hello all,

I'm trying to use a calendar custom tag (cf_formFieldCalendar) inside a
secure directory.Inside the tag it has a window.open command that spawns
a window.When it does, the browser prompts that you're leaving a secure
area.The tag is inside the secure directory.Can anybody tell me how to
get it so the browser doesn't prompt the user that they're leaving a secure
area?

Thanks in advance,
Tim

Here is a piece of the js:

function openCalWin_#attributes.target#() { 
stats='toolbar=no,location=no,directories=no,status=no,menubar=no,'
stats += 'scrollbars=no,resizable=no,width=300,height=250'
CalWin = window.open (,Calendar,stats)
_ 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT: JS help

2003-12-09 Thread Schuster, Steven
Bingo, exactly what I said.

-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:25 PM
To: CF-Talk
Subject: Re: OT: JS help

 
JS Popup browsers are called like this:

window.open('http://www.mydomain.com/pagename.html','windowname','[attribute
s]');

This code is in the code of your custom tag. You must adjust this code 
to say https: instead of http:. If the tag calls the popup page as a 
relative link rather than an absolute path then you will probably have 
to change it to an absolute path. Hope this helps.

Cutter

Tim Do wrote:
 Hello all,
 
 
 I'm trying to use a calendar custom tag (cf_formFieldCalendar) inside a
 secure directory.Inside the tag it has a window.open command that
spawns
 a window.When it does, the browser prompts that you're leaving a secure
 area.The tag is inside the secure directory.Can anybody tell me how to
 get it so the browser doesn't prompt the user that they're leaving a
secure
 area?
 
 
 Thanks in advance,
 Tim
 
 
 Here is a piece of the js:
 
 
 function openCalWin_#attributes.target#() {
 stats='toolbar=no,location=no,directories=no,status=no,menubar=no,'
 stats += 'scrollbars=no,resizable=no,width=300,height=250'
 CalWin = window.open (,Calendar,stats)

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




RE: CFSCHEDULE and file attribute problem

2003-12-09 Thread Schuster, Steven
Are you talking code or the actual cfschedule block that executes. In your
code if you are writing a custom log then just do cffile with att of append.

Otherwise you may need to hack into MX to modify the way CFSchedule works??

 
Steve

-Original Message-
From: David Adams [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 1:39 PM
To: CF-Talk
Subject: CFSCHEDULE and file attribute problem

 
I am using cfschedule with action set to update.Upon completion of the
task it overwrites the file I have specified in the file attribute when I
really want it to only append to the file.

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




RE: JS help

2003-12-09 Thread Schuster, Steven
Can you send the code from the calling page and custom tag?

 
Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:33 PM
To: CF-Talk
Subject: RE: JS help

 
that is correct.

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:34 AM
To: CF-Talk
Subject: RE: JS help

So there are no internal links using http:// within the custom tag itself
and when you call it externally you are using https:// correct?

Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:16 PM
To: CF-Talk
Subject: RE: JS help

There is no http anywhere... the calendar is all rendered inside the custom
tag.

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:20 AM
To: CF-Talk
Subject: RE: JS help

Make sure the tag code does not use http:// anywhere is one way. 

Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:10 PM
To: CF-Talk
Subject: OT: JS help

Hello all,

I'm trying to use a calendar custom tag (cf_formFieldCalendar) inside a
secure directory.Inside the tag it has a window.open command that spawns
a window.When it does, the browser prompts that you're leaving a secure
area.The tag is inside the secure directory.Can anybody tell me how to
get it so the browser doesn't prompt the user that they're leaving a secure
area?

Thanks in advance,
Tim

Here is a piece of the js:

function openCalWin_#attributes.target#() { 
stats='toolbar=no,location=no,directories=no,status=no,menubar=no,'
stats += 'scrollbars=no,resizable=no,width=300,height=250'
CalWin = window.open (,Calendar,stats)
_ 
_
_ 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Prism Antivirus in HOF footer...

2003-12-09 Thread Schuster, Steven
Ah yes but we write ours directly from a database BLOB and use the
deletefile option to ensure it gets removed once it has been called so the
file never really just sits out there.

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:39 PM
To: CF-Talk
Subject: Re: Prism Antivirus in HOF footer...

 
Most of the time, CFCONTENT is sending a file that is on the hard drive.
You could scan that file like any other file.

Regards,

Howie
- Original Message - 
From: Schuster, Steven 
To: CF-Talk 
Sent: Tuesday, December 09, 2003 2:26 PM
Subject: RE: Prism Antivirus in HOF footer...

I wonder how it would handle CFCONTENT streams??
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS help

2003-12-09 Thread Schuster, Steven
){
var dateString = (monthNum + 1) + '-' + dayNum + '-' + yearNum

document.#attributes.formname#.#attributes.target#.value = dateString

CalWin.close()
}

/script

cfif #attributes.image# NEQ 0
a href="">
src="" border=0/a
cfelse
a href="">
/cfif 
/cfoutput

cfcatch type=Any
script language=_javascript_
alert(You must supply a value for the FORMNAME  TARGET attributes!)
/script
/cfcatch
/cftry

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:43 AM
To: CF-Talk
Subject: RE: JS help

Can you send the code from the calling page and custom tag?

Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:33 PM
To: CF-Talk
Subject: RE: JS help

that is correct.

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:34 AM
To: CF-Talk
Subject: RE: JS help

So there are no internal links using http:// within the custom tag itself
and when you call it externally you are using https:// correct?

Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:16 PM
To: CF-Talk
Subject: RE: JS help

There is no http anywhere... the calendar is all rendered inside the custom
tag.

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:20 AM
To: CF-Talk
Subject: RE: JS help

Make sure the tag code does not use http:// anywhere is one way. 

Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:10 PM
To: CF-Talk
Subject: OT: JS help

Hello all,

I'm trying to use a calendar custom tag (cf_formFieldCalendar) inside a
secure directory.Inside the tag it has a window.open command that spawns
a window.When it does, the browser prompts that you're leaving a secure
area.The tag is inside the secure directory.Can anybody tell me how to
get it so the browser doesn't prompt the user that they're leaving a secure
area?

Thanks in advance,
Tim

Here is a piece of the js:

function openCalWin_#attributes.target#() { 
stats='toolbar=no,location=no,directories=no,status=no,menubar=no,'
stats += 'scrollbars=no,resizable=no,width=300,height=250'
CalWin = window.open (,Calendar,stats)
_ 
_
_ 
_
_ 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: JS help

2003-12-09 Thread Schuster, Steven
This is the HTML source, I mean the actual TAG source code. Again, the
images need to be fully qualified in here as well but I am sure there is
more.

 
Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:36 PM
To: CF-Talk
Subject: RE: JS help

 
No http://
this is what the source looks like:

htmlheadTitleSelect a Date/titleSTYLE TYPE=text/cssA { color:
#00; font-family:Verdana;font-size:12px; font-weight: normal;
text-decoration: none; padding:0em .5em;}A:hover { color: #cc6600;
background-color: #ecf4f7; padding:0em .5em; }body { background: #ff;
}/STYLE/headbodya name=this/atable align=center height=100%
width=100% border=0 bordercolor=#ff cellpadding=0 cellspacing=0trth
bgcolor=#b2d9ec colspan=7font face=Verdana color=#006699 size=2December
2003/font/th/trtr bgcolor=#ecf4f7thfont face=Verdana
color=#006699 size=1Su/font/ththfont face=Verdana color=#006699
size=1Mo/font/ththfont face=Verdana color=#006699
size=1Tu/font/ththfont face=Verdana color=#006699
size=1We/font/ththfont face=Verdana color=#006699
size=1Th/font/ththfont face=Verdana color=#006699
size=1Fr/font/ththfont face=Verdana color=#006699
size=1Sa/font/th/trtrtd align=center width=14.28%nbsp;/tdtd
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
td align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
td align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
td align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%a
href="">
align=center width=14.28%nbsp;/tdtd align=center
width=14.28%nbsp;/tdtd align=center
width=14.28%nbsp;/td/trformtr bgcolor=#ecf4f7td colspan=7
align=centerinput type=image src="" align=middle
alt= border=0 name=Backward value=
 face=Verdana color=#006699
size=1 Arrows browse through the months./font input type=image
src="" align=middle alt= border=0 name=Forward
value=
>


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:38 AM
To: CF-Talk
Subject: RE: JS help

ugh, take a look at the HTML source after your page is drwan.I bet there
is an HTTP in the window.open call.

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 2:16 PM
To: CF-Talk
Subject: RE: JS help

There is no http anywhere... the calendar is all rendered inside the custom
tag.

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 11:20 AM
To: CF-Talk
Subject: RE: JS help

Make sure the tag code does not use http:// anywhere is one way. 

Steve

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 09, 2003 2:10 PM
To: CF-Talk
Subject: OT: JS help

Hello all,

I'm trying to use a calendar custom tag (cf_formFieldCalendar) inside a
secure directory.Inside the tag it has a window.open command that spawns
a window.When it does, the browser prompts that you're leaving a secure
area.The tag is inside the secure directory.Can anybody tell me how to
get it so the browser doesn't prompt the user that they're leaving a secure
area?

Thanks in advance,
Tim

Here is a piece of the js:

function openCalWin_#attributes.target#() { 
stats='toolbar=no,location=no,directories=no,status=no,menubar=no,'
stats += 'scrollbars=no,resizable=no,width=300,height=250'
CalWin = window.open (,Calendar,stats)
_ 
_ 
_ 
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Application Modeling/Design/Diagramming

2003-12-08 Thread Schuster, Steven
I use VISIO Enterprise Architect but that's mostly because I do .NET and CF
and the .NET is so easy in VISIO. CF is pretty easy as well using VISIO. It
also supports UML and other things that I need.

 
Steve

-Original Message-
From: Venable, John [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 08, 2003 3:40 PM
To: CF-Talk
Subject: Application Modeling/Design/Diagramming

 
Hello everyone, 

I wanted to get some idea of what everyone uses to layout an application
prior to building it. I'm trying to improve my skills and this is probably
the biggest hurdle for me now--how to plan everything out beforehand rather
than just jumping in and coding until I get myself into a corner that
could've been avoided with better pre-planning. So, anyone have any advice,
commentary, tools, books, web sites, general resources to point me in the
right direction?

Thanks much

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




RE: Do you apply tax after shipping costs?

2003-12-08 Thread Schuster, Steven
Dennis is correct. I would suggest you get in contact with a local SBA or
State agency to help you determine applicable tax laws for shipping, etc.
Also, certain goods may or may not be taxable as well.

 
Steve

 
-Original Message-
From: Dennis Powers [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 08, 2003 3:52 PM
To: CF-Talk
Subject: RE: Do you apply tax after shipping costs?

 
 Do you apply applicable taxes before or after the shipping costs?

 right cuz you pay taxes on goods, not services.

Taxes are determined state by state.In Connecticut you pay taxes on the
Product + shipping cost.

Best regards,

Dennis Powers
UXB Internet - A Web Design and Hosting Company
690 Wolcott Road - P.O. Box 6028
Wolcott, CT 06716 USA
tel: (203)879-2844fax: (203)879-6254
http://www.uxbinternet.com/ http://www.uxbinternet.com/ 
http://dennis.uxb.net/ http://dennis.uxb.net/ 

=
This e-mail message has been scanned and certified Virus free

=
This e-mail message has been scanned and certified Virus free
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Anybody up to test something REALLY weird?

2003-12-07 Thread Schuster, Steven
I see it. Maybe you just need a cup of coffee...

Steve



_

From: Jim Davis [mailto:[EMAIL PROTECTED] 
Sent: Monday, December 08, 2003 12:19 AM
To: CF-Talk
Subject: RE: Anybody up to test something REALLY weird?

I've put a file up with only that line and empty application.cfm and
onrequestend.cfm files here:

http://www.firstnight.org/Test/ http://www.firstnight.org/Test/ 

Do you see the image?I see nothing (in the page or in the source) from
CFMX 6.1 on two servers using IE 6

Jim Davis

_

From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
Sent: Monday, December 08, 2003 12:13 AM
To: CF-Talk
Subject: RE: Anybody up to test something REALLY weird?

Works here too (IE 5.5).

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

Tel: (02) 62115927

 Andrew Scott

 [EMAIL PROTECTED] To: CF-Talk
[EMAIL PROTECTED] 
cc:

 08/12/2003 16:08Subject:RE: Anybody up to
test something REALLY weird?
 Please respond to

 cf-talk

 |
_

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




Stream PDF using CFCONTENT

2003-12-04 Thread Schuster, Steven
Anyone done this, I can't remember how

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




RE: Stream PDF using CFCONTENT

2003-12-04 Thread Schuster, Steven
Well, I solved it...here is the code below in case anyone else needs to do
something like this

 
It is not complete but it works. Need to add some param defaults and the
such.

 
Basically you pass in the following:

 
SID = Datasource name
ID = This is the ID of the row where the blob is stored
Table = This is the Table name of the Blob
UIDFIELD = This is the fieldname in the Table Name that is the Key field for
the passed ID (whew!)
MEDIAFIELD = This is the Blob field name from the table name 
DIRECTORYSET = This is the full path to where the temp files are written
(they are deleted so don't panic)

 
If you pass a 0 for the ID it will exit out. I will also need to add an
extension field so it can handle more than PDF's

 
cfparam name=SID default=None
cfparam name=ID default=0
cfparam name=Table default=None
cfparam name=UidField default=ID
cfparam name=MediaField default=Media
cfparam name=DirectorySet default=c:\inetpub\wwwroot\Faxed\viewacts\

 
cfif #ID# IS 0
p
General Error Occured
/p
cfabort
cfelse
cftry
CFQUERY name=qryGetCV datasource=#SID#
SELECT *
FROM #Table#
WHERE #uidfield# = #ID# 
/CFQUERY

cfcatch type=Database
A general database error has occured
trying to run the specified query!
p
SELECT *
FROM #Table#
WHERE #uidfield# = #ID# 
/p
cfabort
/cfcatch
/cftry

!--- Create the Temp Files ---
cfdirectory directory=#DirectorySet# name=qryFindIt
cfset temp = ValueList(qryFindIt.Name)

 
cfoutput query=qryGetCV
cfset FileVal = #Evaluate(qryGetCV. 
#uidfield#)#  .pdf
cfset myCount = ListValueCount(temp, FileVal)
cfif #myCount# IS 1
!--- Skip For Now ---
cfelse
cffile action="">
file=#DirectorySet##FileVal# output=#toBinary(Evaluate(qryGetCV. 
#mediafield#))# addnewline=No
/cfif
/cfoutput

 
!--- Display File in Browser ---
!--- Also deleted the file after it has been written to
conserve space ---
cfoutput
cfcontent file=#DirectorySet##Evaluate(FileVal)#
type=application/pdf deletefile=Yes
/cfoutput
/cfif

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 12:13 PM
To: CF-Talk
Subject: RE: Stream PDF using CFCONTENT

 
 Anyone done this, I can't remember how

To the best of my knowledge, this isn't possible through CFCONTENT. If you
want to byte-serve PDF files, you'll have to do this through your web
server, or use something other than CF.

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




RE: CFFILE a few things

2003-12-04 Thread Schuster, Steven
Does anyone have a sample connectstring for CFQUERY for Oracle. Here is what
I use for JSP and was wondering if it would be ok for CFM as well.

 
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=+ strHost +
)(PORT =+ strPort + ))(CONNECT_DATA=(SID= + strSid + )))

 
I figure the jdbc:oracle:thin would be something like Oracle.Macr or
something

 
Anyone?

-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 1:44 PM
To: CF-Talk
Subject: RE: CFFILE a few things

 
 So you do an upload and then a rename?

You can't rename before it's uploaded (removing spaces) - unless you
specify the name it's going to be...

 2) When using the move action, there is no option to handle
 name conflicts!!Do you then have to do a try/catch around
 the move and if an error is found try another file name
 (seems pretty clunky to me)??

This is what the FileExists() function is for!
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




ConnectString - Oops

2003-12-04 Thread Schuster, Steven
-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 1:51 PM
To: CF-Talk
Subject: RE: CFFILE a few things

 
Does anyone have a sample connectstring for CFQUERY for Oracle. Here is what
I use for JSP and was wondering if it would be ok for CFM as well.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=+ strHost +
)(PORT =+ strPort + ))(CONNECT_DATA=(SID= + strSid + )))

I figure the jdbc:oracle:thin would be something like Oracle.Macr or
something

Anyone?

-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 1:44 PM
To: CF-Talk
Subject: RE: CFFILE a few things

 So you do an upload and then a rename?

You can't rename before it's uploaded (removing spaces) - unless you
specify the name it's going to be...

 2) When using the move action, there is no option to handle
 name conflicts!!Do you then have to do a try/catch around
 the move and if an error is found try another file name
 (seems pretty clunky to me)??

This is what the FileExists() function is for!
_
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Stream PDF using CFCONTENT

2003-12-04 Thread Schuster, Steven
Actually I do need them. In my testing the PDF streamed the direct binary
without them and didn't associate it to the pdf viewer. It may be something
on our end but it still happened. In actuality this will server DOC, TXT,
etc as well but that was just a preliminary piece of code.

 
Sorry for the word usage I have been working on byte streaming on another
project...information overload.

S

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 2:11 PM
To: CF-Talk
Subject: RE: Stream PDF using CFCONTENT

 
 Well, I solved it...here is the code below in case anyone else 
 needs to do something like this
 
 It is not complete but it works. Need to add some param defaults 
 and the such.
 
 ...

 cfoutput
 cfcontent file=#DirectorySet##Evaluate(FileVal)#
 type=application/pdf deletefile=Yes
 /cfoutput

In my experience, this would return a PDF in its entirety to the browser.
This isn't the same as byte-serving a PDF, in which case the client receives
a page at a time.

On an unrelated note, you don't need the CFOUTPUT tags there, since you're
not outputting text to the client, and you don't need Evaluate, since you
can just refer to FileVal directly.

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




RE: Does ASP 3.0 have something similar

2003-12-04 Thread Schuster, Steven
ASP.NET does :-(

 
Here is a link

http://aspnet.4guysfromrolla.com/articles/022802-1.aspx
http://aspnet.4guysfromrolla.com/articles/022802-1.aspx 

-Original Message-
From: Sandy Clark [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 04, 2003 2:46 PM
To: CF-Talk
Subject: Does ASP 3.0 have something similar

 
I need to emulate Coldfusion's CFSAVECONTENT in ASP, can anyone point me in
a direction?3rd party is good too.

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




Nulling or reseting password in MX 6.1

2003-12-03 Thread Schuster, Steven
OK,

 
I forgot my Admin password on my MX 6.1 box, does anyone know how I can NULL
it or reset it. 

 
I seem to remember some XML doc you could modify to do this but have since
forgotten it's name and what to change.

 
Steve

http://www.houseoffusion.com/banners/view.cfm?bannerid=24
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




JRUN/JSP and Cold Fusion are about to kill me....

2003-12-03 Thread Schuster, Steven
We had this pretty app that used a JSP page to display BLOB data from Oracle
running on MX 6.1 and O8i.

 
It was working perfectly on box A, then I moved it to box B which has the
exact same settings in the CF administrator and uses the exact same
classes12.zip files (et all) and it is FUBAR.

 
Sometimes I get the Server Busy message, sometimes I get raw PDF output and
sometimes I get a PDF document. Now the funny thing is this went from a PIII
with 128 Meg ram to a Dual P4 2.0 with over 2 Gig of memory and a RAID drive
system.

 
I checked the event.log in the runtime folder and keep getting a lot of
java.lang.IllegalStateExceptions.

 
Anyone got any clues as to why this may be happening???

 
Steve

 
-Original Message-
From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 03, 2003 2:11 PM
To: CF-Talk
Subject: cfif dynamic lt / gt

 
hey everyone. i want to write a cfif tag that checks to see if a var is
defined and switches the gt / lt attribute based on that check. for example
- if the variable is defined, then write 

cfif blah lt 4

if the variable is not defined then write...

cfif blah gt 4

any help is appreciated. thanks.
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF Certification

2003-11-26 Thread Schuster, Steven
I've been in this industry for about 14 years and nobody at any job I have
ever had (including ones I was the boss at) has ever asked or cared about
those things.

 
Granted I have a degree in CS Engineering but even at that they have never
even bothered to contact my school to check it out (well at least on my last
3 jobs).

 
I guess it's assumed that after 14 years I should know at least the
basicsboy do I have 'em all fooled.

 
Steve

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 26, 2003 2:33 PM
To: CF-Talk
Subject: RE: CF Certification

 
that's really a personal choice, I believe.did it get me anything besides
a nice little flag on my Max Badge, and a good feeling that I am proficient
in the coding language that my livelihood is based on, nope.but it was
cool to take, kinda let me know that I am good at what I do, and for what
that is worth, why not take it. 

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 26, 2003 1:55 PM
To: CF-Talk
Subject: Re: CF Certification

One the topic of the CF Certification, I am curious as to what value people
that are certified get from the certification?Is it worth it?
- Original Message -
From: Dominic J. Doucet-Lorang
To: CF-Talk
Sent: Wednesday, November 26, 2003 1:41 PM
Subject: CF Certification

Hi,
I am looking at taking the Macromedia CF test and would like an idea on a
good book for preparing for the exam.

Thanks,

Dominic J. Doucet-Lorang

_


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




Access Opened Exclusively Problem

2003-11-25 Thread Schuster, Steven
Does anyone know how to:

 
I am reverting back to access for the first time in like 5 years. Anyway,
the file is in Access 97 format. I am running MACR CF 6.1. 

 
I can create a DSN connection through ODBC at the system level (on the NT
Server). When I go into MX 6.1 to create the ODBC Socket connection I get a
opened exclusively by another user, or you need permission to view its
data.

 
I do not have the Access mdb open at this time in Access and don't see a
record locking file on the server for it either where the original mdb is
located. 

 
To note, this is also a mapped drive. The actual access file does not reside
on the MX box in question.

 
Thanks,
S

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




RE: ListFind() weirdness

2003-11-25 Thread Schuster, Steven
Hmmm...something to ponder

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 25, 2003 10:00 AM
To: CF-Talk
Subject: RE: ListFind() weirdness

 
 Wouldn't a list, by nature of it being a list, need more than 
 1 value to be called a list?

No, I don't think so. A list is simply a string of characters, and strings
can have a length of zero, after all. Admittedly, that list probably
wouldn't be especially useful.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ http://www.figleaf.com/ 
voice: (202) 797-5496
fax: (202) 797-5444

_


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




RE: Access Opened Exclusively Problem

2003-11-25 Thread Schuster, Steven
Next time I'll proof... My bad:)

 
I'll try these out and see what happens. I am almost positive I have CFMX
running under a local account.

 
Steve

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 25, 2003 9:52 AM
To: CF-Talk
Subject: RE: Access Opened Exclusively Problem

 
 I am reverting back to access for the first time in like 5 
 years. 

I don't want you to take this the wrong way, but this is one of my pet
peeves - you don't revert back, you just revert, the fact that you're
going backwards is implicit. Sorry, but I couldn't help myself. Now, on to
your question!

 Anyway, the file is in Access 97 format. I am running MACR 
 CF 6.1. 

 I can create a DSN connection through ODBC at the system 
 level (on the NT Server). When I go into MX 6.1 to create the 
 ODBC Socket connection I get a opened exclusively by another 
 user, or you need permission to view its data.

 I do not have the Access mdb open at this time in Access and 
 don't see a record locking file on the server for it either 
 where the original mdb is located. 

 To note, this is also a mapped drive. The actual access file 
 does not reside on the MX box in question.

Does the user account used by the CFMX service understand the mapping, or
even have rights to the remote share? By default, CFMX (and previous
versions as well) run as SYSTEM, which has no rights to network resources.
You'd have to run CF as a specific user with rights to the remote share, and
if you wanted to use a mapping (instead of just accessing the share via a
UNC path) you'd have to create the mapping while logged on with that user
account, or you'd have to create a mapping that all accounts can see by
doing so while logged in as a domain administrator. I'm a little hazy on
that last part, actually, because it's been a while since I've wanted to do
that.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ http://www.figleaf.com/ 
voice: (202) 797-5496
fax: (202) 797-5444

_


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




RE: Access Opened Exclusively Problem

2003-11-25 Thread Schuster, Steven
I was in the process of reverting when I realized I had already reverted to
the previous state. Now that I have reverted I found the solution by
reverting back to this email.

 
You are correct sir! When I stopped all of the MX services and reregistered
them to run under my domain account the datasource worked as expected.

 
Thanks.

 
Steve

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, November 25, 2003 9:52 AM
To: CF-Talk
Subject: RE: Access Opened Exclusively Problem

 
 I am reverting back to access for the first time in like 5 
 years. 

I don't want you to take this the wrong way, but this is one of my pet
peeves - you don't revert back, you just revert, the fact that you're
going backwards is implicit. Sorry, but I couldn't help myself. Now, on to
your question!

 Anyway, the file is in Access 97 format. I am running MACR 
 CF 6.1. 

 I can create a DSN connection through ODBC at the system 
 level (on the NT Server). When I go into MX 6.1 to create the 
 ODBC Socket connection I get a opened exclusively by another 
 user, or you need permission to view its data.

 I do not have the Access mdb open at this time in Access and 
 don't see a record locking file on the server for it either 
 where the original mdb is located. 

 To note, this is also a mapped drive. The actual access file 
 does not reside on the MX box in question.

Does the user account used by the CFMX service understand the mapping, or
even have rights to the remote share? By default, CFMX (and previous
versions as well) run as SYSTEM, which has no rights to network resources.
You'd have to run CF as a specific user with rights to the remote share, and
if you wanted to use a mapping (instead of just accessing the share via a
UNC path) you'd have to create the mapping while logged on with that user
account, or you'd have to create a mapping that all accounts can see by
doing so while logged in as a domain administrator. I'm a little hazy on
that last part, actually, because it's been a while since I've wanted to do
that.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ http://www.figleaf.com/ 
voice: (202) 797-5496
fax: (202) 797-5444

_


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




  1   2   >