Services & ResourcesWolfram ForumsMathGroup Archive

[Date Index] [Thread Index] [Author Index]

Variable passing to SQLExecute

• To: mathgroup at smc.vnet.net
• Subject: [mg93456] Variable passing to SQLExecute
• From: johney at dsl.net
• Date: Sun, 9 Nov 2008 05:25:03 -0500 (EST)

I'm trying to pass a variable to a SQLExecute command as follows:

v1=55
v2 =1500
SQLExecute[db, "UPDATE table1 SET result = v1 WHERE recnum = v2"]

If I substitute v1 for a number it works.

Thanks