to put variables in sql request?!

[imadouino]

Hi,

How i can to put variables in sql request?!

Thank youu for your help.

[jcarmody · Accepted solution]

Format Into String

[imadouino]

This is exactly what I was looking for
Thank youuuuu

[imadouino]

I'm sorry to disturb you but, why I get commas instead of points in the result?

[cstorey · Accepted solution]

LabVIEW uses your regional number formatting settings from Window. 

For instance your Windows is set to French, then  you use a "," (comma) as number decimal separator instead of a period that you would get if you used English (US).

[drjdpowell · Accepted solution]

Its better to use bound parameters if your SQL library supports it.  String formatting may work for "input 4"="jcarmody", but will fail for "jcarmody's".  Even worse is "jcarmody');drop table Banc2".

[jcarmody · Accepted solution]

---

@drjdpowell wrote:

[...]Even worse is "jcarmody');drop table Banc2".

---

Oh. Yes. Little Jimmy Tables, we call him.