RE: (I guess) Local App
Dick, I think the technology is pretty nifty and I didn't mean to suggest that it couldn't work.For many of the reasons Dave gave and my personal experience with access I thought that doing something quick and dirty even using access wizards would be an easier solution. Dave, Thanks for defending my position so eloquently.I had gone home for the evening. Greg, good luck with your project. Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 12:23 AM To: CF-Talk Subject: RE: (I guess) Local App Just to throw HTA back into the mix - you might want to check it out. One of the features is that an HTA runs with application privileges, not web-page privileges (even tho' the HTA is just a web page).This means that you can use _javascript_ to access any com object on the system.In your case that means you can create an HTML based form that would use the Excel com object to automatically create and fill out the Excel sheet (or create an XML file or whatever). Jim Davis _ From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 11:06 PM To: CF-Talk Subject: Re: (I guess) Local App I posted to a CF list to get ideas, the admin section will be entirely CF and Oracle. I posted to get ideas on how to gather their input while not connected to the internet or intranet and then upload it to Oracle once they get back and can upload their input. This wasnt posted to start a forum war or anything heh.. I appreciate all your inputs and it gives me a good idea of where to start. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
Thanks again for all the input people. If nothing else it lets me broaden my horizon with a few new skills. On Thu, 9 Sep 2004 10:38:40 -0400, Patrick McGeehan [EMAIL PROTECTED] wrote: Dick, I think the technology is pretty nifty and I didn't mean to suggest that it couldn't work.For many of the reasons Dave gave and my personal experience with access I thought that doing something quick and dirty even using access wizards would be an easier solution. Dave, Thanks for defending my position so eloquently.I had gone home for the evening. Greg, good luck with your project. Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 09, 2004 12:23 AM To: CF-Talk Subject: RE: (I guess) Local App Just to throw HTA back into the mix - you might want to check it out. One of the features is that an HTA runs with application privileges, not web-page privileges (even tho' the HTA is just a web page).This means that you can use _javascript_ to access any com object on the system.In your case that means you can create an HTML based form that would use the Excel com object to automatically create and fill out the Excel sheet (or create an XML file or whatever). Jim Davis _ From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 11:06 PM To: CF-Talk Subject: Re: (I guess) Local App I posted to a CF list to get ideas, the admin section will be entirely CF and Oracle. I posted to get ideas on how to gather their input while not connected to the internet or intranet and then upload it to Oracle once they get back and can upload their input. This wasnt posted to start a forum war or anything heh.. I appreciate all your inputs and it gives me a good idea of where to start. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
Honest question -- no hidden agenda: Can you use Flash Remoting without being connected to the Internet? No, but you can use it when you are, and use local shared objects when you aren't. This would be roughly analogous to the Pocket PC example I mentioned, using SQL Server CE for local storage and using web services to update the remote database when the network is available. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
But, Dave, the original poster was looking for a programming solution, quote: Im guessing my only option would be to build something in Java, VB, ASP or something CFML can be the something! Well, sure! X86 assembly could be the something, too, but I wouldn't recommend it! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: (I guess) Local App
I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
could use Flash as well Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
You could do it in Flash - and store the data locally and upload when connected. We did that back with Flash 3, and I'm sure it's a lot cleaner now. - Original Message - From: Greg Morphis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 1:54 PM Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
I know nada about Flash heh On Wed, 8 Sep 2004 14:07:32 -0500, Deanna Schneider [EMAIL PROTECTED] wrote: You could do it in Flash - and store the data locally and upload when connected. We did that back with Flash 3, and I'm sure it's a lot cleaner now. - Original Message - From: Greg Morphis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 1:54 PM Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: (I guess) Local App
You Betchum RR! How about CFanywhere! http://67.124.145.42/CFanywhereDocs/CFAnywhere.html If you need a more robust db, I suggest cloudscape. Dick On Sep 8, 2004, at 11:54 AM, Greg Morphis wrote: I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
Is this on a Pocket PC? We use Flash and Flash Remoting on a PPC and then when we sync the PPC up the following day, the data is loaded into our Oracle database thru a CF page. The PPC while in use collecting data is not connected to our intranet and is only connected while sync-ing up. Mario -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 3:01 PM To: CF-Talk Subject: Re: (I guess) Local App could use Flash as well Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
How complex is the data being collected?If not too complex, why reinvent the wheel, have them collect the data in excel, and read the sheets in when they get back.Create a template and give it to them and you are done.No programming and no training (most people can work excel). Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 3:27 PM To: CF-Talk Subject: Re: (I guess) Local App I know nada about Flash heh On Wed, 8 Sep 2004 14:07:32 -0500, Deanna Schneider [EMAIL PROTECTED] wrote: You could do it in Flash - and store the data locally and upload when connected. We did that back with Flash 3, and I'm sure it's a lot cleaner now. - Original Message - From: Greg Morphis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 1:54 PM Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. On what sort of platform will this application run? I've been playing around with this kind of intermittently connected application on the Pocket PC platform, using SQL Server CE for local storage and using either web services or SQL Server database synchronization for network storage. This kind of thing is pretty easy to build using Windows Forms and the .NET Framework. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
No it's a laptop. I'm actually considering that option Patrick.. They want to be able to create custom templates.. I suppose an admin can do this with CF and then output the data to a csv file.. The only problem will be taking that data and knowing how to transfer it to Oracle. On Wed, 8 Sep 2004 15:33:08 -0400, Patrick McGeehan [EMAIL PROTECTED] wrote: How complex is the data being collected?If not too complex, why reinvent the wheel, have them collect the data in excel, and read the sheets in when they get back.Create a template and give it to them and you are done.No programming and no training (most people can work excel). Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 3:27 PM To: CF-Talk Subject: Re: (I guess) Local App I know nada about Flash heh On Wed, 8 Sep 2004 14:07:32 -0500, Deanna Schneider [EMAIL PROTECTED] wrote: You could do it in Flash - and store the data locally and upload when connected. We did that back with Flash 3, and I'm sure it's a lot cleaner now. - Original Message - From: Greg Morphis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 1:54 PM Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
Windows... Win2K most likely On Wed, 8 Sep 2004 14:43:38 -0500, Greg Morphis [EMAIL PROTECTED] wrote: No it's a laptop. I'm actually considering that option Patrick.. They want to be able to create custom templates.. I suppose an admin can do this with CF and then output the data to a csv file.. The only problem will be taking that data and knowing how to transfer it to Oracle. On Wed, 8 Sep 2004 15:33:08 -0400, Patrick McGeehan [EMAIL PROTECTED] wrote: How complex is the data being collected?If not too complex, why reinvent the wheel, have them collect the data in excel, and read the sheets in when they get back.Create a template and give it to them and you are done.No programming and no training (most people can work excel). Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 3:27 PM To: CF-Talk Subject: Re: (I guess) Local App I know nada about Flash heh On Wed, 8 Sep 2004 14:07:32 -0500, Deanna Schneider [EMAIL PROTECTED] wrote: You could do it in Flash - and store the data locally and upload when connected. We did that back with Flash 3, and I'm sure it's a lot cleaner now. - Original Message - From: Greg Morphis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 1:54 PM Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
I've become a big fan of HTA if you're on Windows.You can build full client-side applications using only HTML and _javascript_. Look it up on msdn.micrsoft.com Jim Davis From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 2:55 PM To: CF-Talk Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: (I guess) Local App
Or just build an access application. The forms for the technicians to submit data, reports to see the data. Then of course you can run the data into the MSSQL DB (or MSDE) when they're back in the office and do whatever you want with the data there. Greg - Original Message - From: Dick Applebaum [EMAIL PROTECTED] Date: Wed, 8 Sep 2004 12:29:40 -0700 Subject: Re: OT: (I guess) Local App To: CF-Talk [EMAIL PROTECTED] You Betchum RR! How about CFanywhere! http://67.124.145.42/CFanywhereDocs/CFAnywhere.html If you need a more robust db, I suggest cloudscape. Dick On Sep 8, 2004, at 11:54 AM, Greg Morphis wrote: I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
http://home.alltel.net/omen/mot.xls here's a sample of one of the templates.. On Wed, 8 Sep 2004 15:49:44 -0400, Jim Davis [EMAIL PROTECTED] wrote: I've become a big fan of HTA if you're on Windows.You can build full client-side applications using only HTML and _javascript_. Look it up on msdn.micrsoft.com Jim Davis From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 2:55 PM To: CF-Talk Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
On Sep 8, 2004, at 12:43 PM, Greg Morphis wrote: No it's a laptop. I'm actually considering that option Patrick.. They want to be able to create custom templates.. I suppose an admin can do this with CF and then output the data to a csv file.. The only problem will be taking that data and knowing how to transfer it to Oracle. Why not CFAnywhere? How many users will you have? You write the app in CF, providing a customized, application-specific GUI, using a browser -- just as you do now for any web app. Your users can run it on the desktop store the data in a local db (with no connection to the Internet) Using, for example; BDJ2ee, Apache, Jetty, Cloudscape * You can make the entire app double-clickable (all of the above)just like any desktop app -- no necessity to type commands or run scripts from the command line. It doesn't cost anything for any of the software* It takes a very small footprint runs quite efficiently (prolly smaller than Excel) When the Internet is available, the user clicks a button the CF template (you write) xfers the data from the desktop db to Oracle, You have all the CF programming capabilities, you use for any other CF app(it's CFML, baby!) You have a single, familiar, language with which to write and maintain the programs, You have the reliability, ease of use, etc. to which you are accustomed. It is easy to deploy via download or CD. * Everything except CFMX/BD is free, open-source, proven redistributable. You will need to get permission of the mfgr to redistro CFMX or BD -- lacking that you must dl install a free trial version on each user's system, Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
The cfanywhere stuff looks cool but seems like a bit of work to get that rolling and the template may be to much for an easily importable spreadsheet.I would personally go with a simple Access db with some user forms.Again, minimize reinventing the wheel... Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 4:23 PM To: CF-Talk Subject: Re: (I guess) Local App On Sep 8, 2004, at 12:43 PM, Greg Morphis wrote: No it's a laptop. I'm actually considering that option Patrick.. They want to be able to create custom templates.. I suppose an admin can do this with CF and then output the data to a csv file.. The only problem will be taking that data and knowing how to transfer it to Oracle. Why not CFAnywhere? How many users will you have? You write the app in CF, providing a customized, application-specific GUI, using a browser -- just as you do now for any web app. Your users can run it on the desktop store the data in a local db (with no connection to the Internet) Using, for example; BDJ2ee, Apache, Jetty, Cloudscape * You can make the entire app double-clickable (all of the above)just like any desktop app -- no necessity to type commands or run scripts from the command line. It doesn't cost anything for any of the software* It takes a very small footprint runs quite efficiently (prolly smaller than Excel) When the Internet is available, the user clicks a button the CF template (you write) xfers the data from the desktop db to Oracle, You have all the CF programming capabilities, you use for any other CF app(it's CFML, baby!) You have a single, familiar, language with which to write and maintain the programs, You have the reliability, ease of use, etc. to which you are accustomed. It is easy to deploy via download or CD. * Everything except CFMX/BD is free, open-source, proven redistributable. You will need to get permission of the mfgr to redistro CFMX or BD -- lacking that you must dl install a free trial version on each user's system, Dick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
Patrick I was suggesting that he write the data entry as a browser form (written in CF) Do you think it is easier to write/maintain forms in Access than in CFML/HTML? If you do want go with a spread sheet, it is easily imported with CFML The Excel/Access solution would require each user to: 1) Have a purchased copy of MS-OFfice 2) Interact with 2 programs (Excel Access) to collect the data 3) Interact with CF (or something) to get the data into Oracle. 4) Trouble shoot Access problems (locked db, etc) 5) Perform lengthly, somewhat complex installs of Office, OS Service Packs, and the apps. with CFAnywhere 1) The software is free 2) The user interacts with only the custom CF App 3) It is much easier to maintain (the users can just download the latest version or copy from CD) -- no installation necessary. FWIW, it takes less than an hour to get CFAnywhere running on your desktop (the first time). The CFAnywhere docs are a little dated and some things are over-explained.It is actually easier to do than to read. Try it! Subsequent installs of the entire package take a few moments to dload or copy to your hard drive. All the user sees is an application icon on the desktop. He double-clicks this icon and the application starts automatically. A few seconds later, he logs in (if necessary) and is entering data into a custom form The form can be SVG, HTML, DHTML, Flash, whatever. The user doesn't know or care that he is running CF and xyz database -- all he sees is a custom UI. Admittedly, I am biased, but I think an Excel/Access solution would be reinventing the wheel. And, IMO, CFAnywhere would be a superior solution -- in almost every way! Dick On Sep 8, 2004, at 1:52 PM, Patrick McGeehan wrote: The cfanywhere stuff looks cool but seems like a bit of work to get that rolling and the template may be to much for an easily importable spreadsheet. I would personally go with a simple Access db with some user forms. Again, minimize reinventing the wheel... Patrick McGeehan Applications Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
Do you think it is easier to write/maintain forms in Access than in CFML/HTML? No, but I don't really think it's harder, either. The Excel/Access solution would require each user to: 1) Have a purchased copy of MS-OFfice 2) Interact with 2 programs (Excel Access) to collect the data 3) Interact with CF (or something) to get the data into Oracle. 4) Trouble shoot Access problems (locked db, etc) 5) Perform lengthly, somewhat complex installs of Office, OS Service Packs, and the apps. If you just used Access, I don't think this is true. I'm pretty sure that all you'd need is the Jet database engine (installed by default on most Windows machines along with ODBC) and the actual Access database. You don't actually need Access itself, unless you want to build your own Access applications. It's pretty easy to build Access applications, and I've never seen a locked db problem within a single-user Access application, as long as the database itself is writeable. I think it would be pretty easy to have your Access application connect to Oracle using linked tables as needed. I don't see why an Excel spreadsheet would be needed, but if it's needed for an Access solution, it would presumably be needed for an HTML-based solution also. Admittedly, I am biased, but I think an Excel/Access solution would be reinventing the wheel. And, IMO, CFAnywhere would be a superior solution -- in almost every way! Since I'm diametrically opposed to your conclusion - I think it would be worse in almost every way - I'm curious about the reason for your bias. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
Hi Greg Have you heard of Coral? It's a CFML clone and looks like it might do what you want. Access only version looks inexpensive and no deployment fees. I am waiting for my free time to be delivered so that I can download and play with it some. http://www.pcaonline.com/coral/index.cfm HTH, Aaron - Original Message - From: Greg Morphis To: CF-Talk Sent: Thursday, September 09, 2004 4:54 AM Subject: OT: (I guess) Local App I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
On Sep 8, 2004, at 3:34 PM, Dave Watts wrote: Do you think it is easier to write/maintain forms in Access than in CFML/HTML? No, but I don't really think it's harder, either. The poser of the Access solution suggested that doing it with CFML (instead of Acess/Excel) would be reinventing the wheel. I suggest that it would be a wash. and I've never seen a locked db problem within a single-user Access application, as long as the database itself is writeable. I have seen this if Access or the system crashes -- I have seen quite a fewtimes and I have never used Access in a multi-user application. But, If Access is a mandate, you could use it as the db component of a Win-Only CF Desktop solution -- though there better dbs available. And, IMO, CFAnywhere would be a superior solution -- in almost every way! Since I'm diametrically opposed to your conclusion - I think it would be worse in almost every way - I'm curious about the reason for your bias. I'll quote the originator of the thread: I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. Since he posted to a CF list I assume that a major part of their installation is CF He suggests that because the application is not connected to the Internet, he must look at non-CF options to write the application. And it appears that these options (Java, VB, ASP or something) are less desirable to him than CFML (for whatever reasons). He does state that the online (Admin) section of the app would be in CF. So, here are the reasons for my bias: 1) Given the above, he *can* do the entire app in CF-- rather than clutter the implementation with other languages, GUIs, spreadsheets, or Access forms. 2) It is a cheaper, simpler, cleaner solution for the implementor and for the user (who uses the ubiquitous browser interface that MS so eloquently insisted is part of the win OS. 3) And, over time, as the application maintained/upgraded, it be deployed by the users with a simple download or copy/paste -- no other installation necessary by the users. 4) I think that this is a natural extension of CF's capabilities I suspect that you won't agree, but appears to me that a CFAnywhere solution is all upside with little downside risk. Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
To me it's a no-brainer! This is what Access is designed for. You could crank out some data entry forms and a database to store the data in a few hours. Each machine would NOT have to have a licensed copy of office to run the compiled application. I agree using an access db as a backend for a mutli-user web application isn't always a great deal, but Access makes brilliant stable single user desktop apps like this. And of course getting the data into the Oracle DB and using CF for admin/reporting would be straight-forward. Greg - Original Message - From: Dick Applebaum [EMAIL PROTECTED] Date: Wed, 8 Sep 2004 16:39:13 -0700 Subject: Re: (I guess) Local App To: CF-Talk [EMAIL PROTECTED] On Sep 8, 2004, at 3:34 PM, Dave Watts wrote: Do you think it is easier to write/maintain forms in Access than in CFML/HTML? No, but I don't really think it's harder, either. The poser of the Access solution suggested that doing it with CFML (instead of Acess/Excel) would be reinventing the wheel. I suggest that it would be a wash. and I've never seen a locked db problem within a single-user Access application, as long as the database itself is writeable. I have seen this if Access or the system crashes -- I have seen quite a fewtimes and I have never used Access in a multi-user application. But, If Access is a mandate, you could use it as the db component of a Win-Only CF Desktop solution -- though there better dbs available. And, IMO, CFAnywhere would be a superior solution -- in almost every way! Since I'm diametrically opposed to your conclusion - I think it would be worse in almost every way - I'm curious about the reason for your bias. I'll quote the originator of the thread: I've been tasked with building an app for engineers on the road to report how cell phones function. Unfortunately they wont be connected to the internet while on the road. So I'm guessing my only option would be to build something in Java, VB, ASP or something to record the data in an Access DB to upload at a later time to an Oracle DB. The Admin section would be in CF tieing to the Oracle DB. Does anyone have any other options, ideas or comments.. Anything is appreciated. Since he posted to a CF list I assume that a major part of their installation is CF He suggests that because the application is not connected to the Internet, he must look at non-CF options to write the application. And it appears that these options (Java, VB, ASP or something) are less desirable to him than CFML (for whatever reasons). He does state that the online (Admin) section of the app would be in CF. So, here are the reasons for my bias: 1) Given the above, he *can* do the entire app in CF-- rather than clutter the implementation with other languages, GUIs, spreadsheets, or Access forms. 2) It is a cheaper, simpler, cleaner solution for the implementor and for the user (who uses the ubiquitous browser interface that MS so eloquently insisted is part of the win OS. 3) And, over time, as the application maintained/upgraded, it be deployed by the users with a simple download or copy/paste -- no other installation necessary by the users. 4) I think that this is a natural extension of CF's capabilities I suspect that you won't agree, but appears to me that a CFAnywhere solution is all upside with little downside risk. Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
I assumed that there was more involved since the originator was considering writing programs in VB, Java, or ASP. My suggestion is that you can use CFML on the desktop, instead of these. Dick On Sep 8, 2004, at 5:04 PM, Greg Luce wrote: could crank out some data entry forms and a database to store the data in a few hours. Each machine would NOT have to have a licensed copy of office to run the compiled application. I agree using an access db as a backend for a mutli-user web application isn't always a great deal, but Access makes brilliant stable single user desktop apps like this. And of course getting the data into the Oracle DB and using CF for admin/reporting would be straight-forward. Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
I have seen this if Access or the system crashes -- I have seen quite a few times and I have never used Access in a multi-user application. Wow. I've been working with Access since version 2.0 for desktop databases and haven't seen that problem yet. No wonder you prefer the Mac! You've obviously had some unpleasant Windows experiences! Since he posted to a CF list I assume that a major part of their installation is CF He suggests that because the application is not connected to the Internet, he must look at non-CF options to write the application. And it appears that these options (Java, VB, ASP or something) are less desirable to him than CFML (for whatever reasons). Well, sure, he posted to a CF list. But if I posted a question to a plumbers' list, and my question asked how do you get a nail into a piece of wood, the appropriate answer wouldn't be to hit it with a pipe wrench. 1) Given the above, he *can* do the entire app in CF-- rather than clutter the implementation with other languages, GUIs, spreadsheets, or Access forms. I really don't see how using an Access database offline leads to a cluttered implementation. On the contrary, giving the end user a single .mdb file strikes me as less cluttered than installing a Java application server on every user's desktop! 3) And, over time, as the application maintained/upgraded, it be deployed by the users with a simple download or copy/paste -- no other installation necessary by the users. How would this be less complicated than giving the user a new .mdb file? 4) I think that this is a natural extension of CF's capabilities I think there are much better tools for the job of building desktop applications. I suspect that you won't agree, but appears to me that a CFAnywhere solution is all upside with little downside risk. I agree, except I would reverse the words upside and downside in the previous sentence. I would like to note that I'm not trying to be obnoxious in my disagreement. I just think that CF is about as wrong a tool for the job of building desktop applications as you can get. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
On Sep 8, 2004, at 5:34 PM, Dave Watts wrote: I would like to note that I'm not trying to be obnoxious in my disagreement. I just think that CF is about as wrong a tool for the job of building desktop applications as you can get. But, Dave, the original poster was looking for a programming solution, quote: Im guessing my only option would be to build something in Java, VB, ASP or something CFML can be the something! And, from what I hear about Blackstone, using CF in this way will be even easier. Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
On Sep 8, 2004, at 12:32 PM, Ciliotta, Mario wrote: Is this on a Pocket PC? We use Flash and Flash Remoting on a PPC and then when we sync the PPC up the following day, the data is loaded into our Oracle database thru a CF page. The PPC while in use collecting data is not connected to our intranet and is only connected while sync-ing up. Honest question -- no hidden agenda: Can you use Flash Remoting without being connected to the Internet? TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: (I guess) Local App
I posted to a CF list to get ideas, the admin section will be entirely CF and Oracle. I posted to get ideas on how to gather their input while not connected to the internet or intranet and then upload it to Oracle once they get back and can upload their input. This wasnt posted to start a forum war or anything heh.. I appreciate all your inputs and it gives me a good idea of where to start. On Wed, 8 Sep 2004 18:09:59 -0700, Dick Applebaum [EMAIL PROTECTED] wrote: On Sep 8, 2004, at 12:32 PM, Ciliotta, Mario wrote: Is this on a Pocket PC? We use Flash and Flash Remoting on a PPC and then when we sync the PPC up the following day, the data is loaded into our Oracle database thru a CF page. The PPC while in use collecting data is not connected to our intranet and is only connected while sync-ing up. Honest question -- no hidden agenda: Can you use Flash Remoting without being connected to the Internet? TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: (I guess) Local App
Just to throw HTA back into the mix - you might want to check it out. One of the features is that an HTA runs with application privileges, not web-page privileges (even tho' the HTA is just a web page).This means that you can use _javascript_ to access any com object on the system.In your case that means you can create an HTML based form that would use the Excel com object to automatically create and fill out the Excel sheet (or create an XML file or whatever). Jim Davis _ From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 11:06 PM To: CF-Talk Subject: Re: (I guess) Local App I posted to a CF list to get ideas, the admin section will be entirely CF and Oracle. I posted to get ideas on how to gather their input while not connected to the internet or intranet and then upload it to Oracle once they get back and can upload their input. This wasnt posted to start a forum war or anything heh.. I appreciate all your inputs and it gives me a good idea of where to start. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]