Re: SQLExecute with an argument
- To: mathgroup at smc.vnet.net
- Subject: [mg109926] Re: SQLExecute with an argument
- From: Jagra <jagra24891 at mypacks.net>
- Date: Sun, 23 May 2010 03:17:09 -0400 (EDT)
- References: <ht7nbr$pss$1@smc.vnet.net>
I don't know what happened in my earlier post for it to have picked up a bunch of extraneous characters that confuse the issue. Unable to edit an earlier post, I've reentered it below, hoping it will come through without the extra characters.... A bit simplified but I hope this explains my problem... This works: SQLExecute[conn,"SELECT column1, FROM table1 WHERE dateColumn >='2007-02-15'"]; But I'd like to make the date ('2007-02-15') a parameter. I've tried this: SQLExecute[conn,"SELECT column1, FROM table1 WHERE dateColumn >='`1`'","2007-02-15" ]; and a whole variety of other combinations like: SQLExecute[conn,"SELECT column1, FROM table1 WHERE dateColumn >='`1`'", {"2007-02-15"} ]; and this: SQLExecute[conn,"SELECT column1, FROM table1 WHERE dateColumn >='`1`'", SQLArgument[{"2007-02-15"}] ]; and this: SQLExecute[conn,"SELECT column1, FROM table1WHERE 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.