Create a Select Statement for your database:
First create a connection to your database
Dim strSQL
Dim recordset
strSQL = "Select title, description from your_table" & _
"Where title=' " & title_value & " ' "and description='
" & description_value & " ' "
Then execute this script and set its value to recordset
When you successfully do this you can now display this in a table
While Not recordset.eof
Response.Write "<td>" & recordset("title") & "</td>"
Response.Write "<td>" & recordset("description") & "</td>"
Wend
This are the summary of the code...since i do not know what exactly
your page looks like...Goodluck!
On Thu, 17 Mar 2005 02:04:46 +0000 (GMT), flor bamboo
<[EMAIL PROTECTED]> wrote:
> I hope you could show me classic asp codes. I'm a beginner and I've just
> started with classic asp; i'm not yet into asp.net. thanks again.
>
> Charles Carroll <[EMAIL PROTECTED]> wrote:I recommend looking at:
> http://www.learnasp.com/freebook/learn/searchertypical.aspx
> (VB.net search example)
>
> or
> http://www.learnasp.com/freebook/learn/cs_searcher.aspx
> (C# same search example)
>
> In terms of the hyperlinks
> http://www.learnasp.com/freebook/learn/datagridtrick-manual.aspx
> has an example of a Hyperlink column that does what you want
>
>
> On Wed, 16 Mar 2005 10:16:25 -0000, floorbamboo <[EMAIL PROTECTED]>
> wrote:
> >
> >
> > I need to do a database search based on certain conditions (e.g.,
> > link.asp?key1=news&key2=local), and i also need to limit the output
> > of my db table two only two items (title, description), and that the
> > title also serve as link to the article. How should i implement
> > these? What would be the relevant codes? Thanks...
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> > ADVERTISEMENT
> >
> >
> > ________________________________
> > Yahoo! Groups Links
> >
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
> >
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> ---------------------------------
> Yahoo! Messenger - Communicate instantly..."Ping" your friends today!
> Download Messenger Now
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> ________________________________
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
