Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by smudger115
-
ASP / SQL - "AND LIKE" QUESTION
Hi .... I spotted and removed that extra closing parentheses - but made no difference. regarding nulls - no all fields should contain values. and yes i have given every field a value in my tests (and written them to double check)- smudger115
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
ASP / SQL - "AND LIKE" QUESTION
Hi PH thanks for that - i double checked my fields some were set to MEMO - so i have changed to TEXT - but no change. I am fairly sure that its a problem with the positioning of Parentheses - but its hurting my head - think i will look again 2morro regards Nigel- smudger115
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
ASP / SQL - "AND LIKE" QUESTION
Hi Steve thanks for your reply 1 - yes i tried that first - connection is ok 2 - yes i think your right - but do you have any ideas where the missing parentheses belong ! (as i said i'm quite a newbie) 3 - unfortunately my client wants to narrow the search as much as possible (she is a...- smudger115
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
ASP / SQL - "AND LIKE" QUESTION
Help Please - i a bit ofg a newbie! have i done something wrong here ..... <% ' get form values licence = TRIM( Request( "PRO_valid_licence" ) ) Area = TRIM( Request( "PRO_country_area" ) ) City = TRIM( Request( "PRO_serving_city" ) ) RealName = TRIM( Request( "PRO_RealName" ) ) Name1 = TRIM(...- smudger115
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
