When you integrate a site onto its final server – things with windows get hairy. Here are some notes to get out of trouble seeing a 401 for anonymous user? Are your permissions for IUSR set to read, write, execute (ref)? This is for anonymous user. For a dynamic user, then you have to add […]
I have been doing Stored Procedures in Microsoft TSQL but this article is a good starter for mySQL. If you use phpMyAdmin to get this and that accomplished – you can access your procedures given the instructions in this article – you have to have at least one stored proc in order for this link to […]
It has always bugged me that code contains passwords that are plainly visible. There are ways to encode just the password or the whole connection string. After some searching, here is a post that talks about encrypting the whole thing – but the last post talks of just encrypting the password (see last entry – at least […]
Well, it seems that ZOHO Creator has come a ways since last winter. I abandoned using ZOHO Creator which REALLY will someday give Filemaker a run for its money. It is BEYOND incredible what ZOHO has done with their database tool REPORTS which blows MS Access out of the water – and it is web […]
I found a great article and tool to get started, but it took many attempts to finally move or relocate WordPress website or folder from http://elbsolutions.com/chadtest to the almost final position of http://smartcar.websitewelcome.com/~wccogca . Since it was quite frustrating, I thought I would blog about it for other people who can benefit. Steps were: get […]
There are really 2 concepts here which is the reason for the long title. First, adding jQuery to Report Services means hacking 2 install files (.aspx files) of Report Services. If you don’t have someone who has access to the server that is hosting the web pages, it might be hard to get this done. […]
This is a note to keep myself clear on what technology is preferred and when to use it. I understand why programmers use explitives and the F-bomb- MS makes things SOOOO complicated (uninstall and reinstall the 2010 distributable – no matter how ‘installed’ you think it is 🙂 ). Basically Microsoft Access has flip flopped […]
We all know- or you should – how cool Notepad++ is for getting work done. If you want a quick “sort text” function without using Excel (cause excel parses based on your last text import/delimit function) – TextFx is a plugin that gets it done . To save my typing and to give proper credit for […]
Adding new fields to the database Adding new fields to the database is useful in cases were you more information about a component, but there is no corrosponding field in the database to the one in the specs. If you know where your database is you can skip the first 3 steps> To create a new […]
Lets assume that a new spec was created. AutoPLANT has a very clever structure to its files so that the core ones that come with AutoPLANT need not be touched. It also helps when new specs, ebs, classes etc. are added (specs beyond just adding or changing dB rows). This article outlines how to integrate […]