Re: [Dbmail] SQL suggestion

2006-11-16 Thread Jason Chu
On Wed, 15 Nov 2006 21:47:49 -0500 Tom Allison [EMAIL PROTECTED] wrote: Believe me, I'm not trying to be an expert here, so if I'm wrong I could benefit from some explaining why... but... instead of: SELECT user_idnr FROM dbmail_users WHERE lower(userid) = lower('[EMAIL PROTECTED]')

Re: [Dbmail] Using DBMail in an existing web app

2006-10-26 Thread Jason Chu
On Sat, 21 Oct 2006 22:55:31 +0200 Paul J Stevens [EMAIL PROTECTED] wrote: Jason Chu wrote: I believe my other two concerns about keeping emails and extra data/fields associated with emails still stand though. Jason, What you want is to associate meta-data with a physmessage and a user

[Dbmail] Using DBMail in an existing web app

2006-10-18 Thread Jason Chu
We're looking into using dbmail in our existing web app (http://oprius.com). Because our app is a CRM type of thing, we want to associate emails with other rows in the database (think associating emails with contacts). We're using Postgres as our backend. I've done a bunch of searching on the

Re: [Dbmail] Using DBMail in an existing web app

2006-10-18 Thread Jason Chu
On Tue, 17 Oct 2006 21:12:23 -0700 Jason Chu [EMAIL PROTECTED] wrote: We're looking into using dbmail in our existing web app (http://oprius.com). Because our app is a CRM type of thing, we want to associate emails with other rows in the database (think associating emails with contacts). Ok