Member Avatar

SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee )

Member Avatar
+0 forum 1
Member Avatar

I need a simple external table definition for preforming loads from FIXED WIDTH files. I don't remember how to do External tables in oracle. This would be a Fixed width, not CSV. I am creating a generator and I need the external table definition.

+0 forum 0
Member Avatar

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

Member Avatar
+0 forum 4
Member Avatar

I have to get an instance of Oracle XE running on my laptop. This is so I can test a plsql package I have been working on at my house. Currently out of the job. I seem to remember when I did this the last time I had to configure the tnsnames.ora and listener.ora files correctly. I would like everything to be as simple as possible. Ex, everything should be named XE or something. I can't even find the listener.ora file actually. Need a brief walk through over the tnsnames.ora file and the listener.ora files.

+0 forum 0
Member Avatar

Hello all. I have a funtion in MYSQL to substruct days from a date. This function seamsto work but some dates it times out. This is my function CREATE DEFINER=`root`@`localhost` FUNCTION `Calculater`(intrval int, req date) RETURNS date DETERMINISTIC BEGIN declare calculated date; declare added int default 0; Lbl_Loop: Loop IF added=intrval then leave lbl_loop; End IF; set calculated = DATE_SUB(req,interval 1 day); IF weekday(calculated)<5 then set added= added+1; End If; end loop; RETURN calculated; END If I do **select Calculater(1,"2020-02-04")**; it works, but **select Calculater(1,"2020-02-02")**; it runs for a few seconds and My SQL times out. Thanks in advance.

Member Avatar
+0 forum 1
Member Avatar

I have a database, where I store Job Openings, Where I store Job Descriptions with formats in RichText Box like: bullet points, ordered lists and bold text etc... But when I save data in MySQL Database and Retrive it from Database it comes format less. Can anyone help me regarding this issue?

+0 forum 0
Member Avatar

I'm using phpMyAdmin to manage my databases, I have 2 projects that use 2 different database the first one uses 'root'@'localhost' and the 2nd is 'root'@'127.0.0.1' I don't know how i ended up using 2 different server but it was working fine until i tried to edit codes with the 1st project that uses 'root'@'localhost', I was trying to select from a table to be loaded to a DataGridView when an error popped up saying "Host 'hostname' is not allowed to connect to this MySQL server". The 2nd project is working fine. This only happened after I try to create …

Member Avatar
+0 forum 3
Member Avatar

Hey! I am really stressed out about my TURBO CPP project. I wrote a program on periodic table using file handling. when i compiled it crashed and not the project is unusable. I want to submit it at the earliest. I was hoping some one might drop their out projects. Thanks.

Member Avatar
+0 forum 6
Member Avatar

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 (CityName = 'Абакан') i get the results null, althought that record in the table i tried to add a record with cityname= 'abc' and ran the view with this parameter, it worked fine so it only doesn't get results written in russian any ideas? SQL query problem with any language …

Member Avatar
+0 forum 5
Member Avatar

I've just started working with PHP and MySQL, and I'm trying to create a table in MySQL. If I've got this right, I'm trying to do so by going to my host's SQL MyAdmin page and typing in mysql_query("CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), age INT)") in the query tab. I get an error saying that my syntax is wrong. Any advice?

Member Avatar
+0 forum 4
Member Avatar

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 to column Categories and Sequence ? Thank you in advance !

Member Avatar
+0 forum 3
Member Avatar

I come across this problem every so often and end up having to do work arounds when I would prefer to keep it in the database. I have a query where the data in the query updates frequently so the query won't stay in the cache but I don't need the query to be accurate. I was trying to avoid adding an extra step of storing the data in a temp table and having to update it on a timer. Does anyone know of a way to get MariaDB or MySQL to Keep the result set for a period of …

Member Avatar
+1 forum 11
Member Avatar

Hi everyone, right now I am looking for a database b2c (consumers) from the UK and SPAIN with more than 200k leads. This is to buy, someone interested?

Member Avatar
+0 forum 2
Member Avatar

Spent a day trying to gen any info on this but didn't find anything so maybe someone here could help me out . here's the html code and a css style. Maybe it's not that difficult in the end but I have never done this and php is not my cup of tea, so I'd be really thankful if someone could help me out! <html> <head> <link href="example.css" rel="stylesheet"> </head> <body> <div class="container"> <h2>ACCOUNTS</h2> <ul class="responsive-table"> <ul> <li class="table-header"> <div class="col col-1">Department</div> <div class="col col-2">Account</div> <div class="col col-3">Account status</div> <div class="col col-4">Account info</div> </li> <li class="table-row"> <div class="col col-1" data-label="Department">-</div> …

Member Avatar
+0 forum 3
Member Avatar

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 not too comfortable with when to use @variable or just variable. Thanks. DELIMITER $$ CREATE PROCEDURE `DATEDIFF_WEEKDAYS`(IN `IN_from_date` DATE, IN `IN_to_date` DATE) BEGIN DECLARE TOTAL_WEEKDAYS INT DEFAULT 0; DECLARE TOTAL_DAYS INT DEFAULT 0; DECLARE FROM_DTE DATE DEFAULT NOW(); DECLARE TO_DTE DATE DEFAULT NOW(); DECLARE CURR_DTE DATE DEFAULT NOW(); IF(IN_from_date = …

Member Avatar
+0 forum 3
Member Avatar

Hello. At work, I have to count about 5k in a day for products. When someone takes out or puts in products for example 450 I have to recount again. So I want to create a system that when someone puts some kind of product on the shelf they would enter the quantity they are putting on the stock. For example, TOM puts 150 pcs of -product1- in stock. Then Bill will take 50 pcs of the same product1. So the system would do the calculation: 150-50 = 100 pcs left in stock. When TOM will put again 110 pcs …

Member Avatar
+0 forum 2
Member Avatar

I am looking to create a database to record when students' work has been handed in to the office. I have created the form but it needs to be able to record who signed in the work. There are several people working in the office and will use the database. How can I record who logged in to the database to accept the work on the form itself?

Member Avatar
+0 forum 5
Member Avatar

I am using bootstrap modals, when i query to populate a dropdown to fill in to my form, my query is show all but the first record and i can't figure out why. My form looks like this <div class="form-group"> <label for="deptcode">Department</label> <select class="form-control" id="deptcode" name="deptcode" value="<?php echo $mem['deptcode'];?>" <?php $departments = $mysqli->query("Select * FROM department ORDER BY deptcode"); while ($dept = mysqli_fetch_assoc($departments)){ $tempdeptname = $dept['deptname']; $tempdeptcode = $dept['deptcode']; //see what the current name is and display it first if ($tempdeptcode == $mem['deptcode']) echo "<option value='$tempdeptcode' selected='selected'>$tempdeptcode ($tempdeptname) </option>\n"; else //if blank display first item in dropdown list echo "<option …

Member Avatar
+0 forum 1
Member Avatar

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 they did and awards they won (for example, I can insert The Beatles into the Database and record all their members, when they debuted, when they disbanded, their songs and more). For now I am only going to create a table that can store the group's/band's name and another table …

Member Avatar
+0 forum 5
Member Avatar

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

Member Avatar
+0 forum 3
Member Avatar

Here is a basic question, what is the fastest way to transfer a MySQL database? Here are the variables at play: 1) Database is just shy of 3GB 2) Transfer is between two servers running different versions of MySQL 3) There will not be usage of the database during transfer, I can even shut down MySQL if needs be. 4) The database is mostly MYISAM but with a few InnoDBs and a couple Memory (VBulletin) 5) Both servers are Linux based and I have root access on both. I've done the transfer using a mysql dump, but the import took …

Member Avatar
+0 forum 15
Member Avatar

DaniWeb was written in Codeigniter, and when posting to the forums, we use database transactions that look like this: $this->db->trans_start(); ... insert into the posts table ... ... update the member's post count ... ... update the tags table ... etc $this->db->trans_complete(); On occassion, the error log will show for a particular query within the transaction: *Query error: Deadlock found when trying to get lock; try restarting transaction - Invalid query* When that happens, the entire transaction is rolled back. However, this is not ideal because when someone attempts to make a post, we don't want it to completely fail …

Member Avatar
+1 forum 10
Member Avatar

here is the normal rows coming ![WhatsApp_Image_2019-11-04_at_2_32_36_PM.jpeg](/attachments/large/4/f5be1a527695a5bf62797e287c220820.jpeg) i want to show the group by product name with the count of store as the below picture ![WhatsApp_Image_2019-11-04_at_3_28_58_PM.jpeg](/attachments/large/4/b96ff7cb890fb01e6de9e5540a7e7a9e.jpeg) 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

Member Avatar
+0 forum 1
Member Avatar

help with ER diagram for package courier service systems

Member Avatar
-1 forum 2
Member Avatar

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 = $row['id']; } } // Step 3: UPDATE the DB with the new info from the form. Validate first. if(isset($_POST['mysubmit'])) { $title = strip_tags(trim($_POST['title'])); $message = strip_tags(trim($_POST['message'])); //echo "$title, $message"; $valid = 1; $msgPre = "<div class=\"alert alert-success\">"; $msgPreError = "<div class=\"alert alert-danger\">"; $msgPost = "</div>\n"; // Title Validation if((strlen($title) …

+0 forum 0
Member Avatar

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: missing right parenthesis The parenthesis are in pairs and match. Why would this error message occur and how could I fix it>? Edit: this is the other Table for reference: CREATE TABLE Municipio ( id_no_pk CHAR(2) PRIMARY KEY, nombre VARCHAR(20) NOT NULL ) ;

Member Avatar
+0 forum 1
Member Avatar

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 a lot of people are going to my website, like more than 20 people in a day, but here is the question or discussion? how and where do I begin learn about databases, I don't really care what language I am going to use, like sql or php, is sql …

Member Avatar
+0 forum 7
Member Avatar

Hi All, I am going to write a small inventory tracking app for a small company. What they need is only to keep track goods in, goods out, supplier, customer, and purchase price and sell price so we are able to calculate purchase price, sales price, and stock value. [LIST=1] [*]Puchase table is for goods in, it links to product table, have timestamp, quantity and price attributes to calculate the purchased price [*]Sales table is for goods out, it links to product table, have timestamp, quantity and price attributes to calculate the sale price [/LIST] My question is: When we …

Member Avatar
+0 forum 7
Member Avatar

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 many php checks and not a problem is found. Does anyone have the answer for me? I would greatly appreciate it. No Errors shown just the white age of death. <?php include_once('jcart.php'); ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); // Connects to your Database mysqli_connect("localhost", "dnk", "here1") or die(mysqli_error()); mysqli_select_db("dnnnk") or die(mysqli_error()); …

Member Avatar
+0 forum 3
Member Avatar

Hello to all. I am developing software in vb.net for sales invoices. Where i need to import invoice data from excel file to vb.net Grid Data View and then save into access db. I will use db data in future for creating customer invoices. I have code that import excel data into GDV successfully, but i d'nt know how to save data in access db. Access db Name "MyInvoice" and table Name is 'InvoiceData'. Please help me to write correct code. Thank You. Imports System.Data.OleDb Imports System.Data.SqlClient Public Class MainForm Private Sub BtnImpExcelFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …

Member Avatar
+0 forum 1

The End.