Re: [RE: HTTP/1.0 404 Object Not Found]

[Pooh Bear]

hehehe it says it's a syntax error!  look at your SQL, maybe you didn't 
write somethinig right, maybe u missed a quote or sumthin


>From: Julia Phu <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: [RE: HTTP/1.0 404 Object Not Found]
>Date: Thu, 31 May 2001 21:34:13 PDT
>
>Thank you all who replied.  It was a spelling error on the action page.  I 
>had
>it correct and now have a different error message. It is pretty weird. It 
>had
>been working until I created a new page for experiment.
>
>It now has the ODBC Error Code=37000 (Syntax error or access violation). I
>again verified the Datasource. It is working. Any suggestion to look into?
>
>
>Costas, the configuration had been set correctly. However, I did double
>checked to be sure. Thanks for the information.
>
>
>Salute,
>Julia Phu
>
>
>
>Costas Piliotis <[EMAIL PROTECTED]> wrote:
>First, check to see if the template name is correct...
>
>Check internet connection...
>
>Check dns server...
>
>If you want the index.cfm to appear, you need to add it to the Default
>Document List.
>
>Ensure MIME types are mapped properly in your web server...
>   - Make sure you have for each site an extension mapped.
>   In IIS, go to the site's properties -> Home Directory tab ->
>Configuration button
>   - You should have \bin\iscf.dll mapped to .cfm
>files.
>
>-Original Message-
>From: Julia Phu [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, May 31, 2001 11:02 AM
>To: CF-Talk
>Subject: HTTP/1.0 404 Object Not Found
>
>
>Hi, guru,
>
>Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It 
>is
>CF 4.5.
>
>Thank you.
>Julia Phu
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: DateFormat function of 4.0 not accurate

[David Shadovitz]

What if you use date/time objects rather than strings?  See CreateDateTime.
-David

On Thurs May 31 2001 JAIME HOI [SMTP:[EMAIL PROTECTED]] wrote:
> i realised that the date format function is not very accurate. For
> example, the below code will return me true, when in fact it should be
> false. Does anyone know how i can resolve this discrepancies?
> 
>   
>   
>   
>   
>DateFormat(Results.ClaimDate[1],"dd/mm/") ,DateFormat
> (Variables.ClamDate,"dd/mm/"),"d") EQ 0>
>   True
>   
>   False
>   

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

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

RE: CF Wireless

[Dylan Bromby]

steve;

obviously i run the cf-wireless list, but i subscribe to other wireless
lists as well.

i have to say the quality of the ones i belong to is not that great. when
the cf-wireless one gets going on certain topics it's very good because
there are a number of developers that have been building HDML/WML apps for a
couple years. i think the best resource is the developer forums at the
openwave (formerly phone.com) site.

http://updev.openwave.com

there's always a lot of activity and you'll find a LOT of knowledgeable
people there.

--dylan

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:29 PM
To: CF-Talk
Subject: CF Wireless


Other than the CF-Wireless mailing list, is anybody aware of other wireless
Cold Fusion resourecs such as tags, tutorials, etc...

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

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

HTML question

[Heidi Belal]

Hi all,
I'm a bit confused on a point in html and would very
much appreciate it if you could help!
I've taken graphics from a graphics designer in html
format.  Meaning he had designed the whole page in
photoshop and then cut it up using fireworks and saved
it as html.  Therefore what i got from him was a table
with all the graphics layed out correctly.  The
question is: the table i got from him was very complex
and not very clear in rows and columns.  So it was
hard for me to find out where i should stick in my
code etc...We worked together after the first version
was very complex and managed to get a more simple
table in the end, but i was wondering if i should just
take the images after they are cut up and create the
table myself and insert the images.  So which way is
it supposed to be done?  or does it matter?  

my second question is: Now that i have the graphics in
a table etc...how do i limit the size of the table so
that if i put another image in the middle and it's too
big the images don't all go separating all over the
place? (i hope you understand what i'm trying to say)
Your ideas and suggestions would be great!
thanks!
Heidi

=
Heidi Belal
ICQ# 32127109

A bus stops at a bus station.
A train stops at a train station.  On my desk
I have a work station...
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: SQL date.

[Neil H.]

Geeez guys maybe I wasn't clear but I want to do this in a stored procedure
so CF isn't in the picture.

Thanks,

Neil

- Original Message -
From: "Shawnea Carter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 9:31 PM
Subject: Re: SQL date.


> #Dateformat(yourdatefield,"mm/dd/")#
>
> HTH
>
> Shawnea Carter
> - Original Message -
> From: "Neil H." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 31, 2001 5:42 PM
> Subject: SQL date.
>
>
> > I would like SQL server to return the date in the format of mm/dd/
> > without the time.  Is this possible?  Actually I know it possible the
> > problem is how :)
> >
> >
> > Thanks,
> >
> > Neil
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: [RE: HTTP/1.0 404 Object Not Found]

[Julia Phu]

Thank you all who replied.  It was a spelling error on the action page.  I had
it correct and now have a different error message. It is pretty weird. It had
been working until I created a new page for experiment.

It now has the ODBC Error Code=37000 (Syntax error or access violation). I
again verified the Datasource. It is working. Any suggestion to look into?


Costas, the configuration had been set correctly. However, I did double
checked to be sure. Thanks for the information.


Salute,
Julia Phu



Costas Piliotis <[EMAIL PROTECTED]> wrote:
First, check to see if the template name is correct...

Check internet connection...

Check dns server...

If you want the index.cfm to appear, you need to add it to the Default
Document List.

Ensure MIME types are mapped properly in your web server...
- Make sure you have for each site an extension mapped.
In IIS, go to the site's properties -> Home Directory tab ->
Configuration button 
- You should have \bin\iscf.dll mapped to .cfm
files.

-Original Message-
From: Julia Phu [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 31, 2001 11:02 AM
To: CF-Talk
Subject: HTTP/1.0 404 Object Not Found


Hi, guru,

Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It is
CF 4.5.

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

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

RE: Delete session variable

[Jann VanOver]

You can use structDelete.

For example, to delete session.fldName, structDelete(session,fldName)

-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 8:21 PM
To: CF-Talk
Subject: Delete session variable


Is there a way to delete a session variable or cause
it to immediately expire?  Looking for something
similar to the DeleteClientVariable() function.

=
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
ICQ UIN: 916324
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CF Wireless

[Steve Reich]

Other than the CF-Wireless mailing list, is anybody aware of other wireless
Cold Fusion resourecs such as tags, tutorials, etc...

Thanks,
Steve



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

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

Re: SQL date.

[CT, Loo]

You can use the convert function with the style parameter as follows:-
convert(char(10),getdate(),101 )

Style parameters :
101   mm/dd/
110  mm-dd-

Hope this will help.

Regards,
CT  Loo
- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 5:42 AM
Subject: SQL date.


> I would like SQL server to return the date in the format of mm/dd/
> without the time.  Is this possible?  Actually I know it possible the
> problem is how :)
>
>
> Thanks,
>
> Neil
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

SQL Gurus - HELP!!!

[Stephen Collins]

Anyone help me with this one?  I'm trying to get a very restricted set of
object data based on object attributes stored in the Spectra properties
table.

SQL Query:


SELECT sm.chardata AS SiteModel,
sm.objectid AS ObjectID,
ix.integerdata AS L3Index
FROM properties AS sm, properties AS ix
WHERE sm.objectid=ix.objectid
AND sm.propertyname='sitemodel'
AND sm.chardata LIKE '#SearchTitle#%'
AND ix.integerdata=1
ORDER BY sm.chardata ASC


All this works, except that I am getting back too much data which I then
have to filter with CF code (unfortunately, too slow) by looping over the
query and excluding items with inappropriate data.

What I want to add to the query is a restriction that the return for
"sm.chardata AS SiteModel" can be a comma-separated list (as it already is),
but of no more then two items' length, e.g. I would accept "Quarantine,About
AQIS" but not "Food,Meat,Pork".  The SiteModel attribute is ALWAYS a comma
separated list of 1-4 items' length.  Currently, the query gets me back a
squillion hits which then have to be filtered down.  The whole process takes
about 30 seconds (which is about 27 seconds too long).

Does SQL support this?  Is there a better way?

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

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

Re: User Group "Roadshow" in June & July

[Joseph Thompson]

You know, Vancouver is just a little North of Los Angeles (well... maybe a
fair bit North).  I would happily drive the 4 hours to Van!

> Macromedia and our local User Groups are launching a FREE summer Road Show
> in North America.  Discussion will include a technical presentation on
> ColdFusion 5 and UltraDev working together.  This Road Show is in
> traditional User Group format, will be technical in nature, and will
include
> a presentation building a sample app with plenty of code!
>
> We also will be raffling off some cool stuff to registered attendees!
>
> More details and registration information can be found at
> http://www.allaire.com/company/events/usergroups/roadshow.cfm
>
> Dates and locations are as follows:
>
> June 13
> Chicago, Illinois User Group Road Show
> Chicago Marriott Downtown
> 540 North Michigan Avenue
> Chicago, IL 60611
> 6:30 PM
>
> June 20
> Washington DC User Group Road Show
> Marriott Wardman Park Hotel
> 2660 Woodley Road, NW
> Washington, DC 20008
> 6:30 PM
>
> June 25
> San Francisco User Group Road Show
> Macromedia, Inc.
> 600 Townsend Street
> San Francisco, CA 94103
> 6:30 PM
>
> June 26
> Los Angeles User Group Road Show
> The Los Angeles Film School
> 6363 Sunset Boulevard, Suite 400
> Hollywood, CA 90028
> 6:30 PM
>
> June 27
> Atlanta User Group Road Show
> Location not yet secured, details will be posted as soon as possible
>
> July 11
> Boston User Group Road Show
> Macromedia
> 275 Grove St.
> Newton, MA 02466
> 6:30 PM
>
> -S
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Exclude the includes!

[Joseph Thompson]

Same.  The "front end" is a little time consuming but the payback is no
overhead.



> I use CFHTTP to request the file and then CFFILE to write the resulting
> static HTML to a file.
>
> http://www.somedomain.com/DynamicCFMLPage.cfm"; method="GET"
> resolveurl="false">
>  output="#CFHTTP.FileContent#" addnewline="Yes">
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: IIS or Apache? (WAS RE: can anyone help?)

[Zac]

> I would recomment sticking with IIS on an NT box.  With CF
> and Apache, there
> were (at least for me) a bunch of bugs.

Well I think this is one of those YMMV moments. I ran Apache, CF 4.5 and
mySQL on an NT4 server for months with no problems at all. And it was, YMMV
again, more stable than when I was running IIS.


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

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

Delete session variable

[Bernd VanSkiver]

Is there a way to delete a session variable or cause
it to immediately expire?  Looking for something
similar to the DeleteClientVariable() function.

=
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
ICQ UIN: 916324
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Writing Custom Functions

[Don Vawter]

I am with ya. I have wanted that for a long time.

- Original Message -
From: "Avi Flax" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 8:47 PM
Subject: Re: Writing Custom Functions


> As long as we're talking about variable scopes, is there a structure that
I
> can get access to that contains all local variables? That is, variables
> that are in the "variables" scope. I have a debug routine at the bottom of
> all my pages that displays all application,session,form,url,request,cgi
> variables, and I would LOVE to be able to include local variables as well.
>
> Thanks!
> --
> Avi Flax
> Developer, Afternic.com
> [EMAIL PROTECTED]
> 212-798-5484
>
> "Art is the lie that makes us realize truth." - Pablo Picasso
>
> At 02:27 AM 5/31/2001 -0400, Michael Dinowitz wrote:
> >No scope unless it was directly loaded into something like the request or
> >server scopes.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF5 released - Macromedia?

[Ann Harrell]

Yes

> -Original Message-
> From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 6:37 PM
> To: CF-Talk
> Subject: CF5 released - Macromedia?
> 
> 
> Has anyone actually received an email from MM to advise that CF5 has been
> released (after signing up on the CF home page to be notified)?
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF5 released - Macromedia?

[John Wilker]

I did. I think it came yesterday.

"Dear ColdFusion Customer,

I’m very pleased to announce that Macromedia ColdFusion Server 5 is
nowavailable for purchase and evaluation. I’ve been working with
ColdFusionsince 1995 and I’m happy to say this release is the highest
performing,most widely tested release of ColdFusion yet.

With ColdFusion 5, we focused on what developers have been asking
for:greater productivity, simplified management, and enhanced
performance.ColdFusion 5 is packed with new features that help developers
move fromconcept to production faster than ever before. With ColdFusion 5,
youcan:
- Create your own user-defined functions
- Add data-driven graphs to Web sites and applications
- Query or join in-memory result sets using standard SQL
- Easily archive and deploy entire applications
- Configure custom probes to closely monitor live applications
- And much, much more

Here’s how to experience ColdFusion 5 yourself:
* DOWNLOAD your evaluation copy at:
http://www.macromedia.com/software/coldfusion/trial/

* LEARN MORE by calling 1-888-939-2545 or visiting:
http://www.macromedia.com/coldfusion

* UPGRADE and buy a subscription before June 30th and save up to $1000!For
details, go to:
http://www.macromedia.com/go/cfpromo/

Thank you for choosing ColdFusion and for guiding us with your feedbackand
suggestions. The improvements in ColdFusion 5 are a direct resultof customer
input. It’s an incredible pleasure to work with developersfrom the
ColdFusion community and I look forward to hearing more aboutthe amazing
applications being built with ColdFusion 5.

Regards,

Adam Berrey
VP, ColdFusion Product Management & Marketing
Macromedia, Inc.

P.S. Join us at DevCon 2001. To register and find out more, visit:
http://www.macromedia.com/go/devcon
==MACROMEDIA 
COLDFUSION 5 AVAILABILITY

The following products are now available for evaluation and purchase:

*** ColdFusion Server 5 Professional Edition for Windows ***
*** ColdFusion Server 5 Professional Edition for Linux ***
*** ColdFusion Server 5 Enterprise Edition for Windows ***
*** ColdFusion Server 5 Enterprise Edition for HP-UX ***

Note: The boxed product of ColdFusion Server 5 is scheduled to ship
startingin early June. Please allow 2-3 weeks for delivery.

The following products are scheduled for availability in August:

*** ColdFusion Server 5 Enterprise Edition for Linux ***
*** ColdFusion Server 5 Enterprise Edition for Solaris ***

P.S. We welcome the opportunity to assist you. If you have any
questions,please visit us at:
http://www.allaire.com/services/customerservice/index.cfm

Thank you for your 
continued interest in Macromedia products. If you'drather
not receive future emails about classes, product information,seminars,
parties, or updates, send an email to: [EMAIL PROTECTED] –type REMOVE ME in
the subject line.
"

J.

John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer

www.red-omega.com 

Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.


-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 4:37 PM
To: CF-Talk
Subject: CF5 released - Macromedia?


Has anyone actually received an email from MM to advise that CF5 has been
released (after signing up on the CF home page to be notified)?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF5 released - Macromedia?

[Dylan Bromby]

i was notified this week. however, i don't know if that's because i signed
up on the home page.


-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 4:37 PM
To: CF-Talk
Subject: CF5 released - Macromedia?


Has anyone actually received an email from MM to advise that CF5 has been
released (after signing up on the CF home page to be notified)?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Apache web server

[Dave Livingston]

*This message was transferred with a trial version of CommuniGate(tm) Pro*
Did you set up the cf module in the apache config file?

Adding the ColdFusion module
The ColdFusion Module can be found in the installation directory (usually
c:\cfusion\bin).

We assume below that your Apache installation is found in c:\Apache.

Copy the module (ApacheModuleColdFusion.dll) to your modules directory under
the Apache source directory.
ex. c:\Apache\modules\ApacheModuleColdFusion.dll
Edit the "httpd.conf" configuration file to contain the following line, this
can be found in c:\Apache\conf:

LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll

Hope that helps.

Dave Livingston
512.694.1669
[EMAIL PROTECTED]


-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 2:59 PM
To: CF-Talk
Subject: Apache web server


*This message was transferred with a trial version of CommuniGate(tm) Pro*

I have installed the Apache web server and when I get this page to test the
installation

http://127.0.0.1/CFDOCS/testinstallation/test.cfm

When I click on Verify query I get:

The requested method POST is not allowed for the URL
/CFDOCS/testinstallation/courses.cfm.

Also, I can't get the Cold Fusion Adminsitrator to launch. When the browser
launches a file download process starts and the funny thing is that the
encrypted index.cfm page shows up in the Studio Edit panel.

Any suggestions?

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

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

Re: can anyone help?

[sebastian palmigiani]

Thanks for all your help. I have got Apache working with ColdFusion.

Sebastian



on 5/31/01 4:39 PM, Dave Watts at [EMAIL PROTECTED] wrote:

>> OK. I have ditched PWS. I have installed Apache and
>> reinstalled ColdFusion and copied the DLL file and changed
>> the httpd.conf file in apache.
>> 
>> I cannot get the web server to start. When I click on start
>> apache I get a dos command window that goes so fast I can't
>> even read what it says. I was able to make out the following
>> however,
>> 
>> Apache.exe cannot determine local host name.
> 
> If you want to find out exactly what error is being returned, you can simply
> open a command prompt and run the command contained within the shortcut.
> 
>> I think the httpd.conf files needs further editing but I'm
>> not confident about what to change. I am guessing that the
>> following lines at the end of the conf file need to be changed.
>> I want to be able to have http://127.0.0.1/
> 
> If I recall correctly, when you set up Apache, all you should have to change
> within httpd.conf is add the LoadModule directive, change the DocumentRoot
> directive, and change the Directory directive, assuming you've got a
> properly configured TCP/IP stack bound to your network card.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

DateFormat function of 4.0 not accurate

[JAIME HOI]

hi
   i realised that the date format function is not very accurate. For
example, the below code will return me true, when in fact it should be
false. Does anyone know how i can resolve this discrepancies?







True

False



Thanks !


Jaime Hoi

Don't shut love out of your life by saying it's impossible to find.
The quickest way to receive love is to give;




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

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

RE: Exclude the includes!

[Ben Koshy]

I use CFHTTP to request the file and then CFFILE to write the resulting
static HTML to a file.

http://www.somedomain.com/DynamicCFMLPage.cfm"; method="GET"
resolveurl="false">

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

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

Re: IIS or Apache? (WAS RE: can anyone help?)

[Aaron Rouse]

I think Apache's site says it all:

"However, due to the code's legacy, and use of metaphors and systems which
are Unix-specific (such as, having multiple processes all accept()ing
connections to the same port), the road to porting to Windows NT has not
been a pretty one. Several attempts have been made, both by Apache Group
members and outside folks, but due to a lack of stability and a clear
consensus on how to manage a true cross-platform development project, NT is
not yet a standard platform supported by Apache. "

- Original Message -
From: "Costas Piliotis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 5:39 PM
Subject: RE: IIS or Apache? (WAS RE: can anyone help?)


> Actually, I found CF made Apache a bit unstable...  After I installed CF
> over Apache, I couldn't start Apache as a service any more - I had to run
> the command line version.  Not good if you don't want the server to remain
> logged in.
>
> I would recomment sticking with IIS on an NT box.  With CF and Apache,
there
> were (at least for me) a bunch of bugs.
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 10:47 AM
> To: CF-Talk
> Subject: RE: IIS or Apache? (WAS RE: can anyone help?)
>
>
> > Well now, since you'all have brought it up, and I never
> > really considered it, (big IIS fan)which is better on
> > a Win2k (advanced server)?
> >
> > IIS or Apache?
> >
> > Pros - Cons?
> > Good for both Development and Production?
> >
> > Would consider shelving IIS for Apache if there was good
> > reason to
>
> >From a functional perspective, both will work fine on Win2K, especially
for
> development. I think that IIS will perform better in production than
Apache
> on Windows, based on my experiences. This shouldn't be a surprise, since
> Microsoft has built IIS specifically to run very well on Windows.
>
> >From a security perspective, Apache is easier to secure than IIS,
although
> both can be secured adequately. Apache doesn't come with all kinds of
extra
> stuff like IIS does, so you don't have to remove and disable as much.
There
> are some people who think that IIS can't be secured
> (http://www.securityportal.com/articles/iis20010521.html), but it can be
> with a bit of diligence. The only "fatal flaw" with IIS, in my opinion, is
> that the service must run as SYSTEM so that it can impersonate other
users -
> if I understand correctly, this is required to support the integration of
> IIS authentication with NT authentication. So, if the IIS service gets
> compromised through a buffer overflow, any code executed as a result will
> run as SYSTEM. Actually, in Win2K, you might be able to change the IIS
> services so that they run as individual users. I haven't tried this yet,
> myself.
>
> If you're interested in taking advantage of Windows-specific
functionality,
> IIS will allow you to do that more easily and more often than Apache,
> generally.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: SQL date.

[Shawnea Carter]

#Dateformat(yourdatefield,"mm/dd/")#

HTH

Shawnea Carter
- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 5:42 PM
Subject: SQL date.


> I would like SQL server to return the date in the format of mm/dd/
> without the time.  Is this possible?  Actually I know it possible the
> problem is how :)
>
>
> Thanks,
>
> Neil
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: OT: SQL Server 2000

[Eron Cohen]

Art,

You can just use MS Access 2000's interface to hit SQL
Server 2000.  You may need to download a patch from
Microsoft because there were some changes going from
SQL Server 7.0 to 2000. (URL below).  It is definitely
the best way for folks who are used to MS Access to
work with a SQL Server.  The interface is very
similar, but there are "extra" features such as a tab
for stored proceedures, and instead of QUERIES its
called VIEWS.  There are times you will still need the
enterprise manager, but for most stuff MS Access works
fine.  To get started open MS Access 2000 and choose
FILE>NEW PROJECT>Existing Database and point it at
your SQL Server.

Eron

The URL:

http://officeupdate.microsoft.com/2000/downloaddetails/accsql.htm?FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D26675%26redirect%3Dno

-Original Message-
From: Art Broussard
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 2:51 PM
To: CF-Talk
Subject: OT: SQL Server 2000


I have a web site that has SQL Server 2000 on it. I
have never even thought of touching this database
until now. I want to go in and create some tables. I
was told I can install some application on my computer
that will allow me to connect to the SQL Sever. Then
use this program to create the tables I need.

Does anyone know what I'm talking about because I sure
don't : ]

TIA

Art

"Never put your finger where you wouldn't put your
nose."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: SQL date.

[Brandon Wood]

You will have to convert the ODBC DateTime to another format in the template
using the DateFormat function of CF.


#DateFormat("#date#", "mm/dd/")#


That should work...

- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 4:42 PM
Subject: SQL date.


> I would like SQL server to return the date in the format of mm/dd/
> without the time.  Is this possible?  Actually I know it possible the
> problem is how :)
>
>
> Thanks,
>
> Neil
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Correctly using CFOUTPUT

[Bill Davidson]

I've always been curious about that.  I saw Ben Forta speak once about that
issue, and have seen that here is well.  Is it just that the looping PCode
is just a lot more cumbersome because Allaire grouped so many different kind
of looping controls in one tag?  I don't get it, loops are usually low
overhead in other programming languages.

Hmm.. Maybe query based loops is where the problem lies.  They might have to
do a lot of conversion between a clean loop and a query resolution that adds
the overhead.

-Bill
www.brainbox.tv

- Original Message -
From: "Bill Killillay" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 4:35 PM
Subject: RE: Correctly using CFOUTPUT


> Since when is CFLOOP "faster" then CFOUTPUT?  I have seen on this list
many,
> many times that CFLOOP is one of the slowest tags in CF...  I see your
point
> about not wanting to execute more code then is needed, but a lot of it
> depends on what your doing.  But in a show down between CFOUTPUT and
CFLOOP,
> I say that CFOUTPUT with a query attribute beats CFLOOP hands down every
> day...
>
> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 2:00 PM
> To: CF-Talk
> Subject: RE: Correctly using CFOUTPUT
>
>
> > Hi, I've always been curious about this. What is the correct way? Does
it
> > matter?
> 
> > Is there an unwritten rule; if there are more than 4 (or ?) vars in a
page
> > Listing 1 is a good way to do it else Listing 2 is recommended?
> > I'm assuming when using  Listing 1 would
> > always be applicable.
>
> OK, there are 2 ways to look at this;
> 1) What's easier for you (and your team) to read and update
> 2) What's faster on then server when it's PCode
>
> In answer to this, Listing 1 is always easier to read, but is slower on
the
> server
> "Why?" you ask (sounds of "Why?" from all over the world)...
>
> Here's how the CF Server looks at a template (if you don't have CFSetting
> EnableCFOutputOnly="Yes" on);
> It sends everything straight to the browser that's not a CF tag outside of
a
> CFOutput without even thinking, once it reaches a CFOutput it has to scan
> through the code to find if anything requires any conversion from
> function/variable/field contents into displayable values and then converts
> those...
>
> When you don't have any functions/variables/fields in the code, you're
> effectively making CF work for nothing
>
> Remeber that a file being larger in size (before PCode) means nothing to
how
> fast it might run on the server - it's the actual work that the server is
> doing that's more important
>
> If you wanted the best performance from a CFOutput query="" tag, then you
> should use CFLoop query="" and only CFOutput the fields
>
> Hope this helps explain why and why not to use CFOutput on everything
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Is it possible to nest CFQUERY inside CFLOOP?

[Bill Davidson]

You're absolutely correct.  I think someone answered this question earlier
with the correct response.


#loop_index#


You'll get a bunch of #loop_index#'s.

However


#loop_index#


works as intended.

Like you said, the variables in his block were resolved because they were
inside of a cfquery tag block, but it is at least worth noting that 
doesn't parse and resolve variables on its own.  Thanks for pointing that
out.

And I think the conclusion was that the lst_region list attribute was
surrounded by pounds, so it wasn't resolving into an actual list?

-Bill
www.brainbox.tv

- Original Message -
From: "David E. Crawford" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 3:10 PM
Subject: Re: Is it possible to nest CFQUERY inside CFLOOP?


> The cfoutput inside a cfloop is unnecessary to resolve the variables
within
> the cfquery block.  I use cfquery inside cfloop all the time to do any
> number of different things.  There is something else going on with the
code
> if it is not working.
>
> DC
>
> - Original Message -
> From: "Bill Davidson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 31, 2001 13:05
> Subject: Re: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> > You should be able to nest cfquery in a cfloop that is not query
based...
> > Maybe the actual problem is that cfloop doesn't implicitly force a
> cfoutput,
> > so chances are your variables are not getting resolved.  Include a
> >  inside the loop.
> >
> > Here's a code snippet where I am nesting a query inside a loop:
> > 
> >  
> >
> >   
> >
> >SELECT  dbo.Jobs.Jobs_Job_Name, dbo.Employee_Job_Rates.*
> >   FROM {oj dbo.Jobs LEFT OUTER JOIN dbo.Employee_Job_Rates ON
> > dbo.Jobs.Jobs_ID = dbo.Employee_Job_Rates.Employee_job_rates_job_id }
> >   where Employee_job_rates_employee_id = #attributes.user_id#
> >   and dbo.Jobs.Jobs_Job_Name = '#jobs_names[loop_index]#'
> >
> >  
> > .
> > 
> > 
> >
> > The only other thing I could think of is the list attribute for cfloop.
> > Maybe cold fusion internally handles lists as a query.  Maybe just do a
> > "from to" loop and only do the query and related code when the index is
in
> > the list.  That's what I am doing in the previous block of code, except
> with
> > arrays.
> >
> > HTH,
> > -Bill
> > www.brainbox.tv
> >
> > - Original Message -
> > From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, May 31, 2001 11:38 AM
> > Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?
> >
> >
> > > I just noticed the loop index variable is wrong, I changed it to from
> "i"
> > to
> > > "region" as it should be and still got the same error message...
> > >
> > > -Original Message-
> > > From: Kevin Gilchrist
> > > Sent: Thursday, May 31, 2001 11:32 AM
> > > To: CF-Talk (E-mail)
> > > Subject: Is it possible to nest CFQUERY inside CFLOOP?
> > >
> > >
> > > I get an error when I try to do this:
> > >
> > > 
> > >  > > dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
> > > SELECT
> > >   sum(severity_minutes) as sev_sum,
> > >   max(total_minutes)
> > > FROM
> > >   history_view,
> > >   site_name
> > > WHERE
> > >   query_id =259 AND
> > >   node='RS_CHARMING1' AND
> > >   severity=5 AND
> > >   customer_name='CHARMING' AND
> > >   application='RS_PING' AND
> > >   region=#i#
> > > 
> > > 
> > >
> > > The error message is:
> > >
> > > Just in time compilation error
> > > A nested CFQUERY tag has been encountered at document position (455:2)
> to
> > > (455:130). CFQuery tags cannot be nested inside one another.
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFMail and Carriage Returns

[Ben Koshy]

You could add:



Alot of computers insert both the Carriage Return (13) and the New Line
Character (10) to create a line break.

Although why your CFMAIL is behaving that way is beyond me...
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

ColdFusion and WML browser

[Laszlo Nadai]

Hi all,

It used to work:
I was using CF-Studio 4.5.1 to develop WML templates. I had M3Gate
installed as a WML browser.
When I wanted to view the template from CF, I just just hit on the
external browser icon and it displayed the page on M3Gate.
Now I keep getting "HTTP 502 Bad Gateway" on the M3Gate emulator.
All this happened (I think) after I installed WinGate on my network. I
uninstalled it, but the problem is still the same.

Q: How can I add (any) WML emulator to the CF IDE?

Thanks in advance,
laszlo



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

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

Re: Writing Custom Functions

[Avi Flax]

As long as we're talking about variable scopes, is there a structure that I 
can get access to that contains all local variables? That is, variables 
that are in the "variables" scope. I have a debug routine at the bottom of 
all my pages that displays all application,session,form,url,request,cgi 
variables, and I would LOVE to be able to include local variables as well.

Thanks!
--
Avi Flax
Developer, Afternic.com
[EMAIL PROTECTED]
212-798-5484

"Art is the lie that makes us realize truth." - Pablo Picasso

At 02:27 AM 5/31/2001 -0400, Michael Dinowitz wrote:
>No scope unless it was directly loaded into something like the request or
>server scopes.


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

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

CF5 released - Macromedia?

[Peter Tilbrook]

Has anyone actually received an email from MM to advise that CF5 has been
released (after signing up on the CF home page to be notified)?


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

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

RE: Exclude the includes!

[Costas Piliotis]

If you want to output static content on a scheduled basis, you can use the
scheduling feature in CF Administrator and output to an HTML file.

That's the only way I know (other than good ol' copy & paste)

=)

-Original Message-
From: Christophe Glaudel [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 31, 2001 10:23 AM
To: CF-Talk
Subject: Exclude the includes!


Maybe you can answer a problem I encounter now.

The pages of our website are full of includes and I would like to generate
automaticly the same site to set on the server all the pages files without
includes in the cfm textfile of the pages for example

a page like that :








could be transformed into a file like that to optimise the cold fusion
server work :

//content of includes/toppub/toppub.cfm LIBERTY
SURF
  var agent = navigator.userAgent.toLowerCase();
var ver = parseInt(navigator.appVersion); if ((agent.indexOf("mozilla") !-1) && (ver 
>= 4) && (navigator.appName.indexOf("Netscape") != -1))
document.write(''); else document.write(''); function MM_reloadPage(init) { if
(init==true) with (navigator) {if
((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight;
onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW ||
innerHeight!=document.MM_pgH) location.reload();}
MM_reloadPage(true);   

  http://www.libertysurf.fr/img/ang_noir.gif"; WIDTH=15 HEIGHT=15>
 http://www.libertysurf.fr";>http://www.libertysurf.fr/img/logolshome.gif"; WIDTH=127 HEIGHT=37
BORDER=0 ALT="Liberty Surf"> 






http://pub.libertysurf.fr/html.ng/category=/liberty_photo&site=liberty";
>
http://pub.libertysurf.fr/js.ng/Params.richmedia=yes&category=/liberty_
photo&site=liberty">

http://pub.libertysurf.fr/click.ng/Params.richmedia=yes&category=/libe
rty_photo&site=liberty">
http://pub.libertysurf.fr/image.ng/Params.richmedia=yes&category=/liber
ty_photo&site=liberty">




 

//end of content
//content of includes/topnavhaut/topnavhaut.cfm
etc...
.
//end of html page


If you have any ideas using any software.
You maybe have more experienced.
Thank for any reply

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

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

RE: IIS or Apache? (WAS RE: can anyone help?)

[Costas Piliotis]

Actually, I found CF made Apache a bit unstable...  After I installed CF
over Apache, I couldn't start Apache as a service any more - I had to run
the command line version.  Not good if you don't want the server to remain
logged in.

I would recomment sticking with IIS on an NT box.  With CF and Apache, there
were (at least for me) a bunch of bugs.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 31, 2001 10:47 AM
To: CF-Talk
Subject: RE: IIS or Apache? (WAS RE: can anyone help?)


> Well now, since you'all have brought it up, and I never
> really considered it, (big IIS fan)which is better on 
> a Win2k (advanced server)?
> 
> IIS or Apache?
> 
> Pros - Cons?
> Good for both Development and Production?
> 
> Would consider shelving IIS for Apache if there was good
> reason to

>From a functional perspective, both will work fine on Win2K, especially for
development. I think that IIS will perform better in production than Apache
on Windows, based on my experiences. This shouldn't be a surprise, since
Microsoft has built IIS specifically to run very well on Windows.

>From a security perspective, Apache is easier to secure than IIS, although
both can be secured adequately. Apache doesn't come with all kinds of extra
stuff like IIS does, so you don't have to remove and disable as much. There
are some people who think that IIS can't be secured
(http://www.securityportal.com/articles/iis20010521.html), but it can be
with a bit of diligence. The only "fatal flaw" with IIS, in my opinion, is
that the service must run as SYSTEM so that it can impersonate other users -
if I understand correctly, this is required to support the integration of
IIS authentication with NT authentication. So, if the IIS service gets
compromised through a buffer overflow, any code executed as a result will
run as SYSTEM. Actually, in Win2K, you might be able to change the IIS
services so that they run as individual users. I haven't tried this yet,
myself.

If you're interested in taking advantage of Windows-specific functionality,
IIS will allow you to do that more easily and more often than Apache,
generally.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: HTTP/1.0 404 Object Not Found

[Costas Piliotis]

First, check to see if the template name is correct...

Check internet connection...

Check dns server...

If you want the index.cfm to appear, you need to add it to the Default
Document List.

Ensure MIME types are mapped properly in your web server...
- Make sure you have for each site an extension mapped.
In IIS, go to the site's properties -> Home Directory tab ->
Configuration button 
- You should have \bin\iscf.dll mapped to .cfm
files.

-Original Message-
From: Julia Phu [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 31, 2001 11:02 AM
To: CF-Talk
Subject: HTTP/1.0 404 Object Not Found


Hi, guru,

Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It is
CF 4.5.

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

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

RE: HTTP/1.0 404 Object Not Found

[Tony Gruen]

Not to sound silly but 404 means only one thing. Not found. This is not a
cold fusion related error and is most likely due to the fact that a link is
mis-typed or the page is missing from the web server directory.

Tony Gruen

-Original Message-
From: Julia Phu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 11:02 AM
To: CF-Talk
Subject: HTTP/1.0 404 Object Not Found


Hi, guru,

Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It is
CF 4.5.

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

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

Re: OT: SQL Server 2000

[Jeffry Houser]

   Easiest thing for you to do is get enterprise manager / Query Analyzer.

   You can order the SQL Server evaluation CD for about $10 off of the 
microsoft web site.  (I.E. Enterprise Manager and Query Analyzer do not 
time out).  You will not be able to run a local SQL Server on Windows 
95/98/Me but the client tools (I.E. Enterprise Manager / Query Analyzer) 
will work.

   You could order the development version of SQL Server (About $500).  If 
you don't have NT / 2000 and/or don't need to run a developmental version 
of SQL Server, this probably isn't worth the cost.

You could sign up for MSDN, which gives you a boat-load of MS products 
for development purposes.  I think if you become a business partner (?), 
the cost is even cheaper.


At 01:51 PM 05/31/2001 -0500, you wrote:
>I have a web site that has SQL Server 2000 on it. I have never even 
>thought of touching this database until now. I want to go in and create 
>some tables. I was told I can install some application on my computer that 
>will allow me to connect to the SQL Sever. Then use this program to create 
>the tables I need.
>
>Does anyone know what I'm talking about because I sure don't : ]
>
>TIA
>
>Art
>
>"Never put your finger where you wouldn't put your nose."
>
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL Server 2000

[Lee Fuller]

Yes.. it comes with SQL 2000.  It's called "Enterprise Manager".  Take a
look at the client tools on the disc.


Lee Fuller
Chief Technical Officer
PrimeDNA Corporation / AAA Web Hosting Corporation
"We ARE the net."
http://www.aaawebhosting.com



> -Original Message-
> From: Art Broussard [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 11:51 AM
> To: CF-Talk
> Subject: OT: SQL Server 2000
>
>
> I have a web site that has SQL Server 2000 on it. I have never
> even thought of touching this database until now. I want to go in
> and create some tables. I was told I can install some application
> on my computer that will allow me to connect to the SQL Sever.
> Then use this program to create the tables I need.
>
> Does anyone know what I'm talking about because I sure don't : ]
>
> TIA
>
> Art
>
> "Never put your finger where you wouldn't put your nose."
>
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFSET / UPDATE SQL

[David Clay]

Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a 
blank space, thus producing an error.

Code below:

 
 SELECT ClassSchedID, InputDate, WaitList, RegistrationID
 FROM ClassRegistration
 WHERE InputDate  (SELECT MIN(InputDate)
  FROM ClassRegistration
  WHERE ClassSchedID=9)
 

 
  

 
  UPDATE ClassRegistration
  SET 
   ClassSchedID=#ClassID#,
   WaitList=NULL,
   ModifiedDate=#Now()#
  WHERE RegistrationID='#RegID#'
 

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
  


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

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

RE: SQL Server 2000

[Dan Phillips]

You need Enterprise Manager. This should be on the same CD that you used to
install SQL server. Just run that CD on your workstation and choose the
install for the Network Tools.

Dan Phillips
www.cfxhosting.com

-Original Message-
From: Art Broussard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 2:51 PM
To: CF-Talk
Subject: OT: SQL Server 2000


I have a web site that has SQL Server 2000 on it. I have never even thought
of touching this database until now. I want to go in and create some tables.
I was told I can install some application on my computer that will allow me
to connect to the SQL Sever. Then use this program to create the tables I
need.

Does anyone know what I'm talking about because I sure don't : ]

TIA

Art

"Never put your finger where you wouldn't put your nose."
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: HTTP/1.0 404 Object Not Found

[Bill Davidson]

If you can answer that VERY precisely, then you can also answer what is the
meaning of life, is there a God, do UFO's exist and ... Can't think of
anything else - not that creative today... you're asking a very big question
or at least very vague.

Oh well, I'll try for real:

404 - file not found. There's infinite reasons why this could happen, try
making sure the file is really there and if you are using a mapping, make
sure the mapping is set right in CF and/or IIS.

-Bill
www.brainbox.tv

- Original Message -
From: "Julia Phu" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 2:02 PM
Subject: HTTP/1.0 404 Object Not Found


> Hi, guru,
>
> Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It
is
> CF 4.5.
>
> Thank you.
> Julia Phu
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

SQL date.

[Neil H.]

I would like SQL server to return the date in the format of mm/dd/
without the time.  Is this possible?  Actually I know it possible the
problem is how :)


Thanks,

Neil


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

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

RE: Is this an Access limitation ?

[Ryan Sabir]

Could it be that you need to 'PreserveSingleQuotes()' in the SQL statement
i.e.


  SELECT item_id
  FROM inv_mast
  WHERE  partnumber NOT
 IN(#PreserveSingleQuotes(QuotedValueList(getproducts.partnumber))#) AND
manufacturer_id = 4


I've fallen for that more times than I care to remember


-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, 1 June 2001 4:08 AM
To: CF-Talk
Subject: RE: Is this an Access limitation ?


> The code below throws an error whenever I try to run it... What
> am I doing wrong ?
>
>  Thanks in Advance...
>
> 
>  SELECT partnumber
>  FROM products
>  WHERE manufacturer_id = 4
>  
>
> 
>  SELECT item_id
>  FROM inv_mast
>  WHERE  partnumber NOT
> IN(#QuotedValueList(getproducts.partnumber)#) AND manufacturer_id = 4
>   

Firstly, what datatype is PartNumber in Access?

If it's a number, then use ValueList(PartNumber) rather than
QuotedValueList(PartNumber)

If it's not, put the SQL to the display before you run the SQL to make sure
it "should" run - try it in Access if needs be

Also, check the getProducts.RecordCount - if it's 0 then the SQL will break
no matter what database engine you throw it at...

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: HTTP/1.0 404 Object Not Found

[Dave Watts]

> Please help on how to resolve the HTTP/1.0 404 Object Not 
> Found error. It is CF 4.5.

This isn't really a programming error, as such. If you request any
nonexistent URL that ends in .cfm, you'll get that error. For example:

http://www.allaire.com/imadethisup.cfm

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

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

RE: can anyone help?

[Dave Watts]

> OK. I have ditched PWS. I have installed Apache and 
> reinstalled ColdFusion and copied the DLL file and changed 
> the httpd.conf file in apache.
> 
> I cannot get the web server to start. When I click on start 
> apache I get a dos command window that goes so fast I can't 
> even read what it says. I was able to make out the following 
> however,
> 
> Apache.exe cannot determine local host name.

If you want to find out exactly what error is being returned, you can simply
open a command prompt and run the command contained within the shortcut.

> I think the httpd.conf files needs further editing but I'm 
> not confident about what to change. I am guessing that the 
> following lines at the end of the conf file need to be changed. 
> I want to be able to have http://127.0.0.1/

If I recall correctly, when you set up Apache, all you should have to change
within httpd.conf is add the LoadModule directive, change the DocumentRoot
directive, and change the Directory directive, assuming you've got a
properly configured TCP/IP stack bound to your network card.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

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

User Group "Roadshow" in June & July

[scoe]

Macromedia and our local User Groups are launching a FREE summer Road Show
in North America.  Discussion will include a technical presentation on
ColdFusion 5 and UltraDev working together.  This Road Show is in
traditional User Group format, will be technical in nature, and will include
a presentation building a sample app with plenty of code!

We also will be raffling off some cool stuff to registered attendees!

More details and registration information can be found at
http://www.allaire.com/company/events/usergroups/roadshow.cfm

Dates and locations are as follows: 

June 13 
Chicago, Illinois User Group Road Show
Chicago Marriott Downtown
540 North Michigan Avenue
Chicago, IL 60611
6:30 PM 

June 20 
Washington DC User Group Road Show
Marriott Wardman Park Hotel
2660 Woodley Road, NW
Washington, DC 20008
6:30 PM 

June 25 
San Francisco User Group Road Show
Macromedia, Inc.
600 Townsend Street
San Francisco, CA 94103
6:30 PM 

June 26 
Los Angeles User Group Road Show
The Los Angeles Film School
6363 Sunset Boulevard, Suite 400
Hollywood, CA 90028
6:30 PM 

June 27 
Atlanta User Group Road Show
Location not yet secured, details will be posted as soon as possible

July 11
Boston User Group Road Show
Macromedia
275 Grove St.
Newton, MA 02466
6:30 PM 

-S



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

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

Re: HTTP/1.0 404 Object Not Found

[Pooh Bear]

what a very cute error!  :)  hehe.  the page doesn't exist, or you didn't 
use the right urls


>From: Julia Phu <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: HTTP/1.0 404 Object Not Found
>Date: Thu, 31 May 2001 11:02:06 PDT
>
>Hi, guru,
>
>Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It 
>is
>CF 4.5.
>
>Thank you.
>Julia Phu
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFMail and Carriage Returns

[Chris Martin]

I have a question about cfmail, and it is driving me nuts.

Basically, I have a question answer board, and every time a user posts a
question, it sends email to a bunch of people.
The only problem, is that if the user happen to press the enter key to start
a new line, the email form cfmail will immediately cut off the message at
that point.

I use this:



to convert carriage returns to line breaks, but that doesn't help.  Removing
it doesn't seem to help either.
I am sending the mail as html (I have no choice, its what they want)

Anybody have a fix for this?  Thanks in advance,


Chris Martin


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

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

Re: Is this an Access limitation ?

[Tracy Bost]

Thanks for the help.
 I was too quick to blame it on access, but if I looked at the error just a
little bit better I would have seen that the field partnumber didn't exist
on the access table..
blah
- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 1:07 PM
Subject: RE: Is this an Access limitation ?


> > The code below throws an error whenever I try to run it... What
> > am I doing wrong ?
> >
> >  Thanks in Advance...
> >
> > 
> >  SELECT partnumber
> >  FROM products
> >  WHERE manufacturer_id = 4
> >  
> >
> > 
> >  SELECT item_id
> >  FROM inv_mast
> >  WHERE  partnumber NOT
> > IN(#QuotedValueList(getproducts.partnumber)#) AND manufacturer_id = 4
> >   
>
> Firstly, what datatype is PartNumber in Access?
>
> If it's a number, then use ValueList(PartNumber) rather than
> QuotedValueList(PartNumber)
>
> If it's not, put the SQL to the display before you run the SQL to make
sure
> it "should" run - try it in Access if needs be
>
> Also, check the getProducts.RecordCount - if it's 0 then the SQL will
break
> no matter what database engine you throw it at...
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Select Boxes <> limiting drop down :: Please Look

[Paul Ihrig]

Jann that . was a typo.
but thanks
yes EmployeeName is an id
-paul

"Whatever you can do, or dream you can, begin it. 
Boldness has genius, power, and magic in it." - Goethe

web developer, nbbj
work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

home:   [EMAIL PROTECTED]
614 449-1681

> icq:  47658358


-Original Message-
From: Jann VanOver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 1:02 PM
To: CF-Talk
Subject: RE: Select Boxes <> limiting drop down :: Please Look


Your query and select look a bit screwy.  In your query you are selecting
all rows where the name is not equal to the ID.  Is that really what you
wanted?  Go back to your original queries -- you were trying to select all
where #get_golf.employeeName# <> .employeeID  Did you really mean to compare
name to ID?  And why the "." ??  IF #get_golf.employeeName# is REALLY an ID,
remove the period.  THEN your select statement:



SELECTED>#rs_Employees.LastName#
#rs_Employees.FirstName#



Which one are you trying to select?  This will result in ALL being selected
because #rs_Employees.EmployeeID# is ALWAYS equal to
#rs_Employees.EmployeeID#


Should be more like:


SELECTED>#LastName#
#FirstName#






SELECT DISTINCT EmployeeID, FirstName, LastName, Email, EmployeeName 
FROM tbl_Employee, GOLF
WHERE EmployeeName <> EmployeeID
ORDER BY LastName 
DESC; 




SELECTED>#rs_Employees.LastName#
#rs_Employees.FirstName#



But then i get all sorts of duplicates.

-paul

"Whatever you can do, or dream you can, begin it. 
Boldness has genius, power, and magic in it." - Goethe

web developer, nbbj
work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

home:   [EMAIL PROTECTED]
614 449-1681

> icq:  47658358


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:13 AM
To: CF-Talk
Subject: Select Boxes <> limiting drop down :: Brian Lock


Ok i know this is simple but i have forgot something
i want to limit the returned names on a select box to 
only those who have not signed up!



SELECT GolfID, EmployeeName 
FROM tbl_Golf 




SELECT EmployeeID, FirstName, LastName, Email
FROM tbl_Employee
WHERE #Get_Golf.EmployeeName# <> .EmployeeID
ORDER BY LastName 
DESC; 






SELECTED>#rs_Employees.LastName#
#rs_Employees.FirstName#



Thank You!

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

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

RE: Correctly using CFOUTPUT

[J Winter]

Great, thanks for your expertise Philip. Just what I was looking for. Can
you explain this part a little more? I didn't quite get it.

>If you wanted the best performance from a CFOutput query="" tag, then you
>should use CFLoop query="" and only CFOutput the fields

Thanks,

Josh


-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 2:00 PM
To: CF-Talk
Subject: RE: Correctly using CFOUTPUT


> Hi, I've always been curious about this. What is the correct way? Does it
> matter?

> Is there an unwritten rule; if there are more than 4 (or ?) vars in a page
> Listing 1 is a good way to do it else Listing 2 is recommended?
> I'm assuming when using  Listing 1 would
> always be applicable.

OK, there are 2 ways to look at this;
1) What's easier for you (and your team) to read and update
2) What's faster on then server when it's PCode

In answer to this, Listing 1 is always easier to read, but is slower on the
server
"Why?" you ask (sounds of "Why?" from all over the world)...

Here's how the CF Server looks at a template (if you don't have CFSetting
EnableCFOutputOnly="Yes" on);
It sends everything straight to the browser that's not a CF tag outside of a
CFOutput without even thinking, once it reaches a CFOutput it has to scan
through the code to find if anything requires any conversion from
function/variable/field contents into displayable values and then converts
those...

When you don't have any functions/variables/fields in the code, you're
effectively making CF work for nothing

Remeber that a file being larger in size (before PCode) means nothing to how
fast it might run on the server - it's the actual work that the server is
doing that's more important

If you wanted the best performance from a CFOutput query="" tag, then you
should use CFLoop query="" and only CFOutput the fields

Hope this helps explain why and why not to use CFOutput on everything

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Is this an Access limitation ?

[Lon Lentz]

  Without seeing the error message, you may need a preservesinglequotes
around the quotedvaluelist in the second query.


Lon Lentz
Applications Developer & CyberEntomologist - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210


At 11:40 AM 5/31/2001 -0500, Tracy Bost wrote:
>The code below throws an error whenever I try to run it... What am I doing
>wrong ?
>
>  Thanks in Advance...
>
>
>  SELECT partnumber
>  FROM products
>  WHERE manufacturer_id = 4
>  
>
>
>  SELECT item_id
>  FROM inv_mast
>  WHERE  partnumber NOT IN(#QuotedValueList(getproducts.partnumber)#) AND
> manufacturer_id = 4
>   


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

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

RE: Select Boxes <> limiting drop down :: Please Look

[Jann VanOver]

There's a CF function that should replace your 
Change:
#Get_Golf.EmployeeName#,
To:
#valueList(Get_Golf.EmployeeName)#

-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:48 AM
To: CF-Talk
Subject: RE: Select Boxes <> limiting drop down :: Please Look


thanks Alistair.
but i just did this, it may be way wrong.
it works but if you know it is bad, please let me know



SELECT DISTINCT EmployeeName 
FROM tbl_Golf 
GROUP BY EmployeeName



SELECT FirstName, LastName, Email, EmployeeID
FROM tbl_Employee
WHERE EmployeeID NOT IN (
#Get_Golf.EmployeeName#,
)
ORDER BY LastName 
DESC; 



SELECTED>#rs_Employees.LastName#
#rs_Employees.FirstName#



FwW man what a day :]
thanks again

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

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

RE: Correctly using CFOUTPUT

[Bill Killillay]

Since when is CFLOOP "faster" then CFOUTPUT?  I have seen on this list many,
many times that CFLOOP is one of the slowest tags in CF...  I see your point
about not wanting to execute more code then is needed, but a lot of it
depends on what your doing.  But in a show down between CFOUTPUT and CFLOOP,
I say that CFOUTPUT with a query attribute beats CFLOOP hands down every
day...

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 2:00 PM
To: CF-Talk
Subject: RE: Correctly using CFOUTPUT


> Hi, I've always been curious about this. What is the correct way? Does it
> matter?

> Is there an unwritten rule; if there are more than 4 (or ?) vars in a page
> Listing 1 is a good way to do it else Listing 2 is recommended?
> I'm assuming when using  Listing 1 would
> always be applicable.

OK, there are 2 ways to look at this;
1) What's easier for you (and your team) to read and update
2) What's faster on then server when it's PCode

In answer to this, Listing 1 is always easier to read, but is slower on the
server
"Why?" you ask (sounds of "Why?" from all over the world)...

Here's how the CF Server looks at a template (if you don't have CFSetting
EnableCFOutputOnly="Yes" on);
It sends everything straight to the browser that's not a CF tag outside of a
CFOutput without even thinking, once it reaches a CFOutput it has to scan
through the code to find if anything requires any conversion from
function/variable/field contents into displayable values and then converts
those...

When you don't have any functions/variables/fields in the code, you're
effectively making CF work for nothing

Remeber that a file being larger in size (before PCode) means nothing to how
fast it might run on the server - it's the actual work that the server is
doing that's more important

If you wanted the best performance from a CFOutput query="" tag, then you
should use CFLoop query="" and only CFOutput the fields

Hope this helps explain why and why not to use CFOutput on everything

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Crazy Dynamic Update/FORM Structure question

[Willy Ray]

Ok, I'm having some trouble here.  I don't know what the form looks like, as it's 
being generated dynamically.  So, I figure, I'll have to loop through the FORM 
structure, and run a seperate update for each form element.

Here's what I'm doing:




 UPDATE contentitems
 SET objectcontent='#form["#i#"]#'
 WHERE objectname='#i#'
 AND page='#FORM.page#'
 



Now the first element of the loop it will hit will be a field from the form called 
"Body."  It's the first possibility, alphabetically.  And value is going to be a 
really long string of text.  I've set "page" on the form earlier on.

It should come out like this:

UPDATE contentitems
SET objectcontent = 'great big long string of text...'
WHERE objectname = 'BODY'
AND page = '1'

And it does, but I get an error:

ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query 
expression  "great big long string of text running out to a point at which it gets 
truncat'

Then it shows my sql, and it really does look like I had hope it would...Am I just 
missing something in my update statement?

Willy



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

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

Apache web server

[sebastian palmigiani]

I have installed the Apache web server and when I get this page to test the
installation

http://127.0.0.1/CFDOCS/testinstallation/test.cfm

When I click on Verify query I get:

The requested method POST is not allowed for the URL
/CFDOCS/testinstallation/courses.cfm.

Also, I can't get the Cold Fusion Adminsitrator to launch. When the browser
launches a file download process starts and the funny thing is that the
encrypted index.cfm page shows up in the Studio Edit panel.

Any suggestions?

Sebastian



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

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

Re: Exclude the includes!

[G]

This is kind of a weird idea/scenario, but couldn't you write a colf fusion
template that reads in the text of a cfm template, searches for
, then goes out and reads in the text from THAT .cfm template,
and outputs that text to a third file.  This third file would then slowly be
built to contain all the included code of the first .cfm template??


- Original Message -
From: "Christophe Glaudel" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 12:22 PM
Subject: Exclude the includes!


> Maybe you can answer a problem I encounter now.
>
> The pages of our website are full of includes and I would like to generate
> automaticly the same site to set on the server all the pages files without
> includes in the cfm textfile of the pages
> for example
>
> a page like that :
>
> 
> 
> 
> 
> 
> 
>
> could be transformed into a file like that to optimise the cold fusion
> server work :
>
> //content of includes/toppub/toppub.cfm
> LIBERTY SURF content="text/html;charset=iso-8859-1">
> 
> 
> var agent =
navigator.userAgent.toLowerCase();
> var ver = parseInt(navigator.appVersion); if ((agent.indexOf("mozilla")
> != -1) && (ver >= 4) && (navigator.appName.indexOf("Netscape") != -1))
> document.write(' TYPE="text/css">'); else document.write(' REL="stylesheet" TYPE="text/css">'); function MM_reloadPage(init) { if
> (init==true) with (navigator) {if
> ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
> document.MM_pgW=innerWidth; document.MM_pgH=innerHeight;
> onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW ||
> innerHeight!=document.MM_pgH) location.reload();}
> MM_reloadPage(true);
> 
>  MARGINWIDTH="0">
> 
>
>  align="center" height=68>
> 
> http://www.libertysurf.fr/img/ang_noir.gif"; WIDTH=15 HEIGHT=15>
> 
> http://www.libertysurf.fr";> src="http://www.libertysurf.fr/img/logolshome.gif"; WIDTH=127 HEIGHT=37
> BORDER=0 ALT="Liberty Surf">
> 
>
> 
> 
> 
>
> 
>  FRAMEBORDER=0 SCROLLING=no BORDERCOLOR="#00"
>
SRC="http://pub.libertysurf.fr/html.ng/category=/liberty_photo&site=liberty";
> >
> 
SRC="http://pub.libertysurf.fr/js.ng/Params.richmedia=yes&category=/liberty_
> photo&site=liberty">
> 
> 
HREF="http://pub.libertysurf.fr/click.ng/Params.richmedia=yes&category=/libe
> rty_photo&site=liberty">
> 
SRC="http://pub.libertysurf.fr/image.ng/Params.richmedia=yes&category=/liber
> ty_photo&site=liberty">
> 
> 
>
> 
> 
>  width=720 ALIGN=center>
> 
> 
> 
> 
>
> //end of content
> //content of includes/topnavhaut/topnavhaut.cfm
> etc...
> 
> //end of html page
>
>
> If you have any ideas using any software.
> You maybe have more experienced.
> Thank for any reply
>
> Christophe Glaudel
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Exclude the includes!

[Keith C. Ivey]

On 31 May 2001, at 19:22, Christophe Glaudel wrote:

> The pages of our website are full of includes and I would like to generate
> automaticly the same site to set on the server all the pages files without
> includes in the cfm textfile of the pages

That's the sort of thing that Perl was designed to do easily, 
but it shouldn't be all that much harder to write a CF program 
to do it.

Keith C. Ivey <[EMAIL PROTECTED]>
Webmaster, EEI Communications
66 Canal Center Plaza, Suite 200
Alexandria, VA  22314
Telephone:  703-683-0683
Fax:  703-683-4915
Web Site:  http://www.eeicommunications.com

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

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

Re: Double byte datatype

[CT, Loo]

Hi! Philip,

In that case, is there anyway I can work around?
I have already developed part of the application using CF.

Thanks.

Looct
- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 1:29 AM
Subject: RE: Double byte datatype


> > I am having problem to update/insert record into a database in MS
> > SQL 7.0 using store procedure.
> > Some fields /parameters of the store procedure are of nvarchar,
> > ntext, nchar
> > data type. Is there any CFSQLType or CF functions  that supports
> > these datatype?
> > Is there any work around method?
> >
> > FYI, I am developing on Cold Fusion version 4.5.
> > Your advice are much appreciated.
>
> CF won't support double-byte character types properly until v6
>
> This can cause a problem if you're working on specific languages which use
> UNICODE characters
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Is it possible to nest CFQUERY inside CFLOOP?

[Steve Martin]

CFQUERY is allowed in any type of CFLOOP so the addition of CFOUTPUTs into
the loop is irrelevant.
This thread reminded me of a BUG in CF which I can confirm is still in CF5RC
(haven't checked with the final release yet but I doubt it has changed!)
which concerns the nesting of query driven loops that I thought I'd post as
I doubt everyone is aware of it. Let's say we have 2 query loops (named
query1 and query2 for simplicity), in which for each record in query1,
query2 is iterated over fully. Now, if within the query2 loop you refer to
query1.somefieldname you would expect it to contain the value of the record
that query1 is currently on. But no. It always contains the value of the
FIRST record in query1. The workaround is to initialise a local variable
before entering into the inner loop and from within the loop refer to the
local variable.




#query1.somevarname#








#variables.someLocalVarname#



Steve


> -Original Message-
> From: Bill Davidson [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 18:06
> To: CF-Talk
> Subject: Re: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> You should be able to nest cfquery in a cfloop that is not query based...
> Maybe the actual problem is that cfloop doesn't implicitly force
> a cfoutput,
> so chances are your variables are not getting resolved.  Include a
>  inside the loop.
>
> Here's a code snippet where I am nesting a query inside a loop:
> 
>  
>
>   
>
>SELECT  dbo.Jobs.Jobs_Job_Name, dbo.Employee_Job_Rates.*
>   FROM {oj dbo.Jobs LEFT OUTER JOIN dbo.Employee_Job_Rates ON
> dbo.Jobs.Jobs_ID = dbo.Employee_Job_Rates.Employee_job_rates_job_id }
>   where Employee_job_rates_employee_id = #attributes.user_id#
>   and dbo.Jobs.Jobs_Job_Name = '#jobs_names[loop_index]#'
>
>  
> .
> 
> 
>
> The only other thing I could think of is the list attribute for cfloop.
> Maybe cold fusion internally handles lists as a query.  Maybe just do a
> "from to" loop and only do the query and related code when the index is in
> the list.  That's what I am doing in the previous block of code,
> except with
> arrays.
>
> HTH,
> -Bill
> www.brainbox.tv
>
> - Original Message -
> From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 31, 2001 11:38 AM
> Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> > I just noticed the loop index variable is wrong, I changed it
> to from "i"
> to
> > "region" as it should be and still got the same error message...
> >
> > -Original Message-
> > From: Kevin Gilchrist
> > Sent: Thursday, May 31, 2001 11:32 AM
> > To: CF-Talk (E-mail)
> > Subject: Is it possible to nest CFQUERY inside CFLOOP?
> >
> >
> > I get an error when I try to do this:
> >
> > 
> >  > dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
> > SELECT
> >   sum(severity_minutes) as sev_sum,
> >   max(total_minutes)
> > FROM
> >   history_view,
> >   site_name
> > WHERE
> >   query_id =259 AND
> >   node='RS_CHARMING1' AND
> >   severity=5 AND
> >   customer_name='CHARMING' AND
> >   application='RS_PING' AND
> >   region=#i#
> > 
> > 
> >
> > The error message is:
> >
> > Just in time compilation error
> > A nested CFQUERY tag has been encountered at document position
> (455:2) to
> > (455:130). CFQuery tags cannot be nested inside one another.
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: COOKIE expiration :((

[Michael Lugassy]

So can you please take a look at my problem
and let me know if you can help, ok?

Thanks alot!

Michael.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 7:25 PM
Subject: RE: COOKIE expiration :((


> We did a lot of testing on the setting of cookies using redirects and
found
> that while we were unable to do it with a CFLOCATION in Cold Fusion, it
can
> be done and there is nothing in the RFC to indicate otherwise.  In our
case
> we were able to use an apache module to process the page before cold
fusion
> and if a redirect was needed, the module would do it, if not, it would let
> Cold Fusion take over.  We did find some oddities though with respect to
how
> many years in the future the cookie had to be set for.,.  I think 2039 was
> the latest date we could use and get consistent results.  This is not in
the
> RFC but appeared in practice.
>
> Justin
>
> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 11:13 AM
> To: CF-Talk
> Subject: RE: COOKIE expiration :((
>
> yeah you're right. good grief. i should've checked my own example huh?
> although i really thought (at least some time ago) that you couldn't
access
> the value of a cookie in the same page you set it. although i just tested
my
> own example and i was able to.
>
> that'll save me future embarrassment. ;) or maybe not...
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Double byte datatype

[CT, Loo]

Hi! Bryan,

Are saying that I can execute a store procedure without using CFStoredproc
tag??? Could you please elaborate a bit more?
The application that I am developing is to support both English and Chinese
characters input. Therefore, the data fields in database are defined as
ndatatype.


Oops, another question related to multibyte data input such as chinese
character. How do we control the maximum character to be accepted by the text
input box on a page? The maxlength element of the input tag doesn't seem to
support this. Please correct me if I am wrong.


Thanks.

Regards,
looct
- Original Message -
From: "Bryan Love" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 12:36 AM
Subject: RE: Double byte datatype


> when passing characters to a stored proc (NOT using CFSTOREDPROC) all string
> types such as varchar, char, nvarchar, etc... should be surrounded by single
> quotes and all numeric types should not.
>
> nvarchar should be treated just like varchar, nchar should be treated just
> like char, and so on...
>
>
> Bryan Love ACP
> Internet Application Developer
> [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: CT, Loo [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 8:43 AM
> To: CF-Talk
> Subject: Double byte datatype
>
>
> Dear all,
>
> Please HELP!
>
> I am having problem to update/insert record into a database in MS SQL 7.0
> using
> store procedure.
> Some fields /parameters of the store procedure are of nvarchar, ntext, nchar
> data type. Is there any CFSQLType or CF functions  that supports these
> datatype?
> Is there any work around method?
>
> FYI, I am developing on Cold Fusion version 4.5.
> Your advice are much appreciated.
>
>
> Thank you.
>
> Kind regards,
> looct
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Is it possible to nest CFQUERY inside CFLOOP?

[David E. Crawford]

The cfoutput inside a cfloop is unnecessary to resolve the variables within
the cfquery block.  I use cfquery inside cfloop all the time to do any
number of different things.  There is something else going on with the code
if it is not working.

DC

- Original Message -
From: "Bill Davidson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 13:05
Subject: Re: Is it possible to nest CFQUERY inside CFLOOP?


> You should be able to nest cfquery in a cfloop that is not query based...
> Maybe the actual problem is that cfloop doesn't implicitly force a
cfoutput,
> so chances are your variables are not getting resolved.  Include a
>  inside the loop.
>
> Here's a code snippet where I am nesting a query inside a loop:
> 
>  
>
>   
>
>SELECT  dbo.Jobs.Jobs_Job_Name, dbo.Employee_Job_Rates.*
>   FROM {oj dbo.Jobs LEFT OUTER JOIN dbo.Employee_Job_Rates ON
> dbo.Jobs.Jobs_ID = dbo.Employee_Job_Rates.Employee_job_rates_job_id }
>   where Employee_job_rates_employee_id = #attributes.user_id#
>   and dbo.Jobs.Jobs_Job_Name = '#jobs_names[loop_index]#'
>
>  
> .
> 
> 
>
> The only other thing I could think of is the list attribute for cfloop.
> Maybe cold fusion internally handles lists as a query.  Maybe just do a
> "from to" loop and only do the query and related code when the index is in
> the list.  That's what I am doing in the previous block of code, except
with
> arrays.
>
> HTH,
> -Bill
> www.brainbox.tv
>
> - Original Message -
> From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 31, 2001 11:38 AM
> Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> > I just noticed the loop index variable is wrong, I changed it to from
"i"
> to
> > "region" as it should be and still got the same error message...
> >
> > -Original Message-
> > From: Kevin Gilchrist
> > Sent: Thursday, May 31, 2001 11:32 AM
> > To: CF-Talk (E-mail)
> > Subject: Is it possible to nest CFQUERY inside CFLOOP?
> >
> >
> > I get an error when I try to do this:
> >
> > 
> >  > dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
> > SELECT
> >   sum(severity_minutes) as sev_sum,
> >   max(total_minutes)
> > FROM
> >   history_view,
> >   site_name
> > WHERE
> >   query_id =259 AND
> >   node='RS_CHARMING1' AND
> >   severity=5 AND
> >   customer_name='CHARMING' AND
> >   application='RS_PING' AND
> >   region=#i#
> > 
> > 
> >
> > The error message is:
> >
> > Just in time compilation error
> > A nested CFQUERY tag has been encountered at document position (455:2)
to
> > (455:130). CFQuery tags cannot be nested inside one another.
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Thanks!! [Newbie-CF trying to process Hex numbers :-)]

[Steve Martin]

Although browsers work fine without hashes (pounds for you yanks ),
technically speaking the 'standard' is for hex numbers to be preceeded with
a #.

Steve

> -Original Message-
> From: Gina K. Anderson [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 16:12
> To: CF-Talk
> Subject: RE: Thanks!! [Newbie-CF trying to process Hex numbers :-)]
>
>
> Thanks to everyone for the fix on my hex numbers! Taking out the
> hash worked, as
> well as doubling up. Now I just have to decide which way to go
> with it and adopt
> it as my form. What's the "standard"?
>
> Thanks again!
> Gina
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

An old hand-built-query and CFIndex problem

[Philip Arnold - ASP]

I've previously had a problem with a hand-built query (built while looping
over other queries) which has problems in CFIndex

When I originally built and tested it, I had problems of around 150 smaller
queries - now the client has used the site a lot, there are 284 small
queries which should be added together to make the big query...

The problem is that it stops after 160 queries are added - thus it appears
to "lose" the queries after this point

I'm checking into the number of rows, but it's roughly 20 rows per small
query, thus on average, 3200 rows... and then CFIndex "fails" on the
subsequent rows

Any ideas, anyone?

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

OT: SQL Server 2000

[Art Broussard]

I have a web site that has SQL Server 2000 on it. I have never even thought of 
touching this database until now. I want to go in and create some tables. I was told I 
can install some application on my computer that will allow me to connect to the SQL 
Sever. Then use this program to create the tables I need.

Does anyone know what I'm talking about because I sure don't : ]

TIA

Art

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






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

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

Re: can anyone help?

[Tony Schreiber]

If you're having errors on startup with apache, run a dos window first,
then the apache command line. Then you can see whatever errors occurs
without the window disappearing.

As for the cannot determine local host name:

Set ServerName to 127.0.0.1

ie, ServerName 127.0.0.1

> OK. I have ditched PWS. I have installed Apache and reinstalled ColdFusion
> and copied the DLL file and changed the httpd.conf file in apache.
> 
> I cannot get the web server to start. When I click on start apache I get a
> dos command window that goes so fast I can't even read what it says. I was
> able to make out the following however,
> 
> Apache.exe cannot determine local host name.
> 
> I think the httpd.conf files needs further editing but I'm not confident
> about what to change. I am guessing that the following lines at the end of
> the conf file need to be changed. I want to be able to have
> http://127.0.0.1/
> 
> Sebastian
> 
> --
> 
> # If you want to use name-based virtual hosts you need to define at
> # least one IP address (and port number) for them.
> #
> #NameVirtualHost 12.34.56.78:80
> #NameVirtualHost 12.34.56.78
> #
> # VirtualHost example:
> # Almost any Apache directive may go into a VirtualHost container.
> #
> #
> # ServerAdmin [EMAIL PROTECTED]
> # DocumentRoot /www/docs/host.some_domain.com
> # ServerName host.some_domain.com
> # ErrorLog logs/host.some_domain.com-error_log
> # CustomLog logs/host.some_domain.com-access_log common
> #
> #
> #
> LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll
> 
> --
> 
> on 5/31/01 8:58 AM, Tony Schreiber at [EMAIL PROTECTED] wrote:
> 
> > I know this isn't the answer to your question, but ditch PWS and run
> > Apache for Win32. Works great. ;p I think I'm running 1.3.20 on my
> > development machine. Easy install, SMALL footprint...
> > 
> >> I have win2K professional with personal web server for development.
> >> 
> >> PWS is hanging after any requests, whether with an htm or cfm file request.
> >> When choosing any options in PWS I get the following message:
> >> 
> >> Server is busy
> >> This action cannot be completed because the other program is busy. Choose
> >> 'Switch to' to activate the busy program and correct the problem.
> >> 
> >> There are no other programs running. I have uninstalled and reinstalled PWS
> >> and same problem.
> >> 
> >> Can anyone help?
> >> 
> >> Sebastian 
> >> 
> >> 
> >> 
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Recall: Is it possible to nest CFQUERY inside CFLOOP?

[Kevin Gilchrist]

I take your point, I wanted to get one query for each of the regions, but
then thinking of what you said I realized that I all I had to do was to
group the query by region.  Thanks for the perspective !

I found the source of my compilation error, a unclosed cfquery tag way up
the page.  Thanks to Scott Weikert for that!

-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 12:34 PM
To: CF-Talk
Subject: RE: Recall: Is it possible to nest CFQUERY inside CFLOOP?


yes, but you shouldn't.  There is almost always a better solution that is
being overlooked.


Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]



-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 8:37 AM
To: CF-Talk
Subject: Recall: Is it possible to nest CFQUERY inside CFLOOP?


Kevin Gilchrist would like to recall the message, "Is it possible to nest
CFQUERY inside CFLOOP?".
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: auto-form fill in

[Owens, Howard]

I know next to nothing about ASP and COM.

However, I know I saw on the Microsoft site (or it may have been an ASP
site) one time a COM object that allows you to do just want you're asking.

I think a little research might uncover it.   Sorry I don't have the
specific information, but it was several months ago and I lost the bookmark.

H.



Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956



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

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

Re: Need a CFX_IMAGE Expert!!

[Tony Schreiber]

Does it happen to be a Progressive JPEG? I've had problems with those and
CFX_Image, though it was resize that crapped out...

> For you CFX_IMAGE experts:
> 
> I have a weird jpg (530Kb, 1152x864) that ACTION=copy destroys it
> and ACTION=resize (with the same OUTPUT= as with copy) works just fine!
> 
> let me show you the code:
> 
> ruin the jpg:
> 
> OUTPUT="#dir_s#\groups\#qqu.qGR#\#qph.newfile#.jpg">
> 
> works fine &-)
> 
> file="#tempfile#" OUTPUT="#dir_s#\groups\#qqu.qGR#\#qph.newfile#.jpg">
> 
> If someone is willing to help, I can attach the jpg to him.
> 
> 
> Thanks,
> 
> Michael Lugassy
> IT/WEB Specialist
> Interactive Music Ltd.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Windows 2000 NLB

[robrusher]

NLB is free and worth every penny.
In your configuration, all traffic is still coming into the first machine
and then half of that is sent to the other. So one has twice as many
connections as the second. Where is the real benefit?

You are much better off using ClusterCATS with or without a hardware load
balancer.
Set it up with DNS round robin if you can't get a load balancer. There is a
bunch of KB articles on this subject at the Allaire site. KB# 18931 is a
good start.

Regards,

Rob Rusher

Spectra Architect, Certified ColdFusion Instructor + Developer, Certified
Java Programmer

(303) 885-7044 Cell
(970) 472-1775  Fax
[EMAIL PROTECTED]

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


plan, build and integrate interactive applications and e-business services
to enhance knowledge sharing, e-commerce and business communications
initiatives


-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 12:41 PM
To: CF-Talk
Subject: Windows 2000 NLB


I am trying to set up a windows 2000 network load balancing cluster.  I have
two servers that I am using.  At this point in time I have configured
everything on the two servers.  If I get it going it starts to work and then
I pull the plug on the #1 priority and #2 takes over.  But as soon as I plug
# 1 back in the hole things bombIts like they are not talking
Also in both the event viewer's Its says the "priority number" has joined as
default with host(s) "priority number"..blah blah.  In both event
viewers it doesn't see the other one and they both are acting like defaults.

I have looked and looked at the settings and everythings seems okay.I
just put in a new extreme switch and configured the vlan for multicasting.
I am thinking that maybe it has something to do with the vlan not letting
them talk?

Any idea's would be great!!

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

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

RE: Select Boxes <> limiting drop down :: Please Look

[Patricia Lee]

It would be much better to say

WHERE EmployeeID NOT IN (#QuotedValueList(Get_Golf.EmployeeName)#)

|-Original Message-
|From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, May 31, 2001 12:48 PM
|To: CF-Talk
|Subject: RE: Select Boxes <> limiting drop down :: Please Look
|
|
|thanks Alistair.
|but i just did this, it may be way wrong.
|it works but if you know it is bad, please let me know
|
|
|
|SELECT DISTINCT EmployeeName 
|FROM tbl_Golf 
|GROUP BY EmployeeName
|
|
|
|SELECT FirstName, LastName, Email, EmployeeID
|FROM tbl_Employee
|WHERE EmployeeID NOT IN (
|#Get_Golf.EmployeeName#,
|   )
|ORDER BY LastName 
|DESC; 
|
|
|
|SELECTED>#rs_Employ
|ees.LastName#
|#rs_Employees.FirstName#
|
|
|
|FwW man what a day :]
|thanks again
|
|-paul
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Is this an Access limitation ?

[Philip Arnold - ASP]

> The code below throws an error whenever I try to run it... What
> am I doing wrong ?
>
>  Thanks in Advance...
>
> 
>  SELECT partnumber
>  FROM products
>  WHERE manufacturer_id = 4
>  
>
> 
>  SELECT item_id
>  FROM inv_mast
>  WHERE  partnumber NOT
> IN(#QuotedValueList(getproducts.partnumber)#) AND manufacturer_id = 4
>   

Firstly, what datatype is PartNumber in Access?

If it's a number, then use ValueList(PartNumber) rather than
QuotedValueList(PartNumber)

If it's not, put the SQL to the display before you run the SQL to make sure
it "should" run - try it in Access if needs be

Also, check the getProducts.RecordCount - if it's 0 then the SQL will break
no matter what database engine you throw it at...

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

The new ACFUG mailing lists are now (*GULP*) online!

[Adam Phillip Churvis]

Well, it's been a long and difficult migration, but it looks like we
finally got the new ACFUG mailing lists up and running.

 ***  VERY IMPORTANT!  ***

-- There are completely new mailing list addresses you must now use:
  [EMAIL PROTECTED] (the regular discussion list)
  [EMAIL PROTECTED]  (to receive meeting announcements and such)
  [EMAIL PROTECTED]   (to receive job listings)

-- The new website is not up yet; it will launch at the June 6th meeting.
   the list message footers tell you that you can manage you lists
   subscriptions there, so ignore that until June 6th.  If you need me to
   change or add your email address before June 6th then please email
   [EMAIL PROTECTED] and it will be handled manually for you.

-- I'm completely new to managing mailing lists, so please go easy on me if
   things mess up on the lists or the website during the month of June.
   Please address all issues to [EMAIL PROTECTED] and I will handle them
   as quickly and as professionally as I can.

-- If you have any advice, then please send it to [EMAIL PROTECTED]  I
   could really use your input, and will certainly appreciate it.

Thanks for being so patient, folks.  Take care!

Respectfully,

Adam Phillip Churvis
Productivity Enhancement, Inc.

Want truly advanced ColdFusion 5 training?  Register for the Advanced
Bootcamp for ColdFusion 5, Database, and Javascript at
http://www.ColdFusionTraining.com!

http://www.CommerceBlocks.com

E-mail:  [EMAIL PROTECTED]
Phone:   770-446-8866


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

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

RE: Correctly using CFOUTPUT

[Philip Arnold - ASP]

> Hi, I've always been curious about this. What is the correct way? Does it
> matter?

> Is there an unwritten rule; if there are more than 4 (or ?) vars in a page
> Listing 1 is a good way to do it else Listing 2 is recommended?
> I'm assuming when using  Listing 1 would
> always be applicable.

OK, there are 2 ways to look at this;
1) What's easier for you (and your team) to read and update
2) What's faster on then server when it's PCode

In answer to this, Listing 1 is always easier to read, but is slower on the
server
"Why?" you ask (sounds of "Why?" from all over the world)...

Here's how the CF Server looks at a template (if you don't have CFSetting
EnableCFOutputOnly="Yes" on);
It sends everything straight to the browser that's not a CF tag outside of a
CFOutput without even thinking, once it reaches a CFOutput it has to scan
through the code to find if anything requires any conversion from
function/variable/field contents into displayable values and then converts
those...

When you don't have any functions/variables/fields in the code, you're
effectively making CF work for nothing

Remeber that a file being larger in size (before PCode) means nothing to how
fast it might run on the server - it's the actual work that the server is
doing that's more important

If you wanted the best performance from a CFOutput query="" tag, then you
should use CFLoop query="" and only CFOutput the fields

Hope this helps explain why and why not to use CFOutput on everything

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

HTTP/1.0 404 Object Not Found

[Julia Phu]

Hi, guru,

Please help on how to resolve the HTTP/1.0 404 Object Not Found error. It is
CF 4.5.

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

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

Re: Is this an Access limitation ?

[Avi Flax]

At a glance, those queries look fine. What is the error message?

Avi

At 11:40 AM 5/31/2001 -0500, Tracy Bost wrote:
>The code below throws an error whenever I try to run it... What am I doing 
>wrong ?
>
>  Thanks in Advance...
>
>
>  SELECT partnumber
>  FROM products
>  WHERE manufacturer_id = 4
>  
>
>
>  SELECT item_id
>  FROM inv_mast
>  WHERE  partnumber NOT IN(#QuotedValueList(getproducts.partnumber)#) AND 
> manufacturer_id = 4
>   


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

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

RE: Is this an Access limitation ?

[David Shadovitz]

Does it throw any particular error that perhaps you'd like to share?

On Thursday, May 31, 2001 9:41 AM, Tracy Bost [SMTP:[EMAIL PROTECTED]] wrote:
> The code below throws an error whenever I try to run it... What am I doing
> wrong ?
>   
>  Thanks in Advance...
> 
> 
>  SELECT partnumber
>  FROM products
>  WHERE manufacturer_id = 4
>  
> 
> 
>  SELECT item_id
>  FROM inv_mast
>  WHERE  partnumber NOT IN(#QuotedValueList(getproducts.partnumber)#) AND
>  manufacturer_id = 4
>   
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Is this an Access limitation ?

[David E. Crawford]

What kind of error?  That might help us solve the problem.

DC

- Original Message -
From: "Tracy Bost" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 12:40
Subject: Is this an Access limitation ?


> The code below throws an error whenever I try to run it... What am I doing
wrong ?
>
>  Thanks in Advance...
>
> 
>  SELECT partnumber
>  FROM products
>  WHERE manufacturer_id = 4
>  
>
> 
>  SELECT item_id
>  FROM inv_mast
>  WHERE  partnumber NOT IN(#QuotedValueList(getproducts.partnumber)#) AND
manufacturer_id = 4
>   
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: COOKIE expiration :(( RECURRING

[Philip Arnold - ASP]

> I'm getting really frustrated from this CFCOOKIE thing.
> Apparently, after I assign the cookie with Expires="Never" the
> cookie is deleted and terminated every time the user closes the browser.
> I need it to last longer, prefarbly forever.
>
> no cflocation in page, tried to link one process page to another.
> didn't work!

Can you try something for me...

Make a page with 2 lines in it;

Cookie placed

Another page with the following code;

Cookie Exists

Cookie does not exist



Now, run the first, then the second - then close the browser and run the
second - if the results are the same then you've not got a problem

If the second one NEVER returns a "Cookie Exists" then your cookie settings
are screwed in your browser

There is another possible issue;
Is your Temporary Internet Files location on your machine and not on the
network?
If it's local, check you've got enough hard disk space - clear down your
cache, try killing some of the "rubbish" cookies to ensure IE's not getting
confused, etc.

I hope some of this helps...

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

Re: Is this an Access limitation ?

[Pooh Bear]

what does the error say? hehe that's the most important part :P


>From: "Tracy Bost" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Is this an Access limitation ?
>Date: Thu, 31 May 2001 11:40:46 -0500
>
>The code below throws an error whenever I try to run it... What am I doing 
>wrong ?
>
>  Thanks in Advance...
>
>
>  SELECT partnumber
>  FROM products
>  WHERE manufacturer_id = 4
>  
>
>
>  SELECT item_id
>  FROM inv_mast
>  WHERE  partnumber NOT IN(#QuotedValueList(getproducts.partnumber)#) AND 
>manufacturer_id = 4
>   
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: IIS or Apache? (WAS RE: can anyone help?)

[Dave Watts]

> Well now, since you'all have brought it up, and I never 
> really considered it, (big IIS fan)which is better on 
> a Win2k (advanced server)?
> 
> IIS or Apache?
> 
> Pros - Cons?
> Good for both Development and Production?
> 
> Would consider shelving IIS for Apache if there was good 
> reason to

>From a functional perspective, both will work fine on Win2K, especially for
development. I think that IIS will perform better in production than Apache
on Windows, based on my experiences. This shouldn't be a surprise, since
Microsoft has built IIS specifically to run very well on Windows.

>From a security perspective, Apache is easier to secure than IIS, although
both can be secured adequately. Apache doesn't come with all kinds of extra
stuff like IIS does, so you don't have to remove and disable as much. There
are some people who think that IIS can't be secured
(http://www.securityportal.com/articles/iis20010521.html), but it can be
with a bit of diligence. The only "fatal flaw" with IIS, in my opinion, is
that the service must run as SYSTEM so that it can impersonate other users -
if I understand correctly, this is required to support the integration of
IIS authentication with NT authentication. So, if the IIS service gets
compromised through a buffer overflow, any code executed as a result will
run as SYSTEM. Actually, in Win2K, you might be able to change the IIS
services so that they run as individual users. I haven't tried this yet,
myself.

If you're interested in taking advantage of Windows-specific functionality,
IIS will allow you to do that more easily and more often than Apache,
generally.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

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

RE: CFFLUSH alternative in CF4.5

[Philip Arnold - ASP]

> I would really like to try out the new CFFLUSH component
> on CF5, but we're not yet ready for the upgrade.
>
> Can someone suggest a better CFFLUSH alternative in CF4.5
> other then opening 3 invisible frames (each one runs 1 template)
> to achive this page-load-balancing and incremental output?

CF4.x WON'T flush - it's no the way it's built...

Pre-CF5, CF builds the whole page in the server's memory and then passes
that back to the browser - there's no real flush technology

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

RE: Double byte datatype

[Philip Arnold - ASP]

> I am having problem to update/insert record into a database in MS
> SQL 7.0 using store procedure.
> Some fields /parameters of the store procedure are of nvarchar,
> ntext, nchar
> data type. Is there any CFSQLType or CF functions  that supports
> these datatype?
> Is there any work around method?
>
> FYI, I am developing on Cold Fusion version 4.5.
> Your advice are much appreciated.

CF won't support double-byte character types properly until v6

This can cause a problem if you're working on specific languages which use
UNICODE characters

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

RE: Thanks!! [Newbie-CF trying to process Hex numbers :-)]

[Tony Schreiber]

> Thanks to everyone for the fix on my hex numbers! Taking out the hash
> worked, as well as doubling up. Now I just have to decide which way to
> go with it and adopt it as my form. What's the "standard"?

For me, since the "#FF" values are valid HTML syntax versus "FF",
I prefer to double-pound, but I'm wierd that way. That means that I have
to be note whether my colors are in a CFOUTPUT or not, because "##FF"
results in the wrong color when not in a CFOUTPUT... ;p So it's infinitely
easier just to leave the # off...

Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.linklabexchange.com _Miata Link ECU Data Exchange


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

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

Exclude the includes!

[Christophe Glaudel]

Maybe you can answer a problem I encounter now.

The pages of our website are full of includes and I would like to generate
automaticly the same site to set on the server all the pages files without
includes in the cfm textfile of the pages
for example

a page like that :








could be transformed into a file like that to optimise the cold fusion
server work :

//content of includes/toppub/toppub.cfm
LIBERTY SURF


var agent = navigator.userAgent.toLowerCase();
var ver = parseInt(navigator.appVersion); if ((agent.indexOf("mozilla")
!= -1) && (ver >= 4) && (navigator.appName.indexOf("Netscape") != -1))
document.write(''); else document.write(''); function MM_reloadPage(init) { if
(init==true) with (navigator) {if
((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight;
onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW ||
innerHeight!=document.MM_pgH) location.reload();}
MM_reloadPage(true);






http://www.libertysurf.fr/img/ang_noir.gif"; WIDTH=15 HEIGHT=15>

http://www.libertysurf.fr";>http://www.libertysurf.fr/img/logolshome.gif"; WIDTH=127 HEIGHT=37
BORDER=0 ALT="Liberty Surf">







http://pub.libertysurf.fr/html.ng/category=/liberty_photo&site=liberty";
>
http://pub.libertysurf.fr/js.ng/Params.richmedia=yes&category=/liberty_
photo&site=liberty">

http://pub.libertysurf.fr/click.ng/Params.richmedia=yes&category=/libe
rty_photo&site=liberty">
http://pub.libertysurf.fr/image.ng/Params.richmedia=yes&category=/liber
ty_photo&site=liberty">











//end of content
//content of includes/topnavhaut/topnavhaut.cfm
etc...

//end of html page


If you have any ideas using any software.
You maybe have more experienced.
Thank for any reply

Christophe Glaudel


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

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

RE: COOKIE expiration :((

[247601589883116300006]

We did a lot of testing on the setting of cookies using redirects and found
that while we were unable to do it with a CFLOCATION in Cold Fusion, it can
be done and there is nothing in the RFC to indicate otherwise.  In our case
we were able to use an apache module to process the page before cold fusion
and if a redirect was needed, the module would do it, if not, it would let
Cold Fusion take over.  We did find some oddities though with respect to how
many years in the future the cookie had to be set for.,.  I think 2039 was
the latest date we could use and get consistent results.  This is not in the
RFC but appeared in practice.

Justin

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 11:13 AM
To: CF-Talk
Subject: RE: COOKIE expiration :((

yeah you're right. good grief. i should've checked my own example huh?
although i really thought (at least some time ago) that you couldn't access
the value of a cookie in the same page you set it. although i just tested my
own example and i was able to.

that'll save me future embarrassment. ;) or maybe not...

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

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

RE: Is it possible to nest CFQUERY inside CFLOOP?

[Steve Martin]

You have an unterminated CFQUERY in your page though you have only pasted a
snippet of the code into your email. Take a look above your code and try to
find the offending tag.

> -Original Message-
> From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 16:38
> To: CF-Talk
> Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> I just noticed the loop index variable is wrong, I changed it to
> from "i" to
> "region" as it should be and still got the same error message...
>
> -Original Message-
> From: Kevin Gilchrist
> Sent: Thursday, May 31, 2001 11:32 AM
> To: CF-Talk (E-mail)
> Subject: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> I get an error when I try to do this:
>
> 
>dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
>   SELECT
> sum(severity_minutes) as sev_sum,
> max(total_minutes)
>   FROM
> history_view,
> site_name
>   WHERE
> query_id =259 AND
> node='RS_CHARMING1' AND
> severity=5 AND
> customer_name='CHARMING' AND
> application='RS_PING' AND
> region=#i#
>   
> 
>
> The error message is:
>
> Just in time compilation error
> A nested CFQUERY tag has been encountered at document position (455:2) to
> (455:130). CFQuery tags cannot be nested inside one another.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: can anyone help?

[sebastian palmigiani]

on 5/31/01 9:40 AM, Arden Weiss at [EMAIL PROTECTED] wrote:

> See Apache installation instructions paper "ColdFusion and Apache install
> tips and tricks" by Mark Mathis on Annapolis Cold Fusion Users Group web
> site (2/22/01 meeting) if you decide to go that route. It will help...
> www.ancfug.com/meetings

Arden, thanks. 

Those are the instructions I was looking for.

Sebastian


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

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

RE: Consensus CFLOCK

[Dave Watts]

> What is a standard timeout that is used with CFLOCK? 30 seconds?

No, there's no standard timeout. Different things will take different
lengths of time.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

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

Re: Is it possible to nest CFQUERY inside CFLOOP?

[Bill Davidson]

You should be able to nest cfquery in a cfloop that is not query based...
Maybe the actual problem is that cfloop doesn't implicitly force a cfoutput,
so chances are your variables are not getting resolved.  Include a
 inside the loop.

Here's a code snippet where I am nesting a query inside a loop:

 

  

   SELECT  dbo.Jobs.Jobs_Job_Name, dbo.Employee_Job_Rates.*
  FROM {oj dbo.Jobs LEFT OUTER JOIN dbo.Employee_Job_Rates ON
dbo.Jobs.Jobs_ID = dbo.Employee_Job_Rates.Employee_job_rates_job_id }
  where Employee_job_rates_employee_id = #attributes.user_id#
  and dbo.Jobs.Jobs_Job_Name = '#jobs_names[loop_index]#'

 
.



The only other thing I could think of is the list attribute for cfloop.
Maybe cold fusion internally handles lists as a query.  Maybe just do a
"from to" loop and only do the query and related code when the index is in
the list.  That's what I am doing in the previous block of code, except with
arrays.

HTH,
-Bill
www.brainbox.tv

- Original Message -
From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 11:38 AM
Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?


> I just noticed the loop index variable is wrong, I changed it to from "i"
to
> "region" as it should be and still got the same error message...
>
> -Original Message-
> From: Kevin Gilchrist
> Sent: Thursday, May 31, 2001 11:32 AM
> To: CF-Talk (E-mail)
> Subject: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> I get an error when I try to do this:
>
> 
>  dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
> SELECT
>   sum(severity_minutes) as sev_sum,
>   max(total_minutes)
> FROM
>   history_view,
>   site_name
> WHERE
>   query_id =259 AND
>   node='RS_CHARMING1' AND
>   severity=5 AND
>   customer_name='CHARMING' AND
>   application='RS_PING' AND
>   region=#i#
> 
> 
>
> The error message is:
>
> Just in time compilation error
> A nested CFQUERY tag has been encountered at document position (455:2) to
> (455:130). CFQuery tags cannot be nested inside one another.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Select Boxes <> limiting drop down :: Please Look

[Jann VanOver]

Your query and select look a bit screwy.  In your query you are selecting
all rows where the name is not equal to the ID.  Is that really what you
wanted?  Go back to your original queries -- you were trying to select all
where #get_golf.employeeName# <> .employeeID  Did you really mean to compare
name to ID?  And why the "." ??  IF #get_golf.employeeName# is REALLY an ID,
remove the period.  THEN your select statement:



SELECTED>#rs_Employees.LastName#
#rs_Employees.FirstName#



Which one are you trying to select?  This will result in ALL being selected
because #rs_Employees.EmployeeID# is ALWAYS equal to
#rs_Employees.EmployeeID#


Should be more like:


SELECTED>#LastName#
#FirstName#






SELECT DISTINCT EmployeeID, FirstName, LastName, Email, EmployeeName 
FROM tbl_Employee, GOLF
WHERE EmployeeName <> EmployeeID
ORDER BY LastName 
DESC; 




SELECTED>#rs_Employees.LastName#
#rs_Employees.FirstName#



But then i get all sorts of duplicates.

-paul

"Whatever you can do, or dream you can, begin it. 
Boldness has genius, power, and magic in it." - Goethe

web developer, nbbj
work:   [EMAIL PROTECTED]
614 241-3534
fax:614 485-5534

home:   [EMAIL PROTECTED]
614 449-1681

> icq:  47658358


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:13 AM
To: CF-Talk
Subject: Select Boxes <> limiting drop down :: Brian Lock


Ok i know this is simple but i have forgot something
i want to limit the returned names on a select box to 
only those who have not signed up!



SELECT GolfID, EmployeeName 
FROM tbl_Golf 




SELECT EmployeeID, FirstName, LastName, Email
FROM tbl_Employee
WHERE #Get_Golf.EmployeeName# <> .EmployeeID
ORDER BY LastName 
DESC; 






SELECTED>#rs_Employees.LastName#
#rs_Employees.FirstName#



Thank You!

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

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

RE: cffile DOES NOT WORK!!!

[Garza, Jeff]

Make sure that the account that Cold Fusion runs under has read/write/change
access to that directory.  Typically CF runs under the system account,
unless you've changed it.

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

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



-Original Message-
From: S R [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 30, 2001 3:43 PM
To: CF-Talk
Subject: cffile DOES NOT WORK!!!


I am having a terrible day, I am still trying to solve this email attachment

problem, I figured out that you have to use cffile to upload it to the 
server and then it will magically work, well I can't even get that to work. 
This is the error I am getting:

Error processing CFFILE

The directory specified in the DESTINATION attribute of the CFFILE tag 
(c:\Inetpub\wwwroot\hnc\) is not valid. The directory either does not exist 
or is not accessible by the Cold Fusion service.


And this directory does indeed exists, it actually contains my entire 
website. I'm really stuck.

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

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

Re: can anyone help?

[sebastian palmigiani]

OK. I have ditched PWS. I have installed Apache and reinstalled ColdFusion
and copied the DLL file and changed the httpd.conf file in apache.

I cannot get the web server to start. When I click on start apache I get a
dos command window that goes so fast I can't even read what it says. I was
able to make out the following however,

Apache.exe cannot determine local host name.

I think the httpd.conf files needs further editing but I'm not confident
about what to change. I am guessing that the following lines at the end of
the conf file need to be changed. I want to be able to have
http://127.0.0.1/

Sebastian

--

# If you want to use name-based virtual hosts you need to define at
# least one IP address (and port number) for them.
#
#NameVirtualHost 12.34.56.78:80
#NameVirtualHost 12.34.56.78
#
# VirtualHost example:
# Almost any Apache directive may go into a VirtualHost container.
#
#
# ServerAdmin [EMAIL PROTECTED]
# DocumentRoot /www/docs/host.some_domain.com
# ServerName host.some_domain.com
# ErrorLog logs/host.some_domain.com-error_log
# CustomLog logs/host.some_domain.com-access_log common
#
#
#
LoadModule coldfusion_module modules/ApacheModuleColdFusion.dll

--

on 5/31/01 8:58 AM, Tony Schreiber at [EMAIL PROTECTED] wrote:

> I know this isn't the answer to your question, but ditch PWS and run
> Apache for Win32. Works great. ;p I think I'm running 1.3.20 on my
> development machine. Easy install, SMALL footprint...
> 
>> I have win2K professional with personal web server for development.
>> 
>> PWS is hanging after any requests, whether with an htm or cfm file request.
>> When choosing any options in PWS I get the following message:
>> 
>> Server is busy
>> This action cannot be completed because the other program is busy. Choose
>> 'Switch to' to activate the busy program and correct the problem.
>> 
>> There are no other programs running. I have uninstalled and reinstalled PWS
>> and same problem.
>> 
>> Can anyone help?
>> 
>> Sebastian 
>> 
>> 
>> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: How do you to set allow zero length in access 2000 for memo f ield using sql

[Garza, Jeff]

Here are the online docs from Access2000 regarding Alter Table Statements...
There doesn't seem to be a way to alter the table and set the columnt to
accept zero length strings.  The issue at hand is that by default a text or
memo column is created with Allow Null = yes and Allow Zero Length = False.
Kinda foobar if you ask me.  I'll see what else I can dig up, but trial and
error might be your best bet.  Start trying some different syntaxes, and if
all else fails, you might want to try CDO and see what's available there.

HTH,

Jeff Garza


Syntax
ALTER TABLE table {ADD {COLUMN field type[(size)] [NOT NULL] [CONSTRAINT
index] |
ALTER COLUMN field type[(size)] |
CONSTRAINT multifieldindex} |
DROP {COLUMN field I CONSTRAINT indexname} }

The ALTER TABLE statement has these parts:

Part Description 
table The name of the table to be altered. 
field The name of the field to be added to or deleted from table. Or, the
name of the field to be altered in table. 
type The data type of field. 
size The field size in characters (Text and Binary fields only). 
index The index for field. For more information on how to construct this
index see CONSTRAINT Clause.  
multifieldindex The definition of a multiple-field index to be added to
table. For more information on how to construct this index see CONSTRAINT
Clause. 
indexname The name of the multiple-field index to be removed. 


Remarks
Using the ALTER TABLE statement you can alter an existing table in several
ways. You can: 

Use ADD COLUMN to add a new field to the table. You specify the field name,
data type, and (for Text and Binary fields) an optional size. For example,
the following statement adds a 25-character Text field called Notes to the
Employees table: 
ALTER TABLE Employees ADD COLUMN Notes TEXT(25) 


You can also define an index on that field. For more information on
single-field indexes see CONSTRAINT Clause. 

If you specify NOT NULL for a field then new records are required to have
valid data in that field. 

Use ALTER COLUMN to change the data type of an existing field. You specify
the field name, the new data type, and an optional size for Text and Binary
fields. For example, the following statement changes the data type of a
field in the Employees table called ZipCode (originally defined as Integer)
to a 10-character Text field: 
ALTER TABLE Employees ALTER COLUMN ZipCode TEXT(10) 


Use ADD CONSTRAINT to add a multiple-field index. For more information on
multiple-field indexes see CONSTRAINT Clause. 
Use DROP COLUMN to delete a field. You specify only the name of the field. 
Use DROP CONSTRAINT to delete a multiple-field index. You specify only the
index name following the CONSTRAINT reserved word. 



Notes 

You cannot add or delete more than one field or index at a time. 
You can use the CREATE INDEX statement to add a single- or multiple-field
index to a table, and you can use ALTER TABLE or the DROP statement to
delete an index created with ALTER TABLE or CREATE INDEX. 
You can use NOT NULL on a single field or within a named CONSTRAINT clause
that applies to either a single field or to a multiple-field named
CONSTRAINT. However, you can apply the NOT NULL restriction only once to a
field. Attempting to apply this restriction more than once restuls in a
run-time error. 



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

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



-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 30, 2001 12:00 PM
To: CF-Talk
Subject: RE: How do you to set allow zero length in access 2000 for memo
field using sql


Is this kinda like?:

"How do you carry a table in one hand, bounce a ball off your nose, rattle a
chain on your ear, push your favorite pita neighbor into the street in front
of a racing car, and eat a pb&j sandwich.. all at the same time?"

Lee

-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 9:31 AM
To: CF-Talk
Subject: How do you to set allow zero length in access 2000 for memo
field using sql


How do you to set allow zero length in access 2000 for memo field using sql
statement when adding column using alter table ?
Thanks
Mike
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Unstable MySQL on Windows 2000

[robrusher]

My original thought was it was low on system resources. It was correct.

I am getting much better results now that I moved to a higher powered
machine with more of everything.

I haven't tried on NT4.

Regards,
Rob

-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 1:07 PM
To: CF-Talk
Subject: RE: Unstable MySQL on Windows 2000


Have you found it to be stable on NT4 ???

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, May 30, 2001 11:34 AM
To: CF-Talk
Subject:Unstable MySQL on Windows 2000

Has anyone successfully gotten MySQL, ColdFusion and W2K to work together?

I am getting flaky at best connections to MySQL using the MyODBC driver. I
works for a little bit then I get nothing but datasource errors. Like:
ODBC Error Code = ()


Unknown connection error for the data source, 'INSPIR.'


Data Source = "INSPIR"


The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (1:1) to (1:66) in the template file
C:\INETPUB\WWWROOT\INSPIR\COMPANY\QRY\QRY_LIST.CFM.


Date/Time: 05/30/01 09:30:31
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Remote Address: 127.0.0.1
HTTP Referer: http://127.0.0.1/inspir/company/snpr/index.cfm



Regards,

Rob Rusher

Spectra Architect, Certified ColdFusion Instructor + Developer, Certified
Java Programmer

(303) 885-7044 Cell
(970) 472-1775  Fax
[EMAIL PROTECTED]

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


plan, build and integrate interactive applications and e-business services
to enhance knowledge sharing, e-commerce and business communications
initiatives
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Thanks!! [Newbie-CF trying to process Hex numbers :-)]

[Bill Davidson]

I don't think there is a standard, but I would just leave out the #'s, so
the code will work inside a cfoutput block or not.  Double pounds (or hashes
for you Brit's ;) ) in HTML will freak out your browser.

-Bill
www.brainbox.tv

- Original Message -
From: "Gina K. Anderson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 11:12 AM
Subject: RE: Thanks!! [Newbie-CF trying to process Hex numbers :-)]


> Thanks to everyone for the fix on my hex numbers! Taking out the hash
worked, as
> well as doubling up. Now I just have to decide which way to go with it and
adopt
> it as my form. What's the "standard"?
>
> Thanks again!
> Gina
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Is it possible to nest CFQUERY inside CFLOOP?

[Dave f]

Don't know what your problem is, but it is definitely OK to have cfquery
inside cfloop. Do you perchance have improperly closed prior cfquery?? (My
usual trick is to dup the  and forget to put the "/" in ):)


- Original Message -
From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 11:38 AM
Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?


> I just noticed the loop index variable is wrong, I changed it to from "i"
to
> "region" as it should be and still got the same error message...
>
> -Original Message-
> From: Kevin Gilchrist
> Sent: Thursday, May 31, 2001 11:32 AM
> To: CF-Talk (E-mail)
> Subject: Is it possible to nest CFQUERY inside CFLOOP?
>
>
> I get an error when I try to do this:
>
> 
>  dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
> SELECT
>   sum(severity_minutes) as sev_sum,
>   max(total_minutes)
> FROM
>   history_view,
>   site_name
> WHERE
>   query_id =259 AND
>   node='RS_CHARMING1' AND
>   severity=5 AND
>   customer_name='CHARMING' AND
>   application='RS_PING' AND
>   region=#i#
> 
> 
>
> The error message is:
>
> Just in time compilation error
> A nested CFQUERY tag has been encountered at document position (455:2) to
> (455:130). CFQuery tags cannot be nested inside one another.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cffile DOES NOT WORK!!!

[S R]

I figured it out. Thanks for your help. After one finally gets some sleep, 
you start to see what went wrong.

Sal


>From: "Ryan Sabir" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: cffile DOES NOT WORK!!!
>Date: Thu, 31 May 2001 12:41:38 +1000
>
>
>This should be straightforward as I've done similar things before... are 
>you
>able to post your code to the list, both the Upload page and the 
>page... just stick it in the body of the email and let us look over it.
>
>
>
>-Original Message-
>From: S R [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, 31 May 2001 8:43 AM
>To: CF-Talk
>Subject: cffile DOES NOT WORK!!!
>
>
>I am having a terrible day, I am still trying to solve this email 
>attachment
>problem, I figured out that you have to use cffile to upload it to the
>server and then it will magically work, well I can't even get that to work.
>This is the error I am getting:
>
>Error processing CFFILE
>
>The directory specified in the DESTINATION attribute of the CFFILE tag
>(c:\Inetpub\wwwroot\hnc\) is not valid. The directory either does not exist
>or is not accessible by the Cold Fusion service.
>
>
>And this directory does indeed exists, it actually contains my entire
>website. I'm really stuck.
>
>SR
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Select Boxes <> limiting drop down :: Please Look

[Paul Ihrig]

thanks Alistair.
but i just did this, it may be way wrong.
it works but if you know it is bad, please let me know



SELECT DISTINCT EmployeeName 
FROM tbl_Golf 
GROUP BY EmployeeName



SELECT FirstName, LastName, Email, EmployeeID
FROM tbl_Employee
WHERE EmployeeID NOT IN (
#Get_Golf.EmployeeName#,
)
ORDER BY LastName 
DESC; 



SELECTED>#rs_Employees.LastName#
#rs_Employees.FirstName#



FwW man what a day :]
thanks again

-paul

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

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