The chances of chargebacks is slim to none; I would be HIGHLY surprised if
there ever was a single one. This is for customers under contract for a
service, who are already happily paying monthly. We just want to give them
a way to pay online, rather than by check.
This is for a corporate entity
> Now, here is the thing: The client REFUSES to sign
> as a guarantor on the account.
As an aside, HUGE red flag there. Why won't they guarantee their own
merchant account? Are they expecting high rates of complaints or
chargebacks? If they won't do it, you certainly should NOT do it for them
> Looking for a payment gateway that offers a low
> transaction cost/percentage per sale. These will
> be high-value transaction, ~1000 monthly per
> customer.
It's a messy world out there in transaction processing land. In addition to
the direct fees and percentages, consider your PCI complian
Looking for a payment gateway that offers a low transaction cost/percentage
per sale. These will be high-value transaction, ~1000 monthly per customer.
The standard paypal pricing is between %1.9 and %2.9, which is quite a bit.
I looked at authorize.net, and they are charging only $0.10/transac
Once you have inserted the filname into your database, you would get the
filename by querying the database with the Primary Key set on the image in
the table.
Assuming the table was like this.
* imageID | imageName*
* -*
* 1 | /mypath/myim
You can of course avoid the whole issue by using the result_name.IDENTITYCOL
value returned from the cfquery tag (if you are on CF8 or higher).
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
On 29 April 2010 01:51, Che Vilnonis wrote:
>
> When using "set nocou
>YO! 2005 +
>
>USE OUTPUT Duh!
Yes, if needed, OUTPUT is an option as well. (Though IIRC it does not work with
the jTDS driver. At least not the last time I checked.) However, the primary
point was there are safer alternatives to SELECT MAX(ID) ..
You will need to have a different name, and then check that value. Since
your buttons both have the same name, the value for both will be in the form
scope as you have seen.
I always just do a regular button, and change the form action via
Javascript.
Cheers,
Rob
On Wed, Apr 28, 2010 at 8:24
You're getting that result because both buttons have the same name.
On Wed, Apr 28, 2010 at 5:24 PM, John Pullam wrote:
> Can anyone tell me what I'm doing wrong or what I need to do to get a single
> value? My code for the buttons is as follows:
>
>
>
>
> When I CFDump it, FORM.Choose is Ch
> I have seen several examples of using multiple form
> buttons on a single form. The idea is that you can
> get the value of the respective form variable when
> you are posted and then take the appropriate action.
Usually that's triggered by the name of the form button that was clicked,
not the
I'm using cf9 on iis7 and when I put what you've provided into a form,
form.choose is either equal to change, or full, depending on which button
was clicked.
On Wed, Apr 28, 2010 at 6:24 PM, John Pullam wrote:
>
> I have seen several examples of using multiple form buttons on a single
> form. Th
I have seen several examples of using multiple form buttons on a single form.
The idea is that you can get the value of the respective form variable when you
are posted and then take the appropriate action.
But I'm getting odd results. Instead of getting a single value, I get both
values every
On Wed, Apr 28, 2010 at 6:19 PM, wrote:
> Yes, I would agree that is a much simpler and safer alternative. since
> scope_identity() is already specific to your connection you don't have
> to worry about locking and such altogether.
>
> ~Brad
>
> Original Message
> Subject: Re:
Greetings all, from a noob.
I'm trying to figure out how to upload a file and store its name and location
into a database for subsequent retrieval.
I will append the code below, but I will say this: it uploads pictures, and
stores their names into the db. I just don't know how to get CF to get
> Wouldn't READ COMMITTED do the trick? ...will never read data that another
> application has changed and not yet committed
No. Another process could insert a record into the table and commit its
change before you select out the max. The ONLY way for the max() record
to be yours is to preven
Hi all,
I have the following codes in my page.
The style variable holds the custom style. The custom style is quite big and I
am not going to post all the codes here unless I absolutely have to.
The strange thing is, when there are two or more MyScore values, the chart
displays
I'm on 8.0.1 and it appears that CF doesn't override the default SQL
Server isolation level if you don't specify one in your cftransaction
tag.
I ran the following code whilst tracing:
select *
from table
This is what I got:
SET IMPLICIT_TRANSACTIONS ON
select * from test
IF
Yes, I would agree that is a much simpler and safer alternative. since
scope_identity() is already specific to your connection you don't have
to worry about locking and such altogether.
~Brad
Original Message
Subject: Re: SQL Gurus... obtaining the correct Incremental ID
From:
from cfquickdocs for cf8: "If you do not specify a value for the isolation
attribute, ColdFusion uses the default isolation level for the associated
database."
from mssqlcity.com: "READ COMMITTED
This is the default isolation level in SQL Server. When it's used, SQL Server
will use shared lock
On Wed, Apr 28, 2010 at 5:34 PM, nvc 1 wrote:
>
> so is this reliable?
>
>
>
>
>insert into mytable(acolumn) values(1)
>
>
>select max(id) as
>That would ONLY work if you used SET TRANSACTION ISOLATION LEVEL
>SERIALIZABLE or WITH(TABLOCKX HOLDLOCK)
>
>Even with with rowlock, another spid can insert additional records into
>the table and the select max() might return a bogus value.
Aside from being unsafe without the right isolation lev
so is this reliable?
insert into mytable(acolumn) values(1)
select max(id) as maxid from mytable
> That would ONLY work if you used SET TRANSACTION ISOLATION LEVEL
> SERIALIZABLE or WITH(TABLOCKX HOLDLOCK)
This is one of those things I never am completely clear on, but I
believe that the default isolation level for CFTRANSACTION is
serializable in CF 7+.
Dave Watts, CTO, Fig Leaf Software
h
> I am using try/catch around a cfquery, and when I use #cfcatch.SQl# within
> cfcatch, I get an error saying sql is undefined
> in cfcatch. The same happens with #cfcatch.where#. Everything is fine with
> #cfcatch.detail#, #cfcatch.message#.
>
> I have been working with #cfcatch.sql# and #cfcat
Transactions control when data gets committed as well as how long some
locks are held. They do not necessarily keep other processes from
modifying parts of a table you are touching. That's when isolation
levels and locking behavior comes into play.
~Brad
Original Message
Subj
That would ONLY work if you used SET TRANSACTION ISOLATION LEVEL
SERIALIZABLE or WITH(TABLOCKX HOLDLOCK)
Even with with rowlock, another spid can insert additional records into
the table and the select max() might return a bogus value.
~Brad
Original Message
Subject: Re: SQL
The error you're catching might not have those properties. For
example, maybe it's a connection failure error. Or perhaps an
expression error in a CFQUERYPARAM. Those keys will be present when
appropriate, but they're not necessarily available all the time. As
such, you have to do existence ch
Are you on CF8 or higher? Try dumping the cfcatch scope and see what you
get.
Paul Alkema
PaulAlkema.com
-Original Message-
From: fun and learning [mailto:funandlrnn...@gmail.com]
Sent: Wednesday, April 28, 2010 4:26 PM
To: cf-talk
Subject: cfcatch issue
hi all-
I am using try/catch
I am using the cftransaction tags. Honestly, I was not absolutely sure that
I needed to do anything else and that is why I posted my original question.
-Original Message-
From: nvc 1 [mailto:n...@hotmail.co.uk]
Sent: Wednesday, April 28, 2010 4:14 PM
To: cf-talk
Subject: Re: SQL Gurus...
hi all-
I am using try/catch around a cfquery, and when I use #cfcatch.SQl# within
cfcatch, I get an error saying sql is undefined
in cfcatch. The same happens with #cfcatch.where#. Everything is fine with
#cfcatch.detail#, #cfcatch.message#.
I have been working with #cfcatch.sql# and #cfcatc
Hi All -
I am using try/catch around a cfquery. When I am trying to output #cfcatch.sql#
or #cfcatch.where#, I get an error that SQl or where is undefined in cfcatch.
These two used to work for me before. I have no issues with cfcatch.message or
cfcatch.detail.
Can anyone let me know what cou
why can't you do this where mytable has an auto incrementing primary key called
id:
insert into mytable(acolumn)
values(1)
select max(id) as maxid from mytable
~|
Want to reach the ColdFusion community with
Dave/Barney/Casey... I'm using SQL 2005.
I just wanted to cover all bases and was looking for a code snippet. Thanks.
-Original Message-
From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com]
Sent: Wednesday, April 28, 2010 2:13 PM
To: cf-talk
Subject: Re: SQL Gurus... obtaining the
> Transactions, transactions, transactions. Don't write another line of
> SQL until you learn about transactions.
I really just want to second this. There should be a law. With
penalties including jail time for violation. (But perhaps time off
would be granted for understanding indexes.)
Dave Wa
On Wed, Apr 28, 2010 at 1:51 PM, Che Vilnonis wrote:
>
> When using "set nocount on", "select @@identity as xyz" and "set nocount
> off" in a cfquery, how can I be certain that two transactions that occur at
> roughly the same time obtain the proper incremental id from an Identity
> column? Is t
> When using "set nocount on", "select @@identity as xyz" and "set nocount
> off" in a cfquery, how can I be certain that two transactions that occur at
> roughly the same time obtain the proper incremental id from an Identity
> column? Is their a SQl equivalent to CF's cflock tag?
BEGIN TRANSACT
Transactions, transactions, transactions. Don't write another line of
SQL until you learn about transactions.
In this case it doesn't matter because @@identity is bound to the
active connection (and connections are single threaded), but you
should still be transactionally aware.
In addition to
When using "set nocount on", "select @@identity as xyz" and "set nocount
off" in a cfquery, how can I be certain that two transactions that occur at
roughly the same time obtain the proper incremental id from an Identity
column? Is their a SQl equivalent to CF's cflock tag?
Thanks, Che
~~
We've got a new AD server that refuses to cooperate with CFLDAP CF8 or CF9:
("Authentication failed:[LDAP: error code 49 - 80090308: LdapErr:
DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece ]")
However, I've been wrestling with that one long enough for now; I've got to
The packet trace was run on an Amazon EC2 instance. In this case
169.254.169.254 is an internal Amazon IP that the EC2 instance uses to retrieve
its metadata.
The problems in the trace are these entries where "10.162.147.150" is the EC2
instance and "Our Outside IP" is the upload server:
3
Start by using Fiddler to look at the cookie headers being sent to you
from the server and being sent back by your browser. When your session
gets "dropped" does the server send you a new jsessionid cookie, or is
your browser still sending the same one.
Also, confirm your session time outs in th
We have an application that's been working fine for 9+ years now (started on
CF5, now CF8.01). Yesterday we started to receive some comments from users
that they weren't able to log in. I could log into their accounts fine, but
they could not. They were using correct info (a failed login att
You could also convert the date to a new format in a view.
~|
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-
43 matches
Mail list logo
