how % sign use in asp

mateenmohd · July 26th, 2003, 03:11 AM

following query give error in % sign
How can use % sign in asp ?

ssql="select drawings.date_recd,drawings.date_revd,drawings.dty pe,sectors.sect_area,sectors.sect_count,drawings.n ame from drawings,sectors where drawings.name=sectors.name and drawings.dtype like ('"%&p&%"') and sectors.sect_area like ('"%&u&%"') and sectors.sect_count like ('"%&sect_count&%"') "

Mateen

pgtips · July 28th, 2003, 04:47 AM

only the variables p, u and sect_count need to be outside the string, not the % signs:

Code:

ssql="select drawings.date_recd,drawings.date_revd,drawings.dtype,sectors.sect_area,sectors.sect_count,drawings.name from drawings,sectors where drawings.name=sectors.name and drawings.dtype like ('%"&p&"%') and sectors.sect_area like ('%"&u&"%') and sectors.sect_count like ('%"&sect_count&"%') "

mateenmohd · July 28th, 2003, 06:56 AM

thanks

Quote:

quote:Originally posted by pgtips
only the variables p, u and sect_count need to be outside the string, not the % signs:

Code:

ssql="select drawings.date_recd,drawings.date_revd,drawings.dtype,sectors.sect_area,sectors.sect_count,drawings.name from drawings,sectors where drawings.name=sectors.name and drawings.dtype like ('%"&p&"%') and sectors.sect_area like ('%"&u&"%') and sectors.sect_count like ('%"&sect_count&"%') "