Re: List Length

2002-08-28 Thread Sean A Corfield

On Tuesday, August 27, 2002, at 06:12 , Bruce Holm wrote:
 The lists in my application are either ID numbers or usernames.  I don't
 believe there will ever be more than several hundred and never more than
 1200.
 Arrays won't work well because I'm using lists to determine
 duplicates...searching for a duplicate username or ID in the list using
 ListFind().
 Arrays are not great for searching since you have to loop through the 
 entire
 array. But then maybe that's faster?

Arrays are *much* faster in CFMX!! listFind() can be *very* slow. Lists 
are just strings - string manipulation is slow. I'd recommend you used 
arrays instead!

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



Installation of latest MDAC on CF4.5 SP2 - required or not ??

2002-08-28 Thread Vishal Narayan

Recently, my ColdFusion application.log has started showing a few messages 
like this:

Error,TID=1060,08/28/02,09:42:04,CFSCHEDULE,unknown exception 
conditionP PCodeRuntimeContextImp::executeSQLTagCFQuery::endTagpThe 
error occurred while processing an element with a general identifier of 
(CFQUERY), occupying document position (167:4) to (167:79) in the template 
file EYOSCHEDULER.CFM./pPPDate/Time: 08/28/02 05:00:31BRBrowser: 
CFSCHEDULEBRQuery String: RequestTimeout=5000P

Some further analysis shows that at the same time that the error was logged 
in my coldfusion server application.log file, there was also an entry in my 
Win 2K server's event viewer application.log file :

Event Type: Information
Event Source:   DrWatson
Event Category: None
Event ID:   4097
Date:   8/28/2002
Time:   9:42:09 AM
User:   N/A
Description:
The application, , generated an application error The error occurred on 
08/28/2002  09:42:09.323 The exception generated was c005 at address 
 (nosymbols)

I am running CF 4.5.1 SP2 Professional on Win 2K Server, with IIS 5 and SQL 
2000 DB. However, it doesn't have the latest version of MDAC
installed on it. Could that be causing these errors to happen ? Should I 
install the latest MDAC on my production web server ?

A search on the ColdFusion Support Forums also shows me the above pcode 
errors may happen due to not using the cflock tag.

Whenever you access (read or write) Application, Server, or Session 
variables in an application, you should use the CFLOCK tag. CFLOCK provides 
borders around the variable access, which in turn ensures the integrity of 
shared data. Using CFLOCK guarantees that multiple concurrently executing 
requests do not manipulate shared data structures, files, or CFXs in an 
inconsistent manner.

The template in the above case reads a few application variables and 
repeatedly calls a CFX tag (upto 5000 times),  as follows :

cfquery name=generalquery datasource=#dns# username=#ua# 
password=#pwd#
 -- query goes here ---
/cfquery

where #dns#, #ua# and #pwd# are application variables defined in my 
application.cfm file.

cfloop query=generalquery
 --- cfx tag call goes here ---
/cfloop

Should there be a CFLOCK around :
a) the cfquery declaration ?
b) the cfx call ? Note that the same CFX tag is used by other applications 
on my website as well.
c) Each of them ?

Hope someone can help me on this one.

Vishal.

__
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



Outlook

2002-08-28 Thread Shahzad.Butt

Hi
 
I am using CFMail to send email on certain action (when new task is
created). It is for company's intranet and all emails are read using
Microsoft Outlook. I was wondering is there anyway in that email i
mention IF YOU WANT TO OWN TASK CLICK HERE. Now this Click Here should
be a link which opens browser with href to page which deals with Owner
ships of tasks. 
 
Shahzad Butt (Development Engineer)
 
JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604
 
7 Solar Way, Innova Park, Enfield, London, EN3 7XY
 

__
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: web mail

2002-08-28 Thread James Smith

I don't think so, but if you have a copy of CFWACK (as all CF developers
should, thanks Ben ;-) it is in there, on page 591-599 if you have the third
edition for CF4.0.

--
Jay
[EMAIL PROTECTED]

Computer games don't affect kids, I mean if Pac Man affected us as kids,
we'd all be running around in darkened rooms, munching pills and listening
to repetitive music...

- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 7:27 PM
Subject: Re: web mail


 Didn't CF come shipped with an example web mail demo?  I don't honestly
 recall as I didn't really look at it.

 -Novak

 - Original Message -
 From: JLH All Turbo [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, August 27, 2002 8:30 AM
 Subject: web mail


  You guys know of a free or inexpensive, basic (or with a few features)
CF
  web mail package?
 
 
  j
 
 
 
 
 
__
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: Help with CFCONTENT

2002-08-28 Thread Shahzad.Butt

Don't use CFContent and if you want to delete the file use CFFile to
delete. If you use cfcontent type=image you can never display text on
that specific page as it is treated as an image file then. On thing you
can try calling that page with CFContent(say blah.cfm) in another page
using Img src=blah.cfm and display your text there like 

Image1: img src=blah.cfm..

I havent tried this thing but I think it might work. I am using
Coldfusion Custom Tag to do the job. CFX_GetImage CFX_PutImage. It works
perfect.

Shahzad

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]] 
Sent: 28 August 2002 01:15
To: CF-Talk
Subject: Help with CFCONTENT


Hi all,

I was wondering if someone might be able to assist me.  My problem is
that I am trying to display an image that retrieved from a MS SQL Server
database and display it back in a html page.  The image displays
correctly but I do not get any of my HTML appearing.  Below is a sample
of what I am trying to do - it is kind of sloppy (since its late here
and I want to go home).  I am sure that I am doing something stupid with
cfcontent.

Any help would be appreciated.

Thanks

Mario Ciliotta



CODE Sample:

cfheader name=pragma value=no-cache
cfheader name=expires value=-1

!--- This code works correctly - I can save it to a db and retrieve it
and create a file on the server --- cffile action=readbinary
file=g:\inetpub\wwwroot\mario\oldpict.jpg variable=imagebinary

cfquery name=test datasource=db_spri11503
INSERT INTO tbl_myImageTable ( filename, fileblob )
values ( 'old.jpg', '#tobase64(imagebinary)#')
/cfquery 

cfquery name=test2 datasource=db_spri11503
Select * from tbl_myImageTable 
/cfquery 

cfset tobin = tobinary(test2.fileblob)  
cffile action=WRITE file=g:\inetpub\wwwroot\mario\old.jpg
output=#tobin# addnewline=No 

!--- END WORKS Correctly ---

!--- This code does not work correctly.  I only see on my page the
image called old.jpg.  I get no text (Image 1 or image 2) and there is
no new.jpg display.  When I go to view the source - there is no source
---

html
head
titleUntitled/title
/head

body

Image 1:  img src=new.jpgBR

Image 2:   cfcontent type=image/jpeg
file=g:\inetpub\wwwroot\mario\old.jpg deletefile=No 
!--- End Does Not Work ---
/body
/html

This message is for the named person's use only. It may contain
sensitive and private proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you are not the intended recipient, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. CREDIT SUISSE GROUP and each legal entity in the
CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business
units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all
e-mail communications through its networks. Any views expressed in this
message are those of the 
individual sender, except where the message states otherwise and the
sender is authorized to state them to be the views of any such entity.
Unless otherwise stated, any pricing information given in this message
is indicative only, is subject to change and does not constitute an
offer to deal at any price quoted. Any reference to the terms of
executed transactions should be treated as  preliminary only and subject
to our formal written confirmation.



__
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: List Length

2002-08-28 Thread Jochem van Dieten

Bruce Holm wrote:
 The lists in my application are either ID numbers or usernames.  I don't
 believe there will ever be more than several hundred and never more than
 1200.
 Arrays won't work well because I'm using lists to determine
 duplicates...searching for a duplicate username or ID in the list using
 ListFind().
 Arrays are not great for searching since you have to loop through the entire
 array. But then maybe that's faster?

Finding is OK for lists.

What hurts is list manipulation, i.e. every time your list changes. For 
instance, building a list of 1000 itemns using a for loop is easily a 
100 times slower as building a 1000 item array using a for loop. If you 
really need to build out of a loop, the best is to build an array in the 
loop and then convert it to a list using ArrayToList().
You should really look at the bigger picture and not just take into 
account the finding, but count the time for building the list as well.

BTW, I am talking CF MX here. In previous versions the difference was 
much smaller.

Jochem

__
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: [OT] - MXDU.com

2002-08-28 Thread todd

And, the only other 'public' topless event would be Mardi Gras. :)

~Todd

On Wed, 28 Aug 2002, Paris Lundis wrote:

 yeah the US is mega uptight... too uptight...  Heck even a cold Canadian
 providence approved pubic bare chested choice for women recently...
 
 The few sensible jurisdictions are in California and Florida most
 notably But the beaches tend to be private and hidden... Almost on the
 verge being some weird thing...
 
 -paris

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
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: Managing Software Versions

2002-08-28 Thread Zac Spitzer

 If I needed to handle this, I'd do each version as a separate directory -
 i.e. http://mydomain/myapp/ver1/index.cfm and
 http://mydomain/myapp/ver2/index.cfm

you could also put in a application layer, moving your code directly out 
the web path and using sessions to select which code base to use

cfinclude template=/code/#request.session.app_version#/login.cfm

z

__
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: Help with CFCONTENT

2002-08-28 Thread Ciliotta, Mario

Thanks Shahzad,

I'll give it a try.

Mario

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 5:10 AM
To: CF-Talk
Subject: RE: Help with CFCONTENT


Don't use CFContent and if you want to delete the file use CFFile to
delete. If you use cfcontent type=image you can never display text on
that specific page as it is treated as an image file then. On thing you
can try calling that page with CFContent(say blah.cfm) in another page
using Img src=blah.cfm and display your text there like 

Image1: img src=blah.cfm..

I havent tried this thing but I think it might work. I am using
Coldfusion Custom Tag to do the job. CFX_GetImage CFX_PutImage. It works
perfect.

Shahzad

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]] 
Sent: 28 August 2002 01:15
To: CF-Talk
Subject: Help with CFCONTENT


Hi all,

I was wondering if someone might be able to assist me.  My problem is
that I am trying to display an image that retrieved from a MS SQL Server
database and display it back in a html page.  The image displays
correctly but I do not get any of my HTML appearing.  Below is a sample
of what I am trying to do - it is kind of sloppy (since its late here
and I want to go home).  I am sure that I am doing something stupid with
cfcontent.

Any help would be appreciated.

Thanks

Mario Ciliotta



CODE Sample:

cfheader name=pragma value=no-cache
cfheader name=expires value=-1

!--- This code works correctly - I can save it to a db and retrieve it
and create a file on the server --- cffile action=readbinary
file=g:\inetpub\wwwroot\mario\oldpict.jpg variable=imagebinary

cfquery name=test datasource=db_spri11503
INSERT INTO tbl_myImageTable ( filename, fileblob )
values ( 'old.jpg', '#tobase64(imagebinary)#')
/cfquery 

cfquery name=test2 datasource=db_spri11503
Select * from tbl_myImageTable 
/cfquery 

cfset tobin = tobinary(test2.fileblob)  
cffile action=WRITE file=g:\inetpub\wwwroot\mario\old.jpg
output=#tobin# addnewline=No 

!--- END WORKS Correctly ---

!--- This code does not work correctly.  I only see on my page the
image called old.jpg.  I get no text (Image 1 or image 2) and there is
no new.jpg display.  When I go to view the source - there is no source
---

html
head
titleUntitled/title
/head

body

Image 1:  img src=new.jpgBR

Image 2:   cfcontent type=image/jpeg
file=g:\inetpub\wwwroot\mario\old.jpg deletefile=No 
!--- End Does Not Work ---
/body
/html

This message is for the named person's use only. It may contain
sensitive and private proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you are not the intended recipient, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. CREDIT SUISSE GROUP and each legal entity in the
CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business
units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all
e-mail communications through its networks. Any views expressed in this
message are those of the 
individual sender, except where the message states otherwise and the
sender is authorized to state them to be the views of any such entity.
Unless otherwise stated, any pricing information given in this message
is indicative only, is subject to change and does not constitute an
offer to deal at any price quoted. Any reference to the terms of
executed transactions should be treated as  preliminary only and subject
to our formal written confirmation.




__
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



Date matchup help in Access 2000

2002-08-28 Thread Bob Wilson

Hello,

I'm having some trouble getting dates to match up in Access 2000.  This 
date thing is new
to me and I think I'm close, just can't get everything lined up.

I'm trying to pull records when the dates match.

Here's my link, this works fine --

cfoutput query=getDates
a href=articles.cfm?GetDate=#AddDate##DateFormat(AddDate,  DD, 
)#/a
/cfoutput


Here's the query ---

cfquery name=getteam datasource=#application.datasource# dbtype=ODBC
Select AddDate, Title, Team from TBLteam
WHERE
AddDate = GetDate
Order BY Team
/cfquery

This either gives me no records returned, gives me EVERY record in the 
list, or says it
doesn't know what AddDate is as I've tried different configs.

I've tried this with quotes, without quotes, using the DateFormat to try to 
format them
correctly, using both GetDate and URL.GetDate and anything else I can think 
of and
can't quite get it to match up.

The version of CF is 4.5.2 and of course Access 2000.

Please help so I can learn to love dates and not hate them as I do right now.

Thanks,

Bob Wilson


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 5 Installation error. Windows is looking for %1

2002-08-28 Thread Andrew Peterson

Hi, I've tried installing / unstalling / reinstalling CF 5 Enterprise on
a Win2K Pro server running Apache 2.0.40 (and that third party Apache
module for CF 5) to no avail. When I click on Start  Programs 
Macromedia ColdFusion Server 5  ColdFusion Administrator, it gives me
the message:
 
Windows is looking for %1. To locate the file yourself, click browse.
 
Apache runs fine, and CFIDE is installed on Apache's webroot (C:\Program
Files\Apache Group\Apache2\CFIDE\)
 
I had MX installed on the same pc before, but uninstalled it.
 
Any help greatly appreciated! Thanks in advance,
 
Andrew
 

__
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



Trouble with sessions and AOL ??

2002-08-28 Thread Bob Wilson

Hello,

I have a login that tracks users with sessions and some people are having 
trouble
with the login.  ALL are AOL users.

They complete the login screen and are immediately looped back to a blank 
login
screen.  It's working fine for all non-AOL users.


Here is the application.cfm setting --
CFAPPLICATION
NAME=foo
CLIENTMANAGEMENT=YES
SESSIONMANAGEMENT=YES
SESSIONTIMEOUT=#CreateTimespan(0,0,90,0)#


Here is the session checker at the top of the page post-login 
--
CFIF isDefined('Session.Auth') is NOT TRUE
CFLOCATION url=subs_login.cfm
cfelseif Session.Auth is NOT TRUE
CFLOCATION url=subs_login.cfm
CFELSE
show the stuff they want
/cfif


Is there something better than IsDefined('Session.Auth') I can use to test 
to see if
a session is in effect??

Is this what is tripping the AOL software??

Or do I need to remove this form of authentication to deal with AOL?

The CF Server in use here is 4.5.2

Thanks for all your help,

Bob Wilson




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



LDAP CF

2002-08-28 Thread Randell B Adkins

When using CFLDAP to authenicate a login, does anyone know if it is
possible to CLOSE that LDAP session or does it close automatically
after the tag is completed the authenication?

TIA!
__
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



Ccaching resultsets

2002-08-28 Thread Andy Ewings

Can you guys advise as to the best way to cache resultsets that are user
specific.  I have a situ whereby users are performing searches and doing a
next/previous and I don't want to go to the DB everytime to get the results
again but want to look at all of the ways of allowing the resultset to
persist across requests


__
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



New CFMX Certification website - Any legal issues????

2002-08-28 Thread siva girumala

I am in the process of developing a website for CFMX
Certification and going to release the site by the end
of Sept

Any issues to be addressed before releasing the
website? Help!!!

Any input or suggestions is appreciated..

Thank you..

Good Day.

--Siva Girumala

__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.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: CF Regex problem

2002-08-28 Thread Jerry Johnson

Sweet.

Thanks for the new info.

Jerry Johnson

 [EMAIL PROTECTED] 08/27/02 03:54PM 
That's not 100% true. 
1. If the first character of a set is a close bracket and there's no open bracket in 
the set, then it will match:
[]0-9] will match ]0123456789
2. If the open bracket is anywhere in the set without a close bracket, it'll match:
[0-9[] will match [0123456789
[[0-9] will match [0123456789
3. If you set a range in your set that starts with an open bracket and goes until a 
tilde, then it'll match:
[[-^] will match [/]^
4. If you use a grouping with a pipe, you can fake the brackets:
(\[|/]|[0-9]) will match []0123456789
And you can always use the [[:punct:]]. :)


 From the Advanced Cold Fusion 5 Application Development, by Ben Forta, page 230:
 
 [ and ] Brackets delimit a character class and are not allowed within the class 
itself. Cold Fusion RegEx does not allow them as escaped characters.
 
 Of course, the [:punct:] class handles them as well as all the other brackets, so 
you COULD use that.
 
 But I have often replaced them with another (unused) pair of characters to allow 
regex to work.
 
 Jerry Johnson
 
 
  [EMAIL PROTECTED] 08/27/02 02:19PM 
 Hi there,
 I'm having a problem in CF5 - if I try to use a regular expression to match a 
pattern that contains either the [ or ] characters, the find fails. I've already 
tried escaping each and using ascii character codes instead of the actual character, 
but I can't seem to make it work.
 
 If I change the text to use ( and ) or { and } and escape them properly, the regex 
find works as expected.
 
 Is this a known problem? Is there a workaround?
 
 
 Thanks,
 
 Matt
 
 
 

__
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



Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Edwards Robert (air0rae)

I have a query that returns about 5000+ rows of data.  Currently it takes
about 51 seconds to execute (it's a very complex query).  I'm only
displaying 100 records per page using start and end rows in a cfloop.  The
problem is that the query gets executed every time I go to a page and it
take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
to limit the return to 100 rows, but that will only get me the first 100.
Does anyone know how to set it up so I can get the second 100, or third or
fortieth?  I would guess this needs to be done in oracle instead of CF, but
there may be a custom tag I don't know about.  (About the data:  There is no
iterator or counter on the rows so I cannot do a select where rowid between
1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
can be added to or deleted from at any time.  Also, the data needs to be
real-time so caching a query is out of the question as well.)

Any suggestions would be greatly appreciated.  My phone is ringing off the
hook with complaints of the slow response.

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


__
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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Andy Ewings

Rob

I have asked a similar question on this forum - I think the best bet is to
cache the query results and then use the query a query functionality
(assuming you are using CF5 or above).  How best to cache the query will
depend on whether the results are specific to users or not.  If not then you
can cache in the Application scope.  If it is specific to users then I think
you can cache in the session scope although my questio (which I am still
awaiting responses to) asks how best to do this...

Andy

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 14:43
To: CF-Talk
Subject: Slightly OT: CFQuery, Oracle and Limiting rows


I have a query that returns about 5000+ rows of data.  Currently it takes
about 51 seconds to execute (it's a very complex query).  I'm only
displaying 100 records per page using start and end rows in a cfloop.  The
problem is that the query gets executed every time I go to a page and it
take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
to limit the return to 100 rows, but that will only get me the first 100.
Does anyone know how to set it up so I can get the second 100, or third or
fortieth?  I would guess this needs to be done in oracle instead of CF, but
there may be a custom tag I don't know about.  (About the data:  There is no
iterator or counter on the rows so I cannot do a select where rowid between
1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
can be added to or deleted from at any time.  Also, the data needs to be
real-time so caching a query is out of the question as well.)

Any suggestions would be greatly appreciated.  My phone is ringing off the
hook with complaints of the slow response.

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



__
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: Date matchup help in Access 2000

2002-08-28 Thread Valerie L. Criswell

Try this as your query instead

SELECT AddDate, Title, Team
FROM TBLteam
WHERE AddDate = #CreateODBCDate(Url.GetDate)#
ORDER BY Team

~Val

- Original Message -
From: Bob Wilson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 9:24 AM
Subject: Date matchup help in Access 2000


 Hello,

 I'm having some trouble getting dates to match up in Access 2000.  This
 date thing is new
 to me and I think I'm close, just can't get everything lined up.

 I'm trying to pull records when the dates match.

 Here's my link, this works fine --

 cfoutput query=getDates
 a href=articles.cfm?GetDate=#AddDate##DateFormat(AddDate,  DD,
 )#/a
 /cfoutput


 Here's the query ---

 cfquery name=getteam datasource=#application.datasource#
dbtype=ODBC
 Select AddDate, Title, Team from TBLteam
 WHERE
 AddDate = GetDate
 Order BY Team
 /cfquery

 This either gives me no records returned, gives me EVERY record in the
 list, or says it
 doesn't know what AddDate is as I've tried different configs.

 I've tried this with quotes, without quotes, using the DateFormat to try
to
 format them
 correctly, using both GetDate and URL.GetDate and anything else I can
think
 of and
 can't quite get it to match up.

 The version of CF is 4.5.2 and of course Access 2000.

 Please help so I can learn to love dates and not hate them as I do right
now.

 Thanks,

 Bob Wilson


 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




__
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: Coldfusion Hiermenus Newstickers

2002-08-28 Thread Ian Vaughan

Hi

I have a news ticker that sits just below a menu system that uses hiermenus.

When the menus drop down the newsticker overlays the menu, in the same way a
form select box does.

But this only happens in Internet Explorer 5 and below, in Internet Explorer
6 it works fine.  Any ideas on what could cause this strange event?   and
can it be solved, anybody had any experiences with this?


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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Phillip Perry

I had the same problem. I used a next/previous button system that showed 10
records at a time. If this is what you're looking for I'll post the code.

Phil

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:43 AM
To: CF-Talk
Subject: Slightly OT: CFQuery, Oracle and Limiting rows


I have a query that returns about 5000+ rows of data.  Currently it takes
about 51 seconds to execute (it's a very complex query).  I'm only
displaying 100 records per page using start and end rows in a cfloop.  The
problem is that the query gets executed every time I go to a page and it
take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
to limit the return to 100 rows, but that will only get me the first 100.
Does anyone know how to set it up so I can get the second 100, or third or
fortieth?  I would guess this needs to be done in oracle instead of CF, but
there may be a custom tag I don't know about.  (About the data:  There is no
iterator or counter on the rows so I cannot do a select where rowid between
1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
can be added to or deleted from at any time.  Also, the data needs to be
real-time so caching a query is out of the question as well.)

Any suggestions would be greatly appreciated.  My phone is ringing off the
hook with complaints of the slow response.

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



__
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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Edwards Robert (air0rae)

I've got code that does that already.  (thanks for the offer anyway).  my
problem is that when I click the button to go to the next one hundred, the
cfquery still returns 5000+ records but the cfloop goes to start row 101 and
end row 200.

I'm looking at possibilities with oracle's ROWNUM psudofield.

If I figure out anything on my own, I'll post it here.

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



-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:01 AM
To: CF-Talk
Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows


I had the same problem. I used a next/previous button system that showed 10
records at a time. If this is what you're looking for I'll post the code.

Phil

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:43 AM
To: CF-Talk
Subject: Slightly OT: CFQuery, Oracle and Limiting rows


I have a query that returns about 5000+ rows of data.  Currently it takes
about 51 seconds to execute (it's a very complex query).  I'm only
displaying 100 records per page using start and end rows in a cfloop.  The
problem is that the query gets executed every time I go to a page and it
take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
to limit the return to 100 rows, but that will only get me the first 100.
Does anyone know how to set it up so I can get the second 100, or third or
fortieth?  I would guess this needs to be done in oracle instead of CF, but
there may be a custom tag I don't know about.  (About the data:  There is no
iterator or counter on the rows so I cannot do a select where rowid between
1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
can be added to or deleted from at any time.  Also, the data needs to be
real-time so caching a query is out of the question as well.)

Any suggestions would be greatly appreciated.  My phone is ringing off the
hook with complaints of the slow response.

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




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

2002-08-28 Thread Pete Ruckelshaus

I hope this was an attempt at humor.

CVS is a source control system (Concurrent Versioning System) that allows
simultaneous editing of a given file.  On the client side, I strongly
recommend using WinCVS  Tortoise in combination.

http://www.wincvs.org/
http://www.tortoisecvs.org/

CVS support is not integral to CF Studio like MS SourceSafe is.

Pete

- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 5:14 PM
Subject: Re: CVS


 CVS is a drug store. CSV stands for comma-separated values which is a text
file that uses commas (or other characters, most notably tabs) to separate
data values. Usually used as a text dump of data.


  What is a CVS and where can I learn more about it?
 
 
__
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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Phillip Perry

Sorry, just re-read the post. My code relys on ordered number list. Since
your id's are all unique it won't work for you.

good luck

Phil

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:01 AM
To: CF-Talk
Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows


I had the same problem. I used a next/previous button system that showed 10
records at a time. If this is what you're looking for I'll post the code.

Phil

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:43 AM
To: CF-Talk
Subject: Slightly OT: CFQuery, Oracle and Limiting rows


I have a query that returns about 5000+ rows of data.  Currently it takes
about 51 seconds to execute (it's a very complex query).  I'm only
displaying 100 records per page using start and end rows in a cfloop.  The
problem is that the query gets executed every time I go to a page and it
take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
to limit the return to 100 rows, but that will only get me the first 100.
Does anyone know how to set it up so I can get the second 100, or third or
fortieth?  I would guess this needs to be done in oracle instead of CF, but
there may be a custom tag I don't know about.  (About the data:  There is no
iterator or counter on the rows so I cannot do a select where rowid between
1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
can be added to or deleted from at any time.  Also, the data needs to be
real-time so caching a query is out of the question as well.)

Any suggestions would be greatly appreciated.  My phone is ringing off the
hook with complaints of the slow response.

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




__
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



Web Hosting services for ColdFusion

2002-08-28 Thread siva girumala

Hi

I am going to release a website for CFMX certification
in  a shortwhile.

I would like to know about the hosting services for
Coldfusion... Please mention few names either
free/charge basis...

Thank you

--Siva Girumala

__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
__
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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Jochem van Dieten

Edwards Robert (air0rae) wrote:
 I have a query that returns about 5000+ rows of data.  Currently it takes
 about 51 seconds to execute (it's a very complex query). 

That is long. What are you doing, table scan on a million rows? Full 
text searching? Get somebody who knows Oracle to look at the query and 
the database schema.
If ODBC, set a blockfactor of 100, it might save half a second :)


 I'm only
 displaying 100 records per page using start and end rows in a cfloop.  The
 problem is that the query gets executed every time I go to a page and it
 take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
 to limit the return to 100 rows, but that will only get me the first 100.
 Does anyone know how to set it up so I can get the second 100, or third or
 fortieth?  I would guess this needs to be done in oracle instead of CF, but
 there may be a custom tag I don't know about.  (About the data:  There is no
 iterator or counter on the rows so I cannot do a select where rowid between
 1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
 can be added to or deleted from at any time.  Also, the data needs to be
 real-time so caching a query is out of the question as well.)

I think it is unlikely that there is a solution for this in the area of 
getting just a part of the resultset. You could use WHERE rowcount 
BETWEEN 100 AND 200 to get the second batch of 100 records back, but I 
don't think that would matter much for your query execution time (you 
need an ORDER BY with that which in turn means that internally the db 
still has to get all rows).

If you need better performance, look at the database setup, or losen the 
realtime restriction (technically your current setup is not realtime 
anyway because Oracle uses MVCC). Sometimes it might be an option to 
just give the user the first 300 results and ask them to modify their 
query to be more specific (need to see the explain output to see if that 
can be used to reduce runtime).

Jochem

__
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: What does the error mean?

2002-08-28 Thread Michael Wilson

I have gotten this error once while working remotely on a file and then
viewing it in the browser very quickly between changes. I am not
positive about what caused the duplicate class file, but it may have
been that I tried to view the page before it had updated (compiled the
class?)completely on the remote server...

At any rate, I deleted the duplicate class file/s located in
CFusionMX/wwwroot/WEB-INF/cfclasses/ and the error has never reappeared.

Good luck,

Mike

-Original Message-
From: Ali Daniali [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, August 27, 2002 7:36 PM
To: CF-Talk
Subject: What does the error mean?

Error Occurred While Processing Request  
Errors reported by Java compiler: Found 1 semantic error compiling
C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfLogin2ecfm1727608710.java


__
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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Phillip Perry

Actually, upon further review my code doesn't rely on ordered numbers. I'll
post the code anyway, it may benefit someone on the list.

!--- Previous  Next buttons ---

CFSET MaxRows = 10

CFPARAM name=start default=1
CFQUERY datasource=cnyidea name=customers

SELECT CompanyName, CustomerID
FROM Customers
WHERE CategoryID = 1001
ORDER BY CompanyName
/cfquery

CFSET PrevStart = Start - MaxRows
CFSET NextStart = Start + MaxRows
CFSET current = StartCFIF PrevStart GTE 1

CFOUTPUT

FORM action=sometemplate.cfm method=post
INPUT type=hidden name=start value=#PrevStart#
INPUT type=Image(you could also use submit button
src=../images/oldideas2.gif border=0
/form

/cfoutput

/cfif
/td
td valign=bottom

CFIF NextStart LTE customers.RecordCount

CFOUTPUT

FORM action=sometemplate.cfm method=post
INPUT type=hidden name=start value=#NextStart#
INPUT type=Image(you could also use submit button src=yourimagehere
border=0
/form

/cfoutput


/cfif

!--- END Previous  Next buttons ---

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:08 AM
To: CF-Talk
Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows


I've got code that does that already.  (thanks for the offer anyway).  my
problem is that when I click the button to go to the next one hundred, the
cfquery still returns 5000+ records but the cfloop goes to start row 101 and
end row 200.

I'm looking at possibilities with oracle's ROWNUM psudofield.

If I figure out anything on my own, I'll post it here.

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



-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:01 AM
To: CF-Talk
Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows


I had the same problem. I used a next/previous button system that showed 10
records at a time. If this is what you're looking for I'll post the code.

Phil

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:43 AM
To: CF-Talk
Subject: Slightly OT: CFQuery, Oracle and Limiting rows


I have a query that returns about 5000+ rows of data.  Currently it takes
about 51 seconds to execute (it's a very complex query).  I'm only
displaying 100 records per page using start and end rows in a cfloop.  The
problem is that the query gets executed every time I go to a page and it
take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
to limit the return to 100 rows, but that will only get me the first 100.
Does anyone know how to set it up so I can get the second 100, or third or
fortieth?  I would guess this needs to be done in oracle instead of CF, but
there may be a custom tag I don't know about.  (About the data:  There is no
iterator or counter on the rows so I cannot do a select where rowid between
1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
can be added to or deleted from at any time.  Also, the data needs to be
real-time so caching a query is out of the question as well.)

Any suggestions would be greatly appreciated.  My phone is ringing off the
hook with complaints of the slow response.

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





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

2002-08-28 Thread Matt Liotta

CVS stands for Concurrent Versioning System. Information about it can be
found at http://www.cvshome.org/.

Matt Liotta
President  CEO
Montara Software, Inc.
http://www.montarasoftware.com/
V: 415-577-8070
F: 415-341-8906
P: [EMAIL PROTECTED]

 -Original Message-
 From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 27, 2002 2:14 PM
 To: CF-Talk
 Subject: Re: CVS
 
 CVS is a drug store. CSV stands for comma-separated values which is a
text
 file that uses commas (or other characters, most notably tabs) to
separate
 data values. Usually used as a text dump of data.
 
 
  What is a CVS and where can I learn more about it?
 
 
__
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



reading files into an array

2002-08-28 Thread Chris Edwards

How would I read a file into an array, where each array element is a single
line from the file?

I want to take a string, pick a delimiter, and chop up that string via the
delimiter and return an array

Thanks

--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.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: reading files into an array

2002-08-28 Thread Adrian Lynch

Loop through the list(your string with a chosen delimiter) and ArrayAppend
the elements to your Array

Ade

-Original Message-
From: Chris Edwards [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 15:31
To: CF-Talk
Subject: reading files into an array


How would I read a file into an array, where each array element is a single
line from the file?

I want to take a string, pick a delimiter, and chop up that string via the
delimiter and return an array

Thanks

--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Jim Curran

Assuming you can do *TOP* within Oracle (i don't use it, so i don't know)
and there is *any* field you can order by, the following works great for me
(for SQL Server):

select  top X item_ID
fromattorney
where   attorney_ID
in  (
select  top Y attorney_ID
fromattorney
order byattorney_ID DESC
)
order byattorney_ID


where x = total number of rows you want
and y = total_records - start_row

if i have 1000 rows and want records 1 - 10

x = 10
y = 1000 - 1 + 1 = 1000

if i want 401 - 420

x = 20
y = 1000 - 401 + 1 = 600


Hope that helps.

- j

jim curran
technical director
nylon technology
212.691.1134
[EMAIL PROTECTED]

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:43 AM
To: CF-Talk
Subject: Slightly OT: CFQuery, Oracle and Limiting rows


I have a query that returns about 5000+ rows of data.  Currently it takes
about 51 seconds to execute (it's a very complex query).  I'm only
displaying 100 records per page using start and end rows in a cfloop.  The
problem is that the query gets executed every time I go to a page and it
take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
to limit the return to 100 rows, but that will only get me the first 100.
Does anyone know how to set it up so I can get the second 100, or third or
fortieth?  I would guess this needs to be done in oracle instead of CF, but
there may be a custom tag I don't know about.  (About the data:  There is no
iterator or counter on the rows so I cannot do a select where rowid between
1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
can be added to or deleted from at any time.  Also, the data needs to be
real-time so caching a query is out of the question as well.)

Any suggestions would be greatly appreciated.  My phone is ringing off the
hook with complaints of the slow response.

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



__
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: reading files into an array

2002-08-28 Thread Chris Edwards

whats the delimiter for a newline and carriage return? 

-- 
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.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: reading files into an array

2002-08-28 Thread Everett, Al

CHR(13)CHR(10)

 -Original Message-
 From: Chris Edwards [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 28, 2002 10:43 AM
 To: CF-Talk
 Subject: Re: reading files into an array
 
 
 whats the delimiter for a newline and carriage return? 
 
 -- 
 Chris Edwards
 Web Application Developer
 Outer Banks Internet, Inc.
 252-441-6698
 [EMAIL PROTECTED]
 http://www.OuterBanksInternet.com
 
 
 
__
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[2]: reading files into an array

2002-08-28 Thread Critter

oi Adrian!!

why loop.

just to an listToArray(list,CHR(13)CHR(10))


-- 
Critz
 Macromedia Certified Advanced ColdFusion Developer
 CFX_BotMaster Network=Efnet Channel=ColdFusion





Wednesday, August 28, 2002, 10:35:13 AM, you wrote:

AL Loop through the list(your string with a chosen delimiter) and ArrayAppend
AL the elements to your Array

AL Ade

AL -Original Message-
AL From: Chris Edwards [mailto:[EMAIL PROTECTED]]
AL Sent: 28 August 2002 15:31
AL To: CF-Talk
AL Subject: reading files into an array


AL How would I read a file into an array, where each array element is a single
AL line from the file?

AL I want to take a string, pick a delimiter, and chop up that string via the
AL delimiter and return an array

AL Thanks

AL --
AL Chris Edwards
AL Web Application Developer
AL Outer Banks Internet, Inc.
AL 252-441-6698
AL [EMAIL PROTECTED]
AL http://www.OuterBanksInternet.com



AL 
__
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: reading files into an array

2002-08-28 Thread Raymond Camden

Just remember that you can't tell CF to use multiple characters as a
delim. I should say - multiple characters as ONE delim. If you pass AB
as delimiters to a list func, it will teat both A and B as delims, not
the string AB.

===
Raymond Camden, ColdFusion Jedi Master for Hire

Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster

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

 -Original Message-
 From: Everett, Al [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 28, 2002 10:46 AM
 To: CF-Talk
 Subject: RE: reading files into an array
 
 
 CHR(13)CHR(10)
 
  -Original Message-
  From: Chris Edwards [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, August 28, 2002 10:43 AM
  To: CF-Talk
  Subject: Re: reading files into an array
  
  
  whats the delimiter for a newline and carriage return? 
  
  -- 
  Chris Edwards
  Web Application Developer
  Outer Banks Internet, Inc.
  252-441-6698
  [EMAIL PROTECTED]
  http://www.OuterBanksInternet.com
  
  
  
 
__
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: CF 5 Installation error. Windows is looking for %1

2002-08-28 Thread Perez, Jimmy

I'm no expert, but sounds like it is trying to run a batch file with no arguments?

-Original Message-
From: Andrew Peterson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 8:13 AM
To: CF-Talk
Subject: CF 5 Installation error. Windows is looking for %1


Hi, I've tried installing / unstalling / reinstalling CF 5 Enterprise on
a Win2K Pro server running Apache 2.0.40 (and that third party Apache
module for CF 5) to no avail. When I click on Start  Programs 
Macromedia ColdFusion Server 5  ColdFusion Administrator, it gives me
the message:
 
Windows is looking for %1. To locate the file yourself, click browse.
 
Apache runs fine, and CFIDE is installed on Apache's webroot (C:\Program
Files\Apache Group\Apache2\CFIDE\)
 
I had MX installed on the same pc before, but uninstalled it.
 
Any help greatly appreciated! Thanks in advance,
 
Andrew
 


__
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: Re[2]: reading files into an array

2002-08-28 Thread Adrian Lynch

Oi Crits, true :O)

-Original Message-
From: Critter [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 15:38
To: CF-Talk
Subject: Re[2]: reading files into an array


oi Adrian!!

why loop.

just to an listToArray(list,CHR(13)CHR(10))


-- 
Critz
 Macromedia Certified Advanced ColdFusion Developer
 CFX_BotMaster Network=Efnet Channel=ColdFusion





Wednesday, August 28, 2002, 10:35:13 AM, you wrote:

AL Loop through the list(your string with a chosen delimiter) and
ArrayAppend
AL the elements to your Array

AL Ade

AL -Original Message-
AL From: Chris Edwards [mailto:[EMAIL PROTECTED]]
AL Sent: 28 August 2002 15:31
AL To: CF-Talk
AL Subject: reading files into an array


AL How would I read a file into an array, where each array element is a
single
AL line from the file?

AL I want to take a string, pick a delimiter, and chop up that string via
the
AL delimiter and return an array

AL Thanks

AL --
AL Chris Edwards
AL Web Application Developer
AL Outer Banks Internet, Inc.
AL 252-441-6698
AL [EMAIL PROTECTED]
AL http://www.OuterBanksInternet.com



AL 

__
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: Re[2]: reading files into an array

2002-08-28 Thread Raymond Camden

See my earlier post. This code will use two characters as delims, not
the string #chr(13)##chr(10)#. In this case, it probably won't hurt
anything, but I just want to make sure people remember the point.

===
Raymond Camden, ColdFusion Jedi Master for Hire

Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster

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

 -Original Message-
 From: Critter [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 28, 2002 10:38 AM
 To: CF-Talk
 Subject: Re[2]: reading files into an array
 
 
 oi Adrian!!
 
 why loop.
 
 just to an listToArray(list,CHR(13)CHR(10))
 
 
 -- 
 Critz
  Macromedia Certified Advanced ColdFusion Developer
  CFX_BotMaster Network=Efnet Channel=ColdFusion
 
 


__
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: Re[2]: reading files into an array

2002-08-28 Thread Adrian Lynch

I mean untrue :OD

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 15:53
To: CF-Talk
Subject: RE: Re[2]: reading files into an array


Oi Crits, true :O)

-Original Message-
From: Critter [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 15:38
To: CF-Talk
Subject: Re[2]: reading files into an array


oi Adrian!!

why loop.

just to an listToArray(list,CHR(13)CHR(10))


-- 
Critz
 Macromedia Certified Advanced ColdFusion Developer
 CFX_BotMaster Network=Efnet Channel=ColdFusion





Wednesday, August 28, 2002, 10:35:13 AM, you wrote:

AL Loop through the list(your string with a chosen delimiter) and
ArrayAppend
AL the elements to your Array

AL Ade

AL -Original Message-
AL From: Chris Edwards [mailto:[EMAIL PROTECTED]]
AL Sent: 28 August 2002 15:31
AL To: CF-Talk
AL Subject: reading files into an array


AL How would I read a file into an array, where each array element is a
single
AL line from the file?

AL I want to take a string, pick a delimiter, and chop up that string via
the
AL delimiter and return an array

AL Thanks

AL --
AL Chris Edwards
AL Web Application Developer
AL Outer Banks Internet, Inc.
AL 252-441-6698
AL [EMAIL PROTECTED]
AL http://www.OuterBanksInternet.com



AL 


__
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[2]: reading files into an array

2002-08-28 Thread Critter

oi Raymond!!

but you could use #CHR(13)CHR(10#, yeah?


-- 
Critz
 Macromedia Certified Advanced ColdFusion Developer
 CFX_BotMaster Network=Efnet Channel=ColdFusion





Wednesday, August 28, 2002, 10:48:08 AM, you wrote:

RC Just remember that you can't tell CF to use multiple characters as a
RC delim. I should say - multiple characters as ONE delim. If you pass AB
RC as delimiters to a list func, it will teat both A and B as delims, not
RC the string AB.

RC ===
RC Raymond Camden, ColdFusion Jedi Master for Hire

RC Email: [EMAIL PROTECTED]
RC Yahoo IM : cfjedimaster

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

 -Original Message-
 From: Everett, Al [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 28, 2002 10:46 AM
 To: CF-Talk
 Subject: RE: reading files into an array
 
 
 CHR(13)CHR(10)
 
  -Original Message-
  From: Chris Edwards [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, August 28, 2002 10:43 AM
  To: CF-Talk
  Subject: Re: reading files into an array
  
  
  whats the delimiter for a newline and carriage return? 
  
  -- 
  Chris Edwards
  Web Application Developer
  Outer Banks Internet, Inc.
  252-441-6698
  [EMAIL PROTECTED]
  http://www.OuterBanksInternet.com
  
  
  
 
RC 
__
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[3]: reading files into an array

2002-08-28 Thread Critter

oi Critter!!

well


#CHR(13)CHR(10)#

not nuff coffee



-- 
Critz
 Macromedia Certified Advanced ColdFusion Developer
 CFX_BotMaster Network=Efnet Channel=ColdFusion





Wednesday, August 28, 2002, 10:51:50 AM, you wrote:

C oi Raymond!!

C but you could use #CHR(13)CHR(10#, yeah?

__
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



Forcing Output to a Specific Length

2002-08-28 Thread Les Mizzell

I need to have some outputted data forced to have a certain length

For example, take the two following bits of data ( #myStreet# and #myCity#)
on one line:

234 Pine StreetSmallville


Each of these needs to be exactly 35 characters in length. If the data
doesn't fill the entire 35 characters, then it's padded with spaces to make
it 35.  I know how to do this with numbers using NumberFormat, but I've
never had to do it with text before.

This is going into a file that to be imported into a specific processing
application on a mainframe that needs to see it this way...

Somebody please point me in the right direction?

TIA,

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



OT: Learning Tree

2002-08-28 Thread Paul Giesenhagen

Has anyone had any experience with Learning Tree International training group?

Looking for a good training group.

You can reply to [EMAIL PROTECTED] off list if you wish

Thank You
Paul Giesenhagen
QuillDesign


__
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: Re[3]: reading files into an array

2002-08-28 Thread Raymond Camden

No. I mean, yes, you CAN use it - but CF does NOT treat it as one
delimiter. It treats it as two delimiters.

I'm being anal here I guess - I just want to make sure people understand
the difference.

Saying that Chr(13)Chr(10) is a delimiter is different from saying
Chr(13) and Chr(10) are delimiters. 

CF list functions do not support the idea of multi-character delimiters.

===
Raymond Camden, ColdFusion Jedi Master for Hire

Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster

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

 -Original Message-
 From: Critter [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 28, 2002 10:58 AM
 To: CF-Talk
 Subject: Re[3]: reading files into an array
 
 
 oi Critter!!
 
 well
 
 
 #CHR(13)CHR(10)#
 
 not nuff coffee
 
 
 
 -- 
 Critz
  Macromedia Certified Advanced ColdFusion Developer
  CFX_BotMaster Network=Efnet Channel=ColdFusion
 
 
 
 
 
 Wednesday, August 28, 2002, 10:51:50 AM, you wrote:
 
 C oi Raymond!!
 
 C but you could use #CHR(13)CHR(10#, yeah?
 
 
__
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: Forcing Output to a Specific Length

2002-08-28 Thread Adrian Lynch

There might be an easier way, but I can see this getting messy. Count the
number of chars in the string, get the difference if there is one, then loop
over the string wacking in as many $nbsp; as you need.

Ade

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 16:05
To: CF-Talk
Subject: Forcing Output to a Specific Length


I need to have some outputted data forced to have a certain length

For example, take the two following bits of data ( #myStreet# and #myCity#)
on one line:

234 Pine StreetSmallville


Each of these needs to be exactly 35 characters in length. If the data
doesn't fill the entire 35 characters, then it's padded with spaces to make
it 35.  I know how to do this with numbers using NumberFormat, but I've
never had to do it with text before.

This is going into a file that to be imported into a specific processing
application on a mainframe that needs to see it this way...

Somebody please point me in the right direction?

TIA,

Les

__
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: Forcing Output to a Specific Length

2002-08-28 Thread Raymond Camden

PadString
http://www.cflib.org/udf.cfm?ID=152

===
Raymond Camden, ColdFusion Jedi Master for Hire

Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster

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

 -Original Message-
 From: Les Mizzell [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 28, 2002 11:05 AM
 To: CF-Talk
 Subject: Forcing Output to a Specific Length
 
 
 I need to have some outputted data forced to have a certain length
 
 For example, take the two following bits of data ( #myStreet# 
 and #myCity#)
 on one line:
 
 234 Pine StreetSmallville
 
 
 Each of these needs to be exactly 35 characters in length. If the data
 doesn't fill the entire 35 characters, then it's padded with 
 spaces to make
 it 35.  I know how to do this with numbers using 
 NumberFormat, but I've
 never had to do it with text before.
 


__
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: CF 5 Installation error. Windows is looking for %1

2002-08-28 Thread John Beynon

Can you browse to the admin via
http://localhost/cfide/administrator/index.cfm (localhost or whatever IP you
installed it on?) - that's all the shortcut is pointing at...you might just
need to recreate the shortcut pointing at the correct location.

Jb.

-Original Message-
From: Andrew Peterson [mailto:[EMAIL PROTECTED]] 
Sent: 28 August 2002 14:13
To: CF-Talk
Subject: CF 5 Installation error. Windows is looking for %1


Hi, I've tried installing / unstalling / reinstalling CF 5 Enterprise on a
Win2K Pro server running Apache 2.0.40 (and that third party Apache module
for CF 5) to no avail. When I click on Start  Programs  Macromedia
ColdFusion Server 5  ColdFusion Administrator, it gives me the message:
 
Windows is looking for %1. To locate the file yourself, click browse.
 
Apache runs fine, and CFIDE is installed on Apache's webroot (C:\Program
Files\Apache Group\Apache2\CFIDE\)
 
I had MX installed on the same pc before, but uninstalled it.
 
Any help greatly appreciated! Thanks in advance,
 
Andrew
 


__
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: Forcing Output to a Specific Length

2002-08-28 Thread Everett, Al

#LJustify(myStreet,35)##LJustify(myCity,35)#

 -Original Message-
 From: Les Mizzell [mailto:[EMAIL PROTECTED]]
 
 
 I need to have some outputted data forced to have a certain length
 
 For example, take the two following bits of data ( #myStreet# 
 and #myCity#)
 on one line:
 
 234 Pine StreetSmallville
 
 
 Each of these needs to be exactly 35 characters in length. If the data
 doesn't fill the entire 35 characters, then it's padded with 
 spaces to make
 it 35.  I know how to do this with numbers using 
 NumberFormat, but I've
 never had to do it with text before.
 
 This is going into a file that to be imported into a specific 
 processing
 application on a mainframe that needs to see it this way...
 
 Somebody please point me in the right direction?

__
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



unresponsive threads crashing cf

2002-08-28 Thread Smith, Matthew P -CONT(DYN)

I am having a problem with unresponsive threads crashing the server.  It
seems that they are not being released even after they exceed the timeout
specified in cf administrator(90 seconds).

It took over 37 minutes for the same template to generate unresponsive
threads.  Why doesn't CF drop them when they exceed the time limit?

Information,238,08/28/02,05:52:49,,The ColdFusion Application
Server started.
Warning,88,08/28/02,06:53:12,,Template:
D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 101 seconds.
Warning,304,08/28/02,06:53:13,,Template:
D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 102 seconds.
Warning,426,08/28/02,07:06:19,,A request exceeded the timeout. The
unresponsive thread count is up to 1. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,07:06:19,,  !!  CFTrace::logThread(304) has no
entry for thread 304
Warning,426,08/28/02,07:12:19,,A request exceeded the timeout. The
unresponsive thread count is up to 2.
[D:\Inetpub\wwwroot\Cantrac\dverify.cfm]
Error,426,08/28/02,07:12:19,,  !!  CFTrace::logThread(324) has no
entry for thread 324
Warning,426,08/28/02,07:16:49,,A request exceeded the timeout. The
unresponsive thread count is up to 3. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,07:16:49,,  !!  CFTrace::logThread(88) has no
entry for thread 88
Warning,426,08/28/02,07:18:19,,A request exceeded the timeout. The
unresponsive thread count is up to 4. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,07:18:19,,  !!  CFTrace::logThread(464) has no
entry for thread 464
Warning,426,08/28/02,07:21:19,,A request exceeded the timeout. The
unresponsive thread count is up to 5.
[D:\Inetpub\wwwroot\Cantrac\dverify.cfm]
Error,426,08/28/02,07:21:19,,  !!  CFTrace::logThread(327) has no
entry for thread 327
Warning,426,08/28/02,07:43:49,,A request exceeded the timeout. The
unresponsive thread count is up to 6. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,07:43:49,,  !!  CFTrace::logThread(568) has no
entry for thread 568
Warning,426,08/28/02,07:55:49,,A request exceeded the timeout. The
unresponsive thread count is up to 7.
[D:\Inetpub\wwwroot\Cantrac\dverify.cfm]
Error,426,08/28/02,07:55:49,,  !!  CFTrace::logThread(129) has no
entry for thread 129
Warning,554,08/28/02,07:56:44,,Template:
D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 210 seconds.
Information,129,08/28/02,07:56:45,,A long-running request returned.
The unresponsive thread count is down to 6.
[D:\Inetpub\wwwroot\foo\dverify.cfm].
Warning,129,08/28/02,07:56:45,,Template:
D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 211 seconds.
Warning,426,08/28/02,08:00:19,,A request exceeded the timeout. The
unresponsive thread count is up to 7. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,08:00:19,,  !!  CFTrace::logThread(308) has no
entry for thread 308
Warning,426,08/28/02,08:04:49,,A request exceeded the timeout. The
unresponsive thread count is up to 8. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,08:04:49,,  !!  CFTrace::logThread(554) has no
entry for thread 554
Warning,426,08/28/02,08:07:49,,A request exceeded the timeout. The
unresponsive thread count is up to 9. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,08:07:49,,  !!  CFTrace::logThread(129) has no
entry for thread 129
Fatal,426,08/28/02,08:09:19,,Unresponsive thread threshold reached.
Restarting service.
Information,177,08/28/02,08:09:23,,The ColdFusion Application
Server started.
(ETC)



The template uses a custom tag call that does a cfhttp call to another
template on the same server, trying my hand at a pseudo web service.

Basically:
1.  Template calls custom tag for validation.
2.  Custom tag calls (local/same cf server) web service url
3.  Web service url/template checks if local cache(ms sql db) if user
validation expired.  If not expired and validates properly, returns 1.
4.  If expired:
Calls a third party web service, which we validate against.
Validation fails, return 0
Validation succeeds, insert to local db cache, return 1

I hope that makes sense.

Could that cause problems?  I would guess that it would take two threads as
one template calls another...  But that shouldn't be to bad.

We've tried tweaking cf administrator a bit, but we're not really sure which
setting to play with.

Thanks for any help.
__
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[2]: reading files into an array

2002-08-28 Thread S . Isaac Dealey

I remember a while back getting stuck when I was trying to write a search
feature that would use and/or keywords, I kept trying to use  and  and 
or  as list delimiters until I eventually figured out that wouldn't work,
since I was going to wind up with list elements like

baseball = b,seb,ll
meandering = me,,,eri,g
element = eleme,t
crystal = cryst,l
bandaid = bi,

So I ended up replacing  and  and  or  with non-printing characters and
using those as delimiters instead


Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

 See my earlier post. This code will use two characters as delims, not
 the string #chr(13)##chr(10)#. In this case, it probably won't hurt
 anything, but I just want to make sure people remember the point.

 ===
 Raymond Camden, ColdFusion Jedi Master for Hire

 Email: [EMAIL PROTECTED]
 Yahoo IM : cfjedimaster

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

 -Original Message-
 From: Critter [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 28, 2002 10:38 AM
 To: CF-Talk
 Subject: Re[2]: reading files into an array


 oi Adrian!!

 why loop.

 just to an listToArray(list,CHR(13)CHR(10))


 --
 Critz
  Macromedia Certified Advanced ColdFusion Developer
  CFX_BotMaster Network=Efnet Channel=ColdFusion




 
__
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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Edwards Robert (air0rae)

Here's what i came up with (this is oracle 8.i+ specific)

Select * from (
Obscenely long and complex query
RANK() OVER (ORDER BY some_col ASC NULLS LAST) as Row_Rank
) Where Row_Rank between #startrow# and #endrow#

This gives me 100 rows back at a time.  I'm still getting an obscene time in
the query so i'm trying to come up with ways to speed things up a little
more.  One idea is to rank on the primary table first as a subquery and then
do the complex joins using the where in (subquery) clause so i only join on
100 rows at a time instead of 5000+.  Another is to slightly denormalize
(currently i have a complex left between join using ipranges) to speed up
processing.

Some background on this project (what little i am allowed to reveal):  This
is a tool that runs on every machine and checks in with a webserver/database
on a given interval.  The web server sets the interval by returning a time
code.  Lots of data sent in a small package including Mac address and ip
address.  Our IP addresses are broken down by building, so if i want to see
machines in a given building i do something like (Where ipoc1 between ipocb1
and ipoce1 and ipco2 between ipcob2 and ipoce2 and ipoc3 between ipocb3 and
ipoce3 and ipoc4 between ipocb4 and ipcoe4) with left joins done on the
between to get null for any areas not in the iprange (the above code is
basicly finding between each octet in the ip address).
Yes, this does need to be real time so i can see at any given moment what
machines are where and other information.

One possibility is to determine the building when checking in and inserting
the building name or id in the main table so i don't have to do 4 between
joins for every ip address.  Hence, the slight denormalization.  

Thanks for all the help though.  Currently the processing time for all the
rows is about 57000 milliseconds (57 seconds).  If i get it working through
the denormalization i'll post the time improvement here if anyone is
interested.

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



-Original Message-
From: Jim Curran [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:35 AM
To: CF-Talk
Subject: RE: Slightly OT: CFQuery, Oracle and Limiting rows


Assuming you can do *TOP* within Oracle (i don't use it, so i don't know)
and there is *any* field you can order by, the following works great for me
(for SQL Server):

select  top X item_ID
fromattorney
where   attorney_ID
in  (
select  top Y attorney_ID
fromattorney
order byattorney_ID DESC
)
order byattorney_ID


where x = total number of rows you want
and y = total_records - start_row

if i have 1000 rows and want records 1 - 10

x = 10
y = 1000 - 1 + 1 = 1000

if i want 401 - 420

x = 20
y = 1000 - 401 + 1 = 600


Hope that helps.

- j

jim curran
technical director
nylon technology
212.691.1134
[EMAIL PROTECTED]

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:43 AM
To: CF-Talk
Subject: Slightly OT: CFQuery, Oracle and Limiting rows


I have a query that returns about 5000+ rows of data.  Currently it takes
about 51 seconds to execute (it's a very complex query).  I'm only
displaying 100 records per page using start and end rows in a cfloop.  The
problem is that the query gets executed every time I go to a page and it
take 50 seconds or so each time.  I know I can use MAXROWS in my cfquery tag
to limit the return to 100 rows, but that will only get me the first 100.
Does anyone know how to set it up so I can get the second 100, or third or
fortieth?  I would guess this needs to be done in oracle instead of CF, but
there may be a custom tag I don't know about.  (About the data:  There is no
iterator or counter on the rows so I cannot do a select where rowid between
1 and 100 or 101 and 200 and so on.  Each row has a unique value in it, and
can be added to or deleted from at any time.  Also, the data needs to be
real-time so caching a query is out of the question as well.)

Any suggestions would be greatly appreciated.  My phone is ringing off the
hook with complaints of the slow response.

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




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

Re: List Length

2002-08-28 Thread Bruce Holm

I built the list using the ValueList() function of a query column.  Seems to
be fast.
I'm also using CF 5 still.

Thanks all for your help.  I was thinking there was a small upper limit to
list vars, something in the 255 range but that is the limit to using a list
in a query WHERE clause i.e.  WHERE id IN (1,2,3,4,255)
THis is where I believe the 255 limit applies to a list.  I would guess this
is an Oracle Db SQL limitation?

Bruce

- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 3:24 AM
Subject: Re: List Length


 Bruce Holm wrote:
  The lists in my application are either ID numbers or usernames.  I don't
  believe there will ever be more than several hundred and never more than
  1200.
  Arrays won't work well because I'm using lists to determine
  duplicates...searching for a duplicate username or ID in the list using
  ListFind().
  Arrays are not great for searching since you have to loop through the
entire
  array. But then maybe that's faster?

 Finding is OK for lists.

 What hurts is list manipulation, i.e. every time your list changes. For
 instance, building a list of 1000 itemns using a for loop is easily a
 100 times slower as building a 1000 item array using a for loop. If you
 really need to build out of a loop, the best is to build an array in the
 loop and then convert it to a list using ArrayToList().
 You should really look at the bigger picture and not just take into
 account the finding, but count the time for building the list as well.

 BTW, I am talking CF MX here. In previous versions the difference was
 much smaller.

 Jochem

 
__
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: List Length

2002-08-28 Thread Everett, Al

I ran into a problem with a list in a query to an Oracle DB of over 1000
items. We hacked a work-around to break up large lists into several pieces
linked with ORs.

Strangely, sub-queries that returned more than 1000 records posed no problem
whatsoever.

 -Original Message-
 From: Bruce Holm [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 28, 2002 11:35 AM
 To: CF-Talk
 Subject: Re: List Length
 
 
 I built the list using the ValueList() function of a query 
 column.  Seems to
 be fast.
 I'm also using CF 5 still.
 
 Thanks all for your help.  I was thinking there was a small 
 upper limit to
 list vars, something in the 255 range but that is the limit 
 to using a list
 in a query WHERE clause i.e.  WHERE id IN (1,2,3,4,255)
 THis is where I believe the 255 limit applies to a list.  I 
 would guess this
 is an Oracle Db SQL limitation?
 
 Bruce
 
 - Original Message -
 From: Jochem van Dieten [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, August 28, 2002 3:24 AM
 Subject: Re: List Length
 
 
  Bruce Holm wrote:
   The lists in my application are either ID numbers or 
 usernames.  I don't
   believe there will ever be more than several hundred and 
 never more than
   1200.
   Arrays won't work well because I'm using lists to determine
   duplicates...searching for a duplicate username or ID in 
 the list using
   ListFind().
   Arrays are not great for searching since you have to loop 
 through the
 entire
   array. But then maybe that's faster?
 
  Finding is OK for lists.
 
  What hurts is list manipulation, i.e. every time your list 
 changes. For
  instance, building a list of 1000 itemns using a for loop 
 is easily a
  100 times slower as building a 1000 item array using a for 
 loop. If you
  really need to build out of a loop, the best is to build an 
 array in the
  loop and then convert it to a list using ArrayToList().
  You should really look at the bigger picture and not just take into
  account the finding, but count the time for building the 
 list as well.
 
  BTW, I am talking CF MX here. In previous versions the 
 difference was
  much smaller.
 
  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: Solved/CF 5 Installation error. Windows is looking for %1

2002-08-28 Thread Andrew Peterson

 Can you browse to the admin via
 http://localhost/cfide/administrator/index.cfm

No I couldn't, but it was because I placed the CFIDE folder in the wrong
directory (duh). Now I can get into CFIDE just fine, despite the error
in the shortcut which I suspect can be easily recreated.

Thanks for your help!
Andrew



__
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



CFDUMP issue

2002-08-28 Thread todd

Has anyone had an issues with CFdump?  It doesn't happen to me all the 
time, but now and then ... my page just starts throwing itself into a 
recursive loop and ... I swear this code isn't complicated at all.  It 
only happens when debugging is on and I'm trying to cfdump something.

I'm pretty sure I brought this up before, but I don't think I got any 
response.  I thought I'd bring this up again.

Thanks,
~Todd

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
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: Slightly OT: CFQuery, Oracle and Limiting rows

2002-08-28 Thread Jochem van Dieten

Edwards Robert (air0rae) wrote:
 
 One idea is to rank on the primary table first as a subquery and then
 do the complex joins using the where in (subquery) clause so i only join on
 100 rows at a time instead of 5000+.  Another is to slightly denormalize
 (currently i have a complex left between join using ipranges) to speed up
 processing.

That should help.

 Some background on this project (what little i am allowed to reveal):  This
 is a tool that runs on every machine and checks in with a webserver/database
 on a given interval.  The web server sets the interval by returning a time
 code.  Lots of data sent in a small package including Mac address and ip
 address.  Our IP addresses are broken down by building, so if i want to see
 machines in a given building i do something like (Where ipoc1 between ipocb1
 and ipoce1 and ipco2 between ipcob2 and ipoce2 and ipoc3 between ipocb3 and
 ipoce3 and ipoc4 between ipocb4 and ipcoe4) with left joins done on the
 between to get null for any areas not in the iprange (the above code is
 basicly finding between each octet in the ip address).

I thought Oracle had IP and MAC datatypes?

If you just need to see what is where NOW, this screams for a second 
table with just the latest data. Just put a trigger on the table you 
have now and insert whatever is inserted there into a second table. Upon 
insert in that second table, fire a trigger that deletes the old entry 
for that machine. That way you should have a quite small table with just 
the latest data, and use the big table only if you need historic data. 
(You could achieve the same using partial indexes and a boolean, but I 
don't know if Oracle supports partial indexes.)


 Yes, this does need to be real time so i can see at any given moment what
 machines are where and other information.

Well, currently it isn't realtime. You are about 57 seconds behind. And 
if 10 people hit the application at the same time and the available 
resources are distributed equally you are 10 times 57 seconds behind 
(baring caching etc.).


 One possibility is to determine the building when checking in and inserting
 the building name or id in the main table so i don't have to do 4 between
 joins for every ip address.  Hence, the slight denormalization.  

Seeing the query helps. Seeing the explain output helps even more.

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



Big problem- session vars not saved in IE6 on CF5

2002-08-28 Thread Smith, Don , , WHS/PSD

I am having a big problem with an old standard login system.  This is the
most simple login system I know and have used it for years.

It consists of:
Login form page
Login action page
Main page
Session variables tracking who is logged in

The user enters in their login acct, the action page compares it against the
db, then sets some session variables and uses cflocation to forward them to
a new page or back to the login page if they fail.  The application page
checks for the session variable to see if they're logged in and uses
cflocation to send them back to the login page if the var doesn't exist.

Up until August 19 it worked fine on all browsers.  

After then, it works fine on about 75% of the instances of IE6 in our
enterprise.

It fails on about 1 out of 4 IE installations including my own!

What happens is the user logs in, the database accepts the login and uses
cflocation to send them to the main page.  Then Application.cfm checks to
see if they have the correct session variable and uses cflocation to forward
them to the login page.  I can display the session vars at the bottom of the
login action page during testing, but as soon as I turn cflocation back on,
the session variables do not exist on the main page after the action page.
They disappear.  Yes they exist on most instances of IE and they exist in
every single instance of NS that I tested.

I have a working version of IE 6 that can login with no problem- I have
modified my internet options (ESPECIALLY the cookies/privacy options) to
match that machine exactly, but still the problems persist on my machine.

The only thing that I did that could have affected this on August 19 was
that I remember that morning getting a request to log into MS Passport to
access my hotmail account.  Other than that, I changed none of this code.

Since 25% of our users seem to be affected by this problem, it's a big deal
for us.

I have asked EVERYONE about this and no one has seen this one before.  Have
any of you heard about this before or does anyone have any suggestions of
how to go about debugging this?  

Thanks,

Don Smith
__
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: CFDUMP issue

2002-08-28 Thread Adrian Lynch

Show us your code

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 16:58
To: CF-Talk
Subject: CFDUMP issue


Has anyone had an issues with CFdump?  It doesn't happen to me all the 
time, but now and then ... my page just starts throwing itself into a 
recursive loop and ... I swear this code isn't complicated at all.  It 
only happens when debugging is on and I'm trying to cfdump something.

I'm pretty sure I brought this up before, but I don't think I got any 
response.  I thought I'd bring this up again.

Thanks,
~Todd

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |



__
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: Issue with text database on Unix

2002-08-28 Thread Steven Monaghan

Yup.  Still treated is as numeric.  I wound up having to put a dummy row in
the file with text in those columns to force the driver to treat them as
text.

Ugly, but it works.

Steve

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 7:10 PM
To: CF-Talk
Subject: Re: Issue with text database on Unix


have you tried saving the CSV file with double quotes () around the 
text column?

Dick


On Tuesday, August 27, 2002, at 12:55 PM, Steven Monaghan wrote:

 I configured a data source, and can now query any csv file I drop into 
 a
 directory.  The only issue I am having, is that sometimes, a text 
 column
 only has numeric data.  The driver assumes that since the column only
 contains numeric data, that the column is numeric.  So, any reference 
 to
 this column as a string (ie DESCRIPTION NE '') fails on a datatype 
 error.

 Does anyone know how to tell CF/Merant ODBC Text driver that this 
 column is
 a text column?

 TIA,
 Steve Monaghan

 -
 Steven Monaghan
 Oracle DBA / Cold Fusion Developer
 MSC Industrial Direct Co., Inc.
 http://www.mscdirect.com
 -


 This e-mail is intended for the use of the addressee(s) only and may 
 contain
 privileged, confidential, or proprietary information that is exempt 
 from
 disclosure under law.  If you are not the intended recipient, please 
 do not
 read, copy, use or disclose the contents of this communication to 
 others.
 Please notify the sender that you have received this e-mail in error by
 replying to the e-mail.  Please then delete the e-mail and destroy any
 copies of it.  Thank you.
 

__
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: List Length

2002-08-28 Thread Jochem van Dieten

Bruce Holm wrote:
 I built the list using the ValueList() function of a query column.  Seems to
 be fast.

I think it is (it is quite easy to test). But if you use 
ArrayToList(queryname[columnname]) I know for sure :)


 Thanks all for your help.  I was thinking there was a small upper limit to
 list vars, something in the 255 range but that is the limit to using a list
 in a query WHERE clause i.e.  WHERE id IN (1,2,3,4,255)
 THis is where I believe the 255 limit applies to a list.  I would guess this
 is an Oracle Db SQL limitation?

Don't know. Have you tried using cfqueryparam?

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: CFDUMP issue

2002-08-28 Thread Ben Johnson

 Has anyone had an issues with CFdump?

Todd,
I had the same problem before, but it's probably not the same
problem... at least not exactly.  I had a huge tree structure that I was
dumping, but on the root node, there was an array of references to the
different tree nodes.  For example:

- Root Node
   |- Node 1
   |- Node 2
   ||- Sub Node 1
   ||- Sub Node 2
   |
   |- array of Node References
|- [1] : reference to root node
|- [2] : reference to node 1
|- [3] : reference to node 2
|- [4] : reference to sub node 1
|- [5] : reference to sub node 2

The problem with dumping this variable is that it would start dumping
the root node, then the child nodes, then it would hit array and dump
the root node, then the child nodes, then it would hit the array
again... etc.

If your data structure is complex, you might look into that.  Otherwise,
I'm not sure.


Ben Johnson
Information Architect
www.architekture.com
[p] 720.934.2179
 
 

__
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: CFDUMP issue

2002-08-28 Thread todd

Too long and scattered to list.  I read Ben's email and I think that's my 
issue.  I do have a 2D Array, but it's not that complicated.  It's 
flipping out on a 2D array and spinning into a crazy loop.  It's just 
weird.

~Todd


On Wed, 28 Aug 2002, Adrian Lynch wrote:

 Show us your code
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: 28 August 2002 16:58
 To: CF-Talk
 Subject: CFDUMP issue
 
 
 Has anyone had an issues with CFdump?  It doesn't happen to me all the 
 time, but now and then ... my page just starts throwing itself into a 
 recursive loop and ... I swear this code isn't complicated at all.  It 
 only happens when debugging is on and I'm trying to cfdump something.
 
 I'm pretty sure I brought this up before, but I don't think I got any 
 response.  I thought I'd bring this up again.
 
 Thanks,
 ~Todd
 
 

-- 

Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ |
Team Macromedia Volunteer for ColdFusion   |
http://www.macromedia.com/support/forums/team_macromedia/  |
http://www.flashCFM.com/   - webRat (Moderator)|
http://www.ultrashock.com/ - webRat (Back-end Moderator)   |


__
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



Semi OT question: Skills for jobs

2002-08-28 Thread Phoeun Pha

Hey guys and gals and code monkeys, it's come to my attention that Employers
are looking for someone with a wide range of skills

For example, one required that you know C++, Coldfusion, ASP, Dreamweaver,
VBScript, Java, Adobe Photoshop, Macromedia Flash...

Oh, and it would be a PLUS if you know nuclear physics and how to cook
french cuisine.

Jokes aside, is this fair?  I mean I know few people who know all of these
at once.  Few...like 1!!!  Are these employers just dropping skills without
considering their relationship?

And also, there are sites like freelance.com or elance.com that allows
coders to bid on projects, and the $$ offered on these projects are crazy.
FOr example, someone wanted an auction site like ebay.  Max bid allowed was
$200.  I contacted the project poster, and his answer was..well, since
there is so many free code you can get online, I assume the programmer only
has to put them together to make the auction site.  How does this make you
feel?  What is the percieved view on programmers?  Maybe I'm just whining.
Maybe I'm just not over the dot com hey-days when code monkeys were gods
with shorts and sandals at work.

Mr. Forta, and dude from Figleaf, I would really appreciate your take on
this one.

Phoeun
__
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: Big problem- session vars not saved in IE6 on CF5

2002-08-28 Thread Mark W. Breneman

I too have seen this on one of our client's server, that I do not manage.
Where I first found it was a job app that used different includes for
different jobs.  When the data was inserted into the database about 15%-20%
of the records would not have a value from the session. Thus you could not
tell what job they were applying for. I never did track down the exact
problem I fix it by passing the job ID in the url line.

Are cookies  enabled? Check to see if IE is set to default security
settings. Under some of the higher settings cookies are disabled and since
sessions are tracked via the CFID and CFTOKEN cookies session vars will
not work.

You can turn on Debugging Options - Show Variables on the server and check
to see if the CFID and CFTOKEN cookies are being written.  That will show up
in the browser under the CGI Variables: HTTP_COOKIE

If you find the problem please let me know.  So far this has not been a
problem for my servers.

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Smith, Don , , WHS/PSD [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:51 AM
To: CF-Talk
Subject: Big problem- session vars not saved in IE6 on CF5


I am having a big problem with an old standard login system.  This is the
most simple login system I know and have used it for years.

It consists of:
Login form page
Login action page
Main page
Session variables tracking who is logged in

The user enters in their login acct, the action page compares it against the
db, then sets some session variables and uses cflocation to forward them to
a new page or back to the login page if they fail.  The application page
checks for the session variable to see if they're logged in and uses
cflocation to send them back to the login page if the var doesn't exist.

Up until August 19 it worked fine on all browsers.

After then, it works fine on about 75% of the instances of IE6 in our
enterprise.

It fails on about 1 out of 4 IE installations including my own!

What happens is the user logs in, the database accepts the login and uses
cflocation to send them to the main page.  Then Application.cfm checks to
see if they have the correct session variable and uses cflocation to forward
them to the login page.  I can display the session vars at the bottom of the
login action page during testing, but as soon as I turn cflocation back on,
the session variables do not exist on the main page after the action page.
They disappear.  Yes they exist on most instances of IE and they exist in
every single instance of NS that I tested.

I have a working version of IE 6 that can login with no problem- I have
modified my internet options (ESPECIALLY the cookies/privacy options) to
match that machine exactly, but still the problems persist on my machine.

The only thing that I did that could have affected this on August 19 was
that I remember that morning getting a request to log into MS Passport to
access my hotmail account.  Other than that, I changed none of this code.

Since 25% of our users seem to be affected by this problem, it's a big deal
for us.

I have asked EVERYONE about this and no one has seen this one before.  Have
any of you heard about this before or does anyone have any suggestions of
how to go about debugging this?

Thanks,

Don Smith

__
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: Semi OT question: Skills for jobs

2002-08-28 Thread Ben Forta

I agree with you, most wanted ads read like a list of whatever happened
to be on the shelf at the time. Fact of the matter is I'd never hire a
Java developer who claimed to be good at Photoshop - I don't believe
he'd be good at either.

Problem is, companies need 2 or 3 people who can do a dozen things and
know they'll end up needing a mix of skills, but the exact member makeup
can vary. And so they list them all - that makes sense (somewhat). But
then whoever screens the calls and sorts the resumes axes those that
don't list everything flagging them as a lesser match.

Furthermore, the current economy dictates that employers try find one
person who can do the job of three. It won't work, but they'll try.

I think they'll learn the hard way though.

--- Ben




-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 28, 2002 12:15 PM
To: CF-Talk
Subject: Semi OT question: Skills for jobs


Hey guys and gals and code monkeys, it's come to my attention that
Employers are looking for someone with a wide range of skills

For example, one required that you know C++, Coldfusion, ASP,
Dreamweaver, VBScript, Java, Adobe Photoshop, Macromedia Flash...

Oh, and it would be a PLUS if you know nuclear physics and how to cook
french cuisine.

Jokes aside, is this fair?  I mean I know few people who know all of
these at once.  Few...like 1!!!  Are these employers just dropping
skills without considering their relationship?

And also, there are sites like freelance.com or elance.com that allows
coders to bid on projects, and the $$ offered on these projects are
crazy. FOr example, someone wanted an auction site like ebay.  Max bid
allowed was $200.  I contacted the project poster, and his answer
was..well, since there is so many free code you can get online, I
assume the programmer only has to put them together to make the auction
site.  How does this make you feel?  What is the percieved view on
programmers?  Maybe I'm just whining. Maybe I'm just not over the dot
com hey-days when code monkeys were gods with shorts and sandals at
work.

Mr. Forta, and dude from Figleaf, I would really appreciate your take on
this one.

Phoeun

__
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: Semi OT question: Skills for jobs

2002-08-28 Thread Bryan Stevenson

First ofCF-JOBS-TALK for this one ;-)

Secondcheck the archives at
http://www.mail-archive.com/cf-talk@houseoffusion.com/
as these topics have been beaten to a fine paste over the past few weeks
(and every few weeks for eternity I'm sure).

Cheers

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: Phoeun Pha [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 9:14 AM
Subject: Semi OT question: Skills for jobs


 Hey guys and gals and code monkeys, it's come to my attention that
Employers
 are looking for someone with a wide range of skills

 For example, one required that you know C++, Coldfusion, ASP, Dreamweaver,
 VBScript, Java, Adobe Photoshop, Macromedia Flash...

 Oh, and it would be a PLUS if you know nuclear physics and how to cook
 french cuisine.

 Jokes aside, is this fair?  I mean I know few people who know all of
these
 at once.  Few...like 1!!!  Are these employers just dropping skills
without
 considering their relationship?

 And also, there are sites like freelance.com or elance.com that allows
 coders to bid on projects, and the $$ offered on these projects are crazy.
 FOr example, someone wanted an auction site like ebay.  Max bid allowed
was
 $200.  I contacted the project poster, and his answer was..well, since
 there is so many free code you can get online, I assume the programmer
only
 has to put them together to make the auction site.  How does this make
you
 feel?  What is the percieved view on programmers?  Maybe I'm just whining.
 Maybe I'm just not over the dot com hey-days when code monkeys were gods
 with shorts and sandals at work.

 Mr. Forta, and dude from Figleaf, I would really appreciate your take on
 this one.

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



OT: Question about IE6 and FTP

2002-08-28 Thread Kimmett, Michael S

Ok,  this is a bit off topic, but I have been banging my head against the
wall all morning!

I just upgraded my browser to IE6 and I have this website that I am working
on uses a FTP window within a frame to move large amounts of files from the
clients machine to the server. 

The whole FTP worked great until I upgraded my browser from IE 5.5 to IE6.
I wanted to be sure that everything was still going to work with the site.
Now, we I try to get the site to open, I am now getting the The page cannot
be displayed kiss of death.

If I try to type the FTP address into the address bar I get the login popup
screen ( BTW: I am using an anonymous login) and have to press the cancel
button. But, when I press the cancel button I am able to see the directory
on the server.   

If I go to another machine that has IE 5.5 running then the website (with
the framed FTP window) is still there and all is well.

Does anyone have any idea why this is happening and what I need to do to get
things running again?

Thanks in advance.

Michael 


__
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



Function?

2002-08-28 Thread Kris Pilles

I was curious if it is possible for me to write a function that will
onExit from a form field cerify that data against our database?

For examples if I enter in my SSN then onexit the ssn would be passed
back to the server and a query would execute

Either returing the results of my query (firstname, lastname etc...) or
it would send back no then I would display a error message.

Please advise... Seems possible im just not sure how to do
it...exactly...

Thanks for your help 

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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: Function?

2002-08-28 Thread Phoeun Pha

Why not just let it happen when the user clicks a submit button?  Onexit AKA
OnBlur is creepy and confusing.

but it's possible to do it your way.


First write a javascript function to submit the form.  


THen in the form field for the SSN, add in this attribute..

onblur=nameoffunction();


that way, when the user moves out of the field, it calls the javascript,
which submits the form magically.

walla!



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:52 AM
To: CF-Talk
Subject: Function?


I was curious if it is possible for me to write a function that will
onExit from a form field cerify that data against our database?

For examples if I enter in my SSN then onexit the ssn would be passed
back to the server and a query would execute

Either returing the results of my query (firstname, lastname etc...) or
it would send back no then I would display a error message.

Please advise... Seems possible im just not sure how to do
it...exactly...

Thanks for your help 

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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



setting client vars via list

2002-08-28 Thread Brian Thornton

I am trying to loop through a list and tack on a prefix of client. to set client 
variables in that list  variables.thisvar is the index 

cfset clientvars = 
address1,address2,city,country,email,firstname,lastname,phonenumber,phonenumber2,state
cfloop list=#clientvars# index=variables.thisvar
CFSET  evaluate('client.'variables.Thisvar)= ucase(evaluate(variables.thisvar))
/cfloop 

__
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: Function?

2002-08-28 Thread Shawn Grover

You can do this in Javascript and CF...

You would use the onBlur event to call your function.

Your function would likely call a CF page into a IFrame, frame, processing
window, etc. and that page would take whatever action is necessary...

i.e.

function ConfirmSSN(sSSN) {
document.all.WorkFrame.src = confirmSSN.cfm?SSN= + sSSN;
}

 . .

input type=Text . . .  onblur=ConfirmSSN(this.value);

iframe id=WorkFrame name=WorkFrame hieght=0 width=0/iframe


CONFIRMSSN.CFM:
===

cfparam name=URL.SSN default=

..  (other code here to process the SSN) ...

cfif ValidSSN eq No
script language=javascript
alert(Invalid SSN);
window.parent.document.forms[0].SSN.focus();
/script
/cfif


Hope this helps  (well, it's a start at least...)

Shawn Grover

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:52 AM
To: CF-Talk
Subject: Function?


I was curious if it is possible for me to write a function that will
onExit from a form field cerify that data against our database?

For examples if I enter in my SSN then onexit the ssn would be passed
back to the server and a query would execute

Either returing the results of my query (firstname, lastname etc...) or
it would send back no then I would display a error message.

Please advise... Seems possible im just not sure how to do
it...exactly...

Thanks for your help 

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]



__
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: setting client vars via list

2002-08-28 Thread Brian Thornton

I was able to get this to work with 

cfparam name=client.#variables.thisvar# 
default=#ucase(evaluate(variables.thisvar))#
  - Original Message - 
  From: Brian Thornton 
  To: CF-Talk 
  Sent: Wednesday, August 28, 2002 10:07 AM
  Subject: setting client vars via list


  I am trying to loop through a list and tack on a prefix of client. to set client 
variables in that list  variables.thisvar is the index 

  cfset clientvars = 
address1,address2,city,country,email,firstname,lastname,phonenumber,phonenumber2,state
  cfloop list=#clientvars# index=variables.thisvar
  CFSET  evaluate('client.'variables.Thisvar)= ucase(evaluate(variables.thisvar))
  /cfloop 

__
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: Coldfusion Training IN SoCal

2002-08-28 Thread Thanh Nguyen

Doug,

After an hour searching the web, I found one.
here's the link if you 're interested.

http://www.roundpeg.com/home.cfm?main=trainingaction=classinfoclassid=109;
locid=29

Thanh.


-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 12:11 PM
To: CF-Talk
Subject: Re: Coldfusion Training IN SoCal


I have looked also, and do not know of any. There are several that offer the
certs and such, but no luck on the actual training aspect. I live in Orange
and have checked Irvine, Anaheim, Santa Ana and a few other areas.




Douglas Brown
Email: [EMAIL PROTECTED]


- Original Message -
From: Thanh Nguyen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 11:02 AM
Subject: OT: Coldfusion Training IN SoCal


 Are there any ColdFusion training schools in Southern California?

 Thanh

 

__
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: unresponsive threads crashing cf

2002-08-28 Thread Chris Norloff

Search the Macromedia knowledge base, I think there's information there about CF admin 
settings. Also, search on information about how CF handles threads.

You need to find why your .cfm templates are running so slowly - that's what's killing 
you.

It sounds like the restart at X number of unresponsive threads is set too low.  
Generally that should be 80% of the number of threads. The number of threads should be 
about 3 to 5 per processor.  The CFadmin default setting makes the restart number 
greater than the total number of threads, so CF never restarts even if all threads are 
unresponsive.

Chris Norloff


-- Original Message --
from: Smith, Matthew P -CONT(DYN) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 28 Aug 2002 10:30:22 -0500

I am having a problem with unresponsive threads crashing the server.  It
seems that they are not being released even after they exceed the timeout
specified in cf administrator(90 seconds).

It took over 37 minutes for the same template to generate unresponsive
threads.  Why doesn't CF drop them when they exceed the time limit?

Information,238,08/28/02,05:52:49,,The ColdFusion Application
Server started.
Warning,88,08/28/02,06:53:12,,Template:
D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 101 seconds.
Warning,304,08/28/02,06:53:13,,Template:
D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 102 seconds.
Warning,426,08/28/02,07:06:19,,A request exceeded the timeout. The
unresponsive thread count is up to 1. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,07:06:19,, !!  CFTrace::logThread(304) has no
entry for thread 304
Warning,426,08/28/02,07:12:19,,A request exceeded the timeout. The
unresponsive thread count is up to 2.
[D:\Inetpub\wwwroot\Cantrac\dverify.cfm]
Error,426,08/28/02,07:12:19,, !!  CFTrace::logThread(324) has no
entry for thread 324
Warning,426,08/28/02,07:16:49,,A request exceeded the timeout. The
unresponsive thread count is up to 3. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,07:16:49,, !!  CFTrace::logThread(88) has no
entry for thread 88
Warning,426,08/28/02,07:18:19,,A request exceeded the timeout. The
unresponsive thread count is up to 4. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,07:18:19,, !!  CFTrace::logThread(464) has no
entry for thread 464
Warning,426,08/28/02,07:21:19,,A request exceeded the timeout. The
unresponsive thread count is up to 5.
[D:\Inetpub\wwwroot\Cantrac\dverify.cfm]
Error,426,08/28/02,07:21:19,, !!  CFTrace::logThread(327) has no
entry for thread 327
Warning,426,08/28/02,07:43:49,,A request exceeded the timeout. The
unresponsive thread count is up to 6. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,07:43:49,, !!  CFTrace::logThread(568) has no
entry for thread 568
Warning,426,08/28/02,07:55:49,,A request exceeded the timeout. The
unresponsive thread count is up to 7.
[D:\Inetpub\wwwroot\Cantrac\dverify.cfm]
Error,426,08/28/02,07:55:49,, !!  CFTrace::logThread(129) has no
entry for thread 129
Warning,554,08/28/02,07:56:44,,Template:
D:\Inetpub\wwwroot\webServices\deersValidation.cfm, Ran: 210 seconds.
Information,129,08/28/02,07:56:45,,A long-running request returned.
The unresponsive thread count is down to 6.
[D:\Inetpub\wwwroot\foo\dverify.cfm].
Warning,129,08/28/02,07:56:45,,Template:
D:\Inetpub\wwwroot\foo\dverify.cfm, Ran: 211 seconds.
Warning,426,08/28/02,08:00:19,,A request exceeded the timeout. The
unresponsive thread count is up to 7. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,08:00:19,, !!  CFTrace::logThread(308) has no
entry for thread 308
Warning,426,08/28/02,08:04:49,,A request exceeded the timeout. The
unresponsive thread count is up to 8. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,08:04:49,, !!  CFTrace::logThread(554) has no
entry for thread 554
Warning,426,08/28/02,08:07:49,,A request exceeded the timeout. The
unresponsive thread count is up to 9. [D:\Inetpub\wwwroot\foo\dverify.cfm]
Error,426,08/28/02,08:07:49,, !!  CFTrace::logThread(129) has no
entry for thread 129
Fatal,426,08/28/02,08:09:19,,Unresponsive thread threshold reached.
Restarting service.
Information,177,08/28/02,08:09:23,,The ColdFusion Application
Server started.
(ETC)



The template uses a custom tag call that does a cfhttp call to another
template on the same server, trying my hand at a pseudo web service.

Basically:
1.  Template calls custom tag for validation.
2.  Custom tag calls (local/same cf server) web service url
3.  Web service url/template checks if local cache(ms sql db) if user
validation expired.  If not expired and validates properly, returns 1.
4.  If expired:
   Calls a third party web service, which we validate against.
   Validation fails, return 0
   Validation succeeds, insert to local db cache, return 1

I hope that makes sense.

Could that cause problems?  I would guess that it would take two threads as
one template calls another...  But that shouldn't be to bad.

We've tried 

RE: Function?

2002-08-28 Thread Kris Pilles

Well I want to validate certain fields throughout the application and
use the submit for a master save of all of the data associated with the
form.

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 28, 2002 1:01 PM
To: CF-Talk
Subject: RE: Function?


Why not just let it happen when the user clicks a submit button?  Onexit
AKA OnBlur is creepy and confusing.

but it's possible to do it your way.


First write a javascript function to submit the form.  


THen in the form field for the SSN, add in this attribute..

onblur=nameoffunction();


that way, when the user moves out of the field, it calls the javascript,
which submits the form magically.

walla!



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:52 AM
To: CF-Talk
Subject: Function?


I was curious if it is possible for me to write a function that will
onExit from a form field cerify that data against our database?

For examples if I enter in my SSN then onexit the ssn would be passed
back to the server and a query would execute

Either returing the results of my query (firstname, lastname etc...) or
it would send back no then I would display a error message.

Please advise... Seems possible im just not sure how to do
it...exactly...

Thanks for your help 

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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



Cflocation and a popup

2002-08-28 Thread Kodjo Ackah

Can I do this?

cfif NOT IsDefined('session.client_id')
cflocation url=javascript:popUpb('home_login.cfm')
cfabort
/cfif


It doesn't work though!

Don't worry - I have a function in my head tags within my top element
page.

Kodjo ackah
Principal Consultant
concrete-media.com



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



Re: Big problem- session vars not saved in IE6 on CF5

2002-08-28 Thread Chris Norloff

I'd suspect the cflocation and/or cookies - if it doesn't have addtoken set, and 
there's problems with the cookies, session vars won't know which session they're part 
of.  Not sure why that would change all of a sudden, though.

I had a problem with an organization once where they stripped all javascript out of 
web pages without telling anyone. Did a number on my client-side activity!

Chris Norloff

-- Original Message --
from: Smith, Don , , WHS/PSD [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 28 Aug 2002 11:50:30 -0400

I am having a big problem with an old standard login system.  This is the
most simple login system I know and have used it for years.

It consists of:
Login form page
Login action page
Main page
Session variables tracking who is logged in

The user enters in their login acct, the action page compares it against the
db, then sets some session variables and uses cflocation to forward them to
a new page or back to the login page if they fail.  The application page
checks for the session variable to see if they're logged in and uses
cflocation to send them back to the login page if the var doesn't exist.

Up until August 19 it worked fine on all browsers.  

After then, it works fine on about 75% of the instances of IE6 in our
enterprise.

It fails on about 1 out of 4 IE installations including my own!

What happens is the user logs in, the database accepts the login and uses
cflocation to send them to the main page.  Then Application.cfm checks to
see if they have the correct session variable and uses cflocation to forward
them to the login page.  I can display the session vars at the bottom of the
login action page during testing, but as soon as I turn cflocation back on,
the session variables do not exist on the main page after the action page.
They disappear.  Yes they exist on most instances of IE and they exist in
every single instance of NS that I tested.

I have a working version of IE 6 that can login with no problem- I have
modified my internet options (ESPECIALLY the cookies/privacy options) to
match that machine exactly, but still the problems persist on my machine.

The only thing that I did that could have affected this on August 19 was
that I remember that morning getting a request to log into MS Passport to
access my hotmail account.  Other than that, I changed none of this code.

Since 25% of our users seem to be affected by this problem, it's a big deal
for us.

I have asked EVERYONE about this and no one has seen this one before.  Have
any of you heard about this before or does anyone have any suggestions of
how to go about debugging this?  

Thanks,

Don Smith

__
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: Function?

2002-08-28 Thread Phoeun Pha

That is unconventional.  Do it this way...

Put an ONCLICK attribute in the submit button.  That way, if u click it, it
will run your javascript functions which u will write to validate the
fields.  If something is wrong, put out a pop up message.  if nothing is
wrong, have it submit the message.



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 12:20 PM
To: CF-Talk
Subject: RE: Function?


Well I want to validate certain fields throughout the application and
use the submit for a master save of all of the data associated with the
form.

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 28, 2002 1:01 PM
To: CF-Talk
Subject: RE: Function?


Why not just let it happen when the user clicks a submit button?  Onexit
AKA OnBlur is creepy and confusing.

but it's possible to do it your way.


First write a javascript function to submit the form.  


THen in the form field for the SSN, add in this attribute..

onblur=nameoffunction();


that way, when the user moves out of the field, it calls the javascript,
which submits the form magically.

walla!



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:52 AM
To: CF-Talk
Subject: Function?


I was curious if it is possible for me to write a function that will
onExit from a form field cerify that data against our database?

For examples if I enter in my SSN then onexit the ssn would be passed
back to the server and a query would execute

Either returing the results of my query (firstname, lastname etc...) or
it would send back no then I would display a error message.

Please advise... Seems possible im just not sure how to do
it...exactly...

Thanks for your help 

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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: Cflocation and a popup

2002-08-28 Thread Phoeun Pha

actually, this would work


cfif NOT IsDefined('session.client_id')
script language=javascript
function pupUpb()
blah blah blah;

/script
/cfif


it runs the script right in there :)

-Original Message-
From: Kodjo Ackah [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 12:18 PM
To: CF-Talk
Subject: Cflocation and a popup


Can I do this?

cfif NOT IsDefined('session.client_id')
cflocation url=javascript:popUpb('home_login.cfm')
cfabort
/cfif


It doesn't work though!

Don't worry - I have a function in my head tags within my top element
page.

Kodjo ackah
Principal Consultant
concrete-media.com




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



Re: Cflocation and a popup

2002-08-28 Thread Paul Giesenhagen

The abort is probably giving you fits ... remove it and try it out!


Paul Giesenhagen
QuillDesign


- Original Message - 
From: Kodjo Ackah [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 12:18 PM
Subject: Cflocation and a popup


 Can I do this?
 
  
 
 It doesn't work though!
 
 Don't worry - I have a function in my head tags within my top element
 page.
 
 Kodjo ackah
 Principal Consultant
 concrete-media.com
 
 
 
 
__
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: Function?

2002-08-28 Thread charlie griefer

Phoeun Pha writes: 

 That is unconventional.  Do it this way... 
 
 Put an ONCLICK attribute in the submit button.  That way, if u click it, it
 will run your javascript functions which u will write to validate the
 fields.  If something is wrong, put out a pop up message.  if nothing is
 wrong, have it submit the message. 
 

actually i believe it's preferrable to have an onSubmit event in the form 
tag to call the validation functions(s) rather than an onClick event in the 
submit button. 

charlie 

 

 


 
 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 28, 2002 12:20 PM
 To: CF-Talk
 Subject: RE: Function? 
 
 
 Well I want to validate certain fields throughout the application and
 use the submit for a master save of all of the data associated with the
 form. 
 
 -Original Message-
 From: Phoeun Pha [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 28, 2002 1:01 PM
 To: CF-Talk
 Subject: RE: Function? 
 
 
 Why not just let it happen when the user clicks a submit button?  Onexit
 AKA OnBlur is creepy and confusing. 
 
 but it's possible to do it your way. 
 
 
 First write a javascript function to submit the form.   
 
 
 THen in the form field for the SSN, add in this attribute.. 
 
 onblur=nameoffunction(); 
 
 
 that way, when the user moves out of the field, it calls the javascript,
 which submits the form magically. 
 
 walla! 
 
  
 
 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 28, 2002 11:52 AM
 To: CF-Talk
 Subject: Function? 
 
 
 I was curious if it is possible for me to write a function that will
 onExit from a form field cerify that data against our database? 
 
 For examples if I enter in my SSN then onexit the ssn would be passed
 back to the server and a query would execute 
 
 Either returing the results of my query (firstname, lastname etc...) or
 it would send back no then I would display a error message. 
 
 Please advise... Seems possible im just not sure how to do
 it...exactly... 
 
 Thanks for your help  
 
 Kris Pilles
 Website Manager
 Western Suffolk BOCES
 507 Deer Park Rd., Building C
 Phone: 631-549-4900 x 267
 E-mail: [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: Web Hosting services for ColdFusion

2002-08-28 Thread novakbanda

www.cfdynamics.com

Good people, good prices.  We use them and are very happy with them.

-Novak

- Original Message -
From: siva girumala [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 7:12 AM
Subject: Web Hosting services for ColdFusion


 Hi

 I am going to release a website for CFMX certification
 in  a shortwhile.

 I would like to know about the hosting services for
 Coldfusion... Please mention few names either
 free/charge basis...

 Thank you

 --Siva Girumala

 __
 Do You Yahoo!?
 Yahoo! Finance - Get real-time stock quotes
 http://finance.yahoo.com
 
__
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: Function?

2002-08-28 Thread Phoeun Pha

Yes, you are right.  I thought that she had wanted to do javascript, then
serverside validation, and if something is wrong, bring them back to the
input page with prefilled fields and alert them.  If nothing is wrong, still
bring them back to the input page, except this time instead of an alert
message, display a submit button for them to click.

heh i'm sleepy i guess



-Original Message-
From: charlie griefer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 12:34 PM
To: CF-Talk
Subject: Re: Function?


Phoeun Pha writes: 

 That is unconventional.  Do it this way... 
 
 Put an ONCLICK attribute in the submit button.  That way, if u click it,
it
 will run your javascript functions which u will write to validate the
 fields.  If something is wrong, put out a pop up message.  if nothing is
 wrong, have it submit the message. 
 

actually i believe it's preferrable to have an onSubmit event in the form 
tag to call the validation functions(s) rather than an onClick event in the 
submit button. 

charlie 

 

 


 
 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 28, 2002 12:20 PM
 To: CF-Talk
 Subject: RE: Function? 
 
 
 Well I want to validate certain fields throughout the application and
 use the submit for a master save of all of the data associated with the
 form. 
 
 -Original Message-
 From: Phoeun Pha [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 28, 2002 1:01 PM
 To: CF-Talk
 Subject: RE: Function? 
 
 
 Why not just let it happen when the user clicks a submit button?  Onexit
 AKA OnBlur is creepy and confusing. 
 
 but it's possible to do it your way. 
 
 
 First write a javascript function to submit the form.   
 
 
 THen in the form field for the SSN, add in this attribute.. 
 
 onblur=nameoffunction(); 
 
 
 that way, when the user moves out of the field, it calls the javascript,
 which submits the form magically. 
 
 walla! 
 
  
 
 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 28, 2002 11:52 AM
 To: CF-Talk
 Subject: Function? 
 
 
 I was curious if it is possible for me to write a function that will
 onExit from a form field cerify that data against our database? 
 
 For examples if I enter in my SSN then onexit the ssn would be passed
 back to the server and a query would execute 
 
 Either returing the results of my query (firstname, lastname etc...) or
 it would send back no then I would display a error message. 
 
 Please advise... Seems possible im just not sure how to do
 it...exactly... 
 
 Thanks for your help  
 
 Kris Pilles
 Website Manager
 Western Suffolk BOCES
 507 Deer Park Rd., Building C
 Phone: 631-549-4900 x 267
 E-mail: [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: Function?

2002-08-28 Thread Shawn Grover

Unconventional?  I've seen a LARGE number of applications that do this sort
of validation - granted most are desktop applications.  In a web environment
this is more of a pain to do, but still very possible.  Perhaps a better
word would be Uncommon? at least in web pages.

The unwritten standard that I've seen in web pages is to validate your data
when the form is being submitted.  This certainly makes writing the code
easier, and removes any weird delays checking data while enter it.  However,
each application has it's own requirements, and some will require validation
when the data is entered (i.e.  a text box field that only allows numbers).

I worked on a web app recently where the type of validation to be done
changed on the fly depending on the value of some other form elements.  This
validation had to happen as data was entered, when the field lost focus, and
when the form was submitted.  It took a fair bit of code to make it happen,
but it wasn't impossible, and actually performs pretty good considering
network lags and all

My thoughts...

Shawn Grover

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:24 AM
To: CF-Talk
Subject: RE: Function?


That is unconventional.  Do it this way...

Put an ONCLICK attribute in the submit button.  That way, if u click it, it
will run your javascript functions which u will write to validate the
fields.  If something is wrong, put out a pop up message.  if nothing is
wrong, have it submit the message.



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 12:20 PM
To: CF-Talk
Subject: RE: Function?


Well I want to validate certain fields throughout the application and
use the submit for a master save of all of the data associated with the
form.

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 28, 2002 1:01 PM
To: CF-Talk
Subject: RE: Function?


Why not just let it happen when the user clicks a submit button?  Onexit
AKA OnBlur is creepy and confusing.

but it's possible to do it your way.


First write a javascript function to submit the form.  


THen in the form field for the SSN, add in this attribute..

onblur=nameoffunction();


that way, when the user moves out of the field, it calls the javascript,
which submits the form magically.

walla!



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:52 AM
To: CF-Talk
Subject: Function?


I was curious if it is possible for me to write a function that will
onExit from a form field cerify that data against our database?

For examples if I enter in my SSN then onexit the ssn would be passed
back to the server and a query would execute

Either returing the results of my query (firstname, lastname etc...) or
it would send back no then I would display a error message.

Please advise... Seems possible im just not sure how to do
it...exactly...

Thanks for your help 

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [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: Cflocation and a popup

2002-08-28 Thread S . Isaac Dealey

 Can I do this?

 cfif NOT IsDefined('session.client_id')
 cflocation url=javascript:popUpb('home_login.cfm')
 cfabort
 /cfif


 It doesn't work though!

 Don't worry - I have a function in my head tags within my top element
 page.

M... nope, I wouldn't expect that to work and here's why:

cflocation actually is a shortcut for a particular cfheader tag, so it
redirects to the next page by manipulating the http header information for
the current request. There is however no communication ( that I'm aware of )
between the http headers for a given request and javascript on the page...
So, the way to get this to work the way you would like it to is to eliminate
the cflocation and use a slightly different syntax.

cfif NOT IsDefined('session.client_id')
script language=javascript
popUpb('home_login.cfm');
/script
cfabort
/cfif

I won't get into specifics about how this technically ought to be inside the
head tags or how it's probably better to associate it with the
window.onload event either in the body tag or by setting the event to your
function... this syntax should work for all intents and purposes on most
browsers.


hth

Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046
__
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



programmer vs. developer

2002-08-28 Thread Phoeun Pha

whats the difference?
__
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: Function?

2002-08-28 Thread S . Isaac Dealey

 Yes, you are right.  I thought that she had wanted to do javascript, then
 serverside validation, and if something is wrong, bring them back to the
 input page with prefilled fields and alert them.  If nothing is wrong,
 still
 bring them back to the input page, except this time instead of an alert
 message, display a submit button for them to click.

 heh i'm sleepy i guess

Actually, dependant upon the application, I could see a situation where it
might be beneficial to take the contents of a single input field and pass or
submit them to an action page in the onblur() event of the field, thus
making allmost all visible content always current, and eliminating the need
for a submit or save button.

The only drawbacks are that it makes undo a little unwieldy and has the
potential to drastically increase bandwidth and server resource usage as a
result of sending dozens if not hundreds or thousands of page requests for
such a tiny amount of data.

But the idea is interresting and possibly viable, given circumstance.


Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046
__
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: Web Hosting services for ColdFusion

2002-08-28 Thread charlie griefer

[EMAIL PROTECTED] writes: 

 www.cfdynamics.com 
 
 Good people, good prices.  We use them and are very happy with them. 
 
 -Novak 
 

I love that on their 'side-by-side comparison' page they list that all of 
their plans offer 'Java Script' :) 

 

 - Original Message -
 From: siva girumala [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, August 28, 2002 7:12 AM
 Subject: Web Hosting services for ColdFusion 
 
 
 Hi 

 I am going to release a website for CFMX certification
 in  a shortwhile. 

 I would like to know about the hosting services for
 Coldfusion... Please mention few names either
 free/charge basis... 

 Thank you 

 --Siva Girumala 

 __
 Do You Yahoo!?
 Yahoo! Finance - Get real-time stock quotes
 http://finance.yahoo.com 
 
 
__
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: Big problem- session vars not saved in IE6 on CF5

2002-08-28 Thread novakbanda

You know... I passed by this thread originally but then this morning I
remembered that I have experienced something similar to this in the past.
It was even reported to Macromedia and (reluctantly) confirmed to be a bug.
I wish I could remember the exact details but to the best of my recollection
it had something to do with using session variables and CFCONTENT or...
session variables and cflocation

Something like that.  Since MM couldn't give us a fix... the workaround was
to use CLIENT vars instead of session vars.

I also recall an issue with the CFCOOKIE tag and CFCONTENT tag (in CF5).
Once again, the workaround here was to use CLIENT vars instead of regular
cookies.  On the surface it didn't make much sense since a Client var IS a
cookie... but I guess it was treated differently in the CF code...

-Novak

- Original Message -
From: Mark W. Breneman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 9:18 AM
Subject: RE: Big problem- session vars not saved in IE6 on CF5


 I too have seen this on one of our client's server, that I do not manage.
 Where I first found it was a job app that used different includes for
 different jobs.  When the data was inserted into the database about
15%-20%
 of the records would not have a value from the session. Thus you could not
 tell what job they were applying for. I never did track down the exact
 problem I fix it by passing the job ID in the url line.

 Are cookies  enabled? Check to see if IE is set to default security
 settings. Under some of the higher settings cookies are disabled and since
 sessions are tracked via the CFID and CFTOKEN cookies session vars will
 not work.

 You can turn on Debugging Options - Show Variables on the server and
check
 to see if the CFID and CFTOKEN cookies are being written.  That will show
up
 in the browser under the CGI Variables: HTTP_COOKIE

 If you find the problem please let me know.  So far this has not been a
 problem for my servers.

 Mark W. Breneman
 -Macromedia Certified ColdFusion Developer
 -Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770

 -Original Message-
 From: Smith, Don , , WHS/PSD [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 28, 2002 10:51 AM
 To: CF-Talk
 Subject: Big problem- session vars not saved in IE6 on CF5


 I am having a big problem with an old standard login system.  This is the
 most simple login system I know and have used it for years.

 It consists of:
 Login form page
 Login action page
 Main page
 Session variables tracking who is logged in

 The user enters in their login acct, the action page compares it against
the
 db, then sets some session variables and uses cflocation to forward them
to
 a new page or back to the login page if they fail.  The application page
 checks for the session variable to see if they're logged in and uses
 cflocation to send them back to the login page if the var doesn't exist.

 Up until August 19 it worked fine on all browsers.

 After then, it works fine on about 75% of the instances of IE6 in our
 enterprise.

 It fails on about 1 out of 4 IE installations including my own!

 What happens is the user logs in, the database accepts the login and uses
 cflocation to send them to the main page.  Then Application.cfm checks to
 see if they have the correct session variable and uses cflocation to
forward
 them to the login page.  I can display the session vars at the bottom of
the
 login action page during testing, but as soon as I turn cflocation back
on,
 the session variables do not exist on the main page after the action page.
 They disappear.  Yes they exist on most instances of IE and they exist in
 every single instance of NS that I tested.

 I have a working version of IE 6 that can login with no problem- I have
 modified my internet options (ESPECIALLY the cookies/privacy options) to
 match that machine exactly, but still the problems persist on my machine.

 The only thing that I did that could have affected this on August 19 was
 that I remember that morning getting a request to log into MS Passport to
 access my hotmail account.  Other than that, I changed none of this code.

 Since 25% of our users seem to be affected by this problem, it's a big
deal
 for us.

 I have asked EVERYONE about this and no one has seen this one before.
Have
 any of you heard about this before or does anyone have any suggestions of
 how to go about debugging this?

 Thanks,

 Don Smith

 
__
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: programmer vs. developer

2002-08-28 Thread Michael Dinowitz

In MMs mind, a programmer is one who uses a compiled language like Java or C++. A 
developer is someone who uses a scripting language like CF. This is a totally 
artificial distinction and one I reject on every level. I program. So do you. We're 
programmers.


 whats the difference?
 
__
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: Cflocation and a popup

2002-08-28 Thread Kodjo Ackah

No joy to dropping the

 cfabort

Kodjo ackah
Principal Consultant
concrete-media.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: Cflocation and a popup

2002-08-28 Thread Kodjo Ackah

No joy to this either!




cfif NOT IsDefined('session.client_id')
script language=javascript
function popUpb(URL) {
day = new Date();
id = day.getTime();
eval(page + id +  = window.open(home_login.cfm, ' + id + ',
'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,wid
th=580,height=580,bgcolor=#11'););
}

/script

/cfif

Kodjo ackah
Principal Consultant
concrete-media.com



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



RE: programmer vs. developer

2002-08-28 Thread Adrian Lynch

A developer developes, a programmer programs.

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 18:42
To: CF-Talk
Subject: programmer vs. developer


whats the difference?

__
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: programmer vs. developer

2002-08-28 Thread Tony Weeg

imho:

developer has these as his/her strong suit: 
50/50 on graphical interface/programming work

photoshop/fireworks
flash
cf
sql
javascript
dhtml

a programmer is a language guru:

all ecma based scripts
cf
maybe some vbscript/asp (if that be their flavor of
choice)
sql (cant get too far without this guy)



..tony

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

-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 28, 2002 1:42 PM
To: CF-Talk
Subject: programmer vs. developer


whats the difference?

__
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



CFTicket Beta Testers Needed.

2002-08-28 Thread Critter

oi List!!

We are currently looking for 10 beta testers for our new ColdFusion based ticketing 
system.

Below is a quick list of features it offers:

 Multiple Queues for different accounts
 Multiple Users allowed, all with different permissions
 Statistics for quick viewing of which queues are the busiest
 History of all communication between customer and your company
 Autoresponders to new and closed tickets
 Notification of new tickets
 Notification at certain intervals, or after each new ticket. Allows multiple 
recipients
 Powerful search engine
 Enhanced security allows only certain people into certain areas
 Color coding scheme allows quick viewing of which tickets have been responded to
 Quick navigation allows for more efficient work
 Built in Web-Mail allows for quick replying to Tickets
 Compatible with Windows and Unix/Linux and MSSQL, Microsoft Access, and MySQL


You can read up on it at http://www.cornfeed.com and if you are interested in helping 
us beta test the app, please
send an email to [EMAIL PROTECTED]

Cheers

Critz

__
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: programmer vs. developer

2002-08-28 Thread Adrian Lynch

If you consider yourself a programmer because you write cfml then you're
saying cfml is a programming language?

Ade

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2002 18:52
To: CF-Talk
Subject: Re: programmer vs. developer


In MMs mind, a programmer is one who uses a compiled language like Java or
C++. A developer is someone who uses a scripting language like CF. This is a
totally artificial distinction and one I reject on every level. I program.
So do you. We're programmers.


 whats the difference?
 

__
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



Exchange, Outlook Tasks with CF

2002-08-28 Thread Paul Ihrig

Hello all.

i need to figure out how to create Tasks
within Outlook using ColdFusion with our Exchange server.

any pointers, leads  example code would be SO MUCH appreciated...

thank you.

-paul
__
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: Cflocation and a popup

2002-08-28 Thread Kodjo Ackah

Isaac,
 this did not work - cfabort makes it all go blank!



Kodjo ackah
Principal Consultant
concrete-media.com



__
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: programmer vs. developer

2002-08-28 Thread Michael Dinowitz

Define a programming language and see if CF fits into it. Does it store variables? Do 
conditional logic? iterate loops? convert data? What makes C++ a programming language 
and CF not one? If you say that CF is just built on top of C++, then every C++ and 
java programmer aren't really programmers as they're not writing machine code. 
The argument is an artificial one. 
I'm a programmer because I use a computer language to write applications (even a 
single template) that runs on a computer to process some data.


 If you consider yourself a programmer because you write cfml then you're
 saying cfml is a programming language?
 
 Ade
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: 28 August 2002 18:52
 To: CF-Talk
 Subject: Re: programmer vs. developer
 
 
 In MMs mind, a programmer is one who uses a compiled language like Java or
 C++. A developer is someone who uses a scripting language like CF. This is a
 totally artificial distinction and one I reject on every level. I program.
 So do you. We're programmers.
 
 
  whats the difference?
  
 
 
__
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



  1   2   3   >