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:

format search comparison Q (2000) Locking up with WebCatalog... (1997) [showif]/[hideif] question (1997) Emailer (WebCat2) (1997) Include files (1998) Template Encryption (1998) sendmail and CGatePro - Not working (2003) This list needs a digest: rant, rave... (1997) Where's 3.0 Online Docs? (1999) WebCat2b15MacPlugin - showing [math] (1997) New WebCatalog site! (1997) Extra equals signs with IE? (More debugging questions...) (1997) Change in Host? (1999) Emailer (WebCat2) (1997) Search design (1997) WebCommerce: Folder organization ? (1997) Re(5): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) problem using ErrorMessages.db to redirect requests (2004) [format xs] freeze (1997) Emailer Error 550 (Was Strange Crash) (1998)