Re: Substitution inside an SQLExecute statement
- To: mathgroup at smc.vnet.net
- Subject: [mg64075] Re: [mg64062] Substitution inside an SQLExecute statement
- From: Chris Williamson <chrisw at wolfram.com>
- Date: Tue, 31 Jan 2006 01:14:22 -0500 (EST)
- References: <200601300410.XAA29450@smc.vnet.net>
- Sender: owner-wri-mathgroup at wolfram.com
You can use a syntax such as...
SQLExecute[conn, "UPDATE MathTest SET sireId = `1` WHERE nameId =`2`",
{5, 6}]
Chris Williamson
Patricia-and-Charles Jones wrote:
>When I use Mathematica to connect to a database an expression such as
>SQLExecute[conn,"UPDATE MathTest SET sireId = 5 WHERE nameId =6"] works
>correctly. However, I would like to be able to replace the 5 and 6 with
>variables computed
>exterior to the SQLExecute statement but evaluated within the SQLExecute
>statement. The " "
>quotes present a stumbling block as they prevent evaluation of exterior
>vaiables, I think.
>
>
>
- References:
- Substitution inside an SQLExecute statement
- From: "Patricia-and-Charles Jones" <brio11@earthlink.net>
- Substitution inside an SQLExecute statement