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
First pick up a good html book. You need to know the basics of
html...Osborne's HTML The Complete Reference is the best imo.
To answer your questions though.
1. There is no correct way. Do what works with the design. I generally
totally rebuild the html mockup from the designer, after the client
Here is one option
SELECT (CAST(MONTH(DateField) AS VARCHAR(2)) + '/' + CAST(DAY(DateField) AS
VARCHAR(2)) + '/' + CAST(YEAR(DateField) AS VARCHAR(4))) AS NewDate
FROM AnyTable
You must use the CAST function to switch numbers to strings and the month,
day, year select the respective date parts
For SESSION.Variable
cfset tmp=#StructDelete(SESSION,Variable,TRUE)#
Joshua Miller
Web Development
Eagle Technologies Group
Technology Solutions for the Next Generation
www.eagletgi.com
[EMAIL PROTECTED]
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
We discussed this on the list no more than a few weeks ago. While
intuitively (at least to me) it would seem that a CFOUTPUT loop would
execute faster than a CFLOOP, that simply is not the case. I think we
pretty much reached the concensus that while CFLOOP is faster, the
difference was so
I've lost track of the original question but you can set a cookie using
CFCOOKIE then redirect if you use this instead of CFLOCATION.
CFHEADER name=Refresh value=0; URL=gotopage.cfm
Duncan Hays
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31,
I have this bit of code...
cfset
date1=dateformat(createdate(year(now()),month(now()),daysinmonth(month(n
ow(,mm/dd/)
cfset
date2=dateformat(createdate(year(now()),month(now()),1),mm/dd/)
and I'm getting this error on date1
In the function CreateDate(year, month, day) the
Doesn't June only have 30 days!
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 14:11
To: CF-Talk
Subject: What's with this?
I have this bit of code...
cfset
Never is too strong a word. If you have a CFOUTPUT at the top of the page and
another CFOUTPUT at the bottom of the page, it's not better to enclose the entire page
in one CFOUTPUT tag as you're suggesting.
Extraneous code, no. Extra code, yes - if it improves performance, reliability, or
Whoa... Definite bug there! I was able to replicate it without much problem
at all :)
Last check of the calendar verified that yes, there are only 30 days in
June.
Norman
-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 9:14
Yep - your problem is that you need to pass in a date object into the
function daysinmonth. So you need:
cfset
date1=dateformat(createdate(year(now()),month(now()),daysinmonth(now()),mm/
dd/)
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001
CORRECTION!
Check out the documentation for DaysInMonth()...
You have to supply a DATE object, not a numeric month
I fell for that one too!
Norman
-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 9:14 AM
To: CF-Talk
No bug. daysInMonth() takes a full date as a parameter -- not the month. If you
say daysInMonth(now()), it will work as expected.
Craig
-Original Message-
From: Norman Elton [SMTP:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 9:33 AM
To: CF-Talk
Subject: RE: What's with
Because June only has 30 days???
Tim Claremont
-Original Message-
From: Steven Dworman [mailto:[EMAIL
Steven,
The function daysinmonth takes a full date and not just the month,so really
all you need is : daysinmonth(now())
regards
Stephen
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 14:11
To: CF-Talk
Subject: What's with this?
I have
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:
CFQUERY name=getWaitingStudent datasource=SMC
SELECT ClassSchedID, InputDate, WaitList, RegistrationID
FROM ClassRegistration
WHERE InputDate (SELECT
To anyone that cares I have found that using a Layer 3 switch requires some extra
fiddling with nlb. I have substitued the switch for a 100m hub and and runs perfectly.
Here is a question though. Regardless of if you use nlb, cc or a hardware solution.
What do you guys do if the server that
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
Store session info in a database instead of in CF memory.
Robert
- Original Message -
From: Michael Ross [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 9:57 AM
Subject: RE: Windows 2000 NLB
To anyone that cares I have found that using a Layer 3 switch
Check to make sure that the GetWaitingStudent query is actually returning a
row.
DC
- Original Message -
From: David Clay [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 09:58
Subject: CFSET
Can anyone tell me why the #ClassID# in the UPDATE Query is
Sebastion,
The code below should do it. Note that this method (both your version and
mine) will choke if the keyword list contains pan or coldfusion,fusion
because of interference between the replacement of a string and the added
span text, or between the replacement of one string and the
client variables can be stored in a database, not sessions.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 7:12 AM
To: CF-Talk
Subject: Re: Windows 2000 NLB
Store session info in a database instead of in CF memory.
Robert
-
Does the first query return any results? i noticed that you dont have a =,
IN, !=, OR having
before the subquery in getWaitingStudent, im no sql expert but does this
still work like this?
KOla
-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 14:58
To:
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 09:10
To: CF-Talk
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
want to make sure i worded my previous response more correctly;
session variables are stored in memory only. client variables however, can
be stored in a database (or the registry) as specified in the CF admin.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:
Ok, I tried plugging the content into a test update statement that I knew was working.
Bombed out. Same error. There's either something in my text string that's causing a
failure, or access/ODBC won't accept that big of a string. Any thoughts on making it
do this?
Willy
[EMAIL
what's the data type of the field objectcontent and exactly how long is your
string?
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 15:40
To: CF-Talk
Subject: Re: Crazy Dynamic Update/FORM Structure question
Ok, I tried plugging the content into a test
I'm trying to provide functionality to a select group of people on a
specific subnet. What I'd like to do is something along the lines of..
cfif #cgi.remote_addr# is '192.168.5.0'
Allow action
/cfif
The thing being they use dhcp to allocate IP's and the address could
actually be any of
hi hope someone here can give me a hand with this:(sorry for the cross post)
I have a table called categories, the key bieng an int, with a field for the
category name.
Another table called adverts, an advert has a category feild which is a
foreign key which links to the category table.
I
Anyone,
I have come up with a slight issue in the past, and it is this:
If you are using client variables for a secure section of a website and they
have a timeout (say 10 minutes). The users closes the browser thinking that
they have logged out (when they haven't) and the cookies (let's assume
Heidi,
If you understand a little about what FireWorks (and other
graphics/HTML) programs are doing to create the tables and graphics, it
might make more sense of what you have, what you need to do, and how you
might approach it in another way.
Normally, we like to use a controlled environment
I would presume this in on an Intranet because on an Internet site you will
not see that range.
Thanks,
Robert
- Original Message -
From: Marcus [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 10:55 AM
Subject: Brain isn't working yet...
I'm trying to
You will probably need to do a test and then set the result to a variable
and then do a CFIF based on that variable result.
Robert
- Original Message -
From: Marcus [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 10:55 AM
Subject: Brain isn't working yet...
You're most of the way there...
cfif #left(cgi.remote_addr,8)# is '192.168.'
or
cfif #left(cgi.remote_addr,10)# is '192.168.5.'
-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 7:56 AM
To: CF-Talk
Subject: Brain isn't working yet...
I'm
cfif #cgi.remote_addr# contains '192.168.5'
Will do the trick, but you really need to use REfind and anchor the string
to the start.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Paul
Put this in your application.cfm:
cfif IsDefined(Cookie.CFID) AND IsDefined(Cookie.CFTOKEN)
cfset cfid_local = Cookie.CFID
cfset cftoken_local = Cookie.CFTOKEN
cfcookie name=CFID value=#cfid_local#
cfcookie name=CFTOKEN value=#cftoken_local#
/cfif
This
how about a regular expression?
cfif REFind(192[.]168[.]5[.][12]?[0-9]?[0-9], cgi.remote_addr)
/cfif
or something like that!
Paul
-Original Message-
From: Marcus [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: 01 June 2001 16:14
Subject: Brain isn't working yet...
I'm trying to
Good questions. The data type of the field is (MS Access) Memo. The string is about
1400 characters. But I've been doodling around this morning with it, and I've gotten
it to take strings up to 2500 characters. The problem seems to be that I'm passing
some sort of carriage return that's
use cfif cgi.remote_addr contains '192.168.5'
or use cfif reFind(cgi.remote_addr,'192.168.5.[0-9]+')
the contains version should work fine, but the reFind has less potential
for error
-chris
On Fri, 1 Jun 2001, Marcus wrote:
I'm trying to provide functionality to a select group of people on
Thanks for all the info. I think I am going to try using Access first since
I have that installed allready. If that doesn't work then I going for the
SQL 2000 client tools.
Art
Never put your finger where you wouldn't put your nose.
~~
Structure
Thanks for the help... I was playing around with it after I sent the email and found
that I needed to pass a complete date to daysinmonth().
Steven D Dworman
---
Cold Fusion Programmer
Web Applications Developer
ComSpec International
phone: 248.647.8841
cell:
cfif find(192.168.5., cgi.remote_addr)
Allow action
/cfif
-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 9:56 AM
To: CF-Talk
Subject: Brain isn't working yet...
I'm trying to provide functionality to a select group of people on a
cfif mid(cgi.remote_addr,1,10) is '192.168.5.'
Allow action
/cfif
-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 9:56 AM
To: CF-Talk
Subject: Brain isn't working yet...
I'm trying to provide functionality to a select group of people on a
the problme is in the where clause. the condition on the right side of the
OR statemnet will always test true.. or .. i should say is potentially
testing true. which is giving you your cartisian product.
i suggest you use either a left join or an inner join (depending on wether
you want nulls)
Hello all:
A user has reported that when he logs in, he is immediately redirected to
a session failed page. I am using an authorization routine that sets a user access
level (like admin or user). The authorization/authentication routine has been tested
on multiple browser/machine
How do I test to see how many dimensions a given array posseses? This method
gives me all the values of a 2 dimensional array, but I need to know if it's
a 2D array BEFORE I try this ... unless someone knows a craftier way... ???
cfset a=1
cfset aD=1
cfloop condition=a LTE ArrayLen(array)
I am trying to update multiple rows at once and I don't seem to get any errors but
when I try to get the info I just updated nothing is there. Can someone tell me if
this Query should work?
CFQUERY NAME=engineeringinfo DATASOURCE=Biosreference DBTYPE=ODBC
Update BiosPart
SET VGA_Rom = 'PCI'
If you set the cookie with no expire time, the cookie is destroyed when the
browser closes, in both IE and NN. Now, the security for the app should be
that both session on server and cookie on client must be present for there
to be a logged in condition. If either is missing, a login must
Wait, I think I got it. There's a apostrophe (A.K.A. single quote) in my text string.
That would do it, eh? What's the function I use to fix that? PreserveSingleQuote?
Willy
[EMAIL PROTECTED] 6/1/01 8:51:54 AM
what's the data type of the field objectcontent and exactly how long is your
*This message was transferred with a trial version of CommuniGate(tm) Pro*
You could parse the last octet of the IP address off and just use the first
three to match the entire subnet. That is if their subnet is 255.255.255.0 .
I didn't test this code but it would probaly go something like
Take cgi.remote_addr as list with delimiter as '.', then it is easy.
Chris
[EMAIL PROTECTED]
- Original Message -
From: Paul Johnston [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 4:09 PM
Subject: Re: Brain isn't working yet...
how about a regular
cfif #cgi.remote_addr# CONTAINS '192.168.5'
Allow action
/cfif
-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 10:56 AM
To: CF-Talk
Subject: Brain isn't working yet...
I'm trying to provide functionality to a select group of people on a
All you appear to be doing is reading and writing the cookies.
Exactly how does this stop the user closing the browser and not having the
cookie's destroyed?
When the user re-starts the browser and goes to that page, the cookies still
exist (as far as I can tell).
Paul
-Original
You can use this code to examine your form field string. Change myString to
your variable.
table
trthIndex/ththCharacter/ththASCII/th/tr
cfloop from=1 to=#Len(myString)# index=iChar
cfoutputtrtd#iChar#/tdtd#Mid(myString,iChar,1)#/tdtd#Asc(
Mid(myString,iChar,1))#/td/tr/cfoutput
Hi
I have an app which lets users upload a file, is there anyway to stop a
malicious user
uploading say a 2gig file before it gets to my server? Also if i wanted the
upload to have a maximum time out how would i do it? Would I need to use
cflock?
Thanks in advance
Kola
I tried refind, and it didn't want to work at all. Contains works great!
Marcus
cfif #cgi.remote_addr# contains '192.168.5'
Will do the trick, but you really need to use REfind and anchor the string
to the start.
~~
Structure your ColdFusion
Or use something like DreamWeaver which intergrates well with (for instance)
FireWorks (and I assume Freehand) and really doesnt care.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
I haven't had any problems myself, but I did see the
performance degrade while Apache was under a load. I
have read that this is because Apache 1.3 for NT is not
multithreaded. Apparently this is fixed in Apache 2.0. I'm
going to download the alpha version and test it out. I just
need
or the numerous ways you could do it:
cfif ListFirst(cgi.remote_addr, .) eq 192
AND ListGetAt(cgi.remote_addr, 2, .) eq 168
AND ListGetAt(cgi.remote_addr, 2, .) eq 5
/cfif
or
cfif Left(cgi.remote_addr, 3) eq 192
AND Mid(cgi.remote_addr, 4, 3) eq 168
AND Mid(cgi.remote_addr, 9,
What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want to be
able to update or refresh the queries at will.
Here is my current process:
1. Break the
I've posted a modified version of the .fla file for the calender up on the
Forum - works very well now in non-popup mode.
Also has some usability tweaks that could be backported into the normal .fla
if your feeling brave.
~~
Structure your
Change your AND(s) to OR(s).
Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com: (703) 805-1095
DSN: (703) 655-1095
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 11:25 AM
See below:
On Thu, 31 May 2001 16:12:03 -0600, David Clay [EMAIL PROTECTED]
wrote:
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:
CFQUERY name=getWaitingStudent datasource=SMC
SELECT ClassSchedID,
See below:
On Thu, 31 May 2001 16:12:03 -0600, David Clay [EMAIL PROTECTED]
wrote:
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:
CFQUERY name=getWaitingStudent datasource=SMC
SELECT ClassSchedID,
I have a template which executes a cfhttp post to a cgi script that then post to
another cgi script. I want to get the results from this 2nd cgi script.
When I read the cfhttp.filecontent I am seeing the results of the first cgi script.
Does anyone know of a way where I can use a cfhttp
(Please pardon the doubled post, newsgroup users)
What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want to be
able to update or refresh the queries at
I have come across an interesting occurrence where CF mysteriously started
to fail on a Stored procedure. The storedProc was working fine for a while
and now it doesn't. The storedProc is executed in a cfquery (there seems to
be an issue with the cfstoredproc tag and paraming timestamps),
Shouldn't it be
WHERE
Part_ID = 751
OR
PART_ID = 752
(Im assuming that each part can only have one Part_id)
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 11:25 AM
To: CF-Talk
Subject: Updating multiple rows!
I am trying to update
Just to combine my last post and Dave's -
Dave is right - you need to set the cookie with no expire time. The only
problem is that if you switch on Clientmanagement and leave the rest to CF
it writes the cookies CFID and CFTOKEN to the users browser with an expiry
time equal to that of the CF
Lets say I have 12 records but I want to display only 3 so I use maxrows 3
in the cfoutput. Is there a way to get 3 random records from the query?
Like order by random or something?
Rich
~~
Structure your ColdFusion code with Fusebox. Get the
Logic error -- do you have any records where the part_id is 751 AND 752?
Change Part_ID = 751
AND
PART_ID = 752
to Part_ID IN (751,752...)
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 8:25 AM
To: CF-Talk
Subject: Updating multiple rows!
Hey Ben,
If you're updating one field in multiple rows with the same constant value,
then you'll want to use OR in your WHERE statement, right?
If you're updating multiple rows with values from a form, then you'll have
to have unique form field names for each row and loop through the query on
You need to use OR instead of AND...you are asking it to find a row where
Part_ID is both 751 AND 752...
You could also say WHERE part_ID IN (751,752)
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
One man's magic is another man's engineering. ---Lazarus
IsArray(variable) tells you if a given variable is an array...
Since a 2D array is simply an array of an array, then IsArray(variable[1])
will tell you if the given variable has a second dimension (or at least one
in the first element).
Likewise, IsArray(variable[1][1]) would tell you if it was
Hi paul
since the expires attribute of cfcookie is left out, it defaults to never,
this means that as soon as the browser is closed and the cookies will be
deleted
HTH
Mark
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 16:38
To: CF-Talk
Subject:
Paul,
When a cookie is created with no expiration it is destroyed when the browser is
closed. This is referred to as a 'session cookie'.
-- Tim Bahlke
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 11:38 AM
To: CF-Talk
Subject: Re:
For 4.0 use Name=session.sessionId for session variables and
Name=Application.ApplicationName for application variables. This works in both 4.0
4.5, though you can't use Full Checking in 4.5 because it's not compatible with the
Name scope (you can still use Auto Read Locking if you want to).
Ben
your code there is trying to update a product which has a productId of 751
AND 752
it won't find it
HTH
Mark
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 16:25
To: CF-Talk
Subject: Updating multiple rows!
I am trying to update multiple rows
Hello everybody:
I have been going through the archives but with no success
I need to query a LDAP directory for a user and show their picture. I
execute the LDAP query but I am not able to show the picture information
(JPEG file).
cfldap action=QUERY name=Test attributes=uid,
I do not understand why you get trailing back slash when using
GetDirectoryFromPath with Apache web server
cfoutput#GetDirectoryFromPath(CGI.CF_TEMPLATE_Path)#/cfoutput
In other words I get
c:/program files/apache group/apache/htdocs/members/om/archive/adu/\
Why is there a trailing back
I've used two methods.
1) Use a variable in the CreateTimeSpan which holds the number of minutes or hours
that you want the cache to last. To force the query to execute, change this variable
to 0, hit the page, and then restore the variable back to the proper value.
2) Add the following code
Use the IN keyword.
Update BiosPart
SET VGA_Rom = 'PCI'
WHERE Part_ID IN (751,752)
I cant remember off the top of my head if there needs to be single quotes
around the values in the parentheses.
jon
- Original Message -
From: Ben Densmore [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Just run your query again with cachedwithin=#CreateTimeSpan(0,0,0,0)#
I take the lazy way out.
When building an app I set a request.QueryCacheTime value to whatever
desired and then simply reference that in my queries where appropriate. When
data is updated I reset request.QueryCacheTime to
Jamie,
You could set a variable for the cachetime in Application.cfm or on the page
itself use that in query. Then use a flag variable passed along URL to
indicate whether cached query needs to be cleared. If flag exists, then
change cachetime to zero.
Here's an example.
-- set in app.cfm --
Hi!
I've got a shopping basket going:
cfset tempValue = queryAddRow(session.basket)
cfset tempValue = querySetCell(session.basket, ID, form.ID)
cfset tempValue = querySetCell(session.basket, Quantity, form.quantity)
But I can't find the instructions on how to delete items
from the basket.
That is true. Hopefully by the time it gets out of beta. :)
Even the mod_php and mod_ssl don't work yet (as far as I know).
Another nice thing I saw was that the new module API allows you to add
protocols. Maybe someone can add FTP and SMTP modules and give Apache the
functionality that IIS
Why not do:
CFQUERY NAME=engineeringinfo DATASOURCE=Biosreference DBTYPE=ODBC
Update BiosPart
SET VGA_Rom = 'PCI'
WHERE
Part_ID 751
/CFQUERY
CFQUERY NAME=engineeringinfo DATASOURCE=Biosreference DBTYPE=ODBC
Update BiosPart
SET VGA_Rom = 'PCI'
WHERE
Part_ID BETWEEN 751 AND whatever
/CFQUERY
We have been running Apache with CF 4.5 on NT 4 for the last 2 year under
very heavy load and have found no stability problems that were related to
Apache. Additionally, because of the open API of apache we have been able
to do some very interesting things for scale and reliability:
1. Run 2
On a shared hosting service, we're getting a lot of (intermittent) errors
like this:
Just in time compilation error
unknown parser error
The error then points to the very first character of the first line of the
template, so that seems spurious.
CF-Talk archives show numerous similar reports,
I use:
cfif cgi.remote_addr contains '192.168.5.'
Allow action
/cfif
Quite a bit easier I think.
- BILL -
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 10:00 AM
To: CF-Talk
Subject: Re: Brain isn't working yet...
or the
I always though it was NAME=#Session.SessionID# and
NAME=#Application.ApplicationName#. Notice the pounds.
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
Try using PART_ID =751 OR PART_ID =752 instead of PART_ID =751 AND PART_ID =752 or try
PART_ID IN ('751,752')
not sure if that is correct syntax off the top of my head.
Mark Smyth wrote:
Ben
your code there is trying to update a product which has a productId of 751
AND 752
it won't
left(length_of_the_string - 1)
sebastian palmigiani [EMAIL PROTECTED] wrote:
I do not understand why you get trailing back slash when using
GetDirectoryFromPath with Apache web server
cfoutput#GetDirectoryFromPath(CGI.CF_TEMPLATE_Path)#/cfoutput
In other words I get
c:/program files/apache
Michel,
If you are going to use queries than there is no clean way to remove rows -
best bet would be to have another column with an active flag. To delete
you just set it to 0 and then ignore it in further processing. The only way
to actually remove a row is to copy the query except for that
I have code to check for the existence of a file which work fine in CF 4.0
but only always returns a 'NO' in CF 4.5.
Has anyone else encountered this problem and/or could offer some advise?
CFSET CFFTP.ReturnValue = NO
CFSET sDirQTROper = #sDir#'QtrOper\MPC\'#client.PlanID#'.pdf'
CFFTP
Got another good one. I'm doing an IsDate() function for a cfif statement,
inside a cfloop-query. The problem is that the cfif's will not function
properly if there are NULL's in the data.
Any suggestins would be nice...
Here is the code:
cfloop query=qTMPPull
cfif
What happens if you use this code in query number 2? If it works, you might
have to explicitly call classID in a scoped variable (variables.classID).
Maybe there's a conflict with classID in another scope?
CFQUERY name=InsertWaitingStudent datasource=SMC
UPDATE ClassRegistration
SET
Yeah, a URL parameter! (Why didn't I think of that?)
I've already got my cache spans in variables (e.g. request.cacheSpan), so
this is a piece of cake.
mydomain.com/myPage.cfm?clearCache=1
___ application.cfm _
// snip
if (isdefined(url.clearCache)) {
request.cache_span =
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 13:37
To: CF-Talk
Subject: RE: IIS or Apache? (WAS RE: can anyone help?)
We have been running Apache with CF 4.5 on NT 4 for the last 2 year under
very heavy load and have found no
My understanding was that Apache for NT used the POSIX subsystem, and took somewhat of
a performance hit because of it. Is this not the case?
Kevin
[EMAIL PROTECTED] 06/01/01 01:52PM
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01,
1 - 100 of 108 matches
Mail list logo
