sensalim Posted April 19, 2007 Share Posted April 19, 2007 Product: Frontrange Goldmine Goldmine has a dll for third party products (for GoldMine 6.x, it's gm6s32.dll) and they supply the API documentation but I'm still confused (I'm new to programming). Can autoit uses that dll to communicate with GoldMine to say... do a query (a select statement)? I can do this in ASP with ADO connection, but not in programming (autoit or vb). Can anyone help? Thank you very much! Link to comment Share on other sites More sharing options...
Zedna Posted April 19, 2007 Share Posted April 19, 2007 Post your PHP code, maybe somebody will help you trnslate it to Autoit ... Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
sensalim Posted April 19, 2007 Author Share Posted April 19, 2007 Post your PHP code, maybe somebody will help you trnslate it to Autoit ... Well it's not PHP, I don't know PHP that well. I use ASP because I found a sample in ASP and tweaked it around until it works lol. OK here's the code strconn="Provider=SQLOLEDB.1;Password=(password here);Persist Security Info=True;User ID=sa;Initial Catalog=GoldMine;Data Source=(server name here)" mySQL="SELECT * FROM CONTACT1 WHERE COMPANY LIKE 'Test Company'" ... Call query2table(mySQL, strconn) query2table() uses: sub query2table(inputquery, inputDSN) dim conntemp, rstemp set conntemp=server.createobject("ADODB.Connection") conntemp.open inputDSN set rstemp=conntemp.execute(inputquery) howmanyfields=rstemp.fields.count -1 ... Then for each, it'll just be in a loop to put each value in html table. Of course the code above is just a sample (fixed query/select statement). Thanks. Link to comment Share on other sites More sharing options...
Zedna Posted April 20, 2007 Share Posted April 20, 2007 Try to search this forum.For example search in examples section for ADODB.Connection Resources UDF ResourcesEx UDF AutoIt Forum Search 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