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:

Custom WebCat Prefs ... (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Formating found categories (1997) How to Sort Summ data ? (1997) Search design (1997) Almost a there but..bye bye NetCloak (1997) send mail problem? (1997) webcat 2.1 new cart fields - please explain more (1998) writing orders to a db (1997) Delete problem (2005) Nested search (1997) WebCat2: Found Items syntax, etc. (1997) Add more fields to an existent data base (1997) Price Not Appearing (2000) Problems passing [SKU] with $Replace in 2.0 (1997) Using WebCat for product info requests (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Plugin or CGI or both (1997) [price] maddness (2002) Major bug report on rootbeer (1997)