Results 1 to 1 of 1
2005-02-01, 23:50 #1
- Join Date
- Jan 2001
- austin, Texas, USA
- Thanked 0 Times in 0 Posts
Wildcard Blues... ASP & SQL Server
Aauugh! I have a handy-dandy search screen that accepts SQL Server wildcard '%' to output a table on hitting the db. HOWEVER, on another section of code I am reloading the page and am using the syntax <font face="Georgia">mypage.asp?SortBy=1&Provider=< %=Provider% ></font face=georgia> to load a variable. Unfortunately, referencing a search term with the wildcard % gets stripped in the inline <font face="Georgia">< % = SomeStuff % > </font face=georgia> syntax. There's a work-around for this (it's not pretty but I might do it anyway) but I was wondering if there's a way to deal with this issue.
BTW, I can't predict if or where a wildcard might be: in front or back or both on the search string text, so bear that in mind...
<img src=/S/compute.gif border=0 alt=compute width=40 height=20>