Rodrigo,
Yuk! No wonder I was having trouble visualising your problem... The
serialised field cannot be meaningfully indexed (it's a waste of time if it
is). That means that any search against a criteria involving a/the
serialised field will require (the time to perform an) the examination of
well, I my opinion is not the way to work, but like I said the work was done
by other guy, and now I have the problem to solve. So i back to old question
:-)
How can I search with some precision in a serialized string?
on 8/24/02 12:13 PM, DL Neil at [EMAIL PROTECTED] wrote:
Rodrigo,
Then
Rodrigo,
Inherited problems = ouch!
Sorry I don't keep old list msgs, perhaps you mentioned this before: does
the language skills field contain:
1 both the language and the skill-level, eg English - Advanced
1b what separator is used between the two words?
2 more than one language/skill-level
I mean double ouch!!! :-)
well..
1 no, it's a select for the language (select name=language[]) and another
to skill level
1b no separator it's stored as array. The array generated by language[] and
skill[] are stored into another array, serialized and put into DB
2 yes. could be up to 5
2b
Hi list,
I have a form to post resumes. In one parte the user have a option to choose
up to 5 languages and his knowledge in it. example : english: basic advanced
My problem is that was stored serialized in the BD and now I need to do a
search by language and knowledge. How can I do this.
Hi list,
I have a form to post resumes. In one parte the user have a option to choose
up to 5 languages and his knowledge in it. example : english: basic advanced
My problem is that was stored serialized in the BD and now I need to do a
search by language and knowledge. How can I do this.
6 matches
Mail list logo