Hey guys,

Not sure where this post is suppose to go but have a query on the
Display Select From List Dialogue Box

e.g.

Question : "Which Internet Browser Do You Prefer?"
List Options 

: Safari
: FireFox
: Internet Explorer

[If] %????% = ???? Then

[GoTo](Label) [Safari]

Which would then run each different application...

Can anyone elaborate on the ????'s please?

Any advice or assistance would be greatly appreciated!
Thanks a bunch,

- aj

P.S.

Here's an example zip of what Im trying to do.
Pretty simple, but the "IF" commands screw me over :(

Yo! Can you please check the revised version of your job that I attached? I skipped the use of "Go To" and "Label" actions since they are not used. If you want an example with labels let me know and I'll try to create one for you.

Notice that I've used the %SelectedItem% variable to determine which browser was selected. Let me know if anything in the job troubles you.

 Ahhhh.... Codex, you're a legend!

I understand "IF" statements now... Thank you so much!

Just wondering if you also have sample code for :

1) chmod'ing a file on a server to 777?
2) connecting via ftp & creating a MySQL Database?

I understand how to connect to the webserver using the FTP connection
as well as changing directories, then invoking the FTP commands,

But the chmod'ing ftp commands have me stumped.

Any advice or assistance would be so greatly appreciated!
Thank you again Codex,

So glad to have you guys here!

- aj

p.s.

I really enjoy trying to create apps using WA and it's easier
for me to learn viewing sample code from experts such as yourself, so i can do it myself.

That way I learn once, not have to bother you guys much, then help others
here in the forum, like you've helped me.

Really appreciate your help 

AJ, I've also replied you with the attachment on the Warrior Forum.

Glad to see that you are making it work for your tasks!

Keep at it!

Jag

Attached you can find a sample file that changes the permissions of a file to 777. If the permissions are not changed successfully, the "Invoke FTP Command" action will return an error.

However, I'm not exactly sure what do you mean by: "creating a MySQL" database. You can't actually create a mysql database through FTP. In order to do that you will either have to connect through a command line tool to the server (e.g. putty) or use web interface (e.g. phpmyadmin).

 Opps, sorry codex, i thought creating a mySql database
was possible through WA... maybe a possible future add on feature? :)

Thank you so much for the example Change FTP Permissions job...
I've nearly completed my first WinAuto APP!

So kool...

Thanks again for your awesome support guys,..
You rock!

- aj

No problem m8! :)

I remember that feeling! Doesn't it feel really good when you know that a task that required 2 hours of your time per week will be done automatically from now on? :p I still get it when I find a new task that can be automated...

I know that it is possible to Execute a SQL query with WinAutomation in a local database (there is a dedicated action for it I think). But when it comes to creating a MySQL database in a remote server there are a lot of problems that need to be issued in order for the WinAutomation guyz to create such an action. Let me explain:

1) First of all, I'm gonna assume that we are talking about a Linux server that is hosting our website. The reason for that is that I have only worked with Linux servers and I don't really know what command line tools do Windows servers provide. Also, MySQL usually goes with the LAMP package (Linux, Apache, MySQL, PHP) so let's stick to this assumption for now.

2) There are 2 different cases that we need to examine:
a) Your website is built on a limited hosting plan from a company (e.g. GoDaddy)
b) Your website is built on a dedicated server that you have unlimited access to (e.g. on an Amazon AMI)

In order to create a MySQL database you need connect to your server through SSH (usually), enter MySQL's command line interface and send a CREATE DATABASE command.

In the (a) case, a "Create MySQL Database" action will not work most of the times. The majority of the hosting companies will only allow you to create your databases through their web interface and they usually don't give an API for that.

In the (b) case, an action could probably be made, but it can also be automated by running a specific set of commands through a predefined putty session.

Notice, that in every case, your task can be automated visually, either through the Web Interface or through the command line interface by sending the appropriate keystrokes and waiting for the corresponding repllies to appear.