Query questions (ponctuation and format.)

[bigdan]

Hi,

I have a working access DB and asp script on a server and have 2 questions.

First:
When I do a search in the DB with a query from a user input text, How I can ignore pontuation
(french ponctuation ex: é, à , etc)?

Second:
When the DB return the result, How I can keep the same format as the format in the DB?
Example Line feed, multiple line feed, enter and more.

Thanks

Dan

 

[Veep]

I haven't had to deal with the punctuation thing but you can preserve your line feeds by using the replace function:
myVar=replace(rs(&quot;YourTextColumn&quot,vbcrlf,&quot;<BR>&quot
response.write(myVar)

 

[YannL]

1/ Use replace for each character you need to replace (they're not so many unless you have to deal with other languages)
2/ Use the html <pre></pre> tag.