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:

WebCatalog for Postcards ? (1997) Help! I've fallen in Structured Query Language and can'tget (2002) Queertrons? (1997) WebCatalog can't find database (1997) Review comparison by PC Magazine: Open for On-line Business (1997) Search in 2 or more catalogs (1997) More DateMath problems (1997) WebCat2 as a chat server? (1997) WebDelivery downloads alias, not original ? (1997) A question on sub-categories (1997) Mac: [ListFiles] bug alert (1997) page redirect in webDNA (1997) Questions To Answer (1997) WebCatalog can't find database (1997) Size images (2002) Repeating Fields (1997) Emailer program? (2000) Webcat Manual and TeaRoom Examples Uses Different Examples. (1997) rotating thumbnails (1997) Zip Code Lookups (1999)