RE: What in the world is CF8 trying to say?
Thanks for the feedback, Jayesh. It's must be Image.Link# since that's a variable used by the CFX_Tag. Would the fact that the CFX_tag, CFX_JPG, is a C++ tag cause any problems? Rick -Original Message- From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 12:36 AM To: CF-Talk Subject: RE: What in the world is CF8 trying to say? This kind of errors are usually seen when there is a specific type of datatype used for a wrong reason or purpose. Although I can not run your code on my machine, I would like to give some pointers which may help you. Error message says that a datatype which is QueryColumn type is being used as a structure datatype which is wrong. Any of the below three variables are not returning the expected kind of data #GAP# - #Get_Announcements.Image# - #Image.Link# Thanks Regards, Jayesh Viradiya Adobe CF Team -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291024 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Why would this query not return the correct data?
Hi, all. Here's the query: cfquery name=get_days datasource=#dsn# select distinct event_days from weekly schedule order by event_day /cfquery The data that should be returned if the query is looped is 1, 1, 1, 1, 2, 4, 6 However, when I run. cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop .. all I get is 1, 1, 1, 1.four ones, and that's it. What could I be doing wrong? I knew transitioning from CF 4.5 to CF 8 would present some issues, but gee whiz. Rick ~| 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:291023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What in the world is CF8 trying to say?
That kind of error normally occurs when you try to access a variable as a type that it isn't Like cfset testVar = {} / cfoutput#testVar['one']['two'] Regards Dale Fraser http://learncf.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, 14 October 2007 4:03 PM To: CF-Talk Subject: RE: What in the world is CF8 trying to say? Thanks for the feedback, Jayesh. It's must be Image.Link# since that's a variable used by the CFX_Tag. Would the fact that the CFX_tag, CFX_JPG, is a C++ tag cause any problems? Rick -Original Message- From: Jayesh Viradiya [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 12:36 AM To: CF-Talk Subject: RE: What in the world is CF8 trying to say? This kind of errors are usually seen when there is a specific type of datatype used for a wrong reason or purpose. Although I can not run your code on my machine, I would like to give some pointers which may help you. Error message says that a datatype which is QueryColumn type is being used as a structure datatype which is wrong. Any of the below three variables are not returning the expected kind of data #GAP# - #Get_Announcements.Image# - #Image.Link# Thanks Regards, Jayesh Viradiya Adobe CF Team -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why would this query not return the correct data?
Considering that your doing a select distinct, the correct output should be 1, 2, 4, 6 and not 1, 1, 1, 1, 2, 4, 6 as you first stated. So it looks like you're getting the very first value 4 times. Try to scope the output and see if that helps: cfloop query=get_days cfoutput#get_days.event_days#/cfoutput /cfloop Or better yet drop the cfloop all together and only use cfoutput cfoutput query=get_days#event_days#/cfoutput /Max On 10/14/07, Rick Faircloth [EMAIL PROTECTED] wrote: Follow-up: When I run the same query below in a query editor, the correct data, 1, 2, 4, 6 is returned. What wouldn't CF 8 return the same data with the same query? Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 1:40 AM To: CF-Talk Subject: Why would this query not return the correct data? Hi, all. Here's the query: cfquery name=get_days datasource=#dsn# select distinct event_days from weekly schedule order by event_day /cfquery The data that should be returned if the query is looped is 1, 1, 1, 1, 2, 4, 6 However, when I run. cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop .. all I get is 1, 1, 1, 1.four ones, and that's it. What could I be doing wrong? I knew transitioning from CF 4.5 to CF 8 would present some issues, but gee whiz. Rick ~| 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:291026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why would this query not return the correct data?
Follow-up: When I run the same query below in a query editor, the correct data, 1, 2, 4, 6 is returned. What wouldn't CF 8 return the same data with the same query? Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 1:40 AM To: CF-Talk Subject: Why would this query not return the correct data? Hi, all. Here's the query: cfquery name=get_days datasource=#dsn# select distinct event_days from weekly schedule order by event_day /cfquery The data that should be returned if the query is looped is 1, 1, 1, 1, 2, 4, 6 However, when I run. cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop .. all I get is 1, 1, 1, 1.four ones, and that's it. What could I be doing wrong? I knew transitioning from CF 4.5 to CF 8 would present some issues, but gee whiz. Rick ~| 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:291025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SiteObjects: No answer at all !
Hi list, does s.o. know what happened to the guys of: http://www.siteobjects.com/ ?? Nobody answers, when I send them an eMail. Besides their Support Forums are out of order for weeks now ! Uwe ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291029 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TinyMCE/CFFM pathing question
I sent this to Rick, but thought I'd post it here as well... I just installed CFFM for the first time with tinyMCE. Tryin to figure out where I'm goin wrong here... Virtually everything works. If you browse for the file, the path shows up correctly in the lil tinyMCEwindow. /ncccfa/contentImages/CEBanner.jpg Click insert. The image shows up in the editor, no problem. But you view the source html and it inserted this: img src=../contentImages/CEBanner.jpg alt= / I'ts like it's using a path that's relative to my text editor page. I'm assuming I have a path setting wrong somewhere. I want it to just insert the root relative path like it shows in the image window: /contentImages/theimage.jpg Here's my js (I'm using the built in server so I gotta put the REAL site root in the front of the url): function cffmCallback(field_name, url, type, win) { // Do custom browser logic url = '/ncccfa/backroom/cffm-1.17/cffm.cfm?editorType=mceEDITOR_RESOURCE_TYPE=' + type; x = 700; // width of window y = 500; // height of window win2 = win; // don't ask, it works. win2 ends up being global to the page, while win is only accessible to the function. cffmWindow = window.open(url,,width=+x+,height=+y+,left=20,top=20,bgcolor=white,resizable,scrollbars,menubar=0); if ( cffmWindow != null ) { // bring the window to the front cffmWindow.focus(); } } And in cffm.cfm cfinvokeargument name=includeDir value=#ExpandPath(/ncccfa/contentImages)# !--- includeDirWeb = web path to the directory specified above. --- cfinvokeargument name=includeDirWeb value=/ncccfa/contentImages Have any ideas? Will ~| 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=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What in the world is CF8 trying to say?
I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using Japanese Text and CFIMAGE
back in the days prior to Unicode, these symbol language characters would take 2 bytes to represent. there even used to be a system called 'DBCS' (Double Byte Character System) where some letters were stored in 1 byte, others were stored in 2 bytes. -jim On 10/13/07, Paul Hastings [EMAIL PROTECTED] wrote: Alan Rother wrote: Anyone out there used CF8 and CFIMAGE to create dynamic images that contain Japanese (well,really any double byte text language. Russian, Chinese, etc...) text yet? yes. I'm having no luck on it, any help would be greatly appreciated. might start with what the problem is. btw, what makes you say call those double byte text languages? ~| 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:291031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Encrypted String - SQL Field Length
Hello Guys, Is there any way to predict the database field length I'll need to facilitate my encrypted data? I'm using AES encryption with HEX encoding for all kinds for different data, from names and address', through to credit card information. I'm looking to define appropriate column lengths in my tables, is this easy to predict? Does AES encryption give me a regular string length regardless of that of the original string? Thanks guys, Rob ~| 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:291032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Check File For Change
Does that sounds like a fair concept? It sure is. I have written such a tag and it works. I use it to make sure two images are not the same, even if they have different file names. But I have not publish the tag yet. I also have a tag that return a correct time stamp about a file, to the second and consistent over all CF versions, see CFX_ListDir http://www.contentbox.com/claude/customtags/ListDir/viewListDir.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291035 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What in the world is CF8 trying to say?
I think the problem is with #Image.Link#. I suppose that Image is a structure returned by CFX_JPG? But if you are inside a CFOUTPUT loop on query Get_Announcements., then Image is also a column in the query, and CF tries to get to the element .Link inside Image, which does not work. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291034 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SiteObjects: No answer at all !
Dead, I bet. soEditor died when IE6 came out, which I'm sure had a negative effect on their company's well being. We moved everything to TinyMCE. cheers, barneyb On 10/14/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi list, does s.o. know what happened to the guys of: http://www.siteobjects.com/ ?? Nobody answers, when I send them an eMail. Besides their Support Forums are out of order for weeks now ! Uwe ~| 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:291033 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using Japanese Text and CFIMAGE
Jim Rising wrote: back in the days prior to Unicode, these symbol language characters would take 2 bytes to represent. there even used to be a system called 'DBCS' (Double Byte Character System) where some letters were stored in 1 byte, others were stored in 2 bytes. i know what dbcs means there's never been a single so-called Double Byte Character System. pre-unicode was almost *20* years ago. japanese had a butt load of encodings that are single, double multi-byte (still has i guess would be correct). ditto for chinese. ancient cyrillic (KOI-8) was a single byte as was pretty much any language that could fit on a windows (or DOS) codepage like thai arabic. in any case, leaving out codepage nonsense, none of these languages have been anything but multi-byte for at least 10 years. the term dbcs is misleading we should all stop using it. ~| 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:291038 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Check File For Change
Thanks Claude, That certainly sounds like an excellent idea, I also like the concept about ensuring two files are not the same, just with different file names, this could most certainly play nicely in my application. Even if the tag is not published I'd love to hear a little about the concepts of how it works, you can mail me off list if you'd prefer to keep it private. Thanks again for the advice mate, I'll look into that directory tag too. Rob -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 14 October 2007 16:45 To: CF-Talk Subject: Re: Check File For Change Does that sounds like a fair concept? It sure is. I have written such a tag and it works. I use it to make sure two images are not the same, even if they have different file names. But I have not publish the tag yet. I also have a tag that return a correct time stamp about a file, to the second and consistent over all CF versions, see CFX_ListDir http://www.contentbox.com/claude/customtags/ListDir/viewListDir.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why would this query not return the correct data?
cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop This is an old CF bug: Inside a loop, a column name alone always comes from the first record. You must specify the query name to get the current row: cfloop query=get_days cfoutput#get_days.event_days#/cfoutput /cfloop -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291036 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What in the world is CF8 trying to say?
A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291041 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why would this query not return the correct data?
I'd do the latter and still prefix the column with the query name. But not for any reason other than I just do it that way all the time after becoming a scoping nazi due to a horrible project I overtook many years ago. On 10/14/07, Maximilian Nyman [EMAIL PROTECTED] wrote: Considering that your doing a select distinct, the correct output should be 1, 2, 4, 6 and not 1, 1, 1, 1, 2, 4, 6 as you first stated. So it looks like you're getting the very first value 4 times. Try to scope the output and see if that helps: cfloop query=get_days cfoutput#get_days.event_days#/cfoutput /cfloop Or better yet drop the cfloop all together and only use cfoutput cfoutput query=get_days#event_days#/cfoutput /Max On 10/14/07, Rick Faircloth [EMAIL PROTECTED] wrote: Follow-up: When I run the same query below in a query editor, the correct data, 1, 2, 4, 6 is returned. What wouldn't CF 8 return the same data with the same query? Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 1:40 AM To: CF-Talk Subject: Why would this query not return the correct data? Hi, all. Here's the query: cfquery name=get_days datasource=#dsn# select distinct event_days from weekly schedule order by event_day /cfquery The data that should be returned if the query is looped is 1, 1, 1, 1, 2, 4, 6 However, when I run. cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop .. all I get is 1, 1, 1, 1.four ones, and that's it. What could I be doing wrong? I knew transitioning from CF 4.5 to CF 8 would present some issues, but gee whiz. Rick ~| 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:291040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Check File For Change
Even if the tag is not published I'd love to hear a little about the concepts of how it works, you can mail me off list if you'd prefer to keep it private. Actually, it does not use MD5 algorithm, but a CRC-32 checksum, which returns an 8 characters hexadecimal value. The probability of having two different files having the same value is near zero, especially if you consider only files having the same length. It is a C++ tag (Windows only), but much more efficient than using CF code. I'm sending the tag to you as a beta test. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
open source eCommerce application
Hi all, I've started the ball rolling on getting a eCommerce solution developed - more information here: http://www.succor.co.uk/index.cfm/2007/10/14/cfCommerceorg--a-free-coldfusion-eCommerce-solution Please post any thoughts on the blog post - many thanks. Nick -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk f..works:http://cfframeworks.com short urls: http://wapurl.co.uk green link: http://wapurl.co.uk/?4Z2YDLX ~| 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:291043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What in the world is CF8 trying to say?
Just reread this, figured I'd clarify, I do not think scoping Image in this instance would fix it but certainly could try it. Was not aware of Image being used for something specific in 8, but guess perhaps scoping it might avoid a conflict with something else in the code on the page and not seen in the snippet. Probably the tag itself not liking the newer version of CF, honestly if I relied so heavily on a custom tag then I'd done some heavy testing with it prior to spending the money to upgrade versions. On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto: [EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291042 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What in the world is CF8 trying to say?
I didn't purchase CF 8... I purchased a VPS for $70 per month that has beefy hardware and CF 8 installed... a good deal. Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 1:22 PM To: CF-Talk Subject: Re: What in the world is CF8 trying to say? Just reread this, figured I'd clarify, I do not think scoping Image in this instance would fix it but certainly could try it. Was not aware of Image being used for something specific in 8, but guess perhaps scoping it might avoid a conflict with something else in the code on the page and not seen in the snippet. Probably the tag itself not liking the newer version of CF, honestly if I relied so heavily on a custom tag then I'd done some heavy testing with it prior to spending the money to upgrade versions. On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto: [EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291044 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: What in the world is CF8 trying to say?
Where? VPS with CF8?? Might need to really look more into a new host for VPS -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 4:35 PM To: CF-Talk Subject: RE: What in the world is CF8 trying to say? I didn't purchase CF 8... I purchased a VPS for $70 per month that has beefy hardware and CF 8 installed... a good deal. Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 1:22 PM To: CF-Talk Subject: Re: What in the world is CF8 trying to say? Just reread this, figured I'd clarify, I do not think scoping Image in this instance would fix it but certainly could try it. Was not aware of Image being used for something specific in 8, but guess perhaps scoping it might avoid a conflict with something else in the code on the page and not seen in the snippet. Probably the tag itself not liking the newer version of CF, honestly if I relied so heavily on a custom tag then I'd done some heavy testing with it prior to spending the money to upgrade versions. On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto: [EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Is This Possible??
Greetings, Here is the scenario the customer has presented. 3 Tables involved. Table 1 - Scheduled training for a year Table 2 - Employee information Table 3 - Completed training If I am understanding my customer and I believe I am, this is what they want to do. They want to run a query against the 3 previous mentioned tables, and output a list of the scheduled training showing a green check for completed and a red x for not completed. In my thinking, there will be nothing to evaluate in table 3 if they have not completed the training, since there will only be an entry for completed training. So if it is possible, how would it be accomplished? Thanks in advance Leonard ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What in the world is CF8 trying to say?
I would like to let people know CFX_JPG is an old, retired product. The problem is a namespace collision on the variable name image. The problem was dealt with on the release of ImageCR 3 some years ago. -- Magnus Just reread this, figured I'd clarify, I do not think scoping Image in this instance would fix it but certainly could try it. Was not aware of Image being used for something specific in 8, but guess perhaps scoping it might avoid a conflict with something else in the code on the page and not seen in the snippet. Probably the tag itself not liking the newer version of CF, honestly if I relied so heavily on a custom tag then I'd done some heavy testing with it prior to spending the money to upgrade versions. On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto: [EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TinyMCE/CFFM pathing question
I fixed this... document_base_url : /ncccfa/index.cfm, relative_urls : false, remove_script_host : true That seemed to do the trick... Will ~| 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=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What in the world is CF8 trying to say?
ImageCR 3 RULES!!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 2:09 PM To: CF-Talk Subject: Re: What in the world is CF8 trying to say? I would like to let people know CFX_JPG is an old, retired product. The problem is a namespace collision on the variable name image. The problem was dealt with on the release of ImageCR 3 some years ago. -- Magnus Just reread this, figured I'd clarify, I do not think scoping Image in this instance would fix it but certainly could try it. Was not aware of Image being used for something specific in 8, but guess perhaps scoping it might avoid a conflict with something else in the code on the page and not seen in the snippet. Probably the tag itself not liking the newer version of CF, honestly if I relied so heavily on a custom tag then I'd done some heavy testing with it prior to spending the money to upgrade versions. On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto: [EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is This Possible??
Leonard, There are a lot of ways to accomplish this. What are you trying to do? Are you trying to get the answer in a single query? What is your expected output? Do you have other schema info? What are the PK FKs in each table? More info is needed to answer your question. Cheers, Kris On 10/14/07, Leonard Boche [EMAIL PROTECTED] wrote: Greetings, Here is the scenario the customer has presented. 3 Tables involved. Table 1 - Scheduled training for a year Table 2 - Employee information Table 3 - Completed training If I am understanding my customer and I believe I am, this is what they want to do. They want to run a query against the 3 previous mentioned tables, and output a list of the scheduled training showing a green check for completed and a red x for not completed. In my thinking, there will be nothing to evaluate in table 3 if they have not completed the training, since there will only be an entry for completed training. So if it is possible, how would it be accomplished? Thanks in advance Leonard ~| 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:291049 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
using array data to create a cfchart
Hi there I have created two arrays which contain the data that I want to report on using cfchart. Basically I have a person name array and a person sales array. I am trying to work out how I can use the data in the arrays to produce the cfchart. Currently I have hard coded the information into the cfchart below, but this is limiting as this report will run for various retail stores and I dont know the sles people from each store. cfchart chartwidth=950 chartheight=500 xaxistitle=Sales Staff yaxistitle=Revenue show3d=Yes cfchartseries type=pie serieslabel=Sales Staff seriescolor=##ffcc00 cfchartdata item=Alan Ash value=2387 cfchartdata item=Brad Bloom value=7795 cfchartdata item=Colin Craig value=2487 cfchartdata item= Doug Douglas value=511 cfchartdata item=Ed Edwards value=1565 cfchartdata item=Frank Farina value=781 /cfchartseries /cfchart ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What in the world is CF8 trying to say?
Only a good deal if what you plan to run on it, will in fact run without issues on it or can easily be modified to run on it without issues. On 10/14/07, Rick Faircloth [EMAIL PROTECTED] wrote: I didn't purchase CF 8... I purchased a VPS for $70 per month that has beefy hardware and CF 8 installed... a good deal. Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 1:22 PM To: CF-Talk Subject: Re: What in the world is CF8 trying to say? Just reread this, figured I'd clarify, I do not think scoping Image in this instance would fix it but certainly could try it. Was not aware of Image being used for something specific in 8, but guess perhaps scoping it might avoid a conflict with something else in the code on the page and not seen in the snippet. Probably the tag itself not liking the newer version of CF, honestly if I relied so heavily on a custom tag then I'd done some heavy testing with it prior to spending the money to upgrade versions. On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto: [EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why would this query not return the correct data?
On 10/14/07, Rick Faircloth [EMAIL PROTECTED] wrote: @ All... This is just nuts... I can run this sql in an editor and get the correct results: select distinct event_day from weekly_schedule order by event_day And the correct results are 1, 2, 4, 6. But if I run that same sql in a CF8 cfquery, scoping or not scoping every variable, all I get is 1, 1, 1, 1. This was working perfectly in CF 4.5. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery I even put just the query and output commands on a separate page and still get 1, 1, 1, 1. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop I just don't get it... Any more ideas, anyone? :o/ you tried dumping the query? cfdump will be your very best friend. cfdump var=#get_days# see if it's the query that's not returning the data you want, or if it's the loop that's outputting it incorrectly. -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| 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:291055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why would this query not return the correct data?
What does it show when you run a cfdump on the query? cfdump var=#get_days# / On 10/14/07, Rick Faircloth [EMAIL PROTECTED] wrote: @ All... This is just nuts... I can run this sql in an editor and get the correct results: select distinct event_day from weekly_schedule order by event_day And the correct results are 1, 2, 4, 6. But if I run that same sql in a CF8 cfquery, scoping or not scoping every variable, all I get is 1, 1, 1, 1. This was working perfectly in CF 4.5. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery I even put just the query and output commands on a separate page and still get 1, 1, 1, 1. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop I just don't get it... Any more ideas, anyone? :o/ Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 11:49 AM To: CF-Talk Subject: Re: Why would this query not return the correct data? cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop This is an old CF bug: Inside a loop, a column name alone always comes from the first record. You must specify the query name to get the current row: cfloop query=get_days cfoutput#get_days.event_days#/cfoutput /cfloop -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why would this query not return the correct data?
@ All... This is just nuts... I can run this sql in an editor and get the correct results: select distinct event_day from weekly_schedule order by event_day And the correct results are 1, 2, 4, 6. But if I run that same sql in a CF8 cfquery, scoping or not scoping every variable, all I get is 1, 1, 1, 1. This was working perfectly in CF 4.5. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery I even put just the query and output commands on a separate page and still get 1, 1, 1, 1. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop I just don't get it... Any more ideas, anyone? :o/ Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 11:49 AM To: CF-Talk Subject: Re: Why would this query not return the correct data? cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop This is an old CF bug: Inside a loop, a column name alone always comes from the first record. You must specify the query name to get the current row: cfloop query=get_days cfoutput#get_days.event_days#/cfoutput /cfloop -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Frameworks: Post vs. Get
Okay, so you pick a framework - just about any framework; Fusebox, ColdBox, mach-ii, Model-Glue. These frameworks fold the form (post) and URL (get) variables into an event object (or attributes in the case of traditional FB apps). But let's say that you want to be sure that the variable came from a post - for instance deleting something in an admin panel. How do you guys (and girls) verify that it's a post var? Thanks, Matt ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Why would this query not return the correct data?
Also if that shows the query itself is in fact pulling out the correct data then have you tried doing a cfoutput with the query attribute and eliminating the cfloop with the cfoutput within that? Something like: cfoutput query=Get_Days#get_days.event_day#br //cfoutput On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: What does it show when you run a cfdump on the query? cfdump var=#get_days# / On 10/14/07, Rick Faircloth [EMAIL PROTECTED] wrote: @ All... This is just nuts... I can run this sql in an editor and get the correct results: select distinct event_day from weekly_schedule order by event_day And the correct results are 1, 2, 4, 6. But if I run that same sql in a CF8 cfquery, scoping or not scoping every variable, all I get is 1, 1, 1, 1. This was working perfectly in CF 4.5. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery I even put just the query and output commands on a separate page and still get 1, 1, 1, 1. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop I just don't get it... Any more ideas, anyone? :o/ Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 11:49 AM To: CF-Talk Subject: Re: Why would this query not return the correct data? cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop This is an old CF bug: Inside a loop, a column name alone always comes from the first record. You must specify the query name to get the current row: cfloop query=get_days cfoutput#get_days.event_days#/cfoutput /cfloop -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Frameworks: Post vs. Get
I haven't worked with very many frameworks, but my understanding is that they don't change the basic functionality of Coldfusion as a middle-tier. You should be able to call upon the 'post' structure for the value of those variables to verify that it was declared there. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 6:05 PM To: CF-Talk Subject: Frameworks: Post vs. Get Okay, so you pick a framework - just about any framework; Fusebox, ColdBox, mach-ii, Model-Glue. These frameworks fold the form (post) and URL (get) variables into an event object (or attributes in the case of traditional FB apps). But let's say that you want to be sure that the variable came from a post - for instance deleting something in an admin panel. How do you guys (and girls) verify that it's a post var? Thanks, Matt ~| 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:291059 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: using array data to create a cfchart
Just loop over the array cfloop index=i from=1 to=#arrayLen(arrayPerson)# cfchartdata item=#arrayPerson[i]# value=#salesArray[i]# /cfloop Regards Dale Fraser http://learncf.com -Original Message- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: Monday, 15 October 2007 9:49 AM To: CF-Talk Subject: using array data to create a cfchart Hi there I have created two arrays which contain the data that I want to report on using cfchart. Basically I have a person name array and a person sales array. I am trying to work out how I can use the data in the arrays to produce the cfchart. Currently I have hard coded the information into the cfchart below, but this is limiting as this report will run for various retail stores and I dont know the sles people from each store. cfchart chartwidth=950 chartheight=500 xaxistitle=Sales Staff yaxistitle=Revenue show3d=Yes cfchartseries type=pie serieslabel=Sales Staff seriescolor=##ffcc00 cfchartdata item=Alan Ash value=2387 cfchartdata item=Brad Bloom value=7795 cfchartdata item=Colin Craig value=2487 cfchartdata item= Doug Douglas value=511 cfchartdata item=Ed Edwards value=1565 cfchartdata item=Frank Farina value=781 /cfchartseries /cfchart ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
I suppose I don't understand why you'd care if the variable came from a form field as opposed to a URL variable. Either way you're going to have to make sure the user is an admin and they they have the rights to delete something. On 10/14/07, Matt Quackenbush [EMAIL PROTECTED] wrote: Okay, so you pick a framework - just about any framework; Fusebox, ColdBox, mach-ii, Model-Glue. These frameworks fold the form (post) and URL (get) variables into an event object (or attributes in the case of traditional FB apps). But let's say that you want to be sure that the variable came from a post - for instance deleting something in an admin panel. How do you guys (and girls) verify that it's a post var? Thanks, Matt ~| 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:291061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What in the world is CF8 trying to say?
AHPhosting.net... found their ad right on the houseoffusion website. I highly recommend it. I've been running my own server since CF 4.5 and this gives me complete control over the OS, installing/deleting software, settings, database, and CF 8 admin. It's cheaper that what I pay now just for my connection to the Internet. Rick -Original Message- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 5:07 PM To: CF-Talk Subject: RE: What in the world is CF8 trying to say? Where? VPS with CF8?? Might need to really look more into a new host for VPS -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 4:35 PM To: CF-Talk Subject: RE: What in the world is CF8 trying to say? I didn't purchase CF 8... I purchased a VPS for $70 per month that has beefy hardware and CF 8 installed... a good deal. Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 1:22 PM To: CF-Talk Subject: Re: What in the world is CF8 trying to say? Just reread this, figured I'd clarify, I do not think scoping Image in this instance would fix it but certainly could try it. Was not aware of Image being used for something specific in 8, but guess perhaps scoping it might avoid a conflict with something else in the code on the page and not seen in the snippet. Probably the tag itself not liking the newer version of CF, honestly if I relied so heavily on a custom tag then I'd done some heavy testing with it prior to spending the money to upgrade versions. On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto: [EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What in the world is CF8 trying to say?
Most of the sites I'm running on my server now are due for an update. So I'll be bringing them along slowly and hopefully rebuilding them as I migrate them anyway. I hope there won't be too many issues. Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 6:59 PM To: CF-Talk Subject: Re: What in the world is CF8 trying to say? Only a good deal if what you plan to run on it, will in fact run without issues on it or can easily be modified to run on it without issues. On 10/14/07, Rick Faircloth [EMAIL PROTECTED] wrote: I didn't purchase CF 8... I purchased a VPS for $70 per month that has beefy hardware and CF 8 installed... a good deal. Rick -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 1:22 PM To: CF-Talk Subject: Re: What in the world is CF8 trying to say? Just reread this, figured I'd clarify, I do not think scoping Image in this instance would fix it but certainly could try it. Was not aware of Image being used for something specific in 8, but guess perhaps scoping it might avoid a conflict with something else in the code on the page and not seen in the snippet. Probably the tag itself not liking the newer version of CF, honestly if I relied so heavily on a custom tag then I'd done some heavy testing with it prior to spending the money to upgrade versions. On 10/14/07, Aaron Rouse [EMAIL PROTECTED] wrote: A way around things like this without renaming things is to just scope it. We ran into a similar problem going to I think it was CF6 when part of some applications did #URL# and all we had to do was go in there and put queryName.URL and was fixed. Of course one could argue that the names of things should not be so generic which could hopefully prevent the possibility of referencing a variable name that later turns into a reserved word or is used for something else. Now in this particular case I am guessing Image is something returned by the CFX_JPG tag and that tag is putting it into the local variables scope, so could try referencing it as #Variables.Image.Link# and if that works then a mass find replace on #Image. with #Variables.Image. would probably fix all instances in the application(s). On 10/14/07, Terry [EMAIL PROTECTED] wrote: I had an issue similar to that when going from cf5 to cf7. Try changing your #link# to #linkx# as in my case with #url# it wouldn't allow it. Worth a try. -Original Message- From: Rick Faircloth [mailto: [EMAIL PROTECTED] Sent: Saturday, October 13, 2007 8:05 PM To: CF-Talk Subject: What in the world is CF8 trying to say? Error Occurred While Processing Request You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. Huh The code I was processing that threw the error is: 34 : div id=annPhoto 35 : CFX_JPG Source=#GAP##Get_Announcements.Image# 36 : Img Src=/_cache/#Image.Link# width=100 border=1 37 : /div I get this sinking feeling that it's because I'm trying to use the CFX_JPG tag from Efflare that I've been using with CF 4.5 for many years. Someone please tell CFX_JPG is compatible with CF8! I've used that tag on almost all of my site and I don't want to have to rewrite all that code! Rick ~| 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:291063 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is This Possible??
without knowing your type of rdbms used, exact data schema and how your 3 tables are linked to each other it is not possible to give you an exact solution. but in general, i would suspect that you will need to INNER JOIN your training and emplyoees tables and LEFT OUTER JOIN your employees table to completed trainings table, plus maybe use a CASE construct in your query, too... Azadi Leonard Boche wrote: Greetings, Here is the scenario the customer has presented. 3 Tables involved. Table 1 - Scheduled training for a year Table 2 - Employee information Table 3 - Completed training If I am understanding my customer and I believe I am, this is what they want to do. They want to run a query against the 3 previous mentioned tables, and output a list of the scheduled training showing a green check for completed and a red x for not completed. In my thinking, there will be nothing to evaluate in table 3 if they have not completed the training, since there will only be an entry for completed training. So if it is possible, how would it be accomplished? Thanks in advance Leonard ~| 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:291064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check File For Change
The inbuilt Java crc32 code might work well too: http://java.sun.com/j2se/1.4.2/docs/api/java/util/zip/CRC32.html On 10/15/07, Claude Schneegans [EMAIL PROTECTED] wrote: Even if the tag is not published I'd love to hear a little about the concepts of how it works, you can mail me off list if you'd prefer to keep it private. Actually, it does not use MD5 algorithm, but a CRC-32 checksum, which returns an 8 characters hexadecimal value. The probability of having two different files having the same value is near zero, especially if you consider only files having the same length. It is a C++ tag (Windows only), but much more efficient than using CF code. I'm sending the tag to you as a beta test. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Why would this query not return the correct data?
cfdump is returning the same wrong results... so strange. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 8:48 PM To: CF-Talk Subject: Re: Why would this query not return the correct data? On 10/14/07, Rick Faircloth [EMAIL PROTECTED] wrote: @ All... This is just nuts... I can run this sql in an editor and get the correct results: select distinct event_day from weekly_schedule order by event_day And the correct results are 1, 2, 4, 6. But if I run that same sql in a CF8 cfquery, scoping or not scoping every variable, all I get is 1, 1, 1, 1. This was working perfectly in CF 4.5. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery I even put just the query and output commands on a separate page and still get 1, 1, 1, 1. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop I just don't get it... Any more ideas, anyone? :o/ you tried dumping the query? cfdump will be your very best friend. cfdump var=#get_days# see if it's the query that's not returning the data you want, or if it's the loop that's outputting it incorrectly. -- Charlie Griefer ~| 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:291065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using array data to create a cfchart
Thanks - worked like a charm T On 10/15/07, Dale Fraser [EMAIL PROTECTED] wrote: Just loop over the array cfloop index=i from=1 to=#arrayLen(arrayPerson)# cfchartdata item=#arrayPerson[i]# value=#salesArray[i]# /cfloop Regards Dale Fraser http://learncf.com -Original Message- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: Monday, 15 October 2007 9:49 AM To: CF-Talk Subject: using array data to create a cfchart Hi there I have created two arrays which contain the data that I want to report on using cfchart. Basically I have a person name array and a person sales array. I am trying to work out how I can use the data in the arrays to produce the cfchart. Currently I have hard coded the information into the cfchart below, but this is limiting as this report will run for various retail stores and I dont know the sles people from each store. cfchart chartwidth=950 chartheight=500 xaxistitle=Sales Staff yaxistitle=Revenue show3d=Yes cfchartseries type=pie serieslabel=Sales Staff seriescolor=##ffcc00 cfchartdata item=Alan Ash value=2387 cfchartdata item=Brad Bloom value=7795 cfchartdata item=Colin Craig value=2487 cfchartdata item= Doug Douglas value=511 cfchartdata item=Ed Edwards value=1565 cfchartdata item=Frank Farina value=781 /cfchartseries /cfchart ~| 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:291066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Frameworks: Post vs. Get
How do you guys (and girls) verify that it's a post var? Check the Form scope? 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! ~| 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:291069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Frameworks: Post vs. Get
I suppose I don't understand why you'd care if the variable came from a form field as opposed to a URL variable. Either way you're going to have to make sure the user is an admin and they they have the rights to delete something. Data changes should not be triggered by GET requests. 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! ~| 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:291068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why would this query not return the correct data?
is this select distinct event_day from weekly_schedule order by event_day your actual sql statement, or just a 'simplified' version for the mailing list? Rick Faircloth wrote: @ All... This is just nuts... I can run this sql in an editor and get the correct results: select distinct event_day from weekly_schedule order by event_day And the correct results are 1, 2, 4, 6. But if I run that same sql in a CF8 cfquery, scoping or not scoping every variable, all I get is 1, 1, 1, 1. This was working perfectly in CF 4.5. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery I even put just the query and output commands on a separate page and still get 1, 1, 1, 1. cfquery name=get_days datasource=#dsn# select distinct event_day from weekly_schedule order by event_day /cfquery cfloop query=get_days cfoutput#get_days.event_day#/cfoutputbr / /cfloop I just don't get it... Any more ideas, anyone? :o/ Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, October 14, 2007 11:49 AM To: CF-Talk Subject: Re: Why would this query not return the correct data? cfloop query=get_days cfoutput#event_days#/cfoutput /cfloop This is an old CF bug: Inside a loop, a column name alone always comes from the first record. You must specify the query name to get the current row: cfloop query=get_days cfoutput#get_days.event_days#/cfoutput /cfloop -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:291067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Frameworks: Post vs. Get
Hi Matt! If you want to make sure it came from a form post, look in the FORM scope. :) -- Cheers! Michael David Sunday, October 14, 2007, 9:05:09 PM, you wrote: Okay, so you pick a framework - just about any framework; Fusebox, ColdBox, mach-ii, Model-Glue. These frameworks fold the form (post) and URL (get) variables into an event object (or attributes in the case of traditional FB apps). But let's say that you want to be sure that the variable came from a post - for instance deleting something in an admin panel. How do you guys (and girls) verify that it's a post var? Thanks, Matt ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291070 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: using array data to create a cfchart
Also, Not sure if you can control that array but if I was doing that id do it as an array of structs or even a query. Ie cfset person = arrayNew(1) / cfset person[1].name = Dale Fraser / cfset person[1].salary = 1 / Etc. Regards Dale Fraser http://learncf.com -Original Message- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: Monday, 15 October 2007 11:59 AM To: CF-Talk Subject: Re: using array data to create a cfchart Thanks - worked like a charm T On 10/15/07, Dale Fraser [EMAIL PROTECTED] wrote: Just loop over the array cfloop index=i from=1 to=#arrayLen(arrayPerson)# cfchartdata item=#arrayPerson[i]# value=#salesArray[i]# /cfloop Regards Dale Fraser http://learncf.com -Original Message- From: Peter Tanswell [mailto:[EMAIL PROTECTED] Sent: Monday, 15 October 2007 9:49 AM To: CF-Talk Subject: using array data to create a cfchart Hi there I have created two arrays which contain the data that I want to report on using cfchart. Basically I have a person name array and a person sales array. I am trying to work out how I can use the data in the arrays to produce the cfchart. Currently I have hard coded the information into the cfchart below, but this is limiting as this report will run for various retail stores and I dont know the sles people from each store. cfchart chartwidth=950 chartheight=500 xaxistitle=Sales Staff yaxistitle=Revenue show3d=Yes cfchartseries type=pie serieslabel=Sales Staff seriescolor=##ffcc00 cfchartdata item=Alan Ash value=2387 cfchartdata item=Brad Bloom value=7795 cfchartdata item=Colin Craig value=2487 cfchartdata item= Doug Douglas value=511 cfchartdata item=Ed Edwards value=1565 cfchartdata item=Frank Farina value=781 /cfchartseries /cfchart ~| 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:291071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLDAP - ADD Broken in ColdFusion 8?
Is anybody aware or heard of any bugs with CFLDAP in version 8? It started with a client installation, where I test just about everything before upgrading to CF8. I guess I forgot to check CFLDAP. I have the following code which executes just fine on CF7. !--- CUSTOM ADD GROUP CODE --- cfset request.ListName = test3 cfoutputcfsavecontent variable=IncAttributes objectClass=top |objectClass=group |cn=#Request.ListName# |name=#Request.ListName# |sAMAccountName=#Request.ListName# |groupType=-2147483646 /cfsavecontent /cfoutput cfldap action=add DN=CN=#Request.Listname#,OU=Groups,DC=Netname,DC=MyCompanys,DC=com attributes=#IncAttributes# delimiter=| server=10.1.1.67 port=389 username=netname\myname password= separator=~ But when I move the exact file to CF8, I get the following error: === An error has occured while trying to execute add :[LDAP: error code 19 - 2081: AtrErr: DSID-03151122, #1: 0: 2081: DSID-03151122, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 3 (cn) ]. One or more of the required attributes may be missing or incorrect or you do not have permissions to execute this operation on the server. == Any ideas on what to do? Thanks. Phil Hayes ~| 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:291072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLDAP - ADD Broken in ColdFusion 8?
We have a problem at work where CFLDAP for whatever reason will not communicate with our LDAP servers via the standard non-secure port. It will however work on the secure port so our fix currently has been to change all LDAP calls from the CF8 test server to use the secure port number. Offhand I am unsure what our LDAP servers are, pretty certain it is not Active Directory though. On 10/14/07, Philip Hayes [EMAIL PROTECTED] wrote: Is anybody aware or heard of any bugs with CFLDAP in version 8? It started with a client installation, where I test just about everything before upgrading to CF8. I guess I forgot to check CFLDAP. I have the following code which executes just fine on CF7. !--- CUSTOM ADD GROUP CODE --- cfset request.ListName = test3 cfoutputcfsavecontent variable=IncAttributes objectClass=top |objectClass=group |cn=#Request.ListName# |name=#Request.ListName# |sAMAccountName=#Request.ListName# |groupType=-2147483646 /cfsavecontent /cfoutput cfldap action=add DN=CN=#Request.Listname#,OU=Groups,DC=Netname,DC=MyCompanys,DC=com attributes=#IncAttributes# delimiter=| server=10.1.1.67 port=389 username=netname\myname password= separator=~ But when I move the exact file to CF8, I get the following error: === An error has occured while trying to execute add :[LDAP: error code 19 - 2081: AtrErr: DSID-03151122, #1: 0: 2081: DSID-03151122, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 3 (cn) ]. One or more of the required attributes may be missing or incorrect or you do not have permissions to execute this operation on the server. == Any ideas on what to do? Thanks. Phil Hayes ~| 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:291073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLDAP - ADD Broken in ColdFusion 8?
DISREGARD- They made a slight change that requires the CN attribute title to be capitalized in CF8. I had it as a small cn in the attributes section (which worked in CFX7). Thanks. Philip L. Hayes On Oct 14, 2007, at 11:38 PM, Philip Hayes wrote: Is anybody aware or heard of any bugs with CFLDAP in version 8? It started with a client installation, where I test just about everything before upgrading to CF8. I guess I forgot to check CFLDAP. I have the following code which executes just fine on CF7. !--- CUSTOM ADD GROUP CODE --- cfset request.ListName = test3 cfoutputcfsavecontent variable=IncAttributes objectClass=top |objectClass=group |cn=#Request.ListName# |name=#Request.ListName# |sAMAccountName=#Request.ListName# |groupType=-2147483646 /cfsavecontent /cfoutput cfldap action=add DN=CN=#Request.Listname#,OU=Groups,DC=Netname,DC=MyCompanys,DC=com attributes=#IncAttributes# delimiter=| server=10.1.1.67 port=389 username=netname\myname password= separator=~ But when I move the exact file to CF8, I get the following error: === An error has occured while trying to execute add :[LDAP: error code 19 - 2081: AtrErr: DSID-03151122, #1: 0: 2081: DSID-03151122, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 3 (cn) ]. One or more of the required attributes may be missing or incorrect or you do not have permissions to execute this operation on the server. == Any ideas on what to do? Thanks. Phil Hayes ~| 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-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Frameworks: Post vs. Get
I should have clarified my question. I completely realize that the 'form' and 'url' scopes (structs) still exist inside the various frameworks, so I know that I can directly reference them. However, in an OO world, you're technically not supposed to reference outside scopes. That is what is driving my question. For instance, I know that I can do this... cfif structKeyExists(form, myVar) !--- do my stuff --- /cfif but in an OO-like application, we're supposed to do something more along the lines of the following: cfif event.valueExists(myVar) !--- do my stuff --- /cfif That value may very well exist, but it could have come via a 'get', when I want to verify it is from a 'post'. So, maybe my question is better worded this way... Is it okay to directly reference the form scope in my OO-like controllers? Or is there another way for me to guarantee that the variable is a post vs. get? Matt ~| 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:291075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4