Page 1 of 1

convert query

Posted: Fri Jan 07, 2005 2:55 pm
by rodrigorules
when i try to run this it says i must convert it..
how do i convert it.. =/

UPDATE Character SET Inventory = '0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'

Posted: Fri Jan 07, 2005 5:03 pm
by feyd
is there a reason you are using a number value that large?

maybe removing the quotes.

Posted: Fri Jan 07, 2005 7:07 pm
by rodrigorules
yea i found out how...remove qoutes and use CAST

yea its for a gameserver..SQL holds all the game info
i wanted to delete everyones items( F's stands for empty)