Advertisement
Guest User

Untitled

a guest
Apr 7th, 2014
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. diff --git a/packages/survey/www/admin/question-add-3-postgresql.xql b/packages/survey/www/admin/question-add-3-postgresql.xql
  2. index e7cfb6b..8029b59 100644
  3. --- a/packages/survey/www/admin/question-add-3-postgresql.xql
  4. +++ b/packages/survey/www/admin/question-add-3-postgresql.xql
  5. @@ -27,7 +27,7 @@
  6.  
  7. <fullquery name="get_choice_id">
  8. <querytext>
  9. - select survey_choice_id_sequence.nextval as choice_id
  10. + select nextval as choice_id from survey_choice_id_sequence
  11. </querytext>
  12. </fullquery>
  13.  
  14. diff --git a/packages/survey/www/admin/question-add-3.tcl b/packages/survey/www/admin/question-add-3.tcl
  15. index 8cc4803..e1f01b7 100644
  16. --- a/packages/survey/www/admin/question-add-3.tcl
  17. +++ b/packages/survey/www/admin/question-add-3.tcl
  18. @@ -105,7 +105,10 @@ if { $already_inserted_p } {
  19. set sort_order [expr { $after + 1 }]
  20. db_dml renumber_sort_orders {}
  21. } else {
  22. - set sort_order [expr {[db_string max_question {}] + 1}]
  23. + set sort_order [db_string max_question {}]
  24. + if { $sort_order eq ""} {
  25. + set sort_order 1
  26. + }
  27. }
  28.  
  29. db_exec_plsql create_question {}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement