Khab Posted May 20, 2009 Share Posted May 20, 2009 Sorry, this is probably a dumb question, but I couldn't find it in the docs or by searching. I am getting a 2D array generated by an ADODB recordset from a SQL query - how do I find the maximum dimensions of the array? e.g. if it is an $array[5][6] how do I get those values, is there some equivalent to .getLength or .getSize or something? I've played around trying what I think makes sense and cannot work it out Again, sorry for the silly question. $QueryResult = ObjCreate("ADODB.Recordset") $QueryResult.Open($sql_query, $sql_conn) $ResultArray = $QueryResult.GetRows() So it's the dimensions of $ResultArray I'm after.. thanks! Link to comment Share on other sites More sharing options...
CodyBarrett Posted May 20, 2009 Share Posted May 20, 2009 yes... UBound ($ARRAY, $DIMENSION)..... not those exact variables but you get my point [size="1"][font="Tahoma"][COMPLETED]-----[FAILED]-----[ONGOING]VolumeControl|Binary Converter|CPU Usage| Mouse Wrap |WinHide|Word Scrammbler|LOCKER|SCREEN FREEZE|Decisions Decisions|Version UDF|Recast Desktop Mask|TCP Multiclient EXAMPLE|BTCP|LANCR|UDP serverless|AIOCR|OECR|Recast Messenger|AU3C|Tik-Tak-Toe|Snakes & Ladders|BattleShips|TRON|SNAKE_____________________[u]I love the Helpfile it is my best friend.[/u][/font][/size] Link to comment Share on other sites More sharing options...
Khab Posted May 20, 2009 Author Share Posted May 20, 2009 Awesome, thanks! Link to comment Share on other sites More sharing options...
CodyBarrett Posted May 20, 2009 Share Posted May 20, 2009 Thanubis beat me to it... but no problemo...i didn't know about Ubound until about 3 months into my scripting experience... its usefull try using the helpfile Index section... it searches the helpfile by what you type... might be of someuse later on [size="1"][font="Tahoma"][COMPLETED]-----[FAILED]-----[ONGOING]VolumeControl|Binary Converter|CPU Usage| Mouse Wrap |WinHide|Word Scrammbler|LOCKER|SCREEN FREEZE|Decisions Decisions|Version UDF|Recast Desktop Mask|TCP Multiclient EXAMPLE|BTCP|LANCR|UDP serverless|AIOCR|OECR|Recast Messenger|AU3C|Tik-Tak-Toe|Snakes & Ladders|BattleShips|TRON|SNAKE_____________________[u]I love the Helpfile it is my best friend.[/u][/font][/size] 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