Re: Webdb message board
From: Zdenek Zavadil <zzavadil_at_my-deja.com>
Date: Tue, 14 Mar 2000 09:45:53 GMT
Message-ID: <8al1oh$do3$1_at_nnrp1.deja.com>
Date: Tue, 14 Mar 2000 09:45:53 GMT
Message-ID: <8al1oh$do3$1_at_nnrp1.deja.com>
In article <b08z4.4900$624.428018_at_news.flash.net>,
"Mark Rischard" <mrischard_at_hotmail.com> wrote:
> I am attempting to create a messge board using webdb components. I
have a
> form for entering messages and a report to vies the messages. you can
click
> on a message to enter a new message. I would like to be able to link
new
> messages to previous messages much like this newsgroup, creating a
tree
> structure. However I have not been able to pass the message_id from
the
> report to the form for creating a new message.
>
> Any ideas out there?
>
>
Hi Mark.
- Add column to SQL SELECT of your report: ('<A HREF=your_schema.form_message.show?p_arg_names=msgid&p_arg_values=' || message_id || '>Reply</A>') as "Reply"
- In the form_message select the column, into which you want to pass the message_id and as Default Value paste: #WEBDB.wwv_name_value.get_number(p_arg_names, p_arg_values, 'msgid')
Regards,
Zdenek
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Mar 14 2000 - 10:45:53 CET