Hello!
Can some one please tell me what is wrong with this tag?
CFIF CGI.REQUEST_METHOD IS POST
CFGRIDUPDATEDatasource=SomeDatasource tablename=SomeTablename
Grid=ActorGrid
/CFIF
The error on the action page reads like this:
CFGRIDUPDATECANNOT FIND the GRID named ActorGrid
My Grid Page is working
Hi,
Firstly I would recommend changing the title of your email to CFGRID is a problem!
I have had similar issues, I don't remember the exact article on Macromedia.But what I did was on my windows machine that was accessing the page.I went to c:\program files\java and renamed the folder
UPDATE products
SET dprice = dealerprice.price
FROM products, dealerprice
WHERE products.code = dealerprice.code
--
Michael Wolfe
[EMAIL PROTECTED]
-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 1:58 PM
To: CF-Talk
Subject: RE:
Adam Wayne Lehman wrote:
Looks like your original post got cut. what does the code look it?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Rick Root wrote:
Adam Wayne Lehman wrote:
Looks like your original post got cut. what does the code look it?
Damn it my Cold Fusion code keeps getting munged!
Alright... I figured it out
I was doing this at the top of the function body:
[CFSET var retVal = ArrayNew(1)]
It didn't like
Ack - you definetely do NOT want to remove the var scoping. Please try again
to post your code. It should look something like this:
cffunction ...
cfargument ...
cfargument ...
cfset var x = 1
cfset var y = 2
/cffunction
All var scope lines MUST come after the cfargument tags and before
Jim T wrote:
the above code gets this error not sure why any help would be appreciated.
Operation must use an updateable query.
Not much details about database, drivers and configuration, but I
will make an educated guess. Make sure your Access database is in
a directory with write
Is there any way to automatically determine where the cfdocs directory is
in CFMX?Seems there's nothing in the registry any more.
This is for a tool not running in CF so I can't use any cf variable or
anything to determine mappings or locations.
Thanks,
Sam
Raymond Camden wrote:
Ack - you definetely do NOT want to remove the var scoping.
All var scope lines MUST come after the cfargument tags and before any
real code, so you CAN'T do this:
snip
AH!GotchyaAfter the cfarguments and before I trim and UCASE the
arguments =)
That
Just as an anal fyi, in mx 6.1 (only) you _can_ have one tag before the var
statements, but it has to be cfscript, ie:
cffunction ...
cfargument ...
cfscript
var x= 1;
var z = 1;
var a = 2;
/cfscript
...
/cffunction
Enjoy. :)
[Todays Threads]
[This Message]
[Subscription]
[Fast
Check all of your entries - something is going wrong
One of the entries has a date that it just can't convert
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 1:05 PM
To: CF-Talk
Subject: RE: SQL date conversion issue
Here is what I
ok, this is a bit scary, but im about to lose
a lot of work, if this isnt fixed, and i dont know
how to make this happen faster than the normal development
cycle.
its all explained right here:
http://dev.navtrak.net/dateDiffbug/anotherDateDiffBug.cfm
thanks.
macromedias, this is HUGE, this is
Is there any way to automatically determine where the cfdocs
directory is in CFMX? Seems there's nothing in the registry any
more.
This is for a tool not running in CF so I can't use any cf variable
or anything to determine mappings or locations.
I can think of a few possibilities, which
Actually it is validating correctly.There are 8 days between 4/1 and 4/10.
the between function does not count the start or end number.
The keyword is between -If you are merely subtracting one from the other then
it would be 9 days
There is a difference in using betweenand hidate - lowdate =
Tony Weeg wrote:
http://dev.navtrak.net/dateDiffbug/anotherDateDiffBug.cfm
I disagree with the following part of your analysis:
And the rest of the calculations follow in their offness
Except for the days, all other calculations are correct. CF MX
appears to think that every day is 24 hours,
ok, then use two other dates...that dont straddle the DST begin.
try 5/1 and 5/10
what do you get?
tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Saturday,
nope.
i disagree with you jochem.
8 days between 04/01/1999 and 04/10/1999(wrong, there are 9 days
between 4/1 and 4/10 no matter what)
215 hours between 04/01/1999 and 04/10/1999(215 / 24) = 8.958 (WTF
IS THAT?)
12900 minutes between 04/01/1999 and 04/10/1999(12900 / 60) / 24 =
8.958
Tony Weeg wrote:
8 days between 04/01/1999 and 04/10/1999(wrong, there are 9 days
between 4/1 and 4/10 no matter what)
I agree with you there.
215 hours between 04/01/1999 and 04/10/1999(215 / 24) = 8.958 (WTF
IS THAT?)
12900 minutes between 04/01/1999 and 04/10/1999(12900 / 60) / 24
and here is probably the real reason for the bug:
1. dateDiff() with the 'd' argument for the datepart returns 1 day off
when the dates straddle any DST begin Date.
2. dateDiff() with the 'h' argument for the date part returns almost the
right number, but is a bit off, and my assumption is...is
:) ok, your right, i did say what can i do but heres what i meant,
macromedia, how can i get this fixed, soon, this is a problem.do i
need to make yet another workaround?
tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
-Original
I have a project, where I'm trying to set up a page for creating an user account.And then validate before inserting into database.I have the form fields set up as Variables.foo in the main template, as such:
cfif Len(ErrMsg) EQ 0
!--- initialze form variables ---
cfset Variables.foo =
cfelse
put the structure in a persistent scope, session for instance.
instead of variables.foo
use session.foo.
but be sure to cflock it, if race conditions could occur.
tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
-Original Message-
Tony Weeg wrote:
case in point
4/1/1999
4/10/1999
9 days
216 hours
cfmx thinks 8.95 days (almost 9 since the switchover actually
happens @ 2:00am in the middle of the calculation)
Incorrect.
and 215 hours,
Correct ;-)
however the function dateDiff() wont return 8.95,
We setup a little internal service to do this. How?
* We used a not very loaded Win2k server, w/o CF to do this
* A simple asp page that downloads a word doc (also works with html/rtf)
passes as a url
* opens it in a MS word 2000 object
* prints it to a postscript printer that is mounted to write
You might want to check if they have a robots.txt and/or any
robots/scaring headers.
-
Hugo AhleniusE-Mail: [EMAIL PROTECTED]
Project Officer Phone:+46 8 230460
UNEP GRID-ArendalFax:+46 8 230441
Stockholm OfficeMobile:+46 733 467111
Let me see if I understand this . . . It's possible to do this:
cfset session.stCreatAcct = StructNew()
cfset stCreatAcct.session.FName = #form.fname#
cfset stCreatAcct.session.LName = #form.lname#
And then in the other template I can do this:cfset Variables.foo =
#session.stCreatAcct.foo#
At
however the function dateDiff() wont return 8.95, it returns 8.
maybe they round down?
Probably.
The docs are very clear on what dateDiff does.The DateDiff function
determines the number of complete datepart units between the two dates; for
example, if the datepart parameter is m and
Thanks for the suggestions.
With CF5 I think there are registry keys that tell you where the CFIDE is
and cfdocs is relative to that, I'm mostly concerned with CFMX.
I'll check out the uninstall option.. there must be a path to the uninstall
file at least somewhere (not in mine since I'm using
almost ;)
cfset session.stCreatAcct = StructNew()
cfset session.stCreatAcct.FName = #form.fname#
cfset session.stCreatAcct.LName = #form.lname#
put the session. on the front of the variable.
And then in the other template I can do this:cfset Variables.foo =
#session.stCreatAcct.foo#
no need
BUT THEN WHY DOES 5/1/1999 to 5/10/1999 say one thing, and 4/1/1999 to
4/10/1999 say another?
tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
Sent: Saturday, December
As long as you use Jet to process the query you can do this.Even if the
target database isn't normally using Jet, you can use a dynamic connection
string.
Let's say the target is an access database.
cfquery datasource=accessDatasource
INSERT INTO AccessTable (AccessField1, AccessField2)
SELECT
the problem lies here.
in the world of collections, and more specifically how interest
is applied to the original principal of the debt.
when you apply payments to the debt, it goes first to accrued interest,
which
is based on the number of days since the last payment, plus any
outstanding
dateDiff() returns 8 in the case that the days span DST start because you
lose an hour and thus the difference gets floored so you end up losing a
whole day.When the dates cross DST end then you gain an hour which gets
rounded down so the number is still accurate according to expected results.
If
looks like we have a WINNER
great idea sam, i kinda was leaning towards
that, since i knew that i could get the number
doing another calculation, my idea was just to
do a dateDiff() and have 'h' as the datepart, then
do a / (divide by 24) get the number, and round up all
the time, since most of
You don't have to do any rounding.It sounds like all of you are making
this in to a larger problem then it is.If we know that 1 hour is lost
because of the time change then why not get the number of hours between
days.So for the calcuation, do the DateDiff for the days in question
and return the
uhhh, isnt that kinda what i suggested, just rounding the other way?
tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
-Original Message-
From: Kevin Webb [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 13, 2003 7:35 PM
To: CF-Talk
CF 5 docs say:
Returns the number of intervals, in units of type datepart, by which
date1 is less than date2.
CF 6 docs say:
Determines the number of units by which date1 is less than date2
CF 6.1 docs say:
Determines the integer number of units by which date1 is less than
date2.
I'm running
There were other bugs in CF6 that necessitated changing the formula in
6.1--leap years was the one that stands out but there were others as well.
Sam
---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
38 matches
Mail list logo