|
| |
|
|
chadb
Posts: 467
From: Kansas
Status: offline
 |
display First of Record - 5/5/2008 16:37:41
I have several fields, 3 of which could contain the same info, 4 don't. Is there a first of statement or something there I can only display the duplicate data once in drw?
Thanks
|
|
|
|
DesiMcK
Posts: 405
Joined: 4/26/2004
From: Essex, UK
Status: offline
|
RE: display First of Record - 5/6/2008 16:01:12
How about using SELECT DISTINCT.
Would it be easier if you pasted your current SQL and then we can adapt it for you.
Desi
| |
|
|
|
chadb
Posts: 467
From: Kansas
Status: offline
|
RE: display First of Record - 5/6/2008 16:49:34
Here is the code:
fp_sQry="SELECT * FROM Item WHERE (Job Like '::Job::' and Iscomplete Like '::Iscomplete::') "& myperc & " ORDER BY Job ASC"
The field Job might have 5 that are the same, then 3 then 9 then 1.
Thanks
| |
|
|
|
DesiMcK
Posts: 405
Joined: 4/26/2004
From: Essex, UK
Status: offline
|
RE: display First of Record - 5/6/2008 17:08:57
Does this do what you want?
fp_sQry="SELECT DISTINCT Job, Iscomplete FROM Item WHERE (Job Like '::Job::' and Iscomplete Like '::Iscomplete::') "& myperc & " ORDER BY Job ASC"
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
