You're forgetting that we know nothing about what it is you're describing:
"I've got information that I recall with a query using the [ ] method."
How does one "recall" "information"? The word "recall" is defined in the
dictionary as:
1. to bring back from memory; recollect; remember: Can you recall what she
said?
2. to call back; summon to return: The army recalled many veterans.
3. to bring (one's thoughts, attention, etc.) back to matters previously
considered:
He recalled his mind from pleasant daydreams to the dull task at hand.
4. International Law. to summon back and withdraw the office from (a
diplomat).
5. to revoke or withdraw: to recall a promise.
6. to revive.
Which of these definitions did you mean? The word "information" means
(computer term ony):
a. important or useful facts obtained as output from a computer by means of
processing input data with a program: Using the input data, we have
come up with some significant new information.
b. data at any stage of processing (input, output, storage, transmission,
etc.).
So, are you saying that you want to call back data? If so, call it back from
where? What data?
Now, you say that you do this with a "query" -
1. a question; an inquiry.
2. mental reservation; doubt.
3. Printing. a question mark (?), esp. as added on a manuscript, proof
sheet, or the like,
indicating doubt as to some point in the text.
4. an inquiry from a writer to an editor of a magazine, newspaper, etc.,
regarding the acceptability of or interest in an idea for an article,
news story,
or the like: usually presented in the form of a letter that outlines or
describes the projected piece.
- or, more specifically, from database terminology:
1. <database, information science> A user's (or agent's)
request for information, generally as a formal request to a
database or search engine.
So, do you mean that you are calling data from a database back from
somewhere to somewhere using a SQL Query? If so, what is the "[] Method?"
Moving on, the next statement you make is:
"Part of the info is numbers/prices. Say for example: 500 550 600 650 ... I
can currently look up the value 500 and all its attached information (in the
table).
Well, we now have a clue as to the nature of the "data" - or at least part
of it, which is apparently "numbers/prices." So, at this point I'm
relatively sure that a database is involved somewhere. But the rest of the
statement is incomprehensible. You say you can "look up the value 500 and
all its attached information (in the table)". What is the number 500
supposed to be? What is "its attached information"? I can at least presume
that "the table" is *a* table in a database. But that's as far as I get.
Finally, you say:
"What I need to be able to do is somehow to look up a range of information
e.g. all entries that match 500 - 600."
Okay, judging from what little information (not as in computers, but as in
humans) I've been able to glean, you apparently want to "look up a range of
information" - which I take to mean a set of records in a table. And the
part of the sentence which reads "e.g. all entries that match 500 - 600" I
take it that you want to query a table in a database and use a range of
numbers to fetch the records.
Now, as confusing as that was, I was able to parse it to a certain degree.
But this is the FrontPage client newsgroup. So, I will have to presume
you're designing a web site. Therefore, the question must be framed within
the context of creating a web site, and based upon the first part of the
question, I would guess that you're creating some Data Access pages. After
all, you're probably going to *do* something with the "information" you want
to "look up," even though you haven't said so, and as you're posting to the
FrontPage client newsgroup, it would not be inconceivable to guess that
you're designing a web site that employes Data Access Pages.
But, oddly enough, you seem to assume that we already know all of this, or
that it's easy enough for anyone reading your post to fill in the missing
parts. And that is a mistake. There are 7 billion people in the world, and
the Internet spans all of it. I happen to be something of an expert in
English, but even I had a great deal of difficulty getting this far. In the
future, pretend you're talking to a 12-year-old from Ethiopia. Not because
you are, but because that is about the lowest common denominator of all the
people who may read your question. Remember that the more clearly you state
your problem, the quicker you will receive a solution. And these newsgroups
don't charge by the word. ;-)
Still, after all that, I'm not sure what the question is. You have stated
what it is you "need to be able to do," but are entirely vague about what
your specific problem is. For example, I could tell you that I "need to be
able to go to New York." Now, if I were to tell you that, what specifically
would I be asking you? Actually, nothing. I never actually asked a question.
I simply stated a circumstance. Now, if I had said "I need to be able to go
to New York, but I can't decide whether to drive or to fly" I would still
not be asking a question, but I would be stating a problem. I need to know
whether it's better to drive or to fly if I am going to New York.
So, could you please try again, pretend that we're all 10-year-old
Ethiopians, and state what specifically you need to know?
--
HTH,
Kevin Spencer
Microsoft MVP
Chicken Salad Surgery
It takes a tough man to make a tender chicken salad.
andyrae said:
I've got information that I recall with a query using the [ ] method. Part
of
the info is numbers/prices. Say for example: 500 550 600 650 ... I can
currently look up the value 500 and all its attached information (in the
table). What I need to be able to do is somehow to look up a range of
information e.g. all entries that match 500 - 600.
