Jump to content
cdjphoenix

Combining Arrays

Recommended Posts

cdjphoenix

I'm hoping someone here can shed some light on a problem I've been having combining some arrays. I've searched the forum and found some posts but I'm still having troubles

My goal is to have an array that I can display with 3 seperate columns, I'd actually be happy with anyway to get 3 arrays on a table. I have a MySQL server that I am pulling 3 different fields from "firstname", "lastname" and "phone" and I can pull the data without any problems, it's just combining them.

Here is what I have currently code wise. It's not very pretty but it works...

#include "mysql.au3"
#include "array.au3"

$sql = _MySQLConnect('username','password','table','TestSystem')
$row = _Query($sql, "SELECT * FROM fax")
Global $aArray
Global $sFill
Global $aArray_Base [1] [3]
$aArray = $aArray_Base

Global $aArray2
Global $sFill2
Global $aArray_Base2 [1] [3]
$aArray2 = $aArray_Base2

Global $aArray3
Global $sFill3
Global $aArray_Base3 [1] [3]
$aArray3 = $aArray_Base3

with $row
While NOT .EOF

   Global $FirstName = .Fields("firstname").value
   Global $LastName = .Fields("lastname").value
   Global $FaxNumber = .Fields("faxnumber").value
   $sFill = $FirstName
   $sFill2 = $LastName
   $sFill3 = $FaxNumber
   _ArrayAdd($aArray, $sFill)
   _ArrayAdd($aArray2, $sFill2)
   _ArrayAdd($aArray3, $sFill3)
   .MoveNext


   ;MsgBox(0,"TEST",$FirstName &" " & $LastName & " " & $FaxNumber)
WEnd

EndWith

_ArrayDisplay($aArray, "Test Array")
_ArrayDisplay($aArray2, "Test Array")
_MySQLEnd($sql)

Thank you for taking the time to look at my code/problem.

Share this post


Link to post
Share on other sites
iamtheky

why not just add them to the same array?  the third parameter of arrayadd is column so something like:

_ArrayAdd($aArray, $sFill)
   _ArrayAdd($aArray, $sFill2, 1)
   _ArrayAdd($aArray, $sFill3 , 2)

,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Share this post


Link to post
Share on other sites
cdjphoenix

There were all in the same array at one point but I've been trying everything I can think of in order to get this to show the way i want.

Share this post


Link to post
Share on other sites
iamtheky
My goal is to have an array that I can display with 3 seperate columns

 

 

i dont understand how placing this data into a single array with three columns, via arrayadd, does not meet the above requirement.  Is there something else you want of this 3 columned array?

Edited by boththose

,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Share this post


Link to post
Share on other sites
JohnOne

Here is what I have currently code wise. It's not very pretty but it works...

Really?

Is your version of AutoIt from the future?

I get all kinds of errors, not least from this...

While NOT .EOF

AutoIt Absolute Beginners    Require a serial    Pause Script    Video Tutorials by Morthawt   ipify 

Monkey's are, like, natures humans.

Share this post


Link to post
Share on other sites
water

You need to add some kind of error checking to your script. Every function sets the return value or macro @error when something went wrong. Check for errors before proceeding to the next statement.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
kylomas

Can you not use your "Select" statement to get whatever you want, in whatever order you want?

Select firstname, lastname, faxnumber from fax









edit: spelling / comment deleted

Edited by kylomas

Forum Rules         Procedure for posting code

"I like pigs.  Dogs look up to us.  Cats look down on us.  Pigs treat us as equals."

- Sir Winston Churchill

Share this post


Link to post
Share on other sites
cdjphoenix

 

Really?

Is your version of AutoIt from the future?

I get all kinds of errors, not least from this...

While NOT .EOF

It must be, I have no doubt there are errors but the reason i say it works is that when i run it I see my data in a table...all in one column, but it's still a table.

Right now in order to update certain user info I have to go to two serperate spots to update it and I find this annoying. What I'm trying to do is get this data into a MySQL database and use autoit to update this database along with Active Directory. Thanks for the input though, I see if i can add in some error checking.

*Edit here is my original code before i went crazy and started trying wierd things to get those coulmns.

#include "mysql.au3"
#include "array.au3"

$sql = _MySQLConnect('user','password','test','TestSystem')
$row = _Query($sql, "SELECT * FROM fax")
Global $aArray,$aArray2
Global $sFill, $sFill2
Global $aArray_Base [1] [3]
$aArray = $aArray_Base
with $row
While NOT .EOF

   Global $FirstName = .Fields("firstname").value
   Global $LastName = .Fields("lastname").value
   Global $FaxNumber = .Fields("faxnumber").value
   $sFill =$FirstName
   $sFill2 =$LastName
   $sFill3 =$FaxNumber
   _ArrayAdd($aArray, $sFill)
   _ArrayAdd($aArray, $sFill2, 1)
   _ArrayAdd($aArray, $sFill3, 2)
   .MoveNext
   ;MsgBox(0,"TEST",$FirstName)
WEnd
EndWith

_ArrayDisplay($aArray, "Test Array")

_MySQLEnd($sql)
Edited by cdjphoenix

Share this post


Link to post
Share on other sites
cdjphoenix

 

why not just add them to the same array?  the third parameter of arrayadd is column so something like:

_ArrayAdd($aArray, $sFill)
   _ArrayAdd($aArray, $sFill2, 1)
   _ArrayAdd($aArray, $sFill3 , 2)

I knew it would be something simple, this gets the correct data into the correct spots....for the most part. whatever reason each piece of data is in the correct column but it's one piece per row.

Share this post


Link to post
Share on other sites
cdjphoenix

I Figured out how to do what I was looking to do. Here is the code just in case someone else comes searching for something similar:

#include "mysql.au3"
#include "array.au3"

$sql = _MySQLConnect('user','password','table','SQLSystem')
$row = _Query($sql, "SELECT * FROM fax")
Global $aArray,$aArray2
Global $sFill, $sFill2
Global $aArray_Base [1] [3]
$aArray = $aArray_Base
with $row
While NOT .EOF


   Global $FirstName = .Fields("firstname").value
   Global $LastName = .Fields("lastname").value
   Global $FaxNumber = .Fields("faxnumber").value

   Local $sFill[2] [3] = [[$FirstName, $LastName,$FaxNumber]]
   _ArrayAdd($aArray, $sFill)
   .MoveNext

WEnd
EndWith


_ArrayDisplay($aArray, "Test Array")


_MySQLEnd($sql)

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • VollachR
      By VollachR
      Hi,
      I'm looking for a way to take a number value from a Row2 of a 2D array and according to this check if files that appear in rows 3-11 in the array exists.
      For example, if the number in Row2 is 5 I need to check for the files in Row 3-6 only, if it is 6 than rows 3-7 and so on.
      I thought on using a FOR loop but I have very little experience with those.
      Can you suggest the best way to do what I need?
      BTW, the files in Rows 3-11 will usually have blank value for any row above the number in Row2 (e.g. Row2 = 5 so Rows3-6 will have values but 8-11 be empty), The values I need are in Column 1 of the array, the name of the key from the INI file that the array was created from is in Column 0.
      Full Example:
      Row2 of Array:
      Col0 = Games# - Col1 = 5
      Rows3-6
      Col0 = Exe2 - Col1 = Path To File
      Col0 = Exe3 - Col1 = Path To File
      Col0 = Exe4 - Col1 = Path To File
      Col0 = Exe5 - Col1 = Path To File
      I need that if Row2 is 5 to check these above for rows if the file exists, if it was 6 then the next row as well and so on up until number 10 in Row2 as it can't go above 10.
      So basically for whatever number in Row2 from 2-10 need to check 1-9 rows from 3-11 to see if the files in Col1 exists and if any of them don't exist it should call a function that shows an error message.
      I'm pretty sure I have the first line of the for look correct:
      For $i = 1 To $aAIO[2][1] Just not sure how to continue from there, also not sure if $i should be equal 1 or 2.
      Help will be appreciated.
    • FMS
      By FMS
      Hello,
      I'm trying to get data from twitter to an array and so far I found an Twitter UDF whish lookes very intresting but couldn't get it to work.
      It lookes not supported any more(2010) and buggy when i read all te replies.
      More around this subject (autoit and twitter) i couldn't find on this forum.
      Is there sombody who know's a good way to get live data from twitter to an array inside autoit?
      (I kinda doubt that this isn't tackled before)
      In the end I was hoping to get all tweets from date to date from an specific subject inside a 2D array to work whit.
    • AndreasNWWWWW
      By AndreasNWWWWW
      I got a question:  i am trying to run different functions based upon what i select in these radio buttons.(code below)
      it needs to check server 1. then run function 1 or function 2 after what i selected in the checkbox.
      once that function is done it moves to the next one, until it has been trough all 5 
       
      iv'e tried using while loops with different while $i equals to something but then i manualy need to go in and edit the script every time.
      #include <ButtonConstants.au3> #include <GUIConstantsEx.au3> #include <StaticConstants.au3> #include <WindowsConstants.au3> #Region ### START Koda GUI section ### Form= $Form1 = GUICreate("Form1", 615, 437, 192, 124) $Server2 = GUICtrlCreateLabel("Server2", 216, 95, 41, 17) $server1 = GUICtrlCreateLabel("Server1", 216, 72, 41, 17) $server4 = GUICtrlCreateLabel("Server4", 216, 144, 41, 17) $server3 = GUICtrlCreateLabel("Server3", 216, 119, 41, 17) $server5 = GUICtrlCreateLabel("Server5", 216, 170, 41, 17) $Start = GUICtrlCreateButton("Start", 240, 248, 147, 25) $Checkbox1 = GUICtrlCreateCheckbox("function1", 288, 72, 97, 17) $Checkbox2 = GUICtrlCreateCheckbox("function2", 392, 72, 97, 17) $Checkbox3 = GUICtrlCreateCheckbox("function1", 288, 96, 97, 17) $Checkbox4 = GUICtrlCreateCheckbox("function2", 392, 96, 97, 17) $Checkbox5 = GUICtrlCreateCheckbox("function1", 288, 120, 97, 17) $Checkbox6 = GUICtrlCreateCheckbox("function2", 392, 120, 97, 17) $Checkbox7 = GUICtrlCreateCheckbox("function1", 288, 144, 97, 17) $Checkbox8 = GUICtrlCreateCheckbox("function2", 392, 144, 97, 17) $Checkbox9 = GUICtrlCreateCheckbox("function1", 288, 170, 97, 17) $Checkbox10 = GUICtrlCreateCheckbox("function2", 392, 170, 97, 17) GUISetState(@SW_SHOW) #EndRegion ### END Koda GUI section ### While 1 $nMsg = GUIGetMsg() Switch $nMsg Case $GUI_EVENT_CLOSE Exit EndSwitch WEnd  
    • 31290
      By 31290
      Hi everyone, 
      I'm currently writing a script that allow me to list all currently installed software on a computer but some of the are listed in the HKLM64 hive of the registry whereas 95% of all others are in the HKLM "normal" one.
      Thing is, I'd like to combine these two reg key into one single ListView item.
      Here's my code so far, knowing that it's working on both cases (changing to HKLM64 or HKLM short)
      Thanks in advance for the help
      -31290-
    • dangr82
      By dangr82
       
      I have created this function for a database, but I can not make it work. I always have two error messages: "not an error" ... and the file created, in the script directory, does not contain anything.
      Global $sDBName = "Hen.db" Func DatabaseTable() Local $sConnDB _SQLite_Startup() If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite.dll Can't be Loaded!") Exit -1 EndIf $sConnDB = _SQLite_Open($sDBName) If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't Load Database!") Exit -1 EndIf If Not _SQLite_Exec($sDBName, 'CREATE TABLE Animal ("Name", "Age");') = $SQLITE_OK Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", _SQLite_ErrMsg()) If Not _SQLite_Exec($sDBName, 'INSERT INTO Animale VALUES ("Charlie","5");') = $SQLITE_OK Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", _SQLite_ErrMsg()) _SQLite_Close($sConnDB) _SQLite_Shutdown() EndFunc  
×