RE: Server Not Returning Debug Info

[Olive, Christopher M Mr USACHPPM]

are your developers on DHCP?  perhaps your IP leases came up.  check the IPs
on your machines against the list in CFAdmin.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 8:55 AM
To: [EMAIL PROTECTED]
Subject: Server Not Returning Debug Info


Ok.
To my knowledge no changes have been made to our CF 4.5.1 Professional
server.
However, the server is now not returning any Debug information, although all
the values for debugging are set to on, as well as the IP addresses are
correctly set.
This was working the last time I did development work on this machine last
week.
Any ideas on what could cause this?
:-\

-Gel


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

RE: Session and Array

[Olive, Christopher M Mr USACHPPM]

sure.


..

Chris Olive,
DOEHRS Website Administrator 


-Original Message-
From: Phim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 2:24 AM
To: [EMAIL PROTECTED]
Subject: Session and Array


Hi Everyone ,

Is there any way to declare array to be as session ?

I have problem that when I set array as global variable ( such as PriceArray
in application.cfm ) and after process task and submit form , I found my
array length = 0 , ArrayLen(PriceArray) = 0

So Is there any method or command to set my array as global .


Regards,
Phim


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

RE: Shopping Cart w/ ICVerify

[Olive, Christopher M Mr USACHPPM]

www.cfwebstore.com .  fantastic product, wondeful support, amazingly easy to
customize, etc, etc.  mary jo has done a fabulous job with this piece of
software, and i highly recommend it to everyone developing an exommerce
solution.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: LH Rothman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 1:58 AM
To: CF Talk
Subject: Shopping Cart w/ ICVerify


Anyone know of a CF good tool/resource for building a shopping cart that
allows the user to pay via ICVerify?  I'm wary of anything beyond a "mid
range" difficulty level.

Thanks!
- L


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

RE: Question about Multiple Order By

[Olive, Christopher M Mr USACHPPM]

yes, it is.

SELECT blahblah
...
ORDER BY city, name

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 24, 2000 4:01 PM
To: [EMAIL PROTECTED]
Subject: Question about Multiple Order By


Ok, can i do this?  I mean i want to order by name first, then i want to 
orderby city, so if we have kevin and john in seattle, i want to be able to 
sort them accordingly.  

So is it possible to do two order by commands within the SQL statement?

-kev

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

RE: Mapping Extensions

[Olive, Christopher M Mr USACHPPM]

in the MMC, select the web site.  select "properties".  go to "home
directory"->"configuration".  then map *.htm/l to the CF dll.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Geoffrey V. Brown [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 24, 2000 12:47 PM
To: [EMAIL PROTECTED]
Subject: Mapping Extensions



Hi,
Does anyone know the registry entry that needs to be added so that I can
have .htm files executed as cold fusion templates?  I found the way to do it
on PWS, but I can't find the key in IIS.


Geoffrey Brown
Intelliforum : Beyond HTML
http://www.intelliforum.com




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

RE: CF & MS Word

[Olive, Christopher M Mr USACHPPM]

yes, as a matter of fact, there is.  (at least the text part)  i'm doing
such a thing for my project now.  you can interface with MSWord fairly
easily (and portably) by using an RTF file.  there's a decent start tutorial
here:
http://www.irt.org/articles/js154/index.htm

if you want any pointers, feel free to drop me a line.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 21, 2000 10:30 AM
To: [EMAIL PROTECTED]
Subject: CF & MS Word


Ok here is what i want to do, question is, is it possible.
I want to beable to have CF Write a file with a few images
and some text and save it as a MS WORD document instead of
a text document. Is there a way to do this?
Kelly

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

RE: Access field names with spaces

[Olive, Christopher M Mr USACHPPM]

while this is the best answer, you can enclose them in ['s. (eg, [field 1],
[field 2].)

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Allen G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 20, 2000 2:10 PM
To: [EMAIL PROTECTED]
Subject: Re: Access field names with spaces


rename them!  =-)

- Original Message -
From: "Claremont, Timothy S" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 20, 2000 1:03 PM
Subject: Access field names with spaces


> Can anyone tell me the secret to working with Access field names that have
> spaces in them?
>
> Thanks,
> Tim
> --

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


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

RE: ORDER BY in a UNION Query

[Olive, Christopher M Mr USACHPPM]

odd.  last time i ported from informix (where i used the column position) to
Oracle 8i, it barfed.  strange.  i'll have to try it again.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Paul Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 19, 2000 10:14 AM
To: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY in a UNION Query 


Um, I've written many union queries on Oracle, and that's how I've always
handled the Order By. It also seems to work on SQL Server. Dunno about the
rest of the DB world.

-- 
Paul Wakefield

Hanlon's Razor - Never attribute to malice that which can be adequately
explained by stupidity.


> -----Original Message-
> From: Olive, Christopher M Mr USACHPPM
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 19, 2000 4:10 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: ORDER BY in a UNION Query 
> 
> 
> as a side note, this will not work in all DBs (eg, oracle)
> 
> Chris Olive,
> DOEHRS Website Administrator 
> 
> -Original Message-
> From: Paul Wakefield [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 19, 2000 8:40 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: ORDER BY in a UNION Query 
> 
> 
> Try using column positions, rather than names, eg.
> 
> (You'll need to substitute appropriate column positions)
> 
> 
>  
>   
>ORDER BY 2
>   
>ORDER BY 4
>   
>  
> 
> -- 
> Paul Wakefield
> 
> Hanlon's Razor - Never attribute to malice that which can be 
> adequately
> explained by stupidity.
> 
> 
> > -Original Message-
> > From: Angél Stewart [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 19, 2000 2:30 PM
> > To: [EMAIL PROTECTED]
> > Subject: SQL: ORDER BY in a UNION Query 
> > 
> > 
> > Hey folks :)
> > 
> > I'm trying to write a simple UNION query, between two 
> > dynamically created
> > select queries.
> > Based on the feilds that the user entered in the previous 
> > form, the SQL
> > statement's WHERE clauses are created.
> > 
> > Basically, I want to pull data from the current Employee Info 
> > table, and the
> > Employee History table, for a report.
> > 
> > However, the user has the option of Ordering the report 
> > either by name, or
> > by Absence Type.
> > 
> > When I stick the Order By statement at the end of the second 
> > Select clause,
> > Oracle returns the error:
> > "[Microsoft][ODBC driver for Oracle][Oracle]ORA-00904: 
> > invalid column name "
> > 
> > The column names Name and Reason *are* present in both 
> > tables. I tried to
> > qualify these columns by using empinfo.name and 
> > empinfo.reason, but this has
> > not helped.
> > 
> > Do any of you have a sample SQL statement that includes UNION 
> > and an ORDER
> > BY clause?
> > :-)
> > 
> > 
> >  
> >   ORDER BY empinfo.Name
> >  
> >   ORDER BY empinfo.Reason
> >  
> > 
> > 
> > (If order value is not selected, then the resulting recordset 
> > will be sorted
> > according to Employee ID.)
> > 
> > -Gel
> > 
> > 
> > 
> > 
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

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

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

RE: ORDER BY in a UNION Query

[Olive, Christopher M Mr USACHPPM]

as a side note, this will not work in all DBs (eg, oracle)

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Paul Wakefield [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 19, 2000 8:40 AM
To: '[EMAIL PROTECTED]'
Subject: RE: ORDER BY in a UNION Query 


Try using column positions, rather than names, eg.

(You'll need to substitute appropriate column positions)


 
  
   ORDER BY 2
  
   ORDER BY 4
  
 

-- 
Paul Wakefield

Hanlon's Razor - Never attribute to malice that which can be adequately
explained by stupidity.


> -Original Message-
> From: Angél Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 19, 2000 2:30 PM
> To: [EMAIL PROTECTED]
> Subject: SQL: ORDER BY in a UNION Query 
> 
> 
> Hey folks :)
> 
> I'm trying to write a simple UNION query, between two 
> dynamically created
> select queries.
> Based on the feilds that the user entered in the previous 
> form, the SQL
> statement's WHERE clauses are created.
> 
> Basically, I want to pull data from the current Employee Info 
> table, and the
> Employee History table, for a report.
> 
> However, the user has the option of Ordering the report 
> either by name, or
> by Absence Type.
> 
> When I stick the Order By statement at the end of the second 
> Select clause,
> Oracle returns the error:
> "[Microsoft][ODBC driver for Oracle][Oracle]ORA-00904: 
> invalid column name "
> 
> The column names Name and Reason *are* present in both 
> tables. I tried to
> qualify these columns by using empinfo.name and 
> empinfo.reason, but this has
> not helped.
> 
> Do any of you have a sample SQL statement that includes UNION 
> and an ORDER
> BY clause?
> :-)
> 
> 
>  
>   ORDER BY empinfo.Name
>  
>   ORDER BY empinfo.Reason
>  
> 
> 
> (If order value is not selected, then the resulting recordset 
> will be sorted
> according to Employee ID.)
> 
> -Gel
> 
> 
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: CF and ASP permissions problem

[Olive, Christopher M Mr USACHPPM]

you may want to look at what context the CF service on the dev machine is
running.  if it's system, the IUSR account may be mangled, or it may not
have appropriate permissions to log onto the exchange server.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: van Der Walt, Estee [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 6:42 AM
To: '[EMAIL PROTECTED]'
Subject: CF and ASP permissions problem


Hi 

I wonder if anyone can help me with the following problem. I've written an
asp page in MS Visual Interdev 6.0 and it works fine. The asp page connects
to Exchange Server and use cdo objects to extract the necessary information.

I then called this asp page from within a coldfusion page on my local
machine and it still works fine, but as soon as I move my work onto the
development server and try to run the coldfusion page (with the embedded asp
page), I get the following error:

Microsoft VBScript runtime error '800a000d' 

Type mismatch: 'Logon' 

/intranet/Diary/PublicDiary/CheckAvailability.asp, line 176


It seems that logon to the exchange server can not be achieved. I think that
my problem has to do with the permission being set up wrong on the
development server. Can anyone please give me advise on what to do...

Thanks
Estee van der Walt

Estee van der Walt
UPC TVi, London
[EMAIL PROTECTED]

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

RE: CF and ASP

[Olive, Christopher M Mr USACHPPM]

the short answer to this is no.

more descriptively, you are not able to do this because CF and ASP are both
interpreted by different DLLs.  once the template is handed to one or the
other, the DLL in question will barf on the code that it doesn't understand.

conversely, you CAN pass control from a CF page to ASP page (and vice
versa.)  example, you can have the action of a form in CF point to an ASP
page.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 11:34 AM
To: '[EMAIL PROTECTED]'
Subject: CF and ASP


Is there any possible way to insert cold fusion code into an asp file? Can
you rename a whatever.asp to whatever.cfm and will it still work?


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

CFContent after SP6

[Olive, Christopher M Mr USACHPPM]

does anyone have the link to the fix for CFCONTENT after SP6?  allaire's
site search is down, and MS's search doesnt turn up anything useful.

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

RE: CF Contract?

[Olive, Christopher M Mr USACHPPM]

100% correct. relying on the "default" is not the best way to do business. i
would strongly encourage you to specify the contractual oblications
regarding IP.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 29, 2000 9:50 AM
To: [EMAIL PROTECTED]
Subject: Re: CF Contract?


Chris,

Thanks for the feedback. You're probably right but the most common reason
for lawsuits are misunderstandings. The one thing that I've learned about
intellectual property rights over the years is that its a *VERY* gray area
of law and leaves quite a bit to interpretation.

Rey...

- Original Message -
From: "Olive, Christopher M Mr USACHPPM"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 29, 2000 8:54 AM
Subject: RE: CF Contract?


> mostly correct.
>
> 
> i am not a lawyer. i am in no way affiliated with lawyers, beyond
> occasionally having a drink with my pre-law friends.  take this with a
grain
> of salt.
> 
>
> that having been said...
>
> i am somewhat familiar with intellectual property rights.  the current
> standard (that is, what is commonly accepted in the court cases i have
read)
> is that "work for hire, unless specifically identified as otherwise, is
the
> sole intellectual property of the creator."
>
> what this means, in plain english, is this:
>
> if you have a contract with an entity (businessi/individual) and they are
> NOT paying you as a W2 employee, the work is yours, unless expressly
stated
> otherwise in the contract.  eg, if you are a 1099 worker, there must be a
> proviso in the contract specifically deliniating the IP rights of the
> created work.  if not, it's yours.
>
> does this make sense?  it's a bit early for me to be having legal
> conversations. :)
>
> Chris Olive,
> DOEHRS Website Administrator
>
>
> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 28, 2000 9:23 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: CF Contract?
>
>
> Christine,
>
> All I can say is tread lightly with this issue. Do they know that the code
> cannot be redistributed? Many companies assume complete ownership of work
> they've contracted for. Since you're coming to them after the work has
been
> started, you may encounter some resistance. Make sure that you review the
> code and determine what you consider your own propietary code vs. what was
> actually custom made for the client. You have a right to your code,
> obviously but the client will feel the same way about their finished
> application.
>
> Rey...
> Certified Allaire Instructor
> Member of Team Allaire
>
> "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>
>
> - Original Message -
> From: "Christine Kelley" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 28, 2000 7:20 PM
> Subject: CF Contract?
>
>
> > Hi all!
> >I am finishing up a couple small CF applications for a
> > company, but I don't have any kind of a contract for them to
> > sign saying they won't redistribute the code, etc.  Does
> > anyone have a standard contract they could post?  I'm kind
> > of new at this so I don't know what to watch out for.
> > Thanks,  Christine
> > [EMAIL PROTECTED]
> >
>
> --
> 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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


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

RE: CF Contract?

[Olive, Christopher M Mr USACHPPM]

mostly correct.


i am not a lawyer. i am in no way affiliated with lawyers, beyond
occasionally having a drink with my pre-law friends.  take this with a grain
of salt.


that having been said...

i am somewhat familiar with intellectual property rights.  the current
standard (that is, what is commonly accepted in the court cases i have read)
is that "work for hire, unless specifically identified as otherwise, is the
sole intellectual property of the creator."

what this means, in plain english, is this:

if you have a contract with an entity (businessi/individual) and they are
NOT paying you as a W2 employee, the work is yours, unless expressly stated
otherwise in the contract.  eg, if you are a 1099 worker, there must be a
proviso in the contract specifically deliniating the IP rights of the
created work.  if not, it's yours.

does this make sense?  it's a bit early for me to be having legal
conversations. :)

Chris Olive,
DOEHRS Website Administrator 


-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 28, 2000 9:23 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: CF Contract?


Christine,

All I can say is tread lightly with this issue. Do they know that the code
cannot be redistributed? Many companies assume complete ownership of work
they've contracted for. Since you're coming to them after the work has been
started, you may encounter some resistance. Make sure that you review the
code and determine what you consider your own propietary code vs. what was
actually custom made for the client. You have a right to your code,
obviously but the client will feel the same way about their finished
application.

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."


- Original Message -
From: "Christine Kelley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 28, 2000 7:20 PM
Subject: CF Contract?


> Hi all!
>I am finishing up a couple small CF applications for a
> company, but I don't have any kind of a contract for them to
> sign saying they won't redistribute the code, etc.  Does
> anyone have a standard contract they could post?  I'm kind
> of new at this so I don't know what to watch out for.
> Thanks,  Christine
> [EMAIL PROTECTED]
>
> --

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


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

RE: OT SQL Server 7 and Win2K

[Olive, Christopher M Mr USACHPPM]

according to MS's site, SQL 7.0 is 100% compliant with Win2K.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 27, 2000 3:54 PM
To: [EMAIL PROTECTED]
Subject: OT SQL Server 7 and Win2K


I am considering upgrading to Win2K. Are there known issues between Win2K
and SQL Server 7.0?

TIA


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

RE: CFSTOREDPROC and Access97

[Olive, Christopher M Mr USACHPPM]

actually, that's not technically correct.  while access "queries" are closer
to views in this case, CF can treat them like SPs.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 11:13 AM
To: [EMAIL PROTECTED]
Subject: Re: CFSTOREDPROC and Access97


I could be incorrect here, but Access "queries" are not the same thing as
stored procs.  As best I understand it, they are just save pieces of SQL,
which are run whenever they are
called.. not quite the same thing as stored procedures.  You will need to
reproduce the query in CF.  Alternately, I've heard that Access 2000
supports stored procs (though I've never
tried it.. haven't used Access for development in quite a while)

--
Billy Cravens
[EMAIL PROTECTED]


Aidan Whitehall wrote:

> Are there any known problems using CFSTOREDPROC and queries in an Access97
> database?
>
> I'm having a hell of a time getting a simple UPDATE query to work
(although
> SELECT queries work no problem).
>
> If you run the query from within Access, it asks for the variable values
and
> then updates the relevant record fine. But passing them as CFPROCPARAMs
> doesn't seem to work at all (pretty sure all the data-types are OK).
>
> I'd paste the code but there's *heaps*... just wondered if anyone had any
> general comments on this topic.
>
> Thanks again.
>
> --
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
>
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
>

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




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

RE: IIS sharing on IP address

[Olive, Christopher M Mr USACHPPM]

with IIS, the three things that make up a "site's ID" are IP address, port,
and host header.  change any one of these, and it's a "new" site.

however, host headers are a bit sticky.  the client browser needs to know
how to use them (essentially 3+ browsers here) and the client box has to
"know" about the host header (which usually entails modifying the hosts
file.)  these are usually only a good idea for "internal" site separation.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 10:17 AM
To: '[EMAIL PROTECTED]'
Subject: OT: IIS sharing on IP address


I have been looking through the help though I am not sure exactly
what to search on. What i want to do is have as many domains as I want
sharing on ip address, though i can't find out how to go about doing this.
Anyone who knows how to do it would be greatly appreciated.

Bob Everland

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

RE: Background HTTP Requests

[Olive, Christopher M Mr USACHPPM]

why not spawn a new window via javascript and have it do it's thing, while
the main (user) browser retains focus?

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Pete Miller [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 19, 2000 10:51 AM
To: [EMAIL PROTECTED]
Subject: Background HTTP Requests


Hello all,

Is there anyway to do an HTTP request in the background without
effecting the user's session.  We are developing a 5-step process and a
request needs to be made in the third step that takes 1-2 minutes.  We
don't want to have the client's browser getting a time out (from a proxy
server or otherwise) and want them to continue on with the process. 
When the long process completes, it doesn't need to return anything to
the user, just update a database.  Can I accomplish this using a CFHTTP
POST or will the process still hang until I get a response?  I basically
need a way to make a request without the user's browser waiting for the
response.  Any help or insight would be greatly appreciated.  Thanks.

-- 
Pete Miller
GOTech, Inc.
http://www.gotech.net

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

RE: Integration with NT Domain Security

[Olive, Christopher M Mr USACHPPM]

what exactly are you trying to accomplish?  you can always set the
permissions on the file/directory/share via windows explorer.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Phil Labonte [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 17, 2000 8:19 PM
To: [EMAIL PROTECTED]
Subject: Integration with NT Domain Security


How do I hook into NT domain security with cold fusion?  Does anyone have
any information on how to do this?


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

RE: Best Method

[Olive, Christopher M Mr USACHPPM]

your best bet is to attach a "date/time posted" field to the entry in the
DB, and do a LAST(5) in your SQL statement.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Jeffrey Cohen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 06, 2000 10:36 AM
To: House OfFusion
Subject: Best Method


Greetings...

What is the best method for reading ONLY the last  five records in a
database for display?

I have a client that adds articles daily to a news database, and then
displays them on a news page. There are hundreds of articles, and on his
home page he just wants to display the 5 most recent. (which would be
the last five in the database, I presume)

Suggetstions???

and thanks as always for your help in advance...

Jeffrey Cohen
ImageWorks


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

RE: Is there a typical cause for this error message?

[Olive, Christopher M Mr USACHPPM]

um...somewhere in my head.  of course, Dave Watts has a much more
comprehensive list stored in HIS head, but i don't have full time access to
THAT. :)

seriously, no.  but you might want to start keeping a (paper/electronic) log
of "things i've seen vs. their causes".  a KB of your own, if you will.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Tom Rainey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 6:40 PM
To: [EMAIL PROTECTED]
Subject: RE: Is there a typical cause for this error message?


is there a good list of error messages and typical causes?

-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 9:49 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Is there a typical cause for this error message?


yes.  it's usually seen when you try to insert into a TEXT field in the DB
that is too short for the value being insert.

ex,

inserting the string "Hello world" into a CHAR(4) field.

Chris Olive,
DOEHRS Website Administrator

-Original Message-
From: Steve Weiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 10:43 AM
To: '[EMAIL PROTECTED]'
Subject: Is there a typical cause for this error message?


Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)


[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (41:7) to (41:98).




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

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


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

RE: Is there a typical cause for this error message?

[Olive, Christopher M Mr USACHPPM]

yes.  it's usually seen when you try to insert into a TEXT field in the DB
that is too short for the value being insert.

ex,

inserting the string "Hello world" into a CHAR(4) field.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Steve Weiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 10:43 AM
To: '[EMAIL PROTECTED]'
Subject: Is there a typical cause for this error message?


Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)


[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (41:7) to (41:98).




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

RE: IIS,Virtual Directorys and CF?

[Olive, Christopher M Mr USACHPPM]

that's one possibility.

and don't shout.  i was only making an observation. :)

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 2:25 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


i SHOULD PROBABLY CREATE A CF_USER ACCOUNT
THAT HAS READ ONLY RIGHTS?
-Original Message-----
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 1:49 PM
To: '[EMAIL PROTECTED]'
Subject: RE: IIS,Virtual Directorys and CF?


fantatic.  glad you fixed it.

one problem.

that's a BIG security hole.  with CF running as the admin account, if
someone compromises an app, they have COMPLETE access to your system.

Chris Olive,
DOEHRS Website Administrator

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 1:32 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your help, but I have resolved this.
My virtual directory worked fine I just could not get CF server to
process .cfm files located on the other machine.
My fix:
Under services in the NT control Panel,
I selected Cold fusion application server
in the "Log In As" portion of the dialog box
I changed from the default system user to (in my case)
Administrator--stopped and restarted the service--
and everything worked!


-----Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 12:49 PM
To: '[EMAIL PROTECTED]'
Subject: RE: IIS,Virtual Directorys and CF?


create a virtual directory in IIS, point it to a "different machine" (an
option in  the create VD screen), and use a UNC to tell it where to look.
mapping a drive will only work if you map is as the service in whose context
the CF server runs.

Chris Olive,
DOEHRS Website Administrator

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Can I host .cfm files on a different server than my cold fusion server?
I am currently hosting all my .cfm files on an NT server running coldfusion.
For security reasons I would like to be able  host my .cfm intranet files on
our novell server. I have been succesful setting up a virtual directory that
allows
the nt server to view directorys and files that are located on the novell
box ,
but when i call a .cfm page I get a 404 error.
Do I need to change my root development
mapping on the cold fusion server? I have tried to browse to the novell
machine
but cf only sees local drives.

Help please!
Malcolm

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your response---
I have not had any trouble w/ users editing the cf_includes
They are invisible when the document is viewed in word unless you choose
view html source---Most of my users are not advanced enough to know what
view html source even means. I did not really understand the rest of your
explanation.

I have never created a macro before---Can I attach this to the template?
Why do you not like this idea?


-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:41 AM
To: [EMAIL PROTECTED]
Subject: Re: IIS,Virtual Directorys and CF?


Hi Malcolm,

I' m a little confused by the first part of the question - however I have
some suggestions of the no2.

a) Don't include the cfinlcude etc in your Word Template , instead create a
handler which includes the middle bit (the HTML created by your users) in
between the cfincludes . this will get around the .cfm problem & also stop
users from removing the cfincludes from the template.

b) write a AutoClose macro for word that saves the file as .cfm (I don't
really like this idea...)


> 2.Although the templates work really well--word insists on using.htm as
the
> default extension.
> Is there a way to change this default? If Not can I set up cf server to
> parse for all .htm extensions--
> convert to .cfm and upload to the live directory? can i schedule this
using
> the shcheduled events in cf server?
>



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


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

RE: IIS,Virtual Directorys and CF?

[Olive, Christopher M Mr USACHPPM]

fantatic.  glad you fixed it.

one problem.

that's a BIG security hole.  with CF running as the admin account, if
someone compromises an app, they have COMPLETE access to your system.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 1:32 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your help, but I have resolved this.
My virtual directory worked fine I just could not get CF server to
process .cfm files located on the other machine.
My fix:
Under services in the NT control Panel,
I selected Cold fusion application server
in the "Log In As" portion of the dialog box
I changed from the default system user to (in my case)
Administrator--stopped and restarted the service--
and everything worked!


-Original Message-----
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 12:49 PM
To: '[EMAIL PROTECTED]'
Subject: RE: IIS,Virtual Directorys and CF?


create a virtual directory in IIS, point it to a "different machine" (an
option in  the create VD screen), and use a UNC to tell it where to look.
mapping a drive will only work if you map is as the service in whose context
the CF server runs.

Chris Olive,
DOEHRS Website Administrator

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Can I host .cfm files on a different server than my cold fusion server?
I am currently hosting all my .cfm files on an NT server running coldfusion.
For security reasons I would like to be able  host my .cfm intranet files on
our novell server. I have been succesful setting up a virtual directory that
allows
the nt server to view directorys and files that are located on the novell
box ,
but when i call a .cfm page I get a 404 error.
Do I need to change my root development
mapping on the cold fusion server? I have tried to browse to the novell
machine
but cf only sees local drives.

Help please!
Malcolm

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your response---
I have not had any trouble w/ users editing the cf_includes
They are invisible when the document is viewed in word unless you choose
view html source---Most of my users are not advanced enough to know what
view html source even means. I did not really understand the rest of your
explanation.

I have never created a macro before---Can I attach this to the template?
Why do you not like this idea?


-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:41 AM
To: [EMAIL PROTECTED]
Subject: Re: IIS,Virtual Directorys and CF?


Hi Malcolm,

I' m a little confused by the first part of the question - however I have
some suggestions of the no2.

a) Don't include the cfinlcude etc in your Word Template , instead create a
handler which includes the middle bit (the HTML created by your users) in
between the cfincludes . this will get around the .cfm problem & also stop
users from removing the cfincludes from the template.

b) write a AutoClose macro for word that saves the file as .cfm (I don't
really like this idea...)


> 2.Although the templates work really well--word insists on using.htm as
the
> default extension.
> Is there a way to change this default? If Not can I set up cf server to
> parse for all .htm extensions--
> convert to .cfm and upload to the live directory? can i schedule this
using
> the shcheduled events in cf server?
>



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


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


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

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

RE: IIS,Virtual Directorys and CF?

[Olive, Christopher M Mr USACHPPM]

create a virtual directory in IIS, point it to a "different machine" (an
option in  the create VD screen), and use a UNC to tell it where to look.
mapping a drive will only work if you map is as the service in whose context
the CF server runs.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Can I host .cfm files on a different server than my cold fusion server?
I am currently hosting all my .cfm files on an NT server running coldfusion.
For security reasons I would like to be able  host my .cfm intranet files on
our novell server. I have been succesful setting up a virtual directory that
allows
the nt server to view directorys and files that are located on the novell
box ,
but when i call a .cfm page I get a 404 error.
Do I need to change my root development
mapping on the cold fusion server? I have tried to browse to the novell
machine
but cf only sees local drives.

Help please!
Malcolm

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your response---
I have not had any trouble w/ users editing the cf_includes
They are invisible when the document is viewed in word unless you choose
view html source---Most of my users are not advanced enough to know what
view html source even means. I did not really understand the rest of your
explanation.

I have never created a macro before---Can I attach this to the template?
Why do you not like this idea?


-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:41 AM
To: [EMAIL PROTECTED]
Subject: Re: IIS,Virtual Directorys and CF?


Hi Malcolm,

I' m a little confused by the first part of the question - however I have
some suggestions of the no2.

a) Don't include the cfinlcude etc in your Word Template , instead create a
handler which includes the middle bit (the HTML created by your users) in
between the cfincludes . this will get around the .cfm problem & also stop
users from removing the cfincludes from the template.

b) write a AutoClose macro for word that saves the file as .cfm (I don't
really like this idea...)


> 2.Although the templates work really well--word insists on using.htm as
the
> default extension.
> Is there a way to change this default? If Not can I set up cf server to
> parse for all .htm extensions--
> convert to .cfm and upload to the live directory? can i schedule this
using
> the shcheduled events in cf server?
>



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


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


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

RE: Avoiding using the MAX function

[Olive, Christopher M Mr USACHPPM]

yes, if you call a stored procedure to insert the record, and reference the
@@IDENTITY property after the SP call.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 12:45 PM
To: Cf-Talk
Subject: Avoiding using the MAX function


Hi Everyone,

At the CFUG-orama in Washington DC last week, I think Ben Forta said that
there is a way to avoid having to use the "MAX()" SQL function to get the ID
number of the item you just inserted into a database.  Can anyone tell me
how to do this?

In other words, currently I'm doing something like this:


INSERT INTO tablename  (x,y,z)
values ('x','y','z')


Then, to get the autonumber'ed ID of the item I just inserted, I'll use:


Select Max(ID) as the_newest_record
>From Tablename


Now I'll have the ID number of the newest inserted record in
#get_the_newest_record.newest_record#.

If I understood Ben correctly, then there is a way to insert the record AND
return the ID number of that inserted record all at the same time.

The database in question is a SQL Server database.  (Although it would be
good to know how to do it with MS Access if its possible).

Thanks,

Eron


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

RE: Slightly OT: Dev. for multiple browser versions

[Olive, Christopher M Mr USACHPPM]

as far as IE, you can run 4.x and 5.x concurrently if you install 5.x with
the "live with 4.x" option.  it's a checkbox when you install the browser.
NS you can just install to different directories.

i believe that there's a tool on the 'net somewhere to check compatibility,
but the URL escapes me at this moment.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:35 AM
To: [EMAIL PROTECTED]
Subject: Slightly OT: Dev. for multiple browser versions


Much thanks to this list, I just turned in my first very large project to a
client who is very happy with the results.  Amazing what CF can do!

On to my next project: my new client has asked that we make sure the site is
compliant with IE 3.0 - 5.1, and Netscape 4.0 - present.  Not a huge deal,
but a big pain in the butt.  I've tried running both IE 4.0 and 5.0 on my
development machine with no luck.  How am I going to run three versions of
each browser?

How do you suggest ensuring compliancy with all browsers and versions?

Thanks,




Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]


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

RE: Merging form fields to single DB field...

[Olive, Christopher M Mr USACHPPM]

in your insert statement, do...


INSERT INTO
fred
(fieldtogetmergedforms, ...)
VALUES
(#FORM.statefield##FORM.numberfield#, ...)


Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: C [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 23, 2000 9:28 PM
To: [EMAIL PROTECTED]
Subject: Merging form fields to single DB field...


I'd like to be able to have users select a dropdown (state) and combine 
that variable with a textinput (a set of digits) to make that a single 
identifier..

something like


 
(textbox)


I can't find anything for merging these two variables into a single form 
variable for integration into a database.. am I on the right track here?

CW


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

RE:

[Olive, Christopher M Mr USACHPPM]

because if you try to use the CFML that created the error in the first place
in your CFERROR, you'll get an endless loop.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: stäs [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 12:37 PM
To: [EMAIL PROTECTED]
Subject: 


Why can't the error handler page contain any CFML, just because? Thanks!


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

RE: Strip directory path to get just file name

[Olive, Christopher M Mr USACHPPM]

do a ListLast("c:\webshare\wwwroot\site\filename.cfm", "\").

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: cf kaizen [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 12:41 PM
To: [EMAIL PROTECTED]
Subject: Strip directory path to get just file name


Hi All,

If my value in a string is 

c:\webshare\wwwroot\site\filename.cfm

, how I just strip it down so I can dump filename.cfm
into a variable?

I am thinking that I should access the above string
from the right side, looping through each character
until I get to the first "\". However, I don't know
where to start with the code (and, I left both cfwacks
books at home :(

Any help is very much appreciated!

Thanks!
Andy

__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

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

FW: Kind Of Off Topic

[Olive, Christopher M Mr USACHPPM]

i would use the web server logs.  if you're using IIS, turn on HTTP_REFERRER
in your log settings.  then do whatever you need to.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 4:17 PM
To: [EMAIL PROTECTED]
Subject: Kind Of Off Topic


This is a multi-part message in MIME format.

--=_NextPart_000_00AC_01BFBF52.1AC980A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hey Everyone,
 I have a question which is kind of off topic but it's still in the =
scope of CF. my company is going to be doing a promo with another =
company and I need to track how many users will be coming to our site =
from the link that this other company will have on their site. This is =
the first time I've ever had to do this so I'm not sure of the best way =
to go about this. Does anyone have any suggestions or good resources =
they can send me to so I can get this set up, I would prefer to do it in =
CF.

Thanks

Ben Densmore
Webmaster
eSupport.com, Inc
TouchStone Software Corp.


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








Hey Everyone,
 I have a question which is kind =
of off topic=20
but it's still in the scope of CF. my company is going to be doing a =
promo with=20
another company and I need to track how many users will be coming to our =
site=20
from the link that this other company will have on their site. This is =
the first=20
time I've ever had to do this so I'm not sure of the best way to go =
about this.=20
Does anyone have any suggestions or good resources they can send me to =
so I can=20
get this set up, I would prefer to do it in CF.
 
Thanks
 
Ben =
DensmoreWebmastereSupport.com,=20
IncTouchStone Software Corp.

--=_NextPart_000_00AC_01BFBF52.1AC980A0--


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

RE: Remote Monitoring

[Olive, Christopher M Mr USACHPPM]

if you have NT server anywhere else, you can set up PerfMon (Performance
Monitor) to look at a remote server.  is this what you were after when you
said "monitoring"?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 9:18 AM
To: [EMAIL PROTECTED]
Subject: Remote Monitoring


This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_8ED69BB4.C5A4CBB5
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Anyone know of a good mid-priced product to monitor CF and IIS remotely.

Thank you for your time.

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506


--=_8ED69BB4.C5A4CBB5
Content-Type: text/plain
Content-Disposition: attachment; filename="David Clay.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Clay, David
TEL;WORK:(303) 967-1558
ORG:;Engineering Automation Group
TEL;PREF;FAX:(303) 770-8506
EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED]
N:Clay;David
TITLE:Web Facilitator
X-GWUSERID:clayd
END:VCARD


--=_8ED69BB4.C5A4CBB5--

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

RE: Slightly OT: Lighten things up a little

[Olive, Christopher M Mr USACHPPM]

echoing this thread to CF-community, as seth so rightly pointed out.

jake, that's exactly what i'm talking about.  the professors may have gotten
their degrees in the 80s/70s.  however, the principles underlying the array,
structure, and loop have NOT changed since then.  i would venture to say
that they have not changed in quite a while.  it is when we learn the
theory, not the application, that we can really raise the ceiling of our
programming skills.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Jake Hileman [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 7:20 PM
To: [EMAIL PROTECTED]
Subject: Re: Slightly OT: Lighten things up a little


word, that's what i'm saying... school can NOT keep up. half the professors
there got their degrees in the early 80s and late 70s... bleh.. please mr.
professor have a seat, lemme show ya a lil' sumtin sumtin.. :-)

as you can tell, i'm young, i'm 18, own my own hosting company and finished
my first year of college this year.. and guess what... it's my last too.

learning cf now... cf rocks... but it uses too much mem.. hahaha

thanks guys, rock on.

jake
- Original Message -
From: "Michael Kear" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 6:57 PM
Subject: RE: Slightly OT: Lighten things up a little


> This will amuse some of you no doubt ... my 20 year old son dropped out of
> university.  He just wouldn't put in the work and the results reflected
> his effort.   He's got a job in a support department for a software
> company.
>
> After he made the decision to drop out (only days before the decision was
> made for him I should add) he sat back in the couch and said "A. At
> last.  I'm finished with all that learning!"
>
> HEhehe  . hate to have bad news for you kid, but your learning's only just
> started.
>
> Seems to me the vast majority of people earning a living in Internet
> disciplines are doing things they never learned in university.  Technology
> is just moving far too fast for schools to keep up.
>
> Similarly, if we let our own knowledge fall behind, we're dead ducks.
>
>
> Cheers,
> Mike Kear
> AFP Web Development
> Windsor, NSW, Australia
>
>
> --

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


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

RE: Setting Focus to Field

[Olive, Christopher M Mr USACHPPM]

you could either combine the stuff into one function call (eg...)


...

function doonloadstuff() {
...
}






or you could separate them with semis. (eg...)



Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 2:51 PM
To: [EMAIL PROTECTED]
Subject: Re: Setting Focus to Field


"Reilly, Jim" wrote:
> 
> 
> 

If I already have an onload in a page, how would I add this one too? I'm
doing some preloading, and I'd like to also set the focus to a form
field.

Thanks,
--John

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

RE: OT: School Days - (was: Lighten things up a little)

[Olive, Christopher M Mr USACHPPM]

oddly enough, my degree is a split major in writing and computer science. ;)

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 1:18 PM
To: '[EMAIL PROTECTED]'
Subject: RE: OT: School Days - (was: Lighten things up a little)


I don't know about in the states but out of ten developers, nine
have degrees in technical subjects and well the boss has an english degree
:)

Stew


> -Original Message-
> From: Todd Ashworth [SMTP:[EMAIL PROTECTED]]
> Sent: 15 May 2000 18:30
> To:   [EMAIL PROTECTED]
> Subject:  Re: OT: School Days - (was: Lighten things up a little)
> 
> OK .. I'll give you that, but then again, how hard would it really be to
> pick up on those concepts on your own?  I don't doubt the value of that
> degree in certain situations; It *can* give you an edge.  In many cases,
> especially when dealing with jobs involving new technology, just having
> the
> degree is more important than what it's in .. if the degree is even
> important at all.
> 
> A college education does tend to make one a more well rounded individual
> and
> I suppose that's desirable to some people.  Unfortunately, the way I see
> it
> is that the college degree won't play a big role for me until I get more
> experience under my belt and move on up into much more competitive
> markets.
> In today's computer age, you can go a good long ways without one, but they
> really help if you want to get to the top :)  So .. I say if you have the
> chance to go, take it.  It can't hurt and will help, even if indirectly.
> Besides, I just want to say I is edumacated .. That's why I'm going back
> for
> a masters in biology. :)
> 
> Heh .. wonder how I can work that into ColdFusion development?
> 
> hmmm .. ?
> Or maybe start a new company, hire Linus Torlvolds and call it
> Transmetaphase?
> 
> OK .. I'm just being silly now.
> 
> Seriously, has anyone had any experience with ColdFusion jobs where the
> employers were concerned with the level of post secondary education?  I'm
> really curious now.
> 
> .Todd
> 
> - Original Message -
> From: "Olive, Christopher M Mr USACHPPM"
> <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, May 15, 2000 12:08 PM
> Subject: RE: Slightly OT: Lighten things up a little
> 
> 
> | i'm afraid i'd have to disagree with that.  i may not "use" anything i
> | learned in college in respect that they never taught me ASP, CF, IIS,
> etc.
> | however, the concept of a stack, queue, linked list, structure, array,
> etc.,
> | is universal to languages (ok, well, most languages).  it is in
> | *understanding* the concepts of these things that college shows its
> value.
> | because of this (fairly) solid foundation in programming *theory*, i am
> | better able to leverage my skill sets in languages i know.  more
> | importantly, they help me in learning something new.  when you boil it
> down,
> | all languages are the same (ok, there are sub-types of programming
> languages
> | (procedural, functional, OO)), all you need to know is where to put the
> semi
> | colons.
> 
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.

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

RE: OT: School Days - (was: Lighten things up a little)

[Olive, Christopher M Mr USACHPPM]

the concepts are not "hard" to pick up on your own.  it's just that when you
spend ~4 years using them in CS assignments, you "own" them.  that is, you
have the theory so deeply entrenched that they beome invisible to you, and
second nature in your development efforts.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 1:30 PM
To: [EMAIL PROTECTED]
Subject: Re: OT: School Days - (was: Lighten things up a little)


OK .. I'll give you that, but then again, how hard would it really be to
pick up on those concepts on your own?  I don't doubt the value of that
degree in certain situations; It *can* give you an edge.  In many cases,
especially when dealing with jobs involving new technology, just having the
degree is more important than what it's in .. if the degree is even
important at all.

A college education does tend to make one a more well rounded individual and
I suppose that's desirable to some people.  Unfortunately, the way I see it
is that the college degree won't play a big role for me until I get more
experience under my belt and move on up into much more competitive markets.
In today's computer age, you can go a good long ways without one, but they
really help if you want to get to the top :)  So .. I say if you have the
chance to go, take it.  It can't hurt and will help, even if indirectly.
Besides, I just want to say I is edumacated .. That's why I'm going back for
a masters in biology. :)

Heh .. wonder how I can work that into ColdFusion development?

hmmm .. ?
Or maybe start a new company, hire Linus Torlvolds and call it
Transmetaphase?

OK .. I'm just being silly now.

Seriously, has anyone had any experience with ColdFusion jobs where the
employers were concerned with the level of post secondary education?  I'm
really curious now.

.Todd

- Original Message -
From: "Olive, Christopher M Mr USACHPPM"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 12:08 PM
Subject: RE: Slightly OT: Lighten things up a little


| i'm afraid i'd have to disagree with that.  i may not "use" anything i
| learned in college in respect that they never taught me ASP, CF, IIS, etc.
| however, the concept of a stack, queue, linked list, structure, array,
etc.,
| is universal to languages (ok, well, most languages).  it is in
| *understanding* the concepts of these things that college shows its value.
| because of this (fairly) solid foundation in programming *theory*, i am
| better able to leverage my skill sets in languages i know.  more
| importantly, they help me in learning something new.  when you boil it
down,
| all languages are the same (ok, there are sub-types of programming
languages
| (procedural, functional, OO)), all you need to know is where to put the
semi
| colons.



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

RE: Slightly OT: Lighten things up a little

[Olive, Christopher M Mr USACHPPM]

i'm afraid i'd have to disagree with that.  i may not "use" anything i
learned in college in respect that they never taught me ASP, CF, IIS, etc.
however, the concept of a stack, queue, linked list, structure, array, etc.,
is universal to languages (ok, well, most languages).  it is in
*understanding* the concepts of these things that college shows its value.
because of this (fairly) solid foundation in programming *theory*, i am
better able to leverage my skill sets in languages i know.  more
importantly, they help me in learning something new.  when you boil it down,
all languages are the same (ok, there are sub-types of programming languages
(procedural, functional, OO)), all you need to know is where to put the semi
colons.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 10:58 AM
To: [EMAIL PROTECTED]
Subject: Re: Slightly OT: Lighten things up a little


No kidding .. I have not used 1 single thing I ever 'learned' in college in
any job I have had since then.  I learned what I'm doing now on my own (with
the help of you fine people) ... wacky field we work in ;)  That new
certification from Allaire will be worth infinately more than that piece of
paper the college gives you.

.Todd

- Original Message -
From: "Chris Hayes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 15, 2000 10:21 AM
Subject: Re: Slightly OT: Lighten things up a little


| I doesn't... if you had years of sitting around with nothing to useful to
| do, you'd achieve exactly the same, college or not :-)
|
| Chris



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

RE: How to create Array of Structures

[Olive, Christopher M Mr USACHPPM]

fred = arrayNew(1);
fred[1] = StructNew(stFred);
...


Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Ajoy Singh [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 12, 2000 12:53 PM
To: cf-Talk
Subject: How to create Array of Structures


Hi all,
How do we create Array of Structures in ColdFusion? As an example I have a
query to get the list of employees and I need to create it as an array of
structures. How do you populate data and how can we retrieve it?
Example Query:

select ssn, firstName, lastName from employee

Thanks,
Ajoy

__
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup


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

RE: M$ Site Server

[Olive, Christopher M Mr USACHPPM]

i found site server to be GREAT when used to analyze the web server logs.
it can slice and dice the information in 500 ways.  great stuff.

Chris Olive
DOHRS Website Administrator


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2000 5:41 PM
To: [EMAIL PROTECTED]
Subject: OT: M$ Site Server


Hello:

My client asked me my opinion about
the subject.  Not having one of my
own, I'm asking you about yours.

Anyone?

best,  paul


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

RE: CFHTTP - for the love of god!

[Olive, Christopher M Mr USACHPPM]

no, you are incorrect.  i created a "gateway" page to all my web based email
accounts, so i could pick the account from a drop down, enter a uname/pwd,
and go, instead of typing in separate URLs.  it's kludgy (the app) but the
part you want works.



...


(with all the more apologies to the freds out there.)

Chris Olive
DOHRS Website Administrator


-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 6:08 PM
To: [EMAIL PROTECTED]
Subject: CFHTTP - for the love of god!


Am I correct in thinking that CFHTTP can only construct a query if you
use GET, not POST?

Why are they doing this to us?! I just need to send a few
parameters to a CGI script which only accepts POST operations, and it
returns nicely tab delimited text. If any of you know someone who works
for Allaire, please HURT THEM NOW.

Dave


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

RE: Order by a field with multiple keywords

[Olive, Christopher M Mr USACHPPM]

sorry, fred. :)

Chris Olive
DOHRS Website Administrator


-Original Message-
From: Fred T. Sanders [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 8:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Order by a field with multiple keywords 


I resemble that search!

LOL
Fred

- Original Message -
From: "Olive, Christopher M Mr USACHPPM"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2000 3:14 PM
Subject: RE: Order by a field with multiple keywords


> you're subject line is close to the actual solution. :)
>
> try.
>
> SELECT
> fred,
> fred2,
> fred3,
> region
> FROM
> sometable
> GROUP BY
> region
> ORDER BY
> region
>
> Chris Olive
> DOHRS Website Administrator
>
>
> -Original Message-
> From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 09, 2000 1:22 PM
> To: Cf-Talk@Houseoffusion. Com
> Subject: Order by a field with multiple keywords
>
>
> Hi, All
>
> I have a table with a "region" field that would contain
several entries
> (Central Coast, California, West Coast, USA). How can I
display the list by
> each individual region? Most records, of course will be
displayed several
> times in each subgroup.
>
> All I can  think of is make a list of all regions and then
run a query for
> each of them. Is there a better way? With just one query?
>
> TIA
>
> Cyrill
>
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or
> send a message to [EMAIL PROTECTED] with
'unsubscribe' in
> the body.
> --

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


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

RE: Order by a field with multiple keywords

[Olive, Christopher M Mr USACHPPM]

you're subject line is close to the actual solution. :)

try.

SELECT
fred,
fred2,
fred3,
region
FROM
sometable
GROUP BY
region
ORDER BY
region

Chris Olive
DOHRS Website Administrator


-Original Message-
From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 1:22 PM
To: Cf-Talk@Houseoffusion. Com
Subject: Order by a field with multiple keywords 


Hi, All

I have a table with a "region" field that would contain several entries
(Central Coast, California, West Coast, USA). How can I display the list by
each individual region? Most records, of course will be displayed several
times in each subgroup.

All I can  think of is make a list of all regions and then run a query for
each of them. Is there a better way? With just one query?

TIA

Cyrill



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

RE: long tables and headings

[Olive, Christopher M Mr USACHPPM]

you could probably just redisplay the heading every N rows or somehting...

this should display the heading every 30 rows.  chencge the MOD by number to
suit your taste.

btw, this is off the top of my head.  the code may not be EXACTLY what
you're after.  but it should get you started.





Heading 1
Heading 2
Heading 3



Data 1
Data 2
Data 3




Chris Olive
DOHRS Website Administrator


-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 12:47 PM
To: [EMAIL PROTECTED]
Subject: long tables and headings


Several of my applications list out a few hundred records in table format,
the top row contains the headings.  After scrolling down you loose the
headings and are constantly scrolling up down up down to see the heading.
Ive played with a this a little using a frame, it works ok but you must
define everything to be the exact width height etc otherwise things dont
line up, it creates lots of maintenance it seems and Id rather not use
another frame for this.

Is there some method for a floating heading bar anyone has discovered or
some JavaScript that would pop up the heading when a link is clicked say in
the first column or something like this...? How are people handling this,
anything I can do with CF...?

Thanks,Adrian


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

RE: conditional statements with a cfouput group

[Olive, Christopher M Mr USACHPPM]

that's not correct.  use one grouping per level of CFOUTPUT.

ex.


...

...



you are correct in that both columns need to appear in the GROUP BY clause
of the SQL statement.

Chris Olive
DOHRS Website Administrator


-Original Message-
From: Christopher P. Maher [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 08, 2000 4:23 PM
To: [EMAIL PROTECTED]
Subject: RE: conditional statements with a cfouput group


I didn't follow all of this, but if you are going to next grouping in
CFOutput, you have to have the first grouping include both fields:

Group="city,lastname" for the first cfoutput

Group="lastname" for the second.

Also, be sure you have sorted the query records by City, LastName

I don't usually use CFOutput to group. Rather I use CFLoop and control my
grouping by setting and comparing variables.

Chris

---
Christopher P. Maher
mailto:[EMAIL PROTECTED]
Maher Associates, Inc.
Actuarial and Computer Consulting
http://www.maherassociates.com


> -Original Message-
> From: Shane Witbeck [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 08, 2000 12:31 PM
> To: [EMAIL PROTECTED]
> Subject: conditional statements with a cfouput group
>
>
> I am trying to filter each record within a cfouput group. Is
> there a way to
> exclude a portion of code from within a cfouput group. The problem I am
> running into is records are being grouped together despite
> conditional code
> I have placed within the grouped cfoutput tag.
>
> What is happening now is any record in the beginning of the grouped output
> pulls in other records that are not suppose to be displayed
> according to the
> conditional date statement as shown below in the pseudocode.
>
> Any alternative suggestions on how to accomplish this would be great.
>
>
>
> This is the current pseudocode:
>
> cfquery for the whole record set
>
> cfoutput group=city
>
> cfif 3 fields containing date attributes are null
> cfset expdate=createdate(3 fields)
> /cfif
>
> cfif datecompare(expdate, now()) is 1
>
> code to display city header
>
> cfouput group=lastname
>
> rest of code for each record detail
>
> 
>  
>
> The current output is correct but is not displaying the correct records
> according to the date criteria.
>
> city
>   lastname
>records
>
> next city
>   lastname
>records
> ...
>


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

RE: Val() doesn't work like I need it to

[Olive, Christopher M Mr USACHPPM]

i would recommend doing something like this...


$

this way, the user will see the $ sign, and the db will only see the number.
solves both problems. :)

btw, in an email before this,  KC Chapman incorrectly says that
VAL("123boy") resolves to 1.  it resolves to 123.  the "Returns a number
that the beginning of a string can be converted to" in the docs refers to a
*sequence* of numbers at the beginning of the string, not just the first
number.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Reuben King [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 08, 2000 2:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Val() doesn't work like I need it to


In 
<[EMAIL PROTECTED]>, 
"Olive, Christopher M Mr USACHPPM" ("Olive, Christopher M Mr USACHPPM") 
in a fit of unbridled passion, wrote:
> why are there dollar signs there in the first place?  the dollar sign
> display should be a separate entity from the actual number.  what are you
> trying to do?

I have a form with a text field that asks for a dollar value.  I need to 
parse that into a real number for insertion into an Oracle NUMBER(10,2) 
column.

Thanks,
-RK

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

RE: Val() doesn't work like I need it to

[Olive, Christopher M Mr USACHPPM]

why are there dollar signs there in the first place?  the dollar sign
display should be a separate entity from the actual number.  what are you
trying to do?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Reuben King [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 08, 2000 1:40 PM
To: [EMAIL PROTECTED]
Subject: Val() doesn't work like I need it to


Val("$12.31") returns 0.  Val("1,120.1") returns 1.. This is starting to 
piss me off.  Am I missing something here?  Am I going to have to write 
a custom tag to simply convert a human-readable number into a number-
number for insertion into an Oracle column? (Oracle's to_number() is 
just as useless, if not more so! urg.)

TIA,
-R

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

echo...echo...

[Olive, Christopher M Mr USACHPPM]

did everyone get wiped by the iloveyou worm?

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

RE: Query help

[Olive, Christopher M Mr USACHPPM]

you need to add all the fields to which you are not applying an aggregate
function to your GROUP BY clause

to whit, add:

GROUP BY
ORDERID,CUSTOMERID,REPORTID,ORDERDATE,PRICE,TRANSAPPROVED,ORDER_TYPE

to the end of the sql statement.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]

-Original Message-
From: stäs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 02, 2000 5:02 PM
To: [EMAIL PROTECTED]
Subject: Query help


Hello, I am getting the below message:

[INTERSOLV][ODBC Oracle 8 driver][Oracle 8]ORA-00937: not a single-group 
group function

SQL = "SELECT SUM(PRICE) AS 
tot_price,ORDERID,CUSTOMERID,REPORTID,ORDERDATE,PRICE,TRANSAPPROVED,ORDER_TY
PE 
FROM REIS.ORDERS WHERE TRANSAPPROVED = 'Y' AND ORDERDATE BETWEEN 
'25-Apr-2000' AND '03-May-2000' AND ORDERS.ORDER_TYPE = 'F' ORDER BY 
ORDERS.ORDERDATE DESC"

Thanks for any help.


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

RE: joining tables

[Olive, Christopher M Mr USACHPPM]

first thing's first.  please post in plain text instead of HTML.  it makes
it MUCH easier to help you.

second.

you're querying from three different tables.  since you only specify one in
your where clause, you get what's called a "cartesian product".  what you
need to do is make sure all the tables from which you query are joined
appropriately.

ex. (i'm assuming the primary keys are the same in each table, and that
products is a subtable of category.)

WHERE CLIENTS.CLIENT_NAME='#session.client#' AND
PRODUCTS.client_name= CLIENTS.client_name AND
CATEGORY.category_id = products.category_id.


does this make sense?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]



-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 02, 2000 12:25 PM
To: '[EMAIL PROTECTED]'
Subject: OT: joining tables


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFB452.F8791E40
Content-Type: text/plain;
charset="iso-8859-1"

hey people,

i'm doing a join in this query:

SELECT  CLIENTS.CLIENT_NAME, PRODUCTS.PRODUCT_NAME, CATEGORY.CAT_ID,
CATEGORY.CATEGORIES
FROM CLIENTS, PRODUCTS, CATEGORY
WHERE CLIENTS.CLIENT_NAME='#session.client#'

I have only one record in the database right now for testing. so there is
only one client. But this query keeps pull out the one client as two
different clients.

I can't figure it out.

Shawn Regan

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






OT: joining tables



hey people,


i'm doing a join in this query:


SELECT  CLIENTS.CLIENT_NAME, =
PRODUCTS.PRODUCT_NAME, CATEGORY.CAT_ID, CATEGORY.CATEGORIES
FROM CLIENTS, PRODUCTS, CATEGORY
WHERE =
CLIENTS.CLIENT_NAME=3D'#session.client#'


I have only one record in the database right now for =
testing. so there is only one client. But this query keeps pull out the =
one client as two different clients.

I can't figure it out.


Shawn Regan




--_=_NextPart_001_01BFB452.F8791E40--

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

RE: Access function in SQL Server

[Olive, Christopher M Mr USACHPPM]

try SUBSTR with the same parameters.
 (if not that, try MIDSTR)

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 30, 2000 4:10 AM
To: CF-Talk
Subject: Access function in SQL Server



I am moving a site from an Access DB to SQL Server 7.0 and have run into a
function that was being used that is not supported in SQL Server 7.0  The
function is: InStr([start, ]string1, string2[, compare])  Is there a new
name for this function in SQL Server?

--Aaron


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

RE: Directory Security

[Olive, Christopher M Mr USACHPPM]

i would so stipulate.

perhaps i should have said "in my experience with my site, the hit is
negligible."

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 27, 2000 11:15 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Directory Security


> there is a performance hit.  in my experience, it's negligible.

It's negligible except in high-load/high-availability scenarios, where the
CF request queueing bottleneck is a serious performance issue.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


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

RE: Using NT Profile

[Olive, Christopher M Mr USACHPPM]

if the company network is NT, you can turn off "Allow Anonymous" in IIS and
rely on REMOTE_USER (i think) to get the username.  however, if you need
their password, you're SOL.  MS has already said that that piece of
information is not available "scriptly".

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: John Stanley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 27, 2000 10:52 AM
To: [EMAIL PROTECTED]
Subject: Using NT Profile


 I am developing the company Intranet, and would like
it to automatically check to see if the User is logged
into the Network. My question is how can I reference
the current NT profile on the client machine, and then
use that value throughout the site to personalize it
(probably with a cookie). 

  Currently I have the user logging in to the site,
and then assigning the username as a cookie variable
to be later referenced. I want to bypass the hole
seperate login and just use the NT information that
already exists.

  Thanks in advance.

  John

__
Do You Yahoo!?
Talk to your friends online and get email alerts with Yahoo! Messenger.
http://im.yahoo.com/

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

RE: Storing Client Variables

[Olive, Christopher M Mr USACHPPM]

did you actually declare a CLIENT.variablename?

it doesn't store anything until you ask it to, i believe.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 8:48 PM
To: '[EMAIL PROTECTED]'
Subject: Storing Client Variables



I'm experimenting with storing client variables in a datasource. I thought I
had a pretty good handle on how to do it, but it's not working out the way I
expected.

I'm running this sample app off the localhost (CF single user version).

Here's my code on the Application.cfm page:



I've got the datasource configured.  

It's an Access db.

The first time I ran the app, the new tables were automatically created, but
no values got stored in them.  I went through a deleted all of my localhost
cookies and tried hitting the sample app again.  New cookies were set but
nothing was stored in the datasource.  I've tried this a couple of times.

What am I missing?

H.


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

RE: Directory Security

[Olive, Christopher M Mr USACHPPM]

there is a performance hit.  in my experience, it's negligible.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 5:53 PM
To: [EMAIL PROTECTED]
Subject: RE: Directory Security


To me, when they told me that, I interpreted it as if I place a support call
with them and I am routing all htm or html files to the CF dll, they may
limit their effort in helping to resolve the support call. (Again, my
Interpretation)

This was during the 2.X days about 3 1/2 years ago, and I did not see much
point to doing it that way. I inherited a project from a consultant (my
first CF exposure), and just changed the extensions to .cfm where it was
necessary. Also, I think somebody else mentioned a performance hit routing
all page requests through CF.

Dan

-Original Message-----
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 3:10 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Directory Security


whoops.  my bad, nick.  i meant to mention that.  i've been in 6 hours of
meeting stoday, i'm a tad brain dead.

and dan, what does that mean?  there's nothing for allaire to support, it's
an IIS thing, not CF.  not that i think you're lying, but i must say, i'm a
bit confused as to why allaire would weigh in on this issue.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 1:49 PM
To: [EMAIL PROTECTED]
Subject: RE: Directory Security


I have also been told by Allaire that they do not support this, for what it
is worth.

Dan

-Original Message-
From: Nick Call [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 11:33 AM
To: [EMAIL PROTECTED]
Subject: Re: Directory Security


Keep in mind that this may cause a performance issue.  Setting .htm files to
read through the CF .dll will cause EVERY .htm request on your site to route
through the CF Server, slowing it down a bit.  It your traffic is high
enough, you may notice a difference.  Otherwise, continue and ignore my
babbling.

Good Luck!
Nick Call
[EMAIL PROTECTED]
http://www.accessutah.com


----- Original Message -
From: "Olive, Christopher M Mr USACHPPM"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 26, 2000 9:36 AM
Subject: RE: Directory Security


> if you're the website admin (have access to the IIS MMC), you can go the
> properties of your web tsite ->home directory -> Configuration (under
> application settings) and add
> .htm mapped to \bin\iscf.dll
>
> that'll do it.
>
> Chris Olive
> DOHRS Website Administrator
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Jeff Bartlett [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 12:45 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Directory Security
>
>
> How would one go about having HTML requests go throught the CF dll?
>
> Jeff
>
> > -Original Message-
> > From: Olive, Christopher M Mr USACHPPM
> > [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 25, 2000 10:27 AM
> > To: '[EMAIL PROTECTED]'
> > Subject: RE: Directory Security
> >
> > one possible way is to feed all HTML requests through the CF dll.  that
> > will
> > invoke application.cfm for HTM files as well as CFM files.
> >
> > Chris Olive
> > DOHRS Website Administrator
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > From: Wey Hueymeei [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 25, 2000 10:08 AM
> > To: [EMAIL PROTECTED]
> > Subject: Directory Security
> >
> >
> >
> > Hello,
> >
> > We have a security system built in application.cfm, which disallow users
> > to
> > access our site without providing valid username and password.
> > ie. when a user put URL on the location bar, if he has not logged in, he
> > would be redirected to the login page first before seeing the actual
page.
> >
> > But we just have a security problem with the system:  There is a
directory
> > for users to upload files. If the file is not in CFM format, it seems
like
> > that the application.cfm cannot do security check. Therefore, if the
> > person
> > knows the URL, he could see the page without logging into the system.
> >
> > Could anybody help?
> >
> > thanks in advance,
> >
> > Hueymeei
> >
> >
>
> --
> > --
> > --
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubsc

RE: Directory Security

[Olive, Christopher M Mr USACHPPM]

whoops.  my bad, nick.  i meant to mention that.  i've been in 6 hours of
meeting stoday, i'm a tad brain dead.

and dan, what does that mean?  there's nothing for allaire to support, it's
an IIS thing, not CF.  not that i think you're lying, but i must say, i'm a
bit confused as to why allaire would weigh in on this issue.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 1:49 PM
To: [EMAIL PROTECTED]
Subject: RE: Directory Security


I have also been told by Allaire that they do not support this, for what it
is worth.

Dan

-Original Message-
From: Nick Call [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 11:33 AM
To: [EMAIL PROTECTED]
Subject: Re: Directory Security


Keep in mind that this may cause a performance issue.  Setting .htm files to
read through the CF .dll will cause EVERY .htm request on your site to route
through the CF Server, slowing it down a bit.  It your traffic is high
enough, you may notice a difference.  Otherwise, continue and ignore my
babbling.

Good Luck!
Nick Call
[EMAIL PROTECTED]
http://www.accessutah.com


- Original Message -----
From: "Olive, Christopher M Mr USACHPPM"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 26, 2000 9:36 AM
Subject: RE: Directory Security


> if you're the website admin (have access to the IIS MMC), you can go the
> properties of your web tsite ->home directory -> Configuration (under
> application settings) and add
> .htm mapped to \bin\iscf.dll
>
> that'll do it.
>
> Chris Olive
> DOHRS Website Administrator
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Jeff Bartlett [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 12:45 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Directory Security
>
>
> How would one go about having HTML requests go throught the CF dll?
>
> Jeff
>
> > -Original Message-
> > From: Olive, Christopher M Mr USACHPPM
> > [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 25, 2000 10:27 AM
> > To: '[EMAIL PROTECTED]'
> > Subject: RE: Directory Security
> >
> > one possible way is to feed all HTML requests through the CF dll.  that
> > will
> > invoke application.cfm for HTM files as well as CFM files.
> >
> > Chris Olive
> > DOHRS Website Administrator
> > [EMAIL PROTECTED]
> >
> >
> > -Original Message-
> > From: Wey Hueymeei [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 25, 2000 10:08 AM
> > To: [EMAIL PROTECTED]
> > Subject: Directory Security
> >
> >
> >
> > Hello,
> >
> > We have a security system built in application.cfm, which disallow users
> > to
> > access our site without providing valid username and password.
> > ie. when a user put URL on the location bar, if he has not logged in, he
> > would be redirected to the login page first before seeing the actual
page.
> >
> > But we just have a security problem with the system:  There is a
directory
> > for users to upload files. If the file is not in CFM format, it seems
like
> > that the application.cfm cannot do security check. Therefore, if the
> > person
> > knows the URL, he could see the page without logging into the system.
> >
> > Could anybody help?
> >
> > thanks in advance,
> >
> > Hueymeei
> >
> >
>
> --
> > --
> > --
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
>
> --
> > 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe 

RE: What happened to this list?

[Olive, Christopher M Mr USACHPPM]

they doin' ok.  everything, she gonna be alright now.

Chris "the Knife" Olive

-Original Message-
From: Sharon DiOrio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 6:26 PM
To: [EMAIL PROTECTED]; '[EMAIL PROTECTED]'
Subject: RE: What happened to this list?


I just got one thing to say, "How's the family?"

Sharon "the Hammer" DiOrio

At 02:40 PM 4/24/2000 -0400, Olive, Christopher M Mr USACHPPM wrote:
>hey, who was asking for a Sicilian CF developer?  are you insulting my
>people? 
>
>:)
>
>Chris Olive
>DOHRS Website Administrator
>[EMAIL PROTECTED]


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

RE: Restart of PCAny

[Olive, Christopher M Mr USACHPPM]

if you have server manager installed on another workstation/server, and
admin rights to the machine with PC anywhere, you can go to that machine
with server manager, select Services, and stop/restart PC Anywhere.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: cftalk [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 26, 2000 6:31 AM
To: [EMAIL PROTECTED]
Subject: OT: Restart of PCAny


Is it possible to restart PCAny remotely ?
S.O. told me it is with NT 4 Server ?
If even also with NT 4 Workstation ?

Uwe

SD Solutions
Uwe Degenhardt
Fon: 08122/903791
Fax: 08122/903792
Web: www.sdsolutions.de
E-Mail: [EMAIL PROTECTED] 





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

RE: Directory Security

[Olive, Christopher M Mr USACHPPM]

if you're the website admin (have access to the IIS MMC), you can go the
properties of your web tsite ->home directory -> Configuration (under
application settings) and add 
.htm mapped to \bin\iscf.dll

that'll do it.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Jeff Bartlett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 12:45 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Directory Security


How would one go about having HTML requests go throught the CF dll?

Jeff

> -Original Message-----
> From: Olive, Christopher M Mr USACHPPM
> [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 10:27 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  RE: Directory Security
> 
> one possible way is to feed all HTML requests through the CF dll.  that
> will
> invoke application.cfm for HTM files as well as CFM files.
> 
> Chris Olive
> DOHRS Website Administrator
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: Wey Hueymeei [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 10:08 AM
> To: [EMAIL PROTECTED]
> Subject: Directory Security
> 
> 
> 
> Hello,
> 
> We have a security system built in application.cfm, which disallow users
> to
> access our site without providing valid username and password.
> ie. when a user put URL on the location bar, if he has not logged in, he
> would be redirected to the login page first before seeing the actual page.
> 
> But we just have a security problem with the system:  There is a directory
> for users to upload files. If the file is not in CFM format, it seems like
> that the application.cfm cannot do security check. Therefore, if the
> person
> knows the URL, he could see the page without logging into the system.
> 
> Could anybody help?
> 
> thanks in advance,
> 
> Hueymeei
> 
> 
> --
> --
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.

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

RE: Best way to learn CF?

[Olive, Christopher M Mr USACHPPM]

you just did.

:)

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Paige Chandler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 4:11 PM
To: [EMAIL PROTECTED]
Subject: Re: Best way to learn CF?


Hello Dave Wilson,

I am just beginning to use CF and have been watching this web site for a
while. I see your name here often.  Could I impose on you to explain how I
might enter a new thread - ask a question of others that log on to this
site?  TIA.

Regards,

Paige Chandler
- Original Message -
From: Dave Wilson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 23, 2000 9:10 PM
Subject: Re: Best way to learn CF?


> Patrick,
>
> Welcome to the CF world.
>
> OK, best way to learn? I don't really think there is a "best" way to learn
> as such, as each individual has different learning styles and different
> backgrounds etc.
>
> However, I learned pretty quickly in the beginning by looking closely at
the
> Tack2 Store (example application included with CFServer) source code and
> modifying it to create the kind of storefront I wanted. This took me about
> 2-3 weeks, but fortunately for me I'd had extensive experience with
> O'reilly's webstore (perl script) beforehand and knew exactly what I was
> looking to achieve before I set out.
>
> I find the CFML Language reference is an invaluable learning tool, along
> with this mailing list and the allaire forums, plus the countless
tutorials
> found on CF related web sites.
>
> If you don't have a copy of the language reference, you can get it at the
> following link:
>
> http://www.allaire.com/documents/cf45docs/acrobatdocs/45langref.pdf
>
> Other good books include Ben Forta's "Web Application Construction Kit"
and
> "Application development (Advanced)", both readily vailable from Amazon.
>
> HTH
>
> Dave Wilson
> Internet Technology Manager,
> BizNet Solutions
>
> Co-Founder CFUG Ireland
> http://www.cfug.ie
>
> 224, Lisburn Road
> Belfast BT9 6GE
>
> Tel: 02890 225 776
> Fax: 02890 223 223
> web: http://www.biznet-solutions.com
>
> email: [EMAIL PROTECTED]
> - Original Message -
> From: Patrick <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, March 23, 2000 2:44 PM
> Subject: Best way to learn CF?
>
>
> > Hi,
> >
> > Any recommendations to the best way to learn CF? I'm new to it, and was
> wondering if I could get by just reading a book or two on the subject. If
> so, what books would you highly
> > recommend?
> >
> > Thanks,
> > Patrick
> >
>
> --
> 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --

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


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

RE: The difference between client and cookie variables

[Olive, Christopher M Mr USACHPPM]

you'll run into problems if you decide to store ALL of the information as
cookies.  the thread that was on here before on the subject seemed to
resolve to a limit of 20 cookies per domain on any given browser.  client
variables are stored on YOUR end, and the only limits on size/number are
those that you impose.  the keys (CFID and CFTOKEN) are the only things
stored as cookies on the client browser.  they are the unique keys to the
DB, and let you get around the browser limit on cookies.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Juan Manuel Tapiola [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 2:57 PM
To: [EMAIL PROTECTED]
Subject: The difference between client and cookie variables


I'm creating an application that will adapt to the client.  So the first
time I create a client.user that will guide to create the next time these
adaptive content.  Now, I was wondering what's the difference between
creating:  and a
client variable that stores the username as a cookie.

Thank you in advance,

Manuel Tapiola


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

RE: Directory Security

[Olive, Christopher M Mr USACHPPM]

one possible way is to feed all HTML requests through the CF dll.  that will
invoke application.cfm for HTM files as well as CFM files.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Wey Hueymeei [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 10:08 AM
To: [EMAIL PROTECTED]
Subject: Directory Security



Hello,

We have a security system built in application.cfm, which disallow users to
access our site without providing valid username and password.
ie. when a user put URL on the location bar, if he has not logged in, he
would be redirected to the login page first before seeing the actual page.

But we just have a security problem with the system:  There is a directory
for users to upload files. If the file is not in CFM format, it seems like
that the application.cfm cannot do security check. Therefore, if the person
knows the URL, he could see the page without logging into the system.

Could anybody help?

thanks in advance,

Hueymeei



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

RE: What happened to this list?

[Olive, Christopher M Mr USACHPPM]

that was mostly a TIC response. i didn't REALLY take offense. while it is
annoying, if the thread of "who's offended?" wasn't running, i wouldn't have
bothered to reply.

:)


this post contains nearly 100% humour.  no animals were harmed in the making
of this message.


Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 9:51 AM
To: [EMAIL PROTECTED]
Subject: RE: What happened to this list?



> i'd object to the "early 20s" bit.  why does being young 
> necessarily mean
> "unscrupulous"?  i'm 24, (just three weeks ago) and i'm 
> afraid that i must
> disagree with you on that particular point.
> 
> Chris Olive
> DOHRS Website Administrator
> [EMAIL PROTECTED]

Lets stop. I'm really wishing I had never mentioned it.

Most of us, I'd say 99%, are good hard working coders, just trying to make a
living with Cold Fusion. Lets just leave it at that!

Marcus·!S÷¬?Ûiÿü0Áá«¢êlr?¿-+-ýÇíjY¡Iì¹»®&Þ¾+"¶m§ÿðÃhºÇ¨}û¬S?Ü¢oâ×±qù¬?
×>j°SËn?-+-³÷µ©d¢»Ö¦zˁëhqûZ-Jު笶.±ê~ë"¢w(>­?éì¹»®&ÞS{ayº
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: What happened to this list?

[Olive, Christopher M Mr USACHPPM]

i'd object to the "early 20s" bit.  why does being young necessarily mean
"unscrupulous"?  i'm 24, (just three weeks ago) and i'm afraid that i must
disagree with you on that particular point.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 3:06 PM
To: [EMAIL PROTECTED]
Subject: RE: What happened to this list?


Maybe I've been watching too much of 'The Profiler" on TV but here is my
profile of the offender...

Sex: Male
Age: Early 20's
CF Skills: Competent beginner skills
Self Opinion: Thinks he knows alot more than he does
Saving Grace: Knows the lingo to get in the door but struggles to produce
History: Has had several short lived CF jobs. Neither reliable or
dependable. Prefers the fast buck to building quality relationships. Will
take shortcuts and 'cheat' to get a job done quickly. ALWAYS pads his
billable time.
Outlook: Will make money early on with short-lived contracts but will
eventually build a poor reputation for himself that will catch up with him.







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

RE: What happened to this list?

[Olive, Christopher M Mr USACHPPM]

hey, who was asking for a Sicilian CF developer?  are you insulting my
people? 

:)

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Brandon Whitaker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 12:59 PM
To: [EMAIL PROTECTED]
Subject: Re: What happened to this list?


>This is a good idea, as long as people don't get carried away.  People tend
>abuse such power, a la, Salem Witch Hunt Trials.  My analogy is a bit
>extreme maybe, but overall you have a good idea.

Given the litigious society we live in at the moment, I don't know whether
anyone would want to open themselves up to a libel/slander/defamation of
character suit...of course it's hard to see how anyone could have the nerve
to press a suit like that, but then again weirder things happen in the
courts every day.  And anyone who was weasel enough to have done this in the
first place certainly has low enough moral standards to whine to the nearest
attorney (who will undoubtably drool at the prospect of the media frenzy to
be had in an INTERNET LAWSUIT..)

Now on the other hand, if anyone knows any Sicilians of the sort favored by
Mario Puzo, perhaps a more appropriate & expedient punishment could be found
for the offender...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore



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

RE: A CF Studio question

[Olive, Christopher M Mr USACHPPM]

Options, Settings, HTML, uncheck "lowercase all inserted tags".

at least in studio 4.01.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 11:59 AM
To: [EMAIL PROTECTED]
Subject: A CF Studio question


Hi,

How can I configure cf studio so that when it autocompletes tags, it does so
using uppercase letters?

Sincerely,
---
Hubert Earl
ICQ#:  16199853

I develop & maintain web sites internationally.  I also build web
applications using CGI scripts written in Perl.  I accept subcontracting
work.

**Personal web site:  http://www.geocities.com/SiliconValley/Peaks/8702/
(please remember to view this with a sense of humour!)

**Business web page:  http://home.talkcity.com/MigrationPath/hearl/



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

RE: Problem with Oracle Procedures and OUTPUT parameters

[Olive, Christopher M Mr USACHPPM]

i just went through this whole Charlie Foxtrot of getting CF to play with
Oracle SPs.  i remember reading the Allarie KB, and somewhere it said that
you can't use DBVARNAME with Oracle SPs.  it breaks them.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Raftree, Mat [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 12:41 PM
To: '[EMAIL PROTECTED]'
Subject: Problem with Oracle Procedures and OUTPUT parameters


Hello All,

I am having trouble getting Oracle procedures to return OUTPUT
parameters.

I have the following code:




This is exactly as the documentation  says to set it up:

It is an output parameter (OUT) of type varchar.

I then hand in my variable from ColdFusion and map it to the parameter
name from the stored procedure (in this case it is: 'resulttype')

I have seen this work when using SQLServer with the DBVARNAME looking
like '@Variable1', but oracle does not use the @ sign with variables.  

Any help would be greatly appreciated.  Please reply to me directly if
you like.

Thanks,

Mathew Raftree
Senior Consultant
Breakaway Solutions, Inc.
50 Rowes Wharf, Boston, MA 02110
617.960.3400 - Office
617.834.0647 - Cell
617.960.3434 - Fax
www.breakaway.com
Get there first. 

"If you look at the history of innovation, you'll see one proven recipe
for breakthroughs: Take a small,  intensely focused team and impose an
unreasonable time frame on it." -- Alan Naumann

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

RE: Cookies disappear

[Olive, Christopher M Mr USACHPPM]

it actually depends on your browser.  i think it was IE 4.x = 25, NS 4.x =
20.  i heard that IE was increasing the limit in 5.x, but i have no idea
what it is now.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 11:02 AM
To: [EMAIL PROTECTED]
Subject: Re: Cookies disappear


I was always led to believe the limit was 15 per domain, does anyone have a
definitive answer on this as I have never needed more than 2 so I have never
tested it?

--
James Smith - [EMAIL PROTECTED]
http://ask-ted.com - Thiele Euronet Directories Limited
=
ICMP: The protocol that goes PING!


- Original Message -
From: Lon Lentz <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 24, 2000 2:10 PM
Subject: RE: Cookies disappear


> >
> > From: cfm [mailto:[EMAIL PROTECTED]]
> >
> > I have created a dynamic site where I tried to save a lot of the dynamic
> information in cookies.
> > At any 1 time there could be about 25 cookies.  None of them are very
> large, each holding a max of
> > about 45 bytes.  This dynamic information is stuff like a cookie for the
> main font color,  a cookie
> > for the main domain url, etc.  These cookies are pulled up on every
page.
>
>
>
>   Cookies are limited to 20 per domain. The 21st cookie will cause the
first
> one to be purged. I
>  believe that the max memory size for all of your site's cookies is 4k.
>
>
>
> Lon Lentz
> Applications Developer - GetLists.Com
> DataWarehousing and List Sales - Market your lists on the Net!
> [EMAIL PROTECTED]
> 941-541-9000 Ext. 210
>
> --

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


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

RE: Question about Netscape

[Olive, Christopher M Mr USACHPPM]

without seeing your code, it's hard to say, but NS is VERY picky about
proper HTML.  i'd be willing to bet that you need "'s around your values.
like this.



Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 24, 2000 10:42 AM
To: [EMAIL PROTECTED]
Subject: Question about Netscape




I am doing a form to query information from a database (access).  Having it
return information in text boxes.  Well it works just fine in IE but, when
it goes to display the returned information in netscape.  It does not show
up, but in the view source it is there.  Just not showing up.  Any ideas
what the problem could be other than netscape has went down hill.  I am
using 4.7 netscape.



Tony Smith
   IBM Learning Services
   3100 Windy Hill Road
   Marietta GA   30339
   770-835-3155
   t/l 596-3155



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

RE: while loop

[Olive, Christopher M Mr USACHPPM]

it's a conditional loop.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: mirza baig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 20, 2000 12:34 PM
To: [EMAIL PROTECTED]
Subject: while loop


If you want to implement a while loop in CF, how do
you do it?

Thank you.
Mirza

__
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com

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

RE: Ordering by TEXT

[Olive, Christopher M Mr USACHPPM]

i *think* it's what you typed between the ??'s.

try that out.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]

-Original Message-
From: Ryan Shrout [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 9:34 PM
To: [EMAIL PROTECTED]
Subject: Re: Ordering by TEXT 


Sorry to bother again, but can you type an example one with the substring?


SELECT ID, Name, Title  (Title is in a TEXT format)
FROM MyTable
ORDER BY ??substring(Title, 1, 10)?? ASC


-Ryan Shrout
Power Gamerz; K7M.COM
[EMAIL PROTECTED]

- Original Message -----
From: "Olive, Christopher M Mr USACHPPM"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 19, 2000 2:55 PM
Subject: RE: Ordering by TEXT


> take a substring(1,10) of the text field, alias it, and order by that.
>
> Chris Olive
> DOHRS Website Administrator
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Ryan Shrout [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 19, 2000 2:46 PM
> To: [EMAIL PROTECTED]
> Subject: Ordering by TEXT
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0061_01BFAA0E.6D671740
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I know that there is no simple way to accomplish this, but I need to be =
> able to sort the order of a query by the first 10 letters of a very long =
> text field (this database uses MS SQL 7).  Is there anyway to do it?
>
> -Ryan Shrout
> Power Gamerz; K7M.COM
> [EMAIL PROTECTED]
>
> --=_NextPart_000_0061_01BFAA0E.6D671740
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> I know that there is no simple way to =
> accomplish=20
> this, but I need to be able to sort the order of a query by the first 10 =
> letters=20
> of a very long text field (this database uses MS SQL 7).  Is there =
> anyway=20
> to do it?
>  
> -Ryan ShroutPower Gamerz; =
> K7M.COM href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]
>
> --=_NextPart_000_0061_01BFAA0E.6D671740--
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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


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

RE: Ordering by TEXT

[Olive, Christopher M Mr USACHPPM]

take a substring(1,10) of the text field, alias it, and order by that.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Ryan Shrout [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 2:46 PM
To: [EMAIL PROTECTED]
Subject: Ordering by TEXT 


This is a multi-part message in MIME format.

--=_NextPart_000_0061_01BFAA0E.6D671740
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I know that there is no simple way to accomplish this, but I need to be =
able to sort the order of a query by the first 10 letters of a very long =
text field (this database uses MS SQL 7).  Is there anyway to do it?

-Ryan Shrout
Power Gamerz; K7M.COM
[EMAIL PROTECTED]

--=_NextPart_000_0061_01BFAA0E.6D671740
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I know that there is no simple way to =
accomplish=20
this, but I need to be able to sort the order of a query by the first 10 =
letters=20
of a very long text field (this database uses MS SQL 7).  Is there =
anyway=20
to do it?
 
-Ryan ShroutPower Gamerz; =
K7M.COMmailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]

--=_NextPart_000_0061_01BFAA0E.6D671740--


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

RE: SQL.COUNT question

[Olive, Christopher M Mr USACHPPM]

you need to alias the field.

  
  select count(*) as fred
  from customer
  where CustomerName='My_Name'
  

  

  #fred#

  

-Original Message-
From: Alex Puriche [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 11:54 AM
To: [EMAIL PROTECTED]
Subject: SQL.COUNT question


cf-talk,

  
  select count(*)
  from customer
  where CustomerName='My_Name'
  

  

  #What I need to put here???#

  

  

-- 
 Regards,
 Alex  mailto:[EMAIL PROTECTED]

Certified HTML Programmer,
Java Script Programmer and
High IT Aptitude Specialist.
http://www.brainbench.com/transcript.jsp?pid=145368

Certified Cold Fusion 4.1 Programmer.
http://www.ecertifications.com/

Permanent FAQ Team player.
http://faq.worldrecovery.com/

Permanent MTeam player.
http://members.tripod.com/mteam1/



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

RE: CFM templates not accessible to clients

[Olive, Christopher M Mr USACHPPM]

i'm sorry, i think i misunderstood the problem.  you mean that NT is
refusing access to the user?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Jeffrey G. Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 10:59 AM
To: [EMAIL PROTECTED]
Subject: Re: CFM templates not accessible to clients


The ACL for the entire /cimnetcf/ directory tree includes 'Authenticated 
Users' with Read (RX/RX) permissions.

Also, the ISCF.DLL is mapped to the CFM extension, and is marked as a
'Script 
Engine' in the MMC. 'Joe User' still can't access CFM templates.

JGB

-Original Message-
CFM files must have executable access available to Joe User, unless you
specify the DLL mapping as a "scripting engine" in the IIS MMC.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Jeffrey G. Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 18, 2000 4:33 PM
To: [EMAIL PROTECTED]
Subject: CFM templates not accessible to clients


Gentlebeings...

Bear with me, please, as I am somewhat new to Coldfusion and NT
administration.

I began development of our intranet site in VBScript on IIS 4.0, and then we

switched to CF. The VBScript site, named cimnet2d, is still online, and all 
users can view it. The new site, named cimnetcf, is totally CFM-based. 
Admin-type users can see it, but not non-admin, ordinary users (hereafter 
referred to as 'Joe User').

The directory trees for each site have exactly the same ACL permissions set 
throughout, and the IIS 4.0 settings are the same. Both directory trees are 
configured for Win NT 4.0 NTLM authentication (no anonymous or basic), and 
have been given Read access throughout to members of the Authenticated Users

group. I finally realized that Coldfusion itself might have something to do 
with the access problem, and tried an experiment.

A very simple file, containing only HTML (no VBScript or CFM code), named 
'simple.htm' was placed in the cimnet2d home directory ( which has always 
been accessible to Joe User). Log in as Joe User and access it with IE 4.0. 
Result: access good. Rename it to simple.asp: access good. BUT, rename to 
simple.cfm: no access! Same results in the cimnetcf home directory. The 
problem, thus, lies not in the directory permissions for the site or the IIS

authentication settings, but in access to some Coldfusion resource.

The ACL for the \programs\coldfusion directory tree on the server contains 
only SYSTEM and the Domain Admins group. Adding a user to the Doman Admins 
group gives him access to cimnetcf; not practical for security reasons, 
obviously. Windows NT is running the CF Server under the SYSTEM user.

What resource(s) must I make accessible, and to whom, for the CF site to
work 
for all authenticated users? How, in general, can I effectively integrate CF

with IIS/NT 4.0 security?

Many thanks...

JGB

===
Jeffrey G. Brown Intranet Webmaster
Milacron, Inc. Voice: 513-841-8655 Fax: 513-841-7345


===
Jeffrey G. Brown Intranet Webmaster
Milacron, Inc.  Voice: 513-841-8655   Fax: 513-841-7345

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

RE: Question on FuseBox model ::: ? :::

[Olive, Christopher M Mr USACHPPM]

i'm afraind i'd have to agree.  i hear so much about the development model,
but the documentation on www.fusebox.org is practically unintelligible from
a development standpoint.  i've read it a few times, too.  

don't get me wrong.
a) i understand the PRINCIPLE of fusebox.  it's just the implementation
that's a little hazy to me.
b) mr. nelson is doing a HELL of a job.  designing an entire programming
methodology is a non-trivial task, and i heartily applaud any and all
efforts to standardize some coding.  as someone who has had to rip apart
some REALLY crappy code in the past, i very much understand a need for clear
methods (whether it be as simple as the One True Brace Style, up to and
including fusebox).

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]

(all offense reserved.)

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 8:32 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Question on FuseBox model ::: ? :::


> easiest thing to do would be to check out www.fusebox.org

No disrespect to Steve Nelson, but I can't make head nor tail of what he's
written.

Is there anything else out there on fusebox... I appreciate it's importance
and would like to know more.




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

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

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

RE: CFM templates not accessible to clients

[Olive, Christopher M Mr USACHPPM]

CFM files must have executable access available to Joe User, unless you
specify the DLL mapping as a "scripting engine" in the IIS MMC.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Jeffrey G. Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 18, 2000 4:33 PM
To: [EMAIL PROTECTED]
Subject: CFM templates not accessible to clients


Gentlebeings...

Bear with me, please, as I am somewhat new to Coldfusion and NT
administration.

I began development of our intranet site in VBScript on IIS 4.0, and then we

switched to CF. The VBScript site, named cimnet2d, is still online, and all 
users can view it. The new site, named cimnetcf, is totally CFM-based. 
Admin-type users can see it, but not non-admin, ordinary users (hereafter 
referred to as 'Joe User').

The directory trees for each site have exactly the same ACL permissions set 
throughout, and the IIS 4.0 settings are the same. Both directory trees are 
configured for Win NT 4.0 NTLM authentication (no anonymous or basic), and 
have been given Read access throughout to members of the Authenticated Users

group. I finally realized that Coldfusion itself might have something to do 
with the access problem, and tried an experiment.

A very simple file, containing only HTML (no VBScript or CFM code), named 
'simple.htm' was placed in the cimnet2d home directory ( which has always 
been accessible to Joe User). Log in as Joe User and access it with IE 4.0. 
Result: access good. Rename it to simple.asp: access good. BUT, rename to 
simple.cfm: no access! Same results in the cimnetcf home directory. The 
problem, thus, lies not in the directory permissions for the site or the IIS

authentication settings, but in access to some Coldfusion resource.

The ACL for the \programs\coldfusion directory tree on the server contains 
only SYSTEM and the Domain Admins group. Adding a user to the Doman Admins 
group gives him access to cimnetcf; not practical for security reasons, 
obviously. Windows NT is running the CF Server under the SYSTEM user.

What resource(s) must I make accessible, and to whom, for the CF site to
work 
for all authenticated users? How, in general, can I effectively integrate CF

with IIS/NT 4.0 security?

Many thanks...

JGB

===
Jeffrey G. Brown Intranet Webmaster
Milacron, Inc.  Voice: 513-841-8655   Fax: 513-841-7345

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

RE: CFSWITCH expressions

[Olive, Christopher M Mr USACHPPM]

i don't see any problem.  in your switch, include cases you want to handle,
then put a default case for all others.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 18, 2000 6:51 AM
To: [EMAIL PROTECTED]
Subject: CFSWITCH expressions


Howdy all.

Question. Is it possible to write a complex expression, other than
expression = "#variable#"?

In other words, if I had:




Stuff here


Then how would I write a cfcase for value Greater Than 1?

And can you get even more complex, like using multiple variables in
the expression?

"this is #that# and theother is #somethingelse#"

Thanks.

Bud Schneehagen - Tropical Web Creations

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

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

RE: Oracle Stored Proc - Included Code...

[Olive, Christopher M Mr USACHPPM]

oh.  you can't use DB_VARNAME with a native driver.  i was reading up on
this matter in the KB.  someone mentioned this (in a Forum post, actually).

try removing the DBVARNAMe parameter to the SP.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Scott Rowe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 2:42 PM
To: [EMAIL PROTECTED]
Subject: Oracle Stored Proc - Included Code...


I've included my code this time. I'm sure it's something easy but I dont'
know what.

Thank you!

Scott Rowe

Oracle stored proc:

Create Procedure usercheck
 (UserID IN NUMBER, TimeLastVisit OUT VarChar2)
AS
 BEGIN
 --check for a user--
 Select To_Char(TimeLastVisit,'-mm-dd HH24:mi:ss')
 INTO TimeLastVisit
 FROM UsersLoggedIn
 WHERE UserID = UserID;
EXCEPTION
 When NO_DATA_FOUND
 THEN TimeLastVisit := 0;
END;









This is the error:

Oracle Error Code = 1036

ORA-01036: illegal variable name/number


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

RE: Oracle Stored Proc - In/Out Variable example

[Olive, Christopher M Mr USACHPPM]

http://www.allaire.com/handlers/index.cfm?ID=8353&Method=Full&PageCall=/supp
ort/index.cfm

this is the KB article on the process.  it's kind of vague, but i used it as
a template for my own SPs in Oracle 8i.  ( i just started working on them a
few days ago. )

BTW, the mysterious "maxrows" parameter to CFSTOREDPROC param is
undocumented.  it shows up in the error message if you have strict attribute
checking turned on in your CF Admin, but nowhere is it actually documented.


if you have any questions, feel free to contact me on/off list.  it's a
subject that i think Allaire should have given more thought to when they
released CF.  (of course, i think 4.5.1 fixes it.  but we ALL can't have the
latest version (at least that's what my manager says...)).

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Scott Rowe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 17, 2000 1:43 PM
To: CF-Talk
Subject: Oracle Stored Proc - In/Out Variable example


Does anyone have an example of an Oracle stored proc with in/out values and
the example Code to go with it. I keep getting errors such as illegal
variable name/number  OR wrong number or types of arguments in call to
'USERCHECK' ORA-06550: line 1, column 7: PL/SQL: Statement ignored. I'm
stuck and I'm a novice with Oracle. Please help.

Scott



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

RE: CF is typeless, but...?

[Olive, Christopher M Mr USACHPPM]

either should be correct.  but this is such a simple example, try it out.
it's only a difference of two quotation marks.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 13, 2000 8:47 AM
To: [EMAIL PROTECTED]
Subject: Re: CF is typeless, but...?


so which would be correct...

If...


then...


or...



Steve


- Original Message -
From: "Olive, Christopher M Mr USACHPPM"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 13, 2000 8:40 AM
Subject: RE: CF is typeless, but...?


> it's neither.  as you said, CF is typeless.
>
> it only "becomes" a type when you do something to it.  CF puts off the
> typing secision until then.
>
> Chris Olive
> DOHRS Website Administrator
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Steve Reich [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 12, 2000 7:43 PM
> To: 
> Subject: CF is typeless, but...?
>
>
> Say I set a cookie
>
> 
>
> When I call the cookie, is the value a string or a number?
>
> Thanks,
> Steve
> ~~
> "640K ought to be enough for anybody!"
>
> -Bill Gates, 1981
> ~~
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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


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

RE: CF is typeless, but...?

[Olive, Christopher M Mr USACHPPM]

it's neither.  as you said, CF is typeless.

it only "becomes" a type when you do something to it.  CF puts off the
typing secision until then.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 7:43 PM
To: 
Subject: CF is typeless, but...?


Say I set a cookie



When I call the cookie, is the value a string or a number?

Thanks,
Steve
~~
"640K ought to be enough for anybody!"

-Bill Gates, 1981
~~


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

RE: Number comparing

[Olive, Christopher M Mr USACHPPM]

do a Fix(cprlookup.cpr_rating).  this will drop any decimal values.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]




-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 2:03 PM
To: [EMAIL PROTECTED]
Subject: Number comparing


When I run this:







I keep getting blue1stshad.gif for 8.5.

If the number is an 8, it gives it red2ndshad.gif. If the number is an 9, 
it gives it blue1stshad.gif.

The column for the SQL server is as follows:

Column Name DatatypeLength  Precision   Scale
CPR_Rating  decimal 9   18  0

Any suggestions?

Thank You
Jacob


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

RE: Mappings problem

[Olive, Christopher M Mr USACHPPM]

that looks right, kind of.

do you really have a directory called 209.344.22.151 on your D:\ drive?

you would use  (use
the beginning slash)

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: PC [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 1:34 PM
To: [EMAIL PROTECTED]
Subject: Mappings problem


I want to setp a mapping in CF ADMIN but am not clear from docs just how
this works.

I have the following:

LOGICAL PATH:  /rootmap/
DIRECTORY PATH:  D:\209.344.22.151\mysite\

3 questions:

1) is this looking right?
2) how do I reference this mapping in a CFINCLUDE?
3) Can I add to the end of this mapping in the CFINCLUDE

is it something like?



TIA




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

RE: Where am I? There MUST be a better way!

[Olive, Christopher M Mr USACHPPM]

so you have a string /MyApplication/Level1/Level2/index.cfm, and you want to
return /Level1/Level2/index.cfm?

use ListRest(/MyApplication/Level1/Level2/index.cfm, "/").

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]

-Original Message-
From: Nick & Loretta Pioch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 11:55 AM
To: [EMAIL PROTECTED]
Subject: Where am I? There MUST be a better way!


What is the best way to derive your subdirectory path?

For instance, the base of my application might be:
/MyApplication/index.cfm
where "MyApplication" is a mapping in CFAdministrator

Then I have some directory structure, such that one path might be:
/MyApplication/Level1/Level2/index.cfm

I want to know where I am (reconstruct only the subdirectory
path)...that is, I want to dynamically be able to generate:
/Level1/Level2

Currently, I'm doing this via lots of string manipulation, and it seems
much more painful than it ought to be.  What I currently have is:



{note...this takes off an extraneous character that
GetDirectoyrFromPath puts on}


And SESSION.RelativeDirectory is what I want.

Is there a better way?  There's GOT to be a better way!

And while I'm asking, could someone explain the  tag?  Would this
help me?

Thanks!
-- Loretta Pioch


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

RE: search results produce everything in the table...

[Olive, Christopher M Mr USACHPPM]

well, that's what you designed it to do.  what do you want your default no
criteria selected results to be?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Richard Hart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 12:23 PM
To: House of Fusion
Subject: search results produce everything in the table...


Hi,

I have a simple search form on which you can search on three criteria.
However when I type nothing in the form and hit submit it gives me
everything in
the table. I have tried to over-ride this to no effect. Can anyone point me
in the right direction?

Thanks,

Richard

..

In the results page I have something like:




   blahblah


AND FieldOne LIKE '%#Trim(Form.VariableOne)#%'



AND FieldTwo LIKE '%#Trim(Form.VariableTwo)#%'



AND FieldThree LIKE '%#Trim(Form.VariableThree)#%'


   balhblah





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

RE: REM out CF codes

[Olive, Christopher M Mr USACHPPM]

use a comment 



Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 9:43 AM
To: [EMAIL PROTECTED]
Subject: REM out CF codes


This is a multi-part message in MIME format.

--=_NextPart_000_00AB_01BFA3A2.C5C2F160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi!

Is there a way to temporarily REM out CF tags=20
so that the server doesn't execute them?



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








Hi!
 
Is there a way to temporarily REM out =
CF tags=20

so that the server doesn't execute=20
them?
 
 

--=_NextPart_000_00AB_01BFA3A2.C5C2F160--


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

RE: Am I unauthorized?

[Olive, Christopher M Mr USACHPPM]

do you have control of the webserver?  if so, check to make sure that user
"testing" has access.  the CFHTTP tag acts in that user's context, not
"mizra baig"'s.  (unless, of course, your user account is named
"testing"...)

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: mirza baig [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 7:56 PM
To: [EMAIL PROTECTED]
Subject: Am I unauthorized?


I have created a file which has  similar code to the
follwoing code:

http://www.testing.com/admin/Receipt.cfm" 
RESOLVEURL="YES" USERNAME="testing"
PASSWORD="TeStInG">












TESTING:#testing#


When I try to execute this file, I get an error which
looks like:
"
HTTP Error 401
401.1 Unauthorized: Logon Failed

This error indicates that the credentials passed to
the server do not match the credentials required to
log on to the server.

Please contact the Web server's administrator to
verify that you have permission to access the
requested resource."

I have administrative privilages on the system. I have
tried with and without the password. I have tried in
many different ways, but in vain. D

Can somebody PLEASE tell me how to tell the computer
that I am AUTHORIZED. It reminds me of  a joke where
the doctor said that the patient is dead and later the
patient started talking and everybody was saying that
the doctor said you are dead, so you are dead!

Help, Save me!

Mirza


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

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

RE: Cold Fusion - ASP Together

[Olive, Christopher M Mr USACHPPM]

i don't think he would want to pass a password as a URL parameter.

the CFHTTP tag looks fine to me.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Eddie Shipman [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 3:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Cold Fusion - ASP Together


Why not pass it as a URL parameter and rewrite your ASP to 
parse the URL?

https://secure.internetclearing.com/iccnet12/userinfo.asp?logon=#Logon#
"
resolveurl="yes">



>
>I am attempting to send information to an ASP page in the form of a
>[httpparam].  I know absolutely nothing about ASP and am still 
>learning Cold
>Fusion.  I am placing a piece of my code below.  Can anyone 
>tell me if there
>is anything different I have to do to send this info to an ASP page?
>
>url="https://secure.internetclearing.com/iccnet12/userinfo.asp"
>resolveurl="yes">
>
>   
>



This message has been scanned for viruses using Sophos.
The opinions stated in this message do not necessarily
represent the opinions of e-MDs, its management or staff.

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

RE: &

[Olive, Christopher M Mr USACHPPM]

you can't, not without a stored procedure.  

you might want to look into doing it in two s, wrapped in a
CFTRANSACTION.

IE,




INSERT username, password...



INSERT userdetails





this way if one blows up, the entire transaction gets rolled back, and you
avoid ugly data consistency problems.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Jim Taylor [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 9:52 AM
To: Cf-Talk@Houseoffusion. Com
Subject:  & 




I have 1 database on a mssql , 2 tables, i need to insert user_id and
password in dbo.usere and the user details in dbo.userdetails with one how
can i do this with one  &  . 


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

RE: One question about list parsing

[Olive, Christopher M Mr USACHPPM]

i would use somehting like this...





UPDATE customer
SET receiptNo = '#fred[bob-1]#'
WHERE Cust_Code = '#fred[bob]#'





that should do you.  of course, change variable names as you see fit. :)

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 03, 2000 3:05 PM
To: [EMAIL PROTECTED]
Subject: One question about list parsing


I have the following task to do:

I have a list that is like

1, abc,
747466464, jdj,
484848848, utd,

... and so on.

What I have to do is write a script that looks like:

update table customer
set receiptNo = '11'
where Cust_Code='abc'

update table customer
set receiptNo='747466464'
where Cust_Code='utd'

... and so on.

The list is a text file. Is there a way to parse this
list by saying that whenever it encounters ','(comma)
sign, goto where clause, then for the second ',' sign
goto the set clause.

What is the best way of parsing the file if there was
no comma. Supposing the list was like:

11 abc
7474664564 xyz

etc.

Is there a built in function in ColdFusion to parse
the list in this way.

Appreciate it.
A Bajaria

__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

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

RE: Load Testing

[Olive, Christopher M Mr USACHPPM]

a few weeks ago, i took the Allaire Performance Tuning course (taught by the
estimable Dave Watts...:).  i must say, i was heartily impressed with the
quality of Segue's tool.  my boss ordered it, (in fact, just called me to
say it's here).  

it pretty much does EVERYTHING except making coffee for you while the test
runs.  apart from some minor language issues (it was written by some
non-native english speakers, and there are a few quirky bits in the
docs/help), it's an EXCELLENT tool.

of course, don't use just my work.  it IS almost 20K for the package itself
(nevermind the "real simulated users" that you have to purchase/rent).

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Scott Rowe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 03, 2000 2:08 PM
To: CF-Talk
Subject: Load Testing


Can anyone recommend, tell experience with etc, load testing software such
as RSW E-suite, Segue SilkPerformer, and Mercury's LoadTest?



 ___

  Scott Rowe <[EMAIL PROTECTED]>
  Webmaster  <212.208.0644>
  Fenics Software  
 ___



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

RE: View->Source in IE

[Olive, Christopher M Mr USACHPPM]

you can have the client do a File->Save As.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 03, 2000 11:41 AM
To: [EMAIL PROTECTED]
Subject: View->Source in IE


The coldfusion server, after executing a request/file
, sends only pure html to the browser. Is there a way
to catch this pure html code and save it as a file?

Thanks>
Aslam 

__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

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

FW: Combining Cf and ASP in the same Template

[Olive, Christopher M Mr USACHPPM]

no, it is not possible.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 03, 2000 9:42 AM
To: [EMAIL PROTECTED]
Subject: Combining Cf and ASP in the same Template


Is it possible to combine Cf and ASP in the same template?  If so, are
there any "gotchas" I need to be aware of? 

Thanks,
Eric


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

RE: Smarter snippets ??

[Olive, Christopher M Mr USACHPPM]

where did you find the docs?  on allaire's site?  i keep meaning to read
them, but the time to peruse the Fine Manual has not come until now.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 02, 2000 4:20 AM
To: [EMAIL PROTECTED]
Subject: Re: Smarter snippets ??


---Reply to mail from Fred Sanders about Smarter snippets ??
> Do searches on homesite sites for info making scripts and custom buttons
to
> implement them.
> 
< doh!> Oops, I just downloaded the CFStudio PDF documentation on the
off-chance (probably have it at work on CD too) and right there in the black
and white it tells
me all about the scripting capabilities of CFStudio, and pretty good it
looks too, I think I should be able to put something togethor to do just
what I want. < /doh!>

On another note, anybody know if the manual `Using ColdFusion Studio' came
printed
with Studio 4.0 (I've only got an upgrade CD for 4.5) and I am missing it ?



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

RE: Advice requested on forms which generate email replies

[Olive, Christopher M Mr USACHPPM]

why not just CFMAIL them the data?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 31, 2000 6:47 PM
To: [EMAIL PROTECTED]
Subject: Advice requested on forms which generate email replies


This is a multi-part message in MIME format.

--=_NextPart_000_05FA_01BF9B41.8F003C00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I need to add an email capability to a form which I recently created, =
allowing the form to send a reply to anyone who filled it. The email =
reply would have the data which had been entered in the form, so that =
the recipient could verify that what had been entered into the database =
was what he/she had intended.

I'd appreciate some advice on how to do such a task.

Sincerely,
---
Hubert Earl
ICQ#:  16199853

I develop & maintain web sites internationally.  I also build web =
applications using CGI scripts written in Perl.  I accept subcontracting =
work.

**Personal web site:  http://www.geocities.com/SiliconValley/Peaks/8702/
(please remember to view this with a sense of humour!)

**Business web page:  http://home.talkcity.com/MigrationPath/hearl/

--=_NextPart_000_05FA_01BF9B41.8F003C00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi,
 
I need to add an email capability to a =
form which I=20
recently created, allowing the form to send a reply to anyone who filled =
it. The=20
email reply would have the data which had been entered in the form, so =
that the=20
recipient could verify that what had been entered into the database was =
what=20
he/she had intended.
 
I'd appreciate some advice on how to do =
such a=20
task.
 
Sincerely,
---Hubert EarlICQ#: =20
16199853
 
I develop & maintain web sites=20
internationally.  I also build web applications using CGI scripts =
written=20
in Perl.  I accept subcontracting work.
 
**Personal web site:  http://www.geocities.com/SiliconValley/Peaks/8702/">http://www.ge=
ocities.com/SiliconValley/Peaks/8702/(please=20
remember to view this with a sense of humour!)
 
**Business web page:  http://home.talkcity.com/MigrationPath/hearl/">http://home.talkci=
ty.com/MigrationPath/hearl/

--=_NextPart_000_05FA_01BF9B41.8F003C00--


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

RE: HTTPRequest - Log File "Access Denied" - SSL

[Olive, Christopher M Mr USACHPPM]

i know that you cannot schedule a task with an HTTPS url in CF4.01.  i don't
know if this was changed in 4.5.

however, i'm curious as to why you need SSL for a scheduled task.  the
information isn't going over any outside pipes.  that means that the request
and reply are merely between the DB and the CF machine.  therefore, unless
you have someone INSIDE your network that is listening, you'll be fine.  and
if that's the case, you have worse issues than just needing SSL.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: David Berger [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 31, 2000 2:15 PM
To: [EMAIL PROTECTED]
Subject: HTTPRequest - Log File "Access Denied" - SSL


I'm having difficultings getting the scheduled tasks to work now that we've 
gone to SSL (Windows 2000, ColdFusion4.5.1 rc 1).  The error log only writes

"access denied".  I'm on the correct port (443) and have tried various user 
names and passwords.  We are also using Certificate Server, and I think that

maybe the HTTPRequest is getting blocked.  Is there a way around this?

Thank you
__
Get Your Private, Free Email at http://www.hotmail.com


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

RE: blockfactor

[Olive, Christopher M Mr USACHPPM]

i'm afraid i don't understand your comment.

yes, it does have a range from 1..100.  it will give the correct record
count, as it DOES NOT have any effect on the number of records a query
actually returns in toto.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 4:39 PM
To: [EMAIL PROTECTED]
Subject: RE: blockfactor


according to cfdocs, it says it has a range limit of 1 to 100in my
queries it still gives correct recordcount where as if i use maxrows it does
not...

> -Original Message-
> From: Olive, Christopher M Mr. USACHPPM
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 30, 2000 3:01 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: blockfactor
>
>
> BLOCKFACTOR does not restrict the maximum number of rows returned
> as MAXROWS
> does.  it merely specifies that the DB is to send over
> BLOCKFACTOR number of
> rows at a time.  eg, if you have 1000 rows returned, and a BLOCKFACTOR of
> 100, the db will send all 1000 rows over the wire, in chunks of 100 rows.
>
> Chris Olive
> DOHRS Website Administrator
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 30, 2000 3:34 PM
> To: [EMAIL PROTECTED]
> Subject: blockfactor
>
>
> do any of you have experience in using it in your queries vs using maxrows
> in the cfquery statement?
>
> > -Original Message-
> > From: Eddie Shipman [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 30, 2000 2:00 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: CF4.5 doesn't support Win2000 file encryption? - answer
> >
> >
> > It should but are you logged in as administrator? The services
> > use the System account. I don't know how to impersonate that account
> > using a login...
> >
> > >So here is a question:
> > >CF is running under a service account - that has permissions across teh
> > >network.
> > >
> > >If the file in Question is encrypted under the Admin account -
> > >won't the
> > >system have access to it then???
> > >
> > >From: Eddie Shipman [mailto:[EMAIL PROTECTED]]
> > >
> > >But you can cause your service to run under a spceific security
> > >context. Basically, all services run using a service account unless
> > >you specify that you want them to run under a different one.
> > >
> > >Check with your NT Administrator on that one...You should be able to
> > >have the CF service "impersonate" another user to read those files.
> > >>
> > >>> Just a guess here as I haven't tried EFS on a server yet, but I
> > >>> would think
> > >>> that since files are encrypted by and can only be read by
> > >>the file owner
> > >>> (as I understand it) that the CF Server service would need to run
> > >>> under the
> > >>> context of the file owner - ie have the CF service login as
> > >>that user.
> > >>
> > >>thank you, someone that actually has constructive input to offer...
> > >>
> > >>you are correct. after i RTF-Win2000-M, i found the following:
> > >>
> > >
> >
> >
> >
> > **
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error please notify
> > the system manager.
> >
> > This footnote also confirms that this email message has been swept by
> > MIMEsweeper for the presence of computer viruses.
> >
> > www.mimesweeper.com
> > **
> > --
> > 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
> --
> --
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

RE: blockfactor

[Olive, Christopher M Mr USACHPPM]

BLOCKFACTOR does not restrict the maximum number of rows returned as MAXROWS
does.  it merely specifies that the DB is to send over BLOCKFACTOR number of
rows at a time.  eg, if you have 1000 rows returned, and a BLOCKFACTOR of
100, the db will send all 1000 rows over the wire, in chunks of 100 rows.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 30, 2000 3:34 PM
To: [EMAIL PROTECTED]
Subject: blockfactor


do any of you have experience in using it in your queries vs using maxrows
in the cfquery statement?

> -Original Message-
> From: Eddie Shipman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 30, 2000 2:00 PM
> To: [EMAIL PROTECTED]
> Subject: RE: CF4.5 doesn't support Win2000 file encryption? - answer
>
>
> It should but are you logged in as administrator? The services
> use the System account. I don't know how to impersonate that account
> using a login...
>
> >So here is a question:
> >CF is running under a service account - that has permissions across teh
> >network.
> >
> >If the file in Question is encrypted under the Admin account -
> >won't the
> >system have access to it then???
> >
> >From: Eddie Shipman [mailto:[EMAIL PROTECTED]]
> >
> >But you can cause your service to run under a spceific security
> >context. Basically, all services run using a service account unless
> >you specify that you want them to run under a different one.
> >
> >Check with your NT Administrator on that one...You should be able to
> >have the CF service "impersonate" another user to read those files.
> >>
> >>> Just a guess here as I haven't tried EFS on a server yet, but I
> >>> would think
> >>> that since files are encrypted by and can only be read by
> >>the file owner
> >>> (as I understand it) that the CF Server service would need to run
> >>> under the
> >>> context of the file owner - ie have the CF service login as
> >>that user.
> >>
> >>thank you, someone that actually has constructive input to offer...
> >>
> >>you are correct. after i RTF-Win2000-M, i found the following:
> >>
> >
>
>
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


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

RE: Has someone wrangled a way to get CF to print an HTML document?

[Olive, Christopher M Mr USACHPPM]

actually as a point of interest, IE 5.0 RC 2 has the print() method defined
in its javascript compiler.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Russ Michaels [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 5:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Has someone wrangled a way to get CF to print an HTML
document?


Netscape Navigator has a print method, one of the few times that Netscape 
turns out to be better than IE.
window.print()
with IE you have to use ActiveX, although I suspect IE5 probably has a 
built in method.

Russ



  Satachi Internet Development
--
 Tel/Fax: 0870 787 3610
 Mobile: 07050 648684
 http://www.satachi.com
 email: [EMAIL PROTECTED]

--
 To join the Satachi-news mailing list
 send a blank e-mail to
 [EMAIL PROTECTED]
 or visit satachi.listbot.com


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

RE: login application help requested

[Olive, Christopher M Mr USACHPPM]

it looks like you need to overhaul the thought process here.

what i do for the protected pages on my site is have a custom tag call at
the beginning of each protected page.  this is a simple check for a cookie i
have set (userid).  if it's not there, then in the tag i redirect them to
the login page, with the page they attempted to reach as a URL variable.

Thusly...







login form (username password)
hidden field with URL.loc in it.


check their login.
if valid, send them to FORM.loc.
if not, error message.

if you need more, let me know.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Chris Estes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 5:24 PM
To: '[EMAIL PROTECTED]'
Subject: login application help requested


I have a home page in which there are links both for public and private
pages. I want users with a password to be able to click on a private page
link, login, then be forwarded directly to that page. It is easy enough to
send them to a specific page, but I can't seem to "forward" them. This code
takes the user back to the login form.

The code I'm using is very simple and basic (which is probably the problem).
I've included it below. If anyone can help, I'd appreciate it. I've wasted
two days of my life working on this.


Application.cfm:
 










http://localhost/isri/login/formpage.cfm?dest=#cgi.path_info#"
addtoken="No">
  



 





Formpage.cfm:




Password:


 


Actionpage.cfm:

SELECT username, pwd
FROM login
WHERE username = '#Form.name#' AND pwd = '#form.password#'




Log In





 
 


alert("We're sorry, but we were unable to verify either your Name or
Password. Please try again.")
self.location = 'formpage.cfm'






Chris Estes
(202) 662-8536
[EMAIL PROTECTED]
http://www.isri.org
http://www.scrap.org


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

RE: CFTry Question

[Olive, Christopher M Mr USACHPPM]

it will just fall through the TRY/CATCH if it's successful.

eg:




The file could not be updated. File is locked or read only.



#Output success message here#

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 12:45 PM
To: CFTalk
Subject: CFTry Question


Hi all,

How do I return a success from CFTry?

I have wrapped cftry around a cfflile call to intercept error messages if
the file can not be updated but I want to return a success message if the
was no errors. Here is what I have:




The file could not be updated. File is locked or read only.



Duane Boudreau
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249
Fax: 603-594-0258
ICQ#: 18024374
Jobs: [EMAIL PROTECTED]


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