Avatar billede phuc69 Juniormester
04. maj 2004 - 11:56 Der er 28 kommentarer og
1 løsning

Tilføj endnu et felt i databasen

Jeg har fundet følgende kode på netcoders på et eller andet tidspunkt. Nu vil jeg gerne have at man ikke kun oploader den udpegede fil og text area, men også forfatter navn. Hvordan gør jeg det. Gerne med en forklaring på tilføjelsen.
Avatar billede phuc69 Juniormester
04. maj 2004 - 11:56 #1
Her er koden


<%
Response.expires = 0
Response.expiresabsolute = Now() - 1
Response.addHeader "pragma", "no-cache"
Response.addHeader "cache-control", "private"
Response.CacheControl = "no-cache"
response.buffer = true
Response.Clear

key = request.querystring("key")

If key = 1 then
byteCount = Request.TotalBytes
RequestBin = Request.BinaryRead(byteCount)
Dim UploadRequest
Set UploadRequest = CreateObject("Scripting.Dictionary")
BuildUploadRequest(RequestBin)
contentType = UploadRequest.Item("blob").Item("ContentType")
filepathname = UploadRequest.Item("blob").Item("FileName")
filename = Right(filepathname,Len(filepathname)-InstrRev(filepathname,"\"))
value = UploadRequest.Item("blob").Item("Value")
Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject")
Set MyFile = ScriptObject.CreateTextFile(Server.mappath("sup/"&filename))
For i = 1 to LenB(value)
MyFile.Write chr(AscB(MidB(value,i,1)))
Next
MyFile.Close   
Sub BuildUploadRequest(RequestBin)
  PosBeg = 1
  PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(13)))
  boundary = MidB(RequestBin,PosBeg,PosEnd-PosBeg)
  boundaryPos = InstrB(1,RequestBin,boundary)
  Do until (boundaryPos=InstrB(RequestBin,boundary & getByteString("--")))
  Dim UploadControl
  Set UploadControl = CreateObject("Scripting.Dictionary")
  Pos = InstrB(BoundaryPos,RequestBin,getByteString("Content-Disposition"))
  Pos = InstrB(Pos,RequestBin,getByteString("name="))
  PosBeg = Pos+6
  PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(34)))
  Name = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
  PosFile = InstrB(BoundaryPos,RequestBin,getByteString("filename="))
  PosBound = InstrB(PosEnd,RequestBin,boundary)
    If  PosFile<>0 AND (PosFile<PosBound) Then
    PosBeg = PosFile + 10
    PosEnd =  InstrB(PosBeg,RequestBin,getByteString(chr(34)))
    FileName = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    UploadControl.Add "FileName", FileName
    Pos = InstrB(PosEnd,RequestBin,getByteString("Content-Type:"))
    PosBeg = Pos+14
    PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(13)))
    ContentType = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    UploadControl.Add "ContentType",ContentType
    PosBeg = PosEnd+4
    PosEnd = InstrB(PosBeg,RequestBin,boundary)-2
    Value = MidB(RequestBin,PosBeg,PosEnd-PosBeg)
    Else
    Pos = InstrB(Pos,RequestBin,getByteString(chr(13)))
    PosBeg = Pos+4
    PosEnd = InstrB(PosBeg,RequestBin,boundary)-2
    Value = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    End If
    UploadControl.Add "Value" , Value   
    UploadRequest.Add name, UploadControl   
    BoundaryPos=InstrB(BoundaryPos+LenB(boundary),RequestBin,boundary)
  Loop
End Sub
Function getByteString(StringStr)
  For i = 1 to Len(StringStr)
  char = Mid(StringStr,i,1)
  getByteString = getByteString & chrB(AscB(char))
  Next
End Function
Function getString(StringBin)
  getString =""
  For intCount = 1 to LenB(StringBin)
  getString = getString & chr(AscB(MidB(StringBin,intCount,1)))
  Next
End Function

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tutorial.mdb")
strsql = "SELECT * FROM [Frames]"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 1, 2
rs.AddNew
rs("frame1") = filename
rs("frame2") = Request.Cookies("tekst")
 

rs.Update
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Response.Clear
Response.Redirect "administration.htm"
End if
%>

<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css">
 
<title>Ny support side</title>

  <script language="JavaScript">
  function SetCookie (name, value) {var argv = SetCookie.arguments;var argc = SetCookie.arguments.length;var expires = (argc > 2) ? argv[2] : null;var path = (argc > 3) ? argv[3] : null;var domain = (argc > 4) ? argv[4] : null;var secure = (argc > 5) ? argv[5] : false;document.cookie = name + "=" + escape (value) + ((expires == null) ? "" : ("; expires=" + expires.toGMTString())) + ((path == null) ? "" : ("; path=" + path)) + ((domain == null) ? "" : ("; domain=" + domain)) + ((secure == true) ? "; secure" : "")}
  function set_name(form) {var expdate = new Date ();expdate.setTime (expdate.getTime() + (24 * 60 * 60 * 1000 * 31));
  var tekst = form3.y_tekst.value;SetCookie ("tekst", tekst, expdate)
 
 
}
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin=0 topmargin=0 marginheight=0 marginwidth=0>
  <form METHOD='Post' ENCTYPE='multipart/form-data' ACTION='nysupport.asp?key=1' id='form3' name='form3' onSubmit="return set_name(this.form);">
<h2>Skriv En kommentar og udpeg stien til dit dokument</h2> 
<textarea cols='30' rows='8' name="y_tekst"></textarea><br>

   
  <input TYPE="file" NAME="blob" class="input">
  <input TYPE="submit" value="UDFØR" NAME="Enter">
  </form>
</BODY>
</HTML>
Avatar billede and_ Nybegynder
04. maj 2004 - 13:04 #2
Dette skulle vist kunne gøre det....

Vi har tilføjet et tekst-felt mere, hvorpå når formen sendes indlæses forfatternavnet i en cookie, som vi henter ud igen, når dataerne skal ind i databasen...

Jeg har kaldt posten frame3, fordi dine andre poster hedder frame1 og frame2, ellers skal du selv rette dette til ;)

Kode:

<%
Response.expires = 0
Response.expiresabsolute = Now() - 1
Response.addHeader "pragma", "no-cache"
Response.addHeader "cache-control", "private"
Response.CacheControl = "no-cache"
response.buffer = true
Response.Clear

key = request.querystring("key")

If key = 1 then
byteCount = Request.TotalBytes
RequestBin = Request.BinaryRead(byteCount)
Dim UploadRequest
Set UploadRequest = CreateObject("Scripting.Dictionary")
BuildUploadRequest(RequestBin)
contentType = UploadRequest.Item("blob").Item("ContentType")
filepathname = UploadRequest.Item("blob").Item("FileName")
filename = Right(filepathname,Len(filepathname)-InstrRev(filepathname,"\"))
value = UploadRequest.Item("blob").Item("Value")
Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject")
Set MyFile = ScriptObject.CreateTextFile(Server.mappath("sup/"&filename))
For i = 1 to LenB(value)
MyFile.Write chr(AscB(MidB(value,i,1)))
Next
MyFile.Close   
Sub BuildUploadRequest(RequestBin)
  PosBeg = 1
  PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(13)))
  boundary = MidB(RequestBin,PosBeg,PosEnd-PosBeg)
  boundaryPos = InstrB(1,RequestBin,boundary)
  Do until (boundaryPos=InstrB(RequestBin,boundary & getByteString("--")))
  Dim UploadControl
  Set UploadControl = CreateObject("Scripting.Dictionary")
  Pos = InstrB(BoundaryPos,RequestBin,getByteString("Content-Disposition"))
  Pos = InstrB(Pos,RequestBin,getByteString("name="))
  PosBeg = Pos+6
  PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(34)))
  Name = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
  PosFile = InstrB(BoundaryPos,RequestBin,getByteString("filename="))
  PosBound = InstrB(PosEnd,RequestBin,boundary)
    If  PosFile<>0 AND (PosFile<PosBound) Then
    PosBeg = PosFile + 10
    PosEnd =  InstrB(PosBeg,RequestBin,getByteString(chr(34)))
    FileName = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    UploadControl.Add "FileName", FileName
    Pos = InstrB(PosEnd,RequestBin,getByteString("Content-Type:"))
    PosBeg = Pos+14
    PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(13)))
    ContentType = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    UploadControl.Add "ContentType",ContentType
    PosBeg = PosEnd+4
    PosEnd = InstrB(PosBeg,RequestBin,boundary)-2
    Value = MidB(RequestBin,PosBeg,PosEnd-PosBeg)
    Else
    Pos = InstrB(Pos,RequestBin,getByteString(chr(13)))
    PosBeg = Pos+4
    PosEnd = InstrB(PosBeg,RequestBin,boundary)-2
    Value = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    End If
    UploadControl.Add "Value" , Value   
    UploadRequest.Add name, UploadControl   
    BoundaryPos=InstrB(BoundaryPos+LenB(boundary),RequestBin,boundary)
  Loop
End Sub
Function getByteString(StringStr)
  For i = 1 to Len(StringStr)
  char = Mid(StringStr,i,1)
  getByteString = getByteString & chrB(AscB(char))
  Next
End Function
Function getString(StringBin)
  getString =""
  For intCount = 1 to LenB(StringBin)
  getString = getString & chr(AscB(MidB(StringBin,intCount,1)))
  Next
End Function

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tutorial.mdb")
strsql = "SELECT * FROM [Frames]"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 1, 2
rs.AddNew
rs("frame1") = filename
rs("frame2") = Request.Cookies("tekst")
rs("frame3") = request.cookies("forfatternavn")
 

rs.Update
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Response.Clear
Response.Redirect "administration.htm"
End if
%>

<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css">
 
<title>Ny support side</title>

  <script language="JavaScript">
  function SetCookie (name, value) {var argv = SetCookie.arguments;var argc = SetCookie.arguments.length;var expires = (argc > 2) ? argv[2] : null;var path = (argc > 3) ? argv[3] : null;var domain = (argc > 4) ? argv[4] : null;var secure = (argc > 5) ? argv[5] : false;document.cookie = name + "=" + escape (value) + ((expires == null) ? "" : ("; expires=" + expires.toGMTString())) + ((path == null) ? "" : ("; path=" + path)) + ((domain == null) ? "" : ("; domain=" + domain)) + ((secure == true) ? "; secure" : "")}
  function set_name(form) {var expdate = new Date ();expdate.setTime (expdate.getTime() + (24 * 60 * 60 * 1000 * 31));
  var tekst = form3.y_tekst.value;SetCookie ("tekst", tekst, expdate)
  var forfatter = form3.navn.value;SetCookie ("forfatternavn", forfatter, expdate)
 
 
}
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin=0 topmargin=0 marginheight=0 marginwidth=0>
  <form METHOD='Post' ENCTYPE='multipart/form-data' ACTION='nysupport.asp?key=1' id='form3' name='form3' onSubmit="return set_name(this.form);">
<h2>Skriv En kommentar og udpeg stien til dit dokument</h2> 
<textarea cols='30' rows='8' name="y_tekst"></textarea><br>

  <input type="text" value="" name="navn">
  <input TYPE="file" NAME="blob" class="input">
  <input TYPE="submit" value="UDFØR" NAME="Enter">
  </form>
</BODY>
</HTML>
Avatar billede and_ Nybegynder
04. maj 2004 - 13:06 #3
sorry, vi skal lige have semikolon på også ;)

<%
Response.expires = 0
Response.expiresabsolute = Now() - 1
Response.addHeader "pragma", "no-cache"
Response.addHeader "cache-control", "private"
Response.CacheControl = "no-cache"
response.buffer = true
Response.Clear

key = request.querystring("key")

If key = 1 then
byteCount = Request.TotalBytes
RequestBin = Request.BinaryRead(byteCount)
Dim UploadRequest
Set UploadRequest = CreateObject("Scripting.Dictionary")
BuildUploadRequest(RequestBin)
contentType = UploadRequest.Item("blob").Item("ContentType")
filepathname = UploadRequest.Item("blob").Item("FileName")
filename = Right(filepathname,Len(filepathname)-InstrRev(filepathname,"\"))
value = UploadRequest.Item("blob").Item("Value")
Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject")
Set MyFile = ScriptObject.CreateTextFile(Server.mappath("sup/"&filename))
For i = 1 to LenB(value)
MyFile.Write chr(AscB(MidB(value,i,1)))
Next
MyFile.Close   
Sub BuildUploadRequest(RequestBin)
  PosBeg = 1
  PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(13)))
  boundary = MidB(RequestBin,PosBeg,PosEnd-PosBeg)
  boundaryPos = InstrB(1,RequestBin,boundary)
  Do until (boundaryPos=InstrB(RequestBin,boundary & getByteString("--")))
  Dim UploadControl
  Set UploadControl = CreateObject("Scripting.Dictionary")
  Pos = InstrB(BoundaryPos,RequestBin,getByteString("Content-Disposition"))
  Pos = InstrB(Pos,RequestBin,getByteString("name="))
  PosBeg = Pos+6
  PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(34)))
  Name = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
  PosFile = InstrB(BoundaryPos,RequestBin,getByteString("filename="))
  PosBound = InstrB(PosEnd,RequestBin,boundary)
    If  PosFile<>0 AND (PosFile<PosBound) Then
    PosBeg = PosFile + 10
    PosEnd =  InstrB(PosBeg,RequestBin,getByteString(chr(34)))
    FileName = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    UploadControl.Add "FileName", FileName
    Pos = InstrB(PosEnd,RequestBin,getByteString("Content-Type:"))
    PosBeg = Pos+14
    PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(13)))
    ContentType = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    UploadControl.Add "ContentType",ContentType
    PosBeg = PosEnd+4
    PosEnd = InstrB(PosBeg,RequestBin,boundary)-2
    Value = MidB(RequestBin,PosBeg,PosEnd-PosBeg)
    Else
    Pos = InstrB(Pos,RequestBin,getByteString(chr(13)))
    PosBeg = Pos+4
    PosEnd = InstrB(PosBeg,RequestBin,boundary)-2
    Value = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    End If
    UploadControl.Add "Value" , Value   
    UploadRequest.Add name, UploadControl   
    BoundaryPos=InstrB(BoundaryPos+LenB(boundary),RequestBin,boundary)
  Loop
End Sub
Function getByteString(StringStr)
  For i = 1 to Len(StringStr)
  char = Mid(StringStr,i,1)
  getByteString = getByteString & chrB(AscB(char))
  Next
End Function
Function getString(StringBin)
  getString =""
  For intCount = 1 to LenB(StringBin)
  getString = getString & chr(AscB(MidB(StringBin,intCount,1)))
  Next
End Function

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tutorial.mdb")
strsql = "SELECT * FROM [Frames]"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 1, 2
rs.AddNew
rs("frame1") = filename
rs("frame2") = Request.Cookies("tekst")
rs("frame3") = request.cookies("forfatternavn")
 

rs.Update
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Response.Clear
Response.Redirect "administration.htm"
End if
%>

<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css">
 
<title>Ny support side</title>

  <script language="JavaScript">
  function SetCookie (name, value) {var argv = SetCookie.arguments;var argc = SetCookie.arguments.length;var expires = (argc > 2) ? argv[2] : null;var path = (argc > 3) ? argv[3] : null;var domain = (argc > 4) ? argv[4] : null;var secure = (argc > 5) ? argv[5] : false;document.cookie = name + "=" + escape (value) + ((expires == null) ? "" : ("; expires=" + expires.toGMTString())) + ((path == null) ? "" : ("; path=" + path)) + ((domain == null) ? "" : ("; domain=" + domain)) + ((secure == true) ? "; secure" : "")}
  function set_name(form) {var expdate = new Date ();expdate.setTime (expdate.getTime() + (24 * 60 * 60 * 1000 * 31));
  var tekst = form3.y_tekst.value;SetCookie ("tekst", tekst, expdate);
  var forfatter = form3.navn.value;SetCookie ("forfatternavn", forfatter, expdate);
 
 
}
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin=0 topmargin=0 marginheight=0 marginwidth=0>
  <form METHOD='Post' ENCTYPE='multipart/form-data' ACTION='nysupport.asp?key=1' id='form3' name='form3' onSubmit="return set_name(this.form);">
<h2>Skriv En kommentar og udpeg stien til dit dokument</h2> 
<textarea cols='30' rows='8' name="y_tekst"></textarea><br>

  <input type="text" value="" name="navn">
  <input TYPE="file" NAME="blob" class="input">
  <input TYPE="submit" value="UDFØR" NAME="Enter">
  </form>
</BODY>
</HTML>
Avatar billede phuc69 Juniormester
04. maj 2004 - 13:27 #4
Den kommer ikke med nogen fejl meddelse. Men den indsætter altså ikke i databasen.
Avatar billede and_ Nybegynder
04. maj 2004 - 13:30 #5
Prøv at udskifte dette:

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tutorial.mdb")
strsql = "SELECT * FROM [Frames]"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 1, 2
rs.AddNew
rs("frame1") = filename
rs("frame2") = Request.Cookies("tekst")
rs("frame3") = request.cookies("forfatternavn")
 

rs.Update
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Response.Clear
Response.Redirect "administration.htm"
End if
%>

med dette:

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tutorial.mdb")
strsql = "SELECT * FROM [Frames]"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 1, 2
rs.AddNew
rs("frame1") = filename
rs("frame2") = Request.Cookies("tekst")
rs("frame3") = request.cookies("forfatternavn")
 

rs.Update
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Response.Clear
response.write "Kagen indeholder " & request.cookies("forfatternavn")
'Response.Redirect "administration.htm"
End if
%>
Avatar billede and_ Nybegynder
04. maj 2004 - 13:31 #6
og fortæl om den skriver forfatternavnet ud
Avatar billede phuc69 Juniormester
04. maj 2004 - 13:43 #7
Nu har jeg ændret den. og fjernet response.Redirect "administration.htm" så koden ser sådan her ud. Den åbner stadigæk administrations filen

<%
Response.expires = 0
Response.expiresabsolute = Now() - 1
Response.addHeader "pragma", "no-cache"
Response.addHeader "cache-control", "private"
Response.CacheControl = "no-cache"
response.buffer = true
Response.Clear

key = request.querystring("key")

If key = 1 then
byteCount = Request.TotalBytes
RequestBin = Request.BinaryRead(byteCount)
Dim UploadRequest
Set UploadRequest = CreateObject("Scripting.Dictionary")
BuildUploadRequest(RequestBin)
contentType = UploadRequest.Item("blob").Item("ContentType")
filepathname = UploadRequest.Item("blob").Item("FileName")
filename = Right(filepathname,Len(filepathname)-InstrRev(filepathname,"\"))
value = UploadRequest.Item("blob").Item("Value")
Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject")
Set MyFile = ScriptObject.CreateTextFile(Server.mappath("sup/"&filename))
For i = 1 to LenB(value)
MyFile.Write chr(AscB(MidB(value,i,1)))
Next
MyFile.Close   
Sub BuildUploadRequest(RequestBin)
  PosBeg = 1
  PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(13)))
  boundary = MidB(RequestBin,PosBeg,PosEnd-PosBeg)
  boundaryPos = InstrB(1,RequestBin,boundary)
  Do until (boundaryPos=InstrB(RequestBin,boundary & getByteString("--")))
  Dim UploadControl
  Set UploadControl = CreateObject("Scripting.Dictionary")
  Pos = InstrB(BoundaryPos,RequestBin,getByteString("Content-Disposition"))
  Pos = InstrB(Pos,RequestBin,getByteString("name="))
  PosBeg = Pos+6
  PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(34)))
  Name = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
  PosFile = InstrB(BoundaryPos,RequestBin,getByteString("filename="))
  PosBound = InstrB(PosEnd,RequestBin,boundary)
    If  PosFile<>0 AND (PosFile<PosBound) Then
    PosBeg = PosFile + 10
    PosEnd =  InstrB(PosBeg,RequestBin,getByteString(chr(34)))
    FileName = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    UploadControl.Add "FileName", FileName
    Pos = InstrB(PosEnd,RequestBin,getByteString("Content-Type:"))
    PosBeg = Pos+14
    PosEnd = InstrB(PosBeg,RequestBin,getByteString(chr(13)))
    ContentType = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    UploadControl.Add "ContentType",ContentType
    PosBeg = PosEnd+4
    PosEnd = InstrB(PosBeg,RequestBin,boundary)-2
    Value = MidB(RequestBin,PosBeg,PosEnd-PosBeg)
    Else
    Pos = InstrB(Pos,RequestBin,getByteString(chr(13)))
    PosBeg = Pos+4
    PosEnd = InstrB(PosBeg,RequestBin,boundary)-2
    Value = getString(MidB(RequestBin,PosBeg,PosEnd-PosBeg))
    End If
    UploadControl.Add "Value" , Value   
    UploadRequest.Add name, UploadControl   
    BoundaryPos=InstrB(BoundaryPos+LenB(boundary),RequestBin,boundary)
  Loop
End Sub
Function getByteString(StringStr)
  For i = 1 to Len(StringStr)
  char = Mid(StringStr,i,1)
  getByteString = getByteString & chrB(AscB(char))
  Next
End Function
Function getString(StringBin)
  getString =""
  For intCount = 1 to LenB(StringBin)
  getString = getString & chr(AscB(MidB(StringBin,intCount,1)))
  Next
End Function

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tutorial.mdb")
strsql = "SELECT * FROM [Frames]"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 1, 2
rs.AddNew
rs("frame1") = filename
rs("frame2") = Request.Cookies("tekst")
rs("frame3") = request.cookies("forfatternavn")
 

rs.Update
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Response.Clear
response.write "Kagen indeholder " & request.cookies("forfatternavn")

End if
%>

<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css">
 
<title>Ny support side</title>

  <script language="JavaScript">
  function SetCookie (name, value) {var argv = SetCookie.arguments;var argc = SetCookie.arguments.length;var expires = (argc > 2) ? argv[2] : null;var path = (argc > 3) ? argv[3] : null;var domain = (argc > 4) ? argv[4] : null;var secure = (argc > 5) ? argv[5] : false;document.cookie = name + "=" + escape (value) + ((expires == null) ? "" : ("; expires=" + expires.toGMTString())) + ((path == null) ? "" : ("; path=" + path)) + ((domain == null) ? "" : ("; domain=" + domain)) + ((secure == true) ? "; secure" : "")}
  function set_name(form) {var expdate = new Date ();expdate.setTime (expdate.getTime() + (24 * 60 * 60 * 1000 * 31));
  var tekst = form3.y_tekst.value;SetCookie ("tekst", tekst, expdate);
  var forfatter = form3.navn.value;SetCookie ("forfatternavn", forfatter, expdate);
 
 
}
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin=0 topmargin=0 marginheight=0 marginwidth=0>
  <form METHOD='Post' ENCTYPE='multipart/form-data' ACTION='nysupport.asp?key=1' id='form3' name='form3' onSubmit="return set_name(this.form);">
<h2>Skriv En kommentar og udpeg stien til dit dokument</h2> 
<textarea cols='30' rows='8' name="y_tekst"></textarea><br>

  <input type="text" value="" name="navn">
  <input TYPE="file" NAME="blob" class="input">
  <input TYPE="submit" value="UDFØR" NAME="Enter">
  </form>
</BODY>
</HTML>
Avatar billede phuc69 Juniormester
04. maj 2004 - 13:43 #8
Den skriver ikke forfatternavnet
Avatar billede and_ Nybegynder
04. maj 2004 - 13:49 #9
og du udfylder selvfølgelig feltet, inden du sender den ikke?

Har du et link, hvor jeg evt. kan se det?
Avatar billede phuc69 Juniormester
04. maj 2004 - 13:51 #10
nej jeg kører det lokalt på min maskine har ingen hotel pt
Avatar billede and_ Nybegynder
04. maj 2004 - 14:00 #11
Så laver vi det på en anden måde :)

udskift det nederste:

set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("tutorial.mdb")
strsql = "SELECT * FROM [Frames]"
set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql, conn, 1, 2
rs.AddNew
rs("frame1") = filename
rs("frame2") = Request.Cookies("tekst")
rs("frame3") = request.querystring("navnet")
 

rs.Update
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
Response.Clear
response.write "Navnet er: " & request.querystring("navnet")
End if
%>

<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css">
 
<title>Ny support side</title>

  <script language="JavaScript">
  function SetCookie (name, value)
  {
  var argv = SetCookie.arguments;
  var argc = SetCookie.arguments.length;
  var expires = (argc > 2) ? argv[2] : null;var path = (argc > 3) ? argv[3] : null;var domain = (argc > 4) ? argv[4] : null;var secure = (argc > 5) ? argv[5] : false;
  document.cookie = name + "=" + escape (value) + ((expires == null) ? "" : ("; expires=" + expires.toGMTString())) + ((path == null) ? "" : ("; path=" + path)) + ((domain == null) ? "" : ("; domain=" + domain)) + ((secure == true) ? "; secure" : "")
  }
 
  function set_name(form)
  {
  var expdate = new Date ();
  var forfatter = form3.navn.value;
  var tekst = form3.y_tekst.value;
  expdate.setTime (expdate.getTime() + (24 * 60 * 60 * 1000 * 31));
  SetCookie ("tekst", tekst, expdate); 
  SetCookie ("forfatternavn", forfatter, expdate); 
  document.form3.action = "nysupport.asp?key=1&navnet=" + forfatter;
  }
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin=0 topmargin=0 marginheight=0 marginwidth=0>
  <form METHOD='Post' ENCTYPE='multipart/form-data' id='form3' name='form3' onSubmit="return set_name(this.form);">
<h2>Skriv En kommentar og udpeg stien til dit dokument</h2> 
<textarea cols='30' rows='8' name="y_tekst"></textarea><br>

  <input type="text" value="" name="navn">
  <input TYPE="file" NAME="blob" class="input">
  <input TYPE="submit" value="UDFØR" NAME="Enter">
  </form>
</BODY>
</HTML>
Avatar billede phuc69 Juniormester
04. maj 2004 - 14:08 #12
nu linker den til denne side
http://nysupport.asp?key=1&navnet=asdfadsf
Avatar billede phuc69 Juniormester
04. maj 2004 - 14:10 #13
Hvis ikke andet findes der så en anden måde at lave opload på.
Det der skal oplaodes er en fil til serveren. Filens navn i databasen. En kommentar til databasen samt et forfatter navn til databasen
Avatar billede and_ Nybegynder
04. maj 2004 - 14:15 #14
jeg ville klart omkode det, men det er ikke relevat lige nu ;)

Men er det ikke også den side den skal linke til?
Avatar billede and_ Nybegynder
04. maj 2004 - 14:16 #15
Avatar billede phuc69 Juniormester
04. maj 2004 - 14:25 #16
jo det er jo det der sker ved mig. men det hjælper jo ikke på noget :-) Den smider stadigvæk ikke noget i databasen. Hvis ikke andet kan du så henvise til et evt download sted.
Avatar billede and_ Nybegynder
04. maj 2004 - 14:27 #17
men så er det jo din base det er galt med! hvordan er den opbygget?
Avatar billede phuc69 Juniormester
04. maj 2004 - 14:36 #18
Jeg tror ikke det er databasen det er galt med det virker fint med. Den eksisterende kode. Og jeg har oprette feltet så det er heller ikke det. Jeg ved sgu snart ikke hvor det går galt.
Avatar billede and_ Nybegynder
04. maj 2004 - 14:40 #19
du må lave et dumb til mig..... jeg kan ikke hjælpe hvis jeg ikke kan se hvad vi skal lave
Avatar billede phuc69 Juniormester
04. maj 2004 - 14:55 #20
Vil du bare have strukturen af db at vide hvilke felter?
Avatar billede and_ Nybegynder
04. maj 2004 - 15:26 #21
jatak...

feltnavn, samt type
Avatar billede phuc69 Juniormester
04. maj 2004 - 21:28 #22
DB'en består af frame1=tekst fram2=tekst forfatter=tekst dato=dato felt
Avatar billede phuc69 Juniormester
04. maj 2004 - 21:28 #23
eller retter tabellen
Avatar billede and_ Nybegynder
04. maj 2004 - 21:31 #24
som sagt... du skal rette koden så den passer

frame3 skal ændres til forfatter
Avatar billede phuc69 Juniormester
05. maj 2004 - 09:34 #25
Jeg tror vi misforstår hinanden. Det jeg har skrevet er hvad jeg vil kalde feltet hvis jeg skulle lave en ny. I den eksisterende tabel hedder feltet frame3.  Det har jeg oprettet så der ikke var npget at tage fejl af. :-)
Avatar billede phuc69 Juniormester
05. maj 2004 - 12:03 #26
Fejlen er nu rettet. med følgende indgreb. Jeg må have fjumret i det igår...

rs("forfatter") = Request.Cookies("forfat")
var forfat = form3.forfat.value;SetCookie ("forfat", forfat, expdate)
<input TYPE="TEXT" NAME="forfat" >

And smid et svar så er der point
Avatar billede and_ Nybegynder
05. maj 2004 - 12:25 #27
svar :)

så lykkedes det tilsidst ;)
Avatar billede phuc69 Juniormester
05. maj 2004 - 15:29 #28
Tak for hjælpen  :-)
Avatar billede and_ Nybegynder
05. maj 2004 - 15:30 #29
det er iorden ;)
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