Micronovae's mod rewrite module on IIS 6 and CF 6.1...
I am trying to get Micronovae's mod rewrite ISAPI filter working on II6 and CF 6.1. When I have the filter installed, it seems like the CF sites go into a eternal redirect loop.even if they shouldn't be getting picked up by the rewrite directive. Has anyone had any experience with this that can help me out. I need to get a running example up as soon as I can. I have never set this up before, so I am coming from a position of total ignorance on this end ;-) Any help would be appreciated. Eric ~| 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:331213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1...
Please post the redirect scripts your running. If you are capturing all of X, sending it to a CF page that processed it and then does another redirect, you might be tripping that first capture again. Proper writing of redirects takes time, dedication, and an engineering degree. :) -- Michael Dinowitz On Mon, Mar 1, 2010 at 12:33 PM, Eric Roberts w...@witchnet.org wrote: I am trying to get Micronovae's mod rewrite ISAPI filter working on II6 and CF 6.1. When I have the filter installed, it seems like the CF sites go into a eternal redirect loop.even if they shouldn't be getting picked up by the rewrite directive. Has anyone had any experience with this that can help me out. I need to get a running example up as soon as I can. I have never set this up before, so I am coming from a position of total ignorance on this end ;-) Any help would be appreciated. Eric ~| 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:331214 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Micronovae's mod rewrite module on IIS 6 and CF 6.1...
That's encouraging hehehehe This is the rewrite rule: RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] Here is what would be in the actual url: http://www.mydomain.com/jobname/company/location/city/state/jobid If I have the isapi filter enabled, nothing works...I just installed at as per the installer for this. This is the text of the actual config file... # IIS Mod-Rewrite configuration file # Prevent access to .htaccess files RewriteEngine On RewriteRule /\.htaccess$ - [F] #rewrite jobad url RewriteEngine On RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] I was just following their example...like I said...total noob to setting this up... Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 11:54 AM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... Please post the redirect scripts your running. If you are capturing all of X, sending it to a CF page that processed it and then does another redirect, you might be tripping that first capture again. Proper writing of redirects takes time, dedication, and an engineering degree. :) -- Michael Dinowitz On Mon, Mar 1, 2010 at 12:33 PM, Eric Roberts w...@witchnet.org wrote: I am trying to get Micronovae's mod rewrite ISAPI filter working on II6 and CF 6.1. When I have the filter installed, it seems like the CF sites go into a eternal redirect loop.even if they shouldn't be getting picked up by the rewrite directive. Has anyone had any experience with this that can help me out. I need to get a running example up as soon as I can. I have never set this up before, so I am coming from a position of total ignorance on this end ;-) Any help would be appreciated. Eric ~| 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:331215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Micronovae's mod rewrite module on IIS 6 and CF 6.1...
I think I stopped the redirect...I changed the options on the end from r,l to l,qsa...now it seems to be redirecting to an index file in the root instead of the current directory. Any ideas oh mighty engineers ;-) Thx Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 11:54 AM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... Please post the redirect scripts your running. If you are capturing all of X, sending it to a CF page that processed it and then does another redirect, you might be tripping that first capture again. Proper writing of redirects takes time, dedication, and an engineering degree. :) -- Michael Dinowitz On Mon, Mar 1, 2010 at 12:33 PM, Eric Roberts w...@witchnet.org wrote: I am trying to get Micronovae's mod rewrite ISAPI filter working on II6 and CF 6.1. When I have the filter installed, it seems like the CF sites go into a eternal redirect loop.even if they shouldn't be getting picked up by the rewrite directive. Has anyone had any experience with this that can help me out. I need to get a running example up as soon as I can. I have never set this up before, so I am coming from a position of total ignorance on this end ;-) Any help would be appreciated. Eric ~| 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:331216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1...
In this fragment, you have /?, meaning that the / is optional. Why? ^/([^/]+)/?([^/]*) Is the url always going to be in the /jobname/company/location/city/state/jobid format or are some shorter? Can you post a few 'live' links for example? If you keep the http prefix off of the url then the list will not try and format them as actual links in the web archives, if that is your concern. Thanks -- Michael Dinowitz On Mon, Mar 1, 2010 at 1:01 PM, Eric Roberts ow...@threeravensconsulting.com wrote: That's encouraging hehehehe This is the rewrite rule: RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] Here is what would be in the actual url: http://www.mydomain.com/jobname/company/location/city/state/jobid If I have the isapi filter enabled, nothing works...I just installed at as per the installer for this. This is the text of the actual config file... # IIS Mod-Rewrite configuration file # Prevent access to .htaccess files RewriteEngine On RewriteRule /\.htaccess$ - [F] #rewrite jobad url RewriteEngine On RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] I was just following their example...like I said...total noob to setting this up... Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 11:54 AM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... Please post the redirect scripts your running. If you are capturing all of X, sending it to a CF page that processed it and then does another redirect, you might be tripping that first capture again. Proper writing of redirects takes time, dedication, and an engineering degree. :) -- Michael Dinowitz On Mon, Mar 1, 2010 at 12:33 PM, Eric Roberts w...@witchnet.org wrote: I am trying to get Micronovae's mod rewrite ISAPI filter working on II6 and CF 6.1. When I have the filter installed, it seems like the CF sites go into a eternal redirect loop.even if they shouldn't be getting picked up by the rewrite directive. Has anyone had any experience with this that can help me out. I need to get a running example up as soon as I can. I have never set this up before, so I am coming from a position of total ignorance on this end ;-) Any help would be appreciated. Eric ~| 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:331217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Micronovae's mod rewrite module on IIS 6 and CF 6.1...
I have it working for localhost now...I set up a dummy subdomain in the hosts file and I am tryingto get that to work. To answer your questions... 1. I have that in the regex because that is what they had in their example...I dont know regex very well as I dont use it often enough to really remember it well. If I go to http://localhost/test/job/company/location/city/state/50...I get my dump of the vars as expected. If I go to http://jobads.mydomain.com/job/company/location/city/state/50 I get a 404. jobads.mydomain.com is paired with 127.0.0.1 in my hosts file and in IIS, it points to the test directory. 2. Yes, it will always be in that format. The server is not available publically, so I can't post links. Unfortunately the server is behind a firewall, so I can't post live links. Thanks! Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 12:52 PM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... In this fragment, you have /?, meaning that the / is optional. Why? ^/([^/]+)/?([^/]*) Is the url always going to be in the /jobname/company/location/city/state/jobid format or are some shorter? Can you post a few 'live' links for example? If you keep the http prefix off of the url then the list will not try and format them as actual links in the web archives, if that is your concern. Thanks -- Michael Dinowitz On Mon, Mar 1, 2010 at 1:01 PM, Eric Roberts ow...@threeravensconsulting.com wrote: That's encouraging hehehehe This is the rewrite rule: RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] Here is what would be in the actual url: http://www.mydomain.com/jobname/company/location/city/state/jobid If I have the isapi filter enabled, nothing works...I just installed at as per the installer for this. This is the text of the actual config file... # IIS Mod-Rewrite configuration file # Prevent access to .htaccess files RewriteEngine On RewriteRule /\.htaccess$ - [F] #rewrite jobad url RewriteEngine On RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] I was just following their example...like I said...total noob to setting this up... Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 11:54 AM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... Please post the redirect scripts your running. If you are capturing all of X, sending it to a CF page that processed it and then does another redirect, you might be tripping that first capture again. Proper writing of redirects takes time, dedication, and an engineering degree. :) -- Michael Dinowitz On Mon, Mar 1, 2010 at 12:33 PM, Eric Roberts w...@witchnet.org wrote: I am trying to get Micronovae's mod rewrite ISAPI filter working on II6 and CF 6.1. When I have the filter installed, it seems like the CF sites go into a eternal redirect loop.even if they shouldn't be getting picked up by the rewrite directive. Has anyone had any experience with this that can help me out. I need to get a running example up as soon as I can. I have never set this up before, so I am coming from a position of total ignorance on this end ;-) Any help would be appreciated. Eric ~| 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:331218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Micronovae's mod rewrite module on IIS 6 and CF 6.1...
BTW...if I just go to jobs.mydomain.com with none of the rewrite string attached I get the dump... with no values obviously...so I know it is pointed to the right place and the site is functional. Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 12:52 PM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... In this fragment, you have /?, meaning that the / is optional. Why? ^/([^/]+)/?([^/]*) Is the url always going to be in the /jobname/company/location/city/state/jobid format or are some shorter? Can you post a few 'live' links for example? If you keep the http prefix off of the url then the list will not try and format them as actual links in the web archives, if that is your concern. Thanks -- Michael Dinowitz On Mon, Mar 1, 2010 at 1:01 PM, Eric Roberts ow...@threeravensconsulting.com wrote: That's encouraging hehehehe This is the rewrite rule: RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] Here is what would be in the actual url: http://www.mydomain.com/jobname/company/location/city/state/jobid If I have the isapi filter enabled, nothing works...I just installed at as per the installer for this. This is the text of the actual config file... # IIS Mod-Rewrite configuration file # Prevent access to .htaccess files RewriteEngine On RewriteRule /\.htaccess$ - [F] #rewrite jobad url RewriteEngine On RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] I was just following their example...like I said...total noob to setting this up... Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 11:54 AM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... Please post the redirect scripts your running. If you are capturing all of X, sending it to a CF page that processed it and then does another redirect, you might be tripping that first capture again. Proper writing of redirects takes time, dedication, and an engineering degree. :) -- Michael Dinowitz On Mon, Mar 1, 2010 at 12:33 PM, Eric Roberts w...@witchnet.org wrote: I am trying to get Micronovae's mod rewrite ISAPI filter working on II6 and CF 6.1. When I have the filter installed, it seems like the CF sites go into a eternal redirect loop.even if they shouldn't be getting picked up by the rewrite directive. Has anyone had any experience with this that can help me out. I need to get a running example up as soon as I can. I have never set this up before, so I am coming from a position of total ignorance on this end ;-) Any help would be appreciated. Eric ~| 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:331219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1...
1. The example is not as right as it could be, at least from my regex perspective. 2. It sounds like the domain is the problem with the redirect looking for localhost, not jobads. I'd look at the implementation rather than the regex. I use the Ionic ISAPI rather than the Micronovae for rewriting so I can't help on the implementation. Sorry -- Michael Dinowitz On Mon, Mar 1, 2010 at 2:42 PM, Eric Roberts ow...@threeravensconsulting.com wrote: I have it working for localhost now...I set up a dummy subdomain in the hosts file and I am tryingto get that to work. To answer your questions... 1. I have that in the regex because that is what they had in their example...I dont know regex very well as I dont use it often enough to really remember it well. If I go to http://localhost/test/job/company/location/city/state/50...I get my dump of the vars as expected. If I go to http://jobads.mydomain.com/job/company/location/city/state/50 I get a 404. jobads.mydomain.com is paired with 127.0.0.1 in my hosts file and in IIS, it points to the test directory. 2. Yes, it will always be in that format. The server is not available publically, so I can't post links. Unfortunately the server is behind a firewall, so I can't post live links. Thanks! Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 12:52 PM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... In this fragment, you have /?, meaning that the / is optional. Why? ^/([^/]+)/?([^/]*) Is the url always going to be in the /jobname/company/location/city/state/jobid format or are some shorter? Can you post a few 'live' links for example? If you keep the http prefix off of the url then the list will not try and format them as actual links in the web archives, if that is your concern. Thanks -- Michael Dinowitz On Mon, Mar 1, 2010 at 1:01 PM, Eric Roberts ow...@threeravensconsulting.com wrote: That's encouraging hehehehe This is the rewrite rule: RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] Here is what would be in the actual url: http://www.mydomain.com/jobname/company/location/city/state/jobid If I have the isapi filter enabled, nothing works...I just installed at as per the installer for this. This is the text of the actual config file... # IIS Mod-Rewrite configuration file # Prevent access to .htaccess files RewriteEngine On RewriteRule /\.htaccess$ - [F] #rewrite jobad url RewriteEngine On RewriteRule ^/([^/]+)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)/?([^/]*)$ /index.cfm?jobname=$1company=$2jobloc=$3city=$4state=$5ad_id=$6 [R,L] I was just following their example...like I said...total noob to setting this up... Eric -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Monday, March 01, 2010 11:54 AM To: cf-talk Subject: Re: Micronovae's mod rewrite module on IIS 6 and CF 6.1... Please post the redirect scripts your running. If you are capturing all of X, sending it to a CF page that processed it and then does another redirect, you might be tripping that first capture again. Proper writing of redirects takes time, dedication, and an engineering degree. :) -- Michael Dinowitz On Mon, Mar 1, 2010 at 12:33 PM, Eric Roberts w...@witchnet.org wrote: I am trying to get Micronovae's mod rewrite ISAPI filter working on II6 and CF 6.1. When I have the filter installed, it seems like the CF sites go into a eternal redirect loop.even if they shouldn't be getting picked up by the rewrite directive. Has anyone had any experience with this that can help me out. I need to get a running example up as soon as I can. I have never set this up before, so I am coming from a position of total ignorance on this end ;-) Any help would be appreciated. Eric ~| 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:331220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
so what can i do? newbie question i am using the following QoQ cfquery name=qaccbytyp dbtype=queryselect * from data where saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and (sadrf='#manyref.sadrf#' or C=#lastD# or MOD(C,#ABS(firstD)#) =0 )/cfquery and i get this error Error Executing Database Query. Query Of Queries syntax error. Encountered MOD ( C ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, any ideas. thanks . ~| 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:328166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
so what can I do ? ~| 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:328167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
so what can I do?? ~| 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:328168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
so what can I do? ~| 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:328169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
so what can i do??? ~| 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:328170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
elect * from data where saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and (sadrf='#manyref.sadrf#' or C=#lastD# or MOD(C,#ABS(firstD)#) =0 There is no and or or between aab='#sanad.saab#' andsaan='#sanad.saan#' I'd try fix that first. But mod might not work in QoQ never tried. Paul On Nov 10, 2009, at 2:27 AM, safo kaskas wrote: so what can i do? newbie question i am using the following QoQ cfquery name=qaccbytyp dbtype=queryselect * from data where saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and (sadrf='#manyref.sadrf#' or C=#lastD# or MOD(C,#ABS(firstD)#) =0 )/cfquery and i get this error Error Executing Database Query. Query Of Queries syntax error. Encountered MOD ( C ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, any ideas. thanks . ~| 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:328171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
cfset modvalue= MOD(C,#ABS(firstD)#) cfquery name=qaccbytyp dbtype=queryselect * from data where saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and (sadrf='#manyref.sadrf#' or C=#lastD# or #modvalue# =0 )/cfquery On Tue, Nov 10, 2009 at 12:08 AM, safo kaskas safokas...@hotmail.com wrote: so what can i do??? ~| 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:328172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
QoQ and MOD function
newbie question i am using the following QoQ cfquery name=qaccbytyp dbtype=queryselect * from data where saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and (sadrf='#manyref.sadrf#' or C=#lastD# or MOD(C,#ABS(firstD)#) =0 )/cfquery and i get this error Error Executing Database Query. Query Of Queries syntax error.Encountered MOD ( C ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, any ideas. thanks . ~| 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:328117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QoQ and MOD function
The MOD function isn't available in Query of Queries. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/11/8 safo kaska safokas...@hotmail.com: newbie question i am using the following QoQ cfquery name=qaccbytyp dbtype=queryselect * from data where saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and (sadrf='#manyref.sadrf#' or C=#lastD# or MOD(C,#ABS(firstD)#) =0 )/cfquery and i get this error Error Executing Database Query. Query Of Queries syntax error.Encountered MOD ( C ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, any ideas. thanks . ~| 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:328118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mod Rewrite for blog cfc
The 404 is coming from tomcat. HTTP Status 404 - -- *type* Status report *message* *description* *The requested resource () is not available.* -- Apache Tomcat/6.0.18 Thank You Dan Vega danv...@gmail.com http://www.danvega.org On Sat, Feb 28, 2009 at 2:09 AM, James Holmes james.hol...@gmail.comwrote: By default, the mod_rewrite rules aren't necessary; BlogCFC handles those friendly URLs internally. Is it Apache that gives you 404 or Railo? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/28 Dan Vega danv...@gmail.com: I got my blog running on Railo and anytime i go to a url that looks like this http://dev.danvega.org/blog/index.cfm/2009/2/5/CFMU-Updates-coming-soon I get a 404 error. This is because I neeed to add some re write rules into apache right? Anyone have these rules for blogcfc? Thank You Dan Vega danv...@gmail.com http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Mod Rewrite for blog cfc
I just searched for coldfusion tomcat ses url and found: http://www.justskins.com/forums/ses-search-engine-safe-doesnt-work-with-coldfusion-mx7-72409.html This help? On Sat, Feb 28, 2009 at 7:55 AM, Dan Vega danv...@gmail.com wrote: The 404 is coming from tomcat. HTTP Status 404 - -- *type* Status report *message* *description* *The requested resource () is not available.* -- Apache Tomcat/6.0.18 Thank You Dan Vega danv...@gmail.com http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319941 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mod Rewrite for blog cfc
The 404 is coming from tomcat. A... I ran into the same problem with Tomcat and IIRC it is cuz Tomcat does not support SES URL's .It was on Cento at the time. I could be wrong. You can ask them on the Railo Talk list http://tech.groups.yahoo.com/group/railo_talk/ G! On Sat, Feb 28, 2009 at 8:55 AM, Dan Vega danv...@gmail.com wrote: The 404 is coming from tomcat. HTTP Status 404 - -- *type* Status report *message* *description* *The requested resource () is not available.* -- Apache Tomcat/6.0.18 Thank You Dan Vega danv...@gmail.com http://www.danvega.org On Sat, Feb 28, 2009 at 2:09 AM, James Holmes james.hol...@gmail.com wrote: By default, the mod_rewrite rules aren't necessary; BlogCFC handles those friendly URLs internally. Is it Apache that gives you 404 or Railo? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/28 Dan Vega danv...@gmail.com: I got my blog running on Railo and anytime i go to a url that looks like this http://dev.danvega.org/blog/index.cfm/2009/2/5/CFMU-Updates-coming-soon I get a 404 error. This is because I neeed to add some re write rules into apache right? Anyone have these rules for blogcfc? Thank You Dan Vega danv...@gmail.com http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mod Rewrite for blog cfc
Add the following to Tomcat's web.xml and restart it. servlet-mapping servlet-nameCFMLServlet/servlet-name url-pattern/index.cfm/*/url-pattern /servlet-mapping ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319945 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
AW: Mod Rewrite for blog cfc
Gerald, you're right. Tomcat only allows one * per mapping. I do not know whether BlogCFC supports some kind of different mapping or not, but we will inform you as soon as the guys from JBoss come up with a solution for this. Instead of Tomcat you can use Resin which supports SES URL's Greetings from Switzerland Gert Franz Railo Technologies GmbH gert.fr...@railo.ch www.railo.ch Join our Mailing List german: http://de.groups.yahoo.com/group/railo/ english:http://groups.yahoo.com/group/railo_talk/ linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 Bug tracker:http://jira.jboss.org/jira/browse/RAILO Railo Blog: http://www.railo-technologies.com/blog -Ursprüngliche Nachricht- Von: Gerald Guido [mailto:gerald.gu...@gmail.com] Gesendet: Samstag, 28. Februar 2009 16:18 An: cf-talk Betreff: Re: Mod Rewrite for blog cfc The 404 is coming from tomcat. A... I ran into the same problem with Tomcat and IIRC it is cuz Tomcat does not support SES URL's .It was on Cento at the time. I could be wrong. You can ask them on the Railo Talk list http://tech.groups.yahoo.com/group/railo_talk/ G! On Sat, Feb 28, 2009 at 8:55 AM, Dan Vega danv...@gmail.com wrote: The 404 is coming from tomcat. HTTP Status 404 - -- *type* Status report *message* *description* *The requested resource () is not available.* -- Apache Tomcat/6.0.18 Thank You Dan Vega danv...@gmail.com http://www.danvega.org On Sat, Feb 28, 2009 at 2:09 AM, James Holmes james.hol...@gmail.com wrote: By default, the mod_rewrite rules aren't necessary; BlogCFC handles those friendly URLs internally. Is it Apache that gives you 404 or Railo? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/28 Dan Vega danv...@gmail.com: I got my blog running on Railo and anytime i go to a url that looks like this http://dev.danvega.org/blog/index.cfm/2009/2/5/CFMU-Updates-coming-soon I get a 404 error. This is because I neeed to add some re write rules into apache right? Anyone have these rules for blogcfc? Thank You Dan Vega danv...@gmail.com http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AW: Mod Rewrite for blog cfc
The Servlet spec says one asterisk per mapping, and it must be at one end or another (not the middle). So Resin (which I've not used) is extending the spec if it supports multiple asterisks. A cleaner solution, if you want to stay pure-JEE, is to use a rewriting filter like UrlRewrite. Then you can support arbitrary URL formats without a dependence on one specific web container. cheers, barneyb --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Feb 28, 2009, at 10:18 AM, Gert Franz gert.fr...@railo.ch wrote: Gerald, you're right. Tomcat only allows one * per mapping. I do not know whether BlogCFC supports some kind of different mapping or not, but we will inform you as soon as the guys from JBoss come up with a solution for this. Instead of Tomcat you can use Resin which supports SES URL's Greetings from Switzerland Gert Franz Railo Technologies GmbH gert.fr...@railo.ch www.railo.ch Join our Mailing List german:http://de.groups.yahoo.com/group/railo/ english:http://groups.yahoo.com/group/railo_talk/ linked in:http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 Bug tracker:http://jira.jboss.org/jira/browse/RAILO Railo Blog:http://www.railo-technologies.com/blog -Ursprüngliche Nachricht- Von: Gerald Guido [mailto:gerald.gu...@gmail.com] Gesendet: Samstag, 28. Februar 2009 16:18 An: cf-talk Betreff: Re: Mod Rewrite for blog cfc The 404 is coming from tomcat. A... I ran into the same problem with Tomcat and IIRC it is cuz Tomcat does not support SES URL's .It was on Cento at the time. I could be wrong. You can ask them on the Railo Talk list http://tech.groups.yahoo.com/group/railo_talk/ G! On Sat, Feb 28, 2009 at 8:55 AM, Dan Vega danv...@gmail.com wrote: The 404 is coming from tomcat. HTTP Status 404 - -- *type* Status report *message* *description* *The requested resource () is not available.* -- Apache Tomcat/6.0.18 Thank You Dan Vega danv...@gmail.com http://www.danvega.org On Sat, Feb 28, 2009 at 2:09 AM, James Holmes james.hol...@gmail.com wrote: By default, the mod_rewrite rules aren't necessary; BlogCFC handles those friendly URLs internally. Is it Apache that gives you 404 or Railo? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/28 Dan Vega danv...@gmail.com: I got my blog running on Railo and anytime i go to a url that looks like this http://dev.danvega.org/blog/index.cfm/2009/2/5/CFMU-Updates-coming-soon I get a 404 error. This is because I neeed to add some re write rules into apache right? Anyone have these rules for blogcfc? Thank You Dan Vega danv...@gmail.com http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AW: Mod Rewrite for blog cfc
Thanks for the advice guys! I would like to stay with tomcat just because I have stuff already setup in there and I have not tested my one openbd app on resign yet (i suspect its not an issue) but the url rewrite does not sound fun so, ill poke around. Thanks! Thank You Dan Vega danv...@gmail.com http://www.danvega.org On Sat, Feb 28, 2009 at 1:31 PM, Barney Boisvert bboisv...@gmail.comwrote: The Servlet spec says one asterisk per mapping, and it must be at one end or another (not the middle). So Resin (which I've not used) is extending the spec if it supports multiple asterisks. A cleaner solution, if you want to stay pure-JEE, is to use a rewriting filter like UrlRewrite. Then you can support arbitrary URL formats without a dependence on one specific web container. cheers, barneyb --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Feb 28, 2009, at 10:18 AM, Gert Franz gert.fr...@railo.ch wrote: Gerald, you're right. Tomcat only allows one * per mapping. I do not know whether BlogCFC supports some kind of different mapping or not, but we will inform you as soon as the guys from JBoss come up with a solution for this. Instead of Tomcat you can use Resin which supports SES URL's Greetings from Switzerland Gert Franz Railo Technologies GmbH gert.fr...@railo.ch www.railo.ch Join our Mailing List german:http://de.groups.yahoo.com/group/railo/ english:http://groups.yahoo.com/group/railo_talk/ linked in:http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 Bug tracker:http://jira.jboss.org/jira/browse/RAILO Railo Blog:http://www.railo-technologies.com/blog -Ursprüngliche Nachricht- Von: Gerald Guido [mailto:gerald.gu...@gmail.com] Gesendet: Samstag, 28. Februar 2009 16:18 An: cf-talk Betreff: Re: Mod Rewrite for blog cfc The 404 is coming from tomcat. A... I ran into the same problem with Tomcat and IIRC it is cuz Tomcat does not support SES URL's .It was on Cento at the time. I could be wrong. You can ask them on the Railo Talk list http://tech.groups.yahoo.com/group/railo_talk/ G! On Sat, Feb 28, 2009 at 8:55 AM, Dan Vega danv...@gmail.com wrote: The 404 is coming from tomcat. HTTP Status 404 - -- *type* Status report *message* *description* *The requested resource () is not available.* -- Apache Tomcat/6.0.18 Thank You Dan Vega danv...@gmail.com http://www.danvega.org On Sat, Feb 28, 2009 at 2:09 AM, James Holmes james.hol...@gmail.com wrote: By default, the mod_rewrite rules aren't necessary; BlogCFC handles those friendly URLs internally. Is it Apache that gives you 404 or Railo? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/28 Dan Vega danv...@gmail.com: I got my blog running on Railo and anytime i go to a url that looks like this http://dev.danvega.org/blog/index.cfm/2009/2/5/CFMU-Updates-coming-soon I get a 404 error. This is because I neeed to add some re write rules into apache right? Anyone have these rules for blogcfc? Thank You Dan Vega danv...@gmail.com http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AW: Mod Rewrite for blog cfc
Thanks for the advice guys! I would like to stay with tomcat just because I have stuff already setup in there and I have not tested my one openbd app on resign yet (i suspect its not an issue) but the url rewrite does not sound fun so, ill poke around. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Mod Rewrite for blog cfc
I got my blog running on Railo and anytime i go to a url that looks like this http://dev.danvega.org/blog/index.cfm/2009/2/5/CFMU-Updates-coming-soon I get a 404 error. This is because I neeed to add some re write rules into apache right? Anyone have these rules for blogcfc? Thank You Dan Vega danv...@gmail.com http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mod Rewrite for blog cfc
By default, the mod_rewrite rules aren't necessary; BlogCFC handles those friendly URLs internally. Is it Apache that gives you 404 or Railo? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/2/28 Dan Vega danv...@gmail.com: I got my blog running on Railo and anytime i go to a url that looks like this http://dev.danvega.org/blog/index.cfm/2009/2/5/CFMU-Updates-coming-soon I get a 404 error. This is because I neeed to add some re write rules into apache right? Anyone have these rules for blogcfc? Thank You Dan Vega danv...@gmail.com http://www.danvega.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT - Apache Mod Rewrite
Hello,
This question is about an Apache configuration problem I have recently. I hope
someone can help here!
In order to view the websites I develop locally easily I set up Apache mod
rewrite to map a url to a directory on the local filesystem. This way I do not
have to make a Virtual directory for every project but the URL is being
rewritten to map to a directory on the local system. Here's the setup:
I set up an A record in the DNS of my domain to point back to the local machine
wjenI use a special prefix in the URL:
*.local 127.0.0.1
(saying every subdomain ending with .local is to be redirected to localhost)
I set up Apache's httpd.config Mod Rewrite like this:
LoadModule rewrite_module modules/mod_rewrite.so
(remove the comment - # - sign)
RewriteEngine on
RewriteCond %{HTTP_HOST} (.*)\.local.mydomain.com
RewriteRule (/.*) D:/www/wwwroot/%1/$1
(saying: every request ending on local.mydomain.com has to be rerouted to the
directory D:/www/wwwroot/whatever preceded .local.mydomain.com/whatever
followed.local.mydomain.com)
This worked fine: if I had a directory d:/www/shipyards/q.cfm all I had to
enter in my address bar was http://shipyards.local.mydomain.com/ q.cfm and
q.cfm was served.
Until yesterday, the same url (http://shipyards.local.mydomain.com/q.cfm) only
gives me this response
---
Bad Request
Your browser sent a request that this server could not understand.
---
Apache_error log gives this:
[Sat Jun 14 13:29:10 2008] [error] [client 127.0.0.1] Invalid URI in request
GET / HTTP/1.1
[Sat Jun 14 13:29:20 2008] [error] [client 127.0.0.1] Invalid URI in request
GET /q.cfm HTTP/1.1
Apache access log gives this:
---
127.0.0.1 - - [14/Jun/2008:13:29:10 +0200] GET / HTTP/1.1 400 226
127.0.0.1 - - [14/Jun/2008:13:29:20 +0200] GET /q.cfm HTTP/1.1 400 226
---
I have no idea why the web browser doesn't recognize these requests anymore and
there is nothing that comes to mind I might have changed that caused this
behaviour. I tried setting up Virtual Hosts to circumevent the problemn but
there Apache won't start for other errors in the config file. And actually I
want the situations with Mod rewrite back as before.
Can anyone here help me out?
Thanks!
Windows XP SP2
WAMP Server:
Apache 2.2.8
FireFox 2.0.0.14 / IE 7.0.5730.13
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307482
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Apache Mod Rewrite
Ok, I found it. Somehow the local system account was removed from the list of accounts having access to D:. After adding it everything worked as before. A clue was given by Perfectdisk who reported You appear to have lost a disk. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307493 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Quick help on a mod rewrite rule
I apologize for those of you who may have seen this post on another list this morning... I'm having trouble finding an answer. I really suck at these. I need a rule that will turn this: http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.htm Into this: http://www.wheretobuild.com/States/index.cfm?StateName=Kansas I know that there are some regex and SES experts on this list. Can any of you do in like 10 seconds? My first 3 attempts based on samples failed... -mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269518 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick help on a mod rewrite rule
Mark, What web server are you using? Steve Brownlee http://www.fusioncube.net/ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:48 AM To: CF-Talk Subject: Quick help on a mod rewrite rule I apologize for those of you who may have seen this post on another list this morning... I'm having trouble finding an answer. I really suck at these. I need a rule that will turn this: http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.htm Into this: http://www.wheretobuild.com/States/index.cfm?StateName=Kansas I know that there are some regex and SES experts on this list. Can any of you do in like 10 seconds? My first 3 attempts based on samples failed... -mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269522 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick help on a mod rewrite rule
Well I'm not going to do a very good job without seeing the rest of the
samples... but something like this:
RewriteCond %{HTTP_HOST}^www.wheretobuild.com$ [NC]
RewriteCond %{REQUEST_URI} ^/States/xq/ASP/StateName\.(.+)+/qx/index.htm$
[NC]
RewriteRule ^/(.*)$ http://
www.wheretobuild.com/States/index.cfm?StateName=%1 [R=301,L]
This is not tested, but this should work...
Russ
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 11:48 AM
To: CF-Talk
Subject: Quick help on a mod rewrite rule
I apologize for those of you who may have seen this post on another list
this morning... I'm having trouble finding an answer.
I really suck at these. I need a rule that will turn this:
http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.htm
Into this:
http://www.wheretobuild.com/States/index.cfm?StateName=Kansas
I know that there are some regex and SES experts on this list. Can any of
you do in like 10 seconds? My first 3 attempts based on samples
failed...
-mark
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269523
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick help on a mod rewrite rule
Pretty sure it's apache, since he mentioned mod_rewrite... Russ -Original Message- From: Steve Brownlee [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:53 AM To: CF-Talk Subject: RE: Quick help on a mod rewrite rule Mark, What web server are you using? Steve Brownlee http://www.fusioncube.net/ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:48 AM To: CF-Talk Subject: Quick help on a mod rewrite rule I apologize for those of you who may have seen this post on another list this morning... I'm having trouble finding an answer. I really suck at these. I need a rule that will turn this: http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.htm Into this: http://www.wheretobuild.com/States/index.cfm?StateName=Kansas I know that there are some regex and SES experts on this list. Can any of you do in like 10 seconds? My first 3 attempts based on samples failed... -mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269524 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Quick help on a mod rewrite rule
To do this in apache, you don't even need mod_rewrite. RedirectMatch /States/xq/ASP/StateName\.(\w+)/qx/index.htm /States/index.cfm?StateName=$1 Don't know if IIS has something like RedirectMatch or not... -Ryan Russ wrote: Pretty sure it's apache, since he mentioned mod_rewrite... Russ -Original Message- From: Steve Brownlee [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:53 AM To: CF-Talk Subject: RE: Quick help on a mod rewrite rule Mark, What web server are you using? Steve Brownlee http://www.fusioncube.net/ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:48 AM To: CF-Talk Subject: Quick help on a mod rewrite rule I apologize for those of you who may have seen this post on another list this morning... I'm having trouble finding an answer. I really suck at these. I need a rule that will turn this: http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.htm Into this: http://www.wheretobuild.com/States/index.cfm?StateName=Kansas I know that there are some regex and SES experts on this list. Can any of you do in like 10 seconds? My first 3 attempts based on samples failed... -mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick help on a mod rewrite rule
Actually no ... It's IIS - but I'm using an ISAPI filter that mimics mod rewrite... -mark -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 10:57 AM To: CF-Talk Subject: RE: Quick help on a mod rewrite rule Pretty sure it's apache, since he mentioned mod_rewrite... Russ -Original Message- From: Steve Brownlee [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:53 AM To: CF-Talk Subject: RE: Quick help on a mod rewrite rule Mark, What web server are you using? Steve Brownlee http://www.fusioncube.net/ -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, February 12, 2007 11:48 AM To: CF-Talk Subject: Quick help on a mod rewrite rule I apologize for those of you who may have seen this post on another list this morning... I'm having trouble finding an answer. I really suck at these. I need a rule that will turn this: http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.ht m Into this: http://www.wheretobuild.com/States/index.cfm?StateName=Kansas I know that there are some regex and SES experts on this list. Can any of you do in like 10 seconds? My first 3 attempts based on samples failed... -mark ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick help on a mod rewrite rule
This would possibly work except it is not flexible. I have other URLs that
contain params.. Sometimes more than 1. I need to be able to:
1. match the first part of the URL
2. Discard the end part - the part that is /qx/index.htm
3. Turn the middle part into a query string
4. Rewrite the URL to the proper handler with the query string...
In addition, this doesn't look like the rules I'm writing Perhaps it's
not as mod_rewritish as I thought. The filter is called ionicIsapRewriter
and I've used it for Farcry sites with this rule:
RewriteRule .*/go([^\?]*)(?:\?(.*))? /go.cfm?path=/go$1$2
Does that syntax look familiar to anyone?
-mark
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 10:57 AM
To: CF-Talk
Subject: RE: Quick help on a mod rewrite rule
Well I'm not going to do a very good job without seeing the rest of the
samples... but something like this:
RewriteCond %{HTTP_HOST}^www.wheretobuild.com$ [NC]
RewriteCond %{REQUEST_URI} ^/States/xq/ASP/StateName\.(.+)+/qx/index.htm$
[NC]
RewriteRule ^/(.*)$ http://
www.wheretobuild.com/States/index.cfm?StateName=%1 [R=301,L]
This is not tested, but this should work...
Russ
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 11:48 AM
To: CF-Talk
Subject: Quick help on a mod rewrite rule
I apologize for those of you who may have seen this post on another
list this morning... I'm having trouble finding an answer.
I really suck at these. I need a rule that will turn this:
http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.ht
m
Into this:
http://www.wheretobuild.com/States/index.cfm?StateName=Kansas
I know that there are some regex and SES experts on this list. Can any
of you do in like 10 seconds? My first 3 attempts based on samples
failed...
-mark
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269533
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick help on a mod rewrite rule
Well I think that's the problem right there... you're not using Apache and
mod_rewrite. I know I can probably figure out the syntax, but I'll let one
of the people who claim that IIS is just as good as apache lend a hand...
since they use the functionality in IIS all the time...
Russ
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 12:24 PM
To: CF-Talk
Subject: RE: Quick help on a mod rewrite rule
This would possibly work except it is not flexible. I have other URLs that
contain params.. Sometimes more than 1. I need to be able to:
1. match the first part of the URL
2. Discard the end part - the part that is /qx/index.htm
3. Turn the middle part into a query string
4. Rewrite the URL to the proper handler with the query string...
In addition, this doesn't look like the rules I'm writing Perhaps it's
not as mod_rewritish as I thought. The filter is called
ionicIsapRewriter
and I've used it for Farcry sites with this rule:
RewriteRule .*/go([^\?]*)(?:\?(.*))? /go.cfm?path=/go$1$2
Does that syntax look familiar to anyone?
-mark
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 10:57 AM
To: CF-Talk
Subject: RE: Quick help on a mod rewrite rule
Well I'm not going to do a very good job without seeing the rest of the
samples... but something like this:
RewriteCond %{HTTP_HOST} ^www.wheretobuild.com$ [NC]
RewriteCond %{REQUEST_URI} ^/States/xq/ASP/StateName\.(.+)+/qx/index.htm$
[NC]
RewriteRule ^/(.*)$ http://
www.wheretobuild.com/States/index.cfm?StateName=%1[R=301,L]
This is not tested, but this should work...
Russ
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 11:48 AM
To: CF-Talk
Subject: Quick help on a mod rewrite rule
I apologize for those of you who may have seen this post on another
list this morning... I'm having trouble finding an answer.
I really suck at these. I need a rule that will turn this:
http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.ht
m
Into this:
http://www.wheretobuild.com/States/index.cfm?StateName=Kansas
I know that there are some regex and SES experts on this list. Can any
of you do in like 10 seconds? My first 3 attempts based on samples
failed...
-mark
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269541
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Quick help on a mod rewrite rule
Well I think that's the problem right there... you're not using Apache and mod_rewrite. I know I can probably figure out the syntax, but I'll let one of the people who claim that IIS is just as good as apache lend a hand... since they use the functionality in IIS all the time... I'll bet you the syntax to rewrite these URLs for this rewriter is identical to that for mod_rewrite. 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! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick help on a mod rewrite rule
Since nobody volunteered... Here is something that should work for apache,
and you can try to convert it to ionicIsapiRewrite (since Dave Watts seems
to think the syntax should be the same).
RewriteCond %{HTTP_HOST}^www.wheretobuild.com$ [NC]
RewriteCond %{REQUEST_URI} ^/States/xq/ASP/(.+)+\.(.+)+/qx/index.htm$ [NC]
RewriteRule ^/(.*)$ http://www.wheretobuild.com/States/index.cfm?%1=%2
[R=301,L]
This should work for any variable name... not just StateName.
I think if you write a few more rules, one for 2 variables, and 1 for 3
variables, etc you should be good.
I can't really be of more help without knowing what the rest of the url's
look like.
Russ
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 12:24 PM
To: CF-Talk
Subject: RE: Quick help on a mod rewrite rule
This would possibly work except it is not flexible. I have other URLs that
contain params.. Sometimes more than 1. I need to be able to:
1. match the first part of the URL
2. Discard the end part - the part that is /qx/index.htm
3. Turn the middle part into a query string
4. Rewrite the URL to the proper handler with the query string...
In addition, this doesn't look like the rules I'm writing Perhaps it's
not as mod_rewritish as I thought. The filter is called
ionicIsapRewriter
and I've used it for Farcry sites with this rule:
RewriteRule .*/go([^\?]*)(?:\?(.*))? /go.cfm?path=/go$1$2
Does that syntax look familiar to anyone?
-mark
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 10:57 AM
To: CF-Talk
Subject: RE: Quick help on a mod rewrite rule
Well I'm not going to do a very good job without seeing the rest of the
samples... but something like this:
RewriteCond %{HTTP_HOST} ^www.wheretobuild.com$ [NC]
RewriteCond %{REQUEST_URI} ^/States/xq/ASP/StateName\.(.+)+/qx/index.htm$
[NC]
RewriteRule ^/(.*)$ http://
www.wheretobuild.com/States/index.cfm?StateName=%1[R=301,L]
This is not tested, but this should work...
Russ
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, February 12, 2007 11:48 AM
To: CF-Talk
Subject: Quick help on a mod rewrite rule
I apologize for those of you who may have seen this post on another
list this morning... I'm having trouble finding an answer.
I really suck at these. I need a rule that will turn this:
http://www.wheretobuild.com/States/xq/ASP/StateName.Kansas/qx/index.ht
m
Into this:
http://www.wheretobuild.com/States/index.cfm?StateName=Kansas
I know that there are some regex and SES experts on this list. Can any
of you do in like 10 seconds? My first 3 attempts based on samples
failed...
-mark
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269577
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
grouped output and Mod 2
Im trying to make a table output grouped query info. Then i want to make a 2 column list of the grouped data within. Dynamically generating the Tr's in the right spots. I'm finding that using MOD wont work because i never know where ill be starting the row at after the title Any thoughts? cfquery name=Services datasource=#DSN# username=#dbusername# password=#dbpassword# Select TYPE, NAME, ID from BUSINESS Order by TYPE ASC /cfquery table cfoutput query=Services group=TYPE tr th colspan=2 class=title #TYPE# /th /tr cfoutput cfif Services.currentrow mod 2 eq 1 tr /cfif td #NAME# /td cfif Services.currentrow mod 2 eq 0 tr /cfif /cfoutput /cfoutput /table -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: grouped output and Mod 2
set a counter var and increment it inside the inner cfoutput cfoutput group=foo cfset counter = 0 / cfoutput !--- begin inner cfoutput --- cfset counter = counter + 1 / cfif counter MOD 2 EQ 0 do stuff cfelse do other stuff /cfif /cfoutput /cfoutput On 12/21/06, Richard Dillman [EMAIL PROTECTED] wrote: Im trying to make a table output grouped query info. Then i want to make a 2 column list of the grouped data within. Dynamically generating the Tr's in the right spots. I'm finding that using MOD wont work because i never know where ill be starting the row at after the title Any thoughts? cfquery name=Services datasource=#DSN# username=#dbusername# password=#dbpassword# Select TYPE, NAME, ID from BUSINESS Order by TYPE ASC /cfquery table cfoutput query=Services group=TYPE tr th colspan=2 class=title #TYPE# /th /tr cfoutput cfif Services.currentrow mod 2 eq 1 tr /cfif td #NAME# /td cfif Services.currentrow mod 2 eq 0 tr /cfif /cfoutput /cfoutput /table -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: grouped output and Mod 2
geee i feel dumb now Backing away from the keyboard. On 12/21/06, Charlie Griefer [EMAIL PROTECTED] wrote: set a counter var and increment it inside the inner cfoutput cfoutput group=foo cfset counter = 0 / cfoutput !--- begin inner cfoutput --- cfset counter = counter + 1 / cfif counter MOD 2 EQ 0 do stuff cfelse do other stuff /cfif /cfoutput /cfoutput On 12/21/06, Richard Dillman [EMAIL PROTECTED] wrote: Im trying to make a table output grouped query info. Then i want to make a 2 column list of the grouped data within. Dynamically generating the Tr's in the right spots. I'm finding that using MOD wont work because i never know where ill be starting the row at after the title Any thoughts? cfquery name=Services datasource=#DSN# username=#dbusername# password=#dbpassword# Select TYPE, NAME, ID from BUSINESS Order by TYPE ASC /cfquery table cfoutput query=Services group=TYPE tr th colspan=2 class=title #TYPE# /th /tr cfoutput cfif Services.currentrow mod 2 eq 1 tr /cfif td #NAME# /td cfif Services.currentrow mod 2 eq 0 tr /cfif /cfoutput /cfoutput /table -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MOD
On Friday 07 October 2005 18:29, Larry Lyons wrote: Simpler? Lets see about 1 line of cf code and 3 or so for the stylesheet vs at least 10 for the javascript. But you've now scattered table zebra/sort code all over your server side. Just setting a class, and having a javascript include is much less work (after the first one !) JS off. Can't login to our site with it off :-) Seriously, I don't think most people have it turned off. -- 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:220527 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: MOD
Thanks Rick, Matthew and Ray. All works well w/all the suggestions incorporated. Robert O. A simpler way would be to create 2 styles, lets call one results1 and the other results0 then you can have something like this: td class= results#currentRow mod 2#etc./td larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| 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:220328 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: MOD
On Friday 07 October 2005 15:14, Larry Lyons wrote: A simpler way would be to create 2 styles, lets call one results1 and the other results0 Simpler is what we do here- give the table the class 'sortable' or 'zebrastrip' and the common javascript code zebra strips it client-side, with optional sorting by clicking the th cells. Next mission is to make it do client-side paging to. -- 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:220332 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: MOD
Simpler is what we do here- give the table the class 'sortable' or 'zebrastrip' and the common javascript code zebra strips it client-side, with optional sorting by clicking the th cells. Nice feature indeed, but I wouldn't say is is simpler ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:220333 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: MOD
oooh...lookit...a can. label says client side vs server side...open with caution /me throws caution to the wind. rips open can. oooh! worms! On 10/7/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Friday 07 October 2005 15:14, Larry Lyons wrote: A simpler way would be to create 2 styles, lets call one results1 and the other results0 Simpler is what we do here- give the table the class 'sortable' or 'zebrastrip' and the common javascript code zebra strips it client-side, with optional sorting by clicking the th cells. Next mission is to make it do client-side paging to. -- 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:220334 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: MOD
On Friday 07 October 2005 15:25, Claude Schneegans wrote: Nice feature indeed, but I wouldn't say is is simpler ;-) It means the server side business stuff doesn't need to care about client side layout at all - it just spits out a bare HTML table with a vague hint that it should be sortable. -- 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:220341 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: MOD
It means the server side business stuff doesn't need to care about client side layout at all I agree, however, some programer had to develop the Javascript stuff at some time. ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:220372 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: MOD
On Friday 07 October 2005 15:14, Larry Lyons wrote: A simpler way would be to create 2 styles, lets call one results1 and the other results0 Simpler is what we do here- give the table the class 'sortable' or 'zebrastrip' and the common javascript code zebra strips it client-side, with optional sorting by clicking the th cells. Next mission is to make it do client-side paging to. -- Tom Chiverton Advanced ColdFusion Programmer Simpler? Lets see about 1 line of cf code and 3 or so for the stylesheet vs at least 10 for the javascript. Also lets not forget that many people turn JS off. If that's your definition of simple, then you have a bright future with the Bush administration. larry ~| 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:220378 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
MOD
I know this is an old one and very easy one, but I lost the code...how do I do a dynamic alternate row of color? I remember it was with the MOD command. Thanks as always. Robert O. HW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.9/118 - Release Date: 10/3/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:220195 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: MOD
cfif #somequery.CurrentRow# mod 2 cfset color = 66 cfelse cfset color = 220088 /cfif Matt - Original Message - From: Orlini, Robert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 06, 2005 8:01 AM Subject: MOD I know this is an old one and very easy one, but I lost the code...how do I do a dynamic alternate row of color? I remember it was with the MOD command. Thanks as always. Robert O. HW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.9/118 - Release Date: 10/3/2005 ~| 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:220198 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: MOD
something along these lines? cfif CurrentRow MOD 2 EQ 0 cfset bgcolor = ##00 cfelse cfset bgcolor = ##FF /cfif td bgcolor=#bgcolor#blah blah blah/td I know there's like 100 iterations of this same concept, but this is what I remember using the last time I did this Ray Orlini, Robert wrote: I know this is an old one and very easy one, but I lost the code...how do I do a dynamic alternate row of color? I remember it was with the MOD command. Thanks as always. Robert O. HW -- = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.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:220199 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: MOD
cfoutput query=queryname td bgcolor=#iif(queryname.rowcount mod 2 eq 1,DE(RED),DE(BLUE))# /cfoutput Check my syntax to make sure it's right. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 9:01 AM To: CF-Talk Subject: MOD I know this is an old one and very easy one, but I lost the code...how do I do a dynamic alternate row of color? I remember it was with the MOD command. Thanks as always. Robert O. HW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.9/118 - Release Date: 10/3/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:220200 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: MOD
Orlini, Robert wrote: I know this is an old one and very easy one, but I lost the code...how do I do a dynamic alternate row of color? I remember it was with the MOD command. trcfif currentrow mod 2 is 1 bgcolor=cc/cfif Feel free to use alternate styles instead of the bgcolor or whatever, but you get the idea. This assumes you're inside a cfoutput query=... loop, making the currentrow variable available. Rick ~| 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:220201 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: MOD
Thanks Rick, Matthew and Ray. All works well w/all the suggestions incorporated. Robert O. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 9:19 AM To: CF-Talk Subject: Re: MOD Orlini, Robert wrote: I know this is an old one and very easy one, but I lost the code...how do I do a dynamic alternate row of color? I remember it was with the MOD command. trcfif currentrow mod 2 is 1 bgcolor=cc/cfif Feel free to use alternate styles instead of the bgcolor or whatever, but you get the idea. This assumes you're inside a cfoutput query=... loop, making the currentrow variable available. Rick ~| 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:220205 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: MOD
Or you could do it in one line with iif. cfset color = iif(somequery.CurrentRow mod 2,66,220088) Also note that if you choose to use Matthew's way, which works just fine too, it's not necessary to pound the somequery.CurrentRow variable. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Matthew Blatchley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 8:15 AM To: CF-Talk Subject: Re: MOD cfif #somequery.CurrentRow# mod 2 cfset color = 66 cfelse cfset color = 220088 /cfif Matt - Original Message - From: Orlini, Robert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 06, 2005 8:01 AM Subject: MOD I know this is an old one and very easy one, but I lost the code...how do I do a dynamic alternate row of color? I remember it was with the MOD command. Thanks as always. Robert O. HW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.9/118 - Release Date: 10/3/2005 ~| 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:220219 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: MOD
bad iif, bad go to the corner :) On 10/6/05, Andy Matthews [EMAIL PROTECTED] wrote: Or you could do it in one line with iif. cfset color = iif(somequery.CurrentRow mod 2,66,220088) Also note that if you choose to use Matthew's way, which works just fine too, it's not necessary to pound the somequery.CurrentRow variable. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Matthew Blatchley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 8:15 AM To: CF-Talk Subject: Re: MOD cfif #somequery.CurrentRow# mod 2 cfset color = 66 cfelse cfset color = 220088 /cfif Matt - Original Message - From: Orlini, Robert [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 06, 2005 8:01 AM Subject: MOD I know this is an old one and very easy one, but I lost the code...how do I do a dynamic alternate row of color? I remember it was with the MOD command. Thanks as always. Robert O. HW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.9/118 - Release Date: 10/3/2005 ~| 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:220227 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: SPAM-LOW: RE: MOD
Andy Matthews wrote:
Or you could do it in one line with iif.
cfset color = iif(somequery.CurrentRow mod 2,66,220088)
Also note that if you choose to use Matthew's way, which works just fine
too, it's not necessary to pound the somequery.CurrentRow variable.
It never ceases to amaze me that many developers strive for code reuse
and modularization and separating business logic from presentational
code but rarely seem to apply the same principles to their HTML coding ;-)
Regardless of the CF syntax used (iff / cfif), here's a more efficient
way to code this functionality:
The following CSS code should be put in an external style sheet:
..evenRow {
background-color: #ccc;
}
..oddRow {
background-color: #fff;
}
Then in the cfm template:
cfset rowClass = oddRow
table
cfoutput query=someQuery
cfif someQuery.CurrentRow mod 2
cfset rowClass = oddRow
cfelse
cfset rowClass = evenRow
/cfif
tr class=#rowClass#
td#someQuery.CurrentRow#/td
tdsome data/td
/tr
/cfoutput
/table
This way the actual colors used are not hardwired in the template and
can be changed from the CSS file and the HTML markup is separate from
the presentation.
Cheers!
Stéphane Bergeron
~|
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:220246
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
Slashdot Mod points wanted!!
http://books.slashdot.org/comments.pl?sid=146789cid=12297023 Someone with Slashdot points, mod this post up. ;-) Jack ~| 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:203790 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
mod command to alter row color
I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? Thanks. Robert O. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183157 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: mod command to alter row color
put this in your tr tag cfif query.CurrentRow MOD 2 EQ 0bgcolor=##00cfelsebgcolor=##f/cfif it think that's right. On Tue, 2 Nov 2004 13:24:19 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? Thanks. Robert O. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183160 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: mod command to alter row color
From: Robert Orlini [mailto:[EMAIL PROTECTED] I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? cfif queryName.CurrentRow MOD 2 EQ 0 Red cfelse Blue /cfif Mike ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183162 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: mod command to alter row color
I generally start by setting up two CSS classes, with similar names ending
in 0/1.
style type=text/css
tr.rowstyle1 {
background-color: #ff;
}
tr.rowstyle0 {
background-color: #e0e0e0;
}
/style
cfoutput
cfloop query=somequery
tr class=rowstyle#Evaluate('somequery.currentrow mod 2')#
...
/tr
/cfloop
/cfoutput
Or you can use IIf() if not using CSS:
cfoutput
cfloop query=somequery
tr background=#IIf(somequery.currentrow mod 2, DE('##ff'),
DE('##e0e0e0'))#
...
/tr
/cfloop
/cfoutput
- Original Message -
From: Robert Orlini [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 02, 2004 11:24 AM
Subject: mod command to alter row color
I know this is an easy one, but can't find the right code.
How do I have CF alternate color for each row of a table?
Anyone have the code please?
Thanks.
Robert O.
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183163
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: mod command to alter row color
--- Robert Orlini [EMAIL PROTECTED] wrote: How do I have CF alternate color for each row of a table? Anyone have the code please? I wrote a UDF to do just that. http://cflib.org/udf.cfm?ID=901 On of its perks is that you're not limited to two colors. You can put as many into the list of colors as you like. __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183168 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: mod command to alter row color
Get rid of that evaluate, it's unneeded:
style
tr.alt1 { background-color: #fff; }
tr.alt0 { background-color: #ffc; }
/style
cfoutput
table
cfloop query=myQuery
tr class=alt#currentRow MOD 2#
...
/tr
/cfloop
/table
/cfoutput
On Tue, 2 Nov 2004 11:42:55 -0700, Jim McAtee [EMAIL PROTECTED] wrote:
I generally start by setting up two CSS classes, with similar names ending
in 0/1.
style type=text/css
tr.rowstyle1 {
background-color: #ff;
}
tr.rowstyle0 {
background-color: #e0e0e0;
}
/style
cfoutput
cfloop query=somequery
tr class=rowstyle#Evaluate('somequery.currentrow mod 2')#
...
/tr
/cfloop
/cfoutput
Or you can use IIf() if not using CSS:
cfoutput
cfloop query=somequery
tr background=#IIf(somequery.currentrow mod 2, DE('##ff'),
DE('##e0e0e0'))#
...
/tr
/cfloop
/cfoutput
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/
I currently have 0 GMail invites for the taking
~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183171
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: mod command to alter row color
It's necessary in CF5 and earlier.
- Original Message -
From: Barney Boisvert [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 02, 2004 11:54 AM
Subject: Re: mod command to alter row color
Get rid of that evaluate, it's unneeded:
style
tr.alt1 { background-color: #fff; }
tr.alt0 { background-color: #ffc; }
/style
cfoutput
table
cfloop query=myQuery
tr class=alt#currentRow MOD 2#
...
/tr
/cfloop
/table
/cfoutput
On Tue, 2 Nov 2004 11:42:55 -0700, Jim McAtee [EMAIL PROTECTED]
wrote:
I generally start by setting up two CSS classes, with similar names
ending
in 0/1.
style type=text/css
tr.rowstyle1 {
background-color: #ff;
}
tr.rowstyle0 {
background-color: #e0e0e0;
}
/style
cfoutput
cfloop query=somequery
tr class=rowstyle#Evaluate('somequery.currentrow mod 2')#
...
/tr
/cfloop
/cfoutput
Or you can use IIf() if not using CSS:
cfoutput
cfloop query=somequery
tr background=#IIf(somequery.currentrow mod 2, DE('##ff'),
DE('##e0e0e0'))#
...
/tr
/cfloop
/cfoutput
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183177
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: mod command to alter row color
This only works in CFMX. But you could use another function for numeric
values (like val())
Pascal
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: 02 November 2004 19:54
To: CF-Talk
Subject: Re: mod command to alter row color
Get rid of that evaluate, it's unneeded:
style
tr.alt1 { background-color: #fff; }
tr.alt0 { background-color: #ffc; }
/style
cfoutput
table
cfloop query=myQuery
tr class=alt#currentRow MOD 2#
...
/tr
/cfloop
/table
/cfoutput
On Tue, 2 Nov 2004 11:42:55 -0700, Jim McAtee
[EMAIL PROTECTED]
wrote:
I generally start by setting up two CSS classes, with similar names
ending
in 0/1.
style type=text/css
tr.rowstyle1 {
background-color: #ff;
}
tr.rowstyle0 {
background-color: #e0e0e0;
}
/style
cfoutput
cfloop query=somequery
tr class=rowstyle#Evaluate('somequery.currentrow mod 2')#
...
/tr
/cfloop
/cfoutput
Or you can use IIf() if not using CSS:
cfoutput
cfloop query=somequery
tr background=#IIf(somequery.currentrow mod 2, DE('##ff'),
DE('##e0e0e0'))#
...
/tr
/cfloop
/cfoutput
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/
I currently have 0 GMail invites for the taking
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183184
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: mod command to alter row color
Two more ways to skin this cat. First a real old one tr bgcolor=#iif(GetData.CurrentRow MOD 2, DE(variables.RowColor1), DE(variables.RowColor2))# and what I use now. Store the row colors in a var in application.cfm or something: my.RowColors=##EDEDED,##FBFBFB; and then use this in the table: tr bgcolor=#listgetat(my.RowColors,(GetData.CurrentRow MOD 2)+1)# No clue as to their relative efficiency to other things posted here. I suppose the second method could accomodate more than two colors without difficulty. Just add one to the var and change the MOD factor. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183185 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: mod command to alter row color
Thank you. One question, in this part of the code: cfloop from=1 to=10 index=i How would I make it infinite? I don't want it to end at the 10th row? Robert O. -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 1:35 PM To: CF-Talk Subject: Re: mod command to alter row color put this in your tr tag cfif query.CurrentRow MOD 2 EQ 0bgcolor=##00cfelsebgcolor=##f/cfif it think that's right. On Tue, 2 Nov 2004 13:24:19 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? Thanks. Robert O. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183186 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: mod command to alter row color
look into a conditional loop then...as I'm sure you'd want to break out at some point ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183187 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: mod command to alter row color
Unot sure why you'd want to do that, but here's the fastest infinite loop I can think of: cfloop condition=true !--- do stuff. over and over. --- /cfloop -joe On Tue, 2 Nov 2004 14:11:28 -0500, Robert Orlini [EMAIL PROTECTED] wrote: Thank you. One question, in this part of the code: cfloop from=1 to=10 index=i How would I make it infinite? I don't want it to end at the 10th row? Robert O. -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 1:35 PM To: CF-Talk Subject: Re: mod command to alter row color put this in your tr tag cfif query.CurrentRow MOD 2 EQ 0bgcolor=##00cfelsebgcolor=##f/cfif it think that's right. On Tue, 2 Nov 2004 13:24:19 -0500, Robert Orlini [EMAIL PROTECTED] wrote: I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Anyone have the code please? Thanks. Robert O. ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183189 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: mod command to alter row color
Robert Orlini wrote: I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Don't do it in CF, use CSS and javascript and ship it off to the client for processing. Example (BSD licensed) at http://spike.oli.tudelft.nl/jochemd/test/resnet/richtables.html Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183197 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: mod command to alter row color
Hi Jochem, Don't want to start a war here but I really disagree. The less that browsers have to do, the less chance they have to be inconsistent (with each other and w3c). PS. Your link is broken: Parameter entity must be defined before it is used. Error processing resource 'http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd'. Line 85, Position 2 %xhtml-prefw-redecl.mod; - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 3:00 PM Subject: Re: mod command to alter row color Robert Orlini wrote: I know this is an easy one, but can't find the right code. How do I have CF alternate color for each row of a table? Don't do it in CF, use CSS and javascript and ship it off to the client for processing. Example (BSD licensed) at http://spike.oli.tudelft.nl/jochemd/test/resnet/richtables.html Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183209 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: mod command to alter row color
Dave Francis wrote: Don't want to start a war here but I really disagree. The less that browsers have to do, the less chance they have to be inconsistent (with each other and w3c). If it works now, use it. I find it hard to believe there will ever be new user agents released that are less conforming then the current ones. PS. Your link is broken: Parameter entity must be defined before it is used. Error processing resource 'http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd'. Line 85, Position 2 I do not consider the link broken, but whatever user agent you are using. That issue is on purpose and is due to a script tag using shorthand closing. Easily solved by substituting script ... / with script .../script if you are so inclined. I am not, and the W3C validates the page: http://validator.w3.org/check?verbose=1uri=http%3A//spike.oli.tudelft.nl/jochemd/test/resnet/richtables.html http://jigsaw.w3.org/css-validator/validator?profile=css2warning=2uri=http%3A//spike.oli.tudelft.nl/jochemd/test/resnet/richtables.html Jochem ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183215 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: mod command to alter row color
That page doesn't work in IE, although Firefox renders it. With Firefox' desired market penetration curve you should be visible to 10% of browsers within 5 years. Its wonderful here over on the Dark Side. Couldn't you meet us halfway? Just bite the head off of *one* bat. Just one. :D man I gotta get away from this dam crt for awhile. Losing it. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183217 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: mod command to alter row color
wont be no 10 yrs will be about 2 more months http://www.eweek.com/article2/0,1759,1706694,00.asp?kc=ewnws110204dtx1k599 get rid of the crap http://browsehappy.com/ -- Original Message -- From: Matt Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 2 Nov 2004 16:02:42 -0800 That page doesn't work in IE, although Firefox renders it. With Firefox' desired market penetration curve you should be visible to 10% of browsers within 5 years. Its wonderful here over on the Dark Side. Couldn't you meet us halfway? Just bite the head off of *one* bat. Just one. :D man I gotta get away from this dam crt for awhile. Losing it. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183219 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: mod command to alter row color
Matt Robertson wrote: That page doesn't work in IE, although Firefox renders it. With Firefox' desired market penetration curve you should be visible to 10% of browsers within 5 years. Its wonderful here over on the Dark Side. Couldn't you meet us halfway? Just bite the head off of *one* bat. Just one. :D man I gotta get away from this dam crt for awhile. Losing it. lol. Just *one* bat. That's great. =P Actually I just read something recently (I think from news.com) where the market growth of Firefox is still growing at an alarming rate. That's kinda cool because it means they'll have that 10% is less then 5 years. ;) Still, I kind of agree that we, as web developers, need to make our applications work in as many browsers as possible. Unfortunately that still includes the now antiquated IE. =\ -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183220 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: mod command to alter row color
Actually I booted IE, Outlook and Outlook Express shortly after GDIPlus, and instantly after MS announced they weren't upgrading IE unless you had XPeee. So only 92.9% of users are using IE, and this is after a plunge in market share. Anyway the same article points to all Mozilla browsers, Netscape included, as having only 6%. My developer-oriented site has FireFox at 7.21% this week. No idea how many of those were me visiting my own site. Firefox has a way to go. A long way. Personally I hope it gets there but reality is what it is. Despite its unholy godawfulness IE is what people use. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183221 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: mod command to alter row color
then do your part on and spread the word! :) the only reason i have ANYTHING m$ on my comp is actually a macromedia issue until they do something different with the damn licensing methods and have it able to run on linux im stuck with this crap! ar -- Original Message -- From: Matt Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 2 Nov 2004 16:29:16 -0800 Actually I booted IE, Outlook and Outlook Express shortly after GDIPlus, and instantly after MS announced they weren't upgrading IE unless you had XPeee. So only 92.9% of users are using IE, and this is after a plunge in market share. Anyway the same article points to all Mozilla browsers, Netscape included, as having only 6%. My developer-oriented site has FireFox at 7.21% this week. No idea how many of those were me visiting my own site. Firefox has a way to go. A long way. Personally I hope it gets there but reality is what it is. Despite its unholy godawfulness IE is what people use. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183222 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: mod command to alter row color
Matt Robertson wrote: That page doesn't work in IE, although Firefox renders it. With Firefox' desired market penetration curve you should be visible to 10% of browsers within 5 years. Its wonderful here over on the Dark Side. Couldn't you meet us halfway? There has been a case where the decision was not up to me, and then it looks like http://resnet.tudelft.nl/resnet_00.php The problem there is that while the javascript is still in a separate file, you really need to dig out the CSS for the table from between all the other CSS. And IE users are missing out on all the :hover goodies and click events in the code Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183223 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: Group and CurrentRow MOD
I'm trying to group people by state, with two columns of names under each state heading. This works, other than some states don't always fill the second top column in the group. Some rows display correctly, and others don't. I have some states with 3 names that work correctly. I get STATE name1 name2 STATE name1 name2 name3 etc. How can I force the 2nd column to fill from the top of the group. I'm not sure if this will help or not, but you can check out my cf_recordcount tag. http://www.twcreations.com/recordcount/ It's designed to be able to return the top X number of records or X number of records per page based on any group out of a joined query. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Group and CurrentRow MOD
Try this out: cfset totalColumns = 2 cfoutput query=Pull_All_Members group=State tr valign=top td colspan=#totalColumns# valign=topstrong#RTrim(state)#/strong/td /tr cfset subRowNumber = 0 cfoutput cfset columnNumber = (subRowNumber MOD totalColumns) + 1 cfif columnNumber EQ 1tr valign=top/cfif td valign=top#Lastname#/td cfif columnNumber EQ totalColumns/tr/cfif cfset subRowNumber = subRowNumber + 1 /cfoutput cfset emptyColumns = totalColumns - columnNumber cfif emptyColumns GT 0 td colspan=#emptyColumns#nbsp;/td/tr /cfif /cfoutput I tested it and it can scale to any number of columns by changing the totalColumns variable. Mike Mertsock Alfred University Web Team ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Group and CurrentRow MOD
I'm trying to group people by state, with two columns of names under each state heading. This works, other than some states don't always fill the second top column in the group. Some rows display correctly, and others don't. I have some states with 3 names that work correctly. I get STATE name1 name2 STATE name1 name2 name3 etc. How can I force the 2nd column to fill from the top of the group. cfoutput query=Pull_All_Members group=State tr valign=top td colspan=2 valign=topstrong#RTrim(state)#/strong/td /tr cfoutput cfif Pull_All_Members.CurrentRow MOD 2 IS 1 tr valign=top cfset trOpen=true /cfif td valign=top#Lastname#/td cfif Pull_All_Members.CurrentRow MOD 2 IS 0 /tr cfset trOpen=false /cfif /cfoutput cfif trOpen /tr /cfif /cfoutput /table Thanks, Al ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Group and CurrentRow MOD
I'm trying to group people by state, with two columns of names under each state heading. This works, other than some states don't always fill the second top column in the group. Some rows display correctly, and others don't. I have some states with 3 names that work correctly. I get STATE name1 name2 STATE name1 name2 name3 etc. How can I force the 2nd column to fill from the top of the group. cfoutput query=Pull_All_Members group=State tr valign=top td colspan=2 valign=topstrong#RTrim(state)#/strong/td /tr cfoutput cfif Pull_All_Members.CurrentRow MOD 2 IS 1 tr valign=top cfset trOpen=true /cfif td valign=top#Lastname#/td cfif Pull_All_Members.CurrentRow MOD 2 IS 0 /tr cfset trOpen=false /cfif /cfoutput cfif trOpen /tr /cfif /cfoutput /table Thanks, Al ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Group and CurrentRow MOD
You can't really use currentrow with group - it throws it off. Best thing to do in those cases is create your own counter, that you refresh each time the group is looped on, and use that to do MODs on. That said, to do two columns the way you want, the manual counter bit won't work either. I'd suggest either doing your cfoutputs the same way you are now, but beforehand, and keep count of how many rows are present for each state, and then when you're doing your display, you'll know at what point in your manual counter for each state you need to start a fresh column. Either that way, or do a ValueList() on your state field in your query, loop over it and keep counts of how many times each state appears in the list, and use that to determine when to start fresh columns. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Using mod to display two across in a table...
I think I'm having a Friday brain fart. I want to output photos whose name is stored in a table and I want them to display two across, like so: Photo1 | Photo2 Photo3 | Photo4 Photo5 | Etc... And for some reason, I'm totally blanking on how to accomplish it... I know it's CurrentRow and modulus, but doggone it...I'm having no luck... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using mod to display two across in a table...
oi Jeff!! if query.currentrow mod 2 eq 0. Friday, June 6, 2003, 11:24:18 AM, you wrote: J I think I'm having a Friday brain fart. J I want to output photos whose name is stored in a table and I want them to J display two across, like so: J Photo1 | Photo2 J Photo3 | Photo4 J Photo5 | J Etc... J And for some reason, I'm totally blanking on how to accomplish it... J I know it's CurrentRow and modulus, but doggone it...I'm having no luck... J ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using mod to display two across in a table...
on 6/6/03 11:31 AM, Critz at [EMAIL PROTECTED] wrote: oi Jeff!! if query.currentrow mod 2 eq 0. ...then, what? This I can get. It's the closing of the table row that's throwing me off...in pseudocode, I see this: cfif query.currentrow mod 2 eq 0 cfoutput tr tdimg src=#image#/td tdimg src=#image#/td /tr /cfoutput /cfif But this obviously isn't right...arrrgh... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using mod to display two across in a table...
in the if statement issue a tr when it evaluates to true... Rgds Paolo Cesana IT Development Manager Electricity is not the result of a series of upgrades to the candle Auth. unknown MIF, an EGL Business Dedicated to problem-free transportation Phone: (305) 594-0038 ext. 7326 Fax: (305) 593-0431 e-mail: mailto:[EMAIL PROTECTED] WEB site: http://www.mif.com WEB site: http://www.eaglegl.com -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 11:42 AM To: CF-Talk Subject: Re: Using mod to display two across in a table... on 6/6/03 11:31 AM, Critz at [EMAIL PROTECTED] wrote: oi Jeff!! if query.currentrow mod 2 eq 0. ...then, what? This I can get. It's the closing of the table row that's throwing me off...in pseudocode, I see this: cfif query.currentrow mod 2 eq 0 cfoutput tr tdimg src=#image#/td tdimg src=#image#/td /tr /cfoutput /cfif But this obviously isn't right...arrrgh... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using mod to display two across in a table...
I've done this before, but I can't remember where for the life of me. This is off the cuff, but I think it will work. cfoutput query=stuff cfif mod(currentrow, 2)tr/cfif tdstuff/td cfif not mod(currentrow, 2)/tr/cfif /cfoutput cfif mod(stuff.recordcount, 2) tdnbsp;/td/tr /cfif -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Jeff [mailto:[EMAIL PROTECTED] : Sent: Friday, June 06, 2003 11:24 AM : To: CF-Talk : Subject: Using mod to display two across in a table... : : : I think I'm having a Friday brain fart. : : I want to output photos whose name is stored in a table and I want them to : display two across, like so: : : Photo1 | Photo2 : Photo3 | Photo4 : Photo5 | : : Etc... : : And for some reason, I'm totally blanking on how to accomplish it... : : I know it's CurrentRow and modulus, but doggone it...I'm having no luck... : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using mod to display two across in a table...
I use this for a 4 wide table So you could adapt it to fit 2... table width=100% border=0 cellspacing=9 cellpadding=0 background=images/main/box_bgn.gif CFIF qryImages.RecordCount CFSET iCount = 1 CFSET iListPos = 1 CFLOOP QUERY=qryImages STARTROW=#iStart# ENDROW=#Val(iStart + (iMax - 1))# CFOUTPUT CFIF iCount EQ 1 tr /CFIF CFIF qryImages.PhotoActive AND FileExists(ExpandPath(photos/thumbs/#qryImages.PhotoImage#)) td align=center valign=middle width=25%a href=index.cfm?Img=#qryImages.PhotoID#action=photoimg src=photos/thumbs/#qryImages.PhotoImage# width=140 height=105 alt=#qryImages.PhotoName# title=#qryImages.PhotoName# border=0/a/td CFELSEIF NOT qryImages.PhotoActive td align=center valign=middle width=25%img src=images/view/removed.gif height=105 width=140/td CFELSE td align=center valign=middle width=25%img src=images/null.gif height=1 width=1/td /CFIF CFIF iCount EQ 4 /tr CFSET iCount = 1 CFELSE CFSET iCount = iCount + 1 /CFIF /CFOUTPUT CFSET iListPos = iListPos + 1 /CFLOOP !--- Make sure the gallery table cells close --- CFIF iCount GT 1 CFLOOP CONDITION=#iCount# NEQ 6 CFOUTPUT tdimg src=images/null.gif height=1 width=1/td /CFOUTPUT CFSET iCount = iCount + 1 /CFLOOP /tr /CFIF CFELSE trtd height=105There are currently no photos in this album/td/tr /CFIF /table HTH Mikey -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Friday, June 6, 2003 16:42 To: CF-Talk Subject: Re: Using mod to display two across in a table... on 6/6/03 11:31 AM, Critz at [EMAIL PROTECTED] wrote: oi Jeff!! if query.currentrow mod 2 eq 0. ...then, what? This I can get. It's the closing of the table row that's throwing me off...in pseudocode, I see this: cfif query.currentrow mod 2 eq 0 cfoutput tr tdimg src=#image#/td tdimg src=#image#/td /tr /cfoutput /cfif But this obviously isn't right...arrrgh... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using mod to display two across in a table...
on 6/6/03 11:45 AM, Jerry Johnson at [EMAIL PROTECTED] wrote: In CF: cfif query.currentrow mod 2 neq 0 tr /cfif cfoutput tdimg src=#image#/td /cfoutput cfif query.currentrow mod 2 eq 0 /tr /cfif Does this make sense? Sure, but it doesn't work...lol...this is so ridiculous...I KNOW I've done this someplace else, but I can't find it...this is so easy to do too, and I'm just pissed that I can't remember how I did it...I've never been so frustrated in my life...arrgh... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using mod to display two across in a table...
on 6/6/03 11:45 AM, Jerry Johnson at [EMAIL PROTECTED] wrote: in pseudo code first if odd row, add TR draw TD if even row, add /TR In CF: cfif query.currentrow mod 2 neq 0 tr /cfif cfoutput tdimg src=#image#/td /cfoutput cfif query.currentrow mod 2 eq 0 /tr /cfif Does this make sense? Aha, I took out the cfoutput tags...d'oh! Works perfect now...I had the EXACT same thing but I had used mod() instead...but I had nested the cfoutput tags too...I wrapped it ALL in my cfoutput tag and it worked fine...thanks for the help. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: mod function?
Well if you leave yourself alone you wont go blind so quickly. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Michael Vinson [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 1:48 PM To: CF-Talk Subject: mod function? newbie needs to know if CF 5 has a mod() function before he goes blind ) tanks, mv ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mod function?
Yes it does. eg: cfif myquery.currentrow mod2 Do this.. cfelse Do this.. /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Kear Sent: Thursday, 27 September 2001 18:29 To: CF-Talk Subject: RE: mod function? Well if you leave yourself alone you wont go blind so quickly. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Michael Vinson [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 1:48 PM To: CF-Talk Subject: mod function? newbie needs to know if CF 5 has a mod() function before he goes blind ) tanks, mv ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
mod function?
newbie needs to know if CF 5 has a mod() function before he goes blind ) tanks, mv ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: mod function?
the mod() function is mod, but its treated more like an operator: cfset x = 5 mod 2 -Original Message- From: Michael Vinson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:48 PM To: CF-Talk Subject: mod function? newbie needs to know if CF 5 has a mod() function before he goes blind ) tanks, mv ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: mod function?
Thanks Duane Duane Boudreau wrote: the mod() function is mod, but its treated more like an operator: ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MOD 7
I have 2 blocks of numbers, the first block contains 9 digits the second 8 digits where the last digit in each block needs to be a MOD 7 check digit. I need to use these numbers in my Primary Key when adding new records, I can easily get the MAX number + 1 but no idea how to get the last MOD 7 check digit. I see some tags for MOD 10 but cant find any info on MOD 7. Any idea's? Example: Block 1 (x = MOD 7 check digit) 1546x 1542x Block 2 (x = MOD 7 check digit) 988x 988x Thanks,Adrian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
