Need a job? Learn Drupal

February 25th, 2010

The economy may be getting better, but unemployment is still high. Companies slashed budgets and personnel last year, but as the economy begins to recover, the creation of jobs is not falling in line.
The lack of new jobs continues to be an issue even for San Francisco Bay Area tech companies. So, how are unemployed [...]

SQL Functions, Triggers, and Rules (and Crystal Reports)

February 20th, 2010

http://www.postgresql.org/docs/8.0/static/xfunc-sql.html
http://www.postgresql.org/docs/8.1/static/rules.html
http://wiki.postgresql.org/wiki/A_Brief_Real-world_Trigger_Example
http://www.vb6.us/tutorials/using-crystal-reports-vb6-tutorial
http://www.postgresql.org/docs/7.3/static/plpgsql.html
http://www.plsql-tutorial.com/

Password crypt authentication not supported

February 13th, 2010

For those of you encountering this error, psqlODBC does not support yet md5 encryption.
Workaround:

Go to your Bitnami WAPPStack\postgresql\data folder and edit pg_hba.conf
Change md5 to trust.*
Run services.msc to restart the wappstack PostgreSQL service.
Rerun your VB code.

 
* WARNING:
Disabling your md5 and changing it to trust risks your server to hackers. As [...]

VB – ADODB – psqlODBC – PostgreSQL Links

February 13th, 2010

Here are the links on a few tutorials on how to do with programming on VB6, using ADODB-psqlODBC to access PostgreSQL Databases. Enjoy!
http://www.vbexplorer.com/VBExplorer/vb_feature/june2000/Database_Beginner_ADO_DAO.asp
http://www.timesheetsmts.com/adotutorial.htm
http://www.codeproject.com/KB/vbscript/recordset_to_array.aspx
For future reference, I have also found these links:
http://www.w3schools.com/Sql/sql_autoincrement.asp
http://www.connectionstrings.com/

DBMS Assignment 1

December 7th, 2009

For class: A & C, Dec 4 & 5
Medium: 1 whole sheet yellow paper
Deadline: Lecture Day (Dec 10 & 12)

Alpha First Shots

November 24th, 2009

Web Seminar 2009

November 14th, 2009

Hi! These are all of the materials and links from the Web Design discussion last 11/14/2009.

Proud MUSTean

September 17th, 2009

This is the future home for the Proud MUSTean initiative. Please check back later for more updates.

Farmville Automator: Public Beta

September 15th, 2009

Here is the automator I promised. It allows you to harvest, plow, and plant in approx 2.27 minutes*, without clicking on the farm.

Tongue Twister!

August 25th, 2009

“Cecile saw seashells at the seashore.
She brought the seashells [to] the seaside.
So she sells the seashells along the seashore
But when she ate the unsold seashells she dies because of seizure.”
- Cecile Pagsure by Ryan Templa
Had to post this… Nice piece…