RE: [ACFUG Discuss] HostMySite observations?
Dusty, And your new VPS provider is...? Inquiring minds want to know! Paul Morton From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dusty Hale Sent: Friday, February 01, 2013 9:15 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] HostMySite observations? From total hosting stardom to complete has-been. I used to think they were the best thing since sliced bread but now they're just plain difficult to deal with and just not the same HostMySite that developers used to love. I use them only because I still have a few shared sites left there and I plan to move those eventually. I also had to move my Windows VPS and CF setup because they just suddenly discontinued the service on it and tried to force me to moving to their new cloud service at more than double the cost. We found another reliable VPS provider for almost half of the original cost of their VPS service they discontinued and the new provider we found has not only saved us a ton of money but they've done a far better job than HMS has done since they went downhill. Ironically I think about 1 year after killing my VPS service, they started offering it again but it's too late it was too much work to move it and the new provider is better and the cost is only half what I was paying HMS. Dusty On Fri, Feb 1, 2013 at 9:58 AM, Adam Churvis a...@productivityenhancement.com wrote: For those of you who have been hosting your or your clients' sites on HostMySite for a number of years, how would you describe their quality trend over time? Thanks in advance for your replies. Respectfully, Adam Churvis Productivity Enhancement -- Dusty Hale Email: du...@dustyhale.com Phone (USA): +1.850.387.2321 Skype (World Wide): dustyhale CONFIDENTIALITY NOTICE: This transmission and any accompanying information are intended exclusively for the addressee. Information may be proprietary, privileged, and confidential or otherwise legally exempt from disclosure. The authorized recipient of this information is prohibited from disclosing this information to any other unauthorized party and is required to maintain the privacy/security of the information. If you are not the addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please contact the sender immediately and, unless instructed otherwise by sender, destroy or delete the message and accompanying information completely from all systems and within standards required by State or Federal law. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] Database incremental Counter
I'm just looking for ideas when creating a counter in a SQL server database. I have a need for a counter that stores an integer value and increments the counter each time it is used. My inclination is to create a table with one record with one integer field that is just retrieved, incremented, and updated each time I need a new number. It seems sort of kludgey, and I would love to hear any other implementations anyone may have used, or can dream up. Also, if anyone can anticipate any issues with this method, I would love to hear them. I have no need for keeping any records of the numbers used. Paul Morton - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Database incremental Counter
Howard, Thanks. I like the idea of doing it with a trigger. Paul _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Fore Sent: Wednesday, March 12, 2008 11:02 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Database incremental Counter Barring some other requirement that dictates otherwise, you'd be better off to keep the incrementing function on the database. Use an insert trigger on the table to update the row or make the field autoincrementing. Howard On Wed, Mar 12, 2008 at 12:45 PM, Paul Morton [EMAIL PROTECTED] wrote: I'm just looking for ideas when creating a counter in a SQL server database. I have a need for a counter that stores an integer value and increments the counter each time it is used. My inclination is to create a table with one record with one integer field that is just retrieved, incremented, and updated each time I need a new number. It seems sort of kludgey, and I would love to hear any other implementations anyone may have used, or can dream up. Also, if anyone can anticipate any issues with this method, I would love to hear them. I have no need for keeping any records of the numbers used. Paul Morton - Annual Sponsor - Figleaf http://www.figleaf.com Software To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - -- Howard Fore, [EMAIL PROTECTED] The universe tends toward maximum irony. Don't push it. - Jeff Atwood - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Database incremental Counter
Thanks Greg, I'm not looking to create a table full of records, which is what is required to use the identity column. I just want a number that is incremented when used, keeping the table limited to one record. I currently have it working, but I run a select to retrieve the value, then an update to increment the value. I wish I could write a trigger on a select. I would like to do it in one step. It's just an exercise to eliminate a database action. Hope this makes sense. Paul Paul Morton Morton International Consulting, Inc. p: 406 459-5634 f: 406 449-3151 w: www.mortonint.com _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of McTure, Greg Sent: Wednesday, March 12, 2008 4:12 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Database incremental Counter Hi Paul: There are a few functional ways you could do this; however, for the sake of simplicity and quick implementation, I would consider using an IDENTITY column with an INT or NUMERIC data type. That will function just like the auto num column for primary keys in an Access database. You could also implement a trigger that will increment the number in the specified column in the event of an insert and decrement it in the event of a deletion. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Morton Sent: Wednesday, March 12, 2008 12:46 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Database incremental Counter I'm just looking for ideas when creating a counter in a SQL server database. I have a need for a counter that stores an integer value and increments the counter each time it is used. My inclination is to create a table with one record with one integer field that is just retrieved, incremented, and updated each time I need a new number. It seems sort of kludgey, and I would love to hear any other implementations anyone may have used, or can dream up. Also, if anyone can anticipate any issues with this method, I would love to hear them. I have no need for keeping any records of the numbers used. Paul Morton - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Database incremental Counter
That should work. I'll try that. Thanks. Paul Paul Morton Morton International Consulting, Inc. p: 406 459-5634 f: 406 449-3151 w: www.mortonint.com _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of McTure, Greg Sent: Wednesday, March 12, 2008 4:42 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Database incremental Counter Couldn't you create a small stored procedure that will actually run the select and subsequently increment the number? Therefore you simply can the stored procedure which in turn will return the record(s) you want and also increment the value. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Morton Sent: Wednesday, March 12, 2008 6:38 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Database incremental Counter Thanks Greg, I'm not looking to create a table full of records, which is what is required to use the identity column. I just want a number that is incremented when used, keeping the table limited to one record. I currently have it working, but I run a select to retrieve the value, then an update to increment the value. I wish I could write a trigger on a select. I would like to do it in one step. It's just an exercise to eliminate a database action. Hope this makes sense. Paul Paul Morton Morton International Consulting, Inc. p: 406 459-5634 f: 406 449-3151 w: www.mortonint.com _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of McTure, Greg Sent: Wednesday, March 12, 2008 4:12 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] Database incremental Counter Hi Paul: There are a few functional ways you could do this; however, for the sake of simplicity and quick implementation, I would consider using an IDENTITY column with an INT or NUMERIC data type. That will function just like the auto num column for primary keys in an Access database. You could also implement a trigger that will increment the number in the specified column in the event of an insert and decrement it in the event of a deletion. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Morton Sent: Wednesday, March 12, 2008 12:46 PM To: discussion@acfug.org Subject: [ACFUG Discuss] Database incremental Counter I'm just looking for ideas when creating a counter in a SQL server database. I have a need for a counter that stores an integer value and increments the counter each time it is used. My inclination is to create a table with one record with one integer field that is just retrieved, incremented, and updated each time I need a new number. It seems sort of kludgey, and I would love to hear any other implementations anyone may have used, or can dream up. Also, if anyone can anticipate any issues with this method, I would love to hear them. I have no need for keeping any records of the numbers used. Paul Morton - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http
RE: [ACFUG Discuss] OT: Dreamweaver 8 Savng Passwords
Scott, I've been using DW8 since it came out, and have never experienced that behavior. Sorry I can't help, but thought I would give you one data point in your investigation. I'm at version 8.0.2. Paul Morton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Councill Sent: Monday, August 06, 2007 8:33 AM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: Dreamweaver 8 Savng Passwords More a frustration than anything else but is anyone else having problems with DW8 losing the login information for their remote sites? Actually the site I am having trouble with uses FTP to connect. Could it be the server I am connecting to? Scott Councill Software Engineer Direct: 404.601.4390 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Spunlogic Expect More From the Web http://www.spunlogic.com/?CMP=EMC-OutlookSig www.spunlogic.com Looking for insights and tips on all aspects of interactive marketing? Visit http://www.spunlogic.com/blog/?CMP=EMC-OutlookSig Spunlogic's Blog for a look inside the minds of a leading interactive agency. - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: Dreamweaver 8 Savng Passwords
Just found this on Adobe site http://kb.adobe.com/selfservice/viewContent.do?externalId=a3f38dcf pertinent sentence: The 8.0.2 update fixes a problem of FTP usernames and passwords in Dreamweaver site definitions being deleted when you close and re-open Dreamweaver 8 or when you reboot your machine. This problem is the result of a change introduced in Internet Explorer 7. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Councill Sent: Monday, August 06, 2007 8:33 AM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: Dreamweaver 8 Savng Passwords More a frustration than anything else but is anyone else having problems with DW8 losing the login information for their remote sites? Actually the site I am having trouble with uses FTP to connect. Could it be the server I am connecting to? Scott Councill Software Engineer Direct: 404.601.4390 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Spunlogic Expect More From the Web http://www.spunlogic.com/?CMP=EMC-OutlookSig www.spunlogic.com Looking for insights and tips on all aspects of interactive marketing? Visit http://www.spunlogic.com/blog/?CMP=EMC-OutlookSig Spunlogic's Blog for a look inside the minds of a leading interactive agency. - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] OT: SQL help
I apologize for the OT post, but I'm getting frustrated. I am attempting to use a UDF to split a varchar (comma delimited list of ints) in an IN clause in a SQL statement, and I'm not able to get the SQL statement to pass a Table field to the UDF. I'm hoping someone sees a glaring error, or can tell me I can't do this. MS SQL 2000 CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) ) RETURNS @RtnValue table ( Id int identity(1,1), Value nvarchar(100) ) AS BEGIN While (Charindex(@SplitOn,@List)0) Begin Insert Into @RtnValue (value) Select Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1))) Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitOn),len(@List)) End Insert Into @RtnValue (Value) Select Value = ltrim(rtrim(@List)) Return END SQL Statement SELECT * FROM dbo.ORDER_ITEMS oi LEFT OUTER JOIN dbo.AP_translation tr ON tr.option_id IN (select convert(int,Value) from dbo.Split(oi.OptionIDs, ',')) WHERE (oi.Order_ID = 12387) _ Error received: Server: Msg 170, Level 15, State 1, Line 4 Line 4: Incorrect syntax near '.'. OptionIDs is a varchar(255) field with a comma delimited list of integers. It doesn't like the oi.OptionIDs. If I put in a list like '0,1,2' in it's place, the query works. Can I not pass a field into a UDF? Is there another way to skin this cat? Paul - Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: SQL help
Teddy, Any idea why do I get an error in Query Analyzer : SQL Statement SELECT * FROM dbo.ORDER_ITEMS oi LEFT OUTER JOIN dbo.AP_translation tr ON tr.option_id IN (select convert(int,Value) from dbo.Split(oi.OptionIDs, ',')) WHERE (oi.Order_ID = 12387) Error received: Server: Msg 170, Level 15, State 1, Line 4 Line 4: Incorrect syntax near '.'. Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R Payne Sent: Tuesday, June 05, 2007 12:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: SQL help You use it in an adhoc query in query analyzer or SSMA. I have not tried it as an ad hoc query in CF as I myself tend not to use cfquery wherever I can. Teddy - Original Message - From: Paul mailto:[EMAIL PROTECTED] Morton To: discussion@acfug.org Sent: Tuesday, June 05, 2007 1:58 PM Subject: RE: [ACFUG Discuss] OT: SQL help Without creating a SP, can I use this in a select statement? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R Payne Sent: Tuesday, June 05, 2007 11:45 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: SQL help Paul, There is already an open source function in SQL Server to do this for you: http://www.4guysfromrolla.com/webtech/031004-1.shtml They explain how to put it together. Here is the function creation for how I put it together from their explanation: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Split]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[Split] GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE FUNCTION dbo.Split ( @List nvarchar(4000), @SplitOn nvarchar(5) ) RETURNS @RtnValue table ( Id int identity(1,1), Value nvarchar(250) ) AS BEGIN While (Charindex(@SplitOn,@List)0) Begin Insert Into @RtnValue ( value ) Select Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1))) Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitOn),len(@List)) End Insert Into @RtnValue ( Value ) Select Value = ltrim(rtrim(@List)) Return END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO It is implemented as such: CREATE PROCEDURE getEmployeesByID(@employeeList nvarchar(1000)) AS Select employeeId, -- integer (int) FirstName, LastName from #myTable Where employeeId IN (Select convert(int,Value) from dbo.Split(@employeeList,',')) Cheers, Teddy - Original Message - From: Paul Morton mailto:[EMAIL PROTECTED] To: discussion@acfug.org Sent: Tuesday, June 05, 2007 1:36 PM Subject: [ACFUG Discuss] OT: SQL help I apologize for the OT post, but I'm getting frustrated. I am attempting to use a UDF to split a varchar (comma delimited list of ints) in an IN clause in a SQL statement, and I'm not able to get the SQL statement to pass a Table field to the UDF. I'm hoping someone sees a glaring error, or can tell me I can't do this. MS SQL 2000 CREATE FUNCTION dbo.Split ( @List nvarchar(2000), @SplitOn nvarchar(5) ) RETURNS @RtnValue table ( Id int identity(1,1), Value nvarchar(100) ) AS BEGIN While (Charindex(@SplitOn,@List)0) Begin Insert Into @RtnValue (value) Select Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1))) Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitOn),len(@List)) End Insert Into @RtnValue (Value) Select Value = ltrim(rtrim(@List)) Return END SQL Statement SELECT * FROM dbo.ORDER_ITEMS oi LEFT OUTER JOIN dbo.AP_translation tr ON tr.option_id IN (select convert(int,Value) from dbo.Split(oi.OptionIDs, ',')) WHERE (oi.Order_ID = 12387) _ Error received: Server: Msg 170, Level 15, State 1, Line 4 Line 4: Incorrect syntax near '.'. OptionIDs is a varchar(255) field with a comma delimited list of integers. It doesn't like the oi.OptionIDs. If I put in a list like '0,1,2' in it's place, the query works. Can I not pass a field into a UDF? Is there another way to skin this cat? Paul - Annual Sponsor - Figleaf Software http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - Annual Sponsor - Figleaf Software http
[ACFUG Discuss] Parsing Date
Hi all. I have a small problem for which I'm hoping there is a simple solution. I am pulling a date from an Informix database using an undocumented Web Service and I am getting a date that looks like: [time=103129560,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone =sun.util.calendar.ZoneInfo[id=America/Los_Angeles,offset=-2880,dstSav ings=360,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZ one[id=America/Los_Angeles,offset=-2880,dstSavings=360,useDaylight=t rue,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTi me=720,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,end Time=720,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1 ,YEAR=2002,MONTH=8,WEEK_OF_YEAR=36,WEEK_OF_MONTH=1,DAY_OF_MONTH=6,DAY_OF_YEA R=249,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINU TE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-2880,DST_OFFSET=360] I need to get this into a CFML date format and I was about to start developing a parsing routine, and the thought occurred to me that someone might recognize this data format and have a ready made solution to parsing the date from this. Anybody have a quick solution, or should I just hard code a parser? Paul - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Parsing Date
Larry, I suspected that was the time=103 , but I wasn't sure of the start date. Guess I could calculate it. I was going to pull the YEAR, MONTH, and DAY_OF_MONTH out and create a date in CF. Just thought there may be a function or something available. Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 10:40 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, I would check to see if this is a converted date showing the number of seconds since 01-01-1900. That was a format used by some systems to hold the date in a numerical format for easier and a more universal storage format. I used to do this on *nix systems all the time. I will look around but I do not have the reverse readily available. Larry Paul Morton wrote: Hi all. I have a small problem for which I'm hoping there is a simple solution. I am pulling a date from an Informix database using an undocumented Web Service and I am getting a date that looks like: [time=103129560,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone =sun.util.calendar.ZoneInfo[id=America/Los_Angeles,offset=-2880,dstSav ings=360,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZ one[id=America/Los_Angeles,offset=-2880,dstSavings=360,useDaylight=t rue,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTi me=720,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,end Time=720,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1 ,YEAR=2002,MONTH=8,WEEK_OF_YEAR=36,WEEK_OF_MONTH=1,DAY_OF_MONTH=6,DAY_OF_YEA R=249,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINU TE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-2880,DST_OFFSET=360] I need to get this into a CFML date format and I was about to start developing a parsing routine, and the thought occurred to me that someone might recognize this data format and have a ready made solution to parsing the date from this. Anybody have a quick solution, or should I just hard code a parser? Paul - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Parsing Date
Larry, I did find that the Unix Time Stamp is from January 1, 1970 in one reference. I'm just going to write a routine to pull the Month Day and Year out and create a CF date. Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 11:13 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, There is something out there and I have used it, but it escaping me right now. I thought it used the word equinox or 01-01-2900 or time in the instructions/help files. Try a few Google searches and see what comes back. I am pretty sure about the starting date. Larry Paul Morton wrote: Larry, I suspected that was the time=103 , but I wasn't sure of the start date. Guess I could calculate it. I was going to pull the YEAR, MONTH, and DAY_OF_MONTH out and create a date in CF. Just thought there may be a function or something available. Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 10:40 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, I would check to see if this is a converted date showing the number of seconds since 01-01-1900. That was a format used by some systems to hold the date in a numerical format for easier and a more universal storage format. I used to do this on *nix systems all the time. I will look around but I do not have the reverse readily available. Larry Paul Morton wrote: Hi all. I have a small problem for which I'm hoping there is a simple solution. I am pulling a date from an Informix database using an undocumented Web Service and I am getting a date that looks like: [time=103129560,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone =sun.util.calendar.ZoneInfo[id=America/Los_Angeles,offset=-2880,dstSav ings=360,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZ one[id=America/Los_Angeles,offset=-2880,dstSavings=360,useDaylight=t rue,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTi me=720,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,end Time=720,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1 ,YEAR=2002,MONTH=8,WEEK_OF_YEAR=36,WEEK_OF_MONTH=1,DAY_OF_MONTH=6,DAY_OF_YEA R=249,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINU TE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-2880,DST_OFFSET=360] I need to get this into a CFML date format and I was about to start developing a parsing routine, and the thought occurred to me that someone might recognize this data format and have a ready made solution to parsing the date from this. Anybody have a quick solution, or should I just hard code a parser? Paul - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Parsing Date
Teddy and Larry, I ended up using: #CreateDate(Mid(CDate,find(YEAR,CDate)+5,Find(,MONTH=,CDATE)-find(YEAR ,CDate)-5),Mid(CDate,find(MONTH,CDate)+6,find(,WEEK_OF_YEAR,CDate)-find( ,MONTH=,CDate)-5),Mid(CDate,find(DAY_OF_MONTH,CDate)+13,find(,DAY_OF_YE AR,CDate)-find(DAY_OF_MONTH,CDate)-13))# Messy but it works. Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R. Payne Sent: Thursday, April 26, 2007 12:43 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Paul, The data has many informative pieces in it. Specifically, java.util.SimpleTimeZone gives you your time zone considerations as explained: http://72.5.124.55/j2se/1.5.0/docs/api/java/util/SimpleTimeZone.html Now it has both sun.util.calendar.ZoneInfo and java.util.SimpleTimeZone. I suspect this is to allow for backwards compatibility of time zones from java versions 1.3-1.5. I believe 103129560 is the number of milliseconds from 1970. Don't quote me. =) I would use list and struct manipulation to get the latter portion of the code: cfscript /** * Converts a delimited list of key/value pairs to a structure. * * @param list List of key/value pairs to initialize the structure with. Format follows key=value. * @param delimiter Delimiter seperating the key/value pairs. Default is the comma. * @return Returns a structure. * @author Rob Brooks-Bilson ([EMAIL PROTECTED]) * @version 1.0, December 10, 2001 */ function ListToStruct(list){ var myStruct=StructNew(); var i=0; var delimiter=,; if (ArrayLen(arguments) gt 1){ delimiter = arguments[2]; } for (i=1; i LTE ListLen(list, delimiter); i=i+1){ StructInsert(myStruct, ListFirst(ListGetAt(list, i, delimiter), =), ListLast(ListGetAt(list, i, delimiter), =)); } return myStruct; } /cfscript cfset iTime = '[time=103129560,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zon e=sun.util.calendar.ZoneInfo[id=America/Los_Angeles,offset=-2880,dstSa vings=360,useDaylight=true,transitions=185,lastRule= java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-2880,dstSavings= 360,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,sta rtDayOfWeek=1,startTime=720,startTimeMode=0,endMode=3,endMonth=10,endDay =1,endDayOfWeek=1,endTime=720,endTimeMode=0]],firstDayOfWeek=1,minimalDa ysInFirstWeek=1,ERA=1,YEAR=2002,MONTH=8,WEEK_OF_YEAR=36,WEEK_OF_MONTH=1,DAY_ OF_MONTH=6,DAY_OF_YEAR=249,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR =0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-2880,DST_O FFSET=360]' cfset iTime = ListGetAt(iTime,2,]]) cfset sTime = ListToStruct(iTime) cfset cfDate = createDate(sTime[year],sTime[month],sTime[day_of_month]) cfdump var=#cfDate# On 4/26/07, Larry J. Morrow [EMAIL PROTECTED] wrote: Oops, I forgot we change to 1970 back around 2000 with all of the bios updates. Larry Paul Morton wrote: Larry, I did find that the Unix Time Stamp is from January 1, 1970 in one reference. I'm just going to write a routine to pull the Month Day and Year out and create a CF date. Paul -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 11:13 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, There is something out there and I have used it, but it escaping me right now. I thought it used the word equinox or 01-01-2900 or time in the instructions/help files. Try a few Google searches and see what comes back. I am pretty sure about the starting date. Larry Paul Morton wrote: Larry, I suspected that was the time=103 , but I wasn't sure of the start date. Guess I could calculate it. I was going to pull the YEAR, MONTH, and DAY_OF_MONTH out and create a date in CF. Just thought there may be a function or something available. Paul -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 10:40 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, I would check to see if this is a converted date showing the number of seconds since 01-01-1900. That was a format used by some systems to hold the date in a numerical format for easier and a more universal storage format. I used to do this on *nix systems all the time. I will look around but I do not have the reverse readily available. Larry Paul Morton wrote: Hi all. I have a small problem for which I'm hoping there is a simple solution. I am pulling a date from an Informix database using an undocumented Web Service and I am getting a date that looks like: [time=103129560,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone =sun.util.calendar.ZoneInfo[id=America/Los_Angeles,offset=-2880,dstSav ings=360,useDaylight=true,transitions=185
RE: [ACFUG Discuss] Parsing Date
I agree. I am going to run it against the database of about 38000 dates that exist and make sure it at least gets actual values for the dates. I'm working on an enhanced version, but at least I have something that I know works sometimes. I appreciate the feedback and suggestions. Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R. Payne Sent: Thursday, April 26, 2007 2:17 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date You may want to test that code a little more at different parts of the day. My concern would be if the web service returned the string with a different placement of the data you are looking for. On 4/26/07, Paul Morton [EMAIL PROTECTED] wrote: Teddy and Larry, I ended up using: #CreateDate(Mid(CDate,find(YEAR,CDate)+5,Find(,MONTH=,CDATE)-find(YEAR ,CDate)-5),Mid(CDate,find(MONTH,CDate)+6,find(,WEEK_OF_YEAR,CDate)-find( ,MONTH=,CDate)-5),Mid(CDate,find(DAY_OF_MONTH,CDate)+13,find(,DAY_OF_YE AR,CDate)-find(DAY_OF_MONTH,CDate)-13))# Messy but it works. Paul -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R. Payne Sent: Thursday, April 26, 2007 12:43 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Paul, The data has many informative pieces in it. Specifically, java.util.SimpleTimeZone gives you your time zone considerations as explained: http://72.5.124.55/j2se/1.5.0/docs/api/java/util/SimpleTimeZone.html http://72.5.124.55/j2se/1.5.0/docs/api/java/util/SimpleTimeZone.html Now it has both sun.util.calendar.ZoneInfo and java.util.SimpleTimeZone. I suspect this is to allow for backwards compatibility of time zones from java versions 1.3-1.5. I believe 103129560 is the number of milliseconds from 1970. Don't quote me. =) I would use list and struct manipulation to get the latter portion of the code: cfscript /** * Converts a delimited list of key/value pairs to a structure. * * @param list List of key/value pairs to initialize the structure with. Format follows key=value. * @param delimiter Delimiter seperating the key/value pairs. Default is the comma. * @return Returns a structure. * @author Rob Brooks-Bilson ([EMAIL PROTECTED]) * @version 1.0, December 10, 2001 */ function ListToStruct(list){ var myStruct=StructNew(); var i=0; var delimiter=,; if (ArrayLen(arguments) gt 1){ delimiter = arguments[2]; } for (i=1; i LTE ListLen(list, delimiter); i=i+1){ StructInsert(myStruct, ListFirst(ListGetAt(list, i, delimiter), =), ListLast(ListGetAt(list, i, delimiter), =)); } return myStruct; } /cfscript cfset iTime = '[time=103129560,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zon e=sun.util.calendar.ZoneInfo[id=America/Los_Angeles,offset=-2880,dstSa vings=360,useDaylight=true,transitions=185,lastRule= java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-2880,dstSavings= 360,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,sta rtDayOfWeek=1,startTime=720,startTimeMode=0,endMode=3,endMonth=10,endDay =1,endDayOfWeek=1,endTime=720,endTimeMode=0]],firstDayOfWeek=1,minimalDa ysInFirstWeek=1,ERA=1,YEAR=2002,MONTH=8,WEEK_OF_YEAR=36,WEEK_OF_MONTH=1,DAY_ OF_MONTH=6,DAY_OF_YEAR=249,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR =0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-2880,DST_O FFSET=360]' cfset iTime = ListGetAt(iTime,2,]]) cfset sTime = ListToStruct(iTime) cfset cfDate = createDate(sTime[year],sTime[month],sTime[day_of_month]) cfdump var=#cfDate# On 4/26/07, Larry J. Morrow [EMAIL PROTECTED] wrote: Oops, I forgot we change to 1970 back around 2000 with all of the bios updates. Larry Paul Morton wrote: Larry, I did find that the Unix Time Stamp is from January 1, 1970 in one reference. I'm just going to write a routine to pull the Month Day and Year out and create a CF date. Paul -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 11:13 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, There is something out there and I have used it, but it escaping me right now. I thought it used the word equinox or 01-01-2900 or time in the instructions/help files. Try a few Google searches and see what comes back. I am pretty sure about the starting date. Larry Paul Morton wrote: Larry, I suspected that was the time=103 , but I wasn't sure of the start date. Guess I could calculate it. I was going to pull the YEAR, MONTH, and DAY_OF_MONTH out and create a date in CF. Just thought there may be a function or something available. Paul -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 10:40 AM
RE: [ACFUG Discuss] Parsing Date
This works, and is independent of Position. Might have other problems, so let me know if you think it might have issues as well. CreateDate(Val(Mid(CDate,find(YEAR=,CDate)+5,4)),Val(Mid(CDate,find(,MONT H=,CDate)+7,2)),Val(Mid(CDate,find(DAY_OF_MONTH,CDate)+13,2))) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R. Payne Sent: Thursday, April 26, 2007 2:17 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date You may want to test that code a little more at different parts of the day. My concern would be if the web service returned the string with a different placement of the data you are looking for. On 4/26/07, Paul Morton [EMAIL PROTECTED] wrote: Teddy and Larry, I ended up using: #CreateDate(Mid(CDate,find(YEAR,CDate)+5,Find(,MONTH=,CDATE)-find(YEAR ,CDate)-5),Mid(CDate,find(MONTH,CDate)+6,find(,WEEK_OF_YEAR,CDate)-find( ,MONTH=,CDate)-5),Mid(CDate,find(DAY_OF_MONTH,CDate)+13,find(,DAY_OF_YE AR,CDate)-find(DAY_OF_MONTH,CDate)-13))# Messy but it works. Paul -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy R. Payne Sent: Thursday, April 26, 2007 12:43 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Paul, The data has many informative pieces in it. Specifically, java.util.SimpleTimeZone gives you your time zone considerations as explained: http://72.5.124.55/j2se/1.5.0/docs/api/java/util/SimpleTimeZone.html http://72.5.124.55/j2se/1.5.0/docs/api/java/util/SimpleTimeZone.html Now it has both sun.util.calendar.ZoneInfo and java.util.SimpleTimeZone. I suspect this is to allow for backwards compatibility of time zones from java versions 1.3-1.5. I believe 103129560 is the number of milliseconds from 1970. Don't quote me. =) I would use list and struct manipulation to get the latter portion of the code: cfscript /** * Converts a delimited list of key/value pairs to a structure. * * @param list List of key/value pairs to initialize the structure with. Format follows key=value. * @param delimiter Delimiter seperating the key/value pairs. Default is the comma. * @return Returns a structure. * @author Rob Brooks-Bilson ([EMAIL PROTECTED]) * @version 1.0, December 10, 2001 */ function ListToStruct(list){ var myStruct=StructNew(); var i=0; var delimiter=,; if (ArrayLen(arguments) gt 1){ delimiter = arguments[2]; } for (i=1; i LTE ListLen(list, delimiter); i=i+1){ StructInsert(myStruct, ListFirst(ListGetAt(list, i, delimiter), =), ListLast(ListGetAt(list, i, delimiter), =)); } return myStruct; } /cfscript cfset iTime = '[time=103129560,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zon e=sun.util.calendar.ZoneInfo[id=America/Los_Angeles,offset=-2880,dstSa vings=360,useDaylight=true,transitions=185,lastRule= java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-2880,dstSavings= 360,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,sta rtDayOfWeek=1,startTime=720,startTimeMode=0,endMode=3,endMonth=10,endDay =1,endDayOfWeek=1,endTime=720,endTimeMode=0]],firstDayOfWeek=1,minimalDa ysInFirstWeek=1,ERA=1,YEAR=2002,MONTH=8,WEEK_OF_YEAR=36,WEEK_OF_MONTH=1,DAY_ OF_MONTH=6,DAY_OF_YEAR=249,DAY_OF_WEEK=6,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR =0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-2880,DST_O FFSET=360]' cfset iTime = ListGetAt(iTime,2,]]) cfset sTime = ListToStruct(iTime) cfset cfDate = createDate(sTime[year],sTime[month],sTime[day_of_month]) cfdump var=#cfDate# On 4/26/07, Larry J. Morrow [EMAIL PROTECTED] wrote: Oops, I forgot we change to 1970 back around 2000 with all of the bios updates. Larry Paul Morton wrote: Larry, I did find that the Unix Time Stamp is from January 1, 1970 in one reference. I'm just going to write a routine to pull the Month Day and Year out and create a CF date. Paul -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 11:13 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Parsing Date Hi Paul, There is something out there and I have used it, but it escaping me right now. I thought it used the word equinox or 01-01-2900 or time in the instructions/help files. Try a few Google searches and see what comes back. I am pretty sure about the starting date. Larry Paul Morton wrote: Larry, I suspected that was the time=103 , but I wasn't sure of the start date. Guess I could calculate it. I was going to pull the YEAR, MONTH, and DAY_OF_MONTH out and create a date in CF. Just thought there may be a function or something available. Paul -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] On Behalf Of Larry J. Morrow Sent: Thursday, April 26, 2007 10:40 AM To: discussion@acfug.org
RE: [ACFUG Discuss] developing cf apps with sql server express databases
http://www.microsoft.com/products/info/product.aspx?view=22 http://www.microsoft.com/products/info/product.aspx?view=22pcid=f544888c-2 638-48ed-9f0f-d814e8b93ca0type=ovr#HowToBuy pcid=f544888c-2638-48ed-9f0f-d814e8b93ca0type=ovr#HowToBuy Developer Edition: $49.95 Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, April 12, 2007 5:47 AM To: [EMAIL PROTECTED] Subject: RE: [ACFUG Discuss] developing cf apps with sql server express databases Yes, developing on express should be fine locally but trying to copy data may be a bit of a pain if you're using studio express as there's no tools for doing data transformations in the express version. However, I think you can buy a developer copy of sql server 2005 for something like $40 (I was just reminded of this today). Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dusty Hale Sent: Wednesday, April 11, 2007 10:24 PM To: [EMAIL PROTECTED] Subject: [ACFUG Discuss] developing cf apps with sql server express databases Anyone use SQL Server Express for developing CF apps on a local PC with windows XP Pro? Is this a good (cheap) solution for a development platform if the live platform will have SQL Server 2005? Will a database developed with SQL Server Express port over well and is the Interface for SQL Server Express similar to Enterprise Manager? Thx, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] coldfusion web hosting
I've been real happy with CFDYNAMICS.COM. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Osmus Sent: Monday, April 09, 2007 1:35 PM To: discussion@acfug.org Subject: [ACFUG Discuss] coldfusion web hosting can anyone suggest cheap, reliable coldfusion web hosting for personal use? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: CAPTCHA Effectiveness
Thanks everyone for your comments and links to other resources. It's provided some very good reading on the topic, and some great insight. Paul Morton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart Sent: Wednesday, February 28, 2007 10:19 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: CAPTCHA Effectiveness This subject, of whether one should worry about someone trying to break a captcha on your own site, is something I blogged about: Captchas: making them simpler, and dialing down the angst against them http://carehart.org/blog/client/index.cfm/2006/8/17/the_angst_against_captc has I was making the point (which may address some of your concerns Paul) that the default captcha used by LylaCaptcha, which underlies BlogCFC, was just more complicated than it needed to be (which could be hurting bloggers whose sites were being protected by it). As I said there, my blog is not a bank, so I don't need to worry about people breaking in to leave me a spam comment. It's just not worth it to them. I just felt the captcha could be simplified without grave risk, based on the arguments in the entry above: Simplifying the captcha graphic in Lyla Captcha (and BlogCFC) http://carehart.org/blog/client/index.cfm/2006/8/17/simplifying_lyla_in_blo gcfc I used the analogy of putting on a screen door versus a double-key deadbolt. It seems my arguments made sense. Besides the favorable comments, soon after those entries, Ray changed the default in BlogCFC to use the simpler captcha I advocated. But for those using an older version, I offer the XML file to update it at: Want to simplify your Blogcfc (or other Lyla-based) captcha? Here's the XML file. http://carehart.org/blog/client/index.cfm/2006/10/7/lyla_captcha_simplified _xml_file As usual, my answer is more than you asked, Paul, but I hope it's helpful to you and others. /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Morton Sent: Wednesday, February 28, 2007 1:11 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: CAPTCHA Effectiveness Thanks for the quick response Dean. I guess if you paid someone to fill out the forms manually, there is really no way to stop it, short of taking the form off line. Paul Morton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Wednesday, February 28, 2007 11:01 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: CAPTCHA Effectiveness CAPTCHA is easy to bypass, in general. If there is enough value you can do it programatically or pay poor people in developing countries to manually bypass CAPTCHA devices. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Free speech exercised both individually and through a free press, is a necessity in any country where people are themselves free. -- Theodore Roosevelt, 1918 On Feb 28, 2007, at 12:35 PM, Paul Morton wrote: Sorry about the off topic post, but I'm curious as to how effective people have found CAPTCHA at stopping, or at least slowing down the SPAM form hijacking on public pages? I have little experience on public sites as most of my development is on intranet sites. Paul Morton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from
[ACFUG Discuss] OT: CAPTCHA Effectiveness
Sorry about the off topic post, but I'm curious as to how effective people have found CAPTCHA at stopping, or at least slowing down the SPAM form hijacking on public pages? I have little experience on public sites as most of my development is on intranet sites. Paul Morton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: CAPTCHA Effectiveness
Thanks for the quick response Dean. I guess if you paid someone to fill out the forms manually, there is really no way to stop it, short of taking the form off line. Paul Morton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Wednesday, February 28, 2007 11:01 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: CAPTCHA Effectiveness CAPTCHA is easy to bypass, in general. If there is enough value you can do it programatically or pay poor people in developing countries to manually bypass CAPTCHA devices. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Free speech exercised both individually and through a free press, is a necessity in any country where people are themselves free. -- Theodore Roosevelt, 1918 On Feb 28, 2007, at 12:35 PM, Paul Morton wrote: Sorry about the off topic post, but I'm curious as to how effective people have found CAPTCHA at stopping, or at least slowing down the SPAM form hijacking on public pages? I have little experience on public sites as most of my development is on intranet sites. Paul Morton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Test
Back at ya! Paul Morton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 8:33 AM To: discussion@acfug.org Subject: [ACFUG Discuss] Test ACK? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] OT: Able Commerce
Title: Message Cody, I'm surprised to hear that. My understanding is that the CF version has been around a while. That's a good point for me to get clarified. I did hear (from an Able Commerce employee) that the current development team tends to develop improvements on the DotNet platform first and apply the changes to the CF version latter. It looks like the client is leaning towards the CF version right now just due to the lower learning curve to modify source code. They have no experience in either technology but are much more impressed with the ease of understandability in the CF side. Thanks for the feedback. Paul Morton -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cody WehuntSent: Wednesday, June 07, 2006 9:07 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] OT: Able Commerce Paul, Also keep in mind that the CF version is fairly new compared to the Dot Net (old ASP) version. On a project I worked on in the past I found it odd they actually sold a beta. But the good thing is I think for the money you can definitely get some great built in functionality. Cody From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul MortonSent: Wednesday, June 07, 2006 9:05 AMTo: discussion@acfug.orgSubject: [ACFUG Discuss] OT: Able Commerce Iam interestedin feedback on Able Commerce. I have a client that is very interested in moving to that package, andwould welcome yourthoughtson any support issues, performance, or implementation issues. Any thoughts on the Dot Net version vs. the CFMX version would also be helpful. Paul Morton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] OT: Able Commerce
Thanks Cam. Paul Morton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Childress Sent: Thursday, June 08, 2006 1:28 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] OT: Able Commerce Paul - Able Commerce was originally a CF only product. It was definitly first built in CF and them later ported to .NET (sometime around 2001/2002?). However, I suspect that if the .NET version sold better that they may now be putting features in the .NET version first and then porting them to CF later. -Cameron On 6/8/06, Paul Morton [EMAIL PROTECTED] wrote: Cody, I'm surprised to hear that. My understanding is that the CF version has been around a while. That's a good point for me to get clarified. I did hear (from an Able Commerce employee) that the current development team tends to develop improvements on the DotNet platform first and apply the changes to the CF version latter. It looks like the client is leaning towards the CF version right now just due to the lower learning curve to modify source code. They have no experience in either technology but are much more impressed with the ease of understandability in the CF side. Thanks for the feedback. Paul Morton -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cody Wehunt Sent: Wednesday, June 07, 2006 9:07 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] OT: Able Commerce Paul, Also keep in mind that the CF version is fairly new compared to the Dot Net (old ASP) version. On a project I worked on in the past I found it odd they actually sold a beta. But the good thing is I think for the money you can definitely get some great built in functionality. Cody From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Morton Sent: Wednesday, June 07, 2006 9:05 AM To: discussion@acfug.org Subject: [ACFUG Discuss] OT: Able Commerce I am interested in feedback on Able Commerce . I have a client that is very interested in moving to that package, and would welcome your thoughts on any support issues, performance, or implementation issues. Any thoughts on the Dot Net version vs. the CFMX version would also be helpful. Paul Morton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com --- cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] OT: Able Commerce
Title: Message Iam interestedin feedback on Able Commerce. I have a client that is very interested in moving to that package, andwould welcome yourthoughtson any support issues, performance, or implementation issues. Any thoughts on the Dot Net version vs. the CFMX version would also be helpful. Paul Morton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] OT: Able Commerce
Title: Message Thanks Robert and Leon for the feedback. Paul Morton -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert ReilSent: Wednesday, June 07, 2006 11:13 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] OT: Able Commerce I use CFMX 5.5 version of Able in my store. I have never used any other cart, but every day I am impressed with its potential and flexibility. The only thing that it WILL NOT DO that I need it to do is: The products have a one to one relationship with the vendor of the product. We have many vendors that sell the same product and this situation is not catered to from the Purchasing agents perspective. There is a work around by adding a Vendor_Products table into the DB, and using foreign keys etc to make it work but that is something that needs doing that you may or maynot need. Also: See web2market.com for some addon features available for the CFMX cart. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com From: Leon Oosterwijk [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 11:24 AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] OT: Able Commerce Paul, We run able commerce here. (www.daveramsey.com/shop) I've not used the .net (or jsp) versions but the cfmx works pretty well. we had some thread safety issues early on but those seems to all be resolved now. One thing to keep in mind is that the license you buy is tied to one and only one domain name. so if your store is purchased for www.example.com, and people to do example.com they will get a license error. Leon From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul MortonSent: Wednesday, June 07, 2006 8:05 AMTo: discussion@acfug.orgSubject: [ACFUG Discuss] OT: Able Commerce Iam interestedin feedback on Able Commerce. I have a client that is very interested in moving to that package, andwould welcome yourthoughtson any support issues, performance, or implementation issues. Any thoughts on the Dot Net version vs. the CFMX version would also be helpful. Paul Morton - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -