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:

[OT] Might be of interest... (2006) [Announce]: Web server security and password protection (1997) WebCommerce: Folder organization ? (1997) no global [username] or [password] displayed ... (1997) Quit revisited (1997) Extended [ConvertChars] (1997) WCS Newbie question (1997) WebCat2final1 crashes (1997) [WebDNA] Talklist Archive & Twitter (2009) WebMerchant Problem (1999) Zip Code Search (2000) Security Question (1997) [WriteFile] problems (1997) Emailer Set Up (1997) Document Contains No Data! (1997) HELP!!! (1998) Changing the value assigned to a formvariable (2000) Quit revisited (1997) OK, here goes... (1997) Comments in db? (1997)