Member Avatar
Hi everyone! So we have a web application that some of our clients use to manage their account. Part of that means they can manage activities that their registered employees do. Right now we have a table that logs all of a customer's employees activities, even if they don't use …
by zachattack05 56 in Databases ()
Member Avatar
Hi, I am new to SQL Server and what I am trying to do is convert my working SELECT Query to an UPDATE Query to update the data. I have looked for a tool or examples but cant find any information that can point me to the correct path. ... …
by lmalave in Databases ()
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 31 in Databases ()
Member Avatar
Hi all, I've been wrestling with CodeIgniter to work with MSSQL. Turned out to be a whole ordeal with changing the functions to use the newly updated sqlsrv functions. After all that, I still seem to have issues with it. While I'm working this out, I wonder if anyone has …
by RudyM 31 in Web Development ()
Member Avatar
Dear All , Hope everyone is fine. I have little question. We use this query normally in MSSQL select * from emp where empid in (1,2,3,4) How to write this query in lambda expression. Is there any way to perfrom above mentioned operation ? Best Regards
by M.Waqas Aslam 67 in Software Development ()
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
Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into interactive, …
by irisfrank in Databases ()
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 ()