通过查询重新确定值的优先级

通过查询重新确定值的优先级

本文介绍了通过查询重新确定值的优先级的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

嗨伙计,


不是真的在寻找代码或其他任何东西,只是朝着正确的方向研究。


我我将设计一个系统,它将获取与SQL Server CE表中的值相关的大量用户输入,如果有10个选项,并且他们选择其中3个,我想返回所有内容的列表具有任何这些值的表,但优先考虑那些最匹配的值。


我正在考虑添加与记录集匹配的所有记录,并可能创建某种形式的临时数组可以通过增加一个值(对于匹配的每个值增加)来排序?有谁知道这种事情的任何技术?或类似的帖子?我看了看但却找不到任何东西。


干杯!


PS - 我觉得我听起来很清楚,但如果没有问的话我,我会澄清一些事情。我还没有开始设计系统,所以我无法提供表信息等。

Hi Folks,

Not really looking for code or anything here, just a point in the right direction to research.

I am going to be designing a system that will take a bunch of user inputs related to values in SQL Server CE tables, and if there are 10 options, and they select 3 of them, I want to return a list of all the things in the table that have any of those values, but prioritise the ones that match the most.

I was thinking of adding all records that match to a recordset, and possibly creating some form of temp array which could be ordered by say an incremented value (that increases for each value that matches up)? Anyone know about any techniques for this sort of thing? or similar posts? I had a look but couldn''t find anything.

Cheers!

PS - I think i sound clear, but if not ask me and I''ll clarify stuff. I havent started designing the system yet, so i cant provide table info etc.

推荐答案




嗯...我不认为这会对此有用,因为输入有望全部是预先定义的,即列表框,复选框等。它是将成为一个使用SQLServerCE的PDA应用程序,我理想地想要生成具有类似于本网站的功能/界面用于花卉识别的东西




这只是产生一个与你投入的费用。显然,其中一些结果会比其他结果更多。


ie


对象a - 匹配characteristcs a,b,c

对象b - 匹配b,c

对象c - 匹配


所以如果你输入,特征a和b

对象c和a将是结果(网站的功能,以及我很乐意与我的项目合作的地方),但是对象是一个matche他们两个都是,因此应该更高的结果(在某个地方我真的应该用我的项目)


我的编程将在PDA上运行。目前我的MASSIVE(恐慌攻击终止)问题是连接到SLQ Server CE数据库并向其传递SQL查询以获得某种形式的输出。不幸的是,似乎没有人回应我在这里寻求帮助的任何请求,我会听一下在VB中用PDA设计运行数据库系统的人,并且愿意他们花了一些时间来回答我的一些问题。

Hmm... I dont think that would work with this, as the inputs will hopefully all be pre-defined, i.e. list boxes, check boxes etc. It is going to be a PDA app with SQLServerCE and I had ideally wanted to produce something with function/interface similar to this website for flower identification

Flower Identification Site

Which just produces a list of things that match the feilds you put in. And obviously some of those results will feature in more fields than the others.

i.e.

object a - matches characteristcs a,b,c
object b - matches b,c
object c - matches a

so if you put in, characteristics a and b

objects c and a will be results (the function of the website, and somewhere i would happily be with my project) , however object a matches them both, thus should be higher up the results (somewhere I would IDEALLY be with my project)

My prog would be running on the PDA. Currently my MASSIVE (panic attack enducing) issue is connecting to a SLQ Server CE database and passing an SQL query to it to have some form of output. Unfortunatly no one seems to be responding to any of my pleas for help here, I would love to hear from someone who has designed a system running with a database on a PDA in VB and who would be willing to spare some of their time to answer a few questions I have.



这篇关于通过查询重新确定值的优先级的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-28 06:21