473,320 Members | 1,933 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Data Searching

markmcgookin
648 Expert 512MB
Hi Folks,

This is a strange post, so bear with me. I am also going to post a smilar post in the Visual Basic forum, but more technical (So hopefully this one will qualify not to get moved/deleted).

I am developing an application that needs to be able to search a table of data, and produce a list of outputs. I can do the output bit etc, however I have NEVER written any software that will refine a search using a series of data, so to be honest I don't know where to start. I am really looking for some kind of pseudocode/algorithm that I can build on. I know this isn't a technical forum, but I just thought it would be the best place to get some ideas knocked about.

So... Imagine I have the ability to read in about 10 values from a table.

and for those 10 values a user can select an option/value for each one from a dropdown box. (these are all selected before hand and the search happens on a button)

For some of the values the user can select (I don't know) so I think the best way to deal with this is to return all records in relation to this field (i.e. Search all types)

But I just don't know what my best approach is to return things that match all the values, and ignore the stuff the user doesn't know.

If anyone has any kind of english pseudocode/algorithm for a good way to approach this I'd be very grateful.. (if they share it that is!)
Mar 7 '07 #1
3 985
Ganon11
3,652 Expert 2GB
This probably belongs in the Miscellaneous Discussions forum, but I think you're better off just asking in the VB forum.

So let me try to sort through your problem:

You have a list of lots of data, and the user wants to search for a certain item. The user can select what type of item they are looking for (such as Name, Address, Phone Number, etc. or other types) or to search for any and all items. Then you need to search through all your data for items meeting the specified requirements. Correct?
Mar 7 '07 #2
markmcgookin
648 Expert 512MB
Yeah I'll give you more detail,

It's for searching for a flower.

The flower has values like,

Colour
Petal Size
Height
Location
Habitiat.... etc

all selected from dropdown boxes.

The DB for each flower has fields this info, but I just have no idea where to start with some pseudocode (I religously use this before coding) I can read in each flowers data line by line, and access each of these fields, but it's the generation of the search query I have no idea how to approach.

Like, if colour = Red
SQLcmd = SQLcmd & "Colour=Red"

... haha, that doesn't seem clear, but I just want to know how people would approach it. I don't need code, or a language specific solution, just somewhere to start, like, "I would concatonate a query with each value for every enrty and then pass this to your database" or something.
Mar 7 '07 #3
bartonc
6,596 Expert 4TB
I googled "drill down algorithm" and got some interesting looking hits.
Mar 7 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

10
by: sffan | last post by:
I am new to database programming and was curious how others solve the problem of storing encrypted in data in db table columns and then subsequently searching for these records. The particular...
2
by: hzy_104 | last post by:
Please recommend book on data structures for searching(c++)?
2
by: yee young han | last post by:
I need a fast data structure and algorithm like below condition. (1) this data structure contain only 10,000 data entry. (2) data structure's one entry is like below typedef struct _DataEntry_...
19
by: Johnny Google | last post by:
Here is an example of the type of data from a file I will have: Apple,4322,3435,4653,6543,4652 Banana,6934,5423,6753,6531 Carrot,3454,4534,3434,1111,9120,5453 Cheese,4411,5522,6622,6641 The...
7
by: | last post by:
Hello, Does anyone have an idea on how I can filter the data in the gridview control that was returned by an sql query? I have a gridview that works fine when I populate it with data. Now I...
12
by: Chris Springer | last post by:
I'd like to get some feedback on the issue of storing data out to disk and where to store it. I've never been in a production environment in programming so you'll have to bear with me... My...
1
by: neeraj | last post by:
Hi All Can any give me the code for convert "DataColumn" data type of "DataTable". Even if data table already populated (have data) Actually I am creating one search module which searches the...
6
by: bushwacker | last post by:
Hello all, I'm a chemical engineering student. our teacher has given us a project to do some calculations based on some equations. those equations include constants, which are to be read from a...
0
Dököll
by: Dököll | last post by:
Continued from: http://www.thescripts.com/forum/thread762010.html -VB 6.0 Professional -Microsoft DAO 3.6 Reference Search Database table... An attempt to fetch data housed in Access:
9
by: a | last post by:
Dear friends I want import data from CSV file to mdb file How can I do that in vb.net?
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.