Upload af billednavn til database
HejJeg er interesseret i at få lavet en form som kan uploade filnavnet til en post i en database mens selve filen ligges i en bestemt mappe.
Jeg har adgang til aspsmartupload
Håber nogen kan finde ud af det
Feltet hvor stien til billedet skal gemmes hedder billed og mappen hedder pic/nyheder
Min kode ser således ud
<%@LANGUAGE="VBSCRIPT"%>
<%
If Session("validering") <> "valid" Then Response.Redirect("nyheder.asp")
id = Request("id")
%>
<!--#include file="nyheder_forbindelse.asp"-->
<%
Set indlaeg = Server.CreateObject("ADODB.Recordset")
indlaeg.Open "SELECT * FROM nyhedsindlaeg WHERE id = " & id, database,2 ,2
If Request("Submit") <> "" Then
indlaeg("overskrift") = Request("overskrift")
indlaeg("dato") = Request("dato")
indlaeg("forfatter") = Request("forfatter")
indlaeg("indlaeg") = Request("indhold")
If Request("link") = "" Then
indlaeg("link") = NULL
Else
indlaeg("link") = Request("link")
End If
indlaeg.Update
Response.Redirect("nyheder.asp")
Else
overskrift = indlaeg("overskrift")
dato = formatmindato(indlaeg("dato"))
forfatter = indlaeg("forfatter")
indhold = indlaeg("indlaeg")
link = indlaeg("link")
End If
%>
<%
Function FormatMinDato(Datoen)
Dim strYYYY
Dim strMM
Dim strDD
strYYYY = CStr(DatePart("yyyy", Datoen))
strMM = CStr(DatePart("m", Datoen))
If Len(strMM) = 1 Then strMM = "0" & strMM
strDD = CStr(DatePart("d", Datoen))
If Len(strDD) = 1 Then strDD = "0" & strDD
FormatMinDato = strDD & "-" & strMM & "-" & strYYYY
End Function
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>¨
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><form action="opdater.asp" method="post" name="form1">
<table width="750" border="0" align="center">
<tr valign="top">
<td height="31" colspan="2"><font size="3" face="Verdana, Arial, Helvetica, sans-serif"><strong>Opdater
nyhed<br>
</strong></font><img src="../pic/moerkeblaa.gif" width="575" height="2"></td>
</tr>
<tr>
<td width="70" valign="top"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Overskrift:</font></div></td>
<td width="670"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="overskrift" type="text" class="noborder" value="<% = overskrift%>" size="41">
</font></td>
</tr>
<tr>
<td width="70" valign="top"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Forfatter:</font></div></td>
<td width="670"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="forfatter" type="text" class="noborder" value="<% = forfatter%>" size="41">
</font> </td>
</tr>
<tr>
<td width="70" valign="top"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Dato:</font></div></td>
<td width="670"> <table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="289"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="dato" type="text" class="noborder" value="<% = dato%>" size="41">
</font></td>
<td width="362"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
(13-04-2003)</font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td width="70" valign="top"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Indlæg:
</font></div></td>
<td width="670"> <div align="left"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<textarea name="indhold" cols="60" rows="8" class="noborder"><% = indhold%></textarea>
</font> </div></td>
</tr>
<tr>
<td width="70" valign="top"> <div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> Evt.
link:</font></div></td>
<td width="670"> <table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="289"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="link" type="text" class="noborder" value="<% = link%>" size="41">
</font></td>
<td width="362"><div align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
(www.stenhuset.dk)</font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td valign="top"> <div align="right"></div></td>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="Submit" type="submit" class="knap" value="Opdater">
</font></td>
</tr>
</table>
<p>
<input type="hidden" name="id" value="<% = id%>">
</p>
</form></td>
</tr>
</table>
