passing wildcards from java to sql

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

passing wildcards from java to sql

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-22 : 07:36:46

Lars writes "Hi,

I am trying to search for a name in a table using a stored procedure getting a value from java. here goes my SP:

GO

CREATE PROCEDURE naamgebdat

@birthdate varchar(8),
@name varchar(34)

as
begin

select * from vmtemp where

geboortedatum = @birthdate And naam LIKE '%'+ @name + '%'

end
GO

the problem must be the Like statement because all my other sp's are working just fine from java to sql. (i get all the values i ask for). When i use this sp in sql server it works fine for me and i get the results i want. BUt with java it finds nothing at all, I have moved the wildcard in java back and forth but nothing seems to work. Java Forums can't help me either so i hoped maybe you can help me here..
thanx in advance!
Lars"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources