76 Topics
|
|
Hi All, I have a sql query i am trying to get the count of how rows it returned. select a.field1, b.field2, c.field2 from table1 as a, table2 as b, table2 as c where a.field1=b.field1 Considered the above query return 9 rows. I want to get count of '9' in … |
|
This is the report.php view [CODE] if(isset($_POST["addReport"])) { $report = new Report(); $report->employee_id = $_POST["employee_id"]; $report->date = $_POST["date"]; $report->job_id = $_POST["job_id"]; $report->description = $_POST["description"]; $report->attachment = file_get_contents($_FILES['attachment']['tmp_name']); for($i = 0; $i < count($_POST['date_range']); $i++) { $report->request_date[$i] = $_POST["request_date"]; } for($i = 0; $i < count($_POST['date_range']); $i++) { $report->quantity[$i] = $_POST["quantity"]; … |
|
Hello, I'm having a problem with my MySQL InnoDB table, only one of five. Every now and then a row or two will go missing completely with no trace of it being there in the first place. I have a website which takes HTTP requests from my desktop side client … |
|
I have a python script that reads a csv file and converts it to two new files so that my database can add new emails or update existing ones. What im trying to do now is after it has converted them for it to send me a email with how … |
|
Hi, Hi I only want to select 5 rows. Can you please tell me how to do it in sql? Thank you. example: ratee rater apple banana apple orange apple peach apple sunkist apple mango apple grapes grapes orange I want to see random selected of 5 ratee orange with … |
|
I have this code which finds the duplicate rows .I want to check if the top row has weight greater than given minimum support..If true then generate its subsets. If row 1 i.e 11110011 wight>min_sup then generate subsets....if not then jump to next row here 1 represents presence of items … |
|
I need to add Column1 + Column2 And Display Result In Column3 But I need to do it for all rows in column3 automatically. I need a very short code. Thankyou. |
|
Ok, so I'm working on a web-project, I connected a custom hanlder to the root Logger in `contextInitialized()` of a ServletContextListener: @Override public void contextInitialized(ServletContextEvent sce) { Logger def = Logger.getLogger(""); Handler hand = new DatabaseLoggingHandler(); hand.setLevel(Level.WARNING); def.addHandler(hand); } which looks like: import java.io.PrintWriter; import java.io.StringWriter; import java.util.logging.LogRecord; import java.util.logging.Logger; … |
|
I need to get the name of the table with the biggest number of rows, I can find the biggest number of rows with function count and than function max, but i don't know how to see from which table is that maximum, can anyone help? tnx |
|
I'm creating a table with PHP/MySql to enter local election results from my newspaper, I'm not a professional developer, more of just a hobbiest hack (who hasn't worked with PHP for a few years either), so feel free to correct existing code if you so please. What I want to … |
|
Hello Community, I was wondering if there is a way to limit users on how many database entries they can insert then once they have reached 100 (Max entried) entries it will delete old entries. So if the user has reached 100 entried and they try to insert another entry … |
|
Hello everyone :) I have this lines of codes and i get : > Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp22\htdocs\folder\index.php on line 52 ( 19 in the code below ) <form method="POST" action="index.php"> CODE : <input type="text" placeholder="Type the code" name="searchfor" /> <input type="submit" … |
|
Hi All, i have requirement like to Convert rows to columns in SQL server. i have retrieved data like below: MatchId SelectionName Odds 322 Home Win 1.33 322 Draw 5.00 322 Away Win 9.00 322 Under 2.5 2.40 322 Over 2.5 1.53 and want to convert like below: MatchId Home … |
|
I know there are other post conserning this but they dont seem to help me. When I run the varaible `$results` through the function `Mysql_num_rows()` it returns as an error saying its not a valid result. Also same for the `mysql_fetch_array()`. function results(){ if ($_POST['search'] != "") { $search = … |
|
im trying to get the user to enter information into a textbox and then after clicking submit button the page has a table containing with that information in the rows. so for example the table has the heading Artist, Songs, Year made, Gene and the user has to enter data … |
|
hi :) is there a possible way where in we can combine two rows for an example i have this code: #include <iostream> #include <fstream> #include <string> using namespace std; int main() { ofstream outfile; outfile.open("1stRow.txt"); for(int i=1;i<10;i++) outfile<<i<<endl; outfile.close(); ofstream outfile2; outfile2.open("2ndRow.txt"); for(int j=2;j<11;j++) outfile2<<j<<endl; outfile2.close(); //return 0; } … |
|
Is there any way to get this to work in Internet Explorer? It shows/hides multiple rows in every other browser, but will only show one class's row in IE. Any help would be great. Here's the code. Thanks! <style type="text/css"> li.merk { list-style:none; display: block; width: 925px; padding:8px; margin-top:-20px; } … |
|
Trying to display events on my website based on what my clients want to view. I have 3 checkboxes setup to toggle the connected events, but I can't seem to make the onclick handle more than 1 event at a time. Basically, I want to know 1) how to display … |
|
I had a jquery-based code that messed up the slider on my page @ http://formidablehoops.blogspot.com Is there a way to have those two co-exist, or is there a way to toggle my calendar at the bottom with javascript instead? I've removed the code for now, but I think it's a … |
|
i have a view named vw_admissionform with columns familycode,Regno,studentname,class for admission form . now if i want to print a student admission form by enetring registration no "regno" in txt1.text then his siblings should also be mentioned on the admission form as requirment by client. for this am using familycode … |
|
Hi, i have been trying to combine data from 2 different sources, to make unique rows: here it is my situation Data in DGV already in dgv, Unbound: column1 | Qty "Sugar", 100 "Salt", 100 "Color", 200 "Malto", 150 Data in datatable: column1 | Qty "Sugar", 80 "Salt", 60 "Apio", … |
|
Hello there, I really need help ASAP. A user has two students(maybe more) where he need to complete marking the score sheet for the students. So, I have a score sheet where the user will insert their id in the textbox and then it will display the first studentName, studentID, … |
|
I have the show/hide table rows function working great now (thank you), but I am having a problem with using the back button. If someone has yes to one of the items (yes/no radio buttons) the onClick event in the input tag causes the appropriate info to display. BUT when … |
|
Hi Guys, I have a form with a DGV and some text boxes.. I am trying to get the program to update the rows shown on the DGV by using the values in the text boxes. Below is my code so far: private void btnOrderEdit_Click(object sender, EventArgs e) { System.Data.OleDb.OleDbCommandBuilder … |
|
Hello everyone. I need some help with a SELECT FROM WHERE query. Let's say I have a row named A and another row named B, and I want to select the eventual cases where values from these two rows, somewhere, match eachother. In this case, you can see, that the … |
|
Hello! This is my first post here, hehe. Seems to be a great site. Anyways, I'm quite new in PHP, but it's fun and I think I'm learning quite fast :) There's appeared a problem for me now though, and I can't see what the problem is...? I have made … |
|
I have been googling this and have read close variations of the following issue from others. It seems that if you are running MS office 2010 Excel and go to delete a group of rows, sometimes below where you are working a blank row will appear at maxamim height size … |
|
Is it possible to reuse an identity field value after deleting rows in SQL Server 2005? Here is an example. Suppose I have a table with an Id field as a primary key (identity). If I add five rows, I will have these 5 Ids: 1, 2, 3, 4, 5. … |
|
Question: Does anyone have any recommendations that are likely to keep a large database healthy/speedy? I'm designing a database that is going to retrieve around thirty million data points a year, up to around three hundred million to a billion in a few years time when all of the sensors … |
The End.