The same basic issue came up on the SQL list.
http://www.houseoffusion.com/groups/sql/thread.cfm/threadid:898
While the question and result is based on a stored procedure, the same
code can go in a single cfquery statement. The operation is a simple
check for data existence and insert if it does
This might help everyone... Regardless of DBMS...
http://www.forta.com/blog/index.cfm/2007/7/6/ColdFusion-8-Can-Return-Identit
y-Values
-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com]
Sent: Wednesday, April 28, 2010 9:43 PM
To: cf-talk
Subject: Re: SQL Gurus...
Thanx for all the feedback. I'm about 95% sure that I've done all this before
and made it work. And the examples given have been tried too. There must be
something different in my case. This simple use of 2 buttons on a page worked
for me. But when I put it back into the live case it fails, so
I have an application that is using a verity cfsearch tag and then doing a
query of the query on the data to sort it. The problem is large data sets are
timing out in IE and FF before any results come up. It seems there is a
timeout function in IE that if it doesn't get a server response, it
Yes authorize.net is .10 per transaction but you STILL have to pay the
discount rate - 1.9 to 2.9 percent depending on your AVR, fraud prevention
settings etc.
Mark A. Kruger, MCSE, CFG
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
did you try adding
cfsetting requesttimeout=some-large-number-here
at the top of the page?
Azadi
On 29/04/2010 21:43, Brian Bradley wrote:
I have an application that is using a verity cfsearch tag and then doing a
query of the query on the data to sort it. The problem is large data sets
Yes, it doesn't seem to make any difference. It tries for maybe 30 seconds and
then just throws a 'Page cannot be displayed' error. If I try the same query
again, it instantly throws the error, if I use a different term with large
results it tries again for 30 seconds and then throws the
When I change the cfform to form, it works properly, but that will stop my
cfinput and cfselect tags from working.
Is it possible that there is something about the use of cfform that is causing
this?
~|
Want to reach the
Hopefully someone else has run into this issue before and can at least point
me in the right direction. I am trying to consume a .NET web service that
has been protected using the .NET WSE 3.0 service. Here's the error I get
while trying to execute the service:
Cannot perform web service
Thanks for your help, it was a coding error. We fixed it.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
We are running ColdFusion 9 on a Windows 2003 web server a in multi-home
configuration.
We have four ColdFusion services configured on our system: cfusion,
general, pur, and playground. Looking at the Windows Services panel
only the cfusion and playground ColdFusion services are started.
I need to pass 4 arguments and for this purpose, lets use a,b,c,d
var data = {argumentCollection:{?}};
$.ajax({
url: cfc/mycfc.cfc?method=dbupdate,
dataType: 'json',
data: data,
type: 'post',
success:
I find that it's easier, and more self-documenting, to enumerate the
variables in data directly:
$.ajax({
url: cfc/mycfc.cfc?method=dbupdate,
dataType: 'json',
data: {
a: 'andy',
b: 'bobby',
Tony,
I think what your looking for is serialize.
data:$(data).serialize(),
On Thu, Apr 29, 2010 at 12:15 PM, Tony Bentley
cascadefreehee...@gmail.com wrote:
I need to pass 4 arguments and for this purpose, lets use a,b,c,d
var data = {argumentCollection:{?}};
$.ajax({
We are running ColdFusion 9 on a Windows 2003 web server a in multi-home
configuration.
We have four ColdFusion services configured on our system: cfusion,
general, pur, and playground. Looking at the Windows Services panel
only the cfusion and playground ColdFusion services are started.
...and so on. With HTML forms, if two or more form elements have the same
name, the values of all active form elements with that name will be put into
a comma-delimited list and show up in ColdFusion as a single variable with a
list of values, as you experienced. This is great for
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.
Again, that's not correct. You can certainly have submit buttons with
the same name and different values.
There are at
If I use serialize I get nothing passed as a post argument. I am requiring all
args and I get the error as normal, ...required but not passed in.
var dat = {
'OBJ': obj,
'VAL': val,
'ATTR': attr,
So then how would I reference an object with members? a.member, a.friend, etc.
I tried a:a and 'a':a but neither works.
I find that it's easier, and more self-documenting, to enumerate the
variables in data directly:
$.ajax({
url: cfc/mycfc.cfc?method=dbupdate,
On 4/29/2010 9:44 AM, Dave Watts wrote:
The first two are actually running as services. The others are running
as applications. CF/JRun can run as an application or as a service. If
it's running as an application, you won't be able to start the
corresponding service while the application is
When using a regular HTML form, we rely on the browser to act like a regular
browser. Only the 'activated' elements of a form are sent. Form elements with
the same name and are 'activated' will be received by the server as a
comma-delimited list.
In a regular form, only the button that is
one more shot, after a quick cursory look
http://api.jquery.com/jQuery.post/
Check the bottom of the page, I *think* your answer is there..
gotta get back to the grind..
On Thu, Apr 29, 2010 at 12:54 PM, Tony Bentley
cascadefreehee...@gmail.com wrote:
So then how would I reference an object
If dat is already an object literal (as below), why do you need to serialize
it? Doesn't the the ajax() data take care of that for you if passing an object?
If I use serialize I get nothing passed as a post argument. I am
requiring all args and I get the error as normal, ...required but
So then how would I reference an object with members? a.member, a.friend, etc.
I tried a:a and 'a':a but neither works.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of
So then how would I reference an object with members? a.member, a.friend, etc.
I tried a:a and 'a':a but neither works.
data: {
a: { member: value, friend: value },
b: value,
c: 2,
d: true
}
~|
Want to reach the ColdFusion
I think jQuery's serialize() only works on forms.
Since you can't pass a JS object to the server, you'll probably have to
serialize it yourself before you pass it in the ajax call.
Also since you are doing $(dat).serialize(), jQuery is looking for a tag
named dat rather than the variable dat.
Does starting a ColdFusion instance with the ColdFusion Administrator
Enterprise Manager Instance Manager start the service as a application
or a service? If an instance is started as an application does it use
custom JVM.config files that where setup with the jrunsvc command?
I have no
Hi,
I want to limit the total execution time of a stored procedure being called
from Coldfusion using cfstoredproc to 90 seconds. With cfquery there is a
parameter timeout, but there is no equivalent in cfstoredproc. Can anyone
think of an alternative to accomplishing this.
The trick is,
I want to limit the total execution time of a stored procedure being called
from Coldfusion using cfstoredproc to 90 seconds.
With cfquery there is a parameter timeout, but there is no equivalent in
cfstoredproc. Can anyone think of an alternative to
accomplishing this.
The trick is, I
Okay I figured it out:
var data = {
'a': {a:a.cat,b:a.dog,c:a.etc},
'b': b,
'c': c,
'd': d
};
Thanks everyone for the help. It helped me out quite a bit.
no problem :)
On Thu, Apr 29, 2010 at 1:27 PM, Tony Bentley
cascadefreehee...@gmail.com wrote:
Okay I figured it out:
var data = {
'a': {a:a.cat,b:a.dog,c:a.etc},
'b': b,
'c': c,
'd': d
};
Thanks everyone for
Can anyone else retrieve their emails through the website?
What I Did:
Went to www.houseoffusion.com.
clicked on Sign In - email password.
entered won...@gmail.com.
The system returned message Your user information has been emailed to you.
on page
On Thu, Apr 29, 2010 at 1:58 PM, Won Lee won...@gmail.com wrote:
Can anyone else retrieve their emails through the website?
worked for me.
~|
Want to reach the ColdFusion community with something they want? Let them know
Just wanted to also mention CF9's result_name.generatedkey.
Please see comment @ bottom of online help for cfquery:
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7fae.html
Thanks!,
-Aaron Neff
When using set nocount on, select @@identity as xyz and
Hopefully someone else has run into this issue before and can at least point
me in the right direction. I am trying to consume a .NET web service that
has been protected using the .NET WSE 3.0 service. Here's the error I get
while trying to execute the service:
Cannot perform web service
Dave, thanks for the response. I've gone to executing the request using
CFHTTP, creating the soap:Header tag and building it as I go through the WSE
spec and examples. I've gotten to the point that I get unauthorized so
that's where I'm at now. I may have to use CFHTTP to do it, but we'll see.
We are having all kinds of issues with the local scope in converting our
application over to CF9.
I have a few variables in the local scope named Filter_1, Filter_2, etc..
So I am looping through a counter to see if they exist like this (loop
excluded).
cfif
Use array notation: cfif isDefined(local[Filter_#LoopCount#])
On Thu, Apr 29, 2010 at 2:08 PM, Dan Crouch stario...@yahoo.com wrote:
cfif isDefined(local.Filter_#LoopCount#)
~|
Want to reach the ColdFusion community with
This is driving me batty. Every time I try to run this code I get a QoQ syntax
error and I'm not seeing where the error is.
cfloop from=1 to=3 index=i
cfquery name=section dbtype=query
SELECT *
FROM questions
WHERE section = #i#
/cfquery
/cfloop
In case it's not immediately obvious, section is
That didn't work either.
This also works fine, but I still don't get the changes to Local that make it
so different now. Not to mention the code that needs to be changed to get this
to work on CF9.
cfif structKeyExists(local,Filter_#loopcount#)
Use array notation: cfif
Ok...you lost me.
Now, what exactly does the 'a': {a:a.cat,b:a.dog,c}
do? An array for a ???
Rick
-Original Message-
From: Tony Bentley [mailto:cascadefreehee...@gmail.com]
Sent: Thursday, April 29, 2010 1:27 PM
To: cf-talk
Subject: Re: jquery $.ajax - need help with json syntax
Looks like section is reserved in QoQ. Try
cfloop from=1 to=3 index=i
cfquery dbtype=query name=section
SELECT *
FROM questions
WHERE [section] = #i#
/cfquery
/cfloop
From: Kris Sisk ks...@gckschools.com
Sent: Thursday,
It appears section is a reserved word. Your WHERE clause should work if you
use: WHERE [section] = #i#
On Thu, Apr 29, 2010 at 2:25 PM, Kris Sisk ks...@gckschools.com wrote:
cfloop from=1 to=3 index=i
cfquery name=section dbtype=query
SELECT *
FROM questions
WHERE section = #i#
/cfquery
It appears section is a reserved word. Your WHERE clause should work if you
use: WHERE [section] = #i#
On Thu, Apr 29, 2010 at 2:25 PM, Kris Sisk ks...@gckschools.com wrote:
Thanks. I didn't think to check for reserved words. That was the problem.
I don't believe that's a legit method of transmitting data via AJAX.
The API docs say that if you pass an array to a value then it will
concatenate:
a: ['one','two'];
Amounts to ?a=onea=two
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Thursday,
On Thu, Apr 29, 2010 at 2:43 PM, Rick Faircloth wrote:
Now, what exactly does the 'a': {a:a.cat,b:a.dog,c}
do? An array for a ???
No, that would be the equivalent to a ColdFusion struct.
cfscript
a = {
a = a.cat,
b = a.dog,
c =
};
/cfscript
Then what I am reading is that ColdFusion simply doesn't do a correct job of
processing cfform submit buttons when used in a cfwindow. As much as I would
like to get it to run correctly I have opted for making this 2 separate small
forms and then testing the existence of a button that is
Or better put, a json structure inside of a json structure :-)
arguments.a = DeserializeJSON(arguments.a);
This is then referenced as a ColdFusion structure with members
~|
Want to reach the ColdFusion community with
I found more details to the weird problem that I am having.
Before I begin, please go to http://www.monteandjanicechan.com/chart_good.jpg.
This is how I my report to come up. On the x-axis, there will always be three
items as long as at least one of them has values. If an item does not
yeah, true...thanks, Matt!
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: Thursday, April 29, 2010 4:32 PM
To: cf-talk
Subject: Re: jquery $.ajax - need help with json syntax
On Thu, Apr 29, 2010 at 2:43 PM, Rick Faircloth wrote:
Now, what exactly
Hello,
I am having trouble with binding ajax calls to multiple cfselects. They work
perfectly on my local environment, but after uploading the file to our QA
serverand testing it out, I get the error message:
Bind failed, element not found: sltBiz
I've tried to find a solution, and saw some
how exactly are you setting these Filter_xxx vars in local scope?
you are not defining local var as non-empty structure, are you? like var
local = {Filter_1=x, Filter_2=y, ...} ?
Azadi
On 30/04/2010 03:34, Dan Crouch wrote:
That didn't work either.
This also works fine, but I still don't
Dan,
There are a lot of fixes coming for the local scope in the next updater, as
there are some serious problems with the local scope in ColdFusion 9.
On Fri, Apr 30, 2010 at 5:08 AM, Dan Crouch stario...@yahoo.com wrote:
We are having all kinds of issues with the local scope in converting
That's quite an omission from the docs. I'll have to try this on Oracle.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
On 30 April 2010 02:20, Aaron Neff w...@itisdesign.com wrote:
Just wanted to also mention CF9's result_name.generatedkey.
Please see
54 matches
Mail list logo
