emanemos Posted August 26, 2014 Share Posted August 26, 2014 (edited) Hi from France, I've an Array > 65525 lines. Do U know a method to workaround this problem? I want to write this array in a file ... Thanks $mysqlrequest = "SELECT * from toto" $aArray = _EzMySql_GetTable2d($mysqlrequest) ;~ _ArrayDisplay ($aArray) _filewritefromarray( $path & $Dir & "state.csv",$aArray,0,UBound($aArray),";") Edited August 26, 2014 by emanemos Link to comment Share on other sites More sharing options...
jguinch Posted August 26, 2014 Share Posted August 26, 2014 Hi "voisin". One way could be to get the number of rows (select count(*)) and make several requests (in a loop), using LIMIT : $mysqlrequest = "SELECT * from toto LIMIT 0, 10000", where 0 is variant (0, 10000, 2000 ...). Spoiler Network configuration UDF, _DirGetSizeByExtension, _UninstallList Firefox ConfigurationArray multi-dimensions, Printer Management UDF Link to comment Share on other sites More sharing options...
kylomas Posted August 26, 2014 Share Posted August 26, 2014 emanemous, Arrays are not limited to 65525 lines. _Array display has a limitation of what it can display due to the max number of controls allowed. The following demonstrates an array of 100,000... local $a[100000] for $1 = 0 to ubound($a) - 1 $a[$1] = $1 Next ; send last ten elements to the console for $1 = ubound($a) - 1 to ubound($a) - 11 step -1 ConsoleWrite($a[$1] & @CRLF) next Have you tried writing the file and looking at it? 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 Link to comment Share on other sites More sharing options...
mikell Posted August 26, 2014 Share Posted August 26, 2014 Confirmed by the helpfile VAR_SUBSCRIPT_ELEMENTS 16,777,216 Maximum number of elements for an array. 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