I saw this thanks. Actually, I created a dfaManager.cfc which handles all create, read, update and deletes. I've re-built my homesite using Mach-II and decided to use the DFA as the data layer. Once I got used to the pseudo SQL syntax of the DFA, it all works a treat. I noticed that SELECT statements require single-quotes around string values but UPDATE and INSERT statements don't like single-quotes around strings, which had me baffled for a while.
Cheers, Douglas -----Original Message----- From: Simon Horwith [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Flex in scotland WAS:RE: [ cf-dev ] Ben Forta meeting this Wednesday! You're right - it is all relativve (I still consider MX the beta verrsion of MX 6.1 and MX 6.1 the "real" software). Hey - glad you like the DFA API.. I hope at some point to be able to build a second rev. that supports some of the hooks I put in there for datatype, length, and other validation. If you didn't see it yet, I have a little example app. on www.how2cf.com (in Apps) that uses nothing but CFC calls directly, rather than the tag, in order to allow you to admin a DFA API app (create, define, and populate data tables). ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 11:11 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Flex in scotland WAS:RE: [ cf-dev ] Ben Forta meeting this Wednesday! 1. No I mean MX. 2. Well maybe you can, but I can't. :o) No point in arguing on this - it's all relative. D PS Simon, I've been using your DFA a lot over the past two weeks. It's pretty cool...thanks. -----Original Message----- From: Simon Horwith [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 10:52 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Flex in scotland WAS:RE: [ cf-dev ] Ben Forta meeting this Wednesday! two corrections: if Flex is the best thing since MX - I believe you mean MX 6.1 you can build flash with nothing but a text editor..... AND server software ;) ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 10:45 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Flex in scotland WAS:RE: [ cf-dev ] Ben Forta meeting this Wednesday! I'm calm...honest! ......grrrrrrhhhhhh IMO Flex is the most exciting thing to come out of Macromedia since CFMX. To be able to build a Flash interface using nothing but a text editor is a great concept and I can't wait to see it in action. Cheers, Douglas -----Original Message----- From: Lucas Sherwood [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 09:42 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Flex in scotland WAS:RE: [ cf-dev ] Ben Forta meeting this Wednesday! Calm down, we will get flex in Scotland sooner or later! -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 9:31 AM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Ben Forta meeting this Wednesday! Bah! Not fair... It was a good meeting though. D -----Original Message----- From: Lucas Sherwood [mailto:[EMAIL PROTECTED] Sent: 26 January 2004 16:31 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Ben Forta meeting this Wednesday! Umm I think you will find they are different topics... L. -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED] Sent: 26 January 2004 3:07 PM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Ben Forta meeting this Wednesday! > Come to the UKCFUG for the first ever user group presentation of Flex, I'll be hearing him tonight at the Scottish User Group in Edinburgh, which I believe is the first user group presentation ever so nah. :oP -----Original Message----- From: Niklas Richardson [mailto:[EMAIL PROTECTED] Sent: 26 January 2004 14:25 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [ cf-dev ] Ben Forta meeting this Wednesday! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The United Kingdom ColdFusion User Group Newsletter, 26 January 2004 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ====================================================================== Next Event - Wednesday, 28 January 2004 ====================================================================== The Meeting With No Name... ---------------------------------------------------------------------- The Meeting With No Name... Flex is cool as hell (Ben's words not EDs). And CF developers can use Flex as the presentation layer for their apps. Come to the UKCFUG for the first ever user group presentation of Flex, and Flex powered by ColdFusion. When: Wednesday, 28 January 2004 Where: Convocation Suite City University Centenary Building Spencer Street London EC1V 0HB meeting details > http://www.ukcfug.org/index.cfm?objectid=8ED00B94-50DA-4D01-87248AE5CE7B 3501 --------------------- | REGISTER NOW | --------------------- ====================================================================== Upcoming Events Schedule ====================================================================== Date Title ---------------------------------------------------------------------- 28-Jan-04 The Meeting With No Name... more > http://www.ukcfug.org/index.cfm?objectid=8ED00B94-50DA-4D01-87248AE5CE7B 3501 19-Feb-04 Tim O'Reilly Presents... more > http://www.ukcfug.org/index.cfm?objectid=8ED1C0D5-50DA-4D01-87FEB77EB879 BD48 25-Mar-04 Software Architecture for ColdFusion more > http://www.ukcfug.org/index.cfm?objectid=F49432D6-50DA-4D01-874F57375E29 8D7C more upcoming events > http://www.ukcfug.org/index.cfm?objectid=4E5B4EE8-B11F-96C7-FC8D12E566D9 8464 ====================================================================== User Group News ====================================================================== BEN'S COMING THIS WEDNESDAY! Don't forget that Ben Forta will be joining us this Wednesday to give us a sneak peek of Flex, Macromedia's upcoming Flash presentation server software. Numbers are limited so please make sure you register on the website. If you are unable to make it please un-register, so that other members can. There will also be refreshments at the meeting. We look forward to seeing you all there. more > http://www.ukcfug.org/index.cfm?objectid=528AAE48-50DA-4D01-8778501AAEB2 BCDA BEN FORTA, TIM O'REILLY, NEW VENUE On the 28th January, we have a world first! For the first time ever since MAX, we are going to get a secret glimpse at Flex, Macromedia's upcoming Flash presentation server software. Ben Forta will be coming down and, we are told, there will be room for questions afterwards. The London MMUG and UKCFUG are proud that the first ever MMUG sneak peek of Flex will take place right here in London. Make sure you don't miss this. We also have an amazing meeting lined up for February. None other than Tim O'Reilly of O'Reilly & Associates (the famous tech book publishers) will be over to talk to us about "The Open Source Paradigm Shift". After the talk, he will answer questions as well as talk about Macromedia rich internet applications as well as wireless/cell phone. Here's to an exciting 2004! NOTE: The venue has moved to City University. You can find details on how to get there under the meeting details. Check out some photos. more > http://www.ukcfug.org/index.cfm?objectid=3D1D71E3-50DA-4D01-87B5DFA0EF9B 9D33 NEW YEAR DRINKS! We hope everyone who came to the New Year's Party had a good time. We certainly did! There were about thirty CFUGers and MMUGers there all drinking and catching up with people. Unfortunately someone alerted the Police to our presence but things were soon under control. They proceeded to close down Tottanham court road to ensure our safty. Ok so not really, we are still unsure as to what actually happened but it gave many of us a reason to stay for one more drink. Check out the photos. more > http://www.ukcfug.org/index.cfm?objectid=3D14DD5A-50DA-4D01-871F31E46C54 321E ====================================================================== Sponsor Spotlight ====================================================================== Prismix Ltd London based Internet Architects Prismix specialise in the provision of content managed Rich Internet Solutions and also offer comprehensive Spectra and ColdFusion consultancy services. more > http://www.ukcfug.org/index.cfm?objectid=7BC3FC83-50DA-4D01-8798EA3883C6 D0E8 Highlander PLC Highlander PLC is the UK's leading Macromedia partner, offering a range of services including training, mentoring and consultancy. more > http://www.ukcfug.org/index.cfm?objectid=95B2D214-50DA-4D01-87ED9D38BB1D C3B3 London Web Communications Ltd For all your ColdFusion needs! more > http://www.ukcfug.org/index.cfm?objectid=95B3B9A5-50DA-4D01-87FBD4A93D54 C44B ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Date Created: 26 January 2004 Copyright C 2004 UK ColdFusion User Group Unsubscribe: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
