var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query help, I thought this would be simple but I cant get it.
Well, Im no guru but I thought I could do this but cant, help please.
For a selection of records in a table, ie; where author_name='john'
I want to take the numeric data in a certain field ie; field is named topic_id
and copy that data into another field in the same record ie; field is named attach_file
thanks in advance
You probably need the Cast() function.
set attach_file = topic_id
Does MySQL do an implict cast between numeric and string?!?!
mysql will do an implicit cast to anything depending on context
(one of the reasons it is so cuddly)
in this particular case, there is no evidence that the other field is a string
attach_file could be numeric, no?
but to answer your question, yes, it's implicit