Site message

[+FarmerPickles]

I would like to like for members to leave other members private messages on
my site. Could someone point me in the right direction for writting
something like this?
Thanks
Jeff

[Aaron [SQL Server MVP]]

Well, do you have a table to store messages? If so, I imagine it would look
something like this:

CREATE TABLE PrivateMessages
(
MessageID INT IDENTITY(1,1) PRIMARY KEY,
From INT NOT NULL FOREIGN KEY REFERENCES Users(UserID),
To INT NOT NULL FOREIGN KEY REFERENCES Users(UserID),
Message VARCHAR(8000) NOT NULL,
Read BIT NOT NULL DEFAULT 0,
dt SMALLDATETIME NOT NULL DEFAULT GETDATE()
-- maybe CHECK (From != To)?
)

Then, when a user sends a message, he picks a User (from which you can
derive UserID):

INSERT PrivateMessages(From, To, Message)
SELECT <MyUserID>, <TheirUserID>, <message>

When a user wants to see all of his messages:

SELECT MessageID, From, Message, dt
FROM PrivateMessages
WHERE To = <MyUserID>

When a user wants to see his unread messages:

SELECT MessageID, From, Message, dt
FROM PrivateMessages
WHERE To = <MyUserID>
AND Read = 0

When the user reads a message:

UPDATE PrivateMessages SET read = 1 WHERE MessageID = <MessageID>

These kinds of issues are covered fairly well in ASP-db tutorials you'll
find all over the web, btw...

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"+FarmerPickles" <gig_bam_takemeout_@verizon.net> wrote in message
news:O8E5uiwTEHA.3768@TK2MSFTNGP11.phx.gbl...

> I would like to like for members to leave other members private messages

on

> my site. Could someone point me in the right direction for writting
> something like this?
> Thanks
> Jeff
>
>

[+FarmerPickles]

ok thanks... i tried to do a search.. but didn't find anything :(

i will try what you posted


"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:%23VIYHswTEHA.2128@TK2MSFTNGP11.phx.gbl...

> Well, do you have a table to store messages? If so, I imagine it would

look

> something like this:
>
> CREATE TABLE PrivateMessages
> (
> MessageID INT IDENTITY(1,1) PRIMARY KEY,
> From INT NOT NULL FOREIGN KEY REFERENCES Users(UserID),
> To INT NOT NULL FOREIGN KEY REFERENCES Users(UserID),
> Message VARCHAR(8000) NOT NULL,
> Read BIT NOT NULL DEFAULT 0,
> dt SMALLDATETIME NOT NULL DEFAULT GETDATE()
> -- maybe CHECK (From != To)?
> )
>
> Then, when a user sends a message, he picks a User (from which you can
> derive UserID):
>
> INSERT PrivateMessages(From, To, Message)
> SELECT <MyUserID>, <TheirUserID>, <message>
>
> When a user wants to see all of his messages:
>
> SELECT MessageID, From, Message, dt
> FROM PrivateMessages
> WHERE To = <MyUserID>
>
> When a user wants to see his unread messages:
>
> SELECT MessageID, From, Message, dt
> FROM PrivateMessages
> WHERE To = <MyUserID>
> AND Read = 0
>
> When the user reads a message:
>
> UPDATE PrivateMessages SET read = 1 WHERE MessageID = <MessageID>
>
> These kinds of issues are covered fairly well in ASP-db tutorials you'll
> find all over the web, btw...
>
> --
> [url]http://www.aspfaq.com/[/url]
> (Reverse address to reply.)
>
>
>
>
> "+FarmerPickles" <gig_bam_takemeout_@verizon.net> wrote in message
> news:O8E5uiwTEHA.3768@TK2MSFTNGP11.phx.gbl...

> > I would like to like for members to leave other members private messages

> on

> > my site. Could someone point me in the right direction for writting
> > something like this?
> > Thanks
> > Jeff
> >
> >

>
>

[Jeff Cochran]

On Thu, 10 Jun 2004 12:33:36 -0400, "+FarmerPickles"
<gig_bam_takemeout_@verizon.net> wrote:

>I would like to like for members to leave other members private messages on
>my site. Could someone point me in the right direction for writting
>something like this?

Might look at some of the forum scripts, the messaging functions will
be there and most have a private setting. Should at least give you
some ideas.

Jeff

[+FarmerPickles]

Ok. I currently use snitz forums.. which i think is wonderful, but haven't
seen that feature on it. I will look into this further
thanks Jeff
Jeff


"Jeff Cochran" <jeff.nospam@zina.com> wrote in message
news:40c8d053.74068344@msnews.microsoft.com...

> On Thu, 10 Jun 2004 12:33:36 -0400, "+FarmerPickles"
> <gig_bam_takemeout_@verizon.net> wrote:
>

> >I would like to like for members to leave other members private messages

on

> >my site. Could someone point me in the right direction for writting
> >something like this?

>
> Might look at some of the forum scripts, the messaging functions will
> be there and most have a private setting. Should at least give you
> some ideas.
>
> Jeff