display First of Record (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

---

chadb -> 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 -> 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 -> 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 -> 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"

---

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.046875