{"id":606,"date":"2004-08-11T11:40:21","date_gmt":"2004-08-11T16:40:21","guid":{"rendered":"http:\/\/blogs.terrorware.com\/geoff\/2004\/08\/11\/info-helpful-to-boxcar-online-inventory-project-consolidated-under-a-single-post\/"},"modified":"2004-08-11T11:40:21","modified_gmt":"2004-08-11T16:40:21","slug":"info-helpful-to-boxcar-online-inventory-project-consolidated-under-a-single-post","status":"publish","type":"post","link":"http:\/\/blogs.terrorware.com\/geoff\/2004\/08\/11\/info-helpful-to-boxcar-online-inventory-project-consolidated-under-a-single-post\/","title":{"rendered":"info. helpful to boxcar online inventory project consolidated under a single post"},"content":{"rendered":"<ul>\n<li><a href=\"http:\/\/jwebunit.sourceforge.net\">web form uinit testing that  can handle javascript : jWebUnit<\/a><\/li>\n<li><a href=\"http:\/\/www.zend.com\/zend\/spotlight\/creatingpdfmay1.php\">creating a PDF with PHP<\/a><\/li>\n<li><a href=\"http:\/\/us4.php.net\/manual\/en\/faq.using.php#faq.using.freepdf\">creating a PDF with PHP for free<\/a>!\n<\/li>\n<li><a href=\"http:\/\/www.webdesignschoolreview.com\/css-printing.html\">CSS for Printing<\/a>\n<\/li>\n<li><a href=\"http:\/\/www.budja.com\/shutdown\/\">Utility to power off windows xp system from a batch file<\/a><\/li>\n<li><a href=\"http:\/\/www.microsoft.com\/downloads\/details.aspx?FamilyID=9d467a69-57ff-4ae7-96ee-b18c4790cffd&amp;DisplayLang=en\">Windows Resource Kit<\/a> (use to install stunnel as services)<\/li>\n<li><a href=\"http:\/\/www.linuxjournal.com\/article.php?sid=7237\">Real-World PHP Security<\/a><\/li>\n<li>sending jabber message from php:\n<p><a href=\"http:\/\/phpjabber.g-blog.net\/HomePage\">http:\/\/phpjabber.g-blog.net\/HomePage<\/a>\n<\/li>\n<li><a href=\"http:\/\/www.washington.edu\/computing\/web\/publishing\/mysql-access.html\">connecting access and mysql<\/a><\/li>\n<li>remote stunnel command:<br \/>\n\/usr\/sbin\/stunnel -P\/tmp\/ -p cert\/mysql-server.pem -d 33306 -r localhost:3306<\/p>\n<p>    stunnel local command:<br \/>\n    stunnel.exe stunnel.conf\n<\/li>\n<li><strong>securing replication process<\/strong><br \/>\ni want to use <a href=\"http:\/\/www.stunnel.org\">stunnel<\/a> to encrypt the data traveling between the computer at Boxcar and the MySQL server\n<\/li>\n<li>unicode in MySQL\n<p>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.<\/p>\n<p>This code shows the problem:<\/p>\n<pre>\n&gt;&gt;&gt; s = u'\\u2026'\n&gt;&gt;&gt; s.encode('latin-1')\nTraceback (most recent call last):\nFile \"\", line 1, in ?\nUnicodeEncodeError: 'latin-1' codec can't encode character u'\\u2026' in position 0: ordinal not in range(256)\n&gt;&gt;&gt; s.encode('ascii')\nTraceback (most recent call last):\nFile \"\", line 1, in ?\nUnicodeEncodeError: 'ascii' codec can't encode character u'\\u2026' in position 0: ordinal not in range(128)\n&gt;&gt;&gt; s.encode('utf-8')\n'\\xe2\\x80\\xa6'\n<\/pre>\n<p>this post proved to be a little helpful:<\/p>\n<p><a href=\"http:\/\/mail.python.org\/pipermail\/python-list\/2003-December\/200090.html\">http:\/\/mail.python.org\/pipermail\/python-list\/2003-December\/200090.html<\/a><\/p>\n<p>this document was even more helpful:<\/p>\n<p><a href=\"http:\/\/python.active-venture.com\/tut\/node5.html\">http:\/\/python.active-venture.com\/tut\/node5.html<\/a><\/li>\n<li><strong>raw string literals in python<\/strong>\n<p>when constructing the DSN be sure to use r&#8221;DSNSTRING&#8221; because the \\b was getting interpretted wrong<\/li>\n<li>I always suspected that the Boxcar Database design was cludgy.  Check out <a href=\"http:\/\/vbmysql.com\/articles\/database-design\/normalize.html\">http:\/\/vbmysql.com\/articles\/database-design\/normalize.html<\/a> for ideas on making it cleaner<\/li>\n<li><a href=\"http:\/\/www.ecp.cc\/pyado.html\">accessing ms access databases in python using ado<\/a><\/li>\n<li><a href=\"http:\/\/www.puffinhome.org\/\">Puffin<\/a> &#8211; a framework for testing web applications.  An article on Puffin is available <a href=\"http:\/\/www-106.ibm.com\/developerworks\/library\/os-puffin.html\">here<\/a><\/li>\n<li><a href=\"http:\/\/elib.cs.berkeley.edu\/admin\/cvs\/cvsrevert.html\">getting older versions of files out of cvs<\/a>\n<\/li>\n<li><a href=\"http:\/\/www.devshed.com\/c\/a\/MySQL\/Speaking-SQL-part-2\">Introduction to SQL Joins and Subqueries<\/a><\/li>\n<li><strong>printing out the contents of an array<\/strong><br \/>\n     use <a href=\"http:\/\/www.php.net\/manual\/en\/function.print-r.php\">print_r<\/a>\n<\/li>\n<li><a href=\"http:\/\/www.devshed.com\/c\/a\/PHP\/Writing-SelfDocumenting-PHP-Code\">Tutorial on using PHPDoc<\/a><\/li>\n<li><strong>backing up table structure only of mysql database<\/strong>\n<pre>mysqldump --no-data<\/pre>\n<\/li>\n<li><b>testing web applications<\/b> &#8211; <a href=\"http:\/\/webunit.sourceforge.net\/\">webunit<\/a><\/li>\n<li><b>allowing only SSL requests for a particular URL<\/b>\n<pre>\n     \n      SSLRequireSSL\n      \n    <\/pre>\n<\/li>\n<li><strong>basic mysql tutorial<\/strong>\n<p>      this is real helpful in refreshing my memory<br \/>\n      <a href=\"http:\/\/www.devshed.com\/c\/a\/MySQL\/Beginning-MySQL-Tutorial\/\">http:\/\/www.devshed.com\/c\/a\/MySQL\/Beginning-MySQL-Tutorial\/<\/a>\n <\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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&hellip; <a class=\"more-link\" href=\"http:\/\/blogs.terrorware.com\/geoff\/2004\/08\/11\/info-helpful-to-boxcar-online-inventory-project-consolidated-under-a-single-post\/\">Continue reading <span class=\"screen-reader-text\">info. helpful to boxcar online inventory project consolidated under a single post<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-606","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wnIz-9M","_links":{"self":[{"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts\/606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/comments?post=606"}],"version-history":[{"count":0,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts\/606\/revisions"}],"wp:attachment":[{"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/media?parent=606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/categories?post=606"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/tags?post=606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}