Reading memo fields in Access using asp and ado

as a reminder to myself really, in access 2000 there is now a memo field these can only be read once from the ado recordset in asp.  The second time the field will be null, ie if you do the following… twice the second one doesnt return anything as it loses the field contents, I believe this is by design

CSS and Accomodating different browsers

the same old problem, using css different things appear in different places.  The solution you have to trick some of the browsers so you can use different css tags – this is one of the best sites I have seen for a long time documenting the features of each browser. http://www.dithered.com/ enjoy…

The project you are trying to open is a web project you need to open it by specifying its URL path

The famous error “The project you are trying to open is a web project you need to open it by specifying its URL path” in visual studio .net.  Basically you have either lost your .webinfo file or your .webinfo file is pointing to the wrong project or wrong place. Took me a while to figure it out but hope that… Continue reading The project you are trying to open is a web project you need to open it by specifying its URL path

Unable to connect to newer mysql database – Client Does Not Support Authentication Protocol Requested By Server, Consider Upgrading MySQL Client

Kept getting the message ‘Client Does Not Support Authentication Protocol Requested By Server, Consider Upgrading MySQL Client’ after upgrading the mysql server to a newer version than the client odbc driver and after much trawling found that you have to update the mysql user table to hold the password in the old format like so.. UPDATE mysql.userSET password=OLD_PASSWORD(‘somepassword’)WHERE user=’someuser’AND host=’somehost’;… Continue reading Unable to connect to newer mysql database – Client Does Not Support Authentication Protocol Requested By Server, Consider Upgrading MySQL Client

GD Lib with Bugzilla

Trying to get libpng and libjpeg support ??  You will need to install the developer versions of the libraries, on Fedora the easiest way is to use up2date ie. up2date libjpeg-devel and up2date libpng-devel this will install it then the configure for the makefile of libgd will pick the libraries up and install support for them. Also dont use the… Continue reading GD Lib with Bugzilla

How to Reset Webalizer

Looking at my hosting site I noticed there is quite a lot of traffic looking for how to reset the open source project webalizer so here is what I do to reset it. Basically under Fedora the webalizer package is installed in /var/lib/webalizer, and in there (if you have run it already) will be two files webalizer.current and webalizer.hist you… Continue reading How to Reset Webalizer