%@ Language=VBScript %>
<%
'שליפת נתוני הערך מכל הטבלות הרלוונטיות כדי להציג את נתוניו. הטבלאות הן
'value, value_user, site_search, more
'(אולי גם קטגוריה)
set rsValue=Server.CreateObject("adodb.recordset")
sqlstr="select * from ency_value1 where id="&killchars(Request("id1"))
rsValue.Open sqlstr ,con,3,3
rsValue.MoveFirst
Sub ktov(x)
zmani=x
while InStr(1,zmani,chr(13))>0
zmani=left(zmani,InStr(1,zmani,chr(13))-1)&" "&mid(zmani,InStr(1,zmani,chr(13))+1)
wend
Response.Write(zmani)
end Sub
%>
אנציקלופדיה יהודית דעת -
<%=rsValue.Fields("title")%>
;
")
Response.Write(" ")
end if
ktov(rsValue.Fields("text"))
if rsValue.Fields("auther")<>"" then Response.Write("
מקור הערך: "&rsValue.Fields("auther")&"
")
set rsUser=Server.CreateObject("adodb.recordset")
sqlstr="select * from ency_value_user where status=1 and value_id="&killchars(Request("id1"))
'Response.Write(" sqlstr="&sqlstr)
'Response.Write(sqlstr)
rsUser.Open sqlstr ,con,3,3
if not rsUser.BOF then
rsUser.MoveFirst
Response.Write("
הערות לערך: ")
do until rsUser.EOF
Response.Write(" שם המעיר: ")
Response.Write(rsUser.Fields("auther"))
Response.Write(" הערה: ")
ktov(rsUser.Fields("text"))
if rsUser.Fields("source")<>"" then
Response.Write(" מקור ההערה: ")
Response.Write(rsUser.Fields("source"))
end if
if rsUser.Fields("http1")<>"" then
Response.Write(" לעיון נוסף: ")
Response.Write("")
Response.Write(rsUser.Fields("http1_text")&" ")
end if
if rsUser.Fields("http2")<>"" then
Response.Write("")
Response.Write(rsUser.Fields("http2_text")&" ")
end if
Response.Write(" ")
rsUser.movenext
loop
end if
rsUser.Close
set rsUser = nothing
%>
יש לך מה להוסיף או להעיר?
&value_name='<%=rsValue.Fields("title")%>'>לחץ כאן
<%
if rsValue.Fields("picture")<>"" then Response.Write(" ")
if rsValue.Fields("picture_text")<>"" then Response.Write(""&rsValue.Fields("picture_text")&"")
set rsMore=Server.CreateObject("adodb.recordset")
sqlstr="select * from ency_more where value_id="&killchars(Request("id1"))
rsMore.Open sqlstr ,con,3,3
moreflag=0
if not rsMore.BOF then
rsmore.MoveFirst
Response.Write("
")
Response.Write("
")
Response.Write("
ערכים קרובים
")
Response.Write("
")
Response.Write("
")
moreflag=1
do until rsMore.EOF
Response.Write(""&rsMore.Fields("more_name")&" ")
rsMore.movenext
loop
' Response.Write("
")
' Response.Write("
")
end if
rsMore.Close
set rsMore=Server.CreateObject("adodb.recordset")
sqlstr="select * from ency_more where more_id="&killchars(Request("id1"))
rsMore.Open sqlstr ,con,3,3
if not rsMore.BOF then
rsMore.MoveFirst
if moreflag=0 then
Response.Write("
")
Response.Write("
")
Response.Write("
ערכים קרובים
")
Response.Write("
")
Response.Write("
")
moreflag=1
end if
do until rsMore.EOF
Response.Write(""&rsMore.Fields("value_name")&" ")
rsMore.movenext
loop
end if
if moreflag=1 then
Response.Write("
")
Response.Write("
")
end if
%>
<%
set rsSite=Server.CreateObject("adodb.recordset")
sqlstr="select * from ency_site_search where value_id="&killchars(Request("id1"))
rsSite.Open sqlstr ,con,3,3
if not rsSite.BOF then
rsSite.MoveFirst
Response.Write("
")
end if
rsSite.Close
set rsSite = nothing
set rsBook=Server.CreateObject("adodb.recordset")
sqlstr="select * from pdf_main where ency1="&killchars(Request("id1"))&" or ency2="&killchars(Request("id1"))
rsBook.Open sqlstr ,con,3,3
set rsBook2=Server.CreateObject("adodb.recordset")
sqlstr="select * from book_ency_title where ency_id="&killchars(Request("id1"))&" order by id"
rsBook2.Open sqlstr ,con,3,3
if not rsBook.BOF or not rsBook2.BOF then
Response.Write("
")
Response.Write("
")
Response.Write("
ספרים בטקסט מלא
")
Response.Write("
")
Response.Write("
")
if not rsBook.BOF then
rsBook.MoveFirst
do until rsBook.EOF
Response.Write(""&rsBook.Fields("title1")&" ")
rsBook.movenext
loop
rsBook.Close
end if
if not rsBook2.BOF then
rsBook2.MoveFirst
do until rsBook2.EOF
Response.Write(""&rsBook2.Fields("book_title")&" ")
rsBook2.movenext
loop
rsBook2.Close
end if
' sqlstr="select * from book_ency_title where ency_id="&killchars(Request("id1"))
' rsBook.Open sqlstr ,con,3,3
' do until rsBook.EOF
' Response.Write(""&rsBook.Fields("book_title")&" ")
' rsBook.movenext
' loop
Response.Write("