Re: [WebDNA] prevent database duplicates

This WebDNA talk-list message is from

2019


It keeps the original formatting.
numero = 114692
interpreted = N
texte = 2314 --Apple-Mail-E9D32D7B-6A8A-4652-9177-357905ACBDA2 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Try fixing your search to start grSKUdatarq=3D Regards Stuart Tremain Pharoah Lane Software=20 7/76 Reserve Road=20 Artarmon NSW 2064 AUSTRALIA +612 8971 4431 > On 15 Aug 2019, at 2:37 am, 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 d= atabase 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 dupli= cates? >=20 > Heroes my search code: =20 > [search db=3Dquestions_temp_vet.db&grSKU=3D999&eqQUESTION_TYPEdatarq=3DC_I= &raQUESTION_NUMBERsort=3D1&QUESTION_NUMBERtype=3Dnum&max=3D[number_of_CI_que= stions]][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 s= ent to you because you are subscribed to the mailing list talk@webdna.us To u= nsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/p= age.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail-E9D32D7B-6A8A-4652-9177-357905ACBDA2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Try fixing your search to start

grSKUdatarq=3D

Regards
Stuart Tremain

Ph= aroah Lane Software 
7/76 Reserve Road 
Artarmon NSW 2064
AUSTRALIA
+61= 2 8971 4431

On 15 Aug 2019, at 2:37 a= m, Stephen Braun <sbraun1@twcny.r= r.com> wrote:

Hello All,  Happy S= ummer!

I have a web page that provides exams for the cust= omer.
I'm doing a search of the database of questions, and creatin= g a temporary database of random questions, which then generates a web page t= hat looks like an exam.

Somehow I am getting duplic= ate questions.
Is there anyway to instruct a [search] or [foundite= ms] tag to reject duplicates?

Heroes my search code= :   
[search db=3Dquestions_temp_vet.db&grSKU=3D999&= amp;eqQUESTION_TYPEdatarq=3DC_I&raQUESTION_NUMBERsort=3D1&QUESTION_N= UMBERtype=3Dnum&max=3D[number_of_CI_questions]][founditems]
Would this code allow the SKU variable to return the number 101= 0 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-leav= e@webdna.us archives: http://www.w= ebdna.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-E9D32D7B-6A8A-4652-9177-357905ACBDA2-- . 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)
2314 --Apple-Mail-E9D32D7B-6A8A-4652-9177-357905ACBDA2 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Try fixing your search to start grSKUdatarq=3D Regards Stuart Tremain Pharoah Lane Software=20 7/76 Reserve Road=20 Artarmon NSW 2064 AUSTRALIA +612 8971 4431 > On 15 Aug 2019, at 2:37 am, 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 d= atabase 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 dupli= cates? >=20 > Heroes my search code: =20 > [search db=3Dquestions_temp_vet.db&grSKU=3D999&eqQUESTION_TYPEdatarq=3DC_I= &raQUESTION_NUMBERsort=3D1&QUESTION_NUMBERtype=3Dnum&max=3D[number_of_CI_que= stions]][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 s= ent to you because you are subscribed to the mailing list talk@webdna.us To u= nsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/p= age.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail-E9D32D7B-6A8A-4652-9177-357905ACBDA2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Try fixing your search to start

grSKUdatarq=3D

Regards
Stuart Tremain

Ph= aroah Lane Software 
7/76 Reserve Road 
Artarmon NSW 2064
AUSTRALIA
+61= 2 8971 4431

On 15 Aug 2019, at 2:37 a= m, Stephen Braun <sbraun1@twcny.r= r.com> wrote:

Hello All,  Happy S= ummer!

I have a web page that provides exams for the cust= omer.
I'm doing a search of the database of questions, and creatin= g a temporary database of random questions, which then generates a web page t= hat looks like an exam.

Somehow I am getting duplic= ate questions.
Is there anyway to instruct a [search] or [foundite= ms] tag to reject duplicates?

Heroes my search code= :   
[search db=3Dquestions_temp_vet.db&grSKU=3D999&= amp;eqQUESTION_TYPEdatarq=3DC_I&raQUESTION_NUMBERsort=3D1&QUESTION_N= UMBERtype=3Dnum&max=3D[number_of_CI_questions]][founditems]
Would this code allow the SKU variable to return the number 101= 0 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-leav= e@webdna.us archives: http://www.w= ebdna.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-E9D32D7B-6A8A-4652-9177-357905ACBDA2-- . Stuart Tremain

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:

unable to launch acgi in WebCat (1997) Announce: Bug fix talk list (1999) change the number format (1997) PSC recommends what date format yr 2000??? (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) [numfound] within summ=t ??? (2000) RePost: NAT and the CART (1999) WEBCAT with SQL backend. Help please! (2000) [WebDNA] CICADA (2009) Page Views Database (2004) Math (1997) [WebDNA] Set UID/GID/Permissions (2009) Permission denied? (2004) Talk List Admin Page? (2000) off-topic: SMS interface? (2001) [WebDNA] New Mountain Lion OSX Server (2013) emailer (1997) Hiding HTML and breaking the page (1997) Scoping rules in WebDNA 4.0 (2000) RE: Help name our technology! (1997)