MrOnline
04-24-2006, 10:08 AM
just wondering if theres a way to check thread name vs thread name in a different sql...
And if they are different update it to the other unless yours thread date is newer than the other...
well i kinda figure it is possible using something like
if (sql1 thread.threaname WHERE thread.threadid = '197') != (sql2 thread.threadname WHERE thread.threadid = '298')
if sql1 thread.threaddate > sql2 thread.threaddate
//do nothing
else
set sql1 thread.threadname = sql2 thread.threadname
else
// do nothing
well thats the "outline" and i belive i've given away that i have no clue whatsover when it comes to coding/programming...
And ofcourse i have full access to both SQL's they are on same server..
And if they are different update it to the other unless yours thread date is newer than the other...
well i kinda figure it is possible using something like
if (sql1 thread.threaname WHERE thread.threadid = '197') != (sql2 thread.threadname WHERE thread.threadid = '298')
if sql1 thread.threaddate > sql2 thread.threaddate
//do nothing
else
set sql1 thread.threadname = sql2 thread.threadname
else
// do nothing
well thats the "outline" and i belive i've given away that i have no clue whatsover when it comes to coding/programming...
And ofcourse i have full access to both SQL's they are on same server..