Re: SQL Gurus... obtaining the correct Incremental ID
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 not exist. All nice, neat, and transaction controlled by SQL. CREATE PROCEDURE getinsertnewssourceid @newssource varchar(256), @newssourcehref varchar(256) AS Set NOCOUNT ON; Select newssourceid from newssources where newssource = @newssource and href = @newssourcehref; if @@ROWCOUNT = 0 begin Insert into newssources(newssource, href) values(@newssource, @newssourcehref); select newssourceid= scope_identity(); end SET NOCOUNT OFF; GO -- Michael Dinowitz On Wed, Apr 28, 2010 at 4:14 PM, nvc 1 n...@hotmail.co.uk wrote: why can't you do this where mytable has an auto incrementing primary key called id: cftransaction cfquery datasource=#dsn# name=insertQuery insert into mytable(acolumn) values(1) /cfquery cfquery datasource=#dsn# name=getid select max(id) as maxid from mytable /cfquery /cftransaction ~| 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:333224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Gurus... obtaining the correct Incremental ID
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... obtaining the correct Incremental ID 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 ch...@asitv.com 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 their a SQl equivalent to CF's cflock tag? Thanks, Che ~| 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:333225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using two submit buttons to control form action
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 think I am
missing something there.
I have trimmed out irrelevant code in an attempt to get this down to a basic
test but still it fails showing me a string that has both button names (it
didn't do this when I started with a single page). My case includes a cfwindow,
so there are 2 bits of code below ... the page and the window.
The calling page:
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=utf-8 /
titleUntitled Document/title
script language=javascript
function WinGo(WindowName,WindowCode) {
ColdFusion.Window.show(WindowName);
ColdFusion.navigate(WindowCode,WindowName);
}
/script/head
body
input name=Duration type=Button value=Change Duration
onclick=WinGo('DurationWindowEdit','UpdateBookingChangeDuration.cfm?Guest=0')/
cfwindow closable=true draggable=true modal=true
name=DurationWindowEdit resizable=false
title=Change Duration width=500 height=200 x=100 y=100
headerStyle=font-size:13px; font-weight:bold; font-family:Verdana;
background-color: ##003399; color: white; text-align:left;
cfajaximport tags=cfform, cfwindow, cfdiv scriptsrc=/CFIDE/scripts
/cfwindow
!-- InstanceEndEditable --
/body
/html
and the window template:
cfoutput
!--- Postback processing if the form specified a change in partial stay
duration ---
cfif IsDefined(FORM.Choose) AND (FORM.Choose NEQ Full)
cfdump var=#FORM#
cfabort showerror=stop
!--- Postback processing if the form specified a change to a full stay ---
cfelseif IsDefined(FORM.choose) AND (FORM.choose EQ Full)
cfabort showerror=made it
cfelse!--- Initial call, just show the input form ---
cfdump var=#FORM#
cfform
input name=Choose value=Change type=submit /
input name=Choose value=Full type=submit /
/cfform
/cfif
/cfoutput
No matter what I do, it keeps setting FORM.Choose to Change,Full
Any ideas?
~|
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:333226
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
IE timeout on large data sets
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 throws an error. Anyone ever come up with a way to get large result sets to come out without the browser throwing a 'Page cannot be displayed' error. ~| 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:333227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: payment gateway options
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- From: Matthew P. Smith [mailto:m...@smithwebdesign.net] Sent: Thursday, April 29, 2010 12:21 AM To: cf-talk Subject: Re: payment gateway options 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, and the top people balked when told they would have to be guarantors. Maybe the corporate officers don't understand what they are agreeing to. I suppose I could have something in the proposal that explores the issue and makes it less scary, but at this point I would like to provide the information they asked for, one of the requirements being no guarantors. Perhaps if I could find a gateway that will discuss the option of both, I could present the price difference between the two and let them decide. I just need to know who will do it so I can start the dialog. Thank you. On Wed, Apr 28, 2010 at 11:37 PM, Justin Scott jscott-li...@gravityfree.com wrote: 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. Many merchant providers won't service a new business without a guarantor, and those that will are going to be looking hard at the kinds of products they sell to gauge risk and you can expect higher fees and percentages or even a reserve balance requirement as a result. -Justin ~| 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:333228 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IE timeout on large data sets
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 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 throws an error. Anyone ever come up with a way to get large result sets to come out without the browser throwing a 'Page cannot be displayed' error. ~| 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:333229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IE timeout on 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 error. did you try adding cfsetting requesttimeout=some-large-number-here at the top of the page? Azadi ~| 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:333230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using two submit buttons to control form action
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 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:333231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion and .NET Web Services running WSE 3.0
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 invocation XX.
The fault returned when invoking the web service operation is:
AxisFault
faultCode: {
http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd}Security
faultSubcode:
faultString: Security requirements are not satisfied because the security
header is not present in the incoming message.
faultActor:
faultNode: http://XXX.asmx
faultDetail:
{http://xml.apache.org/axis/}stackTrace:Security requirements are not
satisfied because the security header is not present in the incoming
message.
at
org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:221)
at
org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:128)
at
org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown
Source)
at
org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch...
''
I've found some things searching for web services security header and it
looks like I need to use the addSOAPHeader function to my web service call,
but those posts seem to be incomplete and others have said the solutions
presented still throw errors. Thanks,
Phil
~|
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:333232
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IE timeout on large data sets
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: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333233 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Windows ColdFusion|Jrun weirdness.
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. When we tried to start the other two, they fail to start with the following message in the Windows Event logs: The ColdFusion 9 AS General service terminated with service-specific error 2. So I started to search for more information about this. During my research, I thought why not try the ColdFusion Enterprise Manager Instance Manger page in the ColdFusion Administrator. This is where things become a bit wierd. All the instances are running according to the Instance manager. And further testing seems to confirm that this is true. All the administrator pages work, applications running against each instance are working. They seem to all be running. Using the Microsoft|Sys Internals Process Explorer tool, we can see that there are only two jrunsvc processes running, the one for the cfusion instance and the one for the playground instance. But there are four jrun.exe processes running. How is this possible? Looking at the properties of the processes with the Explore tool, we see that the jrun.exe processes that match the jrunsvc have this string: jrun.exe -config jvm-cfusion.config -nohup -ntservice ColdFusion 9 Default CFusion-StartEvent -startByNTService cfusion The two jrun.exe process that do not match a jrunsvc have this string: E:\JRun4\bin\jrun.exe -nohup -start -childVM pur Can anybody provide some insight what all of this means? ~| 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:333234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
jquery $.ajax - need help with json syntax
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: callBack
});
Where data = ??? I know that when using the coldfusion ajax proxy I need to
pass argumentCollection as a parameter. Also, one of the arguments is an object
with different data types. (ie - a.string, a.int, a.boolean, etc)
Obviously the 'data' variable is wrong. Has anyone been able to post data using
this method?
~|
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:333235
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: jquery $.ajax - need help with json syntax
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',
c: 'charlie',
d: 'devon'
},
type: 'post',
success: callBack
});
-Original Message-
From: Tony Bentley [mailto:cascadefreehee...@gmail.com]
Sent: Thursday, April 29, 2010 11:16 AM
To: cf-talk
Subject: jquery $.ajax - need help with json syntax
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: callBack
});
Where data = ??? I know that when using the coldfusion ajax proxy I need to
pass argumentCollection as a parameter. Also, one of the arguments is an
object with different data types. (ie - a.string, a.int, a.boolean, etc)
Obviously the 'data' variable is wrong. Has anyone been able to post data
using this method?
~|
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:333236
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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({
url: cfc/mycfc.cfc?method=dbupdate,
dataType: 'json',
data: data,
type: 'post',
success: callBack
});
Where data = ??? I know that when using the coldfusion ajax proxy I need to
pass argumentCollection as a parameter. Also, one of the arguments is an
object with different data types. (ie - a.string, a.int, a.boolean, etc)
Obviously the 'data' variable is wrong. Has anyone been able to post data
using this method?
~|
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:333237
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Windows ColdFusion|Jrun weirdness.
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. When we tried to start the other two, they fail to start with the following message in the Windows Event logs: The ColdFusion 9 AS General service terminated with service-specific error 2. So I started to search for more information about this. During my research, I thought why not try the ColdFusion Enterprise Manager Instance Manger page in the ColdFusion Administrator. This is where things become a bit wierd. All the instances are running according to the Instance manager. And further testing seems to confirm that this is true. All the administrator pages work, applications running against each instance are working. They seem to all be running. Using the Microsoft|Sys Internals Process Explorer tool, we can see that there are only two jrunsvc processes running, the one for the cfusion instance and the one for the playground instance. But there are four jrun.exe processes running. How is this possible? Looking at the properties of the processes with the Explore tool, we see that the jrun.exe processes that match the jrunsvc have this string: jrun.exe -config jvm-cfusion.config -nohup -ntservice ColdFusion 9 Default CFusion-StartEvent -startByNTService cfusion The two jrun.exe process that do not match a jrunsvc have this string: E:\JRun4\bin\jrun.exe -nohup -start -childVM pur 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 running. Kill the application instances and start them as services, and I'll bet they'll start then. It's fairly common to run J2EE servers as applications in a development environment, as you can more easily stop and start them, interact with them, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, ~| 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:333238 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using two submit buttons to control form action
...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 checkboxes (getting a list of the ones that were checked that share a name), but not so great for submit buttons. Actually, it's great for submit buttons too! Only the one that is clicked will be sent to the action page. I've used this approach for many years, and I prefer it to giving the submit buttons different names. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| 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:333239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using two submit buttons to control form action
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 least five types of form fields that don't pass their values to the action page in all cases: checkboxes, radio buttons, selected options in a select box, images, and submit buttons. I always just do a regular button, and change the form action via Javascript. That's not going to degrade very well if JavaScript is disabled. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:333240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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,
'TIMESTAMP': time
};
return $.ajax({
url: mycfc.cfc?method=dbupdate,
dataType: 'json',
data: $(dat).serialize(),
type: 'post',
success: callBack
});
Serialize() seems to return nothing.
~|
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:333241
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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,
dataType: 'json',
data: {
a: 'andy',
b: 'bobby',
c: 'charlie',
d: 'devon'
},
type: 'post',
success: callBack
});
~|
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:333242
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Windows ColdFusion|Jrun weirdness.
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 running. Kill the application instances and start them as services, and I'll bet they'll start then. Thanks Dave. 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? ~| 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:333243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: Using two submit buttons to control form action
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 pressed is 'activated' so your scenario works correctly. Now enter into the world of cfwindow/cfform. These two tag-groups are extremely powerful, but do cause some changes in the way the form is processed. As you mentioned, when you changed your cfform to a regular form, it worked correctly, but you lost the 'keep in the cfwindow' functionality. Cfform and cfwindow appears to work together to submit forms via AJAX. The script probably compiles the form in the usual manner, any field with an active value are sent to the server. The ajax probably identifies the button that was pressed, by its name, and then gathers the values for that 'named field' In this case, you can achieve your needs in 1 of 2 ways (probably a lot more, but working on little sleep here). 1. make your buttons unique names, and parse on the server side based on the button that was pressed. 2. create an additional hidden field, when one of the buttons is pressed, pass the value of the pressed button to the hidden field using javascript, and have your server check the value of the hidden field, instead of the button. Hope this helps, William -- William E. Seiter On Apr 29, 2010, John Pullam jpul...@mcleansystems.com wrote: 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 think I am missing something there. I have trimmed out irrelevant code in an attempt to get this down to a basic test but still it fails showing me a string that has both button names (it didn't do this when I started with a single page). My case includes a cfwindow, so there are 2 bits of code below ... the page and the window. The calling page: ... ~| 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:333244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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 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,
dataType: 'json',
data: {
a: 'andy',
b: 'bobby',
c: 'charlie',
d: 'devon'
},
type: 'post',
success: callBack
});
~|
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:333245
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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 not
passed in.
var dat = {
'OBJ': obj,
'VAL': val,
'ATTR': attr,
'TIMESTAMP': time
};
return $.ajax({
url: mycfc.cfc?method=dbupdate,
dataType: 'json',
data: $(dat).serialize(),
type: 'post',
success: callBack
});
Serialize() seems to return nothing.
~|
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:333246
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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 Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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 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:333248
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: jquery $.ajax - need help with json syntax
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. You would want $( dat
).serialize(), but I'm not sure that would work anyway, since serialize() is
geared toward form serialization.
-- Josh
-Original Message-
From: Tony Bentley [mailto:cascadefreehee...@gmail.com]
Sent: Thursday, April 29, 2010 9:53 AM
To: cf-talk
Subject: Re: jquery $.ajax - need help with json syntax
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,
'TIMESTAMP': time
};
return $.ajax({
url: mycfc.cfc?method=dbupdate,
dataType: 'json',
data: $(dat).serialize(),
type: 'post',
success: callBack
});
Serialize() seems to return nothing.
~|
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:333249
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Windows ColdFusion|Jrun weirdness.
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 idea how it starts it up in that case, as I don't use that to manage instances once they're created. I suspect that it won't use your custom jvm.config files unless you specify them in the -start command when launching as an application. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:333250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfstoredproc timeout
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 wrap the stored procedure call around a cftry block and create an empty query if the procedure times out. Thanks, Asaf ~| 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:333251 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfstoredproc timeout
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 wrap the stored procedure call around a cftry block and create an empty query if the procedure times out. You can often call stored procedures using CFQUERY. If your stored procedure doesn't return multiple recordsets, that might be a good approach. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsit ~| 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:333252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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.
~|
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:333253
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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 the help. It helped me out quite a bit.
~|
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:333254
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
house of fusion password recovery
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 http://www.houseoffusion.com/signin/mailpass.cfm. I tried this about a month ago and nothing was sent to me. I also searched on won@gmail.com. The system sent me a messaging stating the email was not registered. I also did a search on password on my gmail and so no thread with my HoF password. I also did a search on houseoffusion which yielded no results either. TIA, W ~| 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:333255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: house of fusion password recovery
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 on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Gurus... obtaining the correct Incremental ID
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 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 ~| 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:333257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion and .NET Web Services running WSE 3.0
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 invocation XX.
The fault returned when invoking the web service operation is:
AxisFault
faultCode: {
http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd}Security
faultSubcode:
faultString: Security requirements are not satisfied because the security
header is not present in the incoming message.
...
I've found some things searching for web services security header and it
looks like I need to use the addSOAPHeader function to my web service call,
but those posts seem to be incomplete and others have said the solutions
presented still throw errors.
Well, I haven't worked with WSE 3.0 yet, so I don't know how much help
I can offer. But here goes.
First, you might want to check out the difference between good and bad
requests on the wire, using a tool like Wireshark. You'd need a
working client for this web service, perhaps written in .NET. Your
provider probably has .NET reference code for this. This would allow
you to see the headers in question, and see how they differ.
Second, you might want to search specifically on WSE 3 and Axis, since
Axis is the library that CF uses. You might have to write your web
service client code in Java and manipulate Axis directly, also. I
think that CF comes with Axis 1.2.1, which of course isn't the latest
version.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsi
~|
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:333258
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion and .NET Web Services running WSE 3.0
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. Thanks again, Phil ~| 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:333259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 Local scope issues
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 isDefined(local.Filter_#LoopCount#) The problem is that it never finds them. I can replace the #loopcount# with a number and it will work. I can also put the local scope inside of a different scope, Request for example, and it does work. So the following does work: cfset request.newLocal = local cfif isDefined(request.newlocal.Filter_#loopcount#) Why in the world can it find it just fine in something other than Local? This runs fine in CF8, by the way. ~| 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:333260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Local scope issues
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 something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What's wrong with this QoQ?
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 an int with possible values ranging 1-3. I've double checked that it actually is in the questions query. Other variations I've tried are: WHERE section = '#i#' WHERE section = 1 WHERE section = '1' WHERE section = 'WHY WON'T YOU WORK!!!' (ok, so I didn't try that one). It seems no matter what I put in the where statement it throws a QoQ error. If I leave the where statement off completely it works fine, but that's pretty useless in this situation. What am I doing wrong? ~| 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:333262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Local scope issues
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 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 something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: jquery $.ajax - need help with json syntax
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
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.
~|
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:333264
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: What's wrong with this QoQ?
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, April 29, 2010 3:34 PM To: cf-talk cf-talk@houseoffusion.com Subject: What's wrong with this QoQ? 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 an int with possible values ranging 1-3. I've double checked that it actually is in the questions query. Other variations I've tried are: WHERE section = '#i#' WHERE section = 1 WHERE section = '1' WHERE section = 'WHY WON'T YOU WORK!!!' (ok, so I didn't try that one). It seems no matter what I put in the where statement it throws a QoQ error. If I leave the where statement off completely it works fine, but that's pretty useless in this situation. What am I doing wrong? ~| 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:333265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's wrong with this QoQ?
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 /cfloop ~| 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:333266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's wrong with this QoQ?
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. ~| 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:333267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: jquery $.ajax - need help with json syntax
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, April 29, 2010 2:43 PM
To: cf-talk
Subject: RE: jquery $.ajax - need help with json syntax
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
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.
~|
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:333268
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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
~|
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:333269
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using two submit buttons to control form action
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 unique to each form in the postback processing. That was the cleanest thing to do in my case. ~| 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:333270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery $.ajax - need help with json syntax
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 something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfchart ignores my scalefrom value
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 have any values (i.e. 2010), there would not be a marker in the chart. The problem occurs only when only one item has value. Please see http://www.monteandjanicechan.com/chart_bad.jpg. As you can see, 2008 and 2010 do not have any values; y-axis is now scaled from 0 to 100. I have tried setting one of the items (ex. 2008) a value of 0 or something off the chart; it would scale according to this off-the-chart value and the 2009 value. In short, I have to have at least two items with values between 20 and 100 in order for cfchart to scale from 20 to 100. My question is, how can I correct the issue so that cfchart would ALWAYS scale from 20 to 100? Thanks in advance, Monte 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. cfchart chartheight=450 chartwidth=550 gridlines=9 yaxistitle=Score scalefrom=20 scaleto=100 style=#style# format=png cfchartseries query=variables.chart_query type=scatter seriescolor=##00 itemcolumn=MyItem valuecolumn=MyScore/ /cfchart The strange thing is, when there are two or more MyScore values, the chart displays as expected. However, when there is only 1 MyScore value, the chart would show 0 to 100 in the y-axis. It would still show 9 grid lines but these lines are displayed from 0 to 100 instead of from 20 to 100. Does anyone know why this is happening? I am running CF 9 on WinXP on my local box. Thanks in advance, Monte ~| 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:333272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: jquery $.ajax - need help with json syntax
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 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
~|
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:333273
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
multiple cfselect binds - works locally, not on QA server
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 related issues like IE vs Firefox,
but I still get the error in IE, and my cfform is not within a table (another
solution I found).
Any thoughts would be greatly appreciated. Here is my code, the sltBiz is used
to populate sltTemplate (i.e. Businesses have Templates):
cfform id=frmTemp
cfselect name=sltBiz
id=sltBiz
class=selectfield
bind=cfc:cbuilder.getBiz()
bindonload=true
/cfselect
cfselect name=sltTemplate
id=sltTemplate
class=selectfield
bind=cfc:cbuilder.getTemps({sltBiz.value})
/cfselect
~|
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:333274
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Local scope issues
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 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 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 something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333275
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Local scope issues
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 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 isDefined(local.Filter_#LoopCount#) The problem is that it never finds them. I can replace the #loopcount# with a number and it will work. I can also put the local scope inside of a different scope, Request for example, and it does work. So the following does work: cfset request.newLocal = local cfif isDefined(request.newlocal.Filter_#loopcount#) Why in the world can it find it just fine in something other than Local? This runs fine in CF8, by the way. ~| 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:333276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Gurus... obtaining the correct Incremental ID
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 comment @ bottom of online help for cfquery: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7fae.html ~| 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:333277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
