2,570 Topics
 | |
| | Hi I have data to upload to a Mysql database and I need to get the time taken for each row to be inserted so that I can pass that number through to a progress bar. I have alreay tried accomplishing this by determining the number of rows affetced by … |
 | I have data already populated in a datagrid I have three textbox txtCustomername, txtPartcode, txtinvo I want the user to be able to input text into the txtcustomername text box which will result in the datagrid only showing the rows that relate to that customer. Then I want the user …  |
 | Hi All Daniweb PHP Group, I have a big favor to ask (well for me this is big lol). I have 3 databases first (LOCAL),(AIMIS),(ERM). Here's the table (namely account_manager) of LOCAL.  and Here's the table (namely customer_call) of AIMIS.  and Here's the table (namely quotations_header) … |
 | Hello I have two tables: Students and Professors (both with usual info like name, last name, email... etc) I also need to have info about their knowledge of foreign languages, and I guess that should be a third table (languages for example) it should look like: Language_id, Language, Speaking, Writing, … |
 | Hi Anyone can explain whats means with this vulnerability(Blind SQL Injection) and explain Attack details 1 and 2? 1. This vulnerability affects /xxxx/. Discovered by: Scripting (Blind_Sql_Injection.script). Attack details Path Fragment (suffix .html) input - was set to -1' or 61 = '59 2. This vulnerability affects /xxxx/. Discovered by: … |
 | i am trying to get all the result from my databse table but this query is not working. <?php try { $pdo = new PDO('mysql:host=localhost;dbname=articles', 'Avik', ''); } catch (PDOException $e) { $output = 'Unable to connect to the database server.'; echo $output; exit(); } try { $sql = 'SELECT …  |
| | Hello Friends, I have a table which says stores 4 values id,publisher name,bookname,time I am firing query like SELECT * from table where time>='sometime' group by `publisher name` order by time DESC What I want is to select results in DESC order of time with unique publisher name. When I …  |
| | hello every one,,,ihave no experience in c# and iam designing a c# app that insert,update,delete and select data from and into remote database using sql server 2008,so i want some tutorials about c# connection with sql server please help me and thank you.....  |
| | OK so I have already created many pages with my paging all working correctly however I have just created a new paging page that allows the user to use a search criteria. With the paging and search when you click on page 2 it dosen't load and dosen't display any … |
| | Hi, . Could you please provide me a code sample showing how to load a treelistview from database​ with hardcoded root nodes on treelistview. I have shared the link below of a sample preview of the tree I am in need of. Rootnodes are hardcoded and I want the child …  |
 | Having problem with looging in my server. Before it runs smoothly. While learning this system, I came accross the idea of exploring the contents of Microsoft SQL Server in Program Files. I found some exe files inside and tried to run them with the curiosity of what are those for, … |
 | Hi , I am working on a list : Name Town Street House ID_Number Marco Valletta Triq l-Ajkla 10, Fl 1 53290M Mary Valletta Triq l-Ajkla 10, Fl 1 4748M Victor Valletta Triq l-Ajkla 10, Fl 4 37867M Krystle Valletta Triq l-Ajkla 14, Fl 1 52467M Mariella Valletta Triq l-Ajkla … |
| | Ok so I have three tables Customers,Invoices,and Delivery with the fields: Customers: CustomerID Address ........ Orders: OrderID DeliveryID ....... Delivery: DeliveryID DeliveryToAddress ...... So what I want to do is update my delivery table for the DeliveryToAddress for when the customers address changes within the customers tables. To get the … |
| | Hi Just asking for a better solution for my approach in getting sql result with different multiple conditions based on comboboxes. I have a 4 comboboxes, for Branch, Type, Status and other info. User can select conditions from this comboboxes. The default value is "All", meaning no specific condition at … |
| | Hi All, I am trying to add insert/update and delete to an OOP singleton database connection using public functions like this, not sure if it is correct? example code public function insert($sql){ if($this->_execute= $this->_mysqli->_execute($sql)){ while ($row = $this->_execute->fetch_object()){ $this->_results[] = $row; } $this->_count = $this->_execute->num_rows; } return $this; } //page … |
| | Hello everyone, I'm writing up a new application that instead of using microsoft as a server, I'm using a linux server with a database in it. The database was setup, the tables were set up, and access was granted in mysql. The issue I'm having is that I keep getting … |
| | Hi! Can anyone know the result of this query: SELECT COALESCE(MAX(ID),0) + 1 FROM Table123 |
 | for($i=1; $i<=($jumlah_row_tabel_atas+1); $i++) { $satuan = $_POST['PP_row_'.$i.'_satuan']; $word_2[$i]="SELECT id_unit FROM manage_unit WHERE name_unit = '$satuan'"; $q[$i] = mysql_query($word_2[$i]); $data_X = mysql_fetch_array($q[$i]); $id_unit = $data_X['id_unit']; $harga_1 = $_POST['PP_row_'.$i.'_harga_1']; $harga_2 = $_POST['PP_row_'.$i.'_harga_2']; $harga_3 = $_POST['PP_row_'.$i.'_harga_3']; $id_drug = $_POST['id_drug']; $value = $value_array[$i]; $word="INSERT INTO relation_mu_and_unit (id_drug, id_unit, priority, value, harga1, harga2, harga3, last_edit) … |
 | What the webpage would do is after clicking "SUBMIT" button, a php script will be use to add records into my database. But for now i do not know where to put the "signupinsert.php" into the html and to make it run. I have try putting it at form action …  |
| | hi I am trying to save multiple images into one ID and I am getting no where ...I am posting the code so for storing and retrieving image (one image)...but need to store more than one ....need some help here ... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using … |
 | I'm developing an application in which i want the software to be executed at any place. So i want the database to be placed in one computer. This is the scenario. All the computers will be networked. Can i do this in c#.net ? Please tell me the procedures. Thank …  |
| | Hi, Im having a hard time figuring this maybe a simple query. This is my first time to use sql compact edition. How can I query a select statement inside a select statement which tables are not related at all. What i need to accomplish is to insert a logo …  |
| | I'm working on a insert form for my movie database and I have some code working and will be adding more to it, but I wanted to know if there was a better way to go about doing some of this or if I have made a huge coding error. … |
 | how to connect sql server 2000 database with multiple connections I got a sample database DB1 and DB2, the DB1 I have table A, and I got a table on DB2 B, between A and B table no direct relation thanks for the enlightenment |
 | |
| | I have created a table in mysql database table(tblmysq) with id(autoincrement),name(string),branch(string),sex(string),and dat(datetime).The following error occurs when i try to insert a record:check the manual that corresponds to your mysql server version for the right syntax near line 1. My lines of code are : Try conn = New MySqlConnection(conStr) conn.Open() … |
 | Hi All, I want to get all the IPs of the A RECORDS for **mail.google.com**. The aim is to deny access to these IPs. I learnt that mail.google.com has several IPs. I did the following steps: 1. whois google.com 2. I got the following as its DOMAIN SERVERS: ns3.google.com ns2.google.com …  |
| | Ok, before I start, DANIWEB is my last resort to get help. it seems the people on the other sites are having trouble understanding and/or helping me with this... anyway, here is what I am trying to do: I have a website with a folder structure that I allow users … |
| | Hi, is it possible to combine Stored Procedure and Text Command Type in Select Statement? I have a stored procedure that compute available items, it quite a bit long select statement, now i need to call this statement in another select statement which is in text command type, how will …  |
 | i almost spent 3 hours on EXISTS operation, used in SQL especially with subqueries, i got its purpose :) that's ok but what i don't get is that WHY TO USE IT ? e.g. couldn't understand this example: *TABLE STORES* storeName----Sales-------Txn_date *TABLE GEOGRAPHY* regionName----storeName SELECT SUM(Sales) FROM Store_Information WHERE EXISTS … |
The End.