RE: pdflib

[Daye, Marianne]

>From http://www.pdflib.com/pdflib/faq.html#q6:

Q: Why does a stamp with the text www.pdflib.com appear on all my pages?

A: This demo stamp appears when one of our binaries distributed by PDFlib
GmbH is used. It can be disabled by purchasing a PDFlib license, and
applying the delivered license key (serial) at runtime with the
PDF_set_parameter() function as indicated in the manual. With the
ActiveX/COM edition of PDFlib the serial can also be supplied during the
installation process.

I think the manual was supposed to be dowloaded with the demo.

Marianne Daye

-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 3:36 PM
To: CF-Talk
Subject: pdflib


one of the developers here is using pdflib and upon generating a pdf there
is a green pdflib.com logo on each page. We have a registered copy, so
licensing shouldn't be an issue.  

has anyone experienced this?

Steven D Dworman
Macromedia Certified Developer
-
Web Consultant
Systems Administrator

ComSpec International - http://www.comspecinternational.com
phone: 248.647.8841
cell:  248.767.9925
-
EMPOWER-XL ***Software for Higher Education***
http://www.empower-xl.com



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF VS ASP <- let the trolling being

[Daye, Marianne]

That does it!!!  I'm gonna have to convert my new group to CF.  ...Don't you
just hate it when the new person tries to tell you how to run things?!

Marianne

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:49 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Well there has always been a CF Enterprise, but MM listens to us on the
group and when we whined and said there wasn't anything free for us to
develop in they offered us a development version of CF Enterprise. It allows
you to use CF Enterprise in it's full functionality, no features taken away.
You just can only use it for one ip address. 

http://www.macromedia.com/software/coldfusion/trial/trial_cf_server.html

http://www.macromedia.com/software/coldfusion/trial/faq/#200


Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-----
From: Daye, Marianne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:36 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Pardon me!  I hadn't heard of CF Enterprise.  Hence the question "Does CF
have an equivalent?".  If I ever get to code in CF again I'll have to look
into that.

I don't know what it is you don't get, but as a part-time telecommuter, I
prefer not to have to rely on a remote server while developing.  As for
using the web site on the laptop, the application contains a lengthy survey
that relies on skip-logic; not something we would want to do over in another
format (gets expensive).

I have no interest in debating whether or not it's 'fair' that ASP is free.
For the young beginner or hobbyist, it's may be the only affordable option
to get started!

Yeah, I guess you can develop CF in Notepad as well; just never did.
Scratch that point.

Have a nice day!

Marianne

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:15 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


1. PWS? What I don't get it. PWS is a web server. Sure ASP is built in,
but you can get a FREE Developer version of CF Enterprise and it can work in
conjunction with PWS. Where's the problem here?

2. Again if you install the free version of CF on the laptop I doubt this
would be an issue. Though I question having an entire web application on a
laptop. If anything I would have given them the information they needed in
another form and made life easier to upload data to the rest of the
application.

Sure you pay for CF, but we already knew this. Not everyone can have 75% of
the world's desktop so they can just offer things for free. I don't see why
you can't program CF in a word processor, matter of fact a lot of my
debugging is on notepad when I am offsite. Sure I love CF Studio, but it is
in no means required. 

I don't understand some of the issues you brought up here. Please explain
better.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Daye, Marianne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:11 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


I have to agree that CF is easier and faster to use than ASP.  However, ASP
does have the advantage of PWS.  Does CF have an equivalent?  I started out
with ASP, then used CF for two years, and now I'm using ASP again.  I'm not
ecstatic about it, but I have found a couple of advantages:

1.  Thanks to PWS, if I want to work from home, I can just copy the ASP site
to my home computer.  With CF I had to work across a cable connection which
slowed things down a bit.  Of course, I have to access the database over the
network either way, but the web files can be retrieved and saved faster with
PWS.

2.  One of our web sites is not only used by people on-line, but also by
field personnel who use laptops, and have to upload and download data.
Thanks to PWS and MSDE, they will be able to use the same ASP pages as the
on-line users, while using DTS to transfer data back and fourth.  In a
similar situation with CF, we had to develop a separate Access application
for the field team members.

Some other more obvious advantages is that ASP is free and can be developed
in a simple word processor, if need be.  Microsoft is also a huge name,
whether you like them or not, and it doesn't hurt to know how to user their
technology.

Marianne Daye
Programmer/Analyst


-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:09 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


At 12:06 PM 4/3/02 -0800, David Schmidt wrote:
>If he's willing to fork the bucks for the training.  Grab hold, hang on,
and
>take what you can learn.

A cold hearted approach (but I think wise) would be to get the training 
paid for, 

RE: CF VS ASP <- let the trolling being

[Daye, Marianne]

This is great!  So do you have to use that in conjunction with CF Enterprise
as Robert mentioned?

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:21 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


CF equivalent to PWS is PWS. You can use PWS with CF. I do all my
development on my local PC by copying the CF site to my home computer. 
The best thing to do is know the technology you are using.



On Thu, 4 Apr 2002, Daye, Marianne wrote:

> I have to agree that CF is easier and faster to use than ASP.  However,
ASP
> does have the advantage of PWS.  Does CF have an equivalent?  I started
out
> with ASP, then used CF for two years, and now I'm using ASP again.  I'm
not
> ecstatic about it, but I have found a couple of advantages:
> 
> 1.  Thanks to PWS, if I want to work from home, I can just copy the ASP
site
> to my home computer.  With CF I had to work across a cable connection
which
> slowed things down a bit.  Of course, I have to access the database over
the
> network either way, but the web files can be retrieved and saved faster
with
> PWS.
> 
> 2.  One of our web sites is not only used by people on-line, but also by
> field personnel who use laptops, and have to upload and download data.
> Thanks to PWS and MSDE, they will be able to use the same ASP pages as the
> on-line users, while using DTS to transfer data back and fourth.  In a
> similar situation with CF, we had to develop a separate Access application
> for the field team members.
> 
> Some other more obvious advantages is that ASP is free and can be
developed
> in a simple word processor, if need be.  Microsoft is also a huge name,
> whether you like them or not, and it doesn't hurt to know how to user
their
> technology.
> 
> Marianne Daye
> Programmer/Analyst
> 
> 
> -Original Message-
> From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 3:09 PM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
> 
> 
> At 12:06 PM 4/3/02 -0800, David Schmidt wrote:
> >If he's willing to fork the bucks for the training.  Grab hold, hang on,
> and
> >take what you can learn.
> 
> A cold hearted approach (but I think wise) would be to get the training 
> paid for, and then move to a company that is more reasonable.
> 
> T
> 
> 
> 

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF VS ASP <- let the trolling being

[Daye, Marianne]

Pardon me!  I hadn't heard of CF Enterprise.  Hence the question "Does CF
have an equivalent?".  If I ever get to code in CF again I'll have to look
into that.

I don't know what it is you don't get, but as a part-time telecommuter, I
prefer not to have to rely on a remote server while developing.  As for
using the web site on the laptop, the application contains a lengthy survey
that relies on skip-logic; not something we would want to do over in another
format (gets expensive).

I have no interest in debating whether or not it's 'fair' that ASP is free.
For the young beginner or hobbyist, it's may be the only affordable option
to get started!

Yeah, I guess you can develop CF in Notepad as well; just never did.
Scratch that point.

Have a nice day!

Marianne

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:15 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


1. PWS? What I don't get it. PWS is a web server. Sure ASP is built in,
but you can get a FREE Developer version of CF Enterprise and it can work in
conjunction with PWS. Where's the problem here?

2. Again if you install the free version of CF on the laptop I doubt this
would be an issue. Though I question having an entire web application on a
laptop. If anything I would have given them the information they needed in
another form and made life easier to upload data to the rest of the
application.

Sure you pay for CF, but we already knew this. Not everyone can have 75% of
the world's desktop so they can just offer things for free. I don't see why
you can't program CF in a word processor, matter of fact a lot of my
debugging is on notepad when I am offsite. Sure I love CF Studio, but it is
in no means required. 

I don't understand some of the issues you brought up here. Please explain
better.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Daye, Marianne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:11 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


I have to agree that CF is easier and faster to use than ASP.  However, ASP
does have the advantage of PWS.  Does CF have an equivalent?  I started out
with ASP, then used CF for two years, and now I'm using ASP again.  I'm not
ecstatic about it, but I have found a couple of advantages:

1.  Thanks to PWS, if I want to work from home, I can just copy the ASP site
to my home computer.  With CF I had to work across a cable connection which
slowed things down a bit.  Of course, I have to access the database over the
network either way, but the web files can be retrieved and saved faster with
PWS.

2.  One of our web sites is not only used by people on-line, but also by
field personnel who use laptops, and have to upload and download data.
Thanks to PWS and MSDE, they will be able to use the same ASP pages as the
on-line users, while using DTS to transfer data back and fourth.  In a
similar situation with CF, we had to develop a separate Access application
for the field team members.

Some other more obvious advantages is that ASP is free and can be developed
in a simple word processor, if need be.  Microsoft is also a huge name,
whether you like them or not, and it doesn't hurt to know how to user their
technology.

Marianne Daye
Programmer/Analyst


-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:09 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


At 12:06 PM 4/3/02 -0800, David Schmidt wrote:
>If he's willing to fork the bucks for the training.  Grab hold, hang on,
and
>take what you can learn.

A cold hearted approach (but I think wise) would be to get the training 
paid for, and then move to a company that is more reasonable.

T




__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF VS ASP <- let the trolling being

[Daye, Marianne]

I have to agree that CF is easier and faster to use than ASP.  However, ASP
does have the advantage of PWS.  Does CF have an equivalent?  I started out
with ASP, then used CF for two years, and now I'm using ASP again.  I'm not
ecstatic about it, but I have found a couple of advantages:

1.  Thanks to PWS, if I want to work from home, I can just copy the ASP site
to my home computer.  With CF I had to work across a cable connection which
slowed things down a bit.  Of course, I have to access the database over the
network either way, but the web files can be retrieved and saved faster with
PWS.

2.  One of our web sites is not only used by people on-line, but also by
field personnel who use laptops, and have to upload and download data.
Thanks to PWS and MSDE, they will be able to use the same ASP pages as the
on-line users, while using DTS to transfer data back and fourth.  In a
similar situation with CF, we had to develop a separate Access application
for the field team members.

Some other more obvious advantages is that ASP is free and can be developed
in a simple word processor, if need be.  Microsoft is also a huge name,
whether you like them or not, and it doesn't hurt to know how to user their
technology.

Marianne Daye
Programmer/Analyst


-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:09 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


At 12:06 PM 4/3/02 -0800, David Schmidt wrote:
>If he's willing to fork the bucks for the training.  Grab hold, hang on,
and
>take what you can learn.

A cold hearted approach (but I think wise) would be to get the training 
paid for, and then move to a company that is more reasonable.

T


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

RE: SQL?

[Daye, Marianne]

If there's a volume discount you might need to factor that into the database
design as well.


-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 5:00 PM
To: CF-Talk
Subject: RE: SQL?


The problem with keeping the price with the album. What if the album 
goes on
sale?  You'd change the price in the album table then suddenly anyone 
who
bought the album previously shows that they paid the sale price.
You would at least need to add a history table or make sure that the 
sales
table shows the actual price and isn't just hooked to the album table.
It's been a long day- hope this is coherent enough.

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 5:01 PM
To: CF-Talk
Subject: SQL?


I am trying to figure out how I should set up a database for an 
ecommerce site. I will be selling music CD's. 

Each artist can have several albums, and each album can have several 
tracks. I am pretty sure I will need 3 tables for that info. What I am 
wondering , is where should I keep pricing info and such? Should it be 
in the album table or should there be a seperate table for pricing etc. 

Any insight would be helpful


There are two major products that come out of Berkeley: LSD and [Unix] 
BSD. We don't believe this to be a coincidence.



Doug Brown


__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Help

[Daye, Marianne]

Or you can do it in CF like this:


SET NOCOUNT ON
INSERT INTO TAUX_001 (DSC_CHKLST , IND_STATUS)
VALUES  ('OBS' , 20)
SELECT @@IDENTITY AS COD_REQ
SET NOCOUNT OFF




Marianne Daye
Programmer/Analyst
Information Delivery Systems (IDS)
http://ids.rti.org


-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 8:40 AM
To: CF-Talk
Subject: RE: SQL Help


or you can add a trigger to the sql server that runs on insert 
statements to
that table 

SELECT @@IDENTITY as newID


@llan

-Original Message-
From: Stuart Miller [mailto:[EMAIL PROTECTED]]
Sent: 11. januar 2002 14:32
To: CF-Talk
Subject: RE: SQL Help


Your query will run in Query Analyzer because analyzer uses transact 
sql. 

If you're interested in getting the primary key of a record you have 
just
inserted in your CF application, I use . Like this:



INSERT INTO TAUX_001
(DSC_CHKLST , IND_STATUS)
VALUES
('OBS' , 20)



SELECT MAX(COD_REQ) AS ThePrimaryKey
FROM TAUX_001



-Original Message-
From: Waldemiro Junior [mailto:[EMAIL PROTECTED]]
Sent: 11 January 2002 11:27
To: CF-Talk
Subject: SQL Help


Hi again folks...

How can I output a variable that was set within a CFQUERY containing 
first a insert statement, then a select statement?
This is my query:


INSERT INTO TAUX_001
(DSC_CHKLST , IND_STATUS)
VALUES
('OBS' , 20)
SELECT @@IDENTITY AS 'COD_REQ'


When I try to output COD_REQ, Coldfusion returns an error, but when 
using the Query Analyzer it works fine...

Best regards,

Waldemiro Junior
ADDTechnologies Web Developer





__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Passing recordset to caller template

[Daye, Marianne]

Thanks, Raymond!  The first approach works.  I can't get the second one to
work, but that's OK; as long as 'something' works.

Marianne

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 12:22 PM
To: CF-Talk
Subject: RE: Passing recordset to caller template


A few ways,

1) Just name the query caller.whatever. 



2) Just set it:



===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -----Original Message-
> From: Daye, Marianne [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, January 03, 2002 12:11 PM
> To: CF-Talk
> Subject: Passing recordset to caller template
> 
> 
> How do I pass query results from a custom tag to a caller template?
> 
> Marianne Daye
> Programmer/Analyst
> Information Delivery Systems
> http://ids.rti.org
> 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Passing recordset to caller template

[Daye, Marianne]

Never mind, I figured it out.

In custom tag:


In calling template:

..

Easier than I thought!

Marianne

-Original Message-
From: Daye, Marianne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 12:11 PM
To: CF-Talk
Subject: Passing recordset to caller template


How do I pass query results from a custom tag to a caller template?

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Passing recordset to caller template

[Daye, Marianne]

How do I pass query results from a custom tag to a caller template?

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: hosting recommendations

[Daye, Marianne]

Sorry, I meant to forward, not reply.

-Original Message-
From: Daye, Marianne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 8:34 AM
To: CF-Talk
Subject: RE: hosting recommendations


Hi Kevin,

How's the 'relational' database coming along?  As I mentioned before, it
would be really useful if everyone who needs access to member's phone
numbers, etc. would be able to get the most recent data from a Web site
instead bugging you for it.  Class leaders and committee chair persons would
be able to add, edit, and retrieve information as needed, and the data could
(and most certainly should) be password protected.  Well, the free hosing
company I mentioned now offers both free hosting and very low rate deals.
By now they've been around for a long time, and other clients seem to be
happy.  In case you want to consider the possibilities, here's the link:
http://www.cfm-resources.com/.

There are others that I'm less familiar with:  www.ExpertHost.com,
www.wedohosting.com, www.advances.com.

Kind regards,

Marianne

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 4:24 PM
To: CF-Talk
Subject: Re: hosting recommendations


I like CFM resources (www.cfm-resources.com).  Of course, they're all 
I've ever used but I've never had a problem with them.

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  - Original Message - 
  From: lsellers 
  To: CF-Talk 
  Sent: Monday, November 26, 2001 3:05 PM
  Subject: hosting recommendations


  'ello.

  Was looking around for a new host for intrafoundation.com. (My current 

  host's new management software is really ticking me off.)

  <2gb traffic a month avg. 8 email accounts. cf & asp required. 1 or 
more 
  odbc. relatively low stress website. cc gateway soft and cfx/com 
allowance 
  usage required (though I'm not using any cfx's or com's on it at the 
  moment). Some place reliable (2+ years up) but laid back.

  Cheap's good too. ;-)

  Thanks,
  --min
  


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

RE: hosting recommendations

[Daye, Marianne]

Hi Kevin,

How's the 'relational' database coming along?  As I mentioned before, it
would be really useful if everyone who needs access to member's phone
numbers, etc. would be able to get the most recent data from a Web site
instead bugging you for it.  Class leaders and committee chair persons would
be able to add, edit, and retrieve information as needed, and the data could
(and most certainly should) be password protected.  Well, the free hosing
company I mentioned now offers both free hosting and very low rate deals.
By now they've been around for a long time, and other clients seem to be
happy.  In case you want to consider the possibilities, here's the link:
http://www.cfm-resources.com/.

There are others that I'm less familiar with:  www.ExpertHost.com,
www.wedohosting.com, www.advances.com.

Kind regards,

Marianne

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 4:24 PM
To: CF-Talk
Subject: Re: hosting recommendations


I like CFM resources (www.cfm-resources.com).  Of course, they're all 
I've ever used but I've never had a problem with them.

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  - Original Message - 
  From: lsellers 
  To: CF-Talk 
  Sent: Monday, November 26, 2001 3:05 PM
  Subject: hosting recommendations


  'ello.

  Was looking around for a new host for intrafoundation.com. (My current 

  host's new management software is really ticking me off.)

  <2gb traffic a month avg. 8 email accounts. cf & asp required. 1 or 
more 
  odbc. relatively low stress website. cc gateway soft and cfx/com 
allowance 
  usage required (though I'm not using any cfx's or com's on it at the 
  moment). Some place reliable (2+ years up) but laid back.

  Cheap's good too. ;-)

  Thanks,
  --min
  

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session and Client Variables

[Daye, Marianne]

Woe, cease fire!  I, the 'original respondent', was just trying to exercise
my awkward sense of humor.  Kwan Suh, if I ever pick a fight, I want you on
my side.  You may be belligerent, but you make a good case.

I have worked on two shopping cart type applications with complex variables.
On the first I used client scope and wddx, on the second I tried session
variables.  They both worked fine, but the session variables were more
troublesome because things didn't work out as planned (and I did actually
plan).  My 'brilliant' idea was to use the Duplicate() function to copy all
complex session variables to request scope in the application.cfm (to be
'efficient', not lazy), and then copy changed data back to the session
variables as applicable in each action page.  The problem was that the
Duplicate() function was buggy (to put it mildly), and I finally had to
resort to copying individual structure keys at the top of every page, and
putting cflock tags around the queries, which, I agree, is very cumbersome.
So we learn from our mistakes, but had the Duplicat() function worked
correctly, I think it would have been a good plan.  Perhaps when we upgrade
to CF 5 it will work.

The reason I spoke of hidden variables was that when using client variables,
I stored the wddx in a hidden field rather than in a database.  Also, before
I got involved in the second appilication, it had been designed without
session management, and hidden fields were used to pass data for each
selected line item from one page to the next, which was was truly cumbersome
to manage.

We will probably never use clustered servers, but you have a very good
point.  Should we ever have the opportunity to work on an application that
calls for it, it would be a sign of growth from a business perspective, but
a perhaps a nightmare from a programmer's point of view.

I hope Gyrus will be ready for his exam, now.

Taking cover!

Marianne

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 7:11 PM
To: CF-Talk
Subject: Re: Session and Client Variables


- Original Message -
From: "Freddy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 5:16 PM
Subject: Re: Session and Client Variables


> Kwang Suh wrote:
>
> > > My heart goes out to you!  You sound like you've had a bad experience
with
> > a
> > > session variable cult, or something.   But if used in its proper
context,
> > > session variables can change your (work) life.
> >
> > Yeah, but what's "proper context"?  Do people even bother to do enough
> > analysis to say whether they should go client or session, or do people
use
> > session vars because that's what they've been using since they started
using
> > CF?
>
> > I would think that any application should be built with a well thought
out
> > plan. Utilize whatever is best in a given situation. A proerly used
session
> > variable works better than an inproperly used client and vice versa.

Agreed.  I'm saying that most people don't even create the well thought out
plan.

>
> >
> > In your darkest hour, when
> > > confronted with the need to pass queries of information, the number of
> > rows
> > > unbeknownst to you, from one page to another, over and over again in a
> > > endless, vicious cycle, you might find that session variables are your
> > only
> > > hope.
> >
> > Hardly.  That's what WDDX is for.
>
> WDDX is great for hanling large recordsets but it is not as fast to access
as a
> session scoped query on a seperate page. Again the method used is
depoendent on
> what you need to do.
>
> >
> >
> > Yes, some people may have committed evil act in the name of session
> > > variables, but don't let hypocrites turn you away from the tool that
> > > delivered you from the hands of hidden form fields and time consuming
> > > database calls.
> >
> > Why would I need hidden form fields and database calls when I'm using
client
> > variables?
>
> Take a look at your database activity. Using client variables will
generate a
> database call.

Yes, I realize this.  But I will bet you 1 million widgets that a properly
configured RDBMS is _much_ better at handling locking than a properly
configured CF server using session variables.  Not to mention that my client
app will actually scale, and your session app will not.

I think the original respondent was referring to constant database calls for
variables that should be persistent.

> Also try holding a complex structure in a client variable.

I've already mentioned this drawback.

>
> I would say use what works for you. Do not rely on any one method overly
much.
> If you do you will find that you are not going to get the full benefits
that
> working a rich scripting language like cf can provide.

I think the overarching requirement for most, if not all, enterprise-class
applications are reliability and availability.  I can't see how using
session vars meshes with this requirement.  Hey, if all someone's mak

RE: Session and Client Variables

[Daye, Marianne]

Kwang Suh,

My heart goes out to you!  You sound like you've had a bad experience with a
session variable cult, or something.   But if used in its proper context,
session variables can change your (work) life.  In your darkest hour, when
confronted with the need to pass queries of information, the number of rows
unbeknownst to you, from one page to another, over and over again in a
endless, vicious cycle, you might find that session variables are your only
hope.  Yes, some people may have committed evil act in the name of session
variables, but don't let hypocrites turn you away from the tool that
delivered you from the hands of hidden form fields and time consuming
database calls.

Your friend in CF Programming,

Marianne Daye

-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 8:07 PM
To: CF-Talk
Subject: RE: Session and Client Variables


Yikes!

The key differences between client and session variables are:

session variables must be locked, or have automatic locking set.
client variables can be stored in a database, allowing much better
scalability with your apps.
client variables can only store "simple" datatypes.

And yes, client variables DO "time out".

Bottom line:  session variables suck.  I hate them.  They are the bane of
CF.  I hate how people put gigantic structures in session variables and then
use them like simple variables.  I hate how people forget to lock session
variables.  I hate how people don't know when to use type="exclusive" vs.
type="readonly".  I hate all the workarounds so that you don't have to lock
session vars (talk about doing extra work to be lazy).  I hate how they make
deployment of scalable apps a huge headache.

Session variables.  Just say no.

-Original Message-
From: Kinley Pon [mailto:[EMAIL PROTECTED]]
Sent: November 14, 2001 5:38 PM
To: CF-Talk
Subject: Re: Session and Client Variables


sounds about right! - Kinley


>From: "Gyrus" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: Session and Client Variables
>Date: Wed, 14 Nov 2001 18:26:41 -
>
> > Hi Folks, i'm prepping for the cf exam and i'm lacking a good
>understanding
> > of the difference between client and session variables. It seems that
>they
> > both are capable of doing the same thing. When and why should/would i
>use
> > one or the other? What apps have you used client vars for and not
>session
> > vars for and visa versa and why? Thanks for any help.
>
>As I understand it, the key difference is that session variables
>timeout. Client variables are tied to a specific client, session variables
>are tied to a specific client *and last for a specific period of time after
>the last request from that client to a specific application*. This
>timeout period is controlled in CF Admin, or in the CFAPPLICATION
>tag in application.cfm.
>
>I use session variables mostly for password-protected areas (usually
>backend CMS's) that need the finite login time for security reasons.
>I never really used client variables. I suppose I could provide the
>option to "remember me next time" when users login, and this is a
>good example of the difference I suppose:
>
>- Normal login = session variables, and if you leave the app for
>20 mins (or whatever), you will have to login again.
>
>- "Remember me" login = client variables, and as long as the connected
>cookies remain on the client, you won't have to login to get into
>the app.
>
>hth,
>
>- Gyrus
>
>
>


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

RE: Having major problems with session variables

[Daye, Marianne]

Just a shot in the dark, but are you by any chance using the Duplicate()
function to copy complex session scoped variables to local variables?  In CF
4.5 and earlier, the Duplicate() function can cause some really strange
memory corruptions, and even reach outside the current session and
application to pick up other session scoped variables.

-Original Message-
From: Chris Bohill [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 12:21 PM
To: CF-Talk
Subject: Having major problems with session variables


Hi,

Session Variables seem to be a hot topic at the minute, so I was
wondering if anyone could shed some light or give some advice on the
problem below.

We have a multiple user web based application that is all user-profile
based.

User A is  the site administrator with full access to the site.

User B is a member of company 1, and he can only see his companies data
on the site.

User C is a member of company 2, and he can only see his companies data
on the site.

What we are experiencing is a swapping of user profiles. User B is
logging in as himself and is happily navigation through the site,
gaining access to their own data, until they start to see information
which is supposed to only be relevant to User C. 

User A is sometimes logging in, and is getting restricted access to the
site because he has somehow inherited the profile of another user (who
has a lower access privilege).

Somehow the profiles are being swapped while the users are in the
system.

We are using session variables for the profiling, and access privileges,
but the somehow are getting mixed up. 


When we are calling session variables in a query on any individual page
we have declared local variables corresponding to these at the top of
the page, and referenced these throughout the rest of the page, see
below,




 





Select *
from table
where user_id = #Variables.chris#




We are also using StructClear() to kill the session variables when the
user logs out.

I do not know what else to do, as the problem is still persisting. Has
anyone experienced this, or can they offer any advice or direction.

Cheers,


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Request Scope Questions

[Daye, Marianne]

Well, the 'issue' (to put it mildly) that we experienced appeared to be one
of memory corruption.  We got inconsistent, very vague error messages,
sometimes referencing variable names from another application on the same
server.  The problems were very persistent, so if you haven't been having
problems already, you might be safe.  Unfortunately the patch is only for CF
Enterprise (we have Professional), so I resorted to copying all individual
structure keys to Request scope, and locking Session scoped queries before
looping throught them.

Marianne Daye

-Original Message-
From: gyrus [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 10:32 AM
To: CF-Talk
Subject: Re: Request Scope Questions


> Bare in mind that CF 4.5 had a um, 'issue' with Duplicate. You can
> download a hotfix for it though.

What was the issue?! I've got several sites live that are relying
on Duplicate for passing session vars to request scope, and
I'm not sure if the hosts have all the latest patches.

- Gyrus



~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Points of failure for session variables

[Daye, Marianne]

Chris, what did you mean when you said that a query with a name of
application.queryname is a 'write'.  Doesn't that depend on what you do with
it?  If I loop through session.QueryName, but only read the values, is that
not a 'readonly' for locking purposes?

Marianne Daye
Programmer/Analyst
Information Delivery Systems (IDS)
http://ids.rti.org
(919) 541-8031


-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 9:07 AM
To: CF-Talk
Subject: Re: Points of failure for session variables


Manually locking all reads and writes (locking by scope) is good.  Beware of
things that might not look like writes - like a query with a name of
application.queryname is actually a write into the application scope.

Also, use the Duplicate() function with CFSET whenever making a copy of a
complex variable (arrays & structures, at least.  Allaire/MM say queries are
complex, other folks say they're not).  If you don't use Duplicate() when
copying complex variables your copy is a pointer to the original rather than
a real copy.

And test for session validity at the beginning of every request.

best,
Chris Norloff

-- Original Message --
from: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Sun, 30 Sep 2001 17:30:46 -0700

>Of course I've used system variables several times in the past, but never
in
>an application where their proper functioning is absolutely necessary,
until
>now.
>
>The application I'm building now relies heavily on session variables and
>will fail if variables are not properly passed.
>
>Of course, I'm using CFLock around all session variables (both read and
>write).
>
>Besides that, I'm wondering are their other problems to look and plan for?
>Is it possible that session variables will not work with some clients? If
>so, under what conditions. How do you plan for such possible failures?
>
>I just want to do my best to cover all of the bases here.
>
>H.
>

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Training Recommendations

[Daye, Marianne]

Hi Jay,

I took a class called Implementing a Database on MS SQL 7.0 with
Productivity Point Intl (www.propoint.com).  It covered everything you're
looking for, and you get to keep the lesson binder.  It does not related
back to ColdFusion, but I think it's important to learn the ins and outs of
SQL and Enterprise Manager apart from ColdFusion as well, since it's usually
most efficient to do as much of the database work as possible via views and
stored procedures rather than in the ColdFusion code.

Marianne Daye
Programmer/Analyst
Information Delivery Systems (IDS)
http://ids.rti.org
(919) 541-8031


-Original Message-
From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 6:04 PM
To: CF-Talk
Subject: SOT: Training Recommendations


Hi All -

I'm hoping someone can recommend some ColdFusion training that focuses
on a variety of topics at the database level, especially including:

* Database Design Techniques
* Implementing Stored Procedures
* Designing and Using Triggers
* Joins

I started using ColdFusion on a very casual, teach-myself-as-I-go basis
back when CF3 was the latest and greatest.  I am very confident with my
ColdFusion specific skills, but continue to find that my SQL  skills (or
lack of) are holding me back.  I get especially confused with joins, and
moment I prefer to use the old ANSI 88?? style joins.  However, when I
need to do any complex nested joins, I find myself relying on Access's
query builder because I absolutely can't figure out how to write them by
hand.  I also have very little knowledge about stored procedures,
triggers, indexes, etc.  I've been able to gather that stored procedures
and triggers can make a world of difference performance-wise, and I feel
as-if I'm providing a a great disservice to my customers by not knowing
how to properly evaluate when I should be using implementing
stored-procedures, triggers or whatever.

Overall, I want to improve my database design and SQL skills, but I want
the information I learn to be delivered in a way so that it's always
relating back to ColdFusion.

Any suggestions?

Jay Sudowski
-
Handy Networks LLC
TEL: 877-70-HANDY
FAX: 888-300-2FAX
URL: www.handynetworks.com
-
Providing reseller and dedicated Windows 2000 web hosting solutions.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Setting form var with Java

[Daye, Marianne]

No guarantees here, but try this:  var oldvalue = FormName[FieldName].value

Marianne Daye

-Original Message-
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 11:21 AM
To: CF-Talk
Subject: Setting form var with Java


Sent this once already but have not gotten any replies, can anyone help?

A little help please.  I am trying to use some javascript on my CF pages.  I
would like to pass the formname and  fieldname to the function, perform an
action and return the value: i.e.





The formname and Fieldnames are being passed fine,  but how do I use them.
now oldvalue is being set EQ to "document.FormName.FieldName.value" not the
value of the field ,  how can I get the value from the form field. 

If I call the formfield in the function by hardcoding its name I get the
function to work fine, but I would like to re-use this without having to
change the function each time.

Thanks for your help
Rodney
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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, ASP, and Front Page playground?

[Daye, Marianne]

I've use ASP with FrontPage.  Not good!  FrontPage likes to write it's own
code and mess up your neatly aligned code.

Marianne Daye

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 9:08 AM
To: CF-Talk
Subject: CF, ASP, and Front Page playground?





Anyone using all three of these?  ColdFusion 4.5, ASP, and Front Page
extensions?  Do they play well together?

Thanks!

-
Douglas Knudsen
Leveraged Technologies Group
Alltel AIS
678-351-6063
Got Linux? http://linuxmall.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: To ASP or not to ASP

[Daye, Marianne]

I initially used ASP, and had to switch to CF when I changed jobs.  I get my
work done faster in CF, and I don't have to define and open objects to
access data from a database.  You can also get new people trained faster on
CF than on ASP because they don't need to know VB.  CF does not eliminate
the need to use JavaScript, and I still get to utilize my VB skills in
Access once in a while.  Personally, I don't miss ASP at all.

Marianne Daye
Programmer/Analyst
Information Delivery Systems (IDS)
http://ids.rti.org


-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 5:34 PM
To: CF-Talk
Subject: To ASP or not to ASP


This is a Microsoft shop here so that makes me a lone CF'er singing the
praises and virtues of CF. One of our Small Apps Team members in IS is keen
to explore CF a bit as he is currently entirely limited to ASP. He asked me
the other day, "What makes CF better than ASP?" I said that might be an
interesting question to pose on CF-Talk (for legitimate comments, one way or
the other, without wishing to incite any flame wars :-)




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287






This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.

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

[Daye, Marianne]

Or you can SELECT MAX(id) FROM mytable before you run the query to INSERT
INTO mytable.

Marianne Daye
Programmer/Analyst
Information Delivery Systems (IDS)
http://ids.rti.org

-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:11 PM
To: CF-Talk
Subject: RE: incrementer


I've always heard bad things about auto-number fields, but I use them
anyway...

But one thing I've seen is to make a table in your database, call it
nextid or something and put two columns, tablename and id. Store the next
id for each table in the id column...Update it within a transaction after
any insert.

So when you go to insert:

insert into mytable (id,col1,col2) 
values ((select id from nextid where tablename = mytable),col1val,col2val)

then:

update nextid
setup id = id + 1
where tablename = mytable

> depend on what database you are writing to: for example if access
> then use autonumber and make the id the primary key - this will increment
> automatically for you - if using MS Squirrel then when creating the table
> choose integer as datatype, untick allow nulls and tick identity -
identity
> seed and identity increment should then both have 1 in - etc. etc.
> 
> Also, I don't think that your code will work as you should not be able to
> read and insert simultaneously from a table (?) - but the idea is good -
if
> you can't get your datasource to increment for you (which you should let
it
> do if it can) then query the table first with your select max stuff -
create
> a cfset which increments the maxid by one and stuff that variable into
your
> code at "id" instead - though I'm sure others will tell you a neater way
of
> doing it without using two queries!!! ;)
> 
> James
> 
> "The Force is strong in this one..."  - Darth Vader
> 
> 
> -Original Message-
> From: Savan Thongvanh [mailto:[EMAIL PROTECTED]]
> Sent: 20 March 2001 16:25
> To: CF-Talk
> Subject: incrementer
> 
> 
> 
> 
> seems like a gimme but...is
> where id is integer and the primary key
> 
> insert into mytable (id,col1,col2)  values ((select max(id) from
> mytable+1),col1val,col2val)
> 
> can you do that and is it a legit way to get a primary key?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: DB structure advice

[Daye, Marianne]

I think you'll get better performance on your queries when you query the
sub-groups from a separate table because you'll have fewer records to sort
through.  Personally, I don't like to work with tables that have a gazillion
fields that don't apply to the particular task at hand.

Marianne Daye
Programmer/Analyst
Information Delivery Systems (IDS)
http://ids.rti.org


-Original Message-
From: Jason Lotz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 11:52 AM
To: CF-Talk
Subject: DB structure advice


This is more of a theory question than an actualy request for help.  Let's
say you are building a database of members with lots of information that
applies to every member (name, address, phone, etc.)  This could be about 40
seperate fields.  Then, on top of that, each member can have lots of
optional information that can easily be grouped together.  For example, if
they graduated from college, you want to store their degree information or
if they own a company, you want to store their company info.  Each of these
"optional groups" are one-to-one (each member can only have one chunk of
this data but doesn't have to have it at all.) Now here's the question -

When you are building this database, you could easily put it into one huge
table because all the information is one-to-one.  However, it's a pain when
you only want to get the "degree" information or the "company" information.
>From a programming standpoint, is it best to break these into smaller tables
for ease of use or to keep it into one table?

Thanks,
Jason
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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 Cross-Tab / TRANSFORM

[Daye, Marianne]

In case you haven't found an example yet, in SQL Sever Books Online, select
the Index tab and enter 'rotated data'.  Double-click on the highlighted
selection, and select Cross-tab Reports.  That's the best example I've seen
anywhere.

Marianne Daye
Programmer/Analyst
Information Delivery Systems (IDS)
http://ids.rti.org


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 11:39 AM
To: CF-Talk
Subject: RE: SQL Cross-Tab / TRANSFORM


> We're using SQL 7 for all the database work, but we want to 
> combine some tables (doing mods on a 3rd party program). We 
> thought to use Transform/Pivot. That avoids running hundered 
> of queries on a page (or even an additional 50) because of a 
> funny table structure.
> 
> We approched the problem by building the Transform Query in 
> ACCESS (their little wizards!) and then utilizing it in the 
> CF code to access the SQL7 server.
> 
> So, that's how I can see the columns being properly named, 
> but me hair is falling out at being inable to utilize the 
> information. If it's a MS SQL 7 situation - then at least I 
> know it's time to take a different approach!

You might try building a cross-tab query using T-SQL, instead. You can use
the CASE function for this. There's an example in SQL Server Books Online,
which you probably have installed on your SQL Server, or can get in Windows
HTML Help format here:

http://download.microsoft.com/download/SQL70/File/2/Win98/En-US/SQLBOL.exe

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

Got PDFlib?

[Daye, Marianne]

I'm considering using PDFlib to generate PDF files on the fly, and I was
wondering if anyone has some experience to share.  We can't use existing pdf
templates because the number of fields varies, and it's my understanding
that PDFlib allows you to create the PDF dynamically on the server.

Originally we were using Crystal Reports and CFX_CRWTOPDF which no longer
works, and I haven't been able to find anything to replace it that
combination.  Generating the PDF files on the server is the best alternative
I've been able to come up with.  Got better ones?

Marianne Daye   Center for Engineering and
Environmental Technology
Programmer/Analyst  Research Triangle Institute
Information Delivery Systems3040 Cornwallis Rd.
http://ids.rti.org  Research Triangle
Park, NC  27709
Ph: (919) 541-8031, Fax: (919) 541-6936 http://www.rti.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: Cross Browser DHTML Menu

[Daye, Marianne]

Here's an example that worked for me:
http://www.webreview.com/1998/07_24/webauthors/07_24_98_10.shtml


-Original Message-
From: Raymond B. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 4:40 PM
To: CF-Talk
Subject: RE: Cross Browser DHTML Menu


http://www.dynamicdrive.com

http://www.dynamicdrive.com/dynamicindex1/index.html   <-- Menu and Nav
scripts

They have a host of free scripts. I'm not much on the front end display side
but I'm sure they'll have something you can use "out of the box" or adapt
easily.

-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: January 17, 2001 11:31
To: CF-Talk
Subject: OT: Cross Browser DHTML Menu


Guys,

I need a cross browser DHTML menu asap that can do drop down, and slide
menus.

Menu
|-Item1
|-Item2
|-Item3--|-Item5
|-Item4  |-Item6

Does anyone know of a good simple API or generator, that has been tested
(the important part of the question) on NN4+ and IE4+, that they would
recommend? Please don't suggest CF_DHTMLMenu as it specifically states that
it's not for NN.

Thanks

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

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

RE: Learning Javascript Books,

[Daye, Marianne]

JavaScript Bible by Danny Goodman consists of both a tutorial and an object
and language reference.  A little over a thousand pages + example scripts on
CD-ROM.  It's pretty extensive, and easy to understand.  Check out the
reviews at amazon.com, ISBN 0-7645-3188-3.

Marianne Daye
Programmer/Analyst
Information Delivery systems (IDS)
http://ids.rti.org

-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 10:37 AM
To: CF-Talk
Subject: OT: Learning Javascript Books,


Any recommendations, Please

Thanks

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

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

RE: queries vs arrays

[Daye, Marianne]

Thanks, guys, for asking and answering the right question!  This is the
perfect solution to my shopping cart dilemma.  I'm not ready to tackle
structures of arrays, yet, but this works just as well if not better:

Loop through shopping cart (query) once to create a list of key fields.
Use Row = ListFind(lstKeyFields) to determine the position of the key in
question.
Retrieve data with Query.ColumnName[Row]

I don't know if this is old news to the CFPros, but I feel a song coming on!

Marianne Daye

-Original Message-
From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 12:12 AM
To: CF-Talk
Subject: RE: queries vs arrays


Yup, you can access queries like they're arrays... here's an example:


SELECT COUNT(FilePath) AS pathCount, FilePath
FROM MasterFPPList
GROUP BY FilePath



#qGraph.Filepath[x]#


Joseph E. Sheble
a.k.a. Wizaerd
Wizaerd's Realm
Canvas, 3D, Graphics,
ColdFusion, PHP, and mySQL
http://www.wizaerd.com
=

> -Original Message-
> From: Kevin Willyerd [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 13, 2000 3:17 PM
> To: CF-Talk
> Subject: queries vs arrays
>
>
> In Ben Fortas he says "ColdFusion queries are essentially arrays with
> named collumns. You may therefore use any of the array functions with
> queries"  Does this mean ther is a way to address queries in the form
> Query [row] [collumname]? I have tried and can not get it to work.
>
> Kevin
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFreport and crystal reports

[Daye, Marianne]

Try taking a look at recrystallize.com.  It's just a wizard that generate
the html files to run the crystal report; you can probably fined your
answers in those files.  There's a beta version you can try for free.  It
uses a dll (u2fpdf.dll) which comes with the download.  I haven't actually
tried it, yet, since I'm still using CR7, and the feature I need (PDF
download)only works with CR8, but I plan to if we upgrade.  If you try it,
let me know what you think.

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org

-Original Message-
From: Katie Bessiere [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 11:08 AM
To: CF-Talk
Subject: CFreport and crystal reports


has anyone had any luck using CFREPORT with crystal reports 8?  i've tried
the workaround that Allaire recommends and I still can't get the tag to
work.  It's very frustrating..

If anyone has any ideas, please let me know..

katie

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

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

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

RE: Allaire Advanced Fusion Developement Class

[Daye, Marianne]

I took it with Productivity Point.  Details are covered on their Web site:
http://www.propoint.com/featuresheets/Aadvcf_ftr.htm

Marianne

-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 5:11 PM
To: CF-Talk
Subject: RE: Allaire Advanced Fusion Developement Class



What are the topics covered?

Thanks,

Kevin

>>> [EMAIL PROTECTED] 11/15/00 10:50AM >>>
I liked it a lot!  I would recommend it to anybody who's comfortable
with
the basics of CF.  The course book has a lot of easy to follow
explanations
of everything, and makes for a good reference.  I left with valuable
knowledge.

Marianne Daye

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, November 15, 2000 11:27 AM
To: CF-Talk
Subject: OT: Allaire Advanced Fusion Developement Class



I'm trying to get my superiors to send me to the Advanced Developement
class.  Anybody been to this?  How did you like it?



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


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


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

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

RE: Allaire Advanced Fusion Developement Class

[Daye, Marianne]

I liked it a lot!  I would recommend it to anybody who's comfortable with
the basics of CF.  The course book has a lot of easy to follow explanations
of everything, and makes for a good reference.  I left with valuable
knowledge.

Marianne Daye

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 11:27 AM
To: CF-Talk
Subject: OT: Allaire Advanced Fusion Developement Class



I'm trying to get my superiors to send me to the Advanced Developement
class.  Anybody been to this?  How did you like it?



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

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

RE: cfmail receipt ants

[Daye, Marianne]

At the developer conference I heard that the current limit is 40 recipients,
but this limit will no longer apply in CF 5.0.

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org


-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 12:03 PM
To: CF-Talk
Subject: cfmail receipt ants


I have a CF form that when submitted emails a number of persons in my
company. One problem is that it seems to cut-off an address at a certain
limit.

My question: Is there a limit as to how many email addresses can be listed
in the TO= line? I separate each address with a comma and no space. I have
tried including a CC= and BCC= to see whether the TO= has some sort of
address limit, but the problem persists even though it moves down and
cuts-off another email address. It may also be a problem with the email
setup on our internal system as well I realize.

Any help appreciated or suggestions. Thanks

All indications though is that everyone receives the email. Below is the
error email the submitter only receives indicating a problem with an email
address:

--

   - The following addresses had permanent fatal errors -


   - Transcript of session follows -
550 ... Host unknown (Name server: hw: host not found)



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

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

RE: Dynamic PDF

[Daye, Marianne]

There's a custom tag called htm2pdf that does this.
http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=html2p
df&search=search.  I haven't actually put it to the test, but I plan to use
it in the near future.  If you use it, could you tell me what you think and
problems you might have encountered?

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org


-Original Message-
From: Mike Sullivan [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 6:53 PM
To: CF-Talk
Subject: Dynamic PDF


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

All,
Is there a way to create PDFs on the fly?  My users get a results set
from a query and I would like to give them a dynamic way to print it.

Any thoughts on how it can be done?

TIA
Mike 

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

iQA/AwUBOf4JHXYFmKomMlANEQJJ9QCgztd+pjH8xqPClOc8t4+C+AyTbGwAoL8i
+Qlmxq7j9jccBYIrzdqrT4hA
=uLlS
-END PGP SIGNATURE-


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

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

CF_TwoSelectsRelated - Pre-selecting options

[Daye, Marianne]

Using Nat Weiss' CF_TwoSelectsRelated tag, does anyone know how to default
the selection boxes to a specific option, as in ?

Thanks in advance!

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org
Ph: (919) 541-8031

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

RE: SQL Date Error --Help Needed

[Daye, Marianne]

I just put it to the test on my own application with datetime field in the
database.  #CreateODBCDate(Now())#
seems to work just fine.

Marianne Daye

-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 11:50 AM
To: CF-Talk
Subject: SQL Date Error --Help Needed


brain dead.

I am attempting to insert a date into a datetime field in SQL.  It is the
correct ODBCdateformat...it is choking on the zeroed-out time stamp as only
a date is used in the field.   What am I forgetting to get it to insert
properly?  Change database datatype or some code?

Thanks.

Eric


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

RE: How to view textfiles

[Daye, Marianne]

How does the user know the name of the text file(s)?  Is he selecting from a
list?  Is it a result of a query he requested?

If the path and file name are known, the user should be able to just click
on a link.
download file  With a .txt file, this will
probably display the file contents in the browser, but to download the file
he can right-click and select Save Link As...

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org/

-Original Message-
From: monika kon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 1:05 PM
To: CF-Talk
Subject: How to view textfiles


Hello everyone,
I have text files present in the directory.I have a
form which has a textfield and a submit button labeled
as "view".
I want if any one types the name of the textfield and
presses "view" button then should be able to view the
contents of the text file as well able to save it.
Please help.
Thanks in advance
Shally


__
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/

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

RE: CF Career Advice?

[Daye, Marianne]

Location may be a factor.  In my location (RTP, NC) the demand is so great
that many employers have to settle for less than what they'd hoped for,
which is a great opportunity for an entry level who just wants an
opportunity to prove himself.  My experience was limited when I got my
present job; a professional presentation of previous work done got me in the
door, and they've been training me ever since.

Marianne Daye
Programmer/Analyst
Indformation Delivery System
http://ids.rti.org/

-Original Message-
From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 8:30 AM
To: CF-Talk
Subject: CF Career Advice?


Hello Folks,

Wow. I have s much to learn. Just when I think I am getting to
know CF, I come across this discussion list and I realize I am barely
scratching the surface.

I could really use some help in the professional development area.
Situation: New college grad working at a province-wide non-profit in a
relatively rural area, that wants the world while recompensing me on
the same level as McBurger flipper and is not willing to invest
anything in professional development.  Now the choice here is
obvious - get another job!

But where? How? Every CF Developer wanted ad asks for far more than I
have or can learn in the boondocks. Is anyone looking for a junior CF
Developer? (Qualifying factor - in Ontario, Canada or willing to
sponsor) I really want to learn so much more about web developing yet
I cannot seem to find the opportunities. (Yes, I realize I am whining
at this point.) Please advise.

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers & Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262

P.S. You may want to check out all of our websites:
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.
www.OFAH.org - the flagship site of the Ontario Federation of Anglers
& Hunters.



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

RE: 2nd Conference

[Daye, Marianne]

Well, Justin, don't keep us in suspense!  Do you know where it will be?

Marianne

-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 25, 2000 8:09 AM
To: CF-Talk
Subject: Re: 2nd Conference


It's not going to be.. the location has already been decided on.
They are expecting 6000 cfer's..



~Justin MacCarthy
~ Ireland

- Original Message -----
From: "Daye, Marianne" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: "Meroz, Yael" <[EMAIL PROTECTED]>; "Nichols, Robert H." <[EMAIL PROTECTED]>
Sent: Monday, September 25, 2000 12:46 PM
Subject: RE: 2nd Conference


> In that case I'll definitely have to beg my employer to send me.  Wouldn't
> want to miss out on the food!  ...Oh yeah, and the conference.
>
> Marianne
>
> -Original Message-
> From: CF-Talk [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 24, 2000 6:36 AM
> To: CF-Talk
> Subject: Fw: 2nd Conference
>
>
> Iztok, I agree with you. I made a request to Allaire to make the 3rd
> Conference in 2001 somewhere in Europe.
> Uwe
> - Original Message -
> From: "Iztok Polanic" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Freitag, 22. September 2000 14:57
> Subject: 2nd Conference
>
>
> Hi!
>
> We received (some time ago) a notice from Allaire, that they will host the
> 2nd Developer Conference in Washington D.C.  This conference is great ( I
> was at the 1st conference). But to my surprise the entrance fee is $899
(or
> $799 if you register before July or something). THAT'S TOO EXPENSIVE if
you
> ask me!!! If you are from Europe, then you can't come, except if you have
a
> lot of money (entrace fee + plane tickets + hotel + spending money). Am I
> missing something?
>
> Bye,
>
> Iztok
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
>
>
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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


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

RE: 2nd Conference

[Daye, Marianne]

In that case I'll definitely have to beg my employer to send me.  Wouldn't
want to miss out on the food!  ...Oh yeah, and the conference.

Marianne

-Original Message-
From: CF-Talk [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 24, 2000 6:36 AM
To: CF-Talk
Subject: Fw: 2nd Conference


Iztok, I agree with you. I made a request to Allaire to make the 3rd
Conference in 2001 somewhere in Europe.
Uwe
- Original Message -
From: "Iztok Polanic" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Freitag, 22. September 2000 14:57
Subject: 2nd Conference


Hi!

We received (some time ago) a notice from Allaire, that they will host the
2nd Developer Conference in Washington D.C.  This conference is great ( I
was at the 1st conference). But to my surprise the entrance fee is $899 (or
$799 if you register before July or something). THAT'S TOO EXPENSIVE if you
ask me!!! If you are from Europe, then you can't come, except if you have a
lot of money (entrace fee + plane tickets + hotel + spending money). Am I
missing something?

Bye,

Iztok


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






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

RE: 2nd Conference

[Daye, Marianne]

Are you sure you're not my husband posing as someone else?  Your ability to
get steamed up over a simple questions seems all too familiar.

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 22, 2000 11:57 AM
To: CF-Talk
Subject: Re: 2nd Conference


If their taxes are too high, that is their problem.  That still doesn't
change the fact if you can't afford it you can't go.
- Original Message -
From: "Daye, Marianne" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 22, 2000 9:31 AM
Subject: RE: 2nd Conference


> Yeah, but you probably didn't have to pay it out of the pocket money you
get
> after the European tax rate (depending on where Iztok is from).
>
> Marianne Daye
> (originally from Denmark)
>
> -Original Message-
> From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 22, 2000 10:12 AM
> To: CF-Talk
> Subject: Re: 2nd Conference
>
>
> No you are not mssing anything. It means if you can't afford it you can't
> go.  That is a fact of life. Deal with it. I am coming from Michigan and
> still had to pay for airfare, entrance fee, car rental, hotel, spending
> money too...
> - Original Message -
> From: "Iztok Polanic" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, September 22, 2000 7:57 AM
> Subject: 2nd Conference
>
>
> > Hi!
> >
> > We received (some time ago) a notice from Allaire, that they will host
the
> > 2nd Developer Conference in Washington D.C.  This conference is great
 I
> > was at the 1st conference). But to my surprise the entrance fee is $899
> (or
> > $799 if you register before July or something). THAT'S TOO EXPENSIVE if
> you
> > ask me!!! If you are from Europe, then you can't come, except if you
have
> a
> > lot of money (entrace fee + plane tickets + hotel + spending money). Am
I
> > missing something?
> >
> > Bye,
> >
> > Iztok
> >
>
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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


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

RE: 2nd Conference

[Daye, Marianne]

That's why most of them ride busses and bikes.  :-)

Marianne

-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 22, 2000 10:38 AM
To: CF-Talk
Subject: RE: 2nd Conference


With the exchange rates as they are 800 bucks is nearly a whole tank of gas
in the UK :))

Stew

-Original Message-
From: Daye, Marianne [mailto:[EMAIL PROTECTED]]
Sent: 22 September 2000 15:31
To: CF-Talk
Subject: RE: 2nd Conference


Yeah, but you probably didn't have to pay it out of the pocket money you get
after the European tax rate (depending on where Iztok is from).

Marianne Daye
(originally from Denmark)

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 22, 2000 10:12 AM
To: CF-Talk
Subject: Re: 2nd Conference


No you are not mssing anything. It means if you can't afford it you can't
go.  That is a fact of life. Deal with it. I am coming from Michigan and
still had to pay for airfare, entrance fee, car rental, hotel, spending
money too...
- Original Message -
From: "Iztok Polanic" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 22, 2000 7:57 AM
Subject: 2nd Conference


> Hi!
>
> We received (some time ago) a notice from Allaire, that they will host the
> 2nd Developer Conference in Washington D.C.  This conference is great ( I
> was at the 1st conference). But to my surprise the entrance fee is $899
(or
> $799 if you register before July or something). THAT'S TOO EXPENSIVE if
you
> ask me!!! If you are from Europe, then you can't come, except if you have
a
> lot of money (entrace fee + plane tickets + hotel + spending money). Am I
> missing something?
>
> Bye,
>
> Iztok
>
> --

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


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

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

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

RE: 2nd Conference

[Daye, Marianne]

Yeah, but you probably didn't have to pay it out of the pocket money you get
after the European tax rate (depending on where Iztok is from).

Marianne Daye
(originally from Denmark)

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 22, 2000 10:12 AM
To: CF-Talk
Subject: Re: 2nd Conference


No you are not mssing anything. It means if you can't afford it you can't
go.  That is a fact of life. Deal with it. I am coming from Michigan and
still had to pay for airfare, entrance fee, car rental, hotel, spending
money too...
- Original Message -
From: "Iztok Polanic" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 22, 2000 7:57 AM
Subject: 2nd Conference


> Hi!
>
> We received (some time ago) a notice from Allaire, that they will host the
> 2nd Developer Conference in Washington D.C.  This conference is great ( I
> was at the 1st conference). But to my surprise the entrance fee is $899
(or
> $799 if you register before July or something). THAT'S TOO EXPENSIVE if
you
> ask me!!! If you are from Europe, then you can't come, except if you have
a
> lot of money (entrace fee + plane tickets + hotel + spending money). Am I
> missing something?
>
> Bye,
>
> Iztok
>
> --

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


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

RE: I GIVE UP!

[Daye, Marianne]

Have you tried <> 6 ?

Marianne Daye

-Original Message-
From: Geno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 13, 2000 1:39 AM
To: [EMAIL PROTECTED]
Subject: I GIVE UP!


I want to select all records from a table that  "do not" contain the number
6.
Sheesh!  Why is it so difficult to select records this way...

the query was

Select *
>From CaseDetail, CaseInfo
Where CaseDetail.CaseID=CaseInfo.CaseID
And CaseDetail.StatusID ?   6

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

RE: Deleting Duplicate Records in MS access 200

[Daye, Marianne]

To keep it simple, how about running a Make-Table query using 'SELECT
DISTINCT [SuburbName]'.  When you're done, just rename or delete the old
table, and give the old table name to the new table.

Marianne

-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:47 PM
To: [EMAIL PROTECTED]
Subject: Deleting Duplicate Records in MS access 200


I have 5500 records in my suburbs table and many of those suburbs have
identical names therefore I am wanting to delete all duplicates of suburb
names so that I only have one occurrence of each name in the suburb list I
am not sure how to go about this in access 2000

can anyone please assist me please


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]


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

RE: Need a good dynamic bar & pie chart app...

[Daye, Marianne]

I was happy with an applet called tChart which allows you to pass parameters
to various types of charts.  At http://www.javaside.com/us/tchart.shtml you
will find a demo and download.  The download comes with several files
depending on your circumstances.  To pass parameters you'll want to use the
example in tChart5.html source code.  You do have to tinker with the html
source code to get the number of columns, labels, colors, etc. that you
want, but once you get the hang of it, it's a great tool at very low cost
($55 w/o Java source code).

Marianne Daye

-Original Message-
From: Kevin Langevin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 2:32 PM
To: [EMAIL PROTECTED]
Subject: Need a good dynamic bar & pie chart app...


Anyone have a tag/app that plays nicely with ColdFusion to create dynamic
bar and pie chartsin a web page?  I'm specifically looking for something
that will display multiple recommended/actual vertical bars next to each
other, in differing colors.  Any help would be greatly appreciated.

Thanks, all...


-Kev


> -Original Message-
> From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 05, 2000 12:42 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Apache Isn't Playing Nice with ColdFusion...
>
>
> Allaire only supports 1.3.2 and better :)
>
> From the allaire site..
>
> "ColdFusion supports only Apache version 1.3.2 and above"
> For Version 4.01
>
> And for.. 4.5 in my CFDOCS it says
>
> "To configure the Apache Web Server v1.3.6" which kind
> of implies that you have to use that.
>
> And apache will not run in the background in Win98
> try reading the release notes for Win32 apache
> ... Here
>
> http://www.apache.org/docs/windows.html
>
> Apache + CF + NT is real easy with the right
> versions etc.
>
>
> Jeremy
>
>
>
>
>
>
> -Original Message-
> From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 05, 2000 12:23 PM
> To: '[EMAIL PROTECTED]'
> Subject: Apache Isn't Playing Nice with ColdFusion...
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> --_=_NextPart_001_01C01755.9FA441D8
> Content-Type: text/plain;
>   charset="iso-8859-1"
>
> Hello!
>
> I installed Apache 1.3.12 on my machine last night, and I got it running
> with the following problems. Any help on any of these points would be
> greatly appreciated. Win98/C533/64MB/CF4.5 config. TIA!
>
> 1) I can't get Apache to run automatically or as a service in the
> background
>like PWS used to.
>
> Right now, I've got a shortcut to apache.exe in my startup group with
> ColdFusion server. Yes, it seems like a huge hack to me, too. So, at
> startup, I get a DOS-looking window that says something like "Apache
> running...", and indeed it is. But, the DOS window can't be closed without
> killing Apache, and even when I try to shut down, I have to Alt-F4 the
> window and say yes to the "are you sure" dialog. Then, next time I start
> Apache, I get a little message in the DOS window about Apache
> being started
> after it was closed inappropriately last time. Using Start > Programs >
> Apache > Stop Apache gives me an error if the Apache DOS window is still
> open. Trying to install Apache as a service gives me some error in a DOS
> window that closes too quickly for me to read what it says. I just want
> Apache to run in the background with no help from me after I get it set up
> the first time. In other words, I want it to run "hidden" like PWS did.
> (Although it does seem to run faster, which was the reason for the
> "upgrade".)
>
> 2) The /images and /stylesheets directories aren't working, unless...
>
> If I open up IE and hit my site, no images appear, and the page
> is rendered
> without stylesheets, but is otherwise completely functional (queries run,
> CFML is parsed, etc.). So, I can go through and use the site
> without images
> or stylesheets, which is very annoying. But, if I hit Back or use
> history.back();, *the page appears like it is supposed to, complete with
> images and stylesheets*! Consecutive visits to the same page exhibit the
> problems above, but again, using Back or history.back(); will "fix" it.
> That's pretty strange. Yes, the directories are properly mapped
> in CF Admin.
> All of the other dir mappings work correctly. Perhaps I need to add the
> .jpg/.gif/.css file types to httpd.conf? Code, anyone?
>
> 3) Where in httpd.conf is the LoadModule coldfusion_module
>modules/ApacheModuleColdFusion.dll line supposed to go?
>
> At home last night, I stuck it on a new line at the very end of section 1,
> after "#ExtendedStatus On" because I didn't see that it was already there,
> but commented out. Could this be causing the problem listed
> above? I'll fix
> that straightaway when I get home and see, although I'm sure I'll have the
> answer from you guys before then. :-)
>
> 4) Any other Apache/Win32/ColdFusion tips?
>
> If you 

RE: IsDefined() problems

[Daye, Marianne]

Are you remembering to enclose the variable in quotations marks?


...


Marianne

-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 10:57 AM
To: Cf-Talk
Subject: IsDefined() problems


Just a quickie.

I have taken to coding in this way (when I think var may be undefined):



... do something ...


instead of:


... do something ...


Does anyone else have trouble with IsDefined() or is it just me using it
wrong?

Paul



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

RE: Select Distinct not so distinct

[Daye, Marianne]

If any of the remaining fields are numeric you can use SELECT DISTINCT name,
sum(foo) AS foo, sum(bar) AS bar ..., and that will narrow down the
combinations.

Marianne Daye
Programmer/Analyst

-Original Message-
From: Olive, Christopher M Mr NMR
[mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 1:53 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Select Distinct not so distinct


when you

select distinct(name), foo, bar, baz ...

it returns all the distinct combinations of the selected fields.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: Harold Goodson [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 1:48 PM
To: [EMAIL PROTECTED]
Subject: Select Distinct not so distinct


Hi all,

I'm trying to select all of the values from a table where type=foo and I
would like to eliminate duplicates based on name.  

EG.  
SQL="select distinct(name), other, field, names from table where type = foo"
-this returns every field where type is a match.
SQL="select distinct(name) from table where type = foo"
-this works but does not retrieve additional field info.

Am I to understand that select distinct cannot be utilized in this fashion?
 It works if I select the name field only, but if I want more than the name
field it returns all matches.  I cannot ask that the database be
restructured.

Is that just the way it is?

-Andy


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

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

RE: Listing column names in a table

[Daye, Marianne]

There was an article in the ColdFusion Developer's Journal called Dynamic
Table & Query Engine that gives you what you need, and then some (provided
you're NOT using Access).  I couldn't find the complete article on line, but
you can get the source code listings at http://www.sys-con.com/coldfusion/.
Click on SOURCE CODE in the header, select volume 1, Issue 6, and select
Dynamic Table & Query Engine.

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org


-Original Message-
From: Nille af Ekenstam [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 8:56 AM
To: [EMAIL PROTECTED]
Subject: Listing column names in a table


Hi

Anybody know of a good way to find out the column names in a database table 
and outputing them using CF?
What I want to achieve is to use all columns in a table to construct some 
variiables (columnname = value) with without having to know exactly how 
many there are or what they are called.

Thanks!

//Nille



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

RE: Role-based access

[Daye, Marianne]

Did you get Hal's newsletter with his book preview on user permissions.
This is applicable if one user can have several permissions (or belong to
multiple groups).  http://www.teamallaire.com/newsletters/JulyNewsletter.cfm

Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 14, 2000 2:51 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Role-based access



Does anyone know if CF has any built-in modules for user or role-based
access to a website. I'm looking for some kind of login system where I can
restrict access to certain areas based on either the user or a group they
belong to. Thanks in advance for any responses.


Joseph,
We implemented a group-level security on a recent application.  This
is how we did it - in the Users table we have a DepartmentID column.  On the
verify.cfm page, if the user login is successful, we set a bunch of session
variables including .  Then, we use  tags to restrict what is seen or accessed based on
department.  If that does not make sense, email me off list and I will
explain further.  Thanks!

Chris Ivey

MTS Systems Engineer
GTE Data Services: Temple Terrace, Florida
TSS Distributed - WAN Tools Group
Office: (813) 978-4844
Pager: (813) 303-1177
AIM: IveyAtGTEDS


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

RE: searches failing...help.

[Daye, Marianne]

If you use 'WHERE knowledge = '#search_string#, you will only get records
where knowledge matches the search string exactly.  If you use LIKE, you
will only get records where some part of knowledge matches the search string
exactly, i.e. 'Jane Doe' is contained in 'Jane Doe Peterson', but 'Jane Doe'
is not contained in 'Jane B. Doe'.  In the case of "where synopsis =
'#search_string#'", does synopsis contain the word 'site' only, or is 'site'
only a part of the field content?   

-Original Message-
From: miles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 12, 2000 1:23 PM
To: [EMAIL PROTECTED]
Subject: searches failing...help.


Hi,

Ive got myself a tiny problem...which should be a snap for
you folks that are more skilled than myself right now...


select id, entered_date, synopsis, knowledge
from nxsknow
where knowledge = '#search_string#'
order by entered_date desc


this query will fail each and every time with the following
error.

[microsoft][ODBC SQL Server Driver][SQL Server]TEXT and IMAGE datatypes
may not be used in the WHERE or HAVING clause, except with the LIKE
predicate and the IS NULL predicate.

HOWEVER when I change the WHERE statement to the following...

where knowledge LIKE '#search_string#'

I get no results.  It doesn't matter what I enter as a variable.
I should get something backshouldn't I ?

The somewhat annoying part about this is if I change the where
statement to the following

where id = '#search_string#'

and id is equal to some number...this query works...and pulls up a
single record...or if I change the where statement to

where synopsis = '#search_string#'

and synopsis is equal to "site".   It returns nothingit should 
return something
because half the entries in this table half the word "site" in the 
field synopsis.

And before you think that there's nothing in the table...there is plenty
of data.  What's up with this query...why is this happening ?  Any
clues ?

Miles.

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