RE: BETA.ALLAIRE.COM

2001-09-13 Thread Mark Adams

Using COOL 3D this is easy.

-Mark

-- Original Message --
from: Shawn Grover [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Thu, 13 Sep 2001 15:44:06 -0600

I would guess, it's nothing more than an extruded B, with beveled edges,
then rotated in 3 dimensions.  

You would be able to use 3dMax, but you probably don't need to go to those
extremes.  Any application that can do the above features should be able to
recreate the effect.  (Photoshop, Corel, etc.)

Shawn Grover

-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 1:59 PM
To: CF-Talk
Subject: RE: BETA.ALLAIRE.COM


possibly or just a good artist using photoshop or illustrator it isnt that
intricate 
-Original Message-
From: BT [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 2:17 PM
To: CF-Talk
Subject: BETA.ALLAIRE.COM


Does anyone know what graphic program would be used to create the B like on
beta.allaire.com? 3D studio Max?






~~
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: compare 2 files

2001-07-24 Thread Mark Adams

Yes there is a great tool for that I use it all the time. Here you go!

DLSuperC

http://dlsuperc.com/

-Mark

-- Original Message --
from: Ali Awan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Mon, 23 Jul 2001 15:27:58 -0700

I was wondering if anyone knew of a way (other than using Visual Source
Safe) to compare two files and then create a new file that highlights the
differences between the two.  I'm trying to mimic the way Word shows
changes.  Like striking through a word that was deleted in a new version of
a file, and underlining a word that was inserted in a new version of the
file.  How would I go about doing that in Cold Fusion?  Has someone already
written a tool or customtag in Cold Fusion that would expedite this?

I know there is a bunch of software out there, but you have to manually
enter the filenames.  I am looking for something that I could run
automatically and feed in the filenames programmatically.

If anyone has any insight I'd appreciate it, thanks,

Ali Awan
Software Engineer
Dev-Tech, Inc.
http://www.dev-tech.com
(206) 956-0888


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



Re: SQL troubles

2001-05-02 Thread Mark Adams

Nevermind it was a laps of brain matter I was using access but now I'm using
SQL server and the value true or false is really 1or 0 in SQL. Jeez!

Thanks All!

;) Mark

- Original Message -
From: Mark Adams [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, May 02, 2001 2:53 PM
Subject: SQL troubles


 I'm pulling out my hair can anyone see whats up here?


 SELECT Assets.Course_ID, Assets.Module_ID, Assets.Lesson_ID,
Assets.Screen_ID, Assets.Form_ID, Assets.Asset_ID, Assets.Prose,
Assets.Reuse, Assets.Asset_Type, Screen.Reviewed FROM Assets INNER JOIN
Screen ON (Assets.Screen_ID = Screen.Screen_ID) AND (Assets.Lesson_ID =
Screen.Lesson_ID) AND (Assets.Module_ID = Screen.Module_ID) AND
(Assets.Course_ID = Screen.Course_ID) WHERE (((Screen.Reviewed)=True));

 Running really low on hair at this point! AHH!!!

 Thanks for any help! :)

 -Mark



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

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



SQL troubles

2001-05-02 Thread Mark Adams

I'm pulling out my hair can anyone see whats up here?


SELECT Assets.Course_ID, Assets.Module_ID, Assets.Lesson_ID, Assets.Screen_ID, 
Assets.Form_ID, Assets.Asset_ID, Assets.Prose, Assets.Reuse, Assets.Asset_Type, 
Screen.Reviewed FROM Assets INNER JOIN Screen ON (Assets.Screen_ID = Screen.Screen_ID) 
AND (Assets.Lesson_ID = Screen.Lesson_ID) AND (Assets.Module_ID = Screen.Module_ID) 
AND (Assets.Course_ID = Screen.Course_ID) WHERE (((Screen.Reviewed)=True));

Running really low on hair at this point! AHH!!!

Thanks for any help! :)

-Mark


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

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



modem speed detect?

2000-11-13 Thread Mark Adams

Does anyone have a way to check connect speed?

-Mark :o)




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



Re: CF and Flash problem

2000-11-01 Thread Mark Adams

That needs to be done in flash it doesn't matter if you are using CF, ASP,
XYZ, ETC.

--Mark :o)

- Original Message -
From: S R [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 01, 2000 11:42 AM
Subject: CF and Flash problem


 Hi,

 I have flash file that is a menu on several CF pages with the use of
 CFInclude. I have it so that if you click on one of the buttons it does
 two things "on release" which are it goes to another page and drops down
two
 more options under the button being clicked on. The problem I am having is
 that when the other page is called it calls the flash file again in its
 "normal state" which does not show the two options for the button that was
 clicked on.

 Is there any way to pass some kind of variable to flash from CF so that
when
 this other page is called it also goes to a particular frame in Flash so
 that the proper options are shown under the button clicked on?

 Thanks

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

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

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



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



access color selection box with CF?

2000-10-17 Thread Mark Adams

Has anyone accessed the windows color select box using CF?

-Mark

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



Re: access color selection box with CF?

2000-10-17 Thread Mark Adams

Actually, I am trying to access the windows color palette via browser. But,
I'm not sure how to call it up.


- Original Message -
From: Doug Powell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 17, 2000 12:03 PM
Subject: RE: access color selection box with CF?


 ?
 If your trying to make a select box have color you can use this

 cfselect name="whatever" size="1"
   cfoutput query="something"
 option value="##" cfif queryname.CurrentRow MOD
 2STYLE="background-color:blue;"/cfif
 #what you want#
 /option
   /cfoutput
 /cfselect

 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, October 17, 2000 1:54 PM
 To: CF-Talk
 Subject: access color selection box with CF?


 Has anyone accessed the windows color select box using CF?

 -Mark

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


 --

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


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



Re: Page hanging in netscape

2000-10-04 Thread Mark Adams

Hey all, I've got it! I use multi nested tables to layout pages, mainly for
border effects but I guess I have never nested tables this deep before. With
IE there is no limit and no noticeable rendering speed difference that I
found but with NN after 10 tables deep it slows tremendously add 12 or 15
and it locks it completely.

Another knock for NN


Hope this is helps someone.

-Mark :o)


- Original Message -
From: Mark Adams [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 03, 2000 6:23 PM
Subject: Re: Page hanging in netscape


 YA, its a mystery. I'll keep staring at this, until I fix it, or my brain
 melts. Whichever comes first. ;)

 -Mark :o)


 - Original Message -
 From: Peter Tilbrook [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, October 03, 2000 5:53 PM
 Subject: RE: Page hanging in netscape


  Hmmm. Happens on Navigator 4.08 too.
 
  Eventually the page appears however. Interesting in that it doesn't seem
 to
  hang on other pages.
 
  Nice looking site by the way.
 
  Peter Tilbrook
  Internet Applications Developer
  Aspect Computing Pty. Ltd.
  19-25 Moore Street
  Turner, ACT, 2612
  AUSTRALIA
 
  http://www.aspect.com.au
 
  Phone: (02) 6247 7677
  Fax: (02) 6249 1620
  Mobile: 0428 765 020
  ICQ: 666275
 
  ACT ColdFusion Users Group - http://203.37.24.198
 
 
  -Original Message-
  From: Mark Adams [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, 4 October 2000 9:01
  To: CF-Talk
  Cc: [EMAIL PROTECTED]
  Subject: Re: Page hanging in netscape
 
 
  That was my first guess to, but I am using a cfinclude for the header
for
  all the pages and the rest come up fine weird AY!
 
  - Original Message -
  From: Jon Tillman [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Tuesday, October 03, 2000 3:26 PM
  Subject: Re: Page hanging in netscape
 
 
   On Tue, 03 Oct 2000, Mark Adams spake thusly:
Ok GURU's
   
I can't seem to locate the problem can someone take a look at this
 page
  and
see why netscape hangs on it?
   
Thanks for any hints on this.
   
http://www.madronalinks.com/rates.cfm
  
   without looking at it my guess is malformed javascript or Java, does
it
  every
   time

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

 --

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


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



Re: NOT A MATH QUESTION, NumberFormat

2000-10-04 Thread Mark Adams

-4,000

Just guessing

-Mark :o)


- Original Message -
From: Chapman, Katrina [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 3:49 PM
Subject: NOT A MATH QUESTION, NumberFormat


 MM,

 Here's a question for y'all.  It's not math. It's cf.

 What will  cfoutput#NumberFormat("4,000")#/cfoutput give you?

 Try to answer before you test it.

 BB,
 --K

 ---
 Thank you,
 Katrina Chapman
 ColdFusion Web Developer
 System Development



 --

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


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



Re: NOT A MATH QUESTION, NumberFormat

2000-10-04 Thread Mark Adams

can i look now?


- Original Message -
From: Chapman, Katrina [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 3:59 PM
Subject: RE: NOT A MATH QUESTION, NumberFormat


 Nope.

  -Original Message-
  From: Mark Adams [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, October 04, 2000 3:44 PM
  To: CF-Talk
  Subject: Re: NOT A MATH QUESTION, NumberFormat
 
 
  -4,000
 
  Just guessing
 
  -Mark :o)
 
 
  - Original Message -
  From: Chapman, Katrina [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Wednesday, October 04, 2000 3:49 PM
  Subject: NOT A MATH QUESTION, NumberFormat
 
 
   MM,
  
   Here's a question for y'all.  It's not math. It's cf.
  
   What will  cfoutput#NumberFormat("4,000")#/cfoutput give you?
  
   Try to answer before you test it.
  
   BB,
   --K
  
   ---
   Thank you,
   Katrina Chapman
   ColdFusion Web Developer
   System Development
  
  
  
  
  --
  
  
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   To Unsubscribe visit
  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list
 s/cf_talk or
 send a message to [EMAIL PROTECTED] with 'unsubscribe' in
 the body.
 

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

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


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



Re: NOT A MATH QUESTION, NumberFormat

2000-10-04 Thread Mark Adams

Ok, I can't find reference to the " in NumberFormat what does that do?


- Original Message -
From: Mark Adams [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 3:55 PM
Subject: Re: NOT A MATH QUESTION, NumberFormat


 can i look now?


 - Original Message -
 From: Chapman, Katrina [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, October 04, 2000 3:59 PM
 Subject: RE: NOT A MATH QUESTION, NumberFormat


  Nope.
 
   -Original Message-
   From: Mark Adams [mailto:[EMAIL PROTECTED]]
   Sent: Wednesday, October 04, 2000 3:44 PM
   To: CF-Talk
   Subject: Re: NOT A MATH QUESTION, NumberFormat
  
  
   -4,000
  
   Just guessing
  
   -Mark :o)
  
  
   - Original Message -
   From: Chapman, Katrina [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Wednesday, October 04, 2000 3:49 PM
   Subject: NOT A MATH QUESTION, NumberFormat
  
  
MM,
   
Here's a question for y'all.  It's not math. It's cf.
   
What will  cfoutput#NumberFormat("4,000")#/cfoutput give you?
   
Try to answer before you test it.
   
BB,
--K
   
---
Thank you,
Katrina Chapman
ColdFusion Web Developer
System Development
   
   
   
   
   --
   
   
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
   http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list
  s/cf_talk or
  send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
  the body.
  
 

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

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

 --

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


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



Re: NOT A MATH QUESTION, NumberFormat

2000-10-04 Thread Mark Adams

Not yet!

- Original Message -
From: Chapman, Katrina [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 04, 2000 5:01 PM
Subject: RE: NOT A MATH QUESTION, NumberFormat


 MM,

 The " say's this is a string.

 It comes out at, at least on my machine, 36,617.  Any ideas why?

 BB,
 --K

  -Original Message-
  From: Mark Adams [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, October 04, 2000 4:32 PM
  To: CF-Talk
  Subject: Re: NOT A MATH QUESTION, NumberFormat
 
 
  Ok, I can't find reference to the " in NumberFormat what does that do?
 
 
  - Original Message -
  From: Mark Adams [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Wednesday, October 04, 2000 3:55 PM
  Subject: Re: NOT A MATH QUESTION, NumberFormat
 
 
   can i look now?
  
  
   - Original Message -
   From: Chapman, Katrina [EMAIL PROTECTED]
   To: CF-Talk [EMAIL PROTECTED]
   Sent: Wednesday, October 04, 2000 3:59 PM
   Subject: RE: NOT A MATH QUESTION, NumberFormat
  
  
Nope.
   
 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, October 04, 2000 3:44 PM
 To: CF-Talk
 Subject: Re: NOT A MATH QUESTION, NumberFormat


 -4,000

 Just guessing

 -Mark :o)


 - Original Message -
 From: Chapman, Katrina [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, October 04, 2000 3:49 PM
 Subject: NOT A MATH QUESTION, NumberFormat


  MM,
 
  Here's a question for y'all.  It's not math. It's cf.
 
  What will
  cfoutput#NumberFormat("4,000")#/cfoutput give you?
 
  Try to answer before you test it.
 
  BB,
  --K
 
  ---
  Thank you,
  Katrina Chapman
  ColdFusion Web Developer
  System Development
 
 
 
 
 --
 
 
  Archives:
  http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with
  'unsubscribe'
  in
the body.

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

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

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

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

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


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



Page hanging in netscape

2000-10-03 Thread Mark Adams

Ok GURU's

I can't seem to locate the problem can someone take a look at this page and
see why netscape hangs on it?

Thanks for any hints on this.

http://www.madronalinks.com/rates.cfm

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



Re: Page hanging in netscape

2000-10-03 Thread Mark Adams

That was my first guess to, but I am using a cfinclude for the header for
all the pages and the rest come up fine weird AY!

- Original Message -
From: Jon Tillman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 03, 2000 3:26 PM
Subject: Re: Page hanging in netscape


 On Tue, 03 Oct 2000, Mark Adams spake thusly:
  Ok GURU's
 
  I can't seem to locate the problem can someone take a look at this page
and
  see why netscape hangs on it?
 
  Thanks for any hints on this.
 
  http://www.madronalinks.com/rates.cfm

 without looking at it my guess is malformed javascript or Java, does it
every
 time

 

 --

  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
 --
 ***
  Jon Tillman
  LINUX USER: #141163
  ICQ: 4015362
  http://www.eruditum.org
  [EMAIL PROTECTED]
 ***
 Be alert, the world needs more lerts
 ***

 --

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


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



Re: Page hanging in netscape

2000-10-03 Thread Mark Adams

YA, its a mystery. I'll keep staring at this, until I fix it, or my brain
melts. Whichever comes first. ;)

-Mark :o)


- Original Message -
From: Peter Tilbrook [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 03, 2000 5:53 PM
Subject: RE: Page hanging in netscape


 Hmmm. Happens on Navigator 4.08 too.

 Eventually the page appears however. Interesting in that it doesn't seem
to
 hang on other pages.

 Nice looking site by the way.

 Peter Tilbrook
 Internet Applications Developer
 Aspect Computing Pty. Ltd.
 19-25 Moore Street
 Turner, ACT, 2612
 AUSTRALIA

 http://www.aspect.com.au

 Phone: (02) 6247 7677
 Fax: (02) 6249 1620
 Mobile: 0428 765 020
 ICQ: 666275

 ACT ColdFusion Users Group - http://203.37.24.198


 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, 4 October 2000 9:01
 To: CF-Talk
 Cc: [EMAIL PROTECTED]
 Subject: Re: Page hanging in netscape


 That was my first guess to, but I am using a cfinclude for the header for
 all the pages and the rest come up fine weird AY!

 - Original Message -
 From: Jon Tillman [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, October 03, 2000 3:26 PM
 Subject: Re: Page hanging in netscape


  On Tue, 03 Oct 2000, Mark Adams spake thusly:
   Ok GURU's
  
   I can't seem to locate the problem can someone take a look at this
page
 and
   see why netscape hangs on it?
  
   Thanks for any hints on this.
  
   http://www.madronalinks.com/rates.cfm
 
  without looking at it my guess is malformed javascript or Java, does it
 every
  time
 --

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


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



Re: A cfquery problem.

2000-09-29 Thread Mark Adams

Vincent

I don't know of any way you can do this in SQL but just a simple query and a
post works great.

This should work for you.  Adjust the cache time span to meet your needs.


-Mark :o)

Learning = (Asking + Teaching)


CFQUERY NAME="get_items" DATASOURCE="users"
CACHEDWITHIN="#CreateTimeSpan(0,0,5,0)#"
SELECT itemnum, user_id
FROM items
WHERE user_id = 12345
/CFQUERY

CFSET MaxRows = 10
CFPARAM NAME="Begin" DEFAULT="1"
CFPARAM NAME="itemnum" DEFAULT=""
CFPARAM NAME="user_id " DEFAULT=""

CFOUTPUT QUERY="get_items" STARTROW=#Begin# MAXROWS=#MaxRows#
#itemnum#br
/CFOUTPUT

CFSET NextTen = Begin + MaxRows

CFOUTPUT
CFIF NextTen LTE get_items.RecordCount
FORM ACTION="get_items.cfm"  METHOD="post"
INPUT TYPE="hidden" NAME="ItemNumber" VALUE="#itemnum#"
INPUT TYPE="hidden" NAME="Begin" VALUE="#NextTen#"
INPUT TYPE="submit" VALUE="Next #MaxRows#"
/FORM
/CFIF
/CFOUTPUT



- Original Message -
From: Vincent [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 10:36 PM
Subject: A cfquery problem.


 hi,
   I guess this is more of an SQL problem... what I wanted was
 for me to be able to select a group of rows in my cfquery statement.
 eg:
   cfquery name="get_items" datasource="users" maxrows = 10
   SELECT itemnum
FROM items
WHERE user_id = 12345
 /cfquery

 Now this will get me the top 10 rows, yes! Now what Im looking at is
 rows 10-20, then 20-30etc

 Is this possible. I know of one way, but its kinda a long cut.

 thanks
 regards,

 VIN

 --

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


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



Re: OMG!!!!!

2000-09-28 Thread Mark Adams

If you are looking for a string of characters why does it matter what
language they are?

Why can't you refer to a library of characters for each language?



-Mark :o)

CFSET Learning = (Asking + Teaching)


- Original Message -
From: Warrick, Mark [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 6:38 PM
Subject: RE: OMG!


 Sounds like someone is greatly misinformed.

 --
 Mark Warrick
 Phone: (714) 547-5386
 Efax.com Fax: (801) 730-7289
 Personal Email: [EMAIL PROTECTED]
 Personal URL: http://www.warrick.net
 Business Email: [EMAIL PROTECTED]
 Business URL: http://www.fusioneers.com
 ICQ: 346566
 --


  -Original Message-
  From: Jim Taylor [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 27, 2000 11:33 AM
  To: CF-Talk
  Subject: OMG!
 
 
  I just got off the phone with a company and they said that that
  were goning
  ro change from coldfusion to Asp beause coldfusion does not fit their
  international language requirments... Does anyone know what they were
  talking about.  I am talking that some major cold coldfusion fusion
houses
  here in phoenix are changing .and have put a coding freeze on for their
  company.. any one know about this
 
 
 
 
  Jim Taylor
  Web Centric Central
  http://130.13.69.228
 
  [EMAIL PROTECTED]
  Home Office: 480-496-0712
  Cell Phone : 602-576-0508
  Fax:: 208-474-8305
 
  --
  
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
 _talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

 --

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


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



Re: OMG!!!!!

2000-09-28 Thread Mark Adams

No kidding this is very freaky. We have 2 projects that I know of coming up
next month that will want multilingual access.

Please tell me that there is a way to do this?

-Mark :o)

Learning = (Asking + Teaching)




- Original Message -
From: avex [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 10:18 PM
Subject: Re: OMG!


 So how do i do japanese with cold fusion?
 I want to do a japanese site with cold fusion...

 has anyone done this before?

 this thread has scared me because i have done all the talk about doing
 japanese sites..but can i walk the walk?

 chad


 --

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


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



Re: OMG!!!!!

2000-09-28 Thread Mark Adams

Much better now thanks!

:o)

- Original Message -
From: Mike Nimer [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 28, 2000 9:54 PM
Subject: RE: OMG!


 It's tricky but it is possible, But if all you your doing is outputting
 Japanese text from a database, or inserting Japanese text from a form
 submission into a database it works fine. hard coded text in your HTML
also
 works fine.

 I'm not sure about the localization functions (lsDateFormat(), etc..). And
 some of the ReFind() type of functions are a little tricky. For instance
if
 you want to find a space in a text string, you will have to find the ascii
 code for the Japanese space, not the standard space that your keyboard
 types. And I'm not sure if Verity has support for Japanese languages as
 well.

 I would also recommend you run the Japanese versions of your software (CF,
 Studio, Database, OS) while you develop and when you go into production.

 But as long you understand what works and what doesn't before you start,
you
 can architect your site to avoid the few pieces that may not work as
 expected.

 As for the other Romanian languages, they all work just fine.

 Currently I'm in Japan helping a customer launch a Japanese Spectra site.
 And everything is going nice and smooth.

 HTH,
 ---Mike






 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Friday, September 29, 2000 12:20 AM
 To: CF-Talk
 Subject: Re: OMG!


 No kidding this is very freaky. We have 2 projects that I know of coming
up
 next month that will want multilingual access.

 Please tell me that there is a way to do this?

 -Mark :o)

 Learning = (Asking + Teaching)




 - Original Message -
 From: avex [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, September 28, 2000 10:18 PM
 Subject: Re: OMG!


  So how do i do japanese with cold fusion?
  I want to do a japanese site with cold fusion...
 
  has anyone done this before?
 
  this thread has scared me because i have done all the talk about doing
  japanese sites..but can i walk the walk?
 
  chad
 
 

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

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

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


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



Re: Access 2000 Databases with CF4.0

2000-09-26 Thread Mark Adams

I use Access 2000 with CF 4.0 never had any problems.
You do have Access 2000 installed on this server?

-Mark :o)



- Original Message -
From: Joshua Miller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 26, 2000 12:23 PM
Subject: Access 2000 Databases with CF4.0


 This may have been answered here before, but I'm not sure. I'll ask
anyway.

 Is there anyway to use Access 2000 Databases with CFServer 4.0??? I get an
 error every time I try and use Access 2000 dbs.

 THANKS!

 Joshua Miller
 Web Site Development
 Eagle Technologies Group
 Business Solutions for the Next Generation
 www.eagletgi.com
 [EMAIL PROTECTED]

 --

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


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



ASP?

2000-09-26 Thread Mark Adams

I know this is off subject but does anyone know how you would create one
variable from two variables, "VarA" and "VarB", and the text string
"SomeString" in ASP?

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



Re: What's wrong with this script?

2000-09-25 Thread Mark Adams

You don't need #languages.Abrev# just #Abrev#

-Mark :o)

- Original Message -
From: Michael Gagnon [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 25, 2000 5:07 PM
Subject: What's wrong with this script?


 Hi!

 I can't see what's wrong with this script.  I use the same thing
 on another page and it works fine.  It gives me the same answers
 on each row (the answers for the 1st row).

 CFOUTPUT query="table"
cfset ID = evaluate("#FORM.hid#ID")
tr
   td class="txt9yellow"#ID#/td

   cfloop query="languages"
   cfset txt = evaluate("table.#FORM.hlang##Languages.Abrev#")
   td class="txt9yellow"#txt#/td
   /cfloop
/tr
 /cfoutput




 Here's the one that works:

 CFOUTPUT query="sectors"
CFFORM method="POST" action="sectors_submit.cfm?lang=#URL.lang#"
input type="Hidden" name="ID" value="#FORM.ID#"

 cfloop query="languages"
 cfset Val = evaluate("sectors.Sector#languages.abrev#")
 tr
 td class="txt9blue"#Data.a3##Abrev#/td
 td class="txt9yellow"input type="Text" name="Sector#Abrev#"
 value="#Val#" size="50" maxlength="100"/td
 /tr
 /cfloop
 /CFFORM
 /cfoutput

 --

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


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



Re: Newbie CFIF for range of data

2000-09-24 Thread Mark Adams

Kelly,

Make sure you look at the reference for attributes and tags and study them,
rather than getting so caught up in examples.

Would look like this:
CFIF (data LT 1000) AND (data GTE 0)
CFSET words="small"
CFELSEIF (data LT 2000) AND (data GTE 1000)
CFSET words="medium"
CFELSE
CFSET words="large"
/CFIF

-Mark :o)


 How would you write a conditional statement like this:

 CFIF data is greater than 0 and less that 1000
 CFSET words="small"
 CFELSE IF data is greater than 1000 and less than 2000
 CFSET words="medium"
 CFELSE
 CFSET words="large"
 /CFIF


 All of the examples seem to only show an "IS" value. not  "IS" range.

 Kelly

 --

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


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



Re: Irregular/*NO* display of results in NN???

2000-09-23 Thread Mark Adams

You don't have a closing /table tag at the end of your page. NN does not
display broken html whereas IE will display broken html.

Hope this helps.

-Mark :o)


- Original Message -
From: Adrienne H. Cregar [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, September 22, 2000 1:02 PM
Subject: Irregular/*NO* display of results in NN???



 --73DDED20759AD2445CD2B442
 Content-Type: text/plain; charset=us-ascii
 Content-Transfer-Encoding: 7bit

 Hello all...I am perplexed...hope you can help. I have a basic form on
 my site that allows you to view retailers by state. If the state does
 not have any retailers, a sentence to that effect is displayed,
 otherwise, the retailers are listed with name, address, phone, etc...
 The problem I am having is that this works fine with AOL and IE, but in
 Netscape Communicator, if one of the states with no retailers is chosen,
 NOTHING is displayed - not even the header and other page assets. If one
 of the states with retailers is chosen, it displays just fine. When I
 look at the results page (for a state with no retailers), the HTML looks
 as it should. Why isn't this displaying for me The form page is
 http://www.yorkshirehouse.cc/preview/retailer.cfm . (A state with no
 retailers is Alaska or Hawaii) Any insight you could provide would be
 greatly appreciated.

 Thank you,
 A. Cregar
 [EMAIL PROTECTED]

 --73DDED20759AD2445CD2B442
 Content-Type: text/html; charset=us-ascii
 Content-Transfer-Encoding: 7bit

 HTML
 Hello all...I am perplexed...hope you can help. I have a basic form on
 my site that allows you to view retailers by state. If the state does not
 have any retailers, a sentence to that effect is displayed, otherwise,
 the retailers are listed with name, address, phone, etc... The problem
 I am having is that this works fine with AOL and IE, but in Netscape
Communicator,
 if one of the states with no retailers is chosen, NOTHING is displayed
 - not even the header and other page assets. If one of the states with
 retailers is chosen, it displays just fine. When I look at the results
 page (for a state with no retailers), the HTML looks as it should. Why
 isn't this displaying for me The form page is A
HREF="http://www.yorkshirehouse.cc/preview/retailer.cfm"http://www.yorkshir
ehouse.cc/preview/retailer.cfm
 ./A (A state with no retailers is Alaska or Hawaii) Any insight you
could
 provide would be greatly appreciated.

 PThank you,
 BRA. Cregar
 BR[EMAIL PROTECTED]/HTML

 --73DDED20759AD2445CD2B442--

 --

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


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



ip address?

2000-09-21 Thread Mark Adams

Hello all,

I'm sure someone out there knows about changing IP addresses we just changes
ours and it has been almost a week and its still is going to the old ip on
some servers. Why does this take so long, and is there a faster way to do
this?

- Mark :o)


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



# rule? [CF-Talk]

2000-09-20 Thread Mark Adams

What is the rule of thumb with the # ?

I see you don' t need it to refer to cfparam variables but you do use it for
cfset variables and table variables can someone clarify this?

Thanks, Mark :o)

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



Re: # rule? [CF-Talk]

2000-09-20 Thread Mark Adams

Thanks, Michael

That just what I was looking for.

-Mark :o)

- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 20, 2000 11:49 AM
Subject: Re: # rule? [CF-Talk]


 http://www.fusionauthority.com/alert/index.cfm?alertid=37#tech1
 http://www.fusionauthority.com/alert/index.cfm?alertid=8#Tech1



  What is the rule of thumb with the # ?
 
  I see you don' t need it to refer to cfparam variables but you do use it
 for
  cfset variables and table variables can someone clarify this?
 
  Thanks, Mark :o)


 --

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


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



Re: # rule? [CF-Talk]

2000-09-20 Thread Mark Adams

Oh Ok, That makes sense,

Thanks Duane!

-Mark :o)


- Original Message -
From: Duane Boudreau [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 20, 2000 11:53 AM
Subject: RE: # rule? [CF-Talk]


 Mark,

 I'm sure someone can explain it better than I (I assume it follows the by
 val/by ref logic in C/C++). The general rule of thumb I use is its quoted
or
 to be displayed it needs the #'s

 Here are samples of when to use it:

 CF_MyTag SomeAttrib="#MyVar#"
 cfoutput#MyVar#/cfoutput
 cfset MyVar1 = "The value of MyVar2 is #MyVar2#"

 Common misues include:
 cfset MyVar1 = #MyVar2# should be cfset MyVar1 = MyVar2
 CF_MyTag SomeAttrib=#MyVar# should be CF_MyTag SomeAttrib=MyVar


 Some exceptions to the rule (that I can think of off the top of my head)
 are:
 IsDefined() ex: IsDefined("form.somefield")
 IIf() ex: IIf(IsDefined("form.somefield"), "form.somefield", De("0"))


 HTH,
 Duane Boudreau
 eMPower Project Manager


  -Original Message-
  From: Mark Adams [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 20, 2000 2:08 PM
  To: [EMAIL PROTECTED]
  Subject: # rule? [CF-Talk]
 
 
  What is the rule of thumb with the # ?
 
  I see you don' t need it to refer to cfparam variables but you do
  use it for
  cfset variables and table variables can someone clarify this?
 
  Thanks, Mark :o)
 
  --
  
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf
  _talk or send a message to [EMAIL PROTECTED] with
  'unsubscribe' in the body.
 

 --

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


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



Re: [CF-Talk] OT: Subject lines

2000-09-20 Thread Mark Adams

I would imagine that there is a problem with some email readers or this
wouldn't be a topic but I use MS Outlook I have the filter set so if
[EMAIL PROTECTED] is in the "TO" or the "CC" it dumps in the cf-talk
folder. I have been on this list for about 3 weeks with no stray messages. I
am also on a number of other list and I have set them up the same way and
have had no problems with stray messages. So what is the big deal? jees!
LOL!

-Mark :o)

- Original Message -
From: Howie Hamlin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 20, 2000 2:25 PM
Subject: Re: [CF-Talk] OT: Subject lines


 Some list servers alter the "To" field of the email to make it consistent.
 If the "To:" field always said "[EMAIL PROTECTED]" then filtering
is
 a snap...

 Howie

 - Original Message -
 From: "Michael Dinowitz" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, September 20, 2000 5:25 PM
 Subject: Re: [CF-Talk] OT: Subject lines


  Would a special header line for filtering be better for people? My
results
  from this is that:
  prefix blocks the subject, obscures it and gets really monotonous
  suffix also makes the subject look bad and can be cut off in long
  subjects.
 
 
 
   I would have thought that visual filtering is a little
old-fashioned...
 ;)
  
   I can appreciate that people might want CF-Talk somewhere in the
subject
  for
   filtering purposes in case the email address changes, or it comes from
a
   different from address. However, isn't visual filtering just a wee bit
   pointless...?
  
   Robert Everland wrote:
   
Actual putting them at the end serves no purpose. I would rather not
  have
them at all instead of having them at the end. At the fron they are
beneficial becuase they are all near the same place. At the end I
have
  to
look for it, why bother.
   
Robert Everland III
Web Developer
Dixon Ticonderoga
   
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2000 12:53 AM
To: [EMAIL PROTECTED]
Subject: Re: [CF-Talk] OT: Subject lines
   
This was an experiment based on many emails that I've received
asking
  for
it. On the whole, I don't like it and others seem not to as well. In
 the
morning I'll switch over to having it at the end and see how that
 works.
This should satisfy everyone. As usual, comments are appreciated. :)
   
 My point exactly.

 Not to gripe, or anything, but couldn't it be put at the END where
 it
  has
less
 visual significance to the reader, but is still picked up by
 filters?

 How about it, M.D.?

 pan wrote:
 
  From: "David Cummins" [EMAIL PROTECTED]
 
   Hey guys,
  
   How come I'm receiving all this mail with subject lines
starting
  with
   "[CF-Talk]"? Is this a new list policy? Its just that it adds
  little
  information
   content, and means I'm less likely to see enough of the real
  subject
line to
  be
   bothered opening the email.
  
   I mean it would be OK if it was something informative like
[SQL]
  or
[CFLOCK]
  or
   something, but [CF-Talk]?
  
 
  Agreed - this particular tag '[CF-Talk]' makes the subject line
 hard
  to
read.
  The list of current subject headers take on a numbing sameness
 when
  ALL
  are prefixed witht the same tag.
 
  Pan
 
  n.b.  word to wise - if you try checking this new article
subject
  line
format
  with test messages (a time honored and sometimes necessary
cf-talk
'feature'
  :) ) there is a problem child out there in readerland who will
  accuse
you of
  rudeness and threaten to contact your "sys admin" - and she does
 it
  too

  with
  all of the same effectiveness as rope used for pushing a truck
 

   
 

 --

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

 --

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

   
  
 

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

 

Re: AOL and CF sites [CF-Talk]

2000-09-20 Thread Mark Adams

There are many access problems related with AOL its not just CF sites.
Can you describe your problem?

-Mark :o)


- Original Message -
From: Richard Kern [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 20, 2000 3:17 PM
Subject: AOL and CF sites [CF-Talk]


 All,

 I have an paid interactive site, all CF with database queries and tests,
it
 seems that people using AOL keep getting bumped off, and other glitches
seem
 to happen.  Enough that it causes extreme frustration.  Even then the
 customer won't move to a regular ISP.  The question is what is that AOL
does
 in their world that causes so much grief in mine?  Any insight?  Is this
 resolveable?  Are AOL and CF incompatible?

 Thanks,

 Richard
 --

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


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



Re: [CF-Talk] OT: Subject lines

2000-09-19 Thread Mark Adams

Yes, having it on the end is a good compromise. Outta site Outta mind!

-Mark :o)

- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 19, 2000 9:53 PM
Subject: Re: [CF-Talk] OT: Subject lines


 This was an experiment based on many emails that I've received asking for
 it. On the whole, I don't like it and others seem not to as well. In the
 morning I'll switch over to having it at the end and see how that works.
 This should satisfy everyone. As usual, comments are appreciated. :)


  My point exactly.
 
  Not to gripe, or anything, but couldn't it be put at the END where it
has
 less
  visual significance to the reader, but is still picked up by filters?
 
  How about it, M.D.?
 
  pan wrote:
  
   From: "David Cummins" [EMAIL PROTECTED]
  
Hey guys,
   
How come I'm receiving all this mail with subject lines starting
with
"[CF-Talk]"? Is this a new list policy? Its just that it adds little
   information
content, and means I'm less likely to see enough of the real subject
 line to
   be
bothered opening the email.
   
I mean it would be OK if it was something informative like [SQL] or
 [CFLOCK]
   or
something, but [CF-Talk]?
   
  
   Agreed - this particular tag '[CF-Talk]' makes the subject line hard
to
 read.
   The list of current subject headers take on a numbing sameness when
ALL
   are prefixed witht the same tag.
  
   Pan
  
   n.b.  word to wise - if you try checking this new article subject line
 format
   with test messages (a time honored and sometimes necessary cf-talk
 'feature'
   :) ) there is a problem child out there in readerland who will accuse
 you of
   rudeness and threaten to contact your "sys admin" - and she does it
too
 
   with
   all of the same effectiveness as rope used for pushing a truck
  
 

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

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

 --

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


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



[CF-Talk] HELP! format with loops and cfoutput

2000-09-18 Thread Mark Adams

=() HELP! I am pulling out my hair trying to get this to work! I have set
this up to display a daily schedule and it works great until I try to make
it look decent. Here's the scenario I have a daily schedule list with all of
the available times printed on the left these are pulled from the loop and
the matching daily events print next to them. Ok that works fine but as soon
as I add some visual formatting like images and tables I get repeated loops.
I know that cfoutput goes through the loop for every record but how do I
format around this and make this work and also make the code clean?


Any pointer in this is mucho appreciated!

Here is the code in its current state:

!---
DISPLAY TIME LOOP START
---
CFSET StartTime1 = CreateTime(06, 00, 00)
CFSET TeeTime = #DateAdd('N', -8, StartTime1)#

CFLOOP index="TodaysTeeTime" from="1" to="92"
  CFSET TeeTime = #DateAdd('N', 8, TeeTime)#

!---
DAILY SCHEDULE DISPLAY OUTPUT
---
CFOUTPUT QUERY="DailyEvents" GROUP="BookedTeeTime"
   CFIF #TimeFormat(TeeTime)# IS #TimeFormat(BookedTeeTime)#
  CFIF Players EQ 4
   CFSET CheckImage = "#checkIMG#"
   CFSET TableBookColor = "#fourclr#"
  CFELSEIF Players EQ 3
   CFSET CheckImage = "#checkIMG#"
   CFSET TableBookColor = "#threclr#"
  CFELSEIF Players EQ 2
   CFSET CheckImage = "#checkIMG#"
   CFSET TableBookColor = "#twoclr#"
  /CFIF
   CFSET Contact = "#ContactFirstName# #ContactLastName#"
   CFSET Player = "#Players#"
   CFSET EMail_1 = "a href=mailto:#EmailAddress#"
   CFSET EMail_2 = "#EmailAddress#"
   CFSET Ph = "#Phone#"
   CFSET BookColor = "White"
 CFELSE
   CFSET Contact = "--"
   CFSET Player = "--"
   CFSET EMail_1 = ''
   CFSET EMail_2 = "--"
   CFSET Ph = "--"
   CFSET CheckImage = "#blankIMG#"
   CFSET BookColor = "Black"
   CFSET TableBookColor = "White"
 /CFIF

 tr bgcolor="CFOUTPUT#TableBookColor#/CFOUTPUT"
  td bgcolor="White"IMG SRC="../images/CFOUTPUT#CheckImage#/CFOUTPUT"
WIDTH=10 HEIGHT=10 BORDER=0 ALT=""/td
  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="CFOUTPUT#BookColor#/CFOUTPUT"
   nbsp;CFOUTPUTB#TimeFormat(TeeTime, 'H:MM
TT')#/B/CFOUTPUTnbsp;/td

CFIF #DailyEvents.RecordCount# GT 0


  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="CFOUTPUT#BookColor#/CFOUTPUT"
  bnbsp;CFOUTPUT#Contact#/CFOUTPUTnbsp;/b/FONT/td

  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="CFOUTPUT#BookColor#/CFOUTPUT"
 bnbsp;CFOUTPUT#Player#/CFOUTPUTnbsp;/b/FONT/td

  td align="CENTER"nbsp;CFOUTPUT
   #Email_1#/CFOUTPUTFONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="CFOUTPUT#BookColor#/CFOUTPUT"
 bCFOUTPUT#Email_2#/CFOUTPUT/b/font/anbsp;/td

  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="CFOUTPUT#BookColor#/CFOUTPUT"
   bnbsp;CFOUTPUT#Ph#/CFOUTPUTnbsp;/b/font/td

/CFIF

/CFOUTPUT
!---
PRINT THIS IF NOTHING IS SCHEDULED
 ---
  CFIF #DailyEvents.RecordCount# EQ 0
  tr
  td bgcolor="White"IMG SRC="../images/CFOUTPUT#blankIMG#/CFOUTPUT"
WIDTH=10 HEIGHT=10 BORDER=0 ALT=""/td
  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="00"
   nbsp;CFOUTPUTB#TimeFormat(TeeTime, 'h:mm
tt')#/B/CFOUTPUTnbsp;/td
  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="00"--/FONT/td
  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="00"--/FONT/td
  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="00"--/FONT/td
  td align="CENTER"FONT FACE="Arial, Helvetica, san-serif" size=-2
COLOR="00"--/FONT/td
  /CFIF
  /tr
 /CFLOOP
!---
DISPLAY TIME LOOP END
---


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



Re: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox)

2000-09-18 Thread Mark Adams

fusebox.org
read read read :o)

-Mark

- Original Message -
From: Rich [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 18, 2000 11:45 AM
Subject: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox)



 I want to learn Fusebox from the beginning.  Where to start??


 -Original Message-
 From: Gregory Harris [mailto:[EMAIL PROTECTED]]
 Sent: Monday, September 18, 2000 12:33 PM
 To: [EMAIL PROTECTED]
 Subject: Ben Forta, I call on thee (was: What is Fusebox)


 Ben, my challenge to thou art:

 Develop a book in ColdFusion (either 4.5 or the upcoming 5 release) that
is
 entirely re-written using fusebox examples (or at least a similair
 technique).  Let's start off the beginners as the awesome developers that
 they have the potential to be!

 Imagine what could happen to some of the developers who learned fusebox
from
 the beginning?  I picture ColdFusion having taken off a lot better than it
 did, with more professional developers available.  Code easier to
understand
 everywhere.  In short, Programming Utopia!!!  Well, I may exaggerate
 somewhat, but you get the idea...

 Gregory Harris
 Los Angeles Information Technology Agency (ITA)
 [EMAIL PROTECTED]


  [EMAIL PROTECTED] 09/18 9:15 AM 
 I'm training 5 people (all long time friends) on how to use ColdFusion.
And
 I'm training them in the Fusebox style so that as they're going through
the
 CFWACK book and the Allaire self-paced tutorial CD, they'll constantly ask
 "Well WHY did they do it that way?" instead of simply accepting everything
 everyone has told them thus far at face value and accepting it as a
 standard.

 --
 Mark Warrick
 Phone: (714) 547-5386
 Efax.com Fax: (801) 730-7289
 Personal Email: [EMAIL PROTECTED]
 Personal URL: http://www.warrick.net
 Business Email: [EMAIL PROTECTED]
 Business URL: http://www.fusioneers.com
 ICQ: 346566
 --


  -Original Message-
  From: W Luke [mailto:[EMAIL PROTECTED]]
  Sent: Monday, September 18, 2000 5:39 AM
  To: [EMAIL PROTECTED]
  Subject: Re: Ok, What is Fusebox?
 
 
  Sounds extremely interesting, and a very good idea. I've been coding in
CF
  for 3 weeks or so, done a couple of relatively simple projects; would
you
  say Fusebox is something I *must* start to look at and incorporate into
my
  code now, or should I wait until I have a little more experience?
 
  Will
 
 
  - Original Message -
  From: "Reynolds, Adam" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Monday, September 18, 2000 1:24 PM
  Subject: RE: Ok, What is Fusebox?
 
 
   In fusebox, every page on your site is delivered to you via a case
  statement
   embedded in the index.cfm.
  
   Header and footer information is usually maintained by the index.cfm
  through
   calls to header and footer files and any specific
  action/display logic is
   included with a rigid (ish) file naming standard that enables
developors
  to
   identify types of file (display, query, actions).
  
   Each file has a standard header (called a fusedoc). Due to the use of
a
   custom tag cf_formurl2attributes in the index.cfm all files
  work through
   the use of the attribute scoped variables.  You do not use URL or FORM
   variables in any code.
  
   In effect this simplifies the maintenance because each file lists it's
   required and optional attribute parameters, any included files and the
   required 'Fuseactions' (which define exit conditions for a logic
  template).
  
   There is also a trick which enables you to make all attributes
  look like a
   directory structure...which is wonderful for submitting to
  search engines
   (as an example see www.greatgames.co.uk ...still working on this.)
  
   So in summary it enables a developer to focus on the functonality he
is
   attempting to deliver by clearly defining his interfaces and exit
  conditions
   without worrying about display issues.
  
   Any maintenance of a site can usually be easily instigated because it
is
   simple to follow calling hierachies, and any problems/general
  modifications
   can be easily added.
  
   Adam
  
  
--
From: W Luke[SMTP:[EMAIL PROTECTED]]
Sent: 18 September 2000 13:08
To: [EMAIL PROTECTED]
Subject: Re: Ok, What is Fusebox?
   
What exactly do you mean by "maintainable"?
   
Will
- Original Message -
From: "Reynolds, Adam" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 18, 2000 12:15 PM
Subject: RE: Ok, What is Fusebox?
   
   
 Yup,
 Fusebox really is a great leap forward in Web site development. It
  makes
for
 extremely maintainable code...just make sure you add those
  headers to
EVERY
 file!

    

  --
  From: Mark Adams[SMTP:[EMAIL PROTECTED]]
  Sent: 16 September 2000 02:49
  To: [EMAIL PROTECTED

Re: [CF-Talk] good examples and code of a simple drop down list populated from query?

2000-09-18 Thread Mark Adams

You have a space between #getarea# in your second call (#get area# )

- Mark :o)


- Original Message -
From: Jeff Fongemie [EMAIL PROTECTED]
To: Cf-Talk [EMAIL PROTECTED]
Sent: Monday, September 18, 2000 7:09 PM
Subject: [CF-Talk] good examples and code of a simple drop down list
populated from query?



 Hey everyone,

 I'm trying to populate a dropdown list box with the results of a simple
 query.

 I get an error with this:

 FORM ACTION="data2.cfm" METHOD="Post"
  CFOUTPUToption value="#getarea#"#get area#/option /CFOUTPUT
 /select

   /p/form

 Help!??

 Jeff F


 --

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


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



Re: Photo Database App

2000-09-15 Thread Mark Adams

I am not aware of one but I'm sure there's one around.

If not that wouldn't be to difficult to write. Let me know if you can't find
one and maybe next week I'll have some time to put one together. I need one
anyway.

-Mark :o)


- Original Message -
From: Kent A. Orso [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 14, 2000 12:26 PM
Subject: Photo Database App


 Does anyone out in CF-Land know of a photo database app written in CF?
What
 I am looking for is a database app that would allow you to bring up a page
 with multiple thumbnails of photos with possibly a small description. The
 text and photos (thumbnails and originals) would be indexed int he
database.
 Any user hiting the website would, be taken to a page dynamically
generated
 from the entries in the database.

 Thanks In Advance,
 Kent


 --

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


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



Re: Getting a background image to stick

2000-09-15 Thread Mark Adams

I need to see the code so a link to a page would be good or if its not
possible you can email it to me and we'll get it figured out.

-Mark :o)


- Original Message -
From: Gieseman, Athelene [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 14, 2000 9:29 AM
Subject: Getting a background image to stick


 I've been trying to use a background image on some CF pages.  The colors,
 fonts, and all other format options in the body tag seem to work.  But the
 image doesn't display.  Can anyone tell me what I might be doing wrong?

 Also, I need an address to reach a list admin.  Seems I'm getting all of
my
 cf-talk messages twor or three times.  I love this list.  But I'll never
get
 through all the mail!

 Athelene Gieseman
 [EMAIL PROTECTED]
 --

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


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



Re: cfmail

2000-09-15 Thread Mark Adams

That should work fine. Try checking your admin mail settings in CF

-Mark :o)

- Original Message -
From: Peter Benoit [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 15, 2000 10:52 AM
Subject: cfmail


 Any idea why this doesn't work?

 cfmail to="[EMAIL PROTECTED]" from="[EMAIL PROTECTED]"
 subject="test"
 test
 /cfmail

 Thanks,
 Peter

 --

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


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



Re: Javascript Question

2000-09-15 Thread Mark Adams

You need to use style in your select field this will work in 4.0 IE, NS and
above

-Mark :o)


- Original Message -
From: Todd Everling [EMAIL PROTECTED]
To: CF-Talk (E-mail 3) [EMAIL PROTECTED]
Sent: Friday, September 15, 2000 10:41 AM
Subject: OT: Javascript Question


 Anyone know how code the size of the font for text in a dropdown box.

 I know it works for Netscape.but I'm looking for an IE solutions.

 Thanks

 Todd Everling
 --

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


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



Re: Ok, What is Fusebox?

2000-09-15 Thread Mark Adams

This looks COOL, Thanks for all the info!

-Mark :o)


- Original Message -
From: Mark Adams [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 12, 2000 11:48 AM
Subject: Ok, What is Fusebox?


 What is Fusebox? I keep hearing about it.



 --

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


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



Re: DateTimeDiff

2000-09-14 Thread Mark Adams

Something like this should work for you.

CFSET chktime = #DateDiff("h", TimeFormat(now()),
CreateTime(YourTimeInput))#
CFIF (chktime LT 2) AND (chktime GTE 1)
CFSET bgcolor = "yellow"
CFELSEIF chktime EQ 2
CFSET bgcolor = "orange"
CFELSEIF chktime GT 2
CFSET bgcolor = "red"
CFELSE
CFSET bgcolor = "black"
/CFIF
CFOUTPUT
B
FONT FACE="Arial" COLOR="#bgcolor#"Hello your #chktime# hour(s)
late/FONT
/B
/CFOUTPUT

Good Luck!

-Mark :o)


- Original Message -
From: Aidan Whitehall [EMAIL PROTECTED]
To: CF-Talk (E-mail) [EMAIL PROTECTED]
Sent: Thursday, September 14, 2000 7:44 AM
Subject: DateTimeDiff


 Is there DateDiff function that allows you to compare DateTime objects,
not
 just Date Objects?

 I need to flag a record yellow if it's an hour overdue, orange if it's two
 hours overdue and red for anything more than that.


 Thanks

 --
 Aidan Whitehall [EMAIL PROTECTED]
 Netshopper UK Ltd
 Advanced Web Solutions  Services

 http://www.netshopperuk.com/
 Telephone +44 (01744) 648650
 Fax +44 (01744) 648651
 --

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


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



Re: DateTimeDiff

2000-09-14 Thread Mark Adams

Something like this should work for you.

CFSET chktime = #DateDiff("h", TimeFormat(now()),
CreateTime(YourTimeInput))#
CFIF (chktime LT 2) AND (chktime GTE 1)
CFSET bgcolor = "yellow"
CFELSEIF chktime EQ 2
CFSET bgcolor = "orange"
CFELSEIF chktime GT 2
CFSET bgcolor = "red"
CFELSE
CFSET bgcolor = "black"
/CFIF
CFOUTPUT
B
FONT FACE="Arial" COLOR="#bgcolor#"Hello your #chktime# hour(s)
late/FONT
/B
/CFOUTPUT

Good Luck!

-Mark :o)

- Original Message -
From: Aidan Whitehall [EMAIL PROTECTED]
To: CF-Talk (E-mail) [EMAIL PROTECTED]
Sent: Thursday, September 14, 2000 7:44 AM
Subject: DateTimeDiff


 Is there DateDiff function that allows you to compare DateTime objects,
not
 just Date Objects?

 I need to flag a record yellow if it's an hour overdue, orange if it's two
 hours overdue and red for anything more than that.


 Thanks

 --
 Aidan Whitehall [EMAIL PROTECTED]
 Netshopper UK Ltd
 Advanced Web Solutions  Services

 http://www.netshopperuk.com/
 Telephone +44 (01744) 648650
 Fax +44 (01744) 648651
 --

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


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



Re: Simple SQL Question

2000-09-14 Thread Mark Adams

I believe you need to separate fields with a comma.

Hope that helps.

- Mark :o)

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 14, 2000 3:12 PM
Subject: Simple SQL Question


 Ok I want to "conjugate" 3 fields when i am inserting into a database.

 this is what i have, but it won't work, am i missing something???

 cfquery datasource="data" name="add"
 INSERT INTO Data(data1)
 VALUES('#FORM.dat1# #FORM.dat2# #FORM.dat3#')
 /cfquery


 ?
 --

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


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



Re: Simple SQL Question

2000-09-14 Thread Mark Adams

Scratch that last email I didn't look very close, sorry!

If you are just inserting into one table then why not use

CFINSERT dataSource="database" tableName="table"

and then pass whatever from your form.

Or am I misunderstanding what your doing?

-Mark :o)

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 14, 2000 3:12 PM
Subject: Simple SQL Question


 Ok I want to "conjugate" 3 fields when i am inserting into a database.

 this is what i have, but it won't work, am i missing something???

 cfquery datasource="data" name="add"
 INSERT INTO Data(data1)
 VALUES('#FORM.dat1# #FORM.dat2# #FORM.dat3#')
 /cfquery


 ?
 --

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


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



Re: Upload and retrieval of stories?

2000-09-14 Thread Mark Adams

I'm not sure if there is one in CF but if not, there is a great utility for
doing this in Perl. You could easily use with CF. I've used it and it works
great looks a little rough but it can easily be massaged.

Download it here:
http://amphibian.gagames.com/newspro/

-Mark :o)


- Original Message -
From: Steven Katz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 14, 2000 4:00 PM
Subject: Upload and retrieval of stories?


 Hi all,

 I'm developing a site that will feature short- to medium-length
 stories from lesser-known authors. I have designed a page that will
 serve as a template, into which I will insert the material contributed
 from the authors. I would rather that this process of inserting
 content not be a manual one. In fact, I would like the programmatic
 solution to include a web-based administrative interface. Normally,
 this might consist of some forms and CF or PHP, allowing the user to
 upload content to a database, where the material could then also be
 made available to the templates for the dynamic creation of pages.
 However, form fields seem to have a rather small character limit,
 preventing one from simply pasting an entire story into them. This
 isn't really what I want to do anyway. Has anyone devised a good
 process for accomplishing something similar? Perhaps there's no reason
 to store this material in a database, anyway? I'd be very interested
 to hear your suggestions.

 Thanks,
 Steven

 --

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


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



cfif inside loops and querys

2000-09-13 Thread Mark Adams


How can you use the output of a cfif block that is embedded in a cfoutput
query outside of the /cfoutput without having to repeat the cfif block
. It seems silly to repeat these blocks.
This is a sample of what I mean. This code is purely an scenario of what I
want to accomplish, it of course won't work like this.

CFLOOP index="test" from="1" to="20"

CFOUTPUT query="query"
CFIF (#test# EQ #datatable#)
  CFSET CheckImage = "check.gif"
CFELSE
  CFSET CheckImage = "blank.gif"
/CFIF
/CFOUTPUT

CFOUTPUT query="query"
CFIF (#test# EQ #datatable#)
  CFSET BookColor = "White"
CFIF datatable10 EQ 4
  CFSET TableBookColor = "Red"
CFELSEIF datatable10 EQ 3
  CFSET TableBookColor = "Blue"
CFELSEIF datatable10 EQ 2
  CFSET TableBookColor = "Green"
/CFIF
CFELSE
  CFSET BookColor = "Black"
  CFSET TableBookColor = "White"
/CFIF/CFOUTPUT

tr
tdCFOUTPUTimg src="../images/#CheckImage#"/CFOUTPUT/td
td bgcolor = "#TableBookColor #"
font color = "#BookColor#"
CFOUTPUT query="query"CFIF (#test# EQ
#datatable#)#datatable1#/CFELSE--/CFIF/CFOUTPUT/td
td bgcolor = "#TableBookColor #"
font color = "#BookColor#"
CFOUTPUT query="query"CFIF (#test# EQ
#datatable#)#datatable2#/CFELSE--/CFIF/CFOUTPUT/td
td bgcolor = "#TableBookColor #"
font color = "#BookColor#"
CFOUTPUT query="query"CFIF (#test# EQ
#datatable#)#datatable3#/CFELSE--/CFIF/CFOUTPUT/td
td bgcolor = "#TableBookColor #"
font color = "#BookColor#"
CFOUTPUT query="query"CFIF (#test# EQ
#datatable#)#datatable4#/CFELSE--/CFIF/CFOUTPUT/td
/tr

/CFLOOP

Any Idea's, Thanks in advance for any suggestions.

-Mark :o)


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



Re: cfif inside loops and querys

2000-09-13 Thread Mark Adams

Actually what I want is a tr starting with a content conditional image,
background color then output of a loop and more conditional database info as
you can see in the example the cfif conditional compares info from the
database against variables so I need to run each cfif in a separate query.
Yes I know I could just include them in the main query but its in a loop
so I would end up with ten miles of white space along with layout problem
that arise when formatting multiple table rows and columns inside loops.
This is where the problem is. I AM STUCK! There must be a tag to do this
correctly.

Here is a table layout, the loop is compared to a database table and where
they match it prints a record. The variables of these records are then
compared returning the row colors and image values. I hope this makes more
sense.

conditional row color| conditional image | loop output | conditional
database output | conditional database output |
conditional row color| conditional image | loop output | conditional
database output | conditional database output |
conditional row color| conditional image | loop output | conditional
database output | conditional database output |
conditional row color| conditional image | loop output | conditional
database output | conditional database output |

Any help is appreciated.

-Mark :o)





- Original Message -
From: Stephen Moretti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 13, 2000 6:13 AM
Subject: RE: cfif inside loops and querys


 Mark,

 
  How can you use the output of a cfif block that is embedded in
  a cfoutput
  query outside of the /cfoutput without having to repeat the
  cfif block
  . It seems silly to repeat these blocks.
  This is a sample of what I mean. This code is purely an scenario of what
I
  want to accomplish, it of course won't work like this.
 

 Could you explain in words/pictures what exactly it is that you're
after

 It looks kind of like you want to have a multi-column table with a record
in
 each column going from left to right, colouring the background of the TD
 according to the contents of the record.
 However, you could also be depicting one record per TR with a different
 field from the record in each column.

 Regards

 Stephen

 --

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


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



Re: cfif inside loops and querys

2000-09-13 Thread Mark Adams

Thanks All! Never mind I have figure it out.


- Original Message -
From: Mark Adams [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, September 13, 2000 9:40 AM
Subject: Re: cfif inside loops and querys


 Actually what I want is a tr starting with a content conditional image,
 background color then output of a loop and more conditional database info
as
 you can see in the example the cfif conditional compares info from the
 database against variables so I need to run each cfif in a separate
query.
 Yes I know I could just include them in the main query but its in a loop
 so I would end up with ten miles of white space along with layout problem
 that arise when formatting multiple table rows and columns inside loops.
 This is where the problem is. I AM STUCK! There must be a tag to do this
 correctly.

 Here is a table layout, the loop is compared to a database table and where
 they match it prints a record. The variables of these records are then
 compared returning the row colors and image values. I hope this makes more
 sense.

 conditional row color| conditional image | loop output | conditional
 database output | conditional database output |
 conditional row color| conditional image | loop output | conditional
 database output | conditional database output |
 conditional row color| conditional image | loop output | conditional
 database output | conditional database output |
 conditional row color| conditional image | loop output | conditional
 database output | conditional database output |

 Any help is appreciated.

 -Mark :o)





 - Original Message -
 From: Stephen Moretti [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, September 13, 2000 6:13 AM
 Subject: RE: cfif inside loops and querys


  Mark,
 
  
   How can you use the output of a cfif block that is embedded in
   a cfoutput
   query outside of the /cfoutput without having to repeat the
   cfif block
   . It seems silly to repeat these blocks.
   This is a sample of what I mean. This code is purely an scenario of
what
 I
   want to accomplish, it of course won't work like this.
  
 
  Could you explain in words/pictures what exactly it is that you're
 after
 
  It looks kind of like you want to have a multi-column table with a
record
 in
  each column going from left to right, colouring the background of the
TD
  according to the contents of the record.
  However, you could also be depicting one record per TR with a
different
  field from the record in each column.
 
  Regards
 
  Stephen
 

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

 --

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


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



SQL where?

2000-09-13 Thread Mark Adams

Ok, here is the puzzle I am trying to use a WHERE statement to compare a
loop to a table it should work fine if  I can get the date/time values to
match but the raw date format is different

CF raw date/time looks like this 1899-12-30 06:24:00
Access raw date/time looks like this {ts '1899-12-30 06:24:00'}

So if my assumption is true (I have not done this with a loop yet.) the only
thing I need to do is some how format these date/time values within the SQL
statement. If this is possible I can remove about 5 cfif blocks.

So, my question is can dates be formatted in an SQL statement? HU!

Thanks for any input!

-Mark :o)


CFSET StartTime1 = CreateTime(06, 00, 00)
CFSET TeeTime = #DateAdd('N', -8, StartTime1)#

CFLOOP index="TodaysTeeTime" from="1" to="92"
  CFSET TeeTime = #DateAdd('N', 8, TeeTime)#

CFQUERY NAME="Events" DATASOURCE="caltest"
SELECTcal.ID, cal.Players, cal.TeeDate, cal.BookedTeeTime,
cus.CompanyName, cus.ContactFirstName, cus.ContactLastName, cus.PhoneNumber,
cus.EmailAddress
FROM Calendar cal, Customers cus
WHERE   cal.CustomerID = cus.CustomerID
AND #TeeTime# = cal.BookedTeeTime
ORDER BY cal.BookedTeeTime
/CFQUERY

/CFLOOP

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



Re: SQL where?

2000-09-13 Thread Mark Adams

Ya, I tried that bummer. I miswrote before the time outputs are just the
opposite. There must be something I'm missing. HU!

CF raw date/time looks like this {ts '1899-12-30 06:24:00'}
Access raw date/time looks like this 1899-12-30 06:24:00

HU!



- Original Message -
From: Peter Tilbrook [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 13, 2000 7:46 PM
Subject: RE: SQL where?


 I believe you need to use the "CreateODBCDateTime" function.


 -Original Message-----
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, 14 September 2000 12:36
 To: [EMAIL PROTECTED]
 Subject: SQL where?


 Ok, here is the puzzle I am trying to use a WHERE statement to compare a
 loop to a table it should work fine if  I can get the date/time values to
 match but the raw date format is different

 CF raw date/time looks like this 1899-12-30 06:24:00
 Access raw date/time looks like this {ts '1899-12-30 06:24:00'}

 So if my assumption is true (I have not done this with a loop yet.) the
only
 thing I need to do is some how format these date/time values within the
SQL
 statement. If this is possible I can remove about 5 cfif blocks.

 So, my question is can dates be formatted in an SQL statement? HU!

 Thanks for any input!

 -Mark :o)


 CFSET StartTime1 = CreateTime(06, 00, 00)
 CFSET TeeTime = #DateAdd('N', -8, StartTime1)#

 CFLOOP index="TodaysTeeTime" from="1" to="92"
   CFSET TeeTime = #DateAdd('N', 8, TeeTime)#

 CFQUERY NAME="Events" DATASOURCE="caltest"
 SELECTcal.ID, cal.Players, cal.TeeDate, cal.BookedTeeTime,
 cus.CompanyName, cus.ContactFirstName, cus.ContactLastName,
cus.PhoneNumber,
 cus.EmailAddress
 FROM Calendar cal, Customers cus
 WHERE   cal.CustomerID = cus.CustomerID
 AND #TeeTime# = cal.BookedTeeTime
 ORDER BY cal.BookedTeeTime
 /CFQUERY

 /CFLOOP

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

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


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



Ok, What is Fusebox?

2000-09-12 Thread Mark Adams

What is Fusebox? I keep hearing about it. 



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



Re: Onclick doesn't work in Netscape

2000-09-11 Thread Mark Adams

Hello, Robert

I am not sure exactly what your looking for. I went to your page and there
was nothing there.
So here is a sample that will give you a popup window it works on both NS
and IE.


html
head
titleTitle/title
script language="JavaScript"
!--
function openBrWindow(theURL,winName,features) {
  window.open(theURL,winName,features);
}
//--
/script
/head

body bgcolor="#FF"
a href="#"
onClick="openBrWindow('URL/PageToOpen.htm','WindowName','scrollbars=yes,widt
h=500,height=500')"img src="image.gif" width="100" height="100"
border="0"/a

/body
/html



-Mark :o)


- Original Message -
From: Robert Everland [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 11, 2000 10:39 AM
Subject: RE: Onclick doesn't work in Netscape


 Could you explain this in more detail. I just bough my javascript bible a
 little while ago so am still learning hardcore javscript. Could you give
me
 a little snippet?

 Robert Everland III
 Web Developer
 Dixon Ticonderoga



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



Re: Database Blunders

2000-09-10 Thread Mark Adams

Thanks, Bud

I actually do want all the TeeTimes from the FixedTeeTime Table but I don't
want the TeeID values from the Calendar table this is where I am confused
should I redesign my tables?

-Mark :o)



- Original Message -
From: Bud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 10, 2000 12:49 AM
Subject: Re: Database Blunders


 On 9/9/00, Mark Adams penned:
 FROM (FixedTeeTimes LEFT OUTER JOIN Calendar ON
FixedTeeTimes.TeeID
 = Calendar.TeeID ) LEFT OUTER JOIN Customers ON Customers.CustomerID =
 Calendar.CustomerID
 
 
 ORDER BY FixedTeeTimes
 
 Ok, I know its probably easy, right in front of me and all that, but my
mind
 is melting now. HELP!

 I think if you make the first join an inner join it will work. The
 left outer is returning ALL records from the FixedTeeTimes table.
 --

 Bud Schneehagen - Tropical Web Creations

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

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


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



Re: CFPARAM default values

2000-09-09 Thread Mark Adams

Thanks, Chris

The problem with that is if you change the attribute value to a pixel value
rather than a %. You would always have a % attached like 640% wow that's
wide

I am coming from Perl and still figuring out how to set values in CF.

Also how do you set a URL value with CFSET or is there another tag to use
for that?

Thanks Again!

-Mark

- Original Message -
From: Chris Cortes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 09, 2000 11:10 AM
Subject: Re: CFPARAM default values


 Mark why don't you go ahead and set your param like this:

 cfparam name="tablew" default="100"

 and then make your call to the variable like this:

 table width="#tablew#%"...

 Chris Cortes
 Consultant
 [EMAIL PROTECTED]
 Direct 713-985-6244
 Cell 832-723-6485

 Stonebridge Technologies
 ...The Fast Track to e-Business.
 visit us at www.sbti.com

 - Original Message -
 From: "Mark Adams" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Saturday, September 09, 2000 12:03 AM
 Subject: CFPARAM default values


  Hello All!
  I am using CFPARAM to set defaults for table sizes the default value is
  "100%" but if I use this it errors obviously is the "%" How can this be
  done?
  This is the line: cfparam name="tablew" default="100%"
  Thanks in advance.
 
  -Mark :o)
 

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

 --

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


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



Re: CFPARAM default values

2000-09-09 Thread Mark Adams

Weird, what version of CF are you using? I'm using 4.0

-Mark

- Original Message -
From: James [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 09, 2000 11:38 AM
Subject: RE: CFPARAM default values


 Mark this code works fine for me.

 Mark, this code works fine for me.

 CFPARAM name="tablew" default="100%"

 table bgcolor="black" width="cfoutput#tablew#/cfoutput"
align="center"
 trtdnbsp;nbsp;/td/tr
 /table

 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, September 09, 2000 11:23 AM
 To: [EMAIL PROTECTED]
 Subject: Re: CFPARAM default values


 Thanks, Chris

 The problem with that is if you change the attribute value to a pixel
value
 rather than a %. You would always have a % attached like 640% wow that's
 wide

 I am coming from Perl and still figuring out how to set values in CF.

 Also how do you set a URL value with CFSET or is there another tag to use
 for that?

 Thanks Again!

 -Mark

 - Original Message -
 From: Chris Cortes [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Saturday, September 09, 2000 11:10 AM
 Subject: Re: CFPARAM default values


  Mark why don't you go ahead and set your param like this:
 
  cfparam name="tablew" default="100"
 
  and then make your call to the variable like this:
 
  table width="#tablew#%"...
 
  Chris Cortes
  Consultant
  [EMAIL PROTECTED]
  Direct 713-985-6244
  Cell 832-723-6485
 
  Stonebridge Technologies
  ...The Fast Track to e-Business.
  visit us at www.sbti.com
 
  - Original Message -
  From: "Mark Adams" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Saturday, September 09, 2000 12:03 AM
  Subject: CFPARAM default values
 
 
   Hello All!
   I am using CFPARAM to set defaults for table sizes the default value
is
   "100%" but if I use this it errors obviously is the "%" How can this
be
   done?
   This is the line: cfparam name="tablew" default="100%"
   Thanks in advance.
  
   -Mark :o)
  
 

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

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

 --

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

 --

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


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



Re: CFPARAM default values

2000-09-09 Thread Mark Adams

Here is my error message

Error Diagnostic Information
Cannot convert 100% to stk_real.

-Mark

- Original Message -
From: Mark Adams [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 09, 2000 11:36 AM
Subject: Re: CFPARAM default values


 Weird, what version of CF are you using? I'm using 4.0

 -Mark

 - Original Message -
 From: James [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Saturday, September 09, 2000 11:38 AM
 Subject: RE: CFPARAM default values


  Mark this code works fine for me.
 
  Mark, this code works fine for me.
 
  CFPARAM name="tablew" default="100%"
 
  table bgcolor="black" width="cfoutput#tablew#/cfoutput"
 align="center"
  trtdnbsp;nbsp;/td/tr
  /table
 
  -Original Message-
  From: Mark Adams [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, September 09, 2000 11:23 AM
  To: [EMAIL PROTECTED]
  Subject: Re: CFPARAM default values
 
 
  Thanks, Chris
 
  The problem with that is if you change the attribute value to a pixel
 value
  rather than a %. You would always have a % attached like 640% wow that's
  wide
 
  I am coming from Perl and still figuring out how to set values in CF.
 
  Also how do you set a URL value with CFSET or is there another tag to
use
  for that?
 
  Thanks Again!
 
  -Mark
 
  - Original Message -
  From: Chris Cortes [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Saturday, September 09, 2000 11:10 AM
  Subject: Re: CFPARAM default values
 
 
   Mark why don't you go ahead and set your param like this:
  
   cfparam name="tablew" default="100"
  
   and then make your call to the variable like this:
  
   table width="#tablew#%"...
  
   Chris Cortes
   Consultant
   [EMAIL PROTECTED]
   Direct 713-985-6244
   Cell 832-723-6485
  
   Stonebridge Technologies
   ...The Fast Track to e-Business.
   visit us at www.sbti.com
  
   - Original Message -
   From: "Mark Adams" [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Saturday, September 09, 2000 12:03 AM
   Subject: CFPARAM default values
  
  
Hello All!
I am using CFPARAM to set defaults for table sizes the default value
 is
"100%" but if I use this it errors obviously is the "%" How can this
 be
done?
This is the line: cfparam name="tablew" default="100%"
Thanks in advance.
   
-Mark :o)
   
  
 

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

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

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

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

 --

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


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



Re: Number Format Question

2000-09-09 Thread Mark Adams

Thanks, Sebastian

I wasn't sure if you could do this with NumberFormat but this will do the
trick.

Thanks a BUNCH!

-Mark :o)

- Original Message -
From: sebastian palmigiani [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 09, 2000 5:31 PM
Subject: Re: Number Format Question


 on 9/9/00 7:03 PM, Mark Adams at [EMAIL PROTECTED] wrote:

  I need to format this phone number,  #NumberFormat(PhoneNumber)# to look
  like this 555-222- but I am not sure how to properly mask it. Any
Ideas?

 I don't know if you can do that with NumberFormat. However, you can try
 this:

 cfset PhoneNumber = 555222
 cfset PhoneNumber = Insert("-", PhoneNumber, 3)
 cfset PhoneNumber = Insert("-", PhoneNumber, 7) 
 cfoutput#PhoneNumber#/cfoutput

 Maybe others have a more elegant way of doing it.

 Sebastian

 --

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


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



Database Blunders

2000-09-09 Thread Mark Adams

Hello All!

I just setup a new database for my scheduling software and everything, I
thought was great. Here's the scenario. Using the SQL query below I display
all of the TeeTimes and the customers on there corresponding  scheduled days
and time this work fine. Accept when I schedule more than one TeeTime at say
6am it then still displays the schedule correctly but it repeats the 6am
values on all days.

Example1: This is Mondays TeeTimes

TeeTimesName#PlayersEmailPhone
6:00AMJoe Blow2 joe@blow   222-555-
6:08AMTom Blow   2 tom@blow   222-555-
6:16AM------------

Example 2: This is the same Mondays TeeTimes after I have added 6:00AM
TeeTimes on Tuesday and Wednesday as you can see the schedule is still
accurate but for each day a TeeTime is scheduled it shows another 6:00AM
value. This is where I am stuck. What to Do? HUMMM!

TeeTimesName#PlayersEmailPhone
6:00AM------------
6:00AM------------
6:00AMJoe Blow2 joe@blow   222-555-
6:08AMTom Blow   2 tom@blow   222-555-
6:16AM------------

Note: The TeeTimes are stored in FixedTeeTimes starting at 6:00AM to 6:08PM
in 7 min. increments with the corresponding TeeID

Here is the SQL query:

SELECT  FixedTeeTimes.FixedTeeTimes,
   Calendar.CustomerID,
   Calendar.Players,
   Calendar.TeeDate,
   Customers.CustomerID,
   Customers.ContactFirstName,
   Customers.ContactLastName,
   Customers.PhoneNumber,
   Customers.EmailAddress
FROM (FixedTeeTimes LEFT OUTER JOIN Calendar ON FixedTeeTimes.TeeID
= Calendar.TeeID ) LEFT OUTER JOIN Customers ON Customers.CustomerID =
Calendar.CustomerID


ORDER BY FixedTeeTimes

Ok, I know its probably easy, right in front of me and all that, but my mind
is melting now. HELP!


Thanks, Mark :o)



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



CFPARAM default values

2000-09-08 Thread Mark Adams

Hello All!
I am using CFPARAM to set defaults for table sizes the default value is
"100%" but if I use this it errors obviously is the "%" How can this be
done?
This is the line: cfparam name="tablew" default="100%"
Thanks in advance.

-Mark :o)

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



Re: OUTER JOIN w/more than 2 tables

2000-09-07 Thread Mark Adams

Thanks, Justin

It worked perfect just had to create a couple of cfif cfelse statements
for the NULL Date fields and whala!

Thank you! :o)

-Mark


- Original Message -
From: Justin Kidman [EMAIL PROTECTED]
To: 'Mark Adams' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 07, 2000 9:03 AM
Subject: RE: OUTER JOIN w/more than 2 tables


 Ok, I have never done this with RIGHT JOINs, just LEFT JOINs.  The trick
to
 making it work is you put () around one the joins and treat that as if it
is
 one table and join that to the third table.  This will not be right for
your
 case, but let me do a SQL statement with the three tables below as a LEFT
 JOIN totally.

 SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID,
 Customers.CustomerID, Customers.ContactFirstName,
Customers.ContactLastName,
 Customers.PhoneNumber, Customers.EmailAddress
 FROM (Calendar LEFT OUTER JOIN FixedTeeTimes ON Calendar.TeeID =
 FixedTeeTimes.TeeID) LEFT OUTER JOIN Customers ON Customers.CustomerID =
 Calendar.CustomerID

 Ok, this one should work, bringing up all the Calendar results and only
 those associated FixedTeeTimes and Customers.  Maybe you want to bring up
 all the customers and their associatioed FixedTeeTimes and Calendar
results,
 well that would look like this with LEFT JOINS:

 SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID,
 Customers.CustomerID, Customers.ContactFirstName,
Customers.ContactLastName,
 Customers.PhoneNumber, Customers.EmailAddress
 FROM (Customers LEFT OUTER JOIN Calendar ON Customers.CustomerID =
 Calendar.CustomerID) LEFT OUTER JOIN FixedTeeTimes ON FixedTeeTimes.TeeID
=
 Calendar.TeeID

 What the trick is that there is () around one of the joins and then you
 treat that as a single table that has all the columns of the first two
 tables and join it on a third.  I have not tried with RIGHT JOINs yet, and
I
 am having a lot of trouble figuring out how to order it to work with RIGHT
 JOINs, but I think the LEFT JOIN SQL statement I just gave above should
 accomplish what you want, if I am guessing right from your SQL statement.
 Hope this helps you to understand joining multiple tables better...

 Justin Kidman

 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 06, 2000 7:13 PM
 To: [EMAIL PROTECTED]
 Subject: Re: OUTER JOIN w/more than 2 tables


 Hey, Justin

 This is wierd I post a message it takes about 3 to 4 hours before its
 posted. Is that normal for this list?

 Anyway I thought it would be more productive to just email you direct I'm
 still not getting anywhere with this OUTER JOIN thing as I said before I
 have successfully done these with 2 tables no problem, but when I add a
3rd
 table then there's a problem. MS Access says to create two queries then
 refer to the 1st query with the 2nd this does work but it seems like there
 is a better way.

 !-Here is the code you sent-
 SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID,
 Customers.CustomerID, Customers.ContactFirstName,
Customers.ContactLastName,
 Customers.PhoneNumber, Customers.EmailAddress
 FROM (oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON
 Calendar.TeeID = FixedTeeTimes.TeeID) RIGHT OUTER JOIN Customers ON
 Customers.CustomerID = Calendar.CustomerID
 !-Here is the code you sent-

 Here is the latest error,

 !-Error Message-
 Error Diagnostic Information
 ODBC Error Code = S1000 (General error)


 [Microsoft][ODBC Microsoft Access Driver] Join expression not supported.



 I'm just not getting this stuff. It seems so easy yet its irritating the
 h#$%@l out of me. AHHH!
 HELP!


 -Mark


 - Original Message -
 From: Justin Kidman [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, September 06, 2000 1:05 PM
 Subject: RE: OUTER JOIN w/more than 2 tables


  Hmm, me not cutting out enough things... Bah, no more copy paste on
other
  ppl's code... =P
 
  Justin Kidman
 
  -Original Message-
  From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 06, 2000 12:01 PM
  To: [EMAIL PROTECTED]
  Subject: RE: OUTER JOIN w/more than 2 tables
 
 
  What is the "oj"  right after the FROM?
 
  Shouldnt that not be there..? Or is oj a
  table and your aliasing it to Calendar??
 
  Jeremy
 
  -Original Message-
  From: Mark Adams [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 06, 2000 2:17 PM
  To: [EMAIL PROTECTED]
  Subject: Re: OUTER JOIN w/more than 2 tables
 
 
  I tried it and I keep getting this error. Its the same error I was
getting
  before. I must be missing something.
 
 

 
  !-Error Message-
  ODBC Error Code = 37000 (Syntax error or access violation)
 
  [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN
operation.
 
  -Mark
 
 
 
  - Original Message -
  From: Justin Kidman [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Wednesday, September 06, 2000 10:27 AM
  Subject: RE: OUTER JOIN w/more tha

OUTER JOIN w/more than 2 tables

2000-09-06 Thread Mark Adams

Hello All!

"OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting
errors. If I set up a query with 3 or more tables everything works fine
until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up
just 2 tables with an "OUTER JOIN" everything works great but if I add
another table it errors again. A!

The queries are below.

What am I missing?

Any help is appreciated.

Mark :o)



!-This one works fine-
SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID
FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID =
FixedTeeTimes.TeeID }

!-But I need data from 3rd table so I add this and it errors out-
SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID,
Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName,
Customers.PhoneNumber, Customers.EmailAddress
FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON
Calendar.TeeID = FixedTeeTimes.TeeID }
WHERE   Customers.CustomerID = Calendar.CustomerID





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



Re: CF Groupware

2000-09-06 Thread Mark Adams

Here is a Open source Scheduler it seems to work fine.

http://www.epicmedia.com/

-Mark


- Original Message -
From: Sean Daniels [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 06, 2000 10:21 AM
Subject: CF Groupware


 I am looking for a groupware solution written in CF, preferably open
source.
 Anyone have any recommendations? Primarily I need calendar, task
management,
 discussion functionality.

 TIA.


 - Sean

 
 Sean Daniels
   Manager, Engineering
   Marketplace Technologies
   [EMAIL PROTECTED]
 
 tel: 207.439.6030
 cel: 978.764.0779

 http://www.dealforce.com
 http://www.mergernetwork.com

 --

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


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



Re: OUTER JOIN w/more than 2 tables

2000-09-06 Thread Mark Adams

I tried it and I keep getting this error. Its the same error I was getting
before. I must be missing something.

:o( 

!-Error Message-
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.

-Mark 



- Original Message - 
From: Justin Kidman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 06, 2000 10:27 AM
Subject: RE: OUTER JOIN w/more than 2 tables


 Do this all the time, n-table joins, just need to use () well.
 
 SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID,
 Customers.CustomerID, Customers.ContactFirstName, Customers.ContactLastName,
 Customers.PhoneNumber, Customers.EmailAddress
 FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON
 Calendar.TeeID = FixedTeeTimes.TeeID  RIGHT OUTER JOIN Customers) ON
 Customers.CustomerID = Calendar.CustomerID
 
 Use the () to left if you are using a LEFT OUTER JOIN.
 
 Justin Kidman
 
 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 06, 2000 10:10 AM
 To: [EMAIL PROTECTED]
 Subject: OUTER JOIN w/more than 2 tables
 
 
 Hello All!
 
 "OUTER JOIN" with 3 tables? I have tried this many ways and I keep getting
 errors. If I set up a query with 3 or more tables everything works fine
 until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up
 just 2 tables with an "OUTER JOIN" everything works great but if I add
 another table it errors again. A!
 
 The queries are below.
 
 What am I missing?
 
 Any help is appreciated.
 
 Mark :o)
 
 
 
 !-This one works fine-
 SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID
 FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON Calendar.TeeID =
 FixedTeeTimes.TeeID }
 
 !-But I need data from 3rd table so I add this and it errors out-
 SELECT  FixedTeeTimes.Fixed
TeeTimes, Calendar.CustomerID,
 Customers.CustomerID, Customers.ContactFirstName,
Customers.ContactLastName,
 Customers.PhoneNumber, Customers.EmailAddress
 FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON
 Calendar.TeeID = FixedTeeTimes.TeeID }
 WHERE   Customers.CustomerID = Calendar.CustomerID





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

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


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



Re: OUTER JOIN w/more than 2 tables

2000-09-06 Thread Mark Adams

No, the "oj" is the default OUTER JOIN for ODBC. If you apply an OUTER JOIN
with SQL Builder in CF Studio it inserts the "oj" so I just left it there
its probably redundant.

Here is the latest error,

!-Error Message-
Error Diagnostic Information
ODBC Error Code = S1000 (General error)


[Microsoft][ODBC Microsoft Access Driver] Join expression not supported.



I'm just not getting this stuff. It seems so easy yet its irritating the
h#$%@l out of me. AHHH!
HELP!



-Mark

- Original Message -
From: Jeremy Allen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 06, 2000 12:00 PM
Subject: RE: OUTER JOIN w/more than 2 tables


 What is the "oj"  right after the FROM?

 Shouldnt that not be there..? Or is oj a
 table and your aliasing it to Calendar??

 Jeremy

 -Original Message-
 From: Mark Adams [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 06, 2000 2:17 PM
 To: [EMAIL PROTECTED]
 Subject: Re: OUTER JOIN w/more than 2 tables


 I tried it and I keep getting this error. Its the same error I was getting
 before. I must be missing something.




 !-Error Message-
 ODBC Error Code = 37000 (Syntax error or access violation)

 [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.

 -Mark



 - Original Message -
 From: Justin Kidman [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, September 06, 2000 10:27 AM
 Subject: RE: OUTER JOIN w/more than 2 tables


  Do this all the time, n-table joins, just need to use () well.
 
  SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID,
  Customers.CustomerID, Customers.ContactFirstName,
Customers.ContactLastName,
  Customers.PhoneNumber, Customers.EmailAddress
  FROM oj Calendar RIGHT OUTER JOIN (FixedTeeTimes ON
  Calendar.TeeID = FixedTeeTimes.TeeID  RIGHT OUTER JOIN Customers) ON
  Customers.CustomerID = Calendar.CustomerID
 
  Use the () to left if you are using a LEFT OUTER JOIN.
 
  Justin Kidman
 
  -Original Message-
  From: Mark Adams [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, September 06, 2000 10:10 AM
  To: [EMAIL PROTECTED]
  Subject: OUTER JOIN w/more than 2 tables
 
 
  Hello All!
 
  "OUTER JOIN" with 3 tables? I have tried this many ways and I keep
getting
  errors. If I set up a query with 3 or more tables everything works fine
  until I change the "INNER JOIN" to an "OUTER JOIN" So I tried setting up
  just 2 tables with an "OUTER JOIN" everything works great but if I add
  another table it errors again. A!
 
  The queries are below.
 
  What am I missing?
 
  Any help is appreciated.
 
  Mark :o)
 
 
 
  !-This one works fine-
  SELECT  FixedTeeTimes.FixedTeeTimes, Calendar.CustomerID
  FROM {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON
Calendar.TeeID =
  FixedTeeTimes.TeeID }
 
  !-But I need data from 3rd table so I add this and it errors
out-
  SELECT  FixedTeeTimes.Fixed
 TeeTimes, Calendar.CustomerID,
  Customers.CustomerID, Customers.ContactFirstName,
 Customers.ContactLastName,
  Customers.PhoneNumber, Customers.EmailAddress
  FROM Customers, {oj Calendar RIGHT OUTER JOIN FixedTeeTimes ON
  Calendar.TeeID = FixedTeeTimes.TeeID }
  WHERE   Customers.CustomerID = Calendar.CustomerID
 
 
 
 
 

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

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

 --

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

 --

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


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



Re: Select Form Element in IE vs Netscape?

2000-09-06 Thread Mark Adams

Netscape needs to see  form/form tags or it won't display any form
objects.

:o) Mark


- Original Message -
From: Greenberg, Lisa [EMAIL PROTECTED]
To: cftalk (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, September 06, 2000 12:18 PM
Subject: Select Form Element in IE vs Netscape?


 This message is in MIME format. Since your mail reader does not understand
 this format, some or all of this message may not be legible.

 --_=_NextPart_001_01C01837.4BC9ACF0
 Content-Type: text/plain;
 charset="iso-8859-1"


 Why does the following show up and work fine in IE and not Netscape?

   select name="gender" 
cfoutput query="sexlst"
   cfif sexlst.value contains currentpt_dat.gender
option value="#sexlst.value#" selected#sexlst.descrip#/option
   cfelse
   option value="#sexlst.value#" #sexlst.descrip#/option
   /cfif/cfoutput/selected


 Thank you in advance.

 Lisa

 --_=_NextPart_001_01C01837.4BC9ACF0
 Content-Type: text/html;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
 HTML
 HEAD
 META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
 charset=3Diso-8859-1"
 META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
 5.5.2651.75"
 TITLESelect Form Element  in IE vs Netscape?/TITLE
 /HEAD
 BODY
 BR

 PFONT SIZE=3D2 FACE=3D"Arial"Why does the following show up and =
 work fine in IE and not Netscape?/FONT
 /P

 PFONT SIZE=3D2 FACE=3D"Arial"nbsp; lt;select =
 name=3Dquot;genderquot; gt;/FONT
 BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp; lt;cfoutput =
 query=3Dquot;sexlstquot;gt;/FONT
 BRFONT SIZE=3D2 FACE=3D"Arial"nbsp; lt;cfif sexlst.value contains =
 currentpt_dat.gendergt;/FONT
 BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; =
 lt;option value=3Dquot;#sexlst.value#quot; =
 selectedgt;#sexlst.descrip#lt;/optiongt;/FONT
 BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp;nbsp;nbsp;nbsp; =
 lt;cfelsegt;/FONT
 BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp;nbsp;nbsp;nbsp; =
 lt;option value=3Dquot;#sexlst.value#quot; =
 gt;#sexlst.descrip#lt;/optiongt;/FONT
 BRFONT SIZE=3D2 FACE=3D"Arial"nbsp;nbsp;nbsp;nbsp;nbsp; =
 lt;/cfifgt;lt;/cfoutputgt;lt;/selectedgt; /FONT
 /P
 BR

 PFONT SIZE=3D2 FACE=3D"Arial"Thank you in advance./FONT
 /P

 PFONT SIZE=3D2 FACE=3D"Arial"Lisa/FONT
 /P

 /BODY
 /HTML
 --_=_NextPart_001_01C01837.4BC9ACF0--
 --

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


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



Time test

2000-09-06 Thread Mark Adams

Just curious how long it takes for this to post it seems like my posts take
hours before I see them and by that time they are usually to late.
This message was sent at: Wednesday 9/6/00 6:42 PM PST
:o)

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