Without giving this too much thought, it seems to me that you could either
(a) put the expiryDate part before the startDate part, or (b) just create
a
local variable within your stored procedure that has the value you want.
But
maybe I'm missing something.
That would result in
Before update
I thought that would do the trick, but was wrong...
However your suggestion did help me.
1. UPDATE thisTable
3.expiryDate = DATEADD(minute, DATEDIFF(minute, startDate,
expiryDate)/2, GETDATE())
2. SET startDate = DATEADD(minute, DATEDIFF(minute, startDate,
expiryDate), GETDATE()),
Sorry Dave,
What you suggested did work..
Cheers.
Long day, better give it a rest..~~
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Sunday, March 23, 2003 6:05 PM
Subject: RE: [OT] SP Issue (Datediff)
I have this Stored Procedure that
Do you know CF MX has still problems with Unicode and other charsets.
When I use setEncoding(url,utf-8), CF MX displays some double-byte (the
unicode number over than 255) as nothing. It displays nothing.
When I don't use the setEncoding function CF MX uses UTF-8 by default
(documentation
Quoting Murat Demirci [EMAIL PROTECTED]:
Do you know CF MX has still problems with Unicode and other charsets.
When I use setEncoding(url,utf-8), CF MX displays some double-byte (the
unicode number over than 255) as nothing. It displays nothing.
Which characters? Can you give some example
Am trying to sort prices, highest to lowest and am running into a
problem.
For instance, 3 items are priced at 129.99, 99.99 and 8.99. Unless I
insert a blank space in front of the 8.99 price in the actual database,
it insists in sorting in front of 99.99.
Using both CF DollarFormat and CF
Am trying to sort prices, highest to lowest and am running into a
problem.
For instance, 3 items are priced at 129.99, 99.99 and 8.99. Unless I
insert a blank space in front of the 8.99 price in the actual database,
it insists in sorting in front of 99.99.
Using both CF DollarFormat and CF
I am now having trouble with the condition of if the correctLogin
variable is false or undefined or if the form.userName is undefined. I
get either a loop (when I dont have the cfabort in there) or a timeout
(when I take those out.
Based on what you pasted in, I re-worked the login code a
So CFMX uses the jikesw compiler at compile time and whatever
JVM you have configured.
Back, to the question on the thread..
I downloaded IBM JRE 1.3.0 to use with ColdFusion MX. I'm now
getting some
errors: javax/crypto/a (classdef not found)
Does Jikes come with a good JVM as well.. better
In the Release Notes for U3, it claims that Bug 49064 which was The cfwddx
tag did not properly handle packets marked as version 0.9 was fixed.
However, while running CFMX for JRun with U3, I'm still receiving the
following error:
WDDX packet parse error at line 1, column -1. Relative URI
Thanks, Dave. Perfect answer.
david (other)
On Sunday, March 23, 2003, at 12:42 PM, Dave Carabetta wrote:
Am trying to sort prices, highest to lowest and am running into a
problem.
For instance, 3 items are priced at 129.99, 99.99 and 8.99. Unless I
insert a blank space in front of the
CFTRANSACTION is one of ColdFusion's slickest features.
Much easier than database-level transaction handling.
Let's not forget that in a Clustered environment that CFTRANSACTION
won't stop transactions from the other servers...
That's where database level transactions blow away anything that
I'm working on IIS.
The code is:
!--- Application.cfm ---
cfapplication name=sample setclientcookies=no
!--- end ---
!--- url.cfm ---
cfprocessingdirective pageencoding=utf-8
Text:
cfoutput
#URL.text#
/cfoutput
!--- end ---
I'm calling url.cfm?text=Aağşıİxqöo
and the result:
Text:
AaðþýÝxqöo
Seems like you can only use simple variables in preserveSingleQuotes() - you
can't even use a string! See this for example (the commented out line
generates an error):
cfset a = arraynew(1)
cfset a[1] = qwerty
cfset a[2] = asdfg
!--- cfoutput#preservesinglequotes(arraytolist(a))#/cfoutput ---
Do you think preservesinglequotes() is actually meaningful outside a
cfquery? If you inspect the result of the function I think you'll see the
same thing with or without
- Original Message -
From: S. Isaac Dealey [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 24,
Philip Arnold wrote:
CFTRANSACTION is one of ColdFusion's slickest features.
Much easier than database-level transaction handling.
Let's not forget that in a Clustered environment that CFTRANSACTION
won't stop transactions from the other servers...
They do (if the transaction isolation level
No I haven't found any use for it outside of cfquery -- it was after all
specifically designed to short-circuit the default cfquery behavior... This
particular function is intended only to be used in cfqueries...
#request.tapi.db.concatenate(blah,blah2,yadda)#
This is an attempt at building some
#request.tapi.db.concatenate(blah,blah2,yadda)#
Interesting! Our cms has a variable: request.thrive.dbms.concatenate() which
does almost the same thing! My version just inserts the symbol, so it takes
no parameters. ;-)
Matthew Walker
Electric Sheep Web
http://www.electricsheep.co.nz/
They do (if the transaction isolation level warrants stopping
other transactions).
In other words, stops all other traffic of that type on the database
server... Now THAT's a way to kill a site
~|
Archives:
Thanks Dave, I think I see what I did wrong.
The addtoken attribute needed to be specified to prevent Cold Fusion
from automatically appending #URLToken# to CFLOCATION URLs.
Why would I not use cfabort there?
When is a good time to use cfabort?
It seems like the exit sub function in VB. Am I
How can I query an Oracle Date field as an int? I am trying to find rows that are 3
days old and the date fields in Oracle are timestamps. I need to some how ignore the
time in the date field in the query
This is what I have tried:
cfquery name=Thirdday datasource=badge_access_dsn
SELECT *
Why would I not use cfabort there?
When is a good time to use cfabort?
It seems like the exit sub function in VB. Am I mistaken?
You don't need cfabort with a cflocation because when you use cflocation,
the page that is currently executing stops because of the page redirect.
You've effectively
#request.tapi.db.concatenate(blah,blah2,yadda)#
Interesting! Our cms has a variable:
request.thrive.dbms.concatenate() which
does almost the same thing! My version just inserts the
symbol, so it takes no parameters. ;-)
You and I seem to have a lot in common when it comes to coding. :)
I
How can I query an Oracle Date field as an int? I am trying to find rows
that are 3 days old and the date fields in Oracle are timestamps. I need to
some how ignore the time in the date field in the query
This is what I have tried:
cfquery name=Thirdday datasource=badge_access_dsn
SELECT *
Dave,
As you can probably figure out I am very new to this. I tried your query and it did
give me a date of three days ago. How would I implement this in my query?
-Patrick
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 23, 2003 2:32 PM
To: CF-Talk
As you can probably figure out I am very new to this. I tried your query
and it did give me a date of three days ago. How would I implement this in
my query?
Something like this should be what you're looking for:
cfquery name=Thirdday datasource=badge_access_dsn
SELECT *
FROM
They do (if the transaction isolation level warrants stopping
other transactions).
In other words, stops all other traffic of that type on the
database server... Now THAT's a way to kill a site
I think you're missing Jochem's point, which is simply that if you have
multiple servers,
Does Jikes come with a good JVM as well.. better than
SUN's 1.4.1?
I have no idea; it may well depend on what platform you're using. For
example, I wouldn't be surprised if IBM provides a better JVM on Linux than
Sun, but not on Windows.
Dave Watts, CTO, Fig Leaf Software
Dave,
Thank you !! Works like a charm.
-Patrick
Something like this should be what you're looking for:
cfquery name=Thirdday datasource=badge_access_dsn
SELECT *
FROM SPS_NON_MOT_BPS.SITES
WHERE ((trunc(CREATION_DATE) = trunc(sysdate-3) AND Badging_status = 'In Approval
Cycle') OR
I think you're missing Jochem's point, which is simply that
if you have multiple servers, CFTRANSACTION will work fine,
placing the requisite locks as needed.
My problem with it is that if you put 3-4 queries inside a CFTRANSACTION
instead of using one TSQL transaction, then it'll have to
Philip Arnold wrote:
They do (if the transaction isolation level warrants stopping
other transactions).
In other words, stops all other traffic of that type on the database
server... Now THAT's a way to kill a site
That can be desired behaviour if the alternative is inconsistent data.
Jochem
Philip Arnold wrote:
My problem with it is that if you put 3-4 queries inside a CFTRANSACTION
instead of using one TSQL transaction, then it'll have to deadlock the
DB Server for it to handle the transaction properly
Maybe for MS SQL Server, but databases that do better than row level
Try saving the queries out of the array if you
need to use cfloop /cfoutput. (Just a thought)
cfset qry_1 = QueryAry[1]
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Saturday, 22 March 2003 3:19 AM
To: CF-Talk
Subject: RE: Array of Queries and CFOutput
Have you got any CFWDDX calls in the site ?
Just a thought given our perils. See thread on cfwddx issues
watch the wrap...
http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=22567forumid=4refresh=0
:-)
We too use an SQL server but my exhaustive
tests came up negative to any
Hi everyone,
I updated cfmx from 2 to 3.
Cfmx turn on Apache 2.0.44
Apache and cfmx turn on windows 2000 Sp3
Before update Apache and cfmx r2 delivered a normal performance
But since I update they are very very very slow like a 9600 dbs / s modem
Have you any suggestion for me ??
Thanks
Eric
On Saturday, Mar 22, 2003, at 22:51 US/Pacific, Jim Davis wrote:
I'm looking specifically for mistakes I may have made or language
that's
confusing or otherwise craptastic.
A typo on this page:
http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/
Murat Demirci wrote:
I'm working on IIS.
WFM
http://cfmx.oli.tudelft.nl/url.cfm
Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
in fact, it said Access, so TSQL is not really an option and
I don't know what transaction mechanism it uses
Ah, I missed that, and not knowing the latest Access, I don't even know
if it has any form of TSQL
I have a tendency to avoid CFTRANSACTION because of the overhead, and
potential
Do you know CF MX has still problems with Unicode and other charsets.
hardly any.
When I use setEncoding(url,utf-8), CF MX displays some double-byte
(the
unicode number over than 255) as nothing. It displays nothing.
show some code.
39 matches
Mail list logo
