hjælp til SQL - indsæt i Dbase
hey der... jeg har denne Form i Index.asp:<form method="POST" action="upload.asp?showshop=<%=Request.QueryString("showsub")%>" enctype="multipart/form-data">
<input type="FILE" name="FILE1" size="50">
<input type="SUBMIT" value="Upload" name="SUBMIT">
<font size="+2"><a href="" onClick="window.open('Rules.asp','ProfilDetaljer','width=600,height=400');return false;">Read
the Guidelines First!</a> </font> <br>
<font color="#FFFFFF"><b>First select the folder you wanna save your
car in, then upload</b></font>
<input type="hidden" name="textfield" value="<%
If Request.Querystring("showsub") <> "" then
Response.Write(Request.Querystring("showsub"))
else
Response.write("root")
end if%>">
<input type="hidden" name="textfield2" value="Uploader">
<hr>
<input type="hidden" name="MM_insert" value="true">
</form>
Denne skal modtages af Upload.asp som indtil videre ser sådan her ud :
<%
Dim mySmartUpload
Dim intCount, showshop
showshop = Request.Querystring("showshop")
Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload")
mySmartUpload.Upload
intCount = mySmartUpload.Save("Cars" & showshop)
fp = Server.MapPath("Upload.txt")
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.OpenTextFile(fp)
ct = Clng(a.ReadLine)
ct = ct + 1
a.close
Set a = fs.CreateTextFile(fp, True)
a.WriteLine(ct)
a.Close
Response.Redirect("index.asp?ShowSub=" & showshop)
%>
Jeg vil gerne have at data'ene fra Index.asp sættes ind i
Upload.mdb i tabellen med navn Posts,
Værdien af "FILE1" skal gå til "Message"
Værdien af "textfield" skal gå til "Thread"
Værdien af "textfield2" skal gå til "Name"
