Re: Wingz & SQL Q

In article <2gej2vINNn66@emory.mathcs.emory.edu> mltsa!jgill@mlgtw.att.com writes: > Wingz/SQL Problem!... > This works: > > CALL DB:DBSend("select counter from table10 where (time >= 10);") > > But this doesn't: > > ftime = 10 > CALL DB:DBSend("select counter from table10 where (time >= ftime);") > > Any Ideas? Yes, try this: ftime = 10 query = "select counter from table10 where (time >= "&ftime&");" CALL DB:DBSend(query) It's probably not necessary to use a variable to create the query string, but I've found it makes for more readable code. The topic of merging variables with strings is dealt with somewhere in the HyperScript manual; the concatenation operator is the ampersand "&". Hope this helps! Brian O'Sullivan | e-mail: bosulliv@mitre.org MITRE Corp., Washington DC | Space Program Engineering | ** my opinions, not MITRE's **