 |
|
|
|
|
<%if whatToDo="more" then%>
גרסת הדפסה
<%
'set conn=server.CreateObject("adodb.connection")
'conn.open "DSN=gol125.hoffman"
set rs=server.CreateObject("adodb.recordset")
sql="select * from mekorot where mekorotId="&mekorotId&" "
rs.Open sql,conn,2,2,1%>
<%rs.close
set rs=Nothing
'conn.close
'set conn=Nothing
end if %>
<%if whatToDo="update" then %>
<%
'dim conn
'set conn=server.CreateObject("adodb.connection")
'conn.open "DSN=gol125.hoffman"
dim rs, sql
set rs=server.CreateObject("adodb.recordset")
sql="select * from mekorot where mekorotId="&mekorotId&" "
rs.Open sql,conn,2,2,1
if rs("more")<>"" then
previewTxt=replace(rs("more"),chr(34),"''")
'previewTxt=replace(previewTxt,chr(39),"")
previewTxt=replace(previewTxt,vbCrlf,"")
'previewTxt=replace(previewTxt,chr(60)&chr(66)&chr(82)&chr(62),vbCrlf )
'previewTxt=rs("more")
else
previewTxt=""
end if
%>
<%
rs.close
set rs=Nothing
'conn.close
'set conn=nothing
end if %>
|
|