Advertisement
SquirrelInBox

Untitled

May 17th, 2016
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.51 KB | None | 0 0
  1. UpdateCommand="UPDATE dbo.abit$ SET
  2. state = @state,
  3. vstup1 = (SELECT cod FROM exams$ WHERE name=@exname1),
  4. vstup2 = @exname2,
  5. vstup3 = @exname3,
  6. vstup4 = @exname4,
  7. vstup5 = @exname5,
  8. vstup6 = @exname6,
  9. vstup7 = @exname7,
  10. pol = @pol,
  11. att_or_dip = @att_or_dip,
  12. school = @school,
  13. note1 = @note1,
  14. note2 = @note2,
  15. note3 = @note3,
  16. note4 = @note4,
  17. note5 = @note5,
  18. note6 = @note6,
  19. note7 = @note7,
  20. birthday=@birthday,
  21. year_end = @year_end,
  22. [sattestat] = @sattestat,
  23. [nattestat] = @nattestat,
  24. [spusport] = @spusport,
  25. [npusport] = @npusport,
  26. [sv_o_puspo] = @sv_o_puspo,
  27. adres = @adres
  28.  
  29. WHERE (number = @number) AND (FLOOR(DATEDIFF(day, birthday, GETDATE()) / 365.25) < 100) AND (NOT(FLOOR(DATEDIFF(day, birthday, GETDATE()) / 365.25)<15))"
  30. >
  31. <UpdateParameters>
  32. <asp:QueryStringParameter Name="number" QueryStringField="number" Type="Double" />
  33. <asp:formparameter name="state" formfield="DropDownList2" />
  34. <asp:formparameter name="exname1" formfield="DropDownList4"/>
  35. <asp:formparameter name="exname2" formfield="DropDownList5" />
  36. <asp:formparameter name="exname3" formfield="DropDownList6" />
  37. <asp:formparameter name="exname4" formfield="DropDownList7" />
  38. <asp:formparameter name="exname5" formfield="DropDownList8" />
  39. <asp:formparameter name="exname6" formfield="DropDownList9" />
  40. <asp:formparameter name="exname7" formfield="DropDownList10" />
  41. <asp:formparameter name="pol" formfield="DropDownList1" />
  42. <asp:formparameter name="att_or_dip" formfield="DropDownList3" />
  43. </UpdateParameters>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement