server: ntConsoleJava.e

[Mark Terrill]

This is a multi-part message in MIME format.

--=_NextPart_000_0033_01C0FA76.538B58E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

Wondering if anyone out there had a similar experience with a wonderful =
process called 'ntConsoleJava.e'. I am not sure whether it has been =
caused by CF5 shutting down inappropriately at some stage, but CF5 =
spawns a 'ntConsoleJava.e' process. If you watch it in task manager, it =
starts small, but quite determineably grows in memory usage by 4mg =
chunks. More importantly after it reaches about 5mg of memory usage it =
takes over 99% of cpu usage. (Its just a dev system of Ath650, 256ram =
running w2k).

After much swearing at norton AV not finding a virus, I thought it may =
be CF5. So I started selectively killing  CF services.
I've found that if I kill (and define them as manual execution) the =
repository,graphing, management and I think one other small CF process, =
then the ntConsoleJava.e disappears. I can still run CF apps quite fine =
with half of the server missing, but I wouldn't mind being able to play =
with graphing without the system churning 99%.=20

If anyone can help out in re to what I have gone amiss with, or what I =
could do to more appropriately rectify the situation, I would be most =
appreciative.

Regards,

Mark Terrill
Web Development Manager
Net Plus+ Internet Marketing
--
Phone:  07 5577 8835  |  Fax: 07 5577 8836
Email: [EMAIL PROTECTED]
Website: http://www.netplus.net.au
--

--=_NextPart_000_0033_01C0FA76.538B58E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi,
 
Wondering if anyone out there had a =
similar=20
experience with a wonderful process called 'ntConsoleJava.e'. I am not =
sure=20
whether it has been caused by CF5 shutting down inappropriately at some =
stage,=20
but CF5 spawns a 'ntConsoleJava.e' process. If you watch it in task =
manager, it=20
starts small, but quite determineably grows in memory usage by 4mg=20
chunks. More importantly after it reaches about 5mg of memory usage =
it=20
takes over 99% of cpu usage. (Its just a dev system of Ath650, 256ram =
running=20
w2k).
After much swearing at norton AV =
not finding a=20
virus, I thought it may be CF5. So I started selectively killing  =
CF=20
services.
I've found that if I kill (and define =
them as=20
manual execution) the repository,graphing, management and I think one =
other=20
small CF process, then the ntConsoleJava.e disappears. I can still run =
CF apps=20
quite fine with half of the server missing, but I wouldn't mind being =
able to=20
play with graphing without the system churning 99%. 
 
If anyone can help out in re to what I =
have gone=20
amiss with, or what I could do to more appropriately rectify the =
situation, I=20
would be most appreciative.
 
Regards,
 
Mark TerrillWeb Development =
ManagerNet=20
Plus+ Internet=20
Marketing=
--Phone: =20
07 5577 8835  |  Fax: 07 5577 8836Email: mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]Website: =
http://www.netplus.net.au";>http://www.netplus.net.au-=
-<=
/DIV>

--=_NextPart_000_0033_01C0FA76.538B58E0--


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

Cache sp result set

[Don Vawter]

Is there any way to cache the result set returned by a stored proced in SQL
Server 2000, CF 5

TIA



~~
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: SQL Server query

[Mark Warrick]

Interesting.  My opinion on the matter is don't fix something that isn't
broken.  Your first query, where you name the columns, is actually better
anyway.

SELECT * should be avoided whenever possible.

---mark



Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 1:59 PM
> To: CF-Talk
> Subject: RE: SQL Server query
>
>
> I've discovered the CFQUERY actually works fine if the SQL is like
> this:
>
> SELECT field1, field2
> FROM Table
>
> (with or without the semi-colon)
>
> but it fails on:
>
> SELECT *
> FROM Table
>
> Could this be an MDAC version issue? When I installed Ent Mgr, it
> apparently installed MDAC 6, according to the results of
> Component Checker. If it's MDAC-related, how tricky is it to go
> back to MDAC 2.1 SP2?
>
> Gene Kraybill
>
> On 20 Jun 2001, at 9:05, Mark Warrick wrote:
>
> > You've got a semi-colon at the end of your SQL statement.  Although this
> > would work fine in the SQL Query tool, within a CFQUERY it will not.
> >
> > Also, you don't need to specify the entire object path to the
> table, just
> > the tablename itself.  This has nothing to do with the error
> you got;  it's
> > just an FYI.
> >
> > ---mark
> >
> > 
> > Mark Warrick - Fusioneers.com
> > Personal Email: [EMAIL PROTECTED]
> > Business Email: [EMAIL PROTECTED]
> > Phone: 714-547-5386
> > Efax: 801-730-7289
> > Personal URL: http://www.warrick.net
> > Business URL: http://www.fusioneers.com
> > ICQ: 125160 / AIM: markwarric
> > 
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, June 20, 2001 10:34 AM
> > > To: CF-Talk
> > > Subject: SQL Server query
> > >
> > >
> > > I'm having difficulty getting a test template to work after
> > > setting up MSDE
> > > and Enterprise Manager on a dev laptop. I'm a newcomer to SQL
> Server, so
> > > it may be something obvious...
> > >
> > > I get this error:
> > >
> > > -
> > > CMemoryException: unknown cause
> > > PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
> > > The error occurred while processing an element with a general
> > > identifier of
> > > (CFQUERY)...
> > > -
> > > The error comes from this very simple template:
> > >
> > >  > > USERNAME="my_username" PASSWORD="my_password">
> > >   SELECT *
> > >   FROM my_SQLServerDb.dbo.WebPages;
> > > 
> > >
> > >
> > > Don't know if it could be a permissions error. I'm still coming
> > > up to speed
> > > with how they work in SQL Server. I do have the ODBC
> datasource for this
> > > db set up with the username and password shown in the query,
> and I've set
> > > Object Permissions for the WebPages table to include the use of SELECT
> > > for this username ...
> > >
> > > Gene Kraybill
> > >
> > >
> >
>
~~
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 to set up jumps within a CF form?

[Larry Juncker]

Set up all of your fields ahead of time with defaults like so:



That way ColdFusion has a value for that field even though it is null.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 3:45 PM
To: CF-Talk
Subject: Re: How to set up jumps within a CF form?


Thanks.  When I used double hashes, the form worked ok.  However, when I
clicked on the jump my computer, instead of going to the target spot, read
the code from the very beginning of the form and coming across empty field
values (because, after all, I'm still making the form and I haven't filled
it in yet), gave me the following error message:

"Error resolving parameter CUSTFIRSTNAME

ColdFusion was unable to determine the value of the parameter."

This is a problem, because I'm building this form as a demonstration, and
the person evaluating it is likely to check if the jump works before putting
in data.  How can I stop my computer from reading the code above the jump?

Hubert

---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as
US$7.50 each, less if you purchase 2 or more. Also being sold:  the
Genealogy of Jamaica CD-ROM


- Original Message -
From: Don Vawter <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 2:15 PM
Subject: Re: How to set up jumps within a CF form?


> Escape the hash -  displayform.cfm##continue
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 20, 2001 9:43 AM
> Subject: How to set up jumps within a CF form?
>
>
> > Hi,
> >
> > I'd like to enable the user of a form I'm creating to be able to jump
from
> one section to the other.  However, the HTML code for such a jump contains
> the character '#' (as in ) which
the
> CF server tries to interpret, resulting in an error message (I guess it's
> what would be called a 'reserved' character for CF).
> >
> > Is there any other way to achieve such a jump, which would be acceptable
> to CF?
> >
> > Hubert
> > ---
> > Hubert Earl
> >
> > ICQ#: 16199853
> >
> > My Jamaican Art, Craft & More Online Store:
> http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
> > Check out the art print bargains available! Beautiful prints as low as
> US$7.50 each, less if you purchase 2 or more. Also being sold:  the
> Genealogy of Jamaica CD-ROM
> >
> >
> >
> >
> >
>
~~
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

HELP!! VERITY is making me pull my hair out!!

[Larzz]

Does anybody have any solutions to the following problem that I am having:

I have a verity collection that pulls data out of a database.

I have one column in the database database that consists of a list of
keywords, i.e. (dead trees,Meta Lake,Meta Lake Mt. St.
Helens,mountain,Mountains,Mt. St. Helens,National
Monument,USA,volcanic,Volcano,Volcanoes,Washington State).

When I perform a search through the collection for "Mt. St. Helens", I get 0
results. Even though I know that that search string is in the database.

Any suggestions how I can get this to work.?
Thank
Jason Larson
[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: How to set up jumps within a CF form?

[hearl]

Thanks.  When I used double hashes, the form worked ok.  However, when I
clicked on the jump my computer, instead of going to the target spot, read
the code from the very beginning of the form and coming across empty field
values (because, after all, I'm still making the form and I haven't filled
it in yet), gave me the following error message:

"Error resolving parameter CUSTFIRSTNAME

ColdFusion was unable to determine the value of the parameter."

This is a problem, because I'm building this form as a demonstration, and
the person evaluating it is likely to check if the jump works before putting
in data.  How can I stop my computer from reading the code above the jump?

Hubert

---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as
US$7.50 each, less if you purchase 2 or more. Also being sold:  the
Genealogy of Jamaica CD-ROM


- Original Message -
From: Don Vawter <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 2:15 PM
Subject: Re: How to set up jumps within a CF form?


> Escape the hash -  displayform.cfm##continue
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 20, 2001 9:43 AM
> Subject: How to set up jumps within a CF form?
>
>
> > Hi,
> >
> > I'd like to enable the user of a form I'm creating to be able to jump
from
> one section to the other.  However, the HTML code for such a jump contains
> the character '#' (as in ) which
the
> CF server tries to interpret, resulting in an error message (I guess it's
> what would be called a 'reserved' character for CF).
> >
> > Is there any other way to achieve such a jump, which would be acceptable
> to CF?
> >
> > Hubert
> > ---
> > Hubert Earl
> >
> > ICQ#: 16199853
> >
> > My Jamaican Art, Craft & More Online Store:
> http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
> > Check out the art print bargains available! Beautiful prints as low as
> US$7.50 each, less if you purchase 2 or more. Also being sold:  the
> Genealogy of Jamaica CD-ROM
> >
> >
> >
> >
> >
>
~~
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: More CF 5 stuff - CFMAIL

[Michael Dinowitz]

So this is looking less like a CF 5 general issue with CFMAIL and more like
one specifically with my setup. I'm going to look through all the code that
sends mail and the error logs. I know there's a problem, now I get to define
the why of it. :)
Oh, this message was sent with CFMAIL (or resent as the case may be).


> the 4,000-5,000 are different; they're user accounts. there are many more
> users than that, but that is the average daily volume range. the
> 50,000-100,000 batch mailings are all the same - subscribers to a list.
>
> if you want to talk about mail and CF...i can go on for hours.
> www.planetaccess.com has nearly 50,000 accounts now. we've seen everything
> imaginable when it comes to using CF as the application framework for a
> web-based email site.
>
> --dylan
>
>
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 11:38 AM
> To: CF-Talk
> Subject: Re: More CF 5 stuff - CFMAIL
>
>
> Same ones or different? What I've been seeing is that a piece of mail will
> get 'stuck' and locked. It will not get sent, it will not get moved and it
> will not get deleted. This message will stop all other messages from being
> sent. To make matters worse, when CF wants to 'move' it to the
undelivered,
> it actually copies it to that directory and leaves the stuck message. This
> can go on and on. I had 65,000 messages last night and a few thousand
today.
> I'm trying to see the what and why of it before I move back down to 4.5.2.
> Oh, and I am sending all my results to MM as well as writing them down for
> articles. :)
>
>
> > Michael;
> >
> > I send about 4,000-5,000 emails daily with CFMAIL on CF5.0 and I don't
see
> > that. Every few weeks I send 50,000-100,000 in one batch. I haven't
> actually
> > done that in a month or so, so I don't know how that will run on CF5.0.
> When
> > I do, I'll let you know if anything anomalous happens.
> >
> > --Dylan
> >
> > -Original Message-
> > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 20, 2001 5:56 AM
> > To: CF-Talk
> > Subject: More CF 5 stuff - CFMAIL
> >
> >
> > OK, I've got 2 other things that have popped up that may be CF 5 or not.
> I'd
> > like to know of anyone else has seen them.
> > 1. 65,000+ 0 byte files were in the undelivr directory
> > 2. a 3k file with nothing but spaces was in the spool. This file caused
> all
> > mail to just hang.
> >
> > I'm routing about 2000 messages a day through CFMAIL and was wondering
if
> > anyone else with large CFMAIL usage has seen these. Also, CF is using a
> LOT
> > of CPU and I'm not sure its mail, a CFX, a scheduled event or what. I'm
> > still investigating.
> >
>
~~
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: Desperate for Hosting

[nwestby]

If you are looking for a great CF/NT Host look at ATSWEBNET
(www.atswebnet.com)

They have a very affordable solution, reliable up times, and good support.
The support is only by email, but has always been answered within a couple
of hours. 

Tell them www.coldfusionjobs.com sent you.

Nathan Westby
Co-Founder, Developer
ColdfusionJobs.com

-- Original Message --
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 17, 2001 10:13 AM
To: CF-Talk
Subject: Desperate for Hosting

Ok,
I desperately need a cheap and reliable 24 hour support service, hosting!
if anybody could suggest where i can look it would be of great help!
I've checked out a lot of what's on the net, but i'd like some personlized 
views/experince!
Thanks! 

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

RE: More CF 5 stuff - CFMAIL

[Dylan Bromby]

the 4,000-5,000 are different; they're user accounts. there are many more
users than that, but that is the average daily volume range. the
50,000-100,000 batch mailings are all the same - subscribers to a list.

if you want to talk about mail and CF...i can go on for hours.
www.planetaccess.com has nearly 50,000 accounts now. we've seen everything
imaginable when it comes to using CF as the application framework for a
web-based email site.

--dylan


-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 11:38 AM
To: CF-Talk
Subject: Re: More CF 5 stuff - CFMAIL


Same ones or different? What I've been seeing is that a piece of mail will
get 'stuck' and locked. It will not get sent, it will not get moved and it
will not get deleted. This message will stop all other messages from being
sent. To make matters worse, when CF wants to 'move' it to the undelivered,
it actually copies it to that directory and leaves the stuck message. This
can go on and on. I had 65,000 messages last night and a few thousand today.
I'm trying to see the what and why of it before I move back down to 4.5.2.
Oh, and I am sending all my results to MM as well as writing them down for
articles. :)


> Michael;
>
> I send about 4,000-5,000 emails daily with CFMAIL on CF5.0 and I don't see
> that. Every few weeks I send 50,000-100,000 in one batch. I haven't
actually
> done that in a month or so, so I don't know how that will run on CF5.0.
When
> I do, I'll let you know if anything anomalous happens.
>
> --Dylan
>
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 5:56 AM
> To: CF-Talk
> Subject: More CF 5 stuff - CFMAIL
>
>
> OK, I've got 2 other things that have popped up that may be CF 5 or not.
I'd
> like to know of anyone else has seen them.
> 1. 65,000+ 0 byte files were in the undelivr directory
> 2. a 3k file with nothing but spaces was in the spool. This file caused
all
> mail to just hang.
>
> I'm routing about 2000 messages a day through CFMAIL and was wondering if
> anyone else with large CFMAIL usage has seen these. Also, CF is using a
LOT
> of CPU and I'm not sure its mail, a CFX, a scheduled event or what. I'm
> still investigating.
>
~~
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: Thumbnail creation from Quark/Illustrator/Freehand

[Chad Gray]

This one is for the archives.  I have not found a way to make thumbnail 
images from Quark/Illustrator/Freehand documents but i have stumbled upon 
some very nifty image processors:

http://www.handmade.com/
http://www.imagepump.com/
http://www.rastermaster.com/



At 05:23 PM 6/19/2001 -0400, Bill Poff wrote:
>Chad,
>
>You can use ImageRobot from JASC which will read .AI and .EPS files (as well
>as a zillion others) and output a number of different graphic formats. You
>can control image size on the fly. I doubt you will find anything that will
>parse a Quark or Freehand native document.
>
>--Bill
>
>-Original Message-
>From: Chad Gray [mailto:[EMAIL PROTECTED]]
>Sent: Monday, June 18, 2001 11:58 AM
>To: CF-Talk
>Subject: Thumbnail creation from Quark/Illustrator/Freehand
>
>
>Has anyone see an application that can create a thumbnail from
>Quark/Illustrator/Freehand documents?
>
>I have an application where people upload files, and i can create thumbnail
>images from tif,psd,pcx,jpg,gif,eps, and bmp with CFexecute and
>ImageMagick.  I cant seem to find any application that will make a
>thumbnail from a Quark/Illustrator/Freedhand document though.
>
>Im thinking im going to have to hire a VB programmer, or C programmer to
>make an application...  Any Ideas?
>
>Thanks,
>Chad
>
~~
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: RDS Service

[Semrau, Steven L Mr SRA]

This was recently covered, if you check the Archives (see URL below) you can
search on it.  There is a Registry change you need to make to fix this.

I believe (correct me if I'm wrong here) that Mr. Watts was the one to cover
the fix.

Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com:  (703) 805-1095
DSN:  (703) 655-1095


-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 3:18 PM
To: CF-Talk
Subject: RDS Service


When the RDS Service is disabled, the CF Executive service still tries to 
start it. Is there anyway to keep the Executive from trying to start the 
RDS Service.

It tries to start it every 2 seconds and this quickly fills up the log file.

--
Nick McClure
TransDigital Solutions
~~
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 Service

[Nick McClure]

When the RDS Service is disabled, the CF Executive service still tries to 
start it. Is there anyway to keep the Executive from trying to start the 
RDS Service.

It tries to start it every 2 seconds and this quickly fills up the log file.

--
Nick McClure
TransDigital Solutions


~~
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: SQL Server query (MDAC Version correction)

[kraybill]

Sorry, I meant to say Component Checker indicates I'm currently 
running MDAC Version 2.6...

Gene

On 20 Jun 2001, at 13:59, [EMAIL PROTECTED] wrote:

> I've discovered the CFQUERY actually works fine if the SQL is like 
> this:
> 
> SELECT field1, field2 
> FROM Table
> 
> (with or without the semi-colon)
> 
> but it fails on:
> 
> SELECT *
> FROM Table
> 
> Could this be an MDAC version issue? When I installed Ent Mgr, it 
> apparently installed MDAC 6, according to the results of 
> Component Checker. If it's MDAC-related, how tricky is it to go 
> back to MDAC 2.1 SP2?
> 
> Gene Kraybill
> 
> On 20 Jun 2001, at 9:05, Mark Warrick wrote:
> 
> > You've got a semi-colon at the end of your SQL statement.  Although this
> > would work fine in the SQL Query tool, within a CFQUERY it will not.
> > 
> > Also, you don't need to specify the entire object path to the table, just
> > the tablename itself.  This has nothing to do with the error you got;  it's
> > just an FYI.
> > 
> > ---mark
> > 
> > 
> > Mark Warrick - Fusioneers.com
> > Personal Email: [EMAIL PROTECTED]
> > Business Email: [EMAIL PROTECTED]
> > Phone: 714-547-5386
> > Efax: 801-730-7289
> > Personal URL: http://www.warrick.net
> > Business URL: http://www.fusioneers.com
> > ICQ: 125160 / AIM: markwarric
> > 
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, June 20, 2001 10:34 AM
> > > To: CF-Talk
> > > Subject: SQL Server query
> > >
> > >
> > > I'm having difficulty getting a test template to work after
> > > setting up MSDE
> > > and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so
> > > it may be something obvious...
> > >
> > > I get this error:
> > >
> > > -
> > > CMemoryException: unknown cause
> > > PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
> > > The error occurred while processing an element with a general
> > > identifier of
> > > (CFQUERY)...
> > > -
> > > The error comes from this very simple template:
> > >
> > >  > > USERNAME="my_username" PASSWORD="my_password">
> > >   SELECT *
> > >   FROM my_SQLServerDb.dbo.WebPages;
> > > 
> > >
> > >
> > > Don't know if it could be a permissions error. I'm still coming
> > > up to speed
> > > with how they work in SQL Server. I do have the ODBC datasource for this
> > > db set up with the username and password shown in the query, and I've set
> > > Object Permissions for the WebPages table to include the use of SELECT
> > > for this username ...
> > >
> > > Gene Kraybill
> > >
> > >
> >
>
~~
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: More CF 5 stuff - CFMAIL

[Michael Dinowitz]

Same ones or different? What I've been seeing is that a piece of mail will
get 'stuck' and locked. It will not get sent, it will not get moved and it
will not get deleted. This message will stop all other messages from being
sent. To make matters worse, when CF wants to 'move' it to the undelivered,
it actually copies it to that directory and leaves the stuck message. This
can go on and on. I had 65,000 messages last night and a few thousand today.
I'm trying to see the what and why of it before I move back down to 4.5.2.
Oh, and I am sending all my results to MM as well as writing them down for
articles. :)


> Michael;
>
> I send about 4,000-5,000 emails daily with CFMAIL on CF5.0 and I don't see
> that. Every few weeks I send 50,000-100,000 in one batch. I haven't
actually
> done that in a month or so, so I don't know how that will run on CF5.0.
When
> I do, I'll let you know if anything anomalous happens.
>
> --Dylan
>
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 5:56 AM
> To: CF-Talk
> Subject: More CF 5 stuff - CFMAIL
>
>
> OK, I've got 2 other things that have popped up that may be CF 5 or not.
I'd
> like to know of anyone else has seen them.
> 1. 65,000+ 0 byte files were in the undelivr directory
> 2. a 3k file with nothing but spaces was in the spool. This file caused
all
> mail to just hang.
>
> I'm routing about 2000 messages a day through CFMAIL and was wondering if
> anyone else with large CFMAIL usage has seen these. Also, CF is using a
LOT
> of CPU and I'm not sure its mail, a CFX, a scheduled event or what. I'm
> still investigating.
>
~~
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

Is it possible to break out the code in a table from a file that is read in

[Larry Juncker]

I sent this post yesterday and did not receive any kind of response, so I
wanted to try once more.  Excuse me if it is too simple, but I am puzzled on
it.

I have a file that has the code in it for a table.
Is there a way that I can break out this table code into say q query or
something that can be used?  I only want parts of the table code.

For instance:

  
Header
Code1
Code2
  

I wan to be able to extract only the Code 2 cells of each row in the table.

Hope this makes sense.

TIA


Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[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: STRONG REFRESH PROBLEM

[Mark Warrick]

The simplest way to prevent proxies from caching your pages is to appened a
random number the end of each query string (URL) in the website.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 4:39 AM
> To: CF-Talk
> Subject: OT: STRONG REFRESH PROBLEM
>
>
> I'm having a weird problem with my site and local ISP:
>
> I update pages frequently on our www.imvamp.com page, but somehow
> new pages are not retrieved immediatly by our local users who use ISP1!!
> ISP2 local users and all other people from abroad can view the
> new pages just fine.
> ISP1 takes some time to "serve" the new pages, as if some proxy
> server is giving
> the old pages for the next 12-24 hours and updating it's records
> only after a day!
>
> is there a way to eliminate this caching? will specifiyng a
> no-cache/refresh tag
> in the server's html will help? will the ISP1 proxy server even
> consider this tag
> when it retrieves pages?
>
> Thanks,
>
> Michael Lugassy
> IT/WEB Specialist
> Interactive Music Ltd.
> I don't live in fantasy; I just work there...
> http://www.imvamp.com
> [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: More CF 5 stuff - CFMAIL

[Dylan Bromby]

Michael;

I send about 4,000-5,000 emails daily with CFMAIL on CF5.0 and I don't see
that. Every few weeks I send 50,000-100,000 in one batch. I haven't actually
done that in a month or so, so I don't know how that will run on CF5.0. When
I do, I'll let you know if anything anomalous happens.

--Dylan

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 5:56 AM
To: CF-Talk
Subject: More CF 5 stuff - CFMAIL


OK, I've got 2 other things that have popped up that may be CF 5 or not. I'd
like to know of anyone else has seen them.
1. 65,000+ 0 byte files were in the undelivr directory
2. a 3k file with nothing but spaces was in the spool. This file caused all
mail to just hang.

I'm routing about 2000 messages a day through CFMAIL and was wondering if
anyone else with large CFMAIL usage has seen these. Also, CF is using a LOT
of CPU and I'm not sure its mail, a CFX, a scheduled event or what. I'm
still investigating.
~~
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: CFQUERYPARAM broken in CF5?

[Garza, Jeff]

There is a quip on www.allaire.com that the dbtype attribute for
CFQUERYPARAM shouldn't be there.  It's not a valid attribute for that tag.
See 
http://www.allaire.com/documents/cf50/cf5_update.htm

HTH,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 19, 2001 6:21 PM
To: CF-Talk
Subject: CFQUERYPARAM broken in CF5?


When I attempt to use cfqueryparam in CF5.0 I get a compile error that the
attribute dbname is not an
allowable attribute for that tag. Since the VTOM uses it and it is in fact a
required attribute I wondered if anyone has had this problem?


TIA

Don
~~
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 to set up jumps within a CF form?

[Garza, Jeff]

I'm probably the 345th person to answer this, but when using pounds within a
CFOUTPUT block you have to escape the pound sign...

To get # to print out use ##

HTH,

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, June 20, 2001 8:44 AM
To: CF-Talk
Subject: How to set up jumps within a CF form?


Hi,

I'd like to enable the user of a form I'm creating to be able to jump from
one section to the other.  However, the HTML code for such a jump contains
the character '#' (as in ) which the
CF server tries to interpret, resulting in an error message (I guess it's
what would be called a 'reserved' character for CF).  

Is there any other way to achieve such a jump, which would be acceptable to
CF?

Hubert
---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as
US$7.50 each, less if you purchase 2 or more. Also being sold:  the
Genealogy of Jamaica CD-ROM
~~
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: Desperate for Hosting

[Bill Simpson]

Check out www.220solutions.com

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 10:13 AM
To: CF-Talk
Subject: Re: Desperate for Hosting


Why not Cihost? (http://www.cihost.com)
Checkout NT Shared Specials (!)

1gb storage, 20gb bandwidth, 200Mb SQL, Access, CF, shared SSL, plus much
much more.

Go for it.

Thanks,

Michael

- Original Message -
From: "Mark Warrick" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 5:57 PM
Subject: RE: Desperate for Hosting


> That's a pretty good deal, but did you read the fine print?
>
> "ABI Hosting's technical support services are limited to hosting, server,
> network, and domain issues."
>
> and
>
> "Requests for services not included in your account is subject to an
hourly
> charge of $45."
>
> On the service prices page you'll notice that they charge a 1/2 minimum
for
> all tech support calls.
>
> Those charges could add up pretty fast.
>
> ---mark
>
>
> 
> Mark Warrick - Fusioneers.com
> Personal Email: [EMAIL PROTECTED]
> Business Email: [EMAIL PROTECTED]
> Phone: 714-547-5386
> Efax: 801-730-7289
> Personal URL: http://www.warrick.net
> Business URL: http://www.fusioneers.com
> ICQ: 125160 / AIM: markwarric
> 
>
> > -Original Message-
> > From: Kevin Merker [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, June 18, 2001 8:39 AM
> > To: CF-Talk
> > Subject: Re: Desperate for Hosting
> >
> >
> > ABI Hosting
> > 100 mail accounts Complete CF hosting w/Access
> > $19.95 mo.
> > SQL 7 is more
> > http://www.abihosting.com
> >
> > - Original Message -
> > From: "Mark Warrick" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, June 18, 2001 8:49 AM
> > Subject: RE: Desperate for Hosting
> >
> >
> > > Cheap hosting with 24-hour access to tech support?  Hm
> > >
> > > How cheap is cheap in your mind?
> > >
> > > ---mark
> > >
> > > 
> > > Mark Warrick - Fusioneers.com
> > > Personal Email: [EMAIL PROTECTED]
> > > Business Email: [EMAIL PROTECTED]
> > > Phone: 714-547-5386
> > > Efax: 801-730-7289
> > > Personal URL: http://www.warrick.net
> > > Business URL: http://www.fusioneers.com
> > > ICQ: 125160 / AIM: markwarric
> > > 
> > >
> > > > -Original Message-
> > > > From: Heidi Belal [mailto:[EMAIL PROTECTED]]
> > > > Sent: Sunday, June 17, 2001 10:13 AM
> > > > To: CF-Talk
> > > > Subject: Desperate for Hosting
> > > >
> > > >
> > > > Ok,
> > > > I desperately need a cheap and reliable 24 hour
> > > > support service, hosting!
> > > > if anybody could suggest where i can look it would be
> > > > of great help!
> > > > I've checked out a lot of what's on the net, but i'd
> > > > like some personlized views/experince!
> > > > Thanks!
> > > >
> > > >
> > > > =
> > > > Heidi Belal
> > > > ICQ# 32127109
> > > >
> > > > A bus stops at a bus station.
> > > > A train stops at a train station.  On my desk
> > > > I have a work station...
> > > >
> > >
> >
>
~~
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: IsNumeric weirdness - can someone explain this?

[Andrew Tyrone]

> -Original Message-
> From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 19, 2001 3:59 PM
> To: CF-Talk
> Subject: IsNumeric weirdness - can someone explain this?
> 
> 
> Here's the test code:
> 
> -
> 
> 
>   #IsNumeric('3D1')#
>   #myvariable#
>   #IsNumeric(myvariable)#
> 
> 
> This returns:
> Yes
> 3D1
> Yes
> 
> -
> 
> WTF?!?  Shouldn't I be seeing No, 3D1, No?  Is it evaluating "3D1" as a
> binary or hex value of some kind?  Why is it passing an IsNumeric 
> test?  I'm
> running 4.5.1SP2.
> 
> Interestingly, 3A1, 3B1, 3C1, and 3F1 all fail, but 3E1 produces the same
> result.
> 

Evan,

Thanks for wasting my time! ;)  Well I had to figure out why the heck this was 
happening, and I found out it's because it's assuming the value is written in 
scientific notation.  I haven't been able to find out WHY "d" works just like "e" 
(exponential notation as in 24e-2 = 0.24), but it seems to do the same thing:



#IsNumeric("24e-2")#
#myvariable#
#IsNumeric(myvariable)#
#Val(myvariable)#



returns:

YES

24e-2

YES

0.24





#IsNumeric("24d-2")#
#myvariable#
#IsNumeric(myvariable)#
#Val(myvariable)#



returns:

YES

24d-2

YES

0.24


Notice I added the Val() function in there, which made me arrive at the conclusion 
that CF is treating the D the same as E and is using it as an exponent.


Have fun!



-Andy


~~
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 to set up jumps within a CF form?

[Don Vawter]

Escape the hash -  displayform.cfm##continue

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 9:43 AM
Subject: How to set up jumps within a CF form?


> Hi,
>
> I'd like to enable the user of a form I'm creating to be able to jump from
one section to the other.  However, the HTML code for such a jump contains
the character '#' (as in ) which the
CF server tries to interpret, resulting in an error message (I guess it's
what would be called a 'reserved' character for CF).
>
> Is there any other way to achieve such a jump, which would be acceptable
to CF?
>
> Hubert
> ---
> Hubert Earl
>
> ICQ#: 16199853
>
> My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
> Check out the art print bargains available! Beautiful prints as low as
US$7.50 each, less if you purchase 2 or more. Also being sold:  the
Genealogy of Jamaica CD-ROM
>
>
>
>
>
~~
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: Verity and unicode; Was: Coldfusion vs. ASP

[Paul Hastings]

> 1) were you able to  create, maintain and search verity collections based
on
> database info, where the info is in a double byte

if by double byte you mean unicode, then according to verity, the newer
stuff in cf5 *might* work as they say they're using unicode. our shop
hasn't used verity for db searches since we fell upon sql server's full text
indexing.

> 2) can the  gif.

no idea, but none of our thai language cfx tags work on unicode pages. but
these are quite old. i have seen some issues with unicode & some cfx_j tags.

in any case, i guess i'll give both of these issues a whirl thursday.



~~
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: SQL Server query

[kraybill]

I've discovered the CFQUERY actually works fine if the SQL is like 
this:

SELECT field1, field2 
FROM Table

(with or without the semi-colon)

but it fails on:

SELECT *
FROM Table

Could this be an MDAC version issue? When I installed Ent Mgr, it 
apparently installed MDAC 6, according to the results of 
Component Checker. If it's MDAC-related, how tricky is it to go 
back to MDAC 2.1 SP2?

Gene Kraybill

On 20 Jun 2001, at 9:05, Mark Warrick wrote:

> You've got a semi-colon at the end of your SQL statement.  Although this
> would work fine in the SQL Query tool, within a CFQUERY it will not.
> 
> Also, you don't need to specify the entire object path to the table, just
> the tablename itself.  This has nothing to do with the error you got;  it's
> just an FYI.
> 
> ---mark
> 
> 
> Mark Warrick - Fusioneers.com
> Personal Email: [EMAIL PROTECTED]
> Business Email: [EMAIL PROTECTED]
> Phone: 714-547-5386
> Efax: 801-730-7289
> Personal URL: http://www.warrick.net
> Business URL: http://www.fusioneers.com
> ICQ: 125160 / AIM: markwarric
> 
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, June 20, 2001 10:34 AM
> > To: CF-Talk
> > Subject: SQL Server query
> >
> >
> > I'm having difficulty getting a test template to work after
> > setting up MSDE
> > and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so
> > it may be something obvious...
> >
> > I get this error:
> >
> > -
> > CMemoryException: unknown cause
> > PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
> > The error occurred while processing an element with a general
> > identifier of
> > (CFQUERY)...
> > -
> > The error comes from this very simple template:
> >
> >  > USERNAME="my_username" PASSWORD="my_password">
> > SELECT *
> > FROM my_SQLServerDb.dbo.WebPages;
> > 
> >
> >
> > Don't know if it could be a permissions error. I'm still coming
> > up to speed
> > with how they work in SQL Server. I do have the ODBC datasource for this
> > db set up with the username and password shown in the query, and I've set
> > Object Permissions for the WebPages table to include the use of SELECT
> > for this username ...
> >
> > Gene Kraybill
> >
> >
>
~~
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: SQL Server query

[Andy Ewings]

>>You've got a semi-colon at the end of your SQL statement.  Although this
>>would work fine in the SQL Query tool, within a CFQUERY it will not.

I don't think this is true - you can legally use semi colons in a cfquery
providing you are using ODBC 2 as this supports the use of multiple SQL
statements separated by semi colons.

-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: 20 June 2001 17:05
To: CF-Talk
Subject: RE: SQL Server query


You've got a semi-colon at the end of your SQL statement.  Although this
would work fine in the SQL Query tool, within a CFQUERY it will not.

Also, you don't need to specify the entire object path to the table, just
the tablename itself.  This has nothing to do with the error you got;  it's
just an FYI.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 10:34 AM
> To: CF-Talk
> Subject: SQL Server query
>
>
> I'm having difficulty getting a test template to work after
> setting up MSDE
> and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so
> it may be something obvious...
>
> I get this error:
>
> -
> CMemoryException: unknown cause
> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
> The error occurred while processing an element with a general
> identifier of
> (CFQUERY)...
> -
> The error comes from this very simple template:
>
>  USERNAME="my_username" PASSWORD="my_password">
>   SELECT *
>   FROM my_SQLServerDb.dbo.WebPages;
> 
>
>
> Don't know if it could be a permissions error. I'm still coming
> up to speed
> with how they work in SQL Server. I do have the ODBC datasource for this
> db set up with the username and password shown in the query, and I've set
> Object Permissions for the WebPages table to include the use of SELECT
> for this username ...
>
> Gene Kraybill
>
>
~~
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

How to set up jumps within a CF form?

[hearl]

Hi,

I'd like to enable the user of a form I'm creating to be able to jump from one section 
to the other.  However, the HTML code for such a jump contains the character '#' (as 
in ) which the CF server tries to interpret, 
resulting in an error message (I guess it's what would be called a 'reserved' 
character for CF).  

Is there any other way to achieve such a jump, which would be acceptable to CF?

Hubert
---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as US$7.50 each, 
less if you purchase 2 or more. Also being sold:  the Genealogy of Jamaica CD-ROM




~~
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: SQL Server query (Followup)

[kraybill]

I've narrowed this issue down a bit...

Seems the query works fine if it reads:

SELECT field1, field2, etc
FROM Table

but it throws an error with
SELECT *
FROM Table

Running MSDE (SQL Server 7) and CF 4.0.1. Why would the 
asterisk throw an error?

Gene Kraybill

On 20 Jun 2001, at 10:34, [EMAIL PROTECTED] wrote:

> I'm having difficulty getting a test template to work after setting up MSDE 
> and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so 
> it may be something obvious...
> 
> I get this error:
> 
> -
> CMemoryException: unknown cause
> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
> The error occurred while processing an element with a general identifier of 
> (CFQUERY)...
> -
> The error comes from this very simple template:
> 
>  USERNAME="my_username" PASSWORD="my_password">
>   SELECT * 
>   FROM my_SQLServerDb.dbo.WebPages;
> 
> 
> 
> Don't know if it could be a permissions error. I'm still coming up to speed 
> with how they work in SQL Server. I do have the ODBC datasource for this 
> db set up with the username and password shown in the query, and I've set 
> Object Permissions for the WebPages table to include the use of SELECT 
> for this username ...
> 
> Gene Kraybill
> 
>
~~
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

Ensuring correct data placement on submission of a form

[hearl]

Hi,

I'm building an form allowing users to apply for insurance to cover money stored in 
business premises.  Each applicant may have more than one premises, and each premises 
may have more than one safe.  Because of this, I've built separate tables to store the 
data on each customer, premises and safe.  I've also built a field for the ID number 
of each customer in the Premises table, and a field for the ID number of each premises 
in the Safe table.

Beyond this, what else must I do to ensure that the data stored in the Premises table 
relate to the correct customers, and that the data stored in the Safe table relate to 
the correct premises?

Hubert
---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as US$7.50 each, 
less if you purchase 2 or more.




~~
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: Hover attribute with two different colors

[Pete Freitag]

Mike

You can use CSS classes to achieve this...



A.LightLink {
color : white;
}
A.DarkLink {
color: black;
}

A.LightLink:Hover {
color : yellow;
}
A.DarkLink:Hover {
color : red;
}


Then specify the class of the link...

that

And depending on what class  you specify you will have different colors.


Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developers Resources
http://www.cfdev.com/


-Original Message-
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 10:40 AM
To: CF-Talk
Subject: OT: Hover attribute with two different colors


Suppose I have two links on a page, one link is white on a dark
background and one is black on a light background. Is there any way to
get each to "hover" (i.e. CSS hover) a different color or is the hover
property global to the entire page?

-mike
~~
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: Files Explorer !!

[Mark Warrick]

Hamid,

Open up the /cfide/administrator/filedialog/index.cfm file.  This will show
you exactly how you can create an applet "tree" similar to the windows
explorer.

Of course, you'll need the decrypter.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: Hamid Hossain [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 3:32 AM
> To: CF-Talk
> Subject: Files Explorer !!
>
>
> Hi All,
>
> I want to make Files Explorer showing me directories
> and files of a specified directory. I don't know if it
> is available for coldfusion to offer Full-Directory
> structure with all sub-directories.
>
> any suggestions,
>
> Hamid Hossain
>
~~
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: SQL Server query

[Mark Warrick]

You've got a semi-colon at the end of your SQL statement.  Although this
would work fine in the SQL Query tool, within a CFQUERY it will not.

Also, you don't need to specify the entire object path to the table, just
the tablename itself.  This has nothing to do with the error you got;  it's
just an FYI.

---mark


Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 20, 2001 10:34 AM
> To: CF-Talk
> Subject: SQL Server query
>
>
> I'm having difficulty getting a test template to work after
> setting up MSDE
> and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so
> it may be something obvious...
>
> I get this error:
>
> -
> CMemoryException: unknown cause
> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
> The error occurred while processing an element with a general
> identifier of
> (CFQUERY)...
> -
> The error comes from this very simple template:
>
>  USERNAME="my_username" PASSWORD="my_password">
>   SELECT *
>   FROM my_SQLServerDb.dbo.WebPages;
> 
>
>
> Don't know if it could be a permissions error. I'm still coming
> up to speed
> with how they work in SQL Server. I do have the ODBC datasource for this
> db set up with the username and password shown in the query, and I've set
> Object Permissions for the WebPages table to include the use of SELECT
> for this username ...
>
> Gene Kraybill
>
>
~~
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

ER diagrams book

[Rick Johnson]

Hi guys,

Do you know about some good books on ER Diagrams...

Thanks a lot,
Rick
~~
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: Verity and unicode; Was: Coldfusion vs. ASP

[Marius Milosav]

Questions for people using double byte languages:
1) were you able to  create, maintain and search verity collections based on
database info, where the info is in a double byte
2) can the 
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, June 17, 2001 3:58 PM
Subject: Re: OT: Coldfusion vs. ASP


> > I've had to learn ASP to compliment my CF skills, mainly for
> multi-language
> > projects due to CF's lack of unicode support.
>
> not to start any religious wars, but even cf's unicode support, while
> not as good as ASP, isn't completely hopeless. workarounds exist
> for most stuff  http://www.tei.or.th/misc/unicodeSplit.cfm
>
>
>
>
~~
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: Desperate for Hosting <<< URGENT <<< WARNING <<< URGENT

[Brian L. Wolfsohn]

At 10:22 AM 6/20/01, you wrote:

I can second (or third) media3... We've been with them for about 4 years 
now, have 4 colo machines, and are very happy with their service.

>I unfortunately have to agree about CIHost.  Their prices are pretty
>good but I had my site hosted there for a couple of years before I
>moved.  It goes down constantly and there was a time (pre-ColdFusion
>conversion when my site was on Unix) that my site was down completely
>for 6 weeks.  I finally moved hosts and CIHost kept denying my DNS
>change. There was another person who recommended media3.net and I'll
>agree with that...I personally think Media3 is fantastic and I have
>never had any downtime that lasted more than a few seconds.  Support is
>responsive and intelligent there and the prices are very good.
>
>-Marla Jenkins


Brian L. Wolfsohnhttp://www.cus.com
CUS Business Systems Ft.Lauderdale,FL
Software for Auctioneers (954) 565-5600 Email:[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: Unicode ( was OT: Coldfusion vs. ASP)

[Paul Hastings]

> That's really interesting. I can't see the Japanese text but I'm assuming
> this is because I don't have the appropriate font installed?

probably though it seemed the w2k boxes in my shop read
that page as is. as you can see, the workarounds can be as
simple as a tiny bit of js clientside.  though i'm still looking
into serverside solutions.

> I'd be really interested in finding out about these workarounds... are
there
> any online resources? Anything to keep me away from ASP!

not yet. still working thru them all.  i guess the 1st place to start
is a list of what doesn't work w/unicode in cf5. i'll send you what
i know.  ...and any help w/this appreciated, cf6 is still a ways
off so there's still some legs with this issue


~~
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: IIF vs if,else

[Costas Piliotis]

Note - this was written in 1280 x 1024 maximized.  This will probably not
look too great on smaller resolutions.  I suggest copying this to notepad
and turning wordwrap off to view properly...

Iif can reduce the amount of code you need to write.

For example:



Vs








Keep in mind we're talking milliseconds here.  Of course CFIF is faster.
IIF reduces the amount of time it takes to code.  What if your block of code
can be reduced by many lines by one IIF statement?  The best is to
experiment.  You're right though; cfif is faster.  Iif reduces the number of
lines it takes to do something.  A good example of this is in stored
procedures.  In stored procedures, where null values are allowed, you have
two choices:

5 Lines:







Vs:


17 Lines:


















The second method gets a bit tedious.



-Original Message-
From: Cameron [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 19, 2001 4:03 PM
To: CF-Talk
Subject: IIF vs if,else


Ok, after a bit of testing... can anyone tell me what the advantage of IIF
over if ( or if () {}), else ( or else {}).

I tested a simple block of code using IIF and  & IIF
ran twice as slow...

I can't see any major advantage by using it... yeah, it is kinda similar to
i = (true?1 : 2); in javascript but it's really slow case of the implicit
evaluate() on each part. Would be better if it was implicit & made explicit,
IF NEEDED.

Can anyone give me a decent reason why IIF is better that ?

Cameron Junge
Web Developer
Strongnet
[EMAIL PROTECTED]
http://www.strongnet.co.nz
Ph: +64 9 414 2492
Fax: +64 9 414 2960

"You play with a Mac until you break it,
You play with a PC until it works."


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: Passing Javascript variables to CF?

[Costas Piliotis]

Because client side processing occurs AFTER the page loads, you would likely
need to store these values as a session variable.

Why not use  instead?  Only 5% of
the people run Netscape, so it'll probably take six or seven months before
anyone is effected by this =)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Monday, June 18, 2001 4:20 AM
To: CF-Talk
Subject: Re: Passing Javascript variables to CF?



I have the following Javascript returning the frame height and width.



function sizeTextArea(){
var winWidth=top.document.all.mainFrame.width;
var winHeight=top.document.all.mainFrame.height;
// offsets of 20 and 40 prevented scrollbars appearing in window
document.myForm.textvar.style.width=winWidth-20;
document.myForm.textvar.style.height=winHeight-40;
}


How can I get the width and height from the above script into a CF variable 
so I can pass this to a ...
tag?
~~
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: Hover attribute with two different colors

[Mike Amburn]

Suppose I have two links on a page, one link is white on a dark
background and one is black on a light background. Is there any way to
get each to "hover" (i.e. CSS hover) a different color or is the hover
property global to the entire page?
 
-mike
 

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

test

[Art Broussard]

Just checking. Its been a few days and no mail. : (

Art

"Never put your finger where you wouldn't put your nose."






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

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

SQL Server query

[kraybill]

I'm having difficulty getting a test template to work after setting up MSDE 
and Enterprise Manager on a dev laptop. I'm a newcomer to SQL Server, so 
it may be something obvious...

I get this error:

-
CMemoryException: unknown cause
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
The error occurred while processing an element with a general identifier of 
(CFQUERY)...
-
The error comes from this very simple template:


SELECT * 
FROM my_SQLServerDb.dbo.WebPages;



Don't know if it could be a permissions error. I'm still coming up to speed 
with how they work in SQL Server. I do have the ODBC datasource for this 
db set up with the username and password shown in the query, and I've set 
Object Permissions for the WebPages table to include the use of SELECT 
for this username ...

Gene Kraybill

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

Sending Newsletters

[luz lopez]

Hello All,


I would like to know if anyone could recommend an application to send 30,000 
weekly newsletters to our clients.  We are looking for a program that is 
able to detect duplicate emails, validate email addresses and keep track of 
the undeliverable emails.  My company does not want to spend the time to 
create an application, if there is something already out there.

We are looking at Fairlogic WorldCast® application, but we really appreciate 
any recommendations or alternatives.

Thanks,

Luz Lopez
~~
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: Desperate for Hosting <<< URGENT <<< WARNING <<< URGENT

[Marla S. Jenkins]

I unfortunately have to agree about CIHost.  Their prices are pretty
good but I had my site hosted there for a couple of years before I
moved.  It goes down constantly and there was a time (pre-ColdFusion
conversion when my site was on Unix) that my site was down completely
for 6 weeks.  I finally moved hosts and CIHost kept denying my DNS
change. There was another person who recommended media3.net and I'll
agree with that...I personally think Media3 is fantastic and I have
never had any downtime that lasted more than a few seconds.  Support is
responsive and intelligent there and the prices are very good.

-Marla Jenkins

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 9:07 PM
To: CF-Talk
Cc: Heidi Belal; Michael Lugassy
Subject: Re: Desperate for Hosting <<< URGENT <<< WARNING <<< URGENT


Dear Heidi:

IF YOU or MICHAEL LUGASSY or ANYONE ELSE ON THIS LIST are customers of 
CIHOST, be afraid, be VERY afraid.

Maybe you've seen CIHOST listed on a "Top Hosting Lists" website?  If
so, 
go back, look again, and see who actually sent in the votes for them to
be 
there.  This company has NO idea how to install, operate or support an
NT 
webserver, NEVER MIND one running Cold Fusion.  While you're there, also
do 
a domain name search on "CIHOSTSUCKS" and think carefully about why
there 
are so many TLD matches.

CIHOSTING's IIS servers crash dozens of times every day, and their CF 
services go down for hours at a time.  Yes, we DO have the actual logs
off 
their servers to prove it.  They easily take 2 or 3 days to respond to 
support emails, but only if you're lucky.  We also have a large
collection 
of wrongly answered (although mostly just unanswered) support emails.

We can also produce copies of CIHOST transactions where they have
rebilled 
the same service(s) multiple times.  Again we have WEEKS of unanswered 
billing emails asking for them to please stop.  Sadly the only way you
can 
get them to stop rebilling is by canceling your card, although you will 
continue getting automated reminders about your overdue payments, even 
after your account is closed.

Ours is not an isolated bad experience with CIHOST, although we've not 
exactly new to using virtual hosting (having been using CF since version

2).  Currently their attorneys are defending a class action by numerous 
CIHOST ex-customers who got wy more screwed then we did.  Finally
the 
company president and accountant (his girlfriend) are being investigated

for credit card fraud, but then of course you didn't pay them with
plastic 
did you?

Heidi, whatever choice you make for CF hosting, DO NOT, do not, DO NOT
use 
CIHOST.

PS: Please contact us off-list if you or anyone else here needs help
with 
problems caused by this bunch of Texas cowboys.



-- Original Message --
Date: Mon, 18 Jun 2001 19:13:11 +0200
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Desperate for Hosting

Why not Cihost? (http://www.cihost.com)
Checkout NT Shared Specials (!)
1gb storage, 20gb bandwidth, 200Mb SQL, Access, CF, shared SSL, plus
much
much more.
Go for it.
Thanks,
Michael



-- Original Message --
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 17, 2001 10:13 AM
To: CF-Talk
Subject: Desperate for Hosting

Ok,
I desperately need a cheap and reliable 24 hour support service,
hosting!
if anybody could suggest where i can look it would be of great help!
I've checked out a lot of what's on the net, but i'd like some
personlized 
views/experince!
Thanks! 


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: IIF vs if,else

[Gary Groomer]

The only advantage would be if you, as a coder, prefer the IIF() format over
the ... format.  Where performance is an issue, stay away from
the use of ColdFusion's dynamic functions such as IIF() as performance will
definitely suffer.

Gary Groomer

- Original Message -
From: "Cameron" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 4:02 PM
Subject: IIF vs if,else


Ok, after a bit of testing... can anyone tell me what the advantage of IIF
over if ( or if () {}), else ( or else {}).

I tested a simple block of code using IIF and  & IIF
ran twice as slow...

I can't see any major advantage by using it... yeah, it is kinda similar to
i = (true?1 : 2); in javascript but it's really slow case of the implicit
evaluate() on each part. Would be better if it was implicit & made explicit,
IF NEEDED.

Can anyone give me a decent reason why IIF is better that ?

Cameron Junge
Web Developer
Strongnet
[EMAIL PROTECTED]
http://www.strongnet.co.nz
Ph: +64 9 414 2492
Fax: +64 9 414 2960

"You play with a Mac until you break it,
You play with a PC until it works."


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




~~
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: IIF vs if,else

[Avi Flax]

Cameron, it's well known that IIF is much slower. As far as I know, the 
only real advantage to using it is that it's useful in some cases because 
you can write less code, which can be easier to read. And it is useful if 
you actually need to return some evaluated expression.

Avi

At 11:02 AM 6/20/2001 +1200, Cameron wrote:
>Ok, after a bit of testing... can anyone tell me what the advantage of IIF 
>over if ( or if () {}), else ( or else {}).
>
>I tested a simple block of code using IIF and  & IIF 
>ran twice as slow...
>
>I can't see any major advantage by using it... yeah, it is kinda similar 
>to i = (true?1 : 2); in javascript but it's really slow case of the 
>implicit evaluate() on each part. Would be better if it was implicit & 
>made explicit, IF NEEDED.
>
>Can anyone give me a decent reason why IIF is better that ?
>
>Cameron Junge
>Web Developer


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

This is a test. Please ignore.

[hearl]

This is a test.  Please ignore.
---
Hubert Earl

ICQ#: 16199853

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_for_go_jamaica.html
Check out the art print bargains available! Beautiful prints as low as US$7.50 each, 
less if you purchase 2 or more.




~~
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: atswebnet?

[Dave Hannum]

I've got a couple of small sites on there.  Yes, Robert responds very
quickly and is always very helpful!  Up time has been fine to date.

Dave



- Original Message -
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 10:46 AM
Subject: atswebnet?


> Someone tried atswebnet?
> Robert, the webmaster and support person seems very nice and proffesional.
>
> Thanks,
>
> Michael Lugassy
> IT/WEB Specialist
> Interactive Music Ltd.
> I don't live in fantasy; I just work there...
> http://www.imvamp.com
> [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: Foreign Key Constraint

[Erik Carroll]

This will work, just make sure that you insert the record into
tblAppointment_2 before updating the tblAppointment_1 to
avoid a constraint violation.

One thing to consider is the type of relationship between the two tables.
The way you are setting it up now is each tblAppointment_1 record
can be linked to only one tblAppointment_2 record, but each
tblAppointment_2 can be linked to many tblAppointment_1 records.

If this suits your needs then fine.

Not seeing tha data or knowing the requirements its hard to be sure, but you
might
consider putting the foreign key on tblAppointment_2 and have it reference
DEcisionID on tblAppointment_1. This would allow the ONE to MANY
relationship
that I think you are trying to establish.

Again, this is just a best guess from looking at your table structure. If
you are
establishing only a ONE to ONE relationship then what you are thinking of
will work just fine.


Erik


- Original Message -
From: "Julie Clegg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 12:02 PM
Subject: Foreign Key Constraint


>
>
>
> I have 2 tables - tblAppointment_1 and tblAppointment_2.  I want to set up
a
> foreign key in appointment_1 to connect it to Appointment_2.  My question
> is, if the Appointment_1 record is created a few weeks before
Appointment_2,
> will this be a problem because the foreign key will be null for a period
of
> time?  ie...appt_1 record is created first.  Then, after some time, Appt_2
> record is created and appt_1 record is updated(inserting the CASACID).
>
> Appt_1 Appt_2
> 
> DEcisionID(PrimaryKey)CasacID(PrimaryKey)
> date  date
> firstname outcome
> lastname
> CASACID(ForeighKey)
>
~~
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: atswebnet?

[Clint Tredway]

I use atswebnet and I am very happy with their service.

-- Original Message --
From: "Michael Lugassy" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 20 Jun 2001 16:46:14 +0200

Someone tried atswebnet?
Robert, the webmaster and support person seems very nice and proffesional.

Thanks,

Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
I don't live in fantasy; I just work there...
http://www.imvamp.com
[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: CF's handling of queued emails

[tom muck]

By default ColdFusion processes the mail in the queue every sixty seconds,
and sends 100 emails.  You can reduce this to 15 seconds in the
Administrator.  If it's in the queue, it should go out.  If it's in
Undelivered, you can cut/paste them back into the queue, or do it
programatically, and they'll go out.

tom

"W Luke" <[EMAIL PROTECTED]> wrote in message
00ce01c0f907$089391b0$3500a8c0@ekul">news:00ce01c0f907$089391b0$3500a8c0@ekul...
> Hi,
>
> This is something I'll take up with my hosters tomorrow morning, but it
> brought up another question that cf-talk will probably know better.
>
> Several emails generated from  today weren't sent, for some
reason -
> either they have failed, or they're in the queue.  It's been an hour or
more
> since they should have been sent, but I still haven't got a couple - and
198
> of my members are still waiting to receive theirs too.  How long does CF
> wait to re-try queued mails?  Each of the emails contains important
customer
> information, and I'm worried they've gone missing.
>
> Any info appreciated.
>
> Will
>
>
>
~~
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: Oracel Error 604 ?

[Semrau, Steven L Mr SRA]

ORA-00604: error occurred at recursive SQL level num 
Cause: An error occurred while processing a recursive SQL statement. A
recursive SQL statement is one that applies to internal dictionary tables. 

Action: If the situation described in the next message on the stack can be
corrected, do so; otherwise, contact customer support. 


Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com:  (703) 805-1095
DSN:  (703) 655-1095


-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 11:28 PM
To: CF-Talk
Subject: Oracel Error 604 ?


hi 
did anyone encounter this error in CF before?
Oracle Error Code = 604 
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded 

i did not use any cursor in my CF file, but why do i get this error?
Any help will be much appreciated.
Jaime Hoi
DID : 2312617  
FAX : 5386977

Victory is in the mind of those who believe and who believe the longest
~~
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

atswebnet?

[Michael Lugassy]

Someone tried atswebnet?
Robert, the webmaster and support person seems very nice and proffesional.

Thanks,

Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
I don't live in fantasy; I just work there...
http://www.imvamp.com
[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: Any probs with CF5 & COM?

[Michael Dinowitz]

Looping over collections inside CFSCRIPT doesn't work. This might be what he
was referring to. One of the major pet peeves we had.
I'm going to check on that attribute order switch. They said that they were
moving it back to the original for the full release.


> I'm not running 5.0, but Dain Anderson pointed out to me that the order of
the
> arguments to CreateObject has changed.
>
> Beta 3:
> objWord = CreateObject("COM", "Word.Application", "Local");
>
> RC1:
> objWord = CreateObject("COM", "Local", "Word.Application");
>
> It also may be that looping over collections sometimes doesn't work.
(How's
> that line for a vague response?)
>
> -David
>
> On Tuesday, June 19, 2001 11:35 PM, Dylan Bromby [SMTP:[EMAIL PROTECTED]]
wrote:
> > I know this vague, but has anyone experienced any odd problems with
CF5.0
> > and COM objects?
>
>
~~
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 probs with CF5 & COM?

[David Shadovitz]

I'm not running 5.0, but Dain Anderson pointed out to me that the order of the 
arguments to CreateObject has changed.

Beta 3:
objWord = CreateObject("COM", "Word.Application", "Local");

RC1:
objWord = CreateObject("COM", "Local", "Word.Application");

It also may be that looping over collections sometimes doesn't work.  (How's 
that line for a vague response?)

-David

On Tuesday, June 19, 2001 11:35 PM, Dylan Bromby [SMTP:[EMAIL PROTECTED]] wrote:
> I know this vague, but has anyone experienced any odd problems with CF5.0
> and COM objects?

~~
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: OT: Coldfusion vs. ASP

[Paul Hastings]

> I can see the Chinese with my NJ Star Chinese viewer except the second
character under the column SQL LEFT 5 and CF
> LEFT 5 becomes ?? mark.  It might be because my viewer doesn't work well,
but give you an feedback.

thanks. yeah thats supposed to happen. both LEFT in cf & substring in sql
server
garabge unicode. did the js left come thru ok?


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

More CF 5 stuff - CFMAIL

[Michael Dinowitz]

OK, I've got 2 other things that have popped up that may be CF 5 or not. I'd
like to know of anyone else has seen them.
1. 65,000+ 0 byte files were in the undelivr directory
2. a 3k file with nothing but spaces was in the spool. This file caused all
mail to just hang.

I'm routing about 2000 messages a day through CFMAIL and was wondering if
anyone else with large CFMAIL usage has seen these. Also, CF is using a LOT
of CPU and I'm not sure its mail, a CFX, a scheduled event or what. I'm
still investigating.



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

ColdFusion 5 now available on all platforms

[Phil Costa]

Macromedia is proud to announce that all editions of ColdFusion Server 5 on
all supported platforms have been released to manufacturing and are
available immediately for evaluation and purchase. 

Evaluation versions of ColdFusion 5 are available for Windows, Linux,
Solaris, and HP-UX. Experience increased productivity, simplified management
and enhanced performance today by downloading an evaluation copy at:
http://www.macromedia.com/software/coldfusion/trial

Commercial copies can be purchased at the Macromedia online store
(http://www.macromedia.com/store), through Macromedia sales
(1-888-939-2545), or through your local reseller. Except for the enterprise
editions of ColdFusion Server 5 for Linux and Solaris, all editions are
available to ship immediately. Enterprise editions for Solaris and Linux can
be back-ordered via Macromedia sales and will ship to customers in early
July.

Thanks for your continued support,

Phil Costa 
Sr. Product Marketing Manager
Macromedia
[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

Passing text files across servers????

[Chad McCue]

Hello people,
 I am currently looking for some good ideas for sending information from one 
server to another securely from cfscheduler. Someone mentioned cfhttp but I didn't 
think I was able to send things across servers via this method. I am open to any 
suggestions.

Thanks.


~~
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 threads and multiprocessor servers

[Earl, George]

How does using a multiprocessor web server affect the number of concurrent
threads that can run in CF? For example, other things being equal, can a
quad processor server handle four times as many threads as a single
processor server? Or is the number of threads tied into the operating
system? (We're using WinNT 2000 Advanced Server) Thanks!.

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

OT: STRONG REFRESH PROBLEM

[Michael Lugassy]

I'm having a weird problem with my site and local ISP:

I update pages frequently on our www.imvamp.com page, but somehow
new pages are not retrieved immediatly by our local users who use ISP1!!
ISP2 local users and all other people from abroad can view the new pages just fine.
ISP1 takes some time to "serve" the new pages, as if some proxy server is giving
the old pages for the next 12-24 hours and updating it's records only after a day!

is there a way to eliminate this caching? will specifiyng a no-cache/refresh tag
in the server's html will help? will the ISP1 proxy server even consider this tag
when it retrieves pages?

Thanks,

Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
I don't live in fantasy; I just work there...
http://www.imvamp.com
[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

Files Explorer !!

[Hamid Hossain]

Hi All,

I want to make Files Explorer showing me directories
and files of a specified directory. I don't know if it
is available for coldfusion to offer Full-Directory
structure with all sub-directories.

any suggestions,

Hamid Hossain
~~
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

& Session variable problems with IE 5.0 on Mac

[David Laing]

Hi All.

I've been battling with a problem on with IE5.0 on the Mac for the past few
hours and wonder if anyone has
a) Had a similar experience
b) Knows of a solution.

My script does the following.
1.  It turns session management on:



2.  It checks for the existance of a cookie, called visitorID:



3.  If this isn't defined, then it generates a new visitor ID, and stores
this in a cookie



4.  It then uses the cookie variable in the page.

5.  Next time you visit the page, it sees that cookie.visitorID is set, so
it doesn't generate a new one.  This works perfectly on IE5/Win, NN/Win,
NN/Mac but not on IE5/Mac.  Every time I visit the page on the IE5/Mac, it
generates a new visitorID for the cookie (ie, the previous one wasn't set).
Cookies are definately allowed in IE5.  They just don't seem to be stored
between page refreshes!  You will also see that I use cookies for session
management (CFID & CFTOKEN) - these are also getting lost, so my sessions
aren't working either.

I am at a bit of a loss as to what to do - some pointers would be much
appreciated (Allaires Forums and Dev Exchange are pretty quiet on this one)

Update*
I have just discovered the following.  If I make the cookie a session
cookie, (ie, I leave out the expires="..." bit : ) then the cookie is stored, but only
whilst the browser is open.  If I put anything (NEVER, 7, 01/01/2002 etc.)
then the cookie isn't stored at all.  Does that shed any light?
**

Regards

David Laing (david [at] vardus.com)
Substitute Window Washer, Vardus Internet Solutions

(A)bort, (R)etry, (F)*ckup completely?


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

Re: Oracel Error 604 ?

[David Shadovitz]

Jaime,
Are you using stored procedures?  See 
http://www.allaire.com/Handlers/index.cfm?ID=18372&Method=Full
-David

===
Jaime Hoi will have written:
did anyone encounter this error in CF before?
Oracle Error Code = 604
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

i did not use any cursor in my CF file, but why do i get this error?

~~
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 probs with CF5 & COM?

[Dylan Bromby]

I know this vague, but has anyone experienced any odd problems with CF5.0
and COM objects?

--Dylan


~~
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: Data Validation

[David Shadovitz]

Here's a method from David Flanagan's JavaScript: The Definitive Guide, 3rd 
Edition, Example 16-2, Performing Form Validation, 
http://examples.oreilly.com/jscript3/text/16-2.txt

-David

Re: FYI - host switched to CF5

[Massimo Foti]

"Brian Hogue" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> Did you get CrystalTech's email?

It's early in the morning here and I am still at home, I will check my email
as soon as I will arrive at the office.



> I wish Pat Stangler and ChicagoWebs the best. Why don't they mention this?
Just
> curious.

Seems like they still have to install CF 5 on all their machines, but they
mentioned it on the Ultradev Newsgroup

Massimo



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

CFQUERYPARAM broken in CF5?

[Don Vawter]

When I attempt to use cfqueryparam in CF5.0 I get a compile error that the
attribute dbname is not an
allowable attribute for that tag. Since the VTOM uses it and it is in fact a
required attribute I wondered if anyone has had this problem?


TIA

Don




~~
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: Don't PRE-REGISTER New Top Level Domains

[David Hannum]

If any of you are planning going with the new TDL's (.biz, .info, .pro,
..name) don't pre-register.  Pre registration does not guarantee that you'll
get the name, and rip off companies like www.newdomainfactory.com spell out
that first, they don't guarantee that if you pre-register with them, you'll
even get the domain and that your $10 deposit is not refundable under any
circumstances!  Go to their Terms & Conditions at
http://www.newdomainfactory.com/terms.html .  They even admit that they'll
be competing with other registrars at the time the names are actually
available and that they may get beat to the punch. Quote: "most of the
"good" names may be gone when we start operations".  LOL - what a joke.  So
beware!

Dave


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

Oracel Error 604 ?

[JAIME HOI]

hi 
did anyone encounter this error in CF before?
Oracle Error Code = 604 
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded 

i did not use any cursor in my CF file, but why do i get this error?
Any help will be much appreciated.
Jaime Hoi
DID : 2312617  
FAX : 5386977

Victory is in the mind of those who believe and who believe the longest


~~
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: pdfs, fds oh my

[David Shadovitz]

You are populating GradesForPDF in a query loop, so CurrentRow is available. 
 But are you filling in the FDF in a loop? Can't tell from your code snippet, 
but you should be doing something like this:


/FDF << /Fields [ << /V (#GradesForPDF[i][1]#)/T (Grade)>> << /V
(#LASTNAME#)/T (NAME)>>
<< /V (#FIRSTNAME#)/T (TchNAME)>> ] .


-David


On Monday, June 18, 2001 5:19 AM, Janine Jakim [SMTP:[EMAIL PROTECTED]] 
wrote:
> This is a repost.  I sent this out Friday afternoon, but it never showed up
> again in my mailbox...sorry if you are receiving it for a 2nd time.
> I am trying to populate my pdf form using cf/fdf(non ActiveXmethod)-nice
> write up on that Max- your directions are superb and easy to follow. (If you
> don't know what I'm talking about you can check out this link
> http://www.mail-archive.com/cf-talk@houseoffusion.com/msg32040.html )
> It works fine until I try to add an array to the equation.  I keep getting
> error msgs.  It's the msg that usually means that a variable can't be
> found/is misspelled. ("Error resolving parameter Currentrow)I assume it
> is getting caught up on how the array variable  is set up.  This is what
> it's like:
> action page:
> 
> 
> 
> 
> 
> 
>
> The fdf looks like this
> /FDF << /Fields [ << /V (#GradesForPDF[CurrentRow][1]#)/T (Grade)>> << /V
> (#LASTNAME#)/T (NAME)>>
> << /V (#FIRSTNAME#)/T (TchNAME)>> ] .
> The error is the resolving parameter CurrentRow.
>
> In my query I tried to do another cfset- something like
>  work/is illegal- is there a way to get this to output correctly

~~
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: CF 5 scheduling

[Jim Watkins]

No problem here with scheduling after installing CF 5 pro subscription
upgrade.


- Original Message -
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 8:31 AM
Subject: CF 5 scheduling


>
> Has anyone had any problems with the scheduling in CF 5? I've had CF 4.5.2
> and earlier scheduled events running like a champ but 5 doesn't seem to
want
> to budge. Anyone else with this experience?
> I built the new HoF server with CF 5 but I may go back to 4.5.2 if this
> isn't working right.
>
> Michael Dinowitz
> Publisher: Fusion Authority weekly news alert
> (www.fusionauthority.com/alert)
> Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
> (www.houseoffusion.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: CFX_Excel Tag not working with CF 5.0

[Jim Watkins]

The CFX_Excel is in the tag gallery and allows you to populate an Excel
template stored on your server with information from a SELECT statement.
The Excel template is then downloaded to the clients computer and can be
saved or opened in Excel.

Jim
- Original Message -
From: "Paul Smith" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, June 16, 2001 8:39 AM
Subject: Re: CFX_Excel Tag not working with CF 5.0


>
> What does the CFX_Excel tag allow you to do?
> Does it help you import an Excel spreadsheet into SQL?
>
> best,  paul
>
> At 01:21 AM 6/17/01 -0400, you wrote:
> >Dave,
> >That did it!
> >I deleted the tag and removed the "registration".  Downloaded a fresh tag
> >and installed and registered it.  Restarted CF5.  Cold Fusion is running
as
> >a service logging on LocalSystem account.
> >I also reinstalled MSoffice on the webserver.
> >
> >Jim
> >- Original Message -
> >From: "Dave Watts" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Saturday, June 16, 2001 11:05 PM
> >Subject: RE: CFX_Excel Tag not working with CF 5.0
> >
> >
> > >
> > > > CFX_Excel v 2.0 Tag by Thomas Frey stopped working right
> > > > after I upgraded to CF5.0. What would break this tag? It
> > > > ran for over a year on 4.5. Any suggestions?
> > >
> > > Did you reinstall it after installing CF 5?
> > >
> > > Dave Watts, CTO, Fig Leaf Software
> > > http://www.figleaf.com/
> > > voice: (202) 797-5496
> > > fax: (202) 797-5444
> > >
> > >
> >
>
~~
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: Desperate for Hosting <<< URGENT <<< WARNING <<< URGENT

[phumes1]

I use http://www.media3.net/ and I find them excellent.


At 02:06 AM 6/20/2001 +0100, you wrote:
>Dear Heidi:
>
>IF YOU or MICHAEL LUGASSY or ANYONE ELSE ON THIS LIST are customers of
>CIHOST, be afraid, be VERY afraid.
>
>Maybe you've seen CIHOST listed on a "Top Hosting Lists" website?  If so,
>go back, look again, and see who actually sent in the votes for them to be
>there.  This company has NO idea how to install, operate or support an NT
>webserver, NEVER MIND one running Cold Fusion.  While you're there, also do
>a domain name search on "CIHOSTSUCKS" and think carefully about why there
>are so many TLD matches.
>
>CIHOSTING's IIS servers crash dozens of times every day, and their CF
>services go down for hours at a time.  Yes, we DO have the actual logs off
>their servers to prove it.  They easily take 2 or 3 days to respond to
>support emails, but only if you're lucky.  We also have a large collection
>of wrongly answered (although mostly just unanswered) support emails.
>
>We can also produce copies of CIHOST transactions where they have rebilled
>the same service(s) multiple times.  Again we have WEEKS of unanswered
>billing emails asking for them to please stop.  Sadly the only way you can
>get them to stop rebilling is by canceling your card, although you will
>continue getting automated reminders about your overdue payments, even
>after your account is closed.
>
>Ours is not an isolated bad experience with CIHOST, although we've not
>exactly new to using virtual hosting (having been using CF since version
>2).  Currently their attorneys are defending a class action by numerous
>CIHOST ex-customers who got wy more screwed then we did.  Finally the
>company president and accountant (his girlfriend) are being investigated
>for credit card fraud, but then of course you didn't pay them with plastic
>did you?
>
>Heidi, whatever choice you make for CF hosting, DO NOT, do not, DO NOT use
>CIHOST.
>
>PS: Please contact us off-list if you or anyone else here needs help with
>problems caused by this bunch of Texas cowboys.
>
>
>
>-- Original Message --
>Date: Mon, 18 Jun 2001 19:13:11 +0200
>From: "Michael Lugassy" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Desperate for Hosting
>
>Why not Cihost? (http://www.cihost.com)
>Checkout NT Shared Specials (!)
>1gb storage, 20gb bandwidth, 200Mb SQL, Access, CF, shared SSL, plus much
>much more.
>Go for it.
>Thanks,
>Michael
>
>
>
>-- Original Message --
>From: Heidi Belal [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, June 17, 2001 10:13 AM
>To: CF-Talk
>Subject: Desperate for Hosting
>
>Ok,
>I desperately need a cheap and reliable 24 hour support service, hosting!
>if anybody could suggest where i can look it would be of great help!
>I've checked out a lot of what's on the net, but i'd like some personlized
>views/experince!
>Thanks!
>
>
>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: IIF vs if,else

[Michael Dinowitz]

IIF is much slower than a standard CFIF. 'nuff said.


Ok, after a bit of testing... can anyone tell me what the advantage of IIF
over if ( or if () {}), else ( or else {}).

I tested a simple block of code using IIF and  & IIF
ran twice as slow...

I can't see any major advantage by using it... yeah, it is kinda similar to
i = (true?1 : 2); in javascript but it's really slow case of the implicit
evaluate() on each part. Would be better if it was implicit & made explicit,
IF NEEDED.

Can anyone give me a decent reason why IIF is better that ?

Cameron Junge
Web Developer
Strongnet
[EMAIL PROTECTED]
http://www.strongnet.co.nz
Ph: +64 9 414 2492
Fax: +64 9 414 2960

"You play with a Mac until you break it,
You play with a PC until it works."


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




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

CFMail - Question: Sending to a different mail server

[Larry Juncker]

I currently am set up on mail.server1.com
I would like any emails that I send out to appear ss being sent from
mail.server2.com

How do I make my email messaage in the tools, options area to show
mail.server2..com instead of mail.server1.com?

Any quick help on this would be greatly appreciated

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[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

CF's handling of queued emails

[W Luke]

Hi,

This is something I'll take up with my hosters tomorrow morning, but it
brought up another question that cf-talk will probably know better.

Several emails generated from  today weren't sent, for some reason -
either they have failed, or they're in the queue.  It's been an hour or more
since they should have been sent, but I still haven't got a couple - and 198
of my members are still waiting to receive theirs too.  How long does CF
wait to re-try queued mails?  Each of the emails contains important customer
information, and I'm worried they've gone missing.

Any info appreciated.

Will


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

Is it possible to break out the code in a table from a file that is read in

[Larry Juncker]

I have a file that has the code in it for a table.
Is there a way that I can break out this table code into say q query or
something that can be used?  I only want parts of the table code.

For instance:

  
Header
Code1
Code2
  

I wan to be able to extract only the Code 2 cells of each row in the table.

Hope this makes sense.

TIA


Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[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: Thumbnail creation from Quark/Illustrator/Freehand

[Bill Poff]

Chad,

You can use ImageRobot from JASC which will read .AI and .EPS files (as well
as a zillion others) and output a number of different graphic formats. You
can control image size on the fly. I doubt you will find anything that will
parse a Quark or Freehand native document.

--Bill

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 11:58 AM
To: CF-Talk
Subject: Thumbnail creation from Quark/Illustrator/Freehand


Has anyone see an application that can create a thumbnail from
Quark/Illustrator/Freehand documents?

I have an application where people upload files, and i can create thumbnail
images from tif,psd,pcx,jpg,gif,eps, and bmp with CFexecute and
ImageMagick.  I cant seem to find any application that will make a
thumbnail from a Quark/Illustrator/Freedhand document though.

Im thinking im going to have to hire a VB programmer, or C programmer to
make an application...  Any Ideas?

Thanks,
Chad
~~
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: Thumbnail creation from Quark/Illustrator/Freehand

[Bill Poff]

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 11:58 AM
To: CF-Talk
Subject: Thumbnail creation from Quark/Illustrator/Freehand


Has anyone see an application that can create a thumbnail from
Quark/Illustrator/Freehand documents?

I have an application where people upload files, and i can create thumbnail
images from tif,psd,pcx,jpg,gif,eps, and bmp with CFexecute and
ImageMagick.  I cant seem to find any application that will make a
thumbnail from a Quark/Illustrator/Freedhand document though.

Im thinking im going to have to hire a VB programmer, or C programmer to
make an application...  Any Ideas?

Thanks,
Chad
~~
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: Unicode ( was OT: Coldfusion vs. ASP)

[sebastian palmigiani]

on 6/18/01 11:58 PM, Kay Smoljak at [EMAIL PROTECTED] wrote:

> I'd be really interested in finding out about these workarounds... are there
> any online resources? Anything to keep me away from ASP!

One of the work arounds that I have used is to use the URLEncodedFormat()
around the unicode characters and insert them that way into the database.
Then when you pull them out and want to display them you use URLDecode().


Sebastian Palmigiani

Cash Flow Club Charity
http://www.cashflowclubonline.com/?SEB007883
voice: 773.929.9256



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

[Chris Jenkins]

I have set in the CF administrator to timeout request over 120 seconds.
However, in my logs i see
"Warning","TID=482","06/19/01","11:13:10","Template:
d:\Inetpub\wwwroot\channel_products.htm, Ran: 335 seconds."

Why is this??

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

RE: Ambed another application within browser window

[phumes1]

Hi,

Would anyone know if it's possible using CF to run another application 
(UltraEdit-32) within a browser window?

Am I making sense?


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

IsNumeric weirdness - can someone explain this?

[Evan Lavidor]

Here's the test code:

-


#IsNumeric('3D1')#
#myvariable#
#IsNumeric(myvariable)#


This returns:
Yes
3D1
Yes

-

WTF?!?  Shouldn't I be seeing No, 3D1, No?  Is it evaluating "3D1" as a
binary or hex value of some kind?  Why is it passing an IsNumeric test?  I'm
running 4.5.1SP2.

Interestingly, 3A1, 3B1, 3C1, and 3F1 all fail, but 3E1 produces the same
result.

Thanks,

Evan

--
-=-=-=-=-=-=-=-=-=-
Evan Lavidor
Circle.com Boston
Tel: 617-585-3107
Fax: 617-585-3091
-=-=-=-=-=-=-=-=-=-


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

Sending something secure from one server to another.

[Chad McCue]

Hello people,
 I am currently looking for some good ideas for sending information from one 
server to another securely from cfscheduler. Someone mentioned cfhttp but I didn't 
think I was able to send things across servers via this method. If there is any good 
suggestions, I would love to hear them

Thanks.


~~
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: RDS Service

[Chris Norloff]

-- Original Message --
From: Nick McClure <[EMAIL PROTECTED]>
>When the RDS Service is disabled, the CF Executive service still tries to 
>start it. Is there anyway to keep the Executive from trying to start the 
>RDS Service.
>
>It tries to start it every 2 seconds and this quickly fills up the log file.
>

Well, in Solaris you put -s after cfexec in the start script. There's a Knowledgebase 
article on it.

Chris Norloff

~~
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: FYI - host switched to CF5

[Massimo Foti]

Glad to see CrystalTech upgraded (I host an important site there and I am
very happy about the service).

Anyway, www.chicagowebs.com already had CF 5 since a few weeks even if it's
not stated on their website, their are a newcomer with CF, but have a great
reputation on NT hosting

Massimo



"Brian Hogue" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> Michael Dinowitz was not aware of anyone using CF 5 in production at
> this month's User Group meeting. My Web Hosting, CrystalTech, emailed
> that they switched everyone to CF 5. They claim to be the first hosting
> company to do 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

null paddedtrings and OLEDB

[Don Vawter]

   
  

The above call returns  the OUT  variable (request.appname) padded with
nulls when I use an OLEDB datasource. When I use ODBC the nulls are
stripped. DB = SQL Server 2000.

It's easy enough to call a UDF to strip them  but I was wondering if there
is a setting somewhere that can do this automatically.


TIA

Don




~~
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: CF 5 scheduling

[Mark W. Breneman]

Please tell me that it is not so.  Please :-0.  Anyone else having problems
with CF5 scheduling?

Scheduling is not some thing I can have run most of the time.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Philip Brashear [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 1:51 PM
To: CF-Talk
Subject: Re: CF 5 scheduling


I've had trouble with 5 and schedule routines too. I can run 'em fine
manually, but when the time comes for the server to run 'em, the
time just comes ... and goes. Nothing.


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: CF 5 scheduling

[Michael Dinowitz]

Did you import the old keys from the registry? You may have over-written the
HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Schedule\Scrip
t key. This is the script to be run for a scheduled event.


> I've had trouble with 5 and schedule routines too. I can run 'em fine
> manually, but when the time comes for the server to run 'em, the
> time just comes ... and goes. Nothing.
>
>
> 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: CF 5 scheduling

[Philip Brashear]

I've had trouble with 5 and schedule routines too. I can run 'em fine
manually, but when the time comes for the server to run 'em, the
time just comes ... and goes. Nothing.


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

RDS Service

[Nick McClure]

When the RDS Service is disabled, the CF Executive service still tries to 
start it. Is there anyway to keep the Executive from trying to start the 
RDS Service.

It tries to start it every 2 seconds and this quickly fills up the log file.

--
Nick McClure
TransDigital Solutions


~~
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: synchronizing servers

[Michael Lugassy]

I'm trying to synchronize about 14,000 directories and over 500,000 files between two 
server.
10% of the files are changed daily, the rest are changed each 2, 3 or 5 days.

anyone know a good program that does 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: How to connect to PDF file

[Tobe Goldfinger]

George,


Here's the basic idea in a nutshell that we've used successfully.

--- You need a real working version of Adobe Acrobat (not necessarily on 
the server, just on your desktop where you're working).

Instead of creating the usual pdf file. create that file as what THEY 
call a 'form'ie Adobe lets you create areas on the page that are 
substituted with variable values.

I don't remember the details of how you create this but what you end up 
with is a PDF file that's your printable document with variables as 
placeholders... and then an FDF file that has the data values for each 
of the variables.

Essentially it's the same concept as how you would think of mail-merge in a 
word-processing program. One file to hold the document (w/ variables 
placeholders) and another file to hold the data that needs to be 
mail-merged into the document.


--- Now all you need your CF code to do is create the FDF file on-the-fly!

This is not hard to do because if you've generated the fdf file already 
using Adobe, just open it up in any ascii editor and see what makes it tick.

There's all kinds of hex crap on top you just copy AS-IS, followed by a 
series of lines for all the variables and their values (which you generate 
as appropriate), followed by a very important line that indicates to the 
fdf file where its mate the 'pdf' file is actually located on the SERVER, 
followed by some closing lines that you copy AS-IS.

After you've dynamically created the fdf file on the server, you actually 
go directly to it with a CFLOCATION, and the fdf file will find its mate 
(the pdf file) and do the merge.

Then your browser will be looking at the fully-merged pdf file and be ready 
for all the usual pdf activities (view, print).


Caveats:

-- the variable names are case-sensitive. be sure to spell them EXACTLY 
the same way in your generated fdf file as the pdf file is expecting them.

-- the line in the fdf file where you identify WHERE the pdf file is 
located... when you first look at your Adobe-generated fdf file this is 
going to be a regular pathname/filename on your hard drive, but since 
you're doing this work really from a browser-request, you have to change 
this to be an http reference to the pdf file

IE use: http://www.yoursite.com/holdfiles/xxx.pdf
NOT c:\inetpub\wwwroot\yoursite\holdfiles\xxx.pdf


hth,
Tobe Goldfinger
jdt technologies, ltd.
921 Peninsula Blvd
Woodmere, NY 11598
516-569-5606
800-252-5519

* Allaire Alliance Consulting Partner
* Co-Manager NY ColdFusion User's Group





At 04:59 PM 6/19/2001 , you wrote:
>Hi,
>I want draw some data from database with CF, and then put the data to PDF 
>file, is this possible?
>If anyone can help me, I will  very appreciate.
>
>thanks.
>


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

How to connect to PDF file

[George Dong]

Hi, 
I want draw some data from database with CF, and then put the data to PDF file, is 
this possible?
If anyone can help me, I will  very appreciate.

thanks.


~~
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: CF Memory Spike

[tom muck]

Have you installed anything recently?  Some older versions of MDAC will
cause the CF server to go haywire.  This turned out to be the problem on our
machine.  After installing the latest CF update to the server, the MDAC was
modified in the process and wreaked havoc on the machine.  I just downloaded
the MDAC 2.5 and everything was fine after that.

tom

"Lewis Steven" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> What would cause the CF Memory to all of a sudden spike?
>
> Steven Lewis




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

query

[Jones, Becky]

the query i wrote below gives me a list of users that are assigned to an
application.  
my question is, how do i get the list of 400 or so users that ARE NOT
assigned to that application to display somewhere else on the page so i
could then check a box to add them?  i quess i could write a second query
that would show me all users, but how would i get it on the page that i
would just display everyone but those users from the first query?
thanks for your help,
bec.


SELECT  qryIAPeople.*, 
tblLicense.Password, 
tblLicense.FileSrvr, 
tblLicense.Expiration, 
tblLicense.Quantity, 
tblLicense.SerialNum, 
tblLicense.LicenseKey, 
tblLicense.LicenseID, 
tblLicense.LAddInfo, 
tblApplications.AppName, 
tblApplications.AppVersion, 
tblApplications.AppDesc, 
tblApplications.AppQuantity, 
tblApplications.AddInfo, 
tblCompanyInfo.CompanyNm, 
tblCompanyInfo.CompanyPhone
FROM qryIAPeople INNER JOIN ((tblCompanyInfo INNER
JOIN ((tblAppIAUsers INNER JOIN tblApplications ON tblAppIAUsers.AppID =
tblApplications.AppID) 
INNER JOIN tblCompApps ON
tblApplications.AppID = tblCompApps.AppID) 
ON tblCompanyInfo.CompanyID =
tblCompApps.CompanyID) 
INNER JOIN tblLicense ON
tblApplications.AppID = tblLicense.AppID) 
ON qryIAPeople.LISTING_ID =
tblAppIAUsers.Listing_ID
WHERE   tblApplications.AppID = #url.AID#
ORDER by qryIAPeople.LAST_NM, qryIAPeople.FIRST_NM
  


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited. 



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

Shoping cart code

[Rick Johnson]

Hi Guys,
Can you please tell me the sites where I can find
Robust Shopping cart code in Coldfusion..

Many Thanks,
Rick
~~
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: XML with ColdFusion

[David Hannum]

With SOXML, you can output just like any other query, thus, you can add
style sheets.

Dave


- Original Message -
From: ibtoad <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 11:49 AM
Subject: RE: XML with ColdFusion


> I am glad you brought up this tag.  I am curently playing around with it.
I
> have no problem getting xml from a query using cf2xml, my question is how
> can I add a style sheet to the output to display html.  I keep getting
> errors.  Is this even possible?
> Rich
>
> -Original Message-
> From: Russell Brown [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 19, 2001 10:40 AM
> To: CF-Talk
> Subject: RE:XML with ColdFusion
>
>
> Hi,
> Have a look at siteobjects.com's soxml tag (also available at the allaire
> tag gallery) It use cfobject to invoke an instance of the msxml parser and
> run the methods, (just like asp!).
>
> I have a version that uses xerces instead of msxml (in case you have
> Linux/Solaris CF server) if you want it, mail me off list and I can send
it
> to you (Its not in tag gallery yet as it is not fully featured yet)
>
>
> Russell Brown
> Internet Application Developer
> Freeserve.com Plc, PO Box 452, Leeds LS2 7EY
> Telephone: 0113 207 1203
>
>
> 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

CFEXECUTE and buffers?

[Larry W. Virden]

We encountered a rather bizarre situation where we were executing a shell
command from cfexecute and were getting back only a portion of the
output produced, followed by a timeout - regardless of how long we set
the timeout value.  Only when we had the shell write to a file, and then
had coldfusion read that file, were we able to get all the output.

This seems rather unusual - I suspect that coldfusion was waiting for
some event before reading all of the output.  Is there some trick to
getting coldfusion to perform the appropriate buffer flush/reads?
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden  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

Re: CF Memory Spike

[Michael Dinowitz]

Actually, yesterday I had a big spike on a development machine. It turned
out that I was calling a custom tag that did not exist. The machine must
have been searching for it and trying everything it could to find it. After
a little time the spike went down.


> As far as i know, no one has figured this out.  It happens every once and
a
> while.
>
> Some people say clean out the undelivered mail in the mail folder under
the
> cfusion directory, and reboot the machine.
>
>
> At 12:00 PM 6/19/2001 -0400, you wrote:
> >What would cause the CF Memory to all of a sudden
> >spike?
> >
> >Steven Lewis
> >
> >
> >
> >
>
~~
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: CF Memory Spike

[Chad Gray]

As far as i know, no one has figured this out.  It happens every once and a 
while.

Some people say clean out the undelivered mail in the mail folder under the 
cfusion directory, and reboot the machine.


At 12:00 PM 6/19/2001 -0400, you wrote:
>What would cause the CF Memory to all of a sudden 
>spike?
>
>Steven Lewis
>
>
>
>
~~
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