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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: waynefeltham
- Order by date
-
Search multiple columns using multiple parameters
Hi there thanks for the reply but I think a collegue of mine has solved it and the SQL is a little clearer because i don't use as many IF statements (something I wanted to get away from). Here it is: CREATE PROCEDURE CustomerSearch @AccountNumber varchar(20), @CompanyName...- waynefeltham
- Post #3
- Forum: Microsoft SQL Server: Programming
-
MDAC 2.8 problem
Hi all I had an inssue with MDAC 2.8 not supporting something that 2.7 did (can't remember what it was now, something to do with adding parameters when using the command object I think)...anyways... I simply got a version of 2.7 and installed that over the top and everything was fine? I don't...- waynefeltham
- Post #10
- Forum: Microsoft SQL Server: Programming
-
Search multiple columns using multiple parameters
Hi All My first post here. I've been struggling for several days now and still can't get this to work! I have a form with 4 fields which represent the 4 columns in my DB that I want users to search. AccountNumber CompanyName TelephoneNumber PostCode I want users to be able to enter search...- waynefeltham
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
