1,079 Recommended Topics
Remove Filter  | |
 | Hello, Can anyone help me check if this SQL Injection Vulnerability Scan is FREE : https://suip.biz/?act=sqlmap And is the report truly shows whether the website is vulnerable to SQL Injection or truly save. This is the report example: ___ __H__ ___ ___["]_____ ___ ___ {1.2.3#stable} |_ -| . ['] | … Databases sql  |
 | hello i have oracle database 10g as my sql server. i didnt use it for over a year and now when i open it the page just closes without any warning or error after entering the username and password. i reinstalled it and the problem is still there. i can't … |
 | Hi, I have a SQL Server (RSQL) and a SSAS Server(RSSAS). RSQL has a linked server to RSSAS, naming [LinkedCube] Here is a screenshot of my Linked Server Properties I use SSMS to connect to RSQL and then run a query that returns data from SSAS using linked server. The … Databases sql |
 | **I need someone 2 help me drawing the ER diagram for this scenario :( ** Draw an ER Model and the corresponding relational model (logical model) for the following problem. StrongTEETH4U is a private dental clinic that is well known and has an excellent reputation in the area. All patients … Databases mysql  |
| | Hello, I am trying to import sql database and receive this error message. What does it means? MySQL menyatakan: Dokumentasi #1452 - Cannot add or update a child row: a foreign key constraint fails (`wwwsoulf_revsoul2`.`timeline`, CONSTRAINT `timeline_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) Databases mysql  |
 | i want to insert invoice values into databade invoice amount limit and split into multiple row if amount is grater than limit and insert it indicia or group  |
 | I was attempting to store chat logs in a MySQL database where the message field is utf8_general_ci However, when it came across an emoji, it would choke, and the message field would only include text up to the emoji character. I changed the message field to be utf8mb4_general_ci, which seemed …  |
 | Hi Please why I got this error(SQL Error: ORA-00907: missing right parenthesis) whats wrong in my code? CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(5) NOT NULL, path VARCHAR2(100) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ); … Databases oracle  |
| | I am a beginner in this field and I have some mistakes in ((codes)) who can tell me what my mistakes. Physical model (1) Employee (SSN, Salary, Phone) CREATE TABLE Employee (SSN integer PRIMRY KEY, Salary integer, phone integer); Department(DNO, dname, Budget, ssn_employee) CREATE TABLE Department(DNO integer, dname varchar(10 )Budget … |
 | I have two tables. MODELS and AUTOMOBILES. And procedure which export all models with name that user inputs and their price(stored in AUTOMOBILES). create or REPLACE procedure modelzz( VAR_MODEL IN MODELS.NAME_MODEL%TYPE, VAR_PRICE OUT AUTOMOBILES.A_PRICE%TYPE ) as begin SELECT a.A_PRICE INTO VAR_PRICE FROM AUTOMOBILES a join MODELS m on a.MODELS_ID_MODEL=m.ID_MODEL where … |
 | Hello, my code at the minute fetches a record and splits it up into a tuple, this is so each individual element can be displayed in an entry. I am now trying to create a feature which reads what is in the entrybox and updates the record in the database. … Databases sql |
 | I am having a table with nvarchar feild in which values are entered like 1 4 8 25 I want a sql query to find the missing sequence of number in the above series... Thanks in advance...  |
| | Hi Thank you in advance for the replies I will be getting.. Much appreciated. Basically I am running the following mysql query using PDO UPDATE users SET password = AES_ENCRYPT(:password,:supersalt) Now the issue is.. on one computer I am getting ¶z8Ibﶘé®òŒdÂY in the password field but on another its blank. … Databases mysql  |
 | |
| | Hi everyone, I have database which has data of past 2 years. I want to get that data for current financial year. [COLOR="Green"](Here financial year is 1st april to 31st of March)[/COLOR] This query returns data for current calender year i.e. [Jan-to-Dec] [COde=sql] SELECT DATENAME(MONTH, DATE) AS MonthName, SUM(NetAMOUNT) AS … Databases mssql  |
 | Drop down selection not showing up in MySQL. How do I get the selection from the MySQL-populated drop down list to be a value I can use when creating a new record? <?php include_once 'dbcon.php'; if(isset($_POST['save_mul'])) { $total = $_POST['total']; for($i=1; $i<=$total; $i++) { $sname = $_POST["sname$i"]; $sql="INSERT INTO users(speaker) … Databases mysql  |
 | Hello ! I'm having a university project where I have to make a database on MS Access . The subject is : We have a company that deals with trading. You need to make a database to serve cost and product discounts for customers. The database must contain : -Nomenclature … Databases microsoft-access |
| | I got a syntax error flag in my "users" database table, but can't figure the issue out. Please, I need your help. The following is the error message: Error SQL query: --------------------------------------------------------- -- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` INT( … Databases mysql |
 | I need a list of all 5160 name Indian cities by district name in xls/csv or sql format. Where can I find them? Databases sql  |
 | Hi there, I would love to make a list and have a collection of database servers, could you all please help me? It would be nice if you could provide a link to their homepage. If you post, I will update the first post. [list] [*]MySQL ([url="http://www.mysql.org/"]http://www.MySQL.org/[/url]) [*]PostgreSQL [*]Access [*]MSSQL … Databases  |
 | 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: " . … |
 | We have built a software web-portal (POS system) in PHP language. Which is working fine when online. But when the internet goes down in the stores, the software stops completely and the managers are not able to make bills till the time internet is live again! Hence we want to …  |
| | 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 ?????? Databases mysql |
 | 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 … Databases mysql |
 | 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 * … |
 | 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 = … |
 | 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 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 |
 | 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 |
 | I receive an error message and I don't know what to do about it. IO have a delphi app using a MS Access 2010 database. I connect to it through BDE. It worked perfectly until today when the users told me that they can't enter my application due an error … Databases |
 | 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 |
 | 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 |
 | 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() … Databases mssql |
 | I am looking for a mysql query to search and list most common pairs with their IDs and number of occurence. Thanks. |
| | 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 … Databases mysql |
 | 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, not very familiar with mysql. I have here a mysql statement: table customer: [CODE]CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30), PRIMARY KEY (SID));[/CODE] table orders: [CODE]CREATE TABLE ORDERS (Order_ID integer, Order_Date date, Customer_SID integer, Amount double, Primary Key (Order_ID), Foreign Key (Customer_SID) references CUSTOMER(SID));[/CODE] My question is, … 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 |
| | 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 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  |
| | 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 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 … |
The End.