Cflayout, cflayoutarea, and navigating between a border area and a tab?
I'm using cflayout and cflayoutarea to approximate a frame layout. Here's my code: What I have is a list of links in the "locations" layoutarea, and when I click on the link, I want to load location-specific information in both layoutareas "editlocations" and "resources". My initial thought was to use Coldfusion.navigate() to accomplish that, but it doesn't work with cflayout. I looked at the Javascript functions for Coldfusion.Layout, but none of them really seem to apply. Is there any way to click in the one area and have it load new information in these two tabs without reloading the entire page? Thanks Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: query add row at top of query
thanks to all posts, and thanks Ria, i like this method :) > You can refer to this link to appendQuery > http://www.bennadel.com/blog/114-ColdFusion-QueryAppend-qOne-qTwo-. > htm > I guess you should go with method one as of my understanding. Posting > example here. > > appendQuery.cfm > name="GetParks" datasource="cfdocexamples" > cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#"> > SELECT PARKNAME, REGION, STATE > FROM Parks > Where REGION = 'Southeast Region' > ORDER BY ParkName, State > > varchar")> > > > > > > > > > > > > appendQuery.cfc > output="false" > hint="This takes two queries and appends the second one to the first > one. Returns the resultant third query."> > > > > > default="true" /> > > > > > > > > ( > SELECT > * > FROM > ARGUMENTS.QueryOne > > ) > > > UNION > > > > ALL > > > > ( > SELECT > * > FROM > ARGUMENTS.QueryTwo > ) > > > > > > > >> i have a query which has sort criteria applied at mysql level. > >> > >> i want to add a row at the top of the query after mysql has > finished with it. > >> > >> If i use the queryaddrow method it adds the row to the bottom of > the query > >> > >> is there anyway to get it to add it as the first item? > > > >You could add the new row in the SQL itself using a UNION statement, > >couldn't you? > > > >Otherwise, you could add it using queryAddRow, querySetCell, etc, > but > >you'd have to figure out how to get things in the order that you > want > >them. You could create a new query, add the row to the new query, > then > >loop through the old query and add each row to the new query. Or you > >could use queryAddRow and querySetCell with the existing query, but > >have a sortable field for all rows including the new row, then use > >query of query to sort the query again. > > > >But I'd go with doing this in your SQL if I were you. > > > >Dave Watts, CTO, Fig Leaf Software > >http://www.figleaf.com/ > >http://training.figleaf.com/ > > > >Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > >GSA Schedule, and provides the highest caliber vendor-authorized > >instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output newest one item from each category
Also, note that CROSS APPLY works just fine in ColdFusion. Anything that works in SQL Server can be put between the CFQUERY tags. ROW_NUMBER() and PARTITION will also work for you. Try this: SELECT catg, nltitle, nldate FROM ( SELECT n.catg, n.nltitle, n.nldate, ROW_NUMBER = ROW_NUMBER() OVER ( PARTITION BY n.catg ORDER BY n.nldate DESC ) FROM newsletters AS n ) AS news WHERE news.ROW_NUMBER <= 1 ORDER BY news.ndldate DESC > I'm trying to output a list of the most recent newsletters sorted by > DATE. There are a number of categories that they fall under, and I > must > show only the newest 1 from each category.. > > > Select catg, nltitle, nldate > from newsletters > order by date > > Might return this: > nldatecatgnltitle > > 6/28/2010 grants something title > 6/28/2010 grants another title > 6/27/2010 newsyes a title > 6/27/2010 newsgood news today > 6/25/2010 grants more grant stuff > 6/24/2010 toysnew hotwheels > 6/23/2010 carsnew nissan models > 6/23/2010 bob another bob found! > 6/23/2010 newstom just died > > What I need to output is just: > > nldatecatgnltitle > > 6/28/2010 grants something title > 6/27/2010 newsyes a title > 6/24/2010 toysnew hotwheels > 6/23/2010 bob another bob found! > 6/23/2010 carsnew nissan models > > > "group by catg" won't work in the output, for obvious reasons. I've > not > been able to exactly get a query of queries to work either. > > Can someone point me in the correct direction here please? > > > __ Information from ESET NOD32 Antivirus, version of virus > signature database 5326 (20100730) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output newest one item from each category
Les, If that gives you mostly the right answer, then you can consolidate your two queries into one with a sub-select, instead of the valueList(): SELECT TOP 5 nl_hed, nl_date, nl_id, nl_title, goodURL FROM nl_master WHERE nl_status = 'pub' AND id IN ( SELECT MAX(id) FROM nl_master WHERE nl_status = 'pub' GROUP BY nl_hed ) ORDER by nl_date DESC > OK, the below *mostly* gives me the correct output in the correct > order: > > > > SELECT max(id) as id, nl_hed > FROM nl_master > WHERE nl_status='pub' > group by nl_hed > order by nl_hed, id > > > > > > SELECT top 5 nl_hed, nl_date, nl_id, nl_title, goodURL > FROM nl_master > WHERE nl_status='pub' > AND id in ( cfsqltype="CF_SQL_VARCHAR" list="yes">) > ORDER by nl_date DESC > > > > But, that's sorta ugly and uses two queries. Any way to consolidate > this > down? > > There's a few cases where the max(id) might *not* be the newsletter > with > the highest date, but this probably won't crop up often enough to be > noticed. So, it's a kludge that works, but still not the *real* > solution. > > Ideally, I need to be able to find a way to: > Select distinct(nl_hed) > Plus select nl_date, nl_id, nl_title, goodURL > Order by nl_date DESC > > > __ Information from ESET NOD32 Antivirus, version of virus > signature database 5329 (20100731) __ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Running ColdFusion 9 and 8 in multi server
Larry, As much as I appreciate your link, I don't think you understood the problem. I clearly indicated that ColdFusion 8 and ColdFusion 9 work in a multi-server setup on the ports assigned, the problem is that the JRun Connector does not work setting up ColdFusion 8 to IIS. Regards, Andrew Scott http://www.andyscott.id.au/ > -Original Message- > From: Larry Lyons [mailto:larrycly...@gmail.com] > Sent: Friday, 30 July 2010 4:51 AM > To: cf-talk > Subject: Re: Running ColdFusion 9 and 8 in multi server > > > Mike Henke has a pretty good post on this: > > http://www.henke.ws/post.cfm/multiple-coldfusion-version-and-engines- > on-adobe-coldfusion-with-jrun > > hth, > larry > > >Ok, I am having some troubles on this one. > > > > > > > >First some background, ColdFusion 9 and ColdFusion 9 both work as > >installed on the instance port assigned. When trying to map with > >wsconfig to get ColdFusion 8 to map to IIS, I can't get this to work. > >ColdFusion 9 has no problems what so ever. > > > > > > > >There are 2 things that I have noticed, the option to run applications > >as ColdFusion 9 unticked will only add jsp, and jsw handlers. And when > >I do tick this box it sets everything up correctly. But neither option > >will run a ColdFusion 8 site through IIS. > > > > > > > >Has anyone tried this type of setup with Jrun? > > > > > > > > > > > >Regards, > > > >Andrew Scott > > > >http://www.andyscott.id.au/ > > ~~ > ~~~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael- > Dinowitz/dp/1430272155/?tag=houseoffusion > Archive: http://www.houseoffusion.com/groups/cf- > talk/message.cfm/messageid:335860 > Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: http://www.houseoffusion.com/groups/cf- > talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output newest one item from each category
If your using MS SQL 2005 or newer, you could use the row_number() feature-
one query using a funciton:
with f(catg, nltitle, nldate, nth) as (
Select catg, nltitle, nldate, row_number() over (partition by catg order by
catg, nldate desc) as nth
from newsletters)
select * from f where nth = 1
or create a view:
Select catg, nltitle, nldate, row_number() over (partition by catg order by
catg, nldate desc) as nth
from newsletters
select * from view where nth = 1
On Mon, Aug 2, 2010 at 2:12 PM, UXB Internet wrote:
>
> I was actually thinking about this and like yourself have not found a way
> to
> do it in one query. I have a crude solution. This assumes you only have
> the one table. In either case you need to get a unique list of the
> categories then loop over it to create a dynamic query.
>
>
> Select Distinct catg as 'thecategory'
> From newsletters
> Order by catg
>
>
>
>
>
> Select top 1 nldate, catg, nltitle
> From newsletter
> Where catg = '#thecategory#'
> Order by nldate desc
> UNION
>
> Select top 1 nldate, catg nltitle
> From newsletter
> Where 0=1
>
> Order by {column number}
>
>
>
> It may be crude but this approach at least puts all your date into one
> query
> object.
>
>
>
> Dennis Powers
> UXB Internet - A Website Design & Hosting Company
> P.O. Box 6028
> Wolcott, CT 06716
> 203-879-2844
> http://www.uxbinternet.com
>
>
>
>
>
>
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335928
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Output newest one item from each category
I was actually thinking about this and like yourself have not found a way to
do it in one query. I have a crude solution. This assumes you only have
the one table. In either case you need to get a unique list of the
categories then loop over it to create a dynamic query.
Select Distinct catg as 'thecategory'
>From newsletters
Order by catg
Select top 1 nldate, catg, nltitle
>From newsletter
Where catg = '#thecategory#'
Order by nldate desc
UNION
Select top 1 nldate, catg nltitle
>From newsletter
Where 0=1
Order by {column number}
It may be crude but this approach at least puts all your date into one query
object.
Dennis Powers
UXB Internet - A Website Design & Hosting Company
P.O. Box 6028
Wolcott, CT 06716
203-879-2844
http://www.uxbinternet.com
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335927
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HTML spec for mobile devices
To summarize it, I would look into mobile js frameworks like Sencha (http://www.sencha.com/). Also, to get an idea of screen resolution look at your Google analytics stats they should give you an idea of what mobile browsers are looking at your site and what the screen resolutions are. -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Monday, August 02, 2010 1:25 PM To: cf-talk Subject: RE: HTML spec for mobile devices You might also head over to Dan Vega's blog. He just gave a mobile session at CFUnited that was really well attended: http://www.danvega.org/blog/ -Original Message- From: Marc Funaro [mailto:subscripti...@advantex.net] Sent: Monday, August 02, 2010 9:14 AM To: cf-talk Subject: SOT: HTML spec for mobile devices I'm looking for a basic web resource coover what would be considered best practices for building a website that will be viewed on mobile devices... a general reference guide/best practices document, that might cover (x)html, css, etc... I can't seem to find the right keywords to Google with. The last mobile xml/html spec I could find was from 2001. I knwo i could just wing it and use basic html and go from there, but I'd rather follow at least a proposed standard, if there is one. Thanks for any links you can provide! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HTML spec for mobile devices
1+ - I attended this, He did an excellent job, very informative. T:@paulalkema -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Monday, August 02, 2010 1:25 PM To: cf-talk Subject: RE: HTML spec for mobile devices You might also head over to Dan Vega's blog. He just gave a mobile session at CFUnited that was really well attended: http://www.danvega.org/blog/ -Original Message- From: Marc Funaro [mailto:subscripti...@advantex.net] Sent: Monday, August 02, 2010 9:14 AM To: cf-talk Subject: SOT: HTML spec for mobile devices I'm looking for a basic web resource coover what would be considered best practices for building a website that will be viewed on mobile devices... a general reference guide/best practices document, that might cover (x)html, css, etc... I can't seem to find the right keywords to Google with. The last mobile xml/html spec I could find was from 2001. I knwo i could just wing it and use basic html and go from there, but I'd rather follow at least a proposed standard, if there is one. Thanks for any links you can provide! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: HTML spec for mobile devices
You might also head over to Dan Vega's blog. He just gave a mobile session at CFUnited that was really well attended: http://www.danvega.org/blog/ -Original Message- From: Marc Funaro [mailto:subscripti...@advantex.net] Sent: Monday, August 02, 2010 9:14 AM To: cf-talk Subject: SOT: HTML spec for mobile devices I'm looking for a basic web resource coover what would be considered best practices for building a website that will be viewed on mobile devices... a general reference guide/best practices document, that might cover (x)html, css, etc... I can't seem to find the right keywords to Google with. The last mobile xml/html spec I could find was from 2001. I knwo i could just wing it and use basic html and go from there, but I'd rather follow at least a proposed standard, if there is one. Thanks for any links you can provide! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: HTML spec for mobile devices
I would check out the HTML5 series of blog posts on the Sencha site: (starts here) http://www.sencha.com/blog/2010/05/23/html5-now-with-20-percent-more-internet/ Then do some travel through some of the links inside those posts. Every class-1 mobile phone has a browser supporting HTML5, with RIM (BlackBerry) being the next to join the fray (Can't speak to Windows Mobile. Can't seem to get any traction...). I would also invest the time to look into mobile frameworks like JQTouch and Sencha Touch. Steve 'Cutter' Blades On 8/2/2010 9:13 AM, Marc Funaro wrote: > I'm looking for a basic web resource coover what would be considered best > practices for building a website that will be viewed on mobile devices... a > general reference guide/best practices document, that might cover (x)html, > css, etc... I can't seem to find the right keywords to Google with. The last > mobile xml/html spec I could find was from 2001. I knwo i could just wing it > and use basic html and go from there, but I'd rather follow at least a > proposed standard, if there is one. > > Thanks for any links you can provide! > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT: HTML spec for mobile devices
I'm looking for a basic web resource coover what would be considered best practices for building a website that will be viewed on mobile devices... a general reference guide/best practices document, that might cover (x)html, css, etc... I can't seem to find the right keywords to Google with. The last mobile xml/html spec I could find was from 2001. I knwo i could just wing it and use basic html and go from there, but I'd rather follow at least a proposed standard, if there is one. Thanks for any links you can provide! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Server Data Archival - my solution
I find this intriguing as well. Almost like a poor mans historical archive system. A generator for the triggers would be cool also based on Illidium PU-36 -- Dan O'Keefe On Fri, Jul 30, 2010 at 9:08 AM, Pete Ruckelshaus wrote: > > Feel free to pass on any enhancements or improvements! > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
