[WebDNA] prevent database duplicates

This WebDNA talk-list message is from

2019

It keeps the original formatting. numero = 114690
interpreted = N
texte = 2312--000000000000b034e90590166125Content-Type: text/plain; charset="UTF-8"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 temporarydatabase of random questions, which then generates a web page that lookslike an exam.Somehow I am getting duplicate questions.Is there anyway to instruct a [search] or [founditems] tag to rejectduplicates?Heroes my search code:[searchdb=questions_temp_vet.db&grSKU=999&eqQUESTION_TYPEdatarq=C_I&raQUESTION_NUMBERsort=1&QUESTION_NUMBERtype=num&max=[number_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 Braunsbraun1@twcny.rr.com--000000000000b034e90590166125Content-Type: text/html; charset="UTF-8"Content-Transfer-Encoding: quoted-printable

Hello All, =C2=A0Happy S=ummer!

I have a web page that provides exams for the cus=tomer.

I'm doing a search of the database of questions, and c=reating a temporary database of random questions, which then generates a we=b page that looks like an exam.

Somehow I am getti=ng duplicate questions.

Is there anyway to instruct a [search] or= [founditems] tag to reject duplicates?

Heroes my =search code: =C2=A0=C2=A0

[search db=3Dquestions_temp_vet.db&=grSKU=3D999&eqQUESTION_TYPEdatarq=3DC_I&raQUESTION_NUMBERsort=3D1&a=mp;QUESTION_NUMBERtype=3Dnum&max=3D[number_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 happe=ning?

Thanks for any insight.

Stephen F Braun

sbraun1@twcny.rr.com

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us--000000000000b034e90590166125--. Associated Messages, from the most recent to the oldest:

Re: [WebDNA] prevent database duplicates (Stephen Braun 2019)
Re: [WebDNA] prevent database duplicates (Stuart Tremain 2019)
Re: [WebDNA] prevent database duplicates (Alex Mccombie 2019)
[WebDNA] prevent database duplicates (Stephen Braun 2019)

2312--000000000000b034e90590166125Content-Type: text/plain; charset="UTF-8"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 temporarydatabase of random questions, which then generates a web page that lookslike an exam.Somehow I am getting duplicate questions.Is there anyway to instruct a [search] or [founditems] tag to rejectduplicates?Heroes my search code:[searchdb=questions_temp_vet.db&grSKU=999&eqQUESTION_TYPEdatarq=C_I&raQUESTION_NUMBERsort=1&QUESTION_NUMBERtype=num&max=[number_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 Braunsbraun1@twcny.rr.com--000000000000b034e90590166125Content-Type: text/html; charset="UTF-8"Content-Transfer-Encoding: quoted-printable