2. ASPRunnerPro General questions
  3. Special character in 'where ...'
This topic is locked

Special character in 'where ...'

 		6/27/2006 4:01:29 AM
ASPRunnerPro General questions
J
 jlgouget author

Hello friends,
How can I do to accept special characters like ' in a request. For example "chambre d'hôte" ?
Thank you for your help.
Friendly with the good sun from Provence <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2871&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' />
Jean-Louis
Alexey admin 6/27/2006

Jean-Louis
the field and table names with special characters should be surrounded with wrappers - [] in Access and SQ Server.

The quotes should be doubled in the character expressions.
I.e. here is the sample WHERE clause:

where [room name] = 'chambre d''hôte'
J
 		jlgouget author 6/27/2006

Jean-Louis

the field and table names with special characters should be surrounded with wrappers - [] in Access and SQ Server.

The quotes should be doubled in the character expressions.
I.e. here is the sample WHERE clause:


Thank you so much ! It runs 100/100 ...