Re: [WebDNA] prevent database duplicates

This WebDNA talk-list message is from

2019


It keeps the original formatting.
numero = 114693
interpreted = N
texte = 2315 --0000000000005c04080590289f02 Content-Type: text/plain; charset="UTF-8" Thanks Alex & Stuart. I've included both of your recommendations, and now I just wait and see if there are any additional problems reported. Best, sfb Stephen F Braun sbraun1@twcny.rr.com On Wed, Aug 14, 2019 at 8:07 PM Stuart Tremain wrote: > Try fixing your search to start > > grSKUdatarq= > > Regards > Stuart Tremain > > Pharoah Lane Software > 7/76 Reserve Road > Artarmon NSW 2064 > AUSTRALIA > +612 8971 4431 > > On 15 Aug 2019, at 2:37 am, Stephen Braun 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=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 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=55 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=55 Bug Reporting: support@webdna.us --0000000000005c04080590289f02 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks Alex & Stuart. =C2=A0 I've included both of= your recommendations, and now I just wait and see if there are any additio= nal problems reported.

Best,
sfb


=
Stephen F Braun
sbraun1@twcny.rr.com


On Wed, Aug 14, 2019 at 8:07 PM Stuart Tremain &l= t;webdna@plsoftware.com.au&= gt; wrote:
Try fixing your sear= ch to start

grSKUdatarq=3D

Regards
Stuart Tremain

Pharoah Lane Software=C2=A0
<= div>7/76 Reserve Road= =C2=A0
Artarmon NSW 2064
AUSTRALIA
+612 8971 4431

O= n 15 Aug 2019, at 2:37 am, Stephen Braun <sbraun1@twcny.rr.com> wrote:

Hello All, =C2=A0Happy Summer!

I ha= ve a web page that provides exams for the customer.
I'm doing= a search of the database of questions, and creating a temporary database o= f random questions, which then generates a web page that looks like an exam= ..

Somehow I am getting duplicate questions.
<= div>Is there anyway to instruct a [search] or [founditems] tag to reject du= plicates?

Heroes my search code: =C2=A0=C2=A0
[search db=3Dquestions_temp_vet.db&grSKU=3D999&eqQUESTION_TYP= Edatarq=3DC_I&raQUESTION_NUMBERsort=3D1&QUESTION_NUMBERtype=3Dnum&a= mp;max=3D[number_of_CI_questions]][founditems]

Wou= ld this code allow the SKU variable to return the number 1010 twice?
<= div>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@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@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 --0000000000005c04080590289f02-- . 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)
2315 --0000000000005c04080590289f02 Content-Type: text/plain; charset="UTF-8" Thanks Alex & Stuart. I've included both of your recommendations, and now I just wait and see if there are any additional problems reported. Best, sfb Stephen F Braun sbraun1@twcny.rr.com On Wed, Aug 14, 2019 at 8:07 PM Stuart Tremain wrote: > Try fixing your search to start > > grSKUdatarq= > > Regards > Stuart Tremain > > Pharoah Lane Software > 7/76 Reserve Road > Artarmon NSW 2064 > AUSTRALIA > +612 8971 4431 > > On 15 Aug 2019, at 2:37 am, Stephen Braun 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=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 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=55 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=55 Bug Reporting: support@webdna.us --0000000000005c04080590289f02 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks Alex & Stuart. =C2=A0 I've included both of= your recommendations, and now I just wait and see if there are any additio= nal problems reported.

Best,
sfb


=
Stephen F Braun
sbraun1@twcny.rr.com


On Wed, Aug 14, 2019 at 8:07 PM Stuart Tremain &l= t;webdna@plsoftware.com.au&= gt; wrote:
Try fixing your sear= ch to start

grSKUdatarq=3D

Regards
Stuart Tremain

Pharoah Lane Software=C2=A0
<= div>7/76 Reserve Road= =C2=A0
Artarmon NSW 2064
AUSTRALIA
+612 8971 4431

O= n 15 Aug 2019, at 2:37 am, Stephen Braun <sbraun1@twcny.rr.com> wrote:

Hello All, =C2=A0Happy Summer!

I ha= ve a web page that provides exams for the customer.
I'm doing= a search of the database of questions, and creating a temporary database o= f random questions, which then generates a web page that looks like an exam= ..

Somehow I am getting duplicate questions.
<= div>Is there anyway to instruct a [search] or [founditems] tag to reject du= plicates?

Heroes my search code: =C2=A0=C2=A0
[search db=3Dquestions_temp_vet.db&grSKU=3D999&eqQUESTION_TYP= Edatarq=3DC_I&raQUESTION_NUMBERsort=3D1&QUESTION_NUMBERtype=3Dnum&a= mp;max=3D[number_of_CI_questions]][founditems]

Wou= ld this code allow the SKU variable to return the number 1010 twice?
<= div>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@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@webdna.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@w= ebdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: suppo= rt@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 --0000000000005c04080590289f02-- . Stephen Braun

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:

Make sure I understand this??? (1997) [WebDNA] [OT] - One Man. One Road. (2010) possible, WebCat2.0 and checkboxes-restated (1997) [WebDNA] SOS request (2019) users.db (1999) BUG in [showif] using ^ (contains) (1997) StoreBuilder Shopping Cart (2000) Re[2]: Webcatalog 4.0 - When will we be able to beta test it (2000) Strange intermittent WebDNA problems (2008) docs for WebCatalog2 (1997) Accented chars and emailer (1998) Can anyone help me with this shipping thing? (1998) math on date? (1997) Plugin or CGI or both (1997) Multiple prices (1997) WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) [WebDNA] reverse rank=off (2008) Simple Database close connection (2001) Special characters in field names (1998) Blacklisted (2002)