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

MathGroup Archive 2010

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

Search the Archive

SQLExecute with an argument

  • To: mathgroup at smc.vnet.net
  • Subject: [mg109912] SQLExecute with an argument
  • From: Jagra <jagra24891 at mypacks.net>
  • Date: Sat, 22 May 2010 00:42:50 -0400 (EDT)

A bit simplified but I hope this explains my problem...

This works:

SQLExecute[conn, "=E2=80=A8SELECT column1, =E2=80=A8FROM table1=E2=80=A8 WHERE dateColumn >=
'2007-02-15'"=E2=80=A8];

But I'd like to make the date ('2007-02-15') a parameter.  I've tried
this:

SQLExecute[conn, "=E2=80=A8SELECT column1, FROM table1=E2=80=A8 WHERE dateColumn >=
'`1`'",
"2007-02-15" ];

and a whole variety of other combinations like:

SQLExecute[conn, "=E2=80=A8SELECT column1, FROM table1=E2=80=A8 WHERE dateColumn >=
'`1`'",
{"2007-02-15"} ];

and this:

SQLExecute[conn, "=E2=80=A8SELECT =E2=80=A8column1, FROM table1=E2=80=A8 WHERE dateColumn >=
'`1`'",
SQLArgument[{"2007-02-15"}] ];

and this:

SQLExecute[conn, "SELECT column1, FROM table1=E2=80=A8 WHERE dateColumn >=
'`1`'",
DateList["2007-02-15"] ];

BUT I can't seem to figure it out.  Any suggestions or guidelines
beyond the documentation?
Perplexed but hopeful.
Thanks a lot.


  • Prev by Date: V. 6.0: PNG export problems
  • Next by Date: Re: data in absolutetime
  • Previous by thread: V. 6.0: PNG export problems
  • Next by thread: Re: SQLExecute with an argument