Passing "%" wild card to stored procedure

[john Smith]

Hi everyone,

This may be a simple question: When I pass "%" (without the quotes) in an
asp page to a stored procedure, I get the

Incorrect syntax near '%'.

message. I get the same message from the query analyzer, if I dont use the
single quotes. I cannot encase the % sign in single quotes or even double
quotes in the asp page. Is there a way around this?

Thanks for your help,
John

[Ray at]

sSQL = "select whatever from whereever where something like '%something%'"

What is your code/query/result of Response.Write YourQuery?

Ray at work

"john Smith" <smith@fakedomain.com> wrote in message
news:%23F%23DYygAEHA.2308@tk2msftngp13.phx.gbl...

> Hi everyone,
>
> This may be a simple question: When I pass "%" (without the quotes) in an
> asp page to a stored procedure, I get the
>
> Incorrect syntax near '%'.
>
> message. I get the same message from the query analyzer, if I dont use

the

> single quotes. I cannot encase the % sign in single quotes or even double
> quotes in the asp page. Is there a way around this?
>
> Thanks for your help,
> John
>
>

[McKirahan]

"john Smith" <smith@fakedomain.com> wrote in message
news:#F#DYygAEHA.2308@tk2msftngp13.phx.gbl...

> Hi everyone,
>
> This may be a simple question: When I pass "%" (without the quotes) in an
> asp page to a stored procedure, I get the
>
> Incorrect syntax near '%'.
>
> message. I get the same message from the query analyzer, if I dont use

the

> single quotes. I cannot encase the % sign in single quotes or even double
> quotes in the asp page. Is there a way around this?
>
> Thanks for your help,
> John

Perhaps you could use Chr(37).

[john Smith]

My SP is:


create proc AdvEmailReport
@custno varchar(6),
@indexno varchar (5),
@issueno varchar (5)
as
select pubname +' ' + p.issue as pubname, a.custno, custname, i.issueno,
indexno, count(*) as RespThisIssue,
(select count(*) from index_readers i join readers_all r on i.readerno =
r.readerno
where reportdate = (select max(reportdate) from readers_all) and
i.custno like @custno and i.issueno like @issueno
and i.indexno like @indexno)
as [TotalRespThisPeriod]

It works fine when I query like so in the query analyser:

exec AdvEmailReport 'cazgov', '%', 1025

John

"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:eNFkh2gAEHA.640@TK2MSFTNGP09.phx.gbl...

> sSQL = "select whatever from whereever where something like '%something%'"
>
> What is your code/query/result of Response.Write YourQuery?
>
> Ray at work
>
> "john Smith" <smith@fakedomain.com> wrote in message
> news:%23F%23DYygAEHA.2308@tk2msftngp13.phx.gbl...

> > Hi everyone,
> >
> > This may be a simple question: When I pass "%" (without the quotes) in

an

> > asp page to a stored procedure, I get the
> >
> > Incorrect syntax near '%'.
> >
> > message. I get the same message from the query analyzer, if I dont use

> the

> > single quotes. I cannot encase the % sign in single quotes or even

double

> > quotes in the asp page. Is there a way around this?
> >
> > Thanks for your help,
> > John
> >
> >

>
>

[Bob Barrows [MVP]]

john Smith wrote:

> My SP is:
>
>
> create proc AdvEmailReport
> @custno varchar(6),
> @indexno varchar (5),
> @issueno varchar (5)
>
> It works fine when I query like so in the query analyser:
>
> exec AdvEmailReport 'cazgov', '%', 1025
>

Well, you did not show us the line of code causing your problem, but here is
how I would run this stored procedure:

'create and open your connection, cn, then
set rs=createobject("adodb.recordset")
cn.AdvEmailReport 'cazgov', '%', 1025, rs

HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.