CF and Windows 2000 Website

[Tangorre, Michael T.]

Hi everyone.
I am trying to do the following (never done it before):

On one of our test servers we have Windows 2000 Server running IIS 5 and CF
5.
The default website is setup and I need to create a new one. Well the cfdocs
and cfide folders are inside the wwwroot folder which is the path to the
default website. How do I create a new site that will work.. Right now I
have a folder inside the wwwroot folder (default website) that is called
ABC and want to be able to execute Cf templates inside it but right now I
get a 404 error displayed by CF server.  Any ideas?
Do I need to remove the ABC folder and redefine thesite? Any suggestions
would be much appreciated.

Thanks,
Mike
__
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

CF JS Menus

[Tangorre, Michael T.]

Hello Everyone.

I have been playing with the IE DOM and NS DOM for the past two weeks, and
decided to ask if anyone knows of any good JS menu scripts that looks nice
and work in IE4+, NS4.08+?
I would appreciate any links or advice.

Mike
__
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

HTML / CF issue

[Tangorre, Michael T.]

Hi everyone.
This should be an easy fix but I have not run into this in a long time. I
have a table in which I put a border around it using a top row with a height
of 1 pixel and a bottom row of a 1 pixel and two side columns with a width
of  pixel.. Is there a way to get this to work in netscape 4+? It seems that
no matter what kind of content that fills the main cells, it pulls the
border wider than 1 pixel. It works fine in IE of course. Would it help to
put a layer inside the table cell?

Thanks,

Michael T. Tangorre

==
Alfred University
Webteam Manager 
AIM: CrazyFlash4
Phone: 607-426-9277
==
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Running code just one time

[Tangorre, Michael T.]

In your application.cfm file, set a session varibale (flag if you will),
then in your index.cfm using conditional logic, just output accordingly..

user logs in..application.cfm sets flag
index.cfm checks flag and outputs accordingly.
HTH

Mike


-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 20, 2002 7:07 AM
To: CF-Talk
Subject: Re: Running code just one time


Hi,

This is regarding a post from yesterday. Maybe I didn't explain it 
properly. I had mentioned a custom tag but for now
lets just forget about it.

I am running IIS on NT 4. All users have accounts on the system.  In IIS 
under the Default Web Site Properties I went into
the Directory Security tab and disabled the Anonymous Access and 
enabled the NT Windows Challenge/Response only.

Now when users try to access the web page they are prompted with a 
username/password Windows authentication dialog.

If the correct username/password are entered the user is redirected to my 
index.cfm file.

This is what I would like to do.

Within my index.cfm or application.cfm file I want to check if this is the 
first time that the index.cfm file is loaded. If so, do something otherwise 
do nothing.

Below is just an example...


index.cfm or application.cfm
--

- Check to see if this is the first time index.cfm file is loaded (at login 
time)

- If so dump some test
 pLogged in/p


   If index.cfm is loaded any other time do nothing


I'm not sure how to incorporate this?



+---
+ 

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+---
-+



__
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: Running code just one time

[Tangorre, Michael T.]

When they get logged in, set a flag in application.cfm, such as a session
session.beenHereBefore = 1, then in your index page check the value of the
variable and output accordingly.

HTH,
Mike

-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 20, 2002 7:07 AM
To: CF-Talk
Subject: Re: Running code just one time


Hi,

This is regarding a post from yesterday. Maybe I didn't explain it 
properly. I had mentioned a custom tag but for now
lets just forget about it.

I am running IIS on NT 4. All users have accounts on the system.  In IIS 
under the Default Web Site Properties I went into
the Directory Security tab and disabled the Anonymous Access and 
enabled the NT Windows Challenge/Response only.

Now when users try to access the web page they are prompted with a 
username/password Windows authentication dialog.

If the correct username/password are entered the user is redirected to my 
index.cfm file.

This is what I would like to do.

Within my index.cfm or application.cfm file I want to check if this is the 
first time that the index.cfm file is loaded. If so, do something otherwise 
do nothing.

Below is just an example...


index.cfm or application.cfm
--

- Check to see if this is the first time index.cfm file is loaded (at login 
time)

- If so dump some test
 pLogged in/p


   If index.cfm is loaded any other time do nothing


I'm not sure how to incorporate this?



+---
+ 

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+---
-+



__
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: Running code just one time

[Tangorre, Michael T.]

Expire the session varibale when the user logs out..if you have them log
out.
Im not clear on what you are trying to do here.. what is it that you are
outputting on the first page visit?


-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 20, 2002 7:35 AM
To: CF-Talk
Subject: RE: Running code just one time


OK...but won't this session variable always be 1 when the application.cfm 
is loaded again?
Do I have to set the variable to 2 once I output what I want for the 
first time.

I'm missing something here...

At 07:02 AM 3/20/2002 -0500, you wrote:
When they get logged in, set a flag in application.cfm, such as a 
session session.beenHereBefore = 1, then in your index page check the 
value of the variable and output accordingly.

HTH,
Mike

-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 7:07 AM
To: CF-Talk
Subject: Re: Running code just one time


Hi,

This is regarding a post from yesterday. Maybe I didn't explain it 
properly. I had mentioned a custom tag but for now lets just forget 
about it.

I am running IIS on NT 4. All users have accounts on the system.  In 
IIS under the Default Web Site Properties I went into the Directory 
Security tab and disabled the Anonymous Access and enabled the NT 
Windows Challenge/Response only.

Now when users try to access the web page they are prompted with a 
username/password Windows authentication dialog.

If the correct username/password are entered the user is redirected to 
my index.cfm file.

This is what I would like to do.

Within my index.cfm or application.cfm file I want to check if this is 
the first time that the index.cfm file is loaded. If so, do something 
otherwise do nothing.

Below is just an example...


index.cfm or application.cfm
--

- Check to see if this is the first time index.cfm file is loaded (at 
login
time)

 - If so dump some test
  pLogged in/p


If index.cfm is loaded any other time do nothing


I'm not sure how to incorporate this?



+--
+-
+

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+--
+-
-+





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

RE: HTML / CF issue

[Tangorre, Michael T.]

Scott..
Thanks for the info. Im not sure if this link would be any more useful to
you, but here it is...

http:149.84.162.227/xfuze/display/new.cfm

I have nested tables like no tomorrow  :-)
If you could take a look, id appreciate it... no content yet, the table are
empty except for the header.
Is there a web resource online with tid bits about the little annoyances of
NN?

mike


-Original Message-
From: Scott Van Vliet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 10:41 AM
To: CF-Talk
Subject: Re: HTML / CF issue


I have had simliar issues in NN, and here's what I found:

First, Netscape will not allow a nested table to have a background color if
its parent table has a backgroun color (or image for that matter).

Second, when drawing nested tables, NN will choke (and actually crash your
browser) if there is too much white space.

Here's what I have done to create this 1 pixel border with a spacer graphic
(and can be seen in use at http://www.h2owinterclassic.com/):

table width=300 border=0 cellpadding=0 cellspacing=0
tr valign=top
td height=1 colspan=3 valign=top bgcolor=#ccimg
src=images/spacer_clear.gif width=750 height=1/td
/tr
tr height=1 valign=top
td width=1 valign=top bgcolor=#ccimg
src=images/spacer_clear.gif width=1 height=1/td
td width=298 valign=top!--- Your Content Goes Here ---/td
td width=1 valign=top bgcolor=#ccimg
src=images/spacer_clear.gif width=1 height=1/td
/tr

tr valign=top
td height=1 colspan=3 valign=top bgcolor=#ccimg
src=images/spacer_clear.gif width=750 height=1/td
/tr
/table

FYI, here' show I have been nesting tables, and had great success in NN:

table border=0 cellpadding=0 cellspacing=0
tr
tdtable border=0 cellpadding=0 cellspacing=0
tr
td!--- Nest Away! ---/td
/tr
/table/td
/tr
/table

Hope this sheds some light ^_^

- Original Message -
From: Tangorre, Michael T. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, March 20, 2002 3:59 AM
Subject: HTML / CF issue


 Hi everyone.
 This should be an easy fix but I have not run into this in a long time. I
 have a table in which I put a border around it using a top row with a
height
 of 1 pixel and a bottom row of a 1 pixel and two side columns with a width
 of  pixel.. Is there a way to get this to work in netscape 4+? It seems
that
 no matter what kind of content that fills the main cells, it pulls the
 border wider than 1 pixel. It works fine in IE of course. Would it help
to
 put a layer inside the table cell?

 Thanks,

 Michael T. Tangorre

 ==
 Alfred University
 Webteam Manager
 AIM: CrazyFlash4
 Phone: 607-426-9277
 ==
 

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

RE: HTML / CF issue

[Tangorre, Michael T.]

Thanks Owen and everyone else who responded.
Owen I tried what you suggested and it worked great.. Thanks! One of those
HTML problems I haven't encountered before...

TA.

Mike


-Original Message-
From: Owen Munton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 12:10 PM
To: CF-Talk
Subject: RE: HTML / CF issue


Your problem is the width=100% in your td tag.  Your
table should look more like this:

table width=100% cellpadding=0
cellspacing=0 border=0 height=500
tr
td  width=1 bgcolor=33 img
src=http://149.84.162.227/xfuze/display/color_33.gif;
width=1/td
td  width=145NAV/td
td  width=1 bgcolor=33 img
src=http://149.84.162.227/xfuze/display/color_33.gif;
width=1/td
td  width=900CONTENT/td
td  width=1 bgcolor=33 img
src=http://149.84.162.227/xfuze/display/color_33.gif;
width=1/td
/tr
/table

Thanks,

Owen
--- Tangorre, Michael T. [EMAIL PROTECTED]
wrote:
 Scott..
 Thanks for the info. Im not sure if this link would
 be any more useful to
 you, but here it is...
 
 http:149.84.162.227/xfuze/display/new.cfm
 
 I have nested tables like no tomorrow  :-)
 If you could take a look, id appreciate it... no
 content yet, the table are
 empty except for the header.
 Is there a web resource online with tid bits about
 the little annoyances of
 NN?
 
 mike
 
 
 -Original Message-
 From: Scott Van Vliet
 [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 20, 2002 10:41 AM
 To: CF-Talk
 Subject: Re: HTML / CF issue
 
 
 I have had simliar issues in NN, and here's what I
 found:
 
 First, Netscape will not allow a nested table to
 have a background color if
 its parent table has a backgroun color (or image for
 that matter).
 
 Second, when drawing nested tables, NN will choke
 (and actually crash your
 browser) if there is too much white space.
 
 Here's what I have done to create this 1 pixel
 border with a spacer graphic
 (and can be seen in use at
 http://www.h2owinterclassic.com/):
 
 table width=300 border=0 cellpadding=0
 cellspacing=0
 tr valign=top
 td height=1 colspan=3 valign=top
 bgcolor=#ccimg
 src=images/spacer_clear.gif width=750
 height=1/td
 /tr
 tr height=1 valign=top
 td width=1 valign=top
 bgcolor=#ccimg
 src=images/spacer_clear.gif width=1
 height=1/td
 td width=298 valign=top!--- Your
 Content Goes Here ---/td
 td width=1 valign=top
 bgcolor=#ccimg
 src=images/spacer_clear.gif width=1
 height=1/td
 /tr
 
 tr valign=top
 td height=1 colspan=3 valign=top
 bgcolor=#ccimg
 src=images/spacer_clear.gif width=750
 height=1/td
 /tr
 /table
 
 FYI, here' show I have been nesting tables, and had
 great success in NN:
 
 table border=0 cellpadding=0 cellspacing=0
 tr
 tdtable border=0 cellpadding=0
 cellspacing=0
 tr
 td!--- Nest Away! ---/td
 /tr
 /table/td
 /tr
 /table
 
 Hope this sheds some light ^_^
 
 - Original Message -
 From: Tangorre, Michael T. [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, March 20, 2002 3:59 AM
 Subject: HTML / CF issue
 
 
  Hi everyone.
  This should be an easy fix but I have not run into
 this in a long time. I
  have a table in which I put a border around it
 using a top row with a
 height
  of 1 pixel and a bottom row of a 1 pixel and two
 side columns with a width
  of  pixel.. Is there a way to get this to work in
 netscape 4+? It seems
 that
  no matter what kind of content that fills the main
 cells, it pulls the
  border wider than 1 pixel. It works fine in IE
 of course. Would it help
 to
  put a layer inside the table cell?
 
  Thanks,
 
  Michael T. Tangorre
 
  ==
  Alfred University
  Webteam Manager
  AIM: CrazyFlash4
  Phone: 607-426-9277
  ==
  
 



__
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

CF Studio 5

[Tangorre, Michael T.]

Hey everyone.

Anyone have any problems running studio 5 on WinXP box with mapped network
drives? My system crashes big time. If I remove the mapped drives, it runs
fine... any ideas?

Mike
__
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

OT - bgimage

[Tangorre, Michael T.]

Sorry for the off topic post, this is 2 for the day... my apologies. You
guys are so quick with answers, it's hard to find this help elsewhere.
NS4.08 - 4.79 do not seem to support the BGIMAGE attribute other than in the
body tag. Has anyone gotten this attribute to work via style sheets?
I am tyring to get a BG IMAGE in a TD tag and it wont work, nor will it work
in the table.. IE renders everything fine of course..

any suggestions?

Mike
__
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

Search

[Tangorre, Michael T.]

What would the best way to approach the following:

I have a form field called keywords and would like to search for records
from the SQL 2K database from two columns EventTitle and EventDescription.
However, I need this to be case insensitive.. so that i I type mike or Mike
I will get the record if either mike or Mike is in either of the two columns
in the DB? Right now I am trying to use

form.keywords LIKE %EventTitle% and was thinking UCASE around the operands
would work.

Thansk for any input.

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

RE: Second Post CFSELECT Problems

[Tangorre, Michael T.]

Steve,

Set your cfselect up.. then just add the following between the opening and
closing tag.
option value=0/option

so, you'd have

cfselect...option value=0 selected/options/cfselect

substitute anything you want for 0.

Mike


-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 12:46 PM
To: CF-Talk
Subject: RE: Second Post CFSELECT Problems


Does anybody have any advice?

Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED] 



-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR) 
Sent: Monday, March 18, 2002 10:07 AM
To: CF-Talk
Subject: CFSELECT Problems


I have a CFSELECT statement and I want have the user click on and if they
change there mind be able to click off the value with out having to hit like
a clear or reset button. Is there anyway in CF 4.5 to use a value like
value=.

Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED] 



__
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

alternating rows

[Tangorre, Michael T.]

Does anyone remember the quick way to alternate row colors when using MOD on
a recorcount?

Mike
__
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: Advice and opinion on client who has a problem paying bills

[Tangorre, Michael T.]

Mark,

Lay down soem ground rules or services guidelines. Politely explain your
situation to her, and if she is not in favor of working together to make
things go more smoothly, let her go.. unless she is making you tons of
money, I doubt its worth the hassle. There are lots of people on the net who
need sites, just takes a little looking around.

I am a college senior and have been doing contract work on the side for
about 3 years now. I always write up an agreement for them to comply with in
terms of rates, changes, updates, modifications, etc... and when questions
arise I just point to that. Im sure it is not 100% legally binding but at
least expectations are out in the open.

Hope that helps.

Mike


-Original Message-
From: Mark Smeets [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 16, 2002 1:13 PM
To: CF-Talk
Subject: OT: Advice and opinion on client who has a problem paying bills


Hi All,

I realize this is off topic but I could use some advice from everyone on
this list.

I have a client that is very stingy when it comes to paying bills. I've
already had one incident with her and that resulted in her getting out of
paying the majority of the bill but this time I fear when she gets her next
invoice, I'll have more trouble with her.

The thing she likes to do is call me up and tell me there's a problem with
the site and of course since I'm just being the nice guy (the kiss of death
I know) I can just pull the site code up and see if I can find the problem.
Now the latest incident was a case of the links page not working correctly,
I told her it would take an hour to track down and fix and she put up quite
a fuss when I told her that she would be charged for this. (She tried to
argue her way out of paying) In the end I went ahead and fixed the problem
and I sent her a confirmation email before the work was started as well. She
never replied to that confirmation email even though I asked her too.

So now I'm wondering what are my options. I know I'm going to have trouble
collecting from her, I mean there's more to their next invoice than this
links page and she is well aware of my rates. I don't exactly have the funds
to take her to small claims court either.

The only option I have come up with is this. I can change the administrative
status on her account to Disabled instead of Enabled but I think I run
into a problem there because they already paid for the web site last year.
These are all new changes and problems. I figure if I go this route then the
BS will end and at least I will get my money. (She doesn't have FTP access)

Any ideas are most welcome, I'm not exactly in a position to just dump her
as client but I'm getting sick and tired of being taken for a ride.

--
Mark Smeets / stranger0 / ICQ: 1062196
[EMAIL PROTECTED]
http://www.prowerks.com/stranger

Life is a series of small victories - Gene Simmons



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
__
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: JS/CF Screen Resolution

[Tangorre, Michael T.]

nevermind. 
foudn soem JS to do it.

Thanks,
Mike


-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, March 16, 2002 11:16 PM
To: CF-Talk
Subject: JS/CF Screen Resolution


Is there a way to detect a site visitors screen resolution?


Michael T. Tangorre

==
Alfred University
Webteam Manager 
AIM: CrazyFlash4
Phone: 607-426-9277
==


__
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 / JS Issue

[Tangorre, Michael T.]

Hello all.  I am having a problem getting this menu stuff to work in JS.
The link below will show you the page with the error.
http://149.84.162.227/xfuze/display/test4.cfm

The actual CF code is below...

The source form the link above will show you the output from this chunk of
code.

SCRIPT LANGUAGE=JavaScript1.2 SRC=menu.js/SCRIPT
SCRIPT LANGUAGE=JavaScript1.2
!--
function onLoad() {

cfoutputwindow.#Trim(getMainCats.CategoryTitle)# = new
Menu();/cfoutput

cfoutput query=getMainCats group=CategoryID

cfset tempVar = #Trim(getMainCats.CategoryTitle)#

cfquery datasource=xfuze name=getSubCats
SELECT CategoryID, LnkCategoryID, CategoryTitle
FROM tbl_categories
WHERE LnkCategoryID = #getMainCats.CategoryID#
/cfquery

var #Trim(getMainCats.CategoryTitle)# = new Menu();
cfloop query=getSubCats
#Trim(tempVar)#.addMenuItem(#getSubCats.CategoryTitle#);
/cfloop
#Trim(getMainCats.CategoryTitle)#.writeMenus();

/cfoutput
}
//--
/SCRIPT

I am using the js file from developer.netscape.com
Anyone know why this wont work right?

Thanks,
Mike

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

[Tangorre, Michael T.]

I have been using hostmysite for almost a year now  (www.hostmysite.com)
They are very resonable and their tech support is awesome.. they have live
chat 24/7!!
I think one of their lowest plans is around $9/10 a month.

HTH,
Mike


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 1:05 PM
To: CF-Talk
Subject: CF_inexpensive_reliable_ISP


Does any have first hand expereince with a inexpensive 
and reilable CF hosting service.  It's for a non-profit 
organization called TributeofLife.org

D-


__
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: neo beta login problems

[Tangorre, Michael T.]

Me as well please.

[EMAIL PROTECTED]

I haven't received an email back from them in 2 weeks!

Mike


-Original Message-
From: Greg Saunders [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 15, 2002 11:48 AM
To: CF-Talk
Subject: neo beta login problems


I am having problems logging into the neo beta site and I'm not getting any 
response from the neo help mailing address.

Can someone from Macromedia contact me off-list?

Thanks,

Gregory M. Saunders, Ph.D.
Senior VP of Software Engineering
Cognitive Arts Corporation  (http://www.cognitivearts.com)
1840 Oak Avenue, 4th Floor
Evanston, IL 60201-5914


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

RE: textarea and cffile

[Tangorre, Michael T.]

better check out active edit.
:-)



-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, March 16, 2002 12:12 AM
To: CF-Talk
Subject: textarea and cffile


I would like to be able to have users in an intranet submit text for others
to see via formtextarea/form and then usecffile to create a file.

The problem comes when users want to cut-and-paste from articles or from
word docs (which, I'm told, they do). The resulting file doesn't have any of
the paragraph breaks.

I use wrap=physical in the textarea and #ParagraphFormat(Form.content)#

ParagraphFormat works well if people go back into the text and add paragraph
breaks. However this is not acceptable to the users.

Is there anything else to use besides HTMLCodeFormat, HTMLEditFormat and
ParagraphFormat?

TIA

P.S. Now, of course, I'm greedy. In addition to keeping paragraph breaks I
would love it if the formatting b could be kept too. hehehehe





---
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient.




__
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 CF Question

[Tangorre, Michael T.]

Hi Everyone.

Can someone help me out with the following problem.
I have a table in my SQL DB called categories.
In it there are 3 fields: CategoryID, LnkCategoryID, CategoryTitle
What I am trying to do is the following:

When LnkCategoryID = 0 that means that that record is a Main Category.
So in my table there are 3 main categories right now:

CategoryID = 1
LnkCategoryID = 0
CategoryTitle = Hardware 

CategoryID = 2
LnkCategoryID = 0
CategoryTitle = Software

CategoryID = 3
LnkCategoryID = 0
CategoryTitle = Software

Each Main Category can have subcategories and you can probably see that the
LnkCategoryID becomes the CategoryID from the main categories.

CategoryID = 4
LnkCategoryID = 1
CategoryTitle = Hard Drives

CategoryID = 5
LnkCategoryID = 1
CategoryTitle = CD Rom Drives

CategoryID = 6
LnkCategoryID = 1
CategoryTitle = Floppy Drives

etc...etc..

Well I am trying to output the Main Category with the lnked categories below
them such as:

Hardware
-Hard Drives
-CD Rom Drives
-Floppy Drives

Software
-Web Editors
-Graphics
-Operating Systems

etc..

How can I write the SQL Statement for this and use it with cfloop or cfquery
to get my desired results.

My apologies for the long post, I tried for awhile to get it on my own, I
thought I would ask now.

Thanks to anyone who can help. I am a novie SQL user/writer.


Michael T. Tangorre

==
Alfred University
Webteam Manager 
AIM: CrazyFlash4
Phone: 607-426-9277
==
__
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: SQL CF Question

[Tangorre, Michael T.]

John.
I tried what u suggested, but it just outputs the main Categories.

SELECT CategoryID, LnkCategoryID, CategoryTitle
FROM categories
WHERE LnkCategoryID = 0
GROUP BY CategoryID, LnkCategoryID, CategoryTitle

cfoutput query=name group=CategoryID
...

Am I issing anything?

Mike



-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 15, 2002 12:36 AM
To: CF-Talk
Subject: RE: SQL  CF Question


Try grouping

SELECT blah from blah GROUP BY CategoryID, LnkCategoryID, etc..

You'll need to put every column you call in the group by as well but the
first two should be those. Then CFOUTPUT that query group= CategoryID

HTH

J. 
 
John Wilker
Web Applications Consultant, and Author
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
www.red-omega.com
 
more people are killed by donkeys than by airplane crashes each year


-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 14, 2002 9:34 PM
To: CF-Talk
Subject: SQL  CF Question


Hi Everyone.

Can someone help me out with the following problem.
I have a table in my SQL DB called categories.
In it there are 3 fields: CategoryID, LnkCategoryID, CategoryTitle What I am
trying to do is the following:

When LnkCategoryID = 0 that means that that record is a Main Category. So in
my table there are 3 main categories right now:

CategoryID = 1
LnkCategoryID = 0
CategoryTitle = Hardware 

CategoryID = 2
LnkCategoryID = 0
CategoryTitle = Software

CategoryID = 3
LnkCategoryID = 0
CategoryTitle = Software

Each Main Category can have subcategories and you can probably see that the
LnkCategoryID becomes the CategoryID from the main categories.

CategoryID = 4
LnkCategoryID = 1
CategoryTitle = Hard Drives

CategoryID = 5
LnkCategoryID = 1
CategoryTitle = CD Rom Drives

CategoryID = 6
LnkCategoryID = 1
CategoryTitle = Floppy Drives

etc...etc..

Well I am trying to output the Main Category with the lnked categories below
them such as:

Hardware
-Hard Drives
-CD Rom Drives
-Floppy Drives

Software
-Web Editors
-Graphics
-Operating Systems

etc..

How can I write the SQL Statement for this and use it with cfloop or cfquery
to get my desired results.

My apologies for the long post, I tried for awhile to get it on my own, I
thought I would ask now.

Thanks to anyone who can help. I am a novie SQL user/writer.


Michael T. Tangorre

==
Alfred University
Webteam Manager 
AIM: CrazyFlash4
Phone: 607-426-9277
==


__
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: SQL CF Question

[Tangorre, Michael T.]

Paul,

That worked  :-)
Thanks!

I am just gonna keep trying some things out to make sure this is the most
efficient way to do it.

Mike


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 15, 2002 12:52 AM
To: CF-Talk
Subject: Re: SQL  CF Question


Try this out for size:

cfquery datasource=datasource name=getMainCats
 select CategoryID, LnkCategoryID, CategoryTitle
 from tablename
 where LnkCategoryID = 0
/cfquery

cfoutput query=getMainCats
 #getMainCats.CategoryTitle#
 br
 cfquery datasource=datasource name=getSubCats
  select CategoryID, LnkCategoryID, CategoryTitle
  from tablename
  where LnkCategoryID = #getMainCats.CategoryID#
 /cfquery
 cfloop query=getSubCats
 - #getSubCats.CategoryTitle#br
 /cfloop
/cfoutput

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder


- Original Message -
From: Tangorre, Michael T. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, March 14, 2002 11:34 PM
Subject: SQL  CF Question


 Hi Everyone.

 Can someone help me out with the following problem.
 I have a table in my SQL DB called categories.
 In it there are 3 fields: CategoryID, LnkCategoryID, CategoryTitle 
 What I am trying to do is the following:

 When LnkCategoryID = 0 that means that that record is a Main Category. 
 So in my table there are 3 main categories right now:

 CategoryID = 1
 LnkCategoryID = 0
 CategoryTitle = Hardware

 CategoryID = 2
 LnkCategoryID = 0
 CategoryTitle = Software

 CategoryID = 3
 LnkCategoryID = 0
 CategoryTitle = Software

 Each Main Category can have subcategories and you can probably see 
 that
the
 LnkCategoryID becomes the CategoryID from the main categories.

 CategoryID = 4
 LnkCategoryID = 1
 CategoryTitle = Hard Drives

 CategoryID = 5
 LnkCategoryID = 1
 CategoryTitle = CD Rom Drives

 CategoryID = 6
 LnkCategoryID = 1
 CategoryTitle = Floppy Drives

 etc...etc..

 Well I am trying to output the Main Category with the lnked categories
below
 them such as:

 Hardware
 -Hard Drives
 -CD Rom Drives
 -Floppy Drives

 Software
 -Web Editors
 -Graphics
 -Operating Systems

 etc..

 How can I write the SQL Statement for this and use it with cfloop or
cfquery
 to get my desired results.

 My apologies for the long post, I tried for awhile to get it on my 
 own, I thought I would ask now.

 Thanks to anyone who can help. I am a novie SQL user/writer.


 Michael T. Tangorre

 ==
 Alfred University
 Webteam Manager
 AIM: CrazyFlash4
 Phone: 607-426-9277
 ==
 

__
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

CF Server / IIS / SQL Server

[Tangorre, Michael T.]

Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works. 

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people will be using
in CF Apps?

Man I am just at a loss here trying to figure this stuff out.. Any links,
books, online trainings.. anything would be much appreciated. In addition,
if anyone can respond to get me started in learning this stuff so I can try
and get this all straightened out would be great.

Thanks,

Mike Tangorre

A.K.A. Senior AU Student Webteam Slave / mr fixit ... blah blah blah.
Gr  :-)


__
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: CF Server / IIS / SQL Server

[Tangorre, Michael T.]

When you say create an account on the domain, do you mean the server domain,
or our entire network domain?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:24 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


A lot depends on what you are trying to do.  How restrictive are your
security policies, how tightly do you want to lock down the server etc.  If
you want a simple approach, create a domain account with very specific
permissions on the web server (make sure an deny anything you don't want
exposed), and very specific permissions on the database server - then use it
as the service account for CF and IIS - and use trusted connections for your
ODBC connections.  That IS the convienience of it - one account controlling
all access. But be very sure that you know what you intend and do NOT intend
to expose as resources for that user. And don't give it admin rights or sa
rights.  If it needs dbo permissions, give it dbo rights on the individual
databases rather than blanket SA rights.

As far as installing to the local system account - that's ok IF you realize
that CF will have access to any local resource (and you can't deny the local
system account)... so as long as that is what you intend - fine.  You would
then need to implement standard SQL security - adding complexity - but not
too much.

Mark

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 7:48 AM
To: CF-Talk
Subject: CF Server / IIS / SQL Server


Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works.

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people will be using
in CF Apps?

Man I am just at a loss here trying to figure this stuff out.. Any links,
books, online trainings.. anything would be much appreciated. In addition,
if anyone can respond to get me started in learning this stuff so I can try
and get this all straightened out would be great.

Thanks,

Mike Tangorre

A.K.A. Senior AU Student Webteam Slave / mr fixit ... blah blah blah.
Gr  :-)




__
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: CF Server / IIS / SQL Server

[Tangorre, Michael T.]

Thanks Mark.

I am looking into getting some books to help me btter understand this
administration stuff.
Should make for some good reading over spring break. Do you recommend any
other books?

Thanks,

Mike


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:52 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


There is no such thing as the server domain - even though the login screen
leads you to believe there is - there is only a domain and a local
account (not the same as the local system account).  If you use a local
account, you will need to share permissions from one stand alone server to
another - which is adding rather than removing complexity.  The idea behind
a domain acount is to simplify the process.  Create an account and carefully
assign the resources you want it to have - then use it where you need to.
If you end up with too many users, you can create groups instead - also
useful.  But it appears a single user would suffice for what you have in
mind.

Mark

P.S. - I suggest the book Mastering Windows 2000 Server - Mark Minasi -
it's readable and may help you sort this out.



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 8:21 AM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


When you say create an account on the domain, do you mean the server domain,
or our entire network domain?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 1:24 PM
To: CF-Talk
Subject: RE: CF Server / IIS / SQL Server


A lot depends on what you are trying to do.  How restrictive are your
security policies, how tightly do you want to lock down the server etc.  If
you want a simple approach, create a domain account with very specific
permissions on the web server (make sure an deny anything you don't want
exposed), and very specific permissions on the database server - then use it
as the service account for CF and IIS - and use trusted connections for your
ODBC connections.  That IS the convienience of it - one account controlling
all access. But be very sure that you know what you intend and do NOT intend
to expose as resources for that user. And don't give it admin rights or sa
rights.  If it needs dbo permissions, give it dbo rights on the individual
databases rather than blanket SA rights.

As far as installing to the local system account - that's ok IF you realize
that CF will have access to any local resource (and you can't deny the local
system account)... so as long as that is what you intend - fine.  You would
then need to implement standard SQL security - adding complexity - but not
too much.

Mark

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 7:48 AM
To: CF-Talk
Subject: CF Server / IIS / SQL Server


Hello,

Ok, let me start by saying this is going to be a long email (my
apologies)...
I am at my wits end here with the admins on campus who can't seem to figure
anything out.

In terms of accounts and services, what is the best way to setup IIS, SQL
2K, and CF 5.0. I am
a novice when it comes to installing this stuff, however I am trying to
assist the admins here on campus.
Basically, the admins on campus are in a group on the NT domain called
admins or something to that nature.
One server has IIS and CF on it, and the other server has SQL 2K only. The
admins install stuff using their domain
admin acocunts... is this a good idea.. shouldn't all software be installed
using a local system account?

Another issue they (now trickleing down to web guys) have is ODBC
connections and setting them up. What is the best account to use
for this and what kind of permissions does that account need? We have tried
setting up ODBCs using all kinds of logins and passwords,
but instead of guessing I want to know why and how this all works.

Once IIS and CF are installed using the right acocunts (which I don't
believe they are now) and once SQL server is up and running un der the right
account
what is the best practice for database permissions in terms CF and SQL:
specifying a new user and pass for each database that people will be using
in CF Apps?

Man I am just at a loss here trying to figure this stuff out.. Any links,
books, online trainings.. anything would be much appreciated. In addition,
if anyone can respond to get me started in learning this stuff so I can try
and get this all straightened out would be great.

Thanks,

Mike Tangorre

A.K.A. Senior AU Student Webteam Slave / mr fixit ... blah blah blah.
Gr  :-)






__
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

CF and MySQL

[Tangorre, Michael T.]

Hello.

I am never used MySQL before but have been asked to do a project using CF
and MySQL. Does MySQL have in interface similar to SQL Server to use?  how
to you go about creating the DB.. do you have to use SQL statements to
generate the DB?
Can anyone offer a quick rundown of how MySQL works or perhaps point me to
some websites?

TIA,

Mike
__
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

CF and Active edit

[Tangorre, Michael T.]

Hello.

I was wondering if anyone used activeedit from www.cfdev.com .
I was thinking that it may work for my following issue:

I have alot of people on campus that want documents and little paragraphs
online, but they want to be able to edit and format them whenever they want.
The kicker is that they do not want anyone to do it but them and they also
do not know HTML or any WYSWYG editors. I thought maybe they could copy and
paste their information into a text area on a form, editing it with active
edit, then I could store that in a DB (SQL Server 2K) and then output it
from there.

I am not sure of a few things:

1. Could this be too much information to store in a DB?
2. Would it be better to write the formatted text area to a text file then
just include it?
3. Am I just way off base and this is not possible  :-)

Thanks for any input.

__
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

CF and Machine Names on Domain

[Tangorre, Michael T.]

Has anyone done the following:

Accessed their domain and got a list of machine names on their network?
Also, I want to know if it is possible to not only access the list of names,
but to add machine names, and remove all using CF.
I knwo this can be done in PERL using the win32 API.  Anyone have some
thoughts??

Thanks,
__
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

Cold Fusion and Networks

[Tangorre, Michael T.]

Sorry for the double post..I wasn't sure if the subject was descriptive
enough.  :-)

Has anyone done the following:

Accessed their domain and got a list of machine names on their network?
Also, I want to know if it is possible to not only access the list of names,
but to add machine names, and remove all using CF.
I knwo this can be done in PERL using the win32 API.  Anyone have some
thoughts??

__
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

CF Server 5 and SQL server 2K

[Tangorre, Michael T.]

Hello.

I am having some issues setting up an ODBC.
I have a a server with IIS and CF 5 on it and another server with SQL 2K on
it.
I am in the administrator section for CF 5 and am trying to setup the ODBC
but cannot get it to Verify.

Could someone please explain how the permissions and users work for this?
Should I create a user in SQL server
to connect with? Any help is much appreciated.

Mike
__
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: CF Server 5 and SQL server 2K

[Tangorre, Michael T.]

I tried using the SA account as well and that does not work either! When I
add a new user in SQL I can either use WINDOWS authentication or SQL, i dont
see the option for both.

???

Mike


-Original Message-
From: Plane, Nathaniel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:02 AM
To: CF-Talk
Subject: RE: CF Server 5 and SQL server 2K


Also make sure in SQL server that your user authentication is set to 
SQL
Server and Windows, otherwise you will need to give permissions in SQL
Server to the user ColdFusion uses to log on as.

Nat

-Original Message-
From: Rick Eidson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 10:49 AM
To: CF-Talk
Subject: RE: CF Server 5 and SQL server 2K


I would create an acount for Cold Fusion in SQL sever do not use the SA
account (Should be changed).

Rick

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 9:51 AM
To: CF-Talk
Subject: CF Server 5 and SQL server 2K


Hello.

I am having some issues setting up an ODBC.
I have a a server with IIS and CF 5 on it and another server with SQL 
2K on
it.
I am in the administrator section for CF 5 and am trying to setup the 
ODBC
but cannot get it to Verify.

Could someone please explain how the permissions and users work for 
this?
Should I create a user in SQL server
to connect with? Any help is much appreciated.

Mike



__
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

CF / SQL 2K / CONNX

[Tangorre, Michael T.]

Hello List.

I wanted to poll the list for some responses on the following issue.  I am
heading up a project here for the University in which we are building a Cold
Fusion application entitled Schedule of Courses. We need to get
information from the old VMS system and currently use CONNX, Access, and
some poorly written CF to run the current app.  Does anyone have any
experience using SQL 2K and CONNX together and then using CF to output the
data?

I suppose this more a SQL/CONNX post, but I am 22 and notice that most
people on this list are probably older than me and hope some might have
experience with CONNX, VMS and SQL (pulling data from the VMS via CONNX into
the SQL 2K DB).

Thanks again.

__
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

Possible CF related Error

[Tangorre, Michael T.]

Hello,

I just rebuilt my XP box and installed all my CF studio and server
and now when I log into my machine I am getting this error:

Redirection EXE Error

Does anyone knwo if this is CF related? I have the log file from the XP
event viewer but it does not mean much to me. If someone knows this is not
CF related, please email me off list at [EMAIL PROTECTED] or contact me on
AIM at: CrazyFlash4

Thanks All,

__
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: CF and ASP

[Tangorre, Michael T.]

Thanks Jeff.. I appreciate the willingneed to help.


-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 16, 2002 1:11 PM
To: CF-Talk
Subject: RE: CF and ASP


You can try the 15Seconds list, but beware... Make sure you've read through
the VBScript documentation and searched on MSDN/Technet to answer your
problems.  Most of the time they will reference a KB article and that's it.
They're not as friendly as we are here.

You can also ping me off-list.  I've done a significant amount of ASP
development and porting ASP to CF.

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 15, 2002 8:04 PM
To: CF-Talk
Subject: CF and ASP


Hello All,

I have a question a bit off topic.
Does anyone know of a list like this one but for ASP?
I need to ask a few questions there to help get this site converted to CF.

Thanks,
Mike


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4




__
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: Multiple sites...

[Tangorre, Michael T.]

Hi Les,

I do all my mapping stuff in the application.cfm file. That way, when you
move things over, you just change a few lines in the application.cfm file.
I set imagepath, DSN, homepath, and a few others... Makes things go real
smnooth when moving over.

Mike


-Original Message-
From: Les Buchanan [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 16, 2002 1:17 PM
To: CF-Talk
Subject: Multiple sites...


Hi,

I'm new on the list and to ColdFusion in general, so take it easy on me.

I would like to have two (or more) sites on my NT box, one for staging, and
one for production.  For example, I'd like to have a website
(stage.livingscriptures.com) that I do all my pre-production work in, and
then when I'm finished, simply copy everything over to a different
directory, that would be my production site (www.livingscriptures.com).

This is very simple to do with say, ASP, but I have found difficulty in
getting this to work with ColdFusion.  When you're trying to cfinclude
templates, it won't include from the proper directory, without creating
mappings in the ColdFusion administrator, and then using a variable to store
that mapping.

My co-worker introduced my to ColdFusion, and I think it's a GREAT product,
but the inability to do this has frustrated me.  Maybe I'm approaching this
the wrong way.  I'd really appreciate it if someone could help me with this.
Thanks!

---Les Buchanan
Newbie ColdFusion Developer

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

RE: CF and Mailing Lists

[Tangorre, Michael T.]

Use cffile to retrieve the email messages form the mail server?


-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 15, 2002 1:48 AM
To: CF-Talk
Subject: Re: CF and Mailing Lists


Even easier is to have separate email addresses for list signup, removal,
etc.  You can make the different addresses aliases and direct everything to
the same mailbox.  When you retrieve them you don't need to read the message
body itself.  All your info is in the headers (to: and from:).  If you use
something like CFPOP there's nothing to parse.  It's a bit more foolproof,
as well, for the inevitable user that can't spell 'remove'.

Jim

- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 14, 2002 11:25 PM
Subject: Re: CF and Mailing Lists


 Most mailing lists read only the first line to process commands. You 
 can get that by using ListFirst(postbody, chr(13))
 This will take the postbody and return the first line. From there, you
 can search the string for commands. The Regular Expression (RE) tags are
 rather good for this.


  Hello All,
 
  I am trying to figure out how to read an email (subject and body) 
  for certain commands, and base don those commands I want to subscibe 
  and unsubscribe people to an email list my client has going for a 
  small
 e-comm
  site. Any ideas.. I have never done this before.
 
  Thanks,
 
  Michael T. Tangorre
 
  ==
  Resident Assistant - Brick
  Web Applications Developer
  A.U. Webteam Slave  :-)
  AIM: CrazyFlash4
  ==
 
 
 

__
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

CF and ASP

[Tangorre, Michael T.]

Hello All,

I have a question a bit off topic.
Does anyone know of a list like this one but for ASP?
I need to ask a few questions there to help get this site converted to CF.

Thanks,
Mike


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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

CF and Mailing Lists

[Tangorre, Michael T.]

Hello All,

I am trying to figure out how to read an email (subject and body) for
certain commands, and base don those commands I want to subscibe and
unsubscribe people to an email list my client has going for a small e-comm
site. Any ideas.. I have never done this before.

Thanks,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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: Shopping cart demo

[Tangorre, Michael T.]

I just wrote a simple cart you are more than welcome to check out.
Email me off list if you want to check it out.

Mike


-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, January 13, 2002 7:17 PM
To: CF-Talk
Subject: Re: Shopping cart demo


Well what I am looking for is a enterprise level shopping cart. My 
company is going to have three different e-commerce sites and each one 
will be dramatically different from the other. We are trying to figure 
out how to structure the database portion to allow the differences. One 
site will be customizable computer, another CD music and another books. 
WE would prefer not to build a different back-end to accomodate each 
site, but I am beginning to wonder if that would be best.






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: Bruce Sorge [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, January 13, 2002 3:51 PM
Subject: Re: Shopping cart demo


 Webmonkey has one you can use for free. It is pretty basic, but it
works.
 - Original Message -
 From: Douglas Brown [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Sunday, January 13, 2002 6:04 PM
 Subject: Shopping cart demo
 
 
  I was wondering if someone knew of a shopping cart app done in CF
that
  is available for a trial download?
 
 
 
  Thanks
 
 
 
  There are two major products that come out of Berkeley: LSD and
[Unix]
  BSD. We don't believe this to be a coincidence.
 
 
 
  Doug Brown
  
 

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

CF and Zip Codes

[Tangorre, Michael T.]

Has anyone ever done this or know a good way to do it..
I need to calculate the distance between 2 zip codes using Cold Fusion.

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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: CF and Zip Codes

[Tangorre, Michael T.]

Basically what I am doing to clarify things is the following:
I wanna be able to search for stores in my database and get the stores
within x number of miles from the visitors enetered zip code..

Does this make more sense..sorry for the confusion... I pulled an all
nighter  :-)



-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, January 12, 2002 11:35 AM
To: CF-Talk
Subject: RE: CF and Zip Codes


Hey - Michael - I read your message wrong.  If all you need is the distance
between two zips you can have that tag for free.  It won't do the radius
calcs (all zips within x miles of a given zip).

Sorry for the confusion!

cf_need_coffee strength=strong style=black



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 12, 2002 11:14 AM
To: CF-Talk
Subject: CF and Zip Codes


Has anyone ever done this or know a good way to do it..
I need to calculate the distance between 2 zip codes using Cold Fusion.

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4




__
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

OT - Javascript and CF

[Tangorre, Michael T.]

Hi Everyone,
This is a bit off topic, but if anyone is still up I could use some
guideance.
I have a query that returns a value in minutes. What I need to do is setup a
counter that counts down
The minutes then sends a user to another page after so long...

Any ideas?

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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

TEST

[Tangorre, Michael T.]

TEST

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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

CF and Regular Expressions

[Tangorre, Michael T.]

Hi Everyone,

I am brand new to regular expressions and was wondering if anyone had any
good recoomendations for books to read dealing with regualr Expressions,
especially geared towards CF.

Thanks for any ideas,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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: VNC vs PC Anywhere

[Tangorre, Michael T.]

VNC is nice, we use it on most boxes at school since they don't give keys to
us students for the server room  :-)
We used to use PCAnywhere but that was shortlived.

Mike


-Original Message-
From: Ben Whalley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 12:15 PM
To: CF-Talk
Subject: OT: VNC vs PC Anywhere


Has anyone had any experience using VNC from ATT - it seems reasonably good
(and free) at first glance. Anything I should be aware of if we were to use
it on a production box?


__
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: cf include file

[Tangorre, Michael T.]

Im not sure I understand what you want to do!
cfif condition
cfinclude somefile.cfm
cfelseif condition
cfinclude somefile.cfm
cfelse
cfinclude somefile.cfm


-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 2:43 PM
To: CF-Talk
Subject: cf include file


I've looked around (Forta, Micah Brown, CFHub and others) and cannot find a
way to include a file that would be processed by the server. I would like to
include a list of holidays that I could use in more than one file.

ie. 
cfif holiday
do this
cfesle
do that
/cfif

cfinclude template doesn't work. Is there anything that does?

TIA





 
This message is for the named person's use only. It may contain
confidential, proprietary or legally 
privileged information. No confidentiality or privilege is waived or lost by
any mistransmission. If 
you receive this message in error, please immediately delete it and all
copies of it from your 
system, destroy any hard copies of it and notify the sender. You must not,
directly or indirectly, 
use, disclose, distribute, print, or copy any part of this message if you
are not the intended 
recipient. 




__
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: cfselect question

[Tangorre, Michael T.]

Put the option tag before the output query.. Then in the select tag, make
the option selected.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 2:49 PM
To: CF-Talk
Subject: cfselect question


Does anyone know of a way to display a default field when using cfselect 
and a query first? I've put an option tag between the cfselect and 
/cfselect tags and it displays it as the last entry.  I would like it 
to display first.

What I'm doing is using my states database to populate the select box, 
but I want it to default to Select State as the very first entry, but 
it's showing up last.

cfselect query=getStates name=stateid value=stateid 
display=name
   option value=0 selectedSelect State
 /cfselect

Sorry for such a simple post, but I'm fried and can't think of any way 
around putting it in the table itself.

Thanks,

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134


__
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: SOLVED: cfselect question

[Tangorre, Michael T.]

Almost xmas.. Lets have a US wide happy hour.  :-)
Maybe in NYC tomorrow night, I'll be driving there tomorrow morning from
Elmira NY!!


Mike  :-)


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 2:56 PM
To: CF-Talk
Subject: SOLVED: cfselect question


OMG - do I feel stupid.  

Thanks Michael.  I totally knew how to do it that way and my brain just 
locked up. Thanks for the nudge.  I need a beer.

Is it x-mas yet?  I need a break!

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  - Original Message - 
  From: Tangorre, Michael T. 
  To: CF-Talk 
  Sent: Wednesday, December 19, 2001 1:48 PM
  Subject: RE: cfselect question


  Put the option tag before the output query.. Then in the select tag, 
make
  the option selected.


  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, December 19, 2001 2:49 PM
  To: CF-Talk
  Subject: cfselect question


  Does anyone know of a way to display a default field when using 
cfselect 
  and a query first? I've put an option tag between the cfselect and 
  /cfselect tags and it displays it as the last entry.  I would like 
it 
  to display first.

  What I'm doing is using my states database to populate the select box, 

  but I want it to default to Select State as the very first entry, 
but 
  it's showing up last.

  cfselect query=getStates name=stateid value=stateid 
  display=name
 option value=0 selectedSelect State
   /cfselect

  Sorry for such a simple post, but I'm fried and can't think of any way 

  around putting it in the table itself.

  Thanks,

  Michael Corrigan
  Programmer
  Endora Digital Solutions 
  www.endoradigital.com
  630/942-5211 x-134


  

__
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

CF and Time

[Tangorre, Michael T.]

Hi everyone.

I am looking for the best way and data type (SQL) to store a employees
schedule.
I have a form in which they enter a start time and an end time. Should I
store these as Timestamps in SQL Server or use varchar...
And what about AM and PM?  Any ideas would be much appreciated.

Mike


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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: CF and Time

[Tangorre, Michael T.]

Why can a SQL server Db table only contain one field of type timestamp?
I am not al that familiar with DBs yet. :-(

Mike


-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 3:45 PM
To: CF-Talk
Subject: RE: CF and Time


use timestamps.  Timestamps are more versatile that varchars since you 
can
do math calculations with them.  Depending on your gui layout you may 
also
be better off storing a start time and a duration rather than a start 
and
end time.

Definitely use Timestamps - you'll thank yourself later when you write 
the
queries!

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+---+

...'If there must be trouble, let it be in my day, that my child may 
have
peace'...
- Thomas Paine, The American Crisis



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 12:35 PM
To: CF-Talk
Subject: CF and Time


Hi everyone.

I am looking for the best way and data type (SQL) to store a employees
schedule. I have a form in which they enter a start time and an end time.
Should 
I
store these as Timestamps in SQL Server or use varchar...
And what about AM and PM?  Any ideas would be much appreciated.

Mike


Michael T. Tangorre
==
Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4==



__
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: modify access databases via sql and cf

[Tangorre, Michael T.]

I think I have an asnwer for you. Let me email my buddy who did this in ASP.
Email me offlist.

Mike


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 4:03 PM
To: CF-Talk
Subject: Re: modify access databases via sql and cf


Erik Retz wrote:

 Hello,
 
 Anyone have a reference for administering access via sql?  We normally 
 use mysql and need to modify access db's the same way. We've build a 
 cf page that we can type sql into. One of the developers is having a 
 hard time finding all the syntax for drop, alter, etc.  Any 
 suggestions?


Access help files works for me. Sure it is a pain because it is 
overcomplete (as everything from MS), but the info is there.

It is that I haven't found out how to compact an Access database through 
ODBC, or I wouldn't need Access anymore. At all.

Jochem

__
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: CF and Time

[Tangorre, Michael T.]

H,
But what if I want to send in 4 different times that are all being stored in
the DB.. I am unable to use the datetime data type for all of the columns?


-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 4:22 PM
To: CF-Talk
Subject: Re: CF and Time


The timestamp datatype is an automatic timestamp for the record. That
doesn't  mean you cant have more than one timestamp though. You just have to
do it manually.

Create a column with a datetime datatype and set the default value to:
getDate()
Now when the record is created the default value will be a date/time stamp.
When you want to update the time stamp just set the value to getDate()
again.

jon
- Original Message -
From: Tangorre, Michael T. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 4:00 PM
Subject: RE: CF and Time


 Why can a SQL server Db table only contain one field of type 
 timestamp? I am not al that familiar with DBs yet. :-(

 Mike


 -Original Message-
 From: Bryan Love [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 19, 2001 3:45 PM
 To: CF-Talk
 Subject: RE: CF and Time


 use timestamps.  Timestamps are more versatile that varchars since you 
 can do math calculations with them.  Depending on your gui layout you 
 may also
 be better off storing a start time and a duration rather than a start
 and
 end time.

 Definitely use Timestamps - you'll thank yourself later when you write 
 the queries!

 +---+
 Bryan Love
   Macromedia Certified Professional
   Internet Application Developer
   Database Analyst
 Telecomunication Systems
 [EMAIL PROTECTED]
 +---+

 ...'If there must be trouble, let it be in my day, that my child may 
 have peace'...
 - Thomas Paine, The American Crisis



 -Original Message-
 From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 19, 2001 12:35 PM
 To: CF-Talk
 Subject: CF and Time


 Hi everyone.

 I am looking for the best way and data type (SQL) to store a employees 
 schedule. I have a form in which they enter a start time and an end 
 time. Should I
 store these as Timestamps in SQL Server or use varchar...
 And what about AM and PM?  Any ideas would be much appreciated.

 Mike


 Michael T. Tangorre
 ==
 Resident Assistant - Brick
 Web Applications Developer
 A.U. Webteam Slave  :-)
 AIM: CrazyFlash4==



 

__
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: CF and Time

[Tangorre, Michael T.]

Yeah I get an error when tyring to save the tale, it says timestamp can only
be used in one column. :-(

-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 4:28 PM
To: CF-Talk
Subject: RE: CF and Time


that's strange.  do you get an error when you try to assign more than one?

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 4:21 PM
To: CF-Talk
Subject: RE: CF and Time


H,
But what if I want to send in 4 different times that are all being stored in
the DB.. I am unable to use the datetime data type for all of the columns?


-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 4:22 PM
To: CF-Talk
Subject: Re: CF and Time


The timestamp datatype is an automatic timestamp for the record. That
doesn't  mean you cant have more than one timestamp though. You just have to
do it manually.

Create a column with a datetime datatype and set the default value to:
getDate()
Now when the record is created the default value will be a date/time stamp.
When you want to update the time stamp just set the value to getDate()
again.

jon
- Original Message -
From: Tangorre, Michael T. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 4:00 PM
Subject: RE: CF and Time


 Why can a SQL server Db table only contain one field of type
 timestamp? I am not al that familiar with DBs yet. :-(

 Mike


 -Original Message-
 From: Bryan Love [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 19, 2001 3:45 PM
 To: CF-Talk
 Subject: RE: CF and Time


 use timestamps.  Timestamps are more versatile that varchars since you

 can do math calculations with them.  Depending on your gui layout you
 may also
 be better off storing a start time and a duration rather than a start
 and
 end time.

 Definitely use Timestamps - you'll thank yourself later when you write

 the queries!

 +---+
 Bryan Love
   Macromedia Certified Professional
   Internet Application Developer
   Database Analyst
 Telecomunication Systems
 [EMAIL PROTECTED]
 +---+

 ...'If there must be trouble, let it be in my day, that my child may
 have peace'...
 - Thomas Paine, The American Crisis



 -Original Message-
 From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 19, 2001 12:35 PM
 To: CF-Talk
 Subject: CF and Time


 Hi everyone.

 I am looking for the best way and data type (SQL) to store a employees

 schedule. I have a form in which they enter a start time and an end
 time. Should I
 store these as Timestamps in SQL Server or use varchar...
 And what about AM and PM?  Any ideas would be much appreciated.

 Mike


 Michael T. Tangorre
 =
 Resident Assistant - Brick
 Web Applications Developer
 A.U. Webteam Slave  :-)
 AIM: CrazyFlash4



 



__
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: CF and Time

[Tangorre, Michael T.]

Gotcha!  :-)
Sorry to be a pain... Been a long day.

Thanks again,
Mike


-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 4:46 PM
To: CF-Talk
Subject: RE: CF and Time


right.  that's what we're saying.  use datetime as the data type on the
fields.  timestamp CAN only be used in one place.  datetime as many as you
like.

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 4:36 PM
To: CF-Talk
Subject: RE: CF and Time


Yeah I get an error when tyring to save the tale, it says timestamp can only
be used in one column. :-(

-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 4:28 PM
To: CF-Talk
Subject: RE: CF and Time


that's strange.  do you get an error when you try to assign more than one?

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 4:21 PM
To: CF-Talk
Subject: RE: CF and Time


H,
But what if I want to send in 4 different times that are all being stored in
the DB.. I am unable to use the datetime data type for all of the columns?


-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 4:22 PM
To: CF-Talk
Subject: Re: CF and Time


The timestamp datatype is an automatic timestamp for the record. That
doesn't  mean you cant have more than one timestamp though. You just have to
do it manually.

Create a column with a datetime datatype and set the default value to:
getDate()
Now when the record is created the default value will be a date/time stamp.
When you want to update the time stamp just set the value to getDate()
again.

jon
- Original Message -
From: Tangorre, Michael T. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 4:00 PM
Subject: RE: CF and Time


 Why can a SQL server Db table only contain one field of type 
 timestamp? I am not al that familiar with DBs yet. :-(

 Mike


 -Original Message-
 From: Bryan Love [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 19, 2001 3:45 PM
 To: CF-Talk
 Subject: RE: CF and Time


 use timestamps.  Timestamps are more versatile that varchars since you

 can do math calculations with them.  Depending on your gui layout you 
 may also be better off storing a start time and a duration rather than 
 a start and
 end time.

 Definitely use Timestamps - you'll thank yourself later when you write

 the queries!

 +---+
 Bryan Love
   Macromedia Certified Professional
   Internet Application Developer
   Database Analyst
 Telecomunication Systems
 [EMAIL PROTECTED]
 +---+

 ...'If there must be trouble, let it be in my day, that my child may 
 have peace'...
 - Thomas Paine, The American Crisis



 -Original Message-
 From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 19, 2001 12:35 PM
 To: CF-Talk
 Subject: CF and Time


 Hi everyone.

 I am looking for the best way and data type (SQL) to store a employees

 schedule. I have a form in which they enter a start time and an end 
 time. Should I store these as Timestamps in SQL Server or use 
 varchar... And what about AM and PM?  Any ideas would be much 
 appreciated.

 Mike


 Michael T. Tangorre
 

 Resident Assistant - Brick
 Web Applications Developer
 A.U. Webteam Slave  :-)
 AIM: CrazyFlash4==



 





__
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: Quick Question

[Tangorre, Michael T.]

800 x 600

-Original Message-
From: ehoma [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 4:44 PM
To: CF-Talk
Subject: Quick Question


I hope that you'll permit me to ask a non cf question here.  It is the only
list that I subscribe to and I know that all of the top web developers are
here.

I'm having a debate with my boss.  He likes to spend money and always has
the latest gadgets.  On his desk is a twenty-something inch flat panel
display and he sets the resolution as high as he can.  You could look at
most web sites on his screen using binoculars.

I'm still developing our sites using 800 X 600 and he tells me that I'm
living in the stone ages.

My question:  Which screen resolution is everyone designing for nowadays?

Thanks,

Eric Homa



__
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: SQL Licensing/User Question

[Tangorre, Michael T.]

I believe your web server is a user also... Not sure where the other is
coming from.


-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 5:32 PM
To: CF-Talk
Subject: SQL Licensing/User Question


Ok have a question.  We have a license that allows 4 people/logins to be
connected to the SQL server at one time. Via Enterprise manager or whatever.
Well it keeps telling us there are 4 connected yet there are only 2 of us
using it. Is there a place I can go to see who the current USERS are that
are connected to the sql server? Sorry it's something I normally don't
deal w/ so just don't know where to look. Kelly

__
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: SQL Licensing/User Question

[Tangorre, Michael T.]

I think yur right  :-)  not sure though... Im just guessing

-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 5:40 PM
To: CF-Talk
Subject: RE: SQL Licensing/User Question


could it be cold fusion?

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 5:33 PM
To: CF-Talk
Subject: RE: SQL Licensing/User Question


I believe your web server is a user also... Not sure where the other is
coming from.


-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 5:32 PM
To: CF-Talk
Subject: SQL Licensing/User Question


Ok have a question.  We have a license that allows 4 people/logins to be
connected to the SQL server at one time. Via Enterprise manager or whatever.
Well it keeps telling us there are 4 connected yet there are only 2 of us
using it. Is there a place I can go to see who the current USERS are that
are connected to the sql server? Sorry it's something I normally don't
deal w/ so just don't know where to look. Kelly



__
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

CF and Time AM and PM

[Tangorre, Michael T.]

Hello again,  :-)

I have a form in which a user enters a time, but I need to be able to
decipher between AM and PM.. Can they include this with their time?
What is the best way to do this, I will be storing this in a datetime field
in a SQL DB.

Thanks,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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: Quick Question

[Tangorre, Michael T.]

How did you grab that info?


-Original Message-
From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 5:46 PM
To: CF-Talk
Subject: Re: Quick Question


Yesterday's log from a commercial site I've done:

Resolution Page viewsPercent

800x600 243461.66%
1024x768 99025.08%
1152x864 159 4.02%
640x480  115  2.91%
800x55366  1.67%
1024x721  66  1.67%
Unreported37  0.93%
640x46121  0.53%
640x433 7   0.17%

Dave


- Original Message -
From: Dan Phillips [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 19, 2001 5:12 PM
Subject: RE: Quick Question


 Keep in mind too that out of the box, most computers are set to 
 800x600
and
 the average user does not know, or care about how to change his
resolution.

 Dan

 -Original Message-
 From: Tony Gruen [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 19, 2001 5:10 PM
 To: CF-Talk
 Subject: RE: Quick Question


 800 x 600. Your boss is just too hip. Find a buncha ways to complimen 
 t him on this and remind him regularly.

 T

 -Original Message-
 From: ehoma [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 19, 2001 1:44 PM
 To: CF-Talk
 Subject: Quick Question


 I hope that you'll permit me to ask a non cf question here.  It is th 
 e only list that I subscribe to and I know that all of the top web 
 developer s are
 here.

 I'm having a debate with my boss.  He likes to spend money and always  
 has the latest gadgets.  On his desk is a twenty-something inch flat 
 pane l
 display and he sets the resolution as high as he can.  You could look
  at
 most web sites on his screen using binoculars.

 I'm still developing our sites using 800 X 600 and he tells me that I 
 'm living in the stone ages.

 My question:  Which screen resolution is everyone designing for nowad 
 ays?

 Thanks,

 Eric Homa


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


 

__
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

IIF

[Tangorre, Michael T.]

Can someone help me with this.. I am knew at using IIF, but from my
understanding it whould work here:
cfinput type=Text name=ShowDate
value=iif(url.showdate,DateFormat(url.showdate,mm-dd-),DateFormat(now(
),mm-dd-))#

Thanks,
Mike


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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

Time and Date

[Tangorre, Michael T.]

Anyone have a suggestion for the following.
I have to form fields, date and time. I need to make an ODB date out of
these together. Any ideas.. 

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


__
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

SOLVED RE: Time and Date

[Tangorre, Michael T.]

Sorry.. I just figured it out.



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 19, 2001 9:50 PM
To: CF-Talk
Subject: Time and Date


Anyone have a suggestion for the following.
I have to form fields, date and time. I need to make an ODB date out of
these together. Any ideas.. 

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4



__
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: Allaire Partner upgrades...

[Tangorre, Michael T.]

We called MM form school (Alfred University) and inquired about our upgrade
to CF Studio 5, and they said its on its way.. Well, 1 month later we got a
CD but it was ULTRADEV!!  We are still trying to get studio 5, based on
the agreement we have with MM, our subscription entitles us to studio 5, and
we would like to see MM honor their agreements on this.


-Original Message-
From: Kevin Langevin [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 18, 2001 2:47 PM
To: CF-Talk
Subject: Allaire Partner upgrades...


ANybody know when Allaire Alliance Partners (before they expire) should be
recieving the upgrade to CF Studio5 and Homesite 5?  I had been told soon,
but got no firm date a while back.


Kevin Langevin
Web Guy In Charge
UsWebGuys
954-327-5780


-Original Message-
From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 2:43 PM
To: CF-Talk
Subject: Re: CFObject ADO  the decimal datatype


It could be done with CFQuery, but it would require you to loop over your
data and do an insert each time (thought this could be easily wrapped into a
single CFQuery or a stored procedure).

You can take advantage of Java's or ADO's capabilities now - simply put them
in a bean, COM object, or CFX custom tag.

Have you tried casting the column's datatype in your SQL?

---
Billy Cravens

- Original Message -
From: Jon Hall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 12:43 PM
Subject: Re: CFObject ADO  the decimal datatype


 GetRows() converts to a native array which is handled by the 
 interpreter,
in
 this case CF. It only converts to a VBScript array, if called by 
 VBScript. ADO is theorhetically platform independant.

 Basically I am trying to do an array update with ADO. This is easy 
 with
ASP
 or WSH, but  with cfquery, although nice  easy, is extremely limited 
 in
this
 manner. In my app I have one page (it's a grid...) that literally 
 might update hundreds of rows in a normalized table.

 I am hoping that in Neo, I will be able to build a component that 
 takes advantage of java.sql's batch updates, but until then...

 jon
 - Original Message -
 From: BILLY CRAVENS [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, December 18, 2001 12:06 PM
 Subject: Re: CFObject ADO  the decimal datatype


  GetRows() converts to a VBScript array; not a CF array.  If you want 
  to
 see
  the contents of the array, you'll need to write a wrapper object 
  that
 makes
  the ADO calls and gets the results.
 
  Out of curiosity, why are you using ADO instead of CFQuery?
 
  ---
  Billy Cravens
 
  - Original Message -
  From: Jon Hall [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Tuesday, December 18, 2001 10:15 AM
  Subject: CFObject ADO  the decimal datatype
 
 
   I am writing a script that uses ado to update a table, and in the
 process
  of
   debugging it I have run into a snag. My app doesn't need to get a
  recordset,
   but while I am writing this template it would be nice to be able 
   to
see
  the
   data I am working with.
   I have a decimal datatype field in my recordset with a scale of 2 
   (if
 that
   makes a difference...). When I use recordset.GetRows() to convert 
   the
 ADO
   recordset into an array, it bombs out with the error Error 
   attempting
 to
   convert between object and ColdFusion datatypes.
   If I remove the decimal column everything works fine. Is this just 
   a limitation of CFObject, or is their another way around this?
  
   RDBMS == SQL Server...
  
   jon




__
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

Forms and CF Code

[Tangorre, Michael T.]

Hi Everyone.

What steps can be taken to prevent users from submitting cfcode via a form?
Is there any tags out there that will protect?
Any ideas suggestions would be much appreciated.

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


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

RE: Forms and CF Code

[Tangorre, Michael T.]

Yes, that is correct


-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 18, 2001 5:54 PM
To: CF-Talk
Subject: Re: Forms and CF Code


Do you mean submit code in formfields?


On Tue, 18 Dec 2001, Tangorre, Michael T. wrote:

 Hi Everyone.
 
 What steps can be taken to prevent users from submitting cfcode via a 
 form? Is there any tags out there that will protect? Any ideas 
 suggestions would be much appreciated.
 
 Michael T. Tangorre
 
 
 Resident Assistant - Brick
 Web Applications Developer
 A.U. Webteam Slave  :-)
 AIM: CrazyFlash4
 
 
 

__
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: Allaire Partner upgrades...

[Tangorre, Michael T.]

Yeah no kidding, we hit the floor laughing

-Original Message-
From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 18, 2001 5:53 PM
To: CF-Talk
Subject: Re: Allaire Partner upgrades...


So UD is considered an upgrade to CF Studio?  hahahahahahaha

I thought it was the other way around.

---
Billy Cravens


- Original Message -
From: Tangorre, Michael T. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, December 18, 2001 4:25 PM
Subject: RE: Allaire Partner upgrades...


 We called MM form school (Alfred University) and inquired about our
upgrade
 to CF Studio 5, and they said its on its way.. Well, 1 month later we 
 got
a
 CD but it was ULTRADEV!!  We are still trying to get studio 5, 
 based
on
 the agreement we have with MM, our subscription entitles us to studio 
 5,
and
 we would like to see MM honor their agreements on this.


 -Original Message-
 From: Kevin Langevin [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, December 18, 2001 2:47 PM
 To: CF-Talk
 Subject: Allaire Partner upgrades...


 ANybody know when Allaire Alliance Partners (before they expire) 
 should be recieving the upgrade to CF Studio5 and Homesite 5?  I had 
 been told
soon,
 but got no firm date a while back.


 Kevin Langevin
 Web Guy In Charge
 UsWebGuys
 954-327-5780


 -Original Message-
 From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, December 18, 2001 2:43 PM
 To: CF-Talk
 Subject: Re: CFObject ADO  the decimal datatype


 It could be done with CFQuery, but it would require you to loop over 
 your data and do an insert each time (thought this could be easily 
 wrapped into
a
 single CFQuery or a stored procedure).

 You can take advantage of Java's or ADO's capabilities now - simply 
 put
them
 in a bean, COM object, or CFX custom tag.

 Have you tried casting the column's datatype in your SQL?

 ---
 Billy Cravens

 - Original Message -
 From: Jon Hall [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, December 18, 2001 12:43 PM
 Subject: Re: CFObject ADO  the decimal datatype


  GetRows() converts to a native array which is handled by the 
  interpreter,
 in
  this case CF. It only converts to a VBScript array, if called by 
  VBScript. ADO is theorhetically platform independant.
 
  Basically I am trying to do an array update with ADO. This is easy 
  with
 ASP
  or WSH, but  with cfquery, although nice  easy, is extremely limited 
  in
 this
  manner. In my app I have one page (it's a grid...) that literally 
  might update hundreds of rows in a normalized table.
 
  I am hoping that in Neo, I will be able to build a component that 
  takes advantage of java.sql's batch updates, but until then...
 
  jon
  - Original Message -
  From: BILLY CRAVENS [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Tuesday, December 18, 2001 12:06 PM
  Subject: Re: CFObject ADO  the decimal datatype
 
 
   GetRows() converts to a VBScript array; not a CF array.  If you 
   want to
  see
   the contents of the array, you'll need to write a wrapper object 
   that
  makes
   the ADO calls and gets the results.
  
   Out of curiosity, why are you using ADO instead of CFQuery?
  
   ---
   Billy Cravens
  
   - Original Message -
   From: Jon Hall [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Tuesday, December 18, 2001 10:15 AM
   Subject: CFObject ADO  the decimal datatype
  
  
I am writing a script that uses ado to update a table, and in 
the
  process
   of
debugging it I have run into a snag. My app doesn't need to get 
a
   recordset,
but while I am writing this template it would be nice to be able 
to
 see
   the
data I am working with.
I have a decimal datatype field in my recordset with a scale of 
2 (if
  that
makes a difference...). When I use recordset.GetRows() to 
convert the
  ADO
recordset into an array, it bombs out with the error Error 
attempting
  to
convert between object and ColdFusion datatypes.
If I remove the decimal column everything works fine. Is this 
just a limitation of CFObject, or is their another way around 
this?
   
RDBMS == SQL Server...
   
jon
 
 


 

__
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

Calendar Custom Tag

[Tangorre, Michael T.]

Hello everyone.

I searched the tag gallery and came up with a lot of calendar custom tags...
Could someone recommend a good one based upon my criteria for use listed
below?

I need a calendar tag that will allow a user to click on the day, and all I
need to do is pass that date either in the url or another manner.
I might look into building one myself, but thought maybe someone had some
experience with one that would fit the needs I have.

BTW, must be IE and Netscape compliant  :-)

Thanks for any feedback.


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4



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

CFMAIL

[Tangorre, Michael T.]

Hey everyone,

What kind of options are available for formatting non-html email...
I need to format the emails one module of this sytem I am working on sends
out.

Thanks for any input.


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


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

CF and JS

[Tangorre, Michael T.]

Is there anyway to detect if a browser has javascript enabled/disabled using
CF?

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


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

RE: CF and Access

[Tangorre, Michael T.]

Is the web data different fomr the data in the access DB.. In other words,
do you have a aseparate DB for the web app?

-Original Message-
From: Mookie Bear [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 11, 2001 12:32 PM
To: CF-Talk
Subject: CF and Access


hey guys, the client uses an Access application where they can, at the click

of a button, create mailing labels that pull off information from their 
volunteers table.  In fact, that whole Access app is a ufll blown Volunteer 
Management system.  Except it's very ugly and not as robust.

So i created a web version.  The problem is how to handle the mailing labels

part.  Is it possible to export a list of info, and have them import it into

that Access app and have it work with the labels?  Can someone tlel me how 
to approach this please

thanx!

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

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

[Tangorre, Michael T.]

Hey everyone,
Anyone using 2Checkout for e-com? If so, is there a custom tag out there to
interact with it without going to their website to make the purchase then
coming back to your site?


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


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

RDS

[Tangorre, Michael T.]

Is there anyway to have multiple users for RDS in CF 5 or is the password
set for studio the only password available to use for RDS?


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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

RDS

[Tangorre, Michael T.]

Hi everyone.
Our school wants me to work remotely over Christmas break for 5 weeks. I am
trying to setup RDS to be able to connect remotely.
I have a few questions: Is the RDS password the same as the studio and
server admin password?  If the machine I am connecting to has mapped drives
on an NT domain, will I be able to see those when I connect through RDS?

Thanks,
Mike


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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

CF and cached pages

[Tangorre, Michael T.]

I have a problem here, I cannot resolve it.
My issue is as follows:
I have someone login, if successful, I set a session variable.
When they log out, I delete that variable from the session structure and
send them back to the login page... However, if they hit back on the
broweser, they can get into the page they logged out from, which I don't
want to happen.

I tried using no cache in the meta tag, using cflocation when I send them to
the login page after loggin out.. I check for the variabel before the page
loads... Nothing works...

Any ideas?

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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 and cached pages

[Tangorre, Michael T.]

Well, once they logout, and click back they can view the page they logged
out from, however if they click a link on the admin page they are sent to
the login page because the check fails for the session. I don't want them to
be confused by the fact that tit looks like they are still logged in when
they click back..



-Original Message-
From: Joel Parramore [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 05, 2001 4:43 PM
To: CF-Talk
Subject: RE: CF and cached pages


From the page that the person logs out from: can they do anything from that
point on that appears as though they're still logged in (i.e., a bug in the
login/logout checking)?  Or, if they can't do anything further without
logging back in, do you just  want them not being able to back up to that
page at all?

You can try using CF to send no-cache and expires headers in your pages as
well as using meta tags if you want the latter.  If you're setting cookies
with session variables, you could use JavaScript in the page to look for a
valid current session cookie and redirect based on that.

It kinda depends on what you want to do...

Regards,
Joel Parramore


 -Original Message-
 From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 05, 2001 4:12 PM
 To: CF-Talk
 Subject: CF and cached pages


 I have a problem here, I cannot resolve it.
 My issue is as follows:
 I have someone login, if successful, I set a session variable. When 
 they log out, I delete that variable from the session structure and 
 send them back to the login page... However, if they hit back on the 
 broweser, they can get into the page they logged out from, which I 
 don't want to happen.

 I tried using no cache in the meta tag, using cflocation when I send 
 them to the login page after loggin out.. I check for the variabel 
 before the page loads... Nothing works...

 Any ideas?

 Michael T. Tangorre

 
 Resident Assistant - Brick
 Web Applications Developer
 A.U. Webteam Slave  :-)
 AIM: CrazyFlash4
 

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

CF and CGI

[Tangorre, Michael T.]

Hey everyone,
Is there a cgi variable that holds that page name that a user came from..
For instance... Say a user is on my site and on page 1. Is there a way to
tell me that when the user goes to page 2, that he came fomr page 1?


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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 and CGI-------- SOLVED

[Tangorre, Michael T.]

I found it.

Thanks,
Mike


-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 05, 2001 8:29 PM
To: CF-Talk
Subject: CF and CGI


Hey everyone,
Is there a cgi variable that holds that page name that a user came from..
For instance... Say a user is on my site and on page 1. Is there a way to
tell me that when the user goes to page 2, that he came fomr page 1?


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4 
~~
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

Capturing login and logout times

[Tangorre, Michael T.]

Hi everyone.
I posted a question about two weeks ago about an issue I was having with an
application in which I was attempting to charge members of a site by the
minute when they were logged in to a specific section. I can get a timestamp
when they log in no problem, and I can get one if the session expires, but I
am still looking for a solution to getting a timestamp if the browser closes
either voluntarily or involuntarily. I have been looking into other language
alternatives but think 90% of what I am looking for can be done using CF.
Can any of the advanced developers here offer a bit more insight on how I
should proceed. I have intermediate skills in CF, but I am beginning to
think that charge by the minute is not a good approach, although I am
working with a guy who will not budge.

Thanks in advance.

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Capturing login and logout times

[Tangorre, Michael T.]

Ben,
I could give this idea a try...
Do you have code for this?



-Original Message-
From: BEN MORRIS [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 04, 2001 9:59 AM
To: CF-Talk
Subject: Re: Capturing login and logout times


I guess it would depend on how specific of a time interval you need.  I 
have seen some sites that open up a js pop-up window after, say, 10 
minutes of inactivity on a single page.  This window could say Do you 
want to stay logged in? and would only pop up if they do nothing for 10 
minutes.  The request could be recorded, and if no request comes from that 
user after 10 minutes, you know they have left.

 Tangorre, Michael T. [EMAIL PROTECTED] 12/04/01 09:38AM 
Hi everyone.
I posted a question about two weeks ago about an issue I was having with 
an
application in which I was attempting to charge members of a site by the
minute when they were logged in to a specific section. I can get a 
timestamp
when they log in no problem, and I can get one if the session expires, but 
I
am still looking for a solution to getting a timestamp if the browser 
closes
either voluntarily or involuntarily. I have been looking into other 
language
alternatives but think 90% of what I am looking for can be done using CF.
Can any of the advanced developers here offer a bit more insight on how I
should proceed. I have intermediate skills in CF, but I am beginning to
think that charge by the minute is not a good approach, although I am
working with a guy who will not budge.

Thanks in advance.

Michael T. Tangorre
==
Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


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

Payment Processing

[Tangorre, Michael T.]

Hello.
I am new to the payment processing side of a website and wish to implement
some kind of system into a CF site I am developing.
I am looking at something that is seemless, I do not wish for the user to go
to a third party site and then return...
Does anyone have any suggestions? Their isnt much of a restriction on budget
here, I just need to find something that works well with CF.
What about merchant accounts? I assume I will need one, or my client will
need one correct?

Thanks,


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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 Cybercash

[Tangorre, Michael T.]

Does anyone know where to find the cybercash tag.. I tried the link from the
dev exchange and it takes me to verisign, but the link is dead.. Any ideas?

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF and Cybercash

[Tangorre, Michael T.]

Are there any other solutions out there that have custom tags written for
them?


-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, December 04, 2001 7:29 PM
To: CF-Talk
Subject: Re: CF and Cybercash


The last I heard Cybercash was dead as a doornail.  Verisign is only
supporting existing Cybercash customers that it acquired as part of its
mercy killing/buyout, and is only signing up new people to one of their
Payflow solutions.



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

Expriing a session

[Tangorre, Michael T.]

Hi everyone.
I am having no luck expiring a users session. Here is what I am attemnpting:
User logs in.. All is fine, a session variable is set to loggedin. When
the user clicks log out I call a template that sets the value of the
session var to loggedout and then redirect them to a new page. The problem
is that if they hit the browsers back button they can still get to the page
they were viewing when they logged on. I have tried using cflocation to send
them to the enw page and I even check for the value of the sesison var
before displaying the page that is protected via the login...

Any ideas?


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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 weird authentication

[Tangorre, Michael T.]

Hi everyone,

We have some weird things going on here with some university apps written in
CF. If using IE 6 we are prompted for a username and password and prompted
to install CFJava.cab!!! This just started happening outta the blue.. Any
ideas?  This doesn't happen in netscape.


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Why aren't there more CF programmers out there?

[Tangorre, Michael T.]

Frontpage?  Um, BARF!

:-)



-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 27, 2001 5:40 PM
To: CF-Talk
Subject: Why aren't there more CF programmers out there?


A higher up said If ColdFusion was so easy to learn why aren't there more
CF programmers out there?

So what do I tell him? 

How many CF Developers are there?
How many sites use CF?

Is there a Macromedia rep in the house?

He thinks FrontPage is the way to go

Let the games begin!


~~
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 SQL money data type

[Tangorre, Michael T.]

Is there any downsides to using the money data type in SQL server with Cold
Fusion?


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Announcement: CF/IIS/Windows security class

[Tangorre, Michael T.]

Where can kids deeply involved in technology go for some classes like
these.. Im sure you know, college kids are broke  :-)
My $6/hr wages for CF development for the University and fulltime credit
load doesn't allow for day trips to the south.  LOL

Mike


-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 5:42 PM
To: CF-Talk
Subject: RE: Announcement: CF/IIS/Windows security class


True.. Make it LA, which makes it good for everyone from San Diego to San
Francisco, pretty much.

Lee


 -Original Message-
 From: Matt Robertson [mailto:[EMAIL PROTECTED]]
 Sent: Monday, November 26, 2001 2:41 PM
 To: CF-Talk
 Subject: RE: Announcement: CF/IIS/Windows security class
 
 
  As Lee indicated, there may be demand for this course in many 
  places, and I wouldn't mind a bit of travel, myself.
 
 Me neither.  Come to CA!  I'd definitely want to take this
 course provided the travelling could be held down to a day's 
 drive or somesuch.
 
 Cheers,
 
 ---
 Matt Robertson[EMAIL PROTECTED]
 MSB Designs, Inc., www.mysecretbase.com
 ---
  
 

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

RE: CFMODULE and odd display behavior

[Tangorre, Michael T.]

Could you post the code?



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 7:02 PM
To: CF-Talk
Subject: CFMODULE and odd display behavior


Hey Folks,

OK I found this bug/glitch quite a while agoposted it to some 
lists...never really got a decent resolution.

So here we go again beacuse it's driving me up the wall ;-)

I got tired of relying on hosting tech support to put custom tags in 
place, so I use CFMODULE instead.

The Problem:

I have many tags that do many things, but we'll go with a simple 
example.  A tag to take a phone number and format it based on 
length...not rocket science.  Now when I call the tag (using cfmodule) 
to format a phone number (input string...process...display) I will get 
the phone number displaying twice (once in the table where it should be 
and again at the bottom of the page).  Now if I loop over a bunch of 
records and use the tag for each record all is well.  So my solution up 
till now when displaying a single record is to wrap the cfmodule call in 
a cfloop from 1 to 1 which makes the extra output vanish.

Well I'm starting to find other odd display things that cfmodule seems 
to be doing...so it's time to nail this puppy once and for all.

Any thoughts? experiences? comments?

TIA

Bryan Stevenson
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com



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

CF and credit card transactions

[Tangorre, Michael T.]

Hi Everyone,

I am looking for some insight for processing credit cards with Cold Fusion.
I am aware of a few custom tags, but what kind of variety is offered in
terms of companies and sites to do the processing. I am not really a fan of
going from my site, to another site then back to my site as you do with
2CheckOut..

Open for discussion and ideas.

Thanks,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF and credit card transactions

[Tangorre, Michael T.]

Yes,
I have used them with the guy I work with.. Probably on about 15 or so
sites... It not only works good, but it is nice for small volume commerce
sites.
I am trying to investigate others to see the pros and cons. Most of the
clients (upcoming) want seemless integration and do not wish their users to
leave the site then return and what not as seen with 2CheckOut. 

Mike


-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 8:35 PM
To: CF-Talk
Subject: Re: CF and credit card transactions


That 2CheckOut service actually looks pretty good for a very lite ecommerce
in-house project I have coming up.  Have you used these guys before?
Good/bad experience?

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: Tangorre, Michael T. [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 20:14:50 -0500

Hi Everyone,

I am looking for some insight for processing credit cards with Cold Fusion.
I am aware of a few custom tags, but what kind of variety is offered in
terms of companies and sites to do the processing. I am not really a fan of
going from my site, to another site then back to my site as you do with
2CheckOut..

Open for discussion and ideas.

Thanks,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


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

Datestamp

[Tangorre, Michael T.]

Is there a way to insert a datestamp into a SQL Server DB when the user
closers their browser or goes to a different site?
I am tyring to get a timestamp when the user leaves the site either by
closing the browser down, going to a new site, or a session timing out.

Is this possible?


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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: Browser detection w/CF

[Tangorre, Michael T.]

Hi Doug,

Try this..
Your Browser: 
cfif cgi.HTTP_USER_AGENT CONTAINS 'Mozilla/5.0'
NETSCAPE 6
cfelseif cgi.HTTP_USER_AGENT CONTAINS 'Mozilla/4.76'
NETSCAPE 4.76
cfelseif cgi.HTTP_USER_AGENT CONTAINS 'MSIE'
INTERNET EXPLORER
cfelse
WHO KNOWS!!!
/cfif

There is a cool custom tag out there as well.. Try here:
http://www.digital-jungle.com/cfuseragent/

Mike



-Original Message-
From: Douglas L. Brown [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 23, 2001 12:46 PM
To: CF-Talk
Subject: Browser detection w/CF


Does anyone know how I can check for browser type and version with CF? I 
really do not want to use JS to do this, although I am currently doing 
it that way. I would imagine a CGI car, but not sure how to do it.






CF_SIGNATURE
NAME=Douglas L. Brown
EMAIL=[EMAIL PROTECTED]
PHONE=714.538.6611
WEB=http://www.carnivorepc.com;


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

RE: Query Help

[Tangorre, Michael T.]

Try this,


SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered,
Tickets.TicketStatus, Tickets.Priority, Users.FirstName, Users.LastName,
Users.UserID, Techs.FirstName AS tfname, Techs.LastName AS tlname,
Types.TypeValue
FROM Tickets T, Users, Techs
INNER JOIN Types ON (T.TicketStatus = Types.TypeID)
WHERE T.UserID = Users.UserID

I am assuming TicketStauts and TypeID are the same datatype.

Mike






-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 10:37 AM
To: CF-Talk
Subject: Query Help


Ok.. why does it say this:
Error:
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'Tickets'
does not match with a table name or alias name used in the query.

Query:
SELECT Tickets.TicketID, Tickets.Problem, Tickets.DateEntered,
Tickets.TicketStatus, Tickets.Priority,
Users.FirstName, Users.LastName, Users.UserID,
Techs.FirstName AS tfname, Techs.LastName AS tlname,
Types.TypeValue
FROM Tickets T, Users, Techs
INNER JOIN Types ON 
TicketStatus = Types.TypeID
WHERE Tickets.UserID = Users.UserID

Thanks in advance...

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

RDS

[Tangorre, Michael T.]

Hi everyone.. Happy Thanksgiving.

This is going to sound very weird to a lot of people, but what exactly is
RDS and how does it work?
I know when I work on my desktop and work with files on different servers,
the drives are mapped so I just access the remote files via the mapped
drive. Also, I connect via FTP through CF studio. I guess I reall just do
not know what RDS is.

Mike

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

RE: RDS

[Tangorre, Michael T.]

Do you have to setup RDS?  If so, can you point me to some documentation to
do it?

Mike


-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 8:47 PM
To: CF-Talk
Subject: Re: RDS


Mike,

What makes it more useful than mapped network drives and FTP is that you
can view database connections through it... That's what the database tab
in Studio is for.

HTH,
K.

Bryan Love [EMAIL PROTECTED] wrote:
 It stands for Remote Development Server.  Basically you can set up a 
 machine to be a remote development server and then connect to it with 
 CF Studio. The whole thing is similar in concept to a VPN connection.

 -Original Message-
 From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, November 21, 2001 3:57 PM
 To: CF-Talk
 Subject: RDS
 
 
 Hi everyone.. Happy Thanksgiving.
 
 This is going to sound very weird to a lot of people, but what exactly

 is RDS and how does it work? I know when I work on my desktop and work

 with files on different servers, the drives are mapped so I just 
 access the remote files via the mapped drive. Also, I connect via FTP 
 through CF studio. I guess I reall just do not know what RDS is.

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

SQL server (OT)

[Tangorre, Michael T.]

Hi everyone.

I am in studio 5, and have connected to the server through RDS back at
school just fine and can see the files and the databases I am wokring with,
but when i try connecting through Enterprise Manager in SQL server I cannot
get connected...
Is there any known issues with connecting to a SQL 2K server from a WIN2K
Pro box? I have installed one of the updates for the client utilities here
localy on my machine.

I keep getting a timeout error.. I am logging in as sa and have confirmed
that i am using the right password.

Stuck...  :-(

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

RE: SQL server (OT)

[Tangorre, Michael T.]

SOLVED... i dunno, i restarted the server remotely and now it lets me
login.. odd.

LOL

Mike


-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 11:22 PM
To: CF-Talk
Subject: SQL server (OT)


Hi everyone.

I am in studio 5, and have connected to the server through RDS back at
school just fine and can see the files and the databases I am wokring with,
but when i try connecting through Enterprise Manager in SQL server I cannot
get connected...
Is there any known issues with connecting to a SQL 2K server from a WIN2K
Pro box? I have installed one of the updates for the client utilities here
localy on my machine.

I keep getting a timeout error.. I am logging in as sa and have confirmed
that i am using the right password.

Stuck...  :-(

Mike

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

RE: Datediff

[Tangorre, Michael T.]

Use the ABS funcitons, which will return the positive value.
The number is correct, 

Try this:  ABS(cfset
compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#)

Im not sure on the pounds, but play with it.

Lemme know if this helps.

Mike




-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 20, 2001 11:11 AM
To: CF-Talk
Subject: RE: Datediff


I am having problems comparing two dates.
My question is how to compare two dates that come from different years. For
example if I use the code below to compare a date of  12 Nov 2001 and 28 Feb
2002  to get the date difference I get -257 days. 

cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#
cfset comparison_list=#ListAppend(comparison_list,#compare#)#

I have tried other means of doing this but with no success.
Can somebody suggest the correct code to use to compare dates that overlap
years?

Thanks in advance,

Declan maher

-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2001 16:03
To: CF-Talk
Subject: RE: AUTO TABLE WIDTH


table width=xxx ???

EC

-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 10:51 AM
To: CF-Talk
Subject: Re: AUTO TABLE WIDTH


:) not enough coffee

A TABLE will now SHOW on the browser screen until  it reaches the /table
Because it has to read through the whole table to generate Widths and such
but on large tables that can slow down the display of tables by a few
seconds.

Now there is a CODE you put into the page or the table tag that lets the
Browser know this is a PREDEFINED size and to display it on the fly I forget
what that code is any idea?

Thanks all,


Bill Wheatley
Director of Development
Certified Advanced ColdFusion 5 Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645
- Original Message -
From: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 10:35 AM
Subject: Re: AUTO TABLE WIDTH


 On 11/20/01, William J Wheatley penned:
 Whats the Code to AUTOSET the table size of a table so that the
table
 does not have to get to the /table before the table can be
displayed?

 What? LOL
 --

 Bud Schneehagen - Tropical Web Creations

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



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

RE: Datediff

[Tangorre, Michael T.]

Sorry, I meant:

cfset compare =
ABS(#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#)

Mike



-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 20, 2001 11:16 AM
To: CF-Talk
Subject: RE: Datediff


Use the ABS funcitons, which will return the positive value. The number is
correct, 

Try this:  ABS(cfset
compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#)

Im not sure on the pounds, but play with it.

Lemme know if this helps.

Mike




-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 20, 2001 11:11 AM
To: CF-Talk
Subject: RE: Datediff


I am having problems comparing two dates.
My question is how to compare two dates that come from different years. For
example if I use the code below to compare a date of  12 Nov 2001 and 28 Feb
2002  to get the date difference I get -257 days. 

cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#
cfset comparison_list=#ListAppend(comparison_list,#compare#)#

I have tried other means of doing this but with no success.
Can somebody suggest the correct code to use to compare dates that overlap
years?

Thanks in advance,

Declan maher

-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2001 16:03
To: CF-Talk
Subject: RE: AUTO TABLE WIDTH


table width=xxx ???

EC

-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 10:51 AM
To: CF-Talk
Subject: Re: AUTO TABLE WIDTH


:) not enough coffee

A TABLE will now SHOW on the browser screen until  it reaches the /table
Because it has to read through the whole table to generate Widths and such
but on large tables that can slow down the display of tables by a few
seconds.

Now there is a CODE you put into the page or the table tag that lets the
Browser know this is a PREDEFINED size and to display it on the fly I forget
what that code is any idea?

Thanks all,


Bill Wheatley
Director of Development
Certified Advanced ColdFusion 5 Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645
- Original Message -
From: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 10:35 AM
Subject: Re: AUTO TABLE WIDTH


 On 11/20/01, William J Wheatley penned:
 Whats the Code to AUTOSET the table size of a table so that the
table
 does not have to get to the /table before the table can be
displayed?

 What? LOL
 --

 Bud Schneehagen - Tropical Web Creations

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




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

CF and Browser Detection

[Tangorre, Michael T.]

Is there a way in CF to detect the clients browser and version or is JS the
only way to go?


Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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