Udfylder selv i databasen
Jeg har lavet en Update til en database men det ser ud som om at den selv fylder en masse +++++ efter det jeg har skrevet.Hvorfor gør den det?
Skriv hvis der er noget i skal have at vide. For jeg ved ikke hvad jeg skal skrive.
Query = "UPDATE people SET"
Query = Query & "[navn] = '" & Request.QueryString("navn") &"',"
Query = Query & "[alder] = '"& Request.QueryString("alder") &"',"
Query = Query & "[bopael] = '"& Request.QueryString("bopael") &"',"
Query = Query & "[foedested] = '"& Request.QueryString("foedested") &"',"
Query = Query & "[barn] = '"& Request.QueryString("barn") &"',"
Query = Query & "[b_comment] = '"& Request.QueryString("b_comment") &"',"
Query = Query & "[far] = '"& Request.QueryString("far") &"',"
Query = Query & "[faralder] = " & Request.QueryString("faralder") &","
Query = Query & "[termin] = '"& ConvertToSqlDate(Request.QueryString("dato")) &"',"
Query = Query & "[eventuelt] = '"& Request.QueryString("eventuelt") &"',"
Query = Query & "[sex] = '"& Request.QueryString("sex") &"',"
Query = Query & "[scan] = '"& Request.QueryString("scan") &"',"
Query = Query & "[b_navn] = '"& Request.QueryString("b_navn") &"',"
Query = Query & "[jm_besog] = '"& Request.QueryString("jm_besog") &"',"
Query = Query & "[e-mail] = '"& Request.QueryString("email") &"',"
Query = Query & "[nick] = '"& Request.QueryString("nick") &"'"
Query = Query & "WHERE ID = '" & Request.QueryString("skjult") & "'"
Connect.Execute(Query)
set Query = nothing
