Hello..
I'm for a very long time trying to make somthing, but everytime it doesn't
work..
This is what must happend:
If i have a guestbook with 100 letters, then wath i want is that a script
distribute the letters on a page of 10 end that i have under the letters a
buttun to go to te next letters ( 11-20 ) and a button to go back if you are
not at page one. And in the middle of those 2 buttons i want to see how many
pages with letters there are, and that you kan choose a number of a page to
go to it.
It must show a bit like this
(1) (2) (3) (4) (5) Next page <-- this if you are on the first page
Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2 or
whits one you want..
It must happend with this script:
set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan=" &
CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
do until rst.eof
%>
<html>
<head>
<title>Profiel wijzigen</title>
<link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
</head>
<body topmargin="12" leftmargin="10" rightmargin="10" bottommargin="10">
<br>
<center>
<table width="400" cellpadding="0" cellspacing="1" border="0"
bgcolor="#000000">
<tr>
<td bgcolor="#000000" height="15" width="165"><font
color="#FFFFFF"><b> <%=rst("GBNickname")% ></b></font></td>
<td bgcolor="#000000" width="84" align="center"><%
sPro_ID = session("Pro_ID")
if trim(sPro_ID) = trim(request("Pro_ID")) then %>
<a
href="Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_I D")%>&Pro_ID=<%=request("Pro_ID")%>"><font
color="#FFFFFF"> Verwijderen </font></a>
<%end if%>
</td>
<td bgcolor="#000000" width="147" align="center"><font
color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
</tr>
<tr>
<td bgcolor="white" colspan="3">
<%
Bericht = rst("GBtekst")
If Bericht <> "" then
Bericht = Replace(Bericht, ">", ">")
Bericht = Replace(Bericht, "<", "<")
End if
%>
<%=Bericht%>
</td>
</tr>
</table>
</center>
</body>
</html>
<%
rst.movenext
loop
rst.close
set rst = nothing
Is there sombody how can make it for me in this script.. please don't tell
me wath i can try or can do, it wont work.. Zo please
if you know how to fix it, please make it for me..
If you can help me i wanna thank you very much!
Gr. Robert
Robert
Read these articles
http://www.aspfaq.com/show.asp?id=2120
http://www.aspfaq.com/show.asp?id=2424
"Robert" <Bla@.bla.nl> wrote in message news:dfcot2$beu$1@.news.cistron.nl...
> Hello..
> I'm for a very long time trying to make somthing, but everytime it doesn't
> work..
> This is what must happend:
> If i have a guestbook with 100 letters, then wath i want is that a script
> distribute the letters on a page of 10 end that i have under the letters a
> buttun to go to te next letters ( 11-20 ) and a button to go back if you
> are not at page one. And in the middle of those 2 buttons i want to see
> how many pages with letters there are, and that you kan choose a number of
> a page to go to it.
> It must show a bit like this
> (1) (2) (3) (4) (5) Next page <-- this if you are on the first page
> Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2
> or whits one you want..
> It must happend with this script:
> set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan="
> & CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
> do until rst.eof
> %>
> <html>
> <head>
> <title>Profiel wijzigen</title>
> <link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
> </head>
> <body topmargin="12" leftmargin="10" rightmargin="10"
> bottommargin="10">
> <br>
> <center>
> <table width="400" cellpadding="0" cellspacing="1" border="0"
> bgcolor="#000000">
> <tr>
> <td bgcolor="#000000" height="15" width="165"><font
> color="#FFFFFF"><b> <%=rst("GBNickname")% ></b></font></td>
> <td bgcolor="#000000" width="84" align="center"><%
> sPro_ID = session("Pro_ID")
> if trim(sPro_ID) = trim(request("Pro_ID")) then %>
> <a
> href="http://links.10026.com/?link=Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_I D")%>&Pro_ID=<%=request("Pro_ID")%>"><font
> color="#FFFFFF"> Verwijderen </font></a>
> <%end if%>
> </td>
> <td bgcolor="#000000" width="147" align="center"><font
> color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
> </tr>
> <tr>
> <td bgcolor="white" colspan="3">
> <%
> Bericht = rst("GBtekst")
> If Bericht <> "" then
> Bericht = Replace(Bericht, ">", ">")
> Bericht = Replace(Bericht, "<", "<")
> End if
> %>
> <%=Bericht%>
> </td>
> </tr>
> </table>
> </center>
> </body>
> </html>
> <%
> rst.movenext
> loop
> rst.close
> set rst = nothing
> Is there sombody how can make it for me in this script.. please don't tell
> me wath i can try or can do, it wont work.. Zo please
> if you know how to fix it, please make it for me..
> If you can help me i wanna thank you very much!
> Gr. Robert
>
sql
Showing posts with label everytime. Show all posts
Showing posts with label everytime. Show all posts
Tuesday, March 27, 2012
distribute in a page..
Hello..
I'm for a very long time trying to make somthing, but everytime it doesn't
work..
This is what must happend:
If i have a guestbook with 100 letters, then wath i want is that a script
distribute the letters on a page of 10 end that i have under the letters a
buttun to go to te next letters ( 11-20 ) and a button to go back if you are
not at page one. And in the middle of those 2 buttons i want to see how many
pages with letters there are, and that you kan choose a number of a page to
go to it.
It must show a bit like this
(1) (2) (3) (4) (5) Next page <-- this if you are on the first page
Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2 or
whits one you want..
It must happend with this script:
---
set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan=" &
CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
do until rst.eof
%>
<html>
<head>
<title>Profiel wijzigen</title>
<link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
</head>
<body topmargin="12" leftmargin="10" rightmargin="10" bottommargin="10">
<br>
<center>
<table width="400" cellpadding="0" cellspacing="1" border="0"
bgcolor="#000000">
<tr>
<td bgcolor="#000000" height="15" width="165"><font
color="#FFFFFF"><b> <%=rst("GBNickname")%></b></font></td>
<td bgcolor="#000000" width="84" align="center"><%
sPro_ID = session("Pro_ID")
if trim(sPro_ID) = trim(request("Pro_ID")) then %>
<a
href="Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_ID")%>&Pro_ID=<%=request("P
ro_ID")%>"><font
color="#FFFFFF"> Verwijderen </font></a>
<%end if%>
</td>
<td bgcolor="#000000" width="147" align="center"><font
color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
</tr>
<tr>
<td bgcolor="white" colspan="3">
<%
Bericht = rst("GBtekst")
If Bericht <> "" then
Bericht = Replace(Bericht, ">", ">")
Bericht = Replace(Bericht, "<", "<")
End if
%>
<%=Bericht%>
</td>
</tr>
</table>
</center>
</body>
</html>
<%
rst.movenext
loop
rst.close
set rst = nothing
---
Is there sombody how can make it for me in this script.. please don't tell
me wath i can try or can do, it wont work.. Zo please
if you know how to fix it, please make it for me..
If you can help me i wanna thank you very much!
Gr. RobertRobert
Read these articles
http://www.aspfaq.com/show.asp?id=2120
http://www.aspfaq.com/show.asp?id=2424
"Robert" <Bla@.bla.nl> wrote in message news:dfcot2$beu$1@.news.cistron.nl...
> Hello..
> I'm for a very long time trying to make somthing, but everytime it doesn't
> work..
> This is what must happend:
> If i have a guestbook with 100 letters, then wath i want is that a script
> distribute the letters on a page of 10 end that i have under the letters a
> buttun to go to te next letters ( 11-20 ) and a button to go back if you
> are not at page one. And in the middle of those 2 buttons i want to see
> how many pages with letters there are, and that you kan choose a number of
> a page to go to it.
> It must show a bit like this
> (1) (2) (3) (4) (5) Next page <-- this if you are on the first page
> Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2
> or whits one you want..
> It must happend with this script:
> ---
> set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan="
> & CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
> do until rst.eof
> %>
> <html>
> <head>
> <title>Profiel wijzigen</title>
> <link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
> </head>
> <body topmargin="12" leftmargin="10" rightmargin="10"
> bottommargin="10">
> <br>
> <center>
> <table width="400" cellpadding="0" cellspacing="1" border="0"
> bgcolor="#000000">
> <tr>
> <td bgcolor="#000000" height="15" width="165"><font
> color="#FFFFFF"><b> <%=rst("GBNickname")%></b></font></td>
> <td bgcolor="#000000" width="84" align="center"><%
> sPro_ID = session("Pro_ID")
> if trim(sPro_ID) = trim(request("Pro_ID")) then %>
> <a
> href="http://links.10026.com/?link=Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_ID")%>&Pro_ID=<%=request(
"Pro_ID")%>"><font
> color="#FFFFFF"> Verwijderen </font></a>
> <%end if%>
> </td>
> <td bgcolor="#000000" width="147" align="center"><font
> color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
> </tr>
> <tr>
> <td bgcolor="white" colspan="3">
> <%
> Bericht = rst("GBtekst")
> If Bericht <> "" then
> Bericht = Replace(Bericht, ">", ">")
> Bericht = Replace(Bericht, "<", "<")
> End if
> %>
> <%=Bericht%>
> </td>
> </tr>
> </table>
> </center>
> </body>
> </html>
> <%
> rst.movenext
> loop
> rst.close
> set rst = nothing
> ---
> Is there sombody how can make it for me in this script.. please don't tell
> me wath i can try or can do, it wont work.. Zo please
> if you know how to fix it, please make it for me..
> If you can help me i wanna thank you very much!
> Gr. Robert
>
I'm for a very long time trying to make somthing, but everytime it doesn't
work..
This is what must happend:
If i have a guestbook with 100 letters, then wath i want is that a script
distribute the letters on a page of 10 end that i have under the letters a
buttun to go to te next letters ( 11-20 ) and a button to go back if you are
not at page one. And in the middle of those 2 buttons i want to see how many
pages with letters there are, and that you kan choose a number of a page to
go to it.
It must show a bit like this
(1) (2) (3) (4) (5) Next page <-- this if you are on the first page
Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2 or
whits one you want..
It must happend with this script:
---
set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan=" &
CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
do until rst.eof
%>
<html>
<head>
<title>Profiel wijzigen</title>
<link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
</head>
<body topmargin="12" leftmargin="10" rightmargin="10" bottommargin="10">
<br>
<center>
<table width="400" cellpadding="0" cellspacing="1" border="0"
bgcolor="#000000">
<tr>
<td bgcolor="#000000" height="15" width="165"><font
color="#FFFFFF"><b> <%=rst("GBNickname")%></b></font></td>
<td bgcolor="#000000" width="84" align="center"><%
sPro_ID = session("Pro_ID")
if trim(sPro_ID) = trim(request("Pro_ID")) then %>
<a
href="Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_ID")%>&Pro_ID=<%=request("P
ro_ID")%>"><font
color="#FFFFFF"> Verwijderen </font></a>
<%end if%>
</td>
<td bgcolor="#000000" width="147" align="center"><font
color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
</tr>
<tr>
<td bgcolor="white" colspan="3">
<%
Bericht = rst("GBtekst")
If Bericht <> "" then
Bericht = Replace(Bericht, ">", ">")
Bericht = Replace(Bericht, "<", "<")
End if
%>
<%=Bericht%>
</td>
</tr>
</table>
</center>
</body>
</html>
<%
rst.movenext
loop
rst.close
set rst = nothing
---
Is there sombody how can make it for me in this script.. please don't tell
me wath i can try or can do, it wont work.. Zo please
if you know how to fix it, please make it for me..
If you can help me i wanna thank you very much!
Gr. RobertRobert
Read these articles
http://www.aspfaq.com/show.asp?id=2120
http://www.aspfaq.com/show.asp?id=2424
"Robert" <Bla@.bla.nl> wrote in message news:dfcot2$beu$1@.news.cistron.nl...
> Hello..
> I'm for a very long time trying to make somthing, but everytime it doesn't
> work..
> This is what must happend:
> If i have a guestbook with 100 letters, then wath i want is that a script
> distribute the letters on a page of 10 end that i have under the letters a
> buttun to go to te next letters ( 11-20 ) and a button to go back if you
> are not at page one. And in the middle of those 2 buttons i want to see
> how many pages with letters there are, and that you kan choose a number of
> a page to go to it.
> It must show a bit like this
> (1) (2) (3) (4) (5) Next page <-- this if you are on the first page
> Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2
> or whits one you want..
> It must happend with this script:
> ---
> set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan="
> & CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
> do until rst.eof
> %>
> <html>
> <head>
> <title>Profiel wijzigen</title>
> <link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
> </head>
> <body topmargin="12" leftmargin="10" rightmargin="10"
> bottommargin="10">
> <br>
> <center>
> <table width="400" cellpadding="0" cellspacing="1" border="0"
> bgcolor="#000000">
> <tr>
> <td bgcolor="#000000" height="15" width="165"><font
> color="#FFFFFF"><b> <%=rst("GBNickname")%></b></font></td>
> <td bgcolor="#000000" width="84" align="center"><%
> sPro_ID = session("Pro_ID")
> if trim(sPro_ID) = trim(request("Pro_ID")) then %>
> <a
> href="http://links.10026.com/?link=Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_ID")%>&Pro_ID=<%=request(
"Pro_ID")%>"><font
> color="#FFFFFF"> Verwijderen </font></a>
> <%end if%>
> </td>
> <td bgcolor="#000000" width="147" align="center"><font
> color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
> </tr>
> <tr>
> <td bgcolor="white" colspan="3">
> <%
> Bericht = rst("GBtekst")
> If Bericht <> "" then
> Bericht = Replace(Bericht, ">", ">")
> Bericht = Replace(Bericht, "<", "<")
> End if
> %>
> <%=Bericht%>
> </td>
> </tr>
> </table>
> </center>
> </body>
> </html>
> <%
> rst.movenext
> loop
> rst.close
> set rst = nothing
> ---
> Is there sombody how can make it for me in this script.. please don't tell
> me wath i can try or can do, it wont work.. Zo please
> if you know how to fix it, please make it for me..
> If you can help me i wanna thank you very much!
> Gr. Robert
>
distribute in a page..
Hello..
I'm for a very long time trying to make somthing, but everytime it doesn't
work..
This is what must happend:
If i have a guestbook with 100 letters, then wath i want is that a script
distribute the letters on a page of 10 end that i have under the letters a
buttun to go to te next letters ( 11-20 ) and a button to go back if you are
not at page one. And in the middle of those 2 buttons i want to see how many
pages with letters there are, and that you kan choose a number of a page to
go to it.
It must show a bit like this
(1) (2) (3) (4) (5) Next page <-- this if you are on the first page
Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2 or
whits one you want..
It must happend with this script:
---
set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan=" &
CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
do until rst.eof
%>
<html>
<head>
<title>Profiel wijzigen</title>
<link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
</head>
<body topmargin="12" leftmargin="10" rightmargin="10" bottommargin="10">
<br>
<center>
<table width="400" cellpadding="0" cellspacing="1" border="0"
bgcolor="#000000">
<tr>
<td bgcolor="#000000" height="15" width="165"><font
color="#FFFFFF"><b> <%=rst("GBNickname")%></b></font></td>
<td bgcolor="#000000" width="84" align="center"><%
sPro_ID = session("Pro_ID")
if trim(sPro_ID) = trim(request("Pro_ID")) then %>
<a
href="http://links.10026.com/?link=Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_ID")%>&Pro_ID=<%=request("Pro_ID")%>"><font
color="#FFFFFF"> Verwijderen </font></a>
<%end if%>
</td>
<td bgcolor="#000000" width="147" align="center"><font
color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
</tr>
<tr>
<td bgcolor="white" colspan="3">
<%
Bericht = rst("GBtekst")
If Bericht <> "" then
Bericht = Replace(Bericht, ">", ">")
Bericht = Replace(Bericht, "<", "<")
End if
%>
<%=Bericht%>
</td>
</tr>
</table>
</center>
</body>
</html>
<%
rst.movenext
loop
rst.close
set rst = nothing
---
Is there sombody how can make it for me in this script.. please don't tell
me wath i can try or can do, it wont work.. Zo please
if you know how to fix it, please make it for me..
If you can help me i wanna thank you very much!
Gr. RobertRobert
Read these articles
http://www.aspfaq.com/show.asp?id=2120
http://www.aspfaq.com/show.asp?id=2424
"Robert" <Bla@.bla.nl> wrote in message news:dfcot2$beu$1@.news.cistron.nl...
> Hello..
> I'm for a very long time trying to make somthing, but everytime it doesn't
> work..
> This is what must happend:
> If i have a guestbook with 100 letters, then wath i want is that a script
> distribute the letters on a page of 10 end that i have under the letters a
> buttun to go to te next letters ( 11-20 ) and a button to go back if you
> are not at page one. And in the middle of those 2 buttons i want to see
> how many pages with letters there are, and that you kan choose a number of
> a page to go to it.
> It must show a bit like this
> (1) (2) (3) (4) (5) Next page <-- this if you are on the first page
> Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2
> or whits one you want..
> It must happend with this script:
> ---
> set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan="
> & CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
> do until rst.eof
> %>
> <html>
> <head>
> <title>Profiel wijzigen</title>
> <link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
> </head>
> <body topmargin="12" leftmargin="10" rightmargin="10"
> bottommargin="10">
> <br>
> <center>
> <table width="400" cellpadding="0" cellspacing="1" border="0"
> bgcolor="#000000">
> <tr>
> <td bgcolor="#000000" height="15" width="165"><font
> color="#FFFFFF"><b> <%=rst("GBNickname")%></b></font></td>
> <td bgcolor="#000000" width="84" align="center"><%
> sPro_ID = session("Pro_ID")
> if trim(sPro_ID) = trim(request("Pro_ID")) then %>
> <a
> href="http://links.10026.com/?link=Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_ID")%>&Pro_ID=<%=request("Pro_ID")%>"><font
> color="#FFFFFF"> Verwijderen </font></a>
> <%end if%>
> </td>
> <td bgcolor="#000000" width="147" align="center"><font
> color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
> </tr>
> <tr>
> <td bgcolor="white" colspan="3">
> <%
> Bericht = rst("GBtekst")
> If Bericht <> "" then
> Bericht = Replace(Bericht, ">", ">")
> Bericht = Replace(Bericht, "<", "<")
> End if
> %>
> <%=Bericht%>
> </td>
> </tr>
> </table>
> </center>
> </body>
> </html>
> <%
> rst.movenext
> loop
> rst.close
> set rst = nothing
> ---
> Is there sombody how can make it for me in this script.. please don't tell
> me wath i can try or can do, it wont work.. Zo please
> if you know how to fix it, please make it for me..
> If you can help me i wanna thank you very much!
> Gr. Robert
>
I'm for a very long time trying to make somthing, but everytime it doesn't
work..
This is what must happend:
If i have a guestbook with 100 letters, then wath i want is that a script
distribute the letters on a page of 10 end that i have under the letters a
buttun to go to te next letters ( 11-20 ) and a button to go back if you are
not at page one. And in the middle of those 2 buttons i want to see how many
pages with letters there are, and that you kan choose a number of a page to
go to it.
It must show a bit like this
(1) (2) (3) (4) (5) Next page <-- this if you are on the first page
Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2 or
whits one you want..
It must happend with this script:
---
set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan=" &
CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
do until rst.eof
%>
<html>
<head>
<title>Profiel wijzigen</title>
<link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
</head>
<body topmargin="12" leftmargin="10" rightmargin="10" bottommargin="10">
<br>
<center>
<table width="400" cellpadding="0" cellspacing="1" border="0"
bgcolor="#000000">
<tr>
<td bgcolor="#000000" height="15" width="165"><font
color="#FFFFFF"><b> <%=rst("GBNickname")%></b></font></td>
<td bgcolor="#000000" width="84" align="center"><%
sPro_ID = session("Pro_ID")
if trim(sPro_ID) = trim(request("Pro_ID")) then %>
<a
href="http://links.10026.com/?link=Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_ID")%>&Pro_ID=<%=request("Pro_ID")%>"><font
color="#FFFFFF"> Verwijderen </font></a>
<%end if%>
</td>
<td bgcolor="#000000" width="147" align="center"><font
color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
</tr>
<tr>
<td bgcolor="white" colspan="3">
<%
Bericht = rst("GBtekst")
If Bericht <> "" then
Bericht = Replace(Bericht, ">", ">")
Bericht = Replace(Bericht, "<", "<")
End if
%>
<%=Bericht%>
</td>
</tr>
</table>
</center>
</body>
</html>
<%
rst.movenext
loop
rst.close
set rst = nothing
---
Is there sombody how can make it for me in this script.. please don't tell
me wath i can try or can do, it wont work.. Zo please
if you know how to fix it, please make it for me..
If you can help me i wanna thank you very much!
Gr. RobertRobert
Read these articles
http://www.aspfaq.com/show.asp?id=2120
http://www.aspfaq.com/show.asp?id=2424
"Robert" <Bla@.bla.nl> wrote in message news:dfcot2$beu$1@.news.cistron.nl...
> Hello..
> I'm for a very long time trying to make somthing, but everytime it doesn't
> work..
> This is what must happend:
> If i have a guestbook with 100 letters, then wath i want is that a script
> distribute the letters on a page of 10 end that i have under the letters a
> buttun to go to te next letters ( 11-20 ) and a button to go back if you
> are not at page one. And in the middle of those 2 buttons i want to see
> how many pages with letters there are, and that you kan choose a number of
> a page to go to it.
> It must show a bit like this
> (1) (2) (3) (4) (5) Next page <-- this if you are on the first page
> Prevous page (1) (2) (3) (4) (5) next page <-- this if you are on page 2
> or whits one you want..
> It must happend with this script:
> ---
> set rst = cnn.execute("SELECT * FROM tblGastenboek WHERE Gb_Pro_ID_Aan="
> & CheckDBNum(Request("Pro_ID")) & " ORDER BY Gb_ID DESC ")
> do until rst.eof
> %>
> <html>
> <head>
> <title>Profiel wijzigen</title>
> <link rel="stylesheet" type="text/css" href="http://links.10026.com/?link=Style/Default.css">
> </head>
> <body topmargin="12" leftmargin="10" rightmargin="10"
> bottommargin="10">
> <br>
> <center>
> <table width="400" cellpadding="0" cellspacing="1" border="0"
> bgcolor="#000000">
> <tr>
> <td bgcolor="#000000" height="15" width="165"><font
> color="#FFFFFF"><b> <%=rst("GBNickname")%></b></font></td>
> <td bgcolor="#000000" width="84" align="center"><%
> sPro_ID = session("Pro_ID")
> if trim(sPro_ID) = trim(request("Pro_ID")) then %>
> <a
> href="http://links.10026.com/?link=Gastenboek.asp?ACTION=DELETE&ID=<%=rst("GB_ID")%>&Pro_ID=<%=request("Pro_ID")%>"><font
> color="#FFFFFF"> Verwijderen </font></a>
> <%end if%>
> </td>
> <td bgcolor="#000000" width="147" align="center"><font
> color="#FFFFFF"><b><%=rst("GBDatum")%></b></font></td>
> </tr>
> <tr>
> <td bgcolor="white" colspan="3">
> <%
> Bericht = rst("GBtekst")
> If Bericht <> "" then
> Bericht = Replace(Bericht, ">", ">")
> Bericht = Replace(Bericht, "<", "<")
> End if
> %>
> <%=Bericht%>
> </td>
> </tr>
> </table>
> </center>
> </body>
> </html>
> <%
> rst.movenext
> loop
> rst.close
> set rst = nothing
> ---
> Is there sombody how can make it for me in this script.. please don't tell
> me wath i can try or can do, it wont work.. Zo please
> if you know how to fix it, please make it for me..
> If you can help me i wanna thank you very much!
> Gr. Robert
>
Monday, March 19, 2012
Displaying SQL Statement as output on report
The requirements of Sarbanes-Oxley are getting downright outrageous.
Everytime we run a report, we need to verify that the SQL statement has not
been modified since it was last verified as accurate. To combat the constant
requests to show the SQL behind the scenes, I would like to show the SQL as
part of the report.
Is this possible and how would it be done?
I am guessing that it would require custom code that captures the SQL in a
variable and then outputs that variable into the report.Could you get away with driving each report by a seperate stored procedure
( this is what we do anyway ).
Tell them the name of the stored procedure for each report.
If they want to go the extra paranoid step :
Write a custom assembly which uses sp_helptext on the stored proc name to
get the text of the storedproc ( a line at a time )
Generate a SHA1 hash of the text ( you might want to ignore whitespace and
non alphanumeric characters )
Write to some custom reportlog file, reportname, who ran, when, on what
machine, the hash of the procedure name
( Of course you need to record somewhere the hash of the stored procedure
when its verified )
You could even throw an exception if hash doesnt match the last verified
hash.
If thats not good enough ( !! ) you could encrypt the hash with a private
key, i.e. give it a full digital signature.
Or you could just generate a hash of the entire db schema !!
> Everytime we run a report, we need to verify that the SQL statement has
> not
> been modified since it was last verified as accurate.|||I would think the best thing to do is to put everything in SP. Then you have
the date the SP was created and can compare that against when it was
verified. If you keep the date of verification in a table you can then run a
report that shows any unverified SP based on the creation date. This seems
to me to be a much better solution. Straight forward and verifiable (which
is usually what you need for Sarbanes-Oxley).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <David@.discussions.microsoft.com> wrote in message
news:4C2307F6-5002-4713-8B92-DC9A468FFEF2@.microsoft.com...
> The requirements of Sarbanes-Oxley are getting downright outrageous.
> Everytime we run a report, we need to verify that the SQL statement has
not
> been modified since it was last verified as accurate. To combat the
constant
> requests to show the SQL behind the scenes, I would like to show the SQL
as
> part of the report.
> Is this possible and how would it be done?
> I am guessing that it would require custom code that captures the SQL in a
> variable and then outputs that variable into the report.
Everytime we run a report, we need to verify that the SQL statement has not
been modified since it was last verified as accurate. To combat the constant
requests to show the SQL behind the scenes, I would like to show the SQL as
part of the report.
Is this possible and how would it be done?
I am guessing that it would require custom code that captures the SQL in a
variable and then outputs that variable into the report.Could you get away with driving each report by a seperate stored procedure
( this is what we do anyway ).
Tell them the name of the stored procedure for each report.
If they want to go the extra paranoid step :
Write a custom assembly which uses sp_helptext on the stored proc name to
get the text of the storedproc ( a line at a time )
Generate a SHA1 hash of the text ( you might want to ignore whitespace and
non alphanumeric characters )
Write to some custom reportlog file, reportname, who ran, when, on what
machine, the hash of the procedure name
( Of course you need to record somewhere the hash of the stored procedure
when its verified )
You could even throw an exception if hash doesnt match the last verified
hash.
If thats not good enough ( !! ) you could encrypt the hash with a private
key, i.e. give it a full digital signature.
Or you could just generate a hash of the entire db schema !!
> Everytime we run a report, we need to verify that the SQL statement has
> not
> been modified since it was last verified as accurate.|||I would think the best thing to do is to put everything in SP. Then you have
the date the SP was created and can compare that against when it was
verified. If you keep the date of verification in a table you can then run a
report that shows any unverified SP based on the creation date. This seems
to me to be a much better solution. Straight forward and verifiable (which
is usually what you need for Sarbanes-Oxley).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <David@.discussions.microsoft.com> wrote in message
news:4C2307F6-5002-4713-8B92-DC9A468FFEF2@.microsoft.com...
> The requirements of Sarbanes-Oxley are getting downright outrageous.
> Everytime we run a report, we need to verify that the SQL statement has
not
> been modified since it was last verified as accurate. To combat the
constant
> requests to show the SQL behind the scenes, I would like to show the SQL
as
> part of the report.
> Is this possible and how would it be done?
> I am guessing that it would require custom code that captures the SQL in a
> variable and then outputs that variable into the report.
Subscribe to:
Posts (Atom)