Re: Search for starts with and ends with?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47355
interpreted = N
texte = >Two searches. First find all the SKU's that contain 112233 and then the>second search of the first result set that finds all SKU's that have an L>in them.Instead of two searches, I would just use the group field technique and do one search. The only problem is that you want to find all records that END WITH L, but there's no webdna comparison for that, so if L appears anywhere but at the end of the sku you'll still have to use showif's inside your founditems in order to finally display the right records.Sincerely,Kenneth Grome---------------------------------------------------WebDNA Professional Training and Development Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines http://www.webdna.net----------------------------------------------------------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>Two searches. First find all the SKU's that contain 112233 and then the>second search of the first result set that finds all SKU's that have an L>in them.Instead of two searches, I would just use the group field technique and do one search. The only problem is that you want to find all records that END WITH L, but there's no webdna comparison for that, so if L appears anywhere but at the end of the sku you'll still have to use showif's inside your founditems in order to finally display the right records.Sincerely,Kenneth Grome---------------------------------------------------WebDNA Professional Training and Development Center175 J. Llorente Street +63 (32) 255-6921Cebu City, Cebu 6000 kengrome@webdna.netPhilippines http://www.webdna.net----------------------------------------------------------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Kenneth Grome
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:
Shownext from POST (2000)
question: back button prevention (1997)
DataBaseHelper Flawed (1997)
DNS Lookup 2 (2000)
Interactive Online Docs Was: [OT] Mozilla | Was: R.I.P. (2003)
Re:Review comparison by PC Magazine: Open for On-line Business (1997)
Bug Report, maybe (1997)
Showif Question (2001)
psst (1997)
[protect admin] (1997)
WebDNA creates DUPLICATE SHOPPING CART NUMBERS (2004)
updating with ProductEditor (1998)
serial number generation (1997)
Bug or syntax error on my part? (1997)
WebCat Contest Please Clarify (1998)
Conditional searching & displaying (1997)
wrong input values? (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Multiple postings (2000)
WebCat2 - Getting to the browser's username/password data (1997)