CSV WRITE

[Marving Jr]

I'm trying use CSVWRITE  with quote inside query, but i can not get it

CALL CSVWRITE

(   '/home/gb/carrier.csv', 

    'SELECT NAME FROM CARRIER WHERE NAME = 'what ever you want'',

    'fieldSeparator=;'

)

[Exception, Error code 42.001, SQLState 42001] Error de Sintaxis en sentencia SQL

Also with oduble quotes

CALL CSVWRITE

(   '/home/gb/carrier.csv', 

    'SELECT NAME FROM CARRIER WHERE NAME = "what ever you want"',

    'fieldSeparator=;'

)
[Exception]
Column "what ever you want" not found; SQL statement:

Can somebody help me?

Regards

[goran....@gmail.com]

Try: (note the extra ‘ chars added in yellow)

CALL CSVWRITE

(   '/home/gb/carrier.csv', 

    'SELECT NAME FROM CARRIER WHERE NAME = ''what ever you want''',

    'fieldSeparator=;'

)

 

That is add an extra ' Is you have quote string inside a quoted string… (escaping the quote char)

So if I would insert a string “That’s it”, You would have to do do: insert into t1 values(‘That’’s it’)

 

/Goran

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[Marving Jr]

Thank you so much.

You're right.

Thanks, again Goran

Regards