Re: M$ licensing has me at wits end

[Steve Aylor]

Full Product at Estimated Retail Price

http://www.microsoft.com/sql/productinfo/pricing.htm

SQL Server 2000Enterprise EditionStandard EditionDeveloper Edition


Processor Licensing $19,999 US per processor$4,999 US per processor

SQL Server Processor Licensing Clarification

http://www.microsoft.com/sql/productinfo/multiplexing.htm

With the recent introduction of Processor Licensing for the Microsoft® .NET
Enterprise Servers, some independent software vendors (ISVs) have raised
questions as to the proper way to license SQL Server when using it as part
of the ISV's software application. This has particularly been an issue for
vendors of system management tools and their customers, who have requested a
more simplified licensing solution tailored for their specific needs.
Microsoft SQL Server and System Management Tools
As is true for all Microsoft products, SQL Server use is defined in the
End-User Licensing Agreement (EULA) that accompanies all editions of SQL
Server 2000 (or any previous version). There are two ways to license SQL
Server 2000:
Processor License
Server and Client Access Licenses (CALs)
The Server and CAL model is described in the EULA as follows: "SQL Server
2000 Client Access License ('CAL') Requirements. CALs that you acquire may
only be used in conjunction with your Server Software. You must acquire a
separate CAL for each device that.accesses or otherwise utilizes the
services of the Server Software."
Additionally, there is specific language that attempts to clarify the use of
applications that are installed between the end user and the SQL Server:
"'Multiplexing.' Hardware or software that reduces the number of Devices
directly accessing or using the Server Software does not reduce the number
of required CALs. The number you need is based on the number of distinct
inputs to the hardware or software 'front end.'"
Despite this language, our ISV partners have been unclear as to exactly how
many CALs are needed when using system management tools from vendors such as
Computer Associates, BMC, NetIQ, Intel, HP (OpenView) and Microsoft (Systems
Management Server).
Recommended Procedure-Processor License
Microsoft has implemented a processor-based licensing model to address the
special needs of the ISV community and to simplify the licensing model.
Under this new model, a customer acquires a Processor License for each
processor running their server software.
A Processor License includes access for an unlimited number of devices to
connect from either inside the corporate LAN or WAN or outside the firewall.
Customers do not need to purchase additional Server licenses or CALs. The
Processor License is all they need.
Based on a review of system management tool vendors and their products,
Microsoft will communicate that the appropriate licensing method for these
vendors is Processor Licensing.
All system management tool vendors should communicate to their customers,
field account managers, inside sales departments, and resellers that the
appropriate licensing method for Microsoft SQL Server 2000 when used in
conjunction with their product is Processor Licensing. Microsoft will be
communicating the same message to their field account managers and resellers
as well.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Advanced Database Search Form

[B. Wing]

Thanks a lot both of you.  I actually do have THE BOOK by Forta, I guess my
brain is just fried tonight that I didn't figure both of those out on my
own! :-)

I'm going to sleep now!

Thanks again,
Britta

- Original Message -
From: "Stephen Kellogg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 10:58 PM
Subject: RE: Advanced Database Search Form


> Try using one of the following in your query statements:
> 1.
> Where tableField1 = '#form.variable#'
>
> 2.
> Where tableField1 LIKE '#form.variable#%'
> The % is a "wild card" so bu would return anything that started with bu,
ie
> bulb, bulbous but not xbulb
>
> 3.
> Get one of Uncle Ben's (or someone's) books ;-)
> or
> http://www.thenetprofits.co.uk/coldfusion/faq/#answer82
>
> HTH
>
> Stephen
> -Original Message-
> From: B. Wing [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, March 03, 2001 12:51 AM
> To: CF-Talk
> Subject: Advanced Database Search Form
>
>
> There are two things that I'm trying to figure out how to do:  an Exact
> Search - if I put in a search for  "bulb" it would return only "bulb" not
> "bulbous".
>
> Secondly, I've got a client who wants a search which will search only
> beginning of word: For instance a search for, "bu" would return "bulbous"
> but not "babudigalia".
>
> Has anyone done either of these before?  I'd appreciate any idea of where
to
> start to build this.
>
> Thanks a lot!
>
> Britta
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Advanced Database Search Form

[Stephen Kellogg]

Try using one of the following in your query statements:
1.
Where tableField1 = '#form.variable#'

2.
Where tableField1 LIKE '#form.variable#%'
The % is a "wild card" so bu would return anything that started with bu, ie
bulb, bulbous but not xbulb

3.
Get one of Uncle Ben's (or someone's) books ;-)
or
http://www.thenetprofits.co.uk/coldfusion/faq/#answer82

HTH

Stephen
-Original Message-
From: B. Wing [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 03, 2001 12:51 AM
To: CF-Talk
Subject: Advanced Database Search Form


There are two things that I'm trying to figure out how to do:  an Exact
Search - if I put in a search for  "bulb" it would return only "bulb" not
"bulbous".

Secondly, I've got a client who wants a search which will search only
beginning of word: For instance a search for, "bu" would return "bulbous"
but not "babudigalia".

Has anyone done either of these before?  I'd appreciate any idea of where to
start to build this.

Thanks a lot!

Britta
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Advanced Database Search Form

[Robert Everland III]

To do an exact match you would just do in a query Where
something='#something#' to do a partial match you would do where something =
'#something#%' putting the % where you would like the partical match to
look, in this case anything before it would be the search criteria. So you
could put bu in and it would find bulb, bulbous and even butt, but wouldn't
find anything else unless it started with a bu first.


Bob Everland

-Original Message-
From: B. Wing [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 03, 2001 12:51 AM
To: CF-Talk
Subject: Advanced Database Search Form


There are two things that I'm trying to figure out how to do:  an Exact
Search - if I put in a search for  "bulb" it would return only "bulb" not
"bulbous".

Secondly, I've got a client who wants a search which will search only
beginning of word: For instance a search for, "bu" would return "bulbous"
but not "babudigalia".

Has anyone done either of these before?  I'd appreciate any idea of where to
start to build this.

Thanks a lot!

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

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

Advanced Database Search Form

[B. Wing]

There are two things that I'm trying to figure out how to do:  an Exact
Search - if I put in a search for  "bulb" it would return only "bulb" not
"bulbous".

Secondly, I've got a client who wants a search which will search only
beginning of word: For instance a search for, "bu" would return "bulbous"
but not "babudigalia".

Has anyone done either of these before?  I'd appreciate any idea of where to
start to build this.

Thanks a lot!

Britta


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

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

Adserver with proportional serving of ads?

[Paul Sinclair]

I've got a client who is concerned that the adserver we are using seems to
be random in its service of ads. He'll sit there and continually refresh his
browser and gets upset when one ad comes up 3 times in a row, then another
comes up once, and then the original comes up another 5 times in a row. Even
though the ads even out over a long period, he really wants to see the ads
served an equal amount of times in a short period of browser refreshes. The
adserver is CF based and is working quite well for several other sites where
the clients understand that over a long period things even out.

It seems silly to me to want the ads to run in a strict sequence - so long
as the ad impressions even out it doesn't really matter to me. But the
customer is always right. Does anyone know of an adserver that sequences ads
in a strictly evenhanded manner? Ad 1 hits; then ad 2; then ad 3; then ad 4;
and so on until the cycle starts again?

Thanks for any suggestions.

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: SQL Server data type question...

[Tim Fields]

Freddy,

No, the part that follows IN isn't the problem, it's that the PermissionID
column being used to compare against the  "<> 1" is a string. SQL 2000 is
basically telling me that I can't compare a string with an integer. I've
worked around it by making the right side of the equation a string
evaluation, but that's not a very good solution me thinks.

In other words it's the "PermissionID" side of the equation that's the
problem. WHERE PermissionID <> 1

There was another thread here that answered a very  similar question (Stored
Procedures and HTML forms) and maybe in the morning I can extract the logic
from that and solve this thing, it's been a looonngg day!

Thanks for the response.



-Original Message-
From: Freddy [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 9:24 PM
To: CF-Talk
Subject: Re: SQL Server data type question...


Couldn't you use Permissions.PermissionID IN " '4','5' "

Tim Fields wrote:

> I have a client that has an existing SQL Server database which includes a
> table used as part of a permissions framework. The problem is that whoever
> created the table was clever enough to create a column for permissions
id's
> as a varchar rather than creating a join table. So I may a situation where
> Permissions.PermissionID =
>
> They have been using a statement in SQL Server7 that is something like:
>
> Select p.FName, p.LName
> >From Permissions p
> Where p.PermissionID <> 1
>
> That worked in 7, but not in 2000 which correctly sees it as a data type
> error ( cannot convert...)
>
> They won't let me rebuild that part of the database properly right now for
> reasons that are debatable, but anyway I have to work with this structure.
> Their internal person came up with:
>
> Where p.PermissionID NOT LIKE '%1%'
>
> but I pointed out that it had some serious holes in it such as it would
fail
> 11 or 21. I've fixed it temporarily by using a series of AND NOT LIKE
> statements with wildcards to fail '1', '1,' or ',1' but pass everything
> else. It's a pretty damned ugly statement though if I do say so myself.
>
> Does anyone know of a more elegant solution? I can't quite get my arms
> around sp_executesql to see if that could help.
>
> Any help would be appreciated.
>
> Tim


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[paul smith]

I stayed with SQL7.  It does all I need.

best,  paul

At 08:59 PM 3/2/01 -0500, you wrote:
>I still haven't gotten an answer from anyone though. Is there anyone
>else out there hosting websites, other than their own, and using SQL
>2000 as the database? If so, how are you licensed? I guess with this
>can of worms I'm opening, everyone is scared to answer


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 data type question...

[Freddy]

Couldn't you use Permissions.PermissionID IN " '4','5' "

Tim Fields wrote:

> I have a client that has an existing SQL Server database which includes a
> table used as part of a permissions framework. The problem is that whoever
> created the table was clever enough to create a column for permissions id's
> as a varchar rather than creating a join table. So I may a situation where
> Permissions.PermissionID =
>
> They have been using a statement in SQL Server7 that is something like:
>
> Select p.FName, p.LName
> >From Permissions p
> Where p.PermissionID <> 1
>
> That worked in 7, but not in 2000 which correctly sees it as a data type
> error ( cannot convert...)
>
> They won't let me rebuild that part of the database properly right now for
> reasons that are debatable, but anyway I have to work with this structure.
> Their internal person came up with:
>
> Where p.PermissionID NOT LIKE '%1%'
>
> but I pointed out that it had some serious holes in it such as it would fail
> 11 or 21. I've fixed it temporarily by using a series of AND NOT LIKE
> statements with wildcards to fail '1', '1,' or ',1' but pass everything
> else. It's a pretty damned ugly statement though if I do say so myself.
>
> Does anyone know of a more elegant solution? I can't quite get my arms
> around sp_executesql to see if that could help.
>
> Any help would be appreciated.
>
> Tim
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 11:50 AM
> To: CF-Talk
> Subject: RE: Stored Procedures and HTML form List
>
> > > To the best of my knowledge, you can't do this. What you can
> > > do to get the same effect, though, is to execute a string
> > > containing your SQL statement ...
> > > ...
> > > Of course, this isn't an optimal solution.
> >
> > Thanks!  That's almost exactly what I was looking for. I'll
> > try it today. Why would it not be an optimal solution? Is it
> > slower or can that function only be used in certain situations?
>
> It's slower, because it can't take advantage of existing query plans as
> well.
>
> 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: M$ licensing has me at wits end

[Bud]

On 3/2/01, Jim McAtee penned:
>Hell, if they can't figure it out themselves, why lose sleep over it?  Fire
>up the server and get on with your life.

I guess that's the next step. Somehow I figure their roving "License 
Cops" probably do understand it though. :)

I still haven't gotten an answer from anyone though. Is there anyone 
else out there hosting websites, other than their own, and using SQL 
2000 as the database? If so, how are you licensed? I guess with this 
can of worms I'm opening, everyone is scared to answer.
-- 

Bud Schneehagen - Tropical Web Creations

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

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

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

SQL Server data type question...

[Tim Fields]

I have a client that has an existing SQL Server database which includes a
table used as part of a permissions framework. The problem is that whoever
created the table was clever enough to create a column for permissions id's
as a varchar rather than creating a join table. So I may a situation where
Permissions.PermissionID = "1,4,5"

They have been using a statement in SQL Server7 that is something like:

Select p.FName, p.LName
>From Permissions p
Where p.PermissionID <> 1

That worked in 7, but not in 2000 which correctly sees it as a data type
error ( cannot convert...)

They won't let me rebuild that part of the database properly right now for
reasons that are debatable, but anyway I have to work with this structure.
Their internal person came up with:

Where p.PermissionID NOT LIKE '%1%'

but I pointed out that it had some serious holes in it such as it would fail
11 or 21. I've fixed it temporarily by using a series of AND NOT LIKE
statements with wildcards to fail '1', '1,' or ',1' but pass everything
else. It's a pretty damned ugly statement though if I do say so myself.

Does anyone know of a more elegant solution? I can't quite get my arms
around sp_executesql to see if that could help.

Any help would be appreciated.

Tim



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 11:50 AM
To: CF-Talk
Subject: RE: Stored Procedures and HTML form List


> > To the best of my knowledge, you can't do this. What you can
> > do to get the same effect, though, is to execute a string
> > containing your SQL statement ...
> > ...
> > Of course, this isn't an optimal solution.
>
> Thanks!  That's almost exactly what I was looking for. I'll
> try it today. Why would it not be an optimal solution? Is it
> slower or can that function only be used in certain situations?

It's slower, because it can't take advantage of existing query plans as
well.

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: Using XML as datsource in CF

[Marc Garrett]

Richard,

I don't know the answer to your question, but Verity can index xml file
types so you could expose a collection to CFSEARCH.

Regards,

Marc Garrett



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 turn on Application Mangement

[Michael]

HEY,Got it working, and it was something
small and dumb which I am not saying.

But thank you for your help.



Michael

TIme for many beer's and dinner

Once again THANK YOU

Later ,  I hear  MOLSON calling my name.


Michael





"Robert Long" <[EMAIL PROTECTED]> wrote in message
B1A5B5B556DBD31190F800508B55FD6C99FB62@EXCHANGE01">news:B1A5B5B556DBD31190F800508B55FD6C99FB62@EXCHANGE01...
> Are you trying to use a customtag or set up some application
> management? I wondered why you would name your cfapplication
> something like "custom tag name".
>
> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 12:59 PM
> To: CF-Talk
> Subject: Re: How turn on Application Mangement
>
>
> Tried everything you said, and even asked another developer, and they said
> it looked right to them also,  but they didnt really have that much
> experience in custom tags, so they didnt want me to base there words as
> being something set in stone, if you know what I mean.
>
>
> "Robert Long" <[EMAIL PROTECTED]> wrote in message
> B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01">news:B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01...
> > Michael,
> > How do you know it's not on?
> > If you set  in the application.cfm
> > and set other parameters such as clientmanagement="yes" and
> > sessionmanagement="yes"
> > then it should be turned on. You need to set some variables to know for
> > sure,
> > for example. In the application.cfm put
> > 
> > 
> >
> > Then in the index.cfm page (or another page) put
> >
> > 
> > name: #session.name#
> > Is it working: #session.IsThisWorking#
> > 
> >
> > You can replace session with application, client, or whatever...
> >
> > hth
> >
> >
> > -Original Message-
> > From: Michael [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 02, 2001 8:40 AM
> > To: CF-Talk
> > Subject: How turn on Application Mangement
> >
> >
> > Where do you do this?  I have a seperate Application.cfm that has
> >  and I still cant figure out
why
> > this tag is not working, everything is in the proper directory.
> >
> > TIA
> >
> > Michael
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: (yet another) Javascript Question

[Bryan Love]

here is a function I wrote to check integers, I've modified it to fit your
needs:

function checkField(str){
var isValidNum = true;

// check if is blank
if( str.length == 0 )
isValidNum = false;

// check if is integer
for( i=0; i "9")
isValidNum = false;
}

// check limits
if( isValidNum ){
if( str > 1000 )
isValidNum = false;
}

// return if number is good
if( isValidNum )
return true;

// alert if number is bad
alert("Please enter a valid fleet size.");
}


Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 11:10 AM
To: CF-Talk
Subject: (yet another) Javascript Question


Hi Folks,
If there's a more appropriate place to ask this question, please let me know

- this list is so incredibly high volume,I'd hate to be erroneously 
contributing to it when I should send my question elsewhere.

With that said:

I'm doing Javascript validation and having trouble getting the following to 
work (it is supposed to only allow user to enter an integer between 1 and 
1):

function fleet_size_check(form) {

ctrl = form.fleet_size;
myRe=/^[0-9]{1,6}/;

if (!myRe.test(ctrl.value)) {
alert("Please enter a valid fleet size.");
document.profile_info.fleet_size.focus();
return (true);
}
else if ctrl.value > 1 {
alert("Please enter a valid fleet size.");
document.profile_info.fleet_size.focus();
return (true);
}
else return (false);
}

The first "if" seems to work OK, but not the second.  Any suggestions would 
be most appreciated.

TIA,
- - - Jeanne
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Jim McAtee]

Hell, if they can't figure it out themselves, why lose sleep over it?  Fire
up the server and get on with your life.

Jim


- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 2:59 PM
Subject: RE: M$ licensing has me at wits end


> Thanks for all the responses. I'll keep you posted. I guess as soon
> as the gal at Microsoft can figure out how their licensing works
> she'll let me know. For now though, according to the retailer that
> supposedly sells Microsoft Commercial Internet Services licensed
> products, they've never sold one, and have never heard of it, so
> there can't be too many people following the rules.
>
> Of course, I'm very much expecting it's going to be out of my price
> range if and when I do get an answer.
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Dylan Bromby]

sweet. thanks.

-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 12:42 PM
To: CF-Talk
Subject: RE: M$ licensing has me at wits end


A colleague in our CFUG told me about the MSDN Business Connection program.
After being accepted into that program (it's free to join), they offer
members a special Universal Sub annual price of $599 + tax. But this isn't
well publicized at the MSDN Business Connections site unless you log in
(after being accepted into the program).

Here is the link to info about the MSDN Business Connection program:
http://msdnisv.microsoft.com/

Hope that helps clarify the issue.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78

> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 12:56 PM
> To: CF-Talk
> Subject: RE: M$ licensing has me at wits end
>
>
> ok here's MS pricing for MSDN with universal at $2,499. how can i
> get it for
> $599? sorry if i missed the previous post.
>
> http://msdn.microsoft.com/subscriptions/prodinfo/pricing.asp
>
> --dylan
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: UPS XML ... CF?

[Alexandre Dornback]

Yes... If you have the correct data and url, you should see the xml code
display by calling the page directly.  Usually you must call a template or
post variable to a template for it to return xml to you


-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 2:28 PM
To: CF-Talk
Subject: UPS XML ... CF?


Has anyone integrated the UPS XML Shipping data into a CF application or
anyone have any tips on where to start?
I have read through most of the UPS docs, but I seem to be missing some
basic knowledge. I really should pick up a book, but until I go grab one, I
still want to play around with this.

According to the UPS docs the xml is supposed to be posted to
https://www.ups.com/ups.apps/xml/Rate
Yet when I go to that url with my browser or us cfhttp I get page cannot be
displayed...

What I am wondering is can I post xml data and get the response whith
CFHttp?

jon
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Cybercash in Chapter 11

[ron]

> http://www.cybercash.com/company/press/releases/2001/01mar02networ
> k1restruct
> > ure.html
>
> Didn't Cybercash bu ICVerify some time ago as well? Alot of
> eCommerce businesses
> use that.

Yep, Cybercash bought ICVerify a year ago or so, then promptly stopped
support of it. At that time, we switched to AuthorizeNet, and it's been blue
skies ever since. :)

-ron



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: fusebox and cfcache

[Dave Watts]

> I have a question about using cfcache with fusebox. If I have 
> an action like
> 
> 
> 
> 
> 
> 
> I want to use cfcache on Display_Schedule.cfm. The link would 
> be listed as index.cfm?action=ShowSchedule. If that is the case 
> then the query would run. Or would you put the cfcache tag in 
> both templates?
> 
> Or is this an instance where fusebox is not the way to go and 
> just combine the two templates into one page and have
> 
> 
> 
> 

Although I'd argue that Fusebox is never the way to go (just kidding here,
I'm not trying to start a Fusebox flame war), there's no reason why you
can't use CFCACHE with Fusebox. If you only wanted to cache the page output
generated when using display_schedule.cfm, you could do this in index.cfm:







Or, for even better results, use ACTION="OPTIMAL" in CF 4.5.1, which will
take advantage of browser caching if possible.

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

IHTK 3.12

[lsellers]

Just a note: The Intranet/Hosting Toolkit as of 3.12 is now freeware.

http://www.intrafoundation.com/intranethostingtoolkit.html.

(Got tired of fooling with it. :)

--min


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

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

RE: CFMail - Sending a link in an email

[Gieseman, Athelene]

This list is the best.  Of course, after seeing the answer, I'm realizing
how obvious that was.  Thanks for your help and patience!

-Original Message-
From: Robert Long [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 10:30 AM
To: CF-Talk
Subject: RE: CFMail - Sending a link in an email


I think Melissa nailed it. You need to supply some kind of address
in the link tag. Since the email client is not a browser, it needs
specific directions to the page you are linking to. So using
http://intranet/usercalldisplay.cfm or something like that will help
it find it's way to the page.

Hope that helps.

-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 9:47 AM
To: CF-Talk
Subject: Re: CFMail - Sending a link in an email


Try putting in the entire address without the href tag. For example:
http://www.yoursite.com/UserCallDisplay.cfm

If I understand the other responses to your question correctly, when Outlook
sees the http://  it will create a
link.

Melissa

"Gieseman, Athelene" wrote:

> OK, let me try to post the code again.  this time I change the tag in this
> message to say CF_mail.  I'm guessing the post didn't like the real tag.
>
> 
>
>  subject="New Help Desk Ticket" type="HTML">Thank you for
> reporting your issue to the Help Desk.  Your call was logged into
> our database at #prettydatetime#.  If your problem was not resolved at the
> time of your call you will be hearing back from a technician shortly.
> 
> Call Information
> Ticket Number:  #GetCall.ID#
> Problem Description:  
> #GetCall.Issue#
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: CFLOCK, when to use...

[Dave Watts]

> A previous message mentioned locking session variables when 
> you read or write them. Why? I thought session variables were 
> unique to the client.

They are. That doesn't mean that they can't be accessed concurrently by that
(multithreaded, frames-capable, back-button-enabled) client.

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: date times

[Eric Barr]

Well, I have no idea what you are trying to accomplish ...but why not
take a swing in the dark ;-)

If your using SQL Server look into the "dateDiff" function. Say you have
two dates  @date1 = '01/01/2001 01:00' and @date2 = '01/02/2001 02:00'.
dateDiff("hh", @date1, @date2)  would return 25 because 25 hour
boundaries have been crossed between the two. If you are using another
database I'm sure their are similar facilities in them.

If you can be a bit more detailed I would help more.


-eric

Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

Eric Barr
Zeff Design
(p)  212.714.6390 
(f)   212.580.7181


-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:16 AM
To: CF-Talk
Subject: date times


If there is anything I struggle with its dates and times:

What I'm trying to do is this.

Select a time from in my database.

SELECT  DT, sessionStatus
FROMdbo.milford
WHERE   SESSIONSTATUS = 1

SELECT  DT, sessionStatus
FROMdbo.milford
WHERE   SESSIONSTATUS = 0

There is a timestamp for every hour between start time and finish time.

a session will last for 24 hours at least, maximum 7 days.

We are timing a pump here.

Now how would I add up the hours here, any ideas would be appreciated??

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

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

UPS XML ... CF?

[Jon Hall]

Has anyone integrated the UPS XML Shipping data into a CF application or
anyone have any tips on where to start?
I have read through most of the UPS docs, but I seem to be missing some
basic knowledge. I really should pick up a book, but until I go grab one, I
still want to play around with this.

According to the UPS docs the xml is supposed to be posted to
https://www.ups.com/ups.apps/xml/Rate
Yet when I go to that url with my browser or us cfhttp I get page cannot be
displayed...

What I am wondering is can I post xml data and get the response whith
CFHttp?

jon


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: i need List Help (and a thanks)

[Andrew Tyrone]

I apologize -- one line is off.

In the VALUES part of your SQL, I inadvertently put #ThisID# in twice.  The second one 
should be changed back to #Place#.  Sorry!

-Andy 

> -Original Message-
> From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 5:16 PM
> To: CF-Talk
> Subject: RE: i need List Help (and a thanks)
> 
> 
> Jay,
> 
> Try out the following:
> 
> 
> 
> 
>   
>   
>   
>   
>   
>   
>Evaluate("form.Place#CurrentSelect#MoneyEarned")>
>Evaluate("form.Place#CurrentSelect#NotAllAround")>
>   
>CurrentSelect & 'ContestantID')>
>   
>   
>   
>   
>datasource="#datasource#" username="#username#" 
> password="#password#" dbtype="ODBC">
>   INSERT INTO ResultsManager (RodeoID, EventID, 
> ContestantID, Place, TimeTaken, Points, AdjPoints, MoneyEarned, 
> NotAllAround)
>   VALUES (
>   '#RodeoID#',
>   '#EventID#',
>   '#ThisID#',
>   #ThisID#,
>   #TimeTaken#,
>   #Points#,
>   #AdjPoints#,
>   #MoneyEarned#,
>   #NotAllAround#)
>   
>   
>   
> 
> 
> 
> 
> 
> I couldn't run this as it pertains to your app, but it should 
> work.  Noticed I shortened it quite a bit.  I put in some 
> comments to show you why.  The problem had to do with your nested 
> lists.  When you sit back and think about it, you'll realize you 
> have an outer and inner list.  The outer list will always be 6 (I 
> assume you are validation this part on your own), so that we 
> know.  Within each Select list that is sent to your action page, 
> there could be 1 or more values.  You can loop over a list of 1 
> value.  Doing it in this way, you eliminate the need to have 
> separate SQL code for inserting 1 or many Contestants into the database.
> 
> I hope it works for you!
> 
> -Andy 
> 
> > -Original Message-
> > From: Jay Patton [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 02, 2001 10:01 AM
> > To: CF-Talk
> > Subject: i need List Help (and a thanks)
> > 
> > 
> > I submitted this again because im not sure that it went through 
> > the first time.
> > 
> > I'm back with another question ( imagine that :)
> > First i would like to say thanks to everyone that has helped me 
> > so far a lot of things have worked great!
> > 
> > what i have is a form that has 6 selection box's (all multiple 
> > select box's) which list's all of the contestans in a circuit.
> > if i select just one person for each place 1st through 6th 
> > everything is great. however when i need to select two for 
> > a place (example: tie in first or something like that) im trying 
> > to get the insert page to put each contestant on there own
> > row in the DB. rather than put a comma between the ContestantID's 
> > This is what i have now but for some reason it still adds the
> > comma's and doesnt put them on there own row.
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > Select Contestant  query="Contestants">
> > #LastName#, #FirstName# 
> > (#Age#)
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  > username="#username#" password="#password#" dbtype="ODBC">
> > INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, 
> > Place, TimeTaken, Points, AdjPoints, MoneyEarned, NotAllAround)
> > VALUES (
> > '#RodeoID#',
> > '#EventID#',
> > '#ContestantID#',
> > #Place#,
> > #TimeTaken#,
> > #Points#,
> > #AdjPoints#,
> > #MoneyEarned#,
> > #NotAllAround#)
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  > list="#form.Place#LoopList#ContestantID#">
> > 
> > 
> > 
> >  > username="#username#" password="#password#" dbtype="ODBC">
> > INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, 
> > Place, TimeTaken, Points, AdjPoints, MoneyEarned, NotAllAround)
> > VALUES (
> > '#RodeoID#',
> > '#EventID#',
> > '#ContestantID#',
> > #Place#,
> > #TimeTaken#,
> > #Points#,
> > #AdjPoints#,
> > #MoneyEarned#,
> > #NotAllAround#)
> > 
> > 
> > 
> > 
> >  
> > 
> > Thanks,
> > 
> > Jay Patton
> > Web Design / Application Design
> > Web Pro USA
> > 406.549.3337 ext. 203
> > 1.888.5WEBPRO
> > www.webpro-usa.com
> > [EMAIL PROTECTED]
> > 
> > 
> > **
> > "Trust Everyone
> > But Always Cut The Cards."
> > **
> > 
> > 
> > 
> >
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFLOCK, when to use...

[Joby Bednar]

A previous message mentioned locking session variables when you read or
write them.  Why?  I thought session variables were unique to the client.
Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED]
Cell:  949-283-5138
Personal Fax:  208-485-1170


  Only $19.95!  Register your Domain Name with
  SAVE-A-NAME.COM
 www.  .  com net org






~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: i need List Help (and a thanks)

[Andrew Tyrone]

Jay,

Try out the following:



















INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, 
TimeTaken, Points, AdjPoints, MoneyEarned, NotAllAround)
VALUES (
'#RodeoID#',
'#EventID#',
'#ThisID#',
#ThisID#,
#TimeTaken#,
#Points#,
#AdjPoints#,
#MoneyEarned#,
#NotAllAround#)








I couldn't run this as it pertains to your app, but it should work.  Noticed I 
shortened it quite a bit.  I put in some comments to show you why.  The problem had to 
do with your nested lists.  When you sit back and think about it, you'll realize you 
have an outer and inner list.  The outer list will always be 6 (I assume you are 
validation this part on your own), so that we know.  Within each Select list that is 
sent to your action page, there could be 1 or more values.  You can loop over a list 
of 1 value.  Doing it in this way, you eliminate the need to have separate SQL code 
for inserting 1 or many Contestants into the database.

I hope it works for you!

-Andy 

> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 10:01 AM
> To: CF-Talk
> Subject: i need List Help (and a thanks)
> 
> 
> I submitted this again because im not sure that it went through 
> the first time.
> 
> I'm back with another question ( imagine that :)
> First i would like to say thanks to everyone that has helped me 
> so far a lot of things have worked great!
> 
> what i have is a form that has 6 selection box's (all multiple 
> select box's) which list's all of the contestans in a circuit.
> if i select just one person for each place 1st through 6th 
> everything is great. however when i need to select two for 
> a place (example: tie in first or something like that) im trying 
> to get the insert page to put each contestant on there own
> row in the DB. rather than put a comma between the ContestantID's 
> This is what i have now but for some reason it still adds the
> comma's and doesnt put them on there own row.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Select Contestant 
> #LastName#, #FirstName# 
> (#Age#)
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  username="#username#" password="#password#" dbtype="ODBC">
> INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, 
> Place, TimeTaken, Points, AdjPoints, MoneyEarned, NotAllAround)
> VALUES (
> '#RodeoID#',
> '#EventID#',
> '#ContestantID#',
> #Place#,
> #TimeTaken#,
> #Points#,
> #AdjPoints#,
> #MoneyEarned#,
> #NotAllAround#)
> 
> 
> 
> 
> 
> 
> 
> 
>  list="#form.Place#LoopList#ContestantID#">
> 
> 
> 
>  username="#username#" password="#password#" dbtype="ODBC">
> INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, 
> Place, TimeTaken, Points, AdjPoints, MoneyEarned, NotAllAround)
> VALUES (
> '#RodeoID#',
> '#EventID#',
> '#ContestantID#',
> #Place#,
> #TimeTaken#,
> #Points#,
> #AdjPoints#,
> #MoneyEarned#,
> #NotAllAround#)
> 
> 
> 
> 
>  
> 
> Thanks,
> 
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> 406.549.3337 ext. 203
> 1.888.5WEBPRO
> www.webpro-usa.com
> [EMAIL PROTECTED]
> 
> 
> **
> "Trust Everyone
> But Always Cut The Cards."
> **
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Cybercash in Chapter 11

[Adrian Cooper]

- Original Message -
From: "Howie Hamlin" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 10:05 PM

> FYI:
>
> http://www.cybercash.com/company/press/releases/2001/01mar02network1restruct
> ure.html

Didn't Cybercash bu ICVerify some time ago as well? Alot of eCommerce businesses
use that.

Adrian Cooper.



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

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

RE: Problem with login code

[Eric Barr]

In your code it looked like the IF's were nested incorrectly. If you
query where username=X and password=Y ..the result set you get back is
guaranteed to have a username of X and a password of Y ...so their is no
need to check in your IF conditions.

Your code could be written more compactly like below.  I change the
check on record count to use exactly one (instead of MaxRows=1), Just in
case their are every more than one records in the results set.  Your
database should have some constraints not allow this to happen...but
better safe than sorry...and it dosen't incur a performance hit.

BUT, the one big problem I see here is if I ever log in then bookmark
the page "webmaster.cfm"  I will be able to come back to it.  Because,
in this logon procedure you don't seem to be setting any session
variables something like "Session.logonName = logon.username" so that on
the webmaster.cfm page you could include a check to see if the variable
exists ...and if not kick the user back to the logon page.







 SELECT username, password
 FROM   WordJokes
 WHERE  WordJokes.username = '#form.username#' AND
WordJokes.password = '#form.password#'










Anyway, hope this helps.

-eric

Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

Eric Barr
Zeff Design
(p)  212.714.6390 
(f)   212.580.7181


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 5:55 AM
To: CF-Talk
Subject: Problem with login code


Hi everyone,

The code below is a loginaction template.  It's supposed to give an
error
message if the wrong id or password is given on a login form, or if
either
or both aren't given.  Instead, it only gives the message if something
is
missing.  If something is wrong, it simply sends the user back to the
login
page, with no error message.  Is it possible to 'tweak' the code to get
it
to work (and if so, can you please suggest how to do so), or is there
something so fundamentally wrong with it that it needs to be rewritten
from
scratch?




 SELECT username, password
 FROM   WordJokes
 WHERE  WordJokes.username = '#form.username#' AND
WordJokes.password = '#form.password#'



  

  

  
  

  

  
  
 




  
  


Sincerely,

---
Hubert Earl

ICQ#: 16199853

See pictures of items in my Jamaican Art, Craft & More Store Online Sale
on
my "Me" page on eBay (this tells you a little about myself, including a
photo), and there's a link to the auctions themselves:
http://members.ebay.com/aboutme/hearl1/

See pictures of all items I have:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

FYI: Cybercash in Chapter 11

[Howie Hamlin]

FYI:

http://www.cybercash.com/company/press/releases/2001/01mar02network1restruct
ure.html

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Bud]

Thanks for all the responses. I'll keep you posted. I guess as soon 
as the gal at Microsoft can figure out how their licensing works 
she'll let me know. For now though, according to the retailer that 
supposedly sells Microsoft Commercial Internet Services licensed 
products, they've never sold one, and have never heard of it, so 
there can't be too many people following the rules.

Of course, I'm very much expecting it's going to be out of my price 
range if and when I do get an answer.
-- 

Bud Schneehagen - Tropical Web Creations

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Chris Montgomery]

A colleague in our CFUG told me about the MSDN Business Connection program.
After being accepted into that program (it's free to join), they offer
members a special Universal Sub annual price of $599 + tax. But this isn't
well publicized at the MSDN Business Connections site unless you log in
(after being accepted into the program).

Here is the link to info about the MSDN Business Connection program:
http://msdnisv.microsoft.com/

Hope that helps clarify the issue.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78

> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 12:56 PM
> To: CF-Talk
> Subject: RE: M$ licensing has me at wits end
>
>
> ok here's MS pricing for MSDN with universal at $2,499. how can i
> get it for
> $599? sorry if i missed the previous post.
>
> http://msdn.microsoft.com/subscriptions/prodinfo/pricing.asp
>
> --dylan


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 turn on Application Mangement

[Robert Long]

Are you trying to use a customtag or set up some application
management? I wondered why you would name your cfapplication
something like "custom tag name".

-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 12:59 PM
To: CF-Talk
Subject: Re: How turn on Application Mangement


Tried everything you said, and even asked another developer, and they said
it looked right to them also,  but they didnt really have that much
experience in custom tags, so they didnt want me to base there words as
being something set in stone, if you know what I mean.


"Robert Long" <[EMAIL PROTECTED]> wrote in message
B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01">news:B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01...
> Michael,
> How do you know it's not on?
> If you set  in the application.cfm
> and set other parameters such as clientmanagement="yes" and
> sessionmanagement="yes"
> then it should be turned on. You need to set some variables to know for
> sure,
> for example. In the application.cfm put
> 
> 
>
> Then in the index.cfm page (or another page) put
>
> 
> name: #session.name#
> Is it working: #session.IsThisWorking#
> 
>
> You can replace session with application, client, or whatever...
>
> hth
>
>
> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 8:40 AM
> To: CF-Talk
> Subject: How turn on Application Mangement
>
>
> Where do you do this?  I have a seperate Application.cfm that has
>  and I still cant figure out why
> this tag is not working, everything is in the proper directory.
>
> TIA
>
> Michael
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: M$ licensing has me at wits end

[Arden Weiss]

A repost of my findings follows:

Regarding Licensing of SQL Server 2000, the Standard Edition of SQL Server 
2000 (Part Number 228-00782) at a M$ retail cost of $665.00 is available 
only via the Open License Program which says you must by at least five 
products -- but the M$ sales guys said even low cost training courseware 
like the $15 how to use Access qualifies -- so for about $700 you can get a 
single-user version of SQL Server 2000 Standard Edition. Otherwise, the 
cost of the five-user Standard Edition is $1,489 retail ($1,379 from PC 
Connection).

There also is a full featured Developer's Edition for $499 retail ($468.41 
at PC Connection) that, of course, works fine locally for development 
purposes, but can't be used for production/commercial purposes but has the 
feature set of the Enterprise Edition as I understand.

This does not address the initial post regarding commercial usage -- which 
is whole different bag of M$ worms per post by Bud...

See www.microsoft.com/sql/productinfo/pricing.htm


 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Dylan Bromby [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 02, 2001 1:56 PM
To: CF-Talk
Subject:RE: M$ licensing has me at wits end

ok here's MS pricing for MSDN with universal at $2,499. how can i get it 
for
$599? sorry if i missed the previous post.

http://msdn.microsoft.com/subscriptions/prodinfo/pricing.asp

--dylan

-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 10:41 AM
To: CF-Talk
Subject: RE: M$ licensing has me at wits end


You can get it for $599. I posted about that the other day.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78

> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 9:33 AM
> To: CF-Talk
> Subject: RE: M$ licensing has me at wits end
>
>
> MSDN doesn't include commercial licensing, which is what he was
> looking for.
>
> and universal is only $2,500.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

fusebox and cfcache

[sebastian palmigiani]

I have a question about using cfcache with fusebox. If I have an action like






I want to use cfcache on Display_Schedule.cfm. The link  would be listed as
index.cfm?action=ShowSchedule. If that is the case then the query would run.
Or would you put the cfcache tag in both templates?

Or is this an instance where fusebox is not the way to go and just combine
the two templates into one page and have





Thanks,
Sebastian


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: (yet another) Javascript Question

[David Baskin]

Jeanne, it looks like you don't have and "(" ")" around your second if case.
i think that will fix your problem.

else if (ctrl.value > 1) {
alert("Please enter a valid fleet size.");

david

-Original Message-
From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 11:10 AM
To: CF-Talk
Subject: (yet another) Javascript Question


Hi Folks,
If there's a more appropriate place to ask this question, please let me know
- this list is so incredibly high volume,I'd hate to be erroneously
contributing to it when I should send my question elsewhere.

With that said:

I'm doing Javascript validation and having trouble getting the following to
work (it is supposed to only allow user to enter an integer between 1 and
1):

function fleet_size_check(form) {

ctrl = form.fleet_size;
myRe=/^[0-9]{1,6}/;

if (!myRe.test(ctrl.value)) {
alert("Please enter a valid fleet size.");
document.profile_info.fleet_size.focus();
return (true);
}
else if ctrl.value > 1 {
alert("Please enter a valid fleet size.");
document.profile_info.fleet_size.focus();
return (true);
}
else return (false);
}

The first "if" seems to work OK, but not the second.  Any suggestions would
be most appreciated.

TIA,
- - - Jeanne
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: (yet another) Javascript Question

[Phoeun Pha]

I don't really know Javascript, but that's a really cute name! Jeanne heh

-Original Message-
From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 1:10 PM
To: CF-Talk
Subject: (yet another) Javascript Question


Hi Folks,
If there's a more appropriate place to ask this question, please let me know

- this list is so incredibly high volume,I'd hate to be erroneously 
contributing to it when I should send my question elsewhere.

With that said:

I'm doing Javascript validation and having trouble getting the following to 
work (it is supposed to only allow user to enter an integer between 1 and 
1):

function fleet_size_check(form) {

ctrl = form.fleet_size;
myRe=/^[0-9]{1,6}/;

if (!myRe.test(ctrl.value)) {
alert("Please enter a valid fleet size.");
document.profile_info.fleet_size.focus();
return (true);
}
else if ctrl.value > 1 {
alert("Please enter a valid fleet size.");
document.profile_info.fleet_size.focus();
return (true);
}
else return (false);
}

The first "if" seems to work OK, but not the second.  Any suggestions would 
be most appreciated.

TIA,
- - - Jeanne
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 turn on Application Mangement

[Michael]

Tried everything you said, and even asked another developer, and they said
it looked right to them also,  but they didnt really have that much
experience in custom tags, so they didnt want me to base there words as
being something set in stone, if you know what I mean.


"Robert Long" <[EMAIL PROTECTED]> wrote in message
B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01">news:B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01...
> Michael,
> How do you know it's not on?
> If you set  in the application.cfm
> and set other parameters such as clientmanagement="yes" and
> sessionmanagement="yes"
> then it should be turned on. You need to set some variables to know for
> sure,
> for example. In the application.cfm put
> 
> 
>
> Then in the index.cfm page (or another page) put
>
> 
> name: #session.name#
> Is it working: #session.IsThisWorking#
> 
>
> You can replace session with application, client, or whatever...
>
> hth
>
>
> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 8:40 AM
> To: CF-Talk
> Subject: How turn on Application Mangement
>
>
> Where do you do this?  I have a seperate Application.cfm that has
>  and I still cant figure out why
> this tag is not working, everything is in the proper directory.
>
> TIA
>
> 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

(yet another) Javascript Question

[Jeanne Sarfaty Glazer]

Hi Folks,
If there's a more appropriate place to ask this question, please let me know 
- this list is so incredibly high volume,I'd hate to be erroneously 
contributing to it when I should send my question elsewhere.

With that said:

I'm doing Javascript validation and having trouble getting the following to 
work (it is supposed to only allow user to enter an integer between 1 and 
1):

function fleet_size_check(form) {

ctrl = form.fleet_size;
myRe=/^[0-9]{1,6}/;

if (!myRe.test(ctrl.value)) {
alert("Please enter a valid fleet size.");
document.profile_info.fleet_size.focus();
return (true);
}
else if ctrl.value > 1 {
alert("Please enter a valid fleet size.");
document.profile_info.fleet_size.focus();
return (true);
}
else return (false);
}

The first "if" seems to work OK, but not the second.  Any suggestions would 
be most appreciated.

TIA,
- - - Jeanne
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Dylan Bromby]

ok here's MS pricing for MSDN with universal at $2,499. how can i get it for
$599? sorry if i missed the previous post.

http://msdn.microsoft.com/subscriptions/prodinfo/pricing.asp

--dylan

-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 10:41 AM
To: CF-Talk
Subject: RE: M$ licensing has me at wits end


You can get it for $599. I posted about that the other day.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78

> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 9:33 AM
> To: CF-Talk
> Subject: RE: M$ licensing has me at wits end
>
>
> MSDN doesn't include commercial licensing, which is what he was
> looking for.
>
> and universal is only $2,500.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Chris Montgomery]

You can get it for $599. I posted about that the other day.

Chris Montgomery [EMAIL PROTECTED]  

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner  
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78

> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 9:33 AM
> To: CF-Talk
> Subject: RE: M$ licensing has me at wits end
> 
> 
> MSDN doesn't include commercial licensing, which is what he was 
> looking for.
> 
> and universal is only $2,500.
> 

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

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

RE: Allaire Cert Question

[Robert Long]

That's basically my point. I don't know if my dentist had a 4.0 gpa
or a 3.0. But he has the same certificate as the other guy. 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 11:37 AM
To: CF-Talk
Subject: RE: Allaire Cert Question


> > > Is there a difference (that can be seen by a third party) 
> > > between an Allaire Certified Developer that passed the 
> > > test and one that _aced_ the test?
> > 
> > > Not that I have seen.
>
> I would think there is about as much difference as a 
> doctor who simply passed and one who _aced_ everything. :)
> 
> The use of a doctor for my example is a bit extreme, but 
> you get my point. hehe

So, did your doctor ace everything? How would you know that? Rather than how
he tested, wouldn't his patient track record be a more useful indicator of
his abilities as a doctor? (You know, no trail of dead patients behind him.)

Besides, the Allaire certification test just tests how well you can answer
questions about CF. It doesn't test your aptitude for developing CF
applications, that's for sure.

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: How turn on Application Mangement

[Michael]

I will give this a try


"Robert Long" <[EMAIL PROTECTED]> wrote in message
B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01">news:B1A5B5B556DBD31190F800508B55FD6C99FB5F@EXCHANGE01...
> Michael,
> How do you know it's not on?
> If you set  in the application.cfm
> and set other parameters such as clientmanagement="yes" and
> sessionmanagement="yes"
> then it should be turned on. You need to set some variables to know for
> sure,
> for example. In the application.cfm put
> 
> 
>
> Then in the index.cfm page (or another page) put
>
> 
> name: #session.name#
> Is it working: #session.IsThisWorking#
> 
>
> You can replace session with application, client, or whatever...
>
> hth
>
>
> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 8:40 AM
> To: CF-Talk
> Subject: How turn on Application Mangement
>
>
> Where do you do this?  I have a seperate Application.cfm that has
>  and I still cant figure out why
> this tag is not working, everything is in the proper directory.
>
> TIA
>
> Michael
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: DHTML

[James Taavon]

We will be using Netscape 4.74

"DeVoil, Nick" wrote:
> 
> The only issue is cross-browser compatibility, particularly if
> you have to support Netscape 4.
> 
> Nick
> 
> -Original Message-
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 02, 2001 5:04 PM
> To: CF-Talk
> Subject: OT: DHTML
> 
> Anybody having issues with CF and DHTML? I am considering it for a new
> app that we will be developing. Purpose being to get around using frames
> since we can't.
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: DHTML

[Philip Arnold - ASP]

> Anybody having issues with CF and DHTML? I am considering it for a new
> app that we will be developing. Purpose being to get around using frames
> since we can't.

CF=Server Side
DHTML=Client Side

Since CF sends text or images (depending on CFContent) to the browser, it
doesn't care what information gets there - you can make it DHTML, HTML, XML
or anything else you can think of

As long as your DHTML is clean, there won't be any issues

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

"Websites for the real world"

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


> -Original Message-
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: 02 March 2001 17:04
> To: CF-Talk
> Subject: OT: DHTML
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Populate array with query

[allred]

Thanks to all who responded. Kevin and Bryan suggested using
sum(queryColumn) as xxx. However, I wanted to use this as an opportunity to
explore arrays, which I had not previously felt the need to use.

I found what I needed in ValueList and ListToArray. Three lines gives me
the desired results:





Regards,
--John




   
 
Bryan Love 
 
   
 
t.com>   cc:   
 
 Subject: RE: Populate array with query
 
03/01/2001 
 
04:23 PM   
 
Please 
 
respond to 
 
cf-talk
 
   
 
   
 




best to do math in the SQL of the query itself (if you are running a
query):

SELECT sum(hours) AS totalHours,
sum(hours * 65) AS totalCost
FROM hoursTable
WHERE bla = bla

CF is extremely slow compared to enterprise level databases such as SQL
Server 7 and Oracle.  If you insist on using CF, however, do this:




The sum of the numbers is #totalHours# hours. At $65/hr,
this equals #dollarformat(cost)#


Just leave the the ArraySum function out of the CFOUTPUT tags and you won't
get the YES output

Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 1:58 PM
To: CF-Talk
Subject: Populate array with query


Hi,

Can someone suggest a better way to sum a numeric column in a query? The
solution is probably painfully simple, but I've been struggling for an hour
or two on it (only have online docs available).

#ArrayDeleteAt(GetHours,1)#

   #ArrayAppend(GetHours, "#numberformat(hours)#")#


Line 3 produces a string of "YES"s at the top of my output- one for every
record in the query.

The following gives me the result I need, but I can't get around the
display of the YES's that appears.



The sum of the numbers is #ArraySum(GetHours)# hours. At $65/hr,
this equals #dollarformat(cost)#


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

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

RE: Allaire Cert Question

[Philip Arnold - ASP]

> Besides, the Allaire certification test just tests how well you can answer
> questions about CF. It doesn't test your aptitude for developing CF
> applications, that's for sure.

Also it's a test of what they want to hear, not real world

There are several questions where there are 2 or 3 real answers and they say
there's only one...

The problem is that it just means you can answer parrot fashion, doesn't
mean you can build a whole website for a client and how good it'll be

> So, did your doctor ace everything? How would you know that? Rather than
how
> he tested, wouldn't his patient track record be a more useful indicator of
> his abilities as a doctor? (You know, no trail of dead patients behind
him.)

Look, no dead bodies behind me...  

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

"Websites for the real world"

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



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

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

RE: Allaire Cert Question

[Dave Watts]

> > > Is there a difference (that can be seen by a third party) 
> > > between an Allaire Certified Developer that passed the 
> > > test and one that _aced_ the test?
> > 
> > > Not that I have seen.
>
> I would think there is about as much difference as a 
> doctor who simply passed and one who _aced_ everything. :)
> 
> The use of a doctor for my example is a bit extreme, but 
> you get my point. hehe

So, did your doctor ace everything? How would you know that? Rather than how
he tested, wouldn't his patient track record be a more useful indicator of
his abilities as a doctor? (You know, no trail of dead patients behind him.)

Besides, the Allaire certification test just tests how well you can answer
questions about CF. It doesn't test your aptitude for developing CF
applications, that's for sure.

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

[DeVoil, Nick]

The only issue is cross-browser compatibility, particularly if
you have to support Netscape 4.

Nick

-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 5:04 PM
To: CF-Talk
Subject: OT: DHTML


Anybody having issues with CF and DHTML? I am considering it for a new
app that we will be developing. Purpose being to get around using frames
since we can't.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: DHTML

[Dave Watts]

> Anybody having issues with CF and DHTML? I am considering it 
> for a new app that we will be developing. Purpose being to get 
> around using frames since we can't.

We've used DHTML extensively, with no trouble. CF works with any client-side
browser technology.

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: Parsing Text with CFHTTP

[Joseph Thompson]

> Anyone have any tutorials or explainations on how to do this
effectively???
>

There is a live example here.. depends on what you are trying to
accomplish...

http://cfhub.com/advanced/cfhttp/query.cfm


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

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

Re: DHTML

[Alex Schrimsher]

Have you considered a "handler" page.  Works like a frame; all your pages
feed into the main "handler"

We've had great success with it!
Alex


- Original Message -
From: "James Taavon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 12:04 PM
Subject: OT: DHTML


> Anybody having issues with CF and DHTML? I am considering it for a new
> app that we will be developing. Purpose being to get around using frames
> since we can't.
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: DHTML

[James Taavon]

Anybody having issues with CF and DHTML? I am considering it for a new
app that we will be developing. Purpose being to get around using frames
since we can't.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Stored Procedures and HTML form List

[Dave Watts]

> > To the best of my knowledge, you can't do this. What you can 
> > do to get the same effect, though, is to execute a string 
> > containing your SQL statement ...
> > ...
> > Of course, this isn't an optimal solution.
>
> Thanks!  That's almost exactly what I was looking for. I'll 
> try it today. Why would it not be an optimal solution? Is it 
> slower or can that function only be used in certain situations?

It's slower, because it can't take advantage of existing query plans as
well.

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: How turn on Application Mangement

[Robert Long]

Michael, 
How do you know it's not on? 
If you set  in the application.cfm 
and set other parameters such as clientmanagement="yes" and
sessionmanagement="yes"
then it should be turned on. You need to set some variables to know for
sure,
for example. In the application.cfm put 
 


Then in the index.cfm page (or another page) put


name: #session.name#
Is it working: #session.IsThisWorking#


You can replace session with application, client, or whatever...

hth


-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 8:40 AM
To: CF-Talk
Subject: How turn on Application Mangement


Where do you do this?  I have a seperate Application.cfm that has
 and I still cant figure out why
this tag is not working, everything is in the proper directory.

TIA

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

CF / SQL 2000 XML?

[Michel Vuijlsteke]

Is it possible to use the new XML output in SQL Server 2000 in ColdFusion
with thing like this:


SELECT * FROM authors FOR XML auto



#something#


where "something" is the name of the "field" SQL server returns the XML in.

There's always just one field, and you can obviously get its name with
#test.columnlist#, but the problem is that this "field" has a name with
dashes in it (e.g. XML_F52E2B61-18A1-11D1-B105-00805F49916B), and that CF
chokes on the variable name.

Any ideas anyone?

Michel Vuijlsteke
NEtpoint

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

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

Good CF training/conference/seminar?

[Ryan]

Can anyone who has been to several ColdFusion seminars recommend a
good one? I'm looking at "Best Practices with ColdFusion and Fusebox",
is this a good one? I tried searching the archives to see what
people were saying about it, but all I could find is Hal's
signature.  >:|

Also considering cf_west, but I don't really have any idea what the
agenda is there. Trying to get the best/most training for my buck.
Not looking for beginner stuff, either. Thanks for any info.

Ryan


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

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

RE: Allaire Cert Question

[Stewart McGowan]

Stand back I have the power of certification at my
fingertips


Regards


Stew
(back from vacation)

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

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

RE: CFMail - Sending a link in an email

[Robert Long]

I think Melissa nailed it. You need to supply some kind of address
in the link tag. Since the email client is not a browser, it needs
specific directions to the page you are linking to. So using
http://intranet/usercalldisplay.cfm or something like that will help
it find it's way to the page.

Hope that helps.

-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 9:47 AM
To: CF-Talk
Subject: Re: CFMail - Sending a link in an email


Try putting in the entire address without the href tag. For example:
http://www.yoursite.com/UserCallDisplay.cfm

If I understand the other responses to your question correctly, when Outlook
sees the http://  it will create a
link.

Melissa

"Gieseman, Athelene" wrote:

> OK, let me try to post the code again.  this time I change the tag in this
> message to say CF_mail.  I'm guessing the post didn't like the real tag.
>
> 
>
>  subject="New Help Desk Ticket" type="HTML">Thank you for
> reporting your issue to the Help Desk.  Your call was logged into
> our database at #prettydatetime#.  If your problem was not resolved at the
> time of your call you will be hearing back from a technician shortly.
> 
> Call Information
> Ticket Number:  #GetCall.ID#
> Problem Description:  
> #GetCall.Issue#
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Angel Stewart]

i.e. most of the people running such sites are not properly licensed because
Microsoft requires you go on a course and sit an exam to be Microsoft
Licensing Professional Certified.
ROFLMAO
^_^


*ahem*
sorry..returning you to regularly scheduled serious stuff now..
hee hee
-Gel
www.carigamer.com


-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]

How can they make this such a debacle? SAY IT!!! The license is
$.xx. Call here. Pay here. Sign here.
--


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

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

RE: Allaire Cert Question

[Robert Long]

I would think there is about as much difference as a 
doctor who simply passed and one who _aced_ everything. :)

The use of a doctor for my example is a bit extreme, but 
you get my point. hehe

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 10:53 PM
To: CF-Talk
Subject: Re: Allaire Cert Question


Not that I have seen.

Dave Crawford
Allaire Certified ColdFusion Developer


- Original Message -
From: "Jay Jennings" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 23:23
Subject: Allaire Cert Question


> Is there a difference (that can be seen by a third party) between an
Allaire
> Certified Developer that passed the test and one that _aced_ the test?
>
>  jj
>
>  - - - - -
> Get your free email account: [EMAIL PROTECTED]
> Sign up at http://www.alakazam.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: select records from table 1, that are not in table 2 ?

[Vano, Carl G, SITS]

Thanks for the help everyone, it worked perfect! 

-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:05 PM
To: CF-Talk
Subject: RE: select records from table 1, that are not in table 2 ?



try this, but be prepared for a slow query if the rows aren't indexed or if
the tables are big:

SELECT letters
FROM table1
WHERE pKey NOT IN (SELECT letters FROM table2)


Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: Vano, Carl G, SITS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 1:20 PM
To: CF-Talk
Subject: SQL: select records from table 1, that are not in table 2 ?


How would I select only the records from table 1, that are not in table 2.

1   2
A   A
B   B
C   C   
D   
E   
F

expected query result:

D
E
F   


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

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

RE: Using XML as datsource in CF

[Michael Rosario]

I don't think this possible in CF.   The closest thing to it is using WDDX.
Check out http://www.wddx.org


-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 7:58 AM
To: CF-Talk
Subject: Using XML as datsource in CF


Hello,

Has anyone used CFQUERY with XML documents as a datasource? 

Is this even possible?

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

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

RE: Stored Procedures and HTML form List

[Craig Bowes]

Thanks!  That's almost exactly what I was looking for.  I'll try it today.
Why would it not be an optimal solution?  Is it slower or can that function
only be used in certain situations?

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:38 PM
To: CF-Talk
Subject: RE: Stored Procedures and HTML form List

> Is there a way to tell SQL Server that the string you are
> passing it in a stored procedure should be evaluated as a
> list of numbers, not a string?  I'm passing it a an HTML
> form field list.
>
> Here's a test I did for the stored procedure:
>
> declare @mylist varchar(50)
> set @mylist = '34,35,36,37'
>
> select * from focusareas
> where focusareaid IN (@mylist)
>
> the @mylist variable is actually going to be my form field
> list which will have the values. Problem is, SQL sees it as
> ONE String value, not a list of values and gives me this error:
>
> Syntax error converting the varchar value '34,35,36,37' to a
> column of data type int.
>
> I've tried just about everything. Even if I make double quotes
> around all the numbers, it still treats the whole thing as one
> string.

To the best of my knowledge, you can't do this. What you can do to get the
same effect, though, is to execute a string containing your SQL statement
(note that this example is SQL Server-specific):

CREATE PROC myproc

@mylist VARCHAR(50)

AS

sp_executesql("SELECT * FROM FOCUSAREAS WHERE FOCUSAREAID IN (" + @mylist +
")")

Of course, this isn't an optimal solution.

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: What does OT mean?

[Richard Banks]

Occupational Therapist

-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:21 PM
To: CF-Talk
Subject: RE: What does OT mean?


OFF TOPIC! :)

> -Original Message-
> From: Paul Ihrig [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 3:40 PM
> To:   CF-Talk
> Subject:  RE: What does OT mean?
>
> Off Track Betting.
>
> -paul
>
> Web Developer, NBBJ
> Work: [EMAIL PROTECTED]
>   614 241-3534
> fax:  614 485-5534
>
> Home: [EMAIL PROTECTED]
>   614 449-1681
>
> > icq:47658358
> >
> > -Original Message-
> > From:   Phoeun Pha [SMTP:[EMAIL PROTECTED]]
> > Sent:   Saturday, November 11, 2000 5:17 AM
> > To: CF-Talk
> > Subject:What does OT mean?
> >
> > Other things??
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Using XML as datsource in CF

[DeVoil, Nick]

It might be possible to do this via SQL with
SQL Server 2000 using the OPENXML function?

Nick

-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 12:58 PM
To: CF-Talk
Subject: Using XML as datsource in CF


Hello,

Has anyone used CFQUERY with XML documents as a datasource? 

Is this even possible?

Rick


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

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

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

RE: cfmodule oddness

[Sandra Clark]

Not in Custom Tags. They run in their own space.  Request, Session and
Application variables are passed through, but any other variables that you
pass as parameters must be referenced as Attributes.variable.  Conversely if
you want to send something back to the calling template, you must user
Caller.variable, then reference it with just variable or variables.variable
in the calling template.

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 1:09 AM
To: CF-Talk
Subject: RE: cfmodule oddness


Ah ha !
Cheers muchly :-)

I though CF would automagicly try attributes.,cookies., etc. if you just
gave it a variable name ?
-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:19 PM
To: CF-Talk
Subject: RE: cfmodule oddness


Are you using Attributes.x in the custom tag?

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 8:05 AM
To: CF-Talk
Subject: cfmodule oddness


I'm using

but get the error
The required parameter x was not provided.
From
d:\CFUSION\CustomTags\EMEA\bot.cfm.

What gives ? The documentation says you can do this...

Regards,

Thomas Chiverton,
Intranet Webmaster and Desktop Analyst
Office: 01565 757 909
As a GUI, reality in useless...
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CFMail - Sending a link in an email

[Melissa Fraher]

Try putting in the entire address without the href tag. For example: 
http://www.yoursite.com/UserCallDisplay.cfm

If I understand the other responses to your question correctly, when Outlook sees the 
http://  it will create a
link.

Melissa

"Gieseman, Athelene" wrote:

> OK, let me try to post the code again.  this time I change the tag in this
> message to say CF_mail.  I'm guessing the post didn't like the real tag.
>
> 
>
>  subject="New Help Desk Ticket" type="HTML">Thank you for
> reporting your issue to the Help Desk.  Your call was logged into
> our database at #prettydatetime#.  If your problem was not resolved at the
> time of your call you will be hearing back from a technician shortly.
> 
> Call Information
> Ticket Number:  #GetCall.ID#
> Problem Description:  
> #GetCall.Issue#
> 
> 
>


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

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

Re: Allaire Cert Question

[Cary Gordon]

Possibly

At 08:23 PM 3/1/2001 -0800, you wrote:
>Is there a difference (that can be seen by a third party) between an Allaire
>Certified Developer that passed the test and one that _aced_ the test?
>
>  jj


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Dylan Bromby]

MSDN doesn't include commercial licensing, which is what he was looking for.

and universal is only $2,500.

-Original Message-
From: Martin Sutton [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 7:21 AM
To: CF-Talk
Subject: RE: M$ licensing has me at wits end


Go for MSDN, you get all Microsoft software for in house use.  I think its
$15k / year.  Thats worth a look because you get all versions and all
updates of all their software.

I think thats right, my company is on MSDN and we get everything


-
LEGAL DISCLAIMER --
This message and any attachments to it is intended only for the individual
or company to which it is addressed and may contain information which is
privileged, confidential or prohibited from disclosure or unauthorised use.
If the recipient of this transmission is not the intended recipient, or the
employee or agent responsible for delivering such materials to the intended
recipient, you are hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message or its attachments other than by its
intended recipient is strictly prohibited by the sender. If you have
received it in error, please return it to the sender and destroy the message
and/or copies in your possession.  The views or opinions expressed in this
email are that of the individual and not necessarily those of A.B.C (Systems
and Development) Limited or any of it's subsidiaries.



-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 15:00
To: CF-Talk
Subject: M$ licensing has me at wits end


AAARRRGGGHH!

OK, so. I get my copy of SQL Server 2000 with the Processor license
thinking that's all I'm going to need. Open the box, read the
license. WHOOPS! No commercial hosting allowed under this license.
Seems it's only good for your own personal website. Great deal for
4,200.00.

So, now I've spent the past 3 days on and off the phone with
Microsoft. First I need an Application Service provider license. "Get
it from Dell or CDW" they say. Call Dell and CDW. "What's an
Application Service Provider license?" is the response from both of
them.

Back on the phone with Microsoft. "Oh. you were misled. You need the
Microsoft Commercial Internet Services license. To be licensed as an
ASP, you have to have at least 2 people MCSE certified that work for
the company". Send me to their web page. Read that I need a MCSI
"Server" license and MCSI "Domain Access license" for every domain
using SQL. There are only 2 companies in the US that sell MCIS
licenses. Call the first one. "What's a Microsoft Commercial Internet
Services license? What's a Domain Access license? We'll try and find
out what you're talking about and call you back.".

Is anyone out there hosting commercial web sites and using SQL Server
as the database? How are you licensed? If as a MCSI, where did you
get it? Are you just pretending ignorant and using the processor
license or CALs? I've got over $10,000.00 invested here and can't
even take the stuff out of the box. I don't see how anyone can be
purchasing these licenses as one of the only 2 companies in the US
that sells them don't know what it is. I'm too fed up to even call
the other one yet.

How can they make this such a debacle? SAY IT!!! The license is
$.xx. Call here. Pay here. Sign here.
--

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: M$ licensing has me at wits end

[Martin Sutton]

I neglected to mention that obviously it wouldn't solve your commercial
problems but it might save you money in the long term.  Sorry I cannot say
more.


-
LEGAL DISCLAIMER --
This message and any attachments to it is intended only for the individual
or company to which it is addressed and may contain information which is
privileged, confidential or prohibited from disclosure or unauthorised use.
If the recipient of this transmission is not the intended recipient, or the
employee or agent responsible for delivering such materials to the intended
recipient, you are hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message or its attachments other than by its
intended recipient is strictly prohibited by the sender. If you have
received it in error, please return it to the sender and destroy the message
and/or copies in your possession.  The views or opinions expressed in this
email are that of the individual and not necessarily those of A.B.C (Systems
and Development) Limited or any of it's subsidiaries.



-Original Message-
From: Martin Sutton [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 15:21
To: CF-Talk
Subject: RE: M$ licensing has me at wits end


Go for MSDN, you get all Microsoft software for in house use.  I think its
$15k / year.  Thats worth a look because you get all versions and all
updates of all their software.

I think thats right, my company is on MSDN and we get everything


-
LEGAL DISCLAIMER --
This message and any attachments to it is intended only for the individual
or company to which it is addressed and may contain information which is
privileged, confidential or prohibited from disclosure or unauthorised use.
If the recipient of this transmission is not the intended recipient, or the
employee or agent responsible for delivering such materials to the intended
recipient, you are hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message or its attachments other than by its
intended recipient is strictly prohibited by the sender. If you have
received it in error, please return it to the sender and destroy the message
and/or copies in your possession.  The views or opinions expressed in this
email are that of the individual and not necessarily those of A.B.C (Systems
and Development) Limited or any of it's subsidiaries.



-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 15:00
To: CF-Talk
Subject: M$ licensing has me at wits end


AAARRRGGGHH!

OK, so. I get my copy of SQL Server 2000 with the Processor license 
thinking that's all I'm going to need. Open the box, read the 
license. WHOOPS! No commercial hosting allowed under this license. 
Seems it's only good for your own personal website. Great deal for 
4,200.00.

So, now I've spent the past 3 days on and off the phone with 
Microsoft. First I need an Application Service provider license. "Get 
it from Dell or CDW" they say. Call Dell and CDW. "What's an 
Application Service Provider license?" is the response from both of 
them.

Back on the phone with Microsoft. "Oh. you were misled. You need the 
Microsoft Commercial Internet Services license. To be licensed as an 
ASP, you have to have at least 2 people MCSE certified that work for 
the company". Send me to their web page. Read that I need a MCSI 
"Server" license and MCSI "Domain Access license" for every domain 
using SQL. There are only 2 companies in the US that sell MCIS 
licenses. Call the first one. "What's a Microsoft Commercial Internet 
Services license? What's a Domain Access license? We'll try and find 
out what you're talking about and call you back.".

Is anyone out there hosting commercial web sites and using SQL Server 
as the database? How are you licensed? If as a MCSI, where did you 
get it? Are you just pretending ignorant and using the processor 
license or CALs? I've got over $10,000.00 invested here and can't 
even take the stuff out of the box. I don't see how anyone can be 
purchasing these licenses as one of the only 2 companies in the US 
that sells them don't know what it is. I'm too fed up to even call 
the other one yet.

How can they make this such a debacle? SAY IT!!! The license is 
$.xx. Call here. Pay here. Sign here.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: M$ licensing has me at wits end

[Martin Sutton]

Go for MSDN, you get all Microsoft software for in house use.  I think its
$15k / year.  Thats worth a look because you get all versions and all
updates of all their software.

I think thats right, my company is on MSDN and we get everything


-
LEGAL DISCLAIMER --
This message and any attachments to it is intended only for the individual
or company to which it is addressed and may contain information which is
privileged, confidential or prohibited from disclosure or unauthorised use.
If the recipient of this transmission is not the intended recipient, or the
employee or agent responsible for delivering such materials to the intended
recipient, you are hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message or its attachments other than by its
intended recipient is strictly prohibited by the sender. If you have
received it in error, please return it to the sender and destroy the message
and/or copies in your possession.  The views or opinions expressed in this
email are that of the individual and not necessarily those of A.B.C (Systems
and Development) Limited or any of it's subsidiaries.



-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 15:00
To: CF-Talk
Subject: M$ licensing has me at wits end


AAARRRGGGHH!

OK, so. I get my copy of SQL Server 2000 with the Processor license 
thinking that's all I'm going to need. Open the box, read the 
license. WHOOPS! No commercial hosting allowed under this license. 
Seems it's only good for your own personal website. Great deal for 
4,200.00.

So, now I've spent the past 3 days on and off the phone with 
Microsoft. First I need an Application Service provider license. "Get 
it from Dell or CDW" they say. Call Dell and CDW. "What's an 
Application Service Provider license?" is the response from both of 
them.

Back on the phone with Microsoft. "Oh. you were misled. You need the 
Microsoft Commercial Internet Services license. To be licensed as an 
ASP, you have to have at least 2 people MCSE certified that work for 
the company". Send me to their web page. Read that I need a MCSI 
"Server" license and MCSI "Domain Access license" for every domain 
using SQL. There are only 2 companies in the US that sell MCIS 
licenses. Call the first one. "What's a Microsoft Commercial Internet 
Services license? What's a Domain Access license? We'll try and find 
out what you're talking about and call you back.".

Is anyone out there hosting commercial web sites and using SQL Server 
as the database? How are you licensed? If as a MCSI, where did you 
get it? Are you just pretending ignorant and using the processor 
license or CALs? I've got over $10,000.00 invested here and can't 
even take the stuff out of the box. I don't see how anyone can be 
purchasing these licenses as one of the only 2 companies in the US 
that sells them don't know what it is. I'm too fed up to even call 
the other one yet.

How can they make this such a debacle? SAY IT!!! The license is 
$.xx. Call here. Pay here. Sign here.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CFX_File problem

[Paul Johnston]

I have started and stopped the services, the machine and nothing works.  I
downloaded it off the developers exchange a few days ago, and tried it on
and off for several days.

I have followed the instructions on how to install the CFX_File tag, and as
far as I can tell, I have nothing in the setup that doesn't work.

Anyone know of any problems with the tag?

Paul

- Original Message -
From: "Vano, Carl G, SITS" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 5:53 PM
Subject: RE: CFX_File problem


> Paul, did you start&stop cf services?
>
> -Original Message-
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 6:46 AM
> To: CF-Talk
> Subject: CFX_File problem
>
>
> Anyone?
>
> Am using CFX_File downloaded from the allaire developers exchange and
can't
> seem to get it to work!  It just returns an error of
>
> Unknown Action: "READ"
>
> or some such other action (that is blatantly obvious cos it's in the
docs).
> The code I am using is (for a copy):
>
>  username="test"
> password="test"
> action="copy"
> source="C:\inetpub\wwwroot\index.cfm"
> destination="C:\inetpub\wwwroot\index_copy.cfm">
>
> Win2k Pro, CF Pro 4.5.1 SP2
>
> Anyone?  Am I missing something in Win2k or is it the tag?
>
> Paul
> 
> Paul Johnston
> PJ Net Solutions Ltd (UK)
> E: [EMAIL PROTECTED]
> M: 07866 573013
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: unsorted QueryName.ColumnList?

[Stephen Kellogg]

cfx_QueryColumns

http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347299-2830-11D4-AA
9700508B94F380&method=Full

That link was posted previously to a similar question... I haven't used it
and am not sure if it will help.

Stephen

-Original Message-
From: Boskovic, Ante [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 3:59 PM
To: CF-Talk
Subject: RE: unsorted QueryName.ColumnList?


Arden, we're talking about columns not records :) ...

I've searched the archive (thx Andy:) and found a WDDX approach for the
problem: WDDX packet contains column list in original order, as in the
database.

I've also found custom tag (thx Benjamin, it does work with Oracle:) on
Developers Exchange at
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347299-2830-11D4-AA
9700508B94F380&method=Full which works fine but the author mentioned
possibility of memory leaks in his disclaimer ...





> -Original Message-
> From: Arden Weiss [mailto:[EMAIL PROTECTED]]
>
> As this doggie understands, there is no implied order of data
> entry in a
> "real" database like oracle, etc. and unlike some desktop
> databases like
> FoxPro, etc.
>
> Hence, if you want to keep track of the order in which the
> records are
> added, you will need to insert a field and update it with a
> cronolgical
> number or key or a down to the milisecond date/time stamp.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

i need List Help (and a thanks)

[Jay Patton]

I submitted this again because im not sure that it went through the first time.

I'm back with another question ( imagine that :)
First i would like to say thanks to everyone that has helped me so far a lot of things 
have worked great!

what i have is a form that has 6 selection box's (all multiple select box's) which 
list's all of the contestans in a circuit.
if i select just one person for each place 1st through 6th everything is great. 
however when i need to select two for 
a place (example: tie in first or something like that) im trying to get the insert 
page to put each contestant on there own
row in the DB. rather than put a comma between the ContestantID's This is what i have 
now but for some reason it still adds the
comma's and doesnt put them on there own row.












Select Contestant 
#LastName#, #FirstName# (#Age#)





























INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, TimeTaken, Points, 
AdjPoints, MoneyEarned, NotAllAround)
VALUES (
'#RodeoID#',
'#EventID#',
'#ContestantID#',
#Place#,
#TimeTaken#,
#Points#,
#AdjPoints#,
#MoneyEarned#,
#NotAllAround#)













INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, TimeTaken, Points, 
AdjPoints, MoneyEarned, NotAllAround)
VALUES (
'#RodeoID#',
'#EventID#',
'#ContestantID#',
#Place#,
#TimeTaken#,
#Points#,
#AdjPoints#,
#MoneyEarned#,
#NotAllAround#)




 

Thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
[EMAIL PROTECTED]


**
"Trust Everyone
But Always Cut The Cards."
**


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

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

Variable

[JL]

Besides form and url variables, what other variables could I pass them within
each browser instance?  I want each browser instance has separate values of
the variables.  For instance, there are browser A and browser B.  A has
variables x=1 y=2 z=3.  B has variables x=11 y=12 z=13.  I want x, y, and z to
be passed in each pages in each browser instance.  And A and B exist in the
SAME machine by the SAME user.  And let say A and B are Netscape or IE but not
mix.  Is this possible?  Thanks in advance.

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

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

M$ licensing has me at wits end

[Bud]

AAARRRGGGHH!

OK, so. I get my copy of SQL Server 2000 with the Processor license 
thinking that's all I'm going to need. Open the box, read the 
license. WHOOPS! No commercial hosting allowed under this license. 
Seems it's only good for your own personal website. Great deal for 
4,200.00.

So, now I've spent the past 3 days on and off the phone with 
Microsoft. First I need an Application Service provider license. "Get 
it from Dell or CDW" they say. Call Dell and CDW. "What's an 
Application Service Provider license?" is the response from both of 
them.

Back on the phone with Microsoft. "Oh. you were misled. You need the 
Microsoft Commercial Internet Services license. To be licensed as an 
ASP, you have to have at least 2 people MCSE certified that work for 
the company". Send me to their web page. Read that I need a MCSI 
"Server" license and MCSI "Domain Access license" for every domain 
using SQL. There are only 2 companies in the US that sell MCIS 
licenses. Call the first one. "What's a Microsoft Commercial Internet 
Services license? What's a Domain Access license? We'll try and find 
out what you're talking about and call you back.".

Is anyone out there hosting commercial web sites and using SQL Server 
as the database? How are you licensed? If as a MCSI, where did you 
get it? Are you just pretending ignorant and using the processor 
license or CALs? I've got over $10,000.00 invested here and can't 
even take the stuff out of the box. I don't see how anyone can be 
purchasing these licenses as one of the only 2 companies in the US 
that sells them don't know what it is. I'm too fed up to even call 
the other one yet.

How can they make this such a debacle? SAY IT!!! The license is 
$.xx. Call here. Pay here. Sign here.
-- 

Bud Schneehagen - Tropical Web Creations

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: cfmodule oddness

[Patricia Lee]

That only happens for the most basic scopes.  The behavior is a bit of a
vestigal tail...  not supported for any new variable type.

variables.
form.
url.

I'm not surre about cookie. (I could do a quick test but I'm feeling an
attack of laziness coming on).

All others, assume NOT.  Yet another reason why one should
strive to properly scope one's variables...

|-Original Message-
|From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
|Sent: Friday, March 02, 2001 4:09 AM
|To: CF-Talk
|Subject: RE: cfmodule oddness
|
|
|Ah ha !
|Cheers muchly :-)
|
|I though CF would automagicly try attributes.,cookies., etc. 
|if you just
|gave it a variable name ?
|-Original Message-
|From: Sandra Clark [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, March 01, 2001 5:19 PM
|To: CF-Talk
|Subject: RE: cfmodule oddness
|
|
|Are you using Attributes.x in the custom tag?
|
|-Original Message-
|From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, March 01, 2001 8:05 AM
|To: CF-Talk
|Subject: cfmodule oddness
|
|
|I'm using
|
|but get the error
|The required parameter x was not provided.
|From
|d:\CFUSION\CustomTags\EMEA\bot.cfm.
|
|What gives ? The documentation says you can do this...
|
|Regards,
|
|Thomas Chiverton,
|Intranet Webmaster and Desktop Analyst
|Office:01565 757 909
|As a GUI, reality in useless...
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 turn on Application Mangement

[Michael]

Where do you do this?  I have a seperate Application.cfm that has
 and I still cant figure out why
this tag is not working, everything is in the proper directory.

TIA

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

isolation level explination.

[Jason Lees (National Express)]

Hi All,

Can anybody explain the cftransaction tag isolation parameter.  As I dont
seem to be able to find any information other than very basic explinations.

What is happeing is if I place a Read_uncommited level on a DB Read, when I
update the same table I get a 'Cannot Update a table that is Read Only'.

I tried then putting a Read_Uncommited level on the update, but the running
queries went off the scale. 

Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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

Using XML as datsource in CF

[Richard L Smith]

Hello,

Has anyone used CFQUERY with XML documents as a datasource? 

Is this even possible?

Rick





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

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

RE: Problem with login code

[Philip Arnold - ASP]

> Do something like this:
>
> error checking page.
>
>   
>   
>  
> 

Actually, Netscape will fail on the message, it should be


Personally I don't like or use CFLocation as it causes another CF request
when it's not needed

I tend to put a CFInclude in the template depending on the outcome of the
login

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

"Websites for the real world"

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



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

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

RE: Problem with login code

[Javed Mushtaq]

Do something like this:

error checking page.

  
  
 




  
  


Then on login page.



  alert(#URL.strErrorMsg#); 



That should do the trick !

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

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

RE: Problem with login code

[Jason Lees (National Express)]

Why not use the Login Page to validate the User?

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 10:55
To: CF-Talk
Subject: Problem with login code


Hi everyone,

The code below is a loginaction template.  It's supposed to give an error
message if the wrong id or password is given on a login form, or if either
or both aren't given.  Instead, it only gives the message if something is
missing.  If something is wrong, it simply sends the user back to the login
page, with no error message.  Is it possible to 'tweak' the code to get it
to work (and if so, can you please suggest how to do so), or is there
something so fundamentally wrong with it that it needs to be rewritten from
scratch?




 SELECT username, password
 FROM   WordJokes
 WHERE  WordJokes.username = '#form.username#' AND
WordJokes.password = '#form.password#'



  

  

  
  

  

  
  
 




  
  


Sincerely,

---
Hubert Earl

ICQ#: 16199853

See pictures of items in my Jamaican Art, Craft & More Store Online Sale on
my "Me" page on eBay (this tells you a little about myself, including a
photo), and there's a link to the auctions themselves:
http://members.ebay.com/aboutme/hearl1/

See pictures of all items I have:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Problem with login code

[Adkins, Randy]

Are you passing the variable back to the Login.cfm form?
On the Login.cfm page are you displaying the ERRORMESSAGE?

You should pass it back to the template and check
for its existence and if exists display the message



-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 5:55 AM
To: CF-Talk
Subject: Problem with login code


Hi everyone,

The code below is a loginaction template.  It's supposed to give an error
message if the wrong id or password is given on a login form, or if either
or both aren't given.  Instead, it only gives the message if something is
missing.  If something is wrong, it simply sends the user back to the login
page, with no error message.  Is it possible to 'tweak' the code to get it
to work (and if so, can you please suggest how to do so), or is there
something so fundamentally wrong with it that it needs to be rewritten from
scratch?




 SELECT username, password
 FROM   WordJokes
 WHERE  WordJokes.username = '#form.username#' AND
WordJokes.password = '#form.password#'



  

  

  
  

  

  
  
 




  
  


Sincerely,

---
Hubert Earl

ICQ#: 16199853

See pictures of items in my Jamaican Art, Craft & More Store Online Sale on
my "Me" page on eBay (this tells you a little about myself, including a
photo), and there's a link to the auctions themselves:
http://members.ebay.com/aboutme/hearl1/

See pictures of all items I have:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Problem with login code

[Hubert Earl]

Hi everyone,

The code below is a loginaction template.  It's supposed to give an error
message if the wrong id or password is given on a login form, or if either
or both aren't given.  Instead, it only gives the message if something is
missing.  If something is wrong, it simply sends the user back to the login
page, with no error message.  Is it possible to 'tweak' the code to get it
to work (and if so, can you please suggest how to do so), or is there
something so fundamentally wrong with it that it needs to be rewritten from
scratch?




 SELECT username, password
 FROM   WordJokes
 WHERE  WordJokes.username = '#form.username#' AND
WordJokes.password = '#form.password#'



  

  

  
  

  

  
  
 




  
  


Sincerely,

---
Hubert Earl

ICQ#: 16199853

See pictures of items in my Jamaican Art, Craft & More Store Online Sale on
my "Me" page on eBay (this tells you a little about myself, including a
photo), and there's a link to the auctions themselves:
http://members.ebay.com/aboutme/hearl1/

See pictures of all items I have:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 'n' FLASH problem

[James Maltby]

The problem I get is with this code:

The flash movie pulls in the var "menutxt" from menu.cfm the code in
menu.cfm is:


SELECT X, Y, X_url, Y_url FROM
X_table ORDER BY X


MenuText= #X#




The output "part" works as I get the value X outputted as a link, but after
the first row I get 

MenuText X
MenuText X
MenuText X (etc)

As the output loop appends it to the front of the output

Second problem I get is that the dot.gif image does not appear - but I guess
I will have to do a work around for that

J

-Original Message-
From: dennis baldwin [mailto:[EMAIL PROTECTED]]
Sent: 01 March 2001 20:05
To: CF-Talk
Subject: RE: CF 'n' FLASH problem


We're currently workin' on a developer community for flash and CF and you
can check out some tutorials at http://www.flashcfm.com/tutorials/

as for you questions i'm not sure i understand what you are saying with
question 1.  can you be a little more specific?

for pulling images into flash you need to place these images in a .swf file
and then use the LoadMovie command.

-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 1:34 PM
To: CF-Talk
Subject: CF 'n' FLASH problem


OK - here goes - anyone got a solution to this?

Am pulling in a dynamic content page to a menu side bar in a flash.swf

I can get most of the fancy stuff to work - but I am having two problems:

1) If there is more than 1 output from the CFOUTPUT tag - I get the VARTXT=
variable output before every line of the menu
2) The page calls images - can these be pulled in from outside the flash
movie or what?

TIA

James

"You're a big man, but you're out of shape.  With me it's a full time job.
Now behave yourself."
 "Get Carter" 1964
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cfquery table data with the columns in order

[Windle, Kevan]

Does it output in order when you just view the cf page? Could it be
something to do with the link into excel. Perhaps it has trouble with some
data types.

-Original Message-
From: Winston Sia [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 07:33
To: CF-Talk
Subject: cfquery table data with the columns in order


This is a multi-part message in MIME format.

--=_NextPart_000_01A1_01C0A32E.21E43180
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=20
Hi,

Thanks for the info, but I'm afraid it isn't returning columns in =
order... especially for tables with more than five columns..

Below is the sample code that I am currently using.. please make the =
necessary corrections..


   select * from tablename




  
 
 #ColName#
 
  

  
  
 #Evaluate(ColName)#
  
  





Now, this cfm file is used to GET EXTERNAL DATA using MS EXCEL 2000, via =
the NEW WEB QUERY function of Excel.

Once I enter the cfm file, the Excel runs the URL of the cfm file and =
does the query... after a while, the results or data is outputted in the =
excel sheet perfectly as I wanted it, only that the columns are =
SOMETIMES not in order especially when the table has many columns.

Help will be very much appreciated..

Thanks,
Winston


--=_NextPart_000_01A1_01C0A32E.21E43180
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable







 
Hi,
 
Thanks for the info, but I'm afraid it isn't returning columns in =
order...=20
especially for tables with more than five columns..
 
Below is the sample code that I am currently using.. please make =
the=20
necessary corrections..
 
   select * from=20
tablename  =
=20
=20
#ColName# =
   =20
      =20
#Evaluate(ColName)#  =
 =20
&l=
t;/html>Now,=20
this cfm file is used to GET EXTERNAL DATA using MS EXCEL 2000, via the =
NEW WEB=20
QUERY function of Excel.
 
Once I enter the cfm file, the Excel runs the URL of the cfm file =
and does=20
the query... after a while, the results or data is outputted in the =
excel sheet=20
perfectly as I wanted it, only that the columns are SOMETIMES not in =
order=20
especially when the table has many columns.
 
Help will be very much appreciated..
 
Thanks,
Winston
 


--=_NextPart_000_01A1_01C0A32E.21E43180--


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


**

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

**

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

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

RE: Advanced Security question

[Thomas Chiverton]

Go to the admin WWW page, advanced section. Tick the first box.
Go to userdirectorys, and create a new one with namespace=Windows NT, and
location = name of the domain.
Then its just ya standard rules and users (I use the resource view,
resources button on main advanced page).
The Allaire whitepaper is good on explaing theat bit :-)

-Original Message-
From: Vance Duke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 8:49 PM
To: CF-Talk
Subject: Advanced Security question


I am trying to set up and Intranet to use the NT SAM database for user
authentication so as to know which database records the employee has access
to.  We have a domain with all employees obviously able to log into the
domain.  I am trying to set up the Advanced Security but I am unsure where
to start.  This is not going to be used for Development, so I do not need
Sandboxes, correct?  Can someone please give me a direction to go in, or
tell me set up X first, Y second, and Z third, or something along those
lines?

Thanks in advance,
Vance Duke
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Allaire Cert Question

[Philip Arnold - ASP]

> Is there a difference (that can be seen by a third party) between
> an Allaire Certified Developer that passed the test and one that
> _aced_ the test?

That smug air that they exude?

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

"Websites for the real world"

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



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

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

RE: cfmodule oddness

[Thomas Chiverton]

Ah ha !
Cheers muchly :-)

I though CF would automagicly try attributes.,cookies., etc. if you just
gave it a variable name ?
-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:19 PM
To: CF-Talk
Subject: RE: cfmodule oddness


Are you using Attributes.x in the custom tag?

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 8:05 AM
To: CF-Talk
Subject: cfmodule oddness


I'm using

but get the error
The required parameter x was not provided.
From
d:\CFUSION\CustomTags\EMEA\bot.cfm.

What gives ? The documentation says you can do this...

Regards,

Thomas Chiverton,
Intranet Webmaster and Desktop Analyst
Office: 01565 757 909
As a GUI, reality in useless...
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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