Re: Modern (and free) html/cf editor that is similar to Homesite?
Sublime is amazing I have just switched. It's not free but if you use it as the free version its the same just has a pop up to purchase every now and then. Highly recommended for a speedy editor. Paul. On Tue, Aug 14, 2012 at 9:43 AM, Kym Kovan wrote: > > Nobody has mentioned Sublime Text 2 > > http://www.sublimetext.com/2 > > a superb editor, a natural if you are moving on from Homesite > > On 14/08/2012 00:15, Pete Ruckelshaus wrote: > > > > I teach web design and web programming at a public high school. I have > > been using homesite for my classes, but it doesn't play well in our > > environment (locked down C drive, network drives...trust me, it has > > issues). Are there any current text editors that play well with HTML, > CSS, > > JavaScript, and CF, that are also free? It doesn't need to be a super > > heavy duty app like Eclipse, in fact, I tried that with my web design > class > > and it was a nightmare because of its complexity. > > > > Platform is WinXP. > > > > Thanks for any suggestions, > > > > Pete > > > > > > > -- > Yours, > > Kym Kovan > mbcomms.net.au > > > > ~| 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:352143 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
Sublime Text 2 is not free. -Steve On Monday, August 13, 2012, Kym Kovan wrote: > > Nobody has mentioned Sublime Text 2 > > http://www.sublimetext.com/2 > > a superb editor, a natural if you are moving on from Homesite > > On 14/08/2012 00:15, Pete Ruckelshaus wrote: > > > > I teach web design and web programming at a public high school. I have > > been using homesite for my classes, but it doesn't play well in our > > environment (locked down C drive, network drives...trust me, it has > > issues). Are there any current text editors that play well with HTML, > CSS, > > JavaScript, and CF, that are also free? It doesn't need to be a super > > heavy duty app like Eclipse, in fact, I tried that with my web design > class > > and it was a nightmare because of its complexity. > > > > Platform is WinXP. > > > > Thanks for any suggestions, > > > > Pete > > > > > > > -- > Yours, > > Kym Kovan > mbcomms.net.au > > > > ~| 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:352142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
Nobody has mentioned Sublime Text 2 http://www.sublimetext.com/2 a superb editor, a natural if you are moving on from Homesite On 14/08/2012 00:15, Pete Ruckelshaus wrote: > > I teach web design and web programming at a public high school. I have > been using homesite for my classes, but it doesn't play well in our > environment (locked down C drive, network drives...trust me, it has > issues). Are there any current text editors that play well with HTML, CSS, > JavaScript, and CF, that are also free? It doesn't need to be a super > heavy duty app like Eclipse, in fact, I tried that with my web design class > and it was a nightmare because of its complexity. > > Platform is WinXP. > > Thanks for any suggestions, > > Pete > > -- Yours, Kym Kovan mbcomms.net.au ~| 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:352141 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Getting data from MS Access and importing into SQL.
if your looking to move off access then Microsoft also provide free migration tools as well. On Mon, Aug 13, 2012 at 8:18 PM, Eric Roberts < ow...@threeravensconsulting.com> wrote: > > There is an upgrade wizard that will take your access data and tables and > recreate them in SQL Server. That has been there for at least 3 versions > of > SQL ServerI believe that was implemented in SQL 2003. So if you are > using a version later than that, you should be in luck ;-) > > > Three Ravens Consulting > Eric Roberts > Owner/Developer > ow...@threeravensconsulting.com > tel: 630-486-5255 > fax: 630-310-8531 > http://www.threeravensconsulting.com > > > -Original Message- > From: Russ Michaels [mailto:r...@michaels.me.uk] > Sent: Monday, August 13, 2012 12:16 PM > To: cf-talk > Subject: Re: Getting data from MS Access and importing into SQL. > > > it is possible to add a custom interface for msaccess that links it to sql > server, so users can do this directly. > I don;t know how to do this as I don;t do VBA, but we have a customer that > does this very thing. He runs msaccess locally and uses it to conenct to > his > hosted database and manage data and sync with his local access db > > > On Mon, Aug 13, 2012 at 6:12 PM, Captain Obvious > wrote: > > > > > Maybe this: > > > > - have end-users upload entire MDB. > > - in uploaded MDBs insert links to SQL Server tables. > > - execute a set of Insert queries to copy data from MDB tables to SQL > > Server tables. > > > > > > > > > > ~| 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:352140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Getting data from MS Access and importing into SQL.
There is an upgrade wizard that will take your access data and tables and recreate them in SQL Server. That has been there for at least 3 versions of SQL ServerI believe that was implemented in SQL 2003. So if you are using a version later than that, you should be in luck ;-) Three Ravens Consulting Eric Roberts Owner/Developer ow...@threeravensconsulting.com tel: 630-486-5255 fax: 630-310-8531 http://www.threeravensconsulting.com -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Monday, August 13, 2012 12:16 PM To: cf-talk Subject: Re: Getting data from MS Access and importing into SQL. it is possible to add a custom interface for msaccess that links it to sql server, so users can do this directly. I don;t know how to do this as I don;t do VBA, but we have a customer that does this very thing. He runs msaccess locally and uses it to conenct to his hosted database and manage data and sync with his local access db On Mon, Aug 13, 2012 at 6:12 PM, Captain Obvious wrote: > > Maybe this: > > - have end-users upload entire MDB. > - in uploaded MDBs insert links to SQL Server tables. > - execute a set of Insert queries to copy data from MDB tables to SQL > Server tables. > > > ~| 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:352139 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
>>Anybody having a problem getting the Notepad++ cold fusion Lexer plug-in to install? You have to do it manually. The installer does not work. Go here and DL the latest version and follow the instructions in the zip file: https://bitbucket.org/bbluemel/nppcoldfusion/downloads That worked like a charm. HTH G! On Mon, Aug 13, 2012 at 1:48 PM, Tim L (g-mail) wrote: > > Anybody having a problem getting the Notepad++ cold fusion Lexer plug-in to > install? > > On Mon, Aug 13, 2012 at 1:44 PM, Gerald Guido >wrote: > > > > > 1++ for Notepad++. > > > > Also Komodo Edit is pretty slick. It supports CSS, JS, PHP etc.with code > > hinting and code complete. Not as light weight as Notepad++ but it is a > > very nice product. > > http://www.activestate.com/komodo-edit > > > > HTH > > G! > > > > On Mon, Aug 13, 2012 at 12:27 PM, Carl Von Stetten > > wrote: > > > > > > > > Another +1 for Notepad++. > > > -Carl > > > > > > > > > > > > ~| 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:352138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Getting data from MS Access and importing into SQL.
If end users have connectivity to the sql server, yes (no special interface required though). On Mon, Aug 13, 2012 at 1:15 PM, Russ Michaels wrote: > > it is possible to add a custom interface for msaccess that links it to sql > server, so users can do this directly. > I don;t know how to do this as I don;t do VBA, but we have a customer that > does this very thing. He runs msaccess locally and uses it to conenct to > his hosted database and manage data and sync with his local access db > ~| 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:352137 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Modern (and free) html/cf editor that is similar to Homesite?
--- nppColdFusion v0.8.1 --- http://bitbucket.org/bbluemel/nppcoldfusion/ -Original Message- From: Tim L (g-mail) [mailto:homet...@gmail.com] Sent: Monday, August 13, 2012 2:01 PM To: cf-talk Subject: Re: Modern (and free) html/cf editor that is similar to Homesite? what website did you go to for downloading... this site: http://www.nppcf.com comes up page not found On Mon, Aug 13, 2012 at 1:51 PM, Perez, Percy mailto:per...@versa-valves.com>>wrote: > > It would not install successfully using the plugin manager. > > I installed manually. > > > -Original Message- > From: Tim L (g-mail) [mailto:homet...@gmail.com] > Sent: Monday, August 13, 2012 1:49 PM > To: cf-talk > Subject: Re: Modern (and free) html/cf editor that is similar to Homesite? > > > Anybody having a problem getting the Notepad++ cold fusion Lexer plug-in to > install? > > On Mon, Aug 13, 2012 at 1:44 PM, Gerald Guido >wrote: > > > > > 1++ for Notepad++. > > > > Also Komodo Edit is pretty slick. It supports CSS, JS, PHP etc.with code > > hinting and code complete. Not as light weight as Notepad++ but it is a > > very nice product. > > http://www.activestate.com/komodo-edit > > > > HTH > > G! > > > > On Mon, Aug 13, 2012 at 12:27 PM, Carl Von Stetten > > mailto:vonner.li...@vonner.net>>wrote: > > > > > > > > Another +1 for Notepad++. > > > -Carl > > > > > > > > > > > > > > ~| 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:352136 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
what website did you go to for downloading... this site: http://www.nppcf.com comes up page not found On Mon, Aug 13, 2012 at 1:51 PM, Perez, Percy wrote: > > It would not install successfully using the plugin manager. > > I installed manually. > > > -Original Message- > From: Tim L (g-mail) [mailto:homet...@gmail.com] > Sent: Monday, August 13, 2012 1:49 PM > To: cf-talk > Subject: Re: Modern (and free) html/cf editor that is similar to Homesite? > > > Anybody having a problem getting the Notepad++ cold fusion Lexer plug-in to > install? > > On Mon, Aug 13, 2012 at 1:44 PM, Gerald Guido >wrote: > > > > > 1++ for Notepad++. > > > > Also Komodo Edit is pretty slick. It supports CSS, JS, PHP etc.with code > > hinting and code complete. Not as light weight as Notepad++ but it is a > > very nice product. > > http://www.activestate.com/komodo-edit > > > > HTH > > G! > > > > On Mon, Aug 13, 2012 at 12:27 PM, Carl Von Stetten > > wrote: > > > > > > > > Another +1 for Notepad++. > > > -Carl > > > > > > > > > > > > > > ~| 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:352135 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Modern (and free) html/cf editor that is similar to Homesite?
It would not install successfully using the plugin manager. I installed manually. -Original Message- From: Tim L (g-mail) [mailto:homet...@gmail.com] Sent: Monday, August 13, 2012 1:49 PM To: cf-talk Subject: Re: Modern (and free) html/cf editor that is similar to Homesite? Anybody having a problem getting the Notepad++ cold fusion Lexer plug-in to install? On Mon, Aug 13, 2012 at 1:44 PM, Gerald Guido wrote: > > 1++ for Notepad++. > > Also Komodo Edit is pretty slick. It supports CSS, JS, PHP etc.with code > hinting and code complete. Not as light weight as Notepad++ but it is a > very nice product. > http://www.activestate.com/komodo-edit > > HTH > G! > > On Mon, Aug 13, 2012 at 12:27 PM, Carl Von Stetten > wrote: > > > > > Another +1 for Notepad++. > > -Carl > > > > > > ~| 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:352134 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
Anybody having a problem getting the Notepad++ cold fusion Lexer plug-in to install? On Mon, Aug 13, 2012 at 1:44 PM, Gerald Guido wrote: > > 1++ for Notepad++. > > Also Komodo Edit is pretty slick. It supports CSS, JS, PHP etc.with code > hinting and code complete. Not as light weight as Notepad++ but it is a > very nice product. > http://www.activestate.com/komodo-edit > > HTH > G! > > On Mon, Aug 13, 2012 at 12:27 PM, Carl Von Stetten > wrote: > > > > > Another +1 for Notepad++. > > -Carl > > > > > > ~| 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:352133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
1++ for Notepad++. Also Komodo Edit is pretty slick. It supports CSS, JS, PHP etc.with code hinting and code complete. Not as light weight as Notepad++ but it is a very nice product. http://www.activestate.com/komodo-edit HTH G! On Mon, Aug 13, 2012 at 12:27 PM, Carl Von Stetten wrote: > > Another +1 for Notepad++. > -Carl > > ~| 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:352132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Getting data from MS Access and importing into SQL.
it is possible to add a custom interface for msaccess that links it to sql server, so users can do this directly. I don;t know how to do this as I don;t do VBA, but we have a customer that does this very thing. He runs msaccess locally and uses it to conenct to his hosted database and manage data and sync with his local access db On Mon, Aug 13, 2012 at 6:12 PM, Captain Obvious wrote: > > Maybe this: > > - have end-users upload entire MDB. > - in uploaded MDBs insert links to SQL Server tables. > - execute a set of Insert queries to copy data from MDB tables to SQL > Server tables. > > > ~| 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:352131 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Getting data from MS Access and importing into SQL.
Maybe this: - have end-users upload entire MDB. - in uploaded MDBs insert links to SQL Server tables. - execute a set of Insert queries to copy data from MDB tables to SQL Server tables. ~| 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:352130 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
EXTJS Webdesktop sample
Is there any webdesktop sample out there with coldfusion? I don't want to start from scratch. Any link would be appreciated. ~| 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:352129 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 & Scheduled Task
this is definitely possible because I do ittrhe other way round to lock down the administrator folder, so require authentication only on that sub directory. try using a virtual directory instead of a physical directory. On Mon, Aug 13, 2012 at 5:25 PM, Carl Von Stetten wrote: > > Dave, > > On my previous Win2K3 server, the only way I was able to get scheduled > tasks to run properly was to allow anonymous access to the subfolder in > the application which stored the scripts for scheduled tasks. This > worked fine for several years on the old server. > > I was trying to do the same thing on the new Win2K8R2 server (IIS 7.5). > The application requires NTLM authentication, but I haven't been able to > get the scheduled tasks to run. Even when I hit the scheduled task > pages directly in a browser (Firefox and Chrome), I am prompted to login > with Active Directory credentials. I also tried turning the subfolder > in question into a virtual application in IIS 7.5 but that didn't seem > to make any difference. > > Anyway, as you indicate, it appears that under IIS 7.5 you can't open a > "security hole" (my quotes) by allowing anonymous access to a subfolder > in a site requiring authentication. So my workaround is to create a new > site just for running scheduled tasks, and have that entire site allow > anonymous authentication (thanks also to Russ who kinda suggested > this). I am now able to get these scheduled tasks to run properly. > > Thank you Dave and Russ for your suggestions! > -Carl > > On 8/10/2012 4:19 PM, Dave Watts wrote: > >> OK. I created a local Windows user account named "SchedTasks". I gave > that account read permissions to the folder. I set > >> Anonymous Authentication to "Enabled" just for that folder, and set the > credentials to use the SchedTasks account. In the CF > >> Scheduled Task, I specified SchedTask for the username, and filled in > the correct password. I still get the 401.2 error when > >> running the scheduled task. > > If you're creating a user account for CF to use, why would you enable > > anonymous authentication? That's not going to help you any. > > > > First, I'd recommend that you don't even bother testing from CF yet. > > Test from Firefox or some other non-IE HTTP client (wget, etc). > > > > Second, I don't think you can set anonymous authentication for a > > folder, as such - it has to be a virtual server or a virtual > > application. I could be wrong about that, though. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > http://training.figleaf.com/ > > > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > > GSA Schedule, and provides the highest caliber vendor-authorized > > instruction at our training centers, online, or onsite. > > > > > > ~| 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:352128 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
Another +1 for Notepad++. -Carl ~| 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:352127 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Authentication on IIS 7.5 & Scheduled Task
Dave, On my previous Win2K3 server, the only way I was able to get scheduled tasks to run properly was to allow anonymous access to the subfolder in the application which stored the scripts for scheduled tasks. This worked fine for several years on the old server. I was trying to do the same thing on the new Win2K8R2 server (IIS 7.5). The application requires NTLM authentication, but I haven't been able to get the scheduled tasks to run. Even when I hit the scheduled task pages directly in a browser (Firefox and Chrome), I am prompted to login with Active Directory credentials. I also tried turning the subfolder in question into a virtual application in IIS 7.5 but that didn't seem to make any difference. Anyway, as you indicate, it appears that under IIS 7.5 you can't open a "security hole" (my quotes) by allowing anonymous access to a subfolder in a site requiring authentication. So my workaround is to create a new site just for running scheduled tasks, and have that entire site allow anonymous authentication (thanks also to Russ who kinda suggested this). I am now able to get these scheduled tasks to run properly. Thank you Dave and Russ for your suggestions! -Carl On 8/10/2012 4:19 PM, Dave Watts wrote: >> OK. I created a local Windows user account named "SchedTasks". I gave that >> account read permissions to the folder. I set >> Anonymous Authentication to "Enabled" just for that folder, and set the >> credentials to use the SchedTasks account. In the CF >> Scheduled Task, I specified SchedTask for the username, and filled in the >> correct password. I still get the 401.2 error when >> running the scheduled task. > If you're creating a user account for CF to use, why would you enable > anonymous authentication? That's not going to help you any. > > First, I'd recommend that you don't even bother testing from CF yet. > Test from Firefox or some other non-IE HTTP client (wget, etc). > > Second, I don't think you can set anonymous authentication for a > folder, as such - it has to be a virtual server or a virtual > application. I could be wrong about that, though. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > ~| 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:352126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Getting data from MS Access and importing into SQL.
I have been assigned to a new project that has two applications. One of the applications is a MS Access file that people carry on their laptop. They use MS Access because the users work in a lot of places where they have no access to the Internet. When they are done using the MS Access application the user has to go to a location with Internet access, export the data in one of the MS Access tables to an Excel file, which then gets uploaded to a website. Here are the steps the data goes through. 1) While in MS Access the user exports the table's data to an Excel file. 2) The user goes to the website to select the Excel file created by MS Access using an HTML file select form field. (The name of the Excel file is usually always different, but the table inside the file and its format are always the same.) 3) When the user clicks the submit button the selected Excel file is uploaded to the server. 4) The site uses cfspreadsheet to read the data from the Excel file 5) The site uses SQL code to insert the data into the site's SQL database. This seems cumbersome. I was wondering if there was a way to get the data directly from the MS Access file and insert it into the SQL database table? The name of the MS Access file will change, but the format of the table in the MS Access file will never change. (I know, never say never. But for the purpose of this question, let's stick with saying never.) If it helps, we can use the following names: MS Access file = MyAccessFile MS Access table = MyAccessTable SQL Server database = MySqlDatabase SQL Server table = MySqlTable The columns in the table can be: GizmoName = Varchar (255) GizmoDescription = Text ~| 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:352125 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
+1 for Notepad++ On Mon, Aug 13, 2012 at 3:21 PM, Paul Ihrig wrote: > > http://www.ultraedit.com/downloads/ultraedit_download.html > > http://download.cnet.com/HomeSite/3000-10247_4-10001199.html > > > ~| 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:352124 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
http://www.ultraedit.com/downloads/ultraedit_download.html http://download.cnet.com/HomeSite/3000-10247_4-10001199.html ~| 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:352123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Modern (and free) html/cf editor that is similar to Homesite?
Notepad++ http://notepad-plus-plus.org It even has a plugin for ColdFusion. -Original Message- From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] Sent: Monday, August 13, 2012 10:16 AM To: cf-talk Subject: Modern (and free) html/cf editor that is similar to Homesite? I teach web design and web programming at a public high school. I have been using homesite for my classes, but it doesn't play well in our environment (locked down C drive, network drives...trust me, it has issues). Are there any current text editors that play well with HTML, CSS, JavaScript, and CF, that are also free? It doesn't need to be a super heavy duty app like Eclipse, in fact, I tried that with my web design class and it was a nightmare because of its complexity. Platform is WinXP. Thanks for any suggestions, Pete ~| 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:352122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Modern (and free) html/cf editor that is similar to Homesite?
I think there's a CF "plugin" for Notepad++ On Mon, Aug 13, 2012 at 10:15 AM, Pete Ruckelshaus wrote: > > I teach web design and web programming at a public high school. I have > been using homesite for my classes, but it doesn't play well in our > environment (locked down C drive, network drives...trust me, it has > issues). Are there any current text editors that play well with HTML, CSS, > JavaScript, and CF, that are also free? It doesn't need to be a super > heavy duty app like Eclipse, in fact, I tried that with my web design class > and it was a nightmare because of its complexity. > > Platform is WinXP. > > Thanks for any suggestions, > > Pete > > > ~| 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:352121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Modern (and free) html/cf editor that is similar to Homesite?
I teach web design and web programming at a public high school. I have been using homesite for my classes, but it doesn't play well in our environment (locked down C drive, network drives...trust me, it has issues). Are there any current text editors that play well with HTML, CSS, JavaScript, and CF, that are also free? It doesn't need to be a super heavy duty app like Eclipse, in fact, I tried that with my web design class and it was a nightmare because of its complexity. Platform is WinXP. Thanks for any suggestions, Pete ~| 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:352120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm