RE: Making a form text input box "active"

[Kevin Queen]

Try setting the tab-order to 0 for IE, or add a set focus to the form item
in the on-load.

-Original Message-
From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 02, 2001 3:48 PM
To: CF-Talk
Subject: OT: Making a form text input box "active"


I'm working on a simple form page to lookup items based on a sku number.
There's a text input and a SUBMIT button.  The page is eventually going to
be used on a PC running IE in kiosk mode, and I want to eliminate the mouse.
I want the text input box to be active by default, so a user can just type a
sku number and press ENTER.

A real quick and dirty version of the page is at
http://www.cornells.com/storelink/item.cfm.

I did some quick browsing in some of my HTML references and can't find a way
to do this.  I haven't done much Javascript, but maybe there's a way to
solve this problem with JS? ANy suggestions would be appreciated.

Thanks!

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

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

SQL SUM Question

[Kevin Queen]

List,
If I run the following query:

Select Number from Tbl_Numbers SUM(Number)

how can I oputput the SUMed variable in a cfoutput?

TIA,
Kevin Queen

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

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

OT: JRun list

[Kevin Queen]

Does anybody out there know of a JRun list that is not "for archival
purposes only"?  I am going nuts and need some help.

Kevin Queen
Technical Support Analyst ||""||
AnyDevice.com ||__||
Atlanta, Ga   [ -=.]
(404)231-3539 ===:0~
http://www.anydevice.com

"Ah, I see!", said the blind man to the deaf mute.  -Unknown



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

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

Frames

[Kevin Queen]

The BEST way to create a 4 window frame is like this :


Main.htm
--




--
Left.htm
==



==
Right.htm
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-




=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Should produce this:

||--|
||  |
| Logo   |  Headers |
||--|
||  |
||  |
||  |
||  |
||  |
| Links  |  Main|
||  |
||  |
||  |
||  |
||--|



Right?



TIA,
Kevin Queen

"Ah, I see!", said the blind man to the deaf mute.  -Unknown
 

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

WAY WAY OT: Windows NT

[Kevin Queen]

List,
I know that this is a stretch but I need to get this figured out and thought
that somebody might be able to point me to a web page or something that
might help me here.

Problem:
I have a box that was on Win2k, I found it to be slow and cause broadcast
storms on my network, I 'upgraded' to NT4 on Sunday and lost my partitions
(2GB Sys, 7 GB File Share, 1 GB Other) now I know I was supposed to loose
them, but on Sunday I somehow got them back!  So last night I realized
that the 'upgrade' had given me a box that was not on the network or in any
domain, I figured that the easiest way to fix this was a reinstall, so I
did.  Now I have my System Drive (2 GB) and then icons for D: and E:, but
they are not shared, unassigned in Disk Administrator, and I get an explorer
error when trying to access the partitions.  I have an ERD, but going
through the Setup and Repair option did not work and Disk Admin tells me
that there is no disk data on my ERD.  HELP PLEASE, I have 6 GB of data on
one of those shares (and I know that I should have Backed up, but...), I
know that there is a way to get them back as I did it Sunday but am unsure
as to what I did.

Whoever gets this one can come to GA and have a beer (or 12) on me some
day!

TIA,
Kevin

P.S. if you wish to flame me for the OT post please feel free.


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

OT: WAP, WML, and Mobile Devices

[Kevin Queen]

List,
I have a client that would like to make their site wireless accessible.  I
was wondering if anybody knew of the limitations of the wireless
devices(Palm, SMS Phone/Pager, WML Phone, HDML Phone, RIM) or better yet,
where to find this information.  I am aware of the picture, and image map,
and memory restrictions I am looking for things like what style attributes
and HTML tags will/will not work with what devices etc...  Any and all help
is very appreciated as I really don't know where to start on this one.

TIA,
Kevin Queen


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

CFPOP

[Kevin Queen]

List,
I am currently trying to create an e-mail client.  I have a couple of
questions that I thought were easy but... First, is there a way to reverse
the message header order, I am currently getting the oldest message first, I
would like to display the newest first.  Secondly, I would like to format
the date down to just dd/mm/ but the dateformat function will not work,
am I going to have to trim out the extra information?
TIA,
Kevin Queen


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

RE: pointing different domain names to different sub directories on the one server

[Kevin Queen]

Interland does this so that they can still make money, if you were allowed
to map to sub-directories then you could take your 100MB of disk space and
sell off 9 10MB chunks with domain names and charge say 19.95/mo to each of
those 9 customers.  This gives you about $180 per month and you are only
paying Interland 19.95/mo.  Bad business for them to make you their
competitor, no?  I am not trying to flame anybody, but as a former Interland
employee this gets drilled in to your head in training. :)

P.S. - I won't even host my personal website on servers that crash on a next
to daily basis and are NEVER backed up, you can tell, if you loose something
and call to ask for a restore the line you will get is one of 3 things:

1. That will cast you $500
2. We will contact the backup operators and get that done for you.
3. We're sorry but the backup media that contained your data was corrupted.

The Truth - THEY ONLY BACKUP THE SERVERS 2 TIMES A YEAR.  This was about two
months ago so they MIGHT have changed that.

Kevin Queen

-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 11, 2000 10:59 AM
To: CF-Talk
Subject: Re: pointing different domain names to different sub
directories on the one server


interland came back and told me it would coast me 450 per month to upgrade
to a higher level service in order to be able to have the multiple domains
pointing to specific subdirectories

my solution at this stage is to create a splash / doorway page for the site
and have on it links to either the Australian site which will point to its
own directory and a link to the nz site and it points to its own directory
and solve the problem that way

your comments please

- Original Message -
From: "netman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 10, 2000 9:59 PM
Subject: Re: pointing different domain names to different sub directories on
the one server


They are correct in there setup, but there are hosting companies out there
that offer ipless hosting which will allow multiple domains setup to 1 ip,
but different directories.  It just so happens that I am the proud owner of
a company that offers this hosting.  We give you 1 Ip address and will allow
for 10 separate domains to be setup to 10 different directories, email me
and I can give you further details and show you the reliability of our
hosting network.  [EMAIL PROTECTED]

The short answer is that this is possible, but probably not with your
hosting company, so consider giving my company a try...

Robert Filipovich,
ATSWebNet


- Original Message -
From: "AustralianAccommodation.com Pty. Ltd."
<[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 10, 2000 7:55 AM
Subject: pointing different domain names to different sub directories on the
one server


> Is it possible to have two separate domain names being pointed to two
> separate subdirectories of the one cf server space
>
> This was I can host two totally separate websites on the one cf server
> account www.site.com points to the site1 subdirectory and www.site2.com
> points to the site 2 subdirectory
>
> I have been told by my cf hosting service that this is not possible that
you
> need a totally separate account set up for each domain as the content of
> each are totally different is this the case ???
>
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Website: www.AustralianAccommodation.com
> Email: [EMAIL PROTECTED]
>
> --

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


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



--
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: AOL mayheim

[Kevin Queen]

OK, I have watched this thread for the past two days and am now going to
magically solve the AOL caching issues for everybody.



http://webmaster.info.aol.com/index.cfm?article=12



Look, if you read the information provided by AOL in their ColdFusion based
webmaster information page they tell you how to cause their servers to not
cache.

P.S. - Has anybody read that book about the Spanish guy named Manuel, it
does help. ;)

Kevin Queen
Software Developer||""||
SyntheticLogic||__||
Atlanta, Ga   [ -=.]
  ===:0~

"Ah, I see!", said the blind man to the deaf mute.  -Unknown


-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 11, 2000 10:20 AM
To: CF-Talk
Subject: RE: AOL mayheim


Boy, that's a tough one.  I'd ask the folks at AOL, to be honest.  Good luck
getting an answer anytime relatively soon, though.  If you are able to get
the stats from them regarding frequency of caching, etc., please do share
the numbers with this list.  I don't target AOL users, nor do I generally
even stop to think about what my site is going to look like to an AOL user,
to be honest.  However, AOL users do represent a large audience, and I
probably should be more concerned about how my clients' sites look to them.
If you discover any tips, tricks, or standard procedures for making a
dynamic site more "AOL friendly", I'd be interested in knowing about it, as
would many other folks on this list I'm sure.  You are correct in your
statement that AOL's problems are not ColdFusion specific, in regards to
their probable inability to cache dynamic sites.  These problems would exist
for any dynamic site technology, not just CF.  Until you get answers from
the folks at AOL, my best advice (if this is a real concern of yours) is to
post a little disclaimer for AOL users stating the possibility of outdated
material and the like, and let them know you're working on it.  Of course,
the best thing for you to do is to download and install a free AOL trial
membership, and view your site the way other AOL user would.

~Simon

-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 11, 2000 9:58 AM
To: CF-Talk
Subject: RE: AOL mayheim


Thanks for this insight, Simon. According to this logic, Cold Fusion would
not be singled out by AOL. It would not be friendly to any server
technology that presents dynamic pages based on database content, including
ASP, PHP, and Domino.

Can you or anyone else shed some light on just how far behind AOL's caching
is? For instance, if I have info on a site that changes daily, how long
will AOL users go between snapshots? This would help me explain to AOL
users what they're not seeing.

--John






Simon Horwith


leaf.com>cc:

 Subject: RE: AOL mayheim

10/10/2000

01:51 PM

Please

respond to

cf-talk








I haven't been following this entire thread, but you've got to remember
that
for all intents and purposes, AOL is a cached intranet.  AOL (or anyone
else) cannot cache pages that are dynamically changing based on database
content... or at the very least, they cannot keep very current copies of
dynamic sites on their network.From AOL's standpoint, the statement
that
they are not "ColdFusion" friendly makes sense.

~Simon

-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 10, 2000 2:34 PM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: AOL mayheim


Hey Brian,

For those of us (such as myself) who apparently need new glasses, could you
help us out with a link to that info you're talking about?

---mark


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


> -Original Message-
> From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 10, 2000 6:58 AM
> To: CF-Talk
> Subject: AOL mayheim
>
>
> You cannot email AOL using Cold Fusion Application Server... The default
> serverid, You must change it.. Also it transforms all likes like
> Hotmail to
> single quote instead of doublequotes
> - Original Message -
> From: Ryan <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Tuesday, October 10, 2000 7:15 AM
> Subject: Re: CGI Referrer variable stream and 

RE: CGI Referrer variable stream and AOL crap.

[Kevin Queen]

BTW, If you are REALLY fast then you can see that AOL wrote the site in
CF search page= "v_results.CFM"


-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 10, 2000 2:32 PM
To: CF-Talk
Subject: RE: CGI Referrer variable stream and AOL crap.


I tried to find any mention of ColdFusion and ColdFusion on the webmaster
site and found nothing.  This sounds like a really bad rumor to me.  But
even if it were true you could simply rename the extension of your
templates.

And if you were programming in the FUSEBOX STYLE (ahem) this would be a
pretty easy thing to do.  ;)

---mark


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


> -Original Message-
> From: Ryan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 10, 2000 6:15 AM
> To: CF-Talk
> Subject: Re: CGI Referrer variable stream and AOL crap.
>
>
> >Read up on all the crappy changes like blocked Cold Fusion Application
> >server, and all that... http://webmaster.info.aol.com/
>
> I couldn't find anything here about blocked cold fusion... And I
> tried searching for 'cold fusion', 'cold', and 'fusion' and still
> found nothing... If AOL is blocking cfm pages somehow please tell
> me about it.
>
> RPS
>
> --
> 
> 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=sts&body=sts/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: dynamically filling a calendar

[Kevin Queen]

Oo, me too, pleassse  :)

Could you include me in on that colander code (possibly post it to the
list?)

Kevin Queen
Software Engineer
Synthetic Logic


"Ah, I see!", said the blind man to the deaf mute.  -Unknown


-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 06, 2000 11:36 AM
To: CF-Talk
Subject: Re: dynamically filling a calendar


Jon,

I just finished writing an article for CFDJ on this very thing.  I would be
more than willing to send you the code that generates the calendar as well
as populates it from a Database of events.

Kevin
- Original Message -
From: "Jon Tillman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 06, 2000 9:24 AM
Subject: dynamically filling a calendar


> Hey folks,
> I have a calendar(as part of a scheduling app) that I need to fill in
> dynamically.
> What I am trying to do is to allow the user to select any month in any
year and
> have the table filled out with the correct "month view" layuot.
> Is there a way to compare the results of the DateFormat() function OR a
> variable to the position of the table cell (both row and column) so as to
> determine where the individual dates should be?
>
> Any help would be greatly appreciated.
>
> --
> ***
>  Jon Tillman
>  LINUX USER: #141163
>  ICQ: 4015362
>  http://www.eruditum.org
>  [EMAIL PROTECTED]
> ***
> Be alert, the world needs more lerts
> ***
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=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: OT : Making CF and PHP play nice

[Kevin Queen]

Thanks Dave I never would have known what the proper .dll was.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 2:10 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: OT : Making CF and PHP play nice


> I have a pesky little problem I thought you might be able to
> help me with. I have a Win NT box (sp6a) and IIS4 with CF 4.5
> and PHP4. Now I know that PHP and CF are conflicting, but due
> to the nature of the design that I have to do some of it is in
> PHP and some of it is in CF. Now my issue is that after
> installing PHP4 and CF 4.5 on my workstation (for sandbox
> purposes) any CF template that I call simply returns the SOURCE
> code. Is there any way that I can load PHP4 and CF 4.5 on the
> same box and have them all play nice together or am I going to
> have to make a separate PHP server and a separate CF server
> on my network?

They'll coexist fine. Just make sure that you have an ISAPI mapping for
.cfm.

1. Open the Internet Service Manager
2. Select your virtual web server, right-click, and select Properties
3. Go to the Home Directory tab
4. Click on the Configuration button.
5. Click on the Add button.
6. For executable path, enter "C:\CFUSION\BIN\ISCF.DLL" (if that's the right
path for you) and ".cfm" as the extension.

Alternatively, you can just reinstall CF, and it'll fix you back up without
losing your previous settings, as long as you don't uninstall first.

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

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

OT : Making CF and PHP play nice

[Kevin Queen]

All,
I have a pesky little problem I thought you might be able to help me with.
I have a Win NT box (sp6a) and IIS4 with CF 4.5 and PHP4.  Now I know that
PHP and CF are conflicting, but due to the nature of the design that I have
to do some of it is in PHP and some of it is in CF.  Now my issue is that
after installing PHP4 and CF 4.5 on my workstation (for sandbox purposes)
any CF template that I call simply returns the SOURCE code.  Is there any
way that I can load PHP4 and CF 4.5 on the same box and have them all play
nice together or am I going to have to make a separate PHP server and a
separate CF server on my network?

TIA,
Kevin Queen
Software Engineer
Synthetic Logic

--
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: converting Word docs or PDF's to HTML

[Kevin Queen]

Easier way:
open word choose File --> Save as Web Page (word 2k)
-or-
open word choose File --> Save As --> Change file type to *.htm  (word 97)

Makes messy code but if you are using word to edit the docs and not editing
the html than this works like a charm ;}

Kevin (A former Word Tech)

-Original Message-
From: tom muck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 13, 2000 1:05 PM
To: [EMAIL PROTECTED]
Subject: Re: converting Word docs or PDF's to HTML


Go into Word and "Select All".  Then copy it to the clipboard.  Then go into
Homesite or CFStudio and paste the whole thing into "Design View" on a new
document.  It works like a dream.

tom

- Original Message -
From: "Melissa Fraher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 13, 2000 2:54 PM
Subject: converting Word docs or PDF's to HTML


> Does anyone have a suggestion on how to easily convert documents from
> Word to HTML?  Is there a way to convert from PDF to HTML?
>
> I have used Dreamweaver to strip out the word formatting, however, the
> document then needs to be reformatted.
>



--
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: ODBC Date Errors

[Kevin Queen]

Doh  

Thanks, I guess I need to read the Notes in the CFWACK closer, Thanks all

Kevin
--
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.

ODBC Date errors

[Kevin Queen]

List,
I have a template that creates a query to get information for the month
selected.  I am doing this by constructing a query like this :





SELECT Location, Name, Time, Event_Date, Event_Number, Location
FROM Tbl_Events
WHERE Event_Date >= #Today#
AND Event_Date <= #EndDay#


ByYear is passed as the year selected from a form.
ByMonth is the numerical month passed from a form.

Now the issue is that when I pass September as "9" then the above cfset for
EndDay returns 2000- 9-31 (obviously wrong) and November as "11" returns
2000-11-31 (also wrong).

What is the problem with these two months??

TIA,
Kevin

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

Strange 404 Error

[Kevin Queen]

All,
I have a template that performs an insert on my db.  This page is called by
another template with some form fields (Duh!).  The problem is that IE comes
back with a 404 error, however the update IS performed but the cflocation is
not executed.

code samples (beware of the wrap monster):

Query.cfm
-




Untitled



Inserting




Insert Finished, redirecting...



Calling Template :
-




First Name
:



Last Name
:



Address
:
,   


Contact Phone
:



Pager Number
:



Big Brother's Scroll
:



Status
:
Active


Notes (200 Char.)
:
















Thanks for any sugestions!!!

-Kevin

--
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: IsDefined() problems

[Kevin Queen]

I have the same issue and am using the same workaround, I am on CF4.5 NT 4
sp 6a IIS 4

Kevin

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


Just a quickie.

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



... do something ...


instead of:


... do something ...


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

Paul



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

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

RE: OnRequestEnd.cfm

[Kevin Queen]

Ahhh, very good Clint son


That is correct, howeveer; unlike Application.cfm OnRequestEnd.cfm must be
in the same directory as the calling template, CF will NOT recurse the
directory tree for OnRequestEnd.

Kevin

-Original Message-
From: Clint Tillerson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 1:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: OnRequestEnd.cfm


Could someone offer a brief explanation regarding what
OnRequestEnd.cfm is used for?  I've never heard of this one.

Does it process after the requested cfm template processes as the
name might suggest?


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

OT: Printing anchor code

[Kevin Queen]

All,
OK, my brain is about to explode for not being able to remember a simple
command from HTML 3.2, if I want to display the  text "Blah,
blah, blah" in a browser, how do I do that.  BTW:  is not it.

Please help before my brain goes on permanant vacation.

-Kevin

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

Another Data Display Question

[Kevin Queen]

All,
I have a database where the code for a link (Some Text) is
stored in a field, if I want to run a query and have this display in a Text
box, how do I do it?  My current code is :



and this displays the following
   
Directions:|
   
(Sorry for the poor graphical representation, but this is a password
protected section of the site so I can't give a url.)

TIA,
-Kevin

--
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- no it's not, a lot of CF sites are hosted there.] My RANT against Interland.

[Kevin Queen]

Let me make something clear, Interland keeps all of their servers in one
building and will not make changes until at least 1000 calls come in about
the shared servers.  They have ONE person who is in charge of over 500 CF
boxes (I am not defending them, I will NEVER use them and I used to work
there), also if their customers are using HTR then they could map the
extension '.cfm+.htr' to the CF mapping and then the call would be parsed
like a normal CF file.  BTW: when I was using ASP and was working there I
discovered the .asp::$DATA hole and they would not fix my server, I had to
do it myself.  So in closing, DON'T HOST WITH INTERLAND if security,
customer service, and good technical support is what you need.


-Kev

-Original Message-
From: Gregory Gooden (Annex) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 09, 2000 6:12 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [OT- no it's not, a lot of CF sites are hosted there.] My
RANT against Interland.



In possible defense of them... (although I've never done business with
them)...

All MY servers were open to attack (we host our own stuff, but have quite a
few people we HOST cf for as well) as well, and a few customers contacted me
about it and we had it all fixed in less than 4 hours..

BUT... We're a small company... Interland MIGHT be one of those companies
with servers all over various co-located spots, and larger companies don't
have the flexibility to go "making changes" right and left.. They have to be
ready for rollback plans.. What if some of their customers are using HTR?
What if they have a policy about applying service packs or hotfixes to
PRODUCTION machines (we do, and we're small!).

The only reason we were able to respond so fast is because we know our
customerbase (being small), and were able to use the quick fix.. disable
HTR..

Gregory


---
annex.com, Inc. - http://www.annex.com/
---
- If you EcoBuild it, they will come. -
- http://www.ecobuilder.com/ -
---


> -Original Message-
> From: Mooner Ent [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 09, 2000 2:11 PM
> To: [EMAIL PROTECTED]
> Subject: [OT- no it's not, a lot of CF sites are hosted
> there.] My RANT
> against Interland.
>
>
> For the many reason Interland bites, as all company who spend more on
> advertising than they do customer service, here's the best one yet.
>
> Last week when the very large IIS security hole (+.htr) was
> discussed on
> this very list, I called Interland to warn them that all
> their servers where
> wide open to attack.  I even had my call bumped up to the
> highest person in
> the company that would take the call.
>
> What was their reaction, give it a couple days! I asked that
> my sites be
> fixed asap, no dice. Now we're approaching a week later and
> every site on
> Interlands NT boxes are still wide open, even their own corp site.
>
> The person on the phone had two gem comments:
> 1) "with all do respect who would want to hack your site?"
> 2) don't worry the sql databases are protected, they have
> passwords! After I
> explained to him the passwords are in the code, he said "oh".
>
> My sites are moving this week and never again will Interland
> see another one
> of my many thousands of dollars a quarter.
>
> While I'm at it, Webtrend reports for last month are now 9
> days late and
> counting. I even had the tech support people run them a few
> days ago, and
> still no reports. Try explaining that to the folks who sign
> the checks.
>
> With love,
>
> Rick
>
>
>
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=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: Hi Guys n Gals! Quick Select box question :)

[Kevin Queen]

You could also use a  and  block to do the same thing
faster (CASE statements evaluate faster that multiple IF statements),
psudeo-code:



If 


More processing


Code for whatever.value="" goes here



-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 1:44 PM
To: [EMAIL PROTECTED]
Subject: RE: Hi Guys n Gals! Quick Select box question :)


You could do this.  If you do however remove the #'s from the if statements,
they're not necessary and they slow down processing.  Or you could simply
output the value in the database as the first option.  Yes it will appear
twice in the list but it's easier for you to code and it is faster as CF
doesn't have to sort through a bunch of if statements.

--K
-
Thank you,
Katrina Chapman
ColdFusion Web Developer
Systems Development
Volt Information Services

-Original Message-
From: John McKown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 10:15 AM
To: [EMAIL PROTECTED]
Subject: RE: Hi Guys n Gals! Quick Select box question :)




name="reason_#lookup.Audit_ID#">
  

  
  SELECTED>9/80
  SELECTED>Absent
Without Permission
  SELECTED>Funeral
Leave
  SELECTED>Injury
  SELECTED>Jury
Duty
  SELECTED>Maternity
  SELECTED>Other
Approved Absences
  SELECTED>Public
Holiday
  SELECTED>Sick
Leave
  SELECTED>Surgical
Leave
  SELECTED>Suspension
  SELECTED>Time
Off
  SELECTED>Training/Conferences/Team Building
  SELECTED>Weekend
  SELECTED>Vacation
  



John McKown, VP Business Services
Delaware.Net, Inc.


-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 12:37 PM
To: [EMAIL PROTECTED]
Subject: Hi Guys n Gals! Quick Select box question :)


I need a select box to display a value from a database.

The box is not dynamic, and it is not a CFSelect box.

It is a regular, plain vanilla  statement sitting inside a CFFORM
inside a  statement.

I just know this is really really easy for you gurus..but I just can't
figure it out at the moment..

here is the box code as it is now:

name="reason_#lookup.Audit_ID#">
  
  9/80
  Absent Without Permission
  Funeral Leave
  Injury
  Jury Duty
  Maternity
  Other Approved Absences
  Public Holiday
  Sick Leave
  Surgical Leave
  Suspension
  Time Off
  Training/Conferences/Team Building
  Weekend
  Vacation
  



Thanks all!
-Gel



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


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

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

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

RE: I need a host. Intermedia testimonials - Interland

[Kevin Queen]

Please NO FLAMES, but FYI as an ex-Interland employee I only host my
personal site with them because it really does not matter if it is up,
however; for high-availability I would not recommend Interland.

-Kevin

-Original Message-
From: Gavin Myers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 12:22 PM
To: '[EMAIL PROTECTED]'
Subject: RE: I need a host. Intermedia testimonials - Interland


Talked to people probally about 3 times now, and that's just me, i cant
count how many e-mails me and my partners have sent. Ever since day one
things have been kinda shakey. The site I have hosted there is a side
business so I cant put very much time aside to harass Interland employees
(as much as i'd like to :) - but I like to think that One e-mail, or one
phone call should be enough - or maybe two, but when stuff like this
continues after constant calls, then I dont even want to talk to them, I'm
actually looking for another ISP.

I'm not really trying to down interland, its just one bad experience,
everyone has had one. But the length that it has gone on I just would rather
continue my efforts somewhere else. I'm sure other people have had great
luck with them - not me though.

Gavin

-Original Message-
From: Raymond K. Camden [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 10:07 AM
To: [EMAIL PROTECTED]
Subject: RE: I need a host. Intermedia testimonials


When I hear a story like this, I have to wonder... have you talked to a
human @ Interland who can explain why such a simple thing hasn't been done
yet? Have you threatened to stop payment? I can't imagine waiting more then
24 hours for something like this to get fixed.

===
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

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


> -Original Message-
> From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 08, 2000 10:53 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: I need a host. Intermedia testimonials
>
>
> 2 Months ago i would have said Interland... but they started to move crap
> around and our database hasn't been put back on our server YET... its been
> over a month now with no db, I'm pretty pissed at it, and maybe
> its just one
> of those things. Their price is ok, the site is ok, they have sql.
>


--
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: JavaScript error in IE5.00.2920.00

[Kevin Queen]

Jon,
Try document.purchase.action='purchase.cfm'

-Kevin

-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 9:24 PM
To: [EMAIL PROTECTED]
Subject: JavaScript error in IE5.00.2920.00


Hello list,
Does anyone have any insight into why the following would throw a java error
(292) when clicked in IE, but not in any other browser?



Thanks for your help.
--
:::
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 [EMAIL PROTECTED]
 http://tillman.freehosting.net
:::

--
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: Allaire security problem - anyone know solution?

[Kevin Queen]

-Original Message-
From: Kevin Queen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 1:22 PM
To: Dave Wilson [[EMAIL PROTECTED]]
Subject: RE: Allaire security problem - anyone know solution?


Dave,

I have seen this same error in ASP with ::$DATA, the way to fix that one is
to associate the extension .asp::$DATA with the asp.dll, so it would follow
that if you associate the .cfm+.htr extension w/ the cfml parser.  I am not
to sure how what the CF parser .exe and/or .dll is however. (The error is on
ANY CFM page)

-Kevin

P.S. - I have been getting errors posting to the list lately, if you would
please post this to the list when you receive.


-Original Message-
From: Dave Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 12:27 PM
To: [EMAIL PROTECTED]
Subject: Allaire security problem - anyone know solution?


Hi all,

One of my hosting clients has just made me aware of this major security
problem and I'm wondering if anyone knows how to eliminate it?

Try calling the application.cfm template on any CF site with +.htr appended
to the end of the url. You'll first see a blank page. Now hit refresh/reload
and you'll see the full code of said application.cfm

e.g. http://www.support.alllaire.com/application.cfm+.htr

Can someone please tell me there is a patch for this. It seems to happen on
all CFserver versions 4.x + running IS4.0 with Service pack 5

Dave

Dave Wilson
Internet Technology Manager,
BizNet Solutions


Co-Founder CFUG Ireland
http://www.cfug.ie

224, Lisburn Road
Belfast BT9 6GE

Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com

email: [EMAIL PROTECTED]


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

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

RE: CFINCLUDE... compiler question

[Kevin Queen]

The easy answer is this:






does NOT Include some.cfm.

Contrary to Zachary I would assume this in a server compiled SGML based
language due to the fact that when the parser reads and executes the file it
reads it line by line on the fly, unlike a traditional "pre-compiled"
language where the include must be done @ compile time to verify syntax and
variable declarations (This is why if you screw up a CFIF halfway down the
page the first half is displayed and then the error message pops up under
the already displayed half a page.

-Kevin

-Original Message-
From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 11:43 AM
To: '[EMAIL PROTECTED]'
Subject: RE: CFINCLUDE... compiler question


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Testing under CF 4.0.1:

File1.cfm:




File2.cfm:
CFINCLUDED TEST!

File3.cfm:





Running File1 does NOT cause any email to be sent.  Running File3
does NOT cause an error to be thrown about a missing include.

So I'd say the interpreter is only including the file it it needs to
(which isn't what I would have anticipated, but)

Hope that answers your question.

Best regards,
Zac Bedell

> take the following code:
>
> 
>
> 
>
> Will ColdFusion evaluate the expression first before it includes
> the file -OR- will it include the file before it evaluates the
> expression?
>
> in other words, does CF say "ok, thisFlag is false, so i
> won't evaluate
> what's in the include file" or will it say "before i look at
> this, i need to
> include everything first"?

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

iQA/AwUBOYmS7graVoMWBwRBEQLPoACg7U2IgyONzMKCaD3JxU7KQ3DEsGkAn0Wo
5/WzVTo6kiX114cwDAdoM4mq
=ZdKS
-END PGP SIGNATURE-

--
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: CFINCLUDE... compiler question

[Kevin Queen]

Mike,

CF will evaluate the IF and then decide to include or not.

-Kevin

-Original Message-
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 11:09 AM
To: Cf-Talk
Subject: CFINCLUDE... compiler question


take the following code:


   


Will ColdFusion evaluate the expression first before it includes the
file -OR- will it include the file before it evaluates the expression?

in other words, does CF say "ok, thisFlag is false, so i won't evaluate
what's in the include file" or will it say "before i look at this, i need to
include everything first"?

thanx for any response
mike


--
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: Integrating with Flash

[Kevin Queen]

Same here, if you don't mind.

TIA,
-Kevin

-Original Message-
From: Norman Elton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 9:00 AM
To: [EMAIL PROTECTED]
Subject: RE: Integrating with Flash


I'll take a copy of your files too :). Thanks!

Norman

On Thu, 3 Aug 2000, Reynolds, Adam wrote:

> Could you copy me in on this. I would be very interested.
>
> > --
> > From:   Sean Renet[SMTP:[EMAIL PROTECTED]]
> > Sent:   03 August 2000 12:24
> > To: [EMAIL PROTECTED]
> > Subject:Re: Integrating with Flash
> >
> > I have a day left of crazy left, then I will email you an fla file and
cf
> > template off list.
> > - Original Message -
> > From: "Rich Wild" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, August 03, 2000 1:53 AM
> > Subject: RE: Integrating with Flash
> >
> >
> > > Yeah - I wasn't talking semantics though, I am genuinely interested in
> > how
> > > you pull those variables out - where does the LoadVariables pull the
CF
> > > variables from?
> > >
> > > I've used URL variables before fine - but limited as I said, due to
the
> > max
> > > length of a URL string
> > >
> > > I've used textfiles also - getting CF to create a textfile with the
> > > variables written into it:
> > >
> > > eg: variables.txt
> > > **
> > >
> > > var1 = Hello
> > > var2 = Cheese
> > > var3 = red hot poker
> > >
> > > **
> > >
> > > And Then Flash LoadVariables from variables.txt
> > >
> > > Now I *know* that this is brutish and poor. Must be. Makes me wince
just
> > > looking at it.
> > >
> > > How specifically are you handling it? I long for a better way...
> > >
> > > --
> > > Rich Wild
> > > Senior Web Designer
> > >
> > > ---
> > > e-mango.com ltd  Tel: 01202 587 400
> > > Lansdowne Place  Fax: 01202 587 401
> > > 17 Holdenhurst Road
> > > Bournemouth   Mailto:[EMAIL PROTECTED]
> > > BH8 8EW, UK  http://www.e-mango.com
> > > ---
> > > This message may contain information which is legally
> > > privileged and/or confidential.  If you are not the
> > > intended recipient, you are hereby notified that any
> > > unauthorised disclosure, copying, distribution or use
> > > of this information is strictly prohibited. Such
> > > notification notwithstanding, any comments, opinions,
> > > information or conclusions expressed in this message
> > > are those of the originator, not of e-mango.com ltd,
> > > unless otherwise explicitly and independently indicated
> > > by an authorised representative of e-mango.com ltd.
> > > ---
> > >
> > >
> > > -Original Message-
> > > From: Sean Renet [mailto:[EMAIL PROTECTED]]
> > > Sent: 03 August 2000 09:44
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: Integrating with Flash
> > >
> > >
> > > I seldom use url variables.  I am sure that someone will respond with
a
> > > url/form variable dissertation.  However, I generally have an action
> > page
> > in
> > > the background that does all the work and I have flash pull the
> > variables
> > > from it using flash's LoadVariables command.  I suppose this is more
> > like
> > a
> > > form variable pass as the method is "post".  I don't have much time to
> > get
> > > caught up in symantics, I just do what I think works the best.  You
> > don't
> > > need text output per say, you can just use cfcontent.
> > > - Original Message -
> > > From: "Rich Wild" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, August 03, 2000 1:03 AM
> > > Subject: RE: Integrating with Flash
> > >
> > >
> > > > Am I right in saying that you are limited to using URL variables
when
> > > > controlling Flash movies though? That's what I've picked up anyway
> > > >
> > > > Kind of annoying if you have a lot of text to output...
> > > >
> > > >
> > > >
> > > > --
> > > > Rich Wild
> > > > Senior Web Designer
> > > >
> > > > ---
> > > > e-mango.com ltd  Tel: 01202 587 400
> > > > Lansdowne Place  Fax: 01202 587 401
> > > > 17 Holdenhurst Road
> > > > Bournemouth   Mailto:[EMAIL PROTECTED]
> > > > BH8 8EW, UK  http://www.e-mango.com
> > > > ---
> > > > This message may contain information which is legally
> > > > privileged and/or confidential.  If you are not the
> > > > intended recipient, you are hereby notified that any
> > > > unauthorised disclosure, copying, distribution or use
> > > > of this information is strictly prohibited. Such
> > > > notification notwithstanding, any comments, opinions,
> > > > information or conclusions expressed in this message
> > > > are those of the originator, not of e-mango.com ltd

RE: Help! (2)

[Kevin Queen]

Try

SELECT DISTINCT col1, col2, ...
FROM 
WHERE 1=1

(* Notice the absence of Parens)

-Kevin

-Original Message-
From: aslam bajaria [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 02, 2000 10:31 AM
To: [EMAIL PROTECTED]
Subject: RE: Help! (2)


select distinct(*) gives an error.
Also
select distinct(column1, column2,...,LastColumn) gives
an error.

Can someone tell me how to avoid this error.

Appreciate.
A.B.



--- Johan Coens <[EMAIL PROTECTED]> wrote:
> Maybe:
>
> Step 1: SELECT DISTINCT ... (all colums), name it
> qryAllRecords
> Step 2: DELETE FROM , now you're table is
> empty
> Step 3: LOOP over qryAllRecords and insert them into
> the database.
>
> Make sure you have a backup and use CFTRANSACTION!
>
> Best Regards,
> Johan Coens
>
> -Original Message-
> From: aslam bajaria [mailto:[EMAIL PROTECTED]]
> Sent: woensdag 2 augustus 2000 6:30
> To: [EMAIL PROTECTED]
> Subject: Help!
>
>
> Hello All,
> There is a very seriuous problem I am facing. Please
> help. The problem is as follows:
>
> Somehow I have created duplicate records in SQL
> Server
> 7.0 table.
>
> I have to remove the duplicate the records. It all
> happened because there is no primary key when the
> record was created.
>
> If it were a few records, I could have manually
> deleted them. Now the records are in thousands. Can
> someone suggest me a code that would check for
> duplicate values in a table and delete them.
>
> Please help.
>
> A.B.
>
> __
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
>

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

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


__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

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

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

CFHTTP

[Kevin Queen]

I think the list misplaced the message, but if you are getting twice please
flame me personally.  Thanx

-Original Message-
From: Kevin Queen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 02, 2000 9:29 AM
To: Cold Fusion
Subject: CFHTTP


All,
I was looking into CFHTTP and was wondering if I could use it to load a page
without displaying said page.  I have tried using a small pop-up window, but
this is unacceptable to my client. I need a way to load a page (to count the
total hits for a specific functionality of the site) without the user having
to click or a window open. They do not want to use session or app vars (the
page grabs info about the user node and writes to a db, they do not want it
in the page itself because after some trials they want to be able to remove
it easily).  Any and all suggestions are greatly appreciated.

TIA
-Kevin

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

Repost - CreateODBCDate Error

[Kevin Queen]

I sent this on Tuesday and never saw it come up on the list (I thought we
had this slow list issue fixed) so I am reposting, sorry if you are getting
this twice.

-Kevin

-Original Message-
From: Kevin Queen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 4:18 PM
To: '[EMAIL PROTECTED]'
Subject: CreateODBCDate Error


I have a 'function' :   When I set #ByMonth# to 9 or 11 the
function sets days to 31 and the template fails (obviously) is this a known
error with CF4.5,  NT 4.0, IIS 4.0, and SP6?
Is there a valid work around?

TIA,
Kevin Queen

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

OT: CGI Question

[Kevin Queen]

This has been bugging me for two days and I can not fond any reference
materials.  I am attempting to output a table structure to a cfml file using
the following CGI command:


print FILENAME "Yadda, yadda\n";

it looks like this in the code:

print NEWFILE "\n";
print NEWFILE " Subject\n";
print NEWFILE " :\n";
print NEWFILE " \n";
print NEWFILE "\n";


I keep getting a bareword error.

This is probably so simple I am overlooking the answer, but I am to
frustrated to figure it out.  My only thought is that tr or td is a reserved
word?

Thanks for ANY help,
Kevin Queen


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

OT: Picture Cache

[Kevin Queen]

All,
I know this is simple and OT but, is there another way to pre-load my
mouse-over images without setting a JavaScript array?

Thanks,
Kevin "Forrest" Queen

Web Master
Tau Kappa Epsilon

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

Testing - Delete Me!!

[Kevin Queen]

Last one did not make it this is a test Sorry ;-}

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

ODBC date functions

[Kevin Queen]

I am attempting to writ a query that based on a Radio select either returs a
week or a month worth of dates from the current date, I can not get this to
work.  I think the logic is right but I am missing something, any help is
appreciated.

Code: *** Watch for wrap***



 SELECT Location, Name, Time, Directions, Event_Date, Pub
 FROM Tbl_Events
 WHERE 1=1
 AND Event_Date >= #CreateODBCDate(Now())#
  
  
   AND Event_Date <= #CreateODBCDate(CreateDate(Year(Now()), Month(Now()),
Day(DateAdd('d', 7, Now()#
  
  
  
   AND Event_Date <= #CreateODBCDate(CreateDate(Year(Now()),
Month(DateAdd('m', 1, Now())), Day(Now(#
  
 AND WHERE Pub = 1
 ORDER BY Event_Date



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

Site Dedsign Question (Try 2)

[Kevin Queen]

All,
Hello, I am new to the list and to CF.  I have a quick question about CF
programming techniques.  I have a site where I am using a standard
navigation and layout (set up using nested tables so that the content is
always centered). I am using one cell for all of the data (See Code Listing
Below) and would like to know how short of using a snippit I can insert this
table without typing (I'm Lazy) .  The problem is that the "top" part of the
table and the "bottom" part of the table are static and the contect is
dynamic.  I do not want to do this:





So short of hard coding the table in all of the pages, what are my other
options?

Code Listing to follow.

Thank You,
Kevin Queen

IBM Learner Support
1500 Riveredge Pkwy, 19E04
Atlanta, Georgia 30328
(770)644-5050 or t/l 237-5050

I have not lost my mind, it is backed up on CD somewhere.


---
Current Code:



 
  
  
  
  
   

 
 
 
 
 


 
 
 
 
 
 
 
 


 
 
  
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
  
  
 


 
**   CONTENT GOES HERE
 


 
 
 
 
 
 


 
 
 
 
 
 

   
   
  
  
  
  
 





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

Site Design Question

[Kevin Queen]

This is a multi-part message in MIME format.

--=_NextPart_000_000A_01BFC6AE.0C1560C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

All,
Hello, I am new to the list and to CF.  I have a quick question about CF =
programming techniques.  I have a site where I am using a standard =
navigation and layout (set up using nested tables so that the content is =
always centered). I am using one cell for all of the data (See Code =
Listing Below) and would like to know how short of using a snippit I can =
insert this table without typing (I'm Lazy) .  The problem is that the =
"top" part of the table and the "bottom" part of the table are static =
and the contect is dynamic.  I do not want to do this:





So short of hard coding the table in all of the pages, what are my other =
options?

Code Listing to follow.

Thank You,
Kevin Queen

IBM Learner Support
1500 Riveredge Pkwy, 19E04
Atlanta, Georgia 30328
(770)644-5050 or t/l 237-5050

I have not lost my mind, it is backed up on CD somewhere.

-=
-=
-
Current Code:



 
  
  
  
  
   

 
 
 
 
 


 
 
 
 
 
 
 
 


 
 
  
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
   
   


   
   
  
  
 


 
CONTENT GOES HERE
 


 
 
 
 
 
 


 
 
 
 
 
 

   
   
  
  
  
  
 





--=_NextPart_000_000A_01BFC6AE.0C1560C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








All,
Hello, I am new to the list and to =
CF.  I have=20
a quick question about CF programming techniques.  I have a site =
where I am=20
using a standard navigation and layout (set up using nested tables so =
that the=20
content is always centered). I am using one cell for all of the data =
(See Code=20
Listing Below) and would like to know how short of using a snippit I can =
insert=20
this table without typing (I'm Lazy) .  The problem is that the =
"top" part=20
of the table and the "bottom" part of the table are static and the =
contect is=20
dynamic.  I do not want to do this:
 
<cfinclude=20
template=3D"top_table.cfm">
<cfinclude=20
template=3D"content.cfm">
<cfinclude=20
template=3D"bottom_table.cfm">
 
So short of hard coding the table in =
all of the=20
pages, what are my other options?
 
Code Listing to follow.
 
Thank You,
Kevin Queen
 
IBM Learner Support1500 Riveredge =
Pkwy,=20
19E04Atlanta, Georgia 30328(770)644-5050 or t/l =
237-5050
 
I have not lost my mind, it is backed =
up on CD=20
somewhere.
 
=
-=
--
Current Code:
 
<!-- Begin the Main Table (3x1)=20
--><TABLE cellpadding=3D"0" cellspacing=3D"0" cols=3D"3" =
align=3D"center"=20
border=3D"0" =
name=3D"Main_Table"> <TR>  <TD=20
width=3D"50%"><!-- Spacer Cell=20
-->  </TD>  <TD> &nbs=
p;<!--=20
Begin the Content Table (2x4) -->   <TABLE=20
cellpadding=3D"0" cellspacing=3D"0" cols=3D"2" align=3D"center" =
border=3D"0"=20
name=3D"Content_Table"><TR> =
;<TD=20
colspan=3D"2"> <!-- Main Title =
Bar=20
--> <IMG name=3D"Title_Bar"=20
src=3D"images/Main_Banner.gif" width=3D"610" height=3D"90" =
alt=3D"Welcome to Tau Kappa=20
Epsilon" border=3D"0"> <!-- End =
Main Title=20
Bar=20
--> </TD>   =
 </TR><TR>  &n=
bsp;  <TD><IMG=20
name=3D"ID" src=3D"images/ID_Box.gif" width=3D"110" height=3D"30" =
alt=3D""=20
border=3D"0"> <!-- Spacer Cell=20
--> </TD>   =
  <TD> <!--=20
"Tree" Navigational Bar --> <IMG=20
name=3D"Tree" src=3D"images/Tree_Bar.gif" width=3D"500" height=3D"30&