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:

Can I invoke an ssi plugin from within a webcat page (1997) TCP Connect (2000) cc auth with [purchase] (1998) [WebDNA] OT: gmx.com (2009) Re:Has this happened to you? (was:Emailer Chokes on bad address) (1997) Search and Show Question (2003) Re(7): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) URGENT: WebCatalog 2.0 (1998) Multiple instances of database (2003) [ShowIf] and empty fields (1997) Bug when including a db file ... ? (2000) webcat- multiple selection in input field (1997) newcart (1997) WebCatalog and WebMerchant reviewed by InfoWorld (1997) Beta and new version questions? (1998) Lost Field (1998) Multi-processor Mac info ... (1997) calculating tax rates, mail order solutions and version 2 (1997) Bug alert! (1997) 2nd WebCatalog2 Feature Request (1996)