Member Avatar
I'm trying to delete a database in phpMyAdmin which is in localhost of Windows 7 Professional 64bit system. Since I am not an IT or database professional, I'd appreaciate any help with non-techy steps. :-) When I attempt to delete the database I receive the error: DROP DATABASE 'enfold-2016' 1010 …
by Ricardo_1 in Databases ()
Member Avatar
Hi all, I will be building a web application that does a personnel data lookup, unfortunately using SSN. So I’ve been searching for how encrypt this data so that I do not use plaintext SSN in the application to accomplish this. I found this article: ... . Does this mean …
by RudyM 15 in Databases ()
Member Avatar
Hai. i'm beginner in php. Can someone help me to insert the calculated value into database. I'm trying to insert calculated value into database but it doesn't work. This is my code. ...
by Ayuni_1 in Databases ()
Member Avatar
At the bottom is my code and I want to save data on my joined table. Please advise or edit the codes. Thanks :D ...
by Japhet_1 in Programming ()
Member Avatar
I m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 …
by ekuban in Databases ()
Member Avatar
Hi everyone, i need someone to help me. my code below will loop to fill the data .my problem now is i need to sum the total of the amount based on the region. How to get the amount based on region without enter the loop and only print out …
by programmerUSM in Programming ()
Member Avatar
hello guys i want to disconnect a mssql connection automaticaly whit a command
by mehran199107 in Databases ()
Member Avatar
Hello I have 2 databases, one is like a backup for the other. So they have identical tables: Alarmi, which has columns: OBJEKT, OPIS, VREDNOST, START, E_A, UPORABNIK I want to compare those two tables and copy only new entries (rows) to the backup database. How can I do that? …
by vedro in Databases ()
Member Avatar
Hi, I am trying to load data from mysql to angular JS. the data is huge. i.e. 50000 records.I have also set SQL_BIG_SELECTS=1 before join query execution. But i am getting following error while calling this query. Error: Internal Server Error.
by Devendra_4 in Databases ()
Member Avatar
Hi i am trying to execute .java file through php. please any one help.
by rpv_sen 59 in Programming ()
Member Avatar
Warning: mysqli_query() expects parameter 2 to be string, object given in E:\xampp\htdocs\cadastro\cadastrar.php on line 46 Alguem pode me ajudar? ...
by geysa in Programming ()
Member Avatar
i need to get record based on maximum created date any body help me date in mysql database structure is varchar. date is 150921141206 any body help me
by ramsiva in Databases ()
Member Avatar
I'm not looking for others to do my homework, I just want help with getting an idea one what to do. My class was given an assignment and one of the questions is: Create a query that will show the order id, item id, price, sales tax and subtotal for …
by ZombieKnight93 in Databases ()
Member Avatar
Hi I want to stop direct download of videos file from my webiste folder. Please help me. eg: ... If paste the URL in the browser. it should not download the file from the server.
by rpv_sen 59 in Web Development ()
Member Avatar
Hello, What are the different areas of databases I can focus on for my project? Thanks,
by Mohamed_26 in Databases ()
Member Avatar
How To connet mssql to php please please please help meeee. I'll wait for you guys to answer
by Faiz97 in Web Development ()
Member Avatar
I am writing a custom MembershipProvider for ASP.NET and would like to record certain events in a table when they happen. I have the methods to do it, but I would like to get the value of the "ID" column of the row I insert into the table. I have …
by zachattack05 56 in Software Development ()
Member Avatar
Hi Pls advice me the following calculation in stored Procedure my scenario is packing the magazine Example: Order = 6042 copies. 6042 have to be packed by 20 each. so 302 bundle. balance 2 copies. If I divide 6042 /20 Result is 302.10 . How can store 302 and 2 …
by Maideen in Databases ()
Member Avatar
Hii..this is mysql query ... i need to convert this into ** mysqli**. Any Help??
by shashigowda in Databases ()
Member Avatar
My c++ program using visual studio 2012 has one error that i cant figure out what. The error says " 1 IntelliSense: expected a ';' " I do believe that the eror from my program is after this part: ... THIS IS MY WHOLE PROGRAM ...
by Trisha_1 in Databases ()
Member Avatar
hello A newbie in database constuction, need help in adding automated sms functionality in mysql database. A user needs to sent a certain sms with certain keywords like 'location' to the system. the system refines a search according to the location content then sents back the data back to the …
by andrian.mutua.7 in Databases ()
Member Avatar
My current connection and echo code is as follwed: ...
by Jack_14 in Databases ()
Member Avatar
Hello to all! I am facing problems in feartures of sql sever 2008. I installed it but i could not find management studio in it. then i installed managemenet studio2008 separately. but when i opened management studio then there was no interface for making database but only interface was for …
by Saboor Siddique -3 in Databases ()
Member Avatar
I want to show the total qty of these query (total qty from datagridview where ActualQty value will update the values of Used Column) ... and (Total will appear in textbox) ...
by kayecng in Databases ()
Member Avatar
Hi.. I have a big problem, hope that you can help... I have windows 2003 server with CA brightstor 11.0 (Build 2670) and is making backup to all my SQL Servers. so I need to restore a database where the MDF file is 4 GB and the LDF file 111 …
by hollinar in Databases ()
Member Avatar
Can someone please help to advise below question? I need to do a SUM of the amount column based on the CreateDate date range From 10th of previous month to 10th of this month Below is the database table ... The SQL result need to display as per the table …
by strRusty_gal 14 in Databases ()
Member Avatar
Hello all, I have an MS SQL table. There are two columns I need to work on: HOURS_DURATION and MINUTES_DURATION. They are of INT type. As you may see in the photo I am attaching: ... Now, I am making a fast report. And for now I have a simple …
by azapovjednik 14 in Databases ()
Member Avatar
Hi I have firewall.log file in my c:\ driver I wonder what destination IP adresses and 6 ports the scanner have attacked most in the attack. SELECT DISTINCT dst-ip FROM c:\firewall.log WHERE dst-port
by tony75 10 in Databases ()
Member Avatar
Hi guys. I am looking for a software tools that can analyse data from several sources like databases: Oracle,Mysql,Access,MsSql e.t.c and draw graphs,dashboards or other data visualisation objects. The software should also be able to read excel sheet and analyse the data and give output in variuos graphs/pie charts. It …
by mwenyenia07 -4 in Databases ()
Member Avatar
In the work I came up against a situation when the working database at the end of day went to the Suspect Mode. And the archive was in many hours before. To transfer it in normal mode, until isn't made repaired base it was impossible. DBCC checkdb also refused to …
by alain.marion85 in Databases ()