Re:

2000-09-12 Thread Brandon Whitaker

>I have just downloaded cf server 4.5 however when I go to the
administration
>section to modify my server settings the browser proceeds to the address of
>
>http://127.0.0.1/CFIDE/Administrator/index.cfm
>
>and it generates browser message file not found hence I cannot run the
admin
>interface

That's odd...I went to the address above and the admin page came back
correctly...but your password was the same as mine, and all the settings
were just like mine...

[...]

Seriously, though...have you made certain the ColdFusion services are
running on your server?

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"Everytime someone mentions Java the phrase 'cheap plastic toy, that breaks
a lot' comes to mind."
- Lewis Sellers

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Is this a new HTML embedded virus?

2000-08-22 Thread Brandon Whitaker

>Hope this doesn't screw up anyones HTML mail, that's
>why I am taking out the scriopt in it, but it was just
>surrounded by a script tag. Someone sent this to me and
>I just happened to be checking this with web based email.

Yep.  Looks as if (among other things) it shuts your computer down if it's
past 6:00 pm.  It also would seem to be writing an html file containing a
javascript to your system directory, playing around with Outlook
(naturally), etc.

Cute.

BTW, people tend to get annoyed when you ask this sort of question here -
even if the code is disabled, it can still contain enough info to trip SMTP
virus scanners. :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: searches failing...help.

2000-07-12 Thread Brandon Whitaker

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

There's a couple of possibilities that occour to me offhand...
1.) Case sensitivity - if everything in your DB is uppercase, try using
  where knowledge LIKE '#ucase(search_string)#'

2.) Unless you put in wildcards, using 'LIKE' will ONLY match on an EXACT
string; thus:

 where knowledge = 'foobar'

would match 'foobar', but NOT 'boofoobar', 'foobarbaz', 'FOOBAR', etc.

If you wildcard with a percent sign, however:

 where knowledge = 'foobar%'

Then the query would match 'foobar' AND 'foobarbaz'.

At least, it's a percent sign in Oracle.  I seem to recall having seen an
asterisk used elsewhere, but I'm not certain.

HTH...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: You know what would be really cool?

2000-07-12 Thread Brandon Whitaker

>The future's so bright, I gotta wear shades!

Second verse:

..."I studied ColdFusion coding,
 I read Ben Forta;
Subscribe to CF-Talk, but I killfile (OT) squawk;
  tags are kewl,  is even kewler...

When CF Studio they see, co-workers get enraged
Those poor ASP coders...
  They're stuck with FrontPage,
  They're stuck with FrontPage..."

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: pass variables

2000-07-12 Thread Brandon Whitaker

>i have a problem passing variables to an edit page, it passes the field
>pol_question fine but for the answer fields my loop is incorrect, it just
>reproduces the answers 5 times each. each answer is the ans_answer table is
>related to the pol_question through the pol_id, any help would be
>appreciated

It appears that your query loops are resetting the value of 'ans_Ans' &
'ans_ID' each through each iteration; therefore the value for each will end
up set to the last value in the query each time.

You might try using an index loop instead of a query loop, like so:



   
   
   
   
   
   
 



This will replace all 5 of the loops in your current setup.  A possible side
benefit of this is that it'll create the variables for every row in the
current query; of course, this might not be what you want, if your query is
actually selecting a couple hundred rows...

The rest of your output should remain the same.

HTH

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Quite simple, co

2000-07-12 Thread Brandon Whitaker

Quite simple, count the amount of Fields, and the amount of values, and they
aren't consistent you have 11 fields and 12 values, re-tool and try again!

What was throwing me is that the data he had *right* was still being saved.
I've been fortunate(?) to work with native drivers instead of ODBC, and this
(or any other failure) would simply have discarded the whole query and
inserted nothing - is this 'partial insert' a common behavior of ODBC
drivers?

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: (OT) Feel like a dumbass

2000-07-12 Thread Brandon Whitaker

>I'm not gonna post an air cargo or Alyssa Milano question here.

Well...at least THOSE are questions we could answer:

1.) 5000 pounds, give or take.
2.) Yes, but never on-camera.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Testing Assignment

2000-07-10 Thread Brandon Whitaker

>I'm holding back from posting my tag result to the gallery so I can see
what
>others will try. If anyone wants the tag now without trying to do it
>themselves, contact me off list.

Something like this?



// 2 vars for tag:
//  ip = address to translate
//  variable = name of returned var
// ex. 
// #thisIP#
   ipArray = listToArray(attributes.ip,".");
   returnVar = 'caller.' & attributes.variable;
   returnIP =
(ipArray[1]*16777216)+(ipArray[2]*65536)+(ipArray[3]*256)+ipArray[4];
   '#returnVar#' = returnIP;



Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore



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



Re: Oracle on Windows?

2000-07-07 Thread Brandon Whitaker

>Are their Oracle drivers for CF 4.5.1 Windows?  (I client asked me this
>morning, the chart I found on Allaire's website says their isn't, but I
>don't know how current it is)

I know the 7.3 and 8.0 Oracle Native drivers both work, because we're using
them; as for ODBC, I couldn't say for certain but I'd assume they would.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Uh-oh...

2000-07-07 Thread Brandon Whitaker

Is anyone else getting duplicate messages again?

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: contained in a list

2000-07-07 Thread Brandon Whitaker

>let's say.. mynumber = 2 ans mylist = 2,67,34,52

 ...

You were very, very close. :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Know where I can find Chr(*) definitions?

2000-07-07 Thread Brandon Whitaker

>Anyone know of anywhere I can find the definition
>for the Chr(*) stuff online? Only ones I know are
>Chr(10) and Chr(13).

http://www.jimprice.com/ascii-0-127.gif


Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: line break as delimiter

2000-07-07 Thread Brandon Whitaker

>You'll need #CHR(10)# as your delimiter.

It's in there.  Look closely.

>Why incur the extra overhead of converting the list to an array, and then
>looping over the array?

I do it because the NOAA historical data returns I commonly work with are
comma-separated columns of variables.  Break into an array at carriage
returns, process each array element as a list.

For his implementation, perhaps it's not the most efficient - it was simply
offered as one solution.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore



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



Re: line break as delimiter

2000-07-07 Thread Brandon Whitaker


-Original Message-
From: Chris Evans <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, July 06, 2000 5:06 PM
Subject: RE: line break as delimiter


>You'll need #CHR(10)# as your delimiter.
>
>Why incur the extra overhead of converting the list to an array, and then
>looping over the array?  Arrays are normally faster than lists, but the
>extra overhead in converting  the list to an array negates any performance
>gains.
>
>Chris Evans
>[EMAIL PROTECTED]
>http://www.fuseware.com
>
>
>
>-Original Message-
>From: Brandon Whitaker [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, July 06, 2000 12:28 PM
>To: [EMAIL PROTECTED]
>Subject: Re: line break as delimiter
>
>
>>Hi
>>im trying to run a list loop from a file that uses separate lines for the
>>items.
>>i would like to use a line break as a delimiter
>>anyone have any ideas??
>>*
>>
>> 
>>  #i#
>> 
>>
>>*
>>Thanks
>>-Eli-
>
>You could turn it into an array...
>  
>
>
>   
>  #resultArray[i]#
>   
>
>
>I notice that you also have the same value (1) being input for all of your
>options, you might want to re-think that. :)
>
>HTH...
>
>Brandon Whitaker
>[EMAIL PROTECTED]
>---
>"It'll get used by the same people using Opera.  People dressed in black
>wearing berets."
>- Dave Watts, on Mozilla
>
>"It makes you feel so welcome to have a greeter like Papa Dave at the door.
>Kind of like what Wal-Mart wishes it could do."
>- John Allred, on Dave Watts
>
>"The net interprets censorship as damage and routes around it."
>- John Gilmore
>
>
>---
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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



Re: line break as delimiter

2000-07-06 Thread Brandon Whitaker

>Hi
>im trying to run a list loop from a file that uses separate lines for the
>items.
>i would like to use a line break as a delimiter
>anyone have any ideas??
>*
>
> 
>  #i#
> 
>
>*
>Thanks
>-Eli-

You could turn it into an array...
  


   
  #resultArray[i]#
   


I notice that you also have the same value (1) being input for all of your
options, you might want to re-think that. :)

HTH...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: More than one Submit button

2000-07-06 Thread Brandon Whitaker

>Can this be done in Javascript? Or is it better to use
> tag? if so, can someone please help
>me in figuring out how to do it?

JavaScript would work.  I believe that instead of a submit button, you'd
want to use something along the lines of the following:



...where 'mySubmitFunction' is a script which submits the form, using
'myFuseAction' as the variable which calls a particular fuseAction.

HTH...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Great list WAS: Unsubscribe

2000-07-06 Thread Brandon Whitaker

>It makes you feel so welcome to have a greeter like Papa Dave at the door.
>Kind of like what Wal-Mart wishes it could do.

.SIG! .SIG!  I FINALLY have the matched set!!!

Unless you weren't talking about Dave Watts, in which case I'll be
heartbroken.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla

"It makes you feel so welcome to have a greeter like Papa Dave at the door.
Kind of like what Wal-Mart wishes it could do."
- John Allred, on Dave Watts

"The net interprets censorship as damage and routes around it."
- John Gilmore



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



Re: Unsubscribe

2000-06-29 Thread Brandon Whitaker

>Wouldn't it be cool if stupidity was painful?

Yeah...except that insurance/medicare costs would go through the roof when
we were forced to subsidize treatments for #despised_group#.

Either that, or the Politically Correct cadre would legislate that ALL
people must be stupid; thus equality is ensured, and no one suffers just
because a few snobs had the audacity to educate themselves and throw off the
delicate balance.

It'd still be fun to watch spammers squirm in agony, though. }:)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo



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



Re: Binary integers, IEEE Floating point numbers etc. - SOLVED!

2000-06-29 Thread Brandon Whitaker

I figured it out!

Thx again for the pointer, Steven.  I don't know if what I came up with is
the BEST solution, but it's running sub-10ms conversions.  Good enough for
what I gotta get done, and the smallish amount of programming knowledge I
have.

A great thanks to Jim Kahl ( http://nic2000.com/james/ ) for his unwitting
assistance in this one - he wrote it as a VB prog, but it made a sweet
translation to CFScript.

(/me hears the sound of Programmers cringing at the very thought...)

Source available if desired.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo



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



Re: Unsubscribe

2000-06-29 Thread Brandon Whitaker

>To avoid being unprofessional/tacky, I won't make any comments.

Fortunately, I'm both.  The idiot in question is a spammer looking for any
excuse to ply his spineless trade; I simply can't force myself to believe
that one person could *really* be that stupid and continue breathing without
mechanical assistance.

He's either a startup or simply not very good at what he does, as AltaVista
only located one other reference to ivh.com:

http://www.xrt.upenn.edu/training/PResidents.html

...and I'm sure that has nothing to do with our anonymous, unwilling guest.

Either way, killfiling him is the surest option; it's not as if we'll be
missing anything - aside from entertainment on par with the primate house at
the local zoo.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Re: Binary integers, IEEE Floating point numbers, and premature baldness.

2000-06-28 Thread Brandon Whitaker

Thanks for the response, Steve.

>What you really need is the IEEE format specification
>of the bit patterns.

I've looked at the spec; now I'm trying to figure out the best way to make
that happen in CF (or if it's possible...), but I thought someone else might
have done this already - thus saving me a bit of  legwork. :)

I did come across a page in which this was implemented in JavaScript - for
both 32- and 64-bit hex patterns, no less - so I'm confident it can be done
now.  It's more a matter of working out the details.

(if you're interested, the URL is:
http://babbage.cs.qc.edu/courses/cs341/IEEE-754hex32.html)

>If you have a lot of this data, I would consider using a simple
>VB app to do the transformation. This sort of bit banging in CF
>will be CPU intensive, at the very least.

That's my primary concern right now - there's not that many numbers that
need transformation per data set, but there could eventually be quite a few
datasets.  If I knew more VB, I'd jump on it; but I just got started with
that, and only insofar as building a couple of WDDX Database front-ends
(a'la Ben Forta's examples).  Perl was my first alternative, but it's
strictly verboten in my company.

Thanks again for the pointer and advice, though. :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Binary integers, IEEE Floating point numbers, and premature baldness.

2000-06-28 Thread Brandon Whitaker

Here's one for the cadre of real programmers, of whom I'm not a member:

I have a string of information - partially binary, partially ASCII - that
represents a number of reads from an electric meter.  The site name, dates,
etc. are stored in ASCII; record length & type designators in 2-byte binary
integers; and interval data is stored in 4-byte IEEE floating point.

I read this datafile in, using Lewis Sellers' ([EMAIL PROTECTED])
excellent CFX_binaryR tag, and process arrays of the resulting bytes for
display based on an ISO-standard datafile format.

Problem: Floating point conversion.  The ASCII is trivial (#chr(byte)#); and
I wrote a custom tag that converts the 2-byte binInts to decimal (anyone
interested?) - but the floating-point-to-decimal conversion has me pulling
out the remains of my already-endangered hair.

Anyone have any pointers on this?  CFX tags, formulae, anything?

TIA...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Re: Help with Frames

2000-06-26 Thread Brandon Whitaker

...Sorry about the truncated response, accidentally sent it before I
intended to.

Anyway, as I was saying:

Get rid of the  &  tags.  In a framset, the frameset tag
replaces the body tag; e.g.



  Hello.


  
  
  


   This site requires frames.  Upgrade your browser.



Since there is no body tag, you should include the  tag containing
info for browsers without frame support.

You can set the source of all frames to the same page without a problem, as
you did in your demo code; of course, it'd kinda defeat the purpose, but
that's your call. :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo

-Original Message-
From: Paige Chandler <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, June 26, 2000 9:23 AM
Subject: Help with Frames


>This is a multi-part message in MIME format.
>
>--=_NextPart_000_000C_01BFDF59.468B9760
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Hi All,
>
>I'm trying to use Frames for the first time. The examples indicate that =
>the following shoud display the page with 3 rows. Doesn't.  How does it =
>work?  TIA.
>
>Regards,
>
>Paige
>
>
>
>
>  
>  =20
>  
>
>
>
>
>--=_NextPart_000_000C_01BFDF59.468B9760
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>
>
>http-equiv=3DContent-Type>
>
>
>
>
>Hi All,
> 
>I'm trying to use Frames for the first =
>time. The=20
>examples indicate that the following shoud display the page with 3 rows. =
>
>Doesn't.  How does it work?  TIA.
> 
>Regards,
> 
>Paige
> 
><body>
><frameset =
>rows=3D"*,*,*">  <frame=20
>Name=3D"Row1" SRC=3D"Blank.CFM">  <frame Name=3D"Row2"=20
>SRC=3D"Blank.CFM">   <frame Name=3D"Row3"=20
>SRC=3D"Blank.CFM"></Frameset>
>size=3D2></body>
>
>--=_NextPart_000_000C_01BFDF59.468B9760--
>
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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



Re: Help with Frames

2000-06-26 Thread Brandon Whitaker

>I'm trying to use Frames for the first time. The examples indicate that =
>the following shoud display the page with 3 rows. Doesn't.  How does it =
>work?  TIA.

Get rid of the  &  tags.  In a framset, the frameset tag
replaces the body tag; e.g.


 
  Hello.
 
 
  
  


Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Re: Stored Procedure

2000-06-22 Thread Brandon Whitaker

>One thing you can't do in a stored procedure is set the ORDER BY to a
>variable, so you have to dynamically build the statement in your stored
>procedure.

Au contraire!
The following was pointed out to me by Oracle ubergenius Thomas Kyte, when I
posted the same message to comp.databases.oracle.misc: You CAN do a dynamic
ORDER BY ...by using a DECODE.  Or whatever SQL Server's equivalent is, if
not DECODE.

CURSOR testCursor(
   fooVar  NUMBER,
   orderBy NUMBER DEFAULT 1)
IS
   SELECT foo, bar, baz
 FROM fooTable
WHERE foo = fooVar
ORDER BY DECODE(orderBy,1,foo,2,bar,3,baz);

Passing 1 (or nothing, as it's a default) would order by FOO, 2 orders by
BAR, 3 orders by BAZ, etc.  I've never worked with SQL Server, but I'm sure
there must be something roughly analogous to this.

HTH. HAND.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo



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



Re: Bad cfml.exe ???

2000-06-22 Thread Brandon Whitaker

>I upgraded from Cold Fusion studio 4.0 to 4.0.1.

>I made no changes to the webserver (Website Professional).
>
>Any suggestions?

I can't help with the problem you mentioned, but I WOULD point out that - at
least when I was working with Perl -putting executables into a
public-accessable CGI directory was regarded a really, really good way to
let people execute arbitrary code on your system.

In other words, a big fat security hole.

I don't know if this is a no-no with CF, given that I have no experience
with CF on a non-NT environment; but I'd keep it in mind, unless you're
absolutely sure that's the right thing to do.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo



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



Newsgroups?

2000-06-07 Thread Brandon Whitaker

Newsgroups?

As in, 'why aren't there any ColdFusion...'?

There could be a whole Allaire group in the comp.* heirarchy...

comp.lang.ColdFusion.server.linux
comp.lang.ColdFusion.server.windows
comp.lang.ColdFusion.studio.linux
comp.lang.ColdFusion.studio.windows
(etc.)

...I'd personally prefer to start 'em in the alt.* heirarchy, but let's not
go there...

...Anyway, I was just wondering if this was something that someone had tried
that Allaire smacked down, or if there's really so few people that access
Usenet anymore that no one bothered...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Re: Duplicate messages

2000-06-07 Thread Brandon Whitaker

>As the guy said in Catch-22, "I see everything twice!"
>-David

That's it.  I'm re-tooling my database front end to track and thread
auto-reposts based on how many times the HouseOfFusion footer appears at the
bottom of the page...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Re: Another question on performance -- better than lists?

2000-06-07 Thread Brandon Whitaker

>your tests suggest looping through lists performs slower than other data
>structures. however, what about list functions like ListGetAt()? list
>functions are a large reason why i choose lists over arrays most of the
>time.

And what about indexed arrays?  How do they compare to the speed of
structures?

Is that even a valid comparison?

Either way, it's still a cool hack.  I was inordinately pleased with myself
when I figured it out - of course, as I found out later, I was a Loonng
way from being the first. :)

THEY CAN HAVE MY {
   var = array[(listFind(array[1],"foo")+1)];
   }
WHEN THEY PRY IT FROM MY MOLTEN, SMOKING CPU!!!1!

Hey, I was young...but really, anyone done any speed test on this sort of
thing?

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo

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



Re: CF vs. Oracle Application Server

2000-06-06 Thread Brandon Whitaker

>We are trying to make a determination whether to use Oracle Application
>Server or ColdFusion Application Server.
>Does anyone know where I can find a comparison (pros/cons) between the
>two products?
>Any personal comments will also be appreciated.

How about 100% personal comments? :)

I don't know of any such comparison on the web, as OAS is in a different
class than CF and plays to a much more limited audience.  In my personal
experience, OAS' ability to front-end PL/SQL packages for web work has
advantages, but they're outweighed by the inherent inflexibility of the
language.  I've never had occasion to make use of the Java extensibility of
OAS, so I can't comment on that - although I've heard it's a great
improvement over PL/SQL.  Ditto CORBA.

>From a performance standpoint, CF Enterprise certainly runs a lot faster.
Much of this may have to do with the fact that our OAS install was on the
same machine as the database and the PL/SQL packages it was utilizing, while
the CF server was on a different machine communicating via TNS.  I suppose
that's not really a fair comparison; but then again, lord only knows what
Draconian licensing rules Oracle might invoke for a seperate OAS server...

On the programming front, ColdFusion tends to be more flexible and
forgiving; the learning curve isn't nearly as steep as that of PL/SQL.
Around here they are (or were) deeply entrenched in Oracle and didn't bother
to explore other options; after some low-key CF evangelizing, I've converted
quite a few diehard PL/SQL developers to ColdFusion (at least for web
presentation purposes).

Support levels are just about identical; most support for CF is found in
free forums like CF-Talk or Allaire's (godawful slow) forums, while Oracle
support is freely available on the web, in Usenet, etc.  CF's documentation
is simpler; but then again, CF itself is far more simple than OAS.  And not
to sound like a shameless sycophant toadie, but Ben Forta's CF manuals are
FAR more instructive than the dry, by-the-numbers OAS manuals.

If you have to do anything with your local filesystem - read/write files,
etc. - CF is far easier to manage.  It has simple tags purpose-designed for
just that; Oracle has stored procedures that do the same, but they've got
that 'kludged' feeling about them...

Ditto for other internet protocols (SMTP/POP3/FTP).  Oracle has a package
with procedures to retrieve HTML remotely, as with , but it's
extremely primitive by comparison.

Ditto again for scheduling events.  Oracle can do it, but grudgingly.
(There's only so many times your DBA will make changes to INIT.ORA and
restart the server before he begins to get annoyed.)

OAS 4.0.8.0 turned me off in a big way when a very basic install turned out
to be nearly unmanageable; ORB services wouldn't start as they were supposed
to, listeners would go up and down without any apparent cause, etc.  Many of
these issues were supposed to have been resolved in 4.0.8.1; I'll never
know, because I'm not downloading > 100Mb of OAS via an Oracle FTP server
that refuses to give xfer rates over 140 BITS per second, whether you're on
a T1 or a 56k dialup.

(our most reliable Oracle & PL/SQL-based site here *still* runs off of
Oracle WebServer 2.0.2 and Oracle 7.3.3)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Re: Stored procedures and dynamic ORDER BY: answer(?) and question...

2000-06-06 Thread Brandon Whitaker

>The stored procedure seems to work fine, but the dynamic ORDER BY withing
>does not (eg.,):
[snip]
>What am I missing?

I had a similar problem myself, on Oracle 8i.  A quick post to the
c.d.o.misc newsgroup, and Tom Kyte (the God of Oracle, IMHO) provided the
following:

[...begin excerpt...]
> If you are trying to dynamically order based on a bind variable (you
> cannot parameterize an order by with a bind variable) you can try using
> decode(), eg:
>
> select * from T where x = :bv
> order by decode( :another_bv, 'C1', c1, 'C2', c2, 'C3', c3, ... )
>
> this works if all of C1, ... CN are the same type (so the decode
> returns all CHAR or DATE or NUMBER).  If it does not, you'll have to
> convert each type into something type comparable so they can sort
> correctly (the decode will return only 1 type of return type -- it
> won't return a number on one call and a string on the next call --
> it'll always return a string if it can return both a number and a
> string).
[...end excerpt...]

I'm not sure whether DECODE() is peculiar to Oracle, or whether that's a
general SQL thing (the SP code you included in your question wasn't
Oracle-ish...); but for the record, the cursor ends up looking something
like this:

CURSOR testCur(sortBy IN VARCHAR2) IS
   SELECT fooVal1, fooVal2, fooVal3
 FROM fooTable
ORDER BY DECODE(
   sortBy,
   'col1',fooVal1,
   'col2',fooVal2,
   'col3',fooVal3);

Thus, passing the cursor 'col1' as a variable orders it by fooVal1, passing
'col2' orders by fooVal2, etc.

Being trapped in PL/SQL hell for the last few months, I haven't had the
opportunity to play around with the CFStoredProc tag, but one question comes
to mind; if you're not returning the columns in the same way every time,
could that affect the operation of the tag?

Answers & questions...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo



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



Re: client mgmt on Oracle8i instead of MS Access

2000-05-31 Thread Brandon Whitaker

-Original Message-
From: Kellow, Jim <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, May 31, 2000 10:08 AM
Subject: client mgmt on Oracle8i instead of MS Access


>Does anyone have any information (or sources) that can tell
>
> me how to define client
>
>variables on an Oracle8i database instead of
>
>an MS Access database. I have it running on the MSA but for
>
>production would like to move it to the production DB.

Yep.

SQL> describe cdata;
 NameNull?Type
 ---  
 CFID VARCHAR2(250)
 APP  VARCHAR2(250)
 DATA VARCHAR2(4000)

SQL> describe cglobal;
 NameNull?Type
 ---  
 CFID VARCHAR2(250)
 DATA LONG
 LVISIT   DATE

Create these tables manually, then make sure you UN-CHECK the 'Create
tables' option when you're defining the variables datasource in CF Admin.

ALSO make certain you have the CF/Oracle Y2K update from Allaire before you
attempt this, or the LVisit date column in the CGlobal table will die
horribly.  It's available here:

http://www.allaire.com/Handlers/index.cfm?ID=13202&Method=Full&Cache=Off

HTH! HAND!

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo



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



Re: OT: Frames vs NoFrames

2000-05-31 Thread Brandon Whitaker

>>I use frames when it adds value to the user interface.
[snip]
>what is your opinion of frames?  likes dislikes?
[snip]

One interesting use I found for frames is that it simplifies forcing a user
to view a site (esp. a secure site) under a certain context.  For instance:
If your frameset (in index.cfm or whatever) is dynamically generated, you
can use a function like createUUID() to generate a unique name for your main
frame, e.g.



Then that UUID can be assigned, either as a client variable or in a cookie,
and referenced by every page loaded into that frame from there on out.  If
the UUID is different, the page isn't being viewed within the proper
context.  (This is also a good tie back to the use of JS-created cookies in
letting CF determine whether JavaScript is enabled on the client
browser...JavaScript in the frameset sets a cookie, then ColdFusion in the
pages loaded into the frameset check to see whether the cookie exists.)

You can also use JavaScript in an individual framed page to ensure that it's
being loaded in the frame, rather than as TOP (I'm sure you've seen this
before) and reload the site from the root if it's not.

Frames are useful for hiding the URL of the current page from the address
line; this is useful when you're passing CFID & CFToken in the URL string,
as with FuseBox-style apps.  This is obviously more of an aesthetic issue
than a security issue, as finding the 'real' URL is extremely trivial.

Framesets allow you to place an onUnload() handler in the FRAMESET tag which
deletes client variables immediately upon exiting the page; this is
impossible with a static page, as it would delete the variables every time
you navigate to a different page.  **DOWNSIDE TO THIS METHOD**: Nut$crape
reloads the page whenever the user resizes the window, thus triggering the
onUnload() handler in the FRAMESET tag and hammering the client vars.

Framesets can contain JavaScript routines and variables that persist
throughout the application and can be referenced from any page loaded within
the frame, as with Colin Tucker's 'OmenTree' heirarchal navigation app.

Frames have their uses.  Like almost anything else in HTML, they can also be
misused.  Some people will never like them; then again, some people still
insist that every page should be compatible with Lynx.  You'll never please
everyone.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Re: Connecting to datasource

2000-05-24 Thread Brandon Whitaker

>Why? Why does it work fine when I am not connected to the network but fails
>when I am?

I take it you've already run TNSPING to ensure that you can connect to
Oracle correctly, using the same SID specified in the CF datasource, when
you're connected to the network?

If so, does your network use DHCP?  If you're getting a different IP address
assigned to you when you connect to the net, that might throw off the
TNSNAMES.ORA (if the locations are specified via TCP/IP addy...)

I don't know whether either of those are helpful, or even necessarily
applicable...from a logical standpoint, though, it just seems as if the root
of the problem would be in the way the machine itself is addressed.

HTH...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo


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



Re: Javascript question

2000-05-24 Thread Brandon Whitaker

>I asked this question before but my email got deleted. How do you keep a
pop
>up window always on top of the main window.

Apparently, there's two ways of doing this: a universally correct way (modal
windows) and a slightly more flaky way that causes problems on IE3 & 4 on
Macs , via



The full dialogue on this, modal windows, and many other interesting
JS-related topics can be found at:

http://developer.irt.org/script/222.htm

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo



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



Re: tons of white space

2000-05-23 Thread Brandon Whitaker

>Does anybody know why a server would add miles of white space to a web
>page? Our site runs on CF4/Apache/Solaris. Thanks!

It's adding a blank line for every CF tag that's being processed, but not
shown.

Try the following:
(at the beginning of the document)


[content, tags, etc.]



Downside to this: It will ONLY display content appearing between 
and  tags.  That goes for anything you might CFInclude into the
page as well, so take care.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore
"I'm sorry, I can't hear you.  God just sat on my Whoopee Cushion."
- Kibo



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



Re: css and coldfusion

2000-05-20 Thread Brandon Whitaker

>I know this may be a bit OT but Im trying to use cfinclude to incorporate
>css in my pages but for some reason the hover action (underline attribute)
>is only working for some links, not all. I am using the following code for
>the CSS:
>


I had this same problem myself, Shane...it has to do with the order in which
you specify the styles; if you specify a hover BEFORE the visited, 'visited'
attributes will take precedence over 'hover' attribs.

Try this order and see if it helps:
a:link {attribs}
a:visited {attribs}
a:active {attribs}
a:hover {attribs}

HTH! HAND!

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: New Virus [loveBug copy] *.*

2000-05-20 Thread Brandon Whitaker

>   Internet Worm

Look, just because Mr. Adkins doesn't play well with others, there's no
reason to resort to name-calling.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Will the last person leaving Cold Fusion please turn out the lights?

2000-05-17 Thread Brandon Whitaker


Well, it was a good run, but I guess this pretty much
wraps it for the PC.  Not too many people are going to
want to bother with it given that now they can get an
Apple Lisa for about the same amount of money.


Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Kind Of Off Topic

2000-05-17 Thread Brandon Whitaker

>I was hoping that nobody would notice my mistake - thanks for proving me
>wrong :-)
>
>Howie

Actually, I wasn't doing it to point out a mistake so much as just passing
along the (vaguely) amusing idea it inspired.

No harm, no foul. ;)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Kind Of Off Topic

2000-05-16 Thread Brandon Whitaker

>From there you can extrude the domain name and such.

Extrude?

Mental picture: large "Boss Tweed"-like character cranking a meat grinder
labelled 'NSI', bags with prominent dollar-bill signs being fed into the
top...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: "You have nice cookies .. mind if I have a look?"

2000-05-16 Thread Brandon Whitaker

>However ... friggin' frackin' Microsoft!!!

If someone's complaining about security, it's a MS browser.
If someone's complaining about anything else, it's a NS browser.

At this point, I'd tend to agree with you about the likelihood of this hack
being exploited to any significant gain; OTOH, there are a lot of people who
aren't given much option as to whether cookies are enabled or disabled.
Many IT departments centrally manage security settings; if they don't want
cookies, you don't get to use them.  It all depends on the audience you're
addressing.

In the past, I've used cookies only for allowing CF to test JavaScript
functionality on a user's browser.  Any variables that I'd want to persist
between sessions are stored in the DB, and clients log in.  Again, not
everyone has the luxury of doing that (but if you do, it's worth
consideration...).

At any rate, I'd have a real problem with anyone, anywhere, who would use
cookies to store potentially-sensitive information.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: "You have nice cookies .. mind if I have a look?"

2000-05-16 Thread Brandon Whitaker

>I thought cookies had to be enabled for session scoping to work?
>
>H.

Not if you pass them as URL variables.
http://www.foo.com/bar.cfm#URLTOKEN#">

Ugly, but it works.  Works even better if you're navigating via forms, so
you can POST vars from one page to another in hidden variables & keep them
out of the address.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Slightly OT: Lighten things up a little

2000-05-16 Thread Brandon Whitaker


>They contain Ma Huang Extract

Why bother with all that other herbal garbage...THIS is the important part,
here.  Good ol' epehedrine hydrochloride!!! YAY!!!  This stuff is to your
body what a supercharger is to a smallblock Chevy.

Ignore those heart palpitations, they're totally normal. }:)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: "You have nice cookies .. mind if I have a look?"

2000-05-16 Thread Brandon Whitaker

>Might want to be extra carefull what you store in your cookies from now on,
>ladies and gents.  Or .. if you are the naughty kind of CF developer, I
>suppose you could take advantage of this ...

Yet another argument in favor of CF session-based security.

THAT'S IT.  I'M TOSSING MY COOKIES.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Slightly OT: Lighten things up a little

2000-05-12 Thread Brandon Whitaker

>>I'd have to go out and get a life,
>>and I hear those are expensive.

>I hear you can get one on Priceline.

Oh, THANKS...nothing completes an atrocious McDinner like mental images of
William Shatner pimping YET ANOTHER Priceline service in full beatnik
regalia.

Although the amount of time required to coach Shatner into conveying the
concept of a LIFE might encourage Priceline to hire someone else for the
job...

"You dirty Priceline bastardsyou've KILLED my CAREER!!!"
 - William Shatner, upon learning that he's been fired in favor of Paul
Reubens.

The above quote is brought to you courtesy of , a tag
which someone may eventually write, mentioned here for the sole purpose of
maintaining list topic integrity.  Sorta.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: (VERY OT) Re: Slightly OT: Lighten things up a little

2000-05-10 Thread Brandon Whitaker

>> Hmmm .. but what would Brian Boitano do?

> Let's just skate by that one... 

 You're on thin ice, here... 

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re:

2000-05-09 Thread Brandon Whitaker

>Where is the best place to find custom tags?

Allaire's dev area is still the best I've run across for that sort of thing.
You might also check Lewis Sellers' IntraFoundation.com site, depending on
what kind of search you're looking for.

HTH...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Slightly OT: Lighten things up a little

2000-05-09 Thread Brandon Whitaker

>You know you're a ColdFusion programmer if you...

>- Refer to the book as CF WACK

- Have ever been photographed carrying CF WACK & CF AD like the Ten
Commandments.
- Blow up POSIX code by habitually double-bracketing character classes.*
- re-wrote the CFID/CFToken security routines in a less-worthy language,
just so you'd feel comfortable with it.
- DON'T confuse Oracle TO_DATE() format codes with CF Date Format codes.
- Have a bumper sticker reading 'WWBFD'.
- CFInclude stylesheets.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore

*note: I don't know if that really WOULD blow up POSIX code, I'm just
guessing.

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



Re: Thank you for choosing Smart Web Tech .............

2000-05-03 Thread Brandon Whitaker

>what have I learned from this thread?



>Could we possibly remove intolerance from the list?

So what you're saying is, you can't tolerate intolerance? :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Microsoft MSDN "Bug"

2000-05-03 Thread Brandon Whitaker

>and then i said "WOW THATS THE BEST CF SECRET EVER" and we went out
>for sodas!

Orbitz.

>Bye!

HAND!

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Technical Documentation

2000-04-28 Thread Brandon Whitaker

Erika:

>I'm interested in knowing what kind of documentation everyone provides
their
>clients as well since I'm delivering my first product on Monday morning.
>Since no one has replied to this post, I'm wondering if anyone PROVIDES
>documentation??

I've normally relied primarily on extensively-commented code; this has
worked out well because the clients I've dealt with thus far had a fair
degree of technical proficiency (albeit in other languages).  This, of
course, becomes useless if (a.) you're encrypting your code, or (b.) the
client lacks the technical skills required.

In my case, the better part of any external documentation that became
necessary could be cut-and-paste with minor modifications from the code
itself.

Duane:

>(although we are going to be looking for a full time tech writer with CF
>experience in the future)

How much does a position like that pay (roughly)?

>Sleep - must get sleep .

Found elsewhere:
SLEEP (slep) n. A hopelessly inefficient and inadequate substitute for
caffeine.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Very, Very weird problem

2000-04-27 Thread Brandon Whitaker

Question...I don't know if this would solve your problem, but have you tried
writing both queries into one, rather than performing a query, building a
list, then passing the list to the second query?  Something like this


 SELECT Students.ID, Students.Name, Students.email,
Courses.IDCourse, Courses.CourseName,
SCourses.IDStudent, Scourses.IDcourse
   FROM Students, Courses, Scourses
  WHERE Students.ID IN (SELECT DISTINCT IDStudent
FROM SCourses
   WHERE IDCourse IN (#ID#))
AND Scourses.IDStudent = Students.ID
AND Scourses.IDCourse = Courses.IDCourse


Aside from that, I'm kinda stumped...the weird part is its tendency to stop
after 8...

Of the student IDs in the list you originally provided, have you tried
running the query against each of them individually to make sure they're
returning the proper data? (i.e. WHERE Students.ID = #ID#)...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: This list has definitely gone nuts

2000-04-27 Thread Brandon Whitaker

>At 04:54 PM 4/26/00 -0500, you wrote:
>>I've been getting duplicates now and again today as well.
>>
>>(Mind you, I don't have a lot of faith in my mail server, so Jennifer may
be
>>right)
>
>I am subscribed to different house of fusion lists at addresses at two
>different mail servers, and as much as I don't have much faith in the one
>where I get cf-talk, I haven't had this problem with any lists that I'm
>subscribed to.

Mine was running perfectly until last weekend, at which point I started
receiving 4+ copies of each message.

I hadn't changed a thing.  Personally, I thought I had just annoyed enough
people to get mailbombed, but apparently that's not the case.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: HEY! Have I been swindled?

2000-04-27 Thread Brandon Whitaker

>>In Ben Forta's book, Web Application Construction Kit, he has a whole
>>chapter on Crystal Reports and another on using Versions 2.0, both of
>>which he says are shipped with ColdFusion.
>>
>>Not in mine.
>>
>>Was I swindled?   Was Ben mistaken?  Has the policy of inclusions changed
>>since then?

I purchased the Enterprise version of 4.0, and there was no CR in there...at
least, not the frontend designer tool.  Apparently, an essential part of the
CR engine is built into the ColdFusion executables; you use Crystal Reports
to design the report, then you embed the path to the report on your hard
drive into a CF template (think CFInclude...).  The CF Engine executes the
report, and returns the output as HTML.

Whatever.

Personally I fail to see the logic, but I suppose that it would help by
allowing non-HTML designers on staff (READ AS: Accounting Wonks Who Don't
Know Jack About Tables But Are UTTERLY ANAL About Their Reports) to design
the reports as they want them to appear, thus freeing you to do more
important things.

Like getting Freeman out of Black Mesa again, for instance.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: unsubscribe

2000-04-27 Thread Brandon Whitaker

>usubscribe

Indeed, I do.  Do u?

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: What happened to this list?

2000-04-26 Thread Brandon Whitaker

>I just got one thing to say, "How's the family?"
>
>Sharon "the Hammer" DiOrio
>
>At 02:40 PM 4/24/2000 -0400, Olive, Christopher M Mr USACHPPM wrote:
>>hey, who was asking for a Sicilian CF developer?  are you insulting my
>>people?

Hey, paisan, nothin' but respect from this end. :)

Brandon 'The Geek' Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: What happened to this list?

2000-04-25 Thread Brandon Whitaker

>Isn't it a little backwards to write M$ code in a Unix editor???
>
>Justin Kidman

DINGDINGDINGDING!!! Give that boy a cigar!

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: What happened to this list?

2000-04-25 Thread Brandon Whitaker

>It could be a she.


Nah.  A 'she' wouldn't have stopped with disparaging remarks about job
performance. }:)


Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Database Failover

2000-04-24 Thread Brandon Whitaker

>Here's my situation.  The client wants support for disaster and fail over
>on both the web server and database side.

Are they using any kind of clustering?  If so, the CF server would point at
the 'virtual' server presented by the cluster, and the status of the
database on the back end would be irrelevant (to the CF server, anyway...)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: What happened to this list?

2000-04-24 Thread Brandon Whitaker

>This is a good idea, as long as people don't get carried away.  People tend
>abuse such power, a la, Salem Witch Hunt Trials.  My analogy is a bit
>extreme maybe, but overall you have a good idea.

Given the litigious society we live in at the moment, I don't know whether
anyone would want to open themselves up to a libel/slander/defamation of
character suit...of course it's hard to see how anyone could have the nerve
to press a suit like that, but then again weirder things happen in the
courts every day.  And anyone who was weasel enough to have done this in the
first place certainly has low enough moral standards to whine to the nearest
attorney (who will undoubtably drool at the prospect of the media frenzy to
be had in an INTERNET LAWSUIT..)

Now on the other hand, if anyone knows any Sicilians of the sort favored by
Mario Puzo, perhaps a more appropriate & expedient punishment could be found
for the offender...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: What happened to this list?

2000-04-24 Thread Brandon Whitaker

>It was me!!!
>
>Now beat me!!!
>
>Beat me like the bad boy that I am!!!
>
>ooops.
>
>Wrong list.
>
>-- Ric Smith

I thought a CF_Masochist would say something more along the lines of 'beat
me, whip me, make me write ASP in vi'

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: SQL.LIKE question

2000-04-24 Thread Brandon Whitaker

>  I'm _Sorry_ for my poor English.

No worse than some native English speakers I could mention, so no apology
necessary. :)

>  Simple code:

Whenever I've used LIKE in the past, I've never used parentheses around the
expression; it was always expressed as

SELECT foo FROM bar WHERE foo LIKE 'baz';

...granted, that's just on Oracle.  Access might differ.

Have you tried it encapsulating each expression of your match in
parentheses, like below?

WHERE (vchTitle LIKE #PreserveSingleQuotes(sql_search_string)#)
OR  (vchKeywords  LIKE #PreserveSingleQuotes(sql_search_string)#)
OR  (txBody   LIKE #PreserveSingleQuotes(sql_search_string)#)
OR  (vchDesc  LIKE #PreserveSingleQuotes(sql_search_string)#)

HTH...HAND.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Question about Netscape

2000-04-24 Thread Brandon Whitaker

>I am doing a form to query information from a database (access).  Having it
>return information in text boxes.  Well it works just fine in IE but, when
>it goes to display the returned information in netscape.  It does not show
>up, but in the view source it is there.  Just not showing up.  Any ideas
>what the problem could be other than netscape has went down hill.  I am
>using 4.7 netscape.

1.) Are you using CSS?
2.) Are any/all of your table cells closed correctly before the data is
supposed to display?
3.) Is the data being ouput using some obscure JavaScript write() routine,
or is it just plain ol' HTML?

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Proper Case?

2000-04-24 Thread Brandon Whitaker

>Supposing I am getting an output of a query. If the
>company name in the database is :
>
>THE GOOD COMPANY INC
>
>How do I convert it to:
>The Good Company Inc
>
>Appreciate
>AB

I don't suppose you're using an Oracle DB, are you?  That's as simple as
"SELECT INITCAP(foo) FROM bar"...

Other than that, I believe you have to lowercase the entire string, then
loop through it and cap the first letter after each space...

HTH

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: New Public Beta Release of exciting new automatic FORM CREATION tag!

2000-04-24 Thread Brandon Whitaker

>Hello,

HI!!!

>I am excited to announce 

I am equally excited to announce your arrival in MY BRAND-SPANKING NEW
KILLFILTER!!!  You're ##1!!! (note careful use of TWO pound signs!)

How about a custom tag for THAT function?



Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Cfhttp error?? help?

2000-04-24 Thread Brandon Whitaker

> Is there something wrong in my Code?

Running your code from here, it works fine, other than that the page
returned from Yahoo is an error page (it apparently doesn't support the POST
method, try GET instead.)

Can you contact this page from the server console?  If the server itself
can't reach the site, CFHTTP won't be able to, either.

If you can reach the site from your server's console, does your server use a
HTTP Proxy?  If so, that proxy address:port needs to be specified in the
CFHTTP tag.

Other than that, it seems to work just fine....

HTH. HAND.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: What happened to this list?

2000-04-24 Thread Brandon Whitaker

>I am demanding that you post his name to the list. It is a disservice to
the
>rest of us if you let him keep his anonymity. Let him suffer the global
>consequences for his actions. If there's a fox in the hen house, we all
have
>a right to know who it is and adjust accordingly.

Umm...'scuse me, but in the spirit of repeated requests to return this list
back to its formerly non-confrontational state, do you think you *might*
consider backing down off the Torquemada routine a little bit?  I want this
jackass outed as much as you, and MANY here have voiced a similar desire -
but making brash (and futile, and impotent) "demands" is more likely to
dissuade compliance than encourage it.

If Dr. Kiel wishes to share the name of the misbegotten little rat sh*t with
us, he will.  If he doesn't, he won't.  It's that simple.  Ultimately the
decision is his.

To Dr. Kiel: put yourself in our positions - you know you'd want to feel
like you could safely ask a simple question without some underhanded little
trouser-stain putting your job at risk.  I can see how you'd find it a point
of honor to place yourself above this person - that revealing his name would
be invading his privacy and, in some way, might put you on the same moral
level as him.

This isn't the case, I assure you.  This person, and anyone like him, is a
threat to the community we have set up.  HE chose this road; you're not
burning his privacy, your helping the rest of us maintain our OWN privacy.

Respectfully,

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: "Able Commerce knock-off"

2000-04-24 Thread Brandon Whitaker



>The guy has already apologized for it.  Drop it please.

Consider it dropped.  I hadn't received that message at that point; when
combined with 48 straight hours of being force-fed PL/SQL for a project far
better served by CF, I guess it just brought out the smartass in me.

We now return you to your regularly-scheduled Mozilla-thrashing. :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: OT Javascript Detection

2000-04-23 Thread Brandon Whitaker

>Is there a way to detect whether a browser has scripting turned on?

I've used JavaScript to set a cookie, then attempted to read that cookie
with CF on the next page...no cookie, no JavaScript.  Of course, this
implies an extra step, so it's not an all-around solution.  It worked well
in my situation because the entire page was loading into a frame (one
column, 100%, no border...), so the index with the 'frameset' created the
cookie, then the page loading into the frame detected it.  Kludged, but
effective.

HTH. HAND.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: How do I carry an Array over to another page? - HELP!!!!

2000-04-23 Thread Brandon Whitaker

>Pop the array into a Structure, serialize the structure with CFWDDX and
pass
>the WDDX packet to your next page.  Then deserialize the WDDXPacket on the
>next page and voila.  You have your array.

But whatever you do, don't do as I did the first time I fiddled with WDDX,
and attempt to pass it as a URL variable. :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Help with grabbing data

2000-04-23 Thread Brandon Whitaker

>For those who feel I'm a trader to CF, I like to reserve CF Server and it's
>scheduled tasks for the critical web apps, not for what I consider to be
>internal housekeeping.

Hey, making a reasonable suggestion doesn't make you a traitor by any
stretch of the imagination.  It's important to know which tool to use for a
given job; in the case Mr. Dinsmore mentioned, CF might not be the right
tool.

On the other hand, I've discovered that you can use CF for some
obnoxious/cool automated projects, too...like screen-scraping 5 years' worth
of hourly weather data for every reporting station in a four-state area from
NOAA's website.  (scrape a screen, increment the date, use a javascript
timer to submit the form back to itself with the new valuesetc. etc.
etc...)

To paraphrase something I read elsewhere: It's all about choosing the proper
wrench to pound in the correct screw.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: "Able Commerce knock-off"

2000-04-23 Thread Brandon Whitaker

> Do you really want to purchase from a product that is so obviously built
> while looking at the AbleCommerce Builder product?  What does this say
about
> the company?

(AbleCommerce Marketing Guide, Step 1: Question competitor's ethics for
DARING to model their offering on your own flagship product.)

>The fusebox "like" AuctionBuilder product is ONE example of the future of
>our products, which we are releasing many this year.

(AbleCommerce Marketing Guide, Step 2: Hype your product by comparing it to
the well-known and widely-used standard you modeled it on.)

Am I reading your intent incorrectly, or did you just attain Zen-like
balance by perfecting a 1-to-1 foot/mouth ratio?

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: UNSUBSCRIBE

2000-04-20 Thread Brandon Whitaker

>eww an 3LiTe Hack3r

No, no, no, NO!  You haven't been keeping up with the Attrition.com mirror.

it's 3l33t haxOr.

I'm still trying to figure out if the originator of this thread was serious
or not...

>Having a bad day?
>Imagine this...
>
>You are in total seclusion from that hectic place called "The World".

"You are in a maze of twisty little message threads, all different..."

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Application.cfm & javascript

2000-04-13 Thread Brandon Whitaker

>Anyone know of any limitations for using javascript within an
>appplication.cfm file?  I am trying to open a pop-up window for user
>authentication if a condition is false, then close the window once
>authenticated.  It seems to SORT OF work, but the pop-up window seems to be
>looping on itself...STRANGE!!

Lets see:
You have a script in your application.cfm.
If a variable evaluates false, it opens a window.
The script opened in the window will ALSO access the application.cfm first,
and the value will STILL be false because the proper authentication hasn't
been passed - so it'll keep opening it.

One solution: put the document that's supposed to appear in a subdirectory
with its own application.cfm.  This application.cfm can't be blank, but it
should be harmless; put something like:


in there.  When the popup window loads the document from this subdirectory,
it'll read the application.cfm in that directory and stop there, instead of
parsing the one in the root and going into an endless loop.

HTH!  HAND!

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Who Said netscape is dead & as for People dressed in black wearing berets.....

2000-03-31 Thread Brandon Whitaker

>> > "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>>
>> Good Gdd Mn!!!  Its Dave Watts everywhere :-)
>>
>> Now... off to list my beret on Ebay.
>
>Actually, that's not me. I think it's Brandon Whitaker. I never use all
>caps.

Hey, only ONE word there was all caps.

I can't be sure, but I think the implication here is that you identify your
tool by its smaller size...?

}:)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Who Said netscape is dead & as for People dressed in black wearing berets.....

2000-03-29 Thread Brandon Whitaker

-Original Message-
From: Stephen M. Aylor <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, March 29, 2000 12:18 PM
Subject: Re: Who Said netscape is dead & as for People dressed in black
wearing berets.


>> Rey
>> Certified Allaire Instructor
>> Member of Team Allaire
>>
>> "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
>
>
>Good Gaaaadd Mn!!!  Its Dave Watts everywhere :-)

?

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: CFTry Question

2000-03-29 Thread Brandon Whitaker

>How do I return a success from CFTry?

>I have wrapped cftry around a cfflile call to intercept error messages if
>the file can not be updated but I want to return a success message if the
>was no errors. Here is what I have:
>
>
> 
> 
> The file could not be updated. File is locked or read only.
> 
>

In the CFCatch block, put in a  at the end of the 'The file could
not be updated...' statement.  That way if there's an error it would stop
there, if not it would pass through to the end...the success message would
appear after the .

You could also use a CFLocation tag within the cfCatch block to redirect to
the error message (and further processing) if the catch block is triggered.

You could:
...
   
  
   



...HTH. HAND.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: CFSCRIPT

2000-03-29 Thread Brandon Whitaker

>Is CFSCRIPT faster than regular coldfusion coding or is it just easier to
>write so you can get something done faster?

>>Yes. :)

>Faster for variable assignment but slower when looping so I am led to
>believe.

I was chomping at the bit to refute this, in the fine tradition of Usenet
Holy Warriors everywhere.  Perhaps it's my ever-increasing age, but
something told me to check this out for myself before getting my undies in a
bunch.

For the edification of all, the following is the actual code I used to
perform the test, along with the results.

## loopTest1.cfm ##

   SELECT wban, stationname, station_id, state_id, icao_id
   FROM w_stations



   tick1=getTickCount();
   counter = 0;
   for (i=1; i LTE testQuery.recordCount; i=i+1) {
  if (len(testQuery.icao_id[i]) LT 4) {
 counter = counter+1;
 }
  }
   tick2=getTickCount();
   finalTick=tick2 - tick1;

#counter##finalTick#

## loopTest2.cfm ##


   SELECT wban, stationname, station_id, state_id, icao_id
   FROM w_stations





   
  
   



#counter##finalTick#

Final results:

Both loops counted to the proper number, 752.

RUN ONCE:
The cfScript method: 485 milliseconds.
The  method: 141 milliseconds.

RUN 10 TIMES:
cfScript method average: 212 milliseconds.
 method: 138 milliseconds.

*sigh* live and learn. :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: CFSCRIPT

2000-03-29 Thread Brandon Whitaker

>Is CFSCRIPT faster than regular coldfusion coding or is it just easier to
>write so you can get something done faster?

Yes. :)

I can't remember exactly where I saw the article (I could've sworn it was in
Fusion Authority WNA somewhere, but I couldn't find it this morning), but if
I recall correctly, CFScript was faster from a performance standpoint if you
were evaluating more than one or two variables in a row using the CFSet
method:



... was said to be slower than:

  foo='bar';
  fred='barney';
  gargle='blaster'


...and so on and so forth.  I use it for as much procedural code as I can;
it's got all the looping functions, case/switch functionality, and (to the
eye of this long-time Perl junkie), it's a lot cleaner. :)

HTH. HAND.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: Easiest way to get a text file into a List?

2000-03-28 Thread Brandon Whitaker

>  Lucky you!  It is already a list, only it is delimited by carriage
returns


And since you also asked about arrays, you can do essentially the same thing
that Chris specified for lists by using the listToArray function like so:



This creates a 1-dimensional array with one line of text per array item.
This comes in REAL handy when you're working with comma-separated (CSV)
files; you don't want to change the delimiters to a comma in order to
maintain the 'column' structure, so you turn it into an array, then evaluate
each array item as an individual list.

It's a needlessly complex method for what you're trying to accomplish, but
it might come in handy later. :)

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: CFIF Problem with OR

2000-03-24 Thread Brandon Whitaker

>What is wrong with this statement?
>
>OR (ID IS NOT "43")>
By using 'OR', you're saying it could be any of them, as long as it ain't
ALL of them.  Obviously it can't ever be all of them, and therefore it will
always evaluate true.  Try this instead:



Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore

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



Re: linux, oracle8, & date functions

2000-03-24 Thread Brandon Whitaker

CORRECTION NOTICE.
This is what I get for being in a hurry

The code I included to use CF & SQL to_date has a problem...the 'mask' in
to_date() should read

'/MM/DD HH24:MI:SS'

The minute designator in my first message, 'MIN', is wrong.  Sorry 'bout
that...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore



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



Re: Strange CF bug

2000-03-24 Thread Brandon Whitaker

>You need to upgrade your MDAC drivers, possibly even install the latest SQL
>7 service pack.

Well, like the man said, it's his ISP...and if you've dealt with one 'o them
before on a service issue, you know that they're ALWAYS thrilled about
updating their software on a customer recommendation. >;)

Dick: Is there any way you could set a default value for a #SearchWords#
variable that's null?  Say, something like a


   

...or something like that.  It's ugly, it's a kludge, but sometimes you do
what you gotta do...

HTH. HAND

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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



Re: linux, oracle8, & date functions

2000-03-24 Thread Brandon Whitaker

>what's the proper syntax for putting a date into an oracle database on
>linux?  i've already tried #CreateODBCDateTime()# and got an oracle error
>type 911, whatever the heck that means.  anybody work with oracle on linux?

Oracle's date/time is just...well, it's different.

Say you've got a CF date/time object...like now(), for instance.
Oracle doesn't know anything about ODBC datesit has its own little thing
going on, using

to_date('date/time','mask')

The date/time is a numeric, as you'd see displayed on a page; i.e.
12/24/1999 14:40; the 'mask' is exactly that, a mask set up using Oracle's
mask identifiers, matching the way your actual date/time value is laid out.

Example: Say you're wanting to put now() into an Oracle database, in a
column named timeColumn.

The obvious answer would be to SET timeColumn=sysdate...but you're a
masochist (or you wouldn't be using Oracle in the first place, like I am.
:) )  So you insist on doing it the hard way.

The following is a nasty amalgam of the CF and Oracle To_Date needed to
accomplish this.

UPDATE myTable
SET timeColumn =
   to_Date('#dateFormat(now(),"/MM/DD")#
#timeFormat(now(),"HH:MM:SS")#',
  '/MM/DD HH24:MIN:SS')
Note that the mask was laid out in the exact same pattern as the date/time
would appear when produced by the coldFusion tags; including the delimiters
(/ and :) and the space between date and time tags.  Note also that Oracle's
date/time masks are LIKE ColdFusion's, but they're not IDENTICAL.

Just for the sake of completeness, here's a list of Oracle's more
commonly-used masks.
MASK = TYPE (EXAMPLE)
DATE FORMATS:
---
MM = Numeric Month (12)
MON = Three-letter abbrev. of month (AUG)
MONTH = Fully spelled-out month (AUGUST)
DDD = Current day of year since Jan. 1 (354)
DD = Current day of month (24)
D = Current day of week (6)
DY = Three-letter abbrev. of day of week (FRI)
DAY = Day fully spelled out (FRIDAY)
 = Full four-digit year (2000)
YY = Two-digit year (99)
Y = Last digit of year (9)

TIME FORMATS:
---
HH12 = Hour in 12-hour format (2)
HH24 = Hour in 24-hour format (14)
MI = Minute (30) (NOTE: this one screws up most people)
SS = Second (59)

There are MANY others, all of which you can find in yer Oracle docs.  I just
didn't feel like typing 'em all in (four-digit year from ISO standard?
pleez...).

HTH. HAND.

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


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