Re: Generating HTML

[David Collie (itndac)]

>> I am trying to generate some HTML via CF and I want the HTML to come
out 
>> clean. But I end up with lots of whitespace and for the life of me, I
can 
>> not get proper indentation due to all the CFIFS and related CF code.
I have 
>> tried using CFSETTING ENABLECFOUTPUTONLY="NO", but I still end up
with 
>> strange indents and such. I use CFSAVECONTENT for some blocks and
then 
>> include the resulting HTML within more HTML. 
>> 
>> Does any one know of any tricks to get the resulting HTML to be clean
and 
>> properly intended? 

> You could try to take the value of the buffer in OnRequestEnd, pass it

> to a cleanup script (such as the Java version of the HTML Tidy engine)

> and return the result from that instead of the original value. YMMV 
>
> Jochem 

Jochem,

Could this sort of method be used to auto add headers/footers to CFMAIL?
Just a thought

DC

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFDIRECTORY over a LAN

[Neil Middleton]

Guys (and gals),

I've been getting some performance problems with cfdirectory of recent.
Basically I have written a recursive directory listing function which
returns me a query of all the files below a certain folder.  This all seems
to work perfectly.

However, recently the number of files being found has reached approx 2000
causing this list process to take nearly a minute to run(!).  The
environment is CFMX on Win2K, reading directories on another machine on the
LAN. When reading local directories, it runs quite fast (~1 sec).

Thing is, does anyone know anything about how CFDIRECTORY works at a system
level??  I am trying to work out which is the best option available to
me..either upgrading the LAN between the two machines, or running some sort
of process on the machine hosting the files (some sort of .exe or maybe even
CFMX), or something else altogether.

TIA

Neil

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Generating HTML

[Jochem van Dieten]

David Collie (itndac) wrote:
> 
>>You could try to take the value of the buffer in OnRequestEnd, pass it
>>to a cleanup script (such as the Java version of the HTML Tidy engine)
>>and return the result from that instead of the original value. YMMV 

> Could this sort of method be used to auto add headers/footers to CFMAIL?
> Just a thought

Not in a generalized way at the end of the request, you would have to 
modify all cfmail tags.

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Generating HTML

[Hugo Ahlenius]

To auto add headers/footers to cfmail, I would create a wrapper custotag
cf_mailplus or something that would do that, and invoke (and pass
parameters on to) cfmail...




-
Hugo Ahlenius  E-Mail: [EMAIL PROTECTED]
Project OfficerPhone:+46 8 230460
UNEP GRID-Arendal  Fax:  +46 8 230441
Stockholm Office   Mobile: +46 733 467111
   WWW:   http://www.grida.no
- 






| -Original Message-
| From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
| Sent: Thursday, June 12, 2003 11:00
| To: CF-Talk
| Subject: Re: Generating HTML
|
|
| David Collie (itndac) wrote:
| >
| >>You could try to take the value of the buffer in
| OnRequestEnd, pass it
| >>to a cleanup script (such as the Java version of the HTML
| Tidy engine)
| >>and return the result from that instead of the original value. YMMV
|
| > Could this sort of method be used to auto add
| headers/footers to CFMAIL?
| > Just a thought
|
| Not in a generalized way at the end of the request, you would have to
| modify all cfmail tags.
|
| Jochem
|
|
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFDIRECTORY over a LAN

[webguy]

Questions ..

Is it a mapped drive or UNC path?
DHCP or fixed ip addresses ?
ip/tcp or netbios etc?
You using an ip address or a machine name?
Using DNS or other to lookup that name ?

What else is the box with the files? Is it tuned for file server or
whatever?

WG

-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED]
Sent: 12 June 2003 09:54
To: CF-Talk
Subject: CFDIRECTORY over a LAN


Guys (and gals),

I've been getting some performance problems with cfdirectory of recent.
Basically I have written a recursive directory listing function which
returns me a query of all the files below a certain folder.  This all seems
to work perfectly.

However, recently the number of files being found has reached approx 2000
causing this list process to take nearly a minute to run(!).  The
environment is CFMX on Win2K, reading directories on another machine on the
LAN. When reading local directories, it runs quite fast (~1 sec).

Thing is, does anyone know anything about how CFDIRECTORY works at a system
level??  I am trying to work out which is the best option available to
me..either upgrading the LAN between the two machines, or running some sort
of process on the machine hosting the files (some sort of .exe or maybe even
CFMX), or something else altogether.

TIA

Neil


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFDIRECTORY over a LAN

[Neil Middleton]

The calls are over UNC using a machine name (so therefore NETBIOS).

The server is a file server.

Neil

> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2003 10:55
> To: CF-Talk
> Subject: RE: CFDIRECTORY over a LAN
> 
> 
> Questions ..
> 
> Is it a mapped drive or UNC path?
> DHCP or fixed ip addresses ?
> ip/tcp or netbios etc?
> You using an ip address or a machine name?
> Using DNS or other to lookup that name ?
> 
> What else is the box with the files? Is it tuned for file server or
> whatever?
> 
> WG
> 
> -Original Message-
> From: Neil Middleton [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2003 09:54
> To: CF-Talk
> Subject: CFDIRECTORY over a LAN
> 
> 
> Guys (and gals),
> 
> I've been getting some performance problems with cfdirectory 
> of recent.
> Basically I have written a recursive directory listing function which
> returns me a query of all the files below a certain folder.  
> This all seems
> to work perfectly.
> 
> However, recently the number of files being found has reached 
> approx 2000
> causing this list process to take nearly a minute to run(!).  The
> environment is CFMX on Win2K, reading directories on another 
> machine on the
> LAN. When reading local directories, it runs quite fast (~1 sec).
> 
> Thing is, does anyone know anything about how CFDIRECTORY 
> works at a system
> level??  I am trying to work out which is the best option available to
> me..either upgrading the LAN between the two machines, or 
> running some sort
> of process on the machine hosting the files (some sort of 
> .exe or maybe even
> CFMX), or something else altogether.
> 
> TIA
> 
> Neil
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFDIRECTORY over a LAN

[webguy]

Hi,
Have you tried using a the IP address out of interest? Any firewalls
between the boxes?

WG

-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED]
Sent: 12 June 2003 10:51
To: CF-Talk
Subject: RE: CFDIRECTORY over a LAN


The calls are over UNC using a machine name (so therefore NETBIOS).

The server is a file server.

Neil

> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2003 10:55
> To: CF-Talk
> Subject: RE: CFDIRECTORY over a LAN
>
>
> Questions ..
>
> Is it a mapped drive or UNC path?
> DHCP or fixed ip addresses ?
> ip/tcp or netbios etc?
> You using an ip address or a machine name?
> Using DNS or other to lookup that name ?
>
> What else is the box with the files? Is it tuned for file server or
> whatever?
>
> WG
>
> -Original Message-
> From: Neil Middleton [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2003 09:54
> To: CF-Talk
> Subject: CFDIRECTORY over a LAN
>
>
> Guys (and gals),
>
> I've been getting some performance problems with cfdirectory
> of recent.
> Basically I have written a recursive directory listing function which
> returns me a query of all the files below a certain folder.
> This all seems
> to work perfectly.
>
> However, recently the number of files being found has reached
> approx 2000
> causing this list process to take nearly a minute to run(!).  The
> environment is CFMX on Win2K, reading directories on another
> machine on the
> LAN. When reading local directories, it runs quite fast (~1 sec).
>
> Thing is, does anyone know anything about how CFDIRECTORY
> works at a system
> level??  I am trying to work out which is the best option available to
> me..either upgrading the LAN between the two machines, or
> running some sort
> of process on the machine hosting the files (some sort of
> .exe or maybe even
> CFMX), or something else altogether.
>
> TIA
>
> Neil
>
>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFDIRECTORY over a LAN

[Neil Middleton]

no firewalls, and I haven't tried using an IP Address.

I will run the test over IP and see if it makes a big difference or not.

> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2003 11:04
> To: CF-Talk
> Subject: RE: CFDIRECTORY over a LAN
> 
> 
> Hi,
>   Have you tried using a the IP address out of interest? 
> Any firewalls
> between the boxes?
> 
> WG
> 
> -Original Message-
> From: Neil Middleton [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2003 10:51
> To: CF-Talk
> Subject: RE: CFDIRECTORY over a LAN
> 
> 
> The calls are over UNC using a machine name (so therefore NETBIOS).
> 
> The server is a file server.
> 
> Neil
> 
> > -Original Message-
> > From: webguy [mailto:[EMAIL PROTECTED]
> > Sent: 12 June 2003 10:55
> > To: CF-Talk
> > Subject: RE: CFDIRECTORY over a LAN
> >
> >
> > Questions ..
> >
> > Is it a mapped drive or UNC path?
> > DHCP or fixed ip addresses ?
> > ip/tcp or netbios etc?
> > You using an ip address or a machine name?
> > Using DNS or other to lookup that name ?
> >
> > What else is the box with the files? Is it tuned for file server or
> > whatever?
> >
> > WG
> >
> > -Original Message-
> > From: Neil Middleton [mailto:[EMAIL PROTECTED]
> > Sent: 12 June 2003 09:54
> > To: CF-Talk
> > Subject: CFDIRECTORY over a LAN
> >
> >
> > Guys (and gals),
> >
> > I've been getting some performance problems with cfdirectory
> > of recent.
> > Basically I have written a recursive directory listing 
> function which
> > returns me a query of all the files below a certain folder.
> > This all seems
> > to work perfectly.
> >
> > However, recently the number of files being found has reached
> > approx 2000
> > causing this list process to take nearly a minute to run(!).  The
> > environment is CFMX on Win2K, reading directories on another
> > machine on the
> > LAN. When reading local directories, it runs quite fast (~1 sec).
> >
> > Thing is, does anyone know anything about how CFDIRECTORY
> > works at a system
> > level??  I am trying to work out which is the best option 
> available to
> > me..either upgrading the LAN between the two machines, or
> > running some sort
> > of process on the machine hosting the files (some sort of
> > .exe or maybe even
> > CFMX), or something else altogether.
> >
> > TIA
> >
> > Neil
> >
> >
> >
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFMX and JSP connections

[Thomas Chiverton]

On Tuesday 10 Jun 2003 21:17 pm, CF Dude wrote:
> It seems that CF5 was able to connect even more than previous versions. 
> Now I'm starting to get the feeling that CFMX can only connect to
> datasources that Java can connect to.
> I was all excited about DSN-less connections in CF5, but now I'm wondering
> if that only works for sources that a JDBC provider exists for.

There is a JDBC provider for everything. Problem solved.

-- 
Tom C
"Land of the free, home of the brave... you have to be brave to live there and 
enjoy the freedoms"
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: Royale Info Online

[Chris Kief]

Thanks to Mesh for posting this link to his blog...

http://www.macromedia.com/special/royale/

"Royale is the internal code name for a new initiative at Macromedia that
will address the requirements of enterprise programmers who want to develop
rich client applications. Rich client applications combine the
responsiveness and richness of desktop software with the broad reach of web
applications to deliver a more effective end-user experience. Royale will
deliver a standards-based, declarative, JSP-style programming methodology
and workflow, as well as runtime services for developing and deploying the
presentation tier of rich client applications."

Cheers,
chris


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: saving textarea input to rtf

[Bryan Love]

??? As far as I know you can't put bold and italics in a text area.

+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Andrew Henry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 8:17 PM
To: CF-Talk
Subject: saving textarea input to rtf


Hi,

Somewhat of a newbie question I expect.

I have to save input from a textarea, in which the user has the opportunity
to alter the text in the area(e.g. bold, italic), into an rtf file. That is
to say, I need to save what the user sees in the textarea into an rtf file
so that when the user opens the rtf file, from say "Word" the bold and
italicized text are retained. 

Thanks for any ideas you have to offer.

Cheers,

Andrew Henry



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Checkbox woes

[Eric Creese]

I figured out the issue after some sleep. I was using a method of get for the form and 
the vars in my action page were looking for form. not url.

Sleep does has it's puurpose!
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Generating HTML

[David Collie (itndac)]

Was just a thought from Jochem's original answer to the post 

Would save a lot of hassle in retrofitting  a whole pile of legacy
cfmail's for me... :-(

Oh well, could only dream, 

Cheers all DC

> | David Collie (itndac) wrote:
> | >
> | >>You could try to take the value of the buffer in
> | OnRequestEnd, pass it
> | >>to a cleanup script (such as the Java version of the HTML
> | Tidy engine)
> | >>and return the result from that instead of the original 
> value. YMMV
> |
> | > Could this sort of method be used to auto add
> | headers/footers to CFMAIL?
> | > Just a thought
> |
> | Not in a generalized way at the end of the request, you 
> would have to 
> | modify all cfmail tags.
> |
> | Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Testing...

[Ian Lurie]

Sorry, just testing. Is the list up?


Portent Interactive
An Internet Marketing Agency
http://www.portentinteractive.com
http://www.searchengineoptimization.cc

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFDIRECTORY over a LAN

[Kym Kovan]

Hi Neil,

We have run into similar problems with log reading engines using CFX_ReadLine. We 
found that on the local machine the reads of, say, a thousand lines from one log file 
on a local machine was a small fraction of a second whereas over a network connection 
it took many seconds. We experimented with connection type and used many versions of 
OS, the result always the same, so we assumed it was a function of networking files, 
caching, etc., and now run the reading templates locally on every machine.


--

Yours,

Kym

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: query question

[Robert Shaw]

Thanks for the responses. I know which query it is so fixing it is in the 
works, one of my colleagues is also looking into it. I still don't think it 
makes sense that the query going to a database on a different server woud 
cause CF to spike, I'd think it would cause the database server's cpu to 
spike. But if anyone has any other feedback as to why this would hapen and 
if it is expected behavior we'd appreciate the input.

TIA,
Rob


We have watched the web-server spike up to 100 percent utilization on
cumbersome queries before (afterward the page was modified to reduce the
number of results returned). Im not sure if this is supposed to happen but
it did.

Casey Cook

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose.


_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Email BroadCasting

[Chad]

We are looking for an email broadcast and scheduling module that can be
integrated into a Coldfusion application. Ideally, the module needs to be
able to schedule a broadcast close to a predetermined time and date and
handle bounce backs of hard and soft bounces. Any information would be
helpful.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

preloader issue

[Turetsky, Seth]

I followed this thread and it works fine for me in Flash MX(exporting to Flash 5), I 
used option 2(if it matters)  http://chattyfig.figleaf.com/ezmlm/ezmlm-cgi/1/62096
Basically, I'm working with a ton of images in mc's with linkage id's and not 
exporting on first frame, so I can have a preloader.

Co-worker is editing in Flash 5, and I guess all mc's default to exporting to the 
first frame.  Preloader doesn't work while testing.

So, my question is if Flash MX exporting this to ver5 is really going to have the 
working preloader.

hope that makes sense and someone can enlighten me

thanks,
seth

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFC Self Documentation

[Ian Skinner]

What does this mean, when I try to view my CFC's self documentation?

Component not found
The component definition file for component 'test' cannot be found on this
server. 

--
Ian Skinner
Web Programmer
BloodSource
Sacramento, CA

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Stoneage Print Server Resend

[Ian Lurie]

Hi all,

This didn't reach the list this morning and I need HELP, so I'm 
resending. Sorry...

Does anyone know how I can get a copy of Stoneage Print Server? Their 
site appears to be down/gone/defunct. I desperately need their software 
for an application.

Any help would be greatly appreciated.

Ian

Portent Interactive
An Internet Marketing Agency
http://www.portentinteractive.com
http://www.searchengineoptimization.cc

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Email BroadCasting

[Howie Hamlin]

iMS-SE can do this.  iMS-SE comes with a mail sending engine, scheduler and bounce 
mail processing engine.  More info is at www.coolfusion.com

Regards,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
((())) PrismAV is Coming ((()))
>>> Please vote for iMS here: 
>>> http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm 
>>> Find out how iMS Stacks up to the competition: 
>>> http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: "Chad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 1:38 PM
Subject: Email BroadCasting


> We are looking for an email broadcast and scheduling module that can be
> integrated into a Coldfusion application. Ideally, the module needs to be
> able to schedule a broadcast close to a predetermined time and date and
> handle bounce backs of hard and soft bounces. Any information would be
> helpful.
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFMX and Chinese

[Matt Robertson]

Never mind the fact that I don't speak or read Chinese... I have to
build an app that does.  I've looked around and apparently this is a
requirement to get the pages to work right, although I'm not clear on
whether this is simplified or traditional Chinese:

(goes on every page)


(Goes in application.cfm)


 

What about db inserts, updates and output?  Whats the Big5 charset and
is it relevant/better than GB2312?  Utf-8?  Or are they all
interchangeable?  Will some types of text fields not work with Chinese
chars (I've heard some oblique refs about how 'n' type fields are bad
but no specifics or workarounds).  I would want to run this on mySQL and
CFMX if possible.

Seems like this is a fairly simple task (in MX) where there is no single
set of start-finish instructions; or none that I've found yet at least.

Bah, if ingnorance is bliss I should be in Nirvana.


 Matt Robertson   [EMAIL PROTECTED] 
 MSB Designs, Inc.  http://mysecretbase.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: session locking ?

[Dave Lyons]

thanks Jim


- Original Message -
From: "Jim Davis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 12:49 AM
Subject: RE: session locking ?


> If you'd like more information on locking I've a guide here (watch the
> wrap):
>
> http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/
>
> It's applicable directly to CF 5 and below.  The techniques are still
> applicable to CFMX, but the warnings about server stability don't apply.
>
> Hope you like it.
>
> Jim Davis
> President, http://www.depressedpress.com
> Webmaster, http://www.firstnight.org
> Webmaster, http://www.cfAdvocacy.org
> Senior Consultant, http://www.metlife.com
>
>
> > -Original Message-
> > From: Dave Lyons [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, June 11, 2003 11:47 PM
> > To: CF-Talk
> > Subject: Re: session locking ?
> >
> > cool, i hadn't read anything that said you could so I was wondering
> > (wondering wrong as always)
> >
> > Thanks
> >
> > dave
> > - Original Message -
> > From: "Matt Robertson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 11, 2003 11:00 PM
> > Subject: RE: session locking ?
> >
> >
> > > You mean ''session variables'' right?  You can and should always
> combine
> > > cflocks where you can.  Saves overhead.
> > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > >
> > > HtH,
> > >
> > > 
> > >  Matt Robertson   [EMAIL PROTECTED]
> > >  MSB Designs, Inc.  http://mysecretbase.com
> > > 
> > >
> > > -Original Message-
> > > From: Dave Lyons [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, June 11, 2003 7:59 PM
> > > To: CF-Talk
> > > Subject: session locking ?
> > >
> > >
> > > do you need to lock each session separately?
> > > for example, I want to set 3 sessions on a successful login, I'm
> > > assuming they need to be separately locked but I thought I'd ask
> > >
> > > dave
> > >
> > >
> > >
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Email BroadCasting

[Michael Dinowitz]

Best thing I'd suggest is get a copy of iMS (www.coolfusion.com) and use the
scheduler to schedule a mail blast. When using the CFX that sets the mail, set
the return path in it to whatever you want to track. Then you set a chunk of
code in the data template (one of the iMS templates written in CF that controls
incoming mail) to deal with any mail that comes to the bounce account.
This list runs on iMS and it's solid as anything.

(this list also uses an old post.office to receive mail due to legacy issues
that I have to deal with and the P.O blew up resulting in the mail delay today.)


> We are looking for an email broadcast and scheduling module that can be
> integrated into a Coldfusion application. Ideally, the module needs to be
> able to schedule a broadcast close to a predetermined time and date and
> handle bounce backs of hard and soft bounces. Any information would be
> helpful.
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: preloader issue

[Turetsky, Seth]

woops, wrong list, sorry

-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 1:38 PM
To: CF-Talk
Subject: preloader issue


I followed this thread and it works fine for me in Flash MX(exporting to Flash 5), I 
used option 2(if it matters)  http://chattyfig.figleaf.com/ezmlm/ezmlm-cgi/1/62096
Basically, I'm working with a ton of images in mc's with linkage id's and not 
exporting on first frame, so I can have a preloader.

Co-worker is editing in Flash 5, and I guess all mc's default to exporting to the 
first frame.  Preloader doesn't work while testing.

So, my question is if Flash MX exporting this to ver5 is really going to have the 
working preloader.

hope that makes sense and someone can enlighten me

thanks,
seth

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



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFHTTP Issue

[Ciliotta, Mario]

Hi,

I was wondering if someone could help me with a CFHTTP issue.  We have 2 servers that 
are behind a distributed director and one server one the CFHTTP call works correctly 
and on server two the CFHTTP call gets a Connection Failure message.  

Does anyone have any idea of what the problem might be.  It was working for the 
longest time and according to our Web Services guys, nothing on the servers has 
changed.  The servers are CF4.5 and NT/IIS.  Does a setting need to change in ISS or 
NT.

Thanks

Mario

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Generating HTML

[Mike Mertsock]

Another technique to try is using . Because none of your code in cfscript 
generates any output (even whitespace), you can have easy-to read logic without 
worrying about whitespace. Of course, when you do want to print some HTML you need to 
use the WriteOutput() function. Again, you can control precisely what WriteOutput() is 
printing.

This idea is really best, though, for an area with a significant amount of CFML and 
not much generated HTML

And also remember , which does have much more limited usefulness but you may 
find it useful for elminating whitespace, especially if you are using a lot of 
cfincludes or a methodology such as Fusebox. It's particularly useful for "settings" 
pages, like application.cfm.

Good luck

Mike Mertsock

>Don't do any indentation based on non-HTML tags.  That'll be a start.  The
>CFSAVECONTENT blocks will be more problemmatic, especially if you use a
>block multiple times, and it needs different indentation for each.  However,
>if you use them only once, or all uses need the same indentation, just make
>sure that's how they are indented when you create them.
>
>
>
>   Name
>   Date
>
>
>
>
>#header#
>
>
>   #name#
>   #date#
>
>
>#header#
>
>
>---
>Barney Boisvert, Senior Development Engineer
>AudienceCentral (formerly PIER System, Inc.)
>[EMAIL PROTECTED]
>voice : 360.756.8080 x12
>fax   : 360.647.5351
>
>www.audiencecentral.com
>
>> -Original Message-
>> From: Brook Davies [mailto:[EMAIL PROTECTED]
>> Sent: Friday, May 30, 2003 4:02 PM
>> To: CF-Talk
>> Subject: Generating HTML
>>
>>
>> Hello,
>>
>> I am trying to generate some HTML via CF and I want the HTML to come out
>> clean. But I end up with lots of whitespace and for the life of me, I can
>> not get proper indentation due to all the CFIFS and related CF
>> code. I have
>> tried using CFSETTING ENABLECFOUTPUTONLY="NO", but I still end up with
>> strange indents and such.  I use CFSAVECONTENT for some blocks and then
>> include the resulting HTML within more HTML.
>>
>> Does any one know of any tricks to get the resulting HTML to be clean and
>> properly intended?
>>
>> Brook
>>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Update on the Installer "Freeze" & Failure to Auto-Start on W indows Issues...

[Calvin Ward]

I'm thinking this communication and follow up is indeed excellent! Well done
MM and Damon!

On a side note, I missed the part about users of the list giving flak for
complaining, I thought the flak was given for the manner and tone of the
complaints.

Calvin

- Original Message - 
From: "Doug White" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 11:17 PM
Subject: Re: Update on the Installer "Freeze" & Failure to Auto-Start on W
indows Issues...


> I too, am impressed very favorably with not only the follow-up, but the
> reassurance that those of us that were experiencing problems and took
quite a
> bit of flack from other users of this list for complaining about it, were
not
> imagining the problems.
>
> It is also very re-assuring that the identification and resolution has
become a
> priority of MM, and I am really going to enjoy becoming a member of the
happy
> campers again.
>
> I now have a slick and solid running Win2003/CFMX server running and am in
the
> process of adding the free hosting of another user group, the first of
which are
> very interested in a CFMX web site.  I think it will be a showpiece when
> uploaded and goes live within the next few days.
>
> ==
> Stop spam on your domain, use our gateway!
> For hosting solutions http://www.clickdoug.com
> ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
> ==
> If you are not satisfied with my service, my job isn't done!
>
> - Original Message - 
> From: "Mike Kear" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 11, 2003 9:54 PM
> Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on W
> indows Issues...
>
>
> | This is excellent follow-up.  I'm pleased they're working on it like
> | terriers and aren't going to let it go till it's resolved.
> |
> | What Damon says would explain how come some people experience the
problem
> | and others don't, and also how come the problem went away when some
people
> | forced CFMX to load earlier in the boot-up cycle.
> |
> |
> | Cheers,
> | Michael Kear
> | Windsor, NSW, Australia
> | AFP Webworks.
|

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMX on Cobalt RaQ550

[Costas Piliotis]

Nobody has I guess?

-Original Message-
From: Costas Piliotis 
Sent: Wednesday, June 11, 2003 11:53 AM
To: CF-Talk
Subject: CFMX on Cobalt RaQ550


I have a client of mine who has colocated his server, and the colo facility
is having trouble installing cfmx onto that box running the "Linux 2.4
Multitasking operating systen" as Sun calls it.

They've apparantly installed it on other Cobalt servers, but are having
major troubles with this one...

Has anyone gotten CFMX to work on this appliance?  Anything quirky in the
installation I should be aware of?  


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFDIRECTORY over a LAN

[Calvin Ward]

I'm experiencing a similar difficulty on performance, but I've been assuming
it is network performance causing those issues.

- Original Message - 
From: "Neil Middleton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 5:58 AM
Subject: RE: CFDIRECTORY over a LAN


> no firewalls, and I haven't tried using an IP Address.
>
> I will run the test over IP and see if it makes a big difference or not.
>
> > -Original Message-
> > From: webguy [mailto:[EMAIL PROTECTED]
> > Sent: 12 June 2003 11:04
> > To: CF-Talk
> > Subject: RE: CFDIRECTORY over a LAN
> >
> >
> > Hi,
> > Have you tried using a the IP address out of interest?
> > Any firewalls
> > between the boxes?
> >
> > WG
> >
> > -Original Message-
> > From: Neil Middleton [mailto:[EMAIL PROTECTED]
> > Sent: 12 June 2003 10:51
> > To: CF-Talk
> > Subject: RE: CFDIRECTORY over a LAN
> >
> >
> > The calls are over UNC using a machine name (so therefore NETBIOS).
> >
> > The server is a file server.
> >
> > Neil
> >
> > > -Original Message-
> > > From: webguy [mailto:[EMAIL PROTECTED]
> > > Sent: 12 June 2003 10:55
> > > To: CF-Talk
> > > Subject: RE: CFDIRECTORY over a LAN
> > >
> > >
> > > Questions ..
> > >
> > > Is it a mapped drive or UNC path?
> > > DHCP or fixed ip addresses ?
> > > ip/tcp or netbios etc?
> > > You using an ip address or a machine name?
> > > Using DNS or other to lookup that name ?
> > >
> > > What else is the box with the files? Is it tuned for file server or
> > > whatever?
> > >
> > > WG
> > >
> > > -Original Message-
> > > From: Neil Middleton [mailto:[EMAIL PROTECTED]
> > > Sent: 12 June 2003 09:54
> > > To: CF-Talk
> > > Subject: CFDIRECTORY over a LAN
> > >
> > >
> > > Guys (and gals),
> > >
> > > I've been getting some performance problems with cfdirectory
> > > of recent.
> > > Basically I have written a recursive directory listing
> > function which
> > > returns me a query of all the files below a certain folder.
> > > This all seems
> > > to work perfectly.
> > >
> > > However, recently the number of files being found has reached
> > > approx 2000
> > > causing this list process to take nearly a minute to run(!).  The
> > > environment is CFMX on Win2K, reading directories on another
> > > machine on the
> > > LAN. When reading local directories, it runs quite fast (~1 sec).
> > >
> > > Thing is, does anyone know anything about how CFDIRECTORY
> > > works at a system
> > > level??  I am trying to work out which is the best option
> > available to
> > > me..either upgrading the LAN between the two machines, or
> > > running some sort
> > > of process on the machine hosting the files (some sort of
> > > .exe or maybe even
> > > CFMX), or something else altogether.
> > >
> > > TIA
> > >
> > > Neil
> > >
> > >
> > >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Displaying PDFs

[Philip Arnold]

> When displaying a .pdf file can that be accomplished by
> "calling" it from a button or does it have to be "called"
> from a image - .jpg for instance?

A hyperlink is a hyperlink, whether you put it on text or image - it's
basic HTML...

Displaying a PDF only requires 2 things;
1) the user has Acrobat Reader on their computer
2) you link to the exact path of the PDF

> onClick="window.location='http:\CVS3WP14.CFM'">

This location is incorrect - for 2 reasons
1) the web uses forward slashes (/) not back slashes (\)
2) You're referring to "CVSWP14.CFM" as though it's a site, not a page

> 

This link is also incorrect - you're going to link to a folder, not a
page, and it contains a space, which will break Netscape

> face="Arial">"/Images/#Trim(Session
> Client_ID)##Trim(Session.Insured_ID)#1.pdf"
> It displays the code not the image.  What am I doing wrong?  TIA.

It is displaying correctly for what you're asking it to...


Sorry to be blunt (and possibly rude) about this, but I suggest you
increase your HTML knowledge before you start trying to incorporate
ColdFusion into your work...




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: saving textarea input to rtf

[Philip Arnold]

> I have to save input from a textarea, in which the user has
> the opportunity to alter the text in the area(e.g. bold,
> italic), into an rtf file. That is to say, I need to save
> what the user sees in the textarea into an rtf file so that
> when the user opens the rtf file, from say "Word" the bold
> and italicized text are retained.

First point, a text area CANNOT contain bold, italics or other
formatting, it's plain text

Now, if you use a visual editor (see the "active edit alternatives"
thread), then it returns HTML

Now, Word 97 onwards read HTML files as Word docs if you put a .doc
extension on it, which is useful...



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: query question

[Philip Arnold]

> It appears a certain query of mine is causing our CPU to spike. We're
> working on the query but what is strange is that it will hose
> CF. It was my
> uderstanding that CF passes the connection off so I would
> think it would be
> normal for the database server's CPU to spike but not for CF
> to cause the
> webserver CPU to spike. If we kill the query it immediately
> goes back down.
> Does this sound right? I have not seen this happen before and
> am questioning if my logic is off.

What you have to remember is that even though CF "passes" the query to
the database server, it still has to sit and wait for the result, now,
during this time, if the data coming back is complex or too big (say
several hundred, thousand records), then it'll spike as it's trying to
get the information from ODBC/JDBC/OLEDB...

How many records are being returned, and how complex is the SQL?

If the SQL is horribly structured, or there aren't any indexes, then the
query may take ages to execute...

HTH (in some way or another)




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Checkbox woes

[Dina Hess]

I think you're just tiredovercomplicating it. Note that all I'm doing is
setting the value of the checkbox to 1. You've already got CFPARAMs to
default the values to 0, and you don't need to move those form values to the
session scope that I can see. Try this:

FORM PAGE:




  
  Books
  
  Music Items







ACTION PAGE:





SELECT sm.sid as rf1,sm.SALEADDR as rf2, sm.SALEcity as rf4,sM.saletype as
rf3, s.saledate as rf5, s.saletimefrom+' - '+saletimeto as rf6
FROM sale_master sm,  sale s
WHERE sm.sid = s.sid
AND s.saleDisplay = 'Yes'
AND sm.SALEreleased = 1
 AND sm.saleitem1 = true 
 AND sm.SALEITEM2 = true 


HTH,
~Dina



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFMX and Chinese

[Paul Hastings]

> (goes on every page)
> 
>
> (Goes in application.cfm)
> 
> 
> 

i would urge you to use unicode. it will simplify things considerably.

> What about db inserts, updates and output?  Whats the Big5 charset and
> is it relevant/better than GB2312?  Utf-8?  Or are they all

no they aren't interchangeable. big5 is "traditional" chinese, GB2312 is
"simplified" chinese. utf-8 is an encoding form of the borg-like unicode.

> interchangeable?  Will some types of text fields not work with Chinese
> chars (I've heard some oblique refs about how 'n' type fields are bad
> but no specifics or workarounds).  I would want to run this on mySQL and
> CFMX if possible.

"N" datatypes are bad? news to me & sql server i18n developers, so lets call
that nonsense. mySQL? doesn't handle unicode yet (i think). the big iron
(sql server, oracle, postgreSQL, etc.) dbs have better i18n functionality
than mysql. i'd experiment w/mysql plenty first. you should get a good set
of test text data from your clients. there's a modest FAQ on CJK here:
http://www.unicode.org/faq/han_cjk.html

don't forget about dates, numeric, currency formatting as well.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

The DBMS returned an unspecified error

[Tim Do]

Hello all,
 
I'm been struggling with this for about a day now.  I'm getting this error
message: "[Macromedia][SQLServer JDBC Driver]The DBMS returned an
unspecified error."  when I call a stored proc.  When I do a trace, it shows
that it ran fine.  I can execute it through query analyzer also.  Any
ideas??
 
Thanks,
Tim
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: saving textarea input to rtf

[Andrew Henry]

Hi Bryan,

According to this article I can, though I haven't yet got it working myself
it seems possible.

http://www.oreillynet.com/pub/a/javascript/2001/12/21/js_toolbar.html

I know the UI functionality comes from JavaScript but everything else is
done with CF. So ultimately the user can markup the text in the text area,
and I need to save it as rtf.

Thanks for any advice

Cheers,

Andrew

- Original Message -
From: "Bryan Love" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 1:07 PM
Subject: RE: saving textarea input to rtf


> ??? As far as I know you can't put bold and italics in a text area.
>
> +---+
> Bryan Love
>   Database Analyst
>   Macromedia Certified Professional
>   Internet Application Developer
> TeleCommunication Systems
> [EMAIL PROTECTED]
> +---+
>
> "...'If there must be trouble, let it be in my day, that my child may have
> peace'..."
> - Thomas Paine, The American Crisis
>
> "Let's Roll"
> - Todd Beamer, Flight 93
>
>
>
> -Original Message-
> From: Andrew Henry [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 8:17 PM
> To: CF-Talk
> Subject: saving textarea input to rtf
>
>
> Hi,
>
> Somewhat of a newbie question I expect.
>
> I have to save input from a textarea, in which the user has the
opportunity
> to alter the text in the area(e.g. bold, italic), into an rtf file. That
is
> to say, I need to save what the user sees in the textarea into an rtf file
> so that when the user opens the rtf file, from say "Word" the bold and
> italicized text are retained.
>
> Thanks for any ideas you have to offer.
>
> Cheers,
>
> Andrew Henry
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF / Excel / Ranges

[Michael Tangorre]

What would be the easiest way to import an excel sheet into SQL 2K.
The excel sheet contains the following:

Country name
Country abbreviation
Country code
>From Phone Number
To Phone Number

Thanks,

Mike

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Stoneage Print Server

[Ian Lurie]

Hi all,

I'm trying to get in touch with Stoneage (www.stoneagesoftware.com) to 
buy a copy of their print server. Their site's down. I'm in kind of a 
hurry - anyone know how I can reach them?

Ian


Portent Interactive
An Internet Marketing Agency
http://www.portentinteractive.com
http://www.searchengineoptimization.cc

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Pagination (Next n records) for an inner join and grouped output...

[Jeff]

I've got an inner join that I'm trying to make work with paging the records
and I *think* I see what the problem is, but I don't know how to proceed...

The inner joins are working correctly. In fact, when I go to output, I
simply group them by property ID, and I get the right number of Properties,
and the right rates for each property...but the pagination is ALL wonky. I'm
using Dreamweaver's Next N results, which is fairly easy to understand, and
normally works great...

Here's my query:


SELECT *
FROM (tblRentalLocations INNER JOIN tblRentalProperties ON
tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID)
INNER JOIN tblRentalRates ON
tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID

WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms#

ORDER BY tblRentalProperties.PropertyName,
tblRentalRates.RatesOrder,
tblRentalRates.RatesLength Desc



My Next N code looks like this:







  


Now, here's where it gets wonky. On the query, the actual recordcount is the
total number of rows returned, when I use the grouped output and nest my
cfoutput tags, it works perfectly, but it gives me a wrong "recordCount" and
that, in turn, throws the next n browsing all to heck and back. I THINK I
should somehow be totalling the number of unique PropertyIDs there are in
the query, and use that instead of "recordCount"...am I on the right track?
I tried COUNT(PropertyID) AS PropertyCount but that didn't work, it won't
let you use that AND a * in the same query, and when I went to all the
trouble to place all my fieldnames in there, it didn't work either...

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Pagination (Next n records) for an inner join and grouped out put...

[Costas Piliotis]

This is really one place SQL Server can learn from MySQL...  A LIMIT
function would be perfect...

Why not just use the maxrows and startrow function in the cfquery tag?  For
the most part it works quite well actually...  

-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 11:22 AM
To: CF-Talk
Subject: Pagination (Next n records) for an inner join and grouped output...


I've got an inner join that I'm trying to make work with paging the records
and I *think* I see what the problem is, but I don't know how to proceed...

The inner joins are working correctly. In fact, when I go to output, I
simply group them by property ID, and I get the right number of Properties,
and the right rates for each property...but the pagination is ALL wonky. I'm
using Dreamweaver's Next N results, which is fairly easy to understand, and
normally works great...

Here's my query:


SELECT *
FROM (tblRentalLocations INNER JOIN tblRentalProperties ON
tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID)
INNER JOIN tblRentalRates ON
tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID

WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms#

ORDER BY tblRentalProperties.PropertyName,
tblRentalRates.RatesOrder, tblRentalRates.RatesLength Desc



My Next N code looks like this:







  


Now, here's where it gets wonky. On the query, the actual recordcount is the
total number of rows returned, when I use the grouped output and nest my
cfoutput tags, it works perfectly, but it gives me a wrong "recordCount" and
that, in turn, throws the next n browsing all to heck and back. I THINK I
should somehow be totalling the number of unique PropertyIDs there are in
the query, and use that instead of "recordCount"...am I on the right track?
I tried COUNT(PropertyID) AS PropertyCount but that didn't work, it won't
let you use that AND a * in the same query, and when I went to all the
trouble to place all my fieldnames in there, it didn't work either...


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Stoneage Print Server

[Marius Milosav]

try:
[EMAIL PROTECTED]

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm

- Original Message -
From: "Ian Lurie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 12:07 PM
Subject: Stoneage Print Server


> Hi all,
>
> I'm trying to get in touch with Stoneage (www.stoneagesoftware.com) to
> buy a copy of their print server. Their site's down. I'm in kind of a
> hurry - anyone know how I can reach them?
>
> Ian
>
>
> Portent Interactive
> An Internet Marketing Agency
> http://www.portentinteractive.com
> http://www.searchengineoptimization.cc
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Testing...

[Michael Dinowitz]

The drive containing the mails server got filled up and stopped the mail from
being received and processed. I've fixed it.


> Sorry, just testing. Is the list up?
>
>
> Portent Interactive
> An Internet Marketing Agency
> http://www.portentinteractive.com
> http://www.searchengineoptimization.cc
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Pagination (Next n records) for an inner join and grouped out put...

[Bryan Love]

I've run into this one before and it sucks.  Your best bet, if you want the
number of unique property ids is to run another query that does a 
SELECT COUNT DISTINCT propertyID AS pCount...

But whether or not it will work to use this number as the recordcount is
anyone's guess.  You may have to keep track manually.

+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 11:22 AM
To: CF-Talk
Subject: Pagination (Next n records) for an inner join and grouped
output...


I've got an inner join that I'm trying to make work with paging the records
and I *think* I see what the problem is, but I don't know how to proceed...

The inner joins are working correctly. In fact, when I go to output, I
simply group them by property ID, and I get the right number of Properties,
and the right rates for each property...but the pagination is ALL wonky. I'm
using Dreamweaver's Next N results, which is fairly easy to understand, and
normally works great...

Here's my query:


SELECT *
FROM (tblRentalLocations INNER JOIN tblRentalProperties ON
tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID)
INNER JOIN tblRentalRates ON
tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID

WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms#

ORDER BY tblRentalProperties.PropertyName,
tblRentalRates.RatesOrder,
tblRentalRates.RatesLength Desc



My Next N code looks like this:







  


Now, here's where it gets wonky. On the query, the actual recordcount is the
total number of rows returned, when I use the grouped output and nest my
cfoutput tags, it works perfectly, but it gives me a wrong "recordCount" and
that, in turn, throws the next n browsing all to heck and back. I THINK I
should somehow be totalling the number of unique PropertyIDs there are in
the query, and use that instead of "recordCount"...am I on the right track?
I tried COUNT(PropertyID) AS PropertyCount but that didn't work, it won't
let you use that AND a * in the same query, and when I went to all the
trouble to place all my fieldnames in there, it didn't work either...


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Stoneage Print Server Resend

[Matthew Small]

I think I've got a trial copy around here somewhere - would that help?

Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
 

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 1:43 PM
To: CF-Talk
Subject: Stoneage Print Server Resend

Hi all,

This didn't reach the list this morning and I need HELP, so I'm 
resending. Sorry...

Does anyone know how I can get a copy of Stoneage Print Server? Their 
site appears to be down/gone/defunct. I desperately need their software 
for an application.

Any help would be greatly appreciated.

Ian

Portent Interactive
An Internet Marketing Agency
http://www.portentinteractive.com
http://www.searchengineoptimization.cc


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFMX and Chinese

[Jochem van Dieten]

Matt Robertson wrote:
> 
> Whats the Big5 charset and
> is it relevant/better than GB2312?  Utf-8?  Or are they all
> interchangeable?

They are not interchangeable and UTF-8 is the most versatile one.


> I would want to run this on mySQL and CFMX if possible.

Apart from the other issues, unicode support is very new to MySQL, I am 
not even sure there is a stable release with it. Make sure you test 
everything twice and on exactly the same MySQL version as your client 
will run. Or use something else.


> Seems like this is a fairly simple task (in MX) where there is no single
> set of start-finish instructions; or none that I've found yet at least.

http://www.macromedia.com/support/coldfusion/internationalization/internationalization_cfmx/

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF / Excel / Ranges

[Greg Luce]

I've had good luck saving the excell sheet to csv, then using DTS (text)
to import. If there are multiple sheets in the original just save them
each separately as csv. Email me direct if you have any questions.

-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 1:14 PM
To: CF-Talk
Subject: CF / Excel / Ranges


What would be the easiest way to import an excel sheet into SQL 2K. The
excel sheet contains the following:

Country name
Country abbreviation
Country code
>From Phone Number
To Phone Number

Thanks,

Mike


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Stoneage Print Server

[Charlie Arehart]

Um, I've got no association with them at all. Sorry.

/charlie

> -Original Message-
> From: Marius Milosav [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2003 2:30 PM
> To: CF-Talk
> Subject: Re: Stoneage Print Server
>
>
> try:
> [EMAIL PROTECTED]
>
> Marius Milosav
> www.scorpiosoft.com
> It's not about technology, it's about people.
> Virtual Company (VICO) Application Demo
> www.scorpiosoft.com/vicodemo/login.cfm
>
> - Original Message -
> From: "Ian Lurie" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, June 12, 2003 12:07 PM
> Subject: Stoneage Print Server
>
>
> > Hi all,
> >
> > I'm trying to get in touch with Stoneage (www.stoneagesoftware.com) to
> > buy a copy of their print server. Their site's down. I'm in kind of a
> > hurry - anyone know how I can reach them?
> >
> > Ian
> >
> >
> > Portent Interactive
> > An Internet Marketing Agency
> > http://www.portentinteractive.com
> > http://www.searchengineoptimization.cc
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Consuming CFMX Web Services in ASP.NET

[Murat Demirci]

My friend solved the problem by writing a script. I don't know what he
wrote.

Thank you very much for your replies.


-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 3:22 AM
To: CF-Talk
Subject: RE: Consuming CFMX Web Services in ASP.NET


Try returning an array of structs...should be a lot easier to work with in
.NET

-Stace

-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2003 3:21 AM
To: CF-Talk
Subject: Consuming CFMX Web Services in ASP.NET

My friend has a problem when calling a web service method which returns CFMX
query object.
 
When I return a query object from CFC function, .NET cannot get the
recordset object.
 
I'm using CFMX U3.
 
Any experiences?





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFMX and Chinese

[Paul Hastings]

> Apart from the other issues, unicode support is very new to MySQL, I am
> not even sure there is a stable release with it. Make sure you test

just checked, ver 4.1 appears to have added ucs2, so i guess support is
improving.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Stoneage Print Server

[Ian Lurie]

Problem solved - the folks at Stoneage just called me. Thanks,  
everyone, for your help! This continues to be a great community...



On Thursday, June 12, 2003, at 11:52 AM, Charlie Arehart wrote:

> Um, I've got no association with them at all. Sorry.
>
> /charlie
>
>> -Original Message-
>> From: Marius Milosav [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, June 12, 2003 2:30 PM
>> To: CF-Talk
>> Subject: Re: Stoneage Print Server
>>
>>
>> try:
>> [EMAIL PROTECTED]
>>
>> Marius Milosav
>> www.scorpiosoft.com
>> It's not about technology, it's about people.
>> Virtual Company (VICO) Application Demo
>> www.scorpiosoft.com/vicodemo/login.cfm
>>
>> - Original Message -
>> From: "Ian Lurie" <[EMAIL PROTECTED]>
>> To: "CF-Talk" <[EMAIL PROTECTED]>
>> Sent: Thursday, June 12, 2003 12:07 PM
>> Subject: Stoneage Print Server
>>
>>
>>> Hi all,
>>>
>>> I'm trying to get in touch with Stoneage (www.stoneagesoftware.com)  
>>> to
>>> buy a copy of their print server. Their site's down. I'm in kind of a
>>> hurry - anyone know how I can reach them?
>>>
>>> Ian
>>>
>>>
>>> Portent Interactive
>>> An Internet Marketing Agency
>>> http://www.portentinteractive.com
>>> http://www.searchengineoptimization.cc
>>>
>>>
>>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFHTTP Issue

[Dave Carabetta]

>Hi,
>
>I was wondering if someone could help me with a CFHTTP issue.  We have 2 
>servers that are behind a distributed director and one server one the 
>CFHTTP call works correctly and on server two the CFHTTP call gets a 
>Connection Failure message.
>
>Does anyone have any idea of what the problem might be.  It was working for 
>the longest time and according to our Web Services guys, nothing on the 
>servers has changed.  The servers are CF4.5 and NT/IIS.  Does a setting 
>need to change in ISS or NT.

Can you ping the URL you're calling from the server console (not your 
desktop)? Did something change in the DNS? Any firewall rules been tweaked 
lately? Just a couple things to try/look into.

Regards,
Dave.

_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Arrrgh...that's not good...Re: Pagination (Next n records) for an inner join and grouped output...

[Jeff]

on 6/12/03 2:34 PM, Bryan Love at [EMAIL PROTECTED] wrote:

> I've run into this one before and it sucks.  Your best bet, if you want the
> number of unique property ids is to run another query that does a
> SELECT COUNT DISTINCT propertyID AS pCount...
> 
> But whether or not it will work to use this number as the recordcount is
> anyone's guess.  You may have to keep track manually.
> 

You're kidding me...

I had thought about "jury-rigging" it by doing exactly that. But thought I'd
be ashamed of doing something like that...

Am I correct in assuming that the recordcount of the join is actually
correct? It's a fact that I can verify whenever I group them properly (by
grouping them on propertyID) and it always comes out correct. This leads me
to believe that the query is actually *THE* correct way to retrieve this
information in this particular manner...it's just going to be a pain to do a
"next n records" browse type of function?

Is this correct?



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Stoneage Print Server

[Paul Hastings]

seems to be there now...
http://www.stoneagesoftware.com/ProductDetails.cfm?Product_ID_String=8b73249e-9d57-4275-9659-35f47c89f494


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Stoneage Print Server

[Ian Lurie]

Yeah they just put the site back up, just for little old me...


On Thursday, June 12, 2003, at 12:25 PM, Paul Hastings wrote:

> seems to be there now...
> http://www.stoneagesoftware.com/ 
> ProductDetails.cfm?Product_ID_String=8b73249e-9d57-4275-9659- 
> 35f47c89f494
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: saving textarea input to rtf

[Douglas.Knudsen]

right...but as Phillip mention 
"Now, if you use a visual editor (see the "active edit alternatives"
thread), then it returns HTML"

this will save you dev time. 

Doug

>-Original Message-
>From: Andrew Henry [mailto:[EMAIL PROTECTED]
>Sent: Thursday, June 12, 2003 2:10 PM
>To: CF-Talk
>Subject: Re: saving textarea input to rtf
>
>
>Hi Bryan,
>
>According to this article I can, though I haven't yet got it 
>working myself
>it seems possible.
>
>http://www.oreillynet.com/pub/a/javascript/2001/12/21/js_toolbar.html
>
>I know the UI functionality comes from JavaScript but 
>everything else is
>done with CF. So ultimately the user can markup the text in 
>the text area,
>and I need to save it as rtf.
>
>Thanks for any advice
>
>Cheers,
>
>Andrew
>
>- Original Message -
>From: "Bryan Love" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Thursday, June 12, 2003 1:07 PM
>Subject: RE: saving textarea input to rtf
>
>
>> ??? As far as I know you can't put bold and italics in a text area.
>>
>> +---+
>> Bryan Love
>>   Database Analyst
>>   Macromedia Certified Professional
>>   Internet Application Developer
>> TeleCommunication Systems
>> [EMAIL PROTECTED]
>> +---+
>>
>> "...'If there must be trouble, let it be in my day, that my 
>child may have
>> peace'..."
>> - Thomas Paine, The American Crisis
>>
>> "Let's Roll"
>> - Todd Beamer, Flight 93
>>
>>
>>
>> -Original Message-
>> From: Andrew Henry [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, June 11, 2003 8:17 PM
>> To: CF-Talk
>> Subject: saving textarea input to rtf
>>
>>
>> Hi,
>>
>> Somewhat of a newbie question I expect.
>>
>> I have to save input from a textarea, in which the user has the
>opportunity
>> to alter the text in the area(e.g. bold, italic), into an 
>rtf file. That
>is
>> to say, I need to save what the user sees in the textarea 
>into an rtf file
>> so that when the user opens the rtf file, from say "Word" 
>the bold and
>> italicized text are retained.
>>
>> Thanks for any ideas you have to offer.
>>
>> Cheers,
>>
>> Andrew Henry
>>
>>
>>
>> 
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFLDAP and UID Output?

[James Blaha]

Hello All:

CFLDAP and UID Output?

 Can I perform a query search for UID? I need to output the UID and pass 
it to another template when an entry is selected from the LDAP server 
output. I can't seem to output the UID. And Ideas?

This gives me a bunch of people but I cant output their UID's... I'm 
running a Sun ONE Directory LDAP sever.



Regards,
James Blaha



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

iMS CFUG Edition

[Howie Hamlin]

(Sent with permission)

On-Line Data Solutions, Inc. (www.CoolFusion.com) recognizes the tremendous 
value of the ColdFusion User Group and the invaluable role it plays in 
strengthening the CF community. In this "spirit of community", we would like 
to donate a free copy of our award-winning mail server, inFusion Mail Server 
(iMS), to all registered CFUGs. 
 
inFusion Mail Server (iMS) is the World's Most Configurable email server. It's 
unique architecture provides an open platform which allows you to create 
completely customized email applications. iMS gets it's "processing smarts" 
from ColdFusion templates, enabling you to apply the ColdFusion expertise you 
already use in your web applications to dynamic email applications. iMS offers 
seamless CF integration with your current web applications, rapid application 
development, and an unlimited feature set (because you can code them yourself!).

We also provide a freeware set of ColdFusion templates, Fusionmail, an
'out-of-the-box' mail server application, to get you up and running quickly.
Fusionmail can be used as a starting point, and can easily be modified to meet 
your existing and future needs.
 
The CFUG edition of iMS is a fully-functioning version of our iMS bundle (25 
thread SMTP, POST, and POP servers)  with the following conditions:
 
- This version is licensed for CFUG use only. 
- This version needs to authenticate to our license server upon startup 
  (requires access to port 80) 
- ODS reserves the right to terminate this license if it is not being used for 
  CFUG business.
 
For more information on inFusion Mail Server, go to www.coolfusion.com/ims
 
For information on receiving your free CFUG edition of iMS, email 
[EMAIL PROTECTED] Please provide us with the name of your CFUG chapter, 
and a key contact person (name, address, email address).
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Stoneage Print Server

[Charlie Arehart]

Curious: a visit to http://www.stoneagesoftware.com/ still gets a CFMX error
"Could not find the included template /StoneAgeSoftware/Common/Header.cfm.".

Though, perhaps more curious, http://www.stoneagesoftware.com/index.cfm)
does not.

You may want to pass that along to them, Ian.

/charlie

> -Original Message-
> From: Ian Lurie [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2003 3:21 PM
> To: CF-Talk
> Subject: Re: Stoneage Print Server
>
>
> Yeah they just put the site back up, just for little old me...
>
>
> On Thursday, June 12, 2003, at 12:25 PM, Paul Hastings wrote:
>
> > seems to be there now...
> > http://www.stoneagesoftware.com/
> > ProductDetails.cfm?Product_ID_String=8b73249e-9d57-4275-9659-
> > 35f47c89f494
> >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Boston CFUG Revived

[Jim Davis]

[Sorry for the pseudo-spam.]

Although an email today was the first I'd heard of it (annoyingly) the
Boston CFUG seems to have revived itself and will be meeting tonight.
Information here:

http://www.cfugboston.com/index.cfm

The group petered out after it's last director left and this is it's
first meeting under new management.  If you can make, a large turn-out
would nice.  ;^)

Jim Davis
President, http://www.depressedpress.com
Webmaster, http://www.firstnight.org
Webmaster, http://www.cfAdvocacy.org
Senior Consultant, http://www.metlife.com
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Stoneage Print Server

[Matt Robertson]

That error is fixed.  The product looks great, but when I tried to download the demo I 
got a CFMX error.

This logo and company name looks awfully familiar.  Ben Forta was(is?) associated with 
stoneage.com.  

---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---


-- Original Message --
From: "Charlie Arehart" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Thu, 12 Jun 2003 15:33:12 -0400

>Curious: a visit to http://www.stoneagesoftware.com/ still gets a CFMX error
>"Could not find the included template /StoneAgeSoftware/Common/Header.cfm.".
>
>Though, perhaps more curious, http://www.stoneagesoftware.com/index.cfm)
>does not.
>
>You may want to pass that along to them, Ian.
>
>/charlie
>
>> -Original Message-
>> From: Ian Lurie [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, June 12, 2003 3:21 PM
>> To: CF-Talk
>> Subject: Re: Stoneage Print Server
>>
>>
>> Yeah they just put the site back up, just for little old me...
>>
>>
>> On Thursday, June 12, 2003, at 12:25 PM, Paul Hastings wrote:
>>
>> > seems to be there now...
>> > http://www.stoneagesoftware.com/
>> > ProductDetails.cfm?Product_ID_String=8b73249e-9d57-4275-9659-
>> > 35f47c89f494
>> >
>> >
>> >
>> 
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFDIRECTORY over a LAN

[Neil Middleton]

Just tried it over IP and the performance is the same...

N

> -Original Message-
> From: Neil Middleton [mailto:[EMAIL PROTECTED]
> Sent: 12 June 2003 10:59
> To: CF-Talk
> Subject: RE: CFDIRECTORY over a LAN
> 
> 
> no firewalls, and I haven't tried using an IP Address.
> 
> I will run the test over IP and see if it makes a big 
> difference or not.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Okay, is this possible? Re: Arrrgh...that's not good...Re: Pagination (Next n records) for an inner join

[Jeff]

Okay, how about this...

Is there a function or a combination of functions that I can use on the
query results to find the distinct PropertyIDs from a join query?

Say my query returns 10 rows. 2 distinct properties, with 6 rates for one,
and 4 rates for another...so grouped output looks like this:

My Property One
112 Address Drive
[photo 1]
Rate Schedule 1
Rate Schedule 2
Rate Schedule 3
Rate Schedule 4
Rate Schedule 5
Rate Schedule 6

My Property Two
234 Address Drive
[photo 2]
Rate Schedule 1
Rate Schedule 2
Rate Schedule 3
Rate Schedule 4

Your search returned [#DistinctPropertyCount#]

Is there some way to calculate #DistinctPropertyCount# some way from the
results of the query? In this case, the RecordCount is correct (10 rows
returned) but what I *really* need is the number of *properties* that are
returned...

Make sense?

on 6/12/03 3:07 PM, Jeff at [EMAIL PROTECTED] wrote:
> on 6/12/03 2:34 PM, Bryan Love at [EMAIL PROTECTED] wrote:
> 
>> I've run into this one before and it sucks.  Your best bet, if you want the
>> number of unique property ids is to run another query that does a
>> SELECT COUNT DISTINCT propertyID AS pCount...
>> 
>> But whether or not it will work to use this number as the recordcount is
>> anyone's guess.  You may have to keep track manually.
>> 
> 
> You're kidding me...
> 
> I had thought about "jury-rigging" it by doing exactly that. But thought I'd
> be ashamed of doing something like that...
> 
> Am I correct in assuming that the recordcount of the join is actually
> correct? It's a fact that I can verify whenever I group them properly (by
> grouping them on propertyID) and it always comes out correct. This leads me
> to believe that the query is actually *THE* correct way to retrieve this
> information in this particular manner...it's just going to be a pain to do a
> "next n records" browse type of function?
> 
> Is this correct?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Okay, is this possible? Re: Arrrgh...that's not good...Re: Pagination (Next n records) for an inner join

[Scott Weikert]

>Is there some way to calculate #DistinctPropertyCount# some way from the
>results of the query? In this case, the RecordCount is correct (10 rows
>returned) but what I *really* need is the number of *properties* that are
>returned...

You could create a structure, with keys being the value of the property 
field that is duped in your query, starting with values of 0. Loop the 
query, and increment the structure key's value by one each time you hit it...

Or, do a second query with the same criteria, but just query for that one 
field and do a DISTINCT on it, then your recordcount for that query should 
be the number of distinct values for that field.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

ANNOUNCE: CFUN-03 regular price ends in 2 days on 6/14/03

[Michael Smith]

There are just 2 days left on the regular CFUN-03 price of $249! Over
300 people are coming and we only have a few places left. Don't miss
out on this area's biggest CF event, register today!

TeraTech also is offering a few student and unemployed partial scholarships
to CFUN-03. Email me if you want to apply.

The numbers on CFUN-03
* 300+ attendees to network with
* 40 sessions to hear
* 28 nationally known speakers to see
* 8 vendors to meet
* 4 tracks (CF BootCamp, MX Integration, Empowered Programming,  and Advanced CF) to 
attend
* 1 big MX event you can't afford to miss

Check out all the track descriptions, session details and speaker bios at:
http://www.cfconf.com/cfun-03/

- Michael Smith
   TeraTech, Inc

PS The Regular $249 price ends 6/14/03 midnight EST, so
don't delay - register today!


---
   CFUN is organized by TeraTech. Help us by voting for TeraTech
   in the CFDJ awards at
   http://www.sys-con.com/coldfusion/readerschoice2003/

   Best Consulting - TeraTech
   Best Training - TeraTech
   Best Community site - CFConf
   Best Web Dev Tool - CFXGraphicsServer
---

This year's conference has 28 nationally known speakers including Charlie
Arehart, Steve Drucker, Raymond Camden, Hal Helms, Michael Smith, Michael Dinowitz,
Simon Horwith and Shlomy Gantz.

CFUN-03 Washington DC area 6/21 - 6/22:
* Learn CF MX, Flash and more!
* Network with your peers and top national speakers
* Have fun exploring what is new from Macromedia

Tracks:
* Advanced Topics - for gurus, XML, CFCs, SQL
* MX Integration - Flash, Java, .Net, Webservices
* Empowered Programming - OO, Fusebox, Copyright, PM, Testing, Debug
* CF Bootcamp - for beginners in CF and Flash
For details on other tracks please see our website

Pricing schedule - register today to save!
* Just $199 Early Bird Price from 4/1 - 4/30/03
* Ok   $249 Regular Price 5/1/03 - 6/14/03
* Opps $299 Late Registration 6/15/03 - 6/22/03

- Michael Smith, TeraTech, Inc
   http://www.teratech.com/
   http://www.cfconf.com/cfun-03/


-
* CFUN-03
*
Register today
http://www.cfconf.com/cfun-03/


-- 
Michael Smith, TeraTech Inc - Tools for Programmers(tm)
CF/ASP Web, VB, Telephony, Math, Access programming tools and consulting
12221 Parklawn Dr Ste 200, Rockville MD 20852 USA
Please check out http://www.teratech.com/ - email mailto:[EMAIL PROTECTED],
or call us for more information; in the USA at 1-800-447-9120,
+1-301-881-1440 International, Fax 301-881-3586  Thanks!




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT~ but a good laugh:)

[Dave Lyons]

Microsoft announce FrontPage 2003 "We've really focused on generating

clean, industry-standard HTML code." they claim.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: OT~ but a good laugh:)

[Dan Phillips]

LOL! Riiggghhht

-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 4:39 PM
To: CF-Talk
Subject: OT~ but a good laugh:)


Microsoft announce FrontPage 2003 "We've really focused on generating

clean, industry-standard HTML code." they claim.




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output...

[Bryan Love]

Post the code you are using to output the query.  The information you are
trying to display could make or break this effort.

I'm assuming you have something like this:


#propertyID#
?

#some info#...



and you want to outputsay...10 propertyIDs per page?

Without running the SELECT COUNT DISTINCT... you will only be able to use
"next page" and "previous page" links because you won't know how many total
pages there are.



+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 12:08 PM
To: CF-Talk
Subject: Arrrgh...that's not good...Re: Pagination (Next n records) for
an inner join and grouped output...


on 6/12/03 2:34 PM, Bryan Love at [EMAIL PROTECTED] wrote:

> I've run into this one before and it sucks.  Your best bet, if you want
the
> number of unique property ids is to run another query that does a
> SELECT COUNT DISTINCT propertyID AS pCount...
> 
> But whether or not it will work to use this number as the recordcount is
> anyone's guess.  You may have to keep track manually.
> 

You're kidding me...

I had thought about "jury-rigging" it by doing exactly that. But thought I'd
be ashamed of doing something like that...

Am I correct in assuming that the recordcount of the join is actually
correct? It's a fact that I can verify whenever I group them properly (by
grouping them on propertyID) and it always comes out correct. This leads me
to believe that the query is actually *THE* correct way to retrieve this
information in this particular manner...it's just going to be a pain to do a
"next n records" browse type of function?

Is this correct?




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Okay, is this possible? Re: Arrrgh...that's not good...Re: Pagination (Next n records) for an inner join

[Jeff]

on 6/12/03 4:16 PM, Scott Weikert at [EMAIL PROTECTED] wrote:

>> Is there some way to calculate #DistinctPropertyCount# some way from the
>> results of the query? In this case, the RecordCount is correct (10 rows
>> returned) but what I *really* need is the number of *properties* that are
>> returned...
> 
> You could create a structure, with keys being the value of the property
> field that is duped in your query, starting with values of 0. Loop the
> query, and increment the structure key's value by one each time you hit it...
> 
> Or, do a second query with the same criteria, but just query for that one
> field and do a DISTINCT on it, then your recordcount for that query should
> be the number of distinct values for that field.

Man, I totally tried this, but my query just gave the most horrible
errors...

Watch...


SELECT *
FROM (tblRentalLocations INNER JOIN tblRentalProperties ON
tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID)
INNER JOIN tblRentalRates ON
tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID

WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms#

ORDER BY tblRentalProperties.PropertyName, tblRentalRates.RatesOrder,
tblRentalRates.RatesLength Desc



Now...right below it, I make the EXACT same bit of code, and simply request
the count, not even the distinct count...and I get the error below:



SELECT COUNT(PropertyID) AS PropertyCount
FROM (tblRentalLocations INNER JOIN tblRentalProperties ON
tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID)
INNER JOIN tblRentalRates ON
tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID

WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms#

ORDER BY tblRentalProperties.PropertyName, tblRentalRates.RatesOrder,
tblRentalRates.RatesLength Desc



[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access
Driver] You tried to execute a query that does not include the specified
expression
'tblRentalProperties.PropertyName' as part of an aggregate function.

I've tried to look up help on this particular error, but I'm stumped, so I
assumed it wasn't going to work because I couldn't perform the *exact* same
query in both places...just returning different data...

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT~ but a good laugh:)

[Howie Hamlin]

Actually, Frontpage is one of the better code generators.  Have you ever looked at 
Golive code?  Argh...

- Original Message - 
From: "Dave Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 4:39 PM
Subject: OT~ but a good laugh:)


> Microsoft announce FrontPage 2003 "We've really focused on generating
> 
> clean, industry-standard HTML code." they claim.
> 
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT~ but a good laugh:)

[Doug White]

And you can turn off FrontPage extensions too!

2003 has a neat expiration code, and a even cooler "can be opened only by"  and
"cannot save locally" features too!

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 3:51 PM
Subject: Re: OT~ but a good laugh:)


| Actually, Frontpage is one of the better code generators.  Have you ever
looked at Golive code?  Argh...
|
| - Original Message - 
| From: "Dave Lyons" <[EMAIL PROTECTED]>
| To: "CF-Talk" <[EMAIL PROTECTED]>
| Sent: Thursday, June 12, 2003 4:39 PM
| Subject: OT~ but a good laugh:)
|
|
| > Microsoft announce FrontPage 2003 "We've really focused on generating
| >
| > clean, industry-standard HTML code." they claim.
| >
| >
| >
| >
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT~ but a good laugh:)

[Jochem van Dieten]

Dave Lyons wrote:
> Microsoft announce FrontPage 2003 "We've really focused on generating
> clean, industry-standard HTML code." they claim.

That would be quite a change. IIRC, during the anti-trust trials Bill 
Gates himself has delivered sworn testimony that Frontpage is designed 
to only work with IE.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re:Boston CFUG Revived

[jlangevin]

Hi Jim,

Today's email was actually the third email notification we sent out (in
addition to one from Macromedia, though I do not know the extent of that
mailing).   At which email address did you receive today's notice?  I do not see
any depressedpress.com email addresses included in the email list that was given
to us by the former cfug manager.  If you let me know at what address you would
like to receive notices, I will be happy to add you to my database for future
mailings.

Anyone else interested in being to be added to the BCFUG mailing list,
please email me off cftalk.

--Jeff

Jeff Langevin  Appalachian 
Mountain Club
MIS Department   5 Joy Street, Boston, Massachusetts
02108

When you do the common things in life in an uncommon way,
you will command the attention of the world.

--George Washington Carver



Reply Separator
Subject:Boston CFUG Revived
Author: [EMAIL PROTECTED]
Date:   6/12/2003 3:44 PM

[Sorry for the pseudo-spam.]

Although an email today was the first I'd heard of it (annoyingly) the
Boston CFUG seems to have revived itself and will be meeting tonight.
Information here:

http://www.cfugboston.com/index.cfm

The group petered out after it's last director left and this is it's
first meeting under new management.  If you can make, a large turn-out
would nice.  ;^)

Jim Davis
President, http://www.depressedpress.com
Webmaster, http://www.firstnight.org
Webmaster, http://www.cfAdvocacy.org
Senior Consultant, http://www.metlife.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output...

[Jeff]

on 6/12/03 4:47 PM, Bryan Love at [EMAIL PROTECTED] wrote:

> Post the code you are using to output the query.  The information you are
> trying to display could make or break this effort.
> 
> I'm assuming you have something like this:
> 
> 
> #propertyID#
> ?
> 
> #some info#...
> 
> 

That's exactly my output...
 
> and you want to outputsay...10 propertyIDs per page?
> 
> Without running the SELECT COUNT DISTINCT... you will only be able to use
> "next page" and "previous page" links because you won't know how many total
> pages there are.

Can I somehow calculate that DURING the inner join query below? I tried to
add it to the SELECT statement with disastrous results...



SELECT *
FROM (tblRentalLocations INNER JOIN tblRentalProperties ON
tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID)
INNER JOIN tblRentalRates ON
tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID

WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms#

ORDER BY tblRentalProperties.PropertyName, tblRentalRates.RatesOrder,
tblRentalRates.RatesLength Desc



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Consuming CFMX Web Services in ASP.NET

[Andre Mohamed]

This is a known issue and has I believe been acknowleged by various
parties.

It is the result of a "limitation" of the underlying Axis engine that
CFMX uses. 

I believe there were plans for Axis in the future (possibly the version
that is used in the next point release of MX - I haven't tried yet) to
mitigate problems concerning "result set" incompatibilities between .NET
and CFMX.

Since, the issue could be construed as lying with Axis it is somewhat
out of Macromedia's hands.

In the mean time, as suggested you could use an array of structs or
develop your own CFC to represent "result sets".

André

-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED] 
Sent: 12 June 2003 01:22
To: CF-Talk
Subject: RE: Consuming CFMX Web Services in ASP.NET

Try returning an array of structs...should be a lot easier to work with
in .NET

-Stace

-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2003 3:21 AM
To: CF-Talk
Subject: Consuming CFMX Web Services in ASP.NET

My friend has a problem when calling a web service method which returns
CFMX query object.
 
When I return a query object from CFC function, .NET cannot get the
recordset object.
 
I'm using CFMX U3.
 
Any experiences?





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

[Kola Oyedeji]

Hi

I've seen this before. The funny thing is it is was related to Locking. 
Other applications running on the same server and under heavy load
included unlocked session vars which seemed to manifest themselves as
errors when using Q of Q. I can only put this down to the lack of
locking screwing up ram in a way which becomes an issue when you're
doing a query of queries. 


HTH

Kola

>> -Original Message-
>> From: Buddy [mailto:[EMAIL PROTECTED]
>> Sent: 11 June 2003 18:25
>> To: CF-Talk
>> Subject: PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
>> 
>> Okay so I have been handed a problem resulting from code that someone
>> else
>> wrote, I'm sure some of you can sympathize. Hopefully some of you
might
>> also
>> have some advice.
>> 
>> We run a report every month, this month it is much bigger then usual.
>> Normally it takes a while to do, but never has any errors, this month
it
>> is
>> taking a while then erroring out. The file in question does a big
query
>> on
>> the main database, then does a bunch of queries of a query based on
the
>> original query. The main query looks like this:
>> 
>> > username="blah" password="blah">Select SIGNUPS, TDATE, SITEID,WMID
from
>> DATA
>> WHERE TDATE> #CreateODBCDateTime(MASTERLASTPAY)# and TDATE<=
>> #CreateODBCDateTime(ENDDATE)# and signups > 0
>> 
>> Simple, no problems there. Here is the error:
>> 
>> unknown exception condition
>> 
>> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
>> 
>> The error occurred while processing an element with a general
identifier
>> of
>> (CFQUERY), occupying document position (116:4) to (116:51) in the
>> template
>> file E:\blah\blah
>> 
>> Line 116 where the error resides looks like this:
>> 
>> Select SIGNUPS from
>> SELECTMASTERDATA WHERE ((TDATE>'#STARTDATE#') and (TDATE<=
'#ENDDATE2#')
>> and (WMID='#ID#'))
>> 
>> Again, nothing seems wrong here.
>> 
>> The thing that troubles me is that it will process a ton of rows and
then
>> seemingly error out at random, one time on the 500th row and the
750th
>> the
>> next time. And I think it might have something to do with the load on
the
>> box at the time.
>> 
>> I have seen that error referenced in regards to q of q, but a lot of
the
>> problems people are having seem to have to do with locking, and I
don't
>> have
>> anything to lock, so I don't think that is it.
>> 
>> Any advice would be greatly appreciated.
>> -Buddy
>> 
>> 
>> 
>>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

paired values in lists

[Emmet McGovern]

I posted a question earlier with a horrible explanation so here is my
second try.  I'm making a car database where you can add as many
attributes with as many options for each attribute.  I'm guessing you
need to put the options/attributes as pairs in the attribute column in
the car table.  How would I loop through that table switching the
delimiter to display the car and its attributes properly?  As a bonus,
how would I search for a car based on the attribute options?

The app should work like so.  

There needs to be an attribute manager.  Each attribute would be able to
have its own options. such as.

TBL ATTRIBUTES

attID | attname |

1 | color 
2 | interior
3 | wheels


TBL OPTIONS

optID | attID | optname |

1 | 1 | red 
2 | 1 | blue
3 | 2 | cloth
4 | 2 | leather
5 | 3 | alloy
6 | 3 | steel

That part is simple enough.  My problem is how to handle the data in the
car table.  I'm assuming I would use paired values in a list, although
im not quite sure how to loop through it.

TBL CAR

carID | carname | attributes

1 | civic | 1^2;2^4;3^5
2 | accord | 1^1;2^3;3^6

(ie blue civic with leather interior and steel wheels)

Any help is appreciated.


Emmet
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT~ but a good laugh:)

[Dave Lyons]

as usual you are correct jochem
heres the rest:
Microsoft announce FrontPage 2003 "We've really focused on generating

clean, industry-standard HTML code." they claim. We expect it to produce

proprietary, MS-oriented mark-up that only works in IE6. But then we're

cynical. Click here

 to read more.

Any of you going to stop using DMX and start using FrontPage? Tell us by

mailing Bruce Lawson 

- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 5:00 PM
Subject: Re: OT~ but a good laugh:)


> Dave Lyons wrote:
> > Microsoft announce FrontPage 2003 "We've really focused on generating
> > clean, industry-standard HTML code." they claim.
>
> That would be quite a change. IIRC, during the anti-trust trials Bill
> Gates himself has delivered sworn testimony that Frontpage is designed
> to only work with IE.
>
> Jochem
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: paired values in lists

[Barney Boisvert]

You probably want to create a CAROPTION table to replace the attributes
column in CAR:

carID | optID | attID
1 | 1 | 2
1 | 2 | 4
1 | 3 | 5
2 | 1 | 1
2 | 2 | 3
2 | 3 | 6

It adds a join, and splits the data, but will make searching enormously
easier.

---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

> -Original Message-
> From: Emmet McGovern [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2003 1:47 PM
> To: CF-Talk
> Subject: paired values in lists
>
>
> I posted a question earlier with a horrible explanation so here is my
> second try.  I'm making a car database where you can add as many
> attributes with as many options for each attribute.  I'm guessing you
> need to put the options/attributes as pairs in the attribute column in
> the car table.  How would I loop through that table switching the
> delimiter to display the car and its attributes properly?  As a bonus,
> how would I search for a car based on the attribute options?
>
> The app should work like so.
>
> There needs to be an attribute manager.  Each attribute would be able to
> have its own options. such as.
>
> TBL ATTRIBUTES
> 
> attID | attname |
> 
> 1 | color
> 2 | interior
> 3 | wheels
>
>
> TBL OPTIONS
> 
> optID | attID | optname |
> 
> 1 | 1 | red
> 2 | 1 | blue
> 3 | 2 | cloth
> 4 | 2 | leather
> 5 | 3 | alloy
> 6 | 3 | steel
>
> That part is simple enough.  My problem is how to handle the data in the
> car table.  I'm assuming I would use paired values in a list, although
> im not quite sure how to loop through it.
>
> TBL CAR
> 
> carID | carname | attributes
> 
> 1 | civic | 1^2;2^4;3^5
> 2 | accord | 1^1;2^3;3^6
>
> (ie blue civic with leather interior and steel wheels)
>
> Any help is appreciated.
>
>
> Emmet
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: paired values in lists

[Emmet McGovern]

Good point.  I still don't understand how I would write the code though
to pair up the option to the attribute.  Some times I just can't seem to
get over the learning hurdle.  I think age is taking its toll. :)

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 5:15 PM
To: CF-Talk
Subject: RE: paired values in lists

You probably want to create a CAROPTION table to replace the attributes
column in CAR:

carID | optID | attID
1 | 1 | 2
1 | 2 | 4
1 | 3 | 5
2 | 1 | 1
2 | 2 | 3
2 | 3 | 6

It adds a join, and splits the data, but will make searching enormously
easier.

---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

> -Original Message-
> From: Emmet McGovern [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2003 1:47 PM
> To: CF-Talk
> Subject: paired values in lists
>
>
> I posted a question earlier with a horrible explanation so here is my
> second try.  I'm making a car database where you can add as many
> attributes with as many options for each attribute.  I'm guessing you
> need to put the options/attributes as pairs in the attribute column in
> the car table.  How would I loop through that table switching the
> delimiter to display the car and its attributes properly?  As a bonus,
> how would I search for a car based on the attribute options?
>
> The app should work like so.
>
> There needs to be an attribute manager.  Each attribute would be able
to
> have its own options. such as.
>
> TBL ATTRIBUTES
> 
> attID | attname |
> 
> 1 | color
> 2 | interior
> 3 | wheels
>
>
> TBL OPTIONS
> 
> optID | attID | optname |
> 
> 1 | 1 | red
> 2 | 1 | blue
> 3 | 2 | cloth
> 4 | 2 | leather
> 5 | 3 | alloy
> 6 | 3 | steel
>
> That part is simple enough.  My problem is how to handle the data in
the
> car table.  I'm assuming I would use paired values in a list, although
> im not quite sure how to loop through it.
>
> TBL CAR
> 
> carID | carname | attributes
> 
> 1 | civic | 1^2;2^4;3^5
> 2 | accord | 1^1;2^3;3^6
>
> (ie blue civic with leather interior and steel wheels)
>
> Any help is appreciated.
>
>
> Emmet
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SQL conversion question for SQL Guru

[Eric Creese]

I have a query I am trying to run to get a particular record out of the database. The 
problem is that one of the fields is 
a varchar 255 field that houses a date. I want to convert the date so I can find out 
if it is greater than getdate(). I run the following
code and generate this conversion error message:

Server: Msg 241, Level 16, State 1, Line 1
Syntax error converting datetime from character string.


select distinct personid 
from persondemographic 
where demographicgroupid =4
and demographicitemid =4
and convert(datetime, demographicvaluedesc) > getdate()
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: paired values in lists

[Barney Boisvert]

SELECT CAR.carID, CAR.carname,
   OPTIONS.optname
FROM CAR
   INNER JOIN CAROPTION ON CAR.carID = CAROPTION.carID
   INNER JOIN OPTIONS ON CAROPTION.optID = OPTIONS.optID

That'd return a recordset like this:
1, civic, blue
1, civic, leather
1, civic, alloy
2, accord, red
2, accord, cloth
2, accord, steel

---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

> -Original Message-
> From: Emmet McGovern [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2003 2:05 PM
> To: CF-Talk
> Subject: RE: paired values in lists
>
>
> Good point.  I still don't understand how I would write the code though
> to pair up the option to the attribute.  Some times I just can't seem to
> get over the learning hurdle.  I think age is taking its toll. :)
>
> -Original Message-
> From: Barney Boisvert [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 12, 2003 5:15 PM
> To: CF-Talk
> Subject: RE: paired values in lists
>
> You probably want to create a CAROPTION table to replace the attributes
> column in CAR:
>
> carID | optID | attID
> 1 | 1 | 2
> 1 | 2 | 4
> 1 | 3 | 5
> 2 | 1 | 1
> 2 | 2 | 3
> 2 | 3 | 6
>
> It adds a join, and splits the data, but will make searching enormously
> easier.
>
> ---
> Barney Boisvert, Senior Development Engineer
> AudienceCentral (formerly PIER System, Inc.)
> [EMAIL PROTECTED]
> voice : 360.756.8080 x12
> fax   : 360.647.5351
>
> www.audiencecentral.com
>
> > -Original Message-
> > From: Emmet McGovern [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, June 12, 2003 1:47 PM
> > To: CF-Talk
> > Subject: paired values in lists
> >
> >
> > I posted a question earlier with a horrible explanation so here is my
> > second try.  I'm making a car database where you can add as many
> > attributes with as many options for each attribute.  I'm guessing you
> > need to put the options/attributes as pairs in the attribute column in
> > the car table.  How would I loop through that table switching the
> > delimiter to display the car and its attributes properly?  As a bonus,
> > how would I search for a car based on the attribute options?
> >
> > The app should work like so.
> >
> > There needs to be an attribute manager.  Each attribute would be able
> to
> > have its own options. such as.
> >
> > TBL ATTRIBUTES
> > 
> > attID | attname |
> > 
> > 1 | color
> > 2 | interior
> > 3 | wheels
> >
> >
> > TBL OPTIONS
> > 
> > optID | attID | optname |
> > 
> > 1 | 1 | red
> > 2 | 1 | blue
> > 3 | 2 | cloth
> > 4 | 2 | leather
> > 5 | 3 | alloy
> > 6 | 3 | steel
> >
> > That part is simple enough.  My problem is how to handle the data in
> the
> > car table.  I'm assuming I would use paired values in a list, although
> > im not quite sure how to loop through it.
> >
> > TBL CAR
> > 
> > carID | carname | attributes
> > 
> > 1 | civic | 1^2;2^4;3^5
> > 2 | accord | 1^1;2^3;3^6
> >
> > (ie blue civic with leather interior and steel wheels)
> >
> > Any help is appreciated.
> >
> >
> > Emmet
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: OT~ but a good laugh:)

[Mike Kear]

I have a couple of hosting clients who insist on using FrontPage.  They have
great looking sites, until you look at two of them and realise they've got
templates from some site somewhere and just changed the text.   

Then I get emails complaining how slow they are to load, and I see that the
150x50 images are actually 1800x600 images displayed at 150x50 so they
download the whole large uncompressed file.  Add to that all the burden code
they have with fragmented tags, font tags on and off everywhere, empty
paragraph tags, empty font tags, additional and unnecessary style tags etc
etc.. and you can take a page from 150kb down to about 15mb without doing a
lot of thinking.

Oh and  don't try to look at their sites with Netscape.

I do hope this new version is better. 


Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.




-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED] 
Sent: Friday, 13 June 2003 7:08 AM
To: CF-Talk
Subject: Re: OT~ but a good laugh:)

as usual you are correct jochem
heres the rest:
Microsoft announce FrontPage 2003 "We've really focused on generating

clean, industry-standard HTML code." they claim. We expect it to produce

proprietary, MS-oriented mark-up that only works in IE6. But then we're

cynical. Click here

 to read more.

Any of you going to stop using DMX and start using FrontPage? Tell us by

mailing Bruce Lawson 

- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 5:00 PM
Subject: Re: OT~ but a good laugh:)


> Dave Lyons wrote:
> > Microsoft announce FrontPage 2003 "We've really focused on generating
> > clean, industry-standard HTML code." they claim.
>
> That would be quite a change. IIRC, during the anti-trust trials Bill
> Gates himself has delivered sworn testimony that Frontpage is designed
> to only work with IE.
>
> Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQL conversion question for SQL Guru

[ksuh]

How does the data in that column look like?

- Original Message -
From: Eric Creese <[EMAIL PROTECTED]>
Date: Thursday, June 12, 2003 3:34 pm
Subject: SQL conversion question for SQL Guru

> I have a query I am trying to run to get a particular record out 
> of the database. The problem is that one of the fields is 
> a varchar 255 field that houses a date. I want to convert the date 
> so I can find out if it is greater than getdate(). I run the following
> code and generate this conversion error message:
> 
> Server: Msg 241, Level 16, State 1, Line 1
> Syntax error converting datetime from character string.
> 
> 
> select distinct personid 
> from persondemographic 
> where demographicgroupid =4
> and demographicitemid =4
> and convert(datetime, demographicvaluedesc) > getdate()
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SQL conversion question for SQL Guru

[Eric Creese]

for some dates I got 06/12/2003 and others JUN 12 2003

I did not design this merely walking into a previous mess.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 4:37 PM
To: CF-Talk
Subject: Re: SQL conversion question for SQL Guru


How does the data in that column look like?

- Original Message -
From: Eric Creese <[EMAIL PROTECTED]>
Date: Thursday, June 12, 2003 3:34 pm
Subject: SQL conversion question for SQL Guru

> I have a query I am trying to run to get a particular record out 
> of the database. The problem is that one of the fields is 
> a varchar 255 field that houses a date. I want to convert the date 
> so I can find out if it is greater than getdate(). I run the following
> code and generate this conversion error message:
> 
> Server: Msg 241, Level 16, State 1, Line 1
> Syntax error converting datetime from character string.
> 
> 
> select distinct personid 
> from persondemographic 
> where demographicgroupid =4
> and demographicitemid =4
> and convert(datetime, demographicvaluedesc) > getdate()
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQL conversion question for SQL Guru

[Jochem van Dieten]

Eric Creese wrote:
> I have a query I am trying to run to get a particular record out of the database. 
> The problem is that one of the fields is 
> a varchar 255 field that houses a date.

Only a date, or other information as well?


> I want to convert the date so I can find out if it is greater than getdate(). I run 
> the following
> code and generate this conversion error message:
> 
> Server: Msg 241, Level 16, State 1, Line 1
> Syntax error converting datetime from character string.
> 
> 
> select distinct personid 
> from persondemographic 
> where demographicgroupid =4
> and demographicitemid =4
> and convert(datetime, demographicvaluedesc) > getdate()

Which DBMS?

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: paired values in lists

[jon hall]

This may be of interest...

http://www.databaseanswers.com/data_models/car_dealership/index.htm

-- 
 jon
 mailto:[EMAIL PROTECTED]

Thursday, June 12, 2003, 4:47:07 PM, you wrote:
EM> I posted a question earlier with a horrible explanation so here is my
EM> second try.  I'm making a car database where you can add as many
EM> attributes with as many options for each attribute.  I'm guessing you
EM> need to put the options/attributes as pairs in the attribute column in
EM> the car table.  How would I loop through that table switching the
EM> delimiter to display the car and its attributes properly?  As a bonus,
EM> how would I search for a car based on the attribute options?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SQL conversion question for SQL Guru

[Eric Creese]

The field actually holds different kids of data based on the record type. I am only 
select records that will contain a date

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 4:44 PM
To: CF-Talk
Subject: Re: SQL conversion question for SQL Guru


Eric Creese wrote:
> I have a query I am trying to run to get a particular record out of the database. 
> The problem is that one of the fields is 
> a varchar 255 field that houses a date.

Only a date, or other information as well?


> I want to convert the date so I can find out if it is greater than getdate(). I run 
> the following
> code and generate this conversion error message:
> 
> Server: Msg 241, Level 16, State 1, Line 1
> Syntax error converting datetime from character string.
> 
> 
> select distinct personid 
> from persondemographic 
> where demographicgroupid =4
> and demographicitemid =4
> and convert(datetime, demographicvaluedesc) > getdate()

Which DBMS?

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SQL Server 2000 List Functions

[DURETTE, STEVEN J (AIT)]

Hi all,
 
The day before yesterday, someone mentioned having problems dealing with
lists in SQL.  Their final solution ended up using regular expressions, but
I figured that I would still need to deal with lists in SQL in the near
future, so I went and created some list functions in SQL.
 
Of course, as they are functions they will only work in MS SQL Server 2000
(don't know about future versions, but it should work as these are quite
simple).
 
For the most part they work like their CF counter parts with a few quirks.
 
If any anyone is interested, I will post the code to the list and do a
little doc write up.
 
The functions I created are: listLen, listGetAt, listDeleteAt, listSetAt,
listFirst, listLast, listPrepend, listAppend, listFind, listInsertAt and
listToTable
 
Steve
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CF Not creating sessions???

[Staff]

HELP HELP HELP . . .

Anyone got any idea why CF may not create sessions??

I simply moved a working functional CF site to another WIn2K Advanced server,
just like the one it came from, and for some reason CF5 will not hold the 
create and maintain a session.

Try to log in and it keeps bumping me back to log in page . . .

I determined it is not creating and maintaining a session . . .

I uninstalled and reinstalled CF and same shit . . .

anone got any ideas???

I can only think to reinstall . . .OS . . .and all . . .

jim


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF Not creating sessions???

[Bryan Love]

It's most likely not the server itself.  Remember there are ONLY two
possible ways to track a user's session:
1. Cookies store CFID and CFTOKEN
2. Pass CFID and CFTOKEN in the url string

If you can't create and hold a session using code that you know is good then
one of these two things is failing.  Most likely the cookies aren't being
set and/or transmitted.  Did the domain name change?

+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Staff [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 3:22 PM
To: CF-Talk
Subject: CF Not creating sessions???


HELP HELP HELP . . .

Anyone got any idea why CF may not create sessions??

I simply moved a working functional CF site to another WIn2K Advanced
server,
just like the one it came from, and for some reason CF5 will not hold the 
create and maintain a session.

Try to log in and it keeps bumping me back to log in page . . .

I determined it is not creating and maintaining a session . . .

I uninstalled and reinstalled CF and same shit . . .

anone got any ideas???

I can only think to reinstall . . .OS . . .and all . . .

jim



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF Not creating sessions???

[Costas Piliotis]

Have you created an application in IIS?  If the site doesn't have an
application name, IIS may not be sending the headers to write the cookie to
keep the session...



-Original Message-
From: Staff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 3:22 PM
To: CF-Talk
Subject: CF Not creating sessions???


HELP HELP HELP . . .

Anyone got any idea why CF may not create sessions??

I simply moved a working functional CF site to another WIn2K Advanced
server, just like the one it came from, and for some reason CF5 will not
hold the 
create and maintain a session.

Try to log in and it keeps bumping me back to log in page . . .

I determined it is not creating and maintaining a session . . .

I uninstalled and reinstalled CF and same shit . . .

anone got any ideas???

I can only think to reinstall . . .OS . . .and all . . .

jim



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

How do you pass the location of your CFCs to other CFCs?

[Shawn Grover]

We are trying to follow good OO coding standards as we develop our CFCs, but
have hit a minor snag.

Basically, an action page will call a business rule component.  But first,
it needs to know where we've stored the components.  That's fine, I can set
a variable in Application.cfm.  Now the business rule component may have
need to access other components (other BR or data access components), I can
hard code the path to the components during development, but it'd be VERY
nice if I didn't have to replace these values when the project is delivered
(different server and base directory) or we moved our development server.
How do YOU handle this?

We've toyed with the idea of using a central configuration object which all
objects could instantiate if needed, but then how does the CFC know where
the config.cfc is?  Next, we considered specifying a variable in the Request
scope, but this means the components MUST know something about the
environement they are being used in, which breaks OO coding standards (think
black box).  So, the only other option we can think off is to pass the path
to the objects, either on a per function basis, or through an "init"
function right after the component is created.  This option is probably the
most robust overall, but means revising a number of components that already
exist.  So, I'm thinking that leaves us with the Request scope variable.
Are there any other options we're missing?  (reading from a file presents
the same problem - how does the cfc know where the file is located without
breaking OO standards?).

Thanks for any input/suggestions.

Shawn
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: RE: CF Not creating sessions???

[ksuh]

IIS applications have nothing to do with CF sessions.

- Original Message -
From: Costas Piliotis <[EMAIL PROTECTED]>
Date: Thursday, June 12, 2003 4:26 pm
Subject: RE: CF Not creating sessions???

> Have you created an application in IIS?  If the site doesn't have an
> application name, IIS may not be sending the headers to write the 
> cookie to
> keep the session...
> 
> 
> 
> -Original Message-
> From: Staff [EMAIL PROTECTED] 
> Sent: Thursday, June 12, 2003 3:22 PM
> To: CF-Talk
> Subject: CF Not creating sessions???
> 
> 
> HELP HELP HELP . . .
> 
> Anyone got any idea why CF may not create sessions??
> 
> I simply moved a working functional CF site to another WIn2K Advanced
> server, just like the one it came from, and for some reason CF5 
> will not
> hold the 
> create and maintain a session.
> 
> Try to log in and it keeps bumping me back to log in page . . .
> 
> I determined it is not creating and maintaining a session . . .
> 
> I uninstalled and reinstalled CF and same shit . . .
> 
> anone got any ideas???
> 
> I can only think to reinstall . . .OS . . .and all . . .
> 
> jim
> 
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF Not creating sessions???

[Costas Piliotis]

In particular, check under the Home Directory tab of your site in IIS.
Ensure there is an application name there.  I think that may be the cause...
Just a hunch though really...


-Original Message-
From: Costas Piliotis 
Sent: Thursday, June 12, 2003 3:26 PM
To: CF-Talk
Subject: RE: CF Not creating sessions???


Have you created an application in IIS?  If the site doesn't have an
application name, IIS may not be sending the headers to write the cookie to
keep the session...



-Original Message-
From: Staff [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 3:22 PM
To: CF-Talk
Subject: CF Not creating sessions???


HELP HELP HELP . . .

Anyone got any idea why CF may not create sessions??

I simply moved a working functional CF site to another WIn2K Advanced
server, just like the one it came from, and for some reason CF5 will not
hold the 
create and maintain a session.

Try to log in and it keeps bumping me back to log in page . . .

I determined it is not creating and maintaining a session . . .

I uninstalled and reinstalled CF and same shit . . .

anone got any ideas???

I can only think to reinstall . . .OS . . .and all . . .

jim




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output...

[Bryan Love]

No you can't.  When you use aggregate functions in an SQL statement you MUST
put all of the fields you are selecting into the GROUP BY clause.  That
means you will need two queries since you want to select more fields than
you want to GROUP BY.

I wouldn't look down on yourself too much for that.  Two queries is not that
big a deal.  It's when you put queries inside loops that you deserve to be
shot ;)

+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 2:03 PM
To: CF-Talk
Subject: Re: Arrrgh...that's not good...Re: Pagination (Next n records)
fo r an inner join and grouped output...


on 6/12/03 4:47 PM, Bryan Love at [EMAIL PROTECTED] wrote:

> Post the code you are using to output the query.  The information you are
> trying to display could make or break this effort.
> 
> I'm assuming you have something like this:
> 
> 
> #propertyID#
> ?
> 
> #some info#...
> 
> 

That's exactly my output...
 
> and you want to outputsay...10 propertyIDs per page?
> 
> Without running the SELECT COUNT DISTINCT... you will only be able to use
> "next page" and "previous page" links because you won't know how many
total
> pages there are.

Can I somehow calculate that DURING the inner join query below? I tried to
add it to the SELECT statement with disastrous results...



SELECT *
FROM (tblRentalLocations INNER JOIN tblRentalProperties ON
tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID)
INNER JOIN tblRentalRates ON
tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID

WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms#

ORDER BY tblRentalProperties.PropertyName, tblRentalRates.RatesOrder,
tblRentalRates.RatesLength Desc




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: How do you pass the location of your CFCs to other CFCs?

[Raymond Camden]

If the CFCs are related, why not use the same directory? Ie

/root
/root/wwwroot (web files here)
/root/cfcs

If your app was Foo.com, you could make a mapping that points to root,
then all your cfcs would have the path:

foo.cfc.whatever

And of course, if whatever needs to access whoever in the same package,
it can just call "whoever". 


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

> -Original Message-
> From: Shawn Grover [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, June 12, 2003 4:32 PM
> To: CF-Talk
> Subject: How do you pass the location of your CFCs to other CFCs?
> 
> 
> We are trying to follow good OO coding standards as we 
> develop our CFCs, but have hit a minor snag.
> 
> Basically, an action page will call a business rule 
> component.  But first, it needs to know where we've stored 
> the components.  That's fine, I can set a variable in 
> Application.cfm.  Now the business rule component may have 
> need to access other components (other BR or data access 
> components), I can hard code the path to the components 
> during development, but it'd be VERY nice if I didn't have to 
> replace these values when the project is delivered (different 
> server and base directory) or we moved our development 
> server. How do YOU handle this?
> 
> We've toyed with the idea of using a central configuration 
> object which all objects could instantiate if needed, but 
> then how does the CFC know where the config.cfc is?  Next, we 
> considered specifying a variable in the Request scope, but 
> this means the components MUST know something about the 
> environement they are being used in, which breaks OO coding 
> standards (think black box).  So, the only other option we 
> can think off is to pass the path to the objects, either on a 
> per function basis, or through an "init" function right after 
> the component is created.  This option is probably the most 
> robust overall, but means revising a number of components 
> that already exist.  So, I'm thinking that leaves us with the 
> Request scope variable. Are there any other options we're 
> missing?  (reading from a file presents the same problem - 
> how does the cfc know where the file is located without 
> breaking OO standards?).
> 
> Thanks for any input/suggestions.
> 
> Shawn 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: paired values in lists

[Tony Walker]

If you plop the following into Query Analyzer (assuming SqlServer200) I think you will 
get what you want:

declare @cid int
set @cid = 2
 if object_id('tempdb..#tblAttributeType') is not null  drop table #tblAttributeType
 if object_id('tempdb..#tblColor') is not null  drop table #tblColor
 if object_id('tempdb..#tblWheels') is not null drop table #tblWheels
 if object_id('tempdb..#tblInterior') is not null   drop table #tblInterior
 if object_id('tempdb..#tblCarMake') is not nulldrop table #tblCarMake
 if object_id('tempdb..#tblCarModel') is not null   drop table #tblCarModel
 if object_id('tempdb..#tblCar') is not nulldrop table #tblCar
 if object_id('tempdb..#tblCar_Attributes') is not null drop table #tblCar_Attributes

create table #tblAttributeType (AttributeTypeId int, Attribute varchar(50))
insert into #tblAttributeType (attributeTypeId,Attribute) values(1,'Color')
insert into #tblAttributeType (attributeTypeId,Attribute) values(2,'wheels')
insert into #tblAttributeType (attributeTypeId,Attribute) values(3,'interior')

create table #tblColor (ColorId int, Color varchar(50))
insert into #tblColor (ColorId,Color) values(1,'Red')
insert into #tblColor (ColorId,Color) values(2,'Green')
insert into #tblColor (ColorId,Color) values(3,'Blue')

create table #tblWheels (WheelId int, Wheel varchar(50))
insert into #tblWheels (WheelId,Wheel) values(1,'Steel')
insert into #tblWheels (WheelId,Wheel) values(2,'Mag')
insert into #tblWheels (WheelId,Wheel) values(3,'Chrome')

create table #tblInterior (InteriorId int, Interior varchar(50))
insert into #tblInterior (InteriorId,Interior) values(1,'Cloth')
insert into #tblInterior (InteriorId,Interior) values(2,'Leather')
insert into #tblInterior (InteriorId,Interior) values(3,'Mohair')

create table #tblCarMake (CarMakeId int, Make varchar(50))
insert into #tblCarMake (CarMakeId,Make) values(1,'Honda')
insert into #tblCarMake (CarMakeId,Make) values(2,'Toyota')
insert into #tblCarMake (CarMakeId,Make) values(3,'Ford')

create table #tblCarModel(CarModelId int, Model varchar(50))
insert into #tblCarModel (CarModelId,Model) values(1,'civic')
insert into #tblCarModel (CarModelId,Model) values(2,'prelude')
insert into #tblCarModel (CarModelId,Model) values(3,'4Runner') 


create table #tblCar (CarId int, CarMakeId int, CarModelId int, Vin int )
insert into #tblCar (CarId,CarMakeId,CarModelId) values(1,1,1)
insert into #tblCar (CarId,CarMakeId,CarModelId) values(2,2,3)
insert into #tblCar (CarId,CarMakeId,CarModelId) values(3,1,2)

create table #tblCar_Attributes (CarId int, AttributeTypeId int, Attribute int)
insert into #tblCar_Attributes (CarId, AttributeTypeId, Attribute) values 
(2,1,2)
insert into #tblCar_Attributes (CarId, AttributeTypeId, Attribute) values 
(2,2,1)
insert into #tblCar_Attributes (CarId, AttributeTypeId, Attribute) values 
(2,3,2)

select tcm.Model,tcmk.Make,tc.Color,tw.Wheel,ti.Interior
from
#tblCar as tcar
inner join #tblCarModel as tcm
on tcm.CarModelId=tcar.CarModelId
inner join #tblCarMake as tcmk
on tcmk.CarMakeId=tcar.CarMakeId
inner join #tblColor as tc
on tc.ColorId = (select attribute from #tblCar_Attributes 
where AttributeTypeId=1 and [EMAIL PROTECTED])
inner join #tblWheels as tw
on tw.WheelId = (select attribute from #tblCar_Attributes 
where AttributeTypeId=2 and [EMAIL PROTECTED])
inner join #tblInterior as ti
on ti.InteriorId = (select attribute from #tblCar_Attributes 
where AttributeTypeId=3 and [EMAIL PROTECTED])
where
[EMAIL PROTECTED]

ô¿ô Tony

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r an inner join and grouped output...

[Costas Piliotis]

Actually, in sql server, you can do this on one query using derived tables
too...  Kinda like doing two queries, but not quite...  Same idea though...

-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 3:32 PM
To: CF-Talk
Subject: RE: Arrrgh...that's not good...Re: Pagination (Next n records) fo r
an inner join and grouped output...


No you can't.  When you use aggregate functions in an SQL statement you MUST
put all of the fields you are selecting into the GROUP BY clause.  That
means you will need two queries since you want to select more fields than
you want to GROUP BY.

I wouldn't look down on yourself too much for that.  Two queries is not that
big a deal.  It's when you put queries inside loops that you deserve to be
shot ;)

+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 2:03 PM
To: CF-Talk
Subject: Re: Arrrgh...that's not good...Re: Pagination (Next n records) fo r
an inner join and grouped output...


on 6/12/03 4:47 PM, Bryan Love at [EMAIL PROTECTED] wrote:

> Post the code you are using to output the query.  The information you 
> are trying to display could make or break this effort.
> 
> I'm assuming you have something like this:
> 
> 
> #propertyID#
> ?
> 
> #some info#...
> 
> 

That's exactly my output...
 
> and you want to outputsay...10 propertyIDs per page?
> 
> Without running the SELECT COUNT DISTINCT... you will only be able to 
> use "next page" and "previous page" links because you won't know how 
> many
total
> pages there are.

Can I somehow calculate that DURING the inner join query below? I tried to
add it to the SELECT statement with disastrous results...


 SELECT * FROM
(tblRentalLocations INNER JOIN tblRentalProperties ON
tblRentalLocations.LocationID=tblRentalProperties.frn_LocationID)
INNER JOIN tblRentalRates ON
tblRentalProperties.PropertyID=tblRentalRates.frn_PropertyID

WHERE tblRentalProperties.PropertyBedrooms = #URL.Bedrooms#  ORDER BY
tblRentalProperties.PropertyName, tblRentalRates.RatesOrder,
tblRentalRates.RatesLength Desc  



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: OT~ but a good laugh:)

[Costas Piliotis]

That was my favourite thing about interdev 6 ...   all over the
place.  Ugliest code ever.  


-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 12, 2003 2:37 PM
To: CF-Talk
Subject: RE: OT~ but a good laugh:)


I have a couple of hosting clients who insist on using FrontPage.  They have
great looking sites, until you look at two of them and realise they've got
templates from some site somewhere and just changed the text.   

Then I get emails complaining how slow they are to load, and I see that the
150x50 images are actually 1800x600 images displayed at 150x50 so they
download the whole large uncompressed file.  Add to that all the burden code
they have with fragmented tags, font tags on and off everywhere, empty
paragraph tags, empty font tags, additional and unnecessary style tags etc
etc.. and you can take a page from 150kb down to about 15mb without doing a
lot of thinking.

Oh and  don't try to look at their sites with Netscape.

I do hope this new version is better. 


Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.




-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED] 
Sent: Friday, 13 June 2003 7:08 AM
To: CF-Talk
Subject: Re: OT~ but a good laugh:)

as usual you are correct jochem
heres the rest:
Microsoft announce FrontPage 2003 "We've really focused on generating

clean, industry-standard HTML code." they claim. We expect it to produce

proprietary, MS-oriented mark-up that only works in IE6. But then we're

cynical. Click here

 to read more.

Any of you going to stop using DMX and start using FrontPage? Tell us by

mailing Bruce Lawson 

- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 5:00 PM
Subject: Re: OT~ but a good laugh:)


> Dave Lyons wrote:
> > Microsoft announce FrontPage 2003 "We've really focused on 
> > generating clean, industry-standard HTML code." they claim.
>
> That would be quite a change. IIRC, during the anti-trust trials Bill 
> Gates himself has delivered sworn testimony that Frontpage is designed 
> to only work with IE.
>
> Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4