View Single Post
  #5  
Old 11 Mar 2016, 17:49
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Dr.CustUmz View Post
without the limit 1 it erases every entry of that that thread id
Is that not what you are trying to do ?
I guess I dont understand your actual objective then.

Originally Posted by Dr.CustUmz View Post
the problem with the method im using

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

is if there is no row with that threadID in the threadviews table it adds the original view to the table.
A delete query cannot add anything, ever.

You are using shutdown queries, which quite possibly get run backwards to how you define them (there isnt any guarantee what order they will run). So more likely the delete is running first, then the insert. You wont notice this if there is at least one existing record, but you will if there are none.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote