Dear Fellows,
I am trying to use CFTRANSACTION for a multiple insert query to the same
datasource but obviously different tables. Now my need is that if any one of
the INSERT query fails, all the other queries must be rolled-back. If all of
them succeed, then the complete transaction should
The CFTRANSACTION tag takes care of the top-level rollback all on it's
own. The explicit rollback is only used if you have logic inside the
CFTRANSACTION tag that needs to roll back because of some
non-exception situation. So you'll get the behaviour you want if you
remove the CFTRY..CFCATCH
Thanks Barney will try that out :)
I also found an old reply by you on a similar topic
RE: cftransaction cftry order
Barney Boisvert
Thu, 29 May 2003 09:43:52 -0700
:)
Regards,
Arsalan
--
From: Barney Boisvert bboisv...@gmail.com
Sent:
looks like /cfcatch is missing
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Have you checked the table definitions are the same between dev and staging?
It's possible to import/export/script tables and defaults not to go across
too.
Adrian
-Original Message-
From: Nathan Strutz [mailto:str...@gmail.com]
Sent: 28 July 2009 05:30
To: cf-talk
Subject: Re:
Hi frnds,
how can i get current row number inside cfgrid , if any one know please tell .
Rama
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Likewise
2009/7/28 Azadi Saryev az...@sabai-dee.com
down here as well (Hong Kong). been down for almost 24 hours now, i
think...
my sites with AHP have been up and down lately, too, but seem to all be
OK now (knocks on wood)...
Azadi Saryev
Guys cumbersome
below is my code and still its not rolling back ... I have
injected an error in the 2nd insert statement but the transaction
doesn't rolls back... 1st insert takes place... 2nd one has error wat
could be the problem ... dear experts???
Thanks Jason.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325032
Thanks for help Jason!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325033
Guys cumbersome
below is my code and still its not rolling back ... I have
injected an error in the 2nd insert statement but the transaction
doesn't rolls back... 1st insert takes place... 2nd one has error wat
could be the problem ... dear experts???
Helpful...? http://oauth.riaforge.org
On Mon, Jul 27, 2009 at 7:22 PM, Brett Hellman bhellm...@gmail.com wrote:
Has anyone implemented oAuth / Twitter Connect on an app? I'm struggling to
understand how to implement oAuth with Coldfusion and could use some
pointers or documentation for CF.
Near the top of your template:
cfset ajaxOnLoad(init) /
Then, within a JavaScript script block (preferrably within a document
ready statement of some kind):
init = function(){
var theGrid = ColdFusion.Grid.getGridObject('myGrid');
theGrid
Try putting your CFTRY / CFCATCH around the outside of the CFTRANSACTION
... the error handler is not triggering your roll-back, I would guess.
cftry
!---//Starting Transaction
-
cftransaction
!---//QUERY1 Insert
Glad to help!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325038
I'm trying to roll out my app and I was asked to put it in a subfolder within a
main webroot directory. I'm currently getting this error:
==
This is the template errortemplates/fusebox.undefinedCircuit.cfm
An Error of type fusebox.undefinedCircuit
No guys this isn't working ... nor that what Barney and Dave advised...
does anyone has a working example of such scenario? I would be very thankful
if someone provides me with a somewhat similar working example
and yes... I am using using CFTRY/CFCATCH because I need to log the errors
I have been asked to make a change to a blog like feature. Specifically, they
want to allow users to upload a single image per blog post but the images are
to be stored in a non-web accessible location.
When viewing blog posts, the images are supposed to appear within the text of
the blog
try / catch is still the right way to capture errors, but if it's inside
the transaction, then the TR won't fire.
if this isn't working, though, then I gotta question whether Access
supports transaction locking at all? It's been years since I used it, so I
can't vouch one way or the other
The first question I would ask is Why do they want the images stored in a
non-web-accessible location
If the answer is something lame like, they don't want users to be able to
download them, then you can get around this whole issue as you can tell them
that there is no way to totally prevent a
I imagine this is a common issue :
Let's say you have bunch of PDFs in a directory: /pdfs and the links to the
files in the site are behind a login so non-registered users cannot access
them. If a users knew the link to the file:
http://www.mysite.com/pdfs/sample.pdf they could still get to
One thing you could do is write a CF page to retrieve the files for the
user. That way, they wouldnt know the actual location of the file on the
file system. You would then make sure they were logged in before letting
them retrieve the file.
Dave
On Tue, Jul 28, 2009 at 2:11 PM, Scott
them. If a users knew the link to the file:
http://www.mysite.com/pdfs/sample.pdf they could
still get to it in the browser without signing in.
Is there any way outside of windows authentication
at the directory level to prevent this? What
is the standard way of dealing with this (if
Typically, the best way to secure downloadables is to have them stored above
the web root, thus not being directly accessible by the browser. Then when
an authnticated user wants to download one, you provide it to them
progrmatically
Here is a rough example
a href=download.cfm?file=abc.pdfClick
I put stuff like that on S3, with read access denied. When someone
wants to view the resource, they're sent to a proxy page (written in
CF or whatever) that will build a signed URL that will allow them read
access to the resource for a period of time (a few minutes, a couple
hours, whatever is
No guys this isn't working ... nor that what Barney and Dave advised...
does anyone has a working example of such scenario? I would be very thankful
if someone provides me with a somewhat similar working example
and yes... I am using using CFTRY/CFCATCH because I need to log the
hey Dave... can you provide me with some literature or example code on this
topic ... specially in regard to MS Access...?
--
From: Dave Watts dwa...@figleaf.com
Sent: Wednesday, July 29, 2009 12:34 AM
To: cf-talk cf-talk@houseoffusion.com
Has anyone been able to integrate with QBMS using CF? I have looked around
some on different forums and the last time someone posted a solution was
over a year ago. I really need help in finding out how to do this pretty
quickly. Any help is appreciated.
Thanks!
--
“When you choose hope,
Hey all,
I've tried adding params on all fields, then only some. I've changed the
type from clob to varchar to char.. I still get the same error. Help
please, thanks!
cfquery name=bus datasource=ConnectNS
INSERT INTO dbo.Businesses INSERT INTO dbo.Businesses
Hey all,
I found the problem. Seems just posting the question fixed it, lol!
Rick Sanders
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
!--- Prep request ---
cfset qAppId = XXX
cfset qAppLogin = whatev.yourdomain.com
cfset qTimeStamp =
#dateformat(now(),-mm-dd)#T#timeformat(now(),HH:mm:ss)#
cfset
Thanks a lot Dave, Barney and Jason ... it seems my code was perfectly fine
.. it was a bug in Railo :)
it has been removed in the server updates and now everything works fi9
Alhamdulillah ...
:)
Regards,
Arsalan
--
From: Arsalan Tariq Keen
Don't put ' marks around CFQUERYPARAM ... it already handles that for you.
Also, you were missing pound signs around several of the params.
INSERT INTO dbo.Businesses (
CountyID,
CityID,
CategoryID,
SubCatID,
SubCat2ID,
BusinessName,
Address,
Zip,
Thanks. I did have it right, but I was trying different things to get it to
work to the query got messed up. I did end up figuring it out though.
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: July-28-09 5:09 PM
To: cf-talk
Subject: re: Invalid parameter binding -
Hello,
Would you recommend me upgrading from MS SQL Server Express *2005* to MS SQL
Server Express *2008. *I'm currently having issues with 2005 which is
causing CF to hang and be completely unresponsive. Given my recent troubles
I'm wondering if an upgrade to 2008 could resolve a lot of them?
Here's what's new in 2008:
http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx
Whether 2008 fixes your problems sorta depends on the cause of your
problems...
On Tue, Jul 28, 2009 at 3:59 PM, Brett Hellman bhellm...@gmail.com wrote:
Hello,
Would you recommend me upgrading from MS
Is anyone using Jasper Reports or Crystal Reports with coldfusion.
For years I have been using asp code to interact with cyrstal reports, but
now that I need to move to a new server (been trying that for 2 years) I
need to upgrade my code and am searching for a solution.
We publish a 3 column
I'm running into this exact same issue and wondering if anyone has found a
resolution to this?
Hello,
I'm trying to use the new cf8 exchange integration and I can't make it work.
Our company system admin assures me that the following are set:
# IIS is set up and running on the Exchange
I'm working on a project that will require SMS messaging. All we need to do is
send outgoing. Monthly volume will be 5000 or less. All messages will be
within the USA.
Sending via the email method (num...@provider.net) has not proved reliable, so
I assume we need to open an account with an
This is a pretty basic question so I hope it makes sense, as I'm curious
to know what other techniques are available to achieve the same result
as the code below (hopefully in a more efficient manner).
This is for a photo gallery of winning garments from a recent awards
evening. Here is the
cfswitch / cfcase is the way to go ... except that it won't do a
CONTAINS for you, only a string or list element match. That being said,
if you can do a string match (instead of a partial string match), then a
single cfswitch has better performance than 30 cfif tests ...
You can probably put your winner criteria into a struct:
cfset winnerData = {}
cfset winnerData[doosh] = { category = DOOSH Collections, winner =
Carol Yeung }
etc ...
Then loop over the struct keys
cfset result = 0
cfloop item=code collection=#winnerData#
cfif getImageInfo.name contains
You can probably put your winner criteria into a struct:
cfset winnerData = {}
cfset winnerData[doosh] = { category = DOOSH Collections, winner =
Carol Yeung }
etc ...
Then loop over the struct keys
cfset result = 0
cfloop item=code collection=#winnerData#
cfif getImageInfo.name contains
Jason Fisher wrote:
cfswitch / cfcase is the way to go ... except that it won't do a
CONTAINS for you, only a string or list element match. That being
said,
if you can do a string match (instead of a partial string match), then
a
single cfswitch has better performance than 30 cfif tests
Hey sorry I don't monitor cf-talk much, you might check the Fusebox5 Yahoo
groups.
You are getting that error because the defaultFuseaction references a
circuit of m, if Fusebox can not find it you get that error. Chances are
your move to the subdirectory resulted in a slight issue with the
45 matches
Mail list logo