Re: One form with two submit buttons in <cflayoutarea>
Ok, so I am taking Ray's advice and changing a hidden form variable and submitting the form with JS. Thing is when I use the normal submit() in JS it breaks the page out of the original . Anyone know how to keep the form in the layout when submitting with JS? Thanks. > Ray, > > Thanks for the help again. > > Yeah it is confusing me. I have tried submitting to the same page and > to a different page and it always has the same result. The second > button is ignored. > > I don't know what the deal is. At least it is not just me, if it > surprised you then there must really be something wrong. > > Thanks again, you are the man. > > > I have this little bit of code that I am testing with inside of a > > : > > > > > > > > > > > > > > > > > > > > > > #cmd1# > > > > > > > > #cmd2# > > > > > > When inside the and the form is submitted it always > > returns a value for cmd1 no matter which submit button is clicked to > > > submit the form and no value for cmd2. See example: http://demo. > > thinksys.com/cf8/cflayout/ > > > > When not in the it functions like I think it should. > > > See Example: http://demo.thinksys.com/cf8/cflayout/1.cfm > > > > Anyone have any idea why. I am sure I am just confusing something > > because I am really not sure about a lot of the new CF8 stuff. > > > > Thanks in advance for any help. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285450 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfpresentation :: flash form
On 8/5/07, AJ Mercer <[EMAIL PROTECTED]> wrote: > As I understand it, you can put flash objects in a cfpresentationslide You can specify that an entire slide can be a SWF file but it cannot render an HTML page that contains a SWF. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sort By "Key"
Ah then use the array there. :) You just can't use it in your query. On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > Great suggestion, and it worked. However, the QueryAddColumn function > requires an array-name as its third parameter. So now I am getting the > following error: > > "Object of type class java.lang. String cannot be used as an array." > > On the following code: > > > > Dylan > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > Look here: > > > > > >SELECT SPEAKER_ID > >FROM TOPIC > >WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > > > > Remember that you made variables.keyArray an array. You can't use an > > array like that. Before you had made keyarray, you had keylist. Just > > use keylist. > > > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > > Will do Ray. Again, I appreciate any help you can give. > > > > > > --- start code --- > > > > > > > > > > > NAME="getTopics" > > > CRITERIA="*#LCase(FORM.topic)#*"> > > > > > > > > > > > > > > > > > > > > > > > > No files found for "#FORM.topic#" > > > > > > > > > > > > > > > SELECT SPEAKER_ID > > > FROM TOPIC > > > WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > > > > > > > > > > > > VARIABLES.keyArray)> > > > > > > > > > > > > > > SORTCOLUMN="Key" SORTORDER="Desc" > > > SORTTYPE="Numeric" > > > SORTEDQUERY="results"> > > > > > > > > > > > > > > > > > > > > HREF="test_search_details.cfm?speakerID=#key#">#results.title# > > > > > > > > > > > > --- end code --- > > > > > > Hey, it's Sunday...a day to be lazy :) > > > > > > Dylan > > > > > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > > > I think it would help if you could repost the full code again, with > > > > the issues. I could tyr to parse it from your first email, but I'm > > > > lazy. ;) > > > > > > > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > > > > Thanks Ray! I appreciate the quick response and suggestions. > > > > > > > > > > Admittedly, I "found" that code online, so anything that is old or > > > > > deprecated should have been caught. For instance, the parameterExists > > > > > function, I didn't know that it was deprecated, but regardless should > > > > > have known to use an isDefined function instead. Thank you for > > > > > bringing that to my attention. > > > > > > > > > > Ok re: number 2. I have changed my code to assign the valueList of > > > > > keys to a local variable instead. However, in the query I now get a > > > > > "Complex object types cannot be converted to simple values." error. > > > > > > > > > > --- start new query --- > > > > > > > > > > > > > > > SELECT SPEAKER_ID > > > > > FROM TOPIC > > > > > WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > > > > > > > > > > > > > --- end new query --- > > > > > > > > > > With re: to your third comment. This is true, I am only getting one > > > > > column and this same column is already being stored in my as > > > > > the key. As I understand how the custom tag works, I need to "match" > > > > > the verity results with the db results using "WHERE SPEAKER_ID IN > > > > > (#VARIABLES.keyArray#)" ...(except I am getting an error when doing > > > > > this, see number two from above)... Then the custom tag runs > > > > > (http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetail&extid=1000158) > > > > > and sorts the list according to the column specified. Does that make > > > > > sense? Would it be better to use a queryAddColumn and querySetCell as > > > > > opposed to the custom tag (which does the same thing)? > > > > > > > > > > Finally, with re: to your last comment. Thank you for pointing that > > > > > out. I completely overlooked that, since my code isn't even getting > > > > > that far at this point. My new output looks like this: > > > > > > > > > > --- start new output --- > > > > > > > > > > > > > > > > > > > > > > > > href="test_search_details.cfm?speakerID=#key#">#results.title# > > > > > > > > > > > > > > > > > > > > --- end new output --- > > > > > > > > > > Any thoughts or suggestions is much appreciated. > > > > > > > > > > Thanks. > > > > > > > > > > Dylan > > > > > > > > > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > > > > > I see a lot here - so forgive me if I jump around a bit. > > > > > > > > > > > > First off - don't use parameterExists. it was deprecated a _long_ > > > > > > time > > > > > > ago. It isn't the cause of any of your problems, but you should be > > > > > > using isDefined instead. > > > > > > > > > > > > Second - you get the valueList of keys from your Verity query. You > > > > > > then store this in the application scope. Why? You could have an > > > > > > issue > > > > > > right there if 2 people run your c
Re: CFFORM with flash format does not work in Internet Explorer ONLY
Are you able to navigate to the scripts in the CFIDE folder on the cf8 server? On 8/6/07, Charles Sheehan-MIles <[EMAIL PROTECTED]> wrote: > I'm struggling with the same problem, and have not found a solution. Here's > the situation: > > CF8 > IE7 > > Flash forms don't display at all in IE7, they look fine in all other > browsers. The same exact code works fine on a CF 7.0.2 server. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: One form with two submit buttons in &lt;cflayoutarea&gt;
> My need for it is pretty similar to what Ray explained. My buttons are > Save and Save & New. So both buttons submit the form, I just know what > the next step is based on the button. I agree, it can be done with a > drop down or a check box I have always just liked doing it with two > buttons. Its not difficult. What you need are two buttons, one a regular submit button, the other uses some JavaScript to change the action attribute of the form. Assuming that the form's name is searchForm2 here's an example: Of course this assumes that the user has javascript turned on. But if they click the submit button labeled "Continue" it should work like a regular submit. However if the user clicks the Start Search submit button, the action attribute of the form is changed to searchResults.cfm and that's where the user ends up. hth, larry ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: One form with two submit buttons in <cflayoutarea>
My need for it is pretty similar to what Ray explained. My buttons are Save and Save & New. So both buttons submit the form, I just know what the next step is based on the button. I agree, it can be done with a drop down or a check box I have always just liked doing it with two buttons. Thanks. > Ray, > > Thanks for the help again. > > Yeah it is confusing me. I have tried submitting to the same page and > to a different page and it always has the same result. The second > button is ignored. > > I don't know what the deal is. At least it is not just me, if it > surprised you then there must really be something wrong. > > Thanks again, you are the man. > > > I have this little bit of code that I am testing with inside of a > > : > > > > > > > > > > > > > > > > > > > > > > #cmd1# > > > > > > > > #cmd2# > > > > > > When inside the and the form is submitted it always > > returns a value for cmd1 no matter which submit button is clicked to > > > submit the form and no value for cmd2. See example: http://demo. > > thinksys.com/cf8/cflayout/ > > > > When not in the it functions like I think it should. > > > See Example: http://demo.thinksys.com/cf8/cflayout/1.cfm > > > > Anyone have any idea why. I am sure I am just confusing something > > because I am really not sure about a lot of the new CF8 stuff. > > > > Thanks in advance for any help. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285445 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: One form with two submit buttons in <cflayoutarea>
Ah.. ok then. :) Raymond Camden wrote: > One example I've seen recently - one button is labeled Save, one is > Save and Edit, so if you click Save and Edit, your changes are stored > and you end up back on the form. If you click Save, you go back to the > list. > > So sure - that could be a choice, but two buttons are easier. > > On 8/5/07, Phillip M. Vector <[EMAIL PROTECTED]> wrote: >> I have to ask... >> >> Why do you have 2 submit buttons? If you are having the user make a >> choice, why not a dropdown, checkbox, radio button or some such? >> >> If it's to load a terms of service or some such, why not a input of >> "button" with some JS to direct it to that page? >> >> Sorry. Not meaning to sound rude, but I can't fathom why you need 2 >> submits on 1 form. >> >> Steve Sequenzia wrote: >>> Ray, >>> >>> Thanks for the help again. >>> >>> Yeah it is confusing me. I have tried submitting to the same page and to a >>> different page and it always has the same result. The second button is >>> ignored. >>> >>> I don't know what the deal is. At least it is not just me, if it surprised >>> you then there must really be something wrong. >>> >>> Thanks again, you are the man. >>> >> > > ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: One form with two submit buttons in <cflayoutarea>
One example I've seen recently - one button is labeled Save, one is Save and Edit, so if you click Save and Edit, your changes are stored and you end up back on the form. If you click Save, you go back to the list. So sure - that could be a choice, but two buttons are easier. On 8/5/07, Phillip M. Vector <[EMAIL PROTECTED]> wrote: > I have to ask... > > Why do you have 2 submit buttons? If you are having the user make a > choice, why not a dropdown, checkbox, radio button or some such? > > If it's to load a terms of service or some such, why not a input of > "button" with some JS to direct it to that page? > > Sorry. Not meaning to sound rude, but I can't fathom why you need 2 > submits on 1 form. > > Steve Sequenzia wrote: > > Ray, > > > > Thanks for the help again. > > > > Yeah it is confusing me. I have tried submitting to the same page and to a > > different page and it always has the same result. The second button is > > ignored. > > > > I don't know what the deal is. At least it is not just me, if it surprised > > you then there must really be something wrong. > > > > Thanks again, you are the man. > > > > ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: One form with two submit buttons in <cflayoutarea>
I have to ask... Why do you have 2 submit buttons? If you are having the user make a choice, why not a dropdown, checkbox, radio button or some such? If it's to load a terms of service or some such, why not a input of "button" with some JS to direct it to that page? Sorry. Not meaning to sound rude, but I can't fathom why you need 2 submits on 1 form. Steve Sequenzia wrote: > Ray, > > Thanks for the help again. > > Yeah it is confusing me. I have tried submitting to the same page and to a > different page and it always has the same result. The second button is > ignored. > > I don't know what the deal is. At least it is not just me, if it surprised > you then there must really be something wrong. > > Thanks again, you are the man. > ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: One form with two submit buttons in <cflayoutarea>
You can do things the manual way of course. Switch to buttons and call a JS function to set a hidden form field and then submit(). Not ideal -but just a few lines of code and will get ou past this hump. Don't forget to log a bug at www.adobe.com/go/wish On 8/5/07, Steve Sequenzia <[EMAIL PROTECTED]> wrote: > Ray, > > Thanks for the help again. > > Yeah it is confusing me. I have tried submitting to the same page and to a > different page and it always has the same result. The second button is > ignored. > > I don't know what the deal is. At least it is not just me, if it surprised > you then there must really be something wrong. > > Thanks again, you are the man. > > > I have this little bit of code that I am testing with inside of a > > : > > > > > > > > > > > > > > > > > > > > > > #cmd1# > > > > > > > > #cmd2# > > > > > > When inside the and the form is submitted it always > > returns a value for cmd1 no matter which submit button is clicked to > > submit the form and no value for cmd2. See example: http://demo. > > thinksys.com/cf8/cflayout/ > > > > When not in the it functions like I think it should. > > See Example: http://demo.thinksys.com/cf8/cflayout/1.cfm > > > > Anyone have any idea why. I am sure I am just confusing something > > because I am really not sure about a lot of the new CF8 stuff. > > > > Thanks in advance for any help. > > > ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285441 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: One form with two submit buttons in <cflayoutarea>
Ray, Thanks for the help again. Yeah it is confusing me. I have tried submitting to the same page and to a different page and it always has the same result. The second button is ignored. I don't know what the deal is. At least it is not just me, if it surprised you then there must really be something wrong. Thanks again, you are the man. > I have this little bit of code that I am testing with inside of a > : > > > > > > > > > > > #cmd1# > > > > #cmd2# > > > When inside the and the form is submitted it always > returns a value for cmd1 no matter which submit button is clicked to > submit the form and no value for cmd2. See example: http://demo. > thinksys.com/cf8/cflayout/ > > When not in the it functions like I think it should. > See Example: http://demo.thinksys.com/cf8/cflayout/1.cfm > > Anyone have any idea why. I am sure I am just confusing something > because I am really not sure about a lot of the new CF8 stuff. > > Thanks in advance for any help. ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sort By "Key"
Great suggestion, and it worked. However, the QueryAddColumn function requires an array-name as its third parameter. So now I am getting the following error: "Object of type class java.lang. String cannot be used as an array." On the following code: Dylan On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > Look here: > > >SELECT SPEAKER_ID >FROM TOPIC >WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > Remember that you made variables.keyArray an array. You can't use an > array like that. Before you had made keyarray, you had keylist. Just > use keylist. > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > Will do Ray. Again, I appreciate any help you can give. > > > > --- start code --- > > > > > > > NAME="getTopics" > > CRITERIA="*#LCase(FORM.topic)#*"> > > > > > > > > > > > > > > > > No files found for "#FORM.topic#" > > > > > > > > > > SELECT SPEAKER_ID > > FROM TOPIC > > WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > > > > > > > VARIABLES.keyArray)> > > > > > > > > > SORTCOLUMN="Key" SORTORDER="Desc" > > SORTTYPE="Numeric" > > SORTEDQUERY="results"> > > > > > > > > > > > > > HREF="test_search_details.cfm?speakerID=#key#">#results.title# > > > > > > > > --- end code --- > > > > Hey, it's Sunday...a day to be lazy :) > > > > Dylan > > > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > > I think it would help if you could repost the full code again, with > > > the issues. I could tyr to parse it from your first email, but I'm > > > lazy. ;) > > > > > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > > > Thanks Ray! I appreciate the quick response and suggestions. > > > > > > > > Admittedly, I "found" that code online, so anything that is old or > > > > deprecated should have been caught. For instance, the parameterExists > > > > function, I didn't know that it was deprecated, but regardless should > > > > have known to use an isDefined function instead. Thank you for > > > > bringing that to my attention. > > > > > > > > Ok re: number 2. I have changed my code to assign the valueList of > > > > keys to a local variable instead. However, in the query I now get a > > > > "Complex object types cannot be converted to simple values." error. > > > > > > > > --- start new query --- > > > > > > > > > > > > SELECT SPEAKER_ID > > > > FROM TOPIC > > > > WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > > > > > > > > > > --- end new query --- > > > > > > > > With re: to your third comment. This is true, I am only getting one > > > > column and this same column is already being stored in my as > > > > the key. As I understand how the custom tag works, I need to "match" > > > > the verity results with the db results using "WHERE SPEAKER_ID IN > > > > (#VARIABLES.keyArray#)" ...(except I am getting an error when doing > > > > this, see number two from above)... Then the custom tag runs > > > > (http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetail&extid=1000158) > > > > and sorts the list according to the column specified. Does that make > > > > sense? Would it be better to use a queryAddColumn and querySetCell as > > > > opposed to the custom tag (which does the same thing)? > > > > > > > > Finally, with re: to your last comment. Thank you for pointing that > > > > out. I completely overlooked that, since my code isn't even getting > > > > that far at this point. My new output looks like this: > > > > > > > > --- start new output --- > > > > > > > > > > > > > > > > > > > href="test_search_details.cfm?speakerID=#key#">#results.title# > > > > > > > > > > > > > > > > --- end new output --- > > > > > > > > Any thoughts or suggestions is much appreciated. > > > > > > > > Thanks. > > > > > > > > Dylan > > > > > > > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > > > > I see a lot here - so forgive me if I jump around a bit. > > > > > > > > > > First off - don't use parameterExists. it was deprecated a _long_ time > > > > > ago. It isn't the cause of any of your problems, but you should be > > > > > using isDefined instead. > > > > > > > > > > Second - you get the valueList of keys from your Verity query. You > > > > > then store this in the application scope. Why? You could have an issue > > > > > right there if 2 people run your code at the same time. Because they > > > > > share the value, one person won't get the results they expect. I'd > > > > > just store the list of keys as a simple variable. > > > > > > > > > > Third - I see you are joining a Verity result with a db result. There > > > > > is nothing wrong with that, but I notice that you only get one column > > > > > from the db. If you are only getting one column, why not just store > > > > > that va
Re: One form with two submit buttons in
So i did a test when I changed your cfform to post to test2.cfm, and dumped the form scope there, and I saw the same - it doesn't recognize the second button. I mean the button works, but the value is the same. On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > Odd - I see it too. One thing to remember though - when you put cfform > inside of cflayoutarea, CF will post the form asynchronously, and will > replace the contents of the layoutarea with the result. > > But - you are posting to yourself. > > So you end up loading your original file inside the layoutarea you > just posted from. I wonder if that has something to do with it? > > On 8/5/07, Steve Sequenzia <[EMAIL PROTECTED]> wrote: > > I have this little bit of code that I am testing with inside of a > > : > > > > > > > > > > > > > > > > > > > > > > #cmd1# > > > > > > > > #cmd2# > > > > > > When inside the and the form is submitted it always returns > > a value for cmd1 no matter which submit button is clicked to submit the > > form and no value for cmd2. See example: > > http://demo.thinksys.com/cf8/cflayout/ > > > > When not in the it functions like I think it should. See > > Example: http://demo.thinksys.com/cf8/cflayout/1.cfm > > > > Anyone have any idea why. I am sure I am just confusing something because I > > am really not sure about a lot of the new CF8 stuff. > > > > Thanks in advance for any help. > > > > ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: One form with two submit buttons in
Odd - I see it too. One thing to remember though - when you put cfform inside of cflayoutarea, CF will post the form asynchronously, and will replace the contents of the layoutarea with the result. But - you are posting to yourself. So you end up loading your original file inside the layoutarea you just posted from. I wonder if that has something to do with it? On 8/5/07, Steve Sequenzia <[EMAIL PROTECTED]> wrote: > I have this little bit of code that I am testing with inside of a > : > > > > > > > > > > > #cmd1# > > > > #cmd2# > > > When inside the and the form is submitted it always returns a > value for cmd1 no matter which submit button is clicked to submit the form > and no value for cmd2. See example: http://demo.thinksys.com/cf8/cflayout/ > > When not in the it functions like I think it should. See > Example: http://demo.thinksys.com/cf8/cflayout/1.cfm > > Anyone have any idea why. I am sure I am just confusing something because I > am really not sure about a lot of the new CF8 stuff. > > Thanks in advance for any help. > > ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sort By "Key"
Look here: SELECT SPEAKER_ID FROM TOPIC WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) Remember that you made variables.keyArray an array. You can't use an array like that. Before you had made keyarray, you had keylist. Just use keylist. On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > Will do Ray. Again, I appreciate any help you can give. > > --- start code --- > > > NAME="getTopics" > CRITERIA="*#LCase(FORM.topic)#*"> > > > > > > > > No files found for "#FORM.topic#" > > > > > SELECT SPEAKER_ID > FROM TOPIC > WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > > > > > > SORTCOLUMN="Key" SORTORDER="Desc" > SORTTYPE="Numeric" SORTEDQUERY="results"> > > > > > > HREF="test_search_details.cfm?speakerID=#key#">#results.title# > > > > --- end code --- > > Hey, it's Sunday...a day to be lazy :) > > Dylan > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > I think it would help if you could repost the full code again, with > > the issues. I could tyr to parse it from your first email, but I'm > > lazy. ;) > > > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > > Thanks Ray! I appreciate the quick response and suggestions. > > > > > > Admittedly, I "found" that code online, so anything that is old or > > > deprecated should have been caught. For instance, the parameterExists > > > function, I didn't know that it was deprecated, but regardless should > > > have known to use an isDefined function instead. Thank you for > > > bringing that to my attention. > > > > > > Ok re: number 2. I have changed my code to assign the valueList of > > > keys to a local variable instead. However, in the query I now get a > > > "Complex object types cannot be converted to simple values." error. > > > > > > --- start new query --- > > > > > > > > > SELECT SPEAKER_ID > > > FROM TOPIC > > > WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > > > > > > > --- end new query --- > > > > > > With re: to your third comment. This is true, I am only getting one > > > column and this same column is already being stored in my as > > > the key. As I understand how the custom tag works, I need to "match" > > > the verity results with the db results using "WHERE SPEAKER_ID IN > > > (#VARIABLES.keyArray#)" ...(except I am getting an error when doing > > > this, see number two from above)... Then the custom tag runs > > > (http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetail&extid=1000158) > > > and sorts the list according to the column specified. Does that make > > > sense? Would it be better to use a queryAddColumn and querySetCell as > > > opposed to the custom tag (which does the same thing)? > > > > > > Finally, with re: to your last comment. Thank you for pointing that > > > out. I completely overlooked that, since my code isn't even getting > > > that far at this point. My new output looks like this: > > > > > > --- start new output --- > > > > > > > > > > > > > > href="test_search_details.cfm?speakerID=#key#">#results.title# > > > > > > > > > > > > --- end new output --- > > > > > > Any thoughts or suggestions is much appreciated. > > > > > > Thanks. > > > > > > Dylan > > > > > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > > > I see a lot here - so forgive me if I jump around a bit. > > > > > > > > First off - don't use parameterExists. it was deprecated a _long_ time > > > > ago. It isn't the cause of any of your problems, but you should be > > > > using isDefined instead. > > > > > > > > Second - you get the valueList of keys from your Verity query. You > > > > then store this in the application scope. Why? You could have an issue > > > > right there if 2 people run your code at the same time. Because they > > > > share the value, one person won't get the results they expect. I'd > > > > just store the list of keys as a simple variable. > > > > > > > > Third - I see you are joining a Verity result with a db result. There > > > > is nothing wrong with that, but I notice that you only get one column > > > > from the db. If you are only getting one column, why not just store > > > > that value in the Verity collection? You can use one of four custom > > > > columns. > > > > > > > > Lastly - I have'nt used that custom tag before, but it seems like you > > > > told it to return a sortedquery named results. But you don't even use > > > > that query when you output. > > > > > > > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > > > > Does any know how to sort by key from the results of a ? I'm > > > > > using Verity. > > > > > > > > > > I found a way by creating a list from the returned keys, then > > > > > assigning them to an array, then query the original data and matching > > > > > it to
Re: Sort By "Key"
Will do Ray. Again, I appreciate any help you can give. --- start code --- No files found for "#FORM.topic#" SELECT SPEAKER_ID FROM TOPIC WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) #results.title# --- end code --- Hey, it's Sunday...a day to be lazy :) Dylan On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > I think it would help if you could repost the full code again, with > the issues. I could tyr to parse it from your first email, but I'm > lazy. ;) > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > Thanks Ray! I appreciate the quick response and suggestions. > > > > Admittedly, I "found" that code online, so anything that is old or > > deprecated should have been caught. For instance, the parameterExists > > function, I didn't know that it was deprecated, but regardless should > > have known to use an isDefined function instead. Thank you for > > bringing that to my attention. > > > > Ok re: number 2. I have changed my code to assign the valueList of > > keys to a local variable instead. However, in the query I now get a > > "Complex object types cannot be converted to simple values." error. > > > > --- start new query --- > > > > > > SELECT SPEAKER_ID > > FROM TOPIC > > WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > > > > --- end new query --- > > > > With re: to your third comment. This is true, I am only getting one > > column and this same column is already being stored in my as > > the key. As I understand how the custom tag works, I need to "match" > > the verity results with the db results using "WHERE SPEAKER_ID IN > > (#VARIABLES.keyArray#)" ...(except I am getting an error when doing > > this, see number two from above)... Then the custom tag runs > > (http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetail&extid=1000158) > > and sorts the list according to the column specified. Does that make > > sense? Would it be better to use a queryAddColumn and querySetCell as > > opposed to the custom tag (which does the same thing)? > > > > Finally, with re: to your last comment. Thank you for pointing that > > out. I completely overlooked that, since my code isn't even getting > > that far at this point. My new output looks like this: > > > > --- start new output --- > > > > > > > > > href="test_search_details.cfm?speakerID=#key#">#results.title# > > > > > > > > --- end new output --- > > > > Any thoughts or suggestions is much appreciated. > > > > Thanks. > > > > Dylan > > > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > > I see a lot here - so forgive me if I jump around a bit. > > > > > > First off - don't use parameterExists. it was deprecated a _long_ time > > > ago. It isn't the cause of any of your problems, but you should be > > > using isDefined instead. > > > > > > Second - you get the valueList of keys from your Verity query. You > > > then store this in the application scope. Why? You could have an issue > > > right there if 2 people run your code at the same time. Because they > > > share the value, one person won't get the results they expect. I'd > > > just store the list of keys as a simple variable. > > > > > > Third - I see you are joining a Verity result with a db result. There > > > is nothing wrong with that, but I notice that you only get one column > > > from the db. If you are only getting one column, why not just store > > > that value in the Verity collection? You can use one of four custom > > > columns. > > > > > > Lastly - I have'nt used that custom tag before, but it seems like you > > > told it to return a sortedquery named results. But you don't even use > > > that query when you output. > > > > > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > > > Does any know how to sort by key from the results of a ? I'm > > > > using Verity. > > > > > > > > I found a way by creating a list from the returned keys, then > > > > assigning them to an array, then query the original data and matching > > > > it to the returned keys, then using a custom tag by Nate Weiss to sort > > > > the new query. It sounds as if it would work perfectly; however, I've > > > > run into a few issues. Here's what I have got thus far: > > > > > > > > --- start code --- > > > > > > > > > > > > > > > NAME="getTopics" > > > > CRITERIA="#LCase(FORM.topic)#"> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > No files found for > > > > "#FORM.topic#" > > > > > > > > > > > > > > > > > > > > > > > DATASOURCE="#APPLICATION.dataSource#"> > > > > SELECT speaker_id > > > > FROM topic > > > > WHERE speaker_id IN (#application.keyArray#) > > > > > > > > > > > > > > > > > > > application.keyArray)> >
One form with two submit buttons in
I have this little bit of code that I am testing with inside of a : #cmd1# #cmd2# When inside the and the form is submitted it always returns a value for cmd1 no matter which submit button is clicked to submit the form and no value for cmd2. See example: http://demo.thinksys.com/cf8/cflayout/ When not in the it functions like I think it should. See Example: http://demo.thinksys.com/cf8/cflayout/1.cfm Anyone have any idea why. I am sure I am just confusing something because I am really not sure about a lot of the new CF8 stuff. Thanks in advance for any help. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sort By "Key"
I think it would help if you could repost the full code again, with the issues. I could tyr to parse it from your first email, but I'm lazy. ;) On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > Thanks Ray! I appreciate the quick response and suggestions. > > Admittedly, I "found" that code online, so anything that is old or > deprecated should have been caught. For instance, the parameterExists > function, I didn't know that it was deprecated, but regardless should > have known to use an isDefined function instead. Thank you for > bringing that to my attention. > > Ok re: number 2. I have changed my code to assign the valueList of > keys to a local variable instead. However, in the query I now get a > "Complex object types cannot be converted to simple values." error. > > --- start new query --- > > > SELECT SPEAKER_ID > FROM TOPIC > WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) > > > --- end new query --- > > With re: to your third comment. This is true, I am only getting one > column and this same column is already being stored in my as > the key. As I understand how the custom tag works, I need to "match" > the verity results with the db results using "WHERE SPEAKER_ID IN > (#VARIABLES.keyArray#)" ...(except I am getting an error when doing > this, see number two from above)... Then the custom tag runs > (http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetail&extid=1000158) > and sorts the list according to the column specified. Does that make > sense? Would it be better to use a queryAddColumn and querySetCell as > opposed to the custom tag (which does the same thing)? > > Finally, with re: to your last comment. Thank you for pointing that > out. I completely overlooked that, since my code isn't even getting > that far at this point. My new output looks like this: > > --- start new output --- > > > > href="test_search_details.cfm?speakerID=#key#">#results.title# > > > > --- end new output --- > > Any thoughts or suggestions is much appreciated. > > Thanks. > > Dylan > > On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > > I see a lot here - so forgive me if I jump around a bit. > > > > First off - don't use parameterExists. it was deprecated a _long_ time > > ago. It isn't the cause of any of your problems, but you should be > > using isDefined instead. > > > > Second - you get the valueList of keys from your Verity query. You > > then store this in the application scope. Why? You could have an issue > > right there if 2 people run your code at the same time. Because they > > share the value, one person won't get the results they expect. I'd > > just store the list of keys as a simple variable. > > > > Third - I see you are joining a Verity result with a db result. There > > is nothing wrong with that, but I notice that you only get one column > > from the db. If you are only getting one column, why not just store > > that value in the Verity collection? You can use one of four custom > > columns. > > > > Lastly - I have'nt used that custom tag before, but it seems like you > > told it to return a sortedquery named results. But you don't even use > > that query when you output. > > > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > > Does any know how to sort by key from the results of a ? I'm > > > using Verity. > > > > > > I found a way by creating a list from the returned keys, then > > > assigning them to an array, then query the original data and matching > > > it to the returned keys, then using a custom tag by Nate Weiss to sort > > > the new query. It sounds as if it would work perfectly; however, I've > > > run into a few issues. Here's what I have got thus far: > > > > > > --- start code --- > > > > > > > > > > > NAME="getTopics" > > > CRITERIA="#LCase(FORM.topic)#"> > > > > > > > > > > > > > > > > > > > > > > > > No files found for > > > "#FORM.topic#" > > > > > > > > > > > > > > > > > DATASOURCE="#APPLICATION.dataSource#"> > > > SELECT speaker_id > > > FROM topic > > > WHERE speaker_id IN (#application.keyArray#) > > > > > > > > > > > > > > application.keyArray)> > > > > > > > > > > > > > > SORTCOLUMN="Key" > > > SORTORDER="Desc" > > > SORTTYPE="Numeric" > > > SORTEDQUERY="results"> > > > > > > > > > > > > > > > > > >> > href="test_search_details.cfm?speakerID=#key#">#getTopics.title# > > > > > > > > > > > > --- end code --- > > > > > > Any help or direction would be much appreciated. > > > > > > Thanks. > > > > > > Dylan > > > > > > > > > > > > ~
RE: where is my java.library.path ?
> So.. my question is .. where is my java.library.path ? It's in your jvm.config file, but don't worry about changing it, just put your driver in the same directory as all the other drivers (\cfusionmx7\lib if you have the standard single-server install, \jrun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib if you have the multiserver install). 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! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
where is my java.library.path ?
I'm trying to set up a JDBC connection to an SQL Anywhere database I've been told that all I need to do is choose >Datasources/ Other: > > CF data source: appropriate name > JDBC URL : jdbc:ianywhere:dsn=*** (name defined with ODBC manager ) > driver class: ianywhere.ml.jdbcodbc.jdbc3.IDriver > class: JDBC > Username: appropriate name However attempts to verify produce an error: connection verification failed for data source: appropriate name java.sql.SQLException: Timed out trying to establish connection And I find in CF\runtime\logs\coldfusion-err.log java.lang.UnsatisfiedLinkError: no dbjodbc10 in java.library.path So.. my question is .. where is my java.library.path ? BTW .. I can create a datasource with > JDBC URL : jdbc:odbc:dsn=*** (name defined with ODBC manager ) > driver class: ianywhere.ml.jdbcodbc.IDriver but I'd like to get as far away from the ODBC Server as possible.. Any guidance would be greatly appreciated. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285431 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 with flash format does not work in Internet Explorer ONLY
I'm struggling with the same problem, and have not found a solution. Here's the situation: CF8 IE7 Flash forms don't display at all in IE7, they look fine in all other browsers. The same exact code works fine on a CF 7.0.2 server. On 6/22/07 2:48 PM, "siriusthird" <[EMAIL PROTECTED]> wrote: > I am new to flash form in coldfusion. I tested a simple code in both Firebox > and Internet Explorer. > > - In Firebox, it works as expected. > - In Internet Explorer, nothing is displayed. > > Appreciate if anyone could let me know why it likes that and how to solve > it. > > My simple code: > > > > > -- Charles Sheehan-Miles | http://www.sheehanmiles.com Author of Republic: A Novel of America's Future Sparse, clean narrative... Pay attention to this new book... -- Pulitzer Prize winning journalist John Hanchette, Niagara Falls Reporter This novel ...may be prophetic...It will disturb you...It should. -- DailyKos ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285430 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Content Placeholders
And of course if the image is NOT defined, replace **image1** with nothing ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Sunday, August 05, 2007 1:17 PM To: CF-Talk Subject: RE: Content Placeholders I've done this in the past to allow the user to place images at specific places in their articles. I used tokens like... **image1** **image2** **image3** Etc... Then gave them a drop down menu for each image to select which image to display in each position. On the front end... If image1 is defined, #replace(str, '**image1**', '', 'all')# And the same thing for the others. ...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Sunday, August 05, 2007 10:19 AM To: CF-Talk Subject: Content Placeholders Hi, Trying to figure out how to use a placeholder in dynamic content to pull in other content at runtime. A user is entering text on a page in a database driven CMS system. If they insert a "token" or "Placeholder" in the middle of the copy somewhere (such as "%%ref01%%"), I would want that placeholder to dynamically insert additional text/graphics copy pulled from a different query, the inserted copy corresponding to that query's "ref01" ID. I could have two or three different "placeholders" within the page, each corresponding to a different "ID". I'm sure something like this is possible, but my searches for "placeholder" and "token" haven't turned up much. Thanks for your assistance, Mark ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Content Placeholders
Yeah, I was thinking about some type of conditional logic that would parse the entire html to look for an instance of **image01** to trigger the replace. Mark -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Sunday, August 05, 2007 1:17 PM To: CF-Talk Subject: RE: Content Placeholders I've done this in the past to allow the user to place images at specific places in their articles. I used tokens like... **image1** **image2** **image3** Etc... Then gave them a drop down menu for each image to select which image to display in each position. On the front end... If image1 is defined, #replace(str, '**image1**', '', 'all')# And the same thing for the others. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion 8 cfgrid and formatting
I am having a hard time finding an answer to this riddle so maybe someone here can help. I have a grid with columns show below. The livedocs say the mask attribute for cfgridcolumn is only used in when the format is flash. If this is correct then how do i format data in html? This would not just be dates but really any data, does anyone know how to format data? -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Content Placeholders
I've done this in the past to allow the user to place images at specific places in their articles. I used tokens like... **image1** **image2** **image3** Etc... Then gave them a drop down menu for each image to select which image to display in each position. On the front end... If image1 is defined, #replace(str, '**image1**', '', 'all')# And the same thing for the others. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Sunday, August 05, 2007 10:19 AM To: CF-Talk Subject: Content Placeholders Hi, Trying to figure out how to use a placeholder in dynamic content to pull in other content at runtime. A user is entering text on a page in a database driven CMS system. If they insert a "token" or "Placeholder" in the middle of the copy somewhere (such as "%%ref01%%"), I would want that placeholder to dynamically insert additional text/graphics copy pulled from a different query, the inserted copy corresponding to that query's "ref01" ID. I could have two or three different "placeholders" within the page, each corresponding to a different "ID". I'm sure something like this is possible, but my searches for "placeholder" and "token" haven't turned up much. Thanks for your assistance, Mark ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sort By "Key"
Thanks Ray! I appreciate the quick response and suggestions. Admittedly, I "found" that code online, so anything that is old or deprecated should have been caught. For instance, the parameterExists function, I didn't know that it was deprecated, but regardless should have known to use an isDefined function instead. Thank you for bringing that to my attention. Ok re: number 2. I have changed my code to assign the valueList of keys to a local variable instead. However, in the query I now get a "Complex object types cannot be converted to simple values." error. --- start new query --- SELECT SPEAKER_ID FROM TOPIC WHERE SPEAKER_ID IN (#VARIABLES.keyArray#) --- end new query --- With re: to your third comment. This is true, I am only getting one column and this same column is already being stored in my as the key. As I understand how the custom tag works, I need to "match" the verity results with the db results using "WHERE SPEAKER_ID IN (#VARIABLES.keyArray#)" ...(except I am getting an error when doing this, see number two from above)... Then the custom tag runs (http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetail&extid=1000158) and sorts the list according to the column specified. Does that make sense? Would it be better to use a queryAddColumn and querySetCell as opposed to the custom tag (which does the same thing)? Finally, with re: to your last comment. Thank you for pointing that out. I completely overlooked that, since my code isn't even getting that far at this point. My new output looks like this: --- start new output --- #results.title# --- end new output --- Any thoughts or suggestions is much appreciated. Thanks. Dylan On 8/5/07, Raymond Camden <[EMAIL PROTECTED]> wrote: > I see a lot here - so forgive me if I jump around a bit. > > First off - don't use parameterExists. it was deprecated a _long_ time > ago. It isn't the cause of any of your problems, but you should be > using isDefined instead. > > Second - you get the valueList of keys from your Verity query. You > then store this in the application scope. Why? You could have an issue > right there if 2 people run your code at the same time. Because they > share the value, one person won't get the results they expect. I'd > just store the list of keys as a simple variable. > > Third - I see you are joining a Verity result with a db result. There > is nothing wrong with that, but I notice that you only get one column > from the db. If you are only getting one column, why not just store > that value in the Verity collection? You can use one of four custom > columns. > > Lastly - I have'nt used that custom tag before, but it seems like you > told it to return a sortedquery named results. But you don't even use > that query when you output. > > On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > > Does any know how to sort by key from the results of a ? I'm > > using Verity. > > > > I found a way by creating a list from the returned keys, then > > assigning them to an array, then query the original data and matching > > it to the returned keys, then using a custom tag by Nate Weiss to sort > > the new query. It sounds as if it would work perfectly; however, I've > > run into a few issues. Here's what I have got thus far: > > > > --- start code --- > > > > > > > NAME="getTopics" > > CRITERIA="#LCase(FORM.topic)#"> > > > > > > > > > > > > > > > > No files found for > > "#FORM.topic#" > > > > > > > > > > > DATASOURCE="#APPLICATION.dataSource#"> > > SELECT speaker_id > > FROM topic > > WHERE speaker_id IN (#application.keyArray#) > > > > > > > > > application.keyArray)> > > > > > > > > > SORTCOLUMN="Key" > > SORTORDER="Desc" > > SORTTYPE="Numeric" > > SORTEDQUERY="results"> > > > > > > > > > > > >> href="test_search_details.cfm?speakerID=#key#">#getTopics.title# > > > > > > > > --- end code --- > > > > Any help or direction would be much appreciated. > > > > Thanks. > > > > Dylan > > > > > > ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Content Placeholders
Hi, Trying to figure out how to use a placeholder in dynamic content to pull in other content at runtime. A user is entering text on a page in a database driven CMS system. If they insert a "token" or "Placeholder" in the middle of the copy somewhere (such as "%%ref01%%"), I would want that placeholder to dynamically insert additional text/graphics copy pulled from a different query, the inserted copy corresponding to that query's "ref01" ID. I could have two or three different "placeholders" within the page, each corresponding to a different "ID". I'm sure something like this is possible, but my searches for "placeholder" and "token" haven't turned up much. Thanks for your assistance, Mark ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285424 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfpresentation :: flash form
As I understand it, you can put flash objects in a cfpresentationslide So I was thinking that you could put in cfchart or cfform with format = flash like: But this does not seem to be the case - well it isn't working for me. So it just embedded flash objects that can be used? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sort By "Key"
I see a lot here - so forgive me if I jump around a bit. First off - don't use parameterExists. it was deprecated a _long_ time ago. It isn't the cause of any of your problems, but you should be using isDefined instead. Second - you get the valueList of keys from your Verity query. You then store this in the application scope. Why? You could have an issue right there if 2 people run your code at the same time. Because they share the value, one person won't get the results they expect. I'd just store the list of keys as a simple variable. Third - I see you are joining a Verity result with a db result. There is nothing wrong with that, but I notice that you only get one column from the db. If you are only getting one column, why not just store that value in the Verity collection? You can use one of four custom columns. Lastly - I have'nt used that custom tag before, but it seems like you told it to return a sortedquery named results. But you don't even use that query when you output. On 8/5/07, Dylan Carlson <[EMAIL PROTECTED]> wrote: > Does any know how to sort by key from the results of a ? I'm > using Verity. > > I found a way by creating a list from the returned keys, then > assigning them to an array, then query the original data and matching > it to the returned keys, then using a custom tag by Nate Weiss to sort > the new query. It sounds as if it would work perfectly; however, I've > run into a few issues. Here's what I have got thus far: > > --- start code --- > > > NAME="getTopics" > CRITERIA="#LCase(FORM.topic)#"> > > > > > > > > No files found for > "#FORM.topic#" > > > > > > SELECT speaker_id > FROM topic > WHERE speaker_id IN (#application.keyArray#) > > > > application.keyArray)> > > > > SORTCOLUMN="Key" > SORTORDER="Desc" > SORTTYPE="Numeric" > SORTEDQUERY="results"> > > > > > >href="test_search_details.cfm?speakerID=#key#">#getTopics.title# > > > > --- end code --- > > Any help or direction would be much appreciated. > > Thanks. > > Dylan > > ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LDAP
Eric J. Hoffman wrote: > Have an app that is remote from a network that is your standard LDAP/AD > dealthe client's folks really want the remote app to authenticate > back via LDAP. Is LDAP a means or an end here? Do they specifically want LDAP or do they want something that allows single sign on and ties into AD and is LDAP just the first thing that came to their mind? > Now, I don't want to open up 389 in the firewall at all; so for you > great CF minds out thereis it even remotely advisable to setup a > firewall rule to accept 389 LDAP requests from a single IP > address.so this CF app can do its thing?? If they really want LDAP, you are going to have to give them LDAP. You can argue a security baseline and require IPSec, TLS, server hardening etc., but in the end the client is king. > I always err on the side of no in these situationsbut limiting it to > a specific IP is decent...but relies on that system being correct and > free of breachhas others seen this go on? If they really want LDAP the entire security of the AD can be breached. The problem with LDAP authentication is that the users enter their credentials on the remote application, and the remote application checks the credentials with the LDAP server. If the remote application is breached, the credentials are breached because they pass through the remote application. What you really want is a Trusted Third Party setup where the users enter their credentials at the AD, and then the AD guarantees the identity to the remote application without revealing the credentials. If the remote application is breached, only the remote application is breached, not the credentials. If you want to do this right you should use something like Kerberos, A-Select, Shibboleth. Jochem ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sort By "Key"
Does any know how to sort by key from the results of a ? I'm using Verity. I found a way by creating a list from the returned keys, then assigning them to an array, then query the original data and matching it to the returned keys, then using a custom tag by Nate Weiss to sort the new query. It sounds as if it would work perfectly; however, I've run into a few issues. Here's what I have got thus far: --- start code --- No files found for "#FORM.topic#" SELECT speaker_id FROM topic WHERE speaker_id IN (#application.keyArray#) #getTopics.title# --- end code --- Any help or direction would be much appreciated. Thanks. Dylan ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: LDAP
in general, no, I would say it's not a great idea, but sometimes requirements dictate that it has to be done. I've seen directories replicated out to a DMZ server to insulate things a bit, but I honestly don't see that as really improving security much, unless you are replicating non-sensitive information. for starters you should not open port 389 and instead open port 636 (and do LDAP over SSL/TLS). In addition, you could open a different port on the firewall (say 6636) and forward that to 636 on the inside. Also, if the rule is for traffic originating from a specific IP, that is much better than allowing anything in. I think a lot of this depends on how secure your LDAP servers are... in reality you shouldn't be able to do anything destructive without the necessary credentials. Even though the transmission of credentials will be encrypted, it doesn't change the fact that your server could be compromised and passwords sniffed before they go over the wire. I think there's a lot of variables to consider - if it *must* be done it tends to make admins more comfortable if the LDAP client is in a DMZ segment, thus under a bit more control (and can have IDS, etc) rather than a random server out on the Internet. Dave Ross http://www.coldspringframework.org > Have an app that is remote from a network that is your standard > LDAP/AD > dealthe client's folks really want the remote app to authenticate > back via LDAP. > > > > Now, I don't want to open up 389 in the firewall at all; so for you > great CF minds out thereis it even remotely advisable to setup a > firewall rule to accept 389 LDAP requests from a single IP > address.so this CF app can do its thing?? > > > > I always err on the side of no in these situationsbut limiting it > to > a specific IP is decent...but relies on that system being correct and > free of breachhas others seen this go on? > > > > Thanks > > > > Eric > > > > > Eric J. Hoffman > Managing Partner > 1940 Greeley Street South > Suite 102 > StillwaterMN55082 > mail: [EMAIL PROTECTED] > www: http://www.ejhassociates.com > tel: 651.717.4105 > fax: 651.717.4101 > mob: 651.245.2717 > Adobe Solutions Partner > Microsoft Certified Partner > > > > This message contains confidential information and is intended only > for [EMAIL PROTECTED] If you are not [EMAIL PROTECTED] > com you should not disseminate, distribute or copy this e-mail. Please > notify [EMAIL PROTECTED] immediately by e-mail if you have > received this e-mail by mistake and delete this e-mail from your > system. E-mail transmission cannot be guaranteed to be secure or > error-free as information could be intercepted, corrupted, lost, > destroyed, arrive late or incomplete, or contain viruses. Eric J. > Hoffman therefore does not accept liability for any errors or > omissions in the contents of this message, which arise as a result of > e-mail transmission. If verification is required please request a > hard-copy version. > ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Operation Failed on Data Source Error
ORA-00600 means, "Call your DBA as the DB has big issues." This isn't a CF problem. On 8/5/07, Dave Hatz <[EMAIL PROTECTED]> wrote: > We are using CF7.02 Enterprise on a Windows 2003 Server. We have multiple > servers(3) running on the same box via JRun. We are running Oracle 9i on a > Windows 2K box. On one of our CF servers we received the following error > yesterday: > > Operation failed on the data source named "xxx". > Reason of failure "java.sql.SQLException: [Macromedia][Oracle JDBC > Driver][Oracle]ORA-00600: internal error code, arguments: [17172], [0x0], [], > [], [], [], [], [] " > > Our CF server has been online for about 11 months now with no known DB > connection issues. We are using the Oracle Driver provided with CF7 > Enterprise. Our other CF servers running on the same box connected to the > same data source didn't have any problems. This is the 2nd time in 3 weeks > we have received this error. In checking the Ora Error, the ORA-00600 error > is a very serious error, but doesn't tell u much about what is going on, > stuff like the DB is corrupted or unstable. We run multiple applications > against that same DB and we haven't seen any errors like this. Applications > that are written in Delphi, Java and CF. > > So my question to the Oracle/CF guru's in the community, is have u seen this > error before and if so, can u clue me in on what it means or what else I need > to be looking for. Is it really an issue with our Oracle 9i Server or a CF > issue? -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JS Question Hide/Show Form Elements
Or $("#idofelement").toggle(); I'm having a tonne of fun with jQuery at the moment! Adrian -Original Message- From: Josh Nathanson Sent: 03 August 2007 17:25 To: CF-Talk Subject: Re: JS Question Hide/Show Form Elements > HIDE: document.getElementById('idOfElement').style.display='none' > SHOW: document.getElementById('idOfElement').style.display='block' Or in jQuery: $("#idofelement").hide(); $("#idofelement").show(); -- Josh ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Operation Failed on Data Source Error
We are using CF7.02 Enterprise on a Windows 2003 Server. We have multiple servers(3) running on the same box via JRun. We are running Oracle 9i on a Windows 2K box. On one of our CF servers we received the following error yesterday: Operation failed on the data source named "xxx". Reason of failure "java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00600: internal error code, arguments: [17172], [0x0], [], [], [], [], [], [] " Our CF server has been online for about 11 months now with no known DB connection issues. We are using the Oracle Driver provided with CF7 Enterprise. Our other CF servers running on the same box connected to the same data source didn't have any problems. This is the 2nd time in 3 weeks we have received this error. In checking the Ora Error, the ORA-00600 error is a very serious error, but doesn't tell u much about what is going on, stuff like the DB is corrupted or unstable. We run multiple applications against that same DB and we haven't seen any errors like this. Applications that are written in Delphi, Java and CF. So my question to the Oracle/CF guru's in the community, is have u seen this error before and if so, can u clue me in on what it means or what else I need to be looking for. Is it really an issue with our Oracle 9i Server or a CF issue? Thanks, Dave Hatz ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285416 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4