remote site MySQL or local Access?

2001-03-23 Thread Kay Smoljak

Hi all,

I have a non-profit site that I look after. It used to be all manually
updated HTML but they are looking at expanding it a bit and I'd like to
transfer some of the updating from myself to the committee members.

As they are not well-funded, at the moment I'm thinking of using frames,
hosting the CF elements of the site on CFM-Resources (the free account to
start with, although I would consider paying the one of the other options
myself later on if it was going to be more reliable) and the static
pages/framesets on their donated Australian university hosting space and
domain name. (The domain name is a subdomain of the university's and is
quite well known to their audience, so they can't change it or move it
elsewhere, before someone suggests that).

With regards to the database I have two options that I can see: use the
Access dsn that is part of the CFM-Resources account, or use MySQL which is
installed on the Linux web server at the Australian university. I'm not sure
if MySQL is actually all that much better than Access (the traffic on the
site is really low, about 10-15 visitors per day at the moment) or if
accessing a remote database would be too slow (and is it even possible?).

Does anyone forsee any major flaws in my master plan or have any
recommendations? Suggestions please!

Thanks,
Kay.
__

Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!

Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au


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



Help please

2001-03-23 Thread Venkata Ramakrishna

Hi gang,
Iam a Cf guy since 1.5 years.I changed my company
expecting a assignment in US.As the market slowed down
there,my new employer is making me sit at his place.
The problem is that he don't have any CF work and the
other teams wont allow me inside their domain.

Should i stick with CF or change to some other
domain?Whats the trend at US?
Can someone suggest a way out until the US markets
gear up again?

Expecting some serious suggestions.

Thank you.

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

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



RE: remote site MySQL or local Access?

2001-03-23 Thread Kay Smoljak

From: Garza, Jeff [mailto:[EMAIL PROTECTED]]

What server are they running on?  Unix, WinNT ???  This sounds
like it might
be best to look at a different tool.  Perhaps Perl on Unix or ASP on NT...
Perl running the DBI for MySQL cranks!  Just a thought.

They are running Linux... apart from that I don't really know. About four
months ago they promised to install PHP on the box for me but they claim
they are having difficulties getting it installed and don't have enough time
to sort it out. I was willing to learn a little PHP but as it's way overdue
now and I don't get any money from it I think it would be best to stick with
what I know, which is CF.

If you decide to go ahead with it, you'll be better off using the
Access DSN
on CFM-Resources.  The performance hit of going across the pond multiple
times would probably be too much.  I've stored hundreds of tables in a
single access DB.  Shouldn't be too much of a problem.

That was kinda what I was thinking... it's just that there are so many
horror stories about using Access that I was a little reluctant to trust it.

What about CFM-resources.com? I realise that with free hosting you get what
you pay for, but CF hosting in Australia is ridiculously expensive compared
to what I've seen in the US. I was thinking I could start out on the free
account and if it all works out well and I can convince someone to pay for
it, upgrade to a paid account later. Does anyone have any experience with
their paid hosting? Is it any more reliable than the free? And if not, are
there any other "budget" CF hosts out there I might consider?

Thanks again,
K.

Original Message-
From: Kay Smoljak
To: CF-Talk
Sent: 3/22/01 10:52 PM
Subject: remote site MySQL or local Access?

Hi all,

I have a non-profit site that I look after. It used to be all manually
updated HTML but they are looking at expanding it a bit and I'd like to
transfer some of the updating from myself to the committee members.

As they are not well-funded, at the moment I'm thinking of using frames,
hosting the CF elements of the site on CFM-Resources (the free account
to
start with, although I would consider paying the one of the other
options
myself later on if it was going to be more reliable) and the static
pages/framesets on their donated Australian university hosting space and
domain name. (The domain name is a subdomain of the university's and is
quite well known to their audience, so they can't change it or move it
elsewhere, before someone suggests that).

With regards to the database I have two options that I can see: use the
Access dsn that is part of the CFM-Resources account, or use MySQL which
is
installed on the Linux web server at the Australian university. I'm not
sure
if MySQL is actually all that much better than Access (the traffic on
the
site is really low, about 10-15 visitors per day at the moment) or if
accessing a remote database would be too slow (and is it even
possible?).

Does anyone forsee any major flaws in my master plan or have any
recommendations? Suggestions please!

Thanks,
Kay.
__

Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!

Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au


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


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



Need some parsing help

2001-03-23 Thread Brian Thornton

Should I go through the route of len and right functions to accomplish the following.

I have a email adress. ([EMAIL PROTECTED])
I want to parse just the domain and return juanvaldez.com
THen insert it into a field.

Should I Find the char of @ then get the len of the string (21)
Then grab fron the @ (5) to 61 for the len og 16 then insert it? Any other ideas?

-brian



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

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



RE: How do I get NT user name into CGI_AUTH_USER

2001-03-23 Thread Kevan . Windle

Thanks John and Jeff that was it.

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 17:03
To: CF-Talk
Subject: RE: How do I get NT user name into CGI_AUTH_USER


Check in IIS. When I've wanted to capture NT Usernames I've had to turn off
"anonymous access" in IIS so that it records the nt information. I'm not
sure about in internet sites, my experience was with an intranet app, but
that might help you some.

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.red-omega.com http://www.red-omega.com

15 people are known to have been crushed to death tilting soda
machines towards them in order to receive free soda.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 8:48 AM
To: CF-Talk
Subject: How do I get NT user name into CGI_AUTH_USER


Where do I go to do this. I've inherited a site that uses it, which I've
copied to a development server.
On the live site
AUTH_TYPE=NTLM

AUTH_USER=ntusername
 whereas it is empty on the dev server. I'm using NT4 CF4.5 and the IIS that
comes with Option pack 4.

Thanks



**

The opinions expressed in this E-mail are those  of  the individual  and
not  necessarily  the  company.  This E-mail and  any files transmitted
with it are confidential and solely for the use of the intended recipients


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

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



Re: Need some parsing help

2001-03-23 Thread Tom Espen Pedersen

Just use cfset domain = ListLast(String,"@")
since you don't know how many letters will be before the @.

Sincirely
Tom Espen Pedersen
developer @ www.pixelduck.com
[EMAIL PROTECTED]

- Original Message -
From: "Brian Thornton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 8:36 AM
Subject: Need some parsing help


 Should I go through the route of len and right functions to accomplish the
following.

 I have a email adress. ([EMAIL PROTECTED])
 I want to parse just the domain and return juanvaldez.com
 THen insert it into a field.

 Should I Find the char of @ then get the len of the string (21)
 Then grab fron the @ (5) to 61 for the len og 16 then insert it? Any other
ideas?

 -brian




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

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



Re: Need some parsing help

2001-03-23 Thread Jon Hall

Stuff like this with one delimiter, I go the lazy way ;-)

#listlast(emailAddress,"@") #

That should do the trick, without getting into too much code.

jon
- Original Message -
From: "Brian Thornton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 2:36 AM
Subject: Need some parsing help


 Should I go through the route of len and right functions to accomplish the
following.

 I have a email adress. ([EMAIL PROTECTED])
 I want to parse just the domain and return juanvaldez.com
 THen insert it into a field.

 Should I Find the char of @ then get the len of the string (21)
 Then grab fron the @ (5) to 61 for the len og 16 then insert it? Any other
ideas?

 -brian




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

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



RE: remote site MySQL or local Access?

2001-03-23 Thread Daniel Lancelot

Well certainly on the $5.99 account you get what you pay for...
It doesn't seem to go down quite as much as the free sites, maybe twice a
month?
Not good... but still good value...
Depends how critical the site is - For a small charity site etc Id say it
was reasonable...



-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 07:21
To: CF-Talk
Cc: Garza, Jeff
Subject: RE: remote site MySQL or local Access?


From: Garza, Jeff [mailto:[EMAIL PROTECTED]]

What server are they running on?  Unix, WinNT ???  This sounds
like it might
be best to look at a different tool.  Perhaps Perl on Unix or ASP on NT...
Perl running the DBI for MySQL cranks!  Just a thought.

They are running Linux... apart from that I don't really know. About four
months ago they promised to install PHP on the box for me but they claim
they are having difficulties getting it installed and don't have enough time
to sort it out. I was willing to learn a little PHP but as it's way overdue
now and I don't get any money from it I think it would be best to stick with
what I know, which is CF.

If you decide to go ahead with it, you'll be better off using the
Access DSN
on CFM-Resources.  The performance hit of going across the pond multiple
times would probably be too much.  I've stored hundreds of tables in a
single access DB.  Shouldn't be too much of a problem.

That was kinda what I was thinking... it's just that there are so many
horror stories about using Access that I was a little reluctant to trust it.

What about CFM-resources.com? I realise that with free hosting you get what
you pay for, but CF hosting in Australia is ridiculously expensive compared
to what I've seen in the US. I was thinking I could start out on the free
account and if it all works out well and I can convince someone to pay for
it, upgrade to a paid account later. Does anyone have any experience with
their paid hosting? Is it any more reliable than the free? And if not, are
there any other "budget" CF hosts out there I might consider?

Thanks again,
K.

Original Message-
From: Kay Smoljak
To: CF-Talk
Sent: 3/22/01 10:52 PM
Subject: remote site MySQL or local Access?

Hi all,

I have a non-profit site that I look after. It used to be all manually
updated HTML but they are looking at expanding it a bit and I'd like to
transfer some of the updating from myself to the committee members.

As they are not well-funded, at the moment I'm thinking of using frames,
hosting the CF elements of the site on CFM-Resources (the free account
to
start with, although I would consider paying the one of the other
options
myself later on if it was going to be more reliable) and the static
pages/framesets on their donated Australian university hosting space and
domain name. (The domain name is a subdomain of the university's and is
quite well known to their audience, so they can't change it or move it
elsewhere, before someone suggests that).

With regards to the database I have two options that I can see: use the
Access dsn that is part of the CFM-Resources account, or use MySQL which
is
installed on the Linux web server at the Australian university. I'm not
sure
if MySQL is actually all that much better than Access (the traffic on
the
site is really low, about 10-15 visitors per day at the moment) or if
accessing a remote database would be too slow (and is it even
possible?).

Does anyone forsee any major flaws in my master plan or have any
recommendations? Suggestions please!

Thanks,
Kay.

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

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



Re: cfscheduler weird thing...

2001-03-23 Thread Mark Woods

coldfusion scheduling is notoriuosly unreliable. I've recreating these 
symptoms over and over, and followed various threads in the allaire forums 
about it, but never seen a straight answer. I suspect it's nothing to do 
with CF per se, that it's something set in windows somewhere which causes 
the cfscheduler not to work on some servers - but I've no idea where/what 
that setting is. (never tried using CFSCHEDULE on linux)

If you want to be sure you're code will work, use the scheduling service 
built into the OS (NT 'at' or Linux 'cron'). There are some custom tags 
available to make using these as easy as using CFSCHEDULE. I think there is 
actually a CFX_SCHEDULE.


Mark

At 12:03 AM 3/23/2001, you wrote:
I got a scheduler website where users can set some meeting and having a
feature to be notified by email at a specific time.

What i've do, is creating a new task with cfschedule to be executed one
time at a specific date. Everything work fine except one thing : the cf
server doesn't see my new task untill i edit/update it via cf panel. (so
it's manually)

Someone know why? My interval refresh is set to 5 minutes.. i've made some
tests and was checking the schedule log files, and that's how i explain this
trouble : i think there is something more under the cf automated task panel
when editing a task that i doesn't have when using cfschedule tag..

any ideas?

Daive
[EMAIL PROTECTED]




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

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



RE: Survey: Web-based WYSIWIG editing tool

2001-03-23 Thread Steve Martin

5) Other - IE5 (though IE5.5 has more granular object control)

Hi All,

Just a quick survey to appease my curiosity...

If you use a web-based WYSYWIG editing tool, what do you use?

1) ActiveEdit (www.cdev.com)
2) eWebEditPro (www.ektron.com)
3) ezEdit (www.siteobjects.com)
4) HTMLArea (www.iautomated.com/products)
5) Other

I am currently using ActiveEdit, and am curious as to what others are using.

Thanks, Cameron


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

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



RE: Textbox validation

2001-03-23 Thread Aidan Whitehall

 the BEST way to do it is to use javascript validation, and if 
 it doesn't
 meet your criteria, popup a message and focus on that field.  
 that's it  :)


If the user has JavaScript disabled, simply implementing client-side
validation wouldn't catch errors.

If you're *only* going to implement one method and cannot dictate what
browser a client should use or it's settings (as in an Intranet), it *has*
to be ColdFusion validation. If you've got time left over on the project, go
back through your application and add in the JavaScript as a courtesy.

The most complete solution would be to use JavaScript initially and then
re-validate the data when it's been returned to the server.


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

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

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

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



RE: Studio: Export RDS Settings?

2001-03-23 Thread Aidan Whitehall

 It's just registry stuff.  Open RegEdit, browse to 
 HKEY_CURRENT_USER/Software/Allaire/RemoteServers,  and with
 RemoteServers highlighted, go to Registry -- Export.  This 
 will save a .reg file, which you can run on the new
 machine.

Ahhh, thanks for the info!

Now I feel like a klutz...  ;-)


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

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

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

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



RE: cfscheduler weird thing...

2001-03-23 Thread Aidan Whitehall

 coldfusion scheduling is notoriuosly unreliable.

Does anyone know if this is going to be addressed in ColdFusion 5.0?

I've *never* managed to get a scheduled event to work and have to resort to
other applications which trigger batch files to open a browser and pass it a
URL as a parameter... pain!


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

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

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

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



RE: Textbox validation

2001-03-23 Thread John Stanley

You should use javascript, that way the page does not have to get submitted
for the validation to occur. Just have the onChange event for the box call a
function that parses the value of the text box for spaces or whatever.

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 7:39 PM
To: CF-Talk
Subject: Textbox validation


Hi,

On one textbox I need to prohibit users entering more than one word - I
don't want them to enter a space.  What's the best way of doing this -
Javascript, or Cold Fusion after the form has been posted?

Thanks.

Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Textbox validation

2001-03-23 Thread DeVoil, Nick

Really the best way is *both*.
JavaScript is much nicer from a user interface point of view.
But if the validation is important you need to do it again on
the server, because you can't guarantee the user has JavaScript
running in their browser.

Nick

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 12:39 AM
To: CF-Talk
Subject: Textbox validation


Hi,

On one textbox I need to prohibit users entering more than one word - I
don't want them to enter a space.  What's the best way of doing this -
Javascript, or Cold Fusion after the form has been posted?

Thanks.

Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: Survey: Web-based WYSIWIG editing tool

2001-03-23 Thread Lanny R. Udey

Yes, Spectra 1.5 does come with eWebEditPro integrated.

Lanny Udey
Hofstra University

 [EMAIL PROTECTED] Friday, March 23, 2001 
Mark Ireland wrote:

 I heard it will come with the new Macromedia Spectra (start getting used to
 it)

Can anyone confirm this? I'm just in the process of developing a site that
will use a web based HTML editor and if this is the case I may need to
explore  eWebEditPro as I am currently using ezEdit

-- 

If it turns out that there is a God, I don't think that he's evil. But
the worst that you can say about him is that basically he's
an underachiever.

Woody Allen 


email: [EMAIL PROTECTED] 
web: http://www.pixelgeek.com/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Any LDAP Guru's here? Authentication Problem

2001-03-23 Thread Paul Ihrig

quick question.
i want to use NDS  LDAP to authenticate ALL the users of our intranet.
my problem that there are 2 servers.
both have the same tree name?

will this cause me problems.
if so is there a way around it?

any ideas would be great

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

Home:   [EMAIL PROTECTED]
614 449-1681

 icq:  47658358


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

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



CFFILE ACTION=copy and NAMECONFLICT

2001-03-23 Thread Aidan Whitehall

I'm using CFFILE to copy a file from one directory to another on the server.
What happens if the file already exists? It's telling me that I can't use
the NAMECONFLICT attribute when the ACTION is "copy":


Attribute set validation error in tag CFFILE

The tag has an invalid attribute combination: the value of the tag switch
attribute 'ACTION' which is now 'COPY' requires a different combination of
attributes. For the same switch attribute value the following unknown
attributes have been provided: (NAMECONFLICT).


Does it just automatically overwrite the file in the destination folder?
Have I got to use CFTRY and CATCH instead?

Seems nuts not to have this built into the CFFILE tag directly...


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

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

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

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



Calling Custom Tags in CFSCRIPT

2001-03-23 Thread Jason Lees (National Express)


Hi All,

In CF Version 4.5 is it possible to call a custom Tag from with in a
CFScript block

EG

cfif x gt 1
cf_Foo In="x" out="y"
/cfif

cfoutputthe x^2 = #y#/cfoutput

How would you convert the CF_Foo into the cfscript block?


Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [EMAIL PROTECTED]

##


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

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



RE: cfscheduler weird thing...

2001-03-23 Thread Mark Woods


I've *never* managed to get a scheduled event to work and have to resort to
other applications which trigger batch files to open a browser and pass it a
URL as a parameter... pain!


err, there's no need to do that. There is an executable you can use to 
process CFML templates via the command line. Have a look at:
http://www.allaire.com/Handlers/index.cfm?ID=3328Method=Full


Mark


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

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



RE: Calling Custom Tags in CFSCRIPT

2001-03-23 Thread Rich Wild

 How would you convert the CF_Foo into the cfscript block?

You can't. :|

You can't use any cf tags within cfscript

One of the many limitations of cfscript - which is a shame.




---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




 -Original Message-
 From: Jason Lees (National Express)
 [mailto:[EMAIL PROTECTED]]
 Sent: 23 March 2001 12:59
 To: CF-Talk
 Subject: Calling Custom Tags in CFSCRIPT
 
 
 
 Hi All,
 
 In CF Version 4.5 is it possible to call a custom Tag from with in a
 CFScript block
 
 EG
 
 cfif x gt 1
 cf_Foo In="x" out="y"
 /cfif
 
 cfoutputthe x^2 = #y#/cfoutput
 
 How would you convert the CF_Foo into the cfscript block?
 
 
 Jason Lees 
 National Express
 Email : [EMAIL PROTECTED]
 
 ###
 This document is intended for, and should only be read by, 
 those persons to
 whom it is addressed. Its contents are confidential and if 
 you have received
 this message in error, please notify us immediately by 
 telephone on 0121 609 6301
 and delete all records of the message from your computer. Any 
 form of reproduction,
 dissemination, copying, disclosure, modification, 
 distribution and / or
 publication of this message without our prior written consent 
 is strictly
 prohibited. Neither the author of this message nor their 
 employers accept
 legal responsibility for the contents of the message. Any 
 views or opinions
 presented are solely those of the author.
 If you have any queries please contact 
 [EMAIL PROTECTED]
 
 ##
 
 

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

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



RE: Calling Custom Tags in CFSCRIPT

2001-03-23 Thread Steve Martin

No.

-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 12:59
To: CF-Talk
Subject: Calling Custom Tags in CFSCRIPT



Hi All,

In CF Version 4.5 is it possible to call a custom Tag from with in a
CFScript block

EG

cfif x gt 1
cf_Foo In="x" out="y"
/cfif

cfoutputthe x^2 = #y#/cfoutput

How would you convert the CF_Foo into the cfscript block?


Jason Lees
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609
6301
and delete all records of the message from your computer. Any form of
reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [EMAIL PROTECTED]

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

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



RE: Calling Custom Tags in CFSCRIPT

2001-03-23 Thread Jason Lees (National Express)


I thought as much but just wanted to make sure I'd not missed an
undocumented feature.

Roll on CF5.0!


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 12:51
To: CF-Talk
Subject: RE: Calling Custom Tags in CFSCRIPT


 How would you convert the CF_Foo into the cfscript block?

You can't. :|

You can't use any cf tags within cfscript

One of the many limitations of cfscript - which is a shame.




---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




 -Original Message-
 From: Jason Lees (National Express)
 [mailto:[EMAIL PROTECTED]]
 Sent: 23 March 2001 12:59
 To: CF-Talk
 Subject: Calling Custom Tags in CFSCRIPT
 
 
 
 Hi All,
 
 In CF Version 4.5 is it possible to call a custom Tag from with in a
 CFScript block
 
 EG
 
 cfif x gt 1
 cf_Foo In="x" out="y"
 /cfif
 
 cfoutputthe x^2 = #y#/cfoutput
 
 How would you convert the CF_Foo into the cfscript block?
 
 
 Jason Lees 
 National Express
 Email : [EMAIL PROTECTED]
 
 ###
 This document is intended for, and should only be read by, 
 those persons to
 whom it is addressed. Its contents are confidential and if 
 you have received
 this message in error, please notify us immediately by 
 telephone on 0121 609 6301
 and delete all records of the message from your computer. Any 
 form of reproduction,
 dissemination, copying, disclosure, modification, 
 distribution and / or
 publication of this message without our prior written consent 
 is strictly
 prohibited. Neither the author of this message nor their 
 employers accept
 legal responsibility for the contents of the message. Any 
 views or opinions
 presented are solely those of the author.
 If you have any queries please contact 
 [EMAIL PROTECTED]
 
 ##
 
 

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

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



RE: cfscheduler weird thing...

2001-03-23 Thread Adkins, Randy

From past experience with CFSchedule, make sure the
website/template that is being called 
(ie, http://mywebsite.com/check_this.cfm )
is not located on an non-standard port.

Meaning the template should be able to be called
from a normal HTTP Request.

If it is behind an obscure port such as:
http://mywebsite.com:8088/check_this.cfm
This will not work.

Hopefully this is addressed in CF 5.0 but not
the case in 4.01 or 4.5

Hope this helps.
Randy

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 7:31 AM
To: CF-Talk
Subject: RE: cfscheduler weird thing...


 coldfusion scheduling is notoriuosly unreliable.

Does anyone know if this is going to be addressed in ColdFusion 5.0?

I've *never* managed to get a scheduled event to work and have to resort to
other applications which trigger batch files to open a browser and pass it a
URL as a parameter... pain!


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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: DTS packages

2001-03-23 Thread Cruz, Joseph

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

There's also some great example code at www.cfcomet.com under SQL Server on how
to do it with CFOBJECT and COM.  We've used it pretty extensively here since
CFEXECUTE and xp_cmdshell are highly secured processes in our environment
(anal-retentive and paranoid sysadmins, I guess ;)

:)

Joe


Joseph Cruz
Wharton Computing and Information Technology
Programmer/Analyst
3620 Locust Walk
Suite 400 SH-DH
Philadelphia, PA  19104-6302
[EMAIL PROTECTED]
215-898-1220(w)  215-573-2798(f)
215-308-0657(p)  215-768-2071(m)
 

 -Original Message-
 From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 22, 2001 11:13 PM
 To: CF-Talk
 Subject: RE: DTS packages
 
 
 cfexecute dtsrun.exe "package name"  or you can run a stored 
 porcedure which
 will do this.
 
 
 
 -Original Message-
 From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 22, 2001 8:39 PM
 To: CF-Talk
 Subject: DTS packages
 
 
 Does anyone know if it is possible to call a dts package on 
 command? If so
 what is the code?

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

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



template and thread...

2001-03-23 Thread Zhou, Mei Y (Mei)

Hi, does anyone know that how template behavior?

My question is: when I have a bunch of 

CFInclude template="../includes/1.cfm"
CFInclude template="../includes/2.cfm"
CFInclude template="../includes/3.cfm"
..
..
CFInclude template="../includes/N.cfm"

are the CF process in  the 1/2/3 order? or 

they process everything ( 1/2/   ... N ) at the
same time ?

according to what I understand, it should be in order,
but my page behavior funny, e.g. 3.cfm depends on
the result of 1.cfm, sometimes it works, sometimes it tells
me that the result is empty...

Please confirm with me for that. Thank you.

Mei



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

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



CF Auctions

2001-03-23 Thread fiachra crean

Hi,

I'm looking to develop an auction section on our
current site, and I've been looking through the dozens
of options in the developers gallery. 

If anyone has experiences (good or bad!) with using
auctions, I'd like to hear them.

Thanks,
Fiachra.

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

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



RE: Survey: Web-based WYSIWIG editing tool

2001-03-23 Thread Paul Ihrig

5) Other :: Ultra Dev!

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

Home:   [EMAIL PROTECTED]
614 449-1681

 icq:  47658358


-Original Message-
From: Cameron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 10:43 PM
To: CF-Talk
Subject: Survey: Web-based WYSIWIG editing tool


Hi All,

Just a quick survey to appease my curiosity...

If you use a web-based WYSYWIG editing tool, what do you use?

1) ActiveEdit (www.cdev.com)
2) eWebEditPro (www.ektron.com)
3) ezEdit (www.siteobjects.com)
4) HTMLArea (www.iautomated.com/products)
5) Other

I am currently using ActiveEdit, and am curious as to what others are using.

Thanks, Cameron


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

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

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



Re: Textbox validation

2001-03-23 Thread W Luke

Thanks for all the replies.  The reason I need to prevent more than one word
being entered, is I'm finding it impossible to use wildcard filtering using
Access' Instr function (any clues anyone?) - for example, if the search
string contained "Bass Guitar" it would only return True if it *matches* it,
and not if it's similar (Like).

Anyways, thanks - going to do what Aidan suggests, and add the Javascript
when I have time.

Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com

 Really the best way is *both*.
 JavaScript is much nicer from a user interface point of view.
 But if the validation is important you need to do it again on
 the server, because you can't guarantee the user has JavaScript
 running in their browser.

 Nick

 -Original Message-
 From: W Luke [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 23, 2001 12:39 AM
 To: CF-Talk
 Subject: Textbox validation


 Hi,

 On one textbox I need to prohibit users entering more than one word - I
 don't want them to enter a space.  What's the best way of doing this -
 Javascript, or Cold Fusion after the form has been posted?

 Thanks.

 Will
 --
 [EMAIL PROTECTED] -=- www.lukrative.com
 Local-Advertising -=- www.localbounty.com

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

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



RDS problem solved

2001-03-23 Thread Manolo Rivero

Hi all
Finally I solved the problem.
It wasn't possible to delete the RDSs right clicking and deleting in the 
file manager.
I had to go to the windows register and look for the keys which correspond 
to each RDS server I've created.
These keys include all the settings I've done in CFStudio.
I removed them and voila...
Thank you very much for your help
Bye
Manuel
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


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



Re: template and thread...

2001-03-23 Thread Mark Woods

I'm pretty sure it is in order, so variables you set in 1 are available in 
2. Try that and see.


At 01:17 PM 3/23/2001, you wrote:
Hi, does anyone know that how template behavior?

My question is: when I have a bunch of

CFInclude template="../includes/1.cfm"
CFInclude template="../includes/2.cfm"
CFInclude template="../includes/3.cfm"
..
..
CFInclude template="../includes/N.cfm"

are the CF process in  the 1/2/3 order? or

they process everything ( 1/2/   ... N ) at the
same time ?

according to what I understand, it should be in order,
but my page behavior funny, e.g. 3.cfm depends on
the result of 1.cfm, sometimes it works, sometimes it tells
me that the result is empty...

Please confirm with me for that. Thank you.

Mei




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

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



determine if user is active?

2001-03-23 Thread Peter Benoit

My bank disconnects me after 5 minutes, how can I reproduce this?


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

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



RE: CFFILE ACTION=copy and NAMECONFLICT

2001-03-23 Thread Stephen Galligan

Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag?

Steve

-- 
Stephen Galligan
ColdFusion Developer
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890. 



-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 12:57
To: CF-Talk
Subject: CFFILE ACTION="copy" and NAMECONFLICT


I'm using CFFILE to copy a file from one directory to another on the server.
What happens if the file already exists? It's telling me that I can't use
the NAMECONFLICT attribute when the ACTION is "copy":


Attribute set validation error in tag CFFILE

The tag has an invalid attribute combination: the value of the tag switch
attribute 'ACTION' which is now 'COPY' requires a different combination of
attributes. For the same switch attribute value the following unknown
attributes have been provided: (NAMECONFLICT).


Does it just automatically overwrite the file in the destination folder?
Have I got to use CFTRY and CATCH instead?

Seems nuts not to have this built into the CFFILE tag directly...


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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



server.log error

2001-03-23 Thread Bud

Hi. What would cause this error? Is it written when CF times out
after trying to connect to a datasource? Or is it something else? TIA

"Error","TID=150","03/21/01","21:10:39","Unable to write reply --
timed out writing data back to web server."
"Error","TID=150","03/21/01","21:10:39","Windows NT error number 1460
occurred."
-- 

Bud Schneehagen - Tropical Web Creations

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

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

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



RE: determine if user is active?

2001-03-23 Thread John Stanley

Body onLoad settimeout (5 minutes worth of milliseconds) when that timeout
has been reached have the session end, window close or whatever

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:35 AM
To: CF-Talk
Subject: determine if user is active?


My bank disconnects me after 5 minutes, how can I reproduce this?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: determine if user is active?

2001-03-23 Thread James Maltby

If you mean what I think you mean - you do know you posted to the CF-Talk
and not the bank's complaints email? ;) - then you need to use session or
client variables (the former is likely to be more relevant) - you can set a
local timeout in your Application.cfm with the following code:

cfapplication name="Whatever"  sessionmanagement="yes"
sessiontimeout="#createtimespan(0,0,5,0)#"

Where the timespan function is (day,hour,minute,second)


HTH

James   

"The Force is strong in this one..."  - Darth Vader



-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 13:35
To: CF-Talk
Subject: determine if user is active?


My bank disconnects me after 5 minutes, how can I reproduce this?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: cfscheduler weird thing...

2001-03-23 Thread Daive

mmmh do you know how to make it work without opening a IE "window" with AT ?
:) that's my only trouble with that hehe

daive

- Original Message -
From: "Mark Woods" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 3:10 AM
Subject: Re: cfscheduler weird thing...


 coldfusion scheduling is notoriuosly unreliable. I've recreating these
 symptoms over and over, and followed various threads in the allaire forums
 about it, but never seen a straight answer. I suspect it's nothing to do
 with CF per se, that it's something set in windows somewhere which causes
 the cfscheduler not to work on some servers - but I've no idea where/what
 that setting is. (never tried using CFSCHEDULE on linux)

 If you want to be sure you're code will work, use the scheduling service
 built into the OS (NT 'at' or Linux 'cron'). There are some custom tags
 available to make using these as easy as using CFSCHEDULE. I think there
is
 actually a CFX_SCHEDULE.


 Mark

 At 12:03 AM 3/23/2001, you wrote:
 I got a scheduler website where users can set some meeting and having a
 feature to be notified by email at a specific time.
 
 What i've do, is creating a new task with cfschedule to be executed one
 time at a specific date. Everything work fine except one thing : the cf
 server doesn't see my new task untill i edit/update it via cf panel. (so
 it's manually)
 
 Someone know why? My interval refresh is set to 5 minutes.. i've made
some
 tests and was checking the schedule log files, and that's how i explain
this
 trouble : i think there is something more under the cf automated task
panel
 when editing a task that i doesn't have when using cfschedule tag..
 
 any ideas?
 
 Daive
 [EMAIL PROTECTED]
 
 
 
 

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

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



cfloop

2001-03-23 Thread John McCosker

Hi all,

I,m not sure if you can nest cfloop but I'm not getting any errors

but the desired result is not working.

This is my code,

cfloop index="item" list="#form.callsign#"
cfquery name="qry_getvehicle" datasource="#application.dsn#"
username="#application.gateway#" password="#application.key#"
SELECT  callsign, vowner, dt, Lat, Lon, Speed, Direction,
Veh_Reg
FROMdbo.vehicles
WHERE   vowner = 224
/cfquery
/cfloop

cfset start = 1
cfset max = qry_getvehicle.recordCount
cfparam name="icon" default=""
cfloop index="Loopcount" from="#start#" to="#max#"
cfif Loopcount eq max
cfset icon = "xhair"
cfelse
cfset icon = "target"
/cfif
cfset allCars = ""
cfloop query="qry_getvehicle" startrow="#start#"
endrow="#max#"
cfif allCars neq ""
cfset allCars = allCars  ";"
/cfif
cfset allCars = replace(allCars 
#qry_getvehicle.lon#  ","  #qry_getvehicle.lat#  ",#icon#," 
#qry_getvehicle.callsign#," ","","ALL")
/cfloop
/cfloop

What I am trying to do is on the last loop set my icon to a crosshair image,
else set it to a target.

I thought by nesting my loop this would have worked.  I suppose I should be
doing a 'while condition' within the cfloop instead, but I'm not too sure.

If anyone could help me on this I'd appreciate, thanx in advance..

JMC

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

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



RE: CFMail replacement for Linux

2001-03-23 Thread Jeff Beer

Thanks for some good ideas all.

The issue is that the client has a dynamic form that lets them generate
e-mail lists on the fly by matching a number of profile options.  The email
lists can vary from 10 - 10,000 addresses depending.  So, something like
majordomo won't work too well.  We looked at using SQL Server's mailer, but
it was not clear how to add custom headers like content-type: text/html or
content-type: multipart/choice.

I was hoping there would be a cfx_mail-type replacement that would work on
Linux.

What we have now is CF formats the message bodies in HTML and text format,
and passes the address list and other message data to a java class.  The
java class sends the mail directly into sendmail over a standard telnet
socket.

It works, but we had to add a 'sleep' period between calls - it was
overrunning sendmail - so now it's slow.  Ah well, speed or stability - that
is the question :-)

Thanks again for all the good suggestions.

Jeff




 -Original Message-
 From: Richard Kuryk [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, March 22, 2001 4:06 PM
 To: CF-Talk
 Subject: RE: CFMail replacement for Linux


 not running linux but why can't you just execute mail with
 your email text
 and let sendmail kickit off just like a perl script would do?

 cfexecute name="mail"

 Rich

 -Original Message-
 From: Jeff Beer [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 21, 2001 1:18 PM
 To: CF-Talk
 Subject: CFMail replacement for Linux


 Does anyone know of a CFMail replacement that will run on Linux?

 We need to allow a client to send 10,000 plus e-mails in one
 shot, possibly
 several times a day.  CFMail (on their server) handles about
 3,000 with
 little trouble, but above that, threads start hanging, the
 server restarts
 over and over, and of course, we lose all the sessions, etc.

 If I can't find a replacement I think I'll have to write the
 message bodies
 and addresses to temp tables and send them in batches every x
 minutes..
 anyone have a better solution?

 Thanks,

 Jeff

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

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



ORACLE Native Driver Bug?

2001-03-23 Thread Cruz, Joseph

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi, all.  

By way of background, we've created an application that keeps tracks of a
user's click stream within a site.

We've run into a curious problem; when the following query is executed  in Cold
Fusion Ent 4.5.1 SP2 on Win2K SP1, CF's memory usage explodes and eventually
crashes the server (usage hovers around 250MB and then jumps to 1.8GB, paging
starts to occur, and then we're out of virtual memory and a hard reboot is
necessary).  However, if we execute the query against a Microsoft ODBC for
ORACLE data source, it runs without a hitch.

If anyone is willing or able to test this particular scenario on their
DEVELOPMENT servers (watch them carefully; the CF Server's memory is gobbled up
in 50MB chunks) so we can gather more data points, that would be great!

Thanks a lot in advance!

Joe


We've isolated a single recordset that causes this to crash; other recordsets
don't seem to effect in the same way.  Here are the details:

ERRANT QUERY:
=
SELECT   page_id, 
   min(click_sequence) as click_sequence, 
   (sum(time_end - time_start)*24*60*60) as total_time
FROM   learnlab.click_detail_1415
WHEREsession_id = '1415'
ANDtime_end is not null
GROUP BY page_id
UNION
SELECT   page_id, min(click_sequence), 0 as total_time
FROM   learnlab.click_detail_1415
WHERE  session_id = '1415'
AND  time_end is null
GROUP BY page_id

TABLE DESCRIPTION:
===
  Column NameNull?Type
- --  
SESSION_ID NOT NULL NUMBER(5)
PAGE_IDNOT NULL VARCHAR2(10)
CLICK_SEQUENCE NOT NULL NUMBER(5)
TIME_START NOT NULL DATE
TIME_ENDDATE
PREV_PAGE_IDVARCHAR2(10)
NEXT_PAGE_IDVARCHAR2(10)
INTRO_FLAG  CHAR(1)

TABLE CONTENTS:
===
SESSION_ID PAGE_IDCLICK_SEQU TIME_START   TIME_END
PREV_PAGE_ NEXT_PAGE_ I
- -- -- --  
- -- -- -
  1415 CATEGORIES 18 17-MAR-0117-MAR-01   
INTROPROD  FUTNWCOV   N
  1415 CATEGORIES 53 17-MAR-0117-MAR-01   
INTROPROD  INTERVIEWS N
  1415 CATEGORIES 55 17-MAR-0117-MAR-01   
INTERVIEWS INTERVIEWS N
  1415 CATEGORIES 59 17-MAR-0117-MAR-01   
INTERVIEWS REVIEWSN
  1415 CATEGORIES 61 17-MAR-0117-MAR-01   
REVIEWSMAINMENU3  N
  1415 CATEGORIES 64 17-MAR-0117-MAR-01   
INTROPROD  INTERVIEWS N
  1415 CATEGORIES 76 17-MAR-0117-MAR-01   
INTPOINT   INTERVIEWS N
  1415 CATEGORIES 83 17-MAR-0117-MAR-01   
INTERVIEWS INTERVIEWS N
  1415 CATEGORIES 91 17-MAR-0117-MAR-01   
INTERVIEWS REVIEWSN
  1415 CATEGORIES 97 17-MAR-0117-MAR-01   
REVIEWSPRINT  N
  1415 CATEGORIES119 17-MAR-0117-MAR-01   
PRINT  REVIEWSN
  1415 CATEGORIES121 17-MAR-0117-MAR-01   
REVIEWSPRINT  N
  1415 CATEGORIES125 17-MAR-0117-MAR-01   
PRINT  REVIEWSN
  1415 CATEGORIES129 17-MAR-0117-MAR-01   
REVIEWSWEBINFON
  1415 CATEGORIES138 17-MAR-0117-MAR-01   
WEBINFOTVADS  N
  1415 CATEGORIES145 17-MAR-0117-MAR-01   
TVADS  MAINMENU3  N
  1415 CATEGORIES148 17-MAR-0117-MAR-01   
INTROPROD  INTROEXIT  N
  1415 FUTACCID   12 17-MAR-0117-MAR-01   
FUTCALIF   FUTKILLER  N
  1415 FUTACCID   47 17-MAR-0117-MAR-01   
FUTCALIF   FUTKILLER  N
  1415 FUTCALIF   11 17-MAR-0117-MAR-01   
FUTEASTFUTACCID   N
  1415 FUTCALIF   46 17-MAR-0117-MAR-01   
FUTEASTFUTACCID   N
  1415 FUTEAST10 17-MAR-0117-MAR-01   
FUTOPENS   FUTCALIF   N
  1415 FUTEAST45 17-MAR-0117-MAR-01   
FUTOPENS   FUTCALIF   N
  1415 FUTEXPENSE 14 17-MAR-0117-MAR-01   
FUTKILLER  FUTNETWORK N
  1415 FUTEXPENSE 49 17-MAR-0117-MAR-01   
FUTKILLER  FUTNETWORK N
  1415 FUTINTRO6 17-MAR-0117-MAR-01   
INTROTOC   FUTNWCOV   N
  1415 FUTKILLER  13 17-MAR-0117-MAR-01   
FUTACCID   FUTEXPENSE N
  1415 FUTKILLER  48 17-MAR-0117-MAR-01   
FUTACCID   FUTEXPENSE N
  1415 FUTNETWORK   

Re: DTS packages

2001-03-23 Thread Duane Boudreau

Thanks!




cfexecute dtsrun.exe "package name"  or you can run a stored porcedure which
will do this.



-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 8:39 PM
To: CF-Talk
Subject: DTS packages


Does anyone know if it is possible to call a dts package on command? If so
what is the code?


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

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



RE: Find position in a list

2001-03-23 Thread Duane Boudreau



Use listFind(list [, delimiter])

HTH,
Duane

-Original Message-
From: James Maltby [mailto:
Sent: Friday, March 23, 2001 9:28 AM
To: CF-Talk
Subject: Find position in a list


Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Find position in a list

2001-03-23 Thread Dylan Bromby

You need GetToken() to get the next/previous values once you get the
position of the original substring.

--Dylan

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 6:34 AM
To: CF-Talk
Subject: RE: Find position in a list




Use listFind(list [, delimiter])

HTH,
Duane

-Original Message-
From: James Maltby [mailto:
Sent: Friday, March 23, 2001 9:28 AM
To: CF-Talk
Subject: Find position in a list


Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Find position in a list

2001-03-23 Thread dennis baldwin

James,

Try this

cfset list="23,24,27,30,543,675,980"
!--- current_number would be dynamic, right now it's set to 543 ---
cfset current_number=543
cfset position=ListFind(list,current_number)
cfloop list="#list#" index="count"
cfset previous_number=ListGetAt(list,position-1)
cfset next_number=ListGetAt(list,position+1)
/cfloop
cfoutput
Previous Number: #previous_number#br
Current Number: #current_number#br
Next Number: #next_number#
/cfoutput

You will run into problems with the first and last number in the list but
this should give you a start and i'm sure you'll be able to find a
workaround.

Dennis Baldwin

-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 9:28 AM
To: CF-Talk
Subject: Find position in a list


Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: Any LDAP Guru's here? Authentication Problem

2001-03-23 Thread Douglas Knudsen



speaking of this, how does one 'authenticate'?  I'm having trouble
getting this to work.
Do I

cfldap  once anonymously to get the userid based on user inputed
info
then
cfldap again with userid and password supplied this time.  If
cfldap pulls back a record, then authentication happend, correct?
I'm told passwords are generally SHA1 hashed in LDAP directories, does
CFLDAP do the hashing?


-
Douglas Knudsen
Leveraged Technologies Group
Alltel AIS
678-351-6063
Got Linux? http://linuxmall.com




From: [EMAIL PROTECTED] AT INTERNET on 03/23/2001 09:27 AM

To:   Douglas Knudsen/ATL/ALLTELCORP, [EMAIL PROTECTED] AT
  INTERNET@CCMAIL
cc:

Subject:  Re: Any LDAP Guru's here? Authentication Problem


Initally I would say no.  Point your cfldap to an ip of the ldap
server.  Will y
ou need to authenticate to both servers?  Neither tree can see each
other can th
ey?  If one of the servers can give you access to all the users
context thats al
l your should
 need.  If you need to authenticate to both do the first query with
 the first IP
 do a user search then do the second query with the second server.
 Once you fin
d the user context make sure you authenticate to the right ip.

 [EMAIL PROTECTED] 03/23/01 07:51AM 
quick question.
i want to use NDS  LDAP to authenticate ALL the users of our
intranet.
my problem that there are 2 servers.
both have the same tree name?

will this cause me problems.
if so is there a way around it?

any ideas would be great

-paul

Web Developer, NBBJ
Work: [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

Home: [EMAIL PROTECTED]
614 449-1681

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

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



Querying NT directory permissions?

2001-03-23 Thread Terri Stocke

Hey all,

I apologize in advance if this topic has already been discussed ad nauseum, 
but I'm not even sure where to begin looking in the archives for this.(I did 
search, but haven't found anything yet to help me out.)

Here's what I need to do. Our department sets up all directories for web 
publishers within our company. We have an online form that users fill out to 
request web space, and then someone on our team sets it up. We would like to 
build an application that will display:

--all of the current web sites (i.e. "folders"),
--all GROUPS that have permission to access the folder,
--all INDIVIDUALS that have permission to access the folder,
--the entire CONTENTS of each folder and any file-level permissions,
--Disk space usage,
--number of files of each type (.doc, .pdf, .xls, etc.)
--Any primary and secondary publishers to the site, as well as associated 
passwords (if possible. Of course this is for our team's eyes only!)

We do not want to have to store this information in a database--we want to 
pull it right off of the NT box itself. I know I can use CFDIRECTORY to 
display the directory contents, and I can find the number of each file type, 
but how can I display permissions and disk space? Is that even possible?

Publishers all use FrontPage, so we will have one server for all of the 
FrontPage sites, and a completely separate server for all of our CF apps.

If anyone has done something similar I would love to know how you 
implemented it.

Thanks!

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

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



RE: determine if user is active?

2001-03-23 Thread Ben Dyer

Or even:

meta http-equiv="Refresh" content="300;url=timeout.cfm"

At 07:45 AM 3/23/01, you wrote:
Body onLoad settimeout (5 minutes worth of milliseconds) when that timeout
has been reached have the session end, window close or whatever

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:35 AM
To: CF-Talk
Subject: determine if user is active?


My bank disconnects me after 5 minutes, how can I reproduce this?

-=-=-=-=-=-=-=-=-=-=-=-=-
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
-=-=-=-=-=-=-=-=-=-=-=-=-


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

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



RE: Find position in a list

2001-03-23 Thread James Maltby

Thanx everyone - have solved the problem now

J

-Original Message-
From: dennis baldwin [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 14:43
To: CF-Talk
Subject: RE: Find position in a list


James,

Try this

cfset list="23,24,27,30,543,675,980"
!--- current_number would be dynamic, right now it's set to 543 ---
cfset current_number=543
cfset position=ListFind(list,current_number)
cfloop list="#list#" index="count"
cfset previous_number=ListGetAt(list,position-1)
cfset next_number=ListGetAt(list,position+1)
/cfloop
cfoutput
Previous Number: #previous_number#br
Current Number: #current_number#br
Next Number: #next_number#
/cfoutput

You will run into problems with the first and last number in the list but
this should give you a start and i'm sure you'll be able to find a
workaround.

Dennis Baldwin

-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 9:28 AM
To: CF-Talk
Subject: Find position in a list


Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Find position in a list

2001-03-23 Thread Dylan Bromby

i don't think this will work because you don't know how long the string
before or after the original substring is. so how would you know what
position to specify for ListGetAt()? that's why i think GetToken() would
work...


-Original Message-
From: Mark Woods [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 6:38 AM
To: CF-Talk
Subject: Re: Find position in a list


use the listFind() and listGetAt() functions

At 02:28 PM 3/23/2001, you wrote:
Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."


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

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



RE: Find position in a list

2001-03-23 Thread Dylan Bromby

heh scratch my last comment, i think it will work...

i'm off to find some coffee...

-Original Message-
From: Mark Woods [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 6:38 AM
To: CF-Talk
Subject: Re: Find position in a list


use the listFind() and listGetAt() functions

At 02:28 PM 3/23/2001, you wrote:
Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."


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

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



RE: Find position in a list

2001-03-23 Thread James Maltby

Thanx guys - solved the problem now!

J

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 14:41
To: CF-Talk
Subject: RE: Find position in a list


You need GetToken() to get the next/previous values once you get the
position of the original substring.

--Dylan

-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 6:34 AM
To: CF-Talk
Subject: RE: Find position in a list




Use listFind(list [, delimiter])

HTH,
Duane

-Original Message-
From: James Maltby [mailto:
Sent: Friday, March 23, 2001 9:28 AM
To: CF-Talk
Subject: Find position in a list


Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re:Find position in a list

2001-03-23 Thread Chris Terrebonne

James,
I am attaching a CFX tag I wrote that will do what you need.  It's called
ListGetChunk and it allows you to extract a portion of a list.
You could use it like this:

cfset MyList = "23,24,27,30,543,675,980"
cfset Start = ListFind(MyList, 543) - 1
cfset Max = 3
cfx_ListGetChunk List="#MyList#" Start="#Start#" Max="#Max#"
NewList="NewList"
!--- NewList would now contain 30,543,675 ---
cfset First = ListFirst(NewList)
cfset Last = ListLast(NewList)

Hope that helps,
Chris

--
Original Message
From: "James Maltby"[EMAIL PROTECTED]
Subject: Find position in a list
Date: Fri, 23 Mar 2001 14:28:16 -

Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."


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

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



RE: Querying NT directory permissions?

2001-03-23 Thread Bob Silverberg

Check out http://www.intrafoundation.com/intranethostingtoolkit.html

I haven't used it, but I think it contains all of the functionality you're
looking for.

Bob

-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: March 23, 2001 9:47 AM
To: CF-Talk
Subject: Querying NT directory permissions?


Hey all,

I apologize in advance if this topic has already been discussed ad nauseum,
but I'm not even sure where to begin looking in the archives for this.(I did
search, but haven't found anything yet to help me out.)

Here's what I need to do. Our department sets up all directories for web
publishers within our company. We have an online form that users fill out to
request web space, and then someone on our team sets it up. We would like to
build an application that will display:

--all of the current web sites (i.e. "folders"),
--all GROUPS that have permission to access the folder,
--all INDIVIDUALS that have permission to access the folder,
--the entire CONTENTS of each folder and any file-level permissions,
--Disk space usage,
--number of files of each type (.doc, .pdf, .xls, etc.)
--Any primary and secondary publishers to the site, as well as associated
passwords (if possible. Of course this is for our team's eyes only!)

We do not want to have to store this information in a database--we want to
pull it right off of the NT box itself. I know I can use CFDIRECTORY to
display the directory contents, and I can find the number of each file type,
but how can I display permissions and disk space? Is that even possible?

Publishers all use FrontPage, so we will have one server for all of the
FrontPage sites, and a completely separate server for all of our CF apps.

If anyone has done something similar I would love to know how you
implemented it.

Thanks!

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

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



RE: CFFILE ACTION=copy and NAMECONFLICT

2001-03-23 Thread Aidan Whitehall

 Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag?

That's what I'd done - added NAMECONFLICT="makeunique" and ColdFurion threw
the error message pasted into the last post.




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

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

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

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



Multiple Inputs (was Re: Textbox validation)

2001-03-23 Thread Jeanne Sarfaty Glazer

Will,

Have you considered treating the textbox string as a list, breaking it apart 
for your query (in your example) "bass" OR "guitar" OR "other list item".  
This way you can allow your users to enter multiple words.  The part I'm not 
sure about is how my example below affects performance (I'm still new to 
things like database tuning)

e.g.

mySearchParams = "Bass Guitar Music"

CFSET SearchLen = ListLen(mySearchParams)
CFSET SearchArr = ListToArray(mySearchParams)
CFSET SeachFormat = ""

CFLOOP FROM="1" TO="#SearchLen#" INDEX="x"
   CFIF SearchFormat EQ ""
   CFSET SearchFormat = "myColName = """  "#SearchArr[x]#"""
   CFELSE
   CFSET SearchFormat = " OR myColName = """  "#SearchArr[x]#"""
   /CFIF
/CFLOOP


CFQUERY ...
SELECT blah1, blah2, blah3
FROM myTable
WHERE #SearchFormat#
/CFQUERY



From: "W Luke" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Textbox validation
Date: Fri, 23 Mar 2001 13:30:28 -

Thanks for all the replies.  The reason I need to prevent more than one 
word
being entered, is I'm finding it impossible to use wildcard filtering using
Access' Instr function (any clues anyone?) - for example, if the search
string contained "Bass Guitar" it would only return True if it *matches* 
it,
and not if it's similar (Like).

Anyways, thanks - going to do what Aidan suggests, and add the Javascript
when I have time.

Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com

  Really the best way is *both*.
  JavaScript is much nicer from a user interface point of view.
  But if the validation is important you need to do it again on
  the server, because you can't guarantee the user has JavaScript
  running in their browser.
 
  Nick
 
  -Original Message-
  From: W Luke [mailto:[EMAIL PROTECTED]]
  Sent: Friday, March 23, 2001 12:39 AM
  To: CF-Talk
  Subject: Textbox validation
 
 
  Hi,
 
  On one textbox I need to prohibit users entering more than one word - I
  don't want them to enter a space.  What's the best way of doing this -
  Javascript, or Cold Fusion after the form has been posted?
 
  Thanks.
 
  Will
  --
  [EMAIL PROTECTED] -=- www.lukrative.com
  Local-Advertising -=- www.localbounty.com
 

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

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



lock problems

2001-03-23 Thread Peter Benoit

I keep seeing this error, and my app seems to freeze from time to time.  Any
ideas what I should look for?



Unable to acquire lock for single threaded sessions within timeout period.

Please raise the request timeout limit to lengthen the time available to
acquire the lock.


My locks all look like this:  CFLOCK TIMEOUT="30" THROWONTIMEOUT="Yes"
TYPE="EXCLUSIVE" SCOPE="SESSION"


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

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



RE: determine if user is active?

2001-03-23 Thread Dylan Bromby

the bank disconnects in 5 minutes? or after 5 minutes of inactivity? seems
odd if it's the former, because you could be in the middle of a transaction.
the meta and onLoad solutions will work like the former (kick in 5 no
matter what) not the latter (kick after no action for 5 minutes).

-Original Message-
From: Ben Dyer [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 6:48 AM
To: CF-Talk
Subject: RE: determine if user is active?


Or even:

meta http-equiv="Refresh" content="300;url=timeout.cfm"

At 07:45 AM 3/23/01, you wrote:
Body onLoad settimeout (5 minutes worth of milliseconds) when that timeout
has been reached have the session end, window close or whatever

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:35 AM
To: CF-Talk
Subject: determine if user is active?


My bank disconnects me after 5 minutes, how can I reproduce this?

-=-=-=-=-=-=-=-=-=-=-=-=-
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
-=-=-=-=-=-=-=-=-=-=-=-=-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Find position in a list

2001-03-23 Thread Dylan Bromby

heh my second post posted first.

how wierd is that.

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 6:51 AM
To: CF-Talk
Subject: RE: Find position in a list


i don't think this will work because you don't know how long the string
before or after the original substring is. so how would you know what
position to specify for ListGetAt()? that's why i think GetToken() would
work...


-Original Message-
From: Mark Woods [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 6:38 AM
To: CF-Talk
Subject: Re: Find position in a list


use the listFind() and listGetAt() functions

At 02:28 PM 3/23/2001, you wrote:
Hi

Let's imagine I've got a list of id numbers and a specific id number within
this list.  How could I output the "next" id number in the list and the
"previous" id number in the list, depending on the id number I have?

e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or
675, then if I get 675 I need to get 543 or 980, etc. etc.

TIA

James

"The Force is strong in this one..."


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

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



Processing Times and Servers Under Load

2001-03-23 Thread Duane Boudreau

In general what kind of cf processing times can a server handle under
moderate load, say in the neighborhood of 50,000 hits a day.

I have been re-writing the front page portal of an ecommerce site and I
think with query caching and some streamlining of code I have it down as far
as I can (320 ms processing time).

Will this stand up to moderate load? What kind of numbers should I be aiming
for?

Duane


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



Re: Help please

2001-03-23 Thread Billy Cravens

Personally, my advice is to learn everything.  That way you can go one way or the 
other.  Makes you available for
multiple jobs, as well as some places that need multiple skills.

At this point and time, most of the work appears to be in ASP, and there's a healthy 
chunk of Perl out there.
Though you don't wait until you need to a job to learn these skills; it's hard to 
learn enough fast enough.  Always
think forwards.

"Suggest a way out"?  McDonald's is always hiring.   :)

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

Venkata Ramakrishna wrote:

 Hi gang,
 Iam a Cf guy since 1.5 years.I changed my company
 expecting a assignment in US.As the market slowed down
 there,my new employer is making me sit at his place.
 The problem is that he don't have any CF work and the
 other teams wont allow me inside their domain.

 Should i stick with CF or change to some other
 domain?Whats the trend at US?
 Can someone suggest a way out until the US markets
 gear up again?

 Expecting some serious suggestions.

 Thank you.

 Ramakrishna

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

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



Re: Boy - here's a dandy Microsoft Security Bulletin MS01-017

2001-03-23 Thread Billy Cravens

Thanks for the heads up Dave, but didn't Microsoft put a moratorium on posting the 
text of Security Updates to
mailing lists?  I seem to recall that this was a big issue with BugTraq.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

Dave Hannum wrote:

 Take note if you go to pages that try to install components so that you can
 view or operate components on the page (such as java applets, etc . . . )

 Dave

 - Original Message -
 From: "Microsoft Product Security" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, March 22, 2001 10:42 AM
 Subject: Microsoft Security Bulletin MS01-017

 The following is a Security  Bulletin from the Microsoft Product Security
 Notification Service.

 Please do not  reply to this message,  as it was sent  from an unattended
 mailbox.
 

 -BEGIN PGP SIGNED MESSAGE-

 - --
 Title:  Erroneous VeriSign-Issued Digital Certificates Pose
 Spoofing Hazard
 Date:   22 March 2001
 Software:   All Microsoft customers should read the bulletin.
 Impact: Attacker could digitally sign code using the name
 "Microsoft Corporation".
 Bulletin:   MS01-017

 Microsoft encourages customers to review the Security Bulletin at:
 http://www.microsoft.com/technet/security/bulletin/MS01-017.asp.
 - --

 Issue:
 ==
 VeriSign, Inc., recently advised Microsoft that on January 30 and 31,
 2001, it issued two VeriSign Class 3 code-signing digital
 certificates to an individual who fraudulently claimed to be a
 Microsoft employee. The common name assigned to both certificates is
 "Microsoft Corporation". The ability to sign executable content using
 keys that purport to belong to Microsoft would clearly be
 advantageous to an attacker who wished to convince users to allow the
 content to run.
 The certificates could be used to sign programs, ActiveX controls,
 Office macros, and other executable content. Of these, signed ActiveX
 controls and Office macros would pose the greatest risk, because the
 attack scenarios involving them would be the most straightforward.
 Both ActiveX controls and Word documents can be delivered via either
 web pages or HTML mails. ActiveX controls can be automatically
 invoked via script, and Word documents can be automatically opened
 via script unless the user has applied the Office Document Open
 Confirmation Tool.

 However, even though the certificates say they are owned by
 Microsoft, they are not bona fide Microsoft certificates, and content
 signed by them would not be trusted by default. Trust is defined on a
 certificate-by-certificate basis, rather than on the basis of the
 common name. As a result, a warning dialogue would be displayed
 before any of the signed content could be executed, even if the user
 had previously agreed to trust other certificates with the common
 name "Microsoft Corporation". The danger, of course, is that even a
 security-conscious user might agree to let the content execute, and
 might agree to always trust the bogus certificates.

 VeriSign has revoked the certificates, and they are listed in
 VeriSign's current Certificate Revocation List (CRL). However,
 because VeriSign's code-signing certificates do not specify a CRL
 Distribution Point (CDP), it is not possible for any browser's
 CRL-checking mechanism to download the VeriSign CRL and use it.
 Microsoft is developing an update that rectifies this problem. The
 update package includes a CRL containing the two certificates, and an
 installable revocation handler that consults the CRL on the local
 machine, rather than attempting to use the CDP mechanism.

 Versions of the update are being prepared for all Microsoft platforms
 released since 1995. However, because of the large number of
 platforms that must be tested, the patches are not available at this
 writing. Until the update is available, we urge customers to take
 some or all of the following steps to protect themselves should they
 encounter hostile code signed by one of the certificates.
  - Visually inspect the certificates cited in all warning
dialogues. The two certificates at issue here were issued
on 29 and 30 January 2001, respectively. No bona fide
Microsoft certificates were issued on these dates. The
FAQ and Knowledge Base article Q293817 provide complete
details regarding both certificates.
  - Install the Outlook Email Security Update
(http://www.officeupdate.com/2000/downloadDetails/Out2ksec.htm)
to prevent mail-borne programs from being launched, even via
signed components, and install the Office Document Open
Confirmation Tool
(http://officeupdate.microsoft.com/downloadDetails/confirm.htm)
to force web pages to request permission before opening Office
documents.
  - Consider temporarily removing the 

Re: Form Submission -- Revisited (UltraDev 4)

2001-03-23 Thread Billy Cravens

Your talking apples and oranges.  FrontPage has some proprietary scripts that run on 
the server that handle things
like confirmation pages, email functionality, etc.  UD4/ColdFusion do not come with 
this.  You develop the logic
yourself.

Of course UltraDev comes with server behaviors, as well as giving you the ability to 
add or create additional
ones.  I do not recall this being a default behavior; perhaps someone has put one on 
the Ultradev Developer's
Exchange.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

James Taavon wrote:

 Hey Everyone!

 I posted a message a little while back regarding submission forms in
 Dreamweaver. Let me ask the same again, but using UltraDev 4.

 I used to create forms in submission forms FrontPage and use the Form
 properties to assign a confirmation page, tell what fields to save a
 send the info in the form of an email. Know what I mean?

 Anyway, can I duplicate that same functionality in UltraDev or do I need
 to link the form to an external cgi script to perform the desired
 action.

 James


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

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



RE: determine if user is active?

2001-03-23 Thread Peter Benoit

Yes, it's when I'm inactive they prompt me with a "You better do something
or we'll kick you off" type of message.

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 10:13 AM
To: CF-Talk
Subject: RE: determine if user is active?


the bank disconnects in 5 minutes? or after 5 minutes of inactivity? seems
odd if it's the former, because you could be in the middle of a transaction.
the meta and onLoad solutions will work like the former (kick in 5 no
matter what) not the latter (kick after no action for 5 minutes).

-Original Message-
From: Ben Dyer [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 6:48 AM
To: CF-Talk
Subject: RE: determine if user is active?


Or even:

meta http-equiv="Refresh" content="300;url=timeout.cfm"

At 07:45 AM 3/23/01, you wrote:
Body onLoad settimeout (5 minutes worth of milliseconds) when that timeout
has been reached have the session end, window close or whatever

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:35 AM
To: CF-Talk
Subject: determine if user is active?


My bank disconnects me after 5 minutes, how can I reproduce this?

-=-=-=-=-=-=-=-=-=-=-=-=-
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
-=-=-=-=-=-=-=-=-=-=-=-=-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: cfscheduler weird thing...

2001-03-23 Thread Mark Woods

Are you sure this is the case, this seems very, very strange.

I don't think I've ever needed to schedule a http request on Windows that 
connected to a port other than 80, but I have on linux without any difficulty.

The problems I have experienced with CF scheduling are generally with the 
CFSCHEDULE tag, not ColdFusion scheduling in general. Scheduled tasks added 
using the administrator run fine while tasks added/updated using the tag 
simply don't run (though you can run scheduled tasks using CFSCHEDULE). 
Behaviour is not consistent, or I haven't done enough testing to determine 
a definite pattern, though if I recall correctly, restarting the server did 
result in the scheduled tasks set using CFSCHEUDLE running fine. I can't 
remember whether restarting the CF Executive or CF App Server services had 
the same result. To be honest I don't have time to beta test allaire's 
software. There have been complaints about CFSCHEDULE since v3, and it 
still doesn't work reliably, so I just don't use it.


Mark


At 01:04 PM 3/23/2001, you wrote:
 From past experience with CFSchedule, make sure the
website/template that is being called
(ie, http://mywebsite.com/check_this.cfm )
is not located on an non-standard port.

Meaning the template should be able to be called
from a normal HTTP Request.

If it is behind an obscure port such as:
http://mywebsite.com:8088/check_this.cfm
This will not work.

Hopefully this is addressed in CF 5.0 but not
the case in 4.01 or 4.5

Hope this helps.
Randy

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 7:31 AM
To: CF-Talk
Subject: RE: cfscheduler weird thing...


  coldfusion scheduling is notoriuosly unreliable.

Does anyone know if this is going to be addressed in ColdFusion 5.0?

I've *never* managed to get a scheduled event to work and have to resort to
other applications which trigger batch files to open a browser and pass it a
URL as a parameter... pain!


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

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

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

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



RE: Any LDAP Guru's here? Authentication Problem

2001-03-23 Thread Top-Link Tech (John Ceci)

Michael,

Could you go a little more indepth, I am working with LDAP for the first
time and just can't quite get IT...

I can pull a user from the LDAP server, I can search and return multiple
results...I can't seem to get what a successful login is...

Is it that I get a empty recordset (which is what is happening now) or is it
that I get the user record back???

Thanks,
John

-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 9:15 AM
To: CF-Talk
Subject: Re: Any LDAP Guru's here? Authentication Problem


Once you get the full user context.  Do another query/or your first query,
supply that(the full context) in the username field, and the password in the
password field.  CFldap does the rest.  If you get an error the
username/password isn't right.  If nothing happens it was right and they
have authenticated.

 [EMAIL PROTECTED] 03/23/01 09:50AM 


speaking of this, how does one 'authenticate'?  I'm having trouble
getting this to work.
Do I

cfldap  once anonymously to get the userid based on user inputed
info
then
cfldap again with userid and password supplied this time.  If
cfldap pulls back a record, then authentication happend, correct?
I'm told passwords are generally SHA1 hashed in LDAP directories, does
CFLDAP do the hashing?


-
Douglas Knudsen
Leveraged Technologies Group
Alltel AIS
678-351-6063
Got Linux? http://linuxmall.com




From: [EMAIL PROTECTED] AT INTERNET on 03/23/2001 09:27 AM

To:   Douglas Knudsen/ATL/ALLTELCORP, [EMAIL PROTECTED] AT
  INTERNET@CCMAIL
cc:

Subject:  Re: Any LDAP Guru's here? Authentication Problem


Initally I would say no.  Point your cfldap to an ip of the ldap
server.  Will y
ou need to authenticate to both servers?  Neither tree can see each
other can th
ey?  If one of the servers can give you access to all the users
context thats al
l your should
need.  If you need to authenticate to both do the first query with
the first IP
do a user search then do the second query with the second server.
Once you fin
d the user context make sure you authenticate to the right ip.

 [EMAIL PROTECTED] 03/23/01 07:51AM 
quick question.
i want to use NDS  LDAP to authenticate ALL the users of our
intranet.
my problem that there are 2 servers.
both have the same tree name?

will this cause me problems.
if so is there a way around it?

any ideas would be great

-paul

Web Developer, NBBJ
Work: [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

Home: [EMAIL PROTECTED]
614 449-1681

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

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



RE: Help please

2001-03-23 Thread Jason Lees (National Express)


Dont just stick to Web based tools, get to grips with conventional
programming languages as well, such as VB, C++, JAVA. and others.

Even if its just a matter of installing a standard edition of the software
and getting to grips with the syntax and format and quirks of the language.

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 15:33
To: CF-Talk
Subject: Re: Help please


Personally, my advice is to learn everything.  That way you can go one way
or the other.  Makes you available for
multiple jobs, as well as some places that need multiple skills.

At this point and time, most of the work appears to be in ASP, and there's a
healthy chunk of Perl out there.
Though you don't wait until you need to a job to learn these skills; it's
hard to learn enough fast enough.  Always
think forwards.

"Suggest a way out"?  McDonald's is always hiring.   :)

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

Venkata Ramakrishna wrote:

 Hi gang,
 Iam a Cf guy since 1.5 years.I changed my company
 expecting a assignment in US.As the market slowed down
 there,my new employer is making me sit at his place.
 The problem is that he don't have any CF work and the
 other teams wont allow me inside their domain.

 Should i stick with CF or change to some other
 domain?Whats the trend at US?
 Can someone suggest a way out until the US markets
 gear up again?

 Expecting some serious suggestions.

 Thank you.

 Ramakrishna

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

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



Regular expression Help

2001-03-23 Thread Mallory Woods

Greetings All,

I am in the process of developing a small headache with Regular
Expressions...

I have looked at all of the examples I could find on the archives of this
mailing list and other web
pages but I still just don't get it.. I think I will pickup the O'Reilly
book that I have seen at another job before
on regular expressions but for now I am asking the list for help..

What I am trying to do is parse through an HTML source page an look for a
specfic string.. for example..

meta name="pubdate" content="Fri, 23 Mar 2001 07:00:00 GMT"

I would like to grab everything from this string from " to GMT"

Thanks in Advance...

Mallory Woods



This email and any files transmitted with it are confidential and are intended solely 
for the use of the individual or entity to which they are addressed.  If you are not 
the intended recipient or the person responsible for delivering the email to the 
intended recipient, be advised that you have received this email and any such files in 
error and that any use, dissemination, forwarding, printing or copying of this email 
and/or any such files is strictly prohibited.  If you have received this email in 
error please immediately notify [EMAIL PROTECTED] and destroy the original message 
and any such files.

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

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



RE: cfscheduler weird thing...

2001-03-23 Thread Mark Woods

At 03:22 PM 3/23/2001, you wrote:
  err, there's no need to do that. There is an executable you
  can use to
  process CFML templates via the command line. Have a look at:
  http://www.allaire.com/Handlers/index.cfm?ID=3328Method=Full

Thanks. I don't want to sound ungrateful, but with several ColdFusion
servers, presumably what they suggest would mean setting up an instance of
the scheduled event software on each.


Well, that depends on what your scheduled task does. To be honest I can't 
think of a situation where a scheduled task would do something which 
affects multiple servers which could not be achieved by running tasks on 
one server. Then again, it is Friday afternoon and my brain is 
concentrating on coming up with the fastest route to the pub through 
Dublin's nasty traffic jams.



The way it is at the moment, there's a load of open IE windows when I get
into work but at least all the scheduled events are managed from one place.



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

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


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

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



Finding a space in a string..

2001-03-23 Thread Angél Stewart

Hi dee ho all,

Would this find a space in a string?

CFSET pos= #Find(Chr(20),'tempdefendant')#

Because..it ain't working for some reason.
I also tried 

CFSET pos= #Find(' ','tempdefendant')#

BUt that results in POS being 0 all the time.

-Gel


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

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



Passing query back to page through caller in custom tag

2001-03-23 Thread David Caplan

I am trying to write a custom tag that will perform a generic select and
bring back a query to the page. Has anyone had any experience passing a
query structure back to the page through the caller variable? I am having
trouble with this. I also experimented briefly with looping through the
query passing the values to a struct and then passing that struct back to
the caller (couldn't get that to work either). It also seemed like it was
not worth it in terms of overhead if I had to loop through the query and
make a call to the database.

If you could email the list and me directly I would appreciate it, I am in
digest mode.

Thanks,

David Caplan

36 w 20 st  |  nyc 10011  |  212.929.7644  Ext.136  | www.fusebox.com  |



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



Re: Regular expression Help

2001-03-23 Thread Savan Thongvanh



OT:  are there any statistics on how many developers regexp has made bald?



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

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



crystal report report

2001-03-23 Thread Chang Liu

Hi all,

here is my code:

CFREPORT REPORT="Report1.rpt"
{Class.Class_ID} = "3"
/CFREPORT

here is my Error Diagnostic Information:

Report not completed (the report server was busy) 


The requested report could not be completed because the server was extremely busy 
serving other report requests. Please notify the site administrator that the default 
TIMEOUT for the report server should be increased. 

any ideas?

thanks a lot!












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

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



Re: Regular expression Help

2001-03-23 Thread Larry W. Virden

Re: use of regular expressions for parsing html

One can reliably use regular expressions to parse html if it is 
html that you have direct and full editorial control over.
That is, if you hand edit the html, AND you can keep all your 
requirements in mind, then you can use with some success regular 
expressions to parse html.

Otherwise, if you are trying to parse pages from the net, you can 
be pretty certain to run into serious stumbling blocks (ie the 
perverse things people and applications do in the name of writing 
or generating html).

For instance, if I knew that the meta tag would _always_ be the 
format you described, I use a regular expression like
content="([^"]*)"
and know that the stuff between the parens would be what I 
wanted.

However, I see html all the time that adds newlines arbitrarily 
at white space... which means that you have to somehow make 
certain that you know where to stop parsing...

-- 
Larry W. Virden URL: mailto:[EMAIL PROTECTED] 
URL: http://www.purl.org/net/lvirden/
Even if explicitly stated to the contrary, nothing in this 
posting
should be construed as representing my employer's opinions.



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

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



pdf merging?

2001-03-23 Thread Nathan Stanford

I know how to create a dynamic pdf however how do you merge several pdf's
into the same document so the user can print the documents just once?  

Thanks,
Nathan

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

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



RE: CFFILE ACTION=copy and NAMECONFLICT

2001-03-23 Thread Hayes, David

I believe you'll have to check for the existence of the file name using
CFDIRECTORY first.

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 9:08 AM
To: CF-Talk
Subject: RE: CFFILE ACTION="copy" and NAMECONFLICT


 Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag?

That's what I'd done - added NAMECONFLICT="makeunique" and ColdFurion threw
the error message pasted into the last post.




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

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: Finding a space in a string..

2001-03-23 Thread Jon Hall

Try ASCII 32. That is the space character.

jon
- Original Message -
From: "Angél Stewart" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 11:27 AM
Subject: Finding a space in a string..


 Hi dee ho all,

 Would this find a space in a string?

 CFSET pos= #Find(Chr(20),'tempdefendant')#

 Because..it ain't working for some reason.
 I also tried

 CFSET pos= #Find(' ','tempdefendant')#

 BUt that results in POS being 0 all the time.

 -Gel



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

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



RE: Finding a space in a string..

2001-03-23 Thread Duane Boudreau

The following returns 8 in cf 4.5.1

cfset x = Find(" ", "tempdef endant")

Duane

-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 11:27 AM
To: CF-Talk
Subject: Finding a space in a string..


Hi dee ho all,

Would this find a space in a string?

CFSET pos= #Find(Chr(20),'tempdefendant')#

Because..it ain't working for some reason.
I also tried

CFSET pos= #Find(' ','tempdefendant')#

BUt that results in POS being 0 all the time.

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

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



RE: Finding a space in a string..

2001-03-23 Thread Garza, Jeff

Try CFSET pos = Find(" ",tempdefendant, "1")

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

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



-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 23, 2001 9:27 AM
To: CF-Talk
Subject: Finding a space in a string..


Hi dee ho all,

Would this find a space in a string?

CFSET pos= #Find(Chr(20),'tempdefendant')#

Because..it ain't working for some reason.
I also tried 

CFSET pos= #Find(' ','tempdefendant')#

BUt that results in POS being 0 all the time.

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

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



RE: cfscheduler weird thing...

2001-03-23 Thread Aidan Whitehall

 Well, that depends on what your scheduled task does. To be 
 honest I can't think of a situation where a scheduled task would
 do something which affects multiple servers which could not be
 achieved by running tasks on one server.

Maybe I read the Allaire article wrong, but I assumed that if you want to
use the method they suggest (calling the executable and passing it
parameters), you would have to reference the physical path to the template
you wanted to run, ie D:\Inetpub\wwwroot\directory\file.cfm.

With several servers and a range of sites on each, I assumed you'd have to
set up the scheduling software on each machine that had a site for which you
wanted to run a scheduled event (...if that made any sense whatsoever!).


And ditto about that Friday-feeling   *uggh*

"I can almost feel my neural transmitters shutting down." (C  H -
Watterson)


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

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

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

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



RE: Regular expression Help

2001-03-23 Thread Hayes, David

This works.

CFSET theString = "meta name=""pubdate"" content=""Fri, 23 Mar 2001
07:00:00 GMT"""
CFSET st = reFindNoCase("(content="")(.*)(GMT"")",theString,1,"TRUE")
CFOUTPUT#mid(theString,st.pos[3],st.len[3])#/CFOUTPUT


The two pieces are:

1) Creating the regularExpression

2) understanding the use of the "return subexpressions" attribute of reFind;
check the documentation.  I learned something just now about using it with a
paren-ed regular expression.


-Original Message-
From: Mallory Woods [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 10:17 AM
To: CF-Talk
Subject: Regular expression Help


Greetings All,

I am in the process of developing a small headache with Regular
Expressions...

I have looked at all of the examples I could find on the archives of this
mailing list and other web
pages but I still just don't get it.. I think I will pickup the O'Reilly
book that I have seen at another job before
on regular expressions but for now I am asking the list for help..

What I am trying to do is parse through an HTML source page an look for a
specfic string.. for example..

meta name="pubdate" content="Fri, 23 Mar 2001 07:00:00 GMT"

I would like to grab everything from this string from " to GMT"

Thanks in Advance...

Mallory Woods



This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to which they are
addressed.  If you are not the intended recipient or the person responsible
for delivering the email to the intended recipient, be advised that you have
received this email and any such files in error and that any use,
dissemination, forwarding, printing or copying of this email and/or any such
files is strictly prohibited.  If you have received this email in error
please immediately notify [EMAIL PROTECTED] and destroy the original
message and any such files.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: CFFILE ACTION=copy and NAMECONFLICT

2001-03-23 Thread Aidan Whitehall

 Nameconflict is only used when action=upload.

Thanks.

So if you're trying to copy a file into a directory that already has a file
of that name, how can you specify what action to take? Doesn't it makes
sense to be able to provide a NAMECONFLICT attribute for that eventuality?

BTW, that was more of a rhetorical question aimed at Allaire...



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

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

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

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



Crystal Reports Version?

2001-03-23 Thread Richard Colman

Does CR 8.5 work ok with CF 4.51? If not, what version works? TNX for any
comments.

Rick Colman


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

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



RE: crystal report report

2001-03-23 Thread Braver, Ben

I get this periodically due apparently to a memory leak in an ODBC driver or
something.
What solves it immediately is stopping and restarting the CF services.

There was a cf-talk thread on Wed. 3/21: Stopping/starting CF with NT "AT"
that addressed doing this automatically with CF running on NT or Win2K.

HTH.

Ben

-Original Message-
From: Chang Liu [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:50 AM
To: CF-Talk
Subject: crystal report report


Hi all,

here is my code:

CFREPORT REPORT="Report1.rpt"
{Class.Class_ID} = "3"
/CFREPORT

here is my Error Diagnostic Information:

Report not completed (the report server was busy) 


The requested report could not be completed because the server was extremely
busy serving other report requests. Please notify the site administrator
that the default TIMEOUT for the report server should be increased. 

any ideas?

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

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



RE: Regular expression Help

2001-03-23 Thread Douglas Malcolm

Mallory,

Try this:

cfset newVar=REFind(varWithHTML,'meta name="pubdate"[^]+')

That should return the string;
meta name="pubdate" content="[some date]"

Which you can then extract the date from.

Good luck!

Douglas Malcolm


-Original Message-
From: Mallory Woods [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:17 AM
To: CF-Talk
Subject: Regular expression Help


Greetings All,

I am in the process of developing a small headache with Regular
Expressions...

I have looked at all of the examples I could find on the archives of this
mailing list and other web
pages but I still just don't get it.. I think I will pickup the O'Reilly
book that I have seen at another job before
on regular expressions but for now I am asking the list for help..

What I am trying to do is parse through an HTML source page an look for a
specfic string.. for example..

meta name="pubdate" content="Fri, 23 Mar 2001 07:00:00 GMT"

I would like to grab everything from this string from " to GMT"

Thanks in Advance...

Mallory Woods



This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to which they are
addressed.  If you are not the intended recipient or the person responsible
for delivering the email to the intended recipient, be advised that you have
received this email and any such files in error and that any use,
dissemination, forwarding, printing or copying of this email and/or any such
files is strictly prohibited.  If you have received this email in error
please immediately notify [EMAIL PROTECTED] and destroy the original
message and any such files.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: Multiple Inputs (Fixed a Mistake!)

2001-03-23 Thread Jeanne Sarfaty Glazer

Oops - that's what I get for writing code on the fly.  Try this instead:

!--- mySearchParans is just an example of a possible search string ---
CFSET mySearchParams = "Guitar Case and string"

CFSET SearchArr = ListToArray(mySearchParams, " ")
CFSET SearchLen = ArrayLen(SearchArr)
CFSET SearchFormat = "null"
CFOUTPUTLen:#SearchLen#/CFOUTPUT

CFLOOP FROM="1" TO="#SearchLen#" INDEX="x"
   CFIF SearchFormat EQ "null"
   CFSET SearchFormat = "myColName = """  "#SearchArr[x]#"""
   CFELSE
   CFSET SearchFormat = "#SearchFormat#"  " OR myColName = """  
"#SearchArr[x]#"""
   /CFIF
/CFLOOP


CFQUERY ...
   SELECT blah1, blah2, blah3
   FROM myTable
   WHERE #SearchFormat#
/CFQUERY


From: "Jeanne Sarfaty Glazer" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Multiple Inputs (was Re: Textbox validation)
Date: Fri, 23 Mar 2001 10:09:49 -0500

Will,

Have you considered treating the textbox string as a list, breaking it 
apart
for your query (in your example) "bass" OR "guitar" OR "other list item".
This way you can allow your users to enter multiple words.  The part I'm 
not
sure about is how my example below affects performance (I'm still new to
things like database tuning)

e.g.

mySearchParams = "Bass Guitar Music"

CFSET SearchLen = ListLen(mySearchParams)
CFSET SearchArr = ListToArray(mySearchParams)
CFSET SeachFormat = ""

CFLOOP FROM="1" TO="#SearchLen#" INDEX="x"
CFIF SearchFormat EQ ""
CFSET SearchFormat = "myColName = """  "#SearchArr[x]#"""
CFELSE
CFSET SearchFormat = " OR myColName = """  "#SearchArr[x]#"""
/CFIF
/CFLOOP


CFQUERY ...
SELECT blah1, blah2, blah3
FROM myTable
WHERE #SearchFormat#
/CFQUERY



 From: "W Luke" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: Re: Textbox validation
 Date: Fri, 23 Mar 2001 13:30:28 -
 
 Thanks for all the replies.  The reason I need to prevent more than one
 word
 being entered, is I'm finding it impossible to use wildcard filtering 
using
 Access' Instr function (any clues anyone?) - for example, if the search
 string contained "Bass Guitar" it would only return True if it *matches*
 it,
 and not if it's similar (Like).
 
 Anyways, thanks - going to do what Aidan suggests, and add the Javascript
 when I have time.
 
 Will
 --
 [EMAIL PROTECTED] -=- www.lukrative.com
 Local-Advertising -=- www.localbounty.com
 
   Really the best way is *both*.
   JavaScript is much nicer from a user interface point of view.
   But if the validation is important you need to do it again on
   the server, because you can't guarantee the user has JavaScript
   running in their browser.
  
   Nick
  
   -Original Message-
   From: W Luke [mailto:[EMAIL PROTECTED]]
   Sent: Friday, March 23, 2001 12:39 AM
   To: CF-Talk
   Subject: Textbox validation
  
  
   Hi,
  
   On one textbox I need to prohibit users entering more than one word - 
I
   don't want them to enter a space.  What's the best way of doing this -
   Javascript, or Cold Fusion after the form has been posted?
  
   Thanks.
  
   Will
   --
   [EMAIL PROTECTED] -=- www.lukrative.com
   Local-Advertising -=- www.localbounty.com
  
 

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

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



RE: Help with SQL statement

2001-03-23 Thread Russ Conway

 I'm doing a select from three tables, and my query is timing out.  The
 problem is probably coming from the fact that there is not always a
 record in the m.POS_ARC_HEADX table.  Is there a way to restructure this
 query so it still checks the m.POS_ARC_HEADX but does not die if no
 record exists?  Is there another reason this query might be dying?

 cfquery name="InvoiceDetail" datasource="triad.udd" dbtype="ODBC"
 SELECT  m.POS_ARC_HEAD.DocNo, m.POS_ARC_HEAD.CrName,
 m.POS_ARC_SKU.SKU,
 m.POS_ARC_SKU.Description, m.POS_ARC_HEADX.PersonAuthToCharge

 FROM m.POS_ARC_HEAD, m.POS_ARC_HEADX, m.POS_ARC_SKU

 WHERE   m.POS_ARC_HEAD.DocNo = m.POS_ARC_HEADX.DocNo AND
m.POS_ARC_HEADX.DocNo = m.POS_ARC_SKU.DocNo
  AND m.POS_ARC_HEADX.DocNo =
 "#URL.RetrieveDoc#"
 /cfquery

You can handle the missing records in the POS_ARC_HEADX table by using an
outer join. The syntax varies a little depending on what database you are
using, so I'd suggest checking the SQL help that comes with the database.
You may want to change the second WHERE condition to join to the
POS_ARC_HEAD table instead of the POS_ARC_HEADX, unless you intend to
exclude records that may be in POS_ARC_SKU but are not in POS_ARC_HEADX.

As far as the query timing out, the query will run a lot faster if you have
an index on the DocNo field in all three tables. Depending on the size of
the tables that may make a big difference.


Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (646) 638-3444
http://www.hallofsports.com
.. . . where the legends live on



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

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



RE: Finding a space in a string..

2001-03-23 Thread Craig Dudley

use a regular expression

off the top of my head try

CFSET pos= RedFind("[[:Space:]]","#tempdefendant#")

Syntax cold be wrong, but it's not far off, look in the help on refind() to
get it exact.

-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 16:27
To: CF-Talk
Subject: Finding a space in a string..


Hi dee ho all,

Would this find a space in a string?

CFSET pos= #Find(Chr(20),'tempdefendant')#

Because..it ain't working for some reason.
I also tried 

CFSET pos= #Find(' ','tempdefendant')#

BUt that results in POS being 0 all the time.

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

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



RE: Finding a space in a string..

2001-03-23 Thread James McCullough

I am assuming that tempdefendant is a variable however this statement will
read it as a string. Since there is no space in tempdefendant as a string
you will get a zero.
Do this instead.

CFSET pos=Find(" ","#tempdefendant#")

-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:27 AM
To: CF-Talk
Subject: Finding a space in a string..


Hi dee ho all,

Would this find a space in a string?

CFSET pos= #Find(Chr(20),'tempdefendant')#

Because..it ain't working for some reason.
I also tried

CFSET pos= #Find(' ','tempdefendant')#

BUt that results in POS being 0 all the time.

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

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



Re: pdf merging?

2001-03-23 Thread Stephen M Aylor

www.activepdf.com  PDF Server Toolkit

www.digapp.com  (AppendPDF)

www.pdflib.com - i beleive the latest incarnation/beta of this lib supports
FLAT pdf merging

Steve

- Original Message -
From: "Nathan Stanford" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 8:40 AM
Subject: pdf merging?


 I know how to create a dynamic pdf however how do you merge several pdf's
 into the same document so the user can print the documents just once?

 Thanks,
 Nathan


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

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



RE: Finding a space in a string..

2001-03-23 Thread C. Hatton Humphrey

If I remember correctly, the way you've got that statement Find function is
looking for a space in the string 'tempdefendant', which will always be 0.

Try taking the quote marks off of tempdefendant, like so:

CFSET pos= #Find(' ',tempdefendant)#

HTH
Hatton

  Hi dee ho all,
 
  Would this find a space in a string?
 
  CFSET pos= #Find(Chr(20),'tempdefendant')#
 
  Because..it ain't working for some reason.
  I also tried
 
  CFSET pos= #Find(' ','tempdefendant')#
 
  BUt that results in POS being 0 all the time.
 
  -Gel
 
 
 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: CFFILE ACTION=copy and NAMECONFLICT

2001-03-23 Thread Chad Gray

you cannot use NAMECONFLICT with the Copy Action.  You can only use it with 
the Upload Action.

If you have to use the copy action your going to have to create more logic 
to figure out if the file has the same name.

This will be a combination of CFDIRECTORY, CFFILE, and some CFIF statements.


At 10:51 AM 3/23/01 -0600, you wrote:
I believe you'll have to check for the existence of the file name using
CFDIRECTORY first.

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 9:08 AM
To: CF-Talk
Subject: RE: CFFILE ACTION="copy" and NAMECONFLICT


  Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag?

That's what I'd done - added NAMECONFLICT="makeunique" and ColdFurion threw
the error message pasted into the last post.




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

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


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

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



Why wont this advance to the next record

2001-03-23 Thread Michael

Appreciate it someone could tell me why this wont advance to the next
record,  keep getting 404 error object not found

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"

cfparam name="firstrow" default="1"
CFIF IsDefined("URL.first")
cfset firstrow = url.first
/CFIF
Cfset startnextpage = Firstrow + 1

CFPARAM Name="ID" Default=1
HTML
HEAD


cfquery name="selectcandidate" datasource="interview" dbtype="ODBC"
SELECT  ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
FROMinterview
WHERE ID=#ID#
/cfquery

TITLEInterview Candidates/TITLE
/HEAD

BODY bgcolor="6699ff"
!--- include toolbar.cfm---
cfinclude template="Toolbar.cfm"

cfoutput query="Selectcandidate" startrow="#firstrow#" maxrows="1"
table cellpadding="10"
tr
 tdID/tdbr
 td#id#/tdbr
/tr
tr
 tdCandidate Name/tdbr
 td#EmpCandidate#/tdbr
/tr
tr
 tdSkill Background/td
 td#SKillBackground#/td
/tr
tr
 tdStatus/td
 td#Status#/td
/tr
tr
 tdRecruiter/td
 td#Recruiter#/td
/tr
/table
BRBR
a href="cfoutput-default2.cfm?First=#StartNextPage#"Next Record/a
/cfoutput
/body

Thank You



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

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



RE: CFFILE ACTION=copy and NAMECONFLICT

2001-03-23 Thread Aidan Whitehall

 I believe you'll have to check for the existence of the file 
 name using
 CFDIRECTORY first.

doh! of course...

thanks  *sheepish look*


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

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

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

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



Re: pdf merging?

2001-03-23 Thread Tim Painter

Nathan,

Sometime ago, I remember seeing a toolkit on activepdf.com that allowed you
to merge pdf's together.  I never got a chance to use it, but I do remember
seeing some CF examples for it as well.

HTH,
Tim Painter
- Original Message -
From: "Nathan Stanford" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 11:40 AM
Subject: pdf merging?


 I know how to create a dynamic pdf however how do you merge several pdf's
 into the same document so the user can print the documents just once?

 Thanks,
 Nathan


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

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



RE: Finding a space in a string..

2001-03-23 Thread Hayes, David

Take the quotes off of tempdefendant; it's checking the string (which
doesn't have any spaces) rather than a variable.

-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 10:27 AM
To: CF-Talk
Subject: Finding a space in a string..


Hi dee ho all,

Would this find a space in a string?

CFSET pos= #Find(Chr(20),'tempdefendant')#

Because..it ain't working for some reason.
I also tried 

CFSET pos= #Find(' ','tempdefendant')#

BUt that results in POS being 0 all the time.

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

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



Re: crystal report report

2001-03-23 Thread Chang Liu

Ben,
Thank you very much!

- Original Message -
From: "Braver, Ben" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 12:03 PM
Subject: RE: crystal report report


 I get this periodically due apparently to a memory leak in an ODBC driver
or
 something.
 What solves it immediately is stopping and restarting the CF services.

 There was a cf-talk thread on Wed. 3/21: Stopping/starting CF with NT "AT"
 that addressed doing this automatically with CF running on NT or Win2K.

 HTH.

 Ben

 -Original Message-
 From: Chang Liu [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 23, 2001 8:50 AM
 To: CF-Talk
 Subject: crystal report report


 Hi all,

 here is my code:

 CFREPORT REPORT="Report1.rpt"
 {Class.Class_ID} = "3"
 /CFREPORT

 here is my Error Diagnostic Information:

 Report not completed (the report server was busy)


 The requested report could not be completed because the server was
extremely
 busy serving other report requests. Please notify the site administrator
 that the default TIMEOUT for the report server should be increased.

 any ideas?

 thanks a lot!

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

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



OT: Northpoint DSL shutting down all operations

2001-03-23 Thread Judith Campbell

If any of you have DSL connections to the net, you should aware that 
Northpoint, one of the primary backbone DSL providers is shutting down all 
operations effective immediately.

Even if they are not your primary vendor, there is a good change they are 
the supplier to your vendor, so you should check.

http://www.northpointcom.com/


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

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



OT: freelance board

2001-03-23 Thread Chris Alvarado

a while back someone posted a link to a site where you can go to bid on
public contracts for development etc.

Happen to remember the URL?

thanks,

-chris.alvarado
[developer] - VerticalNet




This message is intended only for the use of the Addressee(s) and may
contain information that is PRIVILEGED and CONFIDENTIAL. If you are not
the intended recipient, dissemination of this communication is prohibited.
If you have received this communication in error, please erase all copies
of the message and its attachments and notify [EMAIL PROTECTED]
immediately.



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

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



Very, very, very bad day

2001-03-23 Thread Phoeun Pha

Hey all, early this morning, I was working on project A.  I needed a
javascript image roll over template so I opened up an FTP from another
project (which we'll call project B) i did way back, and downloaded the
template.  I was using FTP explorer to do this.  I worked a few more hours,
then set an alarm to wake myself up so I can FTP Project A to the hosting
computer.

When I woke up, there was no alarm, i guess i didn't set it right, and i was
VERY late for work, so i rushed and dragged Project A's files into the FTP
explorer, not realizing that it was connected to the Project B's site, not
Project A.  I screamed as I tried to press cancel.  The index files have
been replaced, and so have the images, because I used the same naming scheme

now, i suck.



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

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



Database Images

2001-03-23 Thread Brad Squires

This is a multi-part message in MIME format.

--=_NextPart_000_0002_01C0B382.A20C2840
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

When you store an image in the database, how do you go about displaying it
on the HTML page? Right now, I am simply storing the URL in the DB to the
image file on the hard drive, but looking to storing them in the actual SQL
Server dataabase as another solution. I just wanted to find out how one
would go about doing this and get any feedback from those who have used this
technique.

Brad Squires


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

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR/HEAD
BODY
DIVFONT face=3DArial size=3D2SPAN class=3D250591518-23032001When =
you store an=20
image in the database, how do you go about displaying it on the HTML =
page? Right=20
now, Inbsp;am simply storing the URL in the DB to the image file on the =
hard=20
drive, but looking to storing them in the actual SQL Server dataabase as =
another=20
solution. I just wanted to find out how one would go about doing this =
and get=20
any feedback from those who have used this =
technique./SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D250591518-23032001/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D250591518-23032001Brad=20
Squires/SPAN/FONT/DIV
DIVnbsp;/DIV/BODY/HTML

--=_NextPart_000_0002_01C0B382.A20C2840--


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



  1   2   >