Vance,

nice that it was of help.

(When going from Java to the database, for example, it's
easiest to compose the value directly into the SQL query rather than
using a parameter.)  This seems quite viable.

Please allow me to recommend to you to NOT go this seemingly easy way. I went there myself (but did it in Python and PHP) some years ago, when I was young and needed the money.

Those "put Data into your SQL Statements with String Substitution" is easy to get working in the first step; but gets very very hard to keep correct in the long run. Please google up topics like "SQL injection" and "escaping characters for SQL" - it is a source of endless frustration.


Another tip to deal with GUIDs in applications:
Because GUIDs are rather long when expressed in base16 (hexadecimal notion), I made a transformer to Base62, using numbers and all regular letters. That shortens the typical GUID from 32chars to 21chars.

Harald
 

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Let's set so double the killer delete select all.

Reply via email to