![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
*PREEN*
I am extremely proud of myself. Not only have I found and fixed a few extremely challenging bugs in the tcl code, but I have added procedures to search through the database.
The database contains contact information for a non-profit. There are two entities: organizations and people. Each can have phone numbers, email addresses and addresses. In addition, organizations can have people as contacts. I did repair a bug when searching for a contact based on an organization name.
For quite awhile now, we have been able to search for a person with a globbing search that presents a list of possible hits based on bits of supplied information. The search can be on bits of name, address, phone or email.
Tonight I wrote the code that searches for organizations. The trick here is that searches based on people names, phones, emails and addresses have to test against the organization and all the contacts.
That was a VERY complicated query.
AND IT WORKS!
*PREEN*
I am extremely proud of myself. Not only have I found and fixed a few extremely challenging bugs in the tcl code, but I have added procedures to search through the database.
The database contains contact information for a non-profit. There are two entities: organizations and people. Each can have phone numbers, email addresses and addresses. In addition, organizations can have people as contacts. I did repair a bug when searching for a contact based on an organization name.
For quite awhile now, we have been able to search for a person with a globbing search that presents a list of possible hits based on bits of supplied information. The search can be on bits of name, address, phone or email.
Tonight I wrote the code that searches for organizations. The trick here is that searches based on people names, phones, emails and addresses have to test against the organization and all the contacts.
That was a VERY complicated query.
AND IT WORKS!
*PREEN*