andrewducker (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
andrewducker) wrote2002-03-25 10:58 pm
andrewducker) wrote2002-03-25 10:58 pm
The coolness of having your own Webserver
I use VFP a lot. It's a fantastic database, and I I use it occasionally to extract reports for some people in Kent who use it to keep track of neonatal care on a system I wrote, some years back.
I was getting some data off just now, and wanted to check I was pulling off the right info. I wanted to get the SQL output to them, (and was chatting to the person who wanted it over MSN), but couldn't think of a super easy way.
Until I remembered that VFP has a 'save as web page' option, that saves SQL output in a dead simple HTML table. So I saved it into the web directory, checked the URL worked, pasted it into MSN, and they were able to look at the data 3 seconds later.
This is fantastic. I can do RAD a lot easier if the people down there can check my results as I go along. Saves me pulling off tons of data only to find it's not quite right.
I was getting some data off just now, and wanted to check I was pulling off the right info. I wanted to get the SQL output to them, (and was chatting to the person who wanted it over MSN), but couldn't think of a super easy way.
Until I remembered that VFP has a 'save as web page' option, that saves SQL output in a dead simple HTML table. So I saved it into the web directory, checked the URL worked, pasted it into MSN, and they were able to look at the data 3 seconds later.
This is fantastic. I can do RAD a lot easier if the people down there can check my results as I go along. Saves me pulling off tons of data only to find it's not quite right.