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
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-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
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

    • lattey
      By lattey
      hi,
      i have checkboxes and each checkbox that checked, i put in array. 
      now, im stuck on how to loop the checked array and store in in one variable. what i can do now, is only write the result into a text file. 
      below is the code:
      #include <GUIConstantsEx.au3> ;~ #include <MsgBoxConstants.au3> #include <ButtonConstants.au3> #include <Array.au3> Global $Count = 3 Global $CheckBoxP[$Count] Global $step[$Count] global $array1[1] Global $ExitResult $hGUI = GUICreate("Summary Steps", 500, 400) GUISetFont(12, 400, "Tahoma") GUICtrlCreateLabel( "Please Select the Summary Steps for Script Check", 70, 20) GUISetFont(10, 400, "Tahoma") Global $array_Pstep[3] = ["fix2","fix1","fix3"] global $step[3] = ["2","3","4"] $Spacing = 50 For $i = 0 To UBound($array_Pstep) - 1 $CheckBoxP[$i] = GUICtrlCreateCheckbox($array_Pstep[$i], 80, $Spacing + (20 * $i), 65, 17) Next $submit = GUICtrlCreateButton("Submit",180, 280, 80, 30) $exit = GUICtrlCreateButton("Exit",180, 320, 80, 30) GUISetState() While 1 $Msg = GUIGetMsg() Select case $Msg=$submit For $i = 0 To $Count - 1 If GUICtrlRead($CheckBoxP[$i]) = $GUI_CHECKED Then _ArrayAdd($array1, $step[$i]) EndIf Next Global $logfilerray = @WorkingDir & "\checkedlist.txt" FileDelete ($logfilerray) Global $readlogfile = FileOpen($logfilerray,1) for $a = 1 to UBound($array1) - 1 ;~ $var=$array1[$a] FileWriteLine($readlogfile,$array1[$a]) Next FileClose($readlogfile) Exit case $Msg=$exit $ExitResult = MsgBox(1,"Summary Step", "Continue to Exit ?") if $ExitResult = 1 Then ;ok Exit EndIf Exit EndSelect WEnd  
    • jasty
      By jasty
      In every other language doing   
      dim $a[3] = [1, 2, 3] $b = $a creates a reference to a but in autoit it always makes a copy.  I didn't realize this until I have performance problems and now I'm trying to switch over to the reference behavior.  How can I change the above statement so b is a reference to a and not a full copy? 
    • omicron
      By omicron
      How do you perform a nested loop function with a multidimensional array from 2 lists.
      for i in list1
      (open file) extract variable
          while open for i in list 2
          (open file2) extract variable
       
      var1 + var2 = (search term)

      The list sizes will more than likely consist of different lengths.
       
      What is the best approach to accomplishing this method?
             
    • omicron
      By omicron
      Hello!

      I am working on a function that I am just getting lost on. The goal is a multiple nested loop.

      Here are the steps:
      Contents of file1.txt::
      [topic] var1=Name var2=OtherName var3=SomeotheName Contents of file2.txt::
      [subTopic] top=sub1 top2=sub2 top3=sub3 The Shell I am working from::
      #include <file.au3> $file = "c:\yourfile.txt" FileOpen($file, 0) For $i = 1 to _FileCountLines($file) $line = FileReadLine($file, $i) msgbox(0,'','the line ' & $i & ' is ' & $line) Next FileClose($file) Understanding however that the "msgbox" needs to then become a variable. in example the following::
      $file = "c:\yourfile.txt" FileOpen($file, 0) While true( prog.exe is running && "WinName" is open) do For $i = 1 to _FileCountLines($file) $line = FileReadLine($file, $i) ;Open File to log "current location of file 1" FileWriteLine ("filename", $i & ' is ' & $line) var = $line Next $file2 = "c:\yourfile.txt" FileOpen($file, 0) For $i = 1 to _FileCountLines($file) $line = FileReadLine($file, $i) ; OpenFile to log "Current location of file 2" FileWriteLine ("filename", $i & ' is ' & $line) Next FileClose($file2) FileClose($file) The goal in written form is the following ::

      While in "OpenWindow"
          read from file 1 starting at line 1 until end of file.
         file 1 is a list of names to be searched.
         With $line selected, add this element to the element in file 2.
       
      The search of a variables in list 1 and list 2 differ on the amount of posts that day. (This is not a web based platform, it is a game) I need to search 2 names and take a screenshot of the out put. The sizes of the names list depend on the activity of names at the time of search.
      This loop continues until all the names from both lists have been searched. Mostly in the format of::
      File1= item
      File2= Vendor
       
      Item + Vendor  ( Capture screen, scroll) -- Not sure how to detect if I need to scroll)
       
      Thank you for your help and support!
    • Skeletor
      By Skeletor
      Hi Virtual People,
      My array works perfectly fine. However, what is the best practice if the line in the array doesn't have the correct amount of columns and if I can add a placeholder?

       
      For $count = 1 To _FileCountLines($FileRead1) Step 1 $string = FileReadLine($FileRead1, $count) $input = StringSplit($string, ",", 1) $value1 = $input[1] $value2 = $input[2] $value3 = $input[3] _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $value2, "A1") _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $value1, "B1") _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $value3, "C1") Next  
×