Re: table display: row number. without recordset
You could always use cfcontent to render the code and place it in a variable, then output into email. You could also call it via cfhttp and use the response. Be aware, however, JS and CSS do not always play nicely with email clients so make sure you test your target client(s). Judah On Tue, May 12, 2009 at 9:53 AM, Paul Ihrig wrote: > > there are like 5 separate queries. > with sub quires inside the first 3. > > so current row wouldn't work. unless i wrote a big nasty q0q > that's why i really liked the jquery rendering of the row number. > > > > On Tue, May 12, 2009 at 12:23 PM, Azadi Saryev wrote: > >> >> how are you rendering the table in cfmail? is it based on query output? >> use queryname.currentrow then, or a custom row counter if your query >> uses group output... >> >> Azadi Saryev >> Sabai-dee.com >> http://www.sabai-dee.com/ >> >> >> >> Paul Ihrig wrote: >> > ok here is a weird one. >> > the numbers render fine on display in browser. >> > but if i include the rendered output in a cfmail, i dont get the >> numbering? >> > >> > i have the js, and css linked correctly.. >> > >> > >> > >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
there are like 5 separate queries. with sub quires inside the first 3. so current row wouldn't work. unless i wrote a big nasty q0q that's why i really liked the jquery rendering of the row number. On Tue, May 12, 2009 at 12:23 PM, Azadi Saryev wrote: > > how are you rendering the table in cfmail? is it based on query output? > use queryname.currentrow then, or a custom row counter if your query > uses group output... > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > > Paul Ihrig wrote: > > ok here is a weird one. > > the numbers render fine on display in browser. > > but if i include the rendered output in a cfmail, i dont get the > numbering? > > > > i have the js, and css linked correctly.. > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322435 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
display1Day.cfm http://63.144.103.199/FORMS/rittalXpress/ie/inc/detail/display1Day.cfm?placeholder=enclosures&xp1DayId=10027step1 the jquery auto number is in the display1Day.cfm which renders fine. i dont need the sorting or any thing in the email, just the line number. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
how are you rendering the table in cfmail? is it based on query output? use queryname.currentrow then, or a custom row counter if your query uses group output... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: > ok here is a weird one. > the numbers render fine on display in browser. > but if i include the rendered output in a cfmail, i dont get the numbering? > > i have the js, and css linked correctly.. > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
well, whatever you put in the body of tag would be processed and rendered BEFORE the page is displayed in the browser, thus BEFORE any jQuery magic kicks in... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: > ok here is a weird one. > the numbers render fine on display in browser. > but if i include the rendered output in a cfmail, i dont get the numbering? > > i have the js, and css linked correctly.. > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
You can't do JavaScript in emails. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
ok here is a weird one. the numbers render fine on display in browser. but if i include the rendered output in a cfmail, i dont get the numbering? i have the js, and css linked correctly.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table display: row number. without recordset
It probably does, but it's sorted already. Adrian > -Original Message- > From: Paul Ihrig [mailto:pih...@gmail.com] > Sent: 11 May 2009 20:44 > To: cf-talk > Subject: Re: table display: row number. without recordset > > > one weird thing is the tablesorter dost work on that column unles i > sort > from another column first. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
nm. just moved the script up and its fine. On Mon, May 11, 2009 at 3:44 PM, Paul Ihrig wrote: > one weird thing is the tablesorter dost work on that column unles i sort > from another column first. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
one weird thing is the tablesorter dost work on that column unles i sort from another column first. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
Perfect! Thank you, so much. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322386 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: table display: row number. without recordset
Same as CSS. table.className Adrian > -Original Message- > From: Paul Ihrig [mailto:pih...@gmail.com] > Sent: 11 May 2009 20:23 > To: cf-talk > Subject: Re: table display: row number. without recordset > > > how would i target my tables with a class="tablesorterXP" > but not any other table classes? > > i tried > $(".tablesorterXP table tbody tr").each( function(i) { >$("td", $(this)).eq(0).html(i+1); > }); > > > Thanks BTW this is just what i was looking for. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322385 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
how would i target my tables with a class="tablesorterXP" but not any other table classes? i tried $(".tablesorterXP table tbody tr").each( function(i) { $("td", $(this)).eq(0).html(i+1); }); Thanks BTW this is just what i was looking for. On Mon, May 11, 2009 at 3:16 PM, Azadi Saryev wrote: > > there probably is, but i do not know one... > > here's a full sample code, though: > > > > $(document).ready(function(){ > $("table tbody tr").each( function(i) { >$("td", $(this)).eq(0).html(i+1); > }); > }); > > > > > > > > >#monthasstring(idx)# > > > > > > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > > Paul Ihrig wrote: > > hey Azadi is there a link to an example using jquery? > > thanks a bunch! > > > > > > On Mon, May 11, 2009 at 12:02 PM, Azadi Saryev > wrote: > > > > > >> very easy using jquery: > >> > >> $(document).ready(function(){ > >> $("table tbody tr").each( function(i) { > >>$("td", $(this)).eq(0).html(i+1); > >> }); > >> }); > >> > >> Azadi Saryev > >> Sabai-dee.com > >> http://www.sabai-dee.com/ > >> > >> > >> > >> Paul Ihrig wrote: > >> > >>> i have a bit of css, that displays row number, excluding header. > >>> works in FF but note iE .. > >>> > >>> table { counter-reset: line-number; } > >>> td:first-child:before { > >>> content: counter(line-number) "."; > >>> counter-increment: line-number; > >>> padding-right: 0.3em; } > >>> > >>> > >>> is there a way using coldfusion or JS/jquery to display the row number > of > >>> > >> a > >> > >>> table? > >>> independent of a recordset... > >>> > >>> thanks > >>> -paul > >>> > >>> > >>> > >>> > >> > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322383 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
there probably is, but i do not know one... here's a full sample code, though: $(document).ready(function(){ $("table tbody tr").each( function(i) { $("td", $(this)).eq(0).html(i+1); }); }); #monthasstring(idx)# Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: > hey Azadi is there a link to an example using jquery? > thanks a bunch! > > > On Mon, May 11, 2009 at 12:02 PM, Azadi Saryev wrote: > > >> very easy using jquery: >> >> $(document).ready(function(){ >> $("table tbody tr").each( function(i) { >>$("td", $(this)).eq(0).html(i+1); >> }); >> }); >> >> Azadi Saryev >> Sabai-dee.com >> http://www.sabai-dee.com/ >> >> >> >> Paul Ihrig wrote: >> >>> i have a bit of css, that displays row number, excluding header. >>> works in FF but note iE .. >>> >>> table { counter-reset: line-number; } >>> td:first-child:before { >>> content: counter(line-number) "."; >>> counter-increment: line-number; >>> padding-right: 0.3em; } >>> >>> >>> is there a way using coldfusion or JS/jquery to display the row number of >>> >> a >> >>> table? >>> independent of a recordset... >>> >>> thanks >>> -paul >>> >>> >>> >>> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322382 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
hey Azadi is there a link to an example using jquery? thanks a bunch! On Mon, May 11, 2009 at 12:02 PM, Azadi Saryev wrote: > > very easy using jquery: > > $(document).ready(function(){ > $("table tbody tr").each( function(i) { >$("td", $(this)).eq(0).html(i+1); > }); > }); > > Azadi Saryev > Sabai-dee.com > http://www.sabai-dee.com/ > > > > Paul Ihrig wrote: > > i have a bit of css, that displays row number, excluding header. > > works in FF but note iE .. > > > > table { counter-reset: line-number; } > > td:first-child:before { > > content: counter(line-number) "."; > > counter-increment: line-number; > > padding-right: 0.3em; } > > > > > > is there a way using coldfusion or JS/jquery to display the row number of > a > > table? > > independent of a recordset... > > > > thanks > > -paul > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322381 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
very easy using jquery: $(document).ready(function(){ $("table tbody tr").each( function(i) { $("td", $(this)).eq(0).html(i+1); }); }); Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: > i have a bit of css, that displays row number, excluding header. > works in FF but note iE .. > > table { counter-reset: line-number; } > td:first-child:before { > content: counter(line-number) "."; > counter-increment: line-number; > padding-right: 0.3em; } > > > is there a way using coldfusion or JS/jquery to display the row number of a > table? > independent of a recordset... > > thanks > -paul > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: table display: row number. without recordset
If you are looping, you can easily display the row number using the loop index. IE does not often recognize seudo-classes such as :first-child :before, etc. In fact, I think (might be wrong) that counter-increment is in a CSS version higher than IE knows. You can sometimes gain compliance in IE by changing your doctype to XHTML1.0 Strict (look up the exact syntax). This usually only works for me in IE7 though, version 6 doesn't provide much hope for the developer. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: Monday, May 11, 2009 8:42 AM To: cf-talk Subject: table display: row number. without recordset i have a bit of css, that displays row number, excluding header. works in FF but note iE .. table { counter-reset: line-number; } td:first-child:before { content: counter(line-number) "."; counter-increment: line-number; padding-right: 0.3em; } is there a way using coldfusion or JS/jquery to display the row number of a table? independent of a recordset... thanks -paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4