> 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 updat
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
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
(documentati
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 som
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 Num
> 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
> 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 in there) or a timeout
> (when I take those out.
Based on what you pasted in, I re-worked the login code a little
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.. be
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 "wddx
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
> 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
Using
CF 5
Win2K Server
IIS 5
I have the following in a template
function dbconcatenate() {
return preservesinglequotes(ArrayToList(arguments," + "));
}
request.tapi.tStor("dbconcatenate","db.concatenate");
The cfscript block contains several other func
I'm working on IIS.
The code is:
Text:
#URL.text#
I'm calling url.cfm?text=Aağşıİxqöo
and the result:
Text:
AaðþýÝxqöo
When I use in the application.cfm
The result:
Text:
Aa
CF MX currupts the string!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
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):
#preservesinglequotes(b)#
It would be interesting to know how this function works!
Matthew Walker
Electric Sheep Web
http:/
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, Mar
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
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
> #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: http://www.houseo
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 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 mistaken?
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:
SELECT * FROM SPS_NON_MOT_BPS.SITES
WHERE
((int(CREATION_DATE)
> 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 effecti
>> #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 codi
> 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:
>
>
> SELECT * FROM SPS_NON_MOT_BPS.SITES
> WHERE
> ((int(CR
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:
SELECT *
FROM SPS_NON_MOT_BPS.SITES
WHERE ((trunc(CREATION_DATE) <= trunc(sysdate
> > 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
http://www.figleaf.
Dave,
Thank you !! Works like a charm.
-Patrick
Something like this should be what you're looking for:
SELECT *
FROM SPS_NON_MOT_BPS.SITES
WHERE ((trunc(CREATION_DATE) <= trunc(sysdate-3) AND Badging_status = 'In Approval
Cycle') OR (Badging_status = 'In Renew Cycle' AND trunc(MODIFY_DATE)
> 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 "d
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.
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)
> -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
>
>
> I'm guessing cfo
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=messages&threadid=22567&forumid=4&refresh=0
:-)
We too use an SQL server but my exhaustive
tests came up negative to an
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/
Variables/ScopesOvervi
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:
http://www.houseoffusion.com/cf_lists/index.cfm?met
> 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 probl
> 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.
~~~
40 matches
Mail list logo