Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : TeleFlow Designer & Simulator

Author Message
 Post subject:
PostPosted: Thu Sep 16, 2004 10:25 pm 
Offline

Joined: Thu Sep 16, 2004 10:21 pm
Posts: 5
SELECT DATE_ADD(NOW(), INTERVAL "@VARIABLE" MINUTE); <br> <br>I made this time/math select statement in MySQL - how can i bring the results back into a TeleFlow variable? I am not sure what to define the original select statement as in the local variable.


Back to top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 17, 2004 8:56 am 
Offline
Site Admin

Joined: Wed Dec 31, 1969 5:00 pm
Posts: 329
Location: Vancouver, BC
Like this: <br> <br>SELECT DATE_ADD(NOW(), INTERVAL "@VARIABLE" MINUTE) AS NEWDATE FROM [tablename]; <br> <br>The above statement gives the result a column name. When used in a TeleFlow SQL Statement step, TeleFlow will populate the variable @NEWDATE for you automatically.


Back to top
 Profile WWW 
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : TeleFlow Designer & Simulator


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Style by Midnight Phoenix & N.Design Studio
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.