6,934 Topics
 | |
| | can you please help me to answer that problem? This is a question, I have an employee salary table, How do I find the second highest from it.? A big thanks to those who will help. I appreciate it a lot. |
| | As you may know, Transact-SQL debugger was deprecated in Microsoft Management Studio for SQL Server 18.0 and the functionality is no longer available. However, there’s nothing to panic about since Devart is rolling out SQL Complete 6.4 ( https://www.devart.com/dbforge/sql/sqlcomplete/ ) with code debugging feature honed to perfection in dbForge Studio … |
 | I have a nested query that is counting how many invoices have been raised for a customer between a daterange which is working fine EXCEPT..... I am getting null in the Invoice_Count field and I would like to change this to 0. I have tried isnull(SUM(CASE WHEN Inv1.ih_credit = 1 …  |
| | |
| | Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in F:\xampp\htdocs\ajax\server.php on line 55 // Retrieve comments from database $sql = "SELECT * FROM comments"; $result = mysqli_query($conn, $sql); $comments = '<div id="display_area">'; while ($row = mysqli_fetch_array($result)) { $comments .= '<div class="comment_box"> <span class="delete" data-id="' . $row['id'] . '" … |
| | hi good day guys, i'm having a trouble with fetching the data i have a list of folder outside like in the picture below  when i click the first folder the picture below shows the output it has duplicates  i want to know what's the problem with my … |
| | SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee )  |
| | Hi. im developing a loan processing system using mvc c# asp.net. One of the requirements of the system is to perform a credit history check on the customer applying for a loan. so this is how it works: -the customer applies for a loan. the customers id number gets stored … |
 | Hi, I am new with sql server. I want my date formate like dd-mm-yyyy.. but i could not able to do so. please help me and give me proper syntex fro the same |
 | I have a basic html here, where you could just submit the button through an action page, so it inserts the record into the mysql database in phpmyadmin, what I want to know is how to make it auto submit after 5 mins, while setting the blanks fields value into … |
| | I have a large database of information of characters This contains "owner", "charactername" & a lot more info the owner can easily repeat as they own more then one character. what I'm trying to attempt to figure out how to do is create a list of UNIQUE names and how … |
| | How to insert data in sql server 2012 express using php pdo in wamp server 3? What connection string I need to use to connect in the database? |
| | Hello guys, i've the following table in database : IdCity int CityName nvarchar(20) it has the data like this in it : IdCity CityName 1 Абакан 2 Азов 3 Александров 4 Алексин 5 Альметьевск 6 Анапа when i try to run the following view SELECT IdCity, CityName FROM dbo.City WHERE …  |
| | Hello, I need some help from experts. I am testing a site I have created. I have an issue with login system. It worked fine using XAMPP on my computer but when I uploaded to a live server, login has been a problem. This is what I get when I …  |
 | Hi all :) Currently now I used MS SQL Server Management Studio 2008. I have an existing table with data already store on that table. Table Name : Application Column : Categories (nvarchar(1), null) Sequence (nvarchar(1), null) Detail (nvarchar(150), null) I would like to ask how to add primary key … |
 | |
| | Really hoping someone can help me out or point me in the right direction. This is my first ever post in a coding forum so I apologize in advance if I’m breaking any forum rules. I already have a bunch of php code sorted from modifying web resources. I need …  |
| | This is a partial of the code I have on my script. I have tried to make the backgrounds change color depending on the values and can't get it to read the arrays correct. Placing the conditions outside the while or inside the while returns same results when printed. If … |
 | My site use to work fine. But today for some reason pages with mysqli_num_rows takes a very long time to load. I can visit the page but it takes a long time to load. When it loads there are no errors but the error file in the root directory have … |
| | Hi all, I wanted to procedure to return number of days and weekdays between two dates. This is what I came up with and it seems to work ok, but I'd like to read what others think. And if there's already a single line function for this, oops. Also, I'm … |
| | Well I guess it is my turn to ask a question, since most of the time I spend answering questions on DaniWeb. The Problem: DataViewGrid throws a "System.ArgumentException parameter is not valid..." when the dataset contains an SQL 2005 TimeStamp type column. The error occurs in System.Drawing.FromStream... da da da … |
| | I am working on an app where a user registers and its passed to the server where there information is added to the database. It passes various checks along the way but ails to add the user. Code below: <?php $con = mysqli_connect('localhost', 'root', 'root', 'eat4lessaccess'); //check connection if(mysqli_connect_errno()) { … |
 | Hello. I have a quick question. I am making a database as a personal project (I am using Microsoft SQL Server therefore I am using its SQL syntax). All it does is that it keeps track of singing groups and bands, the members in these groups, albums they made, songs … |
 | All Time Show Null value Please help me what is the wrong in my code declare @mxdbvlu int declare @dbvlunm int set @mxdbvlu= (select max(Database_name) from TBL_FY_SELECT_1) if @mxdbvlu = null set @dbvlunm=1000 else set @dbvlunm=sum(@mxdbvlu+1) select @dbvlunm,@mxdbvlu  |
 | I need help on a new problem. On my women’s golf club web site I have a Members Directory page which consists of a table, 5 columns in width, and enough 2 rows sets to hold the members photo in the odd numbered rows with the members name in the …  |
| | here is the normal rows coming  i want to show the group by product name with the count of store as the below picture  here are mysql query SELECT i.barcode, i.name, u.company_name, COUNT(i.id) AS IQTY, COUNT(U.id) AS UQTY FROM inventory i, USER u |
| | can someone please help me with coding. I need to create a dropdown menu with the options being the category the user has inputted into a file upload page. |
| | How do I echo selected option? <?php session_start(); if(isset($_SESSION['cherianne'])){ }else{ header("Location:login.php"); } include("../includes/header.php"); // Retrieve our critical page setter variable. $char_id = $_GET['id']; //echo "<h1>$char_id</h1>"; // set this as a default value if (!isset($char_id)) { $result = mysqli_query($con, "SELECT bid FROM cde_blog LIMIT 1"); while ($row = mysqli_fetch_array($result)) { $char_id … |
 | CREATE TABLE Peaje ( id_no_pk CHAR(2) NOT NULL, nombre VARCHAR(30) NOT NULL, localizacion VARCHAR(30) NOT NULL, dirrecion VARCHAR(50) NOT NULL, tipo CHAR(1) NOT NULL, municipio_fk CHAR(2), CONSTRAINT Peaje_id_no_pk PRIMARY KEY(id_no_pk) CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)); CONSTRAINT Peaje_municipio_fk FOREIGN KEY (municipio_fk) REFERENCES Municipio(id_no_pk)) * ERROR at line 9: ORA-00907: … |
| | after i key-in the form, the function change the whole column with the same value for example if i put first name JOHN it will update whole column with JOHN <?php session_start(); require_once("connection.php"); if (isset($_POST['edit'])) { session_start(); $s=mysqli_query($con,"UPDATE user SET first_name ='" . $_POST['first_name'] . "'"); $row = mysqli_fetch_assoc($s); if … |
| | So I am really interested in making a database, I have knowledge about html and css, not javascript and I just want to begin learning and making a database. I am going to use this website: https://www.000webhost.com/?utm_source=000webhostapp&utm_campaign=000_logo&utm_medium=website&utm_content=footer_img so you can see my website in the internet, I don't really expect …  |
 | I am currently creating a product lookup system for a project of mine, however from reading around it has come to my attention that an OLEDB connection will not handle the SQL query below as it will not handle more than a simple "SELECT, FROM". Table: tbl_ProductInformation Field: Product_Name CurrentEntry … |
| | I do not have a clue as to what the problem is with this code. I am running php 7.0. This was an old form I used long ago, decided to upgrade it for random use. It works on php 5.0 but not in 7. I have run it through …  |
| | Please I need your help, I am new to PHP and I need your help in inserting multiple select array into the database in the form of this. This is what I want to achieve. My table has 3 columns (id, examno, results). I want results column to be inform … |
| | Please I need your help, I am new to PHP and I need your help in inserting multiple select array into the database in the form of this. This is what I want to achieve. My table has 3 columns (id, examno, results). I want results column to be inform … |
| | Hi everyone! i have a question that, if there are two radio buttons Male and Female, if some select male,this value will be store into database, but if he select again another value which is female,then how the first value(Male) will be replace by second value (Female) in the database … |
| | How do I process the xamarin forms that connect to SQL Server and export data to the listView ? I'm looking for this simple example. What do I find on google ? |
| | If an index file is missing in a folder, apache uses its own file/files to list the contents of the folder. Since I don’t want to create an index file in every folder in the file systems, I wonder where I can find the file/files that apache uses when there … |
 | I use MampPro to setup my sites on the local server... all well and good. So, every time I fire it up I get the upgrade nag... so, I figure its time, and hit the upgrade... and it does its thing. BOOM, every database I had there - gone! GRR! … |
| | Hi all, How to store data in two different tables when we click the button. Suppose I have a 2 tables named as team1 and team2. In table team1 have 2 fields teamid,teamname In table team2 have 3 fields team2id,team2name,teamid here teamid is foreign key. So when i click on … |
| | Hi all, How to store data in two different tables when we click the button. Suppose I have a 2 tables named as team1 and team2. In table team1 have 2 fields teamid,teamname In table team2 have 3 fields team2id,team2name,teamid here teamid is foreign key. So when i click on … |
| | Hello! I have a question and I don’t know whether the title is actually descriptive. For some background on the matter, we use Sage 50 as our merchandise information system and for our reporting and controlling tools we run Access queries. Since our database had been reset at some point … |
| | Hi, I have a form which consists a dynamic dependent dropdown and I want to maintain the entered data into the fields after the form is saved or edited. For an example: <input type="text" name="serial" value="<?php echo $serial;?>"> Similary i need to get the value in my dropdown as well. …  |
 | I have storing major data in mysql and logs are stored in cassandra. Cassandra db getting heavier and difficult to do queries. So I want to migrate all my cassandra's table in mysql is it possible? |
| | How can you get the alternate records from the table in the SQL? |
| | in sql server there is a group problem statement: DENSE_RANK() OVER (ORDER BY TABLUONGNV3.HOVATEN) AS STT How to write in sql access issues in groups? I'm not writing well: (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT SELECT (Select Count (*) FROM [TABLUONGNV3] … |
| | My data SQL Server is reported this error, How does this error fix you ? SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0x5555aaaa). It occurred during a read of page (1:210768) in database ID 7 at offset 0x00000066ea0000 in file 'G:\Database\MyData.mdf'. Additional … |
| | In MySQL Database i have a worker who has 1 year of leave days (about 360 days): +--------+---------+---------+-------------+---------+-----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE | +--------+---------+---------+---------+------------+------------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 | +--------+---------+---------+----------------------+------------+ When i I'm going to run below Mysql Command which calculates leave time without weekends and … |
| | Show error when I login to the SQL server management. First, I change the server name. Second restart the server/1st stop services the start services. Then I check the server name SELECT @@servername AS 'ServerName' using this line the show new change server name. Then I closed the window of …  |
| | TITLE: Connect to Server ------------------------------ Cannot connect to (LocalDb)\MSSQLLocalDB. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote … |
The End.