May 28, 2013 at 7:20 am
Hi Everyone,
I have an app that creates groups and designates members based on their age. Now I would like to be able to "suggest" a list of possible members by using the name/description of the group.
For example, if the group name was "Essex Town FC U8", i'd like to get back a table of results as follows:
Operator Value
--------------------
< 8
I'd also be able to interrogate the description field too, for example: "The group contains members for the Essex Town FC under 12's and under 13's football team". From this, I'd like to retrieve the following resultset.
Operator Value
--------------------
< 12
< 13
Once I've got this, I can then perform my own search on the users' ages to get back the "possible" selection.
I'll be completely honest, this is a bit of a challenge for me, but having asked some challenging questions before and received some amazing feedback, I thought I'd at least ask the question here first! 😀
Thanks all,
Kev.
For all your clubs - Our Clubs.
Try out our new site today and see how it can help your club!
May 28, 2013 at 9:31 am
You will need to write your own artificial intelligent parser/translator of English sentences to convert them into dynamic t-sql.
May 29, 2013 at 5:52 am
Thanks for the reply Eugene.
I knew it wasn't a simple query...but I think for now, it might be out-of-scope for my current project. Perhaps at a later date, when I have time, I can revisit it and post up my solution here.
Cheers,
Kev.
For all your clubs - Our Clubs.
Try out our new site today and see how it can help your club!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply