Re: Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58686
interpreted = N
texte = David, I have an instance where I have a search for fielddata (no comparison, no requirement) to find names in a database (not exact names; you get a short list, then pick the one you're looking for), and it finds any partial matches just fine. The search on the following page is simple as can be: [search db=whatever.db&memberdata=[url][incomingname][/url]] It works fine. Brian offered up the wo and wa solution, and it should work; I use that on keyword searches with no problems. All three ways work fine for me (wo, wa, nothing). So to reiterate what Gary said, there must be something else going on. Oh. I can point out one more thing that might be messing you up (it has messed me up in the past: If the incoming variable has a value of nothing, then WebDNA will ignore that part of the search criteria. Check the form page to make sure your form field is indeed bringing in the user input. Or perhaps the text variable is being reset on the page before it gets to the search. (You didn't by any chance just upgrade from version 3 to ver. 4 or higher?) Simply display [zipstore] right before the [search] to see what's coming in. (I do that a lot; it tells me immediately if there's a problem with the variable). A value of nothing is different from a variable that is not passed at all. In that case, you'd get the raw code of [zipstores], which would turn up no matches. An empty field on the other hand, would display as nothing in the search, and since you also say the search should find everything that's not ID=[blank], then everything would be found. Note that in my simple search above, there is no "Not equal blank" criterion, so if the box is coming through empty, nothing is found. I must have ended up doing that way (i.e. no comparison, no rq) because it was the only thing that worked for what I wanted. Sometimes you have to just keep trying all sorts of combinations. But first confirm the variables are being passed correctly. Terry ------------------------------------------------------------- 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:
David, I have an instance where I have a search for fielddata (no comparison, no requirement) to find names in a database (not exact names; you get a short list, then pick the one you're looking for), and it finds any partial matches just fine. The search on the following page is simple as can be: [search db=whatever.db&memberdata=[url][incomingname][/url]] It works fine. Brian offered up the wo and wa solution, and it should work; I use that on keyword searches with no problems. All three ways work fine for me (wo, wa, nothing). So to reiterate what Gary said, there must be something else going on. Oh. I can point out one more thing that might be messing you up (it has messed me up in the past: If the incoming variable has a value of nothing, then WebDNA will ignore that part of the search criteria. Check the form page to make sure your form field is indeed bringing in the user input. Or perhaps the text variable is being reset on the page before it gets to the search. (You didn't by any chance just upgrade from version 3 to ver. 4 or higher?) Simply display [zipstore] right before the [search] to see what's coming in. (I do that a lot; it tells me immediately if there's a problem with the variable). A value of nothing is different from a variable that is not passed at all. In that case, you'd get the raw code of [zipstores], which would turn up no matches. An empty field on the other hand, would display as nothing in the search, and since you also say the search should find everything that's not ID=[blank], then everything would be found. Note that in my simple search above, there is no "Not equal blank" criterion, so if the box is coming through empty, nothing is found. I must have ended up doing that way (i.e. no comparison, no rq) because it was the only thing that worked for what I wanted. Sometimes you have to just keep trying all sorts of combinations. But first confirm the variables are being passed correctly. Terry ------------------------------------------------------------- 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/
Terry Wilson
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:
SMSI - MacWorld (2005)
[WebDNA] List Archives? (2009)
Mac Lockup Problems (1998)
Multiple catalog databases and showcart (1997)
Modifying databases manually (was Banner DNA) (1997)
webcat 2.1 (1997)
It's working (1997)
PCS Frames (1997)
Multiple catalog databases and showcart (1997)
default value from Lookup (was Grant, please help me) (1997)
RAM variables (1997)
page redirect in webDNA (1997)
PCS Frames (1997)
WC1.6 to WC2 date formatting (1997)
For those of you not on the WebCatalog Beta... (1997)
Search in 2 or more catalogs (1997)
Inventory Adjustment SOLUTION (2000)
[WebDNA] Populate Bootstrap Modal with AJAX WebDNA (2015)
Online reference (1997)
Help! WebCat2 bug (1997)