db2 cftransaction best practices

[s r]

I am trying to convince my Manager and DBAs here to 
change the way they manage Database transactions in 
here.

The environment is ColdFusion 5.0, DB2 version 6, DB2
connect

The current setup is as follows.
-

1. All access to the database is through Stored
Procedures only.
Right now they have the concept of building generic
inserts, updates and 
deletes to each table. 

2. They want to set up transaction processing using
cftransaction 
to keep the DB2 stored procedures simple.

For example say there are 3 tables.
tableA, tableB, tableC
Say my transaction requires 
1. delete row from tableC
2. update row in tableB
3. insert new row in tableB
4. insert a row in tableA

then as per the current practice here  I have to do
this

cftransaction
cfstoredproc procedure=SPLdeleteTableC
/cfstoredproc

cfstoredproc procedure=SPLupdateTableB
/cfstoredproc

cfstoredproc procedure=SPLinsertTableB
/cfstoredproc

cfstoredproc procedure=SPLinsertTableA
/cfstoredproc
/cftransaction

Now to my Question:
--

1. I am trying to convince the processing would be
quicker
if the transaction processing is also built inside
another
Stored Procedure. I am arguing at least give me an
option of doing 
transactions inside the database by providing a
controller stored procedure 
that sets up the transaction and makes nested calls to
the generic ones.

2. I know the processing would be quicker, but I am
trying 
to give them some numbers and a comparison of how much
improvement we can achieve by moving the complexity
into
Stored Procedures.

Can someone point me in the right direction. Also can
someone
tell me what other Issues i can bring up in support of
my
case.

thanks
sudhakar




__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

website redirect question

[S R]

Hello everyone,

This is not a CF question, I guess its more a server/dns question. We have 
our site redirecting to another company, we've been acquired, via an IIS 
hostheader redirect. We've also tried this using a meta redirect. The 
redirect works fine, the only problem is that we had some marketing 
campaigns that pointed to subsections of our site and now everything is 
going to the new company's website. Is there any way at all to get around 
this? Or by specifying a redirect at the root level, via IIS or Meta, going 
to cause this to happen?

Thanks

SR


__
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 and web farms

[S R]

Thanks I'll try your suggestions.

Sal


From: Dave Watts [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: cf and web farms
Date: Wed, 5 Jun 2002 20:07:03 -0400

  - I can't delete a client variable via a 'logout' link/button
  like I can a session variable using the structdelete function.

Use the DeleteClientVariable function.

  - I cannot specify the length of time I would like them to
  expire in individual applications. I can set it in the CF
  administrator, but the expiration times differ between my
  apps.

You can do this with a little bit of code. There are many potential
approaches to this; you could delete the connection between the browser and
the Client variables (typically, the CFID and CFTOKEN cookies), or you 
could
set a Client variable to store the time the user's session started, and use
conditional logic to compare the current time with that original time on
each page request.

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

__
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

cf and web farms

[S R]

Is there any way in CF 5.0 to specify a specific server in a web farm to 
contain session variables? I know I can use client variables in a database 
but that limits me.

thanks

sal


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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 and web farms

[S R]

Maybe I just don't know how to solve these problems but this is how client 
variables have limited me.

- I can't delete a client variable via a 'logout' link/button like I can a 
session variable using the structdelete function.

- I cannot specify the length of time I would like them to expire in 
individual applications. I can set it in the CF administrator, but the 
expiration times differ between my apps.


From: Ken Wilson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: cf and web farms
Date: Wed, 5 Jun 2002 19:04:25 -0400

 I know I can use client variables in a database
 but that limits me.


In what way does that limit you?

I would suggest it's just the opposite. Session variables impose 
limitations
whereas db-driven client variables free you from those limitations.

Ken




-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 6:48 PM
To: CF-Talk
Subject: cf and web farms


Is there any way in CF 5.0 to specify a specific server in a web farm to
contain session variables? I know I can use client variables in a database
but that limits me.

thanks

sal




__
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

MAX function problem

[S R]

Hello,

Everytime I use this function I have problems. My code is below. I keep 
receiving an error saying:

The column THEID is not present in the query named GETID

CFQUERY datasource=#dsn# name=GetID
SELECT MAX(ID) FROM UserInfo AS TheID
/CFQUERY

CFOUTPUT#GetID.TheID#/CFOUTPUT

thanks for your help,

Sal


__
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: MAX function problem

[S R]

Thanks this solved the problem.

Sal

From: [EMAIL PROTECTED] (Scott Brader)
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: MAX function problem
Date: Wed, 29 May 2002 12:34:21 -0500

I believe you should word your query as

SELECT MAX(ID) AS TheID FROM UserInfo

Scott Brader
Prairie Software Development LLC
101 East Sadd Street
PO Box 235
North Prairie, WI 53153-0235

Phone: 262.392.9173
Fax: 262.392.9174

Toll Free: 888.821.3427
Mobile: 262.490.1376

http://www.prairiesoftdev.com

Amateurs practice until they get it right,
Experts practice until they can't get it wrong.

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 12:28
To: CF-Talk
Subject: MAX function problem


Hello,

Everytime I use this function I have problems. My code is below. I keep
receiving an error saying:

The column THEID is not present in the query named GETID

CFQUERY datasource=#dsn# name=GetID
SELECT MAX(ID) FROM UserInfo AS TheID
/CFQUERY

CFOUTPUT#GetID.TheID#/CFOUTPUT

thanks for your help,

Sal




__
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

cf_html2PDF

[S R]

Hi,

I was wondering if anyone has used this custom tag? It creates PDF's from 
dynamicly created html pages. I'm using it now and it works fine except that 
the page I am creating has an img src tag in it and the PDF that is 
created does not keep the image. Someone fills out a form with their info 
(first name, last name, etc), hits submit and it creates this PDF with the 
signature of one of our VP's.

If no one has used this does anyone know of a workaround or other PDF 
on-the-fly PDF creators that might support images (jpg or gif or png)?

thanks

sal


__
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: cf_html2PDF

[S R]

Dave,

This is exactly what I'm using. the cf_html2pdf tag actually executes 
htmldoc. So how do you get it to work with images? My dynamic html page that 
is created is a table and in one of the cells is the image in an img src 
tag. I've tried turning the image into a jpg, pdf, and png. But when the pdf 
is created I get this error message saying 'Could not read Myimage.jpg'. The 
pdf is created just fine but without the image.


From: Dave Wilson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: cf_html2PDF
Date: Wed, 15 May 2002 17:03:36 +0100

Sal,

You could try htmldoc by easysw.com (http://www.easysw.com/htmldoc/) I've
been using this for a couple years now and its excellent. very highly
configurable and has no problems with images.

HTH,
Dave


-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2002 16:45
To: CF-Talk
Subject: cf_html2PDF


Hi,

I was wondering if anyone has used this custom tag? It creates PDF's from
dynamicly created html pages. I'm using it now and it works fine except 
that
the page I am creating has an img src tag in it and the PDF that is
created does not keep the image. Someone fills out a form with their info
(first name, last name, etc), hits submit and it creates this PDF with the
signature of one of our VP's.

If no one has used this does anyone know of a workaround or other PDF
on-the-fly PDF creators that might support images (jpg or gif or png)?

thanks

sal




__
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

sql error

[S R]

This one is driving me nuts. I keep getting a 'Base table not found error'. 
Invalid object name 'Products'.

This is my query:

SELECT  Industries.name as  industryName, Products.name as 
productName, 
Products.version, Products.prefix, Products.ID as prodID
FROMProducts, Industries
WHERE   Products.name = '#COOKIE.prodName#' AND Products.version = 
'#COOKIE.prodVersion#' AND Products.industryID = Industries.ID
order by Industries.name, Products.name

Does anyone know what may be causing this if you look at my code?

thanks


__
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: sql error

[S R]

That's why this is driving me crazy because I already checked out that 
possibility and I'm definitely referencing the correct database. There is a 
products table.

The strange thing is that sometimes it does work and sometimes it doesnt. It 
just doesn't make sense.


From: Matthew Walker [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: sql error
Date: Thu, 16 May 2002 10:18:41 +1200

Um, wild guess . . . no Products table? Are you referencing the wrong
database?


Regards,
Matthew Walker
/*
   Cabbage Tree Creative Ltd
   Christchurch - New Zealand

   http://www.matthewwalker.net.nz/
   http://www.cabbagetree.co.nz/
*/


  -Original Message-
  From: S R [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, 16 May 2002 10:13 a.m.
  To: CF-Talk
  Subject: sql error
 
 
  This one is driving me nuts. I keep getting a 'Base table not
  found error'.
  Invalid object name 'Products'.
 
  This is my query:
 
  SELECT  Industries.name as  industryName,
  Products.name as productName,
  Products.version, Products.prefix, Products.ID as prodID
  FROMProducts, Industries
  WHERE   Products.name = '#COOKIE.prodName#' AND
  Products.version =
  '#COOKIE.prodVersion#' AND Products.industryID = Industries.ID
  order by Industries.name, Products.name
 
  Does anyone know what may be causing this if you look at my code?
 
  thanks
 
 
 

__
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: sql error

[S R]

I think I figured it out. I have a web farm and the database name was not 
specified on one of the server's CF Admin.

thx


From: S R [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: sql error
Date: Wed, 15 May 2002 15:24:56 -0700

That's why this is driving me crazy because I already checked out that
possibility and I'm definitely referencing the correct database. There is a
products table.

The strange thing is that sometimes it does work and sometimes it doesnt. 
It
just doesn't make sense.


 From: Matthew Walker [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: RE: sql error
 Date: Thu, 16 May 2002 10:18:41 +1200
 
 Um, wild guess . . . no Products table? Are you referencing the wrong
 database?
 
 
 Regards,
 Matthew Walker
 /*
  Cabbage Tree Creative Ltd
  Christchurch - New Zealand
 
  http://www.matthewwalker.net.nz/
  http://www.cabbagetree.co.nz/
 */
 
 
   -Original Message-
   From: S R [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, 16 May 2002 10:13 a.m.
   To: CF-Talk
   Subject: sql error
  
  
   This one is driving me nuts. I keep getting a 'Base table not
   found error'.
   Invalid object name 'Products'.
  
   This is my query:
  
 SELECT  Industries.name as  industryName,
   Products.name as productName,
   Products.version, Products.prefix, Products.ID as prodID
 FROMProducts, Industries
 WHERE   Products.name = '#COOKIE.prodName#' AND
   Products.version =
   '#COOKIE.prodVersion#' AND Products.industryID = Industries.ID
 order by Industries.name, Products.name
  
   Does anyone know what may be causing this if you look at my code?
  
   thanks
  
  
  
 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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 error

[S R]

That's exactly what happened. The datasource was there but with no database 
specified on one of the servers.

From: Dave Watts [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: sql error
Date: Wed, 15 May 2002 18:51:11 -0400

   I think I figured it out. I have a web farm and the database
   name was not specified on one of the server's CF Admin.
 
  that's not it. That would give you a DATASOURCE NOT FOUND
  error. Chances are you just mapped to the wrong DB somewhere
  or your permissions are screwed up somehow.

No, that would do it - the datasource would exist, but it just wouldn't
point to a specific database, and with say SQL Server, you'd end up 
querying
the default database, which unless you change that for the specific db user
account would be master.

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

__
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

uploading to multiple servers

[S R]

Hi Everyone,

I am using cffile to give my web users the ability to upload pdf's to a 
directory on my web server. The problem is, I have 3 clustered servers and 
when I upload to one, sometimes, as the servers rotate, the main server will 
override the one that I uploaded to. How do I get around this with cffile? 
or do I have to do this another way.

Sal

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

__
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

moving from application to application

[S R]

I've run into a problem where there are 4-5 different CF applications 
running on the password protected part of my website. I'm using Client 
variables to maintain state. The one thing I'm trying to do is to let 
Administrators be able to get into all applications. Since my apps each have 
a different CFAPPLICATION tag on them obviously, the Administrator can't 
go from one app to another. What's the best way to get around this?

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

__
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

session variables and multiple servers

[S R]

We just changed our website from one being on one server to being on 3 
redundant web servers. The problem is, the web farm switches from server to 
server every 15 minutes to whichever server has the least traffic, which 
causes me and any other user to have to re-login to password protected areas 
on the site every 15 minutes.

How can I make session variables span across all three servers? Or should I 
look into other solutions?

Thank

sal

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

__
Why Share?
  Dedicated Win 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=coldfusionc
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

MAX function problem

[S R]

I keep getting an error resolving parameter MAXID when I do the following

CFQUERY datasource=Contacts name=GetNewUser
SELECT MAX(ID) FROM ContactInfo AS MAXID
/CFQUERY

CFSET UserID = #GetNewUser.MAXID#

I've also tried

CFSET UserID = '#GetNewUser.MAXID#'
CFSET UserID = '#MAXID#'
CFSET UserID = #MAXID#

with the same error resulting.

Sal

_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

__
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: MAX function problem

[S R]

Thanks, it worked. I've been staring at the screen too long and I had the 
sql statement backwards.

Thanks again.

Sal

From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: MAX function problem
Date: Wed, 13 Mar 2002 14:22:04 -0800

Try:

CFQUERY datasource=Contacts name=GetNewUser
SELECT MAX(ID) as MAXID
FROM ContactInfo
/CFQUERY



Regards,
Pardeep.


- Original Message -
From: S R [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 2:08 PM
Subject: MAX function problem


  I keep getting an error resolving parameter MAXID when I do the 
following
 
  CFQUERY datasource=Contacts name=GetNewUser
  SELECT MAX(ID) FROM ContactInfo AS MAXID
  /CFQUERY
 
  CFSET UserID = #GetNewUser.MAXID#
 
  I've also tried
 
  CFSET UserID = '#GetNewUser.MAXID#'
  CFSET UserID = '#MAXID#'
  CFSET UserID = #MAXID#
 
  with the same error resulting.
 
  Sal
 
  _
  MSN Photos is the easiest way to share and print your photos:
  http://photos.msn.com/support/worldwide.aspx
 
 

__
Why Share?
  Dedicated Win 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=coldfusionc
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

CFFILE/GetFileFromPath Problem

[S R]

Hi everyone,

I've ran into a weird problem I can't get around. I'm using the CFFILE tag 
to upload some files. As you know, you have to use the 
enctype=multipart/form-data attribute within the CFFORM tag for CFFILE to 
work. But this causes a problem with the GetFileFromPath function because 
when I'm uploading pdf's its converting the names of the files to a .tmp 
file instead of a .pdf. How can I get around this?

Thanks

Sal

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

__
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: CFFILE/GetFileFromPath Problem

[S R]

Thank you very much. It worked.


From: Dylan Bromby [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: CFFILE/GetFileFromPath Problem
Date: Mon, 11 Mar 2002 09:53:08 -0800

Once CFFILE has uploaded the file, you can use the CFFILE vars to get
the original file name. For starters, try outputting some of these:

CFFILE.ServerFile
CFFILE.ClientFileName
CFFILE.ClientFileExt

And you'll get the hang of it.

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 9:46 AM
To: CF-Talk
Subject: CFFILE/GetFileFromPath Problem


Hi everyone,

I've ran into a weird problem I can't get around. I'm using the CFFILE
tag
to upload some files. As you know, you have to use the
enctype=multipart/form-data attribute within the CFFORM tag for CFFILE
to
work. But this causes a problem with the GetFileFromPath function
because
when I'm uploading pdf's its converting the names of the files to a .tmp

file instead of a .pdf. How can I get around this?

Thanks

Sal

_
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.



__
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

create .doc from CF

[S R]

I'm using cffile to create a word doc from cold fusion The weird thing is 
everytime I try and open the created file in Word, it tells me I need to 
install something When I decline to install, it still opens up the file 
just fine I don't want to deter people with this installation question so 
I'm wondering what's the best way to create a word doc from CF on the fly? 
CFFILE? CFTAG?

Can you specify fonts to use in the word document from CF?

Thank you

Sal

_
Send and receive Hotmail on your mobile device: http://mobilemsncom
__
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://wwwpennyhostcom/redirectcfm?adcode=coldfusionb
FAQ: http://wwwthenetprofitscouk/coldfusion/faq
Archives: http://wwwmail-archivecom/cf-talk@houseoffusioncom/
Unsubscribe: http://wwwhouseoffusioncom/indexcfm?sidebar=lists

RE: create .doc from CF

[S R]

Thanks a lot

Sal

From: Haggerty, Michael A. [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: create .doc from CF
Date: Mon, 4 Mar 2002 13:54:42 -0500

www.cfcomet.com has all the answers.

Mike

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 1:47 PM
To: CF-Talk
Subject: create .doc from CF


I'm using cffile to create a word doc from cold fusion. The weird thing
is
everytime I try and open the created file in Word, it tells me I need
to
install something. When I decline to install, it still opens up the
file
just fine. I don't want to deter people with this installation question
so
I'm wondering what's the best way to create a word doc from CF on the
fly?
CFFILE? CFTAG?

Can you specify fonts to use in the word document from CF?

Thank you

Sal

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


__
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: Links in CFMAIL

[S R]

Try changing your href tag to look like this:

a href=http://www.here.com/index.cfm;go to site/a

From: Stephen Adams [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Links in CFMAIL
Date: Tue, 12 Feb 2002 17:05:55 +

Hi,

I am trying to send an email with a link in the body using CFMAIL, but I 
have found that the link never appears in the message body.  I do have the 
type set as HTML.  Here is an example of the cfmail tag I am using:

   cfmail to=#session.Email#
   from=[EMAIL PROTECTED]
   subject=New password
   server=mail.here.com
   port=25
   timeout=20
   type=HTML


   a href=www.here.com/index.cfmgo to site/a

   /cfmail

Does anyone know how I can fix this ?

Thanks

Stephen

__
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

sending multiple email attachments

[S R]

Is there a way within CFMAIL or any other way to send multiple attachments 
in one email?

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com
__
Why Share?
  Dedicated Win 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=coldfusionc
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

Macromedia in talks with Microsoft??

[S R]

Are these rumors true? and if so, what do you think it will mean for the 
future of ColdFusion if Microsoft was to acquire Macromedia? I got this info 
from fuckedcompany.com which has been a pretty reliable source in the past.

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
__
Why Share?
  Dedicated Win 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=coldfusionc
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: Macromedia in talks with Microsoft??

[S R]

Cool I'll look in the archives.

Sorry about this.




From: Douglas Brown [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Macromedia in talks with Microsoft??
Date: Tue, 5 Feb 2002 09:12:46 -0800

Please read the archives at houseoffusion. This has been discussed in
depth before, and you would most likely get what info you need there.
But if it happensit happens whatcha gonna do.




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
- Original Message -
From: S R [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, February 05, 2002 8:45 AM
Subject: Macromedia in talks with Microsoft??


  Are these rumors true? and if so, what do you think it will mean for
the
  future of ColdFusion if Microsoft was to acquire Macromedia? I got
this info
  from fuckedcompany.com which has been a pretty reliable source in the
past.
 
  _
  Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.
 

__
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

dts schedule problem

[S R]

Hi,

What's the best way to schedule a SQL Server 2000 DTS import/export? The 
reason I'm asking is because I've been scheduling by right-clicking on the 
DTS package and choosing 'schedule package'. But it doesn't run? Has anyone 
experienced similar problems?

Sal


~~
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: protect downloadble documents

[S R]

Awesome!! Thank you!!

Sal


From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: protect downloadble documents
Date: Fri, 24 Aug 2001 18:31:18 -0400

I just did this - use CFCONTENT

Here is a powerpoint:

http://128.121.22.119/scriptcontent/custom/test_ppt.cfm

JoAnn A. Schlosser
Senior Consultant
Association Management Software
Grant Thornton LLP
Washington, D. C.
703.837.4428



-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 6:17 PM
To: CF-Talk
Subject: protect downloadble documents


Hi,

I'm building a password protected extranet that allows someone, once logged
int to view .doc, .pdf and .ppt's. But can I use ColdFusion somehow to
prevent someone from linking directly to the .doc, .pdf, .ppt without 
having

to log in?

Thanks

Sal

~~
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: protect downloadble documents

[S R]

Thank you very much, again. You've been a great help.

Sal


From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: protect downloadble documents
Date: Mon, 27 Aug 2001 17:19:09 -0400

The MIME Type Document is up at http://128.121.22.104/CFCONTENT_types.cfm

JoAnn A. Schlosser
Senior Consultant
Association Management Software
Grant Thornton LLP
Washington, D. C.
703.837.4428



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 6:31 PM
To: CF-Talk
Subject: RE: protect downloadble documents


I just did this - use CFCONTENT

Here is a powerpoint:

http://128.121.22.119/scriptcontent/custom/test_ppt.cfm

JoAnn A. Schlosser
Senior Consultant
Association Management Software
Grant Thornton LLP
Washington, D. C.
703.837.4428



-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 6:17 PM
To: CF-Talk
Subject: protect downloadble documents


Hi,

I'm building a password protected extranet that allows someone, once logged
int to view .doc, .pdf and .ppt's. But can I use ColdFusion somehow to
prevent someone from linking directly to the .doc, .pdf, .ppt without 
having

to log in?

Thanks

Sal

~~
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

protect downloadble documents

[S R]

Hi,

I'm building a password protected extranet that allows someone, once logged 
int to view .doc, .pdf and .ppt's. But can I use ColdFusion somehow to 
prevent someone from linking directly to the .doc, .pdf, .ppt without having 
to log in?

Thanks

Sal
~~
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

view CF code

[S R]

Good Morning,

I had read somewhere awhile back that there was a way for someone to 'view 
CF source code' from a browser. I want to know if this is true and if so, is 
there anyway to protect against that?

Thanks

Sal
~~
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

URL Hack Fix??

[S R]

another hack question. I've read Don Vawter's website on how to prevent this 
type of attack. Someone told me at my work that there's an IIS patch that 
prevents this. Is this true? I'm using IIS 4.0 and SQL 7.0 and SQL 2000 for 
the backend. I want to go back and add these fixes to my CF pages, but if 
there's a patch, I won't need to do it.

Thanks
~~
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: URL Hack Fix??

[S R]

I like that solution


From: Stephen Moretti [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: URL Hack Fix??
Date: Mon, 13 Aug 2001 18:15:36 +0100

 
  another hack question. I've read Don Vawter's website on how to
  prevent this
  type of attack. Someone told me at my work that there's an IIS patch 
that
  prevents this. Is this true? I'm using IIS 4.0 and SQL 7.0 and
  SQL 2000 for
  the backend. I want to go back and add these fixes to my CF pages, but 
if
  there's a patch, I won't need to do it.
 
Err no. there isn't a patch against a user changing the contents of a URL
Query String that is sent to the server.

I wish there was, but I think the only true fix is to find the user and go
visit him/her with a couple of mates and take a baseball bat to their
fingers ;o)

Regards

Stephen



~~
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

sql server replication problem

[S R]

Hi,

I'm taking my first stab at database replication and have run into a 
stonewall.

I'm using SQL Server 2000. When I go to Tools - Create and Manage 
Publications it takes me to the server and various databases within it I can 
choose to designate as a Publisher. I choose the database I want then I 
click 'Create Publication'. then I click next and go to the first window of 
the Create Publication Wizard which allows me to 'Select Distributor'. I 
choose the same server that the Publisher is going to be on and I receive a 
dialog box that says:

'SQL Server Agent on 'MYSERVER' currently uses the system account, which 
causes replication between servers to fail. In the following dialog box, 
specify another account for the Service startup account.'

I click ok and then this is where I get lost. On this dialog box I guess I'm 
supposed to specify another account somewhere, but I already found out that 
this account is not one I create here, it seems like someone has to set it 
up somewhere else, then I have to enter it here. What exactly is this 
account and where does it initially get created? I do not maintain the 
server that contains the Database I wish to designate as a publisher and 
distributor so I'm going to have to relay the problem to them. Or maybe I'm 
doing something wrong?

Thanks for your help

Sal
~~
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

Eprise and ColdFusion

[S R]

Is anyone using Eprise Participant server and ColdFusion? What do you guys 
think about it?
~~
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

can't connect to mail server

[S R]

Are there any ideas as to why Cold Fusion cannot connect to a mail server? 
You can rule out the mail server being down or change of address because I 
just tested it using a non-cold fusion program and I received an email. When 
I go to the CF Admin and 'verify' the mail server connection I get 'Unable 
to connect to server'. It was working last week and today all of a sudden I 
send any emails via CFmail or Cf_aspmail
~~
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: can't connect to mail server

[S R]

I've tried both


From: Dylan Bromby [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: can't connect to mail server
Date: Tue, 31 Jul 2001 13:46:52 -0700

are you connecting by its IP or FQDN?

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 1:39 PM
To: CF-Talk
Subject: can't connect to mail server


Are there any ideas as to why Cold Fusion cannot connect to a mail server?
You can rule out the mail server being down or change of address because I
just tested it using a non-cold fusion program and I received an email. 
When
I go to the CF Admin and 'verify' the mail server connection I get 'Unable
to connect to server'. It was working last week and today all of a sudden I
send any emails via CFmail or Cf_aspmail

~~
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: can't connect to mail server

[S R]

htmldiv style='background-color:'DIV
PI did not get a banner I got a cannot connect error, so somehow there is not a 
connection between my web server and our mail server,/P
Pnbsp;/P
PThanks/P
Pnbsp;/P
PSalBRBR/P/DIV
DIV/DIV
DIV/DIVgt;From: Len Conrad [EMAIL PROTECTED]
DIV/DIVgt;Reply-To: [EMAIL PROTECTED] 
DIV/DIVgt;To: CF-Talk [EMAIL PROTECTED]
DIV/DIVgt;Subject: Re: can't connect to mail server 
DIV/DIVgt;Date: Tue, 31 Jul 2001 23:13:23 +0200 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt; gt;Are there any ideas as to why Cold Fusion cannot connect to a mail 
server? 
DIV/DIVgt; gt;You can rule out the mail server being down or change of address 
because I 
DIV/DIVgt; gt;just tested it using a non-cold fusion program 
DIV/DIVgt; 
DIV/DIVgt;from the CF machine? 
DIV/DIVgt; 
DIV/DIVgt; gt; and I received an email. When 
DIV/DIVgt; gt;I go to the CF Admin and 'verify' the mail server connection I get 
'Unable 
DIV/DIVgt; gt;to connect to server'. It was working last week and today all of a 
sudden I 
DIV/DIVgt; gt;send any emails via CFmail or Cf_aspmail 
DIV/DIVgt; 
DIV/DIVgt;on the CF machine: 
DIV/DIVgt; 
DIV/DIVgt;telnet ip.ad.re.ss 25 
DIV/DIVgt; 
DIV/DIVgt;if you get a banner back, the CF-to-SMTP server connectivity is ok. 
DIV/DIVgt; 
DIV/DIVgt;quit 
DIV/DIVgt; 
DIV/DIVgt;to quit SMTP dialog 
DIV/DIVgt; 
DIV/DIVgt;Len 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt;http://MenAndMice.com/DNS-training 
DIV/DIVgt;http://BIND8NT.MEIway.com : ISC BIND 8.2.4 for NT4 amp; W2K 
DIV/DIVgt;http://IMGate.MEIway.com : Build free, hi-perf, anti-abuse mail 
gateways 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt;
~~
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

SQL help

[S R]

I'm trying to get this sql statement to work within sql server in one shot 
and it seems to be ignoring the DELETE statement completely because when I 
do a select * from HomePageReleases, nothing is deleted. Do you see anything 
wrong?

SELECT MIN(ID) AS MRID FROM HomePageReleases

declare @MRID int
select @MRID = @MRID

DELETE HomePageReleases
WHERE ID = @MRID

Thanks for your help
~~
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 help

[S R]

Thanks. It worked.


From: Glenn Olsen [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: SQL help
Date: Mon, 30 Jul 2001 17:21:18 -0400

Try ...

DECLARE @MRID int
SET @MRID = (SELECT MIN(ID) AS MRID FROM HomePageReleases)

DELETE HomePageReleases
WHERE ID = @MRID


-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 5:02 PM
To: CF-Talk
Subject: SQL help


I'm trying to get this sql statement to work within sql server in one shot
and it seems to be ignoring the DELETE statement completely because when I
do a select * from HomePageReleases, nothing is deleted. Do you see 
anything

wrong?

SELECT MIN(ID) AS MRID FROM HomePageReleases

declare @MRID int
select @MRID = @MRID

DELETE HomePageReleases
WHERE ID = @MRID

Thanks for your help

~~
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

another sql question

[S R]

How would I pass the 'MID' variable from a SQL Stored Procedure to CF? The 
Stored Procedure below works fine I've tested it, I think the only thing I'm 
missing is passing the variable to CF correctly.

My Stored Procedure:

CREATE PROCEDURE sp_FrontPageRelease

AS

DELETE HomePageReleases
WHERE ID = (SELECT MIN(ID)FROM HomePageReleases)

UPDATE HomePageReleases SET ListOrder = 4
WHERE ListOrder = 3

UPDATE HomePageReleases SET ListOrder = 3
WHERE ListOrder = 2

UPDATE HomePageReleases SET ListOrder = 2
WHERE ListOrder = 1

DECLARE @MID int
SET @MID = (SELECT MAX(PressID) AS MID FROM PressReleaseTitles)

INSERT INTO HomePageReleases(PressID, ListOrder)
VALUES(@MID, 1)

RETURN @MID

My CF Code:

CFSTOREDPROC datasource = #dsn# name=sp_FrontPageRelease
CFPROCPARAM sqltype=CF_SQL_INTEGER dbvarname = @MID variable = MID type = 
out
/CFSTOREDPROC

I'm getting an 'sp_FrontPageRelease has no parameters and arguments were 
supplied' error

Thanks again
~~
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

one more sql question

[S R]

Is there anyway to compare times in SQL? I have a page that I would only 
like to output press releases that are less than or equal to the current 
date and time.

I know how to compare dates but not times:

SELECT DatePublish, PressReleaseTitle, PressID, DatePublish, TimePublish 
FROM PressReleaseTitles
WHERE DatePublish = GetDate()

SR
~~
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

weird OLEDB error

[S R]

Hi Everyone,

I have a CF page pulling some info from an OLEDB SQL Server datasource and 
every so often, when I call the page I'll get an error that says Login 
failed for OLEDB source 'login name for my database'

If I sit there and refresh my browser for awhile the error will go away and 
the page will come up just fine, its as if it loses connectivity for awhile 
then, appears. I can't afford this to happen in a production environment. 
Does anyone have any ideas why this may be happening? Is it a better idea to 
enter the datasource as an ODBC rather than an OLEDB in CF Admin?

thanks for your help

Sal
~~
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: weird OLEDB error

[S R]

I'm using 4.5, but it sounds like the same error.


From: Marlon Moyer [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: weird OLEDB error
Date: Thu, 26 Jul 2001 17:27:30 -0500

Are you using CF5, because I started having this problem when I upgraded.
It's definitely keeping me from going to CF5 on my production machine.
Sometimes I also get a message saying that the login failed for user '(name
of database I'm trying to log into)'

Marlon


-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 5:15 PM
To: CF-Talk
Subject: weird OLEDB error


Hi Everyone,

I have a CF page pulling some info from an OLEDB SQL Server datasource and
every so often, when I call the page I'll get an error that says Login
failed for OLEDB source 'login name for my database'

If I sit there and refresh my browser for awhile the error will go away and
the page will come up just fine, its as if it loses connectivity for awhile
then, appears. I can't afford this to happen in a production environment.
Does anyone have any ideas why this may be happening? Is it a better idea 
to

enter the datasource as an ODBC rather than an OLEDB in CF Admin?

thanks for your help

Sal

~~
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

microsoft and Java advice

[S R]

As you all know Microsoft has once again made things difficult for the rest 
of us or have they? I was preparing to take some Java Certification courses 
and am now wondering whether I should do that now that Microsoft has 
announced its future products will not support Java. What exactly does this 
mean? I know there's applets and servlets, are both going to be useless in 
the future? maybe I should learn Microsoft's version of Java?

What does this mean for NEO since I heard its going to a completely Java 
based platform

Sal
~~
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

cfschedule not working

[S R]

Hi,

I've never been able to get cfschedule to work programmatically but I really 
need to so it this time. The problem I'm trying to solve is to create a form 
that someone can fill out to time exactly when their press release goes 
live. They create the press release and save it as a 'work in progress' then 
I've created a form that they will specify when they want it to become 
'Live'. I'm 'hardcoding' dates and times right now just trying to see if it 
works and it is not. Is it supposed to show up in the CFAdmin as a new task 
once I run this page?

I'm using CF 4.5 and my interval in CFAdmin is set to 15.

Here's my code:

CFSET StartDate = #DateFormat(#Now()#, mm/dd/)#
CFSET StartTime = #TimeFormat(#CreateTime(16,  20,  0)#, h:hhtt)#

cfschedule task=PublishPress action=RUN 
url=http://www.mypath.com/myfolder/mySubFolder/act_publish.cfm; 
startdate=#StartDate# starttime=#StartTime#
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

pay rates

[S R]

Hi Everyone,

I need some advice on the going pay rates for a person working on a Cold 
Fusion project. I'm going to have a meeting today with some people who want 
a website that will advertise themselves but will allow their clients to 
login and view the work in progress on the various projects they've been 
working on. So, for example, if I am one of these people's clients I can go 
online and view the look of the brochure they have designed or the copywrite 
material they have wrote and comment on it right there.

Anyway, the application would have a SQL Server backend probably be about 20 
pages. I am also going to do the graphic design. I am also going to research 
a cold fusion ISP for them. Which ones out there are the best in terms of 
stability and support? So I guess I can divide it into 3 parts:

hourly rate for CF developer:
hourly rate for Database Developer (or is this included in the CF developer 
area):
hourly rate for an HTML programmer:
Hourly rate for a designer:

maybe I'm going about it wrong. I don't know I need some guidance so I don't 
get ripped off.

Thank yo so much

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

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

display problem

[S R]

htmlDIVI am trying to out put this variable and I keep getting a 'error resolving 
parameter ROW' error. I don't understand it. Here's my code:/DIV
DIVnbsp;/DIV
DIVnbsp;lt;CFSET EprEvent = 
EprUser.CreateEvent(CallGetRoleIDByName)gt;BRnbsp;lt;CFSET 
EprEvent.SetEventVarnbsp;(env.RoleName,nbsp;myRoleName)gt;BRnbsp;lt;CFSET 
EprEvent.ReturnVar (RoleId , env.RoleId)gt;BRnbsp;BRnbsp;lt;CFSET 
EprUser.ExchangeData()gt;BRnbsp;BRnbsp;lt;CFSET roleId = 
EprUser.GetEventOutput(CallGetRoleIDByName, 
RoleId)gt;BRnbsp;BRnbsp;lt;!--- Grabs members in the role 
---gt;BRnbsp;lt;CFSET EprEvent = 
EprUser.CreateEvent(CallListParticipantsInRole)gt;BRnbsp;lt;CFSET 
EprEvent.SetEventVar(env.RoleId, roleId)gt;BRnbsp;BRnbsp;lt;CFSET 
EprEvent.ReturnEnvVar(Success, 
client.env.CallListParticipantsInRole.Success)gt;BRnbsp;nbsp;nbsp; lt;CFSET 
EprUser.RequestTable (Rst_Table, 
ListParticipantsInRoleResults)gt;BRnbsp;nbsp;nbsp; lt;CFSET 
EprUser.ExchangeData()gt;BRnbsp;BRnbsp;BRnbsp;BRlt;htmlgt;BRlt;headgt;BRnbsp;lt;titlegt;
 Memberslt;/titlegt;BRlt;/headgt;/DIV
DIVlt;body bgcolor=Whitegt;/DIV
DIVlist here/DIV
DIVlt;cfoutputgt;#roleId#lt;brgt;#EprUser.GetEventOutput(CallListParticipantsInRole,
 Success)#lt;brgt; 
#EprUser.TableRows(Rst_Table)#lt;brgt;lt;/cfoutputgt;/DIV
DIVnbsp;/DIV
DIVlt;cfoutputgt;#EprUser.TableData(Rst_Table, row, 
LoginID)#lt;/cfoutputgt;/DIV
DIVnbsp;/DIV
DIVthanks for your help/DIVbr clear=allhrGet your FREE download of MSN 
Explorer at a 
href=http://explorer.msn.com;http://explorer.msn.com/abr/p/html

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

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

need some advice

[S R]

htmlDIVHi Everyone,/DIV
DIVnbsp;/DIV
DIVI've been staring at my code to long and I'm stumped. I have a select menu (see 
below) that is being populated from a databse.nbsp; My problem is, if a user chooses 
an option from the pull down menu it needs to also send the rest of my form variables 
to the next page. Right now, using the 'onChange' handler, its only send the ID 
variable within the 'option' tag. Now I know I can use the 'this.form.submit()' to 
accomplish this but I cannot use it because I need the page to go somewhere different 
when they press 'submit'. What would be cool is if I could dynamically change the 
lt;formgt; tag to go one place when they click submit and another if they choose an 
option from the pull down menu. I'm not well versed in Javascript,nbsp;but I probably 
could do it through Javascript. Any help will do./DIV
DIVnbsp;/DIV
DIVThanks/DIV
DIVnbsp;/DIV
DIVnbsp;function openURL(){ /DIV
DIVnbsp;// grab index number of the selected optionBRnbsp;selInd = 
document.myForm.CompanyID2.selectedIndex; BRnbsp;BRnbsp;// get value of the 
selected optionBRnbsp;goURL = 
document.myForm.CompanyID2.options[selInd].value;BRnbsp;BRnbsp;// redirect 
browser to the grabbed value (hopefully a URL)BRnbsp;top.location.href = goURL; 
BR}BR// end hiding script--gt;/DIV
DIVnbsp;/DIV
DIVnbsp;nbsp;lt;cfoutputgt;lt;select name=CompanyID2 
onchange=openURL()gt;lt;/cfoutputgt;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
 lt;option value=gt;lt;/optiongt;BRnbsp;nbsp;nbsp;lt;cfoutput 
query=GetCompaniesgt;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
 lt;option value=index.cfm?ID=#ID# lt;cfif IsDefined(ThisVar) AND 
FORM.CompanyID2 IS NOT ''gt;lt;cfif GetCompanies.ID IS 
FORM.CompanyID2gt;selectedlt;/cfifgt;lt;/cfifgt;gt;#CompanyName#lt;/optiongt;BRnbsp;nbsp;nbsp;lt;/cfoutputgt;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
 lt;/selectgt;/DIVbr clear=allhrGet your FREE download of MSN Explorer at a 
href=http://explorer.msn.com;http://explorer.msn.com/abr/p/html

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

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

RE: cffile DOES NOT WORK!!!

[S R]

I figured it out. Thanks for your help. After one finally gets some sleep, 
you start to see what went wrong.

Sal


From: Ryan Sabir [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: cffile DOES NOT WORK!!!
Date: Thu, 31 May 2001 12:41:38 +1000


This should be straightforward as I've done similar things before... are 
you
able to post your code to the list, both the Upload page and the CFFILE
page... just stick it in the body of the email and let us look over it.



-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 31 May 2001 8:43 AM
To: CF-Talk
Subject: cffile DOES NOT WORK!!!


I am having a terrible day, I am still trying to solve this email 
attachment
problem, I figured out that you have to use cffile to upload it to the
server and then it will magically work, well I can't even get that to work.
This is the error I am getting:

Error processing CFFILE

The directory specified in the DESTINATION attribute of the CFFILE tag
(c:\Inetpub\wwwroot\hnc\) is not valid. The directory either does not exist
or is not accessible by the Cold Fusion service.


And this directory does indeed exists, it actually contains my entire
website. I'm really stuck.

SR

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

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

RE: how do i send an attachment?

[S R]

Yeah, I tried using that and I got this error:

MIMEATTACH

An invalid file name (C:\Documents and Settings\sxr\My 
Documents\Generator.doc) was specified in the MIMEATTACH attribute. Please 
verify that this file exists and that the Cold Fusion service has the 
privileges required to access it.

I set up a page with a input type=file name=myAttachment tag so that 
the user can browse for the file on their desktop, just like any other 
attachment option, like the way hotmail does it. That's why I was trying to 
go another route because this isn't working. This is how my form tag looks:

cfform action=corebank_requests_process_030107new.cfm method=post 
enctype=application/x-www-form-urlencoded


From: Mark Warrick [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: how do i send an attachment?
Date: Tue, 29 May 2001 18:43:59 -0700

Why not just use CFMAIL and use the mimeattach attribute?  For example:

cfmail
TO=
CC=
FROM=
SUBJECT=
MIMEATTACH=#uploadpath#\#serverfile#
 


Mark Warrick - Fusioneers.com
Email: [EMAIL PROTECTED]
Phone: 714-547-5386
http://www.fusioneers.com
http://www.warrick.net


  -Original Message-
  From: S R [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, May 29, 2001 3:43 PM
  To: CF-Talk
  Subject: how do i send an attachment?
 
 
  What is the best way to allow someone to send an attachment
  through a form?
  I've tried the new tag cfmailparam and I'm getting an error
  saying I have
  mispelled the tag. I'm using cf 4.5.2 so I should be able to use this 
tag.
 
  Thanks
 
  Sal
 

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

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

cffile DOES NOT WORK!!!

[S R]

I am having a terrible day, I am still trying to solve this email attachment 
problem, I figured out that you have to use cffile to upload it to the 
server and then it will magically work, well I can't even get that to work. 
This is the error I am getting:

Error processing CFFILE

The directory specified in the DESTINATION attribute of the CFFILE tag 
(c:\Inetpub\wwwroot\hnc\) is not valid. The directory either does not exist 
or is not accessible by the Cold Fusion service.


And this directory does indeed exists, it actually contains my entire 
website. I'm really stuck.

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

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

how do i send an attachment?

[S R]

What is the best way to allow someone to send an attachment through a form? 
I've tried the new tag cfmailparam and I'm getting an error saying I have 
mispelled the tag. I'm using cf 4.5.2 so I should be able to use this tag.

Thanks

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

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

auto-form fill in

[S R]

Does anyone know of a custom cf tag or javascript where once a user chooses 
an item from a pull down menu it will fill in the address fields of the form 
automatically? I'm thinking the page would first do a query of a table that 
contains all the companies and their addresses the users could choose from 
and store it in an array, then whichever 'company' the user chooses it will 
refer to the array and match the comapny ID numbers and auto-fill the info?

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

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

SQL Code problem

[S R]

Hi,

I'm trying to create a table and set a 'default value' for one of the 
columns using the SQL Query analyzer. I keep getting this error when I try 
to run the script:

Server: Msg 128, Level 15, State 1, Line 3
The name 'CategoryID_default' is not permitted in this context. Only 
constants, expressions, or variables allowed here. Column names are not 
permitted.

I can't seem to find anything wrong. I'm using MS SQL Server 2000

Here's my code:

Create Table ForumID
(ForumID integer not NULL IDENTITY (1,1) PRIMARY KEY CLUSTERED, CategoryID 
integer,
DEFAULT CategoryID_default '0' FOR CategoryID)

any help is appreciated,

Thank you

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

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

no buffer space available

[S R]

Hi,

This is not really a CF question but if anyone can help that would be 
awesome!! I've been using CuteFTP to upload files to my server which is a 
windows NT server. All of a sudden when I tried to connect to the server I 
get an error message that says Error 10055 in function bind 'No buffer Space 
Available'.

This is scary because I can't upload anything now. Does anyone know how to 
fix this???

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

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

Cold Fusion Forums

[S R]

Hi Everyone,

Can anyone recommend a good software package either from Allaire or someone 
else that can be used for web forums, sort of like this cf-talk forum?

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

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

OLE DB vs. ODBC

[S R]

htmlDIVHi,/DIV
DIVnbsp;/DIV
DIVI've been told in the past that when using CF server and SQL Server to use OLE DB 
instead of ODBC when connecting to databases. I've never been told why? Is it faster? 
Another thing is they use ODBC where I work to connect to SQL Server databases and are 
asking me to create a test so that they can see the differences between the two. Which 
kind of tests would you create and is there going to be that much of a difference to 
show them?/DIV
DIVnbsp;/DIV
DIVThanks/DIV
DIVnbsp;/DIV
DIVSal/DIVbr clear=allhrGet your FREE download of MSN Explorer at a 
href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html

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

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

Re: Form Fields cleared on Back

[S R]

I've found that this is something that happens on IE5. Netscape doesn't do 
this. The only way I've gotten around is to painstakingly include a bunch of 
'hidden' form fields that way when the user presses the back button it 
repopulates the form.


From: "Adrian Cesana" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Form Fields cleared on Back
Date: Tue, 13 Mar 2001 11:46:49 -0800

Im going nuts trying to figure this one out, I have a form with about 110
fields (ya i know), there is lots of server side validation, if an input
error occurs I CFABORT and give the user a JavaScript back button to go 
back
an correct the input.  On some users PC the form gets cleared on other PC's
it does not.  I also use some of the CF built in validation (_required) so
the user has to use the browser back button, same thing happens on some of
these peoples browsers.  Of coarse it does not happen on mine.  I setup a
few test forms for the problems users and it things work ok.  These users
are all using IE 5.x, any one else have such problems, could it be the 
large
number of INPUT fields? any browser settings? registry settings? Voodoo
dances? anything?

Thanks,Adrian




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

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

ISP's with CF

[S R]

htmlDIVHello,/DIV
DIVnbsp;/DIV
DIVI've been asked to build a website for a client. The website is going to have 
forms, need some kind of database connectivity, basically its a dynamic website. Does 
anyone know of an ISP out there that offers Cold Fusion and preferably SQL Server 
capabality? I don't think any of the major ones, like prodigy, earthlink or AOL 
do./DIV
DIVnbsp;/DIV
DIVThanks for your help,/DIV
DIVnbsp;/DIV
DIVSal/DIVbr clear=allhrGet your FREE download of MSN Explorer at a 
href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html

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

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

RE: Cold Fusion and Eprise

[S R]

htmlDIV
PI understand your point. I've only been using it for 2 weeks and its very clunky. 
/P
PSalBRBR/P/DIV
DIV/DIV
DIV/DIVgt;From: "Ken Wilson" [EMAIL PROTECTED]
DIV/DIVgt;Reply-To: [EMAIL PROTECTED] 
DIV/DIVgt;To: CF-Talk [EMAIL PROTECTED]
DIV/DIVgt;Subject: RE: Cold Fusion and Eprise 
DIV/DIVgt;Date: Wed, 28 Feb 2001 20:34:07 -0500 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt;I do believe you'll need to use the callScript event to include 
CF/ASP/JSP 
DIV/DIVgt;code within your Eprise pages. If you still have your samples installed 
you 
DIV/DIVgt;might take a look at 
DIV/DIVgt;http://YOUR_SERVER/eprise/samples/help/Events/callScript for some 
DIV/DIVgt;info/examples. While you're there take a look at CallHTTPGet and 
DIV/DIVgt;CallHTTPPost also. 
DIV/DIVgt; 
DIV/DIVgt;I am, unfortunately, stuck with the task of trying to make my CEO's 
$100k 
DIV/DIVgt;Eprise decision worthwhile. Needless to say, the bulk of my attention 
is 
DIV/DIVgt;directed at persuading them to abandon it in favor of a more 
appropriate, 
DIV/DIVgt;more capable and less expensive CF solution. So far, I'm finding it far 
DIV/DIVgt;faster to prototype the whole site in CF/Fusebox and then move it over 
into 
DIV/DIVgt;Eprise. Can you sense that bad attitude I've got about it all? 
DIV/DIVgt; 
DIV/DIVgt;Ken 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt; gt; -Original Message- 
DIV/DIVgt; gt; From: S R [mailto:[EMAIL PROTECTED]] 
DIV/DIVgt; gt; Sent: Wednesday, February 28, 2001 6:00 PM 
DIV/DIVgt; gt; To: CF-Talk 
DIV/DIVgt; gt; Subject: Cold Fusion and Eprise 
DIV/DIVgt; gt; 
DIV/DIVgt; gt; 
DIV/DIVgt; gt; 
DIVHi Everyone,/DIV
DIV/DIVgt; gt; 
DIVnbsp;/DIV
DIV/DIVgt; gt; 
DIVIs anyone currently or has in the past used Cold Fusion and /DIVgt; gt; 
Eprise? I'm new to Eprise and I'm trying to figure out a way to 
DIV/DIVgt; gt; create Cold Fusion pages in Eprise and get them to work when they 
DIV/DIVgt; gt; are referenced. As you know Eprise stores the pages in a SQL 
DIV/DIVgt; gt; database and generates the pages on the fly, it doesn't create a 
DIV/DIVgt; gt; physical .cfm page which is causing my problem. I am using Eprise 
DIV/DIVgt; gt; version 2.65 but hope to upgrade to 3.2 along with CF 4.51. I 
DIV/DIVgt; gt; would like to know how to do it or any resources out there, 
DIV/DIVgt; gt; besides Eprise's slow tech support, on how to do it.
DIV/DIV
DIV/DIVgt; gt; 
DIVnbsp;/DIV
DIV/DIVgt; gt; 
DIVThanks for your help/DIV
DIV/DIVgt; gt; 
DIVnbsp;/DIV
DIV/DIVgt; gt; 
DIVSal/DIVBR clear=all
HR
Get your FREE download of MSN 
DIV/DIVgt; gt; Explorer at A DIV gt; gt; 
href="http://explorer.msn.com"gt;http://explorer.msn.com/ABR
P/P
DIV/DIVgt; gt; 
DIV/DIVgt; gt; 
DIV/DIVgt;
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Cold Fusion and Eprise

[S R]

htmlDIVHi Everyone,/DIV
DIVnbsp;/DIV
DIVIs anyone currently or has in the past used Cold Fusion and Eprise? I'm new to 
Eprise and I'm trying to figure out a way to create Cold Fusion pages in Eprise and 
get them to work when they are referenced. As you know Eprise stores the pages in a 
SQL database and generates the pages on the fly, it doesn't create a physical .cfm 
page which is causing my problem. I am using Eprise version 2.65 but hope to upgrade 
to 3.2 along with CF 4.51. I would like to know how to do it or any resources out 
there, besides Eprise's slow tech support, on how to do it./DIV
DIVnbsp;/DIV
DIVThanks for your help/DIV
DIVnbsp;/DIV
DIVSal/DIVbr clear=allhrGet your FREE download of MSN Explorer at a 
href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html

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

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

Win2K and SQL Server 7.0 quest

[S R]

htmlDIVHello,/DIV
DIVnbsp;/DIV
DIVI cannot register a server from in SQL 7.0 using enterprise manager. I am trying 
to connect from a Win2K workstation to a Win2k server. The win2k is running with SP3 
and the strange thing is that I have installed installed SP3 on my machine and 
rebooted, but when I go to the Sql server 'help' menu to look up info it only lists 
SP1 as being installed. Has anyone ever had this problem, if so what did you do to 
solve it./DIV
DIVnbsp;/DIV
DIVSal/DIVbr clear=allhrGet your FREE download of MSN Explorer at a 
href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html

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

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

Re: Win2K and SQL Server 7.0 quest

[S R]

htmlDIV
PSorry I meant SP3 for SQL SERVER 7.0BRBR/P/DIV
DIV/DIV
DIV/DIVgt;From: "Greg Wolfinger" [EMAIL PROTECTED]
DIV/DIVgt;Reply-To: [EMAIL PROTECTED] 
DIV/DIVgt;To: CF-Talk [EMAIL PROTECTED]
DIV/DIVgt;Subject: Re: Win2K and SQL Server 7.0 quest 
DIV/DIVgt;Date: Fri, 16 Feb 2001 12:13:55 -0500 
DIV/DIVgt; 
DIV/DIVgt;I havn't even herd of SP3 for Win2k.where was SP2??? 
DIV/DIVgt; 
DIV/DIVgt;--=@ greg @=-- 
DIV/DIVgt;- Original Message - 
DIV/DIVgt;From: "S R" [EMAIL PROTECTED]
DIV/DIVgt;To: "CF-Talk" [EMAIL PROTECTED]
DIV/DIVgt;Sent: Friday, February 16, 2001 12:08 PM 
DIV/DIVgt;Subject: Win2K and SQL Server 7.0 quest 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt; gt; 
DIVHello,/DIV
DIV/DIVgt; gt; 
DIVnbsp;/DIV
DIV/DIVgt; gt; 
DIVI cannot register a server from in SQL 7.0 using enterprise manager. /DIVgt;I 
am trying to connect from a Win2K workstation to a Win2k server. The win2k 
DIV/DIVgt;is running with SP3 and the strange thing is that I have installed 
installed 
DIV/DIVgt;SP3 on my machine and rebooted, but when I go to the Sql server 'help' 
menu 
DIV/DIVgt;to look up info it only lists SP1 as being installed. Has anyone ever 
had 
DIV/DIVgt;this problem, if so what did you do to solve it.
DIV/DIV
DIV/DIVgt; gt; 
DIVnbsp;/DIV
DIV/DIVgt; gt; 
DIVSal/DIVBR clear=all
HR
Get your FREE download of MSN Explorer at 
DIV/DIVgt;A href="http://explorer.msn.com/"http://explorer.msn.com/ABR
P/P
DIV/DIVgt; gt; 
DIV/DIVgt; gt; 
DIV/DIVgt;
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Win2K and SQL Server 7.0 quest

[S R]

htmlDIV
PSP stands for Service pack and yes they are free. They are available on the 
microsoft website for download. They are packages of bug fixes for a particular 
products, in my case, SQL Server 7.0/P
Pnbsp;/P
PBRBRnbsp;/P/DIV
DIV/DIV
DIV/DIVgt;From: Phoeun Pha [EMAIL PROTECTED]
DIV/DIVgt;Reply-To: [EMAIL PROTECTED] 
DIV/DIVgt;To: CF-Talk [EMAIL PROTECTED]
DIV/DIVgt;Subject: RE: Win2K and SQL Server 7.0 quest 
DIV/DIVgt;Date: Fri, 16 Feb 2001 11:15:59 -0600 
DIV/DIVgt; 
DIV/DIVgt;what are SP's for, and are they free? 
DIV/DIVgt; 
DIV/DIVgt;-Original Message- 
DIV/DIVgt;From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] 
DIV/DIVgt;Sent: Friday, February 16, 2001 11:14 AM 
DIV/DIVgt;To: CF-Talk 
DIV/DIVgt;Subject: Re: Win2K and SQL Server 7.0 quest 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt;I havn't even herd of SP3 for Win2k.where was SP2??? 
DIV/DIVgt; 
DIV/DIVgt;--=@ greg @=-- 
DIV/DIVgt;- Original Message - 
DIV/DIVgt;From: "S R" [EMAIL PROTECTED]
DIV/DIVgt;To: "CF-Talk" [EMAIL PROTECTED]
DIV/DIVgt;Sent: Friday, February 16, 2001 12:08 PM 
DIV/DIVgt;Subject: Win2K and SQL Server 7.0 quest 
DIV/DIVgt; 
DIV/DIVgt; 
DIV/DIVgt; gt; 
DIVHello,/DIV
DIV/DIVgt; gt; 
DIVnbsp;/DIV
DIV/DIVgt; gt; 
DIVI cannot register a server from in SQL 7.0 using enterprise manager. /DIVgt;I 
am trying to connect from a Win2K workstation to a Win2k server. The win2k 
DIV/DIVgt;is running with SP3 and the strange thing is that I have installed 
installed 
DIV/DIVgt;SP3 on my machine and rebooted, but when I go to the Sql server 'help' 
menu 
DIV/DIVgt;to look up info it only lists SP1 as being installed. Has anyone ever 
had 
DIV/DIVgt;this problem, if so what did you do to solve it.
DIV/DIV
DIV/DIVgt; gt; 
DIVnbsp;/DIV
DIV/DIVgt; gt; 
DIVSal/DIVBR clear=all
HR
Get your FREE download of MSN Explorer at 
DIV/DIVgt;A href="http://explorer.msn.com/"http://explorer.msn.com/ABR
P/P
DIV/DIVgt; gt; 
DIV/DIVgt; gt; 
DIV/DIVgt;
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

the future of xml and cf

[S R]

htmlDIVHi,/DIV
DIVnbsp;/DIV
DIVI've been reading up on XML because I want to learn more about what it is. It 
seems to me that it will probably replace cold fusion when it gets up to speed at 
where it wants to be. What is your opinion about this. Here are some points I found in 
my research that led me to believe this. These are things that cf seems to do 
now:/DIV
DIVnbsp;/DIV
OL
LIApplications that require a Web client to mediate between two or more 
heterogeneous databases. 
LIApplications that attempt to distribute a significant portion of the processing 
load from a Web server to a Web client. 
LIApplications that require a Web client to present different views of the same data 
to different users. 
LIApplications in which intelligent Web agents attempt to tailor information 
discovery to the needs of individual users. /LI/OL
PSal/Pbr clear=allhrGet your FREE download of MSN Explorer at a 
href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html

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

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

cf isp??

[S R]

Hi,

I would like to start doing web jobs on the side, designing graphics, html 
and I would like to offer coldFusion and SQL services. Do you guys/girls 
know of any hosting companies that have CF running on them? How does this 
work, I would have to have a single client version at home, test everything 
out, then upload to their site? I don't think any of the big ones offer this 
(aol, earthlink, prodigy)

Thanks

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

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

format question

[S R]

I have a page in which I need to display a block of text, pulled from a 
database, with the 'returns' doing exactly what the user intended.

For example I need it to look like this:

This is one line.
Here is another.
And one more

Instead of this:

This is one line. Here is another. And one more.

Note: This is not a textarea or form field of any sort, I already know how 
to do that with HTMLEditFormat, but that does not seem to work for this

Thanks

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

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

cfstoredproc problem

[S R]

I have been at this for the past 35 minutes and I just can't figure it out. 
This cfstoredproc just isn't working. I've tested the actual stored 
procedure on SQL Server by placing some actual values in the stored 
procedure and it worked. But when I try to use this cfstoredproc to do the 
stored procedure it doesn't do anything. The #cfstoredproc.statuscode# is 
even at 0 can you see anything wrong?

CFSTOREDPROC DATASOURCE="#application.datasource#" 
PROCEDURE="sp_UpdatePicture" DBNAME="userpreferences" RETURNCODE="Yes"
CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@picture" 
VALUE="#FORM.picture#" TYPE="In"
CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@userid" 
VALUE="#session.userid#" TYPE="In"
/CFSTOREDPROC

here is my stored procedure:

UPDATE PasUsers SET picture = '@picture'
WHERE userid = '@userid'
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

how do i delete client vars?

[S R]

I know how to delete a session variable using:

cfset structdelete(session, "myVariable")

it works fine but I tried it with a client variable:

cfset structdelete(client, "myVariable")

and I got an error.
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: how do i delete client vars?

[S R]

Thanks everyone!!


From: "Allan Pichler" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: how do i delete client vars?
Date: Thu, 28 Dec 2000 10:18:19 -0800

That's how it is for us "Old Timers". Maybe that monkey butt formula is not
as good as we thought.

Allan Pichler
Machine Dreams Inc.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 10:16 AM
To: CF-Talk
Subject: RE: how do i delete client vars?


  The client scope isn't a structure. You can't directly delete
  client variables, but you can set their values to empty strings.

Oops! I forgot about DeleteClientVariables(). I must be getting senile!

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

~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

how do I show a range of numbers?

[S R]

For example I have a CFIF statement that looks like this:

CFIF #VARIABLE# IS 1 OR #VARIABLE# IS 2 OR #VARIABLE# IS 3 ETC...

could I do something like:

CFIF #VARIABLE# IS 1-9
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: how do I show a range of numbers?

[S R]

AWESOME!!


From: "Ben Forta" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: how do I show a range of numbers?
Date: Thu, 28 Dec 2000 16:08:20 -0500

You could do CFIF (variable GTE 1) (AND variable LTE 9)


-Original Message-----
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 4:02 PM
To: CF-Talk
Subject: how do I show a range of numbers?


For example I have a CFIF statement that looks like this:

CFIF #VARIABLE# IS 1 OR #VARIABLE# IS 2 OR #VARIABLE# IS 3 ETC...

could I do something like:

CFIF #VARIABLE# IS 1-9

~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

javascript problem

[S R]

Happy holidays,

This problem is boggling my mind. It only happens when I put the code in the 
'root' application. I'm trying to test for a 'session.userid' variable that 
is supposed to be set after someone logs in with the correct username and 
password. As you can see I am testing it by deleting my session variable and 
the page with the login screen, which is a pop-up window, does come up. 
Except that the pop-up window goes into an infinite loop of refreshing 
itself. I can't figure it out. HELP!!

Thanks

CFAPPLICATION NAME="Intranet" CLIENTMANAGEMENT="Yes" 
SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(1, 0, 0, 0)#"

CFLOCK SCOPE="APPLICATION" TIMEOUT="30" TYPE="EXCLUSIVE"
CFSET Application.Datasource = 'userpreferences'
/CFLOCK

CFSET StructDelete(session,"userid")

CFIF NOT IsDefined("session.userid")
HTML
HEAD

SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"

function openpopup(){
openpopup=window.open("login.cfm","newWin","width=200,height=150,left=400, 
right=300")
}

/SCRIPT
/HEAD
BODY ONLOAD="javascript:openpopup();openpopup.focus()"

/BODY
/HTML

CFELSE


CFINCLUDE TEMPLATE="/application/header.cfm"

/CFIF
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: javascript problem

[S R]

I tried it and it still sends the pop-up part of the page into an infinite 
'refresh/reload' loop


From: "Allan Pichler" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: javascript problem
Date: Tue, 26 Dec 2000 15:48:39 -0800


Try this 

SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"
function openpopup(){
popwin=window.open("login.cfm","newWin","width=200,height=150,left=400,
right=300")
popwin.focus();
   }
/SCRIPT

BODY ONLOAD="javascript:openpopup();"


Allan Pichler
Machine Dreams Inc.

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 26, 2000 3:36 PM
To: CF-Talk
Subject: javascript problem


Happy holidays,

This problem is boggling my mind. It only happens when I put the code in 
the
'root' application. I'm trying to test for a 'session.userid' variable that
is supposed to be set after someone logs in with the correct username and
password. As you can see I am testing it by deleting my session variable 
and
the page with the login screen, which is a pop-up window, does come up.
Except that the pop-up window goes into an infinite loop of refreshing
itself. I can't figure it out. HELP!!

Thanks

CFAPPLICATION NAME="Intranet" CLIENTMANAGEMENT="Yes"
SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(1, 0, 0, 0)#"

CFLOCK SCOPE="APPLICATION" TIMEOUT="30" TYPE="EXCLUSIVE"
   CFSET Application.Datasource = 'userpreferences'
/CFLOCK

CFSET StructDelete(session,"userid")

CFIF NOT IsDefined("session.userid")
   HTML
   HEAD

   SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"

   function openpopup(){
   openpopup=window.open("login.cfm","newWin","width=200,height=150,left=400,
right=300")
   }

   /SCRIPT
   /HEAD
   BODY ONLOAD="javascript:openpopup();openpopup.focus()"

   /BODY
   /HTML

CFELSE


   CFINCLUDE TEMPLATE="/application/header.cfm"

/CFIF

~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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

variable problem

[S R]

Hi,

My variable problem is that I have a header template that appears on every 
single page in my application. inside this header is an img src tage whose 
image needs to change based on which page is being accessed:

img src="#imageName#"

since the variables are set at the top of each page from this 'header' 
template I need to be able to designate the #imageName# variable from the 
'content' part of my pages. So basically I have a variable at the top of the 
page that needs to pull from a value at the bottom of the page. Can this be 
done? Maybe I should set a session variable and delete/rewrite it with every 
call to a new page??
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

emails and cf problem

[S R]

Hi,

I have an application here kind of like house of fusion where people can 
email questions via a web interface and other people can reply to each 
other's questions. The messages are contained in an SQL database. It works 
fine except when sent from 2 people in my company. When these 2 people send 
their messages there messages are sent with no subject, no email address 
specified and no text in the message. This may not be a cf problem but has 
anyone had a similar problem. We use Exchange server for our emails.

One thing our I.S. guy told us to compare were the headers of these 2 
people's email messages and others. He said the header's could be out of 
order and that is what's confusing the application. Indeed the headers were 
out of order. I have no idea what this means. The headers i am referring to 
are when you have a string of replies to an email address and you look at 
the top of the message:

Deliverd-To:
Reply-To:
From:
To:
cc:
Subject:
DateL
X-Mailer:
Importance
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

session variable problem

[S R]

htmlDIVHi,/DIV
DIVnbsp;/DIV
DIVI am having the strangest problem with a session variable. I set it in my 
application.cfm file and this is the code:/DIV
DIVnbsp;/DIV
DIVlt;CFLOCK SCOPE="SESSION" TIMEOUT="30" TYPE="EXCLUSIVE"gt;BRlt;CFIF NOT 
IsDefined("session.UserID")gt;BRnbsp;lt;CFSET session.UserID = 
#GetVar.UserID#gt;BRlt;/CFIFgt;BRlt;/CFLOCKgt;/DIV
DIVnbsp;/DIV
DIV2 out of the 3 people where I work can use the website just fine. The 3rd person 
has their session variable set but when I try and output it, nothing shows up. I know 
the session variable has been set because if I do a lt;cfif 
isDefined("session.userid")gt; 'Yes I exist' lt;cfelsegt;I don't existlt;/cfifgt; 
Itnbsp; gives me a 'Yes, I exist'. I even deleted it by using lt;cfset 
structdelete("session.userid")gt; and ran the lt;cfifgt; statement again and it 
said 'I don't exist'. When I do lt;cfoutputgt;#session.Userid#lt;/cfoutputgt; 
nothing shows up? My website is dependent on the UserId to see certain pages so 
obviously it is not working for this 3rd person in my group. I'm stumped. Help, 
please./DIV
DIVnbsp;/DIV
DIVThanks/DIV
DIVnbsp;/DIV
DIVSal/DIVbr clear=allhrGet more from the Web.  FREE MSN Explorer download : 
a href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html

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

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

deleting session variables

[S R]

Hi,

I am using this code to delete my session variables when a user closes their 
browser:

cfif IsDefined("Cookie.CFID") AND IsDefined("Cookie.CFTOKEN")
cfset cfid_local = Cookie.CFID
cfset cftoken_local = Cookie.CFTOKEN
cfcookie name="CFID" value="#cfid_local#"
cfcookie name="CFTOKEN" value="#cftoken_local#"
/cfif

The only problem is that it also deletes my client variables upon closing 
the browser. Is there any way to just delete session variables and leave the 
client intact??

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

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

LOOP AND VARIABLE QUESTION

[S R]

I have this loop below pulling from a database. As you can see, the select 
part of the loop does exactly what I want it to. It dynamically creates lr1, 
lr2, lr3, lr4, lr5, etc. The problem I am now having is where the CFIF 
statement is. I need that to do exactly what the CFIF statement is telling 
it to do but it does not. Right now, each module automatically defaults to 
choice 1 because the #id# and/or #ThisVar# variable is not being fed to the 
CFIF statement. How can I accomplish this??

Sal

CFSTOREDPROC datasource="#application.Datasource#" dbname="UserPreferences" 
procedure="GetChoices"
cfprocresult name="GetChoices"
/CFSTOREDPROC

CFSTOREDPROC DATASOURCE="#application.datasource#" DBNAME="UserPreferences" 
PROCEDURE="sp_GetLRCount"
CFPROCRESULT NAME="GetLRCount"
/CFSTOREDPROC

CFSET LeftLoop = #GetLRCount.LRNumber#

CFLOOP INDEX="i" FROM="1" TO="#LeftLoop#"

CFSET numvar = i
CFSET ThisVar = "Client.lr#numvar#"

cfoutputselect name="lr#i#"/cfoutput
cfoutput query="GetChoices"


option value="#id#" cfif #id# is 
#ThisVar#SELECTED/CFIF#ChoiceName#/option
/cfoutput
/select

p

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

[S R]

That was easy. Thanks Bob


From: "Bob Silverberg" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: LOOP AND VARIABLE QUESTION
Date: Mon, 11 Dec 2000 17:17:15 -0500

If you want ThisVar to contain the value stored in Client.lr#numvar#, then 
I
think you need to do an Evaluate on it.  Otherwise ThisVar is going to be
equal to "Client.lr1".  Also (although this wouldn't be causing a problem)
you don't need those # signs inside your CFIF tag.

Bob

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: December 11, 2000 4:59 PM
To: CF-Talk
Subject: LOOP AND VARIABLE QUESTION


I have this loop below pulling from a database. As you can see, the 
select
part of the loop does exactly what I want it to. It dynamically creates 
lr1,
lr2, lr3, lr4, lr5, etc. The problem I am now having is where the CFIF
statement is. I need that to do exactly what the CFIF statement is 
telling
it to do but it does not. Right now, each module automatically defaults to
choice 1 because the #id# and/or #ThisVar# variable is not being fed to the
CFIF statement. How can I accomplish this??

Sal

CFSTOREDPROC datasource="#application.Datasource#" 
dbname="UserPreferences"
procedure="GetChoices"
cfprocresult name="GetChoices"
/CFSTOREDPROC

CFSTOREDPROC DATASOURCE="#application.datasource#" 
DBNAME="UserPreferences"
PROCEDURE="sp_GetLRCount"
CFPROCRESULT NAME="GetLRCount"
/CFSTOREDPROC

CFSET LeftLoop = #GetLRCount.LRNumber#

CFLOOP INDEX="i" FROM="1" TO="#LeftLoop#"

CFSET numvar = i
CFSET ThisVar = "Client.lr#numvar#"

cfoutputselect name="lr#i#"/cfoutput
cfoutput query="GetChoices"


option value="#id#" cfif #id# is
#ThisVar#SELECTED/CFIF#ChoiceName#/option
/cfoutput
/select

p

/CFLOOP

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

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

cfstored procedure problem

[S R]

Hi everyone,

I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5

This is my stored procedure in SQL:

@SAMAccountName varchar

AS

SELECT UserID FROM PasUsers
WHERE SAMAccountName = '@SAMAccountName'

Here is my CF Code:

CFLDAP NAME="GetUser" SERVER="LDAPSERVER.COM" ACTION="QUERY" 
ATTRIBUTES="SAMAccountName" SCOPE="subtree" 
FILTER="SAMAccountName=#cgi.auth_user#" START="" 
USERNAME="mydomain\sal.rosales" PASSWORD="password" PORT="" 
TIMEOUT="30"

CFSTOREDPROC DATASOURCE="#application.datasource#" DBNAME="userpreferences" 
PROCEDURE="GetUserID"
CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@SAMAccountName" 
VALUE="#GetUser.SAMAccountName#" TYPE="In"
CFPROCPARAM TYPE="Out" DBVARNAME="@UserID" VARIABLE="UserID" 
CFSQLTYPE="CF_SQL_INTEGER"
/CFSTOREDPROC

cfoutput#UserID#/cfoutput

I keep getting a 'Data Access Error Unknown data'

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

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

passing sets of variables

[S R]

Is there a way to pass a set of variables from page to page without passing 
them in the url and without setting session or client variables?

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

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

cf admin problems

[S R]

Hi,

I'm trying to add a SQL server 7.0 database as an OLE DB datasource to CF 
admin and the verification keeps failing. I followed the exact steps I did 
when I did this before. I added a user Login account in SQL server, then 
when I added this to SQL I made sure to go into the CFSettings and enter the 
same username and password that is in SQL Server. It's frustrating because I 
am basically trying to make this new CF admin setup exactly the same as my 
previous server because I had to export data from one server to another. Are 
there any suggestions as to what else I can check for? Has anyone ever 
encountered problems like this when exporting data via the GUI interface 
that SQL 7.0 offers? I'm just not sure what to look for anymore.

Thanks

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

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

CFLDAP question

[S R]

I'm trying to connect to an LDAP server and I keep getting an 'invalid 
credentials' error. Does this mean I am using the wrong username and 
password to authenticate?

SR
_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

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

CF and IIS

[S R]

Hi,

Does anyone know how to have CF query IIS in order to grab the login name of 
someone who has logged into a website, via IIS? The alternative for me would 
be to set up a webpage based log in screen that coldfusion controls and grab 
the info that way, but I am exploring the IIS option first.

Thank you

SR
_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

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

session variable expiring

[S R]

Hi,

I would like to clarify something. I have read that session variables are 
supposed to expire after a user's session is over. I would like my session 
variables to expire every time the user closes the their browser. Would this 
qualify as a user 'ending their session'? If so, how do I specify this when 
I set my session variables or are session variables automatically set to do 
this on their own? I tested it out by closing my browser and opening up my 
website again and it did not seem to work, it let me right in without asking 
me to login again.

Thanks

Sal
_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

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

session variable expiring

[S R]

Hi,

I would like to clarify something. I have read that session variables are 
supposed to expire after a user's session is over. I would like my session 
variables to expire every time the user closes the their browser. Would this 
qualify as a user 'ending their session'? If so, how do I specify this when 
I set my session variables or are session variables automatically set to do 
this on their own? I tested it out by closing my browser and opening up my 
website again and it did not seem to work, it let me right in without asking 
me to login again.

Thanks

Sal
_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

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

session variables question

[S R]

Hi,

I would like to clarify something. I have read that session variables are 
supposed to expire after a user's session is over. I would like my session 
variables to expire every time the user closes the their browser. Would this 
qualify as a user 'ending their session'? If so, how do I specify this when 
I set my session variables or are session variables automatically set to do 
this on their own? I tested it out by closing my browser and opening up my 
website again and it did not seem to work, it let me right in without asking 
me to login again.

Thanks

Sal
_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

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

RE: session variable expiring

[S R]

Thank you


From: ".elizabeth." [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: session variable expiring
Date: Mon, 27 Nov 2000 14:54:08 -0500

I had the same problem myself, and found the solution at
http://www.teamallaire.com/tutorials/index.cfm?fuseaction=displaytopicid=00
4.  Lots of other good tutorials, as well.

the code follows:

   cfif isDefined("COOKIE.cfid") AND isDefined("COOKIE.cftoken")
   cfset cfid_local = COOKIE.cfid
   cfset cftoken_local = COOKIE.cftoken
   cfcookie name = "CFID" value="#cfid_local#"
   cfcookie name = "CFTOKEN" value="#cftoken_local#"
   /cfif

If you put this snippet of code in your Application.cfm file, sessions
should expire when the user closes the browser.

-elizabeth

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 12:53 PM
To: CF-Talk
Subject: session variable expiring


Hi,

I would like to clarify something. I have read that session variables are
supposed to expire after a user's session is over. I would like my session
variables to expire every time the user closes the their browser. Would 
this
qualify as a user 'ending their session'? If so, how do I specify this when
I set my session variables or are session variables automatically set to do
this on their own? I tested it out by closing my browser and opening up my
website again and it did not seem to work, it let me right in without 
asking
me to login again.

Thanks

Sal

_
Get more from the Web.  FREE MSN Explorer download : 
http://explorer.msn.com

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

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

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

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

_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

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

import/export LDAP

[S R]

htmlDIVHi,/DIV
DIVnbsp;/DIV
DIVI am still learning how an LDAP work, unfortunately, as some of you may have 
experienced I am having problems communicating with my I.S. department. Anyway, I am 
thinking of proposing to my company to buy Netscape Enterprise Server(Iplanet) and I 
will set up the LDAP and administer it myself. How would I get the info from the 
existing LDAP into my LDAP? Is there some way they can give me a 'tab or comma' 
delimited file and I can import it into another Directory server? I'd like to know so 
I can propose this to them and not look foolish if it is not that easy./DIV
DIVnbsp;/DIV
DIVThanks/DIV
DIVnbsp;/DIV
DIVSR/DIVbr clear=allhrGet more from the Web.  FREE MSN Explorer download : a 
href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

MS Index Server vs. Verity

[S R]

Hi,

I had to demo how cold fusion works to my I.S. department last week and 
after showing them how 'verity' works they suggested I look into 'Index 
Server' as a 'better' alternative. Can I get some of your opinions as to the 
differences between the two and where I can get more info on 'Index Server'

Thanks

Sal
_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

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

Unknown data access error

[S R]

Hi,

I am trying to use cfstoredproc and I'm passing some variables to a stored 
procedure via cfprocparam. When I run this CF page which is a simple 
update statement in SQL I get an 'Unkown data access error'. My code looks 
fine to me, can you see anything?

My CF code:
CFSTOREDPROC datasource="#application.datasource#" dbname="UserPreferences" 
procedure="UpdateLayout"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr1" value="#lr1#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr2" value="#lr2#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr3" value="#lr3#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr4" value="#lr4#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr5" value="#lr5#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr6" value="#lr6#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@lr7" value="#lr7#" 
type="In"

CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@rr1" value="#rr1#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@rr2" value="#rr2#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@rr3" value="#rr3#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@rr4" value="#rr4#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@rr5" value="#rr5#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@rr6" value="#rr6#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@rr7" value="#rr7#" 
type="In"
CFPROCPARAM cfsqltype="CF_SQL_DATE" dbvarname="@LastUpdated" 
value="#Now()#" type="In"

CFPROCPARAM cfsqltype="CF_SQL_INTEGER" dbvarname="@UserID" value="1" 
type="In"
/CFSTOREDPROC

My SQL Stored Procedure:

CREATE PROCEDURE UpdateLayout

@lr1 int, @lr2 int, @lr3 int, @lr4 int, @lr5 int, @lr6 int, @lr7 int,
@rr1 int, @rr2 int, @rr3 int, @rr4 int, @rr5 int, @rr6 int, @rr7 int,
@LastUpdated datetime,
@UserID int
AS

UPDATE UserLayout SET lr1 = @lr1, lr2 = @lr2, lr3 = @lr3, lr4 = @lr4, lr5 = 
@lr5, lr6 = @lr6, lr7 = @lr7,
rr1 = @rr1, rr2 = @rr2, rr3 = @rr3, rr4 = @rr4, rr5 = @rr5, rr6 = @rr6, rr7 
= @rr7, LastUpdated = @LastUpdated
WHERE UserID = @UserID

_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

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

SQL advice please

[S R]

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

Thanks

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

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

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

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

How to grab login info from LDAP

[S R]

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

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

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

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

Re: How to grab login info from LDAP

[S R]

Thanks a lot!


From: "Michael Thomas" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: How to grab login info from LDAP
Date: Fri, 17 Nov 2000 19:55:25 GMT

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


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

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

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

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

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

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

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

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

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

RE: append variable to a variable??

[S R]

Thanks Everyone!!

Sal


From: "Andrew" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: append variable to a variable??
Date: Wed, 15 Nov 2000 22:40:23 -0500

Sal:

Sure there is. try this for instance:

cfset numvar = "2"
cfset "Edname#numvar#" = "test"

cfoutputEdname2 is #Edname2#/cfoutput

How's that?


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

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 15, 2000 7:56 PM
To: CF-Talk
Subject: append variable to a variable??


Is there anyway to do this?

I have six variables in my database they are called:

EdName1, EdName2, etc.

It would be awesome if I could set a variable that could dynamically change
the number of each variable for me so I don't have to hard code the
variable.

For example (I know this doesn't work but it will get my point across:

cfset numvar = "2"

#EdName#numvar## = EdName2

Thanks for your help

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

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



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]

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

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


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]

append variable to a variable??

[S R]

Is there anyway to do this?

I have six variables in my database they are called:

EdName1, EdName2, etc.

It would be awesome if I could set a variable that could dynamically change 
the number of each variable for me so I don't have to hard code the 
variable.

For example (I know this doesn't work but it will get my point across:

cfset numvar = "2"

#EdName#numvar## = EdName2

Thanks for your help

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

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


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]

OLE DB and CF

[S R]

HI,

I am trying to add an OLD DB datasource to CF Admin, but when I add it, the
datasource connection fails. I have never used OLE DB, I've only used ODBC.
I've been urged to use OLE DB for SQL Server 7.0 but I guess I don't know
how to do it. Does anyone have any ideas as to why this may be happening?
What is the difference between ODBC and OLE DB?

tHANKS

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

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


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: OLE DB and CF

[S R]

no, I'll try that. Thanks


From: "Adrian Cooper" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: OLE DB and CF
Date: Tue, 14 Nov 2000 22:47:37 -


- Original Message -----
From: "S R" [EMAIL PROTECTED]
Sent: Tuesday, November 14, 2000 9:52 PM


  I am trying to add an OLD DB datasource to CF Admin, but when I add it, 
the
  datasource connection fails. I have never used OLE DB, I've only used 
ODBC.
  I've been urged to use OLE DB for SQL Server 7.0 but I guess I don't 
know
  how to do it. Does anyone have any ideas as to why this may be 
happening?
  What is the difference between ODBC and OLE DB?

Have you tried creating a user for the SQL database, and including that 
user and
password in the CF settings for the OLEDB provider?

Adrian Cooper.



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]

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

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


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]