Questions tagged [rowcount]
405 questions
-1
votes
2 answers
It doesn't stop going to else part, issue with if statement
i typed the login and password 100000 times but it dont stop going to ELSE part. where's the error?
if (!empty($user) AND !empty($password)) {
$sql = $this->_db->prepare("SELECT * FROM users WHERE user = :user AND password = :password");
…
kebyzak
- 21
- 1
- 4
-1
votes
1 answer
Count rows in massive .csv file
dumping a Postgres table out by sections is yielding sections that are 30GB+ in size. The files are landing on a windows 2008 server. I'm trying to count the rows in the csv to ensure I have a row count that I expect (22,725,303 to be exact). I…
Matt Coblentz
- 31
- 7
-1
votes
1 answer
Returning a field from mysql using rowCount is not working
I want the following code to return the userID from mysql tblUser of the user if the email and password matched. Currently it is not returning anything
LESETJA
- 15
- 3
-1
votes
1 answer
PHP PDO execute/prepare doesn't seem to work
prepare("SELECT * FROM testdb.users WHERE user = ':login' AND user_pass=PASSWORD(':password')");
$abc->bindParam(':login', $_POST['name']);
$abc->bindParam(':password', $_POST['pw']);
$abc->execute();
…
Dennis
- 19
- 5
-1
votes
2 answers
I have 8 rows but when (i = 7) it says (i + 1) is out of range?
I have a DataGridView with 8 Rows. In the following Sub i have an If statement to only do something when i is less than the RowCount, this is purposely so when i use (i + 1) on the last row it will still be in range, yet it is not? I can't figure…
Pete
- 469
- 7
- 18
-1
votes
2 answers
why rowCount() php function Calculate deleted items?
i use rowCount() php function to get number of my PDO query. but the issue is that this function Calculate deleted items from database.
i want to get number of exist items in DB without deleted items.
tanks
moosavi
- 174
- 1
- 2
- 12
-1
votes
3 answers
Excel VBA selecting data from a sorted Table
I am running into a problem in VBA in excel.
I am trying to create a participant registration program in excel for a sports tournament. One can add data like the weight, age and name of a participant. And then based on that, The participants are…
Denn159
- 1
- 2
-1
votes
1 answer
Total row-count for MySQL multi-queries
I realized today that the row-count returned for data manipulations done via multi-queries is not what I expected it to be: Executing
"INSERT INTO test SET bla=1; INSERT INTO test SET bla=2;"
on an empty table test returns the row-count 1 and not…
dotwin
- 1,302
- 2
- 11
- 31
-1
votes
1 answer
How do I create a macro from a SUMPRODUCT formula for a range whose number of rows changes?
I have a SUMPRODUCT formula which can be written as either:
=SUMPRODUCT(0+(COUNTIF(OFFSET(AL2:AT2,ROW(AL2:AT?)-MIN(ROW(AL2:AT?)),,),"VAC")<5))
OR
=SUMPRODUCT(--(MMULT(--(AL2:AT?="Vac"),{1;1;1;1;1;1;1;1;1})<5))
However, I have to apply this…
anci
- 15
- 1
- 4
-1
votes
1 answer
fetching count and result in PDO
If I have to query db and do something one the basis of number of rows , in mysql I simply query and I can simply query and use simply
if($result->num_rows >= 1){
but in PDO
I have to
make count query , the use fetchCloumn() to get count
query…
user1765876
- 121
- 1
- 8
-1
votes
2 answers
Not able to create two methods for counting and reading a file individually in java
When trying to create two methods for counting the no. of rows and reading the values of a file, only one of these methods got executed and another is not executed showing the following error :Exception in thread "main" java.lang.RuntimeException:…
sandy444
- 11
- 2
- 5
-2
votes
1 answer
Get the row count of a MYSQL table where each row contains same date
I have a MYSQL table called "LCI" in which I have the flowing columns and datatypes respectivelyas shown in the picture.
The java application reads two user inputs User name and a date UI where user have to give User name and a date. and compare…
Jay K
- 37
- 1
- 10
-2
votes
4 answers
Counting the NUM of rows that contains a certain year
I have a data frame that contains a date column of this format (1990-02-28)
i want to count the number of rows that contains the year 1996 (doesnt matter the month/day).
For Example:
DF
1. 1946-01-21 -0.7062
2. 1986-01-22 0.5029
3. 1923-01-23 …
Eliad Harell
- 7
- 2
-3
votes
2 answers
How to show tables names and for each table rows count wpf c#
I am trying to finish my graduation project which is a desktop application for database transfer. The application was made by C# WPF.
I want to introduce a feature in the application which is Quality Assurance, and it should be done as follows:
When…
Khalid
- 3
- 2
-3
votes
1 answer
Select duplicate rows by comapring multiple columns in R
I have an issue in selecting duplicate rows in R. A data fame has 14 columns and 1 million rows. I have to do row comparison i.e finding out identical rows, would be duplicate. I want to get the duplicate row by this method. My data frame is like…
Sharmi
- 51
- 2
- 9