Re: OT (maybe): Display additional info from a Select before Form is Submitted - little help needed
Almost working correctly. When the page first loads, I get an alert: The GROUPS_ID argument passed to the get is not of type numeric If I dismiss the alert, then the page functions normally after that and the correct description shows up depending on what you select in sendGROUP. Ideas? Here's what I've got: My CFC file: !--- Get group description --- cffunction name=getGPDesc access=remote returnType=string cfargument name=groups_id type=numeric required=true !--- Define variables --- cfset var data= cfset var result= !--- Get data --- cfquery name=data datasource=nmdata SELECT mlCOMMENTS FROM nl_groupLIST WHERE groups_id = #ARGUMENTS.groups_id# /cfquery !--- Got it? --- cfif data.RecordCount IS 1 cfset result=data.mlCOMMENTS /cfif !--- And return it --- cfreturn result /cffunction /cfcomponent ... and on the page n question: cfselect name=sendGROUP query=groups display=mgroup value=groups_id size=10 / !--- DIV for description --- cfdiv bind=cfc:art.getGPDesc({sendGROUP}) style=background-color:##F8F8F8; height:100; width:200; / ~| 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:322493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
dynamically create array using cfloop?
hey guys i have an array like below to render a 2nd select box based on first select box it continues 0-20 var sidewalls_Quantity#rsTS8.specs_partnum#=new Array() sidewalls_Quantity#rsTS8.specs_partnum#[0]=[0|0] sidewalls_Quantity#rsTS8.specs_partnum#[1]=[0|0, 1|1] sidewalls_Quantity#rsTS8.specs_partnum#[2]=[0|0, 1|1, 2|2 ] sidewalls_Quantity#rsTS8.specs_partnum#[3]=[0|0, 1|1, 2|2, 3|3] sidewalls_Quantity#rsTS8.specs_partnum#[4]=[0|0, 1|1, 2|2, 3|3 , 4|4] i would like to just use cfloop to populate it and make maller code.. cfloop index=i from=0 to=20 sidewalls_Quantity[#i#]=[#i#|#i#]br / /cfloop outputs sidewalls_Quantity[0]=[0|0] sidewalls_Quantity[1]=[1|1] sidewalls_Quantity[2]=[2|2] sidewalls_Quantity[3]=[3|3] sidewalls_Quantity[4]=[4|4] sidewalls_Quantity[5]=[5|5] sidewalls_Quantity[6]=[6|6] which is close. but i think i need another loop to do the 0|0, 1|1, 2|2, 3|3 stuff.. any ideas.. thanks a ton! -paul ~| 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:322494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamically create array using cfloop?
cfloop index=i from=0 to=20 sidewalls_Quantity[#i#]=[cfloop index=x from=0 to=#i##x#|#x#, /cfloop]br / /cfloop is close. but put the comma at end sidewalls_Quantity[0]=[0|0, ] sidewalls_Quantity[1]=[0|0, 1|1, ] sidewalls_Quantity[2]=[0|0, 1|1, 2|2, ] sidewalls_Quantity[3]=[0|0, 1|1, 2|2, 3|3, ] sidewalls_Quantity[4]=[0|0, 1|1, 2|2, 3|3, 4|4, ] sidewalls_Quantity[5]=[0|0, 1|1, 2|2, 3|3, 4|4, 5|5 ~| 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:322495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dynamically create array using cfloop?
Well as you loop on the 0, 1, 2, spitting out 0|0, 1|1, 2|2, etc... Why not, before the loop, create a variable, and do a ListAppend on it each time? like cfset listVar = '' cfloop from=0 to=20 step=i cfset sidewalls_Quantity[i] = new Array() cfset thisValue = #i#|#i# cfset listVar = ListAppend(listVar, thisValue) cfloop list=#listVar# index=lv cfset sidewalls_Quantity[i] = ArrayAppend(sidewalls_Quantity[i], lv) /cfloop /cfloop Just slapped that together so it may not be 100%, but you get the idea - as you step from 0-20, keep adding your pipe-separated pairs to a list, and loop over that list each interaction and build up your array. Or you might be able to just dump the each-iteration-added-to listVar right into your new array position each loop. *shrug* ~| 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:322496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically create array using cfloop?
cfloop index=i from=0 to=20 cfset innerVal = '' cfloop index=j from=0 to=#i# cfset innerVal = innerVal '#j#|#j#' cfif j NEQ i cfset innerVal = innerVal , /cfif /cfloop sidewalls_Quantity[#i#]=[#innerVal#]br / /cfloop Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: Thursday, May 14, 2009 8:47 AM To: cf-talk Subject: dynamically create array using cfloop? hey guys i have an array like below to render a 2nd select box based on first select box it continues 0-20 var sidewalls_Quantity#rsTS8.specs_partnum#=new Array() sidewalls_Quantity#rsTS8.specs_partnum#[0]=[0|0] sidewalls_Quantity#rsTS8.specs_partnum#[1]=[0|0, 1|1] sidewalls_Quantity#rsTS8.specs_partnum#[2]=[0|0, 1|1, 2|2 ] sidewalls_Quantity#rsTS8.specs_partnum#[3]=[0|0, 1|1, 2|2, 3|3] sidewalls_Quantity#rsTS8.specs_partnum#[4]=[0|0, 1|1, 2|2, 3|3 , 4|4] i would like to just use cfloop to populate it and make maller code.. cfloop index=i from=0 to=20 sidewalls_Quantity[#i#]=[#i#|#i#]br / /cfloop outputs sidewalls_Quantity[0]=[0|0] sidewalls_Quantity[1]=[1|1] sidewalls_Quantity[2]=[2|2] sidewalls_Quantity[3]=[3|3] sidewalls_Quantity[4]=[4|4] sidewalls_Quantity[5]=[5|5] sidewalls_Quantity[6]=[6|6] which is close. but i think i need another loop to do the 0|0, 1|1, 2|2, 3|3 stuff.. any ideas.. thanks a ton! -paul ~| 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:322497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dynamically create array using cfloop?
Jake thats pretty slick! Scott i appreciate the help. On Thu, May 14, 2009 at 10:00 AM, Jake Churchill j...@cfwebtools.com wrote: cfloop index=i from=0 to=20 cfset innerVal = '' cfloop index=j from=0 to=#i# cfset innerVal = innerVal '#j#|#j#' cfif j NEQ i cfset innerVal = innerVal , /cfif /cfloop sidewalls_Quantity[#i#]=[#innerVal#]br / /cfloop Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: Thursday, May 14, 2009 8:47 AM To: cf-talk Subject: dynamically create array using cfloop? hey guys i have an array like below to render a 2nd select box based on first select box it continues 0-20 var sidewalls_Quantity#rsTS8.specs_partnum#=new Array() sidewalls_Quantity#rsTS8.specs_partnum#[0]=[0|0] sidewalls_Quantity#rsTS8.specs_partnum#[1]=[0|0, 1|1] sidewalls_Quantity#rsTS8.specs_partnum#[2]=[0|0, 1|1, 2|2 ] sidewalls_Quantity#rsTS8.specs_partnum#[3]=[0|0, 1|1, 2|2, 3|3] sidewalls_Quantity#rsTS8.specs_partnum#[4]=[0|0, 1|1, 2|2, 3|3 , 4|4] i would like to just use cfloop to populate it and make maller code.. cfloop index=i from=0 to=20 sidewalls_Quantity[#i#]=[#i#|#i#]br / /cfloop outputs sidewalls_Quantity[0]=[0|0] sidewalls_Quantity[1]=[1|1] sidewalls_Quantity[2]=[2|2] sidewalls_Quantity[3]=[3|3] sidewalls_Quantity[4]=[4|4] sidewalls_Quantity[5]=[5|5] sidewalls_Quantity[6]=[6|6] which is close. but i think i need another loop to do the 0|0, 1|1, 2|2, 3|3 stuff.. any ideas.. thanks a ton! -paul ~| 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:322498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamically create array using cfloop?
also.. i cant put cf inside js? or can i? the loop works fine out side script type=text/javascript/script ~| 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:322499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamically create array using cfloop?
You can put CF inside JS. You just have to look at the rendered source to make sure it's correct. It usually takes me a couple tries but it always works in the end. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: Thursday, May 14, 2009 9:10 AM To: cf-talk Subject: Re: dynamically create array using cfloop? also.. i cant put cf inside js? or can i? the loop works fine out side script type=text/javascript/script ~| 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:322500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamically create array using cfloop?
Paul Ihrig wrote: also.. i cant put cf inside js? or can i? You can use CFML to Build JS quite easily, but they don't run at the same time. 1st CF runs and builds the JavaScript 2nd The Code is sent from the ColdFusion server to the web server 3rd The Code is sent from the Web Server to the Client Browser 4th The Browser runs the JavaScript. So as you can see there is not back and forth interaction between the JavaScript and ColdFusion. ~| 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:322501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF to Salesforce.com API?
I'm guessing that the API is technology neutral (Java, PHP, CF, etc.) since it accepts WSDL/SOAP requests. Is this accurate? I'm also weighing a build or buy decision with regard to a data connector between Salesforce and our ERP system (Pervasive SQL database). If I have a working knowledge of SSIS, do I really need to spend the money for a connector? -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: Wednesday, May 13, 2009 4:59 PM To: cf-talk Subject: Re: CF to Salesforce.com API? Working on right now. What you need to know? On Wed, May 13, 2009 at 1:04 PM, Billy Cox bi...@oldworldspices.com wrote: We're considering putting our old Visual Foxpro-based CRM to sleep and going with Salesforce.com. Does anyone have any experience with Salesforce.com integration and/or using their web services API with ColdFusion? Billy Cox Old World Spices bi...@oldworldspices.com ~| 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:322502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamically create array using cfloop?
You can put CF inside JS. That one of the places where CFML really shines. I remember (a painful memory) having to work on a site where the original author was generating JS using PHP and concatenated the JS with PHP. Mixing two C style languages is enough to make your eyes spin in different directions. G! On Thu, May 14, 2009 at 10:17 AM, Jake Churchill j...@cfwebtools.comwrote: You can put CF inside JS. You just have to look at the rendered source to make sure it's correct. It usually takes me a couple tries but it always works in the end. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: Thursday, May 14, 2009 9:10 AM To: cf-talk Subject: Re: dynamically create array using cfloop? also.. i cant put cf inside js? or can i? the loop works fine out side script type=text/javascript/script ~| 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:322503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Permission Issues: Uploading Files
Hi All, We're running an application on a SunOS box that uses CFFILE to allow users to upload image files: nameconflict=makeunique and mode=777 (yes, I know. Bad, bad, bad using 777). When the file gets uploaded, however, the permissions end up being 600! This makes it impossible for Apache to serve up those files. How can we make sure uploaded files get the write permissions? ~| 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:322504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfform
I have a quick question. I have a required radio button in the form with the cfoutput group up with the query: cfform cfoutput Query=Qry1 group=EmpName cfinput type=radio name=Prod1 value=#ID# required=true message=You need to select option/#EmpName# /cfoutput cfinput type=submit name=btn_Previous value=Previousnbsp;nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;nbsp;cfinput type=submit name=btn_Submit value=Continue/td/tr /cfform cfif Isdefined(form.btn_Submit) cflocation url =addinfo.cfm addtoken=no /cfif cfif isdefined(form.btn_Previous) cflocation url=index.cfm /cfif I have the Previous button on that page and the continue button. If I click on the previous button it shows the alert message to select option. Is there anyways we can do that if we hit the previous button , it should not show alert even if we dont select the option and if we hit the continue button it should show an alert if option not selected. Thanks, Priya ~| 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:322505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfform
Your previous button is a submit button - it's submitting the form so running the validation code. You need to use a button instead. -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 May 2009 17:02 To: cf-talk Subject: cfform I have a quick question. I have a required radio button in the form with the cfoutput group up with the query: cfform cfoutput Query=Qry1 group=EmpName cfinput type=radio name=Prod1 value=#ID# required=true message=You need to select option/#EmpName# /cfoutput cfinput type=submit name=btn_Previous value=Previousnbsp;nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;nbsp;cfinput type=submit name=btn_Submit value=Continue/td/tr /cfform cfif Isdefined(form.btn_Submit) cflocation url =addinfo.cfm addtoken=no /cfif cfif isdefined(form.btn_Previous) cflocation url=index.cfm /cfif I have the Previous button on that page and the continue button. If I click on the previous button it shows the alert message to select option. Is there anyways we can do that if we hit the previous button , it should not show alert even if we dont select the option and if we hit the continue button it should show an alert if option not selected. Thanks, Priya ~| 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:322506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IE Cflogin
I have an application file that requires users to login prior to accessing any of the pages in the directory. The first time that a user uses IE, it works great and they have to log in. However, it doesn't seem to log them out when they close the browser. The next time they open the browser, and go to that page, they do not need to log in again. I figured that a session would end when the browser closes. It works fine in FireFox and Chrome. Do I need to program that somehow? Thanks in advance. CODE: cfapplication name=Orders sessionmanagement=Yes loginStorage=Session cflogin cfif NOT IsDefined(cflogin) cfinclude template=dologin.cfm cfabort cfelse cfif cflogin.name IS OR cflogin.password IS cfoutput H2You must enter text in both the User Name and Password fields/H2 /cfoutput cfinclude template=dologin.cfm cfabort cfelse cfquery name=loginQuery dataSource=MailSystem SELECT * FROM loginTable INNER JOIN IndividualInformation on loginTable.counter=IndividualInformation.counter WHERE IndividualInformation.email = '#cflogin.name#' AND InternetPasswordHash = '#Hash(cflogin.password)#' /cfquery cfif loginQuery.Role NEQ cfloginuser name=#cflogin.name# Password = #cflogin.password# roles=#loginQuery.Role# cfelse cfoutput H2Your login information is not valid.br Please Try again/H2 /cfoutput cfinclude template=dologin.cfm cfabort /cfif /cfif /cfif /cflogin ~| 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:322507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE Cflogin
The session will end when the user closes the browser if you've enabled J2EE sessions in the CF admin or if you've written code to convert the cookies to be session based. Are either of those things the case? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/5/15 Brian Bradley bbrad...@plrb.org: I have an application file that requires users to login prior to accessing any of the pages in the directory. The first time that a user uses IE, it works great and they have to log in. However, it doesn't seem to log them out when they close the browser. The next time they open the browser, and go to that page, they do not need to log in again. I figured that a session would end when the browser closes. It works fine in FireFox and Chrome. Do I need to program that somehow? Thanks in ad ~| 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:322508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE Cflogin
I have Use J2EE Session Variables checked, as well as Enable Application Variables and Enable Session Variables. I don't have any code dealing with cookies at this point. Perhaps I have to manipulate the default and maximum timeout for the Application variables in the administrator? BTW, I am running MX 6.1. Thanks for your 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:322509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfform
Thanks for your response but if I use button it is not going to the previous page. Priya. Your previous button is a submit button - it's submitting the form so running the validation code. You need to use a button instead. I have a quick question. I have a required radio button in the form with the cfoutput group up with the query: cfform cfoutput Query=Qry1 group=EmpName cfinput type=radio name=Prod1 value=#ID# required=true message=You need to select option/#EmpName# /cfoutput cfinput type=submit name=btn_Previous value=Previousnbsp;nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;nbsp;cfinput type=submit name=btn_Submit value=Continue/td/tr /cfform cfif Isdefined(form.btn_Submit) cflocation url =addinfo.cfm addtoken=no /cfif cfif isdefined(form.btn_Previous) cflocation url=index.cfm /cfif I have the Previous button on that page and the continue button. If I click on the previous button it shows the alert message to select option. Is there anyways we can do that if we hit the previous button , it should not show alert even if we dont select the option and if we hit the continue button it should show an alert if option not selected. Thanks, Priya ~| 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:322510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamically create array using cfloop?
thanks guys i had a BR that wasnt needed. ~| 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:322511 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IE Cflogin
It looks like IE is doing something strange, like storing login fields. Which version of IE is involved? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/5/15 Brian Bradley bbrad...@plrb.org: I have Use J2EE Session Variables checked, as well as Enable Application Variables and Enable Session Variables. I don't have any code dealing with cookies at this point. Perhaps I have to manipulate the default and maximum timeout for the Application variables in the administrator? BTW, I am running MX 6.1. Thanks for your h ~| 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:322512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: my cfqueryparam grievance
Hello folks: Thanks to all who replied--I really appreciate your thoughts and insights on the issue. Here is the latest development on my fascinating CFQueryparam issue: 1. I have gone through the error messages on this issue, and none of them has bad data coming in. Which is to say, all the incoming data for cookie.theID conforms to somehting like 123456, 6-digit integers. So, in all instances, something happened with the cfqueryparam tag, where incoming values all got somehow translated into 521636a. 2. The incoming data is supposed to be for an ID column, which is of VARCHAR data type in the database, and it auto increments. It is not designed to be hexadecimal, so I can't imagine the translated value standing for any hexadecimal either--well, at least there is no instruction on either the CF or MSSQL side which tells it to convert into hexadecimal. Adding to the confusion of course, is that this ID column is sometimes VARCHAR and sometimes INT in different tables--probably not the best practice. We have an archaic system (iMIS) and it has this ID as VARCHAR, but elsewhere, in built-in-house systems sometimes it is INT. Regarding Brad's comment: I am intrigued by the theory of corrupted cached SQL statement... What exactly does that mean? How does corrupted statements get cached? And if it was corrupted, how/why did it run before with no issues? Did something happen that made the corrupted cache stop working? Thanks guys for your thoughts! On Tue, May 12, 2009 at 5:23 PM, Jason Fisher ja...@wanax.com wrote: Ummm, not sure why your cookie.theID would shift, but I would say absolutely that the CF_SQL_TYPE is designed to match the database column data type, not the incoming variable parameter. The entire point of the CF_SQL_TYPE is to let the JDBC driver handle the data pass-through for you in a way that is safe and that the database server understands, regardless of what RDBMS you are using. So, I would agree that there are 2 separate issues: what's gone on with your data, independent of the CFQUERY and then ensuring that all CFQUERYPARAMs are designed to match your database rather than your application data, which in this case just happens to be integer. ~| 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:322513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfform
Can you not assign an action to the button using js? function previousPage() { window.location.href = index.cfm; } input type=button value=Previous onClick=previousPage() -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 May 2009 17:45 To: cf-talk Subject: Re: cfform Thanks for your response but if I use button it is not going to the previous page. Priya. Your previous button is a submit button - it's submitting the form so running the validation code. You need to use a button instead. I have a quick question. I have a required radio button in the form with the cfoutput group up with the query: cfform cfoutput Query=Qry1 group=EmpName cfinput type=radio name=Prod1 value=#ID# required=true message=You need to select option/#EmpName# /cfoutput cfinput type=submit name=btn_Previous value=Previousnbsp;nbsp;nbsp;nbsp; nbsp;nbsp;nbsp;nbsp;cfinput type=submit name=btn_Submit value=Continue/td/tr /cfform cfif Isdefined(form.btn_Submit) cflocation url =addinfo.cfm addtoken=no /cfif cfif isdefined(form.btn_Previous) cflocation url=index.cfm /cfif I have the Previous button on that page and the continue button. If I click on the previous button it shows the alert message to select option. Is there anyways we can do that if we hit the previous button , it should not show alert even if we dont select the option and if we hit the continue button it should show an alert if option not selected. Thanks, Priya ~| 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:322514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfform
sorry.. I was thinking something else... I got it by using Button... Thanks, Priya Thanks for your response but if I use button it is not going to the previous page. Priya. Priya ~| 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:322515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT (maybe): Display additional info from a Select before Form is Submitted - little help needed
Try setting the bindOnLoad to false cfdiv bindOnLoad=false. On Thu, May 14, 2009 at 8:06 AM, Les Mizzell lesm...@bellsouth.net wrote: Almost working correctly. When the page first loads, I get an alert: The GROUPS_ID argument passed to the get is not of type numeric If I dismiss the alert, then the page functions normally after that and the correct description shows up depending on what you select in sendGROUP. Ideas? Here's what I've got: My CFC file: !--- Get group description --- cffunction name=getGPDesc access=remote returnType=string cfargument name=groups_id type=numeric required=true !--- Define variables --- cfset var data= cfset var result= !--- Get data --- cfquery name=data datasource=nmdata SELECT mlCOMMENTS FROM nl_groupLIST WHERE groups_id = #ARGUMENTS.groups_id# /cfquery !--- Got it? --- cfif data.RecordCount IS 1 cfset result=data.mlCOMMENTS /cfif !--- And return it --- cfreturn result /cffunction /cfcomponent ... and on the page n question: cfselect name=sendGROUP query=groups display=mgroup value=groups_id size=10 / !--- DIV for description --- cfdiv bind=cfc:art.getGPDesc({sendGROUP}) style=background-color:##F8F8F8; height:100; width:200; / ~| 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:322516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: my cfqueryparam grievance
2. The incoming data is supposed to be for an ID column, which is of VARCHAR data type in the database, and it auto increments. It is not designed to be hexadecimal, so I can't imagine the translated value standing for any hexadecimal either--well, at least there is no instruction on either the CF or MSSQL side which tells it to convert into hexadecimal. Adding to the confusion of course, is that this ID column is sometimes VARCHAR and sometimes INT in different tables--probably not the best practice. We have an archaic system (iMIS) and it has this ID as VARCHAR, but elsewhere, in built-in-house systems sometimes it is INT. What does it mean for a VARCHAR to autoincrement? Regarding Brad's comment: I am intrigued by the theory of corrupted cached SQL statement... What exactly does that mean? How does corrupted statements get cached? And if it was corrupted, how/why did it run before with no issues? Did something happen that made the corrupted cache stop working? You run a valid SQL command, you change the schema in such a way that it would no longer be valid, and you attempt to rerun the same command using a cached execution plan. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informati ~| 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:322517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF to Salesforce.com API?
I'm guessing that the API is technology neutral (Java, PHP, CF, etc.) since it accepts WSDL/SOAP requests. Is this accurate? Yes, although CF's default web services interface is a little too simple to do everything you need directly. That said, you can do it all from CF; I'm giving a presentation on how to do this in about five minutes here at cf.Objective. The URL for the presentation is here: http://figleaf.mmalliance.acrobat.com/cfobjective2009/cfsalesforce/ Code samples will follow soon. Basically, the big problems are: - you have to use SOAP headers (not really a big problem), - you have to dynamically change the endpoint (this isn't a big problem once you figure out how to do it, - you have to use the Java stub classes to create new records, etc I'm also weighing a build or buy decision with regard to a data connector between Salesforce and our ERP system (Pervasive SQL database). If I have a working knowledge of SSIS, do I really need to spend the money for a connector? Probably not, but it's a question of how much time you want to sink into it as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:322518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE Cflogin
IE7 IE8 are both doing 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:322519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: my cfqueryparam grievance
LOL I am glad that you asked about the VARCHAR auto increment, Dave. It is an interesting story (everybody grab some hot cocoa, please): Well, (most) iMIS tables have a VARCHAR identity field which need to auto-increment like an integer. To achieve that, there is table which stores the next ID value for these tables. So, whenever an INSERT is done on an iMIS table, this special table with the next ID values have to be updated to reflect what the next value is for the table which just got the INSERT statement. To make life more interesting, some iMIS tables have triggers on them so that the special table gets automatically updated, but others don't. Make sense? Probably not. But well, that is how it is done. As for the cached SQL statement, I think I understand what you mean now. So it is basically like changing the accepted parameters of a CF function--it used to take INT1 and INT2, now it wants VARCHAR1 and INT2, and that CF function happens to be in APPLICATION scope or other persistent scope. So things break until you can refresh the function. Hmm... but I still can't imagine how it happened to my code since our table schema has not changed. Well, I guess my lessons here are: 1) Don't try to be cute with CFqueryparam, always use the same data type as the receiving table column; 2) Make sure the column which holds the same data has the same data type across tables. But still, it is interesting to ponder whatever happened to my data, and why, of all things, everything got to be 521636a. Just another thing to think about on the metro. On Thu, May 14, 2009 at 2:39 PM, Dave Watts dwa...@figleaf.com wrote: 2. The incoming data is supposed to be for an ID column, which is of VARCHAR data type in the database, and it auto increments. It is not designed to be hexadecimal, so I can't imagine the translated value standing for any hexadecimal either--well, at least there is no instruction on either the CF or MSSQL side which tells it to convert into hexadecimal. Adding to the confusion of course, is that this ID column is sometimes VARCHAR and sometimes INT in different tables--probably not the best practice. We have an archaic system (iMIS) and it has this ID as VARCHAR, but elsewhere, in built-in-house systems sometimes it is INT. What does it mean for a VARCHAR to autoincrement? Regarding Brad's comment: I am intrigued by the theory of corrupted cached SQL statement... What exactly does that mean? How does corrupted statements get cached? And if it was corrupted, how/why did it run before with no issues? Did something happen that made the corrupted cache stop working? You run a valid SQL command, you change the schema in such a way that it would no longer be valid, and you attempt to rerun the same command using a cached execution plan. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more informati ~| 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:322520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: my cfqueryparam grievance
The user changed it maybe? Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:30 To: cf-talk Subject: Re: my cfqueryparam grievance But still, it is interesting to ponder whatever happened to my data, and why, of all things, everything got to be 521636a. Just another thing to think about on the metro. ~| 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:322521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: my cfqueryparam grievance
I wish--but the value is a ID value passed back in a query recordset and there is no way how users can manually pass it in. On Thu, May 14, 2009 at 3:39 PM, Adrian Lynch cont...@adrianlynch.co.ukwrote: The user changed it maybe? Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:30 To: cf-talk Subject: Re: my cfqueryparam grievance But still, it is interesting to ponder whatever happened to my data, and why, of all things, everything got to be 521636a. Just another thing to think about on the metro. ~| 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:322522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE Cflogin
James Holmes wrote: The session will end when the user closes the browser if you've enabled J2EE sessions in the CF admin or if you've written code to convert the cookies to be session based. Are either of those things the case? The session *NEVER* ends when the browser closes. If one is using J2EE or one has otherwise configured the cookies used to identify a client to a session state, the cookies should be expied when the browser closes. Thus the client will have to start a new session and get new cookies the next time it connect. But the old session has not ended. It is sitting their, waiting until the session timeout expires, for any new request that might return valid cookies to connect to it. This is an important distinction to understand when dealing with this type of 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:322523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Flex DataGrid with CF dataprovider and Undo/Redo
Hi Flex is new to me but I'm having fun setting up a datagrid with a CF dataprovider. It works well so far and I have the CRUD functionality I need, however if possible I'd like to add a system of undo/redo on the grid. I was thinking of maybe intercepting each query in the cfc and serialising a WDDX packet recording the pre-edit state of a cell and storing it in a database table so that I can rewind each change. Or is there some built in Flex functionality I don't know about? Any ideas? Thanks Brian ~| 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:322524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IE Cflogin
Ian Skinner wrote: A message with large sections of entire sentances missing... The session *NEVER* ends when the browser closes. The browser does not send some message to all the web sites it has visited telling them it is closing down. If one is using J2EE jsesssionid cookies or one has otherwise configured the cfid and cftoken cookies to be per-session cookies, then the cookies should expire when the browser closes. Thus the client would have to start a new session and get new cookies the next time it makes a request from the ColdFusion server. But the old session has not ended when this happens. It is sitting there, waiting until the session timeout expires, for any new request that might return valid cookies to connect to it. This is an important distinction to understand when dealing with this type of 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:322525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: my cfqueryparam grievance
I thought you said it was a cookie value? -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:43 To: cf-talk Subject: Re: my cfqueryparam grievance I wish--but the value is a ID value passed back in a query recordset and there is no way how users can manually pass it in. On Thu, May 14, 2009 at 3:39 PM, Adrian Lynch cont...@adrianlynch.co.ukwrote: The user changed it maybe? Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:30 To: cf-talk Subject: Re: my cfqueryparam grievance But still, it is interesting to ponder whatever happened to my data, and why, of all things, everything got to be 521636a. Just another thing to think about on the metro. ~| 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:322526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
[sot] Postgres?
Hey all, I am venturing into using postgres for the first time. I have read that you can setup postgres to accept network connections, but I can't find a sample on the internet on how to do it. Currently only accepting localhost. Any ideas? Thanks, William ~| 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:322527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [sot] Postgres?
read my blog post on setting up and upgrading PostgreSQL. http://www.trunkful.com Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On May 14, 2009, at 3:01 PM, William Seiter wrote: Hey all, I am venturing into using postgres for the first time. I have read that you can setup postgres to accept network connections, but I can't find a sample on the internet on how to do it. Currently only accepting localhost. Any ideas? Thanks, William ~| 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:322528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flex DataGrid with CF dataprovider and Undo/Redo
Flex is new to me but I'm having fun setting up a datagrid with a CF dataprovider. It works well so far and I have the CRUD functionality I need, however if possible I'd like to add a system of undo/redo on the grid. I was thinking of maybe intercepting each query in the cfc and serialising a WDDX packet recording the pre-edit state of a cell and storing it in a database table so that I can rewind each change. Or is there some built in Flex functionality I don't know about? There is, sort of - LCDS, which is bundled with CF as a single-processor license. Using the DataManagement service, you can control database commits and cancel them, and each record is sent to the server as a ChangeObject, which contains old and new values. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:322529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE Cflogin
I am confused though. Why is IE ignoring the isDefined? I am saying isDefined(login) but if that variable hasn't been set why is it ignoring it. I must be missing something... ~| 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:322530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: [sot] Postgres?
On Thu, May 14, 2009 at 10:01 PM, William Seiter wrote: I am venturing into using postgres for the first time. I have read that you can setup postgres to accept network connections, but I can't find a sample on the internet on how to do it. Currently only accepting localhost. Any ideas? http://wiki.postgresql.org/wiki/FAQ#How_do_I_control_connections_from_other_hosts.3F http://www.postgresql.org/docs/8.3/static/runtime-config-connection.html Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:322531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: my cfqueryparam grievance
Ah yes! You are right--that ID value, after being returned in the query recordset, does get set in cookie scope, and that is where my cfqueryparam tag gets it from, in cookie scope. So, yeah, it is possible that users could have manipulated that cookie value... But then, with so many users (i must have had a couple dozen error messages at least, and they are from different legitimate users) all generating the same error message, it seems unlikely that they all changed their cookie to the same value. On Thu, May 14, 2009 at 4:01 PM, Adrian Lynch cont...@adrianlynch.co.ukwrote: I thought you said it was a cookie value? -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:43 To: cf-talk Subject: Re: my cfqueryparam grievance I wish--but the value is a ID value passed back in a query recordset and there is no way how users can manually pass it in. On Thu, May 14, 2009 at 3:39 PM, Adrian Lynch cont...@adrianlynch.co.ukwrote: The user changed it maybe? Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 20:30 To: cf-talk Subject: Re: my cfqueryparam grievance But still, it is interesting to ponder whatever happened to my data, and why, of all things, everything got to be 521636a. Just another thing to think about on the metro. ~| 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:322532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: my cfqueryparam grievance
Maybe it's happening in code. Do a search for the variable and make sure you don't find something like: cfset COOKIE.something = a COOKIE.something Stranger things have happened :OD Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 14 May 2009 21:33 To: cf-talk Subject: Re: my cfqueryparam grievance Ah yes! You are right--that ID value, after being returned in the query recordset, does get set in cookie scope, and that is where my cfqueryparam tag gets it from, in cookie scope. So, yeah, it is possible that users could have manipulated that cookie value... But then, with so many users (i must have had a couple dozen error messages at least, and they are from different legitimate users) all generating the same error message, it seems unlikely that they all changed their cookie to the same value. On Thu, May 14, 2009 at 4:01 PM, Adrian Lynch cont...@adrianlynch.co.ukwrote: I thought you said it was a cookie value? ~| 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:322533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IE Cflogin
Brian Bradley wrote: I am confused though. Why is IE ignoring the isDefined? I am saying isDefined(login) but if that variable hasn't been set why is it ignoring it. I must be missing something... IE can't ignore the IsDefnind(), it knows nothing about it! This is a client|server thing. You really have to understand and separate what happens on the client and what happens on the server. What you really need to be asking is: What is IE sending in the request that is allowing the IsDefined() to be true. Either it is sending the proper cookies or get variables to connect to the existing session OR it is sending proper get or form variables to start a new session. ~| 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:322534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IE Cflogin
It looks like IE is doing something strange, like storing login fields. Which version of IE is involved? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/5/15 Brian Bradley bbrad...@plrb.org: I have Use J2EE Session Variables checked, as well as Enable Application Variables and Enable Session Variables. I don't have any code dealing with cookies at this point. Perhaps I have to manipulate the default and maximum timeout for the Application variables in the administrator? BTW, I am running MX 6.1. Thanks for your h ~| 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:322535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE Cflogin
Oops, hit the enter key accidentally... Brian, Can you turn on Debugging and have it show all of the variables scopes? This might help you figure out where the session id is coming from. Pay particular attention to the cookie scope. Also, check your Application.cfm/cfc for ClientManagement. Is it enabled? If it is, ColdFusion will create cookies and pass in the session id as a token to the cookie, which can cause sessions to be available to IE when you reopen the browser (I've had this happen to me before). If you aren't using client variables in your application, make sure you set ClientManagement to false. HTH, Carl I have Use J2EE Session Variables checked, as well as Enable Application Variables and Enable Session Variables. I don't have any code dealing with cookies at this point. Perhaps I have to manipulate the default and maximum timeout for the Application variables in the administrator? BTW, I am running MX 6.1. Thanks for your 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:322536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Paypal Changes
I just heard about the paypal changes.. http://www.pdncommunity.com/pdn/board/message?board.id=payflowthread.id=6807http://www.pdncommunity.com/pdn/board/message?board.id=payflowthread.id=6807 Starting Sept 1 none of my paypal sites will wok:) I have a bunch of websites on cfmx 7. Apparently the new tags work on latest Java SDK, v4.31. Can I just install that version of Java on the cfmx 7 server without hurting anything else? ~| 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:322537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Best way to extend from a parent directory
I have an application where a component in one directory wants to extend a component from a previous directory. Normally you would need to either write the extend path from the root or from a mapped location examples: root.dir1.dir2.component mapped_location.dir2.component Is there a way to extend from a directory up without using either of these methods? Basically, the equivalent of html's ../ Thanks -- Michael Dinowitz (http://www.linkedin.com/in/mdinowitz) President: House of Fusion(http://www.houseoffusion.com) Publisher: Fusion Authority(http://www.fusionauthority.com) Publisher: Flex Authority(http://www.flex-authority.com) Adobe Community Expert / Advanced Certified ColdFusion Professional Si, soy el senor chico malo para todos ~| 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:322538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best way to extend from a parent directory
Unfortunately, no. :-( ~| 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:322539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Paypal Changes
If you mean Payflowpro then there are 2 fast solutions that do not require a new Java install: 1. CF_PayFlowPro (http://cf_payflowpro.riaforge.org) This is a component that literally drops into place where the Payflowpro CFXC tag was. I used it for a client and it took all of 1 minute to put in and run a few tests. Worked perfectly. 2. cfPayflowPro (http://cfpayflowpro.riaforge.org) This is a set of components that take the place of the old CFX tag. This means a rewrite of any code On Thu, May 14, 2009 at 7:54 PM, Al Musella, DPM muse...@virtualtrials.comwrote: I just heard about the paypal changes.. http://www.pdncommunity.com/pdn/board/message?board.id=payflowthread.id=6807 http://www.pdncommunity.com/pdn/board/message?board.id=payflowthread.id=6807 Starting Sept 1 none of my paypal sites will wok:) I have a bunch of websites on cfmx 7. Apparently the new tags work on latest Java SDK, v4.31. Can I just install that version of Java on the cfmx 7 server without hurting anything else? ~| 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:322540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4