Problem med SQL insert
HejJeg bruger:
<tr><td width='15%'>D. Pos:</td>
<td width='85%'><input type="text" width="300" name="dpos" class="knap"></td></tr>
SQL:
strSQL = "Insert into spillere (nummer, fornavn, efternavn, hold, opos, dpos, spos, height, weight, alder, nationalitet, billede, beskrivelse, profil)"
strSQL = strSQL & " values('" & replace(request.form("nummer"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("fornavn"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("efternavn"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("hold"),"'","''") & "', "
strSQL = strSQL & "'" & request.form("opos") & "', "
strSQL = strSQL & "'" & request.form("dpos") & "', "
strSQL = strSQL & "'" & request.form("spos") & "', "
strSQL = strSQL & "'" & replace(request.form("height"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("weight"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("alder"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("nationalitet"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("billede"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("beskrivelse"),"'","''") & "', "
strSQL = strSQL & "'" & replace(request.form("profil"),"'","''") & "')"
Uanset om jeg skriver noget eller ej, så smider den konstant et , ind dpos!!
Help :)
