RE: Reverse Engineer DayOfYear Function?

[Dan Haley]

Standard answer will be:





Of course, those of us trying to liberate dates and allow them free access
into the numeric arena like the much simpler:




Do realize, though, that I am the only member of the DTLA, date-time
liberation army ... ;)


Dan



-Original Message-
From: Christian Abad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 04, 2002 12:52 PM
To: CF-Talk
Subject: Reverse Engineer DayOfYear Function?


Folks:

I am trying to obtain a date from the ordinal produced by the function
DayOfYear.  In other words, does anyone know how to "reverse engineer" the
ordinal into a usable date?  I would assume I'd need to pass the ordinal and
the year to some function to obtain a usable date.  I can't seem to find a
function that will accomplish this! Any ideas?

Thanks,
Christian N. Abad

--
Sr. Analyst - Apps Programming
Bank of America
eCommerce Technology - Website Support
http://www.bankofamerica.com



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

RE: No easy way to loop through a date range?

[Dan Haley]

When dates start bugging you and causing you to write a lot of code,
remember that they are just numbers to CF.


#dateformat(i, "m/d/yy")# -- #i#


Dan
President and CEO of the Date-Time Liberation Army (DTLA)

"Dates deserve to be treated just like numbers, ah ha ha."
The Count


-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 5:25 AM
To: CF-Talk
Subject: No easy way to loop through a date range?


My wife needed help writing a template so that she could put together a
regular and on-call schedule for work.  Pretty simple requiremenets, really,
she just asked me to generate a table that dumped out a range of dates.
Easy-peasy, thinks I, I bet Cold Fusion can do it in 3 lines of code.

Wrong.  Not especially difficult, and I worked it out (using CFLOOP, and a
bunch of variables for current day, lastdayofyear(), etc.), but it left me
wondering why  didn't allow you to loop through a date object and
increment by days, hours, minutes, whatever?

Thanks

Pete


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: HTML Form values into struct variables

[Dan Haley]

Once your form is submitted and your CF code is processing it, then you are
back at the server again, so you will need to use FORM variables.  The
"document.all..." variables are javascript variables that your server code
will not be aware of.

The nice thing is, with the FORM variables they are already in a structure
so you can probably skip creating your own.  Just do a 
to see what is available.  You will find, though, that some form variables
don't come across unless they have a value.  Checkboxes and radio buttons
are examples of this.  An unchecked check box will not be in the form
structure, so you will need to test for its existence.

Dan

-Original Message-
From: Yexley Robert D Contr Det 1 AFRL/WSI
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 2:15 PM
To: CF-Talk
Subject: HTML Form values into struct variables



This may be a very obvious and simple thing (I actually really hope it is),
but I am still *very* new with CF, and haven't been able to find anything in
the documentation or on the mailing list archive that has given me any kind
of a clue as to how to do this.  Your patience is appreciated.


I have a rather large HTML form, which has a lot of checkboxes, and some
text fields as well.  To be able to store the selected values of what the
user selects in this form, I have created a STRUCT with a variable for each
item in the form to hold it's value.  I created the struct as follows:









The form that I have is a straight HTML form, meaning the items in it are
HTML input items, and not  items.  What I need to know is, how can
I assign the values of the items in this form to the variables in my new
structure when the form is submitted, so that I can use the values to pass
into a stored procedure in the database?  It seems like it would be pretty
trivial, but what I've tried so far doesn't seem to be working.  For some
reason, CFMX doesn't like the following:



.

Can someone point me to some documentation or a whitepaper or something like
that which would give me a little guidance as to how to go about doing this?
Any help would be greatly appreciated.  Thanks in advance.

::YEX::
<)))><

/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Northrop Grumman IT
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| <)))><
*/

 <> 


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

RE: Stupid SQL Problem (in oracle)

[Dan Haley]

This should be what you're looking for ... not aware of other solutions
similar to transform in SQL Server ...

select  sum(decode(fieldname, 'Running', 1, 0)) running,
sum(decode(fieldname, 'Offline', 1, 0)) offline,
sum(decode(fieldname, 'Unknown', 1, 0)) unknown,
count(*) total


Dan

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 12:18 PM
To: CF-Talk
Subject: OT: Stupid SQL Problem (in oracle)


I need some way to convert a word into a number.

I know I've done it once before, but I can't remember what I did.

For example, I have a query that will return something like the following:

Machine1 Running
Machine2Running
Machine3Offline
Machine4Running
Machine5Offline
Machine6Unknown


I want to get some result like this:

Running OfflineUnknownTotal
3 2 1   6

I know it has something to do with a sum and translating "Running" into 1,
"Offline" into a 1 and "Unknown" into a 1,  I just can't remember how I did
it.

This is an oracle 8i system I'm working with.

Thanks,


Rob Edwards Phone:  (502) 359-1627
Systems Management Tools   Pager:   (502) 478-1116
United Parcel Service   Fax:(502) 359-0094
EMail:  [EMAIL PROTECTED]   

(2B || !2B) == ?



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Behavior

[Dan Haley]

That's not true ... I use  and  for troubleshooting in my
application.cfm all the time ... CF4.5

Wasn't there a thread on here a couple days ago about having a ".com" in
your path and how that can screw things up?

Dan

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 10:10 AM
To: CF-Talk
Subject: RE: Weird Behavior


you cant get application.cfm to show results of cftags
in them, I know that.

.tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 

-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 11, 2002 11:17 AM
To: CF-Talk
Subject: Weird Behavior


OK, this is going to sound weird, but I have a Win2K server running
IIS/CF5/SQL2K. A client asked me to redo the admin section of their site
which is now using NT security on the admin dir on their server. I
created an 'X.com' directory in my C:\inetpub\wwwroot. I ftp'ed the
whole site there. Currently there's no index.cfm in the admin directory
so I created one with: #now()# in it. I hit
www.myserver.com/x.com/admin and I see "#now()#". I hit refresh and get
"The Page Cannot Be Displayed". I've verified CF is running. Now if I
hit www.myserver.com/x.com I get the public site. Then if I put "/admin"
on the url I get "#now()#" again! That seems like some crazy caching
issue or something. I have 30 other sites running properly on the
server. I also tried putting a cfabort in the root application.cfm and
it's not being processed I guess. (There is no application.cfm in the
admin directory.)

Any ideas?



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cf-talk@houseoffusion.com

[Dan Haley]

Can you just do a join between the two?

SELECT  COUNT(*) as count_ttl,
DATEPART(dy, logdate) as doy, 
DATEPART(, logdate) as yr, 
DATEPART(mm, logdate) as mnth, 
DATEPART(d, logdate) as dy,
count(cl1.logdate) as count_in

FROM customer_log as cl2, customer_log as cl1
WHERE logdate BETWEEN #start# AND #DateAdd('D', 1, end)#
and cl1.logdate = cl2.logdate
and cl1.logtype <> 'callout'

GROUP BY DATEPART(dy, logdate), DATEPART(, logdate),
DATEPART(mm, logdate), DATEPART(d, logdate)
ORDER BY DATEPART(dy, logdate)

Dan
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 10:42 AM
To: CF-Talk
Subject: Man this query @#%$&*


Can anyone out there assist me with this query?  I need to count two
sets, differentiated by a text field and grouped by yet another field.
Here's what I have: 
 
SELECT COUNT(*) as count_ttl,
DATEPART(dy, logdate) as doy, 
DATEPART(, logdate) as yr, 
DATEPART(mm, logdate) as mnth, 
DATEPART(d, logdate) as dy,
(SELECT COUNT(*)
FROM customer_log as cl1
WHERE logtype <> 'callout'
AND cl1.logdate = cl2.logdate) AS count_in
FROM customer_log as cl2
WHERE logdate BETWEEN #start# AND #DateAdd('D', 1, end)#
GROUP BY DATEPART(dy, logdate), DATEPART(, logdate),
DATEPART(mm, logdate), DATEPART(d, logdate)
ORDER BY DATEPART(dy, logdate)
 
The problem is that cl2.logdate is not used in the GROUP BY clause nor
can I use it.  Logdate contains a time stamp which screws up the GROUP
BY day functionality which is necessary for my report, thus the
DATEPART.  Basically, I'm counting all lines in a date range but also
need to count just the lines in which the logtype is a specified value.
 
HELP! 
 
cc




__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT - MS SQL help

[Dan Haley]

This was asked a few weeks ago on the SQL list ... here is the thread ...

http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=256
&forumid=6&refresh=0

Dan

-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 12:13 PM
To: CF-Talk
Subject: OT - MS SQL help


Is it possible to join two tables, and have a list of keys returned from one
of the tables as a column of a recordset?

tblOnePK|   name
1   |   threeFriends



tableTwoPK  |   tblOneFK
1   |   1
2   |   1
3   |   1

And the record set should be:

tblOnePK|   name|   listOfKeys
1   |   threeFriends|   1,2,3

Make sense?

I could do it programmatically in CF, but would like to pull this in one
query and avoid a recordset/requery loop.  Also, can't use a stored proc,
unfortunately.

Thanks for any help.


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Rock Band needs a Codie

[Dan Haley]

Do a subquery selecting the min(gigdate) where gigdate >= today.  Select the
gig that is on that date, then in CF determine what text to show depending
on the date of the gig.

Something like
select  giglist.*, gigdates.gigdate, gigdates.gigtime
fromgigdates, giglist
where   gigdates.gigname = giglist.name
and gigdates.gigdate = (select min(gigdate) from gigdates where
gigdate >= now())


tonight's show

next show



That was fun saying gig so many times ...

Dan

-Original Message-
From: Michael Pool [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 1:21 PM
To: CF-Talk
Subject: Rock Band needs a Codie 


OK I give up. I know when I am beat. This is a simple one. I know this
but I just can't get it to work for some reason. I saw something similar
in an old post, but it was not informative enough.
 
Here's the deal:
 
I have 2 tables in a Rock Band's database. (annie.mdb)
 
GIGLIST and GIGDATES
 
I have a template page that I want to show TONIGHT'S SHOW data if there
is a show tonight and IF NOT, then the NEXT SHOW date data.
 
as I am sure you can tell by the extension, this is an ACCESS Database,
I have the GIGDATE field set to a "date" field. (MM/DD/) 
 
Fields are as follows:
 
GIGLIST
ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE
 
GIGDATES
ID, GIGNAME,  GIGDATE, GIGTIME
(GIGNAME = giglist.name)
 
 
 
So, let me reitterate I want to show all of the current variables
for the show record that has tonight's date (if there is a show tonight)
and set a variable "NEXTSHOWTIME" to either display the text "Tonight's
Show"  or set to "Next Show" if no show tonight and then show the next
available showdate's recordset from the GIGDATES table and the
corresponding venue location info from the GIGLIST table. 
 
GIGNAME=NAME in the GIGLIST table
 
 
 
 
 
 
 
FREE MUSIC CD to the first one who sends me code that makes this thing
work!
 
Thanks!
 
M. Pool
[EMAIL PROTECTED]
 



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Log reporting error - No actual error

[Dan Haley]

Turn off your error handling to see where the error is truly occurring ...
or are you including that information in the error message?  Your form is
probably fine, I would concentrate on the page handling the request ...

Dan

-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 10:23 AM
To: CF-Talk
Subject: RE: Log reporting error - No actual error


Here's the basic code (with layout and such trimmed out):

The form:


   
First Name*

  
 







[I just noticed the missing closing table tag in that cell.  I'm closing it
now, but I can't believe that's the problem]

The action page is fairly simple.  I can
#FORM.firstname# and it outputs fine and it inserts
into the database fine.  But, cferror is triggered and sends an e-mail
saying that FORM.firstname doesn't exist.  And, again, cfparam-ing it just
causes an empty string to go into the database [without cfparam, the
submitted form field goes into the database].



Scott Brady
http://www.scottbrady.net/

-- Original Message --
From: Mosh Teitelbaum <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 17 Sep 2002 13:09:38 -0400

>Do you have any code we could look at?
>
>--
>Mosh Teitelbaum
 
 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Timezones and CF

[Dan Haley]

Near as I can tell the Oracle equivalent of this is new_time().  I tried
finding something on "AT TIME ZONE" but wasn't able to.  Standards, pshaw
...

The URL below (probably wrapped 'cuz I use Outlook, but I don't care because
it's a corporate kind of thing) has some interesting date functions for
Oracle, but doesn't say what version.  Ones I didn't know about ...
last_day() for the last day of the month, and the use of round to give you
the first day of the year/month/etc.

http://cis.csuohio.edu/~matos/notes/cis-612/Oracle_Notes/html_notes/SQL-Func
tions.html

Dan

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 4:29 PM
To: CF-Talk
Subject: Re: Timezones and CF


Greg Luce wrote:
> I'm just familiar with Oracle, SQLServer, and Access. Oracle has
> "sysdate", while I believe SQL and Access use getdate().

You are right. If we are going to do it according to the standards, 
better do everything according to the standards :)

SELECT current_timestamp AT TIME ZONE '#your_time_zone#' AS myTime

Jochem


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

RE: Timezones and CF

[Dan Haley]

The key to those URLs is "9i".  I don't follow the standards for SQL so I
don't know how long current_timestamp and "at time zone" have been around,
but they aren't in 8i.  My fault for not specifying the database version
since I was only looking through the documentation for what we've got here.

The "Standards, pshaw ..." was simply humor.  And yes, it could be for the
lack of standards compliance because I can't use those standards. :)

Dan

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 1:43 AM
To: CF-Talk
Subject: Re: Timezones and CF


Dan Haley wrote:
> Near as I can tell the Oracle equivalent of this is new_time().

The Oracle equivalent of "current_timestamp" is "current_timestamp".
http://www.google.com/search?q=oracle+current_timestamp
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/fu
nctions31.htm


> I tried finding something on "AT TIME ZONE" but wasn't able to. 

The Oracle equivalent of "AT TIME ZONE" is "AT TIME ZONE".
http://www.google.com/search?q=oracle+%22AT+TIME+ZONE%22
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/ex
pressions7.htm


> Standards, pshaw ...

I'm afraid I don't understand this remark. It can't be the the lack of 
standards compliance in this case. Could you elaborate?

Jochem


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: scientific characters

[Dan Haley]

CF seems to handle it just fine in url encoding.  The micro symbol shows up
as %B5.  In CF Studio (Windows) you can get the micro symbol by typing
ALT-0181.  Not sure on browser compatibility, etc.

µ8^)

"What is that on your head?"  "Dude, it's a micro"

Dan

-Original Message-
From: Louis Klepner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:33 AM
To: CF-Talk
Subject: RE: scientific characters


The symbol is a sign for micro... This is what I get from viewing the source
of the HTML email I sent from Outlook:

m

I'm able to paste the character as HTML source, but I cannot paste it as the
symbol itself.
I wonder how it will survive URL encoding?

> -Original Message-
> From: Matthew Walker [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 18, 2002 6:27 PM
> To: CF-Talk
> Subject: RE: scientific characters
>
>
> What is the symbol? Is it a diameter symbol? If so IE6 doesn't support
> it. Is that any help?
>
> > -Original Message-
> > From: Louis Klepner [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, 19 September 2002 8:43 a.m.
> > To: CF-Talk
> > Subject: scientific characters
> >
> >
> > I'm having some issues with scientific characters...
> >
> > ..a relatively thick cornea, measuring 600 mm.
> 

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

RE: Urgent: Need help with a CFFILE error

[Dan Haley]

Does CFFILE work with URLs?  I thought it was only with file system paths.
I think the period is just a grammatically correct error message putting the
period inside the quote mark ...

-Original Message-
From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 3:00 PM
To: CF-Talk
Subject: Urgent: Need help with a CFFILE error


Hello,

I am uploading an application which was built by the previous team and now I
have to resolve some issues...

Here is the page:
http://webapps1.hud.gov/pih/pha/plans/approved/approved_plans.cfm

When there, select a state from the drop down menu and then it takes you to:

http://webapps1.hud.gov/pih/pha/plans/approved/view_approved_plans.cfm

Here is the segment of code from view_approved_plans.cfm:


 
  
  
  http://www.hud.gov/offices/pih/pha/approved/#fiscalyear#/#statecode#_#
fiscalyear#.txt"
 variable="phacodeoff">
  
  
 

And here is the error I am getting:

Error Diagnostic Information
Error processing CFFILE

Error attempting to read
'http://www.hud.gov/offices/pih/pha/approved/02/al_02.txt.' No such file or
directory (error 2)

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (449:11) to (451:25).


Date/Time: Thu Sep 19 17:41:05 2002
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95; YComp 5.0.0.0)
Remote Address: 10.200.36.101
HTTP Referrer:
http://webapps1.hud.gov/pih/pha/plans/approved/approved_plans.cfm


Now, I have no clue why is there a dot in the end of the file name which is
being read:
'http://www.hud.gov/offices/pih/pha/approved/02/al_02.txt.' 

If you go to http://www.hud.gov/offices/pih/pha/approved/02/al_02.txt you
will see that the file is there.

Any help will be appreciated!

Thanks,

Mitko

PS. I think the app server is ColdFusion 5 on Netscape Enterprise Server.

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT: Best JAVA Book...

[Dan Haley]

I've really liked reading the first few chapters of Thinking in Java and
Thinking in C++, but with no background in these languages didn't know if
they were any good.  I'm glad to see you recommend the Java book.
 
His books can be found online at www.bruceeckel.com
 , and he just released an update to Thinking in
Java.  I just noticed a 0.1 release of Thinking in C# also.
 
Dan
 

-Original Message- 
From: Sean A Corfield [mailto:[EMAIL PROTECTED]] 
Sent: Thu 9/19/2002 4:18 PM 
To: CF-Talk 
Cc: 
Subject: Re: OT: Best JAVA Book...



On Thursday, September 19, 2002, at 01:25 , Ken Brocx wrote: 
> Hi, I’d like some advice on a good JAVA book. 
> I know CF and ASP, but JAVA is new to me. 

Thinking In Java by Bruce Eckel is pretty good. 

I learned Java originally from Sun's own Java Language Tutorial and the 
other official Java books. 

An interesting Java book for the (mostly) complete applications it 
provides is "Industrial Strength Java" - not great code but the examples 
are useful and thought-provoking. 

Sean A Corfield -- http://www.corfield.org/blog/
  

"If you're not annoying somebody, you're not really alive." 
-- Margaret Atwood 


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: working with SQL meta data

[Dan Haley]

While it's not the best way to pull data ... how about doing a "select *" in
your query?  You get all the fields back and you can use
queryname.columnlist to see what columns are available.  This gives you a
list and you can then process the query results however you want.

If that doesn't work, 2 should be answered by the recordcount from your
query in 1.  And 4 would required building a dynamic query:


select  #valuelist(nameQuery.name)#
fromtable
where   ...


Is that what you are looking for??

Dan

-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 11:58 AM
To: CF-Talk
Subject: working with SQL meta data


PROBLEM:

1. I am continually inserting fields into a table (2-3/mth).
2. I would like my script to know how many fields exist; and
3. to be able to list them and 
4. pull data from them.



  

I got part one (which I thought was going to be the hard part) and I'm able
to list them (3.)



select name from syscolumns where upper(name) like '...' and id =
object_id('...')



So far so good.




I'm stumped on 2 -- which I thought was going to be the easy part.


I thought I could put the result into a list and work off the list.



#ListLen(tmp)#


No go. :-)




#name# works nicely




haven't gotten to yet


thx for any clues


// gilbert midonnet







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

RE: parsing user input to get count

[Dan Haley]

The following would work on what you are showing, but won't do any
validation of inputs ...











Dan

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 12:38 PM
To: CF-Talk
Subject: parsing user input to get count


I have a text field that I allow users to input data as follows:

1,2,5-9

Basically it is a coma delmited list with a range.  Whats the best way to
get a count... in this case I'd need to return 7

Thanks in advance...

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: List of printers

[Dan Haley]

You can use VBScript to get the information ... not sure on how best to
integrate with CF if that is your intent, or how the default printer works
with the system account since the default is stored in the registry.  If you
are doing this in CF and can use the  tag then you could read
the default printer directly.

Enumerate printers:
Set WshNetwork = WScript.CreateObject("WScript.Network")
Set oPrinters = WshNetwork.EnumPrinterConnections
For i = 0 to oPrinters.Count - 1 Step 2
   WScript.Echo "Port " & oPrinters.Item(i) & " = " & oPrinters.Item(i+1)
Next

Get default printer:
Set WshShell = WScript.CreateObject("WScript.Shell")

PrinterKey = "HKEY_CURRENT_USER\Software\Microsoft\Windows
NT\CurrentVersion\Windows\Device"
DefaultPrinter = WSHShell.RegRead(PrinterKey)

WScript.Echo DefaultPrinter

HTH,
Dan


-Original Message-
From: Shawn Richards [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 11:18 AM
To: CF-Talk
Subject: List of printers


Hi everyone,

Is there any way to get a list of the server printers with the default
printer identified?  This is on a Windows 2000 and Windows XP platform.  I
am currently using EnumPrinters.dll but it doesn't identify the default
printer.

Thanks
Shawn Richards
Rich Digital Solutions, Inc.
St. Charles, MO
www.richdigitalsolutions.com
[EMAIL PROTECTED]
636.926.0287 or 314.602.7097

 
 

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

RE: MIME type question

[Dan Haley]

Search the archives for posts about mime from Dave Watts
(http://www.houseoffusion.com/cf_lists).  He has a page out on figleaf.com
that I'm pretty sure has .csv as one of the examples.

Dan

-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 9:42 AM
To: CF-Talk
Subject: RE: MIME type question


That doesn't work either. 

I'm using this list for starters:
ftp://ftp.isi.edu/in-notes/iana/assignments/media-types/media-types. I was
hoping there was one they missed.

-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 12:50 PM
To: CF-Talk
Subject: RE: MIME type question


text/plain ?

-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 9:29 AM
To: CF-Talk
Subject: MIME type question


Does anyone know what MIME type a .csv file would have? I am trying to
upload a csv file using the CFFILE tag and can't seem to find the right
type.

The list of MIME types i've tried so far
text/x-csv,text/csv,application/csv,application/msexcel,application/excel,ap
plication/x-msexcel,application/vnd.ms-excel,application/x-excel

Thanks for any help.


Brian



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: MIME type question

[Dan Haley]

Ooops, committed that most horrible of sins and didn't read the question
closely enough to see the "upload".  On my server (CF4.5/W2K),
cffile.contenttype and cffile.contentsubtype show "application" and
"octet-stream" when I upload a .csv file.  Hmmm.

Dan

-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 11:50 AM
To: CF-Talk
Subject: RE: MIME type question


Mosh,

Yes, I am trying to put csv in the accept field of the cffile tag. None of
the accept types I have tried already seem to work...and i've tried just
about every combination (text/x-csv, text/csv, application/csv,
application/csv, application/msexcel,  application/excel,
application/x-msexcel, application/vnd.ms-excel, application/x-excel)

I'm able to upload excel files perfectly using application/vnd.ms-excel as
the accept value but just can't seem to get csv to work. 

The only thing I can think of is that the host I have my website located on
doesn't have .csv in the registry as a mime type. 



-Brian



-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 2:27 PM
To: CF-Talk
Subject: RE: MIME type question


Just out of curiosity, what does "doesn't work" mean in your context?  What
are you trying to do?

I'm assuming you're trying to place the mime-type in the ACCEPT attribute.
Are you trying to accept CSV but deny MS Excel format?

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


> -Original Message-
> From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 12:42 PM
> To: CF-Talk
> Subject: RE: MIME type question
>
>
> That doesn't work either.
>
> I'm using this list for starters:
> ftp://ftp.isi.edu/in-notes/iana/assignments/media-types/media-types. I was
> hoping there was one they missed.
>
> -Original Message-
> From: Rob Rohan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 12:50 PM
> To: CF-Talk
> Subject: RE: MIME type question
>
>
> text/plain ?
>
> -Original Message-
> From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 9:29 AM
> To: CF-Talk
> Subject: MIME type question
>
>
> Does anyone know what MIME type a .csv file would have? I am trying to
> upload a csv file using the CFFILE tag and can't seem to find the right
> type.
>
> The list of MIME types i've tried so far
> text/x-csv,text/csv,application/csv,application/msexcel,applicatio
> n/excel,ap
> plication/x-msexcel,application/vnd.ms-excel,application/x-excel
>
> Thanks for any help.
>
>
> Brian
>
>
> 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: MIME type question -- SOLVED

[Dan Haley]

Was just looking around on the server at mime-types (no expertise here), but
it appears that octet-stream is the default mime type.  Using this may allow
the upload of almost any type of file ...

Dan

-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 12:13 PM
To: CF-Talk
Subject: RE: MIME type question -- SOLVED


Thank you Dan!!! application/octet-stream works perfectly.


Solution to upload a csv file





-Brian

-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 3:19 PM
To: CF-Talk
Subject: RE: MIME type question


Ooops, committed that most horrible of sins and didn't read the question
closely enough to see the "upload".  On my server (CF4.5/W2K),
cffile.contenttype and cffile.contentsubtype show "application" and
"octet-stream" when I upload a .csv file.  Hmmm.

Dan

-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 11:50 AM
To: CF-Talk
Subject: RE: MIME type question


Mosh,

Yes, I am trying to put csv in the accept field of the cffile tag. None of
the accept types I have tried already seem to work...and i've tried just
about every combination (text/x-csv, text/csv, application/csv,
application/csv, application/msexcel,  application/excel,
application/x-msexcel, application/vnd.ms-excel, application/x-excel)

I'm able to upload excel files perfectly using application/vnd.ms-excel as
the accept value but just can't seem to get csv to work. 

The only thing I can think of is that the host I have my website located on
doesn't have .csv in the registry as a mime type. 



-Brian



-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 2:27 PM
To: CF-Talk
Subject: RE: MIME type question


Just out of curiosity, what does "doesn't work" mean in your context?  What
are you trying to do?

I'm assuming you're trying to place the mime-type in the ACCEPT attribute.
Are you trying to accept CSV but deny MS Excel format?

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


> -Original Message-
> From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 12:42 PM
> To: CF-Talk
> Subject: RE: MIME type question
>
>
> That doesn't work either.
>
> I'm using this list for starters:
> ftp://ftp.isi.edu/in-notes/iana/assignments/media-types/media-types. I was
> hoping there was one they missed.
>
> -Original Message-
> From: Rob Rohan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 12:50 PM
> To: CF-Talk
> Subject: RE: MIME type question
>
>
> text/plain ?
>
> -Original Message-
> From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 9:29 AM
> To: CF-Talk
> Subject: MIME type question
>
>
> Does anyone know what MIME type a .csv file would have? I am trying to
> upload a csv file using the CFFILE tag and can't seem to find the right
> type.
>
> The list of MIME types i've tried so far
> text/x-csv,text/csv,application/csv,application/msexcel,applicatio
> n/excel,ap
> plication/x-msexcel,application/vnd.ms-excel,application/x-excel
>
> Thanks for any help.
>
>
> Brian
>
>
> 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

RE: MIME type question -- SOLVED

[Dan Haley]

I tried adding .csv to the mime map in IIS, both at the global level and on
the website, and it still responded with octet-stream.  CF4.5 ... W2K ...

-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 12:26 PM
To: CF-Talk
Subject: RE: MIME type question -- SOLVED


Is it possible that the server I am hosting my site on doesn't have the csv
mime type registered? It's the one thing I haven't tried yet.

BTW the computer I am on is CF5 Win2K IIS


-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 3:29 PM
To: CF-Talk
Subject: RE: MIME type question -- SOLVED


If this worked "application/octet-stream" that means that Cold Fusion is not
correctly recognizing the CSV files doc type. I think that
"application/octet-stream" is for unknown mimes. Would this be a bug in MX?


Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 3:13 PM
To: CF-Talk
Subject: RE: MIME type question -- SOLVED


Thank you Dan!!! application/octet-stream works perfectly.


Solution to upload a csv file





-Brian

-----Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 3:19 PM
To: CF-Talk
Subject: RE: MIME type question


Ooops, committed that most horrible of sins and didn't read the question
closely enough to see the "upload".  On my server (CF4.5/W2K),
cffile.contenttype and cffile.contentsubtype show "application" and
"octet-stream" when I upload a .csv file.  Hmmm.

Dan

-Original Message-
From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 11:50 AM
To: CF-Talk
Subject: RE: MIME type question


Mosh,

Yes, I am trying to put csv in the accept field of the cffile tag. None of
the accept types I have tried already seem to work...and i've tried just
about every combination (text/x-csv, text/csv, application/csv,
application/csv, application/msexcel,  application/excel,
application/x-msexcel, application/vnd.ms-excel, application/x-excel)

I'm able to upload excel files perfectly using application/vnd.ms-excel as
the accept value but just can't seem to get csv to work.

The only thing I can think of is that the host I have my website located on
doesn't have .csv in the registry as a mime type.



-Brian



-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 2:27 PM
To: CF-Talk
Subject: RE: MIME type question


Just out of curiosity, what does "doesn't work" mean in your context?  What
are you trying to do?

I'm assuming you're trying to place the mime-type in the ACCEPT attribute.
Are you trying to accept CSV but deny MS Excel format?

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


> -Original Message-
> From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 12:42 PM
> To: CF-Talk
> Subject: RE: MIME type question
>
>
> That doesn't work either.
>
> I'm using this list for starters:
> ftp://ftp.isi.edu/in-notes/iana/assignments/media-types/media-types. I was
> hoping there was one they missed.
>
> -Original Message-
> From: Rob Rohan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 12:50 PM
> To: CF-Talk
> Subject: RE: MIME type question
>
>
> text/plain ?
>
> -Original Message-
> From: Brian Ferrigno [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 02, 2002 9:29 AM
> To: CF-Talk
> Subject: MIME type question
>
>
> Does anyone know what MIME type a .csv file would have? I am trying to
> upload a csv file using the CFFILE tag and can't seem to find the right
> type.
>
> The list of MIME types i've tried so far
> text/x-csv,text/csv,application/csv,application/msexcel,applicatio
> n/excel,ap
> plication/x-msexcel,application/vnd.ms-excel,application/x-excel
>
> Thanks for any help.
>
>
> Brian
>
>
>






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: CGI Variable for (Non-existent) Page Requested?

[Dan Haley]

Here's what we use in our page ... our missing template handler is under the
web root, and IIS is set up to "check that file exists" for CFM requests,
and the 404 error page in IIS is pointed to the CF missing template handler
..





... further processing




... further processing



Dan

-Original Message-
From: Bob Haroche [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 11:27 AM
To: CF-Talk
Subject: Re: CGI Variable for (Non-existent) Page Requested?


Bryan,

Thanks, but #HTTP_REFERER# works only to tell me what page the visitor is
coming from. I need to know what (non-existent) page they're *requesting*,
even in the situation where they're not coming from any other page but using
a bookmark or typing a bad URL into the browser address bar.

Any other ideas?

Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: CGI Variable for (Non-existent) Page Requested?

[Dan Haley]

In the properties window for your website, choose Home Directory, then
Configuration, choose the .cfm application mapping and click on Edit, check
the "Check that file exists" check box.  This will send requests for missing
cfm pages directly to your 404 page, rather than sending them to CF to
handle.  Then back on the properties page choose Custom Errors and put a URL
in for your 404 error.

Dan

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 11:58 AM
To: CF-Talk
Subject: RE: CGI Variable for (Non-existent) Page Requested?


How do you setup IIS like this? Very cool.


Bryan F. Hogan
Director of Internet Development
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-----
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 2:43 PM
To: CF-Talk
Subject: RE: CGI Variable for (Non-existent) Page Requested?


Here's what we use in our page ... our missing template handler is under the
web root, and IIS is set up to "check that file exists" for CFM requests,
and the 404 error page in IIS is pointed to the CF missing template handler
.





... further processing




... further processing



Dan

-Original Message-
From: Bob Haroche [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 11:27 AM
To: CF-Talk
Subject: Re: CGI Variable for (Non-existent) Page Requested?


Bryan,

Thanks, but #HTTP_REFERER# works only to tell me what page the visitor is
coming from. I need to know what (non-existent) page they're *requesting*,
even in the situation where they're not coming from any other page but using
a bookmark or typing a bad URL into the browser address bar.

Any other ideas?

Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: SQL Question

[Dan Haley]

udpate tablename
set column = 0
where id > 100
and id < 200
and mod(id, 2) = 0

The mod() may or may not work depending on the database ... but should be
easy to replace to make it work ...
Dan

-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 1:54 PM
To: CF-Talk
Subject: OT: SQL Question


Hi all,

Here's what I want to do:
UPDATE tablename
SET column = 0
WHERE ID = ???

I want to specify a range of numbers (like 100-200) and increment it by 2.
So, 100, 102,104etc would only be updated and the rest wouldn't.

Any ideas?
Thanks,
T


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

cfheader and statuscode="500

[Dan Haley]

Can I do this?  I've successfully used  and
caused a redirect, but I can't get CF to return a statuscode="500" or
statuscode="404".  We are putting in a new switch to handle traffic to our
servers and we wan't it to redirect traffic if it gets anything other than
an HTTP status of 200.  The page it is checking has CF code in it to verify
that the database is available, and if there are any errors I want to return
a 500 status so the switch redirects to the other server.  Using CF4.5 on
Win2K with IIS.

TIA,
Dan
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: Studio tips

[Dan Haley]

Happened to find this one just now quite by accident . . . Ctrl + Up
Arrow/Down Arrow.  Moves the editor screen up and down without moving the
cursor - emulates the scroll bar without having to move to the mouse.

Dan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 8:34 AM
To: [EMAIL PROTECTED]
Subject: Re: Studio tips


In a message dated 08/02/2000 9:31:52 PM Eastern Daylight Time, 
[EMAIL PROTECTED] writes:

<< We are giving a small presentation at the Ottawa ColdFusion User Group
 Meeting this Tuesday and I am looking for anything you can send.
 
 Things like keyboard shortcuts, things people do to make coding a little
 easier.  Some tricks that people who use Studio to code every once in a
 while might not know. >>

There are only a few I use often.  But maybe they will help (or maybe
someone 
else has already covered them)

Other than Ctrl + W to close a file and Ctrl + S to save it, I use Ctrl + F 
to run Code Sweep.  Of course, you have to have the correct Sweep designated

as the default for the type of code sweep you need for the file you have 
open.  Our old Webmaster was a stickler for Code Sweep.  And she had a
point. 
 It kept everyone not only neat, but also similarly laid out...

:-)
Oriole

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

[Dan Haley]

Wow, that's ugly.  You don't even need to do the refresh, just view the
source of the page and it is right there.  It only seems to work if you know
the directory where application.cfm exists.  If you are operating with a
single application.cfm you can move it up one directory, outside of the web
root, and it doesn't work.  It also doesn't appear to work with other .cfm
files.


Don't use application.cfm - use app_globals.cfm.  :)


Dan

-Original Message-
From: Dave Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 9:27 AM
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: sorting question

[Dan Haley]

This works in Oracle . . . 

select  text_field
fromsometable
order byto_number(decode(instr(text_field, '('), 0, text_field,
substr(text_field, 1, instr(text_field, '(') - 1))), text_field

It will sort numerically, and then alphabetically those items with the same
numeric value at the beginning.  A test table I created with the values of
1,9,10,2,1(a),1(1),2(1) sorted as follows - 1, 1(1), 1(a), 2(1), 9, 10.

Dan



-Original Message-
From: Ashe Richards [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 9:30 AM
To: [EMAIL PROTECTED]
Subject: sorting question


This is a multi-part message in MIME format.

--=_NextPart_000_0056_01BFFD3E.1E32F940
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I've got a database with a lot of potentially numeric data in text =
fields. When I order by this column, my result set is somethng like:

1,10,11,12,2,20,21,3

Instead of 1,2,3,10,11,12,20,21

Is there some method of getting these in the correct order?

I've already tried putting the data into an array and sorting that, to =
no avail.
Also, another probelm with the dataset that may be returned is that =
sometimes the fields do contain text, such as 1(1),1(2), or 1(a),1(b). =
And this needs to be taken into account in the sorting procedure.


TIA

Ashe Richards


--=_NextPart_000_0056_01BFFD3E.1E32F940
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I've got a database with a lot of potentially =
numeric data in=20
text fields. When I order by this column, my result set is somethng=20
like:
 
1,10,11,12,2,20,21,3
 
Instead of 1,2,3,10,11,12,20,21
 
Is there some method of getting these in the correct =

order?
 
I've already tried putting the data into an array =
and sorting=20
that, to no avail.
Also, another probelm with the dataset that may be =
returned is=20
that sometimes the fields do contain text, such as 1(1),1(2), or =
1(a),1(b). And=20
this needs to be taken into account in the sorting =
procedure.
 
 
TIA
 
Ashe Richards
 

--=_NextPart_000_0056_01BFFD3E.1E32F940--


--
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: Printing question

[Dan Haley]

Just FYI - one of the best places to get the most recent messages (they have
the last couple of months available), is Monkeywerks.
http://www.pdm-inc.com/mky.htm.  Searchable, fast, and the most recent
messages are there very quickly.

Dan

-Original Message-
From: Sandi Benditt [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 7:41 AM
To: [EMAIL PROTECTED]
Subject: Printing question


I tried searching the archive first, really I did, but the archive only 
seems to go through the end of Jan (unless there's another archive I can't 
find).  What I did find was a question real close to what I need to ask, 
but not the solution.

Here's the original question:
"Does anyone know if there is a custom tag to send the contents of a form 
right to a printer without actually having anyone having to press any form 
buttons or having to execute anything? I am going to be creating an online 
order form and i'd like to have it so then the user submits the form it 
automatically just gets printed out. If  anyone knows of anything like this 
can you let me know,
even if it's not CF based."

What we are actually trying to do is when the user fills out a form and 
submits it a bar code label will print.  Pressing a form button is okay.

I've looked at CF_Print and CFX_Print and neither of them will work for us.

Thanks in advance.

--
Sandi Benditt
Sr. Programmer Analyst - Advanced Technologies
DecisionOne


--
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: Selecting records at random in Oracle

[Dan Haley]

You can probably do this in many ways, but the trick will be to keep the
amount of calls to the database to a minimum.  With that in mind, here's a
first try . . . 



select  rowid
fromsometable



 umm, you can look this up . . . 



select  field1, field2
fromsometable
where   rowid in ('#get_all_ids.rowid[randomnumber1]#',
'#get_all_ids.rowid[randomnumber2]#',
'#get_all_ids.rowid[randomnumber3]#')


Dan

-Original Message-
From: Brandon Behrens [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 10:10 AM
To: [EMAIL PROTECTED]
Subject: OT: Selecting records at random in Oracle


Hello all,

I don't know if this is possible but I was wondering if there was a way to
tell oracle (using cold fusion) that I wanted 3 records, but I didn't care
which ones they were.  I guess a good analogy would be you load up a page
and you want to display a banner ad, but you don't care which banner ad you
display.  Any help would be appreciated.

Thanks in advance,

Brandon Behrens

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.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.

RE: Paging query results question

[Dan Haley]

The number of queries that ColdFusion caches is a server setting, and is not
controlled by the tag.  While it would make sense to include a reference to
that limitation in the language reference, the "Administering the ColdFusion
Server" documentation does include it.  Chapter 3, Configuring ColdFusion
Server, Caching Settings.   This setting can be set anywhere from 0 to 100.

Dan

-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 1:02 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: Paging query results question


--=_21662761==_.ALT
Content-Type: text/plain; charset="us-ascii"

Sorry, I didn't mention that I have the hard-copy Cold Fusion reference set
from Allaire:

Cold Fusion 4.5 CFML Language Reference
Cold Fusion 4.5 Developing Web Applications with Cold Fusion
 and
Cold Fusion 4.5 Administering Cold Fusion Server


At 03:45 PM 8/4/00 -0400, Peter Theobald wrote:
>--=_20677026==_.ALT
>Content-Type: text/plain; charset="us-ascii"
>
>On the mailing list I *CONSTANTLY*  hear people mention facts that are not
in the Cold Fusion documentation.
>In this example, how did you know there is a limit of 100 cached queries?
The Cold Fusion Language Reference doesn't say that in the description of
CFQUERY.
>
>Where is everybody getting this information.
>I must say that, although I love working in Cold Fusion, the Cold Fusion
documentation is among the WORST language documentation I have ever had the
misfortune of struggling with.
>
>Even the so-called Reference manual is little more than a brief description
of each TAG.
>Where is the definitive definition of exactly how each element behaves?
>
>How can they say  is "like" Javascript, but not exactly?! Where
is the rigorous description of every element?
>When I write CFSCRIPT programs that are "like" Javascript, I find out by
trial and error just how "like" it is and isn't.
>
>At 07:17 AM 8/4/00 -0700, paul smith wrote:
>
>>I've done something similar, except I cache the big query for 5 minutes.
>>
>>In addition, I store the long list of IDs as a client variable (in a 
>>database).  The cache thus trades the need to create sublists for a 
>>database read AND speeds up the paging queries (since the cache is in 
>>memory).  Works well, but on a busy site I'm concerned I'll run up against

>>the limit of 100 cached queries.
>>
>>I also wonder about the speed of lists, both the time it takes to create 
>>them, and the resultant use of WHERE ID IN (#ID_List#), compared to using
a 
>>JOIN on a table that contains the IDs as a column.
>>
>>Anyone?
>>
>>best,  paul
>>
>>At 10:14 AM 8/4/00 +0100, you wrote:
>>>Ok here's my take on the problem, and actually what I use.
>>>
>>>Notes, we are always reloading the the same page results.cfm (ie. next
>>>& prev links link right back to results.cfm), there are three
>>>variables which will get passed, startRow, maxRows & resultIDList, all
>>>of which I assume are undefined when I first enter the page.  startRow
>>>& maxRows are passed via the URL, resultIDList is passed in some other
>>>fashion; client.resultIDList, or whatever takes your fancy (passing
>>>all three in a hidden form is quite nice).
>>>
>>>Enter page.
>>>if startRow & maxRows are undefined, give them some value.
>>>if resultIDList is undefined then...
>>>   Do the QUERY, but return only the ID values:
>>> SELECT id FROM somewhere WHERE somethingComplex
>>>   create resultIDList as an empty list, and then loop round the query
>>>populating the list
>>>   resultIDList = ''
>>>   resultIDList =
>>>listAppend(resultIDList,#id#)
>>>endif
>>>
>>>What we have done here is checked to see if a list already existed, if
>>>it didn't we run the query to get all the records which match our
>>>search out, and only return the ID value.
>>>Next time we enter this page, the list will already have been defined,
>>>therefore the query will not run again (handy for those 200 record
>>>returns)
>>>
>>>Now you create a subset of that list using the startRow and maxRow,
>>>I'll leave that exercise up to the cunning of the reader. (subsetList
>>>= from startRow to startRow+maxRows, do listGetAt etc. etc. etc. etc.)
>>>
>>>Finally we can pull all we really need from the database using our
>>>subList;
>>>SELECT * FROM somewhere WHERE id IN (#sublist#)
>>>
>>>So what happened here?  Well we hit the database once for the big-hit
>>>of 200 records or so, and then again (say 20 times) for our display of
>>>results for this page.  But once we move onto the next page, we don't
>>>run that big assed query again, just the smaller 20 hit one.
>>>
>>>Of course we could cache the first query >>DATASOURCE="myData" CACHEWITHING="#CreateTimeSpan(0,6,0,0)#">, so
>>>rerunning it on each page didn't really give us a big database
>>>slowdown, but, here's the pay off...
>>>
>>>You can use the above method to run a number of queries the first time
>>>to enter the page, and append th

RE: Selecting records at random in Oracle

[Dan Haley]

Depends on the size of the table.  If the data table has 30 or 40 fields and
15,000 records, why bring the whole thing across the wire?  Bringing just
the rowids across will be much faster, and getting the three random records
won't take long.  Now, if the data was somewhat static, I could see getting
the whole thing and storing it in an application variable or caching the
query.

Of course, if the table is small, your approach is perfect. :)

Dan

-Original Message-
From: Sharon DiOrio [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 1:14 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Selecting records at random in Oracle


How about this:




SELECT column1, column2, column3
FROM Table






#APPLICATION.get_all_ids[RandRange(1,
APPLICATION.get_all_ids.recordcount)]#



Why requery when you've already gotten all the records?

Sharon


At 01:05 PM 8/4/2000 -0700, Dan Haley wrote:
>You can probably do this in many ways, but the trick will be to keep the
>amount of calls to the database to a minimum.  With that in mind, here's a
>first try . . . 
>
>
>
>select rowid
>from   sometable
>
>
>
> umm, you can look this up . . . 
>
>
>
>select field1, field2
>from   sometable
>where  rowid in ('#get_all_ids.rowid[randomnumber1]#',
>'#get_all_ids.rowid[randomnumber2]#',
>   '#get_all_ids.rowid[randomnumber3]#')
>
>
>Dan
>
>-Original Message-
>From: Brandon Behrens [mailto:[EMAIL PROTECTED]]
>Sent: Friday, August 04, 2000 10:10 AM
>To: [EMAIL PROTECTED]
>Subject: OT: Selecting records at random in Oracle
>
>
>Hello all,
>
>I don't know if this is possible but I was wondering if there was a way to
>tell oracle (using cold fusion) that I wanted 3 records, but I didn't care
>which ones they were.  I guess a good analogy would be you load up a page
>and you want to display a banner ad, but you don't care which banner ad you
>display.  Any help would be appreciated.
>
>Thanks in advance,
>
>Brandon Behrens
>
>Brandon Behrens
>The Internet Design Firm
>512.451.5225
>[EMAIL PROTECTED]
>http://www.theidf.com
>
>
>
>---
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
> 


--
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: Hello?

[Dan Haley]

Yes . . . it seems there are some problems . . . some of us are now
subscribed to a psuedo-digest version . . . I didn't get any messages for
half the morning, and then got 90 all at once.  Yesterday was worse . . .
none all Wed. afternoon, then over 300 when I got here in the morning.  Or
was it the day before . . . h?

Any luck tracking down the problem Michael?

And thanks for all the hard work in advance ;)

Dan

-Original Message-
From: Katrina Chapman [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 04, 2000 1:39 PM
To: [EMAIL PROTECTED]
Subject: Hello?


Is there anyone out there?

--K

--
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: Studio replacing characters

[Dan Haley]

There are two closing  ">" for the option tag.  That would probably confuse
CF Studio and it would throw in the > thinking it is part of the display.

This:
SELECTED>Unavailable

Should be:
SELECTED>Unavailable

Dan

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 12:55 PM
To: [EMAIL PROTECTED]
Subject: Re: Studio replacing characters




SELECTED

>Unavailable

In this example it is in the HTML. It shouldn't replace it if it is part of
a tag.

- Original Message -
From: "Chapman, Katrina" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 07, 2000 1:46 PM
Subject: RE: Studio replacing characters


> But the problem is it's not a display.  It will cause problems.  If it
does
> it on a CF tag it will give and "invalid token found" error.  If it does
it
> on an HTML tag it will break the display of the page.
>
> --K
>
> -Original Message-
> From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 07, 2000 12:36 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Studio replacing characters
>
>
> > is the symbol for > just as < is the symbol for <
> It will still display the same
> - Original Message -
> From: "Hondo Burney" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, August 07, 2000 4:20 PM
> Subject: Studio replacing characters
>
>
> > Got a problem with Studio 4.5.1, it sometimes randomly replaces the a
> closing
> > tag symbol ">" with the html code ">"
> >
> > For instance, about every 4 or 5 times I save the document it will
replace
> > this
> > line :
> >
> >  > 3>SELECTED>Unavailable
> >
> > with this one
> >
> >  > 3>SELECTED>Unavailable
> >
> > I have tried turning off the "automaticly convert special characters"
> > function.
> >
> > Also, it sometimes will apend some variation of the following to my
files
> as I
> > save them "23:10". This is more an annoyance than a real problem, but i
> would
> > still like to figure out why it does this.
> >
>
> --
> 
> > 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.
--
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: not seeing debug information ...

[Dan Haley]

Are you going through a proxy to see the web server?  Use cgi.remote_addr on
a page on that server to verify the ip address that CF sees when you visit
the server.

Dan

-Original Message-
From: c talk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 8:01 AM
To: cf-talk
Subject: not seeing debug information ...


Hi

I've put my PC's IP in the CF Admin Debug settings window. When I view
pages,
none of the debug info displays. When I remove all of the IP addresses, the
debug info displays. When I put my IP in alone, no dice.

FWIW, the CF Server can ping my PC by name.

Any ideas why this is?

Thanks,

* john *

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

(IIS) Customer file uploads - restrictions of file types

[Dan Haley]

We are getting requests from our customers to upload files to a password
secured area of our site so they can share them with other users from their
company, as well as with our internal people.  The intent is for files like
Excel, Word, and Powerpoint documents.  Some of the restrictions we need to
do are pretty straightforward, like who can upload, who can delete, total
file size, etc., but what pitfalls do I need to watch out for from a server
security standpoint?  We are on IIS 4.0, Windows NT 4.0 SP5, CF4.5 ENT, with
plans to go to Win2000.  Is it as simple as restricting certain executable
file types?

All advice is truly appreciated . . . unless Dave Watts sends me more code
from our site . . . whoops . . . :)

Thanks,
Dan
--
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: Comma/Number Problem

[Dan Haley]

Or, evn easier - val("somenumber") . . . val("10,500") = 10500

Dan

-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 12:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Comma/Number Problem


How about newstring=replace(oldstring,",","","ALL")

- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 10, 2000 1:24 PM
Subject: Comma/Number Problem


> Hi,
>
> I am trying to add a bunch of numbers to get a total value. It works fine
> unless someone uses a comma to separate 'thousands':
>
> Ex. 10,500
>
> How do I get rid of the comma before I add it up??
>
> EX. 10500
>
> Thanks
>
> Sal
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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.
--
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: Comma/Number Problem

[Dan Haley]

Wow, take back what I said in my last message . . . I could have sworn the
last time this came up I tested it, and it worked . . . val("10,500") DOES
NOT equal 10500.  It must be because CF thinks 10,500 is a list, but
val("10,500") comes back as 10.

Slap me silly on this one . . . go with the "cleanNumber" setup mentioned by
Sean G.

Dan

-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 12:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Comma/Number Problem


How about newstring=replace(oldstring,",","","ALL")

- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 10, 2000 1:24 PM
Subject: Comma/Number Problem


> Hi,
>
> I am trying to add a bunch of numbers to get a total value. It works fine
> unless someone uses a comma to separate 'thousands':
>
> Ex. 10,500
>
> How do I get rid of the comma before I add it up??
>
> EX. 10500
>
> Thanks
>
> Sal
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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.
--
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: Structs contained within the application scope?

[Dan Haley]

Umm, what am I missing here?  As I was about to type in the duplicate
function, I thought "wait, we use structcopy with structures more than one
level deep", so I did some testing and I can't recreate this problem (or
expected behavior) in either 4.0.1 or 4.5.  I was able to structcopy a
structure multiple levels deep, and assign the application structure to a
variable.  The only problem I ran into is that doing a structcopy on the
application variable was the same as a simple assignment - it was still just
a pointer.

Here is one of the tests I ran - ( is from the developer's
exchange):




















Am I missing something that will bite me in the rear in the future?  Or just
totally misunderstanding this e-mail.

Thanks,
Dan




> I can get around this problem by manually copying the struct
> like so (but it's a pain in the rear):
>
> 
>
> So my question is...  Shouldn't the StructCopy() function copy the
> entire struct, and any other structs stored inside it? Has anyone
> else run into this experience, or is it considered expected behavior
> when copying structs which contain other structs?

This is expected behavior with StructCopy; it only copies "one level
deep".
If you want to make a complete duplicate, no matter how many nested data
containers you have, use the Duplicate function introduced in CF 4.5.1,
which makes a "deep copy".

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.

RE: Database problems

[Dan Haley]

You most likely want the  outside the .  CF is
probably never hitting the closing  tag and therefore is
doing a rollback of the insert.

Just a guess, but makes sense.  I think.  :)

Dan

-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: Database problems


 

Katrina

Chapman  To: [EMAIL PROTECTED]

   Subject: RE: Database problems

 

08/11/2000

11:45 AM

Please

respond to

cf-talk

 

 







Can we see some code?  You may be nesting your tags incorrectly.

--K

Katrina,

I think the code's fine, but here is the action template, anyway.

Thanks,
--John



insert into LINKS
   (APPROVE,
   TYPE_DESC,
   MAIN_NBR,
   LINK)
values
   ('#form.APPROVE#',
   '#form.TYPE_DESC#',
   '#form.MAIN_NBR#',
   '#form.LINK#')



 select max(record) as newrecord
 from links









--
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: Version 4.5.1 memory leak fixed?

[Dan Haley]

Ken,

What platform and OS are you on?  We have 4.5 and I'm wondering whether to
up to 4.5.1 or not.  We are on NT 4.0 SP5 with plans to go to Windows 2000
soon.  I haven't researched the benefits yet, I've just seen lots of people
complain about it on here.

Thanks,
Dan

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 12, 2000 11:21 AM
To: [EMAIL PROTECTED]
Subject: Re: Version 4.5.1 memory leak fixed?


Works great for me.

Ken Wilson



- Original Message -
From: PC <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 1:35 PM
Subject: Version 4.5.1 memory leak fixed?


> Is this a stable platform yet?
>
> --

> 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: CF Administrator Mapping and Apache Alias

[Dan Haley]

Short answer - yes.

Long answer - Think of physical directories under the web root and virtual
directories set up in the web server (thinking of IIS here) as directories
to be used in HTML, such as  and .  Think of CF
mappings as only available to CF code, such as  and .
In fact, in  and , if you want an absolute reference
(starting with "/"), then you can only use CF mappings.  Without CF mappings
you must use relative references ("../../", etc.).  One nice thing about CF
mappings is you can move included CF files out of the web root and then
noone can access them via the browser . . . it makes security easier.

HTH,
Dan

-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 5:35 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: CF Administrator Mapping and Apache Alias



How about virtual servers?
If I set up a CF mapping, for instance: /includes =
/home/httpd/html/docs/www.thissite.com/includes
Then do *ALL* sites on that server get the SAME include (to the wrong
site in most cases).


At 07:09 PM 8/14/00 -0400, Peter Theobald wrote:
So you are saying it does not affect URL
requests at all, right?
It only affects CFINCLUDE?

Your example can't be right. You are using the mapping as a variable
"#foo#/SomeTemplate.cfm"
If that were right, I wouldn't need mapping at all. I would just set a
variable.
It must be more like this:

MAP /cflib = /usr/home/coldfusion/library/peter




At 06:56 PM 8/14/00 -0400, Jeremy Allen wrote:
All mappings do is create an alias for a
phsyical directory...

like say if you wanted an absolute reference for CFINCLUDE

you could make a mapping named Foo which points to
/usr/home/cftagman/cftags

And say you had a lot of templates in /usr/home/cftagman/cftags then
you
could use

 and
Sometemplate.cfm
would of course be in the D:\CFStuff directory.

Thats all :)

Its purely CF driven and referenced with CF basically its a nice
way to map out the absolute location for something.  of course
NT machines start with drive letters ;) So I would say that a
that the Apache alias takes higher precedence than the CF
Mapping.

Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]


-Original Message-
From: Peter Theobald
[mailto:[EMAIL PROTECTED]"
eudora="autourl">mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 6:38 PM
To: [EMAIL PROTECTED]
Subject: CF Administrator Mapping and Apache Alias


What exactly does CF Administrator mapping do?
Does it map URLs as they come in, in other words it affects ALL http
requests even to .html files?
Or does it map URLs that are to .cfm files?
Or does it only affect CFINCLUDE?

How does it interact with Apache directory "Alias"
mapping?

I want to map certain directories for images and cfm files. I also want a
different set of mappings for my CF library of includable
"functions" so I can use  although that file is NOT
located under my document root.



--
-
Peter Theobald, Chief Technology Officer
LiquidStreaming
http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032



--
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/<
br>
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=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/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/<
br>
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=lists/cf_talk or send a message to [EMAIL PROTECTED]
with 'unsubscribe' in the body. 

---<
br>
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com/"
eudora="autourl">http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/"
eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/<
br>
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=lists/cf_talk

RE: CF Administrator Mapping and Apache Alias

[Dan Haley]

How about this . . . set up three CF mappings . . . includes_prod,
includes_test, and includes_dev . . . or names of your choice, of course! .
. . and then in your application.cfm set a variable to the appropriate
mapping depending on the cgi.server_name . . .  . . . and then you would include the right file . . .



Dan

-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 6:59 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: CF Administrator Mapping and Apache Alias


Well, in this case I have:
1) a live production site
2) a staging/testing site
3) a development site

All as virtual server on one physical server. In Apache I can map virtual
directories so each site has a different images directory for example. But
in the Cold Fusion Administrator I cannot map different INCLUDE roots for
each virtual site. I store my libraries of CF modules in a directory that I
want to use absolute references to for convenience and security. But I
cannot have developers working and testing on these libraries if I cannot
map different directories for the live, staging, and development virtual
servers. They all share ONE directory!
That means back to relative paths or setting up two more servers :-(


At 07:04 PM 8/14/00 -0700, Dan Haley wrote:
>Short answer - yes.
>
>Long answer - Think of physical directories under the web root and virtual
>directories set up in the web server (thinking of IIS here) as directories
>to be used in HTML, such as  and .  Think of CF
>mappings as only available to CF code, such as  and .
>In fact, in  and , if you want an absolute reference
>(starting with "/"), then you can only use CF mappings.  Without CF
mappings
>you must use relative references ("../../", etc.).  One nice thing about CF
>mappings is you can move included CF files out of the web root and then
>noone can access them via the browser . . . it makes security easier.
>
>HTH,
>Dan
>
>-Original Message-
>From: Peter Theobald [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 14, 2000 5:35 PM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
>[EMAIL PROTECTED]
>Subject: RE: CF Administrator Mapping and Apache Alias
>
>
>How about virtual servers?
>If I set up a CF mapping, for instance: /includes =
/home/httpd/html/docs/www.thissite.com/includes
>Then do *ALL* sites on that server get the SAME include (to the wrong site
in most cases).
>
>
>At 07:09 PM 8/14/00 -0400, Peter Theobald wrote:
>>So you are saying it does not affect URL requests at all, right?
>>It only affects CFINCLUDE?
>>
>>Your example can't be right. You are using the mapping as a variable
"#foo#/SomeTemplate.cfm"
>>If that were right, I wouldn't need mapping at all. I would just set a
variable.
>>It must be more like this:
>>
>>MAP /cflib = /usr/home/coldfusion/library/peter
>>
>>
>>
>>
>>At 06:56 PM 8/14/00 -0400, Jeremy Allen wrote:
>>>All mappings do is create an alias for a phsyical directory...
>>>
>>>like say if you wanted an absolute reference for CFINCLUDE
>>>
>>>you could make a mapping named Foo which points to
/usr/home/cftagman/cftags
>>>
>>>And say you had a lot of templates in /usr/home/cftagman/cftags then you
>>>could use
>>>
>>> and Sometemplate.cfm
>>>would of course be in the D:\CFStuff directory.
>>>
>>>Thats all :)
>>>
>>>Its purely CF driven and referenced with CF basically its a nice
>>>way to map out the absolute location for something.  of course
>>>NT machines start with drive letters ;) So I would say that a
>>>that the Apache alias takes higher precedence than the CF
>>>Mapping.
>>>
>>>Jeremy Allen
>>>[EMAIL PROTECTED]
>>>[Insert cool title here]
>>>
>>>
>>>-Original Message-
>>>From: Peter Theobald [mailto:[EMAIL PROTECTED]]
>>>Sent: Monday, August 14, 2000 6:38 PM
>>>To: [EMAIL PROTECTED]
>>>Subject: CF Administrator Mapping and Apache Alias
>>>
>>>
>>>What exactly does CF Administrator mapping do?
>>>Does it map URLs as they come in, in other words it affects ALL http
requests even to .html files?
>>>Or does it map URLs that are to .cfm files?
>>>Or does it only affect CFINCLUDE?
>>>
>>>How does it interact with Apache directory "Alias" mapping?
>>>
>>>I want to map certain directories for images and cfm files. I also want a
different set of mappings for my CF library of includable "functions" so I
can use  although that file is NOT
located under my document root.
&g

RE: CF Administrator Mapping and Apache Alias

[Dan Haley]

Yeah, guess you're right . . . damn, hate it when I'm on the road and the
brain stays at work . . . :) . . . but your point makes sense, what is the
difference between a mapping and setting a variable?  Really none . . .
 . . . or maybe not . . . haha . . . anyone else on
cf-talk down at the Motorola Developer's Conference?

Dan

-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 9:33 PM
To: Dan Haley; [EMAIL PROTECTED]
Subject: RE: CF Administrator Mapping and Apache Alias


Kinda' makes mapping useless in this particular case.
Yes, I could use the cgi.server_name to figure it out. That works for me.


At 09:11 PM 8/14/00 -0700, Dan Haley wrote:
>
>How about this . . . set up three CF mappings . . . includes_prod,
>includes_test, and includes_dev . . . or names of your choice, of course! .
>. . and then in your application.cfm set a variable to the appropriate
>mapping depending on the cgi.server_name . . . = "/includes_prod"> . . . and then you would include the right file . . .
>
>
>
>Dan
>
>-Original Message-
>From: Peter Theobald [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 14, 2000 6:59 PM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: RE: CF Administrator Mapping and Apache Alias
>
>
>Well, in this case I have:
>1) a live production site
>2) a staging/testing site
>3) a development site
>
>All as virtual server on one physical server. In Apache I can map virtual
>directories so each site has a different images directory for example. But
>in the Cold Fusion Administrator I cannot map different INCLUDE roots for
>each virtual site. I store my libraries of CF modules in a directory that I
>want to use absolute references to for convenience and security. But I
>cannot have developers working and testing on these libraries if I cannot
>map different directories for the live, staging, and development virtual
>servers. They all share ONE directory!
>That means back to relative paths or setting up two more servers :-(
>
>
>At 07:04 PM 8/14/00 -0700, Dan Haley wrote:
>>Short answer - yes.
>>
>>Long answer - Think of physical directories under the web root and virtual
>>directories set up in the web server (thinking of IIS here) as directories
>>to be used in HTML, such as  and .  Think of CF
>>mappings as only available to CF code, such as  and .
>>In fact, in  and , if you want an absolute reference
>>(starting with "/"), then you can only use CF mappings.  Without CF
>mappings
>>you must use relative references ("../../", etc.).  One nice thing about
CF
>>mappings is you can move included CF files out of the web root and then
>>noone can access them via the browser . . . it makes security easier.
>>
>>HTH,
>>Dan
>>
>>-Original Message-
>>From: Peter Theobald [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, August 14, 2000 5:35 PM
>>To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
>>[EMAIL PROTECTED]
>>Subject: RE: CF Administrator Mapping and Apache Alias
>>
>>
>>How about virtual servers?
>>If I set up a CF mapping, for instance: /includes =
>/home/httpd/html/docs/www.thissite.com/includes
>>Then do *ALL* sites on that server get the SAME include (to the wrong site
>in most cases).
>>
>>
>>At 07:09 PM 8/14/00 -0400, Peter Theobald wrote:
>>>So you are saying it does not affect URL requests at all, right?
>>>It only affects CFINCLUDE?
>>>
>>>Your example can't be right. You are using the mapping as a variable
>"#foo#/SomeTemplate.cfm"
>>>If that were right, I wouldn't need mapping at all. I would just set a
>variable.
>>>It must be more like this:
>>>
>>>MAP /cflib = /usr/home/coldfusion/library/peter
>>>
>>>
>>>
>>>
>>>At 06:56 PM 8/14/00 -0400, Jeremy Allen wrote:
>>>>All mappings do is create an alias for a phsyical directory...
>>>>
>>>>like say if you wanted an absolute reference for CFINCLUDE
>>>>
>>>>you could make a mapping named Foo which points to
>/usr/home/cftagman/cftags
>>>>
>>>>And say you had a lot of templates in /usr/home/cftagman/cftags then you
>>>>could use
>>>>
>>>> and Sometemplate.cfm
>>>>would of course be in the D:\CFStuff directory.
>>>>
>>>>Thats all :)
>>>>
>>>>Its purely CF driven and referenced with CF basically its a nice
>>>>way to map out the absolute location for something.  of course
>>>>NT machines start with drive letters ;) 

RE: Help with SQL

[Dan Haley]

#ShowEvents.ThemeName[1]#

Dan

-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 8:59 AM
To: [EMAIL PROTECTED]
Subject: Help with SQL


I have 2 tables with a One (MonthlyTheme) to Many (Events) relationship. I
want to be able to select Programs within a certain range and to also
isolate the ThemeName with one query. The cfoutput below gives multiple
displays of the same ThemeName equal to the number of records. I just want
it to be shown one time. I tried to use DISTINCT but it did not work.

Is this do able with one query or do I have to use 2 queries?

SELECT Events.ProgramName, Events.ProgramDate, MonthlyTheme.ThemeName,
FROM   Events, MonthlyTheme
WHERE  MonthlyTheme.ThemeID = Events.ThemeID
AND Events.ProgramDate BETWEEN #StartMonth# AND #EndMonth#



MonthlyTheme: #ThemeName#


Sebastian


--
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: How can you programmatically keep a web browser from caching a page?

[Dan Haley]

Here is the best answer I've seen to this question on this list - it is
courtesy of Michael Sheldon:

**
A bit hefty, but it's the technically correct method, and one of the few
that AOL's proxies will pay attention to:












***

Dan


-Original Message-
From: Brandon Behrens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 3:08 PM
To: [EMAIL PROTECTED]
Subject: OT: How can you programmatically keep a web browser from
caching a page?


How can you programmatically keep a web browser from caching a page with
HTML?

Thanks in advance,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.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.

RE: IIS

[Dan Haley]

This is totally a shot in the dark, since I deal with code more than
networks, but we've had problems before with access to the web server that
was related to network setup.  I would imagine your machine is using two
NICs, one for inside and one for outside, and if these aren't configured
properly you may be experiencing too much conflict in some way.  Like I said
though, pure speculation!

Dan

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 1:53 PM
To: [EMAIL PROTECTED]
Subject: IIS 


Hello,

This is not CF, but if anyone has any ideas it would be appreciated.

I have IIS 4.0 w/NT 4.0 CF 4.5.1. The problem is my web server hosts an
Internet and Intranet site. The Internet site runs fine, but the Intranet
site takes too long to long from any browser on any machine. It's almost as
if it is not caching the pages anywhere.

I tried all the possible setup/solutions in Management Console properties
for the Intranet site to speed it up, but it still persists.

Any IIS people out there have any suggestions please?

Thanks.

Robert O.
Web Admin
HW Wilson


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

[Dan Haley]

I don't think the same holds true for onrequestend.cfm that does for
application.cfm.  CF will only look for onrequestend.cfm in the directory
that it found application.cfm.

Dan

-Original Message-
From: Ken Goldstraw [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 8:56 AM
To: '[EMAIL PROTECTED]'
Subject: OnRequestEnd.cfm


Hello folks,

Someone once told me that OnRequestEnd.cfm should exist in every directory,
whether you're using it or not.  The reason he gave was that CF would
traverse the directory tree until either an OnRequestEnd.cfm was found, or
the top level was reached.  Is this true?  Does anyone do this?

TIA
-Ken

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

[Dan Haley]

Ahh, but there is a flaw in your explanation, grasshopper.  It will recurse
the directory tree for application.cfm, and use the onrequestend.cfm from
that directory.  So, if you have an onrequestend.cfm in the calling
template's directory, but no application.cfm, it will not use it.

Onrequestend.cfm, if in the same directory as application.cfm, will be used
when that application.cfm is used, otherwise it will be ignored.

Dan

-Original Message-
From: Kevin Queen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 10:11 AM
To: [EMAIL PROTECTED]
Subject: RE: OnRequestEnd.cfm



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

[Dan Haley]

Ummm, yeah, and so?  Grasshopper musta got squished on the road when he was
thinking hard to come up with that answer!  Read the question now . . .
really . . . (couldn't resist).


-Original Message-
From: Ed Toon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 1:04 PM
To: [EMAIL PROTECTED]
Subject: RE: OnRequestEnd.cfm


"Dan Haley, you fail to grasp Ti Kwan Leep. Approach me that you might see."

There's a very simple solution here...

"Observe closely, class. Boot to the Head! (SH-ZOOMP!)"



It's always handy to have an Application.cfm for each directory. ;)

-----Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 11:07 AM
To: '[EMAIL PROTECTED]'
Subject: RE: OnRequestEnd.cfm


Ahh, but there is a flaw in your explanation, grasshopper.  It will recurse
the directory tree for application.cfm, and use the onrequestend.cfm from
that directory.  So, if you have an onrequestend.cfm in the calling
template's directory, but no application.cfm, it will not use it.

Onrequestend.cfm, if in the same directory as application.cfm, will be used
when that application.cfm is used, otherwise it will be ignored.

Dan



--
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: PDFWriter

[Dan Haley]

Ok, this is off-topic, but I AM using a CF front-end for this app, and
maybe, just maybe someone on here knows the answer off the top of their
head.

I have a web based configurator storing a configuration in WDDX in a
database.  On another machine on the network I have a VB program keeping an
eye on the database and when a new configuration is done it kicks off Visio,
creates a drawing for the configuration, and then prints that drawing to PDF
using PDFWriter.  Works great.  Until I lock my workstation . . . then the
registry tweaks I am using in VB to get the PDFWriter to print to the proper
place don't seem to work.  Anyone deal with an issue like this before?

Thanks, and sorry for the OT post . . . just not getting much help on the
Adobe forums, or from Adobe support, or from some of the other sites dealing
with PDFs . . . 

Dan
--
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: Combining Application.cfm with other CFINCLUDE's

[Dan Haley]

For the timeout attributes in , use
sessiontimeout="#createtimespan(52,0,0,0)#".  BTW, this will create a
timeout of 52 days.  The numbers represent days, hours, minutes, seconds.

Dan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 8:21 AM
To: [EMAIL PROTECTED]
Subject: Re: Combining Application.cfm with other CFINCLUDE's


Hi again,

I tried Al Musella's idea of eliminating the extra and  tags.  Since 
three files are involved in the whole process there are three sets ... then
I 
put the Application.cfm back in place & got the same error.

Here is the only tag currently living in my Application.cfm file (I was just

getting started with the daunting task of figuring out how to "turn on," 
assign, and store variables ... yikes!).  But this is as far as I got:



Here is the error I get...

Error Diagnostic Information

 Attribute APPLICATIONTIMEOUT in tag CFAPPLICATION has an invalid value

 Cannot convert (0,0,2,0) to number.

 Please, check the ColdFusion manual for the allowed conversions between
data 
types

 The error occurred while processing an element with a general identifier of

(CFAPPLICATION), occupying document
 position (1:1) to (4:46).

 The specific sequence of files included or processed is:
 E:\InetPub\wwwroot\marksport.com\Application.cfm 

I know there's an invalid character in there, or something missing...

I tried adding # around the sessiontimeout variable but then I get another 
error...

Error Diagnostic Information

 Just in time compilation error

 Invalid parser construct found on line 4 at position 39. ColdFusion was 
looking at the following text:

 ,

 Invalid expression format. The usual cause is an error in the expression 
structure.

 The last successfully parsed CFML construct was a CFAPPLICATION tag 
occupying document position (1:1) to (1:14).

 The specific sequence of files included or processed is:
 E:\InetPub\wwwroot\marksport.com\Application.cfm  

I am s lost...!!

In a message dated 08/23/2000 4:23:21 PM Eastern Daylight Time, 
[EMAIL PROTECTED] writes:

<< I'm thinking it has less to do with what is ed and more to do 
with
 whatever is in your Application.cfm.  Lots of people, myself included,
build
 sites that are nothing but pages included in other pages.
 
 Maybe if you posted the contents of your Application.cfm ... ?
 
 Todd Ashworth >>

--
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: weird problem

[Dan Haley]

You'll need to decide what you want to do with rows in the database that
have a null quantity.  You have two choices . . . assign them a value in the
select statement or ignore rows with quantity = null.

In Oracle option 1 would be:
select nvl(quantity, 0) quantity   <<-- assigns a value of zero if
it is null

and option 2 would be
where state is null and quantity is not null

But, it looks like you aren't using Oracle, so you'll have to determine how
to do this with your database!

HTH,
Dan

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 9:54 AM
To: [EMAIL PROTECTED]
Subject: weird problem


Hi everyone,

I have a simple table with 4 fields (Quantity, ID, State, FirstName) . When 
I run this query:


SELECT Quantity, ID FROM TestTable
WHERE State = NULL


and try to do this array and output:








#ArraySum(QuantityTotal)#


I get a value that looks something like this:

1.48562799385E-306

If I change the query to this:


SELECT Quantity, ID FROM TestTable
WHERE Quantity <> NULL


It works fine. I really need to do a query against 'Blank' 'State' fields. 
What the heck is going on??

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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.

RE: Blank pages

[Dan Haley]

It sounds like this page is the result of submitting a form.  Have you
validated that the action="" is correct in the form tag?  It sounds like an
IE error message for a page that doesn't exist.  Maybe it isn't ever getting
to your server because of the page with the form?

Dan

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 28, 2000 1:31 PM
To: [EMAIL PROTECTED]
Subject: Re: Blank pages


Putting in a blank application.cfm didn't do it :-(

The page processes rather quickly so it's not a timeout.

No cftry/catches

When the page fails I get a blank page and a POPUP dialog that says:

==
"Internet Explorer cannot open the Internet site 

The download of the specified resource has failed.
==

What's weird is that Netscape doesn't fail and my HTTP diagnostic analyzer
program doesn't fail either - only IE.  Also, I'm accessing the web server
from another machine on our LAN.

Another weird thinng is that on the previous page, when I click on the
submit button, sometiemes the browser says "site contacted" in the status
bar and then nothing happens...almost like the button is not clicked all.
If you continue clicking eventually the results page renders.

Thanks for the suggestions.

Regards,

Howie


- Original Message -
From: "Billy Cravens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 28, 2000 3:28 PM
Subject: Re: Blank pages


> Try throwing in a blank application.cfm in the same directory.
>
> Additionally, are there any mega operations that could be getting lost
> in the fray (timing out)?  How are your try/catch blocks setup (if they
> exist.. which they should :)  ?
>
> --
> Billy Cravens
> [EMAIL PROTECTED]
>
>
>
>
>
> Howie Hamlin wrote:
> >
> > We have an application that works 80% of the time (h...not good
enough!)
> >
> > Running on WIN2K with WebSite Pro 2.5.4 and CF 4.5.1 Pro.  Anyway, what
> > happens is that sometimes you get a blank page sent back.  There are no
> > includes or custom tags on the page in question and the site has no
> > application.cfm files.  When viewing the source I can see text that is
not
> > present in any of the templates for this site so I'm thinking that this
may
> > be a CF thing but I'm not sure.  Here is the text of the "blank page":
> >
> > 
> > 
> >  > http-equiv=Content-Type>
> > 
> >
> > Any ideas?
> >
> > TIA,
> >
> > Howie
> >
>
> --

> > 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: (IIS) Customer file uploads - restrictions of file types

[Dan Haley]

I'm sure I'm missing something really easy . . . if I take an uploaded file
from the customer and put it into a directory outside the web server root,
how do I give the customer access to that file in the future?  The idea
behind this app is sharing of files.  Do I  it with the mime type
based on the file extension?  Or, thinking hard now, someone mentioned an
application/unknown mime type?  Would that be my answer?

Hmmm, off to test this.  Better and previously thunk answers accepted
gladly. :)

Dan

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 30, 2000 6:29 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: (IIS) Customer file uploads - restrictions of file types


> We are getting requests from our customers to upload files to 
> a password secured area of our site so they can share them with 
> other users from their company, as well as with our internal 
> people. The intent is for files like Excel, Word, and Powerpoint 
> documents. Some of the restrictions we need to do are pretty 
> straightforward, like who can upload, who can delete, total
> file size, etc., but what pitfalls do I need to watch out for 
> from a server security standpoint? We are on IIS 4.0, Windows NT 
> 4.0 SP5, CF4.5 ENT, with plans to go to Win2000. Is it as simple 
> as restricting certain executable file types?

Rather than focusing on specific file types, which may be a losing battle,
you might simply make the directory itself safe.

1. Put it outside the web server document root. This way, the web server
itself won't be able to execute anything in there.

2. Only allow read and write rights within the directory. Remove execute
rights from ALL users!

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.

RE: Oracle Concatenation???

[Dan Haley]

Use two pipe symbols.

SELECT
image_title,
'http://www.hello.com/empower/global/' || filename AS image_location

Dan

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 10:58 AM
To: CFTalk
Subject: Oracle Concatenation???


Hi All,

The following SQL string concatenation in Oracle is producing an error

SELECT
image_title,
'http://www.hello.com/empower/global/' + filename AS image_location
FROM
images
ORDER BY
image_title


Error Occurred While Processing Request
Error Diagnostic Information
Oracle Error Code = 1722

ORA-01722: invalid number


What is the correct method of concatenating strings in Oracle?

TIA,
Duane Boudreau,
eMPower Project Manager
Director, Web Technologies
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249 x114
Fax: 603-594-0258

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

[Dan Haley]

Set a boolean in your javascript to true when the page is loading.  When
they click on the link your function checks for the value and if it is true
it will process the "click".  While processing the click it will change the
value to false so no more clicks will be processed.


var x = true;

function processClick() {
if (x) {
x = false;
. . . do rest of processing . . .
}
}


Dan

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 11:27 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Javascript Question


Actually what I want is the opposite. I want it to be a link until they
click it so the order is not submitted more than one time. Do you know how
to do this?


Robert Everland III
Web Developer
Dixon Ticonderoga


-Original Message-
From: Jamie Keane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Javascript Question


Here's what I'd do.

Make the image an HREF pointing to "#", and calls a function when clicked.
Like so:

function doMyStuff()
{
document.image.src = "newimage.jpg";
document.form.submit();
}

I think this will work.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Robert Everland <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Thursday, August 31, 2000 11:20 AM
Subject: OT: Javascript Question


> I can't remember where or the name of the javascript forum off of
>cf-talk but I figured I may as well as my question and then have someone
>tell me where to do. I have a form button that is an image. I put some
>javascript in there so that when I click on it, it changes the image. What
I
>want to do now is make it so that image is not clickable that way no one
can
>keep clicking on submit. Anyone know how to do this, it can't be a href tag
>becuase I have to pass form variables.
>
>
>Robert Everland III
>Web Developer
>Dixon Ticonderoga
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=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: Netscape and IE difference

[Dan Haley]

I'm not sure what the stylesheet attributes are, but in the body tag itself
you can use marginheight and marginwidth - works in NN4+.



Dan

** courtesy of www.blooberry.com!

-Original Message-
From: Mike Deane [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 7:10 AM
To: '[EMAIL PROTECTED]'
Subject: Netscape and IE difference






I use the above code to eliminate the default border/margin.  It only
works correctly in IE.  Any suggestions?

Thank you.
/mdeane

--
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: How to display across a row instead of down?

[Dan Haley]

#query.field[((variables.i - 1) * variables.num_cols) +
variables.j]#






Dan

-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 11:12 PM
To: [EMAIL PROTECTED]
Subject: How to display across a row instead of down?



I want to display the results of my query in 3 columns instead of one.  I
know the method is something to do with mod3, but I'm dashed if i can
figure it out.

What I want to get is:

[record1] [record2] [record3]
[record4] [record5] [record6]
etc

Can anyone help me please with how to code it?

Cheers,
Mike Kear
AFP Web Development
Windsor, NSW, Australia



--
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: [RE: How to display across a row instead of down?]

[Dan Haley]

Yes, I'm hoping Mike realized he could ignore my answer . . . instead of
thinking about how simple it was, I just modified my code that outputs a
query in vertical rows.  Go with the simplest solution Mike!


 

   
  
   
 #myquery.myfield#
   
  
   




Dan


-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 9/1/2000 10:29 AM
Subject: Re: [RE: How to display across a row instead of down?]

use MOD 3  in output

Dan Haley <[EMAIL PROTECTED]> wrote:









#query.field[((variables.i - 1) * variables.num_cols) +
variables.j]#






Dan

-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 11:12 PM
To: [EMAIL PROTECTED]
Subject: How to display across a row instead of down?



I want to display the results of my query in 3 columns instead of one.
I
know the method is something to do with mod3, but I'm dashed if i can
figure it out.

What I want to get is:

[record1] [record2] [record3]
[record4] [record5] [record6]
etc

Can anyone help me please with how to code it?

Cheers,
Mike Kear
AFP Web Development
Windsor, NSW, Australia

--
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: next row in

[Dan Haley]

#myquery.myfield[myquery.currentrow + 1]#

And don't forget to check for when you are in the last row. ;)

Dan

-Original Message-
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 11:53 AM
To: [EMAIL PROTECTED]
Subject: next row in 


Hey all,

I am looping through a query and need to get data from the next row.

Make sense?  While my loop in handling row 5, I need to grab some data from 
row 6 and do a TimeFormat.  I just can't seem to get to that next row.

I have tried a number of different ways to do this but have had no luck.  It

seems that this screams for an embedded loop but I just can't seem to get 
what I want.

If this makes any sense I anyone out there, I would be grateful for any 
assistance.

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

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


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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: Question

[Dan Haley]

As long as your IDs are numeric, use 
SELECT *
FROM Homes
WHERE ID in (#list#)

If your IDs contain alpha characters, you will need to play around with
changing the delimiter from "," to "','".  Something similar to
SELECT *
FROM Homes
WHERE ID in ('#listchangedelims(list, "','")#')

I think. ;)  But it's close. :)

Dan

-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 9:42 AM
To: [EMAIL PROTECTED]
Subject:  Question


This is a multi-part message in MIME format.

--=_NextPart_000_0177_01C017F7.6A6D41C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a list that contains the ID of several items in a database.  I =
want to run one query that will select them all from the database. =20

The number of items in the list is dynamic so I never know exactly how =
many I am pulling???



SELECT *=20
FROM Homes
WHERE ID =3D #listitem1# AND #listitem2# ETC.


Any thoughts??

Kevin Schmidt
Internet Services Manager
Peterson, WIlliams & Bizer
Office: 734.995.5000
Mobile: 734.649.4843


--=_NextPart_000_0177_01C017F7.6A6D41C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I have a list that contains the ID of =
several items=20
in a database.  I want to run one query that will select them =
all from=20
the database.  
 
The number of items in the list is =
dynamic so I=20
never know exactly how many I am pulling???
 
 

SELECT * 
FROM Homes
WHERE ID =3D #listitem1# AND =
#listitem2#=20
ETC.

 
Any thoughts??
 
Kevin SchmidtInternet Services=20
ManagerPeterson, WIlliams & BizerOffice: =
734.995.5000Mobile:=20
734.649.4843

--=_NextPart_000_0177_01C017F7.6A6D41C0--


--
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: count() or recordcount

[Dan Haley]

Two totally different beasts.  If you want to pull data back from the
database and then determine how many rows were returned, use
query.recordcount rather than going back to the database for a row count.
If you only want to find out how many rows but don't need the data, then
count() is your best bet rather than pulling the data across the wire and
using CF's recordcount.

SQL vs. CF . . . two separate beasts, or was that two separate mutants?  Or
was that thread on fusebox?  I'm confused now! ;)

Dan

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 9:12 AM
To: [EMAIL PROTECTED]
Subject: count() or recordcount


Which is faster? I'm presuming count() or what else would it be good for?
-- 

Bud Schneehagen - Tropical Web Creations

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=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: count() or recordcount

[Dan Haley]

Even on small tables the difference is pretty big percentage wise . . . a
quick test (10 iterations) on a table with 140 rows shows an average of 50
ms doing select * and recordcount, 11 ms using select count(*).  If you have
a lot of traffic on that page 40 ms could mean a lot.

Dan

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 9:17 AM
To: '[EMAIL PROTECTED]'
Subject: RE: count() or recordcount


If you do a select * and then do a record count you have to perform 2
operations.  Select count(*) is only one so I think you are right - count(*)
will be faster but it'll be negligible unless you have a huge amount of
records

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: 06 September 2000 17:12
To: [EMAIL PROTECTED]
Subject: count() or recordcount


Which is faster? I'm presuming count() or what else would it be good for?
-- 

Bud Schneehagen - Tropical Web Creations

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

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

Oracle connection lock . . .

[Dan Haley]

Intermittently on our development machine we are starting to get the
following error - Oracle error code = 0 - Timeout while obtaining an Oracle
connection lock.  Once these appear we have to stop and start CF.  Right
before these start occurring there is another error - Oracle error code = 0
- Unknown connection error for the data source.  I know this is happening on
other sites because of a thread on the forums (unresolved) and if you put
the phrase "oracle connection lock" into AltaVista or Google it shows up on
error pages the search engines retrieved.

Anyone run into this and successfully solve it?  We are on CF4.5 Ent on NT4
SP4 with Oracle 8.0.5 using a combination of native drivers and ODBC (moving
to the native drivers).

Thanks,
Dan
--
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: Select Form Element in IE vs Netscape?

[Dan Haley]

Your closing  tag is .

Dan

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


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

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


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

  
   
  
   #sexlst.descrip#
  
  #sexlst.descrip#
   


Thank you in advance.

Lisa

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






Select Form Element  in IE vs Netscape?




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


  
   
  
   =
#sexlst.descrip#
  =

  =
#sexlst.descrip#
  =
 



Thank you in advance.


Lisa




--_=_NextPart_001_01C01837.4BC9ACF0--

--
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: SQL ORDER BY Problem


2000-09-05

Thread
Dan Haley


This one, just like James' original won't work because you are mixing CF and
SQL statements.  CF will try to evaluate the '#datediff(date, now())#' one
time when it is preparing the SQL to send to the database.  It will not be
evaluated for each row of the query.  Build your query with CF.  Use SQL
statements and functions for manipulating each row of the query.

Dan

-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 9:45 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL ORDER BY Problem


SELECT Date, #DateDiff(date, now())# AS "DateSpan"
FROM   Dates
ORDER BY DateSpan


chris

--
Original Message
From: "David Shadovitz"<[EMAIL PROTECTED]>
Subject: Re: SQL ORDER BY Problem
Date: Tue, 5 Sep 2000 06:18:33 -0700

>Wouldn't your results be the same if you just ordered by Date?  You're
>merely (trying to) subtract a constant from each Date.
>-David
>
>On Tue, 5 Sep 2000 "James Smith" <[EMAIL PROTECTED]> writes:
>> I have a query that selects dates from a datasource, and I would like 
>> to
>> order by the number of days to the next occurrence, but the 
>> following
>> doesn't work.
>> 
>> SELECT Date
>> FROM   Dates
>> ORDER BY #DateDiff(date, now())#
>
>YOU'RE PAYING TOO MUCH FOR THE INTERNET!
>Juno now offers FREE Internet Access!
>Try it today - there's no risk!  For your FREE software, visit:
>http://dl.www.juno.com/get/tagj.
>---
---
>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.
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.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.






RE: simple date problem major brain fart


2000-09-07

Thread
Dan Haley


Date addition and subtraction is really much easier than this.  CF does a
lot of implicit data type conversion for you.

Instead of 






Try




Accomplishes the same thing unless I got the subtraction reversed . . .
don't use datediff often enough to remember which way it goes.  One caveat,
you may need the datediff if the time component decides to interfere with
what you are doing.

Dan


-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 9:48 AM
To: [EMAIL PROTECTED]
Subject: RE: simple date problem major brain fart


This code should do the job:








Date to Check: #datetocheck#
Current Date: #currentdate#
Last Week's Date: #lastweekdate#

Difference between last week's date and date to check: #difference#


--
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: Art Broussard [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 07, 2000 8:21 AM
> To: [EMAIL PROTECTED]
> Subject: simple date problem major brain fart
> 
> 
> Lets say CurrentDate is 9/7/2000 and you need to do a check to see if 
> DateToCheck is equal to or greater than CurrentDate - 7 days. if you 
> subtract 7 from the days you get 9/0/2000 which is an invalid 
> date. Is there 
> an easy way to do this?
> 
> Please help, my brain is full of gas
> 
> Art
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> Share information about yourself, create your own public profile at 
> http://profiles.msn.com.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.






Regular expressions . . . a good tutorial somewhere?


2000-09-08

Thread
Dan Haley


Anyone have a link to a decent tutorial for regex?  Can I look at Perl
tutorials for this and not be too far off on what to expect from CF?

Thanks,
Dan
--
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: Regular expressions . . . a good tutorial somewhere?


2000-09-08

Thread
Dan Haley


Sheesh, and the first link is to a chapter from a book sitting on my desk .
. . *slaps self upside the head with a big CF book*

Thanks!

Dan

-Original Message-
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 3:58 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Regular expressions . . . a good tutorial somewhere?


Here's some links to regexs in cf and other languages

http://www.ihs.gov/misc/links_gateway/sub_categories.cfm?sub_cat_id=05010203

Orlando Correa
IHS Web Team
Web Applications Developer, DBA
http://my.ihs.gov



-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 4:38 PM
To: '[EMAIL PROTECTED]'
Subject: Regular expressions . . . a good tutorial somewhere?


Anyone have a link to a decent tutorial for regex?  Can I look at Perl
tutorials for this and not be too far off on what to expect from CF?

Thanks,
Dan

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






regex help


2000-09-13

Thread
Dan Haley


My copy of Mastering Regular Expressions is on its way, but for now can
anyone help with the following?

Given a string such as "sometext[othertext[finaltext] - maybemoretext[]]", I
want to return both "sometext", and the contents of the outer "[ ]".

Any suggestions on how to do nested regexes like this?

Thanks,
Dan
--
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: 2 hours from now -


2000-09-13

Thread
Dan Haley




or, if you want the formatting in the variable



Dan

-Original Message-
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 13, 2000 1:50 PM
To: [EMAIL PROTECTED]
Subject: 2 hours from now -


I am trying to create a variable that represents two hours from now.  I have

been playing with CreateTime() and TimeFormat() but can't seem to get what I

want.

If it's 4:00 I was to return 6:00.

Any Suggestions?

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

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


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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: 2 hours from now -


2000-09-13

Thread
Dan Haley


Sorry - timeformat, not dateformat!

-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 13, 2000 1:53 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: 2 hours from now -




or, if you want the formatting in the variable



Dan

-Original Message-
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 13, 2000 1:50 PM
To: [EMAIL PROTECTED]
Subject: 2 hours from now -


I am trying to create a variable that represents two hours from now.  I have

been playing with CreateTime() and TimeFormat() but can't seem to get what I

want.

If it's 4:00 I was to return 6:00.

Any Suggestions?

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

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


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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: oracle trigger to return newid


2000-09-18

Thread
Dan Haley


A stored procedure could return the new id to you but I haven't found them
to be the most efficient means to do simple inserts.  Other than stored
procedures you have a couple of options (or more, I'm sure) - the "old
access method" using  around the insert and subsequent select
max(id), or using a select sequence.nextval from dual.  If you use the
latter there is no reason to use a .

Dan

-Original Message-
From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 1:45 PM
To: [EMAIL PROTECTED]
Subject: oracle trigger to return newid


Hi folks,
I'm sure this has been answered, but I couldn't find it in the archives.

Has someone written a sample piece of code to demonstrate the most effecient
way to return a newly created primary key whilst doing inserts?

In other words, I insert a record in the author table...I need to now insert
that new primary key (being created by a trigger) into another table, but
only some of the time, so I can't incorporate it into the trigger. Is this a
time to use the old access method, or should I be using a stored procedure,
or what.

Suggestions?

-Deanna




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




--
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: [CF-Talk] OT: Oracle 8i & SQl Server 7 - Can they coexist?


2000-09-19

Thread
Dan Haley


Just to make sure you've tried everything . . . have you tried the Access to
Oracle migration tool?  It is available on Oracle's site - who knows where
today - and does things pretty quickly.  Only problem is it creates a new
user and schema for each database migrated, but that is workable.

Dan

-Original Message-
From: Kibbey, Bruce A (Integic) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 19, 2000 11:06 AM
To: '[EMAIL PROTECTED]'
Subject: [CF-Talk] OT: Oracle 8i & SQl Server 7 - Can they coexist?



I support an internal web team for the Navy.  The adopted standard for
corporate databases at this site is Oracle, but we have a bunch of little
access based web apps that we need to upsize rather quickly and upsizing to
Oracle is not an option due to development time.  We have chosen to upsize
to SQL Server.

Now then, we already have Oracle 8i running on a server here.  It only has 2
databases on it and is rather lightly used.  The server is a dual processor
P3 with 1gb of RAM.

My question is... Can we put SQL Server on the same physical machine (with
Oracle 8i) without too much headache?  There would eventually be a few dozen
small, lightly accessed Databases on SQL Server and perhaps another 2 or 3
more on Oracle.

Does anyone have any experience running this way?  Our team operates much
like an ISP, but we are internal to the organization.  Perhaps an ISP out
there has a setup similar to this scenario?


--
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: [CF-Talk] OT: Subject lines


2000-09-20

Thread
Dan Haley


In Outlook the [cf-talk] works well -- if there is the worry about off-topic
messages being filtered, you can include in the rule an "except if sent
directly to me".

Dan

-Original Message-
From: pan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2000 9:38 AM
To: [EMAIL PROTECTED]
Subject: Re: [CF-Talk] OT: Subject lines



From: "Jennifer" <[EMAIL PROTECTED]>



> It's not as easy to filter based on incoming email address. I am doing
that 
> in at least two ways for each houseoffusion list that I'm on (one filter 
> for ct-talk and one for cftalk because that does happen) and I still get 
> messages that are unfiltered. Sometimes its because the person sending the

> message has sent it to several people and put the cf-talk address
somewhere 
> strange or made it undisclosed. Anything standard that can not be gotten 
> around is helpful. I can filter based on subject line contains [CF-TALK] 
> much more accurately than I can filter based on to or cc contains cf-talk 
> or to or cc contains cftalk.
> 

By filtering on subject line you can't distinguish list traffic from
non-list
traffic. By filtering to:/cc:/etc it is trivial to make that distinction
work
properly.

It may not occur often, but the fact that a subject line that comprises 
[cf-talk] will always go to your list folder when, in fact, it may be
communication that belongs (or was intended to be) off-list.

People do send private exchanges in re cf-talk articles without changing
the subject lines - forwarding, you know?

Pan






--
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: Maximum value of column in cfoutput


2002-07-23

Thread
Dan Haley


You can do it in CF after the query is back ...



Dan

-Original Message-
From: William H. Bowen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:59 AM
To: CF-Talk
Subject: Re: Maximum value of column in cfoutput


Unfortunately I don't need the data in that order, I just need the largest
value of lvl so that I can use that as the colspan value at the top row of
my table.

will


William H. Bowen
Webmaster
ALSTOM's T&D Energy Automation & Information Business

"Your friendly neighborhood Webmaster"

[EMAIL PROTECTED]
http://www.esca.com/

425.739.3629 Voice
425.466.7016 Cell
425.739.3690 FAX
- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 11:52 AM
Subject: Re: Maximum value of column in cfoutput


> I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC to
> get the MAX lvl as the first record?
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> t. 250.920.8830
> e. [EMAIL PROTECTED]
>
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> - Original Message -
> From: "William H. Bowen" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 23, 2002 11:29 AM
> Subject: Maximum value of column in cfoutput
>
>
> > Hello all,
> >
> > I have a column [ lvl ] being returned in a query that is a Count [
> > count(child.startbranch) AS lvl ]of another column. I need to be able to
> > find the MAX of the returned column so that I can write colspans into a
> > table I am building.
> >
> > Is there a way to get *essentially* MAX(lvl) in my cfoutput?
> >
> > Desired result:
> >
> > A table that builds itself dynamically so the end result will look like
> this
> >
> > td colspan=*max(lvl)* - lvl (here it'll be 0)> 0 level header /td/tr
> > td> ,/td td colspan=*max(lvl)* - lvl (here it'll be 1)> 1 level
> subhead
> > /td/tr
> >
> > etc.
> >
> > so far the data I need to display is 5 levels deep but that number is
> > variable with new subs.
> >
> > TIA
> > will
> > 
> >
> > William H. Bowen
> > Webmaster
> > ALSTOM's T&D Energy Automation & Information Business
> >
> > "Your friendly neighborhood Webmaster"
> >
> > [EMAIL PROTECTED]
> > http://www.esca.com/
> >
> > 425.739.3629 Voice
> > 425.466.7016 Cell
> > 425.739.3690 FAX
> >
> >
> 

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






RE: OT javascript addition


2002-07-23

Thread
Dan Haley


Try doing eval(document.newBillingInfo.SCEPbilledAmount.value) +
eval(document.newBillIngo.SCEPpenaltyAmount.value), etc.  At least in
ActionScript (Flash) this forces the value to be treated as a number for
addition purposes.  A quick test in IE javascript showed it to work there
also.

Dan

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 11:30 AM
To: CF-Talk
Subject: RE: OT javascript addition


Thanks Stephen.. I tried that earlier but that only concatenates it

-Original Message-
From: Stephen Kellogg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 10:08 AM
To: CF-Talk
Subject: RE: OT javascript addition


Tim,
try adding () around the addition part like so:

if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)


This should force the addition to take place before the comparison.

PS are you checking for numeric input only

This could be done like so:

if ((isNaN(document.newBillingInfo.SCEPbilledAmount.value)) ||
(isNaN(document.newBillingInfo.SCEPpenaltyAmount.value))  ||
(isNaN(document.newBillingInfo.SCEPdelinquentAmount.value))  ||
(isNaN(document.newBillingInfo.SCEPtotalAmount.value))
{
alert("The amounts must be numeric, Please
check the values.")
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}
else
{
if ((document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value) !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert("The total Billing amount does not add up correctly, Please
check the values.")
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}

return true;
}
}


or something like that ;-)

this is untested code but hopefully will give you something to work with.

HTH

Stephen

-Original Message-
From: Tim Do [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:36 PM
To: CF-Talk
Subject: javascript addition


Hello,

Can anybody show me how you would I would validate the sum of several text
boxes?  This is what I'm trying to use but not having luck.. thanks in
advance.

function validate()
{
 if (document.newBillingInfo.SCEPbilledAmount.value +
document.newBillingInfo.SCEPpenaltyAmount.value +
document.newBillingInfo.SCEPdelinquentAmount.value !=
document.newBillingInfo.SCEPtotalAmount.value)
{
alert("The total Billing amount does not add up correctly, Please
check the values.")
document.newBillingInfo.SCEPbilledAmount.focus()
return false;
}

return true;

}



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists






RE: Maximum value of column in cfoutput


2002-07-23

Thread
Dan Haley


We are still on 4.5 ... why won't valuelist work in CF5?

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 12:08 PM
To: CF-Talk
Subject: Re: Maximum value of column in cfoutput


and if you're not using CF 5...



Then do some list manipulation to get the MAX item in the list

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "William H. Bowen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 11:59 AM
Subject: Re: Maximum value of column in cfoutput


> Unfortunately I don't need the data in that order, I just need the largest
> value of lvl so that I can use that as the colspan value at the top row of
> my table.
>
> will
> 
>
> William H. Bowen
> Webmaster
> ALSTOM's T&D Energy Automation & Information Business
>
> "Your friendly neighborhood Webmaster"
>
> [EMAIL PROTECTED]
> http://www.esca.com/
>
> 425.739.3629 Voice
> 425.466.7016 Cell
> 425.739.3690 FAX
> - Original Message -
> From: "Bryan Stevenson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 23, 2002 11:52 AM
> Subject: Re: Maximum value of column in cfoutput
>
>
> > I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC
to
> > get the MAX lvl as the first record?
> >
> > Bryan Stevenson B.Comm.
> > VP & Director of E-Commerce Development
> > Electric Edge Systems Group Inc.
> > t. 250.920.8830
> > e. [EMAIL PROTECTED]
> >
> > -
> > Macromedia Associate Partner
> > www.macromedia.com
> > -
> > Vancouver Island ColdFusion Users Group
> > Founder & Director
> > www.cfug-vancouverisland.com
> > - Original Message -
> > From: "William H. Bowen" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, July 23, 2002 11:29 AM
> > Subject: Maximum value of column in cfoutput
> >
> >
> > > Hello all,
> > >
> > > I have a column [ lvl ] being returned in a query that is a Count [
> > > count(child.startbranch) AS lvl ]of another column. I need to be able
to
> > > find the MAX of the returned column so that I can write colspans into
a
> > > table I am building.
> > >
> > > Is there a way to get *essentially* MAX(lvl) in my cfoutput?
> > >
> > > Desired result:
> > >
> > > A table that builds itself dynamically so the end result will look
like
> > this
> > >
> > > td colspan=*max(lvl)* - lvl (here it'll be 0)> 0 level header /td/tr
> > > td> ,/td td colspan=*max(lvl)* - lvl (here it'll be 1)> 1 level
> > subhead
> > > /td/tr
> > >
> > > etc.
> > >
> > > so far the data I need to display is 5 levels deep but that number is
> > > variable with new subs.
> > >
> > > TIA
> > > will
> > > 
> > >
> > > William H. Bowen
> > > Webmaster
> > > ALSTOM's T&D Energy Automation & Information Business
> > >
> > > "Your friendly neighborhood Webmaster"
> > >
> > > [EMAIL PROTECTED]
> > > http://www.esca.com/
> > >
> > > 425.739.3629 Voice
> > > 425.466.7016 Cell
> > > 425.739.3690 FAX
> > >
> > >
> >
> 

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






RE: Sql Statement


2002-07-24

Thread
Dan Haley


In Oracle it's really easy ...

select  trunc(sysdate + (6 - to_char(sysdate, 'd')))
fromdual

Dan

-Original Message-
From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 5:01 AM
To: CF-Talk
Subject: Sql Statement


Can anyone help me with a quick SQL statement to give me Fridays date of the
current week?
 
 
Thanks,
 
Joshua Tipton


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






clustercats problem?


2002-07-25

Thread
Dan Haley


We're on CF4.5.1 SP2 Enterprise, on two Win2K servers, using ClusterCats for
load balancing.  On one server mostly, and sometimes the other, we are
seeing entries from wsprobe in the Application Event log where it is
restarting IIS.  The intervals between restarts can be pretty random, but
when it does it is often at 4:00AM. It has done it other times during the
day, and if it weren't for the recurring 4:00 AM theme I'd think it was
runaway processes, but looking at the CF and IIS logs, there isn't much load
on the server when it is happening.  There is very little information about
wsprobe available on Macromedia KB or on the web in general.  Anyone have
any ideas?

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






RE: Re: (Admin) Behavior


2002-07-25

Thread
Dan Haley


Come on ... 'one list under god' just might be a problem ...

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 10:52 AM
To: CF-Talk
Subject: OT: Re: (Admin) Behavior


lol that opened a can of  worms :)

Now all the atheists are gonna be pissed cause they dont believe in "lord"
hehe

Bill Wheatley
Senior Database Developer
Macromedia Certified Advanced Coldfusion Developer
EDIETS.COM
954.360.9022 X159
ICQ 417645
- Original Message -
From: "Marlon Moyer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, July 25, 2002 1:49 PM
Subject: Re: (Admin) Behavior


> Allright, everybody look to the person on their left.  Now look to the
> person on your right
>
> and repeat
>
> *Kumbaya* *Kumbaya* my Lord, *kumbaya* *Kumbaya* my Lord, *kumbaya*
> *Kumbaya* my Lord, *kumbaya*
> Oh Lord *kumbaya* Someone's crying my Lord, *kumbaya* Someone's crying
> my Lord
>
> :)
>
> Thane Sherrington wrote:
>
> >At 01:23 PM 7/25/02 -0400, Michael Dinowitz wrote:
> >
> >
> >>If the behavior of flaming simple, common or any other question
continues,
> >>I'm going to be forced to assign homework to the flamer.
> >>"If your so good at this that you can bash someone else for asking the
> >>question, then you have to write up a short FAQ to answer the question".
I
> >>think that if enough of these FAQs are written then maybe it'll cut down
> >>on what some feel are easy or silly
> >>
> >>
> >
> >Excellent idea.  I agree that the same question gets asked over and over,
> >but it isn't the end of the world.  This is one of the two best lists
I've
> >ever been on, largely because I can feel free to ask a question that some
> >people would label stupid.
> >
> >
> >
> >>questions. I can't do this alone until someone decides to pay me for
> >>hosting the lists and community work. I barely have enough time as is.
> >>(Yes, this is a hint to Macromedia)
> >>
> >>
> >
> >I think you should be hired on as a technology evangelist - this list is
> >probably one of the greatest marketing machines MM has access to.
> >
> >T
> >
> >
> 

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






RE: 3 column output


2002-07-25

Thread
Dan Haley


Not sure how well it will work with true-type fonts and the browsers ... but
if you have enough text this might look ok.

** Not tested! **






Dan

-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 25, 2002 12:21 PM
To: CF-Talk
Subject: 3 column output


Ok, here is a good one for ya. I have a database of stories and they want to
display it in the browser as a 3 column, "newspaper style" display. How does
the all mighty group think this could be accomplished. How could one get a
story to wrap from Column 1 to 2 and 3 with HTML Tables? Is this type of
linked tables available in Flash MX? 

Anyone... Anyone

Justin Hansen
--
Uhlig Communications
Systems Engineer
--
[EMAIL PROTECTED]
913-754-4273
--

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






RE: Coldfusion & Hiermenus


2002-07-29

Thread
Dan Haley


We got them to work and they were great on a fast machine, but testing from
an older P150 machine they were incredibly slow to build.  Of course we
wanted to have multiple levels, etc.  We tore them apart and tried removing
as much 'optional' code, still leaving them cross-browser, and we couldn't
get them to be any faster.  Single level menus would have been fine, but
that didn't meet our needs.  Positioning was never a problem ... probably
been two years since we did it, so we didn't have Netscape 6+ to deal with
at the time.

Dan

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 8:10 AM
To: CF-Talk
Subject: Coldfusion & Hiermenus


Hi

Has anybody used or had any experience in working with the hiermenus script
from

http://www.webreference.com/dhtml/hiermenus/

If so as anybosy had any major problems  (with positioning etc) with it
while implementing the script into their websites?


I would be interested to hear if anybody on the list ahs had the same
problems as myself.

Regards

Ian


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






RE: anyone having list troubles ?


2002-07-29

Thread
Dan Haley


I see that same problem sometimes ... the other day I received 100 list
emails at one time, but the threads had continued while I wasn't getting
them, so the list server was working fine ... and of course my admin says
there's no problem here!

Dan

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 8:52 AM
To: CF-Talk
Subject: anyone having list troubles ? 


Sorry for the OT post, but I seem to be receiving this list sporadically.
The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update
a tracker database with an index.html file. content: "Assumptions can make
an ass out of u and me... :)") My ISP insists my mail server is ok.  Before
I hassle them, have there been any posts since then?

TIA

-Craig


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






RE: anyone having list troubles ?


2002-07-29

Thread
Dan Haley


Sorry, didn't answer your question ... yes, there have been quite a few
posts since then ... 

-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 8:52 AM
To: CF-Talk
Subject: anyone having list troubles ? 


Sorry for the OT post, but I seem to be receiving this list sporadically.
The last post I received was from [EMAIL PROTECTED] (suject: Re: Issue: Update
a tracker database with an index.html file. content: "Assumptions can make
an ass out of u and me... :)") My ISP insists my mail server is ok.  Before
I hassle them, have there been any posts since then?

TIA

-Craig


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists






RE: Spaces stripped out of query return values?


2002-07-29

Thread
Dan Haley


Change your query to:

SELECT replace(rpad(username, 20, chr(7))||
   rpad(project_folder, 20, chr(7))||
   rpad(project_file, 20, chr(7))||
   rpad(to_char(blk_h, 'DD-MON-'), 20, chr(7)), chr(7),
' ') listItemDisplay

You'll want to use a non-printable character for the rpad so you don't end
up replacing something in your data.

Dan

-Original Message-
From: Yexley Robert D Contr Det 1 AFRL/WSI
[mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 10:10 AM
To: CF-Talk
Subject: RE: Spaces stripped out of query return values?


DOH!!  I should have known that.  I've been trying since I got your original
response to figure out a way to trick it and to put in   in place of
spaces, but I haven't been able to get it working.  Does anyone happen to
know of a way to get around this?

Bob
<)))><


-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]] 
Sent: Monday, July 29, 2002 12:13 PM
To: CF-Talk
Subject: RE: Spaces stripped out of query return values?


It's an HTML thing, it will reduce many spaces to one, try replacing the
spaces with  

Ade

-Original Message-
From: Yexley Robert D Contr Det 1 AFRL/WSI
[mailto:[EMAIL PROTECTED]]
Sent: 29 July 2002 17:06
To: CF-Talk
Subject: Spaces stripped out of query return values?


I have a form that has a SELECT list in which I'm trying to trick into
displaying multiple columns in the select list.  I'm doing this by how I'm
returning the values from my query.  I'm querying an Oracle database, and my
query is:


SELECT rpad(username, 20, chr(32))||
   rpad(project_folder, 20, chr(32))||
   rpad(project_file, 20, chr(32))||
   rpad(to_char(blk_h, 'DD-MON-'), 20, chr(32)) listItemDisplay
  ,username||'/'||project_folder||'/'||project_file listItemValue
  FROM dids_project_file_info
 WHERE project_submitted = 'SUBMITTED'
ORDER BY username, project_folder, project_file, blk_h 

So I'm basically trying to concatenate four values together, with spaces
concatenated to the end of each value out to 20 characters for each value,
and return it as one value (listItemDisplay).  How when I execute this query
against the database with any standard query tool, it displays the results
correctly like this:

COUTURGDStevens   MMW--HRL
24-JUL-2002
COUTURGDStevens   WaveBand-MMW
18-JUL-2002
OHARAWTBLODGETTacoustic
08-APR-2002

My problem is that when I try to dynamically create the select list with the
following code:



#listItemDisplay#



The displayed values come out with the padded spaces stripped of, and
display like this:

COUTURGD Stevens MMW--HRL 24-JUL-2002
COUTURGD Stevens WaveBand-MMW 18-JUL-2002
OHARAWT BLODGETT acoustic 08-APR-2002

Does anyone have any ideas why these spaces are being stripped, and how I
might be able to keep them so that the values are displayed in the list
correctly (as columns)?  Any ideas would be greatly appreciated.  Thanks in
advance.

::YEX::

/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| <)))><
*/

 <> 




__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists






RE: SQL question


2002-07-29

Thread
Dan Haley


You didn't mention database ...

In Oracle you could use:

decode(instr(part_number, '.'), 0, part_number, substr(part_number, 1,
instr(part_number) - 1)) = other_part_number

You're idea of loading a master part number may yield better results
depending on how big the tables are.

Dan

-Original Message-
From: Phillip B [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 1:06 PM
To: CF-Talk
Subject: OT: SQL question


I need to do this and don't know where to start.

Compare part of a part number in one table to another table. The part
numbers look like this.

12345.123
12345.234
12345.654
02nt911dc.123
02nt911dc.054
02thq5
02thq7

The part before the dot is all I want to use to compare to the other table
which will only contain the first part. It would be something like this.

12345.123 = 12345
12345.234 = 12345
12345.654 = 12345
02nt911dc.123 = 02nt911dc
02nt911dc.054 = 02nt911dc
02thq5 = 02thq5 
02thq7 = 02thq7 

How would I do that using just sql statements? 

Maybe when I have the server import I could have it create an extra column
that can contain a trimmed version of the part number. A master number of
sorts. Just a thought.


Thanks

Phillip Broussard
Tracker Marine Group
417-873-5957



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






RE: Multiple User Authorization


2002-07-29

Thread
Dan Haley


Not NT ... we did something similar to what he's suggesting.  We set up
'roles' in a lookup table in the database, then in our user maintenance
screen we can check which roles a user has.  This comma-delimited string of
numbers goes into their 'state' that we maintain also in the database.  When
a page loads we create a structure called request.security and fill it with
boolean values for all the roles.  Then on any page you can check for
request.security.name_of_some_role and if true, they are a member.

Dan

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 1:32 PM
To: CF-Talk
Subject: Re: Multiple User Authorization


No, these will be individuals and not groups.  Are you talking about
permissions on an NT box?

Paul Giesenhagen
QuillDesign

> would a group style set of permissions be a good idea?  give permissions
to
> the groups, then assign people to them (NT/Win2K ACLs, really).  it'll cut
> down on overhead a bit.
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 29, 2002 4:05 PM
> To: CF-Talk
> Subject: Multiple User Authorization
>
>
> I am looking for suggestions on a user authorization method.
>
> Basically, I have multiple users with various different access levels
> thourghout the application.  Some can get into some places while others
> can't, and even some can get in everywhere.
>
> There are basically 20 different location restrictions.  My question would
> be what would be the best way/practice to tackle this.
>
> Here is what I have come up with (but think it's a bit cumbersome).
>
> Setup table with the 20 different access columns
> (editor,admin,colors,settings,gifts ect...) and give them a 1 or 0
>
> Then when the user logs in build a struct with the access levels and check
> the struct for that access level (1) when entering a page if 0, send them
> away to the beggining.
>
> Seems a bit cumbersome ... so I am looking for alternatives.
>
> Any thoughts?
>
> I appreciate your input
>
> Paul Giesenhagen
> QuillDesign
>
>
>
> 

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






CF and Oracle -- checking for a record lock


2002-07-30

Thread
Dan Haley


Anyone know if you can check for a record lock in Oracle from a CF query?  I
have a problem with a front-end screen updating an Oracle Apps table ... if
someone is editing that record in the applications then my update never
commits.  I am doing a select right after it on that record and the select
sits and spins until the update commits.  Even the CF timeout doesn't affect
this ... set at 180 seconds and it ran for 300 ... until I saved the record
in the apps and then CF came back with a timeout error.

Can require the user to know what they are doing, but that doesn't always
work!

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






RE: Number of times a character is in a string


2002-07-30

Thread
Dan Haley


Only problem is if they are talking about AA or AAA ... multiple delimiters
in a row don't count as additional list items.

Try this - get rid of all the occurrences and see how much the length
changes:




Dan

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 12:50 PM
To: CF-Talk
Subject: RE: Number of times a character is in a string


If it's one character, you should be able to treat it like a list
delimiter. The only issue is if the char comes first. So, simply add a "
" in front (assuming you aren't counting " " characters).


#listlen(" " & x,"a")#

===
Raymond Camden, ColdFusion Jedi Master for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

> -Original Message-
> From: Graham Pearson [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, July 30, 2002 3:44 PM
> To: CF-Talk
> Subject: Number of times a character is in a string
> 
> 
> Anyway to find out the total number of times a character is 
> apart of a 
> specific string. Any direction greatly appreciated.
> 
> 
> 
> --
> -
> Graham Pearson, System Administrator / Certified Webmaster
> Northern Indiana Educational Services Center
> Http://support.niesc.k12.in.us  Email: 
> [EMAIL PROTECTED]
> 
> Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148
> --
> --
> 
> 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists






RE: Number of times a character is in a string


2002-07-30

Thread
Dan Haley


Whoohoo.

Dan Haley
Creator of Readable Code



-Original Message-
From: Chris Lofback [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 1:16 PM
To: CF-Talk
Subject: RE: Number of times a character is in a string


Yes, I threw it together too quickly.  But Dan Haley nailed it.  :)

Chris Lofback
Sr. Web Developer

TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL  33761
www.trxi.com


> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 30, 2002 4:18 PM
> To: CF-Talk
> Subject: RE: Number of times a character is in a string
> 
> 
> Good catch there. Although you get points off for using evaluate - I'd
> use a temp variable just to make it more readable. ;)
> 
> ==
> =
> Raymond Camden, ColdFusion Jedi Master for Macromedia
> 
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> > -Original Message-
> > From: Chris Lofback [mailto:[EMAIL PROTECTED]] 
> > Sent: Tuesday, July 30, 2002 4:05 PM
> > To: CF-Talk
> > Subject: RE: Number of times a character is in a string
> > 
> > 
> > Using ListLen won't work for single characters or for longer 
> > strings that
> > contain only the target character.  Here's one way to do it 
> for single
> > characters, case-sensitive:
> > 
> > 
> > 
> > Character "a" occurs #Evaluate(Len(MyString) -
> > Len(Replace(MyString,"a","","ALL")))# times
> > 
> > 
> > > -Original Message-
> > > From: Shawn Kernes [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, July 30, 2002 3:51 PM
> > > To: CF-Talk
> > > Subject: RE: Number of times a character is in a string
> > > 
> > > 
> > > ListLen(list [, delimiters ]) - 1
> > > 
> > > where the delimiter is the char you are looking for
> > > 
> > > 
> > > 
> > > -Original Message-
> > > From: Graham Pearson [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, July 30, 2002 12:44 PM
> > > To: CF-Talk
> > > Subject: Number of times a character is in a string
> > > 
> > > 
> > > Anyway to find out the total number of times a character is 
> > apart of a
> > > specific string. Any direction greatly appreciated.
> > > 
> > > 
> > > 
> > > --
> > > --
> > > ---
> > > Graham Pearson, System Administrator / Certified Webmaster
> > > Northern Indiana Educational Services Center
> > > Http://support.niesc.k12.in.us  Email: 
> > > [EMAIL PROTECTED]
> > > 
> > > Voice (574) 254-0444 Ext 108 / (800) 326-5642 Fax: (574) 254-0148
> > > --
> > > --
> > > 
> > > 
> > > 
> > > 
> > 
> 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists






RE: SQL Question: Selecting and grouping by date


2002-07-30

Thread
Dan Haley


In Access datevalue(datefield) does what you are trying to do -- truncate
the date.  This will allow you to group by the date field.  I imagine it is
the same in SQL Server.

Dan

-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 4:24 PM
To: CF-Talk
Subject: RE: SQL Question: Selecting and grouping by date


Thanks for the quick help, I tried the datepart function but it doesn't 
look like it can return more the the date, month OR year. I need to get all 
parts or there may be some inconsistencies in the data.

I also tried the Ben's suggestion using Concatenation.

SELECT Month(myDate) + '/' + Day(myDate) + '/' + Year(myDate)

But I get an error : Syntax error converting the varchar value '/' to a 
column of data type int.


At 04:01 PM 30/07/02 -0700, you wrote:
>Have you tried using the DATEPART() Transact-SQL function?
>
>SELECT ID, FirstName, LastName, DateCreated
>FROM Contact
>WHERE DATEPART("m",DateCreated) = 7
>
>The above query will return all Contacts create in the month of July
>(for any year).
>
>Here are the details for the DATEPART() function:
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref
>/ts_da-db_2mic.asp
>
>Hope this helps :)
>
>
>SCOTT VAN VLIET
>BRD.WRKS INTERACTIVE
>T: 714.469.6805
>E: [EMAIL PROTECTED]
>
>
>-Original Message-
>From: Brook Davies [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, July 30, 2002 4:05 PM
>To: CF-Talk
>Subject: SQL Question: Selecting and grouping by date
>
>Is there a way to select the datepart(mydate,"mm/dd/yy") from MSSQL? I
>can
>only seem to return the Day, month or year, but not all three. The field
>
>contains date & time data and I am trying to group on the date part  but
>
>the time is throwing off the results.
>
>Brook
>
>
>
>

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists






RE: SQL Question: Selecting and grouping by date


2002-07-30

Thread
Dan Haley


Wait ... one more, please ... haha

An open item on my to-do list is start learning more about SQL Server, so
this stuff helps.  In Oracle it is sooo easy ... trunc(datefield).

Here is what I found in SQL Server, since 'datevalue()' doesn't exist! ...
don't know if is any better or not ...

select  cast(floor(cast(datefield as float)) as datetime) as mydate,
sum(numberfield) as mysum
fromtable
group bycast(floor(cast(datefield as float)) as datetime)

It converts the date to a number, takes the integer of that (midnight), then
converts it back to a date.

HTH,
Dan

-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 4:52 PM
To: CF-Talk
Subject: RE: SQL Question: Selecting and grouping by date


Thank you all so much for the help! You guys are great. I tried all of the 
examples. I learned a fair bit during the process. I ended up using the 
example below which worked great.

Thanks again, you've all done your good deed for the day ;) Now go home to 
your wives!


At 04:25 PM 30/07/02 -0700, you wrote:
>Argh. I forgot that the GROUP BY clause does not like aliases. :(
>
>SELECT  Year(datetimefield) as YY, Month(datetimefield) as MM,
>Day(datetimefield) as DD,
> Count(1) AS RecordCountForThatDay
>FROMyourtable
>GROUP BYYear(datetimefield), Month(datetimefield),
>Day(datetimefield)
>ORDER BYYY, MM, DD
>
>I tend to stay away from Convert() for this problem, but if you prefer
>the string manipulation route, you should look into:
>
>Select convert(varchar(8), datetimefield, 1) as adatefield
> From yourtable
>Order by adatefield
>
>
>James Ang
>Senior Programmer
>MedSeek, Inc.
>[EMAIL PROTECTED]
>
>
>
>-Original Message-
>From: James Ang
>Sent: Tuesday, July 30, 2002 4:14 PM
>To: CF-Talk
>Subject: RE: SQL Question: Selecting and grouping by date
>
>
>Month(datetimefield) instead of Month()
>
>Buggy example, but you get the idea. ;)
>
>
>James Ang
>Senior Programmer
>MedSeek, Inc.
>[EMAIL PROTECTED]
>
>
>-Original Message-
>From: James Ang
>Sent: Tuesday, July 30, 2002 4:13 PM
>To: '[EMAIL PROTECTED]'
>Subject: RE: SQL Question: Selecting and grouping by date
>
>
>If you don't need to perform aggregation:
>
>SELECT  Year(datetimefield) as YY, Month() as MM, Day(datetimefield)
>as DD, *
>FROMyourtable
>ORDER BYYY, MM, DD
>
>If you need to perform aggregation based on date (and not date AND
>time):
>SELECT  Year(datetimefield) as YY, Month() as MM, Day(datetimefield)
>as DD,
> Count(1) AS RecordCountForThatDay
>FROMyourtable
>GROUP BYYY, MM, DD
>ORDER BYYY, MM, DD
>
>Hope this helps.
>
>
>James Ang
>Senior Programmer
>MedSeek, Inc.
>[EMAIL PROTECTED]
>
>
>
>-Original Message-
>From: Brook Davies [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, July 30, 2002 4:24 PM
>To: CF-Talk
>Subject: RE: SQL Question: Selecting and grouping by date
>
>
>Thanks for the quick help, I tried the datepart function but it doesn't
>look like it can return more the the date, month OR year. I need to get
>all
>parts or there may be some inconsistencies in the data.
>
>I also tried the Ben's suggestion using Concatenation.
>
>SELECT Month(myDate) + '/' + Day(myDate) + '/' + Year(myDate)
>
>But I get an error : Syntax error converting the varchar value '/' to a
>column of data type int.
>
>
>At 04:01 PM 30/07/02 -0700, you wrote:
> >Have you tried using the DATEPART() Transact-SQL function?
> >
> >SELECT ID, FirstName, LastName, DateCreated
> >FROM Contact
> >WHERE DATEPART("m",DateCreated) = 7
> >
> >The above query will return all Contacts create in the month of July
> >(for any year).
> >
> >Here are the details for the DATEPART() function:
> >http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlre
>f
> >/ts_da-db_2mic.asp
> >
> >Hope this helps :)
> >
> >
> >SCOTT VAN VLIET
> >BRD.WRKS INTERACTIVE
> >T: 714.469.6805
> >E: [EMAIL PROTECTED]
> >
> >
> >-Original Message-
> >From: Brook Davies [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, July 30, 2002 4:05 PM
> >To: CF-Talk
> >Subject: SQL Question: Selecting and grouping by date
> >
> >Is there a way to select the datepart(mydate,"mm/dd/yy") from MSSQL? I
> >can
> >only seem to return the Day, month or year, but not all three. The
>field
> >
> >contains date & time data and I am trying to group on the date part
>but
> >
> >the time is throwing off the results.
> >
> >Brook
> >
> >
> >
> >
>
>
>

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






RE: Can anybody see a problem with this?


2002-08-01

Thread
Dan Haley


And in those corporate environments where the system admins wear Microsoft
socks and Bill Gates underwear?  Throwing Apache onto the production web
servers might not get you employee of the year.  ;)

While Apache may be able to do so much more so much easier (for some!),
sometimes you have to figure out a way to work with the tools you have ... 

IIS will allow you to backup and restore your configuration.  Right click on
IIS in MMC and you should have the option to do that.

As for handling the marketing folks' desires, there is a way to handle this
in IIS without relying on the 404 message handler.

1) Create a sub-directory that you will use for all these requests, say
maybe 'people', so the request would look like
http://www.mydomain.com/people/billhenderson.  Or, alternatively set up a
subdomain: people.mydomain.com/billhenderson.

2) In IIS, for that directory or subdomain, go to properties and choose the
directory tab.  Change the 'When connecting to this resource, the content
should come from:' option to 'A redirection to a URL', and enter in the
redirect to box "/people.cfm?person=$0".  (use the help on that tab to see
other options)

3) Now the URL http://www.mydomain.com/people/billhenderson will be
redirected to http://www.mydomain.com/people.cfm?person=/billhenderson.

Same basic effect as Apache, just a little more(?) work to set up and a
little less flexibility.

Dan


-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 10:13 AM
To: CF-Talk
Subject: Re: Can anybody see a problem with this?


On Thursday, August 1, 2002, at 06:05 , Alistair Davidson wrote:
> Off the top of my head I can't think of a reason why that wouldn't work,
> but to my mind, relying on the server's error catching to perform
> designed functionality just "feels" wrong - it feels like bad design,
> and it's shifting some of your logic from the application itself to the
> server software that it's running under.

Well, whichever way you slice this problem, it amounts to much the same 
thing: URL mapping. People who use Apache do this sort of stuff all the 
time via rewrite rules, redirects and proxies. If I was Bill, I'd dumped 
IIS and install Apache and have it rewrite the URLs from ^/[A-Za-z]*/?$ to 
/lookup.cfm?directory=$1 (which would also have to deal with any other 
valid top-level directories that had default index pages). Although with 
Apache, you could make the redirects and rewrites as smart as you wanted.

Generally, people who run Apache feel that customizing Apache to achieve 
the desired result for the web site is perfectly reasonable - the config 
is all in text files that you can keep under version control. I can see 
why people who run IIS wouldn't want to do the same sort of thing...

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood


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






RE: ColdFusion Accessing exhcnage server calendar


2002-08-01

Thread
Dan Haley


How big a group of people?  As a feasability test in prep for a department
app (still not written) we wrote some Outlook VBA code to push calendar
updates to a database.  CF will then just look at the database.  The VBA
code isn't complete but does handle recurring appointments, etc.  It would
have to be loaded onto each client, so it wouldn't work for a large user
base very well.

If you are working with a larger group, but still all internal, then there
is a lot that can be done on the Exchange server itself ... the same idea
could be applied there.

Shoot me an email off-list if you're interested in the Outlook code.

Dan

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 10:55 AM
To: CF-Talk
Subject: ColdFusion Accessing exhcnage server calendar


I've already been to cfcomet, anyone ever accessed a calendar on an
exchnage server on CF?

Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists






RE: Can anybody see a problem with this?


2002-08-01

Thread
Dan Haley


That would mean making the root directory a redirect, which I don't think
you want to do, unless none of your other URLs are at the root.  Sure you
can't convince him to use a subdomain?  bossman.mydomain.com?  Some kind of
ego boost to get him to go for it?

On the mod_rewrite, I'm not following the question.  You want the
/BillHenderson to stay in the address bar?  I tried the very first one that
came up on Dave's Google search and it leaves the original URL in the
address bar.  I'm on IE 6.

Dan

-Original Message-
From: Bill Henderson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 2:53 PM
To: CF-Talk
Subject: RE: Can anybody see a problem with this?


Dan - you wrote:

2) In IIS, for that directory or subdomain, go to properties and choose
the
directory tab.  Change the 'When connecting to this resource, the
content
should come from:' option to 'A redirection to a URL', and enter in the
redirect to box "/people.cfm?person=$0".  (use the help on that tab to
see
other options)


I would love to do this, however, boss wants
http://www.mydomain.com/BillHenderson format only. Is there any way I
can do something close to what you suggested without straying from the
boss man's idea?

And as far as the URL rewrites, I found a IIS mod_rewrite and started
playing around with it, it looks like I can do what I need, but I need
to have that format showing in the browser's address bar. Any
workarounds?

Bill "At least my nit-picky boss is a nice guy" Henderson
[EMAIL PROTECTED]





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






RE: Does Macromedia have some current strong Flash agenda?


2002-08-01

Thread
Dan Haley


Agreed ... I've been working a side project in Flash, and luckily most of my
time is spent in CFStudio writing ActionScript to control objects that
someone else has developed in Flash.  When I have to manipulate things in
Flash I tend to be glad there's a punching bag in the basement!  Some things
just don't make sense!  I think there's great application for Flash on the
client end -- in this case there is no server interaction because it will be
distributed on a CD -- but the everyday CF developer won't be jumping into
Flash to start building their business applications.

Then again maybe it's sour grapes on my part because I'm tired of saying "I
don't do graphics!" :)

Dan

-Original Message-
From: Todd [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 4:36 PM
To: CF-Talk
Subject: RE: Does Macromedia have some current strong Flash agenda?


My only issue with the "Rich Client" thing is... well... there's only one 
branden hall in the world and Mr. Watts, I'm sure you're doing a good job 
keeping him busy.  Seriously, to truly be a good developer into Flash 
Remoting, I think we'd have to have that much knowledge, because as it 
stands... getting Data into Flash is easy, but I have a feeling a lot of CF 
developers (like myself) are going to scratch their heads and go, "Now
what?"

Ideally, this would be great if your business was split equally between CF 
/ Flash MX people and you had a great team of both that could learn from 
each other.  My problem is, that... at the company I work for, only the 
"partners" get to play with Flash and even then, they're hacks and... don't 
even know that Flash MX is out yet (nor the power they can do with it).

Sigh... did I mention I'm looking for a new job? ;)

~Todd

At 07:30 PM 8/1/2002 -0400, you wrote:
> > Is it me, or has anyone else noticed there's a REALLY strong
> > push for Flash lately at all the CFUGs and conferences?? Is
> > there any particular reason for this?
>
>Sure. MM sells CF, MM sells Flash, MM would like more money!
>
>On a more serious note, though, I think that MM's strategy is to push
>developers into what you might call "rich client" applications. There are a
>lot of limitations in what you can do with an HTML GUI. Flash goes far
>beyond those limitations, allowing you to build applications that provide
>significantly more functionality. The reason that web applications are
>popular isn't because of the great HTML interface - it's probably close to
>as bad an interface as possible. So, the logical next step is to provide
>web-based applications with better interfaces. This was the original
promise
>of Java, if you remember back a few years. Flash is a tool which can
fulfill
>that promise.
>
> > I like Flash - don't get me wrong. But I view it as a GUI
> > frill that I doubt I can sell to my clients who want a
> > functional business application. Anyone here can tell me
> > why/how I could sell them Flash which would be over and
> > above CF development?
>
>It's a common programmers' mistake to think about interfaces as a "frill".
>For an end-user, the interface is ALL THERE IS. Good interface design is
>necessary for a good application. HTML interfaces may be passable, but I
>wouldn't consider them "good" - you'd really hate to use every function on
>your computer through such an interface, wouldn't you?
>
>So, to counteract this misunderstanding, you might show functional business
>applications written in Flash to your clients. In such an application,
>you'll see things that would be impractical or impossible in HTML - using
>Flash to add functionality, instead of "skip intro" glitter. These
>applications are out there.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists






RE: Does Macromedia have some current strong Flash agenda?


2002-08-02

Thread
Dan Haley


Improve the editor, please!  And/or add code hinting etc. to CF Studio.
Trying to work in the Flash code editor to do simple debugging is annoying.
I think someone else mentioned the idea that Flash has a graphic designer's
feel to it, and that is the feeling that I get also.  If the editor were a
real editor, and if it had improved abilities to move around in the code --
to find the code that was attached to a button without drilling down through
multiple movies -- then it might start to have a developer's feel to it.
Simple things can make it so much less annoying, like when I Alt-Tab to
another window and then Alt-Tab back to Flash, why isn't the cursor still
flashing right where I left it?

Of course, don't take my rants too seriously ... I'm learning it for one,
maybe two projects for a client, then posting the 'no flash allowed' sign on
the front door.  :)

Dan

-Original Message-
From: Mike Chambers [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 9:24 AM
To: CF-Talk
Subject: RE: Does Macromedia have some current strong Flash agenda?


You can use external editors to edit your actionscript code, and then
include it via the include directive:

#include "mycode.as"

personally, i use EditPlus for most of my ActionScript code development.
It has color coding syntax variable.

I have also been using Dreamweaver MX more and more lately, as it has
color coding, a reference panel, and code hinting built in.

do you have any suggestions for improving the code editing environment
within Flash MX, or would you prefer tighter integration with external
editors?

mike chambers

[EMAIL PROTECTED]

> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, August 01, 2002 7:53 PM

> Unfortunately the Flash UI is absolutely the most horrendous code
> editing environment ever dreamed up. Worse than DW MX even , so I
> can't really give it a fair shake because I hate the environment so
> much. Can someone tell me who's brilliant idea it was to focus the
> drawing area as soon as the application is refocused? Even if the
> cursor is focused on the code editing area in advanced mode alt-tab
> away and back, and you have to use the mouse again. Grr.
> 


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






RE: Does Macromedia have some current strong Flash agenda?


2002-08-02

Thread
Dan Haley


Are you guys beating a dead horse just because Matt was riding it?

If you are developing HTML for an Intranet do you stop and worry about the
10k graphic files and try to get them down to 3k?  If the UI works, it
works.  If you are developing for the web, or have users of your Intranet
coming in over 28.8, then you worry about it.  Flash has to be similar (NOT
a Flash person here).  Matt's point is that a good developer knows when to
worry about the bandwidth and when not to, but above all else is that the
app meet the client's needs ... if speed over a 28.8 is required, then ya
better skinny it down.

Dan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 2:21 PM
To: CF-Talk
Subject: RE: Does Macromedia have some current strong Flash agenda?


> I would think any competent UI person would consider usability an
> inherent business requirement. So obviously, if the UI feels slow or
> klunky to the user than it isn't really usable. However, that doesn't
> mean that performance and bandwidth are a consideration. This thread
> started out comparing the bandwidth utilization of html based web
> applications vs. Flash applications. The statement was that the Flash
> application would use less bandwidth. So, let's assume that two Flash
> applications had a similar UI, but were implemented differently. The
> first UI used considerably less bandwidth than the second, but both used
> less bandwidth than their html equivalents. Additionally, let's assume
> that the first UI used less bandwidth because the Flash developer spent
> time trying to reduce the bandwidth usage.

Matt,
I think I fail to understand your point still.  Can you give a
concrete
example?  So far you've only given generalizations.  Can you elaborate?  For
example, how was the first Flash movie made to use less bandwidth?  When it
comes to Flash, it's difficult to decrease the amount of bandwidth from one
Flash movie to the next simply because it's all basic data.  When you
compare HTML pages, you can take out or optimize graphics.

Also, I don't think I agree with your first statement entirely.  You state
that:

"if the UI feels slow or klunky to the user than it isn't
really usable.  However, that doesn't mean that performance
and bandwidth are a consideration".

While I believe there are many considerations for UI, I don't know how you
could say that performance and bandwidth simply aren't a consideration.
Perhaps they are less significant at times, but rarely are they not a
consideration.




Ben Johnson


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





    
  1   2   3    >  
  
  

    

      
    
    
 1 - 100 of 211 matches
    

    
Advanced search


Search the list




    
    

      

                               Site Navigation
      
      

        
The Mail Archive home
        

          cf-talk - all messages
        

          cf-talk  - about the list
        
Expand
      
    

    

      

  				Mail list logo