Why would this query not return the correct data?
Hi, all. Here's the query: select distinct event_days from weekly schedule order by event_day The data that should be returned if the query is looped is 1, 1, 1, 1, 2, 4, 6 However, when I run. #event_days# .. 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?
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 : > 35 : > 36 : > 37 : > > 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
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 : 35 : 36 : 37 : 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=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291021 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?
Could this be because CFX_JPG is a C++ tag? As soon as I changed the code to just a regular img tag, the error message disappeared... Rick > > "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 : > 35 : > 36 : > 37 : > > 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=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291022 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
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? ~| 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:291019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Exporting from ColdFuion to a Excel file
You could also just use the CF XML functions to write the file out in OpenXML format for Office. See http://openxmldeveloper.org/ for docs on the format. Hofo -- Howard Fore, [EMAIL PROTECTED] "In any moment of decision, the best thing you can do is the right thing, the next best thing is the wrong thing, and the worst thing you can do is nothing." - Theodore Roosevelt ~| 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:291018 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: connectstring in CF8
It's odd because I've been using jruby lately which uses jdbc connections and it allows you to dynamically set your datasources all day long. It's one feature of CF5 that I really miss. On 10/13/07, Dave Watts <[EMAIL PROTECTED]> wrote: > > Was there a problem with it? > > I seem to recall that JDBC didn't support it. > > Dave Watts, CTO, Fig Leaf Software > > > ~| 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:291020 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
Would you be able to compare the date/time of the upload to the date/time of the 'last update' for the file? This could shed some light on whether the file had been opened/re-saved since the upload. (however it would not show if it had been opened and 'not changed', only re-saved. 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: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 10:46 AM To: CF-Talk Subject: Check File For Change Hello Guys, I've got an application that receives files from an upload form, the user can then come and view/download those files again at a later date. When the file is uploaded I store the basic details, such as the files path and name into a database table, these entries are displayed to the user with a download link, once the link is clicked the file is then served to the client using the cfcontent tag. Now, I'm looking for a method to ensure that the file has not been modified on the file system since the user uploaded it, the chances of it being modified are exceptionally slim, I know, but the consequences of it having happened are quite serious, so I need to be sure. I'm thinking about implementing some form of MD5 check sum on the files, this sum will be saved to the database when the file is uploaded, and checked against a newly generated checksum before the file is served back to the user again. Does that sounds like a fair concept? How severally is it likely to hit performance? Is there a better option? I've also not done any of this MD5 work before, has anyone got any pointers on the best way to handle it? Thanks again, Rob ~| 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:291016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 : 35 : 36 : 37 : 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:291017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: connectstring in CF8
> Was there a problem with it? I seem to recall that JDBC didn't support it. Dave Watts, CTO, Fig Leaf Software ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291015 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: connectstring in CF8
Was there a problem with it? I have a web template I wrote and after I fill out this form with stuff like domain name, domain extension, admin username/password, and other stuff, it copies the master template folder to a new folder named after the domain, renames the database, rewrites 2 application.cfm files, and other things that are gathered by what is on the submitted form. Then I connect to the new database and using the dynamic connectstring and update, insert all the corresponding data. Then I do go into the Admin API and create a new datasource. Terry -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 2:29 PM To: CF-Talk Subject: RE: connectstring in CF8 > What replaces CF5's connectstring and dynamic > in CFQuery for CF8 as they have been > depreciated? There is no replacement, really. You can use the admin API to create a datasource, though. Dave Watts, CTO, Fig Leaf Software ~| 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:291014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: connectstring in CF8
> What replaces CF5's connectstring and dynamic > in CFQuery for CF8 as they have been > depreciated? There is no replacement, really. You can use the admin API to create a datasource, though. Dave Watts, CTO, Fig Leaf Software ~| 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:291013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Check File For Change
Hello Guys, I've got an application that receives files from an upload form, the user can then come and view/download those files again at a later date. When the file is uploaded I store the basic details, such as the files path and name into a database table, these entries are displayed to the user with a download link, once the link is clicked the file is then served to the client using the cfcontent tag. Now, I'm looking for a method to ensure that the file has not been modified on the file system since the user uploaded it, the chances of it being modified are exceptionally slim, I know, but the consequences of it having happened are quite serious, so I need to be sure. I'm thinking about implementing some form of MD5 check sum on the files, this sum will be saved to the database when the file is uploaded, and checked against a newly generated checksum before the file is served back to the user again. Does that sounds like a fair concept? How severally is it likely to hit performance? Is there a better option? I've also not done any of this MD5 work before, has anyone got any pointers on the best way to handle it? Thanks again, 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:291012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
connectstring in CF8
What replaces CF5's connectstring and dynamic in CFQuery for CF8 as they have been depreciated? Could you show me a simple example? Terry Troxel ~| 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:291011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Concat Issue
>>Right now I am getting an error that PubYear is not a valid column Then I'll try to make sure that PubYear is a valid column in table crAdInfo ;-) -- ___ 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:291010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to write this regex?
The strange this is that now I'm getting an extra "" generated in the final HTML... any ideas how this is happening? Website The first thing typed into the textfield is -Original Message- > From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 13, 2007 1:54 AM > To: CF-Talk > Subject: RE: How to write this regex? > > What you have is basically what I assumed you would need but you > explained > it backwards :-) > > > However, now I have to use whenever I want a carriage return. > That's what you need to do (and are now) > > > What about having it ignore the Chr(13) > You don't want to ignore it, you want to replace it with like > you are > doing now :-) > > Cheers > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 13, 2007 12:12 AM > To: CF-Talk > Subject: RE: How to write this regex? > > I ended up trying this > > #replace(noBreak(txt), "#Chr(13)#", "", "All")# > > and it works fine... is that what you > were getting at below? I didn't quite understand the "before and > after" > aspect. > > Rick > > > -Original Message- > > From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 12, 2007 11:19 PM > > To: CF-Talk > > Subject: RE: How to write this regex? > > > > Well for display, you would have to use a BR for a line break > anyway... > > unless its wrapped in pre tags... > > If you still need to... you could just replace #chr(13)##chr(10)# > with > > beforehand then put them back afterwards. > > > > Before replace(str, "#chr(13)##chr(10)#", "", "all") > > After replace(str, "", "#chr(13)##chr(10)#", "all") > > > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. > > Bobby Hartsfield > > http://acoderslife.com > > > > -Original Message- > > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 12, 2007 7:17 PM > > To: CF-Talk > > Subject: RE: How to write this regex? > > > > Ok, Bobby... that works, thanks! > > > > However, now I have to use whenever I want a carriage return. > > What about having it ignore the Chr(13) ? > > > > Rick > > > > > -Original Message- > > > From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] > > > Sent: Friday, October 12, 2007 4:16 PM > > > To: CF-Talk > > > Subject: RE: How to write this regex? > > > > > > Not the end result.. the end result is just... > > > > > > #noBreak(str)# > > > > > > :-) > > > > > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. > > > Bobby Hartsfield > > > http://acoderslife.com > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4