Your Ad Here

Posted By

krisdb on 03/08/07


Tagged

sql


Versions (?)

if exists


 / Published in: SQL
 

  1. sql="if exists (select wineclub_usersID from wineclub where wineclub_usersID = " & session("userid") & ") " & _
  2. "begin " &_
  3. "update table set shipemail = '"&StripTicks(session("shipemail"))&"', " &_
  4. "where wineclub_usersID = "&session("userid")&"; " &_
  5. "end else begin " &_
  6. "insert into table " &_
  7. "(wineclub_usersID,shipemail,shipname,shipaddress, shipcity, shipstate)" & _
  8. " values ("&session("userid")&",'"&StripTicks(session("shipemail"))&"') " &_
  9. "end"

Report this snippet  

You need to login to post a comment.