Avatar billede python Nybegynder
24. juli 2000 - 23:53 Der er 12 kommentarer og
1 løsning

En loop

Det er loopen det er galt med .. hvad gør jeg galt ? Den låser når jeg går ind på siden ..
Håber i forstår hvad jeg laver ;) .. ellers stil spørgsmål .. skal have det her lort til at virke ..

Source of new.asp:

<% response.Expires = 0 %>
<% response.Buffer = TRUE %>
<%
If isEmpty(Session(\"UserID\")) Then
    Response.Redirect(\"index.asp?frame=admin\")
End If
%>
<%
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database/strip.mdb\") & \";UID=admin;PWD=unga;\"
If Request.Form(\"yepper\") = \"Submit\" then

If Request.Form(\"vildu\") = \"yes\" then
\'####### Add lortet #######

Set rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open tempConn
StrSQL = \"SELECT * FROM uploads WHERE picture = \" & Request.Form(\"filename\") & \" \"
rs.Execute StrSQL
danick = rs(\"nick\")
daemail = rs(\"email\")
daurl = rs(\"url\")
datitle = rs(\"title\")
dapicture = rs(\"picture\")
dacomment = rs(\"comment\")
dadate = rs(\"date\")
datime = rs(\"time\")
rs.Close

rs.Open \"SELECT * FROM pictures WHERE (ID = 0)\",tempConn
rs.AddNew
rs(\"nick\")    = danick
rs(\"email\")  = daemail
rs(\"url\")    = daurl
rs(\"title\")  = datitle
rs(\"picture\") = dapicture
rs(\"comment\") = dacomment
rs(\"date\")    = dadate
rs(\"time\")    = datime
rs.Update
rs.Close

Set rst = Server.CreateObject(\"ADODB.Connection\")
rst.Open \"DELETE * FROM uploads where picture =\" & \"\'\" & Request.Form(\"filename\") & \"\'\" & \" \",tempConn,adOpenStatic

rst.Close
Set myConn = nothing
End If

If Request.Form(\"vildu\") = \"no\" then
\'####### Delete lortet #######
StrSql = \"DELETE * FROM uploads where picture =\" & \"\'\" & Request.Form(\"filename\") & \"\'\" & \" \"
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open tempConn
myConn.Execute(StrSql)
myConn.Close
Set myConn = nothing
End If
End If
%>
<!--#Include file=\"inc/starthtml.inc\" -->

<p align=\"center\"><b><font CLASS=\"medium\">#STRIPCOMPO2 - New Pictures</font></b></p>

<%
Set Image = Server.CreateObject(\"AspImage.Image\")
Set RS = Server.CreateObject(\"ADODB.RecordSet\")
RS.Open \"SELECT * FROM uploads\",tempConn,adOpenStatic
Do While Not rs.EOF

nick    = rs(\"nick\")
email  = rs(\"email\")
url    = rs(\"url\")
title  = rs(\"title\")
picture = rs(\"picture\")
dato    = rs(\"date\")
tid    = rs(\"time\")
comment = rs(\"comment\")

If url = \"http://\" OR url = \"\" then
url = \"No Homepage Entered.\"
End If
Image.Loadimage(\"c:\\inetpub\\wwwroot\\newstrip\\uploads\\\" & picture)
height = Image.MaxY
width = Image.MaxX
%>
<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" border=\"1\">
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><font><%=title%></font></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><img src=\"uploads/<%=picture%>\" height=\"<%=height%>\" width=\"<%=width%>\" border=\"0\"></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><font>Comment:<br><br><%=comment%></font></td>
  </tr>
    <td width=\"33%\"><a href=\"mailto:<%=email%>\"><font><%=nick%></font></a></td>
    <td width=\"33%\"><a href=\"<%=url%>\"><font><%=url%></font></a></td>
    <td width=\"34%\"><font>Added: <%=dato%> @ <%=tid%></font></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\"><form method=\"POST\" action=\"new.asp\">
  <font>Do you want to add the picture ?</font><br>
  <input type=\"radio\" value=\"yes\" checked name=\"vildu\">Yes<br>
  <input type=\"radio\" name=\"vildu\" value=\"no\">No
  <input type=\"hidden\" name=\"filename\" value=\"<%=picture%>\">
  <br><input type=\"submit\" value=\"Submit\" name=\"yepper\">
</form></td>
  </tr>
</table>
<%
rs.MoveNext
Loop
Set tempConn = nothing
Set rs = nothing
Set image = nothing

%>

<!--#Include file=\"inc/endhtml.inc\" -->
Avatar billede tue Nybegynder
25. juli 2000 - 00:13 #1
For du en fejl meddelelse ?
Avatar billede tue Nybegynder
25. juli 2000 - 00:21 #2
Har lige rettet et par småting:

<% response.expires = 0 %>
<% response.buffer = true %>
<%
If isEmpty(Session(\"UserID\")) Then
Response.Redirect(\"index.asp?frame=admin\")
End If
%>
<%
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database/strip.mdb\") & \";UID=admin;PWD=unga;\"
If Request.Form(\"yepper\") = \"Submit\" then

If Request.Form(\"vildu\") = \"yes\" then
\'####### Add lortet #######

Set rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open tempConn
StrSQL = \"SELECT * FROM uploads WHERE picture = \" & Request.Form(\"filename\") & \"\"
rs.Execute StrSQL
danick = rs(\"nick\")
daemail = rs(\"email\")
daurl = rs(\"url\")
datitle = rs(\"title\")
dapicture = rs(\"picture\")
dacomment = rs(\"comment\")
dadate = rs(\"date\")
datime = rs(\"time\")
rs.Close

rs.Open \"SELECT * FROM pictures WHERE (ID = 0)\",tempConn
rs.AddNew
rs(\"nick\")    = danick
rs(\"email\")  = daemail
rs(\"url\")    = daurl
rs(\"title\")  = datitle
rs(\"picture\") = dapicture
rs(\"comment\") = dacomment
rs(\"date\")    = dadate
rs(\"time\")    = datime
rs.Update
rs.Close

Set rst = Server.CreateObject(\"ADODB.Connection\")
rst.Open \"DELETE * FROM uploads where picture = \'\" & Request.Form(\"filename\") & \"\'\",tempConn,adOpenStatic

rst.Close
Set myConn = nothing
End If

If Request.Form(\"vildu\") = \"no\" then
\'####### Delete lortet #######
StrSql = \"DELETE * FROM uploads where picture = \'\" & Request.Form(\"filename\") & \"\'\"
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open tempConn
myConn.Execute(StrSql)
myConn.Close
Set myConn = nothing
End If
End If
%>
<!--#Include file=\"inc/starthtml.inc\" -->

<p align=\"center\"><b><font CLASS=\"medium\">#STRIPCOMPO2 - New Pictures</font></b></p>

<%
Set Image = Server.CreateObject(\"AspImage.Image\")
Set RS = Server.CreateObject(\"ADODB.RecordSet\")
RS.Open \"SELECT * FROM uploads\",tempConn,adOpenStatic
Do While Not rs.EOF

nick    = rs(\"nick\")
email  = rs(\"email\")
url    = rs(\"url\")
title  = rs(\"title\")
picture = rs(\"picture\")
dato    = rs(\"date\")
tid    = rs(\"time\")
comment = rs(\"comment\")

If url = \"http://\" OR url = \"\" then
url = \"No Homepage Entered.\"
End If
Image.Loadimage(\"c:\\inetpub\\wwwroot\\newstrip\\uploads\\\" & picture)
height = Image.MaxY
width = Image.MaxX
%>
<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" border=\"1\">
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><font><%=title%></font></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><img src=\"uploads/<%=picture%>\" height=\"<%=height%>\" width=\"<%=width%>\" border=\"0\"></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><font>Comment:<br><br><%=comment%></font></td>
  </tr>
    <td width=\"33%\"><a href=\"mailto:<%=email%>\"><font><%=nick%></font></a></td>
    <td width=\"33%\"><a href=\"<%=url%>\"><font><%=url%></font></a></td>
    <td width=\"34%\"><font>Added: <%=dato%> @ <%=tid%></font></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\"><form method=\"POST\" action=\"new.asp\">
  <font>Do you want to add the picture ?</font><br>
  <input type=\"radio\" value=\"yes\" checked name=\"vildu\">Yes<br>
  <input type=\"radio\" name=\"vildu\" value=\"no\">No
  <input type=\"hidden\" name=\"filename\" value=\"<%=picture%>\">
  <br><input type=\"submit\" value=\"Submit\" name=\"yepper\">
</form></td>
  </tr>
</table>
<%
rs.MoveNext
Loop
Set tempConn = nothing
Set rs = nothing
Set image = nothing

%>
Avatar billede tue Nybegynder
25. juli 2000 - 00:27 #3
Kunne der være mulighed for at få databasen ?

ICQ: 58548143
E-mail: tue@qcom.dk
Avatar billede sjensen Nybegynder
25. juli 2000 - 09:35 #4
For det første skal der vel være \'-tegn omkring \"filename\" når der er det andre steder:

If Request.Form(\"vildu\") = \"yes\" then
\'####### Add lortet #######

Set rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open tempConn
StrSQL = \"SELECT * FROM uploads WHERE picture = \'\" & Request.Form(\"filename\") & \"\'\"

Dernæst bemærker jeg at du bruger RS... til connecyion men rs... til loopkontrol. Mit kendskab til ASP er ikke så avanceret endnu, men kan det have noget med store/små bogstaver at gøre ?

Desuden har du et </form> tag midt i loopet, og det skal vel ikke være der:

</form></td>
  </tr>
</table>

Avatar billede ricardo Nybegynder
25. juli 2000 - 10:31 #5
sjensen har ret, du skal have plinger omkring din \"filename\".

Der er ged i disse linier:

Set rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open tempConn
StrSQL = \"SELECT * FROM uploads WHERE picture = \" & Request.Form(\"filename\") & \"\"

prøv det her:

\'nogle constants, hvis du har brug for dem - ellers kan du hente adovbs.inc fra MS.
Const adOpenForwardOnly = 0
Const adLockOptimistic = 3
Const adCmdTable = &H0002

Set nc = Server.CreateObject(\"ADODB.Connection\")
StrSQL = \"SELECT * FROM uploads WHERE picture = \'\" & Request.Form(\"filename\") & \"\'\"

Set rs = Server.CreateObject(\"ADODB.Recordset\")

rs.Open strSQL ,cn, adOpenForwardOnly, adLockOptimistic, adCmdTable

Avatar billede ricardo Nybegynder
25. juli 2000 - 10:32 #6
Ups!

Set nc = Server.CreateObject(\"ADODB.Connection\")

burde være

Set cn = Server.CreateObject(\"ADODB.Connection\")
Avatar billede runesoft Nybegynder
25. juli 2000 - 10:56 #7
Hvor mange billeder har du?

Nu har jeg ikke brugt AspImage, men gør følgende at billedet bliver hentet ind i hukommelsen?
Image.Loadimage(\"c:\\inetpub\\wwwroot\\newstrip\\uploads\\\" & picture)
Så gælder det at:
Du åbner jo ALLE billeder og finder størrelserne. Når du samtidigt har sat response.buffer = TRUE, så er det vel klart at scriptet tager et stykke tid at eksekvere.

Jeg ville nok gemme størrelserne i databasen og derved opnå lidt mere hastighed.
Avatar billede python Nybegynder
25. juli 2000 - 23:36 #8
der ligger 3 små billeder der lige nu..

jeg booter lige op i 2000 og prøver nogle af de mange forslag...
Avatar billede python Nybegynder
25. juli 2000 - 23:58 #9
ingenting af det i gjorde hjalp .. jeg har fjernet alt koden undtagen loopet og den låser stadig .. så det er loopet det er galt med ..
Avatar billede python Nybegynder
26. juli 2000 - 00:01 #10
okay 1 billede ligger der nu ..

databases table uploads ser sådan ud:

ID - nick - email - url - title - picture - date - time - comment

og der er data i alle felter til det ene billede ..
plz help
Avatar billede python Nybegynder
26. juli 2000 - 00:02 #11
Source:

<% response.expires = 0 %>
<% response.buffer = true %>
<%
If isEmpty(Session(\"UserID\")) Then
Response.Redirect(\"index.asp?frame=admin\")
End If
%>
<%
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database/strip.mdb\") & \";UID=admin;PWD=unga;\"
If Request.Form(\"yepper\") = \"Submit\" then

If Request.Form(\"vildu\") = \"yes\" then
\'####### Add lortet #######

Set rs = Server.CreateObject(\"ADODB.Connection\")
rs.Open tempConn
StrSQL = \"SELECT * FROM uploads WHERE picture = \'\" & Request.Form(\"filename\") & \"\'\"
rs.Execute StrSQL
danick = rs(\"nick\")
daemail = rs(\"email\")
daurl = rs(\"url\")
datitle = rs(\"title\")
dapicture = rs(\"picture\")
dacomment = rs(\"comment\")
dadate = rs(\"date\")
datime = rs(\"time\")
rs.Close

rs.Open \"SELECT * FROM pictures WHERE (ID = 0)\",tempConn
rs.AddNew
rs(\"nick\")    = danick
rs(\"email\")  = daemail
rs(\"url\")    = daurl
rs(\"title\")  = datitle
rs(\"picture\") = dapicture
rs(\"comment\") = dacomment
rs(\"date\")    = dadate
rs(\"time\")    = datime
rs.Update
rs.Close

Set rst = Server.CreateObject(\"ADODB.Connection\")
rst.Open \"DELETE * FROM uploads where picture = \'\" & Request.Form(\"filename\") & \"\'\",tempConn,adOpenStatic

rst.Close
Set myConn = nothing
End If

If Request.Form(\"vildu\") = \"no\" then
\'####### Delete lortet #######
StrSql = \"DELETE * FROM uploads where picture = \'\" & Request.Form(\"filename\") & \"\'\"
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open tempConn
myConn.Execute(StrSql)
myConn.Close
Set myConn = nothing
End If
End If
%>
<!--#Include file=\"inc/starthtml.inc\" -->

<p align=\"center\"><b><font CLASS=\"medium\">#STRIPCOMPO2 - New Pictures</font></b></p>

<%
Set Image = Server.CreateObject(\"AspImage.Image\")
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
rs.Open \"SELECT * FROM uploads\",tempConn,adOpenStatic
Do While Not rs.EOF

nick    = rs(\"nick\")
email  = rs(\"email\")
url    = rs(\"url\")
title  = rs(\"title\")
picture = rs(\"picture\")
dato    = rs(\"date\")
tid    = rs(\"time\")
comment = rs(\"comment\")

If url = \"http://\" OR url = \"\" then
url = \"No Homepage Entered.\"
End If
Image.Loadimage(\"c:\\inetpub\\wwwroot\\newstrip\\uploads\\\" & picture)
height = Image.MaxY
width = Image.MaxX
%>
<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\" border=\"1\">
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><font><%=title%></font></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><img src=\"uploads/<%=picture%>\" height=\"<%=height%>\" width=\"<%=width%>\" border=\"0\"></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\" align=\"center\"><font>Comment:<br><br><%=comment%></font></td>
  </tr>
    <td width=\"33%\"><a href=\"mailto:<%=email%>\"><font><%=nick%></font></a></td>
    <td width=\"33%\"><a href=\"<%=url%>\"><font><%=url%></font></a></td>
    <td width=\"34%\"><font>Added: <%=dato%> @ <%=tid%></font></td>
  </tr>
  <tr>
    <td width=\"100%\" colspan=\"3\"><form method=\"POST\" action=\"new.asp\">
  <font>Do you want to add the picture ?</font><br>
  <input type=\"radio\" value=\"yes\" checked name=\"vildu\">Yes<br>
  <input type=\"radio\" name=\"vildu\" value=\"no\">No
  <input type=\"hidden\" name=\"filename\" value=\"<%=picture%>\">
  <br><input type=\"submit\" value=\"Submit\" name=\"yepper\">
</form></td>
  </tr>
</table>
<%
rs.MoveNext
Loop
Set tempConn = nothing
Set rs = nothing
Set image = nothing

%>
<!--#Include file=\"inc/endhtml.inc\" -->
Avatar billede thomas-sp2k Nybegynder
28. juli 2000 - 15:49 #12
python -->

Hvis du ikke har fået det til at virke vil jeg gerne se om jeg kan hjælpe dig !

Bare send filen / filerne til min email !

Husk også Databasen !

/Thomas
thomas@southpark2k.dk
Avatar billede python Nybegynder
12. oktober 2000 - 03:14 #13
:\\
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester