Intelligent Automation & Macro Software  

Go Back   Automation Anywhere, Inc. Forums > Products Zone > Automation Anywhere
Register FAQ Search Today's Posts Mark Forums Read

Automation Anywhere Post messages and questions related to Automation Software here.


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-24-2010, 01:08 PM
cufis cufis is offline
Junior Member
 
Join Date: Jan 2010
Posts: 8
Default Get return value from VBScript

Running Version 5.5.2 Premiere

I have a task that is grabbing data from a website, then inserting it into my SQL Database, but I want to cleanse the data from two different variable first through VBScript.

Here is one of my Scripts:

DIM strDesc

strDesc = Wscript.Arguments.Item(0)
strDesc = TRIM(strDesc)
strDesc = REPLACE(strDesc,"'","")
strDesc = REPLACE(strDesc,",","")

I select the "Run Script" task, select the correct location for the script. In the second option I pass the current Variable $ItemName$ and the second option is the set the new variable $ItenNameVal$ with the return value. I run the script, it executes with no errors, but the portion of my SQL DB the writes the return values are blank. (the Variables value are null by default).

Is there something wrong with my script that is not returning the value?
Reply With Quote
  #2 (permalink)  
Old 02-24-2010, 01:13 PM
cufis cufis is offline
Junior Member
 
Join Date: Jan 2010
Posts: 8
Default

NM, realized what I was missing

fyi needed to add line

WScript.StdOut.WriteLine strDesc
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -7. The time now is 06:16 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.0 ©2007, Crawlability, Inc.
Copyright © 2003-2011 Automation Anywhere, Inc. All rights reserved