Your Ad Here

advanced code snippet search

Posted By

krisdb on 04/23/07


Tagged

sql


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

eunjoo1984


up/down

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT case request.querystring("order")
  2.      case "up"
  3.          strsql = "update story set orderField = orderField + 1 where orderField = "& request.querystring("orderField")-1 & " and ID = " & request.querystring("ID") & ";" &_
  4. "update TABLE set orderField = orderField - 1 where PrimaryKeyId = " & request.querystring("PrimaryKeyId") & " and ID = " & request.querystring("ID")
  5. updateDatabase(strsql)
  6.  
  7.      case "down"
  8.         strsql = "update story set orderField = orderField - 1 where orderField = "& request.querystring("orderField")+1 & " and ID = " & request.querystring("ID") & ";" &_
  9. "update TABLE set orderField = orderField + 1 where PrimaryKeyId = " & request.querystring("PrimaryKeyId") & " and ID = " & request.querystring("ID")
  10. updateDatabase(strsql)
  11.  
  12. end SELECT
  13.  
  14. <a href="&scriptName&"?ORDER=up&ID="&ID&"&PrimaryKeyId="&PrimaryKeyId&"&orderField="&orderField&">up</a>
  15. <a href="&scriptName&"?ORDER=down&ID="&ID&"&PrimaryKeyId="&PrimaryKeyId&"&orderField="&orderField&">down</a>

Report this snippet  

You need to login to post a comment.