Re: SOT: proximity searches
On 2/18/08, Bryan Stevenson [EMAIL PROTECTED] wrote: My last time involved postal code data with lat/long values. An equation was run to get all lat/longs inside the search radius and then you could grab all your records with postal cods that matched thse lat6 longs (or something along these lines). So what are folks using now? web services? some Google/MS API? other? postal code data. The fastest and most reliable way to do it. You can integrate it into your queries. Can't do that with a web service/API call. We're basically using a variation of this code in our application here at Duke: http://www.opensourcecf.com/1/2007/02/Determining-Zip-Code-Proximity.cfm There's also a link on that page to a $5 zip code lat/long database that we use. Rick -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SOT: Holy Grail? Hosting?
When you connect via RD, does everything appear to be functioning properly on the server? Can you connect to your site via localhost directly on the server? CF Service running? Can you ping the server from your workstation? Just trying to think of ways to help... Rick -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Monday, February 18, 2008 10:05 PM To: CF-Talk Subject: Re: SOT: Holy Grail? Hosting? I'm completely down, no RD, no sites coming up, no email since that's hosted from the server as well. That is a bummer... Seriously...10 pm and *still* not back up. That's after being down all day yesterday too. RD seems to working now but nothing else yet. At least now I've got a temporary copy of my site up to let people know I haven't just disappeared and have email forwarding in place as well. I don't really feel like moving all my sites to a new VPS host right now, so I'll probably stay put for the time being (I may feel differently if I'm still down this time tomorrow!) but I definitely can't see myself recommending them again for a LONG time. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfselect bind loading indicator?
Is there a way to indicate via a loading icon or something when a cfselect is updating its binding? When you make a selection on the first cfselect, if there's a slight delay in the second cfselect updating its options, it can be a bit off-putting. It would be nice if there was some indication that the second cfselect is updating. Thanks Brian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inconsistent Variable Names Across Data Sources
No one has any comments? -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Sunday, February 17, 2008 6:19 PM To: CF-Talk Subject: Inconsistent Variable Names Across Data Sources We have several data sources such as Active Directory, home-built databases and purchased databases. Each of these data sources may have different conventions for similar data elements. For example, Active Directory uses givenName and sn. Our main business system uses FIRST_NAME and LAST_NAME. While another database may use FirstName and LastName or firstName and lastName. Knowing that you can't change the schemas for many common data sources, do you make any attempt to use consistent variable names in your CFM pages? In other words, do you alias all of your data elements so that your CF code only uses one naming convention? m!ke. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: empty array elements
hi thanks for all your posts i will try it without the list qualify and how you suggested, thanks again. its good to know that i am on the right tracks though!! richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: empty array elements
Apologies, I completely mis-read your OP :o thats ok no problem i thought i was going crazy for a min :) thanks dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 CFFTP FTPS/Implicit SSL connection?
Hi All, Does anyone know if you can use cfftp in CF8 to make a FTPS/Implicit SSL connection? I can make cfftp SFTP/SSH connections just fine. My guess is Iâm connecting to a remote IIS FTP server thatâs using a SSL cert. Regards, Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inconsistent Variable Names Across Data Sources
Personally, I only ever use an alias if the original name is even a little obscure (i.e. sn for surname). I probably would not make an alias of 'surname' to 'lastname' (or the other way around) unless it was going to save confusion rather than add to it. Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inconsistent Variable Names Across Data Sources
What are you looking to accomplish? Are each of these databases running separate systems? Are you looking for one global interface to manage the exact same data in each database? I would say, if these systems are separate and distinct you should just leave them as is. If they are talking to each other and updates to one are done to updates to all you should probably create a common object to handle the core data and an adapter that knows how to talk to each database. -jeff We have several data sources such as Active Directory, home-built databases and purchased databases. Each of these data sources may have different conventions for similar data elements. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299333 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inconsistent Variable Names Across Data Sources
On Tuesday 19 Feb 2008, Jeff Price wrote: What are you looking to accomplish? Are each of these databases running separate systems? Are you looking for one global interface to manage the exact same data in each database? Maybe either a single master DB all the others query, or (if not a single site) a local copy that syncs to the master on a scheduled basis would work too. -- Tom Chiverton Helping to professionally synthesize second-generation content on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299334 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Inconsistent Variable Names Across Data Sources
What is there to say really? Yes, consistency makes things easier in a situation like this. But, things are much easier to follow, usually, when the applications variable names match DB column names. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 9:37 AM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources No one has any comments? -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Sunday, February 17, 2008 6:19 PM To: CF-Talk Subject: Inconsistent Variable Names Across Data Sources We have several data sources such as Active Directory, home-built databases and purchased databases. Each of these data sources may have different conventions for similar data elements. For example, Active Directory uses givenName and sn. Our main business system uses FIRST_NAME and LAST_NAME. While another database may use FirstName and LastName or firstName and lastName. Knowing that you can't change the schemas for many common data sources, do you make any attempt to use consistent variable names in your CFM pages? In other words, do you alias all of your data elements so that your CF code only uses one naming convention? m!ke. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inconsistent Variable Names Across Data Sources
Sometimes, I have to join across all three datasources to get the data I need. For example, I need Active Directory, to get a list of current domain accounts. This is then joined to data exports from our business system to get HR information. Finally, this is joined to our ID Card database. Each of these datasources has a field for a person's last name. Active Directory: sn Bus Sys Exports: LAST_NAME ID Card DB: LastName Therefore, I have three different options for specifying a column name for a person's last name. I have to choose one. In this example, I would probably choose the sn from Active Directory since it would be the controlling data entity. I would probably alias sn to lastName in my CF code, in this example. However, if I only need to query Active Directory, and no other data sources, would I still alias the column or not? In other words, regardless of consistency, if my query doesn't include lastName, yet most of the CF code uses lastName, should I not always alias the column? That is my question. However, no matter what I choose for my CF variable, I will not match the column names from the other two data sources. m!ke -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 10:20 AM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources What is there to say really? Yes, consistency makes things easier in a situation like this. But, things are much easier to follow, usually, when the applications variable names match DB column names. ...:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: proximity searches
Thanks Rick, I'll have a lookguess sometimes the best way is still the old way eh ;-) Cheers - 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 Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Tue, 2008-02-19 at 07:55 -0500, Rick Root wrote: On 2/18/08, Bryan Stevenson [EMAIL PROTECTED] wrote: My last time involved postal code data with lat/long values. An equation was run to get all lat/longs inside the search radius and then you could grab all your records with postal cods that matched thse lat6 longs (or something along these lines). So what are folks using now? web services? some Google/MS API? other? postal code data. The fastest and most reliable way to do it. You can integrate it into your queries. Can't do that with a web service/API call. We're basically using a variation of this code in our application here at Duke: http://www.opensourcecf.com/1/2007/02/Determining-Zip-Code-Proximity.cfm There's also a link on that page to a $5 zip code lat/long database that we use. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Bomber, headerStyle attribute of CFWINDOW
This attribute works with IE7 (probably IE6 too) but won't work with FF2. Could anyone reproduce the bug? Thanks. P.S. Though one can first detect browser then decide to use this attibute or not, it slows down the process... workaround is workaround... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: proximity searches
I suppose someone could provide this as a web service, but in the end ** somebody** is going to be making the calculations to determine latitude/longitude proximity. Chris On Feb 19, 2008 10:03 AM, Bryan Stevenson [EMAIL PROTECTED] wrote: Thanks Rick, I'll have a lookguess sometimes the best way is still the old way eh ;-) Cheers - 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 Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Tue, 2008-02-19 at 07:55 -0500, Rick Root wrote: On 2/18/08, Bryan Stevenson [EMAIL PROTECTED] wrote: My last time involved postal code data with lat/long values. An equation was run to get all lat/longs inside the search radius and then you could grab all your records with postal cods that matched thse lat6 longs (or something along these lines). So what are folks using now? web services? some Google/MS API? other? postal code data. The fastest and most reliable way to do it. You can integrate it into your queries. Can't do that with a web service/API call. We're basically using a variation of this code in our application here at Duke: http://www.opensourcecf.com/1/2007/02/Determining-Zip-Code-Proximity.cfm There's also a link on that page to a $5 zip code lat/long database that we use. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Inconsistent Variable Names Across Data Sources
Your questions answer is basically a matter of opinion. I, personally, would only alias them when I cross join them. If I am only querying one of them, I would probably just use the column name as the variable name. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 12:26 PM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources Sometimes, I have to join across all three datasources to get the data I need. For example, I need Active Directory, to get a list of current domain accounts. This is then joined to data exports from our business system to get HR information. Finally, this is joined to our ID Card database. Each of these datasources has a field for a person's last name. Active Directory: sn Bus Sys Exports: LAST_NAME ID Card DB: LastName Therefore, I have three different options for specifying a column name for a person's last name. I have to choose one. In this example, I would probably choose the sn from Active Directory since it would be the controlling data entity. I would probably alias sn to lastName in my CF code, in this example. However, if I only need to query Active Directory, and no other data sources, would I still alias the column or not? In other words, regardless of consistency, if my query doesn't include lastName, yet most of the CF code uses lastName, should I not always alias the column? That is my question. However, no matter what I choose for my CF variable, I will not match the column names from the other two data sources. m!ke -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 10:20 AM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources What is there to say really? Yes, consistency makes things easier in a situation like this. But, things are much easier to follow, usually, when the applications variable names match DB column names. :.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299338 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Restart Apply License Key to ColdFusion?
I forget. Does one need to do a restart of ColdFusion after applying a license key to a trial installation? I have put in my key, and Submit Changes and the pages says my changes have succeeded. But the Information page still says the CF version is ColdFusion Enterprise (Trial) and there is no Serial Number in the System Information section. I have correctly updated CF with my license or not? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inconsistent Variable Names Across Data Sources
If you are using centralized queries (CFCs or a 'framework' type system), you can utilize the 'as' operator in SQL on your selects. This would help with future programmers coming in and not getting confused. Eg. Select givenname as first_name, sn as last_name Where Just a thought. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 6:37 AM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources No one has any comments? -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Sunday, February 17, 2008 6:19 PM To: CF-Talk Subject: Inconsistent Variable Names Across Data Sources We have several data sources such as Active Directory, home-built databases and purchased databases. Each of these data sources may have different conventions for similar data elements. For example, Active Directory uses givenName and sn. Our main business system uses FIRST_NAME and LAST_NAME. While another database may use FirstName and LastName or firstName and lastName. Knowing that you can't change the schemas for many common data sources, do you make any attempt to use consistent variable names in your CFM pages? In other words, do you alias all of your data elements so that your CF code only uses one naming convention? m!ke. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299340 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 ssl v2 or v3?
Hi All, I'm trying to make a XML-RPC call using CFHTTP that only allows SSLV3 connections. The webservice provider told me that there is problem with the way my certificate is being processed. After running Ethereal, I noticed that during the 'Client hello', CFHTTP using the SSLv2 protocol, and then drops to the TLS protocol for the key exchange and handshake. Is there a way to force Coldfusion 8 to use SSLv3? Thanks, Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299341 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
crystal reports 11 and coldfusion 8
I have an existing reporting system in Crystal Reports 11. We are converting from vb.net to coldfusion 8. I want to be able to call these reports through coldfusion. Does anyone know if these are compatible? And if they are - what is the trick to making it work? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using __type__ to return objects to Flex
I am giving this a try on my current app. However, when the data is returned to Flex, it is not of the type that I specified. All fields are camelCased correctly (I added the properties argument to get around the uppercasing issue), the type is set correctly, and all data is returned, but it is not of type AddressBook. If I do cfreturn createObject( component, AddressBook ).init( arguments.id ) / the data is returned as AddressBook. Any ideas? (Code is below). cffunction name=getAllProperties output=false access=remote cfargument name=queryData type=query required=true / cfargument name=properties type=string required=false default=addressBookId,ownerId,connectionSourceId,addressTypeId,address1,address2,city,state,zip,countryId,longitude,latitude,radianLat,radianLong,lastUpdate,lastUpdateBy,lastUpdateByConnectionSourceId / cfset var INST = structNew() / cfset INST.obj = structNew() / cfset INST.ret = arrayNew( 1 ) / !--- default object to addressbook --- cfset INST.obj['__type__'] = AddressBook / !--- loop over query --- cfloop query=arguments.queryData !--- loop over columns and assign to temporary object --- cfloop list=#arguments.properties# index=INST.property cfset INST.obj[INST.property] = arguments.queryData[INST.property][currentRow] / /cfloop cfscript ArrayAppend( INST.ret, duplicate( INST.obj ) ); /cfscript /cfloop cfreturn INST.ret / /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299343 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Inconsistent Variable Names Across Data Sources
Actually... I don't really see a reason to alias in the cross joins either. If they are all the same value, wouldn't you just select the one you wanted to use? ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 1:45 PM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources Your questions answer is basically a matter of opinion. I, personally, would only alias them when I cross join them. If I am only querying one of them, I would probably just use the column name as the variable name. ...:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 12:26 PM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources Sometimes, I have to join across all three datasources to get the data I need. For example, I need Active Directory, to get a list of current domain accounts. This is then joined to data exports from our business system to get HR information. Finally, this is joined to our ID Card database. Each of these datasources has a field for a person's last name. Active Directory: sn Bus Sys Exports: LAST_NAME ID Card DB: LastName Therefore, I have three different options for specifying a column name for a person's last name. I have to choose one. In this example, I would probably choose the sn from Active Directory since it would be the controlling data entity. I would probably alias sn to lastName in my CF code, in this example. However, if I only need to query Active Directory, and no other data sources, would I still alias the column or not? In other words, regardless of consistency, if my query doesn't include lastName, yet most of the CF code uses lastName, should I not always alias the column? That is my question. However, no matter what I choose for my CF variable, I will not match the column names from the other two data sources. m!ke -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 10:20 AM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources What is there to say really? Yes, consistency makes things easier in a situation like this. But, things are much easier to follow, usually, when the applications variable names match DB column names. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 ssl v2 or v3?
I'm not sure if this answers your question but we disabled ssl v2 in Windows registry. Have you done that? There is a (not very good) how-to document on microsoft's site and some info on various blogs, etc. N -Original Message- From: Billy Jamme [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 1:52 PM To: CF-Talk Subject: CF8 ssl v2 or v3? Hi All, I'm trying to make a XML-RPC call using CFHTTP that only allows SSLV3 connections. The webservice provider told me that there is problem with the way my certificate is being processed. After running Ethereal, I noticed that during the 'Client hello', CFHTTP using the SSLv2 protocol, and then drops to the TLS protocol for the key exchange and handshake. Is there a way to force Coldfusion 8 to use SSLv3? Thanks, Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299345 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: Holy Grail? Hosting?
When you connect via RD, does everything appear to be functioning properly on the server? Can you connect to your site via localhost directly on the server? CF Service running? Can you ping the server from your workstation? My server is set up to use Plesk control panel so all the sites go through that. Yeah, I know it's kind of sucky, but I'm hosting a bunch of sites for family members, some of which also use Frontpage Extensions, so was an easy way to go, and I generally am able to work around some of its annoying limitations. But in this case, it seems that the Plesk installation got fried in the whole update process as well and I still can't get any response from my host about what is going on, if he is working on it, how long that will be, etc. So I'm getting a backup of my site up in another location as soon as I can. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
returned component calling function question
Ok, I should know this, but for some reason, I can't make my brain give me the answer. I want to do something like this: objCache.secretRecords.getMyRecord(1234).formatAsTable(). How would I do something like that? In this example, objCache is a shared-memory library for instantiated objects. The secretRecords is an object; the getMyRecord is a function in it. But, how do I pass a returned query (for example) into a function formatAsTable? Am I daft? TIA This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using __type__ to return objects to Flex
How are you calling it from Flex? __type__ only works with FDS, I believe, not with remote objects. cheers, barneyb On Feb 19, 2008 10:54 AM, Gareth Arch [EMAIL PROTECTED] wrote: I am giving this a try on my current app. However, when the data is returned to Flex, it is not of the type that I specified. All fields are camelCased correctly (I added the properties argument to get around the uppercasing issue), the type is set correctly, and all data is returned, but it is not of type AddressBook. If I do cfreturn createObject( component, AddressBook ).init( arguments.id ) / the data is returned as AddressBook. Any ideas? (Code is below). cffunction name=getAllProperties output=false access=remote cfargument name=queryData type=query required=true / cfargument name=properties type=string required=false default=addressBookId,ownerId,connectionSourceId,addressTypeId,address1,address2,city,state,zip,countryId,longitude,latitude,radianLat,radianLong,lastUpdate,lastUpdateBy,lastUpdateByConnectionSourceId / cfset var INST = structNew() / cfset INST.obj = structNew() / cfset INST.ret = arrayNew( 1 ) / !--- default object to addressbook --- cfset INST.obj['__type__'] = AddressBook / !--- loop over query --- cfloop query=arguments.queryData !--- loop over columns and assign to temporary object --- cfloop list=#arguments.properties# index=INST.property cfset INST.obj[INST.property] = arguments.queryData[INST.property][currentRow] / /cfloop cfscript ArrayAppend( INST.ret, duplicate( INST.obj ) ); /cfscript /cfloop cfreturn INST.ret / /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299348 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using __type__ to return objects to Flex
Argh! For some reason I skipped completely over that part. Other than having to use createobject, do you know of anything that will just return the properties rather than the whole shebang (in CFMX7)? I've returned the data as a query before, but that then requires manipulation on the ActionScript side of things, so if there was a way to tell it this is an AddressBook from CF, that would be extremely useful (without going through LiveCycle). Thanks for the help. How are you calling it from Flex? __type__ only works with FDS, I believe, not with remote objects. cheers, barneyb On Feb 19, 2008 10:54 AM, Gareth Arch [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: returned component calling function question
You're not daft, you just need to make sure you pass the object back from getMyRecord(). cfset return THIS or the the object you're working on Adrian http://www.adrianlynch.co.uk/ -Original Message- From: Leitch, Oblio Sent: 19 February 2008 19:47 To: CF-Talk Subject: returned component calling function question Ok, I should know this, but for some reason, I can't make my brain give me the answer. I want to do something like this: objCache.secretRecords.getMyRecord(1234).formatAsTable(). How would I do something like that? In this example, objCache is a shared-memory library for instantiated objects. The secretRecords is an object; the getMyRecord is a function in it. But, how do I pass a returned query (for example) into a function formatAsTable? Am I daft? TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Inconsistent Variable Names Across Data Sources
Yes, but all the last name values should match throughout our databases, therefore, it doesn't really matter which exact column I choose, as long as I choose one of them. Someone else may have touched on the best answer. Many programmers may not know what sn is, but they should all know what lastName is. So, not only is consistency a good thing, so is clarity. ;-) I'm probably better off aliasing the column names to help the other guys. Thanks for everyone's input. M!ke -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 1:10 PM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources Actually... I don't really see a reason to alias in the cross joins either. If they are all the same value, wouldn't you just select the one you wanted to use? ...:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using __type__ to return objects to Flex
No, not that I've found. But it's simple to inflate the generic objects into typed objects in AS. Just add a static createFromProperties(o:Object):AddressBook method that will copy properties from the passed object into a new instance of the strongly typed object, and then when you get your ArrayCollection in Flex, loop over the elements and inflate each one. var ac:ArrayCollection = event.result; for (var i:int = 0; i ac.length; i++) { ac[i] = AddressBook.createFromProperties(ac[i]); } It's not really elegant, but it's simple, and mandatory with how slow CF is at creating CFC instances. cheers, barneyb On Feb 19, 2008 12:05 PM, Gareth Arch [EMAIL PROTECTED] wrote: Argh! For some reason I skipped completely over that part. Other than having to use createobject, do you know of anything that will just return the properties rather than the whole shebang (in CFMX7)? I've returned the data as a query before, but that then requires manipulation on the ActionScript side of things, so if there was a way to tell it this is an AddressBook from CF, that would be extremely useful (without going through LiveCycle). Thanks for the help. How are you calling it from Flex? __type__ only works with FDS, I believe, not with remote objects. cheers, barneyb On Feb 19, 2008 10:54 AM, Gareth Arch [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299352 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using __type__ to return objects to Flex
This actually works fine without LCDS or FDS. It requires that you put the appropriate fully qualified RemoteClass on your AS vlaue object, but if you do that you get automatic conversion from typed CF Struct to AS. The only thing I see that is odd about your posted code is that you are returning an array On Feb 19, 2008 1:04 PM, Barney Boisvert [EMAIL PROTECTED] wrote: No, not that I've found. But it's simple to inflate the generic objects into typed objects in AS. Just add a static createFromProperties(o:Object):AddressBook method that will copy properties from the passed object into a new instance of the strongly typed object, and then when you get your ArrayCollection in Flex, loop over the elements and inflate each one. var ac:ArrayCollection = event.result; for (var i:int = 0; i ac.length; i++) { ac[i] = AddressBook.createFromProperties(ac[i]); } It's not really elegant, but it's simple, and mandatory with how slow CF is at creating CFC instances. cheers, barneyb On Feb 19, 2008 12:05 PM, Gareth Arch [EMAIL PROTECTED] wrote: Argh! For some reason I skipped completely over that part. Other than having to use createobject, do you know of anything that will just return the properties rather than the whole shebang (in CFMX7)? I've returned the data as a query before, but that then requires manipulation on the ActionScript side of things, so if there was a way to tell it this is an AddressBook from CF, that would be extremely useful (without going through LiveCycle). Thanks for the help. How are you calling it from Flex? __type__ only works with FDS, I believe, not with remote objects. cheers, barneyb On Feb 19, 2008 10:54 AM, Gareth Arch [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using __type__ to return objects to Flex
sorry pressed send too soon. To finish that sentence : The only thing I see that is odd about your posted code is that you are returning an array, so on the flex side you need to make sure that you are compiling an instance of your VO into the application or you will get a generic object... On Feb 19, 2008 1:13 PM, Jon Messer [EMAIL PROTECTED] wrote: This actually works fine without LCDS or FDS. It requires that you put the appropriate fully qualified RemoteClass on your AS vlaue object, but if you do that you get automatic conversion from typed CF Struct to AS. The only thing I see that is odd about your posted code is that you are returning an array On Feb 19, 2008 1:04 PM, Barney Boisvert [EMAIL PROTECTED] wrote: No, not that I've found. But it's simple to inflate the generic objects into typed objects in AS. Just add a static createFromProperties(o:Object):AddressBook method that will copy properties from the passed object into a new instance of the strongly typed object, and then when you get your ArrayCollection in Flex, loop over the elements and inflate each one. var ac:ArrayCollection = event.result; for (var i:int = 0; i ac.length; i++) { ac[i] = AddressBook.createFromProperties(ac[i]); } It's not really elegant, but it's simple, and mandatory with how slow CF is at creating CFC instances. cheers, barneyb On Feb 19, 2008 12:05 PM, Gareth Arch [EMAIL PROTECTED] wrote: Argh! For some reason I skipped completely over that part. Other than having to use createobject, do you know of anything that will just return the properties rather than the whole shebang (in CFMX7)? I've returned the data as a query before, but that then requires manipulation on the ActionScript side of things, so if there was a way to tell it this is an AddressBook from CF, that would be extremely useful (without going through LiveCycle). Thanks for the help. How are you calling it from Flex? __type__ only works with FDS, I believe, not with remote objects. cheers, barneyb On Feb 19, 2008 10:54 AM, Gareth Arch [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: crystal reports 11 and coldfusion 8
http://asreports.riaforge.org/ And yes they are compatible. On 2/20/08, Kim Hoopingarner [EMAIL PROTECTED] wrote: I have an existing reporting system in Crystal Reports 11. We are converting from vb.net to coldfusion 8. I want to be able to call these reports through coldfusion. Does anyone know if these are compatible? And if they are - what is the trick to making it work? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Holy Grail? Hosting?
I am back up. The remote desktop was fine, but my sites were getting a 'Service Unavailable'. The following fixed it http://forum.swsoft.com/showthread.php?t=17581 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SEO / website organization
I have a ticket site. http://www.GotTickets.com From a SEO perspective which is better: #1. Is it better to use sub directories /Sports /Sports/basketball /sports/basketball/Lakers or subdomains Lakers.gottickets.com Kings.gottickets.com #2. In a directory solution is it better to have /sports/basketball/lakerstickets.cfm or /sports/basketball/lakers/lakerstickets.cfm #3. File names: lakerstickets.cfm or Lakers_Tickets.cfm Or does it really matter? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MySQL and Dates
In MySQL 5, I'm storing a date in a date field. It stores it as 2008-19-2. But my client wants to let users filter records using this format: 02/19/2008 What's the best way to convert the format my form uses to something mySQL can read. I'll be looking for records between two dates, etc. Thanks, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SEO / website organization
From a SEO perspective which is better: ... I don't think it'll make any difference what you do in those three cases. In general, what works well for SEO is what works well for users. SEO-friendly URLs are also more user-friendly. Since search engines don't release their algorithms, and they're constantly changing said algorithms, the best you can generally do is to provide good, well-organized, user-friendly content. The SEO specialists, for the most part, are a lot like shamans divining the future from entrails. Alternatively, you can spend a lot of time examining how your competitors' pages work, and then do what they're doing. Of course, you have to revisit this quite frequently, as what works well changes. You might find this useful, although it's a bit dated: http://figleaf.mmalliance.acrobat.com/seo/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL and Dates
FWIW let CF do the formatting for you, store it the way the DB handles it. On Feb 19, 2008 5:29 PM, Will Tomlinson [EMAIL PROTECTED] wrote: In MySQL 5, I'm storing a date in a date field. It stores it as 2008-19-2. But my client wants to let users filter records using this format: 02/19/2008 What's the best way to convert the format my form uses to something mySQL can read. I'll be looking for records between two dates, etc. Thanks, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299362 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SEO / website organization
Generally speaking, it's impossible to say. For one, search engines don't really reveal their secrets. Also, all the search engines do it differently. Now, with that said, I can only recommend that you go with your gut. Mine says this is best: lakers.gottickets.com or lakers.basketball.sports.gottickets.com (where basketball.sports.gottickets.com would also resolve). for folders: /sports/basketball/lakers/ or /sports/basketball/lakers/tickets/ for file names, leave the file name off. make it look like directory structures (makes it feel more permanent). The easiest way to fake this out is a URL rewriting web server plugin. This way, you can map these URI directories to a single (or handful, etc) cfm file in the background and gives you the easiest customer discoverability, where they can feel like they could type in /sports/baseball/ and still be successful. Again, this is not more right (nor wrong, probably) than any one else's suggestions. -- nathan strutz http://www.dopefly.com/ On Feb 19, 2008 2:40 PM, Jaysen Pollard [EMAIL PROTECTED] wrote: I have a ticket site. http://www.GotTickets.com From a SEO perspective which is better: #1. Is it better to use sub directories /Sports /Sports/basketball /sports/basketball/Lakers or subdomains Lakers.gottickets.com Kings.gottickets.com #2. In a directory solution is it better to have /sports/basketball/lakerstickets.cfm or /sports/basketball/lakers/lakerstickets.cfm #3. File names: lakerstickets.cfm or Lakers_Tickets.cfm Or does it really matter? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Restart Apply License Key to ColdFusion?
I forget. Does one need to do a restart of ColdFusion after applying a license key to a trial installation? I have put in my key, and Submit Changes and the pages says my changes have succeeded. But the Information page still says the CF version is ColdFusion Enterprise (Trial) and there is no Serial Number in the System Information section. I have correctly updated CF with my license or not? I think that you should just go ahead and restart. I don't think it's always required, but I can easily imagine lots of places where this could fail along the way. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: Holy Grail? Hosting?
I am back up. The remote desktop was fine, but my sites were getting a 'Service Unavailable'. The following fixed it http://forum.swsoft. com/showthread.php?t=17581 Which one? There are 3 different ones mentioned in that thread. Really though, a simple fix probably isn't going to do it, the Plesk on my server just really seems hosed. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to sort columns and Group them at the same time
Hi: The main problem here is: I have a table of orders. Several users may order one Pet(this a part of a pet shop) but one will get it. I use Group in Cfoutput to place all the users who ordered one pet under each pet. It works fine but I had to put the columns I want group in ORDER BY of the sql. I need to sort these users using date to prioritize their orders (the one who ordered first has more chance surely). But when I put date in ORDER BY it seems that sql ignores it all! Please help me find a way to sort the outcome using date. Thanks Benign this is the code: cfquery name=rsPurch_List datasource=#Request.DSN# SELECT Tbl_DogPurchWait.DogPurchWaitID ,Tbl_DogPurchWait.UserID ,Tbl_DogPurchWait.DogID ,Tbl_DogPurchWait.DogPurchWaitDate ,Tbl_DogPurchWait.DogPurchWaitActive ,Tbl_Users.UserName ,Tbl_Users.FistName ,Tbl_Users.LastName ,Tbl_Users.TelephoneNumber ,Tbl_Users.EmailAddress ,Tbl_Dogs.DogNumber ,Tbl_Dogs.DogName ,Tbl_Dogs.DogImageS1 ,Tbl_Users.UserID ,Tbl_Dogs.DogID ,Tbl_Dogs.DogPrice ,Tbl_Users.Address FROM Tbl_DogPurchWait, Tbl_Users, Tbl_Dogs WHERE Tbl_Dogs.DogID = Tbl_DogPurchWait.DogID AND Tbl_DogPurchWait.UserID = Tbl_Users.UserID AND Tbl_DogPurchWait.DogPurchWaitActive = YES ORDER BY Tbl_Dogs.DogID, Tbl_Users.UserID, Tbl_DogPurchWait.DogPurchWaitDate Desc/cfquery cfoutput query=rsPurch_List group=Tbl_Dogs.DogID table width=50% border=0 align=right cellpadding=5 cellspacing=0 dir=rtl tr tdimg src=../#rsPurch_List.DogImageS1# //td td#rsPurch_List.DogName#/td td#rsPurch_List.DogNumber#/td td#rsPurch_List.DogPrice#/td /tr /table cfoutput group=Tbl_Users.UserID table width=100% border=1 align=right cellpadding=5 cellspacing=0 bordercolor=##00 dir=rtl tr td align=center li a href=/dampezeshki_final/dog/Admin/AdminPurchConf_Insertion.cfm?DogPurchWaitID=#rsPurch_List.DogPurchWaitID##rsPurch_List.UserName#/a /li/td td #rsPurch_List.FistName#/td td#rsPurch_List.LastName#/td td#rsPurch_List.TelephoneNumber#/td td#rsPurch_List.EmailAddress#/td td#rsPurch_List.Address#/td td#rsPurch_List.DogPurchWaitDate#/td /tr /table /cfoutput /h1 /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL and Dates
What's the best way to convert the format my form uses to something mySQL can read. I'll be looking for records between two dates, etc. cfset sqldate = parsedatetime(form.formdate) / Then use sqldate in your sql query. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: CSS Question
I understand how to make fields invisible, but is there a way to have a field display on the screen, but become invisible when printed? For example, can I set one stylesheet for Display and another for printing? Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSS Question
media=print in your link tag where you import the stylesheet will accomplish this. media=screen will be screen specific and media=all is for both. A lack of this attribute will default to all. There's more too it than that. Here's a good resource for you: http://www.w3.org/TR/REC-CSS2/media.html _ Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Andy [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:34 PM To: CF-Talk Subject: OT: CSS Question I understand how to make fields invisible, but is there a way to have a field display on the screen, but become invisible when printed? For example, can I set one stylesheet for Display and another for printing? Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to sort columns and Group them at the same time
ORDER BY Tbl_Dogs.DogID, Tbl_Users.UserID, Tbl_DogPurchWait.DogPurchWaitDate Desc/cfquery It looks like Tbl_Users.UserID might be unique in the ORDER BY line, thus rendering any sort order after that useless. -Original Message- From: Ali [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 6:16 PM To: CF-Talk Subject: How to sort columns and Group them at the same time Hi: The main problem here is: I have a table of orders. Several users may order one Pet(this a part of a pet shop) but one will get it. I use Group in Cfoutput to place all the users who ordered one pet under each pet. It works fine but I had to put the columns I want group in ORDER BY of the sql. I need to sort these users using date to prioritize their orders (the one who ordered first has more chance surely). But when I put date in ORDER BY it seems that sql ignores it all! Please help me find a way to sort the outcome using date. Thanks Benign this is the code: cfquery name=rsPurch_List datasource=#Request.DSN# SELECT Tbl_DogPurchWait.DogPurchWaitID ,Tbl_DogPurchWait.UserID ,Tbl_DogPurchWait.DogID ,Tbl_DogPurchWait.DogPurchWaitDate ,Tbl_DogPurchWait.DogPurchWaitActive ,Tbl_Users.UserName ,Tbl_Users.FistName ,Tbl_Users.LastName ,Tbl_Users.TelephoneNumber ,Tbl_Users.EmailAddress ,Tbl_Dogs.DogNumber ,Tbl_Dogs.DogName ,Tbl_Dogs.DogImageS1 ,Tbl_Users.UserID ,Tbl_Dogs.DogID ,Tbl_Dogs.DogPrice ,Tbl_Users.Address FROM Tbl_DogPurchWait, Tbl_Users, Tbl_Dogs WHERE Tbl_Dogs.DogID = Tbl_DogPurchWait.DogID AND Tbl_DogPurchWait.UserID = Tbl_Users.UserID AND Tbl_DogPurchWait.DogPurchWaitActive = YES ORDER BY Tbl_Dogs.DogID, Tbl_Users.UserID, Tbl_DogPurchWait.DogPurchWaitDate Desc/cfquery cfoutput query=rsPurch_List group=Tbl_Dogs.DogID table width=50% border=0 align=right cellpadding=5 cellspacing=0 dir=rtl tr tdimg src=../#rsPurch_List.DogImageS1# //td td#rsPurch_List.DogName#/td td#rsPurch_List.DogNumber#/td td#rsPurch_List.DogPrice#/td /tr /table cfoutput group=Tbl_Users.UserID table width=100% border=1 align=right cellpadding=5 cellspacing=0 bordercolor=##00 dir=rtl tr td align=center li a href=/dampezeshki_final/dog/Admin/AdminPurchConf_Insertion.cfm?DogPurchWait ID=#rsPurch_List.DogPurchWaitID##rsPurch_List.UserName#/a /li/td td #rsPurch_List.FistName#/td td#rsPurch_List.LastName#/td td#rsPurch_List.TelephoneNumber#/td td#rsPurch_List.EmailAddress#/td td#rsPurch_List.Address#/td td#rsPurch_List.DogPurchWaitDate#/td /tr /table /cfoutput /h1 /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSS Question
Very cool. Thanks! -Original Message- From: Jake Churchill [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:39 PM To: CF-Talk Subject: RE: CSS Question media=print in your link tag where you import the stylesheet will accomplish this. media=screen will be screen specific and media=all is for both. A lack of this attribute will default to all. There's more too it than that. Here's a good resource for you: http://www.w3.org/TR/REC-CSS2/media.html _ Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Andy [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:34 PM To: CF-Talk Subject: OT: CSS Question I understand how to make fields invisible, but is there a way to have a field display on the screen, but become invisible when printed? For example, can I set one stylesheet for Display and another for printing? Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
The GetTimeZoneInfo() function
Personally I didn't find this function of any use, it tells offset from GMT, however, it does not indicate whether it's to the east (+) or to west (-). Am I missing something here (yes I've checked the livedocs about it). Thks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The GetTimeZoneInfo() function
Don L wrote: Personally I didn't find this function of any use, it tells offset from GMT, however, it does not indicate whether it's to the east (+) or to west (-). Am I missing something here (yes I've checked the livedocs about it). yes you're missing somethings, from the cf8 docs: Returns Structure that contains these elements and keys: * utcTotalOffset: offset of local time, in seconds, from UTC o A plus sign indicates a time zone west of UTC (such as a zone in North America) o A minus sign indicates a time zone east of UTC (such as a zone in Germany) * utcHourOffset: offset, in hours of local time, from UTC * utcMinuteOffset: offset, in minutes, beyond the hours offset. For North America, this is 0. For countries that are not exactly on the hour offset, the number is between 0 and 60. For example, standard time in Adelaide, Australia is offset 9 hours and 30 minutes from UTC. * isDSTOn: True, if Daylight Savings Time (DST) is on in the host; False, otherwise this is the *server* timezone, so if your server's in a tz west of UTC it will always be positive. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: crystal reports 11 and coldfusion 8
Thank you for your information. I am looking to understand what I need to install from the Crystal Reports 11 CD (and I assume this is done on the web server). Then can I get an example of the cfreport code that works. Here's my cfreport and all it is doing is returning back to the form. The Crystal Reports is not coming up. cfreport report=EmployeList.rpt datasource=employees username=xyz password=xyz ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The GetTimeZoneInfo() function
Indeed, I missed it, thanks. But, I do know my server's timezone, what I'd like to know is user/UA 's timezone, currently I'm using sql to do that... yes you're missing somethings, from the cf8 docs: Returns Structure that contains these elements and keys: * utcTotalOffset: offset of local time, in seconds, from UTC o A plus sign indicates a time zone west of UTC (such as a zone in North America) o A minus sign indicates a time zone east of UTC (such as a zone in Germany) * utcHourOffset: offset, in hours of local time, from UTC * utcMinuteOffset: offset, in minutes, beyond the hours offset. For North America, this is 0. For countries that are not exactly on the hour offset, the number is between 0 and 60. For example, standard time in Adelaide, Australia is offset 9 hours and 30 minutes from UTC. * isDSTOn: True, if Daylight Savings Time (DST) is on in the host; False, otherwise this is the *server* timezone, so if your server's in a tz west of UTC it will always be positive. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: crystal reports 11 and coldfusion 8
http://asreports.riaforge.org/ And yes they are compatible. On 2/20/08, Kim Hoopingarner [EMAIL PROTECTED] wrote: I have an existing reporting system in Crystal Reports 11. We are converting from vb.net to coldfusion 8. I want to be able to call these reports through coldfusion. Does anyone know if these are compatible? And if they are - what is the trick to making it work? Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Inconsistent Variable Names Across Data Sources
Yes, but all the last name values should match throughout our databases, therefore, it doesn't really matter which exact column I choose, as long as I choose one of them. My point exactly... so don't alias SN to lastName in a cross joined query... just select lastName to begin with. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 4:01 PM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources Yes, but all the last name values should match throughout our databases, therefore, it doesn't really matter which exact column I choose, as long as I choose one of them. Someone else may have touched on the best answer. Many programmers may not know what sn is, but they should all know what lastName is. So, not only is consistency a good thing, so is clarity. ;-) I'm probably better off aliasing the column names to help the other guys. Thanks for everyone's input. M!ke -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 1:10 PM To: CF-Talk Subject: RE: Inconsistent Variable Names Across Data Sources Actually... I don't really see a reason to alias in the cross joins either. If they are all the same value, wouldn't you just select the one you wanted to use? :.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The GetTimeZoneInfo() function
Don L wrote: Indeed, I missed it, thanks. But, I do know my server's timezone, what I'd like to know is user/UA 's timezone, currently I'm using sql to do that... other than asking them, you really can't. i think js only returns the offset (if your app is global this is kind of meaningless as there are plenty of tz w/the same offset but different DST, etc. rules). if you're using flash/flex raw, it's date strings can include the tz which you could parse out. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL and Dates
What's the best way to convert the format my form uses to something mySQL cfset sqldate = parsedatetime(form.formdate) / Then use sqldate in your sql query. -- Josh Perfect! That's exactly what I needed. Thanks Josh! Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The GetTimeZoneInfo() function
William Seiter wrote: I believe you can use JS to pull the local computer's time and then use AJAX you *cannot* get the client's tz via js. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The GetTimeZoneInfo() function
Thank you both about the JS option, I looked into that as well... but I'll stick to my sql solution for it (it's working fine and seem efficient). The app is not pre-released yet but it's consumer-oriented, not exactly intended for int'l but more for N. America... I believe you can use JS to pull the local computer's time and then use AJAX to send that information back to the server, however if this is for a security system or an application's vital information, a user can just change their local date/time to overcome the system. If you tell us what the end use will be for the information we may be able to guide you with more useable information. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: The GetTimeZoneInfo() function
I believe you can use JS to pull the local computer's time and then use AJAX to send that information back to the server, however if this is for a security system or an application's vital information, a user can just change their local date/time to overcome the system. If you tell us what the end use will be for the information we may be able to guide you with more useable information. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:07 PM To: CF-Talk Subject: Re: The GetTimeZoneInfo() function Don L wrote: Indeed, I missed it, thanks. But, I do know my server's timezone, what I'd like to know is user/UA 's timezone, currently I'm using sql to do that... other than asking them, you really can't. i think js only returns the offset (if your app is global this is kind of meaningless as there are plenty of tz w/the same offset but different DST, etc. rules). if you're using flash/flex raw, it's date strings can include the tz which you could parse out. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using __type__ to return objects to Flex
Hmmm...not too sure what you mean by this. I had the code setup in a DAO gateway, so the cfcomponent alias=AddressBook was in an AddressBook.cfc (the code I posted was a cffunction in AddressBookGateway.cfc). In my AS class, I have [RemoteClass(alias=AddressBook)] to handle the class that is returned from CF (and convert it to the correct AddressBook class). In the code, I'm trying to return an array of AddressBook objects (thus the array that I'm returning). If I do a createobject for CF AddressBook objects and put it in an array, it correctly returns an array of AddressBook objects back to AS; however, if I use the __type__ and a struct of the other variables (even with correct camelCasing), it returns an array of generic objects. If I try a returntype of AddressBook[] from CF, it states that it is not a valid AddressBook (which makes sense as it hasn't been converted yet). If I can only return one item back to AS from CF using this method, I'll probably just stick with the method I was using before (as creating one object vs. one struct isn't going to make a big difference), but if it can send multiple items back as VOs, then that's what I'm looking for. There's something I'm missing between the gateway and the AS. If, as Barney states, it is the LiveCycle intermediary, then I'm fresh out as my company won't pony up for that, but if there's something else that I'm missing that can do the conversion via AMF, then I'm all ears :) Thanks. Gareth sorry pressed send too soon. To finish that sentence : The only thing I see that is odd about your posted code is that you are returning an array, so on the flex side you need to make sure that you are compiling an instance of your VO into the application or you will get a generic object... On Feb 19, 2008 1:13 PM, J ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT: Holy Grail? Hosting?
I did the following and everything seems fine now. -Open Administrative Tools-Event Viewer and if you see the following W3SVC-WP (IIS6) error messages: - Could not load all ISAPI filters for site/service. Therefore startup aborted -Remove filter from IIS manager: (Web Sites-Properties-ISAPI filters plus disable that filter in Web Server Extentions). -Restart IIS completed OK. Which one? There are 3 different ones mentioned in that thread. Really though, a simple fix probably isn't going to do it, the Plesk on my server just really seems hosed. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The GetTimeZoneInfo() function
Paul, Not timezone, time. -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:47 PM To: CF-Talk Subject: Re: The GetTimeZoneInfo() function William Seiter wrote: I believe you can use JS to pull the local computer's time and then use AJAX you *cannot* get the client's tz via js. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The GetTimeZoneInfo() function
William Seiter wrote: Not timezone, time. the original question was about timezone, not time. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: The GetTimeZoneInfo() function
That is correct, the querant only asked about timezone, however, if we limit our responses to just 'what the querant asked about' there may be a world of solutions that the querant had not even anticipated, hence the further reference I had made to find out what the need was for. As for timezone... When I do this line of code: var currentTime = new Date();document.getElementById('writedate').innerHTML = currentTime; I get this result in FF: Tue Feb 19 2008 20:11:51 GMT-0800 (Pacific Standard Time) That appears to contain a timezone reference both by name and by GMT count. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 7:31 PM To: CF-Talk Subject: Re: The GetTimeZoneInfo() function William Seiter wrote: Not timezone, time. the original question was about timezone, not time. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SEO / website organization
On 2/19/08, Jaysen Pollard [EMAIL PROTECTED] wrote: I have a ticket site. http://www.GotTickets.com From a SEO perspective which is better: #1. Is it better to use sub directories /Sports /Sports/basketball /sports/basketball/Lakers All lower case, as case is really a url encoded value. think of the replacement of spaces with %20, capital letters are the same thing. or subdomains Lakers.gottickets.com Kings.gottickets.com No sub domains as each hold their own index and since you will be linking to all of your ticket areas from within one site you should go with sub directories and keep the whole website under one index. #2. In a directory solution is it better to have /sports/basketball/lakerstickets.cfm or /sports/basketball/lakers/lakerstickets.cfm Neither How about /sports/basketball/lakers/ #3. File names: lakerstickets.cfm or Lakers_Tickets.cfm index.cfm if you need tickets, add a directory /bball/team/tickets/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSS Question
Jake, Ok, I've been playing around for the last 2 hours and can't get it to work. For example, in the following header both displays on the screen and prints. What am I doing wrong? !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 //EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 STYLE type=text/css @media screen { #Header { position: fixed; width: 100%; height: auto; font-size: 20pt; font-weight: bold; } } @media print { #Header {visibility: hidden;} } /STYLE titleTest Document/title /head body div id=HeaderHeader/div pTesting/p /body /html -Original Message- From: Jake Churchill [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:39 PM To: CF-Talk Subject: RE: CSS Question media=print in your link tag where you import the stylesheet will accomplish this. media=screen will be screen specific and media=all is for both. A lack of this attribute will default to all. There's more too it than that. Here's a good resource for you: http://www.w3.org/TR/REC-CSS2/media.html _ Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Andy [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:34 PM To: CF-Talk Subject: OT: CSS Question I understand how to make fields invisible, but is there a way to have a field display on the screen, but become invisible when printed? For example, can I set one stylesheet for Display and another for printing? Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The GetTimeZoneInfo() function
That's neat, it also works with IE7. Now, I'm a bit scare of script kitty, not this one or the like. That is correct, the querant only asked about timezone, however, if we limit our responses to just 'what the querant asked about' there may be a world of solutions that the querant had not even anticipated, hence the further reference I had made to find out what the need was for. As for timezone... When I do this line of code: var currentTime = new Date();document.getElementById('writedate').innerHTML = currentTime; I get this result in FF: Tue Feb 19 2008 20:11:51 GMT-0800 (Pacific Standard Time) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using __type__ to return objects to Flex
Sorry I guess I wasn't clear, you absolutely can return arrays of typed structs and have them converted for you. That's the main point of doing this. You can return thousands of objects in arrays, and it is ridiculously faster then creating cfcs, you do not need LCDS to do this. I mentioned the array because in Flex if you don't have an instance of the AddressBook object compiled into the app, it will come in as a generic object. But if it works when you return arrays of vos that were created with CreateObject, then that's not the problem. Is the AddressBook.cfc in your webroot or is it under some path? This : [RemoteClass(alias=AddressBook)] will only work (with this method) if AddressBook is in your webroot, if you use CreateObject it will work without the fully qualified path, but if you want to use this typed struct method you have to use the full path. So if your AddressBook is actually in com.vo.AddressBook then you have to use struct['__type__'] = 'com.vo.AddressBook' and [RemoteClass(alias=com.vo.AddressBook)] Sorry if I am making it sound more complicated then it is, but it basically boils down to making sure your __type__ is fully qualified and matches your alias. On Feb 19, 2008 5:15 PM, Gareth Arch [EMAIL PROTECTED] wrote: Hmmm...not too sure what you mean by this. I had the code setup in a DAO gateway, so the cfcomponent alias=AddressBook was in an AddressBook.cfc (the code I posted was a cffunction in AddressBookGateway.cfc). In my AS class, I have [RemoteClass(alias=AddressBook)] to handle the class that is returned from CF (and convert it to the correct AddressBook class). In the code, I'm trying to return an array of AddressBook objects (thus the array that I'm returning). If I do a createobject for CF AddressBook objects and put it in an array, it correctly returns an array of AddressBook objects back to AS; however, if I use the __type__ and a struct of the other variables (even with correct camelCasing), it returns an array of generic objects. If I try a returntype of AddressBook[] from CF, it states that it is not a valid AddressBook (which makes sense as it hasn't been converted yet). If I can only return one item back to AS from CF using this method, I'll probably just stick with the method I was using before (as creating one object vs. one struct isn't going to make a big difference), but if it can send multiple items back as VOs, then that's what I'm looking for. There's something I'm missing between the gateway and the AS. If, as Barney states, it is the LiveCycle intermediary, then I'm fresh out as my company won't pony up for that, but if there's something else that I'm missing that can do the conversion via AMF, then I'm all ears :) Thanks. Gareth sorry pressed send too soon. To finish that sentence : The only thing I see that is odd about your posted code is that you are returning an array, so on the flex side you need to make sure that you are compiling an instance of your VO into the application or you will get a generic object... On Feb 19, 2008 1:13 PM, J ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CSS Question
OK. Not sure what happened. But now it is working in IE and FireFox, although FireFox displays the data differently. More playing I guess. Is there a way I can set headers and footers and set page size and orientation via a Print button? -Original Message- From: Andy [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 10:16 PM To: 'cf-talk@houseoffusion.com' Subject: RE: CSS Question Jake, Ok, I've been playing around for the last 2 hours and can't get it to work. For example, in the following header both displays on the screen and prints. What am I doing wrong? !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 //EN http://www.w3.org/TR/html4/loose.dtd; html head meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 STYLE type=text/css @media screen { #Header { position: fixed; width: 100%; height: auto; font-size: 20pt; font-weight: bold; } } @media print { #Header {visibility: hidden;} } /STYLE titleTest Document/title /head body div id=HeaderHeader/div pTesting/p /body /html -Original Message- From: Jake Churchill [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:39 PM To: CF-Talk Subject: RE: CSS Question media=print in your link tag where you import the stylesheet will accomplish this. media=screen will be screen specific and media=all is for both. A lack of this attribute will default to all. There's more too it than that. Here's a good resource for you: http://www.w3.org/TR/REC-CSS2/media.html _ Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Andy [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 5:34 PM To: CF-Talk Subject: OT: CSS Question I understand how to make fields invisible, but is there a way to have a field display on the screen, but become invisible when printed? For example, can I set one stylesheet for Display and another for printing? Andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The GetTimeZoneInfo() function
William Seiter wrote: That is correct, the querant only asked about timezone, however, if we limit our responses to just 'what the querant asked about' there may be a world of the querant? what are we tarot card readers (and yes, had to look that word up)? I get this result in FF: Tue Feb 19 2008 20:11:51 GMT-0800 (Pacific Standard Time) thanks. thats interesting to know, i haven't really looked back at js since flex came out. in any case while that appears to be a valid long tz ID for where you are, it's not for where i am (bangkok): Wed Feb 20 2008 11:47:43 GMT+0700 (SE Asia Standard Time). it should be either Asia/Bangkok or ICT or Indochina Time depending on the JDK version. i suppose some finagling could produce a valid java tz but wonder if this will work across browsers/versions? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS Question
use cfdocument to create a pdf to your size and specs. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Andy wrote: OK. Not sure what happened. But now it is working in IE and FireFox, although FireFox displays the data differently. More playing I guess. Is there a way I can set headers and footers and set page size and orientation via a Print button? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4