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:

encrypt/decrypt - are docs correct?? (2002) Search in 2 or more catalogs (1997) 4.5 to 5.0 question (2003) WebCat2 - storing unformatted date data? (1997) date formatting for CC card expiration date check (1998) Authenticate (1999) Frames and WebCat (1997) Tax & Shipping (1997) Version 4? (2000) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Carrying Forward (1998) [SearchString] usage (1997) database search help (2003) SQL connection (2000) [convertchars] problem... (2000) RE: Emailer prefs in two places ... (1997) Conveting Characters to Graphics (1997) Old Topic - [OT] - server speeds. (2002) WebCat2.0 [format thousands .0f] no go (1997) WebCat2 - many [carts] on one template page? (1997)