SQL VARIABLES

[Sylvain Lafontaine]

If PAGINA is a char or a varchar field, then you must enclose inside single
quotes:

Replace: WHERE PAGINA = " + Replace(setPagina, "'", "''") + ""
With: WHERE PAGINA = '" + Replace(setPagina, "'", "''") + "'"

Also, in the case that setPagina is emtpy, then something like:

setPagina = Request.QueryString("PAGINA") & ""

The addition of: « & "" » at the end will ensure that setPagina is not empty
or not null.

S. L.

 

[RAW]

Hi I have a little problem here with my code Iam asp user and Im trying
to

 

[RAW]

THANKS THIS WORK PERFECT

If PAGINA is a char or a varchar field, then you must enclose inside single
quotes:

Replace: WHERE PAGINA = " + Replace(setPagina, "'", "''") + ""
With: WHERE PAGINA = '" + Replace(setPagina, "'", "''") + "'"

Also, in the case that setPagina is emtpy, then something like:

setPagina = Request.QueryString("PAGINA") & ""

The addition of: « & "" » at the end will ensure that setPagina is not empty
or not null.

S. L.