Khab Posted May 20, 2009 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!
CodyBarrett Posted May 20, 2009 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]
CodyBarrett Posted May 20, 2009 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]
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