Results 1 to 3 of 3

Thread: problem with SQL

  1. #1
    Join Date
    Sep 2005
    Posts
    3

    problem with SQL

    Dear all
    actually i made FAQ web page this web page will content questions title and form applet for add question and title
    if i press on question i will get FAQ details but i have problem let us see it
    this is the main page
    http://nono4nono.jeeran.com/1KKKKKK.JPG
    when i press on the question i will get detail
    http://nono4nono.jeeran.com/1KKKKKK%20(1).JPG
    but there are some question like
    http://nono4nono.jeeran.com/1KKKKKK%20(2).JPG
    when i press on the question i will get error page
    http://nono4nono.jeeran.com/1KKKKKK%20(3).JPG
    ---------
    in fact i know the problem the database content two table
    faq(faqid,faqtitle,faqbody)
    reply(faqid,replyid,reply)

    when i press on the question i will forword to faqdetails
    in this page i used this statement

    dim id
    id = Request.QueryString("faqid")
    selectSQL="select faq.faqtitle, faq.faqbody, reply.reply FROM faq INNER JOIN reply ON faq.faqid = reply.faqid where faq.faqid and reply.faqid ="&id

    set rs=con.execute(selectSQL)


    the problem here
    faq.faqid = reply.faqid

    because when i create new question the reply table will not has any value in faqid

    so what can i do please

  2. #2
    Join Date
    Aug 2005
    Posts
    29
    won't using left outer join instead of inner join help??
    Last edited by rt_roh; 09-19-2005 at 05:59 PM.

  3. #3
    Join Date
    Sep 2005
    Posts
    3
    so what can i do i am not good in sql statement i can understand but i don't know how can i write it
    so kindly help about this statement
    the full statment what is look like

    you can download the project from the link
    http://9q9q.com/get.php?filename=1127253788.zip

    my regards
    Last edited by abo_ashwaag; 09-20-2005 at 05:05 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •