Create CSV and TAB docs
Hi All. I need to give users the ability to download a CSV and TAB file. While I found a neat little function to create a CVS file (http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am having a problem with dates values. Here is my date: 6/20/2009 7:15:03 PM but in the file it shows up as this: 15:03.0 Also, any tips/resources on how to create a TAB file? I can't find anything. Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348425 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Create CSV and TAB docs
Are you seeing that value in Excel? What do you see if you open the CSV with a text editor like Notepad? On Fri, Nov 4, 2011 at 7:59 AM, Torrent Girl moniqueb...@gmail.com wrote: Hi All. I need to give users the ability to download a CSV and TAB file. While I found a neat little function to create a CVS file ( http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am having a problem with dates values. Here is my date: 6/20/2009 7:15:03 PM but in the file it shows up as this: 15:03.0 Also, any tips/resources on how to create a TAB file? I can't find anything. Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Create CSV and TAB docs
On 11/4/2011 8:59 AM, Torrent Girl wrote: Hi All. I need to give users the ability to download a CSV and TAB file. While I found a neat little function to create a CVS file (http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am having a problem with dates values. Here is my date: 6/20/2009 7:15:03 PM but in the file it shows up as this: 15:03.0 In Excel, highlight the column and format it to date. Alternatively, save as a txt file and then open in Excel using the filter. You can set each column to proper format that way so leading zeros on number-text fields are preserved. -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Google+: https://plus.google.com/117357905892731200369 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Dynamic Tabs
Hi All, I'm attempting to add any number of a specific tab within a tab environment that is itself dynamic upon initial build. The 2 problems I'm having: 1) If I add a new tab and then a second, the imported content file gets duplicated within the second addition's tab space and periodically, the first tab added will not be clickable. 2) I need to dynamically give the input fields being imported from tabTest130_2.cfm their own unique ids and cannot figure out how to do this. I managed to assign a unique id to the tablayoutarea I created which uses the javascript function handleTab(). Maybe the cflayout and cflayoutarea is the wrong tool to use here, but I've not found any examples of other tools that would allow me to do the same thing either. Any help, suggestions or even being pointed in a new direction is greatly appreciated. Thanks, Randy Here is the code: TabExample2.cfm (this is the main form) html head titleTab Example/title script type=text/javascript function handleTab(tcID) { var tabVal = parseFloat(document.getElementById('myVar' + tcID).value); document.getElementById('myVar' + tcID).value = tabVal + 1; var divNode = document.getElementById('loa130_ZZZ_' + tcID); divNode.id = 'loa130_' + tabVal + '_' + tcID; } /script /head body cfform name=TaxCalc cflayout type=border name=myLayout cflayoutarea name=header position=topHeader information goes here/cflayoutarea cflayoutarea name=masterArea position=center cflayout name=masterTab type=tab cfloop from=2008 to=2010 index=i cfoutput cflayoutarea name=loa#i# title=#i# input type=hidden name=myVar#i# id=myVar#i# value=4 cfset myVar = 4 input type=button name=Add_130_#i# value=Add Form 130 onclick=ColdFusion.Layout.createTab('lo130_#i#','loa130_ZZZ_#i#','Location','tabTest130_2.cfm?j=#myVar#;TC_ID=#i#');handleTab(#i#); style=float:right; cflayout name=lo#i# type=tabbr / cflayoutarea name=loa1040_#i# title=Form 1040 Adjustments amp; Changes cflayout name=lo1040_#i# type=tabbr / cflayoutarea name=loa1040_1_#i# title=Exemptions Miscbr /#i# Exemptions Misc goes here/cflayoutarea cflayoutarea name=loa1040_2_#i# title=Changesbr /#i# Changes goes here/cflayoutarea cflayoutarea name=loa1040_3_#i# title=Adjustmentsbr /#i# Adjustments goes here/cflayoutarea cflayoutarea name=loa1040_4_#i# title=Other Changesbr /#i# Other Changes goes here/cflayoutarea cflayoutarea name=loa1040_5_#i# title=Contributionsbr /#i# Contributions goes here/cflayoutarea cflayoutarea name=loa1040_6_#i# title=Creditsbr /#i# Credits goes here/cflayoutarea /cflayout /cflayoutarea cflayoutarea name=loa126_#i# title=Form 126br /#i# Form 126 goes here/cflayoutarea cflayoutarea name=loa130_#i# title=Form 130 cflayout name=lo130_#i# type=tab cflayoutarea name=loa130_1_#i# title=Location 1br /#i# Location 1 goes here/cflayoutarea cflayoutarea name=loa130_2_#i# title=Location 2br /#i# Location 2 goes here/cflayoutarea cflayoutarea name=loa130_3_#i# title=Location 3br /#i# Location 3 goes here/cflayoutarea /cflayout
Re: Dynamic Tabs
I presume that you are using the same loop iteration to create more than one tab thus why the duplicate id's ? The easy way to generate unique ID's is to use CreateUUID() function. so you could just do this cflayout name=#CreateUUID# type=tab -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com : ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine sky ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Stripping out special characters...
I'd like to create a function that reviews a string and replaces all characters that aren't alphanumeric, or a dash or underscore. These will generally be short strings, and the function will be used for things like creating friendly page names from navigation text. Some characters would be converted to specific things (spaces to dashes or underscores, ampersands to the word and, etc. ) - that's the easy part because I can look for specific ASCII characters and use Replace() - but most will simply be dropped. For example: navigation text examples = How Do I Join?* The Final Word RD desired converted strings = How-Do-I-Join The-Final-Word R-and-D I thought about looping the strings as a list using spaces as a delimiter, then replacing anything that isn't in a specific ascii range (the letters and numbers), but since I have to look at every character in the string that doesn't work. There's got to be an easier way than doing a replace for every possible ASCII, right? Thanks in advance for any input! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Access with Unicode error
I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Stripping out special characters...
rereplace(string, [^a-zA-Z0-9-_], , all) On Fri, Nov 4, 2011 at 9:30 AM, Dennis Belmont membersh...@dennisbelmont.com wrote: I'd like to create a function that reviews a string and replaces all characters that aren't alphanumeric, or a dash or underscore. These will generally be short strings, and the function will be used for things like creating friendly page names from navigation text. Some characters would be converted to specific things (spaces to dashes or underscores, ampersands to the word and, etc. ) - that's the easy part because I can look for specific ASCII characters and use Replace() - but most will simply be dropped. For example: navigation text examples = How Do I Join?* The Final Word RD desired converted strings = How-Do-I-Join The-Final-Word R-and-D I thought about looping the strings as a list using spaces as a delimiter, then replacing anything that isn't in a specific ascii range (the letters and numbers), but since I have to look at every character in the string that doesn't work. There's got to be an easier way than doing a replace for every possible ASCII, right? Thanks in advance for any input! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Stripping out special characters...
I should have read the rest of your question.. I think you'll have to do it multiple times since it's not a blanket replace.. but maybe someone else has another idea On Fri, Nov 4, 2011 at 9:34 AM, Greg Morphis gmorp...@gmail.com wrote: rereplace(string, [^a-zA-Z0-9-_], , all) On Fri, Nov 4, 2011 at 9:30 AM, Dennis Belmont membersh...@dennisbelmont.com wrote: I'd like to create a function that reviews a string and replaces all characters that aren't alphanumeric, or a dash or underscore. These will generally be short strings, and the function will be used for things like creating friendly page names from navigation text. Some characters would be converted to specific things (spaces to dashes or underscores, ampersands to the word and, etc. ) - that's the easy part because I can look for specific ASCII characters and use Replace() - but most will simply be dropped. For example: navigation text examples = How Do I Join?* The Final Word RD desired converted strings = How-Do-I-Join The-Final-Word R-and-D I thought about looping the strings as a list using spaces as a delimiter, then replacing anything that isn't in a specific ascii range (the letters and numbers), but since I have to look at every character in the string that doesn't work. There's got to be an easier way than doing a replace for every possible ASCII, right? Thanks in advance for any input! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic Tabs
Hi Russ, Yes, I could have anywhere from 1 to n years (3 in this example) and from 0 to n of the Form 130 within each of those years. I'll take a look at using the CreateUUID approach but I'm not sure that it's not going to leave me in the same situation. Wouldn't CF would create the UUID when the form first loaded and then it would be unique only at that point? I need it to generate a new unique ID with every click of the Add 130 button. Thanks, Randy I presume that you are using the same loop iteration to create more than one tab thus why the duplicate id's ? The easy way to generate unique ID's is to use CreateUUID() function. so you could just do this cflayout name=#CreateUUID# type=tab -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com : ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine sky ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348435 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic Tabs
ah ok so your doing it from JS. In which case just have a counter that increments every time you click the button and add that counter to your tabID, then it will be unique. Russ On Fri, Nov 4, 2011 at 3:57 PM, Randy Robinson rlrobin...@sartellgroup.com wrote: Hi Russ, Yes, I could have anywhere from 1 to n years (3 in this example) and from 0 to n of the Form 130 within each of those years. I'll take a look at using the CreateUUID approach but I'm not sure that it's not going to leave me in the same situation. Wouldn't CF would create the UUID when the form first loaded and then it would be unique only at that point? I need it to generate a new unique ID with every click of the Add 130 button. Thanks, Randy I presume that you are using the same loop iteration to create more than one tab thus why the duplicate id's ? The easy way to generate unique ID's is to use CreateUUID() function. so you could just do this cflayout name=#CreateUUID# type=tab -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com : ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine sky ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) fusion-reactor for LAMP ?
Hi list, does anybody know of a system like fusion-reactor but for LAMP-servers ? Uwe ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) fusion-reactor for LAMP ?
indeed, try this http://newrelic.com/ -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com : ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine sky ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic Tabs
Russ, It appears they're unique because I can continue to click. My problem in verifying them is that they are in memory only - View Source doesn't show them. I'm not sure that they are really being kept even. A colleague of mine suggested that each additional request for a form 130 may actually be overwritten in memory by the new one hence the inability to click on a previous button. Is there a way to dump what's being stored in memory the check this? Randy ah ok so your doing it from JS. In which case just have a counter that increments every time you click the button and add that counter to your tabID, then it will be unique. Russ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
Where is this driver at? I just searched the C, D and E drives and came up empty handed. On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote: yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic Tabs
ok can you repost the code as I have deleted the previous emails already On Fri, Nov 4, 2011 at 4:29 PM, Randy Robinson rlrobin...@sartellgroup.com wrote: Russ, It appears they're unique because I can continue to click. My problem in verifying them is that they are in memory only - View Source doesn't show them. I'm not sure that they are really being kept even. A colleague of mine suggested that each additional request for a form 130 may actually be overwritten in memory by the new one hence the inability to click on a previous button. Is there a way to dump what's being stored in memory the check this? Randy ah ok so your doing it from JS. In which case just have a counter that increments every time you click the button and add that counter to your tabID, then it will be unique. Russ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dynamic Tabs
Here is the code: TabExample2.cfm (this is the main form) html head titleTab Example/title script type=text/javascript function handleTab(tcID) { var tabVal = parseFloat(document.getElementById('myVar' + tcID).value); document.getElementById('myVar' + tcID).value = tabVal + 1; var divNode = document.getElementById('loa130_ZZZ_' + tcID); divNode.id = 'loa130_' + tabVal + '_' + tcID; } /script /head body cfform name=TaxCalc cflayout type=border name=myLayout cflayoutarea name=header position=topHeader information goes here/cflayoutarea cflayoutarea name=masterArea position=center cflayout name=masterTab type=tab cfloop from=2008 to=2010 index=i cfoutput cflayoutarea name=loa#i# title=#i# input type=hidden name=myVar#i# id=myVar#i# value=4 cfset myVar = 4 input type=button name=Add_130_#i# value=Add Form 130 onclick=ColdFusion.Layout.createTab('lo130_#i#','loa130_ZZZ_#i#','Location','tabTest130_2.cfm?j=#myVar#;TC_ID=#i#');handleTab(#i#); style=float:right; cflayout name=lo#i# type=tabbr / cflayoutarea name=loa1040_#i# title=Form 1040 Adjustments amp; Changes cflayout name=lo1040_#i# type=tabbr / cflayoutarea name=loa1040_1_#i# title=Exemptions Miscbr /#i# Exemptions Misc goes here/cflayoutarea cflayoutarea name=loa1040_2_#i# title=Changesbr /#i# Changes goes here/cflayoutarea cflayoutarea name=loa1040_3_#i# title=Adjustmentsbr /#i# Adjustments goes here/cflayoutarea cflayoutarea name=loa1040_4_#i# title=Other Changesbr /#i# Other Changes goes here/cflayoutarea cflayoutarea name=loa1040_5_#i# title=Contributionsbr /#i# Contributions goes here/cflayoutarea cflayoutarea name=loa1040_6_#i# title=Creditsbr /#i# Credits goes here/cflayoutarea /cflayout /cflayoutarea cflayoutarea name=loa126_#i# title=Form 126br /#i# Form 126 goes here/cflayoutarea cflayoutarea name=loa130_#i# title=Form 130 cflayout name=lo130_#i# type=tab cflayoutarea name=loa130_1_#i# title=Location 1br /#i# Location 1 goes here/cflayoutarea cflayoutarea name=loa130_2_#i# title=Location 2br /#i# Location 2 goes here/cflayoutarea cflayoutarea name=loa130_3_#i# title=Location 3br /#i# Location 3 goes here/cflayoutarea /cflayout /cflayoutarea cflayoutarea name=loa2210_#i# title=Form 2210br /#i# Form 2210 goes here/cflayoutarea cflayoutarea name=loaPA_#i# title=Paymentsbr /#i# Payments goes here/cflayoutarea cflayoutarea name=loaAD_#i# title=Activity Detailbr /#i# Activity Detail goes here/cflayoutarea /cflayout /cflayoutarea /cfoutput /cfloop cflayoutarea title=Summary name=loaSummarybr
cfimage issue with dpi
I have an app that uploads and converts images to the appropriate sizes for website display. If the image being uploaded is 72dpi, it works fine. If the image is 97 dpi or up, the image is processed appropriately and saved as 72 dpi. Yet, whole the process works, it throws an error. The error is that the cfquery that directly follows says it times out. I have tested it with file sizes and different file types. The only thing in common is the file size. Anyone have a clue what could be going on. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348445 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
izmado.jar is the file you want On Fri, Nov 4, 2011 at 4:32 PM, Greg Morphis gmorp...@gmail.com wrote: Where is this driver at? I just searched the C, D and E drives and came up empty handed. On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote: yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion Hosting Recommendations
I am mostly a lurker on this list, but this has to be about the most common question that I see asked. So, I decided to create a web site to help answer it. The first thing about best is best for what, so the home page allows you to search based on several criteria for what you need in a site (databases, space, needed features, etc) and only returns hosting plans that meet your criteria. http://www.cfwebhosting.com/ I do need help, however. Currently only 25 plans across 9 hosting companies are listed. I would love for the list to be more extensive. So, spread the word to any hosting companies that you know and get them to add their plans to the site (it's free). I also don't have any reviews yet. If you see a hosting company that you have used, I would love to get reviews up. If the company you have used isn't listed, maybe you could convince them to sign up. The site is just getting started, so if you have any feedback let me know. Maybe next time someone asks for hosting recommendations, this site will make for a useful answer. Thanks! Steve Bryant www.bryantwebconsulting.com/blog/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
Not sure if that worked or if a simple service restart worked but it's working now. The files were all the same file size and same dates as well, but either way. Thanks Russ! On Fri, Nov 4, 2011 at 1:03 PM, Russ Michaels r...@michaels.me.uk wrote: izmado.jar is the file you want On Fri, Nov 4, 2011 at 4:32 PM, Greg Morphis gmorp...@gmail.com wrote: Where is this driver at? I just searched the C, D and E drives and came up empty handed. On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote: yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
unless it is very low traffic DB, i'd still upsize it to MSSQL On Fri, Nov 4, 2011 at 7:04 PM, Greg Morphis gmorp...@gmail.com wrote: Not sure if that worked or if a simple service restart worked but it's working now. The files were all the same file size and same dates as well, but either way. Thanks Russ! On Fri, Nov 4, 2011 at 1:03 PM, Russ Michaels r...@michaels.me.uk wrote: izmado.jar is the file you want On Fri, Nov 4, 2011 at 4:32 PM, Greg Morphis gmorp...@gmail.com wrote: Where is this driver at? I just searched the C, D and E drives and came up empty handed. On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote: yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
Low traffic and it wont be used for long, we have an Oracle database if I ever wanted to port it over. Thanks! On Fri, Nov 4, 2011 at 2:14 PM, Russ Michaels r...@michaels.me.uk wrote: unless it is very low traffic DB, i'd still upsize it to MSSQL On Fri, Nov 4, 2011 at 7:04 PM, Greg Morphis gmorp...@gmail.com wrote: Not sure if that worked or if a simple service restart worked but it's working now. The files were all the same file size and same dates as well, but either way. Thanks Russ! On Fri, Nov 4, 2011 at 1:03 PM, Russ Michaels r...@michaels.me.uk wrote: izmado.jar is the file you want On Fri, Nov 4, 2011 at 4:32 PM, Greg Morphis gmorp...@gmail.com wrote: Where is this driver at? I just searched the C, D and E drives and came up empty handed. On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote: yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Hosting Recommendations
I would like to suggest that you put some checks in place to stop hosts from reviewing themselves or posting bad reviews of the competition, as some hosts are really bad for this. require all reviewers to complete some basic details (name, address, email,website hosted with this host, time with host), and send out a validation link via email. Ideally the email address should be using the domain they listed as their website. record the hosts IP address when they sign up and do not allow any reviews from the IP or from the domain of any listed host. that should put a stop to most of the dodgy reviews :-) On Fri, Nov 4, 2011 at 7:01 PM, Steve Bryant st...@bryantwebconsulting.com wrote: I am mostly a lurker on this list, but this has to be about the most common question that I see asked. So, I decided to create a web site to help answer it. The first thing about best is best for what, so the home page allows you to search based on several criteria for what you need in a site (databases, space, needed features, etc) and only returns hosting plans that meet your criteria. http://www.cfwebhosting.com/ I do need help, however. Currently only 25 plans across 9 hosting companies are listed. I would love for the list to be more extensive. So, spread the word to any hosting companies that you know and get them to add their plans to the site (it's free). I also don't have any reviews yet. If you see a hosting company that you have used, I would love to get reviews up. If the company you have used isn't listed, maybe you could convince them to sign up. The site is just getting started, so if you have any feedback let me know. Maybe next time someone asks for hosting recommendations, this site will make for a useful answer. Thanks! Steve Bryant www.bryantwebconsulting.com/blog/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfimage issue with dpi
If the image being uploaded is 72dpi, it works fine. If the image is 97 dpi or up, the image is processed appropriately and saved as 72 dpi. I don't know if it's what's causing your error, but if it's for publishing on the web, what really counts is the width in pixels. The dots per inch is irrelevant in a virtual image, since it has no inch. You may have a 72dpi image 2000 pixels wide and a 300dpi image only 300 pixels wide. You would have a better control using the width of the image. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 Flash Grid problem
Hi, I've inherited a CF8 Flash grid in that is (now) just hanging and not retrieving any data. It does use an onLoad Actionscript event, which I thought wasn't allowed in a Flash grid and I thought this might be at the root of it but it has been demonstrated on the original developer's machine. It just doesn't behave on mine, or on our test or live environments. Does anybody have any ideas about where I should look next? I can post snippets of code or settings if required. Any help would be greatly appreciated. Thanks Paul J ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Running CF on 2008
I am having an odd issue where we installed CF9 64 bit on Windows 2008 server and we have our code physically located on the d drive. When I set up the site in IIS, I point the home directory to the code on the D drive and I get an IIS 500 error. I get the same results with CF Admin when it is on the D drive. CF Admin works fine when i point it to the code in C:\inetpub\wwwroot\cfide\administrator. Any idea why IIS 7 does not like having the code on the D drive? I haven't seen this issue before and I am almost positive I have have dealt with setups like this where the code is on drive other than the C drive...any ideas? i am pretty stumped. Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Running CF on 2008
Nothing to do with drive D or C - more likely it has to do with permissions on those drives or folders. What user is your CF and/or IIS running as? (the services run as a user - even if it's just network service or system). -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: Friday, November 04, 2011 5:30 PM To: cf-talk Subject: Running CF on 2008 I am having an odd issue where we installed CF9 64 bit on Windows 2008 server and we have our code physically located on the d drive. When I set up the site in IIS, I point the home directory to the code on the D drive and I get an IIS 500 error. I get the same results with CF Admin when it is on the D drive. CF Admin works fine when i point it to the code in C:\inetpub\wwwroot\cfide\administrator. Any idea why IIS 7 does not like having the code on the D drive? I haven't seen this issue before and I am almost positive I have have dealt with setups like this where the code is on drive other than the C drive...any ideas? i am pretty stumped. Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348455 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Running CF on 2008
It is using the system user and the folders give full control permissions to the system user on those folders all the way back to the root of the d drive... I get a 500 error from IIS...only if I access files on the D drive. I had the same problem on my Win 7 Ultimate box at home and the only thing I found to solve it was to put the files in the wwwroot on the C drive. It shouldn't matter where the files are at as long as they are included via IIS and the permissions are OK. Would permissions issues cause a 500 or a 401? Nothing to do with drive D or C - more likely it has to do with permissions on those drives or folders. What user is your CF and/or IIS running as? (the services run as a user - even if it's just network service or system). -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger I am having an odd issue where we installed CF9 64 bit on Windows 2008 server and we have our code physically located on the d drive. When I set up the site in IIS, I point the home directory to the code on the D drive and I get an IIS 500 error. I get the same results with CF Admin when it is on the D drive. CF Admin works fine when i point it to the code in C:\inetpub\wwwroot\cfide\administrator. Any idea why IIS 7 does not like having the code on the D drive? I haven't seen this issue before and I am almost positive I have have dealt with setups like this where the code is on drive other than the C drive...any ideas? i am pretty stumped. Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348456 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Running CF on 2008
One more thing... You cannot set the root to D:\ or C:\ .. it has to be a sub folder as in D:\webs or something... anything but the actual root of a drive Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: Friday, November 04, 2011 6:01 PM To: cf-talk Subject: Re: Running CF on 2008 It is using the system user and the folders give full control permissions to the system user on those folders all the way back to the root of the d drive... I get a 500 error from IIS...only if I access files on the D drive. I had the same problem on my Win 7 Ultimate box at home and the only thing I found to solve it was to put the files in the wwwroot on the C drive. It shouldn't matter where the files are at as long as they are included via IIS and the permissions are OK. Would permissions issues cause a 500 or a 401? Nothing to do with drive D or C - more likely it has to do with permissions on those drives or folders. What user is your CF and/or IIS running as? (the services run as a user - even if it's just network service or system). -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger I am having an odd issue where we installed CF9 64 bit on Windows 2008 server and we have our code physically located on the d drive. When I set up the site in IIS, I point the home directory to the code on the D drive and I get an IIS 500 error. I get the same results with CF Admin when it is on the D drive. CF Admin works fine when i point it to the code in C:\inetpub\wwwroot\cfide\administrator. Any idea why IIS 7 does not like having the code on the D drive? I haven't seen this issue before and I am almost positive I have have dealt with setups like this where the code is on drive other than the C drive...any ideas? i am pretty stumped. Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Running CF on 2008
It's in an inetpub/wwwroot...and a few more folders down... One more thing... You cannot set the root to D:\ or C:\ .. it has to be a sub folder as in D:\webs or something... anything but the actual root of a drive Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger It is using the system user and the folders give full control permissions to the system user on those folders all the way back to the root of the d drive... I get a 500 error from IIS...only if I access files on the D drive. I had the same problem on my Win 7 Ultimate box at home and the only thing I found to solve it was to put the files in the wwwroot on the C drive. It shouldn't matter where the files are at as long as they are included via IIS and the permissions are OK. Would permissions issues cause a 500 or a 401? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfimage issue with dpi
Is it a page execution timeout or some database query execution timeout? -Original Message- From: David Moore [mailto:dgmoor...@hotmail.com] Sent: Friday, November 04, 2011 9:01 PM To: cf-talk Subject: cfimage issue with dpi I have an app that uploads and converts images to the appropriate sizes for website display. If the image being uploaded is 72dpi, it works fine. If the image is 97 dpi or up, the image is processed appropriately and saved as 72 dpi. Yet, whole the process works, it throws an error. The error is that the cfquery that directly follows says it times out. I have tested it with file sizes and different file types. The only thing in common is the file size. Anyone have a clue what could be going on. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Running CF on 2008
make sure the IIS_IUSRS groups has read permissions on that folder. On Fri, Nov 4, 2011 at 11:07 PM, Eric Roberts ow...@threeravensconsulting.com wrote: It's in an inetpub/wwwroot...and a few more folders down... One more thing... You cannot set the root to D:\ or C:\ .. it has to be a sub folder as in D:\webs or something... anything but the actual root of a drive Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger It is using the system user and the folders give full control permissions to the system user on those folders all the way back to the root of the d drive... I get a 500 error from IIS...only if I access files on the D drive. I had the same problem on my Win 7 Ultimate box at home and the only thing I found to solve it was to put the files in the wwwroot on the C drive. It shouldn't matter where the files are at as long as they are included via IIS and the permissions are OK. Would permissions issues cause a 500 or a 401? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Flash Grid problem
do you have the CFIDE virtual directory mapped on the site ? On Fri, Nov 4, 2011 at 8:15 PM, Paul James p...@stephandpaul.plus.com wrote: Hi, I've inherited a CF8 Flash grid in that is (now) just hanging and not retrieving any data. It does use an onLoad Actionscript event, which I thought wasn't allowed in a Flash grid and I thought this might be at the root of it but it has been demonstrated on the original developer's machine. It just doesn't behave on mine, or on our test or live environments. Does anybody have any ideas about where I should look next? I can post snippets of code or settings if required. Any help would be greatly appreciated. Thanks Paul J ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Hosting Recommendations
Russ, That is certainly a concern and I do have some steps in place to combat that. At the same time, I am really torn with how to balance fraud checks with making it painless to post a review. Anyone else have any thoughts on this? (more thoughts from you, Russ, are welcome as well of course) Thanks, Steve I would like to suggest that you put some checks in place to stop hosts from reviewing themselves or posting bad reviews of the competition, as some hosts are really bad for this. require all reviewers to complete some basic details (name, address, email,website hosted with this host, time with host), and send out a validation link via email. Ideally the email address should be using the domain they listed as their website. record the hosts IP address when they sign up and do not allow any reviews from the IP or from the domain of any listed host. that should put a stop to most of the dodgy reviews :-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348462 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Hosting Recommendations
Sites like Trip Adviser have the best model. Every review is held in abeyance until a member of the staff approves it On Fri, Nov 4, 2011 at 6:44 PM, Steve Bryant st...@bryantwebconsulting.comwrote: Russ, That is certainly a concern and I do have some steps in place to combat that. At the same time, I am really torn with how to balance fraud checks with making it painless to post a review. Anyone else have any thoughts on this? (more thoughts from you, Russ, are welcome as well of course) Thanks, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348463 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Flash Grid problem
What browser did you test on? Current version of Safari does not load Flash forms properly. Isidro On 11/4/11 5:04 PM, Russ Michaels r...@michaels.me.uk wrote: do you have the CFIDE virtual directory mapped on the site ? On Fri, Nov 4, 2011 at 8:15 PM, Paul James p...@stephandpaul.plus.com wrote: Hi, I've inherited a CF8 Flash grid in that is (now) just hanging and not retrieving any data. It does use an onLoad Actionscript event, which I thought wasn't allowed in a Flash grid and I thought this might be at the root of it but it has been demonstrated on the original developer's machine. It just doesn't behave on mine, or on our test or live environments. Does anybody have any ideas about where I should look next? I can post snippets of code or settings if required. Any help would be greatly appreciated. Thanks Paul J ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Create CSV and TAB docs
Are you seeing that value in Excel? What do you see if you open the CSV with a text editor like Notepad? yes when I open it in excel. When I select the column in excel I see the true value. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Create CSV and TAB docs
On 11/4/2011 8:59 AM, Torrent Girl wrote: Hi All. I need to give users the ability to download a CSV and TAB file. While I found a neat little function to create a CVS file (http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1197) I am having a problem with dates values. Here is my date: 6/20/2009 7:15:03 PM but in the file it shows up as this: 15:03.0 In Excel, highlight the column and format it to date. Alternatively, save as a txt file and then open in Excel using the filter. You can set each column to proper format that way so leading zeros on number-text fields are preserved. the problem is the file will be created on the fly by remote users who will import the data and won't have time to manipulate it by hand. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm