-Original Message-
From: Chris Luksha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 3:39 PM
To: CF-Talk
Subject: The darndest time w/ Cookies. Actually form checking.
I am having the hardest time setting a cookie. I think it is actually in
testing for the form
This is the perfect example of what is wrong with this community.
Gloom and doom. You read it on the internet, it must be true.
Let's complain about how everything is terrible, but do nothing about
it.
Let's not pick ourselves up, let's just whine until we all die.
We all know how reputable
Actually, the SetClientCookies attribute defaults to Yes, so you don'
t need
it in there unless you aren't using client cookies. The only attribu
tes
needed for session management are 'name' and 'sessionmanagement'. Op
tional
attributes like applicationtimeout and sessiontimeout can be used as
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 12:38 PM
To: CF-Talk
Subject: 4 kb cookie limit...
So if you get 4kb per cookie you set, how much data is that? I've never
really learned the whole conversion process, if anyone
-Original Message-
From: Samuel Farmer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 4:21 PM
To: CF-Talk
Subject: SQLServer Stored Proc Permissions
Hi,
I am trying to use a system stored procedure in SQLServer7 that is in the
master database called sp_fkeys. My
-Original Message-
From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 10:21 AM
To: CF-Talk
Subject: OnRequestEnd.cfm not running
OK. This is weird.
I thought OnRequestEnd runs every time a page is called, as long
as there is
a matching
Aren't you feeding Ben when you buy his books?
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 5:54 PM
To: CF-Talk
Subject: RE: OnRequestEnd.cfm not running
Ouch... biting the hand that feeds you g
-Original
One trick I've used with dynamic pages using include files for header
and
footer is to set a pagetitle variable in the main file for each page,
which
I call the content page. The included header will be the page that h
as the
html title tags, and it will use the pagetitle variable to output
Neil:
From the CF Documentation:
To set up the missing template Handler:
In the ColdFusion Administrator, click Settings.
The system displays the Server Settings page.
Specify the absolute path the server uses to find the missing templat
e
handler
Except for the cfif line, Billy is right. The cfif needs to conform
to the
same order of operations he mentioned:
cfif decisionID EQ thisDecisionIDselected/cfif
All that is needed is decisionID, since it is used implicitly within
the
current query.
If you wanted to keep the query name for
I'd like to add to this that another reason for not storing client va
riables
in the registry is for the original reason of this topic: Clustering
and
Load Balancing. You run right into the same problem that is caused b
y using
session variables -- use sticky sessions for pseudo-load balancing
Remember, though, that you can catch cffile errors with cftry/cfcatch
, and
inform the user that the operation failed and that they should wait a
nd try
again. You can also inform system administrators via email if a file
operation fails. There are many ways you can use this functionality
to
Actually, session variables can be set to expire at different time
intervals. There is a method that has been posted before which sets
session cookies, which will effectively end session on browser clo
se.
However, this is not actually true, since the session variables are s
till
held in memory
Mike,
Remove the cfloop lines, they are not needed:
CFLOOP query=Org_Article
/CFLOOP
You are already looping through the query... The outer loop is your g
rouped
cfoutput. The inner cfoutput works as the inner loop, which is accomp
lishing
the output of data contained within the grouped
Neil,
Also remember that Client variables cannot hold complex data objects
such as
structures or arrays. You have to convert them to xml first before s
toring
them in a database. You can use the cfwddx tag to accomplish this.
One reason to use session variables is speed. Under heavy load,
This problem occurs when you have two variables, one after the other,
without anything in between but whitespace. To solve this problem wi
thout
resorting to putting extra characters in, you can force a carriage re
turn
and line feed after the problem areas:
!--- Example ---
cfmail...
Let him learn the hard way. Ask him if he wants sites designed to hi
s spec.
Then design all the sites with fixed-width tables with regards to his
monitor resolution, which is probably 1280x1024 or, if you need binoc
ulars,
1600x1200 +. Then when people complain, blame it on your boss and te
ll
Tony,
I don't know what OS/platform you are using, but CFEXECUTE should do what
you want.
Recently I was working on this exact problem. The application is a content
management system for an advertising agency. When Jobs are updated,
sometimes HUGE files need to be moved, hundreds of megabytes
Zac,
You might be right, but I must admit I don't know that many developers
personally. The ones I do know, however, don't use Fusebox.
I think what would be helpful for people is a study that not only shows the
PROS and CONS of Fusebox, but an actual application that is written with
Fusebox
I've screamed about this OLE DB vs. ODBC for almost a year, and no one
ever gives me any concrete answers or benchmarks! There was an article
in CF Developer's Journal a year or so back about how to set up OLE
DB... The author couldn't disclose the speed differences because they
were done
Hi Dave,
How was DevCon? I keep forgetting to ask if you could email me the
following program that you always refer to for capturing http headers,
etc:
Stretch:
http://www.kestral.com.au/devtools/stretch/
The d/l link has been broken for some time, but the docs are still
there.
There is
Whoops, sorry about the previous email from me, under this thread; it
wasn't supposed to go to the list.
Apologies!
Andy
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 11:37 AM
To: CF-Talk
Subject: RE: CFHTTP Replacement
Anyone
William,
Try:
Joe Celko's SQL for Smarties: Advanced SQL Programming
Transact-SQL Programming (O'Reilly)
The Guru's Guide to Transact-SQL
-Andy
-Original Message-
From: William H. Bowen [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 05, 2001 3:13 PM
To: CF-Talk
Subject: OT: SQL
I'd be interested to see the performance of a web server running on the
MAC platform versus Windows 2000 Server or any *nix based server.
Unless of course you were only talking about desktop platform stability.
You were, right?
-Andy
-Original Message-
From: Joshua Miller
This solution won't work. What is happening is that you are referring
to only the first row in your inner cfloop, in regards to querya, which
is why you are only getting the output of the first value in the first
row. Reversing the process will simply reverse the output you are
getting, not
Off the top of my head, no, but what you can do is, if you have access
to Enterprise Manager, create this exact table and then generate an SQL
script, which will give you exactly what you need to duplicate the table
in SQL Server.
-Andy
-Original Message-
From: Michael Lugassy
Stuart:
Perhaps you can post the code. I tested the example code I posted a few
minutes ago in Netscape 6 and it worked fine.
Andy
-Original Message-
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 03, 2001 6:28 PM
To: CF-Talk
Subject: RE: Netscape 6 and
As long as the type attribute is equal to submit the form will submit
fine. If you name your submit button, you will just have a formfield in
the action page called whatever you named it on the form page along with
it's value equal to whatever you set it to on the form page.
-Original
Shawn,
I had this problem too. What Dave said is right -- it IS a permissions
problem. He led me to this solution a couple of months ago:
I have a PDFS directory that is not in the web root for a certain web
application. I serve the PDF files to the user via cfcontent ... The
directory
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 3:06 PM
To: CF-Talk
Subject: Executing Dynamic Code
Hello World,
I have a template which allows a user to build a criteria based selection.
Somthing like where x=10 and/or z gte
I might be wrong, but I don't think you can issue multiple SQL commands to Access in
this way.
-Andy
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 9:25 AM
To: CF-Talk
Subject: RE: Hacking CF Web Sites and Applications
SELECT
What person in their right mind would click a link they got from an email telling them
their server is compromised? Remember, I said right mind. Think of all the
malicious attacks that could be propagated in this way.
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL
-Original Message-
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 4:34 PM
To: CF-Talk
Subject: CFsetting through a loop - brainfart
Hi - this has got to be an easy fix. I've got a dynamic form sending a
dynamic amount of fields to a Query. The
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 10:41 AM
To: CF-Talk
Subject: I'm an idiot...
Say, hypothetically, I had lost the password to the Cold Fusion Administrator for
cf4.5 on my win2k machine. Anybody have any ideas where,
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:36 PM
To: CF-Talk
Subject: Re: Locked Database
I'd advise against this usage. Performing invalid queries isn't the
preferred method. Using the CFusion_DBConnections_Flush() function
I'm wondering why no one is wanting this to go over to cf-community...
To the guys who think this is cool:
Maybe if you left your basement once in a while you would actually meet a woman.
To the women:
I don't care what anyone looks like, male, female, chimpanzee, whatever... As long as
One way I've tricked Verity into reading a title tag in an app where the headers,
footers, and other parts of the page are dynamic, is to comment out the title. So
just like you did, but:
CF_customtag ...
!--- titleTitleToAppearAtTopOfBrowser/title ---
Body contents go here.
/CF_customtag
I have yet to see any performance gain for ACCESS or SQL SERVER using OLE DB over
ODBC. I remember reading an article on setting up OLE DB (in the CF Journal) a ways
back. The author said he couldn't post his numbers because my MBA prevents me from
reporting those statistics because I didn't
I'm sort of torn here, on what to think. On one hand, knowing all of the information
would be helpful, but on the other, I think Macromedia is waiting to release more
information, hoping that most places will patch the hole so exploits will be fewer. I
am all for it's too bad if the network
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 08, 2001 2:40 PM
To: CF-Talk
Subject: Is it really POST?
How can I check if the .cfm file was submitted using POST and not GET?
(I'm trying to prevent, as possible, people to submit the params using
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 12:25 PM
To: CF-Talk
Subject: RE: Is it really POST?
Now, if you run the first page and submit it, whether you
keep the FORM method as GET or change it to POST, the
IsStruct() function will
What could be happening is that you are setting an application variable somewhere
other than your application.cfm file(s) and trying to read it in another template. If
the application times out, then that application variable wouldn't exist on the
execution of the said template, but all the
-Original Message-
From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 3:59 PM
To: CF-Talk
Subject: IsNumeric weirdness - can someone explain this?
Here's the test code:
-
cfset myvariable = 3D1
cfoutput
If I understand the question correctly, all you need to do is use METHOD=GET in you
form... tag, which will place all form fields in the query string automatically when
the page gets submitted.
-Andy
-Original Message-
From: Dave f [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 9:38 AM
To: CF-Talk
Subject: RE: COOKIE expiration :((
post the code.
otherwise - and you may already know this:
remember...if you load a page with CFCOOKIE (or write a cookie
My take on all of this certification business is this:
Fine if you are an ACP, better if you are and MCSE because many companies that use MS
solutions like to require it of their consultants.
As far as CF certification goes, I am not certified yet, but I know too many people
who are certified
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 8:30 AM
To: CF-Talk
Subject: RE: CFFLUSH QUESTION
CFFLUSH doesn't know the difference between TABLE tags or any other HTML
tag. It just flushes out content. It's really up to the
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 12:01 PM
To: CF-Talk
Subject: request scope confusion
I am trying to understand the request scope.
What is the difference between putting
cfset DSN = 'foo'
vs.
-Original Message-
From: Janssen Dolores Y (Contractor)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 12:28 PM
To: CF-Talk
Subject: RE: CF 5 is out..
are there plans for a new version of studio or a new sp to 4.5? i
didn't see
anything in the cf5 announcement on
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:34 PM
To: CF-Talk
Subject: Using 'Between' sql for Times/Dates
Hi,
I have a list of dates and times, in a field called logDate, which are
constantly updated. I need to pull the last 2
Looking over the templates brought me to the same conclusion as that Deb came to (of
course it was easier for me since I looked at that part first ;)
The app works fine when adding/updating records that have NO values for Cost, Price
and Weight, however when CF checks the RANGE on these fields
Like Howie said before, the ColdFusion Application Server service must be logged on as
a user with network rights, not the LocalSystem account. From your posts I surmise
the drive you are trying to write to is a mapped network drive...
Is that correct?
If so, you will need to edit the CFAS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 12:30 PM
To: CF-Talk
Subject: Re: CFFILE
CFFILE doesn't take unc paths from what I remember. You need to map a
drive and give the user id running the cf application server
Well, I don't know how you missed this huge html table in the studio docs ;)
(from cf studio 4.5.2 docs):
Note Although the File prefix is still supported, it has been deprecated in favor
of the CFFILE prefix.
The following file upload status parameters are
Chad,
Use the DISTINCT keyword:
SELECT DISTINCT
COLOR
FROM
Yourtable
..
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 4:16 PM
To: CF-Talk
Subject: SQL query help
I have a database similar to this:
SKU NAME
There is a good parent/child explanation and recursive custom tag here:
http://www.defusion.com/articles/index.cfm?ArticleID=63
This is a very good article and helped me get my head around the whole thing for a big
project I was working on at the time.
-Original Message-
From: Jeff
If you look at the documentation for CFCOOKIE, you will see it has a expires attribute:
(From the absolutely [?] wonderful cfstudio docs)
CFCOOKIE NAME=cookie_name
VALUE=text
EXPIRES=period
SECURE=Yes or No
PATH=url
DOMAIN=.domain
EXPIRES
Optional. Schedules the expiration
The hand with the lightning bolt...
Gone...
What to do now? It'll cost me THOUSANDS upon THOUSANDS to get skin grafts to remove
all the old ColdFusion logo tattoos on my body.
How could Macromedia do this? Time to reevaluate the product, I suppose...
-Original Message-
From:
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 6:28 PM
To: CF-Talk
Subject: connections
hey
does anyone know how to set up the database connection on the webserver if
your database is not located on your webserver?? i can do this
Message-
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 7:02 PM
To: CF-Talk
Subject: RE: connections
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 6:28 PM
To: CF-Talk
Subject: connections
Well if you look at the rest of Macromedia's product logos, the new ColdFusion 5 one
is design-consistent with them. Also, when Allaire bought JRun they did the same
thing -- created a new logo that was consistent with there current product logos. I
don't really care what the new logo looks
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 11:13 AM
To: CF-Talk
Subject: Finding the last item in a loop
IS it possible to find the last item in a loop?
Right now I have this:
cfloop query=qry_show_event_sponsors
My opinion is, the uprising worked for the Hosting Edition elimination (maybe...), but
now everyone wants to re-design the logo and tell Macromedia how to package the
products. How about we have a thorough inspection of the restrooms at the corporate
headquarters; they might not have the
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 3:31 PM
To: CF-Talk
Subject: ValueList() in CF 4.5
The ValueList function in CF 4.5.1 inserts a space between values
using the
default delimiter.
The table column has
I remember running into this when I first starting developing with ColdFusion. I
remember mentioning it to someone in the field and I got a kind of CF automatically
escapes single quotes in an SQL query, so you shouldn't have to type answer. Of
course that is true, but I was using Evaluate()
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 11:22 AM
To: CF-Talk
Subject: 100s of FTP Accounts
We're about to offer all of our users and client complete ftp
access to 10mb of storage.
Every user will have his own directory
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 1:20 PM
To: CF-Talk
Subject: RE: CFTRY / CFCATCH questions
that's incorrect, actually. it will catch them in the order
defined. so if there is an ALL first, there will never be
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 1:33 PM
To: CF-Talk
Subject: RE: Duplicate answers (was: Character code for a TAB)
I JUST LOVE IT WHEN 1203483409875 PEOPLE answer the same answer
to a pretty easy question.
I
I'm glad this came up. I was about to purchase PC Anywhere (new version, whatever
it's up to) for a client so I can manage her SQL and ColdFusion servers. They're
running Windows NT Servers, 4.0 SP5. We currently have a VPN setup, which works
great, except I need to be able to manage the
This looks great. Thanks for the link and the info. I just downloaded it and will
play with it asap (on the development server, of course!)
Have a good weekend everyone!
Andy
-Original Message-
From: John Lucas [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 21, 2001 8:44 PM
-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 21, 2001 3:30 PM
To: CF-Talk
Subject: OT: Win2K TCP/IP on road
When I am on the road I need to configure TCP/IP to use DHCP but
when I am home I need to use static ip.
Is there any way to keep
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 9:12 AM
To: CF-Talk
Subject: CFExcute doesn't run EXEs
I'm having problems with CFEXCUTE.
apperntly I can run stricly bat files that contains
commands like: move, copy and such..
I'm not sure what you mean...
Do you mean send a processed cfm page (now html) as an attachment?
- Andy
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 10:35 AM
To: CF-Talk
Subject: Putting Post CF Processed file into
to it
- Original Message -
From: "Andrew Tyrone" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, April 18, 2001 11:01 AM
Subject: RE: Putting Post CF Processed file into MAILPARAM
I'm not sure what you mean...
Do you mean send a processe
-Original Message-
From: Curtis C. Layton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 11:10 AM
To: CF-Talk
Subject: Setting up Access Datasources
Here's an interesting question:
We recently set up a server cluster that is configured in this fashion:
Web1/Web2
-Original Message-
From: Moneymaker, Jon S (WPNSTA Yorktown)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 12:08 PM
To: CF-Talk
Subject: Cookies and their expiration
Still pretty new to all this, but am being asked some questions
by superiors
about CF's
-Original Message-
From: Saidi; Marwan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 1:46 PM
To: CF-Talk
Subject: CFFILE problems - Can't delete?
Hello all,
I am running CF Pro 4.5.1 SP 2 on RedHat 6.2. Using CFFILE, I can upload
files with no problems. However,
-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 1:24 PM
To: CF-Talk
Subject: CFLOCATION: The document has moved HERE??
My app has a CFLOCATION that works on most browsers... however on
a MAC running IE5 instead of being
You can use datasources on another machines. I'm pretty sure you can use the UNC path
in CF Adiministrator to specify a datasource somewhere on the network, on a network
drive available the machine that is running ColdFusion. If you go into ODBC Data
Sources in the control panel you can
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 4:27 PM
To: CF-Talk
Subject: Re: URGENT - CFFTP
Robert
I know your problem well. Make sure you specify the full path to
the folder
that you are uploading to
IE
Actually, that's not right. The cachedwithin attribute of cfquery will do what you
are saying.
cachedafter caches a query AFTER the date/time you specify, like so:
cfquery datasource="MyDSN" name="MyQuery" cachedafter="#CreateDateTime(2001, 04,
16, 21, 35, 0)#"
SQL...
/cfquery
-Original Message-
From: Terry Bader [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:32 PM
To: CF-Talk
Subject: LOCKING
ok, question about locking
let's say I have code like this:
CFLOCK SCOPE="SESSION" TYPE="READONLY" TIMEOUT="10"
CFIF
Patty:
When you go into the relationships window in Access 2000, you can add your tables
(which I gather you've done) to the diagram and then specify which fields match up,
whether to enforce referential integrity between them, and what join type they use.
Basically once you relate a primary
Aimee:
You really shouldn't pass attributes for a cf tag in a form, url, or in any other way
that would allow someone to tamper with them.
Are you trying to set the NAMECONFLICT tag for the cffile UPLOAD action? If so, why
not set it on the called page, where it is secure?
If this isn't
-Original Message-
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 3:26 PM
To: CF-Talk
Subject: Could Not Delete From Specified Tables
Ok, you all helped me tremendously this morning, so I'm hoping someone can
point me in the right direction on
Try Protus:
http://www.protus.com/index.cfm
A company I used to work for uses them with great success, apparently.
(Andy they use ColdFusion...)
- Andy
-Original Message-
From: Chang Liu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 4:08 PM
To: CF-Talk
Subject: e fax
Hi there.
I'll point you to a page on the Allaire site. It was posted in another cf-talk
message today, I think:
http://www.allaire.com/Handlers/index.cfm?ID=1463Method=Full
This will also show you how to make sure concurrency issues don't affect the value
that is returned.
- Andy
Hiya Gina!
What you want to do is use the Evaluate() function.
So to normally just output the value of ACCT, you would just do:
cfoutput#ACCT#/cfoutput
However, in your case you only get the actual name that holds the value returned from
your code, which is ACCT.
So to evaluate it, you
By the way, you can just use
#Evaluate(collist)# and get rid of the extra quotes and pound signs.
- Andy
-Original Message-
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 5:50 PM
To: CF-Talk
Subject: RE: Getting the value of a variable, once removed
In my opinion...
Unless you have a huge amount of html files and are running other web sites on the
same server, this won't be a big performance concern.
Also, remember, that if you have more than 1 virtual site on the server, you can
configure the applicable site to process htm and html
-Original Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 2:42 PM
To: CF-Talk
Subject: How to uncache a querry?
I make extensive use of cached queries on 1 of my websites, that uses
read-only data that gets updated once a week..
The format:
FROM="John Smith [EMAIL PROTECTED]"
works fine with most email servers, as far as I know.
I remember that in (I THINK) ColdFusion versions previous to 4.5, this never worked
for me. I could've SWORN it was the mail server, but manually doing it this way
worked. I don't know if
But Phil...
In my experience, ColdFusion escapes the apostrophes automatically. Also, the one
time I had a problem with apostrophes, was when I was using Evaluate() on some form
fields (can't remember the reason -- it was quite a while ago!) which made ColdFusion
NOT escape single quotes
Jay,
Try out the following:
!--- Outer loop. Each iteration is one of the six select boxes, from 1 to 6 ---
cfloop from="1" to="6" index="CurrentSelect"
cfset RodeoID = Form.RodeoID
cfset EventID = Form.EventID
cfset Place = CurrentSelect
cfset TimeTaken =
I apologize -- one line is off.
In the VALUES part of your SQL, I inadvertently put #ThisID# in twice. The second one
should be changed back to #Place#. Sorry!
-Andy
-Original Message-
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 5:16 PM
To: CF
George,
Do you use SMTP Authentication -- user names and passwords? If so, my guess is that
CF isn't running under a user account with access to send mail. If CF is running
under the local system account, you need to create a user account for it and give that
user account permissions to
Michel,
The sites could be down for numerous reasons, and none may even be cf-related.
To decide if you should upgrade to the enterprise edition of ColdFusion, check the
comparison chart and see if any of the features enterprise offers are ones you need:
Thomas,
Try this:
cfquery name="bulletins"
datasource="News"
SELECT *
FROM
Articles
WHERE
approved #Now()# AND startdate #Now()#
AND expirydate #Now()#
/cfquery
What you had was: where approved and startdate ... You have to test both for
Joby,
You can use the cftransaction around both queries. Also, I assume you are setting
session.pro_session_id before this code. Don't forget you should be locking read and
write access to session variables with cflock.
-Andy
-Original Message-
From: Joby Bednar [mailto:[EMAIL
Willy,
I believe to use groupcasesensitive you have to use the group attribute in your
cfoutput tag, as well. If you don't specify a group, specifying HOW to group won't
make a difference.
-Andy
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Monday, February
201 - 300 of 309 matches
Mail list logo