Re: [WebDNA] prevent database duplicates

This WebDNA talk-list message is from

2019


It keeps the original formatting.
numero = 114691
interpreted = N
texte = 2313 --Apple-Mail=_849BDCE3-8698-42B8-926E-DF9D96D479FA Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Of course, you=E2=80=99re gonna want to find how you=E2=80=99re getting = dupes but if the SKU number is being duped, then adding=20 SKUsumm=3Dt to the search will only get 1 unique instance of that field = value. Quick workaround while you track down the real issue. HTh Alex > On Aug 14, 2019, at 12:37 PM, Stephen Braun = wrote: >=20 > Hello All, Happy Summer! >=20 > I have a web page that provides exams for the customer. > I'm doing a search of the database of questions, and creating a = temporary database of random questions, which then generates a web page = that looks like an exam. >=20 > Somehow I am getting duplicate questions. > Is there anyway to instruct a [search] or [founditems] tag to reject = duplicates? >=20 > Heroes my search code: =20 > [search = db=3Dquestions_temp_vet.db&grSKU=3D999&eqQUESTION_TYPEdatarq=3DC_I&raQUEST= ION_NUMBERsort=3D1&QUESTION_NUMBERtype=3Dnum&max=3D[number_of_CI_questions= ]][founditems] >=20 > Would this code allow the SKU variable to return the number 1010 = twice? > Is there a way to prevent this from happening? >=20 > Thanks for any insight. >=20 > Stephen F Braun > sbraun1@twcny.rr.com > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us --Apple-Mail=_849BDCE3-8698-42B8-926E-DF9D96D479FA Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Of = course, you=E2=80=99re gonna want to find how you=E2=80=99re getting = dupes but if the SKU number is being duped, then adding 
SKUsumm=3Dt to the search will only get 1 unique instance of = that field value.

Quick workaround while you track down the real = issue.

HTh
Alex


On Aug 14, 2019, at 12:37 PM, Stephen Braun <sbraun1@twcny.rr.com> wrote:

Hello = All,  Happy Summer!

I have a web page that provides exams for the = customer.
I'm doing a search of the database of = questions, and creating a temporary database of random questions, which = then generates a web page that looks like an exam.

Somehow I am getting = duplicate questions.
Is there anyway to instruct a = [search] or [founditems] tag to reject duplicates?

Heroes my search code: =   
[search = db=3Dquestions_temp_vet.db&grSKU=3D999&eqQUESTION_TYPEdatarq=3DC_I= &raQUESTION_NUMBERsort=3D1&QUESTION_NUMBERtype=3Dnum&max=3D[nu= mber_of_CI_questions]][founditems]

Would this code allow the SKU variable = to return the number 1010 twice?
Is there a way to = prevent this from happening?

Thanks for any = insight.

Stephen F Braun
sbraun1@twcny.rr.com
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_849BDCE3-8698-42B8-926E-DF9D96D479FA-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] prevent database duplicates (Stephen Braun 2019)
  2. Re: [WebDNA] prevent database duplicates (Stuart Tremain 2019)
  3. Re: [WebDNA] prevent database duplicates (Alex Mccombie 2019)
  4. [WebDNA] prevent database duplicates (Stephen Braun 2019)
2313 --Apple-Mail=_849BDCE3-8698-42B8-926E-DF9D96D479FA Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Of course, you=E2=80=99re gonna want to find how you=E2=80=99re getting = dupes but if the SKU number is being duped, then adding=20 SKUsumm=3Dt to the search will only get 1 unique instance of that field = value. Quick workaround while you track down the real issue. HTh Alex > On Aug 14, 2019, at 12:37 PM, Stephen Braun = wrote: >=20 > Hello All, Happy Summer! >=20 > I have a web page that provides exams for the customer. > I'm doing a search of the database of questions, and creating a = temporary database of random questions, which then generates a web page = that looks like an exam. >=20 > Somehow I am getting duplicate questions. > Is there anyway to instruct a [search] or [founditems] tag to reject = duplicates? >=20 > Heroes my search code: =20 > [search = db=3Dquestions_temp_vet.db&grSKU=3D999&eqQUESTION_TYPEdatarq=3DC_I&raQUEST= ION_NUMBERsort=3D1&QUESTION_NUMBERtype=3Dnum&max=3D[number_of_CI_questions= ]][founditems] >=20 > Would this code allow the SKU variable to return the number 1010 = twice? > Is there a way to prevent this from happening? >=20 > Thanks for any insight. >=20 > Stephen F Braun > sbraun1@twcny.rr.com > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us --Apple-Mail=_849BDCE3-8698-42B8-926E-DF9D96D479FA Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Of = course, you=E2=80=99re gonna want to find how you=E2=80=99re getting = dupes but if the SKU number is being duped, then adding 
SKUsumm=3Dt to the search will only get 1 unique instance of = that field value.

Quick workaround while you track down the real = issue.

HTh
Alex


On Aug 14, 2019, at 12:37 PM, Stephen Braun <sbraun1@twcny.rr.com> wrote:

Hello = All,  Happy Summer!

I have a web page that provides exams for the = customer.
I'm doing a search of the database of = questions, and creating a temporary database of random questions, which = then generates a web page that looks like an exam.

Somehow I am getting = duplicate questions.
Is there anyway to instruct a = [search] or [founditems] tag to reject duplicates?

Heroes my search code: =   
[search = db=3Dquestions_temp_vet.db&grSKU=3D999&eqQUESTION_TYPEdatarq=3DC_I= &raQUESTION_NUMBERsort=3D1&QUESTION_NUMBERtype=3Dnum&max=3D[nu= mber_of_CI_questions]][founditems]

Would this code allow the SKU variable = to return the number 1010 twice?
Is there a way to = prevent this from happening?

Thanks for any = insight.

Stephen F Braun
sbraun1@twcny.rr.com
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_849BDCE3-8698-42B8-926E-DF9D96D479FA-- . Alex Mccombie

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[input] [/input] (1997) Nav. 4 probs with cart (1997) same products but different (1998) PCS Frames-Default page is solution! (1997) Sorting by date (1997) RE: IIS4b2 and WebCatalog b19 (1997) quick [middle] Q (2000) RE: Can't get appendfile to work (1997) A question on sub-categories (1997) [WebDNA] Show next..... (2010) WebCat2b12 Mac.acgi--[searchstring] bug (1997) iis 4.0 (1997) High ASCII inside [LOOKUP] inside [LISTWORDS] (1998) Frames and WebCat (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) [PROTECT] Problem (2003) WebCatalog can't find database (1997) Credit card types (1997) [username][password] not showing up! HELP! (1999) [WebDNA] Sort by Row (2017)