I wonder if anyone can point me in the direction of a tutorial which can help me solve my problem.
I wish to create an application that queries a database, but utilises user-specified information in order to refine such queries.
To explain this, perhaps I should give an example of what I am looking for.
Let's say I have a table with 3 fields: StartPoint, EndPoint, Distance
The user can input "1500" as a distance, then the query lists all StartPoint, Endpoint, Distance where Distance > 1500.
Or...
The user can input "Los Angeles" as a StartPoint, then the query lists all StartPoint, Endpoint, Distance where StartPoint = Los Angeles
What I wish to achieve is more complicated than this, but I just want to find a starting point and then I should be able to go from there.
Thanks