CFincludes and SQL Queries <-SIMPLE QUESTION! (update to last q)

[Michael She]

If I embed a SQL query inside a CFQUERY my variables don't get processed:

   
 
   


The query is:

Select Username
 From Users
Where Username = '#form.username#'


The variable #form.username# is not being processed.  Is this normal, or am 
I doing something wrong?

If I put the whole query inside the CFQuery tag (no include) it works fine.
-- 
Michael She
I m a g i n e   C o m m u n i c a t i o n s
Company E-mail: [EMAIL PROTECTED]
Personal E-mail: [EMAIL PROTECTED]
ICQ UIN: #243466
Personal Homepage: http://www.michaelshe.com (Under Construction)
Imagine Communications: http://www.imagineer.net
PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1

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

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

Re: CFSCHEDULER

[pan]

Why isn't your scheduled template checking a stored
variable to see if it should email you?

Example: query a db upon scheduled event entry to
see if and when last email sent. If time span since is
long enough you can reset var to "doMail". Many
ways to condition the value of the referenced stored
value. also makes it easy to turn off or turn on
other features inside the event.

Pan



- Original Message -
From: "Robert M. Saxon, Jr." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 14:06
Subject: CFSCHEDULER


> I have a task that runs once a minute to check if a web page is down. If it
> is, it emails me.  The problem is that I get an email once a minute as long
> as the page is down.  Is there a way to use CFSCHEDULE or some other method
> to stop/pause (not delete) a task defined in CF Administrator from a CF
> page so that it will stop emailing me until the page is restored?
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>

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

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

Re: file extensions

[David E. Crawford]

This is left over from the ancient past, when what we know and love as CFML
was called DBML, in CF 1.0-1.5.  Thus .dbm extensions, as well as ,
, , etc, which may or may not work in more modern versions
of CF, but were the core of the good old days.

DC

- Original Message -
From: "Anuj Gakhar" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 17:09
Subject: file extensions


> can we use .dbm as extension in cold fusion...
> i tested it and it worked.
> why so?
> what is dbm for?
> pl. answer these questions
>
> jimmy
>
>
> __
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>

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

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

Re: cfhttp

[Melissa Fraher]

CF4.01

Paul Mone wrote:

> what version CF?
>
> -Original Message-
> From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 17, 2000 3:51 PM
> To: CF-Talk
> Subject: cfhttp
>
> I am trying to use CFHTTP and CFHTTPPARAM to bypass a form and pass my
> own form variables directly to an action page.  On top of this, the
> action page is an ASP.
>
> I am receiving an error that I am unable to connect to the server.
>
> Does anyone have any advice on this?
>
> TIA,
>
> Melissa
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

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

Any good update/navigate/archive apps for large CF site?

[Paul Sinclair]

I'm putting together a fairly large CF site for an industry association.
There are currently several thousand pages within an existing site. These
will be moved to the new site. There will also be daily updates with
"breaking news" type stories as well as articles. The site needs to be
managed via a database so that "breaking news" stories are moved off the
site after predetermined times, with articles of longer durational interest
being maintained for longer periods and then moved to archive status.

I'm wondering if anyone has some type of database layout that can be used
for this type site that will allow for easy updating of the site as well as
for easy navigation throughout all. I haven't found any good tools in the
custom tag gallery but before I get too far into development I'd be
interested in anything that anyone else may have done in this type site.

Any suggestions will be appreciated.

Paul Sinclair

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

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

Re: scaleability of

[Jon Hall]

Seems to me that if this small subset of records has a unique identifier
that you could just limit the query using a standard WHERE statement. Just
adding a field to the db would be the easiest solution to only pulling the
set of records you need.

I think Shawn answered your question though and you didn't see it.
Use the Startrow statement in your cfquery, then pass a variable called
'page' that is incremented by 1 each time you view the next page or
subtracted by 1 when you go back a page.
This formula might get you on the right track.

page x maxrecordsperpage + 1 will always give you the Startrow variable for
your cfquery statement.

If your recordset is a static one that does not change much and you expect
high enough traffic to justify a little memory usage.You might want to think
about caching the entire query until something is changed.

jon

- Original Message -
From: "[BOXoFUSES] Michael Slatoff" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 6:10 PM
Subject: Re: scaleability of 


> This is what I'm trying to get away from. This is just outputting a subset
> of my entire recordset.
>
> If I've got a query that returns 125,000 records and only display 25 of
> them, it's a waste of the servers resources.
>
> Michael
>
> "Shawn McGehee" <[EMAIL PROTECTED]> wrote in message
> 015b01c050e0$044326e0$[EMAIL PROTECTED]">news:015b01c050e0$044326e0$[EMAIL PROTECTED]...
> > 
> > blah blah blah
> > ...
> > 
> >
> > --Shawn McGehee
> >
> > - Original Message -
> > From: "[BOXoFUSES] Michael Slatoff" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, November 17, 2000 2:16 PM
> > Subject: scaleability of 
> >
> >
> > > I'm working on an inventory management system for a small subset of
out
> > > product database (only about 3k records compared to about 125k
records).
> > > When returning the recordset, I want to break it up into bite sized
> > chunks.
> > > Only problem is, using , the
query
> is
> > > still returning about 3k records and only displaying 25. If this thing
> > ever
> > > gets to the point where I need to keep track of the entire product
list
> > > (125k records), this is going to bog down things.
> > >
> > > Is there a way in SQL to set a start row for a query? I know I can use
> > 'set
> > > rowcount 25' to only get 25 records, but I then need to start again at
> row
> > > 26.
> > >
> > > Am I looking in the wrong place? Is there a different way of getting x
> > > records and then next x records on the SQL side?
> > >
> > > Oh, and I can't persist the data in a array of structures or wddx
packet
> > > because it is inventory that changes quickly and needs to be accurate
on
> > the
> > > execution of the query.
> > >
> > > Michael
> > >
> > >
> > > ~~
> > > Structure your ColdFusion code with Fusebox. Get the official book at
> > http://www.fusionauthority.com/bkinfo.cfm
> > >
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
> > ~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

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

Re: Creating text boxes on the fly

[Jon Hall]

This depends on the fact that you know what form fields you need when you
get the page.
Basically you need the formfield names that you need in a comma delimited
list.
Example:
You know you need Field1,Field3,Field4,Field5 textboxes.

Then as you creates you textarea's just check to see if the fieldname exists
in your list using the listContainNoCase() Function.
Lets say that your list of fieldnames is names fieldlist.






...and so on

jon


- Original Message -
From: "Robert Segal" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 3:59 PM
Subject: RE: Creating text boxes on the fly


> If you know how many text boxes you need, perhaps they come from a query,
do
> something like this:
>
> 
> 
> 
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 17, 2000 3:03 PM
> To: CF-Talk
> Subject: Creating text boxes on the fly
>
>
> I'm not sure how to phrase this but here goes:
> I have a form that requires lots and lots of text boxes, all of the text
> boxes are not always needed so I would like to create these text boxes on
> the fly.
> Right now all of the text boxes show and the form is so long, it
> confuses the user. I am sure that I can send the needed info from a form
> that will contain all the  fieldnames and how many boxes are needed, if I
> need 5 text boxes I would need to append the numbers 1 - 5 onto the
> fieldname, and have 5 text boxes created using those 5 fieldnames. If
> someone could point me in the right direction I would be most grateful.
>
> Thanks,
> Linda McElroy
> Web Designer
> Sears Direct Response
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

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

RE: Nested Structures and Arrays - Addendum

[Eric Gilbert]

Thanks All on your input array notation looks like the best route.  I was
using dot notation since I am familiar with it more than any other.
Basically It would appear that my suspicion that it is a CF Language
limitation is correct, but only specific to adding nested structures to
arrays using dot notation.  I say this because in other situations where no
array was involved I have used nested structures 15 structures deep using
dot notation without any issues.

I'm receiving a WDDX packet of a structure from another legacy system that
should/will basically have the described depth, but it might get deeper...

Eric Gilbert
Developer
Stone Ground Solutions
560 Sutter St., Suite 400
San Francisco, CA 94102
415.252.0600 voice
415.252.0123 fax
www.stoneground.com

-Original Message-
From: Robert Segal [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 1:19 PM
To: CF-Talk
Subject: RE: Nested Structures and Arrays - Addendum


Using array notation or structinsert works, I can't figure out why dot
notation doesn't

Session.Intake.Guardian[1].Employer.Address["StreetAddress"] = "";

or

structinsert(Session.Intake.Guardian[1].Employer.Address,"StreetAddress","")
;

both work.

-Original Message-
From: Eric Gilbert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 11:35 AM
To: CF-Talk
Subject: RE: Nested Structures and Arrays - Addendum


Sorry I miss typed the code, what I meant was


Session.Intake = structnew();
Session.Intake.URLToken = URLToken;
Session.Intake.Guardian = arrayNew(1);
Session.Intake.Guardian[1] = structnew();
Session.Intake.Guardian[1].Employer = structnew();
Session.Intake.Guardian[1].Employer.Name = "";
Session.Intake.Guardian[1].Employer.Address = structnew();

//Works great till here
Session.Intake.Guardian[1].Employer.Address.StreetAddress = "";


I still get the error:
"The member "EMPLOYER.ADDRESS" in dimension 1 of object
"Session.Intake.Guardian" cannot be found. Please, modify the member name"

-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 7:17 AM
To: CF-Talk
Subject: RE: Nested Structures and Arrays


you haven't declared Session.Intake.Parent as anything yet.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Eric Gilbert [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 9:01 PM
To: CF-Talk
Subject: Nested Structures and Arrays


I'm encountering something odd, and I'm not sure if it is a bug with the
version of CFServer I'm using or a deeper CF language issue.

I get the error:
"The member "EMPLOYER.ADDRESS" in dimension 1 of object
"Session.Intake.Parent" cannot be found. Please, modify the member name"

when I try to execute the following script block (with proper locking..)


Session.Intake = structnew();
Session.Intake.URLToken = URLToken;
Session.Intake.Guardian = arrayNew(1);
Session.Intake.Guardian[1] = structnew();
Session.Intake.Guardian[1].Employer = structnew();
Session.Intake.Guardian[1].Employer.Name = "";
Session.Intake.Guardian[1].Employer.Address = structnew();

//Works great till here
Session.Intake.Parent[1].Employer.Address.StreetAddress = "";



I'm running PWS on Win98 with a developer's edition of CFServer.

Server Product ColdFusion Server
 Version 4, 0, 0, 0




Eric Gilbert
Developer
Stone Ground Solutions
560 Sutter St., Suite 400
San Francisco, CA 94102
415.252.0600 voice
415.252.0123 fax
www.stoneground.com



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



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



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
~
Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthor

RE: Real Life Math Computations....

[Michael Thomas]

Thats a damn awesome script. Between this & all the other posts Ive learned 
a great deal on what I inquired about. You guys did an outstanding job. Once 
again this script is verydetailed & looks great.

You were right when you said entertaining, Ive always been a fan of game 
programming & have wanted one day perhaps code a small game or something 
like that. Do you have a working example of this online that I can play 
with!?!?!? Please Please Please!!! lmao

Once again on a serious note, to everyone that posted, good job guys. If you 
have that game online or avialable to try out Id love to play with it, Post 
Link!!! hehe

Sincerely,
Mike


>From: "Daniel Kemp" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Real Life Math Computations
>Date: Fri, 17 Nov 2000 17:02:11 -
>
> > There are a couple of built-in functions within Cold Fusion
> > as well as other languages like Javascript etc. etc. that
> > Im curious about.
>
> > Abs()
> > Atn() (or otherwise referred to as Atan)
> >
> > Anyone have a real world example of these within a CF
> > App???
>
>Yup here's an entertaining, if not unlong snippit of code...
>
>It's used to help run a virtual ecosystem, the below helps me work out
>which target creatures are within the source creatures Field of
>Vision.  i.e. the sourceCreature can be facing 45 degree (northwest),
>and have a FoV of 120 degree, the below code works out the angle
>between the source creature and target creature, and then the angle
>between that angle and the facing angle (nording) of the source
>creature, and checks to see if it falls within the FoV.
>
>Of course I assume the whole thing would be faster in  and
>using some form of look-up table.
>
>I don't know about "real-world", but this is artificial world :)
>
>-
>
>
>
>   
>   
>
>
>
>   
>   
>
>
>
>   
>   
>
>
>
>   
>   
>
>
>
>targetY)))>
>
>
>
>   
>
>
>
>   
>
>
>
>   
>
>
>
>   
>
>
>
>
>(newAngle-360))>
>   
>
>   
>
>
>
>   
>   targetX)+(sourceY - targetY)*(sourceY - targetY)))>
>
>
>   
>   sourceDoV AND Distance LTE int(sourceDistance*5)>
> 
> 
> 
> 
> 
> 
> 
>   
>
>
>
>
>Oh yeah, and for the record, here's the SQL that get's the 10 nearest
>target creatures, within the source creatures view distance.
>
>
>   SELECT id as targetID,
> x as targetX,
> y as targetY,
> creatureType as targetCreatureType,
> dmgTvTMod.modify as TvTMod,
> dmgAvBMod.modify as AvBMod
>   FROM creature,
> dmgTypeVrsTypeMod dmgTvTMod,
> dmgAttackVrsBodyMod dmgAvBMod
>   WHERE id <> #sourceID#
>   AND energyLevel > 0
>   AND dmgTvTMod.defenderTypeID = creatureType
>   AND dmgTvTMod.attackerTypeID = #sourceCreatureType#
>   AND dmgAvBMod.bodyTypeID = bodyType
>   AND dmgAvBMod.attackTypeID = #sourceAttackType#
>   ORDER BY ((x-#sourceX#)*(x-#sourceX#)+(y-#sourceY#)*(y-#sourceY#))
>
>
>Notice the scary ORDER BY bit, any suggestions on how to turn that
>into a stored procedure greatly welcomed :)
>
>-
>
>R'grds,
>Dan.
>
>
>
>This message is intended only for the use of the person(s) ("the intended 
>recipient(s)") to whom it is addressed.
>
>It may contain information which is privileged and confidential within the 
>meaning of the applicable law.
>If you are not the intended recipient, please contact the sender as soon as 
>possible.
>The views expressed in this communication may not necessarily be the views 
>held by Live Information Systems Limited.
>
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

RE: speeding up a multi table query

[Stuart Duncan]

Thanx a lot everyone who responded.   I love it when I get a bunch of 
different answers. I get more to work with... and for the record, they all 
work.  Now I just get to play with them and tweak them to get the maximum 
optimization.

Thanx!
Stuart Duncan
MaracasMedia Inc.


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

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

RE: file extensions

[Christopher Olive, CIO]

i think i remember reading somewhere that .dbm was a legacy naming
convention from CF1.5.  you could probably use it, but why?

actually, you can have (almost) any file convention for CF.  just map its
extension to the CFML module in your ISAPI mappings (in IIS, at least)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Anuj Gakhar [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 12:10 PM
To: CF-Talk
Subject: file extensions


can we use .dbm as extension in cold fusion...
i tested it and it worked.
why so?
what is dbm for?
pl. answer these questions

jimmy

 __ Do You Yahoo!? Talk to
your friends online with Yahoo! Messenger. http://im.yahoo.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

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

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

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

Re: CF-based document viewer

[Jim McAtee]

> > I'm interested in developing a web-based document-viewing intranet page
> > (using CF 4.0.1) to allow users to navigate multiple directory levels on
> > the server.  Word and Acrobat documents in these directories could then
be
> > launched from the browser.
> >
> > So far, I haven't found any custom tags or tutorials on this subject,
> > which must be a fairly common activity for CF developers.  There is a
tag
> > at Allaire's site called CF_FILECHOOSER, but it loads the entire
directory
> > structure into a CFTREE applet - My users won't want to wait that long
to
> > see the directory each time.
> >
> > Please describe how you might do/already did this, or perhaps provide
some
> > code examples or references.

This is pretty straightforward using CFDIRECTORY.  Start with a root
directory, do a CFDIRECTORY to get its contents, then display direct links
to files entries; for directories, you create links which point back at the
same template and pass the new directory name and then do another
CFDIRECTORY on the subdirectory.  There's a field called 'type' returned in
the CFDIRECTORY query which tells you if an entry is a file or directory.
When you do a CFDIRECTORY, you'll also see the standard DOS "." (current
directory) and ".." (parent directory).  You could probably suppress the
current directory link, and if you're in the root directory, suppress the
parent link.  Otherwise, once a user has navigated down into a subdirectory
display the link to the parent so that they may climb back up.

Check out the CFDIRECTORY documentation.  You'll see that you can use a
filter.  For example "*.pdf" if you wanted to only display files with that
extension.  You might use this to refine what file listings a user sees.
When you do a CFDIRECTORY, you'll get things like directory entry name (file
name or subdirectory name), file size, date the file was last updated,
attributes.  You could choose to display any or all of those items for each
entry.  You can also tell CFDIRECTORY to sort in ascending or descending
order on any of those fields, so you might implement a Windows Explorer-like
interface that lets a user click on a colum header and sort the files by
name or date or size.

An quick and dirty way to do all this, if you don't need the filtering or
sorting features, would be to simply permit directory browsing within the
web server's setup.  Then point your users to the root directory and let 'em
roam.  You may have to use NT ACLs to keep those users confined to the tree
below the root, however.

Jim


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

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

RE: cfhttp

[Paul Mone]

what version CF?

-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 3:51 PM
To: CF-Talk
Subject: cfhttp


I am trying to use CFHTTP and CFHTTPPARAM to bypass a form and pass my
own form variables directly to an action page.  On top of this, the
action page is an ASP.

I am receiving an error that I am unable to connect to the server.

Does anyone have any advice on this?

TIA,

Melissa

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

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

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

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

RE: PCodeDocumentNodeImp::validateSelf

[Paul Mone]

Unfortunately not, the servlet is the property of my former employer and I
think they might even be trying to patent it.  However, a Java programmer
remotely familiar with servlets should have no problem reproducing your cf
templates' fucntionality.  Making a module that can make HTTP requests, ODBC
Connections and file parsing are a piece of cake when using the base servlet
class.

-Original Message-
From: Michael Thomas [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 2:32 PM
To: CF-Talk
Subject: RE: PCodeDocumentNodeImp::validateSelf


This never actually brought down the entire server but however it did kill
the usage of that user agent until I restarted the server. This wuz a lil
bit annoying as it would just come out of no where (even though it wuz few &
far between.)

Your solution to this sounds interesting, by any chance would you be able to
pass this servlet along???


>From: "Paul Mone" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: PCodeDocumentNodeImp::validateSelf
>Date: Fri, 17 Nov 2000 13:02:28 -0800
>
>I had a similar application that was doing lots of datamining.  It would
>crash alot, often bringing down the server with it.  Our solution was to
>use
>a Java servlet for the task instead of CF, it worked great.
>
>-Original Message-
>From: Michael Thomas [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 17, 2000 11:47 AM
>To: CF-Talk
>Subject: RE: PCodeDocumentNodeImp::validateSelf
>
>
>Yes indeed it wuz, the database has a couple hundred links but a narrow
>that
>down into fields, so id say maybe 10 at a given time, give or take 1 or 2.
>
>
> >From: "Paul Mone" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: RE: PCodeDocumentNodeImp::validateSelf
> >Date: Fri, 17 Nov 2000 11:31:19 -0800
> >
> >Was that custom tag calling cfhttp alot?
> >
> >-Original Message-
> >From: Michael Thomas [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, November 17, 2000 3:02 AM
> >To: CF-Talk
> >Subject: Re: PCodeDocumentNodeImp::validateSelf
> >
> >
> >As far as PCode goes, I have ran into my own lil scraps with that. It
> >happened within a custom tag that manages my links database. Restarting
>the
> >server (which is 4.5.1) did the trick, but on occasion that ugly error
>does
> >rare its head. I once had this task scheduled but for that very reason it
> >no
> >longer is.
> >
> >
> > >From: David Cummins <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: CF-Talk <[EMAIL PROTECTED]>
> > >Subject: Re: PCodeDocumentNodeImp::validateSelf
> > >Date: Fri, 17 Nov 2000 11:45:55 +1300
> > >
> > >If it causes problems with them, then how are you supposed to use
> >Unicode?
> > >That's what nvarchars are for...
> > >
> > >Paul Mone wrote:
> > > >
> > > > Yeah, I stay away from nvarchar, etc. for the same reason.  What is
> >the
> > > > benefit of using nvarchar over varchar (if any).  i.e. why does it
> > >exist?
> > > >
> > > > -Original Message-
> > > > From: Michael Ross [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, November 15, 2000 12:14 PM
> > > > To: CF-Talk
> > > > Subject: Re: PCodeDocumentNodeImp::validateSelf
> > > >
> > > > I got the pcode error when my variables in SQL 7.0 were nvarchar,
> >ntext
> > >and
> > > > such.  Once I changed them(varchar, text) it worked.
> > > >
> > > > thanks
> > > >
> > > > >>> [EMAIL PROTECTED] 11/12/00 08:36PM >>>
> > > > On 11/13/00, David Cummins penned:
> > > > >I've seen it once before. Damned if I know - I think its an
>internal
> > >error.
> > > > >
> > > > >BTW, does anybody know how to find anything on the Allaire site? I
> >hear
> > > > >references to a search that works properly, but I've never seen a
> > > > >description of
> > > > >a PCode error yet on their site.
> > > >
> > > > The only thing I found in the knowledge base basically said there's
> > > > no way to determine what they are. You can do some things that will
> > > > help you guess, and do some registry hacks in 4.51 that will cause
>CF
> > > > server to restart. But I'm using 4.01 since 4.51 is such crap. I
>just
> > > > restarted CF server and it went away. I'm using the same custom tag,
> > > > that the PCode message said caused the error, under multiple sites
> > > > and it only happened on the one, so it seems to be a random thing.
> > > > --
> > > >
> > > > Bud Schneehagen - Tropical Web Creations
> > > >
> > > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > > > ColdFusion Solutions / eCommerce Development
> > > > [EMAIL PROTECTED]
> > > > http://www.twcreations.com/
> > > > 954.721.3452
> > > >
> >
>
>---
> >-
> > > > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> > >send a
> > > > message with 'unsubscribe' in the body to
> > >[EMAIL PROTECTED]
> > >

Re: scaleability of

[Brett Frisch]

Michael,

There are a number of ways to get the next and prev records.  Go to 
http://www.webtricks.com.  He wrote a pretty nice "browse records" peice of 
code.  If that won't work just do a search in the CF forums at 
allaire.com.  This should help you.

Brett

At 03:10 PM 11/17/00 -0800, you wrote:
>This is what I'm trying to get away from. This is just outputting a subset
>of my entire recordset.
>
>If I've got a query that returns 125,000 records and only display 25 of
>them, it's a waste of the servers resources.
>
>Michael
>
>"Shawn McGehee" <[EMAIL PROTECTED]> wrote in message
>015b01c050e0$044326e0$[EMAIL PROTECTED]">news:015b01c050e0$044326e0$[EMAIL PROTECTED]...
> > 
> > blah blah blah
> > ...
> > 
> >
> > --Shawn McGehee
> >
> > - Original Message -
> > From: "[BOXoFUSES] Michael Slatoff" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, November 17, 2000 2:16 PM
> > Subject: scaleability of 
> >
> >
> > > I'm working on an inventory management system for a small subset of out
> > > product database (only about 3k records compared to about 125k records).
> > > When returning the recordset, I want to break it up into bite sized
> > chunks.
> > > Only problem is, using , the query
>is
> > > still returning about 3k records and only displaying 25. If this thing
> > ever
> > > gets to the point where I need to keep track of the entire product list
> > > (125k records), this is going to bog down things.
> > >
> > > Is there a way in SQL to set a start row for a query? I know I can use
> > 'set
> > > rowcount 25' to only get 25 records, but I then need to start again at
>row
> > > 26.
> > >
> > > Am I looking in the wrong place? Is there a different way of getting x
> > > records and then next x records on the SQL side?
> > >
> > > Oh, and I can't persist the data in a array of structures or wddx packet
> > > because it is inventory that changes quickly and needs to be accurate on
> > the
> > > execution of the query.
> > >
> > > Michael
> > >
> > >
> > > ~~
> > > Structure your ColdFusion code with Fusebox. Get the official book at
> > http://www.fusionauthority.com/bkinfo.cfm
> > >
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
> > ~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


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

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

2nd request: Problem with IE5 on Mac

[Dave Hannum]

Anybody got a clue on this?



- Original Message - 
From: "Dave Hannum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 11:20 AM
Subject: Problem with IE5 on Mac


Can someone shed some light on why the following appears at the top of my
page using IE5+ on a Mac?

Page-Completion-Status: Normal Set-Cookie: CFID=160995; expires=Sun,
27-Sep-2037 00:00:00 GMT; path=/; Set-Cookie: CFTOKEN=76868295;
expires=Sun,...

It also appears in the description for my listing in the AltaVista search
engine!   This is stink-o!  I'm using Session management so I know it has
something to do with that.  But I have another site that uses the same
Session Management structure, but it does not have this problem.  It does,
however, set on another shared server with the same ISP.

Thanks,
Dave



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

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

file extensions

[Anuj Gakhar]

can we use .dbm as extension in cold fusion...
i tested it and it worked.
why so?
what is dbm for?
pl. answer these questions

jimmy


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Protecting Proprietary Content

[John Foulds]

You can crack Flash.


- Original Message -
From: "Paul Mone" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 4:02 PM
Subject: RE: Protecting Proprietary Content


> Do the interface in Flash 5 would be a good start.
>
> -Original Message-
> From: Terry Troxel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 17, 2000 7:44 AM
> To: CF-Talk
> Subject: Protecting Proprietary Content
>
>
> I have a client who wants to  provide training for his "system", his
system
> being a method to perform a service that is totally different then his
> competition. He wants his training to be multimedia computer based, and
was
> planning on doing this totally on the internet in order to maintain
control
> of the contents.
>
> I want to lessen the bandwidth requirements and make the program run from
a
> CD with the only way to get to the data and run the program to be by
logging
> onto the website with your name/password and receiving a one time code
that
> will only be valid for that session. The program will submit the answers
to
> the questions asked during the session to the site and be logged under
that
> users record for grading purposes.
>
> Now that I have said all that, do any of you have any suggestions as to
what
> technology I could utilize to accomplish this, keeping in mind I do not
want
> to leave any files that could be copied off the client either during or
> after the session is over?
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

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

RE: Example of Login that will control users privleges

[Shane Witbeck]

You might want to check out an article in CFDJ Volume 2 Issue 9 called
"Permission Framework" by Kelly Brown. It briefly goes over using session
variables and database schema for setting up authentication.

There is also an issue of whether you want to use session or client
variables with/without cookies.

Hope this helps.

Shane Witbeck

-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 5:09 PM
To: CF-Talk
Subject: Example of Login that will control users privleges


Does anyone have a site, and or code that will show the proper way to
login and password, and what ever privleges the user was granted, that
is all they can do and now more.  I have the login but cant figure out
how to control the users privleges in an application that I am working
on now.

Thanks

Michael

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

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

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

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

CF-based document viewer

[Carlson, Kevin]

> I'm interested in developing a web-based document-viewing intranet page
> (using CF 4.0.1) to allow users to navigate multiple directory levels on
> the server.  Word and Acrobat documents in these directories could then be
> launched from the browser. 
> 
> So far, I haven't found any custom tags or tutorials on this subject,
> which must be a fairly common activity for CF developers.  There is a tag
> at Allaire's site called CF_FILECHOOSER, but it loads the entire directory
> structure into a CFTREE applet - My users won't want to wait that long  to
> see the directory each time.
> 
> Please describe how you might do/already did this, or perhaps provide some
> code examples or references.
> 
> Thanks in advance,
> Kevin
> 
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: [Example of Login that will control users privleges]

[Alex]

the way I do it is have a user table, groups table, and user group
relationship table. the when you check the login set a session var the groups
the user is in


Michael <[EMAIL PROTECTED]> wrote:
Does anyone have a site, and or code that will show the proper way to
login and password, and what ever privleges the user was granted, that
is all they can do and now more.  I have the login but cant figure out
how to control the users privleges in an application that I am working
on now.

Thanks

Michael

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

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



Get free email and a permanent address at http://www.netaddress.com/?N=1
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Unformatted Post?

[Dave Watts]

> What are some options using Cold Fusion to send data in an 
> HTTP or HTTPS post that is not formatted in name value pairs 
> as is done with CFHTTP?
> 
> The purpose of this is to send data (an XML document), in a 
> raw post stream to another system that is reading the raw post 
> stream (ie. not looking for name value pairs).

Unfortunately, you can't do this with CFHTTP. There are third-party
components available which will let you specify the exact contents of the
request header and body. I think you can use CFX_HTTP for this, although I
haven't tried it:

http://www.fsc.follett.com/cf/cfx_http/

If not, there are quite a few COM HTTP controls which will do what you need.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Best Practices

[Dave Watts]

> That's all great, and I am looking forward to these improvements.
> However It's hard to believe that a Java engine will be faster 
> than a C++ engine.
> 
> (The Java interpreter itself is written in C++. C++ is 
> compiled directly to machine code. Think about it)

The Java engine itself might be slower, but a JSP-based solution could
conceivably be faster anyway. The Java-powered version of CF will supposedly
treat CFML scripts in the same way that JSP scripts are treated - compiled
into bytecode before their initial execution, then stored persistently on
disk.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: scaleability of

[[BOXoFUSES] Michael Slatoff]

This is what I'm trying to get away from. This is just outputting a subset
of my entire recordset.

If I've got a query that returns 125,000 records and only display 25 of
them, it's a waste of the servers resources.

Michael

"Shawn McGehee" <[EMAIL PROTECTED]> wrote in message
015b01c050e0$044326e0$[EMAIL PROTECTED]">news:015b01c050e0$044326e0$[EMAIL PROTECTED]...
> 
> blah blah blah
> ...
> 
>
> --Shawn McGehee
>
> - Original Message -
> From: "[BOXoFUSES] Michael Slatoff" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, November 17, 2000 2:16 PM
> Subject: scaleability of 
>
>
> > I'm working on an inventory management system for a small subset of out
> > product database (only about 3k records compared to about 125k records).
> > When returning the recordset, I want to break it up into bite sized
> chunks.
> > Only problem is, using , the query
is
> > still returning about 3k records and only displaying 25. If this thing
> ever
> > gets to the point where I need to keep track of the entire product list
> > (125k records), this is going to bog down things.
> >
> > Is there a way in SQL to set a start row for a query? I know I can use
> 'set
> > rowcount 25' to only get 25 records, but I then need to start again at
row
> > 26.
> >
> > Am I looking in the wrong place? Is there a different way of getting x
> > records and then next x records on the SQL side?
> >
> > Oh, and I can't persist the data in a array of structures or wddx packet
> > because it is inventory that changes quickly and needs to be accurate on
> the
> > execution of the query.
> >
> > Michael
> >
> >
> > ~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


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

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

webserver.log "(Apache) A network I/O error occurred..."

[Daniel Kemp]

Hi all, I'm getting quite a few of these

-

(Solaris 2.6   CF4.5.1.0 Enterprise.)

"Warning","11/17/00","14:08:11","(Apache) A network I/O error occurred
while
writing the reply back to the web server."
"Warning","11/17/00","14:59:12","(Apache) A network I/O error occurred
while
writing the reply back to the web server."
"Warning","11/17/00","15:28:05","(Apache) A network I/O error occurred
while
writing the reply back to the web server."
"Warning","11/17/00","16:03:55","(Apache) A network I/O error occurred
while
writing the reply back to the web server."
"Warning","11/17/00","16:27:40","(Apache) A network I/O error occurred
while
writing the reply back to the web server."
"Error","11/17/00","16:27:40","An error occurred while attempting to
establish a
 connection to the server. The most likely cause of this problem is
that the
server is not currently running. Verify that the server is running and
restart i
t if necessary.  Unix error number 146 occurred: Connection
refused"



Now I know it should be obvious what's going on, but it's late on
Friday here in the UK, and my brain's stopped working.  Anyone give me
a quick idea as to what's going on here.  I'm sure it must be a
commonly seen problem.

Cheers
Dan.



This message is intended only for the use of the person(s) ("the intended 
recipient(s)") to whom it is addressed.

It may contain information which is privileged and confidential within the meaning of 
the applicable law. 
If you are not the intended recipient, please contact the sender as soon as possible.
The views expressed in this communication may not necessarily be the views held by 
Live Information Systems Limited.


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

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

RE: Real Life Math Computations....

[Daniel Kemp]

> There are a couple of built-in functions within Cold Fusion
> as well as other languages like Javascript etc. etc. that
> Im curious about.

> Abs()
> Atn() (or otherwise referred to as Atan)
>
> Anyone have a real world example of these within a CF
> App???

Yup here's an entertaining, if not unlong snippit of code...

It's used to help run a virtual ecosystem, the below helps me work out
which target creatures are within the source creatures Field of
Vision.  i.e. the sourceCreature can be facing 45 degree (northwest),
and have a FoV of 120 degree, the below code works out the angle
between the source creature and target creature, and then the angle
between that angle and the facing angle (nording) of the source
creature, and checks to see if it falls within the FoV.

Of course I assume the whole thing would be faster in  and
using some form of look-up table.

I don't know about "real-world", but this is artificial world :)

-



  
  



  
  



  
  



  
  







  



  



  



  





  

  



  
  


  
  







  




Oh yeah, and for the record, here's the SQL that get's the 10 nearest
target creatures, within the source creatures view distance.


  SELECT id as targetID,
x as targetX,
y as targetY,
creatureType as targetCreatureType,
dmgTvTMod.modify as TvTMod,
dmgAvBMod.modify as AvBMod
  FROM creature,
dmgTypeVrsTypeMod dmgTvTMod,
dmgAttackVrsBodyMod dmgAvBMod
  WHERE id <> #sourceID#
  AND energyLevel > 0
  AND dmgTvTMod.defenderTypeID = creatureType
  AND dmgTvTMod.attackerTypeID = #sourceCreatureType#
  AND dmgAvBMod.bodyTypeID = bodyType
  AND dmgAvBMod.attackTypeID = #sourceAttackType#
  ORDER BY ((x-#sourceX#)*(x-#sourceX#)+(y-#sourceY#)*(y-#sourceY#))


Notice the scary ORDER BY bit, any suggestions on how to turn that
into a stored procedure greatly welcomed :)

-

R'grds,
Dan.



This message is intended only for the use of the person(s) ("the intended 
recipient(s)") to whom it is addressed.

It may contain information which is privileged and confidential within the meaning of 
the applicable law. 
If you are not the intended recipient, please contact the sender as soon as possible.
The views expressed in this communication may not necessarily be the views held by 
Live Information Systems Limited.


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

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

RE: CFTRANSACTION and Oracle 8.1.6

[McCollough, Alan]

That's the whole point of using CFTRANSACTION; it gives you the ability to
roll back multiple transactions if something goes wrong. This is
accomplished by doing a database lock.

Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center

> -Original Message-
> From: dave fauth [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, November 17, 2000 1:04 PM
> To:   CF-Talk
> Subject:  CFTRANSACTION and Oracle 8.1.6
> 
> I have a programmer working for me doing some data conversion using CF
> 4.5.1 sp1.  The database is Oracle 8.1.6 on NT using native drivers.  He
> wrapped the code in CFTRANSACTION and it is database intensive code.  A
> lot
> of selects/updates.  When he runs the code, it locks out all other
> database
> queries until the script is done.  Is this normal and is this how
> CFTRANSACTION works?  Is there something I should be looking at?
> 
> dave  
> ---
> dave fauth
> [EMAIL PROTECTED]
> 
> "The opinions expressed here
> are my own and not those of 
> DOMAIN technologies, inc."
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: cfhttp

[Gregory Harris]

Depending on the specific error message, it could be a wide variety of
things, offhand I can think of 2:

1) The server is just too slow
2) For security reasons, the server isn't letting you

If you can give me a more specific error message coming from the other
server, diagnosing might be easier.  Hint: if you don't know how to print
the results of a CFHTTP Action try this:





#CFHTTP.FileContent#
#CFHTTP.MimeType# 
#CFHTTP.Header# 

 (to avoid further template processing and display results




Gregory Harris
Web Developer
Stirling Bridge Group LLC

- Original Message -
From: "Melissa Fraher" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 3:51 PM
Subject: cfhttp


> I am trying to use CFHTTP and CFHTTPPARAM to bypass a form and pass my
> own form variables directly to an action page.  On top of this, the
> action page is an ASP.
>
> I am receiving an error that I am unable to connect to the server.
>
> Does anyone have any advice on this?
>
> TIA,
>
> Melissa
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>

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

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

RE: append variable to a variable??

[Dave Watts]

> > Using SetVariable is better
> >
> > 
>
> I disagree.
> 
> Why is it "better"? SetVariable is just another redundant function to
> learn, another syntax to look up. I believe there actually IS some
> circumstance where you MUST use it, but I just can't recall when.
> 
>  does exactly what you would 
> expect and hope. It's simple (as in Occam's Razor simple), elegant 
> and effective. Why do string concatenation using ampersands instead 
> of just embedding variables inside your strings? Is it a 'classier' 
> technique, perhaps?

I'd disagree with you, here.

In any programming language, you want to avoid "tricks" of the language. The
fact that you can evaluate a string automatically on the left side of a
CFSET is exactly that - it works, but there's no reason to expect it to
continue working in future versions of CF. It's a bit counterintuitive as
well, given that you can't do that in most programming languages that I've
seen.

On the other hand, the SetVariable function is explicitly designed to create
dynamically-named variables. That'll be supported in future versions. In
addition, when you're reading the code and you see "SetVariable", you
instantly know what's going on, while you might not notice variables named
dynamically using string concatenation.

To follow this to its extreme, I'd argue that you should place a variable on
the left side of the CFSET, which Justin's example is missing:



should be



Now, this isn't required either, in the current version of CF, but having a
variable on the left side of the assignment statement is intrinsic to the
idea of using an assignment statement!

As far as whether you're better off using ampersands for string
concatenation or simply evaluating variables within strings, that's up to
you. Six of one, half-dozen of the other. I prefer using ampersands, but I
make no claim of superiority for that method. I find it personally easier to
read.

In addition, I think you're misusing Occam's Razor, or the principle of
parsimony, which refers to the explanatory power of simplicity, rather than
the functional power of simplicity:

"one should not increase, beyond what is necessary, the number of entities
required to explain anything"

Basically, all it means is that if you can explain something with one step,
or with two steps, the explanation with one step is more likely to be
correct, all other things being equal. In any case, as a computer
programmer, you use complexity every day to make things simpler for others -
that's what programming is all about. Of course, there's room for
disagreement here, but I felt the need to make that philosophy major
worthwhile, and I hate to see epistemology gone bad.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Speeding up a multi table query

[Stas Newdel]

Don't know about whether this is going to be faster, as I can't test your
database:

select vhs.*, p.price, s.studio, s.ID as sID, s.studioID, pr.videoID
from vhs,pricing p,studios s, performersRel pr
where p.priceID = vhs.price
and s.ID = vhs.studio
and vhs.ID =  pr.videoID
and pr.performerID = 1627

-Original Message-
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]

I was wondering if anyone knows of a way to speed up this query? If "Joins"
would be better, and how? That sorta thing.

The actors, studios and prices are all in separate tables.  "vhs" "pricing"
"studios" and "performersRel"

There has to be a faster way to get 22 records back.


resultsbyperformer (Records=22, Time=328ms)
SQL =
select vhs.*, p.price, s.studio, s.ID as sID, s.studioID
from vhs,pricing p,studios s
where p.priceID = vhs.price
and s.ID = vhs.studio
and vhs.ID in (select videoID from performersRel where performerID = 1627)

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

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

RE: Speeding up a multi table query

[Andrew]

Stuart:
Whenever you start using 'IN' in your queries they become increasingly
slower as the list that you are checking IN gets bigger.  Plus it is doing
this check for every record of your main query.  I would try this instead:

SQL =
select vhs.*, p.price, s.studio, s.ID as sID, s.studioID
from vhs,pricing p,studios s
where p.priceID = vhs.price
and s.ID = vhs.studio
and (select count(videoID) from performersRel where videoID=vhs.ID and
performerID = 1627) > 0



Andrew Hewitt
Web Application Developer
webworld studios, inc.
www.wwstudios.com


-Original Message-
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 4:17 PM
To: CF-Talk
Subject: Speeding up a multi table query


I was wondering if anyone knows of a way to speed up this query? If "Joins"
would be better, and how? That sorta thing.

The actors, studios and prices are all in separate tables.  "vhs" "pricing"
"studios" and "performersRel"

There has to be a faster way to get 22 records back.


resultsbyperformer (Records=22, Time=328ms)
SQL =
select vhs.*, p.price, s.studio, s.ID as sID, s.studioID
from vhs,pricing p,studios s
where p.priceID = vhs.price
and s.ID = vhs.studio
and vhs.ID in (select videoID from performersRel where performerID = 1627)


Any help would be greatly appreciated.

Stuart Duncan
MaracasMedia Inc.


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

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


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

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

RE: Speeding up a multi table query

[Hayes, David]

A couple of thoughts:

1) How big are the tables?

2) Is vhs indexed on ID?

3) Is performersRel indexed on performerID?

4) If you don't need all the fields in VHS, specify them.

5) Is studio indexed on ID?

6) How fast does the subquery run by itself? 



-Original Message-
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 3:17 PM
To: CF-Talk
Subject: Speeding up a multi table query


I was wondering if anyone knows of a way to speed up this query? If "Joins" 
would be better, and how? That sorta thing.

The actors, studios and prices are all in separate tables.  "vhs" "pricing" 
"studios" and "performersRel"

There has to be a faster way to get 22 records back.


resultsbyperformer (Records=22, Time=328ms)
SQL =
select vhs.*, p.price, s.studio, s.ID as sID, s.studioID
from vhs,pricing p,studios s
where p.priceID = vhs.price
and s.ID = vhs.studio
and vhs.ID in (select videoID from performersRel where performerID = 1627)


Any help would be greatly appreciated.

Stuart Duncan
MaracasMedia Inc.


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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Speeding up a multi table query

[Jason Powers]

Can't you say:
SELECT vhs.*, p.price, s.studio, s.ID as sID, s.studioID
FROM vhs
JOIN pricing p on p.priceID=vhs.price
JOIN studios s on s.id=vhs.studio
JOIN performersRel pr on pr.videoID=vhs.id
WHERE pr.performerID = 1627

I could be wrong, I don't have a dataset to test against, this is just off
the top of my head.

Jason Powers
Fig Leaf Software
202-797-5440


-Original Message-
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 4:17 PM
To: CF-Talk
Subject: Speeding up a multi table query


I was wondering if anyone knows of a way to speed up this query? If "Joins" 
would be better, and how? That sorta thing.

The actors, studios and prices are all in separate tables.  "vhs" "pricing" 
"studios" and "performersRel"

There has to be a faster way to get 22 records back.


resultsbyperformer (Records=22, Time=328ms)
SQL =
select vhs.*, p.price, s.studio, s.ID as sID, s.studioID
from vhs,pricing p,studios s
where p.priceID = vhs.price
and s.ID = vhs.studio
and vhs.ID in (select videoID from performersRel where performerID = 1627)


Any help would be greatly appreciated.

Stuart Duncan
MaracasMedia Inc.


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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: PCodeDocumentNodeImp::validateSelf

[Michael Thomas]

This never actually brought down the entire server but however it did kill 
the usage of that user agent until I restarted the server. This wuz a lil 
bit annoying as it would just come out of no where (even though it wuz few & 
far between.)

Your solution to this sounds interesting, by any chance would you be able to 
pass this servlet along???


>From: "Paul Mone" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: PCodeDocumentNodeImp::validateSelf
>Date: Fri, 17 Nov 2000 13:02:28 -0800
>
>I had a similar application that was doing lots of datamining.  It would
>crash alot, often bringing down the server with it.  Our solution was to 
>use
>a Java servlet for the task instead of CF, it worked great.
>
>-Original Message-
>From: Michael Thomas [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 17, 2000 11:47 AM
>To: CF-Talk
>Subject: RE: PCodeDocumentNodeImp::validateSelf
>
>
>Yes indeed it wuz, the database has a couple hundred links but a narrow 
>that
>down into fields, so id say maybe 10 at a given time, give or take 1 or 2.
>
>
> >From: "Paul Mone" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: RE: PCodeDocumentNodeImp::validateSelf
> >Date: Fri, 17 Nov 2000 11:31:19 -0800
> >
> >Was that custom tag calling cfhttp alot?
> >
> >-Original Message-
> >From: Michael Thomas [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, November 17, 2000 3:02 AM
> >To: CF-Talk
> >Subject: Re: PCodeDocumentNodeImp::validateSelf
> >
> >
> >As far as PCode goes, I have ran into my own lil scraps with that. It
> >happened within a custom tag that manages my links database. Restarting 
>the
> >server (which is 4.5.1) did the trick, but on occasion that ugly error 
>does
> >rare its head. I once had this task scheduled but for that very reason it
> >no
> >longer is.
> >
> >
> > >From: David Cummins <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: CF-Talk <[EMAIL PROTECTED]>
> > >Subject: Re: PCodeDocumentNodeImp::validateSelf
> > >Date: Fri, 17 Nov 2000 11:45:55 +1300
> > >
> > >If it causes problems with them, then how are you supposed to use
> >Unicode?
> > >That's what nvarchars are for...
> > >
> > >Paul Mone wrote:
> > > >
> > > > Yeah, I stay away from nvarchar, etc. for the same reason.  What is
> >the
> > > > benefit of using nvarchar over varchar (if any).  i.e. why does it
> > >exist?
> > > >
> > > > -Original Message-
> > > > From: Michael Ross [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, November 15, 2000 12:14 PM
> > > > To: CF-Talk
> > > > Subject: Re: PCodeDocumentNodeImp::validateSelf
> > > >
> > > > I got the pcode error when my variables in SQL 7.0 were nvarchar,
> >ntext
> > >and
> > > > such.  Once I changed them(varchar, text) it worked.
> > > >
> > > > thanks
> > > >
> > > > >>> [EMAIL PROTECTED] 11/12/00 08:36PM >>>
> > > > On 11/13/00, David Cummins penned:
> > > > >I've seen it once before. Damned if I know - I think its an 
>internal
> > >error.
> > > > >
> > > > >BTW, does anybody know how to find anything on the Allaire site? I
> >hear
> > > > >references to a search that works properly, but I've never seen a
> > > > >description of
> > > > >a PCode error yet on their site.
> > > >
> > > > The only thing I found in the knowledge base basically said there's
> > > > no way to determine what they are. You can do some things that will
> > > > help you guess, and do some registry hacks in 4.51 that will cause 
>CF
> > > > server to restart. But I'm using 4.01 since 4.51 is such crap. I 
>just
> > > > restarted CF server and it went away. I'm using the same custom tag,
> > > > that the PCode message said caused the error, under multiple sites
> > > > and it only happened on the one, so it seems to be a random thing.
> > > > --
> > > >
> > > > Bud Schneehagen - Tropical Web Creations
> > > >
> > > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > > > ColdFusion Solutions / eCommerce Development
> > > > [EMAIL PROTECTED]
> > > > http://www.twcreations.com/
> > > > 954.721.3452
> > > >
> >
> >---
> >-
> > > > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> > >send a
> > > > message with 'unsubscribe' in the body to
> > >[EMAIL PROTECTED]
> > > >
> > > >
> >
> >---
> >-
> > > > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> > >send a
> > > > message with 'unsubscribe' in the body to
> > >[EMAIL PROTECTED]
> > > >
> > > >
> >
> >---
> >-
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusi

RE: SQL 7.0 Question

[Dave Watts]

> lookup sp_attach_db in BOL. 
> 
> It may not work if sp_detach_db was not used.

I've never had any problem getting sp_attach_db to work without previously
detaching the database. The problem I have run into is that logins from the
old server will still be stored in the attached database, and you can't
delete them from the SQL Enterprise Manager interface.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Fw: OT RE: Certification Exam

[Nick McClure]

I have taken and passed both the Allaire and the Brainbench CF tests.

I took these tests for myself to see where I ranked, I didn't take them for 
the job I am at or any job I might move to because the people I work with 
more than likely won't care about the paper, they will care about the work 
I do.

The people who do look at these tests typically do so because they do not 
have anything else to gauge a persons ability on.

If you are up for a job at a place who is looking for their first web 
programmer then a certification can tell them that you can at least solve 
simple problems. Are you a bad programmer if mistype a pound sign in one of 
your variables? Are you a bad programmer if you cannot find that error?



At 02:47 PM 11/17/2000 -0500, you wrote:
>I agree with Jeremy. I wrote the exam, but must admint that I did so only
>because it was free. As for knowledge, if you have been kicking CF around
>for a while, it should not be an issue. Does it guage if you are a master,
>or even advanced? I don't think so. It was quite basic.
>
>James
>
>- Original Message -
>From: "Jeremy Allen" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, November 17, 2000 2:10 PM
>Subject: OT RE: Certification Exam
>
>
> > Well since were all being opinionated ill speak along
> > the same lines as Simon.
> >
> > I do not believe in tests such as the Allaire Certification,
> > MCSE, Brainbenc, Multiple guess tests, plain and simple.
> >
> > A test like this will do very little to gauge anything as
> > you guys have mentioned but your ability to memorize something.
> > Whats the point?
> >
> > Here is my example.
> > Two people:
> > Person A.) One fails the CF exam due to test anxiety/little working
> > knowledge
> > of ColdFusion
> >
> > Person B.) Another person passes the CF Exam with flying colors, studied
> > just
> > a little the night before the test.
> >
> > I think the failure in the exam does NOT mean you cannot accomplish
> > a particular task without assisstance. Person A with a book in front of
>him
> > or
> > her could work twice as fast as Peron B with just a little visiaul clues
> > and the manual with them to figure out exact particulars on Syntax or
> > exactly
> > how this particular CF tag interacts with a protocol person A is
>intimately
> > familiar with.
> >
> > Does the CF Exam prove that the person gets how everything fits toghether?
> > From the Kernel of the operating system on up to the final presentation of
> > a CF Generated HTML page? I dont think so.
> >
> > I think you can ask questions that can illustrate very crudely at best
> > someones problem solving skills (with multiple guess). I think essay style
> > questions graded by very experienced and knowledgeable programmers (which
> > would make the cost of the test prohibitive to say the least) is a much
> > better gauge of a programmer.
> >
> > Sit someone in a room, give them three hours and all the reference
>material
> > to CF they usually use, assign them a particular task, review the code and
> > overall structure and coherency of their particular method of solving the
> > problem.
> >
> > In those three hours you can gauge more about someones programming skill
> > than any multiple guess test is going to. Again there is still the fact
> > that some people just perform miserably under pressure like that.. but
>then
> > again deadlines happen, a lot more often than they should.
> >
> > This is a really sore topic of mine. I take tests fine but I just dont see
> > the point to all this certification malarky.  Honestly I cant be to sure
> > I would want to work somewhere where something as easy to rig as the
> > the Brainbench test is a factor for deciding if I am hired.
> >
> > Taking the CF Exam can be a "good" thing if you want to say that your shop
> > has
> > "xyz" Certified Developers or whatever, if its free of cost to you.. might
> > as well. I cant see even in the most highly regarded jobs how
>certification
> > can be negative. Not needed, likely. Negative, I dont think so :)
> >
> >
> > Anyways...
> >
> > Jeremy Allen
> > ElliptIQ Inc.
> >
> >
> > ~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

--
Nick McClure[EMAIL PROTECTED]
Technical Director  859.245.9656
squareFish Mediawww.squareFish.com

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
h

Example of Login that will control users privleges

[Michael]

Does anyone have a site, and or code that will show the proper way to
login and password, and what ever privleges the user was granted, that
is all they can do and now more.  I have the login but cant figure out
how to control the users privleges in an application that I am working
on now.

Thanks

Michael

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

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

CFSCHEDULER

[Robert M. Saxon, Jr.]

I have a task that runs once a minute to check if a web page is down. If it
is, it emails me.  The problem is that I get an email once a minute as long
as the page is down.  Is there a way to use CFSCHEDULE or some other method
to stop/pause (not delete) a task defined in CF Administrator from a CF
page so that it will stop emailing me until the page is restored?

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

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

RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP

[Rif Kiamil]

>>U dont link ColdFusion to a LinkServer, U tell SQL to which link server u
want to uses after the OPENQUERY

e.g. 

FROMOPENQUERY(, '
select
{Measures.[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales
')

as [AS ANYTHING]

>> you have to uses "AS" for your table name but it can be anything

>> you have to uses "AS" for your your select stuff becuase when u do the
output it can not uses the standed names e.g.
#OlapQuery.Measures.MeasuresLevel.Members#, but if you
us AS then u can do the following #OlapQuery.C#. Again
it does not have to be "C", it can be "MembersName".

Hope this helps

>From Rif :-)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2000 19:40
To: Rif Kiamil
Subject: RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE
HELP


Rif,

Thanks for your response.  I set up my linked server but just have a few
questions.  How do I get to the linked server through coldfusion?  How do I
set up my datasource in Cf Administrator?  Also, why did you use the o.
"" as c in your expressions?  Why did you use the o and c?  Can I
not just use a query such as:
SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [My Cube]

And then try to diplay the results in an output tag?

Thanks again!
Eddie

-Original Message-
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 1:48 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE
HELP


This is what I do when I want to query OLAP from CF.

Make a LinkServer from MS SQL Server to MS OLAP Server. The setting are :

Provider Name   : Microsoft OLE DB Provider for OLAP
Product Name: MSOLAP
Datesource  : 
Provider string :
Location: 
Catalog : 

Onces that is done you can us the OPENQUERY from a normal SQL query. But you
must turn quted_identifier ON.

e.g.

-- START --

set quoted_identifier on
SELECT  o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
Type].[MEMBER_CAPTION]" AS R
FROMOPENQUERY(OLAP_TEST, '
select
{Measures.[Unit Sales]} on columns,
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales
')

as o
set quoted_identifier off


-- END --


>From Rif

PS I have not test this query!

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2000 16:54
To: CF-Talk
Subject: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP


 Hello,  I am attempting to query an Olap Cube through using MDX through CF.
I am using a com object and can see the cube but am unable to get any data
from it.  I used a custom tag to see what was being returned and all that is
returned is a space.  I was told by Ben Forta that I would need to play with
the com object so that CF would understand the output.  Any suggestions?!?
The following code runs with no errors, (unless I have made an error in my
expression) but there is only a space in the output.

Thanks,
Eddie






Cube Test









 









The variable is  empty.






Results:




#cst#



Your mdx query is:


#smdx#







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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFTRANSACTION and Oracle 8.1.6

[dave fauth]

I have a programmer working for me doing some data conversion using CF
4.5.1 sp1.  The database is Oracle 8.1.6 on NT using native drivers.  He
wrapped the code in CFTRANSACTION and it is database intensive code.  A lot
of selects/updates.  When he runs the code, it locks out all other database
queries until the script is done.  Is this normal and is this how
CFTRANSACTION works?  Is there something I should be looking at?

dave  
---
dave fauth
[EMAIL PROTECTED]

"The opinions expressed here
are my own and not those of 
DOMAIN technologies, inc."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Inserting Arrays into Table

[Parra, Fernando]

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_01C050E0.AB9A38A2
Content-Type: text/plain;
charset="iso-8859-1"

Hi,
 
I am trying to insert a 2 dimensional array into a table.  However, the
array does not have any fieldnames
This is what it looks like
 
session.array[1][1]:  "record1text1"
session.array[1][2]:  "record1text2"
session.array[1][3]:  "record1text3"
session.array[1][4]:  "record1text4"
session.array[1][5]:  "record1text5"
session.array[1][6]:  "record1text6" 
 
session.array[2][1]:   "record2text1"
session.array[2][2]:   "record2text2"
session.array[2][3]:   "record2text3"   
session.array[2][4]:   "record2text4"
session.array[2][5]:   "record2text5"
session.array[2][6]:   "record2text6"  
 
This should be inserted into datasource="p2plan" tablename  "materials"
and the fields should correspond as follows:
 
field1  = session.array[i][1]
field2  = session.array[i][2]
field3  = session.array[i][3]
field4  = session.array[i][4]
field5  = session.array[i][5]
field6  = session.array[i][6]
 
I thought about doing a  with a  based on the index=i but
how do I match each field with its respective text?
Thanks for your help,

Fernando Parra 



--_=_NextPart_001_01C050E0.AB9A38A2
Content-Type: text/html;
charset="iso-8859-1"








Hi,
 
I am trying to 
insert a 2 dimensional array into a table.  However, the array does not have any 
fieldnames
This is what it looks 
like
 
session.array[1][1]:  "record1text1"
session.array[1][2]:  "record1text2"
session.array[1][3]:  "record1text3"
session.array[1][4]:  "record1text4"
session.array[1][5]:  "record1text5"
session.array[1][6]:  "record1text6" 

 

session.array[2][1]:   "record2text1"
session.array[2][2]:   "record2text2"
session.array[2][3]:   "record2text3"   

session.array[2][4]:   "record2text4"
session.array[2][5]:   "record2text5"
session.array[2][6]:   "record2text6"  

 
This should be inserted into datasource="p2plan" 
tablename  "materials"
and the fields should correspond as 
follows:
 
field1  = 
session.array[i][1]
field2  = 
session.array[i][2]
field3  = 
session.array[i][3]
field4  = 
session.array[i][4]
field5  = 
session.array[i][5]
field6  = 
session.array[i][6]
 
I thought about doing a  with a 
 based on the index=i but how do I match each field with its 
respective text?
Thanks for your 
help,
Fernando Parra 

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

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

Re: scaleability of

[Shawn McGehee]

blah blah blah
...


--Shawn McGehee

- Original Message -
From: "[BOXoFUSES] Michael Slatoff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 2:16 PM
Subject: scaleability of 


> I'm working on an inventory management system for a small subset of out
> product database (only about 3k records compared to about 125k records).
> When returning the recordset, I want to break it up into bite sized
chunks.
> Only problem is, using , the query is
> still returning about 3k records and only displaying 25. If this thing
ever
> gets to the point where I need to keep track of the entire product list
> (125k records), this is going to bog down things.
>
> Is there a way in SQL to set a start row for a query? I know I can use
'set
> rowcount 25' to only get 25 records, but I then need to start again at row
> 26.
>
> Am I looking in the wrong place? Is there a different way of getting x
> records and then next x records on the SQL side?
>
> Oh, and I can't persist the data in a array of structures or wddx packet
> because it is inventory that changes quickly and needs to be accurate on
the
> execution of the query.
>
> Michael
>
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

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

CF Encode - (Howie Hamlin??)

[j p]

Hey a while back someone had a cfencoder application that helped with 
encoding files...I thought it was Howie.

Does any one remember this - or have it??

I want to encrypt cfm files only...
it is going through and doing all the files.

I've tried *.cfm but it comes back as "can't find *.cfm"


Help
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

RE: append variable to a variable??

[Lee Borkman]

Aidan,

I wonder why you tried the ugly version first.  Forget the ampersands, forget
SetVariable.  Maybe forget the vairables scoping as well.  Just do this:


Now doesn't that look much MUCH nicer than this:


I mean to say, what the hell is all THAT about?

Bjork.


---

From: Aidan Whitehall <[EMAIL PROTECTED]>
I tried to do something like this a while ago



and it fails (no function call on the LHS of an equals sign, or something
like that).

SetVariable to the rescue:



Ever since finding that out, I've avoided naming variables in the way you've
described above. I don't think there's anything inherently wrong with it
(you could create the variable name using another CFSET prior to this one),
but SetVariable just seems a bit more elegant.


-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd



Get free email and a permanent address at http://www.netaddress.com/?N=1
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: SQL Server Licesning

[paul smith]

They need CALs for users who aren't anonymous, don't they?

best,  paul

At 12:27 PM 11/17/00 -0700, you wrote:
>Someone using SQL for just for web site hosting gets
>shafted though, since he wasn't purchasing any CALs.

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

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

Speeding up a multi table query

[Stuart Duncan]

I was wondering if anyone knows of a way to speed up this query? If "Joins" 
would be better, and how? That sorta thing.

The actors, studios and prices are all in separate tables.  "vhs" "pricing" 
"studios" and "performersRel"

There has to be a faster way to get 22 records back.


resultsbyperformer (Records=22, Time=328ms)
SQL =
select vhs.*, p.price, s.studio, s.ID as sID, s.studioID
from vhs,pricing p,studios s
where p.priceID = vhs.price
and s.ID = vhs.studio
and vhs.ID in (select videoID from performersRel where performerID = 1627)


Any help would be greatly appreciated.

Stuart Duncan
MaracasMedia Inc.


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

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

Re: How to grab login info from LDAP

[S R]

Thanks a lot!


>From: "Michael Thomas" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: How to grab login info from LDAP
>Date: Fri, 17 Nov 2000 19:55:25 GMT
>
>Here is the link: http://www.geocities.com/SoHo/Coffeehouse/7184/cf1.html
>
>
> >From: "S R" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: How to grab login info from LDAP
> >Date: Fri, 17 Nov 2000 10:49:11 PST
> >
> >This was a problem I faced before and was never able to solve it. I have 
>an
> >intranet where people login, via IIS from an LDAP. I may be using the 
>wrong
> >terminology but in laymans terms, a little gray login box appears asking
> >for
> >my username and password, I know for sure the info is being authenticated
> >against an LDAP. My problem is I need to somehow grab that login name to
> >set
> >a session variable to customize the rest of my pages on my site based on
> >who
> >the user is. It would be cool if I could create my own login page where 
>CF
> >can pull the user info from the LDAP and I can go from there, but I don't
> >think these my Info Systems people are going to let me do that for
> >'security
> >reasons'. Is there any way to do this?
> >_
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> >
> >Share information about yourself, create your own public profile at
> >http://profiles.msn.com.
> >
> >~~
> >Structure your ColdFusion code with Fusebox. Get the official book at
> >http://www.fusionauthority.com/bkinfo.cfm
> >
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

RE: PCodeDocumentNodeImp::validateSelf

[Paul Mone]

I had a similar application that was doing lots of datamining.  It would
crash alot, often bringing down the server with it.  Our solution was to use
a Java servlet for the task instead of CF, it worked great.

-Original Message-
From: Michael Thomas [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 11:47 AM
To: CF-Talk
Subject: RE: PCodeDocumentNodeImp::validateSelf


Yes indeed it wuz, the database has a couple hundred links but a narrow that
down into fields, so id say maybe 10 at a given time, give or take 1 or 2.


>From: "Paul Mone" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: PCodeDocumentNodeImp::validateSelf
>Date: Fri, 17 Nov 2000 11:31:19 -0800
>
>Was that custom tag calling cfhttp alot?
>
>-Original Message-
>From: Michael Thomas [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 17, 2000 3:02 AM
>To: CF-Talk
>Subject: Re: PCodeDocumentNodeImp::validateSelf
>
>
>As far as PCode goes, I have ran into my own lil scraps with that. It
>happened within a custom tag that manages my links database. Restarting the
>server (which is 4.5.1) did the trick, but on occasion that ugly error does
>rare its head. I once had this task scheduled but for that very reason it
>no
>longer is.
>
>
> >From: David Cummins <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: Re: PCodeDocumentNodeImp::validateSelf
> >Date: Fri, 17 Nov 2000 11:45:55 +1300
> >
> >If it causes problems with them, then how are you supposed to use
>Unicode?
> >That's what nvarchars are for...
> >
> >Paul Mone wrote:
> > >
> > > Yeah, I stay away from nvarchar, etc. for the same reason.  What is
>the
> > > benefit of using nvarchar over varchar (if any).  i.e. why does it
> >exist?
> > >
> > > -Original Message-
> > > From: Michael Ross [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, November 15, 2000 12:14 PM
> > > To: CF-Talk
> > > Subject: Re: PCodeDocumentNodeImp::validateSelf
> > >
> > > I got the pcode error when my variables in SQL 7.0 were nvarchar,
>ntext
> >and
> > > such.  Once I changed them(varchar, text) it worked.
> > >
> > > thanks
> > >
> > > >>> [EMAIL PROTECTED] 11/12/00 08:36PM >>>
> > > On 11/13/00, David Cummins penned:
> > > >I've seen it once before. Damned if I know - I think its an internal
> >error.
> > > >
> > > >BTW, does anybody know how to find anything on the Allaire site? I
>hear
> > > >references to a search that works properly, but I've never seen a
> > > >description of
> > > >a PCode error yet on their site.
> > >
> > > The only thing I found in the knowledge base basically said there's
> > > no way to determine what they are. You can do some things that will
> > > help you guess, and do some registry hacks in 4.51 that will cause CF
> > > server to restart. But I'm using 4.01 since 4.51 is such crap. I just
> > > restarted CF server and it went away. I'm using the same custom tag,
> > > that the PCode message said caused the error, under multiple sites
> > > and it only happened on the one, so it seems to be a random thing.
> > > --
> > >
> > > Bud Schneehagen - Tropical Web Creations
> > >
> > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > > ColdFusion Solutions / eCommerce Development
> > > [EMAIL PROTECTED]
> > > http://www.twcreations.com/
> > > 954.721.3452
> > >
>
>---
>-
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> >send a
> > > message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
> > >
> > >
>
>---
>-
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> >send a
> > > message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
> > >
> > >
>
>---
>-
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> >send a message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
> >
> >--
> >David Cummins
> >Systems Developer
> >Ubiquity Software Ltd.
> >Ph: (09) 309-1921
> >~~
> >Structure your ColdFusion code with Fusebox. Get the official book at
> >https://secure.houseoffusion.com
> >
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http:/

RE: Creating text boxes on the fly

[Robert Segal]

If you know how many text boxes you need, perhaps they come from a query, do
something like this:






-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 3:03 PM
To: CF-Talk
Subject: Creating text boxes on the fly


I'm not sure how to phrase this but here goes:
I have a form that requires lots and lots of text boxes, all of the text
boxes are not always needed so I would like to create these text boxes on
the fly.
Right now all of the text boxes show and the form is so long, it
confuses the user. I am sure that I can send the needed info from a form
that will contain all the  fieldnames and how many boxes are needed, if I
need 5 text boxes I would need to append the numbers 1 - 5 onto the
fieldname, and have 5 text boxes created using those 5 fieldnames. If
someone could point me in the right direction I would be most grateful.

Thanks,
Linda McElroy
Web Designer
Sears Direct Response

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Certification Exam

[misty . d . woodward]

--openmail-part-354d9b53-0001
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
;Creation-Date="Fri, 17 Nov 2000 13:38:50 -0600"
Content-Transfer-Encoding: 8bit

I agree totally!  However, I'm sure at some point in time most of us
have been asked what degree we hold.  Again, this us just a piece of
paper, doesnt say you know a lick about CF programming but they still
want you to have it.  Personally, I do not have a degree in anything but
having certifications in Brainbench, now Allaire and also my Microsoft
certifications have helped me to overcome this by showing these instead.
So while it is just a piece of paper, employers like those little piece
of assurance. 

I think its all just a piece of paper but as long as they get me the job
instead of someone else I will continue to obtain every certification in
every possible language I can get my grubby little hands on!

Misty

-Original Message-
From: shorwith [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 11:43 AM
To: cf-talk
Cc: shorwith
Subject: RE: Certification Exam


I have been reading this thread, and just wanted to mention that neither
the
allaire test, nor the brainbench test, actually means you have a clue
how to
program in CF.  The allaire test seems to do a better (more thorough)
job of
testing your understanding of web application architectures and
implementations, and the brainbench test might do a better job testing
your
syntax knowledge and your ability to read code and know what it's
doing
but neither of these tests illustrate to me, that a person has the
ability
to write good code.  There's a huge difference between spitting out
memorized answers, and actually using this knowledge in the real world. 
The
tests are nice things to say you've done, and they might make
prospective
employers and clients feel better, but like so many other tests out
there,
they're no substitute for experience and good practice.  If you feel
you're
experienced enough that the test doesn't or shouldn't matter, then
you're
probably ready to take it, and should take it, to emphasise your
talents.
If you don't feel that experienced... my advice is to get experienced
before
taking the test... even if it's building apps on your laptop.
Like I said, just my two cents.

~Simon

> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 


-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 12:26 PM
To: CF-Talk
Subject: RE: Certification Exam


I wonder if the UK certified doodahs could give me an idea of the
advantages
of certification?


Kind Regards


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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

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


--openmail-part-354d9b53-0001--

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

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

cfhttp

[Melissa Fraher]

I am trying to use CFHTTP and CFHTTPPARAM to bypass a form and pass my
own form variables directly to an action page.  On top of this, the
action page is an ASP.

I am receiving an error that I am unable to connect to the server.

Does anyone have any advice on this?

TIA,

Melissa

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

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

Please Help ---Querying olap cubes with mdx---Please Help

[Edward Peloke]

Rif,

Thanks for your response.  I set up my linked server but just have a few
questions.  How do I get to the linked server through coldfusion?  How do I
set up my datasource in Cf Administrator?  Also, why did you use the o.
"" as c in your expressions?  Why did you use the o and c?  Can I
not just use a query such as:
SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [My Cube]

And then try to diplay the results in an output tag?

Thanks again!
Eddie


Eddie Peloke
The Echo Group
www.echoman.com

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

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

RE: Conference materials available?

[Chris Montgomery]

Check out http://www.allaire.com/conference/.  They have conference info
there, including streaming video of the conference general sessions.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner & NetObjects Reseller
210-490-3249/888-745-7603Fax 210-490-4692

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

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

RE: Creating text boxes on the fly

[Hayes, David]

 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 2:03 PM
To: CF-Talk
Subject: Creating text boxes on the fly


I'm not sure how to phrase this but here goes:
I have a form that requires lots and lots of text boxes, all of the text
boxes are not always needed so I would like to create these text boxes on
the fly.
Right now all of the text boxes show and the form is so long, it
confuses the user. I am sure that I can send the needed info from a form
that will contain all the  fieldnames and how many boxes are needed, if I
need 5 text boxes I would need to append the numbers 1 - 5 onto the
fieldname, and have 5 text boxes created using those 5 fieldnames. If
someone could point me in the right direction I would be most grateful.

Thanks,
Linda McElroy
Web Designer
Sears Direct Response

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Crystal Reports on a separate server?

[McCollough, Alan]

Anybody know if you can relocate Crystal Reports to a separate server, and
call up  on your CF server? I'd like to stick the Crystal Reports
engine on a separate box from the CF box...

Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center

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

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

RE: Intranets and PCDOCs DocsOpen

[Eric J Hoffman]

I integrated this solution at a law firm over the last year in conjunction
with a secure Cold Fusion extranetall sorts of little funny things pop
up...contact me offlist if you have questions.

Eric J Hoffman, MAIP
Director of Internet Development
Small Dog Design

-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 1:08 PM
To: CF-Talk
Subject: Intranets and PCDOCs DocsOpen


http://www.hummingbird.com/products/dkm/csdm/open/index.html

I am interested in learning how people are integrating PCDocs DocsOpen with
Cold Fusion on an intranet.

Specifically publishing links to documents on the intranet. ie a news
article application that allows for related Document links to appear. on the
right hand side of the article.

Eric
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

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

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

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

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

RE: SQL Server Licesning

[Paul Mone]

Does the 1Ghz really outperfrom the quad processor?  I have a Abit BP6 with
dual Celeron's OC'd at 523Mhz, and that thing performs better than my athlon
systems.

-Original Message-
From: McCollough, Alan [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 8:30 AM
To: CF-Talk
Subject: RE: SQL Server Licesning


That ain't quite correct. I think if you want to do anything beyond limited
SQL, you'll end up needing the $20K/cpu Enterprise Edition of SQL, which is
comparable to Oracle.

Either way, I think $20K/cpu is a miserable ripoff. In our instance, I have
a quad-processor SQL box, but the processors are 200mhz. Why should I pay
$80K for a license when a single-CPU 1ghz box would perform so much better,
and cost only $20K in licensing?

Moral? Per-CPU licensing is flawed.

Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center

> -Original Message-
> From: Zachary Bedell [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, November 17, 2000 6:48 AM
> To:   CF-Talk
> Subject:  RE: SQL Server Licesning
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Well...  Looks like M$ has changed their licensing strategy again,
> but...  Looking at the info from
> http://www.microsoft.com/sql/productinfo/pricing.htm, you're looking
> at $5000 per processor for unlimited user licenses.  Not bad compared
> to Oracle  Also not bad considering the Internet Connector
> License (which doesn't appear to exist anymore) used to go for
> $20,000.
>
> For more (accurate...) information, check out the SQL Server website
> - -- it's very nice.
>
> Best regards,
> Zac Bedell
>
> 
> Zachary S. Bedell,
> Chief Technology Officer,
> Adirondack Technologies, Inc.
>
> Please include original message in any replies -- I get a
> lot of email every day, and I have a REALLY bad memory...
> So I don't always remember everything that was said.
> Thanks!
>
>
>
>
>
> > -Original Message-
> > From: Paul Mone [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, November 16, 2000 2:45 PM
> > To: CF-Talk
> > Subject: RE: SQL Server Licesning
> >
> >
> > Any idea how much that runs?
> >
> > -Original Message-
> > From: Neil Clark [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, November 16, 2000 3:12 AM
> > To: CF-Talk
> > Subject: RE: SQL Server Licesning
> >
> >
> > yep you can get an unlimited internet connectivity license.
> >
> >  > Neil Clark
> > Senior Web Applications Engineer
> > mcb digital
> > Tel. +44 (0)20 8941 3232
> > Tel. +44 (0)20 8408 8131 [Direct]
> > http://www.mcbdigital.com
> > --->
> >
> >
> >
> > --
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe:
> > http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
> > message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> >
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe:
> > http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> > a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> >
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.8 for non-commercial use 
>
> iQA/AwUBOhVTTKvhLS1aWPxeEQIYWACfZYofoZOPMtWZMB1nMsSSbmrELicAoMiS
> 6PMNmbTTxcr9Zo/Q2WMzNMv6
> =Dx55
> -END PGP SIGNATURE-
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

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

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

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

Re: Can Application.cfm secure html files?

[Douglas Jordon]

Thanks. I was not looking forward to changing all those extensions...

Russel Madere wrote:
> 
> If your Cold Fusion is set to process htm and html files as well as cfm file
> throught the application server, then yes.  Otherwise, no.
> 
> The second behavior is actually useful in some ways.  If you need to have a
> login form page but do not want Cold Fusion to check if the user is logged
> in, make it an HTM page and CF will ignore it.
> 
> Russel
> 
> 
>   Russel Madere, Jr. Senior Web Developer
>   ICQ: 5446158   http://www.TurboSquid.com
> 
> Some days you eat the bear; some days the bear eats you.
> 
> 
> > -Original Message-
> > From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 17, 2000 11:58
> > To: CF-Talk
> > Subject: Can Application.cfm secure html files?
> >
> >
> > Maybe this is simple, but I'm not seeing it. Can I use Application.cfm
> > to secure html files or will it only secure .cfm?
> >
> > I'm being asked to implement security for mostly static html files for a
> > site in progress.
> >
> > TIA,
> >
> > Doug Jordon
> > ~~
> > Structure your ColdFusion code with Fusebox. Get the official
> > book at http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
> 
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

scaleability of

[[BOXoFUSES] Michael Slatoff]

I'm working on an inventory management system for a small subset of out
product database (only about 3k records compared to about 125k records).
When returning the recordset, I want to break it up into bite sized chunks.
Only problem is, using , the query is
still returning about 3k records and only displaying 25. If this thing ever
gets to the point where I need to keep track of the entire product list
(125k records), this is going to bog down things.

Is there a way in SQL to set a start row for a query? I know I can use 'set
rowcount 25' to only get 25 records, but I then need to start again at row
26.

Am I looking in the wrong place? Is there a different way of getting x
records and then next x records on the SQL side?

Oh, and I can't persist the data in a array of structures or wddx packet
because it is inventory that changes quickly and needs to be accurate on the
execution of the query.

Michael


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

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

OT: JS Script Permissions

[Tim Bahlke]

I posted this on the JS list but did not get much of a response.  Thought I 
would pass it along to y'all ...

I have a situation where I need scripts in one frame to access, as well as 
modify, properties in another frame, like obtain the other frame's location, 
history ...

When I try to access these properties in IE I get an 'access is denied' 
error.  Upon further reading I have come to discover that due to security 
reasons scripts cannot access these properties in other frames.

With Netscape, I can use Netscape Object Signing to gain access to these 
properties while IE uses Authenticode.  I have found detailed documentation 
on exactly the steps necessary to sign scripts in NN but have found nothing 
regarding script signing in IE (plenty of white papers on technet about 
signing ActiveX components but this is JS).

If anyone has encountered this before or knows of resources where I can get 
more information I would greatly appreciate some advice.

Thanks,

Tim Bahlke
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

Re: OT: SQL 7.0 Question

[Nick McClure]

It can be done, did you burn a backup or the actual data files?


If not, you need to create the database, then stop the SQL Services

Now you need to copy all the files, the database and the transaction files, 
to the directories. and name them the exact names as the new ones are 
named. Then start the SQL Server.

Bring up Enterprise Manager and check the data.

It should be fine.

At 02:28 PM 11/17/2000 -0500, you wrote:
>I know this is a very newbie-like question, but I'm
>stuck all the same.  I had SQL Server 7.0 installed on
>my machine, and I had to nuke my HD and re-install
>every last weekend.  I burned my Data directory to
>a CD before I formatted.  Now, I've re-installed
>SQL, but I need to know how to get those files from
>the CD to be recognized by the server.  If anyone can
>help me, I would really appreciate it.  Thanks in advance.
>
>
>Scott Wolf
>Goodfriend Computer Training
>5459 Fruitville Rd.
>Sarasota, FL 34232
>
>Phone: 941-365-4769  ext 106
>Fax: 941-342-4332
>E-mail: [EMAIL PROTECTED]
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

--
Nick McClure[EMAIL PROTECTED]
Technical Director  859.245.9656
squareFish Mediawww.squareFish.com

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

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

Creating text boxes on the fly

[lmcelro]

I'm not sure how to phrase this but here goes:
I have a form that requires lots and lots of text boxes, all of the text
boxes are not always needed so I would like to create these text boxes on
the fly.
Right now all of the text boxes show and the form is so long, it
confuses the user. I am sure that I can send the needed info from a form
that will contain all the  fieldnames and how many boxes are needed, if I
need 5 text boxes I would need to append the numbers 1 - 5 onto the
fieldname, and have 5 text boxes created using those 5 fieldnames. If
someone could point me in the right direction I would be most grateful.

Thanks,
Linda McElroy
Web Designer
Sears Direct Response

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

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

RE: Protecting Proprietary Content

[Paul Mone]

Do the interface in Flash 5 would be a good start.

-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 7:44 AM
To: CF-Talk
Subject: Protecting Proprietary Content


I have a client who wants to  provide training for his "system", his system
being a method to perform a service that is totally different then his
competition. He wants his training to be multimedia computer based, and was
planning on doing this totally on the internet in order to maintain control
of the contents.

I want to lessen the bandwidth requirements and make the program run from a
CD with the only way to get to the data and run the program to be by logging
onto the website with your name/password and receiving a one time code that
will only be valid for that session. The program will submit the answers to
the questions asked during the session to the site and be logged under that
users record for grading purposes.

Now that I have said all that, do any of you have any suggestions as to what
technology I could utilize to accomplish this, keeping in mind I do not want
to leave any files that could be copied off the client either during or
after the session is over?

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

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

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

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

RE: SQL 7.0 Question

[Gary Davidson]

lookup sp_attach_db in BOL. 

It may not work if sp_detach_db was not used.




-Original Message-
From: Scott Wolf [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 2:28 PM
To: CF-Talk
Subject: OT: SQL 7.0 Question


I know this is a very newbie-like question, but I'm
stuck all the same.  I had SQL Server 7.0 installed on
my machine, and I had to nuke my HD and re-install
every last weekend.  I burned my Data directory to
a CD before I formatted.  Now, I've re-installed
SQL, but I need to know how to get those files from
the CD to be recognized by the server.  If anyone can
help me, I would really appreciate it.  Thanks in advance.


Scott Wolf
Goodfriend Computer Training
5459 Fruitville Rd.
Sarasota, FL 34232

Phone: 941-365-4769  ext 106
Fax: 941-342-4332
E-mail: [EMAIL PROTECTED]

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: How to grab login info from LDAP

[Michael Thomas]

Here is the link: http://www.geocities.com/SoHo/Coffeehouse/7184/cf1.html


>From: "S R" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: How to grab login info from LDAP
>Date: Fri, 17 Nov 2000 10:49:11 PST
>
>This was a problem I faced before and was never able to solve it. I have an
>intranet where people login, via IIS from an LDAP. I may be using the wrong
>terminology but in laymans terms, a little gray login box appears asking 
>for
>my username and password, I know for sure the info is being authenticated
>against an LDAP. My problem is I need to somehow grab that login name to 
>set
>a session variable to customize the rest of my pages on my site based on 
>who
>the user is. It would be cool if I could create my own login page where CF
>can pull the user info from the LDAP and I can go from there, but I don't
>think these my Info Systems people are going to let me do that for 
>'security
>reasons'. Is there any way to do this?
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

RE: SQL 7.0 Question

[Adrian Cesana]

You should be able to do an ATTACH in sql7.  Will be something like this,
but you should look it up and check as there are more options available I
believe.

sp_attach_db @dbname = N'Your_DB_Name_Here',
@filename1 = N'd:\data\mydb.mdf',
@filename2 = N'e:\trans\mydb.ldf'
GO


Also, when you copy thing off your CD they will be in Read-Only mode, so you
should change that.

Hope it helps,Adrian





-Original Message-
From: Scott Wolf [mailto:[EMAIL PROTECTED]]

I know this is a very newbie-like question, but I'm
stuck all the same.  I had SQL Server 7.0 installed on
my machine, and I had to nuke my HD and re-install
every last weekend.  I burned my Data directory to
a CD before I formatted.  Now, I've re-installed
SQL, but I need to know how to get those files from
the CD to be recognized by the server.  If anyone can
help me, I would really appreciate it.  Thanks in advance.


Scott Wolf

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

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

Re: How to grab login info from LDAP

[Michael Thomas]

Yup there sure is. I saw an excellent story from a guy about his experiences 
within cold fusion. One thing he covered wuz performing querys on an LDAP 
server. Ill find the link & reply again to this message with it. Its good 
reading & on top of that its on a geocities site!!! Ive always been a firm 
believer that you dont need to have your own dotcom to get some respect 
within the industry. ^_^


>From: "S R" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: How to grab login info from LDAP
>Date: Fri, 17 Nov 2000 10:49:11 PST
>
>This was a problem I faced before and was never able to solve it. I have an
>intranet where people login, via IIS from an LDAP. I may be using the wrong
>terminology but in laymans terms, a little gray login box appears asking 
>for
>my username and password, I know for sure the info is being authenticated
>against an LDAP. My problem is I need to somehow grab that login name to 
>set
>a session variable to customize the rest of my pages on my site based on 
>who
>the user is. It would be cool if I could create my own login page where CF
>can pull the user info from the LDAP and I can go from there, but I don't
>think these my Info Systems people are going to let me do that for 
>'security
>reasons'. Is there any way to do this?
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

RE: PCodeDocumentNodeImp::validateSelf

[Michael Thomas]

Yes indeed it wuz, the database has a couple hundred links but a narrow that 
down into fields, so id say maybe 10 at a given time, give or take 1 or 2.


>From: "Paul Mone" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: PCodeDocumentNodeImp::validateSelf
>Date: Fri, 17 Nov 2000 11:31:19 -0800
>
>Was that custom tag calling cfhttp alot?
>
>-Original Message-
>From: Michael Thomas [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 17, 2000 3:02 AM
>To: CF-Talk
>Subject: Re: PCodeDocumentNodeImp::validateSelf
>
>
>As far as PCode goes, I have ran into my own lil scraps with that. It
>happened within a custom tag that manages my links database. Restarting the
>server (which is 4.5.1) did the trick, but on occasion that ugly error does
>rare its head. I once had this task scheduled but for that very reason it 
>no
>longer is.
>
>
> >From: David Cummins <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: Re: PCodeDocumentNodeImp::validateSelf
> >Date: Fri, 17 Nov 2000 11:45:55 +1300
> >
> >If it causes problems with them, then how are you supposed to use 
>Unicode?
> >That's what nvarchars are for...
> >
> >Paul Mone wrote:
> > >
> > > Yeah, I stay away from nvarchar, etc. for the same reason.  What is 
>the
> > > benefit of using nvarchar over varchar (if any).  i.e. why does it
> >exist?
> > >
> > > -Original Message-
> > > From: Michael Ross [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, November 15, 2000 12:14 PM
> > > To: CF-Talk
> > > Subject: Re: PCodeDocumentNodeImp::validateSelf
> > >
> > > I got the pcode error when my variables in SQL 7.0 were nvarchar, 
>ntext
> >and
> > > such.  Once I changed them(varchar, text) it worked.
> > >
> > > thanks
> > >
> > > >>> [EMAIL PROTECTED] 11/12/00 08:36PM >>>
> > > On 11/13/00, David Cummins penned:
> > > >I've seen it once before. Damned if I know - I think its an internal
> >error.
> > > >
> > > >BTW, does anybody know how to find anything on the Allaire site? I 
>hear
> > > >references to a search that works properly, but I've never seen a
> > > >description of
> > > >a PCode error yet on their site.
> > >
> > > The only thing I found in the knowledge base basically said there's
> > > no way to determine what they are. You can do some things that will
> > > help you guess, and do some registry hacks in 4.51 that will cause CF
> > > server to restart. But I'm using 4.01 since 4.51 is such crap. I just
> > > restarted CF server and it went away. I'm using the same custom tag,
> > > that the PCode message said caused the error, under multiple sites
> > > and it only happened on the one, so it seems to be a random thing.
> > > --
> > >
> > > Bud Schneehagen - Tropical Web Creations
> > >
> > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > > ColdFusion Solutions / eCommerce Development
> > > [EMAIL PROTECTED]
> > > http://www.twcreations.com/
> > > 954.721.3452
> > >
> >---
>-
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> >send a
> > > message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
> > >
> > >
> >---
>-
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> >send a
> > > message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
> > >
> > >
> >---
>-
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> >send a message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
> >
> >--
> >David Cummins
> >Systems Developer
> >Ubiquity Software Ltd.
> >Ph: (09) 309-1921
> >~~
> >Structure your ColdFusion code with Fusebox. Get the official book at
> >https://secure.houseoffusion.com
> >
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>~~
>Struct

Fw: OT RE: Certification Exam

[J.Milks]

I agree with Jeremy. I wrote the exam, but must admint that I did so only
because it was free. As for knowledge, if you have been kicking CF around
for a while, it should not be an issue. Does it guage if you are a master,
or even advanced? I don't think so. It was quite basic.

James

- Original Message -
From: "Jeremy Allen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 2:10 PM
Subject: OT RE: Certification Exam


> Well since were all being opinionated ill speak along
> the same lines as Simon.
>
> I do not believe in tests such as the Allaire Certification,
> MCSE, Brainbenc, Multiple guess tests, plain and simple.
>
> A test like this will do very little to gauge anything as
> you guys have mentioned but your ability to memorize something.
> Whats the point?
>
> Here is my example.
> Two people:
> Person A.) One fails the CF exam due to test anxiety/little working
> knowledge
> of ColdFusion
>
> Person B.) Another person passes the CF Exam with flying colors, studied
> just
> a little the night before the test.
>
> I think the failure in the exam does NOT mean you cannot accomplish
> a particular task without assisstance. Person A with a book in front of
him
> or
> her could work twice as fast as Peron B with just a little visiaul clues
> and the manual with them to figure out exact particulars on Syntax or
> exactly
> how this particular CF tag interacts with a protocol person A is
intimately
> familiar with.
>
> Does the CF Exam prove that the person gets how everything fits toghether?
> From the Kernel of the operating system on up to the final presentation of
> a CF Generated HTML page? I dont think so.
>
> I think you can ask questions that can illustrate very crudely at best
> someones problem solving skills (with multiple guess). I think essay style
> questions graded by very experienced and knowledgeable programmers (which
> would make the cost of the test prohibitive to say the least) is a much
> better gauge of a programmer.
>
> Sit someone in a room, give them three hours and all the reference
material
> to CF they usually use, assign them a particular task, review the code and
> overall structure and coherency of their particular method of solving the
> problem.
>
> In those three hours you can gauge more about someones programming skill
> than any multiple guess test is going to. Again there is still the fact
> that some people just perform miserably under pressure like that.. but
then
> again deadlines happen, a lot more often than they should.
>
> This is a really sore topic of mine. I take tests fine but I just dont see
> the point to all this certification malarky.  Honestly I cant be to sure
> I would want to work somewhere where something as easy to rig as the
> the Brainbench test is a factor for deciding if I am hired.
>
> Taking the CF Exam can be a "good" thing if you want to say that your shop
> has
> "xyz" Certified Developers or whatever, if its free of cost to you.. might
> as well. I cant see even in the most highly regarded jobs how
certification
> can be negative. Not needed, likely. Negative, I dont think so :)
>
>
> Anyways...
>
> Jeremy Allen
> ElliptIQ Inc.
>
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

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

RE: CFincludes and SQL Queries <-SIMPLE QUESTION!

[Paul Mone]

You can always put the  tags in the inlcude file as well.

-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 5:28 AM
To: CF-Talk
Subject: CFincludes and SQL Queries <-SIMPLE QUESTION!


If I embed a SQL query inside a CFQUERY my variables don't get processed:

   
 
   


The query is:

Select Username
 From Users
Where Username = '#form.username#'


Am I doing something wrong, or is this normal for CF not to process
CFincludes inside CFqueries?

--
Michael She
I m a g i n e   C o m m u n i c a t i o n s
Company E-mail: [EMAIL PROTECTED]
Personal E-mail: [EMAIL PROTECTED]
ICQ UIN: #243466
Personal Homepage: http://www.michaelshe.com (Under Construction)
Imagine Communications: http://www.imagineer.net
PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1

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

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

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

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

RE: Novell Advanced Security Woes

[Kevin Miller]

Here is the LDAP tag that I use to authenticate users against NDS
LDAP:



Basically, I query for the user using the user's username and password
as credentials.  Note that you should wrap this in a CFTRY because if
the account is disabled or the password has expired, the tag will fail
with an error.  If the user is not found, the query comes back empty.

The #Username# variable must be fully qualified using LDAP
terminology:

cn=username,ou=containter1,ou=container2,o=mycompany

Notice the commas rather than the periods separating the components.

Good luck,

Kevin


-Original Message-
From: Norman Elton [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 16, 2000 9:24 PM
To: CF-Talk
Subject: RE: Novell Advanced Security Woes


Kevin-

If you could detail how you accomplish this, many (MANY) developers
would be
most appreciative!

Do you authenticate off of GroupWise, or straight to NDS?

I'm not a Novell guy, so I don't know all the inner workings, but I
have
definitely struggled to authenticate Novell passwords.

Thanks!

Norman Elton
Information Technology
College of William & Mary

-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 16, 2000 11:51 AM
To: CF-Talk
Subject: RE: Novell Advanced Security Woes



I don't use Advanced Security, but I have and do authenticate to
Novell's LDAP server via the CFLDAP tag.

Kevin

Kevin Miller
Vascular Chief Technologist
Medtronic Vascular
[EMAIL PROTECTED]
(707) 566-1200

>>> [EMAIL PROTECTED] 11/15/00 12:10PM >>>
I know that if you want to do a look up to NDS with cfldap you can.
But you can't authenticate to it.  Allaire has never tested it and
they
say it won't work.  The built it for Netscape DS.  The siteminder
piece
doesn't recognize Novell DS.  I got your same problem some time ago
and
opened a ticket.and nothing..doesn't work...You can verify the
connection and it works, but if you were to go to your policy and
check
the users your shouldn't see anything...
sorry...

Now should anyone have successfully auth against Novell DS, using cf
4.5.1, and advanced security please lets talk.

Thanks



>>> [EMAIL PROTECTED] 11/06/00 10:32AM >>>
Yes, I should have mentioned Rick's tool. I was going down the CF
specific
route but, Rick's tool can solve your problem too.

Steve


-Original Message-
From: Rick Osborne [Mojo] [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 06, 2000 1:06 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] 
Subject: RE: Novell Advanced Security Woes


FYI, I wrote an ISAPI DLL for IIS to do pretty much exactly what Steve
talks
about at the end there.  It is completely free and comes with source.
It is
available at:

http://www.rixsoft.com/NWAuth/ 

Of course, it means that IIS does the authentication instead of CF,
but
that
may be good or bad depending on your situation.

-Original Message-
From: Steve Bernard [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, November 04, 2000 22:41
To: CF-Talk
Subject: RE: Novell Advanced Security Woes


With native CF capability you'll have to use CFLDAP to query NDS' LDAP
interface directly. This doesn't allow you to use NDS as your AS
repository
but, it's better than nothing. You could try hand building the schema
in
NDS. Another option is to use native OS authentication/authorization
but,
have that redirected to NDS. Like using Client32 for NT.

Steve




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



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



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


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

~~
Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com 

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

~~
Structure your ColdFusion code 

Re: SQL Server Licesning

[Jim McAtee]

Even though the substantial connector price increase is unwelcome, the
changes in the licensing scheme make perfect sense and greatly simplify the
licensing.  It's no long an 'Internet Connector' license, just a 'Processor'
license and permits you to simply license the server per processor, without
consideration of whether users are situated on the LAN, whether they're
employees or contractors, or connecting through middleware, etc.  This was a
major source of confusion with SQL 7 licensing.  This is also probably their
reason for the price increase, since they would no longer require the
purchase of CALs.  Someone using SQL for just for web site hosting gets
shafted though, since he wasn't purchasing any CALs.

<<
Licensing Options
Processor
Under this new structure, a customer acquires a Processor License for each
processor of the server running the SQL Server software. A Processor License
includes access for an unlimited number of users to connect from either
inside the corporate large area network (LAN) or wide area network (WAN) or
outside the firewall. Customers do not need to purchase additional Server
Licenses, Client Access Licenses, or Internet Connector Licenses.
>>

Jim


- Original Message -
From: "Zachary Bedell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 11:02 AM
Subject: RE: SQL Server Licesning


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Actually, the standard edition is quite fine for most website tasks.
>
> For a comparison of the different editions, check out:
> http://www.microsoft.com/sql/productinfo/sqlcompdata.htm
>
> Basically the difference between Enterprise & Standard is that
> Standard can't do clustering, can't do server failover, and a few
> other heavy features.  You'd certainly want them if you were starting
> the next EBay or Amazon, but for general site hosting, Standard
> should definately get the job done.
>
> I'll definately agree with you that per CPU licensing is a crock,
> tho...
>
> Regards,
> Zac Bedell
>
> > That ain't quite correct. I think if you want to do anything
> > beyond limited
> > SQL, you'll end up needing the $20K/cpu Enterprise Edition of
> > SQL, which is
> > comparable to Oracle.
> >
> > Either way, I think $20K/cpu is a miserable ripoff. In our
> > instance, I have
> > a quad-processor SQL box, but the processors are 200mhz. Why
> > should I pay
> > $80K for a license when a single-CPU 1ghz box would perform
> > so much better,
> > and cost only $20K in licensing?
> >
> > Moral? Per-CPU licensing is flawed.
> >
> > Alan McCollough
> > Web Programmer
> > Allaire Certified ColdFusion Developer
> > Alaska Native Medical Center
> >
> > > -Original Message-
> > > From: Zachary Bedell [SMTP:[EMAIL PROTECTED]]
> > > Sent: Friday, November 17, 2000 6:48 AM
> > > To: CF-Talk
> > > Subject: RE: SQL Server Licesning
> > >
> > > -BEGIN PGP SIGNED MESSAGE-
> > > Hash: SHA1
> > >
> > > Well...  Looks like M$ has changed their licensing strategy
> > > again, but...  Looking at the info from
> > > http://www.microsoft.com/sql/productinfo/pricing.htm, you're
> > > looking at $5000 per processor for unlimited user licenses.  Not
> > bad compared
> > > to Oracle  Also not bad considering the Internet Connector
> > > License (which doesn't appear to exist anymore) used to go for
> > > $20,000.
> > >
> > > For more (accurate...) information, check out the SQL Server
> > > website - -- it's very nice.
> > >
> > > Best regards,
> > > Zac Bedell
> > >
> > >
> > > > -Original Message-
> > > > From: Paul Mone [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, November 16, 2000 2:45 PM
> > > > To: CF-Talk
> > > > Subject: RE: SQL Server Licesning
> > > >
> > > >
> > > > Any idea how much that runs?
> > > >
> > > > -Original Message-
> > > > From: Neil Clark [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, November 16, 2000 3:12 AM
> > > > To: CF-Talk
> > > > Subject: RE: SQL Server Licesning
> > > >
> > > >
> > > > yep you can get an unlimited internet connectivity license.
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.8 for non-commercial use 
>
> iQA/AwUBOhVytqvhLS1aWPxeEQLaMgCg7TyexQlBJ22Y9rA778EBjNItudgAnjJt
> aec4NyL3t3Ujh1AgifMWrJXa
> =FhWT
> -END PGP SIGNATURE-
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

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

RE: PCodeDocumentNodeImp::validateSelf

[Paul Mone]

Was that custom tag calling cfhttp alot?

-Original Message-
From: Michael Thomas [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 3:02 AM
To: CF-Talk
Subject: Re: PCodeDocumentNodeImp::validateSelf


As far as PCode goes, I have ran into my own lil scraps with that. It
happened within a custom tag that manages my links database. Restarting the
server (which is 4.5.1) did the trick, but on occasion that ugly error does
rare its head. I once had this task scheduled but for that very reason it no
longer is.


>From: David Cummins <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: PCodeDocumentNodeImp::validateSelf
>Date: Fri, 17 Nov 2000 11:45:55 +1300
>
>If it causes problems with them, then how are you supposed to use Unicode?
>That's what nvarchars are for...
>
>Paul Mone wrote:
> >
> > Yeah, I stay away from nvarchar, etc. for the same reason.  What is the
> > benefit of using nvarchar over varchar (if any).  i.e. why does it
>exist?
> >
> > -Original Message-
> > From: Michael Ross [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 15, 2000 12:14 PM
> > To: CF-Talk
> > Subject: Re: PCodeDocumentNodeImp::validateSelf
> >
> > I got the pcode error when my variables in SQL 7.0 were nvarchar, ntext
>and
> > such.  Once I changed them(varchar, text) it worked.
> >
> > thanks
> >
> > >>> [EMAIL PROTECTED] 11/12/00 08:36PM >>>
> > On 11/13/00, David Cummins penned:
> > >I've seen it once before. Damned if I know - I think its an internal
>error.
> > >
> > >BTW, does anybody know how to find anything on the Allaire site? I hear
> > >references to a search that works properly, but I've never seen a
> > >description of
> > >a PCode error yet on their site.
> >
> > The only thing I found in the knowledge base basically said there's
> > no way to determine what they are. You can do some things that will
> > help you guess, and do some registry hacks in 4.51 that will cause CF
> > server to restart. But I'm using 4.01 since 4.51 is such crap. I just
> > restarted CF server and it went away. I'm using the same custom tag,
> > that the PCode message said caused the error, under multiple sites
> > and it only happened on the one, so it seems to be a random thing.
> > --
> >
> > Bud Schneehagen - Tropical Web Creations
> >
> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > ColdFusion Solutions / eCommerce Development
> > [EMAIL PROTECTED]
> > http://www.twcreations.com/
> > 954.721.3452
> >
>---
-
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
>send a
> > message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
> >
> >
>---
-
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
>send a
> > message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
> >
> >
>---
-
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
>send a message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
>
>--
>David Cummins
>Systems Developer
>Ubiquity Software Ltd.
>Ph: (09) 309-1921
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at
>https://secure.houseoffusion.com
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

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

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

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

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

OT: SQL 7.0 Question

[Scott Wolf]

I know this is a very newbie-like question, but I'm
stuck all the same.  I had SQL Server 7.0 installed on
my machine, and I had to nuke my HD and re-install
every last weekend.  I burned my Data directory to
a CD before I formatted.  Now, I've re-installed
SQL, but I need to know how to get those files from
the CD to be recognized by the server.  If anyone can
help me, I would really appreciate it.  Thanks in advance.


Scott Wolf
Goodfriend Computer Training
5459 Fruitville Rd.
Sarasota, FL 34232

Phone: 941-365-4769  ext 106
Fax: 941-342-4332
E-mail: [EMAIL PROTECTED]

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

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

RE: Can Application.cfm secure html files?

[Nick McClure]

This can be done but generally I would rename the files in the site to .cfm.

This way you are not wasting the cfserver processing files that shouldn't be.

Also in the future if you did add some cf to these files the names would 
already make sense.



At 01:00 PM 11/17/2000 -0600, you wrote:
>If you set up.html files to be processed like .cfm files Application.cfm
>will protect them.
>http://www.infranet.com/ProcessHTMAsCFM.htm
>
>Dave
>
>-Original Message-
>From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 17, 2000 11:58 AM
>To: CF-Talk
>Subject: Can Application.cfm secure html files?
>
>
>Maybe this is simple, but I'm not seeing it. Can I use Application.cfm
>to secure html files or will it only secure .cfm?
>
>I'm being asked to implement security for mostly static html files for a
>site in progress.
>
>TIA,
>
>Doug Jordon
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

--
Nick McClure[EMAIL PROTECTED]
Technical Director  859.245.9656
squareFish Mediawww.squareFish.com

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

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

OT RE: Certification Exam

[Jeremy Allen]

Well since were all being opinionated ill speak along
the same lines as Simon.

I do not believe in tests such as the Allaire Certification,
MCSE, Brainbenc, Multiple guess tests, plain and simple.

A test like this will do very little to gauge anything as
you guys have mentioned but your ability to memorize something.
Whats the point?

Here is my example.
Two people:
Person A.) One fails the CF exam due to test anxiety/little working
knowledge
of ColdFusion

Person B.) Another person passes the CF Exam with flying colors, 
studied
just
a little the night before the test.

I think the failure in the exam does NOT mean you cannot accomplish
a particular task without assisstance. Person A with a book in front of him
or
her could work twice as fast as Peron B with just a little visiaul clues
and the manual with them to figure out exact particulars on Syntax or
exactly
how this particular CF tag interacts with a protocol person A is intimately
familiar with.

Does the CF Exam prove that the person gets how everything fits toghether?
>From the Kernel of the operating system on up to the final presentation of
a CF Generated HTML page? I dont think so.

I think you can ask questions that can illustrate very crudely at best
someones problem solving skills (with multiple guess). I think essay style
questions graded by very experienced and knowledgeable programmers (which
would make the cost of the test prohibitive to say the least) is a much
better gauge of a programmer.

Sit someone in a room, give them three hours and all the reference material
to CF they usually use, assign them a particular task, review the code and
overall structure and coherency of their particular method of solving the
problem.

In those three hours you can gauge more about someones programming skill
than any multiple guess test is going to. Again there is still the fact
that some people just perform miserably under pressure like that.. but then
again deadlines happen, a lot more often than they should.

This is a really sore topic of mine. I take tests fine but I just dont see
the point to all this certification malarky.  Honestly I cant be to sure
I would want to work somewhere where something as easy to rig as the
the Brainbench test is a factor for deciding if I am hired.

Taking the CF Exam can be a "good" thing if you want to say that your shop
has
"xyz" Certified Developers or whatever, if its free of cost to you.. might
as well. I cant see even in the most highly regarded jobs how certification
can be negative. Not needed, likely. Negative, I dont think so :)


Anyways...

Jeremy Allen
ElliptIQ Inc.


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

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

Intranets and PCDOCs DocsOpen

[Eric Dawson]

http://www.hummingbird.com/products/dkm/csdm/open/index.html

I am interested in learning how people are integrating PCDocs DocsOpen with 
Cold Fusion on an intranet.

Specifically publishing links to documents on the intranet. ie a news 
article application that allows for related Document links to appear. on the 
right hand side of the article.

Eric
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

RE: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP

[Rif Kiamil]

This is what I do when I want to query OLAP from CF.

Make a LinkServer from MS SQL Server to MS OLAP Server. The setting are :

Provider Name   : Microsoft OLE DB Provider for OLAP
Product Name: MSOLAP
Datesource  : 
Provider string :
Location: 
Catalog : 

Onces that is done you can us the OPENQUERY from a normal SQL query. But you
must turn quted_identifier ON. 

e.g. 

-- START --

set quoted_identifier on
SELECT  o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
Type].[MEMBER_CAPTION]" AS R
FROMOPENQUERY(OLAP_TEST, '
select
{Measures.[Unit Sales]} on columns, 
order(except([Promotion Media].[Media Type].members,{[Promotion
Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
from Sales
') 

as o
set quoted_identifier off


-- END --


>From Rif

PS I have not test this query!

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2000 16:54
To: CF-Talk
Subject: PLEASE HELP--Querying Olap Cube Through MDX and CF--PLEASE HELP


 Hello,  I am attempting to query an Olap Cube through using MDX through CF.
I am using a com object and can see the cube but am unable to get any data
from it.  I used a custom tag to see what was being returned and all that is
returned is a space.  I was told by Ben Forta that I would need to play with
the com object so that CF would understand the output.  Any suggestions?!?
The following code runs with no errors, (unless I have made an error in my
expression) but there is only a space in the output.

Thanks,
Eddie






Cube Test









 









The variable is  empty.






Results:




#cst#



Your mdx query is:


#smdx#







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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Can Application.cfm secure html files?

[David Livingston]

If you set up.html files to be processed like .cfm files Application.cfm
will protect them.
http://www.infranet.com/ProcessHTMAsCFM.htm

Dave

-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 11:58 AM
To: CF-Talk
Subject: Can Application.cfm secure html files?


Maybe this is simple, but I'm not seeing it. Can I use Application.cfm
to secure html files or will it only secure .cfm?

I'm being asked to implement security for mostly static html files for a
site in progress.

TIA,

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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Allaire Forums and Frames

[Rosa, Issac]

I have a page that is loading Forums in a frameset (topFrame and Contents).
When I click a link on the topnav.htm which is the top frame, instead of
populating the contents frame, it spawns a new page.  Anyone have any
solutions or suggestions?

In topnav.htm, I have the links as follows:
http://www.currentanalysis.com/partners/att/eventsmain.cfm"
onMouseOut="MM_swapImgRestore()"
onMouseOver="MM_swapImage('Image12','','images/navbars/n_it_1.gif',1)"
target="contents">

If you have any questions or concerns, please feel free to call me at
407-514-5021.

Thank you,

> Issac Rosa
> 
> IT - National Sales & Marketing
> OLAP Specialist Team Leader
> Ofc: 407-514-5021
> Cell: 407-342-0644
> Fax: 407-514-5988
> [EMAIL PROTECTED]
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Protecting Proprietary Content

[Larry C. Lyons]

Terry,

You may want to look at something like ClickToLearn Toolbook or
Macromedia Authorware. Both allow for database access, content
protection and can be run off the web. They both have a lot of wizards
and preprogrammed objects that make developing web based learning apps
easier. However with both they require you to learn another language -
both are fairly easy however. 

larry

Terry Troxel wrote:
> 
> I have a client who wants to  provide training for his "system", his system
> being a method to perform a service that is totally different then his
> competition. He wants his training to be multimedia computer based, and was
> planning on doing this totally on the internet in order to maintain control
> of the contents.
> 
> I want to lessen the bandwidth requirements and make the program run from a
> CD with the only way to get to the data and run the program to be by logging
> onto the website with your name/password and receiving a one time code that
> will only be valid for that session. The program will submit the answers to
> the questions asked during the session to the site and be logged under that
> users record for grading purposes.
> 
> Now that I have said all that, do any of you have any suggestions as to what
> technology I could utilize to accomplish this, keeping in mind I do not want
> to leave any files that could be copied off the client either during or
> after the session is over?
> 
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

-- 
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

How to grab login info from LDAP

[S R]

This was a problem I faced before and was never able to solve it. I have an 
intranet where people login, via IIS from an LDAP. I may be using the wrong 
terminology but in laymans terms, a little gray login box appears asking for 
my username and password, I know for sure the info is being authenticated 
against an LDAP. My problem is I need to somehow grab that login name to set 
a session variable to customize the rest of my pages on my site based on who 
the user is. It would be cool if I could create my own login page where CF 
can pull the user info from the LDAP and I can go from there, but I don't 
think these my Info Systems people are going to let me do that for 'security 
reasons'. Is there any way to do this?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

Re: Can Application.cfm secure html files?

[Lee Surma]

>Maybe this is simple, but I'm not seeing it. Can I use Application.cfm
>to secure html files or will it only secure .cfm?
>
>I'm being asked to implement security for mostly static html files for a
>site in progress.
>

Application.cfm will work if you change your Web server mappings to to process all 
.html as ColdFusion. In IIS go to Properties/Home Directory/application 
settings/configuration and make the .html the same as .cfm.

_
Lee Surma
Public Radio International
[EMAIL PROTECTED]
612-330-9223
_



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

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

RE: restarting Unix cf server

[Jason Egan]

thank you so much, this was the ticket... our admin didn't know about that,
and he hordes the server books... crazy... thanks!

je

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 9:37 AM
To: CF-Talk
Subject: RE: restarting Unix cf server


Solaris:
/opt/coldfusion/bin/stop
/opt/coldfusion/start

NT:
net stop "Cold Fusion Application Server"
net start "Cold Fusion Application Server"


Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com


-Original Message-
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 6:28 PM
To: CF-Talk
Subject: restarting Unix cf server


I am looking for the NT command line equivalent to restarting a Unix version
of cf server.

We are running:

 Version 4, 5, 1, SP1
 Edition Enterprise
 Operating System UNIX
 OS Version 5.7, SunOS



Thank you,
Jason

~~
Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com

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


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

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

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

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

RE: How to prevent BACK and FORWARD button from clicked?

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>I have created a critical web based application which is not
>  allowed the user to press BACK and FORWARD button in order to 
> prevent 
> data integrity.
> 
> How do we disable the BACK button using CF, instead of using 
> Javascript history.back() ?
> 
> Another way is using session struct to record each template ID.
> 
> Can we implement more efficient way to do it?
> Thanks in advance.

The short answer is that you can't disable the back button and that
your code is flawed if it requires you to do so.

Basically, disabling or messing with basic browser functionality is a
dirty trick that ticks off most websurfers.  It's not something I'd
even think about doing.

If you still feel an overwhelming need to tick off your customers,
then have a look at:
http://www.4guysfromrolla.com/webtech/111500-1.shtml

Honestly, you'd be much better off altering your code so that it's
back button friendly.  You need to make sure that every page you
present to your user CAN be reloaded without causing any problems. 
The way to do that is to move any processing or data storage off the
pages you send to your users.  

Here's one way:
Say you have a series of steps the user has to go through.  Let's
call them Step1.cfm through Step12.cfm.  If you have Step1.cfm submit
to Step2.cfm, then there would have to be processing code in
Step2.cfm that could be messed up by hitting BACK.  

If you instead have Step1.cfm submit to Step1Proc.cfm, do all of your
processing, then CFLOCATION to Step2.cfm, then all of your processing
was handled off the page that the user can see.  At that point, your
user could sit and reload Step2.cfm all day without any problems.

If in addition to all of that, you make sure that any processing on
your Proc pages is reentrant (for lack of a better term), your users
could backup at any point with no problems.  By reentrant, I mean
that any actions you do should be able to be repeated without
problems.  Either update temporary DB entries or use Session
variables, then commit the whole mess at the end of the process. 
THEN if you make Steps 2 through 12 check to see if the temporary
table or sessions vars are present, you could even make those pages
say something like "Sorry, you can't come back," after the final
commit process is completed.

Hope that's helpful.

Best regards,
Zac Bedell



Zachary S. Bedell,
Chief Technology Officer,
Adirondack Technologies, Inc.

Please include original message in any replies -- I get a 
lot of email every day, and I have a REALLY bad memory... 
So I don't always remember everything that was said.  
Thanks!

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOhV4WavhLS1aWPxeEQJ6ugCgugTyoFomHWg/mLJ1kXoUWroyg3QAnjCe
4enup45j2Dqz6kZxe0zuJln2
=hPAu
-END PGP SIGNATURE-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Can Application.cfm secure html files?

[Russel Madere]

If your Cold Fusion is set to process htm and html files as well as cfm file
throught the application server, then yes.  Otherwise, no.

The second behavior is actually useful in some ways.  If you need to have a
login form page but do not want Cold Fusion to check if the user is logged
in, make it an HTM page and CF will ignore it.

Russel


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

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



> -Original Message-
> From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 17, 2000 11:58
> To: CF-Talk
> Subject: Can Application.cfm secure html files?
>
>
> Maybe this is simple, but I'm not seeing it. Can I use Application.cfm
> to secure html files or will it only secure .cfm?
>
> I'm being asked to implement security for mostly static html files for a
> site in progress.
>
> TIA,
>
> Doug Jordon
> ~~
> Structure your ColdFusion code with Fusebox. Get the official
> book at http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>

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

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

RE: SQL advice please

[Gary Davidson]

Don't rule out views guys, they provide great management, security and
performance. SQL 2000 has added indexed and portioned views.

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 12:47 PM
To: CF-Talk
Subject: RE: SQL advice please


Yup use SP's wherever poss.

I tend not to use views either.  I build temp tables in the SP or just
incorporate it into the SQL statement using various joins

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



-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2000 17:43
To: CF-Talk
Subject: RE: SQL advice please


> Can someone explain, in general if possible when the best time to use
> SQL Server views/storedProdedures/triggers VS. CF Queries?

Use Stored Procedures wherever you can. They're usually quicker than
plain CF queries, sometimes enormously so, and help to modularise your
code, which is always good.

Triggers don't do much for you that SP's can't, but they're simpler.
Personally I'm not a big user of views.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Reading a file/cfhttp.filecontent line by line, or...

[Steve Bernard]

Depending on your affinity for Regular Expressions (RE), you may find some
advantages to use them. In this case you would use REFind[NoCase]() with the
optional "returnsubexpressions" parameter set to "true". I assume that you
already know some things about the string you are looking for. For instance,
you probably know the "name" attribute of the hidden form field, and you
know it must begin with "" following
that.

Steve


-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 10:40 AM
To: CF-Talk
Subject: RE: Reading a file/cfhttp.filecontent line by line, or...


Actually, figured it out doing that... and doing some other comparisons.

Thanks!

Lee


> -Original Message-
> From: Paul Mone [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 16, 2000 10:27 PM
> To: CF-Talk
> Subject: RE: Reading a file/cfhttp.filecontent line by line, or...
>
>
> CFHTTP.filecontent is a string.
>
> So, you can search using FindNoCase, which conveniently returns
> the index of
> the match found.  You can then offset this by whatever amount of
> characters
> you'll need to get your hidden field's value.  You'll probably
> need to find
> the end of your hidden field's tag as well, if the length of the field's
> value changes.
>
>
>
>
> -Original Message-
> From: Lee Fuller [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 16, 2000 4:52 PM
> To: CF-Talk
> Subject: Reading a file/cfhttp.filecontent line by line, or...
>
>
> I know that we've talked about this before, but I can't seem to
> remember how
> to do this.
>
> I need to find a specific string in the returned var of
> cfhttp.filecontent,
> then look ahead a certain number of positions, then pull out the remaining
> 10 characters.  Basically I'm going to be finding a hidden form field, and
> grabbing it's value from what's returned by cfhttp.
>
> Can anyone send me the info on how to do this?
>
> TTAIA!
>
>   Lee
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> https://secure.houseoffusion.com
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official
> book at https://secure.houseoffusion.com
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>

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

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

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

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

RE: SQL Server Licesning

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Actually, the standard edition is quite fine for most website tasks.

For a comparison of the different editions, check out:
http://www.microsoft.com/sql/productinfo/sqlcompdata.htm

Basically the difference between Enterprise & Standard is that
Standard can't do clustering, can't do server failover, and a few
other heavy features.  You'd certainly want them if you were starting
the next EBay or Amazon, but for general site hosting, Standard
should definately get the job done.

I'll definately agree with you that per CPU licensing is a crock,
tho...

Regards,
Zac Bedell

> That ain't quite correct. I think if you want to do anything 
> beyond limited
> SQL, you'll end up needing the $20K/cpu Enterprise Edition of 
> SQL, which is
> comparable to Oracle.
> 
> Either way, I think $20K/cpu is a miserable ripoff. In our 
> instance, I have
> a quad-processor SQL box, but the processors are 200mhz. Why 
> should I pay
> $80K for a license when a single-CPU 1ghz box would perform 
> so much better,
> and cost only $20K in licensing?
> 
> Moral? Per-CPU licensing is flawed.
> 
> Alan McCollough
> Web Programmer
> Allaire Certified ColdFusion Developer
> Alaska Native Medical Center
> 
> > -Original Message-
> > From:   Zachary Bedell [SMTP:[EMAIL PROTECTED]]
> > Sent:   Friday, November 17, 2000 6:48 AM
> > To: CF-Talk
> > Subject:RE: SQL Server Licesning
> > 
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> > 
> > Well...  Looks like M$ has changed their licensing strategy
> > again, but...  Looking at the info from
> > http://www.microsoft.com/sql/productinfo/pricing.htm, you're
> > looking at $5000 per processor for unlimited user licenses.  Not 
> bad compared
> > to Oracle  Also not bad considering the Internet Connector
> > License (which doesn't appear to exist anymore) used to go for
> > $20,000.
> > 
> > For more (accurate...) information, check out the SQL Server
> > website - -- it's very nice.
> > 
> > Best regards,
> > Zac Bedell
> > 
> > 
> > > -Original Message-
> > > From: Paul Mone [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, November 16, 2000 2:45 PM
> > > To: CF-Talk
> > > Subject: RE: SQL Server Licesning
> > > 
> > > 
> > > Any idea how much that runs?
> > > 
> > > -Original Message-
> > > From: Neil Clark [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, November 16, 2000 3:12 AM
> > > To: CF-Talk
> > > Subject: RE: SQL Server Licesning
> > > 
> > > 
> > > yep you can get an unlimited internet connectivity license.

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOhVytqvhLS1aWPxeEQLaMgCg7TyexQlBJ22Y9rA778EBjNItudgAnjJt
aec4NyL3t3Ujh1AgifMWrJXa
=FhWT
-END PGP SIGNATURE-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL advice please

[Stewart McGowan]

>From the SQL server books online.

Stew



"The benefits of using stored procedures in SQL Server rather than SQL
programs stored locally on client computers are: 

They allow modular programming. 
You can create the procedure once, store it in the database, and call it any
number of times in your program. Stored procedures can be created by a
person who specializes in database programming, and they can be modified
independently of the program source code. 

They allow faster execution. 
If the operation requires a large amount of Transact-SQL code or is
performed repetitively, stored procedures can be faster than batches of
Transact-SQL code. They are parsed and optimized when they are created, and
an in-memory version of the procedure can be used after the procedure is
executed the first time. Transact-SQL statements repeatedly sent from the
client each time they run are compiled and optimized every time they are
executed by SQL Server. 

They can reduce network traffic. 
An operation requiring hundreds of lines of Transact-SQL code can be
performed through a single statement that executes the code in a procedure,
rather than by sending hundreds of lines of code over the network. 

They can be used as a security mechanism. 
Users can be granted permission to execute a stored procedure even if they
do not have permission to execute the procedure's statements directly."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Certification Exam

[Michael Thomas]

Excellent post Simon, I agree with much that you have stated here. 
Especially in the fact that even though you pass the test, it doesnt mean 
that a given person can write efficient code (which is a huge issue). It 
doesnt mean that they can solve real life problems when confronted with 
them.

I have not taken the certification test given by allaire (Personally $150 
outta my pocket isnt too enticing.) but I know that the brainbench test lets 
you use outside materials when testing. Thats a pretty broad scope there, 
you could have a book open with your hand right on the index if you needed 
any quick answers, among other things. Are we testing how fast you can find 
the answer in a book???

With a couple of those things in mind I think you should use the tests as a 
measure of how far your abilities are coming along. In fact the test can be 
a nice confident booster in most cases but then again on the down side can 
be just the opposite for people who dwell on such things.

I think you mentioned something else that wuz important. The ability to read 
& understand the syntax of the code. This indeed is important in itself as 
it does demonstrate your given quick rationale in thinking & knowledge on 
the given subjects at hand but like you said doesnt illustrate that you can 
write good code.


>From: Simon Horwith <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Certification Exam
>Date: Fri, 17 Nov 2000 12:43:13 -0500
>
>I have been reading this thread, and just wanted to mention that neither 
>the
>allaire test, nor the brainbench test, actually means you have a clue how 
>to
>program in CF.  The allaire test seems to do a better (more thorough) job 
>of
>testing your understanding of web application architectures and
>implementations, and the brainbench test might do a better job testing your
>syntax knowledge and your ability to read code and know what it's doing
>but neither of these tests illustrate to me, that a person has the ability
>to write good code.  There's a huge difference between spitting out
>memorized answers, and actually using this knowledge in the real world.  
>The
>tests are nice things to say you've done, and they might make prospective
>employers and clients feel better, but like so many other tests out there,
>they're no substitute for experience and good practice.  If you feel you're
>experienced enough that the test doesn't or shouldn't matter, then you're
>probably ready to take it, and should take it, to emphasise your talents.
>If you don't feel that experienced... my advice is to get experienced 
>before
>taking the test... even if it's building apps on your laptop.
>Like I said, just my two cents.
>
>~Simon
>
> > Simon Horwith
> > Certified ColdFusion Developer
> > Fig Leaf Software
> > 1400 16th St NW, # 220
> > Washington DC 20036
> > 202.797.6570 (direct line)
> > www.figleaf.com
> >
>
>
>-Original Message-
>From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 17, 2000 12:26 PM
>To: CF-Talk
>Subject: RE: Certification Exam
>
>
>I wonder if the UK certified doodahs could give me an idea of the 
>advantages
>of certification?
>
>
>Kind Regards
>
>
>Stewart
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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

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

RE: Certification Exam

[Simon Horwith]

Like I said, while companies might like seeing it on your resume, if you
can't code, you can't code... and it won't take too long before a company
figures that out.  It's not better than nothing to have on your resume, but
it complements a list of URL's worked on, and/or sample code, very nicely.

~Simon

> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 


-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 12:45 PM
To: CF-Talk
Subject: RE: Certification Exam


My view really Simon, I really wondered what the people who had done the
exam 
as a ticket punching exercise had gained past a certificate (not that I'm in
anyway downgrading the exam or the people who have done it, I would struggle

to pass). Just that I see a lot of certified (and certifiable) candidates
for
employment and for me the certified candidates have proven to be no better 
or worse than the non-certified. My tuppence :)

Regards

Stew





>I have been reading this thread, and just wanted to mention that neither
the
>allaire test, nor the brainbench test, actually means you have a clue how
to
>program in CF.  The allaire test seems to do a better (more thorough) job
of
>testing your understanding of web application architectures and
>implementations, and the brainbench test might do a better job testing your
>syntax knowledge and your ability to read code and know what it's doing
>but neither of these tests illustrate to me, that a person has the ability
>to write good code.  There's a huge difference between spitting out
>memorized answers, and actually using this knowledge in the real world.
The
>tests are nice things to say you've done, and they might make prospective
>employers and clients feel better, but like so many other tests out there,
>they're no substitute for experience and good practice.  If you feel you're
>experienced enough that the test doesn't or shouldn't matter, then you're
>probably ready to take it, and should take it, to emphasise your talents.
>If you don't feel that experienced... my advice is to get experienced
before
>taking the test... even if it's building apps on your laptop.
>Like I said, just my two cents.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Can Application.cfm secure html files?

[Douglas Jordon]

Maybe this is simple, but I'm not seeing it. Can I use Application.cfm
to secure html files or will it only secure .cfm?

I'm being asked to implement security for mostly static html files for a
site in progress.

TIA,

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

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

RE: Netscape 6 and StyleSheets

[Sandra Clark]

Also something I found out the hard way. Don't use underscores in class
names.  eg. Not Text_black NS 4.7 and IE use them. NS 6 does not. Use a CSS
style checker and set it for CSS1.  That helps. NS6 is not only CSS1
compliant (mostly) but extremely picky, like the rest of it.

-Original Message-
From: Xing Li [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 11:44 AM
To: CF-Talk
Subject: OT: Netscape 6 and StyleSheets


Although not CF related many of us use stylesheets everyday so I thought
this might save some of you headaches come support time.

Netscape 6 is case sensitve when it comes to style class declarations and
usage. Netscape 4.7 and IE are not case sensitive when it comes to style
class names.

For a dummy text class of:
.TextBlack {text-decoration: none}

Blah will work in Netscape 6 and
Blah will not.

I was in shock when Netscape 6 killed my homepage before I found out what's
really going on.

Xing

~~
Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com

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


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

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

RE: SQL Server Licesning

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> It seems to me that, for CF users, SQL7 is a much better buy.
> 
> In CF Administrator, you can limit the number of worker threads 
> (simultaneous connections) to 5, for example.  This means at 
> most 5 CF 
> users can use SQL7 at the same time.  No Internet Connector 
> License needed, 
> just 5 CALS.
> 
> Total cost for SQL7 plus 5 CALs is $1000 or so (less on eBay).
> 
> Not sure if this is available for SQL Server 2000 (although I 
> see CALs are).
> 

Um  Nice try, but that's illegal.  M$'s licensing states that if
you are using SQL server for a webserver, you NEED the internet
connector license OR an unlimited client license.  CF Server is
considered multiplexing middleware, and there's a specific section in
the licensing about that.  You *can't* get around it by limiting the
number of worker threads.  And besides...  Using only 5 workers on
any reasonably powered server would be crippling it -- you want
between 4 and 6 thread per processor if my memory serves...

Best regards,
Zac Bedell

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOhVwQavhLS1aWPxeEQLXfQCgtH/i9pfMclVd9UgL5uLasWfKXzMAoMHl
UzURVVWms4vRjNhlJUaYNpVP
=AJr0
-END PGP SIGNATURE-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Novell Advanced Security Woes

[Steve Bernard]

Authenticating against NDS with CFLDAP is pretty easy if you have the
NDS/LDAP interface enabled and accessible from the CF server. Prior to CF
4.5.x, CFLDAP did not support secure communications, via SSL -> SLDAP, and
NDS wants to use a secure channel by default, so it wasn't widely used. The
thing to remember is that this is completely different from 'Advanced
Security' in CF. You won't be able to use the security tags and functions,
authorization is in your control. You query the directory, passing the
user's login information, and parse the response. I've only worked with NDS
5, I'm not sure about 4's LDAP abilities, and I'm not a Novell tech so my
knowledge of the NDS innards is limited. For straight authentication, i.e.
not grabbing other attributes, I had to use a bit of kludge because NDS
didn't throw an error per se if the credentials were wrong. Instead it sent
back a little explanation that it couldn't validate the user, or some such.
So I made a little parser that looked for certain strings, and if a match
was made it was a bad login. Besides that it was pretty straight forward
LDAP. Unfortunately, I don't have the code on me right now but, I'll look
around.


Steve


-Original Message-
From: Norman Elton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 9:24 PM
To: CF-Talk
Subject: RE: Novell Advanced Security Woes


Kevin-

If you could detail how you accomplish this, many (MANY) developers would be
most appreciative!

Do you authenticate off of GroupWise, or straight to NDS?

I'm not a Novell guy, so I don't know all the inner workings, but I have
definitely struggled to authenticate Novell passwords.

Thanks!

Norman Elton
Information Technology
College of William & Mary

-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 11:51 AM
To: CF-Talk
Subject: RE: Novell Advanced Security Woes



I don't use Advanced Security, but I have and do authenticate to
Novell's LDAP server via the CFLDAP tag.

Kevin

>>> [EMAIL PROTECTED] 11/15/00 12:10PM >>>
I know that if you want to do a look up to NDS with cfldap you can.
But you can't authenticate to it.  Allaire has never tested it and they
say it won't work.  The built it for Netscape DS.  The siteminder piece
doesn't recognize Novell DS.  I got your same problem some time ago and
opened a ticket.and nothing..doesn't work...You can verify the
connection and it works, but if you were to go to your policy and check
the users your shouldn't see anything...
sorry...

Now should anyone have successfully auth against Novell DS, using cf
4.5.1, and advanced security please lets talk.

Thanks



>>> [EMAIL PROTECTED] 11/06/00 10:32AM >>>
Yes, I should have mentioned Rick's tool. I was going down the CF
specific
route but, Rick's tool can solve your problem too.

Steve


-Original Message-
From: Rick Osborne [Mojo] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 1:06 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Novell Advanced Security Woes


FYI, I wrote an ISAPI DLL for IIS to do pretty much exactly what Steve
talks
about at the end there.  It is completely free and comes with source.
It is
available at:

http://www.rixsoft.com/NWAuth/

Of course, it means that IIS does the authentication instead of CF, but
that
may be good or bad depending on your situation.

-Original Message-
From: Steve Bernard [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 04, 2000 22:41
To: CF-Talk
Subject: RE: Novell Advanced Security Woes


With native CF capability you'll have to use CFLDAP to query NDS' LDAP
interface directly. This doesn't allow you to use NDS as your AS
repository
but, it's better than nothing. You could try hand building the schema
in
NDS. Another option is to use native OS authentication/authorization
but,
have that redirected to NDS. Like using Client32 for NT.

Steve




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



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



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


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubsc

RE: Certification Exam

[Stewart McGowan]

My view really Simon, I really wondered what the people who had done the
exam 
as a ticket punching exercise had gained past a certificate (not that I'm in
anyway downgrading the exam or the people who have done it, I would struggle

to pass). Just that I see a lot of certified (and certifiable) candidates
for
employment and for me the certified candidates have proven to be no better 
or worse than the non-certified. My tuppence :)

Regards

Stew





>I have been reading this thread, and just wanted to mention that neither
the
>allaire test, nor the brainbench test, actually means you have a clue how
to
>program in CF.  The allaire test seems to do a better (more thorough) job
of
>testing your understanding of web application architectures and
>implementations, and the brainbench test might do a better job testing your
>syntax knowledge and your ability to read code and know what it's doing
>but neither of these tests illustrate to me, that a person has the ability
>to write good code.  There's a huge difference between spitting out
>memorized answers, and actually using this knowledge in the real world.
The
>tests are nice things to say you've done, and they might make prospective
>employers and clients feel better, but like so many other tests out there,
>they're no substitute for experience and good practice.  If you feel you're
>experienced enough that the test doesn't or shouldn't matter, then you're
>probably ready to take it, and should take it, to emphasise your talents.
>If you don't feel that experienced... my advice is to get experienced
before
>taking the test... even if it's building apps on your laptop.
>Like I said, just my two cents.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Dreamweaver Ultradev 4 - any good?

[Greg Wolfinger]

> Ok, is everyone here special?I haven't seen anything about UD4 except for
> Macromedia's page, which says coming soon.

If you were at the developer conference, macromedia showed the new version
for about 150 developers who had to sign a NDA.  Still waiting on that
special gift promised to be sent to my work by Macromedia.  Anyone else get
it yet

Greg
- Original Message -
From: Jon Hall <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 1:20 PM
Subject: Re: Dreamweaver Ultradev 4 - any good?


> Ok, is everyone here special?I haven't seen anything about UD4 except for
> Macromedia's page, which says coming soon.
>
> Anyone have a link?
> jon
> - Original Message -
> From: "Greg Wolfinger" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, November 15, 2000 10:05 PM
> Subject: Re: Dreamweaver Ultradev 4 - any good?
>
>
> > Dreamweaver is great for our graphic design department that doesn't
> > ColdFusion and (even though they say they do) HTML too.  For me, a web
> > developer I find that it slows me down.  They did improve the who table
> > support quite a bit however. But ooops I signed an NDA at the conference
> > last week.  S.
> >
> > Greg
> > - Original Message -
> > From: Tom Muck <[EMAIL PROTECTED]>
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Sent: Wednesday, November 15, 2000 2:29 PM
> > Subject: Re: Dreamweaver Ultradev 4 - any good?
> >
> >
> > > UD4 is awesome.  The Server Behavior builder will let you fill in your
> own
> > > code snippets with your own parameters so the next time you want to
> insert
> > > the code, a custom dialogue box will pop up and let you fill in all
the
> > > parameters.  It also does generation of some basic code so that you
can
> > get
> > > basic database-driven pages up there quickly.  UD1 was a little
limiting
> > for
> > > CF, but UD4 is great.
> > >
> > > tom
> > >
> > > - Original Message -
> > > From: "Shawn Regan" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, November 15, 2000 11:38 AM
> > > Subject: RE: Dreamweaver Ultradev 4 - any good?
> > >
> > >
> > > > 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_01C04F22.71BFB9D0
> > > > Content-Type: text/plain;
> > > > charset="iso-8859-1"
> > > >
> > > > I think it looks better then 3, they have added to some code editing
> > > > features and SQL and more read  or take the product tour on it.
> > > >
> > > > Shawn Regan
> > > > [EMAIL PROTECTED]
> > > > Cold Fusion Developer
> > > > Pacific Technology Solutions
> > > >
> > >
> > >
> >
>
> --
> > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> send
> > a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> > >
> >
>
> --
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>

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

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

RE: SQL advice please

[Andy Ewings]

Yup use SP's wherever poss.

I tend not to use views either.  I build temp tables in the SP or just
incorporate it into the SQL statement using various joins

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



-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2000 17:43
To: CF-Talk
Subject: RE: SQL advice please


> Can someone explain, in general if possible when the best time to use
> SQL Server views/storedProdedures/triggers VS. CF Queries?

Use Stored Procedures wherever you can. They're usually quicker than
plain CF queries, sometimes enormously so, and help to modularise your
code, which is always good.

Triggers don't do much for you that SP's can't, but they're simpler.
Personally I'm not a big user of views.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Certification Exam

[Shane Witbeck]

Something Id like to share: 

I have been interviewing for CF developer jobs and something that was mentioned to me 
by one of the companies. They mentioned that I was dropped from the list of candidates 
because there was doubt about my CF skills based on the limited number of projects I 
have done. They then had me take the Brainbench test to 'rate my CF skills'. When I 
scored a 4.31 which put me at a "Master" level, I was put back on the list of 
candidates. 

Just thought it was interesting how much companies/recruiters base their decisions on 
the Brainbench test. 

Shane Witbeck

-- Original Message --
From: "Jake Hileman - Patmos" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 17 Nov 2000 11:51:37 -0500

>I took the Brainbench the CF test, I took it after 4 weeks of using Cold
>Fusion. I think I received a 3.41... I'd like to take it again and see if I
>can get the masters cf programmer certificate.  Even with books, it's still
>tough to get the masters, but easy I think to get just get the normal
>certificate.
>
>United Federation of Slow (not very smart) CF Programmers,
>
>heh
>jake
>
>- Original Message -
>From: "G" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, November 17, 2000 11:12 AM
>Subject: Re: Certification Exam
>
>
>> I wouldn't quite slap the "certified" tag on ya yet Rich :)
>>
>> I've taken the Brainbench test at the request of several recruiters.
>> They tend to use it as a measure of proficiency in a given language, and
>> use that as they try and place people with a job that fits their skill
>> level.  So in that capacity, it can be a valuable test.  I also found the
>> Cold Fusion test to be challenginga very good test of the language in
>> just 40 questions.  However, beyond that, I don't know if it holds any
>> water as far as certification is concerned.
>>
>> Brian
>> - Original Message -
>> From: ibtoad <[EMAIL PROTECTED]>
>> To: CF-Talk <[EMAIL PROTECTED]>
>> Sent: Thursday, November 16, 2000 2:07 PM
>> Subject: RE: Certification Exam
>>
>>
>> > Hey I just passed the Brainbench CF 4.5 certification. What exactly
>> does
>> > that mean? Can I call myself a Certified ColdFusion Developer now or do
>> I
>> > need to pass Allair's test for that title??
>> >
>> > Thanks,
>> > Rich
>> >
>> > -Original Message-
>> > From: David E. Crawford [mailto:[EMAIL PROTECTED]]
>> > Sent: Thursday, November 16, 2000 12:41 PM
>> > To: CF-Talk
>> > Subject: Re: Certification Exam
>> >
>> >
>> > One thing to keep in mind is that everyone who has taken the exam is
>> under a
>> > non-disclosure agreement with regards to the exam.  While a high level
>> > overview of the areas to study is reasonable, going much further than
>> that
>> > is not appropriate.
>> >
>> > DC
>> > --
>> > David E. Crawford
>> > Certified ColdFusion Developer
>> > Actek, Inc.
>> >
>> > ---
>> -
>> > 
>> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
>> send a
>> > message with 'unsubscribe' in the body to
>> [EMAIL PROTECTED]
>> >
>> > ---
>> -
>> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
>> send a message with 'unsubscribe' in the body to
>> [EMAIL PROTECTED]
>> >
>>
>> ~~
>> Structure your ColdFusion code with Fusebox. Get the official book at
>http://www.fusionauthority.com/bkinfo.cfm
>>
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>~~
>Structure your ColdFusion code with Fusebox. Get the official book at 
>http://www.fusionauthority.com/bkinfo.cfm
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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