|
Posted by robert on 05/15/06 05:38
| LOL. Careful snipping so you can continue to make the same point AGAIN
| and AGAIN. I didn't advise using the method or encourage it.
the snip is to get the crap out of the way. my point IS the same however.
| I wrote:
| "...you could give $surname a nonsense value before doing the search."
sorry for not allowing that you cannot grasp equivocation. to me (and
probably others), "nonsense value" IS "magic value". now, having quoted
yourself, how can you support "i didn't advise using the method [magic
values] or encourage it"? now that's a lol.
| It's a statement of fact.
what is the statement and what is the fact?
| >the IDEAL solution would be to handle this in the sql statement and NOT
the
| >code...like:
| >
| >SELECT *
| >FROM foo
| >WHERE fieldSearched = '$valueToFind'
| >AND '$valueToFind' != ''
| >
| >problem solved!
|
| "THE" SQL? I didn't see anything about SQL mentioned.
sql...standard query language. and it is very much safe to assume that a
query is defined that uses a search value to return a slice of data...unless
you believe the db "magically" knows what the end-user wants to see.
Navigation:
[Reply to this message]
|