RE: producing large PDF documents
I think Windows even has problems with files over a certain size, not sure what that size is though. That's like Unix-sized files. A 10,000 page pdf is kinda nuts. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 5:32 PM To: CF-Talk Subject: RE: producing large PDF documents Let's think about this rationally, tell me if I'm wrong: I'm going to guess that a standard PDF of 3-4 pages has AT LEAST 500K 500K/page * 1 pages = 5,000,000K = 5GIGABYTES I don't know if a generated PDF is wholly loaded into memory or dynamically loaded, but 5Gb is HUGE. You need to just try to create ANY 5GB PDF to see if it's feasible to even ask the question if CF can handle it. My educated guess is that it can't. Matthew Small NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217161 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR)
There's pretty extensive documentation on using the Print Job class in MX 2004. Its not that hard to use actually. You just print a movie clip symbol using the Print job class - some info in the chattyfig.figleaf.com archives for the Flashcoders list and also online resources like Macromedia.com Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 10:26 AM To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) The problem I have Mark is that I am not very clued up about flash, I really wouldn't know where to start :-( -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 15:03 To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) Andy, You might be better off to just create a printed report FROM your flash movie. It's kind of painful - but flash does allow for very granular control over printing. -Mark -Original Message- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 4:45 AM To: CF-Talk Subject: RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) As part of a reporting process I have a movie that allows the user to drag drop different icons onto the stage to form a diagram of player movement during a football match. This data is then saved into my database as XML. There is an option to be able to print this report. This is where I would have liked to use cfdocument to generate a PDF file. The problem is that I need to load the swf file and populate it with the xml data from the database to recreate the original user diagram. I am interested in your idea of embedding cfdocument but have no idea how to do what you suggest. :-( ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR)
Check out Ming (PHP). This can create .swfs on the fly. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Andy Mcshane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 23, 2005 9:50 AM To: CF-Talk Subject: DESPERATE!!! Any way to embed SWF within CFDOCUMENT (PREVIOUSLY CFDOCUMENT ERROR) Can anybody help me, I am at breaking point here. I know now that Live Docs state that CFDOCUMENT does not support embedding SWF files as it cannot render them but I am desperately hoping that someone may have found a clever way to get way around this or anybody know how to output a SWF as an image file on the fly (I am not very savvy with Flash!). I am really desperate for something because if I cannot find a way to make this happen then I will have to abandon all the work that I have done over the last 3 weeks (flash forms, cfdocument, etc), revert back to CFMX and start writing again! The CFDOCUMENT was the main thing that got me to upgrade and now I can't use it! I could just scream!!! Anybody, please? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216047 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Parsing iTunes xml file
My iTunes gives an icon with an explanation point when a file is missing. Don't know about duplicates, but can't you see that using your file browser? Or by sorting categories in iTunes? Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 11:40 AM To: CF-Talk Subject: RE: Parsing iTunes xml file Doesn't iTunes do this for you? Or EpPhod? -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: 19 August 2005 16:35 To: CF-Talk Subject: Parsing iTunes xml file First I know this is the wrong tool for the job, but I wanted to try it anyway. I have a 10mb iTunes xml file that I want to parse so I can figure out what songs are missing and what songs are duplicates. First snagusing blue dragon, cffile craps out on read with a null pointer exception. Is there a size limit to cffile? Or is there a setting that I can change to allow it to read bigger files? Thanks -- Marlon A mulatto, an albino, a mosquito, my libido ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215783 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
Nope - Flash player 8 works great for me in Firefox. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 10:47 AM To: CF-Talk Subject: Re: Studio 8 announced I clicked on this link http://www.macromedia.com/software/studio/experience/ and upgraded firefox to the flash player 8. Now Flash doesn't work at all in firefox. F'ing great. Anyone else have this problem? NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214016 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
doesn't really look worth the upgrade cost ... Are you insane? $399 for Dreamweaver 8, Fireworks 8, Flash Professional 8, Contribute 3, Flashpaper 2? $399 is a STEAL. Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214021 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
Sure, maybe if all you do is Coldfusion, but I'm surprised you don't like some of the new features of Dreamweaver at least. Maybe its not for you then. Me, I use all the products in the studio almost daily and the new features are really fantastic from my point of view. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 11:16 AM To: CF-Talk Subject: Re: Studio 8 announced On Monday 08 August 2005 15:58, Merrill, Jason wrote: doesn't really look worth the upgrade cost ... Are you insane? $399 for Dreamweaver 8, Yeah, but what new features are their that you need ? None by the looks of it... -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214030 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
And that's the upgrade cost, not the cost of the suite new. Right - but you said, not really worth the UPGRADE cost... If you think $399 is a lot to pay for a software suite upgrade, you might be in the wrong business. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: mac jordan [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 11:16 AM To: CF-Talk Subject: Re: Studio 8 announced On 8/8/05, Merrill, Jason [EMAIL PROTECTED] wrote: doesn't really look worth the upgrade cost ... Are you insane? $399 for Dreamweaver 8, Fireworks 8, Flash Professional 8, Contribute 3, Flashpaper 2? $399 is a STEAL. I can't see it offering me $399 worth - and I bet it'll be a lot more in the UK (where I am). Macromedia's $/£ exchange rate is appalling. And that's the upgrade cost, not the cost of the suite new. -- mac jordan home: www.kestrel.org http://www.kestrel.org work: www.webhorus.net http://www.webhorus.net them: www.jordan-cats.org http://www.jordan-cats.org ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214031 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
Performance of what? The development tool I don't see what you're getting at. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 11:13 AM To: CF-Talk Subject: RE: Studio 8 announced I think one of the off putting things is that you get better performance and stability from Eclipse (which is slowly eating up the DW market) -Original Message- From: Merrill, Jason [mailto:[EMAIL PROTECTED] Sent: 08 August 2005 16:19 To: CF-Talk Subject: RE: Studio 8 announced Sure, maybe if all you do is Coldfusion, but I'm surprised you don't like some of the new features of Dreamweaver at least. Maybe its not for you then. Me, I use all the products in the studio almost daily and the new features are really fantastic from my point of view. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 11:16 AM To: CF-Talk Subject: Re: Studio 8 announced On Monday 08 August 2005 15:58, Merrill, Jason wrote: doesn't really look worth the upgrade cost ... Are you insane? $399 for Dreamweaver 8, Yeah, but what new features are their that you need ? None by the looks of it... -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214034 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
I've never thought the performance of the actual authoring tool was ever much of a problem, I usually am thinking more about the performance of the end product. Dreamweaver itself has never given me much of a performance problem, though maybe what you do with it is very different than what I do with it. Interesting. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 11:32 AM To: CF-Talk Subject: RE: Studio 8 announced Yes the tool- DW is a bloatware tool. Like some others on this lists, I had/have used it since version 0.9 but I can honestly say that I could count on one hand the amount of times I have opened it in the last month - there really is no need for it - Eclipse with VSS and CFEclipse plugins serves me better than DW could. -Original Message- From: Merrill, Jason [mailto:[EMAIL PROTECTED] Sent: 08 August 2005 16:32 To: CF-Talk Subject: RE: Studio 8 announced Performance of what? The development tool I don't see what you're getting at. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 11:13 AM To: CF-Talk Subject: RE: Studio 8 announced I think one of the off putting things is that you get better performance and stability from Eclipse (which is slowly eating up the DW market) -Original Message- From: Merrill, Jason [mailto:[EMAIL PROTECTED] Sent: 08 August 2005 16:19 To: CF-Talk Subject: RE: Studio 8 announced Sure, maybe if all you do is Coldfusion, but I'm surprised you don't like some of the new features of Dreamweaver at least. Maybe its not for you then. Me, I use all the products in the studio almost daily and the new features are really fantastic from my point of view. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 11:16 AM To: CF-Talk Subject: Re: Studio 8 announced On Monday 08 August 2005 15:58, Merrill, Jason wrote: doesn't really look worth the upgrade cost ... Are you insane? $399 for Dreamweaver 8, Yeah, but what new features are their that you need ? None by the looks of it... -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214043 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
I drive a Toyota and ironically eat green beans - feel free to contact me off-list about the various angles on that. (in other words, I agree this thread is getting pointless and needs to end) Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 3:22 PM To: CF-Talk Subject: Re: Studio 8 announced It doesn't ruin my day to know that someone drives Toyota, but I don't happen to like them and therefore like to rail on people who do. It doesn't ruin my day to know that some people don't like green beans either, but when someone tells me that they don't, I'm likely to go into the same kind of argument. I'm sure you can think of some subject on which you do the same thing. --Ferg NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214070 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Open Lazlo vs. Flex
You think Flex is cool now, read this: http://weblogs.macromedia.com/mesh/archives/2005/08/will_zorn_requi.cfm Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213744 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bringing family to MAX?
Just one wife? Why not bring all of them? Oh wait, it's not in Utah this year... :-) John Burns Certified Advanced ColdFusion MX Developer For everyone's sake, I would appreciate some religious sensitivity on this list. If you were an African American, Gay, or Jewish, I certainly wouldn't make a joke about that. Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213771 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bringing family to MAX?
No problem, thanks John. I appreciate your kind response. :) Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 3:34 PM To: CF-Talk Subject: RE: Bringing family to MAX? My bad. I appreciate you bringing that up. If you knew me you'd know I make fun of everyone equally, including myself and my beliefs. I do realize, however, that on a list it's tough to know intentions and there are all kinds of audiences listening. My apologies to any who were offended. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Merrill, Jason [mailto:[EMAIL PROTECTED] Sent: Thursday, August 04, 2005 2:11 PM To: CF-Talk Subject: RE: Bringing family to MAX? Just one wife? Why not bring all of them? Oh wait, it's not in Utah this year... :-) John Burns Certified Advanced ColdFusion MX Developer For everyone's sake, I would appreciate some religious sensitivity on this list. If you were an African American, Gay, or Jewish, I certainly wouldn't make a joke about that. Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213822 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Data driven local maps
I'll second that recommendation for using an ESRI product. They are #1 in GIS software. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, August 01, 2005 7:36 PM To: CF-Talk Subject: Re: OT: Data driven local maps Jim McAtee wrote: They'd also need to be generated from only street addresses, since we don't have lat/long coordinates for any of the locations. geocoding, google maps don't allow this currently though you could use 3rd party (but free for non-commerical use) geocoder.us--it's based on tiger data can be a bit messy/wrong/dated. Any ideas for server-based software that could accomplish this? http://www.esri.com/software/awspublicservices/ free for non-commerical use. has geocoding, reverse geocoding, routing, etc. a bit easier to save off images as well. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213458 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML format for menus
Another advantage to XML is it can be shared between different applications. For example, if you wanted to build the same thing in Flash, the same file could be used to describe the menu system. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 2:54 PM To: CF-Talk Subject: Re: XML format for menus Another advantage is XSLT transformations. That was the primary reason we did it. Simple to have have a single XML doc that describes your menu, and then run it through an XSLT stylesheet to generate the same menu with various look and feels. It's also potentially easier to deal with, because an array of structs has to be persisted somehow, where as an XML file is just a file on the filesystem. cheers, barneyb On 7/29/05, Charlie Griefer [EMAIL PROTECTED] wrote: curious...what's the advantage of using XML versus just storing an an array of structs? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213304 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple query question
I surprised nobody knows the answer to this question. Anyone? Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Merrill, Jason [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 26, 2005 12:06 PM To: CF-Talk Subject: Simple query question How do I implement a simple query to search all the field values of a table for a value - basically, I need to check to see if the user name the person entered already exists in the database. Something like a SELECT WHERE and then a cfif value exists from the query return? Thanks. Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212958 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple query question
Huh. Yeah, I have no idea what you just said. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 9:29 AM To: CF-Talk Subject: RE: Simple query question You could also do this inline with an SP. -Original Message- From: Merrill, Jason [mailto:[EMAIL PROTECTED] Sent: 27 July 2005 14:34 To: CF-Talk Subject: RE: Simple query question I surprised nobody knows the answer to this question. Anyone? Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Merrill, Jason [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 26, 2005 12:06 PM To: CF-Talk Subject: Simple query question How do I implement a simple query to search all the field values of a table for a value - basically, I need to check to see if the user name the person entered already exists in the database. Something like a SELECT WHERE and then a cfif value exists from the query return? Thanks. Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212966 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple query question
Thanks Matthew, that's the kind of example I was looking for. I'll see if I can get that to work. Thanks. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 9:56 AM To: CF-Talk Subject: RE: Simple query question cfquery name=query Select count (*) as cnt from table where username = '#form.username#' /cfquery cfif query.cnt gt 0 Do something /cfif Matthew Small -Original Message- From: Merrill, Jason [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 9:48 AM To: CF-Talk Subject: RE: Simple query question Huh. Yeah, I have no idea what you just said. Jason Merrill | E-Learning Solutions | icfconsulting.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212972 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Simple query question
How do I implement a simple query to search all the field values of a table for a value - basically, I need to check to see if the user name the person entered already exists in the database. Something like a SELECT WHERE and then a cfif value exists from the query return? Thanks. Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212836 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Looping over query assistance
I want to get all the fields matching the userid and return and array of the matching values. So in my component, I have the following (see comments in the middle) : cffunction name=getCourseData access=remote cfargument name=R_userName type=string required=yes cfquery name=getCourses datasource=learnline SELECT title FROM courses WHERE userid = cfqueryparam cfsqltype=CF_SQL_STRING value=#Arguments.R_userName# /cfquery !---the following is the part that needs help (the code above works fine)--- cfset courses=ArrayNew(1) cfset i = 0!--- probably not the best way to do the loop--- cfloop query=getCourses courses[i] = #getCourses.title# cfset i = i + 1 /cfloop cfreturn #courses# /cffunction If I instead just return: #getCourses.title# It works, I can get the first title that matches the userid in the query, but if I do the loop like that, and I just return #courses# then it returns an empty array. What am I doing wrong? Fairly new to CF, so any examples are welcome. Thanks. Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212411 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Looping over query assistance
Perfect, thank you. Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Eddie Awad [mailto:[EMAIL PROTECTED] Sent: Thursday, July 21, 2005 12:36 PM To: CF-Talk Subject: Re: Looping over query assistance On 7/21/05, Merrill, Jason [EMAIL PROTECTED] wrote: I want to get all the fields matching the userid and return and array of the matching values. ... #getCourses.title# It works, I can get the first title that matches the userid in the query, but if I do the loop like that, and I just return #courses# then it returns an empty array. What am I doing wrong? use listToArray(valueList(getCourses.title)) -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212420 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query error
Dave, thanks for your response. See my responses below:
My guess is that one of the following is true:
1. You don't have a datasource called coursesDB.
I do. I've been accessing it and making modifications to it. It seems
only to mess up when I try and do this UPDATE type query.
2. The user account used by CF doesn't have rights to update the
Lessons
table.
It does.
3. The Lessons table belongs to another user account, so your user
account
can't see it without specifying the username explicitly (UPDATE
otherusername.Lessons ...).
Nope.
4. The table is not in fact named Lessons.
It is.
5. The table doesn't have a field called Lesson.
It does.
6. The Lesson field doesn't contain a VARCHAR.
It does. at least in Access it designed to be field data type Text
which Dreamweaver displays as VARCHAR.
7. The table doesn't have a field called ID.
It does.
8. The ID field doesn't contain an INTEGER.
It does - at least in Access it designed to be field data type Number.
9. You're passing the wrong datatype to one of the fields - my guess
would
be that Arguments.row should be a number instead of a string.
It does, at least as far as I know how Flash Remoting works, I am
sending like this:
var pc:PendingCall = updateDatabaseService.recieveData({lesson:How to
Dismantle an Atomic Bomb, row:9});
where 9 should be an integer, unless Remoting still sends it as a
string. If so, it seems there is no way to be sure it's being sent as a
number from Flash, is there a way in CF to convert it from a string type
(if that's really how its being sent) to type numeric? Or at least
find out what data type its being received as?
Thanks for your help.
Jason Merrill | E-Learning Solutions | icfconsulting.com
NOTICE:
This message is for the designated recipient only and may contain privileged or
confidential information. If you have received it in error, please notify the
sender immediately and delete the original. Any other use of this e-mail by you
is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211974
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query error
can you post a more informative error message? OK - I put in some pseudo variables instead of using the ones from Flash Remoting and got this when I call the CFC from a CFM: -- Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The table 'Lessons' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically. The error occurred in C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2 9 : UPDATE Lessons 10 :SET Lesson = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#lesson# 11 :WHERE ID = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#row# 12 : /cfquery 13 : cfreturn #lesson# -- Not sure how its being used by someone else, this is all being done locally on my workstation and only have ColdFusion accessing the access database. I am also only using the Developer edition of ColdFusion MX 7, but that shouldn't matter because you get 2 IP addresses to connect anyway, right? What's going on here? Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Friday, July 15, 2005 10:28 AM To: CF-Talk Subject: Re: Query error can you post a more informative error message? Also, test it without the queryparams. Also, maybe just build the SQL in a string and email it to yourself to see if the SQL and inputed arguments are actually coming in correct from Flash. Aside fro this I'll not that you should VAR scope your local variables too. :) DK On 7/14/05, Merrill, Jason [EMAIL PROTECTED] wrote: Any idea why I'm getting an Error Executing Database Query. With this? I can take out the query and return lesson and row just fine. Lesson and ID in the table are varchar and integer type fields respectively. cfcomponent cffunction name=recieveData access=remote cfargument name=lesson type=string required=yes cfargument name=row type=string required=yes cfquery name=updateDB datasource=coursesDB UPDATE Lessons SET Lesson = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Arguments.lesson# WHERE ID = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#Arguments.row# /cfquery cfreturn #Arguments.lesson# !---Test. works fine when cfquery removed--- /cffunction /cfcomponent Thanks. Jason Merrill | E-Learning Solutions | icfconsulting.comhttp://icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query error
Yeah, thanks - I just caught that and fixed it to specify numeric - thanks, but the error remains - I just posted a more detailed error in this thread - might be posted before or after this one... Jason Merrill | E-Learning Solutions | icfconsulting.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, July 15, 2005 11:14 AM To: CF-Talk Subject: RE: Query error where 9 should be an integer, unless Remoting still sends it as a string. If so, it seems there is no way to be sure it's being sent as a number from Flash, is there a way in CF to convert it from a string type (if that's really how its being sent) to type numeric? Or at least find out what data type its being received as? Well, CF is more or less typeless*, but you can specify the expected data type in your CFARGUMENT tag. If I recall correctly, you're specifying a string when you really expect a number. This will result in your CFC throwing an exception if the data can't be cast as a number. I really don't see why this would make a difference in this case, assuming that you actually are passing a numeric value, but I'd recommend that you explicitly specify the data types you expect your arguments to receive. * This is an oversimplification, but still a useful way to think of CF. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211997 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query error
can you post a more informative error message? OK - I put in some pseudo variables instead of using the ones from Flash Remoting and got this when I call the CFC from a CFM: -- Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The table 'Lessons' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically. The error occurred in C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11 Called from C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2 9 : UPDATE Lessons 10 :SET Lesson = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#lesson# 11 :WHERE ID = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#row# 12 : /cfquery 13 : cfreturn #lesson# -- Not sure how its being used by someone else, this is all being done locally on my workstation and only have ColdFusion accessing the access database. I am also only using the Developer edition of ColdFusion MX 7, but that shouldn't matter because you get 2 IP addresses to connect anyway, right? What's going on here? Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211998 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query error
Do you have the Access DB open on your workstation? Oops! That seemed to be it. I feel like an idiot. I was doing updates previously with the database without a problem when the file was open in access. It only popped up now when I did the UPDATE for some reason. Thanks Michael, Dave, Doug, Anthony, Clint! Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Array access/query problem
I am using Flash remoting to send an array to a CFC - works fine, until I try a query. I have been able to connect to the datasource and retrieve values in another CFC with no problem. Why am I getting a Error Executing Database Query error in Flash? The part that I don't understand is how to reference elements of an array (called myArray)that is being send to the CFC - this part of the query is probably the problem: VALUES (#myArray[i]#) But not sure how to fix. I can output myArray in the CFC and it works fine. I can also cfreturn the array to Flash and it also works. Here is the complete code: cfcomponent cffunction name=recieveData access=remote cfargument name=myArray type=array required=yes cfset mLen = ArrayLen(myArray) cfloop from=1 to=#mLen# index=i cfquery name=updateDB datasource=coursesDB INSERT INTO Lessons(ID, Lesson, Required, Time) VALUES (#myArray[i]#) /cfquery /cfloop cfreturn Success /cffunction /cfcomponent Thanks for any help! Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211890 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Array access/query problem
Thanks Dave, I got it working. Now I'm trying to send a complex data
type (flash object) from Flash to a CFC.
From Flash using Remoting:
myObj:Object = {data:[{count:23, title:Bananas}, {count:10,
title:Apples}]};
I thought maybe using struct or structure as the argument type in my
CFC function (i.e. cffunctioncfargument type=struct..etc) and it
would accept this, but it does not. I expected to be able to access
Apples in the CFC like this:
#myObj.data[1].title#
But that does not work. I also tried named arrays in Flash with no
luck. Ideas?
Jason Merrill | E-Learning Solutions | icfconsulting.com
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 14, 2005 3:24 PM
To: CF-Talk
Subject: RE: Array access/query problem
I am using Flash remoting to send an array to a CFC - works
fine, until I try a query. I have been able to connect to the
datasource and retrieve values in another CFC with no problem.
Why am I getting a Error Executing Database Query error in Flash?
The part that I don't understand is how to reference elements of an
array (called myArray)that is being send to the CFC - this part of
the
query is probably the problem:
VALUES (#myArray[i]#)
But not sure how to fix. I can output myArray in the CFC and it
works
fine. I can also cfreturn the array to Flash and it also works.
Here is the complete code:
cfcomponent
cffunction name=recieveData access=remote
cfargument name=myArray type=array required=yes
cfset mLen = ArrayLen(myArray)
cfloop from=1 to=#mLen# index=i
cfquery name=updateDB
datasource=coursesDB
INSERT INTO Lessons(ID, Lesson,
Required, Time)
VALUES (#myArray[i]#)
/cfquery
/cfloop
cfreturn Success
/cffunction
/cfcomponent
The reason you're getting that error is because you have more fields
than
values in your INSERT statement:
INSERT INTO table (col1, col2, col3)
VALUES (val1, val2, val3)
There's nothing wrong with how you're referencing the array except
that you
should explicitly scope it - Arguments.myArray. In addition, when you
create
variables within your functions, they should be local variables in
most
cases:
cfset var mLen = ArrayLen(Arguments.myArray)
In your case, you don't even need the local variable - just use
ArrayLen(Arguments.myArray) when you want to find the length of the
array,
since you only need to find the value once.
Finally, I suspect that your array contains the three values for the
four
fields ID, Lesson, Required and Time, so you'll want your array values
to be
placed within the VALUES of your query rather than looping over the
query
itself. You'll also want to use CFQUERYPARAM to build a prepared
statement:
cfargument ...
cfset var updateDB = !--- you want function variables to be
local ---
cfquery name=updateDB datasource=coursesDB
INSERT INTO Lessons (ID, Lesson, Required, Time)
VALUES(cfqueryparam cfsqltype=cf_sql_integer
value=#Arguments.myArray[1]#,
cfqueryparam cfsqltype=cf_sql_integer
value=#Arguments.myArray[2]#,
cfqueryparam cfsqltype=cf_sql_integer
value=#Arguments.myArray[3]#,
cfqueryparam cfsqltype=cf_sql_integer
value=#Arguments.myArray[4]#)
/cfquery
In the above example, I didn't know what datatypes to use, so I just
assumed
they're all integers. If they're not, change the CFSQLTYPE attributes
appropriately.
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!
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211905
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Array access/query problem
Thanks Dave!
Now I'm on to this: Any info on using Remoting to send complex data
types to a CFC?
i.e. From Flash:
myObj:Object = {data:[{count:23, title:Bananas}, {count:10,
title:Apples}]};
Jason Merrill | E-Learning Solutions | icfconsulting.com
NOTICE:
This message is for the designated recipient only and may contain privileged or
confidential information. If you have received it in error, please notify the
sender immediately and delete the original. Any other use of this e-mail by you
is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211906
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Playing with Flash Data Access
ColdFusion 7 comes with Remoting already up. I think ColdFusion 6
too...
Jason Merrill | E-Learning Solutions | icfconsulting.com
-Original Message-
From: SStewart [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 14, 2005 4:08 PM
To: CF-Talk
Subject: RE: Playing with Flash Data Access
Because I'm just starting to dig into this. and I didn't set the
servers up so I'm
not sure if remoting is even installed...
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated
sheep
carcass... and thus the Pipes were born
the Scottish Rogues
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 14, 2005 04:01 pm
To: CF-Talk
Subject: Re: Playing with Flash Data Access
Importance: Low
I have to ask... why not use Flash Remoting, much faster than using
web services...
On 7/14/05, SStewart [EMAIL PROTECTED] wrote:
I'm just in the beginning stages of playing with Flash as a UI
builder. I've set up
a web services datasource and a data grid, when I run the data grid I
get the
following errors. There doesn't seem to be anyplace to correct them
ideas/
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 6: '}'
or ','
expected
{component: application.data.Concrete Field
ReportsReceiveWebServiceConnector, property: results, event:
[result]},
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 7: '}'
or ','
expected
{component: application.data.Concrete Field ReportsDataSet,
property:
dataProvider},
**Error** Scene=Scene 1, layer=MM_Screen_Layer, frame=1:Line 9:
Syntax error.
false);
Total ActionScript Errors: 3 Reported Errors: 3
Error opening URL
http://localhost/docwf/navigation/qry_RptsbyStatusDate.cfc
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
Many thousands of years ago, a blue faced Pict stepped on a bloated
sheep
carcass... and thus the Pipes were born
the Scottish Rogues
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date:
07/14/2005
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211913
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Query error
Any idea why I'm getting an Error Executing Database Query. With this? I can take out the query and return lesson and row just fine. Lesson and ID in the table are varchar and integer type fields respectively. cfcomponent cffunction name=recieveData access=remote cfargument name=lesson type=string required=yes cfargument name=row type=string required=yes cfquery name=updateDB datasource=coursesDB UPDATE Lessons SET Lesson = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#Arguments.lesson# WHERE ID = cfqueryparam cfsqltype=CF_SQL_INTEGER value=#Arguments.row# /cfquery cfreturn #Arguments.lesson# !---Test. works fine when cfquery removed--- /cffunction /cfcomponent Thanks. Jason Merrill | E-Learning Solutions | icfconsulting.com NOTICE: This message is for the designated recipient only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this e-mail by you is prohibited. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211932 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Simple XML cfscript question
New here - Flash-guy, also new to ColdFusion and SQL (CF-Newbies doesn't
seem to be populated with anybody)
(...and before I ask the question, I'm also looking for a cleaner way to
write this, like not having to hard code the field column names)
How do I insert each subsequent record from a database into my XML file?
I got this working, but it of course repeats the first record in each
child node,which is not what I want.
cfquery name=qAllLessons datasource=coursesDB
SELECT * FROM Lessons
/cfquery
cfquery name=qLessons datasource=coursesDB
SELECT ID, Lesson, Required, Time FROM Lessons
/cfquery
cfscript
lrXML = XmlNew();
lrXML.xmlRoot = XmlElemNew(lrXML,lData);
for (i = 1; i LTE #qAllLessons.RecordCount#; i = i + 1){
lrXML.lData.XmlChildren[i] =
XmlElemNew(lrXML,Content);
lrXML.lData.XmlChildren[i].XmlChildren[1] =
XmlElemNew(lrXML,ID);
lrXML.lData.XmlChildren[i].XmlChildren[2] =
XmlElemNew(lrXML,Lesson);
lrXML.lData.XmlChildren[i].XmlChildren[3] =
XmlElemNew(lrXML,Required);
lrXML.lData.XmlChildren[i].XmlChildren[4] =
XmlElemNew(lrXML,Time);
lrXML.lData.XmlChildren[i].ID.XmlText = #qLessons.ID#;
lrXML.lData.XmlChildren[i].Lesson.XmlText =
#qLessons.Lesson#;
lrXML.lData.XmlChildren[i].Required.XmlText =
#qLessons.Required#;
lrXML.lData.XmlChildren[i].Time.XmlText =
#qLessons.Time#;
}
/cfscript
cfdump var=#lrXML#
cfset XMLText = ToString(lrXML)
cffile action=write
file=C:\CFusionMX7\wwwroot\com\macromedia\test\myTextXml_3.xml
output=#XMLText#
This outputs:
?xml version=1.0 encoding=UTF-8 ?
lData
Content
ID1/ID
LessonbIntroduction to Spatial Analysis/Lesson
RequiredTrue/Required
Time2/Time
/Content
Content
ID1/ID
LessonbIntroduction to Spatial Analysis/Lesson
RequiredTrue/Required
Time2/Time
/Content
...etc...
How do I write the query to insert each record into each subsequent node
instead of inserting the first record each time?
Or, is there a cfscript out there that will take a table and convert its
contents to XML with the nodes being named what the field names are
named? I have searched the web, but haven't found one yet.
Thanks.
Jason Merrill | E-Learning Solutions | icfconsulting.com
NOTICE:
This message is for the designated recipient only and may contain privileged or
confidential information. If you have received it in error, please notify the
sender immediately and delete the original. Any other use of this e-mail by you
is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211750
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple XML cfscript question
Well, I got it working, didn't realize I could use the Array access
operator like I can in Flash and Javascript - gotta love ECMA.
Here is the script, but how can I make it cleaner - i.e. get names of
fields and then loop over those?
cfscript
lrXML = XmlNew();
lrXML.xmlRoot = XmlElemNew(lrXML,lData);
for (i = 1; i LTE #qAllLessons.RecordCount#; i = i + 1){
lrXML.lData.XmlChildren[i] =
XmlElemNew(lrXML,Content);
lrXML.lData.XmlChildren[i].XmlChildren[1] =
XmlElemNew(lrXML,ID);
lrXML.lData.XmlChildren[i].XmlChildren[2] =
XmlElemNew(lrXML,Lesson);
lrXML.lData.XmlChildren[i].XmlChildren[3] =
XmlElemNew(lrXML,Required);
lrXML.lData.XmlChildren[i].XmlChildren[4] =
XmlElemNew(lrXML,Time);
lrXML.lData.XmlChildren[i].ID.XmlText =
#qLessons.ID[i]#;
lrXML.lData.XmlChildren[i].Lesson.XmlText =
#qLessons.Lesson[i]#;
lrXML.lData.XmlChildren[i].Required.XmlText =
#qLessons.Required[i]#;
lrXML.lData.XmlChildren[i].Time.XmlText =
#qLessons.Time[i]#;
}
/cfscript
Jason Merrill | E-Learning Solutions | icfconsulting.com
-Original Message-
From: Merrill, Jason [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 13, 2005 11:31 AM
To: CF-Talk
Subject: Simple XML cfscript question
New here - Flash-guy, also new to ColdFusion and SQL (CF-Newbies
doesn't
seem to be populated with anybody)
(...and before I ask the question, I'm also looking for a cleaner way
to
write this, like not having to hard code the field column names)
How do I insert each subsequent record from a database into my XML
file?
I got this working, but it of course repeats the first record in each
child node,which is not what I want.
cfquery name=qAllLessons datasource=coursesDB
SELECT * FROM Lessons
/cfquery
cfquery name=qLessons datasource=coursesDB
SELECT ID, Lesson, Required, Time FROM Lessons
/cfquery
cfscript
lrXML = XmlNew();
lrXML.xmlRoot = XmlElemNew(lrXML,lData);
for (i = 1; i LTE #qAllLessons.RecordCount#; i = i + 1){
lrXML.lData.XmlChildren[i] =
XmlElemNew(lrXML,Content);
lrXML.lData.XmlChildren[i].XmlChildren[1] =
XmlElemNew(lrXML,ID);
lrXML.lData.XmlChildren[i].XmlChildren[2] =
XmlElemNew(lrXML,Lesson);
lrXML.lData.XmlChildren[i].XmlChildren[3] =
XmlElemNew(lrXML,Required);
lrXML.lData.XmlChildren[i].XmlChildren[4] =
XmlElemNew(lrXML,Time);
lrXML.lData.XmlChildren[i].ID.XmlText = #qLessons.ID#;
lrXML.lData.XmlChildren[i].Lesson.XmlText =
#qLessons.Lesson#;
lrXML.lData.XmlChildren[i].Required.XmlText =
#qLessons.Required#;
lrXML.lData.XmlChildren[i].Time.XmlText =
#qLessons.Time#;
}
/cfscript
cfdump var=#lrXML#
cfset XMLText = ToString(lrXML)
cffile action=write
file=C:\CFusionMX7\wwwroot\com\macromedia\test\myTextXml_3.xml
output=#XMLText#
This outputs:
?xml version=1.0 encoding=UTF-8 ?
lData
Content
ID1/ID
LessonbIntroduction to Spatial Analysis/Lesson
RequiredTrue/Required
Time2/Time
/Content
Content
ID1/ID
LessonbIntroduction to Spatial Analysis/Lesson
RequiredTrue/Required
Time2/Time
/Content
...etc...
How do I write the query to insert each record into each subsequent
node
instead of inserting the first record each time?
Or, is there a cfscript out there that will take a table and convert
its
contents to XML with the nodes being named what the field names are
named? I have searched the web, but haven't found one yet.
Thanks.
Jason Merrill | E-Learning Solutions | icfconsulting.com
NOTICE:
This message is for the designated recipient only and may contain
privileged or
confidential information. If you have received it in error, please
notify the sender
immediately and delete the original. Any other use of this e-mail by
you is
prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211754
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple XML cfscript question
Well, I got it working, didn't realize I could use the Array access
operator like I can in Actionscript and Javascript (ECMA praise here?).
Here is the script, but how can I make it cleaner so not as much is
hardcoded - i.e. get names of all the fields and then loop over those x
number of times?
cfscript
lrXML = XmlNew();
lrXML.xmlRoot = XmlElemNew(lrXML,lData);
for (i = 1; i LTE #qAllLessons.RecordCount#; i = i + 1){
lrXML.lData.XmlChildren[i] =
XmlElemNew(lrXML,Content);
lrXML.lData.XmlChildren[i].XmlChildren[1] =
XmlElemNew(lrXML,ID);
lrXML.lData.XmlChildren[i].XmlChildren[2] =
XmlElemNew(lrXML,Lesson);
lrXML.lData.XmlChildren[i].XmlChildren[3] =
XmlElemNew(lrXML,Required);
lrXML.lData.XmlChildren[i].XmlChildren[4] =
XmlElemNew(lrXML,Time);
lrXML.lData.XmlChildren[i].ID.XmlText =
#qLessons.ID[i]#;
lrXML.lData.XmlChildren[i].Lesson.XmlText =
#qLessons.Lesson[i]#;
lrXML.lData.XmlChildren[i].Required.XmlText =
#qLessons.Required[i]#;
lrXML.lData.XmlChildren[i].Time.XmlText =
#qLessons.Time[i]#;
}
/cfscript
Jason Merrill | E-Learning Solutions | icfconsulting.com
NOTICE:
This message is for the designated recipient only and may contain privileged or
confidential information. If you have received it in error, please notify the
sender immediately and delete the original. Any other use of this e-mail by you
is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211757
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple XML cfscript question
Thanks very much - could you shoot me an example of usage of both
columnlist and listlen() in this context? I'm new to ColdFusion and
can't quite wrap my head around it.
I tried:
for (i = 1; i LTE #qLessons.RecordCount#; i = i + 1){
lrXML.lData.XmlChildren[i] =
XmlElemNew(lrXML,Content);
for(n = 1; n LTE 4; n = n + 1){
lrXML.lData.XmlChildren[i].XmlChildren[n] =
XmlElemNew(lrXML,#qLessons.columnlist[n]#);
...etc...
for example, and that didn't work...
Jason Merrill | E-Learning Solutions | icfconsulting.com
NOTICE:
This message is for the designated recipient only and may contain privileged or
confidential information. If you have received it in error, please notify the
sender immediately and delete the original. Any other use of this e-mail by you
is prohibited.
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211760
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Simple XML cfscript question
Nevermind, after some headaches, I figured it out on my own:
cfquery name=GetAll datasource=coursesDB
SELECT * FROM Lessons
/cfquery
!-- the following query used to dynamically get the table names !--
cfquery name=GetTables datasource=coursesDB
SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Flags = 0
AND MSysObjects.Type = 1
ORDER BY MSysObjects.Name
/cfquery
cfscript
d = XmlNew();
d.xmlRoot = XmlElemNew(d, #GetTables.Name#);
for (i=1; i LTE #GetAll.RecordCount#; i=i+1){
d[#GetTables.Name#].XmlChildren[i] =
XmlElemNew(d,Content);
for(n=1; n LTE listLen(#GetAll.ColumnList#); n=n+1){
d[#GetTables.Name#].XmlChildren[i].XmlChildren[n] =
XmlElemNew(d,#ListGetAt(GetAll.ColumnList,n)#);
d[#GetTables.Name#].XmlChildren[i][#ListGetAt(GetAll.ColumnList,n)#].Xml
Text = #GetAll[#ListGetAt(GetAll.ColumnList,n)#][i]#;
}
}
/cfscript
Jason Merrill | E-Learning Solutions | icfconsulting.com
NOTICE:
This message is for the designated recipient only and may contain privileged or
confidential information. If you have received it in error, please notify the
sender immediately and delete the original. Any other use of this e-mail by you
is prohibited.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211776
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
