Servoy Forum

Hi guys,

problem: I've written a conversion tool for my servoy data to sqlite. Works perfectly (well.....)
I can export an sql file that contains all instructions to generate an sqlite file. There is one problem with the text qualifiers.
I started using ' as text qualifier but than hit the problem that in some languages ' is used within text, so I switched to " as a text qualifier, enforcing quotes to be single quote. That worked OK until I wanted to export some html formatted code. This html uses "" in some place size="3" or font="tahoma". This again messes things up. Since for html there is no need to use double quotes, single quotes render as well, here's my question
Is it possible to create a setting where you indicate that in html constants are in single quotes or do you see another solution ?

TIA

the best is to escape the single quotes you find in text.
By using two single quotes you escape it for SQL

the single quotes are not the problem (anymore).

The problem lies in exporting an html area where constant values are double quoted. What I was looking for is a means of having the html area using single quotes in stead of the double quotes that are used by default.
Those double quotes in my opinion should be single quotes by default or as some parameter in preferences

TIA

Double qoutes are in the HTML spec, so they cannot be changed, using single qoutes en escaping single qoutes if found in the text is the most easy option.