Re: ColdFusion Companies in Baltimore/DC/VA
Thank you Charlie! Figleaf is already on our list to be solicited based on the work I've seen them perform. However, in the interest of due diligence, we also want to look at other companies for comparison. >While I agree with John's suggestion of reaching out to local CFUGs, I can >think of 3 companies off the top of my head (but I'm sure there are others). > >In no particular order... > >Fig Leaf (http://www.figleaf.com/) >AboutWeb (http://www.aboutweb.com/) >Teratech (http://www.teratech.com/) > > > >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Companies in Baltimore/DC/VA
Thank you John! I will give this a try as well. I didn't think about that. >Perhaps you could also direct this question toward your local CFUG's and >their members: > >http://groups.adobe.com/group/1021 >http://groups.adobe.com/group/349 >http://groups.adobe.com/group/782 >http://groups.adobe.com/group/303 > > > >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFLDAP query attribute with multiple values
does cfldap tag support querying for an attribute with multiple values? it seems no matter what i do, it only returns the first value of an attribute... our school uses mac os x server ldap service (based on openldap), and some user attributes are multivalued, but cfldap only ever returns the first value. browsing the directory using server's Workgroup Manager or LDAPManager (3rd party app) returns all attribute's values. anyone has any ideas how to make cfldap return all values? thanks! Azadi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Curious problem with CFINDEX
Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test database correctly indexes 5 rows. But when I run both together (on the same cfm template) the result is not 6. If I run the document one first and then the database one there are 5 records in the collection. If I run the database one first and then the document one there is only one record in the collection. The template commences with a PURGE and I've tried using both UPDATE and REFRESH but same result. TIA!!! ++ Kevin Parker m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Getting Record Number within a Looping Query
It depends on whether you mean a literal loop (ie cfloop) or a cfoutput loop. Both populate a special variable called #currentRow# when iterating through a "query". Limiting the number of iterations works different for each tag: http://livedocs.adobe.com/coldfusion/8/Tags_m-o_16.html http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_j-l_14.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion 9 -- Manually installing ODBC services
Nothing has changed since CF9, It is also the same for multi server except for the paths of course. Russ -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: 01 November 2010 22:15 To: cf-talk Subject: ColdFusion 9 -- Manually installing ODBC services Can anybody tell me if this technote still applies to ColdFusion 9? http://kb2.adobe.com/cps/191/tn_19135.html What, if anything, might be changed because the server in question is multi-server not standalone. TIA Ian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Getting Record Number within a Looping Query
queryName.currentRow On Mon, Nov 1, 2010 at 3:53 PM, Rick Colman wrote: > If I am looping over a query, how do I get the current record number for > the loop? > > e.g. If I am looping for a fixed number of iterations, I can use an > index="loopcount" and get the current loop number. > > How do I do this for a query? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Getting Record Number within a Looping Query
If I am looping over a query, how do I get the current record number for the loop? e.g. If I am looping for a fixed number of iterations, I can use an index="loopcount" and get the current loop number. How do I do this for a query? TNX. rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 9 -- Manually installing ODBC services
Can anybody tell me if this technote still applies to ColdFusion 9? http://kb2.adobe.com/cps/191/tn_19135.html What, if anything, might be changed because the server in question is multi-server not standalone. TIA Ian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFLOOP Next Iteration
>Just to say it, I too had lots of trouble with CFB, and while I liked >some things about CFEclipse before that, its bloat and bugginess >bummed me out (Eclipse more than CFE). YES! That's what we had issues with, getting CFEclipse to work properly... we even tried the older version as well with not much more success. >But now I'm a happy camper, using IntelliJ IDEA with its CFML plugin. ... It's about $250, with a free 30 day >trial. Hmm, thanks for the insight Dave, I'll have to make my boss aware of this one. If it's something that'll work for us, they may be able to come up with that $$$. :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion Search
Hi All, I've created a file index of all of my ColdFusion files so I can quickly search the files and find what I'm looking for. So far, it's working great except it doesn't seem to be searching inside any coldfusion tags. For example. If I searched for this text, It would return a result Does anyone know if there's a way to search inside of a coldfusion tag like that? This is my index.. http://mywebsite/"; extensions=".cfm, .cfml, .cfc" recurse="Yes"> This is my search. Any ideas? Thanks, Paul : ) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFCHART:: no values for # itemlabel #
> url="chartTestDetails.cfm?org=#itemlabel#"> If you are trying to use the pseudo-variables, the syntax is $ITEMLABEL$ http://livedocs.adobe.com/coldfusion/8/Tags_c_05.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFCHART:: no values for # itemlabel #
I have a chart that I want to drill down from however #itemlabel# is not being passed a value. My code the file this page is calling is in the same directory I either get a itemlabel is not defined or if i use cfparam it takes the default value and not the value from CF chart. The chart renders fine. tia J ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Companies in Baltimore/DC/VA
+1000 for Figleaf. They do excellent work. On Mon, Nov 1, 2010 at 12:52 PM, Charlie Griefer wrote: > > While I agree with John's suggestion of reaching out to local CFUGs, I can > think of 3 companies off the top of my head (but I'm sure there are others). > > In no particular order... > > Fig Leaf (http://www.figleaf.com/) > AboutWeb (http://www.aboutweb.com/) > Teratech (http://www.teratech.com/) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Companies in Baltimore/DC/VA
While I agree with John's suggestion of reaching out to local CFUGs, I can think of 3 companies off the top of my head (but I'm sure there are others). In no particular order... Fig Leaf (http://www.figleaf.com/) AboutWeb (http://www.aboutweb.com/) Teratech (http://www.teratech.com/) On Mon, Nov 1, 2010 at 12:23 PM, John M Bliss wrote: > > Perhaps you could also direct this question toward your local CFUG's and > their members: > > http://groups.adobe.com/group/1021 > http://groups.adobe.com/group/349 > http://groups.adobe.com/group/782 > http://groups.adobe.com/group/303 > > On Mon, Nov 1, 2010 at 2:09 PM, John Bono wrote: > > > > > Hello, > > > > We are getting ready for a major undertaking to involve a complete > overhaul > > of our very large Web site/CMS system to include a new design, > information > > architecture, marketing strategy, CMS platform, etc. We plan on issuing 2 > > RFPs: one for the design/marketing strategy and one for the technical > > implementation. > > > > However, finding companies in the Baltimore/Washington, DC/Virginia area > > with a preference for ColdFusion has proven to be very difficult. > > > > We have a preference for a company that uses ColdFusion as one of its > > technologies. Does anyone know of any companies in this area that would > be > > able to perform such work? > > > > Thanks in advance! > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Enterprise Create New Instance
These links may help: http://www.adobe.com/devnet/coldfusion/articles/clustering_cf8.html http://www.placona.co.uk/148/coldfusion/creating-new-coldfusion-8-instances-the-easy-way/ Dawn Sekel wrote: > I am missing something in creating an instance in Enterprise. I have the > site created, the directory structure is there. It is an internal site on > the Coldfusion box. The server is XP with Windows IIS 6. In IIS Manager, I > can see the site in the application pool and added a virtual site to map to > it. > > Do I need to run JRUN Administrator and do something else as well? > > When I try to go to the site it says Unable to display the webpage > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Companies in Baltimore/DC/VA
Perhaps you could also direct this question toward your local CFUG's and their members: http://groups.adobe.com/group/1021 http://groups.adobe.com/group/349 http://groups.adobe.com/group/782 http://groups.adobe.com/group/303 On Mon, Nov 1, 2010 at 2:09 PM, John Bono wrote: > > Hello, > > We are getting ready for a major undertaking to involve a complete overhaul > of our very large Web site/CMS system to include a new design, information > architecture, marketing strategy, CMS platform, etc. We plan on issuing 2 > RFPs: one for the design/marketing strategy and one for the technical > implementation. > > However, finding companies in the Baltimore/Washington, DC/Virginia area > with a preference for ColdFusion has proven to be very difficult. > > We have a preference for a company that uses ColdFusion as one of its > technologies. Does anyone know of any companies in this area that would be > able to perform such work? > > Thanks in advance! > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion Companies in Baltimore/DC/VA
Hello, We are getting ready for a major undertaking to involve a complete overhaul of our very large Web site/CMS system to include a new design, information architecture, marketing strategy, CMS platform, etc. We plan on issuing 2 RFPs: one for the design/marketing strategy and one for the technical implementation. However, finding companies in the Baltimore/Washington, DC/Virginia area with a preference for ColdFusion has proven to be very difficult. We have a preference for a company that uses ColdFusion as one of its technologies. Does anyone know of any companies in this area that would be able to perform such work? Thanks in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 9 Enterprise Create New Instance
I am missing something in creating an instance in Enterprise. I have the site created, the directory structure is there. It is an internal site on the Coldfusion box. The server is XP with Windows IIS 6. In IIS Manager, I can see the site in the application pool and added a virtual site to map to it. Do I need to run JRUN Administrator and do something else as well? When I try to go to the site it says Unable to display the webpage ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the MySQL syntax for this query?
> that's why the msg about 'dfv1', Not just the alias. The FROM part sounded suspicious. This is the one that worked for me with MySQL: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:62159#338715 ... but I am officially beating a dead horse now ;-) So back to work I go. Later -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the MySQL syntax for this query?
Yes, the actual query's different, that's why the msg about 'dfv1', which wasn't actually in the version I posted. Anyway, I'm good I think, thanks for checking. Dave On Mon, Nov 1, 2010 at 11:42 AM, Leigh wrote: > > Yes, putting the JOIN in the UPDATE should work for MySQL. > >> 1093 You can't specify target table 'dfv1' for update in >> FROM clause. > > Though I am thinking the actual query was different than what you posted. > Because I tried version #3 with MySQL 5 and it _seemed_ to run without error. > Anyway, glad you have something that works now. > > -Leigh > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the MySQL syntax for this query?
Yes, putting the JOIN in the UPDATE should work for MySQL. > 1093 You can't specify target table 'dfv1' for update in > FROM clause. Though I am thinking the actual query was different than what you posted. Because I tried version #3 with MySQL 5 and it _seemed_ to run without error. Anyway, glad you have something that works now. -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the MySQL syntax for this query?
@Azadi and Leigh, the oracle syntax gives this on mysql: Error Code: 1093 You can't specify target table 'dfv1' for update in FROM clause. Ended up with this for mysql: UPDATE MyTable t1 LEFT OUTER JOIN t2 ON t2.SomeColumn = t1.SomeColumn AND t2.SomeOtherColumn = t1.SomeOtherColumn AND t2.YetAnotherColumn = 42 SET Foo = 1 WHERE Bar = 99 AND t2.SomeColumn IS NULL Funky stuff. Dave On Mon, Nov 1, 2010 at 10:14 AM, Leigh wrote: > >> This more straight ahead version also works for Oracle: > > What error are you getting? I would expect that syntax to work with MySQL 5. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MS Access Coldfusion
> Thanks All. Enclosing the column within [] has worked for > me. As mentioned, you could also just rename it. Otherwise you have to escape the column every time you use it in a query. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the MySQL syntax for this query?
> This more straight ahead version also works for Oracle: What error are you getting? I would expect that syntax to work with MySQL 5. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the MySQL syntax for this query?
iirc, your last oracle syntax example should work in mysql as well. Azadi On 01/11/2010 21:36 , Dave Merrill wrote: > This more straight ahead version also works for Oracle: > > UPDATE MyTable t1 > SET Foo = 1 > WHERE Bar = 99 > AND NOT EXISTS > ( > SELECT * > FROM MyOtherTable t2 >WHERE t2.SomeColumn = t1.SomeColumn > AND t2.SomeOtherColumn = t1.SomeOtherColumn > AND t2.YetAnotherColumn = 42 > ) > > Still no ideas for MySQL. > Dave > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the MySQL syntax for this query?
This more straight ahead version also works for Oracle: UPDATE MyTable t1 SET Foo = 1 WHERE Bar = 99 AND NOT EXISTS ( SELECT * FROM MyOtherTable t2 WHERE t2.SomeColumn = t1.SomeColumn AND t2.SomeOtherColumn = t1.SomeOtherColumn AND t2.YetAnotherColumn = 42 ) Still no ideas for MySQL. Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What's the MySQL syntax for this query?
Dang it, I was afraid I'd mess up that conversion. The SQL Server version is actually this (2nd and 3rd lines switched): UPDATE t1 SET Foo = 1 FROM MyTable t1 WHERE Bar = 99 AND NOT EXISTS ( SELECT * FROM MyOtherTable t2 WHERE t2.SomeColumn = t1.SomeColumn AND t2.SomeOtherColumn = t1.SomeOtherColumn AND t2.YetAnotherColumn = 42 ) Dave On Mon, Nov 1, 2010 at 9:10 AM, Dave Merrill wrote: > The SQL Server version of this query is this: > > UPDATE t1 > FROM MyTable t1 > SET Foo = 1 > WHERE Bar = 99 > AND NOT EXISTS > ( > SELECT * > FROM MyOtherTable t2 > WHERE t2.SomeColumn = t1.SomeColumn > AND t2.SomeOtherColumn = t1.SomeOtherColumn > AND t2.YetAnotherColumn = 42 > ) > > > The Oracle version is this: > > UPDATE > ( > SELECT * > FROM MyTable t1 > WHERE Bar = 99 > AND NOT EXISTS > ( > SELECT * > FROM MyOtherTable t2 > WHERE t2.SomeColumn = t1.SomeColumn > AND t2.SomeOtherColumn = t1.SomeOtherColumn > AND t2.YetAnotherColumn = 42 > ) > ) join_table > SET join_table.Foo = 1 > > > (Hopefully I didn't mess things up converting from real names and > simplifying a bit. Sorry about the bent indentation too; try it in a > monospace font.) > > What's the MySQL version? Neither of those. All the examples on the > net are simple joins, not like this. Any other more reasonable ways ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What's the MySQL syntax for this query?
The SQL Server version of this query is this: UPDATE t1 FROM MyTable t1 SET Foo = 1 WHERE Bar = 99 AND NOT EXISTS ( SELECT * FROM MyOtherTable t2 WHERE t2.SomeColumn = t1.SomeColumn AND t2.SomeOtherColumn = t1.SomeOtherColumn AND t2.YetAnotherColumn = 42 ) The Oracle version is this: UPDATE ( SELECT * FROM MyTable t1 WHERE Bar = 99 AND NOT EXISTS ( SELECT * FROM MyOtherTable t2 WHERE t2.SomeColumn = t1.SomeColumn AND t2.SomeOtherColumn = t1.SomeOtherColumn AND t2.YetAnotherColumn = 42 ) ) join_table SET join_table.Foo = 1 (Hopefully I didn't mess things up converting from real names and simplifying a bit. Sorry about the bent indentation too; try it in a monospace font.) What's the MySQL version? Neither of those. All the examples on the net are simple joins, not like this. Any other more reasonable ways to do this, ideally something compatible with all three dbs (hah)? Thanks, Dave ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How can we create event calendar from CF
On Mon, Nov 1, 2010 at 4:52 AM, Ramakrishna sabarish wrote: > > Hi...can u help me to create a event calendar > > What specifically are you having troubles with? Here is a complete calendar system that may assist with your project. http://www.bennadel.com/projects/kinky-calendar.htm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How can we create event calendar from CF
Hi...can u help me to create a event calendar ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm