How do I get the column names as a list to match the order of the
rows returned when using select/fetchall_arrayref and using an ARRAY
slice? I'm not having luck finding it in the docs.
I don't know the column names ahead of time -- I'm passed a query and
want to return the data in the column order specified in the query.
And also return the list of column names.
Re: Column names when using selectall_arrayref ... rows returned when using select/fetchall_arrayref and using an ARRAY ... I'm not having luck finding it in the docs. ... want to return the data in the column order specified in the query.... (perl.dbi.users)
Re: Mix/Max/Avg Help based on dynamic ranges ... Did you enter Biff's formula as an array? ... The query I gave you is dependent on your breaking out the ranges as Biff ... Where Nums are the values to avg based on the head count range. ... deemed optimal for building device profiles based on locn size and device ... (microsoft.public.excel.worksheet.functions)
Re: Imitating Mail Merge on server ... given moment we know which data (in this case, customers) is being worked ... and concantenate each query together. ... loop the array, plug in the current recordset value. ... We have close to fifty tokens that we use in the application correspondence, ... (microsoft.public.inetserver.asp.general)
Re: Subquery Confusion ... Then I got this crazy idea that an Array can only contain a maximum ... number of characters, ... Then I decide that maybe I'm completely wrong with my query,... it out of Excel VBA and spit it into Microsoft SQL Server Management ... (microsoft.public.excel.programming)
Re: Form fields array ... I see your point about the array being empty.. ...Dim incDays... for counter=0 to iDays 'iDays are the count of how many days between ... >> not know how many records the query will pull up. ... (microsoft.public.inetserver.asp.db)