Guillermo Posted March 6, 2006 Share Posted March 6, 2006 My script needs to retrieve data (strings) from a database. My company's technician says that AutoIT can't do that, but I have the impression that AutoITX would be able to interact with the DB's language. Unfortunately I can't provide you with more information because the project is in the planning stage, but I've developed a concept in AutoIT that I'd like to build up from, thought it'll be dropped if I can't prove that AutoIT is able to send queries to this DB and retrieve data from it. Can anybody help? Guillermo Link to comment Share on other sites More sharing options...
cdkid Posted March 6, 2006 Share Posted March 6, 2006 (edited) ok, what DB do u use (MySQL? MSSQL?SQLITE?) there are UDFs for all of em, look in my siggy for MySQL, and in Scripts & Scraps for the other two ~cdkid Edited March 6, 2006 by cdkid AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide! Link to comment Share on other sites More sharing options...
Moderators big_daddy Posted March 6, 2006 Moderators Share Posted March 6, 2006 If it is using a MySQL Database you can use the MySQL UDF. I'm not sure about others. Link to comment Share on other sites More sharing options...
Guillermo Posted March 6, 2006 Author Share Posted March 6, 2006 That's a good starting point, guys. I'll try to find out what type of DB this is all about... Link to comment Share on other sites More sharing options...
Guillermo Posted March 7, 2006 Author Share Posted March 7, 2006 Ok. It seems that they'll be using PostgreSQL... Link to comment Share on other sites More sharing options...
flyingboz Posted March 7, 2006 Share Posted March 7, 2006 Ok.It seems that they'll be using PostgreSQL...Well. You are the proud owner of a need to adapt one of the existing UDFs for Postgres. My suggestion, Start w/ the basic ability to login to a database, (ensure that you have OBDC installed) , add the ability to pass a raw sql command, then expand as necessary. ... I look forward to seeing your results. Reading the help file before you post... Not only will it make you look smarter, it will make you smarter. Link to comment Share on other sites More sharing options...
Guillermo Posted March 8, 2006 Author Share Posted March 8, 2006 ... I look forward to seeing your results.Oh my, I wish I had the time and knowledge required to investigate any further...My interest in programming started when I saw first-hand how primitive are the methods used in my company. Now I'm addicted to AutoIT, VBA and Python, but time's scarce to toy too much with them and I only make progress slowly...Thanks anyway! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now