numero = 11432
interpreted = N
texte = >*2) How to do a combination AND search triggered from a webpage with >several different options pop-up lists? I understand how to hard code a >combination search using the comma, but how do you achieve the same thing >as a form?In general, you put rq at the end of any field you want to be required to match (which is the same as AND). >*3) Is there a wildcard search syntax like * or ? that would let me type in >john* in a form text field and retrieve Johnson, Johnston, John123, etc.?It's effectively wildcarded already: searching for john will find Johnson and LeJohn. If you want to force the match to look at only the first letters of the database field, use Begins With, as in bwLastNamedata>*4) How to present retrieved results in a table 3 columns wide and 5 rows >tall per page? I read here recently how to color the Nth returned record by >seeing if the index was divisible by N, but that was in a single column >model....That can get tricky, but the technique is to use [showif] when divisible by the number of columns (and set max=15 so you only get 3x5 per page).
[foundItems]
[field]
[showif [index]\3]
[/showif] [/foundItems]
The [showif] above notices whenever 3 columns have been output, and closes off that row and starts another rowGrant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>*2) How to do a combination AND search triggered from a webpage with >several different options pop-up lists? I understand how to hard code a >combination search using the comma, but how do you achieve the same thing >as a form?In general, you put rq at the end of any field you want to be required to match (which is the same as AND). >*3) Is there a wildcard search syntax like * or ? that would let me type in >john* in a form text field and retrieve Johnson, Johnston, John123, etc.?It's effectively wildcarded already: searching for john will find Johnson and LeJohn. If you want to force the match to look at only the first letters of the database field, use Begins With, as in bwLastNamedata>*4) How to present retrieved results in a table 3 columns wide and 5 rows >tall per page? I read here recently how to color the Nth returned record by >seeing if the index was divisible by N, but that was in a single column >model....That can get tricky, but the technique is to use [showif] when divisible by the number of columns (and set max=15 so you only get 3x5 per page).
The [showif] above notices whenever 3 columns have been output, and closes off that row and starts another rowGrant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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...