Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2008

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

Search the Archive

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








  • Prev by Date: RE: Bras and Kets
  • Next by Date: Re: $Aborted
  • Previous by thread: Re: Storing and Loading Definitions / Emulating Associative Arrays
  • Next by thread: Re: Variable passing to SQLExecute