[thelist] Access SQL Join and WHERE Clauses

[Ed McCarroll]

> FROM contacts
> LEFT JOIN points ON contacts.cid = points.powner
> WHERE contacts.fname LIKE '%#arguments.search#%';
> 
> And that throws the error: Too few parameters. Expected 1.

I don't know about the parameter error, but Access normally uses asterisks for
LIKE wildcards, not percent signs.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                             http://www.ComSimplicity.com
(310) 838-4330                      PO Box 654, Culver City, CA 90232
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -