Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the column count and column name from the
resultset in the database connection program?
- 6 Answers
- 12431 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / punit
in ur mysql database there is 1 database with name
information_schema,
so 1st type,
use information_schema;
inthis data base there is 1 table COLUMNS which contain all
the info related to allthe tables in ur mysql,
so hit the following queri for youe column count:-
select count(*) from COLUMNS where TABLE_NAME='Table name';
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sreeprasad
you use following sql query
select column name, count(column name)from table name.
| Is This Answer Correct ? | 4 Yes | 6 No |
Answer / uday kumar_anem
Hello friends, just observe the question.
It is not Datatable, it is database connection program.
Say i user "select * from table"
Here i dont know how many col r there in my table.
So give the answer to find the number of columns in that
table.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / akshara
in the vb script we use genralluy to count the rows as
rowcount=datatabble.GetSheet("Sheet name").GetRowCount
MsgBox(rowcount)
i fyou need sheet count
datatable.getcheetcount
Thank you
| Is This Answer Correct ? | 0 Yes | 5 No |
Answer / prasad
Select column_name, count(column_name) from user_tab_columns
where table_name='EMP' group by rollup(column_name);
| Is This Answer Correct ? | 0 Yes | 5 No |
what is descriptive programming in QTP? How can be done?
what is functions in qtp?i know the userdefind &bulit funation or i know that Private public function ?plz tell me what is funations in qtp?how to create a funation in qtp
How many scripts do you write per day. What is the average number of scripts you have written in your recent project
1 Answers CenturyLink, Optum, Value Labs,
How to send the qtp results file by email (Lotus notes).
Hello, Can we capture only the labels of the web page in the object repository. If yes, then how. Actually my scenario is: I have to capture all the label of mercury site http://newtours.mercuryinteractive.com/tour/mercurypurchase. php. and want to copy all these labels in the notepad. So,please help me how to do this all. Thanks in advance, Gaytri
I have a drop down box to show selected number of records in result page.It contains 4 items like 10, 25,50 and 100. when i was recordes script for seelcting each item and checking selecting number of records in the result page( it is in the same page in the table format)it is generating a new page with same controls( objects) in the OR. how to avaid these in OR? is it possible to write DP for only these lines?, remaining(remaingin lines of code) objects i want use from OR only. One more problemis if change ( add /remove properties of an OBJECT in OR , my ( recorded )application is not running.
Hi, actually I completed Btech(CS). But i Will go to admin (Facility) interview. So, If Interviewer asking like " Why You choose this field". What we say? pLZ PLZ PLZ PLZ >............................................Send me.....
what is the difference between the modular framework and datadriven frame work
How does qtp recognize objects in aut?
why we use check points , In qtp we use the any check points , what r they , when and why
How should I check my code( Before going to execute) without executing the script in QTP
what testplan contents and what test strategy contents,what is the diff b/w them
WinRunner 
