7,494 Archived Topics
Remove Filter  | |
 | I'm not sure if this is the right forum to ask this in, sorry if it isn't. It's been a while since I've been to this site. We have a MS SQL database that contains a table with some columns that are no longer used (or shouldn't be). The data … Databases  |
 | Hello Guys, So im a student at 12 grade and im trying to build a website from scratch and i've been successfull until now, i've been stuck in this error for 2 or 3 days, i cant send the text area + other input to database at the same type …  |
 | The second annual Imperva Hacker Intelligence Initiative report, this one entitled [Monitoring Hacker Forums](http://www.imperva.com/docs/HII_Monitoring_Hacker_Forums_2012.pdf), is out and reveals that the threat surfaces being discussed by the hacker community are very different from those that businesses are spending money on defending against attack.  The Imperva research analysed the content … Databases cybersecurity mssql sql  |
| | I am trying to connect to a Microsoft SQL server database using PHP 5.6 and am getting the error "could not find driver". I am initially attempting to use PDO but I could use the procedural version if necessary. I have downloaded the SQL server PHP driver and placed it … Databases mssql php windows-server |
 | Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion Here is my simple code. // db.php code _______________________ <?php //$con = mysqli_connect("localhost","root","","bakery"); $db = mysqli_connect('localhost', 'root', '', 'bakery'); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . … |
| | I am trying to set a record back to null. I was able to change it from null and now I want to change it back to null. For some reason it is not working. This worked perfectly fine: UPDATE members set end_date = "2017-01-18" where player = 1 and … Databases sql |
 | This problem's driving me crazy since yesterday. I have a table consist of 5 columns: kode_barang (item ID), nama_barang (name of item), qty (quantity), harga_beli (price), jumlah (total). User can input 2 items. This is the code of the form: <HTML> <?php include "koneksi.php"; ?> <form action="insert3.php" method="POST"> <table id="theTable" … |
 | Is the method in MySQL to set in SQL script dynamic log file name? e.g in Oracle PL/SQL set define on column sdate new_value sdate select to_char(sysdate,'YYYY.MM.DD_HH.MI') sdate from dual; spool 'logs/install_&sdate..log'; e.g. in PG/SQL \o ./logs/install_`date +"%Y-%m-%d_%H%M"`.log but I cant find similar in MySQL \T ?????? |
 | Hi. I'm retrieving a record and populating the data into input fields. there is a column called fld_order_date type timestamp. How do i retrieve the date? i have the usual retrieval: $stmt = $conn->prepare("SELECT * FROM tbl_orders_a154287 WHERE fld_order_id = :oid"); $stmt->bindParam(':oid', $oid, PDO::PARAM_STR); $oid = $_GET['edit']; $stmt->execute(); $editrow = … |
 | How do i format my Query result so it has thousand seperator and only to 2 decimal places <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Daily Sales</title> <link rel="stylesheet" href="../styles/login.css" media="all" /> </head> <body class="normal"> <?php include("../includes/x3connect.php"); ?> <?php $sql="SELECT SUM …  |
| | Hi I have the following code that i can run in MSSQL Query and the result are returned correctly but when i try to run it in PHP it errors what do I need to change to get it to work please. SELECT SUM (CASE WHEN FFP.BPARTNER.CUR_0='GBP' THEN (FFP.SORDERQ.YORIQTY_0 * … |
 | I've been reseraching the best way(s) to store both ipv4 & ipv6 ip addresses. Simply put, so far there seems to be much debate as to how to do so properly ranging from storing them as varchar or in a binary format. I'm really not sure at this point. I …  |
 | Dear all, I have a scenario, where I have a single table with all my users listed in them. Each user also has a field indicating the user they report to. UserID UserDisplayName UserReportsTo ----------- ------------------------------------------------------------ ------------- 8 Anthony Karimi 3 9 naheed kassam 8 1 Administrator 1 3 Ramakrishna … |
 | Hello all members, I am new to this this website. I am working on an assignment and I have a scenario where I have to find the key attributes, entities and keys. Below is the scenario, An international courier, express and parcel Services Company is setting up a package shipping … Databases |
| | Hello everyone, I am having trouble with my code to list all the prime numbers in R. This is what I have thus far: prime = 0:100 for(val in prime){ if (val == 0){ next } else if (val == 1){ next } else if(val == 2){ val = 2 … Databases mathematics |
 | I have done master master replication . I want to do multi master master replication. I research and found mostly master master replication in circular topology. But I want to do one supermaster who reads and update other masters. Is it possible? Is anybody did this? Databases mysql |
 | Hi, I am following a walkthrough of [Entity Framework Code First to a New Database](https://msdn.microsoft.com/en-us/library/jj193542(v=vs.113).aspx) Everything appears to go as expected right through to the end of step 4, where it says "We can now inspect the schema that Code First created." The database shows up under data connections in … Databases sql |
 | We have a MS Access database located on a shared drive. Is there a way I can allow multiple users to access and update the database at the same time? Databases microsoft-access  |
 | I am trying to get the position of students in an exam. The SQL query I wrote uses the DENSE_RANK() function and it works properly just that it does not leave spaces after equal positions. I understand I can achieve that using the RANK() function. I Tried using the RANK() … |
| | I have a login session where it checks the user name and displays it to the form (it displays FirstName LastName). That username is also being used as a variable to pull up data in db. Now I also have another page where user's can update the db, I dont … |
 | I am looking for a mysql query to search and list most common pairs with their IDs and number of occurence. Thanks. |
 | My scripts are doing a lookup of transactions in table B. Each transaction contains an integer which is an ID of the business for each transaction. I also want the name (a varchar) of the business in the original transaction. My solution was to do a 2nd lookup for each … Databases mysql |
| | Hi I am useing Lazarus and a odbc connection to connect to a MS Access database I connect fine and get all records displayed in a dbgrid . My problem is to get the changes written back to the db. When i try to write the data back to the … Databases microsoft-access |
| | I had a quick course of database few years ago and I forgot a lot from there. So you can say I'm starting from zero. I will try to explain to you on what I want to do and a picture with what I did so far. We have a … Databases sql |
| | Hi, I am currently working on Oracle 11.2.0.3. Below is my requirement. 1.I would like to scan the database ( Eg. 1 entire schema) and need to find the DB object either Procedure/Funcation which is having DROP statement. ( some of the procedures having " DROP PROCEDURE <PROCEDURE_NAME> " statements. … Databases oracle |
| | Hi everyone, im working on my FYP and have decided on this project title but im finding it a bit difficult in developing the ERD for the system. i came up with these entities: students,staff,administrator and assessment and would want any form of advice or contribution as i think there … Databases  |
| | as seen in the pic a table. I have the following im trying to fill the boxes based on rows. So line one will fill by the correct ordergoing left to right then down. here is my code. $results = mysqli_query($con, " SELECT * FROM PMAsset Order by Linenum, LineOrder") …  |
| | Hi, i have installed prestashop 1.4.8.2 & i need a report of first order date for each customers, please help me to create mysql query. i need below columns information from database. id_customer, firstname, lastname, first order date thanks, Ritesh Databases mysql  |
| | Hi, i have installed prestashop 1.4.8.2 & i need a report of last order date for each customers, please help me to create mysql query. i need below columns information from database. id_customer, firstname, lastname, email, last order date. or is there any way i can export in active customers … |
| | I currently have some code that gets the overall top 25 frame sales, which is as follows: `Dim FrameCountSelectStr As String = "SELECT TOP 25 Count(Glasses.OrderID) AS GlassesCount, Glasses.Manufacturer, Glasses.FrameName FROM(Glasses) WHERE FrameName <> '' AND OrderDate >= #" & SearchDateStart & "# AND OrderDate < #" & SearchDateEnd & … Databases mysql |
 | i have a logical error in my code where by i will read data into my four textboxes from sql database and the textboxes will be filled but when i click on a textbox the data will appear in the metrogrid(from metro framework) but when clicking another textbox the data … |
| | CREATE TABLE BUILDING(bname VarChar2(30) PRIMARY KEY, address VarChar2(30), phone number Number(15)); i write this code in sql command of oracle application express. but there is a error ORA-00907: missing right parenthesis anyone help me please i am new in oracle world Databases oracle  |
| | Hi I have a mysql tables shown below:  I need to build a query to select all groupnames a user belongs to in a single field seperated by ',' e.g. I wanted to following results id fname lname groups 1 connor Faulkner group_one,group_two 2 Maisie Yates group_four,group_three Just … Databases mysql |
| | |
| | I am querying a MYSQL database and would like to return the results so that all of the job numbers that are the same are grouped together and expandable when clicking on the common name. so when the bag loads all you see is a list of job numbers. I … |
 | I have been butting my head against this problem for the past 4 hours, and I have to tap out. I know I can't be too far from correct I am just not sure what the missing ingredients are. Here is the problem question: Student status: List of all students … |
| | SELECT CASE WHEN (Employees.End_Date is null) THEN select EmpId, Emp_Name, Salary , Start_date , End_date ,DATEDIFF(DATE_ADD(Start_Date, INTERVAL 30 DAY), Start_Date) * Salary/30 as 'Total_Salary' from Employees ELSE Select EmpId, Emp_Name, Salary , Start_date , End_date ,DATEDIFF(End_Date, Start_Date) * Salary/30 as 'Total_Salary' from Employees END From Employees; Please help me to … |
 | I am a beginner practicing how to create tables on SQL Here is what I've done: Create Table PO (Order_id int primary key, order_date date, customer varchar(1000)); Create table PO_Line_Item (Order_id int not null, Line_number int not null, Product varchar (30), Unit_Price decimal (10,2), Qty decimal (10,2), Tax decimal(10,2)); When … Databases sql |
 | **problem** How to get cost per hotel and flight then add it in duration cost table based on flight date automatically . **Details** suppose i write flight date 26/07/2017 alexia 8days 04/08/2017 it must automatically get cost from hotel price table and price from flight then add it in duration …  |
 | when i click mysql inserted data load url or pdf page |
| | Hi All, I am having a system which receive data from around 30K gps . Each unit will be inserting concurrently around 1 minute. 1.What tweak should I add to cater for this? I target my ram to be 48Gb with 24 cpus. 2. Once the data grow should I … Databases mysql |
 | Hey, I have two columns. Ride and booking. In table booking there is the foreign key of ride. The intention is that 30-day and later bookings will be removed. If I run this query, I get the error message: mysql 1451 can not delete or update a parent row The … Databases mysql |
| | I want to get sum of estimate quantity from estimates table gropBy material_id. Also want get sum of mprs quantity related to previous query table. My estimates table is as below | id | project_id | material_id | estimatequantity | | 1 | 1 | 1 | 500 | | … Databases sql |
| | I have the following script which successfully finds the values for $payer_email, reminder_date and sub_expire_date, however where I am having trouble is when I apply a WHERE condition to the SELECT. The condition I am trying to apply is the commented out line at the end of the SELECT. The … Databases sql |
| | Hello, I have make a ERD. And there is a case. Can someone look to this both? Did I forget something? Would anything else have to be done? my case is: A hotel guest can be a main guest or a travel companion. Only a major guest can book and … Databases |
 | Am trying to create edit-form but there are some problem which I cant determine by my self. I cant echo inserted record and updating. <?php include("db_con.php"); $edit_reg_no = filter_input(INPUT_GET, 'edit_customer_detail', FILTER_VALIDATE_INT, ['options' => ['default' => NULL]]); if(isset($_POST['update'])){ $update_reg_no = $edit_reg_no; //getting the text data from the fields $d_fname = $_POST["d_fname"]; … |
| | Hello SQL Gurus, This Query below is doing the job but it is horrible slow. Is there any way to make the query faster ? Perhaps a join .. inner outer, left ? I am looooost. Thanks for any help. SQLQuery1.SQL.Clear; SQLQuery1.SQL.Text:= 'SELECT * FROM orders_batch WHERE invoice_no=:elorder_no'; SQLQuery1.params.parambyname('elorder_no').Asstring := … |
 | I am using MS SQL and have logs that are in .mdf and .ldf format. It took us a while but we figured out how to get our new settings correct and coming in w3c format. The olf files are still .mdf and I need to know what I can … Databases mssql |
| | Hello experts, I have to write a sql joining 6 tables. to retrieve classid, planname, workoutname,date,timeslot,status,staffemail and display them to a gridview. the tables are as below **tblclass** having columns *classid(PK)*, planallocationid*(FK to tblallocation)*, date, timeslotid*(FK to tbltimeslot),*status, staffid*(FK to tblstaff)* **tblallocation** having columns *planallocation(PK)*, planid*(FK to tblplan)*, workoutid*(FK to …  |
| | Hi guys, i have a login page where i created a session trainer after login. the session is the mail address of the trainer. now from another apsx page, i would like to retrieve the staffid of the user logged in using the session as criteria. I tried to write … |
The End.