-
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
-
won't using left outer join instead of inner join help??
Last edited by rt_roh; 09-19-2005 at 05:59 PM.
-
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
-
Forum Rules
|
|