.: geoff.terrorware.com :.

info. helpful to boxcar online inventory project consolidated under a single post

web form uinit testing that can handle javascript : jWebUnit
creating a PDF with PHP
creating a PDF with PHP for free!
CSS for Printing
Utility to power off windows xp system from a batch file

Windows Resource Kit (use to install stunnel as services)

Real-World PHP Security

sending jabber message from php:

http://phpjabber.g-blog.net/HomePage

connecting access and mysql

remote stunnel command:
/usr/sbin/stunnel -P/tmp/ -p cert/mysql-server.pem -d 33306 -r localhost:3306

stunnel local command:
stunnel.exe stunnel.conf

securing replication process
i want to use stunnel to encrypt the data traveling between the computer at Boxcar and the MySQL server

unicode in MySQL

so i was having problems in my python script inserting data into the MySQL database from Access b/c I guess Access uses unicode and python was trying to automagically encode some weird character into latin-1 when doing the insert.

This code shows the problem:
```
>>> s = u'\u2026'
>>> s.encode('latin-1')
Traceback (most recent call last):
File "", line 1, in ?
UnicodeEncodeError: 'latin-1' codec can't encode character u'\u2026' in position 0: ordinal not in range(256)
>>> s.encode('ascii')
Traceback (most recent call last):
File "", line 1, in ?
UnicodeEncodeError: 'ascii' codec can't encode character u'\u2026' in position 0: ordinal not in range(128)
>>> s.encode('utf-8')
'\xe2\x80\xa6'
```
this post proved to be a little helpful:

http://mail.python.org/pipermail/python-list/2003-December/200090.html

this document was even more helpful:

http://python.active-venture.com/tut/node5.html

raw string literals in python

when constructing the DSN be sure to use r"DSNSTRING" because the \b was getting interpretted wrong

I always suspected that the Boxcar Database design was cludgy. Check out http://vbmysql.com/articles/database-design/normalize.html for ideas on making it cleaner

accessing ms access databases in python using ado

Puffin - a framework for testing web applications. An article on Puffin is available here

getting older versions of files out of cvs
Introduction to SQL Joins and Subqueries

printing out the contents of an array
use print_r

Tutorial on using PHPDoc

backing up table structure only of mysql database
```
mysqldump --no-data
```

testing web applications - webunit

allowing only SSL requests for a particular URL
```
     
      SSLRequireSSL
      
    
```

basic mysql tutorial

this is real helpful in refreshing my memory
http://www.devshed.com/c/a/MySQL/Beginning-MySQL-Tutorial/

posted by geoff on 8/11/2004 11:40:21 AM
[top | permanent | atom feed]

bittorrent tracker information

http://www.filesoup.com/forum/index.php?showtopic=6780

posted by geoff on 8/10/2004 03:07:26 PM
[top | permanent | atom feed]