On Jan 2, 2008 11:20 AM, Hines, Catherine <[EMAIL PROTECTED]> wrote: > I want to issue the following command: > > > > "UPDATE BLAH_BLAH SET DIRECT = DIRECT * 2 WHERE PROGRAM = > '"+m.program+"' " > > > > I'd like to replace the '2' with a variable, as I've replaced the > program value with a variable. It's not a character, obviously, and > I've tried every permutation of single- and double-quotes and plus signs > I can think of. What's the secret to using a numeric variable in a > statement like this? > --------------------------------------------
sql = "UPDATE BLAH_BLAH SET DIRECT = DIRECT * " + myIntVal.toString() +" WHERE PROGRAM = '"+m.program+"' " -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
