I'll go through the DWMX section in the Studio MX user guide over the
w/e. No doubt I'm being excessively harsh and just highlighting my
lack
of product knowledge (and the fact that it's a Friday ;-)
Ok, I'm a convert:-)
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion
anyone got any insight on this? its really bugging me...
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 10 July 2003 16:52
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] CF to JS problem
I am working with a JS calendar and the following code creates the
can we see your code?
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 10:25
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] CF to JS problem
anyone got any insight on this? its really bugging me...
-Original Message-
you already havethat basically is it
but here is the date code as well (debug code incl.)
!--- Set Start and End dates for calendar ---
cfset startDate = DateAdd(d,-1,now())
cfset startDate = DateFormat(startDate,dd/mm/)
cfset endDate = DateAdd(,1,now())
cfset endDate =
go to experts-exchange.com and post it in the JavaScript forum - some _very_
good guys in there.
regards,
Ian W
- Original Message -
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:24 AM
Subject: RE: [ cf-dev ] CF to JS problem
This, AFAIK..is not a JS issue per say(though could be)
The server should just be spitting out the already parsed JS as if the date
was hardcoded.
-Original Message-
From: Ian Westbrook [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 10:31
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ]
You seem to have three different date formats going on, is this what you
intended?
Ade
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 10:33
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] CF to JS problem
you already havethat
Hi All,
I want to move Client variables from being stored in the Registry to a Database
without losing the data. Does anyone have any pointers about how best to go about
this, particularly how do I get the data out of the registry?
If anyone has any code samples that do this, that would be
I want to be able to organise my clients to let me know when there are bugs
for software, and what needs doing, who to contact etc...
I've looked on the MM exchange and can't find that kind of tool with their
(pretty useless imho) search tools!
Anyone? Tool must be free (or I'll write it myself)
what like a ticket tool? You can probably get a cheap copy of SiteSpring
somewhere!
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 11:47
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Client Management Tools
I want to be able to organise my clients to
Ok... Something like that, although I don't want to pay for it... Just not
have the hassle of a few hours sitting here and coding something that will
work, but I'll miss somethings I'm sure!
Paul
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 14
so did this help Neil?
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 10:38
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] CF to JS problem
you already havethat basically is it
no it wasn't. That was the hardcoded JS code, I wanted
Hey Richwill give it a whirl and get back to you...sorry, had a real
problem with a shitty View on a table
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 11:49
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] CF to JS problem
so did this help Neil?
RT is very good and free http://www.bestpractical.com/rt its written in
perl though.
- Original Message -
From: Paul Johnston [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:47 AM
Subject: [ cf-dev ] Client Management Tools
I want to be able to organise my
if anyone can get a sample of this up and running on the net...please let me
know...would like to see it
-Original Message-
From: Stephen Fernandez [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 12:38
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Client Management Tools
RT is very good
Ditto that... anyone know of anything CF based? Paul -- if you end up having
to build something I'll give you a hand scoping it if you want.
- Original Message -
From: Paul Johnston [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 11:49 AM
Subject: RE: [ cf-dev ]
Oooh... Sounds like another open source CF project on sourceforge coming
along!
Erm... Not at the moment! Having a look at RT (although seems a bit OTT for
my liking!)
Found this: http://www.triangle-solutions.com/triangle.html?page=support
Which is simple and effective! Does the job which is
does it have developer assignment etc..? we have in house one at the moment
which does exactly what we want etc...but its getting a little aged and we
are looking to replace it either by development or via open source
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]
Sent:
Hi,
I am using an Access DB and am using the INSERT INTO statemeant to add an
entry to a table, how do i get the ID for the entry that I have just
inserted (the Autonumber). I am currently using a second SELECT query to
retrieve the field using the values that were inserted, but this doesn't
look
after the call : simply do another query and use SELECT MAX(ID).
Remember and use locks around that one in case another record gets inserted
before it can run.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 13:44
To: [EMAIL PROTECTED]
Subject: [
after the call : simply do another query and use SELECT MAX(ID).
Ah thanks, crafty solution - why didn't I think of that, I'll put it down to
it being a Monday ;-)
Cheers,
Chris
British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no.
or to expand, you could get around the second query by not using autonumbers
and creating a UUID before you insert - that way you will have a unique
record and the key all in one handy stint.
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 14 July 2003
Well I'm probably gonna have a bash at one if I have time anyway, happy to
keep it open to the list.
:0P
- Original Message -
From: Paul Johnston [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 1:33 PM
Subject: RE: [ cf-dev ] Client Management Tools
Oooh... Sounds
Agree with the second option, I always try and avoid autonumber and
increment, they seem to cause more problems than they solve, keep the code
in your hands I always say! You've also got a better system which is easier
to migrate when the time comes
-Original Message-
From:
Yep, the only problems I find with UUID's (and since my Spectra days) is
that they are a real bitch to remember!
-Original Message-
From: Kevin Faulkner [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 13:57
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] SQL INSERT INTO
Agree with the
cftransaction
Your Insert Query here
SELECT Max(id) as SomeIDName
FROM
/cftransaction
Steve
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 13:44
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] SQL INSERT INTO
Hi,
I am using an
Agree with the second option, I always try and avoid
autonumber and
increment, they seem to cause more problems than they solve,
keep the code
in your hands I always say! You've also got a better system
which is easier
to migrate when the time comes
Ok thanks for the advice,
Is there a need for a transaction? surely the data being passed into the
insert will already be validated client and server side.
-Original Message-
From: Steve Martin [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 13:49
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] SQL INSERT INTO
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 14:01
To: [EMAIL PROTECTED]
Access will prob
not like me changing the datatypes becuase of relationships.
Yeah as I thought Access isn't letting me change the data-types without me
deleting all
Yep, the only problems I find with UUID's (and since my
Spectra days) is
that they are a real bitch to remember!
but that can be an advantage.
Want to stop people *easily* second guessing your record ids in an app? Use
UUIDs.
Now before people turn around and say, but you should be
Niel
cfTransaction allows Rollbacks should there be an error on the insert
I see what you are saying that this should never happen because all the
input should be validated but if the database crashes after the 1st query ..
you will end up having orphined data
therefor CFtransaction is ALWAYS a
yep, I am fully aware of what cftransaction does - I dont use it myself, as
we use SP's here...but I think for this its overkill.
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 14:30
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] SQL INSERT INTO
Niel
unless it's MySQL which doesn't support it yet!!
Sorry, just being awkward!
-Original Message-
From: Matt Horn [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 14:30
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] SQL INSERT INTO
Niel
cfTransaction allows Rollbacks should there be an
all cftransaction will allow
you to do is rollback any changes should you pass in crappy code for
the
insert
I thought, in this instance, where the possibility exists that another
user cause a simultaneous insert to occur, the cftransaction ensured
that the MaxID value returned by the select
anyone got a snippet of code to illustrate the CFTRANSACTION... to put
around the SELECT MAX(id) AS MAXID... code? I'm still using CFLOCK
(type=exclusive) too...
ta
Ian W
- Original Message -
From: Steve Martin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 3:06 PM
Just use cftransaction Isolation level isn't that important.
-Original Message-
From: Ian Westbrook [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:12
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] SQL INSERT INTO
anyone got a snippet of code to illustrate the
CFTRANSACTION...
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental Ltd +44 (0)1695 51775
Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards
This e-mail has been scanned for
Hi Ian,
its really not biggie and once you move onto enterprise DB's its essential :
check out Mr Horwith's excellent doc on the subject..
http://www.macromedia.com/devnet/mx/coldfusion/articles/cftransaction.html
-Original Message-
From: Ian Westbrook [mailto:[EMAIL PROTECTED]
Sent:
:-)
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:25
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Anyone want to buy either or both of Ben Forta's CF5
books?
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks
sell them on Amazon Market place, someone bought mine for £25 each!
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:24
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] Anyone want either or both of Ben Forta's CF5 books
for free?
:-)
too much hassle..just traking up space on my shelf...
-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:28
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Anyone want either or both of Ben Forta's CF5
boo ks for free?
sell them on Amazon Market
sell them on Amazon Market place, someone bought mine for £25 each!
I advertised them there for a while, but was probably asking for too much.
I'll give it another shot, though... thanks.
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental Ltd
What do you guys use as your UUID's? the result of the createUUID
function?
__/ [EMAIL PROTECTED] \__
I am using an Access DB and am using the INSERT INTO statemeant to add an
entry to a table, how do i get the ID for the entry that I have just
inserted (the Autonumber). I am
Yeah, wouldn't mind giving them a read.
Cheers,
Chris
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:24
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] Anyone want either or both of Ben Forta's
CF5 books
for free?
:-)
sometimes, but more often than not I use SQL server : they are slightly
different from CF ones.I think they are 36 chars compared to 34.
-Original Message-
From: Jolly Green Giant [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:39
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] UUID (was
you need to be careful - MS SQL and CF use different UUID formats.
I prefer to create the UUID in SQL - this way my db app is middleware
independent and doesn't rely on CF to run, but this is a small point.
-Original Message-
From: Jolly Green Giant [mailto:[EMAIL PROTECTED]
Sent:
my point exactly.
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:47
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] UUID (was SQL INSERT INTO)
you need to be careful - MS SQL and CF use different UUID formats.
I prefer to create the UUID in SQL -
BTW, I'm using CF4.5, if that makes any difference?
Ian W
- Original Message -
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 14, 2003 3:24 PM
Subject: RE: [ cf-dev ] SQL INSERT INTO
Hi Ian,
its really not biggie and once you move onto
no, just means you have access to old cftransaction type params - if there
are any
-Original Message-
From: Ian Westbrook [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 15:54
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] SQL INSERT INTO
BTW, I'm using CF4.5, if that makes any difference?
Like Adrian says, there is the possiblity for another transaction to
sneak in
between your first query and the select max... CFTRANSACTION causes
anything inbetween to be treated as an atomic Db transaction thus
ensuring
that the select max... is pulling out the record that was created as a
you need to be careful - MS SQL and CF use different UUID formats.
my point exactly.
Realistically though, why should the format difference matter if they
are both uuu--IDs?
Other than to make sure the text field in the DB is big enough, of
course
--
Aidan Whitehall
That will only do a transaction lock on the code on that page. Another
page elsewhere could still acces sthe DB inbetween
-
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
That will only do a transaction lock on the code on that page. Another
page elsewhere could still acces sthe DB inbetween
So the cftransaction in the first query doesn't lock the table, queuing
the next insert / select?
--
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion
No, cftransaction DOES lock the table (or row, depending on isolation) cflock doesn't
as it only works at a CF script level.
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 17:01
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] SQL INSERT INTO
No, cftransaction DOES lock the table (or row, depending on isolation)
cflock
doesn't as it only works at a CF script level.
Hmmm I thought that in the case of Access (the db being discussed,
IIRC) that *both* would work, so long as the cflock was in the
application scope.
AFAIK, Access
Does anyone have a recursive function that traverses an XML tree and
returns the text value of each node?
I would be much obliged.
Douglas
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Consider the scenario of another application accessing the same database. An
application scoped lock won't be honoured by a foreign application. The ONLY sure fire
way to ensure atomic transactions is to have the db engine take care of it. CFLOCK
CFTRANSACTION = apples oranges, chalk cheese,
Consider the scenario of another application accessing the same
database.
An application scoped lock won't be honoured by a foreign application.
The
ONLY sure fire way to ensure atomic transactions is to have the db
engine
take care of it. CFLOCK CFTRANSACTION = apples oranges, chalk
Apologies for yet another DWMX q... the Chatty Fig DWMX list is pretty
well dead (another other good DW lists you know of?)
If you're working on a template that expects a url parameter and you hit
the Live Data View button, how do you supply said url parameter to DWMX
before it throws the
looks like the truly portable solution would be to use multiple queries on
a long int field to do your own auto-incrementing.
__/ Aidan Whitehall \__
you need to be careful - MS SQL and CF use different UUID formats.
my point exactly.
Realistically though, why should
60 matches
Mail list logo